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.7137849330902 339 1.0610 0


No Amazon API Requests Made.


App Debug - Total Time 1.7137849330902 seconds

Number Time From Start Name Description
1 0.60439801216125 Initialise Initialise FSB Function
2 0.61798095703125 App Controller Start Start of the App controller (called before the controller of every page)
3 0.65998983383179 Start of getCategoryListByGroup Function Before first category groups query
4 0.66207480430603 After initial query Before first category groups query
5 0.66207695007324 Get Category List for Group Before the call to getCategoryList function
6 0.66208100318909 Start of GetCategoryList function Start of the function
7 0.66208481788635 Before getting categories Query to get specific category list
8 0.66396594047546 After getting categories Query to get specific category list
9 0.6639678478241 Before getting category custom Before call to function getCategoryCustom
10 0.68907499313354 After getting category custom After call to function getCategoryCustom
11 0.68907880783081 Before getting category custom Before call to function getCategoryCustom
12 0.70217299461365 After getting category custom After call to function getCategoryCustom
13 0.70217490196228 Before getting category custom Before call to function getCategoryCustom
14 0.71693181991577 After getting category custom After call to function getCategoryCustom
15 0.71693396568298 Before getting category custom Before call to function getCategoryCustom
16 0.7243230342865 After getting category custom After call to function getCategoryCustom
17 0.72432494163513 Before getting category custom Before call to function getCategoryCustom
18 0.73227882385254 After getting category custom After call to function getCategoryCustom
19 0.73228096961975 Before getting category custom Before call to function getCategoryCustom
20 0.73843598365784 After getting category custom After call to function getCategoryCustom
21 0.73843789100647 End of GetCategoryList function End of the function
22 0.73844480514526 Get Category List for Group Before the call to getCategoryList function
23 0.73844790458679 Start of GetCategoryList function Start of the function
24 0.73845100402832 Before getting categories Query to get specific category list
25 0.73897695541382 End of getCategoryListByGroup Function Before return()
26 1.3202669620514 App Controller End End of the App controller (called before the controller of every page)
27 1.321035861969 Product Start Start of the product info controller
28 1.3513188362122 Cache file not found Starting get product details
29 1.4027879238129 Related products Start getting related products if enabled
30 1.4027898311615 Related Products Start Before the related products are found
31 1.4027910232544 Related Products Keywords Before the related product keywords are found
32 1.4027948379517 Create Keyword List Function Start of function
33 1.4028849601746 Create Keyword List Function After looping provided content - 36 keywords found
34 1.4044890403748 Create Keyword List Function After looping initial keyword list - 33 keywords remaining
35 1.4044978618622 Create Keyword List Function After reducing keyword list
36 1.4047079086304 Create Keyword List Function After selecting by scoring keywords
37 1.4047119617462 Create Keyword List Function After final loop of keywords
38 1.4047138690948 Related Products Keywords After the related product keywords are found
39 1.5879049301147 Related Products End After the related products are found
40 1.6165099143982 Product End End of the product info controller (Product Info)
41 1.6189169883728 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.6205658912659 Before Get Options Before the call to getOptions in the tpl class
43 1.6797738075256 After Get Options After the call to getOptions in the tpl class
44 1.6799478530884 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.6799829006195 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.6932280063629 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.6932330131531 Product Info: Before Template Display Before the template is displayed
48 1.7137589454651 Product Info: After Template Display After the template is displayed
49 1.7137718200684 Finalizing debug Before the debug is output to the page.
50 1.7137839794159 End of App This is the end of the app logging, final timestamp


