¡Vive plenamente tu tiempo libre con las chanclas SEAC Samoa!
Ideales para llevar siempre contigo a la piscina, la playa, el barco o el mar, las exclusivas chanclas SAMOA están fabricadas con un material de calidad, ligero y duradero.
Gracias a la suela antideslizante y a la plantilla de caucho especial, con SEAC Samoa podrá ir donde quiera con seguridad y disfrutar al mismo tiempo de un masaje plantar, para un bienestar y un placer que duran todo el día.
Disponible en numerosas tallas para hombre y mujer.
Measurues | Size |
---|---|
Memory Usage | 20.33 MB |
Load Time | 312ms |
Server Variables |
---|
Array ( [USER] => u.webdevarea [HOME] => /var/www/vhosts/devb2b.seacsub.com [SCRIPT_NAME] => /index.php [REQUEST_URI] => /es/seacsub/1500006t/samoa-tiffany.html [QUERY_STRING] => filename=single-product&pc=1500006t&p=samoa-tiffany&language=es&shop=seacsub [REQUEST_METHOD] => GET [SERVER_PROTOCOL] => HTTP/1.0 [GATEWAY_INTERFACE] => CGI/1.1 [REDIRECT_QUERY_STRING] => filename=single-product&pc=1500006t&p=samoa-tiffany&language=es&shop=seacsub [REDIRECT_URL] => /single-product.php [REMOTE_PORT] => 34222 [SCRIPT_FILENAME] => /var/www/vhosts/devb2b.seacsub.com/httpdocs/index.php [SERVER_ADMIN] => [no address given] [CONTEXT_DOCUMENT_ROOT] => /var/www/vhosts/devb2b.seacsub.com/httpdocs [CONTEXT_PREFIX] => [REQUEST_SCHEME] => https [DOCUMENT_ROOT] => /var/www/vhosts/devb2b.seacsub.com/httpdocs [REMOTE_ADDR] => 3.145.44.46 [SERVER_PORT] => 443 [SERVER_ADDR] => 85.235.148.161 [SERVER_NAME] => devb2b.seacsub.com [SERVER_SOFTWARE] => Apache [SERVER_SIGNATURE] => Apache Server at devb2b.seacsub.com Port 443 [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin [HTTP_COOKIE] => handl_url_base=https%3A%2F%2Fmicrochipusa.com%2Fintegrated-circuits-ics%2FMAX9038EBT-T; handl_ip=3.145.44.46; handl_landing_page=https%3A%2F%2Fmicrochipusa.com%2Fintegrated-circuits-ics%2FMAX9038EBT-T; handl_url=https%3A%2F%2Fmicrochipusa.com%2Fintegrated-circuits-ics%2FMAX9038EBT-T; fikker-Wlyt-7hIO=GKK8gDy2WBm0a8UOyhgfMhkXQZUr9Vif; user_agent=Mozilla%2F5.0%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%3B%20compatible%3B%20ClaudeBot%2F1.0%3B%20%2Bclaudebot%40anthropic.com%29; HandLtestDomainNameServer=HandLtestDomainValueServer [HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate [HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) [HTTP_ACCEPT] => */* [HTTP_CONNECTION] => close [HTTP_X_ACCEL_INTERNAL] => /internal-nginx-static-location [HTTP_X_REAL_IP] => 3.145.44.46 [HTTP_HOST] => devb2b.seacsub.com [proxy-nokeepalive] => 1 [HTTPS] => on [SCRIPT_URI] => https://devb2b.seacsub.com/es/seacsub/1500006t/samoa-tiffany.html [SCRIPT_URL] => /es/seacsub/1500006t/samoa-tiffany.html [UNIQUE_ID] => Z2iyH4tgY9etGU6y1BbX1wAAAAo [REDIRECT_STATUS] => 200 [REDIRECT_HTTPS] => on [REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/es/seacsub/1500006t/samoa-tiffany.html [REDIRECT_SCRIPT_URL] => /es/seacsub/1500006t/samoa-tiffany.html [REDIRECT_UNIQUE_ID] => Z2iyH4tgY9etGU6y1BbX1wAAAAo [REDIRECT_REDIRECT_STATUS] => 200 [REDIRECT_REDIRECT_HTTPS] => on [REDIRECT_REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/es/seacsub/1500006t/samoa-tiffany.html [REDIRECT_REDIRECT_SCRIPT_URL] => /es/seacsub/1500006t/samoa-tiffany.html [REDIRECT_REDIRECT_UNIQUE_ID] => Z2iyH4tgY9etGU6y1BbX1wAAAAo [FCGI_ROLE] => RESPONDER [PHP_SELF] => /index.php [REQUEST_TIME_FLOAT] => 1734914591.4174 [REQUEST_TIME] => 1734914591 ) |
# | Query | Time (sec) |
---|---|---|
0 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.* FROM tbl_dictionary WHERE ifnull(scope,'') = "" | 1.84ms |
1 | SELECT FOUND_ROWS() AS totrow | 435μ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.42ms |
3 | SELECT FOUND_ROWS() AS totrow | 230μs |
4 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_es AS translate FROM tbl_dictionary WHERE slug = "19ec5b589f66eb57230083177d6e5468" and scope is null LIMIT 0, 1 | 268μs |
5 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 01:43:11' AND to_date > '2024-12-23 01:43:11' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 1.48ms |
6 | SELECT FOUND_ROWS() AS totrow | 240μs |
7 | 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"%') | 363μs |
8 | SELECT FOUND_ROWS() AS totrow | 363μs |
9 | SELECT SQL_CALC_FOUND_ROWS tbl_catalog_categories_product.id, tbl_catalog_categories_product.name_es 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 | 312μs |
10 | SELECT FOUND_ROWS() AS totrow | 319μs |
11 | SELECT SQL_CALC_FOUND_ROWS tbl_pages.url, tbl_pages.id, tbl_pages.title_es AS title, tbl_pages.excerpt_es AS excerpt, tbl_pages.content_es AS content, tbl_pages.meta_title_es AS meta_title, tbl_pages.meta_keywords_es AS meta_keywords, tbl_pages.meta_description_es 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 | 301μs |
12 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 01:43:11' AND to_date > '2024-12-23 01:43:11' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 285μs |
13 | SELECT FOUND_ROWS() AS totrow | 170μs |
14 | SELECT SQL_CALC_FOUND_ROWS tp.code_master AS code, tpd.name_es AS name, tpd.title_es AS title, tpd.excerpt_es AS excerpt, tpd.description_es 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_es AS family_name, tfp.name_it AS family_name_default, tp.season_code, tp.gender_code, tpd.meta_title_es AS meta_title, tpd.meta_keywords_es AS meta_keywords, tpd.meta_description_es 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_es AS label_variant1, tctp.label_variant2_es 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') WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND tp.code_master = "1500006t" GROUP BY tp.code_master ORDER BY tpd.sorting asc LIMIT 0, 1 | 3.01ms |
15 | SELECT FOUND_ROWS() AS totrow | 372μs |
16 | 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 ('1500006541441A') ORDER BY tbl_products_images.sorting ASC | 240μs |
17 | SELECT SQL_CALC_FOUND_ROWS tp.code_master, tqfp.id, tqfp.image, tqfp.color, tqfp.name_es 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 ("1500006T") GROUP BY tp.code_master,tqfp.id ORDER BY tqfp.sorting asc,tqfp.id asc | 1.03ms |
18 | SELECT FOUND_ROWS() AS totrow | 213μs |
19 | 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_es AS title, tbl_products_descriptions_highlights.title_it AS title_default, tbl_products_descriptions_highlights.excerpt_es 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 ("1500006T") 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 | 733μs |
20 | SELECT FOUND_ROWS() AS totrow | 164μs |
21 | SELECT SQL_CALC_FOUND_ROWS tp.code_master, tp.color_code, tszp.code, tszp.name_es 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 ("1500006T") AND tp.enabled = 1 GROUP BY tp.code ORDER BY tszp.sorting asc,tszp.id asc | 1.38ms |
22 | SELECT FOUND_ROWS() AS totrow | 177μs |
23 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 01:43:11' AND to_date > '2024-12-23 01:43:11' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 231μs |
24 | SELECT FOUND_ROWS() AS totrow | 177μs |
25 | SELECT SQL_CALC_FOUND_ROWS tp.id, tp.code, tp.code_master, tp.color_code, tcp.name_es AS color_name, tcp.name_it AS color_name_default, tpd.name_es, tpd.name_it AS name_default, tp.size, tszp.name_es 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) WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND code_master IN ("1500006T") GROUP BY tp.code ORDER BY tp.color_code asc,tszp.sorting asc | 3.29ms |
26 | SELECT FOUND_ROWS() AS totrow | 190μs |
27 | 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 ('1500006541441A','1500006541451A','1500006541461A','1500006541471A','1500006541481A','1500006541491A') ORDER BY tbl_products_images.sorting ASC | 260μs |
28 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 01:43:11' AND to_date > '2024-12-23 01:43:11' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 547μs |
29 | SELECT FOUND_ROWS() AS totrow | 328μs |
30 | 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 = '1500006T' GROUP BY tpcct.category_id ) | 231μs |
31 | SELECT FOUND_ROWS() AS totrow | 176μs |
32 | SELECT SQL_CALC_FOUND_ROWS tbl_catalog_categories_product.id, tbl_catalog_categories_product.name_es 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(15,25) ORDER BY tbl_catalog_categories_product.sorting asc | 167μs |
33 | SELECT FOUND_ROWS() AS totrow | 160μs |
34 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 01:43:11' AND to_date > '2024-12-23 01:43:11' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 246μs |
35 | SELECT FOUND_ROWS() AS totrow | 162μs |
36 | SELECT SQL_CALC_FOUND_ROWS tp.code_master AS code, tpd.name_es AS name, tpd.title_es AS title, tpd.excerpt_es AS excerpt, tpd.description_es 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_es AS family_name, tfp.name_it AS family_name_default, tp.season_code, tp.gender_code, tpd.meta_title_es AS meta_title, tpd.meta_keywords_es AS meta_keywords, tpd.meta_description_es 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_es AS label_variant1, tctp.label_variant2_es 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_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 = '1500006T' GROUP BY tp.code_master ORDER BY tpd.sorting asc | 2.02ms |
37 | SELECT FOUND_ROWS() AS totrow | 201μs |
38 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 01:43:11' AND to_date > '2024-12-23 01:43:11' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 304μs |
39 | SELECT FOUND_ROWS() AS totrow | 182μs |
40 | SELECT SQL_CALC_FOUND_ROWS tp.id, tp.code, tp.code_master, tp.color_code, tcp.name_es AS color_name, tcp.name_it AS color_name_default, tpd.name_es, tpd.name_it AS name_default, tp.size, tszp.name_es 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 ("") AND tcctp.nright <= 39 and tcctp.nleft >= 38 GROUP BY tp.code ORDER BY tp.color_code asc,tszp.sorting asc | 2.94ms |
41 | SELECT FOUND_ROWS() AS totrow | 175μs |
42 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 01:43:11' AND to_date > '2024-12-23 01:43:11' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 149μs |
43 | SELECT FOUND_ROWS() AS totrow | 130μs |
44 | SELECT SQL_CALC_FOUND_ROWS tp.code_master AS code, tpd.name_es AS name, tpd.title_es AS title, tpd.excerpt_es AS excerpt, tpd.description_es 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_es AS family_name, tfp.name_it AS family_name_default, tp.season_code, tp.gender_code, tpd.meta_title_es AS meta_title, tpd.meta_keywords_es AS meta_keywords, tpd.meta_description_es 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_es AS label_variant1, tctp.label_variant2_es 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 <= 39 and tcctp.nleft >= 38 AND tp.code_master != '1500006T' GROUP BY tp.code_master ORDER BY RAND() asc LIMIT 0, 4 | 15.43ms |
45 | SELECT FOUND_ROWS() AS totrow | 205μs |
46 | 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 ('1500016526450A','1500017530450A','1500021520440A','1500001000410A') ORDER BY tbl_products_images.sorting ASC | 1.43ms |
47 | SELECT SQL_CALC_FOUND_ROWS tp.code_master, tp.color_code, tszp.code, tszp.name_es 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 ("1500016","1500017","1500021","1500001") AND tp.enabled = 1 GROUP BY tp.code ORDER BY tszp.sorting asc,tszp.id asc | 1.93ms |
48 | SELECT FOUND_ROWS() AS totrow | 206μs |
49 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 01:43:11' AND to_date > '2024-12-23 01:43:11' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 180μs |
50 | SELECT FOUND_ROWS() AS totrow | 172μs |
51 | SELECT SQL_CALC_FOUND_ROWS tp.id, tp.code, tp.code_master, tp.color_code, tcp.name_es AS color_name, tcp.name_it AS color_name_default, tpd.name_es, tpd.name_it AS name_default, tp.size, tszp.name_es 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 ("1500016","1500017","1500021","1500001") AND tcctp.nright <= 39 and tcctp.nleft >= 38 GROUP BY tp.code ORDER BY tp.color_code asc,tszp.sorting asc | 106ms |
52 | SELECT FOUND_ROWS() AS totrow | 394μs |
53 | 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 ('1500001000410A','1500001000415A','1500001000420A','1500001000425A','1500001000430A','1500001000435A','1500001000440A','1500001000445A','1500001000450A','1500001000455A','1500001000460A','1500001000465A','1500001000470A','1500001000475A','1500001000480A','1500001000485A','1500001000490A','1500001000495A','1500001000500A','1500001000505A','1500001400410A','1500001400415A','1500001400420A','1500001400425A','1500001400430A','1500001400435A','1500001400440A','1500001400445A','1500001400450A','1500001400455A','1500001400460A','1500001400465A','1500001400470A','1500001400475A','1500001400480A','1500001400485A','1500001400490A','1500001400495A','1500001400500A','1500021520440A','1500021520445A','1500021520450A','1500021520455A','1500021520460A','1500021520465A','1500021520470A','1500021520475A','1500021520480A','1500021520485A','1500021520490A','1500021520495A','1500021520500A','1500021520505A','1500016526450A','1500016526455A','1500016526460A','1500016526465A','1500016526470A','1500016526475A','1500016526480A','1500016526485A','1500016526490A','1500016526495A','1500017530450A','1500017530455A','1500017530460A','1500017530465A','1500017530470A','1500017530475A','1500017530480A','1500017530485A','1500017530490A','1500017530495A','1500017530500A','1500017530505A','1500016531450A','1500016531455A','1500016531460A','1500016531465A','1500016531470A','1500016531475A','1500016531480A','1500016531485A','1500016531490A','1500016531495A') ORDER BY tbl_products_images.sorting ASC | 8.05ms |
54 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_es AS translate FROM tbl_dictionary WHERE slug = "68cb97e86fabb3cc85d81e5d09089d31" and scope is null LIMIT 0, 1 | 266μs |
55 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_es AS translate FROM tbl_dictionary WHERE slug = "c44a1a3420df56fe335fab4668d57c90" and scope is null LIMIT 0, 1 | 141μs |
56 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_es AS translate FROM tbl_dictionary WHERE slug = "9ce416335987b4dfdc083db1fde250e2" and scope is null LIMIT 0, 1 | 133μs |
57 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_es AS translate FROM tbl_dictionary WHERE slug = "ff6fbc0f84e2abc908206014316f0b99" and scope is null LIMIT 0, 1 | 150μs |
58 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_es AS translate FROM tbl_dictionary WHERE slug = "1113fca866539d319db4413175dc1bd1" and scope is null LIMIT 0, 1 | 142μs |
59 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_es AS translate FROM tbl_dictionary WHERE slug = "0a0b6f3f2fb36e77b9788457562b95e0" and scope is null LIMIT 0, 1 | 134μs |
60 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.string, tbl_dictionary.translate_es AS translate FROM tbl_dictionary WHERE ifnull(scope,'') = "" | 397μs |
61 | SELECT FOUND_ROWS() AS totrow | 221μs |
Totale | 163ms |