Thé Bio Bleu Vert Oolong

Thé Bio Bleu Vert Oolong
Thé Bio Bleu Vert Oolong Thé Bio Bleu Vert Oolong Thé Bio Bleu Vert Oolong (cliquez sur les images pour élargir)
€8,99
Le prix et la disponibilité du produit sont corrects en date du 2021-07-20 11:31:38 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

Boîte de thé bleu-vert Oolong biologique, originaire de la province d'Anhui en chine, en vrac.
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.2803211212158 252 0.1203 0


No Amazon API Requests Made.

Total time 1.2803211212158 seconds

Number Time From Start Name Description
1 0.44617414474487 Initialise Initialise FSB Function
2 0.44787406921387 App Controller Start Start of the App controller (called before the controller of every page)
3 0.45035815238953 Start of getCategoryListByGroup Function Before first category groups query
4 0.45064997673035 After initial query Before first category groups query
5 0.45065307617188 Get Category List for Group Before the call to getCategoryList function
6 0.45065593719482 Start of GetCategoryList function Start of the function
7 0.45065999031067 Before getting categories Query to get specific category list
8 0.45117115974426 After getting categories Query to get specific category list
9 0.45117211341858 Before getting category custom Before call to function getCategoryCustom
10 0.4663360118866 After getting category custom After call to function getCategoryCustom
11 0.46633911132812 Before getting category custom Before call to function getCategoryCustom
12 0.47676515579224 After getting category custom After call to function getCategoryCustom
13 0.47676801681519 Before getting category custom Before call to function getCategoryCustom
14 0.48133301734924 After getting category custom After call to function getCategoryCustom
15 0.48133516311646 Before getting category custom Before call to function getCategoryCustom
16 0.48382997512817 After getting category custom After call to function getCategoryCustom
17 0.48383212089539 Before getting category custom Before call to function getCategoryCustom
18 0.48681712150574 After getting category custom After call to function getCategoryCustom
19 0.48681902885437 Before getting category custom Before call to function getCategoryCustom
20 0.48968315124512 After getting category custom After call to function getCategoryCustom
21 0.48968601226807 End of GetCategoryList function End of the function
22 0.48969602584839 End of getCategoryListByGroup Function Before return()
23 0.49491405487061 App Controller End End of the App controller (called before the controller of every page)
24 0.49519896507263 Product Start Start of the product info controller
25 0.49632000923157 Cache file not found Starting get product details
26 0.51381993293762 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
27 1.1206290721893 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
28 1.1226890087128 Related products Start getting related products if enabled
29 1.12269115448 Related Products Start Before the related products are found
30 1.1226921081543 Related Products Keywords Before the related product keywords are found
31 1.1226980686188 Create Keyword List Function Start of function
32 1.1227271556854 Create Keyword List Function After looping provided content - 12 keywords found
33 1.123321056366 Create Keyword List Function After looping initial keyword list - 11 keywords remaining
34 1.1233279705048 Create Keyword List Function After reducing keyword list
35 1.1233501434326 Create Keyword List Function After selecting by scoring keywords
36 1.1233539581299 Create Keyword List Function After final loop of keywords
37 1.1233561038971 Related Products Keywords After the related product keywords are found
38 1.1390180587769 Related Products End After the related products are found
39 1.1489310264587 Product End End of the product info controller (Product Info)
40 1.1496419906616 App_after Controller Start Start of the App_after controller (called after the controller of every page)
41 1.1501400470734 Before Get Options Before the call to getOptions in the tpl class
42 1.1758799552917 After Get Options After the call to getOptions in the tpl class
43 1.1759669780731 App_after Controller End End of the App_after controller (called after the controller of every page)
44 1.1759920120239 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
45 1.2043981552124 Product Info: After Smarty Fetch After the product.tpl template is fetched
46 1.2044031620026 Product Info: Before Template Display Before the template is displayed
47 1.2803030014038 Product Info: After Template Display After the template is displayed
48 1.280308008194 Finalizing debug Before the debug is output to the page.
49 1.2803201675415 End of App This is the end of the app logging, final timestamp


