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.30082201957703 158 0.0563 0


No Amazon API Requests Made.


App Debug - Total Time 0.30082201957703 seconds

Number Time From Start Name Description
1 0.21978998184204 Initialise Initialise FSB Function
2 0.22042012214661 App Controller Start Start of the App controller (called before the controller of every page)
3 0.22482991218567 Start of getCategoryListByGroup Function Before first category groups query
4 0.22492003440857 After initial query Before first category groups query
5 0.22492098808289 Get Category List for Group Before the call to getCategoryList function
6 0.22492289543152 Start of GetCategoryList function Start of the function
7 0.22492504119873 Before getting categories Query to get specific category list
8 0.22508001327515 After getting categories Query to get specific category list
9 0.22508096694946 Before getting category custom Before call to function getCategoryCustom
10 0.2261950969696 After getting category custom After call to function getCategoryCustom
11 0.22620010375977 Before getting category custom Before call to function getCategoryCustom
12 0.22738194465637 After getting category custom After call to function getCategoryCustom
13 0.22738289833069 Before getting category custom Before call to function getCategoryCustom
14 0.22848510742188 After getting category custom After call to function getCategoryCustom
15 0.22848701477051 Before getting category custom Before call to function getCategoryCustom
16 0.22941613197327 After getting category custom After call to function getCategoryCustom
17 0.2294180393219 End of GetCategoryList function End of the function
18 0.22942090034485 Get Category List for Group Before the call to getCategoryList function
19 0.22942209243774 Start of GetCategoryList function Start of the function
20 0.22942304611206 Before getting categories Query to get specific category list
21 0.22953009605408 End of getCategoryListByGroup Function Before return()
22 0.26202702522278 App Controller End End of the App controller (called before the controller of every page)
23 0.26354098320007 App_after Controller Start Start of the App_after controller (called after the controller of every page)
24 0.26376891136169 Before Get Options Before the call to getOptions in the tpl class
25 0.27952003479004 After Get Options After the call to getOptions in the tpl class
26 0.27956199645996 App_after Controller End End of the App_after controller (called after the controller of every page)
27 0.3008120059967 Finalizing debug Before the debug is output to the page.
28 0.30082106590271 End of App This is the end of the app logging, final timestamp


Query Debug - 158 Database Queries. Total time 0.0563 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00021815299987793
SELECT parameter, value FROM parameters
2 0.0003 0.00025606155395508
SELECT * FROM `bad_bots`
3 0.0001 0.00014185905456543
SET time_zone = 'Europe/London'
4 0.0001 9.8943710327148E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0001 0.00012707710266113
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"34.239.152.207\";}'
6 0.0001 0.00010013580322266
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1679627469'
7 0.0003 0.00028800964355469
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00010514259338379
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.0001378059387207
SELECT id FROM pages WHERE pagename = 'contact-us' LIMIT 1
10 0.0001 9.0837478637695E-5
SELECT * FROM pages WHERE id = 41
11 0.0003 0.00033211708068848
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
12 0.0035 0.0034859180450439
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
13 0.0001 0.00011992454528809
SELECT * FROM pages WHERE pagename = 'contact-us'
14 0.0001 7.9870223999023E-5
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0001 0.00014090538024902
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0002 0.00023603439331055
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.0001 0.00011205673217773
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.0001 6.3896179199219E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
19 0.0001 8.392333984375E-5
SELECT id FROM categories WHERE parent_id = '27'
20 0.0002 0.00019598007202148
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 8.082389831543E-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 
22 0.0001 9.9897384643555E-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
23 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
24 0.0001 7.2002410888672E-5
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00023198127746582
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.2983245849609E-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 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
28 0.0001 6.8902969360352E-5
SELECT id FROM categories WHERE parent_id = '29'
29 0.0002 0.0002129077911377
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.0002 0.00018405914306641
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.9883804321289E-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 7.0810317993164E-5
SELECT * FROM categorygroups WHERE id = '1'
34 0.0003 0.00025701522827148
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.9883804321289E-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.6982040405273E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
37 0.0001 6.6041946411133E-5
SELECT id FROM categories WHERE parent_id = '30'
38 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 
39 0.0001 7.4148178100586E-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 9.608268737793E-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 6.0081481933594E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
42 0.0001 6.9141387939453E-5
SELECT * FROM categorygroups WHERE id = '1'
43 0.0002 0.00016999244689941
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 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 = 38
45 0.0001 5.6982040405273E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
46 0.0001 6.413459777832E-5
SELECT id FROM categories WHERE parent_id = '38'
47 0.0002 0.0001671314239502
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.4148178100586E-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 7.2002410888672E-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 9.7990036010742E-5
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
53 0.0004 0.0003960132598877
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
54 0.0001 0.00014495849609375
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
55 0.0002 0.00019598007202148
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.00018191337585449
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
57 0.0003 0.00027990341186523
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
58 0.0304 0.030372858047485
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.0001 0.00013613700866699
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
60 0.0001 6.3180923461914E-5
SELECT * FROM countryredirects WHERE countrycode = 'US'
61 0.0001 0.00011801719665527
SELECT * FROM pages WHERE pagename = 'contact-us'
62 0.0001 0.0001060962677002
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
63 0.0001 8.9883804321289E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
64 0.0001 6.6995620727539E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
65 0.0001 9.4890594482422E-5
SELECT * FROM pages WHERE id = 38
66 0.0001 8.2969665527344E-5
SELECT * FROM categories WHERE id = '27'
67 0.0002 0.00016617774963379
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.2227249145508E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
69 0.0001 6.5088272094727E-5
SELECT id FROM categories WHERE parent_id = '27'
70 0.0002 0.00017094612121582
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 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 
72 0.0001 8.6069107055664E-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
73 0.0001 5.793571472168E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
74 0.0002 0.00015091896057129
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.0081481933594E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
76 0.0002 0.00016307830810547
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 8.2969665527344E-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.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 (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.2942504882812E-5
SELECT id FROM categories WHERE parent_id = '27'
81 0.0002 0.00020909309387207
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.0001 0.00012898445129395
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
83 0.0001 7.6055526733398E-5
SELECT * FROM categoryimages WHERE category_id = 27
84 0.0001 6.6995620727539E-5
SELECT * FROM categorygroups WHERE id = '1'
85 0.0002 0.00018405914306641
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 9.2029571533203E-5
SELECT * FROM categories WHERE id = '30'
87 0.0002 0.00024580955505371
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.413459777832E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
89 0.0001 6.9141387939453E-5
SELECT id FROM categories WHERE parent_id = '30'
90 0.0002 0.00024604797363281
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.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
93 0.0001 5.6028366088867E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
94 0.0002 0.00023579597473145
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 7.7962875366211E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
96 0.0002 0.000244140625
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.1048736572266E-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 7.9870223999023E-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.6982040405273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
100 0.0001 6.1988830566406E-5
SELECT id FROM categories WHERE parent_id = '30'
101 0.0003 0.0002741813659668
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.00014901161193848
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
103 0.0001 7.4863433837891E-5
SELECT * FROM categoryimages WHERE category_id = 30
104 0.0001 6.7949295043945E-5
SELECT * FROM categorygroups WHERE id = '1'
105 0.0003 0.00025582313537598
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.6069107055664E-5
SELECT * FROM pages WHERE id = 59
107 0.0001 8.392333984375E-5
SELECT * FROM pages WHERE id = 55
108 0.0001 0.00014495849609375
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.0001070499420166
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:1679627469;s:8:\"products\";a:0:{}}' WHERE id = '8'
110 0.0002 0.00019502639770508
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.2983245849609E-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:1679627469;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.00011491775512695
SELECT * FROM products WHERE id = 7004
113 0.0001 0.00010585784912109
SELECT * FROM products WHERE id = 7011
114 0.0001 0.00010991096496582
SELECT * FROM products WHERE id = 7045
115 0.0001 0.00010585784912109
SELECT * FROM products WHERE id = '7004'
116 0.0001 0.00011992454528809
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
117 0.0001 0.00013899803161621
SELECT * FROM product_image_select WHERE product_id = '7004'
118 0.0001 9.1075897216797E-5
SELECT * FROM productcustomimages WHERE product_id = '7004'
119 0.0005 0.00053310394287109
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.00012493133544922
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
121 0.0001 0.00011420249938965
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 0.00010013580322266
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
125 0.0001 0.00014209747314453
SELECT * FROM product_image_select WHERE product_id = '7011'
126 0.0001 9.0122222900391E-5
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 9.5844268798828E-5
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
129 0.0001 0.0001068115234375
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0001 9.2983245849609E-5
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
131 0.0001 0.00012612342834473
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
132 0.0002 0.0001528263092041
SELECT * FROM products WHERE id = '7045'
133 0.0001 0.00013113021850586
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
134 0.0002 0.00018000602722168
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.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '7045'
136 0.0001 9.9897384643555E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
137 0.0002 0.00019001960754395
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.0002 0.00024509429931641
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.0002 0.00022196769714355
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.0007 0.00070595741271973
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.0001218318939209
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
142 0.0001 0.00013303756713867
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0001 0.0001378059387207
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
144 0.0001 0.00014209747314453
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
145 0.0002 0.00018095970153809
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.00021696090698242
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.00013899803161621
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.0002 0.00018191337585449
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0002 0.00019216537475586
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.0002 0.00020694732666016
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.0003 0.00027298927307129
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
152 0.0002 0.00024104118347168
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
153 0.0004 0.0004420280456543
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
154 0.0002 0.00020098686218262
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
155 0.0002 0.00020098686218262
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
156 0.0002 0.00021600723266602
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
157 0.0002 0.00017404556274414
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
158 0.0002 0.00015997886657715
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'