Query Metrics
15
Database Queries
12
Different statements
2.64 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.33 ms |
SELECT t0.route AS route_1, t0.id AS id_2, t0.page_name AS page_name_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 FROM seopage t0 WHERE t0.route = ? LIMIT 1
Parameters:
[
"app_homepage"
]
|
| 2 | 0.18 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.26 ms |
SELECT t0.id AS id_1, t0.cover_name AS cover_name_2, t0.cover_size AS cover_size_3, t0.cover_updated_at AS cover_updated_at_4, t0.cover_alt AS cover_alt_5, t0.title AS title_6, t0.resume AS resume_7, t0.date AS date_8, t0.published AS published_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.quote_cover_name AS quote_cover_name_12, t0.quote_cover_size AS quote_cover_size_13, t0.quote_cover_updated_at AS quote_cover_updated_at_14, t0.quote_cover_alt AS quote_cover_alt_15, t0.quote AS quote_16, t0.quote_author AS quote_author_17, t0.slug AS slug_18, t0.category_id AS category_id_19 FROM actuality t0 WHERE t0.published = ? ORDER BY t0.date DESC LIMIT 3
Parameters:
[
"1"
]
|
| 4 | 0.15 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.firstname AS firstname_3, t0.name AS name_4, t0.testimony AS testimony_5, t0.role AS role_6, t0.published AS published_7, t0.date AS date_8, t0.email AS email_9, t0.homepage_id AS homepage_id_10 FROM testimony t0 LIMIT 3
Parameters:
[] |
| 5 | 0.16 ms |
SELECT t0.id AS id_1, t0.about_sub_title AS about_sub_title_2, t0.about_title AS about_title_3, t0.about_description AS about_description_4, t0.about_little_image_name AS about_little_image_name_5, t0.about_little_image_size AS about_little_image_size_6, t0.about_little_image_updated_at AS about_little_image_updated_at_7, t0.about_little_image_alt AS about_little_image_alt_8, t0.about_big_image_name AS about_big_image_name_9, t0.about_big_image_size AS about_big_image_size_10, t0.about_big_image_updated_at AS about_big_image_updated_at_11, t0.about_big_image_alt AS about_big_image_alt_12, t0.maritime_resume AS maritime_resume_13, t0.fluvial_resume AS fluvial_resume_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.quote_cover_name AS quote_cover_name_17, t0.quote_cover_size AS quote_cover_size_18, t0.quote_cover_updated_at AS quote_cover_updated_at_19, t0.quote_cover_alt AS quote_cover_alt_20, t0.quote AS quote_21, t0.quote_author AS quote_author_22 FROM homepage t0
Parameters:
[] |
| 6 | 0.17 ms |
SELECT t0.id AS id_1, t0.cover_name AS cover_name_2, t0.cover_size AS cover_size_3, t0.cover_updated_at AS cover_updated_at_4, t0.cover_alt AS cover_alt_5, t0.name AS name_6, t0.title AS title_7, t0.intro_sub_title AS intro_sub_title_8, t0.intro_title AS intro_title_9, t0.intro_paragraph AS intro_paragraph_10, t0.offer_sub_title AS offer_sub_title_11, t0.offer_title AS offer_title_12, t0.offer_paragraph AS offer_paragraph_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16, t0.quote_cover_name AS quote_cover_name_17, t0.quote_cover_size AS quote_cover_size_18, t0.quote_cover_updated_at AS quote_cover_updated_at_19, t0.quote_cover_alt AS quote_cover_alt_20, t0.quote AS quote_21, t0.quote_author AS quote_author_22 FROM maritime_category t0
Parameters:
[] |
| 7 | 0.15 ms |
SELECT t0.id AS id_1, t0.cover_name AS cover_name_2, t0.cover_size AS cover_size_3, t0.cover_updated_at AS cover_updated_at_4, t0.cover_alt AS cover_alt_5, t0.name AS name_6, t0.title AS title_7, t0.intro_sub_title AS intro_sub_title_8, t0.intro_title AS intro_title_9, t0.intro_paragraph AS intro_paragraph_10, t0.offer_sub_title AS offer_sub_title_11, t0.offer_title AS offer_title_12, t0.offer_paragraph AS offer_paragraph_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16, t0.quote_cover_name AS quote_cover_name_17, t0.quote_cover_size AS quote_cover_size_18, t0.quote_cover_updated_at AS quote_cover_updated_at_19, t0.quote_cover_alt AS quote_cover_alt_20, t0.quote AS quote_21, t0.quote_author AS quote_author_22 FROM fluvial_category t0
Parameters:
[] |
| 8 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon_name AS icon_name_3, t0.icon_size AS icon_size_4, t0.icon_updated_at AS icon_updated_at_5, t0.icon_alt AS icon_alt_6, t0.homepage_id AS homepage_id_7 FROM homepage_boat t0 WHERE t0.homepage_id = ?
Parameters:
[
1
]
|
| 9 | 0.17 ms |
SELECT t0.id AS id_1, t0.sub_title AS sub_title_2, t0.title AS title_3, t0.paragraph AS paragraph_4, t0.illustration_name AS illustration_name_5, t0.illustration_size AS illustration_size_6, t0.illustration_updated_at AS illustration_updated_at_7, t0.illustration_alt AS illustration_alt_8, t0.anchor AS anchor_9, t0.resume AS resume_10, t0.position AS position_11, t0.slug AS slug_12, t0.homepage_id AS homepage_id_13 FROM service t0 WHERE t0.homepage_id = ?
Parameters:
[
1
]
|
| 10 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM actuality_category t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 11 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM actuality_category t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 12 | 0.16 ms |
SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.logo_size AS logo_size_3, t0.logo_updated_at AS logo_updated_at_4, t0.logo_alt AS logo_alt_5, t0.homepage_id AS homepage_id_6 FROM homepage_partner t0 WHERE t0.homepage_id = ?
Parameters:
[
1
]
|
| 13 | 0.17 ms |
SELECT t0.id AS id_1, t0.cover_name AS cover_name_2, t0.cover_size AS cover_size_3, t0.cover_updated_at AS cover_updated_at_4, t0.cover_alt AS cover_alt_5, t0.name AS name_6, t0.title AS title_7, t0.intro_sub_title AS intro_sub_title_8, t0.intro_title AS intro_title_9, t0.intro_paragraph AS intro_paragraph_10, t0.offer_sub_title AS offer_sub_title_11, t0.offer_title AS offer_title_12, t0.offer_paragraph AS offer_paragraph_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16, t0.quote_cover_name AS quote_cover_name_17, t0.quote_cover_size AS quote_cover_size_18, t0.quote_cover_updated_at AS quote_cover_updated_at_19, t0.quote_cover_alt AS quote_cover_alt_20, t0.quote AS quote_21, t0.quote_author AS quote_author_22 FROM maritime_category t0
Parameters:
[] |
| 14 | 0.14 ms |
SELECT t0.id AS id_1, t0.cover_name AS cover_name_2, t0.cover_size AS cover_size_3, t0.cover_updated_at AS cover_updated_at_4, t0.cover_alt AS cover_alt_5, t0.name AS name_6, t0.title AS title_7, t0.intro_sub_title AS intro_sub_title_8, t0.intro_title AS intro_title_9, t0.intro_paragraph AS intro_paragraph_10, t0.offer_sub_title AS offer_sub_title_11, t0.offer_title AS offer_title_12, t0.offer_paragraph AS offer_paragraph_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16, t0.quote_cover_name AS quote_cover_name_17, t0.quote_cover_size AS quote_cover_size_18, t0.quote_cover_updated_at AS quote_cover_updated_at_19, t0.quote_cover_alt AS quote_cover_alt_20, t0.quote AS quote_21, t0.quote_author AS quote_author_22 FROM fluvial_category t0
Parameters:
[] |
| 15 | 0.14 ms |
SELECT t0.id AS id_1, t0.sub_title AS sub_title_2, t0.title AS title_3, t0.paragraph AS paragraph_4, t0.illustration_name AS illustration_name_5, t0.illustration_size AS illustration_size_6, t0.illustration_updated_at AS illustration_updated_at_7, t0.illustration_alt AS illustration_alt_8, t0.anchor AS anchor_9, t0.resume AS resume_10, t0.position AS position_11, t0.slug AS slug_12, t0.homepage_id AS homepage_id_13 FROM service t0
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\Actuality | No errors. |
| App\Entity\Testimony | No errors. |
| App\Entity\Homepage | No errors. |
| App\Entity\ActualityCategory | No errors. |
| App\Entity\ActualityBloc | No errors. |
| App\Entity\LandingPage | No errors. |
| App\Entity\HomepageBoat | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\HomepagePartner | No errors. |
| App\Entity\MaritimeCategory | No errors. |
| App\Entity\Bloc |
|
| App\Entity\Offer | No errors. |
| App\Entity\FluvialCategory | No errors. |