Alfa Romeo 6C 2500 SS 1950

General description : 1950 Alfa Romeo 6C 2500 Super Sport Cabriolet
s/n 915788, Engine no. 928081
Coachwork by Pinin Farina
Black with Green Leather Interior

Among the most beautifully constructed automobiles ever conceived, the Alfa Romeo 6C 2500 occupies a cherished position in the history of coachbuilding and automotive excellence. Alfa Romeo, renowned for engaging the finest artisans and craftsmen to build their cars, also benefited from the genius of engineer Vittorio Jano. His remarkable twin-cam six and eight-cylinder engines would become legendary to the Alfa Romeo name powering victory after victory at venues all over the world. In 1925, just one year after constructing their first straight eight engine for Alfa Romeo, they won the very first World Championship. Though praise and acclaim were in order, Alfa Romeo was operating at fiscally unsustainable levels of perfection. In 1933, state recovery orders were put in place to save the company, giving the powerful Italian government control over Alfa Romeo.

Fueled by national vigor and bolstered by the largess associated with government funds, Alfa Romeos of this era became opulent, highly refined, and emblems of Italian pride and technology. In 1946 the 6C 2500 Freccio d’0ro launched. These vehicles were of bespoke construction outfitted with the finest in coachbuilt bodies, stunning interior treatments, and luxuriant appointments befitting royalty. The Super Sport, the premier offering of the 6C configuration, utilized a short wheelbase chassis fitted with the overhead cam engine and triple Weber carburetors. These features, coupled with four-wheel independent suspension, were light years ahead of the typical sold rear axle chassis platforms of other manufacturers. The combination of sophisticated engineering, reliability, and stunning handmade coachwork offered customers the very best in performance motoring. The triple Weber carburetors and broad powerband delivered a robust 110hp with top speeds well beyond the capability of most skilled drivers. In the hands of top drivers competing in motorsport events, Alfa Romeo campaigned both the 2300 and 2500 to high acclaim achieving an impressive string of top finishes including 1st and 2nd in the 1937 Mille Miglia, 1st, 2nd, and 3rd in the 1937 6-Hour Targa Abruzzo, Pescara, and pressing on after the war with an overall win at the prestigious 1950 Targa Florio. In addition to the many competition victories achieved, wealthy clientele of these cars included Rita Hayworth, Prince Rainier of Monaco, and King Farouk of Egypt. Among the most desirable of the 6C models, the 2500 “Super Sport” 2,700 mm short wheelbase contains elements of opulent pre-war design and coachbuilding excellence, transitioning hand crafting and emergent post war technology into the beautiful example reflected here. Though the majority of these cars were fitted with Touring bodies, this example is draped with Pinin Farina alloy coachwork further distinguished by its cabriolet configuration.

Completed at the Alfa Romeo factory in August 1950, the car was dispatched to the Swiss Alfa Romeo agency based in Lugano, Switzerland. According to research compiled under prior ownership, it is believed to be the singular example finished at the factory in the striking black over green color combination. The next owner, believed to be the second, was Parisian Monsieur Michel Pfau, who arranged the purchase in Geneva, Switzerland, 1957. An avid jazz enthusiast, Pfau and two of his closest friends were frequent travelers in this Alfa Romeo touring throughout Europe attending jazz events in Berlin, Nice, and Cannes. A photo of the group taken near Cote d’Azur is part of the impressive documentation included with the car.

Spanning 56 years of singular ownership, Pfau would keep the car until 2013, completing a six-year restoration culminating in 2012. During the restoration, the paint was redone in Novara, Italy and mechanical systems refurbished in Torino Italy. The next owner, Franco Meiners of Bergamo, Italy purchased the car in 2013 shortly after the restoration was completed. Under his ownership., Mr. Meiners attended several concours events including the 2014 Retromobile show in Paris, where Mr. Meiners made the acquaintance of a member of the original trio of jazz enthusiasts and close friend of Mr. Pfau. Sadly, while he reported that Mr. Pfau had passed only a week ago, proceeds from the sale of the car were shared amongst the two friends on the wishes of Mr. Pfau to spend accordingly on future jazz concerts.

The car found its way to America in 2014 under new ownership where the owner fitted the car with period-correct Michelin tires, serviced the car including general fluids, master cylinder rebuild, and tuning/adjustments for the triple Weber carburetors. The exterior body finish was also treated to protective ceramic coating.

