Tick ??Tock origine Thé Rooibos (40) - Paquet de 2

Tick ??Tock origine Thé Rooibos (40) - Paquet de 2
Tick ??Tock origine Thé Rooibos (40) - Paquet de 2 Tick ??Tock origine Thé Rooibos (40) - Paquet de 2 (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-26 16:26:32 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.61037302017212 235 0.1283 0


No Amazon API Requests Made.

Total time 0.61037302017212 seconds

Number Time From Start Name Description
1 0.41524195671082 Initialise Initialise FSB Function
2 0.41789889335632 App Controller Start Start of the App controller (called before the controller of every page)
3 0.42152190208435 Start of getCategoryListByGroup Function Before first category groups query
4 0.421954870224 After initial query Before first category groups query
5 0.42195796966553 Get Category List for Group Before the call to getCategoryList function
6 0.42196202278137 Start of GetCategoryList function Start of the function
7 0.42196702957153 Before getting categories Query to get specific category list
8 0.42242097854614 After getting categories Query to get specific category list
9 0.42242288589478 Before getting category custom Before call to function getCategoryCustom
10 0.44180798530579 After getting category custom After call to function getCategoryCustom
11 0.44181299209595 Before getting category custom Before call to function getCategoryCustom
12 0.44374084472656 After getting category custom After call to function getCategoryCustom
13 0.44374299049377 Before getting category custom Before call to function getCategoryCustom
14 0.44829988479614 After getting category custom After call to function getCategoryCustom
15 0.44830203056335 Before getting category custom Before call to function getCategoryCustom
16 0.45068693161011 After getting category custom After call to function getCategoryCustom
17 0.45069098472595 Before getting category custom Before call to function getCategoryCustom
18 0.45333480834961 After getting category custom After call to function getCategoryCustom
19 0.45333695411682 Before getting category custom Before call to function getCategoryCustom
20 0.45598602294922 After getting category custom After call to function getCategoryCustom
21 0.45598888397217 End of GetCategoryList function End of the function
22 0.45601201057434 End of getCategoryListByGroup Function Before return()
23 0.46144104003906 App Controller End End of the App controller (called before the controller of every page)
24 0.46240282058716 Product Start Start of the product info controller
25 0.46513891220093 Cache file not found Starting get product details
26 0.48560786247253 Related products Start getting related products if enabled
27 0.48561000823975 Related Products Start Before the related products are found
28 0.48561191558838 Related Products Keywords Before the related product keywords are found
29 0.48561692237854 Create Keyword List Function Start of function
30 0.48574280738831 Create Keyword List Function After looping provided content - 24 keywords found
31 0.48672890663147 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
32 0.48673796653748 Create Keyword List Function After reducing keyword list
33 0.48682689666748 Create Keyword List Function After selecting by scoring keywords
34 0.48683381080627 Create Keyword List Function After final loop of keywords
35 0.4868369102478 Related Products Keywords After the related product keywords are found
36 0.50232100486755 Related Products End After the related products are found
37 0.51041984558105 Product End End of the product info controller (Product Info)
38 0.51159596443176 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.51489400863647 Before Get Options Before the call to getOptions in the tpl class
40 0.55570292472839 After Get Options After the call to getOptions in the tpl class
41 0.55588293075562 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.55591583251953 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.57639002799988 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.5763988494873 Product Info: Before Template Display Before the template is displayed
45 0.61033797264099 Product Info: After Template Display After the template is displayed
46 0.61035799980164 Finalizing debug Before the debug is output to the page.
47 0.61037182807922 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1283 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.0008089542388916
SELECT parameter, value FROM parameters
2 0.0008 0.00077319145202637
SELECT * FROM `bad_bots`
3 0.0002 0.00020098686218262
SET time_zone = 'Europe/London'
4 0.0002 0.00023293495178223
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0016 0.0016191005706787
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.110.106\";}'
6 0.0009 0.00092196464538574
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627537238'
7 0.0004 0.00039410591125488
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00030803680419922
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.0006248950958252
SELECT id FROM pages WHERE pagename = 'tick-tock-origine-the-rooibos-40-paquet-de-2' LIMIT 1
10 0.0008 0.00075602531433105
SELECT id FROM products WHERE pagename = 'tick-tock-origine-the-rooibos-40-paquet-de-2' AND hidden = 0 LIMIT 1
11 0.0015 0.0015120506286621
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0010 0.00099587440490723
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0005 0.0005340576171875
SELECT * FROM pages WHERE pagename = 'tick-tock-origine-the-rooibos-40-paquet-de-2'
14 0.0004 0.00041699409484863
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.0101 0.010138988494873
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.0003 0.00025105476379395
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.00022506713867188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00031685829162598
SELECT id FROM categories WHERE parent_id = '26'
20 0.0074 0.0074379444122314
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.00023484230041504
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.00019121170043945
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.0001981258392334
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00020503997802734
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00020289421081543
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.00021219253540039
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.00021505355834961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '27'
29 0.0002 0.00019192695617676
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.00022792816162109
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.00018596649169922
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.00019192695617676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00017809867858887
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016100406646729
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.00018620491027832
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.00019001960754395
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00018000602722168
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0015230178833008
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.00020480155944824
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.00016283988952637
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.00019383430480957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00019693374633789
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00047802925109863
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.0001828670501709
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.00020194053649902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00017118453979492
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00049901008605957
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.00020098686218262
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.00018596649169922
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.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00016498565673828
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00046491622924805
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.0003 0.00027704238891602
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.00023603439331055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00019097328186035
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.0004889965057373
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.00020098686218262
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.0001828670501709
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.00017309188842773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00029706954956055
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00052714347839355
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.00017499923706055
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.00017881393432617
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00062203407287598
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.00019097328186035
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.00018787384033203
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.00017786026000977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00019693374633789
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00030183792114258
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0002 0.00024890899658203
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00026702880859375
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.0002129077911377
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0004 0.00042891502380371
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00054693222045898
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.0003359317779541
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.00019621849060059
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00029110908508301
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0005 0.00050902366638184
SELECT * FROM products WHERE pagename = 'tick-tock-origine-the-rooibos-40-paquet-de-2'
80 0.0010 0.00096583366394043
UPDATE products SET viewcount = viewcount + 1 WHERE id = 921
81 0.0003 0.00026607513427734
SELECT * FROM manufacturers WHERE id = '168'
82 0.0005 0.00050210952758789
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '168'
83 0.0002 0.00021481513977051
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '168' LIMIT 1
84 0.0008 0.00083613395690918
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '168' ORDER BY RAND() LIMIT 1
85 0.0002 0.00022411346435547
SELECT * FROM productimages WHERE product_id = '1435' ORDER BY sortorder ASC
86 0.0002 0.00023102760314941
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '168'
87 0.0005 0.00047111511230469
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '168'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0002 0.00017905235290527
SELECT * FROM manufacturerimages WHERE manufacturer_id = '168'
89 0.0004 0.00042605400085449
SELECT category_id FROM products_categories WHERE product_id = '921'
90 0.0002 0.0002448558807373
SELECT * FROM categories WHERE id = '27'
91 0.0041 0.0041229724884033
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.00020980834960938
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '27'
94 0.0041 0.0041091442108154
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.00027608871459961
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.00020194053649902
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.0001838207244873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0012 0.0012319087982178
SELECT * FROM productimages WHERE product_id = '921' ORDER BY sortorder ASC
99 0.0004 0.00044107437133789
SELECT * FROM product_image_select WHERE product_id = '921'
100 0.0003 0.00034189224243164
SELECT * FROM productcustomimages WHERE product_id = '921'
101 0.0003 0.00034499168395996
SELECT * FROM productfeeds WHERE product_id = '921' ORDER BY item_date DESC
102 0.0005 0.00054812431335449
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '921' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0005 0.00050997734069824
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '921' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00040602684020996
SELECT * FROM productamazoncontent WHERE product_id = '921'
105 0.0008 0.00082087516784668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '921' AND a.name = n.originalname
106 0.0004 0.00043201446533203
SELECT * FROM productoffers WHERE product_id = '921' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0004 0.0003969669342041
SELECT * FROM productoffers
                WHERE product_id = '921' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0003 0.0003359317779541
SELECT * FROM productoffers
                WHERE product_id = 921
                ORDER BY price ASC LIMIT 1
109 0.0003 0.00032901763916016
SELECT value FROM productattributes
                WHERE product_id = '921'
                AND name = 'ListPriceAmount'
110 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '921' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0002 0.00023698806762695
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.0078 0.0078048706054688
SELECT *, MATCH (description, title) AGAINST ('rooibos 40 paquet' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos 40 paquet' IN BOOLEAN MODE) AND 921 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0008 0.000823974609375
SELECT *, MATCH (description, title) AGAINST ('rooibos 40 paquet' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos 40 paquet' IN BOOLEAN MODE) AND 921 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0007 0.00072503089904785
SELECT *, MATCH (description, title) AGAINST ('rooibos 40 paquet' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos 40 paquet' IN BOOLEAN MODE) AND 921 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0005 0.00046801567077637
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
116 0.0002 0.00023293495178223
SELECT * FROM product_image_select WHERE product_id = '862'
117 0.0003 0.0002748966217041
SELECT * FROM productcustomimages WHERE product_id = '862'
118 0.0002 0.00023698806762695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
119 0.0002 0.00021982192993164
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0003 0.0003049373626709
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0002 0.00021886825561523
SELECT * FROM productimages WHERE product_id = '937' ORDER BY sortorder ASC
123 0.0002 0.00019216537475586
SELECT * FROM product_image_select WHERE product_id = '937'
124 0.0002 0.00019001960754395
SELECT * FROM productcustomimages WHERE product_id = '937'
125 0.0002 0.00021910667419434
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '937' AND a.name = n.originalname
126 0.0002 0.0002131462097168
SELECT * FROM productoffers WHERE product_id = '937' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0003 0.00026202201843262
SELECT * FROM productoffers
                WHERE product_id = '937' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0002 0.00019288063049316
SELECT value FROM productattributes WHERE product_id = '937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0003 0.00030398368835449
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
130 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '1010'
131 0.0002 0.00023889541625977
SELECT * FROM productcustomimages WHERE product_id = '1010'
132 0.0002 0.00022506713867188
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1010' AND a.name = n.originalname
133 0.0002 0.0002138614654541
SELECT * FROM productoffers WHERE product_id = '1010' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0003 0.0002739429473877
SELECT * FROM productoffers
                WHERE product_id = '1010' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0002 0.00021910667419434
SELECT value FROM productattributes WHERE product_id = '1010' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0003 0.00028586387634277
SELECT id,asin FROM products WHERE parent_id = 921
137 0.0003 0.00028300285339355
SELECT category_id FROM products_categories WHERE product_id = '921'
138 0.0002 0.00023889541625977
SELECT * FROM categories WHERE id = '27'
139 0.0002 0.00018000602722168
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.00020885467529297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0002 0.00018191337585449
SELECT id FROM categories WHERE parent_id = '27'
142 0.0002 0.00020694732666016
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.00024604797363281
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.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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
145 0.0002 0.0001981258392334
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0002 0.00020813941955566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '921' AND a.name = n.originalname
147 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '921' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0003 0.00030398368835449
SELECT * FROM productoffers
                WHERE product_id = '921' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = 921
                ORDER BY price ASC LIMIT 1
150 0.0003 0.00025820732116699
SELECT value FROM productattributes
                WHERE product_id = '921'
                AND name = 'ListPriceAmount'
151 0.0004 0.0004119873046875
SELECT * FROM products WHERE id = '921'
152 0.0003 0.00031590461730957
SELECT value FROM productattributes WHERE product_id = '921' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0002 0.00024914741516113
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '921' AND a.name = n.originalname
154 0.0002 0.00020980834960938
SELECT * FROM productoffers WHERE product_id = '921' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0005 0.0004889965057373
SELECT * FROM productoffers
                WHERE product_id = '921' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = 921
                ORDER BY price ASC LIMIT 1
157 0.0002 0.00018405914306641
SELECT value FROM productattributes
                WHERE product_id = '921'
                AND name = 'ListPriceAmount'
158 0.0003 0.00032901763916016
SELECT category_id FROM products_categories WHERE product_id = '921' AND prod_type = 'amz'
159 0.0002 0.0001990795135498
SELECT parent_id FROM categories WHERE id = '27'
160 0.0002 0.00022506713867188
SELECT * FROM categories WHERE id = '27'
161 0.0002 0.00017905235290527
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.00020694732666016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '27'
164 0.0002 0.00018715858459473
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.00019598007202148
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.0002 0.00018692016601562
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0004 0.00036311149597168
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0002 0.00021719932556152
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0002 0.00023794174194336
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0003 0.00030684471130371
SELECT * FROM pages WHERE id = 38
172 0.0041 0.0041019916534424
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.00063109397888184
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:1627537239;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.0007 0.00072693824768066
SELECT * FROM products WHERE id = 790
175 0.0007 0.00071382522583008
SELECT * FROM products WHERE id = 788
176 0.0006 0.00064182281494141
SELECT * FROM products WHERE id = 787
177 0.0006 0.00063610076904297
SELECT * FROM products WHERE id = 808
178 0.0006 0.00058698654174805
SELECT * FROM products WHERE id = 810
179 0.0007 0.00069212913513184
SELECT * FROM products WHERE id = 4947
180 0.0006 0.00056314468383789
SELECT * FROM products WHERE id = '790'
181 0.0005 0.00045990943908691
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
182 0.0004 0.00035905838012695
SELECT * FROM product_image_select WHERE product_id = '790'
183 0.0003 0.00031208992004395
SELECT * FROM productcustomimages WHERE product_id = '790'
184 0.0002 0.00022101402282715
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.00026082992553711
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0003 0.0003058910369873
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0005 0.0005180835723877
SELECT * FROM products WHERE id = '788'
189 0.0002 0.00023603439331055
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0003 0.0003049373626709
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0003 0.00030899047851562
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0003 0.00030612945556641
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.0002288818359375
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0003 0.00032305717468262
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0003 0.00031709671020508
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0007 0.0007169246673584
SELECT * FROM products WHERE id = '787'
197 0.0005 0.00052499771118164
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0004 0.00035691261291504
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0005 0.00054621696472168
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0006 0.00063896179199219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
201 0.0006 0.00055599212646484
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0006 0.00055193901062012
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0005 0.00051093101501465
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0009 0.00092792510986328
SELECT * FROM products WHERE id = '808'
205 0.0006 0.00061798095703125
SELECT * FROM productimages WHERE product_id = '808' ORDER BY sortorder ASC
206 0.0007 0.0007319450378418
SELECT * FROM product_image_select WHERE product_id = '808'
207 0.0007 0.00074601173400879
SELECT * FROM productcustomimages WHERE product_id = '808'
208 0.0008 0.00084686279296875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '808' AND a.name = n.originalname
209 0.0007 0.00073790550231934
SELECT * FROM productoffers WHERE product_id = '808' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0006 0.0005638599395752
SELECT * FROM productoffers
                WHERE product_id = '808' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0009 0.00092101097106934
SELECT value FROM productattributes WHERE product_id = '808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0009 0.00093603134155273
SELECT * FROM products WHERE id = '810'
213 0.0011 0.0011029243469238
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
214 0.0009 0.00091099739074707
SELECT * FROM product_image_select WHERE product_id = '810'
215 0.0007 0.0007481575012207
SELECT * FROM productcustomimages WHERE product_id = '810'
216 0.0011 0.001060962677002
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
217 0.0011 0.0011410713195801
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0011 0.0011420249938965
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0003 0.0003349781036377
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0007 0.00068902969360352
SELECT * FROM products WHERE id = '4947'
221 0.0003 0.00031685829162598
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
222 0.0003 0.00029802322387695
SELECT * FROM product_image_select WHERE product_id = '4947'
223 0.0002 0.00024294853210449
SELECT * FROM productcustomimages WHERE product_id = '4947'
224 0.0003 0.00026917457580566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
225 0.0003 0.00025200843811035
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.00027894973754883
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0002 0.00022506713867188
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0003 0.00034594535827637
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0003 0.00031495094299316
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0006 0.00059795379638672
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0005 0.00046801567077637
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0005 0.00046396255493164
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0004 0.00042104721069336
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0005 0.00048089027404785
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0003 0.0003359317779541
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'