SCREEN CONSOLE PSI

  • Seac Screen Console è un computer subacqueo dallo schermo ampio, leggibile, con contrasto e luminosità regolabili. Tutti i dati che ti servono sono visibili, a colpo d’occhio, in un’unica schermata.
  • Anche con guanti molto pesanti è facile gestire tutte le funzioni di Seac Screen, grazie ai due pulsanti frontali ben definiti. Il manometro è disponibile sia con scala in BAR sia in PSI.
  • Funzioni principali: Scuba (gestione dell’immersione secondo algoritmo Bühlmann ZHL-16C), Gauge (gestione autonoma con profondimetro e cronometro), Free (tempi e profondità per chi pratica apnea).
  • Gestione di 1 o 2 miscele (aria, Nitrox e altre con O2 max 99%). Allarme violazione MOD, Deco Stop ed eccessiva velocità in risalita. Planner per simulazione di immersione “NDL only”.
  • Registra fino a 40 ore di immersione in modalità Scuba/Gauge o 18 ore in modalità Free. Dati scaricabili e aggiornamento software via USB e applicativo Seac Dive Manager gratuito sul sito Seacsub.com

Seac Screen è il computer subacqueo che punta alla chiarezza e alla facilità di lettura di tutti i dati relativi al profilo d’immersione. L’ampio display mostra tutte le informazioni utili in una sola schermata, con caratteri ben leggibili e distinti. Contrasto e luminosità possono essere regolati, così come la modalità (automatica o manuale) e il tempo di retro illuminazione (da 2” a 60”). Il display misura 4x4,7cm ed è protetto da una robusta scocca rivestita in gomma. Dimensioni totali quadrante 6,7x7cm. Il cinturino è lungo ed è pensato per allacciare comodamente Seac Screen anche sopra una muta stagna. Lunghezza totale, dalla fibbia all’estremità opposta: circa 36 cm. I due pulsanti frontali ben definiti permettono di utilizzare Seac Screen in modo facile e veloce anche guanti molto pesanti. Seac Screen opera in 3 modalità principali: Scuba, Gauge e Free. In modalità Scuba il profilo d’immersione è automaticamente gestito secondo l’algoritmo di decompressione Bühlmann ZHL-16C. Supporta la gestione di 1 o 2 miscele (aria, Nitrox e altre miscele con O2 fino al 99%) avvisando l’utente nel momento più idoneo per effettuare il cambio. Allarmi sonori e luminosi in caso di violazione della tappa di decompressione, di eccessiva velocità in risalita e di superamento della profondità massima consentita con le miscele in uso. In modalità Gauge il computer Seac Screen mostra profondimetro e cronometro per una gestione dell’immersione in totale autonomia da parte dei subacquei più esperti. In modalità Free chi pratica apnea può visualizzare tempi di superficie e di tuffo, profondità attuale e profondità massima raggiunta durante la sessione. Il Planner di immersione di Seac Screen consente di simulare e pianificare un’immersione visualizzando il tempo di NDL in base alla profondità impostata e agli altri dati di input (miscela, PpO2 massima, livello di prudenza di calcolo dell’algoritmo). Il Logbook memorizza fino a 40 ore di immersione in modalità Scuba/Gauge o 18 ore in modalità Free. Dati scaricabili e aggiornamento software con cavo USB-C e applicativo Seac Dive Manager scaricabile gratuitamente sul sito Seacsub.com. Il cavo USB-C può essere incluso o meno nella confezione a seconda del package acquistato. Seac Screen funziona con una batteria CR2450, non ricaricabile. Può essere sostituita dall’utente ma si consiglia comunque di rivolgersi a un centro autorizzato Seac per cambiare anche l’o-ring originale del vano batteria. Altro: profondità massima 100 metri, calcolo tempi di NoFly e Desaturazione, avviso altitudine massima concessa, selezione acqua dolce o salata. Seac Screen è disponibile anche in versione console abbinato a un manometro.
Scuba mode - Gauge
Scuba: gestione dell’immersione secondo algoritmo Bühlmann ZHL-16C) gestione di 1 o 2 miscele (aria, Nitrox e altre con O2 max 99%)
Gauge: gestione autonoma con profondimetro e cronometro
Schermo LCD
Il display misura 4x4,7cm ed è protetto da una robusta scocca rivestita in gomma. Dimensioni totali quadrante 6,7x7cm. Il cinturino è lungo ed è pensato per allacciare comodamente Seac Screen anche sopra una muta stagna. Protezione schermo inclusa
Manometro integrato
Il manometro è disponibile sia con scala in BAR sia in PSI. Anche con guanti molto pesanti è facile gestire tutte le funzioni di Seac Screen, grazie ai due pulsanti frontali ben definiti.
Batteria
Screen funziona con una batteria CR2450, non ricaricabile. Può essere sostituita dall’utente ma si consiglia comunque di rivolgersi a un centro autorizzato Seac

