Dammann Frères - Rooibos l'Oriental-100gr boite

Dammann Frères - Rooibos l'Oriental-100gr boite
Dammann Frères - Rooibos l'Oriental-100gr boite (cliquez sur les images pour élargir)
€19,85
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-09-11 07:40:54 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

Dammann Frères - Rooibos l'Oriental -100gr boite
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.86010003089905 240 0.1399 0


No Amazon API Requests Made.

Total time 0.86010003089905 seconds

Number Time From Start Name Description
1 0.67193007469177 Initialise Initialise FSB Function
2 0.67399597167969 App Controller Start Start of the App controller (called before the controller of every page)
3 0.67790198326111 Start of getCategoryListByGroup Function Before first category groups query
4 0.68003702163696 After initial query Before first category groups query
5 0.6800389289856 Get Category List for Group Before the call to getCategoryList function
6 0.68004202842712 Start of GetCategoryList function Start of the function
7 0.68004608154297 Before getting categories Query to get specific category list
8 0.68049311637878 After getting categories Query to get specific category list
9 0.68049502372742 Before getting category custom Before call to function getCategoryCustom
10 0.70052909851074 After getting category custom After call to function getCategoryCustom
11 0.70053195953369 Before getting category custom Before call to function getCategoryCustom
12 0.71185493469238 After getting category custom After call to function getCategoryCustom
13 0.71185803413391 Before getting category custom Before call to function getCategoryCustom
14 0.71722102165222 After getting category custom After call to function getCategoryCustom
15 0.71722793579102 Before getting category custom Before call to function getCategoryCustom
16 0.71990990638733 After getting category custom After call to function getCategoryCustom
17 0.71991300582886 Before getting category custom Before call to function getCategoryCustom
18 0.72228097915649 After getting category custom After call to function getCategoryCustom
19 0.72228407859802 Before getting category custom Before call to function getCategoryCustom
20 0.72480893135071 After getting category custom After call to function getCategoryCustom
21 0.72481203079224 End of GetCategoryList function End of the function
22 0.72481608390808 End of getCategoryListByGroup Function Before return()
23 0.73075604438782 App Controller End End of the App controller (called before the controller of every page)
24 0.7313129901886 Product Start Start of the product info controller
25 0.74743700027466 Cache file not found Starting get product details
26 0.78035306930542 Related products Start getting related products if enabled
27 0.78035497665405 Related Products Start Before the related products are found
28 0.78035593032837 Related Products Keywords Before the related product keywords are found
29 0.78035998344421 Create Keyword List Function Start of function
30 0.7804319858551 Create Keyword List Function After looping provided content - 12 keywords found
31 0.78097891807556 Create Keyword List Function After looping initial keyword list - 12 keywords remaining
32 0.78098511695862 Create Keyword List Function After reducing keyword list
33 0.78100299835205 Create Keyword List Function After selecting by scoring keywords
34 0.78100609779358 Create Keyword List Function After final loop of keywords
35 0.78100800514221 Related Products Keywords After the related product keywords are found
36 0.79569411277771 Related Products End After the related products are found
37 0.80261898040771 Product End End of the product info controller (Product Info)
38 0.8034679889679 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.80390596389771 Before Get Options Before the call to getOptions in the tpl class
40 0.82941699028015 After Get Options After the call to getOptions in the tpl class
41 0.82953906059265 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.82956600189209 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.84114789962769 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.84115195274353 Product Info: Before Template Display Before the template is displayed
45 0.86006808280945 Product Info: After Template Display After the template is displayed
46 0.86008596420288 Finalizing debug Before the debug is output to the page.
47 0.86009907722473 End of App This is the end of the app logging, final timestamp


