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.8602521419525 303 1.4651 0


No Amazon API Requests Made.


App Debug - Total Time 1.8602521419525 seconds

Number Time From Start Name Description
1 0.46540713310242 Initialise Initialise FSB Function
2 0.48458313941956 App Controller Start Start of the App controller (called before the controller of every page)
3 0.53441309928894 Start of getCategoryListByGroup Function Before first category groups query
4 0.53637599945068 After initial query Before first category groups query
5 0.53637719154358 Get Category List for Group Before the call to getCategoryList function
6 0.53638005256653 Start of GetCategoryList function Start of the function
7 0.53638219833374 Before getting categories Query to get specific category list
8 0.53841805458069 After getting categories Query to get specific category list
9 0.53841805458069 Before getting category custom Before call to function getCategoryCustom
10 0.5821681022644 After getting category custom After call to function getCategoryCustom
11 0.58217000961304 Before getting category custom Before call to function getCategoryCustom
12 0.5934910774231 After getting category custom After call to function getCategoryCustom
13 0.59349513053894 Before getting category custom Before call to function getCategoryCustom
14 0.60239219665527 After getting category custom After call to function getCategoryCustom
15 0.60239505767822 Before getting category custom Before call to function getCategoryCustom
16 0.60693216323853 After getting category custom After call to function getCategoryCustom
17 0.60693407058716 Before getting category custom Before call to function getCategoryCustom
18 0.61147212982178 After getting category custom After call to function getCategoryCustom
19 0.61147403717041 Before getting category custom Before call to function getCategoryCustom
20 0.61559700965881 After getting category custom After call to function getCategoryCustom
21 0.61559915542603 End of GetCategoryList function End of the function
22 0.6156051158905 Get Category List for Group Before the call to getCategoryList function
23 0.61560702323914 Start of GetCategoryList function Start of the function
24 0.61560916900635 Before getting categories Query to get specific category list
25 0.6160740852356 End of getCategoryListByGroup Function Before return()
26 1.4665532112122 App Controller End End of the App controller (called before the controller of every page)
27 1.4671101570129 Product Start Start of the product info controller
28 1.4688951969147 Cache file not found Starting get product details
29 1.5227911472321 Related products Start getting related products if enabled
30 1.5227921009064 Related Products Start Before the related products are found
31 1.5227930545807 Related Products Keywords Before the related product keywords are found
32 1.5227980613708 Create Keyword List Function Start of function
33 1.5229060649872 Create Keyword List Function After looping provided content - 35 keywords found
34 1.5237100124359 Create Keyword List Function After looping initial keyword list - 29 keywords remaining
35 1.5237171649933 Create Keyword List Function After reducing keyword list
36 1.5238080024719 Create Keyword List Function After selecting by scoring keywords
37 1.5238120555878 Create Keyword List Function After final loop of keywords
38 1.523814201355 Related Products Keywords After the related product keywords are found
39 1.6745901107788 Related Products End After the related products are found
40 1.7243990898132 Product End End of the product info controller (Product Info)
41 1.7273671627045 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.7292351722717 Before Get Options Before the call to getOptions in the tpl class
43 1.8277411460876 After Get Options After the call to getOptions in the tpl class
44 1.8278870582581 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.8279161453247 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.8375990390778 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.8376021385193 Product Info: Before Template Display Before the template is displayed
48 1.8602352142334 Product Info: After Template Display After the template is displayed
49 1.8602440357208 Finalizing debug Before the debug is output to the page.
50 1.8602521419525 End of App This is the end of the app logging, final timestamp


Query Debug - 303 Database Queries. Total time 1.4651 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0019 0.0019021034240723
SELECT parameter, value FROM parameters
2 0.0064 0.0063850879669189
SELECT * FROM `bad_bots`
3 0.0003 0.00030708312988281
SET time_zone = 'Europe/London'
4 0.0171 0.017060041427612
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0331 0.033078908920288
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.225.235.148\";}'
6 0.0487 0.048685073852539
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746811620'
7 0.0060 0.0060250759124756
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0011 0.0011270046234131
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0063 0.0062730312347412
SELECT id FROM pages WHERE pagename = 'the-tea-makers-of-london-lot-de-2botes-de-the-en-etain-100g' LIMIT 1
10 0.0112 0.011209964752197
SELECT id FROM products WHERE pagename = 'the-tea-makers-of-london-lot-de-2botes-de-the-en-etain-100g' AND hidden = 0 LIMIT 1
11 0.0100 0.010016918182373
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0389 0.038923978805542
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.0005791187286377
SELECT * FROM pages WHERE pagename = 'the-tea-makers-of-london-lot-de-2botes-de-the-en-etain-100g'
14 0.0020 0.001957893371582
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0020 0.0020248889923096
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0191 0.019093990325928
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.0027 0.0026850700378418
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.0024 0.002424955368042
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0007 0.00068807601928711
SELECT id FROM categories WHERE parent_id = '26'
20 0.0121 0.012103080749512
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.0023 0.0022969245910645
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.0023 0.002269983291626
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.0017 0.0017120838165283
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00041508674621582
SELECT * FROM categorygroups WHERE id = '1'
25 0.0038 0.0037729740142822
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.0005 0.0004570484161377
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.00034594535827637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00035285949707031
SELECT id FROM categories WHERE parent_id = '27'
29 0.0037 0.0036690235137939
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.0011 0.0010750293731689
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.0006 0.00060200691223145
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.0005 0.00053596496582031
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.0004420280456543
SELECT * FROM categorygroups WHERE id = '1'
34 0.0019 0.0019440650939941
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.0005 0.00052595138549805
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.00041103363037109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00044703483581543
SELECT id FROM categories WHERE parent_id = '28'
38 0.0034 0.003364086151123
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.0006 0.00057077407836914
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.0006 0.00059103965759277
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.0005 0.0005190372467041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00044608116149902
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00065493583679199
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.0005 0.00047683715820312
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.0004 0.00039005279541016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00042414665222168
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.0007479190826416
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.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 (29)
				  AND p.disabled = 0 
49 0.0005 0.0004880428314209
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0004 0.00039505958557129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00036406517028809
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00064182281494141
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0005 0.00049495697021484
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.0004 0.0003969669342041
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00042414665222168
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00074315071105957
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.0005 0.00052499771118164
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.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
59 0.0004 0.00040698051452637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00036001205444336
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00055980682373047
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0004 0.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
63 0.0003 0.00033187866210938
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.0003509521484375
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.0006718635559082
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0005 0.00046896934509277
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0005 0.00046706199645996
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.0004 0.00041723251342773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00039005279541016
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.0004570484161377
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0032 0.003187894821167
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0017 0.0017309188842773
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00053501129150391
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.0017 0.0016500949859619
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0014 0.0013728141784668
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0011 0.0010511875152588
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.8320 0.83199715614319
SELECT * FROM ipgeocountries WHERE INET_ATON('18.225.235.148') >= INET_ATON(ip_start) AND INET_ATON('18.225.235.148') <= INET_ATON(ip_end)
78 0.0031 0.0031318664550781
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0041 0.0040919780731201
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00066089630126953
SELECT * FROM products WHERE pagename = 'the-tea-makers-of-london-lot-de-2botes-de-the-en-etain-100g'
81 0.0005 0.00054311752319336
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1339
82 0.0008 0.00076889991760254
SELECT * FROM manufacturers WHERE id = '305'
83 0.0008 0.00077915191650391
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '305'
84 0.0021 0.0021209716796875
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '305' LIMIT 1
85 0.0025 0.0025489330291748
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
86 0.0012 0.001162052154541
SELECT * FROM productimages WHERE product_id = '1339' ORDER BY sortorder ASC
87 0.0004 0.00043201446533203
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '305'
88 0.0006 0.00060105323791504
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 
89 0.0004 0.00043296813964844
SELECT * FROM manufacturerimages WHERE manufacturer_id = '305'
90 0.0007 0.00073003768920898
SELECT category_id FROM products_categories WHERE product_id = '1339'
91 0.0005 0.00047612190246582
SELECT * FROM categories WHERE id = '26'
92 0.0059 0.0059330463409424
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.0004 0.00043010711669922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
94 0.0004 0.0003669261932373
SELECT id FROM categories WHERE parent_id = '26'
95 0.0060 0.0060110092163086
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.0007 0.00069499015808105
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.0006 0.00055217742919922
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.0006 0.00058984756469727
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
99 0.0009 0.0009310245513916
SELECT * FROM productimages WHERE product_id = '1339' ORDER BY sortorder ASC
100 0.0027 0.0026700496673584
SELECT * FROM product_image_select WHERE product_id = '1339'
101 0.0018 0.0017879009246826
SELECT * FROM productcustomimages WHERE product_id = '1339'
102 0.0014 0.0014009475708008
SELECT * FROM productfeeds WHERE product_id = '1339' ORDER BY item_date DESC
103 0.0043 0.0043230056762695
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
104 0.0047 0.0047109127044678
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
105 0.0020 0.0020499229431152
SELECT * FROM productamazoncontent WHERE product_id = '1339'
106 0.0033 0.0033340454101562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1339' AND a.name = n.originalname
107 0.0037 0.0036940574645996
SELECT * FROM productoffers WHERE product_id = '1339' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0007 0.00068306922912598
SELECT * FROM productoffers
                WHERE product_id = '1339' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0005 0.00052595138549805
SELECT * FROM productoffers
                WHERE product_id = 1339
                ORDER BY price ASC LIMIT 1
110 0.0009 0.0009300708770752
SELECT value FROM productattributes
                WHERE product_id = '1339'
                AND name = 'ListPriceAmount'
111 0.0007 0.00073409080505371
SELECT value FROM productattributes WHERE product_id = '1339' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0010 0.00098395347595215
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
113 0.0207 0.02070689201355
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
114 0.0007 0.00069117546081543
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
115 0.0006 0.00059294700622559
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
116 0.0017 0.0016729831695557
SELECT * FROM productimages WHERE product_id = '797' ORDER BY sortorder ASC
117 0.0009 0.00086402893066406
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
118 0.0007 0.00068283081054688
SELECT * FROM product_image_select WHERE product_id = '797'
119 0.0005 0.00046086311340332
SELECT * FROM productcustomimages WHERE product_id = '797'
120 0.0011 0.001121997833252
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
121 0.0049 0.0049319267272949
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
122 0.0006 0.00061607360839844
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
123 0.0027 0.0026891231536865
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '797' AND a.name = n.originalname
124 0.0006 0.00055408477783203
SELECT * FROM productoffers WHERE product_id = '797' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0018 0.0018000602722168
SELECT * FROM productoffers
                WHERE product_id = '797' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0004 0.0003509521484375
SELECT * FROM productoffers
                WHERE product_id = 797
                ORDER BY price ASC LIMIT 1
127 0.0004 0.00042414665222168
SELECT value FROM productattributes
                WHERE product_id = '797'
                AND name = 'ListPriceAmount'
128 0.0005 0.00048112869262695
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
129 0.0007 0.00071501731872559
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
130 0.0004 0.00040888786315918
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
131 0.0005 0.00052309036254883
SELECT value FROM productattributes WHERE product_id = '797' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0013 0.001295804977417
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
133 0.0031 0.0030639171600342
SELECT * FROM productimages WHERE product_id = '4895' ORDER BY sortorder ASC
134 0.0004 0.00043797492980957
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
135 0.0007 0.00068879127502441
SELECT * FROM product_image_select WHERE product_id = '4895'
136 0.0004 0.00039005279541016
SELECT * FROM productcustomimages WHERE product_id = '4895'
137 0.0010 0.0010290145874023
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
138 0.0009 0.00093793869018555
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
139 0.0004 0.00039291381835938
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
140 0.0019 0.0018711090087891
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4895' AND a.name = n.originalname
141 0.0004 0.00038504600524902
SELECT * FROM productoffers WHERE product_id = '4895' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0004 0.00037789344787598
SELECT * FROM productoffers
                WHERE product_id = '4895' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0004 0.0003659725189209
SELECT * FROM productoffers
                WHERE product_id = 4895
                ORDER BY price ASC LIMIT 1
144 0.0004 0.00041317939758301
SELECT value FROM productattributes
                WHERE product_id = '4895'
                AND name = 'ListPriceAmount'
145 0.0005 0.00049495697021484
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
146 0.0006 0.0006258487701416
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
147 0.0004 0.00037384033203125
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
148 0.0006 0.00056600570678711
SELECT value FROM productattributes WHERE product_id = '4895' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0007 0.0007331371307373
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
150 0.0008 0.00082683563232422
SELECT * FROM productimages WHERE product_id = '2612' ORDER BY sortorder ASC
151 0.0007 0.00065207481384277
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
152 0.0007 0.00066590309143066
SELECT * FROM product_image_select WHERE product_id = '2612'
153 0.0004 0.00039196014404297
SELECT * FROM productcustomimages WHERE product_id = '2612'
154 0.0008 0.00081586837768555
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
155 0.0030 0.0030050277709961
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
156 0.0004 0.00043392181396484
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
157 0.0020 0.0020442008972168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2612' AND a.name = n.originalname
158 0.0004 0.00036001205444336
SELECT * FROM productoffers WHERE product_id = '2612' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0003 0.00033092498779297
SELECT * FROM productoffers
                WHERE product_id = '2612' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = 2612
                ORDER BY price ASC LIMIT 1
161 0.0004 0.00044083595275879
SELECT value FROM productattributes
                WHERE product_id = '2612'
                AND name = 'ListPriceAmount'
162 0.0005 0.00046491622924805
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
163 0.0007 0.0007169246673584
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
164 0.0004 0.00041913986206055
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
165 0.0007 0.00067901611328125
SELECT value FROM productattributes WHERE product_id = '2612' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0006 0.00061798095703125
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
167 0.0014 0.00136399269104
SELECT * FROM productimages WHERE product_id = '1000' ORDER BY sortorder ASC
168 0.0007 0.00067019462585449
SELECT * FROM product_image_select WHERE product_id = '1000'
169 0.0008 0.00080204010009766
SELECT * FROM productcustomimages WHERE product_id = '1000'
170 0.0028 0.0027799606323242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1000' AND a.name = n.originalname
171 0.0007 0.00066399574279785
SELECT * FROM productoffers WHERE product_id = '1000' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0004 0.00044894218444824
SELECT * FROM productoffers
                WHERE product_id = '1000' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0006 0.00055789947509766
SELECT value FROM productattributes WHERE product_id = '1000' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
174 0.0142 0.014173984527588
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
175 0.0008 0.00075387954711914
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
176 0.0006 0.0006108283996582
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
177 0.0057 0.0057289600372314
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
178 0.0005 0.00048303604125977
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
179 0.0004 0.0003819465637207
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
180 0.0124 0.012439012527466
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
181 0.0005 0.00048184394836426
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
182 0.0004 0.00042605400085449
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
183 0.0012 0.0012450218200684
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
184 0.0214 0.021390914916992
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()
185 0.0007 0.0007171630859375
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()
186 0.0006 0.00063586235046387
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()
187 0.0017 0.0016689300537109
SELECT * FROM productimages WHERE product_id = '2213' ORDER BY sortorder ASC
188 0.0008 0.00075101852416992
SELECT * FROM product_image_select WHERE product_id = '2213'
189 0.0005 0.00048494338989258
SELECT * FROM productcustomimages WHERE product_id = '2213'
190 0.0022 0.0022010803222656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2213' AND a.name = n.originalname
191 0.0005 0.00052809715270996
SELECT * FROM productoffers WHERE product_id = '2213' AND merchantid = 'A1X6FK5RDHNB96'
192 0.0004 0.00039005279541016
SELECT * FROM productoffers
                WHERE product_id = '2213' AND price > 0
                ORDER BY price ASC LIMIT 1
193 0.0003 0.00033688545227051
SELECT * FROM productoffers
                WHERE product_id = 2213
                ORDER BY price ASC LIMIT 1
194 0.0004 0.00041294097900391
SELECT value FROM productattributes
                WHERE product_id = '2213'
                AND name = 'ListPriceAmount'
195 0.0005 0.00047993659973145
SELECT value FROM productattributes WHERE product_id = '2213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0010 0.0010170936584473
SELECT * FROM productimages WHERE product_id = '3073' ORDER BY sortorder ASC
197 0.0007 0.00069785118103027
SELECT * FROM product_image_select WHERE product_id = '3073'
198 0.0006 0.00057291984558105
SELECT * FROM productcustomimages WHERE product_id = '3073'
199 0.0020 0.0019869804382324
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3073' AND a.name = n.originalname
200 0.0004 0.00043606758117676
SELECT * FROM productoffers WHERE product_id = '3073' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0004 0.0003659725189209
SELECT * FROM productoffers
                WHERE product_id = '3073' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0003 0.00033402442932129
SELECT * FROM productoffers
                WHERE product_id = 3073
                ORDER BY price ASC LIMIT 1
203 0.0006 0.0006110668182373
SELECT value FROM productattributes
                WHERE product_id = '3073'
                AND name = 'ListPriceAmount'
204 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '3073' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0022 0.0021629333496094
SELECT id,asin FROM products WHERE parent_id = 1339
206 0.0029 0.002936840057373
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1339' ORDER BY timestamp DESC
207 0.0005 0.00050616264343262
SELECT category_id FROM products_categories WHERE product_id = '1339'
208 0.0005 0.00048089027404785
SELECT * FROM categories WHERE id = '26'
209 0.0078 0.0077919960021973
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
210 0.0006 0.00059103965759277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
211 0.0004 0.00040388107299805
SELECT id FROM categories WHERE parent_id = '26'
212 0.0077 0.0077269077301025
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 
213 0.0006 0.000640869140625
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 
214 0.0006 0.00060296058654785
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
215 0.0005 0.00047993659973145
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
216 0.0014 0.0014159679412842
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1339' AND a.name = n.originalname
217 0.0005 0.00047683715820312
SELECT * FROM productoffers WHERE product_id = '1339' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0004 0.00037884712219238
SELECT * FROM productoffers
                WHERE product_id = '1339' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0004 0.00036287307739258
SELECT * FROM productoffers
                WHERE product_id = 1339
                ORDER BY price ASC LIMIT 1
220 0.0004 0.00037813186645508
SELECT value FROM productattributes
                WHERE product_id = '1339'
                AND name = 'ListPriceAmount'
221 0.0005 0.00053095817565918
SELECT * FROM products WHERE id = '1339'
222 0.0005 0.00048279762268066
SELECT value FROM productattributes WHERE product_id = '1339' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0013 0.0012509822845459
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1339' AND a.name = n.originalname
224 0.0004 0.00035595893859863
SELECT * FROM productoffers WHERE product_id = '1339' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0003 0.00034785270690918
SELECT * FROM productoffers
                WHERE product_id = '1339' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0004 0.00035405158996582
SELECT * FROM productoffers
                WHERE product_id = 1339
                ORDER BY price ASC LIMIT 1
227 0.0004 0.00040483474731445
SELECT value FROM productattributes
                WHERE product_id = '1339'
                AND name = 'ListPriceAmount'
228 0.0005 0.00047111511230469
SELECT category_id FROM products_categories WHERE product_id = '1339' AND prod_type = 'amz'
229 0.0004 0.00042915344238281
SELECT parent_id FROM categories WHERE id = '26'
230 0.0003 0.00034809112548828
SELECT * FROM categories WHERE id = '26'
231 0.0073 0.0073390007019043
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
232 0.0005 0.00049304962158203
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
233 0.0003 0.00032591819763184
SELECT id FROM categories WHERE parent_id = '26'
234 0.0070 0.0069639682769775
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 
235 0.0005 0.00053501129150391
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 
236 0.0006 0.00061202049255371
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
237 0.0005 0.00049710273742676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
238 0.0025 0.0024948120117188
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
239 0.0015 0.001533031463623
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
240 0.0003 0.00029206275939941
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
241 0.0377 0.037687063217163
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
242 0.0026 0.0025849342346191
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
243 0.0009 0.00085091590881348
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
244 0.0008 0.00082588195800781
SELECT * FROM products WHERE id = 1626
245 0.0006 0.00057601928710938
SELECT * FROM products WHERE id = 4041
246 0.0006 0.0005500316619873
SELECT * FROM products WHERE id = 4312
247 0.0005 0.00046515464782715
SELECT * FROM products WHERE id = 777
248 0.0005 0.00053000450134277
SELECT * FROM products WHERE id = 3881
249 0.0006 0.00059294700622559
SELECT * FROM products WHERE id = 4213
250 0.0005 0.00053596496582031
SELECT * FROM products WHERE id = '1626'
251 0.0006 0.0006401538848877
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
252 0.0007 0.00068902969360352
SELECT * FROM product_image_select WHERE product_id = '1626'
253 0.0005 0.00045108795166016
SELECT * FROM productcustomimages WHERE product_id = '1626'
254 0.0012 0.00124192237854
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
255 0.0006 0.00056004524230957
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
256 0.0005 0.00046491622924805
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0006 0.00056004524230957
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0006 0.00060582160949707
SELECT * FROM products WHERE id = '4041'
259 0.0005 0.00048208236694336
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
260 0.0006 0.00061607360839844
SELECT * FROM product_image_select WHERE product_id = '4041'
261 0.0004 0.00038290023803711
SELECT * FROM productcustomimages WHERE product_id = '4041'
262 0.0016 0.001629114151001
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
263 0.0005 0.00051093101501465
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
264 0.0005 0.00046205520629883
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
265 0.0006 0.00057005882263184
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0006 0.00056004524230957
SELECT * FROM products WHERE id = '4312'
267 0.0005 0.0005340576171875
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
268 0.0007 0.00073099136352539
SELECT * FROM product_image_select WHERE product_id = '4312'
269 0.0004 0.00041103363037109
SELECT * FROM productcustomimages WHERE product_id = '4312'
270 0.0018 0.0017900466918945
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
271 0.0007 0.00068998336791992
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
272 0.0005 0.00048184394836426
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
273 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274 0.0007 0.00066685676574707
SELECT * FROM products WHERE id = '777'
275 0.0006 0.00060510635375977
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
276 0.0008 0.00079798698425293
SELECT * FROM product_image_select WHERE product_id = '777'
277 0.0005 0.00048995018005371
SELECT * FROM productcustomimages WHERE product_id = '777'
278 0.0026 0.0025839805603027
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
279 0.0005 0.00050711631774902
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
280 0.0004 0.00038290023803711
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
281 0.0005 0.00051093101501465
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
282 0.0005 0.0005028247833252
SELECT * FROM products WHERE id = '3881'
283 0.0007 0.00066089630126953
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
284 0.0009 0.00085306167602539
SELECT * FROM product_image_select WHERE product_id = '3881'
285 0.0004 0.00042581558227539
SELECT * FROM productcustomimages WHERE product_id = '3881'
286 0.0028 0.0027658939361572
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
287 0.0008 0.00076508522033691
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
288 0.0006 0.0005791187286377
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
289 0.0006 0.00056290626525879
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290 0.0006 0.00059199333190918
SELECT * FROM products WHERE id = '4213'
291 0.0005 0.00053882598876953
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
292 0.0007 0.00070595741271973
SELECT * FROM product_image_select WHERE product_id = '4213'
293 0.0005 0.0004580020904541
SELECT * FROM productcustomimages WHERE product_id = '4213'
294 0.0018 0.0017580986022949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
295 0.0013 0.0012581348419189
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
296 0.0006 0.00064611434936523
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
297 0.0008 0.00080204010009766
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298 0.0074 0.0073628425598145
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
299 0.0008 0.00080513954162598
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
300 0.0039 0.0038931369781494
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
301 0.0027 0.0026860237121582
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
302 0.0006 0.00059700012207031
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
303 0.0007 0.00069499015808105
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'