Prodotti correlati

TURTLE
FISCHIETTO BITONALE NERO
BOA SEGNA SUB C/SAGOL
KOMODA FLEX 5 MM MAN
Contatti
Privacy policy
Cookie policy
Progetto ARCHE
Modello 231
Codice etico
MeasuruesSize
Memory Usage17.82 MB
Load Time306ms
Server Variables
Array
(
    [USER] => u.webdevarea
    [HOME] => /var/www/vhosts/devb2b.seacsub.com
    [SCRIPT_NAME] => /index.php
    [REQUEST_URI] => /seacsub/1/scuba/1600011/screen-console-psi.html
    [QUERY_STRING] => filename=single-product&pc=1600011&p=screen-console-psi&cctc=1&cct=scuba&shop=seacsub
    [REQUEST_METHOD] => GET
    [SERVER_PROTOCOL] => HTTP/1.0
    [GATEWAY_INTERFACE] => CGI/1.1
    [REDIRECT_QUERY_STRING] => filename=single-product&pc=1600011&p=screen-console-psi&cctc=1&cct=scuba&shop=seacsub
    [REDIRECT_URL] => /single-product.php
    [REMOTE_PORT] => 35156
    [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] => 3.23.103.216
    [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_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] => 3.23.103.216
    [HTTP_HOST] => devb2b.seacsub.com
    [proxy-nokeepalive] => 1
    [HTTPS] => on
    [SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/1/scuba/1600011/screen-console-psi.html
    [SCRIPT_URL] => /seacsub/1/scuba/1600011/screen-console-psi.html
    [UNIQUE_ID] => Z0EN7WhNHQOukwB8Nxpq1QAAAAM
    [REDIRECT_STATUS] => 200
    [REDIRECT_HTTPS] => on
    [REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/1/scuba/1600011/screen-console-psi.html
    [REDIRECT_SCRIPT_URL] => /seacsub/1/scuba/1600011/screen-console-psi.html
    [REDIRECT_UNIQUE_ID] => Z0EN7WhNHQOukwB8Nxpq1QAAAAM
    [REDIRECT_REDIRECT_STATUS] => 200
    [REDIRECT_REDIRECT_HTTPS] => on
    [REDIRECT_REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/1/scuba/1600011/screen-console-psi.html
    [REDIRECT_REDIRECT_SCRIPT_URL] => /seacsub/1/scuba/1600011/screen-console-psi.html
    [REDIRECT_REDIRECT_UNIQUE_ID] => Z0EN7WhNHQOukwB8Nxpq1QAAAAM
    [FCGI_ROLE] => RESPONDER
    [PHP_SELF] => /index.php
    [REQUEST_TIME_FLOAT] => 1732316654.0076
    [REQUEST_TIME] => 1732316654
)
#QueryTime (sec)
0
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.* FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
1.76ms
1
SELECT FOUND_ROWS() AS totrow
435μ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.58ms
3
SELECT FOUND_ROWS() AS totrow
244μs
4
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 00:04:14' AND to_date > '2024-11-23 00:04:14' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
1.83ms
5
SELECT FOUND_ROWS() AS totrow
274μ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"%')
402μs
7
SELECT FOUND_ROWS() AS totrow
229μ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
280μs
9
SELECT FOUND_ROWS() AS totrow
185μ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
371μs
11
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 00:04:14' AND to_date > '2024-11-23 00:04:14' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
271μs
12
SELECT FOUND_ROWS() AS totrow
173μ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 <= 32 and tcctp.nleft >= 1 AND tp.code_master = "1600011"
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc
LIMIT 0, 1
4.28ms
14
SELECT FOUND_ROWS() AS totrow
225μ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 ('1600011000000A')
ORDER BY
tbl_products_images.sorting ASC
1.81ms
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 ("1600011")
GROUP BY
tp.code_master,tqfp.id
ORDER BY
tqfp.sorting asc,tqfp.id asc
1.26ms
17
SELECT FOUND_ROWS() AS totrow
201μ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 ("1600011")
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
1.03ms
19
SELECT FOUND_ROWS() AS totrow
210μ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 ("1600011") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc
1.9ms
21
SELECT FOUND_ROWS() AS totrow
235μs
22
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 00:04:14' AND to_date > '2024-11-23 00:04:14' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
193μs
23
SELECT FOUND_ROWS() AS totrow
159μ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 ("1600011") AND tcctp.nright <= 32 and tcctp.nleft >= 1
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc
5.29ms
25
SELECT FOUND_ROWS() AS totrow
212μ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 ('1600011000000A')
ORDER BY
tbl_products_images.sorting ASC
281μs
27
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 00:04:14' AND to_date > '2024-11-23 00:04:14' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
562μs
28
SELECT FOUND_ROWS() AS totrow
345μ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 = '1600011'
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc
2.59ms
30
SELECT FOUND_ROWS() AS totrow
232μs
31
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 00:04:14' AND to_date > '2024-11-23 00:04:14' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
216μs
32
SELECT FOUND_ROWS() AS totrow
163μ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 <= 32 and tcctp.nleft >= 1
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc
3.88ms
34
SELECT FOUND_ROWS() AS totrow
227μs
35
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 00:04:14' AND to_date > '2024-11-23 00:04:14' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
197μs
36
SELECT FOUND_ROWS() AS totrow
182μ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 <= 32 and tcctp.nleft >= 1 AND tp.code_master != '1600011'
GROUP BY
tp.code_master
ORDER BY
RAND() asc
LIMIT 0, 4
122ms
38
SELECT FOUND_ROWS() AS totrow
218μ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 ('0840031003520A','1110056520000A','0950013007000A','0010218250080A')
ORDER BY
tbl_products_images.sorting ASC
1.42ms
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 ("0840031","1110056","0950013G","0010218M5") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc
1.31ms
41
SELECT FOUND_ROWS() AS totrow
185μs
42
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-11-23 00:04:14' AND to_date > '2024-11-23 00:04:14' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
194μs
43
SELECT FOUND_ROWS() AS totrow
158μ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 ("0840031","1110056","0950013G","0010218M5") AND tcctp.nright <= 32 and tcctp.nleft >= 1
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc
18.15ms
45
SELECT FOUND_ROWS() AS totrow
283μ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 ('0010218250040A','0010218250055A','0010218250080A','0010218250105A','0010218250125A','0010218250145A','0010218250160A','0840031003520A','0950013007000A','1110056520000A')
ORDER BY
tbl_products_images.sorting ASC
2.35ms
47
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.string,
tbl_dictionary.translate_it AS translate FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
508μs
48
SELECT FOUND_ROWS() AS totrow
199μs
Totale180ms