Query Metrics
10
Database Queries
6
Different statements
5.76 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.64 ms |
SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7, t0.meta_title_en AS meta_title_en_8, t0.meta_description_en AS meta_description_en_9, t0.h1_en AS h1_en_10 FROM seopage t0 WHERE t0.route = ? LIMIT 1
Parameters:
[
"front_application"
]
|
||||||||||||||||||||||||||||||
| 2 | 0.36 ms |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 3 | 0.43 ms |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5, t0.image_updated_at AS image_updated_at_6, t0.image_alt_fr AS image_alt_fr_7, t0.image_alt_en AS image_alt_en_8, t0.logo_name AS logo_name_9, t0.logo_size AS logo_size_10, t0.logo_updated_at AS logo_updated_at_11, t0.logo_alt_fr AS logo_alt_fr_12, t0.logo_alt_en AS logo_alt_en_13, t0.intro_fr AS intro_fr_14, t0.intro_en AS intro_en_15, t0.content_fr AS content_fr_16, t0.content_en AS content_en_17, t0.slug_en AS slug_en_18, t0.h1 AS h1_19, t0.h1_en AS h1_en_20, t0.meta_title_en AS meta_title_en_21, t0.meta_description_en AS meta_description_en_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25, t0.position AS position_26 FROM application t0 WHERE t0.slug_en = ? LIMIT 1
Parameters:
[
"spatial"
]
|
||||||||||||||||||||||||||||||
| 4 | 0.51 ms |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5, t0.image_updated_at AS image_updated_at_6, t0.image_alt_fr AS image_alt_fr_7, t0.image_alt_en AS image_alt_en_8, t0.logo_name AS logo_name_9, t0.logo_size AS logo_size_10, t0.logo_updated_at AS logo_updated_at_11, t0.logo_alt_fr AS logo_alt_fr_12, t0.logo_alt_en AS logo_alt_en_13, t0.intro_fr AS intro_fr_14, t0.intro_en AS intro_en_15, t0.content_fr AS content_fr_16, t0.content_en AS content_en_17, t0.slug_en AS slug_en_18, t0.h1 AS h1_19, t0.h1_en AS h1_en_20, t0.meta_title_en AS meta_title_en_21, t0.meta_description_en AS meta_description_en_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25, t0.position AS position_26 FROM application t0 ORDER BY t0.position ASC
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 5 | 0.46 ms |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5, t0.image_updated_at AS image_updated_at_6, t0.image_alt_fr AS image_alt_fr_7, t0.image_alt_en AS image_alt_en_8, t0.logo_name AS logo_name_9, t0.logo_size AS logo_size_10, t0.logo_updated_at AS logo_updated_at_11, t0.logo_alt_fr AS logo_alt_fr_12, t0.logo_alt_en AS logo_alt_en_13, t0.intro_fr AS intro_fr_14, t0.intro_en AS intro_en_15, t0.content_fr AS content_fr_16, t0.content_en AS content_en_17, t0.slug_en AS slug_en_18, t0.h1 AS h1_19, t0.h1_en AS h1_en_20, t0.meta_title_en AS meta_title_en_21, t0.meta_description_en AS meta_description_en_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25, t0.position AS position_26 FROM application t0 ORDER BY t0.position ASC
Parameters:
[] |
||||||||||||||||||||||||||||||
| 6 | 0.52 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt_fr AS image_alt_fr_5, t0.image_alt_en AS image_alt_en_6, t0.title_fr AS title_fr_7, t0.title_en AS title_en_8, t0.intro_fr AS intro_fr_9, t0.intro_en AS intro_en_10, t0.content_fr AS content_fr_11, t0.content_en AS content_en_12, t0.documentation_intro_fr AS documentation_intro_fr_13, t0.documentation_intro_en AS documentation_intro_en_14, t0.slug_en AS slug_en_15, t0.h1 AS h1_16, t0.h1_en AS h1_en_17, t0.meta_title_en AS meta_title_en_18, t0.meta_description_en AS meta_description_en_19, t0.meta_title AS meta_title_20, t0.meta_description AS meta_description_21, t0.slug AS slug_22, t0.position AS position_23 FROM product t0 ORDER BY t0.position ASC
Parameters:
[] |
||||||||||||||||||||||||||||||
| 7 | 0.94 ms |
SELECT a0_.id AS id_0, a0_.detail AS detail_1, a0_.image_name AS image_name_2, a0_.image_size AS image_size_3, a0_.image_updated_at AS image_updated_at_4, a0_.image_alt_fr AS image_alt_fr_5, a0_.image_alt_en AS image_alt_en_6, a0_.title_fr AS title_fr_7, a0_.title_en AS title_en_8, a0_.intro_fr AS intro_fr_9, a0_.intro_en AS intro_en_10, a0_.description_fr AS description_fr_11, a0_.description_en AS description_en_12, a0_.slug_en AS slug_en_13, a0_.h1 AS h1_14, a0_.h1_en AS h1_en_15, a0_.meta_title_en AS meta_title_en_16, a0_.meta_description_en AS meta_description_en_17, a0_.meta_title AS meta_title_18, a0_.meta_description AS meta_description_19, a0_.slug AS slug_20, a0_.position AS position_21 FROM achievement a0_ LEFT JOIN achievement_application a2_ ON a0_.id = a2_.achievement_id LEFT JOIN application a1_ ON a1_.id = a2_.application_id WHERE a0_.id IS NOT NULL AND a1_.id = ? ORDER BY a0_.position ASC
Parameters:
[
5
]
|
||||||||||||||||||||||||||||||
| 8 | 0.81 ms |
SELECT a0_.id AS id_0, a0_.detail AS detail_1, a0_.image_name AS image_name_2, a0_.image_size AS image_size_3, a0_.image_updated_at AS image_updated_at_4, a0_.image_alt_fr AS image_alt_fr_5, a0_.image_alt_en AS image_alt_en_6, a0_.title_fr AS title_fr_7, a0_.title_en AS title_en_8, a0_.intro_fr AS intro_fr_9, a0_.intro_en AS intro_en_10, a0_.description_fr AS description_fr_11, a0_.description_en AS description_en_12, a0_.slug_en AS slug_en_13, a0_.h1 AS h1_14, a0_.h1_en AS h1_en_15, a0_.meta_title_en AS meta_title_en_16, a0_.meta_description_en AS meta_description_en_17, a0_.meta_title AS meta_title_18, a0_.meta_description AS meta_description_19, a0_.slug AS slug_20, a0_.position AS position_21 FROM achievement a0_ LEFT JOIN achievement_application a2_ ON a0_.id = a2_.achievement_id LEFT JOIN application a1_ ON a1_.id = a2_.application_id WHERE a0_.id IS NOT NULL AND a1_.id = ? ORDER BY a0_.position ASC
Parameters:
[
5
]
|
||||||||||||||||||||||||||||||
| 9 | 0.55 ms |
SELECT t0.id AS id_1, t0.title_fr AS title_fr_2, t0.title_en AS title_en_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5, t0.image_updated_at AS image_updated_at_6, t0.image_alt_fr AS image_alt_fr_7, t0.image_alt_en AS image_alt_en_8, t0.logo_name AS logo_name_9, t0.logo_size AS logo_size_10, t0.logo_updated_at AS logo_updated_at_11, t0.logo_alt_fr AS logo_alt_fr_12, t0.logo_alt_en AS logo_alt_en_13, t0.intro_fr AS intro_fr_14, t0.intro_en AS intro_en_15, t0.content_fr AS content_fr_16, t0.content_en AS content_en_17, t0.slug_en AS slug_en_18, t0.h1 AS h1_19, t0.h1_en AS h1_en_20, t0.meta_title_en AS meta_title_en_21, t0.meta_description_en AS meta_description_en_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25, t0.position AS position_26 FROM application t0 ORDER BY t0.position ASC
Parameters:
[] |
||||||||||||||||||||||||||||||
| 10 | 0.54 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt_fr AS image_alt_fr_5, t0.image_alt_en AS image_alt_en_6, t0.title_fr AS title_fr_7, t0.title_en AS title_en_8, t0.intro_fr AS intro_fr_9, t0.intro_en AS intro_en_10, t0.content_fr AS content_fr_11, t0.content_en AS content_en_12, t0.documentation_intro_fr AS documentation_intro_fr_13, t0.documentation_intro_en AS documentation_intro_en_14, t0.slug_en AS slug_en_15, t0.h1 AS h1_16, t0.h1_en AS h1_en_17, t0.meta_title_en AS meta_title_en_18, t0.meta_description_en AS meta_description_en_19, t0.meta_title AS meta_title_20, t0.meta_description AS meta_description_21, t0.slug AS slug_22, t0.position AS position_23 FROM product t0 ORDER BY t0.position ASC
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 |
|---|---|
| Cofondateur\SocleTechniqueBundle\Entity\SEOPage | No errors. |
| App\Entity\SEOPage | No errors. |
| Cofondateur\SocleTechniqueBundle\Entity\SiteSettings | No errors. |
| App\Entity\SiteSettings | No errors. |
| App\Entity\Application | No errors. |
| App\Entity\Achievement | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Documentation |
|
| App\Entity\DownloadProduct | No errors. |