Tactical Equipment - Survivalist Equipment
   

How Night Vision Optics Work And What To Look For Before You Buy . . .

How to chose night vision

UPDATED :  

HUMAN BEINGS DO NOT NATURALLY POSSESS THE ABILITY TO SEE IN THE DARK...

But we are the ultimate tool users. What we do not naturally possess we can create a substitute for, as is the case with night vision. Let's take a look at the three major types of night vision devices (NVD).

THERMAL IMAGERY NIGHT VISION DEVICES

ATN ThOR Thermal Weapon Scope

ABOVE : The ThOR by ATN (American Technologies Network Corp.) is an example of a thermal weapon scope.

Thermal imagery is based on the transference of energy, energy being heat in this case. As energy transfers from one object to another, infrared light is emitted.

The ability of a surface to emit thermal energy is called emissivity. Thermal imagery displays the difference in energy being emitted between an object and its surroundings in the form of an image. All objects emit infrared light in varying degrees. Objects with more heat always transfer their energy to items with less heat. Energy transference is why with thermal imagery you can se e where a person just touched a tree or where a suspect just threw a gun away.

THERMAL IMAGERY: BOTH SIDES

THE PROS

  • No lightis needed with thermal imagery because every object gives off some level of infrared. If you have to follow an individual who is underground or sweep a structure at night with no windows, thermal imagery will work.

  • If the device's sensors have a high level of sensitivity, an individual cannot hide from the thermal imager unless he is wearing specialty clothing not available to the public.

  • Thermal cameras are capable of detecting any type of heat variance. They can detect warm engines and items that have been recently touched. In my area. we have a number of com crops; people have hidden marijuana crops in among the com. Planes equipped with thermal imagery equipment can detect the marijuana because it has a different heat signature than the common foliage.

  • Thermal imaging devices will work in the fog or under smoky conditions because a body still gives off heat into the surrounding environment. Those conditions might affect our vision, but a thermal imagery device is only concerned with the contrast of the person's body heat to the surrounding environment.

  • Thermal imagery devices are solid-state electronic equipment as opposed to tube technology. If cared for properly, they can last a very long time.

THE CONS

  • Thermal images can be difficult to interpret at times. Say you see an image of something lying on the ground in the distance. There might not be enough detail to tell if that is an animal or a person. Or you might have an image of a man carrying a firearm, but you cannot identify him.

  • Accurate images can be hard to get because of the different emissivity of surfaces or the reflection off a surface. If you are looking for a lost hiker during a search and rescue operation, that hiker might be hard to spot if he wrapped himself in a Mylar survival blanket. The Mylar blanket not only has a poor emissivity, it also reflects the energy of objects around it, possibly making the hiker difficult to detect.

PASSIVE NIGHT VISION IMAGE INTENSIFIERS

12 Survivors Trace 5x50 Night Vision

ABOVE : The 12 Survivors Trace 5x50 NV recording monocular is equipped with a built-in video recorder.

Image intensifier technology uses optics in combination with an image intensifier tube to generate a visible image. The image intensifier tube is a vacuum tube that has a photocathode plate, micro-channel plate and a screen.

When photons of light strike the photo-cathode plate, the plate emits electrons. This is referred to as the photoelectric effect. The electrons then travel across the tube and pass through the micro-channel plate (MCP).

As the electrons pass through the MCP, they are amplified and then strike the screen, which produces an image that a camera or the human eye can see.

LIGHT WONT BLIND NV USERS

Did you ever see a movie in which people using night vision devices were blinded by the sudden introduction of bright light? This is prevented by a mechanism known as auto-gating (ATG).

Auto-gating regulates the amount of light that gets through the micro-channel plate (MCP) in a night vision device. This is designed to protect the tube from being damaged and failing when exposed to bright light.

This comes in handy for the user because the ATG function allows the device to be used in varying light conditions. If a group of soldiers is clearing a building and they come upon a lit room, they are not blinded and do not lose the use of their devices. The devices simply adjust to the brighter light levels.

ACTIVE ILLUMINATION NIGHT VISION

Firefield Nightfall 5x50 NV monocular with built in IR illuminator

ABOVE : The Firefield Nightfall 5x50 NV monocular has a built-in IR illuminator and has a range of detection of 140 yards.

