Mercedes-Benz 280SL w107 SL 1980

General description : * GARANTIE 12 MOIS incluse
* REPRISES et LIVRAISON possibles
* Frais de mise à la route en sus : 690 € TTC (1/4 de carburant, passage contróle technique, préparation intérieur et extérieur)
* Service « carte grise » et « carte grise collection » (dossier FFVE inclus)

MERCEDES 280 SL (1971 - 1989)

Origine France
Carte grise 4 places
Type "R107"
6 Cylindres en ligne / 2746 cc
Boite automatique 4 rapports
Matching color extérieur : « Classic Weiss 737 G »
Matching color intérieur : « Blau »
Restauration carrosserie + peinture + mécanique + sellerie entre 2021 et 2022 (facture: 29.257€).
- ponçage caisse compléte
- mise en apprêt
- peinture compléte coloris Classic Weiss 737 G
- remplacement de l’ensemble des joints de carrosserie
- capote en mohair
- baguettes chromées neuves
- feux arriére neufs
- sellerie avant arriére neuve
- surfaçage culasse
- pochette de joints moteur
- pompe à eau neuve
- démarreur neuf
- support moteur et boite neufs
- courroie accessoire neuve
- joint spy moteur remplacé
- Silencieux d'échappement neuf
- filtre à huile
- 6 bougies neuves
- amortisseurs avant et arriére neufs
- disques de frein avant et arriére neufs
- étriers de frein avant et arriére neufs
- flexibles de frein neufs
- silentblocs train roulant neufs
- cardans neufs
- 4 jantes aluminium MERCEDES en 14’’ restaurées / repeintes
- 4 pneumatiques neufs
Capote manuelle en mohair coloris « Schwarz »
Rétroviseur conducteur + passagers chromés
Pare-brise teinté dégradé coloris« Blau »
Sellerie avant en « Simili-cuir coloris « Blau »
Appuie tête en Simili-cuir coloris « Blau »
Contres portes en simili cuir coloris « Blau »
Tableau de bord en simili cuir coloris « Blau »
Casquette de tableau de bord en simili cuir coloris « Blau »
Console centrale en simili cuir coloris « Blau »
Instrumentation de bord VDO d'origine
Horloge de bord VDO d'origine
Vitres électriques
Volant d'origine en simili cuir coloris « Schwarz »
Pommeau de levier de vitesse en simili cuir coloris « Schwarz »
Moquettes coloris « Blau »
Ceintures de sécurité avant et arriére
Roue de secours en tóle d’origine
Cric

Historique du modéle :
A la fin des années 60 Mercedes doit moderniser sa prestigieuse "SL", symbole absolu de réussite sociale.
La "Pagode" va donc être remplacée par la nouvelle "SL R107" qui reprend les canons de la marque: une ligne associant pureté et classicisme sur laquelle vient se poser un trés lourd hard-top démontable.
Le marché américain étant de loin le premier client de la marque à l'étoile, la nouvelle SL va adopter les standards californiens: la sportivité laisse place à plus de confort et de raffinement, et les moteurs deviennent plus propres et plus puissants comparés aux précédentes Pagodes.
De même, la boîte automatique devient la régle sur cette grosse GT qui se "cruise" désormais sur le couple.

Carrosserie / Extérieur :
Le modéle présenté ici est une MERCEDES 280 SL de Février 1976 dans son coloris «Classic Weiss 737G» d’origine (matching color).
La carrosserie a été restaurée en 2021 (facture disponible).
A cette occasion la caisse a été intégralement démontée, poncée et mise en apprêt pour recevoir une peinture neuve compléte dans son coloris «Classic Weiss 737G» d’origine.
L'ensemble des joints de porte et des joints de vitrage ont également été remplacés.
La peinture est en état proche du neuf et affiche une brillance ainsi qu'une profondeur excellente.
Aprés un lustrage pro réalisé à l’orbitale par notre atelier, nous avons noté un trés léger défaut sous peinture sur le couvre capote et le capot avant.
Les pare chocs chromés d’origine sont parfaitement positionnés et en trés bon état.
Nous avons noté relevé quelques petites traces d’oxydation sur le contour de calandre et le pare choc avant.
Les feux arriére ainsi que les baguettes d'ornement carrosserie ont été remplacés lors de la restauration.
Le pare-brise teinté / dégradé coloris « Blau » présente quelques rayures.
La capote en mohair coloris « Schwarz » est en état neuf.
Sa mise en place est aisée et son étanchéité reste conforme à l’origine.
Les rétroviseurs chromés sont en bon état. Nous noté une trés légére oxydation sur le rétroviseur conducteur.
Les 4 jantes aluminium MERCEDES type "baroque" ont également été restaurées et sont en état neuf.
Les 4 pneumatiques HANKOOK ont été remplacés lors de la restauration des jantes et affichent une usure inférieure à 5%.
Cet exemplaire dispose de sa roue de secours tóle d’origine et de son cric.
Parmi les équipements et options "Carrosserie / Extérieur" intéressants dont ce modéle est doté, nous avons relevé: la peinture neuve dans le coloris d'origine ainsi que les 4 jantes aluminium type "baroque" .

Habitacle :
L’intérieur a conservé sa configuration d’origine et apparaît en excellent état de présentation. L’ensemble de la sellerie à été restauré à neuf en 2020 (facture disponible).
Les siéges avant et arriére en « Simili-cuir coloris « Blau » sont en excellent état.
Il en est de même pour les appuie tête en Simili-cuir coloris « Blau ».
Les contre portes en Simili-cuir coloris « Blau » sont en parfait état.
Le tableau de bord et sa casquette en simili cuir sont également en bon état.
Nous avons relevé deux petites fissures sur la casquette.
L’ensemble de l’instrumentation de bord VDO ainsi que la montre d'origine sont parfaitement fonctionnels.
Les vitres électriques sont parfaitement fonctionnelles.
Seul l’éclairage du combiné de bord n'est plus opérationnel.
La console d'origine en simili cuir coloris« Blau » est en excellent état.
Le volant d'origine en simili cuir coloris « Schwarz » est en bon état.
Le pommeau de vitesse en simili cuir coloris « Schwarz » présente une patine d’usage homogéne.
Les moquettes coloris « Blau » sont en état neuf.
Parmi les équipements et options "Habitacle" intéressantes dont cet exemplaire est doté, nous avons noté: les vitres électriques, la sellerie en Simili-cuir neuve ainsi que les moquettes neuves.

Châssis :
La mise sur le pont confirme une caisse saine, sans trace de corrosion structurelle apparente.
Nous avons relevé une trace de réparation ancienne sur la face avant et le coffre arriére.
Les fondamentaux : bas de caisse, bas d'ailes, passages de roue et plancherssont en bon état.
Réserve d'usage: par principe nous ne pouvons garantir la perfection des alignements au delà de leur bon état visuel et fonctionnel validé lors de l’essai sur route et de la mise sur le pont.
Lors de l'essai dynamique, nous n'avons relevé aucun bruit parasite anormal au niveau de la caisse ou des trains roulants (rotules, silentblocs...).
Les 4 amortisseurs ainsi que les cardans et l’ensemble des silentblocs ont été remplacés lors de la restauration.
Le freinage est aligné, stable et conforme aux normes d’époque.
Les étriers, disques, plaquettes et flexibles de frein ont été remplacés / restaurés en 2021 (facture disponible).
Les disques de frein avant et arriére affichent une usure inférieure à 5%.
Les plaquettes de frein avant et arriére affichent une usure inférieure à 5%.
Le passage au contróle technique effectué par notre atelier avant livraison du véhicule confirmera également le bon fonctionnement de l'ensemble.

Moteur / Transmission :
La mécanique fonctionne parfaitement.
La prise des compressions moteur réalisée en nos ateliers ainsi que l'essai routier confirment un bloc en excellente santé.
Le moteur à été déposé en 2021 pour remplacement du joint de culasse,surfaçage de la culasse, remplacement du kit de joints, de la pompe a eau , du joint spy moteur, des supports moteur et boite, ainsi que des 6 bougies, du filtre à huile et de l'huile moteur 10w40. (facture disponible)
Le faisceau d’allumage sera remplacé à neuf en amont de la livraison.
Le 6 cylindres démarre immédiatement, sans fumées ni bruits suspects et le ralenti est stable ainsi que le confirme la vidéo 360° réalisée moteur tournant et disponible en début de diaporama.
La pression d’huile relevée à froid par notre atelier est de 3 bars à 1.000tr/min.
Au roulage, le moteur prend ses tours sans à-coups ni surchauffe
Les 4 rapports de la boite automatique montent et descendent aisément et sans accrocs.
Comme souvent sur les mécaniques anciennes, l’étanchéité moteur / boite de vitesse reste moyenne.

Cabriolet de prestige symbolisant le luxe et la réussite sociale jusque dans les années 80, le SL 280 permet aujourd'hui aux collectionneurs de s'offrir un 6 cylindres indestructible et le prestige de l'étoile, le tout réuni dans un cabriolet à la ligne trés pure pour un budget trés raisonnable.

1980 Mercedes-Benz 280SL w107 SL is listed for sale on ClassicDigest in La Boisse by GT SPIRIT for Not priced.

Car Facts

Car type : Car Make : Mercedes-Benz Model : 280SL w107 Model Version : SL Engine size : 2.7 Model Year : 1980 Location : Prés Seigneurs Vehicle Registration : Undefined

Not priced

Seller Information

GT SPIRIT

GT SPIRIT
04 78 02 10 10

Contact Seller

ClassicDigest Market Radar on Mercedes-Benz 280SL w107

$ £ €

People who viewed this Mercedes-Benz 280SL w107 also viewed similar Mercedes-Benz listed at ClassicDigest

Mercedes-Benz 280SL w107

29000 €

VALENCIA (SPAIN)

Mercedes-Benz 280SL w107

25000 €

ITALY

Mercedes-Benz 280SL w107

15500 €

Nieuwleusen

Mercedes-Benz 280SL w107

135000 €

Graf Zeppelin Platz 1 (MOTORWORLD)DE-71034 Böblingen

Mercedes-Benz 280SL w107

44500 €

Weinsheimerstrasse 39DE-67547 Worms

Other cars listed for sale by this dealer

Porsche 911

Prés Seigneurs

Porsche 928

Prés Seigneurs

Porsche 911

Prés Seigneurs

Mini 1300

Prés Seigneurs

Porsche 911

Prés Seigneurs

About Mercedes-Benz

In the annals of automotive history, the journey of Mercedes-Benz is a tale that unfolds with the ingenuity of its founding pioneers. In the year 1886, Karl Benz crafted the Benz Patent Motorwagen, a creation that would go down in history as the world's inaugural automobile. Unbeknownst to him, this moment marked the genesis of what would evolve into the most illustrious premium car manufacturer globally. The financial underpinning of this pioneering venture, interestingly, was provided by Karl Benz's wife, Bertha Benz, demonstrating a remarkable partnership that would set the tone for Mercedes-Benz's legacy.

A parallel narrative emerged not far away, as Daimler-Motoren-Gesellschaft, founded by Gottlieb Daimler and Wilhelm Maybach, entered the scene. In 1901, they unveiled their automobile under the now-famous moniker "Mercedes," meaning "godsend" in Spanish. This name was bestowed upon the car at the behest of Emil Jellinek's daughter, the distributor for Daimler-Motoren-Gesellschaft. The wheels of innovation were set in motion.

Fast forward to 1926, a pivotal year that witnessed the merger of Daimler with Benz & Cie., culminating in the birth of Daimler-Benz. The amalgamation saw the adoption of "Mercedes-Benz" as the distinguished trademark for their automobiles, fusing the legacies of two visionary entities into one.

Contrary to perceptions of conservatism, the trajectory of Daimler-Benz unfolds as a chronicle of industry firsts. From the introduction of the honeycomb radiator to the float carburetor, and the pioneering implementation of four-wheel brakes in 1924, Daimler-Benz consistently pushed the boundaries of automotive innovation. The diesel-powered Mercedes-Benz 260 D in 1936 marked the inception of diesel engines in passenger cars. The iconic Mercedes-Benz 300SL Gullwing made history as the first car with direct fuel injection, albeit the Gutbrod's tiny 2-stroke engine can claim precedence.

Safety innovations became a hallmark, with Béla Barényi's patented safety cell design in the "Ponton"-models in 1951, featuring front and rear crumple zones. The W116 450SEL 6.9 saw the introduction of the Anti-Lock Brake system (ABS), another pioneering safety feature. From the first production airbags and beyond, the legacy of "firsts" continued to be etched into the fabric of Daimler-Benz.

Over its centennial journey, Mercedes-Benz has not merely produced cars but has sculpted automotive icons. The SSKL, 710 SSK Trossi Roadster, 770K Grosser, 540K Spezial Roadster, 300SL Gullwing, w100 600 Pullman, w111 280SE 3.5 Flachkühler, w113 230SL Pagoda, w109 300 SEL 6.3, and w201 2.3-16 Cosworth stand testament to the brand's commitment to engineering excellence.

The roaring Silver Arrows, or "Silberpfeile," including the W 25, W 125, W154, W165, and W196, created a legacy of dominance on the racetrack. These machines were not merely cars; they were expressions of precision, speed, and an indomitable spirit that left their competitors in the dust.

As Mercedes-Benz marches into the future, it does so not just as an automaker but as a custodian of a legacy, a torchbearer of innovation, and a beacon of automotive excellence. The road ahead is sure to witness the continued fusion of cutting-edge technology, timeless design, and an unwavering commitment to setting new standards in the world of automobiles.

One luminary figure who left an indelible mark was Béla Barényi, often heralded as the "father of passive safety" for his pioneering work in safety engineering. His patented safety cell design, featuring front and rear crumple zones, became a hallmark of Mercedes-Benz's commitment to occupant safety, setting new standards that reverberated throughout the automotive world.

Moving through the chronicles, the collaborative genius of Wilhelm Maybach, alongside Gottlieb Daimler, laid the foundation for Daimler-Motoren-Gesellschaft. Their innovations not only birthed the first Mercedes but established a culture of relentless pursuit of technological excellence that remains integral to Mercedes-Benz's DNA.

In the post-merger era of 1926, Ferdinand Porsche emerged as a prominent figure within Mercedes-Benz. His work on the Mercedes-Benz S-Type, a supercharged race car, garnered acclaim and set the stage for a legacy that extended far beyond the marque. Porsche's impact would later extend to his eponymous company, but his influence at Mercedes-Benz during those formative years was pivotal.

As the 20th century progressed, the legendary Rudolf Uhlenhaut emerged as a key figure. Uhlenhaut, an accomplished engineer and the driving force behind the iconic Silver Arrows, played a crucial role in Mercedes-Benz's dominance in motorsports. His engineering prowess and attention to detail were instrumental in creating some of the most formidable racing cars of the era.

In the latter half of the century, figures like Bruno Sacco, the head of design at Mercedes-Benz from 1975 to 1999, left an indelible imprint on the brand's aesthetic identity. Sacco's design philosophy, characterized by clean lines and timeless elegance, shaped iconic models like the W126 S-Class and the W201 190E, solidifying Mercedes-Benz's reputation for luxury and sophistication.

The narrative would be incomplete without acknowledging the contributions of engineers like Hans Scherenberg, whose leadership in the 1970s ushered in a new era of technological innovation at Mercedes-Benz. Scherenberg's tenure saw the development of groundbreaking technologies, including the Anti-Lock Brake system (ABS) and the introduction of airbags in production 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' => 'mercedes-benz', 'model' => '280sl-w107', 'id' => '186911', '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.11 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=186911 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 (914)
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.64 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=186911
38	Creole	prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=?
39	Creole	executeQuery(): [0.96 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=186911
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.20 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=186911
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(): [0.41 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 (914)
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(): [0.31 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=186911 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.32 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 (186911) ORDER BY carimg.ORD ASC
49	Creole	executeQuery(): [1.03 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 (186911) 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.44 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 (914)
52	Creole	prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=?
53	Creole	executeQuery(): [0.84 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=914 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(): [0.49 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=112 AND model.ID=1215 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 != 186911 AND car.ID_MODEL = '1215' ) 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 != 186911 AND car.ID_MODEL = '1215' ) 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 != 186911 AND car.ID_MODEL = '1215' ) 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 != 186911 AND car.ID_MODEL = '1215' ) ) AS count
58	Creole	executeQuery(): [1.21 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 != 186911 AND car.ID_MODEL = '1215' ) 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 != 186911 AND car.ID_MODEL = '1215' ) ) 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 != 186911 AND car.ID_MODEL = '1215' ) 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 != 186911 AND car.ID_MODEL = '1215' ) ORDER BY ID DESC, offset: 0, limit: 5
60	Creole	executeQuery(): [2.20 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 != 186911 AND car.ID_MODEL = '1215' ) 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 != 186911 AND car.ID_MODEL = '1215' ) 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 (192198,167454,159396,141901,141852) ORDER BY carimg.ORD ASC
62	Creole	executeQuery(): [1.06 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 (192198,167454,159396,141901,141852) 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 != '186911' AND car.ID_NETTI_USER = '914' ) 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 != '186911' AND car.ID_NETTI_USER = '914' ) 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 != '186911' AND car.ID_NETTI_USER = '914' ) 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 != '186911' AND car.ID_NETTI_USER = '914' ) ) AS count
65	Creole	executeQuery(): [4.15 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 != '186911' AND car.ID_NETTI_USER = '914' ) 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 != '186911' AND car.ID_NETTI_USER = '914' ) ) 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 != '186911' AND car.ID_NETTI_USER = '914' ) 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 != '186911' AND car.ID_NETTI_USER = '914' ) ORDER BY ID DESC, offset: 0, limit: 5
67	Creole	executeQuery(): [12.23 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 != '186911' AND car.ID_NETTI_USER = '914' ) 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 != '186911' AND car.ID_NETTI_USER = '914' ) 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 (199661,199660,199659,199658,199573) ORDER BY carimg.ORD ASC
69	Creole	executeQuery(): [0.67 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 (199661,199660,199659,199658,199573) 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(): [0.73 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=112 AND car.ID_MODEL=1215 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(): [6.08 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=112 AND sold_car.ID_MODEL=1215 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 (32735,71963,88354,110088,117204,118342,122127,130907,135482,136234,140097,140126,141722,141852,141901,159396,167454,186911,192198) GROUP BY cmonth ORDER BY date_create
75	Creole	executeQuery(): [0.79 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 (32735,71963,88354,110088,117204,118342,122127,130907,135482,136234,140097,140126,141722,141852,141901,159396,167454,186911,192198) 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 (29011,29825,30458,30459,30970,31023,32032,32033,33228,33387,34862,35348,35504,37088,38982,42418,42673,43836,43932,44398,44399,46381,46746,47148,48606,49131,51661,52479,53565,55226,56621,58982,62091,62684,64524,66601,67383,69406,69594,70221,72563,83726,84940,85023,85709,86702,87213,91218,91506,91509,91595,94447,94498,99057,100371,101163,102528,103719,107240,107533,108187,108404,110487,110909,111188,111725,112761,113252,113436,113445,113828,113889,116011,116105,116299,116742,118341,118983,119056,122227,122605,123178,123664,124485,126900,127171,127571,128049,130939,131415,131699,132148,132280,133025,133213,134152,134156,134158,134531,135414,136050,136077,136575,137558,141940,143380,143568,145111,152557,156056,156704,158624,159551,173701,173775,175883,176065,176476,177598,179474,179475,179682,180686,181923,183734,184126,185217,185583,186278,187304,188896,197406) GROUP BY sold_week ORDER BY scs.date_actual_sold
77	Creole	executeQuery(): [2.50 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 (29011,29825,30458,30459,30970,31023,32032,32033,33228,33387,34862,35348,35504,37088,38982,42418,42673,43836,43932,44398,44399,46381,46746,47148,48606,49131,51661,52479,53565,55226,56621,58982,62091,62684,64524,66601,67383,69406,69594,70221,72563,83726,84940,85023,85709,86702,87213,91218,91506,91509,91595,94447,94498,99057,100371,101163,102528,103719,107240,107533,108187,108404,110487,110909,111188,111725,112761,113252,113436,113445,113828,113889,116011,116105,116299,116742,118341,118983,119056,122227,122605,123178,123664,124485,126900,127171,127571,128049,130939,131415,131699,132148,132280,133025,133213,134152,134156,134158,134531,135414,136050,136077,136575,137558,141940,143380,143568,145111,152557,156056,156704,158624,159551,173701,173775,175883,176065,176476,177598,179474,179475,179682,180686,181923,183734,184126,185217,185583,186278,187304,188896,197406) 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 (29011,29825,30458,30459,30970,31023,32032,32033,33228,33387,34862,35348,35504,37088,38982,42418,42673,43836,43932,44398,44399,46381,46746,47148,48606,49131,51661,52479,53565,55226,56621,58982,62091,62684,64524,66601,67383,69406,69594,70221,72563,83726,84940,85023,85709,86702,87213,91218,91506,91509,91595,94447,94498,99057,100371,101163,102528,103719,107240,107533,108187,108404,110487,110909,111188,111725,112761,113252,113436,113445,113828,113889,116011,116105,116299,116742,118341,118983,119056,122227,122605,123178,123664,124485,126900,127171,127571,128049,130939,131415,131699,132148,132280,133025,133213,134152,134156,134158,134531,135414,136050,136077,136575,137558,141940,143380,143568,145111,152557,156056,156704,158624,159551,173701,173775,175883,176065,176476,177598,179474,179475,179682,180686,181923,183734,184126,185217,185583,186278,187304,188896,197406) GROUP BY sold_month ORDER BY scs.date_actual_sold
79	Creole	executeQuery(): [3.62 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 (29011,29825,30458,30459,30970,31023,32032,32033,33228,33387,34862,35348,35504,37088,38982,42418,42673,43836,43932,44398,44399,46381,46746,47148,48606,49131,51661,52479,53565,55226,56621,58982,62091,62684,64524,66601,67383,69406,69594,70221,72563,83726,84940,85023,85709,86702,87213,91218,91506,91509,91595,94447,94498,99057,100371,101163,102528,103719,107240,107533,108187,108404,110487,110909,111188,111725,112761,113252,113436,113445,113828,113889,116011,116105,116299,116742,118341,118983,119056,122227,122605,123178,123664,124485,126900,127171,127571,128049,130939,131415,131699,132148,132280,133025,133213,134152,134156,134158,134531,135414,136050,136077,136575,137558,141940,143380,143568,145111,152557,156056,156704,158624,159551,173701,173775,175883,176065,176476,177598,179474,179475,179682,180686,181923,183734,184126,185217,185583,186278,187304,188896,197406) 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(): [1154.31 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(): [0.47 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=192198
108	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
109	Creole	executeQuery(): [0.93 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=167454
110	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
111	Creole	executeQuery(): [0.84 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=159396
112	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
113	Creole	executeQuery(): [0.82 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=141901
114	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
115	Creole	executeQuery(): [0.32 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=141852
116	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
117	Creole	executeQuery(): [0.32 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199661
118	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
119	Creole	executeQuery(): [1.20 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199660
120	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
121	Creole	executeQuery(): [1.03 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199659
122	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
123	Creole	executeQuery(): [1.06 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199658
124	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
125	Creole	executeQuery(): [0.48 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199573
126	View	initialize view for "common_page/_include_vif_js"
127	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_include_vif_js.php"
128	PartialHelper	Generate cache key
129	View	initialize view for "common_page/_fancybox_javascript"
130	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
131	PartialHelper	Generate cache key
132	View	decorate content with "sf_app_dir/templates/view_layout.php"
133	View	render "sf_app_dir/templates/view_layout.php"
134	View	initialize view for "common_page/_responsive_javascript"
135	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_javascript.php"
136	PartialHelper	Generate cache key
137	View	initialize view for "common_page/_google_analytics"
138	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_google_analytics.php"
139	PartialHelper	Generate cache key
140	View	initialize view for "common_page/_header_links"
141	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_header_links.php"
142	View	initialize view for "common_page/_fancybox_javascript"
143	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
144	PartialHelper	Generate cache key
145	View	initialize view for "common_page/_cookie_policy"
146	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_cookie_policy.php"
147	PartialHelper	Generate cache key
148	PartialHelper	Generate cache key
149	View	initialize view for "common_page/_responsive_top_menu"
150	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_top_menu.php"
151	PartialHelper	Generate cache key
152	View	initialize view for "common_page/_top_menu"
153	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_top_menu.php"
154	PartialHelper	Generate cache key
155	View	initialize view for "common_page/_footer_javascript"
156	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer_javascript.php"
157	PartialHelper	Generate cache key
158	View	initialize view for "common_page/_footer"
159	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer.php"
160	PartialHelper	Generate cache key

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    ID_AD: 186911
    action: view
    id: 186911
    make: mercedes-benz
    model: 280sl-w107
    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: 1731671921.2262
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/mercedes-benz/280sl-w107/186911
  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/mercedes-benz/280sl-w107/186911
  HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
  PATH_INFO: /mercedes-benz/280sl-w107/186911
  PATH_TRANSLATED: /web/classicdigest.com/web/mercedes-benz/280sl-w107/186911
  PHP_SELF: /cars/index_dev.php/mercedes-benz/280sl-w107/186911
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REMOTE_ADDR: 18.116.37.61
  REMOTE_PORT: 1459
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1731671921
  REQUEST_TIME_FLOAT: 1731671921.2249
  REQUEST_URI: /cars/index_dev.php/mercedes-benz/280sl-w107/186911
  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.11 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=186911 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 (914)
[0.64 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=186911
[0.96 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=186911
[8.20 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=186911
[0.41 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 (914)
[0.31 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=186911 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2'
[0.32 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.03 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 (186911) ORDER BY carimg.ORD ASC
[0.44 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 (914)
[0.84 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=914 AND dealer_permission.WHICH='Q'
[0.49 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=112 AND model.ID=1215 AND make.ID=model.ID_MAKE
[1.21 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 != 186911 AND car.ID_MODEL = '1215' ) 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 != 186911 AND car.ID_MODEL = '1215' ) ) AS count
[2.20 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 != 186911 AND car.ID_MODEL = '1215' ) 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 != 186911 AND car.ID_MODEL = '1215' ) ORDER BY ID DESC LIMIT 5
[1.06 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 (192198,167454,159396,141901,141852) ORDER BY carimg.ORD ASC
[4.15 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 != '186911' AND car.ID_NETTI_USER = '914' ) 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 != '186911' AND car.ID_NETTI_USER = '914' ) ) AS count
[12.23 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 != '186911' AND car.ID_NETTI_USER = '914' ) 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 != '186911' AND car.ID_NETTI_USER = '914' ) ORDER BY ID DESC LIMIT 5
[0.67 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 (199661,199660,199659,199658,199573) ORDER BY carimg.ORD ASC
[0.73 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=112 AND car.ID_MODEL=1215 AND car.STATUS='F'
[6.08 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=112 AND sold_car.ID_MODEL=1215 AND sold_car.STATUS='S'
[0.79 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 (32735,71963,88354,110088,117204,118342,122127,130907,135482,136234,140097,140126,141722,141852,141901,159396,167454,186911,192198) GROUP BY cmonth ORDER BY date_create
[2.50 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 (29011,29825,30458,30459,30970,31023,32032,32033,33228,33387,34862,35348,35504,37088,38982,42418,42673,43836,43932,44398,44399,46381,46746,47148,48606,49131,51661,52479,53565,55226,56621,58982,62091,62684,64524,66601,67383,69406,69594,70221,72563,83726,84940,85023,85709,86702,87213,91218,91506,91509,91595,94447,94498,99057,100371,101163,102528,103719,107240,107533,108187,108404,110487,110909,111188,111725,112761,113252,113436,113445,113828,113889,116011,116105,116299,116742,118341,118983,119056,122227,122605,123178,123664,124485,126900,127171,127571,128049,130939,131415,131699,132148,132280,133025,133213,134152,134156,134158,134531,135414,136050,136077,136575,137558,141940,143380,143568,145111,152557,156056,156704,158624,159551,173701,173775,175883,176065,176476,177598,179474,179475,179682,180686,181923,183734,184126,185217,185583,186278,187304,188896,197406) GROUP BY sold_week ORDER BY scs.date_actual_sold
[3.62 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 (29011,29825,30458,30459,30970,31023,32032,32033,33228,33387,34862,35348,35504,37088,38982,42418,42673,43836,43932,44398,44399,46381,46746,47148,48606,49131,51661,52479,53565,55226,56621,58982,62091,62684,64524,66601,67383,69406,69594,70221,72563,83726,84940,85023,85709,86702,87213,91218,91506,91509,91595,94447,94498,99057,100371,101163,102528,103719,107240,107533,108187,108404,110487,110909,111188,111725,112761,113252,113436,113445,113828,113889,116011,116105,116299,116742,118341,118983,119056,122227,122605,123178,123664,124485,126900,127171,127571,128049,130939,131415,131699,132148,132280,133025,133213,134152,134156,134158,134531,135414,136050,136077,136575,137558,141940,143380,143568,145111,152557,156056,156704,158624,159551,173701,173775,175883,176065,176476,177598,179474,179475,179682,180686,181923,183734,184126,185217,185583,186278,187304,188896,197406) GROUP BY sold_month ORDER BY scs.date_actual_sold
[1154.31 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
[0.47 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=192198
[0.93 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=167454
[0.84 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=159396
[0.82 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=141901
[0.32 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=141852
[0.32 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199661
[1.20 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199660
[1.03 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199659
[1.06 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199658
[0.48 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199573

type	calls	time (ms)
Configuration	13	1.49
Action "home/view"	1	1259.33
Database	34	1212.31
View "Success" for "home/view"	1	49.68
Partial "home/_vif_images"	1	0.48
Partial "common_page/_social_buttons"	1	0.07
Partial "home/_vif_info"	1	0.16
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.04
Partial "common_page/_header_links"	1	0.63
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.09
Partial "common_page/_footer"	1	0.10

Mercedes-Benz 280SL w107 SL 1980

Car Facts

Seller Information

ClassicDigest Market Radar on Mercedes-Benz 280SL w107

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers