https://netisse2023.netissedev.com/fr/page_category/references

Query Metrics

24 Database Queries
22 Different statements
97.07 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
22.36 ms
(23.03%)
1
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
]
17.68 ms
(18.21%)
1
SELECT b0_.id AS id_0, b1_.id AS id_1, i2_.id AS id_2, i3_.description AS description_3, i2_.classe AS classe_4, m4_.id AS id_5, m4_.file AS file_6, m4_.path AS path_7, m4_.title AS title_8 FROM bloc_solution b0_ LEFT JOIN bloc b1_ ON b0_.bloc_id = b1_.id LEFT JOIN bloc_lang b5_ ON b1_.id = b5_.bloc_id AND (b5_.language_id = ?) LEFT JOIN items_solution i2_ ON b0_.item_solution_id = i2_.id LEFT JOIN media m4_ ON (m4_.id_origin = i2_.id AND m4_.origin = ? AND m4_.language_id = ?) LEFT JOIN items_solution_lang i3_ ON i2_.id = i3_.item_solution_id AND (i3_.language_id = ?) WHERE i2_.deleted_at IS NULL AND b0_.bloc_id IN (?) ORDER BY b0_.position ASC
Parameters:
[
  1
  "App\Entity\ItemsSolution\ItemsSolution"
  1
  1
  100
]
12.08 ms
(12.45%)
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
]
9.37 ms
(9.65%)
1
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p1_.name AS name_3, p1_.slug AS slug_4, p1_.description AS description_5, p2_.name AS name_6, p3_.id AS id_7, p2_.slug AS slug_8 FROM page_sous_category p0_ LEFT JOIN page_sous_category_lang p1_ ON p0_.id = p1_.pagesouscategory_id AND (p1_.language_id = ?) LEFT JOIN page_category p3_ ON p0_.category_id = p3_.id LEFT JOIN page_category_lang p2_ ON p3_.id = p2_.page_category_id AND (p2_.language_id = ?) WHERE p0_.deleted_at IS NULL AND p0_.is_enable = ? AND p3_.deleted_at IS NULL AND p3_.is_enable = 1 AND p3_.id = (?) ORDER BY p0_.id ASC
Parameters:
[
  1
  1
  1
  1
]
8.19 ms
(8.44%)
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\PageCategory"
  1
]
6.18 ms
(6.37%)
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
]
3.66 ms
(3.77%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_enable AS is_enable_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM page_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
2.95 ms
(3.04%)
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, p2_.id AS id_11, p2_.type AS type_12, p3_.is_enable AS is_enable_13, m4_.id AS id_14, m4_.file AS file_15, m4_.path AS path_16, m4_.type AS type_17 FROM page p0_ LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id AND (p1_.language_id = ?) LEFT JOIN media m4_ ON (m4_.id_origin = p0_.id AND m4_.origin = ? AND m4_.language_id = ?) LEFT JOIN page_sous_category p3_ ON p0_.page_sous_category_id = p3_.id LEFT JOIN page_category p2_ ON p3_.category_id = p2_.id LEFT JOIN page_sous_category_lang p5_ ON p3_.id = p5_.pagesouscategory_id AND (p5_.language_id = ?) LEFT JOIN page_category_lang p6_ ON p2_.id = p6_.page_category_id AND (p6_.language_id = ?) WHERE (p0_.deleted_at IS NULL AND p0_.is_enable = 1) AND p0_.is_enable = ? AND (p3_.deleted_at IS NULL AND p3_.is_enable = 1) ORDER BY p0_.id ASC
Parameters:
[
  1
  "App\Entity\Pages\Page"
  1
  1
  1
  1
]
2.73 ms
(2.81%)
3
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"
]
2.10 ms
(2.16%)
1
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.id_origin AS id_origin_3, t0.file AS file_4, t0.extension AS extension_5, t0.taille AS taille_6, t0.path AS path_7, t0.title AS title_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.type AS type_13, t0.language_id AS language_id_14 FROM media t0 WHERE t0.id_origin = ? AND t0.origin = ? AND t0.deleted_at IS NULL
Parameters:
[
  1
  "Proxies\__CG__\App\Entity\Pages\PageCategory"
]
1.79 ms
(1.85%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.description AS description_3, t0.name AS name_4, t0.language_id AS language_id_5, t0.page_category_id AS page_category_id_6 FROM page_category_lang t0 WHERE t0.language_id = ? AND t0.slug = ? LIMIT 1
Parameters:
[
  1
  "references"
]
1.28 ms
(1.31%)
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.95 ms
(0.98%)
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.89 ms
(0.91%)
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.86 ms
(0.88%)
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_category_show"
  "references"
]
0.76 ms
(0.78%)
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.67 ms
(0.69%)
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\PageCategory"
  1
]
0.65 ms
(0.67%)
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 = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  6
  1
]
0.60 ms
(0.62%)
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.54 ms
(0.55%)
1
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p1_.name AS name_3, p1_.slug AS slug_4, p1_.description AS description_5 FROM page_category p0_ LEFT JOIN page_category_lang p1_ ON p0_.id = p1_.page_category_id AND (p1_.language_id = ?) WHERE p0_.deleted_at IS NULL AND p0_.id = ? ORDER BY p0_.id ASC
Parameters:
[
  1
  1
]
0.41 ms
(0.42%)
1
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"
]
0.38 ms
(0.40%)
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\Pages\PageSousCategory No errors.
App\Entity\Pages\PaletteColor 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\Blocs\BlocSolution No errors.
App\Entity\ItemsSolution\ItemsSolution No errors.
App\Entity\Seo\Seo No errors.
App\Entity\Seo\SeoLang No errors.
App\Entity\Config\Configs No errors.