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.6328959465027 207 1.1492 0


No Amazon API Requests Made.


App Debug - Total Time 1.6328959465027 seconds

Number Time From Start Name Description
1 0.38762211799622 Initialise Initialise FSB Function
2 0.39362001419067 App Controller Start Start of the App controller (called before the controller of every page)
3 0.4251549243927 Start of getCategoryListByGroup Function Before first category groups query
4 0.42650508880615 After initial query Before first category groups query
5 0.42650604248047 Get Category List for Group Before the call to getCategoryList function
6 0.4265079498291 Start of GetCategoryList function Start of the function
7 0.426509141922 Before getting categories Query to get specific category list
8 0.42791104316711 After getting categories Query to get specific category list
9 0.42791199684143 Before getting category custom Before call to function getCategoryCustom
10 0.44878005981445 After getting category custom After call to function getCategoryCustom
11 0.44878196716309 Before getting category custom Before call to function getCategoryCustom
12 0.47068095207214 After getting category custom After call to function getCategoryCustom
13 0.47068214416504 Before getting category custom Before call to function getCategoryCustom
14 0.48191905021667 After getting category custom After call to function getCategoryCustom
15 0.48192000389099 Before getting category custom Before call to function getCategoryCustom
16 0.48732209205627 After getting category custom After call to function getCategoryCustom
17 0.48732304573059 Before getting category custom Before call to function getCategoryCustom
18 0.49472308158875 After getting category custom After call to function getCategoryCustom
19 0.49472403526306 Before getting category custom Before call to function getCategoryCustom
20 0.50179600715637 After getting category custom After call to function getCategoryCustom
21 0.50179815292358 End of GetCategoryList function End of the function
22 0.50180196762085 Get Category List for Group Before the call to getCategoryList function
23 0.50180411338806 Start of GetCategoryList function Start of the function
24 0.50180506706238 Before getting categories Query to get specific category list
25 0.50251698493958 End of getCategoryListByGroup Function Before return()
26 1.339723110199 App Controller End End of the App controller (called before the controller of every page)
27 1.4550220966339 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.4585680961609 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.461678981781 Before Get Options Before the call to getOptions in the tpl class
30 1.5248630046844 After Get Options After the call to getOptions in the tpl class
31 1.52494597435 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.6328799724579 Finalizing debug Before the debug is output to the page.
33 1.6328949928284 End of App This is the end of the app logging, final timestamp


Query Debug - 207 Database Queries. Total time 1.1492 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.0022790431976318 
SELECT parameter, value FROM parameters
2 0.0089 0.0088710784912109 
SELECT * FROM `bad_bots`
3 0.0004 0.00036001205444336 
SET time_zone = 'Europe/London'
4 0.0019 0.0019009113311768 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0039 0.0038611888885498 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.221.222.110\";}'
6 0.0027 0.0027308464050293 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746517744'
7 0.0177 0.017675876617432 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00079798698425293 
UPDATE autorun SET lastrun = '2025-05-06 07:49:04' WHERE id = '13'
9 0.0014 0.0014081001281738 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0035 0.0035040378570557 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0005 0.00048708915710449 
SELECT * FROM pages WHERE id = 37
12 0.0047 0.0046699047088623 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0258 0.025779008865356 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00059604644775391 
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0013 0.0013449192047119 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0014 0.0013928413391113 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0073 0.0073490142822266 
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.0017 0.0016770362854004 
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.0012 0.0011539459228516 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.0004119873046875 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0054 0.0054471492767334 
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.0016 0.0016059875488281 
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.0014 0.0014379024505615 
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.0013 0.001309871673584 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.00040411949157715 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0036 0.003565788269043 
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.0012 0.0012469291687012 
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.0008 0.0007779598236084 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0008 0.00084900856018066 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0112 0.011210918426514 
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.0018 0.0018489360809326 
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.0010 0.0010340213775635 
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.0007 0.00066590309143066 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0007 0.00065398216247559 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0026 0.0025689601898193 
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.0007 0.00073885917663574 
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.0006 0.00063705444335938 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0012 0.0011739730834961 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0041 0.0040509700775146 
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.0006 0.00056815147399902 
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.0006 0.00055503845214844 
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.0005 0.00049805641174316 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00041985511779785 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00070714950561523 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0005 0.0005040168762207 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.00039315223693848 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00046491622924805 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0008 0.00076389312744141 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
49 0.0005 0.00051784515380859 
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.0010 0.00097990036010742 
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.0006 0.00060892105102539 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00044083595275879 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0012 0.001168966293335 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0006 0.00056910514831543 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0004 0.00044107437133789 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00039315223693848 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.0006411075592041 
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.0023 0.0023059844970703 
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.0007 0.00072097778320312 
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.0006 0.00057601928710938 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00054502487182617 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0008 0.00078797340393066 
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.0010 0.0009620189666748 
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.0005 0.00051403045654297 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00046515464782715 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0010 0.0010418891906738 
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.0008 0.00077390670776367 
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.0008 0.00077390670776367 
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.0011 0.0010859966278076 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0006 0.00064802169799805 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0007 0.00070905685424805 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0066 0.0065598487854004 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0022 0.0022339820861816 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.00062894821166992 
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.0017 0.0016660690307617 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0014 0.0014359951019287 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0011 0.0011429786682129 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8185 0.8185179233551 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.221.222.110') >= INET_ATON(ip_start) AND INET_ATON('18.221.222.110') <= INET_ATON(ip_end)
79 0.0020 0.0020089149475098 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0012 0.0012381076812744 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0008 0.00075197219848633 
SELECT * FROM pages WHERE pagename = 'all-products'
82 0.0113 0.011322021484375 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83 0.0026 0.0025579929351807 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0023 0.0023128986358643 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0072 0.007166862487793 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86 0.0016 0.0015828609466553 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0005 0.00054121017456055 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0047 0.0046529769897461 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
89 0.0099 0.0099179744720459 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
90 0.0026 0.0025959014892578 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
91 0.0005 0.00047683715820312 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
92 0.0075 0.0074820518493652 
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.0022 0.0021800994873047 
SELECT * FROM productimages WHERE product_id = '4767' ORDER BY sortorder ASC
94 0.0018 0.001751184463501 
SELECT * FROM product_image_select WHERE product_id = '4767'
95 0.0014 0.0014050006866455 
SELECT * FROM productcustomimages WHERE product_id = '4767'
96 0.0023 0.002324104309082 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4767' AND a.name = n.originalname
97 0.0013 0.0012850761413574 
SELECT * FROM productoffers WHERE product_id = '4767' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0004 0.00044488906860352 
SELECT * FROM productoffers
                WHERE product_id = '4767' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0004 0.00037884712219238 
