Patrulla Canina

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.60818290710449 508 0.2307 0


No Amazon API Requests Made.


App Debug - Total Time 0.60818290710449 seconds

Number Time From Start Name Description
1 0.35033893585205 Initialise Initialise FSB Function
2 0.35201907157898 App Controller Start Start of the App controller (called before the controller of every page)
3 0.35502886772156 App Controller End End of the App controller (called before the controller of every page)
4 0.35507488250732 Category Start Start of the category controller
5 0.35507798194885 Before Get Category Before getting the category information
6 0.37465500831604 After Get Category After getting the category information
7 0.37465596199036 Before Get Category List Before getting the updated category list
8 0.37476491928101 Start of getCategoryListByGroup Function Before first category groups query
9 0.37486004829407 After initial query Before first category groups query
10 0.37486100196838 Get Category List for Group Before the call to getCategoryList function
11 0.37486386299133 Start of GetCategoryList function Start of the function
12 0.37486600875854 Before getting categories Query to get specific category list
13 0.37500190734863 After getting categories Query to get specific category list
14 0.37500286102295 Before getting category custom Before call to function getCategoryCustom
15 0.37561702728271 After getting category custom After call to function getCategoryCustom
16 0.37561893463135 Before getting category custom Before call to function getCategoryCustom
17 0.37630105018616 After getting category custom After call to function getCategoryCustom
18 0.37630295753479 Before getting category custom Before call to function getCategoryCustom
19 0.37682485580444 After getting category custom After call to function getCategoryCustom
20 0.37682604789734 Before getting category custom Before call to function getCategoryCustom
21 0.37732195854187 After getting category custom After call to function getCategoryCustom
22 0.37732291221619 Before getting category custom Before call to function getCategoryCustom
23 0.37781095504761 After getting category custom After call to function getCategoryCustom
24 0.37781190872192 Before getting category custom Before call to function getCategoryCustom
25 0.37830090522766 After getting category custom After call to function getCategoryCustom
26 0.37830185890198 Before getting category custom Before call to function getCategoryCustom
27 0.37881398200989 After getting category custom After call to function getCategoryCustom
28 0.3788149356842 Before getting category custom Before call to function getCategoryCustom
29 0.37943291664124 After getting category custom After call to function getCategoryCustom
30 0.37943506240845 Before getting category custom Before call to function getCategoryCustom
31 0.38008189201355 After getting category custom After call to function getCategoryCustom
32 0.38008308410645 Before getting sub category list Before call to recursive function getCategoryList
33 0.38008403778076 Start of GetCategoryList function Start of the function
34 0.38008594512939 Before getting categories Query to get specific category list
35 0.38018989562988 After getting sub category list After call to recursive function getCategoryList
36 0.3801908493042 End of GetCategoryList function End of the function
37 0.38019585609436 Get Category List for Group Before the call to getCategoryList function
38 0.38019800186157 Start of GetCategoryList function Start of the function
39 0.38019895553589 Before getting categories Query to get specific category list
40 0.38033008575439 After getting categories Query to get specific category list
41 0.38033103942871 Before getting category custom Before call to function getCategoryCustom
42 0.38184499740601 After getting category custom After call to function getCategoryCustom
43 0.38184690475464 Before getting category custom Before call to function getCategoryCustom
44 0.38248085975647 After getting category custom After call to function getCategoryCustom
45 0.38248300552368 Before getting category custom Before call to function getCategoryCustom
46 0.38308000564575 After getting category custom After call to function getCategoryCustom
47 0.38308191299438 Before getting category custom Before call to function getCategoryCustom
48 0.38363790512085 After getting category custom After call to function getCategoryCustom
49 0.38363885879517 Before getting category custom Before call to function getCategoryCustom
50 0.38452196121216 After getting category custom After call to function getCategoryCustom
51 0.38452291488647 Before getting category custom Before call to function getCategoryCustom
52 0.38510799407959 After getting category custom After call to function getCategoryCustom
53 0.38510894775391 Before getting category custom Before call to function getCategoryCustom
54 0.38566899299622 After getting category custom After call to function getCategoryCustom
55 0.38566994667053 Before getting category custom Before call to function getCategoryCustom
56 0.3862190246582 After getting category custom After call to function getCategoryCustom
57 0.38622093200684 Before getting category custom Before call to function getCategoryCustom
58 0.38682699203491 After getting category custom After call to function getCategoryCustom
59 0.38682889938354 Before getting category custom Before call to function getCategoryCustom
60 0.38745594024658 After getting category custom After call to function getCategoryCustom
61 0.38745808601379 Before getting category custom Before call to function getCategoryCustom
62 0.38805198669434 After getting category custom After call to function getCategoryCustom
63 0.38805389404297 Before getting category custom Before call to function getCategoryCustom
64 0.38862895965576 After getting category custom After call to function getCategoryCustom
65 0.38863086700439 Before getting category custom Before call to function getCategoryCustom
66 0.38931107521057 After getting category custom After call to function getCategoryCustom
67 0.38931202888489 End of GetCategoryList function End of the function
68 0.38931798934937 End of getCategoryListByGroup Function Before return()
69 0.389319896698 After Get Category List After getting the updated category list
70 0.389319896698 Before Category Images Before getting the category images
71 0.38940906524658 After Category Images After getting the category images
72 0.38965487480164 Before Sub Category Check Before checking for sub category or products category
73 0.38974404335022 Before Category Products Controller Before loading the category products controller
74 0.38981008529663 Start Category Products Start of Category Products Controller
75 0.38982892036438 After Pagination Options After pagination options in Category Products Controller
76 0.39004302024841 After Cache After Cache checking in Category Products Controller
77 0.42193388938904 After Filter Options After getting filter options and SQL in Category Products Controller
78 0.43220400810242 After Counting Products After counting products in the Category Products Controller
79 0.43234801292419 After Counting Bundles After counting bundles in the Category Products Controller
80 0.4324848651886 After Counting Products After counting products in the Category Products Controller
81 0.4439070224762 After Getting Products After getting products and bundles in the Category Products Controller
82 0.44398808479309 After Pagination Links After getting pagination listing links in the Category Products Controller
83 0.44398903846741 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
84 0.57549285888672 After Getting Product Details After getting full product details in the Category Products Controller
85 0.58251595497131 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
86 0.58350086212158 App_after Controller Start Start of the App_after controller (called after the controller of every page)
87 0.58361196517944 Before Get Options Before the call to getOptions in the tpl class
88 0.59138607978821 After Get Options After the call to getOptions in the tpl class
89 0.59171199798584 App_after Controller End End of the App_after controller (called after the controller of every page)
90 0.59172296524048 Before Smarty Before passing everything over to Smarty in the Category Products Controller
91 0.6081690788269 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
92 0.60817098617554 Finalizing debug Before the debug is output to the page.
93 0.60818290710449 End of App This is the end of the app logging, final timestamp


Query Debug - 508 Database Queries. Total time 0.2307 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0001 0.00011301040649414
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00049901008605957
SHOW TABLES LIKE 'bad_bots'
3 0.0001 8.702278137207E-5
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 9.1075897216797E-5
SELECT * FROM `bad_bots`
5 0.0001 0.00014591217041016
SELECT parameter, value FROM parameters
6 0.0002 0.00016999244689941
SET time_zone = 'Europe/London'
7 0.0001 0.00011420249938965
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 8.9883804321289E-5
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.0001070499420166
SELECT id FROM pages WHERE pagename = 'patrulla-canina' LIMIT 1
10 0.0004 0.00041604042053223
SELECT id FROM products WHERE pagename = 'patrulla-canina' AND hidden = 0 LIMIT 1
11 0.0009 0.00086617469787598
SELECT id FROM ebay_products WHERE pagename = 'patrulla-canina'
12 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE pagename = 'patrulla-canina' LIMIT 1
13 0.0014 0.0013890266418457
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
14 0.0002 0.0001988410949707
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'es'
15 0.0001 8.2969665527344E-5
SELECT * FROM pages WHERE pagename = 'patrulla-canina'
16 0.0001 8.1062316894531E-5
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
17 0.0001 6.4849853515625E-5
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
18 0.0001 6.2942504882812E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
19 0.0001 8.702278137207E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
20 0.0001 6.103515625E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
21 0.0001 9.0837478637695E-5
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
22 0.0001 9.2983245849609E-5
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
23 0.0001 7.0810317993164E-5
SELECT * FROM categories WHERE pagename = 'patrulla-canina'
24 0.0001 6.2227249145508E-5
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 = 69
25 0.0001 5.793571472168E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 69
26 0.0001 5.6982040405273E-5
SELECT id FROM categories WHERE parent_id = '69'
27 0.0001 5.793571472168E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
28 0.0001 6.103515625E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 
29 0.0001 8.7976455688477E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (69)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
30 0.0001 5.9127807617188E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
31 0.0001 5.6982040405273E-5
SELECT id FROM categories WHERE parent_id = '69'
32 0.0094 0.0094270706176758
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (69) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
33 0.0001 9.2983245849609E-5
SELECT * FROM productimages WHERE product_id = '22294' ORDER BY sortorder ASC
34 0.0001 7.7009201049805E-5
SELECT * FROM categoryimages WHERE category_id = 69
35 0.0001 6.6995620727539E-5
SELECT * FROM categorygroups WHERE id = '2'
36 0.0083 0.0082530975341797
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 = '69'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
37 0.0009 0.00088310241699219
SELECT parent_id FROM categories WHERE id = '69'
38 0.0001 9.4890594482422E-5
SELECT parent_id FROM categories WHERE id = '69'
39 0.0001 8.3208084106445E-5
SELECT * FROM categorygroups ORDER BY sortorder ASC
40 0.0001 0.00010299682617188
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
41 0.0001 7.8916549682617E-5
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 = 70
42 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '70'
43 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (70)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
44 0.0001 6.5803527832031E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (70)
				  AND p.disabled = 0 
45 0.0001 6.2942504882812E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (70)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
46 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
47 0.0001 0.0001070499420166
SELECT * FROM categorygroups WHERE id = '2'
48 0.0001 6.9856643676758E-5
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 = 66
49 0.0001 6.5088272094727E-5
SELECT id FROM categories WHERE parent_id = '66'
50 0.0001 0.00011706352233887
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (66)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
51 0.0001 0.00010514259338379
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (66)
				  AND p.disabled = 0 
52 0.0001 7.6055526733398E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
53 0.0001 0.00010108947753906
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
54 0.0001 6.9141387939453E-5
SELECT * FROM categorygroups WHERE id = '2'
55 0.0001 6.3180923461914E-5
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 = 67
56 0.0001 6.1988830566406E-5
SELECT id FROM categories WHERE parent_id = '67'
57 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (67)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0001 8.2015991210938E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (67)
				  AND p.disabled = 0 
59 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (67)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
60 0.0001 6.103515625E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
61 0.0001 6.1988830566406E-5
SELECT * FROM categorygroups WHERE id = '2'
62 0.0001 6.1988830566406E-5
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 = 56
63 0.0001 6.103515625E-5
SELECT id FROM categories WHERE parent_id = '56'
64 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (56)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
65 0.0001 6.3180923461914E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (56)
				  AND p.disabled = 0 
66 0.0001 6.2942504882812E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (56)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
67 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '56'
68 0.0001 6.1988830566406E-5
SELECT * FROM categorygroups WHERE id = '2'
69 0.0001 6.103515625E-5
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 = 59
70 0.0001 6.103515625E-5
SELECT id FROM categories WHERE parent_id = '59'
71 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (59)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
72 0.0001 6.5088272094727E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (59)
				  AND p.disabled = 0 
73 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (59)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
74 0.0001 6.103515625E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '59'
75 0.0001 6.1988830566406E-5
SELECT * FROM categorygroups WHERE id = '2'
76 0.0001 6.1988830566406E-5
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 = 61
77 0.0001 6.103515625E-5
SELECT id FROM categories WHERE parent_id = '61'
78 0.0001 6.103515625E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (61)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
79 0.0001 6.3180923461914E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
80 0.0001 6.1988830566406E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
81 0.0001 6.103515625E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
82 0.0001 6.413459777832E-5
SELECT * FROM categorygroups WHERE id = '2'
83 0.0001 6.1988830566406E-5
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 = 62
84 0.0001 6.103515625E-5
SELECT id FROM categories WHERE parent_id = '62'
85 0.0001 6.2227249145508E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (62)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
86 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (62)
				  AND p.disabled = 0 
87 0.0001 6.2942504882812E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (62)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
88 0.0001 6.6995620727539E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '62'
89 0.0001 6.8902969360352E-5
SELECT * FROM categorygroups WHERE id = '2'
90 0.0001 6.9141387939453E-5
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 = 68
91 0.0001 6.9856643676758E-5
SELECT id FROM categories WHERE parent_id = '68'
92 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (68)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
93 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 (68)
				  AND p.disabled = 0 
94 0.0001 8.1062316894531E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (68)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
95 0.0001 7.9154968261719E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
96 0.0001 7.8916549682617E-5
SELECT * FROM categorygroups WHERE id = '2'
97 0.0001 8.1062316894531E-5
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 = 69
98 0.0001 8.9168548583984E-5
SELECT id FROM categories WHERE parent_id = '69'
99 0.0001 7.5101852416992E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
100 0.0001 7.5101852416992E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 
101 0.0001 8.5115432739258E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (69)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
102 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
103 0.0001 7.4863433837891E-5
SELECT * FROM categorygroups WHERE id = '2'
104 0.0001 9.4175338745117E-5
SELECT * FROM categories WHERE parent_id = '69'  AND hidden = 0 ORDER BY sortorder ASC
105 0.0001 9.608268737793E-5
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
106 0.0001 7.8916549682617E-5
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
107 0.0001 7.9154968261719E-5
SELECT id FROM categories WHERE parent_id = '29'
108 0.0001 8.9883804321289E-5
SELECT id FROM categories WHERE parent_id = '30'
109 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '31'
110 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '32'
111 0.0001 7.6055526733398E-5
SELECT id FROM categories WHERE parent_id = '33'
112 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '34'
113 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '35'
114 0.0001 8.6069107055664E-5
SELECT id FROM categories WHERE parent_id = '39'
115 0.0001 6.8902969360352E-5
SELECT id FROM categories WHERE parent_id = '41'
116 0.0001 8.1062316894531E-5
SELECT id FROM categories WHERE parent_id = '36'
117 0.0001 7.8916549682617E-5
SELECT id FROM categories WHERE parent_id = '37'
118 0.0001 7.9154968261719E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30,31,32,33,34,35,39,41,36,37,29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
119 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,31,32,33,34,35,39,41,36,37,29)
				  AND p.disabled = 0 
120 0.0001 8.0108642578125E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30,31,32,33,34,35,39,41,36,37,29)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
121 0.0001 7.8916549682617E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
122 0.0001 7.9154968261719E-5
SELECT * FROM categorygroups WHERE id = '1'
123 0.0001 7.8916549682617E-5
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 = 52
124 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '52'
125 0.0001 7.8916549682617E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (52)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
126 0.0001 8.082389831543E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (52)
				  AND p.disabled = 0 
127 0.0001 7.7009201049805E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (52)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
128 0.0001 7.6055526733398E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '52'
129 0.0001 7.6055526733398E-5
SELECT * FROM categorygroups WHERE id = '1'
130 0.0001 8.1062316894531E-5
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 = 51
131 0.0001 7.5817108154297E-5
SELECT id FROM categories WHERE parent_id = '51'
132 0.0001 8.5115432739258E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
133 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (51)
				  AND p.disabled = 0 
134 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
135 0.0001 6.9141387939453E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
136 0.0001 6.9141387939453E-5
SELECT * FROM categorygroups WHERE id = '1'
137 0.0001 6.8902969360352E-5
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 = 28
138 0.0001 6.7949295043945E-5
SELECT id FROM categories WHERE parent_id = '28'
139 0.0001 6.9856643676758E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
140 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
141 0.0001 6.6995620727539E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
142 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
143 0.0001 7.5817108154297E-5
SELECT * FROM categorygroups WHERE id = '1'
144 0.0001 6.9856643676758E-5
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 = 43
145 0.0001 7.1048736572266E-5
SELECT id FROM categories WHERE parent_id = '43'
146 0.0001 8.0108642578125E-5
SELECT id FROM categories WHERE parent_id = '44'
147 0.0001 7.0095062255859E-5
SELECT id FROM categories WHERE parent_id = '45'
148 0.0001 6.9141387939453E-5
SELECT id FROM categories WHERE parent_id = '46'
149 0.0001 7.0095062255859E-5
SELECT id FROM categories WHERE parent_id = '47'
150 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (44,45,46,47,43)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
151 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (44,45,46,47,43)
				  AND p.disabled = 0 
152 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (44,45,46,47,43)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
153 0.0001 5.3882598876953E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '43'
154 0.0001 6.2942504882812E-5
SELECT * FROM categorygroups WHERE id = '1'
155 0.0001 7.8201293945312E-5
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 = 50
156 0.0001 7.2956085205078E-5
SELECT id FROM categories WHERE parent_id = '50'
157 0.0001 7.3909759521484E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (50)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
158 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (50)
				  AND p.disabled = 0 
159 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
160 0.0001 7.1048736572266E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
161 0.0001 7.2002410888672E-5
SELECT * FROM categorygroups WHERE id = '1'
162 0.0001 7.0095062255859E-5
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 = 54
163 0.0001 6.6995620727539E-5
SELECT id FROM categories WHERE parent_id = '54'
164 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (54)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
165 0.0001 6.9856643676758E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (54)
				  AND p.disabled = 0 
166 0.0001 7.0095062255859E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (54)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
167 0.0001 7.6055526733398E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '54'
168 0.0001 7.0095062255859E-5
SELECT * FROM categorygroups WHERE id = '1'
169 0.0001 6.9141387939453E-5
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 = 26
170 0.0001 6.7949295043945E-5
SELECT id FROM categories WHERE parent_id = '26'
171 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
172 0.0001 6.8902969360352E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
173 0.0001 6.7949295043945E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
174 0.0001 6.6995620727539E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
175 0.0001 7.1048736572266E-5
SELECT * FROM categorygroups WHERE id = '1'
176 0.0001 8.0108642578125E-5
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
177 0.0001 7.1048736572266E-5
SELECT id FROM categories WHERE parent_id = '38'
178 0.0001 7.1048736572266E-5
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 
179 0.0001 7.3909759521484E-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 
180 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (38)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
181 0.0001 8.4877014160156E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
182 0.0001 7.9154968261719E-5
SELECT * FROM categorygroups WHERE id = '1'
183 0.0001 7.2956085205078E-5
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 = 48
184 0.0001 8.2969665527344E-5
SELECT id FROM categories WHERE parent_id = '48'
185 0.0001 7.7962875366211E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (48)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
186 0.0001 8.1062316894531E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (48)
				  AND p.disabled = 0 
187 0.0001 7.8201293945312E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (48)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
188 0.0001 7.4863433837891E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '48'
189 0.0001 7.6055526733398E-5
SELECT * FROM categorygroups WHERE id = '1'
190 0.0001 7.6055526733398E-5
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 = 49
191 0.0001 7.5817108154297E-5
SELECT id FROM categories WHERE parent_id = '49'
192 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
193 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
194 0.0001 8.2015991210938E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
195 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
196 0.0001 7.2956085205078E-5
SELECT * FROM categorygroups WHERE id = '1'
197 0.0001 7.2956085205078E-5
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 = 55
198 0.0001 7.2002410888672E-5
SELECT id FROM categories WHERE parent_id = '55'
199 0.0001 7.319450378418E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (55)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
200 0.0001 7.2956085205078E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (55)
				  AND p.disabled = 0 
201 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (55)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
202 0.0001 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '55'
203 0.0001 7.3909759521484E-5
SELECT * FROM categorygroups WHERE id = '1'
204 0.0001 7.8916549682617E-5
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.2956085205078E-5
SELECT id FROM categories WHERE parent_id = '27'
206 0.0001 7.2956085205078E-5
SELECT id FROM categories WHERE parent_id = '65'
207 0.0001 7.4148178100586E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65,27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
208 0.0001 7.3909759521484E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65,27)
				  AND p.disabled = 0 
209 0.0001 7.5101852416992E-5
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65,27)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
210 0.0001 7.3909759521484E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
211 0.0001 7.5101852416992E-5
SELECT * FROM categorygroups WHERE id = '1'
212 0.0001 8.0108642578125E-5
SELECT * FROM categoryimages WHERE category_id = 69
213 0.0001 8.702278137207E-5
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
214 0.0001 7.7009201049805E-5
SELECT * FROM categories WHERE parent_id = '69'
215 0.0305 0.03051495552063
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
216 0.0008 0.00082802772521973
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
217 0.0001 8.702278137207E-5
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
218 0.0001 9.0837478637695E-5
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
219 0.0093 0.0093109607696533
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 69
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
220 0.0009 0.00091791152954102
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 69
		AND c.prod_type = 'ebay'
		AND hide = 1
221 0.0001 0.00012588500976562
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 69
			AND p.disabled = 0
			
			AND 1 = 1
222 0.0001 0.00012302398681641
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 69
		AND c.prod_type = 'custom'
		AND hide = 1
223 0.0114 0.01136302947998
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 69
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 69
		AND c.prod_type = 'ebay'
		AND p.hide = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 69
		AND c.prod_type = 'custom'
		AND p.hide = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 69
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 54, 18
224 0.0003 0.00029587745666504
SELECT * FROM products WHERE id = '29367'
225 0.0001 0.00011014938354492
SELECT * FROM productimages WHERE product_id = '29367' ORDER BY sortorder ASC
226 0.0001 0.00010895729064941
SELECT * FROM product_image_select WHERE product_id = '29367'
227 0.0001 0.00011205673217773
SELECT * FROM productcustomimages WHERE product_id = '29367'
228 0.0017 0.0017218589782715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '29367' AND a.name = n.originalname
229 0.0006 0.00064897537231445
SELECT * FROM productoffers WHERE product_id = '29367' AND merchantid = ''
230 0.0002 0.00017809867858887
SELECT * FROM productoffers
                WHERE product_id = '29367' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0003 0.00029110908508301
SELECT * FROM productoffers
                WHERE product_id = 29367
                ORDER BY price ASC LIMIT 1
232 0.0003 0.00029110908508301
SELECT value FROM productattributes
                WHERE product_id = '29367'
                AND name = 'ListPriceAmount'
233 0.0001 0.00013399124145508
UPDATE products SET price = '1909' WHERE id = '29367'
234 0.0002 0.00016498565673828
SELECT * FROM products WHERE id = '27730'
235 0.0001 7.3909759521484E-5
SELECT * FROM productimages WHERE product_id = '27730' ORDER BY sortorder ASC
236 0.0010 0.00099301338195801
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '27730' AND p.id = pi.product_id ORDER BY pi.sortorder
237 0.0001 9.2029571533203E-5
SELECT * FROM product_image_select WHERE product_id = '27730'
238 0.0001 7.2956085205078E-5
SELECT * FROM productcustomimages WHERE product_id = '27730'
239 0.0006 0.00062203407287598
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 = '27730'
                GROUP BY o.product_id
240 0.0102 0.010178089141846
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     = '27730'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
241 0.0019 0.0019009113311768
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 27730
242 0.0001 9.8943710327148E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '27730' AND a.name = n.originalname
243 0.0010 0.00095295906066895
SELECT * FROM productoffers WHERE product_id = '27730' AND merchantid = ''
244 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = '27730' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0002 0.00018405914306641
SELECT * FROM productoffers
                WHERE product_id = 27730
                ORDER BY price ASC LIMIT 1
246 0.0004 0.00037598609924316
SELECT value FROM productattributes
                WHERE product_id = '27730'
                AND name = 'ListPriceAmount'
247 0.0001 0.0001220703125
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 = '27730'
                GROUP BY o.product_id
248 0.0001 7.7962875366211E-5
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     = '27730'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
249 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 = 27730
250 0.0003 0.00034904479980469
SELECT value FROM productattributes WHERE product_id = '27730' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0012 0.001176118850708
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '27730'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
252 0.0018 0.001798152923584
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '27730'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
253 0.0005 0.0005340576171875
SELECT * FROM products WHERE id = '22086'
254 0.0001 0.00011110305786133
SELECT * FROM productimages WHERE product_id = '22086' ORDER BY sortorder ASC
255 0.0001 0.0001070499420166
SELECT * FROM product_image_select WHERE product_id = '22086'
256 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '22086'
257 0.0018 0.0018329620361328
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '22086' AND a.name = n.originalname
258 0.0002 0.00017380714416504
SELECT * FROM productoffers WHERE product_id = '22086' AND merchantid = ''
259 0.0008 0.00081992149353027
SELECT * FROM productoffers
                WHERE product_id = '22086' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0006 0.0005948543548584
SELECT * FROM productoffers
                WHERE product_id = 22086
                ORDER BY price ASC LIMIT 1
261 0.0003 0.00027704238891602
SELECT value FROM productattributes
                WHERE product_id = '22086'
                AND name = 'ListPriceAmount'
