Tianhushan - Thé Vert Japonais 200G (100 Sachets)

Tianhushan - Thé Vert Japonais 200G (100 Sachets)
Tianhushan - Thé Vert Japonais 200G (100 Sachets) Tianhushan - Thé Vert Japonais 200G (100 Sachets) Tianhushan - Thé Vert Japonais 200G (100 Sachets) (cliquez sur les images pour élargir)
€14,99
Le prix et la disponibilité du produit sont corrects en date du 2022-05-29 07:27:22 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.
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.80011892318726 234 0.1380 0


No Amazon API Requests Made.

Total time 0.80011892318726 seconds

Number Time From Start Name Description
1 0.62869501113892 Initialise Initialise FSB Function
2 0.63066792488098 App Controller Start Start of the App controller (called before the controller of every page)
3 0.633633852005 Start of getCategoryListByGroup Function Before first category groups query
4 0.63394594192505 After initial query Before first category groups query
5 0.63394784927368 Get Category List for Group Before the call to getCategoryList function
6 0.63395094871521 Start of GetCategoryList function Start of the function
7 0.63395285606384 Before getting categories Query to get specific category list
8 0.63433599472046 After getting categories Query to get specific category list
9 0.63433790206909 Before getting category custom Before call to function getCategoryCustom
10 0.65417790412903 After getting category custom After call to function getCategoryCustom
11 0.65418100357056 Before getting category custom Before call to function getCategoryCustom
12 0.665855884552 After getting category custom After call to function getCategoryCustom
13 0.66585898399353 Before getting category custom Before call to function getCategoryCustom
14 0.67158389091492 After getting category custom After call to function getCategoryCustom
15 0.67158699035645 Before getting category custom Before call to function getCategoryCustom
16 0.67495584487915 After getting category custom After call to function getCategoryCustom
17 0.67495799064636 Before getting category custom Before call to function getCategoryCustom
18 0.67846298217773 After getting category custom After call to function getCategoryCustom
19 0.67846584320068 Before getting category custom Before call to function getCategoryCustom
20 0.68161988258362 After getting category custom After call to function getCategoryCustom
21 0.68162298202515 End of GetCategoryList function End of the function
22 0.68162798881531 End of getCategoryListByGroup Function Before return()
23 0.68599390983582 App Controller End End of the App controller (called before the controller of every page)
24 0.68628191947937 Product Start Start of the product info controller
25 0.68832278251648 Cache file not found Starting get product details
26 0.70750093460083 Related products Start getting related products if enabled
27 0.70750284194946 Related Products Start Before the related products are found
28 0.70750379562378 Related Products Keywords Before the related product keywords are found
29 0.70750784873962 Create Keyword List Function Start of function
30 0.70753288269043 Create Keyword List Function After looping provided content - 18 keywords found
31 0.70828485488892 Create Keyword List Function After looping initial keyword list - 17 keywords remaining
32 0.70829081535339 Create Keyword List Function After reducing keyword list
33 0.70831990242004 Create Keyword List Function After selecting by scoring keywords
34 0.70832300186157 Create Keyword List Function After final loop of keywords
35 0.70832490921021 Related Products Keywords After the related product keywords are found
36 0.72868895530701 Related Products End After the related products are found
37 0.73822593688965 Product End End of the product info controller (Product Info)
38 0.73879790306091 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.73935580253601 Before Get Options Before the call to getOptions in the tpl class
40 0.76982283592224 After Get Options After the call to getOptions in the tpl class
41 0.7699019908905 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.7699248790741 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.78109288215637 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.78109788894653 Product Info: Before Template Display Before the template is displayed
45 0.80010390281677 Product Info: After Template Display After the template is displayed
46 0.80010795593262 Finalizing debug Before the debug is output to the page.
47 0.80011796951294 End of App This is the end of the app logging, final timestamp


Query Debug - 234 Database Queries. Total time 0.1380 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00048208236694336
SELECT parameter, value FROM parameters
2 0.0009 0.00093197822570801
SELECT * FROM `bad_bots`
3 0.0004 0.00040698051452637
SET time_zone = 'Europe/London'
4 0.0003 0.00031495094299316
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0017 0.001737117767334
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.244.12\";}'
6 0.0012 0.0011940002441406
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653815117'
7 0.0004 0.00044894218444824
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00037002563476562
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00052499771118164
SELECT id FROM pages WHERE pagename = 'tianhushan-the-vert-japonais-200g-100-sachets' LIMIT 1
10 0.0006 0.00058698654174805
SELECT id FROM products WHERE pagename = 'tianhushan-the-vert-japonais-200g-100-sachets' AND hidden = 0 LIMIT 1
11 0.0012 0.0011661052703857
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0007 0.00074601173400879
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00064802169799805
SELECT * FROM pages WHERE pagename = 'tianhushan-the-vert-japonais-200g-100-sachets'
14 0.0003 0.00029993057250977
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00036287307739258
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0111 0.011126041412354
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.0003 0.00027203559875488
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.00021791458129883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '26'
20 0.0068 0.0068459510803223
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.00033020973205566
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.0002 0.00024604797363281
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.00020885467529297
SELECT * FROM categorygroups WHERE id = '1'
25 0.0045 0.0045280456542969
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.0003 0.00034189224243164
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.0005 0.00047993659973145
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00046205520629883
SELECT id FROM categories WHERE parent_id = '27'
29 0.0046 0.004601001739502
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.00034499168395996
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0003 0.00034499168395996
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.00023198127746582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00021696090698242
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0016520023345947
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.00034689903259277
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.00041794776916504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00033998489379883
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0016171932220459
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.0002 0.00024700164794922
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0004 0.0003960132598877
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.0003 0.0003209114074707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00024509429931641
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00068211555480957
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0004 0.0003509521484375
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.00024199485778809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00064706802368164
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.0002 0.0002291202545166
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.0003 0.00031399726867676
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.0002 0.00024890899658203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00033402442932129
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00068211555480957
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.0002 0.00024509429931641
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.0003 0.0002598762512207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00036907196044922
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00078392028808594
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0004 0.00035905838012695
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.00021815299987793
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.00024294853210449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00023984909057617
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00070285797119141
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.0002439022064209
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.00022411346435547
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00065994262695312
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0002 0.00021791458129883
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.0002 0.00024104118347168
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.0003 0.00029206275939941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00021600723266602
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00023698806762695
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00025606155395508
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00025510787963867
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.0002 0.00022387504577637
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0006 0.00057792663574219
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0004 0.00043010711669922
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00028491020202637
SELECT * FROM ipgeocountries WHERE INET_ATON('34.231.244.12') >= INET_ATON(ip_start) AND INET_ATON('34.231.244.12') <= INET_ATON(ip_end)
77 0.0002 0.00024509429931641
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0004 0.00042390823364258
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.00058603286743164
SELECT * FROM products WHERE pagename = 'tianhushan-the-vert-japonais-200g-100-sachets'
80 0.0010 0.0009620189666748
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1264
81 0.0007 0.00072193145751953
SELECT * FROM manufacturers WHERE id = '295'
82 0.0006 0.00060296058654785
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '295'
83 0.0004 0.00038385391235352
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '295' LIMIT 1
84 0.0007 0.00069189071655273
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '295' ORDER BY RAND() LIMIT 1
85 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '1264' ORDER BY sortorder ASC
86 0.0003 0.00025200843811035
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '295'
87 0.0006 0.00056099891662598
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '295'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.00042080879211426
SELECT * FROM manufacturerimages WHERE manufacturer_id = '295'
89 0.0004 0.00040316581726074
SELECT category_id FROM products_categories WHERE product_id = '1264'
90 0.0003 0.00027894973754883
SELECT * FROM categories WHERE id = '28'
91 0.0024 0.0024001598358154
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
92 0.0003 0.00025701522827148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
93 0.0004 0.00039482116699219
SELECT id FROM categories WHERE parent_id = '28'
94 0.0021 0.0020649433135986
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 
95 0.0003 0.00032591819763184
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 
96 0.0002 0.00023412704467773
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
97 0.0004 0.00039386749267578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
98 0.0003 0.00034093856811523
SELECT * FROM productimages WHERE product_id = '1264' ORDER BY sortorder ASC
99 0.0003 0.00034594535827637
SELECT * FROM product_image_select WHERE product_id = '1264'
100 0.0003 0.00034999847412109
SELECT * FROM productcustomimages WHERE product_id = '1264'
101 0.0005 0.00047111511230469
SELECT * FROM productfeeds WHERE product_id = '1264' ORDER BY item_date DESC
102 0.0006 0.00055193901062012
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1264' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0007 0.00068902969360352
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1264' AND t.hidden = 0 AND display_product = 1
104 0.0003 0.00029993057250977
SELECT * FROM tags WHERE id = '500'
105 0.0007 0.00072598457336426
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '500'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
106 0.0010 0.00095295906066895
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '500'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
107 0.0008 0.0007779598236084
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '500' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
108 0.0003 0.00027799606323242
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
109 0.0004 0.00038409233093262
SELECT * FROM productamazoncontent WHERE product_id = '1264'
110 0.0003 0.00028395652770996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1264' AND a.name = n.originalname
111 0.0004 0.00038909912109375
SELECT * FROM productoffers WHERE product_id = '1264' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0005 0.00046086311340332
SELECT * FROM productoffers
                WHERE product_id = '1264' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0003 0.00025200843811035
