0
  1. My Store
  2. Rooibos

Jardins De GaÏa - JARDINS DE GAÏA - Zoulou Digest Tube 100 g - Rooibos Parfumé (Epices digestives)

Price: €12,24
Product prices and availability are accurate as of 2022-06-25 20:44:52 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.

Product Features

Rooibos

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.5400750637054 338 0.8780 0


No Amazon API Requests Made.


App Debug - Total Time 1.5400750637054 seconds

Number Time From Start Name Description
1 0.64581394195557 Initialise Initialise FSB Function
2 0.64935898780823 App Controller Start Start of the App controller (called before the controller of every page)
3 0.69007992744446 Start of getCategoryListByGroup Function Before first category groups query
4 0.69061303138733 After initial query Before first category groups query
5 0.69061493873596 Get Category List for Group Before the call to getCategoryList function
6 0.69061803817749 Start of GetCategoryList function Start of the function
7 0.69061994552612 Before getting categories Query to get specific category list
8 0.69139695167542 After getting categories Query to get specific category list
9 0.69139885902405 Before getting category custom Before call to function getCategoryCustom
10 0.70718908309937 After getting category custom After call to function getCategoryCustom
11 0.70719194412231 Before getting category custom Before call to function getCategoryCustom
12 0.71914005279541 After getting category custom After call to function getCategoryCustom
13 0.71914196014404 Before getting category custom Before call to function getCategoryCustom
14 0.72575497627258 After getting category custom After call to function getCategoryCustom
15 0.72575688362122 Before getting category custom Before call to function getCategoryCustom
16 0.73028707504272 After getting category custom After call to function getCategoryCustom
17 0.73028898239136 Before getting category custom Before call to function getCategoryCustom
18 0.73465800285339 After getting category custom After call to function getCategoryCustom
19 0.73466086387634 Before getting category custom Before call to function getCategoryCustom
20 0.73966693878174 After getting category custom After call to function getCategoryCustom
21 0.73967003822327 End of GetCategoryList function End of the function
22 0.73967599868774 Get Category List for Group Before the call to getCategoryList function
23 0.73967885971069 Start of GetCategoryList function Start of the function
24 0.73968100547791 Before getting categories Query to get specific category list
25 0.74024891853333 End of getCategoryListByGroup Function Before return()
26 1.2206120491028 App Controller End End of the App controller (called before the controller of every page)
27 1.221302986145 Product Start Start of the product info controller
28 1.2231869697571 Cache file not found Starting get product details
29 1.2467539310455 Related products Start getting related products if enabled
30 1.2467560768127 Related Products Start Before the related products are found
31 1.2467570304871 Related Products Keywords Before the related product keywords are found
32 1.2467610836029 Create Keyword List Function Start of function
33 1.2468059062958 Create Keyword List Function After looping provided content - 36 keywords found
34 1.2482678890228 Create Keyword List Function After looping initial keyword list - 33 keywords remaining
35 1.2482769489288 Create Keyword List Function After reducing keyword list
36 1.2484650611877 Create Keyword List Function After selecting by scoring keywords
37 1.248468875885 Create Keyword List Function After final loop of keywords
38 1.2484710216522 Related Products Keywords After the related product keywords are found
39 1.4105808734894 Related Products End After the related products are found
40 1.4588539600372 Product End End of the product info controller (Product Info)
41 1.4601318836212 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4611790180206 Before Get Options Before the call to getOptions in the tpl class
43 1.5229880809784 After Get Options After the call to getOptions in the tpl class
44 1.5231399536133 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5231778621674 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5290219783783 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5290269851685 Product Info: Before Template Display Before the template is displayed
48 1.5400500297546 Product Info: After Template Display After the template is displayed
49 1.5400629043579 Finalizing debug Before the debug is output to the page.
50 1.5400729179382 End of App This is the end of the app logging, final timestamp


