0

The Tea Makers of London Lot de 2 boîtes de thé en étain 100 g

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-26 01:48:42 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

Boîte à thé en métal style japonais livré en lot de 2

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

Wait! We have a something for you...

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

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

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.7148289680481 312 1.1107 0


No Amazon API Requests Made.


App Debug - Total Time 1.7148289680481 seconds

Number Time From Start Name Description
1 0.42626309394836 Initialise Initialise FSB Function
2 0.43029594421387 App Controller Start Start of the App controller (called before the controller of every page)
3 0.47473812103271 Start of getCategoryListByGroup Function Before first category groups query
4 0.47541499137878 After initial query Before first category groups query
5 0.4754159450531 Get Category List for Group Before the call to getCategoryList function
6 0.47541904449463 Start of GetCategoryList function Start of the function
7 0.47542190551758 Before getting categories Query to get specific category list
8 0.47606897354126 After getting categories Query to get specific category list
9 0.47607111930847 Before getting category custom Before call to function getCategoryCustom
10 0.49483489990234 After getting category custom After call to function getCategoryCustom
11 0.49483704566956 Before getting category custom Before call to function getCategoryCustom
12 0.50722408294678 After getting category custom After call to function getCategoryCustom
13 0.50722599029541 Before getting category custom Before call to function getCategoryCustom
14 0.51367998123169 After getting category custom After call to function getCategoryCustom
15 0.51368093490601 Before getting category custom Before call to function getCategoryCustom
16 0.51782894134521 After getting category custom After call to function getCategoryCustom
17 0.51782894134521 Before getting category custom Before call to function getCategoryCustom
18 0.52209091186523 After getting category custom After call to function getCategoryCustom
19 0.52209210395813 Before getting category custom Before call to function getCategoryCustom
20 0.52635502815247 After getting category custom After call to function getCategoryCustom
21 0.52635598182678 End of GetCategoryList function End of the function
22 0.52636003494263 Get Category List for Group Before the call to getCategoryList function
23 0.52636194229126 Start of GetCategoryList function Start of the function
24 0.52636289596558 Before getting categories Query to get specific category list
25 0.52684211730957 End of getCategoryListByGroup Function Before return()
26 1.2966959476471 App Controller End End of the App controller (called before the controller of every page)
27 1.2972249984741 Product Start Start of the product info controller
28 1.3577930927277 Cache file not found Starting get product details
29 1.4115169048309 Related products Start getting related products if enabled
30 1.4115180969238 Related Products Start Before the related products are found
31 1.4115190505981 Related Products Keywords Before the related product keywords are found
32 1.4115240573883 Create Keyword List Function Start of function
33 1.4115560054779 Create Keyword List Function After looping provided content - 35 keywords found
34 1.4123859405518 Create Keyword List Function After looping initial keyword list - 29 keywords remaining
35 1.4123930931091 Create Keyword List Function After reducing keyword list
36 1.4124779701233 Create Keyword List Function After selecting by scoring keywords
37 1.4124820232391 Create Keyword List Function After final loop of keywords
38 1.4124829769135 Related Products Keywords After the related product keywords are found
39 1.5129868984222 Related Products End After the related products are found
40 1.5483350753784 Product End End of the product info controller (Product Info)
41 1.5496180057526 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.5503649711609 Before Get Options Before the call to getOptions in the tpl class
43 1.5967950820923 After Get Options After the call to getOptions in the tpl class
44 1.5968658924103 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.596892118454 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.6401720046997 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.6401760578156 Product Info: Before Template Display Before the template is displayed
48 1.7148060798645 Product Info: After Template Display After the template is displayed
49 1.7148170471191 Finalizing debug Before the debug is output to the page.
50 1.7148289680481 End of App This is the end of the app logging, final timestamp


Query Debug - 312 Database Queries. Total time 1.1107 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022091865539551
SELECT parameter, value FROM parameters
2 0.0045 0.0044729709625244
SELECT * FROM `bad_bots`
3 0.0004 0.00037288665771484
SET time_zone = 'Europe/London'
4 0.0008 0.00076413154602051
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0012 0.0012431144714355
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.9.174\";}'
6 0.0009 0.00092315673828125
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745457992'
7 0.0015 0.0015499591827393
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00083208084106445
UPDATE autorun SET lastrun = '2025-04-24 01:26:32' WHERE id = '16'
9 0.0006 0.00063800811767578
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0013 0.0012869834899902
SELECT id FROM pages WHERE pagename = 'the-tea-makers-of-london-lot-de-2botes-de-the-en-etain-100g' LIMIT 1
11 0.0014 0.0014381408691406
SELECT id FROM products WHERE pagename = 'the-tea-makers-of-london-lot-de-2botes-de-the-en-etain-100g' AND hidden = 0 LIMIT 1
12 0.0045 0.0044550895690918
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0389 0.038873910903931
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00061893463134766
SELECT * FROM pages WHERE pagename = 'the-tea-makers-of-london-lot-de-2botes-de-the-en-etain-100g'
15 0.0007 0.00066494941711426
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00063300132751465
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0075 0.0074810981750488
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0007 0.00068902969360352
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0005 0.0005490779876709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00047683715820312
SELECT id FROM categories WHERE parent_id = '26'
21 0.0073 0.0073070526123047
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0006 0.00055694580078125
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0006 0.00059795379638672
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0005 0.00049805641174316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00050902366638184
SELECT * FROM categorygroups WHERE id = '1'
26 0.0043 0.0043230056762695
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0006 0.00055599212646484
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.00040912628173828
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00045514106750488
SELECT id FROM categories WHERE parent_id = '27'
30 0.0046 0.0045521259307861
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0006 0.00055694580078125
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0006 0.0005950927734375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0005 0.00048208236694336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00040888786315918
SELECT * FROM categorygroups WHERE id = '1'
35 0.0016 0.001582145690918
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0005 0.00051593780517578
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0003 0.00034713745117188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00043606758117676
SELECT id FROM categories WHERE parent_id = '28'
39 0.0018 0.0017709732055664
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0005 0.00048208236694336
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0005 0.00049209594726562
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0004 0.00042009353637695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00036907196044922
SELECT * FROM categorygroups WHERE id = '1'
44 0.0005 0.00054097175598145
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0004 0.00040698051452637
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.00038790702819824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00038981437683105
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.00061202049255371
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0005 0.00046515464782715
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0005 0.0005040168762207
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0004 0.00043296813964844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.0003821849822998
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00051522254943848
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0004 0.00043892860412598
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0004 0.00038790702819824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00041389465332031
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00065779685974121
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0005 0.00045204162597656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0005 0.00047206878662109
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0004 0.00042581558227539
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00047492980957031
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00056004524230957
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.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 = 31
64 0.0003 0.00034809112548828
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00037097930908203
SELECT id FROM categories WHERE parent_id = '31'
66 0.0007 0.00072193145751953
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0005 0.00051999092102051
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0005 0.00048398971557617
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0005 0.00045514106750488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00038409233093262
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00047492980957031
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0019 0.0018560886383057
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0006 0.00061893463134766
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.00056910514831543
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0004 0.00040602684020996
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0014 0.00136399269104
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0009 0.00093293190002441
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.7611 0.76108002662659
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.9.174') >= INET_ATON(ip_start) AND INET_ATON('18.97.9.174') <= INET_ATON(ip_end)
79 0.0011 0.0010991096496582
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0005 0.00046491622924805
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0007 0.00068306922912598
SELECT * FROM products WHERE pagename = 'the-tea-makers-of-london-lot-de-2botes-de-the-en-etain-100g'
82 0.0004 0.00038695335388184
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1339
83 0.0011 0.0011410713195801
SELECT * FROM manufacturers WHERE id = '305'
84 0.0010 0.0010058879852295
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '305'
85 0.0037 0.0037150382995605
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '305' LIMIT 1
86 0.0016 0.0016038417816162
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '305' ORDER BY RAND() LIMIT 1
87 0.0008 0.00081610679626465
SELECT * FROM productimages WHERE product_id = '1339' ORDER BY sortorder ASC
88 0.0008 0.00075411796569824
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '305'
89 0.0009 0.00092601776123047
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '305'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0005 0.00052404403686523
SELECT * FROM manufacturerimages WHERE manufacturer_id = '305'
91 0.0009 0.00094294548034668
SELECT category_id FROM products_categories WHERE product_id = '1339'
92 0.0009 0.00093412399291992
SELECT * FROM categories WHERE id = '26'
93 0.0142 0.01418399810791
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
94 0.0006 0.00059080123901367
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
95 0.0004 0.00044798851013184
SELECT id FROM categories WHERE parent_id = '26'
96 0.0085 0.008491039276123
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
97 0.0007 0.00072383880615234
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
98 0.0006 0.00059413909912109
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
99 0.0006 0.00063800811767578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
100 0.0006 0.00060391426086426
SELECT * FROM productimages WHERE product_id = '1339' ORDER BY sortorder ASC
101 0.0008 0.00078201293945312
SELECT * FROM product_image_select WHERE product_id = '1339'
102 0.0005 0.00051593780517578
SELECT * FROM productcustomimages WHERE product_id = '1339'
103 0.0019 0.0018820762634277
SELECT * FROM productfeeds WHERE product_id = '1339' ORDER BY item_date DESC
104 0.0009 0.00092720985412598
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1339' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0034 0.0034379959106445
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1339' AND t.hidden = 0 AND display_product = 1
106 0.0020 0.0020408630371094
SELECT * FROM productamazoncontent WHERE product_id = '1339'
107 0.0018 0.0017580986022949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1339' AND a.name = n.originalname
108 0.0006 0.0006411075592041
SELECT * FROM productoffers WHERE product_id = '1339' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0005 0.00050806999206543
SELECT * FROM productoffers
                WHERE product_id = '1339' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0005 0.00048089027404785
SELECT * FROM productoffers
                WHERE product_id = 1339
                ORDER BY price ASC LIMIT 1
111 0.0005 0.00047397613525391
SELECT value FROM productattributes
                WHERE product_id = '1339'
                AND name = 'ListPriceAmount'
112 0.0006 0.00056886672973633
SELECT value FROM productattributes WHERE product_id = '1339' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0005 0.00054383277893066
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
114 0.0104 0.010362863540649
SELECT *, MATCH (description, title) AGAINST ('thé en étain' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé en étain' IN BOOLEAN MODE) AND 1339 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
115 0.0006 0.0005640983581543
SELECT *, MATCH (description, title) AGAINST ('thé en étain' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé en étain' IN BOOLEAN MODE) AND 1339 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0005 0.00050210952758789
SELECT *, MATCH (description, title) AGAINST ('thé en étain' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé en étain' IN BOOLEAN MODE) AND 1339 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
117 0.0006 0.00055384635925293
SELECT * FROM productimages WHERE product_id = '4895' ORDER BY sortorder ASC
118 0.0004 0.00042104721069336
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
119 0.0006 0.00058913230895996
SELECT * FROM product_image_select WHERE product_id = '4895'
120 0.0005 0.00046396255493164
SELECT * FROM productcustomimages WHERE product_id = '4895'
121 0.0007 0.00066399574279785
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
122 0.0008 0.00079083442687988
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
123 0.0005 0.00049614906311035
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
124 0.0009 0.00087618827819824
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4895' AND a.name = n.originalname
125 0.0004 0.00042200088500977
SELECT * FROM productoffers WHERE product_id = '4895' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0004 0.00037121772766113
SELECT * FROM productoffers
                WHERE product_id = '4895' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = 4895
                ORDER BY price ASC LIMIT 1
128 0.0004 0.00041389465332031
SELECT value FROM productattributes
                WHERE product_id = '4895'
                AND name = 'ListPriceAmount'
129 0.0005 0.0004580020904541
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
130 0.0008 0.00075006484985352
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
131 0.0005 0.00054597854614258
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
132 0.0007 0.0006711483001709
SELECT value FROM productattributes WHERE product_id = '4895' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0008 0.00077390670776367
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
134 0.0006 0.00057506561279297
SELECT * FROM productimages WHERE product_id = '2612' ORDER BY sortorder ASC
135 0.0005 0.00053501129150391
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2612' AND p.id = pi.product_id ORDER BY pi.sortorder
136 0.0007 0.00074291229248047
SELECT * FROM product_image_select WHERE product_id = '2612'
137 0.0006 0.00055909156799316
SELECT * FROM productcustomimages WHERE product_id = '2612'
138 0.0007 0.00069212913513184
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 = '2612'
                GROUP BY o.product_id
139 0.0007 0.00073409080505371
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     = '2612'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
140 0.0005 0.00051116943359375
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2612
141 0.0010 0.0010058879852295
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2612' AND a.name = n.originalname
142 0.0005 0.00046277046203613
SELECT * FROM productoffers WHERE product_id = '2612' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0005 0.00050902366638184
SELECT * FROM productoffers
                WHERE product_id = '2612' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0005 0.0004570484161377
SELECT * FROM productoffers
                WHERE product_id = 2612
                ORDER BY price ASC LIMIT 1
145 0.0005 0.00054693222045898
SELECT value FROM productattributes
                WHERE product_id = '2612'
                AND name = 'ListPriceAmount'
146 0.0006 0.00057411193847656
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 = '2612'
                GROUP BY o.product_id
147 0.0008 0.00077509880065918
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     = '2612'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
148 0.0005 0.00052905082702637
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2612
149 0.0006 0.00064206123352051
SELECT value FROM productattributes WHERE product_id = '2612' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0007 0.00074195861816406
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2612'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
151 0.0005 0.00047588348388672
SELECT * FROM productimages WHERE product_id = '1000' ORDER BY sortorder ASC
152 0.0006 0.00062799453735352
SELECT * FROM product_image_select WHERE product_id = '1000'
153 0.0004 0.00038599967956543
SELECT * FROM productcustomimages WHERE product_id = '1000'
154 0.0007 0.00074982643127441
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1000' AND a.name = n.originalname
155 0.0005 0.00046300888061523
SELECT * FROM productoffers WHERE product_id = '1000' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0004 0.00037980079650879
SELECT * FROM productoffers
                WHERE product_id = '1000' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0004 0.0004270076751709
SELECT value FROM productattributes WHERE product_id = '1000' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0006 0.00061893463134766
SELECT * FROM productimages WHERE product_id = '797' ORDER BY sortorder ASC
159 0.0006 0.00061821937561035
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '797' AND p.id = pi.product_id ORDER BY pi.sortorder
160 0.0005 0.00053691864013672
SELECT * FROM product_image_select WHERE product_id = '797'
161 0.0004 0.00038409233093262
SELECT * FROM productcustomimages WHERE product_id = '797'
162 0.0005 0.00049805641174316
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 = '797'
                GROUP BY o.product_id
163 0.0006 0.00059604644775391
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     = '797'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
164 0.0004 0.00042510032653809
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 797
165 0.0009 0.00087094306945801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '797' AND a.name = n.originalname
166 0.0004 0.00041604042053223
SELECT * FROM productoffers WHERE product_id = '797' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0004 0.00040006637573242
SELECT * FROM productoffers
                WHERE product_id = '797' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0003 0.00031208992004395
SELECT * FROM productoffers
                WHERE product_id = 797
                ORDER BY price ASC LIMIT 1
169 0.0003 0.00034093856811523
SELECT value FROM productattributes
                WHERE product_id = '797'
                AND name = 'ListPriceAmount'
170 0.0004 0.00040197372436523
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 = '797'
                GROUP BY o.product_id
171 0.0006 0.00062012672424316
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     = '797'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
172 0.0004 0.00039196014404297
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 797
173 0.0005 0.00045394897460938
SELECT value FROM productattributes WHERE product_id = '797' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
174 0.0006 0.00063800811767578
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '797'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
175 0.0086 0.0086081027984619
SELECT *, MATCH (description, title) AGAINST ('makers of london' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('makers of london' IN BOOLEAN MODE) AND 1339 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
176 0.0006 0.00056600570678711
SELECT *, MATCH (description, title) AGAINST ('makers of london' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('makers of london' IN BOOLEAN MODE) AND 1339 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
177 0.0005 0.00046610832214355
SELECT *, MATCH (description, title) AGAINST ('makers of london' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('makers of london' IN BOOLEAN MODE) AND 1339 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
178 0.0038 0.0037660598754883
SELECT *, MATCH (description, title) AGAINST ('2boÃtes de thé' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('2boÃtes de thé' IN BOOLEAN MODE) AND 1339 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
179 0.0004 0.00038814544677734
SELECT *, MATCH (description, title) AGAINST ('2boÃtes de thé' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('2boÃtes de thé' IN BOOLEAN MODE) AND 1339 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
180 0.0003 0.00033903121948242
SELECT *, MATCH (description, title) AGAINST ('2boÃtes de thé' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('2boÃtes de thé' IN BOOLEAN MODE) AND 1339 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
181 0.0082 0.0082430839538574
SELECT *, MATCH (description, title) AGAINST ('tea makers' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('tea makers' IN BOOLEAN MODE) AND 1339 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
182 0.0004 0.00043296813964844
SELECT *, MATCH (description, title) AGAINST ('tea makers' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('tea makers' IN BOOLEAN MODE) AND 1339 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
183 0.0004 0.00038695335388184
SELECT *, MATCH (description, title) AGAINST ('tea makers' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('tea makers' IN BOOLEAN MODE) AND 1339 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
184 0.0012 0.0012009143829346
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1339') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
185 0.0153 0.015283107757568
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '26' AND pc.prod_type = 'amz'  AND p.id <> '1339' ORDER BY RAND()
186 0.0007 0.0007328987121582
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '26' AND pc.prod_type = 'ebay' AND p.id <> '1339' ORDER BY RAND()
187 0.0005 0.0005497932434082
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '26' AND pc.prod_type = 'custom' AND p.id <> '1339' ORDER BY RAND()
188 0.0005 0.00049591064453125
SELECT * FROM productimages WHERE product_id = '844' ORDER BY sortorder ASC
189 0.0005 0.00053095817565918
SELECT * FROM product_image_select WHERE product_id = '844'
190 0.0003 0.00034785270690918
SELECT * FROM productcustomimages WHERE product_id = '844'
191 0.0009 0.00086021423339844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '844' AND a.name = n.originalname
192 0.0004 0.00041294097900391
SELECT * FROM productoffers WHERE product_id = '844' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0003 0.00032782554626465
SELECT * FROM productoffers
                WHERE product_id = '844' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0003 0.00034904479980469
SELECT * FROM productoffers
                WHERE product_id = 844
                ORDER BY price ASC LIMIT 1
195 0.0004 0.00036287307739258
SELECT value FROM productattributes
                WHERE product_id = '844'
                AND name = 'ListPriceAmount'
196 0.0004 0.00035905838012695
SELECT value FROM productattributes WHERE product_id = '844' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0005 0.000457763671875
SELECT * FROM productimages WHERE product_id = '2653' ORDER BY sortorder ASC
198 0.0005 0.00045013427734375
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2653' AND p.id = pi.product_id ORDER BY pi.sortorder
199 0.0005 0.00053715705871582
SELECT * FROM product_image_select WHERE product_id = '2653'
200 0.0003 0.00034999847412109
SELECT * FROM productcustomimages WHERE product_id = '2653'
201 0.0005 0.00051307678222656
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 = '2653'
                GROUP BY o.product_id
202 0.0005 0.00054192543029785
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     = '2653'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
203 0.0003 0.0003359317779541
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2653
204 0.0007 0.00073099136352539
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2653' AND a.name = n.originalname
205 0.0004 0.00036907196044922
SELECT * FROM productoffers WHERE product_id = '2653' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0003 0.00032901763916016
SELECT * FROM productoffers
                WHERE product_id = '2653' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0003 0.00031089782714844
SELECT * FROM productoffers
                WHERE product_id = 2653
                ORDER BY price ASC LIMIT 1
208 0.0003 0.00032711029052734
SELECT value FROM productattributes
                WHERE product_id = '2653'
                AND name = 'ListPriceAmount'
209 0.0004 0.00037288665771484
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 = '2653'
                GROUP BY o.product_id
210 0.0005 0.00054597854614258
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     = '2653'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
211 0.0004 0.00039196014404297
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2653
212 0.0005 0.00049710273742676
SELECT value FROM productattributes WHERE product_id = '2653' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0004 0.00039291381835938
SELECT * FROM products WHERE parent_id = '2653'
214 0.0003 0.00029110908508301
SELECT id,asin FROM products WHERE parent_id = 1339
215 0.0015 0.0015089511871338
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1339' ORDER BY timestamp DESC
216 0.0004 0.00042891502380371
SELECT category_id FROM products_categories WHERE product_id = '1339'
217 0.0004 0.00043797492980957
SELECT * FROM categories WHERE id = '26'
218 0.0053 0.0052628517150879
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
219 0.0004 0.00040912628173828
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
220 0.0003 0.00027894973754883
SELECT id FROM categories WHERE parent_id = '26'
221 0.0052 0.0051858425140381
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 
222 0.0005 0.00050592422485352
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 
223 0.0005 0.00054717063903809
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
224 0.0005 0.00046992301940918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
225 0.0009 0.00094199180603027
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1339' AND a.name = n.originalname
226 0.0004 0.00044488906860352
SELECT * FROM productoffers WHERE product_id = '1339' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0003 0.00034284591674805
SELECT * FROM productoffers
                WHERE product_id = '1339' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0003 0.00031805038452148
SELECT * FROM productoffers
                WHERE product_id = 1339
                ORDER BY price ASC LIMIT 1
229 0.0003 0.00034594535827637
SELECT value FROM productattributes
                WHERE product_id = '1339'
                AND name = 'ListPriceAmount'
230 0.0005 0.0005030632019043
SELECT * FROM products WHERE id = '1339'
231 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '1339' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0008 0.00079989433288574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1339' AND a.name = n.originalname
233 0.0003 0.00033998489379883
SELECT * FROM productoffers WHERE product_id = '1339' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0003 0.00032401084899902
SELECT * FROM productoffers
                WHERE product_id = '1339' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0003 0.00028586387634277
SELECT * FROM productoffers
                WHERE product_id = 1339
                ORDER BY price ASC LIMIT 1
236 0.0003 0.00034403800964355
SELECT value FROM productattributes
                WHERE product_id = '1339'
                AND name = 'ListPriceAmount'
237 0.0004 0.00042605400085449
SELECT category_id FROM products_categories WHERE product_id = '1339' AND prod_type = 'amz'
238 0.0004 0.00038003921508789
SELECT parent_id FROM categories WHERE id = '26'
239 0.0003 0.00030088424682617
SELECT * FROM categories WHERE id = '26'
240 0.0053 0.0052859783172607
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
241 0.0004 0.00041699409484863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
242 0.0003 0.00029492378234863
SELECT id FROM categories WHERE parent_id = '26'
243 0.0052 0.0051679611206055
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 
244 0.0005 0.00049781799316406
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 
245 0.0006 0.00059795379638672
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
246 0.0004 0.00044393539428711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
247 0.0005 0.00047492980957031
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
248 0.0004 0.00039196014404297
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
249 0.0003 0.00029516220092773
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
250 0.0124 0.012397050857544
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
251 0.0006 0.00061392784118652
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
252 0.0005 0.00051999092102051
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
253 0.0005 0.00050187110900879
SELECT * FROM products WHERE id = 1626
254 0.0004 0.00041890144348145
SELECT * FROM products WHERE id = 4041
255 0.0004 0.00038313865661621
SELECT * FROM products WHERE id = 4312
256 0.0003 0.00033378601074219
SELECT * FROM products WHERE id = 777
257 0.0003 0.00031495094299316
SELECT * FROM products WHERE id = 3881
258 0.0004 0.00036191940307617
SELECT * FROM products WHERE id = 4213
259 0.0004 0.0003509521484375
SELECT * FROM products WHERE id = '1626'
260 0.0004 0.00043511390686035
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
261 0.0006 0.00055408477783203
SELECT * FROM product_image_select WHERE product_id = '1626'
262 0.0004 0.00035810470581055
SELECT * FROM productcustomimages WHERE product_id = '1626'
263 0.0008 0.00079178810119629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
264 0.0004 0.00044679641723633
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
265 0.0004 0.00037384033203125
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267 0.0005 0.00047492980957031
SELECT * FROM products WHERE id = '4041'
268 0.0004 0.00041508674621582
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
269 0.0005 0.00052118301391602
SELECT * FROM product_image_select WHERE product_id = '4041'
270 0.0003 0.00032281875610352
SELECT * FROM productcustomimages WHERE product_id = '4041'
271 0.0010 0.0010151863098145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
272 0.0004 0.00042510032653809
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
273 0.0004 0.00038599967956543
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
274 0.0004 0.00037908554077148
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275 0.0005 0.00051498413085938
SELECT * FROM products WHERE id = '4312'
276 0.0004 0.00040292739868164
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
277 0.0006 0.00056195259094238
SELECT * FROM product_image_select WHERE product_id = '4312'
278 0.0004 0.00041818618774414
SELECT * FROM productcustomimages WHERE product_id = '4312'
279 0.0009 0.00094199180603027
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
280 0.0004 0.0004270076751709
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
281 0.0004 0.00035285949707031
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
282 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
283 0.0005 0.00046586990356445
SELECT * FROM products WHERE id = '777'
284 0.0004 0.00040507316589355
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
285 0.0005 0.00053691864013672
SELECT * FROM product_image_select WHERE product_id = '777'
286 0.0004 0.00036907196044922
SELECT * FROM productcustomimages WHERE product_id = '777'
287 0.0009 0.00092411041259766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
288 0.0004 0.00043487548828125
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
289 0.0004 0.00037598609924316
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
290 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291 0.0005 0.00046706199645996
SELECT * FROM products WHERE id = '3881'
292 0.0005 0.00048708915710449
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
293 0.0005 0.00053215026855469
SELECT * FROM product_image_select WHERE product_id = '3881'
294 0.0004 0.00036382675170898
SELECT * FROM productcustomimages WHERE product_id = '3881'
295 0.0010 0.0010371208190918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
296 0.0005 0.0004570484161377
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
297 0.0004 0.00040721893310547
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
298 0.0004 0.00037097930908203
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
299 0.0005 0.00048184394836426
SELECT * FROM products WHERE id = '4213'
300 0.0005 0.00046801567077637
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
301 0.0006 0.00056290626525879
SELECT * FROM product_image_select WHERE product_id = '4213'
302 0.0004 0.00037789344787598
SELECT * FROM productcustomimages WHERE product_id = '4213'
303 0.0011 0.0010590553283691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
304 0.0004 0.00044393539428711
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
305 0.0004 0.00040006637573242
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
306 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
307 0.0007 0.0007331371307373
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
308 0.0007 0.0006558895111084
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
309 0.0014 0.001384973526001
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
310 0.0006 0.0005958080291748
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
311 0.0005 0.00047206878662109
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
312 0.0010 0.0010440349578857
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'