Infusettes de Rooibos Nature - boîte 30g

Infusettes de Rooibos Nature - boîte 30g
Infusettes de Rooibos Nature - boîte 30g Infusettes de Rooibos Nature - boîte 30g Infusettes de Rooibos Nature - boîte 30g Infusettes de Rooibos Nature - boîte 30g Infusettes de Rooibos Nature - boîte 30g (cliquez sur les images pour élargir)
€4,80
Le prix et la disponibilité du produit sont corrects en date du 2021-09-15 08:25:36 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.

Caractéristiques du Produit

Thés et tisanes d'excellence 100% BIO Issu en majeure partie de commerce équitable et certains de biodynamie
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.87351393699646 244 0.1387 0


No Amazon API Requests Made.

Total time 0.87351393699646 seconds

Number Time From Start Name Description
1 0.6583240032196 Initialise Initialise FSB Function
2 0.66059684753418 App Controller Start Start of the App controller (called before the controller of every page)
3 0.66390800476074 Start of getCategoryListByGroup Function Before first category groups query
4 0.66577792167664 After initial query Before first category groups query
5 0.66577982902527 Get Category List for Group Before the call to getCategoryList function
6 0.6657829284668 Start of GetCategoryList function Start of the function
7 0.66578698158264 Before getting categories Query to get specific category list
8 0.66622185707092 After getting categories Query to get specific category list
9 0.66622400283813 Before getting category custom Before call to function getCategoryCustom
10 0.68465495109558 After getting category custom After call to function getCategoryCustom
11 0.68465685844421 Before getting category custom Before call to function getCategoryCustom
12 0.68636703491211 After getting category custom After call to function getCategoryCustom
13 0.68636894226074 Before getting category custom Before call to function getCategoryCustom
14 0.69077682495117 After getting category custom After call to function getCategoryCustom
15 0.69077897071838 Before getting category custom Before call to function getCategoryCustom
16 0.69316005706787 After getting category custom After call to function getCategoryCustom
17 0.6931619644165 Before getting category custom Before call to function getCategoryCustom
18 0.69556593894958 After getting category custom After call to function getCategoryCustom
19 0.69556784629822 Before getting category custom Before call to function getCategoryCustom
20 0.69791889190674 After getting category custom After call to function getCategoryCustom
21 0.69792103767395 End of GetCategoryList function End of the function
22 0.69792604446411 End of getCategoryListByGroup Function Before return()
23 0.70254397392273 App Controller End End of the App controller (called before the controller of every page)
24 0.7031078338623 Product Start Start of the product info controller
25 0.71270704269409 Cache file not found Starting get product details
26 0.74927186965942 Related products Start getting related products if enabled
27 0.74927401542664 Related Products Start Before the related products are found
28 0.74927496910095 Related Products Keywords Before the related product keywords are found
29 0.7492790222168 Create Keyword List Function Start of function
30 0.74930500984192 Create Keyword List Function After looping provided content - 15 keywords found
31 0.74989104270935 Create Keyword List Function After looping initial keyword list - 13 keywords remaining
32 0.74989700317383 Create Keyword List Function After reducing keyword list
33 0.74992299079895 Create Keyword List Function After selecting by scoring keywords
34 0.7499258518219 Create Keyword List Function After final loop of keywords
35 0.74992799758911 Related Products Keywords After the related product keywords are found
36 0.77146697044373 Related Products End After the related products are found
37 0.77818703651428 Product End End of the product info controller (Product Info)
38 0.77902793884277 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.77944183349609 Before Get Options Before the call to getOptions in the tpl class
40 0.80708885192871 After Get Options After the call to getOptions in the tpl class
41 0.80715894699097 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.80718588829041 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.84715795516968 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.84716200828552 Product Info: Before Template Display Before the template is displayed
45 0.87348985671997 Product Info: After Template Display After the template is displayed
46 0.87350082397461 Finalizing debug Before the debug is output to the page.
47 0.87351298332214 End of App This is the end of the app logging, final timestamp


Query Debug - 244 Database Queries. Total time 0.1387 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00060510635375977
SELECT parameter, value FROM parameters
2 0.0012 0.0012190341949463
SELECT * FROM `bad_bots`
3 0.0004 0.00037312507629395
SET time_zone = 'Europe/London'
4 0.0003 0.00029420852661133
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0019 0.0019168853759766
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.212.116\";}'
6 0.0009 0.00093317031860352
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632139960'
7 0.0010 0.0010180473327637
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00023293495178223
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00062799453735352
SELECT id FROM pages WHERE pagename = 'infusettes-de-rooibos-nature-bote-30g' LIMIT 1
10 0.0008 0.00075292587280273
SELECT id FROM products WHERE pagename = 'infusettes-de-rooibos-nature-bote-30g' AND hidden = 0 LIMIT 1
11 0.0013 0.0012698173522949
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00094509124755859
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00059890747070312
SELECT * FROM pages WHERE pagename = 'infusettes-de-rooibos-nature-bote-30g'
14 0.0019 0.0018539428710938
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00041413307189941
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0103 0.010344982147217
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.0002 0.00021100044250488
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.0002 0.00018882751464844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00016593933105469
SELECT id FROM categories WHERE parent_id = '26'
20 0.0067 0.0066609382629395
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.0002 0.00019598007202148
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.0002 0.00018215179443359
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.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00018882751464844
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00019407272338867
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.0002 0.00016880035400391
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.0002 0.0001680850982666
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00016999244689941
SELECT id FROM categories WHERE parent_id = '27'
29 0.0002 0.0001988410949707
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.0002 0.00017595291137695
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.0002 0.00019001960754395
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.0002 0.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.0001680850982666
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.001539945602417
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.0002 0.00016999244689941
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.0002 0.00016283988952637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00017213821411133
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0014908313751221
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.0002 0.00017285346984863
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.0002 0.00016498565673828
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.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00025820732116699
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.0005040168762207
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.0002 0.0001981258392334
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.0002 0.00017619132995605
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00017499923706055
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00049996376037598
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.0002 0.00022697448730469
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.0002 0.00017380714416504
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.0002 0.00015878677368164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00018000602722168
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00046300888061523
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.0002 0.00018596649169922
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.0002 0.00017809867858887
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00050616264343262
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.0002 0.00023508071899414
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.0002 0.00018882751464844
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.0002 0.00018119812011719
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00017786026000977
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00057601928710938
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.0002 0.00017905235290527
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.0002 0.00019407272338867
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.0001518726348877
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00052714347839355
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.0002 0.00016498565673828
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.0002 0.00015497207641602
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.0001 0.00014996528625488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00015902519226074
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00017189979553223
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0002 0.00022006034851074
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00025200843811035
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.0002 0.00018620491027832
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0006 0.00055980682373047
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00056195259094238
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.0002288818359375
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.212.116') >= INET_ATON(ip_start) AND INET_ATON('3.236.212.116') <= INET_ATON(ip_end)
77 0.0002 0.00021982192993164
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00017499923706055
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0005 0.00054287910461426
SELECT * FROM products WHERE pagename = 'infusettes-de-rooibos-nature-bote-30g'
80 0.0015 0.0014619827270508
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1017
81 0.0003 0.00034308433532715
SELECT * FROM manufacturers WHERE id = '261'
82 0.0006 0.00058412551879883
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
83 0.0002 0.0001838207244873
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '261' LIMIT 1
84 0.0010 0.0010330677032471
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '261' ORDER BY RAND() LIMIT 1
85 0.0018 0.0018310546875
SELECT * FROM productimages WHERE product_id = '1289' ORDER BY sortorder ASC
86 0.0003 0.00033211708068848
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
87 0.0008 0.00079512596130371
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '261'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0002 0.00020694732666016
SELECT * FROM manufacturerimages WHERE manufacturer_id = '261'
89 0.0003 0.00029516220092773
SELECT category_id FROM products_categories WHERE product_id = '1017'
90 0.0002 0.00023198127746582
SELECT * FROM categories WHERE id = '27'
91 0.0046 0.0045669078826904
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.0002 0.00024318695068359
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0004 0.00035595893859863
SELECT id FROM categories WHERE parent_id = '27'
94 0.0064 0.0064380168914795
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.0005 0.00047802925109863
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.00017309188842773
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.0002 0.00018882751464844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '1017' ORDER BY sortorder ASC
99 0.0002 0.00019001960754395
SELECT * FROM product_image_select WHERE product_id = '1017'
100 0.0002 0.00022482872009277
SELECT * FROM productcustomimages WHERE product_id = '1017'
101 0.0016 0.00164794921875
SELECT * FROM productfeeds WHERE product_id = '1017' ORDER BY item_date DESC
102 0.0027 0.0027179718017578
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1017' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0017 0.0017380714416504
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1017' AND t.hidden = 0 AND display_product = 1
104 0.0002 0.00022792816162109
SELECT * FROM tags WHERE id = '1'
105 0.0018 0.0018470287322998
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.0021 0.002079963684082
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.0019528865814209
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.0003 0.00025796890258789
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
109 0.0005 0.00054192543029785
SELECT * FROM productamazoncontent WHERE product_id = '1017'
110 0.0019 0.0019099712371826
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1017' AND a.name = n.originalname
111 0.0006 0.00060892105102539
SELECT * FROM productoffers WHERE product_id = '1017' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0005 0.00053596496582031
SELECT * FROM productoffers
                WHERE product_id = '1017' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0007 0.00070905685424805
