Tactical Equipment - Survivalist Equipment
   

The Best Self Defense Gun

The best self defense gun

UPDATED :  

Fun Makes Perfect

Here's a radical thought. Any good defense gun must be fun to shoot.

WHY IS THAT A RADICAL THOUGHT? SIMPLE

A gun that's fun to shoot gets shot a lot, even by people who are not die-hard shooters. A lot of shooting adds up to a lot of practice, and that translates into a vital aspect of any defense gun—that it be operated instinctively as an extension of the shooter s body.

Now, obviously, a defense gun must also be reliable, but that's something you find out with a lot of shooting and trying different ammunition. The debate over the relative merits of this gun or that cartridge is never-ending. But like rifles for dangerous game, there is more to it than paper ballistics, accuracy, or cartridge capacity.

These other factors become particularly important when choosing a gun for a family member who may not have your serious interest, won't practice nearly enough, and couldn't care less about foot-pounds of energy.

In a defense gun, two things are of paramount importance: ease of use and reliability. That applies to concealed guns, car guns, and guns kept by the bed. In the last case, where it's most likely to be used in the dark, those two factors become even more critical.

Instinctive Use Comes from Lots of Shooting Regardless of the gun's mechanism, instinctive use comes only from practice—a lot of it. The way to ensure that someone gets enough practice isto make sure they're armed with a gun they like and find fun to shoot.

Different people have affinities for different firearm types, often for inexplicable reasons. Some prefer a double shotgun, others like a pump. Personally, I love double rifles, but I'm more at home with a bolt gun, and that's what I've always had in my hands in dangerous situations.

Finger-Groove Grips

Self defense revolvers

ABOVE : Generally speaking, finger grooves on double-action revolver grips will help keep the gun from sliding down through your grasp in recoil.

My preference in a defensive handgun is either a Smith & Wesson J-Frame revolver or a double-action semiauto like the Walther PPK. I shoot both types a lot simply because they're fun to shoot. What I am talking about is not taste but affinity.

I am comfortable with those mechanisms, but not so much with either a Glock or a Model 1911, and no amount of shooting seems to change that. Trying to force someone to use a gun they aren't comfortable with is a mistake.

Forget ballistics and cartridge count. What matters are things like how to deal with a misfire and how confident you are carrying the gun or reaching into the drawer beside the bed with your heart racing.

Take the .38-caliber J-Frame. It holds five rounds and has a long, safe, double-action pull. You grab the gun and squeeze the trigger. If it misfires, you simply squeeze the trigger again.

It can't jam unless you stuff it full of over-pressure loads. In a tight situation, it requires no conscious thought. It s all instinct and muscle memory. Sheer firepower is overrated; a defensive gun exists to get you out of a bad situation, not get you into a gunfight.

America may be a nation of 1911 lovers, but the 1911 isreally an expert's gun. It's difficult to master, and the .45 ACP is hard to handle. Even in a car, where weight is not a consideration, my preference is a Walther P38, not a 1911. For carrying, I have a .380 PPK. And beside the bed is an old 9mm S&W Model 39-2.

That mechanism and I just have an affinity for each other. Occasionally, I carry an S&W Model 60 in a shoulder holster. For me, all of them are justf u n to shoot. That is not true of the 1911, even though I do shoot them a lot.

Those are my particular choices. You might prefer a 1911 on your hip and a semiauto shotgun under the bed. The point is that in helping to choose a gun for another person, you should tailor the choice to what they like and not what you theorize is "best."

If a person enjoys shooting a particular gun and thinks it's fun, they are more likely to practice than if they find it unpleasant, complicated, or intimidating.

Walther-PPK-380-Self-Defense-Gun

So what's the best handgun for self defense?

  1. The maximum calibre you can comfortably conceal

  2. Reliable and robust - (reputation to fire every time)

  3. Simple to operate - (minimum of complicated controls eg; safety levers, de-cockers etc...)

  4. Easy to shoot - (fits your hand comfortably, allows follow-up shots to stay on target with minimum of recoil disruption)

The moral of the story is choose a gun that you are happy with, to carry and shhot. Self defense does not mean intercepting the oposition in a gun battle, it's plain and simple - "to get yourself out of a bad situation" - even if it means just shooing your weapon to frighten off your attacker.

If it results in shooting the assailant, a well placed shot with a small calibre sure beats random misses by a calibre too large to effectively handle.

A small framed male or female will fare well with .22, .25 and .38/380ACP. Put them in control of a 44 magnum or .45ACP and it's likely only the first shot will have any chance of landing - follow-up shots would be unlikely from the recoil affected accuracy.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.2204611301422 604 0.5492 0


No Amazon API Requests Made.


App Debug - Total Time 1.2204611301422 seconds

Number Time From Start Name Description
1 0.39965009689331 Initialise Initialise FSB Function
2 0.40326809883118 App Controller Start Start of the App controller (called before the controller of every page)
3 0.41430497169495 Start of getCategoryListByGroup Function Before first category groups query
4 0.41448211669922 After initial query Before first category groups query
5 0.41448402404785 Get Category List for Group Before the call to getCategoryList function
6 0.41448712348938 Start of GetCategoryList function Start of the function
7 0.41449093818665 Before getting categories Query to get specific category list
8 0.41504502296448 After getting categories Query to get specific category list
9 0.41504597663879 Before getting category custom Before call to function getCategoryCustom
10 0.41689109802246 After getting category custom After call to function getCategoryCustom
11 0.41689395904541 Before getting category custom Before call to function getCategoryCustom
12 0.42746996879578 After getting category custom After call to function getCategoryCustom
13 0.4274730682373 Before getting category custom Before call to function getCategoryCustom
14 0.4330530166626 After getting category custom After call to function getCategoryCustom
15 0.43305492401123 Before getting category custom Before call to function getCategoryCustom
16 0.43715405464172 After getting category custom After call to function getCategoryCustom
17 0.43715596199036 End of GetCategoryList function End of the function
18 0.43716597557068 Get Category List for Group Before the call to getCategoryList function
19 0.43716812133789 Start of GetCategoryList function Start of the function
20 0.43717098236084 Before getting categories Query to get specific category list
21 0.43759894371033 After getting categories Query to get specific category list
22 0.43760013580322 Before getting category custom Before call to function getCategoryCustom
23 0.4431209564209 After getting category custom After call to function getCategoryCustom
24 0.44312310218811 Before getting category custom Before call to function getCategoryCustom
25 0.45374393463135 After getting category custom After call to function getCategoryCustom
26 0.45374608039856 End of GetCategoryList function End of the function
27 0.45375204086304 Get Category List for Group Before the call to getCategoryList function
28 0.45375394821167 Start of GetCategoryList function Start of the function
29 0.4537570476532 Before getting categories Query to get specific category list
30 0.45445799827576 After getting categories Query to get specific category list
31 0.45446014404297 Before getting category custom Before call to function getCategoryCustom
32 0.46352005004883 After getting category custom After call to function getCategoryCustom
33 0.46352195739746 Before getting category custom Before call to function getCategoryCustom
34 0.48072504997253 After getting category custom After call to function getCategoryCustom
35 0.48072791099548 Before getting category custom Before call to function getCategoryCustom
36 0.48665308952332 After getting category custom After call to function getCategoryCustom
37 0.48665714263916 Before getting category custom Before call to function getCategoryCustom
38 0.49251508712769 After getting category custom After call to function getCategoryCustom
39 0.49251794815063 Before getting category custom Before call to function getCategoryCustom
40 0.49873805046082 After getting category custom After call to function getCategoryCustom
41 0.49874091148376 Before getting category custom Before call to function getCategoryCustom
42 0.52060508728027 After getting category custom After call to function getCategoryCustom
43 0.52060914039612 Before getting category custom Before call to function getCategoryCustom
44 0.52467799186707 After getting category custom After call to function getCategoryCustom
45 0.52468109130859 Before getting category custom Before call to function getCategoryCustom
46 0.52925205230713 After getting category custom After call to function getCategoryCustom
47 0.52925395965576 End of GetCategoryList function End of the function
48 0.52926802635193 Get Category List for Group Before the call to getCategoryList function
49 0.52927112579346 Start of GetCategoryList function Start of the function
50 0.52927398681641 Before getting categories Query to get specific category list
51 0.52970004081726 After getting categories Query to get specific category list
52 0.52970194816589 Before getting category custom Before call to function getCategoryCustom
53 0.53196811676025 After getting category custom After call to function getCategoryCustom
54 0.53197002410889 Before getting category custom Before call to function getCategoryCustom
55 0.53425908088684 After getting category custom After call to function getCategoryCustom
56 0.53426098823547 End of GetCategoryList function End of the function
57 0.53426694869995 Get Category List for Group Before the call to getCategoryList function
58 0.53426909446716 Start of GetCategoryList function Start of the function
59 0.5342710018158 Before getting categories Query to get specific category list
60 0.53459095954895 After getting categories Query to get specific category list
61 0.53459191322327 Before getting category custom Before call to function getCategoryCustom
62 0.5395359992981 After getting category custom After call to function getCategoryCustom
63 0.53953814506531 End of GetCategoryList function End of the function
64 0.53954410552979 End of getCategoryListByGroup Function Before return()
65 0.58898901939392 App Controller End End of the App controller (called before the controller of every page)
66 0.59029006958008 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.5903959274292 Before Get Options Before the call to getOptions in the tpl class
68 0.9684100151062 After Get Options After the call to getOptions in the tpl class
69 0.96846103668213 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.2204439640045 Finalizing debug Before the debug is output to the page.
71 1.2204599380493 End of App This is the end of the app logging, final timestamp


Query Debug - 604 Database Queries. Total time 0.5492 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00017094612121582
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00045299530029297
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00016093254089355
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00013899803161621
SELECT * FROM `bad_bots`
5 0.0005 0.00045609474182129
SELECT parameter, value FROM parameters
6 0.0002 0.00015902519226074
SET time_zone = 'Europe/London'
7 0.0003 0.00031018257141113
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014305114746094
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010490417480469
delete from cachefiles
10 0.0002 0.00023698806762695
SELECT id FROM pages WHERE pagename = 'the-best-self-defense-gun' LIMIT 1
11 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = 379
12 0.0008 0.00078988075256348
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0092 0.0092020034790039
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00027203559875488
SELECT * FROM pages WHERE pagename = 'the-best-self-defense-gun'
15 0.0002 0.00016307830810547
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00051593780517578
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00048708915710449
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.0004 0.00043702125549316
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.00015401840209961
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.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0030050277709961
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.00026106834411621
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.00020217895507812
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0057239532470703
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.00016999244689941
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
32 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 (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
33 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0023131370544434
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.00026202201843262
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0023329257965088
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.00014591217041016
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.00015807151794434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0011551380157471
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.00025796890258789
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017869472503662
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.0001521110534668
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.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
48 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012421607971191
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00040292739868164
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0022881031036377
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0023050308227539
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.00014996528625488
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.00014805793762207
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.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0048141479492188
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.00026607513427734
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0048389434814453
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.00015687942504883
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.00016403198242188
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.00016379356384277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '2'
65 0.0006 0.00063896179199219
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0040 0.0040371417999268
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.0002601146697998
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0040619373321533
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.00014781951904297
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.00016283988952637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '10'
73 0.0081 0.0080940723419189
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.00027990341186523
SELECT id FROM categories WHERE parent_id = '65'
75 0.0081 0.0081222057342529
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.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012516975402832
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.00030517578125
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024690628051758
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.0001530647277832
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.00014710426330566
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
85 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012683868408203
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024240016937256
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.00027704238891602
SELECT id FROM categories WHERE parent_id = '31'
89 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 (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
90 0.0002 0.0001518726348877
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0002 0.00015997886657715
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.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022280216217041
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.00025606155395508
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0028190612792969
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
98 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0002 0.00015997886657715
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.00016117095947266
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '10'
102 0.0095 0.0094799995422363
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.00030088424682617
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00020909309387207
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.0001978874206543
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.00020003318786621
SELECT id FROM categories WHERE parent_id = '130'
109 0.0103 0.010268926620483
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.00017905235290527
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.00015592575073242
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.00012683868408203
SELECT * FROM categorygroups WHERE id = '10'
114 0.0015 0.0015490055084229
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.00026917457580566
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015718936920166
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.00014495849609375
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.00014209747314453
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.00017499923706055
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.0018157958984375
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.00024890899658203
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0018291473388672
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.00014901161193848
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.00014615058898926
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.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00040197372436523
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00067687034606934
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 84
130 0.0002 0.00023078918457031
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00068092346191406
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.00014901161193848
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.00014495849609375
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.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00069284439086914
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.00023293495178223
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00071191787719727
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.00014090538024902
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0001 0.00014305114746094
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.00015521049499512
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00011992454528809
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.0003049373626709
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0020129680633545
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.0020260810852051
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.00014591217041016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
148 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0002 0.00015807151794434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '20'
151 0.0053 0.0053389072418213
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00036883354187012
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00018906593322754
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.00015497207641602
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '401'
169 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00015091896057129
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0002 0.0002288818359375
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '119'
208 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '413'
222 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014877319335938
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '423'
238 0.0001 0.00014996528625488
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.00014114379882812
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014710426330566
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '145'
250 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00019288063049316
SELECT * FROM pages WHERE id = '316'
255 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '387'
259 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016999244689941
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '343'
282 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '293'
308 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00016093254089355
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014495849609375
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.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014185905456543
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00013017654418945
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011897087097168
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.0014011859893799
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00023317337036133
SELECT * FROM pages WHERE pagename = 'the-best-self-defense-gun'
373 0.0002 0.00021505355834961
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
374 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = 2
375 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 4
376 0.0001 0.00013518333435059
SELECT * FROM pages WHERE id = 12
377 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = 10
378 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 7
379 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = 18
380 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = 28
381 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 13
382 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 3
383 0.0337 0.033738136291504
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.0003 0.00025510787963867
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:1560832755;s:8:\"products\";a:6:{i:3;s:6:\"290575\";i:4;s:6:\"171938\";i:10;s:6:\"370121\";i:19;s:6:\"410949\";i:23;s:5:\"43519\";i:11;s:6:\"403517\";}}' WHERE id = '175'
385 0.0005 0.00046205520629883
SELECT * FROM products WHERE id IN (290575,171938,370121,410949,43519,403517) ORDER BY FIELD(id, 290575,171938,370121,410949,43519,403517 )
386 0.0006 0.00058197975158691
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
387 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '290575'
388 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '290575'
389 0.0034 0.0033729076385498
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
390 0.0002 0.00019478797912598
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
391 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
392 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
393 0.0001 0.00012302398681641
UPDATE products SET price = '549500' WHERE id = '290575'
394 0.0006 0.00059008598327637
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
395 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '171938'
396 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '171938'
397 0.0025 0.0025019645690918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
398 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
399 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
400 0.0004 0.00038313865661621
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
401 0.0001 0.00011801719665527
UPDATE products SET price = '389500' WHERE id = '171938'
402 0.0002 0.00018620491027832
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
403 0.0002 0.00024986267089844
SELECT * FROM product_image_select WHERE product_id = '370121'
404 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '370121'
405 0.0027 0.0027410984039307
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
406 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
407 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0004 0.00039482116699219
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
409 0.0001 0.00011992454528809
UPDATE products SET price = '9899' WHERE id = '370121'
410 0.0002 0.00017094612121582
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
411 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '410949'
412 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '410949'
413 0.0026 0.0026330947875977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
414 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
415 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
417 0.0001 0.00011920928955078
UPDATE products SET price = '47995' WHERE id = '410949'
418 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
419 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '43519'
420 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '43519'
421 0.0027 0.0026609897613525
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
422 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
423 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
424 0.0003 0.00032401084899902
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
425 0.0001 0.00011992454528809
UPDATE products SET price = '1330' WHERE id = '43519'
426 0.0003 0.00025701522827148
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
427 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '403517'
428 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '403517'
429 0.0029 0.002875804901123
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
430 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
431 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
433 0.0001 0.00011992454528809
UPDATE products SET price = '6699' WHERE id = '403517'
434 0.0332 0.033210039138794
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.00021481513977051
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560832755;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:3;s:6:\"290575\";i:10;s:6:\"370121\";i:13;s:6:\"414188\";i:17;s:6:\"405644\";i:19;s:6:\"410949\";}}' WHERE id = '177'
436 0.0004 0.00043797492980957
SELECT * FROM products WHERE id IN (407595,290575,370121,414188,405644,410949) ORDER BY FIELD(id, 407595,290575,370121,414188,405644,410949 )
437 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
438 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '407595'
439 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '407595'
440 0.0033 0.0033149719238281
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.00018596649169922
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.0004429817199707
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.00056099891662598
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
446 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '290575'
447 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '290575'
448 0.0033 0.0033440589904785
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.00019502639770508
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
450 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
451 0.0004 0.0004270076751709
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
452 0.0001 0.00011801719665527
UPDATE products SET price = '549500' WHERE id = '290575'
453 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
454 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '370121'
455 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '370121'
456 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
457 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
458 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
459 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
460 0.0001 0.00011897087097168
UPDATE products SET price = '9899' WHERE id = '370121'
461 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
462 0.0002 0.0001988410949707
SELECT * FROM product_image_select WHERE product_id = '414188'
463 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '414188'
464 0.0025 0.0025041103363037
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
465 0.0002 0.00017905235290527
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
466 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
467 0.0004 0.00039410591125488
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
468 0.0001 0.00011801719665527
UPDATE products SET price = '9999' WHERE id = '414188'
469 0.0002 0.00018095970153809
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
470 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '405644'
471 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '405644'
472 0.0033 0.0033237934112549
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.00018215179443359
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
474 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
475 0.0004 0.00043392181396484
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
476 0.0001 0.00011706352233887
UPDATE products SET price = '63539' WHERE id = '405644'
477 0.0002 0.0001680850982666
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
478 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '410949'
479 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '410949'
480 0.0027 0.0026578903198242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
481 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
482 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
483 0.0004 0.00039196014404297
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
484 0.0001 0.00011897087097168
UPDATE products SET price = '47995' WHERE id = '410949'
485 0.0942 0.094238996505737
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.0003 0.00026392936706543
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:1560832755;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:3;s:6:\"290575\";i:5;s:6:\"404554\";i:6;s:6:\"412927\";i:10;s:6:\"370121\";i:23;s:5:\"43519\";}}' WHERE id = '181'
487 0.0004 0.00044608116149902
SELECT * FROM products WHERE id IN (414940,290575,404554,412927,370121,43519) ORDER BY FIELD(id, 414940,290575,404554,412927,370121,43519 )
488 0.0002 0.00018906593322754
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
489 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '414940'
490 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '414940'
491 0.0032 0.0032081604003906
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
492 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
493 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
494 0.0004 0.00043082237243652
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
495 0.0001 0.00012016296386719
UPDATE products SET price = '4490' WHERE id = '414940'
496 0.0006 0.00057101249694824
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
497 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '290575'
498 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '290575'
499 0.0033 0.0033438205718994
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
500 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
501 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
502 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
503 0.0001 0.00011992454528809
UPDATE products SET price = '549500' WHERE id = '290575'
504 0.0003 0.00026488304138184
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
505 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '404554'
506 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '404554'
507 0.0033 0.0032780170440674
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
508 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
509 0.0002 0.00019478797912598
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
510 0.0005 0.00046205520629883
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
511 0.0001 0.00011897087097168
UPDATE products SET price = '399999' WHERE id = '404554'
512 0.0003 0.00025296211242676
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
513 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '412927'
514 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '412927'
515 0.0036 0.0035688877105713
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
516 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
517 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
518 0.0005 0.00045108795166016
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
519 0.0001 0.00012087821960449
UPDATE products SET price = '199900' WHERE id = '412927'
520 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
521 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '370121'
522 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '370121'
523 0.0027 0.0027148723602295
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
524 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
527 0.0001 0.00011920928955078
UPDATE products SET price = '9899' WHERE id = '370121'
528 0.0002 0.00020694732666016
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
529 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '43519'
530 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '43519'
531 0.0027 0.0026669502258301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
532 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
533 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
534 0.0003 0.00032186508178711
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
535 0.0001 0.00013303756713867
UPDATE products SET price = '1330' WHERE id = '43519'
536 0.0938 0.093844175338745
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:1560832755;s:8:\"products\";a:6:{i:13;s:6:\"414188\";i:14;s:6:\"406758\";i:3;s:6:\"290575\";i:7;s:6:\"409759\";i:8;s:6:\"408792\";i:11;s:6:\"403517\";}}' WHERE id = '183'
538 0.0005 0.00045299530029297
SELECT * FROM products WHERE id IN (414188,406758,290575,409759,408792,403517) ORDER BY FIELD(id, 414188,406758,290575,409759,408792,403517 )
539 0.0003 0.00028777122497559
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
540 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '414188'
541 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '414188'
542 0.0025 0.0025398731231689
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
543 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
544 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.0001 0.00012111663818359
UPDATE products SET price = '9999' WHERE id = '414188'
547 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
548 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '406758'
549 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '406758'
550 0.0025 0.0025491714477539
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
551 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00011992454528809
UPDATE products SET price = '2694' WHERE id = '406758'
555 0.0006 0.00055813789367676
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
556 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '290575'
557 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '290575'
558 0.0033 0.0033237934112549
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.00019001960754395
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00011897087097168
UPDATE products SET price = '549500' WHERE id = '290575'
563 0.0002 0.0002138614654541
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
564 0.0002 0.00020217895507812
SELECT * FROM product_image_select WHERE product_id = '409759'
565 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '409759'
566 0.0028 0.002755880355835
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
567 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0004 0.00040793418884277
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00012302398681641
UPDATE products SET price = '229000' WHERE id = '409759'
571 0.0002 0.0001981258392334
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
572 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '408792'
573 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408792'
574 0.0035 0.0035150051116943
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
575 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00011801719665527
UPDATE products SET price = '13499' WHERE id = '408792'
579 0.0003 0.00025320053100586
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
580 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '403517'
581 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '403517'
582 0.0029 0.0029401779174805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
583 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0004 0.00040411949157715
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00012016296386719
UPDATE products SET price = '6699' WHERE id = '403517'
587 0.0004 0.00039911270141602
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
588 0.0001 0.00013184547424316
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
589 0.0001 0.00013899803161621
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
590 0.0001 0.00012111663818359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
591 0.0004 0.00039505958557129
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.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
594 0.0009 0.0009000301361084
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
595 0.0003 0.00029993057250977
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
596 0.0003 0.00028300285339355
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
597 0.0003 0.00034499168395996
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
598 0.0001 0.00013208389282227
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0001 0.0001218318939209
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0001 0.00012898445129395
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
601 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0004 0.00035190582275391
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
604 0.0003 0.00033211708068848
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'