Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.02 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.92 ms	SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.training_plan AS training_plan_3, t0_.certification AS certification_4, t0_.duration AS duration_5, t0_.start_date AS start_date_6, t0_.end_date AS end_date_7, t0_.price AS price_8, t0_.translation AS translation_9, t0_.slug AS slug_10, t0_.status AS status_11, t0_.created_at AS created_at_12, t0_.prerequisites AS prerequisites_13, t0_.knowledge AS knowledge_14, t0_.related_courses AS related_courses_15, t0_.logo AS logo_16, t0_.teachers AS teachers_17, t0_.geolocation_id AS geolocation_id_18 FROM training t0_ WHERE t0_.status = 'a:1:{s:9:\"published\";i:1;}' ORDER BY t0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.training_plan AS training_plan_3, t0_.certification AS certification_4, t0_.duration AS duration_5, t0_.start_date AS start_date_6, t0_.end_date AS end_date_7, t0_.price AS price_8, t0_.translation AS translation_9, t0_.slug AS slug_10, t0_.status AS status_11, t0_.created_at AS created_at_12, t0_.prerequisites AS prerequisites_13, t0_.knowledge AS knowledge_14, t0_.related_courses AS related_courses_15, t0_.logo AS logo_16, t0_.teachers AS teachers_17, t0_.geolocation_id AS geolocation_id_18 FROM training t0_ WHERE t0_.status = 'a:1:{s:9:\"published\";i:1;}' ORDER BY t0_.name ASC SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.training_plan AS training_plan_3, t0_.certification AS certification_4, t0_.duration AS duration_5, t0_.start_date AS start_date_6, t0_.end_date AS end_date_7, t0_.price AS price_8, t0_.translation AS translation_9, t0_.slug AS slug_10, t0_.status AS status_11, t0_.created_at AS created_at_12, t0_.prerequisites AS prerequisites_13, t0_.knowledge AS knowledge_14, t0_.related_courses AS related_courses_15, t0_.logo AS logo_16, t0_.teachers AS teachers_17, t0_.geolocation_id AS geolocation_id_18 FROM training t0_ WHERE t0_.status = 'a:1:{s:9:\"published\";i:1;}' ORDER BY t0_.name ASC;
2	0.58 ms	SELECT d0_.id AS id_0, d0_.domain AS domain_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, t1_.id AS id_6, t1_.name AS name_7, t1_.description AS description_8, t1_.training_plan AS training_plan_9, t1_.certification AS certification_10, t1_.duration AS duration_11, t1_.start_date AS start_date_12, t1_.end_date AS end_date_13, t1_.price AS price_14, t1_.translation AS translation_15, t1_.slug AS slug_16, t1_.status AS status_17, t1_.created_at AS created_at_18, t1_.prerequisites AS prerequisites_19, t1_.knowledge AS knowledge_20, t1_.related_courses AS related_courses_21, t1_.logo AS logo_22, t1_.teachers AS teachers_23, d0_.parent_id AS parent_id_24, d0_.author_id AS author_id_25, t1_.geolocation_id AS geolocation_id_26 FROM domain d0_ INNER JOIN training_domain t2_ ON d0_.id = t2_.domain_id INNER JOIN training t1_ ON t1_.id = t2_.training_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}' Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.domain AS domain_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, t1_.id AS id_6, t1_.name AS name_7, t1_.description AS description_8, t1_.training_plan AS training_plan_9, t1_.certification AS certification_10, t1_.duration AS duration_11, t1_.start_date AS start_date_12, t1_.end_date AS end_date_13, t1_.price AS price_14, t1_.translation AS translation_15, t1_.slug AS slug_16, t1_.status AS status_17, t1_.created_at AS created_at_18, t1_.prerequisites AS prerequisites_19, t1_.knowledge AS knowledge_20, t1_.related_courses AS related_courses_21, t1_.logo AS logo_22, t1_.teachers AS teachers_23, d0_.parent_id AS parent_id_24, d0_.author_id AS author_id_25, t1_.geolocation_id AS geolocation_id_26 FROM domain d0_ INNER JOIN training_domain t2_ ON d0_.id = t2_.domain_id INNER JOIN training t1_ ON t1_.id = t2_.training_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}' SELECT d0_.id AS id_0, d0_.domain AS domain_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, t1_.id AS id_6, t1_.name AS name_7, t1_.description AS description_8, t1_.training_plan AS training_plan_9, t1_.certification AS certification_10, t1_.duration AS duration_11, t1_.start_date AS start_date_12, t1_.end_date AS end_date_13, t1_.price AS price_14, t1_.translation AS translation_15, t1_.slug AS slug_16, t1_.status AS status_17, t1_.created_at AS created_at_18, t1_.prerequisites AS prerequisites_19, t1_.knowledge AS knowledge_20, t1_.related_courses AS related_courses_21, t1_.logo AS logo_22, t1_.teachers AS teachers_23, d0_.parent_id AS parent_id_24, d0_.author_id AS author_id_25, t1_.geolocation_id AS geolocation_id_26 FROM domain d0_ INNER JOIN training_domain t2_ ON d0_.id = t2_.domain_id INNER JOIN training t1_ ON t1_.id = t2_.training_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}';
3	0.53 ms	SELECT d0_.id AS id_0, d0_.discipline AS discipline_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, t1_.id AS id_6, t1_.name AS name_7, t1_.description AS description_8, t1_.training_plan AS training_plan_9, t1_.certification AS certification_10, t1_.duration AS duration_11, t1_.start_date AS start_date_12, t1_.end_date AS end_date_13, t1_.price AS price_14, t1_.translation AS translation_15, t1_.slug AS slug_16, t1_.status AS status_17, t1_.created_at AS created_at_18, t1_.prerequisites AS prerequisites_19, t1_.knowledge AS knowledge_20, t1_.related_courses AS related_courses_21, t1_.logo AS logo_22, t1_.teachers AS teachers_23, d0_.parent_id AS parent_id_24, d0_.author_id AS author_id_25, t1_.geolocation_id AS geolocation_id_26 FROM discipline d0_ INNER JOIN training_discipline t2_ ON d0_.id = t2_.discipline_id INNER JOIN training t1_ ON t1_.id = t2_.training_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}' Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.discipline AS discipline_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, t1_.id AS id_6, t1_.name AS name_7, t1_.description AS description_8, t1_.training_plan AS training_plan_9, t1_.certification AS certification_10, t1_.duration AS duration_11, t1_.start_date AS start_date_12, t1_.end_date AS end_date_13, t1_.price AS price_14, t1_.translation AS translation_15, t1_.slug AS slug_16, t1_.status AS status_17, t1_.created_at AS created_at_18, t1_.prerequisites AS prerequisites_19, t1_.knowledge AS knowledge_20, t1_.related_courses AS related_courses_21, t1_.logo AS logo_22, t1_.teachers AS teachers_23, d0_.parent_id AS parent_id_24, d0_.author_id AS author_id_25, t1_.geolocation_id AS geolocation_id_26 FROM discipline d0_ INNER JOIN training_discipline t2_ ON d0_.id = t2_.discipline_id INNER JOIN training t1_ ON t1_.id = t2_.training_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}' SELECT d0_.id AS id_0, d0_.discipline AS discipline_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, t1_.id AS id_6, t1_.name AS name_7, t1_.description AS description_8, t1_.training_plan AS training_plan_9, t1_.certification AS certification_10, t1_.duration AS duration_11, t1_.start_date AS start_date_12, t1_.end_date AS end_date_13, t1_.price AS price_14, t1_.translation AS translation_15, t1_.slug AS slug_16, t1_.status AS status_17, t1_.created_at AS created_at_18, t1_.prerequisites AS prerequisites_19, t1_.knowledge AS knowledge_20, t1_.related_courses AS related_courses_21, t1_.logo AS logo_22, t1_.teachers AS teachers_23, d0_.parent_id AS parent_id_24, d0_.author_id AS author_id_25, t1_.geolocation_id AS geolocation_id_26 FROM discipline d0_ INNER JOIN training_discipline t2_ ON d0_.id = t2_.discipline_id INNER JOIN training t1_ ON t1_.id = t2_.training_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}';

