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

Query Metrics

61 Database Queries
5 Different statements
9.55 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.24 ms
(86.30%)
57
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_lab ON t0.id = media_lab.media_id WHERE media_lab.lab_id = ?
Parameters:
[
  65
]
0.45 ms
(4.72%)
1
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.acronym AS acronym_2, l0_.description AS description_3, l0_.address AS address_4, l0_.translation AS translation_5, l0_.slug AS slug_6, l0_.status AS status_7, l0_.created_at AS created_at_8, l0_.website AS website_9, l0_.github AS github_10, l0_.gitlab AS gitlab_11, l0_.bitbucket AS bitbucket_12, l0_.logo AS logo_13, l0_.linked_in AS linked_in_14, l0_.twitter AS twitter_15, l0_.facebook AS facebook_16, l0_.instagram AS instagram_17, l0_.youtube AS youtube_18, l0_.research_gate AS research_gate_19, l0_.academia AS academia_20, l0_.review AS review_21 FROM lab l0_ WHERE l0_.status = 'a:1:{s:9:\"published\";i:1;}' ORDER BY l0_.acronym ASC
Parameters:
[]
0.34 ms
(3.60%)
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, l1_.id AS id_6, l1_.name AS name_7, l1_.acronym AS acronym_8, l1_.description AS description_9, l1_.address AS address_10, l1_.translation AS translation_11, l1_.slug AS slug_12, l1_.status AS status_13, l1_.created_at AS created_at_14, l1_.website AS website_15, l1_.github AS github_16, l1_.gitlab AS gitlab_17, l1_.bitbucket AS bitbucket_18, l1_.logo AS logo_19, l1_.linked_in AS linked_in_20, l1_.twitter AS twitter_21, l1_.facebook AS facebook_22, l1_.instagram AS instagram_23, l1_.youtube AS youtube_24, l1_.research_gate AS research_gate_25, l1_.academia AS academia_26, l1_.review AS review_27, d0_.parent_id AS parent_id_28, d0_.author_id AS author_id_29 FROM domain d0_ INNER JOIN lab_domain l2_ ON d0_.id = l2_.domain_id INNER JOIN lab l1_ ON l1_.id = l2_.lab_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND l1_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters:
[]
0.28 ms
(2.88%)
1
SELECT g0_.id AS id_0, g0_.continent AS continent_1, g0_.country AS country_2, g0_.region AS region_3, g0_.department AS department_4, g0_.city AS city_5, g0_.status AS status_6, g0_.created_at AS created_at_7, g0_.zip_code AS zip_code_8, g0_.address AS address_9, g0_.department_num AS department_num_10, l1_.id AS id_11, l1_.name AS name_12, l1_.acronym AS acronym_13, l1_.description AS description_14, l1_.address AS address_15, l1_.translation AS translation_16, l1_.slug AS slug_17, l1_.status AS status_18, l1_.created_at AS created_at_19, l1_.website AS website_20, l1_.github AS github_21, l1_.gitlab AS gitlab_22, l1_.bitbucket AS bitbucket_23, l1_.logo AS logo_24, l1_.linked_in AS linked_in_25, l1_.twitter AS twitter_26, l1_.facebook AS facebook_27, l1_.instagram AS instagram_28, l1_.youtube AS youtube_29, l1_.research_gate AS research_gate_30, l1_.academia AS academia_31, l1_.review AS review_32 FROM geolocation g0_ INNER JOIN lab_geolocation l2_ ON g0_.id = l2_.geolocation_id INNER JOIN lab l1_ ON l1_.id = l2_.lab_id
Parameters:
[]
0.24 ms
(2.49%)
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, l1_.id AS id_6, l1_.name AS name_7, l1_.acronym AS acronym_8, l1_.description AS description_9, l1_.address AS address_10, l1_.translation AS translation_11, l1_.slug AS slug_12, l1_.status AS status_13, l1_.created_at AS created_at_14, l1_.website AS website_15, l1_.github AS github_16, l1_.gitlab AS gitlab_17, l1_.bitbucket AS bitbucket_18, l1_.logo AS logo_19, l1_.linked_in AS linked_in_20, l1_.twitter AS twitter_21, l1_.facebook AS facebook_22, l1_.instagram AS instagram_23, l1_.youtube AS youtube_24, l1_.research_gate AS research_gate_25, l1_.academia AS academia_26, l1_.review AS review_27, d0_.parent_id AS parent_id_28, d0_.author_id AS author_id_29 FROM discipline d0_ INNER JOIN lab_discipline l2_ ON d0_.id = l2_.discipline_id INNER JOIN lab l1_ ON l1_.id = l2_.lab_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}' AND l1_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters:
[]

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\Domain No errors.
App\Entity\Lab 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\Software No errors.
App\Entity\Team No errors.
App\Entity\Institution No errors.
App\Entity\Training No errors.
App\Entity\Discipline No errors.
App\Entity\Skill No errors.
App\Entity\Comment No errors.
App\Entity\Media No errors.
App\Entity\Article No errors.
App\Entity\License No errors.
App\Entity\Page No errors.
App\Entity\Keyword No errors.
App\Entity\Tag No errors.
App\Entity\LabCopy No errors.
App\Entity\Geolocation No errors.