People who viewed this Chevrolet Chevelle also viewed similar Chevrolet listed at ClassicDigest
Other cars listed for sale by this dealer
# | 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' => 'chevrolet', 'model' => 'chevelle', 'id' => '173387', '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(): [12.75 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=173387 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(): [11.43 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 (897) |
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(): [17.41 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=173387 |
38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
39 | Creole | executeQuery(): [9.82 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=173387 |
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(): [40.55 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=173387 |
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(): [10.30 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 (897) |
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(): [6.64 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=173387 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(): [16.66 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 (173387) ORDER BY carimg.ORD ASC |
49 | Creole | executeQuery(): [18.21 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 (173387) 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(): [3.88 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 (897) |
52 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
53 | Creole | executeQuery(): [2.60 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=897 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(): [4.50 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=35 AND model.ID=379 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 != 173387 AND car.ID_MODEL = '379' ) 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 != 173387 AND car.ID_MODEL = '379' ) 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 != 173387 AND car.ID_MODEL = '379' ) 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 != 173387 AND car.ID_MODEL = '379' ) ) AS count |
58 | Creole | executeQuery(): [12.84 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 != 173387 AND car.ID_MODEL = '379' ) 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 != 173387 AND car.ID_MODEL = '379' ) ) 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 != 173387 AND car.ID_MODEL = '379' ) 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 != 173387 AND car.ID_MODEL = '379' ) ORDER BY ID DESC, offset: 0, limit: 5 |
60 | Creole | executeQuery(): [13.41 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 != 173387 AND car.ID_MODEL = '379' ) 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 != 173387 AND car.ID_MODEL = '379' ) 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 (200012,199860,199834,199776,199757) ORDER BY carimg.ORD ASC |
62 | Creole | executeQuery(): [1.39 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 (200012,199860,199834,199776,199757) 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 != '173387' AND car.ID_NETTI_USER = '897' ) 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 != '173387' AND car.ID_NETTI_USER = '897' ) 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 != '173387' AND car.ID_NETTI_USER = '897' ) 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 != '173387' AND car.ID_NETTI_USER = '897' ) ) AS count |
65 | Creole | executeQuery(): [10.86 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 != '173387' AND car.ID_NETTI_USER = '897' ) 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 != '173387' AND car.ID_NETTI_USER = '897' ) ) 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 != '173387' AND car.ID_NETTI_USER = '897' ) 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 != '173387' AND car.ID_NETTI_USER = '897' ) ORDER BY ID DESC, offset: 0, limit: 5 |
67 | Creole | executeQuery(): [19.50 ms] ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '173387' AND car.ID_NETTI_USER = '897' ) 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 != '173387' AND car.ID_NETTI_USER = '897' ) 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 (173392,173391,173390,173389,173388) ORDER BY carimg.ORD ASC |
69 | Creole | executeQuery(): [1.12 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 (173392,173391,173390,173389,173388) 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(): [10.42 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=35 AND car.ID_MODEL=379 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(): [78.96 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=35 AND sold_car.ID_MODEL=379 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 (115294,130418,141605,142032,146901,151585,153713,154277,154789,154817,155839,155855,166093,166761,166853,167123,167652,169057,169242,169442,169443,169665,170002,171107,172138,172268,172592,172709,172763,173065,173387,173388,174625,176172,178085,179321,180077,183278,183602,184144,185230,186175,187450,188484,189927,190423,191759,191792,191921,192531,192640,192802,193138,193253,193546,193641,194251,194301,194392,194399,194559,194618,194737,195407,195416,195631,195856,195888,195945,196056,196187,196633,196690,196691,196717,196805,196853,196898,196919,196978,196992,197108,197179,197217,197344,197394,197540,197541,197596,197710,197768,198231,198639,198686,198907,199251,199299,199499,199703,199757,199776,199834,199860,200012) GROUP BY cmonth ORDER BY date_create |
75 | Creole | executeQuery(): [2.38 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 (115294,130418,141605,142032,146901,151585,153713,154277,154789,154817,155839,155855,166093,166761,166853,167123,167652,169057,169242,169442,169443,169665,170002,171107,172138,172268,172592,172709,172763,173065,173387,173388,174625,176172,178085,179321,180077,183278,183602,184144,185230,186175,187450,188484,189927,190423,191759,191792,191921,192531,192640,192802,193138,193253,193546,193641,194251,194301,194392,194399,194559,194618,194737,195407,195416,195631,195856,195888,195945,196056,196187,196633,196690,196691,196717,196805,196853,196898,196919,196978,196992,197108,197179,197217,197344,197394,197540,197541,197596,197710,197768,198231,198639,198686,198907,199251,199299,199499,199703,199757,199776,199834,199860,200012) 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 (22550,22551,22552,22557,22566,22567,22581,22596,22602,22603,22752,22757,22764,22807,22987,23371,23374,23392,23394,23440,23443,23447,23448,23453,23454,23550,23612,23671,23675,23894,23899,24097,24692,25037,25153,25156,25248,25253,25366,25717,25736,25862,26129,26278,26285,26319,26357,26664,27446,27452,27489,28238,29620,29621,32374,32375,33155,33156,33486,34383,35019,35034,35052,35063,35098,35121,36207,36608,36609,38855,38856,42000,42591,43218,43322,43323,43960,44055,44723,46499,47594,49101,50339,50967,53808,54859,55369,55810,55827,55828,55846,55853,55949,55959,55968,55977,55986,55998,56113,56114,56129,56144,56145,56160,56175,56195,56196,56197,56207,56216,56217,56218,56383,56384,56749,56761,56769,56772,56886,57016,57026,57041,57066,57067,57081,57082,57272,57277,57278,57294,57368,57369,57370,57379,57387,57396,57496,57503,57637,57640,57652,57744,57745,57755,57795,58218,58234,58235,58259,58341,58343,58350,58542,58554,58568,58569,58608,58609,58610,58627,58628,58629,58639,58654,58655,58925,59029,59030,59394,59542,59550,59979,59980,59993,60275,60644,60744,60745,60787,60788,60789,60805,61005,61150,61162,61190,61442,61444,61547,61549,61664,62112,62159,62161,62255,62444,62827,63004,63014,63015,63109,63194,63738,63740,63776,64021,64032,64386,64392,64412,64413,64566,65145,65157,65221,65742,65747,65797,65827,66399,66404,67822,67919,67928,67951,69559,69626,70090,70097,70114,70116,70117,70291,70544,71087,71302,71928,72052,72581,72656,72868,72878,72899,73414,73422,73649,74201,74372,74375,74462,75046,75262,75846,75889,75893,76185,77420,78178,78180,78190,78214,78224,78295,78304,78305,78373,78382,78395,78396,78397,78398,78404,78405,78595,78607,80457,80914,80915,80928,80935,80937,81232,81477,81863,81872,81874,81907,81970,81987,81991,82002,82408,82428,82504,82524,82936,82945,82950,83034,83052,83075,83111,83262,83514,84105,84121,84781,85151,85163,85164,85335,85479,85741,85742,85987,86053,86054,86158,86380,86385,86387,86580,86584,86762,86826,86827,86890,87019,87163,87164,87251,87323,87338,87345,87879,87885,88035,88038,88042,88454,88938,89115,89474,89629,90138,90140,90739,91032,91039,91040,91049,91057,91759,91865,92722,92724,92725,92740,92887,92888,93481,93523,93701,94541,95016,95081,95098,95148,95161,95575,95692,95695,95817,95896,95899,96026,96027,97818,97861,97862,98068,98188,98411,98412,98413,98721,98981,99274,99450,100317,100540,100552,100794,100877,101209,101349,101500,101725,101740,101834,102154,102191,102202,102328,102383,102409,102415,102641,102754,102755,102989,102991,103090,103245,103258,103775,103863,104014,104194,104195,104196,104198,104772,104920,104921,104922,105286,105297,105312,105598,105692,105693,105757,105790,105908,106474,106572,106618,106684,106795,106885,106901,106903,106912,107042,107063,107129,107130,107134,107246,107262,107263,107372,107521,108031,108042,108043,108096,108097,108113,108114,108115,108116,108117,108142,108224,108500,108530,108532,108553,108554,108707,108711,108821,108823,108829,109002,109052,109207,109543,109585,109589,109594,109746,109895,109896,109952,110210,110214,110228,110234,110238,110239,110240,110243,110252,110259,110266,110273,110313,110314,110315,110316,110523,110565,110566,110747,110890,111003,111005,111016,111107,111223,111262,111647,111723,112520,112522,112621,112766,112799,112827,112884,113151,113207,113314,113578,113593,113629,113773,113861,113862,113863,113866,114118,114225,114228,114234,114286,114485,114488,114534,114540,114724,114726,114791,114796,114818,114824,114829,114833,114983,114994,114996,114997,115035,115075,115169,115177,115247,115248,115319,115481,115495,115496,115497,115504,115505,115506,115507,115508,115509,115510,115519,115722,116085,116093,116155,116165,116214,116328,116333,116334,116345,116378,116422,116487,116511,116513,116514,116515,116531,116535,116779,116782,116927,116941,116942,116967,117140,117143,117217,117297,117298,117302,117329,117370,117457,117514,117518,117521,117566,117653,117664,117773,117836,117933,117934,117978,117983,117990,118064,118091,118297,118375,118418,118435,118519,118707,118787,119026,119044,119107,119119,119200,119245,119317,120566,120577,120578,120636,120652,120653,120671,120672,120673,120682,120683,120903,121004,121005,121006,121007,121015,121016,121017,121018,121050,121051,121064,121065,121066,121067,121081,121082,121099,121100,121101,121325,121333,121351,121373,121374,121383,121384,121385,121586,121640,121647,121655,121678,121679,121703,121704,121705,121706,121707,121754,121852,121951,121956,121957,121960,121961,122038,122042,122053,122153,122188,122328,122351,122360,122435,122440,122441,122442,122476,122486,122701,122708,122922,123390,123392,123395,123396,123397,123645,123690,123691,123736,123754,123797,123871,123876,123981,123983,124041,124109,124122,124229,124234,124303,124336,125310,125338,125393,125600,125617,125776,125777,125848,125851,125901,125916,125976,125983,126050,126173,126428,126522,126632,126690,126730,126759,126769,126774,126801,126813,126885,126925,126927,126938,126990,127002,127260,127382,127393,127429,127456,127480,127499,127614,127616,127678,127816,127826,128022,128042,128145,128323,128327,128331,128373,128466,128472,128475,128482,128490,128512,128652,128653,128765,128795,128814,128896,128980,128997,129007,129008,129020,129036,129074,129121,129154,129176,129320,129327,129393,129616,130165,130961,130962,131076,131334,131869,132052,132101,132149,132234,132251,132289,132304,132395,132397,132438,132536,132677,132680,132681,132683,132833,132941,132975,133371,133372,133373,133507,133682,133697,133727,133882,134189,134506,134583,135099,135182,135658,135797,135869,136606,136611,136612,136640,136641,136642,136643,136644,136953,136963,136967,137056,137067,137068,137074,137079,137166,137232,137251,137252,137359,137373,137378,137453,137461,137467,137650,137659,137661,137760,137771,137776,137783,137784,137864,137944,138007,138010,138012,138035,138042,138046,138048,138051,138052,138053,138059,138062,138176,138182,138192,138200,138436,138588,138601,138611,138613,138628,138629,138632,138635,138728,138738,138739,138750,138761,139206,139257,139346,139659,139660,139696,139698,139723,139725,139727,139736,139737,139741,139750,140209,140422,140647,140758,141029,141031,141077,141087,141210,141229,141316,141328,141415,141429,141436,141617,141739,142008,142136,142138,142190,142321,142322,142400,142473,142485,142489,142498,142511,142556,142567,142657,142745,142831,142854,142913,142918,143309,143326,143350,143412,143413,143414,143467,143638,143643,143660,143719,143732,143825,143879,143884,143886,143953,143966,143967,143968,144470,144492,144701,144718,144783,144784,144899,144915,144953,145001,145028,145054,145178,145257,145264,145275,145279,145285,145290,145296,145352,145355,145395,145482,145483,145498,145643,145644,145650,145740,145741,145742,145743,145744,145751,145752,145753,145754,145755,145756,145789,145790,145791,145804,145805,145806,145807,145819,145820,145976,145997,146024,146232,146303,146381,146451,146468,146469,146480,146500,146592,146594,146675,146684,146689,146760,146761,146788,146876,146895,146926,146973,147019,147023,147025,147028,147029,147094,147186,147211,147223,147224,147237,147345,147346,147397,147482,147502,147505,147635,147691,147733,147845,147878,147929,147974,148003,148016,148058,148090,148091,148268,148270,148358,148366,148372,148379,148393,148394,148467,148513,148527,148667,148760,148807,148890,149037,149200,149260,149321,149442,149623,149697,149856,149974,150023,150110,150306,150357,150366,150441,150496,150824,150849,150957,150978,151062,151123,151231,151242,151276,151341,151420,151424,151426,151654,151701,151828,151900,151966,151967,151998,151999,152609,152756,152806,153065,153066,153345,153386,153412,153413,153418,153511,153534,153539,153571,153577,153652,153661,153861,153887,153892,153893,153895,153981,153988,153990,153998,154040,154041,154098,154123,154124,154155,154166,154248,154249,154352,154356,154357,154378,154565,154731,154744,154750,154751,154752,154753,154762,154859,154938,155122,155157,155411,155418,155528,155804,156392,156493,156735,156879,157031,157150,157158,157283,157288,157289,157290,157302,157317,157318,157319,157320,157327,157328,157329,157330,157331,157345,157507,157568,157623,157643,157764,157909,157950,158032,158137,158194,158196,158197,158310,158435,158455,158456,158457,159154,159344,159424,159428,159505,159534,159548,159593,159744,159804,160015,160016,160145,160146,160547,161682,162511,162647,163170,163268,163280,163559,163687,163873,164042,164613,164667,164725,164930,165079,165092,165185,165300,165311,165320,165321,165322,165428,165429,165591,165720,165741,165976,165980,165983,166031,166129,166227,166295,166450,166451,166452,166467,166471,166472,166473,166474,166488,166489,166490,166500,166536,166545,166559,166632,166633,166655,166667,166696,166697,166722,166723,166762,166763,166764,166777,166778,166798,166799,166800,166922,166934,167034,167035,167081,167133,167142,167143,167241,167369,167421,167448,167495,167841,167895,168141,168144,168254,168256,168265,168266,168285,168323,168331,168335,168336,168361,168367,168437,168438,168482,168537,168614,168722,168833,168903,168932,169023,169136,169140,169143,169184,169244,169301,169335,169379,169413,169487,169518,169532,169630,169755,169820,169887,169894,169923,170019,170107,170336,170408,170414,170496,170516,170583,170686,170700,170701,170910,171060,171091,171141,171226,171374,171429,171522,171745,171774,172122,172284,172323,172367,172368,172447,172453,172598,172686,172840,172865,172882,172917,172919,172927,172928,172976,172982,172984,173055,173080,173145,173174,173232,173349,173351,173378,173609,173642,173695,173800,173902,174066,174085,174178,174213,174238,174247,174383,174540,174850,174993,175229,175294,175327,175347,175406,175431,175515,175530,175534,175563,175661,175667,175777,175797,175799,175831,176252,176256,176258,176314,176389,176484,176778,177013,177014,177027,177118,177452,177701,177806,177935,178116,178156,178158,178234,178363,178391,178414,178470,178571,178603,178605,178608,178722,179095,179411,179538,179599,179766,179775,179792,179802,180026,180103,180276,180277,180363,180564,180583,180697,180730,180873,180902,180903,180904,180944,180949,180950,181095,181125,181242,181262,181263,181265,181379,181483,181485,181489,181491,181532,181575,181619,181703,181704,181707,181779,181782,181831,181838,181873,181920,181921,181989,182029,182190,182193,182202,182535,182536,182794,182821,182825,182946,183014,183127,183143,183309,183310,183673,183678,183679,183790,183835,184042,184213,184248,184251,184387,184497,184533,184638,184704,184837,185005,185053,185132,185134,185188,185193,185258,185266,185407,185606,185691,185751,185778,185809,185918,185919,185960,185962,186020,186076,186215,186338,186378,186379,186380,186460,186464,186504,186542,186546,186603,186627,186631,186633,186775,186803,186832,186903,186904,187078,187102,187234,187286,187601,187635,187721,187755,188138,188143,188174,188221,188269,188549,188617,188670,188820,188873,188902,188926,188931,188935,188988,189044,189188,189216,189269,189275,189345,189578,189708,189754,189780,189958,189971,190434,190729,190931,191051,191182,191215,191386,191442,191506,191658,191747,191891,191941,192024,192027,192069,192230,192242,192279,192302,192351,192420,192459,192513,192521,192560,192585,192745,192848,192892,192900,192903,193080,193161,193208,193222,193251,193453,193484,193539,193582,193600,193712,193780,193911,193928,193947,194073,194339,194407,194445,194610,194639,195650,195931,195944,196438,196505,196615,196644,196658,196916,197699,197803,197804) GROUP BY sold_week ORDER BY scs.date_actual_sold |
77 | Creole | executeQuery(): [28.89 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 (22550,22551,22552,22557,22566,22567,22581,22596,22602,22603,22752,22757,22764,22807,22987,23371,23374,23392,23394,23440,23443,23447,23448,23453,23454,23550,23612,23671,23675,23894,23899,24097,24692,25037,25153,25156,25248,25253,25366,25717,25736,25862,26129,26278,26285,26319,26357,26664,27446,27452,27489,28238,29620,29621,32374,32375,33155,33156,33486,34383,35019,35034,35052,35063,35098,35121,36207,36608,36609,38855,38856,42000,42591,43218,43322,43323,43960,44055,44723,46499,47594,49101,50339,50967,53808,54859,55369,55810,55827,55828,55846,55853,55949,55959,55968,55977,55986,55998,56113,56114,56129,56144,56145,56160,56175,56195,56196,56197,56207,56216,56217,56218,56383,56384,56749,56761,56769,56772,56886,57016,57026,57041,57066,57067,57081,57082,57272,57277,57278,57294,57368,57369,57370,57379,57387,57396,57496,57503,57637,57640,57652,57744,57745,57755,57795,58218,58234,58235,58259,58341,58343,58350,58542,58554,58568,58569,58608,58609,58610,58627,58628,58629,58639,58654,58655,58925,59029,59030,59394,59542,59550,59979,59980,59993,60275,60644,60744,60745,60787,60788,60789,60805,61005,61150,61162,61190,61442,61444,61547,61549,61664,62112,62159,62161,62255,62444,62827,63004,63014,63015,63109,63194,63738,63740,63776,64021,64032,64386,64392,64412,64413,64566,65145,65157,65221,65742,65747,65797,65827,66399,66404,67822,67919,67928,67951,69559,69626,70090,70097,70114,70116,70117,70291,70544,71087,71302,71928,72052,72581,72656,72868,72878,72899,73414,73422,73649,74201,74372,74375,74462,75046,75262,75846,75889,75893,76185,77420,78178,78180,78190,78214,78224,78295,78304,78305,78373,78382,78395,78396,78397,78398,78404,78405,78595,78607,80457,80914,80915,80928,80935,80937,81232,81477,81863,81872,81874,81907,81970,81987,81991,82002,82408,82428,82504,82524,82936,82945,82950,83034,83052,83075,83111,83262,83514,84105,84121,84781,85151,85163,85164,85335,85479,85741,85742,85987,86053,86054,86158,86380,86385,86387,86580,86584,86762,86826,86827,86890,87019,87163,87164,87251,87323,87338,87345,87879,87885,88035,88038,88042,88454,88938,89115,89474,89629,90138,90140,90739,91032,91039,91040,91049,91057,91759,91865,92722,92724,92725,92740,92887,92888,93481,93523,93701,94541,95016,95081,95098,95148,95161,95575,95692,95695,95817,95896,95899,96026,96027,97818,97861,97862,98068,98188,98411,98412,98413,98721,98981,99274,99450,100317,100540,100552,100794,100877,101209,101349,101500,101725,101740,101834,102154,102191,102202,102328,102383,102409,102415,102641,102754,102755,102989,102991,103090,103245,103258,103775,103863,104014,104194,104195,104196,104198,104772,104920,104921,104922,105286,105297,105312,105598,105692,105693,105757,105790,105908,106474,106572,106618,106684,106795,106885,106901,106903,106912,107042,107063,107129,107130,107134,107246,107262,107263,107372,107521,108031,108042,108043,108096,108097,108113,108114,108115,108116,108117,108142,108224,108500,108530,108532,108553,108554,108707,108711,108821,108823,108829,109002,109052,109207,109543,109585,109589,109594,109746,109895,109896,109952,110210,110214,110228,110234,110238,110239,110240,110243,110252,110259,110266,110273,110313,110314,110315,110316,110523,110565,110566,110747,110890,111003,111005,111016,111107,111223,111262,111647,111723,112520,112522,112621,112766,112799,112827,112884,113151,113207,113314,113578,113593,113629,113773,113861,113862,113863,113866,114118,114225,114228,114234,114286,114485,114488,114534,114540,114724,114726,114791,114796,114818,114824,114829,114833,114983,114994,114996,114997,115035,115075,115169,115177,115247,115248,115319,115481,115495,115496,115497,115504,115505,115506,115507,115508,115509,115510,115519,115722,116085,116093,116155,116165,116214,116328,116333,116334,116345,116378,116422,116487,116511,116513,116514,116515,116531,116535,116779,116782,116927,116941,116942,116967,117140,117143,117217,117297,117298,117302,117329,117370,117457,117514,117518,117521,117566,117653,117664,117773,117836,117933,117934,117978,117983,117990,118064,118091,118297,118375,118418,118435,118519,118707,118787,119026,119044,119107,119119,119200,119245,119317,120566,120577,120578,120636,120652,120653,120671,120672,120673,120682,120683,120903,121004,121005,121006,121007,121015,121016,121017,121018,121050,121051,121064,121065,121066,121067,121081,121082,121099,121100,121101,121325,121333,121351,121373,121374,121383,121384,121385,121586,121640,121647,121655,121678,121679,121703,121704,121705,121706,121707,121754,121852,121951,121956,121957,121960,121961,122038,122042,122053,122153,122188,122328,122351,122360,122435,122440,122441,122442,122476,122486,122701,122708,122922,123390,123392,123395,123396,123397,123645,123690,123691,123736,123754,123797,123871,123876,123981,123983,124041,124109,124122,124229,124234,124303,124336,125310,125338,125393,125600,125617,125776,125777,125848,125851,125901,125916,125976,125983,126050,126173,126428,126522,126632,126690,126730,126759,126769,126774,126801,126813,126885,126925,126927,126938,126990,127002,127260,127382,127393,127429,127456,127480,127499,127614,127616,127678,127816,127826,128022,128042,128145,128323,128327,128331,128373,128466,128472,128475,128482,128490,128512,128652,128653,128765,128795,128814,128896,128980,128997,129007,129008,129020,129036,129074,129121,129154,129176,129320,129327,129393,129616,130165,130961,130962,131076,131334,131869,132052,132101,132149,132234,132251,132289,132304,132395,132397,132438,132536,132677,132680,132681,132683,132833,132941,132975,133371,133372,133373,133507,133682,133697,133727,133882,134189,134506,134583,135099,135182,135658,135797,135869,136606,136611,136612,136640,136641,136642,136643,136644,136953,136963,136967,137056,137067,137068,137074,137079,137166,137232,137251,137252,137359,137373,137378,137453,137461,137467,137650,137659,137661,137760,137771,137776,137783,137784,137864,137944,138007,138010,138012,138035,138042,138046,138048,138051,138052,138053,138059,138062,138176,138182,138192,138200,138436,138588,138601,138611,138613,138628,138629,138632,138635,138728,138738,138739,138750,138761,139206,139257,139346,139659,139660,139696,139698,139723,139725,139727,139736,139737,139741,139750,140209,140422,140647,140758,141029,141031,141077,141087,141210,141229,141316,141328,141415,141429,141436,141617,141739,142008,142136,142138,142190,142321,142322,142400,142473,142485,142489,142498,142511,142556,142567,142657,142745,142831,142854,142913,142918,143309,143326,143350,143412,143413,143414,143467,143638,143643,143660,143719,143732,143825,143879,143884,143886,143953,143966,143967,143968,144470,144492,144701,144718,144783,144784,144899,144915,144953,145001,145028,145054,145178,145257,145264,145275,145279,145285,145290,145296,145352,145355,145395,145482,145483,145498,145643,145644,145650,145740,145741,145742,145743,145744,145751,145752,145753,145754,145755,145756,145789,145790,145791,145804,145805,145806,145807,145819,145820,145976,145997,146024,146232,146303,146381,146451,146468,146469,146480,146500,146592,146594,146675,146684,146689,146760,146761,146788,146876,146895,146926,146973,147019,147023,147025,147028,147029,147094,147186,147211,147223,147224,147237,147345,147346,147397,147482,147502,147505,147635,147691,147733,147845,147878,147929,147974,148003,148016,148058,148090,148091,148268,148270,148358,148366,148372,148379,148393,148394,148467,148513,148527,148667,148760,148807,148890,149037,149200,149260,149321,149442,149623,149697,149856,149974,150023,150110,150306,150357,150366,150441,150496,150824,150849,150957,150978,151062,151123,151231,151242,151276,151341,151420,151424,151426,151654,151701,151828,151900,151966,151967,151998,151999,152609,152756,152806,153065,153066,153345,153386,153412,153413,153418,153511,153534,153539,153571,153577,153652,153661,153861,153887,153892,153893,153895,153981,153988,153990,153998,154040,154041,154098,154123,154124,154155,154166,154248,154249,154352,154356,154357,154378,154565,154731,154744,154750,154751,154752,154753,154762,154859,154938,155122,155157,155411,155418,155528,155804,156392,156493,156735,156879,157031,157150,157158,157283,157288,157289,157290,157302,157317,157318,157319,157320,157327,157328,157329,157330,157331,157345,157507,157568,157623,157643,157764,157909,157950,158032,158137,158194,158196,158197,158310,158435,158455,158456,158457,159154,159344,159424,159428,159505,159534,159548,159593,159744,159804,160015,160016,160145,160146,160547,161682,162511,162647,163170,163268,163280,163559,163687,163873,164042,164613,164667,164725,164930,165079,165092,165185,165300,165311,165320,165321,165322,165428,165429,165591,165720,165741,165976,165980,165983,166031,166129,166227,166295,166450,166451,166452,166467,166471,166472,166473,166474,166488,166489,166490,166500,166536,166545,166559,166632,166633,166655,166667,166696,166697,166722,166723,166762,166763,166764,166777,166778,166798,166799,166800,166922,166934,167034,167035,167081,167133,167142,167143,167241,167369,167421,167448,167495,167841,167895,168141,168144,168254,168256,168265,168266,168285,168323,168331,168335,168336,168361,168367,168437,168438,168482,168537,168614,168722,168833,168903,168932,169023,169136,169140,169143,169184,169244,169301,169335,169379,169413,169487,169518,169532,169630,169755,169820,169887,169894,169923,170019,170107,170336,170408,170414,170496,170516,170583,170686,170700,170701,170910,171060,171091,171141,171226,171374,171429,171522,171745,171774,172122,172284,172323,172367,172368,172447,172453,172598,172686,172840,172865,172882,172917,172919,172927,172928,172976,172982,172984,173055,173080,173145,173174,173232,173349,173351,173378,173609,173642,173695,173800,173902,174066,174085,174178,174213,174238,174247,174383,174540,174850,174993,175229,175294,175327,175347,175406,175431,175515,175530,175534,175563,175661,175667,175777,175797,175799,175831,176252,176256,176258,176314,176389,176484,176778,177013,177014,177027,177118,177452,177701,177806,177935,178116,178156,178158,178234,178363,178391,178414,178470,178571,178603,178605,178608,178722,179095,179411,179538,179599,179766,179775,179792,179802,180026,180103,180276,180277,180363,180564,180583,180697,180730,180873,180902,180903,180904,180944,180949,180950,181095,181125,181242,181262,181263,181265,181379,181483,181485,181489,181491,181532,181575,181619,181703,181704,181707,181779,181782,181831,181838,181873,181920,181921,181989,182029,182190,182193,182202,182535,182536,182794,182821,182825,182946,183014,183127,183143,183309,183310,183673,183678,183679,183790,183835,184042,184213,184248,184251,184387,184497,184533,184638,184704,184837,185005,185053,185132,185134,185188,185193,185258,185266,185407,185606,185691,185751,185778,185809,185918,185919,185960,185962,186020,186076,186215,186338,186378,186379,186380,186460,186464,186504,186542,186546,186603,186627,186631,186633,186775,186803,186832,186903,186904,187078,187102,187234,187286,187601,187635,187721,187755,188138,188143,188174,188221,188269,188549,188617,188670,188820,188873,188902,188926,188931,188935,188988,189044,189188,189216,189269,189275,189345,189578,189708,189754,189780,189958,189971,190434,190729,190931,191051,191182,191215,191386,191442,191506,191658,191747,191891,191941,192024,192027,192069,192230,192242,192279,192302,192351,192420,192459,192513,192521,192560,192585,192745,192848,192892,192900,192903,193080,193161,193208,193222,193251,193453,193484,193539,193582,193600,193712,193780,193911,193928,193947,194073,194339,194407,194445,194610,194639,195650,195931,195944,196438,196505,196615,196644,196658,196916,197699,197803,197804) 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 (22550,22551,22552,22557,22566,22567,22581,22596,22602,22603,22752,22757,22764,22807,22987,23371,23374,23392,23394,23440,23443,23447,23448,23453,23454,23550,23612,23671,23675,23894,23899,24097,24692,25037,25153,25156,25248,25253,25366,25717,25736,25862,26129,26278,26285,26319,26357,26664,27446,27452,27489,28238,29620,29621,32374,32375,33155,33156,33486,34383,35019,35034,35052,35063,35098,35121,36207,36608,36609,38855,38856,42000,42591,43218,43322,43323,43960,44055,44723,46499,47594,49101,50339,50967,53808,54859,55369,55810,55827,55828,55846,55853,55949,55959,55968,55977,55986,55998,56113,56114,56129,56144,56145,56160,56175,56195,56196,56197,56207,56216,56217,56218,56383,56384,56749,56761,56769,56772,56886,57016,57026,57041,57066,57067,57081,57082,57272,57277,57278,57294,57368,57369,57370,57379,57387,57396,57496,57503,57637,57640,57652,57744,57745,57755,57795,58218,58234,58235,58259,58341,58343,58350,58542,58554,58568,58569,58608,58609,58610,58627,58628,58629,58639,58654,58655,58925,59029,59030,59394,59542,59550,59979,59980,59993,60275,60644,60744,60745,60787,60788,60789,60805,61005,61150,61162,61190,61442,61444,61547,61549,61664,62112,62159,62161,62255,62444,62827,63004,63014,63015,63109,63194,63738,63740,63776,64021,64032,64386,64392,64412,64413,64566,65145,65157,65221,65742,65747,65797,65827,66399,66404,67822,67919,67928,67951,69559,69626,70090,70097,70114,70116,70117,70291,70544,71087,71302,71928,72052,72581,72656,72868,72878,72899,73414,73422,73649,74201,74372,74375,74462,75046,75262,75846,75889,75893,76185,77420,78178,78180,78190,78214,78224,78295,78304,78305,78373,78382,78395,78396,78397,78398,78404,78405,78595,78607,80457,80914,80915,80928,80935,80937,81232,81477,81863,81872,81874,81907,81970,81987,81991,82002,82408,82428,82504,82524,82936,82945,82950,83034,83052,83075,83111,83262,83514,84105,84121,84781,85151,85163,85164,85335,85479,85741,85742,85987,86053,86054,86158,86380,86385,86387,86580,86584,86762,86826,86827,86890,87019,87163,87164,87251,87323,87338,87345,87879,87885,88035,88038,88042,88454,88938,89115,89474,89629,90138,90140,90739,91032,91039,91040,91049,91057,91759,91865,92722,92724,92725,92740,92887,92888,93481,93523,93701,94541,95016,95081,95098,95148,95161,95575,95692,95695,95817,95896,95899,96026,96027,97818,97861,97862,98068,98188,98411,98412,98413,98721,98981,99274,99450,100317,100540,100552,100794,100877,101209,101349,101500,101725,101740,101834,102154,102191,102202,102328,102383,102409,102415,102641,102754,102755,102989,102991,103090,103245,103258,103775,103863,104014,104194,104195,104196,104198,104772,104920,104921,104922,105286,105297,105312,105598,105692,105693,105757,105790,105908,106474,106572,106618,106684,106795,106885,106901,106903,106912,107042,107063,107129,107130,107134,107246,107262,107263,107372,107521,108031,108042,108043,108096,108097,108113,108114,108115,108116,108117,108142,108224,108500,108530,108532,108553,108554,108707,108711,108821,108823,108829,109002,109052,109207,109543,109585,109589,109594,109746,109895,109896,109952,110210,110214,110228,110234,110238,110239,110240,110243,110252,110259,110266,110273,110313,110314,110315,110316,110523,110565,110566,110747,110890,111003,111005,111016,111107,111223,111262,111647,111723,112520,112522,112621,112766,112799,112827,112884,113151,113207,113314,113578,113593,113629,113773,113861,113862,113863,113866,114118,114225,114228,114234,114286,114485,114488,114534,114540,114724,114726,114791,114796,114818,114824,114829,114833,114983,114994,114996,114997,115035,115075,115169,115177,115247,115248,115319,115481,115495,115496,115497,115504,115505,115506,115507,115508,115509,115510,115519,115722,116085,116093,116155,116165,116214,116328,116333,116334,116345,116378,116422,116487,116511,116513,116514,116515,116531,116535,116779,116782,116927,116941,116942,116967,117140,117143,117217,117297,117298,117302,117329,117370,117457,117514,117518,117521,117566,117653,117664,117773,117836,117933,117934,117978,117983,117990,118064,118091,118297,118375,118418,118435,118519,118707,118787,119026,119044,119107,119119,119200,119245,119317,120566,120577,120578,120636,120652,120653,120671,120672,120673,120682,120683,120903,121004,121005,121006,121007,121015,121016,121017,121018,121050,121051,121064,121065,121066,121067,121081,121082,121099,121100,121101,121325,121333,121351,121373,121374,121383,121384,121385,121586,121640,121647,121655,121678,121679,121703,121704,121705,121706,121707,121754,121852,121951,121956,121957,121960,121961,122038,122042,122053,122153,122188,122328,122351,122360,122435,122440,122441,122442,122476,122486,122701,122708,122922,123390,123392,123395,123396,123397,123645,123690,123691,123736,123754,123797,123871,123876,123981,123983,124041,124109,124122,124229,124234,124303,124336,125310,125338,125393,125600,125617,125776,125777,125848,125851,125901,125916,125976,125983,126050,126173,126428,126522,126632,126690,126730,126759,126769,126774,126801,126813,126885,126925,126927,126938,126990,127002,127260,127382,127393,127429,127456,127480,127499,127614,127616,127678,127816,127826,128022,128042,128145,128323,128327,128331,128373,128466,128472,128475,128482,128490,128512,128652,128653,128765,128795,128814,128896,128980,128997,129007,129008,129020,129036,129074,129121,129154,129176,129320,129327,129393,129616,130165,130961,130962,131076,131334,131869,132052,132101,132149,132234,132251,132289,132304,132395,132397,132438,132536,132677,132680,132681,132683,132833,132941,132975,133371,133372,133373,133507,133682,133697,133727,133882,134189,134506,134583,135099,135182,135658,135797,135869,136606,136611,136612,136640,136641,136642,136643,136644,136953,136963,136967,137056,137067,137068,137074,137079,137166,137232,137251,137252,137359,137373,137378,137453,137461,137467,137650,137659,137661,137760,137771,137776,137783,137784,137864,137944,138007,138010,138012,138035,138042,138046,138048,138051,138052,138053,138059,138062,138176,138182,138192,138200,138436,138588,138601,138611,138613,138628,138629,138632,138635,138728,138738,138739,138750,138761,139206,139257,139346,139659,139660,139696,139698,139723,139725,139727,139736,139737,139741,139750,140209,140422,140647,140758,141029,141031,141077,141087,141210,141229,141316,141328,141415,141429,141436,141617,141739,142008,142136,142138,142190,142321,142322,142400,142473,142485,142489,142498,142511,142556,142567,142657,142745,142831,142854,142913,142918,143309,143326,143350,143412,143413,143414,143467,143638,143643,143660,143719,143732,143825,143879,143884,143886,143953,143966,143967,143968,144470,144492,144701,144718,144783,144784,144899,144915,144953,145001,145028,145054,145178,145257,145264,145275,145279,145285,145290,145296,145352,145355,145395,145482,145483,145498,145643,145644,145650,145740,145741,145742,145743,145744,145751,145752,145753,145754,145755,145756,145789,145790,145791,145804,145805,145806,145807,145819,145820,145976,145997,146024,146232,146303,146381,146451,146468,146469,146480,146500,146592,146594,146675,146684,146689,146760,146761,146788,146876,146895,146926,146973,147019,147023,147025,147028,147029,147094,147186,147211,147223,147224,147237,147345,147346,147397,147482,147502,147505,147635,147691,147733,147845,147878,147929,147974,148003,148016,148058,148090,148091,148268,148270,148358,148366,148372,148379,148393,148394,148467,148513,148527,148667,148760,148807,148890,149037,149200,149260,149321,149442,149623,149697,149856,149974,150023,150110,150306,150357,150366,150441,150496,150824,150849,150957,150978,151062,151123,151231,151242,151276,151341,151420,151424,151426,151654,151701,151828,151900,151966,151967,151998,151999,152609,152756,152806,153065,153066,153345,153386,153412,153413,153418,153511,153534,153539,153571,153577,153652,153661,153861,153887,153892,153893,153895,153981,153988,153990,153998,154040,154041,154098,154123,154124,154155,154166,154248,154249,154352,154356,154357,154378,154565,154731,154744,154750,154751,154752,154753,154762,154859,154938,155122,155157,155411,155418,155528,155804,156392,156493,156735,156879,157031,157150,157158,157283,157288,157289,157290,157302,157317,157318,157319,157320,157327,157328,157329,157330,157331,157345,157507,157568,157623,157643,157764,157909,157950,158032,158137,158194,158196,158197,158310,158435,158455,158456,158457,159154,159344,159424,159428,159505,159534,159548,159593,159744,159804,160015,160016,160145,160146,160547,161682,162511,162647,163170,163268,163280,163559,163687,163873,164042,164613,164667,164725,164930,165079,165092,165185,165300,165311,165320,165321,165322,165428,165429,165591,165720,165741,165976,165980,165983,166031,166129,166227,166295,166450,166451,166452,166467,166471,166472,166473,166474,166488,166489,166490,166500,166536,166545,166559,166632,166633,166655,166667,166696,166697,166722,166723,166762,166763,166764,166777,166778,166798,166799,166800,166922,166934,167034,167035,167081,167133,167142,167143,167241,167369,167421,167448,167495,167841,167895,168141,168144,168254,168256,168265,168266,168285,168323,168331,168335,168336,168361,168367,168437,168438,168482,168537,168614,168722,168833,168903,168932,169023,169136,169140,169143,169184,169244,169301,169335,169379,169413,169487,169518,169532,169630,169755,169820,169887,169894,169923,170019,170107,170336,170408,170414,170496,170516,170583,170686,170700,170701,170910,171060,171091,171141,171226,171374,171429,171522,171745,171774,172122,172284,172323,172367,172368,172447,172453,172598,172686,172840,172865,172882,172917,172919,172927,172928,172976,172982,172984,173055,173080,173145,173174,173232,173349,173351,173378,173609,173642,173695,173800,173902,174066,174085,174178,174213,174238,174247,174383,174540,174850,174993,175229,175294,175327,175347,175406,175431,175515,175530,175534,175563,175661,175667,175777,175797,175799,175831,176252,176256,176258,176314,176389,176484,176778,177013,177014,177027,177118,177452,177701,177806,177935,178116,178156,178158,178234,178363,178391,178414,178470,178571,178603,178605,178608,178722,179095,179411,179538,179599,179766,179775,179792,179802,180026,180103,180276,180277,180363,180564,180583,180697,180730,180873,180902,180903,180904,180944,180949,180950,181095,181125,181242,181262,181263,181265,181379,181483,181485,181489,181491,181532,181575,181619,181703,181704,181707,181779,181782,181831,181838,181873,181920,181921,181989,182029,182190,182193,182202,182535,182536,182794,182821,182825,182946,183014,183127,183143,183309,183310,183673,183678,183679,183790,183835,184042,184213,184248,184251,184387,184497,184533,184638,184704,184837,185005,185053,185132,185134,185188,185193,185258,185266,185407,185606,185691,185751,185778,185809,185918,185919,185960,185962,186020,186076,186215,186338,186378,186379,186380,186460,186464,186504,186542,186546,186603,186627,186631,186633,186775,186803,186832,186903,186904,187078,187102,187234,187286,187601,187635,187721,187755,188138,188143,188174,188221,188269,188549,188617,188670,188820,188873,188902,188926,188931,188935,188988,189044,189188,189216,189269,189275,189345,189578,189708,189754,189780,189958,189971,190434,190729,190931,191051,191182,191215,191386,191442,191506,191658,191747,191891,191941,192024,192027,192069,192230,192242,192279,192302,192351,192420,192459,192513,192521,192560,192585,192745,192848,192892,192900,192903,193080,193161,193208,193222,193251,193453,193484,193539,193582,193600,193712,193780,193911,193928,193947,194073,194339,194407,194445,194610,194639,195650,195931,195944,196438,196505,196615,196644,196658,196916,197699,197803,197804) GROUP BY sold_month ORDER BY scs.date_actual_sold |
79 | Creole | executeQuery(): [49.61 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 (22550,22551,22552,22557,22566,22567,22581,22596,22602,22603,22752,22757,22764,22807,22987,23371,23374,23392,23394,23440,23443,23447,23448,23453,23454,23550,23612,23671,23675,23894,23899,24097,24692,25037,25153,25156,25248,25253,25366,25717,25736,25862,26129,26278,26285,26319,26357,26664,27446,27452,27489,28238,29620,29621,32374,32375,33155,33156,33486,34383,35019,35034,35052,35063,35098,35121,36207,36608,36609,38855,38856,42000,42591,43218,43322,43323,43960,44055,44723,46499,47594,49101,50339,50967,53808,54859,55369,55810,55827,55828,55846,55853,55949,55959,55968,55977,55986,55998,56113,56114,56129,56144,56145,56160,56175,56195,56196,56197,56207,56216,56217,56218,56383,56384,56749,56761,56769,56772,56886,57016,57026,57041,57066,57067,57081,57082,57272,57277,57278,57294,57368,57369,57370,57379,57387,57396,57496,57503,57637,57640,57652,57744,57745,57755,57795,58218,58234,58235,58259,58341,58343,58350,58542,58554,58568,58569,58608,58609,58610,58627,58628,58629,58639,58654,58655,58925,59029,59030,59394,59542,59550,59979,59980,59993,60275,60644,60744,60745,60787,60788,60789,60805,61005,61150,61162,61190,61442,61444,61547,61549,61664,62112,62159,62161,62255,62444,62827,63004,63014,63015,63109,63194,63738,63740,63776,64021,64032,64386,64392,64412,64413,64566,65145,65157,65221,65742,65747,65797,65827,66399,66404,67822,67919,67928,67951,69559,69626,70090,70097,70114,70116,70117,70291,70544,71087,71302,71928,72052,72581,72656,72868,72878,72899,73414,73422,73649,74201,74372,74375,74462,75046,75262,75846,75889,75893,76185,77420,78178,78180,78190,78214,78224,78295,78304,78305,78373,78382,78395,78396,78397,78398,78404,78405,78595,78607,80457,80914,80915,80928,80935,80937,81232,81477,81863,81872,81874,81907,81970,81987,81991,82002,82408,82428,82504,82524,82936,82945,82950,83034,83052,83075,83111,83262,83514,84105,84121,84781,85151,85163,85164,85335,85479,85741,85742,85987,86053,86054,86158,86380,86385,86387,86580,86584,86762,86826,86827,86890,87019,87163,87164,87251,87323,87338,87345,87879,87885,88035,88038,88042,88454,88938,89115,89474,89629,90138,90140,90739,91032,91039,91040,91049,91057,91759,91865,92722,92724,92725,92740,92887,92888,93481,93523,93701,94541,95016,95081,95098,95148,95161,95575,95692,95695,95817,95896,95899,96026,96027,97818,97861,97862,98068,98188,98411,98412,98413,98721,98981,99274,99450,100317,100540,100552,100794,100877,101209,101349,101500,101725,101740,101834,102154,102191,102202,102328,102383,102409,102415,102641,102754,102755,102989,102991,103090,103245,103258,103775,103863,104014,104194,104195,104196,104198,104772,104920,104921,104922,105286,105297,105312,105598,105692,105693,105757,105790,105908,106474,106572,106618,106684,106795,106885,106901,106903,106912,107042,107063,107129,107130,107134,107246,107262,107263,107372,107521,108031,108042,108043,108096,108097,108113,108114,108115,108116,108117,108142,108224,108500,108530,108532,108553,108554,108707,108711,108821,108823,108829,109002,109052,109207,109543,109585,109589,109594,109746,109895,109896,109952,110210,110214,110228,110234,110238,110239,110240,110243,110252,110259,110266,110273,110313,110314,110315,110316,110523,110565,110566,110747,110890,111003,111005,111016,111107,111223,111262,111647,111723,112520,112522,112621,112766,112799,112827,112884,113151,113207,113314,113578,113593,113629,113773,113861,113862,113863,113866,114118,114225,114228,114234,114286,114485,114488,114534,114540,114724,114726,114791,114796,114818,114824,114829,114833,114983,114994,114996,114997,115035,115075,115169,115177,115247,115248,115319,115481,115495,115496,115497,115504,115505,115506,115507,115508,115509,115510,115519,115722,116085,116093,116155,116165,116214,116328,116333,116334,116345,116378,116422,116487,116511,116513,116514,116515,116531,116535,116779,116782,116927,116941,116942,116967,117140,117143,117217,117297,117298,117302,117329,117370,117457,117514,117518,117521,117566,117653,117664,117773,117836,117933,117934,117978,117983,117990,118064,118091,118297,118375,118418,118435,118519,118707,118787,119026,119044,119107,119119,119200,119245,119317,120566,120577,120578,120636,120652,120653,120671,120672,120673,120682,120683,120903,121004,121005,121006,121007,121015,121016,121017,121018,121050,121051,121064,121065,121066,121067,121081,121082,121099,121100,121101,121325,121333,121351,121373,121374,121383,121384,121385,121586,121640,121647,121655,121678,121679,121703,121704,121705,121706,121707,121754,121852,121951,121956,121957,121960,121961,122038,122042,122053,122153,122188,122328,122351,122360,122435,122440,122441,122442,122476,122486,122701,122708,122922,123390,123392,123395,123396,123397,123645,123690,123691,123736,123754,123797,123871,123876,123981,123983,124041,124109,124122,124229,124234,124303,124336,125310,125338,125393,125600,125617,125776,125777,125848,125851,125901,125916,125976,125983,126050,126173,126428,126522,126632,126690,126730,126759,126769,126774,126801,126813,126885,126925,126927,126938,126990,127002,127260,127382,127393,127429,127456,127480,127499,127614,127616,127678,127816,127826,128022,128042,128145,128323,128327,128331,128373,128466,128472,128475,128482,128490,128512,128652,128653,128765,128795,128814,128896,128980,128997,129007,129008,129020,129036,129074,129121,129154,129176,129320,129327,129393,129616,130165,130961,130962,131076,131334,131869,132052,132101,132149,132234,132251,132289,132304,132395,132397,132438,132536,132677,132680,132681,132683,132833,132941,132975,133371,133372,133373,133507,133682,133697,133727,133882,134189,134506,134583,135099,135182,135658,135797,135869,136606,136611,136612,136640,136641,136642,136643,136644,136953,136963,136967,137056,137067,137068,137074,137079,137166,137232,137251,137252,137359,137373,137378,137453,137461,137467,137650,137659,137661,137760,137771,137776,137783,137784,137864,137944,138007,138010,138012,138035,138042,138046,138048,138051,138052,138053,138059,138062,138176,138182,138192,138200,138436,138588,138601,138611,138613,138628,138629,138632,138635,138728,138738,138739,138750,138761,139206,139257,139346,139659,139660,139696,139698,139723,139725,139727,139736,139737,139741,139750,140209,140422,140647,140758,141029,141031,141077,141087,141210,141229,141316,141328,141415,141429,141436,141617,141739,142008,142136,142138,142190,142321,142322,142400,142473,142485,142489,142498,142511,142556,142567,142657,142745,142831,142854,142913,142918,143309,143326,143350,143412,143413,143414,143467,143638,143643,143660,143719,143732,143825,143879,143884,143886,143953,143966,143967,143968,144470,144492,144701,144718,144783,144784,144899,144915,144953,145001,145028,145054,145178,145257,145264,145275,145279,145285,145290,145296,145352,145355,145395,145482,145483,145498,145643,145644,145650,145740,145741,145742,145743,145744,145751,145752,145753,145754,145755,145756,145789,145790,145791,145804,145805,145806,145807,145819,145820,145976,145997,146024,146232,146303,146381,146451,146468,146469,146480,146500,146592,146594,146675,146684,146689,146760,146761,146788,146876,146895,146926,146973,147019,147023,147025,147028,147029,147094,147186,147211,147223,147224,147237,147345,147346,147397,147482,147502,147505,147635,147691,147733,147845,147878,147929,147974,148003,148016,148058,148090,148091,148268,148270,148358,148366,148372,148379,148393,148394,148467,148513,148527,148667,148760,148807,148890,149037,149200,149260,149321,149442,149623,149697,149856,149974,150023,150110,150306,150357,150366,150441,150496,150824,150849,150957,150978,151062,151123,151231,151242,151276,151341,151420,151424,151426,151654,151701,151828,151900,151966,151967,151998,151999,152609,152756,152806,153065,153066,153345,153386,153412,153413,153418,153511,153534,153539,153571,153577,153652,153661,153861,153887,153892,153893,153895,153981,153988,153990,153998,154040,154041,154098,154123,154124,154155,154166,154248,154249,154352,154356,154357,154378,154565,154731,154744,154750,154751,154752,154753,154762,154859,154938,155122,155157,155411,155418,155528,155804,156392,156493,156735,156879,157031,157150,157158,157283,157288,157289,157290,157302,157317,157318,157319,157320,157327,157328,157329,157330,157331,157345,157507,157568,157623,157643,157764,157909,157950,158032,158137,158194,158196,158197,158310,158435,158455,158456,158457,159154,159344,159424,159428,159505,159534,159548,159593,159744,159804,160015,160016,160145,160146,160547,161682,162511,162647,163170,163268,163280,163559,163687,163873,164042,164613,164667,164725,164930,165079,165092,165185,165300,165311,165320,165321,165322,165428,165429,165591,165720,165741,165976,165980,165983,166031,166129,166227,166295,166450,166451,166452,166467,166471,166472,166473,166474,166488,166489,166490,166500,166536,166545,166559,166632,166633,166655,166667,166696,166697,166722,166723,166762,166763,166764,166777,166778,166798,166799,166800,166922,166934,167034,167035,167081,167133,167142,167143,167241,167369,167421,167448,167495,167841,167895,168141,168144,168254,168256,168265,168266,168285,168323,168331,168335,168336,168361,168367,168437,168438,168482,168537,168614,168722,168833,168903,168932,169023,169136,169140,169143,169184,169244,169301,169335,169379,169413,169487,169518,169532,169630,169755,169820,169887,169894,169923,170019,170107,170336,170408,170414,170496,170516,170583,170686,170700,170701,170910,171060,171091,171141,171226,171374,171429,171522,171745,171774,172122,172284,172323,172367,172368,172447,172453,172598,172686,172840,172865,172882,172917,172919,172927,172928,172976,172982,172984,173055,173080,173145,173174,173232,173349,173351,173378,173609,173642,173695,173800,173902,174066,174085,174178,174213,174238,174247,174383,174540,174850,174993,175229,175294,175327,175347,175406,175431,175515,175530,175534,175563,175661,175667,175777,175797,175799,175831,176252,176256,176258,176314,176389,176484,176778,177013,177014,177027,177118,177452,177701,177806,177935,178116,178156,178158,178234,178363,178391,178414,178470,178571,178603,178605,178608,178722,179095,179411,179538,179599,179766,179775,179792,179802,180026,180103,180276,180277,180363,180564,180583,180697,180730,180873,180902,180903,180904,180944,180949,180950,181095,181125,181242,181262,181263,181265,181379,181483,181485,181489,181491,181532,181575,181619,181703,181704,181707,181779,181782,181831,181838,181873,181920,181921,181989,182029,182190,182193,182202,182535,182536,182794,182821,182825,182946,183014,183127,183143,183309,183310,183673,183678,183679,183790,183835,184042,184213,184248,184251,184387,184497,184533,184638,184704,184837,185005,185053,185132,185134,185188,185193,185258,185266,185407,185606,185691,185751,185778,185809,185918,185919,185960,185962,186020,186076,186215,186338,186378,186379,186380,186460,186464,186504,186542,186546,186603,186627,186631,186633,186775,186803,186832,186903,186904,187078,187102,187234,187286,187601,187635,187721,187755,188138,188143,188174,188221,188269,188549,188617,188670,188820,188873,188902,188926,188931,188935,188988,189044,189188,189216,189269,189275,189345,189578,189708,189754,189780,189958,189971,190434,190729,190931,191051,191182,191215,191386,191442,191506,191658,191747,191891,191941,192024,192027,192069,192230,192242,192279,192302,192351,192420,192459,192513,192521,192560,192585,192745,192848,192892,192900,192903,193080,193161,193208,193222,193251,193453,193484,193539,193582,193600,193712,193780,193911,193928,193947,194073,194339,194407,194445,194610,194639,195650,195931,195944,196438,196505,196615,196644,196658,196916,197699,197803,197804) 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(): [4758.34 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(): [1.49 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=200012 |
108 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
109 | Creole | executeQuery(): [0.70 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199860 |
110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
111 | Creole | executeQuery(): [0.94 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199834 |
112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
113 | Creole | executeQuery(): [0.59 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199776 |
114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
115 | Creole | executeQuery(): [2.74 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199757 |
116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
117 | Creole | executeQuery(): [3.59 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=173392 |
118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
119 | Creole | executeQuery(): [16.80 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=173391 |
120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
121 | Creole | executeQuery(): [16.52 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=173390 |
122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
123 | Creole | executeQuery(): [3.68 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=173389 |
124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
125 | Creole | executeQuery(): [9.30 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=173388 |
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 |
--- parameterHolder: symfony/default: ID_AD: 173387 action: view id: 173387 make: chevrolet model: chevelle module: home attributeHolder: symfony/default: HOME_LINK: <a title="cap_na_default_title_3" href="https://www.classicdigest.com/cars/index_dev.php">Classic Cars</a> base_domain: .classicdigest.com display_que_ans_setction: Y show_cookie_policy: 1
--- cookies: httpHeaders: Content-Type: text/html; charset=utf-8 parameterHolder: helper/asset/auto/httpmeta: Content-Type: text/html; charset=utf-8 helper/asset/auto/javascript: /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main helper/asset/auto/meta: author: Fiare description: Netiauto - Osta tai Myy vaihtoautot- Kauppa käy keywords: auto, autot, vaihtoautot, vaihtoauto, vaihtoautoliike, bensa, polttoaine, käytetyt, netiauto, osta, myy, käytetty, etsi, haku, ilmastointi, stereot, amatööri, moottori, katsastus, kesäauto, automaatti, kova, halpa, halvalla, kone, hyvä, nopea, ilmainen, ilmaiseksi, second hand, used, car, cars, hot, fast, good, cheap language: et,Estonian,ru,russia,fi,soumeksi,en,English other: Mach1 Oy:n kehittämä vaihtoautosivusto. netiauto.ee on sivusto yksityisille ilmoittajille sekä autoliikkeille. netiauto.ee:issa on erittäin monipuoliset hakutoiminnot, jotka helpottavat vaihtoautoa etsivää. revisit-after: 15 days robots: follow,index title: Netiauto - Osta tai Myy vaihtoautot- Kauppa käy helper/asset/auto/stylesheet: /sf/sf_web_debug/css/main: symfony/action/view: home_view_layout: view_layout symfony/response/http/headers: Content-Type: text/html; charset=utf-8 symfony/view/asset: javascripts_included: stylesheets_included:
--- app_params_adbox_slot: 6 app_params_image_limit: 25 app_params_pdf_limit: 1 app_params_site: Classic Cars app_params_tot_limit_na: 50 app_params_tot_per_month_limit: 50 app_params_web_master: administrator@classicdigest.com app_params_www: www.classicdigest.com/cars app_url_na: https://www.classicdigest.com/cars/index_dev.php app_url_nm: https://www.classicdigest.com/motorcycles/index_dev.php app_url_site_url: https://www.classicdigest.com/cars/index_dev.php css_jquery_ui_custom: jquery-ui-1.8.23.custom.min.css css_jsquares: jsquares.min.css css_responsive: responsive.min.css css_style: style.min.css homepage_sms_slots: 12 html_direction: ltr html_left: left html_right: right jquery_url: https://ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js js_banner: banner.min.js js_common: common.min.js js_effects: effects.js js_html5_printshiv: html5shiv-printshiv.min.js js_html5shiv: html5shiv.min.js js_jsquares: mosiac/jquery.jsquares.min.js js_lazy: lazyload/jquery.lazy.min.js js_netiauto: netiauto js_prototype: prototype.js js_slider: slider.min.js mod_home_enabled: 1 mod_home_is_internal: mod_home_view_class: sfPHP quick_search_max_price: 10000000 quick_search_min_price: 0 sf_admin_web_dir: /sf/sf_admin sf_app: cars sf_app_config_dir: /web/classicdigest.com/apps/cars/config sf_app_config_dir_name: config sf_app_dir: /web/classicdigest.com/apps/cars sf_app_i18n_dir: /web/classicdigest.com/lib/i18n sf_app_i18n_dir_name: i18n sf_app_lib_dir: /web/classicdigest.com/apps/cars/lib sf_app_lib_dir_name: lib sf_app_module_action_dir_name: actions sf_app_module_config_dir_name: config sf_app_module_dir: /web/classicdigest.com/apps/cars/modules sf_app_module_dir_name: modules sf_app_module_i18n_dir_name: i18n sf_app_module_lib_dir_name: lib sf_app_module_template_dir_name: templates sf_app_module_validate_dir_name: validate sf_app_module_view_dir_name: views sf_app_template_dir: /web/classicdigest.com/apps/cars/templates sf_app_template_dir_name: templates sf_apps_dir_name: apps sf_autoloading_functions: sf_available: 1 sf_base_cache_dir: /web/classicdigest.com/cache/cars sf_bin_dir: /web/classicdigest.com/batch sf_bin_dir_name: batch sf_cache: 1 sf_cache_dir: /web/classicdigest.com/cache/cars/dev sf_cache_dir_name: cache sf_calendar_web_dir: /sf/calendar sf_charset: utf-8 sf_check_lock: sf_check_symfony_version: sf_compressed: sf_config_cache_dir: /web/classicdigest.com/cache/cars/dev/config sf_config_dir: /web/classicdigest.com/config sf_config_dir_name: config sf_data_dir: /web/classicdigest.com/data sf_data_dir_name: data sf_debug: 1 sf_default_action: index sf_default_module: default sf_doc_dir: /web/classicdigest.com/data/doc sf_doc_dir_name: doc sf_enabled_modules: - default - user - faSms - user_mail - faDealer - dealer_person - statistics - vote - faErrors - feedback - sfTCPDF - static - article - news - que_ans - favorite - category - sfCaptchaGD - service_index - club - sfLightboxPlugin - sfPropelNorthIdPlugin - facebook - tag_cloud - adbox - apijson - findAgent - fb_connect - fbGeneral sf_environment: dev sf_error_404_action: error404 sf_error_404_module: faErrors sf_error_reporting: 2037 sf_escaping_method: ESC_ENTITIES sf_escaping_strategy: bc sf_etag: sf_i18n: 1 sf_i18n_cache: 1 sf_i18n_cache_dir: /web/classicdigest.com/cache/cars/dev/i18n sf_i18n_debug: sf_i18n_default_culture: en sf_i18n_source: gettext sf_i18n_untranslated_prefix: [T] sf_i18n_untranslated_suffix: [/T] sf_lazy_cache_key: sf_lib_dir: /web/classicdigest.com/lib sf_lib_dir_name: lib sf_lightbox_css_dir: https://www.classicdigest.com/entity/css/sfLightboxPlugin/ sf_lightbox_images_dir: https://www.classicdigest.com/entity/images/sfLightboxPlugin/ sf_lightbox_js_dir: https://www.classicdigest.com/entity/js/sfLightboxPlugin/ sf_log_dir: /web/classicdigest.com/log sf_log_dir_name: log sf_logging_enabled: 1 sf_logging_history: 10 sf_logging_level: debug sf_logging_period: 7 sf_logging_purge: 1 sf_logging_rotate: sf_login_action: loginRequired sf_login_module: faErrors sf_max_forwards: 5 sf_model_dir_name: model sf_model_lib_dir: /web/classicdigest.com/lib/model sf_module_cache_dir: /web/classicdigest.com/cache/cars/dev/modules sf_module_disabled_action: disabled sf_module_disabled_module: default sf_no_script_name: sf_orm: propel sf_path_info_array: SERVER sf_path_info_key: PATH_INFO sf_plugins_dir: /web/classicdigest.com/plugins sf_plugins_dir_name: plugins sf_prototype_web_dir: /sf/prototype sf_rich_text_js_dir: js/tiny_mce sf_root_cache_dir: /web/classicdigest.com/cache sf_root_dir: /web/classicdigest.com sf_routing_defaults: sf_culture: en sf_secure_action: secure sf_secure_module: default sf_standard_helpers: - Partial - Cache - Form - Date - faNettiX - faClient - Javascript - Validation - Object - Lightbox sf_strip_comments: 1 sf_suffix: . sf_symfony_data_dir: /web/clssymfony/data sf_symfony_lib_dir: /web/clssymfony/lib sf_template_cache_dir: /web/classicdigest.com/cache/cars/dev/template sf_test: sf_test_cache_dir: /web/classicdigest.com/cache/cars/dev/test sf_test_dir: /web/classicdigest.com/test sf_test_dir_name: test sf_timeout: 1800 sf_timer_start: 1735061698.4266 sf_unavailable_action: maintenance sf_unavailable_module: util sf_upload_dir: /web/classicdigest.com/web/uploads sf_upload_dir_name: uploads sf_url_format: PATH sf_use_database: 1 sf_use_flash: 1 sf_use_process_cache: 1 sf_use_security: 1 sf_validation_error_class: form_error sf_validation_error_id_prefix: error_for_ sf_validation_error_prefix: sf_validation_error_suffix: sf_web_debug: 1 sf_web_debug_web_dir: /sf/sf_web_debug sf_web_dir: /web/classicdigest.com/web sf_web_dir_name: web
--- cookie: env: files: get: post: server: CONTENT_LENGTH: CONTENT_TYPE: DOCUMENT_ROOT: /web/classicdigest.com/web DOCUMENT_URI: /cars/index_dev.php/chevrolet/chevelle/173387 FCGI_ROLE: RESPONDER GATEWAY_INTERFACE: CGI/1.1 HOME: /var/lib/nginx HTTPS: on HTTP_ACCEPT: */* HTTP_ACCEPT_ENCODING: gzip, br, zstd, deflate HTTP_HOST: www.classicdigest.com HTTP_REFERER: https://classicdigest.com/cars/index_dev.php/chevrolet/chevelle/173387 HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) PATH_INFO: /chevrolet/chevelle/173387 PATH_TRANSLATED: /web/classicdigest.com/web/chevrolet/chevelle/173387 PHP_SELF: /cars/index_dev.php/chevrolet/chevelle/173387 QUERY_STRING: REDIRECT_STATUS: 200 REMOTE_ADDR: 3.147.51.72 REMOTE_PORT: 56012 REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1735061698 REQUEST_TIME_FLOAT: 1735061698.4253 REQUEST_URI: /cars/index_dev.php/chevrolet/chevelle/173387 SCRIPT_FILENAME: /web/classicdigest.com/web/cars/index_dev.php SCRIPT_NAME: /cars/index_dev.php SERVER_ADDR: 10.8.1.209 SERVER_NAME: www.classicdigest.com SERVER_PORT: 443 SERVER_PROTOCOL: HTTP/1.1 SERVER_SOFTWARE: nginx/1.18.0 USER: nginx session: visit_page: - home/view
--- php: 7.2.34 os: Linux classicdigestprod1 4.14.336-179.559.amzn1.x86_64 #1 SMP Tue Feb 13 10:34:24 UTC 2024 x86_64 extensions: - Core - date - libxml - openssl - pcre - zlib - filter - hash - Reflection - SPL - session - standard - cgi-fcgi - bz2 - calendar - ctype - curl - dom - mbstring - fileinfo - ftp - gd - gettext - iconv - json - exif - mysqlnd - PDO - Phar - posix - shmop - SimpleXML - sockets - sqlite3 - sysvmsg - sysvsem - sysvshm - tokenizer - xml - xmlwriter - xsl - zip - mcrypt - mysqli - pdo_mysql - pdo_sqlite - wddx - xmlreader - memcache
type | calls | time (ms) |
---|---|---|
Configuration | 13 | 1.60 |
Action "home/view" | 1 | 5216.50 |
Database | 34 | 5198.78 |
View "Success" for "home/view" | 1 | 105.47 |
Partial "home/_vif_images" | 1 | 0.52 |
Partial "common_page/_social_buttons" | 1 | 0.08 |
Partial "home/_vif_info" | 1 | 0.15 |
Partial "home/_hoover_user_info" | 1 | 0.06 |
Partial "common_page/_price_development_graph" | 1 | 0.05 |
Partial "common_page/_sell_time_price_graph" | 1 | 0.04 |
Partial "common_page/_price_gauge_graph" | 1 | 0.04 |
Partial "common_page/_include_vif_js" | 1 | 0.07 |
Partial "common_page/_fancybox_javascript" | 2 | 0.16 |
Partial "common_page/_responsive_javascript" | 1 | 0.07 |
Partial "common_page/_google_analytics" | 1 | 0.04 |
Partial "common_page/_header_links" | 1 | 0.67 |
Partial "common_page/_cookie_policy" | 1 | 0.07 |
Partial "common_page/_responsive_top_menu" | 1 | 0.12 |
Partial "common_page/_top_menu" | 1 | 0.12 |
Partial "common_page/_footer_javascript" | 1 | 0.10 |
Partial "common_page/_footer" | 1 | 0.11 |