#▲

Time

Info

0.92 ms

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.training_plan AS training_plan_3, t0_.certification AS certification_4, t0_.duration AS duration_5, t0_.start_date AS start_date_6, t0_.end_date AS end_date_7, t0_.price AS price_8, t0_.translation AS translation_9, t0_.slug AS slug_10, t0_.status AS status_11, t0_.created_at AS created_at_12, t0_.prerequisites AS prerequisites_13, t0_.knowledge AS knowledge_14, t0_.related_courses AS related_courses_15, t0_.logo AS logo_16, t0_.teachers AS teachers_17, t0_.geolocation_id AS geolocation_id_18 FROM training t0_ WHERE t0_.status = 'a:1:{s:9:\"published\";i:1;}' ORDER BY t0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.description AS description_2,
  t0_.training_plan AS training_plan_3,
  t0_.certification AS certification_4,
  t0_.duration AS duration_5,
  t0_.start_date AS start_date_6,
  t0_.end_date AS end_date_7,
  t0_.price AS price_8,
  t0_.translation AS translation_9,
  t0_.slug AS slug_10,
  t0_.status AS status_11,
  t0_.created_at AS created_at_12,
  t0_.prerequisites AS prerequisites_13,
  t0_.knowledge AS knowledge_14,
  t0_.related_courses AS related_courses_15,
  t0_.logo AS logo_16,
  t0_.teachers AS teachers_17,
  t0_.geolocation_id AS geolocation_id_18
