All Products

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.60381293296814 311 0.1309 0


No Amazon API Requests Made.


App Debug - Total Time 0.60381293296814 seconds

Number Time From Start Name Description
1 0.41708207130432 Initialise Initialise FSB Function
2 0.41863799095154 App Controller Start Start of the App controller (called before the controller of every page)
3 0.42594289779663 Start of getCategoryListByGroup Function Before first category groups query
4 0.42653012275696 After initial query Before first category groups query
5 0.42653012275696 Get Category List for Group Before the call to getCategoryList function
6 0.42653393745422 Start of GetCategoryList function Start of the function
7 0.42653703689575 Before getting categories Query to get specific category list
8 0.42715001106262 After getting categories Query to get specific category list
9 0.42715096473694 Before getting category custom Before call to function getCategoryCustom
10 0.43197011947632 After getting category custom After call to function getCategoryCustom
11 0.43197703361511 Before getting category custom Before call to function getCategoryCustom
12 0.43322205543518 After getting category custom After call to function getCategoryCustom
13 0.4332230091095 Before getting category custom Before call to function getCategoryCustom
14 0.43453407287598 After getting category custom After call to function getCategoryCustom
15 0.43453502655029 Before getting category custom Before call to function getCategoryCustom
16 0.43559098243713 After getting category custom After call to function getCategoryCustom
17 0.43559193611145 End of GetCategoryList function End of the function
18 0.43559598922729 Get Category List for Group Before the call to getCategoryList function
19 0.43559694290161 Start of GetCategoryList function Start of the function
20 0.43559908866882 Before getting categories Query to get specific category list
21 0.43572306632996 End of getCategoryListByGroup Function Before return()
22 0.49326992034912 App Controller End End of the App controller (called before the controller of every page)
23 0.5347011089325 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
24 0.53594708442688 App_after Controller Start Start of the App_after controller (called after the controller of every page)
25 0.53665089607239 Before Get Options Before the call to getOptions in the tpl class
26 0.5578339099884 After Get Options After the call to getOptions in the tpl class
27 0.55801010131836 App_after Controller End End of the App_after controller (called after the controller of every page)
28 0.60379600524902 Finalizing debug Before the debug is output to the page.
29 0.60380601882935 End of App This is the end of the app logging, final timestamp


Query Debug - 311 Database Queries. Total time 0.1309 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.00083494186401367
SELECT parameter, value FROM parameters
2 0.0014 0.0013799667358398
SELECT * FROM `bad_bots`
3 0.0002 0.00018715858459473
SET time_zone = 'Europe/London'
4 0.0006 0.00057315826416016
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0011 0.0010740756988525
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"44.200.171.74\";}'
6 0.0010 0.00095796585083008
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1660778280'
7 0.0010 0.00097489356994629
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00019598007202148
UPDATE autorun SET lastrun = '2022-08-17 23:18:00' WHERE id = '9'
9 0.0001 0.00012993812561035
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0006 0.00059795379638672
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0001 0.00011181831359863
SELECT * FROM pages WHERE id = 42
12 0.0009 0.00086212158203125
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0056 0.0055868625640869
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0004 0.00038695335388184
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0006 0.00057482719421387
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00059700012207031
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0019 0.0019359588623047
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.0004 0.00044608116149902
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.0003 0.00032401084899902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
20 0.0001 8.8930130004883E-5
SELECT id FROM categories WHERE parent_id = '27'
21 0.0007 0.00069594383239746
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.0004 0.00037598609924316
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.0004 0.00037097930908203
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.0004 0.00036382675170898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
25 0.0001 0.00010395050048828
SELECT * FROM categorygroups WHERE id = '1'
26 0.0002 0.00024914741516113
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.00010299682617188
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 7.2956085205078E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
29 0.0001 0.00010395050048828
SELECT id FROM categories WHERE parent_id = '29'
30 0.0003 0.00027203559875488
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 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 (29)
				  AND p.disabled = 0 
32 0.0001 0.00010013580322266
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 7.4863433837891E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
34 0.0001 8.702278137207E-5
SELECT * FROM categorygroups WHERE id = '1'
35 0.0003 0.00029516220092773
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 9.9897384643555E-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
37 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
38 0.0001 8.392333984375E-5
SELECT id FROM categories WHERE parent_id = '30'
39 0.0003 0.00029802322387695
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 8.6069107055664E-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 
41 0.0001 9.7990036010742E-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
42 0.0001 7.3909759521484E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
43 0.0001 0.0001060962677002
SELECT * FROM categorygroups WHERE id = '1'
44 0.0002 0.00018119812011719
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.0001070499420166
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 7.2956085205078E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
47 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '38'
48 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 (38)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0001 7.9870223999023E-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 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 (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.1062316894531E-5
SELECT * FROM categorygroups WHERE id = '1'
53 0.0001 0.00011396408081055
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
54 0.0013 0.0012731552124023
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
55 0.0006 0.00063610076904297
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
56 0.0002 0.00020790100097656
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.00021719932556152
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
58 0.0006 0.00060105323791504
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
59 0.0487 0.0487220287323
SELECT * FROM ipgeocountries WHERE INET_ATON('44.200.171.74') >= INET_ATON(ip_start) AND INET_ATON('44.200.171.74') <= INET_ATON(ip_end)
60 0.0008 0.0008080005645752
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
61 0.0004 0.00038599967956543
SELECT * FROM countryredirects WHERE countrycode = 'US'
62 0.0002 0.00022792816162109
SELECT * FROM pages WHERE pagename = 'all-products'
63 0.0006 0.0005640983581543
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
64 0.0006 0.00057101249694824
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
65 0.0006 0.00063800811767578
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
66 0.0005 0.00050091743469238
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
67 0.0005 0.00047087669372559
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
68 0.0001 0.0001370906829834
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
69 0.0005 0.00053000450134277
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
70 0.0004 0.0004429817199707
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
71 0.0005 0.00046515464782715
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
72 0.0001 0.00012493133544922
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
73 0.0008 0.00078296661376953
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 72, 18
74 0.0014 0.0013809204101562
SELECT * FROM productimages WHERE product_id = '805' ORDER BY sortorder ASC
75 0.0006 0.00063896179199219
SELECT * FROM product_image_select WHERE product_id = '805'
76 0.0006 0.00055599212646484
SELECT * FROM productcustomimages WHERE product_id = '805'
77 0.0022 0.0022430419921875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '805' AND a.name = n.originalname
78 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '805' AND merchantid = 'ATVPDKIKX0DER'
79 0.0003 0.00033116340637207
SELECT * FROM productoffers
                WHERE product_id = '805' AND price > 0
                ORDER BY price ASC LIMIT 1
80 0.0001 0.0001060962677002
SELECT * FROM productoffers
                WHERE product_id = 805
                ORDER BY price ASC LIMIT 1
81 0.0001 0.00011801719665527
SELECT value FROM productattributes
                WHERE product_id = '805'
                AND name = 'ListPriceAmount'
82 0.0002 0.00015687942504883
SELECT value FROM productattributes WHERE product_id = '805' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
83 0.0005 0.00053000450134277
SELECT * FROM productimages WHERE product_id = '811' ORDER BY sortorder ASC
84 0.0001 0.00014400482177734
SELECT * FROM product_image_select WHERE product_id = '811'
85 0.0001 0.0001070499420166
SELECT * FROM productcustomimages WHERE product_id = '811'
86 0.0006 0.00062799453735352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '811' AND a.name = n.originalname
87 0.0003 0.00033903121948242
SELECT * FROM productoffers WHERE product_id = '811' AND merchantid = 'ATVPDKIKX0DER'
88 0.0001 0.00012397766113281
SELECT * FROM productoffers
                WHERE product_id = '811' AND price > 0
                ORDER BY price ASC LIMIT 1
89 0.0001 0.0001370906829834
SELECT value FROM productattributes WHERE product_id = '811' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
90 0.0003 0.00030708312988281
SELECT * FROM productimages WHERE product_id = '814' ORDER BY sortorder ASC
91 0.0001 0.00013899803161621
SELECT * FROM product_image_select WHERE product_id = '814'
92 0.0001 0.00010204315185547
SELECT * FROM productcustomimages WHERE product_id = '814'
93 0.0004 0.0004429817199707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '814' AND a.name = n.originalname
94 0.0001 0.00012111663818359
SELECT * FROM productoffers WHERE product_id = '814' AND merchantid = 'ATVPDKIKX0DER'
95 0.0002 0.0001521110534668
SELECT * FROM productoffers
                WHERE product_id = '814' AND price > 0
                ORDER BY price ASC LIMIT 1
96 0.0001 0.00014090538024902
SELECT value FROM productattributes WHERE product_id = '814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
97 0.0005 0.00051999092102051
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
98 0.0002 0.00016498565673828
SELECT * FROM product_image_select WHERE product_id = '819'
99 0.0001 0.00011610984802246
SELECT * FROM productcustomimages WHERE product_id = '819'
100 0.0007 0.0007169246673584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '819' AND a.name = n.originalname
101 0.0001 0.00012707710266113
SELECT * FROM productoffers WHERE product_id = '819' AND merchantid = 'ATVPDKIKX0DER'
102 0.0001 0.00012612342834473
SELECT * FROM productoffers
                WHERE product_id = '819' AND price > 0
                ORDER BY price ASC LIMIT 1
103 0.0002 0.00015091896057129
SELECT value FROM productattributes WHERE product_id = '819' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
104 0.0004 0.00036120414733887
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
105 0.0002 0.0001528263092041
SELECT * FROM product_image_select WHERE product_id = '822'
106 0.0001 0.00011515617370605
SELECT * FROM productcustomimages WHERE product_id = '822'
107 0.0004 0.0003969669342041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
108 0.0001 0.00011897087097168
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'ATVPDKIKX0DER'
109 0.0001 0.00013899803161621
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0002 0.00017809867858887
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0002 0.00015687942504883
SELECT * FROM productimages WHERE product_id = '824' ORDER BY sortorder ASC
112 0.0002 0.00015091896057129
SELECT * FROM product_image_select WHERE product_id = '824'
113 0.0001 0.00010204315185547
SELECT * FROM productcustomimages WHERE product_id = '824'
114 0.0006 0.00063896179199219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '824' AND a.name = n.originalname
115 0.0001 0.0001070499420166
SELECT * FROM productoffers WHERE product_id = '824' AND merchantid = 'ATVPDKIKX0DER'
116 0.0001 0.00013113021850586
SELECT * FROM productoffers
                WHERE product_id = '824' AND price > 0
                ORDER BY price ASC LIMIT 1
117 0.0001 0.00013995170593262
SELECT value FROM productattributes WHERE product_id = '824' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0001 0.00011301040649414
SELECT * FROM productimages WHERE product_id = '828' ORDER BY sortorder ASC
119 0.0001 0.0001370906829834
SELECT * FROM product_image_select WHERE product_id = '828'
120 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '828'
121 0.0006 0.00061583518981934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '828' AND a.name = n.originalname
122 0.0001 0.00010085105895996
SELECT * FROM productoffers WHERE product_id = '828' AND merchantid = 'ATVPDKIKX0DER'
123 0.0001 0.00011086463928223
SELECT * FROM productoffers
                WHERE product_id = '828' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0001 0.00011610984802246
SELECT * FROM productoffers
                WHERE product_id = 828
                ORDER BY price ASC LIMIT 1
125 0.0001 0.00011801719665527
SELECT value FROM productattributes
                WHERE product_id = '828'
                AND name = 'ListPriceAmount'
126 0.0001 0.00013494491577148
SELECT value FROM productattributes WHERE product_id = '828' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0003 0.00029897689819336
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
128 0.0001 0.00013995170593262
SELECT * FROM product_image_select WHERE product_id = '7011'
129 0.0001 0.00010204315185547
SELECT * FROM productcustomimages WHERE product_id = '7011'
130 0.0010 0.0010280609130859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
131 0.0001 0.00010180473327637
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
132 0.0001 0.00010991096496582
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0001 0.00011277198791504
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
134 0.0001 0.0001220703125
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
135 0.0001 9.4890594482422E-5
SELECT * FROM productimages WHERE product_id = '7008' ORDER BY sortorder ASC
136 0.0001 0.00013494491577148
SELECT * FROM product_image_select WHERE product_id = '7008'
137 0.0001 0.00010013580322266
SELECT * FROM productcustomimages WHERE product_id = '7008'
138 0.0004 0.00044083595275879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7008' AND a.name = n.originalname
139 0.0001 9.918212890625E-5
SELECT * FROM productoffers WHERE product_id = '7008' AND merchantid = 'ATVPDKIKX0DER'
140 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = '7008' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0001 9.7990036010742E-5
SELECT * FROM productoffers
                WHERE product_id = 7008
                ORDER BY price ASC LIMIT 1
142 0.0001 0.00010991096496582
SELECT value FROM productattributes
                WHERE product_id = '7008'
                AND name = 'ListPriceAmount'
143 0.0001 0.00014591217041016
SELECT value FROM productattributes WHERE product_id = '7008' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0001 0.00010991096496582
SELECT * FROM productimages WHERE product_id = '7006' ORDER BY sortorder ASC
145 0.0001 0.0001380443572998
SELECT * FROM product_image_select WHERE product_id = '7006'
146 0.0001 0.00010800361633301
SELECT * FROM productcustomimages WHERE product_id = '7006'
147 0.0005 0.00049400329589844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7006' AND a.name = n.originalname
148 0.0001 9.8943710327148E-5
SELECT * FROM productoffers WHERE product_id = '7006' AND merchantid = 'ATVPDKIKX0DER'
149 0.0001 0.0001070499420166
SELECT * FROM productoffers
                WHERE product_id = '7006' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0001 9.7990036010742E-5
SELECT * FROM productoffers
                WHERE product_id = 7006
                ORDER BY price ASC LIMIT 1
151 0.0001 0.00011992454528809
SELECT value FROM productattributes
                WHERE product_id = '7006'
                AND name = 'ListPriceAmount'
152 0.0003 0.00034403800964355
SELECT * FROM productimages WHERE product_id = '4252' ORDER BY sortorder ASC
153 0.0001 0.00013589859008789
SELECT * FROM product_image_select WHERE product_id = '4252'
154 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '4252'
155 0.0003 0.00030398368835449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4252' AND a.name = n.originalname
156 0.0001 9.8943710327148E-5
SELECT * FROM productoffers WHERE product_id = '4252' AND merchantid = 'ATVPDKIKX0DER'
157 0.0001 0.0001070499420166
SELECT * FROM productoffers
                WHERE product_id = '4252' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0001 0.00010204315185547
SELECT * FROM productoffers
                WHERE product_id = 4252
                ORDER BY price ASC LIMIT 1
159 0.0001 0.00011301040649414
SELECT value FROM productattributes
                WHERE product_id = '4252'
                AND name = 'ListPriceAmount'
160 0.0001 0.00014805793762207
SELECT value FROM productattributes WHERE product_id = '4252' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0001 0.00012803077697754
SELECT * FROM productimages WHERE product_id = '7005' ORDER BY sortorder ASC
162 0.0001 0.00014615058898926
SELECT * FROM product_image_select WHERE product_id = '7005'
163 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '7005'
164 0.0005 0.00054502487182617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7005' AND a.name = n.originalname
165 0.0001 0.00010800361633301
SELECT * FROM productoffers WHERE product_id = '7005' AND merchantid = 'ATVPDKIKX0DER'
166 0.0001 0.00012612342834473
SELECT * FROM productoffers
                WHERE product_id = '7005' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0001 0.00014400482177734
SELECT value FROM productattributes WHERE product_id = '7005' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0001 0.00012397766113281
SELECT * FROM productimages WHERE product_id = '6750' ORDER BY sortorder ASC
169 0.0001 0.0001378059387207
SELECT * FROM product_image_select WHERE product_id = '6750'
170 0.0001 9.8228454589844E-5
SELECT * FROM productcustomimages WHERE product_id = '6750'
171 0.0004 0.0003972053527832
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6750' AND a.name = n.originalname
172 0.0001 0.00011515617370605
SELECT * FROM productoffers WHERE product_id = '6750' AND merchantid = 'ATVPDKIKX0DER'
173 0.0001 0.0001070499420166
SELECT * FROM productoffers
                WHERE product_id = '6750' AND price > 0
                ORDER BY price ASC LIMIT 1
174 0.0001 0.00010514259338379
SELECT * FROM productoffers
                WHERE product_id = 6750
                ORDER BY price ASC LIMIT 1
175 0.0001 0.00011491775512695
SELECT value FROM productattributes
                WHERE product_id = '6750'
                AND name = 'ListPriceAmount'
176 0.0001 0.00014495849609375
SELECT value FROM productattributes WHERE product_id = '6750' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0001 0.00011706352233887
SELECT * FROM productimages WHERE product_id = '6996' ORDER BY sortorder ASC
178 0.0001 0.0001368522644043
SELECT * FROM product_image_select WHERE product_id = '6996'
179 0.0001 0.0001070499420166
SELECT * FROM productcustomimages WHERE product_id = '6996'
180 0.0005 0.00046992301940918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6996' AND a.name = n.originalname
181 0.0001 0.00010204315185547
SELECT * FROM productoffers WHERE product_id = '6996' AND merchantid = 'ATVPDKIKX0DER'
182 0.0001 0.0001060962677002
SELECT * FROM productoffers
                WHERE product_id = '6996' AND price > 0
                ORDER BY price ASC LIMIT 1
183 0.0001 0.00010299682617188
SELECT * FROM productoffers
                WHERE product_id = 6996
                ORDER BY price ASC LIMIT 1
184 0.0001 0.00011801719665527
SELECT value FROM productattributes
                WHERE product_id = '6996'
                AND name = 'ListPriceAmount'
185 0.0001 0.00011801719665527
SELECT * FROM productimages WHERE product_id = '6997' ORDER BY sortorder ASC
186 0.0001 0.0001370906829834
SELECT * FROM product_image_select WHERE product_id = '6997'
187 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '6997'
188 0.0007 0.0007481575012207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6997' AND a.name = n.originalname
189 0.0001 0.00010395050048828
SELECT * FROM productoffers WHERE product_id = '6997' AND merchantid = 'ATVPDKIKX0DER'
190 0.0001 0.00010991096496582
SELECT * FROM productoffers
                WHERE product_id = '6997' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0001 0.00011587142944336
SELECT * FROM productoffers
                WHERE product_id = 6997
                ORDER BY price ASC LIMIT 1
192 0.0001 0.0001218318939209
SELECT value FROM productattributes
                WHERE product_id = '6997'
                AND name = 'ListPriceAmount'
193 0.0001 0.00011801719665527
SELECT * FROM productimages WHERE product_id = '6998' ORDER BY sortorder ASC
194 0.0002 0.00017404556274414
SELECT * FROM product_image_select WHERE product_id = '6998'
195 0.0001 9.9897384643555E-5
SELECT * FROM productcustomimages WHERE product_id = '6998'
196 0.0005 0.0005040168762207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6998' AND a.name = n.originalname
197 0.0001 9.9897384643555E-5
SELECT * FROM productoffers WHERE product_id = '6998' AND merchantid = 'ATVPDKIKX0DER'
198 0.0001 0.00011587142944336
SELECT * FROM productoffers
                WHERE product_id = '6998' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0001 0.00011587142944336
SELECT * FROM productoffers
                WHERE product_id = 6998
                ORDER BY price ASC LIMIT 1
200 0.0001 0.00011181831359863
SELECT value FROM productattributes
                WHERE product_id = '6998'
                AND name = 'ListPriceAmount'
201 0.0001 0.00011587142944336
SELECT * FROM productimages WHERE product_id = '6999' ORDER BY sortorder ASC
202 0.0001 0.0001380443572998
SELECT * FROM product_image_select WHERE product_id = '6999'
203 0.0001 0.00011181831359863
SELECT * FROM productcustomimages WHERE product_id = '6999'
204 0.0004 0.00039982795715332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6999' AND a.name = n.originalname
205 0.0001 0.00010585784912109
SELECT * FROM productoffers WHERE product_id = '6999' AND merchantid = 'ATVPDKIKX0DER'
206 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '6999' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0001 0.00013589859008789
SELECT value FROM productattributes WHERE product_id = '6999' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0001 0.00012922286987305
SELECT * FROM productimages WHERE product_id = '7847' ORDER BY sortorder ASC
209 0.0001 0.00013399124145508
SELECT * FROM product_image_select WHERE product_id = '7847'
210 0.0001 0.0001070499420166
SELECT * FROM productcustomimages WHERE product_id = '7847'
211 0.0004 0.00038504600524902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7847' AND a.name = n.originalname
212 0.0001 0.00010585784912109
SELECT * FROM productoffers WHERE product_id = '7847' AND merchantid = 'ATVPDKIKX0DER'
213 0.0001 0.00013494491577148
SELECT * FROM productoffers
                WHERE product_id = '7847' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0001 0.00013399124145508
SELECT value FROM productattributes WHERE product_id = '7847' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0006 0.00057291984558105
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
216 0.0006 0.00055909156799316
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
217 0.0001 8.2969665527344E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
218 0.0001 0.00012612342834473
SELECT * FROM pages WHERE id = 38
219 0.0001 0.0001220703125
SELECT * FROM categories WHERE id = '27'
220 0.0002 0.00021696090698242
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
221 0.0001 7.3909759521484E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
222 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '27'
223 0.0002 0.00021910667419434
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 
224 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 
225 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
226 0.0001 8.5115432739258E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
227 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 = 27
228 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
229 0.0002 0.00020694732666016
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 
230 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 
231 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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
232 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
233 0.0001 8.702278137207E-5
SELECT id FROM categories WHERE parent_id = '27'
234 0.0005 0.00051116943359375
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
235 0.0003 0.00033402442932129
SELECT * FROM productimages WHERE product_id = '750' ORDER BY sortorder ASC
236 0.0006 0.00055289268493652
SELECT * FROM categoryimages WHERE category_id = 27
237 0.0001 8.6069107055664E-5
SELECT * FROM categorygroups WHERE id = '1'
238 0.0002 0.00022387504577637
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
239 0.0001 9.608268737793E-5
SELECT * FROM categories WHERE id = '30'
240 0.0003 0.00028300285339355
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
241 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
242 0.0001 7.8916549682617E-5
SELECT id FROM categories WHERE parent_id = '30'
243 0.0003 0.00029897689819336
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 
244 0.0001 8.1777572631836E-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 
245 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
246 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
247 0.0003 0.0003049373626709
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
248 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
249 0.0003 0.00028014183044434
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 
250 0.0001 8.0108642578125E-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 
251 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
252 0.0001 6.9141387939453E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
253 0.0001 8.6069107055664E-5
SELECT id FROM categories WHERE parent_id = '30'
254 0.0003 0.00029683113098145
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
255 0.0001 0.00013113021850586
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
256 0.0001 8.082389831543E-5
SELECT * FROM categoryimages WHERE category_id = 30
257 0.0001 9.8943710327148E-5
SELECT * FROM categorygroups WHERE id = '1'
258 0.0003 0.00029110908508301
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
259 0.0001 0.00010585784912109
SELECT * FROM pages WHERE id = 59
260 0.0001 9.7036361694336E-5
SELECT * FROM pages WHERE id = 55
261 0.0001 0.00014901161193848
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
262 0.0001 0.00013113021850586
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:1660778280;s:8:\"products\";a:0:{}}' WHERE id = '8'
263 0.0002 0.00022792816162109
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
264 0.0001 0.00010395050048828
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:1660778280;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'
265 0.0001 0.00013399124145508
SELECT * FROM products WHERE id = 7004
266 0.0001 0.00013303756713867
SELECT * FROM products WHERE id = 7011
267 0.0001 0.00011396408081055
SELECT * FROM products WHERE id = 7045
268 0.0001 0.00011301040649414
SELECT * FROM products WHERE id = '7004'
269 0.0001 0.00012683868408203
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
270 0.0001 0.0001380443572998
SELECT * FROM product_image_select WHERE product_id = '7004'
271 0.0001 9.9897384643555E-5
SELECT * FROM productcustomimages WHERE product_id = '7004'
272 0.0005 0.0004878044128418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
273 0.0001 0.0001068115234375
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
274 0.0001 0.00013184547424316
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
275 0.0001 0.00014209747314453
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
276 0.0001 0.00014710426330566
SELECT * FROM products WHERE id = '7011'
277 0.0001 0.00012493133544922
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
278 0.0001 0.0001370906829834
SELECT * FROM product_image_select WHERE product_id = '7011'
279 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
280 0.0006 0.0005638599395752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
281 0.0001 0.00010013580322266
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
282 0.0001 0.0001070499420166
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
283 0.0001 0.00010204315185547
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
284 0.0001 0.00011992454528809
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
285 0.0001 0.00012803077697754
SELECT * FROM products WHERE id = '7045'
286 0.0001 0.00010108947753906
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
287 0.0001 0.00014090538024902
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
288 0.0001 0.0001370906829834
SELECT * FROM product_image_select WHERE product_id = '7045'
289 0.0001 9.9897384643555E-5
SELECT * FROM productcustomimages WHERE product_id = '7045'
290 0.0001 0.0001368522644043
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
291 0.0011 0.0011270046234131
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
292 0.0001 0.00013303756713867
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
293 0.0005 0.00053191184997559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
294 0.0001 9.9897384643555E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
295 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
296 0.0001 9.7990036010742E-5
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
297 0.0001 0.00012803077697754
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
298 0.0001 0.00013613700866699
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
299 0.0002 0.00018596649169922
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
300 0.0001 0.00012993812561035
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
301 0.0001 0.00014209747314453
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302 0.0002 0.00015997886657715
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
303 0.0002 0.00016498565673828
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
304 0.0005 0.00051188468933105
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
305 0.0002 0.00019502639770508
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
306 0.0011 0.0010979175567627
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
307 0.0005 0.00049400329589844
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
308 0.0002 0.00015711784362793
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
309 0.0003 0.00028109550476074
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
310 0.0002 0.00022101402282715
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
311 0.0002 0.0001521110534668
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'