0

JARDINS DE GAÏA - Douce Humanité ( Thé Militant Les Amanins) Tube 100 g - Rooibos aromatisé Orange - Menthe douce

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

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

Wait! We have a something for you...

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

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

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.032753944397 306 0.2301 0


No Amazon API Requests Made.


App Debug - Total Time 1.032753944397 seconds

Number Time From Start Name Description
1 0.72598481178284 Initialise Initialise FSB Function
2 0.72898101806641 App Controller Start Start of the App controller (called before the controller of every page)
3 0.73184084892273 Start of getCategoryListByGroup Function Before first category groups query
4 0.7321949005127 After initial query Before first category groups query
5 0.73219680786133 Get Category List for Group Before the call to getCategoryList function
6 0.73219990730286 Start of GetCategoryList function Start of the function
7 0.73220300674438 Before getting categories Query to get specific category list
8 0.73269391059875 After getting categories Query to get specific category list
9 0.73269486427307 Before getting category custom Before call to function getCategoryCustom
10 0.73574590682983 After getting category custom After call to function getCategoryCustom
11 0.73574900627136 Before getting category custom Before call to function getCategoryCustom
12 0.75716185569763 After getting category custom After call to function getCategoryCustom
13 0.75716495513916 Before getting category custom Before call to function getCategoryCustom
14 0.7629988193512 After getting category custom After call to function getCategoryCustom
15 0.76300096511841 Before getting category custom Before call to function getCategoryCustom
16 0.76612782478333 After getting category custom After call to function getCategoryCustom
17 0.76612997055054 Before getting category custom Before call to function getCategoryCustom
18 0.76939702033997 After getting category custom After call to function getCategoryCustom
19 0.7693989276886 Before getting category custom Before call to function getCategoryCustom
20 0.77244901657104 After getting category custom After call to function getCategoryCustom
21 0.77245187759399 End of GetCategoryList function End of the function
22 0.77245688438416 Get Category List for Group Before the call to getCategoryList function
23 0.77245998382568 Start of GetCategoryList function Start of the function
24 0.77246189117432 Before getting categories Query to get specific category list
25 0.77275800704956 End of getCategoryListByGroup Function Before return()
26 0.7775399684906 App Controller End End of the App controller (called before the controller of every page)
27 0.77813482284546 Product Start Start of the product info controller
28 0.81969594955444 Cache file not found Starting get product details
29 0.86517691612244 Related products Start getting related products if enabled
30 0.86517882347107 Related Products Start Before the related products are found
31 0.86518001556396 Related Products Keywords Before the related product keywords are found
32 0.86518383026123 Create Keyword List Function Start of function
33 0.86529684066772 Create Keyword List Function After looping provided content - 47 keywords found
34 0.86718082427979 Create Keyword List Function After looping initial keyword list - 43 keywords remaining
35 0.86719083786011 Create Keyword List Function After reducing keyword list
36 0.86744689941406 Create Keyword List Function After selecting by scoring keywords
37 0.86745095252991 Create Keyword List Function After final loop of keywords
38 0.86745285987854 Related Products Keywords After the related product keywords are found
39 0.95296287536621 Related Products End After the related products are found
40 0.96148896217346 Product End End of the product info controller (Product Info)
41 0.96242189407349 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 0.96306681632996 Before Get Options Before the call to getOptions in the tpl class
43 1.0030670166016 After Get Options After the call to getOptions in the tpl class
44 1.0032110214233 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.0032420158386 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.0138018131256 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.0138058662415 Product Info: Before Template Display Before the template is displayed
48 1.0327298641205 Product Info: After Template Display After the template is displayed
49 1.032742023468 Finalizing debug Before the debug is output to the page.
50 1.0327529907227 End of App This is the end of the app logging, final timestamp


