0
  1. My Store
  2. All Products

All Products

Browse Categories

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.4728078842163 421 1.1320 0


No Amazon API Requests Made.


App Debug - Total Time 1.4728078842163 seconds

Number Time From Start Name Description
1 0.2761390209198 Initialise Initialise FSB Function
2 0.27932190895081 App Controller Start Start of the App controller (called before the controller of every page)
3 0.32512903213501 Start of getCategoryListByGroup Function Before first category groups query
4 0.3259859085083 After initial query Before first category groups query
5 0.3259859085083 Get Category List for Group Before the call to getCategoryList function
6 0.32598781585693 Start of GetCategoryList function Start of the function
7 0.32598996162415 Before getting categories Query to get specific category list
8 0.32671904563904 After getting categories Query to get specific category list
9 0.32671999931335 Before getting category custom Before call to function getCategoryCustom
10 0.34207201004028 After getting category custom After call to function getCategoryCustom
11 0.34207391738892 Before getting category custom Before call to function getCategoryCustom
12 0.35017681121826 After getting category custom After call to function getCategoryCustom
13 0.35017991065979 Before getting category custom Before call to function getCategoryCustom
14 0.35468482971191 After getting category custom After call to function getCategoryCustom
15 0.35468602180481 Before getting category custom Before call to function getCategoryCustom
16 0.35768103599548 After getting category custom After call to function getCategoryCustom
17 0.35768294334412 Before getting category custom Before call to function getCategoryCustom
18 0.36061501502991 After getting category custom After call to function getCategoryCustom
19 0.36061596870422 Before getting category custom Before call to function getCategoryCustom
20 0.36371994018555 After getting category custom After call to function getCategoryCustom
21 0.36372089385986 End of GetCategoryList function End of the function
22 0.36372590065002 Get Category List for Group Before the call to getCategoryList function
23 0.36372804641724 Start of GetCategoryList function Start of the function
24 0.36372995376587 Before getting categories Query to get specific category list
25 0.3640878200531 End of getCategoryListByGroup Function Before return()
26 1.165657043457 App Controller End End of the App controller (called before the controller of every page)
27 1.3542518615723 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.3557460308075 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.3568198680878 Before Get Options Before the call to getOptions in the tpl class
30 1.4229848384857 After Get Options After the call to getOptions in the tpl class
31 1.4231588840485 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.4727938175201 Finalizing debug Before the debug is output to the page.
33 1.472806930542 End of App This is the end of the app logging, final timestamp


Query Debug - 421 Database Queries. Total time 1.1320 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0014 0.0014300346374512 
SELECT parameter, value FROM parameters
2 0.0027 0.0026869773864746 
SELECT * FROM `bad_bots`
3 0.0002 0.00022196769714355 
SET time_zone = 'Europe/London'
4 0.0009 0.00089216232299805 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0008 0.00075507164001465 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.235\";}'
6 0.0007 0.00072884559631348 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1750462927'
7 0.0019 0.0019340515136719 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00052499771118164 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0017 0.0017428398132324 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0004 0.0003969669342041 
SELECT * FROM pages WHERE id = 37
11 0.0031 0.00307297706604 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0419 0.041945934295654 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0004 0.0003969669342041 
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0009 0.00085186958312988 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0007 0.00072002410888672 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0056 0.0055801868438721 
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.0009 0.0009009838104248 
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.0006 0.00059700012207031 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00031185150146484 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0051 0.0051040649414062 
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.0010 0.00096893310546875 
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.0008 0.00081086158752441 
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.0007 0.00071620941162109 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00028491020202637 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0030 0.0029590129852295 
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.0003 0.00031304359436035 
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.00026202201843262 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00028204917907715 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0030 0.0029549598693848 
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.0003 0.00034117698669434 
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.0003 0.00034880638122559 
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.0003 0.0003211498260498 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00027322769165039 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0011 0.0011100769042969 
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.0003 0.00033092498779297 
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.0003 0.00028204917907715 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00029802322387695 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0011 0.0011320114135742 
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.0004 0.00035786628723145 
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.0003 0.00033807754516602 
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.0003 0.0003058910369873 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00028705596923828 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0004 0.00037908554077148 
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.0003 0.00028300285339355 
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.00026702880859375 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00030398368835449 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00047111511230469 
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.0003 0.00031805038452148 
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.0003 0.00033783912658691 
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.0003 0.00030303001403809 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00028800964355469 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0004 0.0003960132598877 
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.0003 0.00029206275939941 
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.0003 0.00026798248291016 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00028014183044434 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0004 0.00042605400085449 
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.0003 0.00033998489379883 
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.0003 0.00032687187194824 
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.0003 0.00030303001403809 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00027799606323242 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0004 0.00040507316589355 
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.0003 0.00029516220092773 
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.0003 0.00028586387634277 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00030899047851562 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00046396255493164 
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.0003 0.00032997131347656 
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.0004 0.00037503242492676 
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.0003 0.00031018257141113 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00029706954956055 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00035309791564941 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0018 0.0018260478973389 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0008 0.00075101852416992 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0004 0.0003809928894043 
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.0007 0.00069189071655273 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0009 0.00090193748474121 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0006 0.00058102607727051 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7921 0.79206204414368 
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.235') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.235') <= INET_ATON(ip_end)
78 0.0020 0.0020389556884766 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0007 0.00074005126953125 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0005 0.00054001808166504 
SELECT * FROM pages WHERE pagename = 'all-products'
81 0.0048 0.0047860145568848 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82 0.0018 0.0018110275268555 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0011 0.0010800361633301 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0059 0.0058748722076416 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85 0.0016 0.0016200542449951 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0004 0.0003669261932373 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0039 0.0039088726043701 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
88 0.0053 0.0052559375762939 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0017 0.0016927719116211 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0004 0.00042510032653809 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0060 0.0059850215911865 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 1170, 18
92 0.0012 0.0011560916900635 
SELECT * FROM productimages WHERE product_id = '4476' ORDER BY sortorder ASC
93 0.0004 0.0004429817199707 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4476' AND p.id = pi.product_id ORDER BY pi.sortorder
94 0.0011 0.0010890960693359 
SELECT * FROM product_image_select WHERE product_id = '4476'
95 0.0007 0.00074291229248047 
SELECT * FROM productcustomimages WHERE product_id = '4476'
96 0.0013 0.0012710094451904 
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 = '4476'
                GROUP BY o.product_id
97 0.0015 0.0015029907226562 
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     = '4476'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
98 0.0004 0.00040006637573242 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4476
99 0.0013 0.00130295753479 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4476' AND a.name = n.originalname
100 0.0004 0.0003669261932373 
SELECT * FROM productoffers WHERE product_id = '4476' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0003 0.00027608871459961 
SELECT * FROM productoffers
                WHERE product_id = '4476' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0002 0.00024986267089844 
SELECT * FROM productoffers
                WHERE product_id = 4476
                ORDER BY price ASC LIMIT 1
103 0.0003 0.00028800964355469 
SELECT value FROM productattributes
                WHERE product_id = '4476'
                AND name = 'ListPriceAmount'
104 0.0004 0.00037503242492676 
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 = '4476'
                GROUP BY o.product_id
105 0.0005 0.00049090385437012 
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     = '4476'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
106 0.0003 0.00027704238891602 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4476
107 0.0004 0.0003969669342041 
SELECT value FROM productattributes WHERE product_id = '4476' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
108 0.0005 0.00045609474182129 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4476'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
109 0.0003 0.00034117698669434 
SELECT * FROM products WHERE parent_id = '4476'
110 0.0008 0.00083112716674805 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '950' AND a.name = n.originalname
111 0.0004 0.00035595893859863 
SELECT * FROM productoffers WHERE product_id = '950' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0003 0.00030803680419922 
SELECT * FROM productoffers
                WHERE product_id = '950' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0003 0.00025320053100586 
SELECT * FROM productoffers
                WHERE product_id = 950
                ORDER BY price ASC LIMIT 1
114 0.0003 0.00026702880859375 
SELECT value FROM productattributes
                WHERE product_id = '950'
                AND name = 'ListPriceAmount'
115 0.0004 0.00039482116699219 
SELECT * FROM productimages WHERE product_id = '4478' ORDER BY sortorder ASC
116 0.0006 0.00055980682373047 
SELECT * FROM product_image_select WHERE product_id = '4478'
117 0.0003 0.00029802322387695 
SELECT * FROM productcustomimages WHERE product_id = '4478'
118 0.0008 0.00081586837768555 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4478' AND a.name = n.originalname
119 0.0003 0.00033998489379883 
SELECT * FROM productoffers WHERE product_id = '4478' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0003 0.00027704238891602 
SELECT * FROM productoffers
                WHERE product_id = '4478' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0003 0.00025105476379395 
SELECT * FROM productoffers
                WHERE product_id = 4478
                ORDER BY price ASC LIMIT 1
122 0.0003 0.00027298927307129 
SELECT value FROM productattributes
                WHERE product_id = '4478'
                AND name = 'ListPriceAmount'
123 0.0003 0.00029802322387695 
SELECT value FROM productattributes WHERE product_id = '4478' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0003 0.00033211708068848 
SELECT * FROM productimages WHERE product_id = '4479' ORDER BY sortorder ASC
125 0.0006 0.00055313110351562 
SELECT * FROM product_image_select WHERE product_id = '4479'
126 0.0003 0.00029587745666504 
SELECT * FROM productcustomimages WHERE product_id = '4479'
127 0.0006 0.00058698654174805 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4479' AND a.name = n.originalname
128 0.0004 0.00037503242492676 
SELECT * FROM productoffers WHERE product_id = '4479' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0003 0.00030207633972168 
SELECT * FROM productoffers
                WHERE product_id = '4479' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0003 0.00027298927307129 
SELECT * FROM productoffers
                WHERE product_id = 4479
                ORDER BY price ASC LIMIT 1
131 0.0003 0.00027704238891602 
SELECT value FROM productattributes
                WHERE product_id = '4479'
                AND name = 'ListPriceAmount'
132 0.0003 0.00030303001403809 
SELECT value FROM productattributes WHERE product_id = '4479' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0004 0.00037002563476562 
SELECT * FROM productimages WHERE product_id = '4483' ORDER BY sortorder ASC
134 0.0005 0.00052094459533691 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4483' AND p.id = pi.product_id ORDER BY pi.sortorder
135 0.0005 0.00054407119750977 
SELECT * FROM product_image_select WHERE product_id = '4483'
136 0.0003 0.00030422210693359 
SELECT * FROM productcustomimages WHERE product_id = '4483'
137 0.0005 0.00045514106750488 
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 = '4483'
                GROUP BY o.product_id
138 0.0006 0.00063300132751465 
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     = '4483'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
139 0.0004 0.00035905838012695 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4483
140 0.0007 0.00065207481384277 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4483' AND a.name = n.originalname
141 0.0003 0.00025606155395508 
SELECT * FROM productoffers WHERE product_id = '4483' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0003 0.00026202201843262 
SELECT * FROM productoffers
                WHERE product_id = '4483' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0002 0.00023818016052246 
SELECT * FROM productoffers
                WHERE product_id = 4483
                ORDER BY price ASC LIMIT 1
144 0.0003 0.00027990341186523 
SELECT value FROM productattributes
                WHERE product_id = '4483'
                AND name = 'ListPriceAmount'
145 0.0004 0.00036001205444336 
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 = '4483'
                GROUP BY o.product_id
146 0.0006 0.00059890747070312 
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     = '4483'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
147 0.0003 0.00031495094299316 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4483
148 0.0004 0.00039005279541016 
SELECT value FROM productattributes WHERE product_id = '4483' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0006 0.00055098533630371 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4483'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
150 0.0004 0.00044798851013184 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4483'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
151 0.0004 0.00035500526428223 
SELECT * FROM productimages WHERE product_id = '4507' ORDER BY sortorder ASC
152 0.0005 0.00052404403686523 
SELECT * FROM product_image_select WHERE product_id = '4507'
153 0.0003 0.00029611587524414 
SELECT * FROM productcustomimages WHERE product_id = '4507'
154 0.0007 0.00066304206848145 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4507' AND a.name = n.originalname
155 0.0003 0.00033402442932129 
SELECT * FROM productoffers WHERE product_id = '4507' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0003 0.00026607513427734 
SELECT * FROM productoffers
                WHERE product_id = '4507' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0003 0.00025010108947754 
SELECT * FROM productoffers
                WHERE product_id = 4507
                ORDER BY price ASC LIMIT 1
158 0.0003 0.00027894973754883 
SELECT value FROM productattributes
                WHERE product_id = '4507'
                AND name = 'ListPriceAmount'
159 0.0003 0.00030994415283203 
SELECT value FROM productattributes WHERE product_id = '4507' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0004 0.00036907196044922 
SELECT * FROM productimages WHERE product_id = '4509' ORDER BY sortorder ASC
161 0.0004 0.00042605400085449 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4509' AND p.id = pi.product_id ORDER BY pi.sortorder
162 0.0005 0.00054597854614258 
SELECT * FROM product_image_select WHERE product_id = '4509'
163 0.0003 0.00030112266540527 
SELECT * FROM productcustomimages WHERE product_id = '4509'
164 0.0005 0.0005040168762207 
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 = '4509'
                GROUP BY o.product_id
165 0.0005 0.00048494338989258 
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     = '4509'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
166 0.0003 0.00032186508178711 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4509
167 0.0007 0.0006568431854248 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4509' AND a.name = n.originalname
168 0.0003 0.00026583671569824 
SELECT * FROM productoffers WHERE product_id = '4509' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0003 0.0002739429473877 
SELECT * FROM productoffers
                WHERE product_id = '4509' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0003 0.00027704238891602 
SELECT * FROM productoffers
                WHERE product_id = 4509
                ORDER BY price ASC LIMIT 1
171 0.0003 0.00028800964355469 
SELECT value FROM productattributes
                WHERE product_id = '4509'
                AND name = 'ListPriceAmount'
172 0.0003 0.0002892017364502 
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 = '4509'
                GROUP BY o.product_id
173 0.0007 0.00066399574279785 
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     = '4509'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
174 0.0003 0.00025296211242676 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4509
175 0.0005 0.00053787231445312 
SELECT value FROM productattributes WHERE product_id = '4509' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0004 0.00039792060852051 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4509'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
177 0.0003 0.00030279159545898 
SELECT * FROM products WHERE parent_id = '4509'
178 0.0004 0.00035810470581055 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4510' AND a.name = n.originalname
179 0.0003 0.00032806396484375 
SELECT * FROM productoffers WHERE product_id = '4510' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0002 0.00024294853210449 
SELECT * FROM productoffers
                WHERE product_id = '4510' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0002 0.0002291202545166 
SELECT * FROM productoffers
                WHERE product_id = 4510
                ORDER BY price ASC LIMIT 1
182 0.0002 0.00023484230041504 
SELECT value FROM productattributes
                WHERE product_id = '4510'
                AND name = 'ListPriceAmount'
183 0.0003 0.0003349781036377 
SELECT * FROM productimages WHERE product_id = '4531' ORDER BY sortorder ASC
184 0.0005 0.00045108795166016 
SELECT * FROM product_image_select WHERE product_id = '4531'
185 0.0005 0.00047206878662109 
SELECT * FROM productcustomimages WHERE product_id = '4531'
186 0.0005 0.00052118301391602 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4531' AND a.name = n.originalname
187 0.0003 0.00030517578125 
SELECT * FROM productoffers WHERE product_id = '4531' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0002 0.00024008750915527 
SELECT * FROM productoffers
                WHERE product_id = '4531' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0002 0.0002288818359375 
SELECT * FROM productoffers
                WHERE product_id = 4531
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00037407875061035 
SELECT value FROM productattributes
                WHERE product_id = '4531'
                AND name = 'ListPriceAmount'
191 0.0003 0.00029110908508301 
SELECT value FROM productattributes WHERE product_id = '4531' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0003 0.00034189224243164 
SELECT * FROM productimages WHERE product_id = '4559' ORDER BY sortorder ASC
193 0.0006 0.00063014030456543 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4559' AND p.id = pi.product_id ORDER BY pi.sortorder
194 0.0009 0.00086092948913574 
SELECT * FROM product_image_select WHERE product_id = '4559'
195 0.0005 0.00049877166748047 
SELECT * FROM productcustomimages WHERE product_id = '4559'
196 0.0004 0.00041604042053223 
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 = '4559'
                GROUP BY o.product_id
197 0.0004 0.00040507316589355 
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     = '4559'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
198 0.0003 0.0002748966217041 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4559
199 0.0006 0.00058484077453613 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4559' AND a.name = n.originalname
200 0.0003 0.00025010108947754 
SELECT * FROM productoffers WHERE product_id = '4559' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0002 0.00023889541625977 
SELECT * FROM productoffers
                WHERE product_id = '4559' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0002 0.00022506713867188 
SELECT * FROM productoffers
                WHERE product_id = 4559
                ORDER BY price ASC LIMIT 1
203 0.0002 0.00024509429931641 
SELECT value FROM productattributes
                WHERE product_id = '4559'
                AND name = 'ListPriceAmount'
204 0.0003 0.00027203559875488 
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 = '4559'
                GROUP BY o.product_id
205 0.0004 0.00039505958557129 
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     = '4559'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
206 0.0003 0.00029492378234863 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4559
207 0.0004 0.00036001205444336 
SELECT value FROM productattributes WHERE product_id = '4559' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0004 0.00037908554077148 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4559'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
209 0.0005 0.00049304962158203 
SELECT * FROM productimages WHERE product_id = '4570' ORDER BY sortorder ASC
210 0.0003 0.00029301643371582 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4570' AND p.id = pi.product_id ORDER BY pi.sortorder
211 0.0004 0.00044488906860352 
SELECT * FROM product_image_select WHERE product_id = '4570'
212 0.0003 0.00026106834411621 
SELECT * FROM productcustomimages WHERE product_id = '4570'
213 0.0004 0.00043201446533203 
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 = '4570'
                GROUP BY o.product_id
214 0.0005 0.00049304962158203 
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     = '4570'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
215 0.0003 0.00033402442932129 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4570
216 0.0007 0.00070881843566895 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4570' AND a.name = n.originalname
217 0.0002 0.00024008750915527 
SELECT * FROM productoffers WHERE product_id = '4570' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0002 0.00023412704467773 
SELECT * FROM productoffers
                WHERE product_id = '4570' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0002 0.00022602081298828 
SELECT * FROM productoffers
                WHERE product_id = 4570
                ORDER BY price ASC LIMIT 1
220 0.0002 0.00024199485778809 
SELECT value FROM productattributes
                WHERE product_id = '4570'
                AND name = 'ListPriceAmount'
221 0.0003 0.00026392936706543 
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 = '4570'
                GROUP BY o.product_id
222 0.0004 0.00039386749267578 
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     = '4570'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
223 0.0002 0.00024604797363281 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4570
224 0.0003 0.00032901763916016 
SELECT value FROM productattributes WHERE product_id = '4570' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0004 0.0003819465637207 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4570'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
226 0.0003 0.00028800964355469 
SELECT * FROM products WHERE parent_id = '4570'
227 0.0003 0.0003209114074707 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4645' AND a.name = n.originalname
228 0.0003 0.00029206275939941 
SELECT * FROM productoffers WHERE product_id = '4645' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0003 0.00025105476379395 
SELECT * FROM productoffers
                WHERE product_id = '4645' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0003 0.00030303001403809 
SELECT * FROM productoffers
                WHERE product_id = 4645
                ORDER BY price ASC LIMIT 1
231 0.0010 0.00098609924316406 
SELECT value FROM productattributes
                WHERE product_id = '4645'
                AND name = 'ListPriceAmount'
232 0.0006 0.00063300132751465 
SELECT * FROM productimages WHERE product_id = '4646' ORDER BY sortorder ASC
233 0.0009 0.000885009765625 
SELECT * FROM product_image_select WHERE product_id = '4646'
234 0.0005 0.00046682357788086 
SELECT * FROM productcustomimages WHERE product_id = '4646'
235 0.0015 0.0015227794647217 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4646' AND a.name = n.originalname
236 0.0005 0.00053596496582031 
SELECT * FROM productoffers WHERE product_id = '4646' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0005 0.00052714347839355 
SELECT * FROM productoffers
                WHERE product_id = '4646' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0005 0.00046396255493164 
SELECT * FROM productoffers
                WHERE product_id = 4646
                ORDER BY price ASC LIMIT 1
239 0.0004 0.00044703483581543 
SELECT value FROM productattributes
                WHERE product_id = '4646'
                AND name = 'ListPriceAmount'
240 0.0006 0.00055098533630371 
SELECT value FROM productattributes WHERE product_id = '4646' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241 0.0006 0.00061988830566406 
SELECT * FROM productimages WHERE product_id = '4804' ORDER BY sortorder ASC
242 0.0007 0.00070500373840332 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4804' AND p.id = pi.product_id ORDER BY pi.sortorder
243 0.0019 0.0019059181213379 
SELECT * FROM product_image_select WHERE product_id = '4804'
244 0.0009 0.00091791152954102 
SELECT * FROM productcustomimages WHERE product_id = '4804'
245 0.0007 0.00067996978759766 
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 = '4804'
                GROUP BY o.product_id
246 0.0007 0.00074505805969238 
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     = '4804'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
247 0.0004 0.00040292739868164 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4804
248 0.0017 0.0017220973968506 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4804' AND a.name = n.originalname
249 0.0004 0.00038385391235352 
SELECT * FROM productoffers WHERE product_id = '4804' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0004 0.00043797492980957 
SELECT * FROM productoffers
                WHERE product_id = '4804' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0010 0.0010340213775635 
SELECT * FROM productoffers
                WHERE product_id = 4804
                ORDER BY price ASC LIMIT 1
252 0.0011 0.0010762214660645 
SELECT value FROM productattributes
                WHERE product_id = '4804'
                AND name = 'ListPriceAmount'
253 0.0005 0.00049686431884766 
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 = '4804'
                GROUP BY o.product_id
254 0.0014 0.0013911724090576 
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     = '4804'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
255 0.0004 0.00042915344238281 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4804
256 0.0016 0.0016441345214844 
SELECT value FROM productattributes WHERE product_id = '4804' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257 0.0010 0.0010330677032471 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4804'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
258 0.0004 0.00044012069702148 
SELECT * FROM products WHERE parent_id = '4804'
259 0.0010 0.0010008811950684 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4815' AND a.name = n.originalname
260 0.0006 0.00056791305541992 
SELECT * FROM productoffers WHERE product_id = '4815' AND merchantid = 'A1X6FK5RDHNB96'
261 0.0004 0.00040912628173828 
SELECT * FROM productoffers
                WHERE product_id = '4815' AND price > 0
                ORDER BY price ASC LIMIT 1
262 0.0011 0.001068115234375 
SELECT * FROM productoffers
                WHERE product_id = 4815
                ORDER BY price ASC LIMIT 1
263 0.0006 0.0005500316619873 
SELECT value FROM productattributes
                WHERE product_id = '4815'
                AND name = 'ListPriceAmount'
264 0.0015 0.0015449523925781 
SELECT * FROM productimages WHERE product_id = '4806' ORDER BY sortorder ASC
265 0.0021 0.0020530223846436 
SELECT * FROM product_image_select WHERE product_id = '4806'
266 0.0012 0.0011670589447021 
SELECT * FROM productcustomimages WHERE product_id = '4806'
267 0.0035 0.0034899711608887 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4806' AND a.name = n.originalname
268 0.0007 0.00071597099304199 
SELECT * FROM productoffers WHERE product_id = '4806' AND merchantid = 'A1X6FK5RDHNB96'
269 0.0004 0.00043106079101562 
SELECT * FROM productoffers
                WHERE product_id = '4806' AND price > 0
                ORDER BY price ASC LIMIT 1
270 0.0004 0.00037193298339844 
SELECT * FROM productoffers
                WHERE product_id = 4806
                ORDER BY price ASC LIMIT 1
271 0.0004 0.00043797492980957 
SELECT value FROM productattributes
                WHERE product_id = '4806'
                AND name = 'ListPriceAmount'
272 0.0005 0.00054216384887695 
SELECT value FROM productattributes WHERE product_id = '4806' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273 0.0006 0.00060296058654785 
SELECT * FROM productimages WHERE product_id = '4612' ORDER BY sortorder ASC
274 0.0012 0.0011889934539795 
SELECT * FROM product_image_select WHERE product_id = '4612'
275 0.0005 0.00046300888061523 
SELECT * FROM productcustomimages WHERE product_id = '4612'
276 0.0022 0.0021600723266602 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4612' AND a.name = n.originalname
277 0.0008 0.000823974609375 
SELECT * FROM productoffers WHERE product_id = '4612' AND merchantid = 'A1X6FK5RDHNB96'
278 0.0004 0.00038409233093262 
SELECT * FROM productoffers
                WHERE product_id = '4612' AND price > 0
                ORDER BY price ASC LIMIT 1
279 0.0003 0.00033807754516602 
SELECT * FROM productoffers
                WHERE product_id = 4612
                ORDER BY price ASC LIMIT 1
280 0.0008 0.00078415870666504 
SELECT value FROM productattributes
                WHERE product_id = '4612'
                AND name = 'ListPriceAmount'
281 0.0006 0.00059294700622559 
SELECT value FROM productattributes WHERE product_id = '4612' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
282 0.0006 0.00062394142150879 
SELECT * FROM productimages WHERE product_id = '4678' ORDER BY sortorder ASC
283 0.0015 0.0015089511871338 
SELECT * FROM product_image_select WHERE product_id = '4678'
284 0.0008 0.00080204010009766 
SELECT * FROM productcustomimages WHERE product_id = '4678'
285 0.0022 0.002208948135376 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4678' AND a.name = n.originalname
286 0.0008 0.00082111358642578 
SELECT * FROM productoffers WHERE product_id = '4678' AND merchantid = 'A1X6FK5RDHNB96'
287 0.0007 0.00066590309143066 
SELECT * FROM productoffers
                WHERE product_id = '4678' AND price > 0
                ORDER BY price ASC LIMIT 1
288 0.0005 0.00049686431884766 
SELECT value FROM productattributes WHERE product_id = '4678' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
289 0.0005 0.00052690505981445 
SELECT * FROM productimages WHERE product_id = '4696' ORDER BY sortorder ASC
290 0.0009 0.00090813636779785 
SELECT * FROM product_image_select WHERE product_id = '4696'
291 0.0005 0.00046110153198242 
SELECT * FROM productcustomimages WHERE product_id = '4696'
292 0.0013 0.0012919902801514 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4696' AND a.name = n.originalname
293 0.0006 0.00062394142150879 
SELECT * FROM productoffers WHERE product_id = '4696' AND merchantid = 'A1X6FK5RDHNB96'
294 0.0003 0.00033783912658691 
SELECT * FROM productoffers
                WHERE product_id = '4696' AND price > 0
                ORDER BY price ASC LIMIT 1
295 0.0004 0.00038290023803711 
SELECT value FROM productattributes WHERE product_id = '4696' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
296 0.0004 0.00038909912109375 
SELECT * FROM productimages WHERE product_id = '4648' ORDER BY sortorder ASC
297 0.0005 0.00048708915710449 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4648' AND p.id = pi.product_id ORDER BY pi.sortorder
298 0.0010 0.0010130405426025 
SELECT * FROM product_image_select WHERE product_id = '4648'
299 0.0003 0.00031709671020508 
SELECT * FROM productcustomimages WHERE product_id = '4648'
300 0.0006 0.00064492225646973 
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 = '4648'
                GROUP BY o.product_id
301 0.0005 0.00045609474182129 
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     = '4648'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
302 0.0003 0.00029897689819336 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4648
303 0.0008 0.00077390670776367 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4648' AND a.name = n.originalname
304 0.0003 0.00026607513427734 
SELECT * FROM productoffers WHERE product_id = '4648' AND merchantid = 'A1X6FK5RDHNB96'
305 0.0003 0.00025296211242676 
SELECT * FROM productoffers
                WHERE product_id = '4648' AND price > 0
                ORDER BY price ASC LIMIT 1
306 0.0002 0.00023603439331055 
SELECT * FROM productoffers
                WHERE product_id = 4648
                ORDER BY price ASC LIMIT 1
307 0.0003 0.00028610229492188 
SELECT value FROM productattributes
                WHERE product_id = '4648'
                AND name = 'ListPriceAmount'
308 0.0003 0.00031399726867676 
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 = '4648'
                GROUP BY o.product_id
309 0.0005 0.00045490264892578 
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     = '4648'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
310 0.0003 0.00032591819763184 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4648
311 0.0004 0.00036501884460449 
SELECT value FROM productattributes WHERE product_id = '4648' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312 0.0006 0.00060796737670898 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4648'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
313 0.0003 0.00031280517578125 
SELECT * FROM products WHERE parent_id = '4648'
314 0.0008 0.00082612037658691 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2309' AND a.name = n.originalname
315 0.0003 0.0003211498260498 
SELECT * FROM productoffers WHERE product_id = '2309' AND merchantid = 'A1X6FK5RDHNB96'
316 0.0003 0.0002589225769043 
SELECT * FROM productoffers
                WHERE product_id = '2309' AND price > 0
                ORDER BY price ASC LIMIT 1
317 0.0003 0.00027012825012207 
SELECT * FROM productoffers
                WHERE product_id = 2309
                ORDER BY price ASC LIMIT 1
318 0.0003 0.0002741813659668 
SELECT value FROM productattributes
                WHERE product_id = '2309'
                AND name = 'ListPriceAmount'
319 0.0003 0.0003352165222168 
SELECT * FROM productimages WHERE product_id = '4672' ORDER BY sortorder ASC
320 0.0005 0.00053977966308594 
SELECT * FROM product_image_select WHERE product_id = '4672'
321 0.0003 0.00030612945556641 
SELECT * FROM productcustomimages WHERE product_id = '4672'
322 0.0009 0.00094509124755859 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4672' AND a.name = n.originalname
323 0.0003 0.00034379959106445 
SELECT * FROM productoffers WHERE product_id = '4672' AND merchantid = 'A1X6FK5RDHNB96'
324 0.0003 0.00028395652770996 
SELECT * FROM productoffers
                WHERE product_id = '4672' AND price > 0
                ORDER BY price ASC LIMIT 1
325 0.0002 0.00023102760314941 
SELECT * FROM productoffers
                WHERE product_id = 4672
                ORDER BY price ASC LIMIT 1
326 0.0003 0.00031709671020508 
SELECT value FROM productattributes
                WHERE product_id = '4672'
                AND name = 'ListPriceAmount'
327 0.0003 0.00030708312988281 
SELECT value FROM productattributes WHERE product_id = '4672' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
328 0.0006 0.00062799453735352 
SELECT * FROM productimages WHERE product_id = '4757' ORDER BY sortorder ASC
329 0.0006 0.0005950927734375 
SELECT * FROM product_image_select WHERE product_id = '4757'
330 0.0003 0.00030684471130371 
SELECT * FROM productcustomimages WHERE product_id = '4757'
331 0.0009 0.00089693069458008 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4757' AND a.name = n.originalname
332 0.0004 0.00035309791564941 
SELECT * FROM productoffers WHERE product_id = '4757' AND merchantid = 'A1X6FK5RDHNB96'
333 0.0003 0.00028800964355469 
SELECT * FROM productoffers
                WHERE product_id = '4757' AND price > 0
                ORDER BY price ASC LIMIT 1
334 0.0002 0.0002281665802002 
SELECT * FROM productoffers
                WHERE product_id = 4757
                ORDER BY price ASC LIMIT 1
335 0.0003 0.00028610229492188 
SELECT value FROM productattributes
                WHERE product_id = '4757'
                AND name = 'ListPriceAmount'
336 0.0003 0.00029397010803223 
SELECT value FROM productattributes WHERE product_id = '4757' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
337 0.0011 0.0010678768157959 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4476' ORDER BY timestamp DESC
338 0.0003 0.00026082992553711 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4478' ORDER BY timestamp DESC
339 0.0002 0.00023484230041504 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4479' ORDER BY timestamp DESC
340 0.0002 0.00021910667419434 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4483' ORDER BY timestamp DESC
341 0.0002 0.00022697448730469 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4507' ORDER BY timestamp DESC
342 0.0002 0.00022482872009277 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4509' ORDER BY timestamp DESC
343 0.0002 0.00021696090698242 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4531' ORDER BY timestamp DESC
344 0.0002 0.00022387504577637 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4559' ORDER BY timestamp DESC
345 0.0002 0.00020313262939453 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4570' ORDER BY timestamp DESC
346 0.0002 0.00024008750915527 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4646' ORDER BY timestamp DESC
347 0.0002 0.00023579597473145 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4804' ORDER BY timestamp DESC
348 0.0002 0.00022506713867188 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4806' ORDER BY timestamp DESC
349 0.0002 0.00023508071899414 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4612' ORDER BY timestamp DESC
350 0.0002 0.0002288818359375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4678' ORDER BY timestamp DESC
351 0.0002 0.00021100044250488 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4696' ORDER BY timestamp DESC
352 0.0005 0.00046396255493164 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4648' ORDER BY timestamp DESC
353 0.0002 0.00022697448730469 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4672' ORDER BY timestamp DESC
354 0.0002 0.00022983551025391 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4757' ORDER BY timestamp DESC
355 0.0010 0.0010049343109131 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
356 0.0008 0.00075292587280273 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
357 0.0003 0.00025606155395508 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
358 0.0275 0.027511119842529 
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
359 0.0038 0.0037591457366943 
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
360 0.0015 0.0015218257904053 
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
361 0.0006 0.00059080123901367 
SELECT * FROM products WHERE id = 1626
362 0.0003 0.00030279159545898 
SELECT * FROM products WHERE id = 4041
363 0.0003 0.00030398368835449 
SELECT * FROM products WHERE id = 4312
364 0.0003 0.00028300285339355 
SELECT * FROM products WHERE id = 777
365 0.0003 0.00030088424682617 
SELECT * FROM products WHERE id = 3881
366 0.0003 0.00029110908508301 
SELECT * FROM products WHERE id = 4213
367 0.0003 0.00028514862060547 
SELECT * FROM products WHERE id = '1626'
368 0.0004 0.00043010711669922 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
369 0.0005 0.00054502487182617 
SELECT * FROM product_image_select WHERE product_id = '1626'
370 0.0003 0.00033307075500488 
SELECT * FROM productcustomimages WHERE product_id = '1626'
371 0.0007 0.00073599815368652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
372 0.0005 0.00052809715270996 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
373 0.0003 0.00034785270690918 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
374 0.0004 0.00044012069702148 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
375 0.0004 0.00039100646972656 
SELECT * FROM products WHERE id = '4041'
376 0.0004 0.00035715103149414 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
377 0.0005 0.0005180835723877 
SELECT * FROM product_image_select WHERE product_id = '4041'
378 0.0003 0.00029492378234863 
SELECT * FROM productcustomimages WHERE product_id = '4041'
379 0.0009 0.00092792510986328 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
380 0.0003 0.00034713745117188 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
381 0.0003 0.00028800964355469 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
382 0.0003 0.00029897689819336 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
383 0.0004 0.00039100646972656 
SELECT * FROM products WHERE id = '4312'
384 0.0003 0.00034594535827637 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
385 0.0006 0.00060200691223145 
SELECT * FROM product_image_select WHERE product_id = '4312'
386 0.0003 0.00029802322387695 
SELECT * FROM productcustomimages WHERE product_id = '4312'
387 0.0009 0.00087094306945801 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
388 0.0004 0.00036787986755371 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
389 0.0003 0.00031208992004395 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
390 0.0003 0.00029706954956055 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
391 0.0004 0.00038814544677734 
SELECT * FROM products WHERE id = '777'
392 0.0004 0.00038385391235352 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
393 0.0006 0.00055289268493652 
SELECT * FROM product_image_select WHERE product_id = '777'
394 0.0003 0.00034213066101074 
SELECT * FROM productcustomimages WHERE product_id = '777'
395 0.0009 0.00087594985961914 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
396 0.0004 0.0003669261932373 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
397 0.0003 0.00031614303588867 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
398 0.0003 0.00031495094299316 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
399 0.0004 0.00038599967956543 
SELECT * FROM products WHERE id = '3881'
400 0.0004 0.00041604042053223 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
401 0.0005 0.00051403045654297 
SELECT * FROM product_image_select WHERE product_id = '3881'
402 0.0003 0.00029301643371582 
SELECT * FROM productcustomimages WHERE product_id = '3881'
403 0.0009 0.00089502334594727 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
404 0.0003 0.00032496452331543 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
405 0.0003 0.00030303001403809 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
406 0.0003 0.00032401084899902 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
407 0.0004 0.00042986869812012 
SELECT * FROM products WHERE id = '4213'
408 0.0004 0.00041699409484863 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
409 0.0006 0.00055599212646484 
SELECT * FROM product_image_select WHERE product_id = '4213'
410 0.0003 0.00031900405883789 
SELECT * FROM productcustomimages WHERE product_id = '4213'
411 0.0009 0.000946044921875 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
412 0.0004 0.00036716461181641 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
413 0.0003 0.00032687187194824 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
414 0.0003 0.00031304359436035 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
415 0.0015 0.0014939308166504 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
416 0.0006 0.00061511993408203 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
417 0.0032 0.0032238960266113 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
418 0.0020 0.0020239353179932 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
419 0.0006 0.00064301490783691 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
420 0.0007 0.00069999694824219 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
421 0.0007 0.00070095062255859 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'