Tactical Equipment - Survivalist Equipment
   

Range Finding - Are You Calculating Or Estimating It?

Modern laser range finding spotting scopes

Figuring out the distance between you and your quarry is easily the biggest question that has to be answered when affecting an accurate bowshot while hunting. In fact accuracy and the correct estimation of distances share an inverse relationship; where the better you can range your target the smaller your margin for error.

UPDATED :  


RANGE ESTIMATION

When I first started bowhunting my hunting was rather Spartan with just bow and arrows and a knife. When it came to judging the distance of a shot I would give it my best guess and let fly.

This worked well at the start when I was full of confidence and ignorance but as soon as I missed a few shots and wounded and lost my first animal this method started to implode.

My confidence reduced to a point where I was so conservative that Istarted backing my stalking skills to get within 25 metres, so that range estimation for those longer shots was mitigated. This increased my success but reduced how productive I was overall as my effective shooting range diminished to only those easy chip shots.

bow-hunter-with-range-finderRange-finding from a static position.

I came to a crossroads during one of my early red deer roars. I could hear a big stag dealing to another subordinate stag in a punga gut across a swamp when all of a sudden the stags chased each other down towards me, with the smaller stag being chased off leaving the dominant stag standing broadside at what I estimated to be bang on 40 metres?

Modern laser rangefinders. I drew back and settled the 40 metre pin but didn't release. I second guessed the range and before I knew it the chance at that magnificent stag had evaporated as he trotted away. It was time to invest in a rangefinder!

The next time I passed that point with my new Leupold range-finder hanging from my neck I ranged the tree that the beautiful red stag had been standing next to. The reading blinked and settled at 40.0m!

There is a benefit to practising range estimation without a rangefinder as there will be times when you don't have time to range your quarry. There will also be times when the target will be close enough that you don't need to know the range.

Remember that the less detail you can make out on the animal the further it will be away. You have to estimate slightly less for a steep uphill or downhill angle.

The distance across voids such as deep gullies will appear a lot further than they really are.

The best form of practice for range estimation is to pick out landmarks as you hunt and estimate the distance to them.

Go with your first gut feeling and then check with a rangefinder if you can access one. You will soon find that with constant practice your estimation will improve.

If you are actively wanting to avoid using a rangefinder in order to make the hunt more challenging and traditional, then you can help your cause by shooting a faster arrow which will flatten the arrow trajectory and reduce the margin of error especially at close range.

RANGE CALCULATION

The calculation of distances would not be a problem if bows had evolved to shoot an arrow with a flat trajectory much like a rifle. This however has not happened as even the fastest bows shoot an arrow with an arced trajectory. The next best thing would be to have a device that can measure the distances and calibrate it to the given bow.

Before the nineties the idea of a hand-held unit that could somehow figure out the distance for you was something we could only dream of; enter the laser rangefinder.

The rangefinder has evolved from a horizontal unit, much like binoculars, to smaller vertical units that can be operated in one hand with the operation buttons on top so that either hand can operate it.

Some higher end sets of binoculars also have a range-finding function. The rangefinder uses a laser beam that shoots out towards the target and uses the time it takes to bounce back to calculate the distance.

ANGLE RANGE CALCULATION

Angle range calculation, or ARC for short, is an application incorporated into many rangefinders which calculates the angle you are shooting and adjusts the distance to suit. Hence with a steep downhill shot at 50 metres the ARC will figure out the actual distance to shoot at, which will be shorter than the straight line distance and closer to the actual horizontal distance.

This application can be set for different draw weight so check the setup manual. Confirm that your bow is calibrated to the ARC settings in your rangefinder by shooting targets at steep uphill and downhill angles and various distances before you go hunting.


RANGEFINDER TIPS

If your rangefinder does not have an ARC application then you can figure out the approximate percentage to take off your measurements by practicing multiple steep uphill and downhill shots. Remember this will only be relevant to the specific rangefinder and bow and arrow rig you are using.

