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
2.087818145752 358 1.1495 0


No Amazon API Requests Made.


App Debug - Total Time 2.087818145752 seconds

Number Time From Start Name Description
1 0.54489994049072 Initialise Initialise FSB Function
2 0.5515820980072 App Controller Start Start of the App controller (called before the controller of every page)
3 0.58571815490723 Start of getCategoryListByGroup Function Before first category groups query
4 0.58694410324097 After initial query Before first category groups query
5 0.58694505691528 Get Category List for Group Before the call to getCategoryList function
6 0.58694696426392 Start of GetCategoryList function Start of the function
7 0.58694815635681 Before getting categories Query to get specific category list
8 0.5882740020752 After getting categories Query to get specific category list
9 0.5882740020752 Before getting category custom Before call to function getCategoryCustom
10 0.60819411277771 After getting category custom After call to function getCategoryCustom
11 0.60819602012634 Before getting category custom Before call to function getCategoryCustom
12 0.61820197105408 After getting category custom After call to function getCategoryCustom
13 0.61820602416992 Before getting category custom Before call to function getCategoryCustom
14 0.62409114837646 After getting category custom After call to function getCategoryCustom
15 0.62409400939941 Before getting category custom Before call to function getCategoryCustom
16 0.62838292121887 After getting category custom After call to function getCategoryCustom
17 0.6283860206604 Before getting category custom Before call to function getCategoryCustom
18 0.63269805908203 After getting category custom After call to function getCategoryCustom
19 0.63270115852356 Before getting category custom Before call to function getCategoryCustom
20 0.63713908195496 After getting category custom After call to function getCategoryCustom
21 0.63714098930359 End of GetCategoryList function End of the function
22 0.63714814186096 Get Category List for Group Before the call to getCategoryList function
23 0.63715004920959 Start of GetCategoryList function Start of the function
24 0.63715314865112 Before getting categories Query to get specific category list
25 0.63767313957214 End of getCategoryListByGroup Function Before return()
26 1.4107050895691 App Controller End End of the App controller (called before the controller of every page)
27 1.7310819625854 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.7337000370026 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.7353229522705 Before Get Options Before the call to getOptions in the tpl class
30 2.0166609287262 After Get Options After the call to getOptions in the tpl class
31 2.0168409347534 App_after Controller End End of the App_after controller (called after the controller of every page)
32 2.0878050327301 Finalizing debug Before the debug is output to the page.
33 2.0878169536591 End of App This is the end of the app logging, final timestamp


