0
  1. My Store
  2. All Products

All Products

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
1.4965500831604 378 1.1259 0


No Amazon API Requests Made.


App Debug - Total Time 1.4965500831604 seconds

Number Time From Start Name Description
1 0.34813499450684 Initialise Initialise FSB Function
2 0.35095310211182 App Controller Start Start of the App controller (called before the controller of every page)
3 0.3914270401001 Start of getCategoryListByGroup Function Before first category groups query
4 0.39188504219055 After initial query Before first category groups query
5 0.39188504219055 Get Category List for Group Before the call to getCategoryList function
6 0.39188694953918 Start of GetCategoryList function Start of the function
7 0.3918890953064 Before getting categories Query to get specific category list
8 0.39247488975525 After getting categories Query to get specific category list
9 0.39247608184814 Before getting category custom Before call to function getCategoryCustom
10 0.41040587425232 After getting category custom After call to function getCategoryCustom
11 0.41040897369385 Before getting category custom Before call to function getCategoryCustom
12 0.42713403701782 After getting category custom After call to function getCategoryCustom
13 0.42713499069214 Before getting category custom Before call to function getCategoryCustom
14 0.43555498123169 After getting category custom After call to function getCategoryCustom
15 0.43555593490601 Before getting category custom Before call to function getCategoryCustom
16 0.44102907180786 After getting category custom After call to function getCategoryCustom
17 0.44102907180786 Before getting category custom Before call to function getCategoryCustom
18 0.44680309295654 After getting category custom After call to function getCategoryCustom
19 0.44680309295654 Before getting category custom Before call to function getCategoryCustom
20 0.45140290260315 After getting category custom After call to function getCategoryCustom
21 0.45140409469604 End of GetCategoryList function End of the function
22 0.45140790939331 Get Category List for Group Before the call to getCategoryList function
23 0.45140910148621 Start of GetCategoryList function Start of the function
24 0.45141005516052 Before getting categories Query to get specific category list
25 0.45193791389465 End of getCategoryListByGroup Function Before return()
26 1.2321050167084 App Controller End End of the App controller (called before the controller of every page)
27 1.4132518768311 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.4143068790436 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.4152250289917 Before Get Options Before the call to getOptions in the tpl class
30 1.4697389602661 After Get Options After the call to getOptions in the tpl class
31 1.469810962677 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.4965438842773 Finalizing debug Before the debug is output to the page.
33 1.4965500831604 End of App This is the end of the app logging, final timestamp


