Tedemecum Thé Rooibos Flor Del Desierto Gourmet (25 x 2gr)

Tedemecum Thé Rooibos Flor Del Desierto Gourmet (25 x 2gr)
Tedemecum Thé Rooibos Flor Del Desierto Gourmet (25 x 2gr) Tedemecum Thé Rooibos Flor Del Desierto Gourmet (25 x 2gr) Tedemecum Thé Rooibos Flor Del Desierto Gourmet (25 x 2gr) Tedemecum Thé Rooibos Flor Del Desierto Gourmet (25 x 2gr) Tedemecum Thé Rooibos Flor Del Desierto Gourmet (25 x 2gr) (cliquez sur les images pour élargir)
€9,90
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2022-05-26 21:24:05 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.5737998485565 240 0.1512 0


No Amazon API Requests Made.

Total time 1.5737998485565 seconds

Number Time From Start Name Description
1 1.0520668029785 Initialise Initialise FSB Function
2 1.0543868541718 App Controller Start Start of the App controller (called before the controller of every page)
3 1.0575609207153 Start of getCategoryListByGroup Function Before first category groups query
4 1.0579059123993 After initial query Before first category groups query
5 1.0579078197479 Get Category List for Group Before the call to getCategoryList function
6 1.0579118728638 Start of GetCategoryList function Start of the function
7 1.0579149723053 Before getting categories Query to get specific category list
8 1.0583579540253 After getting categories Query to get specific category list
9 1.0583598613739 Before getting category custom Before call to function getCategoryCustom
10 1.0617158412933 After getting category custom After call to function getCategoryCustom
11 1.0617179870605 Before getting category custom Before call to function getCategoryCustom
12 1.0760538578033 After getting category custom After call to function getCategoryCustom
13 1.0760569572449 Before getting category custom Before call to function getCategoryCustom
14 1.0814528465271 After getting category custom After call to function getCategoryCustom
15 1.0814559459686 Before getting category custom Before call to function getCategoryCustom
16 1.0843999385834 After getting category custom After call to function getCategoryCustom
17 1.084401845932 Before getting category custom Before call to function getCategoryCustom
18 1.0871579647064 After getting category custom After call to function getCategoryCustom
19 1.0871598720551 Before getting category custom Before call to function getCategoryCustom
20 1.0898759365082 After getting category custom After call to function getCategoryCustom
21 1.0898778438568 End of GetCategoryList function End of the function
22 1.089882850647 End of getCategoryListByGroup Function Before return()
23 1.0952780246735 App Controller End End of the App controller (called before the controller of every page)
24 1.0958828926086 Product Start Start of the product info controller
25 1.1175489425659 Cache file not found Starting get product details
26 1.1563429832458 Related products Start getting related products if enabled
27 1.1563448905945 Related Products Start Before the related products are found
28 1.1563458442688 Related Products Keywords Before the related product keywords are found
29 1.156350851059 Create Keyword List Function Start of function
30 1.1563827991486 Create Keyword List Function After looping provided content - 27 keywords found
31 1.1573278903961 Create Keyword List Function After looping initial keyword list - 22 keywords remaining
32 1.1573348045349 Create Keyword List Function After reducing keyword list
33 1.1574239730835 Create Keyword List Function After selecting by scoring keywords
34 1.1574280261993 Create Keyword List Function After final loop of keywords
35 1.1574308872223 Related Products Keywords After the related product keywords are found
36 1.1776390075684 Related Products End After the related products are found
37 1.1874239444733 Product End End of the product info controller (Product Info)
38 1.3464019298553 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 1.3472428321838 Before Get Options Before the call to getOptions in the tpl class
40 1.3889389038086 After Get Options After the call to getOptions in the tpl class
41 1.3890359401703 App_after Controller End End of the App_after controller (called after the controller of every page)
42 1.3890700340271 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 1.546021938324 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 1.5460288524628 Product Info: Before Template Display Before the template is displayed
45 1.5737688541412 Product Info: After Template Display After the template is displayed
46 1.5737838745117 Finalizing debug Before the debug is output to the page.
47 1.5737979412079 End of App This is the end of the app logging, final timestamp


Query Debug - 240 Database Queries. Total time 0.1512 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00069999694824219
SELECT parameter, value FROM parameters
2 0.0012 0.0011699199676514
SELECT * FROM `bad_bots`
3 0.0005 0.00046682357788086
SET time_zone = 'Europe/London'
4 0.0004 0.00037598609924316
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0017 0.0017359256744385
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"44.192.25.113\";}'
6 0.0013 0.0012710094451904
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653703162'
7 0.0005 0.00046396255493164
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00040793418884277
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00050902366638184
SELECT id FROM pages WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-25-x-2gr' LIMIT 1
10 0.0007 0.00065994262695312
SELECT id FROM products WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-25-x-2gr' AND hidden = 0 LIMIT 1
11 0.0012 0.001209020614624
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0010 0.0010139942169189
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00055599212646484
SELECT * FROM pages WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-25-x-2gr'
14 0.0003 0.00033307075500488
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00042414665222168
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0005 0.0005490779876709
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.00050616264343262
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.0004 0.0004279613494873
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00026202201843262
SELECT id FROM categories WHERE parent_id = '26'
20 0.0003 0.00034093856811523
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.00038909912109375
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.0003 0.00027012825012207
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.00023293495178223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00024795532226562
SELECT * FROM categorygroups WHERE id = '1'
25 0.0082 0.0081961154937744
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.0003 0.00028491020202637
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.00021100044250488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00025296211242676
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.0043239593505859
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.00031590461730957
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.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
32 0.0002 0.00020313262939453
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00020599365234375
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0015959739685059
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.0004 0.00039315223693848
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.0003 0.00027203559875488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '28'
38 0.0018 0.0018310546875
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.0003 0.00027894973754883
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.0003 0.00025296211242676
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.00021815299987793
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00023293495178223
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00051999092102051
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.0003 0.00032401084899902
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.00021505355834961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00023698806762695
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00060701370239258
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.0003 0.00028610229492188
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.0003 0.00025010108947754
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.00020194053649902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.0002140998840332
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00057387351989746
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.00022077560424805
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.0002288818359375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00025510787963867
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00052785873413086
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.0003 0.0002589225769043
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.00020003318786621
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.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.0001990795135498
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00050783157348633
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.00024199485778809
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.0001981258392334
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00018596649169922
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00061202049255371
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.0002281665802002
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.00020718574523926
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.0002 0.00023508071899414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00020694732666016
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.0002288818359375
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0004 0.00038814544677734
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00030517578125
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.00021910667419434
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00054311752319336
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0007 0.00071597099304199
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00024604797363281
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)
77 0.0004 0.00037717819213867
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00023794174194336
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.00062108039855957
SELECT * FROM products WHERE pagename = 'tedemecum-the-rooibos-flor-del-desierto-gourmet-25-x-2gr'
80 0.0007 0.00072193145751953
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3664
81 0.0006 0.00063085556030273
SELECT * FROM manufacturers WHERE id = '538'
82 0.0007 0.00070905685424805
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '538'
83 0.0006 0.00058102607727051
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '538' LIMIT 1
84 0.0009 0.00094103813171387
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '538' ORDER BY RAND() LIMIT 1
85 0.0019 0.0019171237945557
SELECT * FROM productimages WHERE product_id = '3704' ORDER BY sortorder ASC
86 0.0006 0.00055503845214844
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '538'
87 0.0008 0.00080299377441406
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '538'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0005 0.00047206878662109
SELECT * FROM manufacturerimages WHERE manufacturer_id = '538'
89 0.0004 0.0004432201385498
SELECT category_id FROM products_categories WHERE product_id = '3664'
90 0.0004 0.00044989585876465
SELECT * FROM categories WHERE id = '27'
91 0.0068 0.0067570209503174
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.0003 0.00033307075500488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00022506713867188
SELECT id FROM categories WHERE parent_id = '27'
94 0.0058 0.0058238506317139
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.0004 0.00039887428283691
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.0004 0.00037193298339844
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.00021100044250488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0013 0.0013229846954346
SELECT * FROM productimages WHERE product_id = '3664' ORDER BY sortorder ASC
99 0.0006 0.00060200691223145
SELECT * FROM product_image_select WHERE product_id = '3664'
100 0.0006 0.00058102607727051
SELECT * FROM productcustomimages WHERE product_id = '3664'
101 0.0006 0.00055480003356934
SELECT * FROM productfeeds WHERE product_id = '3664' ORDER BY item_date DESC
102 0.0014 0.0013887882232666
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0010 0.00098490715026855
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3664' AND t.hidden = 0 AND display_product = 1
104 0.0005 0.00050902366638184
SELECT * FROM tags WHERE id = '15'
105 0.0012 0.001209020614624
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '15'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
106 0.0012 0.0011639595031738
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '15'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
107 0.0013 0.00130295753479
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '15' 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.0005 0.00053596496582031
SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
109 0.0004 0.00043797492980957
SELECT * FROM productamazoncontent WHERE product_id = '3664'
110 0.0013 0.0013270378112793
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname
111 0.0009 0.00090694427490234
SELECT * FROM productoffers WHERE product_id = '3664' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0007 0.0007469654083252
SELECT * FROM productoffers
                WHERE product_id = '3664' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0008 0.00078892707824707
SELECT * FROM productoffers
                WHERE product_id = 3664
                ORDER BY price ASC LIMIT 1
114 0.0007 0.00073695182800293
SELECT value FROM productattributes
                WHERE product_id = '3664'
                AND name = 'ListPriceAmount'
115 0.0007 0.00074005126953125
SELECT value FROM productattributes WHERE product_id = '3664' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116 0.0006 0.00057888031005859
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
117 0.0113 0.011274814605713
SELECT *, MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AND 3664 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
118 0.0005 0.00054287910461426
SELECT *, MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AND 3664 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
119 0.0005 0.00049805641174316
SELECT *, MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('tedemecum thé rooibos' IN BOOLEAN MODE) AND 3664 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
120 0.0004 0.00039505958557129
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
121 0.0004 0.00041508674621582
SELECT * FROM product_image_select WHERE product_id = '858'
122 0.0003 0.00034713745117188
SELECT * FROM productcustomimages WHERE product_id = '858'
123 0.0004 0.00043702125549316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
124 0.0006 0.00056219100952148
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0006 0.0005791187286377
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0002 0.0002291202545166
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0002 0.00023603439331055
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
128 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '878'
129 0.0002 0.00020098686218262
SELECT * FROM productcustomimages WHERE product_id = '878'
130 0.0003 0.00029802322387695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
131 0.0003 0.00034308433532715
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0005 0.00054097175598145
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0003 0.00028300285339355
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0004 0.00038409233093262
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
135 0.0003 0.00029802322387695
SELECT * FROM product_image_select WHERE product_id = '862'
136 0.0003 0.00033998489379883
SELECT * FROM productcustomimages WHERE product_id = '862'
137 0.0005 0.00045895576477051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
138 0.0002 0.00021886825561523
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0003 0.00025796890258789
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0002 0.00020194053649902
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0004 0.00043201446533203
SELECT id,asin FROM products WHERE parent_id = 3664
142 0.0003 0.00030398368835449
SELECT category_id FROM products_categories WHERE product_id = '3664'
143 0.0002 0.00023102760314941
SELECT * FROM categories WHERE id = '27'
144 0.0002 0.00024795532226562
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
145 0.0003 0.00025010108947754
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
146 0.0002 0.00024199485778809
SELECT id FROM categories WHERE parent_id = '27'
147 0.0004 0.00037789344787598
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 
148 0.0004 0.00039911270141602
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 
149 0.0004 0.00042104721069336
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
150 0.0004 0.00043106079101562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
151 0.0004 0.00042390823364258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname
152 0.0005 0.0005030632019043
SELECT * FROM productoffers WHERE product_id = '3664' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0002 0.00023698806762695
SELECT * FROM productoffers
                WHERE product_id = '3664' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = 3664
                ORDER BY price ASC LIMIT 1
155 0.0002 0.0001990795135498
SELECT value FROM productattributes
                WHERE product_id = '3664'
                AND name = 'ListPriceAmount'
156 0.0006 0.00055623054504395
SELECT * FROM products WHERE id = '3664'
157 0.0003 0.00026392936706543
SELECT value FROM productattributes WHERE product_id = '3664' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0003 0.00026202201843262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname
159 0.0004 0.00044488906860352
SELECT * FROM productoffers WHERE product_id = '3664' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0003 0.00026392936706543
SELECT * FROM productoffers
                WHERE product_id = '3664' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0003 0.0002601146697998
SELECT * FROM productoffers
                WHERE product_id = 3664
                ORDER BY price ASC LIMIT 1
162 0.0002 0.00022602081298828
SELECT value FROM productattributes
                WHERE product_id = '3664'
                AND name = 'ListPriceAmount'
163 0.0003 0.00033903121948242
SELECT category_id FROM products_categories WHERE product_id = '3664' AND prod_type = 'amz'
164 0.0002 0.00020980834960938
SELECT parent_id FROM categories WHERE id = '27'
165 0.0002 0.00023603439331055
SELECT * FROM categories WHERE id = '27'
166 0.0002 0.00019502639770508
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
167 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
168 0.0002 0.00017905235290527
SELECT id FROM categories WHERE parent_id = '27'
169 0.0002 0.00018978118896484
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 
170 0.0002 0.00019001960754395
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 
171 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
172 0.0002 0.00023198127746582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
173 0.0005 0.00052881240844727
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
174 0.0003 0.00028300285339355
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
175 0.0005 0.00048208236694336
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
176 0.0004 0.00043487548828125
SELECT * FROM pages WHERE id = 38
177 0.0068 0.0068490505218506
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
178 0.0007 0.00074100494384766
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:1653703163;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'
179 0.0008 0.00078988075256348
SELECT * FROM products WHERE id = 788
180 0.0008 0.00075984001159668
SELECT * FROM products WHERE id = 787
181 0.0008 0.00078606605529785
SELECT * FROM products WHERE id = 1287
182 0.0007 0.00074195861816406
SELECT * FROM products WHERE id = 780
183 0.0009 0.00094008445739746
SELECT * FROM products WHERE id = 777
184 0.0008 0.00075387954711914
SELECT * FROM products WHERE id = 776
185 0.0006 0.00062990188598633
SELECT * FROM products WHERE id = '788'
186 0.0003 0.00030899047851562
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
187 0.0003 0.00034809112548828
SELECT * FROM product_image_select WHERE product_id = '788'
188 0.0004 0.00037980079650879
SELECT * FROM productcustomimages WHERE product_id = '788'
189 0.0004 0.0004270076751709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
190 0.0004 0.0004270076751709
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0005 0.00050687789916992
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0004 0.00040817260742188
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193 0.0006 0.00061392784118652
SELECT * FROM products WHERE id = '787'
194 0.0005 0.00046396255493164
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
195 0.0004 0.00040888786315918
SELECT * FROM product_image_select WHERE product_id = '787'
196 0.0003 0.00034308433532715
SELECT * FROM productcustomimages WHERE product_id = '787'
197 0.0004 0.00038003921508789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
198 0.0004 0.00037503242492676
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
199 0.0005 0.00047802925109863
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
200 0.0003 0.0002899169921875
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0006 0.00057005882263184
SELECT * FROM products WHERE id = '1287'
202 0.0005 0.00047683715820312
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
203 0.0003 0.00031113624572754
SELECT * FROM product_image_select WHERE product_id = '1287'
204 0.0003 0.00026297569274902
SELECT * FROM productcustomimages WHERE product_id = '1287'
205 0.0004 0.00043797492980957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
206 0.0004 0.00035905838012695
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0003 0.00029182434082031
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0003 0.00032401084899902
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209 0.0005 0.00053215026855469
SELECT * FROM products WHERE id = '780'
210 0.0004 0.00037193298339844
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
211 0.0004 0.00038981437683105
SELECT * FROM product_image_select WHERE product_id = '780'
212 0.0004 0.00038909912109375
SELECT * FROM productcustomimages WHERE product_id = '780'
213 0.0003 0.00034189224243164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
214 0.0004 0.00037384033203125
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0003 0.00031399726867676
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0006 0.00064897537231445
SELECT * FROM products WHERE id = '777'
218 0.0004 0.00041484832763672
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
219 0.0003 0.00032305717468262
SELECT * FROM product_image_select WHERE product_id = '777'
220 0.0003 0.00027012825012207
SELECT * FROM productcustomimages WHERE product_id = '777'
221 0.0004 0.00042891502380371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
222 0.0004 0.00037312507629395
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
223 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
224 0.0003 0.00034904479980469
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0007 0.00067019462585449
SELECT * FROM products WHERE id = '776'
226 0.0004 0.00043916702270508
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
227 0.0003 0.00025606155395508
SELECT * FROM product_image_select WHERE product_id = '776'
228 0.0003 0.00029397010803223
SELECT * FROM productcustomimages WHERE product_id = '776'
229 0.0004 0.00040388107299805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
230 0.0003 0.0002751350402832
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0003 0.0003209114074707
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0002 0.00023102760314941
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0004 0.00037598609924316
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
234 0.0005 0.0005190372467041
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
235 0.0008 0.00084400177001953
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
236 0.0005 0.00053215026855469
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
237 0.0006 0.00058889389038086
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
238 0.0006 0.00061392784118652
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
239 0.0005 0.00052499771118164
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
240 0.0004 0.00038003921508789
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'