0
  1. My Store
  2. All Products

All Products

Select your options below to filter out the products you don't want to see.

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.5869991779327 312 0.8749 0


No Amazon API Requests Made.


App Debug - Total Time 1.5869991779327 seconds

Number Time From Start Name Description
1 0.66328907012939 Initialise Initialise FSB Function
2 0.66577315330505 App Controller Start Start of the App controller (called before the controller of every page)
3 0.70167517662048 Start of getCategoryListByGroup Function Before first category groups query
4 0.70214295387268 After initial query Before first category groups query
5 0.70214605331421 Get Category List for Group Before the call to getCategoryList function
6 0.70215010643005 Start of GetCategoryList function Start of the function
7 0.7021541595459 Before getting categories Query to get specific category list
8 0.70284008979797 After getting categories Query to get specific category list
9 0.70284295082092 Before getting category custom Before call to function getCategoryCustom
10 0.71798205375671 After getting category custom After call to function getCategoryCustom
11 0.71798706054688 Before getting category custom Before call to function getCategoryCustom
12 0.72935009002686 After getting category custom After call to function getCategoryCustom
13 0.7293541431427 Before getting category custom Before call to function getCategoryCustom
14 0.73539710044861 After getting category custom After call to function getCategoryCustom
15 0.73539900779724 Before getting category custom Before call to function getCategoryCustom
16 0.73976898193359 After getting category custom After call to function getCategoryCustom
17 0.73977208137512 Before getting category custom Before call to function getCategoryCustom
18 0.74418711662292 After getting category custom After call to function getCategoryCustom
19 0.74418997764587 Before getting category custom Before call to function getCategoryCustom
20 0.74845814704895 After getting category custom After call to function getCategoryCustom
21 0.7484610080719 End of GetCategoryList function End of the function
22 0.74846696853638 Get Category List for Group Before the call to getCategoryList function
23 0.74846911430359 Start of GetCategoryList function Start of the function
24 0.74847197532654 Before getting categories Query to get specific category list
25 0.74893808364868 End of getCategoryListByGroup Function Before return()
26 1.3226840496063 App Controller End End of the App controller (called before the controller of every page)
27 1.4728360176086 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.4739129543304 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.4748220443726 Before Get Options Before the call to getOptions in the tpl class
30 1.5503621101379 After Get Options After the call to getOptions in the tpl class
31 1.5505859851837 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.5869750976562 Finalizing debug Before the debug is output to the page.
33 1.5869960784912 End of App This is the end of the app logging, final timestamp


Query Debug - 312 Database Queries. Total time 0.8749 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0034 0.0033600330352783 
SELECT parameter, value FROM parameters
2 0.0054 0.0054390430450439 
SELECT * FROM `bad_bots`
3 0.0009 0.00090217590332031 
SET time_zone = 'Europe/London'
4 0.0010 0.0010230541229248 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0015 0.0014820098876953 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.145.109.144\";}'
6 0.0015 0.0014798641204834 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1733371088'
7 0.0013 0.0013411045074463 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00057792663574219 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0010 0.00097393989562988 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0006 0.00057816505432129 
SELECT * FROM pages WHERE id = 37
11 0.0036 0.0036108493804932 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0312 0.031193017959595 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00050806999206543 
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0005 0.00045013427734375 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0007 0.00065708160400391 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0057 0.0057499408721924 
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.0005 0.0004889965057373 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0004 0.00043511390686035 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00046896934509277 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0059 0.0058879852294922 
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.0005 0.0005028247833252 
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.0005 0.00054717063903809 
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.0004 0.00044512748718262 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.0004420280456543 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0037 0.0036759376525879 
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.0005 0.00050902366638184 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0004 0.00042390823364258 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00041007995605469 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.0042619705200195 
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.00053191184997559 
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.00053977966308594 
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.00049114227294922 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00037193298339844 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.001378059387207 
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.0005 0.00045394897460938 
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.00042295455932617 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00039100646972656 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.001507043838501 
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.00051999092102051 
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.00046110153198242 
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.0004429817199707 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00037002563476562 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00054597854614258 
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.00041794776916504 
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.00034379959106445 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00039815902709961 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00068998336791992 
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.00046014785766602 
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.00050711631774902 
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.0005 0.00047898292541504 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00041985511779785 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00056195259094238 
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.0005 0.0004580020904541 
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.00038909912109375 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.0004119873046875 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00064706802368164 
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.00046515464782715 
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.00050020217895508 
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.0004 0.00043392181396484 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00044608116149902 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00058293342590332 
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.00043201446533203 
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.00036406517028809 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00041508674621582 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00063180923461914 
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.0004 0.00043797492980957 
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.00049090385437012 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0004 0.0004420280456543 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00039100646972656 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00045490264892578 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0016 0.0015890598297119 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00057506561279297 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00051999092102051 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0004 0.00043416023254395 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0010700225830078 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.0010030269622803 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5658 0.56583690643311 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.109.144') >= INET_ATON(ip_start) AND INET_ATON('3.145.109.144') <= INET_ATON(ip_end)
78 0.0012 0.0011510848999023 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0005 0.00052595138549805 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00069499015808105 
SELECT * FROM pages WHERE pagename = 'all-products'
81 0.0085 0.0084807872772217 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82 0.0029 0.0028679370880127 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0010 0.0009608268737793 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0077 0.0076620578765869 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85 0.0022 0.002169132232666 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0007 0.00074100494384766 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0048 0.0047750473022461 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
88 0.0052 0.0052299499511719 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0016 0.0015900135040283 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0005 0.00051283836364746 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0026 0.0026259422302246 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 0, 18
92 0.0006 0.00055980682373047 
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
93 0.0006 0.00062894821166992 
SELECT * FROM product_image_select WHERE product_id = '4950'
94 0.0004 0.00040102005004883 
SELECT * FROM productcustomimages WHERE product_id = '4950'
95 0.0010 0.00098705291748047 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
96 0.0005 0.00047898292541504 
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
97 0.0004 0.0004279613494873 
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
98 0.0005 0.00050878524780273 
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
99 0.0006 0.00057601928710938 
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
100 0.0006 0.0005650520324707 
SELECT * FROM product_image_select WHERE product_id = '4953'
101 0.0004 0.00040793418884277 
SELECT * FROM productcustomimages WHERE product_id = '4953'
102 0.0008 0.00082182884216309 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
103 0.0005 0.00045204162597656 
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
104 0.0004 0.00039887428283691 
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
105 0.0004 0.00040292739868164 
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
106 0.0005 0.0004878044128418 
SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
107 0.0007 0.00071501731872559 
SELECT * FROM product_image_select WHERE product_id = '4933'
108 0.0004 0.00039815902709961 
SELECT * FROM productcustomimages WHERE product_id = '4933'
109 0.0010 0.0010299682617188 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4933' AND a.name = n.originalname
110 0.0005 0.00048518180847168 
SELECT * FROM productoffers WHERE product_id = '4933' AND merchantid = 'A1X6FK5RDHNB96'
111 0.0004 0.00041699409484863 
SELECT * FROM productoffers
                WHERE product_id = '4933' AND price > 0
                ORDER BY price ASC LIMIT 1
112 0.0004 0.00043702125549316 
SELECT value FROM productattributes WHERE product_id = '4933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0005 0.0005030632019043 
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
114 0.0006 0.00060701370239258 
SELECT * FROM product_image_select WHERE product_id = '4926'
115 0.0004 0.00041890144348145 
SELECT * FROM productcustomimages WHERE product_id = '4926'
116 0.0011 0.0010828971862793 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
117 0.0005 0.00054001808166504 
SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0004 0.00043892860412598 
SELECT * FROM productoffers
                WHERE product_id = '4926' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0005 0.00052714347839355 
SELECT value FROM productattributes WHERE product_id = '4926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0006 0.00058484077453613 
SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
121 0.0006 0.00058507919311523 
SELECT * FROM product_image_select WHERE product_id = '4925'
122 0.0004 0.00040912628173828 
SELECT * FROM productcustomimages WHERE product_id = '4925'
123 0.0011 0.0010690689086914 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4925' AND a.name = n.originalname
124 0.0005 0.00047492980957031 
SELECT * FROM productoffers WHERE product_id = '4925' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0004 0.00041317939758301 
SELECT * FROM productoffers
                WHERE product_id = '4925' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0005 0.00048208236694336 
SELECT value FROM productattributes WHERE product_id = '4925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0006 0.00059795379638672 
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
128 0.0006 0.00057601928710938 
SELECT * FROM product_image_select WHERE product_id = '868'
129 0.0004 0.00039291381835938 
SELECT * FROM productcustomimages WHERE product_id = '868'
130 0.0009 0.00085997581481934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
131 0.0005 0.00046396255493164 
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0004 0.00040698051452637 
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0005 0.0004570484161377 
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0006 0.00062298774719238 
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
135 0.0006 0.00059294700622559 
SELECT * FROM product_image_select WHERE product_id = '4919'
136 0.0004 0.00038981437683105 
SELECT * FROM productcustomimages WHERE product_id = '4919'
137 0.0012 0.0011627674102783 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
138 0.0005 0.00050806999206543 
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0005 0.00045108795166016 
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0005 0.00048184394836426 
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0006 0.00063896179199219 
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
142 0.0010 0.00099897384643555 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2029' AND p.id = pi.product_id ORDER BY pi.sortorder
143 0.0006 0.00064516067504883 
SELECT * FROM product_image_select WHERE product_id = '2029'
144 0.0004 0.00041413307189941 
SELECT * FROM productcustomimages WHERE product_id = '2029'
145 0.0006 0.00059795379638672 
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 = '2029'
                GROUP BY o.product_id
146 0.0007 0.00071620941162109 
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     = '2029'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
147 0.0004 0.00044608116149902 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
148 0.0010 0.00098013877868652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
149 0.0004 0.00044393539428711 
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0004 0.00042510032653809 
SELECT * FROM productoffers
                WHERE product_id = '2029' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00039505958557129 
SELECT * FROM productoffers
                WHERE product_id = 2029
                ORDER BY price ASC LIMIT 1
152 0.0004 0.00042009353637695 
SELECT value FROM productattributes
                WHERE product_id = '2029'
                AND name = 'ListPriceAmount'
153 0.0005 0.00051999092102051 
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 = '2029'
                GROUP BY o.product_id
154 0.0007 0.00070309638977051 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2029'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
155 0.0005 0.00046300888061523 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
156 0.0005 0.0005488395690918 
SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0007 0.00067901611328125 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2029'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
158 0.0007 0.00074887275695801 
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
159 0.0007 0.00069594383239746 
SELECT * FROM product_image_select WHERE product_id = '862'
160 0.0006 0.00057411193847656 
SELECT * FROM productcustomimages WHERE product_id = '862'
161 0.0012 0.0011839866638184 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
162 0.0006 0.00063991546630859 
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
163 0.0005 0.00047087669372559 
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0005 0.00045204162597656 
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165 0.0007 0.0007481575012207 
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
166 0.0007 0.00065207481384277 
SELECT * FROM product_image_select WHERE product_id = '1011'
167 0.0004 0.00042295455932617 
SELECT * FROM productcustomimages WHERE product_id = '1011'
168 0.0010 0.00097393989562988 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
169 0.0005 0.0005340576171875 
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
170 0.0004 0.00044798851013184 
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0005 0.00050902366638184 
SELECT value FROM productattributes WHERE product_id = '1011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0006 0.00058698654174805 
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
173 0.0006 0.00063800811767578 
SELECT * FROM product_image_select WHERE product_id = '4122'
174 0.0004 0.00042605400085449 
SELECT * FROM productcustomimages WHERE product_id = '4122'
175 0.0011 0.0011250972747803 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4122' AND a.name = n.originalname
176 0.0005 0.00050902366638184 
SELECT * FROM productoffers WHERE product_id = '4122' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0005 0.0004889965057373 
SELECT * FROM productoffers
                WHERE product_id = '4122' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0004 0.00044584274291992 
SELECT value FROM productattributes WHERE product_id = '4122' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0007 0.0006568431854248 
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
180 0.0006 0.00063991546630859 
SELECT * FROM product_image_select WHERE product_id = '1010'
181 0.0005 0.00046801567077637 
SELECT * FROM productcustomimages WHERE product_id = '1010'
182 0.0011 0.001115083694458 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1010' AND a.name = n.originalname
183 0.0005 0.0005490779876709 
SELECT * FROM productoffers WHERE product_id = '1010' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0005 0.00046610832214355 
SELECT * FROM productoffers
                WHERE product_id = '1010' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0005 0.00046396255493164 
SELECT value FROM productattributes WHERE product_id = '1010' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0007 0.0006561279296875 
SELECT * FROM productimages WHERE product_id = '1140' ORDER BY sortorder ASC
187 0.0006 0.00064301490783691 
SELECT * FROM product_image_select WHERE product_id = '1140'
188 0.0004 0.00041890144348145 
SELECT * FROM productcustomimages WHERE product_id = '1140'
189 0.0008 0.00081706047058105 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1140' AND a.name = n.originalname
190 0.0006 0.00057101249694824 
SELECT * FROM productoffers WHERE product_id = '1140' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0005 0.00045013427734375 
SELECT * FROM productoffers
                WHERE product_id = '1140' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0005 0.00045108795166016 
SELECT value FROM productattributes WHERE product_id = '1140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193 0.0006 0.00064897537231445 
SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
194 0.0006 0.00064897537231445 
SELECT * FROM product_image_select WHERE product_id = '1061'
195 0.0004 0.00042200088500977 
SELECT * FROM productcustomimages WHERE product_id = '1061'
196 0.0013 0.0012731552124023 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
197 0.0006 0.00056815147399902 
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0005 0.00046110153198242 
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0005 0.00046706199645996 
SELECT value FROM productattributes WHERE product_id = '1061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0006 0.00064897537231445 
SELECT * FROM productimages WHERE product_id = '2165' ORDER BY sortorder ASC
201 0.0007 0.00065016746520996 
SELECT * FROM product_image_select WHERE product_id = '2165'
202 0.0004 0.0004279613494873 
SELECT * FROM productcustomimages WHERE product_id = '2165'
203 0.0009 0.00093913078308105 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2165' AND a.name = n.originalname
204 0.0006 0.00055098533630371 
SELECT * FROM productoffers WHERE product_id = '2165' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0005 0.00045490264892578 
SELECT * FROM productoffers
                WHERE product_id = '2165' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0005 0.00045299530029297 
SELECT value FROM productattributes WHERE product_id = '2165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0005 0.00053095817565918 
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
208 0.0007 0.00066709518432617 
SELECT * FROM product_image_select WHERE product_id = '4939'
209 0.0004 0.00042414665222168 
SELECT * FROM productcustomimages WHERE product_id = '4939'
210 0.0012 0.0012321472167969 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
211 0.0005 0.00053119659423828 
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0004 0.00044703483581543 
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0006 0.00056290626525879 
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0007 0.00072097778320312 
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
215 0.0007 0.00069284439086914 
SELECT * FROM product_image_select WHERE product_id = '1110'
216 0.0004 0.00044393539428711 
SELECT * FROM productcustomimages WHERE product_id = '1110'
217 0.0011 0.001101016998291 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
218 0.0005 0.00053286552429199 
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0004 0.0004432201385498 
SELECT * FROM productoffers
                WHERE product_id = '1110' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0005 0.00045084953308105 
SELECT value FROM productattributes WHERE product_id = '1110' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0007 0.00067901611328125 
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
222 0.0008 0.00081896781921387 
SELECT * FROM product_image_select WHERE product_id = '4930'
223 0.0005 0.00047016143798828 
SELECT * FROM productcustomimages WHERE product_id = '4930'
224 0.0013 0.0012519359588623 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
225 0.0006 0.00058293342590332 
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0005 0.00046205520629883 
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0005 0.00050616264343262 
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0005 0.00052118301391602 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
229 0.0004 0.00038504600524902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
230 0.0003 0.00034618377685547 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4933' ORDER BY timestamp DESC
231 0.0003 0.00034785270690918 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' ORDER BY timestamp DESC
232 0.0003 0.00032401084899902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4925' ORDER BY timestamp DESC
233 0.0003 0.00033116340637207 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
234 0.0004 0.00044083595275879 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4919' ORDER BY timestamp DESC
235 0.0004 0.00036811828613281 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2029' ORDER BY timestamp DESC
236 0.0003 0.0003349781036377 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '862' ORDER BY timestamp DESC
237 0.0004 0.00040197372436523 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1011' ORDER BY timestamp DESC
238 0.0003 0.00034403800964355 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4122' ORDER BY timestamp DESC
239 0.0004 0.00040102005004883 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1010' ORDER BY timestamp DESC
240 0.0004 0.00038385391235352 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1140' ORDER BY timestamp DESC
241 0.0003 0.00032901763916016 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1061' ORDER BY timestamp DESC
242 0.0003 0.00032210350036621 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2165' ORDER BY timestamp DESC
243 0.0003 0.00033307075500488 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4939' ORDER BY timestamp DESC
244 0.0004 0.00036716461181641 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1110' ORDER BY timestamp DESC
245 0.0003 0.00033998489379883 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
246 0.0007 0.00067687034606934 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
247 0.0005 0.00048208236694336 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
248 0.0004 0.00037097930908203 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
249 0.0166 0.016588926315308 
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
250 0.0007 0.00069212913513184 
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
251 0.0006 0.00063490867614746 
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
252 0.0006 0.00064587593078613 
SELECT * FROM products WHERE id = 1626
253 0.0011 0.0010881423950195 
SELECT * FROM products WHERE id = 4041
254 0.0019 0.0018961429595947 
SELECT * FROM products WHERE id = 4312
255 0.0012 0.0012052059173584 
SELECT * FROM products WHERE id = 777
256 0.0015 0.0014519691467285 
SELECT * FROM products WHERE id = 3881
257 0.0012 0.0011789798736572 
SELECT * FROM products WHERE id = 4213
258 0.0011 0.0011310577392578 
SELECT * FROM products WHERE id = '1626'
259 0.0012 0.0012171268463135 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
260 0.0014 0.001392126083374 
SELECT * FROM product_image_select WHERE product_id = '1626'
261 0.0011 0.0011100769042969 
SELECT * FROM productcustomimages WHERE product_id = '1626'
262 0.0020 0.0019919872283936 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
263 0.0013 0.0012819766998291 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
264 0.0010 0.0010318756103516 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
265 0.0011 0.0010628700256348 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0014 0.0013759136199951 
SELECT * FROM products WHERE id = '4041'
267 0.0014 0.001370906829834 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
268 0.0008 0.00080609321594238 
SELECT * FROM product_image_select WHERE product_id = '4041'
269 0.0006 0.00057601928710938 
SELECT * FROM productcustomimages WHERE product_id = '4041'
270 0.0013 0.0012791156768799 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
271 0.0006 0.00062298774719238 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
272 0.0005 0.0005340576171875 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
273 0.0006 0.0005950927734375 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274 0.0007 0.0007319450378418 
SELECT * FROM products WHERE id = '4312'
275 0.0006 0.00061202049255371 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
276 0.0008 0.00083494186401367 
SELECT * FROM product_image_select WHERE product_id = '4312'
277 0.0006 0.00061297416687012 
SELECT * FROM productcustomimages WHERE product_id = '4312'
278 0.0015 0.0014770030975342 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
279 0.0007 0.00071096420288086 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
280 0.0006 0.00057697296142578 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
281 0.0006 0.00059795379638672 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
282 0.0008 0.00075984001159668 
SELECT * FROM products WHERE id = '777'
283 0.0006 0.00061297416687012 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
284 0.0008 0.00083088874816895 
SELECT * FROM product_image_select WHERE product_id = '777'
285 0.0005 0.00052785873413086 
SELECT * FROM productcustomimages WHERE product_id = '777'
286 0.0015 0.0015408992767334 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
287 0.0007 0.0006709098815918 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
288 0.0005 0.00049901008605957 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
289 0.0005 0.00052595138549805 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290 0.0007 0.00071406364440918 
SELECT * FROM products WHERE id = '3881'
291 0.0008 0.00084900856018066 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
292 0.0008 0.00081896781921387 
SELECT * FROM product_image_select WHERE product_id = '3881'
293 0.0005 0.00050115585327148 
SELECT * FROM productcustomimages WHERE product_id = '3881'
294 0.0016 0.0015699863433838 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
295 0.0006 0.00063395500183105 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
296 0.0005 0.00050806999206543 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
297 0.0005 0.00054812431335449 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298 0.0007 0.00070905685424805 
SELECT * FROM products WHERE id = '4213'
299 0.0008 0.00082206726074219 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
300 0.0008 0.00077295303344727 
SELECT * FROM product_image_select WHERE product_id = '4213'
301 0.0005 0.00047898292541504 
SELECT * FROM productcustomimages WHERE product_id = '4213'
302 0.0016 0.0015609264373779 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
303 0.0006 0.00061607360839844 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
304 0.0005 0.00049185752868652 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
305 0.0005 0.00053787231445312 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
306 0.0011 0.0010628700256348 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
307 0.0011 0.0011389255523682 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
308 0.0021 0.0020959377288818 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
309 0.0010 0.0009610652923584 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
310 0.0008 0.0008080005645752 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
311 0.0011 0.0011060237884521 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
312 0.0011 0.0010910034179688 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'