https://assurboat.cerisarine.fr/actualites

Query Metrics

14 Database Queries
10 Different statements
3.76 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

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
  • The association App\Entity\Bloc#service refers to the inverse side field App\Entity\Service#paragraphs which does not exist.
App\Entity\Offer No errors.
App\Entity\FluvialCategory No errors.
App\Entity\Service No errors.
App\Entity\Homepage No errors.