Alister & Lloyd Soleil Rouge - Rooibos Aromatisé Fruits Rouges - 55g

Alister & Lloyd Soleil Rouge - Rooibos Aromatisé Fruits Rouges - 55g
Alister & Lloyd Soleil Rouge - Rooibos Aromatisé Fruits Rouges - 55g (cliquez sur les images pour élargir)
€4,95
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-07-21 12:13:28 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

Flacon de 55g - Alister & Lloyd - Rooibos parfumé aux fruits rouges agrémenté de morceaux de fraise, cassis, framboise, myrtille et parsemé de pétales de rose et d'hibiscus

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 Sans théine et riche en antioxydants, le "buisson rouge" peut se boire à toute heure de la journée Flacon de 55g Temps d'infusion : 3 à 4 mn Alister & Lloyd, c'est toute une gamme de thés verts, de thés noirs, natures ou aromatisés.
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.8667619228363 238 0.1241 0


No Amazon API Requests Made.

Total time 0.8667619228363 seconds

Number Time From Start Name Description
1 0.6744818687439 Initialise Initialise FSB Function
2 0.67681288719177 App Controller Start Start of the App controller (called before the controller of every page)
3 0.68025493621826 Start of getCategoryListByGroup Function Before first category groups query
4 0.68061804771423 After initial query Before first category groups query
5 0.68061995506287 Get Category List for Group Before the call to getCategoryList function
6 0.68062305450439 Start of GetCategoryList function Start of the function
7 0.68062686920166 Before getting categories Query to get specific category list
8 0.68112397193909 After getting categories Query to get specific category list
9 0.68112587928772 Before getting category custom Before call to function getCategoryCustom
10 0.68469095230103 After getting category custom After call to function getCategoryCustom
11 0.68469405174255 Before getting category custom Before call to function getCategoryCustom
12 0.68726396560669 After getting category custom After call to function getCategoryCustom
13 0.68726587295532 Before getting category custom Before call to function getCategoryCustom
14 0.69015192985535 After getting category custom After call to function getCategoryCustom
15 0.69015693664551 Before getting category custom Before call to function getCategoryCustom
16 0.69349408149719 After getting category custom After call to function getCategoryCustom
17 0.69349598884583 Before getting category custom Before call to function getCategoryCustom
18 0.69604086875916 After getting category custom After call to function getCategoryCustom
19 0.69604301452637 Before getting category custom Before call to function getCategoryCustom
20 0.69809603691101 After getting category custom After call to function getCategoryCustom
21 0.69809794425964 End of GetCategoryList function End of the function
22 0.69810199737549 End of getCategoryListByGroup Function Before return()
23 0.70551586151123 App Controller End End of the App controller (called before the controller of every page)
24 0.7061939239502 Product Start Start of the product info controller
25 0.70921993255615 Cache file not found Starting get product details
26 0.73626399040222 Related products Start getting related products if enabled
27 0.73626589775085 Related Products Start Before the related products are found
28 0.73626708984375 Related Products Keywords Before the related product keywords are found
29 0.73627185821533 Create Keyword List Function Start of function
30 0.7363109588623 Create Keyword List Function After looping provided content - 27 keywords found
31 0.73741507530212 Create Keyword List Function After looping initial keyword list - 26 keywords remaining
32 0.73742294311523 Create Keyword List Function After reducing keyword list
33 0.73749494552612 Create Keyword List Function After selecting by scoring keywords
34 0.73749899864197 Create Keyword List Function After final loop of keywords
35 0.7375009059906 Related Products Keywords After the related product keywords are found
36 0.76399707794189 Related Products End After the related products are found
37 0.77400493621826 Product End End of the product info controller (Product Info)
38 0.7751030921936 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.77600693702698 Before Get Options Before the call to getOptions in the tpl class
40 0.80581998825073 After Get Options After the call to getOptions in the tpl class
41 0.80591893196106 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.80595302581787 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.84173798561096 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.84174489974976 Product Info: Before Template Display Before the template is displayed
45 0.86673188209534 Product Info: After Template Display After the template is displayed
46 0.86674690246582 Finalizing debug Before the debug is output to the page.
47 0.86676001548767 End of App This is the end of the app logging, final timestamp