Query Debug - 338 Database Queries. Total time 0.8780 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0027 0.0027070045471191 
SELECT parameter, value FROM parameters
2 0.0048 0.0048141479492188 
SELECT * FROM `bad_bots`
3 0.0005 0.0004580020904541 
SET time_zone = 'Europe/London'
4 0.0011 0.001068115234375 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0009 0.00086688995361328 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.147.51.187\";}'
6 0.0010 0.0010440349578857 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722056998'
7 0.0019 0.0018730163574219 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00072002410888672 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0011 0.0010790824890137 
SELECT id FROM pages WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-zoulou-digest-tube-100-g-rooibos' LIMIT 1
10 0.0014 0.0014359951019287 
SELECT id FROM products WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-zoulou-digest-tube-100-g-rooibos' AND hidden = 0 LIMIT 1
11 0.0041 0.0040640830993652 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0357 0.035660982131958 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00051188468933105 
SELECT * FROM pages WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-zoulou-digest-tube-100-g-rooibos'
14 0.0005 0.00052094459533691 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0008 0.00075888633728027 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0061 0.0060641765594482 
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.0007 0.0006561279296875 
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.00048613548278809 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00044894218444824 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0058 0.0057649612426758 
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.0006 0.00059318542480469 
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.00065517425537109 
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.0005 0.00052309036254883 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00049185752868652 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0042 0.0041999816894531 
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.0006 0.00064587593078613 
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.000579833984375 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00046300888061523 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0039 0.0038681030273438 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
30 0.0005 0.00054812431335449 
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.0006101131439209 
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.00051689147949219 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00043511390686035 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.0014021396636963 
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.0005 0.00052404403686523 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.00040411949157715 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00046920776367188 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015981197357178 
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.0005 0.00051403045654297 
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.0006 0.00062680244445801 
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.0005 0.00048995018005371 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00050497055053711 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00058889389038086 
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.0005 0.00047397613525391 
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.00044393539428711 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.0004432201385498 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00068402290344238 
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.0004 0.00044608116149902 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
49 0.0005 0.00048184394836426 
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.00046300888061523 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00042891502380371 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00054311752319336 
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.00045585632324219 
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.00037288665771484 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00036787986755371 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00062394142150879 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
57 0.0005 0.00047898292541504 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
58 0.0005 0.00051307678222656 
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.0004 0.0004429817199707 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00048089027404785 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00075411796569824 
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.0004889965057373 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00039911270141602 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00039386749267578 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00073719024658203 
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.00050187110900879 
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.00056695938110352 
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.00052905082702637 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00052785873413086 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00055694580078125 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0018 0.001845121383667 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.0005640983581543 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00053000450134277 
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.00040984153747559 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011489391326904 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0011 0.0010778903961182 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.4719 0.47188496589661 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.147.51.187') >= INET_ATON(ip_start) AND INET_ATON('3.147.51.187') <= INET_ATON(ip_end)
78 0.0013 0.0012829303741455 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0006 0.00060415267944336 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00078701972961426 
SELECT * FROM products WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-zoulou-digest-tube-100-g-rooibos'
81 0.0005 0.00046300888061523 
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1246
82 0.0005 0.00053119659423828 
SELECT * FROM manufacturers WHERE id = '293'
83 0.0005 0.0004880428314209 
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '293'
84 0.0005 0.00050115585327148 
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '293' LIMIT 1
85 0.0007 0.00065088272094727 
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '293' ORDER BY RAND() LIMIT 1
86 0.0007 0.00069403648376465 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
87 0.0005 0.00048303604125977 
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '293'
88 0.0005 0.00054097175598145 
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '293'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0
89 0.0004 0.00041317939758301 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '293'
90 0.0005 0.0004880428314209 
SELECT category_id FROM products_categories WHERE product_id = '1246'
91 0.0005 0.00054597854614258 
SELECT * FROM categories WHERE id = '27'
92 0.0036 0.0036289691925049 
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.0005500316619873 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00039887428283691 
SELECT id FROM categories WHERE parent_id = '27'
95 0.0042 0.0041840076446533 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
96 0.0006 0.00064897537231445 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
97 0.0006 0.00056099891662598 
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.0005030632019043 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0006 0.00064802169799805 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
100 0.0006 0.00058794021606445 
SELECT * FROM product_image_select WHERE product_id = '1246'
101 0.0005 0.00047993659973145 
SELECT * FROM productcustomimages WHERE product_id = '1246'
102 0.0005 0.00045394897460938 
SELECT * FROM productfeeds WHERE product_id = '1246' ORDER BY item_date DESC
103 0.0008 0.00078296661376953 
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0008 0.00075507164001465 
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1246' AND t.hidden = 0 AND display_product = 1
105 0.0006 0.00058579444885254 
SELECT * FROM productamazoncontent WHERE product_id = '1246'
106 0.0009 0.00090289115905762 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
107 0.0005 0.00053787231445312 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00044608116149902 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0005 0.00045394897460938 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0005 0.00053811073303223 
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.0091 0.0090949535369873 
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 1246 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
112 0.0009 0.0008549690246582 
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 1246 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
113 0.0008 0.0007929801940918 
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 1246 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0006 0.0005948543548584 
SELECT * FROM productimages WHERE product_id = '4678' ORDER BY sortorder ASC
115 0.0008 0.00075197219848633 
SELECT * FROM product_image_select WHERE product_id = '4678'
116 0.0006 0.00055599212646484 
SELECT * FROM productcustomimages WHERE product_id = '4678'
117 0.0015 0.001460075378418 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4678' AND a.name = n.originalname
118 0.0008 0.00077199935913086 
SELECT * FROM productoffers WHERE product_id = '4678' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0008 0.00075912475585938 
SELECT * FROM productoffers
                WHERE product_id = '4678' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0007 0.0006561279296875 
SELECT value FROM productattributes WHERE product_id = '4678' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0007 0.0007481575012207 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
122 0.0006 0.00061798095703125 
SELECT * FROM product_image_select WHERE product_id = '1246'
123 0.0005 0.00045514106750488 
SELECT * FROM productcustomimages WHERE product_id = '1246'
124 0.0009 0.00088286399841309 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
125 0.0005 0.0005488395690918 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0005 0.00046205520629883 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0005 0.00046396255493164 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0006 0.00056695938110352 
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
129 0.0006 0.00061488151550293 
SELECT * FROM product_image_select WHERE product_id = '1095'
130 0.0005 0.00045108795166016 
SELECT * FROM productcustomimages WHERE product_id = '1095'
131 0.0009 0.00093698501586914 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
132 0.0005 0.00054407119750977 
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0005 0.00047206878662109 
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0004 0.00044584274291992 
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0006 0.00055098533630371 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
136 0.0006 0.00059390068054199 
SELECT * FROM product_image_select WHERE product_id = '1204'
137 0.0004 0.00041890144348145 
SELECT * FROM productcustomimages WHERE product_id = '1204'
138 0.0008 0.00079989433288574 
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.00056195259094238 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00049400329589844 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0005 0.00046896934509277 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0112 0.011223077774048 
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 1246 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
143 0.0012 0.0012021064758301 
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 1246 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
144 0.0008 0.00083398818969727 
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 1246 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
145 0.0006 0.00056290626525879 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
146 0.0006 0.00064802169799805 
SELECT * FROM product_image_select WHERE product_id = '1204'
147 0.0006 0.00055909156799316 
SELECT * FROM productcustomimages WHERE product_id = '1204'
148 0.0008 0.00083088874816895 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
149 0.0006 0.00055408477783203 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0005 0.00054407119750977 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0005 0.0004880428314209 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0005 0.00052404403686523 
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
153 0.0007 0.00065183639526367 
SELECT * FROM product_image_select WHERE product_id = '1095'
154 0.0004 0.00042104721069336 
SELECT * FROM productcustomimages WHERE product_id = '1095'
155 0.0012 0.0011849403381348 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
156 0.0005 0.00050997734069824 
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0004 0.00044608116149902 
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0005 0.00045013427734375 
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0006 0.00061988830566406 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
160 0.0006 0.00058889389038086 
SELECT * FROM product_image_select WHERE product_id = '1246'
161 0.0004 0.00041103363037109 
SELECT * FROM productcustomimages WHERE product_id = '1246'
162 0.0008 0.00079798698425293 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
163 0.0005 0.00051307678222656 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0004 0.00043988227844238 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0005 0.00046515464782715 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0090 0.0090219974517822 
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 1246 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
167 0.0008 0.00082612037658691 
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 1246 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
168 0.0008 0.00079798698425293 
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 1246 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
169 0.0008 0.00076198577880859 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
170 0.0010 0.0010299682617188 
SELECT * FROM product_image_select WHERE product_id = '1246'
171 0.0011 0.0010778903961182 
SELECT * FROM productcustomimages WHERE product_id = '1246'
172 0.0014 0.0013761520385742 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
173 0.0014 0.0014150142669678 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0013 0.0013010501861572 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0013 0.0012810230255127 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0007 0.00066089630126953 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
177 0.0006 0.00063586235046387 
SELECT * FROM product_image_select WHERE product_id = '1204'
178 0.0005 0.00045418739318848 
SELECT * FROM productcustomimages WHERE product_id = '1204'
179 0.0011 0.0010709762573242 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
180 0.0006 0.00063705444335938 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0005 0.0005490779876709 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0006 0.00055503845214844 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0007 0.00072407722473145 
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
184 0.0009 0.00092911720275879 
SELECT * FROM product_image_select WHERE product_id = '1095'
185 0.0005 0.00054097175598145 
SELECT * FROM productcustomimages WHERE product_id = '1095'
186 0.0013 0.0012950897216797 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
187 0.0006 0.00061392784118652 
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0005 0.00053095817565918 
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0005 0.00051617622375488 
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0130 0.012995958328247 
SELECT *, MATCH (description, title) AGAINST ('zoulou digest tube' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('zoulou digest tube' IN BOOLEAN MODE) AND 1246 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
191 0.0012 0.0012099742889404 
SELECT *, MATCH (description, title) AGAINST ('zoulou digest tube' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('zoulou digest tube' IN BOOLEAN MODE) AND 1246 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
192 0.0008 0.00078487396240234 
SELECT *, MATCH (description, title) AGAINST ('zoulou digest tube' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('zoulou digest tube' IN BOOLEAN MODE) AND 1246 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
193 0.0009 0.00090408325195312 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
194 0.0025 0.0024688243865967 
SELECT * FROM product_image_select WHERE product_id = '1204'
195 0.0010 0.0010280609130859 
SELECT * FROM productcustomimages WHERE product_id = '1204'
196 0.0023 0.0022687911987305 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
197 0.0011 0.0011138916015625 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0009 0.00088000297546387 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0010 0.00099015235900879 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0011 0.0010530948638916 
SELECT * FROM productimages WHERE product_id = '3666' ORDER BY sortorder ASC
201 0.0013 0.0013468265533447 
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
202 0.0019 0.0018620491027832 
SELECT * FROM product_image_select WHERE product_id = '3666'
203 0.0012 0.001215934753418 
SELECT * FROM productcustomimages WHERE product_id = '3666'
204 0.0015 0.0014820098876953 
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
205 0.0020 0.0020298957824707 
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
206 0.0010 0.0010168552398682 
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
207 0.0032 0.0032398700714111 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3666' AND a.name = n.originalname
208 0.0008 0.00082588195800781 
SELECT * FROM productoffers WHERE product_id = '3666' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0012 0.0011899471282959 
SELECT * FROM productoffers
                WHERE product_id = '3666' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0010 0.00095105171203613 
SELECT * FROM productoffers
                WHERE product_id = 3666
                ORDER BY price ASC LIMIT 1
211 0.0011 0.0011451244354248 
SELECT value FROM productattributes
                WHERE product_id = '3666'
                AND name = 'ListPriceAmount'
212 0.0011 0.0011038780212402 
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
213 0.0014 0.0013978481292725 
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
214 0.0006 0.00064992904663086 
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
215 0.0010 0.0010139942169189 
SELECT value FROM productattributes WHERE product_id = '3666' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0013 0.0012750625610352 
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
217 0.0011 0.0010759830474854 
SELECT * FROM productimages WHERE product_id = '2498' ORDER BY sortorder ASC
218 0.0010 0.0010437965393066 
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
219 0.0010 0.00098705291748047 
SELECT * FROM product_image_select WHERE product_id = '2498'
220 0.0006 0.00057315826416016 
SELECT * FROM productcustomimages WHERE product_id = '2498'
221 0.0010 0.0010068416595459 
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
222 0.0010 0.00099396705627441 
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
223 0.0007 0.00070905685424805 
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
224 0.0012 0.001183032989502 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2498' AND a.name = n.originalname
225 0.0005 0.00047802925109863 
SELECT * FROM productoffers WHERE product_id = '2498' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0005 0.00049304962158203 
SELECT * FROM productoffers
                WHERE product_id = '2498' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0004 0.0004432201385498 
SELECT * FROM productoffers
                WHERE product_id = 2498
                ORDER BY price ASC LIMIT 1
228 0.0005 0.00045680999755859 
SELECT value FROM productattributes
                WHERE product_id = '2498'
                AND name = 'ListPriceAmount'
229 0.0005 0.00052809715270996 
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
230 0.0008 0.00077295303344727 
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
231 0.0005 0.00049901008605957 
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
232 0.0007 0.00068187713623047 
SELECT value FROM productattributes WHERE product_id = '2498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0007 0.00072312355041504 
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
234 0.0098 0.0097849369049072 
SELECT *, MATCH (description, title) AGAINST ('parfumé epices digestives' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('parfumé epices digestives' IN BOOLEAN MODE) AND 1246 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
235 0.0009 0.0009000301361084 
SELECT *, MATCH (description, title) AGAINST ('parfumé epices digestives' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('parfumé epices digestives' IN BOOLEAN MODE) AND 1246 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
236 0.0009 0.00089788436889648 
SELECT *, MATCH (description, title) AGAINST ('parfumé epices digestives' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('parfumé epices digestives' IN BOOLEAN MODE) AND 1246 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
237 0.0006 0.00058388710021973 
SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
238 0.0007 0.00065302848815918 
SELECT * FROM product_image_select WHERE product_id = '764'
239 0.0005 0.00051283836364746 
SELECT * FROM productcustomimages WHERE product_id = '764'
240 0.0011 0.0010979175567627 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '764' AND a.name = n.originalname
241 0.0008 0.00075793266296387 
SELECT * FROM productoffers WHERE product_id = '764' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0005 0.00048518180847168 
SELECT * FROM productoffers
                WHERE product_id = '764' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0005 0.00047612190246582 
SELECT value FROM productattributes WHERE product_id = '764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0005 0.0004880428314209 
SELECT id,asin FROM products WHERE parent_id = 1246
245 0.0005 0.00053000450134277 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1246' ORDER BY timestamp DESC
246 0.0005 0.00049710273742676 
SELECT category_id FROM products_categories WHERE product_id = '1246'
247 0.0005 0.00050115585327148 
SELECT * FROM categories WHERE id = '27'
248 0.0048 0.0047850608825684 
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
249 0.0006 0.00056695938110352 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
250 0.0004 0.00038886070251465 
SELECT id FROM categories WHERE parent_id = '27'
251 0.0058 0.0057981014251709 
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
252 0.0013 0.0013120174407959 
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
253 0.0012 0.0012390613555908 
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
254 0.0010 0.001021146774292 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
255 0.0021 0.002108097076416 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
256 0.0010 0.0009911060333252 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
257 0.0009 0.00089502334594727 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
258 0.0010 0.0010418891906738 
SELECT * FROM products WHERE id = '1246'
259 0.0009 0.00093603134155273 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260 0.0016 0.0015761852264404 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
261 0.0007 0.00073099136352539 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
262 0.0012 0.001162052154541 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
263 0.0009 0.00093698501586914 
SELECT category_id FROM products_categories WHERE product_id = '1246' AND prod_type = 'amz'
264 0.0007 0.00070595741271973 
SELECT parent_id FROM categories WHERE id = '27'
265 0.0006 0.00056099891662598 
SELECT * FROM categories WHERE id = '27'
266 0.0086 0.0086128711700439 
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
267 0.0008 0.00083494186401367 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
268 0.0006 0.00059294700622559 
SELECT id FROM categories WHERE parent_id = '27'
269 0.0064 0.0063591003417969 
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
270 0.0009 0.00087594985961914 
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
271 0.0009 0.00090408325195312 
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
272 0.0008 0.00076889991760254 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
273 0.0008 0.00081515312194824 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
274 0.0005 0.00054001808166504 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
275 0.0004 0.00044393539428711 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
276 0.0142 0.014208078384399 
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
277 0.0009 0.00087594985961914 
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
278 0.0007 0.000701904296875 
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
279 0.0008 0.00077199935913086 
SELECT * FROM products WHERE id = 1626
280 0.0006 0.00064706802368164 
SELECT * FROM products WHERE id = 4041
281 0.0007 0.00065898895263672 
SELECT * FROM products WHERE id = 4312
282 0.0006 0.00060009956359863 
SELECT * FROM products WHERE id = 777
283 0.0006 0.00061297416687012 
SELECT * FROM products WHERE id = 3881
284 0.0006 0.00060105323791504 
SELECT * FROM products WHERE id = 4213
285 0.0006 0.00062012672424316 
SELECT * FROM products WHERE id = '1626'
286 0.0005 0.00053215026855469 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
287 0.0006 0.00064802169799805 
SELECT * FROM product_image_select WHERE product_id = '1626'
288 0.0005 0.0005030632019043 
SELECT * FROM productcustomimages WHERE product_id = '1626'
289 0.0009 0.00093483924865723 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
290 0.0006 0.00062108039855957 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
291 0.0005 0.00051712989807129 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
292 0.0005 0.00049304962158203 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
293 0.0007 0.00068402290344238 
SELECT * FROM products WHERE id = '4041'
294 0.0005 0.00052499771118164 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
295 0.0007 0.00065016746520996 
SELECT * FROM product_image_select WHERE product_id = '4041'
296 0.0005 0.00045490264892578 
SELECT * FROM productcustomimages WHERE product_id = '4041'
297 0.0014 0.001378059387207 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
298 0.0006 0.0006108283996582 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
299 0.0005 0.00050497055053711 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
300 0.0005 0.0004880428314209 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
301 0.0007 0.00066590309143066 
SELECT * FROM products WHERE id = '4312'
302 0.0006 0.00058388710021973 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
303 0.0007 0.00070619583129883 
SELECT * FROM product_image_select WHERE product_id = '4312'
304 0.0005 0.00046801567077637 
SELECT * FROM productcustomimages WHERE product_id = '4312'
305 0.0012 0.0012390613555908 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
306 0.0006 0.00058603286743164 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
307 0.0005 0.00050902366638184 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
308 0.0005 0.00051307678222656 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309 0.0008 0.00080513954162598 
SELECT * FROM products WHERE id = '777'
310 0.0006 0.00060200691223145 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
311 0.0007 0.00069999694824219 
SELECT * FROM product_image_select WHERE product_id = '777'
312 0.0005 0.00049805641174316 
SELECT * FROM productcustomimages WHERE product_id = '777'
313 0.0012 0.0012280941009521 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
314 0.0006 0.00060606002807617 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
315 0.0005 0.00051999092102051 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
316 0.0005 0.00047492980957031 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
317 0.0007 0.00071120262145996 
SELECT * FROM products WHERE id = '3881'
318 0.0008 0.0008389949798584 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
319 0.0007 0.00069499015808105 
SELECT * FROM product_image_select WHERE product_id = '3881'
320 0.0005 0.00050592422485352 
SELECT * FROM productcustomimages WHERE product_id = '3881'
321 0.0014 0.0013999938964844 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
322 0.0008 0.00080204010009766 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
323 0.0005 0.00051689147949219 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
324 0.0005 0.00052905082702637 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
325 0.0008 0.00075697898864746 
SELECT * FROM products WHERE id = '4213'
326 0.0008 0.00083017349243164 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
327 0.0009 0.00090718269348145 
SELECT * FROM product_image_select WHERE product_id = '4213'
328 0.0005 0.00052118301391602 
SELECT * FROM productcustomimages WHERE product_id = '4213'
329 0.0017 0.0016651153564453 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
330 0.0007 0.00069808959960938 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
331 0.0006 0.00058698654174805 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
332 0.0006 0.00058197975158691 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
333 0.0012 0.0012421607971191 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
334 0.0012 0.0012061595916748 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
335 0.0021 0.0021061897277832 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
336 0.0010 0.0010228157043457 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
337 0.0009 0.00086498260498047 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
338 0.0008 0.000823974609375 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'