Bestseller Products

Sélectionner une taille

EQUIPAGE 1000

Sélectionner une taille

PINNE BM30

Sélectionner une taille

TORCIA i50

Sélectionner une taille

ACTION

Sélectionner une taille

IT500

Sélectionner une taille

MODULAR

Sélectionner une taille

MAGICA L/XL

Sélectionner une taille

AJNA

Sélectionner une taille

SPACE 5 MM MAN

Sélectionner une taille

SPACE 5 MM LADY

Sélectionner une taille

SCREEN

Sélectionner une taille

COVER LADY 5mm

MeasuruesSize
Memory Usage20.15 MB
Load Time162ms
Server Variables
Array
(
    [USER] => u.webdevarea
    [HOME] => /var/www/vhosts/devb2b.seacsub.com
    [SCRIPT_NAME] => /index.php
    [REQUEST_URI] => /fr/
    [QUERY_STRING] => language=fr
    [REQUEST_METHOD] => GET
    [SERVER_PROTOCOL] => HTTP/1.0
    [GATEWAY_INTERFACE] => CGI/1.1
    [REDIRECT_QUERY_STRING] => language=fr
    [REDIRECT_URL] => /fr/
    [REMOTE_PORT] => 41954
    [SCRIPT_FILENAME] => /var/www/vhosts/devb2b.seacsub.com/httpdocs/index.php
    [SERVER_ADMIN] => [no address given]
    [CONTEXT_DOCUMENT_ROOT] => /var/www/vhosts/devb2b.seacsub.com/httpdocs
    [CONTEXT_PREFIX] => 
    [REQUEST_SCHEME] => https
    [DOCUMENT_ROOT] => /var/www/vhosts/devb2b.seacsub.com/httpdocs
    [REMOTE_ADDR] => 3.230.154.90
    [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] => Mon, 02 Oct 2023 10:43:37 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] => 3.230.154.90 [HTTP_HOST] => devb2b.seacsub.com [proxy-nokeepalive] => 1 [HTTPS] => on [SCRIPT_URI] => https://devb2b.seacsub.com/fr/ [SCRIPT_URL] => /fr/ [UNIQUE_ID] => ZlHrFjzJw5nOBjMpkz7KcAAAAAQ [REDIRECT_STATUS] => 200 [REDIRECT_HTTPS] => on [REDIRECT_SCRIPT_URI] => https://devb2b.seacsub.com/fr/ [REDIRECT_SCRIPT_URL] => /fr/ [REDIRECT_UNIQUE_ID] => ZlHrFjzJw5nOBjMpkz7KcAAAAAQ [FCGI_ROLE] => RESPONDER [PHP_SELF] => /index.php [REQUEST_TIME_FLOAT] => 1716644630.4824 [REQUEST_TIME] => 1716644630 )
