Lipton Thé Vert Classique x30 Sachets 40g

Lipton Thé Vert Classique x30 Sachets 40g
Lipton Thé Vert Classique x30 Sachets 40g Lipton Thé Vert Classique x30 Sachets 40g Lipton Thé Vert Classique x30 Sachets 40g Lipton Thé Vert Classique x30 Sachets 40g Lipton Thé Vert Classique x30 Sachets 40g (cliquez sur les images pour élargir)
€8,90
Le prix et la disponibilité du produit sont corrects en date du 2021-07-21 01:42:08 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
1.8148210048676 233 0.1150 0


No Amazon API Requests Made.

Total time 1.8148210048676 seconds

Number Time From Start Name Description
1 1.2336070537567 Initialise Initialise FSB Function
2 1.2674341201782 App Controller Start Start of the App controller (called before the controller of every page)
3 1.2706391811371 Start of getCategoryListByGroup Function Before first category groups query
4 1.2709100246429 After initial query Before first category groups query
5 1.2709121704102 Get Category List for Group Before the call to getCategoryList function
6 1.2709159851074 Start of GetCategoryList function Start of the function
7 1.2709209918976 Before getting categories Query to get specific category list
8 1.271252155304 After getting categories Query to get specific category list
9 1.2712540626526 Before getting category custom Before call to function getCategoryCustom
10 1.2927770614624 After getting category custom After call to function getCategoryCustom
11 1.2927811145782 Before getting category custom Before call to function getCategoryCustom
12 1.2947430610657 After getting category custom After call to function getCategoryCustom
13 1.2947452068329 Before getting category custom Before call to function getCategoryCustom
14 1.299751996994 After getting category custom After call to function getCategoryCustom
15 1.2997591495514 Before getting category custom Before call to function getCategoryCustom
16 1.3024241924286 After getting category custom After call to function getCategoryCustom
17 1.3024270534515 Before getting category custom Before call to function getCategoryCustom
18 1.305361032486 After getting category custom After call to function getCategoryCustom
19 1.3053631782532 Before getting category custom Before call to function getCategoryCustom
20 1.3080589771271 After getting category custom After call to function getCategoryCustom
21 1.3080620765686 End of GetCategoryList function End of the function
22 1.3080689907074 End of getCategoryListByGroup Function Before return()
23 1.3131711483002 App Controller End End of the App controller (called before the controller of every page)
24 1.3138651847839 Product Start Start of the product info controller
25 1.4879891872406 Cache file not found Starting get product details
26 1.5044941902161 Related products Start getting related products if enabled
27 1.5044960975647 Related Products Start Before the related products are found
28 1.5044980049133 Related Products Keywords Before the related product keywords are found
29 1.5045030117035 Create Keyword List Function Start of function
30 1.5045981407166 Create Keyword List Function After looping provided content - 18 keywords found
31 1.5055770874023 Create Keyword List Function After looping initial keyword list - 16 keywords remaining
32 1.5055861473083 Create Keyword List Function After reducing keyword list
33 1.5056581497192 Create Keyword List Function After selecting by scoring keywords
34 1.5056641101837 Create Keyword List Function After final loop of keywords
35 1.5056669712067 Related Products Keywords After the related product keywords are found
36 1.5215351581573 Related Products End After the related products are found
37 1.5289161205292 Product End End of the product info controller (Product Info)
38 1.5299360752106 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 1.5304741859436 Before Get Options Before the call to getOptions in the tpl class
40 1.5590710639954 After Get Options After the call to getOptions in the tpl class
41 1.5592970848083 App_after Controller End End of the App_after controller (called after the controller of every page)
42 1.5593461990356 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 1.7563021183014 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 1.7563111782074 Product Info: Before Template Display Before the template is displayed
45 1.8147749900818 Product Info: After Template Display After the template is displayed
46 1.8147950172424 Finalizing debug Before the debug is output to the page.
47 1.8148200511932 End of App This is the end of the app logging, final timestamp