Query Debug - 378 Database Queries. Total time 1.1259 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0010 0.00099897384643555 
SELECT parameter, value FROM parameters
2 0.0052 0.005202054977417 
SELECT * FROM `bad_bots`
3 0.0004 0.00041985511779785 
SET time_zone = 'Europe/London'
4 0.0009 0.00093317031860352 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0009 0.00094699859619141 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.119.132.107\";}'
6 0.0008 0.0008399486541748 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746421781'
7 0.0011 0.0010840892791748 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00059294700622559 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0011 0.0011398792266846 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0006 0.00057697296142578 
SELECT * FROM pages WHERE id = 37
11 0.0033 0.003270149230957 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0365 0.036498069763184 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00048589706420898 
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0005 0.00045490264892578 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0006 0.00057601928710938 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0058 0.0057599544525146 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0006 0.00058078765869141 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0004 0.00042104721069336 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.0004279613494873 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0081 0.0081219673156738 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
21 0.0007 0.00071597099304199 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
22 0.0007 0.00071310997009277 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0006 0.00063991546630859 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.0004880428314209 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0062 0.0061850547790527 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0006 0.00063896179199219 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0005 0.00047802925109863 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00051498413085938 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0065 0.0065340995788574 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
30 0.0007 0.00068306922912598 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
31 0.0006 0.00064802169799805 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0005 0.00051617622375488 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00047588348388672 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0023 0.0022900104522705 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0006 0.00061488151550293 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.0004119873046875 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00045299530029297 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0024 0.0023868083953857 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
39 0.0006 0.00060486793518066 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
40 0.0006 0.00063586235046387 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0005 0.00053000450134277 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00047111511230469 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0008 0.00075101852416992 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0005 0.00053787231445312 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0005 0.00045680999755859 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.0005030632019043 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00081992149353027 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
48 0.0006 0.0005500316619873 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
49 0.0007 0.00067591667175293 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0007 0.00065088272094727 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00050687789916992 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00071406364440918 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0007 0.00071310997009277 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0005 0.00048613548278809 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00051283836364746 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0009 0.0009009838104248 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
57 0.0006 0.00059199333190918 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
58 0.0008 0.00076818466186523 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0006 0.0005791187286377 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00048995018005371 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00079488754272461 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0005 0.00046896934509277 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00038003921508789 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00046706199645996 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00068902969360352 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
66 0.0005 0.00050997734069824 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
67 0.0005 0.0004730224609375 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0004 0.0004270076751709 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00037407875061035 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00052499771118164 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0015 0.0015480518341064 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00059294700622559 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00052404403686523 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0004 0.00038886070251465 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0010638236999512 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00078701972961426 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7720 0.77202010154724 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.119.132.107') >= INET_ATON(ip_start) AND INET_ATON('18.119.132.107') <= INET_ATON(ip_end)
78 0.0013 0.0013179779052734 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0005 0.00050616264343262 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0009 0.00094389915466309 
SELECT * FROM pages WHERE pagename = 'all-products'
81 0.0172 0.017204999923706 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82 0.0034 0.0034310817718506 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0025 0.0024590492248535 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0091 0.0090830326080322 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85 0.0019 0.00187087059021 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0006 0.00057196617126465 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0050 0.0050299167633057 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
88 0.0054 0.0054199695587158 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0016 0.0015900135040283 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0006 0.00058507919311523 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0060 0.0060429573059082 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 972, 18
92 0.0006 0.0006260871887207 
SELECT * FROM productimages WHERE product_id = '2663' ORDER BY sortorder ASC
93 0.0004 0.00043392181396484 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2663' AND p.id = pi.product_id ORDER BY pi.sortorder
94 0.0006 0.00061702728271484 
SELECT * FROM product_image_select WHERE product_id = '2663'
95 0.0004 0.00041317939758301 
SELECT * FROM productcustomimages WHERE product_id = '2663'
96 0.0006 0.00059413909912109 
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 = '2663'
                GROUP BY o.product_id
97 0.0006 0.00064611434936523 
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     = '2663'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
98 0.0004 0.00040411949157715 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2663
99 0.0010 0.0010209083557129 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2663' AND a.name = n.originalname
100 0.0004 0.00038313865661621 
SELECT * FROM productoffers WHERE product_id = '2663' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0004 0.00038409233093262 
SELECT * FROM productoffers
                WHERE product_id = '2663' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0003 0.00032401084899902 
SELECT * FROM productoffers
                WHERE product_id = 2663
                ORDER BY price ASC LIMIT 1
103 0.0004 0.00040411949157715 
SELECT value FROM productattributes
                WHERE product_id = '2663'
                AND name = 'ListPriceAmount'
104 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 = '2663'
                GROUP BY o.product_id
105 0.0006 0.00061488151550293 
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     = '2663'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
106 0.0004 0.00039815902709961 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2663
107 0.0005 0.00054812431335449 
SELECT value FROM productattributes WHERE product_id = '2663' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
108 0.0006 0.0005791187286377 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2663'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
109 0.0004 0.0004119873046875 
SELECT * FROM products WHERE parent_id = '2663'
110 0.0007 0.00066518783569336 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4887' AND a.name = n.originalname
111 0.0005 0.00046992301940918 
SELECT * FROM productoffers WHERE product_id = '4887' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0004 0.00036406517028809 
SELECT * FROM productoffers
                WHERE product_id = '4887' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0004 0.0003809928894043 
SELECT * FROM productoffers
                WHERE product_id = 4887
                ORDER BY price ASC LIMIT 1
114 0.0004 0.00044417381286621 
SELECT value FROM productattributes
                WHERE product_id = '4887'
                AND name = 'ListPriceAmount'
115 0.0007 0.00070405006408691 
SELECT * FROM productimages WHERE product_id = '2674' ORDER BY sortorder ASC
116 0.0006 0.00061702728271484 
SELECT * FROM product_image_select WHERE product_id = '2674'
117 0.0005 0.00046586990356445 
SELECT * FROM productcustomimages WHERE product_id = '2674'
118 0.0010 0.00099515914916992 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2674' AND a.name = n.originalname
119 0.0005 0.00051307678222656 
SELECT * FROM productoffers WHERE product_id = '2674' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00042200088500977 
SELECT * FROM productoffers
                WHERE product_id = '2674' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0003 0.00034713745117188 
SELECT * FROM productoffers
                WHERE product_id = 2674
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00040793418884277 
SELECT value FROM productattributes
                WHERE product_id = '2674'
                AND name = 'ListPriceAmount'
123 0.0005 0.00046014785766602 
SELECT value FROM productattributes WHERE product_id = '2674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0005 0.00047183036804199 
SELECT * FROM productimages WHERE product_id = '2688' ORDER BY sortorder ASC
125 0.0007 0.00065493583679199 
SELECT * FROM product_image_select WHERE product_id = '2688'
126 0.0005 0.0005028247833252 
SELECT * FROM productcustomimages WHERE product_id = '2688'
127 0.0014 0.0013840198516846 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2688' AND a.name = n.originalname
128 0.0006 0.00055408477783203 
SELECT * FROM productoffers WHERE product_id = '2688' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0004 0.00044608116149902 
SELECT * FROM productoffers
                WHERE product_id = '2688' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0005 0.00046992301940918 
SELECT * FROM productoffers
                WHERE product_id = 2688
                ORDER BY price ASC LIMIT 1
131 0.0005 0.00048613548278809 
SELECT value FROM productattributes
                WHERE product_id = '2688'
                AND name = 'ListPriceAmount'
132 0.0005 0.00047898292541504 
SELECT value FROM productattributes WHERE product_id = '2688' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0005 0.00054621696472168 
SELECT * FROM productimages WHERE product_id = '2690' ORDER BY sortorder ASC
134 0.0007 0.0006861686706543 
SELECT * FROM product_image_select WHERE product_id = '2690'
135 0.0005 0.00047111511230469 
SELECT * FROM productcustomimages WHERE product_id = '2690'
136 0.0010 0.00095295906066895 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2690' AND a.name = n.originalname
137 0.0006 0.00058102607727051 
SELECT * FROM productoffers WHERE product_id = '2690' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0004 0.00044393539428711 
SELECT * FROM productoffers
                WHERE product_id = '2690' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0005 0.00046992301940918 
SELECT * FROM productoffers
                WHERE product_id = 2690
                ORDER BY price ASC LIMIT 1
140 0.0005 0.00048184394836426 
SELECT value FROM productattributes
                WHERE product_id = '2690'
                AND name = 'ListPriceAmount'
141 0.0007 0.00065803527832031 
SELECT value FROM productattributes WHERE product_id = '2690' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0007 0.00068092346191406 
SELECT * FROM productimages WHERE product_id = '2694' ORDER BY sortorder ASC
143 0.0007 0.00070095062255859 
SELECT * FROM product_image_select WHERE product_id = '2694'
144 0.0006 0.00055408477783203 
SELECT * FROM productcustomimages WHERE product_id = '2694'
145 0.0009 0.00090694427490234 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2694' AND a.name = n.originalname
146 0.0006 0.00055599212646484 
SELECT * FROM productoffers WHERE product_id = '2694' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0005 0.0004570484161377 
SELECT * FROM productoffers
                WHERE product_id = '2694' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00040006637573242 
SELECT * FROM productoffers
                WHERE product_id = 2694
                ORDER BY price ASC LIMIT 1
149 0.0005 0.00046801567077637 
SELECT value FROM productattributes
                WHERE product_id = '2694'
                AND name = 'ListPriceAmount'
150 0.0005 0.00047016143798828 
SELECT value FROM productattributes WHERE product_id = '2694' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0007 0.00067996978759766 
SELECT * FROM productimages WHERE product_id = '2695' ORDER BY sortorder ASC
152 0.0007 0.00072121620178223 
SELECT * FROM product_image_select WHERE product_id = '2695'
153 0.0005 0.0004730224609375 
SELECT * FROM productcustomimages WHERE product_id = '2695'
154 0.0009 0.00094485282897949 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2695' AND a.name = n.originalname
155 0.0005 0.00054693222045898 
SELECT * FROM productoffers WHERE product_id = '2695' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0005 0.00045180320739746 
SELECT * FROM productoffers
                WHERE product_id = '2695' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0004 0.00041794776916504 