FROM
  training t0_
WHERE
  t0_.status = 'a:1:{s:9:\"published\";i:1;}'
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.training_plan AS training_plan_3, t0_.certification AS certification_4, t0_.duration AS duration_5, t0_.start_date AS start_date_6, t0_.end_date AS end_date_7, t0_.price AS price_8, t0_.translation AS translation_9, t0_.slug AS slug_10, t0_.status AS status_11, t0_.created_at AS created_at_12, t0_.prerequisites AS prerequisites_13, t0_.knowledge AS knowledge_14, t0_.related_courses AS related_courses_15, t0_.logo AS logo_16, t0_.teachers AS teachers_17, t0_.geolocation_id AS geolocation_id_18 FROM training t0_ WHERE t0_.status = 'a:1:{s:9:\"published\";i:1;}' ORDER BY t0_.name ASC;

0.58 ms

SELECT d0_.id AS id_0, d0_.domain AS domain_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, t1_.id AS id_6, t1_.name AS name_7, t1_.description AS description_8, t1_.training_plan AS training_plan_9, t1_.certification AS certification_10, t1_.duration AS duration_11, t1_.start_date AS start_date_12, t1_.end_date AS end_date_13, t1_.price AS price_14, t1_.translation AS translation_15, t1_.slug AS slug_16, t1_.status AS status_17, t1_.created_at AS created_at_18, t1_.prerequisites AS prerequisites_19, t1_.knowledge AS knowledge_20, t1_.related_courses AS related_courses_21, t1_.logo AS logo_22, t1_.teachers AS teachers_23, d0_.parent_id AS parent_id_24, d0_.author_id AS author_id_25, t1_.geolocation_id AS geolocation_id_26 FROM domain d0_ INNER JOIN training_domain t2_ ON d0_.id = t2_.domain_id INNER JOIN training t1_ ON t1_.id = t2_.training_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}'

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  d0_.id AS id_0,
  d0_.domain AS domain_1,
  d0_.status AS status_2,
  d0_.created_at AS created_at_3,
  d0_.review AS review_4,
  d0_.slug AS slug_5,
  t1_.id AS id_6,
  t1_.name AS name_7,
  t1_.description AS description_8,
  t1_.training_plan AS training_plan_9,
  t1_.certification AS certification_10,
  t1_.duration AS duration_11,
  t1_.start_date AS start_date_12,
  t1_.end_date AS end_date_13,
  t1_.price AS price_14,
  t1_.translation AS translation_15,
  t1_.slug AS slug_16,
  t1_.status AS status_17,
  t1_.created_at AS created_at_18,
  t1_.prerequisites AS prerequisites_19,
  t1_.knowledge AS knowledge_20,
  t1_.related_courses AS related_courses_21,
  t1_.logo AS logo_22,
  t1_.teachers AS teachers_23,
  d0_.parent_id AS parent_id_24,
  d0_.author_id AS author_id_25,
  t1_.geolocation_id AS geolocation_id_26
FROM
  domain d0_
  INNER JOIN training_domain t2_ ON d0_.id = t2_.domain_id
  INNER JOIN training t1_ ON t1_.id = t2_.training_id
WHERE
  d0_.status = 'a:1:{s:9:\"published\";i:1;}'
  AND t1_.status = 'a:1:{s:9:\"published\";i:1;}'

SELECT d0_.id AS id_0, d0_.domain AS domain_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, t1_.id AS id_6, t1_.name AS name_7, t1_.description AS description_8, t1_.training_plan AS training_plan_9, t1_.certification AS certification_10, t1_.duration AS duration_11, t1_.start_date AS start_date_12, t1_.end_date AS end_date_13, t1_.price AS price_14, t1_.translation AS translation_15, t1_.slug AS slug_16, t1_.status AS status_17, t1_.created_at AS created_at_18, t1_.prerequisites AS prerequisites_19, t1_.knowledge AS knowledge_20, t1_.related_courses AS related_courses_21, t1_.logo AS logo_22, t1_.teachers AS teachers_23, d0_.parent_id AS parent_id_24, d0_.author_id AS author_id_25, t1_.geolocation_id AS geolocation_id_26 FROM domain d0_ INNER JOIN training_domain t2_ ON d0_.id = t2_.domain_id INNER JOIN training t1_ ON t1_.id = t2_.training_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}';

