Tactical Equipment - Survivalist Equipment
   

Shooting Up And Down Hill

Ballistics for shooting up and down hill

UPDATED :  

We've had lots of feedback about some of the "Hunting&Fishing Tips of the Trip" we've been doing in our TV Show series.

One in particular that we had requests for more information about is the uphill and downhill shooting tip.

How to shoot up hill and down hill

As it's the bull tahr rut, and tahr hunting often requires steeply up or down hill shots more so than any other game animal in this countiy, it seems an opportune issue to cover this off in more detail than we had time for during the Show. So here goes.

The simple issue to consider here is that shooting either up or down hill affects the trajectory of the bullet in relation to your line of sight. Everyone should be aware that gravity causes the bullet to drop from the moment it leaves the muzzle of the gun.

The longer the bullet is in the air, the more it drops, which is why slower cartridges have more drop than faster ones over a given range. Gravity pulls directly towards the centre of the earth, or perpendicular to the earth's surface to put it another way.

In really basic terms the bullets "drop" as far as you the shooter is concerned varies according to how far it travels across gravity parallel to the earth's surface. In case you haven't picked up the significance of this, if instead of a level shot you're shooting uphill or downhill, your bullet is no longer traveling at right angles to gravity's pull.

Long range shooting ballistics

Therefore for the same line of sight (LOS) distance shot whether up or down hill as compared with across the flat, your shot is no longer at right angles to gravity and gravity's effect on "your observed drop" will be less as your bullet hasn't travelled as far across it. The steeper the angle, the less your rifle and load will drop compared with a level shot of the same distance.

Also remember, a shot of the same angle whether uphill or downhill will have the same effect, it will go high. This is because the distance travelled parallel with the earth's surface will be the same whether say 30 degrees up or down hill.

The way we visualised this in the Tip of the Trip' was to imagine shooting level where you get the full effect of bullet drop due to gravity in relation to your LOS, then elevate your rifle until your rifle is pointing straight up in the air. The bullet would go straight up and come back down in the same place, showing no drop in relation to your LOS.

Simple accurate incline decline shooting angle guage

ABOVE : This simple little angle gauge is easily made and allows you to measure the angle of the shot. It is very difficult to guess this with any accuracy at the ranges and angles at which it becomes significant. You sight along the top at your target, then read the angle off the straightened paper clip, milking sure its hanging freely.

Shoot vertically straight downwards from a helicopter or some such and again, the bullet will go straight down and show no drop in relation to your LOS. As you steepen the angle away from a level shot in either direction up or down, the drop will be progressively less and less until there is no "observed drop".

Now strictly ballistically speaking, lots of what I just said is inaccurate, but it is the easiest way to try and get across some appreciation of the effect of uphill and downhill shooting.

What makes this description inaccurate is that the "true drop" doesn't change, no matter the angle, but the "observed drop" does. Complicating things further is the fact your scope (your LOS in effect) is mounted above your barrel (the line of departure, LOD), and you've sighted in so that the LOS and LOD intersect at a point you've chosen, giving you your sight in range (250 yards in the example we've chosen in the table below). For this reason you can't just use simple trigonometry and the co-sign to calculate the "corrected" range for any angle. You need to take into account your zero range and sight height.

So How Do I Allow For This?

Simple shooting angles

The rule of thumb is to hold low on steep angle shots, but although the idea is right, most hunters have no idea of how much we are talking about. In my experience, a lot of the hunters who are aware of this allow far too much in most cases.

To give you some idea, here is a table showing the effect of up and downhill shots on the example of a 7mm-08 sighted in for 250 yards, which is a sensible sight in range for this calibre.

The top row is the bullet path (in inches) in relation to LOS for a level shot, while the figures for the three angles are how much higher the impact will be on this angle. In other words you need to add this figure onto the level figures to find out where you'll hit at different angles in relation to your LOS:

 100 yards200 yards300 yards400 yards500 yards
Level shot +2.85" +2.34" -3.9" -16.94 -38.11
15° incline +0.1"; +0.2" +0.7" +1.4" +2.3"
30° incline +0.2" +0.9" +2.9" +5.5" +9.17"
45° incline +0.35" +1.4" +6.5" +12" +20.16"

Most people over estimate the steepness of the angle, and its got to be an extremely steep shot at usually close range to make 45°.

Nightforce ADI shooting anglesNightforce's ADI attaches to a Weaver or Picatinny rail type base, and can be seen from the shooting position.

The longer the shot, the less steep the angle is likely to be anyway, due to the terrain. It would have to be a very tall bluff to cause a very steep angle and a very long shot. The steepest up or down hill shot you're likely to encounter regularly is 30°, and as you can see from the table below, the most this will affect your trajectory inside 300 yards is about 3 inches.

Flatter shooting rifles like the 270 on up will be affected even less, so the average hunter who doesn't shoot beyond 300 yards can pretty much forget about the angle on any shot with a middle of the shoulder hold unless it is a genuine measured more than 30° and 300 yards plus.

For longer ranges beyond 300 yards and at progressively steeper angles you will need a more precise way of dealing with up and down hill shots. Firstly you need a means of measuring the angle as well as the range. Laser rangefinders are common and affordable now, and the best ones have a built in inclometer for measuring incline.

They also have a calculation feature which to steal Leupold's term gives you what we'll call the True Ballistic Range (TBR). This is the effective level range for any shot as opposed to the LOS or angled range on an uphill or downhill shot - remembering this level range is the one you should be allowing for trajectory wise.

The current leaders in this field are Swarovski's EL Range, Leica's HD-B and Bushnell's Fusion rangefinding binoculars - with the and TBR calculator built into a binocular. These all in one units in Swarovski and Leica's case are truly top of the range optical instruments and are our current choice of hunting binocular.

If you don't have a rangefinder with a built in inclometer, then you need a separate inclometer of some sort to measure the incline.

