Tactical Equipment - Survivalist Equipment
   

HDS Systems EDC Tactical Flashlight Review

HDS systems edc tactical flashlight

UPDATED :  

BRIGHT, COMPACT, VERSATILE EDC Tactical Flashlight

THE EDC TACTICAL FLASHLIGHT FROM HDS SYSTEMS IS 3 WAYS EXCELLENT

As a police officer spanning 21+ years of service, I worked night shifts more than any other. Without a doubt the piece of equipment I used most often was not a gun or a radio or a set of handcuffs. It was a flashlight.

Had the HDS Systems EDC Tactical light been available at the time, it would have been my flashlight of choice.

THE BASICS FIRST

1. Its small. The EDC (Every Day Carry) Tactical is a small light at about 3 3A inches long and 1 inch in diameter, making it a perfect size to have with you at all times, whether you're a uniformed officer or plain clothes investigator on or off duty.

2. It lasts. It runs on one long-lasting CR123A lithium battery. These batteries are now common and are available most everywhere these days. A rechargeable battery kit is also available from HDS. The light source is a single LED that you won't have to replace. The body of the light is durable aluminum with steel bezel that will take being dropped repeatedly.

3. It's powerful. The model I tested is rated at 325 lumens in the brightest mode. Thafs brighter than any 5 D-cell light I used to use. A less expensive 250- lumen model is also available and still provides more than enough light for most situations.

THE STANDOUT FEATURES

OK, lots of small, powerful LED flashlights are on the market these days. So why does this one stand out?

What separates the EDC Tactical from the competition in my opinion is the way this light functions through its different modes. There is the typical push button switch in the tailcap, although tailcap isn't the right word because the flashlight unscrews to access the battery compartment at about the mid-point.

THINK I FOUND MY NEW FAVORITE FLASHLIGHT.

The tail end of the light is actually a rotating dial. With the dial rotated fully clockwise, pushing the button will give you momentary-on maximum brightness. Release the button and the light goes off. Ifs a setting thafs easy to remember and easy to find by feel in the dark.

EDC compact tactical flashlightThe EDC Tactical runs on one easily replaced CR123A lithium battery. An optional kit with rechargeable battery is also available.

Its perfect for when using a 'Hash and dash" technique — a brief flash of light to reveal threats and obstacles and then moving in the dark with the light off to prevent you from being an easy target.

Back off that rotating control slightly from full clockwise and pushing the button gets you to the momentary-on blinding strobe mode. Starting at the full counter-clockwise end of the rotating dial you have the variable constant-on settings. Adjusting the dial clockwise little by little takes you from the dimmest glow through multiple brightness levels to strobe to maximum There are not just one or two brightness settings. I counted 12.

This is especially appealing because many times you don't want or need the maximum brightness. You might be merely filling out a report or you might be engaged in the more serious business of moving into position for a tactical operation. Preserve your night vision, save your battery and don't give away your position. Go with a lower brightness setting.

IT GETS BETTER

You don't want to be fumbling with dials or trying to remember a sequence of button pushes to reach different modes on a tactical flashlight. It has to be easy to use under stress with gross motor movements.

That's where the EDC Tactical really shines, literally. Say you're jotting down some notes and your light is on a low brightness setting. Suddenly someone, a possible threat comes out of the darkness toward you.

With your light already at constant on, you have only to push the button with your thumb and your light instantly goes to momentary-on maximum brightness. Release the button and you automatically go back to your constant-on lower setting.

No fine motor skills are required, no complicated drills to remember. A double click of the button with the light on allows you to toggle back and forth between the constant-on dim setting of your choice and constant-on maximum brightness.

LOW BATTERY INDICATOR

When your battery is getting low, the flashlight will turn off momentarily, then come back on at one brightness setting lower. This will repeat as the battery continues to be depleted. When the battery is no longer capable of maintaining a 50-lumen output, the light will double blink once every two minutes as an indicator that the battery needs to be replaced.

NOT JUST A BACKUP LIGHT

I don't think this HDS light should be relegated to mere backup light status. My days on patrol are over, but if this light had been available when I worked the road, I would have carried two of them: one as my primary and a second as a backup. It does everything I need a light to do without taking up a lot of room or weighing me down.

I'm still a flashlight fanatic. I use them on camping trips and back-country hunts. I carry one whenever I go out as a companion to my concealed carry handgun. Until something better comes along, this is now my go-to light.


