| # | 
          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' => 'mg',  'model' => 'td',  'id' => '195246',  '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.22 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=195246 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.57 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 (1204) | 
| 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.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, 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=195246 | 
| 38 |   Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? | 
| 39 |   Creole | executeQuery(): [1.19 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=195246 | 
| 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(): [15.84 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=195246 | 
| 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.88 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 (1204) | 
| 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.62 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=195246 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.55 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 (195246) ORDER BY carimg.ORD ASC | 
| 49 |   Creole | executeQuery(): [0.64 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 (195246) 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.46 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 (1204) | 
| 52 |   Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? | 
| 53 |   Creole | executeQuery(): [0.57 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=1204 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.51 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=115 AND model.ID=1282 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 != 195246 AND car.ID_MODEL = '1282' 					     )                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 != 195246 AND car.ID_MODEL = '1282'                )  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 != 195246 AND car.ID_MODEL = '1282'                       )                       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 != 195246 AND car.ID_MODEL = '1282'                       )                      ) AS count | 
| 58 |   Creole | executeQuery(): [3.11 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 != 195246 AND car.ID_MODEL = '1282'                       )                       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 != 195246 AND car.ID_MODEL = '1282'                       )                      ) 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 != 195246 AND car.ID_MODEL = '1282' 					     )                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 != 195246 AND car.ID_MODEL = '1282'                )  ORDER BY ID DESC, offset: 0, limit: 5 | 
| 60 |   Creole | executeQuery(): [4.50 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 != 195246 AND car.ID_MODEL = '1282' 					     )                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 != 195246 AND car.ID_MODEL = '1282'                )  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 (199220,197508,197360,196420,195158) ORDER BY carimg.ORD ASC | 
| 62 |   Creole | executeQuery(): [0.85 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 (199220,197508,197360,196420,195158) 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 != '195246' AND car.ID_NETTI_USER = '1204' 					     )                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 != '195246' AND car.ID_NETTI_USER = '1204'                )  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 != '195246' AND car.ID_NETTI_USER = '1204'                       )                       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 != '195246' AND car.ID_NETTI_USER = '1204'                       )                      ) AS count | 
| 65 |   Creole | executeQuery(): [5.48 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 != '195246' AND car.ID_NETTI_USER = '1204'                       )                       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 != '195246' AND car.ID_NETTI_USER = '1204'                       )                      ) 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 != '195246' AND car.ID_NETTI_USER = '1204' 					     )                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 != '195246' AND car.ID_NETTI_USER = '1204'                )  ORDER BY ID DESC, offset: 0, limit: 5 | 
| 67 |   Creole | executeQuery(): [11.58 ms] ( 					      SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.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 != '195246' AND car.ID_NETTI_USER = '1204' 					     )                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 != '195246' AND car.ID_NETTI_USER = '1204'                )  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 (199933,199880,199879,199825,199770) ORDER BY carimg.ORD ASC | 
| 69 |   Creole | executeQuery(): [0.99 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 (199933,199880,199879,199825,199770) 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.30 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=115 AND car.ID_MODEL=1282 AND car.STATUS='F' | 
| 72 |   Creole | prepareStatement(): SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=? AND sold_car.ID_MODEL=? AND sold_car.STATUS=? | 
| 73 |   Creole | executeQuery(): [3.55 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=115 AND sold_car.ID_MODEL=1282 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 (21186,21823,25243,25452,28262,31429,44773,105640,116611,122455,122609,123230,123245,126259,126991,127699,130185,131478,135502,135504,135506,150951,151618,152103,154792,155221,166361,169041,172939,174416,175605,177797,178752,179176,179781,180599,180603,181996,182577,184594,185494,192629,194079,195158,195246,196420,197360,197508,199220) GROUP BY cmonth ORDER BY date_create | 
| 75 |   Creole | executeQuery(): [1.42 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 (21186,21823,25243,25452,28262,31429,44773,105640,116611,122455,122609,123230,123245,126259,126991,127699,130185,131478,135502,135504,135506,150951,151618,152103,154792,155221,166361,169041,172939,174416,175605,177797,178752,179176,179781,180599,180603,181996,182577,184594,185494,192629,194079,195158,195246,196420,197360,197508,199220) 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 (20359,20681,20682,20683,20684,20685,20686,21171,21242,21243,21363,21508,21698,21699,21822,21990,22028,22173,22174,22329,22372,22408,22649,23427,23513,23599,23657,24069,24087,24384,24630,24631,24825,24826,25084,25091,25093,25103,25557,25645,25777,25778,26420,26692,26763,27007,27285,27334,27364,27563,27589,27614,27669,28321,28552,28553,28675,29257,29258,29259,29984,30397,30862,31083,31084,31085,31086,31832,32514,32933,33234,35358,40345,41985,46138,46416,46890,46891,46892,46893,48445,49724,50918,52519,54174,54774,56722,56723,56978,57230,57710,58331,59451,59555,60029,60273,60885,60886,61023,61176,61545,62276,62789,63114,63803,63804,64480,64537,65546,66413,66806,67813,69600,70042,71181,72696,73517,73605,74248,74290,74291,74365,74443,74975,75209,75919,76576,76612,76703,78205,83008,84269,84649,84650,85672,86044,86292,86819,87007,87233,87419,88466,92091,92328,93691,95615,98383,99076,99104,99305,101251,101252,101253,101254,101255,101257,101258,101259,101260,101261,101262,101711,102087,102088,102411,103637,105244,105839,105879,106028,106033,106463,108215,108950,108966,109026,109721,110093,110356,110446,110626,110627,111670,112711,113826,113846,115643,116206,116257,116658,117001,117122,117136,117673,117957,118315,118468,118536,118592,120493,121276,122025,122240,123124,123226,123261,123277,123280,123293,123848,123920,124165,125734,125930,125932,126032,126242,126481,126923,127583,129094,129374,130069,130757,133055,133445,135196,135283,135425,136188,136189,136758,136779,137198,137592,137818,138277,138518,138817,141122,141558,141651,142242,143480,144589,146189,146260,146577,146643,147076,147665,148054,149720,149934,151758,151887,152001,153094,153592,153596,154470,155036,155359,155361,155409,155793,156382,156601,156866,157130,157408,157557,158055,158062,159033,159267,159432,159518,159647,160471,161670,162196,162388,162558,162820,162957,163135,163783,163984,164258,164536,164617,164895,165131,165409,165619,165761,165840,165884,165902,166156,166193,166402,166616,167211,167315,167372,167467,168453,168503,168713,169291,169796,169941,170086,170397,171461,171501,171531,172162,172230,172778,173567,173708,173723,173725,174467,174661,174914,174952,174955,175104,175159,175174,175276,176106,176336,176595,176620,176633,176689,176895,177078,177079,177638,177688,177760,178177,178201,178773,180078,180956,180980,181775,183131,184172,184589,185874,186343,186995,187039,187250,187592,187866,188389,188608,188677,189823,189930,191804,192616,193813,194518,195790) 	                GROUP BY sold_week 	                ORDER BY scs.date_actual_sold | 
| 77 |   Creole | executeQuery(): [4.27 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 (20359,20681,20682,20683,20684,20685,20686,21171,21242,21243,21363,21508,21698,21699,21822,21990,22028,22173,22174,22329,22372,22408,22649,23427,23513,23599,23657,24069,24087,24384,24630,24631,24825,24826,25084,25091,25093,25103,25557,25645,25777,25778,26420,26692,26763,27007,27285,27334,27364,27563,27589,27614,27669,28321,28552,28553,28675,29257,29258,29259,29984,30397,30862,31083,31084,31085,31086,31832,32514,32933,33234,35358,40345,41985,46138,46416,46890,46891,46892,46893,48445,49724,50918,52519,54174,54774,56722,56723,56978,57230,57710,58331,59451,59555,60029,60273,60885,60886,61023,61176,61545,62276,62789,63114,63803,63804,64480,64537,65546,66413,66806,67813,69600,70042,71181,72696,73517,73605,74248,74290,74291,74365,74443,74975,75209,75919,76576,76612,76703,78205,83008,84269,84649,84650,85672,86044,86292,86819,87007,87233,87419,88466,92091,92328,93691,95615,98383,99076,99104,99305,101251,101252,101253,101254,101255,101257,101258,101259,101260,101261,101262,101711,102087,102088,102411,103637,105244,105839,105879,106028,106033,106463,108215,108950,108966,109026,109721,110093,110356,110446,110626,110627,111670,112711,113826,113846,115643,116206,116257,116658,117001,117122,117136,117673,117957,118315,118468,118536,118592,120493,121276,122025,122240,123124,123226,123261,123277,123280,123293,123848,123920,124165,125734,125930,125932,126032,126242,126481,126923,127583,129094,129374,130069,130757,133055,133445,135196,135283,135425,136188,136189,136758,136779,137198,137592,137818,138277,138518,138817,141122,141558,141651,142242,143480,144589,146189,146260,146577,146643,147076,147665,148054,149720,149934,151758,151887,152001,153094,153592,153596,154470,155036,155359,155361,155409,155793,156382,156601,156866,157130,157408,157557,158055,158062,159033,159267,159432,159518,159647,160471,161670,162196,162388,162558,162820,162957,163135,163783,163984,164258,164536,164617,164895,165131,165409,165619,165761,165840,165884,165902,166156,166193,166402,166616,167211,167315,167372,167467,168453,168503,168713,169291,169796,169941,170086,170397,171461,171501,171531,172162,172230,172778,173567,173708,173723,173725,174467,174661,174914,174952,174955,175104,175159,175174,175276,176106,176336,176595,176620,176633,176689,176895,177078,177079,177638,177688,177760,178177,178201,178773,180078,180956,180980,181775,183131,184172,184589,185874,186343,186995,187039,187250,187592,187866,188389,188608,188677,189823,189930,191804,192616,193813,194518,195790) 	                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 (20359,20681,20682,20683,20684,20685,20686,21171,21242,21243,21363,21508,21698,21699,21822,21990,22028,22173,22174,22329,22372,22408,22649,23427,23513,23599,23657,24069,24087,24384,24630,24631,24825,24826,25084,25091,25093,25103,25557,25645,25777,25778,26420,26692,26763,27007,27285,27334,27364,27563,27589,27614,27669,28321,28552,28553,28675,29257,29258,29259,29984,30397,30862,31083,31084,31085,31086,31832,32514,32933,33234,35358,40345,41985,46138,46416,46890,46891,46892,46893,48445,49724,50918,52519,54174,54774,56722,56723,56978,57230,57710,58331,59451,59555,60029,60273,60885,60886,61023,61176,61545,62276,62789,63114,63803,63804,64480,64537,65546,66413,66806,67813,69600,70042,71181,72696,73517,73605,74248,74290,74291,74365,74443,74975,75209,75919,76576,76612,76703,78205,83008,84269,84649,84650,85672,86044,86292,86819,87007,87233,87419,88466,92091,92328,93691,95615,98383,99076,99104,99305,101251,101252,101253,101254,101255,101257,101258,101259,101260,101261,101262,101711,102087,102088,102411,103637,105244,105839,105879,106028,106033,106463,108215,108950,108966,109026,109721,110093,110356,110446,110626,110627,111670,112711,113826,113846,115643,116206,116257,116658,117001,117122,117136,117673,117957,118315,118468,118536,118592,120493,121276,122025,122240,123124,123226,123261,123277,123280,123293,123848,123920,124165,125734,125930,125932,126032,126242,126481,126923,127583,129094,129374,130069,130757,133055,133445,135196,135283,135425,136188,136189,136758,136779,137198,137592,137818,138277,138518,138817,141122,141558,141651,142242,143480,144589,146189,146260,146577,146643,147076,147665,148054,149720,149934,151758,151887,152001,153094,153592,153596,154470,155036,155359,155361,155409,155793,156382,156601,156866,157130,157408,157557,158055,158062,159033,159267,159432,159518,159647,160471,161670,162196,162388,162558,162820,162957,163135,163783,163984,164258,164536,164617,164895,165131,165409,165619,165761,165840,165884,165902,166156,166193,166402,166616,167211,167315,167372,167467,168453,168503,168713,169291,169796,169941,170086,170397,171461,171501,171531,172162,172230,172778,173567,173708,173723,173725,174467,174661,174914,174952,174955,175104,175159,175174,175276,176106,176336,176595,176620,176633,176689,176895,177078,177079,177638,177688,177760,178177,178201,178773,180078,180956,180980,181775,183131,184172,184589,185874,186343,186995,187039,187250,187592,187866,188389,188608,188677,189823,189930,191804,192616,193813,194518,195790) 	                GROUP BY sold_month 	                ORDER BY scs.date_actual_sold | 
| 79 |   Creole | executeQuery(): [5.76 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 (20359,20681,20682,20683,20684,20685,20686,21171,21242,21243,21363,21508,21698,21699,21822,21990,22028,22173,22174,22329,22372,22408,22649,23427,23513,23599,23657,24069,24087,24384,24630,24631,24825,24826,25084,25091,25093,25103,25557,25645,25777,25778,26420,26692,26763,27007,27285,27334,27364,27563,27589,27614,27669,28321,28552,28553,28675,29257,29258,29259,29984,30397,30862,31083,31084,31085,31086,31832,32514,32933,33234,35358,40345,41985,46138,46416,46890,46891,46892,46893,48445,49724,50918,52519,54174,54774,56722,56723,56978,57230,57710,58331,59451,59555,60029,60273,60885,60886,61023,61176,61545,62276,62789,63114,63803,63804,64480,64537,65546,66413,66806,67813,69600,70042,71181,72696,73517,73605,74248,74290,74291,74365,74443,74975,75209,75919,76576,76612,76703,78205,83008,84269,84649,84650,85672,86044,86292,86819,87007,87233,87419,88466,92091,92328,93691,95615,98383,99076,99104,99305,101251,101252,101253,101254,101255,101257,101258,101259,101260,101261,101262,101711,102087,102088,102411,103637,105244,105839,105879,106028,106033,106463,108215,108950,108966,109026,109721,110093,110356,110446,110626,110627,111670,112711,113826,113846,115643,116206,116257,116658,117001,117122,117136,117673,117957,118315,118468,118536,118592,120493,121276,122025,122240,123124,123226,123261,123277,123280,123293,123848,123920,124165,125734,125930,125932,126032,126242,126481,126923,127583,129094,129374,130069,130757,133055,133445,135196,135283,135425,136188,136189,136758,136779,137198,137592,137818,138277,138518,138817,141122,141558,141651,142242,143480,144589,146189,146260,146577,146643,147076,147665,148054,149720,149934,151758,151887,152001,153094,153592,153596,154470,155036,155359,155361,155409,155793,156382,156601,156866,157130,157408,157557,158055,158062,159033,159267,159432,159518,159647,160471,161670,162196,162388,162558,162820,162957,163135,163783,163984,164258,164536,164617,164895,165131,165409,165619,165761,165840,165884,165902,166156,166193,166402,166616,167211,167315,167372,167467,168453,168503,168713,169291,169796,169941,170086,170397,171461,171501,171531,172162,172230,172778,173567,173708,173723,173725,174467,174661,174914,174952,174955,175104,175159,175174,175276,176106,176336,176595,176620,176633,176689,176895,177078,177079,177638,177688,177760,178177,178201,178773,180078,180956,180980,181775,183131,184172,184589,185874,186343,186995,187039,187250,187592,187866,188389,188608,188677,189823,189930,191804,192616,193813,194518,195790) 	                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(): [1783.97 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.57 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199220 | 
| 108 |   Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? | 
| 109 |   Creole | executeQuery(): [5.56 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197508 | 
| 110 |   Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? | 
| 111 |   Creole | executeQuery(): [6.82 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197360 | 
| 112 |   Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? | 
| 113 |   Creole | executeQuery(): [7.96 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=196420 | 
| 114 |   Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? | 
| 115 |   Creole | executeQuery(): [12.91 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=195158 | 
| 116 |   Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? | 
| 117 |   Creole | executeQuery(): [10.72 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199933 | 
| 118 |   Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? | 
| 119 |   Creole | executeQuery(): [0.78 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199880 | 
| 120 |   Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? | 
| 121 |   Creole | executeQuery(): [11.89 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199879 | 
| 122 |   Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? | 
| 123 |   Creole | executeQuery(): [16.48 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199825 | 
| 124 |   Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? | 
| 125 |   Creole | executeQuery(): [15.61 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199770 | 
| 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 |