SEAC Invidia, 3 mm Neopren, Ultrastretch, einteiliger Neoprenanzug mit Frontreißverschluss zum Tauchen, Schnorcheln und Freitauchen
- ULTRA ELASTISCH VOM KOPF BIS ZU DEN FÜSSEN - SEAC Invidia ist ein Neoprenanzug, der vollständig aus 3 mm UltraStretch Neopren besteht, um Ihnen jederzeit maximalen Komfort bei Ihren Tauchaktivitäten zu garantieren. Das verwendete Neopren entspricht zu 100% der europäischen REACH-Verordnung.
- MAXIMALE ELASTIZITÄT, NULL STRESS - Die unglaubliche Weichheit und Elastizität des SEAC Invidia Neoprenanzugs, kombiniert mit dem praktischen vertikalen YKK-Frontverschluss, machen das An- und Ausziehen auch an den heißesten Tagen einfach. Außerdem schränkt das UltraStretch-Neopren die Bewegungsfreiheit nicht, was für mehr Freiheit sorgt.
- SUPER VIELSEITIG - Der SEAC Invidia kann als Neoprenanzug für Männer und Frauen, zum Freitauchen in gemäßigten offenen Gewässern (+20°) und zum Schnorcheln und Schwimmen, auch in kühleren Jahreszeiten, verwendet werden.
- KOMFORT-PASSFORM FÜR FRAUEN UND MÄNNER - Der SEAC Invidia Neoprenanzug ist sowohl für Frauen als auch für Männer erhältlich, mit 2 verschiedenen Schnitten, die sich natürlich der Körperform anpassen.
- 6 GRÖSSEN - SEAC Invidia ist in 6 Größen für Männer und 6 Größen für Frauen erhältlich. Die extreme Elastizität des Neoprenanzugs bietet optimale Passform und Komfort für jeden.
BESCHREIBUNG
Sind Sie auf der Suche nach einem extrem dehnbaren und vielseitigen Neoprenanzug für maximalen Komfort bei Ihren Tauchaktivitäten?
SEAC Invidia ist der hochwertige 3 mm Ultrastretch-Neoprenanzug für optimalen Komfort unter allen Bedingungen und bei jeder Wassersportaktivität.
Das verwendete Neopren entspricht zu 100% der europäischen REACH-Verordnung und vermittelt ein angenehmes Gefühl der Freiheit an Armen und Beinen.
Der Frontverschluss mit praktischem YKK-Reißverschluss und die extreme Weichheit erleichtern das Anziehen, auch an heißen Tagen.
Komfort wird mit extremer Liebe zum Detail kombiniert: Flatlock-Nähte und verstärkte Powertek-Kniepolster vervollständigen das minimalistische und elegante Design dieses Neoprenanzugs und machen ihn schön anzuschauen und bequem zu tragen.
Erhältlich in 6 Herren- und 6 Damengrößen, kann der SEAC Invidia als Neoprenanzug zum Tauchen, Freitauchen in gemäßigten offenen Gewässern (mit Temperaturen über 20°), Schnorcheln und Schwimmen verwendet werden und garantiert perfekten Schutz auch in den kühleren Jahreszeiten.
Measurues | Size |
---|---|
Memory Usage | 19.53 MB |
Load Time | 185ms |
Server Variables |
---|
Array ( [USER] => u.webdevarea [HOME] => /var/www/vhosts/devb2b.seacsub.com [SCRIPT_NAME] => /index.php [REQUEST_URI] => /de/seacsub/0010460/m-lungo-invidia.html [QUERY_STRING] => filename=single-product&pc=0010460&p=m-lungo-invidia&language=de&shop=seacsub [REQUEST_METHOD] => GET [SERVER_PROTOCOL] => HTTP/1.0 [GATEWAY_INTERFACE] => CGI/1.1 [REDIRECT_QUERY_STRING] => filename=single-product&pc=0010460&p=m-lungo-invidia&language=de&shop=seacsub [REDIRECT_URL] => /single-product.php [REMOTE_PORT] => 56168 [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] => 18.119.157.241 [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] => care_did=220e3061-19fa-4b99-b76c-9086f9cf9574 [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] => 18.119.157.241 [HTTP_HOST] => devb2b.seacsub.com [proxy-nokeepalive] => 1 [HTTPS] => on [SCRIPT_URI] => https://devb2b.seacsub.com/de/seacsub/0010460/m-lungo-invidia.html [SCRIPT_URL] => /de/seacsub/0010460/m-lungo-invidia.html [UNIQUE_ID] => Z2juy2eGD_n95HcwmvX8rAAAABA [REDIRECT_STATUS] => 200 [REDIRECT_HTTPS] => on [REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/de/seacsub/0010460/m-lungo-invidia.html [REDIRECT_SCRIPT_URL] => /de/seacsub/0010460/m-lungo-invidia.html [REDIRECT_UNIQUE_ID] => Z2juy2eGD_n95HcwmvX8rAAAABA [REDIRECT_REDIRECT_STATUS] => 200 [REDIRECT_REDIRECT_HTTPS] => on [REDIRECT_REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/de/seacsub/0010460/m-lungo-invidia.html [REDIRECT_REDIRECT_SCRIPT_URL] => /de/seacsub/0010460/m-lungo-invidia.html [REDIRECT_REDIRECT_UNIQUE_ID] => Z2juy2eGD_n95HcwmvX8rAAAABA [FCGI_ROLE] => RESPONDER [PHP_SELF] => /index.php [REQUEST_TIME_FLOAT] => 1734930123.9261 [REQUEST_TIME] => 1734930123 ) |
# | Query | Time (sec) |
---|---|---|
0 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.* FROM tbl_dictionary WHERE ifnull(scope,'') = "" | 806μs |
1 | SELECT FOUND_ROWS() AS totrow | 292μ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.06ms |
3 | SELECT FOUND_ROWS() AS totrow | 246μs |
4 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_de AS translate FROM tbl_dictionary WHERE slug = "19ec5b589f66eb57230083177d6e5468" and scope is null LIMIT 0, 1 | 289μs |
5 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 06:02:03' AND to_date > '2024-12-23 06:02:03' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 1.21ms |
6 | SELECT FOUND_ROWS() AS totrow | 189μ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"%') | 274μs |
8 | SELECT FOUND_ROWS() AS totrow | 146μs |
9 | SELECT SQL_CALC_FOUND_ROWS tbl_catalog_categories_product.id, tbl_catalog_categories_product.name_de 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 | 156μs |
10 | SELECT FOUND_ROWS() AS totrow | 122μs |
11 | SELECT SQL_CALC_FOUND_ROWS tbl_pages.url, tbl_pages.id, tbl_pages.title_de AS title, tbl_pages.excerpt_de AS excerpt, tbl_pages.content_de AS content, tbl_pages.meta_title_de AS meta_title, tbl_pages.meta_keywords_de AS meta_keywords, tbl_pages.meta_description_de 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 | 210μs |
12 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 06:02:03' AND to_date > '2024-12-23 06:02:03' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 175μs |
13 | SELECT FOUND_ROWS() AS totrow | 185μs |
14 | SELECT SQL_CALC_FOUND_ROWS tp.code_master AS code, tpd.name_de AS name, tpd.title_de AS title, tpd.excerpt_de AS excerpt, tpd.description_de 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_de AS family_name, tfp.name_it AS family_name_default, tp.season_code, tp.gender_code, tpd.meta_title_de AS meta_title, tpd.meta_keywords_de AS meta_keywords, tpd.meta_description_de 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_de AS label_variant1, tctp.label_variant2_de 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 = "0010460" GROUP BY tp.code_master ORDER BY tpd.sorting asc LIMIT 0, 1 | 2.75ms |
15 | SELECT FOUND_ROWS() AS totrow | 300μ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 ('0010460270040A') ORDER BY tbl_products_images.sorting ASC | 239μs |
17 | SELECT SQL_CALC_FOUND_ROWS tp.code_master, tqfp.id, tqfp.image, tqfp.color, tqfp.name_de 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 ("0010460") GROUP BY tp.code_master,tqfp.id ORDER BY tqfp.sorting asc,tqfp.id asc | 1.3ms |
18 | SELECT FOUND_ROWS() AS totrow | 190μ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_de AS title, tbl_products_descriptions_highlights.title_it AS title_default, tbl_products_descriptions_highlights.excerpt_de 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 ("0010460") 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 | 835μs |
20 | SELECT FOUND_ROWS() AS totrow | 198μs |
21 | SELECT SQL_CALC_FOUND_ROWS tp.code_master, tp.color_code, tszp.code, tszp.name_de 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 ("0010460") AND tp.enabled = 1 GROUP BY tp.code ORDER BY tszp.sorting asc,tszp.id asc | 883μs |
22 | SELECT FOUND_ROWS() AS totrow | 175μs |
23 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 06:02:04' AND to_date > '2024-12-23 06:02:04' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 592μs |
24 | SELECT FOUND_ROWS() AS totrow | 139μs |
25 | SELECT SQL_CALC_FOUND_ROWS tp.id, tp.code, tp.code_master, tp.color_code, tcp.name_de AS color_name, tcp.name_it AS color_name_default, tpd.name_de, tpd.name_it AS name_default, tp.size, tszp.name_de 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 ("0010460") GROUP BY tp.code ORDER BY tp.color_code asc,tszp.sorting asc | 3.66ms |
26 | SELECT FOUND_ROWS() AS totrow | 136μ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 ('0010460270040A','0010460270055A','0010460270080A','0010460270105A','0010460270125A','0010460270145A') ORDER BY tbl_products_images.sorting ASC | 225μs |
28 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 06:02:04' AND to_date > '2024-12-23 06:02:04' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 335μs |
29 | SELECT FOUND_ROWS() AS totrow | 242μ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 = '0010460' GROUP BY tpcct.category_id ) | 190μs |
31 | SELECT FOUND_ROWS() AS totrow | 135μs |
32 | SELECT SQL_CALC_FOUND_ROWS tbl_catalog_categories_product.id, tbl_catalog_categories_product.name_de 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,15,7,224) ORDER BY tbl_catalog_categories_product.sorting asc | 119μs |
33 | SELECT FOUND_ROWS() AS totrow | 115μs |
34 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 06:02:04' AND to_date > '2024-12-23 06:02:04' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 168μs |
35 | SELECT FOUND_ROWS() AS totrow | 128μs |
36 | SELECT SQL_CALC_FOUND_ROWS tp.code_master AS code, tpd.name_de AS name, tpd.title_de AS title, tpd.excerpt_de AS excerpt, tpd.description_de 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_de AS family_name, tfp.name_it AS family_name_default, tp.season_code, tp.gender_code, tpd.meta_title_de AS meta_title, tpd.meta_keywords_de AS meta_keywords, tpd.meta_description_de 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_de AS label_variant1, tctp.label_variant2_de 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 = '0010460' GROUP BY tp.code_master ORDER BY tpd.sorting asc | 1.83ms |
37 | SELECT FOUND_ROWS() AS totrow | 152μs |
38 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 06:02:04' AND to_date > '2024-12-23 06:02:04' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 114μs |
39 | SELECT FOUND_ROWS() AS totrow | 149μs |
40 | SELECT SQL_CALC_FOUND_ROWS tp.id, tp.code, tp.code_master, tp.color_code, tcp.name_de AS color_name, tcp.name_it AS color_name_default, tpd.name_de, tpd.name_it AS name_default, tp.size, tszp.name_de 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 <= 11 and tcctp.nleft >= 10 GROUP BY tp.code ORDER BY tp.color_code asc,tszp.sorting asc | 2.77ms |
41 | SELECT FOUND_ROWS() AS totrow | 136μs |
42 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 06:02:04' AND to_date > '2024-12-23 06:02:04' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 96μs |
43 | SELECT FOUND_ROWS() AS totrow | 135μs |
44 | SELECT SQL_CALC_FOUND_ROWS tp.code_master AS code, tpd.name_de AS name, tpd.title_de AS title, tpd.excerpt_de AS excerpt, tpd.description_de 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_de AS family_name, tfp.name_it AS family_name_default, tp.season_code, tp.gender_code, tpd.meta_title_de AS meta_title, tpd.meta_keywords_de AS meta_keywords, tpd.meta_description_de 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_de AS label_variant1, tctp.label_variant2_de 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 <= 11 and tcctp.nleft >= 10 AND tp.code_master != '0010460' GROUP BY tp.code_master ORDER BY RAND() asc LIMIT 0, 4 | 21.12ms |
45 | SELECT FOUND_ROWS() AS totrow | 217μ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 ('0010218230055A','0010450250040A','0010218270040A','0010382064215A') ORDER BY tbl_products_images.sorting ASC | 1.47ms |
47 | SELECT SQL_CALC_FOUND_ROWS tp.code_master, tp.color_code, tszp.code, tszp.name_de 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 ("0010218M7","0010450","0010218M3","0010382") AND tp.enabled = 1 GROUP BY tp.code ORDER BY tszp.sorting asc,tszp.id asc | 1.18ms |
48 | SELECT FOUND_ROWS() AS totrow | 150μs |
49 | SELECT SQL_CALC_FOUND_ROWS tbl_exclusions.* FROM tbl_exclusions WHERE enabled = 1 AND from_date < '2024-12-23 06:02:04' AND to_date > '2024-12-23 06:02:04' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND company_code = 1 | 105μs |
50 | SELECT FOUND_ROWS() AS totrow | 104μs |
51 | SELECT SQL_CALC_FOUND_ROWS tp.id, tp.code, tp.code_master, tp.color_code, tcp.name_de AS color_name, tcp.name_it AS color_name_default, tpd.name_de, tpd.name_it AS name_default, tp.size, tszp.name_de 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 ("0010218M7","0010450","0010218M3","0010382") AND tcctp.nright <= 11 and tcctp.nleft >= 10 GROUP BY tp.code ORDER BY tp.color_code asc,tszp.sorting asc | 10.99ms |
52 | SELECT FOUND_ROWS() AS totrow | 204μ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 ('0010382064215A','0010382064220A','0010382064225A','0010218230040A','0010218230055A','0010218230080A','0010218230105A','0010218230125A','0010218230145A','0010218230160A','0010450250040A','0010450250055A','0010450250080A','0010450250105A','0010450250125A','0010450250145A','0010218270040A','0010218270055A','0010218270080A','0010218270085A','0010218270105A','0010218270125A','0010218270090A','0010218270115A','0010218270120A','0010218270135A','0010218270140A','0010218270145A','0010218270150A','0010218270160A') ORDER BY tbl_products_images.sorting ASC | 2.94ms |
54 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_de AS translate FROM tbl_dictionary WHERE slug = "68cb97e86fabb3cc85d81e5d09089d31" and scope is null LIMIT 0, 1 | 188μs |
55 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_de AS translate FROM tbl_dictionary WHERE slug = "c44a1a3420df56fe335fab4668d57c90" and scope is null LIMIT 0, 1 | 105μs |
56 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_de AS translate FROM tbl_dictionary WHERE slug = "9ce416335987b4dfdc083db1fde250e2" and scope is null LIMIT 0, 1 | 129μs |
57 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_de AS translate FROM tbl_dictionary WHERE slug = "ff6fbc0f84e2abc908206014316f0b99" and scope is null LIMIT 0, 1 | 172μs |
58 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_de AS translate FROM tbl_dictionary WHERE slug = "1113fca866539d319db4413175dc1bd1" and scope is null LIMIT 0, 1 | 112μs |
59 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.translate_de AS translate FROM tbl_dictionary WHERE slug = "0a0b6f3f2fb36e77b9788457562b95e0" and scope is null LIMIT 0, 1 | 121μs |
60 | SELECT SQL_CALC_FOUND_ROWS tbl_dictionary.string, tbl_dictionary.translate_de AS translate FROM tbl_dictionary WHERE ifnull(scope,'') = "" | 332μs |
61 | SELECT FOUND_ROWS() AS totrow | 133μs |
Totale | 63.58ms |