Tactical Equipment - Survivalist Equipment

Civillian Laser Rangefinders :: Military Laser Range Finder :: Digital Range Finder For Yardage

Civillian Laser Rangefinder Hunting Yardage

UPDATED :  

Digital Laser Rangefinder Improves Accuracy & Helps Conserve Ammunition Accurately Calculating Yardage

Discount Laser Rangefinder Sale

UPDATED :  

The military laser range finder has added a new lethality to improve strategic artillary strikes and sniper shots through more accurate yardage distance measurement and strike calculations.

Today laser rangefinders have become so advanced that they are now integrated into many optical sighting equipment such as binoculars and rifle sights.

Having a laser range finder as a part of in field weaponry allows a higher liklihood of nutralizing the enemy along with conserving ammunition. It can also contribute to lessening stress under fire by the soldier being able to trust in the laser rangefinder to provide strike information quickly and accurately.

The civilian laser rangefinder becomes valuable for hunting expiditions, especially when attempting long range shots. Here the digital laser range finder scout assists in calculating distance, trajectory, and impact lethality. Commercially the laser rangefinder has many uses, especially in the construction industry giving way to the traditional tape measures and other estimation techniques.



From the field :: Hunting Essentials :: Laser Rangefinders

You cannot see as well with the naked eye as with a binocular. Look into thick cover and then look again with a 6x glass, and you will be amazed at how many openings, logs and other objects you failed to notice before come into focus. Game can see that well and even better.

One of the necessary qualities of a hunter's eye is proper perspective. When I first began hunting over 60 years ago, it was difficult for me to see game. The valleys were wide and the ridges far apart, yet the rarified atmosphere was so clear that objects stood out prominently at long distances.

In that clear mountain air I had no sense of how big rocks and trees might be or how far away. Before I obtained my first binocular, it took me a while to tell how far away a game animal was by its apparent size to my naked eye.

Many hunters who have done most of their shooting in forested areas are poor judges of distance on open country. They can't tell whether an animal is 200 or 600 metres away. Today we can correct this by using a laser rangefinder to check our naked eye judgement.

Laser rangefinders come in several makes and models and some give a direct reading for the distance as well as computing the bullet's trajectory. However, all the hunter really needs to know is the distance, which will tell him whether the game is within shooting range or he has to stalk closer. There are a number of affordable rangefinders that will do this.

Often game that shows up within shooting distance is alert, and there will be no need to range it. The ideal situation for using a laser rangefinder occurs when game is a long way off and undisturbed. This gives you plenty of time to range it and decide whether to risk a long shot or plan a stalk that will get you within sure hitting distance.

Rangefinders are excellent for helping you to establish distance firmly in your mind, if you take the trouble to make dry practice runs with them when you are not hunting. Look at an object with your naked eye and guess how far away it is, then check how accurate your estimate was.

The best way to prepare for a hunt is to spend a lot of time looking at objects through your binocular and rangefinder so that you can size them up quickly and efficiently. This applies not only to deer but to game a hunter should be familiar with in his home territory.

Devloping a good game eye may be easy or hard, depending upon your alertness, your ambition to excel as a hunter, and how hard you work at it. But your increased success and satisfaction will more than compensate you for your efforts.


Included in our above selection of laser rangefinders are a number of tactical laser sights to assist in acquiring targets with a visible dot signiture to mark the intended impact point. This can help with faster on target confirmation and low light situations where iron sights just can't compete. There are many different laser sighting systems each with a specific purpose, getting yours at these great prices can be very satisfying.

Military Laser Rangefinder Angle Compensation

The laser rangefinder can be used by the hunter, archer or even the golfer. Simply aim the laser rangefinder at your required target and recieve the required range information.


Laser Bore Sight Use And Instruction

Other products in this category are the laser bore sight to hone in your firearms accuracy with absolute pin point accuracy. We stock the best brands such as Nikon Laser Rangefinder, Bushnell Laser Rangefinders, Swarovski Laser Rangefinders and many more populars models such as the Scout 1000 ARC, Leica LRF 800 and some sporting military style camo coatings....

Vendor Samples...


Leupold :: RX-1000i TBR DNA Digital Laser Rangefinder

Leupold RX-1000 TBR Compact Digital Laser Rangefinder Camo

This lightweight, handheld, yardage rangefinder is a combat essential - it was specifically designed to greatly improve long range shooting, and generate accurate distances to longer range objects. The RX-1000i works best as a combat optic for a designated marksman or his spotter as it is limited to 1000 yards on reflective targets, but is very effective and consistent out to over 600 yards on soft targets.

The True Ballistic Range

(TBR) technology can be set up to give ballistic compensation in mils so it works quickly with the adjustments and mil-dot reticles on most DM-geared platforms. The optics are extremely clear and bright so it can be used as a 6X monocular as well. The RX-1000i employs an OLED dispiay which allows for 3X greater light transmission capability over competitive LCD screens, allowing for greater resolution in low light level situations. It weighs 8 ounces and uses CR2 lithium batteries.


How Do Laser Rangefinders WorkLaser rangefinders work by emitting laser beams at the push of a button. The beams bounce off distant objects and the rangefinder's high-speed clock measures the total time it took from when the beam left the unit untii it returned. Using that time measurement, the rangefinder calculates the distance and displays it to the user.


Ranging For The Modern Shooter

The old methods of range "estimation" have been largely replaced with laser rangeflnders. Knowing the exact distance to a long-range target is crucial, as a bullet's path or drop rate increases with distance. These tools have become advanced, with some models measuring well beyond any reasonable shooting distance and can even inform the shooter of uphill or downhill angles that reduce the effects of the earth's gravitational pull on the bullet's trajectory when compared to long-range shots over flat ground.

The Gunwerks "shooting system" includes a Laser Technology Trupulse G7 BR2 rangefinder. This unit has the ability to measure at distances out to 2,500 yards under ideal circumstances, but it also compensates for atmospheric conditions and gives a "corrected" yardage out to 1,400 yards. Reading wind speed and angle is also critical for long-range success, which can also be input into this unit for correction.


Leupold RX 1200i TBR/W Rangefinder

Leupold RX 1200i TBRW Laser Rangefinder Cheap

Compact and accuarate within 1/10th of a yard out to 1200 yards, the top product in Leupold's rangfinding line-up, gets you ranging right and ready for a confident shot.

The TBR (True Ballistic Range) and wind guage functions also tell you how much to compensate in elevation or drift according to calibre, your scope's zero distance, angle of shot and wind conditions, particularly if you are running Leupold's ballistic reticle.

I've been using the earlier 1000 model for a few years now and the sight picture is clear and the range-finding fast and accurate. It's also a very lightweight, compact and handy item you can keep close to hand if your binoculars don't have a range-finding feature.

A choice of reticles in a red that doesn't throwyour natural vision, 6x magnification, fully coated lenses, scan mode and a choice of yard and meter readings makes this one of the best choices among the current selection of dedicated rangefinders on the market.

Yeah, there are cheaper models, but in the last hour of light when you reach for your cheapie you'll be lucky if you can see anything let alone range effectively. This product does the job. And in bright orange camo, you're less likely to lose it when you put it down to take your shot.

Leupold Rangefinder RX 1200i TBRW DNA Laser For Sale

Opti-Logic

Opti Logic range finder

Originally designed for military and tactical purposes, the hunter-friendly Recon laser rangefinder features 6X magnification and a simple, easy-to-understand internal LCD display.

This unit ranges distances out to 1,000 yards. It also helps hunters hit what they aim at, because its VAC (Vertical Angle Compensation) technology compensates for the trajectory of arrows out to 120 yards and bullets out to 1,000 yards.

Sporting 6X magnification and an easy-to-read display, Opti-Logic's Recon laser rangefinder uses angle compensation software to help hunters compensate for trajectory.

Powered by a single long-life CR123A battery, the low-current draw of the compact and lightweight (less than 8 ounces) Recon will provide up to 2,500 "shots" on a single battery.

As with all Opti-Logic products, the Recon includes a full two-year warranty against manufacturer's defects. SRP: S359.95.


  View our Laser Rangefinder Reviews on the sidebar menu.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.7205910682678 924 0.8144 0


No Amazon API Requests Made.


App Debug - Total Time 1.7205910682678 seconds

Number Time From Start Name Description
1 0.43109011650085 Initialise Initialise FSB Function
2 0.44280195236206 App Controller Start Start of the App controller (called before the controller of every page)
3 0.50386309623718 App Controller End End of the App controller (called before the controller of every page)
4 0.50400710105896 Category Start Start of the category controller
5 0.50400996208191 Before Get Category Before getting the category information
6 0.53895807266235 After Get Category After getting the category information
7 0.53895902633667 Before Get Category List Before getting the updated category list
8 0.5390899181366 Start of getCategoryListByGroup Function Before first category groups query
9 0.53924989700317 After initial query Before first category groups query
10 0.53925108909607 Get Category List for Group Before the call to getCategoryList function
11 0.53925395011902 Start of GetCategoryList function Start of the function
12 0.53925800323486 Before getting categories Query to get specific category list
13 0.53978395462036 After getting categories Query to get specific category list
14 0.53978610038757 Before getting category custom Before call to function getCategoryCustom
15 0.54152512550354 After getting category custom After call to function getCategoryCustom
16 0.54152703285217 Before getting category custom Before call to function getCategoryCustom
17 0.55190491676331 After getting category custom After call to function getCategoryCustom
18 0.55190801620483 Before getting category custom Before call to function getCategoryCustom
19 0.55737805366516 After getting category custom After call to function getCategoryCustom
20 0.55738091468811 Before getting category custom Before call to function getCategoryCustom
21 0.56145095825195 After getting category custom After call to function getCategoryCustom
22 0.56145310401917 End of GetCategoryList function End of the function
23 0.56146097183228 Get Category List for Group Before the call to getCategoryList function
24 0.56146311759949 Start of GetCategoryList function Start of the function
25 0.56146502494812 Before getting categories Query to get specific category list
26 0.56187295913696 After getting categories Query to get specific category list
27 0.56187391281128 Before getting category custom Before call to function getCategoryCustom
28 0.56732296943665 After getting category custom After call to function getCategoryCustom
29 0.56732606887817 Before getting category custom Before call to function getCategoryCustom
30 0.57786512374878 After getting category custom After call to function getCategoryCustom
31 0.57786703109741 End of GetCategoryList function End of the function
32 0.57787299156189 Get Category List for Group Before the call to getCategoryList function
33 0.57787609100342 Start of GetCategoryList function Start of the function
34 0.57787895202637 Before getting categories Query to get specific category list
35 0.57854294776917 After getting categories Query to get specific category list
36 0.57854390144348 Before getting category custom Before call to function getCategoryCustom
37 0.58763790130615 After getting category custom After call to function getCategoryCustom
38 0.58764100074768 Before getting category custom Before call to function getCategoryCustom
39 0.60469102859497 After getting category custom After call to function getCategoryCustom
40 0.6046929359436 Before getting sub category list Before call to recursive function getCategoryList
41 0.60469603538513 Start of GetCategoryList function Start of the function
42 0.60469794273376 Before getting categories Query to get specific category list
43 0.60500812530518 After getting sub category list After call to recursive function getCategoryList
44 0.60500907897949 Before getting category custom Before call to function getCategoryCustom
45 0.61086010932922 After getting category custom After call to function getCategoryCustom
46 0.61086201667786 Before getting category custom Before call to function getCategoryCustom
47 0.61672592163086 After getting category custom After call to function getCategoryCustom
48 0.61672806739807 Before getting category custom Before call to function getCategoryCustom
49 0.6229190826416 After getting category custom After call to function getCategoryCustom
50 0.62292098999023 Before getting category custom Before call to function getCategoryCustom
51 0.64460301399231 After getting category custom After call to function getCategoryCustom
52 0.64460611343384 Before getting category custom Before call to function getCategoryCustom
53 0.64866209030151 After getting category custom After call to function getCategoryCustom
54 0.64866399765015 Before getting category custom Before call to function getCategoryCustom
55 0.65325307846069 After getting category custom After call to function getCategoryCustom
56 0.65325498580933 End of GetCategoryList function End of the function
57 0.65327000617981 Get Category List for Group Before the call to getCategoryList function
58 0.65327191352844 Start of GetCategoryList function Start of the function
59 0.65327501296997 Before getting categories Query to get specific category list
60 0.65369892120361 After getting categories Query to get specific category list
61 0.65370106697083 Before getting category custom Before call to function getCategoryCustom
62 0.65596103668213 After getting category custom After call to function getCategoryCustom
63 0.65596389770508 Before getting category custom Before call to function getCategoryCustom
64 0.65828990936279 After getting category custom After call to function getCategoryCustom
65 0.65829205513 End of GetCategoryList function End of the function
66 0.65829992294312 Get Category List for Group Before the call to getCategoryList function
67 0.65830206871033 Start of GetCategoryList function Start of the function
68 0.65830492973328 Before getting categories Query to get specific category list
69 0.658607006073 After getting categories Query to get specific category list
70 0.65860795974731 Before getting category custom Before call to function getCategoryCustom
71 0.66351294517517 After getting category custom After call to function getCategoryCustom
72 0.66351509094238 End of GetCategoryList function End of the function
73 0.66352105140686 End of getCategoryListByGroup Function Before return()
74 0.6635320186615 After Get Category List After getting the updated category list
75 0.66353297233582 Before Category Images Before getting the category images
76 0.66364908218384 After Category Images After getting the category images
77 0.66403102874756 Before Sub Category Check Before checking for sub category or products category
78 0.66429400444031 Before Category Products Controller Before loading the category products controller
79 0.66444301605225 Start Category Products Start of Category Products Controller
80 0.66446399688721 After Pagination Options After pagination options in Category Products Controller
81 0.66490793228149 After Cache After Cache checking in Category Products Controller
82 0.74325108528137 After Filter Options After getting filter options and SQL in Category Products Controller
83 0.75217509269714 After Counting Products After counting products in the Category Products Controller
84 0.75234603881836 After Counting Bundles After counting bundles in the Category Products Controller
85 0.75250101089478 After Counting Products After counting products in the Category Products Controller
86 0.76610398292542 After Getting Products After getting products and bundles in the Category Products Controller
87 0.76621699333191 After Pagination Links After getting pagination listing links in the Category Products Controller
88 0.76621794700623 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
89 0.86802411079407 After Getting Product Details After getting full product details in the Category Products Controller
90 0.87295007705688 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
91 0.87431192398071 App_after Controller Start Start of the App_after controller (called after the controller of every page)
92 0.87438893318176 Before Get Options Before the call to getOptions in the tpl class
93 1.2803220748901 After Get Options After the call to getOptions in the tpl class
94 1.280601978302 App_after Controller End End of the App_after controller (called after the controller of every page)
95 1.2806150913239 Before Smarty Before passing everything over to Smarty in the Category Products Controller
96 1.7205679416656 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
97 1.7205719947815 Finalizing debug Before the debug is output to the page.
98 1.7205889225006 End of App This is the end of the app logging, final timestamp


Query Debug - 924 Database Queries. Total time 0.8144 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00017905235290527
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00043892860412598
SHOW TABLES LIKE 'bad_bots'
3 0.0001 0.00014805793762207
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00014090538024902
SELECT * FROM `bad_bots`
5 0.0004 0.00044107437133789
SELECT parameter, value FROM parameters
6 0.0001 0.00013995170593262
SET time_zone = 'Europe/London'
7 0.0003 0.00027990341186523
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014400482177734
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 9.9897384643555E-5
delete from cachefiles
10 0.0002 0.00023293495178223
SELECT id FROM pages WHERE pagename = 'laser-rangefinders' LIMIT 1
11 0.0002 0.00020098686218262
SELECT id FROM products WHERE pagename = 'laser-rangefinders' AND hidden = 0 LIMIT 1
12 0.0001 0.00011205673217773
SELECT id FROM ebay_products WHERE pagename = 'laser-rangefinders'
13 0.0002 0.00015401840209961
SELECT id FROM categories WHERE pagename = 'laser-rangefinders' LIMIT 1
14 0.0008 0.00077319145202637
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
15 0.0099 0.0098569393157959
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
16 0.0002 0.00024700164794922
SELECT * FROM pages WHERE pagename = 'laser-rangefinders'
17 0.0053 0.0053040981292725
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0004 0.00037193298339844
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0002 0.00019001960754395
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
20 0.0002 0.00015783309936523
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
21 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '67'
22 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '82'
23 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '84'
24 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '94'
25 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '116'
26 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '52'
27 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '135'
28 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '245'
29 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '269'
30 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '275'
31 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '280'
32 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '357'
33 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '379'
34 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '401'
35 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '450'
36 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '454'
37 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '457'
38 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '458'
39 0.0002 0.0001518726348877
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
40 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '41'
41 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '43'
42 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '44'
43 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '68'
44 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '80'
45 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '85'
46 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '97'
47 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '107'
48 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '108'
49 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '128'
50 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '133'
51 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '148'
52 0.0002 0.00015521049499512
SELECT * FROM pages WHERE id = '217'
53 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '228'
54 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '257'
55 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '271'
56 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '286'
57 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '287'
58 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '291'
59 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '380'
60 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '344'
61 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '354'
62 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '363'
63 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '364'
64 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '368'
65 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '369'
66 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '400'
67 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '463'
68 0.0002 0.00016498565673828
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
69 0.0002 0.00023603439331055
SELECT * FROM pages WHERE id = '66'
70 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '77'
71 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '90'
72 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '414'
73 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '119'
74 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '406'
75 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '149'
76 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '150'
77 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '412'
78 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '162'
79 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '164'
80 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '167'
81 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '180'
82 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '187'
83 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '265'
84 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '268'
85 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '411'
86 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '290'
87 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '413'
88 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '409'
89 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '327'
90 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '336'
91 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '351'
92 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '358'
93 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '360'
94 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '362'
95 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '366'
96 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '370'
97 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '377'
98 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '386'
99 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '408'
100 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '415'
101 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '416'
102 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '419'
103 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '423'
104 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '427'
105 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '428'
106 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '432'
107 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '433'
108 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '436'
109 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '437'
110 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '461'
111 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '464'
112 0.0002 0.0001990795135498
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
113 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '74'
114 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '137'
115 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '145'
116 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '156'
117 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '407'
118 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '410'
119 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '266'
120 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '316'
121 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '332'
122 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '334'
123 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '367'
124 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '387'
125 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '389'
126 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '397'
127 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '449'
128 0.0002 0.00016117095947266
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
129 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '42'
130 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '79'
131 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '86'
132 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '95'
133 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '102'
134 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '109'
135 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '114'
136 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '121'
137 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '138'
138 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '142'
139 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '62'
140 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '157'
141 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '246'
142 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '276'
143 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '278'
144 0.0002 0.00018978118896484
SELECT * FROM pages WHERE id = '279'
145 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '317'
146 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '405'
147 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '343'
148 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '345'
149 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '346'
150 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '347'
151 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '348'
152 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '349'
153 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '381'
154 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '392'
155 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '393'
156 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '394'
157 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '395'
158 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '399'
159 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '421'
160 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '426'
161 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '430'
162 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '431'
163 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '434'
164 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '435'
165 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '440'
166 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '441'
167 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '451'
168 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '453'
169 0.0001 0.00014615058898926
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
170 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '146'
171 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '158'
172 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '163'
173 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '293'
174 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '340'
175 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '417'
176 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
177 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '173'
178 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '181'
179 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '288'
180 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '299'
181 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '300'
182 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '383'
183 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '385'
184 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '438'
185 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '442'
186 0.0001 0.00014805793762207
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
187 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '103'
188 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '134'
189 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '139'
190 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '143'
191 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '234'
192 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '248'
193 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '260'
194 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '398'
195 0.0002 0.00015115737915039
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
196 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '61'
197 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '87'
198 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '104'
199 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '115'
200 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '124'
201 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '144'
202 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '151'
203 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '199'
204 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '200'
205 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '304'
206 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '321'
207 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '333'
208 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '350'
209 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '378'
210 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '422'
211 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '425'
212 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '443'
213 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '444'
214 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '445'
215 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '446'
216 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '447'
217 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '448'
218 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '455'
219 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '456'
220 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '459'
221 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '460'
222 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '462'
223 0.0001 0.00014209747314453
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
224 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '153'
225 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '182'
226 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '238'
227 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '240'
228 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '242'
229 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = '252'
230 0.0001 0.00013518333435059
SELECT * FROM pages WHERE id = '253'
231 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = '262'
232 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '267'
233 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '420'
234 0.0001 0.00013089179992676
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
235 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
236 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
237 0.0014 0.0013501644134521
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
238 0.0003 0.00025296211242676
SELECT * FROM categories WHERE pagename = 'laser-rangefinders'
239 0.0083 0.0082800388336182
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
240 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 65
241 0.0003 0.00026822090148926
SELECT id FROM categories WHERE parent_id = '65'
242 0.0081 0.0081040859222412
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 
243 0.0002 0.00016689300537109
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 
244 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 (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
245 0.0002 0.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
246 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '65'
247 0.0082 0.0081779956817627
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (65) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
248 0.0002 0.00021910667419434
SELECT * FROM productimages WHERE product_id = '411184' ORDER BY sortorder ASC
249 0.0001 0.00011205673217773
SELECT * FROM categoryimages WHERE category_id = 65
250 0.0001 0.00012016296386719
SELECT * FROM categorygroups WHERE id = '10'
251 0.0081 0.0081079006195068
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '65'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
252 0.0002 0.00015592575073242
SELECT parent_id FROM categories WHERE id = '65'
253 0.0001 0.00011587142944336
SELECT parent_id FROM categories WHERE id = '65'
254 0.0001 0.00014495849609375
SELECT * FROM categorygroups ORDER BY sortorder ASC
255 0.0005 0.00048518180847168
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
256 0.0004 0.00042486190795898
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
257 0.0002 0.00021696090698242
SELECT id FROM categories WHERE parent_id = '49'
258 0.0004 0.00043988227844238
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 
259 0.0001 0.0001378059387207
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 
260 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
261 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
262 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '1'
263 0.0029 0.0029168128967285
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
264 0.0003 0.00026488304138184
SELECT id FROM categories WHERE parent_id = '50'
265 0.0002 0.00020503997802734
SELECT id FROM categories WHERE parent_id = '96'
266 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '97'
267 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '111'
268 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '129'
269 0.0056 0.0056419372558594
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 
270 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 (96,97,111,129,50)
				  AND p.disabled = 0 
271 0.0002 0.00015521049499512
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 
272 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
273 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '1'
274 0.0023 0.0022668838500977
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
275 0.0003 0.00025606155395508
SELECT id FROM categories WHERE parent_id = '80'
276 0.0023 0.0022859573364258
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 
277 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
278 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
279 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
280 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '1'
281 0.0011 0.0011389255523682
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
282 0.0003 0.00026321411132812
SELECT id FROM categories WHERE parent_id = '51'
283 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '101'
284 0.0018 0.0017740726470947
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 
285 0.0002 0.0001528263092041
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
286 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
287 0.0002 0.00016617774963379
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
288 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
289 0.0004 0.00038409233093262
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
290 0.0022 0.0022499561309814
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
291 0.0002 0.0002439022064209
SELECT id FROM categories WHERE parent_id = '30'
292 0.0023 0.0022780895233154
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 
293 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
294 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
295 0.0002 0.00016617774963379
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
296 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
297 0.0048 0.0047659873962402
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
298 0.0003 0.00026202201843262
SELECT id FROM categories WHERE parent_id = '61'
299 0.0048 0.0048198699951172
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 
300 0.0002 0.00015807151794434
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 
301 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
302 0.0002 0.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
303 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
304 0.0006 0.00060296058654785
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
305 0.0041 0.0040550231933594
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
306 0.0003 0.00027108192443848
SELECT id FROM categories WHERE parent_id = '64'
307 0.0041 0.0040791034698486
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 
308 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 (64)
				  AND p.disabled = 0 
309 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
310 0.0002 0.00016212463378906
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
311 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
312 0.0080 0.0079998970031738
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
313 0.0003 0.0002739429473877
SELECT id FROM categories WHERE parent_id = '65'
314 0.0081 0.0080668926239014
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 
315 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 (65)
				  AND p.disabled = 0 
316 0.0001 0.00014877319335938
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 
317 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
318 0.0001 0.00013518333435059
SELECT * FROM categorygroups WHERE id = '10'
319 0.0003 0.00029683113098145
SELECT * FROM categories WHERE parent_id = '65'  AND hidden = 0 ORDER BY sortorder ASC
320 0.0024 0.0024449825286865
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
321 0.0003 0.00025606155395508
SELECT id FROM categories WHERE parent_id = '81'
322 0.0025 0.0024669170379639
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 
323 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
324 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
325 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
326 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
327 0.0024 0.0024359226226807
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
328 0.0003 0.00025701522827148
SELECT id FROM categories WHERE parent_id = '31'
329 0.0025 0.0024850368499756
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 
330 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
331 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
332 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
333 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
334 0.0022 0.0022201538085938
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
335 0.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '66'
336 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '131'
337 0.0028 0.0028150081634521
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 
338 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
339 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
340 0.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
341 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
342 0.0094 0.0093898773193359
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
343 0.0003 0.00028085708618164
SELECT id FROM categories WHERE parent_id = '34'
344 0.0002 0.00020503997802734
SELECT id FROM categories WHERE parent_id = '94'
345 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '98'
346 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '99'
347 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '110'
348 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '130'
349 0.0102 0.010215044021606
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 
350 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 (94,98,99,110,130,34)
				  AND p.disabled = 0 
351 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
352 0.0002 0.00017714500427246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
353 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
354 0.0015 0.0015439987182617
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
355 0.0003 0.00025606155395508
SELECT id FROM categories WHERE parent_id = '32'
356 0.0016 0.0015730857849121
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 
357 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
358 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
359 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
360 0.0001 0.00014495849609375
SELECT * FROM categorygroups WHERE id = '10'
361 0.0018 0.001802921295166
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
362 0.0003 0.00026702880859375
SELECT id FROM categories WHERE parent_id = '89'
363 0.0018 0.0018310546875
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 
364 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 (89)
				  AND p.disabled = 0 
365 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
366 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
367 0.0001 0.00012421607971191
SELECT * FROM categorygroups WHERE id = '10'
368 0.0004 0.00039911270141602
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
369 0.0007 0.00066018104553223
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
370 0.0002 0.00022792816162109
SELECT id FROM categories WHERE parent_id = '84'
371 0.0007 0.00069379806518555
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 
372 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
373 0.0001 0.00014305114746094
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
374 0.0002 0.00016522407531738
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
375 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '17'
376 0.0007 0.00071001052856445
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
377 0.0002 0.00023317337036133
SELECT id FROM categories WHERE parent_id = '90'
378 0.0007 0.0007328987121582
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
379 0.0001 0.00014519691467285
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 
380 0.0001 0.00014281272888184
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 
381 0.0002 0.00015377998352051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
382 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '17'
383 0.0003 0.00028896331787109
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
384 0.0020 0.0019869804382324
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
385 0.0003 0.00025415420532227
SELECT id FROM categories WHERE parent_id = '92'
386 0.0020 0.0020079612731934
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 
387 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
388 0.0001 0.00014519691467285
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 
389 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
390 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '20'
391 0.0001 0.0001070499420166
SELECT * FROM categoryimages WHERE category_id = 65
392 0.0002 0.00016403198242188
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
393 0.0002 0.00024890899658203
SELECT * FROM categories WHERE parent_id = '65'
394 0.0319 0.031949996948242
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
395 0.0064 0.006350040435791
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
396 0.0003 0.00029492378234863
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
397 0.0319 0.031905889511108
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
398 0.0062 0.0062119960784912
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
399 0.0003 0.00029110908508301
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
400 0.0087 0.0086948871612549
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 65
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
401 0.0002 0.00019121170043945
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 65
		AND c.prod_type = 'ebay'
		AND hide = 1
402 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 65
			AND p.disabled = 0
			
			AND 1 = 1
403 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 65
		AND c.prod_type = 'custom'
		AND hide = 1
404 0.0135 0.013524055480957
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 65
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 65
		AND c.prod_type = 'ebay'
		AND p.hide = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 65
		AND c.prod_type = 'custom'
		AND p.hide = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 65
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
405 0.0002 0.0002439022064209
SELECT * FROM products WHERE id = '411184'
406 0.0002 0.00019979476928711
SELECT * FROM productimages WHERE product_id = '411184' ORDER BY sortorder ASC
407 0.0003 0.00031495094299316
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '411184' AND p.id = pi.product_id ORDER BY pi.sortorder
408 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '411184'
409 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '411184'
410 0.0003 0.0002901554107666
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '411184'
                GROUP BY o.product_id
411 0.0003 0.0003361701965332
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '411184'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
412 0.0002 0.00023794174194336
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 411184
413 0.0007 0.00068497657775879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411184' AND a.name = n.originalname
414 0.0002 0.00017595291137695
SELECT * FROM productoffers WHERE product_id = '411184' AND merchantid = 'ATVPDKIKX0DER'
415 0.0002 0.00018191337585449
SELECT * FROM productoffers
                WHERE product_id = '411184' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0002 0.00016021728515625
SELECT * FROM productoffers
                WHERE product_id = 411184
                ORDER BY price ASC LIMIT 1
417 0.0003 0.00027012825012207
SELECT value FROM productattributes
                WHERE product_id = '411184'
                AND name = 'ListPriceAmount'
418 0.0003 0.00026583671569824
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '411184'
                GROUP BY o.product_id
419 0.0003 0.00031089782714844
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '411184'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
420 0.0002 0.00024318695068359
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 411184
421 0.0004 0.00039887428283691
SELECT value FROM productattributes WHERE product_id = '411184' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
422 0.0001 0.00013113021850586
UPDATE products SET price = '8195' WHERE id = '411184'
423 0.0004 0.00035905838012695
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '411184'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
424 0.0002 0.00020813941955566
SELECT * FROM products WHERE id = '414235'
425 0.0002 0.00023984909057617
SELECT * FROM productimages WHERE product_id = '414235' ORDER BY sortorder ASC
426 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '414235'
427 0.0001 0.00011920928955078
SELECT * FROM productcustomimages WHERE product_id = '414235'
428 0.0026 0.002561092376709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414235' AND a.name = n.originalname
429 0.0002 0.00017619132995605
SELECT * FROM productoffers WHERE product_id = '414235' AND merchantid = 'ATVPDKIKX0DER'
430 0.0002 0.00017619132995605
SELECT * FROM productoffers
                WHERE product_id = '414235' AND price > 0
                ORDER BY price ASC LIMIT 1
431 0.0002 0.00016999244689941
SELECT * FROM productoffers
                WHERE product_id = 414235
                ORDER BY price ASC LIMIT 1
432 0.0002 0.00021696090698242
SELECT value FROM productattributes
                WHERE product_id = '414235'
                AND name = 'ListPriceAmount'
433 0.0001 0.00011992454528809
UPDATE products SET price = '29999' WHERE id = '414235'
434 0.0002 0.00021910667419434
SELECT * FROM products WHERE id = '414275'
435 0.0002 0.00021886825561523
SELECT * FROM productimages WHERE product_id = '414275' ORDER BY sortorder ASC
436 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '414275'
437 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '414275'
438 0.0081 0.0081460475921631
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414275' AND a.name = n.originalname
439 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '414275' AND merchantid = 'ATVPDKIKX0DER'
440 0.0002 0.00017905235290527
SELECT * FROM productoffers
                WHERE product_id = '414275' AND price > 0
                ORDER BY price ASC LIMIT 1
441 0.0002 0.00016498565673828
SELECT * FROM productoffers
                WHERE product_id = 414275
                ORDER BY price ASC LIMIT 1
442 0.0002 0.0002131462097168
SELECT value FROM productattributes
                WHERE product_id = '414275'
                AND name = 'ListPriceAmount'
443 0.0001 0.00013113021850586
UPDATE products SET price = '18997' WHERE id = '414275'
444 0.0002 0.00020217895507812
SELECT * FROM products WHERE id = '411822'
445 0.0001 0.00014901161193848
SELECT * FROM productimages WHERE product_id = '411822' ORDER BY sortorder ASC
446 0.0005 0.00048995018005371
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '411822' AND p.id = pi.product_id ORDER BY pi.sortorder
447 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '411822'
448 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '411822'
449 0.0002 0.00023388862609863
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '411822'
                GROUP BY o.product_id
450 0.0003 0.00028300285339355
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '411822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
451 0.0002 0.00019717216491699
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 411822
452 0.0030 0.0029630661010742
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411822' AND a.name = n.originalname
453 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '411822' AND merchantid = 'ATVPDKIKX0DER'
454 0.0002 0.00018501281738281
SELECT * FROM productoffers
                WHERE product_id = '411822' AND price > 0
                ORDER BY price ASC LIMIT 1
455 0.0002 0.00016093254089355
SELECT * FROM productoffers
                WHERE product_id = 411822
                ORDER BY price ASC LIMIT 1
456 0.0003 0.00025105476379395
SELECT value FROM productattributes
                WHERE product_id = '411822'
                AND name = 'ListPriceAmount'
457 0.0002 0.00022101402282715
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '411822'
                GROUP BY o.product_id
458 0.0003 0.00027203559875488
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '411822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
459 0.0002 0.00020480155944824
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 411822
460 0.0004 0.00038385391235352
SELECT value FROM productattributes WHERE product_id = '411822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
461 0.0003 0.00031805038452148
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '411822'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
462 0.0002 0.00022101402282715
SELECT * FROM products WHERE id = '413562'
463 0.0003 0.00033187866210938
SELECT * FROM productimages WHERE product_id = '413562' ORDER BY sortorder ASC
464 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '413562'
465 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '413562'
466 0.0030 0.0029940605163574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413562' AND a.name = n.originalname
467 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '413562' AND merchantid = 'ATVPDKIKX0DER'
468 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '413562' AND price > 0
                ORDER BY price ASC LIMIT 1
469 0.0004 0.00039792060852051
SELECT value FROM productattributes WHERE product_id = '413562' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
470 0.0001 0.00011897087097168
UPDATE products SET price = '9999' WHERE id = '413562'
471 0.0002 0.00020503997802734
SELECT * FROM products WHERE id = '412716'
472 0.0002 0.00017404556274414
SELECT * FROM productimages WHERE product_id = '412716' ORDER BY sortorder ASC
473 0.0003 0.0003209114074707
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '412716' AND p.id = pi.product_id ORDER BY pi.sortorder
474 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '412716'
475 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '412716'
476 0.0003 0.00026297569274902
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '412716'
                GROUP BY o.product_id
477 0.0003 0.00032997131347656
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '412716'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
478 0.0002 0.0002281665802002
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 412716
479 0.0021 0.0020809173583984
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412716' AND a.name = n.originalname
480 0.0002 0.00017404556274414
SELECT * FROM productoffers WHERE product_id = '412716' AND merchantid = 'ATVPDKIKX0DER'
481 0.0002 0.00017714500427246
SELECT * FROM productoffers
                WHERE product_id = '412716' AND price > 0
                ORDER BY price ASC LIMIT 1
482 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 412716
                ORDER BY price ASC LIMIT 1
483 0.0002 0.00023698806762695
SELECT value FROM productattributes
                WHERE product_id = '412716'
                AND name = 'ListPriceAmount'
484 0.0003 0.00027084350585938
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '412716'
                GROUP BY o.product_id
485 0.0003 0.00032401084899902
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '412716'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
486 0.0002 0.00022697448730469
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 412716
487 0.0004 0.00037097930908203
SELECT value FROM productattributes WHERE product_id = '412716' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
488 0.0001 0.0001220703125
UPDATE products SET price = '8598' WHERE id = '412716'
489 0.0004 0.00035405158996582
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '412716'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
490 0.0002 0.00020098686218262
SELECT * FROM products WHERE id = '410967'
491 0.0002 0.00017595291137695
SELECT * FROM productimages WHERE product_id = '410967' ORDER BY sortorder ASC
492 0.0002 0.00024986267089844
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '410967' AND p.id = pi.product_id ORDER BY pi.sortorder
493 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '410967'
494 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '410967'
495 0.0002 0.00021910667419434
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '410967'
                GROUP BY o.product_id
496 0.0003 0.00026488304138184
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '410967'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
497 0.0002 0.00019097328186035
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 410967
498 0.0006 0.00064802169799805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410967' AND a.name = n.originalname
499 0.0002 0.00017595291137695
SELECT * FROM productoffers WHERE product_id = '410967' AND merchantid = 'ATVPDKIKX0DER'
500 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '410967' AND price > 0
                ORDER BY price ASC LIMIT 1
501 0.0002 0.00015807151794434
SELECT * FROM productoffers
                WHERE product_id = 410967
                ORDER BY price ASC LIMIT 1
502 0.0003 0.00026297569274902
SELECT value FROM productattributes
                WHERE product_id = '410967'
                AND name = 'ListPriceAmount'
503 0.0002 0.00023198127746582
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '410967'
                GROUP BY o.product_id
504 0.0003 0.00025391578674316
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '410967'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
505 0.0002 0.00019001960754395
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 410967
506 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '410967' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
507 0.0001 0.00011992454528809
UPDATE products SET price = '27999' WHERE id = '410967'
508 0.0003 0.00030112266540527
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '410967'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
509 0.0002 0.00021219253540039
SELECT * FROM products WHERE parent_id = '410967'
510 0.0002 0.00020790100097656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410969' AND a.name = n.originalname
511 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '410969' AND merchantid = 'ATVPDKIKX0DER'
512 0.0002 0.00019478797912598
SELECT * FROM productoffers
                WHERE product_id = '410969' AND price > 0
                ORDER BY price ASC LIMIT 1
513 0.0002 0.00019717216491699
SELECT * FROM products WHERE id = '411183'
514 0.0004 0.00039100646972656
SELECT * FROM productimages WHERE product_id = '411183' ORDER BY sortorder ASC
515 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '411183'
516 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '411183'
517 0.0025 0.0024509429931641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411183' AND a.name = n.originalname
518 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '411183' AND merchantid = 'ATVPDKIKX0DER'
519 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '411183' AND price > 0
                ORDER BY price ASC LIMIT 1
520 0.0004 0.00037407875061035
SELECT value FROM productattributes WHERE product_id = '411183' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
521 0.0001 0.00011897087097168
UPDATE products SET price = '19900' WHERE id = '411183'
522 0.0002 0.00020503997802734
SELECT * FROM products WHERE id = '414569'
523 0.0002 0.00016522407531738
SELECT * FROM productimages WHERE product_id = '414569' ORDER BY sortorder ASC
524 0.0004 0.00043916702270508
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '414569' AND p.id = pi.product_id ORDER BY pi.sortorder
525 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '414569'
526 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '414569'
527 0.0002 0.000244140625
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '414569'
                GROUP BY o.product_id
528 0.0005 0.00046110153198242
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '414569'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
529 0.0002 0.00022006034851074
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 414569
530 0.0007 0.00071191787719727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414569' AND a.name = n.originalname
531 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '414569' AND merchantid = 'ATVPDKIKX0DER'
532 0.0002 0.00017619132995605
SELECT * FROM productoffers
                WHERE product_id = '414569' AND price > 0
                ORDER BY price ASC LIMIT 1
533 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 414569
                ORDER BY price ASC LIMIT 1
534 0.0003 0.00025415420532227
SELECT value FROM productattributes
                WHERE product_id = '414569'
                AND name = 'ListPriceAmount'
535 0.0003 0.00025486946105957
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '414569'
                GROUP BY o.product_id
536 0.0005 0.00045585632324219
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '414569'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
537 0.0002 0.00021791458129883
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 414569
538 0.0004 0.00040388107299805
SELECT value FROM productattributes WHERE product_id = '414569' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
539 0.0004 0.00037884712219238
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '414569'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
540 0.0004 0.00037884712219238
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '414569'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
541 0.0002 0.00021505355834961
SELECT * FROM products WHERE id = '414175'
542 0.0003 0.00028395652770996
SELECT * FROM productimages WHERE product_id = '414175' ORDER BY sortorder ASC
543 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '414175'
544 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414175'
545 0.0029 0.002924919128418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414175' AND a.name = n.originalname
546 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '414175' AND merchantid = 'ATVPDKIKX0DER'
547 0.0002 0.00017690658569336
SELECT * FROM productoffers
                WHERE product_id = '414175' AND price > 0
                ORDER BY price ASC LIMIT 1
548 0.0002 0.00016212463378906
SELECT * FROM productoffers
                WHERE product_id = 414175
                ORDER BY price ASC LIMIT 1
549 0.0002 0.00022315979003906
SELECT value FROM productattributes
                WHERE product_id = '414175'
                AND name = 'ListPriceAmount'
550 0.0001 0.00012087821960449
UPDATE products SET price = '26999' WHERE id = '414175'
551 0.0002 0.00020408630371094
SELECT * FROM products WHERE id = '405034'
552 0.0001 0.00014805793762207
SELECT * FROM productimages WHERE product_id = '405034' ORDER BY sortorder ASC
553 0.0002 0.00021600723266602
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '405034' AND p.id = pi.product_id ORDER BY pi.sortorder
554 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '405034'
555 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '405034'
556 0.0002 0.0002129077911377
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '405034'
                GROUP BY o.product_id
557 0.0003 0.00025701522827148
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '405034'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
558 0.0002 0.00018501281738281
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 405034
559 0.0007 0.00066900253295898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405034' AND a.name = n.originalname
560 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '405034' AND merchantid = 'ATVPDKIKX0DER'
561 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '405034' AND price > 0
                ORDER BY price ASC LIMIT 1
562 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 405034
                ORDER BY price ASC LIMIT 1
563 0.0002 0.00022101402282715
SELECT value FROM productattributes
                WHERE product_id = '405034'
                AND name = 'ListPriceAmount'
564 0.0002 0.00022196769714355
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '405034'
                GROUP BY o.product_id
565 0.0003 0.00025200843811035
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '405034'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
566 0.0002 0.00018501281738281
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 405034
567 0.0003 0.00032210350036621
SELECT value FROM productattributes WHERE product_id = '405034' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
568 0.0003 0.00031089782714844
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '405034'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
569 0.0002 0.0002131462097168
SELECT * FROM products WHERE parent_id = '405034'
570 0.0002 0.00022101402282715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405754' AND a.name = n.originalname
571 0.0002 0.00016093254089355
SELECT * FROM productoffers WHERE product_id = '405754' AND merchantid = 'ATVPDKIKX0DER'
572 0.0002 0.00018596649169922
SELECT * FROM productoffers
                WHERE product_id = '405754' AND price > 0
                ORDER BY price ASC LIMIT 1
573 0.0002 0.00015807151794434
SELECT * FROM productoffers
                WHERE product_id = 405754
                ORDER BY price ASC LIMIT 1
574 0.0002 0.00023484230041504
SELECT value FROM productattributes
                WHERE product_id = '405754'
                AND name = 'ListPriceAmount'
575 0.0002 0.0001978874206543
SELECT * FROM products WHERE id = '413547'
576 0.0004 0.00036311149597168
SELECT * FROM productimages WHERE product_id = '413547' ORDER BY sortorder ASC
577 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '413547'
578 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '413547'
579 0.0027 0.0027470588684082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413547' AND a.name = n.originalname
580 0.0002 0.00017499923706055
SELECT * FROM productoffers WHERE product_id = '413547' AND merchantid = 'ATVPDKIKX0DER'
581 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '413547' AND price > 0
                ORDER BY price ASC LIMIT 1
582 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 413547
                ORDER BY price ASC LIMIT 1
583 0.0002 0.0002281665802002
SELECT value FROM productattributes
                WHERE product_id = '413547'
                AND name = 'ListPriceAmount'
584 0.0001 0.0001220703125
UPDATE products SET price = '11599' WHERE id = '413547'
585 0.0002 0.00019502639770508
SELECT * FROM products WHERE id = '414368'
586 0.0001 0.00014591217041016
SELECT * FROM productimages WHERE product_id = '414368' ORDER BY sortorder ASC
587 0.0002 0.00020003318786621
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '414368' AND p.id = pi.product_id ORDER BY pi.sortorder
588 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '414368'
589 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '414368'
590 0.0002 0.00020003318786621
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '414368'
                GROUP BY o.product_id
591 0.0002 0.00022506713867188
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '414368'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
592 0.0002 0.00017285346984863
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 414368
593 0.0005 0.00052380561828613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414368' AND a.name = n.originalname
594 0.0002 0.00017094612121582
SELECT * FROM productoffers WHERE product_id = '414368' AND merchantid = 'ATVPDKIKX0DER'
595 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '414368' AND price > 0
                ORDER BY price ASC LIMIT 1
596 0.0002 0.00015902519226074
SELECT * FROM productoffers
                WHERE product_id = 414368
                ORDER BY price ASC LIMIT 1
597 0.0003 0.0002892017364502
SELECT value FROM productattributes
                WHERE product_id = '414368'
                AND name = 'ListPriceAmount'
598 0.0002 0.00020003318786621
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '414368'
                GROUP BY o.product_id
599 0.0002 0.00022411346435547
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '414368'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
600 0.0002 0.00017213821411133
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 414368
601 0.0005 0.00048208236694336
SELECT value FROM productattributes WHERE product_id = '414368' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
602 0.0002 0.00019502639770508
SELECT * FROM products WHERE parent_id = '414368'
603 0.0002 0.00020289421081543
SELECT * FROM products WHERE id = '413106'
604 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '413106' ORDER BY sortorder ASC
605 0.0004 0.00036406517028809
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '413106' AND p.id = pi.product_id ORDER BY pi.sortorder
606 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '413106'
607 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '413106'
608 0.0002 0.00023317337036133
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '413106'
                GROUP BY o.product_id
609 0.0003 0.00029206275939941
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '413106'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
610 0.0002 0.0001978874206543
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 413106
611 0.0032 0.0032479763031006
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '413106' AND a.name = n.originalname
612 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '413106' AND merchantid = 'ATVPDKIKX0DER'
613 0.0002 0.00017690658569336
SELECT * FROM productoffers
                WHERE product_id = '413106' AND price > 0
                ORDER BY price ASC LIMIT 1
614 0.0002 0.00015997886657715
SELECT * FROM productoffers
                WHERE product_id = 413106
                ORDER BY price ASC LIMIT 1
615 0.0003 0.00026893615722656
SELECT value FROM productattributes
                WHERE product_id = '413106'
                AND name = 'ListPriceAmount'
616 0.0002 0.00023913383483887
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '413106'
                GROUP BY o.product_id
617 0.0003 0.0002899169921875
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '413106'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
618 0.0002 0.0001981258392334
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 413106
619 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '413106' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
620 0.0003 0.0003359317779541
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '413106'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
621 0.0002 0.00020194053649902
SELECT * FROM products WHERE id = '414321'
622 0.0002 0.0002138614654541
SELECT * FROM productimages WHERE product_id = '414321' ORDER BY sortorder ASC
623 0.0002 0.00021982192993164
SELECT * FROM product_image_select WHERE product_id = '414321'
624 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '414321'
625 0.0025 0.0024878978729248
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414321' AND a.name = n.originalname
626 0.0002 0.00017404556274414
SELECT * FROM productoffers WHERE product_id = '414321' AND merchantid = 'ATVPDKIKX0DER'
627 0.0002 0.00018501281738281
SELECT * FROM productoffers
                WHERE product_id = '414321' AND price > 0
                ORDER BY price ASC LIMIT 1
628 0.0002 0.00016093254089355
SELECT * FROM productoffers
                WHERE product_id = 414321
                ORDER BY price ASC LIMIT 1
629 0.0002 0.00021505355834961
SELECT value FROM productattributes
                WHERE product_id = '414321'
                AND name = 'ListPriceAmount'
630 0.0001 0.00012087821960449
UPDATE products SET price = '9997' WHERE id = '414321'
631 0.0002 0.00019407272338867
SELECT * FROM products WHERE id = '414305'
632 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '414305' ORDER BY sortorder ASC
633 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '414305'
634 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '414305'
635 0.0031 0.0031421184539795
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414305' AND a.name = n.originalname
636 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '414305' AND merchantid = 'ATVPDKIKX0DER'
637 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '414305' AND price > 0
                ORDER BY price ASC LIMIT 1
638 0.0004 0.00040888786315918
SELECT value FROM productattributes WHERE product_id = '414305' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
639 0.0001 0.00011801719665527
UPDATE products SET price = '15899' WHERE id = '414305'
640 0.0002 0.00019693374633789
SELECT * FROM products WHERE id = '404742'
641 0.0002 0.00016617774963379
SELECT * FROM productimages WHERE product_id = '404742' ORDER BY sortorder ASC
642 0.0002 0.00020503997802734
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '404742' AND p.id = pi.product_id ORDER BY pi.sortorder
643 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '404742'
644 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '404742'
645 0.0002 0.00020003318786621
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '404742'
                GROUP BY o.product_id
646 0.0002 0.00023603439331055
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '404742'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
647 0.0002 0.00017285346984863
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 404742
648 0.0007 0.00065708160400391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404742' AND a.name = n.originalname
649 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '404742' AND merchantid = 'ATVPDKIKX0DER'
650 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '404742' AND price > 0
                ORDER BY price ASC LIMIT 1
651 0.0002 0.00015807151794434
SELECT * FROM productoffers
                WHERE product_id = 404742
                ORDER BY price ASC LIMIT 1
652 0.0002 0.000244140625
SELECT value FROM productattributes
                WHERE product_id = '404742'
                AND name = 'ListPriceAmount'
653 0.0002 0.0001981258392334
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '404742'
                GROUP BY o.product_id
654 0.0002 0.00023198127746582
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '404742'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
655 0.0002 0.00017094612121582
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 404742
656 0.0004 0.00036311149597168
SELECT value FROM productattributes WHERE product_id = '404742' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
657 0.0002 0.00019097328186035
SELECT * FROM products WHERE parent_id = '404742'
658 0.0002 0.0001978874206543
SELECT * FROM products WHERE id = '412986'
659 0.0002 0.00023007392883301
SELECT * FROM productimages WHERE product_id = '412986' ORDER BY sortorder ASC
660 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '412986'
661 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '412986'
662 0.0035 0.0034599304199219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412986' AND a.name = n.originalname
663 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '412986' AND merchantid = 'ATVPDKIKX0DER'
664 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '412986' AND price > 0
                ORDER BY price ASC LIMIT 1
665 0.0004 0.00043082237243652
SELECT value FROM productattributes WHERE product_id = '412986' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
666 0.0001 0.00011897087097168
UPDATE products SET price = '9999' WHERE id = '412986'
667 0.0003 0.00030803680419922
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '411184' ORDER BY timestamp DESC
668 0.0003 0.00026106834411621
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '414235' ORDER BY timestamp DESC
669 0.0003 0.00025820732116699
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '414275' ORDER BY timestamp DESC
670 0.0003 0.00025415420532227
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '411822' ORDER BY timestamp DESC
671 0.0003 0.00025415420532227
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '413562' ORDER BY timestamp DESC
672 0.0003 0.00026607513427734
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '412716' ORDER BY timestamp DESC
673 0.0003 0.00025510787963867
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '410967' ORDER BY timestamp DESC
674 0.0003 0.00025415420532227
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '411183' ORDER BY timestamp DESC
675 0.0003 0.00025200843811035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '414569' ORDER BY timestamp DESC
676 0.0003 0.00026416778564453
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '414175' ORDER BY timestamp DESC
677 0.0003 0.00025391578674316
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '405034' ORDER BY timestamp DESC
678 0.0003 0.00025200843811035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '413547' ORDER BY timestamp DESC
679 0.0003 0.00025415420532227
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '414368' ORDER BY timestamp DESC
680 0.0003 0.00026202201843262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '413106' ORDER BY timestamp DESC
681 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '414321' ORDER BY timestamp DESC
682 0.0003 0.00025200843811035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '414305' ORDER BY timestamp DESC
683 0.0003 0.0002589225769043
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '404742' ORDER BY timestamp DESC
684 0.0003 0.00025391578674316
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '412986' ORDER BY timestamp DESC
685 0.0002 0.00016403198242188
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 65
		AND c.prod_type = 'ebay'
		AND hide = 1
686 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
687 0.0001 0.00012016296386719
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
688 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
689 0.0001 0.00012612342834473
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
690 0.0001 0.00012087821960449
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
691 0.0001 0.00013303756713867
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
692 0.0002 0.00015902519226074
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
693 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = 2
694 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 4
695 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 12
696 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 10
697 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 7
698 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = 18
699 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = 28
700 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = 13
701 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 3
702 0.0425 0.042484045028687
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
703 0.0002 0.000244140625
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:1560775566;s:8:\"products\";a:6:{i:4;s:6:\"410588\";i:8;s:6:\"183732\";i:12;s:6:\"403517\";i:13;s:6:\"414825\";i:15;s:6:\"406758\";i:16;s:6:\"407620\";}}' WHERE id = '175'
704 0.0004 0.00043606758117676
SELECT * FROM products WHERE id IN (410588,183732,403517,414825,406758,407620) ORDER BY FIELD(id, 410588,183732,403517,414825,406758,407620 )
705 0.0002 0.00019407272338867
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
706 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '410588'
707 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '410588'
708 0.0020 0.0020170211791992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
709 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
710 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
711 0.0004 0.0003669261932373
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
712 0.0001 0.0001220703125
UPDATE products SET price = '269999' WHERE id = '410588'
713 0.0002 0.0001671314239502
SELECT * FROM productimages WHERE product_id = '183732' ORDER BY sortorder ASC
714 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '183732'
715 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '183732'
716 0.0027 0.0026729106903076
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '183732' AND a.name = n.originalname
717 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '183732' AND merchantid = 'ATVPDKIKX0DER'
718 0.0002 0.00020980834960938
SELECT * FROM productoffers
                WHERE product_id = '183732' AND price > 0
                ORDER BY price ASC LIMIT 1
719 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '183732' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
720 0.0001 0.0001220703125
UPDATE products SET price = '38249' WHERE id = '183732'
721 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
722 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '403517'
723 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '403517'
724 0.0029 0.0029299259185791
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
725 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
726 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
727 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
728 0.0001 0.00012111663818359
UPDATE products SET price = '6699' WHERE id = '403517'
729 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
730 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '414825'
731 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '414825'
732 0.0020 0.0019891262054443
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
733 0.0002 0.0001990795135498
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
734 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
735 0.0004 0.00035595893859863
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
736 0.0001 0.00011801719665527
UPDATE products SET price = '11999' WHERE id = '414825'
737 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
738 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '406758'
739 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '406758'
740 0.0026 0.0025951862335205
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
741 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
742 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
743 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
744 0.0001 0.00012803077697754
UPDATE products SET price = '2694' WHERE id = '406758'
745 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
746 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '407620'
747 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '407620'
748 0.0023 0.0022571086883545
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
749 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
750 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
751 0.0004 0.00036191940307617
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
752 0.0001 0.00011897087097168
UPDATE products SET price = '20323' WHERE id = '407620'
753 0.0424 0.042434930801392
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
754 0.0002 0.00023603439331055
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:1560775566;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:16;s:6:\"407620\";i:18;s:6:\"127345\";i:2;s:6:\"290575\";i:3;s:6:\"171938\";i:4;s:6:\"410588\";}}' WHERE id = '177'
755 0.0004 0.00044608116149902
SELECT * FROM products WHERE id IN (398315,407620,127345,290575,171938,410588) ORDER BY FIELD(id, 398315,407620,127345,290575,171938,410588 )
756 0.0002 0.00021600723266602
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
757 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '398315'
758 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '398315'
759 0.0025 0.0025019645690918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
760 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
761 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
762 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
763 0.0001 0.0001218318939209
UPDATE products SET price = '1999' WHERE id = '398315'
764 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
765 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '407620'
766 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '407620'
767 0.0023 0.0022671222686768
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
768 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
769 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
770 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
771 0.0001 0.00011777877807617
UPDATE products SET price = '20323' WHERE id = '407620'
772 0.0003 0.00029087066650391
SELECT * FROM productimages WHERE product_id = '127345' ORDER BY sortorder ASC
773 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '127345'
774 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '127345'
775 0.0026 0.0026390552520752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '127345' AND a.name = n.originalname
776 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '127345' AND merchantid = 'ATVPDKIKX0DER'
777 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '127345' AND price > 0
                ORDER BY price ASC LIMIT 1
778 0.0004 0.0003812313079834
SELECT value FROM productattributes WHERE product_id = '127345' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
779 0.0001 0.00011897087097168
UPDATE products SET price = '21963' WHERE id = '127345'
780 0.0006 0.00056815147399902
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
781 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '290575'
782 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '290575'
783 0.0034 0.0033860206604004
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
784 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
785 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
786 0.0004 0.00043010711669922
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
787 0.0001 0.00011897087097168
UPDATE products SET price = '549500' WHERE id = '290575'
788 0.0006 0.00059318542480469
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
789 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '171938'
790 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '171938'
791 0.0025 0.0025379657745361
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
792 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
793 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
794 0.0004 0.00037884712219238
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
795 0.0001 0.00011801719665527
UPDATE products SET price = '389500' WHERE id = '171938'
796 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
797 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '410588'
798 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '410588'
799 0.0020 0.0019989013671875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
800 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
801 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
802 0.0004 0.00035214424133301
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
803 0.0001 0.00011897087097168
UPDATE products SET price = '269999' WHERE id = '410588'
804 0.1041 0.1040780544281
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
805 0.0003 0.00026488304138184
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:1560775566;s:8:\"products\";a:6:{i:4;s:6:\"410588\";i:6;s:6:\"412927\";i:10;s:6:\"103845\";i:13;s:6:\"414825\";i:18;s:6:\"127345\";i:22;s:6:\"408079\";}}' WHERE id = '181'
806 0.0004 0.0004429817199707
SELECT * FROM products WHERE id IN (410588,412927,103845,414825,127345,408079) ORDER BY FIELD(id, 410588,412927,103845,414825,127345,408079 )
807 0.0002 0.00019693374633789
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
808 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '410588'
809 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '410588'
810 0.0020 0.0020270347595215
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
811 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
812 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
813 0.0004 0.00036215782165527
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
814 0.0001 0.00012397766113281
UPDATE products SET price = '269999' WHERE id = '410588'
815 0.0003 0.00025391578674316
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
816 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '412927'
817 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '412927'
818 0.0036 0.0036451816558838
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
819 0.0002 0.00018119812011719
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
820 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
821 0.0005 0.00045013427734375
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
822 0.0001 0.00012087821960449
UPDATE products SET price = '199900' WHERE id = '412927'
823 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
824 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '103845'
825 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '103845'
826 0.0024 0.0024049282073975
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
827 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
828 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
829 0.0004 0.00037002563476562
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
830 0.0001 0.00011801719665527
UPDATE products SET price = '11900' WHERE id = '103845'
831 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
832 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '414825'
833 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '414825'
834 0.0020 0.0019891262054443
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
835 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
836 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
837 0.0004 0.0003662109375
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
838 0.0001 0.00012087821960449
UPDATE products SET price = '11999' WHERE id = '414825'
839 0.0003 0.00029110908508301
SELECT * FROM productimages WHERE product_id = '127345' ORDER BY sortorder ASC
840 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '127345'
841 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '127345'
842 0.0026 0.0026390552520752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '127345' AND a.name = n.originalname
843 0.0002 0.00018215179443359
SELECT * FROM productoffers WHERE product_id = '127345' AND merchantid = 'ATVPDKIKX0DER'
844 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '127345' AND price > 0
                ORDER BY price ASC LIMIT 1
845 0.0004 0.00037980079650879
SELECT value FROM productattributes WHERE product_id = '127345' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
846 0.0001 0.00011897087097168
UPDATE products SET price = '21963' WHERE id = '127345'
847 0.0002 0.00017309188842773
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
848 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '408079'
849 0.0001 0.00013208389282227
SELECT * FROM productcustomimages WHERE product_id = '408079'
850 0.0032 0.0032000541687012
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
851 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
852 0.0002 0.00020217895507812
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
853 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
854 0.0001 0.00012302398681641
UPDATE products SET price = '20106' WHERE id = '408079'
855 0.1032 0.10321998596191
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
856 0.0003 0.00027704238891602
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:1560775566;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:1;s:6:\"407595\";i:6;s:6:\"412927\";i:14;s:6:\"414188\";i:17;s:6:\"408078\";i:21;s:6:\"410949\";}}' WHERE id = '183'
857 0.0005 0.00045299530029297
SELECT * FROM products WHERE id IN (398315,407595,412927,414188,408078,410949) ORDER BY FIELD(id, 398315,407595,412927,414188,408078,410949 )
858 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
859 0.0002 0.00022792816162109
SELECT * FROM product_image_select WHERE product_id = '398315'
860 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '398315'
861 0.0025 0.0025110244750977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
862 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
863 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
864 0.0004 0.0003812313079834
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
865 0.0001 0.00012397766113281
UPDATE products SET price = '1999' WHERE id = '398315'
866 0.0002 0.00023388862609863
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
867 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '407595'
868 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '407595'
869 0.0033 0.0033349990844727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
870 0.0002 0.00019407272338867
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
871 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
872 0.0004 0.00042009353637695
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
873 0.0001 0.00012302398681641
UPDATE products SET price = '2497' WHERE id = '407595'
874 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
875 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '412927'
876 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '412927'
877 0.0036 0.0035848617553711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
878 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
879 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
880 0.0004 0.00044512748718262
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
881 0.0001 0.0001220703125
UPDATE products SET price = '199900' WHERE id = '412927'
882 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
883 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '414188'
884 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414188'
885 0.0028 0.0027549266815186
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
886 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
887 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
888 0.0004 0.00038313865661621
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
889 0.0001 0.00012087821960449
UPDATE products SET price = '9999' WHERE id = '414188'
890 0.0002 0.00019979476928711
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
891 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '408078'
892 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '408078'
893 0.0031 0.0030639171600342
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
894 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
895 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
896 0.0004 0.00041508674621582
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
897 0.0001 0.00012397766113281
UPDATE products SET price = '23352' WHERE id = '408078'
898 0.0002 0.00016903877258301
SELECT * FROM productimages WHERE product_id = '410949' ORDER BY sortorder ASC
899 0.0002 0.00020384788513184
SELECT * FROM product_image_select WHERE product_id = '410949'
900 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '410949'
901 0.0027 0.0026700496673584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410949' AND a.name = n.originalname
902 0.0002 0.00018620491027832
SELECT * FROM productoffers WHERE product_id = '410949' AND merchantid = 'ATVPDKIKX0DER'
903 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '410949' AND price > 0
                ORDER BY price ASC LIMIT 1
904 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '410949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
905 0.0001 0.00011801719665527
UPDATE products SET price = '47995' WHERE id = '410949'
906 0.0004 0.00040793418884277
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
907 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
908 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
909 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
910 0.0001 0.00011706352233887
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
911 0.0004 0.00039792060852051
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
912 0.0001 0.00012493133544922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
913 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
914 0.0009 0.00089287757873535
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
915 0.0003 0.00030803680419922
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
916 0.0003 0.00027990341186523
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
917 0.0004 0.00038814544677734
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
918 0.0002 0.00015497207641602
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
919 0.0001 0.00012493133544922
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
920 0.0001 0.00011992454528809
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
921 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
922 0.0001 0.00011682510375977
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
923 0.0004 0.00035595893859863
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
924 0.0003 0.00031900405883789
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'