| 0 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.*
FROM tbl_dictionary
| 1.67ms |
| 1 | SELECT FOUND_ROWS() AS totrow | 282μs |
| 2 | SELECT SQL_CALC_FOUND_ROWS
tbl_settings.*
FROM tbl_settings
WHERE (company_code = 1 OR company_code = '')
AND (shop_code = "seacsub" OR shop_code = '')
| 297μs |
| 3 | SELECT FOUND_ROWS() AS totrow | 186μs |
| 4 | SELECT SQL_CALC_FOUND_ROWS
tbl_products_price_lists.code,
tbl_products_price_lists.description,
tbl_products_price_lists.currency
FROM tbl_products_price_lists
WHERE company_code = 1
GROUP BY
tbl_products_price_lists.code
ORDER BY
FIELD(code, '01') desc, (ABS(code)) asc | 67ms |
| 5 | SELECT FOUND_ROWS() AS totrow | 201μs |
| 6 | SELECT SQL_CALC_FOUND_ROWS
tbl_products_price_lists.code,
tbl_products_price_lists.description,
tbl_products_price_lists.currency
FROM tbl_products_price_lists
WHERE company_code = 1
GROUP BY
tbl_products_price_lists.code
ORDER BY
FIELD(code, '01') desc, (ABS(code)) asc | 67.3ms |
| 7 | SELECT FOUND_ROWS() AS totrow | 219μs |
| 8 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:24:43' AND to_date > '2023-10-02 14:24:43' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 662μs |
| 9 | SELECT FOUND_ROWS() AS totrow | 189μs |
| 10 | SELECT SQL_CALC_FOUND_ROWS
tbl_catalog_categories_product.id,
tbl_catalog_categories_product.parent_id
FROM tbl_catalog_categories_product where enabled = 1 and tbl_catalog_categories_product.id in(SELECT
tpcct.category_id
FROM tbl_products tp
INNER JOIN tbl_families_product tfp ON (tp.family_code = tfp.code) INNER JOIN tbl_categories_product tctp ON (tp.category_code = tctp.code)
LEFT OUTER JOIN tbl_products_price_lists tppl ON (tppl.product_code = tp.code AND tppl.company_code = 1 AND tppl.currency = "99" AND tppl.code = "-1") LEFT OUTER JOIN tbl_products_price_lists tppl_c ON (tppl_c.product_code = tp.code AND tppl_c.company_code = 1 AND tppl_c.currency = '99' AND tppl_c.code = '01')
INNER JOIN tbl_products_catalog_categories tpcct ON (tp.code = tpcct.product_code)
WHERE tpcct.category_id is not null and tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0
GROUP BY
tpcct.category_id
) and (tbl_catalog_categories_product.view_type LIKE '%"0"%' || tbl_catalog_categories_product.view_type LIKE '%"1"%')
| 257μs |
| 11 | SELECT FOUND_ROWS() AS totrow | 208μs |
| 12 | SELECT SQL_CALC_FOUND_ROWS
tbl_catalog_categories_product.id,
tbl_catalog_categories_product.name_it AS name,
tbl_catalog_categories_product.name_it AS name_default,
tbl_catalog_categories_product.nright,
tbl_catalog_categories_product.nleft,
tbl_catalog_categories_product.image,
tbl_catalog_categories_product.stages_category,
tbl_catalog_categories_product.parent_id AS parent
FROM tbl_catalog_categories_product
WHERE id in(1,1,1,1,1,1,1,1,1,15,15,47,47,47,47,47,47,58,58,58,58,1,1,1,15,15,15,15,15,15,152,152,152,152,152,152,152,152,152,152,152,152,152,152,152,152,170,170,170,170,170,170,170,170,47,1,15,15,15,58,58,58,58,58,58,58,58,58,2,4,5,6,7,10,11,13,14,20,26,48,49,50,51,52,55,59,60,61,62,143,144,145,146,147,148,149,150,151,153,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,171,173,175,176,177,178,180,181,182,183,184,185,186,187,188,189,190,195,197,218,220,221)
ORDER BY
tbl_catalog_categories_product.sorting asc | 290μs |
| 13 | SELECT FOUND_ROWS() AS totrow | 183μs |
| 14 | SELECT SQL_CALC_FOUND_ROWS
tbl_pages.url,
tbl_pages.id,
tbl_pages.title_it AS title,
tbl_pages.excerpt_it AS excerpt,
tbl_pages.content_it AS content,
tbl_pages.meta_title_it AS meta_title,
tbl_pages.meta_keywords_it AS meta_keywords,
tbl_pages.meta_description_it AS meta_description,
tbl_pages.title_it AS title_default,
tbl_pages.excerpt_it AS excerpt_default,
tbl_pages.content_it AS content_default,
tbl_pages.meta_title_it AS meta_title_default,
tbl_pages.meta_keywords_it AS meta_keywords_default,
tbl_pages.meta_description_it AS meta_description_default
FROM tbl_pages
WHERE url = "single-product.php" AND enabled = 1 AND
company_code in(0,1)
LIMIT 0, 1 | 371μs |
| 15 | SELECT FOUND_ROWS() AS totrow | 233μs |
| 16 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:24:43' AND to_date > '2023-10-02 14:24:43' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 275μs |
| 17 | SELECT FOUND_ROWS() AS totrow | 354μs |
| 18 | SELECT SQL_CALC_FOUND_ROWS
tp.code_master AS code,
tpd.name_it AS name,
tpd.title_it AS title,
tpd.excerpt_it AS excerpt,
tpd.description_it AS description,
tpd.name_it AS name_default,
tpd.title_it AS title_default,
tpd.excerpt_it AS excerpt_default,
tpd.description_it AS description_default,
tp.family_code,
tfp.name_it AS family_name,
tfp.name_it AS family_name_default,
tp.season_code,
tp.gender_code,
tpd.meta_title_it AS meta_title,
tpd.meta_keywords_it AS meta_keywords,
tpd.meta_description_it AS meta_description,
tpd.meta_title_it AS meta_title_default,
tpd.meta_keywords_it AS meta_keywords_default,
tpd.meta_description_it AS meta_description_default,
tctp.label_variant1_it AS label_variant1,
tctp.label_variant2_it AS label_variant2,
tctp.label_variant1_it AS label_variant1_default,
tctp.label_variant2_it AS label_variant2_default,
tctp.variant_image,
tp.own_production,
tp.pack,
tpd.default_variant1,
MAX(tppl.discount1) AS discount1,
MAX(tppl.discount2) AS discount2,
MIN(tppl.price) AS original_price,
tppl.currency,
MIN(productPrice(tppl.price,tppl.discount1,tppl.discount2)) AS price,
tp.code AS product_image_code
FROM tbl_products tp
INNER JOIN tbl_products_descriptions tpd ON (tpd.product_code_master = tp.code_master) INNER JOIN tbl_families_product tfp ON (tp.family_code = tfp.code) INNER JOIN tbl_categories_product tctp ON (tp.category_code = tctp.code)
LEFT OUTER JOIN tbl_products_price_lists tppl ON (tppl.product_code = tp.code AND tppl.company_code = 1 AND tppl.currency = "99" AND tppl.code = "-1") LEFT OUTER JOIN tbl_products_price_lists tppl_c ON (tppl_c.product_code = tp.code AND tppl_c.company_code = 1 AND tppl_c.currency = '99' AND tppl_c.code = '01')
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND tp.code_master = "0750060"
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc
LIMIT 0, 1 | 2.21ms |
| 19 | SELECT FOUND_ROWS() AS totrow | 214μs |
| 20 | SELECT SQL_CALC_FOUND_ROWS
tbl_image_repository.*,
tbl_products_images.product_code,
tbl_products_images.sorting,
tbl_products_images.hidden,
tbl_products_images.id AS rel_id
FROM tbl_image_repository
LEFT JOIN tbl_products_images ON (tbl_image_repository.id = tbl_products_images.image_id)
LEFT JOIN tbl_products ON (tbl_products_images.product_code = tbl_products.code)
WHERE tbl_products_images.product_code IN ('0750060001180A')
ORDER BY
tbl_products_images.sorting ASC
| 747μs |
| 21 | SELECT SQL_CALC_FOUND_ROWS
tp.code_master,
tqfp.id,
tqfp.image,
tqfp.color,
tqfp.name_it AS name,
tqfp.name_it AS name_default
FROM tbl_products tp
LEFT OUTER JOIN tbl_products_descriptions_quick_features tpdqf ON (tp.code_master = tpdqf.product_description_code) LEFT OUTER JOIN tbl_quick_features_product tqfp ON (tqfp.id = tpdqf.quick_feature_id)
WHERE tp.enabled = 1 AND tqfp.id IS NOT NULL AND tqfp.enabled = 1 AND tp.code_master IN ("0750060")
GROUP BY
tp.code_master,tqfp.id
ORDER BY
tqfp.sorting asc,tqfp.id asc | 652μs |
| 22 | SELECT FOUND_ROWS() AS totrow | 202μs |
| 23 | SELECT SQL_CALC_FOUND_ROWS
tbl_products_descriptions_highlights.product_description_code,
tbl_products_descriptions_highlights.image_url,
tbl_products_descriptions_highlights.image_it AS image_default,
tbl_products_descriptions_highlights.title_it AS title,
tbl_products_descriptions_highlights.title_it AS title_default,
tbl_products_descriptions_highlights.excerpt_it AS excerpt,
tbl_products_descriptions_highlights.excerpt_it AS excerpt_default,
tbl_products_descriptions_highlights.video_url,
tbl_products_descriptions_highlights.video_url_it AS video_url_default
FROM tbl_products_descriptions_highlights
WHERE enabled = 1 AND product_description_code IN ("0750060")
GROUP BY
tbl_products_descriptions_highlights.product_description_code,tbl_products_descriptions_highlights.id
ORDER BY
tbl_products_descriptions_highlights.product_description_code asc,tbl_products_descriptions_highlights. sorting asc,tbl_products_descriptions_highlights. id asc | 630μs |
| 24 | SELECT FOUND_ROWS() AS totrow | 178μs |
| 25 | SELECT SQL_CALC_FOUND_ROWS
tp.code_master,
tp.color_code,
tszp.code,
tszp.name_it AS name,
tszp.name_it AS name_default
FROM tbl_products tp
LEFT OUTER JOIN tbl_sizes_product tszp ON (tp.size = tszp.code)
WHERE (tszp.id IS NOT NULL OR tp.size = '000') AND tp.code_master IN ("0750060") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc | 631μs |
| 26 | SELECT FOUND_ROWS() AS totrow | 178μs |
| 27 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:24:43' AND to_date > '2023-10-02 14:24:43' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 174μs |
| 28 | SELECT FOUND_ROWS() AS totrow | 206μs |
| 29 | SELECT SQL_CALC_FOUND_ROWS
tp.id,
tp.code,
tp.code_master,
tp.color_code,
tcp.name_it AS color_name,
tcp.name_it AS color_name_default,
tpd.name_it,
tpd.name_it AS name_default,
tp.size,
tszp.name_it AS size_name,
tszp.name_it AS size_name_default,
tszp.sorting AS size_sorting,
(tpst.quantity - IFNULL(torr_stb.quantity,0)) AS availability,
tpst.availability_date,
(tpst.future_quantity - IFNULL(torr_stb.quantity,0)) AS future_availability,
tpst.coming_arrivals_quantity,
tpst.coming_arrivals_date,
tp.family_code,
tp.category_code,
tpd.line_code,
tp.season_code,
tp.gender_code,
tp.commercial_code,
tp.own_production,
tp.pack,
tppl.discount1 AS discount1,
tppl.discount2 AS discount2,
productPrice(tppl.price,tppl.discount1,tppl.discount2) AS price,
tppl.price AS original_price,
tp.hide_price,
tppl.currency,
tp.code AS product_image_code
FROM tbl_products tp
INNER JOIN tbl_products_descriptions tpd ON (tpd.product_code_master = tp.code_master) INNER JOIN tbl_families_product tfp ON (tp.family_code = tfp.code) INNER JOIN tbl_categories_product tctp ON (tp.category_code = tctp.code)
LEFT OUTER JOIN tbl_colors_product tcp ON (tp.color_code = tcp.code)
LEFT OUTER JOIN tbl_sizes_product tszp ON (tp.size = tszp.code)
LEFT OUTER JOIN tbl_products_price_lists tppl ON (tppl.product_code = tp.code AND tppl.company_code = 1 AND tppl.currency = "99" AND tppl.code = "-1") LEFT OUTER JOIN tbl_products_price_lists tppl_c ON (tppl_c.product_code = tp.code AND tppl_c.company_code = 1 AND tppl_c.currency = '99' AND tppl_c.code = '01') LEFT OUTER JOIN tbl_products_stocks tpst ON (tpst.product_code = tp.code AND tpst.company_code = "1") LEFT OUTER JOIN (SELECT torr.product_code, SUM(torr.quantity) AS quantity FROM tbl_orders_rows torr JOIN tbl_orders tor on tor.id = torr.order_id WHERE tor.company_code = "1" AND torr.order_status IN ('ordered') AND torr.aside = 0
AND torr.canceled = 0 AND torr.order_type != 5 and tor.order_status >= -1
GROUP BY product_code) torr_stb ON (torr_stb.product_code = tp.code)
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND code_master IN ("0750060")
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc | 2.22ms |
| 30 | SELECT FOUND_ROWS() AS totrow | 184μs |
| 31 | SELECT SQL_CALC_FOUND_ROWS
tbl_image_repository.*,
tbl_products_images.product_code,
tbl_products_images.sorting,
tbl_products_images.hidden,
tbl_products_images.id AS rel_id
FROM tbl_image_repository
LEFT JOIN tbl_products_images ON (tbl_image_repository.id = tbl_products_images.image_id)
LEFT JOIN tbl_products ON (tbl_products_images.product_code = tbl_products.code)
WHERE tbl_products_images.product_code IN ('0750060003180A','0750060001180A','0750060001740A','0750060003130A')
ORDER BY
tbl_products_images.sorting ASC
| 957μs |
| 32 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 248μs |
| 33 | SELECT FOUND_ROWS() AS totrow | 182μs |
| 34 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 172μs |
| 35 | SELECT FOUND_ROWS() AS totrow | 202μs |
| 36 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 166μs |
| 37 | SELECT FOUND_ROWS() AS totrow | 213μs |
| 38 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 170μs |
| 39 | SELECT FOUND_ROWS() AS totrow | 183μs |
| 40 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "801ab24683a4a8c433c6eb40c48bcd9d"
LIMIT 0, 1 | 201μs |
| 41 | SELECT FOUND_ROWS() AS totrow | 186μs |
| 42 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "821b8ee6937cec96c30fdafbfe836d68"
LIMIT 0, 1 | 160μs |
| 43 | SELECT FOUND_ROWS() AS totrow | 165μs |
| 44 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "389c43ba0718d1e10d62d855f0431bfb"
LIMIT 0, 1 | 154μs |
| 45 | SELECT FOUND_ROWS() AS totrow | 161μs |
| 46 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "a922ea470f18bf50b53c239c5d5a414c"
LIMIT 0, 1 | 169μs |
| 47 | SELECT FOUND_ROWS() AS totrow | 164μs |
| 48 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "9aa698f602b1e5694855cee73a683488"
LIMIT 0, 1 | 168μs |
| 49 | SELECT FOUND_ROWS() AS totrow | 160μs |
| 50 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:24:43' AND to_date > '2023-10-02 14:24:43' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 190μs |
| 51 | SELECT FOUND_ROWS() AS totrow | 171μs |
| 52 | SELECT SQL_CALC_FOUND_ROWS
tbl_catalog_categories_product.id,
tbl_catalog_categories_product.parent_id
FROM tbl_catalog_categories_product where enabled = 1 and tbl_catalog_categories_product.id in(SELECT
tpcct.category_id
FROM tbl_products tp
INNER JOIN tbl_families_product tfp ON (tp.family_code = tfp.code) INNER JOIN tbl_categories_product tctp ON (tp.category_code = tctp.code)
LEFT OUTER JOIN tbl_products_price_lists tppl ON (tppl.product_code = tp.code AND tppl.company_code = 1 AND tppl.currency = "99" AND tppl.code = "-1") LEFT OUTER JOIN tbl_products_price_lists tppl_c ON (tppl_c.product_code = tp.code AND tppl_c.company_code = 1 AND tppl_c.currency = '99' AND tppl_c.code = '01')
INNER JOIN tbl_products_catalog_categories tpcct ON (tp.code = tpcct.product_code)
WHERE tpcct.category_id is not null and tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND
tp.code_master = '0750060'
GROUP BY
tpcct.category_id
)
| 1.08ms |
| 53 | SELECT FOUND_ROWS() AS totrow | 179μs |
| 54 | SELECT SQL_CALC_FOUND_ROWS
tbl_catalog_categories_product.id,
tbl_catalog_categories_product.name_it AS name,
tbl_catalog_categories_product.name_it AS name_default,
tbl_catalog_categories_product.nright,
tbl_catalog_categories_product.nleft,
tbl_catalog_categories_product.image,
tbl_catalog_categories_product.stages_category,
tbl_catalog_categories_product.parent_id AS parent
FROM tbl_catalog_categories_product
WHERE id in(63,112)
ORDER BY
tbl_catalog_categories_product.sorting asc | 343μs |
| 55 | SELECT FOUND_ROWS() AS totrow | 188μs |
| 56 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:24:43' AND to_date > '2023-10-02 14:24:43' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 218μs |
| 57 | SELECT FOUND_ROWS() AS totrow | 181μs |
| 58 | SELECT SQL_CALC_FOUND_ROWS
tp.code_master AS code,
tpd.name_it AS name,
tpd.title_it AS title,
tpd.excerpt_it AS excerpt,
tpd.description_it AS description,
tpd.name_it AS name_default,
tpd.title_it AS title_default,
tpd.excerpt_it AS excerpt_default,
tpd.description_it AS description_default,
tp.family_code,
tfp.name_it AS family_name,
tfp.name_it AS family_name_default,
tp.season_code,
tp.gender_code,
tpd.meta_title_it AS meta_title,
tpd.meta_keywords_it AS meta_keywords,
tpd.meta_description_it AS meta_description,
tpd.meta_title_it AS meta_title_default,
tpd.meta_keywords_it AS meta_keywords_default,
tpd.meta_description_it AS meta_description_default,
tctp.label_variant1_it AS label_variant1,
tctp.label_variant2_it AS label_variant2,
tctp.label_variant1_it AS label_variant1_default,
tctp.label_variant2_it AS label_variant2_default,
tctp.variant_image,
tp.own_production,
tp.pack,
tpd.default_variant1,
MAX(tppl.discount1) AS discount1,
MAX(tppl.discount2) AS discount2,
MIN(tppl.price) AS original_price,
tppl.currency,
MIN(productPrice(tppl.price,tppl.discount1,tppl.discount2)) AS price,
tp.code AS product_image_code
FROM tbl_products tp
INNER JOIN tbl_products_descriptions tpd ON (tpd.product_code_master = tp.code_master) INNER JOIN tbl_families_product tfp ON (tp.family_code = tfp.code) INNER JOIN tbl_categories_product tctp ON (tp.category_code = tctp.code)
LEFT OUTER JOIN tbl_products_price_lists tppl ON (tppl.product_code = tp.code AND tppl.company_code = 1 AND tppl.currency = "99" AND tppl.code = "-1") LEFT OUTER JOIN tbl_products_price_lists tppl_c ON (tppl_c.product_code = tp.code AND tppl_c.company_code = 1 AND tppl_c.currency = '99' AND tppl_c.code = '01')
LEFT OUTER JOIN tbl_products_related_products tprp ON (tp.code = tprp.product_related_code)
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND tprp.product_code = '0750060'
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc | 1.47ms |
| 59 | SELECT FOUND_ROWS() AS totrow | 181μs |
| 60 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:24:43' AND to_date > '2023-10-02 14:24:43' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 230μs |
| 61 | SELECT FOUND_ROWS() AS totrow | 191μs |
| 62 | SELECT SQL_CALC_FOUND_ROWS
tp.id,
tp.code,
tp.code_master,
tp.color_code,
tcp.name_it AS color_name,
tcp.name_it AS color_name_default,
tpd.name_it,
tpd.name_it AS name_default,
tp.size,
tszp.name_it AS size_name,
tszp.name_it AS size_name_default,
tszp.sorting AS size_sorting,
(tpst.quantity - IFNULL(torr_stb.quantity,0)) AS availability,
tpst.availability_date,
(tpst.future_quantity - IFNULL(torr_stb.quantity,0)) AS future_availability,
tpst.coming_arrivals_quantity,
tpst.coming_arrivals_date,
tp.family_code,
tp.category_code,
tpd.line_code,
tp.season_code,
tp.gender_code,
tp.commercial_code,
tp.own_production,
tp.pack,
tppl.discount1 AS discount1,
tppl.discount2 AS discount2,
productPrice(tppl.price,tppl.discount1,tppl.discount2) AS price,
tppl.price AS original_price,
tp.hide_price,
tppl.currency,
tp.code AS product_image_code
FROM tbl_products tp
INNER JOIN tbl_products_descriptions tpd ON (tpd.product_code_master = tp.code_master) INNER JOIN tbl_families_product tfp ON (tp.family_code = tfp.code) INNER JOIN tbl_categories_product tctp ON (tp.category_code = tctp.code)
LEFT OUTER JOIN tbl_colors_product tcp ON (tp.color_code = tcp.code)
LEFT OUTER JOIN tbl_sizes_product tszp ON (tp.size = tszp.code)
LEFT OUTER JOIN tbl_products_price_lists tppl ON (tppl.product_code = tp.code AND tppl.company_code = 1 AND tppl.currency = "99" AND tppl.code = "-1") LEFT OUTER JOIN tbl_products_price_lists tppl_c ON (tppl_c.product_code = tp.code AND tppl_c.company_code = 1 AND tppl_c.currency = '99' AND tppl_c.code = '01') LEFT OUTER JOIN tbl_products_stocks tpst ON (tpst.product_code = tp.code AND tpst.company_code = "1") LEFT OUTER JOIN (SELECT torr.product_code, SUM(torr.quantity) AS quantity FROM tbl_orders_rows torr JOIN tbl_orders tor on tor.id = torr.order_id WHERE tor.company_code = "1" AND torr.order_status IN ('ordered') AND torr.aside = 0
AND torr.canceled = 0 AND torr.order_type != 5 and tor.order_status >= -1
GROUP BY product_code) torr_stb ON (torr_stb.product_code = tp.code)
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND code_master IN ("")
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc | 1.37ms |
| 63 | SELECT FOUND_ROWS() AS totrow | 178μs |
| 64 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:24:43' AND to_date > '2023-10-02 14:24:43' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 203μs |
| 65 | SELECT FOUND_ROWS() AS totrow | 213μs |
| 66 | SELECT SQL_CALC_FOUND_ROWS
tp.code_master AS code,
tpd.name_it AS name,
tpd.title_it AS title,
tpd.excerpt_it AS excerpt,
tpd.description_it AS description,
tpd.name_it AS name_default,
tpd.title_it AS title_default,
tpd.excerpt_it AS excerpt_default,
tpd.description_it AS description_default,
tp.family_code,
tfp.name_it AS family_name,
tfp.name_it AS family_name_default,
tp.season_code,
tp.gender_code,
tpd.meta_title_it AS meta_title,
tpd.meta_keywords_it AS meta_keywords,
tpd.meta_description_it AS meta_description,
tpd.meta_title_it AS meta_title_default,
tpd.meta_keywords_it AS meta_keywords_default,
tpd.meta_description_it AS meta_description_default,
tctp.label_variant1_it AS label_variant1,
tctp.label_variant2_it AS label_variant2,
tctp.label_variant1_it AS label_variant1_default,
tctp.label_variant2_it AS label_variant2_default,
tctp.variant_image,
tp.own_production,
tp.pack,
tpd.default_variant1,
MAX(tppl.discount1) AS discount1,
MAX(tppl.discount2) AS discount2,
MIN(tppl.price) AS original_price,
tppl.currency,
MIN(productPrice(tppl.price,tppl.discount1,tppl.discount2)) AS price,
tp.code AS product_image_code
FROM tbl_products tp
INNER JOIN tbl_products_descriptions tpd ON (tpd.product_code_master = tp.code_master) INNER JOIN tbl_families_product tfp ON (tp.family_code = tfp.code) INNER JOIN tbl_categories_product tctp ON (tp.category_code = tctp.code)
LEFT OUTER JOIN tbl_products_price_lists tppl ON (tppl.product_code = tp.code AND tppl.company_code = 1 AND tppl.currency = "99" AND tppl.code = "-1") LEFT OUTER JOIN tbl_products_price_lists tppl_c ON (tppl_c.product_code = tp.code AND tppl_c.company_code = 1 AND tppl_c.currency = '99' AND tppl_c.code = '01')
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND tp.code_master != '0750060'
GROUP BY
tp.code_master
ORDER BY
RAND() asc
LIMIT 0, 4 | 262ms |
| 67 | SELECT FOUND_ROWS() AS totrow | 226μs |
| 68 | SELECT SQL_CALC_FOUND_ROWS
tbl_image_repository.*,
tbl_products_images.product_code,
tbl_products_images.sorting,
tbl_products_images.hidden,
tbl_products_images.id AS rel_id
FROM tbl_image_repository
LEFT JOIN tbl_products_images ON (tbl_image_repository.id = tbl_products_images.image_id)
LEFT JOIN tbl_products ON (tbl_products_images.product_code = tbl_products.code)
WHERE tbl_products_images.product_code IN ('0010048023025A','0710004160451A','1520005000000A','1360013005002A')
ORDER BY
tbl_products_images.sorting ASC
| 1.64ms |
| 69 | SELECT SQL_CALC_FOUND_ROWS
tp.code_master,
tp.color_code,
tszp.code,
tszp.name_it AS name,
tszp.name_it AS name_default
FROM tbl_products tp
LEFT OUTER JOIN tbl_sizes_product tszp ON (tp.size = tszp.code)
WHERE (tszp.id IS NOT NULL OR tp.size = '000') AND tp.code_master IN ("0010048L","0710004","1520005","13600135") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc | 1.25ms |
| 70 | SELECT FOUND_ROWS() AS totrow | 175μs |
| 71 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:24:43' AND to_date > '2023-10-02 14:24:43' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 171μs |
| 72 | SELECT FOUND_ROWS() AS totrow | 158μs |
| 73 | SELECT SQL_CALC_FOUND_ROWS
tp.id,
tp.code,
tp.code_master,
tp.color_code,
tcp.name_it AS color_name,
tcp.name_it AS color_name_default,
tpd.name_it,
tpd.name_it AS name_default,
tp.size,
tszp.name_it AS size_name,
tszp.name_it AS size_name_default,
tszp.sorting AS size_sorting,
(tpst.quantity - IFNULL(torr_stb.quantity,0)) AS availability,
tpst.availability_date,
(tpst.future_quantity - IFNULL(torr_stb.quantity,0)) AS future_availability,
tpst.coming_arrivals_quantity,
tpst.coming_arrivals_date,
tp.family_code,
tp.category_code,
tpd.line_code,
tp.season_code,
tp.gender_code,
tp.commercial_code,
tp.own_production,
tp.pack,
tppl.discount1 AS discount1,
tppl.discount2 AS discount2,
productPrice(tppl.price,tppl.discount1,tppl.discount2) AS price,
tppl.price AS original_price,
tp.hide_price,
tppl.currency,
tp.code AS product_image_code
FROM tbl_products tp
INNER JOIN tbl_products_descriptions tpd ON (tpd.product_code_master = tp.code_master) INNER JOIN tbl_families_product tfp ON (tp.family_code = tfp.code) INNER JOIN tbl_categories_product tctp ON (tp.category_code = tctp.code)
LEFT OUTER JOIN tbl_colors_product tcp ON (tp.color_code = tcp.code)
LEFT OUTER JOIN tbl_sizes_product tszp ON (tp.size = tszp.code)
LEFT OUTER JOIN tbl_products_price_lists tppl ON (tppl.product_code = tp.code AND tppl.company_code = 1 AND tppl.currency = "99" AND tppl.code = "-1") LEFT OUTER JOIN tbl_products_price_lists tppl_c ON (tppl_c.product_code = tp.code AND tppl_c.company_code = 1 AND tppl_c.currency = '99' AND tppl_c.code = '01') LEFT OUTER JOIN tbl_products_stocks tpst ON (tpst.product_code = tp.code AND tpst.company_code = "1") LEFT OUTER JOIN (SELECT torr.product_code, SUM(torr.quantity) AS quantity FROM tbl_orders_rows torr JOIN tbl_orders tor on tor.id = torr.order_id WHERE tor.company_code = "1" AND torr.order_status IN ('ordered') AND torr.aside = 0
AND torr.canceled = 0 AND torr.order_type != 5 and tor.order_status >= -1
GROUP BY product_code) torr_stb ON (torr_stb.product_code = tp.code)
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND code_master IN ("0010048L","0710004","1520005","13600135")
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc | 4.6ms |
| 74 | SELECT FOUND_ROWS() AS totrow | 176μs |
| 75 | SELECT SQL_CALC_FOUND_ROWS
tbl_image_repository.*,
tbl_products_images.product_code,
tbl_products_images.sorting,
tbl_products_images.hidden,
tbl_products_images.id AS rel_id
FROM tbl_image_repository
LEFT JOIN tbl_products_images ON (tbl_image_repository.id = tbl_products_images.image_id)
LEFT JOIN tbl_products ON (tbl_products_images.product_code = tbl_products.code)
WHERE tbl_products_images.product_code IN ('0010048023025A','0010048023040A','0010048023055A','0010048023080A','0010048023105A','0010048023125A','0710004120451A','0710004120461A','0710004120471A','0710004120481A','0710004120491A','0710004120501A','0710004160451A','0710004160461A','0710004160471A','0710004160481A','0710004160491A','0710004160501A','0710004360451A','0710004360461A','0710004360471A','0710004360481A','0710004360491A','0710004360501A','0710004424451A','0710004424461A','0710004424471A','0710004424481A','0710004424491A','0710004424501A','0710004520451A','0710004520461A','0710004520471A','0710004520481A','0710004520491A','0710004520501A','1360013005002A','1520005000000A')
ORDER BY
tbl_products_images.sorting ASC
| 3.14ms |
| 76 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 220μs |
| 77 | SELECT FOUND_ROWS() AS totrow | 163μs |
| 78 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 177μs |
| 79 | SELECT FOUND_ROWS() AS totrow | 177μs |
| 80 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 157μs |
| 81 | SELECT FOUND_ROWS() AS totrow | 153μs |
| 82 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 153μs |
| 83 | SELECT FOUND_ROWS() AS totrow | 166μs |
| 84 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 153μs |
| 85 | SELECT FOUND_ROWS() AS totrow | 176μs |
| 86 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 153μs |
| 87 | SELECT FOUND_ROWS() AS totrow | 150μs |
| 88 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 167μs |
| 89 | SELECT FOUND_ROWS() AS totrow | 156μs |
| 90 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 153μs |
| 91 | SELECT FOUND_ROWS() AS totrow | 191μs |
| 92 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 180μs |
| 93 | SELECT FOUND_ROWS() AS totrow | 155μs |
| 94 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 154μs |
| 95 | SELECT FOUND_ROWS() AS totrow | 153μs |
| 96 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 152μs |
| 97 | SELECT FOUND_ROWS() AS totrow | 178μs |
| 98 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 154μs |
| 99 | SELECT FOUND_ROWS() AS totrow | 195μs |
| 100 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 161μs |
| 101 | SELECT FOUND_ROWS() AS totrow | 171μs |
| 102 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 174μs |
| 103 | SELECT FOUND_ROWS() AS totrow | 195μs |
| 104 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 159μs |
| 105 | SELECT FOUND_ROWS() AS totrow | 152μs |
| 106 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 166μs |
| 107 | SELECT FOUND_ROWS() AS totrow | 152μs |
| 108 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 151μs |
| 109 | SELECT FOUND_ROWS() AS totrow | 150μs |
| 110 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 165μs |
| 111 | SELECT FOUND_ROWS() AS totrow | 152μs |
| 112 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 203μs |
| 113 | SELECT FOUND_ROWS() AS totrow | 157μs |
| 114 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 153μs |
| 115 | SELECT FOUND_ROWS() AS totrow | 230μs |
| 116 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 162μs |
| 117 | SELECT FOUND_ROWS() AS totrow | 152μs |
| 118 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 152μs |
| 119 | SELECT FOUND_ROWS() AS totrow | 150μs |
| 120 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 167μs |
| 121 | SELECT FOUND_ROWS() AS totrow | 154μs |
| 122 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 157μs |
| 123 | SELECT FOUND_ROWS() AS totrow | 152μs |
| 124 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 178μs |
| 125 | SELECT FOUND_ROWS() AS totrow | 169μs |
| 126 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 152μs |
| 127 | SELECT FOUND_ROWS() AS totrow | 151μs |
| 128 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 229μs |
| 129 | SELECT FOUND_ROWS() AS totrow | 168μs |
| 130 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 153μs |
| 131 | SELECT FOUND_ROWS() AS totrow | 152μs |
| 132 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 152μs |
| 133 | SELECT FOUND_ROWS() AS totrow | 150μs |
| 134 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 164μs |
| 135 | SELECT FOUND_ROWS() AS totrow | 152μs |
| 136 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 152μs |
| 137 | SELECT FOUND_ROWS() AS totrow | 149μs |
| 138 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 152μs |
| 139 | SELECT FOUND_ROWS() AS totrow | 150μs |
| 140 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 204μs |
| 141 | SELECT FOUND_ROWS() AS totrow | 177μs |
| 142 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 155μs |
| 143 | SELECT FOUND_ROWS() AS totrow | 151μs |
| 144 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 170μs |
| 145 | SELECT FOUND_ROWS() AS totrow | 151μs |
| 146 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 151μs |
| 147 | SELECT FOUND_ROWS() AS totrow | 151μs |
| 148 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 182μs |
| 149 | SELECT FOUND_ROWS() AS totrow | 181μs |
| 150 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 | 162μs |
| 151 | SELECT FOUND_ROWS() AS totrow | 153μs |
| 152 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.string,
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
| 503μs |
| 153 | SELECT FOUND_ROWS() AS totrow | 196μs |
