Lipton Thé Vert Mandarine Orange 20 Sachets 36 g

Lipton Thé Vert Mandarine Orange 20 Sachets 36 g
Lipton Thé Vert Mandarine Orange 20 Sachets 36 g Lipton Thé Vert Mandarine Orange 20 Sachets 36 g Lipton Thé Vert Mandarine Orange 20 Sachets 36 g Lipton Thé Vert Mandarine Orange 20 Sachets 36 g Lipton Thé Vert Mandarine Orange 20 Sachets 36 g (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-09-17 09:24:40 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é Vert^SACHET PYRAMID ®^MANDARINE ORANGE^Un goût plus léger et moins amer.^Un sachet en forme pyramidale : plus d'espace pour de longues feuilles de thé et une meilleure infusion pour plus de goût^Vérifié Rainforest Alliance : feuilles de thé issues de plantation vérifiées Rainforest Alliance appliquant des principes de développement durable
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.71555614471436 236 0.1102 0


No Amazon API Requests Made.

Total time 0.71555614471436 seconds

Number Time From Start Name Description
1 0.55376601219177 Initialise Initialise FSB Function
2 0.55606317520142 App Controller Start Start of the App controller (called before the controller of every page)
3 0.55942606925964 Start of getCategoryListByGroup Function Before first category groups query
4 0.55968499183655 After initial query Before first category groups query
5 0.55968713760376 Get Category List for Group Before the call to getCategoryList function
6 0.55969214439392 Start of GetCategoryList function Start of the function
7 0.55969619750977 Before getting categories Query to get specific category list
8 0.56012105941772 After getting categories Query to get specific category list
9 0.56012320518494 Before getting category custom Before call to function getCategoryCustom
10 0.56240320205688 After getting category custom After call to function getCategoryCustom
11 0.56240606307983 Before getting category custom Before call to function getCategoryCustom
12 0.57489204406738 After getting category custom After call to function getCategoryCustom
13 0.57489609718323 Before getting category custom Before call to function getCategoryCustom
14 0.5795681476593 After getting category custom After call to function getCategoryCustom
15 0.57957220077515 Before getting category custom Before call to function getCategoryCustom
16 0.58227205276489 After getting category custom After call to function getCategoryCustom
17 0.58227515220642 Before getting category custom Before call to function getCategoryCustom
18 0.58529806137085 After getting category custom After call to function getCategoryCustom
19 0.58530116081238 Before getting category custom Before call to function getCategoryCustom
20 0.58786201477051 After getting category custom After call to function getCategoryCustom
21 0.58786606788635 End of GetCategoryList function End of the function
22 0.58787703514099 End of getCategoryListByGroup Function Before return()
23 0.5929000377655 App Controller End End of the App controller (called before the controller of every page)
24 0.59351205825806 Product Start Start of the product info controller
25 0.60585808753967 Cache file not found Starting get product details
26 0.62499213218689 Related products Start getting related products if enabled
27 0.62499403953552 Related Products Start Before the related products are found
28 0.62499618530273 Related Products Keywords Before the related product keywords are found
29 0.6250011920929 Create Keyword List Function Start of function
30 0.62503719329834 Create Keyword List Function After looping provided content - 24 keywords found
31 0.62596702575684 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
32 0.62597417831421 Create Keyword List Function After reducing keyword list
33 0.62601900100708 Create Keyword List Function After selecting by scoring keywords
34 0.62602305412292 Create Keyword List Function After final loop of keywords
35 0.62602519989014 Related Products Keywords After the related product keywords are found
36 0.6418731212616 Related Products End After the related products are found
37 0.64863419532776 Product End End of the product info controller (Product Info)
38 0.64952397346497 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.64994716644287 Before Get Options Before the call to getOptions in the tpl class
40 0.67872309684753 After Get Options After the call to getOptions in the tpl class
41 0.67887306213379 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.67890906333923 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.69399118423462 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.69400000572205 Product Info: Before Template Display Before the template is displayed
45 0.71552419662476 Product Info: After Template Display After the template is displayed
46 0.71554017066956 Finalizing debug Before the debug is output to the page.
47 0.71555519104004 End of App This is the end of the app logging, final timestamp


Query Debug - 236 Database Queries. Total time 0.1102 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00046896934509277
SELECT parameter, value FROM parameters
2 0.0012 0.0011618137359619
SELECT * FROM `bad_bots`
3 0.0003 0.00032997131347656
SET time_zone = 'Europe/London'
4 0.0003 0.00030398368835449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0023 0.0022971630096436
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.212.116\";}'
6 0.0014 0.0014078617095947
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632134834'
7 0.0003 0.00032901763916016
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00062894821166992
UPDATE autorun SET lastrun = '2021-09-20 10:47:14' WHERE id = '16'
9 0.0003 0.00029397010803223
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0007 0.00071907043457031
SELECT id FROM pages WHERE pagename = 'lipton-the-vert-mandarine-orange-20-sachets-36-g-1437146987' LIMIT 1
11 0.0005 0.00054311752319336
SELECT id FROM products WHERE pagename = 'lipton-the-vert-mandarine-orange-20-sachets-36-g-1437146987' AND hidden = 0 LIMIT 1
12 0.0011 0.0011420249938965
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
13 0.0010 0.00098013877868652
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
14 0.0006 0.0005638599395752
SELECT * FROM pages WHERE pagename = 'lipton-the-vert-mandarine-orange-20-sachets-36-g-1437146987'
15 0.0002 0.00024199485778809
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0004 0.00039815902709961
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0002 0.00023198127746582
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.00021195411682129
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.00020003318786621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '26'
21 0.0002 0.00020503997802734
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.0002 0.00023007392883301
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.00022101402282715
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.0004 0.00038385391235352
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0002 0.00023889541625977
SELECT * FROM categorygroups WHERE id = '1'
26 0.0064 0.0063738822937012
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.00021004676818848
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.00020503997802734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '27'
30 0.0045 0.0044658184051514
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.00024199485778809
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.0003 0.00025010108947754
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.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0002 0.00016593933105469
SELECT * FROM categorygroups WHERE id = '1'
35 0.0016 0.0015668869018555
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0002 0.00022196769714355
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.00018095970153809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0002 0.00018310546875
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.0015749931335449
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.00021886825561523
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.00018310546875
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.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0002 0.00020694732666016
SELECT * FROM categorygroups WHERE id = '1'
44 0.0005 0.00049114227294922
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.00017619132995605
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.0001838207244873
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0002 0.00017118453979492
SELECT id FROM categories WHERE parent_id = '29'
48 0.0005 0.00049996376037598
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.00024318695068359
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.00026893615722656
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.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.00034499168395996
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00059795379638672
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0002 0.00023698806762695
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.00034999847412109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0003 0.00027203559875488
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.00059199333190918
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0002 0.0002138614654541
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.00023007392883301
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.00021815299987793
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0002 0.00017404556274414
SELECT * FROM categorygroups WHERE id = '1'
62 0.0005 0.00054717063903809
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.00018000602722168
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.0001990795135498
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0002 0.00019288063049316
SELECT id FROM categories WHERE parent_id = '31'
66 0.0005 0.00054693222045898
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.00019288063049316
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.00018715858459473
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.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0002 0.00018215179443359
SELECT * FROM categorygroups WHERE id = '1'
71 0.0002 0.00019502639770508
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0002 0.00023603439331055
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0003 0.00029897689819336
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
74 0.0002 0.00020980834960938
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0005 0.00047087669372559
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0006 0.00059008598327637
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0003 0.0002589225769043
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.212.116') >= INET_ATON(ip_start) AND INET_ATON('3.236.212.116') <= INET_ATON(ip_end)
78 0.0002 0.00021004676818848
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0002 0.00019693374633789
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00055718421936035
SELECT * FROM products WHERE pagename = 'lipton-the-vert-mandarine-orange-20-sachets-36-g-1437146987'
81 0.0011 0.0011019706726074
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1165
82 0.0004 0.00035595893859863
SELECT * FROM manufacturers WHERE id = '220'
83 0.0008 0.00075197219848633
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220'
84 0.0003 0.00033712387084961
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '220' LIMIT 1
85 0.0011 0.0010571479797363
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '220' ORDER BY RAND() LIMIT 1
86 0.0003 0.00033879280090332
SELECT * FROM productimages WHERE product_id = '1144' ORDER BY sortorder ASC
87 0.0002 0.00021505355834961
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220'
88 0.0044 0.0043838024139404
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '220'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0002 0.00023508071899414
SELECT * FROM manufacturerimages WHERE manufacturer_id = '220'
90 0.0003 0.00034308433532715
SELECT category_id FROM products_categories WHERE product_id = '1165'
91 0.0002 0.00024795532226562
SELECT * FROM categories WHERE id = '28'
92 0.0016 0.0015609264373779
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
93 0.0003 0.00026988983154297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
94 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '28'
95 0.0015 0.0015239715576172
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 
96 0.0002 0.0001981258392334
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
97 0.0002 0.00019192695617676
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
98 0.0002 0.0002129077911377
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
99 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '1165' ORDER BY sortorder ASC
100 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '1165'
101 0.0002 0.0001990795135498
SELECT * FROM productcustomimages WHERE product_id = '1165'
102 0.0004 0.00036883354187012
SELECT * FROM productfeeds WHERE product_id = '1165' ORDER BY item_date DESC
103 0.0005 0.00045585632324219
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1165' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0005 0.00053596496582031
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1165' AND t.hidden = 0 AND display_product = 1
105 0.0008 0.00076818466186523
SELECT * FROM productamazoncontent WHERE product_id = '1165'
106 0.0007 0.00074386596679688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1165' AND a.name = n.originalname
107 0.0005 0.00047612190246582
SELECT * FROM productoffers WHERE product_id = '1165' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '1165' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0003 0.00032997131347656
SELECT * FROM productoffers
                WHERE product_id = 1165
                ORDER BY price ASC LIMIT 1
110 0.0004 0.00044918060302734
SELECT value FROM productattributes
                WHERE product_id = '1165'
                AND name = 'ListPriceAmount'
111 0.0004 0.00040793418884277
SELECT value FROM productattributes WHERE product_id = '1165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0002 0.00019502639770508
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
113 0.0079 0.0078580379486084
SELECT *, MATCH (description, title) AGAINST ('vert mandarine orange' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('vert mandarine orange' IN BOOLEAN MODE) AND 1165 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
114 0.0006 0.00056099891662598
SELECT *, MATCH (description, title) AGAINST ('vert mandarine orange' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('vert mandarine orange' IN BOOLEAN MODE) AND 1165 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0005 0.0005028247833252
SELECT *, MATCH (description, title) AGAINST ('vert mandarine orange' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('vert mandarine orange' IN BOOLEAN MODE) AND 1165 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
116 0.0003 0.00032520294189453
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
117 0.0002 0.00019097328186035
SELECT * FROM product_image_select WHERE product_id = '1287'
118 0.0002 0.00016689300537109
SELECT * FROM productcustomimages WHERE product_id = '1287'
119 0.0002 0.0002129077911377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
120 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0003 0.0003199577331543
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '866' ORDER BY sortorder ASC
124 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '866'
125 0.0003 0.00026702880859375
SELECT * FROM productcustomimages WHERE product_id = '866'
126 0.0013 0.0012760162353516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '866' AND a.name = n.originalname
127 0.0005 0.00045204162597656
SELECT * FROM productoffers WHERE product_id = '866' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0004 0.00044083595275879
SELECT * FROM productoffers
                WHERE product_id = '866' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '866' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0002 0.00020217895507812
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
131 0.0002 0.00016903877258301
SELECT * FROM product_image_select WHERE product_id = '779'
132 0.0002 0.00018000602722168
SELECT * FROM productcustomimages WHERE product_id = '779'
133 0.0002 0.00019192695617676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
134 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0002 0.00017786026000977
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0003 0.00026583671569824
SELECT id,asin FROM products WHERE parent_id = 1165
138 0.0002 0.00018095970153809
SELECT category_id FROM products_categories WHERE product_id = '1165'
139 0.0002 0.00019216537475586
SELECT * FROM categories WHERE id = '28'
140 0.0002 0.00016283988952637
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
141 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
142 0.0002 0.00015902519226074
SELECT id FROM categories WHERE parent_id = '28'
143 0.0002 0.00015902519226074
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 
144 0.0002 0.00017285346984863
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 
145 0.0002 0.00020217895507812
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
146 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
147 0.0002 0.00016617774963379
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1165' AND a.name = n.originalname
148 0.0002 0.00016999244689941
SELECT * FROM productoffers WHERE product_id = '1165' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '1165' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00017786026000977
SELECT * FROM productoffers
                WHERE product_id = 1165
                ORDER BY price ASC LIMIT 1
151 0.0002 0.00017285346984863
SELECT value FROM productattributes
                WHERE product_id = '1165'
                AND name = 'ListPriceAmount'
152 0.0006 0.0005638599395752
SELECT * FROM products WHERE id = '1165'
153 0.0002 0.00023794174194336
SELECT value FROM productattributes WHERE product_id = '1165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0002 0.00020194053649902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1165' AND a.name = n.originalname
155 0.0002 0.0002448558807373
SELECT * FROM productoffers WHERE product_id = '1165' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '1165' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = 1165
                ORDER BY price ASC LIMIT 1
158 0.0002 0.0001990795135498
SELECT value FROM productattributes
                WHERE product_id = '1165'
                AND name = 'ListPriceAmount'
159 0.0003 0.00031495094299316
SELECT category_id FROM products_categories WHERE product_id = '1165' AND prod_type = 'amz'
160 0.0002 0.00022196769714355
SELECT parent_id FROM categories WHERE id = '28'
161 0.0002 0.00019216537475586
SELECT * FROM categories WHERE id = '28'
162 0.0002 0.00015521049499512
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
163 0.0002 0.00016117095947266
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
164 0.0002 0.00015783309936523
SELECT id FROM categories WHERE parent_id = '28'
165 0.0002 0.00017094612121582
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 
166 0.0002 0.00015902519226074
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 
167 0.0002 0.0001528263092041
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
168 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
169 0.0002 0.00024795532226562
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
170 0.0002 0.00018000602722168
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
171 0.0002 0.00017404556274414
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
172 0.0002 0.00023508071899414
SELECT * FROM pages WHERE id = 38
173 0.0047 0.0047321319580078
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
174 0.0005 0.00047421455383301
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:1632134834;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"779|amazon\";i:5;s:10:\"777|amazon\";}}' WHERE id = '160'
175 0.0004 0.00040888786315918
SELECT * FROM products WHERE id = 790
176 0.0005 0.00049614906311035
SELECT * FROM products WHERE id = 788
177 0.0005 0.00049400329589844
SELECT * FROM products WHERE id = 787
178 0.0005 0.00051116943359375
SELECT * FROM products WHERE id = 1287
179 0.0005 0.00051116943359375
SELECT * FROM products WHERE id = 779
180 0.0005 0.00049901008605957
SELECT * FROM products WHERE id = 777
181 0.0006 0.00063896179199219
SELECT * FROM products WHERE id = '790'
182 0.0005 0.00049400329589844
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
183 0.0002 0.00024890899658203
SELECT * FROM product_image_select WHERE product_id = '790'
184 0.0002 0.00024104118347168
SELECT * FROM productcustomimages WHERE product_id = '790'
185 0.0002 0.00022602081298828
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
186 0.0004 0.00042104721069336
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0003 0.00028896331787109
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0003 0.00032711029052734
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0025 0.0024778842926025
SELECT * FROM products WHERE id = '788'
190 0.0002 0.00023698806762695
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
191 0.0002 0.00023603439331055
SELECT * FROM product_image_select WHERE product_id = '788'
192 0.0002 0.00020813941955566
SELECT * FROM productcustomimages WHERE product_id = '788'
193 0.0002 0.00017905235290527
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
194 0.0004 0.00038814544677734
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0003 0.00027298927307129
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0002 0.00023794174194336
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0004 0.00042104721069336
SELECT * FROM products WHERE id = '787'
198 0.0002 0.00019311904907227
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
199 0.0002 0.00018310546875
SELECT * FROM product_image_select WHERE product_id = '787'
200 0.0002 0.00018692016601562
SELECT * FROM productcustomimages WHERE product_id = '787'
201 0.0003 0.00029706954956055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
202 0.0002 0.00023412704467773
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0002 0.00020003318786621
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0004 0.00041699409484863
SELECT * FROM products WHERE id = '1287'
206 0.0005 0.00045394897460938
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
207 0.0003 0.00025796890258789
SELECT * FROM product_image_select WHERE product_id = '1287'
208 0.0002 0.00020503997802734
SELECT * FROM productcustomimages WHERE product_id = '1287'
209 0.0002 0.00021910667419434
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
210 0.0002 0.00024819374084473
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0002 0.0002281665802002
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0003 0.00033712387084961
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0004 0.00042486190795898
SELECT * FROM products WHERE id = '779'
214 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
215 0.0002 0.00019001960754395
SELECT * FROM product_image_select WHERE product_id = '779'
216 0.0002 0.00018501281738281
SELECT * FROM productcustomimages WHERE product_id = '779'
217 0.0002 0.00017786026000977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
218 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0002 0.00020194053649902
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0007 0.00072097778320312
SELECT * FROM products WHERE id = '777'
222 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
223 0.0002 0.00019288063049316
SELECT * FROM product_image_select WHERE product_id = '777'
224 0.0002 0.00016880035400391
SELECT * FROM productcustomimages WHERE product_id = '777'
225 0.0002 0.00018596649169922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
226 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0003 0.00033402442932129
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0003 0.00026798248291016
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
230 0.0003 0.00028395652770996
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
231 0.0006 0.0006098747253418
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
232 0.0004 0.00037097930908203
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0003 0.00029587745666504
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
234 0.0005 0.00048685073852539
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0005 0.00046610832214355
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
236 0.0004 0.00036001205444336
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'