PINNE BM30

Varianti

SEAC BM-30 - IL LANCIO DELLA TECNOLOGIA FRC™ SULL’ULTIMA PINNA MADE IN ITALY DI SEACSUB

Con le nuove pinne SEAC BM-30 Seacusb lancia la nuova tecnologia FRC™ – Fully Responsive Compound.

Tutto è iniziato dalla ricerca di un blend di polimeri che permettesse all’azienda di San Colombano Certenoli di produrre pinne con prestazioni simili a quelle in fibra di carbonio e vetro, eliminando però i ben noti problemi di fragilità di questi compositi.

Sono quindi arrivati a un compound dalle inedite caratteristiche meccaniche che l’esperienza progettuale e produttiva di Seacsub ha trasformato in una nuova tecnologia dedicata alla realizzazione di pale per pinne ancor più performanti.

La tecnologia FRC™ – Fully Responsive Compound ha risposto quindi a tutte le esigenze produttive di Seacsub:

  • Pinne negative e pale più sottili delle precedenti in tecnopolimero grazie alla fluidità e al peso specifico del materiale.
  • Il design di prodotto sfrutta le proprietà meccaniche del compound per una risposta elastica simile a quella della fibra di carbonio e vetro.
  • Nessun rischio di rottura o deformazione permanente grazie all’elevata resilienza e all’alta resistenza a snervamento e rottura del compound, anche a basse temperature.
  • Resistenza e alto modulo elastico permettono di sfruttare a pieno la geometria tipica delle pale in fibra di carbonio e vetro senza dover utilizzare nessuna nervatura di rinforzo o protezione.
  • Impronta carbonica ridotta rispetto ai comuni tecnopolimeri utilizzati nel settore e totale assenza di elementi tossici.

La peculiarità delle pinne SEAC BM-30 risiede quindi proprio in questa tecnologia che combina materiali innovativi e geometrie idrodinamiche ed ergonomiche.

Il compound utilizzato è così elastico e ha una memoria di forma così elevata che – in una dimostrazione per assurdo – se osservassimo la pala dopo averla arrotolata su sé stessa, una volta rilasciata questa avrebbe ancora la sua geometria iniziale, senza alcuna deformazione strutturale permanente che ne possa compromettere le performance.

Come la fortunata serie Motus anche la scarpetta a longheroni corti della BM-30 è composta da due differenti materiali, uno più rigido sulla suola per dare stabilità e uno più morbido sulla tomaia per il massimo del comfort durante l’uso prolungato.

La pala delle pinne SEAC BM-30 è inclinata di 30° per agevolare sia la pinneggiata in superficie, sia per assecondare la naturale inclinazione delle caviglie in immersione. Le piccole pinnette stabilizzatrici poste all’estremità della pala nel punto di maggior flusso dell’acqua evitano che la pinna derapi lateralmente senza comprometterne la corretta flessione.

Le pinne SEAC BM-30 sono 100% Made in Italy, prodotte nello stabilimento di Seacsub alimentato da energia solare.

 

Il materiale della pala BM30
Tecnopolimero leggero e reattivo, ad oggi unico nel suo genere, che offre prestazioni simili al composito a base di fibra di carbonio, eliminando però il noto problema della fragilità del materiale. Il tecnopolimero utilizzato è così elastico e ha una memoria di forma così elevata che – in una dimostrazione per assurdo – se osservassimo la pala dopo averla arrotolata su sé stessa, una volta rilasciata questa avrebbe ancora la sua geometria iniziale, senza alcuna deformazione strutturale permanente che ne possa compromettere le performance.
La geometria della pala BM30 
La pala delle pinne SEAC BM30 è inclinata di 30°. Questa angolazione più accentuata è ideale sia per agevolare la pinneggiata in superficie, sia per assecondare la naturale inclinazione delle caviglie in immersione. Inoltre, il profilo ultrasottile e differenziato crea una flessione ottimale e ne riducono il peso. Le piccole pinnette stabilizzatrici poste all’estremità della pala nel punto di maggior flusso dell’acqua evitano che la pinna derapi lateralmente senza compromettere la corretta flessione del tecnopolimero della pala.
Il materiale della scarpetta BM30 
Come la fortunata serie Motus anche la scarpetta della BM30 è composta da due differenti materiali, uno più rigido sulla suola per dare stabilità ne uno più morbido sulla tomaia per il massimo del comfort durante l’uso prolungato.
La geometria della scarpetta BM30 
La scarpetta BM30 è ottimizzata per ospitare pale angolate a 30°. I longheroni corti aiutano il tecnopolimero della pala a esprimere tutta la sua reattività e flessibilità.

