0

Vert

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.4884600639343 219 1.1479 0


No Amazon API Requests Made.


App Debug - Total Time 1.4884600639343 seconds

Number Time From Start Name Description
1 0.29086017608643 Initialise Initialise FSB Function
2 0.30540299415588 App Controller Start Start of the App controller (called before the controller of every page)
3 0.34338402748108 Start of getCategoryListByGroup Function Before first category groups query
4 0.34441304206848 After initial query Before first category groups query
5 0.34441304206848 Get Category List for Group Before the call to getCategoryList function
6 0.34441494941711 Start of GetCategoryList function Start of the function
7 0.34441709518433 Before getting categories Query to get specific category list
8 0.34486794471741 After getting categories Query to get specific category list
9 0.3448691368103 Before getting category custom Before call to function getCategoryCustom
10 0.35890817642212 After getting category custom After call to function getCategoryCustom
11 0.35891103744507 Before getting category custom Before call to function getCategoryCustom
12 0.36882209777832 After getting category custom After call to function getCategoryCustom
13 0.36882400512695 Before getting category custom Before call to function getCategoryCustom
14 0.37349605560303 After getting category custom After call to function getCategoryCustom
15 0.37349796295166 Before getting category custom Before call to function getCategoryCustom
16 0.37707495689392 After getting category custom After call to function getCategoryCustom
17 0.37707614898682 Before getting category custom Before call to function getCategoryCustom
18 0.38030505180359 After getting category custom After call to function getCategoryCustom
19 0.38030695915222 Before getting category custom Before call to function getCategoryCustom
20 0.383455991745 After getting category custom After call to function getCategoryCustom
21 0.38345813751221 End of GetCategoryList function End of the function
22 0.38346314430237 Get Category List for Group Before the call to getCategoryList function
23 0.383465051651 Start of GetCategoryList function Start of the function
24 0.38346600532532 Before getting categories Query to get specific category list
25 0.38382411003113 End of getCategoryListByGroup Function Before return()
26 1.3214380741119 App Controller End End of the App controller (called before the controller of every page)
27 1.3910210132599 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.3956770896912 Before Get Options Before the call to getOptions in the tpl class
29 1.4396481513977 After Get Options After the call to getOptions in the tpl class
30 1.4396810531616 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.4884510040283 Finalizing debug Before the debug is output to the page.
32 1.4884600639343 End of App This is the end of the app logging, final timestamp


Query Debug - 219 Database Queries. Total time 1.1479 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0015 0.0015408992767334
SELECT parameter, value FROM parameters
2 0.0055 0.0054721832275391
SELECT * FROM `bad_bots`
3 0.0007 0.00065207481384277
SET time_zone = 'Europe/London'
4 0.0019 0.0019280910491943
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0095 0.0094578266143799
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.66\";}'
6 0.0014 0.0014359951019287
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751752493'
7 0.0019 0.0018670558929443
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00061607360839844
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0016 0.0015950202941895
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
10 0.0020 0.0019850730895996
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
11 0.0016 0.0016450881958008
SELECT id FROM ebay_products WHERE pagename = 'tag'
12 0.0015 0.0015139579772949
SELECT id FROM custom_products WHERE pagename = 'tag'
13 0.0015 0.001453161239624
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
14 0.0014 0.0013699531555176
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
15 0.0013 0.0012819766998291
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
16 0.0024 0.0023789405822754
SELECT id FROM tags WHERE pagename = 'vert' LIMIT 1
17 0.0037 0.0037040710449219
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
18 0.0331 0.033097982406616
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
19 0.0008 0.00080084800720215
SELECT * FROM pages WHERE pagename = 'tag'
20 0.0010 0.0010230541229248
SELECT * FROM categorygroups ORDER BY sortorder ASC
21 0.0004 0.0004429817199707
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
22 0.0056 0.0055820941925049
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
23 0.0004 0.00037503242492676
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
24 0.0007 0.00074100494384766
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
25 0.0003 0.00034594535827637
SELECT id FROM categories WHERE parent_id = '26'
26 0.0047 0.0046610832214355
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 
27 0.0004 0.00039291381835938
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 
28 0.0004 0.0003969669342041
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
29 0.0011 0.0011160373687744
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
30 0.0003 0.00032806396484375
SELECT * FROM categorygroups WHERE id = '1'
31 0.0042 0.0041670799255371
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
32 0.0005 0.00049495697021484
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
33 0.0003 0.00032806396484375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
34 0.0003 0.00031304359436035
SELECT id FROM categories WHERE parent_id = '27'
35 0.0030 0.0030369758605957
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 
36 0.0005 0.00047612190246582
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 
37 0.0004 0.00038290023803711
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
38 0.0003 0.00034618377685547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
39 0.0003 0.00030899047851562
SELECT * FROM categorygroups WHERE id = '1'
40 0.0011 0.001143217086792
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
41 0.0003 0.00031781196594238
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
42 0.0003 0.00028800964355469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
43 0.0003 0.00032615661621094
SELECT id FROM categories WHERE parent_id = '28'
44 0.0012 0.0012378692626953
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 
45 0.0003 0.00034713745117188
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 
46 0.0004 0.00035309791564941
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
47 0.0003 0.00031900405883789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
48 0.0003 0.00029301643371582
SELECT * FROM categorygroups WHERE id = '1'
49 0.0004 0.00042080879211426
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
50 0.0003 0.00030994415283203
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
51 0.0003 0.00029587745666504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
52 0.0003 0.00030112266540527
SELECT id FROM categories WHERE parent_id = '29'
53 0.0005 0.00047397613525391
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 
54 0.0006 0.00062394142150879
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 
55 0.0004 0.00044608116149902
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
56 0.0003 0.00033402442932129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
57 0.0003 0.00031304359436035
SELECT * FROM categorygroups WHERE id = '1'
58 0.0004 0.00043892860412598
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
59 0.0003 0.00034499168395996
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
60 0.0003 0.00029110908508301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
61 0.0003 0.00031399726867676
SELECT id FROM categories WHERE parent_id = '30'
62 0.0004 0.00044417381286621
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 
63 0.0003 0.00034785270690918
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 
64 0.0004 0.00035595893859863
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
65 0.0003 0.00034809112548828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
66 0.0003 0.00029397010803223
SELECT * FROM categorygroups WHERE id = '1'
67 0.0004 0.00040602684020996
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
68 0.0003 0.00031304359436035
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
69 0.0003 0.00028395652770996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
70 0.0003 0.00029683113098145
SELECT id FROM categories WHERE parent_id = '31'
71 0.0005 0.00048613548278809
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 
72 0.0003 0.00034093856811523
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 
73 0.0004 0.00035309791564941
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
74 0.0003 0.00030803680419922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
75 0.0003 0.00031399726867676
SELECT * FROM categorygroups WHERE id = '1'
76 0.0004 0.0003511905670166
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
77 0.0013 0.0013060569763184
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
78 0.0009 0.00093507766723633
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
79 0.0004 0.00040483474731445
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
80 0.0007 0.00069189071655273
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
81 0.0009 0.00089693069458008
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
82 0.0006 0.00057506561279297
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
83 0.9285 0.92854380607605
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.66') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.66') <= INET_ATON(ip_end)
84 0.0018 0.001762866973877
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
85 0.0008 0.00080513954162598
SELECT * FROM countryredirects WHERE countrycode = 'US'
86 0.0091 0.0091288089752197
SELECT * FROM tags WHERE pagename = 'vert'
87 0.0051 0.0050551891326904
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
88 0.0015 0.0015029907226562
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
89 0.0013 0.001338005065918
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
90 0.0055 0.005465030670166
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
91 0.0014 0.00142502784729
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
92 0.0006 0.00055098533630371
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
93 0.0011 0.0011329650878906
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 = '201' AND hidden = 0 AND enabled = 1  AND 1 = 1
94 0.0009 0.00093293190002441
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 = '201' AND hidden = 0 AND enabled = 1  AND 1 = 1 ORDER BY salesrank ASC LIMIT 36, 18
95 0.0008 0.00079798698425293
SELECT * FROM productimages WHERE product_id = '1086' ORDER BY sortorder ASC
96 0.0008 0.00083088874816895
SELECT * FROM product_image_select WHERE product_id = '1086'
97 0.0006 0.00059294700622559
SELECT * FROM productcustomimages WHERE product_id = '1086'
98 0.0010 0.0009760856628418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1086' AND a.name = n.originalname
99 0.0007 0.00068998336791992
SELECT * FROM productoffers WHERE product_id = '1086' AND merchantid = 'A1X6FK5RDHNB96'
100 0.0003 0.00025796890258789
SELECT * FROM productoffers
                WHERE product_id = '1086' AND price > 0
                ORDER BY price ASC LIMIT 1
101 0.0003 0.00034308433532715
SELECT * FROM productoffers
                WHERE product_id = 1086
                ORDER BY price ASC LIMIT 1
