https://netisse2023.netissedev.com/fr/page/wh-it

Query Metrics

28 Database Queries
19 Different statements
104.66 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
61.86 ms
(59.11%)
5
SELECT l0_.id AS id_0, l0_.created_at AS created_at_1, l0_.is_enable AS is_enable_2, l0_.classe AS classe_3, l1_.name AS name_4, l1_.description AS description_5, l2_.id AS id_6, l2_.link AS link_7, l3_.second_title AS second_title_8, l3_.name AS name_9, l2_.is_show_title_labels AS is_show_title_labels_10, l3_.description AS description_11, l2_.classe AS classe_12, l2_.col_bloc_label_slide AS col_bloc_label_slide_13, m4_.id AS id_14, m4_.file AS file_15, m4_.path AS path_16, m4_.title AS title_17 FROM label_bloc l0_ LEFT JOIN label_bloc_lang l1_ ON l0_.id = l1_.label_bloc_id AND (l1_.language_id = ?) LEFT JOIN label_slider l2_ ON l0_.id = l2_.label_bloc_id LEFT JOIN label_slider_lang l3_ ON l2_.id = l3_.label_slider_id AND (l3_.language_id = ?) LEFT JOIN media m4_ ON (m4_.id_origin = l2_.id AND m4_.origin = ? AND m4_.language_id = ?) WHERE l0_.deleted_at IS NULL AND l0_.is_enable = ? AND (l2_.deleted_at IS NULL AND l2_.is_enable = 1) AND m4_.deleted_at IS NULL ORDER BY l0_.id DESC
Parameters:
[
  1
  1
  "App\Entity\Labels\LabelSlider"
  1
  1
]
15.40 ms
(14.71%)
1
SELECT b0_.id AS id_0, b0_.position AS position_1, b0_.is_fix_title AS is_fix_title_2, b0_.type AS type_3, b0_.classe AS classe_4, b0_.id_origin AS id_origin_5, b0_.id_type AS id_type_6, b0_.origin AS origin_7, b0_.first_position AS first_position_8, b0_.second_position AS second_position_9, b0_.is_show_title AS is_show_title_10, b0_.position_image AS position_image_11, b0_.position_video AS position_video_12, b0_.col_txt AS col_txt_13, b0_.col_image AS col_image_14, b0_.col_card AS col_card_15, b0_.alignement_texte AS alignement_texte_16, b0_.istitre_principale_bloc AS istitre_principale_bloc_17, b0_.is_btn AS is_btn_18, b0_.titre_principale_bloc AS titre_principale_bloc_19, b0_.classe_titre_principale_bloc AS classe_titre_principale_bloc_20, b1_.title AS title_21, b1_.description AS description_22, m2_.id AS id_23, m2_.file AS file_24, m2_.path AS path_25, m2_.extension AS extension_26, m2_.title AS title_27, m2_.type AS type_28, c3_.id AS id_29, c3_.is_enable AS is_enable_30, c4_.title_top AS title_top_31, c4_.title AS title_32, c4_.description AS description_33, c3_.link AS link_34, c3_.classe AS classe_35, m5_.id AS id_36, m5_.origin AS origin_37, m5_.file AS file_38, m5_.path AS path_39, m5_.extension AS extension_40, c6_.id AS id_41, c7_.title_top AS title_top_42, c6_.is_enable AS is_enable_43, c7_.title AS title_44, c7_.description AS description_45, c6_.link AS link_46, c6_.classe AS classe_47, m8_.id AS id_48, m8_.origin AS origin_49, m8_.file AS file_50, m8_.path AS path_51, m8_.extension AS extension_52 FROM bloc b0_ LEFT JOIN bloc_lang b1_ ON b0_.id = b1_.bloc_id AND (b1_.language_id = ?) LEFT JOIN media m2_ ON (m2_.id_origin = b0_.id AND m2_.origin = ? AND m2_.language_id = ?) LEFT JOIN client_bloc c6_ ON b0_.client_right_id = c6_.id LEFT JOIN client_bloc_lang c7_ ON c6_.id = c7_.client_bloc_lang_id AND (c7_.language_id = ?) LEFT JOIN media m8_ ON (m8_.origin = ? AND m8_.id_origin = c6_.id AND m8_.language_id = ?) LEFT JOIN client_bloc c3_ ON b0_.client_left_id = c3_.id LEFT JOIN client_bloc_lang c4_ ON c3_.id = c4_.client_bloc_lang_id AND (c4_.language_id = ?) LEFT JOIN media m5_ ON (m5_.origin = ? AND m5_.id_origin = c3_.id AND m5_.language_id = ?) WHERE b0_.origin = ? AND b0_.id_origin = ? AND m2_.deleted_at IS NULL AND m8_.deleted_at IS NULL AND m5_.deleted_at IS NULL ORDER BY b0_.position ASC
Parameters:
[
  1
  "App\Entity\Blocs\Bloc"
  1
  1
  "App\Entity\ClientBlocs\ClientBloc"
  1
  1
  "App\Entity\ClientBlocs\ClientBloc"
  1
  "App\Entity\Pages\Page"
  42
]
8.35 ms
(7.98%)
1
SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.is_enable AS is_enable_2, b1_.name AS name_3, b1_.description AS description_4, b2_.id AS id_5, b2_.classe AS classe_6, b3_.name AS name_7, b3_.description AS description_8, b2_.col_benefice_items AS col_benefice_items_9, b2_.cards_links AS cards_links_10, b3_.link AS link_11, m4_.id AS id_12, m4_.file AS file_13, m4_.path AS path_14, m4_.title AS title_15 FROM benefice b0_ LEFT JOIN benefice_lang b1_ ON b0_.id = b1_.benefice_bloc_id AND (b1_.language_id = ?) LEFT JOIN benefice_items b2_ ON b0_.id = b2_.benefice_id LEFT JOIN benefice_items_lang b3_ ON b2_.id = b3_.benefice_items_id AND (b3_.language_id = ?) LEFT JOIN media m4_ ON (m4_.id_origin = b2_.id AND m4_.origin = ? AND m4_.language_id = ?) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = ? AND (b2_.deleted_at IS NULL AND b2_.is_enable = 1) AND m4_.deleted_at IS NULL ORDER BY b0_.id DESC
Parameters:
[
  1
  1
  "App\Entity\Benefice\BeneficeItems"
  1
  1
]
3.85 ms
(3.68%)
1
SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.is_enable AS is_enable_2, c1_.name AS name_3, c0_.class AS class_4, c2_.id AS id_5, c3_.name AS name_6, c3_.description AS description_7, c3_.title_mobile AS title_mobile_8, c2_.is_enable AS is_enable_9, c2_.background_color AS background_color_10, m4_.id AS id_11, m4_.file AS file_12, m4_.path AS path_13, m4_.extension AS extension_14 FROM carrousel c0_ LEFT JOIN carrousel_lang c1_ ON c0_.id = c1_.carrousel_id AND (c1_.language_id = ?) LEFT JOIN carrousel_items c2_ ON c0_.id = c2_.carrousel_id LEFT JOIN carrousel_items_lang c3_ ON c2_.id = c3_.carousel_items_id AND (c3_.language_id = ?) LEFT JOIN media m4_ ON (m4_.id_origin = c2_.id AND m4_.origin = ? AND m4_.language_id = ?) WHERE c0_.deleted_at IS NULL AND (c2_.deleted_at IS NULL AND c2_.is_enable = 1) AND m4_.deleted_at IS NULL ORDER BY c0_.id DESC, c2_.id ASC
Parameters:
[
  1
  1
  "App\Entity\Carrousel\carrouselItems"
  1
]
2.45 ms
(2.34%)
5
SELECT t0.id AS id_1, t0.the_key AS the_key_2, t0.the_value AS the_value_3, t0.updated_at AS updated_at_4 FROM configs t0 WHERE t0.the_key = ? LIMIT 1
Parameters:
[
  "show_consentement"
]
2.11 ms
(2.02%)
1
SELECT m0_.id AS id_0, m0_.origin AS origin_1, m0_.id_origin AS id_origin_2, m0_.file AS file_3, m0_.extension AS extension_4, m0_.taille AS taille_5, m0_.path AS path_6, m0_.title AS title_7, m0_.position AS position_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.deleted_at AS deleted_at_11, m0_.type AS type_12, m0_.language_id AS language_id_13 FROM media m0_ WHERE m0_.origin = ? AND m0_.id_origin = ? AND m0_.deleted_at IS NULL AND m0_.language_id = ? ORDER BY m0_.position ASC
Parameters:
[
  "App\Entity\Pages\Page"
  42
  1
]
1.42 ms
(1.36%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_actif AS is_actif_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM languages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
1.07 ms
(1.02%)
1
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p0_.is_contact AS is_contact_3, p1_.name AS name_4, p1_.slug AS slug_5, p1_.description AS description_6, p0_.classe_titre_contact AS classe_titre_contact_7, p0_.link_visiter_site AS link_visiter_site_8, p0_.classe_body_page AS classe_body_page_9, p0_.is_demo AS is_demo_10 FROM page p0_ LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id AND (p1_.language_id = ?) WHERE (p0_.deleted_at IS NULL AND p0_.is_enable = 1) AND p0_.id IN (?, ?, ?, ?) ORDER BY p0_.id ASC
Parameters:
[
  1
  "10"
  "8"
  "5"
  "4"
]
0.91 ms
(0.87%)
1
SELECT p0_.slug AS slug_0, p0_.page_id AS sclr_1 FROM page_lang p0_ WHERE p0_.language_id = ? AND p0_.page_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  "4"
  "5"
  "8"
  "10"
  "9"
  "21"
  "32"
  "43"
]
0.90 ms
(0.86%)
1
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p0_.is_contact AS is_contact_3, p1_.name AS name_4, p1_.slug AS slug_5, p1_.description AS description_6, p0_.classe_titre_contact AS classe_titre_contact_7, p0_.link_visiter_site AS link_visiter_site_8, p0_.classe_body_page AS classe_body_page_9, p0_.is_demo AS is_demo_10 FROM page p0_ LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id AND (p1_.language_id = ?) WHERE (p0_.deleted_at IS NULL AND p0_.is_enable = 1) AND p0_.id = ? ORDER BY p0_.id ASC
Parameters:
[
  1
  42
]
0.89 ms
(0.85%)
1
SELECT t0.id AS id_1, t0.route AS route_2, t0.parameter AS parameter_3 FROM seo t0 WHERE t0.route = ? AND t0.parameter = ? LIMIT 1
Parameters:
[
  "front_page_show"
  "wh-it"
]
0.77 ms
(0.73%)
1
SELECT p0_.slug AS slug_0, p0_.page_category_id AS sclr_1 FROM page_category_lang p0_ WHERE p0_.language_id = ? AND p0_.page_category_id IN (?)
Parameters:
[
  1
  "1"
]
0.74 ms
(0.70%)
1
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.id_origin AS id_origin_3, t0.value AS value_4 FROM palette_color t0 WHERE t0.origin = ? AND t0.id_origin = ?
Parameters:
[
  "App\Entity\Pages\Page"
  42
]
0.73 ms
(0.70%)
1
SELECT p0_.slug AS slug_0, p1_.id AS id_1, p0_.name AS name_2 FROM page_lang p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id WHERE p0_.language_id = ? AND p1_.parent_id = ?
Parameters:
[
  1
  "10"
]
0.71 ms
(0.68%)
1
SELECT p0_.slug AS slug_0, p0_.page_id AS sclr_1 FROM page_lang p0_ WHERE p0_.language_id = ? AND p0_.page_id IN (?, ?)
Parameters:
[
  1
  "21"
  "22"
]
0.68 ms
(0.65%)
1
SELECT t0.id AS id_1, t0.is_enable AS is_enable_2, t0.is_contact AS is_contact_3, t0.is_demo AS is_demo_4, t0.classe_titre_contact AS classe_titre_contact_5, t0.link_visiter_site AS link_visiter_site_6, t0.classe_body_page AS classe_body_page_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.page_sous_category_id AS page_sous_category_id_11, t0.parent_id AS parent_id_12 FROM page t0 WHERE t0.id = ?
Parameters:
[
  42
]
0.68 ms
(0.65%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.language_id AS language_id_5, t0.page_id AS page_id_6 FROM page_lang t0 WHERE t0.language_id = ? AND t0.slug = ? LIMIT 1
Parameters:
[
  1
  "wh-it"
]
0.61 ms
(0.58%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.language_id AS language_id_5, t0.seo_id AS seo_id_6 FROM seo_lang t0 WHERE t0.seo_id IS NULL AND t0.language_id = ? LIMIT 1
Parameters:
[
  1
]
0.54 ms
(0.51%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_actif AS is_actif_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM languages t0 WHERE t0.deleted_at IS NULL AND t0.is_actif = ?
Parameters:
[
  1
]

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
App\Entity\Languages No errors.
App\Entity\ClientBlocs\ClientBlocLang No errors.
App\Entity\Labels\LabelBlocLang No errors.
App\Entity\Labels\LabelSliderLang No errors.
App\Entity\ItemsSolution\ItemsSolutionLang No errors.
App\Entity\Benefice\BeneficeLang No errors.
App\Entity\Benefice\BeneficeItemsLang No errors.
App\Entity\Pages\PageSousCategoryLang No errors.
App\Entity\User\UserStatusLang No errors.
App\Entity\Pages\PageCategoryLang No errors.
App\Entity\Pages\PageCategory No errors.
App\Entity\Pages\PageLang No errors.
App\Entity\Pages\Page No errors.
App\Entity\Medias\Media No errors.
App\Entity\Blocs\Bloc
  • The association App\Entity\Blocs\Bloc#clientBlocLangs refers to the owning side field App\Entity\ClientBlocs\ClientBlocLang#clientBloc which does not exist.
App\Entity\Blocs\BlocLang No errors.
App\Entity\ClientBlocs\ClientBloc No errors.
App\Entity\Labels\LabelBloc No errors.
App\Entity\Labels\LabelSlider No errors.
App\Entity\Carrousel\carrousel No errors.
App\Entity\Carrousel\carrouselLang No errors.
App\Entity\Carrousel\carrouselItems No errors.
App\Entity\Carrousel\carrouselItemsLang No errors.
App\Entity\Benefice\Benefice No errors.
App\Entity\Benefice\BeneficeItems No errors.
App\Entity\Pages\PaletteColor No errors.
App\Entity\Pages\PageSousCategory No errors.
App\Entity\Seo\Seo No errors.
App\Entity\Seo\SeoLang No errors.
App\Entity\Config\Configs No errors.