herbaria Rooibos Busch naturel 15 FB, 1er Pack (1 x 30 g Sachets) – Bio

herbaria Rooibos Busch naturel 15 FB, 1er Pack (1 x 30 g Sachets) – Bio
herbaria Rooibos Busch naturel 15 FB, 1er Pack (1 x 30 g Sachets) – Bio (cliquez sur les images pour élargir)
€6,98
Le prix et la disponibilité du produit sont corrects en date du 2022-05-28 14:39: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.67752289772034 229 0.1652 0


No Amazon API Requests Made.

Total time 0.67752289772034 seconds

Number Time From Start Name Description
1 0.49084806442261 Initialise Initialise FSB Function
2 0.49734902381897 App Controller Start Start of the App controller (called before the controller of every page)
3 0.50063300132751 Start of getCategoryListByGroup Function Before first category groups query
4 0.50094890594482 After initial query Before first category groups query
5 0.50095105171204 Get Category List for Group Before the call to getCategoryList function
6 0.50096583366394 Start of GetCategoryList function Start of the function
7 0.50096797943115 Before getting categories Query to get specific category list
8 0.50156688690186 After getting categories Query to get specific category list
9 0.50156903266907 Before getting category custom Before call to function getCategoryCustom
10 0.52233004570007 After getting category custom After call to function getCategoryCustom
11 0.52233290672302 Before getting category custom Before call to function getCategoryCustom
12 0.53330993652344 After getting category custom After call to function getCategoryCustom
13 0.53331303596497 Before getting category custom Before call to function getCategoryCustom
14 0.54070997238159 After getting category custom After call to function getCategoryCustom
15 0.54071283340454 Before getting category custom Before call to function getCategoryCustom
16 0.54515385627747 After getting category custom After call to function getCategoryCustom
17 0.54515695571899 Before getting category custom Before call to function getCategoryCustom
18 0.54952597618103 After getting category custom After call to function getCategoryCustom
19 0.54952883720398 Before getting category custom Before call to function getCategoryCustom
20 0.55334997177124 After getting category custom After call to function getCategoryCustom
21 0.55335283279419 End of GetCategoryList function End of the function
22 0.55336785316467 End of getCategoryListByGroup Function Before return()
23 0.55837202072144 App Controller End End of the App controller (called before the controller of every page)
24 0.55845594406128 Product Start Start of the product info controller
25 0.56083488464355 Cache file not found Starting get product details
26 0.5892539024353 Related products Start getting related products if enabled
27 0.58925485610962 Related Products Start Before the related products are found
28 0.58925604820251 Related Products Keywords Before the related product keywords are found
29 0.58925986289978 Create Keyword List Function Start of function
30 0.58928799629211 Create Keyword List Function After looping provided content - 27 keywords found
31 0.59039783477783 Create Keyword List Function After looping initial keyword list - 24 keywords remaining
32 0.59040594100952 Create Keyword List Function After reducing keyword list
33 0.59047293663025 Create Keyword List Function After selecting by scoring keywords
34 0.59047603607178 Create Keyword List Function After final loop of keywords
35 0.59047794342041 Related Products Keywords After the related product keywords are found
36 0.61164784431458 Related Products End After the related products are found
37 0.62086391448975 Product End End of the product info controller (Product Info)
38 0.62146401405334 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.62220191955566 Before Get Options Before the call to getOptions in the tpl class
40 0.66240882873535 After Get Options After the call to getOptions in the tpl class
41 0.66248297691345 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.66250491142273 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.66706299781799 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.66706705093384 Product Info: Before Template Display Before the template is displayed
45 0.67750692367554 Product Info: After Template Display After the template is displayed
46 0.67751097679138 Finalizing debug Before the debug is output to the page.
47 0.67752194404602 End of App This is the end of the app logging, final timestamp


