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.7249550819397 388 1.1574 0


No Amazon API Requests Made.


App Debug - Total Time 1.7249550819397 seconds

Number Time From Start Name Description
1 0.40829110145569 Initialise Initialise FSB Function
2 0.41244697570801 App Controller Start Start of the App controller (called before the controller of every page)
3 0.45899510383606 Start of getCategoryListByGroup Function Before first category groups query
4 0.46260094642639 After initial query Before first category groups query
5 0.46260094642639 Get Category List for Group Before the call to getCategoryList function
6 0.46260404586792 Start of GetCategoryList function Start of the function
7 0.46260595321655 Before getting categories Query to get specific category list
8 0.46597194671631 After getting categories Query to get specific category list
9 0.46597290039062 Before getting category custom Before call to function getCategoryCustom
10 0.50454711914062 After getting category custom After call to function getCategoryCustom
11 0.50454902648926 Before getting category custom Before call to function getCategoryCustom
12 0.51574802398682 After getting category custom After call to function getCategoryCustom
13 0.51574897766113 Before getting category custom Before call to function getCategoryCustom
14 0.52226400375366 After getting category custom After call to function getCategoryCustom
15 0.52226495742798 Before getting category custom Before call to function getCategoryCustom
16 0.52699303627014 After getting category custom After call to function getCategoryCustom
17 0.52699494361877 Before getting category custom Before call to function getCategoryCustom
18 0.53170013427734 After getting category custom After call to function getCategoryCustom
19 0.53170108795166 Before getting category custom Before call to function getCategoryCustom
20 0.53649401664734 After getting category custom After call to function getCategoryCustom
21 0.53649497032166 End of GetCategoryList function End of the function
22 0.53650093078613 Get Category List for Group Before the call to getCategoryList function
23 0.53650307655334 Start of GetCategoryList function Start of the function
24 0.53650403022766 Before getting categories Query to get specific category list
25 0.5370020866394 End of getCategoryListByGroup Function Before return()
26 1.2965519428253 App Controller End End of the App controller (called before the controller of every page)
27 1.504646062851 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.5091519355774 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.5133650302887 Before Get Options Before the call to getOptions in the tpl class
30 1.5806589126587 After Get Options After the call to getOptions in the tpl class
31 1.5808429718018 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.7249400615692 Finalizing debug Before the debug is output to the page.
33 1.7249541282654 End of App This is the end of the app logging, final timestamp


