| # |
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' => 'jaguar', 'model' => 'e-type', 'id' => '180634', '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(): [2.19 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=180634 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(): [1.20 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 (140) |
| 36 | Creole | prepareStatement(): SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, DATE_ADD(car.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) WHERE car.ID=? |
| 37 | Creole | executeQuery(): [1.27 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=180634 |
| 38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
| 39 | Creole | executeQuery(): [0.40 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=180634 |
| 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(): [7.21 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=180634 |
| 42 | Creole | prepareStatement(): SELECT netti_dealer.ID_DEALER, netti_dealer.ID, netti_dealer.PATH, netti_dealer.COMPANY, netti_dealer.SLOGAN, netti_dealer.URL, netti_dealer.SIMPLE_URL, netti_dealer.HAS_SITE FROM netti_dealer WHERE netti_dealer.ID_DEALER IN (?) |
| 43 | Creole | executeQuery(): [1.75 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 (140) |
| 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.37 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=180634 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2' |
| 46 | Creole | prepareStatement(): SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID=? |
| 47 | Creole | executeQuery(): [1.28 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 (180634) ORDER BY carimg.ORD ASC |
| 49 | Creole | executeQuery(): [1.52 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 (180634) 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.96 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 (140) |
| 52 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
| 53 | Creole | executeQuery(): [1.26 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=140 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=92 AND model.ID=965 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 != 180634 AND car.ID_MODEL = '965' ) 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 != 180634 AND car.ID_MODEL = '965' ) 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 != 180634 AND car.ID_MODEL = '965' ) 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 != 180634 AND car.ID_MODEL = '965' ) ) AS count |
| 58 | Creole | executeQuery(): [7.01 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 != 180634 AND car.ID_MODEL = '965' ) 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 != 180634 AND car.ID_MODEL = '965' ) ) 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 != 180634 AND car.ID_MODEL = '965' ) 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 != 180634 AND car.ID_MODEL = '965' ) ORDER BY ID DESC, offset: 0, limit: 5 |
| 60 | Creole | executeQuery(): [12.86 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 != 180634 AND car.ID_MODEL = '965' ) 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 != 180634 AND car.ID_MODEL = '965' ) 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 (199741,199484,199394,199291,198911) ORDER BY carimg.ORD ASC |
| 62 | Creole | executeQuery(): [0.84 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 (199741,199484,199394,199291,198911) 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 != '180634' AND car.ID_NETTI_USER = '140' ) 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 != '180634' AND car.ID_NETTI_USER = '140' ) 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 != '180634' AND car.ID_NETTI_USER = '140' ) 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 != '180634' AND car.ID_NETTI_USER = '140' ) ) AS count |
| 65 | Creole | executeQuery(): [20.14 ms] SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '180634' AND car.ID_NETTI_USER = '140' ) 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 != '180634' AND car.ID_NETTI_USER = '140' ) ) 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 != '180634' AND car.ID_NETTI_USER = '140' ) 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 != '180634' AND car.ID_NETTI_USER = '140' ) ORDER BY ID DESC, offset: 0, limit: 5 |
| 67 | Creole | executeQuery(): [33.10 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 != '180634' AND car.ID_NETTI_USER = '140' ) 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 != '180634' AND car.ID_NETTI_USER = '140' ) 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 (180639,180638,180637,180636,180635) ORDER BY carimg.ORD ASC |
| 69 | Creole | executeQuery(): [1.28 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (180639,180638,180637,180636,180635) 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.26 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=92 AND car.ID_MODEL=965 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(): [32.52 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=92 AND sold_car.ID_MODEL=965 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 (21188,21190,21195,23668,25244,26538,26539,30941,31404,33322,35555,38895,46406,53214,55435,61806,64365,74488,76959,86865,93367,95281,98678,102622,103486,103717,106138,110081,110778,113003,113428,115268,115311,116519,116694,117879,118600,121901,121902,123212,123287,124578,129834,129835,130193,130551,131815,133778,136309,136371,138395,139488,139587,140905,140923,141598,142082,142424,142597,142777,142827,142943,145910,145912,151941,152940,155210,157048,157065,161982,163885,165193,165443,165697,165698,166206,166297,166619,168461,168820,169029,169203,169961,170761,171688,171807,172149,174753,174903,175044,175588,176269,176449,176546,176574,176854,176901,177277,177479,177486,178267,178680,178684,178703,178706,179115,179626,179768,180219,180407,180414,180420,180593,180621,180634,180673,182009,183387,184528,185094,186168,186253,186408,186529,186721,187203,187244,187641,187941,188184,188192,188330,188508,188762,189722,190132,190307,190354,191353,191422,192592,192852,193174,193184,193185,193682,193896,193902,193903,193905,193956,193980,194219,194490,194584,194585,194724,194799,194978,195657,197099,197337,197784,197849,198441,198674,198911,199291,199394,199484,199741) GROUP BY cmonth ORDER BY date_create |
| 75 | Creole | executeQuery(): [1.67 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 (21188,21190,21195,23668,25244,26538,26539,30941,31404,33322,35555,38895,46406,53214,55435,61806,64365,74488,76959,86865,93367,95281,98678,102622,103486,103717,106138,110081,110778,113003,113428,115268,115311,116519,116694,117879,118600,121901,121902,123212,123287,124578,129834,129835,130193,130551,131815,133778,136309,136371,138395,139488,139587,140905,140923,141598,142082,142424,142597,142777,142827,142943,145910,145912,151941,152940,155210,157048,157065,161982,163885,165193,165443,165697,165698,166206,166297,166619,168461,168820,169029,169203,169961,170761,171688,171807,172149,174753,174903,175044,175588,176269,176449,176546,176574,176854,176901,177277,177479,177486,178267,178680,178684,178703,178706,179115,179626,179768,180219,180407,180414,180420,180593,180621,180634,180673,182009,183387,184528,185094,186168,186253,186408,186529,186721,187203,187244,187641,187941,188184,188192,188330,188508,188762,189722,190132,190307,190354,191353,191422,192592,192852,193174,193184,193185,193682,193896,193902,193903,193905,193956,193980,194219,194490,194584,194585,194724,194799,194978,195657,197099,197337,197784,197849,198441,198674,198911,199291,199394,199484,199741) 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 (20332,20336,20351,20355,20364,20376,20643,20644,20645,20646,20647,20648,20649,20650,20651,20652,20812,20856,20857,20910,20911,20953,20954,20955,21018,21064,21065,21112,21113,21165,21237,21291,21352,21353,21354,21355,21371,21418,21419,21455,21456,21567,21636,21637,21654,21743,21796,21797,21798,21862,21877,21921,21922,21923,21924,21972,22046,22085,22086,22118,22119,22120,22164,22165,22166,22223,22224,22225,22226,22272,22273,22320,22321,22322,22402,22403,22404,22419,22433,22440,22471,22472,22473,22487,22641,22642,22643,22659,23057,23276,23277,23278,23279,23354,23355,23356,23357,23358,23359,23360,23417,23418,23510,23511,23577,23704,23778,23816,23817,23818,23880,23881,23980,23981,23982,23983,24062,24076,24083,24126,24127,24180,24320,24326,24327,24328,24329,24331,24563,24564,24565,24566,24567,24568,24966,25000,25001,25002,25032,25051,25060,25089,25140,25141,25143,25190,25285,25325,25403,25404,25422,25478,25479,25480,25497,25500,25556,25590,25641,25661,25704,25772,25773,25774,25775,25828,25850,25865,25882,25926,25927,25928,25980,26012,26013,26014,26029,26035,26099,26100,26101,26177,26178,26179,26265,26266,26289,26290,26292,26293,26355,26415,26416,26506,26534,26567,26640,26641,26642,26643,26644,26645,26646,26647,26672,26673,26759,26760,26914,26941,26942,26967,27006,27094,27127,27128,27129,27295,27298,27332,27370,27389,27412,27517,27559,27667,27688,27901,28412,28526,29250,29268,29291,29445,29446,29578,29616,30005,30038,30136,30544,30636,30637,30638,30845,30902,30942,30943,31528,31531,31667,31668,31669,31670,31819,31820,32352,32769,32838,32927,32928,32929,33001,33127,33453,33454,33455,33490,33586,33587,33761,33940,33971,33972,34304,34537,34797,34798,34799,34800,34893,35238,35246,35430,35539,36109,36227,36421,36459,36460,36461,36462,36520,36737,36749,36868,36876,36906,37083,37093,38729,38820,38837,38851,38894,38974,39343,39354,39485,39613,39698,41978,42050,42560,42670,43176,43179,43341,44626,44657,44712,45580,45581,45639,45789,46037,46308,46403,46413,46507,46511,46859,46860,46861,46863,46864,46865,46866,46867,46868,46869,46870,46998,47024,47095,47191,47192,48321,48357,48358,48387,48438,48553,48604,48619,48801,48836,48837,49068,49070,49094,49095,49141,49142,49383,49465,49466,49529,49530,49531,49532,49812,49972,49983,50234,50235,50529,50534,50754,50803,50836,50844,50877,50935,50946,50950,51133,51150,51156,51157,51612,51613,51614,51725,51895,51931,51953,51955,52005,52016,52047,52412,52413,52414,52441,52465,52516,52549,52628,52629,52630,53047,53076,53150,53151,53550,53604,53605,53662,53663,53664,53767,53784,53786,53840,54045,54046,54047,54394,54439,55838,56315,56316,56487,56609,56610,56611,57394,57534,58669,58790,58791,59009,59041,59081,59111,59303,59504,59527,59561,59664,59703,60019,60020,60021,60022,60023,60183,60323,60324,60325,60628,60642,60843,60879,61170,61467,61646,61733,61738,62182,62452,62897,62898,62962,63187,63219,63798,63851,63895,64014,64040,64415,64470,64471,64619,64639,64720,65191,65192,65386,65391,65664,65665,65885,65886,65887,65888,65889,65890,66456,66457,66458,66459,66769,67382,67466,67467,67613,67614,67615,67617,67735,67736,68010,68017,68455,68456,68523,68629,68719,68731,68750,69244,69245,69285,69344,69345,69346,69347,69403,69470,69530,69572,70186,70187,70188,70384,70399,70470,70471,70487,70509,70529,70548,70549,70550,71021,71022,71023,71114,71277,71850,71851,71852,71853,71874,71971,72076,72077,72078,72614,72615,72616,72687,72688,72689,72690,72691,72790,72792,72823,72844,72881,73437,73507,73508,73509,73510,73511,73594,73632,73757,73761,74193,74284,74390,74410,74425,74543,75072,75073,75147,75238,75864,75912,75913,76118,76148,76169,76171,76183,76194,76195,76592,76593,76696,76697,76698,76699,76700,76848,77499,77500,77501,77502,77503,77504,77505,77506,78550,78551,78552,79702,80919,81211,81212,81491,81895,81906,81942,82477,82478,82557,83004,83005,83224,83260,83303,83399,83418,83616,83724,84037,84082,84333,84334,84494,84608,84797,84936,85064,85120,85165,85237,85366,85367,85368,85369,85545,85646,85786,85787,85993,86167,86230,86231,86232,86267,86274,86361,86363,86617,86618,86802,86913,86914,86915,86990,87048,87049,87050,87298,87794,88124,88125,88662,88963,88964,88965,89001,89086,89087,89415,90186,90373,91055,91151,91263,91549,91649,91650,91651,91957,91958,92087,92253,92980,93752,93753,93754,94301,94302,94872,94943,95580,95639,95665,95707,95778,95959,97795,97796,97797,97892,97893,98263,98264,98265,98266,98267,98449,98660,98811,98812,98813,99044,99093,99094,99097,99241,99260,100171,100211,100212,100213,100592,101098,101099,101236,101508,101788,102646,102654,102655,102771,103015,103016,103017,103138,103465,103475,103586,103587,103588,103589,103590,103597,103682,103683,103843,103895,104320,104371,104491,104492,105040,105437,105530,105704,105800,105827,105828,105856,106076,106124,106154,106172,106173,106184,106212,106244,106245,106246,106247,106248,106375,106376,106461,106478,106563,106619,106666,106723,106816,106945,106946,107054,107068,107118,107180,107230,107231,107232,107296,107341,107342,107343,107383,107541,107571,108207,108208,108270,108271,108272,108370,108412,108413,108422,108438,108439,108489,108508,108591,108623,108624,108625,108645,108798,108836,109046,109071,109118,109130,109131,109132,109133,109134,109171,109220,109221,109222,109223,109554,109646,109647,110054,110055,110082,110203,110467,110468,110552,110593,110625,110670,110718,110779,110844,110845,110846,110847,110848,110985,111149,111220,111221,111784,111785,111786,111787,111788,111789,111790,111791,111792,111793,112295,112334,112409,112628,112703,112704,112809,112875,112918,113002,113030,113090,113091,113092,113093,113162,113263,113336,113381,113412,113429,113430,113434,113458,113459,113562,113563,113588,113789,114008,114020,114099,114265,114311,114436,114437,114438,114439,114611,115182,115221,115256,115310,115327,115627,115628,115629,115630,115744,115875,115876,115944,115953,116229,116308,116309,116355,116363,116401,116433,116597,116607,116649,116738,117058,117082,117083,117084,117085,117086,117087,117088,117089,117090,117091,117092,117093,117094,117095,117096,117097,117098,117099,117100,117231,117232,117233,117577,117578,117579,117580,117727,117833,117889,118004,118005,118006,118120,118172,118251,118257,118356,118357,118358,118359,118442,118443,118585,118628,118629,118630,118748,118761,118767,118829,118830,118886,118932,118933,118934,118986,119087,119126,119406,119407,119438,119752,119878,119886,120033,120394,120395,120396,120397,121024,121180,121482,121761,121869,121924,121925,121926,121927,121928,121929,121930,122065,122169,122409,122447,122498,122603,122604,122646,122691,122777,122830,122831,122832,122873,122976,122977,122978,123143,123147,123148,123262,123357,123404,123408,123600,123601,123745,123770,123783,123917,123918,124158,124159,124212,124289,124375,124376,124398,124403,124408,124562,124563,124565,124567,125476,125477,125689,125750,125836,125876,125877,125878,125990,126015,126120,126185,126186,126248,126249,126388,126389,126390,126421,126464,126479,126538,126583,126673,126713,126714,126842,126843,126844,126897,126980,127108,127109,127314,127315,127316,127317,127562,127563,127564,127628,127695,127900,127987,127988,127989,127990,127991,128100,128363,128368,128392,128402,128446,128553,128554,128620,128656,128689,128735,128838,129087,129088,129089,129170,129216,129217,129218,129294,129362,129363,129364,129437,129476,129633,129857,129981,129982,130030,130227,130228,130302,130303,130304,130305,130306,130307,130308,130517,130718,130719,130720,130849,130979,130980,130981,130982,131093,131094,131123,131428,131730,131789,131814,132013,132014,132015,132066,132278,132285,132338,132398,132407,132408,132409,132477,132672,132693,132757,132758,132759,132998,133050,133051,133052,133103,133250,133284,133340,133341,133380,133469,133550,133611,133612,133613,133814,133827,133828,133829,133897,133898,133899,133900,133964,133965,133966,134016,134097,134164,134171,134180,134181,134205,134522,134523,135007,135008,135009,135195,135220,135233,135275,135368,135431,135475,135500,135575,135576,135577,135578,135579,135580,135626,135990,136004,136012,136013,136061,136062,136104,136335,136384,136385,136386,136387,136388,136423,136433,136572,136573,136586,136710,136773,136774,136775,137276,138630,138810,138811,138812,138984,138985,139397,139402,140095,140169,140453,140454,140455,140456,140457,140458,140459,140681,140682,140783,140819,141004,141111,141112,141113,141114,141189,141190,141335,141360,141432,141474,141544,141545,141546,141623,141654,141677,141830,141831,142004,142238,142296,142680,142681,142682,142683,142725,142750,143026,143027,143368,143436,143437,143490,143547,143548,143549,143550,143658,143976,144073,144169,144170,144207,144388,144739,144740,144810,144811,144853,144936,144981,144982,144983,145165,145189,145190,145438,145439,145572,145905,145907,145908,145909,146021,146051,146153,146157,146186,146194,146244,146336,146337,146338,146339,146340,146341,146342,146343,146344,146356,146639,146703,146779,146987,147072,147240,147296,147297,147298,147365,147451,147452,147453,147454,147592,147649,147657,147761,147936,148110,148232,148386,148505,148592,148683,148990,148992,148993,149062,149131,149186,149363,149690,149742,149747,149748,149773,149785,149795,149852,149869,149998,150052,150077,150145,150196,150203,150233,150239,150406,150413,150428,150498,150509,150524,150634,150636,150768,150791,150810,150917,150966,151040,151078,151108,151216,151217,151268,151299,151324,151412,151428,151504,151667,151681,151760,151761,151799,151873,151884,151896,151907,151975,151986,152007,152057,152058,152073,152266,152451,152546,152603,152605,152629,152630,152777,152914,153113,153139,153146,153302,153318,153400,153508,154079,154081,154083,154093,154553,154581,154582,154763,154851,154857,154943,154968,154990,154992,155126,155341,155363,155454,155588,155591,155613,155698,155699,155757,155781,155995,155997,156108,156109,156133,156185,156241,156280,156281,156282,156288,156323,156361,156375,156530,156592,156642,156680,156681,156709,156945,157115,157119,157243,157402,157405,157416,157543,157548,157555,157577,157581,157786,157790,157868,157925,157930,157932,157941,157947,158009,158068,158090,158112,158124,158146,158214,158215,158231,158242,158279,158292,158312,158318,158413,158486,158488,158507,158530,158551,158628,158675,158688,158723,158724,158739,158772,158776,158949,158951,158957,158970,158971,158972,159006,159151,159214,159215,159247,159250,159279,159403,159404,159431,159540,159546,159553,159614,159624,159644,159685,159761,159763,159765,159767,159774,159776,159895,160124,160133,160163,160193,160195,160202,160248,160254,160263,160311,160377,160387,160426,160604,160607,160629,160634,160637,160658,160807,160808,161036,161166,161169,161170,161566,161576,161584,161724,161909,161917,162016,162045,162057,162137,162240,162251,162254,162301,162386,162419,162425,162541,162550,162607,162608,162612,162660,162694,162715,162740,162759,162760,162858,162859,162929,162932,163088,163144,163321,163329,163335,163360,163587,163639,163641,163642,163668,163916,163917,163946,163977,163993,164022,164136,164327,164380,164465,164467,164545,164551,164592,164601,164731,164877,164880,164882,164884,164980,164986,164995,165034,165061,165076,165083,165110,165129,165135,165175,165208,165222,165244,165262,165280,165349,165357,165358,165495,165496,165502,165503,165505,165571,165576,165615,165654,165670,165673,165713,165874,165998,166006,166014,166204,166205,166301,166430,166605,166618,166809,166824,166827,167015,167199,167202,167273,167316,167318,167319,167554,167812,167814,167907,167915,167995,168011,168113,168152,168180,168184,168186,168238,168291,168296,168402,168450,168489,168493,168494,168523,168530,168752,168753,168862,168947,168955,169074,169150,169263,169270,169292,169359,169449,169456,169500,169512,169546,169567,169616,169673,169695,169811,169853,170028,170042,170146,170211,170235,170292,170364,170369,170370,170372,170388,170458,170541,170616,170714,170763,170772,170775,170955,170966,170983,171016,171028,171122,171170,171316,171341,171344,171384,171385,171386,171402,171504,171505,171511,171548,171557,171672,171808,171881,171885,171896,172079,172105,172163,172175,172183,172403,172408,172410,172414,172416,172423,172480,172483,172511,172568,172639,172819,173013,173037,173198,173403,173499,173555,173565,173710,174010,174015,174028,174130,174137,174155,174193,174424,174431,174432,174440,174444,174559,174572,174588,174684,174688,174710,174712,174825,174826,174927,174946,175032,175146,175192,175278,175287,175304,175398,175475,175511,175591,175593,175613,175704,175710,175845,175873,175891,175972,175989,175992,176087,176131,176157,176352,176392,176432,176445,176513,176556,176584,176614,176704,176706,177082,177215,177220,177349,177481,177628,177749,177896,178042,178268,178408,178417,178931,179129,179431,179754,179759,179877,179892,180057,180122,180125,180226,180321,180327,180534,180689,180728,180812,180926,180966,181665,181880,181999,182000,182231,182691,182692,182815,183044,183133,183226,183340,183384,183533,183534,183535,183541,183577,183586,183589,183868,183943,184127,184148,184260,184267,184333,184334,184465,184657,184789,184799,184800,184932,185099,185226,185238,185387,185388,185561,185575,185815,185937,185984,186170,186248,186250,186518,186560,186590,186722,186876,186891,187021,187242,187252,187579,187712,187940,188364,188366,188440,188624,188636,188637,188647,188822,188834,188836,188846,189161,189162,189315,189373,189387,189412,189424,189492,189496,189536,189648,190705,190835,190955,191045,191233,191420,191482,191599,191628,191840,191841,191856,191869,192211,192399,192756,192942,192943,193069,193317,193354,193569,193577,194143,194504,197071,197148,197279) GROUP BY sold_week ORDER BY scs.date_actual_sold |
| 77 | Creole | executeQuery(): [21.31 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 (20332,20336,20351,20355,20364,20376,20643,20644,20645,20646,20647,20648,20649,20650,20651,20652,20812,20856,20857,20910,20911,20953,20954,20955,21018,21064,21065,21112,21113,21165,21237,21291,21352,21353,21354,21355,21371,21418,21419,21455,21456,21567,21636,21637,21654,21743,21796,21797,21798,21862,21877,21921,21922,21923,21924,21972,22046,22085,22086,22118,22119,22120,22164,22165,22166,22223,22224,22225,22226,22272,22273,22320,22321,22322,22402,22403,22404,22419,22433,22440,22471,22472,22473,22487,22641,22642,22643,22659,23057,23276,23277,23278,23279,23354,23355,23356,23357,23358,23359,23360,23417,23418,23510,23511,23577,23704,23778,23816,23817,23818,23880,23881,23980,23981,23982,23983,24062,24076,24083,24126,24127,24180,24320,24326,24327,24328,24329,24331,24563,24564,24565,24566,24567,24568,24966,25000,25001,25002,25032,25051,25060,25089,25140,25141,25143,25190,25285,25325,25403,25404,25422,25478,25479,25480,25497,25500,25556,25590,25641,25661,25704,25772,25773,25774,25775,25828,25850,25865,25882,25926,25927,25928,25980,26012,26013,26014,26029,26035,26099,26100,26101,26177,26178,26179,26265,26266,26289,26290,26292,26293,26355,26415,26416,26506,26534,26567,26640,26641,26642,26643,26644,26645,26646,26647,26672,26673,26759,26760,26914,26941,26942,26967,27006,27094,27127,27128,27129,27295,27298,27332,27370,27389,27412,27517,27559,27667,27688,27901,28412,28526,29250,29268,29291,29445,29446,29578,29616,30005,30038,30136,30544,30636,30637,30638,30845,30902,30942,30943,31528,31531,31667,31668,31669,31670,31819,31820,32352,32769,32838,32927,32928,32929,33001,33127,33453,33454,33455,33490,33586,33587,33761,33940,33971,33972,34304,34537,34797,34798,34799,34800,34893,35238,35246,35430,35539,36109,36227,36421,36459,36460,36461,36462,36520,36737,36749,36868,36876,36906,37083,37093,38729,38820,38837,38851,38894,38974,39343,39354,39485,39613,39698,41978,42050,42560,42670,43176,43179,43341,44626,44657,44712,45580,45581,45639,45789,46037,46308,46403,46413,46507,46511,46859,46860,46861,46863,46864,46865,46866,46867,46868,46869,46870,46998,47024,47095,47191,47192,48321,48357,48358,48387,48438,48553,48604,48619,48801,48836,48837,49068,49070,49094,49095,49141,49142,49383,49465,49466,49529,49530,49531,49532,49812,49972,49983,50234,50235,50529,50534,50754,50803,50836,50844,50877,50935,50946,50950,51133,51150,51156,51157,51612,51613,51614,51725,51895,51931,51953,51955,52005,52016,52047,52412,52413,52414,52441,52465,52516,52549,52628,52629,52630,53047,53076,53150,53151,53550,53604,53605,53662,53663,53664,53767,53784,53786,53840,54045,54046,54047,54394,54439,55838,56315,56316,56487,56609,56610,56611,57394,57534,58669,58790,58791,59009,59041,59081,59111,59303,59504,59527,59561,59664,59703,60019,60020,60021,60022,60023,60183,60323,60324,60325,60628,60642,60843,60879,61170,61467,61646,61733,61738,62182,62452,62897,62898,62962,63187,63219,63798,63851,63895,64014,64040,64415,64470,64471,64619,64639,64720,65191,65192,65386,65391,65664,65665,65885,65886,65887,65888,65889,65890,66456,66457,66458,66459,66769,67382,67466,67467,67613,67614,67615,67617,67735,67736,68010,68017,68455,68456,68523,68629,68719,68731,68750,69244,69245,69285,69344,69345,69346,69347,69403,69470,69530,69572,70186,70187,70188,70384,70399,70470,70471,70487,70509,70529,70548,70549,70550,71021,71022,71023,71114,71277,71850,71851,71852,71853,71874,71971,72076,72077,72078,72614,72615,72616,72687,72688,72689,72690,72691,72790,72792,72823,72844,72881,73437,73507,73508,73509,73510,73511,73594,73632,73757,73761,74193,74284,74390,74410,74425,74543,75072,75073,75147,75238,75864,75912,75913,76118,76148,76169,76171,76183,76194,76195,76592,76593,76696,76697,76698,76699,76700,76848,77499,77500,77501,77502,77503,77504,77505,77506,78550,78551,78552,79702,80919,81211,81212,81491,81895,81906,81942,82477,82478,82557,83004,83005,83224,83260,83303,83399,83418,83616,83724,84037,84082,84333,84334,84494,84608,84797,84936,85064,85120,85165,85237,85366,85367,85368,85369,85545,85646,85786,85787,85993,86167,86230,86231,86232,86267,86274,86361,86363,86617,86618,86802,86913,86914,86915,86990,87048,87049,87050,87298,87794,88124,88125,88662,88963,88964,88965,89001,89086,89087,89415,90186,90373,91055,91151,91263,91549,91649,91650,91651,91957,91958,92087,92253,92980,93752,93753,93754,94301,94302,94872,94943,95580,95639,95665,95707,95778,95959,97795,97796,97797,97892,97893,98263,98264,98265,98266,98267,98449,98660,98811,98812,98813,99044,99093,99094,99097,99241,99260,100171,100211,100212,100213,100592,101098,101099,101236,101508,101788,102646,102654,102655,102771,103015,103016,103017,103138,103465,103475,103586,103587,103588,103589,103590,103597,103682,103683,103843,103895,104320,104371,104491,104492,105040,105437,105530,105704,105800,105827,105828,105856,106076,106124,106154,106172,106173,106184,106212,106244,106245,106246,106247,106248,106375,106376,106461,106478,106563,106619,106666,106723,106816,106945,106946,107054,107068,107118,107180,107230,107231,107232,107296,107341,107342,107343,107383,107541,107571,108207,108208,108270,108271,108272,108370,108412,108413,108422,108438,108439,108489,108508,108591,108623,108624,108625,108645,108798,108836,109046,109071,109118,109130,109131,109132,109133,109134,109171,109220,109221,109222,109223,109554,109646,109647,110054,110055,110082,110203,110467,110468,110552,110593,110625,110670,110718,110779,110844,110845,110846,110847,110848,110985,111149,111220,111221,111784,111785,111786,111787,111788,111789,111790,111791,111792,111793,112295,112334,112409,112628,112703,112704,112809,112875,112918,113002,113030,113090,113091,113092,113093,113162,113263,113336,113381,113412,113429,113430,113434,113458,113459,113562,113563,113588,113789,114008,114020,114099,114265,114311,114436,114437,114438,114439,114611,115182,115221,115256,115310,115327,115627,115628,115629,115630,115744,115875,115876,115944,115953,116229,116308,116309,116355,116363,116401,116433,116597,116607,116649,116738,117058,117082,117083,117084,117085,117086,117087,117088,117089,117090,117091,117092,117093,117094,117095,117096,117097,117098,117099,117100,117231,117232,117233,117577,117578,117579,117580,117727,117833,117889,118004,118005,118006,118120,118172,118251,118257,118356,118357,118358,118359,118442,118443,118585,118628,118629,118630,118748,118761,118767,118829,118830,118886,118932,118933,118934,118986,119087,119126,119406,119407,119438,119752,119878,119886,120033,120394,120395,120396,120397,121024,121180,121482,121761,121869,121924,121925,121926,121927,121928,121929,121930,122065,122169,122409,122447,122498,122603,122604,122646,122691,122777,122830,122831,122832,122873,122976,122977,122978,123143,123147,123148,123262,123357,123404,123408,123600,123601,123745,123770,123783,123917,123918,124158,124159,124212,124289,124375,124376,124398,124403,124408,124562,124563,124565,124567,125476,125477,125689,125750,125836,125876,125877,125878,125990,126015,126120,126185,126186,126248,126249,126388,126389,126390,126421,126464,126479,126538,126583,126673,126713,126714,126842,126843,126844,126897,126980,127108,127109,127314,127315,127316,127317,127562,127563,127564,127628,127695,127900,127987,127988,127989,127990,127991,128100,128363,128368,128392,128402,128446,128553,128554,128620,128656,128689,128735,128838,129087,129088,129089,129170,129216,129217,129218,129294,129362,129363,129364,129437,129476,129633,129857,129981,129982,130030,130227,130228,130302,130303,130304,130305,130306,130307,130308,130517,130718,130719,130720,130849,130979,130980,130981,130982,131093,131094,131123,131428,131730,131789,131814,132013,132014,132015,132066,132278,132285,132338,132398,132407,132408,132409,132477,132672,132693,132757,132758,132759,132998,133050,133051,133052,133103,133250,133284,133340,133341,133380,133469,133550,133611,133612,133613,133814,133827,133828,133829,133897,133898,133899,133900,133964,133965,133966,134016,134097,134164,134171,134180,134181,134205,134522,134523,135007,135008,135009,135195,135220,135233,135275,135368,135431,135475,135500,135575,135576,135577,135578,135579,135580,135626,135990,136004,136012,136013,136061,136062,136104,136335,136384,136385,136386,136387,136388,136423,136433,136572,136573,136586,136710,136773,136774,136775,137276,138630,138810,138811,138812,138984,138985,139397,139402,140095,140169,140453,140454,140455,140456,140457,140458,140459,140681,140682,140783,140819,141004,141111,141112,141113,141114,141189,141190,141335,141360,141432,141474,141544,141545,141546,141623,141654,141677,141830,141831,142004,142238,142296,142680,142681,142682,142683,142725,142750,143026,143027,143368,143436,143437,143490,143547,143548,143549,143550,143658,143976,144073,144169,144170,144207,144388,144739,144740,144810,144811,144853,144936,144981,144982,144983,145165,145189,145190,145438,145439,145572,145905,145907,145908,145909,146021,146051,146153,146157,146186,146194,146244,146336,146337,146338,146339,146340,146341,146342,146343,146344,146356,146639,146703,146779,146987,147072,147240,147296,147297,147298,147365,147451,147452,147453,147454,147592,147649,147657,147761,147936,148110,148232,148386,148505,148592,148683,148990,148992,148993,149062,149131,149186,149363,149690,149742,149747,149748,149773,149785,149795,149852,149869,149998,150052,150077,150145,150196,150203,150233,150239,150406,150413,150428,150498,150509,150524,150634,150636,150768,150791,150810,150917,150966,151040,151078,151108,151216,151217,151268,151299,151324,151412,151428,151504,151667,151681,151760,151761,151799,151873,151884,151896,151907,151975,151986,152007,152057,152058,152073,152266,152451,152546,152603,152605,152629,152630,152777,152914,153113,153139,153146,153302,153318,153400,153508,154079,154081,154083,154093,154553,154581,154582,154763,154851,154857,154943,154968,154990,154992,155126,155341,155363,155454,155588,155591,155613,155698,155699,155757,155781,155995,155997,156108,156109,156133,156185,156241,156280,156281,156282,156288,156323,156361,156375,156530,156592,156642,156680,156681,156709,156945,157115,157119,157243,157402,157405,157416,157543,157548,157555,157577,157581,157786,157790,157868,157925,157930,157932,157941,157947,158009,158068,158090,158112,158124,158146,158214,158215,158231,158242,158279,158292,158312,158318,158413,158486,158488,158507,158530,158551,158628,158675,158688,158723,158724,158739,158772,158776,158949,158951,158957,158970,158971,158972,159006,159151,159214,159215,159247,159250,159279,159403,159404,159431,159540,159546,159553,159614,159624,159644,159685,159761,159763,159765,159767,159774,159776,159895,160124,160133,160163,160193,160195,160202,160248,160254,160263,160311,160377,160387,160426,160604,160607,160629,160634,160637,160658,160807,160808,161036,161166,161169,161170,161566,161576,161584,161724,161909,161917,162016,162045,162057,162137,162240,162251,162254,162301,162386,162419,162425,162541,162550,162607,162608,162612,162660,162694,162715,162740,162759,162760,162858,162859,162929,162932,163088,163144,163321,163329,163335,163360,163587,163639,163641,163642,163668,163916,163917,163946,163977,163993,164022,164136,164327,164380,164465,164467,164545,164551,164592,164601,164731,164877,164880,164882,164884,164980,164986,164995,165034,165061,165076,165083,165110,165129,165135,165175,165208,165222,165244,165262,165280,165349,165357,165358,165495,165496,165502,165503,165505,165571,165576,165615,165654,165670,165673,165713,165874,165998,166006,166014,166204,166205,166301,166430,166605,166618,166809,166824,166827,167015,167199,167202,167273,167316,167318,167319,167554,167812,167814,167907,167915,167995,168011,168113,168152,168180,168184,168186,168238,168291,168296,168402,168450,168489,168493,168494,168523,168530,168752,168753,168862,168947,168955,169074,169150,169263,169270,169292,169359,169449,169456,169500,169512,169546,169567,169616,169673,169695,169811,169853,170028,170042,170146,170211,170235,170292,170364,170369,170370,170372,170388,170458,170541,170616,170714,170763,170772,170775,170955,170966,170983,171016,171028,171122,171170,171316,171341,171344,171384,171385,171386,171402,171504,171505,171511,171548,171557,171672,171808,171881,171885,171896,172079,172105,172163,172175,172183,172403,172408,172410,172414,172416,172423,172480,172483,172511,172568,172639,172819,173013,173037,173198,173403,173499,173555,173565,173710,174010,174015,174028,174130,174137,174155,174193,174424,174431,174432,174440,174444,174559,174572,174588,174684,174688,174710,174712,174825,174826,174927,174946,175032,175146,175192,175278,175287,175304,175398,175475,175511,175591,175593,175613,175704,175710,175845,175873,175891,175972,175989,175992,176087,176131,176157,176352,176392,176432,176445,176513,176556,176584,176614,176704,176706,177082,177215,177220,177349,177481,177628,177749,177896,178042,178268,178408,178417,178931,179129,179431,179754,179759,179877,179892,180057,180122,180125,180226,180321,180327,180534,180689,180728,180812,180926,180966,181665,181880,181999,182000,182231,182691,182692,182815,183044,183133,183226,183340,183384,183533,183534,183535,183541,183577,183586,183589,183868,183943,184127,184148,184260,184267,184333,184334,184465,184657,184789,184799,184800,184932,185099,185226,185238,185387,185388,185561,185575,185815,185937,185984,186170,186248,186250,186518,186560,186590,186722,186876,186891,187021,187242,187252,187579,187712,187940,188364,188366,188440,188624,188636,188637,188647,188822,188834,188836,188846,189161,189162,189315,189373,189387,189412,189424,189492,189496,189536,189648,190705,190835,190955,191045,191233,191420,191482,191599,191628,191840,191841,191856,191869,192211,192399,192756,192942,192943,193069,193317,193354,193569,193577,194143,194504,197071,197148,197279) 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 (20332,20336,20351,20355,20364,20376,20643,20644,20645,20646,20647,20648,20649,20650,20651,20652,20812,20856,20857,20910,20911,20953,20954,20955,21018,21064,21065,21112,21113,21165,21237,21291,21352,21353,21354,21355,21371,21418,21419,21455,21456,21567,21636,21637,21654,21743,21796,21797,21798,21862,21877,21921,21922,21923,21924,21972,22046,22085,22086,22118,22119,22120,22164,22165,22166,22223,22224,22225,22226,22272,22273,22320,22321,22322,22402,22403,22404,22419,22433,22440,22471,22472,22473,22487,22641,22642,22643,22659,23057,23276,23277,23278,23279,23354,23355,23356,23357,23358,23359,23360,23417,23418,23510,23511,23577,23704,23778,23816,23817,23818,23880,23881,23980,23981,23982,23983,24062,24076,24083,24126,24127,24180,24320,24326,24327,24328,24329,24331,24563,24564,24565,24566,24567,24568,24966,25000,25001,25002,25032,25051,25060,25089,25140,25141,25143,25190,25285,25325,25403,25404,25422,25478,25479,25480,25497,25500,25556,25590,25641,25661,25704,25772,25773,25774,25775,25828,25850,25865,25882,25926,25927,25928,25980,26012,26013,26014,26029,26035,26099,26100,26101,26177,26178,26179,26265,26266,26289,26290,26292,26293,26355,26415,26416,26506,26534,26567,26640,26641,26642,26643,26644,26645,26646,26647,26672,26673,26759,26760,26914,26941,26942,26967,27006,27094,27127,27128,27129,27295,27298,27332,27370,27389,27412,27517,27559,27667,27688,27901,28412,28526,29250,29268,29291,29445,29446,29578,29616,30005,30038,30136,30544,30636,30637,30638,30845,30902,30942,30943,31528,31531,31667,31668,31669,31670,31819,31820,32352,32769,32838,32927,32928,32929,33001,33127,33453,33454,33455,33490,33586,33587,33761,33940,33971,33972,34304,34537,34797,34798,34799,34800,34893,35238,35246,35430,35539,36109,36227,36421,36459,36460,36461,36462,36520,36737,36749,36868,36876,36906,37083,37093,38729,38820,38837,38851,38894,38974,39343,39354,39485,39613,39698,41978,42050,42560,42670,43176,43179,43341,44626,44657,44712,45580,45581,45639,45789,46037,46308,46403,46413,46507,46511,46859,46860,46861,46863,46864,46865,46866,46867,46868,46869,46870,46998,47024,47095,47191,47192,48321,48357,48358,48387,48438,48553,48604,48619,48801,48836,48837,49068,49070,49094,49095,49141,49142,49383,49465,49466,49529,49530,49531,49532,49812,49972,49983,50234,50235,50529,50534,50754,50803,50836,50844,50877,50935,50946,50950,51133,51150,51156,51157,51612,51613,51614,51725,51895,51931,51953,51955,52005,52016,52047,52412,52413,52414,52441,52465,52516,52549,52628,52629,52630,53047,53076,53150,53151,53550,53604,53605,53662,53663,53664,53767,53784,53786,53840,54045,54046,54047,54394,54439,55838,56315,56316,56487,56609,56610,56611,57394,57534,58669,58790,58791,59009,59041,59081,59111,59303,59504,59527,59561,59664,59703,60019,60020,60021,60022,60023,60183,60323,60324,60325,60628,60642,60843,60879,61170,61467,61646,61733,61738,62182,62452,62897,62898,62962,63187,63219,63798,63851,63895,64014,64040,64415,64470,64471,64619,64639,64720,65191,65192,65386,65391,65664,65665,65885,65886,65887,65888,65889,65890,66456,66457,66458,66459,66769,67382,67466,67467,67613,67614,67615,67617,67735,67736,68010,68017,68455,68456,68523,68629,68719,68731,68750,69244,69245,69285,69344,69345,69346,69347,69403,69470,69530,69572,70186,70187,70188,70384,70399,70470,70471,70487,70509,70529,70548,70549,70550,71021,71022,71023,71114,71277,71850,71851,71852,71853,71874,71971,72076,72077,72078,72614,72615,72616,72687,72688,72689,72690,72691,72790,72792,72823,72844,72881,73437,73507,73508,73509,73510,73511,73594,73632,73757,73761,74193,74284,74390,74410,74425,74543,75072,75073,75147,75238,75864,75912,75913,76118,76148,76169,76171,76183,76194,76195,76592,76593,76696,76697,76698,76699,76700,76848,77499,77500,77501,77502,77503,77504,77505,77506,78550,78551,78552,79702,80919,81211,81212,81491,81895,81906,81942,82477,82478,82557,83004,83005,83224,83260,83303,83399,83418,83616,83724,84037,84082,84333,84334,84494,84608,84797,84936,85064,85120,85165,85237,85366,85367,85368,85369,85545,85646,85786,85787,85993,86167,86230,86231,86232,86267,86274,86361,86363,86617,86618,86802,86913,86914,86915,86990,87048,87049,87050,87298,87794,88124,88125,88662,88963,88964,88965,89001,89086,89087,89415,90186,90373,91055,91151,91263,91549,91649,91650,91651,91957,91958,92087,92253,92980,93752,93753,93754,94301,94302,94872,94943,95580,95639,95665,95707,95778,95959,97795,97796,97797,97892,97893,98263,98264,98265,98266,98267,98449,98660,98811,98812,98813,99044,99093,99094,99097,99241,99260,100171,100211,100212,100213,100592,101098,101099,101236,101508,101788,102646,102654,102655,102771,103015,103016,103017,103138,103465,103475,103586,103587,103588,103589,103590,103597,103682,103683,103843,103895,104320,104371,104491,104492,105040,105437,105530,105704,105800,105827,105828,105856,106076,106124,106154,106172,106173,106184,106212,106244,106245,106246,106247,106248,106375,106376,106461,106478,106563,106619,106666,106723,106816,106945,106946,107054,107068,107118,107180,107230,107231,107232,107296,107341,107342,107343,107383,107541,107571,108207,108208,108270,108271,108272,108370,108412,108413,108422,108438,108439,108489,108508,108591,108623,108624,108625,108645,108798,108836,109046,109071,109118,109130,109131,109132,109133,109134,109171,109220,109221,109222,109223,109554,109646,109647,110054,110055,110082,110203,110467,110468,110552,110593,110625,110670,110718,110779,110844,110845,110846,110847,110848,110985,111149,111220,111221,111784,111785,111786,111787,111788,111789,111790,111791,111792,111793,112295,112334,112409,112628,112703,112704,112809,112875,112918,113002,113030,113090,113091,113092,113093,113162,113263,113336,113381,113412,113429,113430,113434,113458,113459,113562,113563,113588,113789,114008,114020,114099,114265,114311,114436,114437,114438,114439,114611,115182,115221,115256,115310,115327,115627,115628,115629,115630,115744,115875,115876,115944,115953,116229,116308,116309,116355,116363,116401,116433,116597,116607,116649,116738,117058,117082,117083,117084,117085,117086,117087,117088,117089,117090,117091,117092,117093,117094,117095,117096,117097,117098,117099,117100,117231,117232,117233,117577,117578,117579,117580,117727,117833,117889,118004,118005,118006,118120,118172,118251,118257,118356,118357,118358,118359,118442,118443,118585,118628,118629,118630,118748,118761,118767,118829,118830,118886,118932,118933,118934,118986,119087,119126,119406,119407,119438,119752,119878,119886,120033,120394,120395,120396,120397,121024,121180,121482,121761,121869,121924,121925,121926,121927,121928,121929,121930,122065,122169,122409,122447,122498,122603,122604,122646,122691,122777,122830,122831,122832,122873,122976,122977,122978,123143,123147,123148,123262,123357,123404,123408,123600,123601,123745,123770,123783,123917,123918,124158,124159,124212,124289,124375,124376,124398,124403,124408,124562,124563,124565,124567,125476,125477,125689,125750,125836,125876,125877,125878,125990,126015,126120,126185,126186,126248,126249,126388,126389,126390,126421,126464,126479,126538,126583,126673,126713,126714,126842,126843,126844,126897,126980,127108,127109,127314,127315,127316,127317,127562,127563,127564,127628,127695,127900,127987,127988,127989,127990,127991,128100,128363,128368,128392,128402,128446,128553,128554,128620,128656,128689,128735,128838,129087,129088,129089,129170,129216,129217,129218,129294,129362,129363,129364,129437,129476,129633,129857,129981,129982,130030,130227,130228,130302,130303,130304,130305,130306,130307,130308,130517,130718,130719,130720,130849,130979,130980,130981,130982,131093,131094,131123,131428,131730,131789,131814,132013,132014,132015,132066,132278,132285,132338,132398,132407,132408,132409,132477,132672,132693,132757,132758,132759,132998,133050,133051,133052,133103,133250,133284,133340,133341,133380,133469,133550,133611,133612,133613,133814,133827,133828,133829,133897,133898,133899,133900,133964,133965,133966,134016,134097,134164,134171,134180,134181,134205,134522,134523,135007,135008,135009,135195,135220,135233,135275,135368,135431,135475,135500,135575,135576,135577,135578,135579,135580,135626,135990,136004,136012,136013,136061,136062,136104,136335,136384,136385,136386,136387,136388,136423,136433,136572,136573,136586,136710,136773,136774,136775,137276,138630,138810,138811,138812,138984,138985,139397,139402,140095,140169,140453,140454,140455,140456,140457,140458,140459,140681,140682,140783,140819,141004,141111,141112,141113,141114,141189,141190,141335,141360,141432,141474,141544,141545,141546,141623,141654,141677,141830,141831,142004,142238,142296,142680,142681,142682,142683,142725,142750,143026,143027,143368,143436,143437,143490,143547,143548,143549,143550,143658,143976,144073,144169,144170,144207,144388,144739,144740,144810,144811,144853,144936,144981,144982,144983,145165,145189,145190,145438,145439,145572,145905,145907,145908,145909,146021,146051,146153,146157,146186,146194,146244,146336,146337,146338,146339,146340,146341,146342,146343,146344,146356,146639,146703,146779,146987,147072,147240,147296,147297,147298,147365,147451,147452,147453,147454,147592,147649,147657,147761,147936,148110,148232,148386,148505,148592,148683,148990,148992,148993,149062,149131,149186,149363,149690,149742,149747,149748,149773,149785,149795,149852,149869,149998,150052,150077,150145,150196,150203,150233,150239,150406,150413,150428,150498,150509,150524,150634,150636,150768,150791,150810,150917,150966,151040,151078,151108,151216,151217,151268,151299,151324,151412,151428,151504,151667,151681,151760,151761,151799,151873,151884,151896,151907,151975,151986,152007,152057,152058,152073,152266,152451,152546,152603,152605,152629,152630,152777,152914,153113,153139,153146,153302,153318,153400,153508,154079,154081,154083,154093,154553,154581,154582,154763,154851,154857,154943,154968,154990,154992,155126,155341,155363,155454,155588,155591,155613,155698,155699,155757,155781,155995,155997,156108,156109,156133,156185,156241,156280,156281,156282,156288,156323,156361,156375,156530,156592,156642,156680,156681,156709,156945,157115,157119,157243,157402,157405,157416,157543,157548,157555,157577,157581,157786,157790,157868,157925,157930,157932,157941,157947,158009,158068,158090,158112,158124,158146,158214,158215,158231,158242,158279,158292,158312,158318,158413,158486,158488,158507,158530,158551,158628,158675,158688,158723,158724,158739,158772,158776,158949,158951,158957,158970,158971,158972,159006,159151,159214,159215,159247,159250,159279,159403,159404,159431,159540,159546,159553,159614,159624,159644,159685,159761,159763,159765,159767,159774,159776,159895,160124,160133,160163,160193,160195,160202,160248,160254,160263,160311,160377,160387,160426,160604,160607,160629,160634,160637,160658,160807,160808,161036,161166,161169,161170,161566,161576,161584,161724,161909,161917,162016,162045,162057,162137,162240,162251,162254,162301,162386,162419,162425,162541,162550,162607,162608,162612,162660,162694,162715,162740,162759,162760,162858,162859,162929,162932,163088,163144,163321,163329,163335,163360,163587,163639,163641,163642,163668,163916,163917,163946,163977,163993,164022,164136,164327,164380,164465,164467,164545,164551,164592,164601,164731,164877,164880,164882,164884,164980,164986,164995,165034,165061,165076,165083,165110,165129,165135,165175,165208,165222,165244,165262,165280,165349,165357,165358,165495,165496,165502,165503,165505,165571,165576,165615,165654,165670,165673,165713,165874,165998,166006,166014,166204,166205,166301,166430,166605,166618,166809,166824,166827,167015,167199,167202,167273,167316,167318,167319,167554,167812,167814,167907,167915,167995,168011,168113,168152,168180,168184,168186,168238,168291,168296,168402,168450,168489,168493,168494,168523,168530,168752,168753,168862,168947,168955,169074,169150,169263,169270,169292,169359,169449,169456,169500,169512,169546,169567,169616,169673,169695,169811,169853,170028,170042,170146,170211,170235,170292,170364,170369,170370,170372,170388,170458,170541,170616,170714,170763,170772,170775,170955,170966,170983,171016,171028,171122,171170,171316,171341,171344,171384,171385,171386,171402,171504,171505,171511,171548,171557,171672,171808,171881,171885,171896,172079,172105,172163,172175,172183,172403,172408,172410,172414,172416,172423,172480,172483,172511,172568,172639,172819,173013,173037,173198,173403,173499,173555,173565,173710,174010,174015,174028,174130,174137,174155,174193,174424,174431,174432,174440,174444,174559,174572,174588,174684,174688,174710,174712,174825,174826,174927,174946,175032,175146,175192,175278,175287,175304,175398,175475,175511,175591,175593,175613,175704,175710,175845,175873,175891,175972,175989,175992,176087,176131,176157,176352,176392,176432,176445,176513,176556,176584,176614,176704,176706,177082,177215,177220,177349,177481,177628,177749,177896,178042,178268,178408,178417,178931,179129,179431,179754,179759,179877,179892,180057,180122,180125,180226,180321,180327,180534,180689,180728,180812,180926,180966,181665,181880,181999,182000,182231,182691,182692,182815,183044,183133,183226,183340,183384,183533,183534,183535,183541,183577,183586,183589,183868,183943,184127,184148,184260,184267,184333,184334,184465,184657,184789,184799,184800,184932,185099,185226,185238,185387,185388,185561,185575,185815,185937,185984,186170,186248,186250,186518,186560,186590,186722,186876,186891,187021,187242,187252,187579,187712,187940,188364,188366,188440,188624,188636,188637,188647,188822,188834,188836,188846,189161,189162,189315,189373,189387,189412,189424,189492,189496,189536,189648,190705,190835,190955,191045,191233,191420,191482,191599,191628,191840,191841,191856,191869,192211,192399,192756,192942,192943,193069,193317,193354,193569,193577,194143,194504,197071,197148,197279) GROUP BY sold_month ORDER BY scs.date_actual_sold |
| 79 | Creole | executeQuery(): [28.83 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 (20332,20336,20351,20355,20364,20376,20643,20644,20645,20646,20647,20648,20649,20650,20651,20652,20812,20856,20857,20910,20911,20953,20954,20955,21018,21064,21065,21112,21113,21165,21237,21291,21352,21353,21354,21355,21371,21418,21419,21455,21456,21567,21636,21637,21654,21743,21796,21797,21798,21862,21877,21921,21922,21923,21924,21972,22046,22085,22086,22118,22119,22120,22164,22165,22166,22223,22224,22225,22226,22272,22273,22320,22321,22322,22402,22403,22404,22419,22433,22440,22471,22472,22473,22487,22641,22642,22643,22659,23057,23276,23277,23278,23279,23354,23355,23356,23357,23358,23359,23360,23417,23418,23510,23511,23577,23704,23778,23816,23817,23818,23880,23881,23980,23981,23982,23983,24062,24076,24083,24126,24127,24180,24320,24326,24327,24328,24329,24331,24563,24564,24565,24566,24567,24568,24966,25000,25001,25002,25032,25051,25060,25089,25140,25141,25143,25190,25285,25325,25403,25404,25422,25478,25479,25480,25497,25500,25556,25590,25641,25661,25704,25772,25773,25774,25775,25828,25850,25865,25882,25926,25927,25928,25980,26012,26013,26014,26029,26035,26099,26100,26101,26177,26178,26179,26265,26266,26289,26290,26292,26293,26355,26415,26416,26506,26534,26567,26640,26641,26642,26643,26644,26645,26646,26647,26672,26673,26759,26760,26914,26941,26942,26967,27006,27094,27127,27128,27129,27295,27298,27332,27370,27389,27412,27517,27559,27667,27688,27901,28412,28526,29250,29268,29291,29445,29446,29578,29616,30005,30038,30136,30544,30636,30637,30638,30845,30902,30942,30943,31528,31531,31667,31668,31669,31670,31819,31820,32352,32769,32838,32927,32928,32929,33001,33127,33453,33454,33455,33490,33586,33587,33761,33940,33971,33972,34304,34537,34797,34798,34799,34800,34893,35238,35246,35430,35539,36109,36227,36421,36459,36460,36461,36462,36520,36737,36749,36868,36876,36906,37083,37093,38729,38820,38837,38851,38894,38974,39343,39354,39485,39613,39698,41978,42050,42560,42670,43176,43179,43341,44626,44657,44712,45580,45581,45639,45789,46037,46308,46403,46413,46507,46511,46859,46860,46861,46863,46864,46865,46866,46867,46868,46869,46870,46998,47024,47095,47191,47192,48321,48357,48358,48387,48438,48553,48604,48619,48801,48836,48837,49068,49070,49094,49095,49141,49142,49383,49465,49466,49529,49530,49531,49532,49812,49972,49983,50234,50235,50529,50534,50754,50803,50836,50844,50877,50935,50946,50950,51133,51150,51156,51157,51612,51613,51614,51725,51895,51931,51953,51955,52005,52016,52047,52412,52413,52414,52441,52465,52516,52549,52628,52629,52630,53047,53076,53150,53151,53550,53604,53605,53662,53663,53664,53767,53784,53786,53840,54045,54046,54047,54394,54439,55838,56315,56316,56487,56609,56610,56611,57394,57534,58669,58790,58791,59009,59041,59081,59111,59303,59504,59527,59561,59664,59703,60019,60020,60021,60022,60023,60183,60323,60324,60325,60628,60642,60843,60879,61170,61467,61646,61733,61738,62182,62452,62897,62898,62962,63187,63219,63798,63851,63895,64014,64040,64415,64470,64471,64619,64639,64720,65191,65192,65386,65391,65664,65665,65885,65886,65887,65888,65889,65890,66456,66457,66458,66459,66769,67382,67466,67467,67613,67614,67615,67617,67735,67736,68010,68017,68455,68456,68523,68629,68719,68731,68750,69244,69245,69285,69344,69345,69346,69347,69403,69470,69530,69572,70186,70187,70188,70384,70399,70470,70471,70487,70509,70529,70548,70549,70550,71021,71022,71023,71114,71277,71850,71851,71852,71853,71874,71971,72076,72077,72078,72614,72615,72616,72687,72688,72689,72690,72691,72790,72792,72823,72844,72881,73437,73507,73508,73509,73510,73511,73594,73632,73757,73761,74193,74284,74390,74410,74425,74543,75072,75073,75147,75238,75864,75912,75913,76118,76148,76169,76171,76183,76194,76195,76592,76593,76696,76697,76698,76699,76700,76848,77499,77500,77501,77502,77503,77504,77505,77506,78550,78551,78552,79702,80919,81211,81212,81491,81895,81906,81942,82477,82478,82557,83004,83005,83224,83260,83303,83399,83418,83616,83724,84037,84082,84333,84334,84494,84608,84797,84936,85064,85120,85165,85237,85366,85367,85368,85369,85545,85646,85786,85787,85993,86167,86230,86231,86232,86267,86274,86361,86363,86617,86618,86802,86913,86914,86915,86990,87048,87049,87050,87298,87794,88124,88125,88662,88963,88964,88965,89001,89086,89087,89415,90186,90373,91055,91151,91263,91549,91649,91650,91651,91957,91958,92087,92253,92980,93752,93753,93754,94301,94302,94872,94943,95580,95639,95665,95707,95778,95959,97795,97796,97797,97892,97893,98263,98264,98265,98266,98267,98449,98660,98811,98812,98813,99044,99093,99094,99097,99241,99260,100171,100211,100212,100213,100592,101098,101099,101236,101508,101788,102646,102654,102655,102771,103015,103016,103017,103138,103465,103475,103586,103587,103588,103589,103590,103597,103682,103683,103843,103895,104320,104371,104491,104492,105040,105437,105530,105704,105800,105827,105828,105856,106076,106124,106154,106172,106173,106184,106212,106244,106245,106246,106247,106248,106375,106376,106461,106478,106563,106619,106666,106723,106816,106945,106946,107054,107068,107118,107180,107230,107231,107232,107296,107341,107342,107343,107383,107541,107571,108207,108208,108270,108271,108272,108370,108412,108413,108422,108438,108439,108489,108508,108591,108623,108624,108625,108645,108798,108836,109046,109071,109118,109130,109131,109132,109133,109134,109171,109220,109221,109222,109223,109554,109646,109647,110054,110055,110082,110203,110467,110468,110552,110593,110625,110670,110718,110779,110844,110845,110846,110847,110848,110985,111149,111220,111221,111784,111785,111786,111787,111788,111789,111790,111791,111792,111793,112295,112334,112409,112628,112703,112704,112809,112875,112918,113002,113030,113090,113091,113092,113093,113162,113263,113336,113381,113412,113429,113430,113434,113458,113459,113562,113563,113588,113789,114008,114020,114099,114265,114311,114436,114437,114438,114439,114611,115182,115221,115256,115310,115327,115627,115628,115629,115630,115744,115875,115876,115944,115953,116229,116308,116309,116355,116363,116401,116433,116597,116607,116649,116738,117058,117082,117083,117084,117085,117086,117087,117088,117089,117090,117091,117092,117093,117094,117095,117096,117097,117098,117099,117100,117231,117232,117233,117577,117578,117579,117580,117727,117833,117889,118004,118005,118006,118120,118172,118251,118257,118356,118357,118358,118359,118442,118443,118585,118628,118629,118630,118748,118761,118767,118829,118830,118886,118932,118933,118934,118986,119087,119126,119406,119407,119438,119752,119878,119886,120033,120394,120395,120396,120397,121024,121180,121482,121761,121869,121924,121925,121926,121927,121928,121929,121930,122065,122169,122409,122447,122498,122603,122604,122646,122691,122777,122830,122831,122832,122873,122976,122977,122978,123143,123147,123148,123262,123357,123404,123408,123600,123601,123745,123770,123783,123917,123918,124158,124159,124212,124289,124375,124376,124398,124403,124408,124562,124563,124565,124567,125476,125477,125689,125750,125836,125876,125877,125878,125990,126015,126120,126185,126186,126248,126249,126388,126389,126390,126421,126464,126479,126538,126583,126673,126713,126714,126842,126843,126844,126897,126980,127108,127109,127314,127315,127316,127317,127562,127563,127564,127628,127695,127900,127987,127988,127989,127990,127991,128100,128363,128368,128392,128402,128446,128553,128554,128620,128656,128689,128735,128838,129087,129088,129089,129170,129216,129217,129218,129294,129362,129363,129364,129437,129476,129633,129857,129981,129982,130030,130227,130228,130302,130303,130304,130305,130306,130307,130308,130517,130718,130719,130720,130849,130979,130980,130981,130982,131093,131094,131123,131428,131730,131789,131814,132013,132014,132015,132066,132278,132285,132338,132398,132407,132408,132409,132477,132672,132693,132757,132758,132759,132998,133050,133051,133052,133103,133250,133284,133340,133341,133380,133469,133550,133611,133612,133613,133814,133827,133828,133829,133897,133898,133899,133900,133964,133965,133966,134016,134097,134164,134171,134180,134181,134205,134522,134523,135007,135008,135009,135195,135220,135233,135275,135368,135431,135475,135500,135575,135576,135577,135578,135579,135580,135626,135990,136004,136012,136013,136061,136062,136104,136335,136384,136385,136386,136387,136388,136423,136433,136572,136573,136586,136710,136773,136774,136775,137276,138630,138810,138811,138812,138984,138985,139397,139402,140095,140169,140453,140454,140455,140456,140457,140458,140459,140681,140682,140783,140819,141004,141111,141112,141113,141114,141189,141190,141335,141360,141432,141474,141544,141545,141546,141623,141654,141677,141830,141831,142004,142238,142296,142680,142681,142682,142683,142725,142750,143026,143027,143368,143436,143437,143490,143547,143548,143549,143550,143658,143976,144073,144169,144170,144207,144388,144739,144740,144810,144811,144853,144936,144981,144982,144983,145165,145189,145190,145438,145439,145572,145905,145907,145908,145909,146021,146051,146153,146157,146186,146194,146244,146336,146337,146338,146339,146340,146341,146342,146343,146344,146356,146639,146703,146779,146987,147072,147240,147296,147297,147298,147365,147451,147452,147453,147454,147592,147649,147657,147761,147936,148110,148232,148386,148505,148592,148683,148990,148992,148993,149062,149131,149186,149363,149690,149742,149747,149748,149773,149785,149795,149852,149869,149998,150052,150077,150145,150196,150203,150233,150239,150406,150413,150428,150498,150509,150524,150634,150636,150768,150791,150810,150917,150966,151040,151078,151108,151216,151217,151268,151299,151324,151412,151428,151504,151667,151681,151760,151761,151799,151873,151884,151896,151907,151975,151986,152007,152057,152058,152073,152266,152451,152546,152603,152605,152629,152630,152777,152914,153113,153139,153146,153302,153318,153400,153508,154079,154081,154083,154093,154553,154581,154582,154763,154851,154857,154943,154968,154990,154992,155126,155341,155363,155454,155588,155591,155613,155698,155699,155757,155781,155995,155997,156108,156109,156133,156185,156241,156280,156281,156282,156288,156323,156361,156375,156530,156592,156642,156680,156681,156709,156945,157115,157119,157243,157402,157405,157416,157543,157548,157555,157577,157581,157786,157790,157868,157925,157930,157932,157941,157947,158009,158068,158090,158112,158124,158146,158214,158215,158231,158242,158279,158292,158312,158318,158413,158486,158488,158507,158530,158551,158628,158675,158688,158723,158724,158739,158772,158776,158949,158951,158957,158970,158971,158972,159006,159151,159214,159215,159247,159250,159279,159403,159404,159431,159540,159546,159553,159614,159624,159644,159685,159761,159763,159765,159767,159774,159776,159895,160124,160133,160163,160193,160195,160202,160248,160254,160263,160311,160377,160387,160426,160604,160607,160629,160634,160637,160658,160807,160808,161036,161166,161169,161170,161566,161576,161584,161724,161909,161917,162016,162045,162057,162137,162240,162251,162254,162301,162386,162419,162425,162541,162550,162607,162608,162612,162660,162694,162715,162740,162759,162760,162858,162859,162929,162932,163088,163144,163321,163329,163335,163360,163587,163639,163641,163642,163668,163916,163917,163946,163977,163993,164022,164136,164327,164380,164465,164467,164545,164551,164592,164601,164731,164877,164880,164882,164884,164980,164986,164995,165034,165061,165076,165083,165110,165129,165135,165175,165208,165222,165244,165262,165280,165349,165357,165358,165495,165496,165502,165503,165505,165571,165576,165615,165654,165670,165673,165713,165874,165998,166006,166014,166204,166205,166301,166430,166605,166618,166809,166824,166827,167015,167199,167202,167273,167316,167318,167319,167554,167812,167814,167907,167915,167995,168011,168113,168152,168180,168184,168186,168238,168291,168296,168402,168450,168489,168493,168494,168523,168530,168752,168753,168862,168947,168955,169074,169150,169263,169270,169292,169359,169449,169456,169500,169512,169546,169567,169616,169673,169695,169811,169853,170028,170042,170146,170211,170235,170292,170364,170369,170370,170372,170388,170458,170541,170616,170714,170763,170772,170775,170955,170966,170983,171016,171028,171122,171170,171316,171341,171344,171384,171385,171386,171402,171504,171505,171511,171548,171557,171672,171808,171881,171885,171896,172079,172105,172163,172175,172183,172403,172408,172410,172414,172416,172423,172480,172483,172511,172568,172639,172819,173013,173037,173198,173403,173499,173555,173565,173710,174010,174015,174028,174130,174137,174155,174193,174424,174431,174432,174440,174444,174559,174572,174588,174684,174688,174710,174712,174825,174826,174927,174946,175032,175146,175192,175278,175287,175304,175398,175475,175511,175591,175593,175613,175704,175710,175845,175873,175891,175972,175989,175992,176087,176131,176157,176352,176392,176432,176445,176513,176556,176584,176614,176704,176706,177082,177215,177220,177349,177481,177628,177749,177896,178042,178268,178408,178417,178931,179129,179431,179754,179759,179877,179892,180057,180122,180125,180226,180321,180327,180534,180689,180728,180812,180926,180966,181665,181880,181999,182000,182231,182691,182692,182815,183044,183133,183226,183340,183384,183533,183534,183535,183541,183577,183586,183589,183868,183943,184127,184148,184260,184267,184333,184334,184465,184657,184789,184799,184800,184932,185099,185226,185238,185387,185388,185561,185575,185815,185937,185984,186170,186248,186250,186518,186560,186590,186722,186876,186891,187021,187242,187252,187579,187712,187940,188364,188366,188440,188624,188636,188637,188647,188822,188834,188836,188846,189161,189162,189315,189373,189387,189412,189424,189492,189496,189536,189648,190705,190835,190955,191045,191233,191420,191482,191599,191628,191840,191841,191856,191869,192211,192399,192756,192942,192943,193069,193317,193354,193569,193577,194143,194504,197071,197148,197279) 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(): [1394.67 ms] SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC |
| 82 | Action | change layout to "view_layout" |
| 83 | View | initialize view for "home/view" |
| 84 | View | render "sf_app_dir/modules/home/templates/viewSuccess.php" |
| 85 | View | initialize view for "home/_vif_images" |
| 86 | View | render "sf_app_dir/modules/home/templates/_vif_images.php" |
| 87 | PartialHelper | Generate cache key |
| 88 | View | initialize view for "common_page/_social_buttons" |
| 89 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php" |
| 90 | PartialHelper | Generate cache key |
| 91 | View | initialize view for "home/_vif_info" |
| 92 | View | render "sf_app_dir/modules/home/templates/_vif_info.php" |
| 93 | PartialHelper | Generate cache key |
| 94 | View | initialize view for "home/_hoover_user_info" |
| 95 | View | render "sf_app_dir/modules/home/templates/_hoover_user_info.php" |
| 96 | PartialHelper | Generate cache key |
| 97 | View | initialize view for "common_page/_price_development_graph" |
| 98 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php" |
| 99 | PartialHelper | Generate cache key |
| 100 | View | initialize view for "common_page/_sell_time_price_graph" |
| 101 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php" |
| 102 | PartialHelper | Generate cache key |
| 103 | View | initialize view for "common_page/_price_gauge_graph" |
| 104 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php" |
| 105 | PartialHelper | Generate cache key |
| 106 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 107 | Creole | executeQuery(): [2.69 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199741 |
| 108 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 109 | Creole | executeQuery(): [0.57 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199484 |
| 110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 111 | Creole | executeQuery(): [0.70 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199394 |
| 112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 113 | Creole | executeQuery(): [0.36 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199291 |
| 114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 115 | Creole | executeQuery(): [0.36 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198911 |
| 116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 117 | Creole | executeQuery(): [0.92 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=180639 |
| 118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 119 | Creole | executeQuery(): [0.37 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=180638 |
| 120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 121 | Creole | executeQuery(): [0.40 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=180637 |
| 122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 123 | Creole | executeQuery(): [0.38 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=180636 |
| 124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 125 | Creole | executeQuery(): [0.74 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=180635 |
| 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 |
vars & config
logs & msgs
39
10519.1 KB
1733 ms
