0 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.* FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
| 1.46ms |
1 | SELECT FOUND_ROWS() AS totrow | 338μ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 = '')
| 1.24ms |
3 | SELECT FOUND_ROWS() AS totrow | 258μs |
4 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-06 15:09:18' AND to_date > '2024-11-06 15:09:18' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 1.34ms |
5 | SELECT FOUND_ROWS() AS totrow | 237μs |
6 | 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"%')
| 318μs |
7 | SELECT FOUND_ROWS() AS totrow | 178μs |
8 | 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,15,47,47,47,47,47,47,47,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,1,2,4,5,6,7,10,11,13,14,20,25,26,48,49,50,51,52,55,56,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,186,224,251)
ORDER BY
tbl_catalog_categories_product.sorting asc | 224μs |
9 | SELECT FOUND_ROWS() AS totrow | 171μs |
10 | 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 = "catalog.php" AND enabled = 1 AND
company_code in(0,1)
LIMIT 0, 1 | 266μs |
11 | SELECT SQL_CALC_FOUND_ROWS
tbl_banners.position,
tbl_banners.id,
tbl_banners.title_it AS title,
tbl_banners.subtitle_it AS subtitle,
tbl_banners.excerpt_it AS excerpt,
tbl_banners.link_text_it AS link_text,
tbl_banners.link_it AS link,
tbl_banners.image_it AS image,
tbl_banners.icon,
tbl_banners.page_id,
tbl_banners.category_id,
tbl_banners.view_type,
tbl_banners.title_it AS title_default,
tbl_banners.subtitle_it AS subtitle_default,
tbl_banners.excerpt_it AS excerpt_default,
tbl_banners.link_text_it AS link_text_default,
tbl_banners.link_it AS link_default,
tbl_banners.image_it AS image_default FROM tbl_banners
WHERE enabled = 1 AND (shop_code = "seacsub" OR shop_code = "") AND ( page_id LIKE '%"5"%' AND
(category_id LIKE '%"10"%' OR category_id LIKE '%"0"%') AND
(view_type LIKE '%"0"%' OR view_type LIKE '%"1"%')) AND
company_code in(0,1)
ORDER BY
tbl_banners.sorting asc | 985μs |
12 | SELECT FOUND_ROWS() AS totrow | 185μs |
13 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-06 15:09:18' AND to_date > '2024-11-06 15:09:18' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 584μs |
14 | SELECT FOUND_ROWS() AS totrow | 365μs |
15 | 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,
tp.featured,
tp.featured2,
MAX(tppl.discount1) AS discount1,
MAX(tppl.discount2) AS discount2,
MAX(tppl.discount3) AS discount3,
MIN(tppl.price) AS original_price,
tppl.currency,
MIN(productPrice(tppl.price,tppl.discount1,tppl.discount2,tppl.discount3)) AS price,
MAX(tp.featured) AS featured,
MAX(tp.featured2) AS featured2,
MAX(tp.new) AS new,
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_catalog_categories tpcct ON (tp.code = tpcct.product_code) LEFT OUTER JOIN tbl_catalog_categories_product tcctp ON (tcctp.id = tpcct.category_id)
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND tcctp.nright <= 13 and tcctp.nleft >= 12
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc
LIMIT 0, 8 | 13.36ms |
16 | SELECT FOUND_ROWS() AS totrow | 302μs |
17 | 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 ('0710055120030A','0710043160070A','0710012160070A','0710036520030A','0710037160050A','0710001120461A','0710004120461A','0730023520025A')
ORDER BY
tbl_products_images.sorting ASC
| 2.4ms |
18 | 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 ("0710055","0710043","0710012","0710036","0710037","0710001","0710004","0730023N") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc | 2.82ms |
19 | SELECT FOUND_ROWS() AS totrow | 249μs |
20 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-06 15:09:18' AND to_date > '2024-11-06 15:09:18' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 234μs |
21 | SELECT FOUND_ROWS() AS totrow | 268μs |
22 | 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,
tppl.discount3 AS discount3,
productPrice(tppl.price,tppl.discount1,tppl.discount2,tppl.discount3) 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)
LEFT OUTER JOIN tbl_products_catalog_categories tpcct ON (tp.code = tpcct.product_code) LEFT OUTER JOIN tbl_catalog_categories_product tcctp ON (tcctp.id = tpcct.category_id)
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND code_master IN ("0710055","0710043","0710012","0710036","0710037","0710001","0710004","0730023N") AND tcctp.nright <= 13 and tcctp.nleft >= 12
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc | 98.84ms |
23 | SELECT FOUND_ROWS() AS totrow | 309μs |
24 | 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 ('0710055120030A','0710043120050A','0710055120050A','0710012120050A','0710043120070A','0710012120070A','0710055120070A','0710012120095A','0710055120095A','0710043120095A','0710055120110A','0710001120451A','0710004120451A','0710001120461A','0710004120461A','0710004120471A','0710001120471A','0710004120481A','0710001120481A','0710001120491A','0710004120491A','0710001120501A','0710004120501A','0710055160030A','0710037160030A','0710036160030A','0710036160050A','0710055160050A','0710037160050A','0710043160050A','0710012160050A','0710055160070A','0710012160070A','0710037160070A','0710043160070A','0710036160070A','0710043160095A','0710012160095A','0710036160095A','0710055160095A','0710037160095A','0710055160110A','0710004160451A','0710001160451A','0710004160461A','0710001160461A','0710001160471A','0710004160471A','0710001160481A','0710004160481A','0710004160491A','0710001160491A','0710004160501A','0710001160501A','0710055360030A','0710037360030A','0710036360030A','0710043360050A','0710055360050A','0710037360050A','0710036360050A','0710012360050A','0710036360070A','0710012360070A','0710043360070A','0710055360070A','0710037360070A','0710043360095A','0710055360095A','0710037360095A','0710036360095A','0710012360095A','0710055360110A','0710001360451A','0710004360451A','0710001360461A','0710004360461A','0710001360471A','0710004360471A','0710001360481A','0710004360481A','0710001360491A','0710004360491A','0710001360501A','0710004360501A','0710055520030A','0710036520030A','0710037520030A','0710043520050A','0710012520050A','0710036520050A','0710037520050A','0710055520050A','0710043520070A','0710012520070A','0710037520070A','0710036520070A','0710055520070A','0710037520095A','0710036520095A','0710055520095A','0710043520095A','0710012520095A','0710055520110A','0710004520451A','0710001520451A','0710004520461A','0710001520461A','0710004520471A','0710001520471A','0710004520481A','0710001520481A','0710004520491A','0710001520491A','0710004520501A','0710001520501A','0710036680030A','0710037680030A','0710037680050A','0710036680050A','0710036680070A','0710037680070A','0710055720030A','0710055720050A','0710055720070A','0710055720095A','0710055720110A','0710001720451A','0710001720461A','0710001720471A','0710001720481A','0710001720491A','0710001720501A','0710043799050A','0710012799050A','0710043799070A','0710012799070A','0710043799095A','0710012799095A','0710004799451A','0710001799451A','0710004799461A','0710001799461A','0710001799471A','0710004799471A','0710001799481A','0710004799481A','0710004799491A','0710001799491A','0710004799501A','0710001799501A','0730024520000A','0730023520000A','0730023520025A')
ORDER BY
tbl_products_images.sorting ASC
| 13.03ms |
25 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-06 15:09:18' AND to_date > '2024-11-06 15:09:18' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 299μs |
26 | SELECT FOUND_ROWS() AS totrow | 232μs |
27 | SELECT SQL_CALC_FOUND_ROWS
tszp.code,
tszp.name_it AS name,
tszp.name_it AS name_default
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_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_catalog_categories tpcct ON (tp.code = tpcct.product_code) LEFT OUTER JOIN tbl_catalog_categories_product tcctp ON (tcctp.id = tpcct.category_id)
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND tcctp.nright <= 13 and tcctp.nleft >= 12 AND tszp.id IS NOT NULL AND tszp.type = 1
GROUP BY
tszp.name_it
ORDER BY
tszp.sorting asc | 7.45ms |
28 | SELECT FOUND_ROWS() AS totrow | 175μs |
29 | SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-06 15:09:18' AND to_date > '2024-11-06 15:09:18' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
| 125μs |
30 | SELECT FOUND_ROWS() AS totrow | 109μs |
31 | SELECT SQL_CALC_FOUND_ROWS
tgp.code,
tgp.name_it AS name,
tgp.name_it AS name_default
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_genders_product tgp ON (tp.gender_code = tgp.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_catalog_categories tpcct ON (tp.code = tpcct.product_code) LEFT OUTER JOIN tbl_catalog_categories_product tcctp ON (tcctp.id = tpcct.category_id)
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND tcctp.nright <= 13 and tcctp.nleft >= 12 AND tgp.id IS NOT NULL
GROUP BY
tgp.id
ORDER BY
tgp.sorting asc | 6.3ms |
32 | SELECT FOUND_ROWS() AS totrow | 144μs |
33 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate FROM tbl_dictionary
WHERE
slug = "068f80c7519d0528fb08e82137a72131" and scope is null
LIMIT 0, 1 | 171μs |
34 | SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.string,
tbl_dictionary.translate_it AS translate FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
| 437μs |
35 | SELECT FOUND_ROWS() AS totrow | 179μs |