Contact the Former Military Spouse Team

We are ready to help with whatever you need. To ensure you get a fast and considered response, please contact us via email - simply enter your details below and we will get back to you as soon as possible.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.76381397247314 159 0.1007 0


No Amazon API Requests Made.


App Debug - Total Time 0.76381397247314 seconds

Number Time From Start Name Description
1 0.61783385276794 Initialise Initialise FSB Function
2 0.61937284469604 App Controller Start Start of the App controller (called before the controller of every page)
3 0.62709403038025 Start of getCategoryListByGroup Function Before first category groups query
4 0.62749195098877 After initial query Before first category groups query
5 0.62749290466309 Get Category List for Group Before the call to getCategoryList function
6 0.6274950504303 Start of GetCategoryList function Start of the function
7 0.62749791145325 Before getting categories Query to get specific category list
8 0.62794494628906 After getting categories Query to get specific category list
9 0.62794494628906 Before getting category custom Before call to function getCategoryCustom
10 0.63125085830688 After getting category custom After call to function getCategoryCustom
11 0.63125205039978 Before getting category custom Before call to function getCategoryCustom
12 0.63261294364929 After getting category custom After call to function getCategoryCustom
13 0.63261485099792 Before getting category custom Before call to function getCategoryCustom
14 0.63406205177307 After getting category custom After call to function getCategoryCustom
15 0.6340639591217 Before getting category custom Before call to function getCategoryCustom
16 0.63524389266968 After getting category custom After call to function getCategoryCustom
17 0.63524484634399 End of GetCategoryList function End of the function
18 0.63524794578552 Get Category List for Group Before the call to getCategoryList function
19 0.63524985313416 Start of GetCategoryList function Start of the function
20 0.63525199890137 Before getting categories Query to get specific category list
21 0.63538002967834 End of getCategoryListByGroup Function Before return()
22 0.69330191612244 App Controller End End of the App controller (called before the controller of every page)
23 0.69665789604187 App_after Controller Start Start of the App_after controller (called after the controller of every page)
24 0.69723200798035 Before Get Options Before the call to getOptions in the tpl class
25 0.72558188438416 After Get Options After the call to getOptions in the tpl class
26 0.72563004493713 App_after Controller End End of the App_after controller (called after the controller of every page)
27 0.76379704475403 Finalizing debug Before the debug is output to the page.
28 0.76381397247314 End of App This is the end of the app logging, final timestamp


Query Debug - 159 Database Queries. Total time 0.1007 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00073504447937012
SELECT parameter, value FROM parameters
2 0.0008 0.00084209442138672
SELECT * FROM `bad_bots`
3 0.0008 0.00077295303344727
SET time_zone = 'Europe/London'
4 0.0004 0.00043296813964844
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0015 0.001539945602417
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.231.230.177\";}'
6 0.0008 0.00079011917114258
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1628149830'
7 0.0006 0.00056910514831543
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00066804885864258
UPDATE autorun SET lastrun = '2021-08-05 07:50:30' WHERE id = '16'
9 0.0001 0.00013995170593262
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0004 0.00042390823364258
SELECT id FROM pages WHERE pagename = 'contact-us' LIMIT 1
11 0.0001 0.00012779235839844
SELECT * FROM pages WHERE id = 41
12 0.0009 0.0009150505065918
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0059 0.0059099197387695
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0004 0.00039505958557129
SELECT * FROM pages WHERE pagename = 'contact-us'
15 0.0004 0.00038409233093262
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0004 0.00043320655822754
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0019 0.0019130706787109
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
18 0.0002 0.00020289421081543
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
19 0.0001 0.00013613700866699
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
20 0.0001 9.7036361694336E-5
SELECT id FROM categories WHERE parent_id = '27'
21 0.0003 0.00025606155395508
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 
22 0.0002 0.00016403198242188
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 
23 0.0002 0.00018596649169922
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
24 0.0001 0.00012803077697754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
25 0.0001 0.00010585784912109
SELECT * FROM categorygroups WHERE id = '1'
26 0.0003 0.00027608871459961
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
27 0.0001 0.00010800361633301
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
28 0.0001 9.7036361694336E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
29 0.0001 9.9897384643555E-5
SELECT id FROM categories WHERE parent_id = '29'
30 0.0003 0.0002739429473877
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 
31 0.0001 9.5844268798828E-5
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 
32 0.0001 0.00012087821960449
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
33 0.0001 8.8214874267578E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
34 0.0001 9.7990036010742E-5
SELECT * FROM categorygroups WHERE id = '1'
35 0.0003 0.00034594535827637
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
36 0.0001 0.00011396408081055
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
37 0.0001 8.1777572631836E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
38 0.0001 9.5129013061523E-5
SELECT id FROM categories WHERE parent_id = '30'
39 0.0003 0.00033879280090332
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 
40 0.0001 0.00010800361633301
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 
41 0.0001 0.00011396408081055
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
42 0.0001 7.3909759521484E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
43 0.0001 8.392333984375E-5
SELECT * FROM categorygroups WHERE id = '1'
44 0.0002 0.00020694732666016
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 = 38
45 0.0001 0.00010800361633301
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
46 0.0001 8.1062316894531E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
47 0.0001 8.392333984375E-5
SELECT id FROM categories WHERE parent_id = '38'
48 0.0002 0.00023984909057617
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (38)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0001 9.3936920166016E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (38)
				  AND p.disabled = 0 
