0

A0127 Boîte à thé Boîte scellée Boîte à café Matériel de Bambou Mini Portable Voyage en Plein air 4,5 x 6,5 cm

Price: Click Button for Price
Product prices and availability are accurate as of 2022-03-16 12:26:03 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.

Product Features

Design unique, léger mais durable. La doublure est adaptée à une utilisation alimentaire. Hauteur: 6,5 cm - Diamètre: 4,5 cm Joint de couvercle tordu pour garder frais et saveur, léger et pratique C'est un bon moyen de stocker sucre, café, thé, pièces de monnaie et cure-dents. Un bon cadeau pour la famille, les amis, les voisins et les connaissances.

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
2.7822041511536 339 0.9816 0


No Amazon API Requests Made.


App Debug - Total Time 2.7822041511536 seconds

Number Time From Start Name Description
1 1.7141649723053 Initialise Initialise FSB Function
2 1.7242159843445 App Controller Start Start of the App controller (called before the controller of every page)
3 1.7684240341187 Start of getCategoryListByGroup Function Before first category groups query
4 1.7712891101837 After initial query Before first category groups query
5 1.771290063858 Get Category List for Group Before the call to getCategoryList function
6 1.7712960243225 Start of GetCategoryList function Start of the function
7 1.771299123764 Before getting categories Query to get specific category list
8 1.7739310264587 After getting categories Query to get specific category list
9 1.7739319801331 Before getting category custom Before call to function getCategoryCustom
10 1.7991189956665 After getting category custom After call to function getCategoryCustom
11 1.7991230487823 Before getting category custom Before call to function getCategoryCustom
12 1.8106660842896 After getting category custom After call to function getCategoryCustom
13 1.8106689453125 Before getting category custom Before call to function getCategoryCustom
14 1.8172121047974 After getting category custom After call to function getCategoryCustom
15 1.817214012146 Before getting category custom Before call to function getCategoryCustom
16 1.8223049640656 After getting category custom After call to function getCategoryCustom
17 1.8223071098328 Before getting category custom Before call to function getCategoryCustom
18 1.8276350498199 After getting category custom After call to function getCategoryCustom
19 1.8276369571686 Before getting category custom Before call to function getCategoryCustom
20 1.8339750766754 After getting category custom After call to function getCategoryCustom
21 1.833976984024 End of GetCategoryList function End of the function
22 1.8339829444885 Get Category List for Group Before the call to getCategoryList function
23 1.8339860439301 Start of GetCategoryList function Start of the function
24 1.8339879512787 Before getting categories Query to get specific category list
25 1.8345880508423 End of getCategoryListByGroup Function Before return()
26 2.3847560882568 App Controller End End of the App controller (called before the controller of every page)
27 2.3850290775299 Product Start Start of the product info controller
28 2.3998839855194 Cache file not found Starting get product details
29 2.4975140094757 Related products Start getting related products if enabled
30 2.49751496315 Related Products Start Before the related products are found
31 2.4975159168243 Related Products Keywords Before the related product keywords are found
32 2.4975199699402 Create Keyword List Function Start of function
33 2.4976301193237 Create Keyword List Function After looping provided content - 59 keywords found
34 2.4999661445618 Create Keyword List Function After looping initial keyword list - 48 keywords remaining
35 2.4999771118164 Create Keyword List Function After reducing keyword list
36 2.5002970695496 Create Keyword List Function After selecting by scoring keywords
37 2.5003011226654 Create Keyword List Function After final loop of keywords
38 2.500303030014 Related Products Keywords After the related product keywords are found
39 2.5763640403748 Related Products End After the related products are found
40 2.6251130104065 Product End End of the product info controller (Product Info)
41 2.6271300315857 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.6288781166077 Before Get Options Before the call to getOptions in the tpl class
43 2.692626953125 After Get Options After the call to getOptions in the tpl class
44 2.6927659511566 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.6927919387817 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.7329099178314 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.7329149246216 Product Info: Before Template Display Before the template is displayed
48 2.7821860313416 Product Info: After Template Display After the template is displayed
49 2.7821910381317 Finalizing debug Before the debug is output to the page.
50 2.7822029590607 End of App This is the end of the app logging, final timestamp