Query Debug - 339 Database Queries. Total time 1.0610 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0018 0.001845121383667 
SELECT parameter, value FROM parameters
2 0.0076 0.007559061050415 
SELECT * FROM `bad_bots`
3 0.0004 0.0003969669342041 
SET time_zone = 'Europe/London'
4 0.0041 0.0040571689605713 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0038 0.0038490295410156 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.85\";}'
6 0.0033 0.0033168792724609 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1737472478'
7 0.0051 0.0050668716430664 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.0010161399841309 
UPDATE autorun SET lastrun = '2025-01-21 15:14:38' WHERE id = '16'
9 0.0015 0.0014510154724121 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0068 0.006756067276001 
SELECT id FROM pages WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-zoulou-digest-tube-100-g-rooibos' LIMIT 1
11 0.0047 0.0047008991241455 
SELECT id FROM products WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-zoulou-digest-tube-100-g-rooibos' AND hidden = 0 LIMIT 1
12 0.0095 0.0095160007476807 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0295 0.029462099075317 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0024 0.0023858547210693 
SELECT * FROM pages WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-zoulou-digest-tube-100-g-rooibos'
15 0.0021 0.0020718574523926 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0019 0.0018610954284668 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0072 0.0071530342102051 
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
18 0.0028 0.0027949810028076 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0016 0.0015840530395508 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0006 0.00057196617126465 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0066 0.006566047668457 
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
22 0.0022 0.0021648406982422 
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
23 0.0019 0.0018811225891113 
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
24 0.0018 0.0017690658569336 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00050091743469238 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0043 0.0043051242828369 
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
27 0.0006 0.00058293342590332 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0005 0.0004889965057373 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00049495697021484 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0045 0.0044889450073242 
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
31 0.0008 0.0007789134979248 
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
32 0.0007 0.00070595741271973 
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
33 0.0006 0.00058388710021973 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0006 0.00055384635925293 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0034 0.0033869743347168 
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
36 0.0056 0.0055809020996094 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0005 0.00052094459533691 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0006 0.00056695938110352 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0019 0.0018889904022217 
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
40 0.0007 0.00067400932312012 
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
41 0.0009 0.00088095664978027 
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
42 0.0007 0.00066304206848145 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00049686431884766 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0010 0.0010020732879639 
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
45 0.0007 0.0006558895111084 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0007 0.00065302848815918 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0007 0.00065302848815918 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0016 0.0015730857849121 
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
49 0.0008 0.0007789134979248 
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
50 0.0008 0.00082206726074219 
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
51 0.0006 0.00061798095703125 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00054478645324707 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0015 0.0015139579772949 
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
54 0.0006 0.00062394142150879 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0006 0.00058603286743164 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0006 0.00060701370239258 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0018 0.0018289089202881 
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
58 0.0010 0.00099802017211914 
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
59 0.0007 0.00072121620178223 
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
60 0.0005 0.00052285194396973 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00045204162597656 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0008 0.00079607963562012 
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
63 0.0005 0.00049710273742676 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0005 0.0004880428314209 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00047612190246582 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0012 0.0012280941009521 
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
67 0.0006 0.00061202049255371 
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
68 0.0008 0.00079703330993652 
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
69 0.0005 0.00045108795166016 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0007 0.00072908401489258 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00051498413085938 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0042 0.0042488574981689 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0025 0.0025241374969482 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0007 0.0006721019744873 
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
75 0.0033 0.0033159255981445 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0016 0.0015790462493896 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0011 0.0011038780212402 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.5618 0.56178593635559 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.85') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.85') <= INET_ATON(ip_end)
79 0.0025 0.0024659633636475 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0014 0.0014290809631348 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0008 0.0007929801940918 
SELECT * FROM products WHERE pagename = 'jardins-de-gaa-jardins-de-gaa-zoulou-digest-tube-100-g-rooibos'
82 0.0006 0.00055718421936035 
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1246
83 0.0012 0.0011508464813232 
SELECT * FROM manufacturers WHERE id = '293'
84 0.0009 0.00087404251098633 
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '293'
85 0.0039 0.0038940906524658 
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '293' LIMIT 1
86 0.0042 0.0041840076446533 
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
87 0.0009 0.00087404251098633 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
88 0.0009 0.00086092948913574 
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '293'
89 0.0009 0.00089693069458008 
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
90 0.0008 0.0008080005645752 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '293'
91 0.0009 0.00086808204650879 
SELECT category_id FROM products_categories WHERE product_id = '1246'
92 0.0010 0.00096392631530762 
SELECT * FROM categories WHERE id = '27'
93 0.0070 0.0070328712463379 
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
94 0.0007 0.0007011890411377 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0005 0.00050902366638184 
SELECT id FROM categories WHERE parent_id = '27'
96 0.0057 0.0057439804077148 
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
97 0.0008 0.00077605247497559 
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
98 0.0008 0.00081515312194824 
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
99 0.0007 0.00068092346191406 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0007 0.00071811676025391 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
101 0.0023 0.0022950172424316 
SELECT * FROM product_image_select WHERE product_id = '1246'
102 0.0019 0.0018842220306396 
SELECT * FROM productcustomimages WHERE product_id = '1246'
103 0.0014 0.0013771057128906 
SELECT * FROM productfeeds WHERE product_id = '1246' ORDER BY item_date DESC
104 0.0031 0.003054141998291 
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
105 0.0031 0.0031449794769287 
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
106 0.0019 0.001884937286377 
SELECT * FROM productamazoncontent WHERE product_id = '1246'
107 0.0011 0.0010578632354736 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
108 0.0019 0.0019290447235107 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0005 0.00049495697021484 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0007 0.00066900253295898 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0007 0.0007169246673584 
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
112 0.0139 0.013890981674194 
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
113 0.0010 0.0010149478912354 
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
114 0.0007 0.00069093704223633 
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
115 0.0007 0.00073599815368652 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
116 0.0008 0.000823974609375 
SELECT * FROM product_image_select WHERE product_id = '1246'
117 0.0005 0.00049400329589844 
SELECT * FROM productcustomimages WHERE product_id = '1246'
118 0.0011 0.0010631084442139 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
119 0.0006 0.00063610076904297 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0005 0.00049090385437012 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0006 0.00055980682373047 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0007 0.00067496299743652 
SELECT * FROM productimages WHERE product_id = '4678' ORDER BY sortorder ASC
123 0.0007 0.0007011890411377 
SELECT * FROM product_image_select WHERE product_id = '4678'
124 0.0005 0.0004580020904541 
SELECT * FROM productcustomimages WHERE product_id = '4678'
125 0.0016 0.0015568733215332 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4678' AND a.name = n.originalname
126 0.0006 0.00063300132751465 
SELECT * FROM productoffers WHERE product_id = '4678' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0005 0.0004580020904541 
SELECT * FROM productoffers
                WHERE product_id = '4678' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0006 0.00057697296142578 
