0
  1. My Store
  2. Tags
  3. Pour

Pour

Browse Categories

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.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.1260678768158 380 1.0829 0


No Amazon API Requests Made.


App Debug - Total Time 2.1260678768158 seconds

Number Time From Start Name Description
1 0.65722298622131 Initialise Initialise FSB Function
2 0.68325185775757 App Controller Start Start of the App controller (called before the controller of every page)
3 0.71230792999268 Start of getCategoryListByGroup Function Before first category groups query
4 0.71369194984436 After initial query Before first category groups query
5 0.71369290351868 Get Category List for Group Before the call to getCategoryList function
6 0.71369481086731 Start of GetCategoryList function Start of the function
7 0.71369791030884 Before getting categories Query to get specific category list
8 0.71433901786804 After getting categories Query to get specific category list
9 0.71433997154236 Before getting category custom Before call to function getCategoryCustom
10 0.73164081573486 After getting category custom After call to function getCategoryCustom
11 0.73164391517639 Before getting category custom Before call to function getCategoryCustom
12 0.742595911026 After getting category custom After call to function getCategoryCustom
13 0.74259901046753 Before getting category custom Before call to function getCategoryCustom
14 0.74907803535461 After getting category custom After call to function getCategoryCustom
15 0.74908089637756 Before getting category custom Before call to function getCategoryCustom
16 0.75658798217773 After getting category custom After call to function getCategoryCustom
17 0.75659084320068 Before getting category custom Before call to function getCategoryCustom
18 0.76467204093933 After getting category custom After call to function getCategoryCustom
19 0.76467490196228 Before getting category custom Before call to function getCategoryCustom
20 0.77146601676941 After getting category custom After call to function getCategoryCustom
21 0.77146887779236 End of GetCategoryList function End of the function
22 0.77147483825684 Get Category List for Group Before the call to getCategoryList function
23 0.77147698402405 Start of GetCategoryList function Start of the function
24 0.77147793769836 Before getting categories Query to get specific category list
25 0.77215695381165 End of getCategoryListByGroup Function Before return()
26 1.4784820079803 App Controller End End of the App controller (called before the controller of every page)
27 1.7024648189545 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.7044689655304 Before Get Options Before the call to getOptions in the tpl class
29 1.7585849761963 After Get Options After the call to getOptions in the tpl class
30 1.7586169242859 App_after Controller End End of the App_after controller (called after the controller of every page)
31 2.1260559558868 Finalizing debug Before the debug is output to the page.
32 2.1260669231415 End of App This is the end of the app logging, final timestamp


Query Debug - 380 Database Queries. Total time 1.0829 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.0022897720336914 
SELECT parameter, value FROM parameters
2 0.0083 0.0083470344543457 
SELECT * FROM `bad_bots`
3 0.0005 0.00053691864013672 
SET time_zone = 'Europe/London'
4 0.0034 0.0034410953521729 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0035 0.0035181045532227 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.117.155.120\";}'
6 0.0031 0.0030500888824463 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1747364434'
7 0.0038 0.0037908554077148 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00094389915466309 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0032 0.003244161605835 
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
10 0.0040 0.0040080547332764 
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
11 0.0035 0.0035099983215332 
SELECT id FROM ebay_products WHERE pagename = 'tag'
12 0.0031 0.0030689239501953 
SELECT id FROM custom_products WHERE pagename = 'tag'
13 0.0023 0.002269983291626 
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
14 0.0026 0.0026159286499023 
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
15 0.0028 0.002777099609375 
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
16 0.0029 0.0028848648071289 
SELECT id FROM tags WHERE pagename = 'pour' LIMIT 1
17 0.0029 0.0029358863830566 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
18 0.0251 0.02512001991272 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
19 0.0006 0.00063085556030273 
SELECT * FROM pages WHERE pagename = 'tag'
20 0.0014 0.0013730525970459 
SELECT * FROM categorygroups ORDER BY sortorder ASC
21 0.0006 0.0006251335144043 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
22 0.0063 0.0063090324401855 
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
23 0.0006 0.00055813789367676 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
24 0.0013 0.0013389587402344 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
25 0.0005 0.00045895576477051 
SELECT id FROM categories WHERE parent_id = '26'
26 0.0054 0.0054328441619873 
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
27 0.0005 0.00054407119750977 
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
28 0.0006 0.00058317184448242 
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
29 0.0015 0.0014879703521729 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
30 0.0005 0.00047898292541504 
SELECT * FROM categorygroups WHERE id = '1'
31 0.0037 0.0036599636077881 
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
32 0.0005 0.00051689147949219 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
33 0.0004 0.00040102005004883 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
34 0.0005 0.00049996376037598 
SELECT id FROM categories WHERE parent_id = '27'
35 0.0036 0.0036327838897705 
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
36 0.0005 0.00052690505981445 
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
37 0.0006 0.00061607360839844 
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
38 0.0006 0.00056004524230957 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
39 0.0005 0.00045394897460938 
SELECT * FROM categorygroups WHERE id = '1'
40 0.0014 0.0014429092407227 
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
41 0.0005 0.0005030632019043 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
42 0.0004 0.00040721893310547 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
43 0.0004 0.00041913986206055 
SELECT id FROM categories WHERE parent_id = '28'
44 0.0016 0.0015559196472168 
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
45 0.0006 0.00056290626525879 
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
46 0.0005 0.00053596496582031 
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
47 0.0005 0.00049495697021484 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
48 0.0005 0.00046110153198242 
SELECT * FROM categorygroups WHERE id = '1'
49 0.0006 0.00061988830566406 
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
50 0.0005 0.00052094459533691 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
51 0.0004 0.00040292739868164 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
52 0.0004 0.00041413307189941 
SELECT id FROM categories WHERE parent_id = '29'
53 0.0007 0.00069999694824219 
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
54 0.0005 0.00049805641174316 
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
55 0.0015 0.0015239715576172 
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
56 0.0018 0.0018260478973389 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
57 0.0009 0.00091695785522461 
SELECT * FROM categorygroups WHERE id = '1'
58 0.0012 0.0012350082397461 
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
59 0.0009 0.00091695785522461 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
60 0.0007 0.00074315071105957 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
61 0.0007 0.00073409080505371 
SELECT id FROM categories WHERE parent_id = '30'
62 0.0015 0.0015289783477783 
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
63 0.0008 0.00077986717224121 
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
64 0.0008 0.00076389312744141 
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
65 0.0008 0.00075101852416992 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
66 0.0005 0.0005490779876709 
SELECT * FROM categorygroups WHERE id = '1'
67 0.0010 0.0010108947753906 
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
68 0.0007 0.00070786476135254 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
69 0.0006 0.00056099891662598 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
70 0.0006 0.00063204765319824 
SELECT id FROM categories WHERE parent_id = '31'
71 0.0011 0.001082181930542 
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
72 0.0007 0.00068211555480957 
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
73 0.0007 0.00074195861816406 
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
74 0.0007 0.00065493583679199 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
75 0.0006 0.00062108039855957 
SELECT * FROM categorygroups WHERE id = '1'
76 0.0007 0.0006721019744873 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
77 0.0023 0.0023109912872314 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
78 0.0023 0.0023109912872314 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
79 0.0008 0.00083589553833008 
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
80 0.0017 0.0017030239105225 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
81 0.0016 0.0016000270843506 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
82 0.0010 0.0010039806365967 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
83 0.6913 0.69131302833557 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.117.155.120') >= INET_ATON(ip_start) AND INET_ATON('18.117.155.120') <= INET_ATON(ip_end)
84 0.0025 0.0024559497833252 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
85 0.0012 0.001194953918457 
SELECT * FROM countryredirects WHERE countrycode = 'US'
86 0.0127 0.012701034545898 
SELECT * FROM tags WHERE pagename = 'pour'
87 0.0147 0.014693021774292 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
88 0.0037 0.0036799907684326 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
89 0.0030 0.0030250549316406 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
90 0.0085 0.0084900856018066 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
91 0.0018 0.0018057823181152 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
92 0.0005 0.00054001808166504 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
93 0.0032 0.0032379627227783 
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND parent_id = 0 AND t.tag_id = '58' AND hidden = 0 AND enabled = 1  AND 1 = 1
94 0.0058 0.0057539939880371 
SELECT DISTINCT(p.id), p.*, IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank FROM products p, product_tags t WHERE p.id = t.product_id AND p.parent_id = 0 AND t.tag_id = '58' AND hidden = 0 AND enabled = 1  AND 1 = 1 ORDER BY salesrank ASC LIMIT 198, 18
95 0.0015 0.0014710426330566 
SELECT * FROM productimages WHERE product_id = '3614' ORDER BY sortorder ASC
96 0.0007 0.00069808959960938 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3614' AND p.id = pi.product_id ORDER BY pi.sortorder
97 0.0014 0.0013539791107178 
SELECT * FROM product_image_select WHERE product_id = '3614'
98 0.0012 0.0011661052703857 
SELECT * FROM productcustomimages WHERE product_id = '3614'
99 0.0021 0.0020749568939209 
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 = '3614'
                GROUP BY o.product_id
100 0.0022 0.0022149085998535 
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     = '3614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
101 0.0005 0.00048589706420898 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3614
102 0.0017 0.0016570091247559 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3614' AND a.name = n.originalname
103 0.0004 0.00043392181396484 
SELECT * FROM productoffers WHERE product_id = '3614' AND merchantid = 'A1X6FK5RDHNB96'
104 0.0004 0.00035500526428223 
SELECT * FROM productoffers
                WHERE product_id = '3614' AND price > 0
                ORDER BY price ASC LIMIT 1
105 0.0003 0.0003058910369873 
SELECT * FROM productoffers
                WHERE product_id = 3614
                ORDER BY price ASC LIMIT 1
106 0.0004 0.00037097930908203 
SELECT value FROM productattributes
                WHERE product_id = '3614'
                AND name = 'ListPriceAmount'
107 0.0006 0.00060796737670898 
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 = '3614'
                GROUP BY o.product_id
108 0.0008 0.00080513954162598 
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     = '3614'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
109 0.0006 0.0006110668182373 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3614
110 0.0005 0.00054001808166504 
SELECT value FROM productattributes WHERE product_id = '3614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0007 0.0006561279296875 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3614'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
112 0.0005 0.00049495697021484 
SELECT * FROM productimages WHERE product_id = '3622' ORDER BY sortorder ASC
113 0.0006 0.00055694580078125 
SELECT * FROM product_image_select WHERE product_id = '3622'
114 0.0004 0.00042009353637695 
SELECT * FROM productcustomimages WHERE product_id = '3622'
115 0.0010 0.0010340213775635 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3622' AND a.name = n.originalname
116 0.0004 0.00043678283691406 
SELECT * FROM productoffers WHERE product_id = '3622' AND merchantid = 'A1X6FK5RDHNB96'
117 0.0004 0.00035405158996582 
SELECT * FROM productoffers
                WHERE product_id = '3622' AND price > 0
                ORDER BY price ASC LIMIT 1
118 0.0003 0.0003359317779541 
SELECT * FROM productoffers
                WHERE product_id = 3622
                ORDER BY price ASC LIMIT 1
119 0.0004 0.00037813186645508 
SELECT value FROM productattributes
                WHERE product_id = '3622'
                AND name = 'ListPriceAmount'
120 0.0004 0.00040292739868164 
SELECT value FROM productattributes WHERE product_id = '3622' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0005 0.00047087669372559 
SELECT * FROM productimages WHERE product_id = '3666' ORDER BY sortorder ASC
122 0.0006 0.00063991546630859 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3666' AND p.id = pi.product_id ORDER BY pi.sortorder
123 0.0006 0.0005650520324707 
SELECT * FROM product_image_select WHERE product_id = '3666'
124 0.0004 0.0004119873046875 
SELECT * FROM productcustomimages WHERE product_id = '3666'
125 0.0005 0.00052714347839355 
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 = '3666'
                GROUP BY o.product_id
126 0.0006 0.00060486793518066 
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     = '3666'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
127 0.0004 0.00042986869812012 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3666
128 0.0009 0.00090408325195312 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3666' AND a.name = n.originalname
129 0.0004 0.0004279613494873 
SELECT * FROM productoffers WHERE product_id = '3666' AND merchantid = 'A1X6FK5RDHNB96'
130 0.0004 0.00039815902709961 
SELECT * FROM productoffers
                WHERE product_id = '3666' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0004 0.00037598609924316 
SELECT * FROM productoffers
                WHERE product_id = 3666
                ORDER BY price ASC LIMIT 1
132 0.0004 0.00037598609924316 
SELECT value FROM productattributes
                WHERE product_id = '3666'
                AND name = 'ListPriceAmount'
133 0.0004 0.0004270076751709 
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 = '3666'
                GROUP BY o.product_id
134 0.0007 0.0006561279296875 
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     = '3666'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
135 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 = 3666
136 0.0006 0.0005500316619873 
SELECT value FROM productattributes WHERE product_id = '3666' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0007 0.00066113471984863 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3666'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
138 0.0006 0.00055098533630371 
SELECT * FROM productimages WHERE product_id = '3738' ORDER BY sortorder ASC
139 0.0006 0.0006098747253418 
SELECT * FROM product_image_select WHERE product_id = '3738'
140 0.0005 0.0004878044128418 
SELECT * FROM productcustomimages WHERE product_id = '3738'
141 0.0011 0.0011110305786133 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3738' AND a.name = n.originalname
142 0.0005 0.00046777725219727 
SELECT * FROM productoffers WHERE product_id = '3738' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0004 0.00039196014404297 
SELECT * FROM productoffers
                WHERE product_id = '3738' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0004 0.00041294097900391 
SELECT * FROM productoffers
                WHERE product_id = 3738
                ORDER BY price ASC LIMIT 1
145 0.0005 0.00045490264892578 
SELECT value FROM productattributes
                WHERE product_id = '3738'
                AND name = 'ListPriceAmount'
146 0.0005 0.00049185752868652 
SELECT value FROM productattributes WHERE product_id = '3738' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0006 0.00058293342590332 
SELECT * FROM productimages WHERE product_id = '3739' ORDER BY sortorder ASC
148 0.0007 0.00069189071655273 
SELECT * FROM product_image_select WHERE product_id = '3739'
149 0.0005 0.00047898292541504 
SELECT * FROM productcustomimages WHERE product_id = '3739'
150 0.0008 0.00078201293945312 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3739' AND a.name = n.originalname
151 0.0006 0.00059890747070312 
SELECT * FROM productoffers WHERE product_id = '3739' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0005 0.0004880428314209 
SELECT * FROM productoffers
                WHERE product_id = '3739' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0003 0.0003199577331543 
SELECT * FROM productoffers
                WHERE product_id = 3739
                ORDER BY price ASC LIMIT 1
154 0.0004 0.00037002563476562 
SELECT value FROM productattributes
                WHERE product_id = '3739'
                AND name = 'ListPriceAmount'
155 0.0004 0.00041413307189941 
SELECT value FROM productattributes WHERE product_id = '3739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0005 0.00052499771118164 
SELECT * FROM productimages WHERE product_id = '3741' ORDER BY sortorder ASC
157 0.0007 0.00072002410888672 
SELECT * FROM product_image_select WHERE product_id = '3741'
158 0.0004 0.00044012069702148 
SELECT * FROM productcustomimages WHERE product_id = '3741'
159 0.0012 0.0011558532714844 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3741' AND a.name = n.originalname
160 0.0006 0.00055289268493652 
SELECT * FROM productoffers WHERE product_id = '3741' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0004 0.0004119873046875 
SELECT * FROM productoffers
                WHERE product_id = '3741' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0004 0.0003669261932373 
SELECT * FROM productoffers
                WHERE product_id = 3741
                ORDER BY price ASC LIMIT 1
163 0.0005 0.00050902366638184 
SELECT value FROM productattributes
                WHERE product_id = '3741'
                AND name = 'ListPriceAmount'
164 0.0005 0.00046610832214355 
SELECT value FROM productattributes WHERE product_id = '3741' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165 0.0005 0.00047612190246582 
SELECT * FROM productimages WHERE product_id = '3749' ORDER BY sortorder ASC
166 0.0008 0.00075197219848633 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3749' AND p.id = pi.product_id ORDER BY pi.sortorder
167 0.0007 0.00066113471984863 
SELECT * FROM product_image_select WHERE product_id = '3749'
168 0.0005 0.00047802925109863 
SELECT * FROM productcustomimages WHERE product_id = '3749'
169 0.0005 0.00052285194396973 
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 = '3749'
                GROUP BY o.product_id
170 0.0008 0.00075602531433105 
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     = '3749'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
171 0.0006 0.00057816505432129 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3749
172 0.0010 0.00099611282348633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3749' AND a.name = n.originalname
173 0.0004 0.0004119873046875 
SELECT * FROM productoffers WHERE product_id = '3749' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0005 0.00050497055053711 
SELECT * FROM productoffers
                WHERE product_id = '3749' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0005 0.00045180320739746 
SELECT * FROM productoffers
                WHERE product_id = 3749
                ORDER BY price ASC LIMIT 1
176 0.0004 0.00039386749267578 
SELECT value FROM productattributes
                WHERE product_id = '3749'
                AND name = 'ListPriceAmount'
177 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 = '3749'
                GROUP BY o.product_id
178 0.0008 0.00080299377441406 
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     = '3749'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
179 0.0005 0.0005488395690918 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3749
180 0.0006 0.00058794021606445 
SELECT value FROM productattributes WHERE product_id = '3749' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0008 0.00078701972961426 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3749'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
182 0.0006 0.00063395500183105 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3749'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
183 0.0006 0.00055098533630371 
SELECT * FROM productimages WHERE product_id = '3761' ORDER BY sortorder ASC
184 0.0007 0.00066184997558594 
SELECT * FROM product_image_select WHERE product_id = '3761'
185 0.0004 0.00040102005004883 
SELECT * FROM productcustomimages WHERE product_id = '3761'
186 0.0012 0.0012409687042236 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3761' AND a.name = n.originalname
187 0.0005 0.00050115585327148 
SELECT * FROM productoffers WHERE product_id = '3761' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0004 0.00038003921508789 
SELECT * FROM productoffers
                WHERE product_id = '3761' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0003 0.0003349781036377 
SELECT * FROM productoffers
                WHERE product_id = 3761
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00038599967956543 
SELECT value FROM productattributes
                WHERE product_id = '3761'
                AND name = 'ListPriceAmount'
191 0.0004 0.00043797492980957 
SELECT value FROM productattributes WHERE product_id = '3761' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0005 0.00047397613525391 
SELECT * FROM productimages WHERE product_id = '3763' ORDER BY sortorder ASC
193 0.0006 0.00060391426086426 
SELECT * FROM product_image_select WHERE product_id = '3763'
194 0.0004 0.00040507316589355 
SELECT * FROM productcustomimages WHERE product_id = '3763'
195 0.0012 0.0011708736419678 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3763' AND a.name = n.originalname
196 0.0005 0.00051999092102051 
SELECT * FROM productoffers WHERE product_id = '3763' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0004 0.0004270076751709 
SELECT * FROM productoffers
                WHERE product_id = '3763' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0004 0.00035500526428223 
SELECT * FROM productoffers
                WHERE product_id = 3763
                ORDER BY price ASC LIMIT 1
199 0.0004 0.00038599967956543 
SELECT value FROM productattributes
                WHERE product_id = '3763'
                AND name = 'ListPriceAmount'
200 0.0005 0.00046110153198242 
SELECT value FROM productattributes WHERE product_id = '3763' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0006 0.00058889389038086 
SELECT * FROM productimages WHERE product_id = '3769' ORDER BY sortorder ASC
202 0.0007 0.00068998336791992 
SELECT * FROM product_image_select WHERE product_id = '3769'
203 0.0005 0.00050616264343262 
SELECT * FROM productcustomimages WHERE product_id = '3769'
204 0.0008 0.00079894065856934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3769' AND a.name = n.originalname
205 0.0005 0.00051403045654297 
SELECT * FROM productoffers WHERE product_id = '3769' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0004 0.00040507316589355 
SELECT * FROM productoffers
                WHERE product_id = '3769' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0004 0.00038409233093262 
SELECT * FROM productoffers
                WHERE product_id = 3769
                ORDER BY price ASC LIMIT 1
208 0.0004 0.0003960132598877 
SELECT value FROM productattributes
                WHERE product_id = '3769'
                AND name = 'ListPriceAmount'
209 0.0004 0.0004270076751709 
SELECT value FROM productattributes WHERE product_id = '3769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0005 0.00050592422485352 
SELECT * FROM productimages WHERE product_id = '3820' ORDER BY sortorder ASC
211 0.0006 0.0006110668182373 
SELECT * FROM product_image_select WHERE product_id = '3820'
212 0.0004 0.00041699409484863 
SELECT * FROM productcustomimages WHERE product_id = '3820'
213 0.0009 0.00092792510986328 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3820' AND a.name = n.originalname
214 0.0005 0.00045204162597656 
SELECT * FROM productoffers WHERE product_id = '3820' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0004 0.00038790702819824 
SELECT * FROM productoffers
                WHERE product_id = '3820' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0004 0.0003819465637207 
SELECT * FROM productoffers
                WHERE product_id = 3820
                ORDER BY price ASC LIMIT 1
217 0.0004 0.00037407875061035 
SELECT value FROM productattributes
                WHERE product_id = '3820'
                AND name = 'ListPriceAmount'
218 0.0005 0.00049996376037598 
SELECT value FROM productattributes WHERE product_id = '3820' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0005 0.00051593780517578 
SELECT * FROM productimages WHERE product_id = '3880' ORDER BY sortorder ASC
220 0.0006 0.00062394142150879 
SELECT * FROM product_image_select WHERE product_id = '3880'
221 0.0004 0.00042319297790527 
SELECT * FROM productcustomimages WHERE product_id = '3880'
222 0.0012 0.0012109279632568 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3880' AND a.name = n.originalname
223 0.0005 0.00051093101501465 
SELECT * FROM productoffers WHERE product_id = '3880' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0004 0.0003960132598877 
SELECT * FROM productoffers
                WHERE product_id = '3880' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0003 0.00034785270690918 
SELECT * FROM productoffers
                WHERE product_id = 3880
                ORDER BY price ASC LIMIT 1
226 0.0004 0.00037598609924316 
SELECT value FROM productattributes
                WHERE product_id = '3880'
                AND name = 'ListPriceAmount'
227 0.0004 0.00041913986206055 
SELECT value FROM productattributes WHERE product_id = '3880' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0005 0.00052690505981445 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
229 0.0006 0.00063800811767578 
SELECT * FROM product_image_select WHERE product_id = '3881'
230 0.0004 0.00043201446533203 
SELECT * FROM productcustomimages WHERE product_id = '3881'
231 0.0010 0.00099802017211914 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
232 0.0005 0.0005040168762207 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0004 0.00040602684020996 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0006 0.00055289268493652 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0005 0.00054192543029785 
SELECT * FROM productimages WHERE product_id = '3899' ORDER BY sortorder ASC
236 0.0006 0.00063395500183105 
SELECT * FROM product_image_select WHERE product_id = '3899'
237 0.0004 0.00043416023254395 
SELECT * FROM productcustomimages WHERE product_id = '3899'
238 0.0011 0.0011379718780518 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3899' AND a.name = n.originalname
239 0.0006 0.00058984756469727 
SELECT * FROM productoffers WHERE product_id = '3899' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0005 0.00052404403686523 
SELECT * FROM productoffers
                WHERE product_id = '3899' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0004 0.00043082237243652 
SELECT * FROM productoffers
                WHERE product_id = 3899
                ORDER BY price ASC LIMIT 1
242 0.0004 0.0004429817199707 
SELECT value FROM productattributes
                WHERE product_id = '3899'
                AND name = 'ListPriceAmount'
243 0.0005 0.00048613548278809 
SELECT value FROM productattributes WHERE product_id = '3899' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0007 0.00068116188049316 
SELECT * FROM productimages WHERE product_id = '3901' ORDER BY sortorder ASC
245 0.0009 0.00088095664978027 
SELECT * FROM product_image_select WHERE product_id = '3901'
246 0.0005 0.00048303604125977 
SELECT * FROM productcustomimages WHERE product_id = '3901'
247 0.0011 0.0010979175567627 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3901' AND a.name = n.originalname
248 0.0005 0.00047111511230469 
SELECT * FROM productoffers WHERE product_id = '3901' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0004 0.00039196014404297 
SELECT * FROM productoffers
                WHERE product_id = '3901' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0003 0.00034904479980469 
SELECT * FROM productoffers
                WHERE product_id = 3901
                ORDER BY price ASC LIMIT 1
251 0.0004 0.00038003921508789 
SELECT value FROM productattributes
                WHERE product_id = '3901'
                AND name = 'ListPriceAmount'
252 0.0006 0.00061511993408203 
SELECT value FROM productattributes WHERE product_id = '3901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253 0.0006 0.00063204765319824 
SELECT * FROM productimages WHERE product_id = '3916' ORDER BY sortorder ASC
254 0.0008 0.00081992149353027 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3916' AND p.id = pi.product_id ORDER BY pi.sortorder
255 0.0007 0.00071811676025391 
SELECT * FROM product_image_select WHERE product_id = '3916'
256 0.0005 0.00047993659973145 
SELECT * FROM productcustomimages WHERE product_id = '3916'
257 0.0006 0.00055885314941406 
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 = '3916'
                GROUP BY o.product_id
258 0.0007 0.00067996978759766 
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     = '3916'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
259 0.0004 0.00043487548828125 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3916
260 0.0008 0.00083589553833008 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3916' AND a.name = n.originalname
261 0.0004 0.00041699409484863 
SELECT * FROM productoffers WHERE product_id = '3916' AND merchantid = 'A1X6FK5RDHNB96'
262 0.0005 0.00049185752868652 
SELECT * FROM productoffers
                WHERE product_id = '3916' AND price > 0
                ORDER BY price ASC LIMIT 1
263 0.0005 0.00052189826965332 
SELECT * FROM productoffers
                WHERE product_id = 3916
                ORDER BY price ASC LIMIT 1
264 0.0004 0.0003809928894043 
SELECT value FROM productattributes
                WHERE product_id = '3916'
                AND name = 'ListPriceAmount'
265 0.0005 0.00053286552429199 
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 = '3916'
                GROUP BY o.product_id
266 0.0008 0.00079917907714844 
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     = '3916'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
267 0.0006 0.00057506561279297 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3916
268 0.0007 0.00068092346191406 
SELECT value FROM productattributes WHERE product_id = '3916' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
269 0.0007 0.0006868839263916 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3916'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
270 0.0006 0.00058507919311523 
SELECT * FROM productimages WHERE product_id = '3933' ORDER BY sortorder ASC
271 0.0006 0.00057005882263184 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3933' AND p.id = pi.product_id ORDER BY pi.sortorder
272 0.0007 0.0006558895111084 
SELECT * FROM product_image_select WHERE product_id = '3933'
273 0.0004 0.00039410591125488 
SELECT * FROM productcustomimages WHERE product_id = '3933'
274 0.0006 0.00055193901062012 
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 = '3933'
                GROUP BY o.product_id
275 0.0009 0.00092506408691406 
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     = '3933'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
276 0.0005 0.00052213668823242 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3933
277 0.0014 0.0013570785522461 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3933' AND a.name = n.originalname
278 0.0005 0.00050616264343262 
SELECT * FROM productoffers WHERE product_id = '3933' AND merchantid = 'A1X6FK5RDHNB96'
279 0.0004 0.00040984153747559 
SELECT * FROM productoffers
                WHERE product_id = '3933' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0004 0.00038719177246094 
SELECT * FROM productoffers
                WHERE product_id = 3933
                ORDER BY price ASC LIMIT 1
281 0.0004 0.00043010711669922 
SELECT value FROM productattributes
                WHERE product_id = '3933'
                AND name = 'ListPriceAmount'
282 0.0004 0.00044107437133789 
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 = '3933'
                GROUP BY o.product_id
283 0.0008 0.00083494186401367 
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     = '3933'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
284 0.0005 0.00050091743469238 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3933
285 0.0006 0.00060391426086426 
SELECT value FROM productattributes WHERE product_id = '3933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
286 0.0006 0.00064587593078613 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3933'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
287 0.0007 0.0006721019744873 
SELECT * FROM productimages WHERE product_id = '3943' ORDER BY sortorder ASC
288 0.0009 0.00090909004211426 
SELECT * FROM product_image_select WHERE product_id = '3943'
289 0.0007 0.0006859302520752 
SELECT * FROM productcustomimages WHERE product_id = '3943'
290 0.0011 0.0010900497436523 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3943' AND a.name = n.originalname
291 0.0006 0.00058698654174805 
SELECT * FROM productoffers WHERE product_id = '3943' AND merchantid = 'A1X6FK5RDHNB96'
292 0.0004 0.00041913986206055 
SELECT * FROM productoffers
                WHERE product_id = '3943' AND price > 0
                ORDER BY price ASC LIMIT 1
293 0.0004 0.00040197372436523 
SELECT * FROM productoffers
                WHERE product_id = 3943
                ORDER BY price ASC LIMIT 1
294 0.0005 0.00047802925109863 
SELECT value FROM productattributes
                WHERE product_id = '3943'
                AND name = 'ListPriceAmount'
295 0.0005 0.00051093101501465 
SELECT value FROM productattributes WHERE product_id = '3943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
296 0.0017 0.0017480850219727 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3614' ORDER BY timestamp DESC
297 0.0005 0.00051498413085938 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3622' ORDER BY timestamp DESC
298 0.0004 0.0003662109375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3666' ORDER BY timestamp DESC
299 0.0004 0.00036907196044922 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3738' ORDER BY timestamp DESC
300 0.0004 0.00037598609924316 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3739' ORDER BY timestamp DESC
301 0.0005 0.00053715705871582 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3741' ORDER BY timestamp DESC
302 0.0003 0.00033998489379883 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3749' ORDER BY timestamp DESC
303 0.0005 0.0004730224609375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3761' ORDER BY timestamp DESC
304 0.0003 0.00034999847412109 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3763' ORDER BY timestamp DESC
305 0.0003 0.00029206275939941 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3769' ORDER BY timestamp DESC
306 0.0004 0.00038504600524902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3820' ORDER BY timestamp DESC
307 0.0004 0.00035881996154785 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3880' ORDER BY timestamp DESC
308 0.0004 0.00038814544677734 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3881' ORDER BY timestamp DESC
309 0.0004 0.00043606758117676 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3899' ORDER BY timestamp DESC
310 0.0003 0.00032281875610352 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3901' ORDER BY timestamp DESC
311 0.0004 0.00037503242492676 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3916' ORDER BY timestamp DESC
312 0.0003 0.00034403800964355 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3933' ORDER BY timestamp DESC
313 0.0004 0.00038409233093262 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3943' ORDER BY timestamp DESC
314 0.0018 0.001816987991333 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
315 0.0016 0.0015571117401123 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
316 0.0004 0.00038599967956543 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
317 0.0162 0.016194105148315 
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
318 0.0017 0.0016529560089111 
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
319 0.0005 0.00054407119750977 
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
320 0.0006 0.0006108283996582 
SELECT * FROM products WHERE id = 1626
321 0.0005 0.00047397613525391 
SELECT * FROM products WHERE id = 4041
322 0.0004 0.00039291381835938 
SELECT * FROM products WHERE id = 4312
323 0.0004 0.00044512748718262 
SELECT * FROM products WHERE id = 777
324 0.0004 0.00037002563476562 
SELECT * FROM products WHERE id = 3881
325 0.0003 0.00033903121948242 
SELECT * FROM products WHERE id = 4213
326 0.0003 0.00031399726867676 
SELECT * FROM products WHERE id = '1626'
327 0.0005 0.00053095817565918 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
328 0.0007 0.00065898895263672 
SELECT * FROM product_image_select WHERE product_id = '1626'
329 0.0004 0.00042414665222168 
SELECT * FROM productcustomimages WHERE product_id = '1626'
330 0.0008 0.00081300735473633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
331 0.0005 0.00050902366638184 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
332 0.0006 0.00056695938110352 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
333 0.0005 0.00053000450134277 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
334 0.0005 0.00053119659423828 
SELECT * FROM products WHERE id = '4041'
335 0.0004 0.00042390823364258 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
336 0.0006 0.00056695938110352 
SELECT * FROM product_image_select WHERE product_id = '4041'
337 0.0004 0.0003972053527832 
SELECT * FROM productcustomimages WHERE product_id = '4041'
338 0.0010 0.0010371208190918 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
339 0.0005 0.00046300888061523 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
340 0.0004 0.0003960132598877 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
341 0.0004 0.00041890144348145 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
342 0.0005 0.00051498413085938 
SELECT * FROM products WHERE id = '4312'
343 0.0004 0.00043702125549316 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
344 0.0005 0.00054812431335449 
SELECT * FROM product_image_select WHERE product_id = '4312'
345 0.0003 0.00034403800964355 
SELECT * FROM productcustomimages WHERE product_id = '4312'
346 0.0010 0.00096011161804199 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
347 0.0005 0.00045990943908691 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
348 0.0004 0.00040388107299805 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
349 0.0004 0.00039386749267578 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
350 0.0004 0.00043892860412598 
SELECT * FROM products WHERE id = '777'
351 0.0004 0.00042891502380371 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
352 0.0005 0.00052213668823242 
SELECT * FROM product_image_select WHERE product_id = '777'
353 0.0003 0.00033116340637207 
SELECT * FROM productcustomimages WHERE product_id = '777'
354 0.0009 0.00091910362243652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
355 0.0004 0.00043201446533203 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
356 0.0004 0.00036907196044922 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
357 0.0004 0.00036001205444336 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
358 0.0005 0.00045394897460938 
SELECT * FROM products WHERE id = '3881'
359 0.0005 0.00047206878662109 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
360 0.0005 0.00050616264343262 
SELECT * FROM product_image_select WHERE product_id = '3881'
361 0.0003 0.00031495094299316 
SELECT * FROM productcustomimages WHERE product_id = '3881'
362 0.0010 0.00097298622131348 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
363 0.0004 0.00041294097900391 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
364 0.0004 0.00035405158996582 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
365 0.0004 0.0003669261932373 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
366 0.0006 0.00057101249694824 
SELECT * FROM products WHERE id = '4213'
367 0.0005 0.00050115585327148 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
368 0.0006 0.00057387351989746 
SELECT * FROM product_image_select WHERE product_id = '4213'
369 0.0004 0.00037693977355957 
SELECT * FROM productcustomimages WHERE product_id = '4213'
370 0.0010 0.0010230541229248 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
371 0.0005 0.00050902366638184 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
372 0.0004 0.00036406517028809 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
373 0.0004 0.00037312507629395 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
374 0.0019 0.0018589496612549 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
375 0.0006 0.00058794021606445 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
376 0.0021 0.0021250247955322 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
377 0.0017 0.0016670227050781 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
378 0.0005 0.00045204162597656 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
379 0.0011 0.0010519027709961 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
380 0.0011 0.0010569095611572 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'