0

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.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.94323205947876 238 0.1933 0


No Amazon API Requests Made.


App Debug - Total Time 0.94323205947876 seconds

Number Time From Start Name Description
1 0.65940999984741 Initialise Initialise FSB Function
2 0.66296601295471 App Controller Start Start of the App controller (called before the controller of every page)
3 0.66569995880127 Start of getCategoryListByGroup Function Before first category groups query
4 0.66607904434204 After initial query Before first category groups query
5 0.66607999801636 Get Category List for Group Before the call to getCategoryList function
6 0.66608309745789 Start of GetCategoryList function Start of the function
7 0.66608595848083 Before getting categories Query to get specific category list
8 0.66641592979431 After getting categories Query to get specific category list
9 0.66641712188721 Before getting category custom Before call to function getCategoryCustom
10 0.66872000694275 After getting category custom After call to function getCategoryCustom
11 0.66872310638428 Before getting category custom Before call to function getCategoryCustom
12 0.68085503578186 After getting category custom After call to function getCategoryCustom
13 0.68085694313049 Before getting category custom Before call to function getCategoryCustom
14 0.68619108200073 After getting category custom After call to function getCategoryCustom
15 0.68619298934937 Before getting category custom Before call to function getCategoryCustom
16 0.68918704986572 After getting category custom After call to function getCategoryCustom
17 0.68918895721436 Before getting category custom Before call to function getCategoryCustom
18 0.69282007217407 After getting category custom After call to function getCategoryCustom
19 0.69282197952271 Before getting category custom Before call to function getCategoryCustom
20 0.69666409492493 After getting category custom After call to function getCategoryCustom
21 0.69666600227356 End of GetCategoryList function End of the function
22 0.69667196273804 Get Category List for Group Before the call to getCategoryList function
23 0.69667410850525 Start of GetCategoryList function Start of the function
24 0.69667601585388 Before getting categories Query to get specific category list
25 0.69698810577393 End of getCategoryListByGroup Function Before return()
26 0.77452301979065 App Controller End End of the App controller (called before the controller of every page)
27 0.78892803192139 Start of GetCategoryList function Start of the function
28 0.78893208503723 Before getting categories Query to get specific category list
29 0.78935408592224 After getting categories Query to get specific category list
30 0.78935599327087 Before getting category custom Before call to function getCategoryCustom
31 0.79217410087585 After getting category custom After call to function getCategoryCustom
32 0.79217600822449 Before getting sub category list Before call to recursive function getCategoryList
33 0.79217910766602 Start of GetCategoryList function Start of the function
34 0.79218196868896 Before getting categories Query to get specific category list
35 0.79258608818054 After getting sub category list After call to recursive function getCategoryList
36 0.79258799552917 Before getting category custom Before call to function getCategoryCustom
37 0.79570412635803 After getting category custom After call to function getCategoryCustom
38 0.79570508003235 Before getting sub category list Before call to recursive function getCategoryList
39 0.79570698738098 Start of GetCategoryList function Start of the function
40 0.79570913314819 Before getting categories Query to get specific category list
41 0.79602694511414 After getting sub category list After call to recursive function getCategoryList
42 0.79602909088135 Before getting category custom Before call to function getCategoryCustom
43 0.79879593849182 After getting category custom After call to function getCategoryCustom
44 0.79879808425903 Before getting sub category list Before call to recursive function getCategoryList
45 0.79879903793335 Start of GetCategoryList function Start of the function
46 0.79880094528198 Before getting categories Query to get specific category list
47 0.79917216300964 After getting sub category list After call to recursive function getCategoryList
48 0.79917407035828 Before getting category custom Before call to function getCategoryCustom
49 0.80210113525391 After getting category custom After call to function getCategoryCustom
50 0.80210208892822 Before getting sub category list Before call to recursive function getCategoryList
51 0.80210304260254 Start of GetCategoryList function Start of the function
52 0.80210494995117 Before getting categories Query to get specific category list
53 0.80245614051819 After getting sub category list After call to recursive function getCategoryList
54 0.80245804786682 Before getting category custom Before call to function getCategoryCustom
55 0.80536603927612 After getting category custom After call to function getCategoryCustom
56 0.80536699295044 Before getting sub category list Before call to recursive function getCategoryList
57 0.80536794662476 Start of GetCategoryList function Start of the function
58 0.80537009239197 Before getting categories Query to get specific category list
59 0.80572414398193 After getting sub category list After call to recursive function getCategoryList
60 0.80572509765625 Before getting category custom Before call to function getCategoryCustom
61 0.80848813056946 After getting category custom After call to function getCategoryCustom
62 0.80848908424377 Before getting sub category list Before call to recursive function getCategoryList
63 0.80849003791809 Start of GetCategoryList function Start of the function
64 0.80849194526672 Before getting categories Query to get specific category list
65 0.80886793136597 After getting sub category list After call to recursive function getCategoryList
66 0.80887007713318 End of GetCategoryList function End of the function
67 0.84147214889526 App_after Controller Start Start of the App_after controller (called after the controller of every page)
68 0.84218907356262 Before Get Options Before the call to getOptions in the tpl class
69 0.86765694618225 After Get Options After the call to getOptions in the tpl class
70 0.86768507957458 App_after Controller End End of the App_after controller (called after the controller of every page)
71 0.94320893287659 Finalizing debug Before the debug is output to the page.
72 0.94323110580444 End of App This is the end of the app logging, final timestamp


Query Debug - 238 Database Queries. Total time 0.1933 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00038480758666992
SELECT parameter, value FROM parameters
2 0.0014 0.0014081001281738
SELECT * FROM `bad_bots`
3 0.0004 0.0003960132598877
SET time_zone = 'Europe/London'
4 0.0004 0.00040292739868164
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0008 0.00082707405090332
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.135.198.49\";}'
6 0.0005 0.00049400329589844
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1714174884'
7 0.0005 0.00053095817565918
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00026798248291016
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0011 0.00105881690979
SELECT id FROM pages WHERE pagename = 'categories' LIMIT 1
10 0.0017 0.0017428398132324
SELECT * FROM pages WHERE id = 40
11 0.0007 0.00065207481384277
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0007 0.00065803527832031
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0010 0.00097012519836426
SELECT * FROM pages WHERE pagename = 'categories'
14 0.0004 0.00036883354187012
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0003 0.00031185150146484
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00027704238891602
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.0003 0.00025010108947754
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.0002 0.00023889541625977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00024509429931641
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.00023794174194336
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.0002 0.00023913383483887
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.0002 0.00023984909057617
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.0002 0.00024199485778809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00024294853210449
SELECT * FROM categorygroups WHERE id = '1'
25 0.0051 0.0050821304321289
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.0002 0.00024104118347168
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0003 0.00025296211242676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00033307075500488
SELECT id FROM categories WHERE parent_id = '27'
29 0.0047 0.004709005355835
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.0007 0.00068402290344238
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.0002 0.00024986267089844
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.0002 0.00024294853210449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00024294853210449
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0015959739685059
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.0005 0.00048923492431641
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.0002 0.00024104118347168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00023603439331055
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0016160011291504
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.0003 0.00029301643371582
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0003 0.00028109550476074
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.0002 0.00024580955505371
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00026297569274902
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.00051403045654297
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0003 0.00031495094299316
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0002 0.00023698806762695
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00023913383483887
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00049209594726562
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.00037312507629395
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0003 0.00025105476379395
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.0002 0.0002448558807373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00025391578674316
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00058889389038086
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.0009 0.0009310245513916
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0003 0.0002591609954834
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00024104118347168
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00053286552429199
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0003 0.00028705596923828
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.0002 0.00023484230041504
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.0002 0.00023698806762695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00023889541625977
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00049614906311035
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.0011 0.001060962677002
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.00030708312988281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00023078918457031
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00060796737670898
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0003 0.00030303001403809
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.0002 0.00024890899658203
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0003 0.00025105476379395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00025391578674316
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00030183792114258
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0002 0.00024080276489258
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0004 0.00035905838012695
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0003 0.0003049373626709
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.0003 0.00032281875610352
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0003 0.00026297569274902
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0006 0.00059890747070312
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0734 0.073376893997192
SELECT * FROM ipgeocountries WHERE INET_ATON('3.135.198.49') >= INET_ATON(ip_start) AND INET_ATON('3.135.198.49') <= INET_ATON(ip_end)
78 0.0003 0.00028395652770996
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0003 0.00031590461730957
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0005 0.00053000450134277
SELECT * FROM pages WHERE pagename = 'categories'
81 0.0004 0.00039815902709961
SELECT * FROM categories WHERE parent_id = '0'  AND hidden = 0 ORDER BY sortorder ASC
82 0.0002 0.00024700164794922
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
83 0.0003 0.00029802322387695
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
84 0.0003 0.00026297569274902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
85 0.0003 0.00031304359436035
SELECT id FROM categories WHERE parent_id = '26'
86 0.0003 0.00029206275939941
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 
87 0.0003 0.00030088424682617
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 
88 0.0003 0.00034117698669434
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
89 0.0003 0.00031399726867676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
90 0.0003 0.00032591819763184
SELECT * FROM categorygroups WHERE id = '1'
91 0.0004 0.00039386749267578
SELECT * FROM categories WHERE parent_id = '26'  AND hidden = 0 ORDER BY sortorder ASC
92 0.0005 0.00049781799316406
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
93 0.0003 0.00028705596923828
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
94 0.0003 0.00026988983154297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0004 0.00037288665771484
SELECT id FROM categories WHERE parent_id = '27'
96 0.0004 0.00036907196044922
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 
97 0.0004 0.0003969669342041
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 
98 0.0003 0.00029897689819336
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
99 0.0003 0.00026702880859375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0003 0.00026512145996094
SELECT * FROM categorygroups WHERE id = '1'
101 0.0003 0.00030899047851562
SELECT * FROM categories WHERE parent_id = '27'  AND hidden = 0 ORDER BY sortorder ASC
102 0.0003 0.0003199577331543
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
103 0.0004 0.00041103363037109
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
104 0.0003 0.00027108192443848
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
105 0.0003 0.00028204917907715
SELECT id FROM categories WHERE parent_id = '28'
106 0.0002 0.00024795532226562
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 
107 0.0003 0.00025486946105957
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 
108 0.0002 0.00024986267089844
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
109 0.0003 0.00031805038452148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
110 0.0003 0.00030112266540527
SELECT * FROM categorygroups WHERE id = '1'
111 0.0004 0.00036191940307617
SELECT * FROM categories WHERE parent_id = '28'  AND hidden = 0 ORDER BY sortorder ASC
112 0.0004 0.00035810470581055
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
113 0.0003 0.00027799606323242
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
114 0.0003 0.00032711029052734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
115 0.0003 0.00028705596923828
SELECT id FROM categories WHERE parent_id = '29'
116 0.0003 0.00028395652770996
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 
117 0.0003 0.00032496452331543
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 
118 0.0003 0.00029993057250977
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
119 0.0004 0.00038003921508789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
120 0.0003 0.00030994415283203
SELECT * FROM categorygroups WHERE id = '1'
121 0.0003 0.00034284591674805
SELECT * FROM categories WHERE parent_id = '29'  AND hidden = 0 ORDER BY sortorder ASC
122 0.0003 0.00030303001403809
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
123 0.0003 0.00031900405883789
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
124 0.0003 0.00031900405883789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
125 0.0003 0.00032305717468262
SELECT id FROM categories WHERE parent_id = '30'
126 0.0003 0.0003211498260498
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 
127 0.0003 0.00031805038452148
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
128 0.0003 0.00029897689819336
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
129 0.0003 0.00030803680419922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
130 0.0003 0.00031685829162598
SELECT * FROM categorygroups WHERE id = '1'
131 0.0003 0.00034499168395996
SELECT * FROM categories WHERE parent_id = '30'  AND hidden = 0 ORDER BY sortorder ASC
132 0.0003 0.00029301643371582
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
133 0.0003 0.00029706954956055
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
134 0.0004 0.00035405158996582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
135 0.0003 0.0002751350402832
SELECT id FROM categories WHERE parent_id = '31'
136 0.0003 0.00026893615722656
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 
137 0.0003 0.00029420852661133
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 
138 0.0003 0.0002739429473877
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
139 0.0003 0.00027894973754883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
140 0.0003 0.00031614303588867
SELECT * FROM categorygroups WHERE id = '1'
141 0.0004 0.0003669261932373
SELECT * FROM categories WHERE parent_id = '31'  AND hidden = 0 ORDER BY sortorder ASC
142 0.0005 0.00049805641174316
SELECT id FROM categories WHERE parent_id = '26'
143 0.0013 0.0013020038604736
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
144 0.0005 0.00048303604125977
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
145 0.0003 0.00027894973754883
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
146 0.0003 0.0003349781036377
SELECT * FROM categoryimages WHERE category_id = 26
147 0.0003 0.00032305717468262
SELECT id FROM categories WHERE parent_id = '27'
148 0.0112 0.01120400428772
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
149 0.0005 0.000518798828125
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
150 0.0003 0.00033211708068848
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
151 0.0003 0.00027704238891602
SELECT * FROM categoryimages WHERE category_id = 27
152 0.0003 0.00029087066650391
SELECT id FROM categories WHERE parent_id = '28'
153 0.0032 0.0031521320343018
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
154 0.0005 0.00050592422485352
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
155 0.0003 0.00026512145996094
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
156 0.0012 0.001183032989502
SELECT * FROM categoryimages WHERE category_id = 28
157 0.0011 0.0010910034179688
SELECT id FROM categories WHERE parent_id = '29'
158 0.0010 0.0010030269622803
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
159 0.0013 0.0012860298156738
SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
160 0.0004 0.00036096572875977
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
161 0.0007 0.00065088272094727
SELECT * FROM categoryimages WHERE category_id = 29
162 0.0003 0.00030899047851562
SELECT id FROM categories WHERE parent_id = '30'
163 0.0008 0.00076699256896973
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
164 0.0004 0.00039100646972656
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
165 0.0003 0.00026893615722656
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
166 0.0003 0.00034189224243164
SELECT * FROM categoryimages WHERE category_id = 30
167 0.0021 0.002100944519043
SELECT id FROM categories WHERE parent_id = '31'
168 0.0011 0.0010919570922852
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
169 0.0003 0.00032806396484375
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
170 0.0003 0.00028181076049805
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
171 0.0004 0.00037908554077148
SELECT * FROM categoryimages WHERE category_id = 31
172 0.0004 0.00037908554077148
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
173 0.0003 0.00029587745666504
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
174 0.0003 0.00031399726867676
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
175 0.0004 0.00035810470581055
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
176 0.0003 0.00031805038452148
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
177 0.0003 0.00030398368835449
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
178 0.0004 0.00041794776916504
SELECT * FROM products WHERE id = 1626
179 0.0005 0.00049114227294922
SELECT * FROM products WHERE id = 4041
180 0.0005 0.00049901008605957
SELECT * FROM products WHERE id = 4312
181 0.0005 0.00048184394836426
SELECT * FROM products WHERE id = 777
182 0.0005 0.00053191184997559
SELECT * FROM products WHERE id = 4213
183 0.0005 0.00051403045654297
SELECT * FROM products WHERE id = 3881
184 0.0006 0.00064706802368164
SELECT * FROM products WHERE id = '1626'
185 0.0003 0.0002739429473877
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
186 0.0003 0.00025296211242676
SELECT * FROM product_image_select WHERE product_id = '1626'
187 0.0002 0.00024890899658203
SELECT * FROM productcustomimages WHERE product_id = '1626'
188 0.0003 0.00030398368835449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
189 0.0003 0.00033307075500488
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
190 0.0003 0.00028300285339355
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0002 0.00024318695068359
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0004 0.00037384033203125
SELECT * FROM products WHERE id = '4041'
193 0.0003 0.00030779838562012
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
194 0.0002 0.00024509429931641
SELECT * FROM product_image_select WHERE product_id = '4041'
195 0.0003 0.00027298927307129
SELECT * FROM productcustomimages WHERE product_id = '4041'
196 0.0003 0.00030016899108887
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
197 0.0003 0.0003352165222168
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0003 0.00029897689819336
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0003 0.00032281875610352
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0004 0.00038504600524902
SELECT * FROM products WHERE id = '4312'
201 0.0003 0.00028300285339355
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
202 0.0003 0.00027894973754883
SELECT * FROM product_image_select WHERE product_id = '4312'
203 0.0003 0.00029993057250977
SELECT * FROM productcustomimages WHERE product_id = '4312'
204 0.0003 0.00032615661621094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
205 0.0003 0.00031709671020508
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0003 0.00032615661621094
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0003 0.00029706954956055
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0004 0.00038790702819824
SELECT * FROM products WHERE id = '777'
209 0.0003 0.00033402442932129
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
210 0.0003 0.00028800964355469
SELECT * FROM product_image_select WHERE product_id = '777'
211 0.0003 0.00029182434082031
SELECT * FROM productcustomimages WHERE product_id = '777'
212 0.0003 0.00031495094299316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
213 0.0003 0.00030803680419922
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0003 0.00031089782714844
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0003 0.00032496452331543
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0004 0.00039005279541016
SELECT * FROM products WHERE id = '4213'
217 0.0005 0.00054001808166504
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
218 0.0003 0.00030303001403809
SELECT * FROM product_image_select WHERE product_id = '4213'
219 0.0004 0.00037813186645508
SELECT * FROM productcustomimages WHERE product_id = '4213'
220 0.0004 0.00035786628723145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
221 0.0004 0.00036501884460449
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0004 0.00036215782165527
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0003 0.00029516220092773
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0005 0.00045514106750488
SELECT * FROM products WHERE id = '3881'
225 0.0003 0.00034284591674805
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
226 0.0003 0.00028705596923828
SELECT * FROM product_image_select WHERE product_id = '3881'
227 0.0004 0.00035905838012695
SELECT * FROM productcustomimages WHERE product_id = '3881'
228 0.0003 0.0003349781036377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
229 0.0004 0.00035786628723145
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0003 0.00032997131347656
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0003 0.00028014183044434
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0010 0.0010299682617188
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
233 0.0005 0.0005340576171875
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
234 0.0006 0.00058794021606445
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
235 0.0007 0.00068211555480957
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
236 0.0006 0.00056290626525879
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
237 0.0005 0.00050997734069824
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
238 0.0007 0.00072479248046875
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'