SELECT value FROM productattributes WHERE product_id = '4678' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0006 0.00064516067504883 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
130 0.0007 0.00071310997009277 
SELECT * FROM product_image_select WHERE product_id = '1204'
131 0.0004 0.00044608116149902 
SELECT * FROM productcustomimages WHERE product_id = '1204'
132 0.0009 0.00089406967163086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
133 0.0006 0.00063109397888184 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0005 0.0005340576171875 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0005 0.00051498413085938 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0006 0.00063109397888184 
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
137 0.0007 0.0007469654083252 
SELECT * FROM product_image_select WHERE product_id = '1095'
138 0.0005 0.00052905082702637 
SELECT * FROM productcustomimages WHERE product_id = '1095'
139 0.0010 0.001025915145874 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
140 0.0006 0.00057315826416016 
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0005 0.00048995018005371 
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0005 0.00046896934509277 
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0107 0.010663986206055 
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
144 0.0010 0.0010349750518799 
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
145 0.0007 0.00067520141601562 
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
146 0.0006 0.00056219100952148 
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
147 0.0007 0.00069117546081543 
SELECT * FROM product_image_select WHERE product_id = '1095'
148 0.0005 0.00048303604125977 
SELECT * FROM productcustomimages WHERE product_id = '1095'
149 0.0011 0.0010778903961182 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
150 0.0007 0.00070285797119141 
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0005 0.00054502487182617 
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0006 0.00064921379089355 
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0008 0.00078320503234863 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
154 0.0008 0.0008089542388916 
SELECT * FROM product_image_select WHERE product_id = '1204'
155 0.0005 0.00050520896911621 
SELECT * FROM productcustomimages WHERE product_id = '1204'
156 0.0009 0.00089597702026367 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
157 0.0007 0.00066900253295898 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0006 0.00058102607727051 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0005 0.00049495697021484 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0006 0.00059700012207031 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
161 0.0007 0.00074100494384766 
SELECT * FROM product_image_select WHERE product_id = '1246'
162 0.0005 0.00052785873413086 
SELECT * FROM productcustomimages WHERE product_id = '1246'
163 0.0009 0.00089311599731445 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
164 0.0006 0.00062084197998047 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0005 0.00047087669372559 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0005 0.00051188468933105 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0098 0.0097839832305908 
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
168 0.0010 0.0009920597076416 
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
169 0.0007 0.000701904296875 
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
170 0.0007 0.00069808959960938 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
171 0.0008 0.00078701972961426 
SELECT * FROM product_image_select WHERE product_id = '1204'
172 0.0005 0.00053501129150391 
SELECT * FROM productcustomimages WHERE product_id = '1204'
173 0.0014 0.00136399269104 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
174 0.0006 0.00058102607727051 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0005 0.00051617622375488 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0005 0.00048089027404785 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0020 0.0020239353179932 
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
178 0.0017 0.0017240047454834 
SELECT * FROM product_image_select WHERE product_id = '1095'
179 0.0009 0.00086116790771484 
SELECT * FROM productcustomimages WHERE product_id = '1095'
180 0.0028 0.0027689933776855 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
181 0.0013 0.0012650489807129 
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
182 0.0009 0.00093317031860352 
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
183 0.0011 0.0011441707611084 
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
184 0.0020 0.0019898414611816 
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
185 0.0018 0.0017931461334229 
SELECT * FROM product_image_select WHERE product_id = '1246'
186 0.0011 0.0011119842529297 
SELECT * FROM productcustomimages WHERE product_id = '1246'
187 0.0024 0.0023729801177979 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
188 0.0012 0.0011751651763916 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0020 0.0019869804382324 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0032 0.0031700134277344 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191 0.0170 0.017041921615601 
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
192 0.0011 0.0010581016540527 
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
193 0.0007 0.00071287155151367 
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
194 0.0007 0.00069189071655273 
SELECT * FROM productimages WHERE product_id = '3666' ORDER BY sortorder ASC
195 0.0008 0.00082492828369141 
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
196 0.0008 0.00082588195800781 
SELECT * FROM product_image_select WHERE product_id = '3666'
197 0.0005 0.00047087669372559 
SELECT * FROM productcustomimages WHERE product_id = '3666'
198 0.0018 0.0017659664154053 
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
199 0.0079 0.0079469680786133 
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
200 0.0016 0.0016200542449951 
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
201 0.0030 0.0030479431152344 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3666' AND a.name = n.originalname
202 0.0006 0.00057792663574219 
SELECT * FROM productoffers WHERE product_id = '3666' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0007 0.00069594383239746 
SELECT * FROM productoffers
                WHERE product_id = '3666' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0005 0.00051403045654297 