WHY A COMPACT LIGHT MAKES SENSE

compact-tactical-every-day-carry-flashlightEDC means "every day carry." A light, a knife and a handgun are some of the things an officer should think about having on him at all times.

Early in my police career, it was necessary to carry a large light for a couple of reasons.

First, there were no small lights available that were sufficiently powerful to really light up an area enough to reveal possible threats.

Second, our issue batons were nothing more than long wooden sticks. You had to remove it from the ring on your duty belt before taking a seat in a vehicle. That meant that when you had to dash out of the car in a hurry you usually grabbed your flashlight first and the baton often was left behind.

Later, we were issued collapsible batons that could stay on your duty belt even when seated in a vehicle. And advances in technology saw the introduction of small, powerful flashlights. It no longer made sense to carry a long, heavy light. Weighed down with full duty gear, including body armor, it was hard enough to catch a suspect in a hoodie and basketball shoes in a foot chase.

You need to have your hands free on a moment's notice, whether to handcuff a suspect, wrestle a drunk or help to carry a victim to an ambulance. A small light rides easily on your belt or tucks away in a pocket. Ifs there at all times, even on the day shifts when you suddenly find yourself searching the dark basement of a vacant building.

EDC Tactical Flashlight Specifications
Model EDC Tactical flashlight
Manufacturer HDS Systems Inc.
Light source LED
Brightness 0-325 lumens variable (tested); 0-250 lumens variable model also available
Modes Constant-on variable brightness and strobe; momentary-on full power and strobe
Size 3 ¾ inches long, 1 inch in diameter
Power source one CR123A lithium battery; rechargeable battery kit also available for $41
MSRP $299 for 325 lumens model; $269 for 250 lumens model

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.7170798778534 610 0.5809 0


No Amazon API Requests Made.


App Debug - Total Time 1.7170798778534 seconds

