All Products

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.48307609558105 316 0.0999 0


No Amazon API Requests Made.


App Debug - Total Time 0.48307609558105 seconds

Number Time From Start Name Description
1 0.34296607971191 Initialise Initialise FSB Function
2 0.34369301795959 App Controller Start Start of the App controller (called before the controller of every page)
3 0.36139392852783 Start of getCategoryListByGroup Function Before first category groups query
4 0.36151695251465 After initial query Before first category groups query
5 0.36151790618896 Get Category List for Group Before the call to getCategoryList function
6 0.36152005195618 Start of GetCategoryList function Start of the function
7 0.36152291297913 Before getting categories Query to get specific category list
8 0.36168098449707 After getting categories Query to get specific category list
9 0.36168193817139 Before getting category custom Before call to function getCategoryCustom
10 0.36293697357178 After getting category custom After call to function getCategoryCustom
11 0.36293888092041 Before getting category custom Before call to function getCategoryCustom
12 0.36416101455688 After getting category custom After call to function getCategoryCustom
13 0.36416292190552 Before getting category custom Before call to function getCategoryCustom
14 0.3654100894928 After getting category custom After call to function getCategoryCustom
15 0.36541104316711 Before getting category custom Before call to function getCategoryCustom
16 0.36645007133484 After getting category custom After call to function getCategoryCustom
17 0.36645102500916 End of GetCategoryList function End of the function
18 0.3664538860321 Get Category List for Group Before the call to getCategoryList function
19 0.366455078125 Start of GetCategoryList function Start of the function
20 0.36645698547363 Before getting categories Query to get specific category list
21 0.3665828704834 End of getCategoryListByGroup Function Before return()
22 0.39880394935608 App Controller End End of the App controller (called before the controller of every page)
23 0.43391704559326 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
24 0.43449902534485 App_after Controller Start Start of the App_after controller (called after the controller of every page)
25 0.43476700782776 Before Get Options Before the call to getOptions in the tpl class
26 0.45013999938965 After Get Options After the call to getOptions in the tpl class
27 0.45029091835022 App_after Controller End End of the App_after controller (called after the controller of every page)
28 0.48306703567505 Finalizing debug Before the debug is output to the page.
29 0.48307490348816 End of App This is the end of the app logging, final timestamp


Query Debug - 316 Database Queries. Total time 0.0999 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0003 0.00026607513427734
SELECT parameter, value FROM parameters
2 0.0003 0.00033020973205566
SELECT * FROM `bad_bots`
3 0.0009 0.00087189674377441
SET time_zone = 'Europe/London'
4 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0002 0.00018095970153809
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"54.173.214.227\";}'
6 0.0001 0.00011110305786133
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1642886448'
7 0.0003 0.00025320053100586
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00015377998352051
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0002 0.0001530647277832
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0001 0.00012087821960449
SELECT * FROM pages WHERE id = 42
11 0.0003 0.00033807754516602
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
12 0.0167 0.016651153564453
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
13 0.0001 0.0001378059387207
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0001 0.00010204315185547
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0001 0.00014400482177734
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00025296211242676
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
17 0.0001 0.00013518333435059
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 7.7962875366211E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
19 0.0001 8.5115432739258E-5
SELECT id FROM categories WHERE parent_id = '27'
20 0.0002 0.00023293495178223
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 9.2983245849609E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
22 0.0001 0.00010514259338379
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0001 7.7962875366211E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
24 0.0001 9.1075897216797E-5
SELECT * FROM categorygroups WHERE id = '1'
25 0.0003 0.00025796890258789
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 7.2956085205078E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
28 0.0001 8.2969665527344E-5
SELECT id FROM categories WHERE parent_id = '29'
29 0.0003 0.00026202201843262
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.00010204315185547
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 8.6069107055664E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
33 0.0001 8.1062316894531E-5
SELECT * FROM categorygroups WHERE id = '1'
34 0.0003 0.00027298927307129
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 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 = 30
36 0.0001 6.8187713623047E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
37 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '30'
38 0.0003 0.00030803680419922
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.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 
40 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
41 0.0001 6.9141387939453E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
42 0.0001 8.0108642578125E-5
SELECT * FROM categorygroups WHERE id = '1'
43 0.0002 0.00018596649169922
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.3936920166016E-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 6.6995620727539E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
46 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '38'
47 0.0002 0.00020289421081543
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.392333984375E-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.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 (38)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
51 0.0001 8.0108642578125E-5
SELECT * FROM categorygroups WHERE id = '1'
52 0.0001 0.00011610984802246
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
53 0.0005 0.00046205520629883
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
54 0.0002 0.00015807151794434
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
55 0.0002 0.00017309188842773
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.00022315979003906
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
57 0.0004 0.00036382675170898
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
58 0.0297 0.029661893844604
SELECT * FROM ipgeocountries WHERE INET_ATON('54.173.214.227') >= INET_ATON(ip_start) AND INET_ATON('54.173.214.227') <= INET_ATON(ip_end)
59 0.0002 0.00021505355834961
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
60 0.0001 9.2983245849609E-5
SELECT * FROM countryredirects WHERE countrycode = 'US'
61 0.0002 0.00017213821411133
SELECT * FROM pages WHERE pagename = 'all-products'
62 0.0005 0.00051593780517578
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
63 0.0005 0.00048613548278809
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
64 0.0001 0.00014495849609375
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
65 0.0004 0.00044703483581543
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
66 0.0005 0.00045585632324219
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
67 0.0001 0.00013494491577148
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
68 0.0005 0.00054693222045898
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
69 0.0005 0.0004570484161377
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
70 0.0004 0.00044989585876465
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
71 0.0001 0.00011992454528809
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
72 0.0007 0.00074386596679688
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
73 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '794' ORDER BY sortorder ASC
74 0.0002 0.00020599365234375
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '794' AND p.id = pi.product_id ORDER BY pi.sortorder
75 0.0002 0.00018715858459473
SELECT * FROM product_image_select WHERE product_id = '794'
76 0.0002 0.00015091896057129
SELECT * FROM productcustomimages WHERE product_id = '794'
77 0.0002 0.00017309188842773
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 = '794'
                GROUP BY o.product_id
