Thé Dammann Frères - Thé Rooibos Citrus - 24 enveloppes design cristal

Thé Dammann Frères - Thé Rooibos Citrus - 24 enveloppes design cristal
Thé Dammann Frères - Thé Rooibos Citrus - 24 enveloppes design cristal (cliquez sur les images pour élargir)
€26,80
Le prix et la disponibilité du produit sont corrects en date du 2021-07-21 03:55:45 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é DAMMANN frères - infusión Rooibos, - 24 enveloppes en verre
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.5689580440521 235 0.1265 0


No Amazon API Requests Made.

Total time 1.5689580440521 seconds

Number Time From Start Name Description
1 0.92972588539124 Initialise Initialise FSB Function
2 0.93347501754761 App Controller Start Start of the App controller (called before the controller of every page)
3 0.9370059967041 Start of getCategoryListByGroup Function Before first category groups query
4 0.93744087219238 After initial query Before first category groups query
5 0.93744301795959 Get Category List for Group Before the call to getCategoryList function
6 0.93744707107544 Start of GetCategoryList function Start of the function
7 0.93744993209839 Before getting categories Query to get specific category list
8 0.9379608631134 After getting categories Query to get specific category list
9 0.93796300888062 Before getting category custom Before call to function getCategoryCustom
10 0.94093894958496 After getting category custom After call to function getCategoryCustom
11 0.94095993041992 Before getting category custom Before call to function getCategoryCustom
12 0.95360088348389 After getting category custom After call to function getCategoryCustom
13 0.95360398292542 Before getting category custom Before call to function getCategoryCustom
14 0.96070289611816 After getting category custom After call to function getCategoryCustom
15 0.96070599555969 Before getting category custom Before call to function getCategoryCustom
16 0.96462392807007 After getting category custom After call to function getCategoryCustom
17 0.96462607383728 Before getting category custom Before call to function getCategoryCustom
18 0.96764588356018 After getting category custom After call to function getCategoryCustom
19 0.96764802932739 Before getting category custom Before call to function getCategoryCustom
20 0.97074389457703 After getting category custom After call to function getCategoryCustom
21 0.97074604034424 End of GetCategoryList function End of the function
22 0.97075295448303 End of getCategoryListByGroup Function Before return()
23 0.97648787498474 App Controller End End of the App controller (called before the controller of every page)
24 0.99544286727905 Product Start Start of the product info controller
25 1.0946929454803 Cache file not found Starting get product details
26 1.1234519481659 Related products Start getting related products if enabled
27 1.1234550476074 Related Products Start Before the related products are found
28 1.1234569549561 Related Products Keywords Before the related product keywords are found
29 1.1234629154205 Create Keyword List Function Start of function
30 1.123507976532 Create Keyword List Function After looping provided content - 18 keywords found
31 1.1245219707489 Create Keyword List Function After looping initial keyword list - 18 keywords remaining
32 1.1245288848877 Create Keyword List Function After reducing keyword list
33 1.1245610713959 Create Keyword List Function After selecting by scoring keywords
34 1.1245648860931 Create Keyword List Function After final loop of keywords
35 1.1245670318604 Related Products Keywords After the related product keywords are found
36 1.1389880180359 Related Products End After the related products are found
37 1.1464059352875 Product End End of the product info controller (Product Info)
38 1.147449016571 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 1.1478960514069 Before Get Options Before the call to getOptions in the tpl class
40 1.1867709159851 After Get Options After the call to getOptions in the tpl class
41 1.1868698596954 App_after Controller End End of the App_after controller (called after the controller of every page)
42 1.1869058609009 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 1.4832348823547 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 1.4832420349121 Product Info: Before Template Display Before the template is displayed
45 1.5689148902893 Product Info: After Template Display After the template is displayed
46 1.5689289569855 Finalizing debug Before the debug is output to the page.
47 1.5689558982849 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1265 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00058603286743164
SELECT parameter, value FROM parameters
2 0.0009 0.00089216232299805
SELECT * FROM `bad_bots`
3 0.0002 0.00021004676818848
SET time_zone = 'Europe/London'
4 0.0002 0.00024700164794922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0014 0.0013871192932129
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.205.192.201\";}'
6 0.0007 0.00070595741271973
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1628126368'
7 0.0005 0.00048589706420898
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00045394897460938
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0012 0.0011570453643799
SELECT id FROM pages WHERE pagename = 'the-dammann-frres-the-rooibos-citrus-24enveloppes-design-cristal' LIMIT 1
10 0.0007 0.00071310997009277
SELECT id FROM products WHERE pagename = 'the-dammann-frres-the-rooibos-citrus-24enveloppes-design-cristal' AND hidden = 0 LIMIT 1
11 0.0013 0.0012779235839844
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0011 0.0011308193206787
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0007 0.00071406364440918
SELECT * FROM pages WHERE pagename = 'the-dammann-frres-the-rooibos-citrus-24enveloppes-design-cristal'
14 0.0004 0.00042200088500977
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00048995018005371
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0005 0.00046610832214355
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.0005 0.00047397613525391
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.0005 0.00048184394836426
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.00023388862609863
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.0002 0.00023102760314941
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.00023317337036133
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.00021505355834961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00025105476379395
SELECT * FROM categorygroups WHERE id = '1'
25 0.0061 0.0060858726501465
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.00030994415283203
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.00024700164794922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00027990341186523
SELECT id FROM categories WHERE parent_id = '27'
29 0.0046 0.0046210289001465
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.00031900405883789
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.00022196769714355
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.00021791458129883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00020694732666016
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0017459392547607
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.0004 0.00040316581726074
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.00023102760314941
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '28'
38 0.0030 0.0030100345611572
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.0003 0.00031113624572754
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.00039410591125488
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.0004 0.00042605400085449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00024890899658203
SELECT * FROM categorygroups WHERE id = '1'
43 0.0009 0.00088906288146973
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.0005 0.0005340576171875
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.0004 0.00036406517028809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00034999847412109
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00069880485534668
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0003 0.00029802322387695
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.00020408630371094
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.0003 0.00025391578674316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00022506713867188
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.0005500316619873
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.00021505355834961
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.0002 0.0001978874206543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00020217895507812
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00059103965759277
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.00021886825561523
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.0004 0.00038814544677734
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.00033187866210938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00022387504577637
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00066900253295898
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.0003 0.00029397010803223
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.0003 0.00025701522827148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00065708160400391
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.00024294853210449
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.0001990795135498
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.00021791458129883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00025701522827148
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.00029206275939941
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00028800964355469
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.0005 0.00047492980957031
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0007 0.00071883201599121
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0007 0.00068902969360352
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00027680397033691
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.0002 0.00021195411682129
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00022602081298828
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.0005958080291748
SELECT * FROM products WHERE pagename = 'the-dammann-frres-the-rooibos-citrus-24enveloppes-design-cristal'
80 0.0008 0.00084090232849121
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4758
81 0.0008 0.00078988075256348
SELECT * FROM manufacturers WHERE id = '632'
82 0.0010 0.0009608268737793
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '632'
83 0.0005 0.0004580020904541
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '632' LIMIT 1
84 0.0009 0.00093317031860352
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '632' ORDER BY RAND() LIMIT 1
85 0.0019 0.001884937286377
SELECT * FROM productimages WHERE product_id = '4865' ORDER BY sortorder ASC
86 0.0004 0.00040793418884277
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '632'
87 0.0008 0.00077104568481445
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '632'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.00043702125549316
SELECT * FROM manufacturerimages WHERE manufacturer_id = '632'
89 0.0006 0.00056195259094238
SELECT category_id FROM products_categories WHERE product_id = '4758'
90 0.0004 0.00036406517028809
SELECT * FROM categories WHERE id = '27'
91 0.0071 0.0070779323577881
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
92 0.0004 0.00036716461181641
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '27'
94 0.0041 0.004141092300415
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
95 0.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 (27)
				  AND p.disabled = 0 
96 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
97 0.0002 0.00020098686218262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0010 0.00095200538635254
SELECT * FROM productimages WHERE product_id = '4758' ORDER BY sortorder ASC
99 0.0004 0.0003969669342041
SELECT * FROM product_image_select WHERE product_id = '4758'
100 0.0005 0.00048995018005371
SELECT * FROM productcustomimages WHERE product_id = '4758'
101 0.0003 0.00033211708068848
SELECT * FROM productfeeds WHERE product_id = '4758' ORDER BY item_date DESC
102 0.0012 0.0011711120605469
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4758' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0005 0.00054383277893066
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4758' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00041699409484863
SELECT * FROM productamazoncontent WHERE product_id = '4758'
105 0.0009 0.00093698501586914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4758' AND a.name = n.originalname
106 0.0005 0.00046110153198242
SELECT * FROM productoffers WHERE product_id = '4758' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0004 0.00039005279541016
SELECT * FROM productoffers
                WHERE product_id = '4758' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0005 0.0004889965057373
SELECT * FROM productoffers
                WHERE product_id = 4758
                ORDER BY price ASC LIMIT 1
109 0.0005 0.00046515464782715
SELECT value FROM productattributes
                WHERE product_id = '4758'
                AND name = 'ListPriceAmount'
110 0.0005 0.00052380561828613
SELECT value FROM productattributes WHERE product_id = '4758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0003 0.00034189224243164
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
112 0.0080 0.0080461502075195
SELECT *, MATCH (description, title) AGAINST ('frres-thé rooibos citrus-24enveloppes' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('frres-thé rooibos citrus-24enveloppes' IN BOOLEAN MODE) AND 4758 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00057005882263184
SELECT *, MATCH (description, title) AGAINST ('frres-thé rooibos citrus-24enveloppes' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('frres-thé rooibos citrus-24enveloppes' IN BOOLEAN MODE) AND 4758 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0004 0.00037884712219238
SELECT *, MATCH (description, title) AGAINST ('frres-thé rooibos citrus-24enveloppes' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('frres-thé rooibos citrus-24enveloppes' IN BOOLEAN MODE) AND 4758 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0003 0.00032615661621094
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
116 0.0002 0.00019478797912598
SELECT * FROM product_image_select WHERE product_id = '858'
117 0.0002 0.00018906593322754
SELECT * FROM productcustomimages WHERE product_id = '858'
118 0.0002 0.0001988410949707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
119 0.0002 0.00020790100097656
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0003 0.00028014183044434
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0003 0.00026106834411621
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
123 0.0002 0.00018405914306641
SELECT * FROM product_image_select WHERE product_id = '862'
124 0.0002 0.0002138614654541
SELECT * FROM productcustomimages WHERE product_id = '862'
125 0.0002 0.00020694732666016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
126 0.0002 0.0002129077911377
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0003 0.00030994415283203
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0003 0.00027894973754883
SELECT * FROM productimages WHERE product_id = '929' ORDER BY sortorder ASC
130 0.0002 0.00017309188842773
SELECT * FROM product_image_select WHERE product_id = '929'
131 0.0002 0.00018405914306641
SELECT * FROM productcustomimages WHERE product_id = '929'
132 0.0002 0.00020289421081543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '929' AND a.name = n.originalname
133 0.0002 0.00022315979003906
SELECT * FROM productoffers WHERE product_id = '929' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '929' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0002 0.00020194053649902
SELECT value FROM productattributes WHERE product_id = '929' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0003 0.00029897689819336
SELECT id,asin FROM products WHERE parent_id = 4758
137 0.0002 0.00023818016052246
SELECT category_id FROM products_categories WHERE product_id = '4758'
138 0.0003 0.00026893615722656
SELECT * FROM categories WHERE id = '27'
139 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 = 27
140 0.0002 0.00017714500427246
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '27'
142 0.0002 0.00018596649169922
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 
143 0.0002 0.00020790100097656
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 
144 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
145 0.0002 0.00015377998352051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0002 0.00018000602722168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4758' AND a.name = n.originalname
147 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '4758' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '4758' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0003 0.00025415420532227
SELECT * FROM productoffers
                WHERE product_id = 4758
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00019001960754395
SELECT value FROM productattributes
                WHERE product_id = '4758'
                AND name = 'ListPriceAmount'
151 0.0005 0.00052618980407715
SELECT * FROM products WHERE id = '4758'
152 0.0002 0.0001828670501709
SELECT value FROM productattributes WHERE product_id = '4758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0002 0.00019598007202148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4758' AND a.name = n.originalname
154 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '4758' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '4758' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0003 0.00034284591674805
SELECT * FROM productoffers
                WHERE product_id = 4758
                ORDER BY price ASC LIMIT 1
157 0.0003 0.00028204917907715
SELECT value FROM productattributes
                WHERE product_id = '4758'
                AND name = 'ListPriceAmount'
158 0.0003 0.00031089782714844
SELECT category_id FROM products_categories WHERE product_id = '4758' AND prod_type = 'amz'
159 0.0002 0.0001828670501709
SELECT parent_id FROM categories WHERE id = '27'
160 0.0002 0.0002131462097168
SELECT * FROM categories WHERE id = '27'
161 0.0002 0.00018000602722168
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
162 0.0002 0.00021815299987793
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0002 0.00019097328186035
SELECT id FROM categories WHERE parent_id = '27'
164 0.0002 0.00018000602722168
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 
165 0.0002 0.00017309188842773
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 
166 0.0002 0.00016999244689941
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
167 0.0002 0.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0002 0.00024986267089844
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0002 0.00017213821411133
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0002 0.00020885467529297
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0004 0.00040006637573242
SELECT * FROM pages WHERE id = 38
172 0.0035 0.0034511089324951
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
173 0.0005 0.00046992301940918
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:1628126369;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'
174 0.0005 0.00052809715270996
SELECT * FROM products WHERE id = 790
175 0.0006 0.00058197975158691
SELECT * FROM products WHERE id = 788
176 0.0007 0.00065398216247559
SELECT * FROM products WHERE id = 787
177 0.0006 0.00060200691223145
SELECT * FROM products WHERE id = 1287
178 0.0006 0.00056695938110352
SELECT * FROM products WHERE id = 777
179 0.0005 0.00049400329589844
SELECT * FROM products WHERE id = 776
180 0.0006 0.00057697296142578
SELECT * FROM products WHERE id = '790'
181 0.0005 0.00050806999206543
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
182 0.0002 0.0002281665802002
SELECT * FROM product_image_select WHERE product_id = '790'
183 0.0002 0.00022196769714355
SELECT * FROM productcustomimages WHERE product_id = '790'
184 0.0003 0.00031280517578125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
185 0.0003 0.00029301643371582
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0003 0.00030398368835449
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0004 0.00043201446533203
SELECT * FROM products WHERE id = '788'
189 0.0003 0.00026392936706543
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0003 0.00025510787963867
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0002 0.00017118453979492
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0002 0.00021910667419434
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
193 0.0003 0.00027704238891602
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0002 0.00023508071899414
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0002 0.00023198127746582
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0005 0.00047802925109863
SELECT * FROM products WHERE id = '787'
197 0.0002 0.00022196769714355
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0002 0.00021481513977051
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0003 0.00030112266540527
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
201 0.0002 0.00023293495178223
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0003 0.00028395652770996
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0003 0.00028896331787109
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0006 0.00058817863464355
SELECT * FROM products WHERE id = '1287'
205 0.0006 0.00055098533630371
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
206 0.0003 0.00033283233642578
SELECT * FROM product_image_select WHERE product_id = '1287'
207 0.0005 0.00048398971557617
SELECT * FROM productcustomimages WHERE product_id = '1287'
208 0.0005 0.00046205520629883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
209 0.0004 0.00042200088500977
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0003 0.00034785270690918
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0003 0.00033378601074219
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0007 0.00065207481384277
SELECT * FROM products WHERE id = '777'
213 0.0003 0.00034403800964355
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
214 0.0004 0.00042891502380371
SELECT * FROM product_image_select WHERE product_id = '777'
215 0.0005 0.00045490264892578
SELECT * FROM productcustomimages WHERE product_id = '777'
216 0.0005 0.00050497055053711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
217 0.0004 0.00043797492980957
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0003 0.00030994415283203
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0003 0.00031900405883789
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0007 0.00069594383239746
SELECT * FROM products WHERE id = '776'
221 0.0004 0.00044703483581543
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
222 0.0004 0.00035691261291504
SELECT * FROM product_image_select WHERE product_id = '776'
223 0.0003 0.00034403800964355
SELECT * FROM productcustomimages WHERE product_id = '776'
224 0.0005 0.00050806999206543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
225 0.0004 0.00042891502380371
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.0003361701965332
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0002 0.00020194053649902
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0005 0.0004889965057373
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0005 0.00046610832214355
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0009 0.00094103813171387
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0005 0.00049209594726562
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0005 0.00049018859863281
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0006 0.00056290626525879
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0004 0.00038504600524902
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0005 0.00053691864013672
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'