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:00 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.98980498313904 244 0.1529 0


No Amazon API Requests Made.

Total time 0.98980498313904 seconds

Number Time From Start Name Description
1 0.78270983695984 Initialise Initialise FSB Function
2 0.78475904464722 App Controller Start Start of the App controller (called before the controller of every page)
3 0.78777003288269 Start of getCategoryListByGroup Function Before first category groups query
4 0.78802490234375 After initial query Before first category groups query
5 0.78802704811096 Get Category List for Group Before the call to getCategoryList function
6 0.78803086280823 Start of GetCategoryList function Start of the function
7 0.78803396224976 Before getting categories Query to get specific category list
8 0.78833794593811 After getting categories Query to get specific category list
9 0.78833889961243 Before getting category custom Before call to function getCategoryCustom
10 0.79053401947021 After getting category custom After call to function getCategoryCustom
11 0.79053783416748 Before getting category custom Before call to function getCategoryCustom
12 0.80527997016907 After getting category custom After call to function getCategoryCustom
13 0.80528593063354 Before getting category custom Before call to function getCategoryCustom
14 0.81058382987976 After getting category custom After call to function getCategoryCustom
15 0.81058692932129 Before getting category custom Before call to function getCategoryCustom
16 0.81345701217651 After getting category custom After call to function getCategoryCustom
17 0.81345987319946 Before getting category custom Before call to function getCategoryCustom
18 0.81607699394226 After getting category custom After call to function getCategoryCustom
19 0.81607890129089 Before getting category custom Before call to function getCategoryCustom
20 0.81912398338318 After getting category custom After call to function getCategoryCustom
21 0.81912684440613 End of GetCategoryList function End of the function
22 0.81913495063782 End of getCategoryListByGroup Function Before return()
23 0.82378792762756 App Controller End End of the App controller (called before the controller of every page)
24 0.82439589500427 Product Start Start of the product info controller
25 0.84351587295532 Cache file not found Starting get product details
26 0.87913584709167 Related products Start getting related products if enabled
27 0.87913799285889 Related Products Start Before the related products are found
28 0.8791389465332 Related Products Keywords Before the related product keywords are found
29 0.87914490699768 Create Keyword List Function Start of function
30 0.87924003601074 Create Keyword List Function After looping provided content - 21 keywords found
31 0.88015198707581 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
32 0.88015985488892 Create Keyword List Function After reducing keyword list
33 0.88021397590637 Create Keyword List Function After selecting by scoring keywords
34 0.88021898269653 Create Keyword List Function After final loop of keywords
35 0.88022089004517 Related Products Keywords After the related product keywords are found
36 0.91931104660034 Related Products End After the related products are found
37 0.92828893661499 Product End End of the product info controller (Product Info)
38 0.92929697036743 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.93016004562378 Before Get Options Before the call to getOptions in the tpl class
40 0.95814800262451 After Get Options After the call to getOptions in the tpl class
41 0.95828104019165 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.95831298828125 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.9707510471344 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.97075581550598 Product Info: Before Template Display Before the template is displayed
45 0.98977494239807 Product Info: After Template Display After the template is displayed
46 0.98978996276855 Finalizing debug Before the debug is output to the page.
47 0.98980402946472 End of App This is the end of the app logging, final timestamp


