Tactical Equipment - Survivalist Equipment
   

Airsoft KWA ATP Auto Training Pistol

KWA ATP Gas Pistol Select Fire Airsoft pistol for sale online

UPDATED :  

It is the European distributor for KWA, which is no small task. KWA has been making high-end, quality gas-blowback pistols for many a year. Its patented NS2 gas delivery system represents a significant improvement in the power and efficiency of operation compared with other brands of pistols.

The combination of advanced, lightweight, composite gas piston and two-stage, internal expansion chamber means that gas is delivered to the chamber more effectively. This creates a crisp blowback action and reduces the cool-down effect. Over the last few years, KWA has also been the market leader with its Professional Training Pistol (PTP) range.

The Adaptive Training Pistol (ATP) on test here is a completely original design from KWA, and a new addition to the range. I will be looking at it from two angles: can it cut the mustard as a skirmish-ready airsoft pistol; and how does it compare as a training aide in this ever-expanding marketplace?

First impressions

Having been a fan of KWA pistols for a long time, I was intrigued by the ATP. There are two variants: the semi-auto version {on test here) and a (selectable) full-auto version. As with all KWA pistols, it comes in a sturdy but plain KWA branded box. The label on the side is the only indication of what lies within.

Interestingly, the label also features the unique serial number of the pistol. KWA states in its blurb that the ATP was developed in collaboration with various military and law enforcement agencies. Immediately on opening the box, the ATP looked striking, if a little odd.

The aluminium top slide is instantly recognisable as Glock-style, while the composite polymer lower frame has overtones of Glock and Smith & Wesson's M&P.

Picking it up, it feels lightweight but solid. Now personally I am not a big fan of Glocks, mainly due to the size of the pistol grip, which inhibits me from operating the pistol one-handed.

However, I was impressed with the grip on this ATP. For me, it's more comfortable, and with interchangeable back straps (included in the box), it should give you a good grip no matter the of size your hand.

Save

Save

The grip itself is textured and contoured; with your hand wrapped around it, it gives you the confidence that it won't slip out of your grip, whether you are wearing gloves or not. The trigger itself is identical to a Clock series pistol, and unless pulled properly, won't fire.

The magazine release catch is located on the front left-hand side of the pistol grip, just to the rear of the trigger guard: nice and easy to operate with your thumb. The slide release catch is easy to get to without having to move your hand away from the grip itself.

Moving forward of the trigger guard on the lower frame is a short multi-slot rail allowing you to mount various torch/laser units, or an accessory of some description. It is also on the underside of the lower frame that you will find the stamped unique serial number (which should match the one on the box label).

The top slide looks rather funky with the serrations cut into it at the front and rear (to ease cocking), but it keeps the simplicity of the hammerless Glock style design. Its three-dot combat sights keep things basic, but then, realistically, do you require any more than that?

Dropping the mag out and pulling the top slide to the rear with the slide-stop engaged allows you access to the adjustable hop unit. As with all KWA pistols, this is adjusted with a key (provided in the box) and is very simple to do.

The magazine itself is, again, very Glock-esque - it's double-stacking and holds 23 rounds. It also features a heavy-duty base plate, which you slide forward to gas the mag up.

In many real-world combat situations and training scenarios, mags get dumped or dropped onto the floor, but with a normal airsoft pistol mag this is not wise (we have an engineer's work-bench full of various mags which have been treated this way), so the rubberised base s help minimise damage.

Taking down the ATP for cleaning and maintenance is really simple. A quick pull-down of the release catches (located on both sides of the lower frame) allows the top slide to slide straight off. Internally, virtually all of the working parts (including the outer barrel) are aluminium and seem very robust.

One thing I was curious to find out was what holster the ATP would fit. After researching and reading up on the matter, it seems there are many on the market that the ATP will drop into.

Obviously, the ATP will slip in and out of any canvas-style, non-weapon-specific holster for medium frame pistols. For moulded holsters, this could be more difficult. Being so similar to the Glock in so many ways it should fit most Glock 17 holsters.

However, according to various US sites, the likes of G-Code's XST RTi, Razor Concealment Kydex for Smith & Wesson's M&P as well as OTG Spadex holsters are all capable of fitting the ATP. It will also come as a big relief to many that the ATP drops snugly into BlackHawk Serpa holsters for the Glock 17. Phew!

On test

With snow on the ground and the car computer saying zero degrees on my way into work, I thought to myself that this would be an interesting day. With most GBB pistols I wouldn't have bothered attempting to test with conditions being wha t they were, but with the reputation of the NS2 system, I felt confident about getting a good result. After a quick squirt of silicone spray in the relevant places, and a rough set of the hop unit, it was time to see if it's worthy of its Training Pistol moniker.

For the first round of testing, I used Blaster Devil 0.20g BBs and ASG Ultra gas. With the mag full (it's a big reservoir that took 30 seconds to fill) and the mag loaded up with 22 rounds, off I toddled to my test area. After racking back the topslide and loading the first round, I took aim and fired at my static target.

It has a nice trigger pull and, despite the conditions, it fired with a real crack. The top slide cycled with a hard kick and loaded the second round into the chamber; after a few rounds I started double tapping.

The ATP emptied the first mag faultlessly. With the last round fired, the top slide locked back to the rear as it should. Fantastic. I went back into the warm for a refill of gas, a reload of ammo and a quick adjustment of the hop unit.

I was keen to get back out into the cold as soon as possible (did I just say that?) so the mag didn't have chance to warm up too much. I wanted to see if the NS2 system is as good as its reputation says it is.

Okay, this time I wanted to see my fall of shot onto the target. With a mixture of single shot and double taps I soon emptied the second mag. It never missed a beat the entire time, and, upon inspecting my target (placed at 25ft), I found some really solid groupings.

I even amazed myself! Despite the hard recoil, the fact that I was firing using the combat sights, and how comfortable the ATP feels, the pistol never deviated from my point of aim. After another reload, it was time for a quick chrono check.

From start to finish, the ATP fired at 305fps, going down to 287fps by the end of the mag, which, bearing in mind the weather conditions and the fact that the hop was set, was a decent result.

My next task was to use some of my own advice, so I broke open a bottle of Blaster Devil 0.25g BBs, along with a bag of Madbull Precision Grade 0.30g. Using the same static target, first off I tried the Blaster Devils. After a mag of test shots to adjust the hop, I then carried out a mag's worth of chrono results, followed lastly by a mag of accurate shooting.

The difference in accuracy is quite phenomenal - in a good way - while the results on the chrono varied between 268 and 245 fps. I then repeated this process with the Madbulls. With this weight, the hop was pretty much adjusted to the max, but again, the accuracy over this range was another improvement with the groupings getting ever tighter. On the chrono, readings went from 240 to 227 fps. Still very respectable.

Being a bit of a diehard 1911 and Sig man in both airsoft and real steel, I really didn't want to like this pistol. If you are a Glock addict then you will no doubt love it. However, after a while, I really started to like the way it presents itself. Functionality and usability can be beautiful too!

Certainly for me, the massive bonus is in its ergonomics compared to a standard Glock. I like the way it feels in my hands, lightweight yet robust, and I love the way it operates with its crisp, sharp and hard recoil. With the weather conditions being what they were while testing, it still performed well and returned some decent results.

As an airsoft skirmish pistol it ranks way up there, and as a training aide it ticks all the boxes for durability, reliability and usability. With the bonus that it will fit issue holsters as well as personally purchased ones, it really does transgress from the airsoft market into real world training.

KWA has really hit the mark with this one and will help keep them among the higher echelons of GBB manufacturers. This pistol could well be the only pistol you ever need. Sorry Defiance Airsoft, this one may get lost in the post on its way back to you!

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.7074601650238 841 0.9278 0


No Amazon API Requests Made.


App Debug - Total Time 1.7074601650238 seconds

Number Time From Start Name Description
1 0.41797113418579 Initialise Initialise FSB Function
2 0.42654013633728 App Controller Start Start of the App controller (called before the controller of every page)
3 0.43772411346436 Start of getCategoryListByGroup Function Before first category groups query
4 0.43790817260742 After initial query Before first category groups query
5 0.43790912628174 Get Category List for Group Before the call to getCategoryList function
6 0.43791317939758 Start of GetCategoryList function Start of the function
7 0.43791604042053 Before getting categories Query to get specific category list
8 0.43847107887268 After getting categories Query to get specific category list
9 0.438472032547 Before getting category custom Before call to function getCategoryCustom
10 0.44031620025635 After getting category custom After call to function getCategoryCustom
11 0.44031810760498 Before getting category custom Before call to function getCategoryCustom
12 0.45088911056519 After getting category custom After call to function getCategoryCustom
13 0.45089221000671 Before getting category custom Before call to function getCategoryCustom
14 0.45645523071289 After getting category custom After call to function getCategoryCustom
15 0.45645809173584 Before getting category custom Before call to function getCategoryCustom
16 0.46055912971497 After getting category custom After call to function getCategoryCustom
17 0.4605610370636 End of GetCategoryList function End of the function
18 0.4605700969696 Get Category List for Group Before the call to getCategoryList function
19 0.46057200431824 Start of GetCategoryList function Start of the function
20 0.46057510375977 Before getting categories Query to get specific category list
21 0.46100616455078 After getting categories Query to get specific category list
22 0.4610071182251 Before getting category custom Before call to function getCategoryCustom
23 0.46652722358704 After getting category custom After call to function getCategoryCustom
24 0.46653008460999 Before getting category custom Before call to function getCategoryCustom
25 0.4771831035614 After getting category custom After call to function getCategoryCustom
26 0.47718501091003 End of GetCategoryList function End of the function
27 0.47719120979309 Get Category List for Group Before the call to getCategoryList function
28 0.47719407081604 Start of GetCategoryList function Start of the function
29 0.47719717025757 Before getting categories Query to get specific category list
30 0.47789907455444 After getting categories Query to get specific category list
31 0.47790002822876 Before getting category custom Before call to function getCategoryCustom
32 0.48704409599304 After getting category custom After call to function getCategoryCustom
33 0.48704719543457 Before getting category custom Before call to function getCategoryCustom
34 0.50440502166748 After getting category custom After call to function getCategoryCustom
35 0.50440812110901 Before getting category custom Before call to function getCategoryCustom
36 0.5102641582489 After getting category custom After call to function getCategoryCustom
37 0.51026701927185 Before getting category custom Before call to function getCategoryCustom
38 0.51611018180847 After getting category custom After call to function getCategoryCustom
39 0.5161120891571 Before getting category custom Before call to function getCategoryCustom
40 0.52234411239624 After getting category custom After call to function getCategoryCustom
41 0.52234721183777 Before getting category custom Before call to function getCategoryCustom
42 0.5442202091217 After getting category custom After call to function getCategoryCustom
43 0.54422402381897 Before getting category custom Before call to function getCategoryCustom
44 0.54829120635986 After getting category custom After call to function getCategoryCustom
45 0.5482931137085 Before getting category custom Before call to function getCategoryCustom
46 0.55286407470703 After getting category custom After call to function getCategoryCustom
47 0.55286622047424 End of GetCategoryList function End of the function
48 0.55288004875183 Get Category List for Group Before the call to getCategoryList function
49 0.55288314819336 Start of GetCategoryList function Start of the function
50 0.55288600921631 Before getting categories Query to get specific category list
51 0.55329704284668 After getting categories Query to get specific category list
52 0.55329823493958 Before getting category custom Before call to function getCategoryCustom
53 0.55556702613831 After getting category custom After call to function getCategoryCustom
54 0.55556917190552 Before getting category custom Before call to function getCategoryCustom
55 0.55789518356323 After getting category custom After call to function getCategoryCustom
56 0.55789709091187 End of GetCategoryList function End of the function
57 0.55790305137634 Get Category List for Group Before the call to getCategoryList function
58 0.55790519714355 Start of GetCategoryList function Start of the function
59 0.5579080581665 Before getting categories Query to get specific category list
60 0.55822014808655 After getting categories Query to get specific category list
61 0.55822110176086 Before getting category custom Before call to function getCategoryCustom
62 0.56317400932312 After getting category custom After call to function getCategoryCustom
63 0.56317615509033 End of GetCategoryList function End of the function
64 0.56318211555481 End of getCategoryListByGroup Function Before return()
65 0.6125590801239 App Controller End End of the App controller (called before the controller of every page)
66 1.0309672355652 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 1.0310380458832 Before Get Options Before the call to getOptions in the tpl class
68 1.4103491306305 After Get Options After the call to getOptions in the tpl class
69 1.4103991985321 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.7074382305145 Finalizing debug Before the debug is output to the page.
71 1.7074551582336 End of App This is the end of the app logging, final timestamp


Query Debug - 841 Database Queries. Total time 0.9278 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016498565673828
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00043892860412598
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00016999244689941
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00014209747314453
SELECT * FROM `bad_bots`
5 0.0005 0.00045609474182129
SELECT parameter, value FROM parameters
6 0.0002 0.00016117095947266
SET time_zone = 'Europe/London'
7 0.0003 0.00028800964355469
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014805793762207
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010895729064941
delete from cachefiles
10 0.0002 0.0002448558807373
SELECT id FROM pages WHERE pagename = 'airsoft-kwa-atp-auto-training-pistol' LIMIT 1
11 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = 425
12 0.0008 0.00079107284545898
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0094 0.009364128112793
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00027704238891602
SELECT * FROM pages WHERE pagename = 'airsoft-kwa-atp-auto-training-pistol'
15 0.0002 0.0001680850982666
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00051593780517578
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00048708915710449
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.00022387504577637
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.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 (49)
				  AND p.disabled = 0 
21 0.0002 0.0001521110534668
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.00301194190979
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.00025200843811035
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00021219253540039
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00019979476928711
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0057270526885986
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.00017094612121582
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.00015497207641602
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.00017118453979492
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.0001370906829834
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.002310037612915
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.00025606155395508
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0023281574249268
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.0001 0.00014805793762207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
39 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 (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
40 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
42 0.0012 0.0011558532714844
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.00025701522827148
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '101'
45 0.0018 0.0017890930175781
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.0001518726348877
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.00014805793762207
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.00017094612121582
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.00040817260742188
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0023097991943359
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.00024294853210449
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.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 (30)
				  AND p.disabled = 0 
55 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 (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
56 0.0002 0.00017189979553223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.0001227855682373
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.0048389434814453
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.0049 0.0048549175262451
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.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 (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
65 0.0006 0.0006401538848877
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.0040919780731201
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.00025677680969238
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0041029453277588
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.00015497207641602
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.00014901161193848
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.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '10'
73 0.0082 0.0081789493560791
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.00027799606323242
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.0081889629364014
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.00017309188842773
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.00014996528625488
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.00017118453979492
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
80 0.0025 0.0024528503417969
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.00026082992553711
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024621486663818
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.00014710426330566
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.00015592575073242
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024349689483643
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.00026702880859375
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.002453088760376
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.0001521110534668
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.00017380714416504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012588500976562
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.00025415420532227
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0028262138366699
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.00016617774963379
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.00014996528625488
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.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
102 0.0095 0.0095069408416748
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.00029301643371582
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '130'
109 0.0103 0.010263919830322
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.00017499923706055
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.00016498565673828
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.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
114 0.0016 0.0015521049499512
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.00025415420532227
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.001572847366333
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.00014901161193848
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.00014710426330566
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.0001227855682373
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.0018079280853271
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.0002 0.00024819374084473
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0018348693847656
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.00014805793762207
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.00014400482177734
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.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00013208389282227
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00038599967956543
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00067591667175293
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.0002281665802002
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00069093704223633
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.00014400482177734
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.0001 0.00014400482177734
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.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00069308280944824
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.00022792816162109
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00072908401489258
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.00014495849609375
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.00014495849609375
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.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00029802322387695
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0020148754119873
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.0002 0.00023818016052246
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020239353179932
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.00014591217041016
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.00015902519226074
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '20'
151 0.0052 0.0051901340484619
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00036787986755371
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00018906593322754
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015807151794434
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '135'
162 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '401'
169 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '457'
172 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.0001518726348877
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0002 0.00023484230041504
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '336'
225 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '423'
238 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.0001378059387207
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014495849609375
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '145'
250 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '316'
255 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '367'
258 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '387'
259 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016999244689941
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '95'
267 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '138'
272 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00019288063049316
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00020289421081543
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '343'
282 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '349'
287 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '393'
290 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '293'
308 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00013995170593262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '288'
314 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '299'
315 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.0001370906829834
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0002 0.00022196769714355
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '260'
328 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00016307830810547
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '115'
334 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '199'
338 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '444'
348 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '455'
353 0.0003 0.00027108192443848
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014996528625488
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00012683868408203
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0013828277587891
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0003 0.0002748966217041
SELECT * FROM pages WHERE pagename = 'airsoft-kwa-atp-auto-training-pistol'
373 0.0003 0.00026988983154297
SELECT * FROM products WHERE id = '410406'
374 0.0002 0.00018191337585449
SELECT * FROM productimages WHERE product_id = '410406' ORDER BY sortorder ASC
375 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '410406'
376 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '410406'
377 0.0033 0.0033280849456787
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410406' AND a.name = n.originalname
378 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '410406' AND merchantid = 'ATVPDKIKX0DER'
379 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '410406' AND price > 0
                ORDER BY price ASC LIMIT 1
380 0.0004 0.00037288665771484
SELECT value FROM productattributes WHERE product_id = '410406' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
381 0.0001 0.00013399124145508
UPDATE products SET price = '14995' WHERE id = '410406'
382 0.0003 0.00030612945556641
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '410406' ORDER BY timestamp DESC
383 0.0002 0.0001671314239502
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
384 0.0002 0.00017285346984863
INSERT INTO ga_users (`ips`) SELECT 'a:1:{i:0;s:12:\"52.91.39.106\";}'
385 0.0001 0.0001368522644043
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1560832718'
386 0.0001 0.00013208389282227
INSERT INTO tracker_action (`gauser_id`, `gasession_id`, `action`, `notes`, `timestamp`) SELECT '139440', '140375', 'basket_view', '', '1560832718'
387 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = 2
388 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = 4
389 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 12
390 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 10
391 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 7
392 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = 18
393 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 28
394 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = 13
395 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = 3
396 0.0337 0.033726930618286
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
397 0.0002 0.00022411346435547
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:1560832719;s:8:\"products\";a:6:{i:4;s:6:\"171938\";i:5;s:6:\"404554\";i:1;s:6:\"398315\";i:2;s:6:\"407595\";i:7;s:6:\"409759\";i:8;s:6:\"408792\";}}' WHERE id = '175'
398 0.0004 0.00043916702270508
SELECT * FROM products WHERE id IN (171938,404554,398315,407595,409759,408792) ORDER BY FIELD(id, 171938,404554,398315,407595,409759,408792 )
399 0.0006 0.00064182281494141
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
400 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '171938'
401 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '171938'
402 0.0026 0.002554178237915
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
403 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
404 0.0002 0.00022578239440918
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
405 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
406 0.0001 0.0001218318939209
UPDATE products SET price = '389500' WHERE id = '171938'
407 0.0003 0.00027012825012207
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
408 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '404554'
409 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '404554'
410 0.0034 0.0033690929412842
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
411 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
412 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
413 0.0004 0.00044488906860352
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
414 0.0001 0.00011777877807617
UPDATE products SET price = '399999' WHERE id = '404554'
415 0.0002 0.0002140998840332
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
416 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '398315'
417 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '398315'
418 0.0025 0.0024759769439697
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
419 0.0002 0.00019121170043945
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
420 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
421 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
422 0.0001 0.00012111663818359
UPDATE products SET price = '1999' WHERE id = '398315'
423 0.0002 0.00024199485778809
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
424 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '407595'
425 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '407595'
426 0.0034 0.0033581256866455
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
427 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
428 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
429 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
430 0.0001 0.00011897087097168
UPDATE products SET price = '2497' WHERE id = '407595'
431 0.0002 0.00023484230041504
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
432 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '409759'
433 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '409759'
434 0.0028 0.0028209686279297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
435 0.0002 0.00018620491027832
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
436 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
437 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
438 0.0001 0.00012302398681641
UPDATE products SET price = '229000' WHERE id = '409759'
439 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
440 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '408792'
441 0.0001 0.00012779235839844
SELECT * FROM productcustomimages WHERE product_id = '408792'
442 0.0036 0.0035848617553711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
443 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
444 0.0002 0.00020480155944824
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
445 0.0004 0.00043487548828125
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
446 0.0001 0.00011897087097168
UPDATE products SET price = '13499' WHERE id = '408792'
447 0.0334 0.03339695930481
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
448 0.0002 0.00020503997802734
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:1560832719;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:8;s:6:\"408792\";i:9;s:6:\"103845\";i:14;s:6:\"406758\";i:17;s:6:\"405644\";i:18;s:6:\"131163\";}}' WHERE id = '177'
449 0.0004 0.0004119873046875
SELECT * FROM products WHERE id IN (398315,408792,103845,406758,405644,131163) ORDER BY FIELD(id, 398315,408792,103845,406758,405644,131163 )
450 0.0002 0.00022196769714355
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
451 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '398315'
452 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '398315'
453 0.0025 0.002514123916626
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
454 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
455 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
456 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
457 0.0001 0.00013303756713867
UPDATE products SET price = '1999' WHERE id = '398315'
458 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
459 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '408792'
460 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408792'
461 0.0036 0.003593921661377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
462 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
463 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
464 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
465 0.0001 0.00011897087097168
UPDATE products SET price = '13499' WHERE id = '408792'
466 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
467 0.0002 0.00021076202392578
SELECT * FROM product_image_select WHERE product_id = '103845'
468 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '103845'
469 0.0024 0.0024130344390869
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
470 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
471 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
472 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
473 0.0001 0.00011682510375977
UPDATE products SET price = '14499' WHERE id = '103845'
474 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
475 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '406758'
476 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '406758'
477 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
478 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
479 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
480 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
481 0.0001 0.00011897087097168
UPDATE products SET price = '2694' WHERE id = '406758'
482 0.0002 0.00018477439880371
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
483 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '405644'
484 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '405644'
485 0.0034 0.0033540725708008
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
486 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
487 0.0002 0.00020790100097656
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
488 0.0004 0.0004270076751709
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
489 0.0001 0.00011897087097168
UPDATE products SET price = '63539' WHERE id = '405644'
490 0.0002 0.00022101402282715
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
491 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '131163'
492 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '131163'
493 0.0025 0.002547025680542
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
494 0.0002 0.00021600723266602
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
495 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
496 0.0004 0.00038385391235352
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
497 0.0001 0.00011801719665527
UPDATE products SET price = '20362' WHERE id = '131163'
498 0.0951 0.09507417678833
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
499 0.0002 0.00024604797363281
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"categories\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560832719;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:2;s:6:\"407595\";i:6;s:6:\"412927\";i:8;s:6:\"408792\";i:19;s:6:\"410949\";i:22;s:6:\"400044\";}}' WHERE id = '181'
500 0.0004 0.00043702125549316
SELECT * FROM products WHERE id IN (414940,407595,412927,408792,410949,400044) ORDER BY FIELD(id, 414940,407595,412927,408792,410949,400044 )
501 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
502 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '414940'
503 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '414940'
504 0.0032 0.0032429695129395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
505 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
506 0.0002 0.0002288818359375
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
507 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
508 0.0001 0.00012111663818359
UPDATE products SET price = '4490' WHERE id = '414940'
509 0.0002 0.00023603439331055
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
510 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '407595'
511 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '407595'
512 0.0034 0.0033581256866455
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
513 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
514 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
515 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
516 0.0001 0.00011897087097168
UPDATE products SET price = '2497' WHERE id = '407595'
517 0.0003 0.00027084350585938
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
518 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '412927'
519 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '412927'
520 0.0036 0.0035948753356934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
521 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
522 0.0002 0.00019478797912598
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
523 0.0005 0.00046110153198242
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
524 0.0001 0.00012087821960449
UPDATE products SET price = '199900' WHERE id = '412927'
525 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
526 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '408792'
527 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '408792'
528 0.0036 0.003572940826416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
529 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
530 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
531 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
532 0.0001 0.00011801719665527
UPDATE products SET price = '13499' WHERE id = '408792'
533 0.0002 0.00016880035400391
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
534 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '410949'
535 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '410949'
536 0.0027 0.002701997756958
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
537 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
538 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
539 0.0004 0.00038814544677734
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
540 0.0001 0.00011801719665527
UPDATE products SET price = '47995' WHERE id = '410949'
541 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
542 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '400044'
543 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '400044'
544 0.0028 0.002830982208252
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
545 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
546 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
547 0.0004 0.00042080879211426
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
548 0.0001 0.00011992454528809
UPDATE products SET price = '16091' WHERE id = '400044'
549 0.0946 0.09455394744873
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
550 0.0003 0.00025606155395508
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:1560832719;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:2;s:6:\"407595\";i:8;s:6:\"408792\";i:11;s:6:\"403517\";i:15;s:6:\"130885\";i:21;s:6:\"406901\";}}' WHERE id = '183'
551 0.0004 0.00044894218444824
SELECT * FROM products WHERE id IN (398315,407595,408792,403517,130885,406901) ORDER BY FIELD(id, 398315,407595,408792,403517,130885,406901 )
552 0.0002 0.00021815299987793
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
553 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '398315'
554 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '398315'
555 0.0025 0.0025038719177246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
556 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
557 0.0002 0.00020313262939453
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
558 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
559 0.0001 0.0001220703125
UPDATE products SET price = '1999' WHERE id = '398315'
560 0.0002 0.00023698806762695
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
561 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '407595'
562 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '407595'
563 0.0033 0.0033268928527832
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
564 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
565 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
566 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
567 0.0001 0.00011897087097168
UPDATE products SET price = '2497' WHERE id = '407595'
568 0.0002 0.00021004676818848
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
569 0.0002 0.00020122528076172
SELECT * FROM product_image_select WHERE product_id = '408792'
570 0.0001 0.00011801719665527
SELECT * FROM productcustomimages WHERE product_id = '408792'
571 0.0036 0.0035951137542725
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
572 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
573 0.0002 0.00019478797912598
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
574 0.0004 0.00044488906860352
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
575 0.0001 0.00011801719665527
UPDATE products SET price = '13499' WHERE id = '408792'
576 0.0003 0.00025701522827148
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
577 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '403517'
578 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '403517'
579 0.0029 0.0029230117797852
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
580 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
581 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
582 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
583 0.0001 0.00011801719665527
UPDATE products SET price = '6699' WHERE id = '403517'
584 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
585 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '130885'
586 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '130885'
587 0.0020 0.0019690990447998
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
588 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
589 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
590 0.0004 0.00036096572875977
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
591 0.0001 0.00011777877807617
UPDATE products SET price = '1521' WHERE id = '130885'
592 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
593 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '406901'
594 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '406901'
595 0.0023 0.0023341178894043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
596 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
597 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
598 0.0003 0.00034594535827637
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
599 0.0001 0.0001220703125
UPDATE products SET price = '395' WHERE id = '406901'
600 0.0004 0.0003969669342041
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
601 0.0001 0.00014281272888184
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.00012397766113281
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
604 0.0004 0.00039196014404297
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
605 0.0001 0.00014090538024902
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
606 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
607 0.0009 0.00091004371643066
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
608 0.0003 0.00029897689819336
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
609 0.0003 0.00028896331787109
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
610 0.0003 0.00025391578674316
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
611 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = 2
612 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 4
613 0.0001 0.00013518333435059
SELECT * FROM pages WHERE id = 12
614 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 10
615 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = 7
616 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = 18
617 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 28
618 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = 13
619 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 3
620 0.0338 0.033792018890381
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
621 0.0002 0.00022292137145996
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:1560832719;s:8:\"products\";a:6:{i:6;s:6:\"412927\";i:7;s:6:\"409759\";i:8;s:6:\"408792\";i:16;s:6:\"408078\";i:20;s:6:\"408079\";i:21;s:6:\"406901\";}}' WHERE id = '175'
622 0.0005 0.00046396255493164
SELECT * FROM products WHERE id IN (412927,409759,408792,408078,408079,406901) ORDER BY FIELD(id, 412927,409759,408792,408078,408079,406901 )
623 0.0003 0.0002739429473877
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
624 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '412927'
625 0.0001 0.00014209747314453
SELECT * FROM productcustomimages WHERE product_id = '412927'
626 0.0036 0.0036420822143555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
627 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
628 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
629 0.0005 0.00046086311340332
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
630 0.0001 0.00012302398681641
UPDATE products SET price = '199900' WHERE id = '412927'
631 0.0002 0.00022411346435547
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
632 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '409759'
633 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '409759'
634 0.0028 0.0028188228607178
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
635 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
636 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
637 0.0004 0.00040793418884277
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
638 0.0001 0.0001220703125
UPDATE products SET price = '229000' WHERE id = '409759'
639 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
640 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '408792'
641 0.0001 0.0001227855682373
SELECT * FROM productcustomimages WHERE product_id = '408792'
642 0.0036 0.0035698413848877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
643 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
644 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
645 0.0004 0.00044012069702148
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
646 0.0001 0.00011801719665527
UPDATE products SET price = '13499' WHERE id = '408792'
647 0.0002 0.00020503997802734
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
648 0.0003 0.00026106834411621
SELECT * FROM product_image_select WHERE product_id = '408078'
649 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '408078'
650 0.0031 0.0030579566955566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
651 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
652 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
653 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
654 0.0001 0.0001220703125
UPDATE products SET price = '23352' WHERE id = '408078'
655 0.0002 0.00017499923706055
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
656 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '408079'
657 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408079'
658 0.0032 0.003183126449585
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
659 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
660 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
661 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
662 0.0001 0.00012087821960449
UPDATE products SET price = '18547' WHERE id = '408079'
663 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
664 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '406901'
665 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '406901'
666 0.0023 0.0023090839385986
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
667 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
668 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
669 0.0003 0.0003359317779541
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
670 0.0001 0.00013089179992676
UPDATE products SET price = '395' WHERE id = '406901'
671 0.0333 0.03328800201416
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
672 0.0002 0.00021886825561523
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:1560832719;s:8:\"products\";a:6:{i:1;s:6:\"398315\";i:3;s:6:\"290575\";i:19;s:6:\"410949\";i:22;s:6:\"400044\";i:6;s:6:\"412927\";i:11;s:6:\"403517\";}}' WHERE id = '177'
673 0.0004 0.00042915344238281
SELECT * FROM products WHERE id IN (398315,290575,410949,400044,412927,403517) ORDER BY FIELD(id, 398315,290575,410949,400044,412927,403517 )
674 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
675 0.0002 0.00021219253540039
SELECT * FROM product_image_select WHERE product_id = '398315'
676 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '398315'
677 0.0025 0.0024960041046143
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
678 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
679 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
680 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
681 0.0001 0.0001220703125
UPDATE products SET price = '1999' WHERE id = '398315'
682 0.0006 0.00057101249694824
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
683 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '290575'
684 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '290575'
685 0.0034 0.0033769607543945
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
686 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
687 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
688 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
689 0.0001 0.00012707710266113
UPDATE products SET price = '549500' WHERE id = '290575'
690 0.0002 0.00017404556274414
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
691 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '410949'
692 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '410949'
693 0.0027 0.0027010440826416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
694 0.0002 0.00018620491027832
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
695 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
696 0.0004 0.00040078163146973
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
697 0.0001 0.00011801719665527
UPDATE products SET price = '47995' WHERE id = '410949'
698 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
699 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '400044'
700 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '400044'
701 0.0028 0.0027799606323242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
702 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
703 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
704 0.0005 0.0004880428314209
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
705 0.0001 0.0001378059387207
UPDATE products SET price = '16091' WHERE id = '400044'
706 0.0003 0.00032687187194824
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
707 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '412927'
708 0.0001 0.00011706352233887
SELECT * FROM productcustomimages WHERE product_id = '412927'
709 0.0037 0.0036890506744385
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
710 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
711 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
712 0.0005 0.00045490264892578
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
713 0.0001 0.00013089179992676
UPDATE products SET price = '199900' WHERE id = '412927'
714 0.0003 0.00026416778564453
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
715 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '403517'
716 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '403517'
717 0.0030 0.0029900074005127
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
718 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
719 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
720 0.0004 0.00044512748718262
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
721 0.0001 0.00013399124145508
UPDATE products SET price = '6699' WHERE id = '403517'
722 0.0960 0.096001863479614
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
723 0.0002 0.0002281665802002
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"categories\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560832719;s:8:\"products\";a:6:{i:7;s:6:\"409759\";i:12;s:6:\"414825\";i:15;s:6:\"130885\";i:16;s:6:\"408078\";i:4;s:6:\"171938\";i:6;s:6:\"412927\";}}' WHERE id = '181'
724 0.0005 0.00046300888061523
SELECT * FROM products WHERE id IN (409759,414825,130885,408078,171938,412927) ORDER BY FIELD(id, 409759,414825,130885,408078,171938,412927 )
725 0.0002 0.00022387504577637
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
726 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '409759'
727 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '409759'
728 0.0028 0.0028131008148193
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
729 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
730 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
731 0.0004 0.00041913986206055
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
732 0.0001 0.00012898445129395
UPDATE products SET price = '229000' WHERE id = '409759'
733 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
734 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '414825'
735 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '414825'
736 0.0028 0.0028300285339355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
737 0.0002 0.00021100044250488
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
738 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
739 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
740 0.0001 0.00013113021850586
UPDATE products SET price = '11999' WHERE id = '414825'
741 0.0002 0.00019311904907227
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
742 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '130885'
743 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '130885'
744 0.0020 0.0019838809967041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
745 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
746 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
747 0.0004 0.00035285949707031
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
748 0.0001 0.00012493133544922
UPDATE products SET price = '1521' WHERE id = '130885'
749 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
750 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '408078'
751 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '408078'
752 0.0031 0.0030920505523682
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
753 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
754 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
755 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
756 0.0001 0.00012087821960449
UPDATE products SET price = '23352' WHERE id = '408078'
757 0.0006 0.00060892105102539
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
758 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '171938'
759 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '171938'
760 0.0025 0.0025379657745361
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
761 0.0002 0.00018882751464844
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
762 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
763 0.0004 0.00039982795715332
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
764 0.0001 0.00011992454528809
UPDATE products SET price = '389500' WHERE id = '171938'
765 0.0003 0.00025510787963867
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
766 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '412927'
767 0.0002 0.00019311904907227
SELECT * FROM productcustomimages WHERE product_id = '412927'
768 0.0036 0.0036211013793945
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
769 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
770 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
771 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
772 0.0001 0.00011897087097168
UPDATE products SET price = '199900' WHERE id = '412927'
773 0.0954 0.095350027084351
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
774 0.0002 0.00024104118347168
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:1560832719;s:8:\"products\";a:6:{i:4;s:6:\"171938\";i:5;s:6:\"404554\";i:10;s:6:\"370121\";i:21;s:6:\"406901\";i:23;s:5:\"43519\";i:14;s:6:\"406758\";}}' WHERE id = '183'
775 0.0005 0.00046801567077637
SELECT * FROM products WHERE id IN (171938,404554,370121,406901,43519,406758) ORDER BY FIELD(id, 171938,404554,370121,406901,43519,406758 )
776 0.0006 0.00061202049255371
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
777 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '171938'
778 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '171938'
779 0.0025 0.002540111541748
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
780 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
781 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
782 0.0004 0.00038385391235352
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
783 0.0001 0.0001220703125
UPDATE products SET price = '389500' WHERE id = '171938'
784 0.0003 0.0002741813659668
SELECT * FROM productimages WHERE product_id = '404554' ORDER BY sortorder ASC
785 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '404554'
786 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '404554'
787 0.0033 0.0033280849456787
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404554' AND a.name = n.originalname
788 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '404554' AND merchantid = 'ATVPDKIKX0DER'
789 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '404554' AND price > 0
                ORDER BY price ASC LIMIT 1
790 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '404554' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
791 0.0001 0.00012683868408203
UPDATE products SET price = '399999' WHERE id = '404554'
792 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
793 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '370121'
794 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '370121'
795 0.0028 0.0027680397033691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
796 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
797 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
798 0.0004 0.00039505958557129
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
799 0.0001 0.00011801719665527
UPDATE products SET price = '9899' WHERE id = '370121'
800 0.0002 0.00019383430480957
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
801 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '406901'
802 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '406901'
803 0.0023 0.0023148059844971
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
804 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
805 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
806 0.0003 0.00034809112548828
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
807 0.0001 0.00012087821960449
UPDATE products SET price = '395' WHERE id = '406901'
808 0.0002 0.00018310546875
SELECT * FROM productimages WHERE product_id = '43519' ORDER BY sortorder ASC
809 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '43519'
810 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '43519'
811 0.0027 0.0026581287384033
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '43519' AND a.name = n.originalname
812 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '43519' AND merchantid = 'ATVPDKIKX0DER'
813 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '43519' AND price > 0
                ORDER BY price ASC LIMIT 1
814 0.0003 0.0003199577331543
SELECT value FROM productattributes WHERE product_id = '43519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
815 0.0001 0.00011992454528809
UPDATE products SET price = '1330' WHERE id = '43519'
816 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
817 0.0002 0.00020313262939453
SELECT * FROM product_image_select WHERE product_id = '406758'
818 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '406758'
819 0.0026 0.0025689601898193
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
820 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
821 0.0002 0.00020813941955566
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
822 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
823 0.0001 0.00011992454528809
UPDATE products SET price = '2694' WHERE id = '406758'
824 0.0004 0.00041007995605469
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
825 0.0001 0.00014114379882812
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
826 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
827 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
828 0.0004 0.00040888786315918
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
829 0.0001 0.00012683868408203
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
830 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
831 0.0009 0.00090408325195312
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
832 0.0003 0.00031304359436035
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
833 0.0003 0.00028514862060547
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
834 0.0004 0.0003511905670166
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
835 0.0001 0.00013279914855957
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
836 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
837 0.0001 0.00012111663818359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
838 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
839 0.0001 0.00012016296386719
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
840 0.0004 0.00038409233093262
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
841 0.0003 0.00031399726867676
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'