Thé Rooibos Chocolat Menthe Bio Boîte 100G - Tealodge

Thé Rooibos Chocolat Menthe Bio Boîte 100G - Tealodge
Thé Rooibos Chocolat Menthe Bio Boîte 100G - Tealodge Thé Rooibos Chocolat Menthe Bio Boîte 100G - Tealodge Thé Rooibos Chocolat Menthe Bio Boîte 100G - Tealodge (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-07-20 18:40:55 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é Rooibos Chocolat et Menthe Thé bio Thé en vrac, en boite de 100 gr
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.57357287406921 235 0.1232 0


No Amazon API Requests Made.

Total time 0.57357287406921 seconds

Number Time From Start Name Description
1 0.40522289276123 Initialise Initialise FSB Function
2 0.40719985961914 App Controller Start Start of the App controller (called before the controller of every page)
3 0.40995788574219 Start of getCategoryListByGroup Function Before first category groups query
4 0.4102418422699 After initial query Before first category groups query
5 0.41024398803711 Get Category List for Group Before the call to getCategoryList function
6 0.41024684906006 Start of GetCategoryList function Start of the function
7 0.41024994850159 Before getting categories Query to get specific category list
8 0.41052889823914 After getting categories Query to get specific category list
9 0.41053104400635 Before getting category custom Before call to function getCategoryCustom
10 0.41294097900391 After getting category custom After call to function getCategoryCustom
11 0.41294384002686 Before getting category custom Before call to function getCategoryCustom
12 0.42595887184143 After getting category custom After call to function getCategoryCustom
13 0.42596101760864 Before getting category custom Before call to function getCategoryCustom
14 0.4313600063324 After getting category custom After call to function getCategoryCustom
15 0.43136286735535 Before getting category custom Before call to function getCategoryCustom
16 0.43403887748718 After getting category custom After call to function getCategoryCustom
17 0.43404197692871 Before getting category custom Before call to function getCategoryCustom
18 0.43750190734863 After getting category custom After call to function getCategoryCustom
19 0.43750500679016 Before getting category custom Before call to function getCategoryCustom
20 0.44082283973694 After getting category custom After call to function getCategoryCustom
21 0.44082498550415 End of GetCategoryList function End of the function
22 0.44083285331726 End of getCategoryListByGroup Function Before return()
23 0.44578385353088 App Controller End End of the App controller (called before the controller of every page)
24 0.44654583930969 Product Start Start of the product info controller
25 0.44873404502869 Cache file not found Starting get product details
26 0.47199988365173 Related products Start getting related products if enabled
27 0.47200202941895 Related Products Start Before the related products are found
28 0.47200393676758 Related Products Keywords Before the related product keywords are found
29 0.47200798988342 Create Keyword List Function Start of function
30 0.47203993797302 Create Keyword List Function After looping provided content - 21 keywords found
31 0.4729528427124 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
32 0.47295999526978 Create Keyword List Function After reducing keyword list
33 0.47300696372986 Create Keyword List Function After selecting by scoring keywords
34 0.47301197052002 Create Keyword List Function After final loop of keywords
35 0.47301387786865 Related Products Keywords After the related product keywords are found
36 0.49358892440796 Related Products End After the related products are found
37 0.50273704528809 Product End End of the product info controller (Product Info)
38 0.50371503829956 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.50436401367188 Before Get Options Before the call to getOptions in the tpl class
40 0.53087687492371 After Get Options After the call to getOptions in the tpl class
41 0.53095602989197 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.53098297119141 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.54776382446289 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.54776787757874 Product Info: Before Template Display Before the template is displayed
45 0.57353901863098 Product Info: After Template Display After the template is displayed
46 0.57355093955994 Finalizing debug Before the debug is output to the page.
47 0.57357096672058 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1232 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0011 0.0010881423950195
SELECT parameter, value FROM parameters
2 0.0010 0.00097894668579102
SELECT * FROM `bad_bots`
3 0.0004 0.00038385391235352
SET time_zone = 'Europe/London'
4 0.0022 0.0022239685058594
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0017 0.0016558170318604
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.110.106\";}'
6 0.0013 0.0012650489807129
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627538940'
7 0.0005 0.00050997734069824
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.0002591609954834
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0003 0.00033092498779297
SELECT id FROM pages WHERE pagename = 'the-rooibos-chocolat-menthe-bio-bote-100g-tealodge' LIMIT 1
10 0.0006 0.00058388710021973
SELECT id FROM products WHERE pagename = 'the-rooibos-chocolat-menthe-bio-bote-100g-tealodge' AND hidden = 0 LIMIT 1
11 0.0010 0.00098896026611328
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00091099739074707
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0004 0.0004429817199707
SELECT * FROM pages WHERE pagename = 'the-rooibos-chocolat-menthe-bio-bote-100g-tealodge'
14 0.0003 0.00026988983154297
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0003 0.00025796890258789
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00031900405883789
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.00020503997802734
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.00017309188842773
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.00018811225891113
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.00041699409484863
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.0004 0.00036907196044922
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.00019192695617676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00020885467529297
SELECT * FROM categorygroups WHERE id = '1'
25 0.0056 0.0055539608001709
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.0002129077911377
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.00046801567077637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.0003669261932373
SELECT id FROM categories WHERE parent_id = '27'
29 0.0055 0.0055110454559326
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.00021505355834961
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.00018787384033203
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00021696090698242
SELECT * FROM categorygroups WHERE id = '1'
34 0.0021 0.0021231174468994
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.0003 0.0002751350402832
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.00023984909057617
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00018787384033203
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0016851425170898
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.0002129077911377
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.0001990795135498
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.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00018882751464844
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00048208236694336
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.00019097328186035
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.0003 0.00026917457580566
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00050711631774902
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.00022196769714355
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.00019502639770508
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.0003 0.00026297569274902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00023698806762695
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.0004730224609375
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.00018310546875
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.0007 0.00071001052856445
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00032496452331543
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.0007178783416748
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.00032615661621094
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.00022482872009277
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.0001988410949707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.0001978874206543
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00053095817565918
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.00037407875061035
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.0003359317779541
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00022196769714355
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00054597854614258
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.00023794174194336
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.00021004676818848
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.0004 0.00037622451782227
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00038385391235352
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.0002140998840332
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0004 0.00038385391235352
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0002 0.0002288818359375
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.00018405914306641
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0006 0.00060510635375977
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0004 0.00040221214294434
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00026702880859375
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.110.106') >= INET_ATON(ip_start) AND INET_ATON('3.236.110.106') <= INET_ATON(ip_end)
77 0.0002 0.00018596649169922
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00018501281738281
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.00058579444885254
SELECT * FROM products WHERE pagename = 'the-rooibos-chocolat-menthe-bio-bote-100g-tealodge'
80 0.0007 0.00069618225097656
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1126
81 0.0003 0.0003349781036377
SELECT * FROM manufacturers WHERE id = '252'
82 0.0006 0.0005500316619873
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '252'
83 0.0002 0.00018310546875
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '252' LIMIT 1
84 0.0007 0.00073385238647461
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '252' ORDER BY RAND() LIMIT 1
85 0.0003 0.00026893615722656
SELECT * FROM productimages WHERE product_id = '983' ORDER BY sortorder ASC
86 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '252'
87 0.0005 0.00048398971557617
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '252'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0002 0.0001988410949707
SELECT * FROM manufacturerimages WHERE manufacturer_id = '252'
89 0.0005 0.00046777725219727
SELECT category_id FROM products_categories WHERE product_id = '1126'
90 0.0004 0.00037980079650879
SELECT * FROM categories WHERE id = '27'
91 0.0046 0.0046401023864746
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.00033092498779297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '27'
94 0.0043 0.004288911819458
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.00034403800964355
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.00024604797363281
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.00020194053649902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.00020980834960938
SELECT * FROM productimages WHERE product_id = '1126' ORDER BY sortorder ASC
99 0.0005 0.00046014785766602
SELECT * FROM product_image_select WHERE product_id = '1126'
100 0.0004 0.00037598609924316
SELECT * FROM productcustomimages WHERE product_id = '1126'
101 0.0003 0.00034809112548828
SELECT * FROM productfeeds WHERE product_id = '1126' ORDER BY item_date DESC
102 0.0018 0.0018301010131836
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1126' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0011 0.0011060237884521
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1126' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00037407875061035
SELECT * FROM productamazoncontent WHERE product_id = '1126'
105 0.0014 0.0013589859008789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1126' AND a.name = n.originalname
106 0.0003 0.00033783912658691
SELECT * FROM productoffers WHERE product_id = '1126' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0006 0.00055408477783203
SELECT * FROM productoffers
                WHERE product_id = '1126' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0005 0.00049710273742676
SELECT * FROM productoffers
                WHERE product_id = 1126
                ORDER BY price ASC LIMIT 1
109 0.0003 0.00034308433532715
SELECT value FROM productattributes
                WHERE product_id = '1126'
                AND name = 'ListPriceAmount'
110 0.0004 0.00036907196044922
SELECT value FROM productattributes WHERE product_id = '1126' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0005 0.00045895576477051
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
112 0.0109 0.010856866836548
SELECT *, MATCH (description, title) AGAINST ('bote 100g tealodge' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('bote 100g tealodge' IN BOOLEAN MODE) AND 1126 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00056195259094238
SELECT *, MATCH (description, title) AGAINST ('bote 100g tealodge' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('bote 100g tealodge' IN BOOLEAN MODE) AND 1126 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0004 0.00042414665222168
SELECT *, MATCH (description, title) AGAINST ('bote 100g tealodge' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('bote 100g tealodge' IN BOOLEAN MODE) AND 1126 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0002 0.00017809867858887
SELECT * FROM productimages WHERE product_id = '1210' ORDER BY sortorder ASC
116 0.0002 0.0001828670501709
SELECT * FROM product_image_select WHERE product_id = '1210'
117 0.0002 0.00017499923706055
SELECT * FROM productcustomimages WHERE product_id = '1210'
118 0.0019 0.001910924911499
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1210' AND a.name = n.originalname
119 0.0004 0.00037097930908203
SELECT * FROM productoffers WHERE product_id = '1210' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00038003921508789
SELECT * FROM productoffers
                WHERE product_id = '1210' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0005 0.00045895576477051
SELECT value FROM productattributes WHERE product_id = '1210' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0004 0.00038504600524902
SELECT * FROM productimages WHERE product_id = '1118' ORDER BY sortorder ASC
123 0.0004 0.00036406517028809
SELECT * FROM product_image_select WHERE product_id = '1118'
124 0.0002 0.00021696090698242
SELECT * FROM productcustomimages WHERE product_id = '1118'
125 0.0003 0.00030303001403809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1118' AND a.name = n.originalname
126 0.0003 0.0002589225769043
SELECT * FROM productoffers WHERE product_id = '1118' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '1118' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '1118' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0003 0.00028300285339355
SELECT * FROM productimages WHERE product_id = '1127' ORDER BY sortorder ASC
130 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '1127'
131 0.0002 0.00020194053649902
SELECT * FROM productcustomimages WHERE product_id = '1127'
132 0.0005 0.00048613548278809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1127' AND a.name = n.originalname
133 0.0004 0.00037097930908203
SELECT * FROM productoffers WHERE product_id = '1127' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0004 0.00037908554077148
SELECT * FROM productoffers
                WHERE product_id = '1127' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0002 0.00024199485778809
SELECT value FROM productattributes WHERE product_id = '1127' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0003 0.00032401084899902
SELECT id,asin FROM products WHERE parent_id = 1126
137 0.0003 0.00027108192443848
SELECT category_id FROM products_categories WHERE product_id = '1126'
138 0.0004 0.00039196014404297
SELECT * FROM categories WHERE id = '27'
139 0.0002 0.00023102760314941
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
140 0.0002 0.00019192695617676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '27'
142 0.0002 0.00018501281738281
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 
143 0.0002 0.00017690658569336
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 
144 0.0004 0.00037908554077148
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
145 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0002 0.00023102760314941
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1126' AND a.name = n.originalname
147 0.0003 0.00027298927307129
SELECT * FROM productoffers WHERE product_id = '1126' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0003 0.00027108192443848
SELECT * FROM productoffers
                WHERE product_id = '1126' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = 1126
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00021982192993164
SELECT value FROM productattributes
                WHERE product_id = '1126'
                AND name = 'ListPriceAmount'
151 0.0008 0.00076103210449219
SELECT * FROM products WHERE id = '1126'
152 0.0002 0.00020503997802734
SELECT value FROM productattributes WHERE product_id = '1126' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0002 0.00018596649169922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1126' AND a.name = n.originalname
154 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '1126' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '1126' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0004 0.00040984153747559
SELECT * FROM productoffers
                WHERE product_id = 1126
                ORDER BY price ASC LIMIT 1
157 0.0004 0.00036907196044922
SELECT value FROM productattributes
                WHERE product_id = '1126'
                AND name = 'ListPriceAmount'
158 0.0004 0.00036907196044922
SELECT category_id FROM products_categories WHERE product_id = '1126' AND prod_type = 'amz'
159 0.0002 0.00018596649169922
SELECT parent_id FROM categories WHERE id = '27'
160 0.0006 0.00062417984008789
SELECT * FROM categories WHERE id = '27'
161 0.0002 0.00024700164794922
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
162 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0002 0.00017094612121582
SELECT id FROM categories WHERE parent_id = '27'
164 0.0002 0.00016212463378906
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 
165 0.0002 0.00019097328186035
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 
166 0.0004 0.00039291381835938
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
167 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0002 0.00023293495178223
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0002 0.0001680850982666
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0004 0.00041699409484863
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0003 0.00028896331787109
SELECT * FROM pages WHERE id = 38
172 0.0036 0.0035500526428223
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
173 0.0006 0.00055098533630371
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:1627538940;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:10:\"808|amazon\";i:4;s:10:\"810|amazon\";i:5;s:11:\"4947|amazon\";}}' WHERE id = '160'
174 0.0004 0.00041413307189941
SELECT * FROM products WHERE id = 790
175 0.0005 0.0004580020904541
SELECT * FROM products WHERE id = 788
176 0.0004 0.00040698051452637
SELECT * FROM products WHERE id = 787
177 0.0004 0.00041508674621582
SELECT * FROM products WHERE id = 808
178 0.0004 0.00042581558227539
SELECT * FROM products WHERE id = 810
179 0.0004 0.00036811828613281
SELECT * FROM products WHERE id = 4947
180 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = '790'
181 0.0004 0.0003819465637207
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
182 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '790'
183 0.0002 0.00017786026000977
SELECT * FROM productcustomimages WHERE product_id = '790'
184 0.0002 0.00018787384033203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
185 0.0003 0.00032687187194824
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0002 0.00023889541625977
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0002 0.00020599365234375
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0004 0.00037002563476562
SELECT * FROM products WHERE id = '788'
189 0.0002 0.00020694732666016
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0004 0.0004429817199707
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0004 0.00037384033203125
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0003 0.00029706954956055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
193 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0003 0.0003049373626709
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0005 0.00046706199645996
SELECT * FROM products WHERE id = '787'
197 0.0003 0.0002739429473877
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0002 0.00018906593322754
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0002 0.00017499923706055
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0003 0.00027203559875488
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
201 0.0004 0.00042390823364258
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0004 0.00039100646972656
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0003 0.00027799606323242
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0005 0.00046586990356445
SELECT * FROM products WHERE id = '808'
205 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '808' ORDER BY sortorder ASC
206 0.0004 0.00038695335388184
SELECT * FROM product_image_select WHERE product_id = '808'
207 0.0004 0.00037479400634766
SELECT * FROM productcustomimages WHERE product_id = '808'
208 0.0003 0.00030922889709473
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '808' AND a.name = n.originalname
209 0.0002 0.00019621849060059
SELECT * FROM productoffers WHERE product_id = '808' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0004 0.00038003921508789
SELECT * FROM productoffers
                WHERE product_id = '808' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0004 0.00044584274291992
SELECT value FROM productattributes WHERE product_id = '808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0006 0.00058078765869141
SELECT * FROM products WHERE id = '810'
213 0.0004 0.00037717819213867
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
214 0.0002 0.00023508071899414
SELECT * FROM product_image_select WHERE product_id = '810'
215 0.0002 0.0002131462097168
SELECT * FROM productcustomimages WHERE product_id = '810'
216 0.0004 0.00037908554077148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
217 0.0004 0.00036501884460449
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0003 0.0002589225769043
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0002 0.00018095970153809
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0004 0.0004270076751709
SELECT * FROM products WHERE id = '4947'
221 0.0003 0.0003049373626709
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
222 0.0004 0.00040102005004883
SELECT * FROM product_image_select WHERE product_id = '4947'
223 0.0003 0.00025200843811035
SELECT * FROM productcustomimages WHERE product_id = '4947'
224 0.0002 0.00020480155944824
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
225 0.0002 0.00021600723266602
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0002 0.00020813941955566
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0002 0.0001990795135498
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0002 0.00023508071899414
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0003 0.00029683113098145
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0009 0.00094199180603027
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0004 0.00036215782165527
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0003 0.00029683113098145
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0007 0.00070500373840332
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0003 0.00034809112548828
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0004 0.00037002563476562
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'