There are some commercial versions available, ranging from separate units to others that attach like a ring on your scope or your scope base. Nightforce make a smart little device that attaches to a Weaver or Picatinny rail.

I used to make a very simple little model out of the lid of an icecream container and a paper clip. Cut the shape of the old half circle school protractor out of the lid, then drill a small hole in the middle of the flat side just down from the top.

Hold the base line of the protractor on this hole, then mark 0° at the bottom, then 15, 30 and 45° up each side. See photo. Poke a straightened out paper clip through the hole, and bend it over Vi an inch or so on the back side, but have the longest bit hanging down your marked side. You use it by sighting along the flat top at your target, letting the clip hang freely, then tilt it over and read the angle.

Just make sure the clip is straight and hanging freely when you pull it out as they do get bent up in your pouche s at times, but that's why I use the soft plastic lid and paper clip. They can get bent but straighten easily without getting wrecked.

True ballistic range manual calculatorThese simple factors are applied to your actucal measured range to find your TBR, and the simple arithmetic can be done in your head.

Now you have measured the angle, what do you do with it? You can use these simple little approximation factors to work out the level range equivalent. For 30°, you take 10% off the actual range to get your TBR. For 45°, you take off 20%. For 15°, you can pretty much ignore the incline, as it'll be within 2" for most calibres out to 500 yards as you can see from the table above.

You won't have a calculator with you when hunting, but a quick mental way of doing this for 30° to find your 10% if you don't already know how is to shift the decimal point one place to the left. For example, say your rangefinder says 460 yards to the stag, and your angle gauge says 30°, shift the decimal point one spot to get 46.0, then take this off 460 to get 414 yards (90% of 460). For 45° work out 10% as above, then double that to get 20% and subtract it from the range: 46 x 2 = 92 off 460 = 368 yards (80% of 460).

Now these 90% and 80% factors are not exact, but will be more than accurate enough for uphill/downhill shooting out to 500 yards.

Beyond that you need to get serious, and either measure the angle accurately and use a ballistics app on your phone, or use a rangefinder with the TBR feature.

Hopefully you've now got an appreciation as to why up and downhill shooting is not the same as firing level.

"I kept mine in my belt pouch so it was at hand quickly."

You now know when it becomes steep and long enough to have a significant effect you need to allow for, and can use one of the systems explained here to account for it. Ultimately 1 would suggest you should save up until you can afford one of the top quality, all in one range finder/binocular units that have the TBR or corrected range feature.

This is by far the quickest and simplest way, and will ensure you don't miss out on an animal because you either take too long trying to figure out your correction, or get it wrong causing a clean miss - or worse still a wounding.

AGAIN. IF YOU NEVER TAKE A SHOT BEYOND 300 YARDS. YOU CAN FORGET ABOUT IT EXCEPT FOR THE VERY STEEPEST ANGLES.

Mountain shooting uphill

ABOVE : Tahr hunting is the obvious example where you can be faced with some steeply up or down hill shots.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.8037660121918 842 0.9987 0


No Amazon API Requests Made.


App Debug - Total Time 1.8037660121918 seconds

Number Time From Start Name Description
1 0.43598198890686 Initialise Initialise FSB Function
2 0.44727206230164 App Controller Start Start of the App controller (called before the controller of every page)
3 0.45883893966675 Start of getCategoryListByGroup Function Before first category groups query
4 0.45900797843933 After initial query Before first category groups query
5 0.45901012420654 Get Category List for Group Before the call to getCategoryList function
6 0.45901298522949 Start of GetCategoryList function Start of the function
7 0.45901894569397 Before getting categories Query to get specific category list
8 0.45957708358765 After getting categories Query to get specific category list
9 0.45957899093628 Before getting category custom Before call to function getCategoryCustom
10 0.46144008636475 After getting category custom After call to function getCategoryCustom
11 0.46144199371338 Before getting category custom Before call to function getCategoryCustom
12 0.47203612327576 After getting category custom After call to function getCategoryCustom
13 0.47203803062439 Before getting category custom Before call to function getCategoryCustom
14 0.47760510444641 After getting category custom After call to function getCategoryCustom
15 0.47760701179504 Before getting category custom Before call to function getCategoryCustom
16 0.48170495033264 After getting category custom After call to function getCategoryCustom
17 0.48170709609985 End of GetCategoryList function End of the function
18 0.48171615600586 Get Category List for Group Before the call to getCategoryList function
19 0.48171806335449 Start of GetCategoryList function Start of the function
20 0.48172116279602 Before getting categories Query to get specific category list
21 0.48213815689087 After getting categories Query to get specific category list
22 0.4821400642395 Before getting category custom Before call to function getCategoryCustom
23 0.48765802383423 After getting category custom After call to function getCategoryCustom
24 0.4876720905304 Before getting category custom Before call to function getCategoryCustom
25 0.49835515022278 After getting category custom After call to function getCategoryCustom
26 0.49835705757141 End of GetCategoryList function End of the function
27 0.49836397171021 Get Category List for Group Before the call to getCategoryList function
28 0.49836611747742 Start of GetCategoryList function Start of the function
29 0.49836897850037 Before getting categories Query to get specific category list
30 0.49906611442566 After getting categories Query to get specific category list
31 0.49906802177429 Before getting category custom Before call to function getCategoryCustom
32 0.50824999809265 After getting category custom After call to function getCategoryCustom
33 0.50825309753418 Before getting category custom Before call to function getCategoryCustom
34 0.52563500404358 After getting category custom After call to function getCategoryCustom
35 0.52563714981079 Before getting category custom Before call to function getCategoryCustom
36 0.53153204917908 After getting category custom After call to function getCategoryCustom
37 0.53153395652771 Before getting category custom Before call to function getCategoryCustom
38 0.53739309310913 After getting category custom After call to function getCategoryCustom
39 0.53739500045776 Before getting category custom Before call to function getCategoryCustom
40 0.54361701011658 After getting category custom After call to function getCategoryCustom
41 0.54362010955811 Before getting category custom Before call to function getCategoryCustom
42 0.56553506851196 After getting category custom After call to function getCategoryCustom
43 0.5655369758606 Before getting category custom Before call to function getCategoryCustom
44 0.56960010528564 After getting category custom After call to function getCategoryCustom
45 0.56960201263428 Before getting category custom Before call to function getCategoryCustom
46 0.57417702674866 After getting category custom After call to function getCategoryCustom
47 0.57417917251587 End of GetCategoryList function End of the function
48 0.57419204711914 Get Category List for Group Before the call to getCategoryList function
49 0.57419395446777 Start of GetCategoryList function Start of the function
50 0.5741970539093 Before getting categories Query to get specific category list
51 0.57461404800415 After getting categories Query to get specific category list
52 0.57461595535278 Before getting category custom Before call to function getCategoryCustom
53 0.57689595222473 After getting category custom After call to function getCategoryCustom
54 0.57689905166626 Before getting category custom Before call to function getCategoryCustom
55 0.57920598983765 After getting category custom After call to function getCategoryCustom
56 0.57920813560486 End of GetCategoryList function End of the function
57 0.57921409606934 Get Category List for Group Before the call to getCategoryList function
58 0.57921504974365 Start of GetCategoryList function Start of the function
59 0.57921814918518 Before getting categories Query to get specific category list
60 0.57952094078064 After getting categories Query to get specific category list
61 0.57952308654785 Before getting category custom Before call to function getCategoryCustom
62 0.58448100090027 After getting category custom After call to function getCategoryCustom
63 0.58448195457458 End of GetCategoryList function End of the function
64 0.58448910713196 End of getCategoryListByGroup Function Before return()
65 0.63590717315674 App Controller End End of the App controller (called before the controller of every page)
66 1.0928120613098 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 1.0928821563721 Before Get Options Before the call to getOptions in the tpl class
68 1.5076770782471 After Get Options After the call to getOptions in the tpl class
69 1.5077230930328 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.8037481307983 Finalizing debug Before the debug is output to the page.
71 1.8037641048431 End of App This is the end of the app logging, final timestamp


Query Debug - 842 Database Queries. Total time 0.9987 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00018095970153809
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00045895576477051
SHOW TABLES LIKE 'bad_bots'
3 0.0001 0.00014996528625488
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00014090538024902
SELECT * FROM `bad_bots`
5 0.0004 0.00044894218444824
SELECT parameter, value FROM parameters
6 0.0002 0.00015091896057129
SET time_zone = 'Europe/London'
7 0.0003 0.00031900405883789
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00018405914306641
UPDATE autorun SET lastrun = '2019-06-18 17:25:54' WHERE id = '8'
9 0.0001 0.00014996528625488
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0001 9.1075897216797E-5
delete from cachefiles
11 0.0003 0.00026082992553711
SELECT id FROM pages WHERE pagename = 'shooting-up-and-down-hill' LIMIT 1
12 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = 354
13 0.0010 0.0010011196136475
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
14 0.0095 0.0094668865203857
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
15 0.0003 0.00030207633972168
SELECT * FROM pages WHERE pagename = 'shooting-up-and-down-hill'
16 0.0002 0.00015401840209961
SELECT * FROM categorygroups ORDER BY sortorder ASC
17 0.0005 0.00052285194396973
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
18 0.0005 0.00048995018005371
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
19 0.0002 0.00022506713867188
SELECT id FROM categories WHERE parent_id = '49'
20 0.0005 0.00045204162597656
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 
21 0.0001 0.00014495849609375
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 
22 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 
23 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
24 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '1'
25 0.0030 0.0030238628387451
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
26 0.0003 0.00026488304138184
SELECT id FROM categories WHERE parent_id = '50'
27 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '96'
28 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '97'
29 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '111'
30 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '129'
31 0.0057 0.0057260990142822
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 
32 0.0002 0.00016999244689941
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 
33 0.0002 0.00016498565673828
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 
34 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
35 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
36 0.0023 0.0023119449615479
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
37 0.0003 0.00025415420532227
SELECT id FROM categories WHERE parent_id = '80'
38 0.0023 0.0023348331451416
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 
39 0.0001 0.00014901161193848
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 
40 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 (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
41 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
42 0.0001 0.0001227855682373
SELECT * FROM categorygroups WHERE id = '1'
43 0.0012 0.0011649131774902
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
44 0.0002 0.00024580955505371
SELECT id FROM categories WHERE parent_id = '51'
45 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '101'
46 0.0018 0.0017828941345215
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 
47 0.0002 0.0001530647277832
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 
48 0.0001 0.00014805793762207
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 
49 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
50 0.0001 0.00013089179992676
SELECT * FROM categorygroups WHERE id = '1'
51 0.0004 0.00039386749267578
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
52 0.0023 0.0022950172424316
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
53 0.0003 0.00025296211242676
SELECT id FROM categories WHERE parent_id = '30'
54 0.0023 0.0022909641265869
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 
55 0.0001 0.00014901161193848
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 
56 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 (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
57 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
58 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
59 0.0048 0.0048189163208008
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
60 0.0003 0.0002741813659668
SELECT id FROM categories WHERE parent_id = '61'
61 0.0049 0.0048749446868896
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 
62 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 (61)
				  AND p.disabled = 0 
63 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 (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
64 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
65 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
66 0.0006 0.00063991546630859
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
67 0.0041 0.0041120052337646
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
68 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '64'
69 0.0041 0.0041201114654541
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 
70 0.0002 0.00016498565673828
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 
71 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 
72 0.0002 0.00016283988952637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
73 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
74 0.0082 0.0081641674041748
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
75 0.0003 0.00028514862060547
SELECT id FROM categories WHERE parent_id = '65'
76 0.0082 0.0082390308380127
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 
77 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
78 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 (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
79 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
80 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
81 0.0025 0.0024700164794922
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
82 0.0003 0.00025701522827148
SELECT id FROM categories WHERE parent_id = '81'
83 0.0025 0.0025022029876709
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 
84 0.0001 0.00014901161193848
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 
85 0.0001 0.00014710426330566
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 
86 0.0002 0.00015783309936523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
87 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
88 0.0025 0.0024509429931641
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
89 0.0003 0.00025486946105957
SELECT id FROM categories WHERE parent_id = '31'
90 0.0025 0.0024800300598145
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 
91 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 (31)
				  AND p.disabled = 0 
92 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 (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
93 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
94 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
95 0.0022 0.0022439956665039
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
96 0.0003 0.00026512145996094
SELECT id FROM categories WHERE parent_id = '66'
97 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '131'
98 0.0028 0.0028209686279297
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 
99 0.0002 0.00015521049499512
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 
100 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 (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
101 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
102 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
103 0.0095 0.0094921588897705
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
104 0.0003 0.00027990341186523
SELECT id FROM categories WHERE parent_id = '34'
105 0.0002 0.00020384788513184
SELECT id FROM categories WHERE parent_id = '94'
106 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '98'
107 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '99'
108 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '110'
109 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '130'
110 0.0104 0.010362863540649
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 
111 0.0002 0.00017499923706055
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 
112 0.0002 0.00015616416931152
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
113 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
114 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
115 0.0016 0.0015559196472168
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
116 0.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '32'
117 0.0016 0.0015881061553955
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 
118 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 (32)
				  AND p.disabled = 0 
119 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 (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
120 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
121 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
122 0.0018 0.00180983543396
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
123 0.0003 0.00025486946105957
SELECT id FROM categories WHERE parent_id = '89'
124 0.0018 0.0018329620361328
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 
125 0.0002 0.0001530647277832
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 
126 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 (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
127 0.0002 0.00016617774963379
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
128 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
129 0.0004 0.00038981437683105
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
130 0.0007 0.00068211555480957
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
131 0.0002 0.00022792816162109
SELECT id FROM categories WHERE parent_id = '84'
132 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 
133 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 
134 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 
135 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
136 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '17'
137 0.0007 0.0006871223449707
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
138 0.0002 0.00024509429931641
SELECT id FROM categories WHERE parent_id = '90'
139 0.0007 0.00071597099304199
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 
140 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 
141 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 (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
142 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
143 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '17'
144 0.0003 0.00028896331787109
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
145 0.0020 0.0020151138305664
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
146 0.0002 0.00024890899658203
SELECT id FROM categories WHERE parent_id = '92'
147 0.0020 0.0020339488983154
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 
148 0.0001 0.00014591217041016
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 
149 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 (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
150 0.0001 0.00014781951904297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
151 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '20'
152 0.0054 0.0053930282592773
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
153 0.0004 0.00037598609924316
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
154 0.0002 0.0002129077911377
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
155 0.0002 0.00016307830810547
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
156 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '67'
157 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '82'
158 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '84'
159 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '94'
160 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '116'
161 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '52'
162 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '135'
163 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '245'
164 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '269'
165 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '275'
166 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '280'
167 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '357'
168 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '379'
169 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '401'
170 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '450'
171 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '454'
172 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '457'
173 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '458'
174 0.0002 0.00015401840209961
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
175 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '41'
176 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '43'
177 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '44'
178 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '68'
179 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '80'
180 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '85'
181 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '97'
182 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '107'
183 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '108'
184 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '128'
185 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '133'
186 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '148'
187 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '217'
188 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '228'
189 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '257'
190 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '271'
191 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '286'
192 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '287'
193 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '291'
194 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '380'
195 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '344'
196 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '354'
197 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '363'
198 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '364'
199 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '368'
200 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '369'
201 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '400'
202 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '463'
203 0.0002 0.00016498565673828
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
204 0.0003 0.00028395652770996
SELECT * FROM pages WHERE id = '66'
205 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '77'
206 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '90'
207 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '414'
208 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '119'
209 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '406'
210 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '149'
211 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '150'
212 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '412'
213 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '162'
214 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '164'
215 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '167'
216 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '180'
217 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '187'
218 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '265'
219 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '268'
220 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '411'
221 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '290'
222 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '413'
223 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '409'
224 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '327'
225 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '336'
226 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '351'
227 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '358'
228 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '360'
229 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '362'
230 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '366'
231 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '370'
232 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '377'
233 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '386'
234 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '408'
235 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '415'
236 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '416'
237 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '419'
238 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '423'
239 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '427'
240 0.0002 0.00018882751464844
SELECT * FROM pages WHERE id = '428'
241 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = '432'
242 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '433'
243 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '436'
244 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '437'
245 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '461'
246 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '464'
247 0.0001 0.00014710426330566
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
248 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '74'
249 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '137'
250 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '145'
251 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '156'
252 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '407'
253 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '410'
254 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '266'
255 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '316'
256 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '332'
257 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '334'
258 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '367'
259 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '387'
260 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '389'
261 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '397'
262 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '449'
263 0.0002 0.00016188621520996
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
264 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '42'
265 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '79'
266 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '86'
267 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '95'
268 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '102'
269 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '109'
270 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '114'
271 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '121'
272 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '138'
273 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '142'
274 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '62'
275 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '157'
276 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '246'
277 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '276'
278 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '278'
279 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '279'
280 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '317'
281 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '405'
282 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '343'
283 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '345'
284 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '346'
285 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '347'
286 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '348'
287 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '349'
288 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '381'
289 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '392'
290 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '393'
291 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '394'
292 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '395'
293 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '399'
294 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '421'
295 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '426'
296 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '430'
297 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '431'
298 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '434'
299 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '435'
300 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '440'
301 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '441'
302 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '451'
303 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '453'
304 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
305 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '146'
306 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '158'
307 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '163'
308 0.0002 0.000244140625
SELECT * FROM pages WHERE id = '293'
309 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '340'
310 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '417'
311 0.0001 0.00013995170593262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
312 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '173'
313 0.0002 0.00016522407531738
SELECT * FROM pages WHERE id = '181'
314 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '288'
315 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '299'
316 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '300'
317 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '383'
318 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '385'
319 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '438'
320 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '442'
321 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
322 0.0002 0.00023698806762695
SELECT * FROM pages WHERE id = '103'
323 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '134'
324 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '139'
325 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '143'
326 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '234'
327 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '248'
328 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '260'
329 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '398'
330 0.0002 0.0001530647277832
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
331 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '61'
332 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '87'
333 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '104'
334 0.0002 0.00022792816162109
SELECT * FROM pages WHERE id = '115'
335 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '124'
336 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '144'
337 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '151'
338 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '199'
339 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '200'
340 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '304'
341 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '321'
342 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '333'
343 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '350'
344 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '378'
345 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '422'
346 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '425'
347 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '443'
348 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '444'
349 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '445'
350 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '446'
351 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '447'
352 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '448'
353 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '455'
354 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '456'
355 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '459'
356 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '460'
357 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '462'
358 0.0001 0.00014185905456543
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
359 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '153'
360 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '182'
361 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '238'
362 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '240'
363 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '242'
364 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '252'
365 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '253'
366 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '262'
367 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '267'
368 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '420'
369 0.0001 0.00013113021850586
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
370 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
371 0.0001 0.00011682510375977
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
372 0.0013 0.0013439655303955
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
373 0.0003 0.00029492378234863
SELECT * FROM pages WHERE pagename = 'shooting-up-and-down-hill'
374 0.0003 0.00027012825012207
SELECT * FROM products WHERE id = '180451'
375 0.0003 0.00027704238891602
SELECT * FROM productimages WHERE product_id = '180451' ORDER BY sortorder ASC
376 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '180451'
377 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '180451'
378 0.0027 0.0027449131011963
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '180451' AND a.name = n.originalname
379 0.0002 0.00019717216491699
SELECT * FROM productoffers WHERE product_id = '180451' AND merchantid = 'ATVPDKIKX0DER'
380 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '180451' AND price > 0
                ORDER BY price ASC LIMIT 1
381 0.0004 0.00040411949157715
SELECT value FROM productattributes WHERE product_id = '180451' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
382 0.0001 0.00013494491577148
UPDATE products SET price = '7500' WHERE id = '180451'
383 0.0003 0.00030803680419922
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '180451' ORDER BY timestamp DESC
384 0.0002 0.00018501281738281
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
385 0.0002 0.00017809867858887
INSERT INTO ga_users (`ips`) SELECT 'a:1:{i:0;s:14:\"54.226.102.115\";}'
386 0.0001 0.00013899803161621
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1560878754'
387 0.0001 0.00013399124145508
INSERT INTO tracker_action (`gauser_id`, `gasession_id`, `action`, `notes`, `timestamp`) SELECT '139501', '140436', 'basket_view', '', '1560878754'
388 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = 2
389 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 4
390 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 12
391 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 10
392 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = 7
393 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 18
394 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = 28
395 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = 13
396 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 3
397 0.0424 0.042435884475708
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
398 0.0002 0.00022602081298828
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:1560878754;s:8:\"products\";a:6:{i:4;s:6:\"290575\";i:5;s:6:\"171938\";i:8;s:6:\"412927\";i:19;s:6:\"408078\";i:23;s:6:\"408079\";i:0;s:6:\"414940\";}}' WHERE id = '175'
399 0.0004 0.00044107437133789
SELECT * FROM products WHERE id IN (290575,171938,412927,408078,408079,414940) ORDER BY FIELD(id, 290575,171938,412927,408078,408079,414940 )
400 0.0006 0.0005950927734375
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
401 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '290575'
402 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '290575'
403 0.0034 0.0034291744232178
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
404 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
405 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
406 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
407 0.0001 0.00011992454528809
UPDATE products SET price = '549500' WHERE id = '290575'
408 0.0006 0.00061607360839844
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
409 0.0002 0.00022077560424805
SELECT * FROM product_image_select WHERE product_id = '171938'
410 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '171938'
411 0.0026 0.0025749206542969
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
412 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
413 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
414 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
415 0.0001 0.00011897087097168
UPDATE products SET price = '389500' WHERE id = '171938'
416 0.0003 0.00025415420532227
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
417 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '412927'
418 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '412927'
419 0.0037 0.0036759376525879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
420 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0001 0.00012016296386719
UPDATE products SET price = '199900' WHERE id = '412927'
424 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
425 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '408078'
426 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408078'
427 0.0031 0.0030961036682129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
428 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
429 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
430 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
431 0.0001 0.00011897087097168
UPDATE products SET price = '23352' WHERE id = '408078'
432 0.0002 0.00017380714416504
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
433 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '408079'
434 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '408079'
435 0.0032 0.0032119750976562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
436 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
437 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
438 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
439 0.0001 0.00011897087097168
UPDATE products SET price = '18547' WHERE id = '408079'
440 0.0002 0.00017499923706055
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
441 0.0002 0.00020718574523926
SELECT * FROM product_image_select WHERE product_id = '414940'
442 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '414940'
443 0.0032 0.0032470226287842
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
444 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
445 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
446 0.0004 0.00044107437133789
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
447 0.0001 0.00011801719665527
UPDATE products SET price = '4490' WHERE id = '414940'
448 0.0421 0.042078018188477
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
449 0.0002 0.00021481513977051
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:1560878755;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:2;s:6:\"398858\";i:5;s:6:\"171938\";i:6;s:6:\"170197\";i:7;s:6:\"404554\";i:11;s:6:\"402983\";}}' WHERE id = '177'
450 0.0004 0.00043296813964844
SELECT * FROM products WHERE id IN (398315,398858,171938,170197,404554,402983) ORDER BY FIELD(id, 398315,398858,171938,170197,404554,402983 )
451 0.0002 0.00021481513977051
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
452 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '398315'
453 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '398315'
454 0.0026 0.0025589466094971
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
455 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
456 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
457 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
458 0.0001 0.00012302398681641
UPDATE products SET price = '1999' WHERE id = '398315'
459 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
460 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '398858'
461 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '398858'
462 0.0031 0.0030560493469238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
463 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
464 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
465 0.0004 0.00041985511779785
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
466 0.0001 0.00011801719665527
UPDATE products SET price = '2999' WHERE id = '398858'
467 0.0006 0.00061321258544922
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
468 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '171938'
469 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '171938'
470 0.0026 0.0025560855865479
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
471 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
472 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
473 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
474 0.0001 0.00011992454528809
UPDATE products SET price = '389500' WHERE id = '171938'
475 0.0006 0.00064706802368164
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
476 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '170197'
477 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '170197'
478 0.0032 0.0031919479370117
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
479 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
480 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
481 0.0004 0.00041103363037109
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
482 0.0001 0.00011777877807617
UPDATE products SET price = '324500' WHERE id = '170197'
483 0.0003 0.00026798248291016
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
484 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '404554'
485 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '404554'
486 0.0034 0.0033528804779053
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
487 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
488 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
489 0.0004 0.00044393539428711
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
490 0.0001 0.00011801719665527
UPDATE products SET price = '399999' WHERE id = '404554'
491 0.0002 0.00020480155944824
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
492 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '402983'
493 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '402983'
494 0.0022 0.0022480487823486
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
495 0.0002 0.00018620491027832
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
496 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
497 0.0003 0.00034999847412109
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
498 0.0001 0.00012302398681641
UPDATE products SET price = '10392' WHERE id = '402983'
499 0.1032 0.10316205024719
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
500 0.0003 0.0002598762512207
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:1560878755;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:6;s:6:\"170197\";i:7;s:6:\"404554\";i:8;s:6:\"412927\";i:9;s:6:\"409759\";i:14;s:6:\"414825\";}}' WHERE id = '181'
501 0.0005 0.00046801567077637
SELECT * FROM products WHERE id IN (398315,170197,404554,412927,409759,414825) ORDER BY FIELD(id, 398315,170197,404554,412927,409759,414825 )
502 0.0002 0.00022697448730469
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
503 0.0002 0.00022220611572266
SELECT * FROM product_image_select WHERE product_id = '398315'
504 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '398315'
505 0.0025 0.0025219917297363
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
506 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
507 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
508 0.0004 0.00038313865661621
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
509 0.0001 0.00013494491577148
UPDATE products SET price = '1999' WHERE id = '398315'
510 0.0006 0.00064206123352051
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
511 0.0002 0.00024199485778809
SELECT * FROM product_image_select WHERE product_id = '170197'
512 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '170197'
513 0.0032 0.0031900405883789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
514 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
515 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
516 0.0004 0.0004119873046875
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
517 0.0001 0.00011897087097168
UPDATE products SET price = '324500' WHERE id = '170197'
518 0.0003 0.00026416778564453
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
519 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '404554'
520 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '404554'
521 0.0034 0.0034019947052002
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
522 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
523 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
524 0.0004 0.0004417896270752
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
525 0.0001 0.00011777877807617
UPDATE products SET price = '399999' WHERE id = '404554'
526 0.0003 0.00026202201843262
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
527 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '412927'
528 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '412927'
529 0.0037 0.0036928653717041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
530 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
531 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
532 0.0005 0.00045990943908691
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
533 0.0001 0.00011992454528809
UPDATE products SET price = '199900' WHERE id = '412927'
534 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
535 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '409759'
536 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '409759'
537 0.0028 0.0027868747711182
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
538 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
539 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
540 0.0004 0.00039410591125488
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
541 0.0001 0.00012111663818359
UPDATE products SET price = '229000' WHERE id = '409759'
542 0.0002 0.00020909309387207
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
543 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '414825'
544 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '414825'
545 0.0020 0.0020089149475098
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
546 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
547 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
548 0.0004 0.00037312507629395
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
549 0.0001 0.00011897087097168
UPDATE products SET price = '11999' WHERE id = '414825'
550 0.1024 0.10239911079407
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
551 0.0003 0.00027179718017578
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:1560878755;s:8:\"products\";a:6:{i:3;s:6:\"407595\";i:9;s:6:\"409759\";i:19;s:6:\"408078\";i:1;s:6:\"398315\";i:2;s:6:\"398858\";i:11;s:6:\"402983\";}}' WHERE id = '183'
552 0.0005 0.00047707557678223
SELECT * FROM products WHERE id IN (407595,409759,408078,398315,398858,402983) ORDER BY FIELD(id, 407595,409759,408078,398315,398858,402983 )
553 0.0003 0.0002589225769043
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
554 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '407595'
555 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '407595'
556 0.0034 0.0033888816833496
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
557 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
558 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
559 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
560 0.0001 0.00011992454528809
UPDATE products SET price = '2497' WHERE id = '407595'
561 0.0002 0.00021886825561523
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
562 0.0002 0.00021982192993164
SELECT * FROM product_image_select WHERE product_id = '409759'
563 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '409759'
564 0.0028 0.0027930736541748
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
565 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
566 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
567 0.0004 0.00040388107299805
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
568 0.0001 0.0001220703125
UPDATE products SET price = '229000' WHERE id = '409759'
569 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
570 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '408078'
571 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '408078'
572 0.0031 0.0030782222747803
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
573 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
574 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
575 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
576 0.0001 0.00012016296386719
UPDATE products SET price = '23352' WHERE id = '408078'
577 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
578 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '398315'
579 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '398315'
580 0.0025 0.0025181770324707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
581 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
582 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
583 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
584 0.0001 0.00012016296386719
UPDATE products SET price = '1999' WHERE id = '398315'
585 0.0002 0.00018405914306641
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
586 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '398858'
587 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '398858'
588 0.0030 0.003026008605957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
589 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
590 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
591 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
592 0.0001 0.00012707710266113
UPDATE products SET price = '2999' WHERE id = '398858'
593 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
594 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '402983'
595 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '402983'
596 0.0023 0.002255916595459
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
597 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
598 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
599 0.0003 0.00034689903259277
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
600 0.0001 0.0001218318939209
UPDATE products SET price = '10392' WHERE id = '402983'
601 0.0004 0.00040197372436523
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
602 0.0001 0.00013184547424316
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0001 0.00013184547424316
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
604 0.0001 0.00014114379882812
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
605 0.0004 0.00039410591125488
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
606 0.0001 0.00012612342834473
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
607 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
608 0.0009 0.00090599060058594
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
609 0.0003 0.00030994415283203
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
610 0.0003 0.00027918815612793
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
611 0.0003 0.00026512145996094
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
612 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = 2
613 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 4
614 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 12
615 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 10
616 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = 7
617 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = 18
618 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 28
619 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 13
620 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 3
621 0.0424 0.042424201965332
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
622 0.0002 0.00023698806762695
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:1560878755;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:2;s:6:\"398858\";i:5;s:6:\"171938\";i:7;s:6:\"404554\";i:10;s:6:\"408792\";i:11;s:6:\"402983\";}}' WHERE id = '175'
623 0.0004 0.00044488906860352
SELECT * FROM products WHERE id IN (414940,398858,171938,404554,408792,402983) ORDER BY FIELD(id, 414940,398858,171938,404554,408792,402983 )
624 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
625 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '414940'
626 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '414940'
627 0.0033 0.0032589435577393
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
628 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
629 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
630 0.0004 0.00042915344238281
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
631 0.0001 0.00012993812561035
UPDATE products SET price = '4490' WHERE id = '414940'
632 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
633 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '398858'
634 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '398858'
635 0.0030 0.0030300617218018
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
636 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
637 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
638 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
639 0.0001 0.00011682510375977
UPDATE products SET price = '2999' WHERE id = '398858'
640 0.0006 0.00062704086303711
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
641 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '171938'
642 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '171938'
643 0.0026 0.0025508403778076
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
644 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
645 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
646 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
647 0.0001 0.00012016296386719
UPDATE products SET price = '389500' WHERE id = '171938'
648 0.0003 0.00026798248291016
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
649 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '404554'
650 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '404554'
651 0.0034 0.0033729076385498
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
652 0.0002 0.00018119812011719
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
653 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
654 0.0004 0.00043988227844238
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
655 0.0001 0.00011801719665527
UPDATE products SET price = '399999' WHERE id = '404554'
656 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
657 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '408792'
658 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '408792'
659 0.0036 0.0035829544067383
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
660 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
661 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
662 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
663 0.0001 0.00012779235839844
UPDATE products SET price = '13499' WHERE id = '408792'
664 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
665 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '402983'
666 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '402983'
667 0.0023 0.0022518634796143
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
668 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
669 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
670 0.0003 0.00034809112548828
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
671 0.0001 0.00012302398681641
UPDATE products SET price = '10392' WHERE id = '402983'
672 0.0421 0.04210901260376
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
673 0.0002 0.00021505355834961
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:1560878755;s:8:\"products\";a:6:{i:3;s:6:\"407595\";i:5;s:6:\"171938\";i:8;s:6:\"412927\";i:11;s:6:\"402983\";i:16;s:6:\"406758\";i:18;s:6:\"147874\";}}' WHERE id = '177'
674 0.0004 0.00043296813964844
SELECT * FROM products WHERE id IN (407595,171938,412927,402983,406758,147874) ORDER BY FIELD(id, 407595,171938,412927,402983,406758,147874 )
675 0.0002 0.00024914741516113
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
676 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '407595'
677 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '407595'
678 0.0034 0.003364086151123
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
679 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
680 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
681 0.0004 0.0004270076751709
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
682 0.0001 0.00011992454528809
UPDATE products SET price = '2497' WHERE id = '407595'
683 0.0006 0.00061798095703125
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
684 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '171938'
685 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '171938'
686 0.0026 0.0025639533996582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
687 0.0002 0.00020909309387207
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
688 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
689 0.0004 0.00038385391235352
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
690 0.0001 0.00011801719665527
UPDATE products SET price = '389500' WHERE id = '171938'
691 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
692 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '412927'
693 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '412927'
694 0.0037 0.003673791885376
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
695 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
696 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
697 0.0005 0.0004580020904541
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
698 0.0001 0.00012087821960449
UPDATE products SET price = '199900' WHERE id = '412927'
699 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
700 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '402983'
701 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '402983'
702 0.0023 0.0022530555725098
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
703 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
704 0.0002 0.00020623207092285
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
705 0.0004 0.00035595893859863
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
706 0.0001 0.00012397766113281
UPDATE products SET price = '10392' WHERE id = '402983'
707 0.0002 0.00018882751464844
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
708 0.0002 0.00021219253540039
SELECT * FROM product_image_select WHERE product_id = '406758'
709 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '406758'
710 0.0026 0.0026180744171143
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
711 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
712 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
713 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
714 0.0001 0.00012111663818359
UPDATE products SET price = '2694' WHERE id = '406758'
715 0.0002 0.00018787384033203
SELECT * FROM productimages WHERE product_id = '147874' ORDER BY sortorder ASC
716 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '147874'
717 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '147874'
718 0.0028 0.002824068069458
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '147874' AND a.name = n.originalname
719 0.0002 0.00019383430480957
SELECT * FROM productoffers WHERE product_id = '147874' AND merchantid = 'ATVPDKIKX0DER'
720 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '147874' AND price > 0
                ORDER BY price ASC LIMIT 1
721 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '147874' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
722 0.0001 0.00011706352233887
UPDATE products SET price = '599' WHERE id = '147874'
723 0.1029 0.1028790473938
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
724 0.0003 0.00027108192443848
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:1560878755;s:8:\"products\";a:6:{i:6;s:6:\"170197\";i:10;s:6:\"408792\";i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:4;s:6:\"290575\";i:16;s:6:\"406758\";}}' WHERE id = '181'
725 0.0004 0.00044107437133789
SELECT * FROM products WHERE id IN (170197,408792,414940,398315,290575,406758) ORDER BY FIELD(id, 170197,408792,414940,398315,290575,406758 )
726 0.0007 0.00066685676574707
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
727 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '170197'
728 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '170197'
729 0.0032 0.0032098293304443
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
730 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
731 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
732 0.0004 0.00042915344238281
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
733 0.0001 0.0001218318939209
UPDATE products SET price = '324500' WHERE id = '170197'
734 0.0002 0.00019979476928711
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
735 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '408792'
736 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '408792'
737 0.0036 0.0036110877990723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
738 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
739 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
740 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
741 0.0001 0.00011706352233887
UPDATE products SET price = '13499' WHERE id = '408792'
742 0.0002 0.00017404556274414
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
743 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '414940'
744 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '414940'
745 0.0033 0.0032548904418945
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
746 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
747 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
748 0.0004 0.00042510032653809
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
749 0.0001 0.00011801719665527
UPDATE products SET price = '4490' WHERE id = '414940'
750 0.0002 0.0001981258392334
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
751 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '398315'
752 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '398315'
753 0.0025 0.002485990524292
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
754 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
755 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
756 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
757 0.0001 0.00011992454528809
UPDATE products SET price = '1999' WHERE id = '398315'
758 0.0006 0.00057697296142578
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
759 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '290575'
760 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '290575'
761 0.0034 0.0034060478210449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
762 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
763 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
764 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
765 0.0001 0.00012016296386719
UPDATE products SET price = '549500' WHERE id = '290575'
766 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
767 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '406758'
768 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '406758'
769 0.0026 0.0026071071624756
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
770 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
771 0.0002 0.00019979476928711
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
772 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
773 0.0001 0.00011897087097168
UPDATE products SET price = '2694' WHERE id = '406758'
774 0.1027 0.10273814201355
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
775 0.0003 0.00026893615722656
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:1560878755;s:8:\"products\";a:6:{i:3;s:6:\"407595\";i:8;s:6:\"412927\";i:11;s:6:\"402983\";i:20;s:6:\"405644\";i:22;s:6:\"410949\";i:0;s:6:\"414940\";}}' WHERE id = '183'
776 0.0005 0.0004730224609375
SELECT * FROM products WHERE id IN (407595,412927,402983,405644,410949,414940) ORDER BY FIELD(id, 407595,412927,402983,405644,410949,414940 )
777 0.0002 0.00024604797363281
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
778 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '407595'
779 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '407595'
780 0.0034 0.0033919811248779
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
781 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
782 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
783 0.0004 0.00044083595275879
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
784 0.0001 0.0001220703125
UPDATE products SET price = '2497' WHERE id = '407595'
785 0.0003 0.00025415420532227
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
786 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '412927'
787 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '412927'
788 0.0037 0.0036830902099609
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
789 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
790 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
791 0.0004 0.00043988227844238
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
792 0.0001 0.00011992454528809
UPDATE products SET price = '199900' WHERE id = '412927'
793 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
794 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '402983'
795 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '402983'
796 0.0022 0.0022468566894531
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
797 0.0002 0.00019478797912598
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
798 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
799 0.0003 0.00034618377685547
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
800 0.0001 0.00012302398681641
UPDATE products SET price = '10392' WHERE id = '402983'
801 0.0002 0.00018000602722168
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
802 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '405644'
803 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '405644'
804 0.0034 0.0033729076385498
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
805 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
806 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
807 0.0004 0.00042510032653809
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
808 0.0001 0.00011801719665527
UPDATE products SET price = '63539' WHERE id = '405644'
809 0.0002 0.00017189979553223
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
810 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '410949'
811 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '410949'
812 0.0027 0.0026938915252686
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
813 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
814 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
815 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
816 0.0001 0.00012898445129395
UPDATE products SET price = '47995' WHERE id = '410949'
817 0.0002 0.00017499923706055
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
818 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '414940'
819 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '414940'
820 0.0032 0.0032279491424561
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
821 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
822 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
823 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
824 0.0001 0.00011801719665527
UPDATE products SET price = '4490' WHERE id = '414940'
825 0.0004 0.00040006637573242
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
826 0.0001 0.00013089179992676
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
827 0.0001 0.00012612342834473
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
828 0.0001 0.00012111663818359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
829 0.0004 0.00038981437683105
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
830 0.0001 0.00012493133544922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
831 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
832 0.0009 0.00090312957763672
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
833 0.0003 0.00030398368835449
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
834 0.0003 0.00028800964355469
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
835 0.0004 0.00038695335388184
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
836 0.0002 0.00015616416931152
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
837 0.0001 0.00013899803161621
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
838 0.0001 0.0001380443572998
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
839 0.0001 0.00014209747314453
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
840 0.0001 0.00013494491577148
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
841 0.0004 0.00036811828613281
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
842 0.0003 0.00034713745117188
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'