Number Time From Start Name Description
1 0.89078593254089 Initialise Initialise FSB Function
2 0.89956998825073 App Controller Start Start of the App controller (called before the controller of every page)
3 0.91121888160706 Start of getCategoryListByGroup Function Before first category groups query
4 0.91139006614685 After initial query Before first category groups query
5 0.91139197349548 Get Category List for Group Before the call to getCategoryList function
6 0.91139507293701 Start of GetCategoryList function Start of the function
7 0.91140103340149 Before getting categories Query to get specific category list
8 0.91204595565796 After getting categories Query to get specific category list
9 0.91204690933228 Before getting category custom Before call to function getCategoryCustom
10 0.91392397880554 After getting category custom After call to function getCategoryCustom
11 0.91392707824707 Before getting category custom Before call to function getCategoryCustom
12 0.92445302009583 After getting category custom After call to function getCategoryCustom
13 0.92445588111877 Before getting category custom Before call to function getCategoryCustom
14 0.92997193336487 After getting category custom After call to function getCategoryCustom
15 0.9299750328064 Before getting category custom Before call to function getCategoryCustom
16 0.93405795097351 After getting category custom After call to function getCategoryCustom
17 0.93405985832214 End of GetCategoryList function End of the function
18 0.93406891822815 Get Category List for Group Before the call to getCategoryList function
19 0.93407106399536 Start of GetCategoryList function Start of the function
20 0.93407392501831 Before getting categories Query to get specific category list
21 0.93450689315796 After getting categories Query to get specific category list
22 0.93450808525085 Before getting category custom Before call to function getCategoryCustom
23 0.94005489349365 After getting category custom After call to function getCategoryCustom
24 0.94005799293518 Before getting category custom Before call to function getCategoryCustom
25 0.95061087608337 After getting category custom After call to function getCategoryCustom
26 0.95061302185059 End of GetCategoryList function End of the function
27 0.95061898231506 Get Category List for Group Before the call to getCategoryList function
28 0.95062208175659 Start of GetCategoryList function Start of the function
29 0.95062494277954 Before getting categories Query to get specific category list
30 0.951416015625 After getting categories Query to get specific category list
31 0.95141792297363 Before getting category custom Before call to function getCategoryCustom
32 0.96051907539368 After getting category custom After call to function getCategoryCustom
33 0.96052193641663 Before getting category custom Before call to function getCategoryCustom
34 0.97773694992065 After getting category custom After call to function getCategoryCustom
35 0.97774004936218 Before getting category custom Before call to function getCategoryCustom
36 0.98361206054688 After getting category custom After call to function getCategoryCustom
37 0.98361492156982 Before getting category custom Before call to function getCategoryCustom
38 0.98949408531189 After getting category custom After call to function getCategoryCustom
39 0.98949694633484 Before getting category custom Before call to function getCategoryCustom
40 0.99564599990845 After getting category custom After call to function getCategoryCustom
41 0.99564790725708 Before getting category custom Before call to function getCategoryCustom
42 1.0174589157104 After getting category custom After call to function getCategoryCustom
43 1.017462015152 Before getting category custom Before call to function getCategoryCustom
44 1.0215020179749 After getting category custom After call to function getCategoryCustom
45 1.0215048789978 Before getting category custom Before call to function getCategoryCustom
46 1.0260798931122 After getting category custom After call to function getCategoryCustom
47 1.0260820388794 End of GetCategoryList function End of the function
48 1.026095867157 Get Category List for Group Before the call to getCategoryList function
49 1.0260989665985 Start of GetCategoryList function Start of the function
50 1.02610206604 Before getting categories Query to get specific category list
51 1.0265378952026 After getting categories Query to get specific category list
52 1.0265390872955 Before getting category custom Before call to function getCategoryCustom
53 1.0288028717041 After getting category custom After call to function getCategoryCustom
54 1.0288059711456 Before getting category custom Before call to function getCategoryCustom
55 1.0310840606689 After getting category custom After call to function getCategoryCustom
56 1.0310859680176 End of GetCategoryList function End of the function
57 1.0310919284821 Get Category List for Group Before the call to getCategoryList function
58 1.0310940742493 Start of GetCategoryList function Start of the function
59 1.0310969352722 Before getting categories Query to get specific category list
60 1.0313980579376 After getting categories Query to get specific category list
61 1.0313999652863 Before getting category custom Before call to function getCategoryCustom
62 1.0362889766693 After getting category custom After call to function getCategoryCustom
63 1.0362908840179 End of GetCategoryList function End of the function
64 1.036297082901 End of getCategoryListByGroup Function Before return()
65 1.088075876236 App Controller End End of the App controller (called before the controller of every page)
66 1.0909080505371 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 1.0910360813141 Before Get Options Before the call to getOptions in the tpl class
68 1.4992048740387 After Get Options After the call to getOptions in the tpl class
69 1.4992589950562 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.71706199646 Finalizing debug Before the debug is output to the page.
71 1.7170779705048 End of App This is the end of the app logging, final timestamp


Query Debug - 610 Database Queries. Total time 0.5809 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016999244689941
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00045108795166016
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00015401840209961
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.0001380443572998
SELECT * FROM `bad_bots`
5 0.0005 0.00045204162597656
SELECT parameter, value FROM parameters
6 0.0002 0.00016117095947266
SET time_zone = 'Europe/London'
7 0.0004 0.00037312507629395
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00015115737915039
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010800361633301
delete from cachefiles
10 0.0003 0.0002741813659668
SELECT id FROM pages WHERE pagename = 'hds-systems-edc-tactical-flashlight-review' LIMIT 1
11 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = 398
12 0.0008 0.00078606605529785
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0093 0.009289026260376
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00028300285339355
SELECT * FROM pages WHERE pagename = 'hds-systems-edc-tactical-flashlight-review'
15 0.0002 0.00015497207641602
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00055098533630371
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00049805641174316
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.0002291202545166
SELECT id FROM categories WHERE parent_id = '49'
19 0.0004 0.00043797492980957
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.0001 0.00014710426330566
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.00015902519226074
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.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0029709339141846
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.00025415420532227
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020408630371094
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.0001981258392334
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0057179927825928
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
32 0.0002 0.00015401840209961
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.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0022819042205811
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.00025701522827148
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0022969245910645
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 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 (80)
				  AND p.disabled = 0 