Query Debug - 233 Database Queries. Total time 0.1150 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.0007469654083252
SELECT parameter, value FROM parameters
2 0.0012 0.0012049674987793
SELECT * FROM `bad_bots`
3 0.0004 0.00035786628723145
SET time_zone = 'Europe/London'
4 0.0005 0.00045990943908691
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0020 0.0020229816436768
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.205.192.201\";}'
6 0.0013 0.0012991428375244
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1628126550'
7 0.0004 0.0003821849822998
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00023508071899414
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0002 0.00020813941955566
SELECT id FROM pages WHERE pagename = 'lipton-the-vert-classique-x30-sachets-40g' LIMIT 1
10 0.0006 0.00056815147399902
SELECT id FROM products WHERE pagename = 'lipton-the-vert-classique-x30-sachets-40g' AND hidden = 0 LIMIT 1
11 0.0013 0.0013461112976074
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0010 0.00095820426940918
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0003 0.0002751350402832
SELECT * FROM pages WHERE pagename = 'lipton-the-vert-classique-x30-sachets-40g'
14 0.0003 0.00025701522827148
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0003 0.00031185150146484
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0129 0.012857913970947
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.00028204917907715
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.00019407272338867
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '26'
20 0.0070 0.0069708824157715
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.00025010108947754
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.00020194053649902
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.00020289421081543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00019383430480957
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.0002129077911377
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.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 = 27
27 0.0002 0.00021195411682129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00018906593322754
SELECT id FROM categories WHERE parent_id = '27'
29 0.0002 0.00022792816162109
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.0002 0.00022721290588379
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0002 0.00021815299987793
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.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00020098686218262
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0016999244689941
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.0002 0.00020980834960938
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.0002 0.0001990795135498
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00023913383483887
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0017259120941162
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.00024509429931641
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.0002 0.00018692016601562
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0002 0.00019288063049316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00020289421081543
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00056099891662598
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0002 0.0001981258392334
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.00019621849060059
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00022721290588379
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00057101249694824
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.00020098686218262
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0002 0.00020194053649902
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.00019311904907227
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00022101402282715
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00055289268493652
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.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
54 0.0003 0.00026583671569824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00056600570678711
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.0002 0.00021982192993164
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.00023603439331055
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.0003 0.00031805038452148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00021791458129883
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00058507919311523
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.00022602081298828
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.00022721290588379
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00022482872009277
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00060009956359863
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.00018501281738281
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.00019311904907227
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.0002 0.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00018405914306641
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00023007392883301
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00029611587524414
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0002 0.00024294853210449
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.00020980834960938
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00048112869262695
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00055599212646484
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.0001990795135498
SELECT * FROM ipgeocountries WHERE INET_ATON('18.205.192.201') >= INET_ATON(ip_start) AND INET_ATON('18.205.192.201') <= INET_ATON(ip_end)
77 0.0003 0.00026488304138184
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.0001990795135498
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0007 0.00069999694824219
SELECT * FROM products WHERE pagename = 'lipton-the-vert-classique-x30-sachets-40g'
80 0.0006 0.00063800811767578
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1250
81 0.0004 0.00042510032653809
SELECT * FROM manufacturers WHERE id = '220'
82 0.0011 0.0011038780212402
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220'
83 0.0002 0.00024199485778809
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '220' LIMIT 1
84 0.0014 0.0013821125030518
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
85 0.0025 0.0025310516357422
SELECT * FROM productimages WHERE product_id = '1144' ORDER BY sortorder ASC
86 0.0002 0.00024104118347168
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220'
87 0.0008 0.00084400177001953
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 
88 0.0002 0.00024700164794922
SELECT * FROM manufacturerimages WHERE manufacturer_id = '220'
89 0.0003 0.00034022331237793
SELECT category_id FROM products_categories WHERE product_id = '1250'
90 0.0003 0.0002899169921875
SELECT * FROM categories WHERE id = '28'
91 0.0028 0.0027799606323242
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.0002 0.00021100044250488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
93 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '28'
94 0.0016 0.0015959739685059
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.0002 0.00020289421081543
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.00017404556274414
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.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
98 0.0002 0.00022792816162109
SELECT * FROM productimages WHERE product_id = '1250' ORDER BY sortorder ASC
99 0.0002 0.00019216537475586
SELECT * FROM product_image_select WHERE product_id = '1250'
100 0.0002 0.00018906593322754
SELECT * FROM productcustomimages WHERE product_id = '1250'
101 0.0002 0.00022411346435547
SELECT * FROM productfeeds WHERE product_id = '1250' ORDER BY item_date DESC
102 0.0002 0.00022387504577637
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1250' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0002 0.0001978874206543
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1250' AND t.hidden = 0 AND display_product = 1
104 0.0002 0.00022292137145996
SELECT * FROM productamazoncontent WHERE product_id = '1250'
105 0.0003 0.00026607513427734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1250' AND a.name = n.originalname
106 0.0002 0.00020503997802734
SELECT * FROM productoffers WHERE product_id = '1250' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = '1250' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = 1250
                ORDER BY price ASC LIMIT 1
109 0.0002 0.0001978874206543
SELECT value FROM productattributes
                WHERE product_id = '1250'
                AND name = 'ListPriceAmount'
110 0.0002 0.00018715858459473
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
111 0.0085 0.0085139274597168
SELECT *, MATCH (description, title) AGAINST ('classique x30 sachets' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('classique x30 sachets' IN BOOLEAN MODE) AND 1250 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
112 0.0004 0.00039792060852051
SELECT *, MATCH (description, title) AGAINST ('classique x30 sachets' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('classique x30 sachets' IN BOOLEAN MODE) AND 1250 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
113 0.0005 0.00046014785766602
SELECT *, MATCH (description, title) AGAINST ('classique x30 sachets' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('classique x30 sachets' IN BOOLEAN MODE) AND 1250 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0003 0.00032210350036621
SELECT * FROM productimages WHERE product_id = '866' ORDER BY sortorder ASC
115 0.0003 0.00026988983154297
SELECT * FROM product_image_select WHERE product_id = '866'
116 0.0002 0.0001988410949707
SELECT * FROM productcustomimages WHERE product_id = '866'
117 0.0003 0.00029611587524414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '866' AND a.name = n.originalname
118 0.0002 0.00022292137145996
SELECT * FROM productoffers WHERE product_id = '866' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0002 0.0002291202545166
SELECT * FROM productoffers
                WHERE product_id = '866' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0003 0.00032186508178711
SELECT value FROM productattributes WHERE product_id = '866' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0004 0.00036382675170898
SELECT * FROM productimages WHERE product_id = '4917' ORDER BY sortorder ASC
122 0.0003 0.00028491020202637
SELECT * FROM product_image_select WHERE product_id = '4917'
123 0.0002 0.00020098686218262
SELECT * FROM productcustomimages WHERE product_id = '4917'
124 0.0003 0.00027298927307129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4917' AND a.name = n.originalname
125 0.0002 0.00020694732666016
SELECT * FROM productoffers WHERE product_id = '4917' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '4917' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0002 0.00022101402282715
SELECT value FROM productattributes WHERE product_id = '4917' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0003 0.00028014183044434
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
129 0.0002 0.00019121170043945
SELECT * FROM product_image_select WHERE product_id = '858'
130 0.0002 0.00022602081298828
SELECT * FROM productcustomimages WHERE product_id = '858'
131 0.0004 0.00037789344787598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
132 0.0003 0.0003211498260498
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00036191940307617
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0003 0.00032901763916016
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0005 0.00045609474182129
SELECT id,asin FROM products WHERE parent_id = 1250
136 0.0002 0.00021505355834961
SELECT category_id FROM products_categories WHERE product_id = '1250'
137 0.0002 0.00024700164794922
SELECT * FROM categories WHERE id = '28'
138 0.0002 0.00017189979553223
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
139 0.0003 0.00027704238891602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
140 0.0002 0.00016903877258301
SELECT id FROM categories WHERE parent_id = '28'
141 0.0002 0.00019407272338867
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 
142 0.0002 0.00017905235290527
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 
143 0.0002 0.00019693374633789
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
144 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
145 0.0002 0.00022315979003906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1250' AND a.name = n.originalname
146 0.0002 0.0002131462097168
SELECT * FROM productoffers WHERE product_id = '1250' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '1250' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0003 0.00025582313537598
SELECT * FROM productoffers
                WHERE product_id = 1250
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00023388862609863
SELECT value FROM productattributes
                WHERE product_id = '1250'
                AND name = 'ListPriceAmount'
150 0.0006 0.00059890747070312
SELECT * FROM products WHERE id = '1250'
151 0.0003 0.00026822090148926
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1250' AND a.name = n.originalname
152 0.0003 0.00026297569274902
SELECT * FROM productoffers WHERE product_id = '1250' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '1250' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = 1250
                ORDER BY price ASC LIMIT 1
155 0.0002 0.0001680850982666
SELECT value FROM productattributes
                WHERE product_id = '1250'
                AND name = 'ListPriceAmount'
156 0.0002 0.0001678466796875
SELECT category_id FROM products_categories WHERE product_id = '1250' AND prod_type = 'amz'
157 0.0002 0.00017404556274414
SELECT parent_id FROM categories WHERE id = '28'
158 0.0002 0.00019693374633789
SELECT * FROM categories WHERE id = '28'
159 0.0002 0.00017189979553223
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
160 0.0002 0.00016021728515625
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
161 0.0002 0.00017690658569336
SELECT id FROM categories WHERE parent_id = '28'
162 0.0002 0.00018501281738281
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 
163 0.0002 0.00018310546875
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 
164 0.0002 0.00018501281738281
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
165 0.0002 0.0001990795135498
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
166 0.0003 0.00026512145996094
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
167 0.0002 0.00023889541625977
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
168 0.0002 0.00020599365234375
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
169 0.0003 0.0003349781036377
SELECT * FROM pages WHERE id = 38
170 0.0039 0.0038912296295166
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
171 0.0005 0.00046300888061523
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:1628126550;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
172 0.0005 0.00048208236694336
SELECT * FROM products WHERE id = 790
173 0.0006 0.00058817863464355
SELECT * FROM products WHERE id = 788
174 0.0006 0.00062823295593262
SELECT * FROM products WHERE id = 787
175 0.0006 0.00059390068054199
SELECT * FROM products WHERE id = 1287
176 0.0006 0.00057482719421387
SELECT * FROM products WHERE id = 777
177 0.0006 0.00063896179199219
SELECT * FROM products WHERE id = 776
178 0.0006 0.00059390068054199
SELECT * FROM products WHERE id = '790'
179 0.0005 0.00046682357788086
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
180 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '790'
181 0.0002 0.00020098686218262
SELECT * FROM productcustomimages WHERE product_id = '790'
182 0.0003 0.0002601146697998
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
183 0.0002 0.00022006034851074
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0003 0.00026202201843262
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0002 0.00023317337036133
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0004 0.00039291381835938
SELECT * FROM products WHERE id = '788'
187 0.0003 0.00025081634521484
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
188 0.0003 0.00025296211242676
SELECT * FROM product_image_select WHERE product_id = '788'
189 0.0002 0.0001838207244873
SELECT * FROM productcustomimages WHERE product_id = '788'
190 0.0002 0.00019693374633789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
191 0.0002 0.0002281665802002
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
192 0.0003 0.00028610229492188
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
193 0.0002 0.00021886825561523
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
194 0.0004 0.00040698051452637
SELECT * FROM products WHERE id = '787'
195 0.0002 0.00022101402282715
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
196 0.0003 0.0003199577331543
SELECT * FROM product_image_select WHERE product_id = '787'
197 0.0002 0.0002129077911377
SELECT * FROM productcustomimages WHERE product_id = '787'
198 0.0002 0.00024700164794922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
199 0.0002 0.00022292137145996
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0002 0.00020599365234375
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0005 0.00046801567077637
SELECT * FROM products WHERE id = '1287'
203 0.0004 0.00044512748718262
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
204 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '1287'
205 0.0002 0.00020194053649902
SELECT * FROM productcustomimages WHERE product_id = '1287'
206 0.0002 0.00024795532226562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
207 0.0002 0.00022602081298828
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0003 0.00033092498779297
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0004 0.00044107437133789
SELECT * FROM products WHERE id = '777'
211 0.0003 0.00025701522827148
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
212 0.0003 0.00025296211242676
SELECT * FROM product_image_select WHERE product_id = '777'
213 0.0002 0.00020790100097656
SELECT * FROM productcustomimages WHERE product_id = '777'
214 0.0003 0.00025010108947754
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
215 0.0002 0.00023102760314941
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0004 0.00038719177246094
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0003 0.00025415420532227
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0005 0.00048708915710449
SELECT * FROM products WHERE id = '776'
219 0.0003 0.00026082992553711
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
220 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '776'
221 0.0002 0.0002131462097168
SELECT * FROM productcustomimages WHERE product_id = '776'
222 0.0002 0.0002448558807373
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
223 0.0002 0.0002131462097168
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0003 0.00025701522827148
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0003 0.0002751350402832
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0004 0.00037598609924316
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
227 0.0005 0.00048398971557617
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
228 0.0009 0.00092911720275879
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
229 0.0005 0.00048995018005371
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
230 0.0005 0.00053787231445312
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
231 0.0004 0.00041007995605469
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
232 0.0006 0.00055313110351562
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
233 0.0003 0.00034523010253906
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'