SELECT * FROM productoffers
                WHERE product_id = 4767
                ORDER BY price ASC LIMIT 1
100 0.0006 0.00056195259094238 
SELECT value FROM productattributes
                WHERE product_id = '4767'
                AND name = 'ListPriceAmount'
101 0.0004 0.00041913986206055 
SELECT value FROM productattributes WHERE product_id = '4767' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
102 0.0005 0.00045609474182129 
SELECT * FROM productimages WHERE product_id = '4865' ORDER BY sortorder ASC
103 0.0005 0.00054216384887695 
SELECT * FROM product_image_select WHERE product_id = '4865'
104 0.0004 0.00039410591125488 
SELECT * FROM productcustomimages WHERE product_id = '4865'
105 0.0008 0.00075793266296387 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4865' AND a.name = n.originalname
106 0.0005 0.00049304962158203 
SELECT * FROM productoffers WHERE product_id = '4865' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0004 0.00036787986755371 
SELECT * FROM productoffers
                WHERE product_id = '4865' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0003 0.00033402442932129 
SELECT * FROM productoffers
                WHERE product_id = 4865
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00038909912109375 
SELECT value FROM productattributes
                WHERE product_id = '4865'
                AND name = 'ListPriceAmount'
110 0.0004 0.00040888786315918 
SELECT value FROM productattributes WHERE product_id = '4865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0005 0.00050711631774902 
SELECT * FROM productimages WHERE product_id = '4895' ORDER BY sortorder ASC
112 0.0005 0.00049090385437012 
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.0006 0.00057888031005859 
SELECT * FROM product_image_select WHERE product_id = '4895'
114 0.0005 0.00045084953308105 
SELECT * FROM productcustomimages WHERE product_id = '4895'
115 0.0006 0.00059294700622559 
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.0026 0.0025980472564697 
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.0005 0.00051307678222656 
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.0008 0.00080490112304688 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4895' AND a.name = n.originalname
119 0.0004 0.00041007995605469 
SELECT * FROM productoffers WHERE product_id = '4895' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00037503242492676 
SELECT * FROM productoffers
                WHERE product_id = '4895' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0004 0.00037407875061035 
SELECT * FROM productoffers
                WHERE product_id = 4895
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00036001205444336 
SELECT value FROM productattributes
                WHERE product_id = '4895'
                AND name = 'ListPriceAmount'
123 0.0004 0.0004279613494873 
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.0006 0.00059700012207031 
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.0004 0.00039982795715332 
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.0005 0.00053000450134277 
SELECT value FROM productattributes WHERE product_id = '4895' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0018 0.0017569065093994 
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.0011 0.0010621547698975 
SELECT * FROM productimages WHERE product_id = '4894' ORDER BY sortorder ASC
129 0.0014 0.001384973526001 
SELECT * FROM product_image_select WHERE product_id = '4894'
130 0.0007 0.00070810317993164 
SELECT * FROM productcustomimages WHERE product_id = '4894'
131 0.0018 0.0018060207366943 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4894' AND a.name = n.originalname
132 0.0009 0.00090813636779785 
SELECT * FROM productoffers WHERE product_id = '4894' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0008 0.00075507164001465 
SELECT * FROM productoffers
                WHERE product_id = '4894' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0007 0.00069808959960938 
