Dragonfly Teas | Rooibos Breakfast | 4 x 40 Bags

Dragonfly Teas | Rooibos Breakfast | 4 x 40 Bags
Dragonfly Teas | Rooibos Breakfast | 4 x 40 Bags Dragonfly Teas | Rooibos Breakfast | 4 x 40 Bags (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-09-12 06:13:02 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.7720220088959 235 0.1053 0


No Amazon API Requests Made.

Total time 1.7720220088959 seconds

Number Time From Start Name Description
1 0.62577795982361 Initialise Initialise FSB Function
2 0.6282958984375 App Controller Start Start of the App controller (called before the controller of every page)
3 0.63043785095215 Start of getCategoryListByGroup Function Before first category groups query
4 0.63065505027771 After initial query Before first category groups query
5 0.63065695762634 Get Category List for Group Before the call to getCategoryList function
6 0.63065981864929 Start of GetCategoryList function Start of the function
7 0.63066387176514 Before getting categories Query to get specific category list
8 0.63094782829285 After getting categories Query to get specific category list
9 0.63094997406006 Before getting category custom Before call to function getCategoryCustom
10 0.63271689414978 After getting category custom After call to function getCategoryCustom
11 0.63271999359131 Before getting category custom Before call to function getCategoryCustom
12 0.64308595657349 After getting category custom After call to function getCategoryCustom
13 0.64308786392212 Before getting category custom Before call to function getCategoryCustom
14 0.64769983291626 After getting category custom After call to function getCategoryCustom
15 0.64770293235779 Before getting category custom Before call to function getCategoryCustom
16 0.65026187896729 After getting category custom After call to function getCategoryCustom
17 0.6502640247345 Before getting category custom Before call to function getCategoryCustom
18 0.65266585350037 After getting category custom After call to function getCategoryCustom
19 0.65266990661621 Before getting category custom Before call to function getCategoryCustom
20 0.65513300895691 After getting category custom After call to function getCategoryCustom
21 0.65513491630554 End of GetCategoryList function End of the function
22 0.65514087677002 End of getCategoryListByGroup Function Before return()
23 0.66673994064331 App Controller End End of the App controller (called before the controller of every page)
24 0.6677348613739 Product Start Start of the product info controller
25 0.6708128452301 Cache file not found Starting get product details
26 0.69396781921387 Related products Start getting related products if enabled
27 0.6939709186554 Related Products Start Before the related products are found
28 0.69397187232971 Related Products Keywords Before the related product keywords are found
29 0.69397783279419 Create Keyword List Function Start of function
30 0.69402289390564 Create Keyword List Function After looping provided content - 21 keywords found
31 0.69482183456421 Create Keyword List Function After looping initial keyword list - 16 keywords remaining
32 0.69483089447021 Create Keyword List Function After reducing keyword list
33 0.69489288330078 Create Keyword List Function After selecting by scoring keywords
34 0.69489884376526 Create Keyword List Function After final loop of keywords
35 0.69490098953247 Related Products Keywords After the related product keywords are found
36 0.71310687065125 Related Products End After the related products are found
37 0.7210910320282 Product End End of the product info controller (Product Info)
38 0.7222318649292 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.72270393371582 Before Get Options Before the call to getOptions in the tpl class
40 0.74576997756958 After Get Options After the call to getOptions in the tpl class
41 0.74590992927551 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.7459568977356 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.76968693733215 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.76969504356384 Product Info: Before Template Display Before the template is displayed
45 1.7719769477844 Product Info: After Template Display After the template is displayed
46 1.7719979286194 Finalizing debug Before the debug is output to the page.
47 1.772020816803 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1053 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.000701904296875
SELECT parameter, value FROM parameters
2 0.0006 0.00059795379638672
SELECT * FROM `bad_bots`
3 0.0002 0.00020909309387207
SET time_zone = 'Europe/London'
4 0.0002 0.00020003318786621
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0014 0.0014321804046631
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.227.235.216\";}'
6 0.0008 0.00080609321594238
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632224735'
7 0.0005 0.00045895576477051
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00020098686218262
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0004 0.00040912628173828
SELECT id FROM pages WHERE pagename = 'dragonfly-teas-rooibos-breakfast-4-x-40-bags' LIMIT 1
10 0.0004 0.00044703483581543
SELECT id FROM products WHERE pagename = 'dragonfly-teas-rooibos-breakfast-4-x-40-bags' AND hidden = 0 LIMIT 1
11 0.0007 0.00071096420288086
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0006 0.00062704086303711
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0004 0.00037097930908203
SELECT * FROM pages WHERE pagename = 'dragonfly-teas-rooibos-breakfast-4-x-40-bags'
14 0.0002 0.00020289421081543
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0003 0.00026202201843262
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0002 0.00018501281738281
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.00017404556274414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.0001838207244873
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.00017809867858887
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.00017786026000977
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.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00020813941955566
SELECT * FROM categorygroups WHERE id = '1'
25 0.0044 0.0044009685516357
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.00018620491027832
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.00020599365234375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.0001680850982666
SELECT id FROM categories WHERE parent_id = '27'
29 0.0046 0.0045650005340576
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.0001990795135498
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.00017309188842773
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.0001990795135498
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00017309188842773
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016138553619385
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.00018215179443359
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.00017285346984863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00016903877258301
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015759468078613
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.00019598007202148
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.00017380714416504
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.00023484230041504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00020098686218262
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00057506561279297
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.00018596649169922
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.00018596649169922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00016617774963379
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.0005338191986084
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.00021600723266602
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.00019693374633789
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.00020503997802734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00018095970153809
SELECT * FROM categorygroups WHERE id = '1'
52 0.0004 0.00044894218444824
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0002 0.00018596649169922
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.00017809867858887
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00018310546875
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00048398971557617
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.00018620491027832
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.00023794174194336
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00020599365234375
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00052499771118164
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.00020194053649902
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.00017118453979492
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00020885467529297
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.0005650520324707
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.00017690658569336
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.00016903877258301
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00017619132995605
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00021600723266602
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.0002739429473877
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0002 0.00024199485778809
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.00020313262939453
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00049114227294922
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0004 0.0003969669342041
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00022792816162109
SELECT * FROM ipgeocountries WHERE INET_ATON('3.227.235.216') >= INET_ATON(ip_start) AND INET_ATON('3.227.235.216') <= INET_ATON(ip_end)
77 0.0002 0.00021004676818848
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00023913383483887
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0005 0.0005040168762207
SELECT * FROM products WHERE pagename = 'dragonfly-teas-rooibos-breakfast-4-x-40-bags'
80 0.0012 0.0012340545654297
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1038
81 0.0003 0.0003359317779541
SELECT * FROM manufacturers WHERE id = '263'
82 0.0006 0.00056695938110352
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '263'
83 0.0007 0.00069904327392578
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '263' LIMIT 1
84 0.0006 0.00058794021606445
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '263' ORDER BY RAND() LIMIT 1
85 0.0014 0.0013871192932129
SELECT * FROM productimages WHERE product_id = '1038' ORDER BY sortorder ASC
86 0.0004 0.0003960132598877
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '263'
87 0.0006 0.00055384635925293
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '263'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0003 0.00026392936706543
SELECT * FROM manufacturerimages WHERE manufacturer_id = '263'
89 0.0005 0.00047206878662109
SELECT category_id FROM products_categories WHERE product_id = '1038'
90 0.0002 0.00022006034851074
SELECT * FROM categories WHERE id = '27'
91 0.0041 0.0040881633758545
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.00017499923706055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00018215179443359
SELECT id FROM categories WHERE parent_id = '27'
94 0.0045 0.0044629573822021
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.0002 0.00018501281738281
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.00017809867858887
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.0001990795135498
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '1038' ORDER BY sortorder ASC
99 0.0004 0.00043392181396484
SELECT * FROM product_image_select WHERE product_id = '1038'
100 0.0005 0.00054407119750977
SELECT * FROM productcustomimages WHERE product_id = '1038'
101 0.0002 0.00024795532226562
SELECT * FROM productfeeds WHERE product_id = '1038' ORDER BY item_date DESC
102 0.0021 0.0021319389343262
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1038' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0004 0.00037288665771484
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1038' AND t.hidden = 0 AND display_product = 1
104 0.0005 0.00045394897460938
SELECT * FROM productamazoncontent WHERE product_id = '1038'
105 0.0010 0.00096988677978516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1038' AND a.name = n.originalname
106 0.0003 0.00032401084899902
SELECT * FROM productoffers WHERE product_id = '1038' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0003 0.00031518936157227
SELECT * FROM productoffers
                WHERE product_id = '1038' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00042915344238281
SELECT * FROM productoffers
                WHERE product_id = 1038
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00040817260742188
SELECT value FROM productattributes
                WHERE product_id = '1038'
                AND name = 'ListPriceAmount'
110 0.0004 0.00037813186645508
SELECT value FROM productattributes WHERE product_id = '1038' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0004 0.00036406517028809
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.0073 0.0073311328887939
SELECT *, MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AND 1038 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0007 0.00067591667175293
SELECT *, MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AND 1038 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0004 0.00039792060852051
SELECT *, MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AND 1038 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0004 0.00038695335388184
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
116 0.0002 0.00019598007202148
SELECT * FROM product_image_select WHERE product_id = '862'
117 0.0004 0.00044703483581543
SELECT * FROM productcustomimages WHERE product_id = '862'
118 0.0002 0.00023007392883301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
119 0.0004 0.00039505958557129
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00044083595275879
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0002 0.00019478797912598
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '1513' ORDER BY sortorder ASC
123 0.0003 0.00030279159545898
SELECT * FROM product_image_select WHERE product_id = '1513'
124 0.0002 0.00017809867858887
SELECT * FROM productcustomimages WHERE product_id = '1513'
125 0.0016 0.001633882522583
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1513' AND a.name = n.originalname
126 0.0003 0.00029897689819336
SELECT * FROM productoffers WHERE product_id = '1513' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0005 0.00045108795166016
SELECT * FROM productoffers
                WHERE product_id = '1513' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0007 0.00065708160400391
SELECT value FROM productattributes WHERE product_id = '1513' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0002 0.00019407272338867
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
130 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '938'
131 0.0002 0.00024795532226562
SELECT * FROM productcustomimages WHERE product_id = '938'
132 0.0013 0.0012748241424561
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
133 0.0003 0.00032806396484375
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0004 0.00035500526428223
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0005 0.00050997734069824
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0003 0.00027585029602051
SELECT id,asin FROM products WHERE parent_id = 1038
137 0.0002 0.00018906593322754
SELECT category_id FROM products_categories WHERE product_id = '1038'
138 0.0004 0.00035595893859863
SELECT * FROM categories WHERE id = '27'
139 0.0002 0.00018310546875
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.0003 0.00030016899108887
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0002 0.0001838207244873
SELECT id FROM categories WHERE parent_id = '27'
142 0.0002 0.00018000602722168
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.00018405914306641
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.0003 0.00032401084899902
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.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0002 0.00017595291137695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1038' AND a.name = n.originalname
147 0.0004 0.00038981437683105
SELECT * FROM productoffers WHERE product_id = '1038' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '1038' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0003 0.00033402442932129
SELECT * FROM productoffers
                WHERE product_id = 1038
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00021195411682129
SELECT value FROM productattributes
                WHERE product_id = '1038'
                AND name = 'ListPriceAmount'
151 0.0004 0.0003659725189209
SELECT * FROM products WHERE id = '1038'
152 0.0003 0.00034093856811523
SELECT value FROM productattributes WHERE product_id = '1038' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0002 0.00019502639770508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1038' AND a.name = n.originalname
154 0.0002 0.00022697448730469
SELECT * FROM productoffers WHERE product_id = '1038' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0003 0.00033998489379883
SELECT * FROM productoffers
                WHERE product_id = '1038' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = 1038
                ORDER BY price ASC LIMIT 1
157 0.0002 0.00018692016601562
SELECT value FROM productattributes
                WHERE product_id = '1038'
                AND name = 'ListPriceAmount'
158 0.0003 0.00033092498779297
SELECT category_id FROM products_categories WHERE product_id = '1038' AND prod_type = 'amz'
159 0.0002 0.00020194053649902
SELECT parent_id FROM categories WHERE id = '27'
160 0.0002 0.00022101402282715
SELECT * FROM categories WHERE id = '27'
161 0.0002 0.00018095970153809
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.00017094612121582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0002 0.00017309188842773
SELECT id FROM categories WHERE parent_id = '27'
164 0.0002 0.00020217895507812
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.00016903877258301
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.00019288063049316
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.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0002 0.00022602081298828
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0002 0.00017189979553223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0002 0.00020790100097656
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0002 0.00023388862609863
SELECT * FROM pages WHERE id = 38
172 0.0037 0.0036768913269043
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.0003 0.00034499168395996
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:1632224736;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:11:\"1287|amazon\";i:4;s:10:\"779|amazon\";i:5;s:10:\"777|amazon\";}}' WHERE id = '160'
174 0.0004 0.00041294097900391
SELECT * FROM products WHERE id = 790
175 0.0004 0.00035691261291504
SELECT * FROM products WHERE id = 788
176 0.0003 0.00033998489379883
SELECT * FROM products WHERE id = 787
177 0.0003 0.00034403800964355
SELECT * FROM products WHERE id = 1287
178 0.0003 0.00034117698669434
SELECT * FROM products WHERE id = 779
179 0.0003 0.0003199577331543
SELECT * FROM products WHERE id = 777
180 0.0004 0.00037884712219238
SELECT * FROM products WHERE id = '790'
181 0.0003 0.00030612945556641
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
182 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '790'
183 0.0002 0.00018596649169922
SELECT * FROM productcustomimages WHERE product_id = '790'
184 0.0002 0.00020313262939453
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
185 0.0002 0.00020909309387207
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0002 0.00017714500427246
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0004 0.00039505958557129
SELECT * FROM products WHERE id = '788'
189 0.0002 0.00022602081298828
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0002 0.00018596649169922
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0002 0.00018906593322754
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0002 0.00023794174194336
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.00019001960754395
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0002 0.0001680850982666
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0004 0.00039386749267578
SELECT * FROM products WHERE id = '787'
197 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0002 0.00017285346984863
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0002 0.00017905235290527
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0002 0.00018405914306641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
201 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0003 0.00025510787963867
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0002 0.00020122528076172
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0004 0.00041818618774414
SELECT * FROM products WHERE id = '1287'
205 0.0003 0.00027108192443848
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
206 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '1287'
207 0.0002 0.00018811225891113
SELECT * FROM productcustomimages WHERE product_id = '1287'
208 0.0002 0.00023913383483887
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
209 0.0002 0.0002291202545166
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0002 0.0001981258392334
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0004 0.00042200088500977
SELECT * FROM products WHERE id = '779'
213 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
214 0.0002 0.00018787384033203
SELECT * FROM product_image_select WHERE product_id = '779'
215 0.0002 0.0001838207244873
SELECT * FROM productcustomimages WHERE product_id = '779'
216 0.0002 0.000244140625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
217 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0002 0.0001828670501709
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0004 0.00038719177246094
SELECT * FROM products WHERE id = '777'
221 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
222 0.0002 0.00019001960754395
SELECT * FROM product_image_select WHERE product_id = '777'
223 0.0002 0.0001828670501709
SELECT * FROM productcustomimages WHERE product_id = '777'
224 0.0002 0.00023818016052246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
225 0.0002 0.00022196769714355
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.00027084350585938
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0002 0.00020194053649902
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0003 0.00028800964355469
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0003 0.00025200843811035
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0005 0.00052714347839355
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0003 0.00026392936706543
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0003 0.00029683113098145
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0004 0.00041413307189941
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0003 0.00027799606323242
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0018 0.0017800331115723
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'