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
1.9533059597015 244 0.2653 0


No Amazon API Requests Made.


App Debug - Total Time 1.9533059597015 seconds

Number Time From Start Name Description
1 0.99245810508728 Initialise Initialise FSB Function
2 1.0174829959869 App Controller Start Start of the App controller (called before the controller of every page)
3 1.0206570625305 Start of getCategoryListByGroup Function Before first category groups query
4 1.0210461616516 After initial query Before first category groups query
5 1.0210490226746 Get Category List for Group Before the call to getCategoryList function
6 1.0210530757904 Start of GetCategoryList function Start of the function
7 1.0210590362549 Before getting categories Query to get specific category list
8 1.0215640068054 After getting categories Query to get specific category list
9 1.0215671062469 Before getting category custom Before call to function getCategoryCustom
10 1.0248181819916 After getting category custom After call to function getCategoryCustom
11 1.0248241424561 Before getting category custom Before call to function getCategoryCustom
12 1.0493581295013 After getting category custom After call to function getCategoryCustom
13 1.0493631362915 Before getting category custom Before call to function getCategoryCustom
14 1.0568280220032 After getting category custom After call to function getCategoryCustom
15 1.0568330287933 Before getting category custom Before call to function getCategoryCustom
16 1.0604510307312 After getting category custom After call to function getCategoryCustom
17 1.0604569911957 Before getting category custom Before call to function getCategoryCustom
18 1.0638439655304 After getting category custom After call to function getCategoryCustom
19 1.0638489723206 Before getting category custom Before call to function getCategoryCustom
20 1.0673971176147 After getting category custom After call to function getCategoryCustom
21 1.0674021244049 End of GetCategoryList function End of the function
22 1.0674121379852 Get Category List for Group Before the call to getCategoryList function
23 1.0674149990082 Start of GetCategoryList function Start of the function
24 1.0674200057983 Before getting categories Query to get specific category list
25 1.067794084549 End of getCategoryListByGroup Function Before return()
26 1.2185981273651 App Controller End End of the App controller (called before the controller of every page)
27 1.3194291591644 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.3202140331268 Before Get Options Before the call to getOptions in the tpl class
29 1.4261531829834 After Get Options After the call to getOptions in the tpl class
30 1.4262130260468 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.9532880783081 Finalizing debug Before the debug is output to the page.
32 1.9533050060272 End of App This is the end of the app logging, final timestamp


Query Debug - 244 Database Queries. Total time 0.2653 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00051498413085938
SELECT parameter, value FROM parameters
2 0.0012 0.0012149810791016
SELECT * FROM `bad_bots`
3 0.0003 0.00030684471130371
SET time_zone = 'Europe/London'
4 0.0003 0.00030803680419922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0010 0.00099396705627441
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"18.189.43.74\";}'
6 0.0008 0.00082087516784668
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1716086627'
7 0.0012 0.0011739730834961
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00060391426086426
UPDATE autorun SET lastrun = '2024-05-19 02:43:48' WHERE id = '17'
9 0.0003 0.00032305717468262
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0003 0.00032281875610352
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
11 0.0017 0.0017349720001221
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
12 0.0004 0.00035405158996582
SELECT id FROM ebay_products WHERE pagename = 'tag'
13 0.0003 0.00028491020202637
SELECT id FROM custom_products WHERE pagename = 'tag'
14 0.0003 0.00031089782714844
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
15 0.0003 0.00031495094299316
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
16 0.0003 0.00027704238891602
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
17 0.0030 0.0030419826507568
SELECT id FROM tags WHERE pagename = 'menthe' LIMIT 1
18 0.0010 0.0010221004486084
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
19 0.0008 0.00083208084106445
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
20 0.0004 0.00041007995605469
SELECT * FROM pages WHERE pagename = 'tag'
21 0.0004 0.00036907196044922
SELECT * FROM categorygroups ORDER BY sortorder ASC
22 0.0005 0.00047397613525391
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
23 0.0004 0.00035619735717773
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
24 0.0003 0.00031590461730957
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
25 0.0004 0.00035810470581055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
26 0.0003 0.00032496452331543
SELECT id FROM categories WHERE parent_id = '26'
27 0.0004 0.00040388107299805
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 
28 0.0004 0.00037407875061035
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 
29 0.0003 0.0003349781036377
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
30 0.0003 0.00029492378234863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
31 0.0003 0.00031208992004395
SELECT * FROM categorygroups WHERE id = '1'
32 0.0113 0.01131796836853
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
33 0.0004 0.00041985511779785
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
34 0.0003 0.00029802322387695
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
35 0.0003 0.00026893615722656
SELECT id FROM categories WHERE parent_id = '27'
36 0.0106 0.010554075241089
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 
37 0.0004 0.00043511390686035
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 
38 0.0004 0.00039291381835938
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
39 0.0003 0.00033903121948242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
40 0.0003 0.00028491020202637
SELECT * FROM categorygroups WHERE id = '1'
41 0.0027 0.0026760101318359
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
42 0.0003 0.00034093856811523
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
43 0.0003 0.00033402442932129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
44 0.0003 0.0002591609954834
SELECT id FROM categories WHERE parent_id = '28'
45 0.0025 0.0025310516357422
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 
46 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 (28)
				  AND p.disabled = 0 
47 0.0003 0.00028800964355469
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
48 0.0003 0.00026988983154297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
49 0.0003 0.0002591609954834
SELECT * FROM categorygroups WHERE id = '1'
50 0.0006 0.00064611434936523
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
51 0.0003 0.00026702880859375
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
52 0.0003 0.0002739429473877
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
53 0.0003 0.00027108192443848
SELECT id FROM categories WHERE parent_id = '29'
54 0.0007 0.00067996978759766
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 
55 0.0003 0.00029611587524414
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 
56 0.0005 0.00047397613525391
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
57 0.0003 0.00026297569274902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
58 0.0003 0.0002591609954834
SELECT * FROM categorygroups WHERE id = '1'
59 0.0006 0.0005791187286377
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
60 0.0003 0.0002589225769043
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
61 0.0003 0.00025606155395508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
62 0.0003 0.00029993057250977
SELECT id FROM categories WHERE parent_id = '30'
63 0.0007 0.00069284439086914
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 
64 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 
65 0.0003 0.00027298927307129
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
66 0.0003 0.00025200843811035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
67 0.0003 0.00027608871459961
SELECT * FROM categorygroups WHERE id = '1'
68 0.0006 0.00063800811767578
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
69 0.0003 0.00027108192443848
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
70 0.0003 0.00025796890258789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
71 0.0003 0.00029110908508301
SELECT id FROM categories WHERE parent_id = '31'
72 0.0008 0.00075006484985352
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 
73 0.0003 0.00026106834411621
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 
74 0.0004 0.00038409233093262
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
75 0.0003 0.00025200843811035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
76 0.0003 0.0002748966217041
SELECT * FROM categorygroups WHERE id = '1'
77 0.0004 0.00035786628723145
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
78 0.0003 0.00031709671020508
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
79 0.0003 0.00030112266540527
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
80 0.0006 0.00059199333190918
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
81 0.0005 0.0005030632019043
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
82 0.0004 0.00035285949707031
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
83 0.0009 0.00091791152954102
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
84 0.0787 0.078724145889282
SELECT * FROM ipgeocountries WHERE INET_ATON('18.189.43.74') >= INET_ATON(ip_start) AND INET_ATON('18.189.43.74') <= INET_ATON(ip_end)
85 0.0007 0.00066399574279785
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
86 0.0003 0.00031900405883789
SELECT * FROM countryredirects WHERE countrycode = 'US'
87 0.0033 0.0032649040222168
SELECT * FROM tags WHERE pagename = 'menthe'
88 0.0105 0.010494947433472
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
89 0.0004 0.00037503242492676
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0003 0.0003049373626709
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0003 0.00033688545227051
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
92 0.0003 0.00033211708068848
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
93 0.0003 0.00030708312988281
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
94 0.0010 0.0010321140289307
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND parent_id = 0 AND t.tag_id = '521' AND hidden = 0 AND enabled = 1  AND 1 = 1
95 0.0024 0.0023880004882812
SELECT DISTINCT(p.id), p.*, IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank FROM products p, product_tags t WHERE p.id = t.product_id AND p.parent_id = 0 AND t.tag_id = '521' AND hidden = 0 AND enabled = 1  AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
96 0.0009 0.00094795227050781
SELECT * FROM productimages WHERE product_id = '970' ORDER BY sortorder ASC
97 0.0005 0.00054693222045898
SELECT * FROM product_image_select WHERE product_id = '970'
98 0.0005 0.00046586990356445
SELECT * FROM productcustomimages WHERE product_id = '970'
99 0.0028 0.0028231143951416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '970' AND a.name = n.originalname
100 0.0007 0.00065398216247559
SELECT * FROM productoffers WHERE product_id = '970' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0006 0.00057601928710938
SELECT * FROM productoffers
                WHERE product_id = '970' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0006 0.00057792663574219
SELECT value FROM productattributes WHERE product_id = '970' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
103 0.0007 0.00073409080505371
SELECT * FROM productimages WHERE product_id = '1217' ORDER BY sortorder ASC
104 0.0006 0.0005648136138916
SELECT * FROM product_image_select WHERE product_id = '1217'
105 0.0005 0.00047588348388672
SELECT * FROM productcustomimages WHERE product_id = '1217'
106 0.0032 0.0031728744506836
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1217' AND a.name = n.originalname
107 0.0006 0.00064396858215332
SELECT * FROM productoffers WHERE product_id = '1217' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0006 0.0005500316619873
SELECT * FROM productoffers
                WHERE product_id = '1217' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0006 0.00063395500183105
SELECT value FROM productattributes WHERE product_id = '1217' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0003 0.00030994415283203
SELECT * FROM productimages WHERE product_id = '4907' ORDER BY sortorder ASC
111 0.0003 0.00030398368835449
SELECT * FROM product_image_select WHERE product_id = '4907'
112 0.0003 0.00027298927307129
SELECT * FROM productcustomimages WHERE product_id = '4907'
113 0.0003 0.00026321411132812
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4907' AND a.name = n.originalname
114 0.0003 0.00028204917907715
SELECT * FROM productoffers WHERE product_id = '4907' AND merchantid = 'A1X6FK5RDHNB96'
115 0.0004 0.00044798851013184
SELECT * FROM productoffers
                WHERE product_id = '4907' AND price > 0
                ORDER BY price ASC LIMIT 1
116 0.0003 0.00026702880859375
SELECT value FROM productattributes WHERE product_id = '4907' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0006 0.00058507919311523
SELECT * FROM productimages WHERE product_id = '1126' ORDER BY sortorder ASC
118 0.0005 0.00053691864013672
SELECT * FROM product_image_select WHERE product_id = '1126'
119 0.0005 0.00047016143798828
SELECT * FROM productcustomimages WHERE product_id = '1126'
120 0.0011 0.0011491775512695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1126' AND a.name = n.originalname
121 0.0006 0.00062680244445801
SELECT * FROM productoffers WHERE product_id = '1126' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0006 0.00061893463134766
SELECT * FROM productoffers
                WHERE product_id = '1126' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0005 0.00050997734069824
SELECT * FROM productoffers
                WHERE product_id = 1126
                ORDER BY price ASC LIMIT 1
124 0.0006 0.00056815147399902
SELECT value FROM productattributes
                WHERE product_id = '1126'
                AND name = 'ListPriceAmount'
125 0.0007 0.00068092346191406
SELECT value FROM productattributes WHERE product_id = '1126' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0007 0.00066184997558594
SELECT * FROM productimages WHERE product_id = '875' ORDER BY sortorder ASC
127 0.0006 0.00058794021606445
SELECT * FROM product_image_select WHERE product_id = '875'
128 0.0006 0.00061702728271484
SELECT * FROM productcustomimages WHERE product_id = '875'
129 0.0019 0.0018861293792725
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '875' AND a.name = n.originalname
130 0.0006 0.00064301490783691
SELECT * FROM productoffers WHERE product_id = '875' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0005 0.00053596496582031
SELECT * FROM productoffers
                WHERE product_id = '875' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0005 0.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = 875
                ORDER BY price ASC LIMIT 1
133 0.0005 0.00053191184997559
SELECT value FROM productattributes
                WHERE product_id = '875'
                AND name = 'ListPriceAmount'
134 0.0006 0.00062894821166992
SELECT value FROM productattributes WHERE product_id = '875' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0011 0.0011389255523682
SELECT * FROM productimages WHERE product_id = '908' ORDER BY sortorder ASC
136 0.0006 0.00055694580078125
SELECT * FROM product_image_select WHERE product_id = '908'
137 0.0005 0.0004880428314209
SELECT * FROM productcustomimages WHERE product_id = '908'
138 0.0015 0.001507043838501
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '908' AND a.name = n.originalname
139 0.0006 0.00064706802368164
SELECT * FROM productoffers WHERE product_id = '908' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0013 0.0013260841369629
SELECT * FROM productoffers
                WHERE product_id = '908' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0006 0.0006098747253418
SELECT * FROM productoffers
                WHERE product_id = 908
                ORDER BY price ASC LIMIT 1
142 0.0006 0.0005650520324707
SELECT value FROM productattributes
                WHERE product_id = '908'
                AND name = 'ListPriceAmount'
143 0.0006 0.00059795379638672
SELECT value FROM productattributes WHERE product_id = '908' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0007 0.00065493583679199
SELECT * FROM productimages WHERE product_id = '955' ORDER BY sortorder ASC
145 0.0005 0.0005347728729248
SELECT * FROM product_image_select WHERE product_id = '955'
146 0.0005 0.00048089027404785
SELECT * FROM productcustomimages WHERE product_id = '955'
147 0.0014 0.0014259815216064
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '955' AND a.name = n.originalname
148 0.0006 0.00062799453735352
SELECT * FROM productoffers WHERE product_id = '955' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0007 0.0006721019744873
SELECT * FROM productoffers
                WHERE product_id = '955' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0005 0.00049805641174316
SELECT * FROM productoffers
                WHERE product_id = 955
                ORDER BY price ASC LIMIT 1
151 0.0005 0.00054717063903809
SELECT value FROM productattributes
                WHERE product_id = '955'
                AND name = 'ListPriceAmount'
152 0.0006 0.00062704086303711
SELECT value FROM productattributes WHERE product_id = '955' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0008 0.00079488754272461
SELECT * FROM productimages WHERE product_id = '1007' ORDER BY sortorder ASC
154 0.0006 0.00057196617126465
SELECT * FROM product_image_select WHERE product_id = '1007'
155 0.0005 0.00047993659973145
SELECT * FROM productcustomimages WHERE product_id = '1007'
156 0.0010 0.0010490417480469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1007' AND a.name = n.originalname
157 0.0007 0.00066184997558594
SELECT * FROM productoffers WHERE product_id = '1007' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0006 0.00060391426086426
SELECT * FROM productoffers
                WHERE product_id = '1007' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0007 0.00068283081054688
SELECT value FROM productattributes WHERE product_id = '1007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0003 0.00030398368835449
SELECT * FROM productimages WHERE product_id = '1260' ORDER BY sortorder ASC
161 0.0003 0.00029706954956055
SELECT * FROM product_image_select WHERE product_id = '1260'
162 0.0003 0.00033283233642578
SELECT * FROM productcustomimages WHERE product_id = '1260'
163 0.0003 0.00029611587524414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1260' AND a.name = n.originalname
164 0.0003 0.00033903121948242
SELECT * FROM productoffers WHERE product_id = '1260' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0003 0.00026607513427734
SELECT * FROM productoffers
                WHERE product_id = '1260' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0003 0.00029492378234863
SELECT * FROM productoffers
                WHERE product_id = 1260
                ORDER BY price ASC LIMIT 1
167 0.0004 0.0003659725189209
SELECT value FROM productattributes
                WHERE product_id = '1260'
                AND name = 'ListPriceAmount'
168 0.0003 0.00026488304138184
SELECT value FROM productattributes WHERE product_id = '1260' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0006 0.00061583518981934
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '970' ORDER BY timestamp DESC
170 0.0004 0.00043392181396484
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1217' ORDER BY timestamp DESC
171 0.0003 0.00032615661621094
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4907' ORDER BY timestamp DESC
172 0.0004 0.00040793418884277
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1126' ORDER BY timestamp DESC
173 0.0004 0.00038981437683105
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '875' ORDER BY timestamp DESC
174 0.0004 0.0004279613494873
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '908' ORDER BY timestamp DESC
175 0.0004 0.00038409233093262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '955' ORDER BY timestamp DESC
176 0.0004 0.00041604042053223
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1007' ORDER BY timestamp DESC
177 0.0004 0.00035691261291504
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1260' ORDER BY timestamp DESC
178 0.0004 0.00035405158996582
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
179 0.0003 0.00031805038452148
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
180 0.0004 0.0003659725189209
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
181 0.0003 0.00029492378234863
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
182 0.0003 0.00027084350585938
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
183 0.0004 0.0003659725189209
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
184 0.0005 0.00045609474182129
SELECT * FROM products WHERE id = 1626
185 0.0004 0.00036883354187012
SELECT * FROM products WHERE id = 4041
186 0.0004 0.00043797492980957
SELECT * FROM products WHERE id = 4312
187 0.0004 0.00042319297790527
SELECT * FROM products WHERE id = 777
188 0.0005 0.00050497055053711
SELECT * FROM products WHERE id = 4213
189 0.0005 0.00052189826965332
SELECT * FROM products WHERE id = 3881
190 0.0008 0.00077295303344727
SELECT * FROM products WHERE id = '1626'
191 0.0006 0.00058603286743164
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
192 0.0004 0.00044798851013184
SELECT * FROM product_image_select WHERE product_id = '1626'
193 0.0003 0.0003359317779541
SELECT * FROM productcustomimages WHERE product_id = '1626'
194 0.0003 0.00030207633972168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
195 0.0004 0.00036311149597168
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0007 0.00067400932312012
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0004 0.0003821849822998
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0004 0.00037503242492676
SELECT * FROM products WHERE id = '4041'
199 0.0004 0.00035405158996582
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
200 0.0004 0.00035190582275391
SELECT * FROM product_image_select WHERE product_id = '4041'
201 0.0083 0.0083069801330566
SELECT * FROM productcustomimages WHERE product_id = '4041'
202 0.0004 0.00037908554077148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
203 0.0062 0.0062060356140137
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0111 0.011124134063721
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0004 0.00043892860412598
SELECT * FROM products WHERE id = '4312'
207 0.0003 0.00031304359436035
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
208 0.0003 0.00027894973754883
SELECT * FROM product_image_select WHERE product_id = '4312'
209 0.0003 0.00029802322387695
SELECT * FROM productcustomimages WHERE product_id = '4312'
210 0.0003 0.00032711029052734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
211 0.0004 0.00040388107299805
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0003 0.00032210350036621
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0003 0.00025796890258789
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0003 0.0003361701965332
SELECT * FROM products WHERE id = '777'
215 0.0003 0.00028395652770996
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
216 0.0003 0.00029206275939941
SELECT * FROM product_image_select WHERE product_id = '777'
217 0.0003 0.00027680397033691
SELECT * FROM productcustomimages WHERE product_id = '777'
218 0.0003 0.00028491020202637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
219 0.0003 0.00026893615722656
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0003 0.00032901763916016
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0003 0.00030994415283203
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0004 0.00037598609924316
SELECT * FROM products WHERE id = '4213'
223 0.0005 0.0004580020904541
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
224 0.0003 0.00027894973754883
SELECT * FROM product_image_select WHERE product_id = '4213'
225 0.0003 0.00026702880859375
SELECT * FROM productcustomimages WHERE product_id = '4213'
226 0.0003 0.00028705596923828
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
227 0.0003 0.00026798248291016
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0003 0.00029492378234863
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0002 0.0002439022064209
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0004 0.00035905838012695
SELECT * FROM products WHERE id = '3881'
231 0.0003 0.00034999847412109
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
232 0.0003 0.0003058910369873
SELECT * FROM product_image_select WHERE product_id = '3881'
233 0.0003 0.00029087066650391
SELECT * FROM productcustomimages WHERE product_id = '3881'
234 0.0003 0.00032711029052734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
235 0.0003 0.00028300285339355
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0003 0.00030398368835449
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0003 0.00032496452331543
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0004 0.00040197372436523
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
239 0.0005 0.00050497055053711
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
240 0.0008 0.00079607963562012
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
241 0.0006 0.00055193901062012
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
242 0.0006 0.00062203407287598
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
243 0.0005 0.00053191184997559
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
244 0.0005 0.00048089027404785
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'