Query Debug - 339 Database Queries. Total time 0.9816 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.0022759437561035
SELECT parameter, value FROM parameters
2 0.0079 0.0078699588775635
SELECT * FROM `bad_bots`
3 0.0009 0.00086188316345215
SET time_zone = 'Europe/London'
4 0.0035 0.0034661293029785
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0036 0.0035738945007324
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.81\";}'
6 0.0035 0.0035068988800049
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1739320410'
7 0.0040 0.003972053527832
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00081419944763184
UPDATE autorun SET lastrun = '2025-02-12 00:33:30' WHERE id = '16'
9 0.0009 0.00092005729675293
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0037 0.0036599636077881
SELECT id FROM pages WHERE pagename = 'a0127-bote-the-bote-scellee-bote-cafe-materiel-de-bambou-mini' LIMIT 1
11 0.0050 0.004971981048584
SELECT id FROM products WHERE pagename = 'a0127-bote-the-bote-scellee-bote-cafe-materiel-de-bambou-mini' AND hidden = 0 LIMIT 1
12 0.0043 0.0043439865112305
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0384 0.038444995880127
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0010 0.00095605850219727
SELECT * FROM pages WHERE pagename = 'a0127-bote-the-bote-scellee-bote-cafe-materiel-de-bambou-mini'
15 0.0029 0.0028531551361084
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0026 0.0026149749755859
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0071 0.00714111328125
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.0021 0.0020730495452881
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.0013 0.0013329982757568
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.0004889965057373
SELECT id FROM categories WHERE parent_id = '26'
21 0.0058 0.005763053894043
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.0030 0.0029861927032471
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.0031 0.003058910369873
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.0017 0.0016939640045166
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00050497055053711
SELECT * FROM categorygroups WHERE id = '1'
26 0.0037 0.0037147998809814
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.0005 0.00053501129150391
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.0004 0.00043797492980957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00045895576477051
SELECT id FROM categories WHERE parent_id = '27'
30 0.0039 0.0038759708404541
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.00082111358642578
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.0006 0.00058317184448242
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.0005 0.00052690505981445
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00048685073852539
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.0014450550079346
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.0005 0.0005040168762207
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.0004 0.00041389465332031
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00044512748718262
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.001594066619873
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.0005 0.00052094459533691
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.0006 0.00057005882263184
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.0005 0.00052690505981445
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00044703483581543
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00059103965759277
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.0005 0.00052404403686523
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.00041913986206055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00046300888061523
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00072407722473145
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.0005 0.00051498413085938
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.0006 0.00058603286743164
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.00055599212646484
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0006 0.00063514709472656
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00061917304992676
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.0005 0.00047707557678223
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.0004 0.00041317939758301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00042200088500977
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00071811676025391
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.0006 0.00057005882263184
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.0006 0.00061607360839844
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.0006 0.00055503845214844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0009 0.00086092948913574
SELECT * FROM categorygroups WHERE id = '1'
62 0.0012 0.0012388229370117
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.0006 0.00056695938110352
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.0007 0.0006718635559082
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00046896934509277
SELECT id FROM categories WHERE parent_id = '31'
66 0.0007 0.00073504447937012
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.0005 0.00051093101501465
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.0006 0.00055599212646484
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.00052881240844727
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0010 0.00098299980163574
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.00058984756469727
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0032 0.0032229423522949
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0021 0.0020689964294434
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0008 0.00076389312744141
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.0022 0.002173900604248
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0011 0.0010890960693359
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0022 0.0022051334381104
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.5267 0.52672600746155
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.81') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.81') <= INET_ATON(ip_end)
79 0.0023 0.0022709369659424
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0080 0.0079760551452637
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0011 0.0011391639709473
SELECT * FROM products WHERE pagename = 'a0127-bote-the-bote-scellee-bote-cafe-materiel-de-bambou-mini'
82 0.0013 0.0012998580932617
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3693
83 0.0008 0.00081896781921387
SELECT * FROM manufacturers WHERE id = '543'
84 0.0007 0.00071406364440918
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '543'
85 0.0025 0.0025010108947754
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '543' LIMIT 1
86 0.0025 0.0024950504302979
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '543' ORDER BY RAND() LIMIT 1
87 0.0006 0.00058698654174805
SELECT * FROM productimages WHERE product_id = '3940' ORDER BY sortorder ASC
88 0.0006 0.00060200691223145
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '543'
89 0.0006 0.00060415267944336
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '543'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0006 0.00063490867614746
SELECT * FROM manufacturerimages WHERE manufacturer_id = '543'
91 0.0008 0.00078916549682617
SELECT category_id FROM products_categories WHERE product_id = '3693'
92 0.0008 0.00077295303344727
SELECT * FROM categories WHERE id = '26'
93 0.0098 0.0097529888153076
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
94 0.0005 0.00053691864013672
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
95 0.0004 0.00039911270141602
SELECT id FROM categories WHERE parent_id = '26'
96 0.0080 0.0079610347747803
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 
97 0.0007 0.0007171630859375
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 
98 0.0008 0.00077986717224121
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
99 0.0005 0.00054311752319336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
100 0.0006 0.00056099891662598
SELECT * FROM productimages WHERE product_id = '3693' ORDER BY sortorder ASC
101 0.0008 0.00076508522033691
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3693' AND p.id = pi.product_id ORDER BY pi.sortorder
102 0.0019 0.0018868446350098
SELECT * FROM product_image_select WHERE product_id = '3693'
103 0.0015 0.0014939308166504
SELECT * FROM productcustomimages WHERE product_id = '3693'
104 0.0012 0.0012228488922119
SELECT * FROM productfeeds WHERE product_id = '3693' ORDER BY item_date DESC
105 0.0029 0.0029349327087402
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3693' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
106 0.0029 0.0029120445251465
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3693' AND t.hidden = 0 AND display_product = 1
107 0.0005 0.00049495697021484
SELECT * FROM tags WHERE id = '216'
108 0.0098 0.009788990020752
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '216'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
109 0.0075 0.0074999332427979
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '216'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
110 0.0073 0.0072610378265381
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '216' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
111 0.0014 0.0013518333435059
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
112 0.0015 0.0015478134155273
SELECT * FROM tags WHERE id = '62'
113 0.0019 0.0019190311431885
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
114 0.0022 0.0021669864654541
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
115 0.0016 0.0016179084777832
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '62' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
116 0.0006 0.00064992904663086
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
117 0.0005 0.00046491622924805
SELECT * FROM tags WHERE id = '91'
118 0.0011 0.0011281967163086
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '91'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
119 0.0010 0.0010290145874023
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '91'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
120 0.0010 0.00098896026611328
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '91' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
121 0.0005 0.00050616264343262
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
122 0.0027 0.0027217864990234
SELECT * FROM productamazoncontent WHERE product_id = '3693'
123 0.0025 0.0024549961090088
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 = '3693'
                GROUP BY o.product_id
