Tactical Equipment - Survivalist Equipment

Laser Rangefinder, Fnova Digital Hunting Range Finder Ranging 5-600 Yards, +/- 1 Yard Accuracy, 6X Magnification Lens with Distance and Speed Measurement for Racing, Archery, Engineering Survey by Fnova

Price: Click Button for Price
Product prices and availability are accurate as of 2019-07-16 16:22:14 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: Not Available Discontinued
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

Our Combat Gear shop is happy to stock the beneficial Laser Rangefinder, Fnova Digital Hunting Range Finder Ranging 5-600 Yards, +/- 1 Yard Accuracy, 6X Magnification Lens with Distance and Speed Measurement for Racing, Archery, Engineering Survey today at this limited price.

With so many competing tactical, combat and survival products on offer currently, it is great to have a name that you can recognize. The Laser Rangefinder, Fnova Digital Hunting Range Finder Ranging 5-600 Yards, +/- 1 Yard Accuracy, 6X Magnification Lens with Distance and Speed Measurement for Racing, Archery, Engineering Survey is certainly all that and will be a sound buy for your combat kit or tactical ability.

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

For this reduced price, the Laser Rangefinder, Fnova Digital Hunting Range Finder Ranging 5-600 Yards, +/- 1 Yard Accuracy, 6X Magnification Lens with Distance and Speed Measurement for Racing, Archery, Engineering Survey is greatly recommended and is a popular choice with most like minded people. Fnova have provided some excellent touches and this means good value for money.

Manufacturer Description

Shopping for a rangefinder is not the simplest thing for a golfer considering that there are many choices to select from, and each one declares to be the best.
If you desire something that will save you a lot of cash and still provide you precision, efficiency and adaptability, then the Fnova Hunting Rangefinder is what you require to buy.

Why should I buy a Fnova rangefinder for hunting?

Advanced innovation style for Laser Rangefinder
3rd generation imported chip makes the arithmetic speed increasing by 60% and the precision by 50%, the efficiency is extremely stable throughout usage.

Long distance varying scope and High precision measuring
With 6X Magnification and 6x 22mm unbiased lens, varying up to 5-600 backyards, +/- 1 Yard Accuracy, Speed measuring variety is 20-300km/ h.

Lightweight and Portable
Portable size of4.72 x 3.15 x 1.97 in and weight0.52 lb, which is ideal for carrying while hunting, shooting, racing, archery or for measuring and surveying without additional weight or bulk!

In-depth Specifications of Laser Range Finder:
* Brand: Fnova
* Magnification: 7X
* Objective Lens: 22mm
* Maximum Distance Range: 600m/ 600 backyards
* Minimum Distance Range: 5m/ 5 backyards
* Speed Range: 20-300km/ h
* Accuracy: ± 1m
* Field Angle: 7.5 ° * Wave Length: 905nm Class I
* Battery Type: 2 * AAA (not consisted of)
* Item Size: 120 * 80 * 50mm/ 4.72 * 3.15 * 1.97 in
* Item Weight: 236g/ 0.52 lb
* Operating Temperature: 0-50 ? (32-122 ?)

The Fnova laser rangefinder has actually won first place as the leading fundamental and entry level rangefinder since it has everything you require at such a wallet-friendly price.

Product Features

Laser technology for advanced optical observation system: The laser rangefinder has adopted the 3rd generation imported chip, which makes the arithmetic speed increasing by 60% and the accuracy by 50%, the performance is highly stable during use. Long distance ranging scope and High accuracy measuring: With 7X Magnification and 7x 22mm objective lens, the hunting laser rangefinder is measuring range up to 5-600 yards, +/- 1 Yard Accuracy. and the measuring range of speed is 20-300km/h. Lightweight and Portable:The hand held rangefinder has a mini size of4.72 x 3.15 x 1.97in and weighs just0.52 lb.With pocket-sized body, the laser rangefinder is perfect for carrying while hunting, shooting, racing, archery or for measuring and surveying without extra weight or bulk! Durable Material and Excellent Quality: Our laser measure is designed with a durable body which is perfect for carrying while hunting, and for measuring and surveying easier. The original Fnova Golf Laser Rangefinder, a more powerful compact rangefinder made of high quality materials and water resistant body. Ease of use and budget-friendly: 2 buttons operation for easy use, and compact ergonomic design that is easy to grip; Besides the rangefinder, the package also includes 1* carrying case, 1* wrist strap, 1* cleaning cloth, and 1*safety clasp; 2-year warranty.

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.330502986908 765 1.1987 0


No Amazon API Requests Made.


App Debug - Total Time 2.330502986908 seconds