Query Debug - 229 Database Queries. Total time 0.1652 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00063514709472656
SELECT parameter, value FROM parameters
2 0.0012 0.001215934753418
SELECT * FROM `bad_bots`
3 0.0005 0.0005040168762207
SET time_zone = 'Europe/London'
4 0.0005 0.00046801567077637
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0019 0.0019199848175049
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.244.12\";}'
6 0.0014 0.0014228820800781
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653817142'
7 0.0006 0.00063705444335938
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.0003960132598877
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00047206878662109
SELECT id FROM pages WHERE pagename = 'herbaria-rooibos-busch-naturel-15fb-1er-pack-1x-30g-sachetsbio' LIMIT 1
10 0.0007 0.00065302848815918
SELECT id FROM products WHERE pagename = 'herbaria-rooibos-busch-naturel-15fb-1er-pack-1x-30g-sachetsbio' AND hidden = 0 LIMIT 1
11 0.0014 0.0013670921325684
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00087285041809082
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00060892105102539
SELECT * FROM pages WHERE pagename = 'herbaria-rooibos-busch-naturel-15fb-1er-pack-1x-30g-sachetsbio'
14 0.0003 0.00030398368835449
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0006 0.00057697296142578
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0121 0.012102842330933
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.00029993057250977
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.0002281665802002
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00025701522827148
SELECT id FROM categories WHERE parent_id = '26'
20 0.0068 0.0068061351776123
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.0003 0.00027799606323242
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.00024604797363281
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.00020718574523926
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00021195411682129
SELECT * FROM categorygroups WHERE id = '1'
25 0.0044 0.0044248104095459
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.00024509429931641
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.00023698806762695
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '27'
29 0.0044 0.0043690204620361
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.0004 0.00044894218444824
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.00028419494628906
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.00023889541625977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.0003960132598877
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0017399787902832
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.0005 0.00046706199645996
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.0006 0.00055408477783203
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00049805641174316
SELECT id FROM categories WHERE parent_id = '28'
38 0.0018 0.0018148422241211
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.0005 0.00054812431335449
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.0005 0.00053501129150391
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.0005 0.00051999092102051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0006 0.00057601928710938
SELECT * FROM categorygroups WHERE id = '1'
43 0.0009 0.00085091590881348
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.0005 0.0004580020904541
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.00025582313537598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00043988227844238
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00088000297546387
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.0004 0.00035715103149414
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.0004 0.00042295455932617
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.00028204917907715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00035405158996582
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00046110153198242
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.0004 0.00044584274291992
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.0005 0.00050902366638184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00042986869812012
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00051188468933105
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.0006 0.00056695938110352
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.0005 0.00052499771118164
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.00044488906860352
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00034093856811523
SELECT * FROM categorygroups WHERE id = '1'
61 0.0009 0.00085902214050293
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.00035595893859863
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.00025200843811035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00022315979003906
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00084185600280762
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.00026392936706543
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.00031614303588867
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.00032591819763184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00027108192443848
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00047492980957031
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0005 0.00051498413085938
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00033712387084961
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.00026202201843262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0006 0.00063014030456543
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00051617622375488
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0004 0.00043702125549316
SELECT * FROM ipgeocountries WHERE INET_ATON('34.231.244.12') >= INET_ATON(ip_start) AND INET_ATON('34.231.244.12') <= INET_ATON(ip_end)
77 0.0003 0.00033998489379883
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00026297569274902
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0010 0.00097203254699707
SELECT * FROM products WHERE pagename = 'herbaria-rooibos-busch-naturel-15fb-1er-pack-1x-30g-sachetsbio'
80 0.0008 0.00078511238098145
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2521
81 0.0006 0.00063991546630859
SELECT * FROM manufacturers WHERE id = '452'
82 0.0008 0.00081014633178711
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '452'
83 0.0004 0.00042390823364258
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '452' LIMIT 1
84 0.0010 0.00098299980163574
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '452' ORDER BY RAND() LIMIT 1
85 0.0020 0.0020060539245605
SELECT * FROM productimages WHERE product_id = '2521' ORDER BY sortorder ASC
86 0.0003 0.00029206275939941
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '452'
87 0.0008 0.00075006484985352
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '452'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0005 0.00047397613525391
SELECT * FROM manufacturerimages WHERE manufacturer_id = '452'
89 0.0005 0.00045204162597656
SELECT category_id FROM products_categories WHERE product_id = '2521'
90 0.0003 0.0003359317779541
SELECT * FROM categories WHERE id = '27'
91 0.0060 0.0059750080108643
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.0005 0.0004570484161377
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0005 0.00050902366638184
SELECT id FROM categories WHERE parent_id = '27'
94 0.0052 0.0051629543304443
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.00027894973754883
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.0003 0.00026917457580566
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.00022506713867188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0003 0.00025486946105957
SELECT * FROM productimages WHERE product_id = '2521' ORDER BY sortorder ASC
99 0.0005 0.00046610832214355
SELECT * FROM product_image_select WHERE product_id = '2521'
100 0.0004 0.0004420280456543
SELECT * FROM productcustomimages WHERE product_id = '2521'
101 0.0004 0.00036501884460449
SELECT * FROM productfeeds WHERE product_id = '2521' ORDER BY item_date DESC
102 0.0015 0.0015449523925781
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0006 0.00060796737670898
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2521' AND t.hidden = 0 AND display_product = 1
104 0.0005 0.0005040168762207
SELECT * FROM productamazoncontent WHERE product_id = '2521'
105 0.0015 0.0014538764953613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
106 0.0007 0.00065207481384277
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0006 0.00056600570678711
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0005 0.00054597854614258
SELECT value FROM productattributes WHERE product_id = '2521' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0003 0.00033307075500488
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.0080 0.0080299377441406
SELECT *, MATCH (description, title) AGAINST ('herbaria rooibos busch' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('herbaria rooibos busch' IN BOOLEAN MODE) AND 2521 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
111 0.0008 0.00075602531433105
SELECT *, MATCH (description, title) AGAINST ('herbaria rooibos busch' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('herbaria rooibos busch' IN BOOLEAN MODE) AND 2521 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
112 0.0008 0.00078487396240234
SELECT *, MATCH (description, title) AGAINST ('herbaria rooibos busch' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('herbaria rooibos busch' IN BOOLEAN MODE) AND 2521 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
113 0.0004 0.0004420280456543
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
114 0.0003 0.00034403800964355
SELECT * FROM product_image_select WHERE product_id = '878'
115 0.0004 0.00042510032653809
SELECT * FROM productcustomimages WHERE product_id = '878'
116 0.0005 0.00054693222045898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
117 0.0007 0.00071001052856445
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0008 0.00075507164001465
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0006 0.00057196617126465
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0007 0.00067019462585449
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
121 0.0005 0.00050210952758789
SELECT * FROM product_image_select WHERE product_id = '862'
122 0.0009 0.00086808204650879
SELECT * FROM productcustomimages WHERE product_id = '862'
123 0.0004 0.00035905838012695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
124 0.0005 0.00054001808166504
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0005 0.00053906440734863
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00026297569274902
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0005 0.00048494338989258
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
128 0.0004 0.00038599967956543
SELECT * FROM product_image_select WHERE product_id = '858'
129 0.0005 0.00053596496582031
SELECT * FROM productcustomimages WHERE product_id = '858'
130 0.0004 0.00036001205444336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
131 0.0006 0.00055909156799316
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0006 0.0006248950958252
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0003 0.00031709671020508
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0006 0.0005638599395752
SELECT id,asin FROM products WHERE parent_id = 2521
135 0.0004 0.00044512748718262
SELECT category_id FROM products_categories WHERE product_id = '2521'
136 0.0004 0.00036311149597168
SELECT * FROM categories WHERE id = '27'
137 0.0003 0.00033307075500488
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
138 0.0003 0.00025081634521484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
139 0.0003 0.00026988983154297
SELECT id FROM categories WHERE parent_id = '27'
140 0.0004 0.00038409233093262
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 
141 0.0003 0.00029206275939941
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 
142 0.0003 0.00025200843811035
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
143 0.0003 0.00025200843811035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
144 0.0003 0.00028395652770996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
145 0.0003 0.00033903121948242
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0003 0.00027990341186523
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0006 0.0006101131439209
SELECT * FROM products WHERE id = '2521'
148 0.0003 0.00027608871459961
SELECT value FROM productattributes WHERE product_id = '2521' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0002 0.00024986267089844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
150 0.0002 0.00024604797363281
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0003 0.00027179718017578
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0005 0.00045204162597656
SELECT category_id FROM products_categories WHERE product_id = '2521' AND prod_type = 'amz'
153 0.0003 0.00032997131347656
SELECT parent_id FROM categories WHERE id = '27'
154 0.0003 0.00027680397033691
SELECT * FROM categories WHERE id = '27'
155 0.0002 0.00021815299987793
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
156 0.0002 0.00024104118347168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
157 0.0002 0.00024104118347168
SELECT id FROM categories WHERE parent_id = '27'
158 0.0002 0.0002439022064209
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 
159 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 (27)
				  AND p.disabled = 0 
160 0.0003 0.00029301643371582
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
161 0.0002 0.0002439022064209
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
162 0.0005 0.00050091743469238
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
163 0.0004 0.00041890144348145
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
164 0.0002 0.00024986267089844
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
165 0.0004 0.00041580200195312
SELECT * FROM pages WHERE id = 38
166 0.0069 0.0068819522857666
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
167 0.0008 0.00075006484985352
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:1653817142;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'
168 0.0008 0.00081205368041992
SELECT * FROM products WHERE id = 788
169 0.0007 0.00071501731872559
SELECT * FROM products WHERE id = 787
170 0.0009 0.0009300708770752
SELECT * FROM products WHERE id = 1287
171 0.0007 0.0007169246673584
SELECT * FROM products WHERE id = 780
172 0.0006 0.00058794021606445
SELECT * FROM products WHERE id = 777
173 0.0007 0.00067806243896484
SELECT * FROM products WHERE id = 776
174 0.0008 0.00079011917114258
SELECT * FROM products WHERE id = '788'
175 0.0005 0.00047588348388672
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
176 0.0005 0.00048184394836426
SELECT * FROM product_image_select WHERE product_id = '788'
177 0.0003 0.00034999847412109
SELECT * FROM productcustomimages WHERE product_id = '788'
178 0.0004 0.00037813186645508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
179 0.0004 0.00037789344787598
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0003 0.00028514862060547
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0007 0.00066399574279785
SELECT * FROM products WHERE id = '787'
183 0.0004 0.00035405158996582
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
184 0.0003 0.00026988983154297
SELECT * FROM product_image_select WHERE product_id = '787'
185 0.0002 0.00023889541625977
SELECT * FROM productcustomimages WHERE product_id = '787'
186 0.0003 0.00025296211242676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
187 0.0003 0.00025606155395508
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0003 0.0002901554107666
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0002 0.00024318695068359
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0007 0.00068902969360352
SELECT * FROM products WHERE id = '1287'
191 0.0004 0.00042009353637695
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
192 0.0004 0.00042104721069336
SELECT * FROM product_image_select WHERE product_id = '1287'
193 0.0005 0.00045299530029297
SELECT * FROM productcustomimages WHERE product_id = '1287'
194 0.0005 0.00047206878662109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
195 0.0003 0.00030422210693359
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0004 0.00043606758117676
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0003 0.00031709671020508
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0006 0.00064396858215332
SELECT * FROM products WHERE id = '780'
199 0.0004 0.00042581558227539
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
200 0.0005 0.00047802925109863
SELECT * FROM product_image_select WHERE product_id = '780'
201 0.0005 0.0004730224609375
SELECT * FROM productcustomimages WHERE product_id = '780'
202 0.0004 0.00044417381286621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
203 0.0004 0.00043201446533203
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0005 0.00046110153198242
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0007 0.00073599815368652
SELECT * FROM products WHERE id = '777'
207 0.0004 0.00038790702819824
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
208 0.0004 0.00043487548828125
SELECT * FROM product_image_select WHERE product_id = '777'
209 0.0005 0.00046491622924805
SELECT * FROM productcustomimages WHERE product_id = '777'
210 0.0005 0.00047898292541504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
211 0.0005 0.00051999092102051
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0006 0.00056815147399902
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0004 0.00039911270141602
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0008 0.00075292587280273
SELECT * FROM products WHERE id = '776'
215 0.0006 0.00055789947509766
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
216 0.0004 0.00040793418884277
SELECT * FROM product_image_select WHERE product_id = '776'
217 0.0005 0.00054788589477539
SELECT * FROM productcustomimages WHERE product_id = '776'
218 0.0006 0.00058913230895996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
219 0.0005 0.00047397613525391
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0005 0.00049996376037598
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0006 0.00057101249694824
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
223 0.0005 0.0005180835723877
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
224 0.0010 0.00097894668579102
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
225 0.0005 0.00047087669372559
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
226 0.0004 0.00037717819213867
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
227 0.0005 0.00054097175598145
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
228 0.0004 0.00043988227844238
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
229 0.0005 0.0004580020904541
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'