Bestseller Products

MeasuruesSize
Memory Usage20.08 MB
Load Time171ms
Server Variables
Array
(
    [USER] => u.webdevarea
    [HOME] => /var/www/vhosts/devb2b.seacsub.com
    [SCRIPT_NAME] => /index.php
    [REQUEST_URI] => /es/
    [QUERY_STRING] => language=es
    [REQUEST_METHOD] => GET
    [SERVER_PROTOCOL] => HTTP/1.0
    [GATEWAY_INTERFACE] => CGI/1.1
    [REDIRECT_QUERY_STRING] => language=es
    [REDIRECT_URL] => /es/
    [REMOTE_PORT] => 46072
    [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.97.14.86
    [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] => br,gzip [HTTP_IF_MODIFIED_SINCE] => Sat, 14 Sep 2024 14:03:39 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.97.14.86 [HTTP_HOST] => devb2b.seacsub.com [proxy-nokeepalive] => 1 [HTTPS] => on [SCRIPT_URI] => https://devb2b.seacsub.com/es/ [SCRIPT_URL] => /es/ [UNIQUE_ID] => Z1DLWQvMAMzozfyx5AYp1AAAAAM [REDIRECT_STATUS] => 200 [REDIRECT_HTTPS] => on [REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/es/ [REDIRECT_SCRIPT_URL] => /es/ [REDIRECT_UNIQUE_ID] => Z1DLWQvMAMzozfyx5AYp1AAAAAM [FCGI_ROLE] => RESPONDER [PHP_SELF] => /index.php [REQUEST_TIME_FLOAT] => 1733348185.7204 [REQUEST_TIME] => 1733348185 )
#QueryTime (sec)
0
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.* FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
1.61ms
1
SELECT FOUND_ROWS() AS totrow
397μ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.39ms
3
SELECT FOUND_ROWS() AS totrow
182μ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 
240μs
5
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-04 22:36:25' AND to_date > '2024-12-04 22:36:25' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
751μs
6
SELECT FOUND_ROWS() AS totrow
176μ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"%')
257μs
8
SELECT FOUND_ROWS() AS totrow
121μ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 
163μs
10
SELECT FOUND_ROWS() AS totrow
102μ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 = "index.php" AND enabled = 1 AND
company_code in(0,1)
LIMIT 0, 1 
714μs
12
SELECT SQL_CALC_FOUND_ROWS
tbl_banners.position,
tbl_banners.id,
tbl_banners.title_es AS title,
tbl_banners.subtitle_es AS subtitle,
tbl_banners.excerpt_es AS excerpt,
tbl_banners.link_text_es AS link_text,
tbl_banners.link_es AS link,
tbl_banners.image_es 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 '%"4"%' AND
(view_type LIKE '%"0"%' OR view_type LIKE '%"1"%')) AND
company_code in(0,1)
ORDER BY
tbl_banners.sorting asc 
835μs
13
SELECT FOUND_ROWS() AS totrow
137μs
14
SELECT SQL_CALC_FOUND_ROWS
id_record, id, filename, path, thumbnail, tidy, title_es AS title, text_es AS text, link_es AS link, link_text_es AS link_text FROM tbl_banners_images
WHERE id_record IN(76)
ORDER BY tidy ASC
528μs
15
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-04 22:36:25' AND to_date > '2024-12-04 22:36:25' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
374μs
16
SELECT FOUND_ROWS() AS totrow
198μs
17
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.product_name_es AS product_name,
tp.color_code,
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 best_seller = 1
GROUP BY
tp.code_master
ORDER BY
tpd.sorting asc 
4.78ms
18
SELECT FOUND_ROWS() AS totrow
176μs
19
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 ('0920024020000A','0840038001799A','0750069003799A','0710056520486A','0500029020000A','1600005000520A','0350110000005A','0420037000998A','0750066003880A','0710043799050A','1700009020122A','0750067003120A','0010372250040A','0010372350025A','1600008000524A','0750065003538A','0010450350025A')
ORDER BY
tbl_products_images.sorting ASC
2.83ms
20
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-12-04 22:36:25' AND to_date > '2024-12-04 22:36:25' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
204μs
21
SELECT FOUND_ROWS() AS totrow
146μs
22
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 ("0920024","0840038","0750069","0710056","0500029","1600005","0350110","0420037","0750066","0710043","1700009L","0750067","0010372M5","0010372L5","1600008","0750065","0010450L")
GROUP BY
tp.code
ORDER BY
tp.color_code asc,tszp.sorting asc 
30.63ms
23
SELECT FOUND_ROWS() AS totrow
210μs
24
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 ('0420037000998A','0350110000005A','0350110000004A','0010372250060A','0010372250040A','0010372250065A','0010372250055A','0010372250080A','0010372250105A','0010372250085A','0010372250090A','0010372250125A','0010372250145A','0010372350042A','0010372350041A','0010372350025A','0010450350025A','0010450350040A','0010372350040A','0010372350060A','0010372350055A','0010372350065A','0010450350055A','0010372350080A','0010450350080A','0010372350105A','0010450350105A','0010450350125A','0500029020000A','0710043120050A','0710043120070A','0710043120095A','0710043160050A','0710043160070A','0710043160095A','0710043360050A','0710043360070A','0710043360095A','1600005000520A','0710043520050A','0710043520070A','0710043520095A','0710056520452A','0710056520466A','0710056520476A','0710056520486A','0710056520496A','0710056520506A','0710056542452A','0710056542466A','0710056542476A','0710056542486A','0710056542496A','0710056542506A','0710043799050A','0710043799070A','0710043799095A','0750067003160A','1600005000525A','1600008000525A','0750065003538A','0750066003720A','1600008000538A','0750067003720A','0750065001164A','0750065001520A','0750069003520A','0750067003520A','0750065003520A','0750066003520A','0750069003525A','0750069003535A','0750069003536A','0750069003538A','0750069003799A','0750066003880A','0750066004529A','0750066004540A','0840038001160A','0840038001720A','0840038001799A','0840038003160A','0840038003422A','0840038003520A','0840038003720A','0840038003799A','0920024020000A','0750065003529A','1600008000524A','0750067003120A','1600005000524A','1700009020122A','1700009030162A','1700009030340A')
ORDER BY
tbl_products_images.sorting ASC
701μs
25
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "26e2d291250a79cb9d62ae299ff7fffa" and scope is null
LIMIT 0, 1 
651μs
26
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "68cb97e86fabb3cc85d81e5d09089d31" and scope is null
LIMIT 0, 1 
171μs
27
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "c44a1a3420df56fe335fab4668d57c90" and scope is null
LIMIT 0, 1 
97μs
28
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "9ce416335987b4dfdc083db1fde250e2" and scope is null
LIMIT 0, 1 
83μs
29
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "ff6fbc0f84e2abc908206014316f0b99" and scope is null
LIMIT 0, 1 
121μs
30
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "1113fca866539d319db4413175dc1bd1" and scope is null
LIMIT 0, 1 
93μs
31
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE
slug = "0a0b6f3f2fb36e77b9788457562b95e0" and scope is null
LIMIT 0, 1 
98μs
32
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.string,
tbl_dictionary.translate_es AS translate FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
342μs
33
SELECT FOUND_ROWS() AS totrow
155μs
Totale49.66ms