Symfony Profiler

Query Metrics

42 Database Queries

15 Different statements

7.96 ms Query time

5 Invalid entities

Queries


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_.is_deleted AS is_deleted_16, p0_.product_type_id AS product_type_id_17 FROM product p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.slug = ?
SELECT t0.number AS number_1, t0.date AS date_2, t0.num_order AS num_order_3, t0.ean AS ean_4, t0.id AS id_5, t0.is_deleted AS is_deleted_6 FROM isbn t0 WHERE t0.id = ?
SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.website AS website_3, t0.id AS id_4, t0.is_deleted AS is_deleted_5 FROM author t0 WHERE t0.id = ?
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 product p1_ INNER JOIN product_type p2_ ON p1_.product_type_id = p2_.id INNER JOIN product_category p4_ ON p1_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id LEFT JOIN promotion p0_ ON (p0_.type = 'PromotionProduct' AND REPLACE(JSON_EXTRACT(p0_.data, '$.product'), '\"', '') = p1_.id) WHERE p1_.id IN (?) AND p0_.date_end > ?
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 >= ?)
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 FROM widget w0_
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.data AS data_3, p0_.date_start AS date_start_4, p0_.date_end AS date_end_5, p0_.on_top AS on_top_6, p0_.is_deleted AS is_deleted_7 FROM promotion p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.on_top = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
SELECT t0.id AS id_1, t0.link_name AS link_name_2, t0.url AS url_3, t0.on_top AS on_top_4, t0.ordre AS ordre_5, t0.visibility AS visibility_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8 FROM menu t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM page t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM page t0 WHERE t0.id = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.is_enabled AS is_enabled_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 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.is_enabled AS is_enabled_4, t0.image AS image_5, t0.is_deleted AS is_deleted_6 FROM product_type t0 WHERE t0.id = ?
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_.is_deleted AS is_deleted_16, p0_.product_type_id AS product_type_id_17 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE COALESCE(p0_.is_enabled, 1) = 1 AND (c1_.label IN (?) AND p0_.id <> ?) ORDER BY RAND() ASC LIMIT 4
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 product p1_ INNER JOIN product_type p2_ ON p1_.product_type_id = p2_.id INNER JOIN product_category p4_ ON p1_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id LEFT JOIN promotion p0_ ON (p0_.type = 'PromotionProduct' AND REPLACE(JSON_EXTRACT(p0_.data, '$.product'), '\"', '') = p1_.id) WHERE p0_.date_end > ?
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 >= ?)
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.footer_name AS footer_name_3, p0_.content AS content_4, p0_.is_deleted AS is_deleted_5 FROM policy_term p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?

#▲	Time	Info
1	1.04 ms	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_.is_deleted AS is_deleted_16, p0_.product_type_id AS product_type_id_17 FROM product p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.slug = ? Parameters: [`"carnetdescouples"`] View formatted query View runnable query Explain query 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_.is_deleted AS is_deleted_16, p0_.product_type_id AS product_type_id_17 FROM product p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.slug = ? 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_.is_deleted AS is_deleted_16, p0_.product_type_id AS product_type_id_17 FROM product p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.slug = 'carnetdescouples';
2	0.18 ms	SELECT t0.number AS number_1, t0.date AS date_2, t0.num_order AS num_order_3, t0.ean AS ean_4, t0.id AS id_5, t0.is_deleted AS is_deleted_6 FROM isbn t0 WHERE t0.id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.number AS number_1, t0.date AS date_2, t0.num_order AS num_order_3, t0.ean AS ean_4, t0.id AS id_5, t0.is_deleted AS is_deleted_6 FROM isbn t0 WHERE t0.id = ? SELECT t0.number AS number_1, t0.date AS date_2, t0.num_order AS num_order_3, t0.ean AS ean_4, t0.id AS id_5, t0.is_deleted AS is_deleted_6 FROM isbn t0 WHERE t0.id = 4;
3	0.13 ms	SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.website AS website_3, t0.id AS id_4, t0.is_deleted AS is_deleted_5 FROM author t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.website AS website_3, t0.id AS id_4, t0.is_deleted AS is_deleted_5 FROM author t0 WHERE t0.id = ? SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.website AS website_3, t0.id AS id_4, t0.is_deleted AS is_deleted_5 FROM author t0 WHERE t0.id = 1;
4	0.57 ms	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 product p1_ INNER JOIN product_type p2_ ON p1_.product_type_id = p2_.id INNER JOIN product_category p4_ ON p1_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id LEFT JOIN promotion p0_ ON (p0_.type = 'PromotionProduct' AND REPLACE(JSON_EXTRACT(p0_.data, '$.product'), '\"', '') = p1_.id) WHERE p1_.id IN (?) AND p0_.date_end > ? Parameters: [`5 "2025-01-22 04:13:56"`] View formatted query View runnable query Explain query 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 product p1_ INNER JOIN product_type p2_ ON p1_.product_type_id = p2_.id INNER JOIN product_category p4_ ON p1_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id LEFT JOIN promotion p0_ ON ( p0_.type = 'PromotionProduct' AND REPLACE( JSON_EXTRACT(p0_.data, '$.product'), '\"', '' ) = p1_.id ) WHERE p1_.id IN (?) AND p0_.date_end > ? 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 product p1_ INNER JOIN product_type p2_ ON p1_.product_type_id = p2_.id INNER JOIN product_category p4_ ON p1_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id LEFT JOIN promotion p0_ ON (p0_.type = 'PromotionProduct' AND REPLACE(JSON_EXTRACT(p0_.data, '$.product'), '\"', '') = p1_.id) WHERE p1_.id IN (5) AND p0_.date_end > '2025-01-22 04:13:56';
5	0.32 ms	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: [`"2025-01-22 04:13:56" "2025-01-22 04:13:56" "2025-01-22 04:13:56"`] View formatted query View runnable query Explain query 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 >= ? ) 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 >= '2025-01-22 04:13:56') OR (p0_.type = 'PromotionProductGroup' AND p0_.date_end >= '2025-01-22 04:13:56') OR (p0_.type = 'PromotionCategory' AND p0_.date_end >= '2025-01-22 04:13:56');
6	0.17 ms	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 FROM widget w0_ Parameters: [] View formatted query View runnable query Explain query 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 FROM widget w0_ 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 FROM widget w0_;
7	0.20 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"name"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'name';
8	0.13 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"keyword"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'keyword';
9	0.13 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"description"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'description';
10	0.11 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"favicon"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'favicon';
11	0.10 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"logo"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'logo';
12	0.11 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"google_recaptcha_type"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'google_recaptcha_type';
13	0.12 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"favicon"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'favicon';
14	0.12 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"name"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'name';
15	0.11 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"principalColor"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'principalColor';
16	0.11 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"secondaryColor"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'secondaryColor';
17	0.15 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"google_recaptcha_site_key"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'google_recaptcha_site_key';
18	0.14 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.data AS data_3, p0_.date_start AS date_start_4, p0_.date_end AS date_end_5, p0_.on_top AS on_top_6, p0_.is_deleted AS is_deleted_7 FROM promotion p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.on_top = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.data AS data_3, p0_.date_start AS date_start_4, p0_.date_end AS date_end_5, p0_.on_top AS on_top_6, p0_.is_deleted AS is_deleted_7 FROM promotion p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.on_top = ? SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.data AS data_3, p0_.date_start AS date_start_4, p0_.date_end AS date_end_5, p0_.on_top AS on_top_6, p0_.is_deleted AS is_deleted_7 FROM promotion p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.on_top = 1;
19	0.11 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"logo"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'logo';
20	0.10 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"logo_s"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'logo_s';
21	0.12 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"logo"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'logo';
22	0.12 ms	SELECT t0.id AS id_1, t0.link_name AS link_name_2, t0.url AS url_3, t0.on_top AS on_top_4, t0.ordre AS ordre_5, t0.visibility AS visibility_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8 FROM menu t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.link_name AS link_name_2, t0.url AS url_3, t0.on_top AS on_top_4, t0.ordre AS ordre_5, t0.visibility AS visibility_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8 FROM menu t0 SELECT t0.id AS id_1, t0.link_name AS link_name_2, t0.url AS url_3, t0.on_top AS on_top_4, t0.ordre AS ordre_5, t0.visibility AS visibility_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8 FROM menu t0;
23	0.14 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM page t0 WHERE t0.id = ? Parameters: [`26`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM page t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM page t0 WHERE t0.id = 26;
24	0.11 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM page t0 WHERE t0.id = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM page t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM page t0 WHERE t0.id = 21;
25	0.12 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"currency"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'currency';
26	0.40 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.is_enabled AS is_enabled_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.is_enabled AS is_enabled_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 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.is_enabled AS is_enabled_4, t0.is_deleted AS is_deleted_5, t0.parent_id AS parent_id_6 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 5;
27	0.14 ms	SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.is_enabled AS is_enabled_4, t0.image AS image_5, t0.is_deleted AS is_deleted_6 FROM product_type t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.is_enabled AS is_enabled_4, t0.image AS image_5, t0.is_deleted AS is_deleted_6 FROM product_type t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.is_enabled AS is_enabled_4, t0.image AS image_5, t0.is_deleted AS is_deleted_6 FROM product_type t0 WHERE t0.id = 1;
28	0.65 ms	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_.is_deleted AS is_deleted_16, p0_.product_type_id AS product_type_id_17 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE COALESCE(p0_.is_enabled, 1) = 1 AND (c1_.label IN (?) AND p0_.id <> ?) ORDER BY RAND() ASC LIMIT 4 Parameters: [`"Couples, Famille" 5`] View formatted query View runnable query Explain query 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_.is_deleted AS is_deleted_16, p0_.product_type_id AS product_type_id_17 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE COALESCE(p0_.is_enabled, 1) = 1 AND ( c1_.label IN (?) AND p0_.id <> ? ) ORDER BY RAND() ASC LIMIT 4 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_.is_deleted AS is_deleted_16, p0_.product_type_id AS product_type_id_17 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE COALESCE(p0_.is_enabled, 1) = 1 AND (c1_.label IN ('Couples, Famille') AND p0_.id <> 5) ORDER BY RAND() ASC LIMIT 4;
29	0.39 ms	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 product p1_ INNER JOIN product_type p2_ ON p1_.product_type_id = p2_.id INNER JOIN product_category p4_ ON p1_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id LEFT JOIN promotion p0_ ON (p0_.type = 'PromotionProduct' AND REPLACE(JSON_EXTRACT(p0_.data, '$.product'), '\"', '') = p1_.id) WHERE p0_.date_end > ? Parameters: [`"2025-01-22 04:13:56"`] View formatted query View runnable query Explain query 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 product p1_ INNER JOIN product_type p2_ ON p1_.product_type_id = p2_.id INNER JOIN product_category p4_ ON p1_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id LEFT JOIN promotion p0_ ON ( p0_.type = 'PromotionProduct' AND REPLACE( JSON_EXTRACT(p0_.data, '$.product'), '\"', '' ) = p1_.id ) WHERE p0_.date_end > ? 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 product p1_ INNER JOIN product_type p2_ ON p1_.product_type_id = p2_.id INNER JOIN product_category p4_ ON p1_.id = p4_.product_id INNER JOIN category c3_ ON c3_.id = p4_.category_id LEFT JOIN promotion p0_ ON (p0_.type = 'PromotionProduct' AND REPLACE(JSON_EXTRACT(p0_.data, '$.product'), '\"', '') = p1_.id) WHERE p0_.date_end > '2025-01-22 04:13:56';
30	0.14 ms	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: [`"2025-01-22 04:13:56" "2025-01-22 04:13:56" "2025-01-22 04:13:56"`] View formatted query View runnable query Explain query 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 >= ? ) 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 >= '2025-01-22 04:13:56') OR (p0_.type = 'PromotionProductGroup' AND p0_.date_end >= '2025-01-22 04:13:56') OR (p0_.type = 'PromotionCategory' AND p0_.date_end >= '2025-01-22 04:13:56');
31	0.13 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"currency"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'currency';
32	0.12 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"logo_s"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'logo_s';
33	0.12 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"slogan"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'slogan';
34	0.11 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"facebook"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'facebook';
35	0.11 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"twitter"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'twitter';
36	0.12 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"instagram"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'instagram';
37	0.12 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"linkedin"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'linkedin';
38	0.12 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"youtube"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'youtube';
39	0.14 ms	SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.footer_name AS footer_name_3, p0_.content AS content_4, p0_.is_deleted AS is_deleted_5 FROM policy_term p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.footer_name AS footer_name_3, p0_.content AS content_4, p0_.is_deleted AS is_deleted_5 FROM policy_term p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.footer_name AS footer_name_3, p0_.content AS content_4, p0_.is_deleted AS is_deleted_5 FROM policy_term p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0;
40	0.13 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"name"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'name';
41	0.11 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"google_analytics"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'google_analytics';
42	0.11 ms	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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? Parameters: [`"google_recaptcha_site_key"`] View formatted query View runnable query Explain query 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ? 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 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = 'google_recaptcha_site_key';

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\Sentence	No errors.
App\Entity\Mail	No errors.
App\Entity\Author	The target entity 'GraphLife\CMSPaymentBundle\Entity\Product' specified on App\Entity\Author#products is unknown or not an entity.
App\Entity\ExternalOrder	No errors.
App\Entity\KindleOrder	No errors.
App\Entity\ISBN	No errors.
Graphlife\CMSBundle\Entity\User	No errors.
Graphlife\CMSBundle\Entity\PostCategory	No errors.
Graphlife\CMSBundle\Entity\Country	No errors.
Graphlife\CMSBundle\Entity\Post	No errors.
Graphlife\CMSBundle\Entity\Page	No errors.
Graphlife\CMSBundle\Entity\Email	No errors.
Graphlife\CMSBundle\Entity\Parameter	No errors.
Graphlife\CMSBundle\Entity\Notification	The association Graphlife\CMSBundle\Entity\Notification#user refers to the inverse side field Graphlife\CMSBundle\Entity\User#notifications which does not exist.
Graphlife\CMSBundle\Entity\Widget	No errors.
Graphlife\CMSBundle\Entity\Banner	No errors.
Graphlife\CMSBundle\Entity\NewsletterEmail	No errors.
Graphlife\CMSBundle\Entity\ParameterCategory	No errors.
Graphlife\CMSBundle\Entity\PolicyTerm	No errors.
Graphlife\CMSBundle\Entity\Menu	No errors.
Graphlife\CMSPaymentBundle\Entity\Shippment	The association Graphlife\CMSPaymentBundle\Entity\Shippment#payment refers to the inverse side field Graphlife\CMSPaymentBundle\Entity\Payment#shippment which does not exist.
Graphlife\CMSPaymentBundle\Entity\ProductType	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentPlan	No errors.
Graphlife\CMSPaymentBundle\Entity\Promotion	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentStatus	No errors.
Graphlife\CMSPaymentBundle\Entity\ShippmentStatus	No errors.
Graphlife\CMSPaymentBundle\Entity\Payment	The mappings Graphlife\CMSPaymentBundle\Entity\Payment#shippments and Graphlife\CMSPaymentBundle\Entity\Shippment#payment are inconsistent with each other. The association Graphlife\CMSPaymentBundle\Entity\Payment#user refers to the inverse side field Graphlife\CMSBundle\Entity\User#payments which does not exist.
Graphlife\CMSPaymentBundle\Entity\Transaction	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentMethod	No errors.
Graphlife\CMSPaymentBundle\Entity\Category	No errors.
Graphlife\CMSPaymentBundle\Entity\Currency	No errors.
Graphlife\CMSPaymentBundle\Entity\Transporter	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductImage	No errors.
Graphlife\CMSPaymentBundle\Entity\Product	No errors.
Graphlife\CMSPaymentBundle\Entity\CodePromo	No errors.
Graphlife\CMSPaymentBundle\Entity\Stock	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductTax	No errors.
Graphlife\CMSPaymentBundle\Entity\ShippingMethod	The association Graphlife\CMSPaymentBundle\Entity\ShippingMethod#countries refers to the inverse side field Graphlife\CMSBundle\Entity\Country#shippingMethods which does not exist.

Symfony Profiler

GET https://jacquesmbalanda.com/boutique/product/carnetdescouples

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping