Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

401.99 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
401.99 ms (100.00%)	1	SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.surname AS surname_2, l0_.last_name AS last_name_3, l0_.phone AS phone_4, l0_.email AS email_5, l0_.snils AS snils_6, l0_.birthday AS birthday_7, l0_.position AS position_8, l0_.place AS place_9, l0_.date_create AS date_create_10, l0_.moodle_user_id AS moodle_user_id_11, l0_.moodle_mail AS moodle_mail_12, l0_.login AS login_13, l0_.password AS password_14, l0_.amocrm_id AS amocrm_id_15 FROM learners l0_ WHERE l0_.login LIKE ? Parameters: [`"%us40202936_1%"`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.surname AS surname_2, l0_.last_name AS last_name_3, l0_.phone AS phone_4, l0_.email AS email_5, l0_.snils AS snils_6, l0_.birthday AS birthday_7, l0_.position AS position_8, l0_.place AS place_9, l0_.date_create AS date_create_10, l0_.moodle_user_id AS moodle_user_id_11, l0_.moodle_mail AS moodle_mail_12, l0_.login AS login_13, l0_.password AS password_14, l0_.amocrm_id AS amocrm_id_15 FROM learners l0_ WHERE l0_.login LIKE ? SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.surname AS surname_2, l0_.last_name AS last_name_3, l0_.phone AS phone_4, l0_.email AS email_5, l0_.snils AS snils_6, l0_.birthday AS birthday_7, l0_.position AS position_8, l0_.place AS place_9, l0_.date_create AS date_create_10, l0_.moodle_user_id AS moodle_user_id_11, l0_.moodle_mail AS moodle_mail_12, l0_.login AS login_13, l0_.password AS password_14, l0_.amocrm_id AS amocrm_id_15 FROM learners l0_ WHERE l0_.login LIKE '%us40202936_1%';

Time▼

Count

Info

401.99 ms
(100.00%)

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.surname AS surname_2, l0_.last_name AS last_name_3, l0_.phone AS phone_4, l0_.email AS email_5, l0_.snils AS snils_6, l0_.birthday AS birthday_7, l0_.position AS position_8, l0_.place AS place_9, l0_.date_create AS date_create_10, l0_.moodle_user_id AS moodle_user_id_11, l0_.moodle_mail AS moodle_mail_12, l0_.login AS login_13, l0_.password AS password_14, l0_.amocrm_id AS amocrm_id_15 FROM learners l0_ WHERE l0_.login LIKE ?

Parameters:

[
  "%us40202936_1%"
]

View formatted query View runnable query Explain query

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.surname AS surname_2,
  l0_.last_name AS last_name_3,
  l0_.phone AS phone_4,
  l0_.email AS email_5,
  l0_.snils AS snils_6,
  l0_.birthday AS birthday_7,
  l0_.position AS position_8,
  l0_.place AS place_9,
  l0_.date_create AS date_create_10,
  l0_.moodle_user_id AS moodle_user_id_11,
  l0_.moodle_mail AS moodle_mail_12,
  l0_.login AS login_13,
  l0_.password AS password_14,
  l0_.amocrm_id AS amocrm_id_15
FROM
  learners l0_
WHERE
  l0_.login LIKE ?

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.surname AS surname_2, l0_.last_name AS last_name_3, l0_.phone AS phone_4, l0_.email AS email_5, l0_.snils AS snils_6, l0_.birthday AS birthday_7, l0_.position AS position_8, l0_.place AS place_9, l0_.date_create AS date_create_10, l0_.moodle_user_id AS moodle_user_id_11, l0_.moodle_mail AS moodle_mail_12, l0_.login AS login_13, l0_.password AS password_14, l0_.amocrm_id AS amocrm_id_15 FROM learners l0_ WHERE l0_.login LIKE '%us40202936_1%';

Database Connections

Name	Service
default	doctrine.dbal.default_connection
courses	doctrine.dbal.courses_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
courses	doctrine.orm.courses_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Learners	No errors.

courses entity manager

No loaded entities.