SELECT * FROM productoffers
                WHERE product_id = 4894
                ORDER BY price ASC LIMIT 1
135 0.0008 0.00076007843017578 
SELECT value FROM productattributes
                WHERE product_id = '4894'
                AND name = 'ListPriceAmount'
136 0.0008 0.00082802772521973 
SELECT value FROM productattributes WHERE product_id = '4894' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0036 0.0035707950592041 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4767' ORDER BY timestamp DESC
138 0.0006 0.00064897537231445 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4865' ORDER BY timestamp DESC
139 0.0005 0.00053501129150391 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4895' ORDER BY timestamp DESC
140 0.0006 0.00057601928710938 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4894' ORDER BY timestamp DESC
141 0.0031 0.0030519962310791 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
142 0.0025 0.0024971961975098 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
143 0.0006 0.00056004524230957 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
144 0.0208 0.020834922790527 
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.0021 0.0021419525146484 
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.0006 0.00057196617126465 
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.0005 0.00052714347839355 
SELECT * FROM products WHERE id = 1626
148 0.0004 0.00036096572875977 
SELECT * FROM products WHERE id = 4041
149 0.0003 0.00033807754516602 
SELECT * FROM products WHERE id = 4312
150 0.0003 0.00032401084899902 
SELECT * FROM products WHERE id = 777
151 0.0003 0.00030422210693359 
SELECT * FROM products WHERE id = 3881
152 0.0003 0.00030899047851562 
SELECT * FROM products WHERE id = 4213
153 0.0003 0.00032186508178711 
SELECT * FROM products WHERE id = '1626'
154 0.0004 0.00043392181396484 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
155 0.0006 0.00057101249694824 
SELECT * FROM product_image_select WHERE product_id = '1626'
156 0.0004 0.00041794776916504 
SELECT * FROM productcustomimages WHERE product_id = '1626'
157 0.0008 0.00081491470336914 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
158 0.0009 0.00087404251098633 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0004 0.00043416023254395 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0005 0.0005190372467041 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0005 0.00051307678222656 
SELECT * FROM products WHERE id = '4041'
162 0.0005 0.00046205520629883 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
163 0.0012 0.0011870861053467 
SELECT * FROM product_image_select WHERE product_id = '4041'
164 0.0005 0.0004878044128418 
SELECT * FROM productcustomimages WHERE product_id = '4041'
165 0.0012 0.0011701583862305 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
166 0.0006 0.00055122375488281 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0005 0.00049996376037598 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0007 0.00071287155151367 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0006 0.00062894821166992 
SELECT * FROM products WHERE id = '4312'
170 0.0007 0.00067806243896484 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
171 0.0006 0.00060582160949707 
SELECT * FROM product_image_select WHERE product_id = '4312'
172 0.0004 0.00040102005004883 
SELECT * FROM productcustomimages WHERE product_id = '4312'
173 0.0010 0.0010349750518799 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
174 0.0005 0.00046682357788086 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0004 0.00040793418884277 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0005 0.00046300888061523 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0006 0.00060105323791504 
SELECT * FROM products WHERE id = '777'
178 0.0005 0.0004730224609375 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
179 0.0006 0.00063300132751465 
SELECT * FROM product_image_select WHERE product_id = '777'
180 0.0004 0.00037908554077148 
SELECT * FROM productcustomimages WHERE product_id = '777'
181 0.0010 0.00098013877868652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
182 0.0005 0.00046610832214355 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0004 0.00044012069702148 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0004 0.00044083595275879 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0005 0.00054121017456055 
SELECT * FROM products WHERE id = '3881'
186 0.0006 0.00055098533630371 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
187 0.0006 0.00056004524230957 
SELECT * FROM product_image_select WHERE product_id = '3881'
188 0.0004 0.0003969669342041 
SELECT * FROM productcustomimages WHERE product_id = '3881'
189 0.0011 0.0010690689086914 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
190 0.0005 0.00052309036254883 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0004 0.00039911270141602 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0004 0.00041508674621582 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193 0.0006 0.00057601928710938 
SELECT * FROM products WHERE id = '4213'
194 0.0006 0.00062799453735352 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
195 0.0006 0.00057697296142578 
SELECT * FROM product_image_select WHERE product_id = '4213'
196 0.0004 0.00040698051452637 
SELECT * FROM productcustomimages WHERE product_id = '4213'
197 0.0011 0.0011341571807861 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
198 0.0005 0.0004880428314209 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
199 0.0004 0.00039291381835938 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
200 0.0005 0.0005030632019043 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0020 0.0019750595092773 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
202 0.0007 0.00069189071655273 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
203 0.0026 0.0025601387023926 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
204 0.0018 0.0017898082733154 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
205 0.0007 0.0006568431854248 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
206 0.0010 0.0009911060333252 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
207 0.0007 0.00074291229248047 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'