Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

1 Database Queries

1 Different statements

3.75 ms Query time

3 Invalid entities

Queries

Group similar statements

#▲

Time

Info

3.75 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.gender AS gender_5, t0.img AS img_6, t0.phone_number AS phone_number_7, t0.balance AS balance_8, t0.work_experience AS work_experience_9, t0.self AS self_10, t0.role AS role_11, t0.token AS token_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.push_token AS push_token_15, t0.work_imgs AS work_imgs_16, t0.city_name AS city_name_17, t0.register_date AS register_date_18, t0.ban_text AS ban_text_19, t0.b AS b_20, t0.city_id AS city_id_21, t0.lang_id AS lang_id_22 FROM user t0 WHERE t0.token = ? LIMIT 1

Parameters:

[
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.surname AS surname_3,
  t0.birthday AS birthday_4,
  t0.gender AS gender_5,
  t0.img AS img_6,
  t0.phone_number AS phone_number_7,
  t0.balance AS balance_8,
  t0.work_experience AS work_experience_9,
  t0.self AS self_10,
  t0.role AS role_11,
  t0.token AS token_12,
  t0.latitude AS latitude_13,
  t0.longitude AS longitude_14,
  t0.push_token AS push_token_15,
  t0.work_imgs AS work_imgs_16,
  t0.city_name AS city_name_17,
  t0.register_date AS register_date_18,
  t0.ban_text AS ban_text_19,
  t0.b AS b_20,
  t0.city_id AS city_id_21,
  t0.lang_id AS lang_id_22
FROM
  user t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.birthday AS birthday_4, t0.gender AS gender_5, t0.img AS img_6, t0.phone_number AS phone_number_7, t0.balance AS balance_8, t0.work_experience AS work_experience_9, t0.self AS self_10, t0.role AS role_11, t0.token AS token_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.push_token AS push_token_15, t0.work_imgs AS work_imgs_16, t0.city_name AS city_name_17, t0.register_date AS register_date_18, t0.ban_text AS ban_text_19, t0.b AS b_20, t0.city_id AS city_id_21, t0.lang_id AS lang_id_22 FROM user t0 WHERE t0.token = '' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 129)
5	App\Controller\MessageController->checkReady (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 4)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\User	The association App\Entity\User#city refers to the inverse side field App\Entity\City#users which does not exist.
App\Entity\City	The mappings App\Entity\City#Users and App\Entity\User#city are inconsistent with each other. The field App\Entity\City#cities is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\City#lang does not contain the required 'inversedBy="cities"' attribute.
App\Entity\Lang	The mappings App\Entity\Lang#fAQTranslates and App\Entity\FAQTranslate#lang are inconsistent with each other.

Symfony Profiler

GET https://master.tajsoft.tj/api/message/check

Configuration Settings

Theme