SZ3000

  • Baterías: ion de litio 5400 mAh recargables por conexión USB-C.
  • Modos de funcionamiento: potencia máxima, potencia reducida, modo intermitente.
  • Interruptor con seguro para impedir el encendido accidental.
  • Lúmenes
    Lámpara LED mono que desarrolla 2300 lúmenes a plena potencia y 730 lúmenes a potencia intermedia
    Bateria
    Carga de batería externa, con cable de carga USB-C y LED para comprobar el estado de carga. Li-Ion interno 5400mAh
    Botón de encendido y apagado
    El botón de encendido y apagado es magnético y tiene un resorte de retorno.
    Estuche a prueba de golpes
    La bolsa que contiene la lámpara está hecha de material a prueba de golpes. Muy útil en el transporte de la antorcha, incluso por aire

    Productos relacionados

    MeasuruesSize
    Memory Usage19.19 MB
    Load Time157ms
    Server Variables
    Array
    (
        [USER] => u.webdevarea
        [HOME] => /var/www/vhosts/devb2b.seacsub.com
        [SCRIPT_NAME] => /index.php
        [REQUEST_URI] => /es/seacsub/0500028/sz3000.html
        [QUERY_STRING] => filename=single-product&pc=0500028&p=sz3000&language=es&shop=seacsub
        [REQUEST_METHOD] => GET
        [SERVER_PROTOCOL] => HTTP/1.0
        [GATEWAY_INTERFACE] => CGI/1.1
        [REDIRECT_QUERY_STRING] => filename=single-product&pc=0500028&p=sz3000&language=es&shop=seacsub
        [REDIRECT_URL] => /single-product.php
        [REMOTE_PORT] => 50388
        [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.142.197.111
        [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.142.197.111 [HTTP_HOST] => devb2b.seacsub.com [proxy-nokeepalive] => 1 [HTTPS] => on [SCRIPT_URI] => https://devb2b.seacsub.com/es/seacsub/0500028/sz3000.html [SCRIPT_URL] => /es/seacsub/0500028/sz3000.html [UNIQUE_ID] => Z2jqyvi2WoauswvDaCw8lAAAAAI [REDIRECT_STATUS] => 200 [REDIRECT_HTTPS] => on [REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/es/seacsub/0500028/sz3000.html [REDIRECT_SCRIPT_URL] => /es/seacsub/0500028/sz3000.html [REDIRECT_UNIQUE_ID] => Z2jqyvi2WoauswvDaCw8lAAAAAI [REDIRECT_REDIRECT_STATUS] => 200 [REDIRECT_REDIRECT_HTTPS] => on [REDIRECT_REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/es/seacsub/0500028/sz3000.html [REDIRECT_REDIRECT_SCRIPT_URL] => /es/seacsub/0500028/sz3000.html [REDIRECT_REDIRECT_UNIQUE_ID] => Z2jqyvi2WoauswvDaCw8lAAAAAI [FCGI_ROLE] => RESPONDER [PHP_SELF] => /index.php [REQUEST_TIME_FLOAT] => 1734929098.6826 [REQUEST_TIME] => 1734929098 )
    #QueryTime (sec)
    0
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.* FROM tbl_dictionary
    WHERE ifnull(scope,'') = ""
    
    1.01ms
    1
    SELECT FOUND_ROWS() AS totrow
    364μ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.33ms
    3
    SELECT FOUND_ROWS() AS totrow
    208μ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 
    250μs
    5
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 05:44:58' AND to_date > '2024-12-23 05:44:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    1.21ms
    6
    SELECT FOUND_ROWS() AS totrow
    211μ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"%')
    
    216μs
    8
    SELECT FOUND_ROWS() AS totrow
    147μ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
    146μ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 
    215μs
    12
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 05:44:58' AND to_date > '2024-12-23 05:44:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    153μs
    13
    SELECT FOUND_ROWS() AS totrow
    155μ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,
    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')
    WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND tp.code_master = "0500028"
    GROUP BY
    tp.code_master
    ORDER BY
    tpd.sorting asc
    LIMIT 0, 1 
    1.53ms
    15
    SELECT FOUND_ROWS() AS totrow
    171μ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 ('0500028520000A')
    ORDER BY
    tbl_products_images.sorting ASC
    
    240μ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 ("0500028")
    GROUP BY
    tp.code_master,tqfp.id
    ORDER BY
    tqfp.sorting asc,tqfp.id asc 
    958μs
    18
    SELECT FOUND_ROWS() AS totrow
    182μ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 ("0500028")
    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 
    971μs
    20
    SELECT FOUND_ROWS() AS totrow
    178μ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 ("0500028") AND tp.enabled = 1
    GROUP BY
    tp.code
    ORDER BY
    tszp.sorting asc,tszp.id asc 
    772μs
    22
    SELECT FOUND_ROWS() AS totrow
    174μs
    23
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 05:44:58' AND to_date > '2024-12-23 05:44:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    231μs
    24
    SELECT FOUND_ROWS() AS totrow
    162μ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,
    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)
    WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND code_master IN ("0500028")
    GROUP BY
    tp.code
    ORDER BY
    tp.color_code asc,tszp.sorting asc 
    3.61ms
    26
    SELECT FOUND_ROWS() AS totrow
    292μ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 ('0500028520000A')
    ORDER BY
    tbl_products_images.sorting ASC
    
    222μs
    28
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 05:44:58' AND to_date > '2024-12-23 05:44:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    331μs
    29
    SELECT FOUND_ROWS() AS totrow
    279μs
    30
    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 AND
    tp.code_master = '0500028'
    GROUP BY
    tpcct.category_id
    )
    
    170μs
    31
    SELECT FOUND_ROWS() AS totrow
    181μs
    32
    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,6)
    ORDER BY
    tbl_catalog_categories_product.sorting asc 
    187μs
    33
    SELECT FOUND_ROWS() AS totrow
    134μs
    34
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 05:44:58' AND to_date > '2024-12-23 05:44:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    148μs
    35
    SELECT FOUND_ROWS() AS totrow
    136μs
    36
    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,
    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 = '0500028'
    GROUP BY
    tp.code_master
    ORDER BY
    tpd.sorting asc 
    1.49ms
    37
    SELECT FOUND_ROWS() AS totrow
    183μs
    38
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 05:44:58' AND to_date > '2024-12-23 05:44:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    122μs
    39
    SELECT FOUND_ROWS() AS totrow
    106μs
    40
    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,
    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 <= 9 and tcctp.nleft >= 8
    GROUP BY
    tp.code
    ORDER BY
    tp.color_code asc,tszp.sorting asc 
    2.18ms
    41
    SELECT FOUND_ROWS() AS totrow
    149μs
    42
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 05:44:58' AND to_date > '2024-12-23 05:44:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    125μs
    43
    SELECT FOUND_ROWS() AS totrow
    105μs
    44
    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,
    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 <= 9 and tcctp.nleft >= 8 AND tp.code_master != '0500028'
    GROUP BY
    tp.code_master
    ORDER BY
    RAND() asc
    LIMIT 0, 4 
    3.36ms
    45
    SELECT FOUND_ROWS() AS totrow
    146μ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 ('0500025020000A','0500022020000A','0530104000000A','0530108000000A')
    ORDER BY
    tbl_products_images.sorting ASC
    
    1.1ms
    47
    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 ("0500025","0500022","0530104","0530108") AND tp.enabled = 1
    GROUP BY
    tp.code
    ORDER BY
    tszp.sorting asc,tszp.id asc 
    907μs
    48
    SELECT FOUND_ROWS() AS totrow
    192μs
    49
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 05:44:58' AND to_date > '2024-12-23 05:44:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    127μs
    50
    SELECT FOUND_ROWS() AS totrow
    106μs
    51
    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,
    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 ("0500025","0500022","0530104","0530108") AND tcctp.nright <= 9 and tcctp.nleft >= 8
    GROUP BY
    tp.code
    ORDER BY
    tp.color_code asc,tszp.sorting asc 
    21.75ms
    52
    SELECT FOUND_ROWS() AS totrow
    189μs
    53
    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 ('0530108000000A','0530104000000A','0500025020000A','0500022020000A')
    ORDER BY
    tbl_products_images.sorting ASC
    
    1.11ms
    54
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_es AS translate FROM tbl_dictionary
    WHERE
    slug = "68cb97e86fabb3cc85d81e5d09089d31" and scope is null
    LIMIT 0, 1 
    343μs
    55
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_es AS translate FROM tbl_dictionary
    WHERE
    slug = "c44a1a3420df56fe335fab4668d57c90" and scope is null
    LIMIT 0, 1 
    135μs
    56
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_es AS translate FROM tbl_dictionary
    WHERE
    slug = "9ce416335987b4dfdc083db1fde250e2" and scope is null
    LIMIT 0, 1 
    128μs
    57
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_es AS translate FROM tbl_dictionary
    WHERE
    slug = "ff6fbc0f84e2abc908206014316f0b99" and scope is null
    LIMIT 0, 1 
    222μs
    58
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_es AS translate FROM tbl_dictionary
    WHERE
    slug = "1113fca866539d319db4413175dc1bd1" and scope is null
    LIMIT 0, 1 
    148μs
    59
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_es AS translate FROM tbl_dictionary
    WHERE
    slug = "0a0b6f3f2fb36e77b9788457562b95e0" and scope is null
    LIMIT 0, 1 
    126μs
    60
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.string,
    tbl_dictionary.translate_es AS translate FROM tbl_dictionary
    WHERE ifnull(scope,'') = ""
    
    395μs
    61
    SELECT FOUND_ROWS() AS totrow
    183μs
    Totale52.18ms