Tactical Equipment - Survivalist Equipment
   

Modern Unarmed Combat Fighting :: Hand-To-Hand :: Krav Maga :: Bujinkan Ninjutsu

Marine Martial Arts

US MARINE CORPS MARTIAL ARTS PROGRAM :: MILITARY SELF DEFENCE & Hand - To - Hand Combat

As many readers will know, the US Marine Corps has a long and proud history. Marines pride themselves on being 'warriors', so it's no surprise their Marine Corps Martial Arts Program (MCMAP) is an extremely robust and comprehensive program designed to provide Marines with combat-ready, armed and unarmed fighting skills. It is a weapon-based system on the principle that 'every Marine is a rifleman' regardless of speciality. In addition to the physical disciplines associated with other martial arts, this program places an equal emphasis on training in mental and character disciplines.

From as far back as World War 2 through the Vietnam war era to the present day, the USMC selected specific techniques from various martial arts to for the nucleus of their program. This included eastern martial arts systems such as judo and karate.

MCMAP evolved into it's present form by combining the best combat-tested training techniques, with Marine Corps core values and leadership training. It is interesting to note that one of the subject-matter experts consulted in preparation of MCMAP is Jack Hoban, a former Marine captain and long-time Bujinkan Ninjutsu practioner. Many of the MCMAP techniques are essentially Bujinkan techniques with very minor modification. MCMAP makes liberal use of wrist locks (particularly in pistol retention and knife defence), judo throws, and grappling that would be familiar to many serious martial artists.

MCMAP today consists of three components; mental discipline, character discipline, and physical discipline. Each component is divided into blocks and presented systematically at each belt level. A belt ranking system with five basic levels is used; tan, grey, green, brown and black. Progression through the belts includes passing the mental and character discipline requirements, and the physical techniques for each belt level. In addition, each Marine is required to show he has maintained proficiency in the physical disciplines of the current belt as well as the physical techniques of the next belt level. This is monitored through the use of training logs.

A very brief summary of techniques required to progress through the belts is as follows:

Tan - punches; falls; bayonet techniques; pugil strikes; upper and lower-body strikes; chokes; throws; counter strikes; armed manipulations; and, knife techniques.

Grey - advanced techniques for the above; and, weapons of opportunity and ground fighting.

Green - as above, with more advanced techniques.

Brown - any 15 techniques from any of the above techniques; throws; unarmed vs hand-held weapons; firearm retention; and, firearm disarmament.

Black - any 20 techniques, selected at random by the assessors, from any previously taught; and, more advanced techniques.

There are a total of approximately 250 techniques within the MCMAP, and the techniques build on each other as the Marine progressess through the colored belts. By the time a Marine qualifies for black belt, he is well trained in a range of lethal and non-lethal techniques, and is more than capable of overcoming any physical threat, either with or without weapons. Aside from being tested on the physical techniques for each belt, Marines are examined on such topics as: explain the concept of the leader and the follower; leadership styles; mentoring; manoeuvre warefare; decision making; USMC values and beliefs; and ethical leadership.

One particular aspect that is emphasised throughout MCMAP is the mental development of a combative mindset. The aim of this is to develop and maintain mental focus (together with correct physical technique) when fatigued or under other physical and mental pressures. Different mechanisms that affect combat mindset in the MCMAP are detailed and worth summarising below:

Fight or Flight

For most people, the natural response to a combat situation is to flee. However, if you imagine yourself in situation where an individual grievously threatens you or your loved ones, you will most likely find that your reaction will be to remove that threat by whatever means necessary - fight. Unarmed combat, shooting and weapons skills are all aimed at developing the ability to close and enter, taking the fight to the opponent and eliminating them as a threat.

Predatory v Affective Behavior

Predatory behavior is usually associated with stalking prey. The predator experiences very little autonomic arousal and is usually extremely focused on his prey, making little or no noise, waiting to exploit the best opportunity. This non-emotive, almost detached state is the ultimate aim for any combatant, but very hard to achieve in practice.

Many martial artists spend years trying to cultivate this mindset, with mixed levels of sucess. Affective behavior, conversly, includes both overt physical and vocal displays. An individual demonstrating affective behavior experiences physiological changes such as rising arousal levels, adrenaline running through the body, swaeting, heart rate increase, and laboured breathing as the need for oxygen increases. Affective behaviour is difficult to sustain and is an extremely ineffective state to be in for a combative engagement. An excellent explanation of predatory behavior is in the ADF Military Self Defence pamphlet.