Both of the first two systems are passive systems. They rely on light or infrared light that is already there. The third type of system is referred to as active because you flood the area with either near infrared (NIR) light or infrared (IR) light depending on the system you're using.

If you are operating an image intensifier system in low light to zero light conditions such as in a building with no windows, you would then flood the area with NIR.

If you were using an active infrared system, you would then flood the area with IR light in the bandwidth just below the human capability to see it. Flooding the area with infrared light usually results in a high-resolution image.

Active systems are commonly used on large vehicles. In the case of law enforcement, police helicopters will use an active system to follow suspects. A downside to active systems is that because you are actively flooding an area, anyone with night vision of their own will be able to see your location, giving away any stealth advantage.

IMAGE INTENSIFIERS: BOTH SIDES

Pulsar N550A digital night vision rifle scope

ABOVE : The Pulsar N550A digital NV rifle scope offers 13 reticle options and the ability to save 3 zeros for different loads, ranges or weapons.

THE PROS

Pulsar Quantum HD38S Thermal Imaging MonocularThe Pulsar Quantum HD38S Thermal Imaging Monocular can detect heat signatures up to 900 yards away.

Image intensified night vision provides more detail, allowing you to identify the target or suspects. It also provides more detail about terrain than thermal imagery, making it easier to navigate rough terrain at night. A sharper image from image intensifying equipment also allows positive identification of an actual individual.

THE CONS

Sources of bright light, such as headlights or streetlights, can limit the device's ability. Bright sources of light can obscure the operator's vision if the light is not enough to actually cause the device to shut off. Streetlights might cause a heavy halo effect.

Image intensifying devices cannot see through smoke or fog. The device will show you an image as it is. If you are looking in a wooded area for a camouflaged individual, then you have to rely on your own ability to pick him out of the landscape.

Image intensifying units use hollow state technology, meaning they use vacuum tubes. Vacuum tubes have limited life spans based on hours used. So eventually, no matter how well you take care of it, with use it will require replacement.

Pulsar DFA75 forward night vision attachment

ABOVE : The Pulsar DFA75 forward NV attachment connects directly to the objective lens of your rifle scope to provide NV capabilities.

Sightmark Ghost Hunter 4x50 NV binocular Sightmark Ghost Hunter 1x24

ABOVE LEFT : The Sightmark Ghost Hunter 4x50 NV binocular has a high power built-in IR illuminator. It runs on two AAA batteries.

ABOVE RIGHT : The Sightmark Ghost Hunter 1x24 goggle kit comes with a head mount for hands-free operation.


HOW TO SHOP FOR IMAGE INTENSIFIER DEVICES

4 KEY FACTS

1. Which generation? Image intensifier tubes technology has been defined in generations. Currently available are Gen 2 and Gen 3. Although Gen 2 has some of the features of Gen 3, such as automating (ATG), there are still other differences.

Not to take the easy way out, but I could write another whole article just on the generation developments. Before buying, research the differences to see if you actually need the latest and greatest.

2. Quality optics. Image intensifies also utilize optics. The quality of your optics will affect the quality of your image as much as the image intensifying tube itself. Resolution is measured in line pairs per millimeter (lp/mm). A high resolution means that your picture shows more detail allowing you to distinguish between objects, or identify items and people.

3. Power source. You want to make sure you have a power source compatible with your intended use. If you will use it for long periods at a time you might want one that allows you to swap batteries. Recharging batteries on-board will mean the unit is out of service until the battery is recharged.

4. Tube life span. A tube's life span is measured in projected hours of use. It would be important to balance the expected life span of the tube in the device you are buying against the cost.


How to choose thermal night vision scopes


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.4282298088074 604 0.5230 0


No Amazon API Requests Made.


App Debug - Total Time 1.4282298088074 seconds

Number Time From Start Name Description
1 0.50641393661499 Initialise Initialise FSB Function
2 0.51750183105469 App Controller Start Start of the App controller (called before the controller of every page)
3 0.529620885849 Start of getCategoryListByGroup Function Before first category groups query
4 0.52981185913086 After initial query Before first category groups query
5 0.52981400489807 Get Category List for Group Before the call to getCategoryList function
6 0.52981996536255 Start of GetCategoryList function Start of the function
7 0.52982497215271 Before getting categories Query to get specific category list
8 0.53048896789551 After getting categories Query to get specific category list
9 0.53048992156982 Before getting category custom Before call to function getCategoryCustom
10 0.53251481056213 After getting category custom After call to function getCategoryCustom
11 0.53251791000366 Before getting category custom Before call to function getCategoryCustom
12 0.54321503639221 After getting category custom After call to function getCategoryCustom
13 0.54321789741516 Before getting category custom Before call to function getCategoryCustom
14 0.54888081550598 After getting category custom After call to function getCategoryCustom
15 0.54888391494751 Before getting category custom Before call to function getCategoryCustom
16 0.55313491821289 After getting category custom After call to function getCategoryCustom
17 0.55313801765442 End of GetCategoryList function End of the function
18 0.55314803123474 Get Category List for Group Before the call to getCategoryList function
19 0.55314993858337 Start of GetCategoryList function Start of the function
20 0.5531530380249 Before getting categories Query to get specific category list
21 0.55360293388367 After getting categories Query to get specific category list
22 0.5536048412323 Before getting category custom Before call to function getCategoryCustom
23 0.55930089950562 After getting category custom After call to function getCategoryCustom
24 0.55930399894714 Before getting category custom Before call to function getCategoryCustom
25 0.56999182701111 After getting category custom After call to function getCategoryCustom
26 0.56999397277832 End of GetCategoryList function End of the function
27 0.57000184059143 Get Category List for Group Before the call to getCategoryList function
28 0.57000398635864 Start of GetCategoryList function Start of the function
29 0.57000803947449 Before getting categories Query to get specific category list
30 0.57088994979858 After getting categories Query to get specific category list
31 0.57089185714722 Before getting category custom Before call to function getCategoryCustom
32 0.58024001121521 After getting category custom After call to function getCategoryCustom
33 0.58024287223816 Before getting category custom Before call to function getCategoryCustom
34 0.59761691093445 After getting category custom After call to function getCategoryCustom
35 0.59762001037598 Before getting category custom Before call to function getCategoryCustom
36 0.60363602638245 After getting category custom After call to function getCategoryCustom
37 0.6036388874054 Before getting category custom Before call to function getCategoryCustom
38 0.60968685150146 After getting category custom After call to function getCategoryCustom
39 0.60968995094299 Before getting category custom Before call to function getCategoryCustom
40 0.61605381965637 After getting category custom After call to function getCategoryCustom
41 0.6160569190979 Before getting category custom Before call to function getCategoryCustom
42 0.63798594474792 After getting category custom After call to function getCategoryCustom
43 0.63798999786377 Before getting category custom Before call to function getCategoryCustom
44 0.64217495918274 After getting category custom After call to function getCategoryCustom
45 0.64217782020569 Before getting category custom Before call to function getCategoryCustom
46 0.64693188667297 After getting category custom After call to function getCategoryCustom
47 0.6469349861145 End of GetCategoryList function End of the function
48 0.64695000648499 Get Category List for Group Before the call to getCategoryList function
49 0.64695286750793 Start of GetCategoryList function Start of the function
50 0.64695596694946 Before getting categories Query to get specific category list
51 0.64738798141479 After getting categories Query to get specific category list
52 0.64738988876343 Before getting category custom Before call to function getCategoryCustom
53 0.64980387687683 After getting category custom After call to function getCategoryCustom
54 0.64980697631836 Before getting category custom Before call to function getCategoryCustom
55 0.65222096443176 After getting category custom After call to function getCategoryCustom
56 0.6522228717804 End of GetCategoryList function End of the function
57 0.65223097801208 Get Category List for Group Before the call to getCategoryList function
58 0.65223288536072 Start of GetCategoryList function Start of the function
59 0.65223598480225 Before getting categories Query to get specific category list
60 0.65256786346436 After getting categories Query to get specific category list
61 0.65256881713867 Before getting category custom Before call to function getCategoryCustom
62 0.65760803222656 After getting category custom After call to function getCategoryCustom
63 0.65761089324951 End of GetCategoryList function End of the function
64 0.65761685371399 End of getCategoryListByGroup Function Before return()
65 0.71408700942993 App Controller End End of the App controller (called before the controller of every page)
66 0.71574282646179 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.71587085723877 Before Get Options Before the call to getOptions in the tpl class
68 1.0622699260712 After Get Options After the call to getOptions in the tpl class
69 1.0623190402985 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.4282109737396 Finalizing debug Before the debug is output to the page.
71 1.4282288551331 End of App This is the end of the app logging, final timestamp


Query Debug - 604 Database Queries. Total time 0.5230 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.0001828670501709
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00049996376037598
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00019598007202148
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.0001978874206543
SELECT * FROM `bad_bots`
5 0.0004 0.00044608116149902
SELECT parameter, value FROM parameters
6 0.0001 0.00014591217041016
SET time_zone = 'Europe/London'
7 0.0003 0.0002899169921875
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00015807151794434
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00012397766113281
delete from cachefiles
10 0.0003 0.00025296211242676
SELECT id FROM pages WHERE pagename = 'how-nv-optics-work-and-what-to-look-for-before-you-buy' LIMIT 1
11 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = 397
12 0.0009 0.00088310241699219
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0097 0.0096700191497803
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00028014183044434
SELECT * FROM pages WHERE pagename = 'how-nv-optics-work-and-what-to-look-for-before-you-buy'
15 0.0002 0.00017309188842773
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00055909156799316
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00051498413085938
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.00024700164794922
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.0004730224609375
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.00015997886657715
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.00016212463378906
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.00018620491027832
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0030159950256348
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.00028204917907715
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0056860446929932
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.00017690658569336
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.00017595291137695
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.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0023019313812256
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.0002739429473877
SELECT id FROM categories WHERE parent_id = '80'
37 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 
38 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 (80)
				  AND p.disabled = 0 
39 0.0002 0.00017905235290527
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.0001838207244873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0011730194091797
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.00026106834411621
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00022101402282715
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0018191337585449
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.00015902519226074
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0002 0.00016999244689941
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.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00042009353637695
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.002345085144043
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0003 0.00026607513427734
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0023190975189209
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
54 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
55 0.0002 0.00016188621520996
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.0001828670501709
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0048019886016846
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.00027704238891602
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0048229694366455
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.00016498565673828
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.00016212463378906
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.00018882751464844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00071501731872559
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0042 0.0041720867156982
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.00027585029602051
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0041091442108154
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.00017809867858887
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00013613700866699
SELECT * FROM categorygroups WHERE id = '10'
73 0.0081 0.0081241130828857
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.00029110908508301
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.008152961730957
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.00017189979553223
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.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0024831295013428
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.00027203559875488
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0025169849395752
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.00015711784362793
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0002 0.00015783309936523
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
87 0.0025 0.0024850368499756
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.00027203559875488
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0025160312652588
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.00015807151794434
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.00016093254089355
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.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
94 0.0023 0.0022661685943604
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.00026607513427734
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00021481513977051
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0028359889984131
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.00016498565673828
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.00016212463378906
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.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '10'
102 0.0095 0.0094640254974365
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.00030708312988281
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00022506713867188
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00020885467529297
SELECT id FROM categories WHERE parent_id = '130'
109 0.0102 0.01018500328064
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.00018405914306641
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.00016880035400391
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.00020217895507812
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00013613700866699
SELECT * FROM categorygroups WHERE id = '10'
114 0.0016 0.0015640258789062
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.00027585029602051
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0016000270843506
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0002 0.00015115737915039
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0002 0.00016617774963379
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.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
121 0.0019 0.0018610954284668
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 89
122 0.0003 0.00026178359985352
SELECT id FROM categories WHERE parent_id = '89'
123 0.0019 0.0018730163574219
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0002 0.00015401840209961
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.0002 0.00015807151794434
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.00019192695617676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00040006637573242
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.000701904296875
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.00024318695068359
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00072193145751953
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.00014805793762207
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.0002 0.00015807151794434
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.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00014185905456543
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00069808959960938
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.0003 0.00025510787963867
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.0007328987121582
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.00014591217041016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0002 0.00016689300537109
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.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00031399726867676
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0020110607147217
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.0003 0.00026106834411621
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020248889923096
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.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 
148 0.0002 0.00015807151794434
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.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00013518333435059
SELECT * FROM categorygroups WHERE id = '20'
151 0.0054 0.0053510665893555
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.0003819465637207
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.0001678466796875
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00016617774963379
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '84'
158 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00022387504577637
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00021815299987793
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '379'
168 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '450'
170 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00016999244689941
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00022292137145996
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '133'
185 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '217'
187 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '271'
190 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '286'
191 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '364'
198 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00018191337585449
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00032401084899902
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00022602081298828
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '90'
206 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '150'
211 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00018715858459473
SELECT * FROM pages WHERE id = '162'
213 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '164'
214 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '180'
216 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '268'
219 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '290'
221 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '413'
222 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '327'
224 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00016522407531738
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '386'
233 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '428'
240 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '432'
241 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '437'
244 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00016307830810547
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '137'
249 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '407'
252 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00023412704467773
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00018095970153809
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '42'
264 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '86'
266 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00023889541625977
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00022721290588379
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '62'
274 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '393'
290 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '394'
291 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '421'
294 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '430'
296 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '451'
302 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '453'
303 0.0002 0.00016093254089355
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00024294853210449
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '417'
310 0.0002 0.00015401840209961
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '181'
313 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '383'
317 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '442'
320 0.0002 0.00015616416931152
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.00026106834411621
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '248'
327 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00016903877258301
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00024294853210449
SELECT * FROM pages WHERE id = '115'
334 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '151'
337 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '200'
339 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '304'
340 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '446'
350 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '456'
354 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '462'
357 0.0002 0.0001678466796875
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00018119812011719
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.0002129077911377
SELECT * FROM pages WHERE id = '182'
360 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '238'
361 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '240'
362 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '267'
367 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00014781951904297
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00012898445129395
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00013089179992676
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0015 0.0014820098876953
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0003 0.00029301643371582
SELECT * FROM pages WHERE pagename = 'how-nv-optics-work-and-what-to-look-for-before-you-buy'
373 0.0002 0.00020599365234375
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
374 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = 2
375 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = 4
376 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = 12
377 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = 10
378 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = 7
379 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = 18
380 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = 28
381 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = 13
382 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = 3
383 0.0323 0.032324075698853
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
384 0.0002 0.0002281665802002
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:1561610368;s:8:\"products\";a:6:{i:3;s:6:\"290575\";i:5;s:6:\"170197\";i:8;s:6:\"408792\";i:9;s:6:\"402983\";i:13;s:6:\"414188\";i:14;s:6:\"247027\";}}' WHERE id = '175'
385 0.0005 0.00050997734069824
SELECT * FROM products WHERE id IN (290575,170197,408792,402983,414188,247027) ORDER BY FIELD(id, 290575,170197,408792,402983,414188,247027 )
386 0.0006 0.00060510635375977
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
387 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '290575'
388 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '290575'
389 0.0034 0.0034370422363281
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.00020098686218262
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
391 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
392 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
393 0.0001 0.00013899803161621
UPDATE products SET price = '549500' WHERE id = '290575'
394 0.0007 0.0006709098815918
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
395 0.0002 0.00023603439331055
SELECT * FROM product_image_select WHERE product_id = '170197'
396 0.0001 0.00013279914855957
SELECT * FROM productcustomimages WHERE product_id = '170197'
397 0.0033 0.0032639503479004
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
398 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
399 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
400 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
401 0.0001 0.0001370906829834
UPDATE products SET price = '324500' WHERE id = '170197'
402 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
403 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '408792'
404 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '408792'
405 0.0036 0.0036089420318604
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
406 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
407 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
409 0.0001 0.00013494491577148
UPDATE products SET price = '13499' WHERE id = '408792'
410 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
411 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '402983'
412 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '402983'
413 0.0022 0.002223014831543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
414 0.0002 0.00019216537475586
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
415 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
417 0.0001 0.00013303756713867
UPDATE products SET price = '10392' WHERE id = '402983'
418 0.0003 0.00027990341186523
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
419 0.0002 0.00023412704467773
SELECT * FROM product_image_select WHERE product_id = '414188'
420 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '414188'
421 0.0026 0.0026059150695801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
422 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
423 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
424 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
425 0.0001 0.00013017654418945
UPDATE products SET price = '9999' WHERE id = '414188'
426 0.0002 0.00021791458129883
SELECT * FROM productimages WHERE product_id = '247027' ORDER BY sortorder ASC
427 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '247027'
428 0.0001 0.00013184547424316
SELECT * FROM productcustomimages WHERE product_id = '247027'
429 0.0021 0.0020511150360107
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '247027' AND a.name = n.originalname
430 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '247027' AND merchantid = 'ATVPDKIKX0DER'
431 0.0002 0.00022077560424805
SELECT * FROM productoffers
                WHERE product_id = '247027' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '247027' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
433 0.0001 0.00013184547424316
UPDATE products SET price = '1492' WHERE id = '247027'
434 0.0316 0.031550884246826
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.00021696090698242
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:1561610368;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:4;s:6:\"171938\";i:10;s:6:\"370121\";i:15;s:6:\"406758\";i:17;s:6:\"407620\";i:18;s:6:\"408078\";}}' WHERE id = '177'
436 0.0005 0.00054693222045898
SELECT * FROM products WHERE id IN (407595,171938,370121,406758,407620,408078) ORDER BY FIELD(id, 407595,171938,370121,406758,407620,408078 )
437 0.0004 0.00035691261291504
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
438 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '407595'
439 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '407595'
440 0.0034 0.0033688545227051
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.00018215179443359
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.00043797492980957
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
444 0.0001 0.00012493133544922
UPDATE products SET price = '2497' WHERE id = '407595'
445 0.0006 0.00062680244445801
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
446 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '171938'
447 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '171938'
448 0.0026 0.0025730133056641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
449 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
450 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
451 0.0004 0.00039887428283691
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
452 0.0001 0.00011801719665527
UPDATE products SET price = '388900' WHERE id = '171938'
453 0.0002 0.00018405914306641
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
454 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '370121'
455 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '370121'
456 0.0028 0.0027799606323242
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.00017809867858887
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
458 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
459 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
460 0.0001 0.00011706352233887
UPDATE products SET price = '11679' WHERE id = '370121'
461 0.0002 0.00018405914306641
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
462 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '406758'
463 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '406758'
464 0.0026 0.0026102066040039
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
465 0.0002 0.00018620491027832
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
466 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
467 0.0004 0.0003821849822998
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
468 0.0001 0.00011491775512695
UPDATE products SET price = '2694' WHERE id = '406758'
469 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
470 0.0002 0.0001981258392334
SELECT * FROM product_image_select WHERE product_id = '407620'
471 0.0001 0.00011682510375977
SELECT * FROM productcustomimages WHERE product_id = '407620'
472 0.0023 0.0022830963134766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
473 0.0002 0.00019383430480957
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
474 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
475 0.0004 0.00036883354187012
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
476 0.0001 0.00011587142944336
UPDATE products SET price = '20323' WHERE id = '407620'
477 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
478 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '408078'
479 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '408078'
480 0.0024 0.0024178028106689
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
481 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
482 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
483 0.0003 0.00032997131347656
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
484 0.0001 0.00011801719665527
UPDATE products SET price = '24109' WHERE id = '408078'
485 0.0823 0.082257986068726
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 24
486 0.0002 0.00024604797363281
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:1561610368;s:8:\"products\";a:6:{i:3;s:6:\"290575\";i:9;s:6:\"402983\";i:10;s:6:\"370121\";i:12;s:6:\"414825\";i:16;s:6:\"130885\";i:17;s:6:\"407620\";}}' WHERE id = '181'
487 0.0005 0.00045204162597656
SELECT * FROM products WHERE id IN (290575,402983,370121,414825,130885,407620) ORDER BY FIELD(id, 290575,402983,370121,414825,130885,407620 )
488 0.0006 0.0005800724029541
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
489 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '290575'
490 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '290575'
491 0.0034 0.0034408569335938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
492 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
493 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
494 0.0004 0.00043582916259766
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
495 0.0001 0.00011897087097168
UPDATE products SET price = '549500' WHERE id = '290575'
496 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
497 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '402983'
498 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '402983'
499 0.0023 0.0022737979888916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
500 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
501 0.0002 0.00020813941955566
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
502 0.0004 0.00035190582275391
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
503 0.0001 0.00012016296386719
UPDATE products SET price = '10392' WHERE id = '402983'
504 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
505 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '370121'
506 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '370121'
507 0.0028 0.0027999877929688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
508 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
509 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
510 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
511 0.0001 0.00013494491577148
UPDATE products SET price = '11679' WHERE id = '370121'
512 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
513 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '414825'
514 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '414825'
515 0.0021 0.0020768642425537
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
516 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
517 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
518 0.0004 0.00035810470581055
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
519 0.0001 0.00011706352233887
UPDATE products SET price = '11999' WHERE id = '414825'
520 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
521 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '130885'
522 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '130885'
523 0.0020 0.0020229816436768
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
524 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0004 0.00036811828613281
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
527 0.0001 0.00012111663818359
UPDATE products SET price = '1521' WHERE id = '130885'
528 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
529 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '407620'
530 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '407620'
531 0.0023 0.0022919178009033
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
532 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
533 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
534 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
535 0.0001 0.00011777877807617
UPDATE products SET price = '20323' WHERE id = '407620'
536 0.0820 0.081951856613159
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.0002 0.00024080276489258
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:1561610369;s:8:\"products\";a:6:{i:6;s:6:\"185812\";i:10;s:6:\"370121\";i:15;s:6:\"406758\";i:18;s:6:\"408078\";i:4;s:6:\"171938\";i:5;s:6:\"170197\";}}' WHERE id = '183'
538 0.0005 0.00045490264892578
SELECT * FROM products WHERE id IN (185812,370121,406758,408078,171938,170197) ORDER BY FIELD(id, 185812,370121,406758,408078,171938,170197 )
539 0.0007 0.00066709518432617
SELECT * FROM productimages WHERE product_id = '185812' ORDER BY sortorder ASC
540 0.0002 0.00022077560424805
SELECT * FROM product_image_select WHERE product_id = '185812'
541 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '185812'
542 0.0021 0.0020949840545654
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '185812' AND a.name = n.originalname
543 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '185812' AND merchantid = 'ATVPDKIKX0DER'
544 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '185812' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '185812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.0001 0.00012302398681641
UPDATE products SET price = '314900' WHERE id = '185812'
547 0.0002 0.00018191337585449
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
548 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '370121'
549 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '370121'
550 0.0028 0.0027658939361572
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
551 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00012016296386719
UPDATE products SET price = '11679' WHERE id = '370121'
555 0.0002 0.00018215179443359
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
556 0.0002 0.0001978874206543
SELECT * FROM product_image_select WHERE product_id = '406758'
557 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '406758'
558 0.0027 0.0026659965515137
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
559 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00011801719665527
UPDATE products SET price = '2694' WHERE id = '406758'
563 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
564 0.0002 0.0001981258392334
SELECT * FROM product_image_select WHERE product_id = '408078'
565 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '408078'
566 0.0025 0.0024731159210205
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
567 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0003 0.00034213066101074
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00011706352233887
UPDATE products SET price = '24109' WHERE id = '408078'
571 0.0006 0.00060582160949707
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
572 0.0002 0.0002288818359375
SELECT * FROM product_image_select WHERE product_id = '171938'
573 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '171938'
574 0.0025 0.0025110244750977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
575 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00019097328186035
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00012803077697754
UPDATE products SET price = '388900' WHERE id = '171938'
579 0.0006 0.00063800811767578
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
580 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '170197'
581 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '170197'
582 0.0032 0.0031881332397461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
583 0.0002 0.00017595291137695
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00019192695617676
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00012111663818359
UPDATE products SET price = '324500' WHERE id = '170197'
587 0.0004 0.00040698051452637
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
588 0.0001 0.00012803077697754
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
589 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
590 0.0001 0.00011610984802246
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
591 0.0004 0.00039792060852051
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
592 0.0001 0.0001218318939209
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
593 0.0001 0.00011515617370605
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
594 0.0009 0.00094103813171387
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
595 0.0003 0.00031113624572754
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
596 0.0003 0.0002748966217041
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
597 0.0004 0.00035214424133301
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
598 0.0001 0.00012898445129395
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0001 0.00011706352233887
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0001 0.00011515617370605
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
601 0.0001 0.00011610984802246
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.00011301040649414
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0005 0.00047516822814941
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
604 0.0003 0.00034189224243164
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'