Tactical Equipment - Survivalist Equipment
   

Multicolor LED Flashlights Comparison

Multi colored LED flashlight review comparison

UPDATED :  

Our eyes' pupil, dialate, or widen in the dark to allow more light to enter, allowing us to see better. That's what some people call our natural night vision. It takes a few moments for our eyes to adjust to darkness or brightness, so drastic changes in light levels can leave us seeing bright spots or nothing at all until our pupils can adjust. This is where multicolor flashlights can help us out.

MAKE & MODELNightcore EC11First Light USA T-Max ProLED Lenser P7QC
MAX. LUMEN OUTPUT 430 700 220
MAX RUNTIME 20 hrs. (lowest mode) 60 hrs. (low mode) 25 hrs. (low mode)
OVERALL LENGTH 2.95 in 3.4 in 5.23 in
WEIGHT WITH BATTERIES 2.2 oz 5.9 oz 6.1 oz.
BATTERY TYPE CR123A, rechargeable Li-ion IMR 18350, or rechargeable Li-ion RCR123 CR123A (two, included) AAA (four, included)
CONTROLS Constant on, mode slide switches Constant on and momentary push-button switch, mode switch Constant on/momentary tail-cap push-button switch, mode bezel switch
MSRP Starting at $60 $280 $80

The most common colored lights are red. blue, and green. Each of these is "softer" and don't affect our night vision as severely as white light. They are also less likely to be seen at distance, which is an advantage for those who wish to keep a low profile.

Because red light appears less bright to the human eye and also provides more contrast, it is most commonly used as a general-use light at night.

However, red light can make map reading a bit more challenging, since many lines and markers are printed in red. For this reason, blue light is preferred for map reading. Blue light is also better at spotting bodily fluids like blood, which makes it a common choice for not only police Investigators and search-and-rescue teams, but hunters as welL It's also known to be useful for cutting through fog.

MAKE & MODELNightstick Dual-Switch Dual-LightStreamlight Night Com LEDCoast TX100Coleman CPX 4.5 Multi-Color LED Flashlight
MAX. LUMEN OUTPUT 60 105 125 High 155
MAX RUNTIME 3 hrs. 3.5 hrs. 13 hrs. 2 hrs.
OVERALL LENGTH 5.3 in 5.43 in 5.9 in 6.42 in
WEIGHT WITH BATTERIES 2.4 oz 5.4 oz 4.8 oz. 8.1 oz
BATTERY TYPE AAA (two, included) CR123A (two, included) AA (two, included) AA (three included), Li-ion battery pack (optional)
CONTROLS Dual constant-on push-button switches Constant on/momentary tail-cap push button switch, rotary mode switch Constant on/momentary tail-cap push button switch Constant-on bezel ring switch
MSRP $10 $74 $54 $23

Like red and blue, green light can help preserve natural night visioa Unlike white light, it doesn't attract insects and doesn't spook fish or game - remember that the next time you go camping, angling, or hunting.

Multicolor flashlights allow us to stay effective long after the sun has set. So, we've gathered some of the premier models on the market. Read on to see which one lights up your nightlife.


Nitecore EC11 LED Flashlight

Nitecore EC11 LED flashlight review

This puppy measures less than 3 Inches long, but packs a whole lot of lumen power In its turbo mode, it generates 430 lumens when powered by a single CR123 battery.

When an optional rechargeable battery is inserted, the lumen count surges to 900 lumens! The ECU has two buttons located on its side close to its bezel.

One button turns it on and off while the other cycles through its many light functions. Including a low-powered red light and a strobe feature.

We offer this model in multiple bundles, from one that Includes a single-bay battery charger with LCO display ($77 total) to another that has a souped-up charger and car adapter plug ($97 total).

Pros : Durable, compact size, powerful light, multiple power-source options.

Cons : Too many button features can be contusing, might be too small for big hands.


First Light USA T-MAX Pro LED Flashlight

First Light T-Max Pro LED flashlight review

Designed to help free up your hands for other tasks, the T-MAX Pro allows the user to access its three switches with the use of just one thumb.

It comes with a finger loop that keeps the light in place. There is a momentary-on switch that gives you quick access to 700 lumens of searing bright light.

Two smaller switches allow you to turn on and cycle through its colored light options (white, red, blue, green) in varying brightness levels.

The T-MAX Pro also includes optionstor a complete power lock out, strobe, and multicolor safety beacon modes.

Pros : Extremely bright, tied with the LED Lenser for offering the most colored lights (four).

Cons : Can feel awkward to hold, overly complicated operation, the $280 price tag (ouch!).


