1
0.82 ms
SELECT t0 . id AS id_1 , t0 . lang AS lang_2 , t0 . label AS label_3 FROM langs t0 WHERE t0 . lang = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . lang AS lang_2 , t0 . label AS label_3 FROM langs t0 WHERE t0 . lang = 'it' LIMIT 1 ; Copy
2
0.97 ms
SELECT c0_ . id AS id_0 , c0_ . custom_category AS custom_category_1 , c0_ . ordine AS ordine_2 , c0_ . is_online AS is_online_3 , c0_ . show_in_menu AS show_in_menu_4 , c1_ . category_name AS category_name_5 , c1_ . category_url AS category_url_6 , c1_ . meta_title AS meta_title_7 , c1_ . meta_description AS meta_description_8 , c1_ . frontend_description AS frontend_description_9 , c1_ . meta_h1 AS meta_h1_10 , c1_ . meta_h2 AS meta_h2_11 , c0_ . parent_id AS parent_id_12 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c1_ . category_url = ? AND c1_ . lang_id = ?
Parameters :
[
"collezioni "
1
]
SELECT c0_ . id AS id_0 , c0_ . custom_category AS custom_category_1 , c0_ . ordine AS ordine_2 , c0_ . is_online AS is_online_3 , c0_ . show_in_menu AS show_in_menu_4 , c1_ . category_name AS category_name_5 , c1_ . category_url AS category_url_6 , c1_ . meta_title AS meta_title_7 , c1_ . meta_description AS meta_description_8 , c1_ . frontend_description AS frontend_description_9 , c1_ . meta_h1 AS meta_h1_10 , c1_ . meta_h2 AS meta_h2_11 , c0_ . parent_id AS parent_id_12 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c1_ . category_url = 'collezioni' AND c1_ . lang_id = 1 ; Copy
3
0.99 ms
SELECT c0_ . id AS id_0 , c0_ . custom_category AS custom_category_1 , c0_ . ordine AS ordine_2 , c0_ . is_online AS is_online_3 , c0_ . show_in_menu AS show_in_menu_4 , c1_ . category_name AS category_name_5 , c1_ . category_url AS category_url_6 , c1_ . meta_title AS meta_title_7 , c1_ . meta_description AS meta_description_8 , c1_ . frontend_description AS frontend_description_9 , c1_ . meta_h1 AS meta_h1_10 , c1_ . meta_h2 AS meta_h2_11 , c0_ . parent_id AS parent_id_12 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c1_ . category_url = ? AND c1_ . lang_id = ? AND c0_ . parent_id = ?
Parameters :
[
"colorado "
1
9
]
SELECT c0_ . id AS id_0 , c0_ . custom_category AS custom_category_1 , c0_ . ordine AS ordine_2 , c0_ . is_online AS is_online_3 , c0_ . show_in_menu AS show_in_menu_4 , c1_ . category_name AS category_name_5 , c1_ . category_url AS category_url_6 , c1_ . meta_title AS meta_title_7 , c1_ . meta_description AS meta_description_8 , c1_ . frontend_description AS frontend_description_9 , c1_ . meta_h1 AS meta_h1_10 , c1_ . meta_h2 AS meta_h2_11 , c0_ . parent_id AS parent_id_12 FROM custom_categories c0_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c1_ . category_url = 'colorado' AND c1_ . lang_id = 1 AND c0_ . parent_id = 9 ; Copy
4
0.64 ms
SELECT t0 . id AS id_1 , t0 . region_name AS region_name_2 , t0 . region_code AS region_code_3 , t0 . ordine AS ordine_4 , t0 . lang_id AS lang_id_5 , t0 . currency_id AS currency_id_6 FROM shipping_regions t0 WHERE t0 . region_code = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . region_name AS region_name_2 , t0 . region_code AS region_code_3 , t0 . ordine AS ordine_4 , t0 . lang_id AS lang_id_5 , t0 . currency_id AS currency_id_6 FROM shipping_regions t0 WHERE t0 . region_code = 'it' LIMIT 1 ; Copy
5
0.36 ms
SELECT t0 . id AS id_1 , t0 . region_name AS region_name_2 , t0 . region_code AS region_code_3 , t0 . ordine AS ordine_4 , t0 . lang_id AS lang_id_5 , t0 . currency_id AS currency_id_6 FROM shipping_regions t0 WHERE t0 . region_code = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . region_name AS region_name_2 , t0 . region_code AS region_code_3 , t0 . ordine AS ordine_4 , t0 . lang_id AS lang_id_5 , t0 . currency_id AS currency_id_6 FROM shipping_regions t0 WHERE t0 . region_code = 'it' LIMIT 1 ; Copy
6
0.36 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . symbol AS symbol_3 , t0 . label AS label_4 FROM currencies t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . symbol AS symbol_3 , t0 . label AS label_4 FROM currencies t0 WHERE t0 . id = 1 ; Copy
7
23.84 ms
SELECT DISTINCT p . * , pt . name AS translated_product_name , pt . description AS translated_product_description ,
(
SELECT c . color
FROM colors AS c
INNER JOIN products_skews AS ps ON ps . color_id = c . id AND ps . qty > 0
INNER JOIN skews_photos AS sp ON sp . product_id = ps . product_id AND sp . color_id = c . id
WHERE ps . product_id = p . id
AND ps . is_online = 1
LIMIT 1
) AS color ,
(
SELECT GROUP_CONCAT (DISTINCT (c . color ))
FROM colors AS c
INNER JOIN products_skews AS ps ON ps . color_id = c . id AND ps . qty > 0
INNER JOIN skews_photos AS sp ON sp . product_id = ps . product_id AND sp . color_id = c . id
WHERE ps . product_id = p . id
AND ps . is_online = 1
) AS available_colors ,
(
SELECT COUNT (br . id )
FROM custom_categories_products_br AS br
WHERE br . product_id = p . id
) AS nr_associations ,
(
SELECT MAX (price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS max_price ,
(
SELECT MIN (price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS min_price ,
(
SELECT MAX (discounted_price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND (pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-12-06 03:30:35' )
AND (pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-12-06 03:30:35' )
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS max_discounted_price ,
(
SELECT MIN (discounted_price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND (pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-12-06 03:30:35' )
AND (pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-12-06 03:30:35' )
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS min_discounted_price ,
(
SELECT GREATEST (MAX (price ), COALESCE (MAX (discounted_price ), 0 ))
FROM prices AS pr
WHERE pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
AND pr . currency_id = 1
) AS absolute_max_price ,
(
SELECT IF (
pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-12-06 03:30:35'
AND
pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-12-06 03:30:35' ,
LEAST (MIN (pr . price ), COALESCE (MIN (pr . discounted_price ), 999999 )),
MIN (pr . price )
)
FROM prices AS pr
WHERE pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
AND pr . currency_id = 1
) AS absolute_min_price ,
(
SELECT REPLACE (pdi . img_path , '400x570' , '400x400' )
FROM products_default_image AS pdi
WHERE pdi . product_id = p . id
) AS default_path ,
(
SELECT sp . photo_path_reduced
FROM skews_photos sp
INNER JOIN products_skews AS ps on ps . product_id = sp . product_id AND ps . color_id = sp . color_id
WHERE sp . product_id = p . id
AND ps . is_online = 1
LIMIT 1
) as path ,
(
SELECT SUM (qty ) FROM products_skews AS ps WHERE ps . product_id = p . id
) AS sum_global_qty ,
(
SELECT SUM (qty )
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . is_online = 1
) AS sum_online_qty ,
(
SELECT l . label
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND l . image IS NULL
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
LIMIT 0 , 1
) AS product_label ,
(
SELECT GROUP_CONCAT (l . image )
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
) AS product_icon_labels ,
(
SELECT GROUP_CONCAT (l . label )
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
AND l . image is NOT NULL
ORDER BY lpb . id DESC
) AS product_icon_labels_captions ,
(
SELECT l . exa_color
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND l . image IS NULL
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
LIMIT 0 , 1
) AS product_label_color ,
(
SELECT l . font_color
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND l . image IS NULL
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
LIMIT 0 , 1
) AS product_label_font_color ,
(
SELECT GROUP_CONCAT (pe . color_id )
FROM products_exploded AS pe
LEFT JOIN product_colors_order AS pco ON pco . product_id = pe . product_id AND pco . color_id = pe . color_id
WHERE pe . product_id = p . id AND pe . custom_category_id = 11 ORDER BY pco . sequence ASC , pe . ordine ASC
) AS exploded_colors , cco . ordine FROM products AS p
LEFT JOIN products_texts AS pt ON pt . product_id = p . id AND lang_id = 1 LEFT JOIN products_custom_category_order AS cco ON cco . product_id = p . id AND cco . custom_category_id IN (0 , 11 ) WHERE p . is_online = 1 AND p . id IN (
SELECT product_id
FROM custom_categories_products_br
WHERE custom_category_id IN (0 , 11 )
) HAVING min_price > 0
AND color IS NOT NULL
AND nr_associations > 0
AND sum_online_qty > 0
AND path ! = '' ORDER BY ordine ASC , absolute_min_price ASC LIMIT 8 , 8
SELECT DISTINCT p . * , pt . name AS translated_product_name , pt . description AS translated_product_description ,
(
SELECT c . color
FROM colors AS c
INNER JOIN products_skews AS ps ON ps . color_id = c . id AND ps . qty > 0
INNER JOIN skews_photos AS sp ON sp . product_id = ps . product_id AND sp . color_id = c . id
WHERE ps . product_id = p . id
AND ps . is_online = 1
LIMIT 1
) AS color ,
(
SELECT GROUP_CONCAT (DISTINCT (c . color ))
FROM colors AS c
INNER JOIN products_skews AS ps ON ps . color_id = c . id AND ps . qty > 0
INNER JOIN skews_photos AS sp ON sp . product_id = ps . product_id AND sp . color_id = c . id
WHERE ps . product_id = p . id
AND ps . is_online = 1
) AS available_colors ,
(
SELECT COUNT (br . id )
FROM custom_categories_products_br AS br
WHERE br . product_id = p . id
) AS nr_associations ,
(
SELECT MAX (price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS max_price ,
(
SELECT MIN (price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS min_price ,
(
SELECT MAX (discounted_price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND (pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-12-06 03:30:35' )
AND (pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-12-06 03:30:35' )
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS max_discounted_price ,
(
SELECT MIN (discounted_price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND (pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-12-06 03:30:35' )
AND (pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-12-06 03:30:35' )
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS min_discounted_price ,
(
SELECT GREATEST (MAX (price ), COALESCE (MAX (discounted_price ), 0 ))
FROM prices AS pr
WHERE pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
AND pr . currency_id = 1
) AS absolute_max_price ,
(
SELECT IF (
pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-12-06 03:30:35'
AND
pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-12-06 03:30:35' ,
LEAST (MIN (pr . price ), COALESCE (MIN (pr . discounted_price ), 999999 )),
MIN (pr . price )
)
FROM prices AS pr
WHERE pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
AND pr . currency_id = 1
) AS absolute_min_price ,
(
SELECT REPLACE (pdi . img_path , '400x570' , '400x400' )
FROM products_default_image AS pdi
WHERE pdi . product_id = p . id
) AS default_path ,
(
SELECT sp . photo_path_reduced
FROM skews_photos sp
INNER JOIN products_skews AS ps on ps . product_id = sp . product_id AND ps . color_id = sp . color_id
WHERE sp . product_id = p . id
AND ps . is_online = 1
LIMIT 1
) as path ,
(
SELECT SUM (qty ) FROM products_skews AS ps WHERE ps . product_id = p . id
) AS sum_global_qty ,
(
SELECT SUM (qty )
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . is_online = 1
) AS sum_online_qty ,
(
SELECT l . label
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND l . image IS NULL
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
LIMIT 0 , 1
) AS product_label ,
(
SELECT GROUP_CONCAT (l . image )
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
) AS product_icon_labels ,
(
SELECT GROUP_CONCAT (l . label )
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
AND l . image is NOT NULL
ORDER BY lpb . id DESC
) AS product_icon_labels_captions ,
(
SELECT l . exa_color
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND l . image IS NULL
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
LIMIT 0 , 1
) AS product_label_color ,
(
SELECT l . font_color
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND l . image IS NULL
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
LIMIT 0 , 1
) AS product_label_font_color ,
(
SELECT GROUP_CONCAT (pe . color_id )
FROM products_exploded AS pe
LEFT JOIN product_colors_order AS pco ON pco . product_id = pe . product_id AND pco . color_id = pe . color_id
WHERE pe . product_id = p . id AND pe . custom_category_id = 11 ORDER BY pco . sequence ASC , pe . ordine ASC
) AS exploded_colors , cco . ordine FROM products AS p
LEFT JOIN products_texts AS pt ON pt . product_id = p . id AND lang_id = 1 LEFT JOIN products_custom_category_order AS cco ON cco . product_id = p . id AND cco . custom_category_id IN (0 , 11 ) WHERE p . is_online = 1 AND p . id IN (
SELECT product_id
FROM custom_categories_products_br
WHERE custom_category_id IN (0 , 11 )
) HAVING min_price > 0
AND color IS NOT NULL
AND nr_associations > 0
AND sum_online_qty > 0
AND path ! = '' ORDER BY ordine ASC , absolute_min_price ASC LIMIT 8 , 8 ; Copy
8
20.94 ms
SELECT DISTINCT p . * , pt . name AS translated_product_name , pt . description AS translated_product_description ,
(
SELECT c . color
FROM colors AS c
INNER JOIN products_skews AS ps ON ps . color_id = c . id AND ps . qty > 0
INNER JOIN skews_photos AS sp ON sp . product_id = ps . product_id AND sp . color_id = c . id
WHERE ps . product_id = p . id
AND ps . is_online = 1
LIMIT 1
) AS color ,
(
SELECT GROUP_CONCAT (DISTINCT (c . color ))
FROM colors AS c
INNER JOIN products_skews AS ps ON ps . color_id = c . id AND ps . qty > 0
INNER JOIN skews_photos AS sp ON sp . product_id = ps . product_id AND sp . color_id = c . id
WHERE ps . product_id = p . id
AND ps . is_online = 1
) AS available_colors ,
(
SELECT COUNT (br . id )
FROM custom_categories_products_br AS br
WHERE br . product_id = p . id
) AS nr_associations ,
(
SELECT MAX (price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS max_price ,
(
SELECT MIN (price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS min_price ,
(
SELECT MAX (discounted_price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND (pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-12-06 03:30:35' )
AND (pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-12-06 03:30:35' )
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS max_discounted_price ,
(
SELECT MIN (discounted_price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND (pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-12-06 03:30:35' )
AND (pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-12-06 03:30:35' )
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS min_discounted_price ,
(
SELECT GREATEST (MAX (price ), COALESCE (MAX (discounted_price ), 0 ))
FROM prices AS pr
WHERE pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
AND pr . currency_id = 1
) AS absolute_max_price ,
(
SELECT IF (
pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-12-06 03:30:35'
AND
pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-12-06 03:30:35' ,
LEAST (MIN (pr . price ), COALESCE (MIN (pr . discounted_price ), 999999 )),
MIN (pr . price )
)
FROM prices AS pr
WHERE pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
AND pr . currency_id = 1
) AS absolute_min_price ,
(
SELECT REPLACE (pdi . img_path , '400x570' , '400x400' )
FROM products_default_image AS pdi
WHERE pdi . product_id = p . id
) AS default_path ,
(
SELECT sp . photo_path_reduced
FROM skews_photos sp
INNER JOIN products_skews AS ps on ps . product_id = sp . product_id AND ps . color_id = sp . color_id
WHERE sp . product_id = p . id
AND ps . is_online = 1
LIMIT 1
) as path ,
(
SELECT SUM (qty ) FROM products_skews AS ps WHERE ps . product_id = p . id
) AS sum_global_qty ,
(
SELECT SUM (qty )
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . is_online = 1
) AS sum_online_qty ,
(
SELECT l . label
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND l . image IS NULL
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
LIMIT 0 , 1
) AS product_label ,
(
SELECT GROUP_CONCAT (l . image )
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
) AS product_icon_labels ,
(
SELECT GROUP_CONCAT (l . label )
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
AND l . image is NOT NULL
ORDER BY lpb . id DESC
) AS product_icon_labels_captions ,
(
SELECT l . exa_color
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND l . image IS NULL
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
LIMIT 0 , 1
) AS product_label_color ,
(
SELECT l . font_color
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND l . image IS NULL
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
LIMIT 0 , 1
) AS product_label_font_color ,
(
SELECT GROUP_CONCAT (pe . color_id )
FROM products_exploded AS pe
LEFT JOIN product_colors_order AS pco ON pco . product_id = pe . product_id AND pco . color_id = pe . color_id
WHERE pe . product_id = p . id AND pe . custom_category_id = 11 ORDER BY pco . sequence ASC , pe . ordine ASC
) AS exploded_colors , cco . ordine FROM products AS p
LEFT JOIN products_texts AS pt ON pt . product_id = p . id AND lang_id = 1 LEFT JOIN products_custom_category_order AS cco ON cco . product_id = p . id AND cco . custom_category_id IN (0 , 11 ) WHERE p . is_online = 1 AND p . id IN (
SELECT product_id
FROM custom_categories_products_br
WHERE custom_category_id IN (0 , 11 )
) HAVING min_price > 0
AND color IS NOT NULL
AND nr_associations > 0
AND sum_online_qty > 0
AND path ! = '' ORDER BY ordine ASC , absolute_min_price ASC LIMIT 8 , 8
SELECT DISTINCT p . * , pt . name AS translated_product_name , pt . description AS translated_product_description ,
(
SELECT c . color
FROM colors AS c
INNER JOIN products_skews AS ps ON ps . color_id = c . id AND ps . qty > 0
INNER JOIN skews_photos AS sp ON sp . product_id = ps . product_id AND sp . color_id = c . id
WHERE ps . product_id = p . id
AND ps . is_online = 1
LIMIT 1
) AS color ,
(
SELECT GROUP_CONCAT (DISTINCT (c . color ))
FROM colors AS c
INNER JOIN products_skews AS ps ON ps . color_id = c . id AND ps . qty > 0
INNER JOIN skews_photos AS sp ON sp . product_id = ps . product_id AND sp . color_id = c . id
WHERE ps . product_id = p . id
AND ps . is_online = 1
) AS available_colors ,
(
SELECT COUNT (br . id )
FROM custom_categories_products_br AS br
WHERE br . product_id = p . id
) AS nr_associations ,
(
SELECT MAX (price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS max_price ,
(
SELECT MIN (price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS min_price ,
(
SELECT MAX (discounted_price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND (pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-12-06 03:30:35' )
AND (pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-12-06 03:30:35' )
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS max_discounted_price ,
(
SELECT MIN (discounted_price )
FROM prices AS pr
WHERE pr . shipping_region_id = 1
AND (pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-12-06 03:30:35' )
AND (pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-12-06 03:30:35' )
AND pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
) AS min_discounted_price ,
(
SELECT GREATEST (MAX (price ), COALESCE (MAX (discounted_price ), 0 ))
FROM prices AS pr
WHERE pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
AND pr . currency_id = 1
) AS absolute_max_price ,
(
SELECT IF (
pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-12-06 03:30:35'
AND
pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-12-06 03:30:35' ,
LEAST (MIN (pr . price ), COALESCE (MIN (pr . discounted_price ), 999999 )),
MIN (pr . price )
)
FROM prices AS pr
WHERE pr . skew_id IN (
SELECT ps . id
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . qty > 0
AND ps . is_online = 1
)
AND pr . currency_id = 1
) AS absolute_min_price ,
(
SELECT REPLACE (pdi . img_path , '400x570' , '400x400' )
FROM products_default_image AS pdi
WHERE pdi . product_id = p . id
) AS default_path ,
(
SELECT sp . photo_path_reduced
FROM skews_photos sp
INNER JOIN products_skews AS ps on ps . product_id = sp . product_id AND ps . color_id = sp . color_id
WHERE sp . product_id = p . id
AND ps . is_online = 1
LIMIT 1
) as path ,
(
SELECT SUM (qty ) FROM products_skews AS ps WHERE ps . product_id = p . id
) AS sum_global_qty ,
(
SELECT SUM (qty )
FROM products_skews AS ps
WHERE ps . product_id = p . id
AND ps . is_online = 1
) AS sum_online_qty ,
(
SELECT l . label
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND l . image IS NULL
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
LIMIT 0 , 1
) AS product_label ,
(
SELECT GROUP_CONCAT (l . image )
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
) AS product_icon_labels ,
(
SELECT GROUP_CONCAT (l . label )
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
AND l . image is NOT NULL
ORDER BY lpb . id DESC
) AS product_icon_labels_captions ,
(
SELECT l . exa_color
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND l . image IS NULL
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
LIMIT 0 , 1
) AS product_label_color ,
(
SELECT l . font_color
FROM labels_products_br AS lpb
INNER JOIN labels AS l ON l . id = lpb . label_id
WHERE lpb . product_id = p . id
AND l . image IS NULL
AND (l . valid_from IS NULL OR l . valid_from < = '2025-12-06 03:30:35' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-12-06 03:30:35' )
ORDER BY lpb . id DESC
LIMIT 0 , 1
) AS product_label_font_color ,
(
SELECT GROUP_CONCAT (pe . color_id )
FROM products_exploded AS pe
LEFT JOIN product_colors_order AS pco ON pco . product_id = pe . product_id AND pco . color_id = pe . color_id
WHERE pe . product_id = p . id AND pe . custom_category_id = 11 ORDER BY pco . sequence ASC , pe . ordine ASC
) AS exploded_colors , cco . ordine FROM products AS p
LEFT JOIN products_texts AS pt ON pt . product_id = p . id AND lang_id = 1 LEFT JOIN products_custom_category_order AS cco ON cco . product_id = p . id AND cco . custom_category_id IN (0 , 11 ) WHERE p . is_online = 1 AND p . id IN (
SELECT product_id
FROM custom_categories_products_br
WHERE custom_category_id IN (0 , 11 )
) HAVING min_price > 0
AND color IS NOT NULL
AND nr_associations > 0
AND sum_online_qty > 0
AND path ! = '' ORDER BY ordine ASC , absolute_min_price ASC LIMIT 8 , 8 ; Copy
9
0.68 ms
SELECT t0 . id AS id_1 , t0 . lang AS lang_2 , t0 . label AS label_3 FROM langs t0 WHERE t0 . lang = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . lang AS lang_2 , t0 . label AS label_3 FROM langs t0 WHERE t0 . lang = 'it' LIMIT 1 ; Copy
10
0.60 ms
SELECT s0_ . id AS id_0 , s0_ . type AS type_1 , s0_ . text AS text_2 , s0_ . exa_color AS exa_color_3 , s0_ . font_color AS font_color_4 , s0_ . valid_from AS valid_from_5 , s0_ . valid_to AS valid_to_6 FROM static_texts s0_ INNER JOIN static_text_langs s1_ ON (s0_ . id = s1_ . static_text_id ) WHERE s0_ . type = ? AND s1_ . lang_id = ? AND (s0_ . valid_from IS NULL OR s0_ . valid_from < = ? ) AND (s0_ . valid_to IS NULL OR s0_ . valid_to > = ? ) ORDER BY s0_ . id DESC LIMIT 1
Parameters :
[
"header "
1
"2025-12-06 03:30:35 "
"2025-12-06 03:30:35 "
]
SELECT s0_ . id AS id_0 , s0_ . type AS type_1 , s0_ . text AS text_2 , s0_ . exa_color AS exa_color_3 , s0_ . font_color AS font_color_4 , s0_ . valid_from AS valid_from_5 , s0_ . valid_to AS valid_to_6 FROM static_texts s0_ INNER JOIN static_text_langs s1_ ON (s0_ . id = s1_ . static_text_id ) WHERE s0_ . type = 'header' AND s1_ . lang_id = 1 AND (s0_ . valid_from IS NULL OR s0_ . valid_from < = '2025-12-06 03:30:35' ) AND (s0_ . valid_to IS NULL OR s0_ . valid_to > = '2025-12-06 03:30:35' ) ORDER BY s0_ . id DESC LIMIT 1 ; Copy
11
0.44 ms
SELECT c0_ . id AS id_0 , c0_ . custom_category AS custom_category_1 , c0_ . ordine AS ordine_2 , c0_ . is_online AS is_online_3 , c0_ . show_in_menu AS show_in_menu_4 , c0_ . parent_id AS parent_id_5 FROM custom_categories c0_ WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id IS NULL ORDER BY c0_ . ordine ASC
SELECT c0_ . id AS id_0 , c0_ . custom_category AS custom_category_1 , c0_ . ordine AS ordine_2 , c0_ . is_online AS is_online_3 , c0_ . show_in_menu AS show_in_menu_4 , c0_ . parent_id AS parent_id_5 FROM custom_categories c0_ WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id IS NULL ORDER BY c0_ . ordine ASC ; Copy
12
0.35 ms
SELECT c0_ . id AS id_0 , c0_ . custom_category AS custom_category_1 , c0_ . ordine AS ordine_2 , c0_ . is_online AS is_online_3 , c0_ . show_in_menu AS show_in_menu_4 , c0_ . parent_id AS parent_id_5 FROM custom_categories c0_ WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? ORDER BY c0_ . ordine ASC
SELECT c0_ . id AS id_0 , c0_ . custom_category AS custom_category_1 , c0_ . ordine AS ordine_2 , c0_ . is_online AS is_online_3 , c0_ . show_in_menu AS show_in_menu_4 , c0_ . parent_id AS parent_id_5 FROM custom_categories c0_ WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 1 ORDER BY c0_ . ordine ASC ; Copy
13
0.69 ms
SELECT c0_ . id AS id_0 , c0_ . custom_category AS custom_category_1 , c0_ . ordine AS ordine_2 , c0_ . is_online AS is_online_3 , c0_ . show_in_menu AS show_in_menu_4 , c0_ . parent_id AS parent_id_5 FROM custom_categories c0_ WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? ORDER BY c0_ . ordine ASC
SELECT c0_ . id AS id_0 , c0_ . custom_category AS custom_category_1 , c0_ . ordine AS ordine_2 , c0_ . is_online AS is_online_3 , c0_ . show_in_menu AS show_in_menu_4 , c0_ . parent_id AS parent_id_5 FROM custom_categories c0_ WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 2 ORDER BY c0_ . ordine ASC ; Copy
14
0.46 ms
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = ?
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = 1 ; Copy
15
0.37 ms
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = ?
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = 3 ; Copy
16
0.56 ms
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = ?
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = 4 ; Copy
17
0.49 ms
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = ?
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = 5 ; Copy
18
0.50 ms
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = ?
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = 2 ; Copy
19
0.49 ms
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = ?
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = 6 ; Copy
20
0.68 ms
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = ?
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = 7 ; Copy
21
0.59 ms
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = ?
SELECT t0 . id AS id_1 , t0 . category_name AS category_name_2 , t0 . category_url AS category_url_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . frontend_description AS frontend_description_6 , t0 . meta_h1 AS meta_h1_7 , t0 . meta_h2 AS meta_h2_8 , t0 . custom_category_id AS custom_category_id_9 , t0 . lang_id AS lang_id_10 FROM custom_categories_lang t0 WHERE t0 . custom_category_id = 8 ; Copy