All Products

Select your options below to filter out the products you don't want to see.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.34882783889771 295 0.0907 0


No Amazon API Requests Made.


App Debug - Total Time 0.34882783889771 seconds

Number Time From Start Name Description
1 0.22803401947021 Initialise Initialise FSB Function
2 0.22880792617798 App Controller Start Start of the App controller (called before the controller of every page)
3 0.23377704620361 Start of getCategoryListByGroup Function Before first category groups query
4 0.23393797874451 After initial query Before first category groups query
5 0.23393797874451 Get Category List for Group Before the call to getCategoryList function
6 0.23394083976746 Start of GetCategoryList function Start of the function
7 0.23394298553467 Before getting categories Query to get specific category list
8 0.23414993286133 After getting categories Query to get specific category list
9 0.23414993286133 Before getting category custom Before call to function getCategoryCustom
10 0.23564505577087 After getting category custom After call to function getCategoryCustom
11 0.23565101623535 Before getting category custom Before call to function getCategoryCustom
12 0.2369339466095 After getting category custom After call to function getCategoryCustom
13 0.23693585395813 Before getting category custom Before call to function getCategoryCustom
14 0.2382390499115 After getting category custom After call to function getCategoryCustom
15 0.23824000358582 Before getting category custom Before call to function getCategoryCustom
16 0.23932886123657 After getting category custom After call to function getCategoryCustom
17 0.23933005332947 End of GetCategoryList function End of the function
18 0.23933291435242 Get Category List for Group Before the call to getCategoryList function
19 0.23933386802673 Start of GetCategoryList function Start of the function
20 0.23933506011963 Before getting categories Query to get specific category list
21 0.23945689201355 End of getCategoryListByGroup Function Before return()
22 0.27056884765625 App Controller End End of the App controller (called before the controller of every page)
23 0.30130791664124 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
24 0.30187201499939 App_after Controller Start Start of the App_after controller (called after the controller of every page)
25 0.30215096473694 Before Get Options Before the call to getOptions in the tpl class
26 0.32483983039856 After Get Options After the call to getOptions in the tpl class
27 0.32507395744324 App_after Controller End End of the App_after controller (called after the controller of every page)
28 0.34881782531738 Finalizing debug Before the debug is output to the page.
29 0.34882783889771 End of App This is the end of the app logging, final timestamp


