Alister & Lloyd - Thé Rooibos - 608 Soleil Rouge

Alister & Lloyd - Thé Rooibos - 608 Soleil Rouge
Alister & Lloyd - Thé Rooibos - 608 Soleil Rouge (cliquez sur les images pour élargir)
€4,90
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-07-21 13: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.

Description du Fabricant

Rooibos parfumé aux fruits rouges agrémenté de morceaux de fraise, cassis, framboise, myrtille et parsemé de pétales de rose et d'hibiscus. Flacon de 55g. Alister & Lloyd, maison de négoce de thés, recherche pour vous la perfection de ce breuvage. Au coeur des plus beaux jardins de thés, Alister & Lloyd sélectionne les feuilles de calibres parfaits afin d'apporter à votre tasse toute l'excellence d'une liqueur symbole de correspondances exotiques.

Caractéristiques du Produit

Rooibos parfumé aux fruits rouges agrémenté de morceaux de fraise, cassis, framboise, myrtille et parsemé de pétales de rose et d'hibiscus. En flacon de 55 gr pour garder toute sa fraicheur Alister & Lloyd, maison de négoce de thés, recherche pour vous la perfection de ce breuvage. Au coeur des plus beaux jardins de thés, Allister & Lloyd sélectionne les feuilles de calibres parfaits afin d'apporter à votre tasse toute l'excellence d'une liqueur symbole de correspondances exotiques.
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.88334703445435 244 0.1492 0


No Amazon API Requests Made.

Total time 0.88334703445435 seconds

Number Time From Start Name Description
1 0.59210705757141 Initialise Initialise FSB Function
2 0.59588384628296 App Controller Start Start of the App controller (called before the controller of every page)
3 0.59994602203369 Start of getCategoryListByGroup Function Before first category groups query
4 0.60030102729797 After initial query Before first category groups query
5 0.60030388832092 Get Category List for Group Before the call to getCategoryList function
6 0.60030794143677 Start of GetCategoryList function Start of the function
7 0.60031294822693 Before getting categories Query to get specific category list
8 0.60074496269226 After getting categories Query to get specific category list
9 0.60075902938843 Before getting category custom Before call to function getCategoryCustom
10 0.62040185928345 After getting category custom After call to function getCategoryCustom
11 0.62040400505066 Before getting category custom Before call to function getCategoryCustom
12 0.63525986671448 After getting category custom After call to function getCategoryCustom
13 0.63526391983032 Before getting category custom Before call to function getCategoryCustom
14 0.64072489738464 After getting category custom After call to function getCategoryCustom
15 0.64072799682617 Before getting category custom Before call to function getCategoryCustom
16 0.64361500740051 After getting category custom After call to function getCategoryCustom
17 0.64361786842346 Before getting category custom Before call to function getCategoryCustom
18 0.64639902114868 After getting category custom After call to function getCategoryCustom
19 0.64640188217163 Before getting category custom Before call to function getCategoryCustom
20 0.64926791191101 After getting category custom After call to function getCategoryCustom
21 0.64927196502686 End of GetCategoryList function End of the function
22 0.64928102493286 End of getCategoryListByGroup Function Before return()
23 0.65793800354004 App Controller End End of the App controller (called before the controller of every page)
24 0.6593029499054 Product Start Start of the product info controller
25 0.66162586212158 Cache file not found Starting get product details
26 0.69046688079834 Related products Start getting related products if enabled
27 0.69046902656555 Related Products Start Before the related products are found
28 0.69046998023987 Related Products Keywords Before the related product keywords are found
29 0.69047498703003 Create Keyword List Function Start of function
30 0.69057202339172 Create Keyword List Function After looping provided content - 21 keywords found
31 0.69145584106445 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
32 0.69146394729614 Create Keyword List Function After reducing keyword list
33 0.6915168762207 Create Keyword List Function After selecting by scoring keywords
34 0.69152092933655 Create Keyword List Function After final loop of keywords
35 0.69152402877808 Related Products Keywords After the related product keywords are found
36 0.71539497375488 Related Products End After the related products are found
37 0.72303795814514 Product End End of the product info controller (Product Info)
38 0.72452187538147 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.72500491142273 Before Get Options Before the call to getOptions in the tpl class
40 0.75384187698364 After Get Options After the call to getOptions in the tpl class
41 0.7540488243103 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.75409293174744 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.84156084060669 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.84156703948975 Product Info: Before Template Display Before the template is displayed
45 0.88331985473633 Product Info: After Template Display After the template is displayed
46 0.88333296775818 Finalizing debug Before the debug is output to the page.
47 0.88334488868713 End of App This is the end of the app logging, final timestamp


Query Debug - 244 Database Queries. Total time 0.1492 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00051617622375488
SELECT parameter, value FROM parameters
2 0.0011 0.0011310577392578
SELECT * FROM `bad_bots`
3 0.0005 0.0005180835723877
SET time_zone = 'Europe/London'
4 0.0005 0.0004730224609375
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0022 0.0021889209747314
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.208.186.139\";}'
6 0.0017 0.0017189979553223
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653498137'
7 0.0006 0.00057291984558105
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00089478492736816
UPDATE autorun SET lastrun = '2022-05-25 17:02:17' WHERE id = '8'
9 0.0003 0.00031399726867676
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0010 0.0010027885437012
SELECT id FROM pages WHERE pagename = 'alister-lloyd-the-rooibos-608-soleil-rouge' LIMIT 1
11 0.0011 0.0010800361633301
SELECT id FROM products WHERE pagename = 'alister-lloyd-the-rooibos-608-soleil-rouge' AND hidden = 0 LIMIT 1
12 0.0016 0.0015628337860107
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
13 0.0010 0.0010321140289307
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
14 0.0006 0.00063204765319824
SELECT * FROM pages WHERE pagename = 'alister-lloyd-the-rooibos-608-soleil-rouge'
15 0.0003 0.00033807754516602
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0004 0.00039887428283691
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0087 0.0087399482727051
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
18 0.0005 0.00050497055053711
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0004 0.00038385391235352
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00037288665771484
SELECT id FROM categories WHERE parent_id = '26'
21 0.0075 0.0075271129608154
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 
22 0.0005 0.00051593780517578
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 
23 0.0006 0.00060510635375977
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
24 0.0003 0.00030303001403809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00052499771118164
SELECT * FROM categorygroups WHERE id = '1'
26 0.0050 0.0050480365753174
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
27 0.0004 0.00042510032653809
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0003 0.00026679039001465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0002 0.00023913383483887
SELECT id FROM categories WHERE parent_id = '27'
30 0.0065 0.0065231323242188
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 
31 0.0009 0.00086808204650879
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 
32 0.0005 0.00045394897460938
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
33 0.0004 0.00042200088500977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00046300888061523
SELECT * FROM categorygroups WHERE id = '1'
35 0.0021 0.002126932144165
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
36 0.0002 0.00024795532226562
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0003 0.00025391578674316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.0015561580657959
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 
40 0.0002 0.00024795532226562
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 
41 0.0002 0.00023484230041504
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
42 0.0002 0.00021600723266602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0002 0.00022792816162109
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00055980682373047
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
45 0.0002 0.00024795532226562
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0002 0.00023698806762695
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0002 0.00023388862609863
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.0005638599395752
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 
49 0.0002 0.00024580955505371
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 
50 0.0002 0.00022292137145996
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
51 0.0002 0.00021195411682129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0002 0.00023603439331055
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00053095817565918
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
54 0.0003 0.00025296211242676
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0002 0.00020313262939453
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0002 0.00020813941955566
SELECT id FROM categories WHERE parent_id = '30'
57 0.0005 0.00053906440734863
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 
58 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 (30)
				  AND p.disabled = 0 
59 0.0002 0.00021100044250488
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
60 0.0002 0.00024795532226562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0002 0.00022506713867188
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00055503845214844
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
63 0.0002 0.00021696090698242
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0002 0.00021791458129883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0002 0.00023293495178223
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00056099891662598
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 
67 0.0002 0.0002131462097168
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 
68 0.0002 0.00021815299987793
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
69 0.0003 0.00026202201843262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.00025701522827148
SELECT * FROM categorygroups WHERE id = '1'
71 0.0003 0.00026893615722656
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0003 0.00029492378234863
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0003 0.00032186508178711
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
74 0.0002 0.00023293495178223
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0005 0.00049281120300293
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0005 0.00046706199645996
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0003 0.00028395652770996
SELECT * FROM ipgeocountries WHERE INET_ATON('18.208.186.139') >= INET_ATON(ip_start) AND INET_ATON('18.208.186.139') <= INET_ATON(ip_end)
78 0.0002 0.00023508071899414
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0002 0.00022792816162109
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0005 0.00054812431335449
SELECT * FROM products WHERE pagename = 'alister-lloyd-the-rooibos-608-soleil-rouge'
81 0.0005 0.00049781799316406
UPDATE products SET viewcount = viewcount + 1 WHERE id = 864
82 0.0003 0.00030207633972168
SELECT * FROM manufacturers WHERE id = '173'
83 0.0006 0.00061798095703125
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '173'
84 0.0002 0.00022387504577637
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '173' LIMIT 1
85 0.0008 0.00075483322143555
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '173' ORDER BY RAND() LIMIT 1
86 0.0002 0.00024104118347168
SELECT * FROM productimages WHERE product_id = '870' ORDER BY sortorder ASC
87 0.0003 0.00026583671569824
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '173'
88 0.0005 0.00054812431335449
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '173'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0002 0.0002448558807373
SELECT * FROM manufacturerimages WHERE manufacturer_id = '173'
90 0.0004 0.00036311149597168
SELECT category_id FROM products_categories WHERE product_id = '864'
91 0.0004 0.00043582916259766
SELECT * FROM categories WHERE id = '27'
92 0.0058 0.0058479309082031
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
93 0.0003 0.0002901554107666
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '27'
95 0.0050 0.0049750804901123
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 
96 0.0002 0.00024604797363281
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 
97 0.0002 0.00020813941955566
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
98 0.0002 0.0001981258392334
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '864' ORDER BY sortorder ASC
100 0.0003 0.00030207633972168
SELECT * FROM product_image_select WHERE product_id = '864'
101 0.0002 0.00021195411682129
SELECT * FROM productcustomimages WHERE product_id = '864'
102 0.0004 0.00037598609924316
SELECT * FROM productfeeds WHERE product_id = '864' ORDER BY item_date DESC
103 0.0006 0.00062203407287598
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '864' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0008 0.00081801414489746
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '864' AND t.hidden = 0 AND display_product = 1
105 0.0002 0.00023198127746582
SELECT * FROM tags WHERE id = '58'
106 0.0020 0.0020270347595215
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0020 0.0019760131835938
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0021 0.0020530223846436
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
109 0.0002 0.00024795532226562
SELECT * FROM productimages WHERE product_id = '4066' ORDER BY sortorder ASC
110 0.0005 0.00054097175598145
SELECT * FROM productamazoncontent WHERE product_id = '864'
111 0.0003 0.00025701522827148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '864' AND a.name = n.originalname
112 0.0005 0.00050997734069824
SELECT * FROM productoffers WHERE product_id = '864' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0005 0.00045490264892578
SELECT * FROM productoffers
                WHERE product_id = '864' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00042581558227539
SELECT * FROM productoffers
                WHERE product_id = 864
                ORDER BY price ASC LIMIT 1
115 0.0003 0.00025200843811035
SELECT value FROM productattributes
                WHERE product_id = '864'
                AND name = 'ListPriceAmount'
