Pompadour – Supreme Rooibos Caramel 10 cipsulas

Pompadour – Supreme Rooibos Caramel 10 cipsulas
Pompadour – Supreme Rooibos Caramel 10 cipsulas Pompadour – Supreme Rooibos Caramel 10 cipsulas (cliquez sur les images pour élargir)
€19,99
Le prix et la disponibilité du produit sont corrects en date du 2022-01-21 05:07:26 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.

Caractéristiques du Produit

Pompadour - Supreme Rooibos caramel 10 capsules
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.1513500213623 229 0.1309 0


No Amazon API Requests Made.

Total time 1.1513500213623 seconds

Number Time From Start Name Description
1 0.72701597213745 Initialise Initialise FSB Function
2 0.73024702072144 App Controller Start Start of the App controller (called before the controller of every page)
3 0.73419308662415 Start of getCategoryListByGroup Function Before first category groups query
4 0.73448801040649 After initial query Before first category groups query
5 0.73449015617371 Get Category List for Group Before the call to getCategoryList function
6 0.73449301719666 Start of GetCategoryList function Start of the function
7 0.7344970703125 Before getting categories Query to get specific category list
8 0.73492503166199 After getting categories Query to get specific category list
9 0.73492693901062 Before getting category custom Before call to function getCategoryCustom
10 0.73757195472717 After getting category custom After call to function getCategoryCustom
11 0.7375750541687 Before getting category custom Before call to function getCategoryCustom
12 0.75011897087097 After getting category custom After call to function getCategoryCustom
13 0.75012111663818 Before getting category custom Before call to function getCategoryCustom
14 0.75541806221008 After getting category custom After call to function getCategoryCustom
15 0.75542402267456 Before getting category custom Before call to function getCategoryCustom
16 0.75887894630432 After getting category custom After call to function getCategoryCustom
17 0.75888109207153 Before getting category custom Before call to function getCategoryCustom
18 0.76303505897522 After getting category custom After call to function getCategoryCustom
19 0.76303696632385 Before getting category custom Before call to function getCategoryCustom
20 0.76727199554443 After getting category custom After call to function getCategoryCustom
21 0.76727509498596 End of GetCategoryList function End of the function
22 0.76727914810181 End of getCategoryListByGroup Function Before return()
23 0.77619004249573 App Controller End End of the App controller (called before the controller of every page)
24 0.77682614326477 Product Start Start of the product info controller
25 0.7833149433136 Cache file not found Starting get product details
26 0.81202101707458 Related products Start getting related products if enabled
27 0.8120231628418 Related Products Start Before the related products are found
28 0.81202411651611 Related Products Keywords Before the related product keywords are found
29 0.81202816963196 Create Keyword List Function Start of function
30 0.81209206581116 Create Keyword List Function After looping provided content - 9 keywords found
31 0.81249213218689 Create Keyword List Function After looping initial keyword list - 9 keywords remaining
32 0.81249809265137 Create Keyword List Function After reducing keyword list
33 0.81251096725464 Create Keyword List Function After selecting by scoring keywords
34 0.81251502037048 Create Keyword List Function After final loop of keywords
35 0.81251811981201 Related Products Keywords After the related product keywords are found
36 0.82933712005615 Related Products End After the related products are found
37 0.83691096305847 Product End End of the product info controller (Product Info)
38 0.8379180431366 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.83860993385315 Before Get Options Before the call to getOptions in the tpl class
40 0.86766815185547 After Get Options After the call to getOptions in the tpl class
41 0.86779499053955 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.86782312393188 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 1.025074005127 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 1.0250799655914 Product Info: Before Template Display Before the template is displayed
45 1.1513171195984 Product Info: After Template Display After the template is displayed
46 1.1513330936432 Finalizing debug Before the debug is output to the page.
47 1.1513481140137 End of App This is the end of the app logging, final timestamp


