The Tea Masters Boîte de rangement Rooibos Rouge

The Tea Masters Boîte de rangement Rooibos Rouge
The Tea Masters Boîte de rangement Rooibos Rouge (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-07-19 22:45:30 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.79916906356812 254 0.1406 0


No Amazon API Requests Made.

Total time 0.79916906356812 seconds

Number Time From Start Name Description
1 0.57524418830872 Initialise Initialise FSB Function
2 0.5772111415863 App Controller Start Start of the App controller (called before the controller of every page)
3 0.58019709587097 Start of getCategoryListByGroup Function Before first category groups query
4 0.58047199249268 After initial query Before first category groups query
5 0.58047413825989 Get Category List for Group Before the call to getCategoryList function
6 0.58047699928284 Start of GetCategoryList function Start of the function
7 0.58048105239868 Before getting categories Query to get specific category list
8 0.58088898658752 After getting categories Query to get specific category list
9 0.58089017868042 Before getting category custom Before call to function getCategoryCustom
10 0.58281111717224 After getting category custom After call to function getCategoryCustom
11 0.58281421661377 Before getting category custom Before call to function getCategoryCustom
12 0.58456921577454 After getting category custom After call to function getCategoryCustom
13 0.58457112312317 Before getting category custom Before call to function getCategoryCustom
14 0.58632206916809 After getting category custom After call to function getCategoryCustom
15 0.5863242149353 Before getting category custom Before call to function getCategoryCustom
16 0.58801007270813 After getting category custom After call to function getCategoryCustom
17 0.58801221847534 Before getting category custom Before call to function getCategoryCustom
18 0.58982419967651 After getting category custom After call to function getCategoryCustom
19 0.58982610702515 Before getting category custom Before call to function getCategoryCustom
20 0.59153199195862 After getting category custom After call to function getCategoryCustom
21 0.59153413772583 End of GetCategoryList function End of the function
22 0.59153914451599 End of getCategoryListByGroup Function Before return()
23 0.59832906723022 App Controller End End of the App controller (called before the controller of every page)
24 0.59890818595886 Product Start Start of the product info controller
25 0.62602019309998 Cache file not found Starting get product details
26 0.67541909217834 Related products Start getting related products if enabled
27 0.67542099952698 Related Products Start Before the related products are found
28 0.67542219161987 Related Products Keywords Before the related product keywords are found
29 0.67542600631714 Create Keyword List Function Start of function
30 0.67550301551819 Create Keyword List Function After looping provided content - 21 keywords found
31 0.67631006240845 Create Keyword List Function After looping initial keyword list - 18 keywords remaining
32 0.67631721496582 Create Keyword List Function After reducing keyword list
33 0.67636203765869 Create Keyword List Function After selecting by scoring keywords
34 0.67636513710022 Create Keyword List Function After final loop of keywords
35 0.67636704444885 Related Products Keywords After the related product keywords are found
36 0.71043300628662 Related Products End After the related products are found
37 0.71921110153198 Product End End of the product info controller (Product Info)
38 0.72020506858826 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.72073817253113 Before Get Options Before the call to getOptions in the tpl class
40 0.74975800514221 After Get Options After the call to getOptions in the tpl class
41 0.74985218048096 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.7498791217804 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.7782130241394 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.77821803092957 Product Info: Before Template Display Before the template is displayed
45 0.79914402961731 Product Info: After Template Display After the template is displayed
46 0.79915618896484 Finalizing debug Before the debug is output to the page.
47 0.7991681098938 End of App This is the end of the app logging, final timestamp


Query Debug - 254 Database Queries. Total time 0.1406 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00041794776916504
SELECT parameter, value FROM parameters
2 0.0009 0.00093913078308105
SELECT * FROM `bad_bots`
3 0.0004 0.00043177604675293
SET time_zone = 'Europe/London'
4 0.0002 0.00023508071899414
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0022 0.0022249221801758
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.205.192.201\";}'
6 0.0011 0.001060962677002
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1628123249'
7 0.0004 0.00035905838012695
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00022792816162109
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0004 0.00043511390686035
SELECT id FROM pages WHERE pagename = 'the-tea-masters-bote-de-rangement-rooibos-rouge' LIMIT 1
10 0.0004 0.00040292739868164
SELECT id FROM products WHERE pagename = 'the-tea-masters-bote-de-rangement-rooibos-rouge' AND hidden = 0 LIMIT 1
11 0.0008 0.0007929801940918
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0010 0.00098109245300293
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0007 0.00068211555480957
SELECT * FROM pages WHERE pagename = 'the-tea-masters-bote-de-rangement-rooibos-rouge'
14 0.0003 0.00026202201843262
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00038790702819824
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0002 0.00024294853210449
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.0002 0.00020813941955566
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.00020194053649902
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.0002 0.00020194053649902
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.00020098686218262
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.00018000602722168
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.00017881393432617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00019502639770508
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00018811225891113
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.00019097328186035
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.00018811225891113
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00017595291137695
SELECT id FROM categories WHERE parent_id = '27'
29 0.0002 0.00017786026000977
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.00017595291137695
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.00018596649169922
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.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00019121170043945
SELECT * FROM categorygroups WHERE id = '1'
34 0.0002 0.00017714500427246
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.00018000602722168
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.00018095970153809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00018310546875
SELECT id FROM categories WHERE parent_id = '28'
38 0.0002 0.0001981258392334
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.0001990795135498
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.00019001960754395
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00018095970153809
SELECT * FROM categorygroups WHERE id = '1'
43 0.0002 0.00018405914306641
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.00019621849060059
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.00017309188842773
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00017285346984863
SELECT id FROM categories WHERE parent_id = '29'
47 0.0002 0.00016903877258301
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.0001671314239502
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.00018191337585449
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.00017285346984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.0001838207244873
SELECT * FROM categorygroups WHERE id = '1'
52 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 = 30
53 0.0002 0.00020599365234375
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.00019693374633789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00018692016601562
SELECT id FROM categories WHERE parent_id = '30'
56 0.0002 0.00022006034851074
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.00018119812011719
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.00018095970153809
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.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00018405914306641
SELECT * FROM categorygroups WHERE id = '1'
61 0.0002 0.00017714500427246
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.0001838207244873
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.00017499923706055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00017595291137695
SELECT id FROM categories WHERE parent_id = '31'
65 0.0002 0.00017595291137695
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.00018095970153809
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.00018692016601562
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.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00018715858459473
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00020599365234375
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0002 0.00024795532226562
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0002 0.00022983551025391
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.00019216537475586
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0007 0.00068402290344238
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.0005500316619873
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00022578239440918
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.00021982192993164
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00019097328186035
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.00058794021606445
SELECT * FROM products WHERE pagename = 'the-tea-masters-bote-de-rangement-rooibos-rouge'
80 0.0008 0.00078701972961426
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3764
81 0.0007 0.00073099136352539
SELECT * FROM manufacturers WHERE id = '555'
82 0.0008 0.00075697898864746
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '555'
83 0.0006 0.00058698654174805
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '555' LIMIT 1
84 0.0008 0.00084805488586426
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '555' ORDER BY RAND() LIMIT 1
85 0.0017 0.0016601085662842
SELECT * FROM productimages WHERE product_id = '4935' ORDER BY sortorder ASC
86 0.0002 0.00023317337036133
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '555'
87 0.0007 0.00065302848815918
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '555'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.0003819465637207
SELECT * FROM manufacturerimages WHERE manufacturer_id = '555'
89 0.0005 0.00050592422485352
SELECT category_id FROM products_categories WHERE product_id = '3764'
90 0.0002 0.00023317337036133
SELECT * FROM categories WHERE id = '27'
91 0.0044 0.0043709278106689
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.0023 0.0023009777069092
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0003 0.00027894973754883
SELECT id FROM categories WHERE parent_id = '27'
94 0.0059 0.0059299468994141
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.00022006034851074
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.00022792816162109
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.00019621849060059
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0016 0.0016498565673828
SELECT * FROM productimages WHERE product_id = '3764' ORDER BY sortorder ASC
99 0.0004 0.00043797492980957
SELECT * FROM product_image_select WHERE product_id = '3764'
100 0.0003 0.00033307075500488
SELECT * FROM productcustomimages WHERE product_id = '3764'
101 0.0005 0.00049090385437012
SELECT * FROM productfeeds WHERE product_id = '3764' ORDER BY item_date DESC
102 0.0006 0.00060510635375977
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3764' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0015 0.0014960765838623
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3764' AND t.hidden = 0 AND display_product = 1
104 0.0002 0.00022506713867188
SELECT * FROM tags WHERE id = '216'
105 0.0048 0.0047910213470459
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '216'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
106 0.0048 0.004770040512085
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '216'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
107 0.0085 0.0084609985351562
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '216' 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.0004 0.0004270076751709
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
109 0.0012 0.0011680126190186
SELECT * FROM productamazoncontent WHERE product_id = '3764'
110 0.0012 0.0011951923370361
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3764' AND a.name = n.originalname
111 0.0004 0.00044083595275879
SELECT * FROM productoffers WHERE product_id = '3764' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0004 0.00041890144348145
SELECT * FROM productoffers
                WHERE product_id = '3764' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0004 0.00036191940307617
SELECT * FROM productoffers
                WHERE product_id = 3764
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00041389465332031
SELECT value FROM productattributes
                WHERE product_id = '3764'
                AND name = 'ListPriceAmount'
115 0.0005 0.00054597854614258
SELECT value FROM productattributes WHERE product_id = '3764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116 0.0003 0.00032401084899902
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.0110 0.01102089881897
SELECT *, MATCH (description, title) AGAINST ('rangement rooibos rouge' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rangement rooibos rouge' IN BOOLEAN MODE) AND 3764 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
118 0.0008 0.00084996223449707
SELECT *, MATCH (description, title) AGAINST ('rangement rooibos rouge' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rangement rooibos rouge' IN BOOLEAN MODE) AND 3764 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
119 0.0006 0.00058388710021973
SELECT *, MATCH (description, title) AGAINST ('rangement rooibos rouge' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rangement rooibos rouge' IN BOOLEAN MODE) AND 3764 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
120 0.0003 0.00031805038452148
SELECT * FROM productimages WHERE product_id = '850' ORDER BY sortorder ASC
121 0.0008 0.00084519386291504
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '850' AND p.id = pi.product_id ORDER BY pi.sortorder
122 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '850'
123 0.0002 0.00024509429931641
SELECT * FROM productcustomimages WHERE product_id = '850'
124 0.0009 0.00089097023010254
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '850'
                GROUP BY o.product_id
125 0.0009 0.00088405609130859
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '850'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
126 0.0005 0.00052285194396973
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 850
127 0.0003 0.00025606155395508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
128 0.0004 0.00035691261291504
SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0005 0.00047707557678223
SELECT * FROM productoffers
                WHERE product_id = '850' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0005 0.00051999092102051
SELECT * FROM productoffers
                WHERE product_id = 850
                ORDER BY price ASC LIMIT 1
131 0.0002 0.00023078918457031
SELECT value FROM productattributes
                WHERE product_id = '850'
                AND name = 'ListPriceAmount'
132 0.0002 0.00020003318786621
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '850'
                GROUP BY o.product_id
133 0.0002 0.0001981258392334
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '850'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
134 0.0002 0.00019001960754395
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 850
135 0.0002 0.00018596649169922
SELECT value FROM productattributes WHERE product_id = '850' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0007 0.00067305564880371
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '850'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
137 0.0004 0.00042080879211426
SELECT * FROM products WHERE parent_id = '850'
138 0.0002 0.00023007392883301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4891' AND a.name = n.originalname
139 0.0003 0.00032997131347656
SELECT * FROM productoffers WHERE product_id = '4891' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00051999092102051
SELECT * FROM productoffers
                WHERE product_id = '4891' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0015 0.0015039443969727
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
142 0.0005 0.00046610832214355
SELECT * FROM product_image_select WHERE product_id = '858'
143 0.0003 0.00034618377685547
SELECT * FROM productcustomimages WHERE product_id = '858'
144 0.0012 0.0012071132659912
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
145 0.0049 0.0048890113830566
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0007 0.00073790550231934
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0007 0.00071907043457031
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0004 0.00042891502380371
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
149 0.0003 0.00033307075500488
SELECT * FROM product_image_select WHERE product_id = '810'
150 0.0003 0.0002591609954834
SELECT * FROM productcustomimages WHERE product_id = '810'
151 0.0002 0.00023293495178223
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
152 0.0002 0.00022411346435547
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0002 0.00023818016052246
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0003 0.00031399726867676
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0005 0.00049591064453125
SELECT id,asin FROM products WHERE parent_id = 3764
156 0.0003 0.00034809112548828
SELECT category_id FROM products_categories WHERE product_id = '3764'
157 0.0005 0.00053095817565918
SELECT * FROM categories WHERE id = '27'
158 0.0003 0.0002748966217041
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
159 0.0003 0.00027298927307129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
160 0.0002 0.00023198127746582
SELECT id FROM categories WHERE parent_id = '27'
161 0.0002 0.00021505355834961
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 
162 0.0002 0.00021481513977051
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 
163 0.0002 0.00023102760314941
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
164 0.0002 0.00021886825561523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
165 0.0003 0.00025296211242676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3764' AND a.name = n.originalname
166 0.0003 0.00026202201843262
SELECT * FROM productoffers WHERE product_id = '3764' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0002 0.00024080276489258
SELECT * FROM productoffers
                WHERE product_id = '3764' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0003 0.00028300285339355
SELECT * FROM productoffers
                WHERE product_id = 3764
                ORDER BY price ASC LIMIT 1
169 0.0002 0.00023007392883301
SELECT value FROM productattributes
                WHERE product_id = '3764'
                AND name = 'ListPriceAmount'
170 0.0007 0.0007331371307373
SELECT * FROM products WHERE id = '3764'
171 0.0002 0.00024199485778809
SELECT value FROM productattributes WHERE product_id = '3764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0002 0.00024914741516113
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3764' AND a.name = n.originalname
173 0.0002 0.00023579597473145
SELECT * FROM productoffers WHERE product_id = '3764' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '3764' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = 3764
                ORDER BY price ASC LIMIT 1
176 0.0002 0.0001990795135498
SELECT value FROM productattributes
                WHERE product_id = '3764'
                AND name = 'ListPriceAmount'
177 0.0003 0.00033187866210938
SELECT category_id FROM products_categories WHERE product_id = '3764' AND prod_type = 'amz'
178 0.0002 0.00020599365234375
SELECT parent_id FROM categories WHERE id = '27'
179 0.0002 0.00023007392883301
SELECT * FROM categories WHERE id = '27'
180 0.0002 0.00018811225891113
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
181 0.0002 0.00016880035400391
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
182 0.0002 0.00017213821411133
SELECT id FROM categories WHERE parent_id = '27'
183 0.0002 0.00017786026000977
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 
184 0.0002 0.00018000602722168
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 
185 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
186 0.0002 0.00019192695617676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
187 0.0004 0.00042104721069336
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
188 0.0002 0.00021195411682129
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
189 0.0002 0.00024294853210449
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
190 0.0003 0.00029802322387695
SELECT * FROM pages WHERE id = 38
191 0.0040 0.0040128231048584
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
192 0.0007 0.00071001052856445
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:1628123249;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'
193 0.0006 0.00063204765319824
SELECT * FROM products WHERE id = 790
194 0.0005 0.0005030632019043
SELECT * FROM products WHERE id = 788
195 0.0006 0.00064706802368164
SELECT * FROM products WHERE id = 787
196 0.0006 0.00062203407287598
SELECT * FROM products WHERE id = 1287
197 0.0006 0.00064277648925781
SELECT * FROM products WHERE id = 777
198 0.0007 0.0007171630859375
SELECT * FROM products WHERE id = 776
199 0.0007 0.00066804885864258
SELECT * FROM products WHERE id = '790'
200 0.0004 0.0004270076751709
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
201 0.0003 0.00025200843811035
SELECT * FROM product_image_select WHERE product_id = '790'
202 0.0002 0.00020408630371094
SELECT * FROM productcustomimages WHERE product_id = '790'
203 0.0002 0.00024580955505371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
204 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0003 0.0003058910369873
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0004 0.00040006637573242
SELECT * FROM products WHERE id = '788'
208 0.0002 0.0002288818359375
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
209 0.0002 0.00023889541625977
SELECT * FROM product_image_select WHERE product_id = '788'
210 0.0002 0.00017809867858887
SELECT * FROM productcustomimages WHERE product_id = '788'
211 0.0002 0.00023317337036133
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
212 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0002 0.00020980834960938
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0002 0.00023007392883301
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0004 0.00039005279541016
SELECT * FROM products WHERE id = '787'
216 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
217 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '787'
218 0.0002 0.00017499923706055
SELECT * FROM productcustomimages WHERE product_id = '787'
219 0.0002 0.00018501281738281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
220 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0002 0.00020909309387207
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0004 0.00042009353637695
SELECT * FROM products WHERE id = '1287'
224 0.0004 0.00041985511779785
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
225 0.0002 0.00018906593322754
SELECT * FROM product_image_select WHERE product_id = '1287'
226 0.0002 0.00020289421081543
SELECT * FROM productcustomimages WHERE product_id = '1287'
227 0.0002 0.00024890899658203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
228 0.0002 0.00020909309387207
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0002 0.0002291202545166
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0003 0.0003359317779541
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0004 0.00038909912109375
SELECT * FROM products WHERE id = '777'
232 0.0002 0.00018906593322754
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
233 0.0002 0.00018405914306641
SELECT * FROM product_image_select WHERE product_id = '777'
234 0.0002 0.00017595291137695
SELECT * FROM productcustomimages WHERE product_id = '777'
235 0.0002 0.00021481513977051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
236 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0003 0.00032687187194824
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = '776'
240 0.0004 0.00044798851013184
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
241 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '776'
242 0.0002 0.00022196769714355
SELECT * FROM productcustomimages WHERE product_id = '776'
243 0.0003 0.00030708312988281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
244 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0002 0.00021481513977051
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0002 0.00021696090698242
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0003 0.00029587745666504
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
248 0.0006 0.0005500316619873
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
249 0.0011 0.0010778903961182
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
250 0.0005 0.00048589706420898
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
251 0.0006 0.0005640983581543
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
252 0.0005 0.00045204162597656
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
253 0.0003 0.00031900405883789
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
254 0.0004 0.0003509521484375
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'