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.07190990448 338 1.7531 0


No Amazon API Requests Made.


App Debug - Total Time 2.07190990448 seconds

Number Time From Start Name Description
1 0.2960000038147 Initialise Initialise FSB Function
2 0.30215001106262 App Controller Start Start of the App controller (called before the controller of every page)
3 0.34476804733276 Start of getCategoryListByGroup Function Before first category groups query
4 0.3461549282074 After initial query Before first category groups query
5 0.34615612030029 Get Category List for Group Before the call to getCategoryList function
6 0.34615802764893 Start of GetCategoryList function Start of the function
7 0.34615993499756 Before getting categories Query to get specific category list
8 0.34820699691772 After getting categories Query to get specific category list
9 0.34820795059204 Before getting category custom Before call to function getCategoryCustom
10 0.37957501411438 After getting category custom After call to function getCategoryCustom
11 0.37957692146301 Before getting category custom Before call to function getCategoryCustom
12 0.39115810394287 After getting category custom After call to function getCategoryCustom
13 0.3911600112915 Before getting category custom Before call to function getCategoryCustom
14 0.39692211151123 After getting category custom After call to function getCategoryCustom
15 0.39692306518555 Before getting category custom Before call to function getCategoryCustom
16 0.40082597732544 After getting category custom After call to function getCategoryCustom
17 0.40082693099976 Before getting category custom Before call to function getCategoryCustom
18 0.40480494499207 After getting category custom After call to function getCategoryCustom
19 0.40480589866638 Before getting category custom Before call to function getCategoryCustom
20 0.41020894050598 After getting category custom After call to function getCategoryCustom
21 0.41021108627319 End of GetCategoryList function End of the function
22 0.41021490097046 Get Category List for Group Before the call to getCategoryList function
23 0.41021609306335 Start of GetCategoryList function Start of the function
24 0.41021800041199 Before getting categories Query to get specific category list
25 0.41089200973511 End of getCategoryListByGroup Function Before return()
26 1.7906179428101 App Controller End End of the App controller (called before the controller of every page)
27 1.7911429405212 Product Start Start of the product info controller
28 1.8121619224548 Cache file not found Starting get product details
29 1.8779900074005 Related products Start getting related products if enabled
30 1.8779909610748 Related Products Start Before the related products are found
31 1.8779919147491 Related Products Keywords Before the related product keywords are found
32 1.8779950141907 Create Keyword List Function Start of function
33 1.8780860900879 Create Keyword List Function After looping provided content - 59 keywords found
34 1.8790149688721 Create Keyword List Function After looping initial keyword list - 48 keywords remaining
35 1.8790230751038 Create Keyword List Function After reducing keyword list
36 1.8791599273682 Create Keyword List Function After selecting by scoring keywords
37 1.8791630268097 Create Keyword List Function After final loop of keywords
38 1.879163980484 Related Products Keywords After the related product keywords are found
39 1.9346699714661 Related Products End After the related products are found
40 1.9885749816895 Product End End of the product info controller (Product Info)
41 1.9894549846649 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.9904038906097 Before Get Options Before the call to getOptions in the tpl class
43 2.0479469299316 After Get Options After the call to getOptions in the tpl class
44 2.0480539798737 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.0480740070343 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.0508739948273 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.0508770942688 Product Info: Before Template Display Before the template is displayed
48 2.0718910694122 Product Info: After Template Display After the template is displayed
49 2.0718998908997 Finalizing debug Before the debug is output to the page.
50 2.07190990448 End of App This is the end of the app logging, final timestamp


Query Debug - 338 Database Queries. Total time 1.7531 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0019 0.0019378662109375
SELECT parameter, value FROM parameters
2 0.0082 0.0081698894500732
SELECT * FROM `bad_bots`
3 0.0004 0.00044608116149902
SET time_zone = 'Europe/London'
4 0.0033 0.0032680034637451
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0055 0.0054569244384766
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.133.142.101\";}'
6 0.0039 0.0038940906524658
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746022265'
7 0.0036 0.0036051273345947
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00090813636779785
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0017 0.0016868114471436
SELECT id FROM pages WHERE pagename = 'a0127-bote-the-bote-scellee-bote-cafe-materiel-de-bambou-mini' LIMIT 1
10 0.0031 0.0030529499053955
SELECT id FROM products WHERE pagename = 'a0127-bote-the-bote-scellee-bote-cafe-materiel-de-bambou-mini' AND hidden = 0 LIMIT 1
11 0.0045 0.0045099258422852
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0375 0.037468910217285
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0003 0.00034499168395996
SELECT * FROM pages WHERE pagename = 'a0127-bote-the-bote-scellee-bote-cafe-materiel-de-bambou-mini'
14 0.0014 0.0013799667358398
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0020 0.0020351409912109
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0184 0.018404960632324
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0007 0.00073099136352539
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0006 0.00063014030456543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0006 0.00055098533630371
SELECT id FROM categories WHERE parent_id = '26'
20 0.0089 0.0088989734649658
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0006 0.00060701370239258
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.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
23 0.0005 0.00048708915710449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00040507316589355
SELECT * FROM categorygroups WHERE id = '1'
25 0.0049 0.0048549175262451
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0004 0.00042605400085449
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0003 0.00031495094299316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.0003361701965332
SELECT id FROM categories WHERE parent_id = '27'
29 0.0040 0.0040252208709717
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0004 0.00041913986206055
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0004 0.00042295455932617
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0004 0.00040793418884277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00033807754516602
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.0014371871948242
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0004 0.00041317939758301
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.00036311149597168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00038504600524902
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0014901161193848
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0004 0.00042104721069336
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0004 0.00044107437133789
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0004 0.00042390823364258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00036001205444336
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.0005340576171875
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0004 0.00040006637573242
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0003 0.00032210350036621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00033402442932129
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00060105323791504
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0004 0.00043606758117676
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0005 0.00050902366638184
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0004 0.00042390823364258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00032496452331543
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00051283836364746
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0005 0.00054287910461426
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0003 0.00033712387084961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00032806396484375
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00055789947509766
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0004 0.00039482116699219
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0004 0.00040984153747559
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0004 0.00041389465332031
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00046205520629883
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00061607360839844
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0004 0.00043082237243652
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00037884712219238
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00042486190795898
SELECT id FROM categories WHERE parent_id = '31'
65 0.0016 0.0016088485717773
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0005 0.00047492980957031
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0005 0.00047683715820312
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0005 0.00048208236694336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.0004880428314209
SELECT * FROM categorygroups WHERE id = '1'
70 0.0007 0.0006709098815918
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0018 0.001755952835083
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0005 0.00049591064453125
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00047707557678223
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0004 0.00037598609924316
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011320114135742
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00084996223449707
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 1.3699 1.3699328899384
SELECT * FROM ipgeocountries WHERE INET_ATON('3.133.142.101') >= INET_ATON(ip_start) AND INET_ATON('3.133.142.101') <= INET_ATON(ip_end)
78 0.0027 0.0027282238006592
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0012750625610352
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0005 0.00054502487182617
SELECT * FROM products WHERE pagename = 'a0127-bote-the-bote-scellee-bote-cafe-materiel-de-bambou-mini'
81 0.0004 0.00036811828613281
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3693
82 0.0008 0.00078296661376953
SELECT * FROM manufacturers WHERE id = '543'
83 0.0006 0.00062894821166992
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '543'
84 0.0023 0.0023250579833984
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '543' LIMIT 1
85 0.0023 0.0023109912872314
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
86 0.0005 0.00049495697021484
SELECT * FROM productimages WHERE product_id = '3693' ORDER BY sortorder ASC
87 0.0005 0.00050592422485352
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '543'
88 0.0005 0.0005028247833252
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 
89 0.0005 0.00046014785766602
SELECT * FROM manufacturerimages WHERE manufacturer_id = '543'
90 0.0005 0.00052380561828613
SELECT category_id FROM products_categories WHERE product_id = '3693'
91 0.0005 0.0005180835723877
SELECT * FROM categories WHERE id = '26'
92 0.0096 0.0096240043640137
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
93 0.0005 0.00047492980957031
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
94 0.0003 0.00028896331787109
SELECT id FROM categories WHERE parent_id = '26'
95 0.0064 0.0064189434051514
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 
96 0.0006 0.00055885314941406
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 
97 0.0005 0.00053215026855469
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
98 0.0005 0.00045895576477051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
99 0.0005 0.00048708915710449
SELECT * FROM productimages WHERE product_id = '3693' ORDER BY sortorder ASC
100 0.0005 0.00053310394287109
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
101 0.0016 0.0016450881958008
SELECT * FROM product_image_select WHERE product_id = '3693'
102 0.0012 0.001194953918457
SELECT * FROM productcustomimages WHERE product_id = '3693'
103 0.0011 0.0010960102081299
SELECT * FROM productfeeds WHERE product_id = '3693' ORDER BY item_date DESC
104 0.0022 0.0021519660949707
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
105 0.0021 0.0021440982818604
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
106 0.0003 0.00029897689819336
SELECT * FROM tags WHERE id = '216'
107 0.0030 0.0029909610748291
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
108 0.0027 0.0026900768280029
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 
109 0.0025 0.0025458335876465
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
110 0.0005 0.00049710273742676
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
111 0.0003 0.00029802322387695
SELECT * FROM tags WHERE id = '62'
112 0.0014 0.0014309883117676
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
113 0.0013 0.001349925994873
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 
114 0.0013 0.0013070106506348
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
115 0.0004 0.00044512748718262
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
116 0.0003 0.00030398368835449
SELECT * FROM tags WHERE id = '91'
117 0.0008 0.00079011917114258
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
118 0.0007 0.00074100494384766
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 
119 0.0008 0.00076508522033691
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
120 0.0003 0.00030899047851562
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
121 0.0016 0.0016169548034668
SELECT * FROM productamazoncontent WHERE product_id = '3693'
122 0.0015 0.0015380382537842
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
123 0.0023 0.0022859573364258
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
124 0.0005 0.00051712989807129
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
125 0.0011 0.0011169910430908
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3693' AND a.name = n.originalname
126 0.0004 0.00038790702819824
SELECT * FROM productoffers WHERE product_id = '3693' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0003 0.00033903121948242
SELECT * FROM productoffers
                WHERE product_id = '3693' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0004 0.00036287307739258
SELECT * FROM productoffers
                WHERE product_id = 3693
                ORDER BY price ASC LIMIT 1
129 0.0004 0.00036191940307617
SELECT value FROM productattributes
                WHERE product_id = '3693'
                AND name = 'ListPriceAmount'
130 0.0004 0.00043606758117676
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
131 0.0007 0.00065398216247559
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
132 0.0004 0.00039577484130859
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
133 0.0006 0.00061798095703125
SELECT value FROM productattributes WHERE product_id = '3693' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0007 0.00068998336791992
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
135 0.0006 0.00058412551879883
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
136 0.0040 0.0039560794830322
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
137 0.0005 0.0005190372467041
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
138 0.0004 0.00041699409484863
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
139 0.0090 0.0089609622955322
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
140 0.0004 0.00040316581726074
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
141 0.0003 0.0003211498260498
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
142 0.0004 0.00041699409484863
SELECT * FROM productimages WHERE product_id = '2336' ORDER BY sortorder ASC
143 0.0004 0.00043296813964844
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
144 0.0005 0.00052499771118164
SELECT * FROM product_image_select WHERE product_id = '2336'
145 0.0003 0.00034403800964355
SELECT * FROM productcustomimages WHERE product_id = '2336'
146 0.0005 0.00045895576477051
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
147 0.0006 0.00057291984558105
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
148 0.0004 0.00037598609924316
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
149 0.0008 0.00080704689025879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2336' AND a.name = n.originalname
150 0.0003 0.00030803680419922
SELECT * FROM productoffers WHERE product_id = '2336' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0003 0.00034403800964355
SELECT * FROM productoffers
                WHERE product_id = '2336' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0003 0.00028300285339355
SELECT * FROM productoffers
                WHERE product_id = 2336
                ORDER BY price ASC LIMIT 1
153 0.0003 0.00029802322387695
SELECT value FROM productattributes
                WHERE product_id = '2336'
                AND name = 'ListPriceAmount'
154 0.0004 0.00035500526428223
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
155 0.0006 0.00056695938110352
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
156 0.0004 0.00035500526428223
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
157 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '2336' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0005 0.00053787231445312
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
159 0.0004 0.00044894218444824
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
160 0.0005 0.00048613548278809
SELECT * FROM product_image_select WHERE product_id = '4213'
161 0.0003 0.00034403800964355
SELECT * FROM productcustomimages WHERE product_id = '4213'
162 0.0010 0.0010499954223633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
163 0.0004 0.00037479400634766
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0004 0.00036287307739258
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0004 0.00042605400085449
SELECT * FROM productimages WHERE product_id = '3903' ORDER BY sortorder ASC
167 0.0005 0.0005180835723877
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
168 0.0005 0.00050616264343262
SELECT * FROM product_image_select WHERE product_id = '3903'
169 0.0003 0.00033688545227051
SELECT * FROM productcustomimages WHERE product_id = '3903'
170 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 = '3903'
                GROUP BY o.product_id
171 0.0007 0.00065994262695312
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
172 0.0004 0.00037407875061035
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
173 0.0007 0.00067305564880371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3903' AND a.name = n.originalname
174 0.0003 0.00028705596923828
SELECT * FROM productoffers WHERE product_id = '3903' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0003 0.00028705596923828
SELECT * FROM productoffers
                WHERE product_id = '3903' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0003 0.00026679039001465
SELECT * FROM productoffers
                WHERE product_id = 3903
                ORDER BY price ASC LIMIT 1
177 0.0003 0.00028896331787109
SELECT value FROM productattributes
                WHERE product_id = '3903'
                AND name = 'ListPriceAmount'
178 0.0004 0.0003969669342041
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
179 0.0007 0.00065898895263672
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
180 0.0004 0.00038504600524902
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
181 0.0004 0.00040817260742188
SELECT value FROM productattributes WHERE product_id = '3903' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0006 0.0005650520324707
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
183 0.0005 0.00049591064453125
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
184 0.0004 0.00044608116149902
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
185 0.0005 0.00049185752868652
SELECT * FROM product_image_select WHERE product_id = '3881'
186 0.0004 0.0004420280456543
SELECT * FROM productcustomimages WHERE product_id = '3881'
187 0.0010 0.0010249614715576
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
188 0.0004 0.00039410591125488
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0003 0.00031495094299316
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00039911270141602
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191 0.0004 0.00037908554077148
SELECT * FROM productimages WHERE product_id = '2498' ORDER BY sortorder ASC
192 0.0006 0.00063109397888184
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
193 0.0005 0.00050687789916992
SELECT * FROM product_image_select WHERE product_id = '2498'
194 0.0003 0.00031495094299316
SELECT * FROM productcustomimages WHERE product_id = '2498'
195 0.0004 0.00044918060302734
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
196 0.0005 0.00054001808166504
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
197 0.0004 0.00036716461181641
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
198 0.0012 0.0012249946594238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2498' AND a.name = n.originalname
199 0.0004 0.00038003921508789
SELECT * FROM productoffers WHERE product_id = '2498' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0003 0.00033807754516602
SELECT * FROM productoffers
                WHERE product_id = '2498' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0003 0.00029897689819336
SELECT * FROM productoffers
                WHERE product_id = 2498
                ORDER BY price ASC LIMIT 1
202 0.0003 0.00033783912658691
SELECT value FROM productattributes
                WHERE product_id = '2498'
                AND name = 'ListPriceAmount'
203 0.0004 0.00043797492980957
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
204 0.0007 0.00067615509033203
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
205 0.0004 0.00037598609924316
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
206 0.0006 0.00057601928710938
SELECT value FROM productattributes WHERE product_id = '2498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0008 0.00080108642578125
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
208 0.0006 0.00062108039855957
SELECT * FROM productimages WHERE product_id = '4895' ORDER BY sortorder ASC
209 0.0006 0.00057888031005859
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
210 0.0006 0.0006108283996582
SELECT * FROM product_image_select WHERE product_id = '4895'
211 0.0004 0.00043582916259766
SELECT * FROM productcustomimages WHERE product_id = '4895'
212 0.0005 0.00048494338989258
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
213 0.0006 0.00062203407287598
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
214 0.0004 0.00038719177246094
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
215 0.0008 0.00075817108154297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4895' AND a.name = n.originalname
216 0.0004 0.00037813186645508
SELECT * FROM productoffers WHERE product_id = '4895' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0004 0.00041103363037109
SELECT * FROM productoffers
                WHERE product_id = '4895' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0003 0.00030899047851562
SELECT * FROM productoffers
                WHERE product_id = 4895
                ORDER BY price ASC LIMIT 1
219 0.0004 0.00041294097900391
SELECT value FROM productattributes
                WHERE product_id = '4895'
                AND name = 'ListPriceAmount'
220 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 = '4895'
                GROUP BY o.product_id
221 0.0007 0.0007328987121582
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
222 0.0005 0.00049281120300293
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
223 0.0006 0.00063300132751465
SELECT value FROM productattributes WHERE product_id = '4895' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0006 0.0006098747253418
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
225 0.0004 0.00039410591125488
SELECT id,asin FROM products WHERE parent_id = 3693
226 0.0005 0.00045490264892578
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3694
227 0.0004 0.00040388107299805
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3694
228 0.0003 0.00030803680419922
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3695
229 0.0004 0.00037288665771484
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3695
230 0.0003 0.00031900405883789
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3696
231 0.0004 0.00035309791564941
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3696
232 0.0003 0.0003058910369873
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3697
233 0.0003 0.00034308433532715
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3697
234 0.0004 0.00040411949157715
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3693' ORDER BY timestamp DESC
235 0.0004 0.00041294097900391
SELECT category_id FROM products_categories WHERE product_id = '3693'
236 0.0004 0.00042414665222168
SELECT * FROM categories WHERE id = '26'
237 0.0059 0.005885124206543
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
238 0.0004 0.0003809928894043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
239 0.0003 0.00027990341186523
SELECT id FROM categories WHERE parent_id = '26'
240 0.0072 0.0071749687194824
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 
241 0.0005 0.00050711631774902
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 
242 0.0006 0.00062417984008789
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
243 0.0005 0.00050497055053711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
244 0.0015 0.0015101432800293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3693' AND a.name = n.originalname
245 0.0005 0.00048995018005371
SELECT * FROM productoffers WHERE product_id = '3693' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0004 0.00036406517028809
SELECT * FROM productoffers
                WHERE product_id = '3693' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0004 0.00041007995605469
SELECT * FROM productoffers
                WHERE product_id = 3693
                ORDER BY price ASC LIMIT 1
248 0.0005 0.00054216384887695
SELECT value FROM productattributes
                WHERE product_id = '3693'
                AND name = 'ListPriceAmount'
249 0.0007 0.00068402290344238
SELECT * FROM products WHERE id = '3693'
250 0.0006 0.00063014030456543
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
251 0.0009 0.00087308883666992
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
252 0.0005 0.00050806999206543
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
253 0.0006 0.0006401538848877
SELECT value FROM productattributes WHERE product_id = '3693' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0015 0.0014879703521729
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3693' AND a.name = n.originalname
255 0.0004 0.00039815902709961
SELECT * FROM productoffers WHERE product_id = '3693' AND merchantid = 'A1X6FK5RDHNB96'
256 0.0004 0.00041413307189941
SELECT * FROM productoffers
                WHERE product_id = '3693' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0004 0.00037288665771484
SELECT * FROM productoffers
                WHERE product_id = 3693
                ORDER BY price ASC LIMIT 1
258 0.0004 0.00039410591125488
SELECT value FROM productattributes
                WHERE product_id = '3693'
                AND name = 'ListPriceAmount'
259 0.0007 0.0007328987121582
SELECT DISTINCT (name) FROM productoptions
260 0.0006 0.0006258487701416
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 3693))
261 0.0005 0.00052094459533691
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
262 0.0020 0.0019669532775879
SELECT * FROM translationsfilter
263 0.0006 0.00055193901062012
SELECT category_id FROM products_categories WHERE product_id = '3693' AND prod_type = 'amz'
264 0.0005 0.00045490264892578
SELECT parent_id FROM categories WHERE id = '26'
265 0.0004 0.00039911270141602
SELECT * FROM categories WHERE id = '26'
266 0.0080 0.0079970359802246
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
267 0.0005 0.00048995018005371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
268 0.0004 0.00037598609924316
SELECT id FROM categories WHERE parent_id = '26'
269 0.0079 0.0078680515289307
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 
270 0.0007 0.0006868839263916
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 
271 0.0007 0.00071287155151367
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
272 0.0005 0.00053596496582031
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
273 0.0005 0.00051999092102051
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
274 0.0005 0.00054502487182617
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
275 0.0004 0.00035500526428223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
276 0.0187 0.018704175949097
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
277 0.0008 0.00078701972961426
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
278 0.0008 0.00079584121704102
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
279 0.0006 0.0005791187286377
SELECT * FROM products WHERE id = 1626
280 0.0005 0.00045394897460938
SELECT * FROM products WHERE id = 4041
281 0.0004 0.00039291381835938
SELECT * FROM products WHERE id = 4312
282 0.0004 0.00043702125549316
SELECT * FROM products WHERE id = 777
283 0.0004 0.00039196014404297
SELECT * FROM products WHERE id = 3881
284 0.0004 0.00040411949157715
SELECT * FROM products WHERE id = 4213
285 0.0004 0.00041913986206055
SELECT * FROM products WHERE id = '1626'
286 0.0005 0.00052213668823242
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
287 0.0007 0.00067591667175293
SELECT * FROM product_image_select WHERE product_id = '1626'
288 0.0004 0.00044584274291992
SELECT * FROM productcustomimages WHERE product_id = '1626'
289 0.0010 0.00098800659179688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
290 0.0005 0.00050187110900879
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
291 0.0004 0.00043606758117676
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
292 0.0005 0.00050187110900879
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
293 0.0005 0.00050687789916992
SELECT * FROM products WHERE id = '4041'
294 0.0005 0.00049185752868652
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
295 0.0007 0.0006561279296875
SELECT * FROM product_image_select WHERE product_id = '4041'
296 0.0004 0.0004270076751709
SELECT * FROM productcustomimages WHERE product_id = '4041'
297 0.0015 0.0014510154724121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
298 0.0005 0.00049901008605957
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
299 0.0004 0.00040602684020996
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
300 0.0005 0.0004880428314209
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
301 0.0005 0.0005490779876709
SELECT * FROM products WHERE id = '4312'
302 0.0006 0.00056815147399902
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
303 0.0006 0.00063991546630859
SELECT * FROM product_image_select WHERE product_id = '4312'
304 0.0004 0.00043702125549316
SELECT * FROM productcustomimages WHERE product_id = '4312'
305 0.0014 0.0013740062713623
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
306 0.0005 0.00052905082702637
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
307 0.0004 0.00043201446533203
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
308 0.0005 0.00050497055053711
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309 0.0005 0.00053095817565918
SELECT * FROM products WHERE id = '777'
310 0.0005 0.00052189826965332
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
311 0.0007 0.00065708160400391
SELECT * FROM product_image_select WHERE product_id = '777'
312 0.0004 0.0004279613494873
SELECT * FROM productcustomimages WHERE product_id = '777'
313 0.0015 0.0015039443969727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
314 0.0005 0.00051784515380859
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
315 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
316 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
317 0.0006 0.0005648136138916
SELECT * FROM products WHERE id = '3881'
318 0.0006 0.00057697296142578
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
319 0.0007 0.00069212913513184
SELECT * FROM product_image_select WHERE product_id = '3881'
320 0.0005 0.00045299530029297
SELECT * FROM productcustomimages WHERE product_id = '3881'
321 0.0017 0.0016541481018066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
322 0.0005 0.00051617622375488
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
323 0.0004 0.00042510032653809
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
324 0.0005 0.00050878524780273
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
325 0.0006 0.00055789947509766
SELECT * FROM products WHERE id = '4213'
326 0.0006 0.0005950927734375
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
327 0.0007 0.00066494941711426
SELECT * FROM product_image_select WHERE product_id = '4213'
328 0.0004 0.00041484832763672
SELECT * FROM productcustomimages WHERE product_id = '4213'
329 0.0016 0.0016210079193115
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
330 0.0004 0.00044798851013184
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
331 0.0004 0.00035881996154785
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
332 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
333 0.0008 0.00077199935913086
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
334 0.0006 0.00057601928710938
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
335 0.0013 0.0012779235839844
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
336 0.0006 0.00060009956359863
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
337 0.0004 0.00044703483581543
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
338 0.0012 0.0012409687042236
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'