Tactical Equipment - Survivalist Equipment

Hawke Sport Optics 12131 Red Dot 1X Reflect Sight Weaver Rail, Black by Sportsman Supply Inc.

Price: $99.95
Product prices and availability are accurate as of 2019-06-21 20:26:49 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.
Availability: In Stock
Usually ships in 1-2 business days
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Description

The Tactical and Survivalist shop is delighted to stock the brilliant Hawke Sport Optics 12131 Red Dot 1X Reflect Sight Weaver Rail, Black today at this low price.

With so many competing tactical, combat and survival products available currently, it is good to have a brand that you can recognize. The Hawke Sport Optics 12131 Red Dot 1X Reflect Sight Weaver Rail, Black is certainly all that and will be a superb acquisition for your combat equipment or tactical ability.

We pride ourselves to provide the finest quality military gear for all your individual requirements.

For this special price, the Hawke Sport Optics 12131 Red Dot 1X Reflect Sight Weaver Rail, Black is greatly recommended and is always a regular choice amongst most like minded people. Sportsman Supply Inc. have passed on some great touches and this results in improved value for money.

Manufacturer Description

Hawke Reflex Dot sights offers extreme accuracy in a little, light-weight bundle. The sight features 5 brightness settings run by a digital side switch and completely multi-coated optics supplying an unlimited eye relief with parallax free 1x zoom. The Hawke Reflex Dot sights are geared up with a weaver clamp integrating a retained clamp screw.

Product Features

1X Reflect sight Weaver rail 25 layer multi-coated optics for maximum clarity Supplied with Weaver rail clamp mount Fixed focus for use on pistols, shotguns and bows Waterproof, Shock proof

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.0613899230957 743 1.0302 0


No Amazon API Requests Made.


App Debug - Total Time 2.0613899230957 seconds