Query Debug - 306 Database Queries. Total time 0.2301 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00046086311340332
SELECT parameter, value FROM parameters
2 0.0013 0.0013048648834229
SELECT * FROM `bad_bots`
3 0.0004 0.00040578842163086
SET time_zone = 'Europe/London'
4 0.0004 0.00041007995605469
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0009 0.00085210800170898
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.230.143.213\";}'
6 0.0010 0.00097012519836426
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1713495634'
7 0.0006 0.00059700012207031
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00090599060058594
UPDATE autorun SET lastrun = '2024-04-19 03:00:35' WHERE id = '13'
9 0.0004 0.00039196014404297
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0009 0.00088691711425781
SELECT id FROM pages WHERE pagename = 'jardins-de-gaa-douce-humanite-the-militant-les-amanins-tube-100-g' LIMIT 1
11 0.0011 0.0011029243469238
SELECT id FROM products WHERE pagename = 'jardins-de-gaa-douce-humanite-the-militant-les-amanins-tube-100-g' AND hidden = 0 LIMIT 1
12 0.0008 0.00079798698425293
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0007 0.00070500373840332
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0009 0.00088691711425781
SELECT * FROM pages WHERE pagename = 'jardins-de-gaa-douce-humanite-the-militant-les-amanins-tube-100-g'
15 0.0003 0.00034403800964355
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00047492980957031
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0003 0.00028109550476074
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.0003 0.00034308433532715
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.0003 0.00027894973754883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0003 0.00034809112548828
SELECT id FROM categories WHERE parent_id = '26'
21 0.0003 0.00029301643371582
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.0003 0.00028586387634277
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.0003 0.00031900405883789
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.0003 0.00029397010803223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00049805641174316
SELECT * FROM categorygroups WHERE id = '1'
26 0.0119 0.01186990737915
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.0003 0.00030612945556641
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.0003 0.00025010108947754
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0002 0.0002448558807373
SELECT id FROM categories WHERE parent_id = '27'
30 0.0076 0.0075738430023193
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.0003 0.00034308433532715
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.0003 0.00025296211242676
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.0002 0.00023102760314941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0002 0.00024604797363281
SELECT * FROM categorygroups WHERE id = '1'
35 0.0019 0.0019130706787109
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.0003 0.00025391578674316
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.0003 0.00031781196594238
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0002 0.0002439022064209
SELECT id FROM categories WHERE parent_id = '28'
39 0.0020 0.002018928527832
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.0003 0.00025796890258789
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.0003 0.00025105476379395
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.0003 0.00025606155395508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0002 0.00023818016052246
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00055193901062012
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.0003 0.00025010108947754
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.0003 0.0002741813659668
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0003 0.00028300285339355
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.0005638599395752
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.0003 0.00034093856811523
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.0003 0.00028204917907715
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.0003 0.00026106834411621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0002 0.00023508071899414
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00053596496582031
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.0003 0.0002601146697998
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.0002 0.00023508071899414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0003 0.00026082992553711
SELECT id FROM categories WHERE parent_id = '30'
57 0.0008 0.00084400177001953
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.0003 0.00031399726867676
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.0002 0.0002288818359375
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.0003 0.00028491020202637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0002 0.00022602081298828
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00065207481384277
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.0002 0.00024890899658203
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.0003 0.00026297569274902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0003 0.00026416778564453
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00056600570678711
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.0003 0.00026297569274902
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.0002 0.00023317337036133
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.0002 0.0002281665802002
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.00025510787963867
SELECT * FROM categorygroups WHERE id = '1'
71 0.0003 0.00028491020202637
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0002 0.00023794174194336
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0003 0.00033187866210938
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0002 0.00024509429931641
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.0003 0.00025701522827148
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0003 0.00032496452331543
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0006 0.00060892105102539
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.0003 0.00025510787963867
SELECT * FROM ipgeocountries WHERE INET_ATON('3.230.143.213') >= INET_ATON(ip_start) AND INET_ATON('3.230.143.213') <= INET_ATON(ip_end)
79 0.0003 0.00028109550476074
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0003 0.00025296211242676
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0007 0.0006871223449707
SELECT * FROM products WHERE pagename = 'jardins-de-gaa-douce-humanite-the-militant-les-amanins-tube-100-g'
82 0.0011 0.0011470317840576
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1198
83 0.0005 0.00048089027404785
SELECT * FROM manufacturers WHERE id = '261'
84 0.0012 0.0012350082397461
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
85 0.0003 0.00034093856811523
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '261' LIMIT 1
86 0.0014 0.0013749599456787
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '261' ORDER BY RAND() LIMIT 1
87 0.0003 0.00032496452331543
SELECT * FROM productimages WHERE product_id = '1017' ORDER BY sortorder ASC
88 0.0003 0.00028610229492188
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
89 0.0010 0.0010130405426025
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '261'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0003 0.0002601146697998
SELECT * FROM manufacturerimages WHERE manufacturer_id = '261'
91 0.0006 0.00063586235046387
SELECT category_id FROM products_categories WHERE product_id = '1198'
92 0.0004 0.00037717819213867
SELECT * FROM categories WHERE id = '27'
93 0.0111 0.011145830154419
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.0002 0.00024795532226562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0002 0.00022792816162109
SELECT id FROM categories WHERE parent_id = '27'
96 0.0085 0.0084991455078125
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.0006 0.00058197975158691
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.0002 0.00023603439331055
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.0002 0.00021505355834961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0003 0.00025582313537598
SELECT * FROM productimages WHERE product_id = '1198' ORDER BY sortorder ASC
101 0.0002 0.00022220611572266
SELECT * FROM product_image_select WHERE product_id = '1198'
102 0.0002 0.00022506713867188
SELECT * FROM productcustomimages WHERE product_id = '1198'
103 0.0005 0.00048518180847168
SELECT * FROM productfeeds WHERE product_id = '1198' ORDER BY item_date DESC
104 0.0007 0.00065994262695312
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1198' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0014 0.0014181137084961
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1198' AND t.hidden = 0 AND display_product = 1
106 0.0002 0.0002448558807373
SELECT * FROM tags WHERE id = '1'
107 0.0024 0.002424955368042
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
108 0.0022 0.00217604637146
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '1'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
109 0.0027 0.0026519298553467
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '1' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
110 0.0004 0.00035190582275391
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
111 0.0008 0.00079011917114258
SELECT * FROM productamazoncontent WHERE product_id = '1198'
112 0.0011 0.0010831356048584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1198' AND a.name = n.originalname
113 0.0003 0.00027203559875488
SELECT * FROM productoffers WHERE product_id = '1198' AND merchantid = 'A1X6FK5RDHNB96'
114 0.0030 0.002985954284668
SELECT * FROM productoffers
                WHERE product_id = '1198' AND price > 0
                ORDER BY price ASC LIMIT 1