262 0.0003 0.00027704238891602
SELECT value FROM productattributes WHERE product_id = '22086' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263 0.0002 0.00023508071899414
SELECT * FROM products WHERE id = '10859'
264 0.0001 6.6995620727539E-5
SELECT * FROM productimages WHERE product_id = '10859' ORDER BY sortorder ASC
265 0.0001 8.1062316894531E-5
SELECT * FROM product_image_select WHERE product_id = '10859'
266 0.0001 9.608268737793E-5
SELECT * FROM productcustomimages WHERE product_id = '10859'
267 0.0011 0.0010941028594971
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '10859' AND a.name = n.originalname
268 0.0002 0.00024509429931641
SELECT * FROM productoffers WHERE product_id = '10859' AND merchantid = ''
269 0.0020 0.0019819736480713
SELECT * FROM productoffers
                WHERE product_id = '10859' AND price > 0
                ORDER BY price ASC LIMIT 1
270 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = 10859
                ORDER BY price ASC LIMIT 1
271 0.0012 0.0012199878692627
SELECT value FROM productattributes
                WHERE product_id = '10859'
                AND name = 'ListPriceAmount'
272 0.0002 0.00016593933105469
UPDATE products SET price = '2760' WHERE id = '10859'
273 0.0004 0.00036501884460449
SELECT * FROM products WHERE id = '22691'
274 0.0001 7.5101852416992E-5
SELECT * FROM productimages WHERE product_id = '22691' ORDER BY sortorder ASC
275 0.0001 8.9883804321289E-5
SELECT * FROM product_image_select WHERE product_id = '22691'
276 0.0001 7.7962875366211E-5
SELECT * FROM productcustomimages WHERE product_id = '22691'
277 0.0031 0.0031261444091797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '22691' AND a.name = n.originalname
278 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '22691' AND merchantid = ''
279 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = '22691' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = 22691
                ORDER BY price ASC LIMIT 1
281 0.0012 0.0011649131774902
SELECT value FROM productattributes
                WHERE product_id = '22691'
                AND name = 'ListPriceAmount'
282 0.0006 0.00058603286743164
UPDATE products SET price = '1099' WHERE id = '22691'
283 0.0005 0.0004880428314209
SELECT * FROM products WHERE id = '26597'
284 0.0001 8.4877014160156E-5
SELECT * FROM productimages WHERE product_id = '26597' ORDER BY sortorder ASC
285 0.0001 8.5830688476562E-5
SELECT * FROM product_image_select WHERE product_id = '26597'
286 0.0001 9.1075897216797E-5
SELECT * FROM productcustomimages WHERE product_id = '26597'
287 0.0012 0.0012471675872803
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '26597' AND a.name = n.originalname
288 0.0002 0.0001530647277832
SELECT * FROM productoffers WHERE product_id = '26597' AND merchantid = ''
289 0.0002 0.00017714500427246
SELECT * FROM productoffers
                WHERE product_id = '26597' AND price > 0
                ORDER BY price ASC LIMIT 1
290 0.0003 0.00033211708068848
SELECT * FROM productoffers
                WHERE product_id = 26597
                ORDER BY price ASC LIMIT 1
291 0.0008 0.0008242130279541
SELECT value FROM productattributes
                WHERE product_id = '26597'
                AND name = 'ListPriceAmount'
292 0.0002 0.00016593933105469
UPDATE products SET price = '1524' WHERE id = '26597'
293 0.0002 0.00018405914306641
SELECT * FROM products WHERE id = '29177'
294 0.0001 8.2969665527344E-5
SELECT * FROM productimages WHERE product_id = '29177' ORDER BY sortorder ASC
295 0.0026 0.0026149749755859
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '29177' AND p.id = pi.product_id ORDER BY pi.sortorder
296 0.0001 8.9883804321289E-5
SELECT * FROM product_image_select WHERE product_id = '29177'
297 0.0001 7.2002410888672E-5
SELECT * FROM productcustomimages WHERE product_id = '29177'
298 0.0005 0.00049209594726562
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 = '29177'
                GROUP BY o.product_id
299 0.0068 0.0068051815032959
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     = '29177'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
300 0.0004 0.0004270076751709
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 29177
301 0.0001 0.00011706352233887
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '29177' AND a.name = n.originalname
302 0.0002 0.00022602081298828
SELECT * FROM productoffers WHERE product_id = '29177' AND merchantid = ''
303 0.0010 0.0010240077972412
SELECT * FROM productoffers
                WHERE product_id = '29177' AND price > 0
                ORDER BY price ASC LIMIT 1
304 0.0004 0.00040292739868164
SELECT * FROM productoffers
                WHERE product_id = 29177
                ORDER BY price ASC LIMIT 1
305 0.0001 0.00012302398681641
SELECT value FROM productattributes
                WHERE product_id = '29177'
                AND name = 'ListPriceAmount'
306 0.0001 0.00012898445129395
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 = '29177'
                GROUP BY o.product_id
307 0.0001 0.00012397766113281
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     = '29177'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
308 0.0001 0.00010395050048828
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 29177
309 0.0004 0.00041604042053223
SELECT value FROM productattributes WHERE product_id = '29177' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
310 0.0021 0.0020909309387207
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '29177'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
311 0.0011 0.001086950302124
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '29177'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
312 0.0005 0.00048112869262695
SELECT * FROM products WHERE id = '23020'
313 0.0004 0.00035500526428223
SELECT * FROM productimages WHERE product_id = '23020' ORDER BY sortorder ASC
314 0.0001 0.00010085105895996
SELECT * FROM product_image_select WHERE product_id = '23020'
315 0.0001 9.7036361694336E-5
SELECT * FROM productcustomimages WHERE product_id = '23020'
316 0.0014 0.0013711452484131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '23020' AND a.name = n.originalname
317 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '23020' AND merchantid = ''
318 0.0003 0.00033092498779297
SELECT * FROM productoffers
                WHERE product_id = '23020' AND price > 0
                ORDER BY price ASC LIMIT 1
319 0.0001 0.00014185905456543
SELECT * FROM productoffers
                WHERE product_id = 23020
                ORDER BY price ASC LIMIT 1
320 0.0006 0.00060892105102539
SELECT value FROM productattributes
                WHERE product_id = '23020'
                AND name = 'ListPriceAmount'
