Tactical Equipment - Survivalist Equipment
   

Handgun Shooting In Combat : : The Real Deal

Videoing shooting techniques training

I WISH I HAD ATTENDED THIS COURSE SOONER

UPDATED :  

You can't swing a dead cat without hitting half a dozen guys that are willing to teach you how to shoot (for a small fee, of course). I've had the good fortune to attend fantastic firearms training provided by the Special Forces community as well as a number of civilian courses from the most recognized instructors in the industry. The two days I spent pistol shooting with John McPhee of Sheriff of Baghdad Tactical were more efficient and productive than the SF training and light years ahead of almost everything else I've seen on the civilian side.

EXPERIENCE and technique

McPhee is a 20-plus year veteran of the Special Operations community. In and of itself, that is not an indicator of firearms instructor competence. I served along-side a lot of guys that were great folks, but not necessarily a ninja when it came time to shoot.

The majority of McPhee's service was with Delta Force. Service in that unit is impossible without serious shooting ability. The sheer number of rounds fired and hours of dry-fire practice, all under the watchful eyes of an instructor or fellow operator, make it impossible to hide if you cannot perform. Live that life for a decade or two, and a guy walks away knowing how to shoot.

Filming in progress:

What makes McPhee's approach different from what's usually available is the intense one-on-one assessment he provides. McPhee's pistol course began with a small number of students on the firing line. One by one, he filmed each student drawing the pistol, firing two rounds at the target, reloading and firing a final two rounds. The entire class then moved back to the informal classroom, where we stayed until lunchtime.

It was in his classroom where the majority of learning occurred. So many students and instructors think that firing a ton of rounds is how to get better at shooting. This is absolutely not the case. Blasting ammunition is good for bragging rights and offers an easily quantifiable metric of work done, but it is no measure of whether or not the student improves.

McPhee takes students, one at a time, and reviews the slow-motion video of their shooting performance. The morning's first and only shooting drill lasLs about five seconds but is plenty of material for McPhee to work with. The drill is broken down into four categories: stance, presentation, grip and reload.

McPhee has a TV set up in the classroom and reviews each student's video with them in front of the rest of the students. Being able to see your performance on screen and in slow motion provides an enhanced degree of understanding. I can't tell you how often I've reviewed and practiced the draw sequence with a pistol. I can break it down into four steps and explain in detail exactly what needs to happen. I even thought that I had a pretty good draw prior to attending this course. No other instructor has ever watched my presentation and said anything other than, "Looks good."

Shooting while moving techniques

ABOVE : Just when students are getting comfortable with the basics, it's time to start shooting and moving.

The video of my draw sequence showed a different reality. Where I thought my movement was efficient, the video showed I rocked back prior to grabbing my pistol, pulled my strong arm elbow way too high in the air to clear my holster and then dropped my gun below my line of sight instead of pushing it out straight toward the target. I remember the details because I still have the video and review it often.

Those types of details are vitally important to improving shooting performance, but they are only visible to the student and instructor if there's video both can review. It also takes an instructor who knows what they're doing to spot the problems and offer detailed corrections on what needs to change and why. McPhee always covers both.

12 years. I shot pistols competitively in college and in a few informal competitions in the U.S. Army. Where 1 really learned how to shoot was in a two-month CQB (close quarters battle) program that Special Forces runs for Green Berets assigned to the counterterrorism mission. I attended that course in 2004 and learned more about how to shoot a pistol than at any other time in my life.

I still remember an instructor standing in front of the student body saying, "We are going to teach you how to shoot a pistol because you will learn that skill nowhere else in the military." He was right. Every student learned to shoot a pistol well or they were removed from training.

My class staned with 56 Green Berets, and 32 finished. Of the five captains that started the class, only two of us made it to the end. It was an incredibly stressful but fantastically informative experience. My pistol shooting ability has remained relatively unchanged since that time.

Knowing what to fix. Part of the reason for my plateau is that I could never get a good read on what I needed to fix or why I needed to fix it. It's hard enough to find knowledgeable instructors, but then it takes one-on-one tutelage to diagnose any problems. Also, pistol shooting happens quickly. A semiautomatic pistol fires and cycles in a fraction of a second, so the human eye is going to miss a lot of what's really happening.

Post video

