| # |
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' => 'volkswagen', 'model' => 'beetle-typ1', 'id' => '160640', 'module' => 'home', 'action' => 'view',) |
| 6 | Routing | connect "/sf_cache_partial/:module/:action/:sf_cache_key" |
| 7 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
| 8 | Creole | prepareStatement(): SET time_zone = '+01:00' |
| 9 | Creole | executeUpdate(): SET time_zone = '+01:00' |
| 10 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
| 11 | Creole | prepareStatement(): SET time_zone = '+01:00' |
| 12 | Creole | executeUpdate(): SET time_zone = '+01:00' |
| 13 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
| 14 | Creole | prepareStatement(): SET time_zone = '+01:00' |
| 15 | Creole | executeUpdate(): SET time_zone = '+01:00' |
| 16 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
| 17 | Creole | prepareStatement(): SET time_zone = '+01:00' |
| 18 | Creole | executeUpdate(): SET time_zone = '+01:00' |
| 19 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
| 20 | Creole | prepareStatement(): SET time_zone = '+01:00' |
| 21 | Creole | executeUpdate(): SET time_zone = '+01:00' |
| 22 | Controller | dispatch request |
| 23 | Filter | executing filter "sfRenderingFilter" |
| 24 | Filter | executing filter "sfWebDebugFilter" |
| 25 | Filter | executing filter "sfCarViewFilter" |
| 26 | Filter | executing filter "naBreadcrumbFilter" |
| 27 | Filter | executing filter "sfCacheFilter" |
| 28 | Filter | executing filter "sfCommonFilter" |
| 29 | Filter | executing filter "sfFlashFilter" |
| 30 | Filter | executing filter "sfExecutionFilter" |
| 31 | Action | call "homeActions->executeView()" |
| 32 | Creole | prepareStatement(): SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, DATE_FORMAT(car.DATE_MODIFY,'%d.%m.%Y') AS DM, make.MAKE_EN AS MAKE, model.MODEL_EN AS MODEL, make.MAKE_EN AS MAKE_en, model.MODEL_EN AS MODEL_en, vehicle_type.VEHICLE_TYPE_EN AS VEHICLE_TYPE, car_type.CAR_TYPE_EN AS CAR_TYPE, color.COLOR_EN AS COLOR, color_type.COLOR_TYPE_EN AS COLOR_TYPE, car_stat.HIT_AD_INFO AS AD_HIT FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) LEFT JOIN make ON (car.ID_MAKE=make.ID) LEFT JOIN model ON (car.ID_MODEL=model.ID) LEFT JOIN vehicle_type ON (car.ID_VEHICLE_TYPE=vehicle_type.ID) LEFT JOIN car_type ON (car_info.ID_CAR_TYPE=car_type.ID) LEFT JOIN color ON (car_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (car_info.ID_COLOR_TYPE=color_type.ID) LEFT JOIN car_stat ON (car.ID=car_stat.ID_AD) WHERE car.ID=? AND car.STATUS=? |
| 33 | Creole | executeQuery(): [1.42 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=160640 AND car.STATUS='F' |
| 34 | Creole | prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?) |
| 35 | Creole | executeQuery(): [0.65 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 (1420) |
| 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.32 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=160640 |
| 38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
| 39 | Creole | executeQuery(): [0.76 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=160640 |
| 40 | 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=? |
| 41 | Creole | executeQuery(): [0.67 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=160640 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2' |
| 42 | 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=? |
| 43 | Creole | executeQuery(): [0.55 ms] SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID='1' |
| 44 | 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 (160640) ORDER BY carimg.ORD ASC |
| 45 | Creole | executeQuery(): [0.80 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 (160640) ORDER BY carimg.ORD ASC |
| 46 | 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 (?) |
| 47 | Creole | executeQuery(): [0.58 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 (1420) |
| 48 | 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 (?) |
| 49 | Creole | executeQuery(): [0.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 (1420) |
| 50 | Creole | prepareStatement(): SELECT dealer.ID_MAKE, dealer.HIT_COUNTER FROM dealer WHERE dealer.ID_DEALER=? |
| 51 | Creole | executeQuery(): [1.42 ms] SELECT dealer.ID_MAKE, dealer.HIT_COUNTER FROM dealer WHERE dealer.ID_DEALER=1420 |
| 52 | Creole | prepareStatement(): SELECT netti_dealer.HAS_SITE, netti_dealer.SIMPLE_URL, netti_dealer.SLOGAN FROM netti_dealer WHERE netti_dealer.ID_DEALER=? |
| 53 | Creole | executeQuery(): [0.54 ms] SELECT netti_dealer.HAS_SITE, netti_dealer.SIMPLE_URL, netti_dealer.SLOGAN FROM netti_dealer WHERE netti_dealer.ID_DEALER=1420 |
| 54 | Creole | prepareStatement(): SELECT dealer_permission.ID, dealer_permission.ID_DEALER, dealer_permission.WHICH, dealer_permission.DATE_CREATE FROM dealer_permission WHERE dealer_permission.ID_DEALER=? |
| 55 | Creole | executeQuery(): [0.56 ms] SELECT dealer_permission.ID, dealer_permission.ID_DEALER, dealer_permission.WHICH, dealer_permission.DATE_CREATE FROM dealer_permission WHERE dealer_permission.ID_DEALER=1420 |
| 56 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
| 57 | Creole | executeQuery(): [0.67 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=1420 AND dealer_permission.WHICH='Q' |
| 58 | 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 |
| 59 | Creole | executeQuery(): [0.69 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=175 AND model.ID=1993 AND make.ID=model.ID_MAKE |
| 60 | 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 != 160640 AND car.ID_MODEL = '1993' ) 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 != 160640 AND car.ID_MODEL = '1993' ) ORDER BY ID DESC |
| 61 | 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 != 160640 AND car.ID_MODEL = '1993' ) 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 != 160640 AND car.ID_MODEL = '1993' ) ) AS count |
| 62 | Creole | executeQuery(): [9.04 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 != 160640 AND car.ID_MODEL = '1993' ) 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 != 160640 AND car.ID_MODEL = '1993' ) ) AS count |
| 63 | 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 != 160640 AND car.ID_MODEL = '1993' ) 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 != 160640 AND car.ID_MODEL = '1993' ) ORDER BY ID DESC, offset: 0, limit: 5 |
| 64 | Creole | executeQuery(): [13.23 ms] ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 160640 AND car.ID_MODEL = '1993' ) 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 != 160640 AND car.ID_MODEL = '1993' ) ORDER BY ID DESC LIMIT 5 |
| 65 | 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 (199964,199915,199861,199832,199775) ORDER BY carimg.ORD ASC |
| 66 | Creole | executeQuery(): [1.07 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 (199964,199915,199861,199832,199775) ORDER BY carimg.ORD ASC |
| 67 | 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 != '160640' AND car.ID_NETTI_USER = '1420' ) 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 != '160640' AND car.ID_NETTI_USER = '1420' ) ORDER BY ID DESC |
| 68 | 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 != '160640' AND car.ID_NETTI_USER = '1420' ) 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 != '160640' AND car.ID_NETTI_USER = '1420' ) ) AS count |
| 69 | Creole | executeQuery(): [1.57 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 != '160640' AND car.ID_NETTI_USER = '1420' ) 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 != '160640' AND car.ID_NETTI_USER = '1420' ) ) AS count |
| 70 | 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 != '160640' AND car.ID_NETTI_USER = '1420' ) 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 != '160640' AND car.ID_NETTI_USER = '1420' ) ORDER BY ID DESC, offset: 0, limit: 5 |
| 71 | Creole | executeQuery(): [1.69 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 != '160640' AND car.ID_NETTI_USER = '1420' ) 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 != '160640' AND car.ID_NETTI_USER = '1420' ) ORDER BY ID DESC LIMIT 5 |
| 72 | 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 (161165,160641,159994,159993,159992) ORDER BY carimg.ORD ASC |
| 73 | Creole | executeQuery(): [1.25 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 (161165,160641,159994,159993,159992) ORDER BY carimg.ORD ASC |
| 74 | Creole | prepareStatement(): SELECT car.ID FROM car WHERE car.ID_MAKE=? AND car.ID_MODEL=? AND car.STATUS=? |
| 75 | Creole | executeQuery(): [1.83 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=175 AND car.ID_MODEL=1993 AND car.STATUS='F' |
| 76 | Creole | prepareStatement(): SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=? AND sold_car.ID_MODEL=? AND sold_car.STATUS=? |
| 77 | Creole | executeQuery(): [52.16 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=175 AND sold_car.ID_MODEL=1993 AND sold_car.STATUS='S' |
| 78 | 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 (27806,28276,28594,30627,30994,31331,31445,33429,33430,44810,48345,50189,53843,59570,67861,72940,97998,106985,114656,117324,118847,123418,127908,131358,131444,131719,131779,132558,132559,132583,133589,133762,134868,135254,135464,135545,135599,135883,136181,136231,136494,136498,136538,136732,137529,138389,138405,139611,140318,140888,140889,141257,141719,142092,142094,142209,142609,142810,142811,143118,147150,147539,150945,151226,153212,153718,154304,155721,155875,155877,156465,157064,157079,158715,159989,160640,162686,166312,168446,171575,172264,172544,173072,173073,173192,173726,175395,176608,176904,176982,176983,177203,177268,177535,177541,177674,178210,179180,180229,180455,180548,181136,181902,183355,183377,184106,184595,185664,186520,186958,186959,187438,188326,188697,189809,190091,190717,191531,192264,192814,193678,193848,193901,194209,194347,194491,194492,194502,194770,194989,196188,196326,196572,196657,196824,196927,197034,197035,197312,197389,197398,197469,197534,197578,197698,198457,198612,198726,199104,199138,199270,199331,199504,199533,199775,199832,199861,199915,199964) GROUP BY cmonth ORDER BY date_create |
| 79 | Creole | executeQuery(): [2.86 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 (27806,28276,28594,30627,30994,31331,31445,33429,33430,44810,48345,50189,53843,59570,67861,72940,97998,106985,114656,117324,118847,123418,127908,131358,131444,131719,131779,132558,132559,132583,133589,133762,134868,135254,135464,135545,135599,135883,136181,136231,136494,136498,136538,136732,137529,138389,138405,139611,140318,140888,140889,141257,141719,142092,142094,142209,142609,142810,142811,143118,147150,147539,150945,151226,153212,153718,154304,155721,155875,155877,156465,157064,157079,158715,159989,160640,162686,166312,168446,171575,172264,172544,173072,173073,173192,173726,175395,176608,176904,176982,176983,177203,177268,177535,177541,177674,178210,179180,180229,180455,180548,181136,181902,183355,183377,184106,184595,185664,186520,186958,186959,187438,188326,188697,189809,190091,190717,191531,192264,192814,193678,193848,193901,194209,194347,194491,194492,194502,194770,194989,196188,196326,196572,196657,196824,196927,197034,197035,197312,197389,197398,197469,197534,197578,197698,198457,198612,198726,199104,199138,199270,199331,199504,199533,199775,199832,199861,199915,199964) GROUP BY cmonth ORDER BY date_create |
| 80 | 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 (21076,21181,21253,21368,21652,21756,21986,21987,22186,22693,22794,23839,23847,23848,23903,24135,24470,24783,24785,24832,24926,24927,24958,24970,25067,25109,25206,25429,25493,25503,25566,25711,25712,25727,25741,25872,25939,25944,26019,26031,26187,26205,26207,26294,26297,26353,26361,26362,26706,26707,26955,27165,27500,27600,27779,27891,27892,27909,27910,27936,27972,27982,27995,28102,28191,28192,28209,28353,28470,28627,28629,28684,28714,28884,28911,28925,28998,28999,29024,29061,29082,29083,29084,29085,29086,29087,29088,29089,29090,29091,29092,29113,29114,29147,29175,29176,29243,29300,29330,29331,29424,29464,29481,29482,29483,29555,29649,29650,29651,29652,29695,29763,29801,29815,29816,29817,29818,29819,29820,29821,29822,29845,29899,29901,29903,29985,29997,29998,30062,30158,30159,30160,30161,30162,30247,30307,30308,30333,30490,30521,30522,30548,30549,30562,30578,30625,30763,30791,30792,30876,30897,30995,31030,31031,31127,31129,31269,31334,31335,31338,31468,31469,31471,31575,31576,31577,31735,31765,31906,31953,31954,31955,31956,31981,31994,31995,32103,32104,32105,32159,32250,32251,32252,32253,32254,32255,32347,32349,32350,32423,32530,32531,32641,32642,32970,32973,32986,33011,33039,33047,33048,33049,33071,33096,33097,33098,33100,33101,33102,33113,33194,33195,33235,33318,33341,33348,33349,33410,33413,33414,33498,33505,33506,33513,33519,33594,33635,33636,33646,33654,33679,33754,33755,34052,34060,34235,34312,34412,34845,34858,34859,34915,34916,34928,34985,35037,35229,35232,35236,35321,35335,35361,35376,35505,35522,35545,35638,35639,35673,35771,35797,36156,36202,36238,36318,36488,36575,36677,36678,36713,36807,36812,36916,36918,36935,36937,36976,37061,37080,37099,37104,38710,38717,38731,38773,38777,38778,38786,38787,38803,38828,38879,38880,38881,38882,38884,38885,38886,38887,38888,38920,39311,39337,39410,39450,39531,39532,39533,39534,39569,39570,39571,39575,39576,39599,39602,39642,39664,39671,41896,41906,41907,41960,42489,42511,42536,42679,43114,43129,43130,43169,43247,43249,43250,43261,43278,43297,43299,43339,43343,43373,43387,43390,43913,43998,44075,44076,44113,44408,44495,44529,44618,44622,44630,45140,45141,45292,45401,45402,45512,45513,45587,45752,46155,46179,46187,46188,46192,46205,46210,46278,46349,46363,46371,46388,46460,46465,46737,46758,46973,46974,46977,47033,47044,47073,47086,47104,47105,47134,47137,47138,47139,47140,47141,47142,47162,47535,47546,47801,47827,47838,47901,47902,47945,47979,48447,48451,48477,48478,48496,48497,48509,48510,48565,48599,48608,48794,48797,48874,48977,48996,49046,49056,49134,49359,49445,49488,49489,49558,49564,49614,49716,49726,49784,49797,49800,49803,49811,49824,49825,49860,49913,49992,50163,50164,50253,50307,50308,50347,50399,50467,50493,50494,50502,50533,50713,50722,50733,50842,50843,50852,50861,50870,50879,50992,50997,51027,51072,51082,51087,51092,51579,51580,51599,51883,51913,51922,51930,51980,51999,52001,52021,52140,52172,52195,52205,52216,52220,52466,52471,52566,52604,52973,53058,53059,53172,53191,53192,53195,53209,53233,53251,53252,53253,53263,53264,53291,53298,53299,53328,53529,53820,53824,54111,54112,54283,54332,54333,54621,54736,54845,54854,55260,55301,55327,55350,55391,55392,55408,55414,55415,55749,55758,55931,56013,56186,56206,56221,56228,56229,56250,56765,56778,56783,56798,56895,56914,56916,57111,57112,57151,57197,57226,57292,57303,57308,57500,57633,57663,57672,57752,57768,57789,58207,58257,58265,58266,58267,58375,58583,58599,58650,58660,58695,58696,58914,58915,58916,58929,58943,58971,58985,59058,59560,59565,59595,59597,59598,59939,60101,60102,60152,60153,60159,60164,60173,60227,60285,60713,60722,60858,60977,61021,61024,61039,61043,61076,61089,61102,61367,61416,61507,61518,61537,61556,61560,61584,61795,61797,61818,61819,62075,62083,62085,62152,62232,62265,62278,62280,62282,62356,62804,62818,62826,62975,62976,63032,63039,63055,63063,63067,63079,63163,63178,63188,63215,63680,63925,63939,63940,63947,63965,63966,63977,64531,64532,64550,64576,64584,64585,64602,64618,64632,64638,64703,64713,64725,64727,65058,65141,65228,65279,65385,65431,65445,65454,65577,65675,66354,66582,66652,66654,66677,66684,66737,66776,66959,66960,67651,67800,67848,67883,67908,67925,67926,67927,67982,68398,68472,68500,68558,68559,68599,68603,68604,68605,68609,68708,68741,69239,69378,69385,69415,69419,69517,69580,69644,70080,70122,70247,70248,70249,70263,70264,70283,70302,70324,70327,70352,70353,70354,70356,70361,70372,70379,70381,70406,70494,70511,70513,70912,70918,70976,70994,71059,71069,71111,71127,71149,71170,71221,71240,71263,71266,71292,71293,71766,71772,71879,71905,71922,71952,71959,72002,72014,72028,72048,72553,72760,72797,72898,73398,73406,73438,74344,74345,74366,74432,74525,75008,75043,75177,75181,76752,76847,76872,77005,77359,77440,77441,77442,77694,78194,78408,78591,78639,81260,81261,81476,83369,83370,83371,83373,83376,83378,83380,83381,83382,83383,83590,83608,84043,84516,84661,84806,84921,85007,85061,85062,85157,85475,85556,85649,85682,85728,85842,85912,85958,86281,86518,86532,86849,86872,87216,87242,88085,88795,88802,88805,88878,89069,89126,89127,89476,90738,90806,91001,91037,91081,91192,91478,91496,91497,91498,91599,91600,91943,92102,92135,92922,93527,93785,94418,94420,94421,94422,94423,94424,94427,95083,95331,95332,95333,95347,95680,95822,95833,96068,96152,98059,98131,98132,98329,98358,98782,98831,98927,99059,99072,99080,99092,99106,99141,99212,99254,100468,100832,100852,101171,101507,101569,101690,101767,101768,101770,101771,102024,102032,102359,102385,102626,102686,102687,102731,103085,103205,103228,103287,103296,103356,103357,103668,103669,103670,103697,104389,105127,105273,105726,105883,105884,106054,106082,106092,106135,106136,106182,106183,106210,106384,106421,106529,106531,106532,106585,106600,106629,106877,106884,106892,106974,106979,106984,107274,107385,107552,108427,108445,108450,108451,108452,108453,108535,108565,108750,108777,108868,108928,108952,109121,109174,109240,109249,109282,109283,109309,109345,109387,109540,109683,109692,109764,109801,110160,110162,110163,110369,110370,110696,110702,110777,110894,111080,111081,111085,111087,111129,111181,111193,111215,111268,111955,112353,112354,112355,112391,112688,112691,112749,113057,113063,113110,113131,113141,113206,113257,113312,113325,113446,113654,113739,113879,113911,114036,114037,114039,114227,114279,114710,114773,115003,115004,115045,115092,115106,115249,115274,115290,115308,115785,116292,116327,116423,116438,116488,116660,116662,116692,116924,117170,117354,117355,117392,117413,117534,117698,117782,117787,117858,118057,118112,118113,118114,118115,118470,118491,118505,118546,118579,118724,119007,119054,119137,119147,119148,119168,119271,119612,119749,120130,120541,120667,120687,120882,120898,121061,121139,121316,121407,121486,121522,121523,121583,121701,121702,121720,121724,121732,121773,121790,121800,121817,121843,121846,121858,122164,122460,122602,122611,122624,122712,122716,122772,122816,122817,123093,123107,123123,123126,123133,123157,123158,123159,123167,123206,123338,123421,123422,123448,123781,123826,123827,123968,124069,124236,124407,125589,125735,126042,126049,126183,126199,126271,126562,126603,126708,126716,126924,126967,127197,127417,127457,127494,127506,127588,127692,127698,127741,127798,127844,127904,128093,128266,128588,128678,128863,129236,129345,130382,130593,130612,130640,130696,131061,131062,131156,131409,131485,131591,131648,131649,131650,131651,131652,131653,131709,132136,132163,132198,132216,132270,132284,132348,132368,132415,132432,132452,132517,132518,132610,132678,132732,132774,132810,132904,132919,132988,133240,133430,133466,133723,133754,133988,134022,134083,134869,135086,135145,135146,135147,135177,135298,135325,135345,135371,135463,135465,135646,136025,136144,136172,136173,136174,136257,136455,136490,136568,136584,136760,136951,137093,137259,137265,137268,137350,137400,137464,137658,137672,137674,137792,137796,138013,138069,138077,138160,138302,138315,138328,138574,138617,138655,138773,139340,139350,139695,139769,140129,140134,140254,140807,140830,140831,141032,141096,141247,141284,141303,141363,141365,141643,141686,141764,142132,142174,142179,142351,142964,143104,143308,143756,143930,144064,144144,144357,144368,144369,144415,144471,144477,144530,144537,144541,144570,144572,144576,144609,144614,144652,144790,144885,144920,145095,145156,145374,145611,145614,145866,145988,146197,146418,146701,146767,147140,147141,147142,147143,147144,147145,147146,147148,147191,147323,147362,147593,147744,147901,147955,148303,148322,148347,148423,148424,148435,148589,148728,148787,148831,148837,148896,148961,148967,148984,149004,149042,149051,149263,149277,149424,149430,149515,149519,149665,149789,149838,149886,149936,150069,150204,150313,150411,150501,150579,150660,150760,150761,150765,150766,150955,150979,150982,151115,151181,151254,151264,151318,151427,151437,151542,151670,151694,151717,151759,151767,151816,151817,151821,151882,151958,151962,151992,152037,152125,152129,152132,152202,152241,152447,152658,152791,153140,153606,153937,153976,153996,154051,154136,154370,154396,154465,154482,154521,154546,154620,155005,155024,155349,155356,155722,155762,155922,155925,155926,155934,155936,155937,155948,155952,156570,156677,156678,156794,156857,156860,157006,157007,157033,157153,157182,157473,157650,157651,157819,157927,157997,158026,158271,158272,158273,158368,158713,158714,158794,158847,158889,159126,159351,159456,159457,159695,159875,160003,160004,160081,160241,160269,160386,161035,162267,162274,162275,162369,162370,162411,162418,162423,162466,162732,162739,162838,162839,163134,163391,163394,163742,163750,163796,163797,163802,163810,163855,163994,164077,164268,164269,164357,164452,164975,164977,164999,165075,165133,165240,165491,165492,165561,165679,165744,165893,165912,165957,166010,166126,166219,166382,166393,166677,166693,166820,166838,166908,166925,167110,167822,167881,167883,167885,167960,168183,168646,168725,168760,168904,169062,169120,169235,169496,169497,169590,169591,169635,169638,169640,169641,169642,169646,169650,169898,170079,170084,170089,170254,170255,170345,170355,170613,171096,171189,171303,171348,171395,171406,171444,171573,172052,172070,172085,172170,172326,172374,172377,172379,172380,172867,173086,173150,173317,173505,173657,173945,173964,174183,174287,174426,174436,174437,174472,174473,174716,174738,174743,174940,174956,175202,175432,175580,175806,175863,175866,175869,175870,175964,176050,176109,176163,176189,176242,176287,176601,176923,176942,177020,177202,177236,177423,177464,177532,177586,177727,177771,177792,177801,177991,178330,178425,178429,178431,178483,178545,178630,178631,179175,179441,179710,179711,179738,179976,179998,180080,180084,180166,180191,180197,180672,180799,180815,180909,180910,180945,181035,181138,181141,181143,181147,181169,181276,181282,181352,181359,181362,181397,181512,181514,181515,181667,181676,181784,181883,181911,182061,182209,182212,182990,183085,183260,183289,183335,183363,183381,183640,183837,183854,183889,183911,183985,183987,184108,184734,185192,185321,185496,185584,185655,185661,185685,185697,185817,185896,185948,185977,186005,186043,186256,186281,186410,186816,186831,186846,186967,186999,187095,187238,187377,188053,188209,188410,188452,188550,188797,188848,188980,189079,189270,189380,189394,189439,189670,189688,189952,190144,190299,190353,190415,190665,190708,191048,191310,191418,191547,191923,192002,192336,192342,192437,192468,192835,193188,193385,193389,193856,193869,194060,194307,195242,195327,195587,195721,196829,197553,197880,198290) GROUP BY sold_week ORDER BY scs.date_actual_sold |
| 81 | Creole | executeQuery(): [15.33 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 (21076,21181,21253,21368,21652,21756,21986,21987,22186,22693,22794,23839,23847,23848,23903,24135,24470,24783,24785,24832,24926,24927,24958,24970,25067,25109,25206,25429,25493,25503,25566,25711,25712,25727,25741,25872,25939,25944,26019,26031,26187,26205,26207,26294,26297,26353,26361,26362,26706,26707,26955,27165,27500,27600,27779,27891,27892,27909,27910,27936,27972,27982,27995,28102,28191,28192,28209,28353,28470,28627,28629,28684,28714,28884,28911,28925,28998,28999,29024,29061,29082,29083,29084,29085,29086,29087,29088,29089,29090,29091,29092,29113,29114,29147,29175,29176,29243,29300,29330,29331,29424,29464,29481,29482,29483,29555,29649,29650,29651,29652,29695,29763,29801,29815,29816,29817,29818,29819,29820,29821,29822,29845,29899,29901,29903,29985,29997,29998,30062,30158,30159,30160,30161,30162,30247,30307,30308,30333,30490,30521,30522,30548,30549,30562,30578,30625,30763,30791,30792,30876,30897,30995,31030,31031,31127,31129,31269,31334,31335,31338,31468,31469,31471,31575,31576,31577,31735,31765,31906,31953,31954,31955,31956,31981,31994,31995,32103,32104,32105,32159,32250,32251,32252,32253,32254,32255,32347,32349,32350,32423,32530,32531,32641,32642,32970,32973,32986,33011,33039,33047,33048,33049,33071,33096,33097,33098,33100,33101,33102,33113,33194,33195,33235,33318,33341,33348,33349,33410,33413,33414,33498,33505,33506,33513,33519,33594,33635,33636,33646,33654,33679,33754,33755,34052,34060,34235,34312,34412,34845,34858,34859,34915,34916,34928,34985,35037,35229,35232,35236,35321,35335,35361,35376,35505,35522,35545,35638,35639,35673,35771,35797,36156,36202,36238,36318,36488,36575,36677,36678,36713,36807,36812,36916,36918,36935,36937,36976,37061,37080,37099,37104,38710,38717,38731,38773,38777,38778,38786,38787,38803,38828,38879,38880,38881,38882,38884,38885,38886,38887,38888,38920,39311,39337,39410,39450,39531,39532,39533,39534,39569,39570,39571,39575,39576,39599,39602,39642,39664,39671,41896,41906,41907,41960,42489,42511,42536,42679,43114,43129,43130,43169,43247,43249,43250,43261,43278,43297,43299,43339,43343,43373,43387,43390,43913,43998,44075,44076,44113,44408,44495,44529,44618,44622,44630,45140,45141,45292,45401,45402,45512,45513,45587,45752,46155,46179,46187,46188,46192,46205,46210,46278,46349,46363,46371,46388,46460,46465,46737,46758,46973,46974,46977,47033,47044,47073,47086,47104,47105,47134,47137,47138,47139,47140,47141,47142,47162,47535,47546,47801,47827,47838,47901,47902,47945,47979,48447,48451,48477,48478,48496,48497,48509,48510,48565,48599,48608,48794,48797,48874,48977,48996,49046,49056,49134,49359,49445,49488,49489,49558,49564,49614,49716,49726,49784,49797,49800,49803,49811,49824,49825,49860,49913,49992,50163,50164,50253,50307,50308,50347,50399,50467,50493,50494,50502,50533,50713,50722,50733,50842,50843,50852,50861,50870,50879,50992,50997,51027,51072,51082,51087,51092,51579,51580,51599,51883,51913,51922,51930,51980,51999,52001,52021,52140,52172,52195,52205,52216,52220,52466,52471,52566,52604,52973,53058,53059,53172,53191,53192,53195,53209,53233,53251,53252,53253,53263,53264,53291,53298,53299,53328,53529,53820,53824,54111,54112,54283,54332,54333,54621,54736,54845,54854,55260,55301,55327,55350,55391,55392,55408,55414,55415,55749,55758,55931,56013,56186,56206,56221,56228,56229,56250,56765,56778,56783,56798,56895,56914,56916,57111,57112,57151,57197,57226,57292,57303,57308,57500,57633,57663,57672,57752,57768,57789,58207,58257,58265,58266,58267,58375,58583,58599,58650,58660,58695,58696,58914,58915,58916,58929,58943,58971,58985,59058,59560,59565,59595,59597,59598,59939,60101,60102,60152,60153,60159,60164,60173,60227,60285,60713,60722,60858,60977,61021,61024,61039,61043,61076,61089,61102,61367,61416,61507,61518,61537,61556,61560,61584,61795,61797,61818,61819,62075,62083,62085,62152,62232,62265,62278,62280,62282,62356,62804,62818,62826,62975,62976,63032,63039,63055,63063,63067,63079,63163,63178,63188,63215,63680,63925,63939,63940,63947,63965,63966,63977,64531,64532,64550,64576,64584,64585,64602,64618,64632,64638,64703,64713,64725,64727,65058,65141,65228,65279,65385,65431,65445,65454,65577,65675,66354,66582,66652,66654,66677,66684,66737,66776,66959,66960,67651,67800,67848,67883,67908,67925,67926,67927,67982,68398,68472,68500,68558,68559,68599,68603,68604,68605,68609,68708,68741,69239,69378,69385,69415,69419,69517,69580,69644,70080,70122,70247,70248,70249,70263,70264,70283,70302,70324,70327,70352,70353,70354,70356,70361,70372,70379,70381,70406,70494,70511,70513,70912,70918,70976,70994,71059,71069,71111,71127,71149,71170,71221,71240,71263,71266,71292,71293,71766,71772,71879,71905,71922,71952,71959,72002,72014,72028,72048,72553,72760,72797,72898,73398,73406,73438,74344,74345,74366,74432,74525,75008,75043,75177,75181,76752,76847,76872,77005,77359,77440,77441,77442,77694,78194,78408,78591,78639,81260,81261,81476,83369,83370,83371,83373,83376,83378,83380,83381,83382,83383,83590,83608,84043,84516,84661,84806,84921,85007,85061,85062,85157,85475,85556,85649,85682,85728,85842,85912,85958,86281,86518,86532,86849,86872,87216,87242,88085,88795,88802,88805,88878,89069,89126,89127,89476,90738,90806,91001,91037,91081,91192,91478,91496,91497,91498,91599,91600,91943,92102,92135,92922,93527,93785,94418,94420,94421,94422,94423,94424,94427,95083,95331,95332,95333,95347,95680,95822,95833,96068,96152,98059,98131,98132,98329,98358,98782,98831,98927,99059,99072,99080,99092,99106,99141,99212,99254,100468,100832,100852,101171,101507,101569,101690,101767,101768,101770,101771,102024,102032,102359,102385,102626,102686,102687,102731,103085,103205,103228,103287,103296,103356,103357,103668,103669,103670,103697,104389,105127,105273,105726,105883,105884,106054,106082,106092,106135,106136,106182,106183,106210,106384,106421,106529,106531,106532,106585,106600,106629,106877,106884,106892,106974,106979,106984,107274,107385,107552,108427,108445,108450,108451,108452,108453,108535,108565,108750,108777,108868,108928,108952,109121,109174,109240,109249,109282,109283,109309,109345,109387,109540,109683,109692,109764,109801,110160,110162,110163,110369,110370,110696,110702,110777,110894,111080,111081,111085,111087,111129,111181,111193,111215,111268,111955,112353,112354,112355,112391,112688,112691,112749,113057,113063,113110,113131,113141,113206,113257,113312,113325,113446,113654,113739,113879,113911,114036,114037,114039,114227,114279,114710,114773,115003,115004,115045,115092,115106,115249,115274,115290,115308,115785,116292,116327,116423,116438,116488,116660,116662,116692,116924,117170,117354,117355,117392,117413,117534,117698,117782,117787,117858,118057,118112,118113,118114,118115,118470,118491,118505,118546,118579,118724,119007,119054,119137,119147,119148,119168,119271,119612,119749,120130,120541,120667,120687,120882,120898,121061,121139,121316,121407,121486,121522,121523,121583,121701,121702,121720,121724,121732,121773,121790,121800,121817,121843,121846,121858,122164,122460,122602,122611,122624,122712,122716,122772,122816,122817,123093,123107,123123,123126,123133,123157,123158,123159,123167,123206,123338,123421,123422,123448,123781,123826,123827,123968,124069,124236,124407,125589,125735,126042,126049,126183,126199,126271,126562,126603,126708,126716,126924,126967,127197,127417,127457,127494,127506,127588,127692,127698,127741,127798,127844,127904,128093,128266,128588,128678,128863,129236,129345,130382,130593,130612,130640,130696,131061,131062,131156,131409,131485,131591,131648,131649,131650,131651,131652,131653,131709,132136,132163,132198,132216,132270,132284,132348,132368,132415,132432,132452,132517,132518,132610,132678,132732,132774,132810,132904,132919,132988,133240,133430,133466,133723,133754,133988,134022,134083,134869,135086,135145,135146,135147,135177,135298,135325,135345,135371,135463,135465,135646,136025,136144,136172,136173,136174,136257,136455,136490,136568,136584,136760,136951,137093,137259,137265,137268,137350,137400,137464,137658,137672,137674,137792,137796,138013,138069,138077,138160,138302,138315,138328,138574,138617,138655,138773,139340,139350,139695,139769,140129,140134,140254,140807,140830,140831,141032,141096,141247,141284,141303,141363,141365,141643,141686,141764,142132,142174,142179,142351,142964,143104,143308,143756,143930,144064,144144,144357,144368,144369,144415,144471,144477,144530,144537,144541,144570,144572,144576,144609,144614,144652,144790,144885,144920,145095,145156,145374,145611,145614,145866,145988,146197,146418,146701,146767,147140,147141,147142,147143,147144,147145,147146,147148,147191,147323,147362,147593,147744,147901,147955,148303,148322,148347,148423,148424,148435,148589,148728,148787,148831,148837,148896,148961,148967,148984,149004,149042,149051,149263,149277,149424,149430,149515,149519,149665,149789,149838,149886,149936,150069,150204,150313,150411,150501,150579,150660,150760,150761,150765,150766,150955,150979,150982,151115,151181,151254,151264,151318,151427,151437,151542,151670,151694,151717,151759,151767,151816,151817,151821,151882,151958,151962,151992,152037,152125,152129,152132,152202,152241,152447,152658,152791,153140,153606,153937,153976,153996,154051,154136,154370,154396,154465,154482,154521,154546,154620,155005,155024,155349,155356,155722,155762,155922,155925,155926,155934,155936,155937,155948,155952,156570,156677,156678,156794,156857,156860,157006,157007,157033,157153,157182,157473,157650,157651,157819,157927,157997,158026,158271,158272,158273,158368,158713,158714,158794,158847,158889,159126,159351,159456,159457,159695,159875,160003,160004,160081,160241,160269,160386,161035,162267,162274,162275,162369,162370,162411,162418,162423,162466,162732,162739,162838,162839,163134,163391,163394,163742,163750,163796,163797,163802,163810,163855,163994,164077,164268,164269,164357,164452,164975,164977,164999,165075,165133,165240,165491,165492,165561,165679,165744,165893,165912,165957,166010,166126,166219,166382,166393,166677,166693,166820,166838,166908,166925,167110,167822,167881,167883,167885,167960,168183,168646,168725,168760,168904,169062,169120,169235,169496,169497,169590,169591,169635,169638,169640,169641,169642,169646,169650,169898,170079,170084,170089,170254,170255,170345,170355,170613,171096,171189,171303,171348,171395,171406,171444,171573,172052,172070,172085,172170,172326,172374,172377,172379,172380,172867,173086,173150,173317,173505,173657,173945,173964,174183,174287,174426,174436,174437,174472,174473,174716,174738,174743,174940,174956,175202,175432,175580,175806,175863,175866,175869,175870,175964,176050,176109,176163,176189,176242,176287,176601,176923,176942,177020,177202,177236,177423,177464,177532,177586,177727,177771,177792,177801,177991,178330,178425,178429,178431,178483,178545,178630,178631,179175,179441,179710,179711,179738,179976,179998,180080,180084,180166,180191,180197,180672,180799,180815,180909,180910,180945,181035,181138,181141,181143,181147,181169,181276,181282,181352,181359,181362,181397,181512,181514,181515,181667,181676,181784,181883,181911,182061,182209,182212,182990,183085,183260,183289,183335,183363,183381,183640,183837,183854,183889,183911,183985,183987,184108,184734,185192,185321,185496,185584,185655,185661,185685,185697,185817,185896,185948,185977,186005,186043,186256,186281,186410,186816,186831,186846,186967,186999,187095,187238,187377,188053,188209,188410,188452,188550,188797,188848,188980,189079,189270,189380,189394,189439,189670,189688,189952,190144,190299,190353,190415,190665,190708,191048,191310,191418,191547,191923,192002,192336,192342,192437,192468,192835,193188,193385,193389,193856,193869,194060,194307,195242,195327,195587,195721,196829,197553,197880,198290) GROUP BY sold_week ORDER BY scs.date_actual_sold |
| 82 | 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 (21076,21181,21253,21368,21652,21756,21986,21987,22186,22693,22794,23839,23847,23848,23903,24135,24470,24783,24785,24832,24926,24927,24958,24970,25067,25109,25206,25429,25493,25503,25566,25711,25712,25727,25741,25872,25939,25944,26019,26031,26187,26205,26207,26294,26297,26353,26361,26362,26706,26707,26955,27165,27500,27600,27779,27891,27892,27909,27910,27936,27972,27982,27995,28102,28191,28192,28209,28353,28470,28627,28629,28684,28714,28884,28911,28925,28998,28999,29024,29061,29082,29083,29084,29085,29086,29087,29088,29089,29090,29091,29092,29113,29114,29147,29175,29176,29243,29300,29330,29331,29424,29464,29481,29482,29483,29555,29649,29650,29651,29652,29695,29763,29801,29815,29816,29817,29818,29819,29820,29821,29822,29845,29899,29901,29903,29985,29997,29998,30062,30158,30159,30160,30161,30162,30247,30307,30308,30333,30490,30521,30522,30548,30549,30562,30578,30625,30763,30791,30792,30876,30897,30995,31030,31031,31127,31129,31269,31334,31335,31338,31468,31469,31471,31575,31576,31577,31735,31765,31906,31953,31954,31955,31956,31981,31994,31995,32103,32104,32105,32159,32250,32251,32252,32253,32254,32255,32347,32349,32350,32423,32530,32531,32641,32642,32970,32973,32986,33011,33039,33047,33048,33049,33071,33096,33097,33098,33100,33101,33102,33113,33194,33195,33235,33318,33341,33348,33349,33410,33413,33414,33498,33505,33506,33513,33519,33594,33635,33636,33646,33654,33679,33754,33755,34052,34060,34235,34312,34412,34845,34858,34859,34915,34916,34928,34985,35037,35229,35232,35236,35321,35335,35361,35376,35505,35522,35545,35638,35639,35673,35771,35797,36156,36202,36238,36318,36488,36575,36677,36678,36713,36807,36812,36916,36918,36935,36937,36976,37061,37080,37099,37104,38710,38717,38731,38773,38777,38778,38786,38787,38803,38828,38879,38880,38881,38882,38884,38885,38886,38887,38888,38920,39311,39337,39410,39450,39531,39532,39533,39534,39569,39570,39571,39575,39576,39599,39602,39642,39664,39671,41896,41906,41907,41960,42489,42511,42536,42679,43114,43129,43130,43169,43247,43249,43250,43261,43278,43297,43299,43339,43343,43373,43387,43390,43913,43998,44075,44076,44113,44408,44495,44529,44618,44622,44630,45140,45141,45292,45401,45402,45512,45513,45587,45752,46155,46179,46187,46188,46192,46205,46210,46278,46349,46363,46371,46388,46460,46465,46737,46758,46973,46974,46977,47033,47044,47073,47086,47104,47105,47134,47137,47138,47139,47140,47141,47142,47162,47535,47546,47801,47827,47838,47901,47902,47945,47979,48447,48451,48477,48478,48496,48497,48509,48510,48565,48599,48608,48794,48797,48874,48977,48996,49046,49056,49134,49359,49445,49488,49489,49558,49564,49614,49716,49726,49784,49797,49800,49803,49811,49824,49825,49860,49913,49992,50163,50164,50253,50307,50308,50347,50399,50467,50493,50494,50502,50533,50713,50722,50733,50842,50843,50852,50861,50870,50879,50992,50997,51027,51072,51082,51087,51092,51579,51580,51599,51883,51913,51922,51930,51980,51999,52001,52021,52140,52172,52195,52205,52216,52220,52466,52471,52566,52604,52973,53058,53059,53172,53191,53192,53195,53209,53233,53251,53252,53253,53263,53264,53291,53298,53299,53328,53529,53820,53824,54111,54112,54283,54332,54333,54621,54736,54845,54854,55260,55301,55327,55350,55391,55392,55408,55414,55415,55749,55758,55931,56013,56186,56206,56221,56228,56229,56250,56765,56778,56783,56798,56895,56914,56916,57111,57112,57151,57197,57226,57292,57303,57308,57500,57633,57663,57672,57752,57768,57789,58207,58257,58265,58266,58267,58375,58583,58599,58650,58660,58695,58696,58914,58915,58916,58929,58943,58971,58985,59058,59560,59565,59595,59597,59598,59939,60101,60102,60152,60153,60159,60164,60173,60227,60285,60713,60722,60858,60977,61021,61024,61039,61043,61076,61089,61102,61367,61416,61507,61518,61537,61556,61560,61584,61795,61797,61818,61819,62075,62083,62085,62152,62232,62265,62278,62280,62282,62356,62804,62818,62826,62975,62976,63032,63039,63055,63063,63067,63079,63163,63178,63188,63215,63680,63925,63939,63940,63947,63965,63966,63977,64531,64532,64550,64576,64584,64585,64602,64618,64632,64638,64703,64713,64725,64727,65058,65141,65228,65279,65385,65431,65445,65454,65577,65675,66354,66582,66652,66654,66677,66684,66737,66776,66959,66960,67651,67800,67848,67883,67908,67925,67926,67927,67982,68398,68472,68500,68558,68559,68599,68603,68604,68605,68609,68708,68741,69239,69378,69385,69415,69419,69517,69580,69644,70080,70122,70247,70248,70249,70263,70264,70283,70302,70324,70327,70352,70353,70354,70356,70361,70372,70379,70381,70406,70494,70511,70513,70912,70918,70976,70994,71059,71069,71111,71127,71149,71170,71221,71240,71263,71266,71292,71293,71766,71772,71879,71905,71922,71952,71959,72002,72014,72028,72048,72553,72760,72797,72898,73398,73406,73438,74344,74345,74366,74432,74525,75008,75043,75177,75181,76752,76847,76872,77005,77359,77440,77441,77442,77694,78194,78408,78591,78639,81260,81261,81476,83369,83370,83371,83373,83376,83378,83380,83381,83382,83383,83590,83608,84043,84516,84661,84806,84921,85007,85061,85062,85157,85475,85556,85649,85682,85728,85842,85912,85958,86281,86518,86532,86849,86872,87216,87242,88085,88795,88802,88805,88878,89069,89126,89127,89476,90738,90806,91001,91037,91081,91192,91478,91496,91497,91498,91599,91600,91943,92102,92135,92922,93527,93785,94418,94420,94421,94422,94423,94424,94427,95083,95331,95332,95333,95347,95680,95822,95833,96068,96152,98059,98131,98132,98329,98358,98782,98831,98927,99059,99072,99080,99092,99106,99141,99212,99254,100468,100832,100852,101171,101507,101569,101690,101767,101768,101770,101771,102024,102032,102359,102385,102626,102686,102687,102731,103085,103205,103228,103287,103296,103356,103357,103668,103669,103670,103697,104389,105127,105273,105726,105883,105884,106054,106082,106092,106135,106136,106182,106183,106210,106384,106421,106529,106531,106532,106585,106600,106629,106877,106884,106892,106974,106979,106984,107274,107385,107552,108427,108445,108450,108451,108452,108453,108535,108565,108750,108777,108868,108928,108952,109121,109174,109240,109249,109282,109283,109309,109345,109387,109540,109683,109692,109764,109801,110160,110162,110163,110369,110370,110696,110702,110777,110894,111080,111081,111085,111087,111129,111181,111193,111215,111268,111955,112353,112354,112355,112391,112688,112691,112749,113057,113063,113110,113131,113141,113206,113257,113312,113325,113446,113654,113739,113879,113911,114036,114037,114039,114227,114279,114710,114773,115003,115004,115045,115092,115106,115249,115274,115290,115308,115785,116292,116327,116423,116438,116488,116660,116662,116692,116924,117170,117354,117355,117392,117413,117534,117698,117782,117787,117858,118057,118112,118113,118114,118115,118470,118491,118505,118546,118579,118724,119007,119054,119137,119147,119148,119168,119271,119612,119749,120130,120541,120667,120687,120882,120898,121061,121139,121316,121407,121486,121522,121523,121583,121701,121702,121720,121724,121732,121773,121790,121800,121817,121843,121846,121858,122164,122460,122602,122611,122624,122712,122716,122772,122816,122817,123093,123107,123123,123126,123133,123157,123158,123159,123167,123206,123338,123421,123422,123448,123781,123826,123827,123968,124069,124236,124407,125589,125735,126042,126049,126183,126199,126271,126562,126603,126708,126716,126924,126967,127197,127417,127457,127494,127506,127588,127692,127698,127741,127798,127844,127904,128093,128266,128588,128678,128863,129236,129345,130382,130593,130612,130640,130696,131061,131062,131156,131409,131485,131591,131648,131649,131650,131651,131652,131653,131709,132136,132163,132198,132216,132270,132284,132348,132368,132415,132432,132452,132517,132518,132610,132678,132732,132774,132810,132904,132919,132988,133240,133430,133466,133723,133754,133988,134022,134083,134869,135086,135145,135146,135147,135177,135298,135325,135345,135371,135463,135465,135646,136025,136144,136172,136173,136174,136257,136455,136490,136568,136584,136760,136951,137093,137259,137265,137268,137350,137400,137464,137658,137672,137674,137792,137796,138013,138069,138077,138160,138302,138315,138328,138574,138617,138655,138773,139340,139350,139695,139769,140129,140134,140254,140807,140830,140831,141032,141096,141247,141284,141303,141363,141365,141643,141686,141764,142132,142174,142179,142351,142964,143104,143308,143756,143930,144064,144144,144357,144368,144369,144415,144471,144477,144530,144537,144541,144570,144572,144576,144609,144614,144652,144790,144885,144920,145095,145156,145374,145611,145614,145866,145988,146197,146418,146701,146767,147140,147141,147142,147143,147144,147145,147146,147148,147191,147323,147362,147593,147744,147901,147955,148303,148322,148347,148423,148424,148435,148589,148728,148787,148831,148837,148896,148961,148967,148984,149004,149042,149051,149263,149277,149424,149430,149515,149519,149665,149789,149838,149886,149936,150069,150204,150313,150411,150501,150579,150660,150760,150761,150765,150766,150955,150979,150982,151115,151181,151254,151264,151318,151427,151437,151542,151670,151694,151717,151759,151767,151816,151817,151821,151882,151958,151962,151992,152037,152125,152129,152132,152202,152241,152447,152658,152791,153140,153606,153937,153976,153996,154051,154136,154370,154396,154465,154482,154521,154546,154620,155005,155024,155349,155356,155722,155762,155922,155925,155926,155934,155936,155937,155948,155952,156570,156677,156678,156794,156857,156860,157006,157007,157033,157153,157182,157473,157650,157651,157819,157927,157997,158026,158271,158272,158273,158368,158713,158714,158794,158847,158889,159126,159351,159456,159457,159695,159875,160003,160004,160081,160241,160269,160386,161035,162267,162274,162275,162369,162370,162411,162418,162423,162466,162732,162739,162838,162839,163134,163391,163394,163742,163750,163796,163797,163802,163810,163855,163994,164077,164268,164269,164357,164452,164975,164977,164999,165075,165133,165240,165491,165492,165561,165679,165744,165893,165912,165957,166010,166126,166219,166382,166393,166677,166693,166820,166838,166908,166925,167110,167822,167881,167883,167885,167960,168183,168646,168725,168760,168904,169062,169120,169235,169496,169497,169590,169591,169635,169638,169640,169641,169642,169646,169650,169898,170079,170084,170089,170254,170255,170345,170355,170613,171096,171189,171303,171348,171395,171406,171444,171573,172052,172070,172085,172170,172326,172374,172377,172379,172380,172867,173086,173150,173317,173505,173657,173945,173964,174183,174287,174426,174436,174437,174472,174473,174716,174738,174743,174940,174956,175202,175432,175580,175806,175863,175866,175869,175870,175964,176050,176109,176163,176189,176242,176287,176601,176923,176942,177020,177202,177236,177423,177464,177532,177586,177727,177771,177792,177801,177991,178330,178425,178429,178431,178483,178545,178630,178631,179175,179441,179710,179711,179738,179976,179998,180080,180084,180166,180191,180197,180672,180799,180815,180909,180910,180945,181035,181138,181141,181143,181147,181169,181276,181282,181352,181359,181362,181397,181512,181514,181515,181667,181676,181784,181883,181911,182061,182209,182212,182990,183085,183260,183289,183335,183363,183381,183640,183837,183854,183889,183911,183985,183987,184108,184734,185192,185321,185496,185584,185655,185661,185685,185697,185817,185896,185948,185977,186005,186043,186256,186281,186410,186816,186831,186846,186967,186999,187095,187238,187377,188053,188209,188410,188452,188550,188797,188848,188980,189079,189270,189380,189394,189439,189670,189688,189952,190144,190299,190353,190415,190665,190708,191048,191310,191418,191547,191923,192002,192336,192342,192437,192468,192835,193188,193385,193389,193856,193869,194060,194307,195242,195327,195587,195721,196829,197553,197880,198290) GROUP BY sold_month ORDER BY scs.date_actual_sold |
| 83 | Creole | executeQuery(): [22.92 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 (21076,21181,21253,21368,21652,21756,21986,21987,22186,22693,22794,23839,23847,23848,23903,24135,24470,24783,24785,24832,24926,24927,24958,24970,25067,25109,25206,25429,25493,25503,25566,25711,25712,25727,25741,25872,25939,25944,26019,26031,26187,26205,26207,26294,26297,26353,26361,26362,26706,26707,26955,27165,27500,27600,27779,27891,27892,27909,27910,27936,27972,27982,27995,28102,28191,28192,28209,28353,28470,28627,28629,28684,28714,28884,28911,28925,28998,28999,29024,29061,29082,29083,29084,29085,29086,29087,29088,29089,29090,29091,29092,29113,29114,29147,29175,29176,29243,29300,29330,29331,29424,29464,29481,29482,29483,29555,29649,29650,29651,29652,29695,29763,29801,29815,29816,29817,29818,29819,29820,29821,29822,29845,29899,29901,29903,29985,29997,29998,30062,30158,30159,30160,30161,30162,30247,30307,30308,30333,30490,30521,30522,30548,30549,30562,30578,30625,30763,30791,30792,30876,30897,30995,31030,31031,31127,31129,31269,31334,31335,31338,31468,31469,31471,31575,31576,31577,31735,31765,31906,31953,31954,31955,31956,31981,31994,31995,32103,32104,32105,32159,32250,32251,32252,32253,32254,32255,32347,32349,32350,32423,32530,32531,32641,32642,32970,32973,32986,33011,33039,33047,33048,33049,33071,33096,33097,33098,33100,33101,33102,33113,33194,33195,33235,33318,33341,33348,33349,33410,33413,33414,33498,33505,33506,33513,33519,33594,33635,33636,33646,33654,33679,33754,33755,34052,34060,34235,34312,34412,34845,34858,34859,34915,34916,34928,34985,35037,35229,35232,35236,35321,35335,35361,35376,35505,35522,35545,35638,35639,35673,35771,35797,36156,36202,36238,36318,36488,36575,36677,36678,36713,36807,36812,36916,36918,36935,36937,36976,37061,37080,37099,37104,38710,38717,38731,38773,38777,38778,38786,38787,38803,38828,38879,38880,38881,38882,38884,38885,38886,38887,38888,38920,39311,39337,39410,39450,39531,39532,39533,39534,39569,39570,39571,39575,39576,39599,39602,39642,39664,39671,41896,41906,41907,41960,42489,42511,42536,42679,43114,43129,43130,43169,43247,43249,43250,43261,43278,43297,43299,43339,43343,43373,43387,43390,43913,43998,44075,44076,44113,44408,44495,44529,44618,44622,44630,45140,45141,45292,45401,45402,45512,45513,45587,45752,46155,46179,46187,46188,46192,46205,46210,46278,46349,46363,46371,46388,46460,46465,46737,46758,46973,46974,46977,47033,47044,47073,47086,47104,47105,47134,47137,47138,47139,47140,47141,47142,47162,47535,47546,47801,47827,47838,47901,47902,47945,47979,48447,48451,48477,48478,48496,48497,48509,48510,48565,48599,48608,48794,48797,48874,48977,48996,49046,49056,49134,49359,49445,49488,49489,49558,49564,49614,49716,49726,49784,49797,49800,49803,49811,49824,49825,49860,49913,49992,50163,50164,50253,50307,50308,50347,50399,50467,50493,50494,50502,50533,50713,50722,50733,50842,50843,50852,50861,50870,50879,50992,50997,51027,51072,51082,51087,51092,51579,51580,51599,51883,51913,51922,51930,51980,51999,52001,52021,52140,52172,52195,52205,52216,52220,52466,52471,52566,52604,52973,53058,53059,53172,53191,53192,53195,53209,53233,53251,53252,53253,53263,53264,53291,53298,53299,53328,53529,53820,53824,54111,54112,54283,54332,54333,54621,54736,54845,54854,55260,55301,55327,55350,55391,55392,55408,55414,55415,55749,55758,55931,56013,56186,56206,56221,56228,56229,56250,56765,56778,56783,56798,56895,56914,56916,57111,57112,57151,57197,57226,57292,57303,57308,57500,57633,57663,57672,57752,57768,57789,58207,58257,58265,58266,58267,58375,58583,58599,58650,58660,58695,58696,58914,58915,58916,58929,58943,58971,58985,59058,59560,59565,59595,59597,59598,59939,60101,60102,60152,60153,60159,60164,60173,60227,60285,60713,60722,60858,60977,61021,61024,61039,61043,61076,61089,61102,61367,61416,61507,61518,61537,61556,61560,61584,61795,61797,61818,61819,62075,62083,62085,62152,62232,62265,62278,62280,62282,62356,62804,62818,62826,62975,62976,63032,63039,63055,63063,63067,63079,63163,63178,63188,63215,63680,63925,63939,63940,63947,63965,63966,63977,64531,64532,64550,64576,64584,64585,64602,64618,64632,64638,64703,64713,64725,64727,65058,65141,65228,65279,65385,65431,65445,65454,65577,65675,66354,66582,66652,66654,66677,66684,66737,66776,66959,66960,67651,67800,67848,67883,67908,67925,67926,67927,67982,68398,68472,68500,68558,68559,68599,68603,68604,68605,68609,68708,68741,69239,69378,69385,69415,69419,69517,69580,69644,70080,70122,70247,70248,70249,70263,70264,70283,70302,70324,70327,70352,70353,70354,70356,70361,70372,70379,70381,70406,70494,70511,70513,70912,70918,70976,70994,71059,71069,71111,71127,71149,71170,71221,71240,71263,71266,71292,71293,71766,71772,71879,71905,71922,71952,71959,72002,72014,72028,72048,72553,72760,72797,72898,73398,73406,73438,74344,74345,74366,74432,74525,75008,75043,75177,75181,76752,76847,76872,77005,77359,77440,77441,77442,77694,78194,78408,78591,78639,81260,81261,81476,83369,83370,83371,83373,83376,83378,83380,83381,83382,83383,83590,83608,84043,84516,84661,84806,84921,85007,85061,85062,85157,85475,85556,85649,85682,85728,85842,85912,85958,86281,86518,86532,86849,86872,87216,87242,88085,88795,88802,88805,88878,89069,89126,89127,89476,90738,90806,91001,91037,91081,91192,91478,91496,91497,91498,91599,91600,91943,92102,92135,92922,93527,93785,94418,94420,94421,94422,94423,94424,94427,95083,95331,95332,95333,95347,95680,95822,95833,96068,96152,98059,98131,98132,98329,98358,98782,98831,98927,99059,99072,99080,99092,99106,99141,99212,99254,100468,100832,100852,101171,101507,101569,101690,101767,101768,101770,101771,102024,102032,102359,102385,102626,102686,102687,102731,103085,103205,103228,103287,103296,103356,103357,103668,103669,103670,103697,104389,105127,105273,105726,105883,105884,106054,106082,106092,106135,106136,106182,106183,106210,106384,106421,106529,106531,106532,106585,106600,106629,106877,106884,106892,106974,106979,106984,107274,107385,107552,108427,108445,108450,108451,108452,108453,108535,108565,108750,108777,108868,108928,108952,109121,109174,109240,109249,109282,109283,109309,109345,109387,109540,109683,109692,109764,109801,110160,110162,110163,110369,110370,110696,110702,110777,110894,111080,111081,111085,111087,111129,111181,111193,111215,111268,111955,112353,112354,112355,112391,112688,112691,112749,113057,113063,113110,113131,113141,113206,113257,113312,113325,113446,113654,113739,113879,113911,114036,114037,114039,114227,114279,114710,114773,115003,115004,115045,115092,115106,115249,115274,115290,115308,115785,116292,116327,116423,116438,116488,116660,116662,116692,116924,117170,117354,117355,117392,117413,117534,117698,117782,117787,117858,118057,118112,118113,118114,118115,118470,118491,118505,118546,118579,118724,119007,119054,119137,119147,119148,119168,119271,119612,119749,120130,120541,120667,120687,120882,120898,121061,121139,121316,121407,121486,121522,121523,121583,121701,121702,121720,121724,121732,121773,121790,121800,121817,121843,121846,121858,122164,122460,122602,122611,122624,122712,122716,122772,122816,122817,123093,123107,123123,123126,123133,123157,123158,123159,123167,123206,123338,123421,123422,123448,123781,123826,123827,123968,124069,124236,124407,125589,125735,126042,126049,126183,126199,126271,126562,126603,126708,126716,126924,126967,127197,127417,127457,127494,127506,127588,127692,127698,127741,127798,127844,127904,128093,128266,128588,128678,128863,129236,129345,130382,130593,130612,130640,130696,131061,131062,131156,131409,131485,131591,131648,131649,131650,131651,131652,131653,131709,132136,132163,132198,132216,132270,132284,132348,132368,132415,132432,132452,132517,132518,132610,132678,132732,132774,132810,132904,132919,132988,133240,133430,133466,133723,133754,133988,134022,134083,134869,135086,135145,135146,135147,135177,135298,135325,135345,135371,135463,135465,135646,136025,136144,136172,136173,136174,136257,136455,136490,136568,136584,136760,136951,137093,137259,137265,137268,137350,137400,137464,137658,137672,137674,137792,137796,138013,138069,138077,138160,138302,138315,138328,138574,138617,138655,138773,139340,139350,139695,139769,140129,140134,140254,140807,140830,140831,141032,141096,141247,141284,141303,141363,141365,141643,141686,141764,142132,142174,142179,142351,142964,143104,143308,143756,143930,144064,144144,144357,144368,144369,144415,144471,144477,144530,144537,144541,144570,144572,144576,144609,144614,144652,144790,144885,144920,145095,145156,145374,145611,145614,145866,145988,146197,146418,146701,146767,147140,147141,147142,147143,147144,147145,147146,147148,147191,147323,147362,147593,147744,147901,147955,148303,148322,148347,148423,148424,148435,148589,148728,148787,148831,148837,148896,148961,148967,148984,149004,149042,149051,149263,149277,149424,149430,149515,149519,149665,149789,149838,149886,149936,150069,150204,150313,150411,150501,150579,150660,150760,150761,150765,150766,150955,150979,150982,151115,151181,151254,151264,151318,151427,151437,151542,151670,151694,151717,151759,151767,151816,151817,151821,151882,151958,151962,151992,152037,152125,152129,152132,152202,152241,152447,152658,152791,153140,153606,153937,153976,153996,154051,154136,154370,154396,154465,154482,154521,154546,154620,155005,155024,155349,155356,155722,155762,155922,155925,155926,155934,155936,155937,155948,155952,156570,156677,156678,156794,156857,156860,157006,157007,157033,157153,157182,157473,157650,157651,157819,157927,157997,158026,158271,158272,158273,158368,158713,158714,158794,158847,158889,159126,159351,159456,159457,159695,159875,160003,160004,160081,160241,160269,160386,161035,162267,162274,162275,162369,162370,162411,162418,162423,162466,162732,162739,162838,162839,163134,163391,163394,163742,163750,163796,163797,163802,163810,163855,163994,164077,164268,164269,164357,164452,164975,164977,164999,165075,165133,165240,165491,165492,165561,165679,165744,165893,165912,165957,166010,166126,166219,166382,166393,166677,166693,166820,166838,166908,166925,167110,167822,167881,167883,167885,167960,168183,168646,168725,168760,168904,169062,169120,169235,169496,169497,169590,169591,169635,169638,169640,169641,169642,169646,169650,169898,170079,170084,170089,170254,170255,170345,170355,170613,171096,171189,171303,171348,171395,171406,171444,171573,172052,172070,172085,172170,172326,172374,172377,172379,172380,172867,173086,173150,173317,173505,173657,173945,173964,174183,174287,174426,174436,174437,174472,174473,174716,174738,174743,174940,174956,175202,175432,175580,175806,175863,175866,175869,175870,175964,176050,176109,176163,176189,176242,176287,176601,176923,176942,177020,177202,177236,177423,177464,177532,177586,177727,177771,177792,177801,177991,178330,178425,178429,178431,178483,178545,178630,178631,179175,179441,179710,179711,179738,179976,179998,180080,180084,180166,180191,180197,180672,180799,180815,180909,180910,180945,181035,181138,181141,181143,181147,181169,181276,181282,181352,181359,181362,181397,181512,181514,181515,181667,181676,181784,181883,181911,182061,182209,182212,182990,183085,183260,183289,183335,183363,183381,183640,183837,183854,183889,183911,183985,183987,184108,184734,185192,185321,185496,185584,185655,185661,185685,185697,185817,185896,185948,185977,186005,186043,186256,186281,186410,186816,186831,186846,186967,186999,187095,187238,187377,188053,188209,188410,188452,188550,188797,188848,188980,189079,189270,189380,189394,189439,189670,189688,189952,190144,190299,190353,190415,190665,190708,191048,191310,191418,191547,191923,192002,192336,192342,192437,192468,192835,193188,193385,193389,193856,193869,194060,194307,195242,195327,195587,195721,196829,197553,197880,198290) GROUP BY sold_month ORDER BY scs.date_actual_sold |
| 84 | 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 |
| 85 | Creole | executeQuery(): [1595.79 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 |
| 86 | Action | change layout to "view_layout" |
| 87 | View | initialize view for "home/view" |
| 88 | View | render "sf_app_dir/modules/home/templates/viewSuccess.php" |
| 89 | View | initialize view for "home/_vif_images" |
| 90 | View | render "sf_app_dir/modules/home/templates/_vif_images.php" |
| 91 | PartialHelper | Generate cache key |
| 92 | View | initialize view for "common_page/_social_buttons" |
| 93 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php" |
| 94 | PartialHelper | Generate cache key |
| 95 | View | initialize view for "home/_vif_info" |
| 96 | View | render "sf_app_dir/modules/home/templates/_vif_info.php" |
| 97 | PartialHelper | Generate cache key |
| 98 | View | initialize view for "home/_owner_info" |
| 99 | View | render "sf_app_dir/modules/home/templates/_owner_info.php" |
| 100 | PartialHelper | Generate cache key |
| 101 | View | initialize view for "common_page/_price_development_graph" |
| 102 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php" |
| 103 | PartialHelper | Generate cache key |
| 104 | View | initialize view for "common_page/_sell_time_price_graph" |
| 105 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php" |
| 106 | PartialHelper | Generate cache key |
| 107 | View | initialize view for "common_page/_price_gauge_graph" |
| 108 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php" |
| 109 | PartialHelper | Generate cache key |
| 110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 111 | Creole | executeQuery(): [0.65 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199964 |
| 112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 113 | Creole | executeQuery(): [0.53 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199915 |
| 114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 115 | Creole | executeQuery(): [0.55 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199861 |
| 116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 117 | Creole | executeQuery(): [0.52 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199832 |
| 118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 119 | Creole | executeQuery(): [0.56 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199775 |
| 120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 121 | Creole | executeQuery(): [0.61 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=161165 |
| 122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 123 | Creole | executeQuery(): [0.57 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=160641 |
| 124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 125 | Creole | executeQuery(): [0.62 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=159994 |
| 126 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 127 | Creole | executeQuery(): [0.64 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=159993 |
| 128 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
| 129 | Creole | executeQuery(): [0.52 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=159992 |
| 130 | View | initialize view for "common_page/_include_vif_js" |
| 131 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_include_vif_js.php" |
| 132 | PartialHelper | Generate cache key |
| 133 | View | initialize view for "common_page/_fancybox_javascript" |
| 134 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php" |
| 135 | PartialHelper | Generate cache key |
| 136 | View | decorate content with "sf_app_dir/templates/view_layout.php" |
| 137 | View | render "sf_app_dir/templates/view_layout.php" |
| 138 | View | initialize view for "common_page/_responsive_javascript" |
| 139 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_javascript.php" |
| 140 | PartialHelper | Generate cache key |
| 141 | View | initialize view for "common_page/_google_analytics" |
| 142 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_google_analytics.php" |
| 143 | PartialHelper | Generate cache key |
| 144 | View | initialize view for "common_page/_header_links" |
| 145 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_header_links.php" |
| 146 | View | initialize view for "common_page/_fancybox_javascript" |
| 147 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php" |
| 148 | PartialHelper | Generate cache key |
| 149 | View | initialize view for "common_page/_cookie_policy" |
| 150 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_cookie_policy.php" |
| 151 | PartialHelper | Generate cache key |
| 152 | PartialHelper | Generate cache key |
| 153 | View | initialize view for "common_page/_responsive_top_menu" |
| 154 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_top_menu.php" |
| 155 | PartialHelper | Generate cache key |
| 156 | View | initialize view for "common_page/_top_menu" |
| 157 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_top_menu.php" |
| 158 | PartialHelper | Generate cache key |
| 159 | View | initialize view for "common_page/_footer_javascript" |
| 160 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer_javascript.php" |
| 161 | PartialHelper | Generate cache key |
| 162 | View | initialize view for "common_page/_footer" |
| 163 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer.php" |
| 164 | PartialHelper | Generate cache key |
vars & config
logs & msgs
41
10706.0 KB
1883 ms