Query Debug - 388 Database Queries. Total time 1.1574 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0017 0.0017139911651611 
SELECT parameter, value FROM parameters
2 0.0062 0.0062191486358643 
SELECT * FROM `bad_bots`
3 0.0031 0.0031089782714844 
SET time_zone = 'Europe/London'
4 0.0020 0.001978874206543 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0020 0.001964807510376 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"3.145.200.8\";}'
6 0.0022 0.0021510124206543 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746452716'
7 0.0027 0.0026650428771973 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00044703483581543 
UPDATE autorun SET lastrun = '2025-05-05 13:45:16' WHERE id = '16'
9 0.0005 0.00053310394287109 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0020 0.0020270347595215 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0011 0.0010519027709961 
SELECT * FROM pages WHERE id = 37
12 0.0046 0.004619836807251 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0360 0.036012887954712 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0055 0.0055091381072998 
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0036 0.0035960674285889 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0034 0.0033531188964844 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0174 0.017412900924683 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0025 0.0025019645690918 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0014 0.0013918876647949 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00043106079101562 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0111 0.011075019836426 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
22 0.0020 0.0020279884338379 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
23 0.0017 0.0016839504241943 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0016 0.001554012298584 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.00043678283691406 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0040 0.0040111541748047 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0005 0.00052785873413086 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.00041007995605469 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00044608116149902 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0037 0.0037209987640381 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
31 0.0006 0.00055098533630371 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
32 0.0006 0.00059103965759277 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0005 0.00049614906311035 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00040984153747559 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0015 0.0015091896057129 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0005 0.00049996376037598 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.0003969669342041 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00040817260742188 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.0016391277313232 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
40 0.0005 0.00052309036254883 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
41 0.0005 0.00049018859863281 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0006 0.00055408477783203 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00046682357788086 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.0006411075592041 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0005 0.00050687789916992 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.0004429817199707 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00047707557678223 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00073003768920898 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
49 0.0005 0.00048303604125977 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
50 0.0005 0.00054216384887695 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0005 0.00049614906311035 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00038719177246094 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00062394142150879 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0006 0.00056219100952148 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0004 0.00041294097900391 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00040698051452637 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00067615509033203 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
58 0.0005 0.00053501129150391 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
59 0.0005 0.00049114227294922 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0004 0.00042605400085449 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00054693222045898 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00068092346191406 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0005 0.00051593780517578 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0004 0.00037789344787598 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00046300888061523 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0008 0.00076889991760254 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
67 0.0005 0.00051403045654297 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
68 0.0005 0.00051498413085938 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0004 0.00044012069702148 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.00049400329589844 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00049400329589844 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0028 0.0027680397033691 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0015 0.0015010833740234 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0005 0.00053501129150391 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0011 0.0011250972747803 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0012 0.0012261867523193 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0008 0.00084900856018066 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.7466 0.7465660572052 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.200.8') >= INET_ATON(ip_start) AND INET_ATON('3.145.200.8') <= INET_ATON(ip_end)
79 0.0020 0.0019989013671875 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0014 0.0014400482177734 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0008 0.00081610679626465 
SELECT * FROM pages WHERE pagename = 'all-products'
82 0.0105 0.010525941848755 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83 0.0042 0.0042171478271484 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0030 0.0029881000518799 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0099 0.0099160671234131 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86 0.0018 0.0017819404602051 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0007 0.0007171630859375 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0071 0.0071010589599609 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
89 0.0054 0.0053660869598389 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
90 0.0016 0.0016059875488281 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
91 0.0005 0.00046992301940918 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
92 0.0055 0.0054919719696045 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 990, 18
93 0.0016 0.0015869140625 
SELECT * FROM productimages WHERE product_id = '2803' ORDER BY sortorder ASC
94 0.0016 0.0015840530395508 
SELECT * FROM product_image_select WHERE product_id = '2803'
95 0.0013 0.0012810230255127 
SELECT * FROM productcustomimages WHERE product_id = '2803'
96 0.0018 0.0018367767333984 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2803' AND a.name = n.originalname
97 0.0014 0.0014100074768066 
SELECT * FROM productoffers WHERE product_id = '2803' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0004 0.00040602684020996 
SELECT * FROM productoffers
                WHERE product_id = '2803' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0005 0.00051116943359375 
SELECT value FROM productattributes WHERE product_id = '2803' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
100 0.0005 0.00049495697021484 
SELECT * FROM productimages WHERE product_id = '2811' ORDER BY sortorder ASC
101 0.0006 0.00056219100952148 
SELECT * FROM product_image_select WHERE product_id = '2811'
102 0.0004 0.00043296813964844 
SELECT * FROM productcustomimages WHERE product_id = '2811'
103 0.0010 0.0009911060333252 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2811' AND a.name = n.originalname
104 0.0005 0.00048708915710449 
SELECT * FROM productoffers WHERE product_id = '2811' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0004 0.0004420280456543 
SELECT * FROM productoffers
                WHERE product_id = '2811' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0003 0.00032401084899902 
SELECT * FROM productoffers
                WHERE product_id = 2811
                ORDER BY price ASC LIMIT 1
107 0.0004 0.0003819465637207 
SELECT value FROM productattributes
                WHERE product_id = '2811'
                AND name = 'ListPriceAmount'
108 0.0004 0.00042414665222168 
SELECT value FROM productattributes WHERE product_id = '2811' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0005 0.00049495697021484 
SELECT * FROM productimages WHERE product_id = '2827' ORDER BY sortorder ASC
110 0.0005 0.00054597854614258 
SELECT * FROM product_image_select WHERE product_id = '2827'
111 0.0004 0.00042295455932617 
SELECT * FROM productcustomimages WHERE product_id = '2827'
112 0.0009 0.00089788436889648 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2827' AND a.name = n.originalname
113 0.0005 0.00048494338989258 
SELECT * FROM productoffers WHERE product_id = '2827' AND merchantid = 'A1X6FK5RDHNB96'
114 0.0004 0.00037693977355957 
SELECT * FROM productoffers
                WHERE product_id = '2827' AND price > 0
                ORDER BY price ASC LIMIT 1
115 0.0004 0.0003511905670166 
SELECT * FROM productoffers
                WHERE product_id = 2827
                ORDER BY price ASC LIMIT 1
116 0.0004 0.00037503242492676 
SELECT value FROM productattributes
                WHERE product_id = '2827'
                AND name = 'ListPriceAmount'
