0

Premier Housewares émail Boîte à thé, Purple _ parent

Price: €11,01
Product prices and availability are accurate as of 2022-06-23 20:17:34 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
Availability: In Stock
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

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

Wait! We have a something for you...

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

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

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.3363440036774 376 1.8901 0


No Amazon API Requests Made.


App Debug - Total Time 2.3363440036774 seconds

Number Time From Start Name Description
1 0.39633703231812 Initialise Initialise FSB Function
2 0.40127992630005 App Controller Start Start of the App controller (called before the controller of every page)
3 0.44631409645081 Start of getCategoryListByGroup Function Before first category groups query
4 0.44750308990479 After initial query Before first category groups query
5 0.4475040435791 Get Category List for Group Before the call to getCategoryList function
6 0.44750499725342 Start of GetCategoryList function Start of the function
7 0.44750690460205 Before getting categories Query to get specific category list
8 0.44885993003845 After getting categories Query to get specific category list
9 0.44885993003845 Before getting category custom Before call to function getCategoryCustom
10 0.46773505210876 After getting category custom After call to function getCategoryCustom
11 0.4677369594574 Before getting category custom Before call to function getCategoryCustom
12 0.48042106628418 After getting category custom After call to function getCategoryCustom
13 0.48042297363281 Before getting category custom Before call to function getCategoryCustom
14 0.48803496360779 After getting category custom After call to function getCategoryCustom
15 0.4880359172821 Before getting category custom Before call to function getCategoryCustom
16 0.4949049949646 After getting category custom After call to function getCategoryCustom
17 0.49490594863892 Before getting category custom Before call to function getCategoryCustom
18 0.50008010864258 After getting category custom After call to function getCategoryCustom
19 0.50008106231689 Before getting category custom Before call to function getCategoryCustom
20 0.50561690330505 After getting category custom After call to function getCategoryCustom
21 0.50561904907227 End of GetCategoryList function End of the function
22 0.50562310218811 Get Category List for Group Before the call to getCategoryList function
23 0.50562500953674 Start of GetCategoryList function Start of the function
24 0.50562596321106 Before getting categories Query to get specific category list
25 0.50619697570801 End of getCategoryListByGroup Function Before return()
26 1.9514179229736 App Controller End End of the App controller (called before the controller of every page)
27 1.9519228935242 Product Start Start of the product info controller
28 1.9673891067505 Cache file not found Starting get product details
29 2.026074886322 Related products Start getting related products if enabled
30 2.0260760784149 Related Products Start Before the related products are found
31 2.0260770320892 Related Products Keywords Before the related product keywords are found
32 2.0260798931122 Create Keyword List Function Start of function
33 2.026172876358 Create Keyword List Function After looping provided content - 21 keywords found
34 2.0265510082245 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
35 2.0265560150146 Create Keyword List Function After reducing keyword list
36 2.0265810489655 Create Keyword List Function After selecting by scoring keywords
37 2.0265829563141 Create Keyword List Function After final loop of keywords
38 2.0265839099884 Related Products Keywords After the related product keywords are found
39 2.1367499828339 Related Products End After the related products are found
40 2.2114300727844 Product End End of the product info controller (Product Info)
41 2.212306022644 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.2130439281464 Before Get Options Before the call to getOptions in the tpl class
43 2.2824568748474 After Get Options After the call to getOptions in the tpl class
44 2.2825388908386 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.282557964325 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.2857089042664 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.2857110500336 Product Info: Before Template Display Before the template is displayed
48 2.3363220691681 Product Info: After Template Display After the template is displayed
49 2.3363308906555 Finalizing debug Before the debug is output to the page.
50 2.3363430500031 End of App This is the end of the app logging, final timestamp


Query Debug - 376 Database Queries. Total time 1.8901 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0016 0.001572847366333
SELECT parameter, value FROM parameters
2 0.0077 0.0077388286590576
SELECT * FROM `bad_bots`
3 0.0004 0.00042986869812012
SET time_zone = 'Europe/London'
4 0.0046 0.0045778751373291
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0035 0.0034739971160889
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.144.162.109\";}'
6 0.0028 0.0027749538421631
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746009216'
7 0.0024 0.0024449825286865
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00069189071655273
UPDATE autorun SET lastrun = '2025-04-30 10:33:36' WHERE id = '15'
9 0.0011 0.0010561943054199
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0011 0.0010890960693359
SELECT id FROM pages WHERE pagename = 'premier-housewares-email-bote-the-purple-parent' LIMIT 1
11 0.0026 0.0025520324707031
SELECT id FROM products WHERE pagename = 'premier-housewares-email-bote-the-purple-parent' AND hidden = 0 LIMIT 1
12 0.0045 0.0044770240783691
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0391 0.039129018783569
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0011 0.0011250972747803
SELECT * FROM pages WHERE pagename = 'premier-housewares-email-bote-the-purple-parent'
15 0.0012 0.0011839866638184
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0013 0.0013430118560791
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0073 0.007317066192627
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.0014 0.001384973526001
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.0006 0.00058317184448242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0006 0.00063920021057129
SELECT id FROM categories WHERE parent_id = '26'
21 0.0070 0.0069530010223389
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.0005 0.00047707557678223
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.0005 0.00052785873413086
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.00046396255493164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00047016143798828
SELECT * FROM categorygroups WHERE id = '1'
26 0.0044 0.0043771266937256
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.00060796737670898
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.00037002563476562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00042891502380371
SELECT id FROM categories WHERE parent_id = '27'
30 0.0047 0.0046651363372803
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.0005 0.00048398971557617
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.0005 0.00050210952758789
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.0007 0.00074601173400879
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00044608116149902
SELECT * FROM categorygroups WHERE id = '1'
35 0.0019 0.0019400119781494
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.00050902366638184
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.00040817260742188
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.0004570484161377
SELECT id FROM categories WHERE parent_id = '28'
39 0.0018 0.0017781257629395
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.0006 0.00057601928710938
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.0008 0.00084781646728516
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.0007 0.00065302848815918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00041699409484863
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00063276290893555
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.0020 0.0020360946655273
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.0006 0.00059795379638672
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0006 0.00055789947509766
SELECT id FROM categories WHERE parent_id = '29'
48 0.0009 0.00087499618530273
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.0007 0.00073409080505371
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.00054502487182617
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.0005 0.00046801567077637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00039386749267578
SELECT * FROM categorygroups WHERE id = '1'
53 0.0007 0.00068807601928711
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0005 0.00045680999755859
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.00042104721069336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0005 0.00046801567077637
SELECT id FROM categories WHERE parent_id = '30'
57 0.0009 0.00086188316345215
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.00051999092102051
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.0007 0.00072598457336426
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.0005 0.00052094459533691
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.0004889965057373
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00074005126953125
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0006 0.00061202049255371
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.0004 0.00043320655822754
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00045990943908691
SELECT id FROM categories WHERE parent_id = '31'
66 0.0009 0.00087785720825195
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.0007 0.00065398216247559
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0006 0.000640869140625
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.0006 0.00063419342041016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.00045895576477051
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.00056695938110352
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0019 0.0018808841705322
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0007 0.00068998336791992
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.00060582160949707
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.0006 0.0006098747253418
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0015 0.0014519691467285
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0009 0.00094890594482422
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 1.4344 1.4343781471252
SELECT * FROM ipgeocountries WHERE INET_ATON('3.144.162.109') >= INET_ATON(ip_start) AND INET_ATON('3.144.162.109') <= INET_ATON(ip_end)
79 0.0025 0.002518892288208
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0013 0.0013270378112793
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0006 0.00060510635375977
SELECT * FROM products WHERE pagename = 'premier-housewares-email-bote-the-purple-parent'
82 0.0005 0.00046706199645996
UPDATE products SET viewcount = viewcount + 1 WHERE id = 837
83 0.0006 0.00055789947509766
SELECT * FROM manufacturers WHERE id = '218'
84 0.0004 0.00043797492980957
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '218'
85 0.0018 0.0017580986022949
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '218' LIMIT 1
86 0.0022 0.0022292137145996
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '218' ORDER BY RAND() LIMIT 1
87 0.0005 0.00046777725219727
SELECT * FROM productimages WHERE product_id = '838' ORDER BY sortorder ASC
88 0.0005 0.00053596496582031
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '218'
89 0.0005 0.00048398971557617
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '218'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0005 0.00045609474182129
SELECT * FROM manufacturerimages WHERE manufacturer_id = '218'
91 0.0005 0.0004889965057373
SELECT category_id FROM products_categories WHERE product_id = '837'
92 0.0005 0.00051307678222656
SELECT * FROM categories WHERE id = '26'
93 0.0066 0.0065510272979736
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
94 0.0005 0.00045895576477051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
95 0.0003 0.00032901763916016
SELECT id FROM categories WHERE parent_id = '26'
96 0.0054 0.0053749084472656
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.0005 0.00053811073303223
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.000579833984375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
99 0.0005 0.00048494338989258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
100 0.0004 0.00044989585876465
SELECT * FROM productimages WHERE product_id = '837' ORDER BY sortorder ASC
101 0.0006 0.00057888031005859
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '837' AND p.id = pi.product_id ORDER BY pi.sortorder
102 0.0016 0.0016229152679443
SELECT * FROM product_image_select WHERE product_id = '837'
103 0.0013 0.0013039112091064
SELECT * FROM productcustomimages WHERE product_id = '837'
104 0.0011 0.0011169910430908
SELECT * FROM productfeeds WHERE product_id = '837' ORDER BY item_date DESC
105 0.0020 0.0020401477813721
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '837' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
106 0.0024 0.0023519992828369
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '837' AND t.hidden = 0 AND display_product = 1
107 0.0003 0.00031399726867676
SELECT * FROM tags WHERE id = '62'
108 0.0018 0.0017929077148438
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
109 0.0016 0.0015690326690674
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
110 0.0014 0.0014300346374512
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '62' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
111 0.0006 0.00057101249694824
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
112 0.0003 0.00031685829162598
SELECT * FROM tags WHERE id = '216'
113 0.0029 0.002924919128418
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '216'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
114 0.0031 0.0031051635742188
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '216'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
115 0.0030 0.0030350685119629
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '216' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
116 0.0004 0.00039291381835938
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
117 0.0015 0.0015320777893066
SELECT * FROM productamazoncontent WHERE product_id = '837'
118 0.0016 0.0015609264373779
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 = '837'
                GROUP BY o.product_id
119 0.0024 0.0023698806762695
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     = '837'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
120 0.0005 0.00053691864013672
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 837
121 0.0008 0.00077390670776367
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '837' AND a.name = n.originalname
122 0.0003 0.00032711029052734
SELECT * FROM productoffers WHERE product_id = '837' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0003 0.00031518936157227
SELECT * FROM productoffers
                WHERE product_id = '837' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0003 0.00034904479980469
SELECT * FROM productoffers
                WHERE product_id = 837
                ORDER BY price ASC LIMIT 1
125 0.0003 0.00032591819763184
SELECT value FROM productattributes
                WHERE product_id = '837'
                AND name = 'ListPriceAmount'
126 0.0004 0.00041103363037109
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 = '837'
                GROUP BY o.product_id
127 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     = '837'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
128 0.0004 0.00036787986755371
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 837
129 0.0005 0.00050592422485352
SELECT value FROM productattributes WHERE product_id = '837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0006 0.00058388710021973
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '837'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
131 0.0005 0.00046801567077637
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
132 0.0094 0.0094168186187744
SELECT *, MATCH (description, title) AGAINST ('premier housewares émail' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('premier housewares émail' IN BOOLEAN MODE) AND 837 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
133 0.0006 0.00061702728271484
SELECT *, MATCH (description, title) AGAINST ('premier housewares émail' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('premier housewares émail' IN BOOLEAN MODE) AND 837 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
134 0.0005 0.00048589706420898
SELECT *, MATCH (description, title) AGAINST ('premier housewares émail' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('premier housewares émail' IN BOOLEAN MODE) AND 837 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
135 0.0006 0.00055503845214844
SELECT * FROM productimages WHERE product_id = '797' ORDER BY sortorder ASC
136 0.0005 0.00046706199645996
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
137 0.0006 0.00057792663574219
SELECT * FROM product_image_select WHERE product_id = '797'
138 0.0004 0.00036501884460449
SELECT * FROM productcustomimages WHERE product_id = '797'
139 0.0005 0.00054383277893066
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
140 0.0007 0.00066685676574707
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
141 0.0004 0.00036787986755371
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
142 0.0009 0.00093507766723633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '797' AND a.name = n.originalname
143 0.0003 0.00032496452331543
SELECT * FROM productoffers WHERE product_id = '797' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0004 0.00036311149597168
SELECT * FROM productoffers
                WHERE product_id = '797' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0003 0.00029492378234863
SELECT * FROM productoffers
                WHERE product_id = 797
                ORDER BY price ASC LIMIT 1
146 0.0003 0.00033783912658691
SELECT value FROM productattributes
                WHERE product_id = '797'
                AND name = 'ListPriceAmount'
147 0.0004 0.00042319297790527
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
148 0.0006 0.0006260871887207
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
149 0.0004 0.00037813186645508
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
150 0.0005 0.0004580020904541
SELECT value FROM productattributes WHERE product_id = '797' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0006 0.0006258487701416
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
152 0.0004 0.00044608116149902
SELECT * FROM productimages WHERE product_id = '837' ORDER BY sortorder ASC
153 0.0005 0.00047397613525391
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '837' AND p.id = pi.product_id ORDER BY pi.sortorder
154 0.0005 0.00054097175598145
SELECT * FROM product_image_select WHERE product_id = '837'
155 0.0004 0.00035810470581055
SELECT * FROM productcustomimages WHERE product_id = '837'
156 0.0006 0.0005500316619873
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 = '837'
                GROUP BY o.product_id
157 0.0006 0.00062203407287598
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '837'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
158 0.0004 0.00037407875061035
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 837
159 0.0008 0.00084400177001953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '837' AND a.name = n.originalname
160 0.0003 0.00033879280090332
SELECT * FROM productoffers WHERE product_id = '837' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0003 0.00034904479980469
SELECT * FROM productoffers
                WHERE product_id = '837' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0003 0.0003199577331543
SELECT * FROM productoffers
                WHERE product_id = 837
                ORDER BY price ASC LIMIT 1
163 0.0004 0.00041007995605469
SELECT value FROM productattributes
                WHERE product_id = '837'
                AND name = 'ListPriceAmount'
164 0.0005 0.00048995018005371
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 = '837'
                GROUP BY o.product_id
165 0.0006 0.00063705444335938
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     = '837'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
166 0.0004 0.00044894218444824
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 837
167 0.0005 0.00049304962158203
SELECT value FROM productattributes WHERE product_id = '837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0006 0.00060200691223145
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '837'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
169 0.0005 0.00045490264892578
SELECT * FROM productimages WHERE product_id = '3643' ORDER BY sortorder ASC
170 0.0004 0.00040197372436523
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3643' AND p.id = pi.product_id ORDER BY pi.sortorder
171 0.0005 0.00052881240844727
SELECT * FROM product_image_select WHERE product_id = '3643'
172 0.0004 0.00035500526428223
SELECT * FROM productcustomimages WHERE product_id = '3643'
173 0.0005 0.00048017501831055
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 = '3643'
                GROUP BY o.product_id
174 0.0006 0.0005500316619873
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     = '3643'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
175 0.0004 0.00035500526428223
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3643
176 0.0008 0.00078988075256348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3643' AND a.name = n.originalname
177 0.0004 0.00036311149597168
SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0003 0.00030207633972168
SELECT * FROM productoffers
                WHERE product_id = '3643' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0003 0.00031685829162598
SELECT * FROM productoffers
                WHERE product_id = 3643
                ORDER BY price ASC LIMIT 1
180 0.0003 0.00034093856811523
SELECT value FROM productattributes
                WHERE product_id = '3643'
                AND name = 'ListPriceAmount'
181 0.0004 0.00040292739868164
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 = '3643'
                GROUP BY o.product_id
182 0.0006 0.00064206123352051
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     = '3643'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
183 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 = 3643
184 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '3643' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0006 0.00060915946960449
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3643'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
186 0.0005 0.00045204162597656
SELECT * FROM productimages WHERE product_id = '3699' ORDER BY sortorder ASC
187 0.0004 0.00039386749267578
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3699' AND p.id = pi.product_id ORDER BY pi.sortorder
188 0.0006 0.00056791305541992
SELECT * FROM product_image_select WHERE product_id = '3699'
189 0.0005 0.00048685073852539
SELECT * FROM productcustomimages WHERE product_id = '3699'
190 0.0008 0.00084900856018066
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 = '3699'
                GROUP BY o.product_id
191 0.0010 0.0010421276092529
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     = '3699'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
192 0.0005 0.00046205520629883
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3699
193 0.0008 0.00079083442687988
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3699' AND a.name = n.originalname
194 0.0004 0.0003509521484375
SELECT * FROM productoffers WHERE product_id = '3699' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0004 0.00041699409484863
SELECT * FROM productoffers
                WHERE product_id = '3699' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0004 0.00036501884460449
SELECT * FROM productoffers
                WHERE product_id = 3699
                ORDER BY price ASC LIMIT 1
197 0.0004 0.00038409233093262
SELECT value FROM productattributes
                WHERE product_id = '3699'
                AND name = 'ListPriceAmount'
198 0.0005 0.00053501129150391
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 = '3699'
                GROUP BY o.product_id
199 0.0016 0.00160813331604
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     = '3699'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
200 0.0008 0.00080609321594238
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3699
201 0.0011 0.0010712146759033
SELECT value FROM productattributes WHERE product_id = '3699' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0015 0.0015048980712891
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3699'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
203 0.0253 0.025256872177124
SELECT *, MATCH (description, title) AGAINST ('thé purple parent' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé purple parent' IN BOOLEAN MODE) AND 837 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
204 0.0010 0.0010478496551514
SELECT *, MATCH (description, title) AGAINST ('thé purple parent' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé purple parent' IN BOOLEAN MODE) AND 837 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
205 0.0007 0.00073695182800293
SELECT *, MATCH (description, title) AGAINST ('thé purple parent' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé purple parent' IN BOOLEAN MODE) AND 837 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
206 0.0005 0.00052595138549805
SELECT * FROM productimages WHERE product_id = '4498' ORDER BY sortorder ASC
207 0.0005 0.00048303604125977
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4498' AND p.id = pi.product_id ORDER BY pi.sortorder
208 0.0006 0.00062203407287598
SELECT * FROM product_image_select WHERE product_id = '4498'
209 0.0004 0.00038886070251465
SELECT * FROM productcustomimages WHERE product_id = '4498'
210 0.0005 0.00053787231445312
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 = '4498'
                GROUP BY o.product_id
211 0.0007 0.00072693824768066
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     = '4498'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
212 0.0004 0.00039410591125488
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4498
213 0.0008 0.00083398818969727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4498' AND a.name = n.originalname
214 0.0003 0.00031495094299316
SELECT * FROM productoffers WHERE product_id = '4498' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0004 0.00036001205444336
SELECT * FROM productoffers
                WHERE product_id = '4498' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0003 0.00033020973205566
SELECT * FROM productoffers
                WHERE product_id = 4498
                ORDER BY price ASC LIMIT 1
217 0.0004 0.00042891502380371
SELECT value FROM productattributes
                WHERE product_id = '4498'
                AND name = 'ListPriceAmount'
218 0.0007 0.00065708160400391
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 = '4498'
                GROUP BY o.product_id
219 0.0009 0.00094389915466309
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     = '4498'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
220 0.0005 0.00049400329589844
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4498
221 0.0006 0.00059199333190918
SELECT value FROM productattributes WHERE product_id = '4498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0006 0.00063705444335938
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4498'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
223 0.0003 0.00034117698669434
SELECT * FROM products WHERE parent_id = '4498'
224 0.0005 0.00053095817565918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4499' AND a.name = n.originalname
225 0.0005 0.00047016143798828
SELECT * FROM productoffers WHERE product_id = '4499' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0007 0.00065994262695312
SELECT * FROM productimages WHERE product_id = '4500' ORDER BY sortorder ASC
227 0.0006 0.00063800811767578
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4500' AND p.id = pi.product_id ORDER BY pi.sortorder
228 0.0007 0.00066518783569336
SELECT * FROM product_image_select WHERE product_id = '4500'
229 0.0004 0.00037407875061035
SELECT * FROM productcustomimages WHERE product_id = '4500'
230 0.0006 0.00061202049255371
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 = '4500'
                GROUP BY o.product_id
231 0.0007 0.00067615509033203
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4500'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
232 0.0005 0.00046300888061523
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4500
233 0.0009 0.00091409683227539
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4500' AND a.name = n.originalname
234 0.0004 0.00040292739868164
SELECT * FROM productoffers WHERE product_id = '4500' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0003 0.00034713745117188
SELECT * FROM productoffers
                WHERE product_id = '4500' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0003 0.00029587745666504
SELECT * FROM productoffers
                WHERE product_id = 4500
                ORDER BY price ASC LIMIT 1
237 0.0004 0.00039100646972656
SELECT value FROM productattributes
                WHERE product_id = '4500'
                AND name = 'ListPriceAmount'
238 0.0005 0.00047802925109863
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 = '4500'
                GROUP BY o.product_id
239 0.0008 0.00079512596130371
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     = '4500'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
240 0.0005 0.00048708915710449
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4500
241 0.0007 0.000701904296875
SELECT value FROM productattributes WHERE product_id = '4500' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0008 0.00083303451538086
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4500'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
243 0.0005 0.00051498413085938
SELECT * FROM productimages WHERE product_id = '4474' ORDER BY sortorder ASC
244 0.0004 0.00038886070251465
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4474' AND p.id = pi.product_id ORDER BY pi.sortorder
245 0.0005 0.00052809715270996
SELECT * FROM product_image_select WHERE product_id = '4474'
246 0.0005 0.00053310394287109
SELECT * FROM productcustomimages WHERE product_id = '4474'
247 0.0006 0.00064897537231445
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 = '4474'
                GROUP BY o.product_id
248 0.0010 0.00096702575683594
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     = '4474'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
249 0.0005 0.0005180835723877
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4474
250 0.0011 0.0010750293731689
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4474' AND a.name = n.originalname
251 0.0004 0.00039887428283691
SELECT * FROM productoffers WHERE product_id = '4474' AND merchantid = 'A1X6FK5RDHNB96'
252 0.0005 0.00053787231445312
SELECT * FROM productoffers
                WHERE product_id = '4474' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0008 0.00077605247497559
SELECT * FROM productoffers
                WHERE product_id = 4474
                ORDER BY price ASC LIMIT 1
254 0.0007 0.00072002410888672
SELECT value FROM productattributes
                WHERE product_id = '4474'
                AND name = 'ListPriceAmount'
255 0.0006 0.00064802169799805
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 = '4474'
                GROUP BY o.product_id
256 0.0012 0.0012431144714355
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     = '4474'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
257 0.0007 0.00070500373840332
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4474
258 0.0011 0.0011260509490967
SELECT value FROM productattributes WHERE product_id = '4474' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
259 0.0008 0.00076389312744141
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4474'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
260 0.0004 0.00042581558227539
SELECT * FROM products WHERE parent_id = '4474'
261 0.0010 0.00095510482788086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4697' AND a.name = n.originalname
262 0.0013 0.0012681484222412
SELECT * FROM productoffers WHERE product_id = '4697' AND merchantid = 'A1X6FK5RDHNB96'
263 0.0004 0.00042200088500977
SELECT id,asin FROM products WHERE parent_id = 837
264 0.0014 0.0013620853424072
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 838
265 0.0014 0.0013630390167236
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 838
266 0.0011 0.0011260509490967
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 839
267 0.0010 0.0010478496551514
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 839
268 0.0007 0.00073981285095215
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1680
269 0.0008 0.00084495544433594
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1680
270 0.0006 0.00064301490783691
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4473
271 0.0014 0.0013689994812012
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4473
272 0.0009 0.00094389915466309
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '837' ORDER BY timestamp DESC
273 0.0007 0.0007319450378418
SELECT category_id FROM products_categories WHERE product_id = '837'
274 0.0008 0.00082111358642578
SELECT * FROM categories WHERE id = '26'
275 0.0146 0.014556169509888
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
276 0.0006 0.00063109397888184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
277 0.0008 0.00078010559082031
SELECT id FROM categories WHERE parent_id = '26'
278 0.0097 0.0097150802612305
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 
279 0.0012 0.0011510848999023
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 
280 0.0008 0.00080609321594238
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
281 0.0007 0.00069808959960938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
282 0.0013 0.0013260841369629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '837' AND a.name = n.originalname
283 0.0008 0.00076913833618164
SELECT * FROM productoffers WHERE product_id = '837' AND merchantid = 'A1X6FK5RDHNB96'
284 0.0005 0.00054502487182617
SELECT * FROM productoffers
                WHERE product_id = '837' AND price > 0
                ORDER BY price ASC LIMIT 1
285 0.0006 0.00061392784118652
SELECT * FROM productoffers
                WHERE product_id = 837
                ORDER BY price ASC LIMIT 1
286 0.0008 0.00079703330993652
SELECT value FROM productattributes
                WHERE product_id = '837'
                AND name = 'ListPriceAmount'
287 0.0013 0.0012631416320801
SELECT * FROM products WHERE id = '837'
288 0.0011 0.001133918762207
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 = '837'
                GROUP BY o.product_id
289 0.0011 0.0010640621185303
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     = '837'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
290 0.0004 0.00040102005004883
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 837
291 0.0013 0.0012509822845459
SELECT value FROM productattributes WHERE product_id = '837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
292 0.0009 0.00091290473937988
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '837' AND a.name = n.originalname
293 0.0003 0.00034213066101074
SELECT * FROM productoffers WHERE product_id = '837' AND merchantid = 'A1X6FK5RDHNB96'
294 0.0003 0.00034499168395996
SELECT * FROM productoffers
                WHERE product_id = '837' AND price > 0
                ORDER BY price ASC LIMIT 1
295 0.0003 0.00032711029052734
SELECT * FROM productoffers
                WHERE product_id = 837
                ORDER BY price ASC LIMIT 1
296 0.0003 0.00034809112548828
SELECT value FROM productattributes
                WHERE product_id = '837'
                AND name = 'ListPriceAmount'
297 0.0005 0.00049400329589844
SELECT DISTINCT (name) FROM productoptions
298 0.0007 0.00072407722473145
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 837))
299 0.0007 0.0006711483001709
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 837
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
300 0.0023 0.0023179054260254
SELECT * FROM translationsfilter
301 0.0010 0.0010159015655518
SELECT category_id FROM products_categories WHERE product_id = '837' AND prod_type = 'amz'
302 0.0007 0.0007169246673584
SELECT parent_id FROM categories WHERE id = '26'
303 0.0009 0.00094103813171387
SELECT * FROM categories WHERE id = '26'
304 0.0079 0.0078859329223633
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
305 0.0006 0.00060105323791504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
306 0.0003 0.00034499168395996
SELECT id FROM categories WHERE parent_id = '26'
307 0.0057 0.005666971206665
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 
308 0.0006 0.00058484077453613
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 
309 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
310 0.0005 0.00045180320739746
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
311 0.0005 0.0004889965057373
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
312 0.0004 0.00037717819213867
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
313 0.0003 0.00031900405883789
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
314 0.0166 0.016622066497803
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
315 0.0006 0.00058293342590332
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
316 0.0006 0.00057101249694824
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
317 0.0005 0.00047993659973145
SELECT * FROM products WHERE id = 1626
318 0.0004 0.00035214424133301
SELECT * FROM products WHERE id = 4041
319 0.0003 0.00034523010253906
SELECT * FROM products WHERE id = 4312
320 0.0004 0.00042009353637695
SELECT * FROM products WHERE id = 777
321 0.0005 0.00051188468933105
SELECT * FROM products WHERE id = 3881
322 0.0004 0.00044608116149902
SELECT * FROM products WHERE id = 4213
323 0.0004 0.00042295455932617
SELECT * FROM products WHERE id = '1626'
324 0.0013 0.0012650489807129
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
325 0.0013 0.001331090927124
SELECT * FROM product_image_select WHERE product_id = '1626'
326 0.0008 0.00077509880065918
SELECT * FROM productcustomimages WHERE product_id = '1626'
327 0.0020 0.0019981861114502
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
328 0.0009 0.00093293190002441
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
329 0.0008 0.00083398818969727
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
330 0.0008 0.00078201293945312
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
331 0.0007 0.0007328987121582
SELECT * FROM products WHERE id = '4041'
332 0.0007 0.00065803527832031
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
333 0.0008 0.00080204010009766
SELECT * FROM product_image_select WHERE product_id = '4041'
334 0.0005 0.0005190372467041
SELECT * FROM productcustomimages WHERE product_id = '4041'
335 0.0029 0.0028700828552246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
336 0.0013 0.0013041496276855
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
337 0.0005 0.00048303604125977
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
338 0.0005 0.00050592422485352
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
339 0.0012 0.0011730194091797
SELECT * FROM products WHERE id = '4312'
340 0.0010 0.00095510482788086
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
341 0.0016 0.0016019344329834
SELECT * FROM product_image_select WHERE product_id = '4312'
342 0.0008 0.00076007843017578
SELECT * FROM productcustomimages WHERE product_id = '4312'
343 0.0032 0.0031890869140625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
344 0.0006 0.00058507919311523
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
345 0.0005 0.00047802925109863
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
346 0.0006 0.00057601928710938
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
347 0.0006 0.00057506561279297
SELECT * FROM products WHERE id = '777'
348 0.0005 0.00050592422485352
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
349 0.0007 0.00069808959960938
SELECT * FROM product_image_select WHERE product_id = '777'
350 0.0005 0.00047802925109863
SELECT * FROM productcustomimages WHERE product_id = '777'
351 0.0014 0.0013978481292725
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
352 0.0006 0.00062894821166992
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
353 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
354 0.0006 0.00055789947509766
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
355 0.0008 0.00076389312744141
SELECT * FROM products WHERE id = '3881'
356 0.0007 0.0006871223449707
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
357 0.0008 0.00075697898864746
SELECT * FROM product_image_select WHERE product_id = '3881'
358 0.0005 0.00053000450134277
SELECT * FROM productcustomimages WHERE product_id = '3881'
359 0.0018 0.0017900466918945
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
360 0.0006 0.0006110668182373
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
361 0.0005 0.00049495697021484
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
362 0.0005 0.00051689147949219
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
363 0.0006 0.00064802169799805
SELECT * FROM products WHERE id = '4213'
364 0.0006 0.00061702728271484
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
365 0.0008 0.00083494186401367
SELECT * FROM product_image_select WHERE product_id = '4213'
366 0.0005 0.000518798828125
SELECT * FROM productcustomimages WHERE product_id = '4213'
367 0.0016 0.0015530586242676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
368 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
369 0.0005 0.00047016143798828
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
370 0.0006 0.00060415267944336
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
371 0.0011 0.0010809898376465
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
372 0.0008 0.00078296661376953
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
373 0.0019 0.0018529891967773
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
374 0.0007 0.00072383880615234
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
375 0.0006 0.00055408477783203
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
376 0.0009 0.00092482566833496
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'