Rooibos Tea Robert Roberts

Rooibos Tea Robert Roberts
Rooibos Tea Robert Roberts (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-07-21 10:26:17 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.

Caractéristiques du Produit

Rooibos Tea Robert Roberts

Produits Connexes

CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.2153780460358 254 0.1172 0


No Amazon API Requests Made.

Total time 1.2153780460358 seconds

Number Time From Start Name Description
1 0.38662195205688 Initialise Initialise FSB Function
2 0.38876485824585 App Controller Start Start of the App controller (called before the controller of every page)
3 0.39198398590088 Start of getCategoryListByGroup Function Before first category groups query
4 0.39225697517395 After initial query Before first category groups query
5 0.39225888252258 Get Category List for Group Before the call to getCategoryList function
6 0.39226102828979 Start of GetCategoryList function Start of the function
7 0.39226388931274 Before getting categories Query to get specific category list
8 0.39259505271912 After getting categories Query to get specific category list
9 0.39259600639343 Before getting category custom Before call to function getCategoryCustom
10 0.4105658531189 After getting category custom After call to function getCategoryCustom
11 0.41056990623474 Before getting category custom Before call to function getCategoryCustom
12 0.42100191116333 After getting category custom After call to function getCategoryCustom
13 0.42100596427917 Before getting category custom Before call to function getCategoryCustom
14 0.42650389671326 After getting category custom After call to function getCategoryCustom
15 0.4265079498291 Before getting category custom Before call to function getCategoryCustom
16 0.42917084693909 After getting category custom After call to function getCategoryCustom
17 0.4291729927063 Before getting category custom Before call to function getCategoryCustom
18 0.43216586112976 After getting category custom After call to function getCategoryCustom
19 0.43216800689697 Before getting category custom Before call to function getCategoryCustom
20 0.43498682975769 After getting category custom After call to function getCategoryCustom
21 0.4349889755249 End of GetCategoryList function End of the function
22 0.4349958896637 End of getCategoryListByGroup Function Before return()
23 0.44646883010864 App Controller End End of the App controller (called before the controller of every page)
24 0.44710898399353 Product Start Start of the product info controller
25 0.44823598861694 Cache file not found Starting get product details
26 0.46401000022888 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
27 1.1276118755341 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
28 1.1299748420715 Related products Start getting related products if enabled
29 1.1299779415131 Related Products Start Before the related products are found
30 1.1299788951874 Related Products Keywords Before the related product keywords are found
31 1.1299870014191 Create Keyword List Function Start of function
32 1.1300208568573 Create Keyword List Function After looping provided content - 9 keywords found
33 1.1305668354034 Create Keyword List Function After looping initial keyword list - 8 keywords remaining
34 1.1305758953094 Create Keyword List Function After reducing keyword list
35 1.1305930614471 Create Keyword List Function After selecting by scoring keywords
36 1.1305990219116 Create Keyword List Function After final loop of keywords
37 1.1306009292603 Related Products Keywords After the related product keywords are found
38 1.1474359035492 Related Products End After the related products are found
39 1.1561119556427 Product End End of the product info controller (Product Info)
40 1.156702041626 App_after Controller Start Start of the App_after controller (called after the controller of every page)
41 1.1572530269623 Before Get Options Before the call to getOptions in the tpl class
42 1.1777138710022 After Get Options After the call to getOptions in the tpl class
43 1.1778109073639 App_after Controller End End of the App_after controller (called after the controller of every page)
44 1.1778399944305 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
45 1.1920199394226 Product Info: After Smarty Fetch After the product.tpl template is fetched
46 1.1920380592346 Product Info: Before Template Display Before the template is displayed
47 1.2153499126434 Product Info: After Template Display After the template is displayed
48 1.2153630256653 Finalizing debug Before the debug is output to the page.
49 1.2153759002686 End of App This is the end of the app logging, final timestamp


Query Debug - 254 Database Queries. Total time 0.1172 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00051784515380859
SELECT parameter, value FROM parameters
2 0.0010 0.0009920597076416
SELECT * FROM `bad_bots`
3 0.0003 0.00032591819763184
SET time_zone = 'Europe/London'
4 0.0003 0.00032401084899902
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0021 0.0021162033081055
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.207.238.146\";}'
6 0.0010 0.001007080078125
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627259568'
7 0.0005 0.00047612190246582
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.0008549690246582
UPDATE autorun SET lastrun = '2021-07-26 00:32:48' WHERE id = '8'
9 0.0003 0.00030517578125
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0006 0.00057291984558105
SELECT id FROM pages WHERE pagename = 'rooibos-tea-robert-roberts' LIMIT 1
11 0.0008 0.00079011917114258
SELECT id FROM products WHERE pagename = 'rooibos-tea-robert-roberts' AND hidden = 0 LIMIT 1
12 0.0014 0.0014410018920898
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
13 0.0009 0.00085711479187012
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
14 0.0005 0.00052905082702637
SELECT * FROM pages WHERE pagename = 'rooibos-tea-robert-roberts'
15 0.0003 0.00026202201843262
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0003 0.00031185150146484
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0094 0.0094399452209473
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.00024199485778809
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.0002 0.00023508071899414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '26'
21 0.0067 0.00673508644104
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.0003 0.00026702880859375
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.0003 0.00027894973754883
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.00020003318786621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0002 0.0002129077911377
SELECT * FROM categorygroups WHERE id = '1'
26 0.0044 0.0043840408325195
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.0003 0.00028109550476074
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.00019097328186035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0002 0.00019216537475586
SELECT id FROM categories WHERE parent_id = '27'
30 0.0044 0.0044159889221191
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.0002 0.00020503997802734
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.00022006034851074
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.0001978874206543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0002 0.00018095970153809
SELECT * FROM categorygroups WHERE id = '1'
35 0.0020 0.0019969940185547
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.00021600723266602
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.00021696090698242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0002 0.00021886825561523
SELECT id FROM categories WHERE parent_id = '28'
39 0.0019 0.001917839050293
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.00023388862609863
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.00020694732666016
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.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0002 0.00018000602722168
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00056004524230957
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.00018095970153809
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.00018000602722168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0002 0.00016617774963379
SELECT id FROM categories WHERE parent_id = '29'
48 0.0008 0.00075817108154297
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.00019097328186035
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.00018596649169922
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.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0002 0.00018405914306641
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00051498413085938
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.00018620491027832
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.00022196769714355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0002 0.0001678466796875
SELECT id FROM categories WHERE parent_id = '30'
57 0.0010 0.0010290145874023
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.0001988410949707
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.00020599365234375
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.00017714500427246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0002 0.00020599365234375
SELECT * FROM categorygroups WHERE id = '1'
62 0.0008 0.00075101852416992
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.00018906593322754
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.00016593933105469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0002 0.00017714500427246
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00061583518981934
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.00018811225891113
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.00018477439880371
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.00026416778564453
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0002 0.00019001960754395
SELECT * FROM categorygroups WHERE id = '1'
71 0.0002 0.00021910667419434
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0004 0.00039792060852051
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0002 0.00021195411682129
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
74 0.0002 0.00018095970153809
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0002 0.00017499923706055
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
76 0.0002 0.00016689300537109
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
77 0.0002 0.00017595291137695
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
78 0.0005 0.00049996376037598
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
79 0.0002 0.00020599365234375
SELECT * FROM ipgeocountries WHERE INET_ATON('18.207.238.146') >= INET_ATON(ip_start) AND INET_ATON('18.207.238.146') <= INET_ATON(ip_end)
80 0.0002 0.0001988410949707
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
81 0.0002 0.00018501281738281
SELECT * FROM countryredirects WHERE countrycode = 'US'
82 0.0005 0.00049185752868652
SELECT * FROM products WHERE pagename = 'rooibos-tea-robert-roberts'
83 0.0005 0.00054693222045898
SELECT * FROM manufacturers WHERE id = '639'
84 0.0008 0.00078201293945312
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
85 0.0004 0.00038385391235352
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
86 0.0015 0.0015039443969727
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
87 0.0002 0.00021481513977051
SELECT * FROM productimages WHERE product_id = '4059' ORDER BY sortorder ASC
88 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
89 0.0008 0.00079703330993652
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '639'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0004 0.00039196014404297
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
91 0.0004 0.00038385391235352
SELECT category_id FROM products_categories WHERE product_id = '3805'
92 0.0002 0.00022697448730469
SELECT * FROM categories WHERE id = '27'
93 0.0002 0.00019001960754395
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
94 0.0002 0.00018215179443359
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0002 0.00016903877258301
SELECT id FROM categories WHERE parent_id = '27'
96 0.0002 0.00019192695617676
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 
97 0.0002 0.00019478797912598
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 
98 0.0002 0.00016999244689941
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
99 0.0002 0.00019407272338867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0002 0.00018405914306641
SELECT * FROM productimages WHERE product_id = '3805' ORDER BY sortorder ASC
101 0.0004 0.00037193298339844
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3805' AND p.id = pi.product_id ORDER BY pi.sortorder
102 0.0002 0.00020384788513184
SELECT * FROM product_image_select WHERE product_id = '3805'
103 0.0002 0.00019693374633789
SELECT * FROM productcustomimages WHERE product_id = '3805'
104 0.0004 0.00042319297790527
SELECT * FROM productfeeds WHERE product_id = '3805' ORDER BY item_date DESC
105 0.0005 0.00052380561828613
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3805' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
106 0.0013 0.0012509822845459
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3805' AND t.hidden = 0 AND display_product = 1
107 0.0006 0.00064516067504883
SELECT * FROM productamazoncontent WHERE product_id = '3805'
108 0.0004 0.00040292739868164
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3805'
                GROUP BY o.product_id
109 0.0005 0.00045990943908691
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3805'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
110 0.0005 0.00052595138549805
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3805
111 0.0002 0.00021100044250488
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3805' AND a.name = n.originalname
112 0.0002 0.00024199485778809
SELECT * FROM productoffers WHERE product_id = '3805' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0002 0.00018882751464844
SELECT * FROM productoffers
                WHERE product_id = '3805' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = 3805
                ORDER BY price ASC LIMIT 1
115 0.0002 0.00021910667419434
SELECT value FROM productattributes
                WHERE product_id = '3805'
                AND name = 'ListPriceAmount'
116 0.0002 0.0002138614654541
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3805'
                GROUP BY o.product_id
117 0.0002 0.00018787384033203
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3805'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
118 0.0002 0.00019192695617676
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3805
119 0.0002 0.00017404556274414
SELECT value FROM productattributes WHERE product_id = '3805' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0004 0.00038599967956543
SELECT * FROM products WHERE parent_id = '3805'
121 0.0002 0.0001990795135498
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
122 0.0002 0.00017285346984863
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
123 0.0002 0.00017786026000977
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
124 0.0002 0.00017786026000977
SELECT * FROM ebay_products_cache WHERE cachekey = '4ee8d429538b2b5d4286b7d39916c82c' 
125 0.0002 0.00023293495178223
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
126 0.0003 0.00034213066101074
SELECT * FROM ebay_products_cache WHERE cachekey = '4ee8d429538b2b5d4286b7d39916c82c' 
127 0.0017 0.0017130374908447
INSERT INTO externalrequestlog (`type`, `wherefrom`, `url`, `parameters`, `successful`, `timetaken`, `appinstance`, `apprequesturi`, `created`) SELECT 'ebay', 'function searchProducts()', 'https://svcs.ebay.com/services/search/FindingService/v1?OPERATION-NAME=findItemsByKeywords&SERVICE-VERSION=1.0.0&GLOBAL-ID=EBAY-US&SECURITY-APPNAME=&RESPONSE-DATA-FORMAT=XML&REST-PAYLOAD&keywords=s&paginationInput.pageNumber=1&paginationInput.entriesPerPage=1&itemFilter(0).name=HideDuplicateItems&itemFilter(0).value=true&affiliate.trackingId=&affiliate.networkId=9', 'a:10:{s:9:\"ebayappid\";s:0:\"\";s:9:\"authtoken\";s:0:\"\";s:13:\"ebaynetworkid\";s:1:\"9\";s:14:\"ebaytrackingid\";s:0:\"\";s:19:\"googlerecaptchatype\";s:1:\"0\";s:15:\"googlesecretkey\";s:0:\"\";s:13:\"googlesitekey\";s:0:\"\";s:12:\"ebayglobalid\";s:7:\"EBAY-US\";s:10:\"ebaysiteid\";s:1:\"0\";s:8:\"currency\";s:3:\"USD\";}', '0', '0.66361403465271', 'fb5af242ef0ce23a00c8e51215a60950', 'http://www.boite-a-the.fr/rooibos-tea-robert-roberts/', '2021-07-26 00:32:49'
128 0.0098 0.0097870826721191
SELECT *, MATCH (description, title) AGAINST ('rooibos tea robert' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos tea robert' IN BOOLEAN MODE) AND 3805 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
129 0.0006 0.00057792663574219
SELECT *, MATCH (description, title) AGAINST ('rooibos tea robert' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos tea robert' IN BOOLEAN MODE) AND 3805 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
130 0.0005 0.00048208236694336
SELECT *, MATCH (description, title) AGAINST ('rooibos tea robert' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos tea robert' IN BOOLEAN MODE) AND 3805 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
131 0.0003 0.0002901554107666
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
132 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '1011'
133 0.0002 0.00023818016052246
SELECT * FROM productcustomimages WHERE product_id = '1011'
134 0.0002 0.00024604797363281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
135 0.0003 0.00026416778564453
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0003 0.00030207633972168
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0002 0.00019979476928711
SELECT value FROM productattributes WHERE product_id = '1011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0003 0.00025081634521484
SELECT * FROM productimages WHERE product_id = '1017' ORDER BY sortorder ASC
139 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '1017'
140 0.0002 0.00023102760314941
SELECT * FROM productcustomimages WHERE product_id = '1017'
141 0.0002 0.00020694732666016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1017' AND a.name = n.originalname
142 0.0002 0.00021791458129883
SELECT * FROM productoffers WHERE product_id = '1017' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0002 0.00024008750915527
SELECT * FROM productoffers
                WHERE product_id = '1017' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0002 0.00020313262939453
SELECT value FROM productattributes WHERE product_id = '1017' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0003 0.0002739429473877
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
146 0.0003 0.0002892017364502
SELECT * FROM product_image_select WHERE product_id = '1010'
147 0.0002 0.00021195411682129
SELECT * FROM productcustomimages WHERE product_id = '1010'
148 0.0002 0.000244140625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1010' AND a.name = n.originalname
149 0.0002 0.00023198127746582
SELECT * FROM productoffers WHERE product_id = '1010' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '1010' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0002 0.00019693374633789
SELECT value FROM productattributes WHERE product_id = '1010' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0003 0.00034618377685547
SELECT id,asin FROM products WHERE parent_id = 3805
153 0.0002 0.00020503997802734
SELECT category_id FROM products_categories WHERE product_id = '3805'
154 0.0002 0.00024294853210449
SELECT * FROM categories WHERE id = '27'
155 0.0002 0.00020790100097656
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
156 0.0002 0.00019407272338867
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
157 0.0002 0.00018787384033203
SELECT id FROM categories WHERE parent_id = '27'
158 0.0002 0.00020694732666016
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
159 0.0002 0.0001981258392334
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
160 0.0002 0.00018787384033203
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
161 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
162 0.0002 0.00020098686218262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3805' AND a.name = n.originalname
163 0.0002 0.0002140998840332
SELECT * FROM productoffers WHERE product_id = '3805' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '3805' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = 3805
                ORDER BY price ASC LIMIT 1
166 0.0002 0.0002140998840332
SELECT value FROM productattributes
                WHERE product_id = '3805'
                AND name = 'ListPriceAmount'
167 0.0005 0.00051403045654297
SELECT * FROM products WHERE id = '3805'
168 0.0003 0.00029301643371582
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3805'
                GROUP BY o.product_id
169 0.0002 0.00021505355834961
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3805'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
170 0.0002 0.00024104118347168
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3805
171 0.0002 0.00022721290588379
SELECT value FROM productattributes WHERE product_id = '3805' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0002 0.00022220611572266
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3805' AND a.name = n.originalname
173 0.0002 0.00022792816162109
SELECT * FROM productoffers WHERE product_id = '3805' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '3805' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = 3805
                ORDER BY price ASC LIMIT 1
176 0.0002 0.0002138614654541
SELECT value FROM productattributes
                WHERE product_id = '3805'
                AND name = 'ListPriceAmount'
177 0.0004 0.00036907196044922
SELECT category_id FROM products_categories WHERE product_id = '3805' AND prod_type = 'amz'
178 0.0002 0.00018906593322754
SELECT parent_id FROM categories WHERE id = '27'
179 0.0002 0.00024890899658203
SELECT * FROM categories WHERE id = '27'
180 0.0002 0.00022411346435547
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
181 0.0002 0.00022506713867188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
182 0.0002 0.00020885467529297
SELECT id FROM categories WHERE parent_id = '27'
183 0.0002 0.00018692016601562
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 
184 0.0002 0.00020599365234375
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 
185 0.0002 0.00023984909057617
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
186 0.0002 0.00020003318786621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
187 0.0003 0.00026702880859375
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
188 0.0002 0.0002129077911377
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
189 0.0002 0.00022315979003906
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
190 0.0003 0.00027108192443848
SELECT * FROM pages WHERE id = 38
191 0.0002 0.00023818016052246
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
192 0.0004 0.0004119873046875
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:1627259569;s:8:\"products\";a:6:{i:0;s:10:\"808|amazon\";i:1;s:11:\"4939|amazon\";i:2;s:10:\"873|amazon\";i:3;s:10:\"894|amazon\";i:4;s:10:\"881|amazon\";i:5;s:10:\"887|amazon\";}}' WHERE id = '160'
193 0.0003 0.0003211498260498
SELECT * FROM products WHERE id = 808
194 0.0004 0.00038504600524902
SELECT * FROM products WHERE id = 4939
195 0.0003 0.00028419494628906
SELECT * FROM products WHERE id = 873
196 0.0004 0.00042390823364258
SELECT * FROM products WHERE id = 894
197 0.0003 0.00028204917907715
SELECT * FROM products WHERE id = 881
198 0.0003 0.00032711029052734
SELECT * FROM products WHERE id = 887
199 0.0003 0.00029420852661133
SELECT * FROM products WHERE id = '808'
200 0.0003 0.00032901763916016
SELECT * FROM productimages WHERE product_id = '808' ORDER BY sortorder ASC
201 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '808'
202 0.0003 0.0002589225769043
SELECT * FROM productcustomimages WHERE product_id = '808'
203 0.0002 0.00022482872009277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '808' AND a.name = n.originalname
204 0.0003 0.00026297569274902
SELECT * FROM productoffers WHERE product_id = '808' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0002 0.000244140625
SELECT * FROM productoffers
                WHERE product_id = '808' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0002 0.00020599365234375
SELECT value FROM productattributes WHERE product_id = '808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0003 0.00029802322387695
SELECT * FROM products WHERE id = '4939'
208 0.0003 0.00028395652770996
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
209 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '4939'
210 0.0002 0.00024604797363281
SELECT * FROM productcustomimages WHERE product_id = '4939'
211 0.0003 0.0002598762512207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
212 0.0002 0.00023722648620605
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0002 0.00024294853210449
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0002 0.00020289421081543
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0003 0.00029802322387695
SELECT * FROM products WHERE id = '873'
216 0.0004 0.00037097930908203
SELECT * FROM productimages WHERE product_id = '873' ORDER BY sortorder ASC
217 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '873'
218 0.0002 0.00021004676818848
SELECT * FROM productcustomimages WHERE product_id = '873'
219 0.0003 0.00028896331787109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '873' AND a.name = n.originalname
220 0.0003 0.00027799606323242
SELECT * FROM productoffers WHERE product_id = '873' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = '873' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0002 0.00020480155944824
SELECT value FROM productattributes WHERE product_id = '873' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0003 0.00031399726867676
SELECT * FROM products WHERE id = '894'
224 0.0003 0.00028085708618164
SELECT * FROM productimages WHERE product_id = '894' ORDER BY sortorder ASC
225 0.0002 0.00023818016052246
SELECT * FROM product_image_select WHERE product_id = '894'
226 0.0002 0.00022101402282715
SELECT * FROM productcustomimages WHERE product_id = '894'
227 0.0002 0.00023317337036133
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '894' AND a.name = n.originalname
228 0.0002 0.00024294853210449
SELECT * FROM productoffers WHERE product_id = '894' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0002 0.00024700164794922
SELECT * FROM productoffers
                WHERE product_id = '894' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0002 0.00021004676818848
SELECT value FROM productattributes WHERE product_id = '894' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0003 0.00028586387634277
SELECT * FROM products WHERE id = '881'
232 0.0003 0.00028610229492188
SELECT * FROM productimages WHERE product_id = '881' ORDER BY sortorder ASC
233 0.0003 0.00027203559875488
SELECT * FROM product_image_select WHERE product_id = '881'
234 0.0002 0.0002281665802002
SELECT * FROM productcustomimages WHERE product_id = '881'
235 0.0002 0.00024700164794922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '881' AND a.name = n.originalname
236 0.0002 0.00024104118347168
SELECT * FROM productoffers WHERE product_id = '881' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0003 0.00025105476379395
SELECT * FROM productoffers
                WHERE product_id = '881' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0002 0.00020289421081543
SELECT value FROM productattributes WHERE product_id = '881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0003 0.00030088424682617
SELECT * FROM products WHERE id = '887'
240 0.0003 0.00028586387634277
SELECT * FROM productimages WHERE product_id = '887' ORDER BY sortorder ASC
241 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '887'
242 0.0002 0.0002131462097168
SELECT * FROM productcustomimages WHERE product_id = '887'
243 0.0002 0.00022697448730469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '887' AND a.name = n.originalname
244 0.0002 0.00023293495178223
SELECT * FROM productoffers WHERE product_id = '887' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0002 0.00023508071899414
SELECT * FROM productoffers
                WHERE product_id = '887' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0002 0.00022983551025391
SELECT value FROM productattributes WHERE product_id = '887' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0003 0.00027990341186523
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
248 0.0003 0.0002901554107666
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
249 0.0007 0.00073790550231934
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
250 0.0003 0.00031495094299316
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
251 0.0003 0.00030803680419922
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
252 0.0003 0.00033879280090332
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
253 0.0014 0.0013899803161621
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
254 0.0002 0.00024914741516113
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'