117 0.0004 0.00038886070251465 
SELECT value FROM productattributes WHERE product_id = '2827' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0005 0.00047397613525391 
SELECT * FROM productimages WHERE product_id = '2829' ORDER BY sortorder ASC
119 0.0006 0.00062108039855957 
SELECT * FROM product_image_select WHERE product_id = '2829'
120 0.0004 0.00044417381286621 
SELECT * FROM productcustomimages WHERE product_id = '2829'
121 0.0008 0.00080394744873047 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2829' AND a.name = n.originalname
122 0.0006 0.00055503845214844 
SELECT * FROM productoffers WHERE product_id = '2829' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0004 0.00041604042053223 
SELECT * FROM productoffers
                WHERE product_id = '2829' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0004 0.00037789344787598 
SELECT * FROM productoffers
                WHERE product_id = 2829
                ORDER BY price ASC LIMIT 1
125 0.0004 0.00037097930908203 
SELECT value FROM productattributes
                WHERE product_id = '2829'
                AND name = 'ListPriceAmount'
126 0.0004 0.00040698051452637 
SELECT value FROM productattributes WHERE product_id = '2829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0006 0.00058889389038086 
SELECT * FROM productimages WHERE product_id = '2830' ORDER BY sortorder ASC
128 0.0006 0.00064206123352051 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2830' AND p.id = pi.product_id ORDER BY pi.sortorder
129 0.0006 0.00058794021606445 
SELECT * FROM product_image_select WHERE product_id = '2830'
130 0.0004 0.00038790702819824 
SELECT * FROM productcustomimages WHERE product_id = '2830'
131 0.0006 0.0005650520324707 
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 = '2830'
                GROUP BY o.product_id
132 0.0027 0.0026838779449463 
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     = '2830'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
133 0.0006 0.0005648136138916 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2830
134 0.0010 0.00099587440490723 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2830' AND a.name = n.originalname
135 0.0004 0.0003960132598877 
SELECT * FROM productoffers WHERE product_id = '2830' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0004 0.00044083595275879 
SELECT * FROM productoffers
                WHERE product_id = '2830' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0004 0.00043606758117676 
SELECT * FROM productoffers
                WHERE product_id = 2830
                ORDER BY price ASC LIMIT 1
138 0.0004 0.00043821334838867 
SELECT value FROM productattributes
                WHERE product_id = '2830'
                AND name = 'ListPriceAmount'
139 0.0004 0.00043296813964844 
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 = '2830'
                GROUP BY o.product_id
140 0.0006 0.0006101131439209 
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     = '2830'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
141 0.0004 0.00038909912109375 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2830
142 0.0005 0.00048708915710449 
SELECT value FROM productattributes WHERE product_id = '2830' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0007 0.00070285797119141 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2830'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
144 0.0005 0.00050783157348633 
SELECT * FROM products WHERE parent_id = '2830'
145 0.0006 0.00058507919311523 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4770' AND a.name = n.originalname
146 0.0005 0.00047802925109863 
SELECT * FROM productoffers WHERE product_id = '4770' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0004 0.0003960132598877 
SELECT * FROM productoffers
                WHERE product_id = '4770' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0005 0.00054693222045898 
SELECT * FROM productoffers
                WHERE product_id = 4770
                ORDER BY price ASC LIMIT 1
149 0.0006 0.00057196617126465 
SELECT value FROM productattributes
                WHERE product_id = '4770'
                AND name = 'ListPriceAmount'
150 0.0007 0.00068116188049316 
SELECT * FROM productimages WHERE product_id = '2835' ORDER BY sortorder ASC
151 0.0006 0.00061392784118652 
SELECT * FROM product_image_select WHERE product_id = '2835'
152 0.0005 0.00049710273742676 
SELECT * FROM productcustomimages WHERE product_id = '2835'
153 0.0007 0.00072813034057617 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2835' AND a.name = n.originalname
154 0.0005 0.00045204162597656 
SELECT * FROM productoffers WHERE product_id = '2835' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0005 0.00049400329589844 
SELECT * FROM productoffers
                WHERE product_id = '2835' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0004 0.00041294097900391 
SELECT value FROM productattributes WHERE product_id = '2835' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0004 0.00043106079101562 
SELECT * FROM productimages WHERE product_id = '2836' ORDER BY sortorder ASC
158 0.0005 0.00051093101501465 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2836' AND p.id = pi.product_id ORDER BY pi.sortorder
159 0.0006 0.00064206123352051 
SELECT * FROM product_image_select WHERE product_id = '2836'
160 0.0004 0.00040292739868164 
SELECT * FROM productcustomimages WHERE product_id = '2836'
161 0.0005 0.00051689147949219 
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 = '2836'
                GROUP BY o.product_id
162 0.0007 0.00073504447937012 
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     = '2836'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
163 0.0005 0.00047588348388672 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2836
164 0.0010 0.0010190010070801 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2836' AND a.name = n.originalname
165 0.0004 0.00038695335388184 
SELECT * FROM productoffers WHERE product_id = '2836' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0006 0.00055503845214844 
SELECT * FROM productoffers
                WHERE product_id = '2836' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0004 0.00036311149597168 
SELECT * FROM productoffers
                WHERE product_id = 2836
                ORDER BY price ASC LIMIT 1
168 0.0004 0.00043487548828125 
SELECT value FROM productattributes
                WHERE product_id = '2836'
                AND name = 'ListPriceAmount'
169 0.0004 0.00043392181396484 
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 = '2836'
                GROUP BY o.product_id
170 0.0006 0.00062012672424316 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2836'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
171 0.0004 0.00041103363037109 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2836
172 0.0005 0.0005180835723877 
SELECT value FROM productattributes WHERE product_id = '2836' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0006 0.00064301490783691 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2836'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
174 0.0005 0.0005040168762207 
SELECT * FROM products WHERE parent_id = '2836'
175 0.0007 0.00071501731872559 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2837' AND a.name = n.originalname
176 0.0005 0.00052499771118164 
SELECT * FROM productoffers WHERE product_id = '2837' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0005 0.00046682357788086 
SELECT * FROM productoffers
                WHERE product_id = '2837' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0004 0.00035405158996582 
SELECT * FROM productoffers
                WHERE product_id = 2837
                ORDER BY price ASC LIMIT 1
179 0.0004 0.00040507316589355 
SELECT value FROM productattributes
                WHERE product_id = '2837'
                AND name = 'ListPriceAmount'
180 0.0006 0.00062799453735352 
SELECT * FROM productimages WHERE product_id = '2838' ORDER BY sortorder ASC
181 0.0007 0.00067877769470215 
SELECT * FROM product_image_select WHERE product_id = '2838'
182 0.0004 0.00041794776916504 
SELECT * FROM productcustomimages WHERE product_id = '2838'
183 0.0012 0.0011658668518066 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2838' AND a.name = n.originalname
184 0.0005 0.0004878044128418 
SELECT * FROM productoffers WHERE product_id = '2838' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0004 0.00040197372436523 
SELECT * FROM productoffers
                WHERE product_id = '2838' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0006 0.00056219100952148 
SELECT * FROM productoffers
                WHERE product_id = 2838
                ORDER BY price ASC LIMIT 1
187 0.0004 0.00043797492980957 
SELECT value FROM productattributes
                WHERE product_id = '2838'
                AND name = 'ListPriceAmount'
188 0.0006 0.00059795379638672 
SELECT value FROM productattributes WHERE product_id = '2838' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0006 0.0005650520324707 
SELECT * FROM productimages WHERE product_id = '2839' ORDER BY sortorder ASC
190 0.0008 0.00078797340393066 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2839' AND p.id = pi.product_id ORDER BY pi.sortorder
191 0.0008 0.00077199935913086 
SELECT * FROM product_image_select WHERE product_id = '2839'
192 0.0005 0.00052404403686523 
SELECT * FROM productcustomimages WHERE product_id = '2839'
193 0.0006 0.00058507919311523 
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 = '2839'
                GROUP BY o.product_id
194 0.0006 0.00064802169799805 
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     = '2839'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
195 0.0005 0.00051689147949219 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2839
196 0.0011 0.0010890960693359 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2839' AND a.name = n.originalname
197 0.0005 0.00050115585327148 
SELECT * FROM productoffers WHERE product_id = '2839' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0005 0.00048398971557617 
SELECT * FROM productoffers
                WHERE product_id = '2839' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0005 0.00045394897460938 
SELECT * FROM productoffers
                WHERE product_id = 2839
                ORDER BY price ASC LIMIT 1
200 0.0005 0.00051784515380859 
SELECT value FROM productattributes
                WHERE product_id = '2839'
                AND name = 'ListPriceAmount'
201 0.0005 0.00054597854614258 
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 = '2839'
                GROUP BY o.product_id
202 0.0008 0.00079679489135742 
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     = '2839'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
203 0.0006 0.00060391426086426 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2839
204 0.0006 0.00055789947509766 
SELECT value FROM productattributes WHERE product_id = '2839' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0005 0.00052499771118164 
SELECT * FROM products WHERE parent_id = '2839'
206 0.0012 0.0011918544769287 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3585' AND a.name = n.originalname
207 0.0005 0.00049209594726562 
SELECT * FROM productoffers WHERE product_id = '3585' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0005 0.00047898292541504 
SELECT * FROM productoffers
                WHERE product_id = '3585' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0005 0.00048303604125977 
SELECT * FROM productoffers
                WHERE product_id = 3585
                ORDER BY price ASC LIMIT 1
210 0.0005 0.00052285194396973 
SELECT value FROM productattributes
                WHERE product_id = '3585'
                AND name = 'ListPriceAmount'
211 0.0006 0.00058603286743164 
SELECT * FROM productimages WHERE product_id = '2853' ORDER BY sortorder ASC
212 0.0008 0.0008091926574707 
SELECT * FROM product_image_select WHERE product_id = '2853'
213 0.0005 0.00051403045654297 
SELECT * FROM productcustomimages WHERE product_id = '2853'
214 0.0008 0.00084900856018066 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2853' AND a.name = n.originalname
215 0.0005 0.00054001808166504 
SELECT * FROM productoffers WHERE product_id = '2853' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0004 0.00042200088500977 
SELECT * FROM productoffers
                WHERE product_id = '2853' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0004 0.00036191940307617 
SELECT * FROM productoffers
                WHERE product_id = 2853
                ORDER BY price ASC LIMIT 1
218 0.0004 0.00041103363037109 
SELECT value FROM productattributes
                WHERE product_id = '2853'
                AND name = 'ListPriceAmount'
219 0.0005 0.00045108795166016 
SELECT value FROM productattributes WHERE product_id = '2853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0005 0.00054502487182617 
SELECT * FROM productimages WHERE product_id = '2849' ORDER BY sortorder ASC
221 0.0007 0.00065779685974121 
SELECT * FROM product_image_select WHERE product_id = '2849'
222 0.0004 0.00044393539428711 
SELECT * FROM productcustomimages WHERE product_id = '2849'
223 0.0011 0.0011069774627686 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2849' AND a.name = n.originalname
224 0.0005 0.0005040168762207 
SELECT * FROM productoffers WHERE product_id = '2849' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0004 0.00043177604675293 
SELECT * FROM productoffers
                WHERE product_id = '2849' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0004 0.00041007995605469 
SELECT * FROM productoffers
                WHERE product_id = 2849
                ORDER BY price ASC LIMIT 1
227 0.0004 0.00037097930908203 
SELECT value FROM productattributes
                WHERE product_id = '2849'
                AND name = 'ListPriceAmount'
228 0.0005 0.00045990943908691 
SELECT value FROM productattributes WHERE product_id = '2849' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0005 0.00050020217895508 
SELECT * FROM productimages WHERE product_id = '2882' ORDER BY sortorder ASC
230 0.0006 0.00062084197998047 
SELECT * FROM product_image_select WHERE product_id = '2882'
231 0.0004 0.00040602684020996 
SELECT * FROM productcustomimages WHERE product_id = '2882'
232 0.0010 0.00098609924316406 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2882' AND a.name = n.originalname
233 0.0006 0.00060486793518066 
SELECT * FROM productoffers WHERE product_id = '2882' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0005 0.00051999092102051 
SELECT * FROM productoffers
                WHERE product_id = '2882' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0004 0.00037002563476562 
SELECT * FROM productoffers
                WHERE product_id = 2882
                ORDER BY price ASC LIMIT 1
236 0.0004 0.00042104721069336 
SELECT value FROM productattributes
                WHERE product_id = '2882'
                AND name = 'ListPriceAmount'
237 0.0004 0.00043296813964844 
SELECT value FROM productattributes WHERE product_id = '2882' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0005 0.00053095817565918 
SELECT * FROM productimages WHERE product_id = '2876' ORDER BY sortorder ASC
239 0.0006 0.00055694580078125 
SELECT * FROM product_image_select WHERE product_id = '2876'
240 0.0004 0.00038790702819824 
SELECT * FROM productcustomimages WHERE product_id = '2876'
241 0.0007 0.00074601173400879 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2876' AND a.name = n.originalname
242 0.0005 0.00047898292541504 
SELECT * FROM productoffers WHERE product_id = '2876' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0005 0.0004570484161377 
SELECT * FROM productoffers
                WHERE product_id = '2876' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0003 0.00034499168395996 
SELECT * FROM productoffers
                WHERE product_id = 2876
                ORDER BY price ASC LIMIT 1
245 0.0004 0.00035810470581055 
SELECT value FROM productattributes
                WHERE product_id = '2876'
                AND name = 'ListPriceAmount'
246 0.0004 0.00039911270141602 
SELECT value FROM productattributes WHERE product_id = '2876' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0005 0.00045585632324219 
SELECT * FROM productimages WHERE product_id = '2897' ORDER BY sortorder ASC
248 0.0006 0.00056099891662598 
SELECT * FROM product_image_select WHERE product_id = '2897'
249 0.0005 0.00048112869262695 
SELECT * FROM productcustomimages WHERE product_id = '2897'
250 0.0011 0.0010700225830078 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2897' AND a.name = n.originalname
251 0.0005 0.00046610832214355 
SELECT * FROM productoffers WHERE product_id = '2897' AND merchantid = 'A1X6FK5RDHNB96'
252 0.0004 0.00040602684020996 
SELECT * FROM productoffers
                WHERE product_id = '2897' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0004 0.00040102005004883 
SELECT value FROM productattributes WHERE product_id = '2897' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0005 0.00050497055053711 
SELECT * FROM productimages WHERE product_id = '2918' ORDER BY sortorder ASC
255 0.0005 0.0005340576171875 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2918' AND p.id = pi.product_id ORDER BY pi.sortorder
256 0.0006 0.0005950927734375 
SELECT * FROM product_image_select WHERE product_id = '2918'
257 0.0004 0.00038814544677734 
SELECT * FROM productcustomimages WHERE product_id = '2918'
258 0.0006 0.00056314468383789 
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 = '2918'
                GROUP BY o.product_id
259 0.0007 0.00066208839416504 
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     = '2918'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
260 0.0005 0.00047779083251953 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2918
261 0.0008 0.00080490112304688 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2918' AND a.name = n.originalname
262 0.0003 0.00032997131347656 
SELECT * FROM productoffers WHERE product_id = '2918' AND merchantid = 'A1X6FK5RDHNB96'
263 0.0004 0.00041413307189941 
SELECT * FROM productoffers
                WHERE product_id = '2918' AND price > 0
                ORDER BY price ASC LIMIT 1
264 0.0004 0.00038504600524902 
SELECT * FROM productoffers
                WHERE product_id = 2918
                ORDER BY price ASC LIMIT 1
265 0.0004 0.00040793418884277 
SELECT value FROM productattributes
                WHERE product_id = '2918'
                AND name = 'ListPriceAmount'
266 0.0004 0.00042605400085449 
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 = '2918'
                GROUP BY o.product_id
267 0.0006 0.00064992904663086 
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     = '2918'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
268 0.0004 0.00038790702819824 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2918
269 0.0006 0.00058197975158691 
SELECT value FROM productattributes WHERE product_id = '2918' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270 0.0005 0.00054121017456055 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2918'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
271 0.0004 0.00039410591125488 
SELECT * FROM products WHERE parent_id = '2918'
272 0.0005 0.00052380561828613 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3280' AND a.name = n.originalname
273 0.0005 0.00052881240844727 
SELECT * FROM productoffers WHERE product_id = '3280' AND merchantid = 'A1X6FK5RDHNB96'
274 0.0004 0.00035595893859863 
SELECT * FROM productoffers
                WHERE product_id = '3280' AND price > 0
                ORDER BY price ASC LIMIT 1
275 0.0004 0.00038290023803711 
SELECT * FROM productoffers
                WHERE product_id = 3280
                ORDER BY price ASC LIMIT 1
276 0.0004 0.00039505958557129 
SELECT value FROM productattributes
                WHERE product_id = '3280'
                AND name = 'ListPriceAmount'
277 0.0005 0.00046920776367188 
SELECT * FROM productimages WHERE product_id = '2923' ORDER BY sortorder ASC
278 0.0006 0.00057506561279297 
SELECT * FROM product_image_select WHERE product_id = '2923'
279 0.0004 0.00037598609924316 
SELECT * FROM productcustomimages WHERE product_id = '2923'
280 0.0009 0.00088405609130859 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2923' AND a.name = n.originalname
281 0.0005 0.00046896934509277 
SELECT * FROM productoffers WHERE product_id = '2923' AND merchantid = 'A1X6FK5RDHNB96'
282 0.0004 0.00036811828613281 
SELECT * FROM productoffers
                WHERE product_id = '2923' AND price > 0
                ORDER BY price ASC LIMIT 1
283 0.0003 0.00032615661621094 
SELECT * FROM productoffers
                WHERE product_id = 2923
                ORDER BY price ASC LIMIT 1
284 0.0003 0.00034904479980469 
SELECT value FROM productattributes
                WHERE product_id = '2923'
                AND name = 'ListPriceAmount'
285 0.0004 0.00035905838012695 
SELECT value FROM productattributes WHERE product_id = '2923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
286 0.0004 0.00041794776916504 
SELECT * FROM productimages WHERE product_id = '2924' ORDER BY sortorder ASC
287 0.0005 0.00050091743469238 
SELECT * FROM product_image_select WHERE product_id = '2924'
288 0.0003 0.00033092498779297 
SELECT * FROM productcustomimages WHERE product_id = '2924'
289 0.0008 0.0008080005645752 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2924' AND a.name = n.originalname
290 0.0004 0.00044918060302734 
SELECT * FROM productoffers WHERE product_id = '2924' AND merchantid = 'A1X6FK5RDHNB96'
291 0.0004 0.00035810470581055 
SELECT * FROM productoffers
                WHERE product_id = '2924' AND price > 0
                ORDER BY price ASC LIMIT 1
292 0.0003 0.00032186508178711 
SELECT * FROM productoffers
                WHERE product_id = 2924
                ORDER BY price ASC LIMIT 1
293 0.0004 0.00036311149597168 
SELECT value FROM productattributes
                WHERE product_id = '2924'
                AND name = 'ListPriceAmount'
294 0.0004 0.00036883354187012 
SELECT value FROM productattributes WHERE product_id = '2924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
295 0.0005 0.0004570484161377 
SELECT * FROM productimages WHERE product_id = '2925' ORDER BY sortorder ASC
296 0.0006 0.00059103965759277 
SELECT * FROM product_image_select WHERE product_id = '2925'
297 0.0004 0.00038909912109375 
SELECT * FROM productcustomimages WHERE product_id = '2925'
298 0.0009 0.00089406967163086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2925' AND a.name = n.originalname
299 0.0005 0.00046586990356445 
SELECT * FROM productoffers WHERE product_id = '2925' AND merchantid = 'A1X6FK5RDHNB96'
300 0.0004 0.00037384033203125 
SELECT * FROM productoffers
                WHERE product_id = '2925' AND price > 0
                ORDER BY price ASC LIMIT 1
301 0.0003 0.00033211708068848 
SELECT * FROM productoffers
                WHERE product_id = 2925
                ORDER BY price ASC LIMIT 1
302 0.0005 0.00051093101501465 
SELECT value FROM productattributes
                WHERE product_id = '2925'
                AND name = 'ListPriceAmount'
303 0.0005 0.00053000450134277 
SELECT value FROM productattributes WHERE product_id = '2925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
304 0.0015 0.0014679431915283 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2803' ORDER BY timestamp DESC
305 0.0003 0.0003359317779541 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2811' ORDER BY timestamp DESC
306 0.0003 0.00030517578125 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2827' ORDER BY timestamp DESC
307 0.0003 0.0002901554107666 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2829' ORDER BY timestamp DESC
308 0.0003 0.00031900405883789 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2830' ORDER BY timestamp DESC
309 0.0003 0.00030207633972168 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2835' ORDER BY timestamp DESC
310 0.0003 0.00027894973754883 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2836' ORDER BY timestamp DESC
311 0.0003 0.00026512145996094 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2838' ORDER BY timestamp DESC
312 0.0003 0.0002739429473877 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2839' ORDER BY timestamp DESC
313 0.0004 0.00036907196044922 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2853' ORDER BY timestamp DESC
314 0.0003 0.00028491020202637 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2849' ORDER BY timestamp DESC
315 0.0003 0.00029301643371582 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2882' ORDER BY timestamp DESC
316 0.0003 0.00027799606323242 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2876' ORDER BY timestamp DESC
317 0.0003 0.00029587745666504 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2897' ORDER BY timestamp DESC
318 0.0003 0.00032401084899902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2918' ORDER BY timestamp DESC
319 0.0004 0.00036311149597168 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2923' ORDER BY timestamp DESC
320 0.0004 0.00035595893859863 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2924' ORDER BY timestamp DESC
321 0.0003 0.00034809112548828 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2925' ORDER BY timestamp DESC
322 0.0039 0.0039248466491699 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
323 0.0035 0.0034999847412109 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
324 0.0006 0.00063896179199219 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
325 0.0245 0.024503946304321 
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
326 0.0019 0.0019478797912598 
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
327 0.0007 0.00069212913513184 
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
328 0.0006 0.00063395500183105 
SELECT * FROM products WHERE id = 1626
329 0.0004 0.00040316581726074 
SELECT * FROM products WHERE id = 4041
330 0.0004 0.00036907196044922 
SELECT * FROM products WHERE id = 4312
331 0.0004 0.0003659725189209 
SELECT * FROM products WHERE id = 777
332 0.0006 0.00058984756469727 
SELECT * FROM products WHERE id = 3881
333 0.0005 0.00047707557678223 
SELECT * FROM products WHERE id = 4213
334 0.0005 0.00049591064453125 
SELECT * FROM products WHERE id = '1626'
335 0.0005 0.00048208236694336 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
336 0.0007 0.00065183639526367 
SELECT * FROM product_image_select WHERE product_id = '1626'
337 0.0005 0.00048089027404785 
SELECT * FROM productcustomimages WHERE product_id = '1626'
338 0.0009 0.00089001655578613 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
339 0.0005 0.00049591064453125 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
340 0.0005 0.00048017501831055 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
341 0.0005 0.00050997734069824 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
342 0.0005 0.00054502487182617 
SELECT * FROM products WHERE id = '4041'
343 0.0004 0.00043296813964844 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
344 0.0006 0.00057601928710938 
SELECT * FROM product_image_select WHERE product_id = '4041'
345 0.0004 0.00043106079101562 
SELECT * FROM productcustomimages WHERE product_id = '4041'
346 0.0012 0.0011630058288574 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
347 0.0005 0.00052404403686523 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
348 0.0005 0.00045108795166016 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
349 0.0006 0.00063610076904297 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
350 0.0005 0.00053906440734863 
SELECT * FROM products WHERE id = '4312'
351 0.0005 0.00045394897460938 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
352 0.0006 0.00061488151550293 
SELECT * FROM product_image_select WHERE product_id = '4312'
353 0.0004 0.00040292739868164 
SELECT * FROM productcustomimages WHERE product_id = '4312'
354 0.0011 0.0011160373687744 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
355 0.0005 0.00053000450134277 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
356 0.0005 0.00045013427734375 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
357 0.0004 0.00042295455932617 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
358 0.0006 0.0005791187286377 
SELECT * FROM products WHERE id = '777'
359 0.0006 0.00062394142150879 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
360 0.0007 0.00069689750671387 
SELECT * FROM product_image_select WHERE product_id = '777'
361 0.0005 0.00045895576477051 
SELECT * FROM productcustomimages WHERE product_id = '777'
362 0.0011 0.0011098384857178 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
363 0.0005 0.00049209594726562 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
364 0.0004 0.00041007995605469 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
365 0.0004 0.00038790702819824 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
366 0.0005 0.00053882598876953 
SELECT * FROM products WHERE id = '3881'
367 0.0006 0.00060391426086426 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
368 0.0006 0.00064802169799805 
SELECT * FROM product_image_select WHERE product_id = '3881'
369 0.0004 0.00044512748718262 
SELECT * FROM productcustomimages WHERE product_id = '3881'
370 0.0012 0.001209020614624 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
371 0.0005 0.00050997734069824 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
372 0.0004 0.00043988227844238 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
373 0.0004 0.00043487548828125 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
374 0.0006 0.00063109397888184 
SELECT * FROM products WHERE id = '4213'
375 0.0006 0.00058388710021973 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
376 0.0006 0.00062012672424316 
SELECT * FROM product_image_select WHERE product_id = '4213'
377 0.0004 0.00039291381835938 
SELECT * FROM productcustomimages WHERE product_id = '4213'
378 0.0012 0.001237154006958 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
379 0.0005 0.00051093101501465 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
380 0.0004 0.00041389465332031 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
381 0.0005 0.00049591064453125 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
382 0.0019 0.0019190311431885 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
383 0.0007 0.00066304206848145 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
384 0.0022 0.0022199153900146 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
385 0.0016 0.0016191005706787 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
386 0.0005 0.00052595138549805 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
387 0.0012 0.0011610984802246 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
388 0.0014 0.0013608932495117 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'