321 0.0001 0.00014281272888184
UPDATE products SET price = '1027' WHERE id = '23020'
322 0.0002 0.00023198127746582
SELECT * FROM products WHERE id = '25282'
323 0.0001 0.00010180473327637
SELECT * FROM productimages WHERE product_id = '25282' ORDER BY sortorder ASC
324 0.0004 0.00041294097900391
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '25282' AND p.id = pi.product_id ORDER BY pi.sortorder
325 0.0001 0.00011610984802246
SELECT * FROM product_image_select WHERE product_id = '25282'
326 0.0001 0.00010180473327637
SELECT * FROM productcustomimages WHERE product_id = '25282'
327 0.0002 0.00023913383483887
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 = '25282'
                GROUP BY o.product_id
328 0.0004 0.00040006637573242
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     = '25282'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
329 0.0002 0.00022506713867188
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 25282
330 0.0008 0.00084710121154785
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '25282' AND a.name = n.originalname
331 0.0004 0.00042605400085449
SELECT * FROM productoffers WHERE product_id = '25282' AND merchantid = ''
332 0.0003 0.00033092498779297
SELECT * FROM productoffers
                WHERE product_id = '25282' AND price > 0
                ORDER BY price ASC LIMIT 1
333 0.0008 0.00081682205200195
SELECT * FROM productoffers
                WHERE product_id = 25282
                ORDER BY price ASC LIMIT 1
334 0.0001 8.702278137207E-5
SELECT value FROM productattributes
                WHERE product_id = '25282'
                AND name = 'ListPriceAmount'
335 0.0001 9.0122222900391E-5
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 = '25282'
                GROUP BY o.product_id
336 0.0001 7.3909759521484E-5
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     = '25282'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
337 0.0001 6.7949295043945E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 25282
338 0.0003 0.00028800964355469
SELECT value FROM productattributes WHERE product_id = '25282' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
339 0.0004 0.00042319297790527
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '25282'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
340 0.0013 0.0012850761413574
SELECT * FROM products WHERE id = '22389'
341 0.0011 0.0011179447174072
SELECT * FROM productimages WHERE product_id = '22389' ORDER BY sortorder ASC
342 0.0001 9.1075897216797E-5
SELECT * FROM product_image_select WHERE product_id = '22389'
343 0.0001 8.702278137207E-5
SELECT * FROM productcustomimages WHERE product_id = '22389'
344 0.0035 0.0035209655761719
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '22389' AND a.name = n.originalname
345 0.0004 0.00037598609924316
SELECT * FROM productoffers WHERE product_id = '22389' AND merchantid = ''
346 0.0005 0.00049400329589844
SELECT * FROM productoffers
                WHERE product_id = '22389' AND price > 0
                ORDER BY price ASC LIMIT 1
347 0.0005 0.00052094459533691
SELECT * FROM productoffers
                WHERE product_id = 22389
                ORDER BY price ASC LIMIT 1
348 0.0003 0.00029397010803223
SELECT value FROM productattributes
                WHERE product_id = '22389'
                AND name = 'ListPriceAmount'
349 0.0002 0.0001838207244873
UPDATE products SET price = '2874' WHERE id = '22389'
350 0.0004 0.00039100646972656
SELECT * FROM products WHERE id = '23751'
351 0.0001 0.00010299682617188
SELECT * FROM productimages WHERE product_id = '23751' ORDER BY sortorder ASC
352 0.0001 9.4890594482422E-5
SELECT * FROM product_image_select WHERE product_id = '23751'
353 0.0001 8.8930130004883E-5
SELECT * FROM productcustomimages WHERE product_id = '23751'
354 0.0043 0.004256010055542
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '23751' AND a.name = n.originalname
355 0.0013 0.0013010501861572
SELECT * FROM productoffers WHERE product_id = '23751' AND merchantid = ''
356 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = '23751' AND price > 0
                ORDER BY price ASC LIMIT 1
357 0.0003 0.00034379959106445
SELECT * FROM productoffers
                WHERE product_id = 23751
                ORDER BY price ASC LIMIT 1
358 0.0016 0.0016059875488281
SELECT value FROM productattributes
                WHERE product_id = '23751'
                AND name = 'ListPriceAmount'
359 0.0002 0.00023198127746582
UPDATE products SET price = '895' WHERE id = '23751'
360 0.0003 0.00033211708068848
SELECT * FROM products WHERE id = '22990'
361 0.0003 0.0002748966217041
SELECT * FROM productimages WHERE product_id = '22990' ORDER BY sortorder ASC
362 0.0001 9.2983245849609E-5
SELECT * FROM product_image_select WHERE product_id = '22990'
363 0.0001 9.1075897216797E-5
SELECT * FROM productcustomimages WHERE product_id = '22990'
364 0.0001 0.00013089179992676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '22990' AND a.name = n.originalname
365 0.0004 0.00044488906860352
SELECT * FROM productoffers WHERE product_id = '22990' AND merchantid = ''
366 0.0026 0.0026190280914307
SELECT value FROM productattributes WHERE product_id = '22990' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
367 0.0014 0.0014228820800781
UPDATE products SET price = '899' WHERE id = '22990'
368 0.0007 0.0007331371307373
SELECT * FROM products WHERE id = '19826'
369 0.0001 0.0001220703125
SELECT * FROM productimages WHERE product_id = '19826' ORDER BY sortorder ASC
370 0.0002 0.00015711784362793
SELECT * FROM product_image_select WHERE product_id = '19826'
371 0.0001 0.00011086463928223
SELECT * FROM productcustomimages WHERE product_id = '19826'
372 0.0001 0.00011992454528809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '19826' AND a.name = n.originalname
373 0.0004 0.00035810470581055
SELECT * FROM productoffers WHERE product_id = '19826' AND merchantid = ''
374 0.0003 0.00029397010803223
SELECT value FROM productattributes WHERE product_id = '19826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
375 0.0001 0.00014710426330566
UPDATE products SET price = '10547' WHERE id = '19826'
376 0.0002 0.0001990795135498
SELECT * FROM products WHERE id = '22460'
377 0.0001 9.0837478637695E-5
SELECT * FROM productimages WHERE product_id = '22460' ORDER BY sortorder ASC
378 0.0001 8.392333984375E-5
SELECT * FROM product_image_select WHERE product_id = '22460'
379 0.0001 8.2969665527344E-5
SELECT * FROM productcustomimages WHERE product_id = '22460'
380 0.0035 0.0035140514373779
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '22460' AND a.name = n.originalname
381 0.0005 0.00052499771118164
SELECT * FROM productoffers WHERE product_id = '22460' AND merchantid = ''
382 0.0002 0.00023317337036133
SELECT * FROM productoffers
                WHERE product_id = '22460' AND price > 0
                ORDER BY price ASC LIMIT 1
383 0.0003 0.00033903121948242
SELECT * FROM productoffers
                WHERE product_id = 22460
                ORDER BY price ASC LIMIT 1
384 0.0002 0.00023794174194336
SELECT value FROM productattributes
                WHERE product_id = '22460'
                AND name = 'ListPriceAmount'
385 0.0001 0.00014400482177734
UPDATE products SET price = '999' WHERE id = '22460'
386 0.0004 0.00044012069702148
SELECT * FROM products WHERE id = '22293'
387 0.0001 0.00010204315185547
SELECT * FROM productimages WHERE product_id = '22293' ORDER BY sortorder ASC
388 0.0001 0.00010204315185547
SELECT * FROM product_image_select WHERE product_id = '22293'
389 0.0001 0.00010395050048828
SELECT * FROM productcustomimages WHERE product_id = '22293'
390 0.0024 0.002399206161499
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '22293' AND a.name = n.originalname
391 0.0003 0.00025296211242676
SELECT * FROM productoffers WHERE product_id = '22293' AND merchantid = ''
392 0.0022 0.0022110939025879
SELECT * FROM productoffers
                WHERE product_id = '22293' AND price > 0
                ORDER BY price ASC LIMIT 1
393 0.0018 0.0017929077148438
SELECT * FROM productoffers
                WHERE product_id = 22293
                ORDER BY price ASC LIMIT 1
394 0.0006 0.00057005882263184
SELECT value FROM productattributes
                WHERE product_id = '22293'
                AND name = 'ListPriceAmount'
395 0.0004 0.00039792060852051
UPDATE products SET price = '2043' WHERE id = '22293'
396 0.0004 0.00038695335388184
SELECT * FROM products WHERE id = '24664'
397 0.0001 0.00010490417480469
SELECT * FROM productimages WHERE product_id = '24664' ORDER BY sortorder ASC
398 0.0001 9.8943710327148E-5
SELECT * FROM product_image_select WHERE product_id = '24664'
399 0.0001 9.7990036010742E-5
SELECT * FROM productcustomimages WHERE product_id = '24664'
400 0.0025 0.0025339126586914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '24664' AND a.name = n.originalname
401 0.0004 0.00036811828613281
SELECT * FROM productoffers WHERE product_id = '24664' AND merchantid = ''
402 0.0002 0.00023913383483887
SELECT * FROM productoffers
                WHERE product_id = '24664' AND price > 0
                ORDER BY price ASC LIMIT 1
403 0.0021 0.0021028518676758
SELECT * FROM productoffers
                WHERE product_id = 24664
                ORDER BY price ASC LIMIT 1
404 0.0006 0.00062298774719238
SELECT value FROM productattributes
                WHERE product_id = '24664'
                AND name = 'ListPriceAmount'
405 0.0018 0.0018270015716553
UPDATE products SET price = '1155' WHERE id = '24664'
406 0.0003 0.00030207633972168
SELECT * FROM products WHERE id = '22827'
407 0.0002 0.00023102760314941
SELECT * FROM productimages WHERE product_id = '22827' ORDER BY sortorder ASC
408 0.0001 0.00010585784912109
SELECT * FROM product_image_select WHERE product_id = '22827'
409 0.0001 0.00010180473327637
SELECT * FROM productcustomimages WHERE product_id = '22827'
410 0.0023 0.0023281574249268
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '22827' AND a.name = n.originalname
411 0.0002 0.00023102760314941
SELECT * FROM productoffers WHERE product_id = '22827' AND merchantid = ''
412 0.0011 0.0011088848114014
SELECT * FROM productoffers
                WHERE product_id = '22827' AND price > 0
                ORDER BY price ASC LIMIT 1
413 0.0005 0.00045204162597656
SELECT * FROM productoffers
                WHERE product_id = 22827
                ORDER BY price ASC LIMIT 1
414 0.0004 0.00037813186645508
SELECT value FROM productattributes
                WHERE product_id = '22827'
                AND name = 'ListPriceAmount'
415 0.0002 0.00017189979553223
UPDATE products SET price = '4195' WHERE id = '22827'
416 0.0002 0.00021791458129883
SELECT * FROM products WHERE id = '28703'
417 0.0001 9.3936920166016E-5
SELECT * FROM productimages WHERE product_id = '28703' ORDER BY sortorder ASC
418 0.0001 8.8930130004883E-5
SELECT * FROM product_image_select WHERE product_id = '28703'
419 0.0001 8.9168548583984E-5
SELECT * FROM productcustomimages WHERE product_id = '28703'
420 0.0001 0.00010490417480469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '28703' AND a.name = n.originalname
421 0.0017 0.0017261505126953
SELECT * FROM productoffers WHERE product_id = '28703' AND merchantid = ''
422 0.0018 0.0018410682678223
SELECT value FROM productattributes WHERE product_id = '28703' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0001 0.00014519691467285
UPDATE products SET price = '1535' WHERE id = '28703'
424 0.0003 0.00025701522827148
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '29367' ORDER BY timestamp DESC
425 0.0003 0.00033211708068848
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '27730' ORDER BY timestamp DESC
426 0.0002 0.00021505355834961
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '22086' ORDER BY timestamp DESC
427 0.0003 0.00025010108947754
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '10859' ORDER BY timestamp DESC
428 0.0002 0.00020599365234375
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '22691' ORDER BY timestamp DESC
429 0.0002 0.00021100044250488
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '26597' ORDER BY timestamp DESC
430 0.0002 0.00021004676818848
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '29177' ORDER BY timestamp DESC
431 0.0001 0.00014615058898926
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '23020' ORDER BY timestamp DESC
432 0.0002 0.00017690658569336
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '25282' ORDER BY timestamp DESC
433 0.0002 0.00019407272338867
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '22389' ORDER BY timestamp DESC
434 0.0001 0.00013208389282227
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '23751' ORDER BY timestamp DESC
435 0.0015 0.0014650821685791
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '22990' ORDER BY timestamp DESC
436 0.0002 0.0001981258392334
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '19826' ORDER BY timestamp DESC
437 0.0004 0.0004270076751709
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '22460' ORDER BY timestamp DESC
438 0.0006 0.00060606002807617
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '22293' ORDER BY timestamp DESC
439 0.0011 0.001133918762207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '24664' ORDER BY timestamp DESC
440 0.0003 0.00034213066101074
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '22827' ORDER BY timestamp DESC
441 0.0002 0.00015711784362793
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '28703' ORDER BY timestamp DESC
442 0.0001 0.00011610984802246
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 69
		AND c.prod_type = 'ebay'
		AND hide = 1