Query Debug - 358 Database Queries. Total time 1.1495 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0024 0.0024039745330811 
SELECT parameter, value FROM parameters
2 0.0034 0.0034070014953613 
SELECT * FROM `bad_bots`
3 0.0003 0.00032687187194824 
SET time_zone = 'Europe/London'
4 0.0025 0.0024628639221191 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0021 0.0020759105682373 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.134.81.178\";}'
6 0.0018 0.0017879009246826 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746324830'
7 0.0036 0.0035960674285889 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00078201293945312 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0033 0.0033369064331055 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0006 0.00056910514831543 
SELECT * FROM pages WHERE id = 37
11 0.0037 0.003713846206665 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0295 0.029528856277466 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00052380561828613 
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0012 0.0012209415435791 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0013 0.0013139247894287 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0073 0.0072951316833496 
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.0014 0.0014369487762451 
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.0011 0.0011200904846191 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00040197372436523 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0054 0.0054070949554443 
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.0013 0.0013070106506348 
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.0013 0.0012631416320801 
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.0013 0.0012600421905518 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00037002563476562 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0034 0.0034070014953613 
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.0004 0.00042104721069336 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0003 0.00034499168395996 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00039911270141602 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0035 0.0035498142242432 
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.0005 0.00045013427734375 
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.0005 0.00048589706420898 
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.00045180320739746 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00040102005004883 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.0014081001281738 
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.0004 0.0004429817199707 
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.0003960132598877 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00036406517028809 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0014 0.0014069080352783 
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.0005 0.00047492980957031 
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.0005 0.00049400329589844 
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.0004 0.00041294097900391 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.0003960132598877 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00054788589477539 
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.0004 0.00040292739868164 
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.0003 0.00033998489379883 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00036382675170898 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00058794021606445 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
48 0.0005 0.00047111511230469 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
49 0.0005 0.00049400329589844 
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.0006 0.0005500316619873 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00044798851013184 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00059199333190918 
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.0004 0.00043916702270508 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0004 0.00036787986755371 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00038886070251465 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00063705444335938 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
57 0.0005 0.00045609474182129 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
58 0.0005 0.00048208236694336 
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.0005 0.00045108795166016 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00042295455932617 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00062990188598633 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0004 0.00043487548828125 
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.00037097930908203 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00040102005004883 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00066900253295898 
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.00046706199645996 
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.00049996376037598 
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.0005 0.00047612190246582 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00042009353637695 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00051093101501465 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0024 0.0024378299713135 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0013 0.0013339519500732 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00057101249694824 
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.0011 0.0010988712310791 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0010800361633301 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00080513954162598 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7607 0.76065802574158 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.134.81.178') >= INET_ATON(ip_start) AND INET_ATON('3.134.81.178') <= INET_ATON(ip_end)
78 0.0019 0.00193190574646 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0011 0.0011491775512695 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0011 0.0010740756988525 
SELECT * FROM pages WHERE pagename = 'all-products'
81 0.0153 0.015318155288696 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82 0.0032 0.0031590461730957 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0024 0.00235915184021 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0061 0.0061450004577637 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85 0.0016 0.0016160011291504 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0005 0.00046515464782715 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0044 0.0043950080871582 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
88 0.0050 0.0050358772277832 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0015 0.001539945602417 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0005 0.00049304962158203 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0053 0.0052571296691895 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 612, 18
92 0.0015 0.0015239715576172 
SELECT * FROM productimages WHERE product_id = '1068' ORDER BY sortorder ASC
93 0.0013 0.0013291835784912 
SELECT * FROM product_image_select WHERE product_id = '1068'
94 0.0011 0.0010659694671631 
SELECT * FROM productcustomimages WHERE product_id = '1068'
95 0.0015 0.0015430450439453 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1068' AND a.name = n.originalname
96 0.0013 0.0012600421905518 
SELECT * FROM productoffers WHERE product_id = '1068' AND merchantid = 'A1X6FK5RDHNB96'
97 0.0006 0.0006258487701416 
SELECT * FROM productoffers
                WHERE product_id = '1068' AND price > 0
                ORDER BY price ASC LIMIT 1
98 0.0004 0.00038695335388184 
SELECT * FROM productoffers
                WHERE product_id = 1068
                ORDER BY price ASC LIMIT 1
99 0.0005 0.00049710273742676 
SELECT value FROM productattributes
                WHERE product_id = '1068'
                AND name = 'ListPriceAmount'
100 0.0006 0.00060009956359863 
SELECT value FROM productattributes WHERE product_id = '1068' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
101 0.0006 0.00058293342590332 
SELECT * FROM productimages WHERE product_id = '1071' ORDER BY sortorder ASC
102 0.0006 0.00059318542480469 
SELECT * FROM product_image_select WHERE product_id = '1071'
103 0.0004 0.00038695335388184 
SELECT * FROM productcustomimages WHERE product_id = '1071'
104 0.0007 0.0006561279296875 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1071' AND a.name = n.originalname
105 0.0004 0.00044488906860352 
SELECT * FROM productoffers WHERE product_id = '1071' AND merchantid = 'A1X6FK5RDHNB96'
106 0.0003 0.00034213066101074 
SELECT * FROM productoffers
                WHERE product_id = '1071' AND price > 0
                ORDER BY price ASC LIMIT 1
107 0.0003 0.00030398368835449 
SELECT * FROM productoffers
                WHERE product_id = 1071
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00040197372436523 
SELECT value FROM productattributes
                WHERE product_id = '1071'
                AND name = 'ListPriceAmount'
109 0.0004 0.00037193298339844 
SELECT value FROM productattributes WHERE product_id = '1071' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0004 0.00039911270141602 
SELECT * FROM productimages WHERE product_id = '1072' ORDER BY sortorder ASC
111 0.0006 0.00055599212646484 
SELECT * FROM product_image_select WHERE product_id = '1072'
112 0.0019 0.0019350051879883 
SELECT * FROM productcustomimages WHERE product_id = '1072'
113 0.0030 0.0030410289764404 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1072' AND a.name = n.originalname
114 0.0005 0.00049614906311035 
SELECT * FROM productoffers WHERE product_id = '1072' AND merchantid = 'A1X6FK5RDHNB96'
115 0.0003 0.00034308433532715 
SELECT * FROM productoffers
                WHERE product_id = '1072' AND price > 0
                ORDER BY price ASC LIMIT 1
116 0.0003 0.00029110908508301 
SELECT * FROM productoffers
                WHERE product_id = 1072
                ORDER BY price ASC LIMIT 1
117 0.0003 0.00033116340637207 
SELECT value FROM productattributes
                WHERE product_id = '1072'
                AND name = 'ListPriceAmount'
118 0.0004 0.00038504600524902 
SELECT value FROM productattributes WHERE product_id = '1072' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0004 0.00043392181396484 
SELECT * FROM productimages WHERE product_id = '1073' ORDER BY sortorder ASC
120 0.0006 0.00055718421936035 
SELECT * FROM product_image_select WHERE product_id = '1073'
121 0.0004 0.00035190582275391 
SELECT * FROM productcustomimages WHERE product_id = '1073'
122 0.0007 0.00072312355041504 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1073' AND a.name = n.originalname
123 0.0005 0.00048708915710449 
SELECT * FROM productoffers WHERE product_id = '1073' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0003 0.00034213066101074 
SELECT * FROM productoffers
                WHERE product_id = '1073' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0003 0.00029611587524414 
SELECT * FROM productoffers
                WHERE product_id = 1073
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00032281875610352 
SELECT value FROM productattributes
                WHERE product_id = '1073'
                AND name = 'ListPriceAmount'
127 0.0004 0.00035881996154785 
SELECT value FROM productattributes WHERE product_id = '1073' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0004 0.00040698051452637 
SELECT * FROM productimages WHERE product_id = '1076' ORDER BY sortorder ASC
129 0.0005 0.00047707557678223 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1076' AND p.id = pi.product_id ORDER BY pi.sortorder
130 0.0006 0.00057411193847656 
SELECT * FROM product_image_select WHERE product_id = '1076'
131 0.0004 0.00041818618774414 
SELECT * FROM productcustomimages WHERE product_id = '1076'
132 0.0006 0.00056600570678711 
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 = '1076'
                GROUP BY o.product_id
133 0.0026 0.0026290416717529 
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     = '1076'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
134 0.0005 0.00050210952758789 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1076
135 0.0008 0.00081801414489746 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1076' AND a.name = n.originalname
136 0.0005 0.00050497055053711 
SELECT * FROM productoffers WHERE product_id = '1076' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0004 0.00038003921508789 
SELECT * FROM productoffers
                WHERE product_id = '1076' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0004 0.00037097930908203 
SELECT * FROM productoffers
                WHERE product_id = 1076
                ORDER BY price ASC LIMIT 1
139 0.0004 0.00038480758666992 
SELECT value FROM productattributes
                WHERE product_id = '1076'
                AND name = 'ListPriceAmount'
140 0.0004 0.0003960132598877 
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 = '1076'
                GROUP BY o.product_id
141 0.0006 0.00056290626525879 
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     = '1076'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
142 0.0004 0.00035190582275391 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1076
143 0.0005 0.00052404403686523 
SELECT value FROM productattributes WHERE product_id = '1076' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0004 0.00038695335388184 
SELECT * FROM products WHERE parent_id = '1076'
145 0.0004 0.00043010711669922 
SELECT * FROM productimages WHERE product_id = '1077' ORDER BY sortorder ASC
146 0.0006 0.00060915946960449 
SELECT * FROM product_image_select WHERE product_id = '1077'
147 0.0005 0.00046300888061523 
SELECT * FROM productcustomimages WHERE product_id = '1077'
148 0.0011 0.0011088848114014 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1077' AND a.name = n.originalname
149 0.0005 0.00052499771118164 
SELECT * FROM productoffers WHERE product_id = '1077' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0004 0.0003659725189209 
SELECT * FROM productoffers
                WHERE product_id = '1077' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00038504600524902 
SELECT value FROM productattributes WHERE product_id = '1077' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0006 0.00058698654174805 
SELECT * FROM productimages WHERE product_id = '1078' ORDER BY sortorder ASC
153 0.0005 0.00053000450134277 
SELECT * FROM product_image_select WHERE product_id = '1078'
154 0.0004 0.00040197372436523 
SELECT * FROM productcustomimages WHERE product_id = '1078'
155 0.0007 0.00069403648376465 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1078' AND a.name = n.originalname
156 0.0005 0.00045514106750488 
SELECT * FROM productoffers WHERE product_id = '1078' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0003 0.00034999847412109 
SELECT * FROM productoffers
                WHERE product_id = '1078' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0004 0.00039100646972656 
SELECT * FROM productoffers
                WHERE product_id = 1078
                ORDER BY price ASC LIMIT 1
159 0.0006 0.00055313110351562 
SELECT value FROM productattributes
                WHERE product_id = '1078'
                AND name = 'ListPriceAmount'
160 0.0006 0.00061416625976562 
SELECT value FROM productattributes WHERE product_id = '1078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0005 0.0005030632019043 
SELECT * FROM productimages WHERE product_id = '1081' ORDER BY sortorder ASC
162 0.0007 0.00065994262695312 
SELECT * FROM product_image_select WHERE product_id = '1081'
163 0.0005 0.00046420097351074 
SELECT * FROM productcustomimages WHERE product_id = '1081'
164 0.0010 0.0009770393371582 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1081' AND a.name = n.originalname
165 0.0005 0.00054383277893066 
SELECT * FROM productoffers WHERE product_id = '1081' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0005 0.00053215026855469 
SELECT * FROM productoffers
                WHERE product_id = '1081' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0004 0.00036907196044922 
SELECT * FROM productoffers
                WHERE product_id = 1081
                ORDER BY price ASC LIMIT 1
168 0.0005 0.00045418739318848 
SELECT value FROM productattributes
                WHERE product_id = '1081'
                AND name = 'ListPriceAmount'
169 0.0005 0.00052404403686523 
SELECT value FROM productattributes WHERE product_id = '1081' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0005 0.00052285194396973 
SELECT * FROM productimages WHERE product_id = '1082' ORDER BY sortorder ASC
171 0.0006 0.0005800724029541 
SELECT * FROM product_image_select WHERE product_id = '1082'
172 0.0005 0.00053691864013672 
SELECT * FROM productcustomimages WHERE product_id = '1082'
173 0.0007 0.00073599815368652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1082' AND a.name = n.originalname
174 0.0004 0.00043296813964844 
SELECT * FROM productoffers WHERE product_id = '1082' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0007 0.00066518783569336 
SELECT * FROM productoffers
                WHERE product_id = '1082' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0004 0.00041413307189941 
SELECT * FROM productoffers
                WHERE product_id = 1082
                ORDER BY price ASC LIMIT 1
177 0.0007 0.00074410438537598 
SELECT value FROM productattributes
                WHERE product_id = '1082'
                AND name = 'ListPriceAmount'
178 0.0006 0.0006110668182373 
SELECT value FROM productattributes WHERE product_id = '1082' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0005 0.0004570484161377 
SELECT * FROM productimages WHERE product_id = '1083' ORDER BY sortorder ASC
180 0.0005 0.00052189826965332 
SELECT * FROM product_image_select WHERE product_id = '1083'
181 0.0004 0.00036120414733887 
SELECT * FROM productcustomimages WHERE product_id = '1083'
182 0.0010 0.0010318756103516 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1083' AND a.name = n.originalname
183 0.0005 0.00047707557678223 
SELECT * FROM productoffers WHERE product_id = '1083' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0004 0.00037097930908203 
SELECT * FROM productoffers
                WHERE product_id = '1083' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0003 0.00032305717468262 
SELECT * FROM productoffers
                WHERE product_id = 1083
                ORDER BY price ASC LIMIT 1
186 0.0010 0.00098419189453125 
SELECT value FROM productattributes
                WHERE product_id = '1083'
                AND name = 'ListPriceAmount'
187 0.0011 0.0010690689086914 
SELECT value FROM productattributes WHERE product_id = '1083' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0010 0.00098586082458496 
SELECT * FROM productimages WHERE product_id = '1086' ORDER BY sortorder ASC
189 0.0008 0.0007781982421875 
SELECT * FROM product_image_select WHERE product_id = '1086'
190 0.0010 0.0009918212890625 
SELECT * FROM productcustomimages WHERE product_id = '1086'
191 0.0012 0.0011920928955078 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1086' AND a.name = n.originalname
192 0.0013 0.0012822151184082 
SELECT * FROM productoffers WHERE product_id = '1086' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0016 0.0015628337860107 
SELECT * FROM productoffers
                WHERE product_id = '1086' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0007 0.00068211555480957 
SELECT * FROM productoffers
                WHERE product_id = 1086
                ORDER BY price ASC LIMIT 1
195 0.0008 0.00083303451538086 
SELECT value FROM productattributes
                WHERE product_id = '1086'
                AND name = 'ListPriceAmount'
196 0.0011 0.001129150390625 
SELECT value FROM productattributes WHERE product_id = '1086' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0008 0.00075507164001465 
SELECT * FROM productimages WHERE product_id = '1341' ORDER BY sortorder ASC
198 0.0010 0.00096607208251953 
SELECT * FROM product_image_select WHERE product_id = '1341'
199 0.0011 0.0010528564453125 
SELECT * FROM productcustomimages WHERE product_id = '1341'
200 0.0020 0.0020198822021484 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1341' AND a.name = n.originalname
201 0.0005 0.00054693222045898 
SELECT * FROM productoffers WHERE product_id = '1341' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0004 0.00039911270141602 
SELECT * FROM productoffers
                WHERE product_id = '1341' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0004 0.00036406517028809 
SELECT * FROM productoffers
                WHERE product_id = 1341
                ORDER BY price ASC LIMIT 1
204 0.0004 0.00043296813964844 
SELECT value FROM productattributes
                WHERE product_id = '1341'
                AND name = 'ListPriceAmount'
205 0.0006 0.00059890747070312 
SELECT value FROM productattributes WHERE product_id = '1341' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0008 0.00077700614929199 
SELECT * FROM productimages WHERE product_id = '1090' ORDER BY sortorder ASC
207 0.0009 0.00087213516235352 
SELECT * FROM product_image_select WHERE product_id = '1090'
208 0.0004 0.00041699409484863 
SELECT * FROM productcustomimages WHERE product_id = '1090'
209 0.0010 0.0010049343109131 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1090' AND a.name = n.originalname
210 0.0005 0.00051689147949219 
SELECT * FROM productoffers WHERE product_id = '1090' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0005 0.00054097175598145 
SELECT * FROM productoffers
                WHERE product_id = '1090' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0004 0.00035500526428223 
SELECT * FROM productoffers
                WHERE product_id = 1090
                ORDER BY price ASC LIMIT 1
213 0.0004 0.00037980079650879 
SELECT value FROM productattributes
                WHERE product_id = '1090'
                AND name = 'ListPriceAmount'
214 0.0004 0.00043511390686035 
SELECT value FROM productattributes WHERE product_id = '1090' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0005 0.00049710273742676 
SELECT * FROM productimages WHERE product_id = '1091' ORDER BY sortorder ASC
216 0.0006 0.00061511993408203 
SELECT * FROM product_image_select WHERE product_id = '1091'
217 0.0005 0.00050616264343262 
SELECT * FROM productcustomimages WHERE product_id = '1091'
218 0.0009 0.0008549690246582 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1091' AND a.name = n.originalname
219 0.0010 0.00096416473388672 
SELECT * FROM productoffers WHERE product_id = '1091' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0006 0.00061988830566406 
SELECT * FROM productoffers
                WHERE product_id = '1091' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0004 0.00042104721069336 
SELECT * FROM productoffers
                WHERE product_id = 1091
                ORDER BY price ASC LIMIT 1
222 0.0004 0.0004119873046875 
SELECT value FROM productattributes
                WHERE product_id = '1091'
                AND name = 'ListPriceAmount'
223 0.0004 0.00043892860412598 
SELECT value FROM productattributes WHERE product_id = '1091' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0005 0.00046420097351074 
SELECT * FROM productimages WHERE product_id = '1097' ORDER BY sortorder ASC
225 0.0006 0.00062799453735352 
SELECT * FROM product_image_select WHERE product_id = '1097'
226 0.0006 0.0005640983581543 
SELECT * FROM productcustomimages WHERE product_id = '1097'
227 0.0019 0.001910924911499 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1097' AND a.name = n.originalname
228 0.0009 0.00089597702026367 
SELECT * FROM productoffers WHERE product_id = '1097' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0012 0.001162052154541 
SELECT * FROM productoffers
                WHERE product_id = '1097' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0012 0.0011751651763916 
SELECT * FROM productoffers
                WHERE product_id = 1097
                ORDER BY price ASC LIMIT 1
231 0.0006 0.00055980682373047 
SELECT value FROM productattributes
                WHERE product_id = '1097'
                AND name = 'ListPriceAmount'
232 0.0014 0.0014181137084961 
SELECT value FROM productattributes WHERE product_id = '1097' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0015 0.0014669895172119 
SELECT * FROM productimages WHERE product_id = '1101' ORDER BY sortorder ASC
234 0.0012 0.0011940002441406 
SELECT * FROM product_image_select WHERE product_id = '1101'
235 0.0011 0.0010550022125244 
SELECT * FROM productcustomimages WHERE product_id = '1101'
236 0.0016 0.0016279220581055 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1101' AND a.name = n.originalname
237 0.0007 0.00071597099304199 
SELECT * FROM productoffers WHERE product_id = '1101' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0010 0.001007080078125 
SELECT * FROM productoffers
                WHERE product_id = '1101' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0005 0.00046396255493164 
SELECT * FROM productoffers
                WHERE product_id = 1101
                ORDER BY price ASC LIMIT 1
240 0.0004 0.00041699409484863 
SELECT value FROM productattributes
                WHERE product_id = '1101'
                AND name = 'ListPriceAmount'
241 0.0004 0.00044894218444824 
SELECT value FROM productattributes WHERE product_id = '1101' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0005 0.00046086311340332 
SELECT * FROM productimages WHERE product_id = '1102' ORDER BY sortorder ASC
243 0.0007 0.00066900253295898 
SELECT * FROM product_image_select WHERE product_id = '1102'
244 0.0004 0.00037193298339844 
SELECT * FROM productcustomimages WHERE product_id = '1102'
245 0.0010 0.0010459423065186 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1102' AND a.name = n.originalname
246 0.0004 0.0004432201385498 
SELECT * FROM productoffers WHERE product_id = '1102' AND merchantid = 'A1X6FK5RDHNB96'
247 0.0004 0.00041294097900391 
SELECT * FROM productoffers
                WHERE product_id = '1102' AND price > 0
                ORDER BY price ASC LIMIT 1
248 0.0004 0.00037813186645508 
SELECT * FROM productoffers
                WHERE product_id = 1102
                ORDER BY price ASC LIMIT 1
249 0.0004 0.00043201446533203 
SELECT value FROM productattributes
                WHERE product_id = '1102'
                AND name = 'ListPriceAmount'
250 0.0004 0.00044798851013184 
SELECT value FROM productattributes WHERE product_id = '1102' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0006 0.00055384635925293 
SELECT * FROM productimages WHERE product_id = '1588' ORDER BY sortorder ASC
252 0.0006 0.00059199333190918 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1588' AND p.id = pi.product_id ORDER BY pi.sortorder
253 0.0006 0.00062680244445801 
SELECT * FROM product_image_select WHERE product_id = '1588'
254 0.0004 0.00039386749267578 
SELECT * FROM productcustomimages WHERE product_id = '1588'
255 0.0005 0.00054812431335449 
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 = '1588'
                GROUP BY o.product_id
256 0.0006 0.00064492225646973 
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     = '1588'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
257 0.0005 0.00048208236694336 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1588
258 0.0008 0.00082492828369141 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1588' AND a.name = n.originalname
259 0.0004 0.00037908554077148 
SELECT * FROM productoffers WHERE product_id = '1588' AND merchantid = 'A1X6FK5RDHNB96'
260 0.0003 0.00034499168395996 
SELECT * FROM productoffers
                WHERE product_id = '1588' AND price > 0
                ORDER BY price ASC LIMIT 1
261 0.0003 0.00033402442932129 
SELECT * FROM productoffers
                WHERE product_id = 1588
                ORDER BY price ASC LIMIT 1
262 0.0004 0.00036478042602539 
SELECT value FROM productattributes
                WHERE product_id = '1588'
                AND name = 'ListPriceAmount'
263 0.0005 0.00048398971557617 
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 = '1588'
                GROUP BY o.product_id
264 0.0007 0.00070285797119141 
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     = '1588'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
265 0.0004 0.00037693977355957 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1588
266 0.0005 0.00054788589477539 
SELECT value FROM productattributes WHERE product_id = '1588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267 0.0006 0.00062203407287598 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1588'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
268 0.0005 0.00045585632324219 
SELECT * FROM products WHERE parent_id = '1588'
269 0.0006 0.00055599212646484 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4140' AND a.name = n.originalname
270 0.0004 0.00044417381286621 
SELECT * FROM productoffers WHERE product_id = '4140' AND merchantid = 'A1X6FK5RDHNB96'
271 0.0005 0.00045680999755859 
SELECT * FROM productoffers
                WHERE product_id = '4140' AND price > 0
                ORDER BY price ASC LIMIT 1
272 0.0004 0.00040888786315918 
SELECT * FROM productoffers
                WHERE product_id = 4140
                ORDER BY price ASC LIMIT 1
273 0.0004 0.00040292739868164 
SELECT value FROM productattributes
                WHERE product_id = '4140'
                AND name = 'ListPriceAmount'
274 0.0015 0.0014829635620117 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1068' ORDER BY timestamp DESC
275 0.0004 0.00043797492980957 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1071' ORDER BY timestamp DESC
276 0.0003 0.00031614303588867 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1072' ORDER BY timestamp DESC
277 0.0003 0.00030398368835449 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1073' ORDER BY timestamp DESC
278 0.0003 0.00030183792114258 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1076' ORDER BY timestamp DESC
279 0.0003 0.00029802322387695 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1077' ORDER BY timestamp DESC
280 0.0003 0.00034403800964355 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1078' ORDER BY timestamp DESC
281 0.0004 0.00036287307739258 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1081' ORDER BY timestamp DESC
282 0.0003 0.00030994415283203 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1082' ORDER BY timestamp DESC
283 0.0003 0.00032901763916016 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1083' ORDER BY timestamp DESC
284 0.0003 0.00032806396484375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1086' ORDER BY timestamp DESC
285 0.0003 0.00031089782714844 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1341' ORDER BY timestamp DESC
286 0.0003 0.00029206275939941 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1090' ORDER BY timestamp DESC
287 0.0003 0.00029397010803223 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1091' ORDER BY timestamp DESC
288 0.0003 0.00031590461730957 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1097' ORDER BY timestamp DESC
289 0.0003 0.00030922889709473 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1101' ORDER BY timestamp DESC
290 0.0003 0.00032496452331543 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1102' ORDER BY timestamp DESC
291 0.0003 0.00034809112548828 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1588' ORDER BY timestamp DESC
292 0.0014 0.0013561248779297 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
293 0.0011 0.0010910034179688 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
294 0.0005 0.00046181678771973 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
295 0.0132 0.013198137283325 
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
296 0.0024 0.0024240016937256 
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
297 0.0007 0.00069308280944824 
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
298 0.0005 0.00047802925109863 
SELECT * FROM products WHERE id = 1626
299 0.0010 0.0010001659393311 
SELECT * FROM products WHERE id = 4041
300 0.0012 0.001187801361084 
SELECT * FROM products WHERE id = 4312
301 0.0006 0.00055599212646484 
SELECT * FROM products WHERE id = 777
302 0.0006 0.00061202049255371 
SELECT * FROM products WHERE id = 3881
303 0.0009 0.00088286399841309 
SELECT * FROM products WHERE id = 4213
304 0.0004 0.00042200088500977 
SELECT * FROM products WHERE id = '1626'
305 0.0005 0.00053787231445312 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
306 0.0007 0.00074601173400879 
SELECT * FROM product_image_select WHERE product_id = '1626'
307 0.0004 0.0003969669342041 
SELECT * FROM productcustomimages WHERE product_id = '1626'
308 0.0009 0.00091886520385742 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
309 0.0006 0.00057220458984375 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
310 0.0006 0.00059700012207031 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
311 0.0006 0.00059914588928223 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312 0.0007 0.00068092346191406 
SELECT * FROM products WHERE id = '4041'
313 0.0006 0.00055384635925293 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
314 0.0012 0.0012431144714355 
SELECT * FROM product_image_select WHERE product_id = '4041'
315 0.0009 0.00089001655578613 
SELECT * FROM productcustomimages WHERE product_id = '4041'
316 0.0015 0.0014810562133789 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
317 0.0008 0.00075006484985352 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
318 0.0006 0.00055694580078125 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
319 0.0007 0.00068783760070801 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
320 0.0006 0.00061607360839844 
SELECT * FROM products WHERE id = '4312'
321 0.0009 0.00087594985961914 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
322 0.0008 0.00082015991210938 
SELECT * FROM product_image_select WHERE product_id = '4312'
323 0.0004 0.00040698051452637 
SELECT * FROM productcustomimages WHERE product_id = '4312'
324 0.0012 0.0012369155883789 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
325 0.0006 0.00055885314941406 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
326 0.0005 0.00050091743469238 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
327 0.0007 0.00067305564880371 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
328 0.0007 0.00069999694824219 
SELECT * FROM products WHERE id = '777'
329 0.0013 0.0012831687927246 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
330 0.0024 0.0023608207702637 
SELECT * FROM product_image_select WHERE product_id = '777'
331 0.0026 0.0026118755340576 
SELECT * FROM productcustomimages WHERE product_id = '777'
332 0.0080 0.007965087890625 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
333 0.0012 0.0011570453643799 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
334 0.0007 0.0007469654083252 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
335 0.0007 0.00066089630126953 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
336 0.0012 0.0011529922485352 
SELECT * FROM products WHERE id = '3881'
337 0.0008 0.00078797340393066 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
338 0.0009 0.00092887878417969 
SELECT * FROM product_image_select WHERE product_id = '3881'
339 0.0006 0.0006098747253418 
SELECT * FROM productcustomimages WHERE product_id = '3881'
340 0.0021 0.0020511150360107 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
341 0.0026 0.0025689601898193 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
342 0.0026 0.0025629997253418 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
343 0.0005 0.00054407119750977 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
344 0.0017 0.0016829967498779 
SELECT * FROM products WHERE id = '4213'
345 0.0008 0.00077199935913086 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
346 0.0008 0.00083303451538086 
SELECT * FROM product_image_select WHERE product_id = '4213'
347 0.0006 0.00060796737670898 
SELECT * FROM productcustomimages WHERE product_id = '4213'
348 0.0022 0.0021679401397705 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
349 0.0012 0.0012438297271729 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
350 0.0005 0.00046086311340332 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
351 0.0007 0.0006561279296875 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
352 0.0020 0.0020341873168945 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
353 0.0021 0.0020818710327148 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
354 0.0081 0.0080761909484863 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
355 0.0051 0.0051310062408447 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
356 0.0012 0.0011980533599854 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
357 0.0010 0.0010280609130859 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
358 0.0010 0.0010039806365967 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'