Today this Alfa Romeo 6C presents as a gorgeous work of automotive artistry, poised for enthusiastic ownership as it continues to delight even the most familiar collectors of desirable coachbuilt Italian cars. Offered with exemplary finishes consistent with the traditions of fine Italian craftsmanship as applied when first built, Italian artisans have once again proven their exquisite skills in the restoration performed on this rare Super Sport convertible. The Pinin Farina coachwork is a refined expression of the convertible configuration, enveloping passengers in hand shaped lightweight alloy construction with elegant drapery and refined details, accented by lustrous Borrani wire wheels.

Having benefited from a comprehensive restoration that addressed every feature of this remarkable car, the restoration preserved as many of the rare original parts and uniquely designed components that make up this stunning example. The lustrous, black paint is beautifully finished, applied with consistent coverage and excellent final polish, showing only minor evidence of use since completion. The deep black reveals the refined yet subtle body surfaces and contours so well managed in the bodywork. The minimal, yet refined brightwork surrounding the front fascia and grille are perfectly formed and polished, while the glass, accessory lights, delicate door handles, and rotating trunk handles are delightful bits of jewelry enhancing the body lines. The brilliantly polished Borrani wire wheels are shod with period correct Michelin tires and accented with chrome plated dual-ear knockoffs embossed with the Alfa Romeo script lettering. The Pinin Farina coachwork badges, Alfa Romeo emblems, and distinctive grille are gorgeous pieces of automotive jewelry, particularly brilliant against the deep black body color. Every aspect of the original design has been wonderfully captured in the restoration with beautiful finishes and exemplary details displayed throughout this splendid example.

Gently pulling the recessed door handle lever, the green leather interior offers full width seating, handsome trim, and a breathtaking dashboard finished in a captivating green color that only Italian designers can so boldly express. The seating and door panels are finished in the same color themes while the carpet is a softer green finished with contrasting perimeter binding. The supple leather and pleated inserts are beautifully stitched and trimmed with precision. The hinged bench seat creates a comforting but supportive feel, while the brilliantly colored dashboard and full instrumentation convey the sporting spirit of this model. The dashboard and accompanying instruments are stunning in presentation and wonderfully laid out. The central grill separates the two main instruments, both of which display unmistakable Italian flare in design, beautiful nomenclature, and elegant colors, surrounded by crisp polished trim and deep orange color accents decorating the various knobs, handles, and escutcheon plates. The interior is completed with an elegant finishing touch, the ivory finished steering wheel. Further details throughout the interior include tastefully sculpted door handles and window cranks, elegant, felted headliner, and an under dash mounted heater. Overall, the interior exhibits the familiarly stunning excellence and attention to craftsmanship consistent with exceptional Italian design.

The matching numbers engine, confirmed by the Alfa Romeo 6C 2300-2500 registry, and beautifully finished engine compartment have been comprehensively restored using correct factory finishes, correct hardware and fasteners, and proper wiring, all of which are brought together with mechanical refinement and aesthetic harmony befitting a car of this caliber. The impressive six-cylinder twin-cam engine castings are uniformly finished with attention to detail and authenticity in every respect, including the original type Weber DO2 Tipo 36 carburetors bearing #1234, 1260, and 1334 on their casting bodies. The original data plates on the firewall reflect the original engine number which is consistent with the engine in the car.

The trunk is finished with a painted Borrani spare wheel and Dunlop tire mounted above the carpeted trunk floor. The underside of the car has been restored with the same attention to detail and authenticity afforded to the exterior, displaying accurate details including correct exhaust, correct 4-speed manual gearbox, independent front and rear suspension, and finned hydraulic drum brakes. The car is accompanied by an impressive file containing numerous records spanning decades of ownership as well as photos documenting the six-year restoration, the original owner’s manual, and the original French registration license plates which remain on the car today.

This Alfa Romeo 6C 2500 Super Sport Pinin Farina Cabriolet represents a rare opportunity to acquire a beautifully restored coachbuilt Pinin Farina Alfa Romeo with a captivating history, superb restoration and valuable documentation supporting the legacy of 56 years of passionate ownership. The elegant body lines, sporting 6C engine, and exquisitely finished interior makes this Super Sport a welcomed entrant to any major automotive concours throughout the world, including eligibility in the Mille Miglia. For those who cherish Italian artistry, hand-crafted alloy coachwork, and state of the art engineering, this Alfa Romeo 6C 2500 Super Sport will forever deliver on the promise of excellence, transcending the passage of time.

