PINNE F1

Variation

  • ULTRA PERFORMANCE | The Seac F1 diving fins offer great performance with minimal weight. At just 730 grams each the F1 Fin produces an unrivalled reactive thrust that is more than equal to the traditional heavier fins, but requires much less effort.
  • ULTRA RESISTANT | The rigid sections of the blade are joined by a special Ultra Flex technopolymer network. This special structure then has a high degree of impact resistance, even at low temperatures, and the protection of the ribs helps avoid abrasion.
  • STABLE FOOT | The rubber of the Seac F1 diving fins and the easily adjustable strap stabilize the fit by ensuring that the fin remains firmly on the foot. The sole is a non-slip material with raised rubber profiles
  • FROM XS TO XL | The Seac F1 fins are available in 3 colors (black, black / red, black / blue, black) and 4 sizes to fit from 34 to 45 (XS / S = 34/36; S / M = 37/39; M / L = 40/42; L / XL = 43/45)
  • HIGH PERFORMANCE | The Seac F1 fins represent the quality and research of underwater performance typical of the Seac brand and, although designed for recreational diving, offer features usually reserved for professional fins

Sturdy shoe, square profile and reinforced edges. All of this will amaze you when it comes to diving fins that are surprisingly light like the Seac F1 which, is just 730 grams. All the quality and research of underwater performance typical of the Seac brand has been incorporated into the Seac F1 Fin. Although designed for recreational use, the Seac F1 fins offer many qualities usually reserved for professional fins. The Seac F1 diving fins have a blade designed to reduce the diver's effort to a minimum and release an unprecedented thrust for such a lightweight fin. The Ultra Flex technopolymers network combines the rigid sections of the blade to guarantee flexibility, ease of return of the fin and therefore less effort. This special structure then has a high degree of impact resistance, even at low temperatures, and the protection from the ribs avoid abrasions. The shoe has been created with a combination of polymers to stabilize the fit and has a practical non-slip sole with raised rubber profiles. Seac F1 fins are available in 4 sizes, to fit from 34 to 45, and in 3 colors: black, red / black and black / blue.
Techno-polymer double material
Techno-polymer dual material with high performance and high impact resistance even at low temperatures.
Material foot pocket
Combination of techno-polymer and thermoplastic elastomer
Light weight
Lightweight fins perfect for travelling

Related products