Number Time From Start Name Description
1 0.40188407897949 Initialise Initialise FSB Function
2 0.41304087638855 App Controller Start Start of the App controller (called before the controller of every page)
3 0.42478394508362 Start of getCategoryListByGroup Function Before first category groups query
4 0.42498087882996 After initial query Before first category groups query
5 0.42498302459717 Get Category List for Group Before the call to getCategoryList function
6 0.42498898506165 Start of GetCategoryList function Start of the function
7 0.42499399185181 Before getting categories Query to get specific category list
8 0.42559599876404 After getting categories Query to get specific category list
9 0.42559790611267 Before getting category custom Before call to function getCategoryCustom
10 0.42760992050171 After getting category custom After call to function getCategoryCustom
11 0.42761301994324 Before getting category custom Before call to function getCategoryCustom
12 0.43834209442139 After getting category custom After call to function getCategoryCustom
13 0.43834590911865 Before getting category custom Before call to function getCategoryCustom
14 0.44399094581604 After getting category custom After call to function getCategoryCustom
15 0.44399404525757 Before getting category custom Before call to function getCategoryCustom
16 0.44822287559509 After getting category custom After call to function getCategoryCustom
17 0.4482250213623 End of GetCategoryList function End of the function
18 0.44823598861694 Get Category List for Group Before the call to getCategoryList function
19 0.44823908805847 Start of GetCategoryList function Start of the function
20 0.44824194908142 Before getting categories Query to get specific category list
21 0.44869494438171 After getting categories Query to get specific category list
22 0.44869709014893 Before getting category custom Before call to function getCategoryCustom
23 0.45435309410095 After getting category custom After call to function getCategoryCustom
24 0.4543559551239 Before getting category custom Before call to function getCategoryCustom
25 0.46496295928955 After getting category custom After call to function getCategoryCustom
26 0.46496605873108 End of GetCategoryList function End of the function
27 0.46497297286987 Get Category List for Group Before the call to getCategoryList function
28 0.4649760723114 Start of GetCategoryList function Start of the function
29 0.46497893333435 Before getting categories Query to get specific category list
30 0.46569991111755 After getting categories Query to get specific category list
31 0.46570086479187 Before getting category custom Before call to function getCategoryCustom
32 0.4749870300293 After getting category custom After call to function getCategoryCustom
33 0.47498989105225 Before getting category custom Before call to function getCategoryCustom
34 0.49248194694519 After getting category custom After call to function getCategoryCustom
35 0.49248600006104 Before getting category custom Before call to function getCategoryCustom
36 0.49860787391663 After getting category custom After call to function getCategoryCustom
37 0.49861192703247 Before getting category custom Before call to function getCategoryCustom
38 0.50464105606079 After getting category custom After call to function getCategoryCustom
39 0.50464391708374 Before getting category custom Before call to function getCategoryCustom
40 0.51103901863098 After getting category custom After call to function getCategoryCustom
41 0.51104187965393 Before getting category custom Before call to function getCategoryCustom
42 0.53344202041626 After getting category custom After call to function getCategoryCustom
43 0.53344702720642 Before getting category custom Before call to function getCategoryCustom
44 0.53764986991882 After getting category custom After call to function getCategoryCustom
45 0.53765201568604 Before getting category custom Before call to function getCategoryCustom
46 0.54237604141235 After getting category custom After call to function getCategoryCustom
47 0.54237794876099 End of GetCategoryList function End of the function
48 0.54239201545715 Get Category List for Group Before the call to getCategoryList function
49 0.5423948764801 Start of GetCategoryList function Start of the function
50 0.54239892959595 Before getting categories Query to get specific category list
51 0.54283308982849 After getting categories Query to get specific category list
52 0.54283499717712 Before getting category custom Before call to function getCategoryCustom
53 0.54519486427307 After getting category custom After call to function getCategoryCustom
54 0.5451979637146 Before getting category custom Before call to function getCategoryCustom
55 0.54761290550232 After getting category custom After call to function getCategoryCustom
56 0.54761600494385 End of GetCategoryList function End of the function
57 0.54762196540833 Get Category List for Group Before the call to getCategoryList function
58 0.54762387275696 Start of GetCategoryList function Start of the function
59 0.54762697219849 Before getting categories Query to get specific category list
60 0.5480170249939 After getting categories Query to get specific category list
61 0.54801893234253 Before getting category custom Before call to function getCategoryCustom
62 0.55308389663696 After getting category custom After call to function getCategoryCustom
63 0.55308604240417 End of GetCategoryList function End of the function
64 0.55309295654297 End of getCategoryListByGroup Function Before return()
65 0.60707998275757 App Controller End End of the App controller (called before the controller of every page)
66 0.60773897171021 Product Start Start of the product info controller
67 0.60869288444519 Cache file not found Starting get product details
68 0.62842202186584 Related products Start getting related products if enabled
69 0.62842392921448 Related Products Start Before the related products are found
70 0.62842488288879 Related Products Keywords Before the related product keywords are found
71 0.62843704223633 Create Keyword List Function Start of function
72 0.62953591346741 Create Keyword List Function After looping provided content - 641 keywords found
73 0.67112398147583 Create Keyword List Function After looping initial keyword list - 587 keywords remaining
74 0.67128205299377 Create Keyword List Function After reducing keyword list
75 0.67235803604126 Create Keyword List Function After selecting by scoring keywords
76 0.67236304283142 Create Keyword List Function After final loop of keywords
77 0.67236590385437 Related Products Keywords After the related product keywords are found
78 0.93729686737061 Related Products End After the related products are found
79 1.1736118793488 Product End End of the product info controller (Product Info)
80 1.1740238666534 App_after Controller Start Start of the App_after controller (called after the controller of every page)
81 1.1741199493408 Before Get Options Before the call to getOptions in the tpl class
82 1.5112628936768 After Get Options After the call to getOptions in the tpl class
83 1.511547088623 App_after Controller End End of the App_after controller (called after the controller of every page)
84 1.5115599632263 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
85 1.8562729358673 Product Info: After Smarty Fetch After the product.tpl template is fetched
86 1.8562800884247 Product Info: Before Template Display Before the template is displayed
87 2.0613679885864 Product Info: After Template Display After the template is displayed
88 2.0613729953766 Finalizing debug Before the debug is output to the page.
89 2.0613880157471 End of App This is the end of the app logging, final timestamp


