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.8591859340668 207 1.0773 0


No Amazon API Requests Made.


App Debug - Total Time 1.8591859340668 seconds

Number Time From Start Name Description
1 0.71280002593994 Initialise Initialise FSB Function
2 0.71610498428345 App Controller Start Start of the App controller (called before the controller of every page)
3 0.76251697540283 Start of getCategoryListByGroup Function Before first category groups query
4 0.76464295387268 After initial query Before first category groups query
5 0.764643907547 Get Category List for Group Before the call to getCategoryList function
6 0.76464605331421 Start of GetCategoryList function Start of the function
7 0.76464796066284 Before getting categories Query to get specific category list
8 0.76665306091309 After getting categories Query to get specific category list
9 0.7666540145874 Before getting category custom Before call to function getCategoryCustom
10 0.79119086265564 After getting category custom After call to function getCategoryCustom
11 0.79119300842285 Before getting category custom Before call to function getCategoryCustom
12 0.8021068572998 After getting category custom After call to function getCategoryCustom
13 0.80210900306702 Before getting category custom Before call to function getCategoryCustom
14 0.80834293365479 After getting category custom After call to function getCategoryCustom
15 0.8083438873291 Before getting category custom Before call to function getCategoryCustom
16 0.81298899650574 After getting category custom After call to function getCategoryCustom
17 0.81298995018005 Before getting category custom Before call to function getCategoryCustom
18 0.81811285018921 After getting category custom After call to function getCategoryCustom
19 0.81811499595642 Before getting category custom Before call to function getCategoryCustom
20 0.823086977005 After getting category custom After call to function getCategoryCustom
21 0.82308793067932 End of GetCategoryList function End of the function
22 0.8230938911438 Get Category List for Group Before the call to getCategoryList function
23 0.82309508323669 Start of GetCategoryList function Start of the function
24 0.82309699058533 Before getting categories Query to get specific category list
25 0.82360601425171 End of getCategoryListByGroup Function Before return()
26 1.6478190422058 App Controller End End of the App controller (called before the controller of every page)
27 1.7356848716736 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.7377200126648 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.7391629219055 Before Get Options Before the call to getOptions in the tpl class
30 1.7926759719849 After Get Options After the call to getOptions in the tpl class
31 1.7927649021149 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.8591768741608 Finalizing debug Before the debug is output to the page.
33 1.8591849803925 End of App This is the end of the app logging, final timestamp


Query Debug - 207 Database Queries. Total time 1.0773 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0027 0.0027270317077637 
SELECT parameter, value FROM parameters
2 0.0042 0.0042431354522705 
SELECT * FROM `bad_bots`
3 0.0004 0.00038886070251465 
SET time_zone = 'Europe/London'
4 0.0035 0.0034799575805664 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0036 0.0036239624023438 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.141.40.192\";}'
6 0.0044 0.0044429302215576 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746534007'
7 0.0025 0.0025079250335693 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00045394897460938 
UPDATE autorun SET lastrun = '2025-05-06 12:20:07' WHERE id = '13'
9 0.0006 0.00055098533630371 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0018 0.0018379688262939 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0004 0.00041484832763672 
SELECT * FROM pages WHERE id = 37
12 0.0028 0.0027668476104736 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0422 0.042201042175293 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0009 0.0009009838104248 
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0021 0.00211501121521 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0020 0.0019891262054443 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0100 0.010028839111328 
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.0019 0.0018901824951172 
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.0014 0.0013720989227295 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00049877166748047 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0055 0.005511999130249 
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.0017 0.0017340183258057 
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.0016 0.0015649795532227 
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.0013148784637451 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0006 0.00055408477783203 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0037 0.003662109375 
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.0005 0.0005488395690918 
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.0005 0.00046610832214355 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00048398971557617 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0038 0.0038211345672607 
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.00050187110900879 
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.0004880428314209 
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.00043511390686035 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00046396255493164 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.0014081001281738 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0005 0.00051999092102051 
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.0004 0.00042104721069336 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00047111511230469 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0014 0.0014340877532959 
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.00045680999755859 
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.0005 0.00054383277893066 
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.00053691864013672 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00041508674621582 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00060892105102539 
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.00053286552429199 
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.0004119873046875 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00041294097900391 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00068497657775879 
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.00049686431884766 
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.0006 0.00055098533630371 
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.0005 0.00045895576477051 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00041985511779785 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00056314468383789 
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.0005 0.00046110153198242 
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.00040507316589355 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0005 0.00045585632324219 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0009 0.00085282325744629 
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.0006 0.00058507919311523 
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.00066709518432617 
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.00057005882263184 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.0005030632019043 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0008 0.00079917907714844 
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.0007 0.00071501731872559 
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.0004 0.00041294097900391 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.0003969669342041 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0007 0.00067305564880371 
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.0005 0.00052881240844727 
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.0005 0.00049090385437012 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0005 0.00046300888061523 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00043010711669922 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.0005030632019043 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0027 0.0026719570159912 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0019 0.0018951892852783 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0005 0.00053691864013672 
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.0012 0.001230001449585 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0012 0.0011801719665527 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0008 0.00080609321594238 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8109 0.81086611747742 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.141.40.192') >= INET_ATON(ip_start) AND INET_ATON('3.141.40.192') <= INET_ATON(ip_end)
79 0.0020 0.0020339488983154 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0012 0.0012121200561523 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0016 0.0016021728515625 
SELECT * FROM pages WHERE pagename = 'all-products'
82 0.0080 0.0079629421234131 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83 0.0017 0.0017080307006836 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0018 0.0017659664154053 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0055 0.0055041313171387 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86 0.0017 0.0017111301422119 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0005 0.00049400329589844 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0047 0.0046629905700684 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
89 0.0048 0.0048160552978516 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
90 0.0014 0.0013909339904785 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
91 0.0004 0.00041508674621582 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
92 0.0053 0.005263090133667 
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.0014 0.0014140605926514 
SELECT * FROM productimages WHERE product_id = '4767' ORDER BY sortorder ASC
94 0.0014 0.0013680458068848 
SELECT * FROM product_image_select WHERE product_id = '4767'
95 0.0011 0.0011398792266846 
SELECT * FROM productcustomimages WHERE product_id = '4767'
96 0.0019 0.0018801689147949 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4767' AND a.name = n.originalname
97 0.0014 0.0014121532440186 
SELECT * FROM productoffers WHERE product_id = '4767' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0004 0.00038003921508789 
SELECT * FROM productoffers
                WHERE product_id = '4767' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0003 0.00032806396484375 
SELECT * FROM productoffers
                WHERE product_id = 4767
                ORDER BY price ASC LIMIT 1
100 0.0005 0.0004570484161377 
SELECT value FROM productattributes
                WHERE product_id = '4767'
                AND name = 'ListPriceAmount'
101 0.0004 0.00043702125549316 
SELECT value FROM productattributes WHERE product_id = '4767' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
102 0.0004 0.00040602684020996 
SELECT * FROM productimages WHERE product_id = '4865' ORDER BY sortorder ASC
103 0.0006 0.00056791305541992 
SELECT * FROM product_image_select WHERE product_id = '4865'
104 0.0003 0.0003359317779541 
SELECT * FROM productcustomimages WHERE product_id = '4865'
105 0.0007 0.0007331371307373 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4865' AND a.name = n.originalname
106 0.0004 0.00040507316589355 
SELECT * FROM productoffers WHERE product_id = '4865' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0003 0.00032305717468262 
SELECT * FROM productoffers
                WHERE product_id = '4865' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0003 0.00026893615722656 
SELECT * FROM productoffers
                WHERE product_id = 4865
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00037479400634766 
SELECT value FROM productattributes
                WHERE product_id = '4865'
                AND name = 'ListPriceAmount'
110 0.0005 0.00045299530029297 
SELECT value FROM productattributes WHERE product_id = '4865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0005 0.00050091743469238 
SELECT * FROM productimages WHERE product_id = '4895' ORDER BY sortorder ASC
112 0.0006 0.00057005882263184 
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.00061893463134766 
SELECT * FROM product_image_select WHERE product_id = '4895'
114 0.0004 0.00037693977355957 
SELECT * FROM productcustomimages WHERE product_id = '4895'
115 0.0007 0.00065207481384277 
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.0032 0.0031669139862061 
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.00051093101501465 
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.00076508522033691 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4895' AND a.name = n.originalname
119 0.0003 0.00031399726867676 
SELECT * FROM productoffers WHERE product_id = '4895' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0003 0.00030899047851562 
SELECT * FROM productoffers
                WHERE product_id = '4895' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0003 0.00026702880859375 
SELECT * FROM productoffers
                WHERE product_id = 4895
                ORDER BY price ASC LIMIT 1
122 0.0003 0.00031614303588867 
SELECT value FROM productattributes
                WHERE product_id = '4895'
                AND name = 'ListPriceAmount'
123 0.0004 0.00040888786315918 
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.0006108283996582 
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.00035190582275391 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4895
126 0.0005 0.00051593780517578 
SELECT value FROM productattributes WHERE product_id = '4895' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0006 0.00057196617126465 
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.0005 0.00045990943908691 
SELECT * FROM productimages WHERE product_id = '4894' ORDER BY sortorder ASC
129 0.0006 0.00055813789367676 
SELECT * FROM product_image_select WHERE product_id = '4894'
130 0.0003 0.00034117698669434 
SELECT * FROM productcustomimages WHERE product_id = '4894'
131 0.0008 0.00080490112304688 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4894' AND a.name = n.originalname
132 0.0004 0.00040817260742188 
SELECT * FROM productoffers WHERE product_id = '4894' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0003 0.0003359317779541 
SELECT * FROM productoffers
                WHERE product_id = '4894' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0003 0.00030803680419922 
SELECT * FROM productoffers
                WHERE product_id = 4894
                ORDER BY price ASC LIMIT 1
135 0.0003 0.00033903121948242 
SELECT value FROM productattributes
                WHERE product_id = '4894'
                AND name = 'ListPriceAmount'
136 0.0004 0.00035691261291504 
SELECT value FROM productattributes WHERE product_id = '4894' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0013 0.001291036605835 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4767' ORDER BY timestamp DESC
138 0.0003 0.00030612945556641 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4865' ORDER BY timestamp DESC
139 0.0003 0.00033807754516602 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4895' ORDER BY timestamp DESC
140 0.0003 0.00028681755065918 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4894' ORDER BY timestamp DESC
141 0.0015 0.0014970302581787 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
142 0.0010 0.0010380744934082 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
143 0.0004 0.00036311149597168 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
144 0.0132 0.013217926025391 
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.0016 0.0015509128570557 
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.0005 0.00048518180847168 
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.00049996376037598 
SELECT * FROM products WHERE id = 1626
148 0.0004 0.00037789344787598 
SELECT * FROM products WHERE id = 4041
149 0.0004 0.00043797492980957 
SELECT * FROM products WHERE id = 4312
150 0.0004 0.00037193298339844 
SELECT * FROM products WHERE id = 777
151 0.0004 0.0003969669342041 
SELECT * FROM products WHERE id = 3881
152 0.0004 0.00044393539428711 
SELECT * FROM products WHERE id = 4213
153 0.0004 0.00036215782165527 
SELECT * FROM products WHERE id = '1626'
154 0.0004 0.00044894218444824 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
155 0.0005 0.00053596496582031 
SELECT * FROM product_image_select WHERE product_id = '1626'
156 0.0004 0.00041699409484863 
SELECT * FROM productcustomimages WHERE product_id = '1626'
157 0.0008 0.0008389949798584 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
158 0.0005 0.00047206878662109 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0004 0.0004119873046875 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0004 0.00041794776916504 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0007 0.00070714950561523 
SELECT * FROM products WHERE id = '4041'
162 0.0004 0.00042986869812012 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
163 0.0006 0.00057697296142578 
SELECT * FROM product_image_select WHERE product_id = '4041'
164 0.0004 0.00041985511779785 
SELECT * FROM productcustomimages WHERE product_id = '4041'
165 0.0011 0.0011119842529297 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
166 0.0005 0.00048184394836426 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0004 0.00043487548828125 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0005 0.00045013427734375 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0006 0.00055909156799316 
SELECT * FROM products WHERE id = '4312'
170 0.0004 0.0004420280456543 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
171 0.0006 0.00060105323791504 
SELECT * FROM product_image_select WHERE product_id = '4312'
172 0.0004 0.00041103363037109 
SELECT * FROM productcustomimages WHERE product_id = '4312'
173 0.0011 0.0010769367218018 
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.0005340576171875 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0005 0.00045204162597656 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0004 0.00039410591125488 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0005 0.00052905082702637 
SELECT * FROM products WHERE id = '777'
178 0.0005 0.00051188468933105 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
179 0.0006 0.00062012672424316 
SELECT * FROM product_image_select WHERE product_id = '777'
180 0.0004 0.00036501884460449 
SELECT * FROM productcustomimages WHERE product_id = '777'
181 0.0011 0.0010590553283691 
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.00051689147949219 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0004 0.00040507316589355 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0004 0.00044918060302734 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0006 0.00055599212646484 
SELECT * FROM products WHERE id = '3881'
186 0.0006 0.00059700012207031 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
187 0.0006 0.00057506561279297 
SELECT * FROM product_image_select WHERE product_id = '3881'
188 0.0004 0.00040102005004883 
SELECT * FROM productcustomimages WHERE product_id = '3881'
189 0.0013 0.0013220310211182 
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.00045084953308105 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0004 0.00042486190795898 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0005 0.00052499771118164 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193 0.0006 0.00056099891662598 
SELECT * FROM products WHERE id = '4213'
194 0.0005 0.00050091743469238 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
195 0.0006 0.00058197975158691 
SELECT * FROM product_image_select WHERE product_id = '4213'
196 0.0004 0.0004119873046875 
SELECT * FROM productcustomimages WHERE product_id = '4213'
197 0.0011 0.0010988712310791 
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.00048089027404785 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
199 0.0004 0.00039005279541016 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
200 0.0005 0.00046801567077637 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0019 0.0018551349639893 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
202 0.0007 0.00067615509033203 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
203 0.0024 0.0023760795593262 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
204 0.0017 0.0016500949859619 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
205 0.0004 0.00044798851013184 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
206 0.0011 0.0010929107666016 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
207 0.0011 0.0010678768157959 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'