0

Pot De Thé, Bidons étanches, Boîtes De Thé, Céramique Boîtes Thé, Voyage Boîtes De Stockage, Pu'er Pots, Sets De Thé Kung Fu,Conteneur De Thé En Porcelaine

Price: €15,99
Product prices and availability are accurate as of 2022-04-13 17:03:57 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
Availability: In Stock
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

Couvercle Hermétique Douillet Et Occultants Porcelaine Maintient Thé Frais Et secs. Construction Robuste En Porcelaine.le Porcelainlid Se Prête à La Fraîcheur Pour éviter Que Vos Goodies Va rassis. Céramique De Haute Qualité, Coffre-fort Et Les Durablemoistureproof Et Les ravageurs. Simple Et Belle,Aider à Décorer La salle. Pour Bonbons Thé Biscuits Noix De Céréales Et De Stockage De Café,Faire La Chambre Propre Et Bien rangé.

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
0.99650311470032 340 0.2360 0


No Amazon API Requests Made.


App Debug - Total Time 0.99650311470032 seconds

Number Time From Start Name Description
1 0.67435002326965 Initialise Initialise FSB Function
2 0.67693710327148 App Controller Start Start of the App controller (called before the controller of every page)
3 0.68043422698975 Start of getCategoryListByGroup Function Before first category groups query
4 0.68078899383545 After initial query Before first category groups query
5 0.68079113960266 Get Category List for Group Before the call to getCategoryList function
6 0.68079400062561 Start of GetCategoryList function Start of the function
7 0.68079710006714 Before getting categories Query to get specific category list
8 0.68132209777832 After getting categories Query to get specific category list
9 0.68132400512695 Before getting category custom Before call to function getCategoryCustom
10 0.70147204399109 After getting category custom After call to function getCategoryCustom
11 0.70147705078125 Before getting category custom Before call to function getCategoryCustom
12 0.70426511764526 After getting category custom After call to function getCategoryCustom
13 0.7042670249939 Before getting category custom Before call to function getCategoryCustom
14 0.70977306365967 After getting category custom After call to function getCategoryCustom
15 0.7097761631012 Before getting category custom Before call to function getCategoryCustom
16 0.71234107017517 After getting category custom After call to function getCategoryCustom
17 0.71234321594238 Before getting category custom Before call to function getCategoryCustom
18 0.71499609947205 After getting category custom After call to function getCategoryCustom
19 0.71499800682068 Before getting category custom Before call to function getCategoryCustom
20 0.71765518188477 After getting category custom After call to function getCategoryCustom
21 0.7176570892334 End of GetCategoryList function End of the function
22 0.71766400337219 Get Category List for Group Before the call to getCategoryList function
23 0.7176661491394 Start of GetCategoryList function Start of the function
24 0.71766901016235 Before getting categories Query to get specific category list
25 0.71796607971191 End of getCategoryListByGroup Function Before return()
26 0.72256517410278 App Controller End End of the App controller (called before the controller of every page)
27 0.72316002845764 Product Start Start of the product info controller
28 0.75727820396423 Cache file not found Starting get product details
29 0.8118040561676 Related products Start getting related products if enabled
30 0.81180715560913 Related Products Start Before the related products are found
31 0.81180906295776 Related Products Keywords Before the related product keywords are found
32 0.81181502342224 Create Keyword List Function Start of function
33 0.81201004981995 Create Keyword List Function After looping provided content - 61 keywords found
34 0.81501007080078 Create Keyword List Function After looping initial keyword list - 58 keywords remaining
35 0.81502318382263 Create Keyword List Function After reducing keyword list
36 0.81541013717651 Create Keyword List Function After selecting by scoring keywords
37 0.81541514396667 Create Keyword List Function After final loop of keywords
38 0.81541705131531 Related Products Keywords After the related product keywords are found
39 0.88176703453064 Related Products End After the related products are found
40 0.90712308883667 Product End End of the product info controller (Product Info)
41 0.90808820724487 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 0.90868902206421 Before Get Options Before the call to getOptions in the tpl class
43 0.95286512374878 After Get Options After the call to getOptions in the tpl class
44 0.95307803153992 App_after Controller End End of the App_after controller (called after the controller of every page)
45 0.95311808586121 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 0.96478414535522 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 0.96478915214539 Product Info: Before Template Display Before the template is displayed
48 0.99647307395935 Product Info: After Template Display After the template is displayed
49 0.99648714065552 Finalizing debug Before the debug is output to the page.
50 0.996502161026 End of App This is the end of the app logging, final timestamp


Query Debug - 340 Database Queries. Total time 0.2360 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00044894218444824
SELECT parameter, value FROM parameters
2 0.0010 0.0010080337524414
SELECT * FROM `bad_bots`
3 0.0004 0.00040292739868164
SET time_zone = 'Europe/London'
4 0.0003 0.00033211708068848
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0009 0.00092005729675293
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"44.213.63.130\";}'
6 0.0011 0.0010690689086914
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1674912068'
7 0.0005 0.0005180835723877
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00030684471130371
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0008 0.00078511238098145
SELECT id FROM pages WHERE pagename = 'pot-de-the-bidons-etanches-botes-de-the-ceramique-botes-the-voyage' LIMIT 1
10 0.0009 0.00088691711425781
SELECT id FROM products WHERE pagename = 'pot-de-the-bidons-etanches-botes-de-the-ceramique-botes-the-voyage' AND hidden = 0 LIMIT 1
11 0.0011 0.001068115234375
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0013 0.0012550354003906
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00068306922912598
SELECT * FROM pages WHERE pagename = 'pot-de-the-bidons-etanches-botes-de-the-ceramique-botes-the-voyage'
14 0.0003 0.00034308433532715
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00050187110900879
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0089 0.0089409351348877
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.0003 0.00030398368835449
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.0003 0.00034594535827637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00023293495178223
SELECT id FROM categories WHERE parent_id = '26'
20 0.0092 0.0091879367828369
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.0003 0.0002751350402832
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.0002 0.00023293495178223
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.0002 0.00022578239440918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00024318695068359
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00023698806762695
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.0002 0.0002439022064209
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.00026798248291016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.000244140625
SELECT id FROM categories WHERE parent_id = '27'
29 0.0003 0.00033187866210938
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.0002 0.00024914741516113
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.0002 0.00022101402282715
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0002 0.00022602081298828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0007 0.00067496299743652
SELECT * FROM categorygroups WHERE id = '1'
34 0.0020 0.0020108222961426
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.0003 0.00031495094299316
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.0002 0.00022292137145996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '28'
38 0.0018 0.0017518997192383
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.0002 0.0002448558807373
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.0002 0.00022315979003906
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.0002 0.0002129077911377
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.0002129077911377
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00047397613525391
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.0002 0.00023102760314941
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.0002 0.00021195411682129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00020813941955566
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.0004889965057373
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.0002 0.00023698806762695
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.0002 0.00021719932556152
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.0002 0.00020503997802734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00021195411682129
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00049400329589844
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.0002 0.00024509429931641
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.0002 0.00021600723266602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.0002138614654541
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00052690505981445
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.0002 0.00023198127746582
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.0002 0.00021815299987793
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.0002 0.00020503997802734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00022292137145996
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00050592422485352
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.0003 0.0002598762512207
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.0002 0.00021505355834961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00051403045654297
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.0002 0.00024199485778809
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.0002 0.00021505355834961
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.0002 0.00020313262939453
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00020790100097656
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00028491020202637
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0002 0.00022101402282715
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0003 0.00026988983154297
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0003 0.00025701522827148
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.0002 0.00023698806762695
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0002 0.00023889541625977
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00079083442687988
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0003 0.00029778480529785
SELECT * FROM ipgeocountries WHERE INET_ATON('44.213.63.130') >= INET_ATON(ip_start) AND INET_ATON('44.213.63.130') <= INET_ATON(ip_end)
78 0.0003 0.00025105476379395
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0002 0.00023293495178223
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00060701370239258
SELECT * FROM products WHERE pagename = 'pot-de-the-bidons-etanches-botes-de-the-ceramique-botes-the-voyage'
81 0.0005 0.0005190372467041
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3903
82 0.0008 0.00082612037658691
SELECT * FROM manufacturers WHERE id = '547'
83 0.0007 0.00072312355041504
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '547'
84 0.0006 0.00058388710021973
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '547' LIMIT 1
85 0.0009 0.00085997581481934
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '547' ORDER BY RAND() LIMIT 1
86 0.0007 0.00066518783569336
SELECT * FROM productimages WHERE product_id = '3919' ORDER BY sortorder ASC
87 0.0005 0.00054097175598145
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '547'
88 0.0007 0.00070810317993164
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '547'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0004 0.00039815902709961
SELECT * FROM manufacturerimages WHERE manufacturer_id = '547'
90 0.0006 0.00057291984558105
SELECT category_id FROM products_categories WHERE product_id = '3903'
91 0.0003 0.00032687187194824
SELECT * FROM categories WHERE id = '26'
92 0.0110 0.01102614402771
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.0002 0.00024199485778809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
94 0.0002 0.00022792816162109
SELECT id FROM categories WHERE parent_id = '26'
95 0.0075 0.0074989795684814
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.0003 0.00026297569274902
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
97 0.0002 0.00022292137145996
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.0002 0.0002129077911377
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
99 0.0005 0.00048208236694336
SELECT * FROM productimages WHERE product_id = '3903' ORDER BY sortorder ASC
100 0.0006 0.00063705444335938
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
101 0.0005 0.00051307678222656
SELECT * FROM product_image_select WHERE product_id = '3903'
102 0.0004 0.0004119873046875
SELECT * FROM productcustomimages WHERE product_id = '3903'
103 0.0005 0.00051093101501465
SELECT * FROM productfeeds WHERE product_id = '3903' ORDER BY item_date DESC
104 0.0006 0.00063085556030273
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3903' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0006 0.00060701370239258
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3903' AND t.hidden = 0 AND display_product = 1
106 0.0003 0.0002901554107666
SELECT * FROM tags WHERE id = '81'
107 0.0036 0.0036230087280273
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
108 0.0034 0.0034160614013672
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
109 0.0038 0.0037908554077148
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' 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.0003 0.00032401084899902
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
111 0.0004 0.00036787986755371
SELECT * FROM tags WHERE id = '3162'
112 0.0008 0.00077605247497559
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3162'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
113 0.0007 0.00071907043457031
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3162'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
114 0.0007 0.00074911117553711
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3162' 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.0005 0.0004880428314209
SELECT * FROM productimages WHERE product_id = '3555' ORDER BY sortorder ASC
116 0.0008 0.00075078010559082
SELECT * FROM productamazoncontent WHERE product_id = '3903'
117 0.0008 0.0008080005645752
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
118 0.0010 0.0010139942169189
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
119 0.0006 0.00055193901062012
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
120 0.0009 0.00092506408691406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3903' AND a.name = n.originalname
121 0.0004 0.00037598609924316
SELECT * FROM productoffers WHERE product_id = '3903' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0006 0.00058794021606445
SELECT * FROM productoffers
                WHERE product_id = '3903' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0004 0.00038504600524902
SELECT * FROM productoffers
                WHERE product_id = 3903
                ORDER BY price ASC LIMIT 1
124 0.0006 0.00058794021606445
SELECT value FROM productattributes
                WHERE product_id = '3903'
                AND name = 'ListPriceAmount'
125 0.0003 0.00028896331787109
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
126 0.0003 0.00026297569274902
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
127 0.0002 0.00024700164794922
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
128 0.0004 0.00040912628173828
SELECT value FROM productattributes WHERE product_id = '3903' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0007 0.00068092346191406
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
130 0.0010 0.0010080337524414
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
131 0.0002 0.00023508071899414
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
132 0.0049 0.0048789978027344
SELECT *, MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AND 3903 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
133 0.0008 0.00078296661376953
SELECT *, MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AND 3903 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
134 0.0007 0.00068783760070801
SELECT *, MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AND 3903 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
135 0.0068 0.0068020820617676
SELECT *, MATCH (description, title) AGAINST ('botes' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('botes' IN BOOLEAN MODE) AND 3903 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
136 0.0009 0.00090193748474121
SELECT *, MATCH (description, title) AGAINST ('botes' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('botes' IN BOOLEAN MODE) AND 3903 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
137 0.0006 0.00062990188598633
SELECT *, MATCH (description, title) AGAINST ('botes' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('botes' IN BOOLEAN MODE) AND 3903 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
138 0.0084 0.008357048034668
SELECT *, MATCH (description, title) AGAINST ('stockage puer pots' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('stockage puer pots' IN BOOLEAN MODE) AND 3903 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
139 0.0007 0.00068497657775879
SELECT *, MATCH (description, title) AGAINST ('stockage puer pots' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('stockage puer pots' IN BOOLEAN MODE) AND 3903 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
140 0.0008 0.00083184242248535
SELECT *, MATCH (description, title) AGAINST ('stockage puer pots' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('stockage puer pots' IN BOOLEAN MODE) AND 3903 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
141 0.0008 0.00084209442138672
SELECT * FROM productimages WHERE product_id = '923' ORDER BY sortorder ASC
142 0.0006 0.00059890747070312
SELECT * FROM product_image_select WHERE product_id = '923'
143 0.0004 0.00043606758117676
SELECT * FROM productcustomimages WHERE product_id = '923'
144 0.0012 0.0012061595916748
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '923' AND a.name = n.originalname
145 0.0005 0.00050902366638184
SELECT * FROM productoffers WHERE product_id = '923' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0005 0.00049781799316406
SELECT * FROM productoffers
                WHERE product_id = '923' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0005 0.00052094459533691
SELECT value FROM productattributes WHERE product_id = '923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0007 0.00068783760070801
SELECT * FROM productimages WHERE product_id = '3770' ORDER BY sortorder ASC
149 0.0005 0.0004730224609375
SELECT * FROM product_image_select WHERE product_id = '3770'
150 0.0008 0.00078582763671875
SELECT * FROM productcustomimages WHERE product_id = '3770'
151 0.0010 0.0010008811950684
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3770' AND a.name = n.originalname
152 0.0005 0.00050091743469238
SELECT * FROM productoffers WHERE product_id = '3770' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '3770' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0005 0.00050592422485352
SELECT value FROM productattributes WHERE product_id = '3770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0005 0.00049686431884766
SELECT * FROM productimages WHERE product_id = '2498' ORDER BY sortorder ASC
156 0.0010 0.00099396705627441
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
157 0.0006 0.0006098747253418
SELECT * FROM product_image_select WHERE product_id = '2498'
158 0.0005 0.00048112869262695
SELECT * FROM productcustomimages WHERE product_id = '2498'
159 0.0006 0.00055813789367676
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
160 0.0007 0.00071287155151367
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
161 0.0005 0.00045990943908691
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
162 0.0010 0.0010151863098145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2498' AND a.name = n.originalname
163 0.0004 0.00043702125549316
SELECT * FROM productoffers WHERE product_id = '2498' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0005 0.00045585632324219
SELECT * FROM productoffers
                WHERE product_id = '2498' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0004 0.00040411949157715
SELECT * FROM productoffers
                WHERE product_id = 2498
                ORDER BY price ASC LIMIT 1
166 0.0004 0.00037193298339844
SELECT value FROM productattributes
                WHERE product_id = '2498'
                AND name = 'ListPriceAmount'
167 0.0002 0.00022006034851074
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
168 0.0002 0.00021791458129883
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
169 0.0002 0.0002129077911377
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
170 0.0004 0.00041913986206055
SELECT value FROM productattributes WHERE product_id = '2498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0008 0.00078797340393066
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
172 0.0005 0.00048518180847168
SELECT * FROM productimages WHERE product_id = '4232' ORDER BY sortorder ASC
173 0.0007 0.00069499015808105
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4232' AND p.id = pi.product_id ORDER BY pi.sortorder
174 0.0004 0.00043201446533203
SELECT * FROM product_image_select WHERE product_id = '4232'
175 0.0004 0.00036787986755371
SELECT * FROM productcustomimages WHERE product_id = '4232'
176 0.0006 0.00060486793518066
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 = '4232'
                GROUP BY o.product_id
177 0.0007 0.00066113471984863
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     = '4232'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
178 0.0005 0.00053191184997559
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
179 0.0007 0.00069713592529297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
180 0.0004 0.00038790702819824
SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0005 0.00047898292541504
SELECT * FROM productoffers
                WHERE product_id = '4232' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = 4232
                ORDER BY price ASC LIMIT 1
183 0.0005 0.00048303604125977
SELECT value FROM productattributes
                WHERE product_id = '4232'
                AND name = 'ListPriceAmount'
184 0.0003 0.00031208992004395
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 = '4232'
                GROUP BY o.product_id
185 0.0003 0.0002598762512207
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     = '4232'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
186 0.0004 0.00035309791564941
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
187 0.0006 0.00055289268493652
SELECT value FROM productattributes WHERE product_id = '4232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0007 0.00066280364990234
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4232'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
189 0.0005 0.00054192543029785
SELECT * FROM productimages WHERE product_id = '2336' ORDER BY sortorder ASC
190 0.0008 0.00076985359191895
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
191 0.0005 0.00048303604125977
SELECT * FROM product_image_select WHERE product_id = '2336'
192 0.0005 0.00052785873413086
SELECT * FROM productcustomimages WHERE product_id = '2336'
193 0.0007 0.00068902969360352
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
194 0.0008 0.00081205368041992
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
195 0.0006 0.00057101249694824
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
196 0.0008 0.00077199935913086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2336' AND a.name = n.originalname
197 0.0005 0.00052499771118164
SELECT * FROM productoffers WHERE product_id = '2336' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0005 0.00053811073303223
SELECT * FROM productoffers
                WHERE product_id = '2336' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0005 0.00053191184997559
SELECT * FROM productoffers
                WHERE product_id = 2336
                ORDER BY price ASC LIMIT 1
200 0.0006 0.00056099891662598
SELECT value FROM productattributes
                WHERE product_id = '2336'
                AND name = 'ListPriceAmount'
201 0.0003 0.00031685829162598
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
202 0.0003 0.00025391578674316
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
203 0.0003 0.00025701522827148
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
204 0.0005 0.00048398971557617
SELECT value FROM productattributes WHERE product_id = '2336' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0007 0.00073695182800293
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
206 0.0006 0.00056695938110352
SELECT * FROM productimages WHERE product_id = '2633' ORDER BY sortorder ASC
207 0.0004 0.00043082237243652
SELECT * FROM product_image_select WHERE product_id = '2633'
208 0.0004 0.00036001205444336
SELECT * FROM productcustomimages WHERE product_id = '2633'
209 0.0011 0.0011107921600342
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2633' AND a.name = n.originalname
210 0.0005 0.00048017501831055
SELECT * FROM productoffers WHERE product_id = '2633' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0005 0.00045204162597656
SELECT * FROM productoffers
                WHERE product_id = '2633' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0007 0.00068807601928711
SELECT value FROM productattributes WHERE product_id = '2633' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0005 0.0005490779876709
SELECT id,asin FROM products WHERE parent_id = 3903
214 0.0004 0.00043797492980957
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4870
215 0.0006 0.00061893463134766
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4870
216 0.0004 0.00044918060302734
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4871
217 0.0005 0.00052690505981445
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4871
218 0.0005 0.0004880428314209
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4872
219 0.0007 0.00067710876464844
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4872
220 0.0005 0.00047707557678223
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4873
221 0.0004 0.00044512748718262
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4873
222 0.0004 0.00037193298339844
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4874
223 0.0005 0.00047397613525391
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4874
224 0.0004 0.00035905838012695
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4875
225 0.0004 0.00043702125549316
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4875
226 0.0003 0.00034594535827637
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4876
227 0.0007 0.00069212913513184
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4876
228 0.0005 0.00050997734069824
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4877
229 0.0005 0.00047898292541504
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4877
230 0.0005 0.00047993659973145
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4878
231 0.0005 0.00054407119750977
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4878
232 0.0005 0.00046110153198242
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4879
233 0.0005 0.00053215026855469
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4879
234 0.0005 0.00047802925109863
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4880
235 0.0005 0.00054097175598145
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4880
236 0.0006 0.0005791187286377
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3903' ORDER BY timestamp DESC
237 0.0003 0.00027108192443848
SELECT category_id FROM products_categories WHERE product_id = '3903'
238 0.0003 0.00034999847412109
SELECT * FROM categories WHERE id = '26'
239 0.0003 0.00033712387084961
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
240 0.0002 0.00021982192993164
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
241 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '26'
242 0.0003 0.00029492378234863
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 
243 0.0003 0.00032687187194824
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 
244 0.0002 0.00023102760314941
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
245 0.0003 0.00026392936706543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
246 0.0003 0.00026893615722656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3903' AND a.name = n.originalname
247 0.0003 0.00033092498779297
SELECT * FROM productoffers WHERE product_id = '3903' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0003 0.00026392936706543
SELECT * FROM productoffers
                WHERE product_id = '3903' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = 3903
                ORDER BY price ASC LIMIT 1
250 0.0002 0.00024819374084473
SELECT value FROM productattributes
                WHERE product_id = '3903'
                AND name = 'ListPriceAmount'
251 0.0006 0.00060415267944336
SELECT * FROM products WHERE id = '3903'
252 0.0003 0.00025701522827148
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
253 0.0002 0.00023603439331055
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
254 0.0002 0.00023794174194336
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
255 0.0002 0.00022506713867188
SELECT value FROM productattributes WHERE product_id = '3903' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0003 0.00027990341186523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3903' AND a.name = n.originalname
257 0.0002 0.00024914741516113
SELECT * FROM productoffers WHERE product_id = '3903' AND merchantid = 'A1X6FK5RDHNB96'
258 0.0003 0.00026607513427734
SELECT * FROM productoffers
                WHERE product_id = '3903' AND price > 0
                ORDER BY price ASC LIMIT 1
259 0.0003 0.00030398368835449
SELECT * FROM productoffers
                WHERE product_id = 3903
                ORDER BY price ASC LIMIT 1
260 0.0003 0.00025582313537598
SELECT value FROM productattributes
                WHERE product_id = '3903'
                AND name = 'ListPriceAmount'
261 0.0003 0.00027322769165039
SELECT DISTINCT (name) FROM productoptions
262 0.0008 0.00078320503234863
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 3903))
263 0.0007 0.00074005126953125
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 3903
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
264 0.0004 0.00038504600524902
SELECT * FROM translationsfilter
265 0.0006 0.00059700012207031
SELECT category_id FROM products_categories WHERE product_id = '3903' AND prod_type = 'amz'
266 0.0004 0.00036406517028809
SELECT parent_id FROM categories WHERE id = '26'
267 0.0005 0.00046896934509277
SELECT * FROM categories WHERE id = '26'
268 0.0004 0.00037503242492676
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
269 0.0004 0.00036311149597168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
270 0.0004 0.00035405158996582
SELECT id FROM categories WHERE parent_id = '26'
271 0.0003 0.00034189224243164
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 
272 0.0003 0.00032305717468262
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 
273 0.0003 0.00028800964355469
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
274 0.0003 0.0002601146697998
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
275 0.0004 0.00035595893859863
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
276 0.0002 0.00023508071899414
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
277 0.0003 0.00028705596923828
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
278 0.0170 0.017045021057129
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
279 0.0004 0.00037097930908203
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
280 0.0002 0.00024104118347168
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
281 0.0005 0.00046706199645996
SELECT * FROM products WHERE id = 1626
282 0.0007 0.00071382522583008
SELECT * FROM products WHERE id = 4041
283 0.0007 0.00069189071655273
SELECT * FROM products WHERE id = 4312
284 0.0007 0.0007331371307373
SELECT * FROM products WHERE id = 777
285 0.0006 0.000640869140625
SELECT * FROM products WHERE id = 4213
286 0.0006 0.00062417984008789
SELECT * FROM products WHERE id = 3881
287 0.0009 0.00086307525634766
SELECT * FROM products WHERE id = '1626'
288 0.0004 0.00044608116149902
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
289 0.0003 0.00026297569274902
SELECT * FROM product_image_select WHERE product_id = '1626'
290 0.0002 0.00022292137145996
SELECT * FROM productcustomimages WHERE product_id = '1626'
291 0.0004 0.00035715103149414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
292 0.0004 0.00036382675170898
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
293 0.0003 0.00034904479980469
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
294 0.0003 0.00025081634521484
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
295 0.0005 0.00053596496582031
SELECT * FROM products WHERE id = '4041'
296 0.0003 0.00031900405883789
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
297 0.0002 0.00024795532226562
SELECT * FROM product_image_select WHERE product_id = '4041'
298 0.0002 0.00022196769714355
SELECT * FROM productcustomimages WHERE product_id = '4041'
299 0.0003 0.00028395652770996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
300 0.0003 0.00025606155395508
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
301 0.0004 0.00037407875061035
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
302 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
303 0.0006 0.00063586235046387
SELECT * FROM products WHERE id = '4312'
304 0.0003 0.00030994415283203
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
305 0.0003 0.00027298927307129
SELECT * FROM product_image_select WHERE product_id = '4312'
306 0.0002 0.00022792816162109
SELECT * FROM productcustomimages WHERE product_id = '4312'
307 0.0004 0.00036191940307617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
308 0.0004 0.00037407875061035
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
309 0.0004 0.0004119873046875
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
310 0.0003 0.00028586387634277
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
311 0.0005 0.00048995018005371
SELECT * FROM products WHERE id = '777'
312 0.0003 0.00029301643371582
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
313 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '777'
314 0.0002 0.00022578239440918
SELECT * FROM productcustomimages WHERE product_id = '777'
315 0.0004 0.00037312507629395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
316 0.0004 0.0003812313079834
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
317 0.0003 0.00027298927307129
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
318 0.0003 0.00032591819763184
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
319 0.0007 0.00067400932312012
SELECT * FROM products WHERE id = '4213'
320 0.0005 0.00053596496582031
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
321 0.0003 0.00027298927307129
SELECT * FROM product_image_select WHERE product_id = '4213'
322 0.0003 0.00034093856811523
SELECT * FROM productcustomimages WHERE product_id = '4213'
323 0.0004 0.00036382675170898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
324 0.0004 0.0003509521484375
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
325 0.0004 0.00036716461181641
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
326 0.0002 0.00022697448730469
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
327 0.0006 0.00056886672973633
SELECT * FROM products WHERE id = '3881'
328 0.0005 0.00050592422485352
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
329 0.0003 0.00028610229492188
SELECT * FROM product_image_select WHERE product_id = '3881'
330 0.0003 0.00032591819763184
SELECT * FROM productcustomimages WHERE product_id = '3881'
331 0.0003 0.00027918815612793
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
332 0.0004 0.00035500526428223
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
333 0.0003 0.00029897689819336
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
334 0.0002 0.00023794174194336
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
335 0.0005 0.00047993659973145
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
336 0.0007 0.00071001052856445
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
337 0.0007 0.00069713592529297
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
338 0.0005 0.00049901008605957
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
339 0.0006 0.00059390068054199
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
340 0.0006 0.00058507919311523
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'