Pickwick Tea Blend Rooibos Honey, 20 Sachets de Thé

Pickwick Tea Blend Rooibos Honey, 20 Sachets de Thé
Pickwick Tea Blend Rooibos Honey, 20 Sachets de Thé Pickwick Tea Blend Rooibos Honey, 20 Sachets de Thé Pickwick Tea Blend Rooibos Honey, 20 Sachets de Thé (cliquez sur les images pour élargir)
€12,25
Le prix et la disponibilité du produit sont corrects en date du 2022-05-18 19:09:32 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
0.73769402503967 244 0.1922 0


No Amazon API Requests Made.

Total time 0.73769402503967 seconds

Number Time From Start Name Description
1 0.51605606079102 Initialise Initialise FSB Function
2 0.51800012588501 App Controller Start Start of the App controller (called before the controller of every page)
3 0.52147006988525 Start of getCategoryListByGroup Function Before first category groups query
4 0.52186799049377 After initial query Before first category groups query
5 0.52186989784241 Get Category List for Group Before the call to getCategoryList function
6 0.52187299728394 Start of GetCategoryList function Start of the function
7 0.52187609672546 Before getting categories Query to get specific category list
8 0.52231502532959 After getting categories Query to get specific category list
9 0.52231597900391 Before getting category custom Before call to function getCategoryCustom
10 0.54780912399292 After getting category custom After call to function getCategoryCustom
11 0.54781293869019 Before getting category custom Before call to function getCategoryCustom
12 0.56021904945374 After getting category custom After call to function getCategoryCustom
13 0.56022191047668 Before getting category custom Before call to function getCategoryCustom
14 0.56649589538574 After getting category custom After call to function getCategoryCustom
15 0.56649804115295 Before getting category custom Before call to function getCategoryCustom
16 0.57096791267395 After getting category custom After call to function getCategoryCustom
17 0.57097005844116 Before getting category custom Before call to function getCategoryCustom
18 0.57657194137573 After getting category custom After call to function getCategoryCustom
19 0.57657504081726 Before getting category custom Before call to function getCategoryCustom
20 0.58123898506165 After getting category custom After call to function getCategoryCustom
21 0.58124303817749 End of GetCategoryList function End of the function
22 0.58125400543213 End of getCategoryListByGroup Function Before return()
23 0.58632612228394 App Controller End End of the App controller (called before the controller of every page)
24 0.58641791343689 Product Start Start of the product info controller
25 0.58849096298218 Cache file not found Starting get product details
26 0.62345099449158 Related products Start getting related products if enabled
27 0.62345409393311 Related Products Start Before the related products are found
28 0.62345600128174 Related Products Keywords Before the related product keywords are found
29 0.6234610080719 Create Keyword List Function Start of function
30 0.62359690666199 Create Keyword List Function After looping provided content - 24 keywords found
31 0.62515091896057 Create Keyword List Function After looping initial keyword list - 21 keywords remaining
32 0.62516093254089 Create Keyword List Function After reducing keyword list
33 0.62527108192444 Create Keyword List Function After selecting by scoring keywords
34 0.62527704238892 Create Keyword List Function After final loop of keywords
35 0.62528109550476 Related Products Keywords After the related product keywords are found
36 0.65221500396729 Related Products End After the related products are found
37 0.66626405715942 Product End End of the product info controller (Product Info)
38 0.6669340133667 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.6677680015564 Before Get Options Before the call to getOptions in the tpl class
40 0.7097909450531 After Get Options After the call to getOptions in the tpl class
41 0.70992612838745 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.70995306968689 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.71714997291565 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.71715497970581 Product Info: Before Template Display Before the template is displayed
45 0.73766899108887 Product Info: After Template Display After the template is displayed
46 0.73767709732056 Finalizing debug Before the debug is output to the page.
47 0.73769307136536 End of App This is the end of the app logging, final timestamp