78 0.0004 0.00042104721069336
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     = '794'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
79 0.0001 0.00013995170593262
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 794
80 0.0002 0.00022101402282715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '794' AND a.name = n.originalname
81 0.0001 0.00010299682617188
SELECT * FROM productoffers WHERE product_id = '794' AND merchantid = 'ATVPDKIKX0DER'
82 0.0001 0.00011086463928223
SELECT * FROM productoffers
                WHERE product_id = '794' AND price > 0
                ORDER BY price ASC LIMIT 1
83 0.0001 0.00011301040649414
SELECT * FROM productoffers
                WHERE product_id = 794
                ORDER BY price ASC LIMIT 1
84 0.0001 0.00011897087097168
SELECT value FROM productattributes
                WHERE product_id = '794'
                AND name = 'ListPriceAmount'
85 0.0002 0.0001518726348877
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 = '794'
                GROUP BY o.product_id
86 0.0002 0.00022506713867188
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     = '794'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
87 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 = 794
88 0.0001 0.00014090538024902
SELECT value FROM productattributes WHERE product_id = '794' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
89 0.0003 0.00032281875610352
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '794'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
90 0.0001 0.00012111663818359
SELECT * FROM productimages WHERE product_id = '799' ORDER BY sortorder ASC
91 0.0001 0.0001368522644043
SELECT * FROM product_image_select WHERE product_id = '799'
92 0.0001 0.00010204315185547
SELECT * FROM productcustomimages WHERE product_id = '799'
93 0.0007 0.00066804885864258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '799' AND a.name = n.originalname
94 0.0001 0.00010895729064941
SELECT * FROM productoffers WHERE product_id = '799' AND merchantid = 'ATVPDKIKX0DER'
95 0.0001 0.00013995170593262
SELECT * FROM productoffers
                WHERE product_id = '799' AND price > 0
                ORDER BY price ASC LIMIT 1
96 0.0001 0.0001370906829834
SELECT value FROM productattributes WHERE product_id = '799' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
97 0.0001 0.00011992454528809
SELECT * FROM productimages WHERE product_id = '811' ORDER BY sortorder ASC
98 0.0001 0.00014901161193848
SELECT * FROM product_image_select WHERE product_id = '811'
99 0.0001 9.8943710327148E-5
SELECT * FROM productcustomimages WHERE product_id = '811'
100 0.0004 0.00035500526428223
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '811' AND a.name = n.originalname
101 0.0001 0.0001070499420166
SELECT * FROM productoffers WHERE product_id = '811' AND merchantid = 'ATVPDKIKX0DER'
102 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '811' AND price > 0
                ORDER BY price ASC LIMIT 1
103 0.0001 0.00014019012451172
SELECT value FROM productattributes WHERE product_id = '811' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
104 0.0001 0.00010895729064941
SELECT * FROM productimages WHERE product_id = '814' ORDER BY sortorder ASC
105 0.0001 0.00013399124145508
SELECT * FROM product_image_select WHERE product_id = '814'
106 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '814'
107 0.0004 0.00043201446533203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '814' AND a.name = n.originalname
108 0.0001 0.00011086463928223
SELECT * FROM productoffers WHERE product_id = '814' AND merchantid = 'ATVPDKIKX0DER'
109 0.0001 0.00012087821960449
SELECT * FROM productoffers
                WHERE product_id = '814' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0001 0.00013613700866699
SELECT value FROM productattributes WHERE product_id = '814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0001 0.00011491775512695
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
112 0.0002 0.0001518726348877
SELECT * FROM product_image_select WHERE product_id = '822'
113 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '822'
114 0.0004 0.00035405158996582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
115 0.0001 0.00010204315185547
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'ATVPDKIKX0DER'
116 0.0001 0.00011801719665527
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
117 0.0001 0.00014805793762207
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0001 0.00011301040649414
SELECT * FROM productimages WHERE product_id = '824' ORDER BY sortorder ASC
119 0.0001 0.00013494491577148
SELECT * FROM product_image_select WHERE product_id = '824'
120 0.0001 9.6797943115234E-5
SELECT * FROM productcustomimages WHERE product_id = '824'
121 0.0004 0.00042200088500977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '824' AND a.name = n.originalname
122 0.0001 0.00011491775512695
SELECT * FROM productoffers WHERE product_id = '824' AND merchantid = 'ATVPDKIKX0DER'
123 0.0001 0.00011777877807617
SELECT * FROM productoffers
                WHERE product_id = '824' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0001 0.00014019012451172
SELECT value FROM productattributes WHERE product_id = '824' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0001 0.00012087821960449
SELECT * FROM productimages WHERE product_id = '827' ORDER BY sortorder ASC
126 0.0001 0.00013399124145508
SELECT * FROM product_image_select WHERE product_id = '827'
127 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '827'
128 0.0004 0.00035309791564941
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '827' AND a.name = n.originalname
129 0.0001 0.00010800361633301
SELECT * FROM productoffers WHERE product_id = '827' AND merchantid = 'ATVPDKIKX0DER'
130 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '827' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0001 0.00013995170593262
SELECT value FROM productattributes WHERE product_id = '827' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0001 0.0001070499420166
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
133 0.0001 0.00013589859008789
SELECT * FROM product_image_select WHERE product_id = '7011'
134 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
135 0.0005 0.00053906440734863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
136 0.0001 9.7036361694336E-5
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
137 0.0001 0.00010585784912109
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0001 0.00010490417480469
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
139 0.0001 0.00013184547424316
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
140 0.0001 9.0837478637695E-5
SELECT * FROM productimages WHERE product_id = '7008' ORDER BY sortorder ASC
141 0.0001 0.00013184547424316
SELECT * FROM product_image_select WHERE product_id = '7008'
142 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '7008'
143 0.0005 0.00045299530029297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7008' AND a.name = n.originalname
144 0.0001 0.00011587142944336
SELECT * FROM productoffers WHERE product_id = '7008' AND merchantid = 'ATVPDKIKX0DER'
145 0.0001 0.0001060962677002
SELECT * FROM productoffers
                WHERE product_id = '7008' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0001 9.7036361694336E-5
SELECT * FROM productoffers
                WHERE product_id = 7008
                ORDER BY price ASC LIMIT 1
147 0.0001 0.00010991096496582
SELECT value FROM productattributes
                WHERE product_id = '7008'
                AND name = 'ListPriceAmount'
