Tactical Equipment - Survivalist Equipment
   

Combat Situational Awareness

Combat Sitautional Awareness

The whole concept of situational awareness is so integral to our discussion of personal safety that it appears in some form within virtually every column. It's one of those things that we take for granted, like sunlight and clean drinking water.

For me, situational awareness is something that's been cultivated over the years and is so habituated as to be unconscious. Though I am not the world's greatest living practitioner or expert on combat situational awareness, it is a keystone of my personal survival program and has literally become second nature. So far, it has worked and will hopefully still be working when you read this.

At its most basic, combat situational awareness is simply knowing what is happening around you. Because action is always faster than reaction, you stand a far greater chance of saving your skin in a crisis if you see the proverbial curve ball coming. No matter what the potential source of danger is, by maintaining a reasonable level of situational awareness at all times, you can see a problem looming beforehand and greatly increase your chances of surviving an emergency.

Situational Awareness can be likened to weather radar. It's always on, searching, looking for problems, even when there are none. When a blip arises on our screen, we monitor it until it goes away or we've decided there wasn't really a problem in the first place.

The process of building your combat situational awareness starts by cultivating a habit of noticing the things around you, regardless of your mental status bored, tired, busy, or otherwise engaged. This is one of those "simple but not easy" things to do. At first, it takes conscious and constant effort to remind yourself to look up, down and all around your world. The goal is to use all your senses and truly "see" the world around you in three dimensions.

However, for those who are serious about personal safety, I believe that good combat situational awareness requires more than simply detecting unusual items within your environment. Seeing potential problems is certainly critical, but the second part of my definition of good situational awareness requires an understanding of those facts that your senses have gathered. This means analysis of the environmental clues.

Fortunately, you probably have personality traits that can help in this task. Healthy fear is an important one, along with curiosity. Let's talk about fear.

A strong sense of self-preservation, coupled with an honest appraisal of the dangers faced as you conduct your daily business, is almost guaranteed to inspire some level of apprehension within you. Heck, just reading the daily news is enough to make you double lock your front door and make sure the shotgun in the bedroom is still loaded.

However, instead of fretting about what could happen, channel your concerns into a strong, nearly unquenchable desire to see, hear, smell and possibly taste everything taking place around you. If you have really considered the pitfalls of modern living, it seems nearly impossible not to constantly look around.

Curiosity isthe trait that develops the habit of analysis, which results in the understanding we seek. As a naturally curious person, I want to comprehend everything around me, whether it's an odd tree I encounter while hiking or a strange noise while I'm on patrol.

In the personal safety arena, I find myself constantly wondering "Why?" For instance, why isthat group of disadvantaged urban youths showing singular interest in my vehicle? Why would a man be walking down the middle of the street carrying a shovel? Why is there a heap of record albums lying in the middle of the street? All of these things could have a perfectly harmless explanation, but you must consider the various possibilities before dismissing them as innocent.

For instance, record albums lying in the street might mean a burglary has just occurred, or could be the result of a domestic dispute that got heated enough for someone to throw their boyfriend's prized music collection into the street. After analysis, you begin to better understand and foresee the potential dangers of your environment.

After taking stock of things, don't go into full combat mode. Rather, simply turn up your awareness a bit and begin to think about possible actions should you stumble upon a broken music-store window or two people in a violent argument on the sidewalk.

In addition, don't take it for granted that this is the only problem in the immediate area.Situational awareness is a constant ongoing process that continually evaluates the surroundings, people and situations in your vicinity. Just because there is one storm on the horizon doesn't mean there isn't a second, third or more.

I will unapologetically continue to stomp upon the corpse of that old gray mare we call combat situational awareness because it is inarguably the foundation of everything important regarding personal security. You might get tired of hearing about it, but that doesn't make it any less critical.

After all, it doesn't matter how much cool-guy gear, guns and tactics you possess if you don't see the problem coming beforehand, you're likely to end up just as dead as that horse.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.3020401000977 605 0.5932 0


No Amazon API Requests Made.


App Debug - Total Time 1.3020401000977 seconds