Query Debug - 240 Database Queries. Total time 0.1399 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00043916702270508
SELECT parameter, value FROM parameters
2 0.0010 0.001007080078125
SELECT * FROM `bad_bots`
3 0.0003 0.00028896331787109
SET time_zone = 'Europe/London'
4 0.0003 0.00030899047851562
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0023 0.0023269653320312
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.212.116\";}'
6 0.0013 0.0013329982757568
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632139102'
7 0.0004 0.0004420280456543
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00031495094299316
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00046801567077637
SELECT id FROM pages WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite' LIMIT 1
10 0.0006 0.00058984756469727
SELECT id FROM products WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite' AND hidden = 0 LIMIT 1
11 0.0013 0.0013351440429688
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00094890594482422
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0011 0.0010788440704346
SELECT * FROM pages WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite'
14 0.0021 0.0021190643310547
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.0004279613494873
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0104 0.010429859161377
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.00046586990356445
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.0003 0.00031805038452148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00018501281738281
SELECT id FROM categories WHERE parent_id = '26'
20 0.0071 0.0071430206298828
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.00022506713867188
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.0006 0.00064897537231445
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.00023889541625977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00022792816162109
SELECT * FROM categorygroups WHERE id = '1'
25 0.0050 0.0049748420715332
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.0002129077911377
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.0002129077911377
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00020718574523926
SELECT id FROM categories WHERE parent_id = '27'
29 0.0048 0.0047750473022461
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.00022482872009277
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.0001978874206543
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.0002140998840332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00019216537475586
SELECT * FROM categorygroups WHERE id = '1'
34 0.0019 0.0018792152404785
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.00020217895507812
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.00019097328186035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00017809867858887
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0017189979553223
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.00034379959106445
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.0003 0.0002751350402832
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0003 0.0002589225769043
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00020599365234375
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00057697296142578
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.00020313262939453
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.0002129077911377
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.0001828670501709
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00064992904663086
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.00020694732666016
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.00018596649169922
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.00018811225891113
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00017595291137695
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00047492980957031
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.00019001960754395
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.00018310546875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00019097328186035
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00050091743469238
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.00016999244689941
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.00017905235290527
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00020098686218262
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00058698654174805
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.00018906593322754
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.00018191337585449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00017285346984863
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00053811073303223
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.00022506713867188
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.00017213821411133
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00018405914306641
SELECT * FROM categorygroups WHERE id = '1'
70 0.0013 0.0012521743774414
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00030517578125
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.0003359317779541
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.0003 0.0002601146697998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0006 0.00059294700622559
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00057387351989746
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00023412704467773
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)
77 0.0002 0.00020384788513184
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00019502639770508
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.00059390068054199
SELECT * FROM products WHERE pagename = 'dammann-frres-rooibos-loriental-100gr-boite'
80 0.0009 0.00092291831970215
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4814
81 0.0004 0.0003809928894043
SELECT * FROM manufacturers WHERE id = '177'
82 0.0008 0.00077986717224121
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '177'
83 0.0002 0.00020718574523926
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '177' LIMIT 1
84 0.0008 0.00084781646728516
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '177' ORDER BY RAND() LIMIT 1
85 0.0004 0.00040602684020996
SELECT * FROM productimages WHERE product_id = '975' ORDER BY sortorder ASC
86 0.0002 0.00024294853210449
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '177'
87 0.0007 0.00065207481384277
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '177'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0002 0.00022101402282715
SELECT * FROM manufacturerimages WHERE manufacturer_id = '177'
89 0.0004 0.00041699409484863
SELECT category_id FROM products_categories WHERE product_id = '4814'
90 0.0003 0.00028491020202637
SELECT * FROM categories WHERE id = '27'
91 0.0070 0.0069558620452881
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.0002 0.00018501281738281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00017309188842773
SELECT id FROM categories WHERE parent_id = '27'
94 0.0043 0.0043048858642578
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.0002 0.00019502639770508
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
96 0.0002 0.00019216537475586
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0015 0.0014691352844238
SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
99 0.0008 0.00084996223449707
SELECT * FROM product_image_select WHERE product_id = '4814'
100 0.0004 0.00035500526428223
SELECT * FROM productcustomimages WHERE product_id = '4814'
101 0.0003 0.00025010108947754
SELECT * FROM productfeeds WHERE product_id = '4814' ORDER BY item_date DESC
102 0.0013 0.0012741088867188
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0008 0.00078701972961426
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4814' AND t.hidden = 0 AND display_product = 1
104 0.0002 0.00022292137145996
SELECT * FROM tags WHERE id = '1'
105 0.0017 0.001676082611084
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
106 0.0016 0.0016419887542725
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
107 0.0019 0.00187087059021
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
108 0.0003 0.00027799606323242
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
109 0.0008 0.00077199935913086
SELECT * FROM productamazoncontent WHERE product_id = '4814'
110 0.0014 0.0014400482177734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
111 0.0004 0.00044918060302734
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0008 0.00081396102905273
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0004 0.00036311149597168
SELECT * FROM productoffers
                WHERE product_id = 4814
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00043487548828125
SELECT value FROM productattributes
                WHERE product_id = '4814'
                AND name = 'ListPriceAmount'
