https://noocarb.asb-digital.fr/actualites

Query Metrics

24 Database Queries
13 Different statements
10.25 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.94 ms
(18.97%)
6
SELECT t0.id AS id_1, t0.title AS title_2 FROM reference_city t0 WHERE t0.id = ?
Parameters:
[
  3
]
1.54 ms
(15.04%)
4
SELECT t0.id AS id_1, t0.name AS name_2 FROM category_actualite t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.32 ms
(12.88%)
4
SELECT t0.id AS id_1, t0.name AS name_2 FROM actualite_hashtag t0 INNER JOIN actualite_hashtag_actualite ON t0.id = actualite_hashtag_actualite.actualite_hashtag_id WHERE actualite_hashtag_actualite.actualite_id = ?
Parameters:
[
  1
]
0.80 ms
(7.76%)
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.name AS name_6, t0.icon_name AS icon_name_7, t0.icon_size AS icon_size_8, t0.icon_updated_at AS icon_updated_at_9, t0.icon_alt AS icon_alt_10, t0.resume AS resume_11, t0.intro_sub_title AS intro_sub_title_12, t0.intro_title AS intro_title_13, t0.intro_paragraphe AS intro_paragraphe_14, t0.intro_visuel_panoramique_name AS intro_visuel_panoramique_name_15, t0.intro_visuel_panoramique_size AS intro_visuel_panoramique_size_16, t0.intro_visuel_panoramique_updated_at AS intro_visuel_panoramique_updated_at_17, t0.intro_visuel_panoramique_alt AS intro_visuel_panoramique_alt_18, t0.intro_paragraphe2 AS intro_paragraphe2_19, t0.intro_paragraphe3 AS intro_paragraphe3_20, t0.why_call_sub_title AS why_call_sub_title_21, t0.why_call_title AS why_call_title_22, t0.citationsub_title AS citationsub_title_23, t0.why_call_paragraphe AS why_call_paragraphe_24, t0.why_call_paragraphe2 AS why_call_paragraphe2_25, t0.contact_title AS contact_title_26, t0.contact_paragraphe AS contact_paragraphe_27, t0.meta_title AS meta_title_28, t0.meta_description AS meta_description_29, t0.position AS position_30, t0.slug AS slug_31, t0.citation AS citation_32, t0.author AS author_33 FROM expertise_public t0
Parameters:
[]
0.73 ms
(7.08%)
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_actualite_list"
]
0.62 ms
(6.06%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.created_at AS created_at_2, a0_.cover_name AS cover_name_3, a0_.cover_size AS cover_size_4, a0_.cover_updated_at AS cover_updated_at_5, a0_.cover_alt AS cover_alt_6, a0_.resume_other_page AS resume_other_page_7, a0_.resume_on_page AS resume_on_page_8, a0_.published AS published_9, a0_.meta_title AS meta_title_10, a0_.meta_description AS meta_description_11, a0_.slug AS slug_12 FROM actualite a0_ WHERE a0_.published = 1 ORDER BY a0_.created_at DESC) dctrn_result) dctrn_table
Parameters:
[]
0.59 ms
(5.73%)
1
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_2 FROM (SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.created_at AS created_at_2, a0_.cover_name AS cover_name_3, a0_.cover_size AS cover_size_4, a0_.cover_updated_at AS cover_updated_at_5, a0_.cover_alt AS cover_alt_6, a0_.resume_other_page AS resume_other_page_7, a0_.resume_on_page AS resume_on_page_8, a0_.published AS published_9, a0_.meta_title AS meta_title_10, a0_.meta_description AS meta_description_11, a0_.slug AS slug_12 FROM actualite a0_ WHERE a0_.published = 1) dctrn_result_inner ORDER BY created_at_2 DESC) dctrn_result LIMIT 6
Parameters:
[]
0.54 ms
(5.26%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.cover_name AS cover_name_3, t0.cover_size AS cover_size_4, t0.cover_updated_at AS cover_updated_at_5, t0.cover_alt AS cover_alt_6, t0.firm_name AS firm_name_7, t0.logo_name AS logo_name_8, t0.logo_size AS logo_size_9, t0.logo_updated_at AS logo_updated_at_10, t0.logo_alt AS logo_alt_11, t0.resume AS resume_12, t0.intro_title AS intro_title_13, t0.intro_paragraph AS intro_paragraph_14, t0.intro_visuel_panoramique_name AS intro_visuel_panoramique_name_15, t0.intro_visuel_panoramique_size AS intro_visuel_panoramique_size_16, t0.intro_visuel_panoramique_updated_at AS intro_visuel_panoramique_updated_at_17, t0.intro_visuel_panoramique_alt AS intro_visuel_panoramique_alt_18, t0.intro_video_url AS intro_video_url_19, t0.more_sectors AS more_sectors_20, t0.more_expertises AS more_expertises_21, t0.more_title AS more_title_22, t0.more_paragraph AS more_paragraph_23, t0.blue_sub_title AS blue_sub_title_24, t0.blue_title AS blue_title_25, t0.blue_paragraph1 AS blue_paragraph1_26, t0.blue_paragraph2 AS blue_paragraph2_27, t0.key_number1_number AS key_number1_number_28, t0.key_number1_libelle AS key_number1_libelle_29, t0.key_number2_number AS key_number2_number_30, t0.key_number2_libelle AS key_number2_libelle_31, t0.key_number3_number AS key_number3_number_32, t0.key_number3_libelle AS key_number3_libelle_33, t0.key_number4_number AS key_number4_number_34, t0.key_number4_libelle AS key_number4_libelle_35, t0.contact_title AS contact_title_36, t0.contact_paragraph AS contact_paragraph_37, t0.display_on_menu AS display_on_menu_38, t0.meta_title AS meta_title_39, t0.meta_description AS meta_description_40, t0.position AS position_41, t0.slug AS slug_42, t0.city_id AS city_id_43 FROM reference_public t0 WHERE t0.display_on_menu = ?
Parameters:
[
  1
]
0.53 ms
(5.14%)
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.name AS name_6, t0.icon_name AS icon_name_7, t0.icon_size AS icon_size_8, t0.icon_updated_at AS icon_updated_at_9, t0.icon_alt AS icon_alt_10, t0.resume AS resume_11, t0.intro_sub_title AS intro_sub_title_12, t0.intro_title AS intro_title_13, t0.intro_paragraphe AS intro_paragraphe_14, t0.intro_visuel_panoramique_name AS intro_visuel_panoramique_name_15, t0.intro_visuel_panoramique_size AS intro_visuel_panoramique_size_16, t0.intro_visuel_panoramique_updated_at AS intro_visuel_panoramique_updated_at_17, t0.intro_visuel_panoramique_alt AS intro_visuel_panoramique_alt_18, t0.intro_paragraphe2 AS intro_paragraphe2_19, t0.intro_paragraphe3 AS intro_paragraphe3_20, t0.why_call_sub_title AS why_call_sub_title_21, t0.why_call_title AS why_call_title_22, t0.citationsub_title AS citationsub_title_23, t0.why_call_paragraphe AS why_call_paragraphe_24, t0.why_call_paragraphe2 AS why_call_paragraphe2_25, t0.contact_title AS contact_title_26, t0.contact_paragraphe AS contact_paragraphe_27, t0.meta_title AS meta_title_28, t0.meta_description AS meta_description_29, t0.position AS position_30, t0.slug AS slug_31, t0.citation AS citation_32, t0.author AS author_33 FROM expertise_prive t0
Parameters:
[]
0.46 ms
(4.45%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.cover_name AS cover_name_3, t0.cover_size AS cover_size_4, t0.cover_updated_at AS cover_updated_at_5, t0.cover_alt AS cover_alt_6, t0.section1_sub_title AS section1_sub_title_7, t0.section1_title AS section1_title_8, t0.section1_paragraphe AS section1_paragraphe_9, t0.section1_visuel_left_name AS section1_visuel_left_name_10, t0.section1_visuel_left_size AS section1_visuel_left_size_11, t0.section1_visuel_left_updated_at AS section1_visuel_left_updated_at_12, t0.section1_visuel_left_alt AS section1_visuel_left_alt_13, t0.section2_sub_title AS section2_sub_title_14, t0.section2_title AS section2_title_15, t0.section2_paragraphe AS section2_paragraphe_16, t0.section2_visuel_name AS section2_visuel_name_17, t0.section2_visuel_size AS section2_visuel_size_18, t0.section2_visuel_updated_at AS section2_visuel_updated_at_19, t0.section2_visuel_alt AS section2_visuel_alt_20, t0.citationsub_title AS citationsub_title_21, t0.section_blue_sub_title AS section_blue_sub_title_22, t0.section_blue_title AS section_blue_title_23, t0.section_blue_paragraphe1 AS section_blue_paragraphe1_24, t0.section_blue_paragraphe2 AS section_blue_paragraphe2_25, t0.section4_sub_title AS section4_sub_title_26, t0.section4_title AS section4_title_27, t0.section4_paragraphe AS section4_paragraphe_28, t0.section4_visuel_right_name AS section4_visuel_right_name_29, t0.section4_visuel_right_size AS section4_visuel_right_size_30, t0.section4_visuel_right_updated_at AS section4_visuel_right_updated_at_31, t0.section4_visuel_right_alt AS section4_visuel_right_alt_32, t0.objectif_sub_title AS objectif_sub_title_33, t0.objectif_title AS objectif_title_34, t0.contact_title AS contact_title_35, t0.contact_paragraphe AS contact_paragraphe_36, t0.meta_title AS meta_title_37, t0.meta_description AS meta_description_38, t0.citation AS citation_39, t0.author AS author_40, t0.slug AS slug_41, t0.position AS position_42, t0.is_published AS is_published_43 FROM solution t0 WHERE t0.is_published = ?
Parameters:
[
  1
]
0.41 ms
(4.05%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.cover_name AS cover_name_3, t0.cover_size AS cover_size_4, t0.cover_updated_at AS cover_updated_at_5, t0.cover_alt AS cover_alt_6, t0.firm_name AS firm_name_7, t0.logo_name AS logo_name_8, t0.logo_size AS logo_size_9, t0.logo_updated_at AS logo_updated_at_10, t0.logo_alt AS logo_alt_11, t0.resume AS resume_12, t0.intro_title AS intro_title_13, t0.intro_paragraph AS intro_paragraph_14, t0.intro_visuel_panoramique_name AS intro_visuel_panoramique_name_15, t0.intro_visuel_panoramique_size AS intro_visuel_panoramique_size_16, t0.intro_visuel_panoramique_updated_at AS intro_visuel_panoramique_updated_at_17, t0.intro_visuel_panoramique_alt AS intro_visuel_panoramique_alt_18, t0.intro_video_url AS intro_video_url_19, t0.more_sectors AS more_sectors_20, t0.more_expertises AS more_expertises_21, t0.more_title AS more_title_22, t0.more_paragraph AS more_paragraph_23, t0.blue_sub_title AS blue_sub_title_24, t0.blue_title AS blue_title_25, t0.blue_paragraph1 AS blue_paragraph1_26, t0.blue_paragraph2 AS blue_paragraph2_27, t0.key_number1_number AS key_number1_number_28, t0.key_number1_libelle AS key_number1_libelle_29, t0.key_number2_number AS key_number2_number_30, t0.key_number2_libelle AS key_number2_libelle_31, t0.key_number3_number AS key_number3_number_32, t0.key_number3_libelle AS key_number3_libelle_33, t0.key_number4_number AS key_number4_number_34, t0.key_number4_libelle AS key_number4_libelle_35, t0.contact_title AS contact_title_36, t0.contact_paragraph AS contact_paragraph_37, t0.display_on_menu AS display_on_menu_38, t0.meta_title AS meta_title_39, t0.meta_description AS meta_description_40, t0.position AS position_41, t0.slug AS slug_42, t0.city_id AS city_id_43 FROM reference_prive t0 WHERE t0.display_on_menu = ?
Parameters:
[
  1
]
0.41 ms
(4.03%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.created_at AS created_at_2, a0_.cover_name AS cover_name_3, a0_.cover_size AS cover_size_4, a0_.cover_updated_at AS cover_updated_at_5, a0_.cover_alt AS cover_alt_6, a0_.resume_other_page AS resume_other_page_7, a0_.resume_on_page AS resume_on_page_8, a0_.published AS published_9, a0_.meta_title AS meta_title_10, a0_.meta_description AS meta_description_11, a0_.slug AS slug_12, a0_.category_id AS category_id_13 FROM actualite a0_ WHERE a0_.published = 1 AND a0_.id IN (?) ORDER BY a0_.created_at DESC
Parameters:
[
  [
    1
    2
    3
    13
  ]
]
0.37 ms
(3.57%)
1
SELECT t0.phone AS phone_1, t0.address_street AS address_street_2, t0.credits AS credits_3, t0.id AS id_4, t0.email AS email_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.legal_site_name AS legal_site_name_8, t0.legal_siret AS legal_siret_9, t0.legal_siren AS legal_siren_10, t0.legal_rcs AS legal_rcs_11, t0.legal_address AS legal_address_12, t0.legal_zipcode AS legal_zipcode_13, t0.legal_city AS legal_city_14, t0.legal_phone AS legal_phone_15, t0.legal_email AS legal_email_16, t0.legal_publication_owner AS legal_publication_owner_17, t0.legal_site_url AS legal_site_url_18, t0.default_title AS default_title_19, t0.default_meta_desc AS default_meta_desc_20 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\Actualite
  • The mappings App\Entity\Actualite#referencesPrive and App\Entity\ReferencePrive#actualites are inconsistent with each other.
App\Entity\ExpertisePublic No errors.
App\Entity\BlockExpertise No errors.
App\Entity\ReferencePublic
  • The mappings App\Entity\ReferencePublic#blocs and App\Entity\ReferenceBloc#referencePublic are inconsistent with each other.
App\Entity\ExpertisePrive No errors.
App\Entity\ReferencePrive
  • The mappings App\Entity\ReferencePrive#blocs and App\Entity\ReferenceBloc#referencePrive are inconsistent with each other.
  • The association App\Entity\ReferencePrive#actualites refers to the owning side field App\Entity\Actualite#ReferencePrive which does not exist.
App\Entity\ReferenceCity No errors.
App\Entity\ReferenceBloc
  • The association App\Entity\ReferenceBloc#referencePublic refers to the inverse side field App\Entity\ReferencePublic#referenceBlocs which does not exist.
  • The association App\Entity\ReferenceBloc#referencePrive refers to the inverse side field App\Entity\ReferencePrive#referenceBlocs which does not exist.
App\Entity\ReferenceMedia No errors.
App\Entity\Solution No errors.
App\Entity\Homepage No errors.
App\Entity\SolutionReference No errors.
App\Entity\SolutionObjectif No errors.
App\Entity\CategoryActualite No errors.
App\Entity\ActualiteHashtag No errors.
App\Entity\ActualiteParagraph No errors.
App\Entity\ActualiteGalleriePhoto No errors.
App\Entity\ActualiteGallerieVideo No errors.