If there is a chance that your mate may range the animal for you with their own rangefinder, then check each of your range-finders against the same object to compare them. This is a must if the rangefinders are different brands. Also check to see if you are both in metres or yards.

I remember ranging a hind standing broadside at 27 metres. My mate drew back and shot just over her shoulder. We both looked at each other puzzled and then checked our rangefinders. Mine measured 27 metres while my friend's one measured 34 metres off the same object!

When ranging through thick cover use the scan mode, which is usually initiated by holding the power button down. This will give you multiple readings that will make the erroneous shorter measurements obvious.

When ranging an animal you don't have to range its chest. If it means you stay out of sight you can range its hindquarter or the tree it is standing next to and use that.

HANDY HINT: Always carry a spare CR2 battery on extended hunts.

If you are hunting from a static position, such as a tree stand, use your down time to range obvious landmarks around you and memorise them so that if an animal arrives on the scene you can determine its distance without having to go back to your rangefinder and creating unnecessary movement.

Remember that thick fog or mist will reduce the rangefinder's ability to secure a reading. For a largely hands-free operation I hang my rangefinder off my chest from a binocular harness.

When needing to range I stretch the harness to bring the unit up to my eye to acquire the range, then as soon as I have registered it I drop the rangefinder which rebounds back to my chest. I can then adjust my bow sight and start the shot process while forgetting about pocketing the rangefinder.

A BALANCED APPROACH

The balanced way to approach range estimation is to use the rangefinder at every opportunity while also being confident enough in range estimation to make a shot when a rangefinder cannot be used.

I use a logical system where I do not consider using a range-finder when I can see the target animal in high detail. Usually this means I can see the texture of its hide which applies out to a distance of about 20 metres.

Beyond that I will range the distance with the rangefinder and will seldom take a long shot without ranging it precisely. However, I will take a shot and rely on range estimation if time is running out, especially if it is a follow up shot.

EFFECTIVE RANGE

With a balanced and disciplined approach to range-finding you will be able to shoot with confidence and your effective range will be limited only by your ability to make the shot, rather than a lack of range-finding accuracy!

Hunting close up fallow buck

ABOVE : An animal close enough to see the detail in its hide should not require a rangefinder - it is close! This fallow buck was about 15 metres from the camera lens.


  View all LASER RANGE FINGER models: View our Laser Rangefinder category.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.5591099262238 604 0.8746 0


No Amazon API Requests Made.


App Debug - Total Time 1.5591099262238 seconds

Number Time From Start Name Description
1 0.43551087379456 Initialise Initialise FSB Function
2 0.44740390777588 App Controller Start Start of the App controller (called before the controller of every page)
3 0.4614679813385 Start of getCategoryListByGroup Function Before first category groups query
4 0.46167683601379 After initial query Before first category groups query
5 0.46167802810669 Get Category List for Group Before the call to getCategoryList function
6 0.46168184280396 Start of GetCategoryList function Start of the function
7 0.4616858959198 Before getting categories Query to get specific category list
8 0.46235680580139 After getting categories Query to get specific category list
9 0.46235799789429 Before getting category custom Before call to function getCategoryCustom
10 0.46458292007446 After getting category custom After call to function getCategoryCustom
11 0.46458601951599 Before getting category custom Before call to function getCategoryCustom
12 0.47744202613831 After getting category custom After call to function getCategoryCustom
13 0.47744584083557 Before getting category custom Before call to function getCategoryCustom
14 0.48358392715454 After getting category custom After call to function getCategoryCustom
15 0.48358702659607 Before getting category custom Before call to function getCategoryCustom
16 0.48805499076843 After getting category custom After call to function getCategoryCustom
17 0.48805785179138 End of GetCategoryList function End of the function
18 0.4880678653717 Get Category List for Group Before the call to getCategoryList function
19 0.48807096481323 Start of GetCategoryList function Start of the function
20 0.48807382583618 Before getting categories Query to get specific category list
21 0.488520860672 After getting categories Query to get specific category list
22 0.48852181434631 Before getting category custom Before call to function getCategoryCustom
23 0.49463582038879 After getting category custom After call to function getCategoryCustom
24 0.49463891983032 Before getting category custom Before call to function getCategoryCustom
25 0.50567698478699 After getting category custom After call to function getCategoryCustom
26 0.50567889213562 End of GetCategoryList function End of the function
27 0.50568580627441 Get Category List for Group Before the call to getCategoryList function
28 0.50568890571594 Start of GetCategoryList function Start of the function
29 0.50569081306458 Before getting categories Query to get specific category list
30 0.5064058303833 After getting categories Query to get specific category list
31 0.5064070224762 Before getting category custom Before call to function getCategoryCustom
32 0.51569581031799 After getting category custom After call to function getCategoryCustom
33 0.51569795608521 Before getting category custom Before call to function getCategoryCustom
34 0.53324699401855 After getting category custom After call to function getCategoryCustom
35 0.5332498550415 Before getting category custom Before call to function getCategoryCustom
36 0.53919982910156 After getting category custom After call to function getCategoryCustom
37 0.53920197486877 Before getting category custom Before call to function getCategoryCustom
38 0.54573488235474 After getting category custom After call to function getCategoryCustom
39 0.54573798179626 Before getting category custom Before call to function getCategoryCustom
40 0.55206990242004 After getting category custom After call to function getCategoryCustom
41 0.55207300186157 Before getting category custom Before call to function getCategoryCustom
42 0.57410287857056 After getting category custom After call to function getCategoryCustom
43 0.57410597801208 Before getting category custom Before call to function getCategoryCustom
44 0.57832288742065 After getting category custom After call to function getCategoryCustom
45 0.57832598686218 Before getting category custom Before call to function getCategoryCustom
46 0.58297300338745 After getting category custom After call to function getCategoryCustom
47 0.58297491073608 End of GetCategoryList function End of the function
48 0.58298993110657 Get Category List for Group Before the call to getCategoryList function
49 0.5829930305481 Start of GetCategoryList function Start of the function
50 0.58299589157104 Before getting categories Query to get specific category list
51 0.58341979980469 After getting categories Query to get specific category list
52 0.58342099189758 Before getting category custom Before call to function getCategoryCustom
53 0.58572602272034 After getting category custom After call to function getCategoryCustom
54 0.58572793006897 Before getting category custom Before call to function getCategoryCustom
55 0.58803081512451 After getting category custom After call to function getCategoryCustom
56 0.58803296089172 End of GetCategoryList function End of the function
57 0.5880389213562 Get Category List for Group Before the call to getCategoryList function
58 0.58804082870483 Start of GetCategoryList function Start of the function
59 0.58804392814636 Before getting categories Query to get specific category list
60 0.58834791183472 After getting categories Query to get specific category list
61 0.58834886550903 Before getting category custom Before call to function getCategoryCustom
62 0.59332799911499 After getting category custom After call to function getCategoryCustom
63 0.59332990646362 End of GetCategoryList function End of the function
64 0.5933358669281 End of getCategoryListByGroup Function Before return()
65 0.64328789710999 App Controller End End of the App controller (called before the controller of every page)
66 0.64485788345337 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.64495182037354 Before Get Options Before the call to getOptions in the tpl class
68 1.3385348320007 After Get Options After the call to getOptions in the tpl class
69 1.3385918140411 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.5590908527374 Finalizing debug Before the debug is output to the page.
71 1.5591089725494 End of App This is the end of the app logging, final timestamp


Query Debug - 604 Database Queries. Total time 0.8746 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00018811225891113
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00049901008605957
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00020098686218262
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00015592575073242
SELECT * FROM `bad_bots`
5 0.0005 0.00048279762268066
SELECT parameter, value FROM parameters
6 0.0002 0.00016498565673828
SET time_zone = 'Europe/London'
7 0.0004 0.00040006637573242
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00018477439880371
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00013399124145508
delete from cachefiles
10 0.0002 0.00023794174194336
SELECT id FROM pages WHERE pagename = 'range-finding-are-you-calculating-or-estimating-it' LIMIT 1
11 0.0002 0.00020813941955566
SELECT * FROM pages WHERE id = 299
12 0.0009 0.00092816352844238
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0121 0.012058973312378
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00028705596923828
SELECT * FROM pages WHERE pagename = 'range-finding-are-you-calculating-or-estimating-it'
15 0.0002 0.00018095970153809
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00063204765319824
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0006 0.00058197975158691
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.0003 0.00027298927307129
SELECT id FROM categories WHERE parent_id = '49'
19 0.0006 0.00056314468383789
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
21 0.0002 0.00017595291137695
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.00020098686218262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0002 0.0001521110534668
SELECT * FROM categorygroups WHERE id = '1'
24 0.0036 0.0036170482635498
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.00031089782714844
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00023508071899414
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00022196769714355
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0002291202545166
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00024795532226562
SELECT id FROM categories WHERE parent_id = '129'
30 0.0071 0.0071060657501221
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.00016212463378906
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.00021100044250488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00013995170593262
SELECT * FROM categorygroups WHERE id = '1'
35 0.0026 0.0025699138641357
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.00027298927307129
SELECT id FROM categories WHERE parent_id = '80'
37 0.0026 0.0025811195373535
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0002 0.00015616416931152
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.00014901161193848
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.00016212463378906
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00014019012451172
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.001223087310791
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.00025010108947754
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '101'
45 0.0021 0.0020649433135986
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.00016617774963379
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.00016403198242188
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.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00042200088500977
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0025 0.0025460720062256
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.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '30'
53 0.0026 0.0026259422302246
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.00015497207641602
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.0001 0.00014686584472656
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.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012898445129395
SELECT * FROM categorygroups WHERE id = '2'
58 0.0052 0.0051779747009277
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.00026893615722656
SELECT id FROM categories WHERE parent_id = '61'
60 0.0049 0.0048880577087402
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.00015902519226074
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.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 (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012683868408203
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00065183639526367
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0041289329528809
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.00026202201843262
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0041370391845703
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.0001990795135498
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.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 (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00019288063049316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
73 0.0083 0.0082638263702393
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.00028491020202637
SELECT id FROM categories WHERE parent_id = '65'
75 0.0083 0.0082969665527344
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.00016593933105469
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.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 (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.0001678466796875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0025038719177246
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.00026512145996094
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.002514123916626
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.00015091896057129
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.00014615058898926
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.00015807151794434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
87 0.0025 0.0024900436401367
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.00030684471130371
SELECT id FROM categories WHERE parent_id = '31'
89 0.0030 0.0029640197753906
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.00017690658569336
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0002 0.0001528263092041
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.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012898445129395
SELECT * FROM categorygroups WHERE id = '10'
94 0.0023 0.002284049987793
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.00026392936706543
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00022411346435547
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0028400421142578
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.00017714500427246
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.0001518726348877
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.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
102 0.0096 0.0095820426940918
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.00028514862060547
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00020384788513184
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '130'
109 0.0104 0.010361909866333
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.00018787384033203
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.00015902519226074
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.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012588500976562
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.0002751350402832
SELECT id FROM categories WHERE parent_id = '32'
116 0.0017 0.0016510486602783
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.00015807151794434
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.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 (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
119 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0018391609191895
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.00025200843811035
SELECT id FROM categories WHERE parent_id = '89'
123 0.0019 0.0018560886383057
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0002 0.00016593933105469
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.00014901161193848
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.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00040006637573242
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00069212913513184
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.00023078918457031
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00069785118103027
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.00014686584472656
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.00014400482177734
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00068283081054688
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.0002439022064209
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00071501731872559
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.0002 0.0001528263092041
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.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 (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.00029110908508301
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0020279884338379
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.00024914741516113
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020480155944824
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.0001 0.00014686584472656
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.00014591217041016
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.00014495849609375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '20'
151 0.0054 0.0053720474243164
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00037312507629395
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00018787384033203
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015902519226074
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00019383430480957
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '401'
169 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00015521049499512
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '107'
182 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '271'
190 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.0001680850982666
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00026607513427734
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '413'
222 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014376640319824
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014901161193848
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '145'
250 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '156'
251 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019288063049316
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '387'
259 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00017404556274414
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00019478797912598
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '392'
289 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.00013995170593262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '293'
308 0.0001 0.00014877319335938
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00014209747314453
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '299'
315 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '383'
317 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '385'
318 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.00013995170593262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00023388862609863
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00022220611572266
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '199'
338 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '200'
339 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '455'
353 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '462'
357 0.0002 0.0001528263092041
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.0001370906829834
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.0001 0.00013017654418945
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0013930797576904
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0003 0.00025296211242676
SELECT * FROM pages WHERE pagename = 'range-finding-are-you-calculating-or-estimating-it'
373 0.0002 0.00022006034851074
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
374 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = 2
375 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = 4
376 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = 12
377 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = 10
378 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 7
379 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = 18
380 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 28
381 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 13
382 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = 3
383 0.0440 0.044013977050781
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
384 0.0002 0.00023412704467773
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:1560876071;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:2;s:6:\"398858\";i:6;s:6:\"170197\";i:11;s:6:\"402983\";i:15;s:6:\"414825\";i:20;s:6:\"408078\";}}' WHERE id = '175'
385 0.0004 0.00044107437133789
SELECT * FROM products WHERE id IN (414940,398858,170197,402983,414825,408078) ORDER BY FIELD(id, 414940,398858,170197,402983,414825,408078 )
386 0.0002 0.00020813941955566
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
387 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '414940'
388 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '414940'
389 0.0032 0.0032110214233398
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
390 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
391 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
392 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
393 0.0001 0.00012111663818359
UPDATE products SET price = '4490' WHERE id = '414940'
394 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
395 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '398858'
396 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '398858'
397 0.0030 0.0029668807983398
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
398 0.0002 0.00018882751464844
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
399 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
400 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
401 0.0001 0.00011897087097168
UPDATE products SET price = '2999' WHERE id = '398858'
402 0.0007 0.00069093704223633
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
403 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '170197'
404 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '170197'
405 0.0032 0.0031819343566895
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
406 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
407 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0004 0.00041389465332031
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
409 0.0001 0.00012993812561035
UPDATE products SET price = '324500' WHERE id = '170197'
410 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
411 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '402983'
412 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '402983'
413 0.0022 0.0021889209747314
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
414 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
415 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0003 0.00034689903259277
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
417 0.0001 0.00012516975402832
UPDATE products SET price = '10392' WHERE id = '402983'
418 0.0002 0.0002129077911377
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
419 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '414825'
420 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '414825'
421 0.0020 0.002007007598877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
422 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
423 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
424 0.0004 0.00036907196044922
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
425 0.0001 0.00011897087097168
UPDATE products SET price = '11999' WHERE id = '414825'
426 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
427 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '408078'
428 0.0001 0.00012779235839844
SELECT * FROM productcustomimages WHERE product_id = '408078'
429 0.0030 0.0030109882354736
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
430 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
431 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0004 0.00040411949157715
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
433 0.0001 0.00012612342834473
UPDATE products SET price = '23352' WHERE id = '408078'
434 0.0435 0.043461799621582
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
435 0.0002 0.00022006034851074
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:1560876071;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:9;s:6:\"409759\";i:10;s:6:\"408792\";i:17;s:6:\"406758\";i:22;s:6:\"131163\";i:23;s:6:\"410949\";}}' WHERE id = '177'
436 0.0004 0.00043606758117676
SELECT * FROM products WHERE id IN (398315,409759,408792,406758,131163,410949) ORDER BY FIELD(id, 398315,409759,408792,406758,131163,410949 )
437 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
438 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '398315'
439 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '398315'
440 0.0025 0.0024518966674805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
441 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
442 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
443 0.0004 0.00039792060852051
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
444 0.0001 0.00012302398681641
UPDATE products SET price = '1999' WHERE id = '398315'
445 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
446 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '409759'
447 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '409759'
448 0.0028 0.0027599334716797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
449 0.0003 0.00031495094299316
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
450 0.0002 0.00022315979003906
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
451 0.0004 0.00042891502380371
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
452 0.0002 0.00016880035400391
UPDATE products SET price = '229000' WHERE id = '409759'
453 0.0002 0.0002138614654541
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
454 0.0002 0.00023579597473145
SELECT * FROM product_image_select WHERE product_id = '408792'
455 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '408792'
456 0.0036 0.0036067962646484
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
457 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
458 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
459 0.0004 0.00044584274291992
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
460 0.0001 0.00012397766113281
UPDATE products SET price = '13499' WHERE id = '408792'
461 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
462 0.0002 0.00023508071899414
SELECT * FROM product_image_select WHERE product_id = '406758'
463 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '406758'
464 0.0026 0.0025739669799805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
465 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
466 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
467 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
468 0.0001 0.00012516975402832
UPDATE products SET price = '2694' WHERE id = '406758'
469 0.0002 0.00024700164794922
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
470 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '131163'
471 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '131163'
472 0.0026 0.002601146697998
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
473 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
474 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
475 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
476 0.0001 0.00012803077697754
UPDATE products SET price = '20362' WHERE id = '131163'
477 0.0002 0.00019121170043945
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
478 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '410949'
479 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '410949'
480 0.0033 0.0032861232757568
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
481 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
482 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
483 0.0004 0.00042319297790527
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
484 0.0001 0.00013494491577148
UPDATE products SET price = '47995' WHERE id = '410949'
485 0.1140 0.11403107643127
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
486 0.0002 0.00024986267089844
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:1560876071;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:9;s:6:\"409759\";i:10;s:6:\"408792\";i:19;s:6:\"147874\";i:2;s:6:\"398858\";i:4;s:6:\"290575\";}}' WHERE id = '181'
487 0.0005 0.0004889965057373
SELECT * FROM products WHERE id IN (414940,409759,408792,147874,398858,290575) ORDER BY FIELD(id, 414940,409759,408792,147874,398858,290575 )
488 0.0002 0.00020909309387207
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
489 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '414940'
490 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '414940'
491 0.0035 0.0034801959991455
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
492 0.0002 0.00020694732666016
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
493 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
494 0.0005 0.00046110153198242
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
495 0.0005 0.00052690505981445
UPDATE products SET price = '4490' WHERE id = '414940'
496 0.0002 0.00023102760314941
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
497 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '409759'
498 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '409759'
499 0.0032 0.003154993057251
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
500 0.0002 0.00021505355834961
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
501 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
502 0.0004 0.00042891502380371
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
503 0.0020 0.002025842666626
UPDATE products SET price = '229000' WHERE id = '409759'
504 0.0002 0.00024604797363281
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
505 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '408792'
506 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '408792'
507 0.0036 0.0035760402679443
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
508 0.0002 0.00021004676818848
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
509 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
510 0.0005 0.00045990943908691
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
511 0.0001 0.00012516975402832
UPDATE products SET price = '13499' WHERE id = '408792'
512 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '147874' ORDER BY sortorder ASC
513 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '147874'
514 0.0001 0.00013017654418945
SELECT * FROM productcustomimages WHERE product_id = '147874'
515 0.0028 0.0028259754180908
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '147874' AND a.name = n.originalname
516 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '147874' AND merchantid = 'ATVPDKIKX0DER'
517 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '147874' AND price > 0
                ORDER BY price ASC LIMIT 1
518 0.0004 0.00039792060852051
SELECT value FROM productattributes WHERE product_id = '147874' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
519 0.0001 0.00012087821960449
UPDATE products SET price = '599' WHERE id = '147874'
520 0.0002 0.00018906593322754
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
521 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '398858'
522 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '398858'
523 0.0030 0.0030238628387451
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
524 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0004 0.00041985511779785
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
527 0.0001 0.00013184547424316
UPDATE products SET price = '2999' WHERE id = '398858'
528 0.0006 0.00061798095703125
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
529 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '290575'
530 0.0002 0.00015091896057129
SELECT * FROM productcustomimages WHERE product_id = '290575'
531 0.0034 0.0033979415893555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
532 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
533 0.0002 0.00022792816162109
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
534 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
535 0.0001 0.00013113021850586
UPDATE products SET price = '549500' WHERE id = '290575'
536 0.1093 0.10928201675415
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
537 0.0003 0.00025320053100586
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:1560876072;s:8:\"products\";a:6:{i:6;s:6:\"170197\";i:7;s:6:\"404554\";i:9;s:6:\"409759\";i:10;s:6:\"408792\";i:11;s:6:\"402983\";i:12;s:6:\"103845\";}}' WHERE id = '183'
538 0.0005 0.00045680999755859
SELECT * FROM products WHERE id IN (170197,404554,409759,408792,402983,103845) ORDER BY FIELD(id, 170197,404554,409759,408792,402983,103845 )
539 0.0007 0.00069403648376465
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
540 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '170197'
541 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '170197'
542 0.0032 0.0032069683074951
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
543 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
544 0.0002 0.0002288818359375
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.2499 0.24985003471375
UPDATE products SET price = '324500' WHERE id = '170197'
547 0.0004 0.00041794776916504
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
548 0.0002 0.00023293495178223
SELECT * FROM product_image_select WHERE product_id = '404554'
549 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '404554'
550 0.0043 0.0043401718139648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
551 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.0002288818359375
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0002 0.0001530647277832
UPDATE products SET price = '399999' WHERE id = '404554'
555 0.0002 0.00023293495178223
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
556 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '409759'
557 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '409759'
558 0.0039 0.0038528442382812
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
559 0.0002 0.00021600723266602
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0004 0.00043392181396484
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0002 0.00016689300537109
UPDATE products SET price = '229000' WHERE id = '409759'
563 0.0002 0.00023293495178223
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
564 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '408792'
565 0.0001 0.0001368522644043
SELECT * FROM productcustomimages WHERE product_id = '408792'
566 0.0045 0.0045318603515625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
567 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00021219253540039
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.0001368522644043
UPDATE products SET price = '13499' WHERE id = '408792'
571 0.0002 0.00023102760314941
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
572 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '402983'
573 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '402983'
574 0.0032 0.0032320022583008
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
575 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00014305114746094
UPDATE products SET price = '10392' WHERE id = '402983'
579 0.0002 0.00021791458129883
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
580 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '103845'
581 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '103845'
582 0.0038 0.0037660598754883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
583 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00013208389282227
UPDATE products SET price = '14499' WHERE id = '103845'
587 0.0004 0.00041913986206055
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
588 0.0002 0.00015020370483398
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
589 0.0001 0.00013899803161621
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
590 0.0001 0.00014901161193848
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
591 0.0004 0.00041389465332031
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
592 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
593 0.0001 0.00013899803161621
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
594 0.0009 0.00091695785522461
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
595 0.0003 0.00031590461730957
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
596 0.0003 0.00029206275939941
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
597 0.0005 0.00051188468933105
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
598 0.0002 0.00015401840209961
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0001 0.00012707710266113
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0001 0.00014400482177734
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
601 0.0001 0.00012397766113281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0005 0.00046205520629883
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
604 0.0005 0.00045490264892578
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'