Number Time From Start Name Description
1 0.44004201889038 Initialise Initialise FSB Function
2 0.44887590408325 App Controller Start Start of the App controller (called before the controller of every page)
3 0.46090507507324 Start of getCategoryListByGroup Function Before first category groups query
4 0.46110010147095 After initial query Before first category groups query
5 0.46110200881958 Get Category List for Group Before the call to getCategoryList function
6 0.46110486984253 Start of GetCategoryList function Start of the function
7 0.46111106872559 Before getting categories Query to get specific category list
8 0.46179795265198 After getting categories Query to get specific category list
9 0.46180009841919 Before getting category custom Before call to function getCategoryCustom
10 0.46384286880493 After getting category custom After call to function getCategoryCustom
11 0.46384596824646 Before getting category custom Before call to function getCategoryCustom
12 0.47448587417603 After getting category custom After call to function getCategoryCustom
13 0.47448897361755 Before getting category custom Before call to function getCategoryCustom
14 0.48011088371277 After getting category custom After call to function getCategoryCustom
15 0.4801139831543 Before getting category custom Before call to function getCategoryCustom
16 0.48433494567871 After getting category custom After call to function getCategoryCustom
17 0.48433804512024 End of GetCategoryList function End of the function
18 0.48434686660767 Get Category List for Group Before the call to getCategoryList function
19 0.48434901237488 Start of GetCategoryList function Start of the function
20 0.48435187339783 Before getting categories Query to get specific category list
21 0.48481798171997 After getting categories Query to get specific category list
22 0.4848198890686 Before getting category custom Before call to function getCategoryCustom
23 0.49043202400208 After getting category custom After call to function getCategoryCustom
24 0.49043488502502 Before getting category custom Before call to function getCategoryCustom
25 0.50106406211853 After getting category custom After call to function getCategoryCustom
26 0.50106596946716 End of GetCategoryList function End of the function
27 0.50107288360596 Get Category List for Group Before the call to getCategoryList function
28 0.50107598304749 Start of GetCategoryList function Start of the function
29 0.50107908248901 Before getting categories Query to get specific category list
30 0.50197696685791 After getting categories Query to get specific category list
31 0.50197887420654 Before getting category custom Before call to function getCategoryCustom
32 0.51121306419373 After getting category custom After call to function getCategoryCustom
33 0.51121592521667 Before getting category custom Before call to function getCategoryCustom
34 0.52845788002014 After getting category custom After call to function getCategoryCustom
35 0.52846097946167 Before getting category custom Before call to function getCategoryCustom
36 0.5345139503479 After getting category custom After call to function getCategoryCustom
37 0.53451704978943 Before getting category custom Before call to function getCategoryCustom
38 0.54049301147461 After getting category custom After call to function getCategoryCustom
39 0.54049587249756 Before getting category custom Before call to function getCategoryCustom
40 0.54676508903503 After getting category custom After call to function getCategoryCustom
41 0.54676699638367 Before getting category custom Before call to function getCategoryCustom
42 0.56860303878784 After getting category custom After call to function getCategoryCustom
43 0.56860589981079 Before getting category custom Before call to function getCategoryCustom
44 0.57274198532104 After getting category custom After call to function getCategoryCustom
45 0.57274508476257 Before getting category custom Before call to function getCategoryCustom
46 0.57741093635559 After getting category custom After call to function getCategoryCustom
47 0.5774130821228 End of GetCategoryList function End of the function
48 0.57742691040039 Get Category List for Group Before the call to getCategoryList function
49 0.57743000984192 Start of GetCategoryList function Start of the function
50 0.57743406295776 Before getting categories Query to get specific category list
51 0.57789087295532 After getting categories Query to get specific category list
52 0.57789301872253 Before getting category custom Before call to function getCategoryCustom
53 0.58028697967529 After getting category custom After call to function getCategoryCustom
54 0.58029007911682 Before getting category custom Before call to function getCategoryCustom
55 0.58268904685974 After getting category custom After call to function getCategoryCustom
56 0.58269095420837 End of GetCategoryList function End of the function
57 0.58269691467285 Get Category List for Group Before the call to getCategoryList function
58 0.58270001411438 Start of GetCategoryList function Start of the function
59 0.58270287513733 Before getting categories Query to get specific category list
60 0.58305597305298 After getting categories Query to get specific category list
61 0.58305692672729 Before getting category custom Before call to function getCategoryCustom
62 0.58807897567749 After getting category custom After call to function getCategoryCustom
63 0.58808088302612 End of GetCategoryList function End of the function
64 0.58808708190918 End of getCategoryListByGroup Function Before return()
65 0.64486908912659 App Controller End End of the App controller (called before the controller of every page)
66 0.64662909507751 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.64677309989929 Before Get Options Before the call to getOptions in the tpl class
68 1.063952922821 After Get Options After the call to getOptions in the tpl class
69 1.0640320777893 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.30202293396 Finalizing debug Before the debug is output to the page.
71 1.3020389080048 End of App This is the end of the app logging, final timestamp


Query Debug - 605 Database Queries. Total time 0.5932 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016617774963379
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00045108795166016
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00016498565673828
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00017094612121582
SELECT * FROM `bad_bots`
5 0.0005 0.0004580020904541
SELECT parameter, value FROM parameters
6 0.0002 0.00016593933105469
SET time_zone = 'Europe/London'
7 0.0003 0.00028395652770996
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00020384788513184
UPDATE autorun SET lastrun = '2019-06-18 16:59:31' WHERE id = '16'
9 0.0002 0.00016593933105469
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0001 0.00010204315185547
delete from cachefiles
11 0.0002 0.00023007392883301
SELECT id FROM pages WHERE pagename = 'combat-situational-awareness' LIMIT 1
12 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = 108
13 0.0009 0.00086784362792969
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
14 0.0096 0.009598970413208
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
15 0.0003 0.00026082992553711
SELECT * FROM pages WHERE pagename = 'combat-situational-awareness'
16 0.0002 0.00017595291137695
SELECT * FROM categorygroups ORDER BY sortorder ASC
17 0.0006 0.00059199333190918
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
18 0.0005 0.00051307678222656
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 49
19 0.0003 0.00025105476379395
SELECT id FROM categories WHERE parent_id = '49'
20 0.0005 0.00047087669372559
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.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 (49)
				  AND p.disabled = 0 
22 0.0002 0.00016617774963379
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
23 0.0002 0.00018811225891113
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
24 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '1'
25 0.0029 0.0029439926147461
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 50
26 0.0003 0.00027990341186523
SELECT id FROM categories WHERE parent_id = '50'
27 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '96'
28 0.0002 0.0002138614654541
SELECT id FROM categories WHERE parent_id = '97'
29 0.0002 0.0002129077911377
SELECT id FROM categories WHERE parent_id = '111'
30 0.0002 0.00022387504577637
SELECT id FROM categories WHERE parent_id = '129'
31 0.0057 0.0056829452514648
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
32 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
33 0.0002 0.00017213821411133
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
34 0.0002 0.00018692016601562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
35 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '1'
36 0.0023 0.0022759437561035
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 80
37 0.0003 0.0002739429473877
SELECT id FROM categories WHERE parent_id = '80'
38 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 (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0002 0.00015616416931152
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
40 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 (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
41 0.0002 0.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
42 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '1'
43 0.0012 0.0011579990386963
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 51
44 0.0003 0.0002601146697998
SELECT id FROM categories WHERE parent_id = '51'
45 0.0002 0.00022101402282715
SELECT id FROM categories WHERE parent_id = '101'
46 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 
47 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 (101,51)
				  AND p.disabled = 0 
48 0.0002 0.00017213821411133
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
49 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
50 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '1'
51 0.0004 0.00043487548828125
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
52 0.0023 0.0022690296173096
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0003 0.0002598762512207
SELECT id FROM categories WHERE parent_id = '30'
54 0.0023 0.0022969245910645
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
55 0.0002 0.00015783309936523
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
56 0.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 (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
57 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
58 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '2'
59 0.0048 0.0047581195831299
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 61
60 0.0003 0.0002739429473877
SELECT id FROM categories WHERE parent_id = '61'
61 0.0048 0.0048038959503174
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (61)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
62 0.0002 0.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 
63 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 
64 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
65 0.0001 0.00014305114746094
SELECT * FROM categorygroups WHERE id = '2'
66 0.0007 0.00074100494384766
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
67 0.0041 0.0040791034698486
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 64
68 0.0003 0.00027704238891602
SELECT id FROM categories WHERE parent_id = '64'
69 0.0041 0.0040919780731201
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (64)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
70 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
71 0.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 (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
72 0.0002 0.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
73 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
74 0.0080 0.0080339908599854
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 65
75 0.0003 0.00028491020202637
SELECT id FROM categories WHERE parent_id = '65'
76 0.0081 0.0080950260162354
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
77 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
78 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
79 0.0002 0.0001838207244873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
80 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
81 0.0025 0.0025148391723633
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 81
82 0.0003 0.00028085708618164
SELECT id FROM categories WHERE parent_id = '81'
83 0.0025 0.0024969577789307
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
84 0.0002 0.00016617774963379
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
85 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 (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
86 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
87 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
88 0.0024 0.0024371147155762
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
89 0.0003 0.00027108192443848
SELECT id FROM categories WHERE parent_id = '31'
90 0.0025 0.0024809837341309
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
91 0.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 (31)
				  AND p.disabled = 0 
92 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 (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
93 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
94 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
95 0.0022 0.0022070407867432
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 66
96 0.0003 0.0002748966217041
SELECT id FROM categories WHERE parent_id = '66'
97 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '131'
98 0.0028 0.0027890205383301
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
99 0.0002 0.00016379356384277
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
100 0.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 (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
101 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
102 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '10'
103 0.0094 0.0093579292297363
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 34
104 0.0003 0.00029087066650391
SELECT id FROM categories WHERE parent_id = '34'
105 0.0002 0.00022315979003906
SELECT id FROM categories WHERE parent_id = '94'
106 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '98'
107 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '99'
108 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '110'
109 0.0002 0.00020980834960938
SELECT id FROM categories WHERE parent_id = '130'
110 0.0102 0.010211944580078
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
111 0.0002 0.00019097328186035
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
112 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
113 0.0002 0.00019288063049316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
114 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
115 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
116 0.0003 0.00026416778564453
SELECT id FROM categories WHERE parent_id = '32'
117 0.0016 0.0015850067138672
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
118 0.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 (32)
				  AND p.disabled = 0 
119 0.0002 0.00015783309936523
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
120 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
121 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
122 0.0018 0.0017991065979004
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 89
123 0.0003 0.00026106834411621
SELECT id FROM categories WHERE parent_id = '89'
124 0.0018 0.0018379688262939
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
125 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
126 0.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 (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
127 0.0002 0.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
128 0.0001 0.00013613700866699
SELECT * FROM categorygroups WHERE id = '10'
129 0.0004 0.00042390823364258
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
130 0.0007 0.00069212913513184
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 84
131 0.0002 0.00024819374084473
SELECT id FROM categories WHERE parent_id = '84'
132 0.0007 0.00070595741271973
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
133 0.0001 0.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 
134 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 (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
135 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
136 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '17'
137 0.0007 0.00069403648376465
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 90
138 0.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '90'
139 0.0007 0.00073003768920898
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
140 0.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 (90)
				  AND p.disabled = 0 
141 0.0002 0.00015687942504883
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
142 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
143 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '17'
144 0.0003 0.00032687187194824
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
145 0.0020 0.0020039081573486
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 92
146 0.0003 0.00025510787963867
SELECT id FROM categories WHERE parent_id = '92'
147 0.0020 0.0020167827606201
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
148 0.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 (92)
				  AND p.disabled = 0 
149 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
150 0.0002 0.00016379356384277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
151 0.0001 0.00014901161193848
SELECT * FROM categorygroups WHERE id = '20'
152 0.0053 0.0052559375762939
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
153 0.0004 0.00037503242492676
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
154 0.0002 0.00016903877258301
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
155 0.0002 0.00016593933105469
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
156 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '67'
157 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '82'
158 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '84'
159 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '94'
160 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '116'
161 0.0002 0.00024795532226562
SELECT * FROM pages WHERE id = '52'
162 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '135'
163 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '245'
164 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '269'
165 0.0002 0.00023388862609863
SELECT * FROM pages WHERE id = '275'
166 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '280'
167 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '357'
168 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '379'
169 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '401'
170 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '450'
171 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '454'
172 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '457'
173 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '458'
174 0.0002 0.00016999244689941
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
175 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '41'
176 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '43'
177 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '44'
178 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '68'
179 0.0003 0.00026798248291016
SELECT * FROM pages WHERE id = '80'
180 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '85'
181 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '97'
182 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '107'
183 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '108'
184 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '128'
185 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '133'
186 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '148'
187 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '217'
188 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '228'
189 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '257'
190 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '271'
191 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '286'
192 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '287'
193 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '291'
194 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '380'
195 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '344'
196 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '354'
197 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '363'
198 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '364'
199 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '368'
200 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '369'
201 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '400'
202 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '463'
203 0.0002 0.00019598007202148
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
204 0.0003 0.00030398368835449
SELECT * FROM pages WHERE id = '66'
205 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '77'
206 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '90'
207 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '414'
208 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '119'
209 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '406'
210 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '149'
211 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '150'
212 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '412'
213 0.0002 0.00018119812011719
SELECT * FROM pages WHERE id = '162'
214 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '164'
215 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '167'
216 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '180'
217 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '187'
218 0.0002 0.00021982192993164
SELECT * FROM pages WHERE id = '265'
219 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '268'
220 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '411'
221 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '290'
222 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '413'
223 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '409'
224 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '327'
225 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '336'
226 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '351'
227 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '358'
228 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '360'
229 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '362'
230 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '366'
231 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '370'
232 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '377'
233 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '386'
234 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '408'
235 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '415'
236 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '416'
237 0.0002 0.00021219253540039
SELECT * FROM pages WHERE id = '419'
238 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '423'
239 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '427'
240 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '428'
241 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '432'
242 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '433'
243 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '436'
244 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '437'
245 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '461'
246 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '464'
247 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
248 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '74'
249 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '137'
250 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '145'
251 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '156'
252 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '407'
253 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '410'
254 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '266'
255 0.0003 0.00026297569274902
SELECT * FROM pages WHERE id = '316'
256 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '332'
257 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '334'
258 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '367'
259 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '387'
260 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '389'
261 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '397'
262 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '449'
263 0.0002 0.00017881393432617
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
264 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '42'
265 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '79'
266 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '86'
267 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '95'
268 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '102'
269 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '109'
270 0.0003 0.0002741813659668
SELECT * FROM pages WHERE id = '114'
271 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '121'
272 0.0002 0.00022602081298828
SELECT * FROM pages WHERE id = '138'
273 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '142'
274 0.0002 0.00022411346435547
SELECT * FROM pages WHERE id = '62'
275 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '157'
276 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '246'
277 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '276'
278 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '278'
279 0.0002 0.00024604797363281
SELECT * FROM pages WHERE id = '279'
280 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '317'
281 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '405'
282 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '343'
283 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '345'
284 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '346'
285 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '347'
286 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '348'
287 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '349'
288 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '381'
289 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '392'
290 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '393'
291 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '394'
292 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '395'
293 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '399'
294 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '421'
295 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '426'
296 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '430'
297 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '431'
298 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '434'
299 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '435'
300 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '440'
301 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '441'
302 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '451'
303 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '453'
304 0.0002 0.00015997886657715
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
305 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '146'
306 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '158'
307 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '163'
308 0.0002 0.00024819374084473
SELECT * FROM pages WHERE id = '293'
309 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '340'
310 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '417'
311 0.0002 0.00016903877258301
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
312 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '173'
313 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '181'
314 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '288'
315 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '299'
316 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '300'
317 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '383'
318 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '385'
319 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '438'
320 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '442'
321 0.0002 0.00015592575073242
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
322 0.0003 0.00026798248291016
SELECT * FROM pages WHERE id = '103'
323 0.0002 0.00023794174194336
SELECT * FROM pages WHERE id = '134'
324 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '139'
325 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '143'
326 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '234'
327 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '248'
328 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '260'
329 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '398'
330 0.0002 0.00017809867858887
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
331 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '61'
332 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '87'
333 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '104'
334 0.0002 0.00023102760314941
SELECT * FROM pages WHERE id = '115'
335 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '124'
336 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '144'
337 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '151'
338 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '199'
339 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '200'
340 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '304'
341 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '321'
342 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '333'
343 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '350'
344 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '378'
345 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '422'
346 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '425'
347 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '443'
348 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '444'
349 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '445'
350 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '446'
351 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '447'
352 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '448'
353 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '455'
354 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '456'
355 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '459'
356 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '460'
357 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '462'
358 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
359 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '153'
360 0.0002 0.00022315979003906
SELECT * FROM pages WHERE id = '182'
361 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '238'
362 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '240'
363 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '242'
364 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '252'
365 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '253'
366 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '262'
367 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '267'
368 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '420'
369 0.0001 0.00014996528625488
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
370 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
371 0.0001 0.00014376640319824
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
372 0.0014 0.0014040470123291
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
373 0.0003 0.00026798248291016
SELECT * FROM pages WHERE pagename = 'combat-situational-awareness'
374 0.0002 0.00021004676818848
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
375 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = 2
376 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = 4
377 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = 12
378 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = 10
379 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = 7
380 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = 18
381 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = 28
382 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = 13
383 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = 3
384 0.0426 0.042622804641724
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
385 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:1560877172;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:5;s:6:\"171938\";i:7;s:6:\"404554\";i:8;s:6:\"412927\";i:10;s:6:\"408792\";i:14;s:6:\"403517\";}}' WHERE id = '175'
386 0.0005 0.00048303604125977
SELECT * FROM products WHERE id IN (398315,171938,404554,412927,408792,403517) ORDER BY FIELD(id, 398315,171938,404554,412927,408792,403517 )
387 0.0002 0.00024080276489258
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
388 0.0002 0.00024104118347168
SELECT * FROM product_image_select WHERE product_id = '398315'
389 0.0002 0.00015592575073242
SELECT * FROM productcustomimages WHERE product_id = '398315'
390 0.0025 0.0024969577789307
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
391 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
392 0.0002 0.00022792816162109
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
393 0.0004 0.00039792060852051
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
394 0.0001 0.00013899803161621
UPDATE products SET price = '1999' WHERE id = '398315'
395 0.0006 0.00064206123352051
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
396 0.0002 0.00024199485778809
SELECT * FROM product_image_select WHERE product_id = '171938'
397 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '171938'
398 0.0025 0.0025198459625244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
399 0.0002 0.00020790100097656
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
400 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
401 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
402 0.0001 0.00013208389282227
UPDATE products SET price = '389500' WHERE id = '171938'
403 0.0003 0.00029802322387695
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
404 0.0002 0.0002288818359375
SELECT * FROM product_image_select WHERE product_id = '404554'
405 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '404554'
406 0.0033 0.0033349990844727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
407 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
408 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
409 0.0005 0.00045680999755859
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
410 0.0001 0.00013113021850586
UPDATE products SET price = '399999' WHERE id = '404554'
411 0.0003 0.0002751350402832
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
412 0.0002 0.0002288818359375
SELECT * FROM product_image_select WHERE product_id = '412927'
413 0.0001 0.0001368522644043
SELECT * FROM productcustomimages WHERE product_id = '412927'
414 0.0036 0.0036377906799316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
415 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
416 0.0002 0.0002291202545166
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
417 0.0005 0.0004580020904541
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
418 0.0001 0.00013113021850586
UPDATE products SET price = '199900' WHERE id = '412927'
419 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
420 0.0002 0.00023889541625977
SELECT * FROM product_image_select WHERE product_id = '408792'
421 0.0001 0.00013184547424316
SELECT * FROM productcustomimages WHERE product_id = '408792'
422 0.0036 0.0035920143127441
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
423 0.0002 0.00020217895507812
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
424 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
425 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
426 0.0001 0.00013995170593262
UPDATE products SET price = '13499' WHERE id = '408792'
427 0.0003 0.0002741813659668
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
428 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '403517'
429 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '403517'
430 0.0029 0.0029120445251465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
431 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
432 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
433 0.0004 0.00041604042053223
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
434 0.0001 0.00012898445129395
UPDATE products SET price = '6699' WHERE id = '403517'
435 0.0422 0.042242050170898
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
436 0.0002 0.00023293495178223
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:1560877172;s:8:\"products\";a:6:{i:7;s:6:\"404554\";i:13;s:6:\"370121\";i:15;s:6:\"414825\";i:17;s:6:\"406758\";i:22;s:6:\"131163\";i:3;s:6:\"407595\";}}' WHERE id = '177'
437 0.0004 0.00044703483581543
SELECT * FROM products WHERE id IN (404554,370121,414825,406758,131163,407595) ORDER BY FIELD(id, 404554,370121,414825,406758,131163,407595 )
438 0.0003 0.00030803680419922
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
439 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '404554'
440 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '404554'
441 0.0034 0.003364086151123
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
442 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
443 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
444 0.0005 0.00046920776367188
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
445 0.0001 0.00013303756713867
UPDATE products SET price = '399999' WHERE id = '404554'
446 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
447 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '370121'
448 0.0001 0.00013422966003418
SELECT * FROM productcustomimages WHERE product_id = '370121'
449 0.0028 0.0027530193328857
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
450 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
451 0.0002 0.0002288818359375
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
452 0.0004 0.00040221214294434
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
453 0.0001 0.00012898445129395
UPDATE products SET price = '9899' WHERE id = '370121'
454 0.0002 0.00022697448730469
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
455 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '414825'
456 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '414825'
457 0.0020 0.0020179748535156
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
458 0.0002 0.00019717216491699
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
459 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
460 0.0004 0.00037813186645508
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
461 0.0001 0.00012993812561035
UPDATE products SET price = '11999' WHERE id = '414825'
462 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
463 0.0002 0.00023794174194336
SELECT * FROM product_image_select WHERE product_id = '406758'
464 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '406758'
465 0.0026 0.0025720596313477
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
466 0.0002 0.00020217895507812
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
467 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
468 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
469 0.0001 0.00013208389282227
UPDATE products SET price = '2694' WHERE id = '406758'
470 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
471 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '131163'
472 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '131163'
473 0.0026 0.0025629997253418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
474 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
475 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
476 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
477 0.0001 0.00013089179992676
UPDATE products SET price = '20362' WHERE id = '131163'
478 0.0002 0.00024318695068359
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
479 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '407595'
480 0.0001 0.00013279914855957
SELECT * FROM productcustomimages WHERE product_id = '407595'
481 0.0033 0.0033349990844727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
482 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
483 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
484 0.0004 0.00044989585876465
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
485 0.0001 0.00013017654418945
UPDATE products SET price = '2497' WHERE id = '407595'
486 0.1041 0.10408401489258
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
487 0.0003 0.00028300285339355
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:1560877172;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:6;s:6:\"170197\";i:9;s:6:\"409759\";i:14;s:6:\"403517\";i:21;s:6:\"405644\";i:5;s:6:\"171938\";}}' WHERE id = '181'
488 0.0005 0.00048398971557617
SELECT * FROM products WHERE id IN (414940,170197,409759,403517,405644,171938) ORDER BY FIELD(id, 414940,170197,409759,403517,405644,171938 )
489 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
490 0.0002 0.0002448558807373
SELECT * FROM product_image_select WHERE product_id = '414940'
491 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '414940'
492 0.0032 0.0032339096069336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
493 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
494 0.0002 0.00024509429931641
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
495 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
496 0.0001 0.00013184547424316
UPDATE products SET price = '4490' WHERE id = '414940'
497 0.0007 0.00069308280944824
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
498 0.0002 0.00023794174194336
SELECT * FROM product_image_select WHERE product_id = '170197'
499 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '170197'
500 0.0032 0.003154993057251
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
501 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
502 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
503 0.0004 0.00043416023254395
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
504 0.0001 0.00013303756713867
UPDATE products SET price = '324500' WHERE id = '170197'
505 0.0002 0.00022196769714355
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
506 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '409759'
507 0.0001 0.00014185905456543
SELECT * FROM productcustomimages WHERE product_id = '409759'
508 0.0028 0.0027890205383301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
509 0.0002 0.00020289421081543
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
510 0.0002 0.00021886825561523
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
511 0.0004 0.00040984153747559
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
512 0.0001 0.00013399124145508
UPDATE products SET price = '229000' WHERE id = '409759'
513 0.0003 0.00028800964355469
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
514 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '403517'
515 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '403517'
516 0.0029 0.0029149055480957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
517 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
518 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
519 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
520 0.0001 0.00012993812561035
UPDATE products SET price = '6699' WHERE id = '403517'
521 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
522 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '405644'
523 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '405644'
524 0.0034 0.0033659934997559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
525 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
526 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
527 0.0004 0.00043916702270508
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
528 0.0001 0.00013089179992676
UPDATE products SET price = '63539' WHERE id = '405644'
529 0.0006 0.00063300132751465
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
530 0.0002 0.00023388862609863
SELECT * FROM product_image_select WHERE product_id = '171938'
531 0.0001 0.00014400482177734
SELECT * FROM productcustomimages WHERE product_id = '171938'
532 0.0025 0.0025269985198975
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
533 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
534 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
535 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
536 0.0001 0.00013113021850586
UPDATE products SET price = '389500' WHERE id = '171938'
537 0.1039 0.10388112068176
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
538 0.0003 0.00027894973754883
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:1560877172;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:17;s:6:\"406758\";i:18;s:6:\"130885\";i:19;s:6:\"147874\";i:23;s:6:\"410949\";i:2;s:6:\"398858\";}}' WHERE id = '183'
539 0.0005 0.00046396255493164
SELECT * FROM products WHERE id IN (398315,406758,130885,147874,410949,398858) ORDER BY FIELD(id, 398315,406758,130885,147874,410949,398858 )
540 0.0002 0.00023913383483887
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
541 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '398315'
542 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '398315'
543 0.0025 0.0024929046630859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
544 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
545 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
546 0.0004 0.00039911270141602
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
547 0.0001 0.00014495849609375
UPDATE products SET price = '1999' WHERE id = '398315'
548 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
549 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '406758'
550 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '406758'
551 0.0026 0.0025908946990967
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
552 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
553 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
554 0.0004 0.00040793418884277
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
555 0.0001 0.00013089179992676
UPDATE products SET price = '2694' WHERE id = '406758'
556 0.0002 0.00020813941955566
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
557 0.0002 0.00022721290588379
SELECT * FROM product_image_select WHERE product_id = '130885'
558 0.0001 0.00013995170593262
SELECT * FROM productcustomimages WHERE product_id = '130885'
559 0.0020 0.0019879341125488
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
560 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
561 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
562 0.0004 0.00036382675170898
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
563 0.0001 0.00013899803161621
UPDATE products SET price = '1521' WHERE id = '130885'
564 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '147874' ORDER BY sortorder ASC
565 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '147874'
566 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '147874'
567 0.0028 0.0028109550476074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '147874' AND a.name = n.originalname
568 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '147874' AND merchantid = 'ATVPDKIKX0DER'
569 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '147874' AND price > 0
                ORDER BY price ASC LIMIT 1
570 0.0004 0.00041103363037109
SELECT value FROM productattributes WHERE product_id = '147874' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
571 0.0001 0.00012803077697754
UPDATE products SET price = '599' WHERE id = '147874'
572 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
573 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '410949'
574 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '410949'
575 0.0027 0.0026562213897705
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
576 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
577 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
578 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
579 0.0001 0.00013113021850586
UPDATE products SET price = '47995' WHERE id = '410949'
580 0.0002 0.00020217895507812
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
581 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '398858'
582 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '398858'
583 0.0030 0.0029699802398682
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
584 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
585 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
586 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
587 0.0001 0.00012779235839844
UPDATE products SET price = '2999' WHERE id = '398858'
588 0.0004 0.0004270076751709
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
589 0.0001 0.00014901161193848
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
590 0.0001 0.00013589859008789
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
591 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
592 0.0004 0.00041699409484863
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
593 0.0001 0.00013899803161621
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
594 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
595 0.0009 0.00092101097106934
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
596 0.0003 0.00033020973205566
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
597 0.0003 0.00029397010803223
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
598 0.0004 0.00036096572875977
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
599 0.0001 0.00014805793762207
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0001 0.00013613700866699
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
601 0.0001 0.00014591217041016
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.00013494491577148
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
604 0.0004 0.00038003921508789
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
605 0.0003 0.00034093856811523
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'