Rooibos sauvage en vrac bio & équitable

Rooibos sauvage en vrac bio & équitable
Rooibos sauvage en vrac bio & équitable Rooibos sauvage en vrac bio & équitable Rooibos sauvage en vrac bio & équitable Rooibos sauvage en vrac bio & équitable Rooibos sauvage en vrac bio & équitable (cliquez sur les images pour élargir)
€11,09
Le prix et la disponibilité du produit sont corrects en date du 2022-05-17 16:28:53 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.87124800682068 239 0.1645 0


No Amazon API Requests Made.

Total time 0.87124800682068 seconds

Number Time From Start Name Description
1 0.6647469997406 Initialise Initialise FSB Function
2 0.66703581809998 App Controller Start Start of the App controller (called before the controller of every page)
3 0.67079281806946 Start of getCategoryListByGroup Function Before first category groups query
4 0.6711118221283 After initial query Before first category groups query
5 0.67111396789551 Get Category List for Group Before the call to getCategoryList function
6 0.67111802101135 Start of GetCategoryList function Start of the function
7 0.67112183570862 Before getting categories Query to get specific category list
8 0.67149186134338 After getting categories Query to get specific category list
9 0.6714940071106 Before getting category custom Before call to function getCategoryCustom
10 0.69052481651306 After getting category custom After call to function getCategoryCustom
11 0.69052982330322 Before getting category custom Before call to function getCategoryCustom
12 0.69322395324707 After getting category custom After call to function getCategoryCustom
13 0.69322681427002 Before getting category custom Before call to function getCategoryCustom
14 0.69917988777161 After getting category custom After call to function getCategoryCustom
15 0.69918394088745 Before getting category custom Before call to function getCategoryCustom
16 0.70289993286133 After getting category custom After call to function getCategoryCustom
17 0.70290303230286 Before getting category custom Before call to function getCategoryCustom
18 0.70679497718811 After getting category custom After call to function getCategoryCustom
19 0.70679903030396 Before getting category custom Before call to function getCategoryCustom
20 0.71047687530518 After getting category custom After call to function getCategoryCustom
21 0.71048188209534 End of GetCategoryList function End of the function
22 0.71049404144287 End of getCategoryListByGroup Function Before return()
23 0.71734404563904 App Controller End End of the App controller (called before the controller of every page)
24 0.7176079750061 Product Start Start of the product info controller
25 0.72800087928772 Cache file not found Starting get product details
26 0.75679397583008 Related products Start getting related products if enabled
27 0.75679588317871 Related Products Start Before the related products are found
28 0.75679683685303 Related Products Keywords Before the related product keywords are found
29 0.75680088996887 Create Keyword List Function Start of function
30 0.75682592391968 Create Keyword List Function After looping provided content - 18 keywords found
31 0.75757193565369 Create Keyword List Function After looping initial keyword list - 16 keywords remaining
32 0.75757884979248 Create Keyword List Function After reducing keyword list
33 0.75761485099792 Create Keyword List Function After selecting by scoring keywords
34 0.75761795043945 Create Keyword List Function After final loop of keywords
35 0.75761985778809 Related Products Keywords After the related product keywords are found
36 0.79571199417114 Related Products End After the related products are found
37 0.80622291564941 Product End End of the product info controller (Product Info)
38 0.80683302879333 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.80743002891541 Before Get Options Before the call to getOptions in the tpl class
40 0.84016704559326 After Get Options After the call to getOptions in the tpl class
41 0.84027504920959 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.84030485153198 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.85170292854309 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.85170984268188 Product Info: Before Template Display Before the template is displayed
45 0.87122702598572 Product Info: After Template Display After the template is displayed
46 0.87123394012451 Finalizing debug Before the debug is output to the page.
47 0.87124681472778 End of App This is the end of the app logging, final timestamp