LED Lenser P7QC LED Flashlight

LED Lenser P7QC LED flashlight review

The P7QC is an updated version of LED Lenser's popular P7 model and its first tour-color handheld flashlight, it provides 220 lumens of brilliant light with a press ot its tail-cap push-button switch or can be toned down to 40 lumens by just another dick. Yet another click turns on Its strobe function.

All three light modes are available in each of its colors: white, red, blue, and green. The bezel can be twisted to change the light colors.

Pros : Four bright lights, very bright, common battery type.

Cons : Challenging to operate all it's functions with only one hand.

Promo

NEW from LED Lenser comes the P7QC Quattro Colour, a unique torch that offers four different colour options (red, green, blue, and white) that provide great versatility. Use red light to help preserve your night vision, green light to reduce disturbance to animals and blue to identify fluids like blood more easily.

The white light option delivers an impressive 220 lumens of light, and all colours have three different light functions (high power, low power and blink). You can select the colour you want simply by turning the torch head, and you can change colours when the light is on. The P7QC Quattro Colour is covered by LED Lenser’s 5-year warranty.


Nightstick Dual-Switch Dual-Light LED Flashlight

Nightstick dual-switch dual-light LED flashlight review

The Dual-Switch Dual-Light flashlight has two switches located on its polymer body that offer the user a choice of powering its white light flashlight, red light floodlight or both at the same time, Its compact oval housing is water resistant and features a soft touch finish.

The flashlight's white light is emitted from its end, while the floodlight's red light shines through a window on the side of the body, allowing multiple lighting techniques depending on your situation. It's lightweight and includes a pocket dip.

Pros : Two lights can be operated independent of one another, quite affordable.

Cons : No momentary-on switch capability.


Streamlight Night Com LED Flashlight

Streamlight Night Com LED flashlight review

The Night Com LED Is equipped with a single white light C4 LEO that produces 105 lumens of light.

It also has dual red LEDs that can run for up to 28 hours, shining 2.5 lumens of light as well as a provision that allows it to power a dimly lit single red LED that helps protect your natural night vision.

Its power is operated via a tail-cap button while its light modes are controlled by a rotary switch found on its side near the bezel end.

Pros : Easy to use controls, durable build.

Cons : A little complicated to use one-handed.


Coast TX100 LED Flashlight

Coast TX100 LED flashlight review

Housed In an impact - and weather-resistant aluminum body, the TX100 contains three virtually unbreakable LEDs that light up in red, white, or blue.

Coast says this is its longest-reaching colored light option and liststhe TX100 to be able to throw out to more than 300 yards.

The red light helps preserve night vision while the blue light can cut through fog without creating too much glare.

To switch colors, the user must push the tail-cap and cycle through each colored light.

Pros : Robust build, common battery type, brightness.

Cons : Switching colors requires the light to be cycled through.


Coleman CPX 4.5 Multi-Color LED Flashlight

Coleman CPX 4.5 multi color LED flashlight

The CPX 4.5 Multi-Color LED's white light Israted at 155 lumens with a 390-foot range. The light Is activated and can be color changed by the twist of Its ring switch.

Its red light mode engages five lower-powered LEDs and its aluminum casing isimpact- and water-resistant.

This flashlight can be powered by three common AAA batteries or by an optional rechargeable battery pack.

Pros : Multiple power options, easy to switch from white to red light, affordable.

Cons : Difficult to operate one handed.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.2225649356842 605 0.5926 0


No Amazon API Requests Made.


App Debug - Total Time 1.2225649356842 seconds

Number Time From Start Name Description
1 0.38198113441467 Initialise Initialise FSB Function
2 0.39065408706665 App Controller Start Start of the App controller (called before the controller of every page)
3 0.40254807472229 Start of getCategoryListByGroup Function Before first category groups query
4 0.40274405479431 After initial query Before first category groups query
5 0.40274500846863 Get Category List for Group Before the call to getCategoryList function
6 0.40274906158447 Start of GetCategoryList function Start of the function
7 0.40275597572327 Before getting categories Query to get specific category list
8 0.40338110923767 After getting categories Query to get specific category list
9 0.4033830165863 Before getting category custom Before call to function getCategoryCustom
10 0.40540814399719 After getting category custom After call to function getCategoryCustom
11 0.40541100502014 Before getting category custom Before call to function getCategoryCustom
12 0.41609811782837 After getting category custom After call to function getCategoryCustom
13 0.41610097885132 Before getting category custom Before call to function getCategoryCustom
14 0.42174911499023 After getting category custom After call to function getCategoryCustom
15 0.42175197601318 Before getting category custom Before call to function getCategoryCustom
16 0.42596507072449 After getting category custom After call to function getCategoryCustom
17 0.42596697807312 End of GetCategoryList function End of the function
18 0.42597699165344 Get Category List for Group Before the call to getCategoryList function
19 0.42597913742065 Start of GetCategoryList function Start of the function
20 0.4259819984436 Before getting categories Query to get specific category list
21 0.42644000053406 After getting categories Query to get specific category list
22 0.42644214630127 Before getting category custom Before call to function getCategoryCustom
23 0.43208813667297 After getting category custom After call to function getCategoryCustom
24 0.43209099769592 Before getting category custom Before call to function getCategoryCustom
25 0.44283199310303 After getting category custom After call to function getCategoryCustom
26 0.44283413887024 End of GetCategoryList function End of the function
27 0.44284105300903 Get Category List for Group Before the call to getCategoryList function
28 0.44284415245056 Start of GetCategoryList function Start of the function
29 0.44284701347351 Before getting categories Query to get specific category list
30 0.44362592697144 After getting categories Query to get specific category list
31 0.44362711906433 Before getting category custom Before call to function getCategoryCustom
32 0.45288014411926 After getting category custom After call to function getCategoryCustom
33 0.45288300514221 Before getting category custom Before call to function getCategoryCustom
34 0.47028398513794 After getting category custom After call to function getCategoryCustom
35 0.47028708457947 Before getting category custom Before call to function getCategoryCustom
36 0.47627997398376 After getting category custom After call to function getCategoryCustom
37 0.47628307342529 Before getting category custom Before call to function getCategoryCustom
38 0.48227596282959 After getting category custom After call to function getCategoryCustom
39 0.48227906227112 Before getting category custom Before call to function getCategoryCustom
40 0.48854899406433 After getting category custom After call to function getCategoryCustom
41 0.48855209350586 Before getting category custom Before call to function getCategoryCustom
42 0.51045393943787 After getting category custom After call to function getCategoryCustom
43 0.51045703887939 Before getting category custom Before call to function getCategoryCustom
44 0.51460599899292 After getting category custom After call to function getCategoryCustom
45 0.51460909843445 Before getting category custom Before call to function getCategoryCustom
46 0.51927709579468 After getting category custom After call to function getCategoryCustom
47 0.51927995681763 End of GetCategoryList function End of the function
48 0.51929402351379 Get Category List for Group Before the call to getCategoryList function
49 0.51929593086243 Start of GetCategoryList function Start of the function
50 0.51930093765259 Before getting categories Query to get specific category list
51 0.51975107192993 After getting categories Query to get specific category list
52 0.51975297927856 Before getting category custom Before call to function getCategoryCustom
53 0.52214908599854 After getting category custom After call to function getCategoryCustom
54 0.52215194702148 Before getting category custom Before call to function getCategoryCustom
55 0.52454113960266 After getting category custom After call to function getCategoryCustom
56 0.52454304695129 End of GetCategoryList function End of the function
57 0.52454996109009 Get Category List for Group Before the call to getCategoryList function
58 0.5245521068573 Start of GetCategoryList function Start of the function
59 0.52455496788025 Before getting categories Query to get specific category list
60 0.52489900588989 After getting categories Query to get specific category list
61 0.52489995956421 Before getting category custom Before call to function getCategoryCustom
62 0.52995800971985 After getting category custom After call to function getCategoryCustom
63 0.52996110916138 End of GetCategoryList function End of the function
64 0.52996706962585 End of getCategoryListByGroup Function Before return()
65 0.58634114265442 App Controller End End of the App controller (called before the controller of every page)
66 0.58813405036926 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.58828210830688 Before Get Options Before the call to getOptions in the tpl class
68 1.0040400028229 After Get Options After the call to getOptions in the tpl class
69 1.0041191577911 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.2225470542908 Finalizing debug Before the debug is output to the page.
71 1.2225630283356 End of App This is the end of the app logging, final timestamp


