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
1.5141282081604 324 0.9473 0


No Amazon API Requests Made.


App Debug - Total Time 1.5141282081604 seconds

Number Time From Start Name Description
1 0.52955508232117 Initialise Initialise FSB Function
2 0.53339099884033 App Controller Start Start of the App controller (called before the controller of every page)
3 0.57323002815247 Start of getCategoryListByGroup Function Before first category groups query
4 0.57376217842102 After initial query Before first category groups query
5 0.57376408576965 Get Category List for Group Before the call to getCategoryList function
6 0.5737681388855 Start of GetCategoryList function Start of the function
7 0.57377099990845 Before getting categories Query to get specific category list
8 0.57458114624023 After getting categories Query to get specific category list
9 0.57458209991455 Before getting category custom Before call to function getCategoryCustom
10 0.59476017951965 After getting category custom After call to function getCategoryCustom
11 0.5947642326355 Before getting category custom Before call to function getCategoryCustom
12 0.60982513427734 After getting category custom After call to function getCategoryCustom
13 0.60982704162598 Before getting category custom Before call to function getCategoryCustom
14 0.61904120445251 After getting category custom After call to function getCategoryCustom
15 0.61904406547546 Before getting category custom Before call to function getCategoryCustom
16 0.6242561340332 After getting category custom After call to function getCategoryCustom
17 0.62425923347473 Before getting category custom Before call to function getCategoryCustom
18 0.62973523139954 After getting category custom After call to function getCategoryCustom
19 0.62973713874817 Before getting category custom Before call to function getCategoryCustom
20 0.63486123085022 After getting category custom After call to function getCategoryCustom
21 0.63486409187317 End of GetCategoryList function End of the function
22 0.63487219810486 Get Category List for Group Before the call to getCategoryList function
23 0.63487410545349 Start of GetCategoryList function Start of the function
24 0.63487720489502 Before getting categories Query to get specific category list
25 0.63544917106628 End of getCategoryListByGroup Function Before return()
26 1.1621470451355 App Controller End End of the App controller (called before the controller of every page)
27 1.1628501415253 Product Start Start of the product info controller
28 1.1645801067352 Cache file not found Starting get product details
29 1.1914730072021 Related products Start getting related products if enabled
30 1.1914751529694 Related Products Start Before the related products are found
31 1.191477060318 Related Products Keywords Before the related product keywords are found
32 1.1914811134338 Create Keyword List Function Start of function
33 1.1915290355682 Create Keyword List Function After looping provided content - 42 keywords found
34 1.1932320594788 Create Keyword List Function After looping initial keyword list - 38 keywords remaining
35 1.1932411193848 Create Keyword List Function After reducing keyword list
36 1.1934740543365 Create Keyword List Function After selecting by scoring keywords
37 1.1934790611267 Create Keyword List Function After final loop of keywords
38 1.1934812068939 Related Products Keywords After the related product keywords are found
39 1.3708341121674 Related Products End After the related products are found
40 1.4153201580048 Product End End of the product info controller (Product Info)
41 1.4167790412903 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4181680679321 Before Get Options Before the call to getOptions in the tpl class
43 1.4803521633148 After Get Options After the call to getOptions in the tpl class
44 1.4804651737213 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4804940223694 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4928240776062 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.492828130722 Product Info: Before Template Display Before the template is displayed
48 1.5141041278839 Product Info: After Template Display After the template is displayed
49 1.5141160488129 Finalizing debug Before the debug is output to the page.
50 1.5141270160675 End of App This is the end of the app logging, final timestamp


Query Debug - 324 Database Queries. Total time 0.9473 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0016 0.0015599727630615 
SELECT parameter, value FROM parameters
2 0.0037 0.0036771297454834 
SELECT * FROM `bad_bots`
3 0.0004 0.00039815902709961 
SET time_zone = 'Europe/London'
4 0.0007 0.00069189071655273 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0007 0.00071406364440918 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.149.255.10\";}'
6 0.0006 0.00063705444335938 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722058715'
7 0.0013 0.0013070106506348 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00074410438537598 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0012 0.0011570453643799 
SELECT id FROM pages WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-elixir-des-petits-lutins-tube-100-g' LIMIT 1
10 0.0012 0.0012078285217285 
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.0036 0.0035831928253174 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0353 0.035329818725586 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00049686431884766 
SELECT * FROM pages WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-elixir-des-petits-lutins-tube-100-g'
14 0.0005 0.00051999092102051 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0008 0.00079011917114258 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0062 0.0061600208282471 
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.0009 0.00086116790771484 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0005 0.00051403045654297 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0006 0.00055813789367676 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0089 0.0089371204376221 
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.00085306167602539 
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.00074410438537598 
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.00067305564880371 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0008 0.00075197219848633 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0052 0.0051770210266113 
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.00067687034606934 
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.00060701370239258 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0006 0.0005948543548584 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0053 0.0052859783172607 
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.0008 0.00076699256896973 
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.0007 0.0007169246673584 
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.0006 0.00060105323791504 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00054001808166504 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0023 0.0023150444030762 
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.0008 0.00079107284545898 
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.0005800724029541 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0006 0.0005958080291748 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0022 0.0022091865539551 
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.0007 0.00065398216247559 
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.00071597099304199 
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.00058197975158691 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0007 0.0006709098815918 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00072693824768066 
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.00056099891662598 
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.00042390823364258 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00049209594726562 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00075387954711914 
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.00058293342590332 
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.0006 0.00060892105102539 
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.00052094459533691 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.0004570484161377 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00063800811767578 
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.00053596496582031 
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.00043201446533203 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0007 0.00069618225097656 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00081014633178711 
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.00063109397888184 
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.0005791187286377 
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.00050687789916992 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0006 0.00056195259094238 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.0006561279296875 
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.00054097175598145 
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.00051999092102051 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00046420097351074 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00075411796569824 
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.0005 0.00051593780517578 
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.0005948543548584 
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.0005 0.00051712989807129 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00046992301940918 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00056099891662598 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0016 0.0016260147094727 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00064611434936523 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0068 0.0068109035491943 
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.0027 0.0026500225067139 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011131763458252 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.0012130737304688 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5091 0.50913095474243 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.149.255.10') >= INET_ATON(ip_start) AND INET_ATON('3.149.255.10') <= INET_ATON(ip_end)
78 0.0011 0.0011169910430908 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0004 0.00044393539428711 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00066304206848145 
SELECT * FROM products WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-elixir-des-petits-lutins-tube-100-g'
81 0.0004 0.00042009353637695 
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1204
82 0.0006 0.00060510635375977 
SELECT * FROM manufacturers WHERE id = '261'
83 0.0005 0.00053501129150391 
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
84 0.0005 0.00046205520629883 
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '261' LIMIT 1
85 0.0007 0.0006558895111084 
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.0005 0.00054001808166504 
SELECT * FROM productimages WHERE product_id = '1073' ORDER BY sortorder ASC
87 0.0008 0.00076007843017578 
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
88 0.0006 0.00063586235046387 
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.0004 0.00039792060852051 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '261'
90 0.0006 0.00056695938110352 
SELECT category_id FROM products_categories WHERE product_id = '1204'
91 0.0006 0.00059986114501953 
SELECT * FROM categories WHERE id = '27'
92 0.0045 0.0045309066772461 
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.0006 0.00057220458984375 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00038695335388184 
SELECT id FROM categories WHERE parent_id = '27'
95 0.0049 0.0049450397491455 
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.0008 0.00075411796569824 
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.0008 0.00080513954162598 
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.00061988830566406 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0007 0.00065302848815918 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
100 0.0008 0.00075984001159668 
SELECT * FROM product_image_select WHERE product_id = '1204'
101 0.0005 0.00049400329589844 
SELECT * FROM productcustomimages WHERE product_id = '1204'
102 0.0005 0.00052404403686523 
SELECT * FROM productfeeds WHERE product_id = '1204' ORDER BY item_date DESC
103 0.0009 0.00092792510986328 
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.0008 0.00080680847167969 
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.0006 0.00057411193847656 
SELECT * FROM productamazoncontent WHERE product_id = '1204'
106 0.0009 0.00094103813171387 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
107 0.0006 0.00058197975158691 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0005 0.0004570484161377 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0005 0.0005030632019043 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0006 0.00064396858215332 
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.0143 0.014328956604004 
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.0070 0.0070359706878662 
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.0025 0.0024809837341309 
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.0010 0.001039981842041 
SELECT * FROM productimages WHERE product_id = '4678' ORDER BY sortorder ASC
115 0.0014 0.0014021396636963 
SELECT * FROM product_image_select WHERE product_id = '4678'
116 0.0007 0.00071883201599121 
SELECT * FROM productcustomimages WHERE product_id = '4678'
117 0.0031 0.0031437873840332 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4678' AND a.name = n.originalname
118 0.0012 0.0011661052703857 
SELECT * FROM productoffers WHERE product_id = '4678' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0008 0.00083112716674805 
SELECT * FROM productoffers
                WHERE product_id = '4678' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0010 0.0010321140289307 
SELECT value FROM productattributes WHERE product_id = '4678' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0013 0.0012810230255127 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
122 0.0016 0.0015850067138672 
SELECT * FROM product_image_select WHERE product_id = '1246'
123 0.0010 0.0010449886322021 
SELECT * FROM productcustomimages WHERE product_id = '1246'
124 0.0020 0.0019640922546387 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
125 0.0009 0.0009000301361084 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0007 0.00065088272094727 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0007 0.00074601173400879 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0009 0.00087308883666992 
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
129 0.0011 0.0010890960693359 
SELECT * FROM product_image_select WHERE product_id = '1095'
130 0.0007 0.00069499015808105 
SELECT * FROM productcustomimages WHERE product_id = '1095'
131 0.0019 0.0018770694732666 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
132 0.0009 0.00091886520385742 
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0006 0.00058603286743164 
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0007 0.0006721019744873 
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0010 0.0010428428649902 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
136 0.0008 0.00083303451538086 
SELECT * FROM product_image_select WHERE product_id = '1204'
137 0.0005 0.0005340576171875 
SELECT * FROM productcustomimages WHERE product_id = '1204'
138 0.0010 0.0010418891906738 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
139 0.0006 0.00064206123352051 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00054788589477539 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0006 0.00056600570678711 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0123 0.012288093566895 
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.0009 0.00092887878417969 
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.0009 0.0008690357208252 
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.0010 0.0010371208190918 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
146 0.0010 0.00096416473388672 
SELECT * FROM product_image_select WHERE product_id = '1204'
147 0.0073 0.0073001384735107 
SELECT * FROM productcustomimages WHERE product_id = '1204'
148 0.0012 0.0011518001556396 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
149 0.0008 0.00075411796569824 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0006 0.00055599212646484 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0005 0.00053811073303223 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0007 0.00069403648376465 
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
153 0.0009 0.00085902214050293 
SELECT * FROM product_image_select WHERE product_id = '1095'
154 0.0006 0.00055408477783203 
SELECT * FROM productcustomimages WHERE product_id = '1095'
155 0.0014 0.001384973526001 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
156 0.0006 0.00064206123352051 
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0005 0.00047492980957031 
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0006 0.00062394142150879 
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0007 0.00067901611328125 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
160 0.0007 0.00073504447937012 
SELECT * FROM product_image_select WHERE product_id = '1246'
161 0.0006 0.00058102607727051 
SELECT * FROM productcustomimages WHERE product_id = '1246'
162 0.0009 0.00091409683227539 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
163 0.0006 0.00056719779968262 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0005 0.00051593780517578 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0005 0.00050210952758789 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0095 0.009458065032959 
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.0008 0.00081014633178711 
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.0008 0.00077104568481445 
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.0008 0.0007929801940918 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
170 0.0007 0.00071382522583008 
SELECT * FROM product_image_select WHERE product_id = '1246'
171 0.0005 0.00045609474182129 
SELECT * FROM productcustomimages WHERE product_id = '1246'
172 0.0010 0.0010199546813965 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
173 0.0006 0.00057387351989746 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0005 0.00054287910461426 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0005 0.0004570484161377 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0006 0.00057506561279297 
SELECT * FROM productimages WHERE product_id = '3666' ORDER BY sortorder ASC
177 0.0007 0.00070500373840332 
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.0016 0.0015530586242676 
SELECT * FROM product_image_select WHERE product_id = '3666'
179 0.0011 0.0010600090026855 
SELECT * FROM productcustomimages WHERE product_id = '3666'
180 0.0015 0.0014729499816895 
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.0079 0.0079479217529297 
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.0009 0.00094199180603027 
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.0019 0.0019049644470215 
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.00062203407287598 
SELECT * FROM productoffers WHERE product_id = '3666' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0009 0.00094008445739746 
SELECT * FROM productoffers
                WHERE product_id = '3666' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0008 0.00080204010009766 
SELECT * FROM productoffers
                WHERE product_id = 3666
                ORDER BY price ASC LIMIT 1
187 0.0010 0.00099992752075195 
SELECT value FROM productattributes
                WHERE product_id = '3666'
                AND name = 'ListPriceAmount'
188 0.0008 0.00080585479736328 
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.0013 0.0013139247894287 
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.0007 0.00069999694824219 
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.0010 0.00095319747924805 
SELECT value FROM productattributes WHERE product_id = '3666' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0009 0.00090813636779785 
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.0009 0.00087690353393555 
SELECT * FROM productimages WHERE product_id = '2498' ORDER BY sortorder ASC
194 0.0009 0.00089883804321289 
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.0011 0.0010530948638916 
SELECT * FROM product_image_select WHERE product_id = '2498'
196 0.0007 0.0006561279296875 
SELECT * FROM productcustomimages WHERE product_id = '2498'
197 0.0008 0.0007779598236084 
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.0010 0.0009760856628418 
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.0006 0.000579833984375 
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.0015 0.0015099048614502 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2498' AND a.name = n.originalname
201 0.0005 0.00047898292541504 
SELECT * FROM productoffers WHERE product_id = '2498' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0005 0.00045680999755859 
SELECT * FROM productoffers
                WHERE product_id = '2498' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0004 0.00043797492980957 
SELECT * FROM productoffers
                WHERE product_id = 2498
                ORDER BY price ASC LIMIT 1
204 0.0006 0.00058603286743164 
SELECT value FROM productattributes
                WHERE product_id = '2498'
                AND name = 'ListPriceAmount'
205 0.0006 0.00058603286743164 
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.00087499618530273 
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.0006 0.00062894821166992 
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.0008 0.00075602531433105 
SELECT value FROM productattributes WHERE product_id = '2498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209 0.0008 0.00083494186401367 
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.0109 0.010926961898804 
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.0009 0.00087904930114746 
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.0007 0.00074005126953125 
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.00051283836364746 
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
214 0.0006 0.000640869140625 
SELECT * FROM product_image_select WHERE product_id = '1095'
215 0.0004 0.00043916702270508 
SELECT * FROM productcustomimages WHERE product_id = '1095'
216 0.0010 0.00096797943115234 
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.00060796737670898 
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0004 0.00043201446533203 
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0004 0.00041580200195312 
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0101 0.010084867477417 
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.0009 0.000946044921875 
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.0006 0.00061607360839844 
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.00050187110900879 
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
224 0.0007 0.0006859302520752 
SELECT * FROM product_image_select WHERE product_id = '878'
225 0.0005 0.00049090385437012 
SELECT * FROM productcustomimages WHERE product_id = '878'
226 0.0012 0.0011641979217529 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
227 0.0005 0.00052905082702637 
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0005 0.00047016143798828 
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0004 0.00043296813964844 
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0005 0.00053691864013672 
SELECT id,asin FROM products WHERE parent_id = 1204
231 0.0005 0.00050997734069824 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1204' ORDER BY timestamp DESC
232 0.0005 0.00053191184997559 
SELECT category_id FROM products_categories WHERE product_id = '1204'
233 0.0005 0.00053787231445312 
SELECT * FROM categories WHERE id = '27'
234 0.0037 0.0036721229553223 
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.0005 0.0005040168762207 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
236 0.0004 0.00044894218444824 
SELECT id FROM categories WHERE parent_id = '27'
237 0.0037 0.0037441253662109 
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.0006 0.00063610076904297 
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.0006 0.00060701370239258 
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.0006 0.00055599212646484 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
241 0.0009 0.00085186958312988 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
242 0.0006 0.00063800811767578 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0005 0.00050592422485352 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0007 0.00068902969360352 
SELECT * FROM products WHERE id = '1204'
245 0.0005 0.00052785873413086 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0009 0.00087690353393555 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
247 0.0005 0.00046896934509277 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0005 0.00046110153198242 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0005 0.00050997734069824 
SELECT category_id FROM products_categories WHERE product_id = '1204' AND prod_type = 'amz'
250 0.0005 0.0005040168762207 
SELECT parent_id FROM categories WHERE id = '27'
251 0.0004 0.00041317939758301 
SELECT * FROM categories WHERE id = '27'
252 0.0042 0.0042212009429932 
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.0005 0.00053811073303223 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
254 0.0009 0.00092792510986328 
SELECT id FROM categories WHERE parent_id = '27'
255 0.0118 0.011759996414185 
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.0056 0.005587100982666 
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.0015 0.0014679431915283 
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.0009 0.00085687637329102 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
259 0.0008 0.00082492828369141 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
260 0.0007 0.00070309638977051 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
261 0.0006 0.00062918663024902 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
262 0.0190 0.018963813781738 
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.0010 0.00095677375793457 
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.0008 0.00077605247497559 
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.0006 0.00063014030456543 
SELECT * FROM products WHERE id = 1626
266 0.0006 0.00061702728271484 
SELECT * FROM products WHERE id = 4041
267 0.0006 0.00057196617126465 
SELECT * FROM products WHERE id = 4312
268 0.0004 0.00041508674621582 
SELECT * FROM products WHERE id = 777
269 0.0005 0.00046920776367188 
SELECT * FROM products WHERE id = 3881
270 0.0006 0.0006101131439209 
SELECT * FROM products WHERE id = 4213
271 0.0007 0.00067591667175293 
SELECT * FROM products WHERE id = '1626'
272 0.0006 0.00059103965759277 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
273 0.0006 0.000640869140625 
SELECT * FROM product_image_select WHERE product_id = '1626'
274 0.0005 0.0005180835723877 
SELECT * FROM productcustomimages WHERE product_id = '1626'
275 0.0009 0.00087881088256836 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
276 0.0006 0.00056004524230957 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
277 0.0005 0.00045609474182129 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
278 0.0005 0.00049901008605957 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
279 0.0006 0.00060892105102539 
SELECT * FROM products WHERE id = '4041'
280 0.0005 0.00052094459533691 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
281 0.0007 0.00070095062255859 
SELECT * FROM product_image_select WHERE product_id = '4041'
282 0.0004 0.00043797492980957 
SELECT * FROM productcustomimages WHERE product_id = '4041'
283 0.0013 0.0012898445129395 
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.00052595138549805 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
285 0.0005 0.00047492980957031 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
286 0.0005 0.00048208236694336 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
287 0.0006 0.00063395500183105 
SELECT * FROM products WHERE id = '4312'
288 0.0006 0.00057697296142578 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
289 0.0006 0.0006411075592041 
SELECT * FROM product_image_select WHERE product_id = '4312'
290 0.0004 0.00044798851013184 
SELECT * FROM productcustomimages WHERE product_id = '4312'
291 0.0011 0.0010988712310791 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
292 0.0006 0.00055313110351562 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
293 0.0005 0.0004730224609375 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
294 0.0005 0.00046706199645996 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
295 0.0008 0.00075507164001465 
SELECT * FROM products WHERE id = '777'
296 0.0005 0.00054311752319336 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
297 0.0007 0.00070381164550781 
SELECT * FROM product_image_select WHERE product_id = '777'
298 0.0005 0.00046610832214355 
SELECT * FROM productcustomimages WHERE product_id = '777'
299 0.0011 0.0011260509490967 
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.00050497055053711 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
301 0.0005 0.00048398971557617 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
302 0.0005 0.00047993659973145 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
303 0.0007 0.00065708160400391 
SELECT * FROM products WHERE id = '3881'
304 0.0006 0.00058293342590332 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
305 0.0006 0.00060009956359863 
SELECT * FROM product_image_select WHERE product_id = '3881'
306 0.0004 0.00044894218444824 
SELECT * FROM productcustomimages WHERE product_id = '3881'
307 0.0011 0.0011370182037354 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
308 0.0006 0.00057792663574219 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
309 0.0004 0.00043201446533203 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
310 0.0005 0.00046014785766602 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
311 0.0006 0.00059413909912109 
SELECT * FROM products WHERE id = '4213'
312 0.0008 0.00075721740722656 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
313 0.0009 0.00087308883666992 
SELECT * FROM product_image_select WHERE product_id = '4213'
314 0.0006 0.00059413909912109 
SELECT * FROM productcustomimages WHERE product_id = '4213'
315 0.0013 0.0013279914855957 
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.00050783157348633 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
317 0.0005 0.00050997734069824 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
318 0.0005 0.0004570484161377 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
319 0.0012 0.0012331008911133 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
320 0.0009 0.00091981887817383 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
321 0.0019 0.0018517971038818 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
322 0.0009 0.00092506408691406 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
323 0.0007 0.00071191787719727 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
324 0.0013 0.0012500286102295 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'