0.96 ms (14.59%)
1
SELECT k0_ . lft AS lft_0 , k0_ . lvl AS lvl_1 , k0_ . rgt AS rgt_2 , k0_ . deleted AS deleted_3 , k0_ . hidden_from_nav AS hidden_from_nav_4 , k0_ . ref_entity_name AS ref_entity_name_5 , k0_ . internal_name AS internal_name_6 , k0_ . id AS id_7 , k1_ . lang AS lang_8 , k1_ . online AS online_9 , k1_ . title AS title_10 , k1_ . slug AS slug_11 , k1_ . url AS url_12 , k1_ . weight AS weight_13 , k1_ . created AS created_14 , k1_ . updated AS updated_15 , k1_ . id AS id_16 , k2_ . type AS type_17 , k2_ . owner AS owner_18 , k2_ . created AS created_19 , k2_ . updated AS updated_20 , k2_ . ref_id AS ref_id_21 , k2_ . ref_entity_name AS ref_entity_name_22 , k2_ . id AS id_23 , k0_ . parent_id AS parent_id_24 , k1_ . node_id AS node_id_25 , k1_ . public_node_version_id AS public_node_version_id_26 , k2_ . node_translation_id AS node_translation_id_27 , k2_ . origin_id AS origin_id_28 FROM kuma_nodes k0_ INNER JOIN kuma_node_translations k1_ ON k0_ . id = k1_ . node_id LEFT JOIN kuma_node_versions k2_ ON k1_ . public_node_version_id = k2_ . id AND (k1_ . public_node_version_id = k2_ . id ) WHERE k0_ . deleted = ? AND (k0_ . lft < = 67 AND k0_ . rgt > = 68 ) ORDER BY k0_ . lft ASC
SELECT k0_ . lft AS lft_0 , k0_ . lvl AS lvl_1 , k0_ . rgt AS rgt_2 , k0_ . deleted AS deleted_3 , k0_ . hidden_from_nav AS hidden_from_nav_4 , k0_ . ref_entity_name AS ref_entity_name_5 , k0_ . internal_name AS internal_name_6 , k0_ . id AS id_7 , k1_ . lang AS lang_8 , k1_ . online AS online_9 , k1_ . title AS title_10 , k1_ . slug AS slug_11 , k1_ . url AS url_12 , k1_ . weight AS weight_13 , k1_ . created AS created_14 , k1_ . updated AS updated_15 , k1_ . id AS id_16 , k2_ . type AS type_17 , k2_ . owner AS owner_18 , k2_ . created AS created_19 , k2_ . updated AS updated_20 , k2_ . ref_id AS ref_id_21 , k2_ . ref_entity_name AS ref_entity_name_22 , k2_ . id AS id_23 , k0_ . parent_id AS parent_id_24 , k1_ . node_id AS node_id_25 , k1_ . public_node_version_id AS public_node_version_id_26 , k2_ . node_translation_id AS node_translation_id_27 , k2_ . origin_id AS origin_id_28 FROM kuma_nodes k0_ INNER JOIN kuma_node_translations k1_ ON k0_ . id = k1_ . node_id LEFT JOIN kuma_node_versions k2_ ON k1_ . public_node_version_id = k2_ . id AND (k1_ . public_node_version_id = k2_ . id ) WHERE k0_ . deleted = 0 AND (k0_ . lft < = 67 AND k0_ . rgt > = 68 ) ORDER BY k0_ . lft ASC ;
Copy
0.60 ms (9.12%)
3
SELECT t0 . uuid AS uuid_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . copyright AS copyright_4 , t0 . location AS location_5 , t0 . content_type AS content_type_6 , t0 . metadata AS metadata_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . filesize AS filesize_10 , t0 . url AS url_11 , t0 . original_filename AS original_filename_12 , t0 . deleted AS deleted_13 , t0 . removed_from_file_system AS removed_from_file_system_14 , t0 . id AS id_15 , t0 . folder_id AS folder_id_16 FROM kuma_media t0 WHERE t0 . id = ?
SELECT t0 . uuid AS uuid_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . copyright AS copyright_4 , t0 . location AS location_5 , t0 . content_type AS content_type_6 , t0 . metadata AS metadata_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . filesize AS filesize_10 , t0 . url AS url_11 , t0 . original_filename AS original_filename_12 , t0 . deleted AS deleted_13 , t0 . removed_from_file_system AS removed_from_file_system_14 , t0 . id AS id_15 , t0 . folder_id AS folder_id_16 FROM kuma_media t0 WHERE t0 . id = '9' ;
Copy
0.53 ms (7.98%)
1
SELECT a0_ . category_label AS category_label_0 , a0_ . location AS location_1 , a0_ . registration_url AS registration_url_2 , a0_ . date AS date_3 , a0_ . summary AS summary_4 , a0_ . title AS title_5 , a0_ . page_title AS page_title_6 , a0_ . id AS id_7 , a0_ . cover_image_id AS cover_image_id_8 FROM app_event_pages a0_ INNER JOIN kuma_node_versions k1_ ON (a0_ . id = k1_ . ref_id ) INNER JOIN kuma_node_translations k2_ ON (k2_ . public_node_version_id = k1_ . id ) INNER JOIN kuma_nodes k3_ ON (k2_ . node_id = k3_ . id ) WHERE k2_ . online = ? AND k3_ . deleted = ? AND k1_ . ref_entity_name = ? AND a0_ . id < > ? AND k2_ . lang = ? ORDER BY a0_ . date DESC LIMIT 3
Parameters :
[
1
0
"App\Entity\Pages\EventPage "
"2 "
"fr "
]
SELECT a0_ . category_label AS category_label_0 , a0_ . location AS location_1 , a0_ . registration_url AS registration_url_2 , a0_ . date AS date_3 , a0_ . summary AS summary_4 , a0_ . title AS title_5 , a0_ . page_title AS page_title_6 , a0_ . id AS id_7 , a0_ . cover_image_id AS cover_image_id_8 FROM app_event_pages a0_ INNER JOIN kuma_node_versions k1_ ON (a0_ . id = k1_ . ref_id ) INNER JOIN kuma_node_translations k2_ ON (k2_ . public_node_version_id = k1_ . id ) INNER JOIN kuma_nodes k3_ ON (k2_ . node_id = k3_ . id ) WHERE k2_ . online = 1 AND k3_ . deleted = 0 AND k1_ . ref_entity_name = 'App\\Entity\\Pages\\EventPage' AND a0_ . id < > '2' AND k2_ . lang = 'fr' ORDER BY a0_ . date DESC LIMIT 3 ;
Copy
0.52 ms (7.90%)
1
SELECT k0_ . lang AS lang_0 , k0_ . online AS online_1 , k0_ . title AS title_2 , k0_ . slug AS slug_3 , k0_ . url AS url_4 , k0_ . weight AS weight_5 , k0_ . created AS created_6 , k0_ . updated AS updated_7 , k0_ . id AS id_8 , k1_ . type AS type_9 , k1_ . owner AS owner_10 , k1_ . created AS created_11 , k1_ . updated AS updated_12 , k1_ . ref_id AS ref_id_13 , k1_ . ref_entity_name AS ref_entity_name_14 , k1_ . id AS id_15 , k0_ . node_id AS node_id_16 , k0_ . public_node_version_id AS public_node_version_id_17 , k1_ . node_translation_id AS node_translation_id_18 , k1_ . origin_id AS origin_id_19 FROM kuma_node_translations k0_ INNER JOIN kuma_nodes k2_ ON k0_ . node_id = k2_ . id AND (k0_ . node_id = k2_ . id ) LEFT JOIN kuma_node_versions k1_ ON k0_ . public_node_version_id = k1_ . id AND (k0_ . public_node_version_id = k1_ . id ) WHERE k2_ . deleted = ? AND k0_ . lang = ? AND k0_ . url = ? ORDER BY k0_ . online DESC LIMIT 1
Parameters :
[
0
"fr "
"nos-evenements/la-3eme-edition-de-la-foire-artisanale "
]
SELECT k0_ . lang AS lang_0 , k0_ . online AS online_1 , k0_ . title AS title_2 , k0_ . slug AS slug_3 , k0_ . url AS url_4 , k0_ . weight AS weight_5 , k0_ . created AS created_6 , k0_ . updated AS updated_7 , k0_ . id AS id_8 , k1_ . type AS type_9 , k1_ . owner AS owner_10 , k1_ . created AS created_11 , k1_ . updated AS updated_12 , k1_ . ref_id AS ref_id_13 , k1_ . ref_entity_name AS ref_entity_name_14 , k1_ . id AS id_15 , k0_ . node_id AS node_id_16 , k0_ . public_node_version_id AS public_node_version_id_17 , k1_ . node_translation_id AS node_translation_id_18 , k1_ . origin_id AS origin_id_19 FROM kuma_node_translations k0_ INNER JOIN kuma_nodes k2_ ON k0_ . node_id = k2_ . id AND (k0_ . node_id = k2_ . id ) LEFT JOIN kuma_node_versions k1_ ON k0_ . public_node_version_id = k1_ . id AND (k0_ . public_node_version_id = k1_ . id ) WHERE k2_ . deleted = 0 AND k0_ . lang = 'fr' AND k0_ . url = 'nos-evenements/la-3eme-edition-de-la-foire-artisanale' ORDER BY k0_ . online DESC LIMIT 1 ;
Copy
0.50 ms (7.63%)
3
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = ? AND e0_ . locale = ? AND e0_ . object_class = ?
Parameters :
[
"9 "
"fr "
"Kunstmaan\MediaBundle\Entity\Media "
]
SELECT e0_ . content AS content_0 , e0_ . field AS field_1 FROM ext_translations e0_ WHERE e0_ . foreign_key = '9' AND e0_ . locale = 'fr' AND e0_ . object_class = 'Kunstmaan\\MediaBundle\\Entity\\Media' ;
Copy
0.50 ms (7.55%)
2
SELECT t0 . type AS type_1 , t0 . owner AS owner_2 , t0 . created AS created_3 , t0 . updated AS updated_4 , t0 . ref_id AS ref_id_5 , t0 . ref_entity_name AS ref_entity_name_6 , t0 . id AS id_7 , t0 . node_translation_id AS node_translation_id_8 , t0 . origin_id AS origin_id_9 FROM kuma_node_versions t0 WHERE t0 . ref_id = ? AND t0 . ref_entity_name = ? LIMIT 1
Parameters :
[
"3 "
"App\Entity\Pages\EventPage "
]
SELECT t0 . type AS type_1 , t0 . owner AS owner_2 , t0 . created AS created_3 , t0 . updated AS updated_4 , t0 . ref_id AS ref_id_5 , t0 . ref_entity_name AS ref_entity_name_6 , t0 . id AS id_7 , t0 . node_translation_id AS node_translation_id_8 , t0 . origin_id AS origin_id_9 FROM kuma_node_versions t0 WHERE t0 . ref_id = '3' AND t0 . ref_entity_name = 'App\\Entity\\Pages\\EventPage' LIMIT 1 ;
Copy
0.37 ms (5.62%)
1
SELECT t0 . category_label AS category_label_1 , t0 . location AS location_2 , t0 . registration_url AS registration_url_3 , t0 . date AS date_4 , t0 . summary AS summary_5 , t0 . title AS title_6 , t0 . page_title AS page_title_7 , t0 . id AS id_8 , t0 . cover_image_id AS cover_image_id_9 FROM app_event_pages t0 WHERE t0 . id = ?
SELECT t0 . category_label AS category_label_1 , t0 . location AS location_2 , t0 . registration_url AS registration_url_3 , t0 . date AS date_4 , t0 . summary AS summary_5 , t0 . title AS title_6 , t0 . page_title AS page_title_7 , t0 . id AS id_8 , t0 . cover_image_id AS cover_image_id_9 FROM app_event_pages t0 WHERE t0 . id = '2' ;
Copy
0.36 ms (5.40%)
1
SELECT t0 . id AS id_1 , t0 . pageId AS pageId_2 , t0 . pageEntityname AS pageEntityname_3 , t0 . context AS context_4 , t0 . sequencenumber AS sequencenumber_5 , t0 . page_part_id AS page_part_id_6 , t0 . page_part_entityname AS page_part_entityname_7 , t0 . created AS created_8 , t0 . updated AS updated_9 FROM kuma_page_part_refs t0 WHERE t0 . pageId = ? AND t0 . pageEntityname = ? AND t0 . context = ? ORDER BY t0 . sequencenumber ASC
Parameters :
[
"2 "
"App\Entity\Pages\EventPage "
"main "
]
SELECT t0 . id AS id_1 , t0 . pageId AS pageId_2 , t0 . pageEntityname AS pageEntityname_3 , t0 . context AS context_4 , t0 . sequencenumber AS sequencenumber_5 , t0 . page_part_id AS page_part_id_6 , t0 . page_part_entityname AS page_part_entityname_7 , t0 . created AS created_8 , t0 . updated AS updated_9 FROM kuma_page_part_refs t0 WHERE t0 . pageId = '2' AND t0 . pageEntityname = 'App\\Entity\\Pages\\EventPage' AND t0 . context = 'main' ORDER BY t0 . sequencenumber ASC ;
Copy
0.34 ms (5.13%)
1
SELECT redirect . id FROM kuma_redirects redirect WHERE (? LIKE REPLACE (redirect . origin , '*' , '%' )) AND ((redirect . domain IS NULL ) OR (redirect . domain = '' ) OR (redirect . domain = ? ))
Parameters :
[
"/nos-evenements/la-3eme-edition-de-la-foire-artisanale "
"www.stag.cciangazidja.com "
]
SELECT redirect . id FROM kuma_redirects redirect WHERE ('/nos-evenements/la-3eme-edition-de-la-foire-artisanale' LIKE REPLACE (redirect . origin , '*' , '%' )) AND ((redirect . domain IS NULL ) OR (redirect . domain = '' ) OR (redirect . domain = 'www.stag.cciangazidja.com' ));
Copy
0.34 ms (5.10%)
1
SELECT t0 . page_id AS page_id_1 , t0 . page_entity_name AS page_entity_name_2 , t0 . page_template AS page_template_3 , t0 . id AS id_4 FROM kuma_page_template_configuration t0 WHERE t0 . page_id = ? AND t0 . page_entity_name = ? LIMIT 1
Parameters :
[
"2 "
"App\Entity\Pages\EventPage "
]
SELECT t0 . page_id AS page_id_1 , t0 . page_entity_name AS page_entity_name_2 , t0 . page_template AS page_template_3 , t0 . id AS id_4 FROM kuma_page_template_configuration t0 WHERE t0 . page_id = '2' AND t0 . page_entity_name = 'App\\Entity\\Pages\\EventPage' LIMIT 1 ;
Copy
0.32 ms (4.80%)
1
SELECT t0 . meta_title AS meta_title_1 , t0 . meta_description AS meta_description_2 , t0 . meta_author AS meta_author_3 , t0 . meta_robots AS meta_robots_4 , t0 . og_type AS og_type_5 , t0 . og_title AS og_title_6 , t0 . og_description AS og_description_7 , t0 . extra_metadata AS extra_metadata_8 , t0 . ref_id AS ref_id_9 , t0 . ref_entity_name AS ref_entity_name_10 , t0 . og_url AS og_url_11 , t0 . og_article_author AS og_article_author_12 , t0 . og_article_publisher AS og_article_publisher_13 , t0 . og_article_section AS og_article_section_14 , t0 . twitter_title AS twitter_title_15 , t0 . twitter_description AS twitter_description_16 , t0 . twitter_site AS twitter_site_17 , t0 . twitter_creator AS twitter_creator_18 , t0 . id AS id_19 , t0 . og_image_id AS og_image_id_20 , t0 . twitter_image_id AS twitter_image_id_21 FROM kuma_seo t0 WHERE t0 . ref_id = ? AND t0 . ref_entity_name = ? LIMIT 1
Parameters :
[
"2 "
"App\Entity\Pages\EventPage "
]
SELECT t0 . meta_title AS meta_title_1 , t0 . meta_description AS meta_description_2 , t0 . meta_author AS meta_author_3 , t0 . meta_robots AS meta_robots_4 , t0 . og_type AS og_type_5 , t0 . og_title AS og_title_6 , t0 . og_description AS og_description_7 , t0 . extra_metadata AS extra_metadata_8 , t0 . ref_id AS ref_id_9 , t0 . ref_entity_name AS ref_entity_name_10 , t0 . og_url AS og_url_11 , t0 . og_article_author AS og_article_author_12 , t0 . og_article_publisher AS og_article_publisher_13 , t0 . og_article_section AS og_article_section_14 , t0 . twitter_title AS twitter_title_15 , t0 . twitter_description AS twitter_description_16 , t0 . twitter_site AS twitter_site_17 , t0 . twitter_creator AS twitter_creator_18 , t0 . id AS id_19 , t0 . og_image_id AS og_image_id_20 , t0 . twitter_image_id AS twitter_image_id_21 FROM kuma_seo t0 WHERE t0 . ref_id = '2' AND t0 . ref_entity_name = 'App\\Entity\\Pages\\EventPage' LIMIT 1 ;
Copy
0.30 ms (4.48%)
1
SELECT k0_ . locale AS locale_0 , k0_ . domain AS domain_1 FROM kuma_translation k0_ GROUP BY k0_ . locale , k0_ . domain
SELECT k0_ . locale AS locale_0 , k0_ . domain AS domain_1 FROM kuma_translation k0_ GROUP BY k0_ . locale , k0_ . domain ;
Copy
0.28 ms (4.25%)
1
SELECT t0 . lft AS lft_1 , t0 . lvl AS lvl_2 , t0 . rgt AS rgt_3 , t0 . deleted AS deleted_4 , t0 . hidden_from_nav AS hidden_from_nav_5 , t0 . ref_entity_name AS ref_entity_name_6 , t0 . internal_name AS internal_name_7 , t0 . id AS id_8 , t0 . parent_id AS parent_id_9 FROM kuma_nodes t0 WHERE t0 . id = ?
SELECT t0 . lft AS lft_1 , t0 . lvl AS lvl_2 , t0 . rgt AS rgt_3 , t0 . deleted AS deleted_4 , t0 . hidden_from_nav AS hidden_from_nav_5 , t0 . ref_entity_name AS ref_entity_name_6 , t0 . internal_name AS internal_name_7 , t0 . id AS id_8 , t0 . parent_id AS parent_id_9 FROM kuma_nodes t0 WHERE t0 . id = '24' ;
Copy
0.25 ms (3.82%)
1
SELECT t0 . content AS content_1 , t0 . id AS id_2 FROM app_text_page_parts t0 WHERE t0 . id IN (? )
SELECT t0 . content AS content_1 , t0 . id AS id_2 FROM app_text_page_parts t0 WHERE t0 . id IN ('6' );
Copy
0.22 ms (3.39%)
1
SELECT DATABASE ()
0.21 ms (3.22%)
1
SELECT k0_ . lft AS lft_0 , k0_ . lvl AS lvl_1 , k0_ . rgt AS rgt_2 , k0_ . deleted AS deleted_3 , k0_ . hidden_from_nav AS hidden_from_nav_4 , k0_ . ref_entity_name AS ref_entity_name_5 , k0_ . internal_name AS internal_name_6 , k0_ . id AS id_7 , k1_ . lang AS lang_8 , k1_ . online AS online_9 , k1_ . title AS title_10 , k1_ . slug AS slug_11 , k1_ . url AS url_12 , k1_ . weight AS weight_13 , k1_ . created AS created_14 , k1_ . updated AS updated_15 , k1_ . id AS id_16 , k2_ . type AS type_17 , k2_ . owner AS owner_18 , k2_ . created AS created_19 , k2_ . updated AS updated_20 , k2_ . ref_id AS ref_id_21 , k2_ . ref_entity_name AS ref_entity_name_22 , k2_ . id AS id_23 , k0_ . parent_id AS parent_id_24 , k1_ . node_id AS node_id_25 , k1_ . public_node_version_id AS public_node_version_id_26 , k2_ . node_translation_id AS node_translation_id_27 , k2_ . origin_id AS origin_id_28 FROM kuma_nodes k0_ LEFT JOIN kuma_node_translations k1_ ON k0_ . id = k1_ . node_id AND (k1_ . lang = ? ) LEFT JOIN kuma_node_versions k2_ ON k1_ . public_node_version_id = k2_ . id AND (k1_ . public_node_version_id = k2_ . id ) WHERE k0_ . deleted = ? AND ((k0_ . hidden_from_nav < > 1 OR k0_ . internal_name IS NOT NULL )) ORDER BY k1_ . weight ASC , k1_ . title ASC
SELECT k0_ . lft AS lft_0 , k0_ . lvl AS lvl_1 , k0_ . rgt AS rgt_2 , k0_ . deleted AS deleted_3 , k0_ . hidden_from_nav AS hidden_from_nav_4 , k0_ . ref_entity_name AS ref_entity_name_5 , k0_ . internal_name AS internal_name_6 , k0_ . id AS id_7 , k1_ . lang AS lang_8 , k1_ . online AS online_9 , k1_ . title AS title_10 , k1_ . slug AS slug_11 , k1_ . url AS url_12 , k1_ . weight AS weight_13 , k1_ . created AS created_14 , k1_ . updated AS updated_15 , k1_ . id AS id_16 , k2_ . type AS type_17 , k2_ . owner AS owner_18 , k2_ . created AS created_19 , k2_ . updated AS updated_20 , k2_ . ref_id AS ref_id_21 , k2_ . ref_entity_name AS ref_entity_name_22 , k2_ . id AS id_23 , k0_ . parent_id AS parent_id_24 , k1_ . node_id AS node_id_25 , k1_ . public_node_version_id AS public_node_version_id_26 , k2_ . node_translation_id AS node_translation_id_27 , k2_ . origin_id AS origin_id_28 FROM kuma_nodes k0_ LEFT JOIN kuma_node_translations k1_ ON k0_ . id = k1_ . node_id AND (k1_ . lang = 'fr' ) LEFT JOIN kuma_node_versions k2_ ON k1_ . public_node_version_id = k2_ . id AND (k1_ . public_node_version_id = k2_ . id ) WHERE k0_ . deleted = 0 AND ((k0_ . hidden_from_nav < > 1 OR k0_ . internal_name IS NOT NULL )) ORDER BY k1_ . weight ASC , k1_ . title ASC ;
Copy