Number Time From Start Name Description
1 0.45110511779785 Initialise Initialise FSB Function
2 0.46237206459045 App Controller Start Start of the App controller (called before the controller of every page)
3 0.47427606582642 Start of getCategoryListByGroup Function Before first category groups query
4 0.47444915771484 After initial query Before first category groups query
5 0.47445106506348 Get Category List for Group Before the call to getCategoryList function
6 0.47445702552795 Start of GetCategoryList function Start of the function
7 0.4744610786438 Before getting categories Query to get specific category list
8 0.4750919342041 After getting categories Query to get specific category list
9 0.475093126297 Before getting category custom Before call to function getCategoryCustom
10 0.47699403762817 After getting category custom After call to function getCategoryCustom
11 0.47699594497681 Before getting category custom Before call to function getCategoryCustom
12 0.48760509490967 After getting category custom After call to function getCategoryCustom
13 0.48760914802551 Before getting category custom Before call to function getCategoryCustom
14 0.4931640625 After getting category custom After call to function getCategoryCustom
15 0.49316692352295 Before getting category custom Before call to function getCategoryCustom
16 0.49728393554688 After getting category custom After call to function getCategoryCustom
17 0.4972870349884 End of GetCategoryList function End of the function
18 0.49729800224304 Get Category List for Group Before the call to getCategoryList function
19 0.49730110168457 Start of GetCategoryList function Start of the function
20 0.49730396270752 Before getting categories Query to get specific category list
21 0.49774408340454 After getting categories Query to get specific category list
22 0.49774503707886 Before getting category custom Before call to function getCategoryCustom
23 0.50332093238831 After getting category custom After call to function getCategoryCustom
24 0.50332403182983 Before getting category custom Before call to function getCategoryCustom
25 0.51407814025879 After getting category custom After call to function getCategoryCustom
26 0.51408004760742 End of GetCategoryList function End of the function
27 0.51408910751343 Get Category List for Group Before the call to getCategoryList function
28 0.51409196853638 Start of GetCategoryList function Start of the function
29 0.51409602165222 Before getting categories Query to get specific category list
30 0.51494693756104 After getting categories Query to get specific category list
31 0.51494908332825 Before getting category custom Before call to function getCategoryCustom
32 0.52418112754822 After getting category custom After call to function getCategoryCustom
33 0.52418398857117 Before getting category custom Before call to function getCategoryCustom
34 0.54190397262573 After getting category custom After call to function getCategoryCustom
35 0.54190707206726 Before getting category custom Before call to function getCategoryCustom
36 0.54778504371643 After getting category custom After call to function getCategoryCustom
37 0.54778814315796 Before getting category custom Before call to function getCategoryCustom
38 0.55385613441467 After getting category custom After call to function getCategoryCustom
39 0.55385994911194 Before getting category custom Before call to function getCategoryCustom
40 0.56015396118164 After getting category custom After call to function getCategoryCustom
41 0.56015801429749 Before getting category custom Before call to function getCategoryCustom
42 0.58214402198792 After getting category custom After call to function getCategoryCustom
43 0.58214807510376 Before getting category custom Before call to function getCategoryCustom
44 0.58630299568176 After getting category custom After call to function getCategoryCustom
45 0.58630609512329 Before getting category custom Before call to function getCategoryCustom
46 0.59120893478394 After getting category custom After call to function getCategoryCustom
47 0.59121203422546 End of GetCategoryList function End of the function
48 0.59122800827026 Get Category List for Group Before the call to getCategoryList function
49 0.59123110771179 Start of GetCategoryList function Start of the function
50 0.59123396873474 Before getting categories Query to get specific category list
51 0.59166193008423 After getting categories Query to get specific category list
52 0.59166312217712 Before getting category custom Before call to function getCategoryCustom
53 0.59396409988403 After getting category custom After call to function getCategoryCustom
54 0.59396600723267 Before getting category custom Before call to function getCategoryCustom
55 0.59624314308167 After getting category custom After call to function getCategoryCustom
56 0.5962450504303 End of GetCategoryList function End of the function
57 0.59625101089478 Get Category List for Group Before the call to getCategoryList function
58 0.59625315666199 Start of GetCategoryList function Start of the function
59 0.59625601768494 Before getting categories Query to get specific category list
60 0.59657192230225 After getting categories Query to get specific category list
61 0.59657311439514 Before getting category custom Before call to function getCategoryCustom
62 0.6015191078186 After getting category custom After call to function getCategoryCustom
63 0.60152101516724 End of GetCategoryList function End of the function
64 0.60152792930603 End of getCategoryListByGroup Function Before return()
65 0.65414714813232 App Controller End End of the App controller (called before the controller of every page)
66 0.65478014945984 Product Start Start of the product info controller
67 0.65563106536865 Cache file not found Starting get product details
68 0.74544310569763 Related products Start getting related products if enabled
69 0.74544501304626 Related Products Start Before the related products are found
70 0.74544596672058 Related Products Keywords Before the related product keywords are found
71 0.74545812606812 Create Keyword List Function Start of function
72 0.74782514572144 Create Keyword List Function After looping provided content - 1299 keywords found
73 0.83314299583435 Create Keyword List Function After looping initial keyword list - 1217 keywords remaining
74 0.8334801197052 Create Keyword List Function After reducing keyword list
75 0.83478808403015 Create Keyword List Function After selecting by scoring keywords
76 0.83479404449463 Create Keyword List Function After final loop of keywords
77 0.83479595184326 Related Products Keywords After the related product keywords are found
78 1.1139559745789 Related Products End After the related products are found
79 1.331670999527 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 1.4709961414337 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 1.7323310375214 Product End End of the product info controller (Product Info)
82 1.7327470779419 App_after Controller Start Start of the App_after controller (called after the controller of every page)
83 1.732871055603 Before Get Options Before the call to getOptions in the tpl class
84 1.9147169589996 After Get Options After the call to getOptions in the tpl class
85 1.9149651527405 App_after Controller End End of the App_after controller (called after the controller of every page)
86 1.9149780273438 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
87 2.1242289543152 Product Info: After Smarty Fetch After the product.tpl template is fetched
88 2.1242380142212 Product Info: Before Template Display Before the template is displayed
89 2.3304541110992 Product Info: After Template Display After the template is displayed
90 2.330461025238 Finalizing debug Before the debug is output to the page.
91 2.3305020332336 End of App This is the end of the app logging, final timestamp


Query Debug - 765 Database Queries. Total time 1.1987 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00017094612121582
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0006 0.00055694580078125
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00021481513977051
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00016689300537109
SELECT * FROM `bad_bots`
5 0.0005 0.00053310394287109
SELECT parameter, value FROM parameters
6 0.0002 0.00018978118896484
SET time_zone = 'Europe/London'
7 0.0003 0.00034403800964355
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014710426330566
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00011110305786133
delete from cachefiles
10 0.0003 0.00034999847412109
SELECT id FROM pages WHERE pagename = 'laser-rangefinder-fnova-digital-hunting-range-finder-ranging-5-600-yards-1-yard-accuracy-6x-magnification-lens-with-distance-and-speed-measurement-for-racing-archery-engineering-survey-1553398908' LIMIT 1
11 0.0003 0.00025820732116699
SELECT id FROM products WHERE pagename = 'laser-rangefinder-fnova-digital-hunting-range-finder-ranging-5-600-yards-1-yard-accuracy-6x-magnification-lens-with-distance-and-speed-measurement-for-racing-archery-engineering-survey-1553398908' AND hidden = 0 LIMIT 1
12 0.0008 0.00080204010009766
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0094 0.0094442367553711
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00029397010803223
SELECT * FROM pages WHERE pagename = 'laser-rangefinder-fnova-digital-hunting-range-finder-ranging-5-600-yards-1-yard-accuracy-6x-magnification-lens-with-distance-and-speed-measurement-for-racing-archery-engineering-survey-1553398908'
15 0.0002 0.00015711784362793
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.0005340576171875
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00049209594726562
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.00022602081298828
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.00046586990356445
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.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 (49)
				  AND p.disabled = 0 
21 0.0001 0.00014901161193848
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.00017118453979492
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00013518333435059
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0030100345611572
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.00027704238891602
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0002129077911377
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0056581497192383
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.00020289421081543
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.00015997886657715
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.00017881393432617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012898445129395
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0022940635681152
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.00027680397033691
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0023069381713867
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.0001 0.00014805793762207
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.0001 0.00014519691467285
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.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '1'
42 0.0011 0.0011420249938965
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.00025105476379395
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0018091201782227
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.00015401840209961
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.00015807151794434
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.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00040483474731445
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0023097991943359
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.00025391578674316
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0022990703582764
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.00016212463378906
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.00015687942504883
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.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.004849910736084
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.00030303001403809
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.004849910736084
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.00017309188842773
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.00015401840209961
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00066614151000977
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0041341781616211
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.00026988983154297
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0040948390960693
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.00016522407531738
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.00015091896057129
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.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '10'
73 0.0083 0.00826096534729
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.00033378601074219
SELECT id FROM categories WHERE parent_id = '65'
75 0.0084 0.0083560943603516
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.00017905235290527
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.0001518726348877
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.00017380714416504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '10'
80 0.0024 0.0024449825286865
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.00027990341186523
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024600028991699
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.00015592575073242
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.0001 0.00014400482177734
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.00015687942504883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
87 0.0026 0.0025749206542969
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.00028085708618164
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0025091171264648
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.00015902519226074
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.0001 0.00014996528625488
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.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '10'
94 0.0023 0.0022690296173096
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.00027585029602051
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020503997802734
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0028219223022461
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.00015997886657715
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.0001521110534668
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.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '10'
102 0.0095 0.0095148086547852
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.00033783912658691
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '130'
109 0.0102 0.010240077972412
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.00020503997802734
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.00016283988952637
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.00020384788513184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '10'
114 0.0016 0.0015819072723389
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.00029182434082031
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015888214111328
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.00015592575073242
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.0001530647277832
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.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
121 0.0020 0.0019721984863281
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.00026392936706543
SELECT id FROM categories WHERE parent_id = '89'
123 0.0020 0.0019721984863281
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.0001 0.00014996528625488
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.0001 0.00014519691467285
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.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00038290023803711
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00069594383239746
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.00023198127746582
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00069713592529297
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.00014305114746094
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.0001 0.00014305114746094
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.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00013208389282227
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00067901611328125
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.00023388862609863
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00069999694824219
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.00014209747314453
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.00015091896057129
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.00015401840209961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00030207633972168
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0020120143890381
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.0002 0.00024104118347168
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020179748535156
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.00015020370483398
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.0001 0.00014495849609375
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.0001 0.00014805793762207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '20'
151 0.0052 0.005220890045166
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00040292739868164
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0003 0.00025796890258789
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.0001680850982666
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00020313262939453
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '457'
172 0.0003 0.00025415420532227
SELECT * FROM pages WHERE id = '458'
173 0.0003 0.00031805038452148
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00023508071899414
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00018620491027832
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '217'
187 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '271'
190 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '286'
191 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '364'
198 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018882751464844
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00017714500427246
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00028896331787109
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '90'
206 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '150'
211 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '411'
220 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00018882751464844
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014615058898926
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '137'
249 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '367'
258 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016212463378906
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00021815299987793
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '343'
282 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00020313262939453
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '392'
289 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '394'
291 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '451'
302 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00014019012451172
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '181'
313 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '299'
315 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = '385'
318 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00023794174194336
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00015902519226074
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '200'
339 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014305114746094
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00013422966003418
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '420'
368 0.0002 0.0001518726348877
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00012898445129395
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011777877807617
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0015 0.00148606300354
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00018787384033203
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.0001218318939209
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00030517578125
SELECT * FROM products WHERE pagename = 'laser-rangefinder-fnova-digital-hunting-range-finder-ranging-5-600-yards-1-yard-accuracy-6x-magnification-lens-with-distance-and-speed-measurement-for-racing-archery-engineering-survey-1553398908'
376 0.0002 0.00021600723266602
SELECT * FROM manufacturers WHERE id = '8150'
377 0.0003 0.00030803680419922
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '8150'
378 0.0001 0.00011897087097168
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '8150' LIMIT 1
379 0.0002 0.00024604797363281
SELECT pagename, id FROM products p WHERE manufacturer_id = '8150' ORDER BY RAND() LIMIT 1
380 0.0003 0.00029110908508301
SELECT * FROM productimages WHERE product_id = '411419' ORDER BY sortorder ASC
381 0.0002 0.00023484230041504
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '8150'
382 0.0003 0.00026392936706543
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '8150'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00011706352233887
SELECT * FROM manufacturerimages WHERE manufacturer_id = '8150'
384 0.0001 0.00013089179992676
SELECT category_id FROM products_categories WHERE product_id = '412384'
385 0.0002 0.00020289421081543
SELECT * FROM categories WHERE id = '65'
386 0.0084 0.0083868503570557
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
387 0.0002 0.00017189979553223
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 65
388 0.0003 0.00028204917907715
SELECT id FROM categories WHERE parent_id = '65'
389 0.0083 0.0083210468292236
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 
390 0.0002 0.00018405914306641
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 
391 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 (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
392 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
393 0.0002 0.00023412704467773
SELECT * FROM productimages WHERE product_id = '412384' ORDER BY sortorder ASC
394 0.0002 0.00021195411682129
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '412384' AND p.id = pi.product_id ORDER BY pi.sortorder
395 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '412384'
396 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '412384'
397 0.0001 0.0001218318939209
SELECT * FROM productfeeds WHERE product_id = '412384' ORDER BY item_date DESC
398 0.0003 0.0003352165222168
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '412384' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
399 0.0005 0.00053501129150391
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '412384' AND t.hidden = 0 AND display_product = 1
400 0.0002 0.0002129077911377
SELECT * FROM tags WHERE id = '4188'
401 0.0025 0.002493143081665
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '4188'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
402 0.0024 0.0023579597473145
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '4188'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
403 0.0024 0.0024130344390869
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '4188' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
404 0.0003 0.00026106834411621
SELECT * FROM productimages WHERE product_id = '414275' ORDER BY sortorder ASC
405 0.0547 0.054672002792358
SELECT * FROM productamazoncontent WHERE product_id = '412384'
406 0.0004 0.00039005279541016
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '412384'
                GROUP BY o.product_id
407 0.0002 0.00024986267089844
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '412384'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
408 0.0002 0.00018310546875
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 412384
409 0.0022 0.0021641254425049
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412384' AND a.name = n.originalname
410 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '412384' AND merchantid = 'ATVPDKIKX0DER'
411 0.0002 0.00018501281738281
SELECT * FROM productoffers
                WHERE product_id = '412384' AND price > 0
                ORDER BY price ASC LIMIT 1
412 0.0002 0.00017094612121582
SELECT * FROM productoffers
                WHERE product_id = 412384
                ORDER BY price ASC LIMIT 1
413 0.0002 0.00023603439331055
SELECT value FROM productattributes
                WHERE product_id = '412384'
                AND name = 'ListPriceAmount'
414 0.0002 0.00020289421081543
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '412384'
                GROUP BY o.product_id
415 0.0002 0.00022387504577637
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '412384'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
416 0.0002 0.00017094612121582
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 412384
417 0.0003 0.00034689903259277
SELECT value FROM productattributes WHERE product_id = '412384' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
418 0.0002 0.00019192695617676
SELECT * FROM products WHERE parent_id = '412384'
419 0.2347 0.23466610908508
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('rangefinder' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('rangefinder' IN BOOLEAN MODE) AND 412384 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
420 0.0004 0.00043797492980957
SELECT * FROM productimages WHERE product_id = '273525' ORDER BY sortorder ASC
421 0.0004 0.00035619735717773
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '273525' AND p.id = pi.product_id ORDER BY pi.sortorder
422 0.0002 0.00023579597473145
SELECT * FROM product_image_select WHERE product_id = '273525'
423 0.0002 0.00015091896057129
SELECT * FROM productcustomimages WHERE product_id = '273525'
424 0.0003 0.00027084350585938
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '273525'
                GROUP BY o.product_id
425 0.0003 0.00030708312988281
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '273525'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
426 0.0002 0.00021910667419434
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 273525
427 0.0022 0.0022070407867432
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '273525' AND a.name = n.originalname
428 0.0002 0.00019979476928711
SELECT * FROM productoffers WHERE product_id = '273525' AND merchantid = 'ATVPDKIKX0DER'
429 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '273525' AND price > 0
                ORDER BY price ASC LIMIT 1
430 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = 273525
                ORDER BY price ASC LIMIT 1
431 0.0003 0.00026988983154297
SELECT value FROM productattributes
                WHERE product_id = '273525'
                AND name = 'ListPriceAmount'
432 0.0003 0.0002591609954834
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '273525'
                GROUP BY o.product_id
433 0.0003 0.00029611587524414
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '273525'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
434 0.0002 0.00021886825561523
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 273525
435 0.0004 0.00040793418884277
SELECT value FROM productattributes WHERE product_id = '273525' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
436 0.0001 0.00014400482177734
UPDATE products SET price = '12199' WHERE id = '273525'
437 0.0003 0.00032901763916016
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '273525'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
438 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '407679' ORDER BY sortorder ASC
439 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '407679'
440 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '407679'
441 0.0031 0.0030860900878906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407679' AND a.name = n.originalname
442 0.0002 0.00020217895507812
SELECT * FROM productoffers WHERE product_id = '407679' AND merchantid = 'ATVPDKIKX0DER'
443 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '407679' AND price > 0
                ORDER BY price ASC LIMIT 1
444 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '407679' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
445 0.0001 0.00014209747314453
UPDATE products SET price = '17995' WHERE id = '407679'
446 0.0002 0.00020813941955566
SELECT * FROM productimages WHERE product_id = '410082' ORDER BY sortorder ASC
447 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '410082'
448 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '410082'
449 0.0032 0.0031669139862061
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410082' AND a.name = n.originalname
450 0.0002 0.00020980834960938
SELECT * FROM productoffers WHERE product_id = '410082' AND merchantid = 'ATVPDKIKX0DER'
451 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '410082' AND price > 0
                ORDER BY price ASC LIMIT 1
452 0.0004 0.00039911270141602
SELECT value FROM productattributes WHERE product_id = '410082' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
453 0.0001 0.00012993812561035
UPDATE products SET price = '9985' WHERE id = '410082'
454 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '412716' ORDER BY sortorder ASC
455 0.0004 0.0003659725189209
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '412716' AND p.id = pi.product_id ORDER BY pi.sortorder
456 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '412716'
457 0.0001 0.00013017654418945
SELECT * FROM productcustomimages WHERE product_id = '412716'
458 0.0003 0.00032186508178711
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '412716'
                GROUP BY o.product_id
459 0.0004 0.00037097930908203
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '412716'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
460 0.0003 0.00029802322387695
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 412716
461 0.0027 0.0026819705963135
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412716' AND a.name = n.originalname
462 0.0002 0.00020790100097656
SELECT * FROM productoffers WHERE product_id = '412716' AND merchantid = 'ATVPDKIKX0DER'
463 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '412716' AND price > 0
                ORDER BY price ASC LIMIT 1
464 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = 412716
                ORDER BY price ASC LIMIT 1
465 0.0003 0.00025606155395508
SELECT value FROM productattributes
                WHERE product_id = '412716'
                AND name = 'ListPriceAmount'
466 0.0003 0.0003209114074707
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '412716'
                GROUP BY o.product_id
467 0.0004 0.00037288665771484
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '412716'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
468 0.0003 0.00028514862060547
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 412716
469 0.0004 0.00041484832763672
SELECT value FROM productattributes WHERE product_id = '412716' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
470 0.0001 0.00013303756713867
UPDATE products SET price = '9500' WHERE id = '412716'
471 0.0004 0.00038695335388184
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '412716'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
472 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '413066' ORDER BY sortorder ASC
473 0.0002 0.00022721290588379
SELECT * FROM product_image_select WHERE product_id = '413066'
474 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '413066'
475 0.0114 0.011356830596924
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413066' AND a.name = n.originalname
476 0.0003 0.0002899169921875
SELECT * FROM productoffers WHERE product_id = '413066' AND merchantid = 'ATVPDKIKX0DER'
477 0.0002 0.00023794174194336
SELECT * FROM productoffers
                WHERE product_id = '413066' AND price > 0
                ORDER BY price ASC LIMIT 1
478 0.0005 0.00046181678771973
SELECT value FROM productattributes WHERE product_id = '413066' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
479 0.0002 0.00016093254089355
UPDATE products SET price = '32694' WHERE id = '413066'
480 0.0003 0.00026392936706543
SELECT * FROM productimages WHERE product_id = '413665' ORDER BY sortorder ASC
481 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '413665'
482 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '413665'
483 0.0040 0.0039560794830322
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413665' AND a.name = n.originalname
484 0.0002 0.00021696090698242
SELECT * FROM productoffers WHERE product_id = '413665' AND merchantid = 'ATVPDKIKX0DER'
485 0.0002 0.00023007392883301
SELECT * FROM productoffers
                WHERE product_id = '413665' AND price > 0
                ORDER BY price ASC LIMIT 1
486 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '413665' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
487 0.0002 0.00015997886657715
UPDATE products SET price = '39999' WHERE id = '413665'
488 0.0002 0.00016188621520996
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
489 0.0001 0.00013279914855957
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
490 0.0002 0.00015401840209961
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
491 0.0001 0.00012898445129395
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
492 0.0001 0.00014495849609375
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
493 0.0001 0.00013303756713867
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
494 0.0001 0.00014686584472656
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
495 0.2154 0.2154278755188
SELECT * FROM ebay_products_cache WHERE cachekey = '8f05f0ccedce1abdd14ae124189ac582' 
496 0.0003 0.00028395652770996
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
497 0.0001 0.00012803077697754
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
498 0.0001 0.00012111663818359
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
499 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
500 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
501 0.2161 0.21613192558289
SELECT * FROM ebay_products_cache WHERE cachekey = '8f05f0ccedce1abdd14ae124189ac582' 
502 0.0003 0.00028705596923828
SELECT id,asin FROM products WHERE parent_id = 412384
503 0.0003 0.00034499168395996
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '412384' ORDER BY timestamp DESC
504 0.0001 0.00014591217041016
SELECT category_id FROM products_categories WHERE product_id = '412384'
505 0.0002 0.00018882751464844
SELECT * FROM categories WHERE id = '65'
506 0.0084 0.0083658695220947
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
507 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 65
508 0.0003 0.00028085708618164
SELECT id FROM categories WHERE parent_id = '65'
509 0.0085 0.0084869861602783
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 
510 0.0002 0.00023388862609863
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 
511 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 (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
512 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
513 0.0022 0.0021648406982422
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412384' AND a.name = n.originalname
514 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '412384' AND merchantid = 'ATVPDKIKX0DER'
515 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '412384' AND price > 0
                ORDER BY price ASC LIMIT 1
516 0.0002 0.00016212463378906
SELECT * FROM productoffers
                WHERE product_id = 412384
                ORDER BY price ASC LIMIT 1
517 0.0002 0.00023603439331055
SELECT value FROM productattributes
                WHERE product_id = '412384'
                AND name = 'ListPriceAmount'
518 0.0002 0.00022006034851074
SELECT * FROM products WHERE id = '412384'
519 0.0002 0.00022602081298828
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '412384'
                GROUP BY o.product_id
520 0.0002 0.00023698806762695
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '412384'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
521 0.0002 0.00017499923706055
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 412384
522 0.0003 0.00033807754516602
SELECT value FROM productattributes WHERE product_id = '412384' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
523 0.0021 0.0021159648895264
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412384' AND a.name = n.originalname
524 0.0002 0.00017404556274414
SELECT * FROM productoffers WHERE product_id = '412384' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '412384' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 412384
                ORDER BY price ASC LIMIT 1
527 0.0002 0.00022602081298828
SELECT value FROM productattributes
                WHERE product_id = '412384'
                AND name = 'ListPriceAmount'
528 0.0002 0.00017213821411133
SELECT category_id FROM products_categories WHERE product_id = '412384'
529 0.0001 0.00014996528625488
SELECT parent_id FROM categories WHERE id = '65'
530 0.0002 0.00018692016601562
SELECT * FROM categories WHERE id = '65'
531 0.0083 0.0082888603210449
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
532 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 65
533 0.0003 0.00031113624572754
SELECT id FROM categories WHERE parent_id = '65'
534 0.0085 0.0084671974182129
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 
535 0.0002 0.00020098686218262
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 
536 0.0002 0.00017499923706055
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 
537 0.0002 0.00020384788513184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
538 0.0002 0.00019407272338867
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
539 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = 2
540 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = 4
541 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = 12
542 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = 10
543 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = 7
544 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = 18
545 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = 28
546 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = 13
547 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = 3
548 0.0082 0.0081689357757568
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
549 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:1563302810;s:8:\"products\";a:6:{i:2;s:6:\"406156\";i:14;s:6:\"407551\";i:15;s:6:\"413295\";i:16;s:6:\"143805\";i:18;s:6:\"263829\";i:8;s:6:\"411042\";}}' WHERE id = '175'
550 0.0005 0.00046992301940918
SELECT * FROM products WHERE id IN (406156,407551,413295,143805,263829,411042) ORDER BY FIELD(id, 406156,407551,413295,143805,263829,411042 )
551 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '406156' ORDER BY sortorder ASC
552 0.0002 0.0002281665802002
SELECT * FROM product_image_select WHERE product_id = '406156'
553 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '406156'
554 0.0033 0.0033400058746338
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406156' AND a.name = n.originalname
555 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '406156' AND merchantid = 'ATVPDKIKX0DER'
556 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '406156' AND price > 0
                ORDER BY price ASC LIMIT 1
557 0.0005 0.00045084953308105
SELECT value FROM productattributes WHERE product_id = '406156' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
558 0.0001 0.00014519691467285
UPDATE products SET price = '1015' WHERE id = '406156'
559 0.0002 0.00020813941955566
SELECT * FROM productimages WHERE product_id = '407551' ORDER BY sortorder ASC
560 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '407551'
561 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '407551'
562 0.0037 0.0037178993225098
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407551' AND a.name = n.originalname
563 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '407551' AND merchantid = 'ATVPDKIKX0DER'
564 0.0002 0.00022792816162109
SELECT * FROM productoffers
                WHERE product_id = '407551' AND price > 0
                ORDER BY price ASC LIMIT 1
565 0.0005 0.00046205520629883
SELECT value FROM productattributes WHERE product_id = '407551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
566 0.0001 0.00013899803161621
UPDATE products SET price = '10596' WHERE id = '407551'
567 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '413295' ORDER BY sortorder ASC
568 0.0002 0.00024700164794922
SELECT * FROM product_image_select WHERE product_id = '413295'
569 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '413295'
570 0.0023 0.0023207664489746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413295' AND a.name = n.originalname
571 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '413295' AND merchantid = 'ATVPDKIKX0DER'
572 0.0002 0.00023508071899414
SELECT * FROM productoffers
                WHERE product_id = '413295' AND price > 0
                ORDER BY price ASC LIMIT 1
573 0.0004 0.0003821849822998
SELECT value FROM productattributes WHERE product_id = '413295' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
574 0.0001 0.00013399124145508
UPDATE products SET price = '254999' WHERE id = '413295'
575 0.0002 0.00024914741516113
SELECT * FROM productimages WHERE product_id = '143805' ORDER BY sortorder ASC
576 0.0002 0.00022482872009277
SELECT * FROM product_image_select WHERE product_id = '143805'
577 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '143805'
578 0.0022 0.0022120475769043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '143805' AND a.name = n.originalname
579 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '143805' AND merchantid = 'ATVPDKIKX0DER'
580 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '143805' AND price > 0
                ORDER BY price ASC LIMIT 1
581 0.0004 0.00037908554077148
SELECT value FROM productattributes WHERE product_id = '143805' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
582 0.0001 0.00013494491577148
UPDATE products SET price = '10999' WHERE id = '143805'
583 0.0003 0.00027704238891602
SELECT * FROM productimages WHERE product_id = '263829' ORDER BY sortorder ASC
584 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '263829'
585 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '263829'
586 0.0023 0.0022790431976318
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '263829' AND a.name = n.originalname
587 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '263829' AND merchantid = 'ATVPDKIKX0DER'
588 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '263829' AND price > 0
                ORDER BY price ASC LIMIT 1
589 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '263829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
590 0.0001 0.00013399124145508
UPDATE products SET price = '60799' WHERE id = '263829'
591 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '411042' ORDER BY sortorder ASC
592 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '411042'
593 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '411042'
594 0.0025 0.0024940967559814
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411042' AND a.name = n.originalname
595 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '411042' AND merchantid = 'ATVPDKIKX0DER'
596 0.0003 0.00026702880859375
SELECT * FROM productoffers
                WHERE product_id = '411042' AND price > 0
                ORDER BY price ASC LIMIT 1
597 0.0004 0.00044512748718262
SELECT value FROM productattributes WHERE product_id = '411042' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
598 0.0001 0.00013303756713867
UPDATE products SET price = '15892' WHERE id = '411042'
599 0.0082 0.0082001686096191
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
600 0.0002 0.0002448558807373
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:1563302810;s:8:\"products\";a:6:{i:3;s:6:\"407089\";i:5;s:5:\"90837\";i:8;s:6:\"411042\";i:19;s:6:\"264565\";i:20;s:6:\"178036\";i:23;s:6:\"397167\";}}' WHERE id = '177'
601 0.0005 0.00045895576477051
SELECT * FROM products WHERE id IN (407089,90837,411042,264565,178036,397167) ORDER BY FIELD(id, 407089,90837,411042,264565,178036,397167 )
602 0.0003 0.00026392936706543
SELECT * FROM productimages WHERE product_id = '407089' ORDER BY sortorder ASC
603 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '407089'
604 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '407089'
605 0.0034 0.0034480094909668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407089' AND a.name = n.originalname
606 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '407089' AND merchantid = 'ATVPDKIKX0DER'
607 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '407089' AND price > 0
                ORDER BY price ASC LIMIT 1
608 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '407089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
609 0.0001 0.00012302398681641
UPDATE products SET price = '3999' WHERE id = '407089'
610 0.0004 0.00040698051452637
SELECT * FROM productimages WHERE product_id = '90837' ORDER BY sortorder ASC
611 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '90837'
612 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '90837'
613 0.0019 0.0019299983978271
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '90837' AND a.name = n.originalname
614 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '90837' AND merchantid = 'ATVPDKIKX0DER'
615 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '90837' AND price > 0
                ORDER BY price ASC LIMIT 1
616 0.0003 0.00033307075500488
SELECT value FROM productattributes WHERE product_id = '90837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
617 0.0001 0.00011897087097168
UPDATE products SET price = '9999' WHERE id = '90837'
618 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '411042' ORDER BY sortorder ASC
619 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '411042'
620 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '411042'
621 0.0024 0.002357006072998
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411042' AND a.name = n.originalname
622 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '411042' AND merchantid = 'ATVPDKIKX0DER'
623 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '411042' AND price > 0
                ORDER BY price ASC LIMIT 1
624 0.0004 0.00035405158996582
SELECT value FROM productattributes WHERE product_id = '411042' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
625 0.0001 0.00012111663818359
UPDATE products SET price = '15892' WHERE id = '411042'
626 0.0003 0.00033807754516602
SELECT * FROM productimages WHERE product_id = '264565' ORDER BY sortorder ASC
627 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '264565'
628 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '264565'
629 0.0030 0.002971887588501
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '264565' AND a.name = n.originalname
630 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '264565' AND merchantid = 'ATVPDKIKX0DER'
631 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = '264565' AND price > 0
                ORDER BY price ASC LIMIT 1
632 0.0004 0.0003509521484375
SELECT value FROM productattributes WHERE product_id = '264565' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
633 0.0001 0.00012707710266113
UPDATE products SET price = '48849' WHERE id = '264565'
634 0.0003 0.00029206275939941
SELECT * FROM productimages WHERE product_id = '178036' ORDER BY sortorder ASC
635 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '178036'
636 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '178036'
637 0.0028 0.0027568340301514
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '178036' AND a.name = n.originalname
638 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '178036' AND merchantid = 'ATVPDKIKX0DER'
639 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '178036' AND price > 0
                ORDER BY price ASC LIMIT 1
640 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '178036' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
641 0.0001 0.0001370906829834
UPDATE products SET price = '7399' WHERE id = '178036'
642 0.0002 0.00018095970153809
SELECT * FROM productimages WHERE product_id = '397167' ORDER BY sortorder ASC
643 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '397167'
644 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '397167'
645 0.0032 0.0032029151916504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '397167' AND a.name = n.originalname
646 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '397167' AND merchantid = 'ATVPDKIKX0DER'
647 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '397167' AND price > 0
                ORDER BY price ASC LIMIT 1
648 0.0004 0.00042581558227539
SELECT value FROM productattributes WHERE product_id = '397167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
649 0.0001 0.00013494491577148
UPDATE products SET price = '940' WHERE id = '397167'
650 0.0154 0.015351057052612
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
651 0.0003 0.00028800964355469
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:1563302810;s:8:\"products\";a:6:{i:1;s:6:\"410951\";i:10;s:5:\"53240\";i:12;s:6:\"195608\";i:14;s:6:\"407551\";i:22;s:6:\"405719\";i:15;s:6:\"413295\";}}' WHERE id = '181'
652 0.0006 0.00058603286743164
SELECT * FROM products WHERE id IN (410951,53240,195608,407551,405719,413295) ORDER BY FIELD(id, 410951,53240,195608,407551,405719,413295 )
653 0.0003 0.00032782554626465
SELECT * FROM productimages WHERE product_id = '410951' ORDER BY sortorder ASC
654 0.0003 0.00027203559875488
SELECT * FROM product_image_select WHERE product_id = '410951'
655 0.0002 0.00015091896057129
SELECT * FROM productcustomimages WHERE product_id = '410951'
656 0.0027 0.0027401447296143
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410951' AND a.name = n.originalname
657 0.0003 0.00025010108947754
SELECT * FROM productoffers WHERE product_id = '410951' AND merchantid = 'ATVPDKIKX0DER'
658 0.0003 0.00025677680969238
SELECT * FROM productoffers
                WHERE product_id = '410951' AND price > 0
                ORDER BY price ASC LIMIT 1
659 0.0005 0.0004889965057373
SELECT value FROM productattributes WHERE product_id = '410951' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
660 0.0002 0.00016188621520996
UPDATE products SET price = '94700' WHERE id = '410951'
661 0.0002 0.00023198127746582
SELECT * FROM productimages WHERE product_id = '53240' ORDER BY sortorder ASC
662 0.0003 0.00026297569274902
SELECT * FROM product_image_select WHERE product_id = '53240'
663 0.0002 0.00016188621520996
SELECT * FROM productcustomimages WHERE product_id = '53240'
664 0.0030 0.0030031204223633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53240' AND a.name = n.originalname
665 0.0002 0.00023603439331055
SELECT * FROM productoffers WHERE product_id = '53240' AND merchantid = 'ATVPDKIKX0DER'
666 0.0002 0.000244140625
SELECT * FROM productoffers
                WHERE product_id = '53240' AND price > 0
                ORDER BY price ASC LIMIT 1
667 0.0005 0.00048303604125977
SELECT value FROM productattributes WHERE product_id = '53240' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
668 0.0002 0.00015711784362793
UPDATE products SET price = '8199' WHERE id = '53240'
669 0.0004 0.00035500526428223
SELECT * FROM productimages WHERE product_id = '195608' ORDER BY sortorder ASC
670 0.0003 0.00029492378234863
SELECT * FROM product_image_select WHERE product_id = '195608'
671 0.0002 0.00015497207641602
SELECT * FROM productcustomimages WHERE product_id = '195608'
672 0.0023 0.0023479461669922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '195608' AND a.name = n.originalname
673 0.0003 0.00027298927307129
SELECT * FROM productoffers WHERE product_id = '195608' AND merchantid = 'ATVPDKIKX0DER'
674 0.0003 0.00028395652770996
SELECT * FROM productoffers
                WHERE product_id = '195608' AND price > 0
                ORDER BY price ASC LIMIT 1
675 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '195608' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
676 0.0002 0.00015902519226074
UPDATE products SET price = '3995' WHERE id = '195608'
677 0.0002 0.00022697448730469
SELECT * FROM productimages WHERE product_id = '407551' ORDER BY sortorder ASC
678 0.0002 0.00024795532226562
SELECT * FROM product_image_select WHERE product_id = '407551'
679 0.0001 0.00013995170593262
SELECT * FROM productcustomimages WHERE product_id = '407551'
680 0.0049 0.0048768520355225
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407551' AND a.name = n.originalname
681 0.0002 0.00024795532226562
SELECT * FROM productoffers WHERE product_id = '407551' AND merchantid = 'ATVPDKIKX0DER'
682 0.0003 0.00026607513427734
SELECT * FROM productoffers
                WHERE product_id = '407551' AND price > 0
                ORDER BY price ASC LIMIT 1
683 0.0006 0.00058317184448242
SELECT value FROM productattributes WHERE product_id = '407551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
684 0.0002 0.00018596649169922
UPDATE products SET price = '10596' WHERE id = '407551'
685 0.0004 0.00041604042053223
SELECT * FROM productimages WHERE product_id = '405719' ORDER BY sortorder ASC
686 0.0003 0.0002591609954834
SELECT * FROM product_image_select WHERE product_id = '405719'
687 0.0001 0.00014781951904297
SELECT * FROM productcustomimages WHERE product_id = '405719'
688 0.0033 0.0032670497894287
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405719' AND a.name = n.originalname
689 0.0003 0.00025391578674316
SELECT * FROM productoffers WHERE product_id = '405719' AND merchantid = 'ATVPDKIKX0DER'
690 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = '405719' AND price > 0
                ORDER BY price ASC LIMIT 1
691 0.0005 0.00052809715270996
SELECT value FROM productattributes WHERE product_id = '405719' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
692 0.0002 0.0001680850982666
UPDATE products SET price = '36200' WHERE id = '405719'
693 0.0002 0.00022602081298828
SELECT * FROM productimages WHERE product_id = '413295' ORDER BY sortorder ASC
694 0.0003 0.00026988983154297
SELECT * FROM product_image_select WHERE product_id = '413295'
695 0.0002 0.0001530647277832
SELECT * FROM productcustomimages WHERE product_id = '413295'
696 0.0030 0.0029799938201904
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413295' AND a.name = n.originalname
697 0.0002 0.00024700164794922
SELECT * FROM productoffers WHERE product_id = '413295' AND merchantid = 'ATVPDKIKX0DER'
698 0.0002 0.0002439022064209
SELECT * FROM productoffers
                WHERE product_id = '413295' AND price > 0
                ORDER BY price ASC LIMIT 1
699 0.0005 0.00047802925109863
SELECT value FROM productattributes WHERE product_id = '413295' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
700 0.0002 0.00015497207641602
UPDATE products SET price = '254999' WHERE id = '413295'
701 0.0173 0.017279148101807
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
702 0.0003 0.00029778480529785
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:1563302811;s:8:\"products\";a:6:{i:0;s:6:\"147874\";i:3;s:6:\"407089\";i:10;s:5:\"53240\";i:14;s:6:\"407551\";i:15;s:6:\"413295\";i:16;s:6:\"143805\";}}' WHERE id = '183'
703 0.0005 0.00053501129150391
SELECT * FROM products WHERE id IN (147874,407089,53240,407551,413295,143805) ORDER BY FIELD(id, 147874,407089,53240,407551,413295,143805 )
704 0.0003 0.00026106834411621
SELECT * FROM productimages WHERE product_id = '147874' ORDER BY sortorder ASC
705 0.0003 0.00026297569274902
SELECT * FROM product_image_select WHERE product_id = '147874'
706 0.0002 0.0001518726348877
SELECT * FROM productcustomimages WHERE product_id = '147874'
707 0.0037 0.0037238597869873
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '147874' AND a.name = n.originalname
708 0.0003 0.00025701522827148
SELECT * FROM productoffers WHERE product_id = '147874' AND merchantid = 'ATVPDKIKX0DER'
709 0.0003 0.00026893615722656
SELECT * FROM productoffers
                WHERE product_id = '147874' AND price > 0
                ORDER BY price ASC LIMIT 1
710 0.0005 0.00053501129150391
SELECT value FROM productattributes WHERE product_id = '147874' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
711 0.0002 0.00017285346984863
UPDATE products SET price = '1486' WHERE id = '147874'
712 0.0003 0.00032806396484375
SELECT * FROM productimages WHERE product_id = '407089' ORDER BY sortorder ASC
713 0.0003 0.00025200843811035
SELECT * FROM product_image_select WHERE product_id = '407089'
714 0.0002 0.00016903877258301
SELECT * FROM productcustomimages WHERE product_id = '407089'
715 0.0045 0.0045280456542969
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407089' AND a.name = n.originalname
716 0.0003 0.00025701522827148
SELECT * FROM productoffers WHERE product_id = '407089' AND merchantid = 'ATVPDKIKX0DER'
717 0.0003 0.00025081634521484
SELECT * FROM productoffers
                WHERE product_id = '407089' AND price > 0
                ORDER BY price ASC LIMIT 1
718 0.0006 0.00057005882263184
SELECT value FROM productattributes WHERE product_id = '407089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
719 0.0002 0.00016903877258301
UPDATE products SET price = '3999' WHERE id = '407089'
720 0.0002 0.00023102760314941
SELECT * FROM productimages WHERE product_id = '53240' ORDER BY sortorder ASC
721 0.0003 0.00026488304138184
SELECT * FROM product_image_select WHERE product_id = '53240'
722 0.0001 0.00014805793762207
SELECT * FROM productcustomimages WHERE product_id = '53240'
723 0.0029 0.0028948783874512
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53240' AND a.name = n.originalname
724 0.0002 0.00024795532226562
SELECT * FROM productoffers WHERE product_id = '53240' AND merchantid = 'ATVPDKIKX0DER'
725 0.0003 0.00026893615722656
SELECT * FROM productoffers
                WHERE product_id = '53240' AND price > 0
                ORDER BY price ASC LIMIT 1
726 0.0005 0.000518798828125
SELECT value FROM productattributes WHERE product_id = '53240' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
727 0.0002 0.00016212463378906
UPDATE products SET price = '8199' WHERE id = '53240'
728 0.0002 0.00022792816162109
SELECT * FROM productimages WHERE product_id = '407551' ORDER BY sortorder ASC
729 0.0003 0.00027108192443848
SELECT * FROM product_image_select WHERE product_id = '407551'
730 0.0002 0.00015091896057129
SELECT * FROM productcustomimages WHERE product_id = '407551'
731 0.0049 0.0048730373382568
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407551' AND a.name = n.originalname
732 0.0003 0.00025081634521484
SELECT * FROM productoffers WHERE product_id = '407551' AND merchantid = 'ATVPDKIKX0DER'
733 0.0002 0.00024008750915527
SELECT * FROM productoffers
                WHERE product_id = '407551' AND price > 0
                ORDER BY price ASC LIMIT 1
734 0.0006 0.00058293342590332
SELECT value FROM productattributes WHERE product_id = '407551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
735 0.0002 0.00015497207641602
UPDATE products SET price = '10596' WHERE id = '407551'
736 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '413295' ORDER BY sortorder ASC
737 0.0003 0.0002739429473877
SELECT * FROM product_image_select WHERE product_id = '413295'
738 0.0001 0.00014901161193848
SELECT * FROM productcustomimages WHERE product_id = '413295'
739 0.0029 0.002932071685791
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413295' AND a.name = n.originalname
740 0.0002 0.00023889541625977
SELECT * FROM productoffers WHERE product_id = '413295' AND merchantid = 'ATVPDKIKX0DER'
741 0.0002 0.00024294853210449
SELECT * FROM productoffers
                WHERE product_id = '413295' AND price > 0
                ORDER BY price ASC LIMIT 1
742 0.0005 0.00048208236694336
SELECT value FROM productattributes WHERE product_id = '413295' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
743 0.0002 0.00015521049499512
UPDATE products SET price = '254999' WHERE id = '413295'
744 0.0003 0.0002748966217041
SELECT * FROM productimages WHERE product_id = '143805' ORDER BY sortorder ASC
745 0.0003 0.00026702880859375
SELECT * FROM product_image_select WHERE product_id = '143805'
746 0.0002 0.00015091896057129
SELECT * FROM productcustomimages WHERE product_id = '143805'
747 0.0029 0.0028738975524902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '143805' AND a.name = n.originalname
748 0.0002 0.00023698806762695
SELECT * FROM productoffers WHERE product_id = '143805' AND merchantid = 'ATVPDKIKX0DER'
749 0.0002 0.00024914741516113
SELECT * FROM productoffers
                WHERE product_id = '143805' AND price > 0
                ORDER BY price ASC LIMIT 1
750 0.0005 0.00048685073852539
SELECT value FROM productattributes WHERE product_id = '143805' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
751 0.0002 0.00015902519226074
UPDATE products SET price = '10999' WHERE id = '143805'
752 0.0005 0.0005040168762207
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
753 0.0002 0.00015592575073242
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
754 0.0001 0.00014781951904297
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
755 0.0001 0.00014901161193848
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
756 0.0002 0.00015687942504883
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
757 0.0005 0.00050687789916992
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
758 0.0002 0.00018501281738281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
759 0.0002 0.0001838207244873
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
760 0.0002 0.00016283988952637
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
761 0.0012 0.0011730194091797
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
762 0.0004 0.00040292739868164
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
763 0.0004 0.00035715103149414
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
764 0.0005 0.00053095817565918
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
765 0.0004 0.00040197372436523
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'