Query Debug - 743 Database Queries. Total time 1.0302 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016498565673828
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00044918060302734
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00018620491027832
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00016999244689941
SELECT * FROM `bad_bots`
5 0.0004 0.00043511390686035
SELECT parameter, value FROM parameters
6 0.0002 0.00016283988952637
SET time_zone = 'Europe/London'
7 0.0004 0.00035881996154785
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00017619132995605
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.0001060962677002
delete from cachefiles
10 0.0002 0.00024604797363281
SELECT id FROM pages WHERE pagename = 'hawke-sport-optics-12131-red-dot-1x-reflect-sight-weaver-rail-black' LIMIT 1
11 0.0002 0.00023913383483887
SELECT id FROM products WHERE pagename = 'hawke-sport-optics-12131-red-dot-1x-reflect-sight-weaver-rail-black' AND hidden = 0 LIMIT 1
12 0.0012 0.0012121200561523
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0094 0.0094490051269531
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0002 0.000244140625
SELECT * FROM pages WHERE pagename = 'hawke-sport-optics-12131-red-dot-1x-reflect-sight-weaver-rail-black'
15 0.0002 0.00017786026000977
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00055718421936035
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00050592422485352
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
18 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.00046396255493164
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 
20 0.0002 0.00016403198242188
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 
21 0.0002 0.00016093254089355
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 
22 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0030241012573242
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
25 0.0003 0.00028395652770996
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.0002131462097168
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00021219253540039
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0057101249694824
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
32 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
33 0.0002 0.00019097328186035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0022978782653809
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 = 80
36 0.0003 0.00027990341186523
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0023221969604492
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
39 0.0002 0.00015783309936523
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
40 0.0002 0.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00014400482177734
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0011627674102783
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
43 0.0003 0.0002598762512207
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0018100738525391
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
46 0.0002 0.00016379356384277
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
48 0.0002 0.00019216537475586
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00042200088500977
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.002331018447876
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
52 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0023040771484375
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 
54 0.0002 0.00015711784362793
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 
55 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
56 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '2'
58 0.0047 0.004741907119751
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
59 0.0003 0.00027799606323242
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0047931671142578
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 
61 0.0002 0.00017189979553223
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 
62 0.0002 0.00016093254089355
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 
63 0.0002 0.00017881393432617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00014495849609375
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00065088272094727
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.004141092300415
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 = 64
67 0.0003 0.00029516220092773
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.004080057144165
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (64)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
69 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0002 0.00015711784362793
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00014615058898926
SELECT * FROM categorygroups WHERE id = '10'
73 0.0082 0.0081551074981689
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 = 65
74 0.0003 0.00029897689819336
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.0082199573516846
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
76 0.0002 0.00019311904907227
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0025169849395752
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 = 81
81 0.0003 0.00027680397033691
SELECT id FROM categories WHERE parent_id = '81'
82 0.0026 0.0025551319122314
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0002 0.0001838207244873
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0002 0.00015616416931152
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
85 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '10'
87 0.0025 0.0024979114532471
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 = 31
88 0.0003 0.00027108192443848
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024988651275635
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
90 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
92 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00014519691467285
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022459030151367
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
95 0.0003 0.00027203559875488
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '131'
97 0.0029 0.0028610229492188
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
98 0.0002 0.00016212463378906
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00017285346984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0002 0.00015401840209961
SELECT * FROM categorygroups WHERE id = '10'
102 0.0094 0.0094411373138428
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 = 34
103 0.0003 0.00029921531677246
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.0002281665802002
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00022101402282715
SELECT id FROM categories WHERE parent_id = '130'
109 0.0106 0.010603189468384
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
110 0.0002 0.00021696090698242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
111 0.0002 0.00019407272338867
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
112 0.0002 0.00020503997802734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00014400482177734
SELECT * FROM categorygroups WHERE id = '10'
114 0.0016 0.0015859603881836
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 = 32
115 0.0003 0.00028014183044434
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0016050338745117
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0002 0.00015115737915039
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0002 0.00015616416931152
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
119 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '10'
121 0.0019 0.0018517971038818
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 = 89
122 0.0003 0.0002601146697998
SELECT id FROM categories WHERE parent_id = '89'
123 0.0019 0.0018608570098877
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0002 0.00015115737915039
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
125 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
126 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00040292739868164
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00068998336791992
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 = 84
130 0.0002 0.00024104118347168
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00069808959960938
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
133 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00018715858459473
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00013113021850586
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00070500373840332
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 = 90
137 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00074100494384766
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00014495849609375
SELECT * FROM categorygroups WHERE id = '17'
143 0.0004 0.00037217140197754
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0021 0.002065896987915
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 = 92
145 0.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020051002502441
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0002 0.0001521110534668
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
148 0.0002 0.00015521049499512
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '20'
151 0.0052 0.0051918029785156
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00037407875061035
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00016689300537109
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00016307830810547
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '84'
158 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00020885467529297
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '379'
168 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '450'
170 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00020408630371094
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '133'
185 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '217'
187 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '271'
190 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '286'
191 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00020813941955566
SELECT * FROM pages WHERE id = '364'
198 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00018095970153809
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00026512145996094
SELECT * FROM pages WHERE id = '66'
204 0.0003 0.00027990341186523
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '90'
206 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '150'
211 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00016522407531738
SELECT * FROM pages WHERE id = '162'
213 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '164'
214 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '268'
219 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '290'
221 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '413'
222 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '327'
224 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '386'
233 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '428'
240 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '432'
241 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '437'
244 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00016212463378906
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '137'
249 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '407'
252 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00017404556274414
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '42'
264 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '86'
266 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '62'
274 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00018978118896484
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '393'
290 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '394'
291 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '421'
294 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '430'
296 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '451'
302 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '453'
303 0.0002 0.00015401840209961
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00022292137145996
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '417'
310 0.0002 0.0001518726348877
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '181'
313 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '383'
317 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '442'
320 0.0002 0.00015091896057129
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00023579597473145
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00023388862609863
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '248'
327 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '115'
334 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '151'
337 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '200'
339 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '304'
340 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '446'
350 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '456'
354 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '462'
357 0.0002 0.00015687942504883
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = '182'
360 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '238'
361 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '242'
363 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '253'
365 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '267'
367 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '420'
368 0.0002 0.00016403198242188
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00012898445129395
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0014441013336182
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00018215179443359
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.00013113021850586
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.00012803077697754
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00029897689819336
SELECT * FROM products WHERE pagename = 'hawke-sport-optics-12131-red-dot-1x-reflect-sight-weaver-rail-black'
376 0.0002 0.00020694732666016
SELECT * FROM manufacturers WHERE id = '858'
377 0.0008 0.00075912475585938
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '858'
378 0.0001 0.00012612342834473
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '858' LIMIT 1
379 0.0007 0.00067996978759766
SELECT pagename, id FROM products p WHERE manufacturer_id = '858' ORDER BY RAND() LIMIT 1
380 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '273575' ORDER BY sortorder ASC
381 0.0007 0.0006709098815918
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '858'
382 0.0007 0.00072503089904785
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '858'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00012707710266113
SELECT * FROM manufacturerimages WHERE manufacturer_id = '858'
384 0.0001 0.00014591217041016
SELECT category_id FROM products_categories WHERE product_id = '404498'
385 0.0002 0.00016593933105469
SELECT * FROM categories WHERE id = '98'
386 0.0008 0.00075101852416992
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 = 98
387 0.0001 0.00011897087097168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 98
388 0.0003 0.00027608871459961
SELECT id FROM categories WHERE parent_id = '98'
389 0.0008 0.00075793266296387
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (98)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
390 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (98)
				  AND p.disabled = 0 
