Thé en filtres rouge Rooibos 20 filtres

Thé en filtres rouge Rooibos 20 filtres
Thé en filtres rouge Rooibos 20 filtres Thé en filtres rouge Rooibos 20 filtres Thé en filtres rouge Rooibos 20 filtres Thé en filtres rouge Rooibos 20 filtres Thé en filtres rouge Rooibos 20 filtres (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2022-05-23 12:45:17 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.057256937027 236 0.1583 0


No Amazon API Requests Made.

Total time 1.057256937027 seconds

Number Time From Start Name Description
1 0.64937996864319 Initialise Initialise FSB Function
2 0.651939868927 App Controller Start Start of the App controller (called before the controller of every page)
3 0.65593099594116 Start of getCategoryListByGroup Function Before first category groups query
4 0.65631794929504 After initial query Before first category groups query
5 0.65632081031799 Get Category List for Group Before the call to getCategoryList function
6 0.65632486343384 Start of GetCategoryList function Start of the function
7 0.65633082389832 Before getting categories Query to get specific category list
8 0.65679597854614 After getting categories Query to get specific category list
9 0.65679883956909 Before getting category custom Before call to function getCategoryCustom
10 0.67957282066345 After getting category custom After call to function getCategoryCustom
11 0.67957901954651 Before getting category custom Before call to function getCategoryCustom
12 0.69189882278442 After getting category custom After call to function getCategoryCustom
13 0.6919310092926 Before getting category custom Before call to function getCategoryCustom
14 0.69762682914734 After getting category custom After call to function getCategoryCustom
15 0.69763088226318 Before getting category custom Before call to function getCategoryCustom
16 0.70273303985596 After getting category custom After call to function getCategoryCustom
17 0.70273685455322 Before getting category custom Before call to function getCategoryCustom
18 0.70580196380615 After getting category custom After call to function getCategoryCustom
19 0.705806016922 Before getting category custom Before call to function getCategoryCustom
20 0.70884203910828 After getting category custom After call to function getCategoryCustom
21 0.70884490013123 End of GetCategoryList function End of the function
22 0.70885682106018 End of getCategoryListByGroup Function Before return()
23 0.72979283332825 App Controller End End of the App controller (called before the controller of every page)
24 0.73061585426331 Product Start Start of the product info controller
25 0.75266098976135 Cache file not found Starting get product details
26 0.78260397911072 Related products Start getting related products if enabled
27 0.78260684013367 Related Products Start Before the related products are found
28 0.78260803222656 Related Products Keywords Before the related product keywords are found
29 0.78261590003967 Create Keyword List Function Start of function
30 0.78273582458496 Create Keyword List Function After looping provided content - 15 keywords found
31 0.7836709022522 Create Keyword List Function After looping initial keyword list - 14 keywords remaining
32 0.78368091583252 Create Keyword List Function After reducing keyword list
33 0.78372502326965 Create Keyword List Function After selecting by scoring keywords
34 0.78373098373413 Create Keyword List Function After final loop of keywords
35 0.78373384475708 Related Products Keywords After the related product keywords are found
36 0.80189085006714 Related Products End After the related products are found
37 0.81062698364258 Product End End of the product info controller (Product Info)
38 0.81909894943237 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.81977987289429 Before Get Options Before the call to getOptions in the tpl class
40 0.8547580242157 After Get Options After the call to getOptions in the tpl class
41 0.85495495796204 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.85499787330627 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.95380187034607 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.95380902290344 Product Info: Before Template Display Before the template is displayed
45 1.0572128295898 Product Info: After Template Display After the template is displayed
46 1.0572328567505 Finalizing debug Before the debug is output to the page.
47 1.0572559833527 End of App This is the end of the app logging, final timestamp


Query Debug - 236 Database Queries. Total time 0.1583 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.0007779598236084
SELECT parameter, value FROM parameters
2 0.0010 0.00098705291748047
SELECT * FROM `bad_bots`
3 0.0004 0.00042414665222168
SET time_zone = 'Europe/London'
4 0.0005 0.00048494338989258
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0023 0.0022759437561035
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"44.192.25.113\";}'
6 0.0014 0.0014448165893555
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653698755'
7 0.0012 0.0011558532714844
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00054407119750977
UPDATE autorun SET lastrun = '2022-05-28 00:45:55' WHERE id = '16'
9 0.0004 0.0003969669342041
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0007 0.00067996978759766
SELECT id FROM pages WHERE pagename = 'the-en-filtres-rouge-rooibos-20filtres' LIMIT 1
11 0.0006 0.00056791305541992
SELECT id FROM products WHERE pagename = 'the-en-filtres-rouge-rooibos-20filtres' AND hidden = 0 LIMIT 1
12 0.0014 0.0014288425445557
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
13 0.0011 0.0011439323425293
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
14 0.0006 0.00059700012207031
SELECT * FROM pages WHERE pagename = 'the-en-filtres-rouge-rooibos-20filtres'
15 0.0004 0.00036907196044922
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0004 0.00043606758117676
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0088 0.0087840557098389
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0004 0.00042486190795898
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0004 0.00037193298339844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00044512748718262
SELECT id FROM categories WHERE parent_id = '26'
21 0.0108 0.010802030563354
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0004 0.00039386749267578
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0005 0.00047397613525391
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0004 0.00041103363037109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.00043606758117676
SELECT * FROM categorygroups WHERE id = '1'
26 0.0058 0.0058438777923584
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0002 0.00023984909057617
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0002 0.00023818016052246
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0002 0.00024199485778809
SELECT id FROM categories WHERE parent_id = '27'
30 0.0045 0.0044600963592529
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0003 0.00032401084899902
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0003 0.00034904479980469
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0002 0.00021886825561523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0002 0.00022411346435547
SELECT * FROM categorygroups WHERE id = '1'
35 0.0018 0.0018489360809326
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0004 0.00040006637573242
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0003 0.00029087066650391
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0002 0.0002129077911377
SELECT id FROM categories WHERE parent_id = '28'
39 0.0017 0.0017271041870117
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0004 0.00039410591125488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0002 0.00023293495178223
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0002 0.00021600723266602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0002 0.00023198127746582
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00059914588928223
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0003 0.00031518936157227
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0005 0.00045514106750488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00045394897460938
SELECT id FROM categories WHERE parent_id = '29'
48 0.0010 0.00097799301147461
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0006 0.00059700012207031
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0004 0.00039315223693848
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0006 0.00056982040405273
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0006 0.00059294700622559
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.0006110668182373
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0003 0.00025701522827148
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0002 0.000244140625
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0002 0.00023984909057617
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.00061917304992676
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0003 0.00026607513427734
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0002 0.00024199485778809
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0002 0.00021219253540039
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0002 0.00021195411682129
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00057721138000488
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0003 0.00031900405883789
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0002 0.00022721290588379
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00061988830566406
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0003 0.00025606155395508
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0002 0.00023794174194336
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0002 0.00022292137145996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0002 0.0002131462097168
SELECT * FROM categorygroups WHERE id = '1'
71 0.0003 0.00025081634521484
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0003 0.00029516220092773
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00055813789367676
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0005 0.00047802925109863
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0009 0.00087118148803711
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0009 0.00087094306945801
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0004 0.00037097930908203
SELECT * FROM ipgeocountries WHERE INET_ATON('44.192.25.113') >= INET_ATON(ip_start) AND INET_ATON('44.192.25.113') <= INET_ATON(ip_end)
78 0.0004 0.0003669261932373
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0003 0.0003359317779541
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00079798698425293
SELECT * FROM products WHERE pagename = 'the-en-filtres-rouge-rooibos-20filtres'
81 0.0008 0.00076413154602051
UPDATE products SET viewcount = viewcount + 1 WHERE id = 883
82 0.0010 0.00095891952514648
SELECT * FROM manufacturers WHERE id = '237'
83 0.0008 0.00084900856018066
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '237'
84 0.0005 0.00054788589477539
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '237' LIMIT 1
85 0.0009 0.00087809562683105
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '237' ORDER BY RAND() LIMIT 1
86 0.0018 0.0018348693847656
SELECT * FROM productimages WHERE product_id = '883' ORDER BY sortorder ASC
87 0.0003 0.00025105476379395
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '237'
88 0.0007 0.00073909759521484
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '237'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0005 0.00050902366638184
SELECT * FROM manufacturerimages WHERE manufacturer_id = '237'
90 0.0005 0.00045990943908691
SELECT category_id FROM products_categories WHERE product_id = '883'
91 0.0004 0.00036787986755371
SELECT * FROM categories WHERE id = '27'
92 0.0066 0.0065882205963135
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
93 0.0004 0.00035691261291504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00037384033203125
SELECT id FROM categories WHERE parent_id = '27'
95 0.0047 0.004680871963501
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
96 0.0003 0.0003049373626709
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
97 0.0002 0.00023198127746582
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0002 0.00019097328186035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0002 0.000244140625
SELECT * FROM productimages WHERE product_id = '883' ORDER BY sortorder ASC
100 0.0004 0.00039887428283691
SELECT * FROM product_image_select WHERE product_id = '883'
101 0.0004 0.00040984153747559
SELECT * FROM productcustomimages WHERE product_id = '883'
102 0.0005 0.00050210952758789
SELECT * FROM productfeeds WHERE product_id = '883' ORDER BY item_date DESC
103 0.0018 0.0018100738525391
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0007 0.00072717666625977
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '883' AND t.hidden = 0 AND display_product = 1
105 0.0005 0.00050997734069824
SELECT * FROM productamazoncontent WHERE product_id = '883'
106 0.0012 0.0012140274047852
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname
107 0.0006 0.00058603286743164
SELECT * FROM productoffers WHERE product_id = '883' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0005 0.00048112869262695
SELECT * FROM productoffers
                WHERE product_id = '883' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0006 0.00057291984558105
SELECT * FROM productoffers
                WHERE product_id = 883
                ORDER BY price ASC LIMIT 1
110 0.0005 0.0005488395690918
SELECT value FROM productattributes
                WHERE product_id = '883'
                AND name = 'ListPriceAmount'
111 0.0005 0.00054812431335449
SELECT value FROM productattributes WHERE product_id = '883' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0003 0.00029706954956055
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
113 0.0083 0.008328914642334
SELECT *, MATCH (description, title) AGAINST ('rouge rooibos 20filtres' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rouge rooibos 20filtres' IN BOOLEAN MODE) AND 883 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
114 0.0008 0.00080394744873047
SELECT *, MATCH (description, title) AGAINST ('rouge rooibos 20filtres' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rouge rooibos 20filtres' IN BOOLEAN MODE) AND 883 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0008 0.00082516670227051
SELECT *, MATCH (description, title) AGAINST ('rouge rooibos 20filtres' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rouge rooibos 20filtres' IN BOOLEAN MODE) AND 883 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
116 0.0005 0.00052809715270996
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
117 0.0003 0.00030803680419922
SELECT * FROM product_image_select WHERE product_id = '858'
118 0.0003 0.00026416778564453
SELECT * FROM productcustomimages WHERE product_id = '858'
119 0.0003 0.00030684471130371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
120 0.0004 0.0003669261932373
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0004 0.00042104721069336
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0003 0.00028395652770996
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0004 0.00041699409484863
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
124 0.0004 0.0004270076751709
SELECT * FROM product_image_select WHERE product_id = '878'
125 0.0003 0.00025105476379395
SELECT * FROM productcustomimages WHERE product_id = '878'
126 0.0003 0.00031709671020508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
127 0.0004 0.00037193298339844
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0004 0.00041007995605469
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0002 0.00021195411682129
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0003 0.00031900405883789
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
131 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '862'
132 0.0002 0.00023102760314941
SELECT * FROM productcustomimages WHERE product_id = '862'
133 0.0004 0.00039196014404297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
134 0.0004 0.00036406517028809
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0004 0.00043797492980957
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0002 0.00021791458129883
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0003 0.00034594535827637
SELECT id,asin FROM products WHERE parent_id = 883
138 0.0003 0.00026488304138184
SELECT category_id FROM products_categories WHERE product_id = '883'
139 0.0002 0.0002439022064209
SELECT * FROM categories WHERE id = '27'
140 0.0002 0.00021982192993164
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
141 0.0002 0.00020694732666016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
142 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '27'
143 0.0002 0.00020408630371094
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
144 0.0002 0.00021600723266602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
145 0.0002 0.00023198127746582
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
146 0.0002 0.00022196769714355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
147 0.0002 0.00020003318786621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname
148 0.0002 0.00020885467529297
SELECT * FROM productoffers WHERE product_id = '883' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0002 0.00022387504577637
SELECT * FROM productoffers
                WHERE product_id = '883' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = 883
                ORDER BY price ASC LIMIT 1
151 0.0002 0.00020408630371094
SELECT value FROM productattributes
                WHERE product_id = '883'
                AND name = 'ListPriceAmount'
152 0.0006 0.00060415267944336
SELECT * FROM products WHERE id = '883'
153 0.0002 0.00024199485778809
SELECT value FROM productattributes WHERE product_id = '883' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0003 0.0002589225769043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname
155 0.0003 0.0002601146697998
SELECT * FROM productoffers WHERE product_id = '883' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0003 0.00029587745666504
SELECT * FROM productoffers
                WHERE product_id = '883' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0003 0.00025105476379395
SELECT * FROM productoffers
                WHERE product_id = 883
                ORDER BY price ASC LIMIT 1
158 0.0003 0.00030207633972168
SELECT value FROM productattributes
                WHERE product_id = '883'
                AND name = 'ListPriceAmount'
159 0.0004 0.00036501884460449
SELECT category_id FROM products_categories WHERE product_id = '883' AND prod_type = 'amz'
160 0.0002 0.0002448558807373
SELECT parent_id FROM categories WHERE id = '27'
161 0.0002 0.00023508071899414
SELECT * FROM categories WHERE id = '27'
162 0.0002 0.00020122528076172
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
163 0.0003 0.00026702880859375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
164 0.0002 0.00022506713867188
SELECT id FROM categories WHERE parent_id = '27'
165 0.0002 0.00023984909057617
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
166 0.0002 0.00024700164794922
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
167 0.0003 0.00026106834411621
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
168 0.0003 0.0002598762512207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
169 0.0005 0.00049400329589844
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
170 0.0004 0.00036096572875977
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
171 0.0002 0.00019407272338867
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
172 0.0004 0.00037813186645508
SELECT * FROM pages WHERE id = 38
173 0.0051 0.0050508975982666
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
174 0.0005 0.00049495697021484
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1653698756;s:8:\"products\";a:6:{i:0;s:10:\"788|amazon\";i:1;s:10:\"787|amazon\";i:2;s:11:\"1287|amazon\";i:3;s:10:\"780|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
175 0.0006 0.0005800724029541
SELECT * FROM products WHERE id = 788
176 0.0008 0.00075578689575195
SELECT * FROM products WHERE id = 787
177 0.0008 0.0007779598236084
SELECT * FROM products WHERE id = 1287
178 0.0007 0.00066781044006348
SELECT * FROM products WHERE id = 780
179 0.0007 0.00070786476135254
SELECT * FROM products WHERE id = 777
180 0.0006 0.00064396858215332
SELECT * FROM products WHERE id = 776
181 0.0007 0.00073409080505371
SELECT * FROM products WHERE id = '788'
182 0.0003 0.00030303001403809
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
183 0.0003 0.00025486946105957
SELECT * FROM product_image_select WHERE product_id = '788'
184 0.0002 0.00021696090698242
SELECT * FROM productcustomimages WHERE product_id = '788'
185 0.0003 0.00025200843811035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
186 0.0005 0.00050091743469238
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0005 0.00047993659973145
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0002 0.0002288818359375
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0006 0.00062394142150879
SELECT * FROM products WHERE id = '787'
190 0.0003 0.00034284591674805
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
191 0.0003 0.00032186508178711
SELECT * FROM product_image_select WHERE product_id = '787'
192 0.0003 0.00030303001403809
SELECT * FROM productcustomimages WHERE product_id = '787'
193 0.0003 0.00027608871459961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
194 0.0005 0.00050210952758789
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0006 0.00060892105102539
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0002 0.00024890899658203
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0006 0.00059103965759277
SELECT * FROM products WHERE id = '1287'
198 0.0005 0.00052309036254883
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
199 0.0003 0.00029206275939941
SELECT * FROM product_image_select WHERE product_id = '1287'
200 0.0004 0.00035715103149414
SELECT * FROM productcustomimages WHERE product_id = '1287'
201 0.0004 0.00035691261291504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
202 0.0005 0.00052905082702637
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0005 0.00049805641174316
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0002 0.00019001960754395
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0005 0.00046300888061523
SELECT * FROM products WHERE id = '780'
206 0.0003 0.0002748966217041
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
207 0.0002 0.00024008750915527
SELECT * FROM product_image_select WHERE product_id = '780'
208 0.0003 0.00025820732116699
SELECT * FROM productcustomimages WHERE product_id = '780'
209 0.0003 0.00033998489379883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
210 0.0003 0.00033211708068848
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0003 0.00033712387084961
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0003 0.00029110908508301
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0004 0.00040912628173828
SELECT * FROM products WHERE id = '777'
214 0.0004 0.00037717819213867
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
215 0.0003 0.00025796890258789
SELECT * FROM product_image_select WHERE product_id = '777'
216 0.0002 0.00024604797363281
SELECT * FROM productcustomimages WHERE product_id = '777'
217 0.0004 0.00037193298339844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
218 0.0005 0.00047898292541504
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0006 0.00058603286743164
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0003 0.0003058910369873
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0006 0.00057291984558105
SELECT * FROM products WHERE id = '776'
222 0.0003 0.00029993057250977
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
223 0.0003 0.0002899169921875
SELECT * FROM product_image_select WHERE product_id = '776'
224 0.0004 0.00035786628723145
SELECT * FROM productcustomimages WHERE product_id = '776'
225 0.0003 0.00032401084899902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
226 0.0005 0.00048398971557617
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0005 0.00050806999206543
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0003 0.0002751350402832
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0004 0.00038599967956543
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
230 0.0005 0.00052714347839355
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
231 0.0008 0.00082588195800781
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
232 0.0005 0.00051593780517578
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0005 0.00051593780517578
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
234 0.0005 0.0005040168762207
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0004 0.00044679641723633
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
236 0.0005 0.00046205520629883
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'