Query Debug - 239 Database Queries. Total time 0.1645 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.000762939453125
SELECT parameter, value FROM parameters
2 0.0013 0.0012519359588623
SELECT * FROM `bad_bots`
3 0.0005 0.00049114227294922
SET time_zone = 'Europe/London'
4 0.0005 0.00054502487182617
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0022 0.0021989345550537
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.238.180.255\";}'
6 0.0015 0.0014870166778564
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653088880'
7 0.0006 0.00058484077453613
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00036883354187012
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.00073695182800293
SELECT id FROM pages WHERE pagename = 'rooibos-sauvage-en-vrac-bio-equitable' LIMIT 1
10 0.0007 0.0006861686706543
SELECT id FROM products WHERE pagename = 'rooibos-sauvage-en-vrac-bio-equitable' AND hidden = 0 LIMIT 1
11 0.0015 0.0014510154724121
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.00063800811767578
SELECT * FROM pages WHERE pagename = 'rooibos-sauvage-en-vrac-bio-equitable'
14 0.0003 0.00030398368835449
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0003 0.00034499168395996
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0099 0.0099399089813232
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.00029802322387695
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.000244140625
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00033998489379883
SELECT id FROM categories WHERE parent_id = '26'
20 0.0067 0.0067400932312012
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.00038695335388184
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.00028705596923828
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.0003 0.0002748966217041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00034713745117188
SELECT * FROM categorygroups WHERE id = '1'
25 0.0003 0.00033116340637207
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.00025010108947754
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.0002439022064209
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00026798248291016
SELECT id FROM categories WHERE parent_id = '27'
29 0.0003 0.00026392936706543
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.00028395652770996
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.0003 0.00028300285339355
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.0003 0.00031185150146484
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.0003211498260498
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0016560554504395
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.0006 0.00061702728271484
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.00031709671020508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00030994415283203
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0016958713531494
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.00031685829162598
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0004 0.0003509521484375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0003 0.00025010108947754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00028395652770996
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00060105323791504
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.00030612945556641
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.00032901763916016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00026202201843262
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00084900856018066
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.00028896331787109
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.00025296211242676
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0004 0.00035285949707031
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00034499168395996
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.0007021427154541
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.00033092498779297
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.00024700164794922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00028204917907715
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00070691108703613
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.00029706954956055
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.0004 0.0003821849822998
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.0004 0.00036406517028809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00044608116149902
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.0008091926574707
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.0003 0.00029802322387695
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.00028395652770996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00030112266540527
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00068497657775879
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0003 0.00032901763916016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0003 0.00026392936706543
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0003 0.00028395652770996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00028395652770996
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00031185150146484
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00032806396484375
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0005 0.00045514106750488
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.0003 0.00029206275939941
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0010 0.00096702575683594
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0008 0.00075197219848633
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0004 0.00038599967956543
SELECT * FROM ipgeocountries WHERE INET_ATON('3.238.180.255') >= INET_ATON(ip_start) AND INET_ATON('3.238.180.255') <= INET_ATON(ip_end)
77 0.0006 0.00057411193847656
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0005 0.0005488395690918
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0010 0.00096392631530762
SELECT * FROM products WHERE pagename = 'rooibos-sauvage-en-vrac-bio-equitable'
80 0.0011 0.0011410713195801
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1087
81 0.0006 0.00057196617126465
SELECT * FROM manufacturers WHERE id = '261'
82 0.0011 0.0010919570922852
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
83 0.0008 0.00078010559082031
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '261' LIMIT 1
84 0.0012 0.0011940002441406
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '261' ORDER BY RAND() LIMIT 1
85 0.0004 0.00040388107299805
SELECT * FROM productimages WHERE product_id = '4678' ORDER BY sortorder ASC
86 0.0003 0.00028300285339355
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
87 0.0008 0.00076603889465332
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '261'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0003 0.00033211708068848
SELECT * FROM manufacturerimages WHERE manufacturer_id = '261'
89 0.0006 0.00061511993408203
SELECT category_id FROM products_categories WHERE product_id = '1087'
90 0.0005 0.00047898292541504
SELECT * FROM categories WHERE id = '27'
91 0.0068 0.0068070888519287
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.0006 0.00057387351989746
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0004 0.00036716461181641
SELECT id FROM categories WHERE parent_id = '27'
94 0.0045 0.0044660568237305
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.00028800964355469
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.00024795532226562
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
97 0.0003 0.00027704238891602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0003 0.00033307075500488
SELECT * FROM productimages WHERE product_id = '1087' ORDER BY sortorder ASC
99 0.0003 0.00032997131347656
SELECT * FROM product_image_select WHERE product_id = '1087'
100 0.0003 0.00032687187194824
SELECT * FROM productcustomimages WHERE product_id = '1087'
101 0.0004 0.00039982795715332
SELECT * FROM productfeeds WHERE product_id = '1087' ORDER BY item_date DESC
102 0.0022 0.002208948135376
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1087' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0005 0.0004880428314209
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1087' AND t.hidden = 0 AND display_product = 1
104 0.0009 0.00093889236450195
SELECT * FROM productamazoncontent WHERE product_id = '1087'
105 0.0012 0.0012228488922119
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1087' AND a.name = n.originalname
106 0.0005 0.00054407119750977
SELECT * FROM productoffers WHERE product_id = '1087' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0006 0.00061798095703125
SELECT * FROM productoffers
                WHERE product_id = '1087' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0006 0.00057697296142578
SELECT value FROM productattributes WHERE product_id = '1087' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0004 0.00040912628173828
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
110 0.0106 0.010579824447632
SELECT *, MATCH (description, title) AGAINST ('bio andamp équitable' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('bio andamp équitable' IN BOOLEAN MODE) AND 1087 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
111 0.0009 0.00092005729675293
SELECT *, MATCH (description, title) AGAINST ('bio andamp équitable' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('bio andamp équitable' IN BOOLEAN MODE) AND 1087 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
112 0.0007 0.00069713592529297
SELECT *, MATCH (description, title) AGAINST ('bio andamp équitable' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('bio andamp équitable' IN BOOLEAN MODE) AND 1087 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
113 0.0005 0.00052499771118164
SELECT * FROM productimages WHERE product_id = '1140' ORDER BY sortorder ASC
114 0.0004 0.00036311149597168
SELECT * FROM product_image_select WHERE product_id = '1140'
115 0.0003 0.00028800964355469
SELECT * FROM productcustomimages WHERE product_id = '1140'
116 0.0034 0.0034070014953613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1140' AND a.name = n.originalname
117 0.0008 0.00075411796569824
SELECT * FROM productoffers WHERE product_id = '1140' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0008 0.00077009201049805
SELECT * FROM productoffers
                WHERE product_id = '1140' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0007 0.0007481575012207
SELECT value FROM productattributes WHERE product_id = '1140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0003 0.00029802322387695
SELECT * FROM productimages WHERE product_id = '1087' ORDER BY sortorder ASC
121 0.0003 0.00034713745117188
SELECT * FROM product_image_select WHERE product_id = '1087'
122 0.0004 0.00038504600524902
SELECT * FROM productcustomimages WHERE product_id = '1087'
123 0.0004 0.00044393539428711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1087' AND a.name = n.originalname
124 0.0003 0.00032401084899902
SELECT * FROM productoffers WHERE product_id = '1087' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0003 0.0003049373626709
SELECT * FROM productoffers
                WHERE product_id = '1087' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.0003049373626709
SELECT value FROM productattributes WHERE product_id = '1087' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0003 0.00029206275939941
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
128 0.0003 0.00034189224243164
SELECT * FROM product_image_select WHERE product_id = '1215'
129 0.0003 0.00026297569274902
SELECT * FROM productcustomimages WHERE product_id = '1215'
130 0.0010 0.0010359287261963
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1215' AND a.name = n.originalname
131 0.0006 0.00057506561279297
SELECT * FROM productoffers WHERE product_id = '1215' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0006 0.00063300132751465
SELECT * FROM productoffers
                WHERE product_id = '1215' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0006 0.00055718421936035
SELECT value FROM productattributes WHERE product_id = '1215' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0082 0.0081570148468018
SELECT *, MATCH (description, title) AGAINST ('rooibos sauvage en' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos sauvage en' IN BOOLEAN MODE) AND 1087 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
135 0.0007 0.00073790550231934
SELECT *, MATCH (description, title) AGAINST ('rooibos sauvage en' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos sauvage en' IN BOOLEAN MODE) AND 1087 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
136 0.0005 0.00048685073852539
SELECT *, MATCH (description, title) AGAINST ('rooibos sauvage en' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos sauvage en' IN BOOLEAN MODE) AND 1087 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
137 0.0003 0.00026512145996094
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
138 0.0004 0.00038290023803711
SELECT * FROM product_image_select WHERE product_id = '878'
139 0.0003 0.00030088424682617
SELECT * FROM productcustomimages WHERE product_id = '878'
140 0.0005 0.00047588348388672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
141 0.0003 0.00032305717468262
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0003 0.00027108192443848
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0003 0.00025391578674316
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0005 0.00049614906311035
SELECT id,asin FROM products WHERE parent_id = 1087
145 0.0003 0.00034785270690918
SELECT category_id FROM products_categories WHERE product_id = '1087'
146 0.0003 0.00028085708618164
SELECT * FROM categories WHERE id = '27'
147 0.0002 0.00023007392883301
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
148 0.0003 0.00027108192443848
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
149 0.0004 0.00035405158996582
SELECT id FROM categories WHERE parent_id = '27'
150 0.0004 0.00042605400085449
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 
151 0.0004 0.00041985511779785
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 
152 0.0004 0.0004119873046875
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
153 0.0003 0.00034999847412109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
154 0.0003 0.00026512145996094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1087' AND a.name = n.originalname
155 0.0004 0.00038719177246094
SELECT * FROM productoffers WHERE product_id = '1087' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0003 0.00032210350036621
SELECT * FROM productoffers
                WHERE product_id = '1087' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0006 0.00060582160949707
SELECT * FROM products WHERE id = '1087'
158 0.0003 0.00031709671020508
SELECT value FROM productattributes WHERE product_id = '1087' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0003 0.00028491020202637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1087' AND a.name = n.originalname
160 0.0004 0.00039196014404297
SELECT * FROM productoffers WHERE product_id = '1087' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0003 0.00030279159545898
SELECT * FROM productoffers
                WHERE product_id = '1087' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0007 0.0006568431854248
SELECT category_id FROM products_categories WHERE product_id = '1087' AND prod_type = 'amz'
163 0.0005 0.00047492980957031
SELECT parent_id FROM categories WHERE id = '27'
164 0.0004 0.00041103363037109
SELECT * FROM categories WHERE id = '27'
165 0.0003 0.00025701522827148
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
166 0.0003 0.00026893615722656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
167 0.0003 0.00032496452331543
SELECT id FROM categories WHERE parent_id = '27'
168 0.0003 0.00030684471130371
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 
169 0.0003 0.00029397010803223
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 
170 0.0003 0.00026893615722656
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
171 0.0003 0.00028085708618164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
172 0.0003 0.00032401084899902
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
173 0.0003 0.00025510787963867
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
174 0.0003 0.0002598762512207
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
175 0.0003 0.0003349781036377
SELECT * FROM pages WHERE id = 38
176 0.0056 0.0055630207061768
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
177 0.0010 0.0010311603546143
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:1653088881;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'
178 0.0006 0.00056195259094238
SELECT * FROM products WHERE id = 788
179 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = 787
180 0.0005 0.00052595138549805
SELECT * FROM products WHERE id = 1287
181 0.0005 0.00053787231445312
SELECT * FROM products WHERE id = 780
182 0.0007 0.00071287155151367
SELECT * FROM products WHERE id = 777
183 0.0012 0.001162052154541
SELECT * FROM products WHERE id = 776
184 0.0007 0.00069999694824219
SELECT * FROM products WHERE id = '788'
185 0.0003 0.00028896331787109
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
186 0.0003 0.00025796890258789
SELECT * FROM product_image_select WHERE product_id = '788'
187 0.0003 0.00032806396484375
SELECT * FROM productcustomimages WHERE product_id = '788'
188 0.0003 0.00034904479980469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
189 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
190 0.0003 0.00032210350036621
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0003 0.00033998489379883
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0005 0.00048112869262695
SELECT * FROM products WHERE id = '787'
193 0.0003 0.00030803680419922
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
194 0.0003 0.00026917457580566
SELECT * FROM product_image_select WHERE product_id = '787'
195 0.0003 0.00025510787963867
SELECT * FROM productcustomimages WHERE product_id = '787'
196 0.0003 0.00034403800964355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
197 0.0003 0.00033903121948242
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0003 0.00032496452331543
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0003 0.00025701522827148
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0006 0.00058698654174805
SELECT * FROM products WHERE id = '1287'
201 0.0003 0.00033402442932129
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
202 0.0003 0.00027585029602051
SELECT * FROM product_image_select WHERE product_id = '1287'
203 0.0002 0.00024700164794922
SELECT * FROM productcustomimages WHERE product_id = '1287'
204 0.0003 0.00033712387084961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
205 0.0004 0.00036287307739258
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0003 0.00034093856811523
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0003 0.00026202201843262
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0005 0.00047016143798828
SELECT * FROM products WHERE id = '780'
209 0.0003 0.00034308433532715
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
210 0.0003 0.00028085708618164
SELECT * FROM product_image_select WHERE product_id = '780'
211 0.0002 0.00023794174194336
SELECT * FROM productcustomimages WHERE product_id = '780'
212 0.0003 0.00029087066650391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
213 0.0003 0.00028085708618164
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0003 0.00033402442932129
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0003 0.00026893615722656
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0005 0.00052499771118164
SELECT * FROM products WHERE id = '777'
217 0.0003 0.00027704238891602
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
218 0.0003 0.00026512145996094
SELECT * FROM product_image_select WHERE product_id = '777'
219 0.0002 0.00024890899658203
SELECT * FROM productcustomimages WHERE product_id = '777'
220 0.0003 0.00033998489379883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
221 0.0003 0.00030303001403809
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0003 0.00030398368835449
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0002 0.00024294853210449
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = '776'
225 0.0003 0.00033688545227051
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
226 0.0003 0.00031900405883789
SELECT * FROM product_image_select WHERE product_id = '776'
227 0.0004 0.00039100646972656
SELECT * FROM productcustomimages WHERE product_id = '776'
228 0.0004 0.0004429817199707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
229 0.0004 0.00037503242492676
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0004 0.00043511390686035
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0003 0.00030803680419922
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0004 0.00038886070251465
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
233 0.0004 0.00036191940307617
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
234 0.0008 0.00075984001159668
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
235 0.0004 0.00038790702819824
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
236 0.0004 0.00040102005004883
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
237 0.0006 0.00061392784118652
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
238 0.0005 0.00046014785766602
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
239 0.0006 0.00060105323791504
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'