Thé Rooibos Fraise : Strawberry Cream Pochette 100G - Tealodge

Thé Rooibos Fraise : Strawberry Cream Pochette 100G - Tealodge
Thé Rooibos Fraise : Strawberry Cream Pochette 100G - Tealodge Thé Rooibos Fraise : Strawberry Cream Pochette 100G - Tealodge Thé Rooibos Fraise : Strawberry Cream Pochette 100G - Tealodge (cliquez sur les images pour élargir)
€8,00
Le prix et la disponibilité du produit sont corrects en date du 2021-07-20 04:40:47 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

Thé Rooibos Goût Fraise Thé en vrac en sachet
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
6.0501499176025 249 0.1608 0


No Amazon API Requests Made.

Total time 6.0501499176025 seconds

Number Time From Start Name Description
1 2.8410680294037 Initialise Initialise FSB Function
2 2.8438680171967 App Controller Start Start of the App controller (called before the controller of every page)
3 2.8472709655762 Start of getCategoryListByGroup Function Before first category groups query
4 2.8477649688721 After initial query Before first category groups query
5 2.8477668762207 Get Category List for Group Before the call to getCategoryList function
6 2.8477709293365 Start of GetCategoryList function Start of the function
7 2.8477749824524 Before getting categories Query to get specific category list
8 2.8482360839844 After getting categories Query to get specific category list
9 2.848237991333 Before getting category custom Before call to function getCategoryCustom
10 2.8504769802094 After getting category custom After call to function getCategoryCustom
11 2.8504800796509 Before getting category custom Before call to function getCategoryCustom
12 2.8697240352631 After getting category custom After call to function getCategoryCustom
13 2.869726896286 Before getting category custom Before call to function getCategoryCustom
14 2.8755240440369 After getting category custom After call to function getCategoryCustom
15 2.8755269050598 Before getting category custom Before call to function getCategoryCustom
16 2.8786640167236 After getting category custom After call to function getCategoryCustom
17 2.8786659240723 Before getting category custom Before call to function getCategoryCustom
18 2.8827829360962 After getting category custom After call to function getCategoryCustom
19 2.8827860355377 Before getting category custom Before call to function getCategoryCustom
20 2.8870949745178 After getting category custom After call to function getCategoryCustom
21 2.8870980739594 End of GetCategoryList function End of the function
22 2.8871030807495 End of getCategoryListByGroup Function Before return()
23 3.1397399902344 App Controller End End of the App controller (called before the controller of every page)
24 3.1403660774231 Product Start Start of the product info controller
25 3.1795060634613 Cache file not found Starting get product details
26 3.2233579158783 Related products Start getting related products if enabled
27 3.2233588695526 Related Products Start Before the related products are found
28 3.2233610153198 Related Products Keywords Before the related product keywords are found
29 3.22336602211 Create Keyword List Function Start of function
30 3.2234590053558 Create Keyword List Function After looping provided content - 21 keywords found
31 3.2243919372559 Create Keyword List Function After looping initial keyword list - 21 keywords remaining
32 3.2244009971619 Create Keyword List Function After reducing keyword list
33 3.224457025528 Create Keyword List Function After selecting by scoring keywords
34 3.2244620323181 Create Keyword List Function After final loop of keywords
35 3.2244639396667 Related Products Keywords After the related product keywords are found
36 3.2443959712982 Related Products End After the related products are found
37 3.2545299530029 Product End End of the product info controller (Product Info)
38 3.25546002388 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 3.2561099529266 Before Get Options Before the call to getOptions in the tpl class
40 3.414911031723 After Get Options After the call to getOptions in the tpl class
41 3.4151408672333 App_after Controller End End of the App_after controller (called after the controller of every page)
42 3.4151880741119 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 4.7977569103241 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 4.7977640628815 Product Info: Before Template Display Before the template is displayed
45 6.0500829219818 Product Info: After Template Display After the template is displayed
46 6.0501239299774 Finalizing debug Before the debug is output to the page.
47 6.0501489639282 End of App This is the end of the app logging, final timestamp


Query Debug - 249 Database Queries. Total time 0.1608 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00074195861816406
SELECT parameter, value FROM parameters
2 0.0011 0.0011019706726074
SELECT * FROM `bad_bots`
3 0.0006 0.00056099891662598
SET time_zone = 'Europe/London'
4 0.0004 0.00042915344238281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0018 0.0017769336700439
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.205.192.201\";}'
6 0.0010 0.00098299980163574
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1628128102'
7 0.0006 0.00057220458984375
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00039315223693848
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0010 0.00098013877868652
SELECT id FROM pages WHERE pagename = 'the-rooibos-fraise-strawberry-cream-pochette-100g-tealodge' LIMIT 1
10 0.0007 0.0006711483001709
SELECT id FROM products WHERE pagename = 'the-rooibos-fraise-strawberry-cream-pochette-100g-tealodge' AND hidden = 0 LIMIT 1
11 0.0014 0.001384973526001
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00088310241699219
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00058603286743164
SELECT * FROM pages WHERE pagename = 'the-rooibos-fraise-strawberry-cream-pochette-100g-tealodge'
14 0.0005 0.00047707557678223
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00043988227844238
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0002 0.00024509429931641
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0002 0.00022411346435547
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.0002 0.00024008750915527
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00022292137145996
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.00022387504577637
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.00025701522827148
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0003 0.00025796890258789
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.0002 0.00022411346435547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00021815299987793
SELECT * FROM categorygroups WHERE id = '1'
25 0.0083 0.0082950592041016
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0004 0.0003969669342041
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.0004 0.00039196014404297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00039291381835938
SELECT id FROM categories WHERE parent_id = '27'
29 0.0087 0.0086729526519775
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.00033998489379883
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.0002 0.00021481513977051
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0002 0.00021600723266602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00020003318786621
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0017209053039551
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.0003 0.00033307075500488
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.0004 0.00039291381835938
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.0003969669342041
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.001655101776123
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0004 0.00039410591125488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0003 0.00031900405883789
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.00023698806762695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00021910667419434
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00061583518981934
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.0002 0.00023317337036133
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.0002 0.00022077560424805
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00024890899658203
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.000640869140625
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0003 0.00027203559875488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0002 0.00019598007202148
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.0004 0.0003819465637207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00022006034851074
SELECT * FROM categorygroups WHERE id = '1'
52 0.0009 0.00093197822570801
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0004 0.00039005279541016
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.0004 0.00041604042053223
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00033116340637207
SELECT id FROM categories WHERE parent_id = '30'
56 0.0009 0.00093984603881836
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.0003 0.00029397010803223
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.00023984909057617
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.00022196769714355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00023293495178223
SELECT * FROM categorygroups WHERE id = '1'
61 0.0009 0.00094294548034668
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.00024580955505371
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.00024795532226562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.0002281665802002
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00080299377441406
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0004 0.00039505958557129
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.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 (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0007 0.00065398216247559
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00025296211242676
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00043606758117676
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00027704238891602
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0005 0.00046515464782715
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.0003 0.00028395652770996
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0009 0.00092291831970215
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0007 0.00068402290344238
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0004 0.00035715103149414
SELECT * FROM ipgeocountries WHERE INET_ATON('18.205.192.201') >= INET_ATON(ip_start) AND INET_ATON('18.205.192.201') <= INET_ATON(ip_end)
77 0.0003 0.00026798248291016
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00032210350036621
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0009 0.00085687637329102
SELECT * FROM products WHERE pagename = 'the-rooibos-fraise-strawberry-cream-pochette-100g-tealodge'
80 0.0011 0.001054048538208
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1082
81 0.0005 0.00046300888061523
SELECT * FROM manufacturers WHERE id = '252'
82 0.0012 0.0011909008026123
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '252'
83 0.0003 0.00025177001953125
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '252' LIMIT 1
84 0.0015 0.0014638900756836
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '252' ORDER BY RAND() LIMIT 1
85 0.0022 0.0022070407867432
SELECT * FROM productimages WHERE product_id = '1211' ORDER BY sortorder ASC
86 0.0002 0.00024104118347168
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '252'
87 0.0008 0.00081896781921387
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '252'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0002 0.00023818016052246
SELECT * FROM manufacturerimages WHERE manufacturer_id = '252'
89 0.0006 0.00057601928710938
SELECT category_id FROM products_categories WHERE product_id = '1082'
90 0.0003 0.0002899169921875
SELECT * FROM categories WHERE id = '27'
91 0.0069 0.0069289207458496
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.0002 0.00021600723266602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '27'
94 0.0047 0.0046899318695068
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.0002 0.00022292137145996
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.0002 0.00022792816162109
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.0002 0.00020909309387207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0019 0.0019211769104004
SELECT * FROM productimages WHERE product_id = '1082' ORDER BY sortorder ASC
99 0.0005 0.00053596496582031
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1082' AND p.id = pi.product_id ORDER BY pi.sortorder
100 0.0006 0.0005640983581543
SELECT * FROM product_image_select WHERE product_id = '1082'
101 0.0005 0.00045204162597656
SELECT * FROM productcustomimages WHERE product_id = '1082'
102 0.0005 0.00045108795166016
SELECT * FROM productfeeds WHERE product_id = '1082' ORDER BY item_date DESC
103 0.0018 0.0017859935760498
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1082' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0012 0.001154899597168
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1082' AND t.hidden = 0 AND display_product = 1
105 0.0002 0.00021791458129883
SELECT * FROM tags WHERE id = '1'
106 0.0018 0.0018191337585449
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0017 0.0016801357269287
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0019 0.001924991607666
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' 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.0004 0.00042390823364258
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
110 0.0007 0.00068402290344238
SELECT * FROM productamazoncontent WHERE product_id = '1082'
111 0.0008 0.00083088874816895
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 = '1082'
                GROUP BY o.product_id
112 0.0011 0.0010628700256348
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     = '1082'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
113 0.0006 0.00059700012207031
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1082
114 0.0023 0.0022881031036377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1082' AND a.name = n.originalname
115 0.0007 0.00071287155151367
SELECT * FROM productoffers WHERE product_id = '1082' AND merchantid = 'A1X6FK5RDHNB96'
116 0.0006 0.00055408477783203
SELECT * FROM productoffers
                WHERE product_id = '1082' AND price > 0
                ORDER BY price ASC LIMIT 1
117 0.0006 0.00056195259094238
SELECT * FROM productoffers
                WHERE product_id = 1082
                ORDER BY price ASC LIMIT 1
118 0.0006 0.00057101249694824
SELECT value FROM productattributes
                WHERE product_id = '1082'
                AND name = 'ListPriceAmount'
119 0.0005 0.00045394897460938
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 = '1082'
                GROUP BY o.product_id
120 0.0003 0.00028181076049805
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     = '1082'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
121 0.0002 0.00023198127746582
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1082
122 0.0005 0.0004580020904541
SELECT * FROM products WHERE parent_id = '1082'
123 0.0002 0.00022387504577637
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
124 0.0080 0.0079729557037354
SELECT *, MATCH (description, title) AGAINST ('pochette 100g tealodge' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('pochette 100g tealodge' IN BOOLEAN MODE) AND 1082 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
125 0.0008 0.00075101852416992
SELECT *, MATCH (description, title) AGAINST ('pochette 100g tealodge' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('pochette 100g tealodge' IN BOOLEAN MODE) AND 1082 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
126 0.0007 0.00072288513183594
SELECT *, MATCH (description, title) AGAINST ('pochette 100g tealodge' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('pochette 100g tealodge' IN BOOLEAN MODE) AND 1082 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
127 0.0003 0.00030994415283203
SELECT * FROM productimages WHERE product_id = '1007' ORDER BY sortorder ASC
128 0.0003 0.00031495094299316
SELECT * FROM product_image_select WHERE product_id = '1007'
129 0.0007 0.00072622299194336
SELECT * FROM productcustomimages WHERE product_id = '1007'
130 0.0005 0.00045084953308105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1007' AND a.name = n.originalname
131 0.0005 0.00047993659973145
SELECT * FROM productoffers WHERE product_id = '1007' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0006 0.00064301490783691
SELECT * FROM productoffers
                WHERE product_id = '1007' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0002 0.00024294853210449
SELECT value FROM productattributes WHERE product_id = '1007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0004 0.0004429817199707
SELECT * FROM productimages WHERE product_id = '929' ORDER BY sortorder ASC
135 0.0003 0.00032687187194824
SELECT * FROM product_image_select WHERE product_id = '929'
136 0.0006 0.00055909156799316
SELECT * FROM productcustomimages WHERE product_id = '929'
137 0.0003 0.00028109550476074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '929' AND a.name = n.originalname
138 0.0006 0.00057005882263184
SELECT * FROM productoffers WHERE product_id = '929' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0006 0.00058197975158691
SELECT * FROM productoffers
                WHERE product_id = '929' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0003 0.00030303001403809
SELECT value FROM productattributes WHERE product_id = '929' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0004 0.00042104721069336
SELECT * FROM productimages WHERE product_id = '957' ORDER BY sortorder ASC
142 0.0004 0.00043201446533203
SELECT * FROM product_image_select WHERE product_id = '957'
143 0.0004 0.00039410591125488
SELECT * FROM productcustomimages WHERE product_id = '957'
144 0.0005 0.00051093101501465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '957' AND a.name = n.originalname
145 0.0006 0.00055289268493652
SELECT * FROM productoffers WHERE product_id = '957' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0008 0.00083303451538086
SELECT * FROM productoffers
                WHERE product_id = '957' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0003 0.00031805038452148
SELECT value FROM productattributes WHERE product_id = '957' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0004 0.00037693977355957
SELECT id,asin FROM products WHERE parent_id = 1082
149 0.0003 0.00026798248291016
SELECT category_id FROM products_categories WHERE product_id = '1082'
150 0.0005 0.00049185752868652
SELECT * FROM categories WHERE id = '27'
151 0.0003 0.0002739429473877
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
152 0.0003 0.00034189224243164
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
153 0.0004 0.00043201446533203
SELECT id FROM categories WHERE parent_id = '27'
154 0.0004 0.00042295455932617
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 
155 0.0004 0.00036120414733887
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 
156 0.0003 0.00027203559875488
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
157 0.0002 0.00019192695617676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
158 0.0002 0.00019097328186035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1082' AND a.name = n.originalname
159 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '1082' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0002 0.00022792816162109
SELECT * FROM productoffers
                WHERE product_id = '1082' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0003 0.00026416778564453
SELECT * FROM productoffers
                WHERE product_id = 1082
                ORDER BY price ASC LIMIT 1
162 0.0002 0.00017809867858887
SELECT value FROM productattributes
                WHERE product_id = '1082'
                AND name = 'ListPriceAmount'
163 0.0006 0.00055217742919922
SELECT * FROM products WHERE id = '1082'
164 0.0003 0.00025486946105957
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 = '1082'
                GROUP BY o.product_id
165 0.0002 0.00023698806762695
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     = '1082'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
166 0.0002 0.00019097328186035
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1082
167 0.0003 0.0003049373626709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1082' AND a.name = n.originalname
168 0.0004 0.00039291381835938
SELECT * FROM productoffers WHERE product_id = '1082' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0004 0.00036787986755371
SELECT * FROM productoffers
                WHERE product_id = '1082' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0003 0.00031805038452148
SELECT * FROM productoffers
                WHERE product_id = 1082
                ORDER BY price ASC LIMIT 1
171 0.0003 0.00032210350036621
SELECT value FROM productattributes
                WHERE product_id = '1082'
                AND name = 'ListPriceAmount'
172 0.0004 0.00043892860412598
SELECT category_id FROM products_categories WHERE product_id = '1082' AND prod_type = 'amz'
173 0.0002 0.00022482872009277
SELECT parent_id FROM categories WHERE id = '27'
174 0.0002 0.00022697448730469
SELECT * FROM categories WHERE id = '27'
175 0.0002 0.00017905235290527
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
176 0.0002 0.00022482872009277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
177 0.0002 0.00019216537475586
SELECT id FROM categories WHERE parent_id = '27'
178 0.0002 0.00021195411682129
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 
179 0.0002 0.00019097328186035
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
180 0.0002 0.00018310546875
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
181 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
182 0.0003 0.00030803680419922
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
183 0.0003 0.0002589225769043
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
184 0.0003 0.00030803680419922
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
185 0.0004 0.00039100646972656
SELECT * FROM pages WHERE id = 38
186 0.0047 0.0047447681427002
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
187 0.0007 0.00070905685424805
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:1628128103;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:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
188 0.0005 0.00054812431335449
SELECT * FROM products WHERE id = 790
189 0.0006 0.00063705444335938
SELECT * FROM products WHERE id = 788
190 0.0006 0.00063180923461914
SELECT * FROM products WHERE id = 787
191 0.0006 0.00059080123901367
SELECT * FROM products WHERE id = 1287
192 0.0007 0.00065088272094727
SELECT * FROM products WHERE id = 777
193 0.0007 0.0006859302520752
SELECT * FROM products WHERE id = 776
194 0.0005 0.00047993659973145
SELECT * FROM products WHERE id = '790'
195 0.0004 0.00044822692871094
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
196 0.0004 0.00039291381835938
SELECT * FROM product_image_select WHERE product_id = '790'
197 0.0004 0.00037193298339844
SELECT * FROM productcustomimages WHERE product_id = '790'
198 0.0004 0.00037693977355957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
199 0.0003 0.00034499168395996
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0004 0.00037479400634766
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0003 0.00028705596923828
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0006 0.00061202049255371
SELECT * FROM products WHERE id = '788'
203 0.0003 0.00030398368835449
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
204 0.0003 0.00032901763916016
SELECT * FROM product_image_select WHERE product_id = '788'
205 0.0004 0.00036191940307617
SELECT * FROM productcustomimages WHERE product_id = '788'
206 0.0004 0.0004119873046875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
207 0.0003 0.00033307075500488
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0003 0.00030708312988281
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0002 0.00021505355834961
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0004 0.00044894218444824
SELECT * FROM products WHERE id = '787'
211 0.0004 0.00036287307739258
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
212 0.0004 0.00038003921508789
SELECT * FROM product_image_select WHERE product_id = '787'
213 0.0004 0.00037384033203125
SELECT * FROM productcustomimages WHERE product_id = '787'
214 0.0004 0.00043988227844238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
215 0.0004 0.00038886070251465
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0005 0.00054502487182617
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0007 0.00068902969360352
SELECT * FROM products WHERE id = '1287'
219 0.0005 0.00047492980957031
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
220 0.0004 0.00039815902709961
SELECT * FROM product_image_select WHERE product_id = '1287'
221 0.0004 0.00039100646972656
SELECT * FROM productcustomimages WHERE product_id = '1287'
222 0.0004 0.00044417381286621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
223 0.0004 0.0004119873046875
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0004 0.00042390823364258
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0003 0.0002899169921875
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0006 0.00061702728271484
SELECT * FROM products WHERE id = '777'
227 0.0002 0.00020718574523926
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
228 0.0002 0.00024104118347168
SELECT * FROM product_image_select WHERE product_id = '777'
229 0.0003 0.00033998489379883
SELECT * FROM productcustomimages WHERE product_id = '777'
230 0.0005 0.00046300888061523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
231 0.0004 0.00035786628723145
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0003 0.00032496452331543
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0003 0.00028610229492188
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0006 0.00059413909912109
SELECT * FROM products WHERE id = '776'
235 0.0004 0.0003819465637207
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
236 0.0003 0.00027203559875488
SELECT * FROM product_image_select WHERE product_id = '776'
237 0.0003 0.0003349781036377
SELECT * FROM productcustomimages WHERE product_id = '776'
238 0.0003 0.00025606155395508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
239 0.0002 0.00022101402282715
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0002 0.00023984909057617
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0005 0.00047683715820312
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
243 0.0005 0.00052213668823242
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
244 0.0009 0.0009150505065918
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
245 0.0006 0.00057315826416016
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
246 0.0006 0.0005648136138916
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
247 0.0004 0.00044512748718262
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
248 0.0004 0.00044703483581543
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
249 0.0005 0.00046896934509277
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'