Heath & Heather - Organic - Green Rooibos - 30g

Heath & Heather - Organic - Green Rooibos - 30g
Heath & Heather - Organic - Green Rooibos - 30g Heath & Heather - Organic - Green Rooibos - 30g (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 2022-01-09 22:48:08 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.2914750576019 235 0.1477 0


No Amazon API Requests Made.

Total time 1.2914750576019 seconds

Number Time From Start Name Description
1 0.88042998313904 Initialise Initialise FSB Function
2 0.8835301399231 App Controller Start Start of the App controller (called before the controller of every page)
3 0.88632011413574 Start of getCategoryListByGroup Function Before first category groups query
4 0.8865921497345 After initial query Before first category groups query
5 0.88659405708313 Get Category List for Group Before the call to getCategoryList function
6 0.88659811019897 Start of GetCategoryList function Start of the function
7 0.88660097122192 Before getting categories Query to get specific category list
8 0.88701105117798 After getting categories Query to get specific category list
9 0.88701295852661 Before getting category custom Before call to function getCategoryCustom
10 0.8894350528717 After getting category custom After call to function getCategoryCustom
11 0.88943815231323 Before getting category custom Before call to function getCategoryCustom
12 0.90498614311218 After getting category custom After call to function getCategoryCustom
13 0.90498900413513 Before getting category custom Before call to function getCategoryCustom
14 0.91162514686584 After getting category custom After call to function getCategoryCustom
15 0.91162800788879 Before getting category custom Before call to function getCategoryCustom
16 0.91526412963867 After getting category custom After call to function getCategoryCustom
17 0.91526699066162 Before getting category custom Before call to function getCategoryCustom
18 0.91883397102356 After getting category custom After call to function getCategoryCustom
19 0.91883707046509 Before getting category custom Before call to function getCategoryCustom
20 0.92243409156799 After getting category custom After call to function getCategoryCustom
21 0.92243695259094 End of GetCategoryList function End of the function
22 0.92244410514832 End of getCategoryListByGroup Function Before return()
23 0.93080306053162 App Controller End End of the App controller (called before the controller of every page)
24 0.93244314193726 Product Start Start of the product info controller
25 0.94735813140869 Cache file not found Starting get product details
26 0.97984218597412 Related products Start getting related products if enabled
27 0.97984409332275 Related Products Start Before the related products are found
28 0.97984504699707 Related Products Keywords Before the related product keywords are found
29 0.97985005378723 Create Keyword List Function Start of function
30 0.97988295555115 Create Keyword List Function After looping provided content - 18 keywords found
31 0.98068904876709 Create Keyword List Function After looping initial keyword list - 17 keywords remaining
32 0.98069596290588 Create Keyword List Function After reducing keyword list
33 0.98076295852661 Create Keyword List Function After selecting by scoring keywords
34 0.98076796531677 Create Keyword List Function After final loop of keywords
35 0.98077011108398 Related Products Keywords After the related product keywords are found
36 1.0065109729767 Related Products End After the related products are found
37 1.0165870189667 Product End End of the product info controller (Product Info)
38 1.0177581310272 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 1.0182671546936 Before Get Options Before the call to getOptions in the tpl class
40 1.069934129715 After Get Options After the call to getOptions in the tpl class
41 1.070032119751 App_after Controller End End of the App_after controller (called after the controller of every page)
42 1.0700671672821 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 1.1201491355896 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 1.1201560497284 Product Info: Before Template Display Before the template is displayed
45 1.2914431095123 Product Info: After Template Display After the template is displayed
46 1.2914590835571 Finalizing debug Before the debug is output to the page.
47 1.2914731502533 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1477 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00072479248046875
SELECT parameter, value FROM parameters
2 0.0011 0.0011410713195801
SELECT * FROM `bad_bots`
3 0.0004 0.00035595893859863
SET time_zone = 'Europe/London'
4 0.0004 0.00036191940307617
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0024 0.0024278163909912
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"54.224.117.125\";}'
6 0.0016 0.0016248226165771
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1642904580'
7 0.0006 0.00061202049255371
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00032401084899902
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00059103965759277
SELECT id FROM pages WHERE pagename = 'heath-heather-organic-green-rooibos-30g' LIMIT 1
10 0.0006 0.00063896179199219
SELECT id FROM products WHERE pagename = 'heath-heather-organic-green-rooibos-30g' AND hidden = 0 LIMIT 1
11 0.0011 0.0011091232299805
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0008 0.00075006484985352
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0004 0.00044488906860352
SELECT * FROM pages WHERE pagename = 'heath-heather-organic-green-rooibos-30g'
14 0.0003 0.0002591609954834
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00038409233093262
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00025081634521484
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.00028085708618164
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.00021886825561523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00022292137145996
SELECT id FROM categories WHERE parent_id = '26'
20 0.0003 0.0002598762512207
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.00027012825012207
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.0002 0.00024604797363281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00025415420532227
SELECT * FROM categorygroups WHERE id = '1'
25 0.0065 0.0065460205078125
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.0004 0.00036311149597168
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.0004 0.00040197372436523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00038409233093262
SELECT id FROM categories WHERE parent_id = '27'
29 0.0061 0.0060689449310303
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.00024008750915527
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.0009 0.00087308883666992
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.00026702880859375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00028300285339355
SELECT * FROM categorygroups WHERE id = '1'
34 0.0022 0.0021939277648926
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0003 0.00029516220092773
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.00026178359985352
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00028586387634277
SELECT id FROM categories WHERE parent_id = '28'
38 0.0024 0.0024440288543701
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.00026297569274902
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.0003 0.00026798248291016
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.00021600723266602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00030207633972168
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00074195861816406
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.00029110908508301
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.0004 0.00036001205444336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00034189224243164
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00073480606079102
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.00028705596923828
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.00023889541625977
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.00026798248291016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00025200843811035
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00066900253295898
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.00029802322387695
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.0003 0.00028204917907715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00030994415283203
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00076818466186523
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.00024509429931641
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.0003 0.0002598762512207
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.0003 0.00032901763916016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.0003049373626709
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00069618225097656
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.0002739429473877
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.00024914741516113
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00033092498779297
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00074100494384766
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.00027799606323242
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.00025796890258789
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0004 0.00039291381835938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00027990341186523
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00029182434082031
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0004 0.0003809928894043
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0004 0.00037503242492676
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.00030398368835449
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0008 0.00083589553833008
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.0004889965057373
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00031208992004395
SELECT * FROM ipgeocountries WHERE INET_ATON('54.224.117.125') >= INET_ATON(ip_start) AND INET_ATON('54.224.117.125') <= INET_ATON(ip_end)
77 0.0003 0.0002741813659668
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00030207633972168
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.00063896179199219
SELECT * FROM products WHERE pagename = 'heath-heather-organic-green-rooibos-30g'
80 0.0009 0.00089883804321289
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1258
81 0.0008 0.00084209442138672
SELECT * FROM manufacturers WHERE id = '294'
82 0.0010 0.0010478496551514
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '294'
83 0.0006 0.00062108039855957
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '294' LIMIT 1
84 0.0013 0.0013279914855957
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '294' ORDER BY RAND() LIMIT 1
85 0.0019 0.0018918514251709
SELECT * FROM productimages WHERE product_id = '2518' ORDER BY sortorder ASC
86 0.0003 0.00034403800964355
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '294'
87 0.0008 0.00083112716674805
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '294'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.00041103363037109
SELECT * FROM manufacturerimages WHERE manufacturer_id = '294'
89 0.0005 0.00052785873413086
SELECT category_id FROM products_categories WHERE product_id = '1258'
90 0.0003 0.00034689903259277
SELECT * FROM categories WHERE id = '27'
91 0.0066 0.0066051483154297
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.0004 0.00037717819213867
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0004 0.00037693977355957
SELECT id FROM categories WHERE parent_id = '27'
94 0.0052 0.0052058696746826
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.0004 0.00037503242492676
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.00024294853210449
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.0002140998840332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.0002448558807373
SELECT * FROM productimages WHERE product_id = '1258' ORDER BY sortorder ASC
99 0.0003 0.00033283233642578
SELECT * FROM product_image_select WHERE product_id = '1258'
100 0.0003 0.00033903121948242
SELECT * FROM productcustomimages WHERE product_id = '1258'
101 0.0006 0.00056910514831543
SELECT * FROM productfeeds WHERE product_id = '1258' ORDER BY item_date DESC
102 0.0021 0.0021209716796875
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1258' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0007 0.00072789192199707
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1258' AND t.hidden = 0 AND display_product = 1
104 0.0005 0.00052595138549805
SELECT * FROM productamazoncontent WHERE product_id = '1258'
105 0.0019 0.0019140243530273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1258' AND a.name = n.originalname
106 0.0007 0.00073981285095215
SELECT * FROM productoffers WHERE product_id = '1258' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0006 0.00055718421936035
SELECT * FROM productoffers
                WHERE product_id = '1258' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0005 0.00054383277893066
SELECT * FROM productoffers
                WHERE product_id = 1258
                ORDER BY price ASC LIMIT 1
109 0.0006 0.0005648136138916
SELECT value FROM productattributes
                WHERE product_id = '1258'
                AND name = 'ListPriceAmount'
110 0.0007 0.00068497657775879
SELECT value FROM productattributes WHERE product_id = '1258' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0003 0.00028800964355469
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.0094 0.0094270706176758
SELECT *, MATCH (description, title) AGAINST ('andamp heather organic' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('andamp heather organic' IN BOOLEAN MODE) AND 1258 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0007 0.00074195861816406
SELECT *, MATCH (description, title) AGAINST ('andamp heather organic' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('andamp heather organic' IN BOOLEAN MODE) AND 1258 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0007 0.00069808959960938
SELECT *, MATCH (description, title) AGAINST ('andamp heather organic' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('andamp heather organic' IN BOOLEAN MODE) AND 1258 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0003 0.00033807754516602
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
116 0.0003 0.00031495094299316
SELECT * FROM product_image_select WHERE product_id = '938'
117 0.0003 0.00027585029602051
SELECT * FROM productcustomimages WHERE product_id = '938'
118 0.0025 0.0024700164794922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
119 0.0005 0.00053811073303223
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00044918060302734
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0005 0.00049996376037598
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0004 0.00036096572875977
SELECT * FROM productimages WHERE product_id = '879' ORDER BY sortorder ASC
123 0.0003 0.00028800964355469
SELECT * FROM product_image_select WHERE product_id = '879'
124 0.0004 0.00036501884460449
SELECT * FROM productcustomimages WHERE product_id = '879'
125 0.0014 0.0013999938964844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '879' AND a.name = n.originalname
126 0.0006 0.00060510635375977
SELECT * FROM productoffers WHERE product_id = '879' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0006 0.00063896179199219
SELECT * FROM productoffers
                WHERE product_id = '879' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0006 0.00063014030456543
SELECT value FROM productattributes WHERE product_id = '879' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0004 0.00037407875061035
SELECT * FROM productimages WHERE product_id = '1089' ORDER BY sortorder ASC
130 0.0003 0.00026607513427734
SELECT * FROM product_image_select WHERE product_id = '1089'
131 0.0004 0.00036191940307617
SELECT * FROM productcustomimages WHERE product_id = '1089'
132 0.0012 0.0012080669403076
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1089' AND a.name = n.originalname
133 0.0009 0.00093603134155273
SELECT * FROM productoffers WHERE product_id = '1089' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0007 0.00066089630126953
SELECT * FROM productoffers
                WHERE product_id = '1089' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0012 0.0011811256408691
SELECT value FROM productattributes WHERE product_id = '1089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0013 0.0013470649719238
SELECT id,asin FROM products WHERE parent_id = 1258
137 0.0004 0.00036406517028809
SELECT category_id FROM products_categories WHERE product_id = '1258'
138 0.0003 0.0002751350402832
SELECT * FROM categories WHERE id = '27'
139 0.0002 0.00021195411682129
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
140 0.0002 0.00023913383483887
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0002 0.00020909309387207
SELECT id FROM categories WHERE parent_id = '27'
142 0.0003 0.00025200843811035
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.00024819374084473
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
144 0.0002 0.0002138614654541
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.0003 0.00032711029052734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0003 0.00030612945556641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1258' AND a.name = n.originalname
147 0.0003 0.0002589225769043
SELECT * FROM productoffers WHERE product_id = '1258' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0003 0.00032496452331543
SELECT * FROM productoffers
                WHERE product_id = '1258' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0003 0.00028705596923828
SELECT * FROM productoffers
                WHERE product_id = 1258
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00024986267089844
SELECT value FROM productattributes
                WHERE product_id = '1258'
                AND name = 'ListPriceAmount'
151 0.0005 0.00052309036254883
SELECT * FROM products WHERE id = '1258'
152 0.0003 0.00025796890258789
SELECT value FROM productattributes WHERE product_id = '1258' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0002 0.00024104118347168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1258' AND a.name = n.originalname
154 0.0002 0.0002439022064209
SELECT * FROM productoffers WHERE product_id = '1258' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0002 0.00023484230041504
SELECT * FROM productoffers
                WHERE product_id = '1258' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0002 0.00023198127746582
SELECT * FROM productoffers
                WHERE product_id = 1258
                ORDER BY price ASC LIMIT 1
157 0.0002 0.00020408630371094
SELECT value FROM productattributes
                WHERE product_id = '1258'
                AND name = 'ListPriceAmount'
158 0.0003 0.00033998489379883
SELECT category_id FROM products_categories WHERE product_id = '1258' AND prod_type = 'amz'
159 0.0003 0.00026202201843262
SELECT parent_id FROM categories WHERE id = '27'
160 0.0003 0.00029587745666504
SELECT * FROM categories WHERE id = '27'
161 0.0002 0.00020003318786621
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.00022697448730469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '27'
164 0.0003 0.00028300285339355
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.0003 0.00031495094299316
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.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
167 0.0002 0.0002288818359375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0003 0.00031208992004395
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0002 0.00021481513977051
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0002 0.00022411346435547
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0003 0.00026822090148926
SELECT * FROM pages WHERE id = 38
172 0.0047 0.0046758651733398
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.0007 0.00073909759521484
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:1642904581;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:\"780|amazon\";i:5;s:10:\"779|amazon\";}}' WHERE id = '160'
174 0.0007 0.00068402290344238
SELECT * FROM products WHERE id = 790
175 0.0005 0.00053501129150391
SELECT * FROM products WHERE id = 788
176 0.0006 0.00056195259094238
SELECT * FROM products WHERE id = 787
177 0.0006 0.00063705444335938
SELECT * FROM products WHERE id = 1287
178 0.0005 0.00053596496582031
SELECT * FROM products WHERE id = 780
179 0.0006 0.0005791187286377
SELECT * FROM products WHERE id = 779
180 0.0005 0.00048613548278809
SELECT * FROM products WHERE id = '790'
181 0.0003 0.00032210350036621
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
182 0.0003 0.00032186508178711
SELECT * FROM product_image_select WHERE product_id = '790'
183 0.0003 0.00029516220092773
SELECT * FROM productcustomimages WHERE product_id = '790'
184 0.0005 0.0004580020904541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
185 0.0003 0.00031614303588867
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0003 0.00032615661621094
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0003 0.00025796890258789
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0007 0.00072813034057617
SELECT * FROM products WHERE id = '788'
189 0.0004 0.00036907196044922
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0003 0.00027894973754883
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0003 0.00028705596923828
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0005 0.00045394897460938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
193 0.0003 0.00031304359436035
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0004 0.00039005279541016
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0002 0.00024604797363281
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0006 0.00055289268493652
SELECT * FROM products WHERE id = '787'
197 0.0003 0.0002899169921875
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0003 0.00026988983154297
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0002 0.00023913383483887
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0003 0.00027680397033691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
201 0.0003 0.00032401084899902
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0003 0.00025486946105957
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0006 0.00058221817016602
SELECT * FROM products WHERE id = '1287'
205 0.0004 0.00043892860412598
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
206 0.0002 0.00024104118347168
SELECT * FROM product_image_select WHERE product_id = '1287'
207 0.0002 0.00024199485778809
SELECT * FROM productcustomimages WHERE product_id = '1287'
208 0.0003 0.0002741813659668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
209 0.0003 0.00029492378234863
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0004 0.00035309791564941
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0003 0.00029897689819336
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0007 0.00072503089904785
SELECT * FROM products WHERE id = '780'
213 0.0003 0.00027799606323242
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
214 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '780'
215 0.0002 0.00024604797363281
SELECT * FROM productcustomimages WHERE product_id = '780'
216 0.0003 0.00026893615722656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
217 0.0003 0.00030207633972168
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0003 0.00031304359436035
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0003 0.00025105476379395
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0006 0.00055909156799316
SELECT * FROM products WHERE id = '779'
221 0.0003 0.00027704238891602
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
222 0.0003 0.00028395652770996
SELECT * FROM product_image_select WHERE product_id = '779'
223 0.0002 0.00023913383483887
SELECT * FROM productcustomimages WHERE product_id = '779'
224 0.0003 0.00025200843811035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
225 0.0003 0.00026798248291016
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.00027704238891602
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0003 0.00027108192443848
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0004 0.00040793418884277
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0004 0.00039482116699219
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0007 0.00071501731872559
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0004 0.00041794776916504
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0004 0.00043892860412598
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0004 0.00036978721618652
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0006 0.00055193901062012
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0003 0.00028681755065918
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'