1
0.75 ms
SELECT COUNT (l0_ . id ) AS sclr_0 FROM listini l0_
SELECT COUNT (l0_ . id ) AS sclr_0 FROM listini l0_ ; Copy
2
0.58 ms
SELECT t0 . id AS id_1 , t0 . lang AS lang_2 , t0 . label AS label_3 FROM langs t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . lang AS lang_2 , t0 . label AS label_3 FROM langs t0 WHERE t0 . id = '1' ; Copy
3
0.58 ms
SELECT t0 . id AS id_1 , t0 . listino AS listino_2 , t0 . currency_id AS currency_id_3 FROM listini t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . listino AS listino_2 , t0 . currency_id AS currency_id_3 FROM listini t0 WHERE t0 . id = '1' ; Copy
4
0.53 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
5
45.09 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 CONCAT (c . color , '|' , cd . color_start , '|' , IFNULL (cd . color_end , '' )))
FROM colors AS c
INNER JOIN products_skews AS ps ON ps . color_id = c . id AND ps . qty > 0
INNER JOIN colors_description AS cd ON cd . color = c . color
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-10-27 17:04:13' )
AND (pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-10-27 17:04:13' )
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-10-27 17:04:13' )
AND (pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-10-27 17:04:13' )
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 . shipping_region_id = 1
) AS absolute_max_price ,
(
SELECT IF (
pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-10-27 17:04:13'
AND
pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-10-27 17:04:13' ,
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 . shipping_region_id = 1
) AS absolute_min_price ,
(
SELECT REPLACE (pdi . img_path , '400x570' , '400x400_TE' )
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-10-27 17:04:13' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-10-27 17:04:13' )
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-10-27 17:04:13' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-10-27 17:04:13' )
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-10-27 17:04:13' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-10-27 17:04:13' )
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-10-27 17:04:13' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-10-27 17:04:13' )
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-10-27 17:04:13' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-10-27 17:04:13' )
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 ORDER BY pco . sequence ASC , pe . ordine ASC
) AS exploded_colors FROM products AS p
LEFT JOIN products_texts AS pt ON pt . product_id = p . id AND lang_id = 1 WHERE p . is_online = 1 AND p . in_home = 1 HAVING min_price > 0
AND color IS NOT NULL
AND nr_associations > 0
AND sum_online_qty > 0
AND path ! = '' ORDER BY RAND ()
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 CONCAT (c . color , '|' , cd . color_start , '|' , IFNULL (cd . color_end , '' )))
FROM colors AS c
INNER JOIN products_skews AS ps ON ps . color_id = c . id AND ps . qty > 0
INNER JOIN colors_description AS cd ON cd . color = c . color
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-10-27 17:04:13' )
AND (pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-10-27 17:04:13' )
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-10-27 17:04:13' )
AND (pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-10-27 17:04:13' )
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 . shipping_region_id = 1
) AS absolute_max_price ,
(
SELECT IF (
pr . discounted_price_from IS NULL OR pr . discounted_price_from < = '2025-10-27 17:04:13'
AND
pr . discounted_price_to IS NULL OR pr . discounted_price_to > = '2025-10-27 17:04:13' ,
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 . shipping_region_id = 1
) AS absolute_min_price ,
(
SELECT REPLACE (pdi . img_path , '400x570' , '400x400_TE' )
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-10-27 17:04:13' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-10-27 17:04:13' )
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-10-27 17:04:13' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-10-27 17:04:13' )
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-10-27 17:04:13' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-10-27 17:04:13' )
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-10-27 17:04:13' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-10-27 17:04:13' )
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-10-27 17:04:13' )
AND (l . valid_to IS NULL OR l . valid_to > = '2025-10-27 17:04:13' )
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 ORDER BY pco . sequence ASC , pe . ordine ASC
) AS exploded_colors FROM products AS p
LEFT JOIN products_texts AS pt ON pt . product_id = p . id AND lang_id = 1 WHERE p . is_online = 1 AND p . in_home = 1 HAVING min_price > 0
AND color IS NOT NULL
AND nr_associations > 0
AND sum_online_qty > 0
AND path ! = '' ORDER BY RAND (); Copy
6
0.85 ms
SELECT t0 . id AS id_1 , t0 . product AS product_2 , t0 . ean13 AS ean13_3 , t0 . product_name AS product_name_4 , t0 . product_url AS product_url_5 , t0 . commodity_code AS commodity_code_6 , t0 . brand AS brand_7 , t0 . collection AS collection_8 , t0 . category AS category_9 , t0 . is_online AS is_online_10 , t0 . in_home AS in_home_11 , t0 . is_to_show AS is_to_show_12 , t0 . label AS label_13 , t0 . linea_id AS linea_id_14 FROM products t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product AS product_2 , t0 . ean13 AS ean13_3 , t0 . product_name AS product_name_4 , t0 . product_url AS product_url_5 , t0 . commodity_code AS commodity_code_6 , t0 . brand AS brand_7 , t0 . collection AS collection_8 , t0 . category AS category_9 , t0 . is_online AS is_online_10 , t0 . in_home AS in_home_11 , t0 . is_to_show AS is_to_show_12 , t0 . label AS label_13 , t0 . linea_id AS linea_id_14 FROM products t0 WHERE t0 . id = 24137 ; Copy
7
0.63 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
8
0.82 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? AND t0 . phototype_id = ? ORDER BY t0 . season_id DESC LIMIT 1
Parameters :
[
24137
11037
1
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24137 AND t0 . color_id = 11037 AND t0 . phototype_id = 1 ORDER BY t0 . season_id DESC LIMIT 1 ; Copy
9
0.47 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
10
0.57 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? ORDER BY t0 . season_id DESC , t0 . phototype_id ASC
Parameters :
[
24137
11037
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24137 AND t0 . color_id = 11037 ORDER BY t0 . season_id DESC , t0 . phototype_id ASC ; Copy
11
0.29 ms
SELECT t0 . id AS id_1 , t0 . product AS product_2 , t0 . ean13 AS ean13_3 , t0 . product_name AS product_name_4 , t0 . product_url AS product_url_5 , t0 . commodity_code AS commodity_code_6 , t0 . brand AS brand_7 , t0 . collection AS collection_8 , t0 . category AS category_9 , t0 . is_online AS is_online_10 , t0 . in_home AS in_home_11 , t0 . is_to_show AS is_to_show_12 , t0 . label AS label_13 , t0 . linea_id AS linea_id_14 FROM products t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product AS product_2 , t0 . ean13 AS ean13_3 , t0 . product_name AS product_name_4 , t0 . product_url AS product_url_5 , t0 . commodity_code AS commodity_code_6 , t0 . brand AS brand_7 , t0 . collection AS collection_8 , t0 . category AS category_9 , t0 . is_online AS is_online_10 , t0 . in_home AS in_home_11 , t0 . is_to_show AS is_to_show_12 , t0 . label AS label_13 , t0 . linea_id AS linea_id_14 FROM products t0 WHERE t0 . id = 25813 ; Copy
12
0.37 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'SFFR' LIMIT 1 ; Copy
13
0.46 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? AND t0 . phototype_id = ? ORDER BY t0 . season_id DESC LIMIT 1
Parameters :
[
25813
13875
1
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 25813 AND t0 . color_id = 13875 AND t0 . phototype_id = 1 ORDER BY t0 . season_id DESC LIMIT 1 ; Copy
14
0.38 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'SFFR' LIMIT 1 ; Copy
15
0.56 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? ORDER BY t0 . season_id DESC , t0 . phototype_id ASC
Parameters :
[
25813
13875
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 25813 AND t0 . color_id = 13875 ORDER BY t0 . season_id DESC , t0 . phototype_id ASC ; Copy
16
0.37 ms
SELECT t0 . id AS id_1 , t0 . product AS product_2 , t0 . ean13 AS ean13_3 , t0 . product_name AS product_name_4 , t0 . product_url AS product_url_5 , t0 . commodity_code AS commodity_code_6 , t0 . brand AS brand_7 , t0 . collection AS collection_8 , t0 . category AS category_9 , t0 . is_online AS is_online_10 , t0 . in_home AS in_home_11 , t0 . is_to_show AS is_to_show_12 , t0 . label AS label_13 , t0 . linea_id AS linea_id_14 FROM products t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product AS product_2 , t0 . ean13 AS ean13_3 , t0 . product_name AS product_name_4 , t0 . product_url AS product_url_5 , t0 . commodity_code AS commodity_code_6 , t0 . brand AS brand_7 , t0 . collection AS collection_8 , t0 . category AS category_9 , t0 . is_online AS is_online_10 , t0 . in_home AS in_home_11 , t0 . is_to_show AS is_to_show_12 , t0 . label AS label_13 , t0 . linea_id AS linea_id_14 FROM products t0 WHERE t0 . id = 24139 ; Copy
17
0.34 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'CNZ' LIMIT 1 ; Copy
18
0.45 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? AND t0 . phototype_id = ? ORDER BY t0 . season_id DESC LIMIT 1
Parameters :
[
24139
13018
1
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24139 AND t0 . color_id = 13018 AND t0 . phototype_id = 1 ORDER BY t0 . season_id DESC LIMIT 1 ; Copy
19
0.30 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'CNZ' LIMIT 1 ; Copy
20
0.48 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? ORDER BY t0 . season_id DESC , t0 . phototype_id ASC
Parameters :
[
24139
13018
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24139 AND t0 . color_id = 13018 ORDER BY t0 . season_id DESC , t0 . phototype_id ASC ; Copy
21
0.31 ms
SELECT t0 . id AS id_1 , t0 . product AS product_2 , t0 . ean13 AS ean13_3 , t0 . product_name AS product_name_4 , t0 . product_url AS product_url_5 , t0 . commodity_code AS commodity_code_6 , t0 . brand AS brand_7 , t0 . collection AS collection_8 , t0 . category AS category_9 , t0 . is_online AS is_online_10 , t0 . in_home AS in_home_11 , t0 . is_to_show AS is_to_show_12 , t0 . label AS label_13 , t0 . linea_id AS linea_id_14 FROM products t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product AS product_2 , t0 . ean13 AS ean13_3 , t0 . product_name AS product_name_4 , t0 . product_url AS product_url_5 , t0 . commodity_code AS commodity_code_6 , t0 . brand AS brand_7 , t0 . collection AS collection_8 , t0 . category AS category_9 , t0 . is_online AS is_online_10 , t0 . in_home AS in_home_11 , t0 . is_to_show AS is_to_show_12 , t0 . label AS label_13 , t0 . linea_id AS linea_id_14 FROM products t0 WHERE t0 . id = 24138 ; Copy
22
0.26 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'MLW' LIMIT 1 ; Copy
23
0.44 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? AND t0 . phototype_id = ? ORDER BY t0 . season_id DESC LIMIT 1
Parameters :
[
24138
11036
1
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24138 AND t0 . color_id = 11036 AND t0 . phototype_id = 1 ORDER BY t0 . season_id DESC LIMIT 1 ; Copy
24
0.25 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'MLW' LIMIT 1 ; Copy
25
0.48 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? ORDER BY t0 . season_id DESC , t0 . phototype_id ASC
Parameters :
[
24138
11036
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24138 AND t0 . color_id = 11036 ORDER BY t0 . season_id DESC , t0 . phototype_id ASC ; Copy
26
0.30 ms
SELECT t0 . id AS id_1 , t0 . product AS product_2 , t0 . ean13 AS ean13_3 , t0 . product_name AS product_name_4 , t0 . product_url AS product_url_5 , t0 . commodity_code AS commodity_code_6 , t0 . brand AS brand_7 , t0 . collection AS collection_8 , t0 . category AS category_9 , t0 . is_online AS is_online_10 , t0 . in_home AS in_home_11 , t0 . is_to_show AS is_to_show_12 , t0 . label AS label_13 , t0 . linea_id AS linea_id_14 FROM products t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product AS product_2 , t0 . ean13 AS ean13_3 , t0 . product_name AS product_name_4 , t0 . product_url AS product_url_5 , t0 . commodity_code AS commodity_code_6 , t0 . brand AS brand_7 , t0 . collection AS collection_8 , t0 . category AS category_9 , t0 . is_online AS is_online_10 , t0 . in_home AS in_home_11 , t0 . is_to_show AS is_to_show_12 , t0 . label AS label_13 , t0 . linea_id AS linea_id_14 FROM products t0 WHERE t0 . id = 24136 ; Copy
27
0.25 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
28
0.89 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? AND t0 . phototype_id = ? ORDER BY t0 . season_id DESC LIMIT 1
Parameters :
[
24136
79
1
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24136 AND t0 . color_id = 79 AND t0 . phototype_id = 1 ORDER BY t0 . season_id DESC LIMIT 1 ; Copy
29
0.26 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
30
0.96 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? ORDER BY t0 . season_id DESC , t0 . phototype_id ASC
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24136 AND t0 . color_id = 79 ORDER BY t0 . season_id DESC , t0 . phototype_id ASC ; Copy
31
0.36 ms
SELECT t0 . id AS id_1 , t0 . product AS product_2 , t0 . ean13 AS ean13_3 , t0 . product_name AS product_name_4 , t0 . product_url AS product_url_5 , t0 . commodity_code AS commodity_code_6 , t0 . brand AS brand_7 , t0 . collection AS collection_8 , t0 . category AS category_9 , t0 . is_online AS is_online_10 , t0 . in_home AS in_home_11 , t0 . is_to_show AS is_to_show_12 , t0 . label AS label_13 , t0 . linea_id AS linea_id_14 FROM products t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product AS product_2 , t0 . ean13 AS ean13_3 , t0 . product_name AS product_name_4 , t0 . product_url AS product_url_5 , t0 . commodity_code AS commodity_code_6 , t0 . brand AS brand_7 , t0 . collection AS collection_8 , t0 . category AS category_9 , t0 . is_online AS is_online_10 , t0 . in_home AS in_home_11 , t0 . is_to_show AS is_to_show_12 , t0 . label AS label_13 , t0 . linea_id AS linea_id_14 FROM products t0 WHERE t0 . id = 24135 ; Copy
32
0.23 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
33
0.95 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? AND t0 . phototype_id = ? ORDER BY t0 . season_id DESC LIMIT 1
Parameters :
[
24135
79
1
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24135 AND t0 . color_id = 79 AND t0 . phototype_id = 1 ORDER BY t0 . season_id DESC LIMIT 1 ; Copy
34
0.27 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
35
0.92 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? ORDER BY t0 . season_id DESC , t0 . phototype_id ASC
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24135 AND t0 . color_id = 79 ORDER BY t0 . season_id DESC , t0 . phototype_id ASC ; Copy
36
0.39 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 , t0 . listino_id AS listino_id_7 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 , t0 . listino_id AS listino_id_7 FROM shipping_regions t0 WHERE t0 . region_code = 'it' LIMIT 1 ; Copy
37
3.71 ms
SELECT ps . * , c . color , s . size , sc . conversion , pr . price , pr . discounted_price , pr . lowest_price , pr . discount_percentage , pr . discounted_price_from , pr . discounted_price_to , pr . shipping_region_id ,
(
SELECT
CONVERT (GROUP_CONCAT (
CONCAT_WS (
'|' ,
phototype_id , phototype_name , photo_path , photo_path_reduced
)
) USING utf8mb4 )
FROM skews_photos sp
WHERE sp . product_id = ps . product_id
AND sp . color_id = ps . color_id
AND season_id IN (
SELECT MAX (season_id )
FROM skews_photos
WHERE product_id = ps . product_id
AND color_id = ps . color_id
)
ORDER BY phototype_id ASC
) AS path
FROM products_skews AS ps
INNER JOIN colors AS c ON c . id = ps . color_id
INNER JOIN sizes AS s ON s . id = ps . size_id
LEFT JOIN size_conversion AS sc ON sc . size = s . size AND linea_id = 15
LEFT JOIN product_colors_order AS pco ON pco . product_id = ps . product_id ANd pco . color_id = ps . color_id
INNER JOIN prices AS pr ON pr . skew_id = ps . id AND pr . shipping_region_id = 1
WHERE ps . product_id = 24137
AND ps . qty > 0
AND ps . is_online = 1
HAVING path ! = ''
ORDER BY pco . sequence ASC , sc . sequence ASC
SELECT ps . * , c . color , s . size , sc . conversion , pr . price , pr . discounted_price , pr . lowest_price , pr . discount_percentage , pr . discounted_price_from , pr . discounted_price_to , pr . shipping_region_id ,
(
SELECT
CONVERT (GROUP_CONCAT (
CONCAT_WS (
'|' ,
phototype_id , phototype_name , photo_path , photo_path_reduced
)
) USING utf8mb4 )
FROM skews_photos sp
WHERE sp . product_id = ps . product_id
AND sp . color_id = ps . color_id
AND season_id IN (
SELECT MAX (season_id )
FROM skews_photos
WHERE product_id = ps . product_id
AND color_id = ps . color_id
)
ORDER BY phototype_id ASC
) AS path
FROM products_skews AS ps
INNER JOIN colors AS c ON c . id = ps . color_id
INNER JOIN sizes AS s ON s . id = ps . size_id
LEFT JOIN size_conversion AS sc ON sc . size = s . size AND linea_id = 15
LEFT JOIN product_colors_order AS pco ON pco . product_id = ps . product_id ANd pco . color_id = ps . color_id
INNER JOIN prices AS pr ON pr . skew_id = ps . id AND pr . shipping_region_id = 1
WHERE ps . product_id = 24137
AND ps . qty > 0
AND ps . is_online = 1
HAVING path ! = ''
ORDER BY pco . sequence ASC , sc . sequence ASC
; Copy
38
0.31 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756340 ; Copy
39
0.29 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
40
0.26 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756341 ; Copy
41
0.22 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 FROM sizes t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . size AS size_2 FROM sizes t0 WHERE t0 . id = 90 ; Copy
42
0.34 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = ? AND t0 . linea_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = '8,5' AND t0 . linea_id = 15 LIMIT 1 ; Copy
43
0.33 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = ? AND t0 . linea_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = '8.5' AND t0 . linea_id = 15 LIMIT 1 ; Copy
44
0.32 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
45
0.24 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756342 ; Copy
46
0.22 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
47
0.19 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756343 ; Copy
48
0.19 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 FROM sizes t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . size AS size_2 FROM sizes t0 WHERE t0 . id = 91 ; Copy
49
0.23 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = ? AND t0 . linea_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = '9,5' AND t0 . linea_id = 15 LIMIT 1 ; Copy
50
0.30 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = ? AND t0 . linea_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = '9.5' AND t0 . linea_id = 15 LIMIT 1 ; Copy
51
0.21 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
52
0.23 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756344 ; Copy
53
0.23 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
54
0.21 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756345 ; Copy
55
0.20 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 FROM sizes t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . size AS size_2 FROM sizes t0 WHERE t0 . id = 92 ; Copy
56
0.23 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = ? AND t0 . linea_id = ? LIMIT 1
Parameters :
[
"10,5 "
15
]
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = '10,5' AND t0 . linea_id = 15 LIMIT 1 ; Copy
57
0.25 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = ? AND t0 . linea_id = ? LIMIT 1
Parameters :
[
"10.5 "
15
]
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = '10.5' AND t0 . linea_id = 15 LIMIT 1 ; Copy
58
0.20 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
59
0.21 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756346 ; Copy
60
0.20 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
61
0.21 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756347 ; Copy
62
0.19 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 FROM sizes t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . size AS size_2 FROM sizes t0 WHERE t0 . id = 93 ; Copy
63
0.24 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = ? AND t0 . linea_id = ? LIMIT 1
Parameters :
[
"11,5 "
15
]
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = '11,5' AND t0 . linea_id = 15 LIMIT 1 ; Copy
64
0.25 ms
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = ? AND t0 . linea_id = ? LIMIT 1
Parameters :
[
"11.5 "
15
]
SELECT t0 . id AS id_1 , t0 . size AS size_2 , t0 . conversion AS conversion_3 , t0 . sequence AS sequence_4 , t0 . linea_id AS linea_id_5 FROM size_conversion t0 WHERE t0 . size = '11.5' AND t0 . linea_id = 15 LIMIT 1 ; Copy
65
0.22 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
66
0.23 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756348 ; Copy
67
0.21 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
68
0.21 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756349 ; Copy
69
0.26 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
70
0.21 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'TSG' LIMIT 1 ; Copy
71
0.39 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? ORDER BY t0 . season_id DESC , t0 . phototype_id ASC
Parameters :
[
24137
11037
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24137 AND t0 . color_id = 11037 ORDER BY t0 . season_id DESC , t0 . phototype_id ASC ; Copy
72
0.47 ms
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . discount_percentage AS discount_percentage_2 , p0_ . discounted_price AS discounted_price_3 , p0_ . discounted_price_from AS discounted_price_from_4 , p0_ . discounted_price_to AS discounted_price_to_5 , p0_ . is_price_blocked AS is_price_blocked_6 , p0_ . lowest_price AS lowest_price_7 , p0_ . skew_id AS skew_id_8 , p0_ . currency_id AS currency_id_9 , p0_ . product_id AS product_id_10 , p0_ . shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_ . id = p0_ . skew_id ) INNER JOIN colors c2_ ON (c2_ . id = p1_ . color_id ) WHERE p0_ . product_id = ? AND c2_ . color = ? AND p0_ . shipping_region_id = ? LIMIT 1
Parameters :
[
24137
"TSG "
1
]
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . discount_percentage AS discount_percentage_2 , p0_ . discounted_price AS discounted_price_3 , p0_ . discounted_price_from AS discounted_price_from_4 , p0_ . discounted_price_to AS discounted_price_to_5 , p0_ . is_price_blocked AS is_price_blocked_6 , p0_ . lowest_price AS lowest_price_7 , p0_ . skew_id AS skew_id_8 , p0_ . currency_id AS currency_id_9 , p0_ . product_id AS product_id_10 , p0_ . shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_ . id = p0_ . skew_id ) INNER JOIN colors c2_ ON (c2_ . id = p1_ . color_id ) WHERE p0_ . product_id = 24137 AND c2_ . color = 'TSG' AND p0_ . shipping_region_id = 1 LIMIT 1 ; Copy
73
0.26 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 , t0 . listino_id AS listino_id_7 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 , t0 . listino_id AS listino_id_7 FROM shipping_regions t0 WHERE t0 . region_code = 'it' LIMIT 1 ; Copy
74
2.28 ms
SELECT ps . * , c . color , s . size , sc . conversion , pr . price , pr . discounted_price , pr . lowest_price , pr . discount_percentage , pr . discounted_price_from , pr . discounted_price_to , pr . shipping_region_id ,
(
SELECT
CONVERT (GROUP_CONCAT (
CONCAT_WS (
'|' ,
phototype_id , phototype_name , photo_path , photo_path_reduced
)
) USING utf8mb4 )
FROM skews_photos sp
WHERE sp . product_id = ps . product_id
AND sp . color_id = ps . color_id
AND season_id IN (
SELECT MAX (season_id )
FROM skews_photos
WHERE product_id = ps . product_id
AND color_id = ps . color_id
)
ORDER BY phototype_id ASC
) AS path
FROM products_skews AS ps
INNER JOIN colors AS c ON c . id = ps . color_id
INNER JOIN sizes AS s ON s . id = ps . size_id
LEFT JOIN size_conversion AS sc ON sc . size = s . size AND linea_id = 15
LEFT JOIN product_colors_order AS pco ON pco . product_id = ps . product_id ANd pco . color_id = ps . color_id
INNER JOIN prices AS pr ON pr . skew_id = ps . id AND pr . shipping_region_id = 1
WHERE ps . product_id = 25813
AND ps . qty > 0
AND ps . is_online = 1
HAVING path ! = ''
ORDER BY pco . sequence ASC , sc . sequence ASC
SELECT ps . * , c . color , s . size , sc . conversion , pr . price , pr . discounted_price , pr . lowest_price , pr . discount_percentage , pr . discounted_price_from , pr . discounted_price_to , pr . shipping_region_id ,
(
SELECT
CONVERT (GROUP_CONCAT (
CONCAT_WS (
'|' ,
phototype_id , phototype_name , photo_path , photo_path_reduced
)
) USING utf8mb4 )
FROM skews_photos sp
WHERE sp . product_id = ps . product_id
AND sp . color_id = ps . color_id
AND season_id IN (
SELECT MAX (season_id )
FROM skews_photos
WHERE product_id = ps . product_id
AND color_id = ps . color_id
)
ORDER BY phototype_id ASC
) AS path
FROM products_skews AS ps
INNER JOIN colors AS c ON c . id = ps . color_id
INNER JOIN sizes AS s ON s . id = ps . size_id
LEFT JOIN size_conversion AS sc ON sc . size = s . size AND linea_id = 15
LEFT JOIN product_colors_order AS pco ON pco . product_id = ps . product_id ANd pco . color_id = ps . color_id
INNER JOIN prices AS pr ON pr . skew_id = ps . id AND pr . shipping_region_id = 1
WHERE ps . product_id = 25813
AND ps . qty > 0
AND ps . is_online = 1
HAVING path ! = ''
ORDER BY pco . sequence ASC , sc . sequence ASC
; Copy
75
0.42 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 807353 ; Copy
76
0.33 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'SFFR' LIMIT 1 ; Copy
77
0.60 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 807354 ; Copy
78
0.29 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'SFFR' LIMIT 1 ; Copy
79
0.27 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 807355 ; Copy
80
0.33 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'SFFR' LIMIT 1 ; Copy
81
0.26 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 807356 ; Copy
82
0.40 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'SFFR' LIMIT 1 ; Copy
83
0.30 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 807357 ; Copy
84
0.27 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'SFFR' LIMIT 1 ; Copy
85
0.23 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 807358 ; Copy
86
0.25 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'SFFR' LIMIT 1 ; Copy
87
0.27 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 807359 ; Copy
88
0.25 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'SFFR' LIMIT 1 ; Copy
89
0.64 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'SFFR' LIMIT 1 ; Copy
90
1.18 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? ORDER BY t0 . season_id DESC , t0 . phototype_id ASC
Parameters :
[
25813
13875
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 25813 AND t0 . color_id = 13875 ORDER BY t0 . season_id DESC , t0 . phototype_id ASC ; Copy
91
1.04 ms
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . discount_percentage AS discount_percentage_2 , p0_ . discounted_price AS discounted_price_3 , p0_ . discounted_price_from AS discounted_price_from_4 , p0_ . discounted_price_to AS discounted_price_to_5 , p0_ . is_price_blocked AS is_price_blocked_6 , p0_ . lowest_price AS lowest_price_7 , p0_ . skew_id AS skew_id_8 , p0_ . currency_id AS currency_id_9 , p0_ . product_id AS product_id_10 , p0_ . shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_ . id = p0_ . skew_id ) INNER JOIN colors c2_ ON (c2_ . id = p1_ . color_id ) WHERE p0_ . product_id = ? AND c2_ . color = ? AND p0_ . shipping_region_id = ? LIMIT 1
Parameters :
[
25813
"SFFR "
1
]
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . discount_percentage AS discount_percentage_2 , p0_ . discounted_price AS discounted_price_3 , p0_ . discounted_price_from AS discounted_price_from_4 , p0_ . discounted_price_to AS discounted_price_to_5 , p0_ . is_price_blocked AS is_price_blocked_6 , p0_ . lowest_price AS lowest_price_7 , p0_ . skew_id AS skew_id_8 , p0_ . currency_id AS currency_id_9 , p0_ . product_id AS product_id_10 , p0_ . shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_ . id = p0_ . skew_id ) INNER JOIN colors c2_ ON (c2_ . id = p1_ . color_id ) WHERE p0_ . product_id = 25813 AND c2_ . color = 'SFFR' AND p0_ . shipping_region_id = 1 LIMIT 1 ; Copy
92
0.57 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 , t0 . listino_id AS listino_id_7 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 , t0 . listino_id AS listino_id_7 FROM shipping_regions t0 WHERE t0 . region_code = 'it' LIMIT 1 ; Copy
93
6.03 ms
SELECT ps . * , c . color , s . size , sc . conversion , pr . price , pr . discounted_price , pr . lowest_price , pr . discount_percentage , pr . discounted_price_from , pr . discounted_price_to , pr . shipping_region_id ,
(
SELECT
CONVERT (GROUP_CONCAT (
CONCAT_WS (
'|' ,
phototype_id , phototype_name , photo_path , photo_path_reduced
)
) USING utf8mb4 )
FROM skews_photos sp
WHERE sp . product_id = ps . product_id
AND sp . color_id = ps . color_id
AND season_id IN (
SELECT MAX (season_id )
FROM skews_photos
WHERE product_id = ps . product_id
AND color_id = ps . color_id
)
ORDER BY phototype_id ASC
) AS path
FROM products_skews AS ps
INNER JOIN colors AS c ON c . id = ps . color_id
INNER JOIN sizes AS s ON s . id = ps . size_id
LEFT JOIN size_conversion AS sc ON sc . size = s . size AND linea_id = 14
LEFT JOIN product_colors_order AS pco ON pco . product_id = ps . product_id ANd pco . color_id = ps . color_id
INNER JOIN prices AS pr ON pr . skew_id = ps . id AND pr . shipping_region_id = 1
WHERE ps . product_id = 24139
AND ps . qty > 0
AND ps . is_online = 1
HAVING path ! = ''
ORDER BY pco . sequence ASC , sc . sequence ASC
SELECT ps . * , c . color , s . size , sc . conversion , pr . price , pr . discounted_price , pr . lowest_price , pr . discount_percentage , pr . discounted_price_from , pr . discounted_price_to , pr . shipping_region_id ,
(
SELECT
CONVERT (GROUP_CONCAT (
CONCAT_WS (
'|' ,
phototype_id , phototype_name , photo_path , photo_path_reduced
)
) USING utf8mb4 )
FROM skews_photos sp
WHERE sp . product_id = ps . product_id
AND sp . color_id = ps . color_id
AND season_id IN (
SELECT MAX (season_id )
FROM skews_photos
WHERE product_id = ps . product_id
AND color_id = ps . color_id
)
ORDER BY phototype_id ASC
) AS path
FROM products_skews AS ps
INNER JOIN colors AS c ON c . id = ps . color_id
INNER JOIN sizes AS s ON s . id = ps . size_id
LEFT JOIN size_conversion AS sc ON sc . size = s . size AND linea_id = 14
LEFT JOIN product_colors_order AS pco ON pco . product_id = ps . product_id ANd pco . color_id = ps . color_id
INNER JOIN prices AS pr ON pr . skew_id = ps . id AND pr . shipping_region_id = 1
WHERE ps . product_id = 24139
AND ps . qty > 0
AND ps . is_online = 1
HAVING path ! = ''
ORDER BY pco . sequence ASC , sc . sequence ASC
; Copy
94
0.54 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756390 ; Copy
95
0.49 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'CNZ' LIMIT 1 ; Copy
96
0.50 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756391 ; Copy
97
0.47 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'CNZ' LIMIT 1 ; Copy
98
0.32 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756392 ; Copy
99
0.32 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'CNZ' LIMIT 1 ; Copy
100
0.31 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756393 ; Copy
101
0.32 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'CNZ' LIMIT 1 ; Copy
102
0.30 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756394 ; Copy
103
0.30 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'CNZ' LIMIT 1 ; Copy
104
0.37 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756395 ; Copy
105
0.39 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'CNZ' LIMIT 1 ; Copy
106
0.31 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'CNZ' LIMIT 1 ; Copy
107
0.59 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? ORDER BY t0 . season_id DESC , t0 . phototype_id ASC
Parameters :
[
24139
13018
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24139 AND t0 . color_id = 13018 ORDER BY t0 . season_id DESC , t0 . phototype_id ASC ; Copy
108
0.60 ms
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . discount_percentage AS discount_percentage_2 , p0_ . discounted_price AS discounted_price_3 , p0_ . discounted_price_from AS discounted_price_from_4 , p0_ . discounted_price_to AS discounted_price_to_5 , p0_ . is_price_blocked AS is_price_blocked_6 , p0_ . lowest_price AS lowest_price_7 , p0_ . skew_id AS skew_id_8 , p0_ . currency_id AS currency_id_9 , p0_ . product_id AS product_id_10 , p0_ . shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_ . id = p0_ . skew_id ) INNER JOIN colors c2_ ON (c2_ . id = p1_ . color_id ) WHERE p0_ . product_id = ? AND c2_ . color = ? AND p0_ . shipping_region_id = ? LIMIT 1
Parameters :
[
24139
"CNZ "
1
]
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . discount_percentage AS discount_percentage_2 , p0_ . discounted_price AS discounted_price_3 , p0_ . discounted_price_from AS discounted_price_from_4 , p0_ . discounted_price_to AS discounted_price_to_5 , p0_ . is_price_blocked AS is_price_blocked_6 , p0_ . lowest_price AS lowest_price_7 , p0_ . skew_id AS skew_id_8 , p0_ . currency_id AS currency_id_9 , p0_ . product_id AS product_id_10 , p0_ . shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_ . id = p0_ . skew_id ) INNER JOIN colors c2_ ON (c2_ . id = p1_ . color_id ) WHERE p0_ . product_id = 24139 AND c2_ . color = 'CNZ' AND p0_ . shipping_region_id = 1 LIMIT 1 ; Copy
109
0.39 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 , t0 . listino_id AS listino_id_7 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 , t0 . listino_id AS listino_id_7 FROM shipping_regions t0 WHERE t0 . region_code = 'it' LIMIT 1 ; Copy
110
4.37 ms
SELECT ps . * , c . color , s . size , sc . conversion , pr . price , pr . discounted_price , pr . lowest_price , pr . discount_percentage , pr . discounted_price_from , pr . discounted_price_to , pr . shipping_region_id ,
(
SELECT
CONVERT (GROUP_CONCAT (
CONCAT_WS (
'|' ,
phototype_id , phototype_name , photo_path , photo_path_reduced
)
) USING utf8mb4 )
FROM skews_photos sp
WHERE sp . product_id = ps . product_id
AND sp . color_id = ps . color_id
AND season_id IN (
SELECT MAX (season_id )
FROM skews_photos
WHERE product_id = ps . product_id
AND color_id = ps . color_id
)
ORDER BY phototype_id ASC
) AS path
FROM products_skews AS ps
INNER JOIN colors AS c ON c . id = ps . color_id
INNER JOIN sizes AS s ON s . id = ps . size_id
LEFT JOIN size_conversion AS sc ON sc . size = s . size AND linea_id = 14
LEFT JOIN product_colors_order AS pco ON pco . product_id = ps . product_id ANd pco . color_id = ps . color_id
INNER JOIN prices AS pr ON pr . skew_id = ps . id AND pr . shipping_region_id = 1
WHERE ps . product_id = 24138
AND ps . qty > 0
AND ps . is_online = 1
HAVING path ! = ''
ORDER BY pco . sequence ASC , sc . sequence ASC
SELECT ps . * , c . color , s . size , sc . conversion , pr . price , pr . discounted_price , pr . lowest_price , pr . discount_percentage , pr . discounted_price_from , pr . discounted_price_to , pr . shipping_region_id ,
(
SELECT
CONVERT (GROUP_CONCAT (
CONCAT_WS (
'|' ,
phototype_id , phototype_name , photo_path , photo_path_reduced
)
) USING utf8mb4 )
FROM skews_photos sp
WHERE sp . product_id = ps . product_id
AND sp . color_id = ps . color_id
AND season_id IN (
SELECT MAX (season_id )
FROM skews_photos
WHERE product_id = ps . product_id
AND color_id = ps . color_id
)
ORDER BY phototype_id ASC
) AS path
FROM products_skews AS ps
INNER JOIN colors AS c ON c . id = ps . color_id
INNER JOIN sizes AS s ON s . id = ps . size_id
LEFT JOIN size_conversion AS sc ON sc . size = s . size AND linea_id = 14
LEFT JOIN product_colors_order AS pco ON pco . product_id = ps . product_id ANd pco . color_id = ps . color_id
INNER JOIN prices AS pr ON pr . skew_id = ps . id AND pr . shipping_region_id = 1
WHERE ps . product_id = 24138
AND ps . qty > 0
AND ps . is_online = 1
HAVING path ! = ''
ORDER BY pco . sequence ASC , sc . sequence ASC
; Copy
111
0.55 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756364 ; Copy
112
0.50 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MLW' LIMIT 1 ; Copy
113
0.43 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756366 ; Copy
114
0.62 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MLW' LIMIT 1 ; Copy
115
0.46 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756368 ; Copy
116
0.48 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MLW' LIMIT 1 ; Copy
117
0.43 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756370 ; Copy
118
0.42 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MLW' LIMIT 1 ; Copy
119
0.41 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756372 ; Copy
120
0.40 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MLW' LIMIT 1 ; Copy
121
0.40 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756374 ; Copy
122
0.42 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MLW' LIMIT 1 ; Copy
123
0.40 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756377 ; Copy
124
0.38 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . id = 11615 ; Copy
125
0.45 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BDV' LIMIT 1 ; Copy
126
0.39 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756379 ; Copy
127
0.39 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BDV' LIMIT 1 ; Copy
128
0.40 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756381 ; Copy
129
0.42 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BDV' LIMIT 1 ; Copy
130
0.44 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756383 ; Copy
131
0.41 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BDV' LIMIT 1 ; Copy
132
0.43 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756385 ; Copy
133
0.40 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BDV' LIMIT 1 ; Copy
134
0.38 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756387 ; Copy
135
0.41 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BDV' LIMIT 1 ; Copy
136
0.36 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'MLW' LIMIT 1 ; Copy
137
0.85 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? ORDER BY t0 . season_id DESC , t0 . phototype_id ASC
Parameters :
[
24138
11036
]
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24138 AND t0 . color_id = 11036 ORDER BY t0 . season_id DESC , t0 . phototype_id ASC ; Copy
138
0.95 ms
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . discount_percentage AS discount_percentage_2 , p0_ . discounted_price AS discounted_price_3 , p0_ . discounted_price_from AS discounted_price_from_4 , p0_ . discounted_price_to AS discounted_price_to_5 , p0_ . is_price_blocked AS is_price_blocked_6 , p0_ . lowest_price AS lowest_price_7 , p0_ . skew_id AS skew_id_8 , p0_ . currency_id AS currency_id_9 , p0_ . product_id AS product_id_10 , p0_ . shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_ . id = p0_ . skew_id ) INNER JOIN colors c2_ ON (c2_ . id = p1_ . color_id ) WHERE p0_ . product_id = ? AND c2_ . color = ? AND p0_ . shipping_region_id = ? LIMIT 1
Parameters :
[
24138
"MLW "
1
]
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . discount_percentage AS discount_percentage_2 , p0_ . discounted_price AS discounted_price_3 , p0_ . discounted_price_from AS discounted_price_from_4 , p0_ . discounted_price_to AS discounted_price_to_5 , p0_ . is_price_blocked AS is_price_blocked_6 , p0_ . lowest_price AS lowest_price_7 , p0_ . skew_id AS skew_id_8 , p0_ . currency_id AS currency_id_9 , p0_ . product_id AS product_id_10 , p0_ . shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_ . id = p0_ . skew_id ) INNER JOIN colors c2_ ON (c2_ . id = p1_ . color_id ) WHERE p0_ . product_id = 24138 AND c2_ . color = 'MLW' AND p0_ . shipping_region_id = 1 LIMIT 1 ; Copy
139
0.41 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 , t0 . listino_id AS listino_id_7 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 , t0 . listino_id AS listino_id_7 FROM shipping_regions t0 WHERE t0 . region_code = 'it' LIMIT 1 ; Copy
140
81.59 ms
SELECT ps . * , c . color , s . size , sc . conversion , pr . price , pr . discounted_price , pr . lowest_price , pr . discount_percentage , pr . discounted_price_from , pr . discounted_price_to , pr . shipping_region_id ,
(
SELECT
CONVERT (GROUP_CONCAT (
CONCAT_WS (
'|' ,
phototype_id , phototype_name , photo_path , photo_path_reduced
)
) USING utf8mb4 )
FROM skews_photos sp
WHERE sp . product_id = ps . product_id
AND sp . color_id = ps . color_id
AND season_id IN (
SELECT MAX (season_id )
FROM skews_photos
WHERE product_id = ps . product_id
AND color_id = ps . color_id
)
ORDER BY phototype_id ASC
) AS path
FROM products_skews AS ps
INNER JOIN colors AS c ON c . id = ps . color_id
INNER JOIN sizes AS s ON s . id = ps . size_id
LEFT JOIN size_conversion AS sc ON sc . size = s . size AND linea_id = 14
LEFT JOIN product_colors_order AS pco ON pco . product_id = ps . product_id ANd pco . color_id = ps . color_id
INNER JOIN prices AS pr ON pr . skew_id = ps . id AND pr . shipping_region_id = 1
WHERE ps . product_id = 24136
AND ps . qty > 0
AND ps . is_online = 1
HAVING path ! = ''
ORDER BY pco . sequence ASC , sc . sequence ASC
SELECT ps . * , c . color , s . size , sc . conversion , pr . price , pr . discounted_price , pr . lowest_price , pr . discount_percentage , pr . discounted_price_from , pr . discounted_price_to , pr . shipping_region_id ,
(
SELECT
CONVERT (GROUP_CONCAT (
CONCAT_WS (
'|' ,
phototype_id , phototype_name , photo_path , photo_path_reduced
)
) USING utf8mb4 )
FROM skews_photos sp
WHERE sp . product_id = ps . product_id
AND sp . color_id = ps . color_id
AND season_id IN (
SELECT MAX (season_id )
FROM skews_photos
WHERE product_id = ps . product_id
AND color_id = ps . color_id
)
ORDER BY phototype_id ASC
) AS path
FROM products_skews AS ps
INNER JOIN colors AS c ON c . id = ps . color_id
INNER JOIN sizes AS s ON s . id = ps . size_id
LEFT JOIN size_conversion AS sc ON sc . size = s . size AND linea_id = 14
LEFT JOIN product_colors_order AS pco ON pco . product_id = ps . product_id ANd pco . color_id = ps . color_id
INNER JOIN prices AS pr ON pr . skew_id = ps . id AND pr . shipping_region_id = 1
WHERE ps . product_id = 24136
AND ps . qty > 0
AND ps . is_online = 1
HAVING path ! = ''
ORDER BY pco . sequence ASC , sc . sequence ASC
; Copy
141
0.46 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756322 ; Copy
142
0.37 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
143
0.42 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756323 ; Copy
144
0.39 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
145
0.46 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756324 ; Copy
146
0.35 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
147
0.31 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756325 ; Copy
148
0.40 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
149
0.31 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756326 ; Copy
150
0.35 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
151
0.37 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756327 ; Copy
152
0.36 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
153
0.30 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756328 ; Copy
154
0.32 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
155
0.33 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756329 ; Copy
156
0.33 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
157
0.48 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756330 ; Copy
158
0.37 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . id = 10973 ; Copy
159
0.38 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'WPPP' LIMIT 1 ; Copy
160
0.43 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756331 ; Copy
161
0.46 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'WPPP' LIMIT 1 ; Copy
162
0.53 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756332 ; Copy
163
0.46 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'WPPP' LIMIT 1 ; Copy
164
0.39 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756333 ; Copy
165
0.41 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'WPPP' LIMIT 1 ; Copy
166
0.39 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756334 ; Copy
167
0.39 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'WPPP' LIMIT 1 ; Copy
168
0.37 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756335 ; Copy
169
0.34 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'WPPP' LIMIT 1 ; Copy
170
0.36 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756336 ; Copy
171
0.36 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'WPPP' LIMIT 1 ; Copy
172
0.37 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756337 ; Copy
173
0.28 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'WPPP' LIMIT 1 ; Copy
174
0.25 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
175
0.90 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? ORDER BY t0 . season_id DESC , t0 . phototype_id ASC
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24136 AND t0 . color_id = 79 ORDER BY t0 . season_id DESC , t0 . phototype_id ASC ; Copy
176
0.55 ms
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . discount_percentage AS discount_percentage_2 , p0_ . discounted_price AS discounted_price_3 , p0_ . discounted_price_from AS discounted_price_from_4 , p0_ . discounted_price_to AS discounted_price_to_5 , p0_ . is_price_blocked AS is_price_blocked_6 , p0_ . lowest_price AS lowest_price_7 , p0_ . skew_id AS skew_id_8 , p0_ . currency_id AS currency_id_9 , p0_ . product_id AS product_id_10 , p0_ . shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_ . id = p0_ . skew_id ) INNER JOIN colors c2_ ON (c2_ . id = p1_ . color_id ) WHERE p0_ . product_id = ? AND c2_ . color = ? AND p0_ . shipping_region_id = ? LIMIT 1
Parameters :
[
24136
"BLK "
1
]
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . discount_percentage AS discount_percentage_2 , p0_ . discounted_price AS discounted_price_3 , p0_ . discounted_price_from AS discounted_price_from_4 , p0_ . discounted_price_to AS discounted_price_to_5 , p0_ . is_price_blocked AS is_price_blocked_6 , p0_ . lowest_price AS lowest_price_7 , p0_ . skew_id AS skew_id_8 , p0_ . currency_id AS currency_id_9 , p0_ . product_id AS product_id_10 , p0_ . shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_ . id = p0_ . skew_id ) INNER JOIN colors c2_ ON (c2_ . id = p1_ . color_id ) WHERE p0_ . product_id = 24136 AND c2_ . color = 'BLK' AND p0_ . shipping_region_id = 1 LIMIT 1 ; Copy
177
0.61 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 , t0 . listino_id AS listino_id_7 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 , t0 . listino_id AS listino_id_7 FROM shipping_regions t0 WHERE t0 . region_code = 'it' LIMIT 1 ; Copy
178
67.89 ms
SELECT ps . * , c . color , s . size , sc . conversion , pr . price , pr . discounted_price , pr . lowest_price , pr . discount_percentage , pr . discounted_price_from , pr . discounted_price_to , pr . shipping_region_id ,
(
SELECT
CONVERT (GROUP_CONCAT (
CONCAT_WS (
'|' ,
phototype_id , phototype_name , photo_path , photo_path_reduced
)
) USING utf8mb4 )
FROM skews_photos sp
WHERE sp . product_id = ps . product_id
AND sp . color_id = ps . color_id
AND season_id IN (
SELECT MAX (season_id )
FROM skews_photos
WHERE product_id = ps . product_id
AND color_id = ps . color_id
)
ORDER BY phototype_id ASC
) AS path
FROM products_skews AS ps
INNER JOIN colors AS c ON c . id = ps . color_id
INNER JOIN sizes AS s ON s . id = ps . size_id
LEFT JOIN size_conversion AS sc ON sc . size = s . size AND linea_id = 14
LEFT JOIN product_colors_order AS pco ON pco . product_id = ps . product_id ANd pco . color_id = ps . color_id
INNER JOIN prices AS pr ON pr . skew_id = ps . id AND pr . shipping_region_id = 1
WHERE ps . product_id = 24135
AND ps . qty > 0
AND ps . is_online = 1
HAVING path ! = ''
ORDER BY pco . sequence ASC , sc . sequence ASC
SELECT ps . * , c . color , s . size , sc . conversion , pr . price , pr . discounted_price , pr . lowest_price , pr . discount_percentage , pr . discounted_price_from , pr . discounted_price_to , pr . shipping_region_id ,
(
SELECT
CONVERT (GROUP_CONCAT (
CONCAT_WS (
'|' ,
phototype_id , phototype_name , photo_path , photo_path_reduced
)
) USING utf8mb4 )
FROM skews_photos sp
WHERE sp . product_id = ps . product_id
AND sp . color_id = ps . color_id
AND season_id IN (
SELECT MAX (season_id )
FROM skews_photos
WHERE product_id = ps . product_id
AND color_id = ps . color_id
)
ORDER BY phototype_id ASC
) AS path
FROM products_skews AS ps
INNER JOIN colors AS c ON c . id = ps . color_id
INNER JOIN sizes AS s ON s . id = ps . size_id
LEFT JOIN size_conversion AS sc ON sc . size = s . size AND linea_id = 14
LEFT JOIN product_colors_order AS pco ON pco . product_id = ps . product_id ANd pco . color_id = ps . color_id
INNER JOIN prices AS pr ON pr . skew_id = ps . id AND pr . shipping_region_id = 1
WHERE ps . product_id = 24135
AND ps . qty > 0
AND ps . is_online = 1
HAVING path ! = ''
ORDER BY pco . sequence ASC , sc . sequence ASC
; Copy
179
0.63 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756306 ; Copy
180
0.52 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
181
0.48 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756307 ; Copy
182
0.42 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
183
0.39 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756308 ; Copy
184
0.43 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
185
0.37 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756309 ; Copy
186
0.39 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
187
0.37 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756310 ; Copy
188
0.34 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
189
0.35 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756311 ; Copy
190
0.40 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
191
0.34 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756312 ; Copy
192
0.38 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
193
0.30 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756313 ; Copy
194
0.25 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
195
0.29 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756314 ; Copy
196
0.26 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . id = 589 ; Copy
197
0.27 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MAH' LIMIT 1 ; Copy
198
0.26 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756315 ; Copy
199
0.32 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MAH' LIMIT 1 ; Copy
200
0.25 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756316 ; Copy
201
0.23 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MAH' LIMIT 1 ; Copy
202
0.24 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756317 ; Copy
203
0.24 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MAH' LIMIT 1 ; Copy
204
0.29 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756318 ; Copy
205
0.27 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MAH' LIMIT 1 ; Copy
206
0.27 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756319 ; Copy
207
0.26 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MAH' LIMIT 1 ; Copy
208
0.26 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756320 ; Copy
209
0.26 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MAH' LIMIT 1 ; Copy
210
0.23 ms
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . sku_code AS sku_code_2 , t0 . barcode AS barcode_3 , t0 . qty AS qty_4 , t0 . is_qty_blocked AS is_qty_blocked_5 , t0 . is_future AS is_future_6 , t0 . sent_to_splio AS sent_to_splio_7 , t0 . is_online AS is_online_8 , t0 . product_id AS product_id_9 , t0 . color_id AS color_id_10 , t0 . size_id AS size_id_11 FROM products_skews t0 WHERE t0 . id = 756321 ; Copy
211
0.25 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 , t0 . description AS description_3 FROM colors_description t0 WHERE t0 . color = 'MAH' LIMIT 1 ; Copy
212
0.26 ms
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . color AS color_2 FROM colors t0 WHERE t0 . color = 'BLK' LIMIT 1 ; Copy
213
0.82 ms
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = ? AND t0 . color_id = ? ORDER BY t0 . season_id DESC , t0 . phototype_id ASC
SELECT t0 . id AS id_1 , t0 . photo_path AS photo_path_2 , t0 . photo_path_reduced AS photo_path_reduced_3 , t0 . brand_name AS brand_name_4 , t0 . color_name AS color_name_5 , t0 . season_label AS season_label_6 , t0 . insert_timestamp AS insert_timestamp_7 , t0 . product_id AS product_id_8 , t0 . color_id AS color_id_9 , t0 . phototype_id AS phototype_id_10 , t0 . season_id AS season_id_11 FROM skews_photos t0 WHERE t0 . product_id = 24135 AND t0 . color_id = 79 ORDER BY t0 . season_id DESC , t0 . phototype_id ASC ; Copy
214
0.53 ms
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . discount_percentage AS discount_percentage_2 , p0_ . discounted_price AS discounted_price_3 , p0_ . discounted_price_from AS discounted_price_from_4 , p0_ . discounted_price_to AS discounted_price_to_5 , p0_ . is_price_blocked AS is_price_blocked_6 , p0_ . lowest_price AS lowest_price_7 , p0_ . skew_id AS skew_id_8 , p0_ . currency_id AS currency_id_9 , p0_ . product_id AS product_id_10 , p0_ . shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_ . id = p0_ . skew_id ) INNER JOIN colors c2_ ON (c2_ . id = p1_ . color_id ) WHERE p0_ . product_id = ? AND c2_ . color = ? AND p0_ . shipping_region_id = ? LIMIT 1
Parameters :
[
24135
"BLK "
1
]
SELECT p0_ . id AS id_0 , p0_ . price AS price_1 , p0_ . discount_percentage AS discount_percentage_2 , p0_ . discounted_price AS discounted_price_3 , p0_ . discounted_price_from AS discounted_price_from_4 , p0_ . discounted_price_to AS discounted_price_to_5 , p0_ . is_price_blocked AS is_price_blocked_6 , p0_ . lowest_price AS lowest_price_7 , p0_ . skew_id AS skew_id_8 , p0_ . currency_id AS currency_id_9 , p0_ . product_id AS product_id_10 , p0_ . shipping_region_id AS shipping_region_id_11 FROM prices p0_ INNER JOIN products_skews p1_ ON (p1_ . id = p0_ . skew_id ) INNER JOIN colors c2_ ON (c2_ . id = p1_ . color_id ) WHERE p0_ . product_id = 24135 AND c2_ . color = 'BLK' AND p0_ . shipping_region_id = 1 LIMIT 1 ; Copy
215
0.27 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 , t0 . listino_id AS listino_id_7 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 , t0 . listino_id AS listino_id_7 FROM shipping_regions t0 WHERE t0 . region_code = 'it' LIMIT 1 ; Copy
216
0.36 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
217
0.56 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-10-27 17:04:13 "
"2025-10-27 17:04:13 "
]
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-10-27 17:04:13' ) AND (s0_ . valid_to IS NULL OR s0_ . valid_to > = '2025-10-27 17:04:13' ) ORDER BY s0_ . id DESC LIMIT 1 ; Copy
218
0.25 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
219
0.47 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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id IS NULL AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id IS NULL AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
220
0.48 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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 84 AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
221
0.47 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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 85 AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
222
0.53 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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 91 AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
223
0.38 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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 92 AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
224
0.39 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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 88 AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
225
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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 106 AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
226
0.41 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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 107 AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
227
0.37 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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 108 AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
228
0.37 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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 89 AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
229
0.41 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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 109 AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
230
0.36 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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 110 AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
231
0.39 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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = ? AND c1_ . lang_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_ INNER JOIN custom_categories_lang c1_ ON (c1_ . custom_category_id = c0_ . id ) WHERE c0_ . is_online = 1 AND c0_ . show_in_menu = 1 AND c0_ . parent_id = 111 AND c1_ . lang_id = 1 ORDER BY c0_ . ordine ASC ; Copy
232
0.31 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 = 84 ; Copy
233
0.31 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 = 85 ; Copy
234
0.27 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 = 86 ; Copy
235
0.29 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 = 87 ; Copy
236
0.27 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 = 94 ; Copy
237
0.27 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 = 95 ; Copy
238
0.31 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 = 96 ; Copy
239
0.35 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 = 93 ; Copy
240
0.32 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 = 91 ; Copy
241
0.28 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 = 97 ; Copy
242
0.29 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 = 98 ; Copy
243
0.27 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 = 99 ; Copy
244
0.28 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 = 100 ; Copy
245
0.25 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 = 101 ; Copy
246
0.29 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 = 102 ; Copy
247
0.28 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 = 103 ; Copy
248
0.27 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 = 92 ; Copy
249
0.26 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 = 105 ; Copy
250
0.30 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 = 104 ; Copy
251
0.29 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 = 88 ; Copy
252
0.33 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 = 106 ; Copy
253
0.38 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 = 112 ; Copy
254
0.32 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 = 118 ; Copy
255
0.30 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 = 113 ; Copy
256
0.29 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 = 115 ; Copy
257
0.30 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 = 116 ; Copy
258
0.27 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 = 117 ; Copy
259
0.30 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 = 114 ; Copy
260
0.27 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 = 107 ; Copy
261
0.26 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 = 125 ; Copy
262
0.25 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 = 119 ; Copy
263
0.25 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 = 120 ; Copy
264
0.27 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 = 126 ; Copy
265
0.26 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 = 121 ; Copy
266
0.27 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 = 122 ; Copy
267
0.26 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 = 123 ; Copy
268
0.25 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 = 127 ; Copy
269
0.27 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 = 124 ; Copy
270
0.26 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 = 108 ; Copy
271
0.24 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 = 129 ; Copy
272
0.26 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 = 128 ; Copy
273
0.31 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 = 89 ; Copy
274
0.34 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 = 109 ; Copy
275
0.33 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 = 130 ; Copy
276
0.55 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 = 131 ; Copy
277
0.44 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 = 132 ; Copy
278
0.42 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 = 133 ; Copy
279
0.33 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 = 134 ; Copy
280
0.31 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 = 135 ; Copy
281
0.30 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 = 110 ; Copy
282
0.32 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 = 136 ; Copy
283
0.29 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 = 137 ; Copy
284
0.31 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 = 138 ; Copy
285
0.27 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 = 111 ; Copy
286
0.27 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 = 140 ; Copy
287
0.27 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 = 139 ; Copy