1950 Alfa Romeo 6C 2500 SS is listed for sale on ClassicDigest in California by Fantasy Junction for $639500.

Car Facts

Car type : Car Make : Alfa Romeo Model : 6C 2500 SS Engine size : 2.4 Model Year : 1950 Sub type : Convertible Color : Black Color type : Nonmetallic Location : Emeryville Vehicle Registration : Normal

639500 $

Seller Information

Fantasy Junction

Fantasy Junction
+1 510 653 7555

ClassicDigest Market Radar on Alfa Romeo 6C 2500 SS

$ £ €

People who viewed this Alfa Romeo 6C 2500 SS also viewed similar Alfa Romeo listed at ClassicDigest

Alfa Romeo 6C 2500 SS

220000 €

Orberstr. 4a 60386 Frankfurt am Main, Germany

Alfa Romeo 6C 2500 SS

Emeryville

Alfa Romeo 6C 2500 SS

267500 $

Astoria

Alfa Romeo 6C 2500 SS

ITALY

Other cars listed for sale by this dealer

Ferrari 308 GTS

Emeryville

Honda S2000

Emeryville

Ford Pick Up

Emeryville

Ford De Luxe

Emeryville

Mercedes-Benz 190SL

Emeryville

About Alfa Romeo 6C 2500 SS

The Alfa Romeo 6C 2500 SS (Super Sport) was a high-performance car produced by Alfa Romeo between 1938 and 1952. It was designed as a luxury sports car, and it quickly gained a reputation for its impressive performance, style, and engineering. Here are some highlights and a brief history of the Alfa Romeo 6C 2500 SS:

Design: The Alfa Romeo 6C 2500 SS was designed by the legendary Italian coachbuilder Carrozzeria Touring, which was known for its lightweight, aerodynamic designs. The car featured a sleek, streamlined body that was both stylish and functional, as well as advanced suspension and chassis design.
Engine: The 6C 2500 SS was powered by a 2,443 cc inline-six engine that produced up to 110 horsepower. This engine was one of the most advanced of its time and featured a number of innovative technologies, including twin overhead camshafts, hemispherical combustion chambers, and an aluminum cylinder head.
Racing success: The Alfa Romeo 6C 2500 SS was a successful racing car, winning numerous races and championships throughout its production run. The car's success on the track helped to cement its reputation as a high-performance machine and made it a favorite among racing enthusiasts.
Post-war production: Production of the 6C 2500 SS was halted during World War II, but it resumed in 1946. During the post-war years, the car underwent a number of changes and upgrades, including the addition of hydraulic brakes and a more powerful engine that produced up to 120 horsepower.
Rarity and value: Today, the Alfa Romeo 6C 2500 SS is a highly sought-after collector's car, thanks to its rarity, performance, and style. Only around 400 examples were produced, and many of these have been lost over time, making the remaining examples even more valuable.
Overall, the Alfa Romeo 6C 2500 SS is considered one of the most significant cars in Alfa Romeo's history. Its advanced technology, racing success, and sleek design all helped to establish Alfa Romeo's reputation as a maker of high-performance sports cars.

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' => 'alfa-romeo', 'model' => '6c-2500-ss', 'id' => '188380', '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.80 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=188380 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.50 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(): [0.57 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=188380
38	Creole	prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=?
39	Creole	executeQuery(): [0.78 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=188380
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.54 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=188380
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.03 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.21 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=188380 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(): [1.53 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 (188380) ORDER BY carimg.ORD ASC
49	Creole	executeQuery(): [1.75 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 (188380) 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.92 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(): [0.55 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.24 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=4 AND model.ID=16 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 != 188380 AND car.ID_MODEL = '16' ) 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 != 188380 AND car.ID_MODEL = '16' ) 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 != 188380 AND car.ID_MODEL = '16' ) 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 != 188380 AND car.ID_MODEL = '16' ) ) AS count
58	Creole	executeQuery(): [0.81 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 != 188380 AND car.ID_MODEL = '16' ) 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 != 188380 AND car.ID_MODEL = '16' ) ) 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 != 188380 AND car.ID_MODEL = '16' ) 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 != 188380 AND car.ID_MODEL = '16' ) ORDER BY ID DESC, offset: 0, limit: 5
60	Creole	executeQuery(): [1.25 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 != 188380 AND car.ID_MODEL = '16' ) 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 != 188380 AND car.ID_MODEL = '16' ) 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 (199822,199482,188620,153307) ORDER BY carimg.ORD ASC
62	Creole	executeQuery(): [0.51 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 (199822,199482,188620,153307) 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 != '188380' 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 != '188380' 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 != '188380' 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 != '188380' AND car.ID_NETTI_USER = '431' ) ) AS count
65	Creole	executeQuery(): [5.92 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 != '188380' 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 != '188380' 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 != '188380' 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 != '188380' AND car.ID_NETTI_USER = '431' ) ORDER BY ID DESC, offset: 0, limit: 5
67	Creole	executeQuery(): [14.12 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 != '188380' 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 != '188380' 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 (199823,199717,199649,199648,199561) ORDER BY carimg.ORD ASC
69	Creole	executeQuery(): [0.70 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 (199823,199717,199649,199648,199561) 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.40 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=4 AND car.ID_MODEL=16 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(): [0.82 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=4 AND sold_car.ID_MODEL=16 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 (153307,188380,188620,199482,199822) GROUP BY cmonth ORDER BY date_create
75	Creole	executeQuery(): [1.72 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 (153307,188380,188620,199482,199822) 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 (24122,25767,29847,31478,52520,65046,65047,65095,65677,72612,110069,113687,179533) GROUP BY sold_week ORDER BY scs.date_actual_sold
77	Creole	executeQuery(): [0.68 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 (24122,25767,29847,31478,52520,65046,65047,65095,65677,72612,110069,113687,179533) 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 (24122,25767,29847,31478,52520,65046,65047,65095,65677,72612,110069,113687,179533) GROUP BY sold_month ORDER BY scs.date_actual_sold
79	Creole	executeQuery(): [0.69 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 (24122,25767,29847,31478,52520,65046,65047,65095,65677,72612,110069,113687,179533) 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(): [1548.90 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(): [5.35 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199822
108	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
109	Creole	executeQuery(): [7.22 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199482
110	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
111	Creole	executeQuery(): [3.11 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=188620
112	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
113	Creole	executeQuery(): [4.67 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=153307
114	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
115	Creole	executeQuery(): [2.56 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199823
116	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
117	Creole	executeQuery(): [5.05 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199717
118	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
119	Creole	executeQuery(): [4.34 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199649
120	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
121	Creole	executeQuery(): [1.00 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199648
122	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
123	Creole	executeQuery(): [1.37 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199561
124	View	initialize view for "common_page/_include_vif_js"
125	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_include_vif_js.php"
126	PartialHelper	Generate cache key
127	View	initialize view for "common_page/_fancybox_javascript"
128	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
129	PartialHelper	Generate cache key
130	View	decorate content with "sf_app_dir/templates/view_layout.php"
131	View	render "sf_app_dir/templates/view_layout.php"
132	View	initialize view for "common_page/_responsive_javascript"
133	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_javascript.php"
134	PartialHelper	Generate cache key
135	View	initialize view for "common_page/_google_analytics"
136	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_google_analytics.php"
137	PartialHelper	Generate cache key
138	View	initialize view for "common_page/_header_links"
139	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_header_links.php"
140	View	initialize view for "common_page/_fancybox_javascript"
141	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
142	PartialHelper	Generate cache key
143	View	initialize view for "common_page/_cookie_policy"
144	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_cookie_policy.php"
145	PartialHelper	Generate cache key
146	PartialHelper	Generate cache key
147	View	initialize view for "common_page/_responsive_top_menu"
148	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_top_menu.php"
149	PartialHelper	Generate cache key
150	View	initialize view for "common_page/_top_menu"
151	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_top_menu.php"
152	PartialHelper	Generate cache key
153	View	initialize view for "common_page/_footer_javascript"
154	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer_javascript.php"
155	PartialHelper	Generate cache key
156	View	initialize view for "common_page/_footer"
157	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer.php"
158	PartialHelper	Generate cache key

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    ID_AD: 188380
    action: view
    id: 188380
    make: alfa-romeo
    model: 6c-2500-ss
    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: 1732337206.7679
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: 
  fikker-61vm-nk2N: MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E
env: 
files: 
get: 
post: 
server: 
  CONTENT_LENGTH: 
  CONTENT_TYPE: 
  DOCUMENT_ROOT: /web/classicdigest.com/web
  DOCUMENT_URI: /cars/index_dev.php/alfa-romeo/6c-2500-ss/188380
  FCGI_ROLE: RESPONDER
  GATEWAY_INTERFACE: CGI/1.1
  HOME: /var/lib/nginx
  HTTPS: on
  HTTP_ACCEPT: */*
  HTTP_ACCEPT_ENCODING: gzip, br, zstd, deflate
  HTTP_COOKIE: fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E
  HTTP_HOST: www.classicdigest.com
  HTTP_REFERER: https://classicdigest.com/cars/index_dev.php/alfa-romeo/6c-2500-ss/188380
  HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
  PATH_INFO: /alfa-romeo/6c-2500-ss/188380
  PATH_TRANSLATED: /web/classicdigest.com/web/alfa-romeo/6c-2500-ss/188380
  PHP_SELF: /cars/index_dev.php/alfa-romeo/6c-2500-ss/188380
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REMOTE_ADDR: 3.15.211.71
  REMOTE_PORT: 13224
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1732337206
  REQUEST_TIME_FLOAT: 1732337206.7662
  REQUEST_URI: /cars/index_dev.php/alfa-romeo/6c-2500-ss/188380
  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.80 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=188380 AND car.STATUS='F'
[0.50 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)
[0.57 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=188380
[0.78 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=188380
[8.54 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=188380
[1.03 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.21 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=188380 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2'
[1.53 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.75 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 (188380) ORDER BY carimg.ORD ASC
[0.92 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)
[0.55 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=431 AND dealer_permission.WHICH='Q'
[1.24 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=4 AND model.ID=16 AND make.ID=model.ID_MAKE
[0.81 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 != 188380 AND car.ID_MODEL = '16' ) 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 != 188380 AND car.ID_MODEL = '16' ) ) AS count
[1.25 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 != 188380 AND car.ID_MODEL = '16' ) 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 != 188380 AND car.ID_MODEL = '16' ) ORDER BY ID DESC LIMIT 5
[0.51 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 (199822,199482,188620,153307) ORDER BY carimg.ORD ASC
[5.92 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 != '188380' 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 != '188380' AND car.ID_NETTI_USER = '431' ) ) AS count
[14.12 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 != '188380' 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 != '188380' AND car.ID_NETTI_USER = '431' ) ORDER BY ID DESC LIMIT 5
[0.70 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 (199823,199717,199649,199648,199561) ORDER BY carimg.ORD ASC
[1.40 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=4 AND car.ID_MODEL=16 AND car.STATUS='F'
[0.82 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=4 AND sold_car.ID_MODEL=16 AND sold_car.STATUS='S'
[1.72 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 (153307,188380,188620,199482,199822) GROUP BY cmonth ORDER BY date_create
[0.68 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 (24122,25767,29847,31478,52520,65046,65047,65095,65677,72612,110069,113687,179533) GROUP BY sold_week ORDER BY scs.date_actual_sold
[0.69 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 (24122,25767,29847,31478,52520,65046,65047,65095,65677,72612,110069,113687,179533) GROUP BY sold_month ORDER BY scs.date_actual_sold
[1548.90 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
[5.35 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199822
[7.22 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199482
[3.11 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=188620
[4.67 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=153307
[2.56 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199823
[5.05 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199717
[4.34 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199649
[1.00 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199648
[1.37 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199561

type	calls	time (ms)
Configuration	13	1.75
Action "home/view"	1	1655.62
Database	33	1632.60
View "Success" for "home/view"	1	75.27
Partial "home/_vif_images"	1	0.46
Partial "common_page/_social_buttons"	1	0.08
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.05
Partial "common_page/_fancybox_javascript"	2	0.15
Partial "common_page/_responsive_javascript"	1	0.05
Partial "common_page/_google_analytics"	1	0.06
Partial "common_page/_header_links"	1	0.64
Partial "common_page/_cookie_policy"	1	0.07
Partial "common_page/_responsive_top_menu"	1	0.10
Partial "common_page/_top_menu"	1	0.12
Partial "common_page/_footer_javascript"	1	0.10
Partial "common_page/_footer"	1	0.10

Alfa Romeo 6C 2500 SS 1950

Car Facts

Seller Information

ClassicDigest Market Radar on Alfa Romeo 6C 2500 SS

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers