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.3633759021759 158 0.0556 0


No Amazon API Requests Made.


App Debug - Total Time 0.3633759021759 seconds

Number Time From Start Name Description
1 0.2859218120575 Initialise Initialise FSB Function
2 0.28661298751831 App Controller Start Start of the App controller (called before the controller of every page)
3 0.29136800765991 Start of getCategoryListByGroup Function Before first category groups query
4 0.29150795936584 After initial query Before first category groups query
5 0.29150891304016 Get Category List for Group Before the call to getCategoryList function
6 0.29151082038879 Start of GetCategoryList function Start of the function
7 0.29151391983032 Before getting categories Query to get specific category list
8 0.29170083999634 After getting categories Query to get specific category list
9 0.29170179367065 Before getting category custom Before call to function getCategoryCustom
10 0.29318785667419 After getting category custom After call to function getCategoryCustom
11 0.29319286346436 Before getting category custom Before call to function getCategoryCustom
12 0.29436492919922 After getting category custom After call to function getCategoryCustom
13 0.29436588287354 Before getting category custom Before call to function getCategoryCustom
14 0.29560780525208 After getting category custom After call to function getCategoryCustom
15 0.29560995101929 Before getting category custom Before call to function getCategoryCustom
16 0.29668378829956 After getting category custom After call to function getCategoryCustom
17 0.29668498039246 End of GetCategoryList function End of the function
18 0.29668784141541 Get Category List for Group Before the call to getCategoryList function
19 0.29668784141541 Start of GetCategoryList function Start of the function
20 0.29668998718262 Before getting categories Query to get specific category list
21 0.29680681228638 End of getCategoryListByGroup Function Before return()
22 0.32737278938293 App Controller End End of the App controller (called before the controller of every page)
23 0.32920789718628 App_after Controller Start Start of the App_after controller (called after the controller of every page)
24 0.32949090003967 Before Get Options Before the call to getOptions in the tpl class
25 0.3450448513031 After Get Options After the call to getOptions in the tpl class
26 0.34508085250854 App_after Controller End End of the App_after controller (called after the controller of every page)
27 0.3633668422699 Finalizing debug Before the debug is output to the page.
28 0.3633759021759 End of App This is the end of the app logging, final timestamp


Query Debug - 158 Database Queries. Total time 0.0556 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00023984909057617
SELECT parameter, value FROM parameters
2 0.0004 0.00035810470581055
SELECT * FROM `bad_bots`
3 0.0001 0.00013399124145508
SET time_zone = 'Europe/London'
4 0.0002 0.00015592575073242
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0002 0.00019598007202148
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.208.132.74\";}'
6 0.0001 0.00014400482177734
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1665029369'
7 0.0003 0.0003359317779541
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00010108947753906
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0002 0.00020194053649902
SELECT id FROM pages WHERE pagename = 'contact-us' LIMIT 1
10 0.0001 0.00010204315185547
SELECT * FROM pages WHERE id = 41
11 0.0004 0.00036215782165527
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
12 0.0039 0.0038552284240723
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
13 0.0001 0.00012588500976562
SELECT * FROM pages WHERE pagename = 'contact-us'
14 0.0001 0.00012993812561035
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0002 0.00017404556274414
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00031805038452148
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.0001678466796875
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 0.00011181831359863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
19 0.0001 8.3208084106445E-5
SELECT id FROM categories WHERE parent_id = '27'
20 0.0002 0.00020885467529297
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.00012898445129395
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.00015592575073242
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.00011587142944336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
24 0.0001 9.7036361694336E-5
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00023388862609863
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.7990036010742E-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 8.2015991210938E-5
SELECT id FROM categories WHERE parent_id = '29'
29 0.0003 0.00025081634521484
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 8.4877014160156E-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 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 (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
33 0.0001 8.4877014160156E-5
SELECT * FROM categorygroups WHERE id = '1'
34 0.0003 0.00027108192443848
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 9.608268737793E-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 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
37 0.0001 8.8930130004883E-5
SELECT id FROM categories WHERE parent_id = '30'
38 0.0003 0.00029587745666504
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 8.392333984375E-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.6797943115234E-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 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
42 0.0001 8.4161758422852E-5
SELECT * FROM categorygroups WHERE id = '1'
43 0.0002 0.00017595291137695
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 0.00010299682617188
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 9.2983245849609E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
46 0.0001 8.2969665527344E-5
SELECT id FROM categories WHERE parent_id = '38'
47 0.0002 0.00020003318786621
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 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 (38)
				  AND p.disabled = 0 
49 0.0001 9.8228454589844E-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.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
51 0.0001 8.4161758422852E-5
SELECT * FROM categorygroups WHERE id = '1'
52 0.0001 0.00010895729064941
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
53 0.0005 0.00051283836364746
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
54 0.0002 0.00019097328186035
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
55 0.0002 0.00017619132995605
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.00020122528076172
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
57 0.0003 0.00033903121948242
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
58 0.0275 0.027497053146362
SELECT * FROM ipgeocountries WHERE INET_ATON('18.208.132.74') >= INET_ATON(ip_start) AND INET_ATON('18.208.132.74') <= INET_ATON(ip_end)
59 0.0003 0.00031495094299316
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
60 0.0001 0.00011301040649414
SELECT * FROM countryredirects WHERE countrycode = 'US'
61 0.0002 0.0001521110534668
SELECT * FROM pages WHERE pagename = 'contact-us'
62 0.0002 0.0001680850982666
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
63 0.0001 0.00012397766113281
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
64 0.0001 7.9870223999023E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
65 0.0001 0.00010204315185547
SELECT * FROM pages WHERE id = 38
66 0.0001 9.9897384643555E-5
SELECT * FROM categories WHERE id = '27'
67 0.0002 0.00023794174194336
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 8.6069107055664E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
69 0.0001 7.8916549682617E-5
SELECT id FROM categories WHERE parent_id = '27'
70 0.0002 0.00020313262939453
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 8.7976455688477E-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.00010108947753906
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.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
74 0.0002 0.00018095970153809
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.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
76 0.0002 0.00020098686218262
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.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 
78 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
79 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
80 0.0001 7.8916549682617E-5
SELECT id FROM categories WHERE parent_id = '27'
81 0.0002 0.00021696090698242
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.00019192695617676
SELECT * FROM productimages WHERE product_id = '798' ORDER BY sortorder ASC
83 0.0001 0.00012993812561035
SELECT * FROM categoryimages WHERE category_id = 27
84 0.0001 8.3208084106445E-5
SELECT * FROM categorygroups WHERE id = '1'
85 0.0002 0.00020003318786621
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.0003 0.00027012825012207
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 7.5817108154297E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
89 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '30'
90 0.0003 0.00029182434082031
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 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 (30)
				  AND p.disabled = 0 
92 0.0001 9.2983245849609E-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 6.7949295043945E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
94 0.0003 0.00026202201843262
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.6055526733398E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
96 0.0003 0.00029301643371582
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.8916549682617E-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.2029571533203E-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 6.7949295043945E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
100 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '30'
101 0.0003 0.00029206275939941
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.0001370906829834
SELECT * FROM productimages WHERE product_id = '821' ORDER BY sortorder ASC
103 0.0001 9.5129013061523E-5
SELECT * FROM categoryimages WHERE category_id = 30
104 0.0001 7.9154968261719E-5
SELECT * FROM categorygroups WHERE id = '1'
105 0.0003 0.00028514862060547
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 9.2029571533203E-5
SELECT * FROM pages WHERE id = 59
107 0.0001 9.7990036010742E-5
SELECT * FROM pages WHERE id = 55
108 0.0002 0.00020194053649902
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.00013995170593262
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:1665029370;s:8:\"products\";a:0:{}}' WHERE id = '8'
110 0.0002 0.00020909309387207
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.7990036010742E-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:1665029370;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.00012588500976562
SELECT * FROM products WHERE id = 7004
113 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = 7011
114 0.0001 0.00011897087097168
SELECT * FROM products WHERE id = 7045
115 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = '7004'
116 0.0001 0.00014090538024902
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
117 0.0002 0.00017786026000977
SELECT * FROM product_image_select WHERE product_id = '7004'
118 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '7004'
119 0.0006 0.00057077407836914
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.00011491775512695
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
121 0.0001 0.00012803077697754
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0001 0.00014400482177734
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0001 0.00012397766113281
SELECT * FROM products WHERE id = '7011'
124 0.0001 0.00010895729064941
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
125 0.0001 0.00014805793762207
SELECT * FROM product_image_select WHERE product_id = '7011'
126 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
127 0.0005 0.00051403045654297
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.00010895729064941
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
129 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0001 0.00011515617370605
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
131 0.0001 0.00011801719665527
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
132 0.0001 0.00011897087097168
SELECT * FROM products WHERE id = '7045'
133 0.0001 0.00010180473327637
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
134 0.0001 0.00014019012451172
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.00014305114746094
SELECT * FROM product_image_select WHERE product_id = '7045'
136 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
137 0.0001 0.00014901161193848
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.00024604797363281
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.00011706352233887
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.0005 0.00052905082702637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
141 0.0001 9.8228454589844E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
142 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0001 9.7990036010742E-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.00013589859008789
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.00018191337585449
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.00011420249938965
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.00015807151794434
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0002 0.00015377998352051
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.00014901161193848
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.00024104118347168
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
152 0.0002 0.00017499923706055
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
153 0.0004 0.00037813186645508
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
154 0.0002 0.0001990795135498
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
155 0.0002 0.0001530647277832
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
156 0.0003 0.00027608871459961
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
157 0.0002 0.00015115737915039
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
158 0.0001 0.00013518333435059
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'