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.3785829544067 206 1.0635 0


No Amazon API Requests Made.


App Debug - Total Time 1.3785829544067 seconds

Number Time From Start Name Description
1 0.2702898979187 Initialise Initialise FSB Function
2 0.27486395835876 App Controller Start Start of the App controller (called before the controller of every page)
3 0.30609893798828 Start of getCategoryListByGroup Function Before first category groups query
4 0.30750298500061 After initial query Before first category groups query
5 0.30750393867493 Get Category List for Group Before the call to getCategoryList function
6 0.30750608444214 Start of GetCategoryList function Start of the function
7 0.30750894546509 Before getting categories Query to get specific category list
8 0.30884790420532 After getting categories Query to get specific category list
9 0.30884790420532 Before getting category custom Before call to function getCategoryCustom
10 0.32949900627136 After getting category custom After call to function getCategoryCustom
11 0.32950305938721 Before getting category custom Before call to function getCategoryCustom
12 0.33984899520874 After getting category custom After call to function getCategoryCustom
13 0.33985090255737 Before getting category custom Before call to function getCategoryCustom
14 0.34551692008972 After getting category custom After call to function getCategoryCustom
15 0.34551811218262 Before getting category custom Before call to function getCategoryCustom
16 0.34932088851929 After getting category custom After call to function getCategoryCustom
17 0.3493230342865 Before getting category custom Before call to function getCategoryCustom
18 0.35313892364502 After getting category custom After call to function getCategoryCustom
19 0.35314106941223 Before getting category custom Before call to function getCategoryCustom
20 0.35704708099365 After getting category custom After call to function getCategoryCustom
21 0.35704898834229 End of GetCategoryList function End of the function
22 0.35705494880676 Get Category List for Group Before the call to getCategoryList function
23 0.35705590248108 Start of GetCategoryList function Start of the function
24 0.35705709457397 Before getting categories Query to get specific category list
25 0.35747003555298 End of getCategoryListByGroup Function Before return()
26 1.1472930908203 App Controller End End of the App controller (called before the controller of every page)
27 1.264899969101 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.2680990695953 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.2710630893707 Before Get Options Before the call to getOptions in the tpl class
30 1.3452439308167 After Get Options After the call to getOptions in the tpl class
31 1.3453350067139 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.3785629272461 Finalizing debug Before the debug is output to the page.
33 1.3785820007324 End of App This is the end of the app logging, final timestamp


Query Debug - 206 Database Queries. Total time 1.0635 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0021 0.0020959377288818 
SELECT parameter, value FROM parameters
2 0.0100 0.00996994972229 
SELECT * FROM `bad_bots`
3 0.0003 0.00034713745117188 
SET time_zone = 'Europe/London'
4 0.0022 0.0021729469299316 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0028 0.0027618408203125 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.118.122.147\";}'
6 0.0027 0.0027291774749756 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745491332'
7 0.0033 0.0032889842987061 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00072789192199707 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0028 0.0028138160705566 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0005 0.0005190372467041 
SELECT * FROM pages WHERE id = 37
11 0.0041 0.0041019916534424 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0263 0.026275873184204 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00056600570678711 
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0014 0.001399040222168 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0013 0.0013301372528076 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0073 0.0072720050811768 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0017 0.0016651153564453 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0013 0.001276969909668 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00040102005004883 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0054 0.0053701400756836 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
21 0.0015 0.001507043838501 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
22 0.0014 0.0013818740844727 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0013 0.001276969909668 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00041699409484863 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0035 0.0035340785980225 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0005 0.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
27 0.0004 0.00041294097900391 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00037217140197754 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0036 0.0036079883575439 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
30 0.0005 0.00046420097351074 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
31 0.0005 0.00052213668823242 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0004 0.00039792060852051 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00041103363037109 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0013 0.0013079643249512 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0004 0.0004270076751709 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0003 0.00032210350036621 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00039410591125488 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0014 0.0014410018920898 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
39 0.0004 0.0004429817199707 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
40 0.0005 0.00051999092102051 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0004 0.00040602684020996 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00036787986755371 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00051999092102051 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0004 0.00040006637573242 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0003 0.0003361701965332 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00034713745117188 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.0005800724029541 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
48 0.0004 0.00040411949157715 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
49 0.0004 0.00041890144348145 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0004 0.00039005279541016 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00037193298339844 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00052094459533691 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0004 0.00038886070251465 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0004 0.00036096572875977 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00034594535827637 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00057315826416016 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
57 0.0004 0.00040912628173828 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
58 0.0004 0.0004420280456543 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0004 0.00040006637573242 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00033688545227051 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.0005490779876709 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0004 0.00039005279541016 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0003 0.00033116340637207 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00038003921508789 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00060510635375977 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
66 0.0004 0.00042390823364258 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
67 0.0004 0.00043702125549316 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0004 0.00040388107299805 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00034809112548828 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00040793418884277 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0025 0.0025191307067871 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0013 0.0013470649719238 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00051307678222656 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0011 0.001086950302124 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0010800361633301 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0007 0.00072884559631348 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7778 0.77783513069153 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.118.122.147') >= INET_ATON(ip_start) AND INET_ATON('18.118.122.147') <= INET_ATON(ip_end)
78 0.0020 0.0019609928131104 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0012 0.0011990070343018 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0011 0.0010550022125244 
SELECT * FROM pages WHERE pagename = 'all-products'
81 0.0148 0.014813899993896 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82 0.0035 0.0034542083740234 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0029 0.002932071685791 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0100 0.010004997253418 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85 0.0023 0.0022728443145752 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0005 0.00054287910461426 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0049 0.0048561096191406 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
88 0.0050 0.0050480365753174 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0016 0.00160813331604 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0005 0.00050592422485352 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0054 0.0053820610046387 
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
92 0.0016 0.0016250610351562 
SELECT * FROM productimages WHERE product_id = '4767' ORDER BY sortorder ASC
93 0.0013 0.0013191699981689 
SELECT * FROM product_image_select WHERE product_id = '4767'
94 0.0011 0.0011141300201416 
SELECT * FROM productcustomimages WHERE product_id = '4767'
95 0.0018 0.0018219947814941 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4767' AND a.name = n.originalname
96 0.0013 0.0012831687927246 
SELECT * FROM productoffers WHERE product_id = '4767' AND merchantid = 'A1X6FK5RDHNB96'
97 0.0004 0.00038385391235352 
SELECT * FROM productoffers
                WHERE product_id = '4767' AND price > 0
                ORDER BY price ASC LIMIT 1
98 0.0003 0.0003199577331543 
SELECT * FROM productoffers
                WHERE product_id = 4767
                ORDER BY price ASC LIMIT 1
99 0.0005 0.00054407119750977 
SELECT value FROM productattributes
                WHERE product_id = '4767'
                AND name = 'ListPriceAmount'
100 0.0004 0.00040793418884277 
SELECT value FROM productattributes WHERE product_id = '4767' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
101 0.0005 0.00045204162597656 
SELECT * FROM productimages WHERE product_id = '4865' ORDER BY sortorder ASC
102 0.0006 0.00061702728271484 
SELECT * FROM product_image_select WHERE product_id = '4865'
103 0.0004 0.00044012069702148 
SELECT * FROM productcustomimages WHERE product_id = '4865'
104 0.0008 0.00078988075256348 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4865' AND a.name = n.originalname
105 0.0005 0.00045394897460938 
SELECT * FROM productoffers WHERE product_id = '4865' AND merchantid = 'A1X6FK5RDHNB96'
106 0.0004 0.00041007995605469 
SELECT * FROM productoffers
                WHERE product_id = '4865' AND price > 0
                ORDER BY price ASC LIMIT 1
107 0.0004 0.0003659725189209 
SELECT * FROM productoffers
                WHERE product_id = 4865
                ORDER BY price ASC LIMIT 1
108 0.0004 0.0003669261932373 
SELECT value FROM productattributes
                WHERE product_id = '4865'
                AND name = 'ListPriceAmount'
109 0.0004 0.00043606758117676 
SELECT value FROM productattributes WHERE product_id = '4865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0005 0.00046491622924805 
SELECT * FROM productimages WHERE product_id = '4895' ORDER BY sortorder ASC
111 0.0005 0.00053310394287109 
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
112 0.0006 0.00055217742919922 
SELECT * FROM product_image_select WHERE product_id = '4895'
113 0.0004 0.0004279613494873 
SELECT * FROM productcustomimages WHERE product_id = '4895'
114 0.0005 0.00053095817565918 
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
115 0.0023 0.0022790431976318 
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
116 0.0005 0.00048613548278809 
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
117 0.0008 0.00077295303344727 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4895' AND a.name = n.originalname
118 0.0004 0.00039911270141602 
SELECT * FROM productoffers WHERE product_id = '4895' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0004 0.00037503242492676 
SELECT * FROM productoffers
                WHERE product_id = '4895' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0003 0.00032305717468262 
SELECT * FROM productoffers
                WHERE product_id = 4895
                ORDER BY price ASC LIMIT 1
121 0.0004 0.00037097930908203 
SELECT value FROM productattributes
                WHERE product_id = '4895'
                AND name = 'ListPriceAmount'
122 0.0006 0.00055789947509766 
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
123 0.0006 0.00059294700622559 
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
124 0.0004 0.00037097930908203 
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
125 0.0005 0.00049901008605957 
SELECT value FROM productattributes WHERE product_id = '4895' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0006 0.00055885314941406 
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
127 0.0004 0.00042390823364258 
SELECT * FROM productimages WHERE product_id = '4894' ORDER BY sortorder ASC
128 0.0006 0.00059795379638672 
SELECT * FROM product_image_select WHERE product_id = '4894'
129 0.0004 0.00035405158996582 
SELECT * FROM productcustomimages WHERE product_id = '4894'
130 0.0008 0.00079607963562012 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4894' AND a.name = n.originalname
131 0.0006 0.00059294700622559 
SELECT * FROM productoffers WHERE product_id = '4894' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0008 0.00083589553833008 
SELECT * FROM productoffers
                WHERE product_id = '4894' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0006 0.0006101131439209 
SELECT * FROM productoffers
                WHERE product_id = 4894
                ORDER BY price ASC LIMIT 1
134 0.0007 0.00072789192199707 
SELECT value FROM productattributes
                WHERE product_id = '4894'
                AND name = 'ListPriceAmount'
135 0.0009 0.00085592269897461 
SELECT value FROM productattributes WHERE product_id = '4894' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0035 0.0035080909729004 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4767' ORDER BY timestamp DESC
137 0.0006 0.00059103965759277 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4865' ORDER BY timestamp DESC
138 0.0005 0.00045895576477051 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4895' ORDER BY timestamp DESC
139 0.0005 0.00047016143798828 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4894' ORDER BY timestamp DESC
140 0.0027 0.0027399063110352 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
141 0.0024 0.0024220943450928 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
142 0.0005 0.00049591064453125 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
143 0.0210 0.021047115325928 
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
144 0.0021 0.0021300315856934 
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
145 0.0006 0.0005948543548584 
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
146 0.0005 0.00053906440734863 
SELECT * FROM products WHERE id = 1626
147 0.0004 0.00038695335388184 
SELECT * FROM products WHERE id = 4041
148 0.0004 0.0003659725189209 
SELECT * FROM products WHERE id = 4312
149 0.0010 0.00099921226501465 
SELECT * FROM products WHERE id = 777
150 0.0013 0.0013289451599121 
SELECT * FROM products WHERE id = 3881
151 0.0008 0.00076389312744141 
SELECT * FROM products WHERE id = 4213
152 0.0006 0.00061488151550293 
SELECT * FROM products WHERE id = '1626'
153 0.0009 0.00092792510986328 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
154 0.0014 0.0014071464538574 
SELECT * FROM product_image_select WHERE product_id = '1626'
155 0.0007 0.0007479190826416 
SELECT * FROM productcustomimages WHERE product_id = '1626'
156 0.0019 0.0019271373748779 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
157 0.0008 0.00083184242248535 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0005 0.0005490779876709 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0009 0.00086307525634766 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0009 0.00088620185852051 
SELECT * FROM products WHERE id = '4041'
161 0.0007 0.00066089630126953 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
162 0.0011 0.0010640621185303 
SELECT * FROM product_image_select WHERE product_id = '4041'
163 0.0006 0.0005500316619873 
SELECT * FROM productcustomimages WHERE product_id = '4041'
164 0.0023 0.0022780895233154 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
165 0.0008 0.00080490112304688 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0008 0.00081586837768555 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0009 0.000885009765625 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0007 0.00074410438537598 
SELECT * FROM products WHERE id = '4312'
169 0.0006 0.0005800724029541 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
170 0.0008 0.00083613395690918 
SELECT * FROM product_image_select WHERE product_id = '4312'
171 0.0005 0.00050592422485352 
SELECT * FROM productcustomimages WHERE product_id = '4312'
172 0.0017 0.0016889572143555 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
173 0.0006 0.00061392784118652 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0005 0.00047492980957031 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0005 0.00053501129150391 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0007 0.00068211555480957 
SELECT * FROM products WHERE id = '777'
177 0.0006 0.00056982040405273 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
178 0.0008 0.0007781982421875 
SELECT * FROM product_image_select WHERE product_id = '777'
179 0.0004 0.00043201446533203 
SELECT * FROM productcustomimages WHERE product_id = '777'
180 0.0015 0.0014619827270508 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
181 0.0005 0.0005180835723877 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
182 0.0004 0.0004429817199707 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
183 0.0004 0.0004417896270752 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
184 0.0006 0.00057697296142578 
SELECT * FROM products WHERE id = '3881'
185 0.0005 0.00053501129150391 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
186 0.0007 0.00067400932312012 
SELECT * FROM product_image_select WHERE product_id = '3881'
187 0.0004 0.0004420280456543 
SELECT * FROM productcustomimages WHERE product_id = '3881'
188 0.0013 0.0013091564178467 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
189 0.0005 0.00051307678222656 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
190 0.0004 0.00042390823364258 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0005 0.00047993659973145 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0006 0.00058698654174805 
SELECT * FROM products WHERE id = '4213'
193 0.0005 0.00054001808166504 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
194 0.0007 0.00065708160400391 
SELECT * FROM product_image_select WHERE product_id = '4213'
195 0.0004 0.00042200088500977 
SELECT * FROM productcustomimages WHERE product_id = '4213'
196 0.0016 0.0016050338745117 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
197 0.0005 0.00046086311340332 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0004 0.00037717819213867 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0004 0.00039982795715332 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0020 0.0020201206207275 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
201 0.0007 0.00066614151000977 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
202 0.0025 0.0024619102478027 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
203 0.0016 0.0016298294067383 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
204 0.0005 0.00046801567077637 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
205 0.0005 0.00050520896911621 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
206 0.0006 0.00059008598327637 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'