Hundgun shooting debriefingThe first morning of reviewing videos in the classroom was a highly informative learning experience unlike anything the author has been exposed to in the shooting world.

The first morning in the classroom was time well spent, but the afternoon session was out on the range correcting the deficiencies identified earlier. McPhee keeps classes small so that he can spend time with each student on the line to ensure they're applying what he taught during the video review He has a number of drills to test each portion of the drawing and firing sequence.

I wanted to work on my stance a little to make sure that I leaned forward enough and really wanted to practice getting my thumbs in the right position to set up the correct grip on the pistol. The afternoon session featured drills from various yard lines. Closer drills emphasized speed and recoil management, and the long distances worked on accuracy.

The second day started with more video, but the debriefing each student received was shorter. These videos were to check student progression and incorporated new drills that tested new skills. While day one was all about sound fundamentals, day two moved into more advanced skills.

One of the day-two skills that stood out was quickly engaging multiple targets. McPhee had students load up and then shoot two to three targets as fast as they could. He taught students to move their eyes from the first target to the second as soon as they finish the last shots on target one but prior to moving the pistol to target two. The eyes should get to target two before the firearm does.

Handgun shooting training techniques

ABOVE : McPhee places marks on the author's hand and pistol to facilitate a quick alignment check once the gun comes out of the holster. This fixes incorrect draw geometry.

This skill is hard to critique without video that can be replayed in slow motion. The concept wasn't new to me, but it was seeing myself perform the task that really helped improve my speed. In the video, shot target one, quickly moved my eyes to target two, and then moved my eyes back to the pistol just before it got to target two. This costs me time and defeats the whole purpose of moving the eyes ahead of the firearm.

While video is a unique and immensely valuable aspect of McPhee's instruction, he also uses some good old-fashioned training techniques to drive home lessons.

We spent a fair amount of time covering shooting on the move with a pistol. This helps pull some of the focus away from what should be the basics and has a way of making students work harder to do simple tasks. As soon as students had to shoot on the move, the basics we worked on suddenly became much harder.

Best takeaways EVER

Combat shooting realitiesMcPhee coaches forward-leaning body position to ensure the pistol doesn't move the shooter around.

McPhee sends each student home with the video critiques he made in class. The most valuable videos are the ones from the first morning because this is where he goes in-depth diagnosing each student's problems and what needs to happen to fix them.

Each video McPhee makes includes his verbal observations and notes, along with his corrections drawn into the actual video, much like a coach using a whiteboard. Students can go back and review those videos any time they want, and it'sjust like sitting next to McPhee in the classroom as he walks you through it.

The most telling comment came from Barry Dueck, one of the nation's top 3-Gun competitors. Dueck knows how to shoot. At one point during the first morning in the classroom, Dueck looked at me and said, "This is going to change so much about how I shoot." I figured if a guy like Dueck was finding areas in which he needed to improve, I was probably in the right spot. After seeing my performance gains two days later, I knew I was.


SHOOTING STANCE

Handgun shooting stance

It's important to get your body weight forward over the balls of your feet, not just crouch and tilt the upper body forward.

A good position allows the shooter to stand with their toes 6 inches from the wall and still have their forehead touching the wall.

These were tips specific to me and also, general reccomendations.

Each individual will have different position normalities dependant on body size, weight and structure.

That is why it becomes so important to have a professional view your proceedure and even record it for analysis.

 

SHOOTING PRESENTATION

Shooting presentation

The pistol should be taken out of the holster, moved quickly to the center of the chest and pushed straight out to the target.

This allows the shooter to see the sights as early as possible and get them lined up for a quick shot.

One tip is to put the support hand high in the center of the chest so that the shooting hand can move the pistol quickly to it.

The support hand acts as a consistent destination for the drawn pistol and allows for faster presentation.

 

SHOOTING GRIP

Handgun tactical shooting grip

The shooting hand's thumb should be completely relaxed and pointed up at a 45-degree angle.

This allows the support hand to get high up on the grip with the palm rolled completely forward, locking the wrist in position.

Recoil management is much easier this way because the support arm will be straight and directly behind the gun.

 

HANDGUN RELOAD

Reloading handgun combat shooting

Get on the magazine release as soon as the support hand comes off the gun.

Pull the pistol straight back toward your face and keep it at eye level.

This allows the shooter to maintain situational awareness while getting a new magazine into the magazine well.

Keeping your weapon "live" is equally important as being able to make shots count. Many people do not put emphasis on the reload but rather the shooting.

While TV hype will have us beleive that in a shoot out, when your enemy is reloading, you have a chance to attack or flee, in reality, the time to reload should be that minimal that it does not interfere with your need to place shots in any given situation.

Practice, repeat, and practice again. Make reloading second nature!

 

John McPhee : : BIO

John Mc Phee Special Forces Training

Retired Sgt. Maj.John McPhee served a distinguished career in the U.S. Army Special Operations for over 20 years, retiring in 2011.

McPhee has spent his adult life in Special Operations and Special Mission Units (SMUs).

He has trained countless U.S. Special Operations Forces, thousands of international Tier 1 Operators and special forces around the world.

He is one of a handful of operators with over a decade of combat experience, having served in multiple theaters from Bosnia and South America to recent war efforts in Iraq and Afghanistan.

McPhee's experience and skill set make him uniquely qualified to instruct on a wide range of topics beyond small arms marksmanship. For more information, visit sobtactical.com.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.2535212039948 604 0.5818 0


No Amazon API Requests Made.


App Debug - Total Time 1.2535212039948 seconds

Number Time From Start Name Description
1 0.41212511062622 Initialise Initialise FSB Function
2 0.43908715248108 App Controller Start Start of the App controller (called before the controller of every page)
3 0.45027303695679 Start of getCategoryListByGroup Function Before first category groups query
4 0.45044016838074 After initial query Before first category groups query
5 0.45044207572937 Get Category List for Group Before the call to getCategoryList function
6 0.45044612884521 Start of GetCategoryList function Start of the function
7 0.45044898986816 Before getting categories Query to get specific category list
8 0.45105814933777 After getting categories Query to get specific category list
9 0.45105910301208 Before getting category custom Before call to function getCategoryCustom
10 0.45290613174438 After getting category custom After call to function getCategoryCustom
11 0.45290803909302 Before getting category custom Before call to function getCategoryCustom
12 0.4633960723877 After getting category custom After call to function getCategoryCustom
13 0.46339797973633 Before getting category custom Before call to function getCategoryCustom
14 0.46890807151794 After getting category custom After call to function getCategoryCustom
15 0.46890997886658 Before getting category custom Before call to function getCategoryCustom
16 0.47295904159546 After getting category custom After call to function getCategoryCustom
17 0.47296118736267 End of GetCategoryList function End of the function
18 0.4729700088501 Get Category List for Group Before the call to getCategoryList function
19 0.47297215461731 Start of GetCategoryList function Start of the function
20 0.47297501564026 Before getting categories Query to get specific category list
21 0.47340416908264 After getting categories Query to get specific category list
22 0.47340607643127 Before getting category custom Before call to function getCategoryCustom
23 0.47883796691895 After getting category custom After call to function getCategoryCustom
24 0.47884106636047 Before getting category custom Before call to function getCategoryCustom
25 0.48930597305298 After getting category custom After call to function getCategoryCustom
26 0.48930811882019 End of GetCategoryList function End of the function
27 0.48931407928467 Get Category List for Group Before the call to getCategoryList function
28 0.4893159866333 Start of GetCategoryList function Start of the function
29 0.48931813240051 Before getting categories Query to get specific category list
30 0.4900541305542 After getting categories Query to get specific category list
31 0.49005603790283 Before getting category custom Before call to function getCategoryCustom
32 0.49911117553711 After getting category custom After call to function getCategoryCustom
33 0.49911308288574 Before getting category custom Before call to function getCategoryCustom
34 0.51617908477783 After getting category custom After call to function getCategoryCustom
35 0.51618099212646 Before getting category custom Before call to function getCategoryCustom
36 0.52200317382812 After getting category custom After call to function getCategoryCustom
37 0.52201509475708 Before getting category custom Before call to function getCategoryCustom
38 0.52786207199097 After getting category custom After call to function getCategoryCustom
39 0.52786612510681 Before getting category custom Before call to function getCategoryCustom
40 0.5346040725708 After getting category custom After call to function getCategoryCustom
41 0.53460717201233 Before getting category custom Before call to function getCategoryCustom
42 0.55623507499695 After getting category custom After call to function getCategoryCustom
43 0.55623817443848 Before getting category custom Before call to function getCategoryCustom
44 0.56028008460999 After getting category custom After call to function getCategoryCustom
45 0.56028199195862 Before getting category custom Before call to function getCategoryCustom
46 0.56479120254517 After getting category custom After call to function getCategoryCustom
47 0.5647931098938 End of GetCategoryList function End of the function
48 0.56480813026428 Get Category List for Group Before the call to getCategoryList function
49 0.56481003761292 Start of GetCategoryList function Start of the function
50 0.56481409072876 Before getting categories Query to get specific category list
51 0.56525206565857 After getting categories Query to get specific category list
52 0.56525301933289 Before getting category custom Before call to function getCategoryCustom
53 0.56750202178955 After getting category custom After call to function getCategoryCustom
54 0.56750512123108 Before getting category custom Before call to function getCategoryCustom
55 0.56988716125488 After getting category custom After call to function getCategoryCustom
56 0.56988906860352 End of GetCategoryList function End of the function
57 0.56989598274231 Get Category List for Group Before the call to getCategoryList function
58 0.56989812850952 Start of GetCategoryList function Start of the function
59 0.56990098953247 Before getting categories Query to get specific category list
60 0.57022213935852 After getting categories Query to get specific category list
61 0.57022309303284 Before getting category custom Before call to function getCategoryCustom
62 0.57512497901917 After getting category custom After call to function getCategoryCustom
63 0.57512712478638 End of GetCategoryList function End of the function
64 0.57513308525085 End of getCategoryListByGroup Function Before return()
65 0.6253981590271 App Controller End End of the App controller (called before the controller of every page)
66 0.62711000442505 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.62722206115723 Before Get Options Before the call to getOptions in the tpl class
68 1.0372769832611 After Get Options After the call to getOptions in the tpl class
69 1.0373270511627 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.2535030841827 Finalizing debug Before the debug is output to the page.
71 1.2535190582275 End of App This is the end of the app logging, final timestamp


Query Debug - 604 Database Queries. Total time 0.5818 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016999244689941
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00047516822814941
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.0001530647277832
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00014090538024902
SELECT * FROM `bad_bots`
5 0.0005 0.00046300888061523
SELECT parameter, value FROM parameters
6 0.0002 0.00016212463378906
SET time_zone = 'Europe/London'
7 0.0003 0.00029301643371582
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014710426330566
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.0001068115234375
delete from cachefiles
10 0.0003 0.00026702880859375
SELECT id FROM pages WHERE pagename = 'handgun-shooting-in-combat-the-real-deal' LIMIT 1
11 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = 369
12 0.0008 0.00077104568481445
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0093 0.0093338489532471
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00029420852661133
SELECT * FROM pages WHERE pagename = 'handgun-shooting-in-combat-the-real-deal'
15 0.0002 0.0001521110534668
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00057005882263184
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00047802925109863
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 49
18 0.0002 0.00022602081298828
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.00045609474182129
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0001 0.00014185905456543
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
21 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
22 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.002971887588501
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 50
25 0.0003 0.00026392936706543
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00019502639770508
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0056688785552979
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0002 0.00017213821411133
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
32 0.0002 0.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 
33 0.0002 0.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0022830963134766
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 80
36 0.0003 0.00025606155395508
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.00229811668396
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0001 0.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 
39 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 (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
40 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
42 0.0011 0.0011489391326904
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 51
43 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017588138580322
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
46 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.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 (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
48 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00040602684020996
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0022571086883545
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0002 0.00024294853210449
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0022618770599365
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
54 0.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 
55 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 (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
56 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '2'
58 0.0047 0.0047299861907959
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 61
59 0.0003 0.00026512145996094
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0047779083251953
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (61)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
61 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0001 0.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 
63 0.0002 0.0001678466796875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00066494941711426
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0040 0.0040318965911865
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 64
67 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0040700435638428
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (64)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
69 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
73 0.0080 0.0080089569091797
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 65
74 0.0003 0.0002748966217041
SELECT id FROM categories WHERE parent_id = '65'
75 0.0081 0.0080759525299072
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
76 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.00017380714416504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '10'
80 0.0024 0.0024399757385254
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 81
81 0.0003 0.0002591609954834
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024588108062744
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 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 (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
85 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.0001227855682373
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024299621582031
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
88 0.0003 0.00025701522827148
SELECT id FROM categories WHERE parent_id = '31'
89 0.0024 0.002432107925415
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
90 0.0002 0.00015115737915039
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
92 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0002 0.00015497207641602
SELECT * FROM categorygroups WHERE id = '10'
94 0.0026 0.0026059150695801
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 66
95 0.0003 0.00032687187194824
SELECT id FROM categories WHERE parent_id = '66'
96 0.0003 0.00025701522827148
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0028250217437744
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
98 0.0002 0.00017213821411133
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0002 0.0001521110534668
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '10'
102 0.0094 0.0093660354614258
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 34
103 0.0003 0.00030016899108887
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00020384788513184
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '130'
109 0.0102 0.010167837142944
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
110 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
111 0.0002 0.00015711784362793
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
112 0.0002 0.00018811225891113
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '10'
114 0.0015 0.0015299320220947
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 32
115 0.0003 0.00027179718017578
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015661716461182
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 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 
119 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0017781257629395
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 89
122 0.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0018119812011719
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
125 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
126 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00041413307189941
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00066304206848145
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 84
130 0.0002 0.00023889541625977
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00067400932312012
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
133 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '17'
136 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
137 0.0002 0.00023102760314941
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00073814392089844
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0002 0.00017714500427246
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0002 0.00015711784362793
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00030684471130371
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0019807815551758
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 92
145 0.0002 0.00023889541625977
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.002007007598877
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
148 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '20'
151 0.0053 0.0052671432495117
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00039005279541016
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00019097328186035
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015592575073242
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00019383430480957
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00019478797912598
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '401'
169 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '454'
171 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '107'
182 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00026798248291016
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '411'
220 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '362'
229 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '386'
233 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '408'
234 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00019383430480957
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '433'
242 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014495849609375
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '156'
251 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00022292137145996
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '367'
258 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '387'
259 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016498565673828
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00022482872009277
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00021481513977051
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '392'
289 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.000244140625
SELECT * FROM pages WHERE id = '293'
308 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00013995170593262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '288'
314 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '299'
315 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '385'
318 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '438'
319 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00023889541625977
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '248'
327 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '260'
328 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00015091896057129
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '104'
333 0.0003 0.0002748966217041
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014114379882812
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '182'
360 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00013303756713867
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0013968944549561
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0003 0.0003049373626709
SELECT * FROM pages WHERE pagename = 'handgun-shooting-in-combat-the-real-deal'
373 0.0002 0.00024700164794922
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
374 0.0002 0.00020980834960938
SELECT * FROM pages WHERE id = 2
375 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 4
376 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = 12
377 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = 10
378 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 7
379 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = 18
380 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = 28
381 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = 13
382 0.0001 0.00013303756713867
SELECT * FROM pages WHERE id = 3
383 0.0427 0.042706966400146
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
384 0.0002 0.000244140625
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:1560834976;s:8:\"products\";a:6:{i:6;s:6:\"412927\";i:9;s:6:\"103845\";i:15;s:6:\"130885\";i:16;s:6:\"408078\";i:18;s:6:\"131163\";i:19;s:6:\"410949\";}}' WHERE id = '175'
385 0.0004 0.0004420280456543
SELECT * FROM products WHERE id IN (412927,103845,130885,408078,131163,410949) ORDER BY FIELD(id, 412927,103845,130885,408078,131163,410949 )
386 0.0003 0.00027608871459961
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
387 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '412927'
388 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '412927'
389 0.0037 0.003695011138916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
390 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
391 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
392 0.0005 0.0004580020904541
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
393 0.0001 0.00012588500976562
UPDATE products SET price = '199900' WHERE id = '412927'
394 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
395 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '103845'
396 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '103845'
397 0.0024 0.0024230480194092
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
398 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
399 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
400 0.0004 0.00037884712219238
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
401 0.0001 0.00011801719665527
UPDATE products SET price = '14499' WHERE id = '103845'
402 0.0002 0.00019407272338867
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
403 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '130885'
404 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '130885'
405 0.0020 0.0019869804382324
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
406 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
407 0.0002 0.00019621849060059
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0004 0.0003509521484375
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
409 0.0001 0.00011706352233887
UPDATE products SET price = '1521' WHERE id = '130885'
410 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
411 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '408078'
412 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '408078'
413 0.0031 0.0030748844146729
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
414 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
415 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0004 0.00041103363037109
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
417 0.0001 0.00012111663818359
UPDATE products SET price = '23352' WHERE id = '408078'
418 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
419 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '131163'
420 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '131163'
421 0.0025 0.0025370121002197
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
422 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
423 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
424 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
425 0.0001 0.00011801719665527
UPDATE products SET price = '20362' WHERE id = '131163'
426 0.0002 0.00016903877258301
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
427 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '410949'
428 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '410949'
429 0.0027 0.0027270317077637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
430 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
431 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0004 0.00038981437683105
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
433 0.0001 0.00012803077697754
UPDATE products SET price = '47995' WHERE id = '410949'
434 0.0422 0.042212009429932
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
435 0.0002 0.00021719932556152
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:1560834976;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:3;s:6:\"290575\";i:6;s:6:\"412927\";i:10;s:6:\"370121\";i:15;s:6:\"130885\";i:18;s:6:\"131163\";}}' WHERE id = '177'
436 0.0004 0.00043892860412598
SELECT * FROM products WHERE id IN (407595,290575,412927,370121,130885,131163) ORDER BY FIELD(id, 407595,290575,412927,370121,130885,131163 )
437 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
438 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '407595'
439 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '407595'
440 0.0034 0.0033669471740723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
441 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
442 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
443 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
444 0.0001 0.00012087821960449
UPDATE products SET price = '2497' WHERE id = '407595'
445 0.0006 0.00057005882263184
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
446 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '290575'
447 0.0001 0.00012421607971191
SELECT * FROM productcustomimages WHERE product_id = '290575'
448 0.0034 0.0033769607543945
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
449 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
450 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
451 0.0004 0.00042390823364258
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
452 0.0001 0.00011897087097168
UPDATE products SET price = '549500' WHERE id = '290575'
453 0.0003 0.00026392936706543
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
454 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '412927'
455 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '412927'
456 0.0036 0.003648042678833
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
457 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
458 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
459 0.0005 0.00045394897460938
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
460 0.0001 0.00011992454528809
UPDATE products SET price = '199900' WHERE id = '412927'
461 0.0002 0.00018787384033203
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
462 0.0002 0.00021576881408691
SELECT * FROM product_image_select WHERE product_id = '370121'
463 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '370121'
464 0.0027 0.0027480125427246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
465 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
466 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
467 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
468 0.0001 0.00011706352233887
UPDATE products SET price = '9899' WHERE id = '370121'
469 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
470 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '130885'
471 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '130885'
472 0.0020 0.0019869804382324
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
473 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
474 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
475 0.0004 0.00035810470581055
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
476 0.0001 0.00011897087097168
UPDATE products SET price = '1521' WHERE id = '130885'
477 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
478 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '131163'
479 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '131163'
480 0.0026 0.0025508403778076
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
481 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
482 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
483 0.0004 0.00037908554077148
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
484 0.0001 0.00011706352233887
UPDATE products SET price = '20362' WHERE id = '131163'
485 0.1027 0.10265302658081
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
486 0.0002 0.00024890899658203
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:1560834976;s:8:\"products\";a:6:{i:7;s:6:\"409759\";i:12;s:6:\"414825\";i:16;s:6:\"408078\";i:20;s:6:\"408079\";i:23;s:5:\"43519\";i:2;s:6:\"407595\";}}' WHERE id = '181'
487 0.0005 0.00051212310791016
SELECT * FROM products WHERE id IN (409759,414825,408078,408079,43519,407595) ORDER BY FIELD(id, 409759,414825,408078,408079,43519,407595 )
488 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
489 0.0003 0.00025296211242676
SELECT * FROM product_image_select WHERE product_id = '409759'
490 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '409759'
491 0.0033 0.003324031829834
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
492 0.0002 0.00022792816162109
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
493 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
494 0.0005 0.00051093101501465
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
495 0.0002 0.0001530647277832
UPDATE products SET price = '229000' WHERE id = '409759'
496 0.0003 0.00025296211242676
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
497 0.0003 0.00027203559875488
SELECT * FROM product_image_select WHERE product_id = '414825'
498 0.0001 0.00014495849609375
SELECT * FROM productcustomimages WHERE product_id = '414825'
499 0.0022 0.0021839141845703
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
500 0.0002 0.00020909309387207
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
501 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
502 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
503 0.0001 0.00012516975402832
UPDATE products SET price = '11999' WHERE id = '414825'
504 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
505 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '408078'
506 0.0001 0.00013923645019531
SELECT * FROM productcustomimages WHERE product_id = '408078'
507 0.0031 0.0030629634857178
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
508 0.0002 0.00018882751464844
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
509 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
510 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
511 0.0001 0.00012397766113281
UPDATE products SET price = '23352' WHERE id = '408078'
512 0.0002 0.00017499923706055
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
513 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '408079'
514 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '408079'
515 0.0032 0.0031821727752686
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
516 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
517 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
518 0.0004 0.00037407875061035
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
519 0.0001 0.00013399124145508
UPDATE products SET price = '18547' WHERE id = '408079'
520 0.0002 0.00018906593322754
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
521 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '43519'
522 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '43519'
523 0.0027 0.0027239322662354
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
524 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.00019478797912598
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0003 0.00034093856811523
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
527 0.0001 0.0001220703125
UPDATE products SET price = '1330' WHERE id = '43519'
528 0.0002 0.0002288818359375
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
529 0.0002 0.00020718574523926
SELECT * FROM product_image_select WHERE product_id = '407595'
530 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '407595'
531 0.0033 0.0033259391784668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
532 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
533 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
534 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
535 0.0001 0.00011897087097168
UPDATE products SET price = '2497' WHERE id = '407595'
536 0.1028 0.10282897949219
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
537 0.0003 0.00025796890258789
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:1560834976;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:9;s:6:\"103845\";i:11;s:6:\"403517\";i:19;s:6:\"410949\";i:20;s:6:\"408079\";i:23;s:5:\"43519\";}}' WHERE id = '183'
538 0.0005 0.00046801567077637
SELECT * FROM products WHERE id IN (407595,103845,403517,410949,408079,43519) ORDER BY FIELD(id, 407595,103845,403517,410949,408079,43519 )
539 0.0002 0.00024509429931641
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
540 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '407595'
541 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '407595'
542 0.0033 0.0033349990844727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
543 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
544 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.0001 0.00012087821960449
UPDATE products SET price = '2497' WHERE id = '407595'
547 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
548 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '103845'
549 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '103845'
550 0.0024 0.0024030208587646
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
551 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00011801719665527
UPDATE products SET price = '14499' WHERE id = '103845'
555 0.0003 0.00025796890258789
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
556 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '403517'
557 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '403517'
558 0.0030 0.0029511451721191
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
559 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00011801719665527
UPDATE products SET price = '6699' WHERE id = '403517'
563 0.0002 0.00018000602722168
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
564 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '410949'
565 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '410949'
566 0.0027 0.002673864364624
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
567 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00011801719665527
UPDATE products SET price = '47995' WHERE id = '410949'
571 0.0002 0.00017380714416504
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
572 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '408079'
573 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408079'
574 0.0032 0.0031709671020508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
575 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00037312507629395
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00012087821960449
UPDATE products SET price = '18547' WHERE id = '408079'
579 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
580 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '43519'
581 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '43519'
582 0.0027 0.0026779174804688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
583 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0003 0.00033211708068848
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00011992454528809
UPDATE products SET price = '1330' WHERE id = '43519'
587 0.0004 0.00040006637573242
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
588 0.0001 0.00013613700866699
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
589 0.0001 0.00012516975402832
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
590 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
591 0.0004 0.00039005279541016
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
592 0.0001 0.0001370906829834
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
593 0.0001 0.00012493133544922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
594 0.0009 0.00091409683227539
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
595 0.0003 0.0003058910369873
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
596 0.0003 0.00028896331787109
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
597 0.0003 0.00034379959106445
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
598 0.0001 0.00014400482177734
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0001 0.00012493133544922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0001 0.00012111663818359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
601 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0003 0.00034809112548828
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
604 0.0003 0.00033807754516602
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'