443 0.0001 7.319450378418E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
444 0.0001 9.2983245849609E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
445 0.0001 9.2029571533203E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
446 0.0001 9.0122222900391E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
447 0.0001 8.8930130004883E-5
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
448 0.0001 9.4890594482422E-5
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
449 0.0001 9.2983245849609E-5
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
450 0.0001 0.00010395050048828
SELECT * FROM pages WHERE id = 52
451 0.0001 9.1075897216797E-5
SELECT * FROM pages WHERE id = 53
452 0.0001 9.5129013061523E-5
SELECT * FROM pages WHERE id = 54
453 0.0001 9.1075897216797E-5
SELECT * FROM pages WHERE id = 51
454 0.0001 9.2983245849609E-5
SELECT * FROM pages WHERE id = 52
455 0.0001 0.00010085105895996
SELECT * FROM pages WHERE id = 53
456 0.0001 9.1075897216797E-5
SELECT * FROM pages WHERE id = 54
457 0.0001 9.1075897216797E-5
SELECT * FROM pages WHERE id = 51
458 0.0001 9.1075897216797E-5
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (p.price >= 1000 AND p.price <= 50000) AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY o.percentagesaved DESC LIMIT 4
459 0.0009 0.00085306167602539
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"4\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:2:\"10\";s:8:\"maxprice\";s:3:\"500\";s:9:\"minimages\";s:1:\"1\";s:10:\"updatetime\";s:5:\"21600\";s:13:\"selectiontype\";s:13:\"specialoffers\";s:11:\"lastupdated\";i:1560655080;s:8:\"products\";a:4:{i:0;s:4:\"4619\";i:1;s:3:\"955\";i:2;s:4:\"1934\";i:3;s:3:\"758\";}}' WHERE id = '207'
460 0.0001 0.00011682510375977
SELECT * FROM products WHERE id IN (4619,955,1934,758) ORDER BY FIELD(id, 4619,955,1934,758 )
461 0.0001 8.8930130004883E-5
SELECT * FROM productimages WHERE product_id = '4619' ORDER BY sortorder ASC
462 0.0001 8.5115432739258E-5
SELECT * FROM product_image_select WHERE product_id = '4619'
463 0.0001 8.702278137207E-5
SELECT * FROM productcustomimages WHERE product_id = '4619'
464 0.0001 9.3936920166016E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4619' AND a.name = n.originalname
465 0.0001 0.00010490417480469
SELECT * FROM productoffers WHERE product_id = '4619' AND merchantid = ''
466 0.0001 9.0122222900391E-5
SELECT value FROM productattributes WHERE product_id = '4619' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
467 0.0002 0.00016188621520996
UPDATE products SET price = '2993' WHERE id = '4619'
468 0.0001 8.9883804321289E-5
SELECT * FROM productimages WHERE product_id = '955' ORDER BY sortorder ASC
469 0.0001 8.6069107055664E-5
SELECT * FROM product_image_select WHERE product_id = '955'
470 0.0001 8.2015991210938E-5
SELECT * FROM productcustomimages WHERE product_id = '955'
471 0.0001 8.9883804321289E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '955' AND a.name = n.originalname
472 0.0001 8.8930130004883E-5
SELECT * FROM productoffers WHERE product_id = '955' AND merchantid = ''
473 0.0001 9.8943710327148E-5
SELECT value FROM productattributes WHERE product_id = '955' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
474 0.0001 0.00014090538024902
UPDATE products SET price = '7426' WHERE id = '955'
475 0.0001 9.8943710327148E-5
SELECT * FROM productimages WHERE product_id = '1934' ORDER BY sortorder ASC
476 0.0001 8.4877014160156E-5
SELECT * FROM product_image_select WHERE product_id = '1934'
477 0.0001 8.392333984375E-5
SELECT * FROM productcustomimages WHERE product_id = '1934'
478 0.0001 0.00010204315185547
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1934' AND a.name = n.originalname
479 0.0001 8.7976455688477E-5
SELECT * FROM productoffers WHERE product_id = '1934' AND merchantid = ''
480 0.0001 8.2969665527344E-5
SELECT value FROM productattributes WHERE product_id = '1934' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
481 0.0002 0.00016212463378906
UPDATE products SET price = '15048' WHERE id = '1934'
482 0.0001 8.7976455688477E-5
SELECT * FROM productimages WHERE product_id = '758' ORDER BY sortorder ASC
483 0.0001 8.8930130004883E-5
SELECT * FROM product_image_select WHERE product_id = '758'
484 0.0001 8.4161758422852E-5
SELECT * FROM productcustomimages WHERE product_id = '758'
485 0.0001 9.7036361694336E-5
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '758' AND a.name = n.originalname
486 0.0001 8.702278137207E-5
SELECT * FROM productoffers WHERE product_id = '758' AND merchantid = ''
487 0.0001 8.702278137207E-5
SELECT value FROM productattributes WHERE product_id = '758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
488 0.0001 0.00014114379882812
UPDATE products SET price = '3921' WHERE id = '758'
489 0.0001 9.4890594482422E-5
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
490 0.0001 8.9883804321289E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
491 0.0001 8.392333984375E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
492 0.0001 8.8930130004883E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
493 0.0001 8.5115432739258E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
494 0.0001 9.7990036010742E-5
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
495 0.0001 8.7976455688477E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
496 0.0001 0.00010085105895996
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
497 0.0002 0.00015401840209961
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
498 0.0001 0.00011992454528809
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
499 0.0001 0.00010991096496582
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
500 0.0001 0.00014805793762207
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
501 0.0001 9.1075897216797E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
502 0.0001 8.4877014160156E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
503 0.0001 8.9883804321289E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
504 0.0001 9.8943710327148E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
505 0.0001 8.4161758422852E-5
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
506 0.0002 0.00015401840209961
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
507 0.0001 9.8943710327148E-5
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND textuid = '' AND language = 'en'
508 0.0001 0.00010395050048828
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'