Query Debug - 605 Database Queries. Total time 0.5926 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00018191337585449
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00046396255493164
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00018095970153809
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00015592575073242
SELECT * FROM `bad_bots`
5 0.0005 0.00045585632324219
SELECT parameter, value FROM parameters
6 0.0001 0.00014996528625488
SET time_zone = 'Europe/London'
7 0.0003 0.00030279159545898
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00019598007202148
UPDATE autorun SET lastrun = '2019-06-18 17:33:11' WHERE id = '13'
9 0.0002 0.00016593933105469
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0001 0.00010395050048828
delete from cachefiles
11 0.0003 0.00025105476379395
SELECT id FROM pages WHERE pagename = 'multicolor-led-flashlights' LIMIT 1
12 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = 248
13 0.0012 0.0012099742889404
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
14 0.0096 0.009566068649292
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
15 0.0003 0.00027990341186523
SELECT * FROM pages WHERE pagename = 'multicolor-led-flashlights'
16 0.0002 0.00017595291137695
SELECT * FROM categorygroups ORDER BY sortorder ASC
17 0.0006 0.00057888031005859
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
18 0.0005 0.00050497055053711
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.0002 0.00024795532226562
SELECT id FROM categories WHERE parent_id = '49'
20 0.0005 0.00046086311340332
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.00016498565673828
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.00016689300537109
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
23 0.0002 0.00018692016601562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
24 0.0001 0.00014019012451172
SELECT * FROM categorygroups WHERE id = '1'
25 0.0030 0.0030059814453125
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.00027799606323242
SELECT id FROM categories WHERE parent_id = '50'
27 0.0002 0.00022101402282715
SELECT id FROM categories WHERE parent_id = '96'
28 0.0002 0.0002140998840332
SELECT id FROM categories WHERE parent_id = '97'
29 0.0002 0.0002131462097168
SELECT id FROM categories WHERE parent_id = '111'
30 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '129'
31 0.0057 0.0056819915771484
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.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 
33 0.0002 0.00017881393432617
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.0001380443572998
SELECT * FROM categorygroups WHERE id = '1'
36 0.0023 0.0022950172424316
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.00026607513427734
SELECT id FROM categories WHERE parent_id = '80'
38 0.0023 0.0023338794708252
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.00015711784362793
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.00015997886657715
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
42 0.0001 0.00014400482177734
SELECT * FROM categorygroups WHERE id = '1'
43 0.0012 0.0011589527130127
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.0002591609954834
SELECT id FROM categories WHERE parent_id = '51'
45 0.0002 0.00021910667419434
SELECT id FROM categories WHERE parent_id = '101'
46 0.0018 0.0017919540405273
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.00016403198242188
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.00019288063049316
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.0004279613494873
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
52 0.0023 0.0022890567779541
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.002310037612915
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.00015592575073242
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.00017499923706055
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.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
58 0.0001 0.0001378059387207
SELECT * FROM categorygroups WHERE id = '2'
59 0.0048 0.0048089027404785
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.00027608871459961
SELECT id FROM categories WHERE parent_id = '61'
61 0.0049 0.0048599243164062
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.00016593933105469
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.00016379356384277
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.00017976760864258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
65 0.0002 0.0001521110534668
SELECT * FROM categorygroups WHERE id = '2'
66 0.0007 0.00071287155151367
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
67 0.0041 0.0040922164916992
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.0041060447692871
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.00016307830810547
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.00016307830810547
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.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
73 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
74 0.0081 0.008120059967041
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.00028610229492188
SELECT id FROM categories WHERE parent_id = '65'
76 0.0082 0.0082039833068848
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.00017595291137695
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.00016403198242188
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.00018191337585449
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.0024631023406982
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.00026822090148926
SELECT id FROM categories WHERE parent_id = '81'
83 0.0025 0.0025081634521484
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.00016498565673828
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.00016188621520996
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
87 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
88 0.0024 0.0024499893188477
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.00027084350585938
SELECT id FROM categories WHERE parent_id = '31'
90 0.0025 0.0024960041046143
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.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
95 0.0022 0.0022101402282715
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.0002739429473877
SELECT id FROM categories WHERE parent_id = '66'
97 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '131'
98 0.0028 0.0027940273284912
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.00016403198242188
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.00016498565673828
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.0094008445739746
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.00029301643371582
SELECT id FROM categories WHERE parent_id = '34'
105 0.0002 0.00021886825561523
SELECT id FROM categories WHERE parent_id = '94'
106 0.0002 0.00022196769714355
SELECT id FROM categories WHERE parent_id = '98'
107 0.0002 0.0002138614654541
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.0002131462097168
SELECT id FROM categories WHERE parent_id = '130'
110 0.0102 0.010234117507935
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.00019192695617676
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.00017094612121582
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.00019216537475586
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
114 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
115 0.0016 0.0015549659729004
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.00026297569274902
SELECT id FROM categories WHERE parent_id = '32'
117 0.0016 0.0015909671783447
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.00015878677368164
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.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
122 0.0018 0.0018019676208496
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.0002601146697998
SELECT id FROM categories WHERE parent_id = '89'
124 0.0018 0.0018298625946045
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.00016593933105469
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.00016212463378906
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.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
128 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '10'
129 0.0004 0.00041604042053223
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
130 0.0007 0.00069093704223633
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.0003 0.00025081634521484
SELECT id FROM categories WHERE parent_id = '84'
132 0.0007 0.0007021427154541
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.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 (84)
				  AND p.disabled = 0 
134 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 (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
135 0.0002 0.00018095970153809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
136 0.0001 0.00013613700866699
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.00072693824768066
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.00014805793762207
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.00015711784362793
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
142 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
143 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '17'
144 0.0003 0.00032401084899902
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
145 0.0020 0.002007007598877
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.00025081634521484
SELECT id FROM categories WHERE parent_id = '92'
147 0.0021 0.0020511150360107
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.00015401840209961
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.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
151 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '20'
152 0.0053 0.005302906036377
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
153 0.0004 0.0003809928894043
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
154 0.0002 0.00017023086547852
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
155 0.0002 0.00017881393432617
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
156 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '67'
157 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '82'
158 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '84'
159 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '94'
160 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '116'
161 0.0002 0.00022697448730469
SELECT * FROM pages WHERE id = '52'
162 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '135'
163 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '245'
164 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '269'
165 0.0002 0.00022411346435547
SELECT * FROM pages WHERE id = '275'
166 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '280'
167 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '357'
168 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '379'
169 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '401'
170 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '450'
171 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '454'
172 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '457'
173 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '458'
174 0.0002 0.0001680850982666
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
175 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '41'
176 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '43'
177 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '44'
178 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '68'
179 0.0002 0.0002281665802002
SELECT * FROM pages WHERE id = '80'
180 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '85'
181 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '97'
182 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '107'
183 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '108'
184 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '128'
185 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '133'
186 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '148'
187 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '217'
188 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '228'
189 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '257'
190 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '271'
191 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '286'
192 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '287'
193 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '291'
194 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '380'
195 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '344'
196 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '354'
197 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '363'
198 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '364'
199 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '368'
200 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '369'
201 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '400'
202 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '463'
203 0.0002 0.00018215179443359
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
204 0.0003 0.00033307075500488
SELECT * FROM pages WHERE id = '66'
205 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '77'
206 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '90'
207 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '414'
208 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '119'
209 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '406'
210 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '149'
211 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '150'
212 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '412'
213 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '162'
214 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '164'
215 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '167'
216 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '180'
217 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '187'
218 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '265'
219 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '268'
220 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '411'
221 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '290'
222 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '413'
223 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '409'
224 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '327'
225 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '336'
226 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '351'
227 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '358'
228 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '360'
229 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '362'
230 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '366'
231 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '370'
232 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '377'
233 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '386'
234 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '408'
235 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '415'
236 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '416'
237 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '419'
238 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '423'
239 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '427'
240 0.0002 0.00020217895507812
SELECT * FROM pages WHERE id = '428'
241 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '432'
242 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '433'
243 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '436'
244 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '437'
245 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '461'
246 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '464'
247 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
248 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '74'
249 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '137'
250 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '145'
251 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '156'
252 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '407'
253 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '410'
254 0.0002 0.00020408630371094
SELECT * FROM pages WHERE id = '266'
255 0.0003 0.00025486946105957
SELECT * FROM pages WHERE id = '316'
256 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '332'
257 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '334'
258 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '367'
259 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '387'
260 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '389'
261 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '397'
262 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '449'
263 0.0002 0.00018191337585449
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
264 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '42'
265 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '79'
266 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '86'
267 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '95'
268 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '102'
269 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '109'
270 0.0003 0.00025796890258789
SELECT * FROM pages WHERE id = '114'
271 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '121'
272 0.0002 0.00023198127746582
SELECT * FROM pages WHERE id = '138'
273 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '142'
274 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '62'
275 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '157'
276 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '246'
277 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '276'
278 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '278'
279 0.0002 0.00024509429931641
SELECT * FROM pages WHERE id = '279'
280 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '317'
281 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '405'
282 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '343'
283 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '345'
284 0.0002 0.00022411346435547
SELECT * FROM pages WHERE id = '346'
285 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '347'
286 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '348'
287 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '349'
288 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '381'
289 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '392'
290 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '393'
291 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '394'
292 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '395'
293 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '399'
294 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '421'
295 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '426'
296 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '430'
297 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '431'
298 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '434'
299 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '435'
300 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '440'
301 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '441'
302 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '451'
303 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '453'
304 0.0002 0.00016903877258301
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
305 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '146'
306 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '158'
307 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '163'
308 0.0003 0.00027990341186523
SELECT * FROM pages WHERE id = '293'
309 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '340'
310 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '417'
311 0.0002 0.00015616416931152
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
312 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '173'
313 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '181'
314 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '288'
315 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '299'
316 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '300'
317 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '383'
318 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '385'
319 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '438'
320 0.0002 0.00016522407531738
SELECT * FROM pages WHERE id = '442'
321 0.0002 0.00015687942504883
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
322 0.0003 0.00026321411132812
SELECT * FROM pages WHERE id = '103'
323 0.0003 0.00025200843811035
SELECT * FROM pages WHERE id = '134'
324 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '139'
325 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '143'
326 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '234'
327 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '248'
328 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '260'
329 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '398'
330 0.0002 0.00017189979553223
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
331 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '61'
332 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '87'
333 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '104'
334 0.0002 0.00024294853210449
SELECT * FROM pages WHERE id = '115'
335 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '124'
336 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '144'
337 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '151'
338 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '199'
339 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '200'
340 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '304'
341 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '321'
342 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '333'
343 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '350'
344 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '378'
345 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '422'
346 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '425'
347 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '443'
348 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '444'
349 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '445'
350 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '446'
351 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '447'
352 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '448'
353 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '455'
354 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '456'
355 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '459'
356 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '460'
357 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '462'
358 0.0002 0.00015997886657715
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
359 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '153'
360 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '182'
361 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '238'
362 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '240'
363 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '242'
364 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '252'
365 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '253'
366 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '262'
367 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '267'
368 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '420'
369 0.0002 0.00015091896057129
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
370 0.0001 0.00013303756713867
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
371 0.0001 0.00013113021850586
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
372 0.0014 0.0014150142669678
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
373 0.0003 0.00030899047851562
SELECT * FROM pages WHERE pagename = 'multicolor-led-flashlights'
374 0.0002 0.0002140998840332
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
375 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = 2
376 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = 4
377 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = 12
378 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = 10
379 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = 7
380 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = 18
381 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = 28
382 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = 13
383 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = 3
384 0.0426 0.042649030685425
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.00024509429931641
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:1560879191;s:8:\"products\";a:6:{i:6;s:6:\"170197\";i:8;s:6:\"412927\";i:10;s:6:\"408792\";i:20;s:6:\"405644\";i:23;s:6:\"408079\";i:12;s:6:\"370121\";}}' WHERE id = '175'
386 0.0005 0.00048303604125977
SELECT * FROM products WHERE id IN (170197,412927,408792,405644,408079,370121) ORDER BY FIELD(id, 170197,412927,408792,405644,408079,370121 )
387 0.0007 0.00068187713623047
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
388 0.0002 0.00023603439331055
SELECT * FROM product_image_select WHERE product_id = '170197'
389 0.0001 0.00014090538024902
SELECT * FROM productcustomimages WHERE product_id = '170197'
390 0.0032 0.0031669139862061
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
391 0.0002 0.00021004676818848
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
392 0.0002 0.00022387504577637
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
393 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
394 0.0002 0.00015020370483398
UPDATE products SET price = '324500' WHERE id = '170197'
395 0.0003 0.00028181076049805
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
396 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '412927'
397 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '412927'
398 0.0036 0.0036067962646484
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
399 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
400 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
401 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
402 0.0001 0.00013089179992676
UPDATE products SET price = '199900' WHERE id = '412927'
403 0.0002 0.00021886825561523
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
404 0.0002 0.00023293495178223
SELECT * FROM product_image_select WHERE product_id = '408792'
405 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '408792'
406 0.0036 0.0035760402679443
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
407 0.0002 0.00021004676818848
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
408 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
409 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
410 0.0001 0.00012898445129395
UPDATE products SET price = '13499' WHERE id = '408792'
411 0.0002 0.00020980834960938
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
412 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '405644'
413 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '405644'
414 0.0034 0.0033740997314453
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
415 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
416 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
417 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
418 0.0001 0.00013899803161621
UPDATE products SET price = '63539' WHERE id = '405644'
419 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
420 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '408079'
421 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '408079'
422 0.0032 0.0032000541687012
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
423 0.0002 0.00020503997802734
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
424 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
425 0.0004 0.00039315223693848
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
426 0.0001 0.00013494491577148
UPDATE products SET price = '18547' WHERE id = '408079'
427 0.0002 0.00020480155944824
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
428 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '370121'
429 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '370121'
430 0.0027 0.0027430057525635
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
431 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
432 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
433 0.0004 0.0004119873046875
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
434 0.0001 0.00012898445129395
UPDATE products SET price = '9899' WHERE id = '370121'
435 0.0422 0.042203187942505
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.0003 0.00026202201843262
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:1560879191;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:6;s:6:\"170197\";i:13;s:6:\"403517\";i:14;s:6:\"414825\";i:18;s:6:\"147874\";i:20;s:6:\"405644\";}}' WHERE id = '177'
437 0.0005 0.00045990943908691
SELECT * FROM products WHERE id IN (398315,170197,403517,414825,147874,405644) ORDER BY FIELD(id, 398315,170197,403517,414825,147874,405644 )
438 0.0002 0.00023293495178223
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
439 0.0002 0.0002439022064209
SELECT * FROM product_image_select WHERE product_id = '398315'
440 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '398315'
441 0.0025 0.0024800300598145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
442 0.0002 0.00020289421081543
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
443 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
444 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
445 0.0001 0.00013494491577148
UPDATE products SET price = '1999' WHERE id = '398315'
446 0.0007 0.00067400932312012
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
447 0.0002 0.00024509429931641
SELECT * FROM product_image_select WHERE product_id = '170197'
448 0.0001 0.0001368522644043
SELECT * FROM productcustomimages WHERE product_id = '170197'
449 0.0031 0.0031411647796631
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
450 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
451 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
452 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
453 0.0001 0.00013089179992676
UPDATE products SET price = '324500' WHERE id = '170197'
454 0.0003 0.00027585029602051
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
455 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '403517'
456 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '403517'
457 0.0029 0.002946138381958
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
458 0.0002 0.00019121170043945
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
459 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
460 0.0004 0.0004279613494873
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
461 0.0001 0.00013208389282227
UPDATE products SET price = '6699' WHERE id = '403517'
462 0.0002 0.00022411346435547
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
463 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '414825'
464 0.0001 0.00014305114746094
SELECT * FROM productcustomimages WHERE product_id = '414825'
465 0.0020 0.0020380020141602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
466 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
467 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
468 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
469 0.0001 0.00013208389282227
UPDATE products SET price = '11999' WHERE id = '414825'
470 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '147874' ORDER BY sortorder ASC
471 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '147874'
472 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '147874'
473 0.0028 0.0028150081634521
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '147874' AND a.name = n.originalname
474 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '147874' AND merchantid = 'ATVPDKIKX0DER'
475 0.0002 0.00022315979003906
SELECT * FROM productoffers
                WHERE product_id = '147874' AND price > 0
                ORDER BY price ASC LIMIT 1
476 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '147874' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
477 0.0001 0.00012898445129395
UPDATE products SET price = '599' WHERE id = '147874'
478 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
479 0.0002 0.00023579597473145
SELECT * FROM product_image_select WHERE product_id = '405644'
480 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '405644'
481 0.0034 0.0033519268035889
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
482 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
483 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
484 0.0004 0.00044012069702148
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
485 0.0001 0.00012898445129395
UPDATE products SET price = '63539' WHERE id = '405644'
486 0.1023 0.10233902931213
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.00026583671569824
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:1560879191;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:7;s:6:\"404554\";i:8;s:6:\"412927\";i:9;s:6:\"409759\";i:12;s:6:\"370121\";i:22;s:6:\"410949\";}}' WHERE id = '181'
488 0.0005 0.00048708915710449
SELECT * FROM products WHERE id IN (414940,404554,412927,409759,370121,410949) ORDER BY FIELD(id, 414940,404554,412927,409759,370121,410949 )
489 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
490 0.0002 0.00022602081298828
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.0032370090484619
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.00020003318786621
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
494 0.0002 0.00023317337036133
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
495 0.0005 0.00045895576477051
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
496 0.0001 0.00013303756713867
UPDATE products SET price = '4490' WHERE id = '414940'
497 0.0003 0.00029683113098145
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
498 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '404554'
499 0.0001 0.00014400482177734
SELECT * FROM productcustomimages WHERE product_id = '404554'
500 0.0033 0.0033280849456787
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
501 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
502 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
503 0.0005 0.00046896934509277
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
504 0.0001 0.00013113021850586
UPDATE products SET price = '399999' WHERE id = '404554'
505 0.0003 0.00028085708618164
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
506 0.0002 0.00023508071899414
SELECT * FROM product_image_select WHERE product_id = '412927'
507 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '412927'
508 0.0036 0.0035979747772217
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
509 0.0002 0.00019621849060059
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
510 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
511 0.0005 0.00045609474182129
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
512 0.0001 0.00014400482177734
UPDATE products SET price = '199900' WHERE id = '412927'
513 0.0002 0.00022482872009277
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
514 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '409759'
515 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '409759'
516 0.0028 0.0027720928192139
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
517 0.0002 0.00019478797912598
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
518 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
519 0.0004 0.00040912628173828
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
520 0.0001 0.00013303756713867
UPDATE products SET price = '229000' WHERE id = '409759'
521 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
522 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '370121'
523 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '370121'
524 0.0027 0.0027399063110352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
525 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
526 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
527 0.0004 0.00040888786315918
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
528 0.0001 0.00013017654418945
UPDATE products SET price = '9899' WHERE id = '370121'
529 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
530 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '410949'
531 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '410949'
532 0.0027 0.0026860237121582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
533 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
534 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
535 0.0004 0.00040411949157715
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
536 0.0001 0.00012993812561035
UPDATE products SET price = '47995' WHERE id = '410949'
537 0.1020 0.10198187828064
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.00029397010803223
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:1560879191;s:8:\"products\";a:6:{i:5;s:6:\"171938\";i:10;s:6:\"408792\";i:15;s:6:\"414188\";i:17;s:6:\"130885\";i:18;s:6:\"147874\";i:21;s:6:\"131163\";}}' WHERE id = '183'
539 0.0005 0.00048685073852539
SELECT * FROM products WHERE id IN (171938,408792,414188,130885,147874,131163) ORDER BY FIELD(id, 171938,408792,414188,130885,147874,131163 )
540 0.0006 0.00064921379089355
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
541 0.0002 0.0002439022064209
SELECT * FROM product_image_select WHERE product_id = '171938'
542 0.0001 0.00013995170593262
SELECT * FROM productcustomimages WHERE product_id = '171938'
543 0.0026 0.0025568008422852
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
544 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
545 0.0002 0.000244140625
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
546 0.0004 0.00040888786315918
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
547 0.0001 0.00013613700866699
UPDATE products SET price = '389500' WHERE id = '171938'
548 0.0002 0.00021815299987793
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
549 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '408792'
550 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '408792'
551 0.0036 0.0035789012908936
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
552 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
553 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
554 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
555 0.0001 0.00014019012451172
UPDATE products SET price = '13499' WHERE id = '408792'
556 0.0003 0.00028204917907715
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
557 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '414188'
558 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '414188'
559 0.0025 0.0025489330291748
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
560 0.0002 0.00018978118896484
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
561 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
562 0.0004 0.00040793418884277
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
563 0.0001 0.00012898445129395
UPDATE products SET price = '9999' WHERE id = '414188'
564 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
565 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '130885'
566 0.0001 0.00014400482177734
SELECT * FROM productcustomimages WHERE product_id = '130885'
567 0.0020 0.0019950866699219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
568 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
569 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
570 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
571 0.0001 0.00014185905456543
UPDATE products SET price = '1521' WHERE id = '130885'
572 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '147874' ORDER BY sortorder ASC
573 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '147874'
574 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '147874'
575 0.0028 0.0028231143951416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '147874' AND a.name = n.originalname
576 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '147874' AND merchantid = 'ATVPDKIKX0DER'
577 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = '147874' AND price > 0
                ORDER BY price ASC LIMIT 1
578 0.0004 0.00041103363037109
SELECT value FROM productattributes WHERE product_id = '147874' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
579 0.0001 0.00012803077697754
UPDATE products SET price = '599' WHERE id = '147874'
580 0.0002 0.00023198127746582
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
581 0.0002 0.0002288818359375
SELECT * FROM product_image_select WHERE product_id = '131163'
582 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '131163'
583 0.0025 0.0025219917297363
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
584 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
585 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
586 0.0004 0.00039291381835938
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
587 0.0001 0.00013113021850586
UPDATE products SET price = '20362' WHERE id = '131163'
588 0.0004 0.00042104721069336
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
589 0.0002 0.00015091896057129
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
590 0.0001 0.00014996528625488
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
591 0.0001 0.0001368522644043
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
592 0.0004 0.00041580200195312
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.0001380443572998
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
595 0.0009 0.00093197822570801
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
596 0.0003 0.00033211708068848
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
597 0.0003 0.00031185150146484
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
598 0.0004 0.00037097930908203
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
599 0.0001 0.00014710426330566
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.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.00014686584472656
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
604 0.0004 0.00036406517028809
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
605 0.0003 0.00034213066101074
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'