Query Debug - 238 Database Queries. Total time 0.1241 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00050020217895508
SELECT parameter, value FROM parameters
2 0.0009 0.00088715553283691
SELECT * FROM `bad_bots`
3 0.0003 0.00033283233642578
SET time_zone = 'Europe/London'
4 0.0003 0.00025200843811035
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0018 0.0018088817596436
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.227.235.216\";}'
6 0.0013 0.0012650489807129
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632225248'
7 0.0005 0.00052595138549805
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00033998489379883
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.0006561279296875
SELECT id FROM pages WHERE pagename = 'alister-lloyd-soleil-rouge-rooibos-aromatise-fruits-rouges-55g' LIMIT 1
10 0.0006 0.00064206123352051
SELECT id FROM products WHERE pagename = 'alister-lloyd-soleil-rouge-rooibos-aromatise-fruits-rouges-55g' AND hidden = 0 LIMIT 1
11 0.0013 0.001255989074707
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0010 0.00096607208251953
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0007 0.00067281723022461
SELECT * FROM pages WHERE pagename = 'alister-lloyd-soleil-rouge-rooibos-aromatise-fruits-rouges-55g'
14 0.0003 0.00034880638122559
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00047397613525391
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0004 0.00039410591125488
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.0004 0.00038695335388184
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.0004 0.00037884712219238
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00043606758117676
SELECT id FROM categories WHERE parent_id = '26'
20 0.0004 0.00043988227844238
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0003 0.00034713745117188
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.0004 0.00038290023803711
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.00032210350036621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00034117698669434
SELECT * FROM categorygroups WHERE id = '1'
25 0.0003 0.00030517578125
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0002 0.00024700164794922
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.0003 0.00025296211242676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00023412704467773
SELECT id FROM categories WHERE parent_id = '27'
29 0.0003 0.00027012825012207
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.00031518936157227
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.00032186508178711
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0003 0.00026202201843262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00027108192443848
SELECT * FROM categorygroups WHERE id = '1'
34 0.0003 0.00031399726867676
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.0004 0.00038003921508789
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.00026106834411621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00035595893859863
SELECT id FROM categories WHERE parent_id = '28'
38 0.0003 0.00026297569274902
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0003 0.00033712387084961
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.0004 0.00036096572875977
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.00023102760314941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00029587745666504
SELECT * FROM categorygroups WHERE id = '1'
43 0.0003 0.00027799606323242
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.00039577484130859
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.0003 0.00033903121948242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00027704238891602
SELECT id FROM categories WHERE parent_id = '29'
47 0.0004 0.00041699409484863
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.0004 0.00044393539428711
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.0004 0.00041604042053223
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0003 0.00029516220092773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00038599967956543
SELECT * FROM categorygroups WHERE id = '1'
52 0.0002 0.00023889541625977
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0003 0.00031185150146484
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0002 0.00022506713867188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00037193298339844
SELECT id FROM categories WHERE parent_id = '30'
56 0.0002 0.00023102760314941
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.00036096572875977
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0002 0.00024008750915527
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0002 0.00023484230041504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00023818016052246
SELECT * FROM categorygroups WHERE id = '1'
61 0.0002 0.00021600723266602
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0002 0.00021100044250488
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0002 0.00019693374633789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00019407272338867
SELECT id FROM categories WHERE parent_id = '31'
65 0.0002 0.00020313262939453
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0002 0.00023293495178223
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0003 0.00026893615722656
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0002 0.00022101402282715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00022101402282715
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00024914741516113
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0004 0.00039196014404297
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00031590461730957
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.0004 0.00043892860412598
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0006 0.00058794021606445
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00049805641174316
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0004 0.00037312507629395
SELECT * FROM ipgeocountries WHERE INET_ATON('3.227.235.216') >= INET_ATON(ip_start) AND INET_ATON('3.227.235.216') <= INET_ATON(ip_end)
77 0.0004 0.00039982795715332
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.0002901554107666
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.00061893463134766
SELECT * FROM products WHERE pagename = 'alister-lloyd-soleil-rouge-rooibos-aromatise-fruits-rouges-55g'
80 0.0015 0.0014920234680176
UPDATE products SET viewcount = viewcount + 1 WHERE id = 854
81 0.0006 0.00060701370239258
SELECT * FROM manufacturers WHERE id = '221'
82 0.0008 0.00078320503234863
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '221'
83 0.0004 0.00043892860412598
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '221' LIMIT 1
84 0.0009 0.00089812278747559
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '221' ORDER BY RAND() LIMIT 1
85 0.0005 0.00049591064453125
SELECT * FROM productimages WHERE product_id = '854' ORDER BY sortorder ASC
86 0.0005 0.00048494338989258
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '221'
87 0.0009 0.00085091590881348
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '221'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.00043988227844238
SELECT * FROM manufacturerimages WHERE manufacturer_id = '221'
89 0.0005 0.00047993659973145
SELECT category_id FROM products_categories WHERE product_id = '854'
90 0.0005 0.00052714347839355
SELECT * FROM categories WHERE id = '27'
91 0.0064 0.0064129829406738
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.0003 0.00026893615722656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0004 0.00043416023254395
SELECT id FROM categories WHERE parent_id = '27'
94 0.0045 0.0044639110565186
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.0003 0.00032496452331543
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.00045299530029297
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.0004 0.00037097930908203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0004 0.00044989585876465
SELECT * FROM productimages WHERE product_id = '854' ORDER BY sortorder ASC
99 0.0004 0.00040388107299805
SELECT * FROM product_image_select WHERE product_id = '854'
100 0.0005 0.00045609474182129
SELECT * FROM productcustomimages WHERE product_id = '854'
101 0.0005 0.00050187110900879
SELECT * FROM productfeeds WHERE product_id = '854' ORDER BY item_date DESC
102 0.0006 0.00058794021606445
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '854' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0006 0.00063800811767578
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '854' AND t.hidden = 0 AND display_product = 1
104 0.0005 0.00045919418334961
SELECT * FROM productamazoncontent WHERE product_id = '854'
105 0.0011 0.0010900497436523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '854' AND a.name = n.originalname
106 0.0005 0.00048708915710449
SELECT * FROM productoffers WHERE product_id = '854' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0005 0.00048422813415527
SELECT * FROM productoffers
                WHERE product_id = '854' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0007 0.00069999694824219
