Ford GT40 Ford V8 1966

General description : 1966 Holman-Moody Mk II Roadster
VIN - P-202
Engine - 427 V8
Transaxle - T-44 4-speed
Red with Black Interior

Highlights of this Holman-Moody Mk II Roadster

- Historically accurate roadster constructed by Lee Holman
- FIA eligible 7-liter with potential acceptance to world class events
- A superb Mk II proven with video track footage taken at Lime Rock

History of the Original Mk II

The 1960s was one of the most impressive decades of sports car performance engineering. Racing and production sports car development shared significant advances benefiting greatly from the overlap between advancing aerospace technology, material sciences, and horsepower wars. Conceived and developed by a Who’s Who of motorsports engineering, the Holman-Moody Mk II has become an American performance dreamscape, one that defines this extraordinary convergence of engineering, competition, and courage.

The origin of the Mark I and II is framed by Ford’s advances to Ferrari for a potential company purchase. After spending millions of dollars to investigate the financial health of Ferrari, Ford quickly learned of the challenges dealing with Enzo Ferrari. As negotiations advanced, CEO Henry Ford II was stunned when Ferrari pulled out of negotiations. The infuriated “Hank the Deuce” vowed to beat Ferrari at his own game, setting his sights and formidable resources on racing. After initial development in 1963, the first Mk I was completed in 1964, but arrived with less than promising results. Later that year, Ford delivered the project to Shelby American who would gradually improve the cars, refine the chassis, and begin establishing the Mk I as a force to be reckoned with. Eventually the more robust and highly capable Mk II would introduce the impressive Ford FE 427 big-block V8 mated to a T44 4-speed. The Mk II would rise to prominence, culminating in the 1, 2, 3 Le Mans photo finish that would captivate the world, becoming the subject of the award winning contemporary major motion picture film “Ford vs Ferrari”. In addition to the Le Mans sweep, the Mk II would bring Ford the 1966 Manufacturers Championship.

With significant differences in construction and performance, both the Mk I and Mk II occupy important places in the history of these great cars. However, the Mk II is considered the premier engineering example brought together by Carroll Shelby, Holman-Moody, Ken Miles, and a host of exceptionally talented team members, all of whom contributed to the success and legacy of these cars. The 427 powered Mk II not only allowed for 200+mph speeds at Mulsanne, the power and durability of the engine, 427 power handled by the Ford-developed T44 transaxle, robust monocoque structure, and larger brakes elevated the Mk II to the legendary winning status that built their vaulted worldwide reputation.

Holman-Moody History and Build Specifications

As the FIA manufacturer of record for Mk II cars, Holman-Moody remains today the only source for an accurate original build of the Le Mans winning Mk II. Today a genuine Mk II captures a rightfully important place in the pantheon of premier collector vehicles. And while a handful of contemporary shops offer kits that replicate approximate dimensions and performance of the original Mk I cars, only one company has the name, history, tooling, precise records, blueprints, and historic fabrication experience to faithfully construct a genuine race-ready continuation of the original Mk II – Holman-Moody of Charlotte, NC.

Operating today as an ongoing force in motorsports excellence, Lee Holman has continued the legacy of his father and partner developing the most accurate Mk II, an FIA approved Mk II of precise specifications. Constructed using the original blueprints for these ground-breaking cars, Holman’s cars use chassis fabricated by Tennent Panels, UK, the official supplier of Mk II chassis at the close of the racing program. and the original forming bucks to build the chassis for these specialized cars. Uninterested in building a copy or replica, every effort has been made to assemble the most original Mk II possible. When the owner of this car commissioned the build a few years ago, Lee Holman, at 6’ 2”, wanted to improve the fit of his personally configured Mk II. With Holman evaluating internal construction plans for a roadster, he suggested the roadster configuration for this build. Originally built as an experiment in lightweight construction, the Mk II roadster that was built in period, has not survived. This car is an exact continuation of that car, enhanced with only safety-related improvements.

Construction of this Holman-Moody Mk II roadster was performed at Holman over a period of over a year as Lee Holman, Jim Rose and other team members who were personally involved in the original Mk II build team crafted this car. Having retained an original and uniquely formed Mk II roadster windshield when Holman-Moody were building the five original Mk II roadsters, Lee Holman offered to build this first and only Mk II continuation roadster. As the first Mk II roadster was constructed using alloy panels for some of the structure, these riveted alloy panels quickly weakened under the rigors of Sebring competition. In this build, steel panels were used to form a safer and more durable monocoque structure. In addition to the Tennent Panels construction using original Ford jigs and tooling, the pressed steel monocoque structure was formed to specifications at Holman-Moody by Jimmy Tucker and Jim Rose, both of whom were members of the racing team for Ford at Le Mans. Further improvements were engineered into this roadster design including a full B column and chromoly bar fitted to the side and back edges of the windshield. Two removable side bars were also installed, linking the windshield structure to the rear brace. This closed roll bar construction allows acceptance to racetracks that require full roll bar protection and improves overall structural rigidity under the stresses of racing. Additional features further included relocation of a 1967 spec. dry sump oil tank now installed behind the driver instead of over the driver’s feet. Like many components on this car, the oil system itself is bespoke in detail consisting of a magnesium cast oil pan with gear-driven scavenge pumps inside the crankcase and Mk II B style aluminum rear oil tank.

This example was completed in 2020 and is outfitted with a host of exceptional features including a Jimmy Tucker built FE 427 medium riser cast iron block with aluminum heads and intake, single Holley 4-barrel carburetor, and dry sump oiling system, linked to a magnesium case Holman-Moody Kar-Kraft T-44 4-Speed transaxle. In addition to the numerous construction details surrounding this car, the build consists of Halibrand magnesium wheels with knock off hubs, and 2.260” stainless-steel “bundle of snakes” headers.

The independent double wishbone front suspension, anti-roll bar, adjustable shocks with coil over springs and double trailing arm rear suspension are identical to the original Mk II and use cast magnesium uprights at all four corners. Front and rear Girling CR type calipers and 11.56” ventilated disc brakes with Girling master, Aeroquip lines and fittings, are also interchangeable with original Mk II Holman-Moody cars. The fuel delivery system consists of two fuel cells, each with its own fuel pump. The overall development, refinement, and absolute adherence to the original design with further improvement for added safety and durability come together in a stunning presentation worthy of the Mark I and Mark II legacy, the legends that created it, and the heroes that raced these great cars to victory.

General Overview

Presenting with test mileage only and beautiful factory original finishes. This Holman-Moody Mk II roadster is exceptional at every level. Finished in gleaming red and white livery, reflective of the original Sebring roadster, no longer in existence, the white rocker panel stripes and #1 roundels depict the first roadster as it was when it won the 1966 Sebring race. The superbly crafted body panels feature all the hallmark Mk II features including NACA ducts, rear scoops, and side intake scoops. The glass, lenses, and exterior body trim are all in excellent cosmetic condition. There are no chips or scratches in the expansive wrap-around windshield, a unique and original unit specially constructed in the 1960s only for the roadster design. Fit and finish for the body panels is excellent throughout with exceptional stance and perfect wheel and tire fit. The Halibrand 8 x 15 rear and 6 x 15 front wheels feature center hub knock offs and Goodyear Blue Streak Sport Car Special tires. The total visual package delivers a menacing presence, finished off by a polished aluminum airfoil, in place for added high speed stability.

Stepping up to the driver’s door, the latch is easily accessed as the door swings open. In roadster configuration, the ease of entrance is greatly appreciated as the driver and passenger slip into the cockpit. The removable steering wheel further improves ingress and egress. The seating position has been improved significantly under 6’ 2” Lee Holman’s direction inviting owners of taller stature to enjoy the magic of these cars. The interior displays historically accurate finishes including ventilated seats, displaying the now iconic brass grommet ventilation holes, which are historically accurate. The current seats also are padded to provide a more upright driving position since the original laid-back position is no longer required by a low roof. The.race-specification dashboard, internal build details, exposed rivet construction, offside gear selector, correctly labeled toggle switches, correct instrumentation, and Sparco multi-point seat harnesses all convey the power and performance of this rare roadster.

Lifting the hinged clamshell rear deck, the ground-breaking 427 V8 engine is a feast for the eyes. Though it’s difficult to decide where to look first, the warmly hued stainless-steel bundle-of-snakes exhaust commands your attention, exiting just under the aluminum heads, rising to gather over the T-44 magnesium case gearbox. The massive rear tires, exposed coil-over suspension, flanking twin pumps and Holman-Moody 427 branded valve covers deliver a satisfying narrative celebrating the historic excellence of these great cars. The removable front cover reveals a clean and tidy forward bulkhead containing a FireSense fire bottle feeding the fire suppression system plumbed throughout the car. The entire front section can also be removed which reveals twin electric cooling fans. Fluidyne High Performance radiator, and internal air ducting. The sophisticated engineering and artful construction are evident in every weld line, rivet, and carefully placed lightening hole – true to the original in every respect. The undercarriage displays evidence of the original construction methods employed to create the sophisticated welded steel monocoque. Suspension and various exposed components are further in excellent condition including the cast magnesium oil pan, magnesium cast gearbox, sophisticated suspension uprights, half shafts, coil-over shock absorbers, and Girling disc brakes.

The car starts easily, setting off a raucous V8 sound that goes straight to the soul of any motorsport’s enthusiast. Once warmed, the settled idle lopes in waiting, eager for higher revs and track action. Seating position is excellent with great forward visibility and command over the mid-engine layout. As use is primarily focused on racing venues, power comes on immediately as an unforgettable rush of 427 power vaults you forward. It’s hard to imagine how even masterful drivers might have commanded such power at full tilt, subjected to hours of racing, but this is one of many reasons why nearly all these great drivers are known as heroes of this era.

This rare and amazing Holman-Moody constructed Mk II roadster is offered with a car cover and bag, removable roof side roll bar connectors, and a plaque for display by the current owner when presented at The Quail, Monterey, CA.

One of the most sought-after collectible premium supercars in the history of modern competition motorsports, this Holman-Moody Mk II roadster offers enthusiasts a unique opportunity to experience every aspect of the original construction without the costs, frailties, and concerns associated with museum artifacts. With original Mk II examples now multi-million-dollar icons, this rare example is ready to deliver exceptional performance and provenance. Hand fabricated by members of the original Holman-Moody Mk II build team, with single commissioned ownership, this is a rare opportunity to own a very special vehicle, one that continues the legendary legacy of the incomparable Mk II and the courageous engineers and builders that made history with these exceptional cars.

This car has been designed and built for competition use specifically for closed course racing. It is offered on Bill of Sale only.

1966 Ford GT40 Ford V8 is listed for sale on ClassicDigest in California by Fantasy Junction for Not priced.

Car Facts

Car type : Car Make : Ford Model : GT40 Model Version : Ford V8 Engine size : 0.0 Model Year : 1966 Location : Emeryville Vehicle Registration : Normal

Not priced

Seller Information

Fantasy Junction

Fantasy Junction
+1 510 653 7555

ClassicDigest Market Radar on Ford GT40

$ £ €

People who viewed this Ford GT40 also viewed similar Ford listed at ClassicDigest

Ford GT40

Halton Hills

Ford GT40

249000 €

2 rue du Parc 78470 Saint-Rémy-Lès-Chevreuse, France

Other cars listed for sale by this dealer

Honda S2000

Emeryville

Ford Pick Up

Emeryville

Ford De Luxe

Emeryville

Mercedes-Benz 190SL

Emeryville

Alfa Romeo 1900 C Sprint

739500$

Emeryville

About Ford

Ford, founded in 1902, has arguably changed the history of automotive world more than any other car manufacturer by introducing the first people's car Model T in 1908. They had produced more than 15 million cars by the end of the production in 1927, by which T had become obsolete.

Ford launched the first low priced V8 engine powered car in 1932. 1932 V8 was an instant hit with superior handling and performance to many far more expansive cars of the day. No wonder 32 V8 Ford has become such a favourite among hot rodders around the world with 32 Deuce coupe as their icon.

During the war Ford completely shut down civilian vehicle production to dedicate all its resources to the Allied war efforts (1942-45) They used to build B-24 bombers, aircraft engines, jeeps, M-4 tanks, military trucks and Bren-gun carriers and more than 30,000 super-charged Rolls Royce Merlin V-12 engines for Mosquito and Lancaster bombers as well as P-51 Mustang fighters. After the war Ford cars in the USA got bigger and flashier along with their competitors. In the 60's Ford was back in the forefront again when introducing their commercial hit Mustang in 1964. Mustang was so popular the competition had to follow Ford's example and the ponycar phenomenon took over the US. Over the years the ponies grew some muscles until the oil crisis kill finally killed them off.

In the sixties Ford rushed into international motor sports scene with a fury. After unsuccessful Ferrari takeover, when Enzo Ferrari had cut the deal off with Henry Ford II making the latter absolutely boil with fury, Ford turned to Lola in UK to produce a Ferrari beating long distance racer after. The collaboration between Ford and Lola created the mighty Ford GT40 that absolutely beat Ferrari in Le Mans 24 numerous times.

In Europe, Ford introduced some of the most epic race and rally cars of the 60's based on humble family sedans; Cortina GT, Lotus Cortina, Escort Twin Cam, and Escort 1600RS with the iconic Cosworth BDA engines.

Today classic Fords are extremely popular with enthusiasts and a great selection of classic Fords can be found for sale at www.ClassicDigest.com

Log and debug messages

#	type	message
1	Routing	connect "/captcha"
2	Context	initialization
3	Controller	initialization
4	Routing	match route [na_vif] "/:make/:model/:id"
5	Request	request parameters array ( 'make' => 'ford', 'model' => 'gt40', 'id' => '193191', 'module' => 'home', 'action' => 'view',)
6	Routing	connect "/sf_cache_partial/:module/:action/:sf_cache_key"
7	Creole	connect(): DSN: array ( 'compat_assoc_lower' => '**', 'compat_rtrim_string' => '', 'database' => '', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'socket' => '', 'username' => '**', ), FLAGS: 0
8	Creole	prepareStatement(): SET time_zone = '+01:00'
9	Creole	executeUpdate(): SET time_zone = '+01:00'
10	Creole	connect(): DSN: array ( 'compat_assoc_lower' => '**', 'compat_rtrim_string' => '', 'database' => '', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'socket' => '', 'username' => '**', ), FLAGS: 0
11	Creole	prepareStatement(): SET time_zone = '+01:00'
12	Creole	executeUpdate(): SET time_zone = '+01:00'
13	Creole	connect(): DSN: array ( 'compat_assoc_lower' => '**', 'compat_rtrim_string' => '', 'database' => '', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'socket' => '', 'username' => '**', ), FLAGS: 0
14	Creole	prepareStatement(): SET time_zone = '+01:00'
15	Creole	executeUpdate(): SET time_zone = '+01:00'
16	Creole	connect(): DSN: array ( 'compat_assoc_lower' => '**', 'compat_rtrim_string' => '', 'database' => '', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'socket' => '', 'username' => '**', ), FLAGS: 0
17	Creole	prepareStatement(): SET time_zone = '+01:00'
18	Creole	executeUpdate(): SET time_zone = '+01:00'
19	Creole	connect(): DSN: array ( 'compat_assoc_lower' => '**', 'compat_rtrim_string' => '', 'database' => '', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'socket' => '', 'username' => '**', ), FLAGS: 0
20	Creole	prepareStatement(): SET time_zone = '+01:00'
21	Creole	executeUpdate(): SET time_zone = '+01:00'
22	Controller	dispatch request
23	Filter	executing filter "sfRenderingFilter"
24	Filter	executing filter "sfWebDebugFilter"
25	Filter	executing filter "sfCarViewFilter"
26	Filter	executing filter "naBreadcrumbFilter"
27	Filter	executing filter "sfCacheFilter"
28	Filter	executing filter "sfCommonFilter"
29	Filter	executing filter "sfFlashFilter"
30	Filter	executing filter "sfExecutionFilter"
31	Action	call "homeActions->executeView()"
32	Creole	prepareStatement(): SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, DATE_FORMAT(car.DATE_MODIFY,'%d.%m.%Y') AS DM, make.MAKE_EN AS MAKE, model.MODEL_EN AS MODEL, make.MAKE_EN AS MAKE_en, model.MODEL_EN AS MODEL_en, vehicle_type.VEHICLE_TYPE_EN AS VEHICLE_TYPE, car_type.CAR_TYPE_EN AS CAR_TYPE, color.COLOR_EN AS COLOR, color_type.COLOR_TYPE_EN AS COLOR_TYPE, car_stat.HIT_AD_INFO AS AD_HIT FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) LEFT JOIN make ON (car.ID_MAKE=make.ID) LEFT JOIN model ON (car.ID_MODEL=model.ID) LEFT JOIN vehicle_type ON (car.ID_VEHICLE_TYPE=vehicle_type.ID) LEFT JOIN car_type ON (car_info.ID_CAR_TYPE=car_type.ID) LEFT JOIN color ON (car_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (car_info.ID_COLOR_TYPE=color_type.ID) LEFT JOIN car_stat ON (car.ID=car_stat.ID_AD) WHERE car.ID=? AND car.STATUS=?
33	Creole	executeQuery(): [1.58 ms] SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, DATE_FORMAT(car.DATE_MODIFY,'%d.%m.%Y') AS DM, make.MAKE_EN AS MAKE, model.MODEL_EN AS MODEL, make.MAKE_EN AS MAKE_en, model.MODEL_EN AS MODEL_en, vehicle_type.VEHICLE_TYPE_EN AS VEHICLE_TYPE, car_type.CAR_TYPE_EN AS CAR_TYPE, color.COLOR_EN AS COLOR, color_type.COLOR_TYPE_EN AS COLOR_TYPE, car_stat.HIT_AD_INFO AS AD_HIT FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) LEFT JOIN make ON (car.ID_MAKE=make.ID) LEFT JOIN model ON (car.ID_MODEL=model.ID) LEFT JOIN vehicle_type ON (car.ID_VEHICLE_TYPE=vehicle_type.ID) LEFT JOIN car_type ON (car_info.ID_CAR_TYPE=car_type.ID) LEFT JOIN color ON (car_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (car_info.ID_COLOR_TYPE=color_type.ID) LEFT JOIN car_stat ON (car.ID=car_stat.ID_AD) WHERE car.ID=193191 AND car.STATUS='F'
34	Creole	prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?)
35	Creole	executeQuery(): [0.56 ms] SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (431)
36	Creole	prepareStatement(): SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, DATE_ADD(car.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) WHERE car.ID=?
37	Creole	executeQuery(): [1.26 ms] SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, DATE_ADD(car.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) WHERE car.ID=193191
38	Creole	prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=?
39	Creole	executeQuery(): [1.49 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=193191
40	Creole	prepareStatement(): SELECT car_contact.ID, car_contact.ID_AD, car_contact.ID_SOURCE_AD, car_contact.SCODE, car_contact.COMPANY, car_contact.NAME, car_contact.CITY, car_contact.ADDRESS, car_contact.ZIP, car_contact.EMAIL, car_contact.CONT_TIME, car_contact.PHONE, car_contact.MOBILE, car_contact.FAX, car_contact.WEB_URL, car_contact.DATE_CREATE, car_contact.DATE_MODIFY FROM car_contact WHERE car_contact.ID_AD=?
41	Creole	executeQuery(): [8.12 ms] SELECT car_contact.ID, car_contact.ID_AD, car_contact.ID_SOURCE_AD, car_contact.SCODE, car_contact.COMPANY, car_contact.NAME, car_contact.CITY, car_contact.ADDRESS, car_contact.ZIP, car_contact.EMAIL, car_contact.CONT_TIME, car_contact.PHONE, car_contact.MOBILE, car_contact.FAX, car_contact.WEB_URL, car_contact.DATE_CREATE, car_contact.DATE_MODIFY FROM car_contact WHERE car_contact.ID_AD=193191
42	Creole	prepareStatement(): SELECT netti_dealer.ID_DEALER, netti_dealer.ID, netti_dealer.PATH, netti_dealer.COMPANY, netti_dealer.SLOGAN, netti_dealer.URL, netti_dealer.SIMPLE_URL, netti_dealer.HAS_SITE FROM netti_dealer WHERE netti_dealer.ID_DEALER IN (?)
43	Creole	executeQuery(): [1.45 ms] SELECT netti_dealer.ID_DEALER, netti_dealer.ID, netti_dealer.PATH, netti_dealer.COMPANY, netti_dealer.SLOGAN, netti_dealer.URL, netti_dealer.SIMPLE_URL, netti_dealer.HAS_SITE FROM netti_dealer WHERE netti_dealer.ID_DEALER IN (431)
44	Creole	prepareStatement(): SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=? AND fa_payment_order.PAYMENT_STATUS=? AND fa_payment_order.UPSELLS_TAKEN=?
45	Creole	executeQuery(): [1.16 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=193191 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2'
46	Creole	prepareStatement(): SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID=?
47	Creole	executeQuery(): [0.93 ms] SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID='1'
48	Creole	prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (193191) ORDER BY carimg.ORD ASC
49	Creole	executeQuery(): [1.28 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (193191) ORDER BY carimg.ORD ASC
50	Creole	prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?)
51	Creole	executeQuery(): [0.59 ms] SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (431)
52	Creole	prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=?
53	Creole	executeQuery(): [1.80 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=431 AND dealer_permission.WHICH='Q'
54	Creole	prepareStatement(): SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=? AND model.ID=? AND make.ID=model.ID_MAKE
55	Creole	executeQuery(): [1.61 ms] SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=63 AND model.ID=737 AND make.ID=model.ID_MAKE
56	Creole	prepareStatement(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 193191 AND car.ID_MODEL = '737' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != 193191 AND car.ID_MODEL = '737' ) ORDER BY ID DESC
57	Creole	prepareStatement(): SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 193191 AND car.ID_MODEL = '737' ) UNION ( SELECT car.id FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != 193191 AND car.ID_MODEL = '737' ) ) AS count
58	Creole	executeQuery(): [2.14 ms] SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 193191 AND car.ID_MODEL = '737' ) UNION ( SELECT car.id FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != 193191 AND car.ID_MODEL = '737' ) ) AS count
59	Creole	applyLimit(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 193191 AND car.ID_MODEL = '737' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != 193191 AND car.ID_MODEL = '737' ) ORDER BY ID DESC, offset: 0, limit: 5
60	Creole	executeQuery(): [2.49 ms] ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 193191 AND car.ID_MODEL = '737' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != 193191 AND car.ID_MODEL = '737' ) ORDER BY ID DESC LIMIT 5
61	Creole	prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (88956,64012) ORDER BY carimg.ORD ASC
62	Creole	executeQuery(): [1.22 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (88956,64012) ORDER BY carimg.ORD ASC
63	Creole	prepareStatement(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) ORDER BY ID DESC
64	Creole	prepareStatement(): SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) UNION ( SELECT car.id FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) ) AS count
65	Creole	executeQuery(): [3.95 ms] SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) UNION ( SELECT car.id FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) ) AS count
66	Creole	applyLimit(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) ORDER BY ID DESC, offset: 0, limit: 5
67	Creole	executeQuery(): [10.84 ms] ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) ORDER BY ID DESC LIMIT 5
68	Creole	prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199717,199649,199648,199561,199560) ORDER BY carimg.ORD ASC
69	Creole	executeQuery(): [0.66 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199717,199649,199648,199561,199560) ORDER BY carimg.ORD ASC
70	Creole	prepareStatement(): SELECT car.ID FROM car WHERE car.ID_MAKE=? AND car.ID_MODEL=? AND car.STATUS=?
71	Creole	executeQuery(): [1.02 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=63 AND car.ID_MODEL=737 AND car.STATUS='F'
72	Creole	prepareStatement(): SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=? AND sold_car.ID_MODEL=? AND sold_car.STATUS=?
73	Creole	executeQuery(): [3.39 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=63 AND sold_car.ID_MODEL=737 AND sold_car.STATUS='S'
74	Creole	prepareStatement(): SELECT id, id_ad, ROUND(AVG(price)) AS avg_price, DATE_FORMAT(date_create, "%m-%Y") AS cmonth, date_create FROM price_history WHERE date_create >= DATE_SUB(SYSDATE(), INTERVAL 1 YEAR) AND id_ad IN (64012,88956,193191) GROUP BY cmonth ORDER BY date_create
75	Creole	executeQuery(): [1.02 ms] SELECT id, id_ad, ROUND(AVG(price)) AS avg_price, DATE_FORMAT(date_create, "%m-%Y") AS cmonth, date_create FROM price_history WHERE date_create >= DATE_SUB(SYSDATE(), INTERVAL 1 YEAR) AND id_ad IN (64012,88956,193191) GROUP BY cmonth ORDER BY date_create
76	Creole	prepareStatement(): SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%V" ) AS sold_week, DATE_FORMAT(scs.date_actual_sold, "%V-%Y") AS wmonth FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND sc.price_ask > 0 AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 5 YEAR) AND scs.id_ad IN (29884,30209,30210,30384,30385,33244,33276,33277,33633,34445,35091,35364,36178,36748,36819,36839,36840,36841,38917,39679,39689,42025,42558,42629,42647,42648,42649,43360,44100,44783,45746,46473,46488,46489,47158,47932,48597,49124,49943,49961,50507,51098,51952,52029,52590,53317,53324,53783,53838,54422,54849,55407,56601,57575,57586,58952,59008,59065,59429,59430,59685,61129,62393,62394,62957,63170,65790,68700,75237,76737,76821,83041,88638,100146,100746,102103,105291,105788,105792,108516,109482,112768,115545,119251,119894,146922,146923,147197,148027,149812,151707,151915,157273,157285,164448,168593) GROUP BY sold_week ORDER BY scs.date_actual_sold
77	Creole	executeQuery(): [1.29 ms] SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%V" ) AS sold_week, DATE_FORMAT(scs.date_actual_sold, "%V-%Y") AS wmonth FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND sc.price_ask > 0 AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 5 YEAR) AND scs.id_ad IN (29884,30209,30210,30384,30385,33244,33276,33277,33633,34445,35091,35364,36178,36748,36819,36839,36840,36841,38917,39679,39689,42025,42558,42629,42647,42648,42649,43360,44100,44783,45746,46473,46488,46489,47158,47932,48597,49124,49943,49961,50507,51098,51952,52029,52590,53317,53324,53783,53838,54422,54849,55407,56601,57575,57586,58952,59008,59065,59429,59430,59685,61129,62393,62394,62957,63170,65790,68700,75237,76737,76821,83041,88638,100146,100746,102103,105291,105788,105792,108516,109482,112768,115545,119251,119894,146922,146923,147197,148027,149812,151707,151915,157273,157285,164448,168593) GROUP BY sold_week ORDER BY scs.date_actual_sold
78	Creole	prepareStatement(): SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sc.id IN (29884,30209,30210,30384,30385,33244,33276,33277,33633,34445,35091,35364,36178,36748,36819,36839,36840,36841,38917,39679,39689,42025,42558,42629,42647,42648,42649,43360,44100,44783,45746,46473,46488,46489,47158,47932,48597,49124,49943,49961,50507,51098,51952,52029,52590,53317,53324,53783,53838,54422,54849,55407,56601,57575,57586,58952,59008,59065,59429,59430,59685,61129,62393,62394,62957,63170,65790,68700,75237,76737,76821,83041,88638,100146,100746,102103,105291,105788,105792,108516,109482,112768,115545,119251,119894,146922,146923,147197,148027,149812,151707,151915,157273,157285,164448,168593) GROUP BY sold_month ORDER BY scs.date_actual_sold
79	Creole	executeQuery(): [3.49 ms] SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sc.id IN (29884,30209,30210,30384,30385,33244,33276,33277,33633,34445,35091,35364,36178,36748,36819,36839,36840,36841,38917,39679,39689,42025,42558,42629,42647,42648,42649,43360,44100,44783,45746,46473,46488,46489,47158,47932,48597,49124,49943,49961,50507,51098,51952,52029,52590,53317,53324,53783,53838,54422,54849,55407,56601,57575,57586,58952,59008,59065,59429,59430,59685,61129,62393,62394,62957,63170,65790,68700,75237,76737,76821,83041,88638,100146,100746,102103,105291,105788,105792,108516,109482,112768,115545,119251,119894,146922,146923,147197,148027,149812,151707,151915,157273,157285,164448,168593) GROUP BY sold_month ORDER BY scs.date_actual_sold
80	Creole	prepareStatement(): SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC
81	Creole	executeQuery(): [1036.95 ms] SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC
82	Action	change layout to "view_layout"
83	View	initialize view for "home/view"
84	View	render "sf_app_dir/modules/home/templates/viewSuccess.php"
85	View	initialize view for "home/_vif_images"
86	View	render "sf_app_dir/modules/home/templates/_vif_images.php"
87	PartialHelper	Generate cache key
88	View	initialize view for "common_page/_social_buttons"
89	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php"
90	PartialHelper	Generate cache key
91	View	initialize view for "home/_vif_info"
92	View	render "sf_app_dir/modules/home/templates/_vif_info.php"
93	PartialHelper	Generate cache key
94	View	initialize view for "home/_hoover_user_info"
95	View	render "sf_app_dir/modules/home/templates/_hoover_user_info.php"
96	PartialHelper	Generate cache key
97	View	initialize view for "common_page/_price_development_graph"
98	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php"
99	PartialHelper	Generate cache key
100	View	initialize view for "common_page/_sell_time_price_graph"
101	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php"
102	PartialHelper	Generate cache key
103	View	initialize view for "common_page/_price_gauge_graph"
104	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php"
105	PartialHelper	Generate cache key
106	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
107	Creole	executeQuery(): [2.03 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=88956
108	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
109	Creole	executeQuery(): [0.54 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=64012
110	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
111	Creole	executeQuery(): [0.46 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199717
112	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
113	Creole	executeQuery(): [1.04 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199649
114	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
115	Creole	executeQuery(): [1.23 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199648
116	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
117	Creole	executeQuery(): [0.59 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199561
118	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
119	Creole	executeQuery(): [0.56 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199560
120	View	initialize view for "common_page/_include_vif_js"
121	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_include_vif_js.php"
122	PartialHelper	Generate cache key
123	View	initialize view for "common_page/_fancybox_javascript"
124	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
125	PartialHelper	Generate cache key
126	View	decorate content with "sf_app_dir/templates/view_layout.php"
127	View	render "sf_app_dir/templates/view_layout.php"
128	View	initialize view for "common_page/_responsive_javascript"
129	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_javascript.php"
130	PartialHelper	Generate cache key
131	View	initialize view for "common_page/_google_analytics"
132	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_google_analytics.php"
133	PartialHelper	Generate cache key
134	View	initialize view for "common_page/_header_links"
135	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_header_links.php"
136	View	initialize view for "common_page/_fancybox_javascript"
137	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
138	PartialHelper	Generate cache key
139	View	initialize view for "common_page/_cookie_policy"
140	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_cookie_policy.php"
141	PartialHelper	Generate cache key
142	PartialHelper	Generate cache key
143	View	initialize view for "common_page/_responsive_top_menu"
144	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_top_menu.php"
145	PartialHelper	Generate cache key
146	View	initialize view for "common_page/_top_menu"
147	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_top_menu.php"
148	PartialHelper	Generate cache key
149	View	initialize view for "common_page/_footer_javascript"
150	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer_javascript.php"
151	PartialHelper	Generate cache key
152	View	initialize view for "common_page/_footer"
153	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer.php"
154	PartialHelper	Generate cache key

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    ID_AD: 193191
    action: view
    id: 193191
    make: ford
    model: gt40
    module: home
attributeHolder: 
  symfony/default: 
    HOME_LINK: <a title="cap_na_default_title_3" href="https://www.classicdigest.com/cars/index_dev.php">Classic Cars</a>
    base_domain: .classicdigest.com
    display_que_ans_setction: Y
    show_cookie_policy: 1

Response

---
cookies: 
httpHeaders: 
  Content-Type: text/html; charset=utf-8
parameterHolder: 
  helper/asset/auto/httpmeta: 
    Content-Type: text/html; charset=utf-8
  helper/asset/auto/javascript: 
    /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main
  helper/asset/auto/meta: 
    author: Fiare
    description: Netiauto - Osta tai Myy vaihtoautot- Kauppa käy
    keywords: auto, autot, vaihtoautot, vaihtoauto, vaihtoautoliike, bensa, polttoaine, käytetyt, netiauto, osta, myy, käytetty, etsi, haku, ilmastointi, stereot, amatööri, moottori, katsastus, kesäauto, automaatti, kova, halpa, halvalla, kone, hyvä, nopea, ilmainen, ilmaiseksi, second hand, used, car, cars, hot, fast, good, cheap
    language: et,Estonian,ru,russia,fi,soumeksi,en,English
    other: Mach1 Oy:n kehittämä vaihtoautosivusto. netiauto.ee on sivusto yksityisille ilmoittajille sekä autoliikkeille. netiauto.ee:issa on erittäin monipuoliset hakutoiminnot, jotka helpottavat vaihtoautoa etsivää.
    revisit-after: 15 days
    robots: follow,index
    title: Netiauto - Osta tai Myy vaihtoautot- Kauppa käy
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
  symfony/action/view: 
    home_view_layout: view_layout
  symfony/response/http/headers: 
    Content-Type: text/html; charset=utf-8
  symfony/view/asset: 
    javascripts_included: 
    stylesheets_included:

Settings

---
app_params_adbox_slot: 6
app_params_image_limit: 25
app_params_pdf_limit: 1
app_params_site: Classic Cars
app_params_tot_limit_na: 50
app_params_tot_per_month_limit: 50
app_params_web_master: administrator@classicdigest.com
app_params_www: www.classicdigest.com/cars
app_url_na: https://www.classicdigest.com/cars/index_dev.php
app_url_nm: https://www.classicdigest.com/motorcycles/index_dev.php
app_url_site_url: https://www.classicdigest.com/cars/index_dev.php
css_jquery_ui_custom: jquery-ui-1.8.23.custom.min.css
css_jsquares: jsquares.min.css
css_responsive: responsive.min.css
css_style: style.min.css
homepage_sms_slots: 12
html_direction: ltr
html_left: left
html_right: right
jquery_url: https://ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js
js_banner: banner.min.js
js_common: common.min.js
js_effects: effects.js
js_html5_printshiv: html5shiv-printshiv.min.js
js_html5shiv: html5shiv.min.js
js_jsquares: mosiac/jquery.jsquares.min.js
js_lazy: lazyload/jquery.lazy.min.js
js_netiauto: netiauto
js_prototype: prototype.js
js_slider: slider.min.js
mod_home_enabled: 1
mod_home_is_internal: 
mod_home_view_class: sfPHP
quick_search_max_price: 10000000
quick_search_min_price: 0
sf_admin_web_dir: /sf/sf_admin
sf_app: cars
sf_app_config_dir: /web/classicdigest.com/apps/cars/config
sf_app_config_dir_name: config
sf_app_dir: /web/classicdigest.com/apps/cars
sf_app_i18n_dir: /web/classicdigest.com/lib/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: /web/classicdigest.com/apps/cars/lib
sf_app_lib_dir_name: lib
sf_app_module_action_dir_name: actions
sf_app_module_config_dir_name: config
sf_app_module_dir: /web/classicdigest.com/apps/cars/modules
sf_app_module_dir_name: modules
sf_app_module_i18n_dir_name: i18n
sf_app_module_lib_dir_name: lib
sf_app_module_template_dir_name: templates
sf_app_module_validate_dir_name: validate
sf_app_module_view_dir_name: views
sf_app_template_dir: /web/classicdigest.com/apps/cars/templates
sf_app_template_dir_name: templates
sf_apps_dir_name: apps
sf_autoloading_functions: 
sf_available: 1
sf_base_cache_dir: /web/classicdigest.com/cache/cars
sf_bin_dir: /web/classicdigest.com/batch
sf_bin_dir_name: batch
sf_cache: 1
sf_cache_dir: /web/classicdigest.com/cache/cars/dev
sf_cache_dir_name: cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock: 
sf_check_symfony_version: 
sf_compressed: 
sf_config_cache_dir: /web/classicdigest.com/cache/cars/dev/config
sf_config_dir: /web/classicdigest.com/config
sf_config_dir_name: config
sf_data_dir: /web/classicdigest.com/data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_module: default
sf_doc_dir: /web/classicdigest.com/data/doc
sf_doc_dir_name: doc
sf_enabled_modules: 
  - default
  - user
  - faSms
  - user_mail
  - faDealer
  - dealer_person
  - statistics
  - vote
  - faErrors
  - feedback
  - sfTCPDF
  - static
  - article
  - news
  - que_ans
  - favorite
  - category
  - sfCaptchaGD
  - service_index
  - club
  - sfLightboxPlugin
  - sfPropelNorthIdPlugin
  - facebook
  - tag_cloud
  - adbox
  - apijson
  - findAgent
  - fb_connect
  - fbGeneral
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: faErrors
sf_error_reporting: 2037
sf_escaping_method: ESC_ENTITIES
sf_escaping_strategy: bc
sf_etag: 
sf_i18n: 1
sf_i18n_cache: 1
sf_i18n_cache_dir: /web/classicdigest.com/cache/cars/dev/i18n
sf_i18n_debug: 
sf_i18n_default_culture: en
sf_i18n_source: gettext
sf_i18n_untranslated_prefix: [T]
sf_i18n_untranslated_suffix: [/T]
sf_lazy_cache_key: 
sf_lib_dir: /web/classicdigest.com/lib
sf_lib_dir_name: lib
sf_lightbox_css_dir: https://www.classicdigest.com/entity/css/sfLightboxPlugin/
sf_lightbox_images_dir: https://www.classicdigest.com/entity/images/sfLightboxPlugin/
sf_lightbox_js_dir: https://www.classicdigest.com/entity/js/sfLightboxPlugin/
sf_log_dir: /web/classicdigest.com/log
sf_log_dir_name: log
sf_logging_enabled: 1
sf_logging_history: 10
sf_logging_level: debug
sf_logging_period: 7
sf_logging_purge: 1
sf_logging_rotate: 
sf_login_action: loginRequired
sf_login_module: faErrors
sf_max_forwards: 5
sf_model_dir_name: model
sf_model_lib_dir: /web/classicdigest.com/lib/model
sf_module_cache_dir: /web/classicdigest.com/cache/cars/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: 
sf_orm: propel
sf_path_info_array: SERVER
sf_path_info_key: PATH_INFO
sf_plugins_dir: /web/classicdigest.com/plugins
sf_plugins_dir_name: plugins
sf_prototype_web_dir: /sf/prototype
sf_rich_text_js_dir: js/tiny_mce
sf_root_cache_dir: /web/classicdigest.com/cache
sf_root_dir: /web/classicdigest.com
sf_routing_defaults: 
  sf_culture: en
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers: 
  - Partial
  - Cache
  - Form
  - Date
  - faNettiX
  - faClient
  - Javascript
  - Validation
  - Object
  - Lightbox
sf_strip_comments: 1
sf_suffix: .
sf_symfony_data_dir: /web/clssymfony/data
sf_symfony_lib_dir: /web/clssymfony/lib
sf_template_cache_dir: /web/classicdigest.com/cache/cars/dev/template
sf_test: 
sf_test_cache_dir: /web/classicdigest.com/cache/cars/dev/test
sf_test_dir: /web/classicdigest.com/test
sf_test_dir_name: test
sf_timeout: 1800
sf_timer_start: 1731217320.4638
sf_unavailable_action: maintenance
sf_unavailable_module: util
sf_upload_dir: /web/classicdigest.com/web/uploads
sf_upload_dir_name: uploads
sf_url_format: PATH
sf_use_database: 1
sf_use_flash: 1
sf_use_process_cache: 1
sf_use_security: 1
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix:  
sf_validation_error_suffix:  
sf_web_debug: 1
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /web/classicdigest.com/web
sf_web_dir_name: web

Globals

---
cookie: 
env: 
files: 
get: 
post: 
server: 
  CONTENT_LENGTH: 
  CONTENT_TYPE: 
  DOCUMENT_ROOT: /web/classicdigest.com/web
  DOCUMENT_URI: /cars/index_dev.php/ford/gt40/193191
  FCGI_ROLE: RESPONDER
  GATEWAY_INTERFACE: CGI/1.1
  HOME: /var/lib/nginx
  HTTPS: on
  HTTP_ACCEPT: */*
  HTTP_ACCEPT_ENCODING: gzip, br, zstd, deflate
  HTTP_HOST: www.classicdigest.com
  HTTP_REFERER: https://classicdigest.com/cars/index_dev.php/ford/gt40/193191
  HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
  PATH_INFO: /ford/gt40/193191
  PATH_TRANSLATED: /web/classicdigest.com/web/ford/gt40/193191
  PHP_SELF: /cars/index_dev.php/ford/gt40/193191
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REMOTE_ADDR: 3.139.83.210
  REMOTE_PORT: 18568
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1731217320
  REQUEST_TIME_FLOAT: 1731217320.4626
  REQUEST_URI: /cars/index_dev.php/ford/gt40/193191
  SCRIPT_FILENAME: /web/classicdigest.com/web/cars/index_dev.php
  SCRIPT_NAME: /cars/index_dev.php
  SERVER_ADDR: 10.8.1.209
  SERVER_NAME: www.classicdigest.com
  SERVER_PORT: 443
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SOFTWARE: nginx/1.18.0
  USER: nginx
session: 
  visit_page: 
    - home/view

Php

---
php: 7.2.34
os: Linux classicdigestprod1 4.14.336-179.559.amzn1.x86_64 #1 SMP Tue Feb 13 10:34:24 UTC 2024 x86_64
extensions: 
  - Core
  - date
  - libxml
  - openssl
  - pcre
  - zlib
  - filter
  - hash
  - Reflection
  - SPL
  - session
  - standard
  - cgi-fcgi
  - bz2
  - calendar
  - ctype
  - curl
  - dom
  - mbstring
  - fileinfo
  - ftp
  - gd
  - gettext
  - iconv
  - json
  - exif
  - mysqlnd
  - PDO
  - Phar
  - posix
  - shmop
  - SimpleXML
  - sockets
  - sqlite3
  - sysvmsg
  - sysvsem
  - sysvshm
  - tokenizer
  - xml
  - xmlwriter
  - xsl
  - zip
  - mcrypt
  - mysqli
  - pdo_mysql
  - pdo_sqlite
  - wddx
  - xmlreader
  - memcache

SQL queries

SET time_zone = '+01:00'
SET time_zone = '+01:00'
SET time_zone = '+01:00'
SET time_zone = '+01:00'
SET time_zone = '+01:00'
[1.58 ms] SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, DATE_FORMAT(car.DATE_MODIFY,'%d.%m.%Y') AS DM, make.MAKE_EN AS MAKE, model.MODEL_EN AS MODEL, make.MAKE_EN AS MAKE_en, model.MODEL_EN AS MODEL_en, vehicle_type.VEHICLE_TYPE_EN AS VEHICLE_TYPE, car_type.CAR_TYPE_EN AS CAR_TYPE, color.COLOR_EN AS COLOR, color_type.COLOR_TYPE_EN AS COLOR_TYPE, car_stat.HIT_AD_INFO AS AD_HIT FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) LEFT JOIN make ON (car.ID_MAKE=make.ID) LEFT JOIN model ON (car.ID_MODEL=model.ID) LEFT JOIN vehicle_type ON (car.ID_VEHICLE_TYPE=vehicle_type.ID) LEFT JOIN car_type ON (car_info.ID_CAR_TYPE=car_type.ID) LEFT JOIN color ON (car_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (car_info.ID_COLOR_TYPE=color_type.ID) LEFT JOIN car_stat ON (car.ID=car_stat.ID_AD) WHERE car.ID=193191 AND car.STATUS='F'
[0.56 ms] SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (431)
[1.26 ms] SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, DATE_ADD(car.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) WHERE car.ID=193191
[1.49 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=193191
[8.12 ms] SELECT car_contact.ID, car_contact.ID_AD, car_contact.ID_SOURCE_AD, car_contact.SCODE, car_contact.COMPANY, car_contact.NAME, car_contact.CITY, car_contact.ADDRESS, car_contact.ZIP, car_contact.EMAIL, car_contact.CONT_TIME, car_contact.PHONE, car_contact.MOBILE, car_contact.FAX, car_contact.WEB_URL, car_contact.DATE_CREATE, car_contact.DATE_MODIFY FROM car_contact WHERE car_contact.ID_AD=193191
[1.45 ms] SELECT netti_dealer.ID_DEALER, netti_dealer.ID, netti_dealer.PATH, netti_dealer.COMPANY, netti_dealer.SLOGAN, netti_dealer.URL, netti_dealer.SIMPLE_URL, netti_dealer.HAS_SITE FROM netti_dealer WHERE netti_dealer.ID_DEALER IN (431)
[1.16 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=193191 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2'
[0.93 ms] SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID='1'
[1.28 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (193191) ORDER BY carimg.ORD ASC
[0.59 ms] SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (431)
[1.80 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=431 AND dealer_permission.WHICH='Q'
[1.61 ms] SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=63 AND model.ID=737 AND make.ID=model.ID_MAKE
[2.14 ms] SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 193191 AND car.ID_MODEL = '737' ) UNION ( SELECT car.id FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != 193191 AND car.ID_MODEL = '737' ) ) AS count
[2.49 ms] ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 193191 AND car.ID_MODEL = '737' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != 193191 AND car.ID_MODEL = '737' ) ORDER BY ID DESC LIMIT 5
[1.22 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (88956,64012) ORDER BY carimg.ORD ASC
[3.95 ms] SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) UNION ( SELECT car.id FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) ) AS count
[10.84 ms] ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) UNION ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.sold_car as car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.sold_car_info as car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'S' and car.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND car.ID != '193191' AND car.ID_NETTI_USER = '431' ) ORDER BY ID DESC LIMIT 5
[0.66 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199717,199649,199648,199561,199560) ORDER BY carimg.ORD ASC
[1.02 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=63 AND car.ID_MODEL=737 AND car.STATUS='F'
[3.39 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=63 AND sold_car.ID_MODEL=737 AND sold_car.STATUS='S'
[1.02 ms] SELECT id, id_ad, ROUND(AVG(price)) AS avg_price, DATE_FORMAT(date_create, "%m-%Y") AS cmonth, date_create FROM price_history WHERE date_create >= DATE_SUB(SYSDATE(), INTERVAL 1 YEAR) AND id_ad IN (64012,88956,193191) GROUP BY cmonth ORDER BY date_create
[1.29 ms] SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%V" ) AS sold_week, DATE_FORMAT(scs.date_actual_sold, "%V-%Y") AS wmonth FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND sc.price_ask > 0 AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 5 YEAR) AND scs.id_ad IN (29884,30209,30210,30384,30385,33244,33276,33277,33633,34445,35091,35364,36178,36748,36819,36839,36840,36841,38917,39679,39689,42025,42558,42629,42647,42648,42649,43360,44100,44783,45746,46473,46488,46489,47158,47932,48597,49124,49943,49961,50507,51098,51952,52029,52590,53317,53324,53783,53838,54422,54849,55407,56601,57575,57586,58952,59008,59065,59429,59430,59685,61129,62393,62394,62957,63170,65790,68700,75237,76737,76821,83041,88638,100146,100746,102103,105291,105788,105792,108516,109482,112768,115545,119251,119894,146922,146923,147197,148027,149812,151707,151915,157273,157285,164448,168593) GROUP BY sold_week ORDER BY scs.date_actual_sold
[3.49 ms] SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sc.id IN (29884,30209,30210,30384,30385,33244,33276,33277,33633,34445,35091,35364,36178,36748,36819,36839,36840,36841,38917,39679,39689,42025,42558,42629,42647,42648,42649,43360,44100,44783,45746,46473,46488,46489,47158,47932,48597,49124,49943,49961,50507,51098,51952,52029,52590,53317,53324,53783,53838,54422,54849,55407,56601,57575,57586,58952,59008,59065,59429,59430,59685,61129,62393,62394,62957,63170,65790,68700,75237,76737,76821,83041,88638,100146,100746,102103,105291,105788,105792,108516,109482,112768,115545,119251,119894,146922,146923,147197,148027,149812,151707,151915,157273,157285,164448,168593) GROUP BY sold_month ORDER BY scs.date_actual_sold
[1036.95 ms] SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC
[2.03 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=88956
[0.54 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=64012
[0.46 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199717
[1.04 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199649
[1.23 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199648
[0.59 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199561
[0.56 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199560

type	calls	time (ms)
Configuration	13	1.45
Action "home/view"	1	1144.64
Database	31	1096.73
View "Success" for "home/view"	1	41.88
Partial "home/_vif_images"	1	0.47
Partial "common_page/_social_buttons"	1	0.09
Partial "home/_vif_info"	1	0.15
Partial "home/_hoover_user_info"	1	0.06
Partial "common_page/_price_development_graph"	1	0.05
Partial "common_page/_sell_time_price_graph"	1	0.04
Partial "common_page/_price_gauge_graph"	1	0.04
Partial "common_page/_include_vif_js"	1	0.06
Partial "common_page/_fancybox_javascript"	2	0.17
Partial "common_page/_responsive_javascript"	1	0.05
Partial "common_page/_google_analytics"	1	0.04
Partial "common_page/_header_links"	1	0.75
Partial "common_page/_cookie_policy"	1	0.10
Partial "common_page/_responsive_top_menu"	1	0.12
Partial "common_page/_top_menu"	1	0.12
Partial "common_page/_footer_javascript"	1	0.10
Partial "common_page/_footer"	1	0.10

Ford GT40 Ford V8 1966

Car Facts

Seller Information

ClassicDigest Market Radar on Ford GT40

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers