Products

MeasuruesSize
Memory Usage16.34 MB
Load Time324ms
Server Variables
Array
(
    [USER] => u.webdevarea
    [HOME] => /var/www/vhosts/devb2b.seacsub.com
    [SCRIPT_NAME] => /index.php
    [REQUEST_URI] => /seacsub/159/pesca-subacquea-pinne
    [QUERY_STRING] => filename=catalog&cctc=159&cct=pesca-subacquea-pinne&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=159&cct=pesca-subacquea-pinne&shop=seacsub
    [REMOTE_PORT] => 38792
    [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] => 44.200.101.84
    [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 06:55:10 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] => 44.200.101.84
    [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/159/pesca-subacquea-pinne
    [SCRIPT_URL] => /seacsub/159/pesca-subacquea-pinne
    [QS_ConnectionId] => 16962489148379860130658
    [QS_AllConn] => 4
    [QS_SrvConn] => 4
    [GEOIP_COUNTRY_CODE] => US
    [MM_COUNTRY_NAME] => United States
    [MMDB_INFO] => result found
    [MMDB_ADDR] => 44.200.101.84
    [UNIQUE_ID] => ZRq0UpWvTQVaKUpyZv1R-wAAAMk
    [REDIRECT_STATUS] => 200
    [REDIRECT_HTTPS] => on
    [REDIRECT_PERL5LIB] => /usr/share/awstats/lib:/usr/share/awstats/plugins
    [REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/seacsub/159/pesca-subacquea-pinne
    [REDIRECT_SCRIPT_URL] => /seacsub/159/pesca-subacquea-pinne
    [REDIRECT_QS_ConnectionId] => 16962489148379860130658
    [REDIRECT_QS_AllConn] => 4
    [REDIRECT_QS_SrvConn] => 4
    [REDIRECT_GEOIP_COUNTRY_CODE] => US
    [REDIRECT_MM_COUNTRY_NAME] => United States
    [REDIRECT_MMDB_INFO] => result found
    [REDIRECT_MMDB_ADDR] => 44.200.101.84
    [REDIRECT_UNIQUE_ID] => ZRq0UpWvTQVaKUpyZv1R-wAAAMk
    [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/159/pesca-subacquea-pinne
    [REDIRECT_REDIRECT_SCRIPT_URL] => /seacsub/159/pesca-subacquea-pinne
    [REDIRECT_REDIRECT_QS_ConnectionId] => 16962489148379860130658
    [REDIRECT_REDIRECT_QS_AllConn] => 4
    [REDIRECT_REDIRECT_QS_SrvConn] => 4
    [REDIRECT_REDIRECT_GEOIP_COUNTRY_CODE] => US
    [REDIRECT_REDIRECT_MM_COUNTRY_NAME] => United States
    [REDIRECT_REDIRECT_MMDB_INFO] => result found
    [REDIRECT_REDIRECT_MMDB_ADDR] => 44.200.101.84
    [REDIRECT_REDIRECT_UNIQUE_ID] => ZRq0UpWvTQVaKUpyZv1R-wAAAMk
    [FCGI_ROLE] => RESPONDER
    [PHP_SELF] => /index.php
    [REQUEST_TIME_FLOAT] => 1696248914.848
    [REQUEST_TIME] => 1696248914
)
#QueryTime (sec)
0
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.*
FROM tbl_dictionary
1.66ms
1
SELECT FOUND_ROWS() AS totrow
231μ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 = '')
267μs
3
SELECT FOUND_ROWS() AS totrow
174μ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 
68.84ms
5
SELECT FOUND_ROWS() AS totrow
181μ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 
66.51ms
7
SELECT FOUND_ROWS() AS totrow
183μs
8
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:15:15' AND to_date > '2023-10-02 14:15:15' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
660μs
9
SELECT FOUND_ROWS() AS totrow
178μ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"%')
242μs
11
SELECT FOUND_ROWS() AS totrow
261μ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,47,47,47,47,47,47,58,58,58,58,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,58,58,58,58,58,58,58,58,58,2,4,5,6,7,10,11,13,14,20,26,48,49,50,51,52,55,59,60,61,62,143,144,145,146,147,148,149,150,151,153,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,171,173,175,176,177,178,180,181,182,183,184,185,186,187,188,189,190,195,197,218,220,221)
ORDER BY
tbl_catalog_categories_product.sorting asc 
283μs
13
SELECT FOUND_ROWS() AS totrow
175μ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 
285μs
15
SELECT FOUND_ROWS() AS totrow
183μ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 '%"159"%' 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 
850μs
17
SELECT FOUND_ROWS() AS totrow
185μs
18
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "801ab24683a4a8c433c6eb40c48bcd9d"
LIMIT 0, 1 
207μs
19
SELECT FOUND_ROWS() AS totrow
162μs
20
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "821b8ee6937cec96c30fdafbfe836d68"
LIMIT 0, 1 
149μs
21
SELECT FOUND_ROWS() AS totrow
162μs
22
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "389c43ba0718d1e10d62d855f0431bfb"
LIMIT 0, 1 
144μs
23
SELECT FOUND_ROWS() AS totrow
150μs
24
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "a922ea470f18bf50b53c239c5d5a414c"
LIMIT 0, 1 
142μs
25
SELECT FOUND_ROWS() AS totrow
149μs
26
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "9aa698f602b1e5694855cee73a683488"
LIMIT 0, 1 
167μs
27
SELECT FOUND_ROWS() AS totrow
148μs
28
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:15:15' AND to_date > '2023-10-02 14:15:15' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
205μs
29
SELECT FOUND_ROWS() AS totrow
157μ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,
MAX(tppl.discount1) AS discount1,
MAX(tppl.discount2) AS discount2,
MIN(tppl.price) AS original_price,
tppl.currency,
MIN(productPrice(tppl.price,tppl.discount1,tppl.discount2)) AS price,
tp.code AS product_image_code
FROM tbl_products tp
INNER JOIN tbl_products_descriptions tpd ON (tpd.product_code_master = tp.code_master) INNER JOIN tbl_families_product tfp ON (tp.family_code = tfp.code) INNER JOIN tbl_categories_product tctp ON (tp.category_code = tctp.code)
LEFT OUTER JOIN tbl_products_price_lists tppl ON (tppl.product_code = tp.code AND tppl.company_code = 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 <= 203 and tcctp.nleft >= 202
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc
LIMIT 0, 8 
12.77ms
31
SELECT FOUND_ROWS() AS totrow
217μ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 ('0730056520000A','0730058520452A','0710056520452A','0730059160000A','0710052529452A','0710052205452A','0710052217452A','0710025520452A')
ORDER BY
tbl_products_images.sorting ASC
289μs
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 ("0730056","0730058","0710056","0730059","710352","710152","710252","0710025") AND tp.enabled = 1
GROUP BY
tp.code
ORDER BY
tszp.sorting asc,tszp.id asc 
334μs
34
SELECT FOUND_ROWS() AS totrow
233μs
35
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:15:15' AND to_date > '2023-10-02 14:15:15' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
218μs
36
SELECT FOUND_ROWS() AS totrow
221μ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 ("0730056","0730058","0710056","0730059","710352","710152","710252","0710025") AND tcctp.nright <= 203 and tcctp.nleft >= 202
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc 
9.28ms
38
SELECT FOUND_ROWS() AS totrow
234μ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 ('0710052205452A','0710052205466A','0710052205476A','0710052205486A','0710052205496A','0710052205506A','0710052217452A','0710052217466A','0710052217476A','0710052217486A','0710052217496A','0710052217506A','0710025520452A','0710056520452A','0710056520466A','0710025520466A','0710056520476A','0710025520476A','0710056520486A','0710025520486A','0710056520496A','0710025520496A','0710056520506A','0710025520506A','0710052529452A','0710052529466A','0710052529476A','0710052529486A','0710052529496A','0710052529506A','0730059160000A','0730056520000A','0730058520452A','0730058520466A','0730058520476A','0730058520486A','0730058520496A','0730058520506A')
ORDER BY
tbl_products_images.sorting ASC
5.89ms
40
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:15:15' AND to_date > '2023-10-02 14:15:15' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
198μs
41
SELECT FOUND_ROWS() AS totrow
162μ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 <= 203 and tcctp.nleft >= 202 AND tszp.id IS NOT NULL AND tszp.type = 1
GROUP BY
tszp.name_it
ORDER BY
tszp.sorting asc 
3.23ms
43
SELECT FOUND_ROWS() AS totrow
167μs
44
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.*
FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2023-10-02 14:15:15' AND to_date > '2023-10-02 14:15:15' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
162μs
45
SELECT FOUND_ROWS() AS totrow
153μ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 <= 203 and tcctp.nleft >= 202 AND tgp.id IS NOT NULL
GROUP BY
tgp.id
ORDER BY
tgp.sorting asc 
5.27ms
47
SELECT FOUND_ROWS() AS totrow
167μs
48
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "068f80c7519d0528fb08e82137a72131"
LIMIT 0, 1 
174μs
49
SELECT FOUND_ROWS() AS totrow
207μs
50
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
171μs
51
SELECT FOUND_ROWS() AS totrow
172μs
52
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
180μs
53
SELECT FOUND_ROWS() AS totrow
158μs
54
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
180μs
55
SELECT FOUND_ROWS() AS totrow
170μs
56
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
156μs
57
SELECT FOUND_ROWS() AS totrow
152μs
58
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
152μs
59
SELECT FOUND_ROWS() AS totrow
151μs
60
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
169μs
61
SELECT FOUND_ROWS() AS totrow
150μs
62
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
152μs
63
SELECT FOUND_ROWS() AS totrow
150μs
64
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
160μs
65
SELECT FOUND_ROWS() AS totrow
159μs
66
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
166μs
67
SELECT FOUND_ROWS() AS totrow
150μs
68
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
152μs
69
SELECT FOUND_ROWS() AS totrow
150μs
70
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
155μs
71
SELECT FOUND_ROWS() AS totrow
150μs
72
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
153μs
73
SELECT FOUND_ROWS() AS totrow
161μs
74
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
169μs
75
SELECT FOUND_ROWS() AS totrow
152μs
76
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
160μs
77
SELECT FOUND_ROWS() AS totrow
151μs
78
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
187μs
79
SELECT FOUND_ROWS() AS totrow
154μs
80
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
153μs
81
SELECT FOUND_ROWS() AS totrow
149μs
82
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
164μs
83
SELECT FOUND_ROWS() AS totrow
167μs
84
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
153μs
85
SELECT FOUND_ROWS() AS totrow
150μs
86
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
153μs
87
SELECT FOUND_ROWS() AS totrow
149μs
88
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
188μs
89
SELECT FOUND_ROWS() AS totrow
175μs
90
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
171μs
91
SELECT FOUND_ROWS() AS totrow
159μs
92
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
176μs
93
SELECT FOUND_ROWS() AS totrow
155μs
94
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
155μs
95
SELECT FOUND_ROWS() AS totrow
151μs
96
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
155μs
97
SELECT FOUND_ROWS() AS totrow
168μs
98
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
185μs
99
SELECT FOUND_ROWS() AS totrow
153μs
100
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
158μs
101
SELECT FOUND_ROWS() AS totrow
152μs
102
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
168μs
103
SELECT FOUND_ROWS() AS totrow
154μs
104
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
154μs
105
SELECT FOUND_ROWS() AS totrow
151μs
106
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
183μs
107
SELECT FOUND_ROWS() AS totrow
151μs
108
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
153μs
109
SELECT FOUND_ROWS() AS totrow
149μs
110
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
154μs
111
SELECT FOUND_ROWS() AS totrow
166μs
112
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
154μs
113
SELECT FOUND_ROWS() AS totrow
151μs
114
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
178μs
115
SELECT FOUND_ROWS() AS totrow
169μs
116
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
197μs
117
SELECT FOUND_ROWS() AS totrow
193μs
118
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
158μs
119
SELECT FOUND_ROWS() AS totrow
152μs
120
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
159μs
121
SELECT FOUND_ROWS() AS totrow
152μs
122
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
154μs
123
SELECT FOUND_ROWS() AS totrow
150μs
124
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
WHERE
slag = "d41d8cd98f00b204e9800998ecf8427e"
LIMIT 0, 1 
152μs
125
SELECT FOUND_ROWS() AS totrow
167μs
126
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.string,
tbl_dictionary.translate_it AS translate
FROM tbl_dictionary
776μs
127
SELECT FOUND_ROWS() AS totrow
297μs
Totale196ms