SMART

Il jacket Seac Smart è un GAV tradizionale caratterizzato da un sacco rinforzato e un sistema di rilascio rapido dei piombi . Seac Smart è un GAV robusto, compatto e facile da usare, ottimo per i subacquei principianti e per coloro che amano viaggiare. Su entrambi i lati sono presenti tasche distinte per piombi e accessori. Le tasche piombi hanno due aperture con velcro, una, superiore, per inserire i piombi e un’altra, inferiore, per assicurare il rilascio rapido della zavorra in caso di necessità. Il sistema di sgancio dei piombi è di tipo Safety Release, con fibbia e maniglia color argento per maggiore visibilità. Le tasche porta oggetti sono invece chiuse con robuste zip anti corrosione.
Tasche per zavorra a sgancio rapido
Le tasche piombi hanno due aperture con velcro, una, superiore, per inserire i piombi e un’altra, inferiore, per assicurare il rilascio rapido della zavorra in caso di necessità
Sacco rinforzato
GAV tradizionale caratterizzato da un sacco rinforzato, con valvole di sovrapressione
Sistema Safety Release
Il sistema di sgancio dei piombi è di tipo Safety Release, con fibbia e maniglia color argento per maggiore visibilità

Prodotti correlati

MeasuruesSize
Memory Usage13.6 MB
Load Time0.2464 sec
Server Variables
Array
(
    [USER] => u.webdevarea
    [HOME] => /var/www/vhosts/b2b.seac.webdevarea.it
    [SCRIPT_NAME] => /single-product.php
    [REQUEST_URI] => /seacsub/5/scuba-gav/0420034/smart.html
    [QUERY_STRING] => pc=0420034&p=smart&cctc=5&cct=scuba-gav&shop=seacsub
    [REQUEST_METHOD] => GET
    [SERVER_PROTOCOL] => HTTP/1.0
    [GATEWAY_INTERFACE] => CGI/1.1
    [REDIRECT_URL] => /seacsub/5/scuba-gav/0420034/smart.html
    [REDIRECT_QUERY_STRING] => pc=0420034&p=smart&cctc=5&cct=scuba-gav&shop=seacsub
    [REMOTE_PORT] => 47520
    [SCRIPT_FILENAME] => /var/www/vhosts/b2b.seac.webdevarea.it/httpdocs/single-product.php
    [SERVER_ADMIN] => root@localhost
    [CONTEXT_DOCUMENT_ROOT] => /var/www/vhosts/b2b.seac.webdevarea.it/httpdocs
    [CONTEXT_PREFIX] => 
    [REQUEST_SCHEME] => https
    [DOCUMENT_ROOT] => /var/www/vhosts/b2b.seac.webdevarea.it/httpdocs
    [REMOTE_ADDR] => 44.200.169.3
    [SERVER_PORT] => 443
    [SERVER_ADDR] => 80.211.158.51
    [SERVER_NAME] => b2b.seac.webdevarea.it
    [SERVER_SOFTWARE] => Apache
    [SERVER_SIGNATURE] => 
    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/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] => 44.200.169.3
    [HTTP_HOST] => b2b.seac.webdevarea.it
    [proxy-nokeepalive] => 1
    [HTTPS] => on
    [PERL5LIB] => /usr/share/awstats/lib:/usr/share/awstats/plugins
    [GEOIP_COUNTRY_CODE] => US
    [MM_COUNTRY_NAME] => United States
    [MMDB_INFO] => result found
    [MMDB_ADDR] => 44.200.169.3
    [UNIQUE_ID] => Y4a2eqPPZkE2zPQ3cHdLLgAAANQ
    [REDIRECT_STATUS] => 200
    [REDIRECT_HTTPS] => on
    [REDIRECT_PERL5LIB] => /usr/share/awstats/lib:/usr/share/awstats/plugins
    [REDIRECT_GEOIP_COUNTRY_CODE] => US
    [REDIRECT_MM_COUNTRY_NAME] => United States
    [REDIRECT_MMDB_INFO] => result found
    [REDIRECT_MMDB_ADDR] => 44.200.169.3
    [REDIRECT_UNIQUE_ID] => Y4a2eqPPZkE2zPQ3cHdLLgAAANQ
    [FCGI_ROLE] => RESPONDER
    [PHP_SELF] => /single-product.php
    [REQUEST_TIME_FLOAT] => 1669772922.1056
    [REQUEST_TIME] => 1669772922
)
#QueryTime (sec)
0
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.*
FROM tbl_dictionary
0.0019
1
SELECT FOUND_ROWS() AS totrow
0.0002
2
SELECT SQL_CALC_FOUND_ROWS
tbl_settings.*
FROM tbl_settings
WHERE (company_code = "000" OR company_code = '')
AND (shop_code = "seacsub" OR shop_code = '')
0.0003
3
SELECT FOUND_ROWS() AS totrow
0.0002
4
SELECT SQL_CALC_FOUND_ROWS
tbl_products_price_lists.code,
tbl_products_price_lists.description,
tbl_products_price_lists.currency
FROM tbl_products_price_lists
GROUP BY
tbl_products_price_lists.code
ORDER BY
FIELD(code, '01') desc, (ABS(code)) asc 
0.0274
5
SELECT FOUND_ROWS() AS totrow
0.0002
6
SELECT SQL_CALC_FOUND_ROWS
tbl_products_price_lists.code,
tbl_products_price_lists.description,
tbl_products_price_lists.currency
FROM tbl_products_price_lists
GROUP BY
tbl_products_price_lists.code
ORDER BY
FIELD(code, '01') desc, (ABS(code)) asc 
0.0275
7
SELECT FOUND_ROWS() AS totrow
0.0002
8
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2022-11-30 02:48:42' AND to_date > '2022-11-30 02:48:42' AND (order_type = 1 OR order_type = "") AND (company_code = 0)
0.0007
9
SELECT FOUND_ROWS() AS totrow
0.0002
10
SELECT SQL_CALC_FOUND_ROWS
tcctp.id,
tcctp.parent_id
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 = tp.company_code 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 = tp.company_code AND tppl_c.currency = '99' AND tppl_c.code = '01')
INNER JOIN tbl_products_catalog_categories tpcct ON (tp.code = tpcct.product_code) INNER JOIN tbl_catalog_categories_product tcctp ON (tcctp.id = tpcct.category_id)
WHERE
tp.company_code = "000"
and tcctp.enabled = 1 and tcctp.id is not null and tfp.enabled = 1 AND tctp.enabled = 1 and tpd.product_code_master is not null AND tp.enabled = 1 AND tppl_c.price > 0 AND tcctp.view_type LIKE '%"0"%' || tcctp.view_type LIKE '%"1"%'
GROUP BY
tcctp.id
0.0002
11
SELECT FOUND_ROWS() AS totrow
0.0002
12
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,15,170,47,58,152,2,4,5,6,7,10,11,13,14,20,24,25,26,37,48,49,50,51,52,55,59,60,61,62,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,185,186,187,188,189,190,195,197,218,220,221) and enabled = 1
ORDER BY
tbl_catalog_categories_product.sorting asc 
0.0003
13
SELECT FOUND_ROWS() AS totrow
0.0002
14
SELECT SQL_CALC_FOUND_ROWS
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
LIMIT 0, 1 
0.0003
15
SELECT FOUND_ROWS() AS totrow
0.0002
16
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2022-11-30 02:48:42' AND to_date > '2022-11-30 02:48:42' AND (order_type = 1 OR order_type = "") AND (company_code = 0)
0.0002
17
SELECT FOUND_ROWS() AS totrow
0.0002
18
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,
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,
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 = tp.company_code 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 = tp.company_code 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
tp.company_code = "000"
and tfp.enabled = 1 AND tctp.enabled = 1 and tpd.product_code_master is not null AND tp.enabled = 1 AND tppl_c.price > 0 AND tcctp.nright <= 7 and tcctp.nleft >= 6 AND tp.code_master = "0420034"
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc
LIMIT 0, 1 
0.0025
19
SELECT FOUND_ROWS() AS totrow
0.0002
20
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 ('0420034000040A')
ORDER BY
tbl_products_images.sorting ASC
0.0008
21
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.company_code = "000"
and tp.enabled = 1 AND tqfp.id IS NOT NULL AND tqfp.enabled = 1 AND tp.code_master IN ("0420034")
GROUP BY
tp.code_master,tqfp.id
ORDER BY
tqfp.sorting asc,tqfp.id asc 
0.0009
22
SELECT FOUND_ROWS() AS totrow
0.0002
23
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 ("0420034")
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 
0.0006
24
SELECT FOUND_ROWS() AS totrow
0.0002
25
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
tp.company_code = "000"
and (tszp.id IS NOT NULL OR tp.size = '000') AND tp.code_master IN ("0420034") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc 
0.0008
26
SELECT FOUND_ROWS() AS totrow
0.0002
27
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2022-11-30 02:48:42' AND to_date > '2022-11-30 02:48:42' AND (order_type = 1 OR order_type = "") AND (company_code = 0)
0.0002
28
SELECT FOUND_ROWS() AS totrow
0.0002
29
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,
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 = tp.company_code 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 = tp.company_code 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 = tp.company_code) 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 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
tp.company_code = "000"
and tfp.enabled = 1 AND tctp.enabled = 1 and tpd.product_code_master is not null AND tp.enabled = 1 AND tppl_c.price > 0 AND code_master IN ("0420034") AND tcctp.nright <= 7 and tcctp.nleft >= 6
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc 
0.0131
30
SELECT FOUND_ROWS() AS totrow
0.0002
31
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 ('0420034000015A','0420034000025A','0420034000040A','0420034000055A','0420034000080A','0420034000105A')
ORDER BY
tbl_products_images.sorting ASC
0.001
32
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
33
SELECT FOUND_ROWS() AS totrow
0.0002
34
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
35
SELECT FOUND_ROWS() AS totrow
0.0002
36
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
37
SELECT FOUND_ROWS() AS totrow
0.0002
38
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
39
SELECT FOUND_ROWS() AS totrow
0.0002
40
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
41
SELECT FOUND_ROWS() AS totrow
0.0002
42
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
43
SELECT FOUND_ROWS() AS totrow
0.0002
44
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "801ab24683a4a8c433c6eb40c48bcd9d"
LIMIT 0, 1 
0.0002
45
SELECT FOUND_ROWS() AS totrow
0.0002
46
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "821b8ee6937cec96c30fdafbfe836d68"
LIMIT 0, 1 
0.0002
47
SELECT FOUND_ROWS() AS totrow
0.0002
48
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "9aa698f602b1e5694855cee73a683488"
LIMIT 0, 1 
0.0002
49
SELECT FOUND_ROWS() AS totrow
0.0002
50
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2022-11-30 02:48:42' AND to_date > '2022-11-30 02:48:42' AND (order_type = 1 OR order_type = "") AND (company_code = 0)
0.0002
51
SELECT FOUND_ROWS() AS totrow
0.0002
52
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,
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,
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 = tp.company_code 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 = tp.company_code 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
tp.company_code = "000"
and tfp.enabled = 1 AND tctp.enabled = 1 and tpd.product_code_master is not null AND tp.enabled = 1 AND tppl_c.price > 0 AND tprp.product_code = '0420034'
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc 
0.0014
53
SELECT FOUND_ROWS() AS totrow
0.0002
54
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2022-11-30 02:48:42' AND to_date > '2022-11-30 02:48:42' AND (order_type = 1 OR order_type = "") AND (company_code = 0)
0.0002
55
SELECT FOUND_ROWS() AS totrow
0.0002
56
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,
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 = tp.company_code 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 = tp.company_code 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 = tp.company_code) 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 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
tp.company_code = "000"
and tfp.enabled = 1 AND tctp.enabled = 1 and tpd.product_code_master is not null AND tp.enabled = 1 AND tppl_c.price > 0 AND code_master IN ("") AND tcctp.nright <= 7 and tcctp.nleft >= 6
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc 
0.0016
57
SELECT FOUND_ROWS() AS totrow
0.0002
58
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2022-11-30 02:48:42' AND to_date > '2022-11-30 02:48:42' AND (order_type = 1 OR order_type = "") AND (company_code = 0)
0.0002
59
SELECT FOUND_ROWS() AS totrow
0.0002
60
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,
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,
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 = tp.company_code 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 = tp.company_code 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
tp.company_code = "000"
and tfp.enabled = 1 AND tctp.enabled = 1 and tpd.product_code_master is not null AND tp.enabled = 1 AND tppl_c.price > 0 AND tcctp.nright <= 7 and tcctp.nleft >= 6 AND tp.code_master != '0420034'
GROUP BY
tp.code_master
ORDER BY
RAND() asc
LIMIT 0, 4 
0.0111
61
SELECT FOUND_ROWS() AS totrow
0.0002
62
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 ('0420039000998A','6420011000015A','6420012000025A','0420005000005A')
ORDER BY
tbl_products_images.sorting ASC
0.0007
63
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
tp.company_code = "000"
and (tszp.id IS NOT NULL OR tp.size = '000') AND tp.code_master IN ("0420039","6420011","6420012","0420005") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc 
0.001
64
SELECT FOUND_ROWS() AS totrow
0.0002
65
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2022-11-30 02:48:42' AND to_date > '2022-11-30 02:48:42' AND (order_type = 1 OR order_type = "") AND (company_code = 0)
0.0002
66
SELECT FOUND_ROWS() AS totrow
0.0002
67
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,
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 = tp.company_code 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 = tp.company_code 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 = tp.company_code) 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 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
tp.company_code = "000"
and tfp.enabled = 1 AND tctp.enabled = 1 and tpd.product_code_master is not null AND tp.enabled = 1 AND tppl_c.price > 0 AND code_master IN ("0420039","6420011","6420012","0420005") AND tcctp.nright <= 7 and tcctp.nleft >= 6
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc 
0.0182
68
SELECT FOUND_ROWS() AS totrow
0.0002
69
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 ('6420012000025A','6420011000105A','6420011000080A','6420011000055A','6420011000040A','6420011000025A','6420011000015A','6420012000105A','0420039000998A','6420012000080A','6420012000055A','6420012000040A','0420005000005A','0420005000015A','0420005000025A','0420005000040A','0420005000055A','0420005000080A','0420005000105A')
ORDER BY
tbl_products_images.sorting ASC
0.0012
70
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
71
SELECT FOUND_ROWS() AS totrow
0.0002
72
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
73
SELECT FOUND_ROWS() AS totrow
0.0002
74
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
75
SELECT FOUND_ROWS() AS totrow
0.0002
76
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
77
SELECT FOUND_ROWS() AS totrow
0.0002
78
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
79
SELECT FOUND_ROWS() AS totrow
0.0002
80
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
81
SELECT FOUND_ROWS() AS totrow
0.0002
82
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
83
SELECT FOUND_ROWS() AS totrow
0.0002
84
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
85
SELECT FOUND_ROWS() AS totrow
0.0002
86
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0001
87
SELECT FOUND_ROWS() AS totrow
0.0002
88
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
89
SELECT FOUND_ROWS() AS totrow
0.0002
90
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
91
SELECT FOUND_ROWS() AS totrow
0.0002
92
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
93
SELECT FOUND_ROWS() AS totrow
0.0002
94
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
95
SELECT FOUND_ROWS() AS totrow
0.0002
96
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
97
SELECT FOUND_ROWS() AS totrow
0.0002
98
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0001
99
SELECT FOUND_ROWS() AS totrow
0.0002
100
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
101
SELECT FOUND_ROWS() AS totrow
0.0002
102
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0001
103
SELECT FOUND_ROWS() AS totrow
0.0002
104
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0001
105
SELECT FOUND_ROWS() AS totrow
0.0002
106
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
0.0002
107
SELECT FOUND_ROWS() AS totrow
0.0002
108
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.string,
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
0.0005
109
SELECT FOUND_ROWS() AS totrow
0.0002
Totale0.1299