391 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (98)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
392 0.0002 0.00017309188842773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '98'
393 0.0002 0.00022697448730469
SELECT * FROM productimages WHERE product_id = '404498' ORDER BY sortorder ASC
394 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '404498'
395 0.0001 0.00014305114746094
SELECT * FROM productcustomimages WHERE product_id = '404498'
396 0.0001 0.00012397766113281
SELECT * FROM productfeeds WHERE product_id = '404498' ORDER BY item_date DESC
397 0.0004 0.00035595893859863
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '404498' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
398 0.0003 0.00031495094299316
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '404498' AND t.hidden = 0 AND display_product = 1
399 0.0002 0.00016498565673828
SELECT * FROM tags WHERE id = '8596'
400 0.0006 0.00060606002807617
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '8596'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
401 0.0006 0.00058698654174805
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '8596'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
402 0.0006 0.0006110668182373
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '8596' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
403 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '408065' ORDER BY sortorder ASC
404 0.0002 0.00015902519226074
SELECT * FROM tags WHERE id = '3419'
405 0.0015 0.0015029907226562
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3419'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
406 0.0014 0.0014259815216064
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3419'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
407 0.0015 0.0014629364013672
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3419' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
408 0.0004 0.00035786628723145
SELECT * FROM productimages WHERE product_id = '258602' ORDER BY sortorder ASC
409 0.0002 0.00017189979553223
SELECT * FROM productamazoncontent WHERE product_id = '404498'
410 0.0028 0.0027878284454346
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404498' AND a.name = n.originalname
411 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '404498' AND merchantid = 'ATVPDKIKX0DER'
412 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = '404498' AND price > 0
                ORDER BY price ASC LIMIT 1
413 0.0004 0.00044012069702148
SELECT value FROM productattributes WHERE product_id = '404498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
414 0.0001 0.00014400482177734
UPDATE products SET price = '9995' WHERE id = '404498'
415 0.2384 0.2384090423584
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('weaver' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('weaver' IN BOOLEAN MODE) AND 404498 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
416 0.0005 0.0005340576171875
SELECT * FROM productimages WHERE product_id = '128892' ORDER BY sortorder ASC
417 0.0002 0.00024199485778809
SELECT * FROM product_image_select WHERE product_id = '128892'
418 0.0001 0.00014114379882812
SELECT * FROM productcustomimages WHERE product_id = '128892'
419 0.0020 0.0019829273223877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '128892' AND a.name = n.originalname
420 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '128892' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00021982192993164
SELECT * FROM productoffers
                WHERE product_id = '128892' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '128892' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0001 0.00014495849609375
UPDATE products SET price = '14685' WHERE id = '128892'
424 0.0002 0.00023102760314941
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
425 0.0002 0.0002288818359375
SELECT * FROM product_image_select WHERE product_id = '131163'
426 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '131163'
427 0.0026 0.0026090145111084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
428 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
429 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
430 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
431 0.0001 0.00012993812561035
UPDATE products SET price = '20362' WHERE id = '131163'
432 0.0002 0.00023293495178223
SELECT * FROM productimages WHERE product_id = '56175' ORDER BY sortorder ASC
433 0.0002 0.00023579597473145
SELECT * FROM product_image_select WHERE product_id = '56175'
434 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '56175'
435 0.0027 0.0026800632476807
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '56175' AND a.name = n.originalname
436 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '56175' AND merchantid = 'ATVPDKIKX0DER'
437 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '56175' AND price > 0
                ORDER BY price ASC LIMIT 1
438 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '56175' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
439 0.0001 0.00014114379882812
UPDATE products SET price = '12766' WHERE id = '56175'
440 0.0002 0.00021004676818848
SELECT * FROM productimages WHERE product_id = '129650' ORDER BY sortorder ASC
441 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '129650'
442 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '129650'
443 0.0027 0.0027320384979248
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '129650' AND a.name = n.originalname
444 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '129650' AND merchantid = 'ATVPDKIKX0DER'
445 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '129650' AND price > 0
                ORDER BY price ASC LIMIT 1
446 0.0004 0.0004270076751709
SELECT value FROM productattributes WHERE product_id = '129650' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
447 0.0001 0.00012803077697754
UPDATE products SET price = '5399' WHERE id = '129650'
448 0.0002 0.00021004676818848
SELECT * FROM productimages WHERE product_id = '121508' ORDER BY sortorder ASC
449 0.0002 0.00023913383483887
SELECT * FROM product_image_select WHERE product_id = '121508'
450 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '121508'
451 0.0028 0.0028109550476074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '121508' AND a.name = n.originalname
452 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '121508' AND merchantid = 'ATVPDKIKX0DER'
453 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '121508' AND price > 0
                ORDER BY price ASC LIMIT 1
454 0.0004 0.00040984153747559
SELECT value FROM productattributes WHERE product_id = '121508' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
455 0.0001 0.00013303756713867
UPDATE products SET price = '2999' WHERE id = '121508'
456 0.0003 0.00029206275939941
SELECT * FROM productimages WHERE product_id = '123878' ORDER BY sortorder ASC
457 0.0002 0.00023603439331055
SELECT * FROM product_image_select WHERE product_id = '123878'
458 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '123878'
459 0.0024 0.0023670196533203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '123878' AND a.name = n.originalname
460 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '123878' AND merchantid = 'ATVPDKIKX0DER'
461 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '123878' AND price > 0
                ORDER BY price ASC LIMIT 1
462 0.0004 0.00040006637573242
SELECT value FROM productattributes WHERE product_id = '123878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
463 0.0001 0.00012898445129395
UPDATE products SET price = '3951' WHERE id = '123878'
464 0.0002 0.00016093254089355
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
465 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
466 0.0001 0.00014305114746094
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
467 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
468 0.0001 0.00012898445129395
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
469 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
470 0.0001 0.00014519691467285
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
471 0.1988 0.19878792762756
SELECT * FROM ebay_products_cache WHERE cachekey = '1ae7e4d0bdf9cd29c92e37ae38d7e109' 
472 0.0003 0.00026416778564453
SELECT id,asin FROM products WHERE parent_id = 404498
473 0.0003 0.00034809112548828
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '404498' ORDER BY timestamp DESC
474 0.0002 0.00015902519226074
SELECT category_id FROM products_categories WHERE product_id = '404498'
475 0.0002 0.00016689300537109
SELECT * FROM categories WHERE id = '98'
476 0.0008 0.00078201293945312
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 = 98
477 0.0001 0.0001220703125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 98
478 0.0003 0.00026202201843262
SELECT id FROM categories WHERE parent_id = '98'
479 0.0008 0.00078296661376953
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (98)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
480 0.0002 0.00015711784362793
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (98)
				  AND p.disabled = 0 
481 0.0002 0.00016283988952637
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (98)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
482 0.0002 0.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '98'
483 0.0027 0.0027470588684082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404498' AND a.name = n.originalname
484 0.0002 0.00020384788513184
SELECT * FROM productoffers WHERE product_id = '404498' AND merchantid = 'ATVPDKIKX0DER'
485 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = '404498' AND price > 0
                ORDER BY price ASC LIMIT 1
486 0.0002 0.00021696090698242
SELECT * FROM products WHERE id = '404498'
487 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '404498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
488 0.0001 0.00013613700866699
UPDATE products SET price = '9995' WHERE id = '404498'
489 0.0028 0.0027601718902588
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404498' AND a.name = n.originalname
490 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '404498' AND merchantid = 'ATVPDKIKX0DER'
491 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '404498' AND price > 0
                ORDER BY price ASC LIMIT 1
492 0.0001 0.00014996528625488
SELECT category_id FROM products_categories WHERE product_id = '404498'
493 0.0001 0.00012493133544922
SELECT parent_id FROM categories WHERE id = '98'
494 0.0001 0.00013089179992676
SELECT parent_id FROM categories WHERE id = '34'
495 0.0002 0.00021505355834961
SELECT * FROM categories WHERE id = '34'
496 0.0095 0.0094728469848633
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 = 34
497 0.0002 0.0001528263092041
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
498 0.0003 0.00026917457580566
SELECT id FROM categories WHERE parent_id = '34'
499 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '94'
500 0.0002 0.0002138614654541
SELECT id FROM categories WHERE parent_id = '98'
501 0.0002 0.00021982192993164
SELECT id FROM categories WHERE parent_id = '99'
502 0.0002 0.00020885467529297
SELECT id FROM categories WHERE parent_id = '110'
503 0.0003 0.00026798248291016
SELECT id FROM categories WHERE parent_id = '130'
504 0.0100 0.010036945343018
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
505 0.0002 0.00017714500427246
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
506 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
507 0.0002 0.00019407272338867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
508 0.0002 0.0001521110534668
SELECT * FROM categories WHERE id = '98'
509 0.0007 0.00071001052856445
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 = 98
510 0.0001 0.00011301040649414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 98
511 0.0002 0.00023603439331055
SELECT id FROM categories WHERE parent_id = '98'
512 0.0007 0.00074291229248047
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (98)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
513 0.0001 0.00013995170593262
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (98)
				  AND p.disabled = 0 
514 0.0001 0.00014114379882812
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (98)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
515 0.0002 0.0001518726348877
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '98'
516 0.0002 0.00017690658569336
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
517 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = 2
518 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 4
519 0.0001 0.00013303756713867
SELECT * FROM pages WHERE id = 12
520 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = 10
521 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 7
522 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 18
523 0.0001 0.00013279914855957
SELECT * FROM pages WHERE id = 28
524 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = 13
525 0.0001 0.00013089179992676
SELECT * FROM pages WHERE id = 3
526 0.0317 0.031738996505737
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 o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
527 0.0002 0.00022101402282715
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";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\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1561544045;s:8:\"products\";a:6:{i:3;s:6:\"290575\";i:7;s:6:\"415016\";i:9;s:6:\"402983\";i:12;s:6:\"247027\";i:13;s:6:\"406758\";i:20;s:6:\"398823\";}}' WHERE id = '175'
528 0.0005 0.00045108795166016
SELECT * FROM products WHERE id IN (290575,415016,402983,247027,406758,398823) ORDER BY FIELD(id, 290575,415016,402983,247027,406758,398823 )
529 0.0006 0.00058913230895996
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
530 0.0002 0.0002281665802002
SELECT * FROM product_image_select WHERE product_id = '290575'
531 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '290575'
532 0.0034 0.0033998489379883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
533 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
534 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
535 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
536 0.0001 0.00011897087097168
UPDATE products SET price = '549500' WHERE id = '290575'
537 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '415016' ORDER BY sortorder ASC
538 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '415016'
539 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '415016'
540 0.0027 0.0027430057525635
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '415016' AND a.name = n.originalname
541 0.0002 0.00017809867858887
SELECT * FROM productoffers WHERE product_id = '415016' AND merchantid = 'ATVPDKIKX0DER'
542 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '415016' AND price > 0
                ORDER BY price ASC LIMIT 1
543 0.0004 0.00037217140197754
SELECT value FROM productattributes WHERE product_id = '415016' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
544 0.0001 0.00011491775512695
UPDATE products SET price = '8899' WHERE id = '415016'
545 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
546 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '402983'
547 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '402983'
548 0.0022 0.0021998882293701
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
549 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
550 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
551 0.0004 0.00035619735717773
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
552 0.0001 0.00011587142944336
UPDATE products SET price = '10392' WHERE id = '402983'
553 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '247027' ORDER BY sortorder ASC
554 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '247027'
555 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '247027'
556 0.0020 0.0020058155059814
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '247027' AND a.name = n.originalname
557 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '247027' AND merchantid = 'ATVPDKIKX0DER'
558 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '247027' AND price > 0
                ORDER BY price ASC LIMIT 1
559 0.0004 0.00035810470581055
SELECT value FROM productattributes WHERE product_id = '247027' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
560 0.0001 0.00011610984802246
UPDATE products SET price = '1492' WHERE id = '247027'
561 0.0002 0.00019311904907227
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
562 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '406758'
563 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '406758'
564 0.0026 0.0026021003723145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
565 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
566 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
567 0.0004 0.00037813186645508
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
568 0.0001 0.00012803077697754
UPDATE products SET price = '2694' WHERE id = '406758'
569 0.0002 0.00016498565673828
SELECT * FROM productimages WHERE product_id = '398823' ORDER BY sortorder ASC
570 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '398823'
571 0.0001 0.00011587142944336
SELECT * FROM productcustomimages WHERE product_id = '398823'
572 0.0030 0.003000020980835
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398823' AND a.name = n.originalname
573 0.0002 0.00017690658569336
SELECT * FROM productoffers WHERE product_id = '398823' AND merchantid = 'ATVPDKIKX0DER'
574 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '398823' AND price > 0
                ORDER BY price ASC LIMIT 1
575 0.0003 0.0003359317779541
SELECT value FROM productattributes WHERE product_id = '398823' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
576 0.0001 0.00011706352233887
UPDATE products SET price = '2147' WHERE id = '398823'
577 0.0314 0.031385183334351
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 o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
578 0.0002 0.00020098686218262
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1561544045;s:8:\"products\";a:6:{i:16;s:6:\"408078\";i:17;s:6:\"131163\";i:3;s:6:\"290575\";i:4;s:6:\"171938\";i:12;s:6:\"247027\";i:18;s:6:\"410949\";}}' WHERE id = '177'
579 0.0004 0.00042295455932617
SELECT * FROM products WHERE id IN (408078,131163,290575,171938,247027,410949) ORDER BY FIELD(id, 408078,131163,290575,171938,247027,410949 )
580 0.0002 0.00022983551025391
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
581 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '408078'
582 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '408078'
583 0.0024 0.0024278163909912
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
584 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
585 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
586 0.0003 0.00033688545227051
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
587 0.0001 0.00011587142944336
UPDATE products SET price = '24109' WHERE id = '408078'
588 0.0002 0.00023198127746582
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
589 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '131163'
590 0.0001 0.00011682510375977
SELECT * FROM productcustomimages WHERE product_id = '131163'
591 0.0026 0.0025639533996582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
592 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
593 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
594 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
595 0.0001 0.00011897087097168
UPDATE products SET price = '20362' WHERE id = '131163'
596 0.0006 0.00057101249694824
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
597 0.0002 0.00023889541625977
SELECT * FROM product_image_select WHERE product_id = '290575'
598 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '290575'
599 0.0034 0.0034079551696777
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
600 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
601 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
602 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
603 0.0001 0.00011610984802246
UPDATE products SET price = '549500' WHERE id = '290575'
604 0.0006 0.00061392784118652
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
605 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '171938'
606 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '171938'
607 0.0025 0.0025050640106201
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
608 0.0002 0.00017809867858887
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
609 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
610 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
611 0.0001 0.00011682510375977
UPDATE products SET price = '388900' WHERE id = '171938'
612 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '247027' ORDER BY sortorder ASC
613 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '247027'
614 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '247027'
615 0.0020 0.0020267963409424
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '247027' AND a.name = n.originalname
616 0.0002 0.00017881393432617
SELECT * FROM productoffers WHERE product_id = '247027' AND merchantid = 'ATVPDKIKX0DER'
617 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '247027' AND price > 0
                ORDER BY price ASC LIMIT 1
618 0.0004 0.0003659725189209
SELECT value FROM productattributes WHERE product_id = '247027' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
619 0.0001 0.00011801719665527
UPDATE products SET price = '1492' WHERE id = '247027'
620 0.0002 0.00016593933105469
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
621 0.0002 0.00022077560424805
SELECT * FROM product_image_select WHERE product_id = '410949'
622 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '410949'
623 0.0026 0.0026359558105469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
624 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
625 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
626 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
627 0.0001 0.00011610984802246
UPDATE products SET price = '47995' WHERE id = '410949'
628 0.0814 0.081374883651733
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 (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 p.title DESC LIMIT 24
629 0.0003 0.0002589225769043
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"categories\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1561544045;s:8:\"products\";a:6:{i:4;s:6:\"171938\";i:10;s:6:\"414825\";i:16;s:6:\"408078\";i:17;s:6:\"131163\";i:6;s:6:\"410950\";i:9;s:6:\"402983\";}}' WHERE id = '181'
630 0.0004 0.00044608116149902
SELECT * FROM products WHERE id IN (171938,414825,408078,131163,410950,402983) ORDER BY FIELD(id, 171938,414825,408078,131163,410950,402983 )
631 0.0006 0.00061893463134766
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
632 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '171938'
633 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '171938'
634 0.0025 0.0025370121002197
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
635 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
636 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
637 0.0004 0.00038480758666992
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
638 0.0001 0.00011897087097168
UPDATE products SET price = '388900' WHERE id = '171938'
639 0.0002 0.0001981258392334
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
640 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '414825'
641 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414825'
642 0.0020 0.0020179748535156
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
643 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
644 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
645 0.0004 0.00037002563476562
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
646 0.0001 0.00011801719665527
UPDATE products SET price = '11999' WHERE id = '414825'
647 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
648 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '408078'
649 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '408078'
650 0.0024 0.0023970603942871
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
651 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
652 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
653 0.0003 0.0003361701965332
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
654 0.0001 0.00011897087097168
UPDATE products SET price = '24109' WHERE id = '408078'
655 0.0002 0.0002129077911377
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
656 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '131163'
657 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '131163'
658 0.0026 0.0025570392608643
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
659 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
660 0.0002 0.00021219253540039
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
661 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
662 0.0001 0.00011801719665527
UPDATE products SET price = '20362' WHERE id = '131163'
663 0.0002 0.0002439022064209
SELECT * FROM productimages WHERE product_id = '410950' ORDER BY sortorder ASC
664 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '410950'
665 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '410950'
666 0.0031 0.0030739307403564
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410950' AND a.name = n.originalname
667 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '410950' AND merchantid = 'ATVPDKIKX0DER'
668 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '410950' AND price > 0
                ORDER BY price ASC LIMIT 1
669 0.0004 0.00042390823364258
SELECT value FROM productattributes WHERE product_id = '410950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
670 0.0001 0.00011706352233887
UPDATE products SET price = '399999' WHERE id = '410950'
671 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
672 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '402983'
673 0.0001 0.00011682510375977
SELECT * FROM productcustomimages WHERE product_id = '402983'
674 0.0022 0.002202033996582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
675 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
676 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
677 0.0003 0.00034213066101074
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
678 0.0001 0.00011706352233887
UPDATE products SET price = '10392' WHERE id = '402983'
679 0.0809 0.080889940261841
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 (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 p.title DESC LIMIT 24
680 0.0003 0.0002591609954834
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1561544045;s:8:\"products\";a:6:{i:9;s:6:\"402983\";i:13;s:6:\"406758\";i:16;s:6:\"408078\";i:21;s:6:\"404868\";i:12;s:6:\"247027\";i:15;s:6:\"407620\";}}' WHERE id = '183'
681 0.0005 0.00045895576477051
SELECT * FROM products WHERE id IN (402983,406758,408078,404868,247027,407620) ORDER BY FIELD(id, 402983,406758,408078,404868,247027,407620 )
682 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
683 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '402983'
684 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '402983'
685 0.0022 0.0022189617156982
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
686 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
687 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
688 0.0004 0.00035190582275391
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
689 0.0001 0.00012397766113281
UPDATE products SET price = '10392' WHERE id = '402983'
690 0.0002 0.00018310546875
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
691 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '406758'
692 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '406758'
693 0.0026 0.0025730133056641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
694 0.0002 0.00018882751464844
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
695 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
696 0.0004 0.00037980079650879
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
697 0.0001 0.00011587142944336
UPDATE products SET price = '2694' WHERE id = '406758'
698 0.0002 0.00020480155944824
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
699 0.0002 0.00021719932556152
SELECT * FROM product_image_select WHERE product_id = '408078'
700 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '408078'
701 0.0024 0.0024039745330811
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
702 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
703 0.0002 0.00019216537475586
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
704 0.0003 0.00032901763916016
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
705 0.0001 0.00011396408081055
UPDATE products SET price = '24109' WHERE id = '408078'
706 0.0003 0.00029516220092773
SELECT * FROM productimages WHERE product_id = '404868' ORDER BY sortorder ASC
707 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '404868'
708 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '404868'
709 0.0030 0.0029799938201904
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404868' AND a.name = n.originalname
710 0.0002 0.00017809867858887
SELECT * FROM productoffers WHERE product_id = '404868' AND merchantid = 'ATVPDKIKX0DER'
711 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '404868' AND price > 0
                ORDER BY price ASC LIMIT 1
712 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '404868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
713 0.0001 0.00011920928955078
UPDATE products SET price = '44899' WHERE id = '404868'
714 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '247027' ORDER BY sortorder ASC
715 0.0002 0.00020718574523926
SELECT * FROM product_image_select WHERE product_id = '247027'
716 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '247027'
717 0.0020 0.0020139217376709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '247027' AND a.name = n.originalname
718 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '247027' AND merchantid = 'ATVPDKIKX0DER'
719 0.0002 0.00019121170043945
SELECT * FROM productoffers
                WHERE product_id = '247027' AND price > 0
                ORDER BY price ASC LIMIT 1
720 0.0004 0.00036001205444336
SELECT value FROM productattributes WHERE product_id = '247027' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
721 0.0001 0.00012898445129395
UPDATE products SET price = '1492' WHERE id = '247027'
722 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
723 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '407620'
724 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '407620'
725 0.0023 0.0022671222686768
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
726 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
727 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
728 0.0004 0.00036787986755371
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
729 0.0001 0.0001227855682373
UPDATE products SET price = '20323' WHERE id = '407620'
730 0.0004 0.00039792060852051
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
731 0.0001 0.00012898445129395
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
732 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
733 0.0001 0.00011682510375977
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
734 0.0001 0.00011491775512695
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
735 0.0004 0.00038695335388184
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
736 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
737 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
738 0.0001 0.00011420249938965
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
739 0.0009 0.00091004371643066
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
740 0.0003 0.00030112266540527
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
741 0.0003 0.00027990341186523
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
742 0.0004 0.00041103363037109
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
743 0.0003 0.00032305717468262
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'