#QueryTime (sec)
0
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.* FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
774μs
1
SELECT FOUND_ROWS() AS totrow
246μ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 = '')
938μs
3
SELECT FOUND_ROWS() AS totrow
158μs
4
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_fr AS translate FROM tbl_dictionary
WHERE
slug = "19ec5b589f66eb57230083177d6e5468" and scope is null
LIMIT 0, 1 
250μs
5
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-05-25 15:43:50' AND to_date > '2024-05-25 15:43:50' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
222μs
6
SELECT FOUND_ROWS() AS totrow
277μ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"%')
301μs
8
SELECT FOUND_ROWS() AS totrow
260μs
9
SELECT SQL_CALC_FOUND_ROWS
tbl_catalog_categories_product.id,
tbl_catalog_categories_product.name_fr 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 
246μs
10
SELECT FOUND_ROWS() AS totrow
164μs
11
SELECT SQL_CALC_FOUND_ROWS
tbl_pages.url,
tbl_pages.id,
tbl_pages.title_fr AS title,
tbl_pages.excerpt_fr AS excerpt,
tbl_pages.content_fr AS content,
tbl_pages.meta_title_fr AS meta_title,
tbl_pages.meta_keywords_fr AS meta_keywords,
tbl_pages.meta_description_fr 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 
1.09ms
12
SELECT SQL_CALC_FOUND_ROWS
tbl_banners.position,
tbl_banners.id,
tbl_banners.title_fr AS title,
tbl_banners.subtitle_fr AS subtitle,
tbl_banners.excerpt_fr AS excerpt,
tbl_banners.link_text_fr AS link_text,
tbl_banners.link_fr AS link,
tbl_banners.image_fr 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 
910μs
13
SELECT FOUND_ROWS() AS totrow
214μs
14
SELECT SQL_CALC_FOUND_ROWS
id_record, id, filename, path, thumbnail, tidy, title_fr AS title, text_fr AS text, link_fr AS link, link_text_fr AS link_text FROM tbl_banners_images
WHERE id_record IN(76)
ORDER BY tidy ASC
868μs
15
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-05-25 15:43:50' AND to_date > '2024-05-25 15:43:50' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
333μs
16
SELECT FOUND_ROWS() AS totrow
218μs
17
SELECT SQL_CALC_FOUND_ROWS
tp.code_master AS code,
tpd.name_fr AS name,
tpd.title_fr AS title,
tpd.excerpt_fr AS excerpt,
tpd.description_fr 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_fr AS family_name,
tfp.name_it AS family_name_default,
tp.season_code,
tp.gender_code,
tpd.meta_title_fr AS meta_title,
tpd.meta_keywords_fr AS meta_keywords,
tpd.meta_description_fr 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_fr AS label_variant1,
tctp.label_variant2_fr 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,
MAX(tp.new) AS new,
tp.product_name_fr 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 
3.37ms
18
SELECT FOUND_ROWS() AS totrow
158μ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 ('0840038001799A','0920024020000A','0750069003799A','0710056520486A','0500029020000A','1600005000520A','0350110000005A','0420037000998A','0750066003880A','0710043799050A','1700009020122A','0750067003120A','0010372250040A','0010372350025A','1600008000524A','0750065003538A','0010450350025A')
ORDER BY
tbl_products_images.sorting ASC
2.75ms
20
SELECT SQL_CALC_FOUND_ROWS
tbl_exclusions.* FROM tbl_exclusions
WHERE enabled = 1 AND from_date < '2024-05-25 15:43:50' AND to_date > '2024-05-25 15:43:50' AND (order_type = 1 OR order_type = "") AND (company_code = 1) AND
company_code = 1
194μs
21
SELECT FOUND_ROWS() AS totrow
172μs
22
SELECT SQL_CALC_FOUND_ROWS
tp.id,
tp.code,
tp.code_master,
tp.color_code,
tcp.name_fr AS color_name,
tcp.name_it AS color_name_default,
tpd.name_fr,
tpd.name_it AS name_default,
tp.size,
tszp.name_fr 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)
WHERE tfp.enabled = 1 AND tctp.enabled = 1 AND tp.enabled = 1 AND tppl_c.price > 0 AND code_master IN ("0840038","0920024","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 
29.51ms
23
SELECT FOUND_ROWS() AS totrow
194μ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','0350110000004A','0350110000005A','0010372250040A','0010372250060A','0010372250065A','0010372250055A','0010372250080A','0010372250105A','0010372250085A','0010372250125A','0010372250090A','0010372250145A','0010372350042A','0010372350041A','0010372350025A','0010450350025A','0010372350060A','0010372350040A','0010450350040A','0010450350055A','0010372350055A','0010372350065A','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','1600008000525A','0750067003160A','1600005000525A','0750067003720A','0750066003720A','0750065003538A','1600008000538A','0750065001164A','0750065001520A','0750066003520A','0750069003520A','0750067003520A','0750065003520A','0750069003525A','0750069003535A','0750069003536A','0750069003538A','0750069003799A','0750066003880A','0750066004529A','0750066004540A','0840038001160A','0840038001720A','0840038001799A','0840038003160A','0840038003422A','0840038003520A','0840038003720A','0840038003799A','0920024020000A','0750065003529A','1600005000524A','1600008000524A','0750067003120A','1700009020122A','1700009030162A','1700009030340A')
ORDER BY
tbl_products_images.sorting ASC
10.91ms
25
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_fr AS translate FROM tbl_dictionary
WHERE
slug = "26e2d291250a79cb9d62ae299ff7fffa" and scope is null
LIMIT 0, 1 
663μs
26
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_fr AS translate FROM tbl_dictionary
WHERE
slug = "68cb97e86fabb3cc85d81e5d09089d31" and scope is null
LIMIT 0, 1 
240μs
27
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_fr AS translate FROM tbl_dictionary
WHERE
slug = "c44a1a3420df56fe335fab4668d57c90" and scope is null
LIMIT 0, 1 
159μs
28
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_fr AS translate FROM tbl_dictionary
WHERE
slug = "9ce416335987b4dfdc083db1fde250e2" and scope is null
LIMIT 0, 1 
175μs
29
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_fr AS translate FROM tbl_dictionary
WHERE
slug = "ff6fbc0f84e2abc908206014316f0b99" and scope is null
LIMIT 0, 1 
189μs
30
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_fr AS translate FROM tbl_dictionary
WHERE
slug = "1113fca866539d319db4413175dc1bd1" and scope is null
LIMIT 0, 1 
153μs
31
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.translate_fr AS translate FROM tbl_dictionary
WHERE
slug = "0a0b6f3f2fb36e77b9788457562b95e0" and scope is null
LIMIT 0, 1 
175μs
32
SELECT SQL_CALC_FOUND_ROWS
tbl_dictionary.string,
tbl_dictionary.translate_fr AS translate FROM tbl_dictionary
WHERE ifnull(scope,'') = ""
429μs
33
SELECT FOUND_ROWS() AS totrow
197μs
Totale57.1ms