Products

Devi selezionare una taglia

FIRE

Devi selezionare una taglia

FIRE CAMO

Devi selezionare una taglia

TARGET

Devi selezionare una taglia

PREDA

Devi selezionare una taglia

PREDA HC

Devi selezionare una taglia

FUCILE ELASTICO HIT

Devi selezionare una taglia

NEW STING

Devi selezionare una taglia

FUCILE A MOLLA POLPONE

MeasuruesSize
Memory Usage20.21 MB
Load Time266ms
Server Variables
Array
(
    [USER] => u.webdevarea
    [HOME] => /var/www/vhosts/devb2b.seacsub.com
    [SCRIPT_NAME] => /index.php
    [REQUEST_URI] => /seacsub/158/pesca-subacquea-arbalete
    [QUERY_STRING] => filename=catalog&cctc=158&cct=pesca-subacquea-arbalete&shop=seacsub
    [REQUEST_METHOD] => GET
    [SERVER_PROTOCOL] => HTTP/1.0
    [GATEWAY_INTERFACE] => CGI/1.1
    [REDIRECT_URL] => /catalog.php
    [REDIRECT_QUERY_STRING] => filename=catalog&cctc=158&cct=pesca-subacquea-arbalete&shop=seacsub
    [REMOTE_PORT] => 42912
    [SCRIPT_FILENAME] => /var/www/vhosts/devb2b.seacsub.com/httpdocs/index.php
    [SERVER_ADMIN] => root@localhost
    [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.206.48.243
    [SERVER_PORT] => 443
    [SERVER_ADDR] => 80.211.158.51
    [SERVER_NAME] => devb2b.seacsub.com
    [SERVER_SOFTWARE] => Apache
    [SERVER_SIGNATURE] => 
    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
    [HTTP_ACCEPT_ENCODING] => br,gzip
    [HTTP_IF_MODIFIED_SINCE] => Fri, 24 Mar 2023 07:16:35 GMT
    [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    [HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/)
    [HTTP_CONNECTION] => close
    [HTTP_X_ACCEL_INTERNAL] => /internal-nginx-static-location
    [HTTP_X_REAL_IP] => 18.206.48.243
    [HTTP_HOST] => devb2b.seacsub.com
    [proxy-nokeepalive] => 1
    [HTTPS] => on
    [PERL5LIB] => /usr/share/awstats/lib:/usr/share/awstats/plugins
    [SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/158/pesca-subacquea-arbalete
    [SCRIPT_URL] => /seacsub/158/pesca-subacquea-arbalete
    [QS_ConnectionId] => 17014279143092029808639
    [QS_AllConn] => 1
    [QS_SrvConn] => 1
    [GEOIP_COUNTRY_CODE] => US
    [MM_COUNTRY_NAME] => United States
    [MMDB_INFO] => result found
    [MMDB_ADDR] => 18.206.48.243
    [UNIQUE_ID] => ZWm6ylDkiSfAQDf75lg6CgAAAMY
    [REDIRECT_STATUS] => 200
    [REDIRECT_HTTPS] => on
    [REDIRECT_PERL5LIB] => /usr/share/awstats/lib:/usr/share/awstats/plugins
    [REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/158/pesca-subacquea-arbalete
    [REDIRECT_SCRIPT_URL] => /seacsub/158/pesca-subacquea-arbalete
    [REDIRECT_QS_ConnectionId] => 17014279143092029808639
    [REDIRECT_QS_AllConn] => 1
    [REDIRECT_QS_SrvConn] => 1
    [REDIRECT_GEOIP_COUNTRY_CODE] => US
    [REDIRECT_MM_COUNTRY_NAME] => United States
    [REDIRECT_MMDB_INFO] => result found
    [REDIRECT_MMDB_ADDR] => 18.206.48.243
    [REDIRECT_UNIQUE_ID] => ZWm6ylDkiSfAQDf75lg6CgAAAMY
    [REDIRECT_REDIRECT_STATUS] => 200
    [REDIRECT_REDIRECT_HTTPS] => on
    [REDIRECT_REDIRECT_PERL5LIB] => /usr/share/awstats/lib:/usr/share/awstats/plugins
    [REDIRECT_REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/158/pesca-subacquea-arbalete
    [REDIRECT_REDIRECT_SCRIPT_URL] => /seacsub/158/pesca-subacquea-arbalete
    [REDIRECT_REDIRECT_QS_ConnectionId] => 17014279143092029808639
    [REDIRECT_REDIRECT_QS_AllConn] => 1
    [REDIRECT_REDIRECT_QS_SrvConn] => 1
    [REDIRECT_REDIRECT_GEOIP_COUNTRY_CODE] => US
    [REDIRECT_REDIRECT_MM_COUNTRY_NAME] => United States
    [REDIRECT_REDIRECT_MMDB_INFO] => result found
    [REDIRECT_REDIRECT_MMDB_ADDR] => 18.206.48.243
    [REDIRECT_REDIRECT_UNIQUE_ID] => ZWm6ylDkiSfAQDf75lg6CgAAAMY
    [FCGI_ROLE] => RESPONDER
    [PHP_SELF] => /index.php
    [REQUEST_TIME_FLOAT] => 1701427914.3156
    [REQUEST_TIME] => 1701427914
)
#QueryTime (sec)
0
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.*
FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
1.18ms
1
SELECT FOUND_ROWS() AS totrow
228μ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
281μs
4
SELECT SQL_CALC_FOUND_ROWS
tbl_products_price_lists.code,
tbl_products_price_lists.description,
tbl_products_price_lists.currency
FROM tbl_products_price_lists
WHERE company_code = 1
GROUP BY
tbl_products_price_lists.code
ORDER BY
FIELD(code, '01') desc, (ABS(code)) asc 
47.31ms
5
SELECT FOUND_ROWS() AS totrow
203μs
6
SELECT SQL_CALC_FOUND_ROWS
tbl_products_price_lists.code,
tbl_products_price_lists.description,
tbl_products_price_lists.currency
FROM tbl_products_price_lists
WHERE company_code = 1
GROUP BY
tbl_products_price_lists.code
ORDER BY
FIELD(code, '01') desc, (ABS(code)) asc 
47.51ms
7
SELECT FOUND_ROWS() AS totrow
214μs
8
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-12-01 11:51:54' AND to_date > '2023-12-01 11:51:54' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
624μs
9
SELECT FOUND_ROWS() AS totrow
185μs
10
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"%')
303μs
11
SELECT FOUND_ROWS() AS totrow
246μs
12
SELECT SQL_CALC_FOUND_ROWS
tbl_catalog_categories_product.id,
tbl_catalog_categories_product.name_it AS name,
tbl_catalog_categories_product.name_it AS name_default,
tbl_catalog_categories_product.nright,
tbl_catalog_categories_product.nleft,
tbl_catalog_categories_product.image,
tbl_catalog_categories_product.stages_category,
tbl_catalog_categories_product.parent_id AS parent
FROM tbl_catalog_categories_product
WHERE id in(1,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 
309μs
13
SELECT FOUND_ROWS() AS totrow
193μs
14
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 = "catalog.php" AND enabled = 1 AND
company_code in(0,1)
LIMIT 0, 1 
213μs
15
SELECT FOUND_ROWS() AS totrow
176μs
16
SELECT SQL_CALC_FOUND_ROWS
tbl_banners.position,
tbl_banners.id,
tbl_banners.title_it AS title,
tbl_banners.subtitle_it AS subtitle,
tbl_banners.excerpt_it AS excerpt,
tbl_banners.link_text_it AS link_text,
tbl_banners.link_it AS link,
tbl_banners.image_it AS image,
tbl_banners.icon,
tbl_banners.page_id,
tbl_banners.category_id,
tbl_banners.view_type,
tbl_banners.title_it AS title_default,
tbl_banners.subtitle_it AS subtitle_default,
tbl_banners.excerpt_it AS excerpt_default,
tbl_banners.link_text_it AS link_text_default,
tbl_banners.link_it AS link_default,
tbl_banners.image_it AS image_default
FROM tbl_banners
WHERE enabled = 1 AND (shop_code = "seacsub" OR shop_code = "") AND ( page_id LIKE '%"5"%' AND
(category_id LIKE '%"158"%' OR category_id LIKE '%"0"%') AND
(view_type LIKE '%"0"%' OR view_type LIKE '%"1"%')) AND
company_code in(0,1)
ORDER BY
tbl_banners.sorting asc 
765μs
17
SELECT FOUND_ROWS() AS totrow
184μs
18
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slug = "801ab24683a4a8c433c6eb40c48bcd9d" and scope is null
LIMIT 0, 1 
266μs
19
SELECT FOUND_ROWS() AS totrow
221μs
20
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slug = "821b8ee6937cec96c30fdafbfe836d68" and scope is null
LIMIT 0, 1 
215μs
21
SELECT FOUND_ROWS() AS totrow
210μs
22
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slug = "389c43ba0718d1e10d62d855f0431bfb" and scope is null
LIMIT 0, 1 
200μs
23
SELECT FOUND_ROWS() AS totrow
227μs
24
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slug = "a922ea470f18bf50b53c239c5d5a414c" and scope is null
LIMIT 0, 1 
202μs
25
SELECT FOUND_ROWS() AS totrow
208μs
26
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slug = "9aa698f602b1e5694855cee73a683488" and scope is null
LIMIT 0, 1 
200μs
27
SELECT FOUND_ROWS() AS totrow
225μs
28
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-12-01 11:51:54' AND to_date > '2023-12-01 11:51:54' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
260μs
29
SELECT FOUND_ROWS() AS totrow
217μs
30
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,
MIN(tppl.price) AS original_price,
tppl.currency,
MIN(productPrice(tppl.price,tppl.discount1,tppl.discount2)) AS price,
MAX(tp.featured) AS featured,
MAX(tp.featured2) AS featured2,
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
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc
LIMIT 0, 8 
5.21ms
31
SELECT FOUND_ROWS() AS totrow
200μs
32
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 ('1210041033000A','1210050045000A','1210042017000A','1210051013000A','1210054013000A','1210052007000A','1210014007000A','1210001013000A')
ORDER BY
tbl_products_images.sorting ASC
2.35ms
33
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 ("1210041","1210050","1210042","1210051","1210054","1210052","1210014","1210001") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc 
1.7ms
34
SELECT FOUND_ROWS() AS totrow
229μs
35
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-12-01 11:51:54' AND to_date > '2023-12-01 11:51:54' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
243μs
36
SELECT FOUND_ROWS() AS totrow
244μs
37
SELECT SQL_CALC_FOUND_ROWS
tp.id,
tp.code,
tp.code_master,
tp.color_code,
tcp.name_it AS color_name,
tcp.name_it AS color_name_default,
tpd.name_it,
tpd.name_it AS name_default,
tp.size,
tszp.name_it AS size_name,
tszp.name_it AS size_name_default,
tszp.sorting AS size_sorting,
(tpst.quantity - IFNULL(torr_stb.quantity,0)) AS availability,
tpst.availability_date,
(tpst.future_quantity - IFNULL(torr_stb.quantity,0)) AS future_availability,
tpst.coming_arrivals_quantity,
tpst.coming_arrivals_date,
tp.family_code,
tp.category_code,
tpd.line_code,
tp.season_code,
tp.gender_code,
tp.commercial_code,
tp.own_production,
tp.pack,
tppl.discount1 AS discount1,
tppl.discount2 AS discount2,
productPrice(tppl.price,tppl.discount1,tppl.discount2) AS price,
tppl.price AS original_price,
tp.hide_price,
tppl.currency,
tp.code AS product_image_code
FROM tbl_products tp
INNER JOIN tbl_products_descriptions tpd ON (tpd.product_code_master = tp.code_master) INNER JOIN tbl_families_product tfp ON (tp.family_code = tfp.code) INNER JOIN tbl_categories_product tctp ON (tp.category_code = tctp.code)
LEFT OUTER JOIN tbl_colors_product tcp ON (tp.color_code = tcp.code)
LEFT OUTER JOIN tbl_sizes_product tszp ON (tp.size = tszp.code)
LEFT OUTER JOIN tbl_products_price_lists tppl ON (tppl.product_code = tp.code AND tppl.company_code = 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 ("1210041","1210050","1210042","1210051","1210054","1210052","1210014","1210001") AND tcctp.nright <= 213 and tcctp.nleft >= 212
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc 
20.39ms
38
SELECT FOUND_ROWS() AS totrow
346μ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 ('1210052007000A','1210014007000A','1210014011000A','1210052011000A','1210054013000A','1210051013000A','1210001013000A','1210014015000A','1210052015000A','1210051017000A','1210042017000A','1210054017000A','1210052019000A','1210014019000A','1210051023000A','1210042023000A','1210052023000A','1210041023000A','1210050023000A','1210054023000A','1210014023000A','1210052027000A','1210014027000A','1210041029000A','1210050029000A','1210054029000A','1210051029000A','1210042029000A','1210041033000A','1210050033000A','1210054033000A','1210051033000A','1210042033000A','1210041038000A','1210050038000A','1210054038000A','1210051038000A','1210042038000A','1210041045000A','1210050045000A')
ORDER BY
tbl_products_images.sorting ASC
4.17ms
40
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-12-01 11:51:54' AND to_date > '2023-12-01 11:51:54' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
272μs
41
SELECT FOUND_ROWS() AS totrow
207μs
42
SELECT SQL_CALC_FOUND_ROWS
tszp.code,
tszp.name_it AS name,
tszp.name_it AS name_default
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_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_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 tszp.id IS NOT NULL AND tszp.type = 1
GROUP BY
tszp.name_it
ORDER BY
tszp.sorting asc 
2.01ms
43
SELECT FOUND_ROWS() AS totrow
205μs
44
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-12-01 11:51:54' AND to_date > '2023-12-01 11:51:54' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
183μs
45
SELECT FOUND_ROWS() AS totrow
192μs
46
SELECT SQL_CALC_FOUND_ROWS
tgp.code,
tgp.name_it AS name,
tgp.name_it AS name_default
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_genders_product tgp ON (tp.gender_code = tgp.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 tgp.id IS NOT NULL
GROUP BY
tgp.id
ORDER BY
tgp.sorting asc 
2.48ms
47
SELECT FOUND_ROWS() AS totrow
225μs
48
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slug = "068f80c7519d0528fb08e82137a72131" and scope is null
LIMIT 0, 1 
188μs
49
SELECT FOUND_ROWS() AS totrow
179μs
50
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slug = "68cb97e86fabb3cc85d81e5d09089d31" and scope is null
LIMIT 0, 1 
216μs
51
SELECT FOUND_ROWS() AS totrow
223μs
52
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slug = "c44a1a3420df56fe335fab4668d57c90" and scope is null
LIMIT 0, 1 
171μs
53
SELECT FOUND_ROWS() AS totrow
185μs
54
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slug = "9ce416335987b4dfdc083db1fde250e2" and scope is null
LIMIT 0, 1 
171μs
55
SELECT FOUND_ROWS() AS totrow
194μs
56
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.string,
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
592μs
57
SELECT FOUND_ROWS() AS totrow
195μs
Totale147ms