Query Debug - 252 Database Queries. Total time 0.1203 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00063610076904297
SELECT parameter, value FROM parameters
2 0.0011 0.001086950302124
SELECT * FROM `bad_bots`
3 0.0004 0.00042390823364258
SET time_zone = 'Europe/London'
4 0.0003 0.00030708312988281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0027 0.0026588439941406
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.207.238.146\";}'
6 0.0013 0.0013480186462402
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627265327'
7 0.0004 0.00037288665771484
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00059294700622559
UPDATE autorun SET lastrun = '2021-07-26 02:08:47' WHERE id = '9'
9 0.0003 0.00033998489379883
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0005 0.00045108795166016
SELECT id FROM pages WHERE pagename = 'the-bio-bleu-vert-oolong' LIMIT 1
11 0.0004 0.00041604042053223
SELECT id FROM products WHERE pagename = 'the-bio-bleu-vert-oolong' AND hidden = 0 LIMIT 1
12 0.0009 0.00089406967163086
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
13 0.0008 0.00077700614929199
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
14 0.0003 0.00034999847412109
SELECT * FROM pages WHERE pagename = 'the-bio-bleu-vert-oolong'
15 0.0003 0.00027704238891602
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00048995018005371
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0067 0.0067408084869385
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.00020194053649902
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.00019502639770508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0002 0.00015401840209961
SELECT id FROM categories WHERE parent_id = '26'
21 0.0067 0.0066969394683838
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.0003349781036377
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0002 0.00024986267089844
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.00021886825561523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0002 0.00023698806762695
SELECT * FROM categorygroups WHERE id = '1'
26 0.0045 0.0044779777526855
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.0002 0.00021195411682129
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.00023508071899414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '27'
30 0.0043 0.0043017864227295
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.00021600723266602
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.00017905235290527
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.00021481513977051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0002 0.00024795532226562
SELECT * FROM categorygroups WHERE id = '1'
35 0.0015 0.0014669895172119
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.0003 0.00028800964355469
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.00019097328186035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0002 0.00019311904907227
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.0015931129455566
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.00021195411682129
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.00016283988952637
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.00016283988952637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0002 0.00018000602722168
SELECT * FROM categorygroups WHERE id = '1'
44 0.0005 0.00048589706420898
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.00022196769714355
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.00016403198242188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0002 0.00015997886657715
SELECT id FROM categories WHERE parent_id = '29'
48 0.0005 0.00049114227294922
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.00023484230041504
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.0003 0.00027704238891602
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.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0002 0.00016498565673828
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00050711631774902
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0003 0.00027108192443848
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.0003 0.00033307075500488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.00061488151550293
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.0003 0.00028204917907715
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.00018095970153809
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.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0002 0.00023889541625977
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00061798095703125
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.00020289421081543
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.00023293495178223
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0002 0.00019311904907227
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00058484077453613
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.00020813941955566
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.00020813941955566
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0002 0.00020384788513184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.00029683113098145
SELECT * FROM categorygroups WHERE id = '1'
71 0.0002 0.0002140998840332
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0003 0.00027298927307129
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0003 0.00025510787963867
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
74 0.0002 0.00018000602722168
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0003 0.0003209114074707
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
76 0.0002 0.00023913383483887
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
77 0.0002 0.00018095970153809
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
78 0.0006 0.0006101131439209
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
79 0.0004 0.00035810470581055
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.00022315979003906
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
81 0.0002 0.0002131462097168
SELECT * FROM countryredirects WHERE countrycode = 'US'
82 0.0005 0.00051188468933105
SELECT * FROM products WHERE pagename = 'the-bio-bleu-vert-oolong'
83 0.0004 0.00042104721069336
SELECT * FROM manufacturers WHERE id = '179'
84 0.0006 0.00055313110351562
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '179'
85 0.0005 0.0004889965057373
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '179' LIMIT 1
86 0.0007 0.00073599815368652
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '179' ORDER BY RAND() LIMIT 1
87 0.0015 0.0014641284942627
SELECT * FROM productimages WHERE product_id = '989' ORDER BY sortorder ASC
88 0.0002 0.00023102760314941
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '179'
89 0.0005 0.0005340576171875
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '179'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0003 0.00025320053100586
SELECT * FROM manufacturerimages WHERE manufacturer_id = '179'
91 0.0003 0.0003199577331543
SELECT category_id FROM products_categories WHERE product_id = '1153'
92 0.0002 0.00020718574523926
SELECT * FROM categories WHERE id = '27'
93 0.0002 0.00018310546875
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.00015497207641602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0002 0.00018095970153809
SELECT id FROM categories WHERE parent_id = '27'
96 0.0002 0.00017905235290527
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.00019502639770508
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.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
99 0.0002 0.00021100044250488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0011 0.0011470317840576
SELECT * FROM productimages WHERE product_id = '1153' ORDER BY sortorder ASC
101 0.0005 0.00045204162597656
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1153' AND p.id = pi.product_id ORDER BY pi.sortorder
102 0.0005 0.00045108795166016
SELECT * FROM product_image_select WHERE product_id = '1153'
103 0.0003 0.00033402442932129
SELECT * FROM productcustomimages WHERE product_id = '1153'
104 0.0004 0.00035500526428223
SELECT * FROM productfeeds WHERE product_id = '1153' ORDER BY item_date DESC
105 0.0005 0.00049090385437012
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1153' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
106 0.0005 0.00053310394287109
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1153' AND t.hidden = 0 AND display_product = 1
107 0.0004 0.00043296813964844
SELECT * FROM productamazoncontent WHERE product_id = '1153'
108 0.0005 0.00053095817565918
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 = '1153'
                GROUP BY o.product_id