116 0.0002 0.0002291202545166
SELECT value FROM productattributes WHERE product_id = '864' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0003 0.0002748966217041
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
118 0.0080 0.0080139636993408
SELECT *, MATCH (description, title) AGAINST ('alister andamp lloyd' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('alister andamp lloyd' IN BOOLEAN MODE) AND 864 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
119 0.0006 0.00059390068054199
SELECT *, MATCH (description, title) AGAINST ('alister andamp lloyd' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('alister andamp lloyd' IN BOOLEAN MODE) AND 864 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
120 0.0005 0.00051188468933105
SELECT *, MATCH (description, title) AGAINST ('alister andamp lloyd' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('alister andamp lloyd' IN BOOLEAN MODE) AND 864 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
121 0.0075 0.0074629783630371
SELECT *, MATCH (description, title) AGAINST ('rooibos 608 soleil' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos 608 soleil' IN BOOLEAN MODE) AND 864 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
122 0.0005 0.00048303604125977
SELECT *, MATCH (description, title) AGAINST ('rooibos 608 soleil' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos 608 soleil' IN BOOLEAN MODE) AND 864 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
123 0.0005 0.00046992301940918
SELECT *, MATCH (description, title) AGAINST ('rooibos 608 soleil' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos 608 soleil' IN BOOLEAN MODE) AND 864 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
124 0.0004 0.00037503242492676
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
125 0.0002 0.00024008750915527
SELECT * FROM product_image_select WHERE product_id = '862'
126 0.0002 0.00023412704467773
SELECT * FROM productcustomimages WHERE product_id = '862'
127 0.0003 0.00028800964355469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
128 0.0002 0.00021910667419434
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0002 0.00023698806762695
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0002 0.00020599365234375
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0003 0.00029587745666504
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
132 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '858'
133 0.0002 0.00020718574523926
SELECT * FROM productcustomimages WHERE product_id = '858'
134 0.0003 0.0002741813659668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
135 0.0004 0.00036716461181641
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0004 0.00038313865661621
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0002 0.00020885467529297
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0002 0.00021004676818848
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
139 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '878'
140 0.0002 0.00020694732666016
SELECT * FROM productcustomimages WHERE product_id = '878'
141 0.0003 0.00028610229492188
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
142 0.0003 0.00033307075500488
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0004 0.00036406517028809
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0002 0.00020813941955566
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0003 0.00031495094299316
SELECT id,asin FROM products WHERE parent_id = 864
146 0.0002 0.00020408630371094
SELECT category_id FROM products_categories WHERE product_id = '864'
147 0.0002 0.00023293495178223
SELECT * FROM categories WHERE id = '27'
148 0.0002 0.00020503997802734
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
149 0.0002 0.00022006034851074
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
150 0.0002 0.00018692016601562
SELECT id FROM categories WHERE parent_id = '27'
151 0.0002 0.00022792816162109
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 
152 0.0002 0.00020122528076172
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 
153 0.0002 0.00019621849060059
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
154 0.0002 0.00020098686218262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
155 0.0002 0.00021982192993164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '864' AND a.name = n.originalname
156 0.0002 0.00022315979003906
SELECT * FROM productoffers WHERE product_id = '864' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0002 0.00021719932556152
SELECT * FROM productoffers
                WHERE product_id = '864' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0002 0.00022387504577637
SELECT * FROM productoffers
                WHERE product_id = 864
                ORDER BY price ASC LIMIT 1
159 0.0002 0.00020003318786621
SELECT value FROM productattributes
                WHERE product_id = '864'
                AND name = 'ListPriceAmount'
160 0.0004 0.00038909912109375
SELECT * FROM products WHERE id = '864'
161 0.0002 0.00022006034851074
SELECT value FROM productattributes WHERE product_id = '864' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0002 0.00024199485778809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '864' AND a.name = n.originalname
163 0.0002 0.0002288818359375
SELECT * FROM productoffers WHERE product_id = '864' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0002 0.00023818016052246
SELECT * FROM productoffers
                WHERE product_id = '864' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = 864
                ORDER BY price ASC LIMIT 1
166 0.0002 0.00023698806762695
SELECT value FROM productattributes
                WHERE product_id = '864'
                AND name = 'ListPriceAmount'
167 0.0003 0.00034594535827637
SELECT category_id FROM products_categories WHERE product_id = '864' AND prod_type = 'amz'
168 0.0002 0.00021100044250488
SELECT parent_id FROM categories WHERE id = '27'
169 0.0002 0.00023198127746582
SELECT * FROM categories WHERE id = '27'
170 0.0002 0.00019311904907227
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
171 0.0002 0.00019502639770508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
172 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '27'
173 0.0002 0.00019598007202148
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 
174 0.0002 0.00019097328186035
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 
175 0.0002 0.00023698806762695
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
176 0.0002 0.00019693374633789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
177 0.0003 0.0002899169921875
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
178 0.0002 0.00020503997802734
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
179 0.0002 0.00019502639770508
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
180 0.0003 0.00025415420532227
SELECT * FROM pages WHERE id = 38
181 0.0044 0.004364013671875
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
182 0.0005 0.00046801567077637
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:1653498137;s:8:\"products\";a:6:{i:0;s:10:\"788|amazon\";i:1;s:10:\"787|amazon\";i:2;s:11:\"1287|amazon\";i:3;s:10:\"780|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
183 0.0004 0.00044894218444824
SELECT * FROM products WHERE id = 788
184 0.0004 0.00041484832763672
SELECT * FROM products WHERE id = 787
185 0.0004 0.00043487548828125
SELECT * FROM products WHERE id = 1287
186 0.0004 0.00039100646972656
SELECT * FROM products WHERE id = 780
187 0.0004 0.00039982795715332
SELECT * FROM products WHERE id = 777
188 0.0004 0.0003969669342041
SELECT * FROM products WHERE id = 776
189 0.0005 0.00049996376037598
SELECT * FROM products WHERE id = '788'
190 0.0003 0.0002892017364502
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
191 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '788'
192 0.0002 0.00021481513977051
SELECT * FROM productcustomimages WHERE product_id = '788'
193 0.0003 0.00025320053100586
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
194 0.0002 0.00023198127746582
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0004 0.00041890144348145
SELECT * FROM products WHERE id = '787'
198 0.0002 0.00022077560424805
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
199 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '787'
200 0.0003 0.00029110908508301
SELECT * FROM productcustomimages WHERE product_id = '787'
201 0.0003 0.00030398368835449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
202 0.0003 0.00031399726867676
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0002 0.00020694732666016
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0005 0.00046420097351074
SELECT * FROM products WHERE id = '1287'
206 0.0003 0.00030207633972168
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
207 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '1287'
208 0.0003 0.00029516220092773
SELECT * FROM productcustomimages WHERE product_id = '1287'
209 0.0003 0.00029087066650391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
210 0.0002 0.00023698806762695
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0002 0.00023818016052246
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0002 0.00020599365234375
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0004 0.00042891502380371
SELECT * FROM products WHERE id = '780'
214 0.0003 0.00026106834411621
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
215 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '780'
216 0.0002 0.00023198127746582
SELECT * FROM productcustomimages WHERE product_id = '780'
217 0.0003 0.00025606155395508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
218 0.0002 0.00022602081298828
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0003 0.00028777122497559
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0004 0.00041604042053223
SELECT * FROM products WHERE id = '777'
222 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
223 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '777'
224 0.0002 0.00022506713867188
SELECT * FROM productcustomimages WHERE product_id = '777'
225 0.0003 0.00032401084899902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
226 0.0003 0.00026392936706543
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0003 0.00027298927307129
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0005 0.00045299530029297
SELECT * FROM products WHERE id = '776'
230 0.0003 0.00025796890258789
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
231 0.0002 0.00023388862609863
SELECT * FROM product_image_select WHERE product_id = '776'
232 0.0002 0.00021004676818848
SELECT * FROM productcustomimages WHERE product_id = '776'
233 0.0002 0.00024318695068359
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
234 0.0002 0.00024318695068359
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0002 0.00022506713867188
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0003 0.00034308433532715
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
238 0.0004 0.00039792060852051
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
239 0.0006 0.00063800811767578
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
240 0.0005 0.00045204162597656
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
241 0.0004 0.00040316581726074
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
242 0.0004 0.00043392181396484
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
243 0.0004 0.0004279613494873
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
244 0.0004 0.00035309791564941
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'