Query Metrics
14
Database Queries
10
Different statements
3.76 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.52 ms (13.80%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM actuality_category t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.49 ms (13.00%) |
2 |
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:
[] |
|
0.43 ms (11.41%) |
1 |
SELECT a0_.id AS id_0, a0_.cover_name AS cover_name_1, a0_.cover_size AS cover_size_2, a0_.cover_updated_at AS cover_updated_at_3, a0_.cover_alt AS cover_alt_4, a0_.title AS title_5, a0_.resume AS resume_6, a0_.date AS date_7, a0_.published AS published_8, a0_.meta_title AS meta_title_9, a0_.meta_description AS meta_description_10, a0_.quote_cover_name AS quote_cover_name_11, a0_.quote_cover_size AS quote_cover_size_12, a0_.quote_cover_updated_at AS quote_cover_updated_at_13, a0_.quote_cover_alt AS quote_cover_alt_14, a0_.quote AS quote_15, a0_.quote_author AS quote_author_16, a0_.slug AS slug_17, a0_.category_id AS category_id_18 FROM actuality a0_ WHERE a0_.published = 1 AND a0_.id <> ? AND a0_.id IN (?) ORDER BY a0_.date DESC
Parameters:
[ 8 [ 7 6 3 1 2 ] ] |
|
0.43 ms (11.32%) |
2 |
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:
[] |
|
0.41 ms (10.79%) |
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_actuality_list"
]
|
|
0.38 ms (10.19%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.cover_name AS cover_name_1, a0_.cover_size AS cover_size_2, a0_.cover_updated_at AS cover_updated_at_3, a0_.cover_alt AS cover_alt_4, a0_.title AS title_5, a0_.resume AS resume_6, a0_.date AS date_7, a0_.published AS published_8, a0_.meta_title AS meta_title_9, a0_.meta_description AS meta_description_10, a0_.quote_cover_name AS quote_cover_name_11, a0_.quote_cover_size AS quote_cover_size_12, a0_.quote_cover_updated_at AS quote_cover_updated_at_13, a0_.quote_cover_alt AS quote_cover_alt_14, a0_.quote AS quote_15, a0_.quote_author AS quote_author_16, a0_.slug AS slug_17 FROM actuality a0_ WHERE a0_.published = 1 AND a0_.id <> ? ORDER BY a0_.date DESC) dctrn_result) dctrn_table
Parameters:
[
8
]
|
|
0.33 ms (8.75%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_7 FROM (SELECT a0_.id AS id_0, a0_.cover_name AS cover_name_1, a0_.cover_size AS cover_size_2, a0_.cover_updated_at AS cover_updated_at_3, a0_.cover_alt AS cover_alt_4, a0_.title AS title_5, a0_.resume AS resume_6, a0_.date AS date_7, a0_.published AS published_8, a0_.meta_title AS meta_title_9, a0_.meta_description AS meta_description_10, a0_.quote_cover_name AS quote_cover_name_11, a0_.quote_cover_size AS quote_cover_size_12, a0_.quote_cover_updated_at AS quote_cover_updated_at_13, a0_.quote_cover_alt AS quote_cover_alt_14, a0_.quote AS quote_15, a0_.quote_author AS quote_author_16, a0_.slug AS slug_17 FROM actuality a0_ WHERE a0_.published = 1 AND a0_.id <> ?) dctrn_result_inner ORDER BY date_7 DESC) dctrn_result LIMIT 6
Parameters:
[
8
]
|
|
0.31 ms (8.29%) |
1 |
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 1
Parameters:
[
"1"
]
|
|
0.25 ms (6.59%) |
1 |
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:
[] |
|
0.22 ms (5.88%) |
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\Actuality | No errors. |
| App\Entity\ActualityCategory | No errors. |
| App\Entity\ActualityBloc | No errors. |
| App\Entity\MaritimeCategory | No errors. |
| App\Entity\Bloc |
|
| App\Entity\Offer | No errors. |
| App\Entity\FluvialCategory | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Homepage | No errors. |