4.78 ms (59.59%)
21
SELECT w0_ . id AS id_0 , w0_ . name AS name_1 , w0_ . class AS class_2 , w0_ . code AS code_3 , w0_ . template AS template_4 , w0_ . is_deleted AS is_deleted_5 , w0_ . created_at AS created_at_6 , w0_ . updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE (w0_ . is_deleted , 0 ) = 0 AND w0_ . code = ?
Parameters :
[
"sliderBanner "
]
SELECT w0_ . id AS id_0 , w0_ . name AS name_1 , w0_ . class AS class_2 , w0_ . code AS code_3 , w0_ . template AS template_4 , w0_ . is_deleted AS is_deleted_5 , w0_ . created_at AS created_at_6 , w0_ . updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE (w0_ . is_deleted , 0 ) = 0 AND w0_ . code = 'sliderBanner' ;
Copy
0.78 ms (9.78%)
1
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . thumb AS thumb_2 , p0_ . description AS description_3 , p0_ . slug AS slug_4 , p0_ . principal_image AS principal_image_5 , p0_ . is_sold AS is_sold_6 , p0_ . top_position AS top_position_7 , p0_ . is_enabled AS is_enabled_8 , p0_ . keywords AS keywords_9 , p0_ . price AS price_10 , p0_ . price_ht AS price_ht_11 , p0_ . properties AS properties_12 , p0_ . max_cart_quantity AS max_cart_quantity_13 , p0_ . weight AS weight_14 , p0_ . variations AS variations_15 , p0_ . subtitle AS subtitle_16 , p0_ . is_deleted AS is_deleted_17 , p0_ . created_at AS created_at_18 , p0_ . updated_at AS updated_at_19 , p0_ . product_type_id AS product_type_id_20 , p0_ . author_id AS author_id_21 FROM product p0_ WHERE COALESCE (p0_ . is_enabled , 1 ) = 1 ORDER BY RAND () ASC LIMIT 3
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . thumb AS thumb_2 , p0_ . description AS description_3 , p0_ . slug AS slug_4 , p0_ . principal_image AS principal_image_5 , p0_ . is_sold AS is_sold_6 , p0_ . top_position AS top_position_7 , p0_ . is_enabled AS is_enabled_8 , p0_ . keywords AS keywords_9 , p0_ . price AS price_10 , p0_ . price_ht AS price_ht_11 , p0_ . properties AS properties_12 , p0_ . max_cart_quantity AS max_cart_quantity_13 , p0_ . weight AS weight_14 , p0_ . variations AS variations_15 , p0_ . subtitle AS subtitle_16 , p0_ . is_deleted AS is_deleted_17 , p0_ . created_at AS created_at_18 , p0_ . updated_at AS updated_at_19 , p0_ . product_type_id AS product_type_id_20 , p0_ . author_id AS author_id_21 FROM product p0_ WHERE COALESCE (p0_ . is_enabled , 1 ) = 1 ORDER BY RAND () ASC LIMIT 3 ;
Copy
0.50 ms (6.26%)
1
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . code AS code_2 , p0_ . slug AS slug_3 , p0_ . image_bkg AS image_bkg_4 , p0_ . header_image AS header_image_5 , p0_ . subtitle AS subtitle_6 , p0_ . is_home AS is_home_7 , p0_ . header_type AS header_type_8 , p0_ . header_detail AS header_detail_9 , p0_ . keywords AS keywords_10 , p0_ . transparent_menu AS transparent_menu_11 , p0_ . content AS content_12 , p0_ . is_deleted AS is_deleted_13 , p0_ . created_at AS created_at_14 , p0_ . updated_at AS updated_at_15 FROM page p0_ WHERE COALESCE (p0_ . is_deleted , 0 ) = 0 AND p0_ . is_home = ?
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . code AS code_2 , p0_ . slug AS slug_3 , p0_ . image_bkg AS image_bkg_4 , p0_ . header_image AS header_image_5 , p0_ . subtitle AS subtitle_6 , p0_ . is_home AS is_home_7 , p0_ . header_type AS header_type_8 , p0_ . header_detail AS header_detail_9 , p0_ . keywords AS keywords_10 , p0_ . transparent_menu AS transparent_menu_11 , p0_ . content AS content_12 , p0_ . is_deleted AS is_deleted_13 , p0_ . created_at AS created_at_14 , p0_ . updated_at AS updated_at_15 FROM page p0_ WHERE COALESCE (p0_ . is_deleted , 0 ) = 0 AND p0_ . is_home = 1 ;
Copy
0.37 ms (4.58%)
1
SELECT f0_ . id AS id_0 , f0_ . name AS name_1 , f0_ . description AS description_2 , f0_ . options AS options_3 , f0_ . price AS price_4 , f0_ . is_subscription_open AS is_subscription_open_5 , f0_ . payment_configuration AS payment_configuration_6 , f0_ . price_ht AS price_ht_7 , f0_ . is_in_top_bar AS is_in_top_bar_8 , f0_ . top_bar_message AS top_bar_message_9 , f0_ . is_deleted AS is_deleted_10 , f0_ . created_at AS created_at_11 , f0_ . updated_at AS updated_at_12 , f0_ . subscription_class_id AS subscription_class_id_13 , f0_ . product_type_id AS product_type_id_14 FROM formation f0_ WHERE COALESCE (f0_ . is_deleted , 0 ) = 0 AND f0_ . is_in_top_bar = ?
SELECT f0_ . id AS id_0 , f0_ . name AS name_1 , f0_ . description AS description_2 , f0_ . options AS options_3 , f0_ . price AS price_4 , f0_ . is_subscription_open AS is_subscription_open_5 , f0_ . payment_configuration AS payment_configuration_6 , f0_ . price_ht AS price_ht_7 , f0_ . is_in_top_bar AS is_in_top_bar_8 , f0_ . top_bar_message AS top_bar_message_9 , f0_ . is_deleted AS is_deleted_10 , f0_ . created_at AS created_at_11 , f0_ . updated_at AS updated_at_12 , f0_ . subscription_class_id AS subscription_class_id_13 , f0_ . product_type_id AS product_type_id_14 FROM formation f0_ WHERE COALESCE (f0_ . is_deleted , 0 ) = 0 AND f0_ . is_in_top_bar = 1 ;
Copy
0.31 ms (3.89%)
1
SELECT b0_ . id AS id_0 , b0_ . name AS name_1 , b0_ . title AS title_2 , b0_ . image AS image_3 , b0_ . bkg AS bkg_4 , b0_ . is_visible AS is_visible_5 , b0_ . full_content AS full_content_6 , b0_ . with_text AS with_text_7 , b0_ . type AS type_8 , b0_ . overlay_background AS overlay_background_9 , b0_ . text AS text_10 , b0_ . link_type AS link_type_11 , b0_ . link_text AS link_text_12 , b0_ . bkg_color AS bkg_color_13 , b0_ . bkg_video AS bkg_video_14 , b0_ . link AS link_15 , b0_ . link_color AS link_color_16 , b0_ . link_hover_color AS link_hover_color_17 , b0_ . link_text_color AS link_text_color_18 , b0_ . link_text_hover_color AS link_text_hover_color_19 , b0_ . is_deleted AS is_deleted_20 , b0_ . created_at AS created_at_21 , b0_ . updated_at AS updated_at_22 FROM banner b0_ WHERE COALESCE (b0_ . is_deleted , 0 ) = 0 AND b0_ . id IN (? )
SELECT b0_ . id AS id_0 , b0_ . name AS name_1 , b0_ . title AS title_2 , b0_ . image AS image_3 , b0_ . bkg AS bkg_4 , b0_ . is_visible AS is_visible_5 , b0_ . full_content AS full_content_6 , b0_ . with_text AS with_text_7 , b0_ . type AS type_8 , b0_ . overlay_background AS overlay_background_9 , b0_ . text AS text_10 , b0_ . link_type AS link_type_11 , b0_ . link_text AS link_text_12 , b0_ . bkg_color AS bkg_color_13 , b0_ . bkg_video AS bkg_video_14 , b0_ . link AS link_15 , b0_ . link_color AS link_color_16 , b0_ . link_hover_color AS link_hover_color_17 , b0_ . link_text_color AS link_text_color_18 , b0_ . link_text_hover_color AS link_text_hover_color_19 , b0_ . is_deleted AS is_deleted_20 , b0_ . created_at AS created_at_21 , b0_ . updated_at AS updated_at_22 FROM banner b0_ WHERE COALESCE (b0_ . is_deleted , 0 ) = 0 AND b0_ . id IN (1 );
Copy
0.27 ms (3.32%)
1
SELECT p0_ . id AS id_0 , p0_ . parameter_key AS parameter_key_1 , p0_ . parameter_value AS parameter_value_2 , p0_ . parameter_label AS parameter_label_3 , p0_ . parameter_type AS parameter_type_4 , p0_ . parameter_category AS parameter_category_5 , p0_ . in_session AS in_session_6 , p0_ . parameter_category_enabled AS parameter_category_enabled_7 , p0_ . is_deleted AS is_deleted_8 , p0_ . created_at AS created_at_9 , p0_ . updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE (p0_ . is_deleted , 0 ) = 0 AND p0_ . parameter_key = ?
Parameters :
[
"currency "
]
SELECT p0_ . id AS id_0 , p0_ . parameter_key AS parameter_key_1 , p0_ . parameter_value AS parameter_value_2 , p0_ . parameter_label AS parameter_label_3 , p0_ . parameter_type AS parameter_type_4 , p0_ . parameter_category AS parameter_category_5 , p0_ . in_session AS in_session_6 , p0_ . parameter_category_enabled AS parameter_category_enabled_7 , p0_ . is_deleted AS is_deleted_8 , p0_ . created_at AS created_at_9 , p0_ . updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE (p0_ . is_deleted , 0 ) = 0 AND p0_ . parameter_key = 'currency' ;
Copy
0.26 ms (3.26%)
1
SELECT t0 . id AS id_1 , t0 . label AS label_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . is_enabled AS is_enabled_5 , t0 . is_deleted AS is_deleted_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . parent_id AS parent_id_9 , t0 . product_link_id AS product_link_id_10 FROM category t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = ?
SELECT t0 . id AS id_1 , t0 . label AS label_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . is_enabled AS is_enabled_5 , t0 . is_deleted AS is_deleted_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . parent_id AS parent_id_9 , t0 . product_link_id AS product_link_id_10 FROM category t0 INNER JOIN product_category ON t0 . id = product_category . category_id WHERE product_category . product_id = 28 ;
Copy
0.26 ms (3.21%)
1
SELECT pt . id , pt . name , pt . data , pt . type ,
CASE WHEN pt . type = 'PromotionProduct' THEN 999 ELSE 1 END AS priority ,
pt . date_end AS dateEnd
FROM promotion pt
WHERE pt . date_end > ?
AND (
(
pt . type = 'PromotionProduct'
AND CAST (JSON_UNQUOTE (JSON_EXTRACT (pt . data , '$.product' )) AS UNSIGNED ) IN (? )
)
OR pt . type IN ('PromotionProductType' , 'PromotionCategory' , 'PromotionProductGroup' )
)
Parameters :
[
"2026-11-17 "
28
]
SELECT pt . id , pt . name , pt . data , pt . type ,
CASE WHEN pt . type = 'PromotionProduct' THEN 999 ELSE 1 END AS priority ,
pt . date_end AS dateEnd
FROM promotion pt
WHERE pt . date_end > '2026-11-17'
AND (
(
pt . type = 'PromotionProduct'
AND CAST (JSON_UNQUOTE (JSON_EXTRACT (pt . data , '$.product' )) AS UNSIGNED ) IN (28 )
)
OR pt . type IN ('PromotionProductType' , 'PromotionCategory' , 'PromotionProductGroup' )
)
;
Copy
0.25 ms (3.11%)
1
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . data AS data_2 , p0_ . type AS type_3 , CASE WHEN p0_ . type = 'PromotionProduct' THEN 999 ELSE 1 END AS sclr_4 , p0_ . date_end AS date_end_5 FROM promotion p0_ WHERE (p0_ . type = 'PromotionProductType' AND p0_ . date_end > = ? ) OR (p0_ . type = 'PromotionProductGroup' AND p0_ . date_end > = ? ) OR (p0_ . type = 'PromotionCategory' AND p0_ . date_end > = ? )
Parameters :
[
"2026-11-17 11:41:58 "
"2026-11-17 11:41:58 "
"2026-11-17 11:41:58 "
]
SELECT p0_ . id AS id_0 , p0_ . name AS name_1 , p0_ . data AS data_2 , p0_ . type AS type_3 , CASE WHEN p0_ . type = 'PromotionProduct' THEN 999 ELSE 1 END AS sclr_4 , p0_ . date_end AS date_end_5 FROM promotion p0_ WHERE (p0_ . type = 'PromotionProductType' AND p0_ . date_end > = '2026-11-17 11:41:58' ) OR (p0_ . type = 'PromotionProductGroup' AND p0_ . date_end > = '2026-11-17 11:41:58' ) OR (p0_ . type = 'PromotionCategory' AND p0_ . date_end > = '2026-11-17 11:41:58' );
Copy
0.24 ms (3.00%)
1
SELECT l0_ . id AS id_0 , l0_ . name AS name_1 , l0_ . description AS description_2 , l0_ . video_link AS video_link_3 , l0_ . duration AS duration_4 , l0_ . is_video_uploaded AS is_video_uploaded_5 , l0_ . type AS type_6 , l0_ . validation_comments AS validation_comments_7 , l0_ . content AS content_8 , l0_ . is_deleted AS is_deleted_9 , l0_ . created_at AS created_at_10 , l0_ . updated_at AS updated_at_11 , l0_ . author_id AS author_id_12 , l0_ . status_id AS status_id_13 , l0_ . cours_id AS cours_id_14 FROM lesson l0_ WHERE COALESCE (l0_ . is_deleted , 0 ) = 0 AND l0_ . id IN (? , ? )
SELECT l0_ . id AS id_0 , l0_ . name AS name_1 , l0_ . description AS description_2 , l0_ . video_link AS video_link_3 , l0_ . duration AS duration_4 , l0_ . is_video_uploaded AS is_video_uploaded_5 , l0_ . type AS type_6 , l0_ . validation_comments AS validation_comments_7 , l0_ . content AS content_8 , l0_ . is_deleted AS is_deleted_9 , l0_ . created_at AS created_at_10 , l0_ . updated_at AS updated_at_11 , l0_ . author_id AS author_id_12 , l0_ . status_id AS status_id_13 , l0_ . cours_id AS cours_id_14 FROM lesson l0_ WHERE COALESCE (l0_ . is_deleted , 0 ) = 0 AND l0_ . id IN (59 , 60 );
Copy