PINNE BM30

Variación

SEAC BM-30 - EL LANZAMIENTO DE LA TECNOLOGÍA FRC™ EN LA ÚLTIMA ALETA DE SEACSUB FABRICADA EN ITALIA

Con las nuevas aletas SEAC BM-30, Seacusb lanza la nueva tecnología FRC™ - Fully Responsive Compound.

Todo empezó con la búsqueda de una mezcla de polímeros que permitiera a la empresa de San Colombano Certenoli producir aletas con prestaciones similares a las de fibra de carbono y vidrio, eliminando al mismo tiempo los conocidos problemas de fragilidad de estos compuestos.

Así pues, han llegado a un compuesto con unas características mecánicas sin precedentes que la experiencia en diseño y producción de Seacsub ha transformado en una nueva tecnología dedicada a la producción de aletas de prestaciones aún más elevadas.

La tecnología FRC™ - Fully Responsive Compound ha satisfecho, por tanto, todos los requisitos de producción de Seacsub:

- Aletas negativas y palas de aleta más delgadas que sus predecesoras de tecnopolímero gracias a la fluidez y el peso específico del material.

- El diseño del producto aprovecha las propiedades mecánicas del compuesto para una respuesta elástica similar a la del carbono y la fibra de vidrio.

- No hay riesgo de rotura o deformación permanente gracias a la alta resiliencia del compuesto y a su elevado límite elástico y resistencia al desgarro, incluso a bajas temperaturas.

- La resistencia y el elevado módulo de elasticidad permiten aprovechar al máximo la geometría típica de las palas de carbono y fibra de vidrio sin tener que utilizar nervios de refuerzo ni protecciones.

- Huella de carbono reducida en comparación con los tecnopolímeros habituales utilizados en la industria y ausencia total de elementos tóxicos.

La particularidad de las aletas SEAC BM-30 reside, pues, en esta tecnología que combina materiales innovadores con geometrías hidrodinámicas y ergonómicas.

El compuesto utilizado es tan elástico y tiene una memoria de forma tan elevada que -en una demostración absurda- si miráramos la pala después de enrollarla sobre sí misma, una vez liberada seguiría teniendo su geometría inicial, sin ninguna deformación estructural permanente que pudiera comprometer su rendimiento.

Al igual que la exitosa serie Motus, la pala de aleta corta de la BM-30 está fabricada con dos materiales diferentes, uno más rígido en la suela para dar estabilidad y otro más blando en la parte superior para ofrecer el máximo confort durante un uso prolongado.

La pala de las aletas SEAC BM-30 tiene un ángulo de 30° para facilitar tanto el aleteo en superficie como para adaptarse a la inclinación natural de los tobillos durante la inmersión. Las pequeñas aletas estabilizadoras situadas en el extremo de la pala, en el punto de mayor flujo de agua, evitan que la aleta se desplace lateralmente sin comprometer su correcta flexión.

Las aletas SEAC BM-30 son 100% Made in Italy, producidas en la fábrica alimentada con energía solar de Seacsub.

El material de la pala BM30
Un tecnopolímero ligero y reactivo, único en su género hasta la fecha, que ofrece prestaciones similares a las del composite a base de fibra de carbono, pero eliminando el conocido problema de la fragilidad del material. El tecnopolímero utilizado es tan elástico y tiene una memoria de forma tan elevada que, en una demostración absurda, si miráramos la pala después de enrollarla sobre sí misma, una vez liberada seguiría teniendo su geometría inicial, sin ninguna deformación estructural permanente que pudiera comprometer sus prestaciones.
La geometría de la pala BM30
La pala de las aletas SEAC BM30 tiene un ángulo de 30°. Este ángulo más acentuado es ideal tanto para facilitar el aleteo en superficie como para adaptarse a la inclinación natural de los tobillos durante la inmersión. Además, el perfil ultrafino y diferenciado crea una flexión óptima y reduce el peso. Unas pequeñas aletas estabilizadoras situadas en el extremo de la pala, en el punto de mayor flujo de agua, evitan que la aleta se desplace lateralmente sin comprometer la correcta flexión del tecnopolímero de la 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 geometría del calzante BM30
El calzante BM30 está optimizado para adaptarse a las palas con un ángulo de 30°. Los nervios cortos del calzante ayudan al tecnopolímero de la pala a expresar toda su reactividad y flexibilidad.

