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.36153507232666 158 0.0550 0


No Amazon API Requests Made.


App Debug - Total Time 0.36153507232666 seconds

Number Time From Start Name Description
1 0.29743814468384 Initialise Initialise FSB Function
2 0.2980580329895 App Controller Start Start of the App controller (called before the controller of every page)
3 0.30261206626892 Start of getCategoryListByGroup Function Before first category groups query
4 0.30274701118469 After initial query Before first category groups query
5 0.30274796485901 Get Category List for Group Before the call to getCategoryList function
6 0.30275011062622 Start of GetCategoryList function Start of the function
7 0.30275201797485 Before getting categories Query to get specific category list
8 0.30294704437256 After getting categories Query to get specific category list
9 0.30294799804688 Before getting category custom Before call to function getCategoryCustom
10 0.30445408821106 After getting category custom After call to function getCategoryCustom
11 0.3044581413269 Before getting category custom Before call to function getCategoryCustom
12 0.30552506446838 After getting category custom After call to function getCategoryCustom
13 0.3055260181427 Before getting category custom Before call to function getCategoryCustom
14 0.30662298202515 After getting category custom After call to function getCategoryCustom
15 0.30662512779236 Before getting category custom Before call to function getCategoryCustom
16 0.30894017219543 After getting category custom After call to function getCategoryCustom
17 0.30894207954407 End of GetCategoryList function End of the function
18 0.30894494056702 Get Category List for Group Before the call to getCategoryList function
19 0.30894613265991 Start of GetCategoryList function Start of the function
20 0.30894708633423 Before getting categories Query to get specific category list
21 0.30906295776367 End of getCategoryListByGroup Function Before return()
22 0.33875894546509 App Controller End End of the App controller (called before the controller of every page)
23 0.33999395370483 App_after Controller Start Start of the App_after controller (called after the controller of every page)
24 0.34027600288391 Before Get Options Before the call to getOptions in the tpl class
25 0.35499405860901 After Get Options After the call to getOptions in the tpl class
26 0.35502099990845 App_after Controller End End of the App_after controller (called after the controller of every page)
27 0.36152696609497 Finalizing debug Before the debug is output to the page.
28 0.36153411865234 End of App This is the end of the app logging, final timestamp


Query Debug - 158 Database Queries. Total time 0.0550 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.0002138614654541
SELECT parameter, value FROM parameters
2 0.0004 0.00035905838012695
SELECT * FROM `bad_bots`
3 0.0003 0.00029087066650391
SET time_zone = 'Europe/London'
4 0.0002 0.00015592575073242
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0002 0.00024294853210449
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"34.239.152.207\";}'
6 0.0001 0.00014495849609375
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1679628177'
7 0.0002 0.00020289421081543
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 8.3208084106445E-5
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0002 0.00016689300537109
SELECT id FROM pages WHERE pagename = 'contact-us' LIMIT 1
10 0.0001 8.7976455688477E-5
SELECT * FROM pages WHERE id = 41
11 0.0004 0.00036001205444336
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
12 0.0036 0.0036270618438721
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
13 0.0001 0.00011801719665527
SELECT * FROM pages WHERE pagename = 'contact-us'
14 0.0001 0.00012493133544922
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0002 0.00018000602722168
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00030088424682617
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
17 0.0002 0.00018501281738281
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
18 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
19 0.0001 7.2002410888672E-5
SELECT id FROM categories WHERE parent_id = '27'
20 0.0002 0.00019097328186035
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 
21 0.0001 0.00012588500976562
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 
22 0.0002 0.00015497207641602
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
23 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
24 0.0001 7.8916549682617E-5
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00022792816162109
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
26 0.0001 9.0122222900391E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
27 0.0001 5.8889389038086E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
28 0.0001 6.4849853515625E-5
SELECT id FROM categories WHERE parent_id = '29'
29 0.0002 0.00022196769714355
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 
30 0.0001 9.9897384643555E-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 
31 0.0001 8.7976455688477E-5
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
32 0.0001 5.9127807617188E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
33 0.0001 6.8902969360352E-5
SELECT * FROM categorygroups WHERE id = '1'
34 0.0002 0.0002439022064209
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
35 0.0001 8.6069107055664E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
36 0.0001 5.8174133300781E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
37 0.0001 6.5088272094727E-5
SELECT id FROM categories WHERE parent_id = '30'
38 0.0003 0.00026607513427734
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 
39 0.0001 7.2956085205078E-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 
40 0.0001 8.2969665527344E-5
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
41 0.0001 5.8889389038086E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
42 0.0001 7.9154968261719E-5
SELECT * FROM categorygroups WHERE id = '1'
43 0.0002 0.00015687942504883
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
44 0.0001 8.6069107055664E-5
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
45 0.0003 0.00026583671569824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
46 0.0012 0.0012469291687012
SELECT id FROM categories WHERE parent_id = '38'
47 0.0002 0.00018596649169922
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 
48 0.0001 7.5101852416992E-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 
49 0.0001 8.392333984375E-5
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
50 0.0001 5.9127807617188E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
51 0.0001 6.9141387939453E-5
SELECT * FROM categorygroups WHERE id = '1'
52 0.0001 0.0001070499420166
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
53 0.0005 0.00048089027404785
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
54 0.0002 0.00022006034851074
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
55 0.0002 0.00021600723266602
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
56 0.0002 0.00019311904907227
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
57 0.0003 0.00030016899108887
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
58 0.0273 0.027311086654663
SELECT * FROM ipgeocountries WHERE INET_ATON('34.239.152.207') >= INET_ATON(ip_start) AND INET_ATON('34.239.152.207') <= INET_ATON(ip_end)
59 0.0002 0.00017595291137695
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
60 0.0001 0.00010585784912109
SELECT * FROM countryredirects WHERE countrycode = 'US'
61 0.0001 0.00013303756713867
SELECT * FROM pages WHERE pagename = 'contact-us'
62 0.0002 0.00016188621520996
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
63 0.0001 0.00013089179992676
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
64 0.0001 6.7949295043945E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
65 0.0001 9.7036361694336E-5
SELECT * FROM pages WHERE id = 38
66 0.0001 8.4161758422852E-5
SELECT * FROM categories WHERE id = '27'
67 0.0002 0.00018715858459473
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
68 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
69 0.0001 6.4849853515625E-5
SELECT id FROM categories WHERE parent_id = '27'
70 0.0002 0.00016903877258301
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 
71 0.0001 7.6055526733398E-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 
72 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
73 0.0001 7.3909759521484E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
74 0.0002 0.00016093254089355
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
75 0.0001 6.103515625E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
76 0.0002 0.00016689300537109
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 
77 0.0001 7.2956085205078E-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 
78 0.0001 8.2969665527344E-5
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
79 0.0001 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
80 0.0001 6.413459777832E-5
SELECT id FROM categories WHERE parent_id = '27'
81 0.0002 0.00020217895507812
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
82 0.0002 0.00017690658569336
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
83 0.0001 0.00012016296386719
SELECT * FROM categoryimages WHERE category_id = 27
84 0.0001 6.9856643676758E-5
SELECT * FROM categorygroups WHERE id = '1'
85 0.0002 0.00018715858459473
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
86 0.0001 8.392333984375E-5
SELECT * FROM categories WHERE id = '30'
87 0.0002 0.00024890899658203
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
88 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
89 0.0001 6.2942504882812E-5
SELECT id FROM categories WHERE parent_id = '30'
90 0.0003 0.00025105476379395
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 
91 0.0001 7.5101852416992E-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 
92 0.0001 8.2015991210938E-5
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
93 0.0001 5.6028366088867E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
94 0.0002 0.00022292137145996
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
95 0.0001 5.793571472168E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
96 0.0002 0.00024914741516113
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 
97 0.0001 7.2002410888672E-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 
98 0.0001 9.3936920166016E-5
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
99 0.0001 5.6028366088867E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
100 0.0001 6.103515625E-5
SELECT id FROM categories WHERE parent_id = '30'
101 0.0003 0.00025200843811035
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
102 0.0001 0.00011706352233887
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
103 0.0001 8.4877014160156E-5
SELECT * FROM categoryimages WHERE category_id = 30
104 0.0001 6.7949295043945E-5
SELECT * FROM categorygroups WHERE id = '1'
105 0.0003 0.0002591609954834
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
106 0.0001 8.4877014160156E-5
SELECT * FROM pages WHERE id = 59
107 0.0001 8.702278137207E-5
SELECT * FROM pages WHERE id = 55
108 0.0002 0.00021195411682129
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
109 0.0001 0.00010299682617188
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:1679628177;s:8:\"products\";a:0:{}}' WHERE id = '8'
110 0.0002 0.00019979476928711
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
111 0.0001 9.0122222900391E-5
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:1679628177;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'
112 0.0001 0.0001227855682373
SELECT * FROM products WHERE id = 7004
113 0.0001 0.00010299682617188
SELECT * FROM products WHERE id = 7011
114 0.0001 0.00010108947753906
SELECT * FROM products WHERE id = 7045
115 0.0001 0.00010299682617188
SELECT * FROM products WHERE id = '7004'
116 0.0001 0.00011587142944336
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
117 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '7004'
118 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '7004'
119 0.0006 0.00062012672424316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
120 0.0001 0.0001060962677002
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
121 0.0001 0.00011086463928223
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0001 0.00013899803161621
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0001 0.00011491775512695
SELECT * FROM products WHERE id = '7011'
124 0.0001 9.7990036010742E-5
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
125 0.0001 0.00012898445129395
SELECT * FROM product_image_select WHERE product_id = '7011'
126 0.0001 0.00010585784912109
SELECT * FROM productcustomimages WHERE product_id = '7011'
127 0.0006 0.00056099891662598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
128 0.0001 0.00011086463928223
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
129 0.0001 0.00010299682617188
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0001 0.00011396408081055
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
131 0.0001 0.00011301040649414
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
132 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = '7045'
133 0.0001 0.00010013580322266
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
134 0.0001 0.00014996528625488
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
135 0.0001 0.00013184547424316
SELECT * FROM product_image_select WHERE product_id = '7045'
136 0.0001 8.5115432739258E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
137 0.0001 0.00013113021850586
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
138 0.0003 0.00027108192443848
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
139 0.0001 0.00011992454528809
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
140 0.0006 0.00056719779968262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
141 0.0001 0.00010514259338379
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
142 0.0001 9.7036361694336E-5
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0001 8.7976455688477E-5
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
144 0.0001 0.00011301040649414
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
145 0.0001 0.00012397766113281
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
146 0.0002 0.00015592575073242
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
147 0.0001 0.00010585784912109
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
148 0.0001 0.0001370906829834
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0002 0.00015783309936523
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
150 0.0001 0.00013899803161621
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
151 0.0002 0.00024700164794922
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
152 0.0002 0.00016188621520996
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
153 0.0003 0.00034999847412109
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
154 0.0002 0.00022506713867188
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
155 0.0001 0.00013899803161621
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
156 0.0001 0.00013589859008789
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
157 0.0001 0.00014805793762207
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
158 0.0001 0.0001220703125
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'