148 0.0002 0.00016880035400391
SELECT value FROM productattributes WHERE product_id = '7008' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0006 0.00055599212646484
SELECT * FROM productimages WHERE product_id = '7007' ORDER BY sortorder ASC
150 0.0001 0.00013899803161621
SELECT * FROM product_image_select WHERE product_id = '7007'
151 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '7007'
152 0.0004 0.0003659725189209
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7007' AND a.name = n.originalname
153 0.0001 0.00010299682617188
SELECT * FROM productoffers WHERE product_id = '7007' AND merchantid = 'ATVPDKIKX0DER'
154 0.0001 0.00013089179992676
SELECT * FROM productoffers
                WHERE product_id = '7007' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0001 0.00013494491577148
SELECT value FROM productattributes WHERE product_id = '7007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0001 0.0001070499420166
SELECT * FROM productimages WHERE product_id = '7006' ORDER BY sortorder ASC
157 0.0002 0.0001678466796875
SELECT * FROM product_image_select WHERE product_id = '7006'
158 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '7006'
159 0.0005 0.00051093101501465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7006' AND a.name = n.originalname
160 0.0001 9.7990036010742E-5
SELECT * FROM productoffers WHERE product_id = '7006' AND merchantid = 'ATVPDKIKX0DER'
161 0.0001 0.00011491775512695
SELECT * FROM productoffers
                WHERE product_id = '7006' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0001 0.00011086463928223
SELECT * FROM productoffers
                WHERE product_id = 7006
                ORDER BY price ASC LIMIT 1
163 0.0001 0.00012898445129395
SELECT value FROM productattributes
                WHERE product_id = '7006'
                AND name = 'ListPriceAmount'
164 0.0001 0.00014805793762207
SELECT * FROM productimages WHERE product_id = '4252' ORDER BY sortorder ASC
165 0.0001 0.00014710426330566
SELECT * FROM product_image_select WHERE product_id = '4252'
166 0.0001 0.00010108947753906
SELECT * FROM productcustomimages WHERE product_id = '4252'
167 0.0003 0.00034499168395996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4252' AND a.name = n.originalname
168 0.0001 0.00010013580322266
SELECT * FROM productoffers WHERE product_id = '4252' AND merchantid = 'ATVPDKIKX0DER'
169 0.0001 0.0001060962677002
SELECT * FROM productoffers
                WHERE product_id = '4252' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0001 0.00010204315185547
SELECT * FROM productoffers
                WHERE product_id = 4252
                ORDER BY price ASC LIMIT 1
171 0.0001 0.00012516975402832
SELECT value FROM productattributes
                WHERE product_id = '4252'
                AND name = 'ListPriceAmount'
172 0.0001 0.00012803077697754
SELECT value FROM productattributes WHERE product_id = '4252' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0004 0.00037193298339844
SELECT * FROM productimages WHERE product_id = '7005' ORDER BY sortorder ASC
174 0.0001 0.0001380443572998
SELECT * FROM product_image_select WHERE product_id = '7005'
175 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7005'
176 0.0005 0.00053501129150391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7005' AND a.name = n.originalname
177 0.0001 0.00012588500976562
SELECT * FROM productoffers WHERE product_id = '7005' AND merchantid = 'ATVPDKIKX0DER'
178 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = '7005' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0001 0.00014400482177734
SELECT value FROM productattributes WHERE product_id = '7005' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0001 0.0001370906829834
SELECT * FROM productimages WHERE product_id = '6750' ORDER BY sortorder ASC
181 0.0001 0.0001378059387207
SELECT * FROM product_image_select WHERE product_id = '6750'
182 0.0001 9.6797943115234E-5
SELECT * FROM productcustomimages WHERE product_id = '6750'
183 0.0003 0.00034713745117188
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6750' AND a.name = n.originalname
184 0.0001 9.918212890625E-5
SELECT * FROM productoffers WHERE product_id = '6750' AND merchantid = 'ATVPDKIKX0DER'
185 0.0001 0.0001060962677002
SELECT * FROM productoffers
                WHERE product_id = '6750' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0001 0.00011301040649414
SELECT * FROM productoffers
                WHERE product_id = 6750
                ORDER BY price ASC LIMIT 1
187 0.0001 0.00011301040649414
SELECT value FROM productattributes
                WHERE product_id = '6750'
                AND name = 'ListPriceAmount'