SELECT * FROM productoffers
                WHERE product_id = 854
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00040197372436523
SELECT value FROM productattributes
                WHERE product_id = '854'
                AND name = 'ListPriceAmount'
110 0.0005 0.00046300888061523
SELECT value FROM productattributes WHERE product_id = '854' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0004 0.00040602684020996
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
112 0.0078 0.0077588558197021
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 854 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00058507919311523
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 854 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0005 0.00047802925109863
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 854 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0080 0.0079710483551025
SELECT *, MATCH (description, title) AGAINST ('rooibos aromatisé fruits' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos aromatisé fruits' IN BOOLEAN MODE) AND 854 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
116 0.0006 0.00056910514831543
SELECT *, MATCH (description, title) AGAINST ('rooibos aromatisé fruits' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos aromatisé fruits' IN BOOLEAN MODE) AND 854 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
117 0.0006 0.0005950927734375
SELECT *, MATCH (description, title) AGAINST ('rooibos aromatisé fruits' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos aromatisé fruits' IN BOOLEAN MODE) AND 854 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
118 0.0003 0.00034618377685547
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
119 0.0005 0.00045895576477051
SELECT * FROM product_image_select WHERE product_id = '878'
120 0.0004 0.00040102005004883
SELECT * FROM productcustomimages WHERE product_id = '878'
121 0.0004 0.00043702125549316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
122 0.0005 0.00049018859863281
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0005 0.00046801567077637
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0004 0.00040006637573242
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0004 0.00035905838012695
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
126 0.0003 0.00028395652770996
SELECT * FROM product_image_select WHERE product_id = '858'
127 0.0004 0.0004119873046875
SELECT * FROM productcustomimages WHERE product_id = '858'
128 0.0003 0.00029993057250977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
129 0.0002 0.00024008750915527
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
130 0.0002 0.00023722648620605
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0002 0.00024294853210449
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0004 0.00040483474731445
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
133 0.0003 0.00027608871459961
SELECT * FROM product_image_select WHERE product_id = '862'
134 0.0002 0.00022697448730469
SELECT * FROM productcustomimages WHERE product_id = '862'
135 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
136 0.0005 0.00046396255493164
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0004 0.00044989585876465
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0004 0.00044393539428711
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0005 0.00052714347839355
SELECT id,asin FROM products WHERE parent_id = 854
140 0.0004 0.00037813186645508
SELECT category_id FROM products_categories WHERE product_id = '854'
141 0.0003 0.00025391578674316
SELECT * FROM categories WHERE id = '27'
142 0.0002 0.00020408630371094
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
143 0.0003 0.00025486946105957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
144 0.0003 0.0002748966217041
SELECT id FROM categories WHERE parent_id = '27'
145 0.0004 0.00040102005004883
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 
146 0.0004 0.00039792060852051
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 
147 0.0002 0.00022196769714355
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
148 0.0002 0.00022602081298828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
149 0.0004 0.00042819976806641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '854' AND a.name = n.originalname
150 0.0004 0.00041317939758301
SELECT * FROM productoffers WHERE product_id = '854' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = '854' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0004 0.00035691261291504
SELECT * FROM productoffers
                WHERE product_id = 854
                ORDER BY price ASC LIMIT 1
153 0.0003 0.00025296211242676
SELECT value FROM productattributes
                WHERE product_id = '854'
                AND name = 'ListPriceAmount'
154 0.0007 0.00070285797119141
SELECT * FROM products WHERE id = '854'
155 0.0003 0.00026583671569824
SELECT value FROM productattributes WHERE product_id = '854' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0003 0.00028419494628906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '854' AND a.name = n.originalname
157 0.0002 0.00023102760314941
SELECT * FROM productoffers WHERE product_id = '854' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0002 0.00024008750915527
SELECT * FROM productoffers
                WHERE product_id = '854' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0002 0.00024318695068359
SELECT * FROM productoffers
                WHERE product_id = 854
                ORDER BY price ASC LIMIT 1
160 0.0002 0.00021004676818848
SELECT value FROM productattributes
                WHERE product_id = '854'
                AND name = 'ListPriceAmount'
161 0.0004 0.00041007995605469
SELECT category_id FROM products_categories WHERE product_id = '854' AND prod_type = 'amz'
162 0.0002 0.00021505355834961
SELECT parent_id FROM categories WHERE id = '27'
163 0.0003 0.0002589225769043
SELECT * FROM categories WHERE id = '27'
164 0.0002 0.00022697448730469
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
165 0.0002 0.00020313262939453
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
166 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '27'
167 0.0002 0.00023984909057617
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 
168 0.0003 0.00030398368835449
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 
169 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
170 0.0002 0.00024104118347168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
171 0.0004 0.0004270076751709
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
172 0.0004 0.00038695335388184
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
173 0.0004 0.00044012069702148
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
174 0.0005 0.00046205520629883
SELECT * FROM pages WHERE id = 38
175 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
176 0.0006 0.00055408477783203
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:1632225248;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'
177 0.0006 0.0006110668182373
SELECT * FROM products WHERE id = 790
178 0.0005 0.00045490264892578
SELECT * FROM products WHERE id = 788
179 0.0005 0.00045013427734375
SELECT * FROM products WHERE id = 787
180 0.0005 0.00047707557678223
SELECT * FROM products WHERE id = 1287
181 0.0005 0.00054717063903809
SELECT * FROM products WHERE id = 779
182 0.0005 0.00046992301940918
SELECT * FROM products WHERE id = 777
183 0.0005 0.00048208236694336
SELECT * FROM products WHERE id = '790'
184 0.0004 0.00041294097900391
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
185 0.0003 0.00029182434082031
SELECT * FROM product_image_select WHERE product_id = '790'
186 0.0003 0.0002739429473877
SELECT * FROM productcustomimages WHERE product_id = '790'
187 0.0004 0.00039196014404297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
188 0.0003 0.00029301643371582
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0003 0.00029706954956055
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0002 0.00022602081298828
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191 0.0005 0.00045323371887207
SELECT * FROM products WHERE id = '788'
192 0.0003 0.00029397010803223
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
193 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '788'
194 0.0002 0.00024604797363281
SELECT * FROM productcustomimages WHERE product_id = '788'
195 0.0003 0.00030684471130371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
196 0.0003 0.00028896331787109
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0003 0.0002741813659668
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0002 0.00021004676818848
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
199 0.0004 0.00043702125549316
SELECT * FROM products WHERE id = '787'
200 0.0003 0.00032806396484375
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
201 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '787'
202 0.0002 0.00023603439331055
SELECT * FROM productcustomimages WHERE product_id = '787'
203 0.0002 0.00022697448730469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
204 0.0004 0.00038409233093262
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0005 0.00047087669372559
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0004 0.00035691261291504
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0006 0.00060892105102539
SELECT * FROM products WHERE id = '1287'
208 0.0003 0.00033879280090332
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
209 0.0004 0.00035595893859863
SELECT * FROM product_image_select WHERE product_id = '1287'
210 0.0004 0.00041604042053223
SELECT * FROM productcustomimages WHERE product_id = '1287'
211 0.0004 0.00044608116149902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
212 0.0005 0.00050616264343262
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0005 0.00049018859863281
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0004 0.00037980079650879
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0006 0.0005950927734375
SELECT * FROM products WHERE id = '779'
216 0.0003 0.00029492378234863
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
217 0.0002 0.00023889541625977
SELECT * FROM product_image_select WHERE product_id = '779'
218 0.0003 0.00025701522827148
SELECT * FROM productcustomimages WHERE product_id = '779'
219 0.0004 0.00038504600524902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
220 0.0004 0.00036191940307617
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0003 0.00029087066650391
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0003 0.00031208992004395
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0006 0.00057005882263184
SELECT * FROM products WHERE id = '777'
224 0.0003 0.00029993057250977
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
225 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '777'
226 0.0002 0.00023007392883301
SELECT * FROM productcustomimages WHERE product_id = '777'
227 0.0002 0.00023818016052246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
228 0.0003 0.00029397010803223
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0002 0.00024700164794922
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0003 0.00025200843811035
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0004 0.00039815902709961
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
232 0.0004 0.00041294097900391
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
233 0.0006 0.0006251335144043
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
234 0.0004 0.00038695335388184
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
235 0.0003 0.00032711029052734
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
236 0.0006 0.00059413909912109
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
237 0.0005 0.00048398971557617
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
238 0.0006 0.00056791305541992
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'