M.LUNGO INVIDIA

SEAC Invidia, Muta monopezzo in neoprene da 3 mm, Ultrastretch, con cerniera anteriore per subacquea, snorkeling e apnea

 

  • ULTRA ELASTICA DALLA TESTA AI PIEDI - SEAC Invidia è la muta interamente realizzata in neoprene UltraStretch da 3 mm per garantirti sempre il massimo comfort durante le tue attività subacquee. Il neoprene utilizzato rispetta al 100% la normativa europea REACH.
  • MASSIMA ELASTICITA’, ZERO STRESS - L'incredibile morbidezza ed elasticità della muta da subacquea SEAC Invidia, unita alla pratica chiusura verticale anteriore con cerniera YKK, rendono più agevole la vestizione e la svestizione anche nelle giornate più calde. Inoltre, il neoprene UltraStretch non impedisce né frena alcun movimento, per una maggiore libertà.
  • SUPER VERSATILE - SEAC Invidia può essere utilizzata come muta da sub per uomo e donna, da freediving in acque libere temperate (+20°) e da snorkeling e nuoto, anche nelle stagioni più fresche.
  • COMFORT FIT PER DONNA E UOMO - La muta da sub SEAC Invidia è disponibile sia per uomo sia per donna, con 2 tagli differenti che seguono naturalmente le forme del corpo.
  • 6 TAGLIE - SEAC Invidia è disponibile in 6 taglie per uomo e 6 taglie per donna. L'estrema elasticità della muta offre una vestizione e un comfort ottimale per tutti.

 

 

DESCRIZIONE

 

Sei alla ricerca di una muta ultrastretch e versatile, per avere sempre il massimo comfort durante le tue attività subacquee?

 

SEAC Invidia è la muta in neoprene da 3 mm sottile, di alta qualità e Ultrastretch, per un comfort ottimale in qualunque condizione e in qualsiasi attività sportiva in acqua.

Il neoprene utilizzato rispetta al 100% la normativa europea REACH e dona una piacevole sensazione di libertà su braccia e gambe.

La chiusura anteriore con pratica cerniera YKK, unita all’estrema morbidezza, assicurano una più agevole vestizione, anche nelle giornate più calde.

Il comfort si unisce all’estrema attenzione ai dettagli: le cuciture Flatlock e le ginocchiere rinforzate in Powertek completano il design minimal ed elegante di questa muta, rendendola bella da vedere e comoda da indossare.

 

Disponibile in 6 taglie per uomo e 6 per donna, SEAC Invidia può essere utilizzata come muta da sub, da freediving in acque libere temperate (con temperatura superiore ai 20°), da snorkeling e nuoto, garantendo una perfetta protezione anche nelle stagioni più fresche.

 

Prodotti correlati