SELECT * FROM productoffers
                WHERE product_id = 2695
                ORDER BY price ASC LIMIT 1
158 0.0004 0.00042605400085449 
SELECT value FROM productattributes
                WHERE product_id = '2695'
                AND name = 'ListPriceAmount'
159 0.0005 0.00046396255493164 
SELECT value FROM productattributes WHERE product_id = '2695' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0005 0.000518798828125 
SELECT * FROM productimages WHERE product_id = '2697' ORDER BY sortorder ASC
161 0.0008 0.00075721740722656 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2697' AND p.id = pi.product_id ORDER BY pi.sortorder
162 0.0008 0.00081586837768555 
SELECT * FROM product_image_select WHERE product_id = '2697'
163 0.0005 0.00051283836364746 
SELECT * FROM productcustomimages WHERE product_id = '2697'
164 0.0007 0.00066113471984863 
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 = '2697'
                GROUP BY o.product_id
165 0.0007 0.00070309638977051 
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     = '2697'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
166 0.0004 0.00043296813964844 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2697
167 0.0009 0.00089812278747559 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2697' AND a.name = n.originalname
168 0.0005 0.00045204162597656 
SELECT * FROM productoffers WHERE product_id = '2697' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0005 0.00047922134399414 
SELECT * FROM productoffers
                WHERE product_id = '2697' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0004 0.00040197372436523 
SELECT * FROM productoffers
                WHERE product_id = 2697
                ORDER BY price ASC LIMIT 1
171 0.0004 0.00043201446533203 
SELECT value FROM productattributes
                WHERE product_id = '2697'
                AND name = 'ListPriceAmount'
172 0.0005 0.00049114227294922 
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 = '2697'
                GROUP BY o.product_id
173 0.0006 0.00063490867614746 
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     = '2697'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
174 0.0004 0.00040602684020996 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2697
175 0.0005 0.00053000450134277 
SELECT value FROM productattributes WHERE product_id = '2697' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0006 0.00063896179199219 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2697'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
177 0.0005 0.00052499771118164 
SELECT * FROM products WHERE parent_id = '2697'
178 0.0014 0.0014419555664062 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1455' AND a.name = n.originalname
179 0.0006 0.00062298774719238 
SELECT * FROM productoffers WHERE product_id = '1455' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0004 0.00043511390686035 
SELECT * FROM productoffers
                WHERE product_id = '1455' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0004 0.00039100646972656 
SELECT * FROM productoffers
                WHERE product_id = 1455
                ORDER BY price ASC LIMIT 1
182 0.0004 0.00043916702270508 
SELECT value FROM productattributes
                WHERE product_id = '1455'
                AND name = 'ListPriceAmount'
183 0.0006 0.00059008598327637 
SELECT * FROM productimages WHERE product_id = '2699' ORDER BY sortorder ASC
184 0.0007 0.00070500373840332 
SELECT * FROM product_image_select WHERE product_id = '2699'
185 0.0005 0.00046992301940918 
SELECT * FROM productcustomimages WHERE product_id = '2699'
186 0.0010 0.001032829284668 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2699' AND a.name = n.originalname
187 0.0005 0.00053691864013672 
SELECT * FROM productoffers WHERE product_id = '2699' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0004 0.00041913986206055 
SELECT * FROM productoffers
                WHERE product_id = '2699' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0004 0.0003960132598877 
SELECT * FROM productoffers
                WHERE product_id = 2699
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00041317939758301 
SELECT value FROM productattributes
                WHERE product_id = '2699'
                AND name = 'ListPriceAmount'
191 0.0004 0.0004270076751709 
SELECT value FROM productattributes WHERE product_id = '2699' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0005 0.00054192543029785 
SELECT * FROM productimages WHERE product_id = '2916' ORDER BY sortorder ASC
193 0.0006 0.00061392784118652 
SELECT * FROM product_image_select WHERE product_id = '2916'
194 0.0004 0.00041413307189941 
SELECT * FROM productcustomimages WHERE product_id = '2916'
195 0.0016 0.0015511512756348 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2916' AND a.name = n.originalname
196 0.0007 0.00068998336791992 
SELECT * FROM productoffers WHERE product_id = '2916' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0006 0.0006101131439209 
SELECT * FROM productoffers
                WHERE product_id = '2916' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0005 0.0004730224609375 
SELECT * FROM productoffers
                WHERE product_id = 2916
                ORDER BY price ASC LIMIT 1
199 0.0004 0.00041699409484863 
SELECT value FROM productattributes
                WHERE product_id = '2916'
                AND name = 'ListPriceAmount'
200 0.0004 0.00043511390686035 
SELECT value FROM productattributes WHERE product_id = '2916' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0005 0.00052785873413086 
SELECT * FROM productimages WHERE product_id = '2708' ORDER BY sortorder ASC
202 0.0006 0.00057888031005859 
SELECT * FROM product_image_select WHERE product_id = '2708'
203 0.0005 0.00046920776367188 
SELECT * FROM productcustomimages WHERE product_id = '2708'
204 0.0019 0.0019071102142334 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2708' AND a.name = n.originalname
205 0.0006 0.00063300132751465 
SELECT * FROM productoffers WHERE product_id = '2708' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0006 0.00058698654174805 
SELECT * FROM productoffers
                WHERE product_id = '2708' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0006 0.00063705444335938 
SELECT * FROM productoffers
                WHERE product_id = 2708
                ORDER BY price ASC LIMIT 1
208 0.0005 0.00051283836364746 
SELECT value FROM productattributes
                WHERE product_id = '2708'
                AND name = 'ListPriceAmount'
209 0.0004 0.00043606758117676 
SELECT value FROM productattributes WHERE product_id = '2708' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0005 0.00053310394287109 
SELECT * FROM productimages WHERE product_id = '2709' ORDER BY sortorder ASC
211 0.0007 0.0006568431854248 
SELECT * FROM product_image_select WHERE product_id = '2709'
212 0.0004 0.0004417896270752 
SELECT * FROM productcustomimages WHERE product_id = '2709'
213 0.0008 0.00078606605529785 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2709' AND a.name = n.originalname
214 0.0005 0.00048398971557617 
SELECT * FROM productoffers WHERE product_id = '2709' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0004 0.0003809928894043 
SELECT * FROM productoffers
                WHERE product_id = '2709' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0004 0.00040698051452637 
SELECT * FROM productoffers
                WHERE product_id = 2709
                ORDER BY price ASC LIMIT 1
217 0.0005 0.00050091743469238 
SELECT value FROM productattributes
                WHERE product_id = '2709'
                AND name = 'ListPriceAmount'
218 0.0004 0.0004420280456543 
SELECT value FROM productattributes WHERE product_id = '2709' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0006 0.00058698654174805 
SELECT * FROM productimages WHERE product_id = '2711' ORDER BY sortorder ASC
220 0.0007 0.00072288513183594 
SELECT * FROM product_image_select WHERE product_id = '2711'
221 0.0005 0.00054693222045898 
SELECT * FROM productcustomimages WHERE product_id = '2711'
222 0.0010 0.0010480880737305 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2711' AND a.name = n.originalname
223 0.0006 0.00058984756469727 
SELECT * FROM productoffers WHERE product_id = '2711' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0004 0.00043392181396484 
SELECT * FROM productoffers
                WHERE product_id = '2711' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0004 0.00037598609924316 
SELECT * FROM productoffers
                WHERE product_id = 2711
                ORDER BY price ASC LIMIT 1
226 0.0005 0.00048494338989258 
SELECT value FROM productattributes
                WHERE product_id = '2711'
                AND name = 'ListPriceAmount'
227 0.0005 0.00045895576477051 
SELECT value FROM productattributes WHERE product_id = '2711' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0005 0.00052905082702637 
SELECT * FROM productimages WHERE product_id = '2710' ORDER BY sortorder ASC
229 0.0007 0.0006868839263916 
SELECT * FROM product_image_select WHERE product_id = '2710'
230 0.0004 0.00039815902709961 
SELECT * FROM productcustomimages WHERE product_id = '2710'
231 0.0008 0.00083279609680176 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2710' AND a.name = n.originalname
232 0.0005 0.0005180835723877 
SELECT * FROM productoffers WHERE product_id = '2710' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0004 0.00036501884460449 
SELECT * FROM productoffers
                WHERE product_id = '2710' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0003 0.00032615661621094 
SELECT * FROM productoffers
                WHERE product_id = 2710
                ORDER BY price ASC LIMIT 1
235 0.0004 0.00036406517028809 
SELECT value FROM productattributes
                WHERE product_id = '2710'
                AND name = 'ListPriceAmount'
236 0.0004 0.00036001205444336 
SELECT value FROM productattributes WHERE product_id = '2710' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0005 0.00047612190246582 
SELECT * FROM productimages WHERE product_id = '2714' ORDER BY sortorder ASC
238 0.0006 0.00058698654174805 
SELECT * FROM product_image_select WHERE product_id = '2714'
239 0.0004 0.00036311149597168 
SELECT * FROM productcustomimages WHERE product_id = '2714'
240 0.0010 0.0009770393371582 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2714' AND a.name = n.originalname
241 0.0005 0.00049304962158203 
SELECT * FROM productoffers WHERE product_id = '2714' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0004 0.00037097930908203 
SELECT * FROM productoffers
                WHERE product_id = '2714' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0003 0.00031208992004395 
SELECT * FROM productoffers
                WHERE product_id = 2714
                ORDER BY price ASC LIMIT 1
244 0.0003 0.00034713745117188 
SELECT value FROM productattributes
                WHERE product_id = '2714'
                AND name = 'ListPriceAmount'
245 0.0004 0.00040197372436523 
SELECT value FROM productattributes WHERE product_id = '2714' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0005 0.0005340576171875 
SELECT * FROM productimages WHERE product_id = '2717' ORDER BY sortorder ASC
247 0.0006 0.00062918663024902 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2717' AND p.id = pi.product_id ORDER BY pi.sortorder
248 0.0006 0.00062894821166992 
SELECT * FROM product_image_select WHERE product_id = '2717'
249 0.0005 0.00047111511230469 
SELECT * FROM productcustomimages WHERE product_id = '2717'
250 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 = '2717'
                GROUP BY o.product_id
251 0.0006 0.00063991546630859 
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     = '2717'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
252 0.0004 0.00039196014404297 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2717
253 0.0009 0.00086307525634766 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2717' AND a.name = n.originalname
254 0.0005 0.00047898292541504 
SELECT * FROM productoffers WHERE product_id = '2717' AND merchantid = 'A1X6FK5RDHNB96'
255 0.0004 0.00039196014404297 
SELECT * FROM productoffers
                WHERE product_id = '2717' AND price > 0
                ORDER BY price ASC LIMIT 1
256 0.0004 0.00037121772766113 
SELECT * FROM productoffers
                WHERE product_id = 2717
                ORDER BY price ASC LIMIT 1
257 0.0004 0.0003809928894043 
SELECT value FROM productattributes
                WHERE product_id = '2717'
                AND name = 'ListPriceAmount'
258 0.0004 0.0004429817199707 
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 = '2717'
                GROUP BY o.product_id
259 0.0006 0.00060296058654785 
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     = '2717'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
260 0.0004 0.00042200088500977 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2717
261 0.0006 0.00055503845214844 
SELECT value FROM productattributes WHERE product_id = '2717' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0007 0.0006568431854248 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2717'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
263 0.0004 0.00043296813964844 
SELECT * FROM products WHERE parent_id = '2717'
264 0.0007 0.00065803527832031 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4662' AND a.name = n.originalname
265 0.0005 0.00050997734069824 
SELECT * FROM productoffers WHERE product_id = '4662' AND merchantid = 'A1X6FK5RDHNB96'
266 0.0005 0.00048995018005371 
SELECT * FROM productoffers
                WHERE product_id = '4662' AND price > 0
                ORDER BY price ASC LIMIT 1
267 0.0004 0.0004119873046875 
SELECT * FROM productoffers
                WHERE product_id = 4662
                ORDER BY price ASC LIMIT 1
268 0.0006 0.00062203407287598 
SELECT value FROM productattributes
                WHERE product_id = '4662'
                AND name = 'ListPriceAmount'
269 0.0006 0.00058603286743164 
SELECT * FROM productimages WHERE product_id = '2729' ORDER BY sortorder ASC
270 0.0008 0.00075387954711914 
SELECT * FROM product_image_select WHERE product_id = '2729'
271 0.0004 0.00044894218444824 
SELECT * FROM productcustomimages WHERE product_id = '2729'
272 0.0009 0.00093507766723633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2729' AND a.name = n.originalname
273 0.0006 0.00057482719421387 
SELECT * FROM productoffers WHERE product_id = '2729' AND merchantid = 'A1X6FK5RDHNB96'
274 0.0005 0.00045895576477051 
SELECT * FROM productoffers
                WHERE product_id = '2729' AND price > 0
                ORDER BY price ASC LIMIT 1
275 0.0004 0.00043797492980957 
SELECT * FROM productoffers
                WHERE product_id = 2729
                ORDER BY price ASC LIMIT 1
276 0.0006 0.00059413909912109 
SELECT value FROM productattributes
                WHERE product_id = '2729'
                AND name = 'ListPriceAmount'
277 0.0005 0.0005037784576416 
SELECT value FROM productattributes WHERE product_id = '2729' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
278 0.0005 0.0004730224609375 
SELECT * FROM productimages WHERE product_id = '4127' ORDER BY sortorder ASC
279 0.0007 0.00070309638977051 
SELECT * FROM product_image_select WHERE product_id = '4127'
280 0.0004 0.00042200088500977 
SELECT * FROM productcustomimages WHERE product_id = '4127'
281 0.0008 0.00078511238098145 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4127' AND a.name = n.originalname
282 0.0006 0.00057601928710938 
SELECT * FROM productoffers WHERE product_id = '4127' AND merchantid = 'A1X6FK5RDHNB96'
283 0.0004 0.00044703483581543 
SELECT * FROM productoffers
                WHERE product_id = '4127' AND price > 0
                ORDER BY price ASC LIMIT 1
284 0.0011 0.001086950302124 
SELECT value FROM productattributes WHERE product_id = '4127' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
285 0.0011 0.0010750293731689 
SELECT * FROM productimages WHERE product_id = '2983' ORDER BY sortorder ASC
286 0.0014 0.0013880729675293 
SELECT * FROM product_image_select WHERE product_id = '2983'
287 0.0008 0.00075101852416992 
SELECT * FROM productcustomimages WHERE product_id = '2983'
288 0.0023 0.0023269653320312 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2983' AND a.name = n.originalname
289 0.0009 0.00085687637329102 
SELECT * FROM productoffers WHERE product_id = '2983' AND merchantid = 'A1X6FK5RDHNB96'
290 0.0006 0.00060796737670898 
SELECT * FROM productoffers
                WHERE product_id = '2983' AND price > 0
                ORDER BY price ASC LIMIT 1
291 0.0005 0.00046205520629883 
SELECT * FROM productoffers
                WHERE product_id = 2983
                ORDER BY price ASC LIMIT 1
292 0.0006 0.00058102607727051 
SELECT value FROM productattributes
                WHERE product_id = '2983'
                AND name = 'ListPriceAmount'
293 0.0007 0.00067996978759766 
SELECT value FROM productattributes WHERE product_id = '2983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
294 0.0006 0.00061702728271484 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2663' ORDER BY timestamp DESC
295 0.0004 0.00038790702819824 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2674' ORDER BY timestamp DESC
296 0.0004 0.00036382675170898 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2688' ORDER BY timestamp DESC
297 0.0003 0.00034904479980469 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2690' ORDER BY timestamp DESC
298 0.0003 0.00034999847412109 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2694' ORDER BY timestamp DESC
299 0.0003 0.00033402442932129 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2695' ORDER BY timestamp DESC
300 0.0004 0.00041389465332031 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2697' ORDER BY timestamp DESC
301 0.0003 0.00034379959106445 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2699' ORDER BY timestamp DESC
302 0.0004 0.00042891502380371 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2916' ORDER BY timestamp DESC
303 0.0003 0.00034904479980469 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2708' ORDER BY timestamp DESC
304 0.0003 0.0002901554107666 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2709' ORDER BY timestamp DESC
305 0.0003 0.00028204917907715 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2711' ORDER BY timestamp DESC
306 0.0003 0.0002751350402832 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2710' ORDER BY timestamp DESC
307 0.0003 0.00027298927307129 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2714' ORDER BY timestamp DESC
308 0.0003 0.00029492378234863 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2717' ORDER BY timestamp DESC
309 0.0003 0.00029897689819336 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2729' ORDER BY timestamp DESC
310 0.0003 0.0002739429473877 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4127' ORDER BY timestamp DESC
311 0.0003 0.00031089782714844 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2983' ORDER BY timestamp DESC
312 0.0006 0.00059223175048828 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
313 0.0005 0.00051999092102051 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
314 0.0004 0.00036406517028809 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
315 0.0166 0.016580104827881 
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
316 0.0007 0.00069284439086914 
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
317 0.0006 0.00059103965759277 
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
318 0.0005 0.00052094459533691 
SELECT * FROM products WHERE id = 1626
319 0.0004 0.00036096572875977 
SELECT * FROM products WHERE id = 4041
320 0.0003 0.00032901763916016 
SELECT * FROM products WHERE id = 4312
321 0.0003 0.00034904479980469 
SELECT * FROM products WHERE id = 777
322 0.0003 0.00034999847412109 
SELECT * FROM products WHERE id = 3881
323 0.0004 0.00037002563476562 
SELECT * FROM products WHERE id = 4213
324 0.0004 0.00041604042053223 
SELECT * FROM products WHERE id = '1626'
325 0.0005 0.00046920776367188 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
326 0.0006 0.00055503845214844 
SELECT * FROM product_image_select WHERE product_id = '1626'
327 0.0004 0.00041484832763672 
SELECT * FROM productcustomimages WHERE product_id = '1626'
328 0.0008 0.00080394744873047 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
329 0.0005 0.00045895576477051 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
330 0.0004 0.00038290023803711 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
331 0.0004 0.00039410591125488 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
332 0.0005 0.00048398971557617 
SELECT * FROM products WHERE id = '4041'
333 0.0004 0.00044393539428711 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
334 0.0006 0.00055313110351562 
SELECT * FROM product_image_select WHERE product_id = '4041'
335 0.0004 0.00035500526428223 
SELECT * FROM productcustomimages WHERE product_id = '4041'
336 0.0011 0.0010700225830078 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
337 0.0005 0.00045490264892578 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
338 0.0004 0.00036907196044922 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
339 0.0004 0.00041794776916504 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
340 0.0006 0.0005800724029541 
SELECT * FROM products WHERE id = '4312'
341 0.0004 0.00043606758117676 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
342 0.0007 0.00065398216247559 
SELECT * FROM product_image_select WHERE product_id = '4312'
343 0.0004 0.0003960132598877 
SELECT * FROM productcustomimages WHERE product_id = '4312'
344 0.0010 0.0010199546813965 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
345 0.0005 0.00046801567077637 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
346 0.0004 0.00040197372436523 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
347 0.0004 0.00039196014404297 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
348 0.0005 0.0005190372467041 
SELECT * FROM products WHERE id = '777'
349 0.0004 0.00043511390686035 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
350 0.0006 0.00059890747070312 
SELECT * FROM product_image_select WHERE product_id = '777'
351 0.0004 0.00037598609924316 
SELECT * FROM productcustomimages WHERE product_id = '777'
352 0.0009 0.000946044921875 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
353 0.0005 0.00045299530029297 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
354 0.0006 0.00060319900512695 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
355 0.0006 0.00055599212646484 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
356 0.0008 0.00079989433288574 
SELECT * FROM products WHERE id = '3881'
357 0.0008 0.00075817108154297 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
358 0.0009 0.00089788436889648 
SELECT * FROM product_image_select WHERE product_id = '3881'
359 0.0005 0.00046515464782715 
SELECT * FROM productcustomimages WHERE product_id = '3881'
360 0.0017 0.0017170906066895 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
361 0.0006 0.00061702728271484 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
362 0.0005 0.00046706199645996 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
363 0.0005 0.00049805641174316 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
364 0.0006 0.00063991546630859 
SELECT * FROM products WHERE id = '4213'
365 0.0006 0.00060582160949707 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
366 0.0007 0.00074887275695801 
SELECT * FROM product_image_select WHERE product_id = '4213'
367 0.0004 0.0004270076751709 
SELECT * FROM productcustomimages WHERE product_id = '4213'
368 0.0014 0.0013651847839355 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
369 0.0006 0.00055098533630371 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
370 0.0004 0.00043416023254395 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
371 0.0005 0.00046205520629883 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
372 0.0010 0.00096893310546875 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
373 0.0007 0.00073814392089844 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
374 0.0017 0.0016880035400391 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
375 0.0007 0.00073909759521484 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
376 0.0006 0.00064492225646973 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
377 0.0006 0.00058794021606445 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
378 0.0005 0.00054097175598145 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'