SELECT value FROM productattributes WHERE product_id = '1264' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114 0.0003 0.00026297569274902
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
115 0.0080 0.0079689025878906
SELECT *, MATCH (description, title) AGAINST ('tianhushan thé vert' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('tianhushan thé vert' IN BOOLEAN MODE) AND 1264 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
116 0.0005 0.00053501129150391
SELECT *, MATCH (description, title) AGAINST ('tianhushan thé vert' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('tianhushan thé vert' IN BOOLEAN MODE) AND 1264 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
117 0.0005 0.0004889965057373
SELECT *, MATCH (description, title) AGAINST ('tianhushan thé vert' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('tianhushan thé vert' IN BOOLEAN MODE) AND 1264 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
118 0.0003 0.00028300285339355
SELECT * FROM productimages WHERE product_id = '842' ORDER BY sortorder ASC
119 0.0003 0.00030779838562012
SELECT * FROM product_image_select WHERE product_id = '842'
120 0.0003 0.00026488304138184
SELECT * FROM productcustomimages WHERE product_id = '842'
121 0.0017 0.0017068386077881
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '842' AND a.name = n.originalname
122 0.0004 0.0003812313079834
SELECT * FROM productoffers WHERE product_id = '842' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0005 0.00051999092102051
SELECT * FROM productoffers
                WHERE product_id = '842' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0005 0.00047087669372559
SELECT value FROM productattributes WHERE product_id = '842' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0004 0.0004267692565918
SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC
126 0.0002 0.00023984909057617
SELECT * FROM product_image_select WHERE product_id = '853'
127 0.0003 0.00030398368835449
SELECT * FROM productcustomimages WHERE product_id = '853'
128 0.0007 0.00071477890014648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname
129 0.0004 0.00036096572875977
SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96'
130 0.0006 0.00058102607727051
SELECT * FROM productoffers
                WHERE product_id = '853' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0006 0.00055313110351562
SELECT value FROM productattributes WHERE product_id = '853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0004 0.00037908554077148
SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
133 0.0003 0.0002748966217041
SELECT * FROM product_image_select WHERE product_id = '857'
134 0.0003 0.00025796890258789
SELECT * FROM productcustomimages WHERE product_id = '857'
135 0.0010 0.00095891952514648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
136 0.0005 0.00048995018005371
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0005 0.000518798828125
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0007 0.00069093704223633
SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0005 0.00048708915710449
SELECT id,asin FROM products WHERE parent_id = 1264
140 0.0003 0.00031900405883789
SELECT category_id FROM products_categories WHERE product_id = '1264'
141 0.0005 0.00045394897460938
SELECT * FROM categories WHERE id = '28'
142 0.0003 0.00026822090148926
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
143 0.0004 0.00040292739868164
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
144 0.0003 0.00033092498779297
SELECT id FROM categories WHERE parent_id = '28'
145 0.0003 0.00026512145996094
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 
146 0.0003 0.00025296211242676
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 
147 0.0002 0.00023102760314941
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
148 0.0002 0.00022292137145996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
149 0.0002 0.0002439022064209
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1264' AND a.name = n.originalname
150 0.0003 0.00031304359436035
SELECT * FROM productoffers WHERE product_id = '1264' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0004 0.00043606758117676
SELECT * FROM productoffers
                WHERE product_id = '1264' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0005 0.00054216384887695
SELECT * FROM products WHERE id = '1264'
153 0.0003 0.00025200843811035
SELECT value FROM productattributes WHERE product_id = '1264' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0003 0.00031805038452148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1264' AND a.name = n.originalname
155 0.0004 0.00044512748718262
SELECT * FROM productoffers WHERE product_id = '1264' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0005 0.00045490264892578
SELECT * FROM productoffers
                WHERE product_id = '1264' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0005 0.00050806999206543
SELECT category_id FROM products_categories WHERE product_id = '1264' AND prod_type = 'amz'
158 0.0003 0.00029993057250977
SELECT parent_id FROM categories WHERE id = '28'
159 0.0003 0.00026488304138184
SELECT * FROM categories WHERE id = '28'
160 0.0002 0.00023508071899414
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
161 0.0002 0.0002439022064209
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
162 0.0003 0.00026488304138184
SELECT id FROM categories WHERE parent_id = '28'
163 0.0003 0.00027894973754883
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 
164 0.0002 0.00023603439331055
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
165 0.0003 0.00025177001953125
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
166 0.0003 0.00026607513427734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
167 0.0003 0.00027585029602051
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
168 0.0002 0.0002439022064209
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
169 0.0002 0.00023198127746582
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
170 0.0003 0.00032281875610352
SELECT * FROM pages WHERE id = 38
171 0.0042 0.004202127456665
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
172 0.0006 0.00055789947509766
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:1653815118;s:8:\"products\";a:6:{i:0;s:10:\"788|amazon\";i:1;s:10:\"787|amazon\";i:2;s:11:\"1287|amazon\";i:3;s:10:\"780|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
173 0.0006 0.00062704086303711
SELECT * FROM products WHERE id = 788
174 0.0005 0.0005488395690918
SELECT * FROM products WHERE id = 787
175 0.0005 0.00051093101501465
SELECT * FROM products WHERE id = 1287
176 0.0006 0.00056815147399902
SELECT * FROM products WHERE id = 780
177 0.0006 0.00055909156799316
SELECT * FROM products WHERE id = 777
178 0.0007 0.00067615509033203
SELECT * FROM products WHERE id = 776
179 0.0006 0.00061511993408203
SELECT * FROM products WHERE id = '788'
180 0.0004 0.00039005279541016
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
181 0.0003 0.00028681755065918
SELECT * FROM product_image_select WHERE product_id = '788'
182 0.0004 0.00042891502380371
SELECT * FROM productcustomimages WHERE product_id = '788'
183 0.0005 0.00045609474182129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
184 0.0004 0.0003960132598877
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0003 0.00029301643371582
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0002 0.00024914741516113
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0007 0.0006709098815918
SELECT * FROM products WHERE id = '787'
188 0.0004 0.0003659725189209
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
189 0.0003 0.00033211708068848
SELECT * FROM product_image_select WHERE product_id = '787'
190 0.0003 0.00029110908508301
SELECT * FROM productcustomimages WHERE product_id = '787'
191 0.0004 0.00040197372436523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
192 0.0004 0.00044894218444824
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0004 0.00037598609924316
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0003 0.0002899169921875
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0006 0.0006248950958252
SELECT * FROM products WHERE id = '1287'
196 0.0004 0.00040388107299805
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
197 0.0003 0.00031709671020508
SELECT * FROM product_image_select WHERE product_id = '1287'
198 0.0003 0.00025606155395508
SELECT * FROM productcustomimages WHERE product_id = '1287'
199 0.0004 0.00037193298339844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
200 0.0003 0.00027108192443848
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0003 0.00028586387634277
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0003 0.00025510787963867
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0005 0.00049805641174316
SELECT * FROM products WHERE id = '780'
204 0.0004 0.00038504600524902
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
205 0.0003 0.00025701522827148
SELECT * FROM product_image_select WHERE product_id = '780'
206 0.0002 0.00023293495178223
SELECT * FROM productcustomimages WHERE product_id = '780'
207 0.0003 0.00028610229492188
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
208 0.0003 0.00029802322387695
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0003 0.00027084350585938
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0002 0.00023603439331055
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0004 0.00043487548828125
SELECT * FROM products WHERE id = '777'
212 0.0003 0.00025796890258789
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
213 0.0002 0.00023412704467773
SELECT * FROM product_image_select WHERE product_id = '777'
214 0.0002 0.0002291202545166
SELECT * FROM productcustomimages WHERE product_id = '777'
215 0.0003 0.00027585029602051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
216 0.0003 0.00025320053100586
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0003 0.00029110908508301
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0002 0.00023102760314941
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0006 0.00060009956359863
SELECT * FROM products WHERE id = '776'
220 0.0004 0.00042200088500977
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
221 0.0003 0.00028181076049805
SELECT * FROM product_image_select WHERE product_id = '776'
222 0.0004 0.00037407875061035
SELECT * FROM productcustomimages WHERE product_id = '776'
223 0.0003 0.00034379959106445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
224 0.0003 0.00026988983154297
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0003 0.00032496452331543
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0003 0.00025606155395508
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0004 0.00036406517028809
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
228 0.0003 0.00034785270690918
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
229 0.0008 0.00078511238098145
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
230 0.0005 0.00045394897460938
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
231 0.0004 0.00044584274291992
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0004 0.00040602684020996
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
233 0.0004 0.00036501884460449
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0004 0.00040483474731445
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'