Query Debug - 229 Database Queries. Total time 0.1309 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00066900253295898
SELECT parameter, value FROM parameters
2 0.0011 0.0010619163513184
SELECT * FROM `bad_bots`
3 0.0004 0.00044488906860352
SET time_zone = 'Europe/London'
4 0.0003 0.00028085708618164
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0022 0.0022208690643311
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"54.224.117.125\";}'
6 0.0014 0.0014410018920898
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1642906743'
7 0.0007 0.00069522857666016
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00040292739868164
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0010 0.0010099411010742
SELECT id FROM pages WHERE pagename = 'pompadoursupreme-rooibos-caramel-10cipsulas' LIMIT 1
10 0.0011 0.0010979175567627
SELECT id FROM products WHERE pagename = 'pompadoursupreme-rooibos-caramel-10cipsulas' AND hidden = 0 LIMIT 1
11 0.0016 0.0015711784362793
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0011 0.001115083694458
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0007 0.00069594383239746
SELECT * FROM pages WHERE pagename = 'pompadoursupreme-rooibos-caramel-10cipsulas'
14 0.0003 0.00028300285339355
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00040602684020996
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00026082992553711
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.00024986267089844
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.0003 0.00030303001403809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.0002448558807373
SELECT id FROM categories WHERE parent_id = '26'
20 0.0003 0.00028800964355469
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.00024104118347168
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.00031495094299316
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0003 0.00026798248291016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00035500526428223
SELECT * FROM categorygroups WHERE id = '1'
25 0.0062 0.0061740875244141
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.00044107437133789
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.00022697448730469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00022482872009277
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.004331111907959
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0003 0.0003349781036377
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.00025677680969238
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.00022292137145996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00022006034851074
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0016560554504395
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0005 0.00049090385437012
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.00025701522827148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00023102760314941
SELECT id FROM categories WHERE parent_id = '28'
38 0.0014 0.0014429092407227
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.0004 0.00037789344787598
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.00029683113098145
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.00021505355834961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00021696090698242
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.000640869140625
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.0004 0.00042200088500977
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.00042891502380371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00026488304138184
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00064301490783691
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.0002589225769043
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.00022697448730469
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.00021600723266602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.0002448558807373
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00061202049255371
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.00035786628723145
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.00034713745117188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00038790702819824
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00066995620727539
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.0004 0.0003972053527832
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0004 0.0004119873046875
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.0005 0.00047397613525391
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00040292739868164
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00078797340393066
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.00036501884460449
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.0004 0.00039315223693848
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.0002448558807373
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00066113471984863
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.0004 0.00040507316589355
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.0005 0.00049805641174316
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.00036501884460449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00042295455932617
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00036215782165527
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00027990341186523
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0005 0.00053906440734863
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.0005 0.00048279762268066
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0007 0.00074195861816406
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00061202049255371
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0004 0.00039792060852051
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.0004 0.00039792060852051
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0004 0.00040507316589355
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0008 0.00078082084655762
SELECT * FROM products WHERE pagename = 'pompadoursupreme-rooibos-caramel-10cipsulas'
80 0.0009 0.00093221664428711
UPDATE products SET viewcount = viewcount + 1 WHERE id = 994
81 0.0010 0.00096702575683594
SELECT * FROM manufacturers WHERE id = '182'
82 0.0008 0.00080990791320801
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '182'
83 0.0005 0.00050783157348633
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '182' LIMIT 1
84 0.0011 0.0011401176452637
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '182' ORDER BY RAND() LIMIT 1
85 0.0005 0.00046801567077637
SELECT * FROM productimages WHERE product_id = '994' ORDER BY sortorder ASC
86 0.0005 0.00049710273742676
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '182'
87 0.0009 0.00087714195251465
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '182'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0005 0.00052309036254883
SELECT * FROM manufacturerimages WHERE manufacturer_id = '182'
89 0.0006 0.00058507919311523
SELECT category_id FROM products_categories WHERE product_id = '994'
90 0.0004 0.00043988227844238
SELECT * FROM categories WHERE id = '27'
91 0.0067 0.0067069530487061
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.00036811828613281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0003 0.00029611587524414
SELECT id FROM categories WHERE parent_id = '27'
94 0.0052 0.0051620006561279
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.0005 0.0004889965057373
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.0005 0.00052905082702637
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.0005 0.00051999092102051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0004 0.0003809928894043
SELECT * FROM productimages WHERE product_id = '994' ORDER BY sortorder ASC
99 0.0004 0.00036907196044922
SELECT * FROM product_image_select WHERE product_id = '994'
100 0.0003 0.00031900405883789
SELECT * FROM productcustomimages WHERE product_id = '994'
101 0.0005 0.00054383277893066
SELECT * FROM productfeeds WHERE product_id = '994' ORDER BY item_date DESC
102 0.0007 0.00071597099304199
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '994' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0007 0.00073790550231934
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '994' AND t.hidden = 0 AND display_product = 1
104 0.0007 0.00070500373840332
SELECT * FROM productamazoncontent WHERE product_id = '994'
105 0.0011 0.001115083694458
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '994' AND a.name = n.originalname
106 0.0011 0.0011489391326904
SELECT * FROM productoffers WHERE product_id = '994' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0004 0.00043702125549316
SELECT * FROM productoffers
                WHERE product_id = '994' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '994' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0003 0.00025105476379395
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.0079 0.0079009532928467
SELECT *, MATCH (description, title) AGAINST ('pompadoursupreme rooibos caramel' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('pompadoursupreme rooibos caramel' IN BOOLEAN MODE) AND 994 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
111 0.0007 0.00067687034606934
SELECT *, MATCH (description, title) AGAINST ('pompadoursupreme rooibos caramel' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('pompadoursupreme rooibos caramel' IN BOOLEAN MODE) AND 994 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
112 0.0005 0.00053596496582031
SELECT *, MATCH (description, title) AGAINST ('pompadoursupreme rooibos caramel' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('pompadoursupreme rooibos caramel' IN BOOLEAN MODE) AND 994 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
113 0.0003 0.00029182434082031
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
114 0.0002 0.00024294853210449
SELECT * FROM product_image_select WHERE product_id = '862'
115 0.0003 0.00028800964355469
SELECT * FROM productcustomimages WHERE product_id = '862'
116 0.0003 0.00032997131347656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
117 0.0005 0.00054097175598145
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0005 0.00048494338989258
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0003 0.00029301643371582
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0004 0.0003669261932373
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
121 0.0003 0.00026297569274902
SELECT * FROM product_image_select WHERE product_id = '858'
122 0.0004 0.0003511905670166
SELECT * FROM productcustomimages WHERE product_id = '858'
123 0.0004 0.00038695335388184
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
124 0.0004 0.0003819465637207
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0004 0.00044107437133789
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00033688545227051
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0003 0.00027799606323242
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
128 0.0002 0.00023508071899414
SELECT * FROM product_image_select WHERE product_id = '878'
129 0.0002 0.00023293495178223
SELECT * FROM productcustomimages WHERE product_id = '878'
130 0.0003 0.00026392936706543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
131 0.0004 0.00035810470581055
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0004 0.00043892860412598
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0002 0.00023388862609863
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0003 0.00031900405883789
SELECT id,asin FROM products WHERE parent_id = 994
135 0.0002 0.00023913383483887
SELECT category_id FROM products_categories WHERE product_id = '994'
136 0.0003 0.00025582313537598
SELECT * FROM categories WHERE id = '27'
137 0.0002 0.00023102760314941
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.0002 0.00023102760314941
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
139 0.0002 0.00023198127746582
SELECT id FROM categories WHERE parent_id = '27'
140 0.0002 0.00023007392883301
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.0002 0.00022602081298828
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.0002 0.00023198127746582
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.0002 0.00023198127746582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
144 0.0002 0.00024294853210449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '994' AND a.name = n.originalname
145 0.0003 0.00025796890258789
SELECT * FROM productoffers WHERE product_id = '994' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0003 0.0002601146697998
SELECT * FROM productoffers
                WHERE product_id = '994' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0004 0.00040292739868164
SELECT * FROM products WHERE id = '994'
148 0.0003 0.00026202201843262
SELECT value FROM productattributes WHERE product_id = '994' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0002 0.00024795532226562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '994' AND a.name = n.originalname
150 0.0003 0.00028896331787109
SELECT * FROM productoffers WHERE product_id = '994' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0003 0.00026702880859375
SELECT * FROM productoffers
                WHERE product_id = '994' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0003 0.00032711029052734
SELECT category_id FROM products_categories WHERE product_id = '994' AND prod_type = 'amz'
153 0.0003 0.00025391578674316
SELECT parent_id FROM categories WHERE id = '27'
154 0.0003 0.00026488304138184
SELECT * FROM categories WHERE id = '27'
155 0.0002 0.00021696090698242
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.00023007392883301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
157 0.0002 0.0002288818359375
SELECT id FROM categories WHERE parent_id = '27'
158 0.0002 0.00023198127746582
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.00023484230041504
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.0002751350402832
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.00024604797363281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
162 0.0004 0.00038504600524902
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
163 0.0004 0.00038790702819824
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
164 0.0002 0.00023889541625977
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
165 0.0003 0.00026893615722656
SELECT * FROM pages WHERE id = 38
166 0.0065 0.0065360069274902
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.0020 0.002007007598877
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:1642906744;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'
168 0.0005 0.0005180835723877
SELECT * FROM products WHERE id = 790
169 0.0004 0.00038599967956543
SELECT * FROM products WHERE id = 788
170 0.0004 0.00043606758117676
SELECT * FROM products WHERE id = 787
171 0.0004 0.00043606758117676
SELECT * FROM products WHERE id = 1287
172 0.0004 0.00043106079101562
SELECT * FROM products WHERE id = 780
173 0.0004 0.00038504600524902
SELECT * FROM products WHERE id = 779
174 0.0004 0.00043106079101562
SELECT * FROM products WHERE id = '790'
175 0.0003 0.00033307075500488
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
176 0.0002 0.00023984909057617
SELECT * FROM product_image_select WHERE product_id = '790'
177 0.0003 0.00026798248291016
SELECT * FROM productcustomimages WHERE product_id = '790'
178 0.0003 0.00028204917907715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
179 0.0003 0.00027203559875488
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0002 0.00023484230041504
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0002 0.00022792816162109
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0004 0.00040507316589355
SELECT * FROM products WHERE id = '788'
183 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
184 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '788'
185 0.0002 0.00023388862609863
SELECT * FROM productcustomimages WHERE product_id = '788'
186 0.0002 0.00022387504577637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
187 0.0002 0.00023484230041504
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0003 0.00028896331787109
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0002 0.00020503997802734
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0004 0.00041890144348145
SELECT * FROM products WHERE id = '787'
191 0.0003 0.00026702880859375
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
192 0.0002 0.0002288818359375
SELECT * FROM product_image_select WHERE product_id = '787'
193 0.0002 0.00021195411682129
SELECT * FROM productcustomimages WHERE product_id = '787'
194 0.0002 0.0002129077911377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
195 0.0002 0.0002439022064209
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0002 0.00023794174194336
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0002 0.00020313262939453
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0004 0.00043392181396484
SELECT * FROM products WHERE id = '1287'
199 0.0003 0.00028395652770996
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
200 0.0003 0.00025796890258789
SELECT * FROM product_image_select WHERE product_id = '1287'
201 0.0002 0.00024604797363281
SELECT * FROM productcustomimages WHERE product_id = '1287'
202 0.0002 0.00023603439331055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
203 0.0002 0.00022482872009277
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0002 0.0002439022064209
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0002 0.0001988410949707
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0004 0.00037813186645508
SELECT * FROM products WHERE id = '780'
207 0.0003 0.00026488304138184
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
208 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '780'
209 0.0002 0.00024700164794922
SELECT * FROM productcustomimages WHERE product_id = '780'
210 0.0003 0.00025010108947754
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
211 0.0003 0.00027704238891602
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0003 0.00026297569274902
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0002 0.00022006034851074
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0005 0.00046610832214355
SELECT * FROM products WHERE id = '779'
215 0.0003 0.00031185150146484
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
216 0.0002 0.00023293495178223
SELECT * FROM product_image_select WHERE product_id = '779'
217 0.0003 0.00028014183044434
SELECT * FROM productcustomimages WHERE product_id = '779'
218 0.0002 0.00023102760314941
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
219 0.0002 0.00024318695068359
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0003 0.00025010108947754
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0003 0.00028800964355469
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
223 0.0003 0.00029706954956055
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
224 0.0006 0.0006258487701416
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
225 0.0004 0.00036311149597168
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
226 0.0004 0.00037813186645508
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
227 0.0005 0.00046300888061523
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
228 0.0004 0.00043392181396484
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
229 0.0004 0.00036382675170898
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'