Query Debug - 244 Database Queries. Total time 0.1922 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00056910514831543
SELECT parameter, value FROM parameters
2 0.0012 0.0011589527130127
SELECT * FROM `bad_bots`
3 0.0004 0.00042510032653809
SET time_zone = 'Europe/London'
4 0.0005 0.00054693222045898
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0022 0.0022399425506592
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.238.180.255\";}'
6 0.0014 0.0014019012451172
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653092927'
7 0.0009 0.00092506408691406
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00038909912109375
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.00066399574279785
SELECT id FROM pages WHERE pagename = 'pickwick-tea-blend-rooibos-honey-20-sachets-de-the' LIMIT 1
10 0.0007 0.00074577331542969
SELECT id FROM products WHERE pagename = 'pickwick-tea-blend-rooibos-honey-20-sachets-de-the' AND hidden = 0 LIMIT 1
11 0.0013 0.001305103302002
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00092601776123047
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0008 0.00075006484985352
SELECT * FROM pages WHERE pagename = 'pickwick-tea-blend-rooibos-honey-20-sachets-de-the'
14 0.0004 0.00038695335388184
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00041913986206055
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0128 0.012815952301025
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
17 0.0005 0.00047707557678223
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0003 0.00029110908508301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00034713745117188
SELECT id FROM categories WHERE parent_id = '26'
20 0.0097 0.0097131729125977
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 
21 0.0004 0.00039815902709961
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 
22 0.0005 0.0004570484161377
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
23 0.0005 0.00050997734069824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00031018257141113
SELECT * FROM categorygroups WHERE id = '1'
25 0.0045 0.0044770240783691
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
26 0.0005 0.00046086311340332
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0005 0.00052213668823242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00031089782714844
SELECT id FROM categories WHERE parent_id = '27'
29 0.0048 0.0047750473022461
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 
30 0.0003 0.00028419494628906
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 
31 0.0005 0.00046706199645996
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
32 0.0005 0.00046205520629883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00050902366638184
SELECT * FROM categorygroups WHERE id = '1'
34 0.0019 0.0018699169158936
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
35 0.0005 0.00049209594726562
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.00043511390686035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00026297569274902
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0017049312591553
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 
39 0.0004 0.00042986869812012
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 
40 0.0004 0.00044703483581543
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
41 0.0003 0.00026488304138184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00024700164794922
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00063395500183105
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
44 0.0004 0.00044918060302734
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00044918060302734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00041580200195312
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00065708160400391
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 
48 0.0005 0.00045394897460938
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 
49 0.0004 0.00040507316589355
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
50 0.0004 0.00042295455932617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00045299530029297
SELECT * FROM categorygroups WHERE id = '1'
52 0.0009 0.00089716911315918
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
53 0.0005 0.00051188468933105
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0005 0.00053596496582031
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00048303604125977
SELECT id FROM categories WHERE parent_id = '30'
56 0.0013 0.0012760162353516
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 
57 0.0005 0.00049591064453125
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 
58 0.0005 0.00046610832214355
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
59 0.0005 0.0004730224609375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00033307075500488
SELECT * FROM categorygroups WHERE id = '1'
61 0.0011 0.0011360645294189
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
62 0.0004 0.00040698051452637
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0003 0.00028896331787109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00027608871459961
SELECT id FROM categories WHERE parent_id = '31'
65 0.0011 0.0011389255523682
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 
66 0.0003 0.00033998489379883
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 
67 0.0003 0.00031900405883789
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
68 0.0003 0.00027608871459961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.0003509521484375
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00030708312988281
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.0003359317779541
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0004 0.00038790702819824
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
73 0.0004 0.00035715103149414
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0009 0.0009000301361084
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00049805641174316
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00031518936157227
SELECT * FROM ipgeocountries WHERE INET_ATON('3.238.180.255') >= INET_ATON(ip_start) AND INET_ATON('3.238.180.255') <= INET_ATON(ip_end)
77 0.0005 0.00045680999755859
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00029301643371582
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0009 0.00086283683776855
SELECT * FROM products WHERE pagename = 'pickwick-tea-blend-rooibos-honey-20-sachets-de-the'
80 0.0006 0.00064802169799805
UPDATE products SET viewcount = viewcount + 1 WHERE id = 974
81 0.0008 0.00079894065856934
SELECT * FROM manufacturers WHERE id = '167'
82 0.0010 0.00096797943115234
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '167'
83 0.0006 0.0005648136138916
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '167' LIMIT 1
84 0.0010 0.0010099411010742
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '167' ORDER BY RAND() LIMIT 1
85 0.0018 0.0018417835235596
SELECT * FROM productimages WHERE product_id = '2803' ORDER BY sortorder ASC
86 0.0005 0.00051093101501465
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '167'
87 0.0009 0.00087618827819824
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '167'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0007 0.00065398216247559
SELECT * FROM manufacturerimages WHERE manufacturer_id = '167'
89 0.0007 0.00072908401489258
SELECT category_id FROM products_categories WHERE product_id = '974'
90 0.0005 0.00050091743469238
SELECT * FROM categories WHERE id = '27'
91 0.0050 0.0050308704376221
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
92 0.0005 0.00051999092102051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0003 0.00033998489379883
SELECT id FROM categories WHERE parent_id = '27'
94 0.0051 0.0050561428070068
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 
95 0.0003 0.00027918815612793
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 
96 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
97 0.0003 0.00029397010803223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0010 0.0010240077972412
SELECT * FROM productimages WHERE product_id = '974' ORDER BY sortorder ASC
99 0.0004 0.00043106079101562
SELECT * FROM product_image_select WHERE product_id = '974'
100 0.0005 0.00052118301391602
SELECT * FROM productcustomimages WHERE product_id = '974'
101 0.0005 0.00049901008605957
SELECT * FROM productfeeds WHERE product_id = '974' ORDER BY item_date DESC
102 0.0006 0.00061988830566406
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '974' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0009 0.00086092948913574
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '974' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00038909912109375
SELECT * FROM tags WHERE id = '1'
105 0.0018 0.0018389225006104
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
106 0.0017 0.0016860961914062
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
107 0.0020 0.0019690990447998
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
108 0.0006 0.00055408477783203
SELECT * FROM productimages WHERE product_id = '1055' ORDER BY sortorder ASC
109 0.0006 0.00059413909912109
SELECT * FROM productamazoncontent WHERE product_id = '974'
110 0.0009 0.00086498260498047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '974' AND a.name = n.originalname
111 0.0005 0.00048995018005371
SELECT * FROM productoffers WHERE product_id = '974' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0006 0.00055289268493652
SELECT * FROM productoffers
                WHERE product_id = '974' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0005 0.00048995018005371