To become a MCMAP instructor, a Marine must first complete a three-week instructors course. The instructor trains Marines at the small-unit level and is responsible for teching up to the belt level he holds, but cannot test to that same level. He teaches the physical techniques, which are the basis of the physical discipline and develops the small unit with character and mental training, which aims to enhance the units cohesion, esprit de corps, and rediness. The minimum requirement for attending the course is to be a grey belt, be corpral or above, have their commander's consent, obtain a first-class pass on their physical-fitness test and be medically screened. The next course, the instructor-trainer, is seven weeks and develops the instructors within a unit. They can then run instructor courses at unit level, and train and test Marines up to black-belt instructor.

To conclude, MCMAP combines the physical disciplines of combat with the leadership and core-values training characteristic of the USMC. What makes this such a complete program is the blend of all three disciplines; all three components are inextricably linked to each other, and to the advancement process within the belt-ranking system. This ensures that, as a Marine develops the physical skills to make him a formidable exponent, he also develops a commensurate level of maturity and self-discipline.

Remember, how you practice is how you perform under pressure, and your mental attitude during such training will become your reality.

About the author: Ian Robertson is a major in the Australian Army who deployed to Afghanistan in 2012 with the US 82nd Airborne Division. An active Military Self Defence Instructor, he also holds black-belt ranks in Shotokan Karate and Bujinkan Ninjutsu. He also passed the examination for his MCMAP black belt while deployed.

Major Robertson would like to thank Corpral 'Leo' Lyons (RAAF ADG), Captain Dana Ogle (MCMAP black belt), Corpral Justin McGee (MCMAP black belt instructor) and Sergeant Lucas Eastman (MCMAP black belt), for assistance in preparing this article.


Learn Krav Maga Online Course


The Truth About Training

the-truth-about-police-training The truth about police training

How the information age has changed police training

Keeping secrets in this century is increasingly difficult — just ask the NSA, CIA or any government organization living in the "black ops" world. Given this reality, it is interesting how some police trainers remain convinced that their training is a "secret' that provides an edge against the bad guys. Guarding these "black arts" as national secrets would be laughable were it not for the danger it poses to officers who must live in the real world. They must survive reality, not a video game. The police training community must open its eyes.

The phrase "black arts" came to my attention over 40 years ago, at the beginning of my martial arts training. It was mostly a gimmick that sold classes. Every black belt with a studio held back some super-secret death-dealing technique only "special" people could learn—if they kept paying their dues long enough. Those few making it that far usually found these secret arts rather anti-climactic. Sure, reputable teachers make sure practitioners have the mental and moral strength to use lethal techniques properly before passing them on, but the techniques have been around for a thousand years or more. So these secrets became running myths, tongue-and-cheek jokes among most of us—including those masters who reportedly pos?sessed these secret skills. Relegated mostly to the fantasy world of movies and video games, most true practitioners simply chuckle. So encountering this same mythology in the police world was a bit surprising. Having already trained in several martial arts for 15-plus years before becoming an officer, I just shook my head and laughed.

Unfortunately, little has changed today. Recently, a fellow trainer touted the need to protect the "black arts" from the general public. Why, because it gives officers an edge? It took every ounce of self-control to not break into laughter. I've attended a lot of training courses over the years, and most of the teachers within secret military or LE circles learned the techniques from a civilian. Going as far back as the 1970s, much of the knife training came from Asian martial arts of one form or another. Walter Nishioka, the founder of the International Karate League, brought in current Asian "masters" to teach to our military in the 1950s, so this is not new. Any police trainer who believes what they are teaching should be a secret, unavailable to the public, is living in a fantasy world. Not only are these skills available to the public, including those we must fight, but they probably started there.

Not So Special

Convincing a line officer the hand-to-hand fighting technique or firearms training they learn provides some edge over the general public, including bad guys, is downright lethal. It just makes them more surprised when their adversary is better trained, more practiced and more willing to apply this "secret" training. People today can learn more watching YouTube than many agencies receive in actual training. Several agencies have adopted MMA-style training, something anyone can acquire, and unlike officers, non-LE personnel can train every day. The idea that training in a particular field four times a year provides you some edge is patently ridiculous. Telling officers that "not everyone" has access to their training is a lie—and it sets LEOs up for failure. What we teach is not a secret or special. And you aren't some 16th century samurai incarnate. You are a trainer, so do your job and train your officers.

A lot of firearms training programs around the country are run by "black ops" types who make money passing on their elite skills. Their classes are populated by civilians, often with no background check or vetting other than a valid credit card. And, unlike most officers, they have the best equipment money can by. The same is true for both unarmed and edged-weapons training. Seminars occur daily, and most are open to the public. The reality is simple: Officers remain behind the curve, not in front of it, and nothing we do is secret. Leave the shadow world and enter this one; the advent of the internet and social media has made training free to anyone with a computer. There's no need for a secret instructor in black pajamas. Leave the "black arts" where they belong—in movies and TV shows. Stick to reality. It'll save an officer's life!


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.2751190662384 604 0.6035 0


No Amazon API Requests Made.


App Debug - Total Time 1.2751190662384 seconds

Number Time From Start Name Description
1 0.4175751209259 Initialise Initialise FSB Function
2 0.43435502052307 App Controller Start Start of the App controller (called before the controller of every page)
3 0.44535398483276 Start of getCategoryListByGroup Function Before first category groups query
4 0.4455349445343 After initial query Before first category groups query
5 0.44553709030151 Get Category List for Group Before the call to getCategoryList function
6 0.44553995132446 Start of GetCategoryList function Start of the function
7 0.44554495811462 Before getting categories Query to get specific category list
8 0.44616794586182 After getting categories Query to get specific category list
9 0.44617009162903 Before getting category custom Before call to function getCategoryCustom
10 0.44818902015686 After getting category custom After call to function getCategoryCustom
11 0.44819211959839 Before getting category custom Before call to function getCategoryCustom
12 0.45952892303467 After getting category custom After call to function getCategoryCustom
13 0.4595320224762 Before getting category custom Before call to function getCategoryCustom
14 0.46552300453186 After getting category custom After call to function getCategoryCustom
15 0.46552610397339 Before getting category custom Before call to function getCategoryCustom
16 0.47000694274902 After getting category custom After call to function getCategoryCustom
17 0.47001004219055 End of GetCategoryList function End of the function
18 0.47002005577087 Get Category List for Group Before the call to getCategoryList function
19 0.47002196311951 Start of GetCategoryList function Start of the function
20 0.47002601623535 Before getting categories Query to get specific category list
21 0.47048902511597 After getting categories Query to get specific category list
22 0.4704909324646 Before getting category custom Before call to function getCategoryCustom
23 0.47642111778259 After getting category custom After call to function getCategoryCustom
24 0.47642397880554 Before getting category custom Before call to function getCategoryCustom
25 0.48776006698608 After getting category custom After call to function getCategoryCustom
26 0.48776197433472 End of GetCategoryList function End of the function
27 0.48777103424072 Get Category List for Group Before the call to getCategoryList function
28 0.48777413368225 Start of GetCategoryList function Start of the function
29 0.4877769947052 Before getting categories Query to get specific category list
30 0.48855495452881 After getting categories Query to get specific category list
31 0.48855710029602 Before getting category custom Before call to function getCategoryCustom
32 0.49841213226318 After getting category custom After call to function getCategoryCustom
33 0.49841499328613 Before getting category custom Before call to function getCategoryCustom
34 0.51678109169006 After getting category custom After call to function getCategoryCustom
35 0.51678514480591 Before getting category custom Before call to function getCategoryCustom
36 0.52346706390381 After getting category custom After call to function getCategoryCustom
37 0.52347111701965 Before getting category custom Before call to function getCategoryCustom
38 0.52968192100525 After getting category custom After call to function getCategoryCustom
39 0.52968502044678 Before getting category custom Before call to function getCategoryCustom
40 0.53655910491943 After getting category custom After call to function getCategoryCustom
41 0.53656196594238 Before getting category custom Before call to function getCategoryCustom
42 0.55851602554321 After getting category custom After call to function getCategoryCustom
43 0.55851912498474 Before getting category custom Before call to function getCategoryCustom
44 0.56304907798767 After getting category custom After call to function getCategoryCustom
45 0.56305193901062 Before getting category custom Before call to function getCategoryCustom
46 0.56793594360352 After getting category custom After call to function getCategoryCustom
47 0.56793904304504 End of GetCategoryList function End of the function
48 0.56796193122864 Get Category List for Group Before the call to getCategoryList function
49 0.56796503067017 Start of GetCategoryList function Start of the function
50 0.56796908378601 Before getting categories Query to get specific category list
51 0.56838512420654 After getting categories Query to get specific category list
52 0.56838607788086 Before getting category custom Before call to function getCategoryCustom
53 0.57087898254395 After getting category custom After call to function getCategoryCustom
54 0.57088208198547 Before getting category custom Before call to function getCategoryCustom
55 0.57330703735352 After getting category custom After call to function getCategoryCustom
56 0.57330894470215 End of GetCategoryList function End of the function
57 0.57331514358521 Get Category List for Group Before the call to getCategoryList function
58 0.57331705093384 Start of GetCategoryList function Start of the function
59 0.57331895828247 Before getting categories Query to get specific category list
60 0.57362508773804 After getting categories Query to get specific category list
61 0.57362604141235 Before getting category custom Before call to function getCategoryCustom
62 0.57882714271545 After getting category custom After call to function getCategoryCustom
63 0.57882905006409 End of GetCategoryList function End of the function
64 0.57883501052856 End of getCategoryListByGroup Function Before return()
65 0.62856602668762 App Controller End End of the App controller (called before the controller of every page)
66 0.62994003295898 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.63004207611084 Before Get Options Before the call to getOptions in the tpl class
68 1.0538530349731 After Get Options After the call to getOptions in the tpl class
69 1.0539019107819 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.2750999927521 Finalizing debug Before the debug is output to the page.
71 1.2751169204712 End of App This is the end of the app logging, final timestamp


Query Debug - 604 Database Queries. Total time 0.6035 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.0001680850982666
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.0005180835723877
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.0001988410949707
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.0001678466796875
SELECT * FROM `bad_bots`
5 0.0005 0.00050210952758789
SELECT parameter, value FROM parameters
6 0.0002 0.0001530647277832
SET time_zone = 'Europe/London'
7 0.0003 0.0003058910369873
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00015997886657715
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010800361633301
delete from cachefiles
10 0.0003 0.00025510787963867
SELECT id FROM pages WHERE pagename = 'modern-unarmed-combat-fighting' LIMIT 1
11 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = 41
12 0.0008 0.00083804130554199
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0091 0.0090880393981934
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00028085708618164
SELECT * FROM pages WHERE pagename = 'modern-unarmed-combat-fighting'
15 0.0002 0.00016188621520996
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00057601928710938
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.00024604797363281
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.00050210952758789
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0002 0.00015497207641602
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.00016689300537109
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.00020313262939453
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '1'
24 0.0032 0.0031800270080566
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.00026798248291016
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00022602081298828
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00020909309387207
SELECT id FROM categories WHERE parent_id = '129'
30 0.0061 0.006148099899292
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.00017595291137695
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.00017309188842773
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.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00013995170593262
SELECT * FROM categorygroups WHERE id = '1'
35 0.0025 0.0024898052215576
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.00026488304138184
SELECT id FROM categories WHERE parent_id = '80'
37 0.0025 0.0024788379669189
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
39 0.0002 0.00016283988952637
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0012331008911133
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 51
43 0.0003 0.00026798248291016
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '101'
45 0.0020 0.0019669532775879
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.00016307830810547
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0002 0.00016498565673828
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.00018692016601562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00014591217041016
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00043320655822754
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0024 0.0024349689483643
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0003 0.00026893615722656
SELECT id FROM categories WHERE parent_id = '30'
53 0.0024 0.0024499893188477
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
54 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
55 0.0002 0.00016999244689941
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.00018692016601562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00014209747314453
SELECT * FROM categorygroups WHERE id = '2'
58 0.0052 0.0051660537719727
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.00027608871459961
SELECT id FROM categories WHERE parent_id = '61'
60 0.0051 0.0051188468933105
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.00016689300537109
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0002 0.00016307830810547
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.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00013995170593262
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00070881843566895
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0044 0.0044221878051758
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.00027704238891602
SELECT id FROM categories WHERE parent_id = '64'
68 0.0044 0.0043740272521973
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.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 
70 0.0002 0.00017094612121582
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.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
73 0.0086 0.0085611343383789
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.00029397010803223
SELECT id FROM categories WHERE parent_id = '65'
75 0.0087 0.0087151527404785
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.00017380714416504
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00014019012451172
SELECT * FROM categorygroups WHERE id = '10'
80 0.0027 0.0026819705963135
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.00028395652770996
SELECT id FROM categories WHERE parent_id = '81'
82 0.0029 0.0028738975524902
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0002 0.00020408630371094
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0002 0.00020503997802734
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.00017881393432617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00013113021850586
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0023910999298096
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.00029921531677246
SELECT id FROM categories WHERE parent_id = '31'
89 0.0028 0.0028159618377686
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.00016093254089355
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
92 0.0002 0.00017285346984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012683868408203
SELECT * FROM categorygroups WHERE id = '10'
94 0.0024 0.0023930072784424
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.00028204917907715
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '131'
97 0.0032 0.0032429695129395
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.00018191337585449
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.00015616416931152
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.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '10'
102 0.0092 0.0091779232025146
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.00031805038452148
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.0002288818359375
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00022101402282715
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '130'
109 0.0105 0.010541915893555
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.0001990795135498
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.00017285346984863
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.00018882751464844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
114 0.0017 0.0017220973968506
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.00026106834411621
SELECT id FROM categories WHERE parent_id = '32'
116 0.0018 0.0018179416656494
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0002 0.00015497207641602
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.00018620491027832
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0017740726470947
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 89
122 0.0003 0.00028300285339355
SELECT id FROM categories WHERE parent_id = '89'
123 0.0021 0.0021331310272217
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0002 0.00015902519226074
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.00014805793762207
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.00017285346984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00039100646972656
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0008 0.00075817108154297
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.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '84'
131 0.0008 0.00078892707824707
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.00014996528625488
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.00014805793762207
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.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '17'
136 0.0008 0.00077414512634277
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.00024008750915527
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00074386596679688
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0001 0.00014495849609375
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.00015401840209961
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.00015592575073242
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.00029182434082031
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0021 0.0021438598632812
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.00024604797363281
SELECT id FROM categories WHERE parent_id = '92'
146 0.0022 0.0021522045135498
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.00014686584472656
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.00012397766113281
SELECT * FROM categorygroups WHERE id = '20'
151 0.0054 0.0053901672363281
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00037097930908203
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00018191337585449
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015807151794434
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00018882751464844
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '450'
170 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '457'
172 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00016689300537109
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '107'
182 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018119812011719
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016498565673828
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0002 0.00024795532226562
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '408'
234 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00016522407531738
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00015401840209961
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '145'
250 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00019121170043945
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00015592575073242
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.00015616416931152
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016903877258301
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00020384788513184
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '343'
282 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.0002138614654541
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '288'
314 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '438'
319 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '260'
328 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00015997886657715
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014114379882812
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00012111663818359
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00012087821960449
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0014011859893799
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0003 0.0002748966217041
SELECT * FROM pages WHERE pagename = 'modern-unarmed-combat-fighting'
373 0.0002 0.00022006034851074
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
374 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = 2
375 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 4
376 0.0001 0.00013518333435059
SELECT * FROM pages WHERE id = 12
377 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 10
378 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = 7
379 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = 18
380 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = 28
381 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 13
382 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 3
383 0.0463 0.046344995498657
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.00024795532226562
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:1560832644;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:3;s:6:\"290575\";i:6;s:6:\"412927\";i:12;s:6:\"414825\";i:13;s:6:\"414188\";i:15;s:6:\"130885\";}}' WHERE id = '175'
385 0.0005 0.00047588348388672
SELECT * FROM products WHERE id IN (398315,290575,412927,414825,414188,130885) ORDER BY FIELD(id, 398315,290575,412927,414825,414188,130885 )
386 0.0002 0.00023484230041504
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
387 0.0003 0.00025296211242676
SELECT * FROM product_image_select WHERE product_id = '398315'
388 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '398315'
389 0.0035 0.0035009384155273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
390 0.0002 0.00020503997802734
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
391 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
392 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
393 0.0001 0.00013589859008789
UPDATE products SET price = '1999' WHERE id = '398315'
394 0.0006 0.00062012672424316
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
395 0.0002 0.00023579597473145
SELECT * FROM product_image_select WHERE product_id = '290575'
396 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '290575'
397 0.0043 0.0042638778686523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
398 0.0002 0.00021004676818848
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
399 0.0002 0.00022387504577637
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
400 0.0005 0.00049114227294922
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
401 0.0001 0.00014901161193848
UPDATE products SET price = '549500' WHERE id = '290575'
402 0.0003 0.00026488304138184
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
403 0.0003 0.0002591609954834
SELECT * FROM product_image_select WHERE product_id = '412927'
404 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '412927'
405 0.0045 0.0045261383056641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
406 0.0002 0.00021004676818848
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
407 0.0002 0.00020980834960938
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0005 0.00049400329589844
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
409 0.0001 0.00012993812561035
UPDATE products SET price = '199900' WHERE id = '412927'
410 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
411 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '414825'
412 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '414825'
413 0.0027 0.0026590824127197
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
414 0.0002 0.0002140998840332
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
415 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0005 0.00046992301940918
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
417 0.0001 0.00012397766113281
UPDATE products SET price = '11999' WHERE id = '414825'
418 0.0003 0.00027203559875488
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
419 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '414188'
420 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '414188'
421 0.0030 0.0030310153961182
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
422 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
423 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
424 0.0005 0.00045108795166016
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
425 0.0001 0.00012302398681641
UPDATE products SET price = '9999' WHERE id = '414188'
426 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
427 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '130885'
428 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '130885'
429 0.0023 0.002269983291626
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
430 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
431 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0004 0.00041103363037109
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
433 0.0001 0.00012493133544922
UPDATE products SET price = '1521' WHERE id = '130885'
434 0.0431 0.04309606552124
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.00022220611572266
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:1560832644;s:8:\"products\";a:6:{i:3;s:6:\"290575\";i:11;s:6:\"403517\";i:13;s:6:\"414188\";i:16;s:6:\"408078\";i:17;s:6:\"405644\";i:18;s:6:\"131163\";}}' WHERE id = '177'
436 0.0004 0.00042200088500977
SELECT * FROM products WHERE id IN (290575,403517,414188,408078,405644,131163) ORDER BY FIELD(id, 290575,403517,414188,408078,405644,131163 )
437 0.0006 0.00059199333190918
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
438 0.0002 0.00022220611572266
SELECT * FROM product_image_select WHERE product_id = '290575'
439 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '290575'
440 0.0034 0.003364086151123
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
441 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
442 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
443 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
444 0.0001 0.00011992454528809
UPDATE products SET price = '549500' WHERE id = '290575'
445 0.0003 0.00025701522827148
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
446 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '403517'
447 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '403517'
448 0.0030 0.002957820892334
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
449 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
450 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
451 0.0004 0.00040912628173828
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
452 0.0001 0.00012803077697754
UPDATE products SET price = '6699' WHERE id = '403517'
453 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
454 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '414188'
455 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414188'
456 0.0026 0.002561092376709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
457 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
458 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
459 0.0004 0.00039792060852051
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
460 0.0001 0.00011682510375977
UPDATE products SET price = '9999' WHERE id = '414188'
461 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
462 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '408078'
463 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '408078'
464 0.0030 0.0030288696289062
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
465 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
466 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
467 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
468 0.0001 0.00013113021850586
UPDATE products SET price = '23352' WHERE id = '408078'
469 0.0002 0.0001828670501709
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
470 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '405644'
471 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '405644'
472 0.0033 0.0033478736877441
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
473 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
474 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
475 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
476 0.0001 0.00013208389282227
UPDATE products SET price = '63539' WHERE id = '405644'
477 0.0002 0.00021910667419434
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
478 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '131163'
479 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '131163'
480 0.0025 0.0025351047515869
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.00018811225891113
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
482 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
483 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
484 0.0001 0.00011801719665527
UPDATE products SET price = '20362' WHERE id = '131163'
485 0.1040 0.10402703285217
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.00024580955505371
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:1560832645;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:2;s:6:\"407595\";i:3;s:6:\"290575\";i:7;s:6:\"409759\";i:8;s:6:\"408792\";i:10;s:6:\"370121\";}}' WHERE id = '181'
487 0.0004 0.00044608116149902
SELECT * FROM products WHERE id IN (398315,407595,290575,409759,408792,370121) ORDER BY FIELD(id, 398315,407595,290575,409759,408792,370121 )
488 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
489 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '398315'
490 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '398315'
491 0.0025 0.0025060176849365
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
492 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
493 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
494 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
495 0.0001 0.00012302398681641
UPDATE products SET price = '1999' WHERE id = '398315'
496 0.0002 0.00022792816162109
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
497 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '407595'
498 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '407595'
499 0.0033 0.0033020973205566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
500 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
501 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
502 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
503 0.0001 0.00012087821960449
UPDATE products SET price = '2497' WHERE id = '407595'
504 0.0006 0.00058603286743164
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
505 0.0002 0.00022482872009277
SELECT * FROM product_image_select WHERE product_id = '290575'
506 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '290575'
507 0.0034 0.0033988952636719
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
508 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
509 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
510 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
511 0.0001 0.00012779235839844
UPDATE products SET price = '549500' WHERE id = '290575'
512 0.0002 0.00020694732666016
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
513 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '409759'
514 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '409759'
515 0.0028 0.0027611255645752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
516 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
517 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
518 0.0004 0.00040912628173828
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
519 0.0001 0.00012302398681641
UPDATE products SET price = '229000' WHERE id = '409759'
520 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
521 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '408792'
522 0.0001 0.00012922286987305
SELECT * FROM productcustomimages WHERE product_id = '408792'
523 0.0036 0.0035629272460938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
524 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.00020480155944824
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0004 0.00044417381286621
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
527 0.0001 0.00011801719665527
UPDATE products SET price = '13499' WHERE id = '408792'
528 0.0002 0.00018310546875
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
529 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '370121'
530 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '370121'
531 0.0028 0.0027580261230469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
532 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
533 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
534 0.0004 0.00040197372436523
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
535 0.0001 0.00011897087097168
UPDATE products SET price = '9899' WHERE id = '370121'
536 0.1039 0.10386204719543
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.00026106834411621
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:1560832645;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:3;s:6:\"290575\";i:5;s:6:\"404554\";i:11;s:6:\"403517\";i:12;s:6:\"414825\";}}' WHERE id = '183'
538 0.0004 0.00043702125549316
SELECT * FROM products WHERE id IN (414940,398315,290575,404554,403517,414825) ORDER BY FIELD(id, 414940,398315,290575,404554,403517,414825 )
539 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
540 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '414940'
541 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '414940'
542 0.0032 0.0032439231872559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
543 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
544 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.0001 0.00012016296386719
UPDATE products SET price = '4490' WHERE id = '414940'
547 0.0002 0.00020909309387207
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
548 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '398315'
549 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '398315'
550 0.0025 0.0024840831756592
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
551 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00011992454528809
UPDATE products SET price = '1999' WHERE id = '398315'
555 0.0006 0.00057101249694824
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
556 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '290575'
557 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '290575'
558 0.0034 0.003352165222168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
559 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00011801719665527
UPDATE products SET price = '549500' WHERE id = '290575'
563 0.0003 0.00026679039001465
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
564 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '404554'
565 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '404554'
566 0.0033 0.003342866897583
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
567 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0005 0.00045084953308105
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00011801719665527
UPDATE products SET price = '399999' WHERE id = '404554'
571 0.0003 0.00026893615722656
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
572 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '403517'
573 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '403517'
574 0.0029 0.0029048919677734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
575 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00011897087097168
UPDATE products SET price = '6699' WHERE id = '403517'
579 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
580 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '414825'
581 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414825'
582 0.0020 0.0020380020141602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
583 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0004 0.00036406517028809
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00012803077697754
UPDATE products SET price = '11999' WHERE id = '414825'
587 0.0004 0.00039315223693848
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
588 0.0001 0.00012993812561035
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
589 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
590 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
591 0.0004 0.00038886070251465
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
592 0.0001 0.00012397766113281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
593 0.0001 0.00012612342834473
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
594 0.0009 0.00089001655578613
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
595 0.0003 0.00030207633972168
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
596 0.0003 0.00027799606323242
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
597 0.0004 0.00036001205444336
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
598 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
601 0.0001 0.00011706352233887
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0003 0.00032401084899902
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
604 0.0003 0.00031805038452148
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'