0

Palais Des Thés - Rooibos De Noël N°25 - Boîte Métal 100 Gr

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-18 19:49:06 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Features

La plus surprenante des créations de noël Rooibos de noël aux agrumes et épices Rooibos parfumé Idéal le soir

There are no customer reviews yet. Be the first to Write a Review!

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.5569829940796 266 1.1769 0


No Amazon API Requests Made.


App Debug - Total Time 1.5569829940796 seconds

Number Time From Start Name Description
1 0.35108494758606 Initialise Initialise FSB Function
2 0.35476398468018 App Controller Start Start of the App controller (called before the controller of every page)
3 0.3917179107666 Start of getCategoryListByGroup Function Before first category groups query
4 0.39224100112915 After initial query Before first category groups query
5 0.39224195480347 Get Category List for Group Before the call to getCategoryList function
6 0.392245054245 Start of GetCategoryList function Start of the function
7 0.39224791526794 Before getting categories Query to get specific category list
8 0.39279794692993 After getting categories Query to get specific category list
9 0.39279794692993 Before getting category custom Before call to function getCategoryCustom
10 0.40947008132935 After getting category custom After call to function getCategoryCustom
11 0.40947198867798 Before getting category custom Before call to function getCategoryCustom
12 0.42117190361023 After getting category custom After call to function getCategoryCustom
13 0.42117404937744 Before getting category custom Before call to function getCategoryCustom
14 0.42748689651489 After getting category custom After call to function getCategoryCustom
15 0.42748808860779 Before getting category custom Before call to function getCategoryCustom
16 0.43198108673096 After getting category custom After call to function getCategoryCustom
17 0.43198204040527 Before getting category custom Before call to function getCategoryCustom
18 0.43634104728699 After getting category custom After call to function getCategoryCustom
19 0.4363420009613 Before getting category custom Before call to function getCategoryCustom
20 0.44060301780701 After getting category custom After call to function getCategoryCustom
21 0.44060397148132 End of GetCategoryList function End of the function
22 0.44060802459717 Get Category List for Group Before the call to getCategoryList function
23 0.4406099319458 Start of GetCategoryList function Start of the function
24 0.44061088562012 Before getting categories Query to get specific category list
25 0.4411449432373 End of getCategoryListByGroup Function Before return()
26 1.3528518676758 App Controller End End of the App controller (called before the controller of every page)
27 1.3532919883728 Product Start Start of the product info controller
28 1.3647110462189 Cache file not found Starting get product details
29 1.4096140861511 Related products Start getting related products if enabled
30 1.4096150398254 Related Products Start Before the related products are found
31 1.4096159934998 Related Products Keywords Before the related product keywords are found
32 1.4096238613129 Create Keyword List Function Start of function
33 1.4097230434418 Create Keyword List Function After looping provided content - 30 keywords found
34 1.4103820323944 Create Keyword List Function After looping initial keyword list - 25 keywords remaining
35 1.4103870391846 Create Keyword List Function After reducing keyword list
36 1.410434961319 Create Keyword List Function After selecting by scoring keywords
37 1.4104380607605 Create Keyword List Function After final loop of keywords
38 1.4104390144348 Related Products Keywords After the related product keywords are found
39 1.4455590248108 Related Products End After the related products are found
40 1.4786720275879 Product End End of the product info controller (Product Info)
41 1.4794209003448 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4801840782166 Before Get Options Before the call to getOptions in the tpl class
43 1.5295939445496 After Get Options After the call to getOptions in the tpl class
44 1.5297110080719 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5297300815582 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5326578617096 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5326600074768 Product Info: Before Template Display Before the template is displayed
48 1.5569660663605 Product Info: After Template Display After the template is displayed
49 1.5569739341736 Finalizing debug Before the debug is output to the page.
50 1.5569820404053 End of App This is the end of the app logging, final timestamp


Query Debug - 266 Database Queries. Total time 1.1769 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0009 0.0009300708770752
SELECT parameter, value FROM parameters
2 0.0090 0.0090088844299316
SELECT * FROM `bad_bots`
3 0.0005 0.0004570484161377
SET time_zone = 'Europe/London'
4 0.0008 0.00077009201049805
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0008 0.00080204010009766
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"13.58.244.184\";}'
6 0.0007 0.00072407722473145
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745317754'
7 0.0014 0.0014050006866455
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.0008089542388916
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0011 0.0011370182037354
SELECT id FROM pages WHERE pagename = 'palais-des-thes-rooibos-de-noel-n25-bote-metal-100-gr' LIMIT 1
10 0.0015 0.0015029907226562
SELECT id FROM products WHERE pagename = 'palais-des-thes-rooibos-de-noel-n25-bote-metal-100-gr' AND hidden = 0 LIMIT 1
11 0.0047 0.0046579837799072
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0315 0.031452894210815
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00050210952758789
SELECT * FROM pages WHERE pagename = 'palais-des-thes-rooibos-de-noel-n25-bote-metal-100-gr'
14 0.0005 0.00050997734069824
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00053501129150391
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0068 0.0067689418792725
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.00052595138549805
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.0004 0.00043082237243652
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00045299530029297
SELECT id FROM categories WHERE parent_id = '26'
20 0.0061 0.0060501098632812
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.0007 0.00069808959960938
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.0007 0.0006558895111084
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.0006 0.00056791305541992
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00047612190246582
SELECT * FROM categorygroups WHERE id = '1'
25 0.0044 0.0043599605560303
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.0005 0.00047707557678223
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.0005 0.0004580020904541
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00045585632324219
SELECT id FROM categories WHERE parent_id = '27'
29 0.0039 0.0039429664611816
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.0005 0.00048089027404785
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.0005 0.00054693222045898
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.0005 0.00052189826965332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.0004270076751709
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0015790462493896
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.0006 0.00058317184448242
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.0004 0.00040817260742188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00048208236694336
SELECT id FROM categories WHERE parent_id = '28'
38 0.0014 0.0014300346374512
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.0004 0.00044083595275879
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.0005 0.00050497055053711
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.00044608116149902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.0004119873046875
SELECT * FROM categorygroups WHERE id = '1'
43 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 = 29
44 0.0004 0.00044488906860352
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.00040006637573242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00043797492980957
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00072216987609863
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.0006 0.00055193901062012
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.0005 0.00049996376037598
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.0005 0.00046896934509277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.0003969669342041
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00059390068054199
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.0005 0.00046205520629883
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.0004 0.00040602684020996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00039887428283691
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.0005 0.00050711631774902
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.0005 0.00047898292541504
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.0005 0.00045585632324219
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00043797492980957
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00057411193847656
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.0004 0.00043201446533203
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.0004 0.00036501884460449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.0003809928894043
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00061202049255371
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.0004 0.00040817260742188
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.0006 0.00061202049255371
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.0004 0.0004429817199707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00041294097900391
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00053119659423828
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0016 0.0015709400177002
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0008 0.00077199935913086
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00063395500183105
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0004 0.00040698051452637
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0012 0.0011918544769287
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0009 0.00093293190002441
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.9039 0.90390491485596
SELECT * FROM ipgeocountries WHERE INET_ATON('13.58.244.184') >= INET_ATON(ip_start) AND INET_ATON('13.58.244.184') <= INET_ATON(ip_end)
78 0.0010 0.0009770393371582
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0004 0.00043988227844238
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00064682960510254
SELECT * FROM products WHERE pagename = 'palais-des-thes-rooibos-de-noel-n25-bote-metal-100-gr'
81 0.0004 0.00041794776916504
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1400
82 0.0006 0.00055503845214844
SELECT * FROM manufacturers WHERE id = '222'
83 0.0005 0.00047802925109863
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '222'
84 0.0004 0.00040102005004883
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '222' LIMIT 1
85 0.0006 0.00059008598327637
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '222' ORDER BY RAND() LIMIT 1
86 0.0004 0.0003669261932373
SELECT * FROM productimages WHERE product_id = '1163' ORDER BY sortorder ASC
87 0.0004 0.00040197372436523
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '222'
88 0.0004 0.00043296813964844
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '222'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0003 0.00026106834411621
SELECT * FROM manufacturerimages WHERE manufacturer_id = '222'
90 0.0004 0.00037598609924316
SELECT category_id FROM products_categories WHERE product_id = '1400'
91 0.0004 0.00038480758666992
SELECT * FROM categories WHERE id = '27'
92 0.0044 0.004417896270752
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
93 0.0004 0.00042510032653809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0003 0.00032711029052734
SELECT id FROM categories WHERE parent_id = '27'
95 0.0049 0.0049018859863281
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 
96 0.0006 0.00059390068054199
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 
97 0.0006 0.00056004524230957
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
98 0.0006 0.00060009956359863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0006 0.00057101249694824
SELECT * FROM productimages WHERE product_id = '1400' ORDER BY sortorder ASC
100 0.0008 0.00076007843017578
SELECT * FROM product_image_select WHERE product_id = '1400'
101 0.0005 0.00048613548278809
SELECT * FROM productcustomimages WHERE product_id = '1400'
102 0.0006 0.00058603286743164
SELECT * FROM productfeeds WHERE product_id = '1400' ORDER BY item_date DESC
103 0.0009 0.00085210800170898
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1400' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0007 0.00070810317993164
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1400' AND t.hidden = 0 AND display_product = 1
105 0.0004 0.00040006637573242
SELECT * FROM tags WHERE id = '1'
106 0.0021 0.0021228790283203
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
107 0.0018 0.0018088817596436
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 
108 0.0018 0.0018458366394043
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
109 0.0007 0.00067400932312012
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
110 0.0004 0.0003509521484375
SELECT * FROM tags WHERE id = '216'
111 0.0045 0.0044949054718018
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
112 0.0047 0.0046920776367188
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 
113 0.0030 0.0030419826507568
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
114 0.0005 0.00049209594726562
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
115 0.0006 0.00056791305541992
SELECT * FROM productamazoncontent WHERE product_id = '1400'
116 0.0012 0.0012350082397461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1400' AND a.name = n.originalname
117 0.0005 0.00049114227294922
SELECT * FROM productoffers WHERE product_id = '1400' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0004 0.00039386749267578
SELECT * FROM productoffers
                WHERE product_id = '1400' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0003 0.00034308433532715
SELECT * FROM productoffers
                WHERE product_id = 1400
                ORDER BY price ASC LIMIT 1
120 0.0004 0.00039315223693848
SELECT value FROM productattributes
                WHERE product_id = '1400'
                AND name = 'ListPriceAmount'
121 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '1400' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0005 0.00052094459533691
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
123 0.0094 0.0094389915466309
SELECT *, MATCH (description, title) AGAINST ('des thés rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('des thés rooibos' IN BOOLEAN MODE) AND 1400 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
124 0.0006 0.00058293342590332
SELECT *, MATCH (description, title) AGAINST ('des thés rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('des thés rooibos' IN BOOLEAN MODE) AND 1400 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
125 0.0005 0.00053715705871582
SELECT *, MATCH (description, title) AGAINST ('des thés rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('des thés rooibos' IN BOOLEAN MODE) AND 1400 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
126 0.0005 0.00047206878662109
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
127 0.0006 0.00061988830566406
SELECT * FROM product_image_select WHERE product_id = '878'
128 0.0004 0.00039196014404297
SELECT * FROM productcustomimages WHERE product_id = '878'
129 0.0011 0.0011188983917236
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
130 0.0006 0.00055313110351562
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0004 0.00040984153747559
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0005 0.00050806999206543
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
134 0.0006 0.00059318542480469
SELECT * FROM product_image_select WHERE product_id = '869'
135 0.0005 0.00053191184997559
SELECT * FROM productcustomimages WHERE product_id = '869'
136 0.0009 0.00090885162353516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
137 0.0005 0.00048112869262695
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0004 0.0004119873046875
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0004 0.00041389465332031
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0005 0.00050711631774902
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
141 0.0006 0.00057792663574219
SELECT * FROM product_image_select WHERE product_id = '780'
142 0.0004 0.00042104721069336
SELECT * FROM productcustomimages WHERE product_id = '780'
143 0.0009 0.00089383125305176
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
144 0.0005 0.00045180320739746
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0006 0.00062394142150879
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0006 0.00056290626525879
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
148 0.0006 0.00058507919311523
SELECT * FROM product_image_select WHERE product_id = '865'
149 0.0005 0.00046205520629883
SELECT * FROM productcustomimages WHERE product_id = '865'
150 0.0008 0.00078392028808594
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
151 0.0005 0.00048017501831055
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0005 0.00047206878662109
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00040793418884277
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0006 0.00064396858215332
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
155 0.0007 0.00066900253295898
SELECT * FROM product_image_select WHERE product_id = '862'
156 0.0004 0.0004279613494873
SELECT * FROM productcustomimages WHERE product_id = '862'
157 0.0009 0.00092411041259766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
158 0.0005 0.00047707557678223
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0005 0.00045204162597656
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0006 0.00059413909912109
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
162 0.0006 0.0006110668182373
SELECT * FROM product_image_select WHERE product_id = '858'
163 0.0004 0.00044989585876465
SELECT * FROM productcustomimages WHERE product_id = '858'
164 0.0012 0.0011858940124512
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
165 0.0005 0.00050902366638184
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0004 0.00040984153747559
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0005 0.00046586990356445
SELECT id,asin FROM products WHERE parent_id = 1400
169 0.0005 0.000518798828125
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1400' ORDER BY timestamp DESC
170 0.0005 0.00046706199645996
SELECT category_id FROM products_categories WHERE product_id = '1400'
171 0.0005 0.00051403045654297
SELECT * FROM categories WHERE id = '27'
172 0.0045 0.0045180320739746
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
173 0.0005 0.00045514106750488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
174 0.0004 0.00039196014404297
SELECT id FROM categories WHERE parent_id = '27'
175 0.0047 0.0047130584716797
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 
176 0.0006 0.00062298774719238
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 
177 0.0006 0.00058102607727051
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
178 0.0005 0.00051116943359375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
179 0.0017 0.0016920566558838
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1400' AND a.name = n.originalname
180 0.0005 0.00050497055053711
SELECT * FROM productoffers WHERE product_id = '1400' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0004 0.00041079521179199
SELECT * FROM productoffers
                WHERE product_id = '1400' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0003 0.00034189224243164
SELECT * FROM productoffers
                WHERE product_id = 1400
                ORDER BY price ASC LIMIT 1
183 0.0004 0.00041913986206055
SELECT value FROM productattributes
                WHERE product_id = '1400'
                AND name = 'ListPriceAmount'
184 0.0006 0.00056600570678711
SELECT * FROM products WHERE id = '1400'
185 0.0005 0.00054287910461426
SELECT value FROM productattributes WHERE product_id = '1400' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0013 0.0012569427490234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1400' AND a.name = n.originalname
187 0.0004 0.00035595893859863
SELECT * FROM productoffers WHERE product_id = '1400' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0003 0.00034689903259277
SELECT * FROM productoffers
                WHERE product_id = '1400' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0003 0.00032901763916016
SELECT * FROM productoffers
                WHERE product_id = 1400
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00040483474731445
SELECT value FROM productattributes
                WHERE product_id = '1400'
                AND name = 'ListPriceAmount'
191 0.0005 0.00049495697021484
SELECT category_id FROM products_categories WHERE product_id = '1400' AND prod_type = 'amz'
192 0.0005 0.0005340576171875
SELECT parent_id FROM categories WHERE id = '27'
193 0.0004 0.00038909912109375
SELECT * FROM categories WHERE id = '27'
194 0.0042 0.0041699409484863
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
195 0.0005 0.00048208236694336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
196 0.0003 0.00034189224243164
SELECT id FROM categories WHERE parent_id = '27'
197 0.0041 0.0041239261627197
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 
198 0.0006 0.00055503845214844
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 
199 0.0005 0.00052690505981445
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
200 0.0004 0.00041794776916504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
201 0.0004 0.00044798851013184
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
202 0.0004 0.00040483474731445
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
203 0.0003 0.00030207633972168
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
204 0.0134 0.013398885726929
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
205 0.0006 0.00061297416687012
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
206 0.0005 0.00051093101501465
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
207 0.0005 0.00048184394836426
SELECT * FROM products WHERE id = 1626
208 0.0004 0.00037693977355957
SELECT * FROM products WHERE id = 4041
209 0.0003 0.00034999847412109
SELECT * FROM products WHERE id = 4312
210 0.0003 0.00030398368835449
SELECT * FROM products WHERE id = 777
211 0.0003 0.00033402442932129
SELECT * FROM products WHERE id = 3881
212 0.0003 0.00032591819763184
SELECT * FROM products WHERE id = 4213
213 0.0003 0.00034499168395996
SELECT * FROM products WHERE id = '1626'
214 0.0005 0.0004580020904541
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
215 0.0006 0.00057601928710938
SELECT * FROM product_image_select WHERE product_id = '1626'
216 0.0004 0.0003511905670166
SELECT * FROM productcustomimages WHERE product_id = '1626'
217 0.0008 0.00082302093505859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
218 0.0005 0.00047898292541504
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0005 0.00046086311340332
SELECT * FROM products WHERE id = '4041'
222 0.0004 0.00041890144348145
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
223 0.0006 0.00055098533630371
SELECT * FROM product_image_select WHERE product_id = '4041'
224 0.0004 0.00036287307739258
SELECT * FROM productcustomimages WHERE product_id = '4041'
225 0.0011 0.0010778903961182
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
226 0.0004 0.00043702125549316
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0004 0.00040888786315918
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0005 0.00045394897460938
SELECT * FROM products WHERE id = '4312'
230 0.0004 0.00043296813964844
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
231 0.0005 0.00052809715270996
SELECT * FROM product_image_select WHERE product_id = '4312'
232 0.0004 0.00036215782165527
SELECT * FROM productcustomimages WHERE product_id = '4312'
233 0.0011 0.0010972023010254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
234 0.0005 0.0004730224609375
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0004 0.00039505958557129
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0004 0.00043606758117676
SELECT * FROM products WHERE id = '777'
238 0.0004 0.00043296813964844
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
239 0.0005 0.00053906440734863
SELECT * FROM product_image_select WHERE product_id = '777'
240 0.0004 0.00038003921508789
SELECT * FROM productcustomimages WHERE product_id = '777'
241 0.0013 0.0012919902801514
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
242 0.0007 0.0007178783416748
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0007 0.00074315071105957
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0005 0.00050592422485352
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0006 0.00055789947509766
SELECT * FROM products WHERE id = '3881'
246 0.0006 0.00063705444335938
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
247 0.0007 0.00066304206848145
SELECT * FROM product_image_select WHERE product_id = '3881'
248 0.0004 0.00041508674621582
SELECT * FROM productcustomimages WHERE product_id = '3881'
249 0.0014 0.0013918876647949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
250 0.0005 0.00048112869262695
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0005 0.00045204162597656
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0005 0.00046515464782715
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253 0.0006 0.00064301490783691
SELECT * FROM products WHERE id = '4213'
254 0.0006 0.00063514709472656
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
255 0.0009 0.00092196464538574
SELECT * FROM product_image_select WHERE product_id = '4213'
256 0.0004 0.0004420280456543
SELECT * FROM productcustomimages WHERE product_id = '4213'
257 0.0013 0.0012979507446289
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
258 0.0005 0.0004730224609375
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0004 0.00044012069702148
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0008 0.00076007843017578
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
262 0.0006 0.00062394142150879
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
263 0.0017 0.0017490386962891
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
264 0.0006 0.00062298774719238
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
265 0.0005 0.00049686431884766
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
266 0.0005 0.0005180835723877
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'