109 0.0006 0.0005640983581543
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     = '1153'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
110 0.0003 0.00033903121948242
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1153
111 0.0009 0.00088286399841309
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1153' AND a.name = n.originalname
112 0.0003 0.0003209114074707
SELECT * FROM productoffers WHERE product_id = '1153' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0004 0.00036191940307617
SELECT * FROM productoffers
                WHERE product_id = '1153' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00037503242492676
SELECT * FROM productoffers
                WHERE product_id = 1153
                ORDER BY price ASC LIMIT 1
115 0.0004 0.00035786628723145
SELECT value FROM productattributes
                WHERE product_id = '1153'
                AND name = 'ListPriceAmount'
116 0.0002 0.00017809867858887
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 = '1153'
                GROUP BY o.product_id
117 0.0002 0.00020813941955566
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     = '1153'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
118 0.0002 0.00015711784362793
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1153
119 0.0004 0.00035190582275391
SELECT * FROM products WHERE parent_id = '1153'
120 0.0003 0.00034403800964355
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
121 0.0003 0.00032591819763184
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.00022196769714355
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
123 0.0002 0.00022292137145996
SELECT * FROM ebay_products_cache WHERE cachekey = '4ee8d429538b2b5d4286b7d39916c82c' 
124 0.0002 0.00018596649169922
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
125 0.0004 0.00036907196044922
SELECT * FROM ebay_products_cache WHERE cachekey = '4ee8d429538b2b5d4286b7d39916c82c' 
126 0.0015 0.0015020370483398
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.60683584213257', '7a55776b7c95b05ac9330e3f7a41154f', 'http://www.boite-a-the.fr/the-bio-bleu-vert-oolong/', '2021-07-26 02:08:48'
127 0.0078 0.0078070163726807
SELECT *, MATCH (description, title) AGAINST ('bleu vert oolong' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('bleu vert oolong' IN BOOLEAN MODE) AND 1153 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
128 0.0008 0.00078392028808594
SELECT *, MATCH (description, title) AGAINST ('bleu vert oolong' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('bleu vert oolong' IN BOOLEAN MODE) AND 1153 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
129 0.0005 0.00054311752319336
SELECT *, MATCH (description, title) AGAINST ('bleu vert oolong' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('bleu vert oolong' IN BOOLEAN MODE) AND 1153 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
130 0.0002 0.00024604797363281
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
131 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '1160'
132 0.0003 0.0002751350402832
SELECT * FROM productcustomimages WHERE product_id = '1160'
133 0.0002 0.00020694732666016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
134 0.0004 0.00040698051452637
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0004 0.00039505958557129
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0002 0.00018405914306641
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0003 0.00030398368835449
SELECT * FROM productimages WHERE product_id = '1806' ORDER BY sortorder ASC
138 0.0003 0.00030112266540527
SELECT * FROM product_image_select WHERE product_id = '1806'
139 0.0002 0.000244140625
SELECT * FROM productcustomimages WHERE product_id = '1806'
140 0.0002 0.00024199485778809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1806' AND a.name = n.originalname
141 0.0002 0.0002140998840332
SELECT * FROM productoffers WHERE product_id = '1806' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0004 0.00038886070251465
SELECT * FROM productoffers
                WHERE product_id = '1806' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0003 0.00029706954956055
SELECT value FROM productattributes WHERE product_id = '1806' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0003 0.00029087066650391
SELECT * FROM productimages WHERE product_id = '4910' ORDER BY sortorder ASC
145 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '4910'
146 0.0003 0.00025296211242676
SELECT * FROM productcustomimages WHERE product_id = '4910'
147 0.0002 0.0002131462097168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4910' AND a.name = n.originalname
148 0.0002 0.0002439022064209
SELECT * FROM productoffers WHERE product_id = '4910' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0004 0.00035309791564941
SELECT * FROM productoffers
                WHERE product_id = '4910' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00020503997802734
SELECT value FROM productattributes WHERE product_id = '4910' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0004 0.00042080879211426
SELECT id,asin FROM products WHERE parent_id = 1153
152 0.0003 0.00028610229492188
SELECT category_id FROM products_categories WHERE product_id = '1153'
153 0.0002 0.00024008750915527
SELECT * FROM categories WHERE id = '27'
154 0.0002 0.00020909309387207
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
155 0.0002 0.00023818016052246
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
156 0.0002 0.00021982192993164
SELECT id FROM categories WHERE parent_id = '27'
157 0.0002 0.00019001960754395
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 
158 0.0002 0.0002439022064209
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 
159 0.0002 0.00017499923706055
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
160 0.0002 0.00020003318786621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
161 0.0003 0.00034999847412109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1153' AND a.name = n.originalname
162 0.0003 0.00026512145996094
SELECT * FROM productoffers WHERE product_id = '1153' AND merchantid = 'A1X6FK5RDHNB96'
163 0.0003 0.00027585029602051
SELECT * FROM productoffers
                WHERE product_id = '1153' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0003 0.00028586387634277
SELECT * FROM productoffers
                WHERE product_id = 1153
                ORDER BY price ASC LIMIT 1
165 0.0004 0.00035309791564941
SELECT value FROM productattributes
                WHERE product_id = '1153'
                AND name = 'ListPriceAmount'
166 0.0006 0.00055789947509766
SELECT * FROM products WHERE id = '1153'
167 0.0002 0.00022101402282715
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 = '1153'
                GROUP BY o.product_id
168 0.0003 0.00029706954956055
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     = '1153'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
169 0.0003 0.00025391578674316
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1153
170 0.0002 0.00020408630371094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1153' AND a.name = n.originalname
171 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '1153' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0003 0.00033211708068848
SELECT * FROM productoffers
                WHERE product_id = '1153' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0003 0.00033903121948242
SELECT * FROM productoffers
                WHERE product_id = 1153
                ORDER BY price ASC LIMIT 1
174 0.0004 0.00036311149597168
SELECT value FROM productattributes
                WHERE product_id = '1153'
                AND name = 'ListPriceAmount'
175 0.0004 0.00043606758117676
SELECT category_id FROM products_categories WHERE product_id = '1153' AND prod_type = 'amz'
176 0.0002 0.00019192695617676
SELECT parent_id FROM categories WHERE id = '27'
177 0.0006 0.00062417984008789
SELECT * FROM categories WHERE id = '27'
178 0.0002 0.00018215179443359
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
179 0.0002 0.00022101402282715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
180 0.0002 0.00022411346435547
SELECT id FROM categories WHERE parent_id = '27'
181 0.0003 0.00029706954956055
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 
182 0.0002 0.00017499923706055
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 
183 0.0002 0.00016403198242188
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
184 0.0002 0.00019383430480957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
185 0.0004 0.00039291381835938
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
186 0.0002 0.00017809867858887
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
187 0.0002 0.00023698806762695
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
188 0.0002 0.0002138614654541
SELECT * FROM pages WHERE id = 38
189 0.0041 0.0041120052337646
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
190 0.0005 0.00047492980957031
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:1627265328;s:8:\"products\";a:6:{i:0;s:10:\"808|amazon\";i:1;s:11:\"4939|amazon\";i:2;s:11:\"1727|amazon\";i:3;s:10:\"873|amazon\";i:4;s:10:\"894|amazon\";i:5;s:10:\"881|amazon\";}}' WHERE id = '160'
191 0.0005 0.00045895576477051
SELECT * FROM products WHERE id = 808
192 0.0004 0.0003960132598877
SELECT * FROM products WHERE id = 4939
193 0.0004 0.00040793418884277
SELECT * FROM products WHERE id = 1727
194 0.0004 0.00036907196044922
SELECT * FROM products WHERE id = 873
195 0.0004 0.00044512748718262
SELECT * FROM products WHERE id = 894
196 0.0004 0.00036311149597168
SELECT * FROM products WHERE id = 881
197 0.0004 0.00043797492980957
SELECT * FROM products WHERE id = '808'
198 0.0003 0.00032901763916016
SELECT * FROM productimages WHERE product_id = '808' ORDER BY sortorder ASC
199 0.0003 0.00030303001403809
SELECT * FROM product_image_select WHERE product_id = '808'
200 0.0005 0.00048685073852539
SELECT * FROM productcustomimages WHERE product_id = '808'
201 0.0003 0.00026607513427734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '808' AND a.name = n.originalname
202 0.0003 0.0002589225769043
SELECT * FROM productoffers WHERE product_id = '808' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0003 0.00033211708068848
SELECT * FROM productoffers
                WHERE product_id = '808' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0002 0.00019192695617676
SELECT value FROM productattributes WHERE product_id = '808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0004 0.00037598609924316
SELECT * FROM products WHERE id = '4939'
206 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
207 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '4939'
208 0.0002 0.0002288818359375
SELECT * FROM productcustomimages WHERE product_id = '4939'
209 0.0003 0.00029802322387695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
210 0.0006 0.00056195259094238
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0003 0.00028395652770996
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0002 0.00019693374633789
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0004 0.00042605400085449
SELECT * FROM products WHERE id = '1727'
214 0.0002 0.00017213821411133
SELECT * FROM productimages WHERE product_id = '1727' ORDER BY sortorder ASC
215 0.0002 0.00019311904907227
SELECT * FROM product_image_select WHERE product_id = '1727'
216 0.0002 0.00017189979553223
SELECT * FROM productcustomimages WHERE product_id = '1727'
217 0.0002 0.00021791458129883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1727' AND a.name = n.originalname
218 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '1727' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0004 0.00037002563476562
SELECT * FROM productoffers
                WHERE product_id = '1727' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0002 0.0001680850982666
SELECT value FROM productattributes WHERE product_id = '1727' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0004 0.00039196014404297
SELECT * FROM products WHERE id = '873'
222 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '873' ORDER BY sortorder ASC
223 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '873'
224 0.0002 0.00018095970153809
SELECT * FROM productcustomimages WHERE product_id = '873'
225 0.0003 0.0002741813659668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '873' AND a.name = n.originalname
226 0.0002 0.00020909309387207
SELECT * FROM productoffers WHERE product_id = '873' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0003 0.00033402442932129
SELECT * FROM productoffers
                WHERE product_id = '873' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0002 0.00024700164794922
SELECT value FROM productattributes WHERE product_id = '873' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0004 0.00043010711669922
SELECT * FROM products WHERE id = '894'
230 0.0003 0.00027894973754883
SELECT * FROM productimages WHERE product_id = '894' ORDER BY sortorder ASC
231 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '894'
232 0.0002 0.00021505355834961
SELECT * FROM productcustomimages WHERE product_id = '894'
233 0.0002 0.00024008750915527
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '894' AND a.name = n.originalname
234 0.0003 0.00027918815612793
SELECT * FROM productoffers WHERE product_id = '894' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0004 0.00043606758117676
SELECT * FROM productoffers
                WHERE product_id = '894' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0002 0.00018000602722168
SELECT value FROM productattributes WHERE product_id = '894' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0004 0.00039100646972656
SELECT * FROM products WHERE id = '881'
238 0.0003 0.00032901763916016
SELECT * FROM productimages WHERE product_id = '881' ORDER BY sortorder ASC
239 0.0002 0.00019502639770508
SELECT * FROM product_image_select WHERE product_id = '881'
240 0.0002 0.00018596649169922
SELECT * FROM productcustomimages WHERE product_id = '881'
241 0.0002 0.00021910667419434
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '881' AND a.name = n.originalname
242 0.0003 0.00031089782714844
SELECT * FROM productoffers WHERE product_id = '881' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0004 0.00041890144348145
SELECT * FROM productoffers
                WHERE product_id = '881' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0002 0.00017404556274414
SELECT value FROM productattributes WHERE product_id = '881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0002 0.00024509429931641
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
246 0.0002 0.00024199485778809
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
247 0.0007 0.00071597099304199
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
248 0.0003 0.00034284591674805
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
249 0.0003 0.00028109550476074
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
250 0.0006 0.0005500316619873
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
251 0.0003 0.00031399726867676
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
252 0.0005 0.00049591064453125
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'