FIRE CAMO

  • Einstellbarer Leinenlöser für Links- und Rechtshänder.
  • Brustbeinstütze mit Gummipolsterung.
  • Im Lieferumfang enthalten: Reel, Shark Laser Schaft 6,5 mm, runde TriPower Gummizüge, 14 mm, mit zweifarbigem Dyneema-Wishbone.
  • Leinenauslöser
    Kann mit einer einzigen Schraube nach links oder rechts verstellt werden.
    Abzugsmechanismus
    Der gesamte Abzugsmechanismus ist aus rostfreiem Stahl. Kann schnell und einfach demontiert werden.
    Reibungsminderendes Rad
    Der gesamte Mechanismus besteht aus Stahl und ist mit einem Anti-Reibungsrad ausgestattet, um die Reibung zu minimieren und eine bessere Abzugsempfindlichkeit zu gewährleisten.
    Gummipolster
    Zur Dämpfung der Schussgeräusche dämpft ein Gummipolster den Schlag des Auslösehebels, wodurch der Schlag gedämpft wird.

    Verwandte Produkte

    MeasuruesSize
    Memory Usage19.55 MB
    Load Time272ms
    Server Variables
    Array
    (
        [USER] => u.webdevarea
        [HOME] => /var/www/vhosts/devb2b.seacsub.com
        [SCRIPT_NAME] => /index.php
        [REQUEST_URI] => /de/seacsub/1210050/fire-camo.html
        [QUERY_STRING] => filename=single-product&pc=1210050&p=fire-camo&language=de&shop=seacsub
        [REQUEST_METHOD] => GET
        [SERVER_PROTOCOL] => HTTP/1.0
        [GATEWAY_INTERFACE] => CGI/1.1
        [REDIRECT_QUERY_STRING] => filename=single-product&pc=1210050&p=fire-camo&language=de&shop=seacsub
        [REDIRECT_URL] => /single-product.php
        [REMOTE_PORT] => 37524
        [SCRIPT_FILENAME] => /var/www/vhosts/devb2b.seacsub.com/httpdocs/index.php
        [SERVER_ADMIN] => [no address given]
        [CONTEXT_DOCUMENT_ROOT] => /var/www/vhosts/devb2b.seacsub.com/httpdocs
        [CONTEXT_PREFIX] => 
        [REQUEST_SCHEME] => https
        [DOCUMENT_ROOT] => /var/www/vhosts/devb2b.seacsub.com/httpdocs
        [REMOTE_ADDR] => 18.222.119.143
        [SERVER_PORT] => 443
        [SERVER_ADDR] => 85.235.148.161
        [SERVER_NAME] => devb2b.seacsub.com
        [SERVER_SOFTWARE] => Apache
        [SERVER_SIGNATURE] => 
    Apache Server at devb2b.seacsub.com Port 443
    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin [HTTP_COOKIE] => fikker-Wlyt-7hIO=GKK8gDy2WBm0a8UOyhgfMhkXQZUr9Vif; care_did=9145d01e-c86b-441a-a922-2c58fa64203d [HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate [HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) [HTTP_ACCEPT] => */* [HTTP_CONNECTION] => close [HTTP_X_ACCEL_INTERNAL] => /internal-nginx-static-location [HTTP_X_REAL_IP] => 18.222.119.143 [HTTP_HOST] => devb2b.seacsub.com [proxy-nokeepalive] => 1 [HTTPS] => on [SCRIPT_URI] => https://devb2b.seacsub.com/de/seacsub/1210050/fire-camo.html [SCRIPT_URL] => /de/seacsub/1210050/fire-camo.html [UNIQUE_ID] => Z2iiXljI2hBJQr_3Jw6esAAAAAg [REDIRECT_STATUS] => 200 [REDIRECT_HTTPS] => on [REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/de/seacsub/1210050/fire-camo.html [REDIRECT_SCRIPT_URL] => /de/seacsub/1210050/fire-camo.html [REDIRECT_UNIQUE_ID] => Z2iiXljI2hBJQr_3Jw6esAAAAAg [REDIRECT_REDIRECT_STATUS] => 200 [REDIRECT_REDIRECT_HTTPS] => on [REDIRECT_REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/de/seacsub/1210050/fire-camo.html [REDIRECT_REDIRECT_SCRIPT_URL] => /de/seacsub/1210050/fire-camo.html [REDIRECT_REDIRECT_UNIQUE_ID] => Z2iiXljI2hBJQr_3Jw6esAAAAAg [FCGI_ROLE] => RESPONDER [PHP_SELF] => /index.php [REQUEST_TIME_FLOAT] => 1734910558.2067 [REQUEST_TIME] => 1734910558 )
    #QueryTime (sec)
    0
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.* FROM tbl_dictionary
    WHERE ifnull(scope,'') = ""
    
    903μs
    1
    SELECT FOUND_ROWS() AS totrow
    285μ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.14ms
    3
    SELECT FOUND_ROWS() AS totrow
    101μs
    4
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_de AS translate FROM tbl_dictionary
    WHERE
    slug = "19ec5b589f66eb57230083177d6e5468" and scope is null
    LIMIT 0, 1 
    200μs
    5
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 00:35:58' AND to_date > '2024-12-23 00:35:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    996μs
    6
    SELECT FOUND_ROWS() AS totrow
    154μ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"%')
    
    293μs
    8
    SELECT FOUND_ROWS() AS totrow
    127μs
    9
    SELECT SQL_CALC_FOUND_ROWS
    tbl_catalog_categories_product.id,
    tbl_catalog_categories_product.name_de 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 
    171μs
    10
    SELECT FOUND_ROWS() AS totrow
    96μs
    11
    SELECT SQL_CALC_FOUND_ROWS
    tbl_pages.url,
    tbl_pages.id,
    tbl_pages.title_de AS title,
    tbl_pages.excerpt_de AS excerpt,
    tbl_pages.content_de AS content,
    tbl_pages.meta_title_de AS meta_title,
    tbl_pages.meta_keywords_de AS meta_keywords,
    tbl_pages.meta_description_de 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 
    172μs
    12
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 00:35:58' AND to_date > '2024-12-23 00:35:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    117μs
    13
    SELECT FOUND_ROWS() AS totrow
    100μs
    14
    SELECT SQL_CALC_FOUND_ROWS
    tp.code_master AS code,
    tpd.name_de AS name,
    tpd.title_de AS title,
    tpd.excerpt_de AS excerpt,
    tpd.description_de 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_de AS family_name,
    tfp.name_it AS family_name_default,
    tp.season_code,
    tp.gender_code,
    tpd.meta_title_de AS meta_title,
    tpd.meta_keywords_de AS meta_keywords,
    tpd.meta_description_de 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_de AS label_variant1,
    tctp.label_variant2_de 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 = "1210050"
    GROUP BY
    tp.code_master
    ORDER BY
    tpd.sorting asc
    LIMIT 0, 1 
    1.75ms
    15
    SELECT FOUND_ROWS() AS totrow
    141μ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 ('1210050023000A')
    ORDER BY
    tbl_products_images.sorting ASC
    
    261μs
    17
    SELECT SQL_CALC_FOUND_ROWS
    tp.code_master,
    tqfp.id,
    tqfp.image,
    tqfp.color,
    tqfp.name_de 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 ("1210050")
    GROUP BY
    tp.code_master,tqfp.id
    ORDER BY
    tqfp.sorting asc,tqfp.id asc 
    1.01ms
    18
    SELECT FOUND_ROWS() AS totrow
    133μ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_de AS title,
    tbl_products_descriptions_highlights.title_it AS title_default,
    tbl_products_descriptions_highlights.excerpt_de 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 ("1210050")
    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 
    693μs
    20
    SELECT FOUND_ROWS() AS totrow
    149μs
    21
    SELECT SQL_CALC_FOUND_ROWS
    tp.code_master,
    tp.color_code,
    tszp.code,
    tszp.name_de 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 ("1210050") AND tp.enabled = 1
    GROUP BY
    tp.code
    ORDER BY
    tszp.sorting asc,tszp.id asc 
    677μs
    22
    SELECT FOUND_ROWS() AS totrow
    142μs
    23
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 00:35:58' AND to_date > '2024-12-23 00:35:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    124μs
    24
    SELECT FOUND_ROWS() AS totrow
    98μs
    25
    SELECT SQL_CALC_FOUND_ROWS
    tp.id,
    tp.code,
    tp.code_master,
    tp.color_code,
    tcp.name_de AS color_name,
    tcp.name_it AS color_name_default,
    tpd.name_de,
    tpd.name_it AS name_default,
    tp.size,
    tszp.name_de 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 ("1210050")
    GROUP BY
    tp.code
    ORDER BY
    tp.color_code asc,tszp.sorting asc 
    5.39ms
    26
    SELECT FOUND_ROWS() AS totrow
    142μ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 ('1210050023000A','1210050029000A','1210050033000A','1210050038000A','1210050045000A')
    ORDER BY
    tbl_products_images.sorting ASC
    
    250μs
    28
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 00:35:58' AND to_date > '2024-12-23 00:35:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    507μs
    29
    SELECT FOUND_ROWS() AS totrow
    260μ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 = '1210050'
    GROUP BY
    tpcct.category_id
    )
    
    207μs
    31
    SELECT FOUND_ROWS() AS totrow
    163μs
    32
    SELECT SQL_CALC_FOUND_ROWS
    tbl_catalog_categories_product.id,
    tbl_catalog_categories_product.name_de 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(152,158)
    ORDER BY
    tbl_catalog_categories_product.sorting asc 
    161μs
    33
    SELECT FOUND_ROWS() AS totrow
    137μs
    34
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 00:35:58' AND to_date > '2024-12-23 00:35:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    177μs
    35
    SELECT FOUND_ROWS() AS totrow
    149μs
    36
    SELECT SQL_CALC_FOUND_ROWS
    tp.code_master AS code,
    tpd.name_de AS name,
    tpd.title_de AS title,
    tpd.excerpt_de AS excerpt,
    tpd.description_de 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_de AS family_name,
    tfp.name_it AS family_name_default,
    tp.season_code,
    tp.gender_code,
    tpd.meta_title_de AS meta_title,
    tpd.meta_keywords_de AS meta_keywords,
    tpd.meta_description_de 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_de AS label_variant1,
    tctp.label_variant2_de 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 = '1210050'
    GROUP BY
    tp.code_master
    ORDER BY
    tpd.sorting asc 
    2.06ms
    37
    SELECT FOUND_ROWS() AS totrow
    185μs
    38
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 00:35:58' AND to_date > '2024-12-23 00:35:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    148μs
    39
    SELECT FOUND_ROWS() AS totrow
    129μs
    40
    SELECT SQL_CALC_FOUND_ROWS
    tp.id,
    tp.code,
    tp.code_master,
    tp.color_code,
    tcp.name_de AS color_name,
    tcp.name_it AS color_name_default,
    tpd.name_de,
    tpd.name_it AS name_default,
    tp.size,
    tszp.name_de 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 <= 213 and tcctp.nleft >= 212
    GROUP BY
    tp.code
    ORDER BY
    tp.color_code asc,tszp.sorting asc 
    2.6ms
    41
    SELECT FOUND_ROWS() AS totrow
    162μs
    42
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 00:35:58' AND to_date > '2024-12-23 00:35:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    150μs
    43
    SELECT FOUND_ROWS() AS totrow
    128μs
    44
    SELECT SQL_CALC_FOUND_ROWS
    tp.code_master AS code,
    tpd.name_de AS name,
    tpd.title_de AS title,
    tpd.excerpt_de AS excerpt,
    tpd.description_de 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_de AS family_name,
    tfp.name_it AS family_name_default,
    tp.season_code,
    tp.gender_code,
    tpd.meta_title_de AS meta_title,
    tpd.meta_keywords_de AS meta_keywords,
    tpd.meta_description_de 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_de AS label_variant1,
    tctp.label_variant2_de 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 <= 213 and tcctp.nleft >= 212 AND tp.code_master != '1210050'
    GROUP BY
    tp.code_master
    ORDER BY
    RAND() asc
    LIMIT 0, 4 
    104ms
    45
    SELECT FOUND_ROWS() AS totrow
    342μ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 ('7210005023000A','1210051013000A','1210042017000A','1210041023000A')
    ORDER BY
    tbl_products_images.sorting ASC
    
    1.5ms
    47
    SELECT SQL_CALC_FOUND_ROWS
    tp.code_master,
    tp.color_code,
    tszp.code,
    tszp.name_de 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 ("7210005","1210051","1210042","1210041") AND tp.enabled = 1
    GROUP BY
    tp.code
    ORDER BY
    tszp.sorting asc,tszp.id asc 
    1.05ms
    48
    SELECT FOUND_ROWS() AS totrow
    168μs
    49
    SELECT SQL_CALC_FOUND_ROWS
    tbl_exclusions.* FROM tbl_exclusions
    WHERE enabled = 1 AND from_date < '2024-12-23 00:35:58' AND to_date > '2024-12-23 00:35:58' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
    company_code = 1
    
    158μs
    50
    SELECT FOUND_ROWS() AS totrow
    114μs
    51
    SELECT SQL_CALC_FOUND_ROWS
    tp.id,
    tp.code,
    tp.code_master,
    tp.color_code,
    tcp.name_de AS color_name,
    tcp.name_it AS color_name_default,
    tpd.name_de,
    tpd.name_it AS name_default,
    tp.size,
    tszp.name_de 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 ("7210005","1210051","1210042","1210041") AND tcctp.nright <= 213 and tcctp.nleft >= 212
    GROUP BY
    tp.code
    ORDER BY
    tp.color_code asc,tszp.sorting asc 
    9.85ms
    52
    SELECT FOUND_ROWS() AS totrow
    233μ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 ('1210051013000A','1210042017000A','1210051017000A','1210051023000A','1210041023000A','1210042023000A','1210051029000A','1210041029000A','1210042029000A','1210042033000A','1210041033000A','1210051033000A','1210042038000A','1210041038000A','1210051038000A','1210041045000A','7210005029000A','7210005023000A','7210005038000A','7210005033000A')
    ORDER BY
    tbl_products_images.sorting ASC
    
    3.34ms
    54
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_de AS translate FROM tbl_dictionary
    WHERE
    slug = "68cb97e86fabb3cc85d81e5d09089d31" and scope is null
    LIMIT 0, 1 
    230μs
    55
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_de AS translate FROM tbl_dictionary
    WHERE
    slug = "c44a1a3420df56fe335fab4668d57c90" and scope is null
    LIMIT 0, 1 
    139μs
    56
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_de AS translate FROM tbl_dictionary
    WHERE
    slug = "9ce416335987b4dfdc083db1fde250e2" and scope is null
    LIMIT 0, 1 
    122μs
    57
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_de AS translate FROM tbl_dictionary
    WHERE
    slug = "ff6fbc0f84e2abc908206014316f0b99" and scope is null
    LIMIT 0, 1 
    154μs
    58
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_de AS translate FROM tbl_dictionary
    WHERE
    slug = "1113fca866539d319db4413175dc1bd1" and scope is null
    LIMIT 0, 1 
    116μs
    59
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.translate_de AS translate FROM tbl_dictionary
    WHERE
    slug = "0a0b6f3f2fb36e77b9788457562b95e0" and scope is null
    LIMIT 0, 1 
    113μs
    60
    SELECT SQL_CALC_FOUND_ROWS
    tbl_dictionary.string,
    tbl_dictionary.translate_de AS translate FROM tbl_dictionary
    WHERE ifnull(scope,'') = ""
    
    391μs
    61
    SELECT FOUND_ROWS() AS totrow
    191μs
    Totale145ms