SELECT value FROM productattributes WHERE product_id = '974' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114 0.0005 0.00046491622924805
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
115 0.0077 0.007749080657959
SELECT *, MATCH (description, title) AGAINST ('sachets de thé' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('sachets de thé' IN BOOLEAN MODE) AND 974 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
116 0.0006 0.00058698654174805
SELECT *, MATCH (description, title) AGAINST ('sachets de thé' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('sachets de thé' IN BOOLEAN MODE) AND 974 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
117 0.0006 0.00058889389038086
SELECT *, MATCH (description, title) AGAINST ('sachets de thé' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('sachets de thé' IN BOOLEAN MODE) AND 974 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
118 0.0004 0.00042200088500977
SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
119 0.0003 0.00029397010803223
SELECT * FROM product_image_select WHERE product_id = '764'
120 0.0003 0.00028014183044434
SELECT * FROM productcustomimages WHERE product_id = '764'
121 0.0004 0.00044107437133789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '764' AND a.name = n.originalname
122 0.0005 0.000518798828125
SELECT * FROM productoffers WHERE product_id = '764' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0005 0.00046992301940918
SELECT * FROM productoffers
                WHERE product_id = '764' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0003 0.00032615661621094
SELECT value FROM productattributes WHERE product_id = '764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0003 0.00027179718017578
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
126 0.0003 0.00026297569274902
SELECT * FROM product_image_select WHERE product_id = '878'
127 0.0002 0.00024509429931641
SELECT * FROM productcustomimages WHERE product_id = '878'
128 0.0009 0.00087213516235352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
129 0.0004 0.00042605400085449
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
130 0.0006 0.00063300132751465
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0005 0.00050806999206543
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0005 0.00046205520629883
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
133 0.0009 0.00085997581481934
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '822' AND p.id = pi.product_id ORDER BY pi.sortorder
134 0.0003 0.00032591819763184
SELECT * FROM product_image_select WHERE product_id = '822'
135 0.0004 0.00042510032653809
SELECT * FROM productcustomimages WHERE product_id = '822'
136 0.0010 0.00095009803771973
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '822'
                GROUP BY o.product_id
137 0.0009 0.00093793869018555
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
138 0.0006 0.00062799453735352
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
139 0.0009 0.00092816352844238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
140 0.0007 0.00068998336791992
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0008 0.00078797340393066
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0006 0.00063610076904297
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
143 0.0005 0.00053000450134277
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
144 0.0003 0.00027894973754883
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '822'
                GROUP BY o.product_id
145 0.0004 0.00044488906860352
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
146 0.0004 0.00042390823364258
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
147 0.0007 0.00073981285095215
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0010 0.0010201930999756
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '822'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
149 0.0007 0.00069499015808105
SELECT id,asin FROM products WHERE parent_id = 974
150 0.0004 0.00040411949157715
SELECT category_id FROM products_categories WHERE product_id = '974'
151 0.0005 0.00049591064453125
SELECT * FROM categories WHERE id = '27'
152 0.0004 0.00040888786315918
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
153 0.0005 0.00050806999206543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
154 0.0005 0.00053691864013672
SELECT id FROM categories WHERE parent_id = '27'
155 0.0006 0.00055313110351562
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 
156 0.0005 0.00052094459533691
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 
157 0.0005 0.00048685073852539
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
158 0.0005 0.00051093101501465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
159 0.0005 0.00048398971557617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '974' AND a.name = n.originalname
160 0.0005 0.00046205520629883
SELECT * FROM productoffers WHERE product_id = '974' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = '974' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0007 0.00072789192199707
SELECT * FROM products WHERE id = '974'
163 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '974' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0004 0.0004119873046875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '974' AND a.name = n.originalname
165 0.0005 0.00049805641174316
SELECT * FROM productoffers WHERE product_id = '974' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0005 0.00054597854614258
SELECT * FROM productoffers
                WHERE product_id = '974' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0005 0.00047898292541504
SELECT category_id FROM products_categories WHERE product_id = '974' AND prod_type = 'amz'
168 0.0003 0.00028300285339355
SELECT parent_id FROM categories WHERE id = '27'
169 0.0004 0.0004429817199707
SELECT * FROM categories WHERE id = '27'
170 0.0004 0.00042915344238281
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
171 0.0005 0.00045990943908691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
172 0.0005 0.00047707557678223
SELECT id FROM categories WHERE parent_id = '27'
173 0.0005 0.00046610832214355
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 
174 0.0005 0.00049781799316406
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 
175 0.0005 0.0004580020904541
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
176 0.0004 0.0003509521484375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
177 0.0006 0.00055217742919922
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
178 0.0005 0.00047087669372559
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
179 0.0003 0.00028300285339355
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
180 0.0005 0.00053787231445312
SELECT * FROM pages WHERE id = 38
181 0.0068 0.0067880153656006
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
182 0.0008 0.0008089542388916
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:1653092928;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'
183 0.0009 0.00085902214050293
SELECT * FROM products WHERE id = 788
184 0.0006 0.00064301490783691
SELECT * FROM products WHERE id = 787
185 0.0008 0.00076007843017578
SELECT * FROM products WHERE id = 1287
186 0.0007 0.0006721019744873
SELECT * FROM products WHERE id = 780
187 0.0006 0.00064206123352051
SELECT * FROM products WHERE id = 777
188 0.0007 0.00066089630126953
SELECT * FROM products WHERE id = 776
189 0.0006 0.00055384635925293
SELECT * FROM products WHERE id = '788'
190 0.0004 0.00039505958557129
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
191 0.0004 0.00039100646972656
SELECT * FROM product_image_select WHERE product_id = '788'
192 0.0004 0.00038886070251465
SELECT * FROM productcustomimages WHERE product_id = '788'
193 0.0004 0.00042414665222168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
194 0.0006 0.00063204765319824
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0007 0.00072193145751953
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0006 0.00063085556030273
SELECT * FROM products WHERE id = '787'
198 0.0003 0.0003359317779541
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
199 0.0004 0.00042104721069336
SELECT * FROM product_image_select WHERE product_id = '787'
200 0.0004 0.00035691261291504
SELECT * FROM productcustomimages WHERE product_id = '787'
201 0.0005 0.00045299530029297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
202 0.0006 0.0005500316619873
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0007 0.00073599815368652
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0003 0.00031805038452148
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0007 0.00069308280944824
SELECT * FROM products WHERE id = '1287'
206 0.0004 0.00042200088500977
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
207 0.0003 0.00034403800964355
SELECT * FROM product_image_select WHERE product_id = '1287'
208 0.0005 0.00050806999206543
SELECT * FROM productcustomimages WHERE product_id = '1287'
209 0.0006 0.00056195259094238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
210 0.0007 0.00068116188049316
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0008 0.00078701972961426
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0005 0.0005190372467041
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0008 0.00083112716674805
SELECT * FROM products WHERE id = '780'
214 0.0004 0.00043511390686035
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
215 0.0004 0.00043296813964844
SELECT * FROM product_image_select WHERE product_id = '780'
216 0.0004 0.00044703483581543
SELECT * FROM productcustomimages WHERE product_id = '780'
217 0.0005 0.0004730224609375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
218 0.0007 0.00067782402038574
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0007 0.00070405006408691
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0004 0.00044989585876465
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0006 0.00063896179199219
SELECT * FROM products WHERE id = '777'
222 0.0004 0.00043010711669922
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
223 0.0004 0.00044894218444824
SELECT * FROM product_image_select WHERE product_id = '777'
224 0.0004 0.00040698051452637
SELECT * FROM productcustomimages WHERE product_id = '777'
225 0.0005 0.00052690505981445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
226 0.0006 0.00064802169799805
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0009 0.00087094306945801
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0003 0.00032806396484375
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0007 0.00070905685424805
SELECT * FROM products WHERE id = '776'
230 0.0004 0.0004119873046875
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
231 0.0003 0.00032496452331543
SELECT * FROM product_image_select WHERE product_id = '776'
232 0.0003 0.00034403800964355
SELECT * FROM productcustomimages WHERE product_id = '776'
233 0.0004 0.00044584274291992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
234 0.0006 0.00059199333190918
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0006 0.00060820579528809
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0005 0.00046515464782715
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0006 0.0005800724029541
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
238 0.0004 0.00036811828613281
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
239 0.0007 0.00065398216247559
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
240 0.0004 0.0004420280456543
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
241 0.0004 0.00041317939758301
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
242 0.0005 0.00050997734069824
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
243 0.0004 0.0004119873046875
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
244 0.0004 0.00038814544677734
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'