Query Debug - 244 Database Queries. Total time 0.1529 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00058293342590332
SELECT parameter, value FROM parameters
2 0.0007 0.00070309638977051
SELECT * FROM `bad_bots`
3 0.0003 0.00026297569274902
SET time_zone = 'Europe/London'
4 0.0002 0.00023603439331055
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0014 0.0014088153839111
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.227.235.216\";}'
6 0.0010 0.0009610652923584
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632224702'
7 0.0004 0.00037002563476562
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0011 0.0010559558868408
UPDATE autorun SET lastrun = '2021-09-21 11:45:02' WHERE id = '17'
9 0.0003 0.00030899047851562
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0004 0.0004119873046875
SELECT id FROM pages WHERE pagename = 'alister-lloyd-the-rooibos-608-soleil-rouge' LIMIT 1
11 0.0006 0.00058698654174805
SELECT id FROM products WHERE pagename = 'alister-lloyd-the-rooibos-608-soleil-rouge' AND hidden = 0 LIMIT 1
12 0.0009 0.00093793869018555
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
13 0.0009 0.00088906288146973
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
14 0.0006 0.0005950927734375
SELECT * FROM pages WHERE pagename = 'alister-lloyd-the-rooibos-608-soleil-rouge'
15 0.0002 0.0002439022064209
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0003 0.00028514862060547
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0002 0.00022101402282715
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.0002 0.00022196769714355
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.0003 0.00026893615722656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0002 0.00020718574523926
SELECT id FROM categories WHERE parent_id = '26'
21 0.0002 0.0002281665802002
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.0002 0.00022101402282715
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.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 (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0002 0.00020313262939453
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0002 0.00024199485778809
SELECT * FROM categorygroups WHERE id = '1'
26 0.0072 0.0072131156921387
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.0008 0.00082898139953613
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.0002 0.00022101402282715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0002 0.00020503997802734
SELECT id FROM categories WHERE parent_id = '27'
30 0.0044 0.0043821334838867
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.0004 0.00036096572875977
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.0002 0.00022602081298828
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.0002 0.00019407272338867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0009 0.00094485282897949
SELECT * FROM categorygroups WHERE id = '1'
35 0.0021 0.0021390914916992
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.00020313262939453
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.0002 0.00019311904907227
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0002 0.00018310546875
SELECT id FROM categories WHERE parent_id = '28'
39 0.0017 0.0016999244689941
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.00020289421081543
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.00018000602722168
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.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0002 0.00019097328186035
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00065898895263672
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.0002288818359375
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.00019288063049316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.00062990188598633
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.00021791458129883
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.00020313262939453
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.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0002 0.00021600723266602
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00056886672973633
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.0002 0.00018405914306641
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.00020289421081543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0002 0.00018501281738281
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.00059199333190918
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.00023603439331055
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.00017690658569336
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.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0002 0.00018811225891113
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00060677528381348
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.00024318695068359
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.00018215179443359
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0002 0.0002129077911377
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00059914588928223
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.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 (31)
				  AND p.disabled = 0 
68 0.0002 0.00020694732666016
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.0002 0.0001828670501709
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0002 0.00018811225891113
SELECT * FROM categorygroups WHERE id = '1'
71 0.0002 0.00022602081298828
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0002 0.00023889541625977
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0003 0.00026798248291016
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.0002140998840332
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0005 0.00053501129150391
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0004 0.00040292739868164
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0002 0.0002439022064209
SELECT * FROM ipgeocountries WHERE INET_ATON('3.227.235.216') >= INET_ATON(ip_start) AND INET_ATON('3.227.235.216') <= INET_ATON(ip_end)
78 0.0002 0.00020885467529297
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0002 0.00019502639770508
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00062704086303711
SELECT * FROM products WHERE pagename = 'alister-lloyd-the-rooibos-608-soleil-rouge'
81 0.0013 0.0012798309326172
UPDATE products SET viewcount = viewcount + 1 WHERE id = 864
82 0.0003 0.00030899047851562
SELECT * FROM manufacturers WHERE id = '173'
83 0.0008 0.00076103210449219
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '173'
84 0.0002 0.00018882751464844
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '173' LIMIT 1
85 0.0007 0.00073504447937012
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.0003 0.00026988983154297
SELECT * FROM productimages WHERE product_id = '864' ORDER BY sortorder ASC
87 0.0002 0.00019001960754395
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '173'
88 0.0006 0.0005650520324707
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.0003 0.00029206275939941
SELECT * FROM manufacturerimages WHERE manufacturer_id = '173'
90 0.0004 0.00041413307189941
SELECT category_id FROM products_categories WHERE product_id = '864'
91 0.0002 0.0002439022064209
SELECT * FROM categories WHERE id = '27'
92 0.0057 0.0056588649749756
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.0004 0.00044918060302734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0002 0.00022602081298828
SELECT id FROM categories WHERE parent_id = '27'
95 0.0048 0.0047609806060791
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.0006 0.00063586235046387
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.00024890899658203
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.00023603439331055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0002 0.0002138614654541
SELECT * FROM productimages WHERE product_id = '864' ORDER BY sortorder ASC
100 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '864'
101 0.0003 0.00033307075500488
SELECT * FROM productcustomimages WHERE product_id = '864'
102 0.0005 0.00053286552429199
SELECT * FROM productfeeds WHERE product_id = '864' ORDER BY item_date DESC
103 0.0007 0.0006711483001709
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.0015 0.0014879703521729
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.0003 0.00026106834411621
SELECT * FROM tags WHERE id = '58'
106 0.0033 0.0033290386199951
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.0030 0.0030369758605957
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.0027 0.0026969909667969
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.0006 0.00058388710021973
SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
110 0.0009 0.00091290473937988
SELECT * FROM productamazoncontent WHERE product_id = '864'
111 0.0014 0.0014069080352783
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.00053787231445312
SELECT * FROM productoffers WHERE product_id = '864' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0005 0.00049591064453125
SELECT * FROM productoffers
                WHERE product_id = '864' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0005 0.00046896934509277
SELECT * FROM productoffers
                WHERE product_id = 864
                ORDER BY price ASC LIMIT 1
115 0.0006 0.0005791187286377
SELECT value FROM productattributes
                WHERE product_id = '864'
                AND name = 'ListPriceAmount'
116 0.0005 0.00053787231445312
SELECT value FROM productattributes WHERE product_id = '864' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0003 0.00026607513427734
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.0110 0.010974884033203
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.0008 0.00076007843017578
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.0006 0.00063085556030273
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.0130 0.013001918792725
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.00050806999206543
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.00049209594726562
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.0003 0.00027108192443848
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
125 0.0002 0.00019502639770508
SELECT * FROM product_image_select WHERE product_id = '858'
126 0.0002 0.00021791458129883
SELECT * FROM productcustomimages WHERE product_id = '858'
127 0.0011 0.0011329650878906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
128 0.0005 0.00051403045654297
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0008 0.00078701972961426
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0007 0.00068211555480957
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0003 0.00027298927307129
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
132 0.0002 0.00024509429931641
SELECT * FROM product_image_select WHERE product_id = '878'
133 0.0002 0.00022387504577637
SELECT * FROM productcustomimages WHERE product_id = '878'
134 0.0017 0.0016570091247559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
135 0.0006 0.0005800724029541
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0006 0.00063490867614746
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0006 0.00055313110351562
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0003 0.00029206275939941
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
139 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '862'
140 0.0003 0.00025796890258789
SELECT * FROM productcustomimages WHERE product_id = '862'
141 0.0008 0.00077295303344727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
142 0.0005 0.00047993659973145
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0005 0.00046420097351074
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0014 0.0014259815216064
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0004 0.00040817260742188
SELECT id,asin FROM products WHERE parent_id = 864
146 0.0002 0.00024795532226562
SELECT category_id FROM products_categories WHERE product_id = '864'
147 0.0003 0.0002591609954834
SELECT * FROM categories WHERE id = '27'
148 0.0002 0.00020194053649902
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.00023198127746582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
150 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '27'
151 0.0002 0.00023388862609863
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.00021505355834961
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.00021600723266602
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.00023603439331055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
155 0.0003 0.00025486946105957
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.0002129077911377
SELECT * FROM productoffers WHERE product_id = '864' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0002 0.00023889541625977
SELECT * FROM productoffers
                WHERE product_id = '864' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0002 0.00023889541625977
SELECT * FROM productoffers
                WHERE product_id = 864
                ORDER BY price ASC LIMIT 1
159 0.0003 0.00026297569274902
SELECT value FROM productattributes
                WHERE product_id = '864'
                AND name = 'ListPriceAmount'
160 0.0006 0.00059986114501953
SELECT * FROM products WHERE id = '864'
161 0.0002 0.00022602081298828
SELECT value FROM productattributes WHERE product_id = '864' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0003 0.00027704238891602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '864' AND a.name = n.originalname
163 0.0003 0.00026202201843262
SELECT * FROM productoffers WHERE product_id = '864' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0003 0.0003199577331543
SELECT * FROM productoffers
                WHERE product_id = '864' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0003 0.00032305717468262
SELECT * FROM productoffers
                WHERE product_id = 864
                ORDER BY price ASC LIMIT 1
166 0.0002 0.00024318695068359
SELECT value FROM productattributes
                WHERE product_id = '864'
                AND name = 'ListPriceAmount'
167 0.0006 0.00057816505432129
SELECT category_id FROM products_categories WHERE product_id = '864' AND prod_type = 'amz'
168 0.0003 0.00028586387634277
SELECT parent_id FROM categories WHERE id = '27'
169 0.0003 0.0003359317779541
SELECT * FROM categories WHERE id = '27'
170 0.0002 0.00022506713867188
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.00022697448730469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
172 0.0002 0.00020098686218262
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.00018787384033203
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.00019216537475586
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.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
177 0.0003 0.00033998489379883
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
178 0.0006 0.00058889389038086
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
179 0.0002 0.00018692016601562
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
180 0.0011 0.0010890960693359
SELECT * FROM pages WHERE id = 38
181 0.0054 0.0054190158843994
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.00053715705871582
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:1632224702;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"779|amazon\";i:5;s:10:\"777|amazon\";}}' WHERE id = '160'
183 0.0006 0.0005638599395752
SELECT * FROM products WHERE id = 790
184 0.0005 0.00046586990356445
SELECT * FROM products WHERE id = 788
185 0.0005 0.00051712989807129
SELECT * FROM products WHERE id = 787
186 0.0005 0.00047516822814941
SELECT * FROM products WHERE id = 1287
187 0.0005 0.00046896934509277
SELECT * FROM products WHERE id = 779
188 0.0005 0.00046682357788086
SELECT * FROM products WHERE id = 777
189 0.0005 0.00047612190246582
SELECT * FROM products WHERE id = '790'
190 0.0003 0.00032901763916016
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
191 0.0003 0.00026917457580566
SELECT * FROM product_image_select WHERE product_id = '790'
192 0.0004 0.00038313865661621
SELECT * FROM productcustomimages WHERE product_id = '790'
193 0.0003 0.00029993057250977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
194 0.0004 0.00036382675170898
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0004 0.00040292739868164
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0002 0.0002140998840332
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0005 0.00049304962158203
SELECT * FROM products WHERE id = '788'
198 0.0002 0.00023889541625977
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
199 0.0002 0.00020384788513184
SELECT * FROM product_image_select WHERE product_id = '788'
200 0.0002 0.00021696090698242
SELECT * FROM productcustomimages WHERE product_id = '788'
201 0.0002 0.00022196769714355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
202 0.0002 0.00022792816162109
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0002 0.00022315979003906
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0002 0.00022315979003906
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0004 0.00043106079101562
SELECT * FROM products WHERE id = '787'
206 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
207 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '787'
208 0.0002 0.00021719932556152
SELECT * FROM productcustomimages WHERE product_id = '787'
209 0.0002 0.00021481513977051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
210 0.0002 0.00024104118347168
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0002 0.00018095970153809
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0005 0.00047206878662109
SELECT * FROM products WHERE id = '1287'
214 0.0003 0.00030088424682617
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
215 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '1287'
216 0.0002 0.00020289421081543
SELECT * FROM productcustomimages WHERE product_id = '1287'
217 0.0002 0.00023484230041504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
218 0.0002 0.00020813941955566
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0002 0.00021100044250488
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0005 0.00047707557678223
SELECT * FROM products WHERE id = '779'
222 0.0002 0.00022292137145996
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
223 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '779'
224 0.0002 0.00024318695068359
SELECT * FROM productcustomimages WHERE product_id = '779'
225 0.0002 0.00021600723266602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
226 0.0002 0.00023508071899414
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0002 0.00020217895507812
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0005 0.00046396255493164
SELECT * FROM products WHERE id = '777'
230 0.0002 0.00022315979003906
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
231 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '777'
232 0.0002 0.00020599365234375
SELECT * FROM productcustomimages WHERE product_id = '777'
233 0.0002 0.00023198127746582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
234 0.0002 0.00024104118347168
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0002 0.00023388862609863
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0002 0.00019216537475586
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0003 0.00026679039001465
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
238 0.0003 0.00028800964355469
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
239 0.0009 0.00092387199401855
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
240 0.0004 0.00036096572875977
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
241 0.0003 0.00031495094299316
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
242 0.0004 0.00035405158996582
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
243 0.0003 0.00033402442932129
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
244 0.0003 0.00025701522827148
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'