Productos relacionados

MOTUS CAMO MARRONE
SHOUT CAMO VERDE
KIT VITI X PINNE BM307BM30 CARBON BLU SF
MOTUS CAMO BLU
Contacto
Privacy policy
Cookie policy
Progetto ARCHE
Modello 231
Codice etico
MeasuruesSize
Memory Usage19.64 MB
Load Time260ms
Server Variables
Array
(
    [USER] => u.webdevarea
    [HOME] => /var/www/vhosts/devb2b.seacsub.com
    [SCRIPT_NAME] => /index.php
    [REQUEST_URI] => /seacsub/159/includes-icon-favicon-ico/0710056/pinne-bm30.html
    [QUERY_STRING] => filename=single-product&pc=0710056&p=pinne-bm30&cctc=159&cct=includes-icon-favicon-ico&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=159&cct=includes-icon-favicon-ico&shop=seacsub
    [REDIRECT_URL] => /single-product.php
    [REMOTE_PORT] => 43106
    [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.224.70.238
    [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] => PHPSESSID=v512dksll0tunnuk68qn1pu5v2
    [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.224.70.238
    [HTTP_HOST] => devb2b.seacsub.com
    [proxy-nokeepalive] => 1
    [HTTPS] => on
    [SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/159/includes-icon-favicon-ico/0710056/pinne-bm30.html
    [SCRIPT_URL] => /seacsub/159/includes-icon-favicon-ico/0710056/pinne-bm30.html
    [UNIQUE_ID] => Zkcn2MHnBGKAm_ngZeYVRwAAAAU
    [REDIRECT_STATUS] => 200
    [REDIRECT_HTTPS] => on
    [REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/159/includes-icon-favicon-ico/0710056/pinne-bm30.html
    [REDIRECT_SCRIPT_URL] => /seacsub/159/includes-icon-favicon-ico/0710056/pinne-bm30.html
    [REDIRECT_UNIQUE_ID] => Zkcn2MHnBGKAm_ngZeYVRwAAAAU
    [REDIRECT_REDIRECT_STATUS] => 200
    [REDIRECT_REDIRECT_HTTPS] => on
    [REDIRECT_REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/159/includes-icon-favicon-ico/0710056/pinne-bm30.html
    [REDIRECT_REDIRECT_SCRIPT_URL] => /seacsub/159/includes-icon-favicon-ico/0710056/pinne-bm30.html
    [REDIRECT_REDIRECT_UNIQUE_ID] => Zkcn2MHnBGKAm_ngZeYVRwAAAAU
    [FCGI_ROLE] => RESPONDER
    [PHP_SELF] => /index.php
    [REQUEST_TIME_FLOAT] => 1715939288.9482
    [REQUEST_TIME] => 1715939288
)
#QueryTime (sec)
0
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.* FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
828μs
1
SELECT FOUND_ROWS() AS totrow
333μ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.1ms
3
SELECT FOUND_ROWS() AS totrow
180μs
4
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "19ec5b589f66eb57230083177d6e5468" and scope is null
LIMIT 0, 1
196μs
5
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-05-17 11:48:08' AND to_date > '2024-05-17 11:48:08' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
252μs
6
SELECT FOUND_ROWS() AS totrow
191μs
7
SELECT SQL_CALC_FOUND_ROWS
tbl_catalog_categories_product.id,
tbl_catalog_categories_product.parent_id FROM tbl_catalog_categories_product
where enabled = 1 and tbl_catalog_categories_product.id in(SELECT
tpcct.category_id
FROM tbl_products tp
INNER JOIN tbl_families_product tfp ON (tp.family_code = tfp.code) INNER JOIN tbl_categories_product tctp ON (tp.category_code = tctp.code)
LEFT OUTER JOIN tbl_products_price_lists tppl ON (tppl.product_code = tp.code AND tppl.company_code = 1 AND tppl.currency = "99" AND tppl.code = "-1") LEFT OUTER JOIN tbl_products_price_lists tppl_c ON (tppl_c.product_code = tp.code AND tppl_c.company_code = 1 AND tppl_c.currency = '99' AND tppl_c.code = '01')
INNER JOIN tbl_products_catalog_categories tpcct ON (tp.code = tpcct.product_code)
WHERE tpcct.category_id is not null and tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0
GROUP BY
tpcct.category_id
) and (tbl_catalog_categories_product.view_type LIKE '%"0"%' || tbl_catalog_categories_product.view_type LIKE '%"1"%')
256μs
8
SELECT FOUND_ROWS() AS totrow
141μs
9
SELECT SQL_CALC_FOUND_ROWS
tbl_catalog_categories_product.id,
tbl_catalog_categories_product.name_es AS name,
tbl_catalog_categories_product.name_it AS name_default,
tbl_catalog_categories_product.nright,
tbl_catalog_categories_product.nleft,
tbl_catalog_categories_product.image,
tbl_catalog_categories_product.stages_category,
tbl_catalog_categories_product.parent_id AS parent FROM tbl_catalog_categories_product
WHERE id in(1,1,1,1,1,1,1,1,1,15,15,15,47,47,47,47,47,47,47,1,1,1,15,15,15,15,15,15,152,152,152,152,152,152,152,152,152,152,152,152,152,152,152,152,170,170,170,170,170,170,170,170,47,1,15,15,15,1,2,4,5,6,7,10,11,13,14,20,25,26,48,49,50,51,52,55,56,143,144,145,146,147,148,149,150,151,153,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,171,173,175,176,177,178,180,181,182,183,184,186,224,251)
ORDER BY
tbl_catalog_categories_product.sorting asc
187μs
10
SELECT FOUND_ROWS() AS totrow
118μs
11
SELECT SQL_CALC_FOUND_ROWS
tbl_pages.url,
tbl_pages.id,
tbl_pages.title_es AS title,
tbl_pages.excerpt_es AS excerpt,
tbl_pages.content_es AS content,
tbl_pages.meta_title_es AS meta_title,
tbl_pages.meta_keywords_es AS meta_keywords,
tbl_pages.meta_description_es AS meta_description,
tbl_pages.title_it AS title_default,
tbl_pages.excerpt_it AS excerpt_default,
tbl_pages.content_it AS content_default,
tbl_pages.meta_title_it AS meta_title_default,
tbl_pages.meta_keywords_it AS meta_keywords_default,
tbl_pages.meta_description_it AS meta_description_default FROM tbl_pages
WHERE url = "single-product.php" AND enabled = 1 AND
company_code in(0,1)
LIMIT 0, 1
193μs
12
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-05-17 11:48:09' AND to_date > '2024-05-17 11:48:09' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
838μs
13
SELECT FOUND_ROWS() AS totrow
175μs
14
SELECT SQL_CALC_FOUND_ROWS
tp.code_master AS code,
tpd.name_es AS name,
tpd.title_es AS title,
tpd.excerpt_es AS excerpt,
tpd.description_es AS description,
tpd.name_it AS name_default,
tpd.title_it AS title_default,
tpd.excerpt_it AS excerpt_default,
tpd.description_it AS description_default,
tp.family_code,
tfp.name_es AS family_name,
tfp.name_it AS family_name_default,
tp.season_code,
tp.gender_code,
tpd.meta_title_es AS meta_title,
tpd.meta_keywords_es AS meta_keywords,
tpd.meta_description_es AS meta_description,
tpd.meta_title_it AS meta_title_default,
tpd.meta_keywords_it AS meta_keywords_default,
tpd.meta_description_it AS meta_description_default,
tctp.label_variant1_es AS label_variant1,
tctp.label_variant2_es AS label_variant2,
tctp.label_variant1_it AS label_variant1_default,
tctp.label_variant2_it AS label_variant2_default,
tctp.variant_image,
tp.own_production,
tp.pack,
tpd.default_variant1,
tp.featured,
tp.featured2,
MAX(tppl.discount1) AS discount1,
MAX(tppl.discount2) AS discount2,
MIN(tppl.price) AS original_price,
tppl.currency,
MIN(productPrice(tppl.price,tppl.discount1,tppl.discount2)) 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 <= 215 and tcctp.nleft >= 214 AND tp.code_master = "0710056"
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc
LIMIT 0, 1
2.25ms
15
SELECT FOUND_ROWS() AS totrow
164μ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 ('0710056520452A')
ORDER BY
tbl_products_images.sorting ASC
230μs
17
SELECT SQL_CALC_FOUND_ROWS
tp.code_master,
tqfp.id,
tqfp.image,
tqfp.color,
tqfp.name_es AS name,
tqfp.name_it AS name_default
FROM tbl_products tp
LEFT OUTER JOIN tbl_products_descriptions_quick_features tpdqf ON (tp.code_master = tpdqf.product_description_code) LEFT OUTER JOIN tbl_quick_features_product tqfp ON (tqfp.id = tpdqf.quick_feature_id)
WHERE tp.enabled = 1 AND tqfp.id IS NOT NULL AND tqfp.enabled = 1 AND tp.code_master IN ("0710056")
GROUP BY
tp.code_master,tqfp.id
ORDER BY
tqfp.sorting asc,tqfp.id asc
176μs
18
SELECT FOUND_ROWS() AS totrow
161μs
19
SELECT SQL_CALC_FOUND_ROWS
tbl_products_descriptions_highlights.product_description_code,
tbl_products_descriptions_highlights.image_url,
tbl_products_descriptions_highlights.image_it AS image_default,
tbl_products_descriptions_highlights.title_es AS title,
tbl_products_descriptions_highlights.title_it AS title_default,
tbl_products_descriptions_highlights.excerpt_es AS excerpt,
tbl_products_descriptions_highlights.excerpt_it AS excerpt_default,
tbl_products_descriptions_highlights.video_url,
tbl_products_descriptions_highlights.video_url_it AS video_url_default
FROM tbl_products_descriptions_highlights
WHERE enabled = 1 AND product_description_code IN ("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
221μs
20
SELECT FOUND_ROWS() AS totrow
153μs
21
SELECT SQL_CALC_FOUND_ROWS
tp.code_master,
tp.color_code,
tszp.code,
tszp.name_es AS name,
tszp.name_it AS name_default
FROM tbl_products tp
LEFT OUTER JOIN tbl_sizes_product tszp ON (tp.size = tszp.code)
WHERE (tszp.id IS NOT NULL OR tp.size = '000') AND tp.code_master IN ("0710056") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc
179μs
22
SELECT FOUND_ROWS() AS totrow
132μs
23
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-05-17 11:48:09' AND to_date > '2024-05-17 11:48:09' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
130μs
24
SELECT FOUND_ROWS() AS totrow
114μs
25
SELECT SQL_CALC_FOUND_ROWS
tp.id,
tp.code,
tp.code_master,
tp.color_code,
tcp.name_es AS color_name,
tcp.name_it AS color_name_default,
tpd.name_es,
tpd.name_it AS name_default,
tp.size,
tszp.name_es AS size_name,
tszp.name_it AS size_name_default,
tszp.sorting AS size_sorting,
(tpst.quantity - IFNULL(torr_stb.quantity,0)) AS availability,
tpst.availability_date,
(tpst.future_quantity - IFNULL(torr_stb.quantity,0)) AS future_availability,
tpst.coming_arrivals_quantity,
tpst.coming_arrivals_date,
tp.family_code,
tp.category_code,
tpd.line_code,
tp.season_code,
tp.gender_code,
tp.commercial_code,
tp.own_production,
tp.pack,
tppl.discount1 AS discount1,
tppl.discount2 AS discount2,
productPrice(tppl.price,tppl.discount1,tppl.discount2) 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 <= 215 and tcctp.nleft >= 214
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc
7.79ms
26
SELECT FOUND_ROWS() AS totrow
161μ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 ('0710056520452A','0710056520466A','0710056520476A','0710056520486A','0710056520496A','0710056520506A','0710056542452A','0710056542466A','0710056542476A','0710056542486A','0710056542496A','0710056542506A')
ORDER BY
tbl_products_images.sorting ASC
374μs
28
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-05-17 11:48:09' AND to_date > '2024-05-17 11:48:09' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
343μs
29
SELECT FOUND_ROWS() AS totrow
191μs
30
SELECT SQL_CALC_FOUND_ROWS
tp.code_master AS code,
tpd.name_es AS name,
tpd.title_es AS title,
tpd.excerpt_es AS excerpt,
tpd.description_es AS description,
tpd.name_it AS name_default,
tpd.title_it AS title_default,
tpd.excerpt_it AS excerpt_default,
tpd.description_it AS description_default,
tp.family_code,
tfp.name_es AS family_name,
tfp.name_it AS family_name_default,
tp.season_code,
tp.gender_code,
tpd.meta_title_es AS meta_title,
tpd.meta_keywords_es AS meta_keywords,
tpd.meta_description_es AS meta_description,
tpd.meta_title_it AS meta_title_default,
tpd.meta_keywords_it AS meta_keywords_default,
tpd.meta_description_it AS meta_description_default,
tctp.label_variant1_es AS label_variant1,
tctp.label_variant2_es AS label_variant2,
tctp.label_variant1_it AS label_variant1_default,
tctp.label_variant2_it AS label_variant2_default,
tctp.variant_image,
tp.own_production,
tp.pack,
tpd.default_variant1,
tp.featured,
tp.featured2,
MAX(tppl.discount1) AS discount1,
MAX(tppl.discount2) AS discount2,
MIN(tppl.price) AS original_price,
tppl.currency,
MIN(productPrice(tppl.price,tppl.discount1,tppl.discount2)) 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
1.48ms
31
SELECT FOUND_ROWS() AS totrow
152μs
32
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-05-17 11:48:09' AND to_date > '2024-05-17 11:48:09' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
116μs
33
SELECT FOUND_ROWS() AS totrow
107μs
34
SELECT SQL_CALC_FOUND_ROWS
tp.id,
tp.code,
tp.code_master,
tp.color_code,
tcp.name_es AS color_name,
tcp.name_it AS color_name_default,
tpd.name_es,
tpd.name_it AS name_default,
tp.size,
tszp.name_es AS size_name,
tszp.name_it AS size_name_default,
tszp.sorting AS size_sorting,
(tpst.quantity - IFNULL(torr_stb.quantity,0)) AS availability,
tpst.availability_date,
(tpst.future_quantity - IFNULL(torr_stb.quantity,0)) AS future_availability,
tpst.coming_arrivals_quantity,
tpst.coming_arrivals_date,
tp.family_code,
tp.category_code,
tpd.line_code,
tp.season_code,
tp.gender_code,
tp.commercial_code,
tp.own_production,
tp.pack,
tppl.discount1 AS discount1,
tppl.discount2 AS discount2,
productPrice(tppl.price,tppl.discount1,tppl.discount2) 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 <= 215 and tcctp.nleft >= 214
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc
2.13ms
35
SELECT FOUND_ROWS() AS totrow
170μs
36
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-05-17 11:48:09' AND to_date > '2024-05-17 11:48:09' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
116μs
37
SELECT FOUND_ROWS() AS totrow
103μs
38
SELECT SQL_CALC_FOUND_ROWS
tp.code_master AS code,
tpd.name_es AS name,
tpd.title_es AS title,
tpd.excerpt_es AS excerpt,
tpd.description_es AS description,
tpd.name_it AS name_default,
tpd.title_it AS title_default,
tpd.excerpt_it AS excerpt_default,
tpd.description_it AS description_default,
tp.family_code,
tfp.name_es AS family_name,
tfp.name_it AS family_name_default,
tp.season_code,
tp.gender_code,
tpd.meta_title_es AS meta_title,
tpd.meta_keywords_es AS meta_keywords,
tpd.meta_description_es AS meta_description,
tpd.meta_title_it AS meta_title_default,
tpd.meta_keywords_it AS meta_keywords_default,
tpd.meta_description_it AS meta_description_default,
tctp.label_variant1_es AS label_variant1,
tctp.label_variant2_es AS label_variant2,
tctp.label_variant1_it AS label_variant1_default,
tctp.label_variant2_it AS label_variant2_default,
tctp.variant_image,
tp.own_production,
tp.pack,
tpd.default_variant1,
tp.featured,
tp.featured2,
MAX(tppl.discount1) AS discount1,
MAX(tppl.discount2) AS discount2,
MIN(tppl.price) AS original_price,
tppl.currency,
MIN(productPrice(tppl.price,tppl.discount1,tppl.discount2)) 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 <= 215 and tcctp.nleft >= 214 AND tp.code_master != '0710056'
GROUP BY
tp.code_master
ORDER BY
RAND() asc
LIMIT 0, 4
106ms
39
SELECT FOUND_ROWS() AS totrow
362μ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 ('0710025209452A','0710044216466A','0730059160000A','0710025203452A')
ORDER BY
tbl_products_images.sorting ASC
1.18ms
41
SELECT SQL_CALC_FOUND_ROWS
tp.code_master,
tp.color_code,
tszp.code,
tszp.name_es AS name,
tszp.name_it AS name_default
FROM tbl_products tp
LEFT OUTER JOIN tbl_sizes_product tszp ON (tp.size = tszp.code)
WHERE (tszp.id IS NOT NULL OR tp.size = '000') AND tp.code_master IN ("0710025CM","0710044","0730059","0710025CB") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc
955μs
42
SELECT FOUND_ROWS() AS totrow
171μs
43
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-05-17 11:48:09' AND to_date > '2024-05-17 11:48:09' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
133μs
44
SELECT FOUND_ROWS() AS totrow
109μs
45
SELECT SQL_CALC_FOUND_ROWS
tp.id,
tp.code,
tp.code_master,
tp.color_code,
tcp.name_es AS color_name,
tcp.name_it AS color_name_default,
tpd.name_es,
tpd.name_it AS name_default,
tp.size,
tszp.name_es AS size_name,
tszp.name_it AS size_name_default,
tszp.sorting AS size_sorting,
(tpst.quantity - IFNULL(torr_stb.quantity,0)) AS availability,
tpst.availability_date,
(tpst.future_quantity - IFNULL(torr_stb.quantity,0)) AS future_availability,
tpst.coming_arrivals_quantity,
tpst.coming_arrivals_date,
tp.family_code,
tp.category_code,
tpd.line_code,
tp.season_code,
tp.gender_code,
tp.commercial_code,
tp.own_production,
tp.pack,
tppl.discount1 AS discount1,
tppl.discount2 AS discount2,
productPrice(tppl.price,tppl.discount1,tppl.discount2) 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 ("0710025CM","0710044","0730059","0710025CB") AND tcctp.nright <= 215 and tcctp.nleft >= 214
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc
12.93ms
46
SELECT FOUND_ROWS() AS totrow
193μ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 ('0710025203452A','0710025203466A','0710025203476A','0710025203486A','0710025203496A','0710025203506A','0710025209452A','0710025209466A','0710025209476A','0710025209486A','0710025209496A','0710025209506A','0710044216452A','0710044216466A','0710044216476A','0710044216486A','0710044216496A','0710044216506A','0730059160000A')
ORDER BY
tbl_products_images.sorting ASC
2.25ms
48
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "68cb97e86fabb3cc85d81e5d09089d31" and scope is null
LIMIT 0, 1
183μs
49
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "c44a1a3420df56fe335fab4668d57c90" and scope is null
LIMIT 0, 1
119μs
50
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "9ce416335987b4dfdc083db1fde250e2" and scope is null
LIMIT 0, 1
112μs
51
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "ff6fbc0f84e2abc908206014316f0b99" and scope is null
LIMIT 0, 1
145μs
52
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "1113fca866539d319db4413175dc1bd1" and scope is null
LIMIT 0, 1
113μs
53
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "0a0b6f3f2fb36e77b9788457562b95e0" and scope is null
LIMIT 0, 1
138μs
54
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.string,
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
362μs
55
SELECT FOUND_ROWS() AS totrow
181μs
Totale148ms