Prodotti correlati

SET TRIS MOTUS S/GR
OGIVA ARTICOLATA UNIVERSALE
COPPIA ELASTICI TRIPOWER
INOX
Contatti
Privacy policy
Cookie policy
Progetto ARCHE
Modello 231
Codice etico
MeasuruesSize
Memory Usage18.49 MB
Load Time343ms
Server Variables
Array
(
    [USER] => u.webdevarea
    [HOME] => /var/www/vhosts/devb2b.seacsub.com
    [SCRIPT_NAME] => /index.php
    [REQUEST_URI] => /seacsub/152/pesca-subacquea/0710056/pinne-bm30.html
    [QUERY_STRING] => filename=single-product&pc=0710056&p=pinne-bm30&cctc=152&cct=pesca-subacquea&shop=seacsub
    [REQUEST_METHOD] => GET
    [SERVER_PROTOCOL] => HTTP/1.0
    [GATEWAY_INTERFACE] => CGI/1.1
    [REDIRECT_QUERY_STRING] => filename=single-product&pc=0710056&p=pinne-bm30&cctc=152&cct=pesca-subacquea&shop=seacsub
    [REDIRECT_URL] => /single-product.php
    [REMOTE_PORT] => 34768
    [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.191.202.48
    [SERVER_PORT] => 443
    [SERVER_ADDR] => 85.235.148.161
    [SERVER_NAME] => devb2b.seacsub.com
    [SERVER_SOFTWARE] => Apache
    [SERVER_SIGNATURE] => 
Apache Server at devb2b.seacsub.com Port 443


    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
    [HTTP_COOKIE] => handl_url=https%3A%2F%2Frpssolarpumps.com%2Flearn%2Fhow-does-solar-for-water-pumping-work%2F; HandLtestDomainNameServer=HandLtestDomainValueServer; handl_ref=https%3A%2F%2Frpssolarpumps.com%2F%3Fp%3D3186; login=username=&uyeid=0; user_agent=Mozilla%2F5.0%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%3B%20compatible%3B%20ClaudeBot%2F1.0%3B%20%2Bclaudebot%40anthropic.com%29; organic_source=https%3A%2F%2Fmicrochipusa.com%2Fdiscrete-semiconductor-products%2FFS150R12N3T7BPSA1; organic_source_str=Internal; handl_landing_page=https%3A%2F%2Fmicrochipusa.com%2Fdiscrete-semiconductor-products%2FFS150R12N3T7BPSA1; handl_ip=18.191.202.48; handl_url_base=https%3A%2F%2Frpssolarpumps.com%2Flearn%2Fhow-does-solar-for-water-pumping-work%2F; handl_original_ref=https%3A%2F%2Fmicrochipusa.com%2Fdiscrete-semiconductor-products%2FFS150R12N3T7BPSA1
    [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.191.202.48
    [HTTP_HOST] => devb2b.seacsub.com
    [proxy-nokeepalive] => 1
    [HTTPS] => on
    [SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/152/pesca-subacquea/0710056/pinne-bm30.html
    [SCRIPT_URL] => /seacsub/152/pesca-subacquea/0710056/pinne-bm30.html
    [UNIQUE_ID] => Z0Gggnl4WzbOlE0_6ydg8gAAAAE
    [REDIRECT_STATUS] => 200
    [REDIRECT_HTTPS] => on
    [REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/152/pesca-subacquea/0710056/pinne-bm30.html
    [REDIRECT_SCRIPT_URL] => /seacsub/152/pesca-subacquea/0710056/pinne-bm30.html
    [REDIRECT_UNIQUE_ID] => Z0Gggnl4WzbOlE0_6ydg8gAAAAE
    [REDIRECT_REDIRECT_STATUS] => 200
    [REDIRECT_REDIRECT_HTTPS] => on
    [REDIRECT_REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/152/pesca-subacquea/0710056/pinne-bm30.html
    [REDIRECT_REDIRECT_SCRIPT_URL] => /seacsub/152/pesca-subacquea/0710056/pinne-bm30.html
    [REDIRECT_REDIRECT_UNIQUE_ID] => Z0Gggnl4WzbOlE0_6ydg8gAAAAE
    [FCGI_ROLE] => RESPONDER
    [PHP_SELF] => /index.php
    [REQUEST_TIME_FLOAT] => 1732354178.2262
    [REQUEST_TIME] => 1732354178
)
#QueryTime (sec)
0
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.* FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
1.01ms
1
SELECT FOUND_ROWS() AS totrow
210μ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 = '')
964μs
3
SELECT FOUND_ROWS() AS totrow
143μs
4
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 10:29:38' AND to_date > '2024-11-23 10:29:38' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
896μs
5
SELECT FOUND_ROWS() AS totrow
157μ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"%')
279μs
7
SELECT FOUND_ROWS() AS totrow
131μ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
161μs
9
SELECT FOUND_ROWS() AS totrow
93μ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
192μs
11
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 10:29:38' AND to_date > '2024-11-23 10:29:38' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
139μs
12
SELECT FOUND_ROWS() AS totrow
105μ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 <= 238 and tcctp.nleft >= 203 AND tp.code_master = "0710056"
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc
LIMIT 0, 1
2.91ms
14
SELECT FOUND_ROWS() AS totrow
140μ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 ('0710056520452A')
ORDER BY
tbl_products_images.sorting ASC
1.09ms
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 ("0710056")
GROUP BY
tp.code_master,tqfp.id
ORDER BY
tqfp.sorting asc,tqfp.id asc
849μs
17
SELECT FOUND_ROWS() AS totrow
147μ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 ("0710056")
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
742μs
19
SELECT FOUND_ROWS() AS totrow
131μ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 ("0710056") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc
815μs
21
SELECT FOUND_ROWS() AS totrow
143μs
22
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 10:29:38' AND to_date > '2024-11-23 10:29:38' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
141μs
23
SELECT FOUND_ROWS() AS totrow
101μ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 ("0710056") AND tcctp.nright <= 238 and tcctp.nleft >= 203
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc
8.14ms
25
SELECT FOUND_ROWS() AS totrow
245μ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 ('0710056520452A','0710056520466A','0710056520476A','0710056520486A','0710056520496A','0710056520506A','0710056542452A','0710056542466A','0710056542476A','0710056542486A','0710056542496A','0710056542506A')
ORDER BY
tbl_products_images.sorting ASC
2.89ms
27
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 10:29:38' AND to_date > '2024-11-23 10:29:38' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
525μs
28
SELECT FOUND_ROWS() AS totrow
280μ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 = '0710056'
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc
2.51ms
30
SELECT FOUND_ROWS() AS totrow
206μs
31
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 10:29:38' AND to_date > '2024-11-23 10:29:38' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
152μs
32
SELECT FOUND_ROWS() AS totrow
109μ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 <= 238 and tcctp.nleft >= 203
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc
3.95ms
34
SELECT FOUND_ROWS() AS totrow
243μs
35
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 10:29:38' AND to_date > '2024-11-23 10:29:38' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
155μs
36
SELECT FOUND_ROWS() AS totrow
107μ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 <= 238 and tcctp.nleft >= 203 AND tp.code_master != '0710056'
GROUP BY
tp.code_master
ORDER BY
RAND() asc
LIMIT 0, 4
173ms
38
SELECT FOUND_ROWS() AS totrow
231μ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 ('0890087216452A','1250076000000A','1270060031012A','1320023070430A')
ORDER BY
tbl_products_images.sorting ASC
1.3ms
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 ("0890087","1250076","1270060","1320023") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc
1.3ms
41
SELECT FOUND_ROWS() AS totrow
133μs
42
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 10:29:38' AND to_date > '2024-11-23 10:29:38' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
111μs
43
SELECT FOUND_ROWS() AS totrow
91μ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 ("0890087","1250076","1270060","1320023") AND tcctp.nright <= 238 and tcctp.nleft >= 203
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc
12.35ms
45
SELECT FOUND_ROWS() AS totrow
193μ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 ('0890087216452A','0890087216466A','0890087216476A','0890087216486A','0890087216496A','0890087216506A','1250076000000A','1270060031012A','1270060031014A','1270060031016A','1270060031018A','1270060031020A','1270060031022A','1270060031024A','1270060031026A','1270060031028A','1270060031030A','1270060034016A','1270060034018A','1270060034019A','1270060034020A','1270060034022A','1270060034024A','1270060034026A','1270060034028A','1270060034030A','1270060034032A','1320023070305A','1320023070355A','1320023070430A','1320023070505A','1320023070555A','1320023070605A')
ORDER BY
tbl_products_images.sorting ASC
2.38ms
47
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.string,
tbl_dictionary.translate_it AS translate FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
436μs
48
SELECT FOUND_ROWS() AS totrow
146μs
Totale223ms