Tactical Equipment - Survivalist Equipment
   

LED Tactical Flashlight Reviews

Best tactical rechargeable flashlight reviews buying guide

UPDATED :  


A selection of tactical LED flashlight reviews to assist you in choosing the right flashlight for your particular tactical purpose.


BRITE-STRIKE DUTY LIGHT CAMERA

Bright Strike Duty Light Camera Flashlight

Brite-Strike Technologies® is an innovator of tactical lighting solutions and tools for police, military and civilian operators. Brite-Strike now offers the Duty Light Camera (DLC).

Brite Strike Flashlight

The DLC was designed to meet the modern and unique demands of both the police and military. Now Brite Strike has become the tactical LED flashlight choice of many professionals and security agencies. The compact (weighing approximately 12.3 ounces and measuring 7.5 inches long) rechargeable duty light with built-in video recorder and audio provides the ideal light and video resolution needed to capture engagement while providing light on the subject. The Brite Strike DLC 200 Flashlight video recorder holds up to six hours of recordings.

DLC 200 HLS Rechargable LED Flashlight

The DLC LED flashlight has High, Low, and Strobe settings. Recharge the lithium battery with the included 12-volt vehicle charger. Inside the body of the DLC LED tactical flashlight sits a vibration-isolated microphone for clear audio recording. A removable rubber cap covers the microphone when not in use, keeping dust and water out. Optional colored flashlight lenses are available for the DLC and sold separately. There is also a belt mount (ROTO-LOC Holster) for the LED flashlight allowing hands free operation, much like the police sholder mounted cameras (body worn cameras), but the benefit of having the bright light far enough from your face as to not disctract concentration. Suggested retail price of the Brite Strike DLC 200 Flashlight is $500.


  View All BRITE-STRIKE DUTY models: View All Available Brite Strike Flashlights


Lightforce PRED-3X Firearm Mounted Compact LED Light

Discount Lightforce PRED-3X LED Weapon Mounted Flashlight Sale

Lightforce have recently released a new, compact mini-spotlight system which will quickly and simply attach to a rifle or shotgun for night hunters, that doesn't require any leads or a separate battery packto operate. Referred to as the PRED-3X its extremely lightweight and made of high grade 6061 aluminium. Featuring a toughened, ultra-clear glass lens and specially treated aluminium reflector for focused beam and maximum light transmission, it offers a 220 Lumen LED with 50,000 hours life span via 2 x rechargeable batteries housed within the unit. This light has been fitted with authentic CREE chips Color Rendering Index (CRI), chosen for its ability to produce a neutral, white light, resulting in superior target acquisition and colour definition.

Lightforce PRED-3X LED Flashlight

I'm told the two fully charged batteries will provide up to 90 minutes of maximum light intensity, while the unit will also operate using only a single battery for reduced operating time. The Pred3X can also be connected to an external power source via the USB cable provided for extended periods. This cable also acts as a charging unit when the batteries require recharging via any 5 volt supply like a mobile phone charger or computer. The centre of the on/off switch actually features an indicator which turns red when the batteries are being charged and once fully charged the light simply goes out. Re-charging time is approximately 3 hours. To fit the Pred3X to a rifle, the unit comes complete with a quick release mechanism that attaches to a supplied scope ring via Picatinny/Weaver attachment.

Lightforce PRED3X Firearm Mounted LED Light Sale

Best Price Scopes

  Ready To Purchase: Buy Now

  Read User Reviews: Not Available

  View All LightForce models: View All Available LightForce Flashlights

 

LED Lenser P7 Flashlight Buy Cheap

LED LENSER P7 TACTICAL TORCH

Previously we have reviewed and tested several Led Lenser torches with excellent results.

Well here's another new model that promises to outshine any light of its size. The Led Lenser P7 Tactical is equipped with an advanced focussing system that is unique to Led Lenser. The P7 Tactical offers a circular floodlight or a sharply focused spot beam with a range of up to 200 meters I'm told. It's simple three-step cycle switch function is designed for one-handed speed. Simply press for maximum light (130% - turbo mode), click for high light (100% - power mode) or click again for low light (15% - economy mode).

Designed in Germany, the P7 Tactical light comes with 200 lumens of light and it doesn't get much brighter than that. The torch also offers up to 120 hours of battery life via 4 x standard AAA batteries.

Made of high-grade aluminium body, the Led Lenser P7 Tactical is available in either black or titanium finish. Also included is a nylon pouch and well presented in a black, gift box.

Recommended retail is around $139.95.


  View All Lenser models and pricing: View All Available LED Lenser P7 Flashlights


 

 


NEW LED LENSER M3R FLASHLIGHT

New Lenser LED M3R flashlight

Introducing the M3R, a tiny rechargeable torch (weighing only 45g and less than 10 cm long) but big on brightness. With 220 lumens of light (more than the original LED Lenser P7!) and with a beam range of 130 metres, it produces a performance comparable to torches many times larger.

The M3R incorporates LED Lenser’s patented Advanced Focus System which allows seamless transition from floodlight to focused beam and also has Smart Light Technology with three light functions (high power, low power and defence strobe).

With easy recharging via USB and a low battery warning system, the M3R is technological dynamite in a compact package. For ultimate versatility, the M3R also operates on a standard AAA battery.


Buffalo River Model BRT61LED-12v Spotlight – a gamechanger...!

Buffalo River LED spotlight

IT’S NOT OFTEN YOU COME ACROSS A PRODUCT THAT REALLY DOES BREAK THE MOULD AND RENDER ALL OTHER SIMILAR PRODUCTS OBSOLETE OVERNIGHT, BUT THE CREE T6, MADE IN THE USA AND MARKETED BY BUFFALO RIVER AS THE BRT61, IS SUCH A PRODUCT.

When I was handed the new Buffalo River spotlight kit I asked if I could have battery to go with it. “You’re holding it!” I was told. And there it was, so discrete that I hadn’t noticed the small black box clipped to the end of the power cord.

The battery fits easily into a shirt pocket – you can put two of them into a jacket pocket.

Measuring just 110mm x 65mm x 25mm, the new lithium battery is about a quarter of the size of a standard spotlight battery, and wait for it – eight times lighter! The 12v motorcycle-type batteries I’ve been using ever since spotlights were invented weigh just over 2kg each, and I normally carry them in a bag hung over my shoulder, whereas the new Cree T6 weighs just 260 grams and fits comfortably into my shirt pocket. There’s no such thing as a free lunch, so I figured there had to be a drawback somewhere – maybe the battery had only enough power to run a good sized light for a couple of minutes, but on the box it proclaims, “2.5 hours of light between recharging”.

A standard battery weighs just over 2kg (4lb 7oz), while the new Cree weighs 260 grams (9.25oz).

I haven’t yet used it to the max, but on a hour-long possum hunting trip it showed no signs of running flat, and considering that the beam the 110mm diameter spotlight throws is tight, bright and strong for over 200 metres (the box says 300 metres, but you can’t expect two miracles in a row), I think this is outstanding performance. Not only is the new lithium battery extremely light and compact, it’s rechargeable as indicated above (a charger comes with the kit), and has one other very useful feature – a small LED display that reveals the battery’s state of charge.

The charger, and an attachment for mounting the hand-held light onto a scope.

Press a button at the end of the unit and the battery’s status is indicated. Five green lights means full charging, four green and one red means you’ve got 80% of charge left, and you can figure out the rest. The light that came with the kit was hand-held model with a pistol grip and an adaptor that allowed it to be clipped onto a scope.

The Cree battery, left, shown beside a standard motorcycle spotlight battery for comparison, has an LED display that indicates its charge status.

This set-up mounts the light very high above your rifle and is a bit cumbersome. I understand that other models and attachments are, or soon will be, available that make fitting the light onto your rifle more convenient.

TECH SPECS: BUFFALO RIVER BRT61
LENS DIAMETER 110MM
POWER 540 LUMENS
BATTERY 4.2V3.3AH LITHIUM RECHARGEABLE
RRP BATTERY PACK WITH CHARGER & POUCH $164.99 110MM CREE 540 LU 10 WATT LIGHT $79.99

LED Lenser P7QC Quattro Color one lashlight four colors


SEAL HIGH INTENSITY LED HUNTING TORCH

Wolf Eyes Seal reflector LED Flashlight

The Seal High Intensity LED torch looks exactly the same as the Seal Original, the only difference is where the Original is rated for 400 metres the High Intensity is good for 500 metres. Of course, a 500 metre light also provides more light when being used at 200 metres! So now there arc two versions of the Seal to suit different users needs.

The Seal High Intensity LED Hunting torch features a more focussed, de-domed LED which is able to project further through the large aspheric head - with the naked eye you can see it light up a white card at 500 metres! This LED isn't compatible with the small reflector head, so this version is for those who want the longest throwing hunting torch, small acreage or professional security torch or a search and rescue torch.

The Seal High Intensity will throw more light even when used at 150 metres or 200 metres, so if your eyes are a little older or prefer more light, the Seal High Intensity would be useful. Due to the tight and powerful beam the High Intensity is a remarkable long throwing torch and could be recommended for those who like long distance night hunting and want a rifle mounted LED torch.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
5.1916389465332 884 3.7411 0


No Amazon API Requests Made.


App Debug - Total Time 5.1916389465332 seconds

Number Time From Start Name Description
1 0.70561289787292 Initialise Initialise FSB Function
2 0.93131399154663 App Controller Start Start of the App controller (called before the controller of every page)
3 0.94261598587036 Start of getCategoryListByGroup Function Before first category groups query
4 0.94277882575989 After initial query Before first category groups query
5 0.9427809715271 Get Category List for Group Before the call to getCategoryList function
6 0.94278478622437 Start of GetCategoryList function Start of the function
7 0.94278788566589 Before getting categories Query to get specific category list
8 0.9433479309082 After getting categories Query to get specific category list
9 0.94334888458252 Before getting category custom Before call to function getCategoryCustom
10 0.94515085220337 After getting category custom After call to function getCategoryCustom
11 0.9451539516449 Before getting category custom Before call to function getCategoryCustom
12 0.95571494102478 After getting category custom After call to function getCategoryCustom
13 0.95571684837341 Before getting category custom Before call to function getCategoryCustom
14 0.96255493164062 After getting category custom After call to function getCategoryCustom
15 0.96255779266357 Before getting category custom Before call to function getCategoryCustom
16 0.96728992462158 After getting category custom After call to function getCategoryCustom
17 0.96729183197021 End of GetCategoryList function End of the function
18 0.96730399131775 Get Category List for Group Before the call to getCategoryList function
19 0.96730589866638 Start of GetCategoryList function Start of the function
20 0.96730899810791 Before getting categories Query to get specific category list
21 0.96777582168579 After getting categories Query to get specific category list
22 0.96777701377869 Before getting category custom Before call to function getCategoryCustom
23 0.97419595718384 After getting category custom After call to function getCategoryCustom
24 0.97419881820679 Before getting category custom Before call to function getCategoryCustom
25 0.98503184318542 After getting category custom After call to function getCategoryCustom
26 0.98503398895264 End of GetCategoryList function End of the function
27 0.98505878448486 Get Category List for Group Before the call to getCategoryList function
28 0.98506283760071 Start of GetCategoryList function Start of the function
29 0.98506593704224 Before getting categories Query to get specific category list
30 0.98583579063416 After getting categories Query to get specific category list
31 0.98583793640137 Before getting category custom Before call to function getCategoryCustom
32 1.0158438682556 After getting category custom After call to function getCategoryCustom
33 1.0158469676971 Before getting category custom Before call to function getCategoryCustom
34 1.0373718738556 After getting category custom After call to function getCategoryCustom
35 1.0373749732971 Before getting category custom Before call to function getCategoryCustom
36 1.0442879199982 After getting category custom After call to function getCategoryCustom
37 1.044291973114 Before getting category custom Before call to function getCategoryCustom
38 1.0613708496094 After getting category custom After call to function getCategoryCustom
39 1.0613739490509 Before getting category custom Before call to function getCategoryCustom
40 1.0935609340668 After getting category custom After call to function getCategoryCustom
41 1.0935637950897 Before getting category custom Before call to function getCategoryCustom
42 1.1686758995056 After getting category custom After call to function getCategoryCustom
43 1.1686799526215 Before getting category custom Before call to function getCategoryCustom
44 1.1742968559265 After getting category custom After call to function getCategoryCustom
45 1.174299955368 Before getting category custom Before call to function getCategoryCustom
46 1.1805019378662 After getting category custom After call to function getCategoryCustom
47 1.1805038452148 End of GetCategoryList function End of the function
48 1.1805198192596 Get Category List for Group Before the call to getCategoryList function
49 1.1805229187012 Start of GetCategoryList function Start of the function
50 1.1805260181427 Before getting categories Query to get specific category list
51 1.180969953537 After getting categories Query to get specific category list
52 1.1809718608856 Before getting category custom Before call to function getCategoryCustom
53 1.2023658752441 After getting category custom After call to function getCategoryCustom
54 1.2023689746857 Before getting category custom Before call to function getCategoryCustom
55 1.2051329612732 After getting category custom After call to function getCategoryCustom
56 1.2051348686218 End of GetCategoryList function End of the function
57 1.2051429748535 Get Category List for Group Before the call to getCategoryList function
58 1.2051448822021 Start of GetCategoryList function Start of the function
59 1.2051479816437 Before getting categories Query to get specific category list
60 1.2054920196533 After getting categories Query to get specific category list
61 1.205493927002 Before getting category custom Before call to function getCategoryCustom
62 1.2126159667969 After getting category custom After call to function getCategoryCustom
63 1.2126178741455 End of GetCategoryList function End of the function
64 1.2126247882843 End of getCategoryListByGroup Function Before return()
65 1.5025618076324 App Controller End End of the App controller (called before the controller of every page)
66 3.492203950882 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 3.4922749996185 Before Get Options Before the call to getOptions in the tpl class
68 4.9382479190826 After Get Options After the call to getOptions in the tpl class
69 4.9382967948914 App_after Controller End End of the App_after controller (called after the controller of every page)
70 5.1916139125824 Finalizing debug Before the debug is output to the page.
71 5.1916379928589 End of App This is the end of the app logging, final timestamp


Query Debug - 884 Database Queries. Total time 3.7411 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00019097328186035
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00044703483581543
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00015401840209961
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0615 0.061450004577637
SELECT * FROM `bad_bots`
5 0.0005 0.0005030632019043
SELECT parameter, value FROM parameters
6 0.0002 0.00015401840209961
SET time_zone = 'Europe/London'
7 0.0003 0.00030016899108887
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.0001530647277832
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010895729064941
delete from cachefiles
10 0.0003 0.00031399726867676
SELECT id FROM pages WHERE pagename = 'tactical-flashlight-reviews' LIMIT 1
11 0.0003 0.00025105476379395
SELECT * FROM pages WHERE id = 103
12 0.0008 0.00078797340393066
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0094 0.0093832015991211
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0004 0.00035214424133301
SELECT * FROM pages WHERE pagename = 'tactical-flashlight-reviews'
15 0.0001 0.00014901161193848
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00052213668823242
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00045990943908691
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.00023102760314941
SELECT id FROM categories WHERE parent_id = '49'
19 0.0004 0.00043296813964844
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0001 0.00013995170593262
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.0001 0.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
22 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0030040740966797
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.0002601146697998
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '129'
30 0.0057 0.0057158470153809
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.00018501281738281
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
32 0.0002 0.00015401840209961
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
33 0.0002 0.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00013017654418945
SELECT * FROM categorygroups WHERE id = '1'
35 0.0027 0.0027389526367188
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.00030612945556641
SELECT id FROM categories WHERE parent_id = '80'
37 0.0030 0.0030059814453125
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
39 0.0002 0.00018000602722168
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.00017809867858887
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '1'
42 0.0013 0.001317024230957
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.0002748966217041
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00021982192993164
SELECT id FROM categories WHERE parent_id = '101'
45 0.0021 0.0021278858184814
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.00016212463378906
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0002 0.00016188621520996
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.00019478797912598
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.0001380443572998
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00043511390686035
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0026 0.0026350021362305
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0003 0.00027203559875488
SELECT id FROM categories WHERE parent_id = '30'
53 0.0027 0.002734899520874
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
54 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
55 0.0002 0.00016117095947266
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.00018596649169922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0002 0.00015115737915039
SELECT * FROM categorygroups WHERE id = '2'
58 0.0049 0.0049200057983398
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.00028109550476074
SELECT id FROM categories WHERE parent_id = '61'
60 0.0049 0.0048611164093018
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.00016999244689941
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.00015997886657715
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.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.0001368522644043
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00069594383239746
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0240 0.024011850357056
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.00030899047851562
SELECT id FROM categories WHERE parent_id = '64'
68 0.0049 0.0048952102661133
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.00017404556274414
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0002 0.00016283988952637
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.00018191337585449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
73 0.0106 0.010624885559082
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.00029492378234863
SELECT id FROM categories WHERE parent_id = '65'
75 0.0098 0.009782075881958
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.00017714500427246
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0002 0.00016689300537109
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.00020408630371094
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
80 0.0029 0.0029261112213135
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.00027704238891602
SELECT id FROM categories WHERE parent_id = '81'
82 0.0029 0.0029280185699463
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
85 0.0002 0.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00013995170593262
SELECT * FROM categorygroups WHERE id = '10'
87 0.0130 0.012998104095459
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.00028610229492188
SELECT id FROM categories WHERE parent_id = '31'
89 0.0030 0.0029900074005127
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.00016403198242188
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
91 0.0002 0.00016283988952637
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.00020003318786621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
94 0.0274 0.027416944503784
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.00031399726867676
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00023794174194336
SELECT id FROM categories WHERE parent_id = '131'
97 0.0034 0.0034010410308838
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
98 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0002 0.00017809867858887
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.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00013899803161621
SELECT * FROM categorygroups WHERE id = '10'
102 0.0558 0.055769920349121
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.0004 0.00036001205444336
SELECT id FROM categories WHERE parent_id = '34'
104 0.0003 0.00026392936706543
SELECT id FROM categories WHERE parent_id = '94'
105 0.0003 0.00026988983154297
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00023698806762695
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00023698806762695
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00023508071899414
SELECT id FROM categories WHERE parent_id = '130'
109 0.0168 0.016782999038696
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.00023007392883301
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.00019192695617676
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.0002288818359375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0002 0.0001518726348877
SELECT * FROM categorygroups WHERE id = '10'
114 0.0025 0.0025460720062256
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.00029087066650391
SELECT id FROM categories WHERE parent_id = '32'
116 0.0020 0.0019869804382324
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0002 0.00015616416931152
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0002 0.00016403198242188
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.00020790100097656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00013995170593262
SELECT * FROM categorygroups WHERE id = '10'
121 0.0027 0.0026571750640869
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 89
122 0.0003 0.00028705596923828
SELECT id FROM categories WHERE parent_id = '89'
123 0.0025 0.0024881362915039
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
125 0.0002 0.00016999244689941
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.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00013995170593262
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00041294097900391
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0193 0.019348859786987
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.0003 0.00028300285339355
SELECT id FROM categories WHERE parent_id = '84'
131 0.0010 0.00099706649780273
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.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 (84)
				  AND p.disabled = 0 
133 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00019383430480957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00013399124145508
SELECT * FROM categorygroups WHERE id = '17'
136 0.0008 0.00084304809570312
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 90
137 0.0003 0.00025200843811035
SELECT id FROM categories WHERE parent_id = '90'
138 0.0009 0.00092101097106934
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.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 (90)
				  AND p.disabled = 0 
140 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 (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.00018000602722168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00014710426330566
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00032496452331543
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0031 0.0031251907348633
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 92
145 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '92'
146 0.0030 0.0029780864715576
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0002 0.0001678466796875
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.00016403198242188
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.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00014114379882812
SELECT * FROM categorygroups WHERE id = '20'
151 0.1216 0.1215648651123
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0005 0.00047397613525391
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00020813941955566
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00018000602722168
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '84'
158 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00022411346435547
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '357'
167 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '379'
168 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '450'
170 0.0057 0.0057110786437988
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '458'
173 0.0003 0.00032401084899902
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0057 0.0057029724121094
SELECT * FROM pages WHERE id = '41'
175 0.0003 0.0002739429473877
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00023078918457031
SELECT * FROM pages WHERE id = '44'
177 0.0002 0.00020980834960938
SELECT * FROM pages WHERE id = '68'
178 0.0003 0.0002899169921875
SELECT * FROM pages WHERE id = '80'
179 0.0003 0.0002901554107666
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00022411346435547
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00023698806762695
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00022792816162109
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.0002131462097168
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00024795532226562
SELECT * FROM pages WHERE id = '133'
185 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '148'
186 0.0022 0.0021979808807373
SELECT * FROM pages WHERE id = '217'
187 0.0002 0.00023818016052246
SELECT * FROM pages WHERE id = '228'
188 0.0003 0.00028300285339355
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00022506713867188
SELECT * FROM pages WHERE id = '271'
190 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '286'
191 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00021982192993164
SELECT * FROM pages WHERE id = '291'
193 0.0003 0.0002589225769043
SELECT * FROM pages WHERE id = '380'
194 0.0005 0.0005030632019043
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00023007392883301
SELECT * FROM pages WHERE id = '354'
196 0.0003 0.00030016899108887
SELECT * FROM pages WHERE id = '363'
197 0.0005 0.00045180320739746
SELECT * FROM pages WHERE id = '364'
198 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '368'
199 0.0003 0.00027298927307129
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00023889541625977
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00024104118347168
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0004 0.00039792060852051
SELECT * FROM pages WHERE id = '66'
204 0.0003 0.00031089782714844
SELECT * FROM pages WHERE id = '77'
205 0.0003 0.00028491020202637
SELECT * FROM pages WHERE id = '90'
206 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '149'
210 0.0003 0.00026297569274902
SELECT * FROM pages WHERE id = '150'
211 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '162'
213 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '164'
214 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '167'
215 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '180'
216 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '268'
219 0.0003 0.00025606155395508
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '290'
221 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '413'
222 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '409'
223 0.0003 0.00032496452331543
SELECT * FROM pages WHERE id = '327'
224 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '358'
227 0.0003 0.00025510787963867
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00020408630371094
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00020813941955566
SELECT * FROM pages WHERE id = '386'
233 0.0002 0.00019288063049316
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00020885467529297
SELECT * FROM pages WHERE id = '416'
236 0.0003 0.00026988983154297
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '427'
239 0.0003 0.0002598762512207
SELECT * FROM pages WHERE id = '428'
240 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '432'
241 0.0002 0.00020289421081543
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '437'
244 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00022315979003906
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00018405914306641
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '74'
248 0.0102 0.010235786437988
SELECT * FROM pages WHERE id = '137'
249 0.0620 0.061954975128174
SELECT * FROM pages WHERE id = '145'
250 0.0004 0.00040507316589355
SELECT * FROM pages WHERE id = '156'
251 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '407'
252 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00023317337036133
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00024294853210449
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '334'
257 0.0002 0.00019621849060059
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00020599365234375
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00022482872009277
SELECT * FROM pages WHERE id = '42'
264 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00020384788513184
SELECT * FROM pages WHERE id = '86'
266 0.0002 0.00020718574523926
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '102'
268 0.0002 0.00018119812011719
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00024700164794922
SELECT * FROM pages WHERE id = '114'
270 0.0003 0.00025010108947754
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00024294853210449
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00022983551025391
SELECT * FROM pages WHERE id = '62'
274 0.0002 0.00021004676818848
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00019693374633789
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00022792816162109
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00023508071899414
SELECT * FROM pages WHERE id = '278'
278 0.0003 0.00026488304138184
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00019621849060059
SELECT * FROM pages WHERE id = '345'
283 0.0003 0.00025105476379395
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00019478797912598
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '393'
290 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '394'
291 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '421'
294 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '426'
295 0.0003 0.00025701522827148
SELECT * FROM pages WHERE id = '430'
296 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '451'
302 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '453'
303 0.0002 0.0001518726348877
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0072 0.0071969032287598
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00023603439331055
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '417'
310 0.0002 0.00015902519226074
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '181'
313 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00018119812011719
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '383'
317 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '442'
320 0.0002 0.00018095970153809
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.00025486946105957
SELECT * FROM pages WHERE id = '103'
322 0.0046 0.0045769214630127
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.0002138614654541
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '248'
327 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00020194053649902
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00022196769714355
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '104'
333 0.0003 0.00030899047851562
SELECT * FROM pages WHERE id = '115'
334 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = '151'
337 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '200'
339 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '304'
340 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00019383430480957
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.00018715858459473
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '446'
350 0.0002 0.00017786026000977
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00019288063049316
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '456'
354 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '462'
357 0.0002 0.0001828670501709
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00023698806762695
SELECT * FROM pages WHERE id = '182'
360 0.0002 0.00020289421081543
SELECT * FROM pages WHERE id = '238'
361 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '240'
362 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '242'
363 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '252'
364 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '253'
365 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '262'
366 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '267'
367 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '420'
368 0.0002 0.00015997886657715
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00014019012451172
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00013995170593262
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0019 0.00187087059021
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0004 0.00043916702270508
SELECT * FROM pages WHERE pagename = 'tactical-flashlight-reviews'
373 0.0279 0.027908086776733
SELECT * FROM productsets WHERE id = '22'
374 0.0254 0.02542519569397
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 p.salesrank <= 999999 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND (SELECT COUNT(pc.id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (51)) > 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 48
375 0.0002 0.00019502639770508
UPDATE productsets SET lastupdated = '1563375431', products = '97492,128353,128352,148089,137032' WHERE id = '22'
376 0.0002 0.0002291202545166
SELECT * FROM products WHERE id = '97492'
377 0.0003 0.00025606155395508
SELECT * FROM productimages WHERE product_id = '97492' ORDER BY sortorder ASC
378 0.0002 0.00023293495178223
SELECT * FROM product_image_select WHERE product_id = '97492'
379 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '97492'
380 0.0196 0.019613027572632
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '97492' AND a.name = n.originalname
381 0.0002 0.0002288818359375
SELECT * FROM productoffers WHERE product_id = '97492' AND merchantid = 'ATVPDKIKX0DER'
382 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '97492' AND price > 0
                ORDER BY price ASC LIMIT 1
383 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '97492' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
384 0.0001 0.00014185905456543
UPDATE products SET price = '3299' WHERE id = '97492'
385 0.0002 0.00021600723266602
SELECT * FROM products WHERE id = '128353'
386 0.0003 0.00033712387084961
SELECT * FROM productimages WHERE product_id = '128353' ORDER BY sortorder ASC
387 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '128353'
388 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '128353'
389 0.0323 0.032285928726196
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '128353' AND a.name = n.originalname
390 0.0002 0.0002288818359375
SELECT * FROM productoffers WHERE product_id = '128353' AND merchantid = 'ATVPDKIKX0DER'
391 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '128353' AND price > 0
                ORDER BY price ASC LIMIT 1
392 0.0003 0.00034904479980469
SELECT value FROM productattributes WHERE product_id = '128353' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
393 0.0001 0.00012707710266113
UPDATE products SET price = '5995' WHERE id = '128353'
394 0.0003 0.00027918815612793
SELECT * FROM products WHERE id = '128352'
395 0.0004 0.00038909912109375
SELECT * FROM productimages WHERE product_id = '128352' ORDER BY sortorder ASC
396 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '128352'
397 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '128352'
398 0.0240 0.023988008499146
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '128352' AND a.name = n.originalname
399 0.0002 0.00021195411682129
SELECT * FROM productoffers WHERE product_id = '128352' AND merchantid = 'ATVPDKIKX0DER'
400 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '128352' AND price > 0
                ORDER BY price ASC LIMIT 1
401 0.0004 0.00040912628173828
SELECT value FROM productattributes WHERE product_id = '128352' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
402 0.0001 0.00012612342834473
UPDATE products SET price = '7345' WHERE id = '128352'
403 0.0002 0.00020790100097656
SELECT * FROM products WHERE id = '148089'
404 0.0003 0.00030994415283203
SELECT * FROM productimages WHERE product_id = '148089' ORDER BY sortorder ASC
405 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '148089'
406 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '148089'
407 0.0088 0.0087668895721436
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '148089' AND a.name = n.originalname
408 0.0002 0.00022602081298828
SELECT * FROM productoffers WHERE product_id = '148089' AND merchantid = 'ATVPDKIKX0DER'
409 0.0002 0.00020980834960938
SELECT * FROM productoffers
                WHERE product_id = '148089' AND price > 0
                ORDER BY price ASC LIMIT 1
410 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '148089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
411 0.0001 0.00012707710266113
UPDATE products SET price = '5745' WHERE id = '148089'
412 0.0002 0.00020217895507812
SELECT * FROM products WHERE id = '137032'
413 0.0003 0.0003199577331543
SELECT * FROM productimages WHERE product_id = '137032' ORDER BY sortorder ASC
414 0.0002 0.00024199485778809
SELECT * FROM product_image_select WHERE product_id = '137032'
415 0.0001 0.00013113021850586
SELECT * FROM productcustomimages WHERE product_id = '137032'
416 0.1422 0.14215397834778
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '137032' AND a.name = n.originalname
417 0.0003 0.00025200843811035
SELECT * FROM productoffers WHERE product_id = '137032' AND merchantid = 'ATVPDKIKX0DER'
418 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = '137032' AND price > 0
                ORDER BY price ASC LIMIT 1
419 0.0004 0.00043487548828125
SELECT value FROM productattributes WHERE product_id = '137032' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
420 0.1168 0.11677098274231
UPDATE products SET price = '3995' WHERE id = '137032'
421 0.0005 0.0005180835723877
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '97492' ORDER BY timestamp DESC
422 0.0003 0.00031876564025879
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '128353' ORDER BY timestamp DESC
423 0.0003 0.00031208992004395
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '128352' ORDER BY timestamp DESC
424 0.0003 0.00033283233642578
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '148089' ORDER BY timestamp DESC
425 0.0003 0.00032401084899902
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '137032' ORDER BY timestamp DESC
426 0.0002 0.00019001960754395
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
427 0.0257 0.025696039199829
INSERT INTO ga_users (`ips`) SELECT 'a:1:{i:0;s:13:\"54.162.151.77\";}'
428 0.0226 0.022588968276978
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1563375431'
429 0.0139 0.013910055160522
INSERT INTO tracker_action (`gauser_id`, `gasession_id`, `action`, `notes`, `timestamp`) SELECT '144658', '145599', 'basket_view', '', '1563375431'
430 0.0002 0.00020909309387207
SELECT * FROM pages WHERE id = 2
431 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = 4
432 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = 12
433 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = 10
434 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 7
435 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = 18
436 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = 28
437 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = 13
438 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 3
439 0.2294 0.22944903373718
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
440 0.0002 0.00021815299987793
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:1563375432;s:8:\"products\";a:6:{i:3;s:6:\"414321\";i:9;s:6:\"402907\";i:11;s:6:\"411183\";i:12;s:6:\"267285\";i:19;s:5:\"90837\";i:21;s:6:\"104029\";}}' WHERE id = '175'
441 0.2306 0.2305920124054
SELECT * FROM products WHERE id IN (414321,402907,411183,267285,90837,104029) ORDER BY FIELD(id, 414321,402907,411183,267285,90837,104029 )
442 0.0003 0.00030207633972168
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
443 0.0002 0.00023794174194336
SELECT * FROM product_image_select WHERE product_id = '414321'
444 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '414321'
445 0.0251 0.025081872940063
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
446 0.0002 0.00023198127746582
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
447 0.0002 0.00023078918457031
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
448 0.0004 0.00039911270141602
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
449 0.2212 0.22118806838989
UPDATE products SET price = '9999' WHERE id = '414321'
450 0.0004 0.00038290023803711
SELECT * FROM productimages WHERE product_id = '402907' ORDER BY sortorder ASC
451 0.0003 0.00029301643371582
SELECT * FROM product_image_select WHERE product_id = '402907'
452 0.0002 0.00017213821411133
SELECT * FROM productcustomimages WHERE product_id = '402907'
453 0.0108 0.010797023773193
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402907' AND a.name = n.originalname
454 0.0002 0.00022506713867188
SELECT * FROM productoffers WHERE product_id = '402907' AND merchantid = 'ATVPDKIKX0DER'
455 0.0002 0.00024104118347168
SELECT * FROM productoffers
                WHERE product_id = '402907' AND price > 0
                ORDER BY price ASC LIMIT 1
456 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '402907' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
457 0.0002 0.00015997886657715
UPDATE products SET price = '9400' WHERE id = '402907'
458 0.0005 0.00045084953308105
SELECT * FROM productimages WHERE product_id = '411183' ORDER BY sortorder ASC
459 0.0002 0.00023508071899414
SELECT * FROM product_image_select WHERE product_id = '411183'
460 0.0001 0.0001368522644043
SELECT * FROM productcustomimages WHERE product_id = '411183'
461 0.0032 0.0031979084014893
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411183' AND a.name = n.originalname
462 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '411183' AND merchantid = 'ATVPDKIKX0DER'
463 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '411183' AND price > 0
                ORDER BY price ASC LIMIT 1
464 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '411183' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
465 0.2494 0.24935507774353
UPDATE products SET price = '16999' WHERE id = '411183'
466 0.0005 0.0004880428314209
SELECT * FROM productimages WHERE product_id = '267285' ORDER BY sortorder ASC
467 0.0002 0.00024104118347168
SELECT * FROM product_image_select WHERE product_id = '267285'
468 0.0001 0.00014114379882812
SELECT * FROM productcustomimages WHERE product_id = '267285'
469 0.0049 0.0048611164093018
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '267285' AND a.name = n.originalname
470 0.0002 0.00022602081298828
SELECT * FROM productoffers WHERE product_id = '267285' AND merchantid = 'ATVPDKIKX0DER'
471 0.0002 0.000244140625
SELECT * FROM productoffers
                WHERE product_id = '267285' AND price > 0
                ORDER BY price ASC LIMIT 1
472 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '267285' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
473 0.0228 0.022754192352295
UPDATE products SET price = '7999' WHERE id = '267285'
474 0.0005 0.00046086311340332
SELECT * FROM productimages WHERE product_id = '90837' ORDER BY sortorder ASC
475 0.0002 0.00024890899658203
SELECT * FROM product_image_select WHERE product_id = '90837'
476 0.0001 0.00013995170593262
SELECT * FROM productcustomimages WHERE product_id = '90837'
477 0.0084 0.0083839893341064
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '90837' AND a.name = n.originalname
478 0.0003 0.00027179718017578
SELECT * FROM productoffers WHERE product_id = '90837' AND merchantid = 'ATVPDKIKX0DER'
479 0.0003 0.00028109550476074
SELECT * FROM productoffers
                WHERE product_id = '90837' AND price > 0
                ORDER BY price ASC LIMIT 1
480 0.0006 0.00064992904663086
SELECT value FROM productattributes WHERE product_id = '90837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
481 0.0020 0.0020430088043213
UPDATE products SET price = '9999' WHERE id = '90837'
482 0.0003 0.00030899047851562
SELECT * FROM productimages WHERE product_id = '104029' ORDER BY sortorder ASC
483 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '104029'
484 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '104029'
485 0.0054 0.0054070949554443
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '104029' AND a.name = n.originalname
486 0.0002 0.00021910667419434
SELECT * FROM productoffers WHERE product_id = '104029' AND merchantid = 'ATVPDKIKX0DER'
487 0.0002 0.00023007392883301
SELECT * FROM productoffers
                WHERE product_id = '104029' AND price > 0
                ORDER BY price ASC LIMIT 1
488 0.0005 0.00047993659973145
SELECT value FROM productattributes WHERE product_id = '104029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
489 0.0031 0.0030820369720459
UPDATE products SET price = '9700' WHERE id = '104029'
490 0.0109 0.010884046554565
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
491 0.0002 0.00023794174194336
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:1563375432;s:8:\"products\";a:6:{i:3;s:6:\"414321\";i:6;s:6:\"404868\";i:14;s:6:\"123223\";i:16;s:6:\"413807\";i:18;s:6:\"182782\";i:9;s:6:\"402907\";}}' WHERE id = '177'
492 0.0005 0.00046706199645996
SELECT * FROM products WHERE id IN (414321,404868,123223,413807,182782,402907) ORDER BY FIELD(id, 414321,404868,123223,413807,182782,402907 )
493 0.0003 0.00027298927307129
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
494 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '414321'
495 0.0001 0.00014495849609375
SELECT * FROM productcustomimages WHERE product_id = '414321'
496 0.0051 0.0050959587097168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
497 0.0002 0.00020217895507812
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
498 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
499 0.0004 0.00044608116149902
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
500 0.0035 0.0035130977630615
UPDATE products SET price = '9999' WHERE id = '414321'
501 0.0004 0.00036501884460449
SELECT * FROM productimages WHERE product_id = '404868' ORDER BY sortorder ASC
502 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '404868'
503 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '404868'
504 0.0058 0.0058279037475586
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404868' AND a.name = n.originalname
505 0.0002 0.00020909309387207
SELECT * FROM productoffers WHERE product_id = '404868' AND merchantid = 'ATVPDKIKX0DER'
506 0.0002 0.00023508071899414
SELECT * FROM productoffers
                WHERE product_id = '404868' AND price > 0
                ORDER BY price ASC LIMIT 1
507 0.0006 0.00055384635925293
SELECT value FROM productattributes WHERE product_id = '404868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
508 0.0040 0.0040268898010254
UPDATE products SET price = '46999' WHERE id = '404868'
509 0.0004 0.00035810470581055
SELECT * FROM productimages WHERE product_id = '123223' ORDER BY sortorder ASC
510 0.0002 0.00024700164794922
SELECT * FROM product_image_select WHERE product_id = '123223'
511 0.0001 0.0001378059387207
SELECT * FROM productcustomimages WHERE product_id = '123223'
512 0.0097 0.0097119808197021
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '123223' AND a.name = n.originalname
513 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '123223' AND merchantid = 'ATVPDKIKX0DER'
514 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = '123223' AND price > 0
                ORDER BY price ASC LIMIT 1
515 0.0005 0.0005190372467041
SELECT value FROM productattributes WHERE product_id = '123223' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
516 0.0036 0.0035760402679443
UPDATE products SET price = '19661' WHERE id = '123223'
517 0.0002 0.00023198127746582
SELECT * FROM productimages WHERE product_id = '413807' ORDER BY sortorder ASC
518 0.0002 0.0002439022064209
SELECT * FROM product_image_select WHERE product_id = '413807'
519 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '413807'
520 0.0058 0.0057590007781982
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413807' AND a.name = n.originalname
521 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '413807' AND merchantid = 'ATVPDKIKX0DER'
522 0.0002 0.00022006034851074
SELECT * FROM productoffers
                WHERE product_id = '413807' AND price > 0
                ORDER BY price ASC LIMIT 1
523 0.0005 0.0004730224609375
SELECT value FROM productattributes WHERE product_id = '413807' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
524 0.0010 0.0010230541229248
UPDATE products SET price = '179900' WHERE id = '413807'
525 0.0005 0.00046801567077637
SELECT * FROM productimages WHERE product_id = '182782' ORDER BY sortorder ASC
526 0.0002 0.00022578239440918
SELECT * FROM product_image_select WHERE product_id = '182782'
527 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '182782'
528 0.0033 0.0033068656921387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '182782' AND a.name = n.originalname
529 0.0002 0.00021481513977051
SELECT * FROM productoffers WHERE product_id = '182782' AND merchantid = 'ATVPDKIKX0DER'
530 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '182782' AND price > 0
                ORDER BY price ASC LIMIT 1
531 0.0005 0.00045895576477051
SELECT value FROM productattributes WHERE product_id = '182782' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
532 0.0013 0.0013108253479004
UPDATE products SET price = '11520' WHERE id = '182782'
533 0.0003 0.0002591609954834
SELECT * FROM productimages WHERE product_id = '402907' ORDER BY sortorder ASC
534 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '402907'
535 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '402907'
536 0.0035 0.0035190582275391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402907' AND a.name = n.originalname
537 0.0002 0.00020003318786621
SELECT * FROM productoffers WHERE product_id = '402907' AND merchantid = 'ATVPDKIKX0DER'
538 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '402907' AND price > 0
                ORDER BY price ASC LIMIT 1
539 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '402907' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
540 0.0018 0.001823902130127
UPDATE products SET price = '9400' WHERE id = '402907'
541 0.0250 0.025038003921509
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
542 0.0002 0.00023794174194336
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"categories\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1563375432;s:8:\"products\";a:6:{i:5;s:6:\"408079\";i:12;s:6:\"267285\";i:16;s:6:\"117539\";i:19;s:6:\"232837\";i:4;s:6:\"131163\";i:7;s:6:\"402058\";}}' WHERE id = '181'
543 0.0005 0.00046396255493164
SELECT * FROM products WHERE id IN (408079,267285,117539,232837,131163,402058) ORDER BY FIELD(id, 408079,267285,117539,232837,131163,402058 )
544 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
545 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '408079'
546 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '408079'
547 0.0032 0.0031731128692627
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
548 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
549 0.0002 0.00022387504577637
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
550 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
551 0.0017 0.0017251968383789
UPDATE products SET price = '26458' WHERE id = '408079'
552 0.0004 0.00040197372436523
SELECT * FROM productimages WHERE product_id = '267285' ORDER BY sortorder ASC
553 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '267285'
554 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '267285'
555 0.0028 0.002755880355835
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '267285' AND a.name = n.originalname
556 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '267285' AND merchantid = 'ATVPDKIKX0DER'
557 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '267285' AND price > 0
                ORDER BY price ASC LIMIT 1
558 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '267285' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
559 0.0001 0.0001370906829834
UPDATE products SET price = '7999' WHERE id = '267285'
560 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '117539' ORDER BY sortorder ASC
561 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '117539'
562 0.0001 0.00013518333435059
SELECT * FROM productcustomimages WHERE product_id = '117539'
563 0.0040 0.004019021987915
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '117539' AND a.name = n.originalname
564 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '117539' AND merchantid = 'ATVPDKIKX0DER'
565 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '117539' AND price > 0
                ORDER BY price ASC LIMIT 1
566 0.0005 0.00048398971557617
SELECT value FROM productattributes WHERE product_id = '117539' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
567 0.0015 0.0014951229095459
UPDATE products SET price = '8699' WHERE id = '117539'
568 0.0003 0.00032401084899902
SELECT * FROM productimages WHERE product_id = '232837' ORDER BY sortorder ASC
569 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '232837'
570 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '232837'
571 0.0027 0.0026900768280029
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '232837' AND a.name = n.originalname
572 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '232837' AND merchantid = 'ATVPDKIKX0DER'
573 0.0002 0.00023221969604492
SELECT * FROM productoffers
                WHERE product_id = '232837' AND price > 0
                ORDER BY price ASC LIMIT 1
574 0.0004 0.00035810470581055
SELECT value FROM productattributes WHERE product_id = '232837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
575 0.0001 0.00013303756713867
UPDATE products SET price = '8077' WHERE id = '232837'
576 0.0002 0.00023388862609863
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
577 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '131163'
578 0.0001 0.00014305114746094
SELECT * FROM productcustomimages WHERE product_id = '131163'
579 0.0025 0.0025289058685303
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
580 0.0002 0.00019621849060059
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
581 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
582 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
583 0.0001 0.00013399124145508
UPDATE products SET price = '18946' WHERE id = '131163'
584 0.0003 0.00031495094299316
SELECT * FROM productimages WHERE product_id = '402058' ORDER BY sortorder ASC
585 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '402058'
586 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '402058'
587 0.0028 0.0028409957885742
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '402058' AND a.name = n.originalname
588 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '402058' AND merchantid = 'ATVPDKIKX0DER'
589 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '402058' AND price > 0
                ORDER BY price ASC LIMIT 1
590 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '402058' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
591 0.0001 0.00013518333435059
UPDATE products SET price = '19900' WHERE id = '402058'
592 0.0274 0.027374029159546
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
593 0.0002 0.00024294853210449
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:1563375432;s:8:\"products\";a:6:{i:0;s:6:\"398858\";i:5;s:6:\"408079\";i:13;s:6:\"328526\";i:15;s:6:\"406156\";i:16;s:6:\"117539\";i:20;s:6:\"104029\";}}' WHERE id = '183'
594 0.0005 0.00046300888061523
SELECT * FROM products WHERE id IN (398858,408079,328526,406156,117539,104029) ORDER BY FIELD(id, 398858,408079,328526,406156,117539,104029 )
595 0.0002 0.00023198127746582
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
596 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '398858'
597 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '398858'
598 0.0031 0.0031280517578125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
599 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
600 0.0002 0.00024700164794922
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
601 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
602 0.0001 0.0001380443572998
UPDATE products SET price = '2999' WHERE id = '398858'
603 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
604 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '408079'
605 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '408079'
606 0.0026 0.0026378631591797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
607 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
608 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
609 0.0004 0.00039911270141602
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
610 0.0001 0.00013589859008789
UPDATE products SET price = '26458' WHERE id = '408079'
611 0.0003 0.00025486946105957
SELECT * FROM productimages WHERE product_id = '328526' ORDER BY sortorder ASC
612 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '328526'
613 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '328526'
614 0.0019 0.0019021034240723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '328526' AND a.name = n.originalname
615 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '328526' AND merchantid = 'ATVPDKIKX0DER'
616 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '328526' AND price > 0
                ORDER BY price ASC LIMIT 1
617 0.0004 0.00037002563476562
SELECT value FROM productattributes WHERE product_id = '328526' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
618 0.0001 0.00013399124145508
UPDATE products SET price = '9999' WHERE id = '328526'
619 0.0002 0.00019979476928711
SELECT * FROM productimages WHERE product_id = '406156' ORDER BY sortorder ASC
620 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '406156'
621 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '406156'
622 0.0034 0.0033998489379883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406156' AND a.name = n.originalname
623 0.0003 0.00026392936706543
SELECT * FROM productoffers WHERE product_id = '406156' AND merchantid = 'ATVPDKIKX0DER'
624 0.0003 0.00026202201843262
SELECT * FROM productoffers
                WHERE product_id = '406156' AND price > 0
                ORDER BY price ASC LIMIT 1
625 0.0007 0.00066184997558594
SELECT value FROM productattributes WHERE product_id = '406156' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
626 0.0002 0.00020599365234375
UPDATE products SET price = '1015' WHERE id = '406156'
627 0.0004 0.00041794776916504
SELECT * FROM productimages WHERE product_id = '117539' ORDER BY sortorder ASC
628 0.0004 0.00040102005004883
SELECT * FROM product_image_select WHERE product_id = '117539'
629 0.0002 0.00020098686218262
SELECT * FROM productcustomimages WHERE product_id = '117539'
630 0.0032 0.0032229423522949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '117539' AND a.name = n.originalname
631 0.0002 0.00021195411682129
SELECT * FROM productoffers WHERE product_id = '117539' AND merchantid = 'ATVPDKIKX0DER'
632 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '117539' AND price > 0
                ORDER BY price ASC LIMIT 1
633 0.0005 0.00047111511230469
SELECT value FROM productattributes WHERE product_id = '117539' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
634 0.0059 0.0058729648590088
UPDATE products SET price = '8699' WHERE id = '117539'
635 0.0003 0.00033783912658691
SELECT * FROM productimages WHERE product_id = '104029' ORDER BY sortorder ASC
636 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '104029'
637 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '104029'
638 0.0037 0.0036740303039551
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '104029' AND a.name = n.originalname
639 0.0002 0.00020813941955566
SELECT * FROM productoffers WHERE product_id = '104029' AND merchantid = 'ATVPDKIKX0DER'
640 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = '104029' AND price > 0
                ORDER BY price ASC LIMIT 1
641 0.0005 0.0004880428314209
SELECT value FROM productattributes WHERE product_id = '104029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
642 0.0040 0.0040009021759033
UPDATE products SET price = '9700' WHERE id = '104029'
643 0.0005 0.00047492980957031
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
644 0.0002 0.00015091896057129
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
645 0.0001 0.0001368522644043
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
646 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
647 0.0004 0.00043010711669922
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
648 0.0001 0.0001380443572998
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
649 0.0001 0.00013494491577148
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
650 0.0009 0.00093293190002441
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
651 0.0004 0.0003509521484375
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
652 0.0003 0.00031089782714844
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
653 0.0003 0.00029802322387695
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
654 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = 2
655 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 4
656 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 12
657 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = 10
658 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 7
659 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = 18
660 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = 28
661 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = 13
662 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = 3
663 0.0128 0.012837886810303
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
664 0.0002 0.00023007392883301
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:1563375433;s:8:\"products\";a:6:{i:5;s:6:\"408079\";i:6;s:6:\"404868\";i:17;s:6:\"117539\";i:18;s:6:\"182782\";i:20;s:6:\"232837\";i:23;s:6:\"412561\";}}' WHERE id = '175'
665 0.0004 0.0004420280456543
SELECT * FROM products WHERE id IN (408079,404868,117539,182782,232837,412561) ORDER BY FIELD(id, 408079,404868,117539,182782,232837,412561 )
666 0.0002 0.00019311904907227
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
667 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '408079'
668 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '408079'
669 0.0026 0.0026059150695801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
670 0.0002 0.00020503997802734
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
671 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
672 0.0004 0.00036382675170898
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
673 0.2709 0.27086210250854
UPDATE products SET price = '26458' WHERE id = '408079'
674 0.0005 0.00045585632324219
SELECT * FROM productimages WHERE product_id = '404868' ORDER BY sortorder ASC
675 0.0002 0.0002291202545166
SELECT * FROM product_image_select WHERE product_id = '404868'
676 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '404868'
677 0.0040 0.0039868354797363
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404868' AND a.name = n.originalname
678 0.0002 0.00019717216491699
SELECT * FROM productoffers WHERE product_id = '404868' AND merchantid = 'ATVPDKIKX0DER'
679 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '404868' AND price > 0
                ORDER BY price ASC LIMIT 1
680 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '404868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
681 0.0001 0.00013184547424316
UPDATE products SET price = '46999' WHERE id = '404868'
682 0.0003 0.00026893615722656
SELECT * FROM productimages WHERE product_id = '117539' ORDER BY sortorder ASC
683 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '117539'
684 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '117539'
685 0.0027 0.0027029514312744
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '117539' AND a.name = n.originalname
686 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '117539' AND merchantid = 'ATVPDKIKX0DER'
687 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '117539' AND price > 0
                ORDER BY price ASC LIMIT 1
688 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '117539' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
689 0.2292 0.22921109199524
UPDATE products SET price = '8699' WHERE id = '117539'
690 0.0005 0.00053715705871582
SELECT * FROM productimages WHERE product_id = '182782' ORDER BY sortorder ASC
691 0.0003 0.00027990341186523
SELECT * FROM product_image_select WHERE product_id = '182782'
692 0.0002 0.0001528263092041
SELECT * FROM productcustomimages WHERE product_id = '182782'
693 0.0038 0.0038399696350098
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '182782' AND a.name = n.originalname
694 0.0003 0.00025606155395508
SELECT * FROM productoffers WHERE product_id = '182782' AND merchantid = 'ATVPDKIKX0DER'
695 0.0003 0.00026082992553711
SELECT * FROM productoffers
                WHERE product_id = '182782' AND price > 0
                ORDER BY price ASC LIMIT 1
696 0.0006 0.00055694580078125
SELECT value FROM productattributes WHERE product_id = '182782' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
697 0.2414 0.24139380455017
UPDATE products SET price = '11520' WHERE id = '182782'
698 0.0004 0.00039982795715332
SELECT * FROM productimages WHERE product_id = '232837' ORDER BY sortorder ASC
699 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '232837'
700 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '232837'
701 0.0032 0.0031991004943848
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '232837' AND a.name = n.originalname
702 0.0002 0.00021791458129883
SELECT * FROM productoffers WHERE product_id = '232837' AND merchantid = 'ATVPDKIKX0DER'
703 0.0002 0.0002291202545166
SELECT * FROM productoffers
                WHERE product_id = '232837' AND price > 0
                ORDER BY price ASC LIMIT 1
704 0.0004 0.00041389465332031
SELECT value FROM productattributes WHERE product_id = '232837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
705 0.0001 0.00013089179992676
UPDATE products SET price = '8077' WHERE id = '232837'
706 0.0002 0.00019383430480957
SELECT * FROM productimages WHERE product_id = '412561' ORDER BY sortorder ASC
707 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '412561'
708 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '412561'
709 0.0032 0.0031790733337402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412561' AND a.name = n.originalname
710 0.0002 0.00018978118896484
SELECT * FROM productoffers WHERE product_id = '412561' AND merchantid = 'ATVPDKIKX0DER'
711 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '412561' AND price > 0
                ORDER BY price ASC LIMIT 1
712 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '412561' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
713 0.2513 0.25130581855774
UPDATE products SET price = '3499' WHERE id = '412561'
714 0.0099 0.0098769664764404
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
715 0.0003 0.00025701522827148
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:1563375434;s:8:\"products\";a:6:{i:10;s:6:\"410951\";i:22;s:6:\"128892\";i:0;s:6:\"398858\";i:8;s:6:\"258602\";i:13;s:6:\"328526\";i:17;s:6:\"117539\";}}' WHERE id = '177'
716 0.0005 0.00046682357788086
SELECT * FROM products WHERE id IN (410951,128892,398858,258602,328526,117539) ORDER BY FIELD(id, 410951,128892,398858,258602,328526,117539 )
717 0.0003 0.00026607513427734
SELECT * FROM productimages WHERE product_id = '410951' ORDER BY sortorder ASC
718 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '410951'
719 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '410951'
720 0.0180 0.018032073974609
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410951' AND a.name = n.originalname
721 0.0002 0.0002288818359375
SELECT * FROM productoffers WHERE product_id = '410951' AND merchantid = 'ATVPDKIKX0DER'
722 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '410951' AND price > 0
                ORDER BY price ASC LIMIT 1
723 0.0004 0.00037384033203125
SELECT value FROM productattributes WHERE product_id = '410951' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
724 0.2314 0.23138785362244
UPDATE products SET price = '94700' WHERE id = '410951'
725 0.0006 0.00056195259094238
SELECT * FROM productimages WHERE product_id = '128892' ORDER BY sortorder ASC
726 0.0002 0.0002288818359375
SELECT * FROM product_image_select WHERE product_id = '128892'
727 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '128892'
728 0.0027 0.0027329921722412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '128892' AND a.name = n.originalname
729 0.0002 0.0002131462097168
SELECT * FROM productoffers WHERE product_id = '128892' AND merchantid = 'ATVPDKIKX0DER'
730 0.0002 0.00021815299987793
SELECT * FROM productoffers
                WHERE product_id = '128892' AND price > 0
                ORDER BY price ASC LIMIT 1
731 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '128892' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
732 0.0001 0.00013613700866699
UPDATE products SET price = '12482' WHERE id = '128892'
733 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
734 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '398858'
735 0.0001 0.00014209747314453
SELECT * FROM productcustomimages WHERE product_id = '398858'
736 0.0037 0.0037240982055664
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
737 0.0002 0.00022387504577637
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
738 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
739 0.0005 0.00046110153198242
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
740 0.0001 0.00012302398681641
UPDATE products SET price = '2999' WHERE id = '398858'
741 0.0004 0.00035715103149414
SELECT * FROM productimages WHERE product_id = '258602' ORDER BY sortorder ASC
742 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '258602'
743 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '258602'
744 0.0041 0.0040969848632812
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '258602' AND a.name = n.originalname
745 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '258602' AND merchantid = 'ATVPDKIKX0DER'
746 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '258602' AND price > 0
                ORDER BY price ASC LIMIT 1
747 0.0004 0.00042390823364258
SELECT value FROM productattributes WHERE product_id = '258602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
748 0.0001 0.00012516975402832
UPDATE products SET price = '19900' WHERE id = '258602'
749 0.0003 0.00025606155395508
SELECT * FROM productimages WHERE product_id = '328526' ORDER BY sortorder ASC
750 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '328526'
751 0.0001 0.00012683868408203
SELECT * FROM productcustomimages WHERE product_id = '328526'
752 0.0034 0.0033531188964844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '328526' AND a.name = n.originalname
753 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '328526' AND merchantid = 'ATVPDKIKX0DER'
754 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '328526' AND price > 0
                ORDER BY price ASC LIMIT 1
755 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '328526' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
756 0.0001 0.00013494491577148
UPDATE products SET price = '9999' WHERE id = '328526'
757 0.0003 0.00026512145996094
SELECT * FROM productimages WHERE product_id = '117539' ORDER BY sortorder ASC
758 0.0002 0.00021886825561523
SELECT * FROM product_image_select WHERE product_id = '117539'
759 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '117539'
760 0.0038 0.0038259029388428
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '117539' AND a.name = n.originalname
761 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '117539' AND merchantid = 'ATVPDKIKX0DER'
762 0.0002 0.00022196769714355
SELECT * FROM productoffers
                WHERE product_id = '117539' AND price > 0
                ORDER BY price ASC LIMIT 1
763 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '117539' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
764 0.0001 0.00012493133544922
UPDATE products SET price = '8699' WHERE id = '117539'
765 0.0277 0.0277259349823
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
766 0.0003 0.00029802322387695
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:1563375434;s:8:\"products\";a:6:{i:0;s:6:\"398858\";i:1;s:6:\"410588\";i:8;s:6:\"258602\";i:14;s:6:\"123223\";i:16;s:6:\"117539\";i:19;s:6:\"232837\";}}' WHERE id = '181'
767 0.0005 0.0004730224609375
SELECT * FROM products WHERE id IN (398858,410588,258602,123223,117539,232837) ORDER BY FIELD(id, 398858,410588,258602,123223,117539,232837 )
768 0.0002 0.00020289421081543
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
769 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '398858'
770 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '398858'
771 0.0031 0.0030748844146729
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
772 0.0002 0.00020384788513184
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
773 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
774 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
775 0.0001 0.00012302398681641
UPDATE products SET price = '2999' WHERE id = '398858'
776 0.0002 0.00018000602722168
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
777 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '410588'
778 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '410588'
779 0.0020 0.0020320415496826
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
780 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
781 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
782 0.0004 0.00035595893859863
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
783 0.0001 0.00012302398681641
UPDATE products SET price = '269999' WHERE id = '410588'
784 0.0003 0.00033187866210938
SELECT * FROM productimages WHERE product_id = '258602' ORDER BY sortorder ASC
785 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '258602'
786 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '258602'
787 0.0031 0.003108024597168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '258602' AND a.name = n.originalname
788 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '258602' AND merchantid = 'ATVPDKIKX0DER'
789 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '258602' AND price > 0
                ORDER BY price ASC LIMIT 1
790 0.0004 0.00040388107299805
SELECT value FROM productattributes WHERE product_id = '258602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
791 0.0001 0.00013399124145508
UPDATE products SET price = '19900' WHERE id = '258602'
792 0.0003 0.0003209114074707
SELECT * FROM productimages WHERE product_id = '123223' ORDER BY sortorder ASC
793 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '123223'
794 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '123223'
795 0.0027 0.0027239322662354
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '123223' AND a.name = n.originalname
796 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '123223' AND merchantid = 'ATVPDKIKX0DER'
797 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '123223' AND price > 0
                ORDER BY price ASC LIMIT 1
798 0.0004 0.00039815902709961
SELECT value FROM productattributes WHERE product_id = '123223' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
799 0.0001 0.00012016296386719
UPDATE products SET price = '19661' WHERE id = '123223'
800 0.0002 0.00024509429931641
SELECT * FROM productimages WHERE product_id = '117539' ORDER BY sortorder ASC
801 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '117539'
802 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '117539'
803 0.0027 0.0027329921722412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '117539' AND a.name = n.originalname
804 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '117539' AND merchantid = 'ATVPDKIKX0DER'
805 0.0004 0.00040483474731445
SELECT * FROM productoffers
                WHERE product_id = '117539' AND price > 0
                ORDER BY price ASC LIMIT 1
806 0.0005 0.00048184394836426
SELECT value FROM productattributes WHERE product_id = '117539' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
807 0.0001 0.00013589859008789
UPDATE products SET price = '8699' WHERE id = '117539'
808 0.0003 0.00028204917907715
SELECT * FROM productimages WHERE product_id = '232837' ORDER BY sortorder ASC
809 0.0002 0.00023508071899414
SELECT * FROM product_image_select WHERE product_id = '232837'
810 0.0001 0.00014901161193848
SELECT * FROM productcustomimages WHERE product_id = '232837'
811 0.0024 0.0023601055145264
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '232837' AND a.name = n.originalname
812 0.0002 0.00020408630371094
SELECT * FROM productoffers WHERE product_id = '232837' AND merchantid = 'ATVPDKIKX0DER'
813 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '232837' AND price > 0
                ORDER BY price ASC LIMIT 1
814 0.0004 0.00035691261291504
SELECT value FROM productattributes WHERE product_id = '232837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
815 0.0001 0.00013399124145508
UPDATE products SET price = '8077' WHERE id = '232837'
816 0.0274 0.027412176132202
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
817 0.0003 0.00028204917907715
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:1563375434;s:8:\"products\";a:6:{i:0;s:6:\"398858\";i:2;s:6:\"410950\";i:3;s:6:\"414321\";i:8;s:6:\"258602\";i:14;s:6:\"123223\";i:15;s:6:\"406156\";}}' WHERE id = '183'
818 0.0005 0.00047898292541504
SELECT * FROM products WHERE id IN (398858,410950,414321,258602,123223,406156) ORDER BY FIELD(id, 398858,410950,414321,258602,123223,406156 )
819 0.0002 0.0002288818359375
SELECT * FROM productimages WHERE product_id = '398858' ORDER BY sortorder ASC
820 0.0002 0.00023508071899414
SELECT * FROM product_image_select WHERE product_id = '398858'
821 0.0001 0.00013995170593262
SELECT * FROM productcustomimages WHERE product_id = '398858'
822 0.0030 0.0030441284179688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398858' AND a.name = n.originalname
823 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '398858' AND merchantid = 'ATVPDKIKX0DER'
824 0.0002 0.00023508071899414
SELECT * FROM productoffers
                WHERE product_id = '398858' AND price > 0
                ORDER BY price ASC LIMIT 1
825 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '398858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
826 0.0001 0.00013303756713867
UPDATE products SET price = '2999' WHERE id = '398858'
827 0.0003 0.00027990341186523
SELECT * FROM productimages WHERE product_id = '410950' ORDER BY sortorder ASC
828 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '410950'
829 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '410950'
830 0.0031 0.003101110458374
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410950' AND a.name = n.originalname
831 0.0002 0.00020480155944824
SELECT * FROM productoffers WHERE product_id = '410950' AND merchantid = 'ATVPDKIKX0DER'
832 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '410950' AND price > 0
                ORDER BY price ASC LIMIT 1
833 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '410950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
834 0.0001 0.00013208389282227
UPDATE products SET price = '250524' WHERE id = '410950'
835 0.0002 0.00024104118347168
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
836 0.0002 0.00023889541625977
SELECT * FROM product_image_select WHERE product_id = '414321'
837 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '414321'
838 0.0025 0.0025029182434082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
839 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
840 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
841 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '414321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
842 0.0001 0.00013589859008789
UPDATE products SET price = '9999' WHERE id = '414321'
843 0.0003 0.00033402442932129
SELECT * FROM productimages WHERE product_id = '258602' ORDER BY sortorder ASC
844 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '258602'
845 0.0001 0.00014400482177734
SELECT * FROM productcustomimages WHERE product_id = '258602'
846 0.0031 0.0030851364135742
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '258602' AND a.name = n.originalname
847 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '258602' AND merchantid = 'ATVPDKIKX0DER'
848 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '258602' AND price > 0
                ORDER BY price ASC LIMIT 1
849 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '258602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
850 0.0001 0.00013184547424316
UPDATE products SET price = '19900' WHERE id = '258602'
851 0.0003 0.0003211498260498
SELECT * FROM productimages WHERE product_id = '123223' ORDER BY sortorder ASC
852 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '123223'
853 0.0001 0.00014495849609375
SELECT * FROM productcustomimages WHERE product_id = '123223'
854 0.0027 0.0027117729187012
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '123223' AND a.name = n.originalname
855 0.0002 0.00020813941955566
SELECT * FROM productoffers WHERE product_id = '123223' AND merchantid = 'ATVPDKIKX0DER'
856 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '123223' AND price > 0
                ORDER BY price ASC LIMIT 1
857 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '123223' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
858 0.0001 0.00013208389282227
UPDATE products SET price = '19661' WHERE id = '123223'
859 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '406156' ORDER BY sortorder ASC
860 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '406156'
861 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '406156'
862 0.0032 0.003216028213501
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406156' AND a.name = n.originalname
863 0.0002 0.00020790100097656
SELECT * FROM productoffers WHERE product_id = '406156' AND merchantid = 'ATVPDKIKX0DER'
864 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = '406156' AND price > 0
                ORDER BY price ASC LIMIT 1
865 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '406156' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
866 0.0001 0.00013399124145508
UPDATE products SET price = '1015' WHERE id = '406156'
867 0.0004 0.00042605400085449
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
868 0.0001 0.00014305114746094
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
869 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
870 0.0002 0.00018596649169922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
871 0.0004 0.00041604042053223
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
872 0.0001 0.0001370906829834
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
873 0.0001 0.00014591217041016
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
874 0.0009 0.0009148120880127
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
875 0.0003 0.00033402442932129
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
876 0.0003 0.00031399726867676
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
877 0.0005 0.00051999092102051
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
878 0.0002 0.00015997886657715
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
879 0.0001 0.0001220703125
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
880 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
881 0.0001 0.00012588500976562
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
882 0.0001 0.00011610984802246
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
883 0.0004 0.00036287307739258
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
884 0.0003 0.00034213066101074
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'