39 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
40 0.0002 0.00015711784362793
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
42 0.0011 0.0011429786682129
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.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.0002129077911377
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017709732055664
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.00016593933105469
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0001 0.00014901161193848
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.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00040888786315918
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0022869110107422
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0022850036621094
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.00015616416931152
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.00018596649169922
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.00016880035400391
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0047640800476074
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.00026512145996094
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0048301219940186
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.00015592575073242
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.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '2'
65 0.0006 0.00063204765319824
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0040650367736816
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.0002598762512207
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0040698051452637
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.00016593933105469
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0001 0.00014710426330566
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.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
73 0.0080 0.0080418586730957
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.00027918815612793
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.0081658363342285
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.00016617774963379
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.0001 0.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '10'
80 0.0024 0.0024471282958984
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.00026798248291016
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024771690368652
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.0001 0.00014996528625488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
85 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024440288543701
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.0002601146697998
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.002471923828125
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.00015091896057129
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0001 0.00014495849609375
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0021958351135254
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.00025582313537598
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0027980804443359
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.00015497207641602
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.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '10'
102 0.0094 0.0094180107116699
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.00028705596923828
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00020122528076172
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '130'
109 0.0103 0.010293006896973
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.00017881393432617
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.00015807151794434
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.00017619132995605
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '10'
114 0.0015 0.0015408992767334
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.0002591609954834
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015668869018555
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0001 0.00014495849609375
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.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0018060207366943
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.00026202201843262
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0018219947814941
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
125 0.0001 0.00014591217041016
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.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00041103363037109
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00066804885864258
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.00023984909057617
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00068092346191406
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0001 0.00014305114746094
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.00015115737915039
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00068187713623047
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 90
137 0.0002 0.00023293495178223
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00071287155151367
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.00014400482177734
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0001 0.00014305114746094
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.0001528263092041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00011992454528809
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.0002892017364502
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0019772052764893
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.00025010108947754
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020029544830322
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
148 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '20'
151 0.0050 0.0049910545349121
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00038599967956543
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00020503997802734
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015997886657715
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '84'
158 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00022411346435547
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '379'
168 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '457'
172 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00015401840209961
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '107'
182 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00020289421081543
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016617774963379
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00028204917907715
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '119'
208 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '411'
220 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '362'
229 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00020217895507812
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014901161193848
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '156'
251 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '316'
255 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '387'
259 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016307830810547
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00022196769714355
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '95'
267 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00022792816162109
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00021481513977051
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00022387504577637
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '343'
282 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '392'
289 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.00014185905456543
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00023984909057617
SELECT * FROM pages WHERE id = '293'
308 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00014114379882812
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '385'
318 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '438'
319 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.00026512145996094
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.0001530647277832
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00022697448730469
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014376640319824
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '199'
338 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014305114746094
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0013799667358398
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0003 0.00028491020202637
SELECT * FROM pages WHERE pagename = 'hds-systems-edc-tactical-flashlight-review'
373 0.0003 0.00025296211242676
SELECT * FROM products WHERE id = '409076'
374 0.0002 0.0001680850982666
SELECT * FROM productimages WHERE product_id = '' ORDER BY sortorder ASC
375 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = ''
376 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = ''
377 0.0001 0.00010490417480469
SELECT pagename FROM products WHERE id = ''
378 0.0003 0.00025296211242676
SELECT value FROM productattributes WHERE product_id = '' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
379 0.0002 0.00016903877258301
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
380 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = 2
381 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 4
382 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 12
383 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = 10
384 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 7
385 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 18
386 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 28
387 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 13
388 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = 3
389 0.0427 0.042686939239502
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
390 0.0002 0.00023794174194336
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:1560834303;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:4;s:6:\"171938\";i:7;s:6:\"409759\";i:8;s:6:\"408792\";i:14;s:6:\"406758\";i:16;s:6:\"408078\";}}' WHERE id = '175'
391 0.0005 0.0004580020904541
SELECT * FROM products WHERE id IN (398315,171938,409759,408792,406758,408078) ORDER BY FIELD(id, 398315,171938,409759,408792,406758,408078 )
392 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
393 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '398315'
394 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '398315'
395 0.0025 0.0025098323822021
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
396 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
397 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
398 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
399 0.0001 0.00012493133544922
UPDATE products SET price = '1999' WHERE id = '398315'
400 0.0006 0.00061488151550293
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
401 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '171938'
402 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '171938'
403 0.0025 0.0025439262390137
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
404 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
405 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
406 0.0004 0.00038385391235352
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
407 0.0001 0.00012087821960449
UPDATE products SET price = '389500' WHERE id = '171938'
408 0.0002 0.00021004676818848
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
409 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '409759'
410 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '409759'
411 0.0028 0.0028009414672852
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
412 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
413 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
414 0.0004 0.00039386749267578
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
415 0.0001 0.00012397766113281
UPDATE products SET price = '229000' WHERE id = '409759'
416 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
417 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '408792'
418 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '408792'
419 0.0036 0.0035991668701172
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
420 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0001 0.00011801719665527
UPDATE products SET price = '13499' WHERE id = '408792'
424 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
425 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '406758'
426 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '406758'
427 0.0026 0.0026299953460693
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
428 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
429 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
430 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
431 0.0001 0.00012898445129395
UPDATE products SET price = '2694' WHERE id = '406758'
432 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
433 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '408078'
434 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '408078'
435 0.0031 0.0030651092529297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
436 0.0002 0.00020480155944824
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
437 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
438 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
439 0.0001 0.0001220703125
UPDATE products SET price = '23352' WHERE id = '408078'
440 0.0425 0.042468070983887
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
441 0.0002 0.00022506713867188
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:1560834303;s:8:\"products\";a:6:{i:6;s:6:\"412927\";i:12;s:6:\"414825\";i:14;s:6:\"406758\";i:15;s:6:\"130885\";i:17;s:6:\"405644\";i:21;s:6:\"406901\";}}' WHERE id = '177'
442 0.0004 0.00044393539428711
SELECT * FROM products WHERE id IN (412927,414825,406758,130885,405644,406901) ORDER BY FIELD(id, 412927,414825,406758,130885,405644,406901 )
443 0.0003 0.00027012825012207
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
444 0.0002 0.00020980834960938
SELECT * FROM product_image_select WHERE product_id = '412927'
445 0.0001 0.00012612342834473
SELECT * FROM productcustomimages WHERE product_id = '412927'
446 0.0037 0.0036759376525879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
447 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
448 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
449 0.0004 0.00044488906860352
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
450 0.0001 0.0001220703125
UPDATE products SET price = '199900' WHERE id = '412927'
451 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
452 0.0002 0.00020980834960938
SELECT * FROM product_image_select WHERE product_id = '414825'
453 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '414825'
454 0.0020 0.0020129680633545
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
455 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
456 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
457 0.0004 0.00037002563476562
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
458 0.0001 0.00011897087097168
UPDATE products SET price = '11999' WHERE id = '414825'
459 0.0002 0.00018811225891113
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
460 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '406758'
461 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '406758'
462 0.0026 0.0026130676269531
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
463 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
464 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
465 0.0004 0.00037884712219238
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
466 0.0001 0.00012016296386719
UPDATE products SET price = '2694' WHERE id = '406758'
467 0.0002 0.00019311904907227
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
468 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '130885'
469 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '130885'
470 0.0020 0.0019760131835938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
471 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
472 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
473 0.0003 0.00034499168395996
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
474 0.0001 0.00012779235839844
UPDATE products SET price = '1521' WHERE id = '130885'
475 0.0002 0.00018191337585449
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
476 0.0002 0.00020384788513184
SELECT * FROM product_image_select WHERE product_id = '405644'
477 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '405644'
478 0.0034 0.0034010410308838
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
479 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
480 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
481 0.0004 0.00042009353637695
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
482 0.0001 0.00011897087097168
UPDATE products SET price = '63539' WHERE id = '405644'
483 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
484 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '406901'
485 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '406901'
486 0.0023 0.0023472309112549
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
487 0.0002 0.00021219253540039
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
488 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
489 0.0004 0.00035691261291504
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
490 0.0001 0.00012397766113281
UPDATE products SET price = '395' WHERE id = '406901'
491 0.1027 0.10273098945618
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
492 0.0003 0.00026392936706543
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"categories\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560834303;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:10;s:6:\"370121\";i:20;s:6:\"408079\";i:23;s:5:\"43519\";i:7;s:6:\"409759\";}}' WHERE id = '181'
493 0.0005 0.00047707557678223
SELECT * FROM products WHERE id IN (414940,398315,370121,408079,43519,409759) ORDER BY FIELD(id, 414940,398315,370121,408079,43519,409759 )
494 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
495 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '414940'
496 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '414940'
497 0.0033 0.0032849311828613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
498 0.0002 0.00020194053649902
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
499 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
500 0.0004 0.0004279613494873
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
501 0.0001 0.00012111663818359
UPDATE products SET price = '4490' WHERE id = '414940'
502 0.0002 0.00020885467529297
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
503 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '398315'
504 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '398315'
505 0.0025 0.0025191307067871
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
506 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
507 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
508 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
509 0.0001 0.00013089179992676
UPDATE products SET price = '1999' WHERE id = '398315'
510 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
511 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '370121'
512 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '370121'
513 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
514 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
515 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
516 0.0004 0.00039386749267578
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
517 0.0001 0.00011801719665527
UPDATE products SET price = '9899' WHERE id = '370121'
518 0.0002 0.00017499923706055
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
519 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '408079'
520 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '408079'
521 0.0032 0.0032119750976562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
522 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
523 0.0002 0.00020217895507812
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
524 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
525 0.0001 0.00012016296386719
UPDATE products SET price = '18547' WHERE id = '408079'
526 0.0002 0.00018405914306641
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
527 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '43519'
528 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '43519'
529 0.0027 0.0026631355285645
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
530 0.0002 0.00018119812011719
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
531 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
532 0.0003 0.00033092498779297
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
533 0.0001 0.00011992454528809
UPDATE products SET price = '1330' WHERE id = '43519'
534 0.0002 0.00020384788513184
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
535 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '409759'
536 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '409759'
537 0.0028 0.0027811527252197
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
538 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
539 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
540 0.0004 0.00041508674621582
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
541 0.0001 0.00012397766113281
UPDATE products SET price = '229000' WHERE id = '409759'
542 0.1026 0.10263705253601
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
543 0.0003 0.00027084350585938
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:1560834303;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:9;s:6:\"103845\";i:11;s:6:\"403517\";i:14;s:6:\"406758\";i:20;s:6:\"408079\";i:23;s:5:\"43519\";}}' WHERE id = '183'
544 0.0005 0.0004570484161377
SELECT * FROM products WHERE id IN (407595,103845,403517,406758,408079,43519) ORDER BY FIELD(id, 407595,103845,403517,406758,408079,43519 )
545 0.0002 0.000244140625
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
546 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '407595'
547 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '407595'
548 0.0034 0.0033547878265381
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
549 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
550 0.0002 0.00022506713867188
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
551 0.0004 0.0004279613494873
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
552 0.0001 0.00012087821960449
UPDATE products SET price = '2497' WHERE id = '407595'
553 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
554 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '103845'
555 0.0001 0.0001227855682373
SELECT * FROM productcustomimages WHERE product_id = '103845'
556 0.0024 0.0023989677429199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
557 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
558 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
559 0.0004 0.00036787986755371
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
560 0.0001 0.00011682510375977
UPDATE products SET price = '14499' WHERE id = '103845'
561 0.0003 0.00026082992553711
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
562 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '403517'
563 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '403517'
564 0.0030 0.0029599666595459
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
565 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
566 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
567 0.0004 0.00041389465332031
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
568 0.0001 0.00011897087097168
UPDATE products SET price = '6699' WHERE id = '403517'
569 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
570 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '406758'
571 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '406758'
572 0.0026 0.0026378631591797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
573 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
574 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
575 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
576 0.0001 0.00011897087097168
UPDATE products SET price = '2694' WHERE id = '406758'
577 0.0002 0.00017595291137695
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
578 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '408079'
579 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '408079'
580 0.0032 0.0032029151916504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
581 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
582 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
583 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
584 0.0001 0.00012111663818359
UPDATE products SET price = '18547' WHERE id = '408079'
585 0.0002 0.00018405914306641
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
586 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '43519'
587 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '43519'
588 0.0026 0.0026469230651855
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
589 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
590 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
591 0.0003 0.0003199577331543
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
592 0.0001 0.00011992454528809
UPDATE products SET price = '1330' WHERE id = '43519'
593 0.0004 0.00042819976806641
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
594 0.0001 0.0001378059387207
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
595 0.0001 0.00012302398681641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
596 0.0001 0.00012111663818359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
597 0.0004 0.00040793418884277
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
598 0.0001 0.00012588500976562
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0009 0.00092101097106934
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
601 0.0003 0.00032591819763184
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
602 0.0003 0.00028800964355469
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
603 0.0003 0.00034093856811523
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
604 0.0001 0.00013279914855957
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
605 0.0001 0.00012302398681641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
606 0.0001 0.00013208389282227
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
607 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
608 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
609 0.0003 0.00033020973205566
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
610 0.0003 0.00031900405883789
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'