124 0.0027 0.0026969909667969
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     = '3693'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
125 0.0005 0.00054502487182617
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3693
126 0.0015 0.001539945602417
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3693' AND a.name = n.originalname
127 0.0004 0.00042295455932617
SELECT * FROM productoffers WHERE product_id = '3693' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0004 0.00040793418884277
SELECT * FROM productoffers
                WHERE product_id = '3693' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0004 0.00037813186645508
SELECT * FROM productoffers
                WHERE product_id = 3693
                ORDER BY price ASC LIMIT 1
130 0.0006 0.00055694580078125
SELECT value FROM productattributes
                WHERE product_id = '3693'
                AND name = 'ListPriceAmount'
131 0.0006 0.00055718421936035
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 = '3693'
                GROUP BY o.product_id
132 0.0007 0.00071001052856445
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     = '3693'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
133 0.0005 0.00047516822814941
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3693
134 0.0006 0.00064396858215332
SELECT value FROM productattributes WHERE product_id = '3693' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0007 0.00068283081054688
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3693'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
136 0.0006 0.00057697296142578
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
137 0.0056 0.0056428909301758
SELECT *, MATCH (description, title) AGAINST ('boÃte' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('boÃte' IN BOOLEAN MODE) AND 3693 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
138 0.0010 0.00098395347595215
SELECT *, MATCH (description, title) AGAINST ('boÃte' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('boÃte' IN BOOLEAN MODE) AND 3693 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
139 0.0008 0.00084996223449707
SELECT *, MATCH (description, title) AGAINST ('boÃte' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('boÃte' IN BOOLEAN MODE) AND 3693 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
140 0.0118 0.011772871017456
SELECT *, MATCH (description, title) AGAINST ('mini portable voyage' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('mini portable voyage' IN BOOLEAN MODE) AND 3693 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
141 0.0007 0.0007479190826416
SELECT *, MATCH (description, title) AGAINST ('mini portable voyage' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('mini portable voyage' IN BOOLEAN MODE) AND 3693 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
142 0.0006 0.00062799453735352
SELECT *, MATCH (description, title) AGAINST ('mini portable voyage' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('mini portable voyage' IN BOOLEAN MODE) AND 3693 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
143 0.0008 0.00081515312194824
SELECT * FROM productimages WHERE product_id = '4895' ORDER BY sortorder ASC
144 0.0005 0.00053691864013672
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4895' AND p.id = pi.product_id ORDER BY pi.sortorder
145 0.0008 0.00082588195800781
SELECT * FROM product_image_select WHERE product_id = '4895'
146 0.0005 0.00050806999206543
SELECT * FROM productcustomimages WHERE product_id = '4895'
147 0.0007 0.00067281723022461
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 = '4895'
                GROUP BY o.product_id
148 0.0011 0.0011000633239746
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     = '4895'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
149 0.0005 0.00052499771118164
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4895
150 0.0011 0.0011370182037354
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4895' AND a.name = n.originalname
151 0.0005 0.0005490779876709
SELECT * FROM productoffers WHERE product_id = '4895' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0005 0.00046992301940918
SELECT * FROM productoffers
                WHERE product_id = '4895' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00042080879211426
SELECT * FROM productoffers
                WHERE product_id = 4895
                ORDER BY price ASC LIMIT 1
154 0.0005 0.00047492980957031
SELECT value FROM productattributes
                WHERE product_id = '4895'
                AND name = 'ListPriceAmount'
155 0.0005 0.00052499771118164
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 = '4895'
                GROUP BY o.product_id
156 0.0009 0.00092315673828125
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     = '4895'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
157 0.0006 0.00059795379638672
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4895
158 0.0008 0.00082111358642578
SELECT value FROM productattributes WHERE product_id = '4895' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0009 0.00089001655578613
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4895'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
160 0.0007 0.00070905685424805
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
161 0.0008 0.00080680847167969
SELECT * FROM product_image_select WHERE product_id = '4213'
162 0.0005 0.00050997734069824
SELECT * FROM productcustomimages WHERE product_id = '4213'
163 0.0018 0.0018360614776611
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
164 0.0006 0.00063204765319824
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0006 0.00055599212646484
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0005 0.00054001808166504
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0007 0.00073099136352539
SELECT * FROM productimages WHERE product_id = '2498' ORDER BY sortorder ASC
168 0.0009 0.00090503692626953
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
169 0.0007 0.0006868839263916
SELECT * FROM product_image_select WHERE product_id = '2498'
170 0.0005 0.00048279762268066
SELECT * FROM productcustomimages WHERE product_id = '2498'
171 0.0006 0.00064706802368164
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
172 0.0007 0.00069212913513184
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
173 0.0005 0.00045514106750488
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
174 0.0011 0.0010981559753418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2498' AND a.name = n.originalname
175 0.0004 0.00043320655822754
SELECT * FROM productoffers WHERE product_id = '2498' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0004 0.00040793418884277
SELECT * FROM productoffers
                WHERE product_id = '2498' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0005 0.00051212310791016
SELECT * FROM productoffers
                WHERE product_id = 2498
                ORDER BY price ASC LIMIT 1
178 0.0004 0.00043988227844238
SELECT value FROM productattributes
                WHERE product_id = '2498'
                AND name = 'ListPriceAmount'
179 0.0005 0.0004878044128418
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
180 0.0007 0.0007021427154541
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
181 0.0005 0.00052213668823242
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
182 0.0006 0.00057387351989746
SELECT value FROM productattributes WHERE product_id = '2498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0007 0.00073814392089844
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
184 0.0006 0.00061297416687012
SELECT * FROM productimages WHERE product_id = '2336' ORDER BY sortorder ASC
185 0.0006 0.00060391426086426
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2336' AND p.id = pi.product_id ORDER BY pi.sortorder
186 0.0006 0.00062894821166992
SELECT * FROM product_image_select WHERE product_id = '2336'
187 0.0005 0.00051093101501465
SELECT * FROM productcustomimages WHERE product_id = '2336'
188 0.0006 0.00056910514831543
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 = '2336'
                GROUP BY o.product_id
189 0.0007 0.00070786476135254
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     = '2336'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
190 0.0005 0.00046396255493164
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2336
191 0.0012 0.0011990070343018
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2336' AND a.name = n.originalname
192 0.0005 0.00045895576477051
SELECT * FROM productoffers WHERE product_id = '2336' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0005 0.0004580020904541
SELECT * FROM productoffers
                WHERE product_id = '2336' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0006 0.00055694580078125
SELECT * FROM productoffers
                WHERE product_id = 2336
                ORDER BY price ASC LIMIT 1
195 0.0004 0.00042414665222168
SELECT value FROM productattributes
                WHERE product_id = '2336'
                AND name = 'ListPriceAmount'
196 0.0005 0.00051283836364746
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 = '2336'
                GROUP BY o.product_id
197 0.0007 0.00070691108703613
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     = '2336'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
198 0.0005 0.00046682357788086
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2336
199 0.0006 0.00059890747070312
SELECT value FROM productattributes WHERE product_id = '2336' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0008 0.00078320503234863
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2336'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
201 0.0005 0.00054693222045898
SELECT * FROM productimages WHERE product_id = '3903' ORDER BY sortorder ASC
202 0.0006 0.00059199333190918
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3903' AND p.id = pi.product_id ORDER BY pi.sortorder
203 0.0007 0.00066494941711426
SELECT * FROM product_image_select WHERE product_id = '3903'
204 0.0005 0.00046205520629883
SELECT * FROM productcustomimages WHERE product_id = '3903'
205 0.0006 0.00061798095703125
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 = '3903'
                GROUP BY o.product_id
206 0.0008 0.0007932186126709
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     = '3903'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
207 0.0005 0.00054216384887695
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3903
208 0.0009 0.00088000297546387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3903' AND a.name = n.originalname
209 0.0004 0.00041913986206055
SELECT * FROM productoffers WHERE product_id = '3903' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = '3903' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0005 0.00050711631774902
SELECT * FROM productoffers
                WHERE product_id = 3903
                ORDER BY price ASC LIMIT 1
212 0.0004 0.00044989585876465
SELECT value FROM productattributes
                WHERE product_id = '3903'
                AND name = 'ListPriceAmount'
213 0.0005 0.00054216384887695
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 = '3903'
                GROUP BY o.product_id
214 0.0008 0.00080299377441406
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     = '3903'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
215 0.0005 0.00050902366638184
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3903
216 0.0006 0.00059103965759277
SELECT value FROM productattributes WHERE product_id = '3903' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0007 0.00073099136352539
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3903'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
218 0.0006 0.00062799453735352
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3903'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
219 0.0006 0.00062704086303711
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
220 0.0007 0.00065302848815918
SELECT * FROM product_image_select WHERE product_id = '3881'
221 0.0008 0.00082707405090332
SELECT * FROM productcustomimages WHERE product_id = '3881'
222 0.0012 0.0012459754943848
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
223 0.0006 0.00055313110351562
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0005 0.00053811073303223
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0005 0.0005190372467041
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0005 0.00050902366638184
SELECT id,asin FROM products WHERE parent_id = 3693
227 0.0005 0.00050091743469238
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3694
228 0.0006 0.00059604644775391
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3694
229 0.0004 0.00041604042053223
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3695
230 0.0005 0.00050902366638184
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3695
231 0.0004 0.00043606758117676
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3696
232 0.0005 0.00049090385437012
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3696
233 0.0004 0.0004270076751709
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3697
234 0.0005 0.00053501129150391
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3697
235 0.0019 0.0018618106842041
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3693' ORDER BY timestamp DESC
236 0.0006 0.00059103965759277
SELECT category_id FROM products_categories WHERE product_id = '3693'
237 0.0007 0.0006558895111084
SELECT * FROM categories WHERE id = '26'
238 0.0058 0.0057859420776367
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
239 0.0005 0.00051307678222656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
240 0.0004 0.00038290023803711
SELECT id FROM categories WHERE parent_id = '26'
241 0.0053 0.0053400993347168
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 
242 0.0006 0.0006248950958252
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 
243 0.0006 0.00057792663574219
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
244 0.0005 0.00049901008605957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
245 0.0012 0.0011570453643799
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3693' AND a.name = n.originalname
246 0.0005 0.00053286552429199
SELECT * FROM productoffers WHERE product_id = '3693' AND merchantid = 'A1X6FK5RDHNB96'
247 0.0005 0.00047087669372559
SELECT * FROM productoffers
                WHERE product_id = '3693' AND price > 0
                ORDER BY price ASC LIMIT 1
248 0.0004 0.00042295455932617
SELECT * FROM productoffers
                WHERE product_id = 3693
                ORDER BY price ASC LIMIT 1
249 0.0004 0.00040388107299805
SELECT value FROM productattributes
                WHERE product_id = '3693'
                AND name = 'ListPriceAmount'
250 0.0007 0.00072884559631348
SELECT * FROM products WHERE id = '3693'
251 0.0005 0.00046896934509277
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 = '3693'
                GROUP BY o.product_id
252 0.0007 0.00070285797119141
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     = '3693'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
253 0.0005 0.00048589706420898
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3693
254 0.0006 0.00057506561279297
SELECT value FROM productattributes WHERE product_id = '3693' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0011 0.0010840892791748
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3693' AND a.name = n.originalname
256 0.0004 0.00041604042053223
SELECT * FROM productoffers WHERE product_id = '3693' AND merchantid = 'A1X6FK5RDHNB96'
257 0.0004 0.00041699409484863
SELECT * FROM productoffers
                WHERE product_id = '3693' AND price > 0
                ORDER BY price ASC LIMIT 1
258 0.0004 0.00042891502380371
SELECT * FROM productoffers
                WHERE product_id = 3693
                ORDER BY price ASC LIMIT 1
259 0.0005 0.00045084953308105
SELECT value FROM productattributes
                WHERE product_id = '3693'
                AND name = 'ListPriceAmount'
260 0.0007 0.00065207481384277
SELECT DISTINCT (name) FROM productoptions
261 0.0006 0.00061798095703125
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 3693))
262 0.0005 0.00050806999206543
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 3693
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
263 0.0017 0.0016610622406006
SELECT * FROM translationsfilter
264 0.0006 0.00058293342590332
SELECT category_id FROM products_categories WHERE product_id = '3693' AND prod_type = 'amz'
265 0.0005 0.00051188468933105
SELECT parent_id FROM categories WHERE id = '26'
266 0.0005 0.00047111511230469
SELECT * FROM categories WHERE id = '26'
267 0.0053 0.0053179264068604
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
268 0.0005 0.00045299530029297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
269 0.0004 0.00039005279541016
SELECT id FROM categories WHERE parent_id = '26'
270 0.0053 0.0053451061248779
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 
271 0.0006 0.00058984756469727
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 
272 0.0006 0.00062108039855957
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
273 0.0005 0.00051617622375488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
274 0.0017 0.0017440319061279
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
275 0.0012 0.0012199878692627
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
276 0.0004 0.00042605400085449
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
277 0.0129 0.012853860855103
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.0016 0.0016388893127441
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.00062322616577148
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.0005958080291748
SELECT * FROM products WHERE id = 1626
281 0.0006 0.00063014030456543
SELECT * FROM products WHERE id = 4041
282 0.0006 0.00061297416687012
SELECT * FROM products WHERE id = 4312
283 0.0006 0.00059890747070312
SELECT * FROM products WHERE id = 777
284 0.0008 0.00082898139953613
SELECT * FROM products WHERE id = 3881
285 0.0008 0.00077700614929199
SELECT * FROM products WHERE id = 4213
286 0.0006 0.00061202049255371
SELECT * FROM products WHERE id = '1626'
287 0.0005 0.00051116943359375
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
288 0.0007 0.0006561279296875
SELECT * FROM product_image_select WHERE product_id = '1626'
289 0.0004 0.00044107437133789
SELECT * FROM productcustomimages WHERE product_id = '1626'
290 0.0009 0.0009458065032959
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.00054407119750977
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
292 0.0005 0.00046515464782715
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
293 0.0004 0.00043988227844238
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
294 0.0007 0.000701904296875
SELECT * FROM products WHERE id = '4041'
295 0.0005 0.00052189826965332
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
296 0.0006 0.00061607360839844
SELECT * FROM product_image_select WHERE product_id = '4041'
297 0.0004 0.00041913986206055
SELECT * FROM productcustomimages WHERE product_id = '4041'
298 0.0012 0.0011851787567139
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
299 0.0005 0.00053310394287109
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
300 0.0006 0.00058984756469727
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
301 0.0005 0.00048398971557617
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302 0.0007 0.00067496299743652
SELECT * FROM products WHERE id = '4312'
303 0.0005 0.00047898292541504
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
304 0.0007 0.00070714950561523
SELECT * FROM product_image_select WHERE product_id = '4312'
305 0.0006 0.00058984756469727
SELECT * FROM productcustomimages WHERE product_id = '4312'
306 0.0012 0.0012471675872803
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
307 0.0006 0.00062704086303711
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
308 0.0007 0.00066018104553223
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
309 0.0005 0.00054097175598145
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
310 0.0011 0.0010900497436523
SELECT * FROM products WHERE id = '777'
311 0.0006 0.00055408477783203
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
312 0.0007 0.00071907043457031
SELECT * FROM product_image_select WHERE product_id = '777'
313 0.0005 0.00048995018005371
SELECT * FROM productcustomimages WHERE product_id = '777'
314 0.0011 0.0011038780212402
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.00054192543029785
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
316 0.0005 0.00047111511230469
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
317 0.0005 0.00052285194396973
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
318 0.0006 0.00064206123352051
SELECT * FROM products WHERE id = '3881'
319 0.0008 0.00083518028259277
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
320 0.0007 0.00071096420288086
SELECT * FROM product_image_select WHERE product_id = '3881'
321 0.0004 0.00043797492980957
SELECT * FROM productcustomimages WHERE product_id = '3881'
322 0.0012 0.001237154006958
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
323 0.0007 0.0006871223449707
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
324 0.0008 0.00081181526184082
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
325 0.0005 0.00053596496582031
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
326 0.0007 0.00069785118103027
SELECT * FROM products WHERE id = '4213'
327 0.0008 0.00078201293945312
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
328 0.0006 0.00063204765319824
SELECT * FROM product_image_select WHERE product_id = '4213'
329 0.0004 0.00044703483581543
SELECT * FROM productcustomimages WHERE product_id = '4213'
330 0.0012 0.0011849403381348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
331 0.0006 0.00056695938110352
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
332 0.0005 0.00052499771118164
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
333 0.0005 0.00049591064453125
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
334 0.0023 0.002263069152832
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
335 0.0008 0.00083398818969727
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
336 0.0039 0.0038788318634033
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
337 0.0025 0.0024960041046143
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
338 0.0008 0.00078415870666504
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
339 0.0012 0.0011849403381348
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'