115 0.0003 0.00027012825012207
SELECT * FROM productoffers
                WHERE product_id = 1198
                ORDER BY price ASC LIMIT 1
116 0.0003 0.00027203559875488
SELECT value FROM productattributes
                WHERE product_id = '1198'
                AND name = 'ListPriceAmount'
117 0.0002 0.000244140625
SELECT value FROM productattributes WHERE product_id = '1198' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0003 0.00027608871459961
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
119 0.0068 0.0067930221557617
SELECT *, MATCH (description, title) AGAINST ('amanins tube 100' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('amanins tube 100' IN BOOLEAN MODE) AND 1198 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
120 0.0008 0.00075507164001465
SELECT *, MATCH (description, title) AGAINST ('amanins tube 100' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('amanins tube 100' IN BOOLEAN MODE) AND 1198 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
121 0.0006 0.00061798095703125
SELECT *, MATCH (description, title) AGAINST ('amanins tube 100' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('amanins tube 100' IN BOOLEAN MODE) AND 1198 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
122 0.0005 0.00045490264892578
SELECT * FROM productimages WHERE product_id = '1246' ORDER BY sortorder ASC
123 0.0004 0.00037407875061035
SELECT * FROM product_image_select WHERE product_id = '1246'
124 0.0002 0.0002291202545166
SELECT * FROM productcustomimages WHERE product_id = '1246'
125 0.0003 0.00026202201843262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1246' AND a.name = n.originalname
126 0.0002 0.00023984909057617
SELECT * FROM productoffers WHERE product_id = '1246' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0002 0.00023388862609863
SELECT * FROM productoffers
                WHERE product_id = '1246' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0002 0.00020599365234375
SELECT value FROM productattributes WHERE product_id = '1246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '2498' ORDER BY sortorder ASC
130 0.0009 0.00088286399841309
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
131 0.0002 0.00021219253540039
SELECT * FROM product_image_select WHERE product_id = '2498'
132 0.0002 0.00022006034851074
SELECT * FROM productcustomimages WHERE product_id = '2498'
133 0.0005 0.00050687789916992
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
134 0.0006 0.00059103965759277
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
135 0.0004 0.0003969669342041
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
136 0.0003 0.00034189224243164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2498' AND a.name = n.originalname
137 0.0002 0.00021696090698242
SELECT * FROM productoffers WHERE product_id = '2498' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0003 0.00025582313537598
SELECT * FROM productoffers
                WHERE product_id = '2498' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0002 0.00023317337036133
SELECT * FROM productoffers
                WHERE product_id = 2498
                ORDER BY price ASC LIMIT 1
140 0.0002 0.00019502639770508
SELECT value FROM productattributes
                WHERE product_id = '2498'
                AND name = 'ListPriceAmount'
141 0.0002 0.00022697448730469
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
142 0.0002 0.00021600723266602
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
143 0.0002 0.00020503997802734
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
144 0.0002 0.00021910667419434
SELECT value FROM productattributes WHERE product_id = '2498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0005 0.00054788589477539
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
146 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
147 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '1204'
148 0.0002 0.00021100044250488
SELECT * FROM productcustomimages WHERE product_id = '1204'
149 0.0002 0.0002448558807373
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
150 0.0002 0.0002448558807373
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0003 0.00025606155395508
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0002 0.00022697448730469
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0005 0.00052905082702637
SELECT * FROM productimages WHERE product_id = '3666' ORDER BY sortorder ASC
154 0.0007 0.00066208839416504
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
155 0.0004 0.00037598609924316
SELECT * FROM product_image_select WHERE product_id = '3666'
156 0.0005 0.00049614906311035
SELECT * FROM productcustomimages WHERE product_id = '3666'
157 0.0006 0.00060105323791504
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
158 0.0006 0.00061702728271484
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
159 0.0004 0.00041508674621582
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
160 0.0006 0.00063109397888184
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3666' AND a.name = n.originalname
161 0.0004 0.00040698051452637
SELECT * FROM productoffers WHERE product_id = '3666' AND merchantid = 'A1X6FK5RDHNB96'
162 0.0004 0.00038599967956543
SELECT * FROM productoffers
                WHERE product_id = '3666' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0003 0.00031113624572754
SELECT * FROM productoffers
                WHERE product_id = 3666
                ORDER BY price ASC LIMIT 1
164 0.0004 0.00039291381835938
SELECT value FROM productattributes
                WHERE product_id = '3666'
                AND name = 'ListPriceAmount'
165 0.0002 0.00020384788513184
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
166 0.0002 0.00020098686218262
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
167 0.0002 0.0001988410949707
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
168 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '3666' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0006 0.00056290626525879
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
170 0.0072 0.0072009563446045
SELECT *, MATCH (description, title) AGAINST ('humanité thé militant' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('humanité thé militant' IN BOOLEAN MODE) AND 1198 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
171 0.0007 0.00066590309143066
SELECT *, MATCH (description, title) AGAINST ('humanité thé militant' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('humanité thé militant' IN BOOLEAN MODE) AND 1198 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
172 0.0006 0.00059795379638672
SELECT *, MATCH (description, title) AGAINST ('humanité thé militant' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('humanité thé militant' IN BOOLEAN MODE) AND 1198 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
173 0.0079 0.0078680515289307
SELECT *, MATCH (description, title) AGAINST ('militant les amanins' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('militant les amanins' IN BOOLEAN MODE) AND 1198 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
174 0.0006 0.0005800724029541
SELECT *, MATCH (description, title) AGAINST ('militant les amanins' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('militant les amanins' IN BOOLEAN MODE) AND 1198 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
175 0.0005 0.00054192543029785
SELECT *, MATCH (description, title) AGAINST ('militant les amanins' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('militant les amanins' IN BOOLEAN MODE) AND 1198 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
176 0.0068 0.0067617893218994
SELECT *, MATCH (description, title) AGAINST ('gaa douce humanité' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('gaa douce humanité' IN BOOLEAN MODE) AND 1198 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
177 0.0006 0.00061392784118652
SELECT *, MATCH (description, title) AGAINST ('gaa douce humanité' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('gaa douce humanité' IN BOOLEAN MODE) AND 1198 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
178 0.0006 0.00058794021606445
SELECT *, MATCH (description, title) AGAINST ('gaa douce humanité' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('gaa douce humanité' IN BOOLEAN MODE) AND 1198 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
179 0.0066 0.0066308975219727
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 1198 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
180 0.0006 0.00058603286743164
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 1198 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
181 0.0008 0.00078892707824707
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 1198 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
182 0.0003 0.00028681755065918
SELECT * FROM productimages WHERE product_id = '1095' ORDER BY sortorder ASC
183 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '1095'
184 0.0003 0.00029301643371582
SELECT * FROM productcustomimages WHERE product_id = '1095'
185 0.0002 0.00023889541625977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1095' AND a.name = n.originalname
186 0.0002 0.00022006034851074
SELECT * FROM productoffers WHERE product_id = '1095' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = '1095' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0002 0.00021505355834961
SELECT value FROM productattributes WHERE product_id = '1095' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0002 0.00023484230041504
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
190 0.0002 0.00018906593322754
SELECT * FROM product_image_select WHERE product_id = '1204'
191 0.0002 0.00019502639770508
SELECT * FROM productcustomimages WHERE product_id = '1204'
192 0.0002 0.00022506713867188
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
193 0.0002 0.00020885467529297
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0002 0.00022983551025391
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0002 0.00020313262939453
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0010 0.00099301338195801
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1198') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
197 0.0152 0.015156030654907
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'amz'  AND p.id <> '1198' ORDER BY RAND()
198 0.0007 0.00067615509033203
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'ebay' AND p.id <> '1198' ORDER BY RAND()
199 0.0004 0.00043320655822754
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'custom' AND p.id <> '1198' ORDER BY RAND()
200 0.0004 0.0003969669342041
SELECT * FROM productimages WHERE product_id = '1377' ORDER BY sortorder ASC
201 0.0003 0.00034284591674805
SELECT * FROM product_image_select WHERE product_id = '1377'
202 0.0003 0.0003199577331543
SELECT * FROM productcustomimages WHERE product_id = '1377'
203 0.0011 0.0010931491851807
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1377' AND a.name = n.originalname
204 0.0005 0.00045299530029297
SELECT * FROM productoffers WHERE product_id = '1377' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0004 0.00036287307739258
SELECT * FROM productoffers
                WHERE product_id = '1377' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0003 0.00034499168395996
SELECT * FROM productoffers
                WHERE product_id = 1377
                ORDER BY price ASC LIMIT 1
207 0.0004 0.00036501884460449
SELECT value FROM productattributes
                WHERE product_id = '1377'
                AND name = 'ListPriceAmount'
208 0.0004 0.00039005279541016
SELECT id,asin FROM products WHERE parent_id = 1198
209 0.0002 0.00022697448730469
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1198' ORDER BY timestamp DESC
210 0.0002 0.00020909309387207
SELECT category_id FROM products_categories WHERE product_id = '1198'
211 0.0002 0.00022101402282715
SELECT * FROM categories WHERE id = '27'
212 0.0002 0.00022006034851074
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
213 0.0002 0.0002131462097168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
214 0.0002 0.00018596649169922
SELECT id FROM categories WHERE parent_id = '27'
215 0.0002 0.00020790100097656
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 
216 0.0002 0.00020384788513184
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 
217 0.0002 0.00022101402282715
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
218 0.0002 0.00019407272338867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
219 0.0002 0.00022721290588379
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1198' AND a.name = n.originalname
220 0.0002 0.00021505355834961
SELECT * FROM productoffers WHERE product_id = '1198' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '1198' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = 1198
                ORDER BY price ASC LIMIT 1
223 0.0002 0.0002129077911377
SELECT value FROM productattributes
                WHERE product_id = '1198'
                AND name = 'ListPriceAmount'
224 0.0006 0.00057196617126465
SELECT * FROM products WHERE id = '1198'
225 0.0002 0.00023603439331055
SELECT value FROM productattributes WHERE product_id = '1198' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0002 0.00023579597473145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1198' AND a.name = n.originalname
227 0.0002 0.00023293495178223
SELECT * FROM productoffers WHERE product_id = '1198' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0002 0.00024700164794922
SELECT * FROM productoffers
                WHERE product_id = '1198' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = 1198
                ORDER BY price ASC LIMIT 1
230 0.0002 0.00020813941955566
SELECT value FROM productattributes
                WHERE product_id = '1198'
                AND name = 'ListPriceAmount'
231 0.0004 0.00040602684020996
SELECT category_id FROM products_categories WHERE product_id = '1198' AND prod_type = 'amz'
232 0.0003 0.00027298927307129
SELECT parent_id FROM categories WHERE id = '27'
233 0.0003 0.00025200843811035
SELECT * FROM categories WHERE id = '27'
234 0.0002 0.00019979476928711
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
235 0.0002 0.00020098686218262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
236 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '27'
237 0.0003 0.00028204917907715
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
238 0.0002 0.00021600723266602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
239 0.0002 0.00022006034851074
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
240 0.0002 0.00020098686218262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
241 0.0003 0.00031113624572754
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
242 0.0004 0.00035500526428223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
243 0.0002 0.00021219253540039
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
244 0.0164 0.016396045684814
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
245 0.0003 0.00026679039001465
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
246 0.0002 0.00020885467529297
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
247 0.0004 0.00043487548828125
SELECT * FROM products WHERE id = 1626
248 0.0006 0.00057506561279297
SELECT * FROM products WHERE id = 4041
249 0.0005 0.00052380561828613
SELECT * FROM products WHERE id = 4312
250 0.0005 0.00050806999206543
SELECT * FROM products WHERE id = 777
251 0.0005 0.00051498413085938
SELECT * FROM products WHERE id = 4213
252 0.0005 0.00050592422485352
SELECT * FROM products WHERE id = 3881
253 0.0005 0.00052309036254883
SELECT * FROM products WHERE id = '1626'
254 0.0002 0.00022220611572266
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
255 0.0002 0.0002281665802002
SELECT * FROM product_image_select WHERE product_id = '1626'
256 0.0002 0.00023293495178223
SELECT * FROM productcustomimages WHERE product_id = '1626'
257 0.0002 0.00023889541625977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
258 0.0002 0.000244140625
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0004 0.00036716461181641
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0002 0.00020503997802734
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0005 0.00046491622924805
SELECT * FROM products WHERE id = '4041'
262 0.0002 0.00024294853210449
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
263 0.0002 0.00023889541625977
SELECT * FROM product_image_select WHERE product_id = '4041'
264 0.0002 0.0002439022064209
SELECT * FROM productcustomimages WHERE product_id = '4041'
265 0.0003 0.00025606155395508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
266 0.0003 0.00025391578674316
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
267 0.0003 0.00031900405883789
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
268 0.0003 0.00026202201843262
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
269 0.0006 0.00056195259094238
SELECT * FROM products WHERE id = '4312'
270 0.0003 0.00026798248291016
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
271 0.0004 0.00038814544677734
SELECT * FROM product_image_select WHERE product_id = '4312'
272 0.0003 0.00034594535827637
SELECT * FROM productcustomimages WHERE product_id = '4312'
273 0.0003 0.00031876564025879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
274 0.0003 0.00028300285339355
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
275 0.0004 0.0004279613494873
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
276 0.0003 0.0002598762512207
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
277 0.0005 0.0005340576171875
SELECT * FROM products WHERE id = '777'
278 0.0004 0.00038504600524902
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
279 0.0003 0.0002598762512207
SELECT * FROM product_image_select WHERE product_id = '777'
280 0.0003 0.00025796890258789
SELECT * FROM productcustomimages WHERE product_id = '777'
281 0.0003 0.00031709671020508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
282 0.0003 0.00026488304138184
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
283 0.0003 0.00028610229492188
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
284 0.0003 0.00032687187194824
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
285 0.0005 0.00048089027404785
SELECT * FROM products WHERE id = '4213'
286 0.0005 0.00045895576477051
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
287 0.0003 0.00025582313537598
SELECT * FROM product_image_select WHERE product_id = '4213'
288 0.0003 0.00028395652770996
SELECT * FROM productcustomimages WHERE product_id = '4213'
289 0.0003 0.00027084350585938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
290 0.0003 0.0002901554107666
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
291 0.0003 0.00034809112548828
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
292 0.0003 0.00033402442932129
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
293 0.0006 0.00058794021606445
SELECT * FROM products WHERE id = '3881'
294 0.0004 0.00044989585876465
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
295 0.0003 0.00025510787963867
SELECT * FROM product_image_select WHERE product_id = '3881'
296 0.0003 0.0002739429473877
SELECT * FROM productcustomimages WHERE product_id = '3881'
297 0.0003 0.0002601146697998
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
298 0.0003 0.00027179718017578
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
299 0.0003 0.00030088424682617
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
300 0.0003 0.00031113624572754
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
301 0.0003 0.0003349781036377
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
302 0.0005 0.00051689147949219
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
303 0.0005 0.00053906440734863
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
304 0.0005 0.00050687789916992
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
305 0.0005 0.00054001808166504
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
306 0.0006 0.00055909156799316
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'