0
  1. My Store
  2. Rooibos

Jardins De GaÏa - JARDINS DE GAÏA - Elixir des petits lutins Tube 100 g - Rooibos aromatisé (Fraise - Vanille)

Price: €12,24
Product prices and availability are accurate as of 2022-06-25 17:11:23 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.
Availability: In Stock
Click and Choose Options
Buy Now from Amazon
En stock.
Product Information (more info)
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.

Related Products

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

Browse Categories

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.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.3823750019073 324 1.1905 0


No Amazon API Requests Made.


App Debug - Total Time 2.3823750019073 seconds

Number Time From Start Name Description
1 0.60286116600037 Initialise Initialise FSB Function
2 0.6044909954071 App Controller Start Start of the App controller (called before the controller of every page)
3 0.63713717460632 Start of getCategoryListByGroup Function Before first category groups query
4 0.63778805732727 After initial query Before first category groups query
5 0.63778901100159 Get Category List for Group Before the call to getCategoryList function
6 0.6377911567688 Start of GetCategoryList function Start of the function
7 0.63779306411743 Before getting categories Query to get specific category list
8 0.63858699798584 After getting categories Query to get specific category list
9 0.63858795166016 Before getting category custom Before call to function getCategoryCustom
10 0.66926908493042 After getting category custom After call to function getCategoryCustom
11 0.66927099227905 Before getting category custom Before call to function getCategoryCustom
12 0.68514204025269 After getting category custom After call to function getCategoryCustom
13 0.685142993927 Before getting category custom Before call to function getCategoryCustom
14 0.69390797615051 After getting category custom After call to function getCategoryCustom
15 0.69390797615051 Before getting category custom Before call to function getCategoryCustom
16 0.7003321647644 After getting category custom After call to function getCategoryCustom
17 0.70033311843872 Before getting category custom Before call to function getCategoryCustom
18 0.70627808570862 After getting category custom After call to function getCategoryCustom
19 0.70627808570862 Before getting category custom Before call to function getCategoryCustom
20 0.7117919921875 After getting category custom After call to function getCategoryCustom
21 0.71179413795471 End of GetCategoryList function End of the function
22 0.71179795265198 Get Category List for Group Before the call to getCategoryList function
23 0.71179914474487 Start of GetCategoryList function Start of the function
24 0.71180009841919 Before getting categories Query to get specific category list
25 0.71246099472046 End of getCategoryListByGroup Function Before return()
26 1.5527839660645 App Controller End End of the App controller (called before the controller of every page)
27 1.5532519817352 Product Start Start of the product info controller
28 1.554878950119 Cache file not found Starting get product details
29 1.5794470310211 Related products Start getting related products if enabled
30 1.5794479846954 Related Products Start Before the related products are found
31 1.5794491767883 Related Products Keywords Before the related product keywords are found
32 1.5794529914856 Create Keyword List Function Start of function
33 1.5795481204987 Create Keyword List Function After looping provided content - 42 keywords found
34 1.5805411338806 Create Keyword List Function After looping initial keyword list - 38 keywords remaining
35 1.5805470943451 Create Keyword List Function After reducing keyword list
36 1.580708026886 Create Keyword List Function After selecting by scoring keywords
37 1.5807111263275 Create Keyword List Function After final loop of keywords
38 1.5807120800018 Related Products Keywords After the related product keywords are found
39 1.7122509479523 Related Products End After the related products are found
40 1.7388570308685 Product End End of the product info controller (Product Info)
41 1.7396290302277 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.7403190135956 Before Get Options Before the call to getOptions in the tpl class
43 1.7893691062927 After Get Options After the call to getOptions in the tpl class
44 1.7894711494446 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.7894911766052 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.0269570350647 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.0269601345062 Product Info: Before Template Display Before the template is displayed
48 2.3823480606079 Product Info: After Template Display After the template is displayed
49 2.3823630809784 Finalizing debug Before the debug is output to the page.
50 2.3823750019073 End of App This is the end of the app logging, final timestamp


Query Debug - 324 Database Queries. Total time 1.1905 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.00076723098754883 
SELECT parameter, value FROM parameters
2 0.0054 0.0054230690002441 
SELECT * FROM `bad_bots`
3 0.0004 0.00041794776916504 
SET time_zone = 'Europe/London'
4 0.0006 0.00064206123352051 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0010 0.0010440349578857 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"18.116.27.40\";}'
6 0.0011 0.0010530948638916 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1743753596'
7 0.0007 0.0006871223449707 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00040197372436523 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00047206878662109 
SELECT id FROM pages WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-elixir-des-petits-lutins-tube-100-g' LIMIT 1
10 0.0005 0.00052690505981445 
SELECT id FROM products WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-elixir-des-petits-lutins-tube-100-g' AND hidden = 0 LIMIT 1
11 0.0014 0.0014078617095947 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0302 0.030200958251953 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00058984756469727 
SELECT * FROM pages WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-elixir-des-petits-lutins-tube-100-g'
14 0.0006 0.00064182281494141 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0008 0.00078201293945312 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0090 0.0090498924255371 
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.00052309036254883 
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.00040221214294434 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00042104721069336 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0172 0.01720404624939 
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.0009 0.00092315673828125 
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.0009 0.00089192390441895 
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.0007 0.00066995620727539 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00053715705871582 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0062 0.0062019824981689 
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.0007 0.00070381164550781 
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.0006 0.00058102607727051 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0012 0.0012331008911133 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0050 0.0049779415130615 
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.0006 0.00055599212646484 
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.0006 0.00062084197998047 
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.0005040168762207 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00045299530029297 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0018 0.0018360614776611 
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.00063180923461914 
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.0006 0.00058698654174805 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00048708915710449 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0019 0.0019371509552002 
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.0014 0.0014159679412842 
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.0007 0.00070095062255859 
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.0006 0.00061511993408203 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00053310394287109 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0009 0.00093889236450195 
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.0006 0.00056719779968262 
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.0006 0.00055599212646484 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00048589706420898 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00085306167602539 
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.0008 0.00080490112304688 
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.0008 0.00076508522033691 
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.0009 0.00091218948364258 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00052094459533691 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.00082898139953613 
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.0009 0.00094699859619141 
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.0006 0.00062894821166992 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.0005180835723877 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00075316429138184 
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.0006 0.00057101249694824 
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.0006 0.00064492225646973 
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.00052905082702637 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00050711631774902 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00075292587280273 
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.0005 0.00050091743469238 
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.0005 0.00045299530029297 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00054001808166504 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00084900856018066 
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.0008 0.00076508522033691 
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.00057196617126465 
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.0006 0.00055789947509766 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00050711631774902 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0007 0.00065708160400391 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0025 0.0025219917297363 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00063705444335938 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00059986114501953 
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.00040197372436523 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0015 0.0014808177947998 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0013 0.0013439655303955 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.8312 0.83124017715454 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.116.27.40') >= INET_ATON(ip_start) AND INET_ATON('18.116.27.40') <= INET_ATON(ip_end)
78 0.0010 0.001021146774292 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0004 0.00039410591125488 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00060200691223145 
SELECT * FROM products WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-elixir-des-petits-lutins-tube-100-g'
81 0.0004 0.00036382675170898 
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1204
82 0.0004 0.00044512748718262 
SELECT * FROM manufacturers WHERE id = '261'
83 0.0004 0.00041913986206055 
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
84 0.0015 0.0014610290527344 
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '261' LIMIT 1
85 0.0008 0.00075793266296387 
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '261' ORDER BY RAND() LIMIT 1
86 0.0004 0.00037407875061035 
SELECT * FROM productimages WHERE product_id = '1289' ORDER BY sortorder ASC
87 0.0004 0.0003969669342041 
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
88 0.0004 0.0004119873046875 
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '261'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0
89 0.0003 0.00028896331787109 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '261'
90 0.0004 0.0003809928894043 
SELECT category_id FROM products_categories WHERE product_id = '1204'
91 0.0004 0.00041103363037109 
SELECT * FROM categories WHERE id = '27'
92 0.0034 0.0034441947937012 
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.00037789344787598 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0003 0.00028181076049805 
SELECT id FROM categories WHERE parent_id = '27'
95 0.0038 0.0038399696350098 
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.0005 0.00048708915710449 
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.0004 0.00044512748718262 
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.0005 0.00047683715820312 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00048303604125977 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
100 0.0005 0.00050997734069824 
SELECT * FROM product_image_select WHERE product_id = '1204'
101 0.0003 0.00033879280090332 
SELECT * FROM productcustomimages WHERE product_id = '1204'
102 0.0013 0.0012991428375244 
SELECT * FROM productfeeds WHERE product_id = '1204' ORDER BY item_date DESC
103 0.0006 0.0006401538848877 
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0021 0.0021469593048096 
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1204' AND t.hidden = 0 AND display_product = 1
105 0.0014 0.0014429092407227 
SELECT * FROM productamazoncontent WHERE product_id = '1204'
106 0.0008 0.00080704689025879 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
107 0.0005 0.0004570484161377 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00037193298339844 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00036001205444336 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0005 0.00046300888061523 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
111 0.0089 0.0088701248168945 
SELECT *, MATCH (description, title) AGAINST ('jardins de gaa' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('jardins de gaa' IN BOOLEAN MODE) AND 1204 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
112 0.0006 0.00057601928710938 
SELECT *, MATCH (description, title) AGAINST ('jardins de gaa' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('jardins de gaa' IN BOOLEAN MODE) AND 1204 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
113 0.0005 0.00049090385437012 
SELECT *, MATCH (description, title) AGAINST ('jardins de gaa' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('jardins de gaa' IN BOOLEAN MODE) AND 1204 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0004 0.00042605400085449 
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
115 0.0005 0.00053906440734863 
SELECT * FROM product_image_select WHERE product_id = '1095'
116 0.0004 0.00035309791564941 
SELECT * FROM productcustomimages WHERE product_id = '1095'
117 0.0010 0.0009920597076416 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
118 0.0005 0.00049018859863281 
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0004 0.00043296813964844 
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0004 0.00038290023803711 
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0005 0.00048112869262695 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
122 0.0005 0.00052094459533691 
SELECT * FROM product_image_select WHERE product_id = '1246'
123 0.0003 0.00033807754516602 
SELECT * FROM productcustomimages WHERE product_id = '1246'
124 0.0007 0.0007178783416748 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
125 0.0004 0.00042915344238281 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0004 0.0003662109375 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0004 0.00041890144348145 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0004 0.00041508674621582 
SELECT * FROM productimages WHERE product_id = '4678' ORDER BY sortorder ASC
129 0.0014 0.0014400482177734 
SELECT * FROM product_image_select WHERE product_id = '4678'
130 0.0005 0.00046586990356445 
SELECT * FROM productcustomimages WHERE product_id = '4678'
131 0.0012 0.0011639595031738 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4678' AND a.name = n.originalname
132 0.0005 0.00046014785766602 
SELECT * FROM productoffers WHERE product_id = '4678' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00041604042053223 
SELECT * FROM productoffers
                WHERE product_id = '4678' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0006 0.00059390068054199 
SELECT value FROM productattributes WHERE product_id = '4678' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0004 0.00044703483581543 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
136 0.0005 0.00052809715270996 
SELECT * FROM product_image_select WHERE product_id = '1204'
137 0.0004 0.00035309791564941 
SELECT * FROM productcustomimages WHERE product_id = '1204'
138 0.0007 0.00066304206848145 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
139 0.0004 0.00044012069702148 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0004 0.00039005279541016 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0004 0.00038003921508789 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0091 0.0091211795806885 
SELECT *, MATCH (description, title) AGAINST ('gaa jardins de' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('gaa jardins de' IN BOOLEAN MODE) AND 1204 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
143 0.0008 0.00078797340393066 
SELECT *, MATCH (description, title) AGAINST ('gaa jardins de' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('gaa jardins de' IN BOOLEAN MODE) AND 1204 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
144 0.0005 0.0004580020904541 
SELECT *, MATCH (description, title) AGAINST ('gaa jardins de' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('gaa jardins de' IN BOOLEAN MODE) AND 1204 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
145 0.0005 0.00046706199645996 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
146 0.0005 0.00054788589477539 
SELECT * FROM product_image_select WHERE product_id = '1204'
147 0.0004 0.00040292739868164 
SELECT * FROM productcustomimages WHERE product_id = '1204'
148 0.0007 0.00072503089904785 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
149 0.0004 0.00039386749267578 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0004 0.00037503242492676 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00038003921508789 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0005 0.0004730224609375 
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
153 0.0005 0.00051093101501465 
SELECT * FROM product_image_select WHERE product_id = '1095'
154 0.0003 0.00032591819763184 
SELECT * FROM productcustomimages WHERE product_id = '1095'
155 0.0008 0.00079202651977539 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
156 0.0004 0.00040602684020996 
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0003 0.00034093856811523 
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0004 0.0004279613494873 
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0005 0.00049805641174316 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
160 0.0005 0.00050997734069824 
SELECT * FROM product_image_select WHERE product_id = '1246'
161 0.0003 0.00031185150146484 
SELECT * FROM productcustomimages WHERE product_id = '1246'
162 0.0008 0.00077605247497559 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
163 0.0004 0.00040197372436523 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0004 0.00035786628723145 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0004 0.00037598609924316 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0089 0.0089449882507324 
SELECT *, MATCH (description, title) AGAINST ('petits lutins tube' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('petits lutins tube' IN BOOLEAN MODE) AND 1204 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
167 0.0005 0.00051784515380859 
SELECT *, MATCH (description, title) AGAINST ('petits lutins tube' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('petits lutins tube' IN BOOLEAN MODE) AND 1204 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
168 0.0009 0.00093793869018555 
SELECT *, MATCH (description, title) AGAINST ('petits lutins tube' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('petits lutins tube' IN BOOLEAN MODE) AND 1204 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
169 0.0009 0.00094199180603027 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
170 0.0012 0.0012178421020508 
SELECT * FROM product_image_select WHERE product_id = '1246'
171 0.0008 0.00075697898864746 
SELECT * FROM productcustomimages WHERE product_id = '1246'
172 0.0023 0.002269983291626 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
173 0.0009 0.00088691711425781 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0007 0.00072979927062988 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0011 0.0011470317840576 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0011 0.0010688304901123 
SELECT * FROM productimages WHERE product_id = '3666' ORDER BY sortorder ASC
177 0.0013 0.0012619495391846 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3666' AND p.id = pi.product_id ORDER BY pi.sortorder
178 0.0013 0.0012531280517578 
SELECT * FROM product_image_select WHERE product_id = '3666'
179 0.0009 0.00089097023010254 
SELECT * FROM productcustomimages WHERE product_id = '3666'
180 0.0012 0.0011649131774902 
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 = '3666'
                GROUP BY o.product_id
181 0.0011 0.0011401176452637 
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     = '3666'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
182 0.0007 0.00072383880615234 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3666
183 0.0023 0.0022859573364258 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3666' AND a.name = n.originalname
184 0.0006 0.00064897537231445 
SELECT * FROM productoffers WHERE product_id = '3666' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0005 0.00048184394836426 
SELECT * FROM productoffers
                WHERE product_id = '3666' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0004 0.0004270076751709 
SELECT * FROM productoffers
                WHERE product_id = 3666
                ORDER BY price ASC LIMIT 1
187 0.0005 0.00046706199645996 
SELECT value FROM productattributes
                WHERE product_id = '3666'
                AND name = 'ListPriceAmount'
188 0.0006 0.00057291984558105 
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 = '3666'
                GROUP BY o.product_id
189 0.0008 0.00082206726074219 
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     = '3666'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
190 0.0005 0.00048184394836426 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3666
191 0.0007 0.00072693824768066 
SELECT value FROM productattributes WHERE product_id = '3666' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0008 0.00079798698425293 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3666'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
193 0.0006 0.00056195259094238 
SELECT * FROM productimages WHERE product_id = '2498' ORDER BY sortorder ASC
194 0.0009 0.00091695785522461 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2498' AND p.id = pi.product_id ORDER BY pi.sortorder
195 0.0009 0.00087308883666992 
SELECT * FROM product_image_select WHERE product_id = '2498'
196 0.0005 0.00046396255493164 
SELECT * FROM productcustomimages WHERE product_id = '2498'
197 0.0006 0.00063800811767578 
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 = '2498'
                GROUP BY o.product_id
198 0.0008 0.00078511238098145 
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     = '2498'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
199 0.0007 0.00069379806518555 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2498
200 0.0024 0.0024120807647705 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2498' AND a.name = n.originalname
201 0.0014 0.0014090538024902 
SELECT * FROM productoffers WHERE product_id = '2498' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0026 0.002586841583252 
SELECT * FROM productoffers
                WHERE product_id = '2498' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0024 0.0024218559265137 
SELECT * FROM productoffers
                WHERE product_id = 2498
                ORDER BY price ASC LIMIT 1
204 0.0024 0.0023729801177979 
SELECT value FROM productattributes
                WHERE product_id = '2498'
                AND name = 'ListPriceAmount'
205 0.0011 0.0010750293731689 
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 = '2498'
                GROUP BY o.product_id
206 0.0009 0.00086712837219238 
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     = '2498'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
207 0.0005 0.00050687789916992 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2498
208 0.0006 0.00061893463134766 
SELECT value FROM productattributes WHERE product_id = '2498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209 0.0007 0.00066113471984863 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2498'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
210 0.0106 0.01056981086731 
SELECT *, MATCH (description, title) AGAINST ('de gaa jardins' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('de gaa jardins' IN BOOLEAN MODE) AND 1204 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
211 0.0006 0.00058603286743164 
SELECT *, MATCH (description, title) AGAINST ('de gaa jardins' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('de gaa jardins' IN BOOLEAN MODE) AND 1204 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
212 0.0006 0.0006101131439209 
SELECT *, MATCH (description, title) AGAINST ('de gaa jardins' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('de gaa jardins' IN BOOLEAN MODE) AND 1204 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
213 0.0005 0.00050497055053711 
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
214 0.0006 0.00063300132751465 
SELECT * FROM product_image_select WHERE product_id = '1095'
215 0.0004 0.00041294097900391 
SELECT * FROM productcustomimages WHERE product_id = '1095'
216 0.0011 0.0010950565338135 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
217 0.0006 0.00055098533630371 
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0004 0.00041699409484863 
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0005 0.00048995018005371 
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0100 0.010022163391113 
SELECT *, MATCH (description, title) AGAINST ('rooibos aromatisé fraise' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos aromatisé fraise' IN BOOLEAN MODE) AND 1204 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
221 0.0006 0.00062108039855957 
SELECT *, MATCH (description, title) AGAINST ('rooibos aromatisé fraise' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos aromatisé fraise' IN BOOLEAN MODE) AND 1204 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
222 0.0005 0.00054192543029785 
SELECT *, MATCH (description, title) AGAINST ('rooibos aromatisé fraise' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos aromatisé fraise' IN BOOLEAN MODE) AND 1204 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
223 0.0005 0.00047516822814941 
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
224 0.0006 0.00064301490783691 
SELECT * FROM product_image_select WHERE product_id = '878'
225 0.0004 0.00043487548828125 
SELECT * FROM productcustomimages WHERE product_id = '878'
226 0.0012 0.001183032989502 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
227 0.0004 0.00044798851013184 
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0004 0.00042891502380371 
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0004 0.00044608116149902 
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0005 0.00046205520629883 
SELECT id,asin FROM products WHERE parent_id = 1204
231 0.0004 0.00042009353637695 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1204' ORDER BY timestamp DESC
232 0.0005 0.00049710273742676 
SELECT category_id FROM products_categories WHERE product_id = '1204'
233 0.0004 0.0004279613494873 
SELECT * FROM categories WHERE id = '27'
234 0.0037 0.0037200450897217 
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
235 0.0004 0.00040483474731445 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
236 0.0003 0.00029301643371582 
SELECT id FROM categories WHERE parent_id = '27'
237 0.0039 0.0038840770721436 
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
238 0.0005 0.00051188468933105 
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
239 0.0007 0.00066089630126953 
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
240 0.0005 0.00047087669372559 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
241 0.0007 0.00068402290344238 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
242 0.0004 0.00042104721069336 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0004 0.00037097930908203 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0005 0.00048208236694336 
SELECT * FROM products WHERE id = '1204'
245 0.0004 0.00043988227844238 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0006 0.00059294700622559 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
247 0.0004 0.00035691261291504 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0003 0.00033688545227051 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0004 0.00040197372436523 
SELECT category_id FROM products_categories WHERE product_id = '1204' AND prod_type = 'amz'
250 0.0004 0.00036406517028809 
SELECT parent_id FROM categories WHERE id = '27'
251 0.0003 0.00029087066650391 
SELECT * FROM categories WHERE id = '27'
252 0.0037 0.0037028789520264 
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
253 0.0004 0.00042295455932617 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
254 0.0003 0.00028800964355469 
SELECT id FROM categories WHERE parent_id = '27'
255 0.0041 0.004072904586792 
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
256 0.0005 0.00047421455383301 
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
257 0.0005 0.00045299530029297 
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
258 0.0004 0.00040483474731445 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
259 0.0005 0.00045394897460938 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
260 0.0004 0.00036478042602539 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
261 0.0003 0.00028705596923828 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
262 0.0130 0.012985944747925 
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
263 0.0005 0.00054597854614258 
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
264 0.0005 0.00049209594726562 
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
265 0.0005 0.00045084953308105 
SELECT * FROM products WHERE id = 1626
266 0.0004 0.00036311149597168 
SELECT * FROM products WHERE id = 4041
267 0.0003 0.00031089782714844 
SELECT * FROM products WHERE id = 4312
268 0.0003 0.00033807754516602 
SELECT * FROM products WHERE id = 777
269 0.0003 0.0003199577331543 
SELECT * FROM products WHERE id = 3881
270 0.0003 0.00033378601074219 
SELECT * FROM products WHERE id = 4213
271 0.0003 0.00034904479980469 
SELECT * FROM products WHERE id = '1626'
272 0.0004 0.00038886070251465 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
273 0.0006 0.00055909156799316 
SELECT * FROM product_image_select WHERE product_id = '1626'
274 0.0004 0.00035595893859863 
SELECT * FROM productcustomimages WHERE product_id = '1626'
275 0.0008 0.00077199935913086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
276 0.0004 0.00042891502380371 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
277 0.0003 0.00034213066101074 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
278 0.0004 0.00040102005004883 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
279 0.0004 0.00043201446533203 
SELECT * FROM products WHERE id = '4041'
280 0.0004 0.00041103363037109 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
281 0.0006 0.00060701370239258 
SELECT * FROM product_image_select WHERE product_id = '4041'
282 0.0004 0.0003821849822998 
SELECT * FROM productcustomimages WHERE product_id = '4041'
283 0.0015 0.0014970302581787 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
284 0.0005 0.00048208236694336 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
285 0.0004 0.00041604042053223 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
286 0.0004 0.00044107437133789 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
287 0.0005 0.00052905082702637 
SELECT * FROM products WHERE id = '4312'
288 0.0004 0.00044989585876465 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
289 0.0006 0.00062108039855957 
SELECT * FROM product_image_select WHERE product_id = '4312'
290 0.0004 0.00037217140197754 
SELECT * FROM productcustomimages WHERE product_id = '4312'
291 0.0013 0.0013329982757568 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
292 0.0004 0.00044417381286621 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
293 0.0004 0.00037503242492676 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
294 0.0005 0.00046777725219727 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
295 0.0005 0.00048303604125977 
SELECT * FROM products WHERE id = '777'
296 0.0004 0.00043702125549316 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
297 0.0007 0.00066518783569336 
SELECT * FROM product_image_select WHERE product_id = '777'
298 0.0004 0.00039100646972656 
SELECT * FROM productcustomimages WHERE product_id = '777'
299 0.0013 0.0012669563293457 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
300 0.0005 0.00047492980957031 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
301 0.0004 0.00041699409484863 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
302 0.0005 0.00045013427734375 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
303 0.0005 0.00051999092102051 
SELECT * FROM products WHERE id = '3881'
304 0.0005 0.00053286552429199 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
305 0.0007 0.0006568431854248 
SELECT * FROM product_image_select WHERE product_id = '3881'
306 0.0004 0.00040698051452637 
SELECT * FROM productcustomimages WHERE product_id = '3881'
307 0.0015 0.0014581680297852 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
308 0.0005 0.00049901008605957 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
309 0.0004 0.00039911270141602 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
310 0.0004 0.00044512748718262 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
311 0.0005 0.00047206878662109 
SELECT * FROM products WHERE id = '4213'
312 0.0005 0.00051712989807129 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
313 0.0006 0.00059008598327637 
SELECT * FROM product_image_select WHERE product_id = '4213'
314 0.0004 0.00040006637573242 
SELECT * FROM productcustomimages WHERE product_id = '4213'
315 0.0016 0.0015809535980225 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
316 0.0005 0.00050592422485352 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
317 0.0004 0.00042486190795898 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
318 0.0005 0.00046205520629883 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
319 0.0008 0.00077986717224121 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
320 0.0007 0.00074195861816406 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
321 0.0017 0.0016789436340332 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
322 0.0007 0.00065708160400391 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
323 0.0006 0.00057291984558105 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
324 0.0021 0.0021419525146484 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'