SELECT value FROM productattributes WHERE product_id = '1017' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114 0.0002 0.00018405914306641
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.0098 0.0098140239715576
SELECT *, MATCH (description, title) AGAINST ('rooibos nature bote' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos nature bote' IN BOOLEAN MODE) AND 1017 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
116 0.0007 0.00069999694824219
SELECT *, MATCH (description, title) AGAINST ('rooibos nature bote' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos nature bote' IN BOOLEAN MODE) AND 1017 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
117 0.0005 0.00050091743469238
SELECT *, MATCH (description, title) AGAINST ('rooibos nature bote' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos nature bote' IN BOOLEAN MODE) AND 1017 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
118 0.0003 0.0003199577331543
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
119 0.0002 0.00019001960754395
SELECT * FROM product_image_select WHERE product_id = '858'
120 0.0002 0.00018000602722168
SELECT * FROM productcustomimages WHERE product_id = '858'
121 0.0002 0.00018692016601562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
122 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0003 0.0003058910369873
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0003 0.0002601146697998
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
126 0.0011 0.0010828971862793
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
127 0.0002 0.00018405914306641
SELECT * FROM product_image_select WHERE product_id = '822'
128 0.0002 0.00020194053649902
SELECT * FROM productcustomimages WHERE product_id = '822'
129 0.0011 0.001107931137085
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
130 0.0008 0.00080704689025879
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
131 0.0004 0.00041413307189941
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
132 0.0002 0.00022196769714355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
133 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
136 0.0002 0.00016999244689941
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
137 0.0002 0.00017595291137695
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
138 0.0002 0.00022292137145996
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
139 0.0002 0.00018000602722168
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
140 0.0002 0.00018405914306641
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0008 0.00076603889465332
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
142 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
143 0.0002 0.00019717216491699
SELECT * FROM product_image_select WHERE product_id = '878'
144 0.0002 0.00018811225891113
SELECT * FROM productcustomimages WHERE product_id = '878'
145 0.0002 0.00020694732666016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
146 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0002 0.00023984909057617
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0003 0.00032806396484375
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0004 0.00040316581726074
SELECT id,asin FROM products WHERE parent_id = 1017
150 0.0002 0.00017499923706055
SELECT category_id FROM products_categories WHERE product_id = '1017'
151 0.0002 0.00020599365234375
SELECT * FROM categories WHERE id = '27'
152 0.0002 0.00017309188842773
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.0002 0.00020003318786621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
154 0.0002 0.00022792816162109
SELECT id FROM categories WHERE parent_id = '27'
155 0.0002 0.00017189979553223
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.0002 0.0001838207244873
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.0002 0.00018095970153809
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.0002 0.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
159 0.0002 0.00018596649169922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1017' AND a.name = n.originalname
160 0.0002 0.00024914741516113
SELECT * FROM productoffers WHERE product_id = '1017' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0002 0.00024199485778809
SELECT * FROM productoffers
                WHERE product_id = '1017' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0005 0.00046396255493164
SELECT * FROM products WHERE id = '1017'
163 0.0002 0.00017094612121582
SELECT value FROM productattributes WHERE product_id = '1017' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0002 0.00020599365234375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1017' AND a.name = n.originalname
165 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '1017' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = '1017' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0003 0.00028300285339355
SELECT category_id FROM products_categories WHERE product_id = '1017' AND prod_type = 'amz'
168 0.0002 0.00018405914306641
SELECT parent_id FROM categories WHERE id = '27'
169 0.0002 0.0001978874206543
SELECT * FROM categories WHERE id = '27'
170 0.0002 0.00016093254089355
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.0002 0.00020694732666016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
172 0.0002 0.00015497207641602
SELECT id FROM categories WHERE parent_id = '27'
173 0.0002 0.00020217895507812
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.0002 0.00021815299987793
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.0002 0.0002140998840332
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.0005 0.00052094459533691
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
177 0.0002 0.000244140625
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
178 0.0002 0.00017285346984863
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
179 0.0002 0.00018119812011719
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
180 0.0003 0.00025105476379395
SELECT * FROM pages WHERE id = 38
181 0.0046 0.004551887512207
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.0023 0.0022869110107422
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:1632139961;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"779|amazon\";i:5;s:10:\"777|amazon\";}}' WHERE id = '160'
183 0.0005 0.00049304962158203
SELECT * FROM products WHERE id = 790
184 0.0004 0.00040102005004883
SELECT * FROM products WHERE id = 788
185 0.0005 0.00046992301940918
SELECT * FROM products WHERE id = 787
186 0.0007 0.00067305564880371
SELECT * FROM products WHERE id = 1287
187 0.0004 0.00042891502380371
SELECT * FROM products WHERE id = 779
188 0.0004 0.00040888786315918
SELECT * FROM products WHERE id = 777
189 0.0005 0.00049805641174316
SELECT * FROM products WHERE id = '790'
190 0.0004 0.00042414665222168
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
191 0.0002 0.0002281665802002
SELECT * FROM product_image_select WHERE product_id = '790'
192 0.0002 0.00019121170043945
SELECT * FROM productcustomimages WHERE product_id = '790'
193 0.0002 0.00023317337036133
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
194 0.0003 0.00027203559875488
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0004 0.00038790702819824
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0004 0.00044703483581543
SELECT * FROM products WHERE id = '788'
198 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
199 0.0003 0.00027298927307129
SELECT * FROM product_image_select WHERE product_id = '788'
200 0.0002 0.00017285346984863
SELECT * FROM productcustomimages WHERE product_id = '788'
201 0.0002 0.00018501281738281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
202 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0002 0.00023102760314941
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0004 0.00040817260742188
SELECT * FROM products WHERE id = '787'
206 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
207 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '787'
208 0.0002 0.00019598007202148
SELECT * FROM productcustomimages WHERE product_id = '787'
209 0.0002 0.00018405914306641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
210 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0002 0.00020313262939453
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0004 0.00042891502380371
SELECT * FROM products WHERE id = '1287'
214 0.0004 0.00043296813964844
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
215 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '1287'
216 0.0002 0.00022196769714355
SELECT * FROM productcustomimages WHERE product_id = '1287'
217 0.0003 0.00026798248291016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
218 0.0002 0.00023794174194336
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0002 0.00023889541625977
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0003 0.00031399726867676
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0004 0.00043606758117676
SELECT * FROM products WHERE id = '779'
222 0.0002 0.00019478797912598
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
223 0.0002 0.00018906593322754
SELECT * FROM product_image_select WHERE product_id = '779'
224 0.0002 0.00019407272338867
SELECT * FROM productcustomimages WHERE product_id = '779'
225 0.0002 0.00019192695617676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
226 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0002 0.00020313262939453
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0004 0.00038790702819824
SELECT * FROM products WHERE id = '777'
230 0.0002 0.00018620491027832
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
231 0.0002 0.00018787384033203
SELECT * FROM product_image_select WHERE product_id = '777'
232 0.0002 0.00018596649169922
SELECT * FROM productcustomimages WHERE product_id = '777'
233 0.0002 0.00020599365234375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
234 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0003 0.00032496452331543
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0003 0.00028204917907715
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
238 0.0004 0.00042486190795898
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
239 0.0009 0.00089001655578613
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
240 0.0007 0.00073409080505371
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
241 0.0004 0.00039410591125488
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
242 0.0006 0.00063514709472656
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
243 0.0005 0.00054192543029785
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
244 0.0004 0.00043511390686035
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'