50 0.0001 0.00010895729064941
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (38)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0001 8.2015991210938E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
52 0.0001 8.082389831543E-5
SELECT * FROM categorygroups WHERE id = '1'
53 0.0001 0.00011897087097168
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
54 0.0011 0.0011100769042969
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
55 0.0005 0.00051403045654297
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
56 0.0002 0.0001990795135498
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
57 0.0002 0.00024008750915527
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
58 0.0007 0.00065088272094727
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
59 0.0495 0.049542188644409
SELECT * FROM ipgeocountries WHERE INET_ATON('3.231.230.177') >= INET_ATON(ip_start) AND INET_ATON('3.231.230.177') <= INET_ATON(ip_end)
60 0.0007 0.00066399574279785
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
61 0.0002 0.00016903877258301
SELECT * FROM countryredirects WHERE countrycode = 'US'
62 0.0002 0.00020718574523926
SELECT * FROM pages WHERE pagename = 'contact-us'
63 0.0007 0.0006859302520752
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
64 0.0004 0.00037980079650879
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
65 0.0001 9.1791152954102E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
66 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 38
67 0.0001 0.00012302398681641
SELECT * FROM categories WHERE id = '27'
68 0.0003 0.00030899047851562
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
69 0.0001 8.1062316894531E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
70 0.0001 8.7976455688477E-5
SELECT id FROM categories WHERE parent_id = '27'
71 0.0003 0.00025606155395508
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 
72 0.0001 0.00011014938354492
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 
73 0.0001 0.00011110305786133
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
74 0.0001 9.7036361694336E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
75 0.0002 0.00022196769714355
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
76 0.0001 7.7009201049805E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
77 0.0002 0.00021100044250488
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 
78 0.0001 9.2029571533203E-5
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 
79 0.0001 0.00011801719665527
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
80 0.0001 8.2969665527344E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
81 0.0001 0.0001060962677002
SELECT id FROM categories WHERE parent_id = '27'
82 0.0003 0.0002741813659668
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
83 0.0010 0.001046895980835
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
84 0.0003 0.00034117698669434
SELECT * FROM categoryimages WHERE category_id = 27
85 0.0001 9.8943710327148E-5
SELECT * FROM categorygroups WHERE id = '1'
86 0.0003 0.00026798248291016
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '27'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
87 0.0001 0.00010395050048828
SELECT * FROM categories WHERE id = '30'
88 0.0004 0.00039005279541016
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
89 0.0001 7.4148178100586E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
90 0.0001 8.9883804321289E-5
SELECT id FROM categories WHERE parent_id = '30'
91 0.0004 0.00038814544677734
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 
92 0.0001 9.5844268798828E-5
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 
93 0.0001 0.00011205673217773
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
94 0.0001 7.7962875366211E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
95 0.0003 0.00030517578125
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
96 0.0001 7.8201293945312E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
97 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 (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
98 0.0001 9.3936920166016E-5
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 
99 0.0001 0.00010395050048828
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
100 0.0001 7.5101852416992E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
101 0.0001 7.9870223999023E-5
SELECT id FROM categories WHERE parent_id = '30'
102 0.0004 0.00037789344787598
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
103 0.0007 0.00068116188049316
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
104 0.0001 9.608268737793E-5
SELECT * FROM categoryimages WHERE category_id = 30
105 0.0001 0.0001070499420166
SELECT * FROM categorygroups WHERE id = '1'
106 0.0003 0.00034093856811523
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '30'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
107 0.0001 0.00011491775512695
SELECT * FROM pages WHERE id = 59
108 0.0001 0.0001220703125
SELECT * FROM pages WHERE id = 55
109 0.0003 0.00025010108947754
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (32)) AND p.parent_id = 0
110 0.0004 0.00035309791564941
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:0:\"\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"32\";}s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1628149831;s:8:\"products\";a:0:{}}' WHERE id = '8'
111 0.0003 0.00026392936706543
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (38)) AND p.parent_id = 0 LIMIT 3
112 0.0001 0.00011301040649414
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"3\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"38\";}s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1628149831;s:8:\"products\";a:3:{i:0;s:11:\"7004|amazon\";i:1;s:11:\"7011|amazon\";i:2;s:11:\"7045|amazon\";}}' WHERE id = '16'
113 0.0002 0.00017189979553223
SELECT * FROM products WHERE id = 7004
114 0.0001 0.00013613700866699
SELECT * FROM products WHERE id = 7011
115 0.0001 0.00012302398681641
SELECT * FROM products WHERE id = 7045
116 0.0001 0.00014495849609375
SELECT * FROM products WHERE id = '7004'
117 0.0004 0.00035500526428223
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
118 0.0005 0.00047898292541504
SELECT * FROM product_image_select WHERE product_id = '7004'
119 0.0004 0.00041699409484863
SELECT * FROM productcustomimages WHERE product_id = '7004'
120 0.0023 0.0023469924926758
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
121 0.0004 0.00035405158996582
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
122 0.0002 0.0001521110534668
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0002 0.00019621849060059
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0001 0.00013494491577148
SELECT * FROM products WHERE id = '7011'
125 0.0001 0.00014996528625488
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
126 0.0002 0.0001521110534668
SELECT * FROM product_image_select WHERE product_id = '7011'
127 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '7011'
128 0.0014 0.0013988018035889
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
129 0.0001 0.00013899803161621
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
130 0.0001 0.00013184547424316
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0001 0.00012588500976562
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
132 0.0001 0.00014495849609375
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
133 0.0001 0.00014495849609375
SELECT * FROM products WHERE id = '7045'
134 0.0001 0.00012493133544922
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
135 0.0002 0.00016999244689941
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '7045' AND p.id = pi.product_id ORDER BY pi.sortorder
136 0.0002 0.00017094612121582
SELECT * FROM product_image_select WHERE product_id = '7045'
137 0.0001 0.00011396408081055
SELECT * FROM productcustomimages WHERE product_id = '7045'
138 0.0002 0.00016999244689941
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 = '7045'
                GROUP BY o.product_id
139 0.0007 0.00073909759521484
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     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
140 0.0001 0.00014281272888184
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
141 0.0006 0.00055289268493652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
142 0.0001 0.00012087821960449
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
143 0.0001 0.00013017654418945
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0001 0.00011205673217773
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
145 0.0001 0.0001220703125
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
146 0.0002 0.00017714500427246
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 = '7045'
                GROUP BY o.product_id
147 0.0002 0.00020980834960938
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     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
148 0.0002 0.00015091896057129
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
149 0.0002 0.00015401840209961
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0002 0.00018692016601562
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
151 0.0002 0.00019383430480957
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
152 0.0006 0.00059080123901367
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
153 0.0002 0.0002281665802002
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
154 0.0012 0.0011699199676514
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
155 0.0005 0.00051712989807129
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
156 0.0002 0.00018310546875
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
157 0.0003 0.00029897689819336
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
158 0.0002 0.00021815299987793
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
159 0.0002 0.00019192695617676
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'