Tactical Equipment - Survivalist Equipment
   

Surefire R1 Lawman Rechargeable Variable Output LED Flashlight

R1 Lawman LED Flashlight Cheap

"JUST BECAUSE YOU CAN DO SOMETHING, DOESN'T MEAN YOU SHOULD DO IT."

UPDATED :  

While this quote is normally touted by Ethicists, I find it holds equally true when it comes to modern flashlights. Flashlights today come in a bevy of sizes and offer a plethora of options, including multiple brightness outputs; strobing effect; temporary vs. permanent on; and all with white, red, blue, yellow-green and IR beams.

With all of these options, you would think that finding your ideal flashlight would be simple; however, finding the size and output option you want can still be a challenge. In my quest to find a light I could use at work, I was able to get my hands on a SureFire R1 Lawman LED Flashlight and put it through its paces.

ON THE STREET

To be candid, I am a police officer who works patrol at night. I offer that so you'll understand the environment in which I work and can get some idea of what I might need a tactical light to do.

Also know that I use two lights at work: a high-output light that is on my belt at all times, and in this case, the Lawman, which I kept in my patrol bag and used as needed. In this capacity, the Lawman was used to illuminate people, places, and things in low-light and near-total dark environments. These included streets ides, residences, warehouses, backyards and empty lots.

FIRST REACTIONS

In receiving the Lawman, I was impressed not only with the look and feel of the light itself, but with the amount of items that accompany it. The box had sharp graphics and pertinent information as to what was inside and what the light could do.

Inside the box was, of course, the R1 Lawman flashlight, as well as a lithium-ion rechargeable battery, a battery magazine that holds two disposable 123A lithium batteries, a wall charger (AC) with four international adapters, a car charger (DC) and an anti-roll ring.

Additionally, it comes with a warning pamphlet, a pamphlet listing available accessories and a 55-page user manual that is written in seven languages. The Lawman Tactical Flashlight comes with enough support equipment to stay functional in a variety of environments.

Discount SureFire R1 Lawman Flashlight

GETTING A FEEL FOR IT

The first thing I read is that you can program three different switching modes, each of which has the light function differently, depending if you use the tailcap switch or the bezel switch. Program One has the tailcap switch run at high output only, and the bezel switch runs from high, medium, low and off as you cycle through it.

Program Two has the tailcap switch cycle between high and strobe, and the bezel switch runs from high, medium, low and off as you cycle through it. This was my preferred option, though it should be noted that in order to activate the strobe function, you have to press the switch three times and then hold it This is not exactly intuitive. On the plus side, I never needed the strobe option, as I will argue that it has extremely limited practical use.

Program Three has the tailcap switch run at high only, and the bezel switch runs at high only as well, simplifying things significantly, and also taking away a lot of what this flashlight is capable of.

As expected, the high output beam worked excellently in large spaces and when I needed to clearly illuminate people. The medium output beam worked well indoors in general, whereas a high output beam can blind a user as it splashes off white interior walls. The Sow output beam was a lifesaver when I needed to write things (notes, tickets, forms) while standing out on the streets and when I needed to find things on the ground. It provided enough light without my feeling like my corneas were scarred after the fact.

As for the light output, with three intensity settings and two power sources, you end up with four options. When using the high setting, the rechargeable battery is an impressive 1,000 lumens, while it's "only" 500 when using 123's.

The medium setting is listed as 300 lumens, and the low setting is listed as 15 lumens with both power sources, These varied output options result in two different runtimes depending upon If you are using the lithium-ion rechargeable battery or the CR 123 battery magazine.

Normally, I prefer to use disposable batteries, as I make sure that they are readily available, and I don't like to bother with a rechargeable, which typically requires you have a spare on hand if you want to make sure you always have a working light. However, with the significant increase of lumen output on high (1,000 vs, 500 lumens) and having a wall charger, as well as the car charger, I had no issues in using the rechargeable and being able to keep the Lawman powered up.

UNDER THE HOOD

The flashlight itself is just what you'd expect from SureFire. It looks sleek, it's tacti-cool and rugged. It's made of a black-coated, high?strength hard-anodized aerospace aluminum. It is light, as it weighs only 10.2 ounces, yet it fills my hand nicely at 8.1-inches long; it also has a 1-inch body diameter. The tubular body has two flat sides to reduce the profile and a textured knurling that Increases the "stickiness" of the light when holding it. The ergonomics allow the user to switch easily between running the fight with the bezel coming out of either side of the hand.

Surefire R1 Lawman Specifications

  • Tactical Runtime: 1.75 hours
  • Length: 8.1 inches
  • Bezel Diameter: 1.62 inches
  • Weight With Batteries: 10.2 ounces
  • Batteries: 1 x Li-ion rech or 2 x CR 123A
  • RRP: $455

Surefire Lumens Output

  • 1000 for 1.75 hours
  • 150 for 5.25 hours
  • 15 for 37 hours
  • (Using included rechargable batteries)

The "tactical tailcap" switch is a press for momentary-on and a twist for constant on! would have much preferred to see a "clicky" tailcap on this model. Overall, I like the size of the Lawman flashlight as it fits the hand well, but it is not so small that I have to fish for it in a pocket.

The Lawman comes with an anti-roll ring, which I put on as directed. While I remember first seeing SureFire put flat edges on their lights back in 2000, which I thought was ingenious, I'm not sure how useful the ring is, as it does not seem to offer much more than the crenelations already found around the bezel.

"IT LOOKS SLEEK, IT'S BRIGHT, TACTI-COOL AND RUGGED"

With a list price of $455, the Lawman is not going to be the first choice for most first responded. To further alienate their customers, SureFire developed a proprietary rechargeable for this light that ensures that you use their product as the Lawman is not compatible with other rechargeable 18650 type batteries. In SureFire's favor though, all of the needed hardware came with the light.

FINAL WORDS

The LED tactical flashlight world has exploded in the last 20 years, and there are many companies that can bring economical and innovative options to the market. Still, I still find that SureFire sets the standard where quality is concerned.

In my perfect world, I would have a Lawman with a clicky tailcap switch that had a high output only and a bezel switch that had a high and low output and that remembered what you last used when you turned it off.

Using the Lawman, however, l found that it more than met my needs of having a light that fit seamlessly in how I run a gun and light together, while having a focused bright light, with enough throw to search large backyards, that could be brought down to a useable level where I could illuminate my immediate area without blinding myself.

In this world of flashlight overload, the Lawman holds its own as a premium light that exhibits some of the best of what modern tactical and combat flashlights have to offer.

SureFire R1 Lawman Comparison 500 Lumens


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.2422640323639 610 0.5965 0


No Amazon API Requests Made.


App Debug - Total Time 1.2422640323639 seconds

Number Time From Start Name Description
1 0.37912392616272 Initialise Initialise FSB Function
2 0.3871738910675 App Controller Start Start of the App controller (called before the controller of every page)
3 0.39906191825867 Start of getCategoryListByGroup Function Before first category groups query
4 0.39924287796021 After initial query Before first category groups query
5 0.39924383163452 Get Category List for Group Before the call to getCategoryList function
6 0.39924788475037 Start of GetCategoryList function Start of the function
7 0.39925193786621 Before getting categories Query to get specific category list
8 0.39986085891724 After getting categories Query to get specific category list
9 0.39986300468445 Before getting category custom Before call to function getCategoryCustom
10 0.40186190605164 After getting category custom After call to function getCategoryCustom
11 0.40186500549316 Before getting category custom Before call to function getCategoryCustom
12 0.41254496574402 After getting category custom After call to function getCategoryCustom
13 0.41254782676697 Before getting category custom Before call to function getCategoryCustom
14 0.41821098327637 After getting category custom After call to function getCategoryCustom
15 0.41821384429932 Before getting category custom Before call to function getCategoryCustom
16 0.42243790626526 After getting category custom After call to function getCategoryCustom
17 0.42244100570679 End of GetCategoryList function End of the function
18 0.42244982719421 Get Category List for Group Before the call to getCategoryList function
19 0.42245292663574 Start of GetCategoryList function Start of the function
20 0.42245602607727 Before getting categories Query to get specific category list
21 0.42291903495789 After getting categories Query to get specific category list
22 0.42292094230652 Before getting category custom Before call to function getCategoryCustom
23 0.42857003211975 After getting category custom After call to function getCategoryCustom
24 0.4285728931427 Before getting category custom Before call to function getCategoryCustom
25 0.43927597999573 After getting category custom After call to function getCategoryCustom
26 0.43927884101868 End of GetCategoryList function End of the function
27 0.43928599357605 Get Category List for Group Before the call to getCategoryList function
28 0.43928790092468 Start of GetCategoryList function Start of the function
29 0.43929100036621 Before getting categories Query to get specific category list
30 0.44005489349365 After getting categories Query to get specific category list
31 0.44005703926086 Before getting category custom Before call to function getCategoryCustom
32 0.44932889938354 After getting category custom After call to function getCategoryCustom
33 0.44933199882507 Before getting category custom Before call to function getCategoryCustom
34 0.46674394607544 After getting category custom After call to function getCategoryCustom
35 0.46674704551697 Before getting category custom Before call to function getCategoryCustom
36 0.47275495529175 After getting category custom After call to function getCategoryCustom
37 0.47275805473328 Before getting category custom Before call to function getCategoryCustom
38 0.47870087623596 After getting category custom After call to function getCategoryCustom
39 0.47870397567749 Before getting category custom Before call to function getCategoryCustom
40 0.48502993583679 After getting category custom After call to function getCategoryCustom
41 0.48503303527832 Before getting category custom Before call to function getCategoryCustom
42 0.50746393203735 After getting category custom After call to function getCategoryCustom
43 0.5074679851532 Before getting category custom Before call to function getCategoryCustom
44 0.51167798042297 After getting category custom After call to function getCategoryCustom
45 0.51168084144592 Before getting category custom Before call to function getCategoryCustom
46 0.51637291908264 After getting category custom After call to function getCategoryCustom
47 0.51637482643127 End of GetCategoryList function End of the function
48 0.51639199256897 Get Category List for Group Before the call to getCategoryList function
49 0.51639485359192 Start of GetCategoryList function Start of the function
50 0.51639795303345 Before getting categories Query to get specific category list
51 0.51685500144958 After getting categories Query to get specific category list
52 0.51685690879822 Before getting category custom Before call to function getCategoryCustom
53 0.5192608833313 After getting category custom After call to function getCategoryCustom
54 0.51926398277283 Before getting category custom Before call to function getCategoryCustom
55 0.52168393135071 After getting category custom After call to function getCategoryCustom
56 0.52168583869934 End of GetCategoryList function End of the function
57 0.52169299125671 Get Category List for Group Before the call to getCategoryList function
58 0.52169489860535 Start of GetCategoryList function Start of the function
59 0.52169799804688 Before getting categories Query to get specific category list
60 0.52203798294067 After getting categories Query to get specific category list
61 0.52203989028931 Before getting category custom Before call to function getCategoryCustom
62 0.52711892127991 After getting category custom After call to function getCategoryCustom
63 0.52712202072144 End of GetCategoryList function End of the function
64 0.52712798118591 End of getCategoryListByGroup Function Before return()
65 0.58145594596863 App Controller End End of the App controller (called before the controller of every page)
66 0.58413887023926 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.58423686027527 Before Get Options Before the call to getOptions in the tpl class
68 1.0020668506622 After Get Options After the call to getOptions in the tpl class
69 1.0021178722382 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.2422459125519 Finalizing debug Before the debug is output to the page.
71 1.242262840271 End of App This is the end of the app logging, final timestamp


Query Debug - 610 Database Queries. Total time 0.5965 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016403198242188
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00044393539428711
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00015807151794434
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.0001521110534668
SELECT * FROM `bad_bots`
5 0.0005 0.00046396255493164
SELECT parameter, value FROM parameters
6 0.0002 0.00015711784362793
SET time_zone = 'Europe/London'
7 0.0003 0.0002751350402832
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00015902519226074
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00012302398681641
delete from cachefiles
10 0.0002 0.00024199485778809
SELECT id FROM pages WHERE pagename = 'surefire-r1-lawman-rechargeable-variable-output-led-flashlight' LIMIT 1
11 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = 143
12 0.0008 0.00084018707275391
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0100 0.010006189346313
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00026798248291016
SELECT * FROM pages WHERE pagename = 'surefire-r1-lawman-rechargeable-variable-output-led-flashlight'
15 0.0002 0.00016307830810547
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00056195259094238
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00049996376037598
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.0003 0.00025486946105957
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.00046205520629883
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0002 0.00015616416931152
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.00017499923706055
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.00018811225891113
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '1'
24 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
25 0.0003 0.00026702880859375
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00022196769714355
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0002131462097168
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0056748390197754
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.00018405914306641
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.00016999244689941
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
33 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00014805793762207
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0023131370544434
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 80
36 0.0003 0.00026392936706543
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0023419857025146
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.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
40 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00013518333435059
SELECT * FROM categorygroups WHERE id = '1'
42 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
43 0.0003 0.00026988983154297
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0018010139465332
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
46 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0002 0.00016379356384277
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.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00043201446533203
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0023138523101807
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0003 0.00027203559875488
SELECT id FROM categories WHERE parent_id = '30'
53 0.0023 0.0023000240325928
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.00015497207641602
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.00015997886657715
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.00018310546875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00014591217041016
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0048019886016846
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 61
59 0.0003 0.00027894973754883
SELECT id FROM categories WHERE parent_id = '61'
60 0.0049 0.004857063293457
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.00016403198242188
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0002 0.00016093254089355
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.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00069594383239746
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0041120052337646
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.00028491020202637
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0041041374206543
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.00016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0002 0.00016188621520996
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.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
73 0.0081 0.0081207752227783
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.00028586387634277
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.0082080364227295
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.00017285346984863
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0002 0.00016212463378906
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.00019192695617676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0024709701538086
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.00027894973754883
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0025031566619873
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0002 0.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 
85 0.0002 0.00018215179443359
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024139881134033
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.0002751350402832
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024828910827637
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.00015997886657715
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0002 0.00016117095947266
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.00019192695617676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022368431091309
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.00026392936706543
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00022792816162109
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0028159618377686
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.00017309188842773
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
102 0.0096 0.0096421241760254
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.00031113624572754
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00021886825561523
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00023508071899414
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.0002138614654541
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '130'
109 0.0105 0.010466814041138
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.00018811225891113
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.00017595291137695
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.0001978874206543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00014400482177734
SELECT * FROM categorygroups WHERE id = '10'
114 0.0016 0.0015709400177002
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.0002751350402832
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0016100406646729
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0002 0.0001528263092041
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0002 0.00015997886657715
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.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00013613700866699
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0018260478973389
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.00025796890258789
SELECT id FROM categories WHERE parent_id = '89'
123 0.0019 0.0018529891967773
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0002 0.00015616416931152
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
125 0.0002 0.00016093254089355
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.00018405914306641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00042581558227539
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00069808959960938
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 84
130 0.0002 0.00024986267089844
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00071191787719727
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 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 (84)
				  AND p.disabled = 0 
133 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00070285797119141
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.00024604797363281
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.0007328987121582
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 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 (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00032210350036621
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0020408630371094
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.00025200843811035
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020480155944824
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
148 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '20'
151 0.0054 0.0054390430450439
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00037813186645508
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00016903877258301
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00016593933105469
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '84'
158 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '379'
168 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '450'
170 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.0001680850982666
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00020408630371094
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '133'
185 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '217'
187 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '271'
190 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '286'
191 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '364'
198 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00018596649169922
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.00025296211242676
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '90'
206 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '150'
211 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '162'
213 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '164'
214 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '167'
215 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '180'
216 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '268'
219 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '290'
221 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '413'
222 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '327'
224 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '386'
233 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '428'
240 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '432'
241 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '437'
244 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00018477439880371
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '74'
248 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '137'
249 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '407'
252 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019288063049316
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00018620491027832
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '42'
264 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '86'
266 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00019216537475586
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00023698806762695
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '62'
274 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '393'
290 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '394'
291 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '421'
294 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '430'
296 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '451'
302 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '453'
303 0.0002 0.00015711784362793
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.0002281665802002
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '417'
310 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '181'
313 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00016522407531738
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '383'
317 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '442'
320 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00023984909057617
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '248'
327 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00017118453979492
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00020384788513184
SELECT * FROM pages WHERE id = '115'
334 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '151'
337 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '200'
339 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '304'
340 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00018787384033203
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '446'
350 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '456'
354 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '462'
357 0.0002 0.00015807151794434
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '182'
360 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '238'
361 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '240'
362 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '242'
363 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '252'
364 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '253'
365 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '262'
366 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '267'
367 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '420'
368 0.0002 0.00015687942504883
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00013613700866699
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0014019012451172
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0003 0.0002748966217041
SELECT * FROM pages WHERE pagename = 'surefire-r1-lawman-rechargeable-variable-output-led-flashlight'
373 0.0002 0.00022006034851074
SELECT * FROM products WHERE id = '400621'
374 0.0002 0.00017809867858887
SELECT * FROM productimages WHERE product_id = '' ORDER BY sortorder ASC
375 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = ''
376 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = ''
377 0.0001 0.00013208389282227
SELECT pagename FROM products WHERE id = ''
378 0.0003 0.0002591609954834
SELECT value FROM productattributes WHERE product_id = '' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
379 0.0002 0.00018596649169922
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
380 0.0002 0.00018882751464844
SELECT * FROM pages WHERE id = 2
381 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = 4
382 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = 12
383 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = 10
384 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = 7
385 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = 18
386 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = 28
387 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = 13
388 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = 3
389 0.0427 0.042710065841675
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.00023293495178223
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:1560876759;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:3;s:6:\"407595\";i:6;s:6:\"170197\";i:9;s:6:\"409759\";i:11;s:6:\"402983\";i:12;s:6:\"103845\";}}' WHERE id = '175'
391 0.0005 0.00046896934509277
SELECT * FROM products WHERE id IN (414940,407595,170197,409759,402983,103845) ORDER BY FIELD(id, 414940,407595,170197,409759,402983,103845 )
392 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
393 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '414940'
394 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '414940'
395 0.0033 0.003309965133667
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
396 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
397 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
398 0.0005 0.0004570484161377
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
399 0.0001 0.00013399124145508
UPDATE products SET price = '4490' WHERE id = '414940'
400 0.0002 0.00024700164794922
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
401 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '407595'
402 0.0001 0.00014615058898926
SELECT * FROM productcustomimages WHERE product_id = '407595'
403 0.0033 0.0033450126647949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
404 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
405 0.0002 0.00021219253540039
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
406 0.0004 0.00044989585876465
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
407 0.0001 0.00013113021850586
UPDATE products SET price = '2497' WHERE id = '407595'
408 0.0007 0.0006711483001709
SELECT * FROM productimages WHERE product_id = '170197' ORDER BY sortorder ASC
409 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '170197'
410 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '170197'
411 0.0032 0.0032048225402832
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '170197' AND a.name = n.originalname
412 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '170197' AND merchantid = 'ATVPDKIKX0DER'
413 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '170197' AND price > 0
                ORDER BY price ASC LIMIT 1
414 0.0004 0.0004279613494873
SELECT value FROM productattributes WHERE product_id = '170197' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
415 0.0001 0.00013399124145508
UPDATE products SET price = '324500' WHERE id = '170197'
416 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
417 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '409759'
418 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '409759'
419 0.0028 0.0027980804443359
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
420 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
421 0.0002 0.00022721290588379
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
422 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
423 0.0001 0.00013399124145508
UPDATE products SET price = '229000' WHERE id = '409759'
424 0.0002 0.00021004676818848
SELECT * FROM productimages WHERE product_id = '402983' ORDER BY sortorder ASC
425 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '402983'
426 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '402983'
427 0.0023 0.0022668838500977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402983' AND a.name = n.originalname
428 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '402983' AND merchantid = 'ATVPDKIKX0DER'
429 0.0002 0.00022697448730469
SELECT * FROM productoffers
                WHERE product_id = '402983' AND price > 0
                ORDER BY price ASC LIMIT 1
430 0.0004 0.0003659725189209
SELECT value FROM productattributes WHERE product_id = '402983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
431 0.0001 0.00013589859008789
UPDATE products SET price = '10392' WHERE id = '402983'
432 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
433 0.0002 0.00023889541625977
SELECT * FROM product_image_select WHERE product_id = '103845'
434 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '103845'
435 0.0024 0.0024220943450928
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
436 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
437 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
438 0.0004 0.00038480758666992
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
439 0.0001 0.00012922286987305
UPDATE products SET price = '14499' WHERE id = '103845'
440 0.0426 0.042593002319336
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.00023007392883301
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:1560876759;s:8:\"products\";a:6:{i:13;s:6:\"370121\";i:15;s:6:\"414825\";i:16;s:6:\"414188\";i:5;s:6:\"171938\";i:7;s:6:\"404554\";i:8;s:6:\"412927\";}}' WHERE id = '177'
442 0.0005 0.0004730224609375
SELECT * FROM products WHERE id IN (370121,414825,414188,171938,404554,412927) ORDER BY FIELD(id, 370121,414825,414188,171938,404554,412927 )
443 0.0002 0.00021982192993164
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
444 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '370121'
445 0.0002 0.00015807151794434
SELECT * FROM productcustomimages WHERE product_id = '370121'
446 0.0028 0.0028069019317627
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
447 0.0002 0.00020813941955566
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
448 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
449 0.0004 0.00040793418884277
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
450 0.0001 0.00014400482177734
UPDATE products SET price = '9899' WHERE id = '370121'
451 0.0002 0.00022101402282715
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
452 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '414825'
453 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '414825'
454 0.0020 0.0019979476928711
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.0001988410949707
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
456 0.0002 0.00023579597473145
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
457 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
458 0.0001 0.00012898445129395
UPDATE products SET price = '11999' WHERE id = '414825'
459 0.0003 0.00029897689819336
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
460 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '414188'
461 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '414188'
462 0.0026 0.0025780200958252
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
463 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
464 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
465 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
466 0.0001 0.00013089179992676
UPDATE products SET price = '9999' WHERE id = '414188'
467 0.0006 0.0006110668182373
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
468 0.0002 0.00023388862609863
SELECT * FROM product_image_select WHERE product_id = '171938'
469 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '171938'
470 0.0026 0.0025749206542969
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
471 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
472 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
473 0.0004 0.00039911270141602
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
474 0.0001 0.00014185905456543
UPDATE products SET price = '389500' WHERE id = '171938'
475 0.0003 0.00028681755065918
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
476 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '404554'
477 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '404554'
478 0.0034 0.0034198760986328
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
479 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
480 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
481 0.0005 0.00047016143798828
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
482 0.0001 0.00012993812561035
UPDATE products SET price = '399999' WHERE id = '404554'
483 0.0003 0.0002751350402832
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
484 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '412927'
485 0.0001 0.00014591217041016
SELECT * FROM productcustomimages WHERE product_id = '412927'
486 0.0037 0.0036540031433105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
487 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
488 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
489 0.0005 0.00046014785766602
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
490 0.0001 0.00013184547424316
UPDATE products SET price = '199900' WHERE id = '412927'
491 0.1050 0.10499501228333
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.0002 0.00024700164794922
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:1560876759;s:8:\"products\";a:6:{i:7;s:6:\"404554\";i:12;s:6:\"103845\";i:18;s:6:\"130885\";i:20;s:6:\"408078\";i:8;s:6:\"412927\";i:16;s:6:\"414188\";}}' WHERE id = '181'
493 0.0004 0.00044918060302734
SELECT * FROM products WHERE id IN (404554,103845,130885,408078,412927,414188) ORDER BY FIELD(id, 404554,103845,130885,408078,412927,414188 )
494 0.0003 0.00031495094299316
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
495 0.0002 0.00022721290588379
SELECT * FROM product_image_select WHERE product_id = '404554'
496 0.0001 0.0001370906829834
SELECT * FROM productcustomimages WHERE product_id = '404554'
497 0.0034 0.0034239292144775
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
498 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
499 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
500 0.0005 0.00047588348388672
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
501 0.0001 0.00013399124145508
UPDATE products SET price = '399999' WHERE id = '404554'
502 0.0002 0.00021219253540039
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
503 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '103845'
504 0.0001 0.00013184547424316
SELECT * FROM productcustomimages WHERE product_id = '103845'
505 0.0024 0.002418041229248
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
506 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
507 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
508 0.0004 0.00039887428283691
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
509 0.0001 0.00013089179992676
UPDATE products SET price = '14499' WHERE id = '103845'
510 0.0002 0.00020909309387207
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
511 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '130885'
512 0.0001 0.00014400482177734
SELECT * FROM productcustomimages WHERE product_id = '130885'
513 0.0020 0.002004861831665
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
514 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
515 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
516 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
517 0.0001 0.00013184547424316
UPDATE products SET price = '1521' WHERE id = '130885'
518 0.0002 0.00021886825561523
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
519 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '408078'
520 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '408078'
521 0.0031 0.0031108856201172
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
522 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
523 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
524 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
525 0.0001 0.00014710426330566
UPDATE products SET price = '23352' WHERE id = '408078'
526 0.0003 0.0002739429473877
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
527 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '412927'
528 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '412927'
529 0.0037 0.0036778450012207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
530 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
531 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
532 0.0005 0.00045895576477051
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
533 0.0001 0.00013399124145508
UPDATE products SET price = '199900' WHERE id = '412927'
534 0.0003 0.00028204917907715
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
535 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '414188'
536 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '414188'
537 0.0026 0.0025851726531982
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
538 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
539 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
540 0.0004 0.00039792060852051
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
541 0.0001 0.00013899803161621
UPDATE products SET price = '9999' WHERE id = '414188'
542 0.1045 0.10448813438416
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.00025105476379395
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:1560876759;s:8:\"products\";a:6:{i:7;s:6:\"404554\";i:8;s:6:\"412927\";i:12;s:6:\"103845\";i:14;s:6:\"403517\";i:15;s:6:\"414825\";i:22;s:6:\"131163\";}}' WHERE id = '183'
544 0.0005 0.0004730224609375
SELECT * FROM products WHERE id IN (404554,412927,103845,403517,414825,131163) ORDER BY FIELD(id, 404554,412927,103845,403517,414825,131163 )
545 0.0003 0.00030398368835449
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
546 0.0002 0.00024008750915527
SELECT * FROM product_image_select WHERE product_id = '404554'
547 0.0001 0.00013899803161621
SELECT * FROM productcustomimages WHERE product_id = '404554'
548 0.0034 0.00341796875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
549 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
550 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
551 0.0005 0.00046682357788086
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
552 0.0001 0.00013399124145508
UPDATE products SET price = '399999' WHERE id = '404554'
553 0.0003 0.00028300285339355
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
554 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '412927'
555 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '412927'
556 0.0037 0.0036559104919434
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
557 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
558 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
559 0.0005 0.00047206878662109
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
560 0.0001 0.00013303756713867
UPDATE products SET price = '199900' WHERE id = '412927'
561 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
562 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '103845'
563 0.0001 0.00014591217041016
SELECT * FROM productcustomimages WHERE product_id = '103845'
564 0.0024 0.0024120807647705
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
565 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
566 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
567 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
568 0.0001 0.00012993812561035
UPDATE products SET price = '14499' WHERE id = '103845'
569 0.0003 0.00027298927307129
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
570 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '403517'
571 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '403517'
572 0.0030 0.0029549598693848
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
573 0.0002 0.00019121170043945
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
574 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
575 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
576 0.0001 0.00013089179992676
UPDATE products SET price = '6699' WHERE id = '403517'
577 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
578 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '414825'
579 0.0001 0.00014495849609375
SELECT * FROM productcustomimages WHERE product_id = '414825'
580 0.0020 0.0020020008087158
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
581 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
582 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
583 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
584 0.0001 0.00013208389282227
UPDATE products SET price = '11999' WHERE id = '414825'
585 0.0002 0.00023317337036133
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
586 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '131163'
587 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '131163'
588 0.0026 0.0025792121887207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
589 0.0002 0.00019478797912598
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
590 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
591 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
592 0.0001 0.00012993812561035
UPDATE products SET price = '20362' WHERE id = '131163'
593 0.0004 0.00042295455932617
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
594 0.0001 0.00014495849609375
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
595 0.0001 0.0001368522644043
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
596 0.0001 0.00013494491577148
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
597 0.0004 0.00042080879211426
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
598 0.0001 0.00013899803161621
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0001 0.00013494491577148
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0009 0.00091385841369629
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
601 0.0003 0.00033092498779297
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
602 0.0003 0.00029611587524414
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
603 0.0004 0.00036001205444336
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
604 0.0001 0.00014615058898926
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
605 0.0001 0.00014114379882812
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
606 0.0001 0.00013494491577148
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
607 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
608 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
609 0.0004 0.00036907196044922
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
610 0.0003 0.00034713745117188
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'