0.53 ms

SELECT d0_.id AS id_0, d0_.discipline AS discipline_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, t1_.id AS id_6, t1_.name AS name_7, t1_.description AS description_8, t1_.training_plan AS training_plan_9, t1_.certification AS certification_10, t1_.duration AS duration_11, t1_.start_date AS start_date_12, t1_.end_date AS end_date_13, t1_.price AS price_14, t1_.translation AS translation_15, t1_.slug AS slug_16, t1_.status AS status_17, t1_.created_at AS created_at_18, t1_.prerequisites AS prerequisites_19, t1_.knowledge AS knowledge_20, t1_.related_courses AS related_courses_21, t1_.logo AS logo_22, t1_.teachers AS teachers_23, d0_.parent_id AS parent_id_24, d0_.author_id AS author_id_25, t1_.geolocation_id AS geolocation_id_26 FROM discipline d0_ INNER JOIN training_discipline t2_ ON d0_.id = t2_.discipline_id INNER JOIN training t1_ ON t1_.id = t2_.training_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}'

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  d0_.id AS id_0,
  d0_.discipline AS discipline_1,
  d0_.status AS status_2,
  d0_.created_at AS created_at_3,
  d0_.review AS review_4,
  d0_.slug AS slug_5,
  t1_.id AS id_6,
  t1_.name AS name_7,
  t1_.description AS description_8,
  t1_.training_plan AS training_plan_9,
  t1_.certification AS certification_10,
  t1_.duration AS duration_11,
  t1_.start_date AS start_date_12,
  t1_.end_date AS end_date_13,
  t1_.price AS price_14,
  t1_.translation AS translation_15,
  t1_.slug AS slug_16,
  t1_.status AS status_17,
  t1_.created_at AS created_at_18,
  t1_.prerequisites AS prerequisites_19,
  t1_.knowledge AS knowledge_20,
  t1_.related_courses AS related_courses_21,
  t1_.logo AS logo_22,
  t1_.teachers AS teachers_23,
  d0_.parent_id AS parent_id_24,
  d0_.author_id AS author_id_25,
  t1_.geolocation_id AS geolocation_id_26
FROM
  discipline d0_
  INNER JOIN training_discipline t2_ ON d0_.id = t2_.discipline_id
  INNER JOIN training t1_ ON t1_.id = t2_.training_id
WHERE
  d0_.status = 'a:1:{s:9:\"published\";i:1;}'
  AND t1_.status = 'a:1:{s:9:\"published\";i:1;}'

SELECT d0_.id AS id_0, d0_.discipline AS discipline_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, t1_.id AS id_6, t1_.name AS name_7, t1_.description AS description_8, t1_.training_plan AS training_plan_9, t1_.certification AS certification_10, t1_.duration AS duration_11, t1_.start_date AS start_date_12, t1_.end_date AS end_date_13, t1_.price AS price_14, t1_.translation AS translation_15, t1_.slug AS slug_16, t1_.status AS status_17, t1_.created_at AS created_at_18, t1_.prerequisites AS prerequisites_19, t1_.knowledge AS knowledge_20, t1_.related_courses AS related_courses_21, t1_.logo AS logo_22, t1_.teachers AS teachers_23, d0_.parent_id AS parent_id_24, d0_.author_id AS author_id_25, t1_.geolocation_id AS geolocation_id_26 FROM discipline d0_ INNER JOIN training_discipline t2_ ON d0_.id = t2_.discipline_id INNER JOIN training t1_ ON t1_.id = t2_.training_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND t1_.status = 'a:1:{s:9:\"published\";i:1;}';

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\Training	No errors.
App\Entity\Geolocation	No errors.
App\Entity\User	The association App\Entity\User#calendars refers to the owning side field App\Entity\Calendar#user which does not exist. The association App\Entity\User#events refers to the owning side field App\Entity\Calendar#users which does not exist. The mappings App\Entity\User#owners and App\Entity\Calendar#owners are inconsistent with each other. The mappings App\Entity\User#participants and App\Entity\Calendar#participants are inconsistent with each other.
App\Entity\Discipline	No errors.
App\Entity\Domain	No errors.
App\Entity\Comment	No errors.
App\Entity\Media	No errors.
App\Entity\TrainingCopy	No errors.

Symfony Profiler

GET https://preprod.postlab.fr/cartographie/formations

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping