0
  1. My Store
  2. All Products

All Products

Browse Categories

Wait! We have a something for you...

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

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

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.0556859970093 207 1.1873 0


No Amazon API Requests Made.


App Debug - Total Time 2.0556859970093 seconds

Number Time From Start Name Description
1 0.35996508598328 Initialise Initialise FSB Function
2 0.36196804046631 App Controller Start Start of the App controller (called before the controller of every page)
3 0.41175818443298 Start of getCategoryListByGroup Function Before first category groups query
4 0.41219305992126 After initial query Before first category groups query
5 0.41219401359558 Get Category List for Group Before the call to getCategoryList function
6 0.41219615936279 Start of GetCategoryList function Start of the function
7 0.41219806671143 Before getting categories Query to get specific category list
8 0.41264009475708 After getting categories Query to get specific category list
9 0.4126410484314 Before getting category custom Before call to function getCategoryCustom
10 0.4261360168457 After getting category custom After call to function getCategoryCustom
11 0.42613816261292 Before getting category custom Before call to function getCategoryCustom
12 0.43581414222717 After getting category custom After call to function getCategoryCustom
13 0.43581509590149 Before getting category custom Before call to function getCategoryCustom
14 0.44178605079651 After getting category custom After call to function getCategoryCustom
15 0.44178819656372 Before getting category custom Before call to function getCategoryCustom
16 0.44497799873352 After getting category custom After call to function getCategoryCustom
17 0.44497919082642 Before getting category custom Before call to function getCategoryCustom
18 0.4483699798584 After getting category custom After call to function getCategoryCustom
19 0.44837117195129 Before getting category custom Before call to function getCategoryCustom
20 0.45186901092529 After getting category custom After call to function getCategoryCustom
21 0.45187020301819 End of GetCategoryList function End of the function
22 0.45187401771545 Get Category List for Group Before the call to getCategoryList function
23 0.45187497138977 Start of GetCategoryList function Start of the function
24 0.45187616348267 Before getting categories Query to get specific category list
25 0.45224404335022 End of getCategoryListByGroup Function Before return()
26 1.4273161888123 App Controller End End of the App controller (called before the controller of every page)
27 1.500293970108 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.5011069774628 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.501697063446 Before Get Options Before the call to getOptions in the tpl class
30 1.5632350444794 After Get Options After the call to getOptions in the tpl class
31 1.5633180141449 App_after Controller End End of the App_after controller (called after the controller of every page)
32 2.055675983429 Finalizing debug Before the debug is output to the page.
33 2.055685043335 End of App This is the end of the app logging, final timestamp


Query Debug - 207 Database Queries. Total time 1.1873 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0036 0.0035970211029053 
SELECT parameter, value FROM parameters
2 0.0045 0.004533052444458 
SELECT * FROM `bad_bots`
3 0.0003 0.00030899047851562 
SET time_zone = 'Europe/London'
4 0.0006 0.00062298774719238 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0007 0.0007178783416748 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.106\";}'
6 0.0006 0.00058412551879883 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1756180805'
7 0.0010 0.0010430812835693 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00045490264892578 
UPDATE autorun SET lastrun = '2025-08-26 04:00:05' WHERE id = '15'
9 0.0004 0.00040793418884277 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0006 0.00061988830566406 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0004 0.00043201446533203 
SELECT * FROM pages WHERE id = 37
12 0.0027 0.0026710033416748 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0462 0.046160936355591 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0005 0.00052809715270996 
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0004 0.0004270076751709 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0004 0.00043010711669922 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0060 0.0059599876403809 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0005 0.00049901008605957 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0004 0.00037503242492676 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0003 0.00034093856811523 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0048 0.0048120021820068 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
22 0.0004 0.0004270076751709 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
23 0.0004 0.00035905838012695 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0003 0.00034999847412109 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0003 0.00031709671020508 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0030 0.0030028820037842 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0004 0.00035500526428223 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0003 0.00027298927307129 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00035500526428223 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0039 0.0039150714874268 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
31 0.0005 0.00053906440734863 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
32 0.0005 0.0004580020904541 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0004 0.00039887428283691 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00035691261291504 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0016 0.0016300678253174 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0003 0.00034022331237793 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0003 0.00027203559875488 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00047588348388672 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0017 0.0016980171203613 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
40 0.0005 0.00049710273742676 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
41 0.0004 0.00041794776916504 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0003 0.00032305717468262 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0003 0.00028395652770996 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0005 0.00053191184997559 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0003 0.00031495094299316 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0003 0.00026798248291016 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0003 0.00031304359436035 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0005 0.00047802925109863 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
49 0.0003 0.00032615661621094 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
50 0.0003 0.00030708312988281 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0003 0.00030612945556641 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.00031709671020508 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00048589706420898 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0003 0.00034594535827637 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0003 0.00029897689819336 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0003 0.00030899047851562 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0005 0.00050878524780273 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
58 0.0004 0.00037479400634766 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
59 0.0004 0.00038385391235352 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0003 0.0003209114074707 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.00034189224243164 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0005 0.00051307678222656 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0004 0.00040006637573242 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0003 0.00030684471130371 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00035500526428223 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0005 0.00053191184997559 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
67 0.0004 0.00035691261291504 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
68 0.0004 0.00035715103149414 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0003 0.00030612945556641 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.00033116340637207 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0004 0.00036406517028809 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0017 0.0016770362854004 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0004 0.00044393539428711 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0004 0.00040006637573242 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0003 0.00030803680419922 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0010 0.0010049343109131 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0007 0.00067877769470215 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.9676 0.96762299537659 
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.106') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.106') <= INET_ATON(ip_end)
79 0.0011 0.0010809898376465 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0003 0.00034689903259277 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0006 0.00057077407836914 
SELECT * FROM pages WHERE pagename = 'all-products'
82 0.0049 0.0049347877502441 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83 0.0015 0.0014541149139404 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0005 0.00048112869262695 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0052 0.0052061080932617 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86 0.0013 0.0012960433959961 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0004 0.00042510032653809 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0042 0.0041730403900146 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
89 0.0046 0.0045650005340576 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
90 0.0013 0.0013430118560791 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
91 0.0003 0.00034594535827637 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
92 0.0043 0.0042500495910645 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 1188, 18
93 0.0005 0.00045490264892578 
SELECT * FROM productimages WHERE product_id = '4767' ORDER BY sortorder ASC
94 0.0005 0.00048279762268066 
SELECT * FROM product_image_select WHERE product_id = '4767'
95 0.0003 0.00030398368835449 
SELECT * FROM productcustomimages WHERE product_id = '4767'
96 0.0008 0.00077509880065918 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4767' AND a.name = n.originalname
97 0.0003 0.00034189224243164 
SELECT * FROM productoffers WHERE product_id = '4767' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0003 0.0002589225769043 
SELECT * FROM productoffers
                WHERE product_id = '4767' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0002 0.00024509429931641 
SELECT * FROM productoffers
                WHERE product_id = 4767
                ORDER BY price ASC LIMIT 1
100 0.0003 0.00026416778564453 
SELECT value FROM productattributes
                WHERE product_id = '4767'
                AND name = 'ListPriceAmount'
101 0.0003 0.00028395652770996 
SELECT value FROM productattributes WHERE product_id = '4767' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
102 0.0003 0.00032496452331543 
SELECT * FROM productimages WHERE product_id = '4865' ORDER BY sortorder ASC
103 0.0005 0.0004580020904541 
SELECT * FROM product_image_select WHERE product_id = '4865'
104 0.0003 0.0002751350402832 
SELECT * FROM productcustomimages WHERE product_id = '4865'
105 0.0005 0.0005040168762207 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4865' AND a.name = n.originalname
106 0.0003 0.00031399726867676 
SELECT * FROM productoffers WHERE product_id = '4865' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0003 0.00026297569274902 
SELECT * FROM productoffers
                WHERE product_id = '4865' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0002 0.00023603439331055 
SELECT * FROM productoffers
                WHERE product_id = 4865
                ORDER BY price ASC LIMIT 1
109 0.0003 0.00025796890258789 
SELECT value FROM productattributes
                WHERE product_id = '4865'
                AND name = 'ListPriceAmount'
110 0.0003 0.0002739429473877 
SELECT value FROM productattributes WHERE product_id = '4865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0003 0.00034213066101074 
SELECT * FROM productimages WHERE product_id = '4895' ORDER BY sortorder ASC
112 0.0004 0.00035190582275391 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4895' AND p.id = pi.product_id ORDER BY pi.sortorder
113 0.0004 0.00043797492980957 
SELECT * FROM product_image_select WHERE product_id = '4895'
114 0.0003 0.00026106834411621 
SELECT * FROM productcustomimages WHERE product_id = '4895'
115 0.0004 0.00037407875061035 
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 = '4895'
                GROUP BY o.product_id
116 0.0004 0.00044894218444824 
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     = '4895'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
117 0.0003 0.00026202201843262 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4895
118 0.0005 0.00054097175598145 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4895' AND a.name = n.originalname
119 0.0002 0.00024199485778809 
SELECT * FROM productoffers WHERE product_id = '4895' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0002 0.00024914741516113 
SELECT * FROM productoffers
                WHERE product_id = '4895' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0002 0.00023984909057617 
SELECT * FROM productoffers
                WHERE product_id = 4895
                ORDER BY price ASC LIMIT 1
122 0.0002 0.00024604797363281 
SELECT value FROM productattributes
                WHERE product_id = '4895'
                AND name = 'ListPriceAmount'
123 0.0003 0.00027990341186523 
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 = '4895'
                GROUP BY o.product_id
124 0.0004 0.0004279613494873 
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     = '4895'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
125 0.0003 0.00025200843811035 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4895
126 0.0003 0.00034189224243164 
SELECT value FROM productattributes WHERE product_id = '4895' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0004 0.00037693977355957 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4895'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
128 0.0003 0.00030183792114258 
SELECT * FROM productimages WHERE product_id = '4894' ORDER BY sortorder ASC
129 0.0005 0.0004580020904541 
SELECT * FROM product_image_select WHERE product_id = '4894'
130 0.0003 0.00026798248291016 
SELECT * FROM productcustomimages WHERE product_id = '4894'
131 0.0006 0.00055599212646484 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4894' AND a.name = n.originalname
132 0.0003 0.0003049373626709 
SELECT * FROM productoffers WHERE product_id = '4894' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0002 0.0002439022064209 
SELECT * FROM productoffers
                WHERE product_id = '4894' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0003 0.00026202201843262 
SELECT * FROM productoffers
                WHERE product_id = 4894
                ORDER BY price ASC LIMIT 1
135 0.0002 0.00024294853210449 
SELECT value FROM productattributes
                WHERE product_id = '4894'
                AND name = 'ListPriceAmount'
136 0.0003 0.00025391578674316 
SELECT value FROM productattributes WHERE product_id = '4894' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0003 0.00028395652770996 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4767' ORDER BY timestamp DESC
138 0.0002 0.00021815299987793 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4865' ORDER BY timestamp DESC
139 0.0002 0.00021004676818848 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4895' ORDER BY timestamp DESC
140 0.0002 0.00020599365234375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4894' ORDER BY timestamp DESC
141 0.0003 0.00033712387084961 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
142 0.0003 0.00031590461730957 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
143 0.0002 0.00023508071899414 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
144 0.0128 0.012813091278076 
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
145 0.0005 0.00047588348388672 
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
146 0.0004 0.00038290023803711 
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
147 0.0004 0.00040006637573242 
SELECT * FROM products WHERE id = 1626
148 0.0003 0.00028610229492188 
SELECT * FROM products WHERE id = 4041
149 0.0002 0.00023508071899414 
SELECT * FROM products WHERE id = 4312
150 0.0002 0.00024509429931641 
SELECT * FROM products WHERE id = 777
151 0.0002 0.00023603439331055 
SELECT * FROM products WHERE id = 3881
152 0.0002 0.00022792816162109 
SELECT * FROM products WHERE id = 4213
153 0.0002 0.00023889541625977 
SELECT * FROM products WHERE id = '1626'
154 0.0003 0.00030708312988281 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
155 0.0005 0.00048494338989258 
SELECT * FROM product_image_select WHERE product_id = '1626'
156 0.0003 0.00029492378234863 
SELECT * FROM productcustomimages WHERE product_id = '1626'
157 0.0006 0.00062108039855957 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
158 0.0003 0.00031900405883789 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0003 0.0002601146697998 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0003 0.00029397010803223 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0003 0.00032806396484375 
SELECT * FROM products WHERE id = '4041'
162 0.0003 0.0003049373626709 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
163 0.0005 0.00047779083251953 
SELECT * FROM product_image_select WHERE product_id = '4041'
164 0.0003 0.00027799606323242 
SELECT * FROM productcustomimages WHERE product_id = '4041'
165 0.0007 0.00073790550231934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
166 0.0004 0.00035214424133301 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0003 0.0002739429473877 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0003 0.00028491020202637 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0004 0.00035786628723145 
SELECT * FROM products WHERE id = '4312'
170 0.0003 0.0003049373626709 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
171 0.0005 0.00052285194396973 
SELECT * FROM product_image_select WHERE product_id = '4312'
172 0.0003 0.0002739429473877 
SELECT * FROM productcustomimages WHERE product_id = '4312'
173 0.0007 0.00074005126953125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
174 0.0004 0.00037288665771484 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0003 0.00030112266540527 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0003 0.00029993057250977 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0004 0.00037789344787598 
SELECT * FROM products WHERE id = '777'
178 0.0003 0.00030398368835449 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
179 0.0005 0.00047588348388672 
SELECT * FROM product_image_select WHERE product_id = '777'
180 0.0003 0.00026798248291016 
SELECT * FROM productcustomimages WHERE product_id = '777'
181 0.0007 0.00067901611328125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
182 0.0003 0.00031805038452148 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0003 0.0002741813659668 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0003 0.00026988983154297 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0004 0.00036191940307617 
SELECT * FROM products WHERE id = '3881'
186 0.0003 0.00034403800964355 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
187 0.0005 0.00047993659973145 
SELECT * FROM product_image_select WHERE product_id = '3881'
188 0.0003 0.00026607513427734 
SELECT * FROM productcustomimages WHERE product_id = '3881'
189 0.0007 0.00066280364990234 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
190 0.0003 0.00031018257141113 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0003 0.00025200843811035 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0003 0.00027608871459961 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193 0.0004 0.00037288665771484 
SELECT * FROM products WHERE id = '4213'
194 0.0005 0.00052285194396973 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
195 0.0008 0.00075411796569824 
SELECT * FROM product_image_select WHERE product_id = '4213'
196 0.0003 0.00034999847412109 
SELECT * FROM productcustomimages WHERE product_id = '4213'
197 0.0012 0.0012378692626953 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
198 0.0007 0.00071406364440918 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
199 0.0004 0.00043010711669922 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
200 0.0004 0.00042486190795898 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0119 0.011851787567139 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
202 0.0006 0.00058603286743164 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
203 0.0035 0.0034940242767334 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
204 0.0083 0.00832200050354 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
205 0.0007 0.00073695182800293 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
206 0.0043 0.0042831897735596 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
207 0.0007 0.00073099136352539 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'