Query Debug - 295 Database Queries. Total time 0.0907 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.0002439022064209
SELECT parameter, value FROM parameters
2 0.0005 0.00047183036804199
SELECT * FROM `bad_bots`
3 0.0002 0.00019502639770508
SET time_zone = 'Europe/London'
4 0.0002 0.00017905235290527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0003 0.00029706954956055
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.208.132.74\";}'
6 0.0002 0.0001990795135498
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1665029103'
7 0.0003 0.00033402442932129
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00015997886657715
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0002 0.00020408630371094
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0001 0.0001070499420166
SELECT * FROM pages WHERE id = 42
11 0.0004 0.00038790702819824
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
12 0.0040 0.0040371417999268
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
13 0.0001 0.00012803077697754
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0002 0.00015091896057129
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0002 0.00019216537475586
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00031685829162598
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.00015497207641602
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.00011396408081055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
19 0.0001 9.2029571533203E-5
SELECT id FROM categories WHERE parent_id = '27'
20 0.0002 0.00021696090698242
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.00012993812561035
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 0.00014805793762207
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.00011610984802246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
24 0.0001 8.702278137207E-5
SELECT * FROM categorygroups WHERE id = '1'
25 0.0003 0.00025486946105957
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 0.00010204315185547
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 8.8930130004883E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
28 0.0001 0.00014805793762207
SELECT id FROM categories WHERE parent_id = '29'
29 0.0002 0.00024700164794922
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.702278137207E-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.00010323524475098
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.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
33 0.0001 9.4890594482422E-5
SELECT * FROM categorygroups WHERE id = '1'
34 0.0003 0.00030088424682617
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
35 0.0001 9.7036361694336E-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.5101852416992E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
37 0.0001 8.5830688476562E-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 9.4890594482422E-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.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
41 0.0001 8.392333984375E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
42 0.0001 9.0122222900391E-5
SELECT * FROM categorygroups WHERE id = '1'
43 0.0002 0.00017905235290527
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.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 = 38
45 0.0001 7.4863433837891E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
46 0.0001 8.4877014160156E-5
SELECT id FROM categories WHERE parent_id = '38'
47 0.0002 0.00020790100097656
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.702278137207E-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 0.00011086463928223
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.319450378418E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
51 0.0001 8.8214874267578E-5
SELECT * FROM categorygroups WHERE id = '1'
52 0.0001 0.00011396408081055
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
53 0.0005 0.00050187110900879
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
54 0.0002 0.00022292137145996
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
55 0.0002 0.0001990795135498
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
56 0.0002 0.0002131462097168
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
57 0.0003 0.00033688545227051
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
58 0.0284 0.028362989425659
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.00028300285339355
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
60 0.0001 0.00011205673217773
SELECT * FROM countryredirects WHERE countrycode = 'US'
61 0.0002 0.00015091896057129
SELECT * FROM pages WHERE pagename = 'all-products'
62 0.0005 0.00051498413085938
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
63 0.0005 0.00049114227294922
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
64 0.0002 0.0001671314239502
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
65 0.0005 0.00046300888061523
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
66 0.0005 0.00045394897460938
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
67 0.0001 0.00011801719665527
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
68 0.0007 0.00074410438537598
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
69 0.0004 0.00043916702270508
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
70 0.0005 0.00045585632324219
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
71 0.0001 0.00011801719665527
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
72 0.0006 0.00059700012207031
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 0, 18
73 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
74 0.0002 0.00018692016601562
SELECT * FROM product_image_select WHERE product_id = '785'
75 0.0001 0.00014090538024902
SELECT * FROM productcustomimages WHERE product_id = '785'
76 0.0005 0.0005340576171875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '785' AND a.name = n.originalname
77 0.0002 0.00015807151794434
SELECT * FROM productoffers WHERE product_id = '785' AND merchantid = 'ATVPDKIKX0DER'
78 0.0001 0.00012707710266113
SELECT * FROM productoffers
                WHERE product_id = '785' AND price > 0
                ORDER BY price ASC LIMIT 1
79 0.0001 0.00014305114746094
SELECT value FROM productattributes WHERE product_id = '785' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
80 0.0001 0.00014400482177734
SELECT * FROM productimages WHERE product_id = '821' ORDER BY sortorder ASC
81 0.0001 0.00014996528625488
SELECT * FROM product_image_select WHERE product_id = '821'
82 0.0001 0.00010490417480469
SELECT * FROM productcustomimages WHERE product_id = '821'
83 0.0003 0.00033807754516602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '821' AND a.name = n.originalname
84 0.0001 0.00010919570922852
SELECT * FROM productoffers WHERE product_id = '821' AND merchantid = 'ATVPDKIKX0DER'
85 0.0001 0.00013208389282227
SELECT * FROM productoffers
                WHERE product_id = '821' AND price > 0
                ORDER BY price ASC LIMIT 1
86 0.0001 0.00014019012451172
SELECT value FROM productattributes WHERE product_id = '821' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
87 0.0001 0.00012493133544922
SELECT * FROM productimages WHERE product_id = '7824' ORDER BY sortorder ASC
88 0.0001 0.00014090538024902
SELECT * FROM product_image_select WHERE product_id = '7824'
89 0.0001 9.918212890625E-5
SELECT * FROM productcustomimages WHERE product_id = '7824'
90 0.0003 0.00034785270690918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7824' AND a.name = n.originalname
91 0.0001 0.00010395050048828
SELECT * FROM productoffers WHERE product_id = '7824' AND merchantid = 'ATVPDKIKX0DER'
92 0.0001 0.00014209747314453
SELECT * FROM productoffers
                WHERE product_id = '7824' AND price > 0
                ORDER BY price ASC LIMIT 1
93 0.0001 0.0001380443572998
SELECT value FROM productattributes WHERE product_id = '7824' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
94 0.0001 0.00012803077697754
SELECT * FROM productimages WHERE product_id = '830' ORDER BY sortorder ASC
95 0.0001 0.00014901161193848
SELECT * FROM product_image_select WHERE product_id = '830'
96 0.0001 0.00010108947753906
SELECT * FROM productcustomimages WHERE product_id = '830'
97 0.0005 0.00048708915710449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '830' AND a.name = n.originalname
98 0.0001 0.00011396408081055
SELECT * FROM productoffers WHERE product_id = '830' AND merchantid = 'ATVPDKIKX0DER'
99 0.0001 0.00012087821960449
SELECT * FROM productoffers
                WHERE product_id = '830' AND price > 0
                ORDER BY price ASC LIMIT 1
100 0.0001 0.00014686584472656
SELECT value FROM productattributes WHERE product_id = '830' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
101 0.0001 0.00011706352233887
SELECT * FROM productimages WHERE product_id = '7834' ORDER BY sortorder ASC
102 0.0001 0.00014019012451172
SELECT * FROM product_image_select WHERE product_id = '7834'
103 0.0001 0.0001070499420166
SELECT * FROM productcustomimages WHERE product_id = '7834'
104 0.0006 0.00064516067504883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7834' AND a.name = n.originalname
105 0.0001 0.00012302398681641
SELECT * FROM productoffers WHERE product_id = '7834' AND merchantid = 'ATVPDKIKX0DER'
106 0.0001 0.00012087821960449
SELECT * FROM productoffers
                WHERE product_id = '7834' AND price > 0
                ORDER BY price ASC LIMIT 1
107 0.0002 0.00015783309936523
SELECT value FROM productattributes WHERE product_id = '7834' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
108 0.0001 0.00011491775512695
SELECT * FROM productimages WHERE product_id = '7839' ORDER BY sortorder ASC
109 0.0001 0.00013303756713867
SELECT * FROM product_image_select WHERE product_id = '7839'
110 0.0001 0.00010800361633301
SELECT * FROM productcustomimages WHERE product_id = '7839'
111 0.0006 0.0006098747253418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7839' AND a.name = n.originalname
112 0.0001 0.00010895729064941
SELECT * FROM productoffers WHERE product_id = '7839' AND merchantid = 'ATVPDKIKX0DER'
113 0.0001 0.0001218318939209
SELECT * FROM productoffers
                WHERE product_id = '7839' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0001 0.00013399124145508
SELECT value FROM productattributes WHERE product_id = '7839' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0001 0.00011301040649414
SELECT * FROM productimages WHERE product_id = '7836' ORDER BY sortorder ASC
116 0.0001 0.00014185905456543
SELECT * FROM product_image_select WHERE product_id = '7836'
117 0.0001 0.00011396408081055
SELECT * FROM productcustomimages WHERE product_id = '7836'
118 0.0005 0.00047183036804199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7836' AND a.name = n.originalname
119 0.0001 0.00010395050048828
SELECT * FROM productoffers WHERE product_id = '7836' AND merchantid = 'ATVPDKIKX0DER'
120 0.0001 0.00012993812561035
SELECT * FROM productoffers
                WHERE product_id = '7836' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0001 0.00014495849609375
SELECT value FROM productattributes WHERE product_id = '7836' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0001 0.00012707710266113
SELECT * FROM productimages WHERE product_id = '7833' ORDER BY sortorder ASC
123 0.0001 0.00013995170593262
SELECT * FROM product_image_select WHERE product_id = '7833'
124 0.0001 0.00010180473327637
SELECT * FROM productcustomimages WHERE product_id = '7833'
125 0.0004 0.00038981437683105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7833' AND a.name = n.originalname
126 0.0001 0.0001070499420166
SELECT * FROM productoffers WHERE product_id = '7833' AND merchantid = 'ATVPDKIKX0DER'
127 0.0001 0.00013399124145508
SELECT * FROM productoffers
                WHERE product_id = '7833' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0001 0.00013589859008789
SELECT value FROM productattributes WHERE product_id = '7833' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0001 0.00011086463928223
SELECT * FROM productimages WHERE product_id = '7838' ORDER BY sortorder ASC
130 0.0001 0.00014400482177734
SELECT * FROM product_image_select WHERE product_id = '7838'
131 0.0001 0.00010204315185547
SELECT * FROM productcustomimages WHERE product_id = '7838'
132 0.0003 0.00033712387084961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7838' AND a.name = n.originalname
133 0.0001 0.00012612342834473
SELECT * FROM productoffers WHERE product_id = '7838' AND merchantid = 'ATVPDKIKX0DER'
134 0.0001 0.00013399124145508
SELECT * FROM productoffers
                WHERE product_id = '7838' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0001 0.0001370906829834
SELECT value FROM productattributes WHERE product_id = '7838' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0001 0.0001220703125
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
137 0.0001 0.00014710426330566
SELECT * FROM product_image_select WHERE product_id = '812'
138 0.0001 0.00010800361633301
SELECT * FROM productcustomimages WHERE product_id = '812'
139 0.0004 0.00040197372436523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '812' AND a.name = n.originalname
140 0.0001 0.00010395050048828
SELECT * FROM productoffers WHERE product_id = '812' AND merchantid = 'ATVPDKIKX0DER'
141 0.0001 0.00011992454528809
SELECT * FROM productoffers
                WHERE product_id = '812' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0002 0.00015115737915039
SELECT value FROM productattributes WHERE product_id = '812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0001 0.00011086463928223
SELECT * FROM productimages WHERE product_id = '7835' ORDER BY sortorder ASC
144 0.0002 0.00015091896057129
SELECT * FROM product_image_select WHERE product_id = '7835'
145 0.0001 0.00010299682617188
SELECT * FROM productcustomimages WHERE product_id = '7835'
146 0.0004 0.00044894218444824
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7835' AND a.name = n.originalname
147 0.0001 0.00011301040649414
SELECT * FROM productoffers WHERE product_id = '7835' AND merchantid = 'ATVPDKIKX0DER'
148 0.0001 0.00011801719665527
SELECT * FROM productoffers
                WHERE product_id = '7835' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00015711784362793
SELECT value FROM productattributes WHERE product_id = '7835' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0001 0.00011205673217773
SELECT * FROM productimages WHERE product_id = '7831' ORDER BY sortorder ASC
151 0.0001 0.00013089179992676
SELECT * FROM product_image_select WHERE product_id = '7831'
152 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '7831'
153 0.0003 0.00033903121948242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7831' AND a.name = n.originalname
154 0.0001 0.00010299682617188
SELECT * FROM productoffers WHERE product_id = '7831' AND merchantid = 'ATVPDKIKX0DER'
155 0.0001 0.0001370906829834
SELECT * FROM productoffers
                WHERE product_id = '7831' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0001 0.00012803077697754
SELECT value FROM productattributes WHERE product_id = '7831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0001 0.00010895729064941
SELECT * FROM productimages WHERE product_id = '7832' ORDER BY sortorder ASC
158 0.0001 0.00013899803161621
SELECT * FROM product_image_select WHERE product_id = '7832'
159 0.0001 9.9897384643555E-5
SELECT * FROM productcustomimages WHERE product_id = '7832'
160 0.0004 0.00036287307739258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7832' AND a.name = n.originalname
161 0.0001 0.00011110305786133
SELECT * FROM productoffers WHERE product_id = '7832' AND merchantid = 'ATVPDKIKX0DER'
162 0.0001 0.00012397766113281
SELECT * FROM productoffers
                WHERE product_id = '7832' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0001 0.00012993812561035
SELECT value FROM productattributes WHERE product_id = '7832' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0001 0.00011420249938965
SELECT * FROM productimages WHERE product_id = '7837' ORDER BY sortorder ASC
165 0.0001 0.00013899803161621
SELECT * FROM product_image_select WHERE product_id = '7837'
166 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7837'
167 0.0004 0.00040316581726074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7837' AND a.name = n.originalname
168 0.0001 0.00010514259338379
SELECT * FROM productoffers WHERE product_id = '7837' AND merchantid = 'ATVPDKIKX0DER'
169 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '7837' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0001 0.00013494491577148
SELECT value FROM productattributes WHERE product_id = '7837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0002 0.00022220611572266
SELECT * FROM productimages WHERE product_id = '820' ORDER BY sortorder ASC
172 0.0001 0.00014901161193848
SELECT * FROM product_image_select WHERE product_id = '820'
173 0.0001 9.9897384643555E-5
SELECT * FROM productcustomimages WHERE product_id = '820'
174 0.0003 0.00029993057250977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '820' AND a.name = n.originalname
175 0.0001 0.00010204315185547
SELECT * FROM productoffers WHERE product_id = '820' AND merchantid = 'ATVPDKIKX0DER'
176 0.0001 0.00012707710266113
SELECT * FROM productoffers
                WHERE product_id = '820' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0001 0.00012707710266113
SELECT value FROM productattributes WHERE product_id = '820' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178 0.0001 0.0001227855682373
SELECT * FROM productimages WHERE product_id = '775' ORDER BY sortorder ASC
179 0.0001 0.00013613700866699
SELECT * FROM product_image_select WHERE product_id = '775'
180 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '775'
181 0.0005 0.00046491622924805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '775' AND a.name = n.originalname
182 0.0001 0.00011610984802246
SELECT * FROM productoffers WHERE product_id = '775' AND merchantid = 'ATVPDKIKX0DER'
183 0.0001 0.00011801719665527
SELECT * FROM productoffers
                WHERE product_id = '775' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0001 0.0001378059387207
SELECT value FROM productattributes WHERE product_id = '775' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0001 0.00013613700866699
SELECT * FROM productimages WHERE product_id = '749' ORDER BY sortorder ASC
186 0.0001 0.00014281272888184
SELECT * FROM product_image_select WHERE product_id = '749'
187 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '749'
188 0.0005 0.0004570484161377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '749' AND a.name = n.originalname
189 0.0001 0.00010514259338379
SELECT * FROM productoffers WHERE product_id = '749' AND merchantid = 'ATVPDKIKX0DER'
190 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '749' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0001 0.00013589859008789
SELECT value FROM productattributes WHERE product_id = '749' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0001 0.00012612342834473
SELECT * FROM productimages WHERE product_id = '7840' ORDER BY sortorder ASC
193 0.0001 0.00013494491577148
SELECT * FROM product_image_select WHERE product_id = '7840'
194 0.0001 0.00011014938354492
SELECT * FROM productcustomimages WHERE product_id = '7840'
195 0.0006 0.00061798095703125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7840' AND a.name = n.originalname
196 0.0001 0.00010991096496582
SELECT * FROM productoffers WHERE product_id = '7840' AND merchantid = 'ATVPDKIKX0DER'
197 0.0001 0.00013089179992676
SELECT * FROM productoffers
                WHERE product_id = '7840' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0001 0.0001368522644043
SELECT value FROM productattributes WHERE product_id = '7840' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
199 0.0002 0.00015497207641602
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
200 0.0001 0.00012803077697754
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
201 0.0001 8.392333984375E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
202 0.0001 0.00010299682617188
SELECT * FROM pages WHERE id = 38
203 0.0001 9.7036361694336E-5
SELECT * FROM categories WHERE id = '27'
204 0.0002 0.00020313262939453
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
205 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
206 0.0001 8.2015991210938E-5
SELECT id FROM categories WHERE parent_id = '27'
207 0.0002 0.00020503997802734
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 
208 0.0001 9.9897384643555E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
209 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
210 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
211 0.0002 0.00017213821411133
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
212 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
213 0.0002 0.00018501281738281
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 
214 0.0001 8.9168548583984E-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 
215 0.0001 9.5129013061523E-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
216 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
217 0.0001 8.8930130004883E-5
SELECT id FROM categories WHERE parent_id = '27'
218 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
219 0.0001 0.00013279914855957
SELECT * FROM productimages WHERE product_id = '798' ORDER BY sortorder ASC
220 0.0001 0.00011682510375977
SELECT * FROM categoryimages WHERE category_id = 27
221 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
222 0.0002 0.00020813941955566
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
223 0.0001 0.00010895729064941
SELECT * FROM categories WHERE id = '30'
224 0.0003 0.00026488304138184
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
225 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
226 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '30'
227 0.0003 0.00030112266540527
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 
228 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 
229 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
230 0.0001 8.082389831543E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
231 0.0003 0.00026512145996094
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
232 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
233 0.0003 0.00027704238891602
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 
234 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 
235 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
236 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
237 0.0001 8.7976455688477E-5
SELECT id FROM categories WHERE parent_id = '30'
238 0.0003 0.00029993057250977
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
239 0.0001 0.00012993812561035
SELECT * FROM productimages WHERE product_id = '821' ORDER BY sortorder ASC
240 0.0001 7.9154968261719E-5
SELECT * FROM categoryimages WHERE category_id = 30
241 0.0001 7.7962875366211E-5
SELECT * FROM categorygroups WHERE id = '1'
242 0.0003 0.00031399726867676
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
243 0.0001 8.8930130004883E-5
SELECT * FROM pages WHERE id = 59
244 0.0001 0.00010108947753906
SELECT * FROM pages WHERE id = 55
245 0.0002 0.00016498565673828
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
246 0.0001 0.00012493133544922
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:1665029104;s:8:\"products\";a:0:{}}' WHERE id = '8'
247 0.0002 0.00023317337036133
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
248 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:1665029104;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'
249 0.0001 0.00014209747314453
SELECT * FROM products WHERE id = 7004
250 0.0001 0.00011897087097168
SELECT * FROM products WHERE id = 7011
251 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = 7045
252 0.0001 0.00011706352233887
SELECT * FROM products WHERE id = '7004'
253 0.0001 0.00013113021850586
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
254 0.0001 0.00014686584472656
SELECT * FROM product_image_select WHERE product_id = '7004'
255 0.0001 0.00010514259338379
SELECT * FROM productcustomimages WHERE product_id = '7004'
256 0.0005 0.00049114227294922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
257 0.0001 0.00011301040649414
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
258 0.0001 0.0001370906829834
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
259 0.0001 0.00014519691467285
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260 0.0001 0.00013279914855957
SELECT * FROM products WHERE id = '7011'
261 0.0001 0.00010895729064941
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
262 0.0001 0.00014376640319824
SELECT * FROM product_image_select WHERE product_id = '7011'
263 0.0001 0.00010204315185547
SELECT * FROM productcustomimages WHERE product_id = '7011'
264 0.0006 0.00055909156799316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
265 0.0001 0.00010395050048828
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
266 0.0001 0.00010895729064941
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
267 0.0001 0.00011610984802246
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
268 0.0001 0.00012803077697754
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
269 0.0001 0.00012612342834473
SELECT * FROM products WHERE id = '7045'
270 0.0001 0.00010514259338379
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
271 0.0002 0.0001680850982666
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
272 0.0001 0.0001380443572998
SELECT * FROM product_image_select WHERE product_id = '7045'
273 0.0001 0.00010108947753906
SELECT * FROM productcustomimages WHERE product_id = '7045'
274 0.0001 0.00013899803161621
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
275 0.0003 0.00026798248291016
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
276 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
277 0.0006 0.00055289268493652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
278 0.0001 9.8943710327148E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
279 0.0001 0.0001070499420166
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0001 0.00011110305786133
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
281 0.0001 0.00012016296386719
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
282 0.0002 0.00015497207641602
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
283 0.0002 0.00018310546875
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
284 0.0001 0.00011396408081055
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
285 0.0002 0.00015091896057129
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
286 0.0002 0.0001680850982666
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
287 0.0002 0.00015401840209961
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
288 0.0073 0.0072860717773438
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
289 0.0002 0.00021982192993164
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
290 0.0005 0.00045990943908691
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
291 0.0002 0.0002291202545166
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
292 0.0002 0.0001680850982666
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
293 0.0003 0.00030684471130371
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
294 0.0002 0.00015807151794434
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
295 0.0001 0.00014591217041016
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'