People who viewed this Ford Thunderbird also viewed similar Ford 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' => 'ford', 'model' => 'thunderbird', 'id' => '199668', 'module' => 'home', 'action' => 'view',) |
6 | Routing | connect "/sf_cache_partial/:module/:action/:sf_cache_key" |
7 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
8 | Creole | prepareStatement(): SET time_zone = '+01:00' |
9 | Creole | executeUpdate(): SET time_zone = '+01:00' |
10 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
11 | Creole | prepareStatement(): SET time_zone = '+01:00' |
12 | Creole | executeUpdate(): SET time_zone = '+01:00' |
13 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
14 | Creole | prepareStatement(): SET time_zone = '+01:00' |
15 | Creole | executeUpdate(): SET time_zone = '+01:00' |
16 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
17 | Creole | prepareStatement(): SET time_zone = '+01:00' |
18 | Creole | executeUpdate(): SET time_zone = '+01:00' |
19 | Creole | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
20 | Creole | prepareStatement(): SET time_zone = '+01:00' |
21 | Creole | executeUpdate(): SET time_zone = '+01:00' |
22 | Controller | dispatch request |
23 | Filter | executing filter "sfRenderingFilter" |
24 | Filter | executing filter "sfWebDebugFilter" |
25 | Filter | executing filter "sfCarViewFilter" |
26 | Filter | executing filter "naBreadcrumbFilter" |
27 | Filter | executing filter "sfCacheFilter" |
28 | Filter | executing filter "sfCommonFilter" |
29 | Filter | executing filter "sfFlashFilter" |
30 | Filter | executing filter "sfExecutionFilter" |
31 | Action | call "homeActions->executeView()" |
32 | Creole | prepareStatement(): SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, DATE_FORMAT(car.DATE_MODIFY,'%d.%m.%Y') AS DM, make.MAKE_EN AS MAKE, model.MODEL_EN AS MODEL, make.MAKE_EN AS MAKE_en, model.MODEL_EN AS MODEL_en, vehicle_type.VEHICLE_TYPE_EN AS VEHICLE_TYPE, car_type.CAR_TYPE_EN AS CAR_TYPE, color.COLOR_EN AS COLOR, color_type.COLOR_TYPE_EN AS COLOR_TYPE, car_stat.HIT_AD_INFO AS AD_HIT FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) LEFT JOIN make ON (car.ID_MAKE=make.ID) LEFT JOIN model ON (car.ID_MODEL=model.ID) LEFT JOIN vehicle_type ON (car.ID_VEHICLE_TYPE=vehicle_type.ID) LEFT JOIN car_type ON (car_info.ID_CAR_TYPE=car_type.ID) LEFT JOIN color ON (car_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (car_info.ID_COLOR_TYPE=color_type.ID) LEFT JOIN car_stat ON (car.ID=car_stat.ID_AD) WHERE car.ID=? AND car.STATUS=? |
33 | Creole | executeQuery(): [1.10 ms] SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_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=199668 AND car.STATUS='F' |
34 | Creole | prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?) |
35 | Creole | executeQuery(): [1.17 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 (901) |
36 | Creole | prepareStatement(): SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, DATE_ADD(car.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) WHERE car.ID=? |
37 | Creole | executeQuery(): [1.52 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=199668 |
38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
39 | Creole | executeQuery(): [0.91 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=199668 |
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(): [10.46 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=199668 |
42 | Creole | prepareStatement(): SELECT netti_dealer.ID_DEALER, netti_dealer.ID, netti_dealer.PATH, netti_dealer.COMPANY, netti_dealer.SLOGAN, netti_dealer.URL, netti_dealer.SIMPLE_URL, netti_dealer.HAS_SITE FROM netti_dealer WHERE netti_dealer.ID_DEALER IN (?) |
43 | Creole | executeQuery(): [0.85 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 (901) |
44 | Creole | prepareStatement(): SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=? AND fa_payment_order.PAYMENT_STATUS=? AND fa_payment_order.UPSELLS_TAKEN=? |
45 | Creole | executeQuery(): [0.45 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=199668 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2' |
46 | Creole | prepareStatement(): SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID=? |
47 | Creole | executeQuery(): [0.34 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 (199668) ORDER BY carimg.ORD ASC |
49 | Creole | executeQuery(): [0.57 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 (199668) ORDER BY carimg.ORD ASC |
50 | Creole | prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?) |
51 | Creole | executeQuery(): [0.82 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 (901) |
52 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
53 | Creole | executeQuery(): [0.63 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=901 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(): [1.00 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=63 AND model.ID=759 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 != 199668 AND car.ID_MODEL = '759' ) 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 != 199668 AND car.ID_MODEL = '759' ) 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 != 199668 AND car.ID_MODEL = '759' ) 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 != 199668 AND car.ID_MODEL = '759' ) ) AS count |
58 | Creole | executeQuery(): [4.50 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 != 199668 AND car.ID_MODEL = '759' ) 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 != 199668 AND car.ID_MODEL = '759' ) ) 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 != 199668 AND car.ID_MODEL = '759' ) 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 != 199668 AND car.ID_MODEL = '759' ) ORDER BY ID DESC, offset: 0, limit: 5 |
60 | Creole | executeQuery(): [8.09 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 != 199668 AND car.ID_MODEL = '759' ) 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 != 199668 AND car.ID_MODEL = '759' ) 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 (199699,199669,199651,199579,199505) ORDER BY carimg.ORD ASC |
62 | Creole | executeQuery(): [1.22 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 (199699,199669,199651,199579,199505) 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 != '199668' AND car.ID_NETTI_USER = '901' ) 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 != '199668' AND car.ID_NETTI_USER = '901' ) 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 != '199668' AND car.ID_NETTI_USER = '901' ) 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 != '199668' AND car.ID_NETTI_USER = '901' ) ) AS count |
65 | Creole | executeQuery(): [4.78 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 != '199668' AND car.ID_NETTI_USER = '901' ) 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 != '199668' AND car.ID_NETTI_USER = '901' ) ) 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 != '199668' AND car.ID_NETTI_USER = '901' ) 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 != '199668' AND car.ID_NETTI_USER = '901' ) ORDER BY ID DESC, offset: 0, limit: 5 |
67 | Creole | executeQuery(): [10.22 ms] ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.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 != '199668' AND car.ID_NETTI_USER = '901' ) 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 != '199668' AND car.ID_NETTI_USER = '901' ) 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 (199702,199624,199581,199504,199465) ORDER BY carimg.ORD ASC |
69 | Creole | executeQuery(): [0.66 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 (199702,199624,199581,199504,199465) 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(): [4.72 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=63 AND car.ID_MODEL=759 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(): [34.63 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=63 AND sold_car.ID_MODEL=759 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 (31615,44770,66987,90801,90838,105631,110181,110348,117946,129398,129980,132982,133216,135151,136266,140988,141273,141274,141460,143503,144558,145964,154783,154786,154791,154800,155175,155205,155206,155883,155884,156431,157068,157074,159394,159395,162636,166064,166082,166746,170198,170351,170521,170723,172384,172691,172756,173704,174844,174935,175508,176098,176120,176473,176563,176565,177509,177510,177550,177744,177757,177765,177776,177973,178176,178961,179127,179429,180617,180626,180654,181240,181778,183102,184089,184090,184580,185101,185136,185268,185536,185904,186669,186733,187193,187271,187413,187638,188287,188635,189003,189173,189310,189556,189698,191468,191593,192146,193246,193272,193770,193884,193976,194361,194368,194511,194662,194693,194775,194883,194889,194972,195051,195408,195411,195554,195597,195677,195891,195894,195929,195935,196234,196363,196583,196638,196786,196856,197047,197399,197435,197590,198184,198530,198613,198678,198816,198858,198867,199105,199140,199172,199197,199289,199466,199505,199579,199651,199668,199669,199699) GROUP BY cmonth ORDER BY date_create |
75 | Creole | executeQuery(): [2.27 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 (31615,44770,66987,90801,90838,105631,110181,110348,117946,129398,129980,132982,133216,135151,136266,140988,141273,141274,141460,143503,144558,145964,154783,154786,154791,154800,155175,155205,155206,155883,155884,156431,157068,157074,159394,159395,162636,166064,166082,166746,170198,170351,170521,170723,172384,172691,172756,173704,174844,174935,175508,176098,176120,176473,176563,176565,177509,177510,177550,177744,177757,177765,177776,177973,178176,178961,179127,179429,180617,180626,180654,181240,181778,183102,184089,184090,184580,185101,185136,185268,185536,185904,186669,186733,187193,187271,187413,187638,188287,188635,189003,189173,189310,189556,189698,191468,191593,192146,193246,193272,193770,193884,193976,194361,194368,194511,194662,194693,194775,194883,194889,194972,195051,195408,195411,195554,195597,195677,195891,195894,195929,195935,196234,196363,196583,196638,196786,196856,197047,197399,197435,197590,198184,198530,198613,198678,198816,198858,198867,199105,199140,199172,199197,199289,199466,199505,199579,199651,199668,199669,199699) 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 (20624,20625,20626,20853,21164,21235,21506,21970,22318,22539,22664,22703,22759,22782,23194,23195,23912,23913,24156,24301,24862,25152,25204,25402,25491,25771,26110,26120,26441,26443,27453,27743,27967,28037,28525,28865,28866,29444,29842,30152,30292,30393,30502,30657,32025,32491,32492,32961,34556,34793,35042,35053,35094,35096,35110,35124,35355,36120,36621,36948,42062,43300,43396,43796,43957,45498,46237,46338,46339,46490,46847,46848,47517,48603,48890,49712,51046,51886,52060,52641,53149,53278,54012,54253,55388,55458,55803,55982,56064,56065,56071,56473,56474,56475,56476,56477,56478,56479,56480,56481,56482,56483,56732,56852,56883,57354,57457,57718,57723,58175,58379,58508,58509,58510,58513,58514,58521,58664,58724,58788,58937,58975,59020,59024,59027,59069,59642,59976,60055,60274,60319,60653,60712,60717,60752,60771,60875,60908,61096,61465,61485,61850,62206,62340,62416,62417,63823,63933,64019,64034,65223,65497,65629,65633,66453,66651,66862,67712,67999,68510,69546,69604,70181,70512,70983,71813,71988,72626,72866,72971,73728,74200,74251,74531,74999,75045,75053,75121,75283,76156,76175,76613,76690,76716,77643,78340,78365,79701,81242,81977,82969,83040,83080,83269,83531,84104,84106,84235,84956,85156,85244,85963,86036,86240,86294,86392,86412,86515,86589,86770,87255,87286,88155,88714,89071,89082,89628,90294,90369,90370,90958,91045,91583,91734,92180,92218,92720,92935,93480,93772,94134,95131,95132,95248,95359,95983,96028,96073,96159,97888,97950,97951,98057,98189,98254,98384,98438,98826,99247,99329,100015,100038,100209,100225,100620,100783,100804,100807,101746,102153,102295,102341,102393,102633,103014,103218,103247,103250,103409,103583,103757,103833,104200,104791,104901,104911,105265,105278,105294,105348,105423,105431,105686,105754,105903,106356,106494,106566,106611,106774,106815,107108,107253,107338,107502,107513,108010,108017,108034,108364,108425,108899,109035,109038,109041,109045,109115,109248,109358,109567,109580,109691,109701,109723,109742,109973,110099,110216,110347,110947,111753,111754,111755,111756,112350,112532,112681,112879,112977,113072,113202,113214,113248,113387,113474,113666,113850,114108,114109,114520,114771,114772,114774,114799,115085,115155,115621,115622,115671,116275,116421,116553,116575,116636,116766,116787,117109,117288,117291,117292,117422,117646,117726,117745,117911,117966,117967,118212,118231,118305,118602,118814,119114,119204,119232,119355,119919,120179,120514,120515,120526,120527,120528,120547,120548,120552,120553,120876,120956,120963,120975,120983,120993,121194,121285,121290,121297,121298,121299,121469,121476,121613,121614,121617,121622,121623,121628,121652,122041,122138,122201,122253,122474,122807,122917,122920,123002,123043,123366,123403,123829,124063,124089,124200,124203,125328,125368,125432,125475,125501,125815,125830,125831,126061,126149,126262,126296,126336,126425,126426,126493,126513,126619,126655,126810,127013,127188,127236,127350,127354,127391,127559,127689,127916,127985,128013,128064,128157,128286,128377,128380,128537,128632,128650,128676,128757,128758,128873,129025,129086,129147,129273,129276,129342,130173,130373,130655,130936,131604,131683,131866,132065,132897,132995,132996,133610,133961,135004,135104,135212,135222,135677,135952,136000,136254,136682,136706,136913,136921,136933,136979,137168,137169,137203,137204,137205,137346,137434,137452,137599,137617,137734,137881,137945,137990,137992,137993,137994,137995,138080,138083,138159,138286,138419,138420,138451,138523,138527,138530,138532,138534,138541,138542,138569,138807,138970,138971,138972,138973,138974,138975,138976,138977,138978,138979,138980,138981,138982,139367,139389,140932,141026,141092,141099,141140,141334,141721,141880,142060,142099,142122,142156,142456,142458,142526,142554,142612,142613,142708,142846,143022,143256,143282,143321,143333,143482,143544,143545,143626,143631,143799,143800,143801,143820,143922,144015,144037,144082,144122,144183,144217,144261,144441,144486,144596,144767,144804,144858,144890,144898,144950,144991,145032,145033,145207,145208,145247,145253,145343,145361,145403,145601,145689,145718,145727,145963,146047,146122,146130,146131,146332,146433,146503,146598,147031,147737,147760,147978,148048,148105,148166,148181,148217,148218,148222,148365,148556,148577,148704,148970,149049,149076,149145,149154,149318,149380,149531,149544,149563,149611,149768,149968,150115,150192,150195,150199,150280,150359,150484,150493,150961,151072,151099,151101,151128,151435,151528,151573,152181,152545,152601,152789,153136,153285,153374,153380,153417,153447,153513,153600,153603,153607,153641,153685,153930,154069,154070,154141,154145,154329,154418,154426,154536,154934,155118,155243,155267,155339,155403,155598,155603,155635,155639,155711,156249,156275,156276,156326,156574,156578,156805,156817,157261,157363,157478,157567,157686,157744,157816,157936,157957,158106,158107,158132,158309,158351,158424,158511,158512,158869,158967,159009,159025,159499,159566,159609,159639,159922,160014,160139,160143,160285,160412,160414,160552,160832,161798,161829,161919,162037,162105,162249,162260,162329,162379,162714,162941,162961,163171,163333,163537,163900,164108,164403,164590,164939,164947,164982,164989,165109,165137,165186,165228,165236,165370,165582,165643,165780,165857,166177,166182,166185,166198,166372,166373,166374,166420,166547,166622,167014,167028,167160,167288,167550,167553,167560,167925,168340,168626,168659,168694,168717,168994,169053,169149,169180,169378,169490,169658,169751,169770,169771,169846,169919,169986,170046,170204,170258,170366,170384,170447,170548,170630,171037,171206,171322,171343,171383,171420,171482,171525,171690,171772,172151,172205,172206,172207,172208,172209,172393,172399,172437,172503,172737,172784,172793,172847,172864,172876,173042,173116,173123,173131,173141,173142,173182,173196,173233,173331,173448,173526,173572,173601,173630,173755,173866,173911,174094,174360,174568,174600,174631,174721,174779,174783,174870,174936,175053,175187,175433,175449,175451,175528,175531,175643,175700,175861,175978,176130,176180,176239,176342,176475,176494,176495,176504,176566,176652,176654,176666,176739,176771,176941,177233,177272,177410,177587,177699,177827,177834,177854,178009,178196,178299,178474,178597,178610,178766,178913,178914,179561,179917,180298,180480,180586,180658,180795,180833,180876,180906,180955,181030,181102,181222,181225,181505,181581,181673,181777,181806,181928,182031,182063,182189,182246,182941,182944,183146,183150,183257,183428,183664,183812,183865,183878,183919,184048,184316,184617,184816,185092,185122,185137,185276,185282,185529,185628,185967,185983,185999,186241,186353,186419,186437,186766,187038,187061,187215,187313,187423,187532,187606,187708,187838,187854,188077,188243,188288,188539,188568,188596,188904,188905,189085,189271,189390,189567,189868,190026,190281,191172,191206,191321,191334,191366,191369,191490,191774,191948,192438,192747,192791,193142,193533,193930,194986,195669,196399,196821,197387) GROUP BY sold_week ORDER BY scs.date_actual_sold |
77 | Creole | executeQuery(): [7.57 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 (20624,20625,20626,20853,21164,21235,21506,21970,22318,22539,22664,22703,22759,22782,23194,23195,23912,23913,24156,24301,24862,25152,25204,25402,25491,25771,26110,26120,26441,26443,27453,27743,27967,28037,28525,28865,28866,29444,29842,30152,30292,30393,30502,30657,32025,32491,32492,32961,34556,34793,35042,35053,35094,35096,35110,35124,35355,36120,36621,36948,42062,43300,43396,43796,43957,45498,46237,46338,46339,46490,46847,46848,47517,48603,48890,49712,51046,51886,52060,52641,53149,53278,54012,54253,55388,55458,55803,55982,56064,56065,56071,56473,56474,56475,56476,56477,56478,56479,56480,56481,56482,56483,56732,56852,56883,57354,57457,57718,57723,58175,58379,58508,58509,58510,58513,58514,58521,58664,58724,58788,58937,58975,59020,59024,59027,59069,59642,59976,60055,60274,60319,60653,60712,60717,60752,60771,60875,60908,61096,61465,61485,61850,62206,62340,62416,62417,63823,63933,64019,64034,65223,65497,65629,65633,66453,66651,66862,67712,67999,68510,69546,69604,70181,70512,70983,71813,71988,72626,72866,72971,73728,74200,74251,74531,74999,75045,75053,75121,75283,76156,76175,76613,76690,76716,77643,78340,78365,79701,81242,81977,82969,83040,83080,83269,83531,84104,84106,84235,84956,85156,85244,85963,86036,86240,86294,86392,86412,86515,86589,86770,87255,87286,88155,88714,89071,89082,89628,90294,90369,90370,90958,91045,91583,91734,92180,92218,92720,92935,93480,93772,94134,95131,95132,95248,95359,95983,96028,96073,96159,97888,97950,97951,98057,98189,98254,98384,98438,98826,99247,99329,100015,100038,100209,100225,100620,100783,100804,100807,101746,102153,102295,102341,102393,102633,103014,103218,103247,103250,103409,103583,103757,103833,104200,104791,104901,104911,105265,105278,105294,105348,105423,105431,105686,105754,105903,106356,106494,106566,106611,106774,106815,107108,107253,107338,107502,107513,108010,108017,108034,108364,108425,108899,109035,109038,109041,109045,109115,109248,109358,109567,109580,109691,109701,109723,109742,109973,110099,110216,110347,110947,111753,111754,111755,111756,112350,112532,112681,112879,112977,113072,113202,113214,113248,113387,113474,113666,113850,114108,114109,114520,114771,114772,114774,114799,115085,115155,115621,115622,115671,116275,116421,116553,116575,116636,116766,116787,117109,117288,117291,117292,117422,117646,117726,117745,117911,117966,117967,118212,118231,118305,118602,118814,119114,119204,119232,119355,119919,120179,120514,120515,120526,120527,120528,120547,120548,120552,120553,120876,120956,120963,120975,120983,120993,121194,121285,121290,121297,121298,121299,121469,121476,121613,121614,121617,121622,121623,121628,121652,122041,122138,122201,122253,122474,122807,122917,122920,123002,123043,123366,123403,123829,124063,124089,124200,124203,125328,125368,125432,125475,125501,125815,125830,125831,126061,126149,126262,126296,126336,126425,126426,126493,126513,126619,126655,126810,127013,127188,127236,127350,127354,127391,127559,127689,127916,127985,128013,128064,128157,128286,128377,128380,128537,128632,128650,128676,128757,128758,128873,129025,129086,129147,129273,129276,129342,130173,130373,130655,130936,131604,131683,131866,132065,132897,132995,132996,133610,133961,135004,135104,135212,135222,135677,135952,136000,136254,136682,136706,136913,136921,136933,136979,137168,137169,137203,137204,137205,137346,137434,137452,137599,137617,137734,137881,137945,137990,137992,137993,137994,137995,138080,138083,138159,138286,138419,138420,138451,138523,138527,138530,138532,138534,138541,138542,138569,138807,138970,138971,138972,138973,138974,138975,138976,138977,138978,138979,138980,138981,138982,139367,139389,140932,141026,141092,141099,141140,141334,141721,141880,142060,142099,142122,142156,142456,142458,142526,142554,142612,142613,142708,142846,143022,143256,143282,143321,143333,143482,143544,143545,143626,143631,143799,143800,143801,143820,143922,144015,144037,144082,144122,144183,144217,144261,144441,144486,144596,144767,144804,144858,144890,144898,144950,144991,145032,145033,145207,145208,145247,145253,145343,145361,145403,145601,145689,145718,145727,145963,146047,146122,146130,146131,146332,146433,146503,146598,147031,147737,147760,147978,148048,148105,148166,148181,148217,148218,148222,148365,148556,148577,148704,148970,149049,149076,149145,149154,149318,149380,149531,149544,149563,149611,149768,149968,150115,150192,150195,150199,150280,150359,150484,150493,150961,151072,151099,151101,151128,151435,151528,151573,152181,152545,152601,152789,153136,153285,153374,153380,153417,153447,153513,153600,153603,153607,153641,153685,153930,154069,154070,154141,154145,154329,154418,154426,154536,154934,155118,155243,155267,155339,155403,155598,155603,155635,155639,155711,156249,156275,156276,156326,156574,156578,156805,156817,157261,157363,157478,157567,157686,157744,157816,157936,157957,158106,158107,158132,158309,158351,158424,158511,158512,158869,158967,159009,159025,159499,159566,159609,159639,159922,160014,160139,160143,160285,160412,160414,160552,160832,161798,161829,161919,162037,162105,162249,162260,162329,162379,162714,162941,162961,163171,163333,163537,163900,164108,164403,164590,164939,164947,164982,164989,165109,165137,165186,165228,165236,165370,165582,165643,165780,165857,166177,166182,166185,166198,166372,166373,166374,166420,166547,166622,167014,167028,167160,167288,167550,167553,167560,167925,168340,168626,168659,168694,168717,168994,169053,169149,169180,169378,169490,169658,169751,169770,169771,169846,169919,169986,170046,170204,170258,170366,170384,170447,170548,170630,171037,171206,171322,171343,171383,171420,171482,171525,171690,171772,172151,172205,172206,172207,172208,172209,172393,172399,172437,172503,172737,172784,172793,172847,172864,172876,173042,173116,173123,173131,173141,173142,173182,173196,173233,173331,173448,173526,173572,173601,173630,173755,173866,173911,174094,174360,174568,174600,174631,174721,174779,174783,174870,174936,175053,175187,175433,175449,175451,175528,175531,175643,175700,175861,175978,176130,176180,176239,176342,176475,176494,176495,176504,176566,176652,176654,176666,176739,176771,176941,177233,177272,177410,177587,177699,177827,177834,177854,178009,178196,178299,178474,178597,178610,178766,178913,178914,179561,179917,180298,180480,180586,180658,180795,180833,180876,180906,180955,181030,181102,181222,181225,181505,181581,181673,181777,181806,181928,182031,182063,182189,182246,182941,182944,183146,183150,183257,183428,183664,183812,183865,183878,183919,184048,184316,184617,184816,185092,185122,185137,185276,185282,185529,185628,185967,185983,185999,186241,186353,186419,186437,186766,187038,187061,187215,187313,187423,187532,187606,187708,187838,187854,188077,188243,188288,188539,188568,188596,188904,188905,189085,189271,189390,189567,189868,190026,190281,191172,191206,191321,191334,191366,191369,191490,191774,191948,192438,192747,192791,193142,193533,193930,194986,195669,196399,196821,197387) 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 (20624,20625,20626,20853,21164,21235,21506,21970,22318,22539,22664,22703,22759,22782,23194,23195,23912,23913,24156,24301,24862,25152,25204,25402,25491,25771,26110,26120,26441,26443,27453,27743,27967,28037,28525,28865,28866,29444,29842,30152,30292,30393,30502,30657,32025,32491,32492,32961,34556,34793,35042,35053,35094,35096,35110,35124,35355,36120,36621,36948,42062,43300,43396,43796,43957,45498,46237,46338,46339,46490,46847,46848,47517,48603,48890,49712,51046,51886,52060,52641,53149,53278,54012,54253,55388,55458,55803,55982,56064,56065,56071,56473,56474,56475,56476,56477,56478,56479,56480,56481,56482,56483,56732,56852,56883,57354,57457,57718,57723,58175,58379,58508,58509,58510,58513,58514,58521,58664,58724,58788,58937,58975,59020,59024,59027,59069,59642,59976,60055,60274,60319,60653,60712,60717,60752,60771,60875,60908,61096,61465,61485,61850,62206,62340,62416,62417,63823,63933,64019,64034,65223,65497,65629,65633,66453,66651,66862,67712,67999,68510,69546,69604,70181,70512,70983,71813,71988,72626,72866,72971,73728,74200,74251,74531,74999,75045,75053,75121,75283,76156,76175,76613,76690,76716,77643,78340,78365,79701,81242,81977,82969,83040,83080,83269,83531,84104,84106,84235,84956,85156,85244,85963,86036,86240,86294,86392,86412,86515,86589,86770,87255,87286,88155,88714,89071,89082,89628,90294,90369,90370,90958,91045,91583,91734,92180,92218,92720,92935,93480,93772,94134,95131,95132,95248,95359,95983,96028,96073,96159,97888,97950,97951,98057,98189,98254,98384,98438,98826,99247,99329,100015,100038,100209,100225,100620,100783,100804,100807,101746,102153,102295,102341,102393,102633,103014,103218,103247,103250,103409,103583,103757,103833,104200,104791,104901,104911,105265,105278,105294,105348,105423,105431,105686,105754,105903,106356,106494,106566,106611,106774,106815,107108,107253,107338,107502,107513,108010,108017,108034,108364,108425,108899,109035,109038,109041,109045,109115,109248,109358,109567,109580,109691,109701,109723,109742,109973,110099,110216,110347,110947,111753,111754,111755,111756,112350,112532,112681,112879,112977,113072,113202,113214,113248,113387,113474,113666,113850,114108,114109,114520,114771,114772,114774,114799,115085,115155,115621,115622,115671,116275,116421,116553,116575,116636,116766,116787,117109,117288,117291,117292,117422,117646,117726,117745,117911,117966,117967,118212,118231,118305,118602,118814,119114,119204,119232,119355,119919,120179,120514,120515,120526,120527,120528,120547,120548,120552,120553,120876,120956,120963,120975,120983,120993,121194,121285,121290,121297,121298,121299,121469,121476,121613,121614,121617,121622,121623,121628,121652,122041,122138,122201,122253,122474,122807,122917,122920,123002,123043,123366,123403,123829,124063,124089,124200,124203,125328,125368,125432,125475,125501,125815,125830,125831,126061,126149,126262,126296,126336,126425,126426,126493,126513,126619,126655,126810,127013,127188,127236,127350,127354,127391,127559,127689,127916,127985,128013,128064,128157,128286,128377,128380,128537,128632,128650,128676,128757,128758,128873,129025,129086,129147,129273,129276,129342,130173,130373,130655,130936,131604,131683,131866,132065,132897,132995,132996,133610,133961,135004,135104,135212,135222,135677,135952,136000,136254,136682,136706,136913,136921,136933,136979,137168,137169,137203,137204,137205,137346,137434,137452,137599,137617,137734,137881,137945,137990,137992,137993,137994,137995,138080,138083,138159,138286,138419,138420,138451,138523,138527,138530,138532,138534,138541,138542,138569,138807,138970,138971,138972,138973,138974,138975,138976,138977,138978,138979,138980,138981,138982,139367,139389,140932,141026,141092,141099,141140,141334,141721,141880,142060,142099,142122,142156,142456,142458,142526,142554,142612,142613,142708,142846,143022,143256,143282,143321,143333,143482,143544,143545,143626,143631,143799,143800,143801,143820,143922,144015,144037,144082,144122,144183,144217,144261,144441,144486,144596,144767,144804,144858,144890,144898,144950,144991,145032,145033,145207,145208,145247,145253,145343,145361,145403,145601,145689,145718,145727,145963,146047,146122,146130,146131,146332,146433,146503,146598,147031,147737,147760,147978,148048,148105,148166,148181,148217,148218,148222,148365,148556,148577,148704,148970,149049,149076,149145,149154,149318,149380,149531,149544,149563,149611,149768,149968,150115,150192,150195,150199,150280,150359,150484,150493,150961,151072,151099,151101,151128,151435,151528,151573,152181,152545,152601,152789,153136,153285,153374,153380,153417,153447,153513,153600,153603,153607,153641,153685,153930,154069,154070,154141,154145,154329,154418,154426,154536,154934,155118,155243,155267,155339,155403,155598,155603,155635,155639,155711,156249,156275,156276,156326,156574,156578,156805,156817,157261,157363,157478,157567,157686,157744,157816,157936,157957,158106,158107,158132,158309,158351,158424,158511,158512,158869,158967,159009,159025,159499,159566,159609,159639,159922,160014,160139,160143,160285,160412,160414,160552,160832,161798,161829,161919,162037,162105,162249,162260,162329,162379,162714,162941,162961,163171,163333,163537,163900,164108,164403,164590,164939,164947,164982,164989,165109,165137,165186,165228,165236,165370,165582,165643,165780,165857,166177,166182,166185,166198,166372,166373,166374,166420,166547,166622,167014,167028,167160,167288,167550,167553,167560,167925,168340,168626,168659,168694,168717,168994,169053,169149,169180,169378,169490,169658,169751,169770,169771,169846,169919,169986,170046,170204,170258,170366,170384,170447,170548,170630,171037,171206,171322,171343,171383,171420,171482,171525,171690,171772,172151,172205,172206,172207,172208,172209,172393,172399,172437,172503,172737,172784,172793,172847,172864,172876,173042,173116,173123,173131,173141,173142,173182,173196,173233,173331,173448,173526,173572,173601,173630,173755,173866,173911,174094,174360,174568,174600,174631,174721,174779,174783,174870,174936,175053,175187,175433,175449,175451,175528,175531,175643,175700,175861,175978,176130,176180,176239,176342,176475,176494,176495,176504,176566,176652,176654,176666,176739,176771,176941,177233,177272,177410,177587,177699,177827,177834,177854,178009,178196,178299,178474,178597,178610,178766,178913,178914,179561,179917,180298,180480,180586,180658,180795,180833,180876,180906,180955,181030,181102,181222,181225,181505,181581,181673,181777,181806,181928,182031,182063,182189,182246,182941,182944,183146,183150,183257,183428,183664,183812,183865,183878,183919,184048,184316,184617,184816,185092,185122,185137,185276,185282,185529,185628,185967,185983,185999,186241,186353,186419,186437,186766,187038,187061,187215,187313,187423,187532,187606,187708,187838,187854,188077,188243,188288,188539,188568,188596,188904,188905,189085,189271,189390,189567,189868,190026,190281,191172,191206,191321,191334,191366,191369,191490,191774,191948,192438,192747,192791,193142,193533,193930,194986,195669,196399,196821,197387) GROUP BY sold_month ORDER BY scs.date_actual_sold |
79 | Creole | executeQuery(): [10.20 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 (20624,20625,20626,20853,21164,21235,21506,21970,22318,22539,22664,22703,22759,22782,23194,23195,23912,23913,24156,24301,24862,25152,25204,25402,25491,25771,26110,26120,26441,26443,27453,27743,27967,28037,28525,28865,28866,29444,29842,30152,30292,30393,30502,30657,32025,32491,32492,32961,34556,34793,35042,35053,35094,35096,35110,35124,35355,36120,36621,36948,42062,43300,43396,43796,43957,45498,46237,46338,46339,46490,46847,46848,47517,48603,48890,49712,51046,51886,52060,52641,53149,53278,54012,54253,55388,55458,55803,55982,56064,56065,56071,56473,56474,56475,56476,56477,56478,56479,56480,56481,56482,56483,56732,56852,56883,57354,57457,57718,57723,58175,58379,58508,58509,58510,58513,58514,58521,58664,58724,58788,58937,58975,59020,59024,59027,59069,59642,59976,60055,60274,60319,60653,60712,60717,60752,60771,60875,60908,61096,61465,61485,61850,62206,62340,62416,62417,63823,63933,64019,64034,65223,65497,65629,65633,66453,66651,66862,67712,67999,68510,69546,69604,70181,70512,70983,71813,71988,72626,72866,72971,73728,74200,74251,74531,74999,75045,75053,75121,75283,76156,76175,76613,76690,76716,77643,78340,78365,79701,81242,81977,82969,83040,83080,83269,83531,84104,84106,84235,84956,85156,85244,85963,86036,86240,86294,86392,86412,86515,86589,86770,87255,87286,88155,88714,89071,89082,89628,90294,90369,90370,90958,91045,91583,91734,92180,92218,92720,92935,93480,93772,94134,95131,95132,95248,95359,95983,96028,96073,96159,97888,97950,97951,98057,98189,98254,98384,98438,98826,99247,99329,100015,100038,100209,100225,100620,100783,100804,100807,101746,102153,102295,102341,102393,102633,103014,103218,103247,103250,103409,103583,103757,103833,104200,104791,104901,104911,105265,105278,105294,105348,105423,105431,105686,105754,105903,106356,106494,106566,106611,106774,106815,107108,107253,107338,107502,107513,108010,108017,108034,108364,108425,108899,109035,109038,109041,109045,109115,109248,109358,109567,109580,109691,109701,109723,109742,109973,110099,110216,110347,110947,111753,111754,111755,111756,112350,112532,112681,112879,112977,113072,113202,113214,113248,113387,113474,113666,113850,114108,114109,114520,114771,114772,114774,114799,115085,115155,115621,115622,115671,116275,116421,116553,116575,116636,116766,116787,117109,117288,117291,117292,117422,117646,117726,117745,117911,117966,117967,118212,118231,118305,118602,118814,119114,119204,119232,119355,119919,120179,120514,120515,120526,120527,120528,120547,120548,120552,120553,120876,120956,120963,120975,120983,120993,121194,121285,121290,121297,121298,121299,121469,121476,121613,121614,121617,121622,121623,121628,121652,122041,122138,122201,122253,122474,122807,122917,122920,123002,123043,123366,123403,123829,124063,124089,124200,124203,125328,125368,125432,125475,125501,125815,125830,125831,126061,126149,126262,126296,126336,126425,126426,126493,126513,126619,126655,126810,127013,127188,127236,127350,127354,127391,127559,127689,127916,127985,128013,128064,128157,128286,128377,128380,128537,128632,128650,128676,128757,128758,128873,129025,129086,129147,129273,129276,129342,130173,130373,130655,130936,131604,131683,131866,132065,132897,132995,132996,133610,133961,135004,135104,135212,135222,135677,135952,136000,136254,136682,136706,136913,136921,136933,136979,137168,137169,137203,137204,137205,137346,137434,137452,137599,137617,137734,137881,137945,137990,137992,137993,137994,137995,138080,138083,138159,138286,138419,138420,138451,138523,138527,138530,138532,138534,138541,138542,138569,138807,138970,138971,138972,138973,138974,138975,138976,138977,138978,138979,138980,138981,138982,139367,139389,140932,141026,141092,141099,141140,141334,141721,141880,142060,142099,142122,142156,142456,142458,142526,142554,142612,142613,142708,142846,143022,143256,143282,143321,143333,143482,143544,143545,143626,143631,143799,143800,143801,143820,143922,144015,144037,144082,144122,144183,144217,144261,144441,144486,144596,144767,144804,144858,144890,144898,144950,144991,145032,145033,145207,145208,145247,145253,145343,145361,145403,145601,145689,145718,145727,145963,146047,146122,146130,146131,146332,146433,146503,146598,147031,147737,147760,147978,148048,148105,148166,148181,148217,148218,148222,148365,148556,148577,148704,148970,149049,149076,149145,149154,149318,149380,149531,149544,149563,149611,149768,149968,150115,150192,150195,150199,150280,150359,150484,150493,150961,151072,151099,151101,151128,151435,151528,151573,152181,152545,152601,152789,153136,153285,153374,153380,153417,153447,153513,153600,153603,153607,153641,153685,153930,154069,154070,154141,154145,154329,154418,154426,154536,154934,155118,155243,155267,155339,155403,155598,155603,155635,155639,155711,156249,156275,156276,156326,156574,156578,156805,156817,157261,157363,157478,157567,157686,157744,157816,157936,157957,158106,158107,158132,158309,158351,158424,158511,158512,158869,158967,159009,159025,159499,159566,159609,159639,159922,160014,160139,160143,160285,160412,160414,160552,160832,161798,161829,161919,162037,162105,162249,162260,162329,162379,162714,162941,162961,163171,163333,163537,163900,164108,164403,164590,164939,164947,164982,164989,165109,165137,165186,165228,165236,165370,165582,165643,165780,165857,166177,166182,166185,166198,166372,166373,166374,166420,166547,166622,167014,167028,167160,167288,167550,167553,167560,167925,168340,168626,168659,168694,168717,168994,169053,169149,169180,169378,169490,169658,169751,169770,169771,169846,169919,169986,170046,170204,170258,170366,170384,170447,170548,170630,171037,171206,171322,171343,171383,171420,171482,171525,171690,171772,172151,172205,172206,172207,172208,172209,172393,172399,172437,172503,172737,172784,172793,172847,172864,172876,173042,173116,173123,173131,173141,173142,173182,173196,173233,173331,173448,173526,173572,173601,173630,173755,173866,173911,174094,174360,174568,174600,174631,174721,174779,174783,174870,174936,175053,175187,175433,175449,175451,175528,175531,175643,175700,175861,175978,176130,176180,176239,176342,176475,176494,176495,176504,176566,176652,176654,176666,176739,176771,176941,177233,177272,177410,177587,177699,177827,177834,177854,178009,178196,178299,178474,178597,178610,178766,178913,178914,179561,179917,180298,180480,180586,180658,180795,180833,180876,180906,180955,181030,181102,181222,181225,181505,181581,181673,181777,181806,181928,182031,182063,182189,182246,182941,182944,183146,183150,183257,183428,183664,183812,183865,183878,183919,184048,184316,184617,184816,185092,185122,185137,185276,185282,185529,185628,185967,185983,185999,186241,186353,186419,186437,186766,187038,187061,187215,187313,187423,187532,187606,187708,187838,187854,188077,188243,188288,188539,188568,188596,188904,188905,189085,189271,189390,189567,189868,190026,190281,191172,191206,191321,191334,191366,191369,191490,191774,191948,192438,192747,192791,193142,193533,193930,194986,195669,196399,196821,197387) 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(): [1067.41 ms] SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC |
82 | Action | change layout to "view_layout" |
83 | View | initialize view for "home/view" |
84 | View | render "sf_app_dir/modules/home/templates/viewSuccess.php" |
85 | View | initialize view for "home/_vif_images" |
86 | View | render "sf_app_dir/modules/home/templates/_vif_images.php" |
87 | PartialHelper | Generate cache key |
88 | View | initialize view for "common_page/_social_buttons" |
89 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php" |
90 | PartialHelper | Generate cache key |
91 | View | initialize view for "home/_vif_info" |
92 | View | render "sf_app_dir/modules/home/templates/_vif_info.php" |
93 | PartialHelper | Generate cache key |
94 | View | initialize view for "home/_hoover_user_info" |
95 | View | render "sf_app_dir/modules/home/templates/_hoover_user_info.php" |
96 | PartialHelper | Generate cache key |
97 | View | initialize view for "common_page/_price_development_graph" |
98 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php" |
99 | PartialHelper | Generate cache key |
100 | View | initialize view for "common_page/_sell_time_price_graph" |
101 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php" |
102 | PartialHelper | Generate cache key |
103 | View | initialize view for "common_page/_price_gauge_graph" |
104 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php" |
105 | PartialHelper | Generate cache key |
106 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
107 | Creole | executeQuery(): [0.46 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199699 |
108 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
109 | Creole | executeQuery(): [1.85 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199669 |
110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
111 | Creole | executeQuery(): [0.46 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199651 |
112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
113 | Creole | executeQuery(): [0.36 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199579 |
114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
115 | Creole | executeQuery(): [0.54 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199505 |
116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
117 | Creole | executeQuery(): [0.97 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199702 |
118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
119 | Creole | executeQuery(): [0.62 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199624 |
120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
121 | Creole | executeQuery(): [0.77 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199581 |
122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
123 | Creole | executeQuery(): [0.93 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199504 |
124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
125 | Creole | executeQuery(): [0.36 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199465 |
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: 199668 action: view id: 199668 make: ford model: thunderbird 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: 1730427855.7078 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/ford/thunderbird/199668 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/ford/thunderbird/199668 HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) PATH_INFO: /ford/thunderbird/199668 PATH_TRANSLATED: /web/classicdigest.com/web/ford/thunderbird/199668 PHP_SELF: /cars/index_dev.php/ford/thunderbird/199668 QUERY_STRING: REDIRECT_STATUS: 200 REMOTE_ADDR: 3.144.9.82 REMOTE_PORT: 11095 REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1730427855 REQUEST_TIME_FLOAT: 1730427855.7066 REQUEST_URI: /cars/index_dev.php/ford/thunderbird/199668 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.51 |
Action "home/view" | 1 | 1245.36 |
Database | 34 | 1183.41 |
View "Success" for "home/view" | 1 | 48.75 |
Partial "home/_vif_images" | 1 | 0.50 |
Partial "common_page/_social_buttons" | 1 | 0.07 |
Partial "home/_vif_info" | 1 | 0.16 |
Partial "home/_hoover_user_info" | 1 | 0.06 |
Partial "common_page/_price_development_graph" | 1 | 0.06 |
Partial "common_page/_sell_time_price_graph" | 1 | 0.04 |
Partial "common_page/_price_gauge_graph" | 1 | 0.04 |
Partial "common_page/_include_vif_js" | 1 | 0.05 |
Partial "common_page/_fancybox_javascript" | 2 | 0.17 |
Partial "common_page/_responsive_javascript" | 1 | 0.06 |
Partial "common_page/_google_analytics" | 1 | 0.04 |
Partial "common_page/_header_links" | 1 | 0.70 |
Partial "common_page/_cookie_policy" | 1 | 0.07 |
Partial "common_page/_responsive_top_menu" | 1 | 0.11 |
Partial "common_page/_top_menu" | 1 | 0.12 |
Partial "common_page/_footer_javascript" | 1 | 0.10 |
Partial "common_page/_footer" | 1 | 0.10 |