188 0.0001 0.00013089179992676
SELECT value FROM productattributes WHERE product_id = '6750' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0001 0.00011491775512695
SELECT * FROM productimages WHERE product_id = '6996' ORDER BY sortorder ASC
190 0.0001 0.00014305114746094
SELECT * FROM product_image_select WHERE product_id = '6996'
191 0.0001 9.608268737793E-5
SELECT * FROM productcustomimages WHERE product_id = '6996'
192 0.0005 0.00046610832214355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6996' AND a.name = n.originalname
193 0.0001 9.7036361694336E-5
SELECT * FROM productoffers WHERE product_id = '6996' AND merchantid = 'ATVPDKIKX0DER'
194 0.0001 0.0001060962677002
SELECT * FROM productoffers
                WHERE product_id = '6996' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0001 0.00010895729064941
SELECT * FROM productoffers
                WHERE product_id = 6996
                ORDER BY price ASC LIMIT 1
196 0.0001 0.00011491775512695
SELECT value FROM productattributes
                WHERE product_id = '6996'
                AND name = 'ListPriceAmount'
197 0.0001 0.00011491775512695
SELECT * FROM productimages WHERE product_id = '6997' ORDER BY sortorder ASC
198 0.0001 0.00013494491577148
SELECT * FROM product_image_select WHERE product_id = '6997'
199 0.0001 0.00010895729064941
SELECT * FROM productcustomimages WHERE product_id = '6997'
200 0.0006 0.00058889389038086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6997' AND a.name = n.originalname
201 0.0001 9.7990036010742E-5
SELECT * FROM productoffers WHERE product_id = '6997' AND merchantid = 'ATVPDKIKX0DER'
202 0.0001 0.00010585784912109
SELECT * FROM productoffers
                WHERE product_id = '6997' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0001 0.00010919570922852
SELECT * FROM productoffers
                WHERE product_id = 6997
                ORDER BY price ASC LIMIT 1
204 0.0001 0.00011897087097168
SELECT value FROM productattributes
                WHERE product_id = '6997'
                AND name = 'ListPriceAmount'
205 0.0001 0.00011587142944336
SELECT * FROM productimages WHERE product_id = '6998' ORDER BY sortorder ASC
206 0.0001 0.00014495849609375
SELECT * FROM product_image_select WHERE product_id = '6998'
207 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '6998'
208 0.0005 0.00049686431884766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6998' AND a.name = n.originalname
209 0.0001 9.7990036010742E-5
SELECT * FROM productoffers WHERE product_id = '6998' AND merchantid = 'ATVPDKIKX0DER'
210 0.0001 0.0001070499420166
SELECT * FROM productoffers
                WHERE product_id = '6998' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0001 0.00010991096496582
SELECT * FROM productoffers
                WHERE product_id = 6998
                ORDER BY price ASC LIMIT 1
212 0.0001 0.00011110305786133
SELECT value FROM productattributes
                WHERE product_id = '6998'
                AND name = 'ListPriceAmount'
213 0.0001 0.00011301040649414
SELECT * FROM productimages WHERE product_id = '6999' ORDER BY sortorder ASC
214 0.0001 0.00013613700866699
SELECT * FROM product_image_select WHERE product_id = '6999'
215 0.0001 0.00011086463928223
SELECT * FROM productcustomimages WHERE product_id = '6999'
216 0.0004 0.00036287307739258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '6999' AND a.name = n.originalname
217 0.0001 0.00010490417480469
SELECT * FROM productoffers WHERE product_id = '6999' AND merchantid = 'ATVPDKIKX0DER'
218 0.0001 0.00011992454528809
SELECT * FROM productoffers
                WHERE product_id = '6999' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0001 0.00013494491577148
SELECT value FROM productattributes WHERE product_id = '6999' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0002 0.00017094612121582
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
221 0.0001 0.00013494491577148
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
222 0.0001 8.0108642578125E-5
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
223 0.0001 0.00010490417480469
SELECT * FROM pages WHERE id = 38
224 0.0001 0.00011110305786133
SELECT * FROM categories WHERE id = '27'
225 0.0002 0.00020694732666016
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
226 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
227 0.0001 8.0108642578125E-5
SELECT id FROM categories WHERE parent_id = '27'
228 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 
229 0.0001 8.8930130004883E-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 
230 0.0001 9.8943710327148E-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
231 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
232 0.0002 0.00018596649169922
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
233 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
234 0.0002 0.00019311904907227
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 
235 0.0001 9.2983245849609E-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 
236 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
237 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
238 0.0001 7.8916549682617E-5
SELECT id FROM categories WHERE parent_id = '27'
239 0.0002 0.00022506713867188
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
240 0.0001 0.00011992454528809
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
241 0.0001 0.00011992454528809
SELECT * FROM categoryimages WHERE category_id = 27
242 0.0001 8.6069107055664E-5
SELECT * FROM categorygroups WHERE id = '1'
243 0.0002 0.00020790100097656
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
244 0.0001 9.2029571533203E-5
SELECT * FROM categories WHERE id = '30'
245 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
246 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
247 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '30'
248 0.0003 0.0003058910369873
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 
249 0.0001 8.8930130004883E-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 
250 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
251 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
252 0.0003 0.00027704238891602
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
253 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
254 0.0003 0.00027990341186523
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 
255 0.0001 9.2983245849609E-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 
256 0.0001 9.5844268798828E-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
257 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
258 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '30'
259 0.0003 0.00031900405883789
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
260 0.0001 0.00012612342834473
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
261 0.0001 7.9870223999023E-5
SELECT * FROM categoryimages WHERE category_id = 30
262 0.0001 8.0108642578125E-5
SELECT * FROM categorygroups WHERE id = '1'
263 0.0003 0.0003049373626709
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
264 0.0001 9.4175338745117E-5
SELECT * FROM pages WHERE id = 59
265 0.0001 0.00011515617370605
SELECT * FROM pages WHERE id = 55
266 0.0001 0.00014996528625488
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
267 0.0001 0.00012707710266113
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:1642886448;s:8:\"products\";a:0:{}}' WHERE id = '8'
268 0.0002 0.00022101402282715
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
269 0.0001 0.00010490417480469
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:1642886448;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'
270 0.0001 0.00012493133544922
SELECT * FROM products WHERE id = 7004
271 0.0001 0.00012993812561035
SELECT * FROM products WHERE id = 7011
272 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = 7045
273 0.0001 0.00013184547424316
SELECT * FROM products WHERE id = '7004'
274 0.0001 0.00012707710266113
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
275 0.0001 0.00014805793762207
SELECT * FROM product_image_select WHERE product_id = '7004'
276 0.0001 9.9897384643555E-5
SELECT * FROM productcustomimages WHERE product_id = '7004'
277 0.0005 0.00049304962158203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
278 0.0001 0.00010895729064941
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
279 0.0001 0.00013303756713867
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0001 0.00014400482177734
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
281 0.0001 0.00011897087097168
SELECT * FROM products WHERE id = '7011'
282 0.0001 0.00014710426330566
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
283 0.0001 0.0001380443572998
SELECT * FROM product_image_select WHERE product_id = '7011'
284 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '7011'
285 0.0005 0.00054597854614258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
286 0.0001 0.00011515617370605
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
287 0.0001 0.00010800361633301
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
288 0.0001 0.00010108947753906
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
289 0.0001 0.00012016296386719
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
290 0.0001 0.00012397766113281
SELECT * FROM products WHERE id = '7045'
291 0.0001 0.00010108947753906
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
292 0.0001 0.00014209747314453
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
293 0.0001 0.00014400482177734
SELECT * FROM product_image_select WHERE product_id = '7045'
294 0.0001 0.00011110305786133
SELECT * FROM productcustomimages WHERE product_id = '7045'
295 0.0001 0.0001370906829834
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
296 0.0002 0.00018000602722168
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
297 0.0001 0.00012588500976562
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
298 0.0005 0.00053715705871582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
299 0.0001 9.8228454589844E-5
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
300 0.0001 0.0001060962677002
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
301 0.0001 9.9897384643555E-5
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
302 0.0001 0.00012493133544922
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
303 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
304 0.0002 0.00017499923706055
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
305 0.0001 0.00013494491577148
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
306 0.0001 0.00014305114746094
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
307 0.0002 0.00015711784362793
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
308 0.0002 0.00016617774963379
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
309 0.0002 0.00024986267089844
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
310 0.0002 0.00019502639770508
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
311 0.0004 0.0003960132598877
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
312 0.0002 0.00020408630371094
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
313 0.0002 0.00015783309936523
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
314 0.0003 0.00026297569274902
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
315 0.0002 0.00019407272338867
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
316 0.0002 0.00015902519226074
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'