Query Metrics
15
Database Queries
8
Different statements
10.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.10 ms (40.68%) |
7 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.product_name AS product_name_4, t0.product_size AS product_size_5, t0.product_file_updated_at AS product_file_updated_at_6, t0.display AS display_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.position AS position_10, t0.slug AS slug_11, t0.category_id AS category_id_12 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
7
]
|
|
1.82 ms (18.06%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.intro AS intro_4, t0.sub_title_detail AS sub_title_detail_5, t0.description AS description_6, t0.category_name AS category_name_7, t0.category_size AS category_size_8, t0.category_file_updated_at AS category_file_updated_at_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.position AS position_12, t0.slug AS slug_13 FROM category t0
Parameters:
[] |
|
0.96 ms (9.52%) |
1 |
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_product_show"
]
|
|
0.74 ms (7.33%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.paragraph_name AS paragraph_name_4, t0.paragraph_size AS paragraph_size_5, t0.paragraph_alt AS paragraph_alt_6, t0.paragraph_file_updated_at AS paragraph_file_updated_at_7, t0.cta_text AS cta_text_8, t0.cta_link AS cta_link_9, t0.cta_external AS cta_external_10, t0.position AS position_11, t0.product_id AS product_id_12, t0.post_id AS post_id_13, t0.presentation_id AS presentation_id_14, t0.expertise_id AS expertise_id_15, t0.landing_page_id AS landing_page_id_16 FROM paragraph t0 WHERE t0.product_id = ?
Parameters:
[
14
]
|
|
0.70 ms (6.90%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.intro AS intro_4, t0.sub_title_detail AS sub_title_detail_5, t0.description AS description_6, t0.category_name AS category_name_7, t0.category_size AS category_size_8, t0.category_file_updated_at AS category_file_updated_at_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.position AS position_12, t0.slug AS slug_13 FROM category t0 WHERE t0.id = ?
Parameters:
[
11
]
|
|
0.68 ms (6.71%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.achievement_name AS achievement_name_4, t0.achievement_size AS achievement_size_5, t0.achievement_file_updated_at AS achievement_file_updated_at_6, t0.updated_at AS updated_at_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.position AS position_10, t0.slug AS slug_11, t0.product_id AS product_id_12 FROM achievement t0 WHERE t0.product_id = ?
Parameters:
[
14
]
|
|
0.56 ms (5.53%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.intro AS intro_3, t0.product_name AS product_name_4, t0.product_size AS product_size_5, t0.product_file_updated_at AS product_file_updated_at_6, t0.display AS display_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.position AS position_10, t0.slug AS slug_11, t0.category_id AS category_id_12 FROM product t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"signaletique-exterieure"
]
|
|
0.53 ms (5.27%) |
1 |
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:
[] |
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\Product | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Paragraph | No errors. |
| App\Entity\Achievement | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\Presentation | No errors. |
| App\Entity\Expertise | No errors. |
| App\Entity\LandingPage | No errors. |