102 0.0004 0.00037598609924316
SELECT value FROM productattributes
                WHERE product_id = '1086'
                AND name = 'ListPriceAmount'
103 0.0005 0.00047111511230469
SELECT value FROM productattributes WHERE product_id = '1086' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
104 0.0004 0.00044703483581543
SELECT * FROM productimages WHERE product_id = '1260' ORDER BY sortorder ASC
105 0.0005 0.0004580020904541
SELECT * FROM product_image_select WHERE product_id = '1260'
106 0.0003 0.00031805038452148
SELECT * FROM productcustomimages WHERE product_id = '1260'
107 0.0005 0.00054097175598145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1260' AND a.name = n.originalname
108 0.0003 0.00030612945556641
SELECT * FROM productoffers WHERE product_id = '1260' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0002 0.00024199485778809
SELECT * FROM productoffers
                WHERE product_id = '1260' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0002 0.00023698806762695
SELECT * FROM productoffers
                WHERE product_id = 1260
                ORDER BY price ASC LIMIT 1
111 0.0002 0.00024700164794922
SELECT value FROM productattributes
                WHERE product_id = '1260'
                AND name = 'ListPriceAmount'
112 0.0003 0.0003058910369873
SELECT value FROM productattributes WHERE product_id = '1260' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0003 0.00032615661621094
SELECT * FROM productimages WHERE product_id = '999' ORDER BY sortorder ASC
114 0.0005 0.00049090385437012
SELECT * FROM product_image_select WHERE product_id = '999'
115 0.0003 0.00027012825012207
SELECT * FROM productcustomimages WHERE product_id = '999'
116 0.0005 0.00049901008605957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '999' AND a.name = n.originalname
117 0.0003 0.0003349781036377
SELECT * FROM productoffers WHERE product_id = '999' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0002 0.00024914741516113
SELECT * FROM productoffers
                WHERE product_id = '999' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = 999
                ORDER BY price ASC LIMIT 1
120 0.0003 0.0002601146697998
SELECT value FROM productattributes
                WHERE product_id = '999'
                AND name = 'ListPriceAmount'
121 0.0003 0.00027012825012207
SELECT value FROM productattributes WHERE product_id = '999' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0003 0.00031805038452148
SELECT * FROM productimages WHERE product_id = '958' ORDER BY sortorder ASC
123 0.0004 0.0004420280456543
SELECT * FROM product_image_select WHERE product_id = '958'
124 0.0003 0.00027012825012207
SELECT * FROM productcustomimages WHERE product_id = '958'
125 0.0005 0.00051307678222656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '958' AND a.name = n.originalname
126 0.0003 0.0003199577331543
SELECT * FROM productoffers WHERE product_id = '958' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0002 0.00024199485778809
SELECT * FROM productoffers
                WHERE product_id = '958' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = 958
                ORDER BY price ASC LIMIT 1
129 0.0002 0.00024819374084473
SELECT value FROM productattributes
                WHERE product_id = '958'
                AND name = 'ListPriceAmount'
130 0.0003 0.00026106834411621
SELECT value FROM productattributes WHERE product_id = '958' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0003 0.0003199577331543
SELECT * FROM productimages WHERE product_id = '932' ORDER BY sortorder ASC
132 0.0004 0.00037717819213867
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '932' AND p.id = pi.product_id ORDER BY pi.sortorder
133 0.0005 0.00046277046203613
SELECT * FROM product_image_select WHERE product_id = '932'
134 0.0003 0.00027894973754883
SELECT * FROM productcustomimages WHERE product_id = '932'
135 0.0004 0.00035881996154785
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 = '932'
                GROUP BY o.product_id
136 0.0014 0.0014479160308838
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     = '932'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
137 0.0003 0.00033998489379883
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 932
138 0.0006 0.00061202049255371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '932' AND a.name = n.originalname
139 0.0002 0.00023603439331055
SELECT * FROM productoffers WHERE product_id = '932' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = '932' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0003 0.00025486946105957
SELECT * FROM productoffers
                WHERE product_id = 932
                ORDER BY price ASC LIMIT 1
142 0.0002 0.00023794174194336
SELECT value FROM productattributes
                WHERE product_id = '932'
                AND name = 'ListPriceAmount'
143 0.0003 0.00026583671569824
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 = '932'
                GROUP BY o.product_id
144 0.0004 0.00040507316589355
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     = '932'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
145 0.0003 0.00027298927307129
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 932
146 0.0004 0.00035381317138672
SELECT value FROM productattributes WHERE product_id = '932' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0004 0.00043606758117676
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '932'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
148 0.0007 0.00074481964111328
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1086' ORDER BY timestamp DESC
149 0.0002 0.00022220611572266
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1260' ORDER BY timestamp DESC
150 0.0002 0.00020194053649902
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '999' ORDER BY timestamp DESC
151 0.0002 0.00021791458129883
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '958' ORDER BY timestamp DESC
152 0.0002 0.00020790100097656
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '932' ORDER BY timestamp DESC
153 0.0007 0.0007469654083252
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
154 0.0014 0.0014069080352783
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
155 0.0032 0.0031960010528564
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
156 0.0175 0.017515897750854
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
157 0.0010 0.0010128021240234
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
158 0.0004 0.00037312507629395
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
159 0.0004 0.00037789344787598
SELECT * FROM products WHERE id = 1626
160 0.0003 0.00025105476379395
SELECT * FROM products WHERE id = 4041
161 0.0003 0.00029110908508301
SELECT * FROM products WHERE id = 4312
162 0.0002 0.00023913383483887
SELECT * FROM products WHERE id = 777
163 0.0002 0.00024986267089844
SELECT * FROM products WHERE id = 3881
164 0.0003 0.00025510787963867
SELECT * FROM products WHERE id = 4213
165 0.0002 0.00023698806762695
SELECT * FROM products WHERE id = '1626'
166 0.0003 0.00031208992004395
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
167 0.0004 0.00043892860412598
SELECT * FROM product_image_select WHERE product_id = '1626'
168 0.0003 0.0002748966217041
SELECT * FROM productcustomimages WHERE product_id = '1626'
169 0.0006 0.00057601928710938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
170 0.0003 0.00033998489379883
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0003 0.00026082992553711
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0003 0.0002748966217041
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0004 0.00035905838012695
SELECT * FROM products WHERE id = '4041'
174 0.0003 0.00031495094299316
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
175 0.0005 0.00045204162597656
SELECT * FROM product_image_select WHERE product_id = '4041'
176 0.0003 0.00027704238891602
SELECT * FROM productcustomimages WHERE product_id = '4041'
177 0.0007 0.00068497657775879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
178 0.0003 0.00034308433532715
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0003 0.00025701522827148
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0003 0.00026583671569824
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0003 0.00033783912658691
SELECT * FROM products WHERE id = '4312'
182 0.0003 0.00030708312988281
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
183 0.0005 0.00045394897460938
SELECT * FROM product_image_select WHERE product_id = '4312'
184 0.0003 0.00026583671569824
SELECT * FROM productcustomimages WHERE product_id = '4312'
185 0.0007 0.00069403648376465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
186 0.0003 0.00031805038452148
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0003 0.00025510787963867
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0003 0.00027012825012207
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0003 0.00031495094299316
SELECT * FROM products WHERE id = '777'
190 0.0003 0.00030303001403809
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
191 0.0004 0.00043416023254395
SELECT * FROM product_image_select WHERE product_id = '777'
192 0.0003 0.00025796890258789
SELECT * FROM productcustomimages WHERE product_id = '777'
193 0.0006 0.00064492225646973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
194 0.0003 0.00031280517578125
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0003 0.00026798248291016
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0003 0.00032997131347656
SELECT * FROM products WHERE id = '3881'
198 0.0003 0.00033998489379883
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
199 0.0004 0.0004270076751709
SELECT * FROM product_image_select WHERE product_id = '3881'
200 0.0003 0.00026512145996094
SELECT * FROM productcustomimages WHERE product_id = '3881'
201 0.0007 0.00065994262695312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
202 0.0003 0.00029897689819336
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0002 0.00024986267089844
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0003 0.0002741813659668
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0003 0.0003349781036377
SELECT * FROM products WHERE id = '4213'
206 0.0004 0.00035810470581055
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
207 0.0005 0.00047492980957031
SELECT * FROM product_image_select WHERE product_id = '4213'
208 0.0003 0.00029492378234863
SELECT * FROM productcustomimages WHERE product_id = '4213'
209 0.0009 0.00089812278747559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
210 0.0003 0.00033998489379883
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0003 0.00026798248291016
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0013 0.0013439655303955
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
214 0.0006 0.00060200691223145
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
215 0.0015 0.001474142074585
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
216 0.0008 0.00081706047058105
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
217 0.0004 0.00035405158996582
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
218 0.0005 0.0004580020904541
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
219 0.0005 0.00047898292541504
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'