MeasuruesSize
Memory Usage19.99 MB
Load Time400ms
Server Variables
Array
(
    [USER] => u.webdevarea
    [HOME] => /var/www/vhosts/devb2b.seacsub.com
    [SCRIPT_NAME] => /index.php
    [REQUEST_URI] => /seacsub/15/snorkeling/0010460l/m-lungo-invidia.html
    [QUERY_STRING] => filename=single-product&pc=0010460l&p=m-lungo-invidia&cctc=15&cct=snorkeling&shop=seacsub
    [REQUEST_METHOD] => GET
    [SERVER_PROTOCOL] => HTTP/1.0
    [GATEWAY_INTERFACE] => CGI/1.1
    [REDIRECT_QUERY_STRING] => filename=single-product&pc=0010460l&p=m-lungo-invidia&cctc=15&cct=snorkeling&shop=seacsub
    [REDIRECT_URL] => /single-product.php
    [REMOTE_PORT] => 54954
    [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.218.63.176
    [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] => fikker-Wlyt-7hIO=GKK8gDy2WBm0a8UOyhgfMhkXQZUr9Vif [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.218.63.176 [HTTP_HOST] => devb2b.seacsub.com [proxy-nokeepalive] => 1 [HTTPS] => on [SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/15/snorkeling/0010460l/m-lungo-invidia.html [SCRIPT_URL] => /seacsub/15/snorkeling/0010460l/m-lungo-invidia.html [UNIQUE_ID] => Z2kEbpflCWrzzJeDedUWXQAAAAA [REDIRECT_STATUS] => 200 [REDIRECT_HTTPS] => on [REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/15/snorkeling/0010460l/m-lungo-invidia.html [REDIRECT_SCRIPT_URL] => /seacsub/15/snorkeling/0010460l/m-lungo-invidia.html [REDIRECT_UNIQUE_ID] => Z2kEbpflCWrzzJeDedUWXQAAAAA [REDIRECT_REDIRECT_STATUS] => 200 [REDIRECT_REDIRECT_HTTPS] => on [REDIRECT_REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/15/snorkeling/0010460l/m-lungo-invidia.html [REDIRECT_REDIRECT_SCRIPT_URL] => /seacsub/15/snorkeling/0010460l/m-lungo-invidia.html [REDIRECT_REDIRECT_UNIQUE_ID] => Z2kEbpflCWrzzJeDedUWXQAAAAA [FCGI_ROLE] => RESPONDER [PHP_SELF] => /index.php [REQUEST_TIME_FLOAT] => 1734935662.1069 [REQUEST_TIME] => 1734935662 )
#QueryTime (sec)
0
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.* FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
1.06ms
1
SELECT FOUND_ROWS() AS totrow
341μ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
190μs
4
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-23 07:34:22' AND to_date > '2024-12-23 07:34:22' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
1.4ms
5
SELECT FOUND_ROWS() AS totrow
257μ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"%')
302μs
7
SELECT FOUND_ROWS() AS totrow
165μ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 
250μs
9
SELECT FOUND_ROWS() AS totrow
139μ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 = "single-product.php" AND enabled = 1 AND
company_code in(0,1)
LIMIT 0, 1 
266μs
11
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-23 07:34:22' AND to_date > '2024-12-23 07:34:22' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
214μs
12
SELECT FOUND_ROWS() AS totrow
168μs
13
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 <= 76 and tcctp.nleft >= 33 AND tp.code_master = "0010460l"
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc
LIMIT 0, 1 
3.32ms
14
SELECT FOUND_ROWS() AS totrow
198μs
15
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 ('0010460370025A')
ORDER BY
tbl_products_images.sorting ASC
346μs
16
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 ("0010460L")
GROUP BY
tp.code_master,tqfp.id
ORDER BY
tqfp.sorting asc,tqfp.id asc 
1.2ms
17
SELECT FOUND_ROWS() AS totrow
195μs
18
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 ("0010460L")
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 
242μs
19
SELECT FOUND_ROWS() AS totrow
162μs
20
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 ("0010460L") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc 
869μs
21
SELECT FOUND_ROWS() AS totrow
261μs
22
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-23 07:34:22' AND to_date > '2024-12-23 07:34:22' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
171μs
23
SELECT FOUND_ROWS() AS totrow
135μs
24
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 ("0010460L") AND tcctp.nright <= 76 and tcctp.nleft >= 33
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc 
4.39ms
25
SELECT FOUND_ROWS() AS totrow
237μs
26
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 ('0010460370025A','0010460370040A','0010460370055A','0010460370080A','0010460370105A','0010460370125A')
ORDER BY
tbl_products_images.sorting ASC
293μs
27
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-23 07:34:22' AND to_date > '2024-12-23 07:34:22' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
523μs
28
SELECT FOUND_ROWS() AS totrow
305μs
29
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_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 = '0010460L'
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc 
2.07ms
30
SELECT FOUND_ROWS() AS totrow
229μs
31
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-23 07:34:22' AND to_date > '2024-12-23 07:34:22' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
195μs
32
SELECT FOUND_ROWS() AS totrow
166μs
33
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 ("") AND tcctp.nright <= 76 and tcctp.nleft >= 33
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc 
3.15ms
34
SELECT FOUND_ROWS() AS totrow
194μs
35
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-23 07:34:22' AND to_date > '2024-12-23 07:34:22' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
162μs
36
SELECT FOUND_ROWS() AS totrow
148μs
37
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 <= 76 and tcctp.nleft >= 33 AND tp.code_master != '0010460L'
GROUP BY
tp.code_master
ORDER BY
RAND() asc
LIMIT 0, 4 
172ms
38
SELECT FOUND_ROWS() AS totrow
300μs
39
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 ('0890083520000A','1500014120436A','1500015160450A','1550016008025A')
ORDER BY
tbl_products_images.sorting ASC
1.91ms
40
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 ("0890083","1500014","1500015","1550016L") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc 
2.12ms
41
SELECT FOUND_ROWS() AS totrow
211μs
42
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-23 07:34:22' AND to_date > '2024-12-23 07:34:22' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
181μs
43
SELECT FOUND_ROWS() AS totrow
126μs
44
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 ("0890083","1500014","1500015","1550016L") AND tcctp.nright <= 76 and tcctp.nleft >= 33
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc 
61.95ms
45
SELECT FOUND_ROWS() AS totrow
284μ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 ('0890083520000A','1500014120436A','1500014120446A','1500014120456A','1500014120466A','1500014120476A','1500014120486A','1500014120496A','1500014120506A','1500014125436A','1500014125446A','1500014125456A','1500014125466A','1500014125476A','1500014125486A','1500014125496A','1500014125506A','1500014160436A','1500014160446A','1500015160450A','1500015160455A','1500014160456A','1500015160460A','1500015160465A','1500014160466A','1500015160470A','1500015160475A','1500014160476A','1500015160480A','1500015160485A','1500014160486A','1500015160490A','1500015160495A','1500014160496A','1500015160500A','1500014160506A','1500014166436A','1500014166446A','1500014166456A','1500014166466A','1500014166476A','1500014166486A','1500014166496A','1500014166506A','1500014520436A','1500014520446A','1500014520456A','1500014520466A','1500014520476A','1500014520486A','1500014520496A','1500014520506A','1500014530436A','1500014530446A','1500014530456A','1500014530466A','1500014530476A','1500014530486A','1500014530496A','1500014530506A','1500015882450A','1500015882455A','1500015882460A','1500015882465A','1500015882470A','1500015882475A','1500015882480A','1500015882485A','1500015882490A','1500015882495A','1500015882500A','1550016008025A','1550016008040A','1550016008055A','1550016008080A','1550016008105A','1550016012025A','1550016012040A','1550016012055A','1550016012080A','1550016012105A','1550016015025A','1550016015040A','1550016015055A','1550016015080A','1550016015105A','1550016018025A','1550016018040A','1550016018055A','1550016018080A','1550016018105A','1550016023025A','1550016023040A','1550016023055A','1550016023080A','1550016023105A')
ORDER BY
tbl_products_images.sorting ASC
4.65ms
47
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.string,
tbl_dictionary.translate_it AS translate FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
516μs
48
SELECT FOUND_ROWS() AS totrow
219μs
Totale270ms