MeasuruesSize
Memory Usage19.94 MB
Load Time258ms
Server Variables
Array
(
    [USER] => u.webdevarea
    [HOME] => /var/www/vhosts/devb2b.seacsub.com
    [SCRIPT_NAME] => /index.php
    [REQUEST_URI] => /seacsub/10/scuba-fins/0710037/pinne-f1.html
    [QUERY_STRING] => filename=single-product&pc=0710037&p=pinne-f1&cctc=10&cct=scuba-fins&shop=seacsub
    [REQUEST_METHOD] => GET
    [SERVER_PROTOCOL] => HTTP/1.0
    [GATEWAY_INTERFACE] => CGI/1.1
    [REDIRECT_QUERY_STRING] => filename=single-product&pc=0710037&p=pinne-f1&cctc=10&cct=scuba-fins&shop=seacsub
    [REDIRECT_URL] => /single-product.php
    [REMOTE_PORT] => 38378
    [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.97.14.90
    [SERVER_PORT] => 443
    [SERVER_ADDR] => 85.235.148.161
    [SERVER_NAME] => devb2b.seacusa.com
    [SERVER_SOFTWARE] => Apache
    [SERVER_SIGNATURE] => 
Apache Server at devb2b.seacusa.com Port 443
[PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin [HTTP_ACCEPT_ENCODING] => br,gzip [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/) [HTTP_CONNECTION] => close [HTTP_X_ACCEL_INTERNAL] => /internal-nginx-static-location [HTTP_X_REAL_IP] => 18.97.14.90 [HTTP_HOST] => devb2b.seacusa.com [proxy-nokeepalive] => 1 [HTTPS] => on [SCRIPT_URI] => https://devb2b.seacusa.com/seacsub/10/scuba-fins/0710037/pinne-f1.html [SCRIPT_URL] => /seacsub/10/scuba-fins/0710037/pinne-f1.html [UNIQUE_ID] => Z07Kc8I3nTl8qpLgGAks-wAAAAk [REDIRECT_STATUS] => 200 [REDIRECT_HTTPS] => on [REDIRECT_SCRIPT_URI] => https://devb2b.seacusa.com/seacsub/10/scuba-fins/0710037/pinne-f1.html [REDIRECT_SCRIPT_URL] => /seacsub/10/scuba-fins/0710037/pinne-f1.html [REDIRECT_UNIQUE_ID] => Z07Kc8I3nTl8qpLgGAks-wAAAAk [REDIRECT_REDIRECT_STATUS] => 200 [REDIRECT_REDIRECT_HTTPS] => on [REDIRECT_REDIRECT_SCRIPT_URI] => https://devb2b.seacusa.com/seacsub/10/scuba-fins/0710037/pinne-f1.html [REDIRECT_REDIRECT_SCRIPT_URL] => /seacsub/10/scuba-fins/0710037/pinne-f1.html [REDIRECT_REDIRECT_UNIQUE_ID] => Z07Kc8I3nTl8qpLgGAks-wAAAAk [FCGI_ROLE] => RESPONDER [PHP_SELF] => /index.php [REQUEST_TIME_FLOAT] => 1733216883.3795 [REQUEST_TIME] => 1733216883 )
#QueryTime (sec)
0
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.* FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
1.47ms
1
SELECT FOUND_ROWS() AS totrow
328μs
2
SELECT SQL_CALC_FOUND_ROWS
tbl_settings.* FROM tbl_settings
WHERE (company_code = 2 OR company_code = '')
AND (shop_code = "seacsub" OR shop_code = '')
925μs
3
SELECT FOUND_ROWS() AS totrow
194μs
4
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_en AS translate FROM tbl_dictionary
WHERE
slug = "19ec5b589f66eb57230083177d6e5468" and scope is null
LIMIT 0, 1 
263μs
5
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-03 10:08:03' AND to_date > '2024-12-03 10:08:03' AND (order_type = 1 OR order_type = "") AND (company_code = 2) AND
company_code = 2
1.21ms
6
SELECT FOUND_ROWS() AS totrow
202μ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 = 2 AND tppl.currency = "1" 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 = 2 AND tppl_c.currency = '1' 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"%')
240μs
8
SELECT FOUND_ROWS() AS totrow
122μs
9
SELECT SQL_CALC_FOUND_ROWS
tbl_catalog_categories_product.id,
tbl_catalog_categories_product.name_en 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,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,1,15,15,58,15,1,2,4,5,6,7,10,11,13,14,20,25,26,48,49,50,51,52,55,56,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,183,184,186,187,224,251)
ORDER BY
tbl_catalog_categories_product.sorting asc 
175μs
10
SELECT FOUND_ROWS() AS totrow
134μs
11
SELECT SQL_CALC_FOUND_ROWS
tbl_pages.url,
tbl_pages.id,
tbl_pages.title_en AS title,
tbl_pages.excerpt_en AS excerpt,
tbl_pages.content_en AS content,
tbl_pages.meta_title_en AS meta_title,
tbl_pages.meta_keywords_en AS meta_keywords,
tbl_pages.meta_description_en 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,2)
LIMIT 0, 1 
235μs
12
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-03 10:08:03' AND to_date > '2024-12-03 10:08:03' AND (order_type = 1 OR order_type = "") AND (company_code = 2) AND
company_code = 2
101μs
13
SELECT FOUND_ROWS() AS totrow
96μs
14
SELECT SQL_CALC_FOUND_ROWS
tp.code_master AS code,
tpd.name_en AS name,
tpd.title_en AS title,
tpd.excerpt_en AS excerpt,
tpd.description_en 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_en AS family_name,
tfp.name_it AS family_name_default,
tp.season_code,
tp.gender_code,
tpd.meta_title_en AS meta_title,
tpd.meta_keywords_en AS meta_keywords,
tpd.meta_description_en 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_en AS label_variant1,
tctp.label_variant2_en 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 = 2 AND tppl.currency = "1" 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 = 2 AND tppl_c.currency = '1' AND tppl_c.code = '01')
LEFT OUTER JOIN tbl_products_catalog_categories tpcct ON (tp.code = tpcct.product_code) LEFT OUTER JOIN tbl_catalog_categories_product tcctp ON (tcctp.id = tpcct.category_id)
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND tcctp.nright <= 13 and tcctp.nleft >= 12 AND tp.code_master = "0710037"
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc
LIMIT 0, 1 
3.39ms
15
SELECT FOUND_ROWS() AS totrow
117μ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 ('0710037160050A')
ORDER BY
tbl_products_images.sorting ASC
419μs
17
SELECT SQL_CALC_FOUND_ROWS
tp.code_master,
tqfp.id,
tqfp.image,
tqfp.color,
tqfp.name_en 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 ("0710037")
GROUP BY
tp.code_master,tqfp.id
ORDER BY
tqfp.sorting asc,tqfp.id asc 
164μs
18
SELECT FOUND_ROWS() AS totrow
101μ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_en AS title,
tbl_products_descriptions_highlights.title_it AS title_default,
tbl_products_descriptions_highlights.excerpt_en 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 ("0710037")
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 
161μs
20
SELECT FOUND_ROWS() AS totrow
141μs
21
SELECT SQL_CALC_FOUND_ROWS
tp.code_master,
tp.color_code,
tszp.code,
tszp.name_en 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 ("0710037") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc 
111μs
22
SELECT FOUND_ROWS() AS totrow
79μs
23
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-03 10:08:03' AND to_date > '2024-12-03 10:08:03' AND (order_type = 1 OR order_type = "") AND (company_code = 2) AND
company_code = 2
134μs
24
SELECT FOUND_ROWS() AS totrow
104μs
25
SELECT SQL_CALC_FOUND_ROWS
tp.id,
tp.code,
tp.code_master,
tp.color_code,
tcp.name_en AS color_name,
tcp.name_it AS color_name_default,
tpd.name_en,
tpd.name_it AS name_default,
tp.size,
tszp.name_en 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 = 2 AND tppl.currency = "1" 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 = 2 AND tppl_c.currency = '1' AND tppl_c.code = '01') LEFT OUTER JOIN tbl_products_stocks tpst ON (tpst.product_code = tp.code AND tpst.company_code = "2") 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 = "2" 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 ("0710037") AND tcctp.nright <= 13 and tcctp.nleft >= 12
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc 
9.28ms
26
SELECT FOUND_ROWS() AS totrow
146μ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 ('0710037160030A','0710037160050A','0710037160070A','0710037160095A','0710037520030A','0710037520050A','0710037520070A','0710037520095A','0710037680030A','0710037680050A','0710037680070A')
ORDER BY
tbl_products_images.sorting ASC
188μs
28
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-03 10:08:03' AND to_date > '2024-12-03 10:08:03' AND (order_type = 1 OR order_type = "") AND (company_code = 2) AND
company_code = 2
423μs
29
SELECT FOUND_ROWS() AS totrow
316μs
30
SELECT SQL_CALC_FOUND_ROWS
tp.code_master AS code,
tpd.name_en AS name,
tpd.title_en AS title,
tpd.excerpt_en AS excerpt,
tpd.description_en 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_en AS family_name,
tfp.name_it AS family_name_default,
tp.season_code,
tp.gender_code,
tpd.meta_title_en AS meta_title,
tpd.meta_keywords_en AS meta_keywords,
tpd.meta_description_en 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_en AS label_variant1,
tctp.label_variant2_en 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 = 2 AND tppl.currency = "1" 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 = 2 AND tppl_c.currency = '1' 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 = '0710037'
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc 
1.87ms
31
SELECT FOUND_ROWS() AS totrow
151μs
32
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-03 10:08:03' AND to_date > '2024-12-03 10:08:03' AND (order_type = 1 OR order_type = "") AND (company_code = 2) AND
company_code = 2
128μs
33
SELECT FOUND_ROWS() AS totrow
91μs
34
SELECT SQL_CALC_FOUND_ROWS
tp.id,
tp.code,
tp.code_master,
tp.color_code,
tcp.name_en AS color_name,
tcp.name_it AS color_name_default,
tpd.name_en,
tpd.name_it AS name_default,
tp.size,
tszp.name_en 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 = 2 AND tppl.currency = "1" 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 = 2 AND tppl_c.currency = '1' AND tppl_c.code = '01') LEFT OUTER JOIN tbl_products_stocks tpst ON (tpst.product_code = tp.code AND tpst.company_code = "2") 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 = "2" 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 <= 13 and tcctp.nleft >= 12
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc 
2.5ms
35
SELECT FOUND_ROWS() AS totrow
163μs
36
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-03 10:08:03' AND to_date > '2024-12-03 10:08:03' AND (order_type = 1 OR order_type = "") AND (company_code = 2) AND
company_code = 2
159μs
37
SELECT FOUND_ROWS() AS totrow
123μs
38
SELECT SQL_CALC_FOUND_ROWS
tp.code_master AS code,
tpd.name_en AS name,
tpd.title_en AS title,
tpd.excerpt_en AS excerpt,
tpd.description_en 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_en AS family_name,
tfp.name_it AS family_name_default,
tp.season_code,
tp.gender_code,
tpd.meta_title_en AS meta_title,
tpd.meta_keywords_en AS meta_keywords,
tpd.meta_description_en 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_en AS label_variant1,
tctp.label_variant2_en 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 = 2 AND tppl.currency = "1" 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 = 2 AND tppl_c.currency = '1' AND tppl_c.code = '01')
LEFT OUTER JOIN tbl_products_catalog_categories tpcct ON (tp.code = tpcct.product_code) LEFT OUTER JOIN tbl_catalog_categories_product tcctp ON (tcctp.id = tpcct.category_id)
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND tcctp.nright <= 13 and tcctp.nleft >= 12 AND tp.code_master != '0710037'
GROUP BY
tp.code_master
ORDER BY
RAND() asc
LIMIT 0, 4 
18.99ms
39
SELECT FOUND_ROWS() AS totrow
235μs
40
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 ('0710036520030A','0710001120461A','0710043160070A','0710004120461A')
ORDER BY
tbl_products_images.sorting ASC
1.58ms
41
SELECT SQL_CALC_FOUND_ROWS
tp.code_master,
tp.color_code,
tszp.code,
tszp.name_en 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 ("0710036","0710001","0710043","0710004") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc 
1.86ms
42
SELECT FOUND_ROWS() AS totrow
136μs
43
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-03 10:08:03' AND to_date > '2024-12-03 10:08:03' AND (order_type = 1 OR order_type = "") AND (company_code = 2) AND
company_code = 2
126μs
44
SELECT FOUND_ROWS() AS totrow
168μs
45
SELECT SQL_CALC_FOUND_ROWS
tp.id,
tp.code,
tp.code_master,
tp.color_code,
tcp.name_en AS color_name,
tcp.name_it AS color_name_default,
tpd.name_en,
tpd.name_it AS name_default,
tp.size,
tszp.name_en 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 = 2 AND tppl.currency = "1" 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 = 2 AND tppl_c.currency = '1' AND tppl_c.code = '01') LEFT OUTER JOIN tbl_products_stocks tpst ON (tpst.product_code = tp.code AND tpst.company_code = "2") 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 = "2" 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 ("0710036","0710001","0710043","0710004") AND tcctp.nright <= 13 and tcctp.nleft >= 12
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc 
69.18ms
46
SELECT FOUND_ROWS() AS totrow
254μs
47
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 ('0710043120050A','0710043120070A','0710043120095A','0710001120451A','0710004120451A','0710004120461A','0710001120461A','0710004120471A','0710001120471A','0710001120481A','0710004120481A','0710001120491A','0710004120491A','0710004120501A','0710001120501A','0710036160030A','0710043160050A','0710036160050A','0710036160070A','0710043160070A','0710036160095A','0710043160095A','0710004160451A','0710001160451A','0710001160461A','0710004160461A','0710001160471A','0710004160471A','0710001160481A','0710004160481A','0710004160491A','0710001160491A','0710001160501A','0710004160501A','0710036360030A','0710043360050A','0710036360050A','0710036360070A','0710043360070A','0710036360095A','0710043360095A','0710004360451A','0710001360451A','0710004360461A','0710001360461A','0710004360471A','0710001360471A','0710004360481A','0710001360481A','0710004360491A','0710001360491A','0710004360501A','0710001360501A','0710036520030A','0710036520050A','0710043520050A','0710043520070A','0710036520070A','0710036520095A','0710043520095A','0710004520451A','0710001520451A','0710001520461A','0710004520461A','0710004520471A','0710001520471A','0710001520481A','0710004520481A','0710004520491A','0710001520491A','0710001520501A','0710004520501A','0710001720451A','0710001720461A','0710001720471A','0710001720481A','0710001720491A','0710001720501A','0710004799451A','0710001799451A','0710001799461A','0710004799461A','0710001799471A','0710004799471A','0710004799481A','0710001799481A','0710004799491A','0710001799491A','0710001799501A','0710004799501A')
ORDER BY
tbl_products_images.sorting ASC
8.69ms
48
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_en AS translate FROM tbl_dictionary
WHERE
slug = "68cb97e86fabb3cc85d81e5d09089d31" and scope is null
LIMIT 0, 1 
233μs
49
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_en AS translate FROM tbl_dictionary
WHERE
slug = "c44a1a3420df56fe335fab4668d57c90" and scope is null
LIMIT 0, 1 
93μs
50
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_en AS translate FROM tbl_dictionary
WHERE
slug = "9ce416335987b4dfdc083db1fde250e2" and scope is null
LIMIT 0, 1 
111μs
51
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_en AS translate FROM tbl_dictionary
WHERE
slug = "ff6fbc0f84e2abc908206014316f0b99" and scope is null
LIMIT 0, 1 
118μs
52
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_en AS translate FROM tbl_dictionary
WHERE
slug = "1113fca866539d319db4413175dc1bd1" and scope is null
LIMIT 0, 1 
87μs
53
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_en AS translate FROM tbl_dictionary
WHERE
slug = "0a0b6f3f2fb36e77b9788457562b95e0" and scope is null
LIMIT 0, 1 
82μs
54
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.string,
tbl_dictionary.translate_en AS translate FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
343μs
55
SELECT FOUND_ROWS() AS totrow
186μs
Totale129ms