SELECT * FROM productoffers
                WHERE product_id = 3666
                ORDER BY price ASC LIMIT 1
205 0.0007 0.00071310997009277 
SELECT value FROM productattributes
                WHERE product_id = '3666'
                AND name = 'ListPriceAmount'
206 0.0007 0.0007328987121582 
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
207 0.0013 0.0012810230255127 
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
208 0.0009 0.00094294548034668 
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
209 0.0008 0.00079011917114258 
SELECT value FROM productattributes WHERE product_id = '3666' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0009 0.00090217590332031 
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
211 0.0007 0.00071215629577637 
SELECT * FROM productimages WHERE product_id = '2498' ORDER BY sortorder ASC
212 0.0008 0.00080394744873047 
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
213 0.0008 0.00084519386291504 
SELECT * FROM product_image_select WHERE product_id = '2498'
214 0.0005 0.00052595138549805 
SELECT * FROM productcustomimages WHERE product_id = '2498'
215 0.0008 0.00078296661376953 
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
216 0.0010 0.00098419189453125 
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
217 0.0006 0.00063419342041016 
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
218 0.0014 0.0013558864593506 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2498' AND a.name = n.originalname
219 0.0005 0.00045013427734375 
SELECT * FROM productoffers WHERE product_id = '2498' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0004 0.00044989585876465 
SELECT * FROM productoffers
                WHERE product_id = '2498' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0005 0.00045084953308105 