115 0.0005 0.00048613548278809
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116 0.0002 0.00018692016601562
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
117 0.0081 0.0080749988555908
SELECT *, MATCH (description, title) AGAINST ('frres rooibos loriental-100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('frres rooibos loriental-100gr' IN BOOLEAN MODE) AND 4814 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
118 0.0006 0.00057411193847656
SELECT *, MATCH (description, title) AGAINST ('frres rooibos loriental-100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('frres rooibos loriental-100gr' IN BOOLEAN MODE) AND 4814 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
119 0.0005 0.00048398971557617
SELECT *, MATCH (description, title) AGAINST ('frres rooibos loriental-100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('frres rooibos loriental-100gr' IN BOOLEAN MODE) AND 4814 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
120 0.0003 0.00029492378234863
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
121 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '862'
122 0.0003 0.00025200843811035
SELECT * FROM productcustomimages WHERE product_id = '862'
123 0.0002 0.00022411346435547
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
124 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.0003209114074707
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0003 0.00026392936706543
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
128 0.0002 0.00018811225891113
SELECT * FROM product_image_select WHERE product_id = '858'
129 0.0002 0.00022006034851074
SELECT * FROM productcustomimages WHERE product_id = '858'
130 0.0002 0.00019502639770508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
131 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0003 0.00030112266540527
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0003 0.00025486946105957
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
135 0.0002 0.00019407272338867
SELECT * FROM product_image_select WHERE product_id = '878'
136 0.0002 0.00017619132995605
SELECT * FROM productcustomimages WHERE product_id = '878'
137 0.0002 0.00019598007202148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
138 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0003 0.00032997131347656
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0003 0.00032305717468262
SELECT id,asin FROM products WHERE parent_id = 4814
142 0.0002 0.0001988410949707
SELECT category_id FROM products_categories WHERE product_id = '4814'
143 0.0002 0.00020503997802734
SELECT * FROM categories WHERE id = '27'
144 0.0002 0.00017905235290527
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
145 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
146 0.0002 0.00018191337585449
SELECT id FROM categories WHERE parent_id = '27'
147 0.0002 0.00017404556274414
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 
148 0.0002 0.00016880035400391
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 
149 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
150 0.0002 0.00016617774963379
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
151 0.0002 0.00017499923706055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
152 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0002 0.0001828670501709
SELECT * FROM productoffers
                WHERE product_id = 4814
                ORDER BY price ASC LIMIT 1
155 0.0002 0.00016903877258301
SELECT value FROM productattributes
                WHERE product_id = '4814'
                AND name = 'ListPriceAmount'
156 0.0005 0.0005040168762207
SELECT * FROM products WHERE id = '4814'
157 0.0002 0.00017905235290527
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0002 0.00018596649169922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
159 0.0002 0.00021004676818848
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = 4814
                ORDER BY price ASC LIMIT 1
162 0.0002 0.00018000602722168
SELECT value FROM productattributes
                WHERE product_id = '4814'
                AND name = 'ListPriceAmount'
163 0.0003 0.00030207633972168
SELECT category_id FROM products_categories WHERE product_id = '4814' AND prod_type = 'amz'
164 0.0002 0.00017094612121582
SELECT parent_id FROM categories WHERE id = '27'
165 0.0002 0.00019097328186035
SELECT * FROM categories WHERE id = '27'
166 0.0002 0.00021982192993164
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
167 0.0002 0.00018787384033203
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
168 0.0002 0.00015401840209961
SELECT id FROM categories WHERE parent_id = '27'
169 0.0002 0.00016593933105469
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 
170 0.0002 0.00021696090698242
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 
171 0.0002 0.00017309188842773
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
172 0.0002 0.0001828670501709
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
173 0.0002 0.000244140625
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
174 0.0002 0.00018405914306641
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
175 0.0002 0.00018119812011719
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
176 0.0003 0.00030279159545898
SELECT * FROM pages WHERE id = 38
177 0.0046 0.0046260356903076
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
178 0.0004 0.00035405158996582
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:1632139102;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'
179 0.0004 0.00043702125549316
SELECT * FROM products WHERE id = 790
180 0.0004 0.00041389465332031
SELECT * FROM products WHERE id = 788
181 0.0005 0.00050091743469238
SELECT * FROM products WHERE id = 787
182 0.0006 0.00057387351989746
SELECT * FROM products WHERE id = 1287
183 0.0005 0.00052714347839355
SELECT * FROM products WHERE id = 779
184 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = 777
185 0.0005 0.00052499771118164
SELECT * FROM products WHERE id = '790'
186 0.0005 0.00046515464782715
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
187 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '790'
188 0.0002 0.00020909309387207
SELECT * FROM productcustomimages WHERE product_id = '790'
189 0.0002 0.00020408630371094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
190 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0003 0.0003049373626709
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193 0.0004 0.00042581558227539
SELECT * FROM products WHERE id = '788'
194 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
195 0.0003 0.00025415420532227
SELECT * FROM product_image_select WHERE product_id = '788'
196 0.0002 0.00018095970153809
SELECT * FROM productcustomimages WHERE product_id = '788'
197 0.0002 0.00021100044250488
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
198 0.0002 0.00020480155944824
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
199 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
200 0.0002 0.0002291202545166
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0004 0.00039005279541016
SELECT * FROM products WHERE id = '787'
202 0.0002 0.00019216537475586
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
203 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '787'
204 0.0002 0.00022602081298828
SELECT * FROM productcustomimages WHERE product_id = '787'
205 0.0002 0.00021219253540039
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
206 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0002 0.0001990795135498
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209 0.0004 0.00044512748718262
SELECT * FROM products WHERE id = '1287'
210 0.0004 0.00040388107299805
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
211 0.0002 0.00018405914306641
SELECT * FROM product_image_select WHERE product_id = '1287'
212 0.0002 0.0001981258392334
SELECT * FROM productcustomimages WHERE product_id = '1287'
213 0.0002 0.00020813941955566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
214 0.0002 0.00021195411682129
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0003 0.00033783912658691
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0004 0.00042104721069336
SELECT * FROM products WHERE id = '779'
218 0.0002 0.00024104118347168
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
219 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '779'
220 0.0002 0.00018405914306641
SELECT * FROM productcustomimages WHERE product_id = '779'
221 0.0002 0.000244140625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
222 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
223 0.0002 0.00020623207092285
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
224 0.0002 0.00020003318786621
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0004 0.00040292739868164
SELECT * FROM products WHERE id = '777'
226 0.0002 0.00020217895507812
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
227 0.0002 0.00019192695617676
SELECT * FROM product_image_select WHERE product_id = '777'
228 0.0002 0.0001828670501709
SELECT * FROM productcustomimages WHERE product_id = '777'
229 0.0002 0.00021910667419434
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
230 0.0002 0.00021004676818848
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0003 0.0003201961517334
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0003 0.00027585029602051
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
234 0.0004 0.00039196014404297
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
235 0.0008 0.00082707405090332
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
236 0.0005 0.00051784515380859
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
237 0.0004 0.00042319297790527
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
238 0.0005 0.00051093101501465
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
239 0.0004 0.00043702125549316
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
240 0.0003 0.00025296211242676
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'