SELECT * FROM productoffers
                WHERE product_id = 2498
                ORDER BY price ASC LIMIT 1
222 0.0005 0.00052809715270996 
SELECT value FROM productattributes
                WHERE product_id = '2498'
                AND name = 'ListPriceAmount'
223 0.0006 0.00058197975158691 
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
224 0.0011 0.0011270046234131 
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
225 0.0005 0.00054788589477539 
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
226 0.0007 0.00071501731872559 
SELECT value FROM productattributes WHERE product_id = '2498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0009 0.00092792510986328 
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
228 0.0007 0.00072193145751953 
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
229 0.0008 0.00081896781921387 
SELECT * FROM product_image_select WHERE product_id = '1204'
230 0.0005 0.00051188468933105 
SELECT * FROM productcustomimages WHERE product_id = '1204'
231 0.0013 0.0012691020965576 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
232 0.0007 0.00066995620727539 
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0006 0.00059986114501953 
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0006 0.00056195259094238 
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0127 0.012722015380859 
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
236 0.0009 0.00086116790771484 
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
237 0.0007 0.00074601173400879 
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
238 0.0005 0.00054001808166504 
SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
239 0.0006 0.00063085556030273 
SELECT * FROM product_image_select WHERE product_id = '764'
240 0.0004 0.00042486190795898 
SELECT * FROM productcustomimages WHERE product_id = '764'
241 0.0010 0.0010480880737305 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '764' AND a.name = n.originalname
242 0.0005 0.0005030632019043 
SELECT * FROM productoffers WHERE product_id = '764' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0004 0.0004279613494873 
SELECT * FROM productoffers
                WHERE product_id = '764' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0004 0.00042200088500977 
SELECT value FROM productattributes WHERE product_id = '764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0005 0.00046586990356445 
SELECT id,asin FROM products WHERE parent_id = 1246
246 0.0016 0.0016210079193115 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1246' ORDER BY timestamp DESC
247 0.0004 0.00043702125549316 
SELECT category_id FROM products_categories WHERE product_id = '1246'
248 0.0004 0.00044989585876465 
SELECT * FROM categories WHERE id = '27'
249 0.0038 0.0037760734558105 
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
250 0.0004 0.00044012069702148 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
251 0.0004 0.00037908554077148 
SELECT id FROM categories WHERE parent_id = '27'
252 0.0038 0.0038490295410156 
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
253 0.0006 0.0005638599395752 
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
254 0.0006 0.00055789947509766 
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
255 0.0005 0.00047492980957031 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
256 0.0008 0.00084996223449707 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
257 0.0005 0.00047683715820312 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
258 0.0004 0.00043606758117676 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
259 0.0006 0.0005650520324707 
SELECT * FROM products WHERE id = '1246'
260 0.0005 0.00045609474182129 
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0006 0.0006411075592041 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
262 0.0004 0.00039792060852051 
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
263 0.0004 0.0003809928894043 
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
264 0.0005 0.00045299530029297 
SELECT category_id FROM products_categories WHERE product_id = '1246' AND prod_type = 'amz'
265 0.0004 0.0004279613494873 
SELECT parent_id FROM categories WHERE id = '27'
266 0.0003 0.00034499168395996 
SELECT * FROM categories WHERE id = '27'
267 0.0037 0.0036988258361816 
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
268 0.0004 0.00042891502380371 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
269 0.0003 0.00032496452331543 
SELECT id FROM categories WHERE parent_id = '27'
270 0.0037 0.0036971569061279 
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
271 0.0005 0.00049281120300293 
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
272 0.0006 0.00061798095703125 
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
273 0.0005 0.00047707557678223 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
274 0.0017 0.0017268657684326 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
275 0.0012 0.0012359619140625 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
276 0.0003 0.00033092498779297 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
277 0.0142 0.014210939407349 
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
278 0.0021 0.0021090507507324 
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
279 0.0006 0.00056815147399902 
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
280 0.0006 0.00061392784118652 
SELECT * FROM products WHERE id = 1626
281 0.0006 0.00057697296142578 
SELECT * FROM products WHERE id = 4041
282 0.0006 0.00055789947509766 
SELECT * FROM products WHERE id = 4312
283 0.0006 0.00055217742919922 
SELECT * FROM products WHERE id = 777
284 0.0006 0.00055980682373047 
SELECT * FROM products WHERE id = 3881
285 0.0006 0.00064992904663086 
SELECT * FROM products WHERE id = 4213
286 0.0006 0.00060009956359863 
SELECT * FROM products WHERE id = '1626'
287 0.0005 0.00046086311340332 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
288 0.0006 0.00063204765319824 
SELECT * FROM product_image_select WHERE product_id = '1626'
289 0.0005 0.0005030632019043 
SELECT * FROM productcustomimages WHERE product_id = '1626'
290 0.0011 0.0010528564453125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
291 0.0005 0.00052213668823242 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
292 0.0004 0.00043702125549316 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
293 0.0005 0.00048017501831055 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
294 0.0006 0.00057506561279297 
SELECT * FROM products WHERE id = '4041'
295 0.0005 0.00053286552429199 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
296 0.0006 0.00062799453735352 
SELECT * FROM product_image_select WHERE product_id = '4041'
297 0.0005 0.00045895576477051 
SELECT * FROM productcustomimages WHERE product_id = '4041'
298 0.0014 0.0013630390167236 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
299 0.0006 0.00056195259094238 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
300 0.0004 0.00040912628173828 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
301 0.0005 0.00049781799316406 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302 0.0006 0.00063014030456543 
SELECT * FROM products WHERE id = '4312'
303 0.0006 0.00057888031005859 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
304 0.0006 0.00062918663024902 
SELECT * FROM product_image_select WHERE product_id = '4312'
305 0.0004 0.00037908554077148 
SELECT * FROM productcustomimages WHERE product_id = '4312'
306 0.0011 0.0011420249938965 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
307 0.0005 0.00047588348388672 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
308 0.0004 0.00043392181396484 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
309 0.0005 0.00045299530029297 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
310 0.0006 0.00061416625976562 
SELECT * FROM products WHERE id = '777'
311 0.0005 0.00053095817565918 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
312 0.0006 0.00061702728271484 
SELECT * FROM product_image_select WHERE product_id = '777'
313 0.0004 0.00038409233093262 
SELECT * FROM productcustomimages WHERE product_id = '777'
314 0.0011 0.0011179447174072 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
315 0.0005 0.00048398971557617 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
316 0.0004 0.00043201446533203 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
317 0.0004 0.00041508674621582 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
318 0.0006 0.00056695938110352 
SELECT * FROM products WHERE id = '3881'
319 0.0007 0.00067496299743652 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
320 0.0006 0.00060009956359863 
SELECT * FROM product_image_select WHERE product_id = '3881'
321 0.0004 0.00038504600524902 
SELECT * FROM productcustomimages WHERE product_id = '3881'
322 0.0011 0.0010979175567627 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
323 0.0005 0.0004889965057373 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
324 0.0004 0.00041294097900391 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
325 0.0004 0.00040292739868164 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
326 0.0006 0.00063395500183105 
SELECT * FROM products WHERE id = '4213'
327 0.0007 0.0006859302520752 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
328 0.0006 0.00064587593078613 
SELECT * FROM product_image_select WHERE product_id = '4213'
329 0.0004 0.0004420280456543 
SELECT * FROM productcustomimages WHERE product_id = '4213'
330 0.0012 0.0012161731719971 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
331 0.0005 0.00047683715820312 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
332 0.0004 0.00040888786315918 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
333 0.0004 0.00040888786315918 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
334 0.0020 0.00199294090271 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
335 0.0008 0.00081682205200195 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
336 0.0024 0.0024430751800537 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
337 0.0019 0.0018579959869385 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
338 0.0007 0.00070285797119141 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
339 0.0014 0.0013978481292725 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'