People who viewed this Other Other also viewed similar Other 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' => 'other', 'model' => 'other', 'id' => '131378', '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(): [3.82 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=131378 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(): [14.52 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 (529) |
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.35 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=131378 |
38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
39 | Creole | executeQuery(): [1.09 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=131378 |
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(): [43.95 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=131378 |
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(): [13.88 ms] SELECT netti_dealer.ID_DEALER, netti_dealer.ID, netti_dealer.PATH, netti_dealer.COMPANY, netti_dealer.SLOGAN, netti_dealer.URL, netti_dealer.SIMPLE_URL, netti_dealer.HAS_SITE FROM netti_dealer WHERE netti_dealer.ID_DEALER IN (529) |
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(): [11.98 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=131378 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(): [5.97 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 (131378) ORDER BY carimg.ORD ASC |
49 | Creole | executeQuery(): [8.71 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 (131378) 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(): [18.93 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 (529) |
52 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
53 | Creole | executeQuery(): [8.93 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=529 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(): [8.64 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=128 AND model.ID=2098 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 != 131378 AND car.ID_MODEL = '2098' ) 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 != 131378 AND car.ID_MODEL = '2098' ) 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 != 131378 AND car.ID_MODEL = '2098' ) 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 != 131378 AND car.ID_MODEL = '2098' ) ) AS count |
58 | Creole | executeQuery(): [17.02 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 != 131378 AND car.ID_MODEL = '2098' ) 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 != 131378 AND car.ID_MODEL = '2098' ) ) 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 != 131378 AND car.ID_MODEL = '2098' ) 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 != 131378 AND car.ID_MODEL = '2098' ) ORDER BY ID DESC, offset: 0, limit: 5 |
60 | Creole | executeQuery(): [24.43 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 != 131378 AND car.ID_MODEL = '2098' ) 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 != 131378 AND car.ID_MODEL = '2098' ) 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 (199879,199183,199010,198896,197950) ORDER BY carimg.ORD ASC |
62 | Creole | executeQuery(): [7.29 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 (199879,199183,199010,198896,197950) 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 != '131378' AND car.ID_NETTI_USER = '529' ) 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 != '131378' AND car.ID_NETTI_USER = '529' ) 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 != '131378' AND car.ID_NETTI_USER = '529' ) 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 != '131378' AND car.ID_NETTI_USER = '529' ) ) AS count |
65 | Creole | executeQuery(): [10.24 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 != '131378' AND car.ID_NETTI_USER = '529' ) 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 != '131378' AND car.ID_NETTI_USER = '529' ) ) 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 != '131378' AND car.ID_NETTI_USER = '529' ) 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 != '131378' AND car.ID_NETTI_USER = '529' ) ORDER BY ID DESC, offset: 0, limit: 5 |
67 | Creole | executeQuery(): [5.86 ms] ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '131378' AND car.ID_NETTI_USER = '529' ) 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 != '131378' AND car.ID_NETTI_USER = '529' ) 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 (142338,141261,139233,131379,131377) ORDER BY carimg.ORD ASC |
69 | Creole | executeQuery(): [12.63 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 (142338,141261,139233,131379,131377) 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(): [7.26 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=128 AND car.ID_MODEL=2098 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(): [9.52 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=128 AND sold_car.ID_MODEL=2098 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 (28234,28657,30479,31289,31361,31368,31369,31381,44011,48290,53065,59972,60916,62703,64340,67900,70274,87167,93850,109431,110028,110357,112075,112401,114624,115689,115792,115996,116697,118185,118965,123290,123623,123624,124956,128137,128728,131377,131378,131992,131993,132041,132043,132497,132663,133271,134148,135189,135839,135844,136018,136502,137941,139586,139647,140125,140295,140304,140323,140325,140326,140327,140329,140331,140702,140910,140916,142297,142340,142717,144200,146449,146570,147531,147534,149095,150590,153243,153312,155165,155208,155501,155903,156460,156461,158211,158758,160410,161381,161408,162849,162852,163890,164456,165467,165476,165950,166736,168793,170626,170738,170795,170796,171059,171084,171085,171087,171307,171971,172251,172252,172493,172806,172861,173833,173840,173842,174333,174340,174968,176454,176905,177242,177370,177371,177372,179001,179639,179982,180353,180547,181130,183727,184072,184253,184883,190123,191648,191843,192735,193303,193967,195876,195974,196741,196742,197426,197891,197907,197950,198896,199010,199183,199879) GROUP BY cmonth ORDER BY date_create |
75 | Creole | executeQuery(): [26.10 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 (28234,28657,30479,31289,31361,31368,31369,31381,44011,48290,53065,59972,60916,62703,64340,67900,70274,87167,93850,109431,110028,110357,112075,112401,114624,115689,115792,115996,116697,118185,118965,123290,123623,123624,124956,128137,128728,131377,131378,131992,131993,132041,132043,132497,132663,133271,134148,135189,135839,135844,136018,136502,137941,139586,139647,140125,140295,140304,140323,140325,140326,140327,140329,140331,140702,140910,140916,142297,142340,142717,144200,146449,146570,147531,147534,149095,150590,153243,153312,155165,155208,155501,155903,156460,156461,158211,158758,160410,161381,161408,162849,162852,163890,164456,165467,165476,165950,166736,168793,170626,170738,170795,170796,171059,171084,171085,171087,171307,171971,172251,172252,172493,172806,172861,173833,173840,173842,174333,174340,174968,176454,176905,177242,177370,177371,177372,179001,179639,179982,180353,180547,181130,183727,184072,184253,184883,190123,191648,191843,192735,193303,193967,195876,195974,196741,196742,197426,197891,197907,197950,198896,199010,199183,199879) 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 (27718,27719,27748,27783,27784,27785,27787,27788,27789,27809,27810,27811,27836,27837,27838,27997,28110,28111,28112,28113,28114,28115,28116,28117,28138,28158,28159,28210,28212,28213,28235,28299,28302,28389,28515,28516,28517,28600,28601,28602,28603,28644,28645,28659,28660,28661,28663,28815,28816,28817,28818,28819,28820,28821,28822,28846,28852,28853,28887,28888,28889,28915,28974,29026,29097,29148,29199,29200,29275,29276,29277,29278,29279,29280,29281,29282,29303,29304,29317,29332,29333,29436,29484,29485,29486,29488,29489,29490,29491,29492,29493,29494,29495,29496,29497,29498,29499,29500,29513,29571,29574,29756,29834,29848,29875,29974,29975,29988,30023,30044,30060,30061,30064,30065,30066,30146,30147,30199,30200,30201,30202,30203,30661,30662,30663,30664,30665,30666,30667,30668,30669,30670,30671,30672,30673,30674,30675,30676,30677,30678,30679,30680,30681,30682,30683,30684,30685,30687,30749,30752,30755,30756,30757,30759,30760,30761,30762,31222,31288,31482,31483,31984,32001,32003,32256,32257,32262,32592,32612,32887,32999,33024,33085,33201,33242,33427,33433,33507,33692,33696,33745,33767,33789,33870,33888,33893,33901,33903,33904,33906,33907,33908,33909,33910,33911,33912,33913,33914,33915,33927,33929,33938,34162,34163,34181,34269,34328,34335,34337,34338,34341,34342,34345,34350,34351,34352,34354,34355,34356,34357,34359,34360,34364,34369,34370,34373,34405,34431,34499,34505,34506,34507,34509,34512,34530,34557,34562,34849,34885,34886,34966,34967,34973,35242,35280,35362,35640,35706,36159,36176,36624,36739,36816,36880,36928,36930,36960,37009,37086,37094,38674,38675,38676,38914,39312,39315,39368,39677,39692,39693,41915,41925,41968,42023,42470,42471,42552,42627,43046,43080,43358,43776,43843,43851,43859,43942,44098,44396,44778,44781,44839,45245,45246,45247,45248,45249,45250,45251,45252,45253,45254,45255,45256,45257,45258,45259,45312,45378,45379,45380,45476,45534,45557,45567,45568,45569,45570,45571,45572,45573,45600,45744,46062,46222,46223,46226,46271,46279,46311,46312,46471,46962,46963,46964,46980,47062,47093,47156,47467,47753,47799,47829,47852,47859,47930,48291,48375,48594,48861,48862,48863,48959,48960,48961,49002,49058,49059,49122,49314,49378,49481,49490,49517,49718,49754,49783,49817,49833,49834,49835,49836,49837,49838,49839,49840,49841,49842,49843,49844,49845,49846,49847,49848,49849,49868,49871,49875,49876,49877,49878,49988,50660,50787,50901,51038,51096,51112,51909,51940,51941,52015,52027,52206,52503,52588,52964,53010,53135,53226,53315,53558,53559,53637,53638,53738,53769,53770,53836,54116,54123,54346,54420,54742,54786,54802,54847,55404,55727,56546,56569,56571,57572,57573,57846,57847,57993,58291,58396,58749,58815,58877,58880,58881,58882,58883,58884,58987,58994,58995,58996,58997,58998,58999,59019,59063,59404,59628,59629,59630,59631,59632,59682,59919,60166,60917,61418,61536,61582,61630,61631,61794,62099,62386,62412,62440,62680,62681,62940,62941,63073,63088,63089,63090,63091,63092,63093,63094,63095,63096,63097,63098,63099,63100,63101,63102,63103,63104,63105,63106,63166,63167,63168,63169,63745,63826,63860,63950,64037,64557,65052,65294,65472,65927,65933,66276,66756,66757,66956,67599,67646,67774,67868,67897,68007,68428,68484,68526,68529,68698,69383,69420,70068,70069,70158,70385,70386,70387,70388,70389,70390,70475,70960,70961,71080,71138,71163,71223,71228,72035,72037,72726,72795,72820,72821,72822,72828,72829,72830,72831,72832,72833,72834,72835,72836,72930,74391,75868,76081,76587,76725,77449,77597,87013,87267,87398,87402,87940,88137,88769,89391,89565,90420,90421,90791,91640,92963,93065,93849,94581,95045,95454,95462,96117,96130,96131,96192,99095,99112,99348,101338,101565,101673,101744,102100,102692,103543,103659,103696,104804,104818,104878,105367,105662,105796,105864,106282,106708,106727,106958,107293,107294,107949,107951,107953,108172,108222,108232,108867,109030,109423,109436,109708,109720,109765,109793,109821,109845,109848,109983,110172,110331,110669,110917,111320,111324,111325,111683,111685,111947,112488,112544,112547,112669,112935,112936,112981,112982,113475,113677,113686,113742,114062,114063,114141,114147,114209,114458,114657,115204,115551,115928,116128,116193,116494,116696,116783,116890,117178,117432,117503,117765,117816,117886,118021,118048,118108,118233,118324,118573,119255,119256,119823,120241,120480,121734,121780,121837,121919,122882,123794,123811,124252,124954,124955,125360,125362,125446,125795,126056,126285,126606,127231,127336,127525,127943,128076,128143,128284,128364,128404,128468,128495,128524,128706,128940,129168,129312,131632,131675,131887,131888,131986,131988,131989,131990,132042,132044,132389,132581,132650,132775,132776,132927,132945,133182,133183,133227,133471,133595,133596,133774,134778,135079,135193,135835,135840,136291,136687,136690,137189,137253,137335,137683,137715,137746,137748,137813,137914,137915,137916,137930,138250,138438,138512,138694,139314,139682,140279,140926,141315,141493,141622,141892,142143,142163,142264,142545,143328,143329,143431,143443,143832,143839,144031,144053,144101,144249,144348,144349,144404,144413,144463,144467,144564,145155,145163,145213,145330,145384,145424,145432,145545,145546,145555,145583,145587,145945,145949,145969,146176,146251,146276,146465,146667,146738,147067,147081,147104,147168,147462,147487,147562,147644,147719,147951,147997,148227,148351,148421,148442,148602,148641,148645,148677,148718,148886,148887,149196,149229,149299,149376,149594,149745,149826,149835,150013,150066,150070,150074,150084,150138,150139,150140,150202,150276,150559,150680,150852,151246,151392,151551,151553,151566,151666,151684,151934,151942,151981,151985,152009,152072,152185,152303,152867,153096,154573,154720,154852,155250,155517,156374,157225,157481,157495,157867,157995,158040,158164,158311,158320,158431,158726,158858,158927,158928,159007,159160,159283,159288,159329,159448,159470,159737,159837,159873,159931,159932,159962,159966,159970,160289,160312,160369,160376,160418,160429,160610,161803,161819,162687,163033,163076,163579,163611,163852,163898,163899,164684,164840,164933,164936,165058,165171,165199,165202,165427,165542,165733,166007,166643,166878,167411,168378,168794,169387,169391,169812,170286,170315,170324,170349,170393,170789,170889,170969,171033,171092,172099,172311,172354,172476,172530,172862,172912,173014,173274,173554,173582,173588,173825,173828,173829,173835,173838,173839,173843,174334,174886,175054,175076,175100,175102,175411,175948,176005,176267,176839,177382,177388,177515,177632,177684,177781,177813,177909,177976,178043,178315,179316,179960,180316,181334,181336,181426,182180,182210,182366,183277,183519,183542,183547,183639,183856,183866,184527,185184,185228,185560,186160,186306,186330,186509,187562,187828,188391,189284,189661,190825,191696,193308,193412,196571,197305,199090) GROUP BY sold_week ORDER BY scs.date_actual_sold |
77 | Creole | executeQuery(): [28.59 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 (27718,27719,27748,27783,27784,27785,27787,27788,27789,27809,27810,27811,27836,27837,27838,27997,28110,28111,28112,28113,28114,28115,28116,28117,28138,28158,28159,28210,28212,28213,28235,28299,28302,28389,28515,28516,28517,28600,28601,28602,28603,28644,28645,28659,28660,28661,28663,28815,28816,28817,28818,28819,28820,28821,28822,28846,28852,28853,28887,28888,28889,28915,28974,29026,29097,29148,29199,29200,29275,29276,29277,29278,29279,29280,29281,29282,29303,29304,29317,29332,29333,29436,29484,29485,29486,29488,29489,29490,29491,29492,29493,29494,29495,29496,29497,29498,29499,29500,29513,29571,29574,29756,29834,29848,29875,29974,29975,29988,30023,30044,30060,30061,30064,30065,30066,30146,30147,30199,30200,30201,30202,30203,30661,30662,30663,30664,30665,30666,30667,30668,30669,30670,30671,30672,30673,30674,30675,30676,30677,30678,30679,30680,30681,30682,30683,30684,30685,30687,30749,30752,30755,30756,30757,30759,30760,30761,30762,31222,31288,31482,31483,31984,32001,32003,32256,32257,32262,32592,32612,32887,32999,33024,33085,33201,33242,33427,33433,33507,33692,33696,33745,33767,33789,33870,33888,33893,33901,33903,33904,33906,33907,33908,33909,33910,33911,33912,33913,33914,33915,33927,33929,33938,34162,34163,34181,34269,34328,34335,34337,34338,34341,34342,34345,34350,34351,34352,34354,34355,34356,34357,34359,34360,34364,34369,34370,34373,34405,34431,34499,34505,34506,34507,34509,34512,34530,34557,34562,34849,34885,34886,34966,34967,34973,35242,35280,35362,35640,35706,36159,36176,36624,36739,36816,36880,36928,36930,36960,37009,37086,37094,38674,38675,38676,38914,39312,39315,39368,39677,39692,39693,41915,41925,41968,42023,42470,42471,42552,42627,43046,43080,43358,43776,43843,43851,43859,43942,44098,44396,44778,44781,44839,45245,45246,45247,45248,45249,45250,45251,45252,45253,45254,45255,45256,45257,45258,45259,45312,45378,45379,45380,45476,45534,45557,45567,45568,45569,45570,45571,45572,45573,45600,45744,46062,46222,46223,46226,46271,46279,46311,46312,46471,46962,46963,46964,46980,47062,47093,47156,47467,47753,47799,47829,47852,47859,47930,48291,48375,48594,48861,48862,48863,48959,48960,48961,49002,49058,49059,49122,49314,49378,49481,49490,49517,49718,49754,49783,49817,49833,49834,49835,49836,49837,49838,49839,49840,49841,49842,49843,49844,49845,49846,49847,49848,49849,49868,49871,49875,49876,49877,49878,49988,50660,50787,50901,51038,51096,51112,51909,51940,51941,52015,52027,52206,52503,52588,52964,53010,53135,53226,53315,53558,53559,53637,53638,53738,53769,53770,53836,54116,54123,54346,54420,54742,54786,54802,54847,55404,55727,56546,56569,56571,57572,57573,57846,57847,57993,58291,58396,58749,58815,58877,58880,58881,58882,58883,58884,58987,58994,58995,58996,58997,58998,58999,59019,59063,59404,59628,59629,59630,59631,59632,59682,59919,60166,60917,61418,61536,61582,61630,61631,61794,62099,62386,62412,62440,62680,62681,62940,62941,63073,63088,63089,63090,63091,63092,63093,63094,63095,63096,63097,63098,63099,63100,63101,63102,63103,63104,63105,63106,63166,63167,63168,63169,63745,63826,63860,63950,64037,64557,65052,65294,65472,65927,65933,66276,66756,66757,66956,67599,67646,67774,67868,67897,68007,68428,68484,68526,68529,68698,69383,69420,70068,70069,70158,70385,70386,70387,70388,70389,70390,70475,70960,70961,71080,71138,71163,71223,71228,72035,72037,72726,72795,72820,72821,72822,72828,72829,72830,72831,72832,72833,72834,72835,72836,72930,74391,75868,76081,76587,76725,77449,77597,87013,87267,87398,87402,87940,88137,88769,89391,89565,90420,90421,90791,91640,92963,93065,93849,94581,95045,95454,95462,96117,96130,96131,96192,99095,99112,99348,101338,101565,101673,101744,102100,102692,103543,103659,103696,104804,104818,104878,105367,105662,105796,105864,106282,106708,106727,106958,107293,107294,107949,107951,107953,108172,108222,108232,108867,109030,109423,109436,109708,109720,109765,109793,109821,109845,109848,109983,110172,110331,110669,110917,111320,111324,111325,111683,111685,111947,112488,112544,112547,112669,112935,112936,112981,112982,113475,113677,113686,113742,114062,114063,114141,114147,114209,114458,114657,115204,115551,115928,116128,116193,116494,116696,116783,116890,117178,117432,117503,117765,117816,117886,118021,118048,118108,118233,118324,118573,119255,119256,119823,120241,120480,121734,121780,121837,121919,122882,123794,123811,124252,124954,124955,125360,125362,125446,125795,126056,126285,126606,127231,127336,127525,127943,128076,128143,128284,128364,128404,128468,128495,128524,128706,128940,129168,129312,131632,131675,131887,131888,131986,131988,131989,131990,132042,132044,132389,132581,132650,132775,132776,132927,132945,133182,133183,133227,133471,133595,133596,133774,134778,135079,135193,135835,135840,136291,136687,136690,137189,137253,137335,137683,137715,137746,137748,137813,137914,137915,137916,137930,138250,138438,138512,138694,139314,139682,140279,140926,141315,141493,141622,141892,142143,142163,142264,142545,143328,143329,143431,143443,143832,143839,144031,144053,144101,144249,144348,144349,144404,144413,144463,144467,144564,145155,145163,145213,145330,145384,145424,145432,145545,145546,145555,145583,145587,145945,145949,145969,146176,146251,146276,146465,146667,146738,147067,147081,147104,147168,147462,147487,147562,147644,147719,147951,147997,148227,148351,148421,148442,148602,148641,148645,148677,148718,148886,148887,149196,149229,149299,149376,149594,149745,149826,149835,150013,150066,150070,150074,150084,150138,150139,150140,150202,150276,150559,150680,150852,151246,151392,151551,151553,151566,151666,151684,151934,151942,151981,151985,152009,152072,152185,152303,152867,153096,154573,154720,154852,155250,155517,156374,157225,157481,157495,157867,157995,158040,158164,158311,158320,158431,158726,158858,158927,158928,159007,159160,159283,159288,159329,159448,159470,159737,159837,159873,159931,159932,159962,159966,159970,160289,160312,160369,160376,160418,160429,160610,161803,161819,162687,163033,163076,163579,163611,163852,163898,163899,164684,164840,164933,164936,165058,165171,165199,165202,165427,165542,165733,166007,166643,166878,167411,168378,168794,169387,169391,169812,170286,170315,170324,170349,170393,170789,170889,170969,171033,171092,172099,172311,172354,172476,172530,172862,172912,173014,173274,173554,173582,173588,173825,173828,173829,173835,173838,173839,173843,174334,174886,175054,175076,175100,175102,175411,175948,176005,176267,176839,177382,177388,177515,177632,177684,177781,177813,177909,177976,178043,178315,179316,179960,180316,181334,181336,181426,182180,182210,182366,183277,183519,183542,183547,183639,183856,183866,184527,185184,185228,185560,186160,186306,186330,186509,187562,187828,188391,189284,189661,190825,191696,193308,193412,196571,197305,199090) 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 (27718,27719,27748,27783,27784,27785,27787,27788,27789,27809,27810,27811,27836,27837,27838,27997,28110,28111,28112,28113,28114,28115,28116,28117,28138,28158,28159,28210,28212,28213,28235,28299,28302,28389,28515,28516,28517,28600,28601,28602,28603,28644,28645,28659,28660,28661,28663,28815,28816,28817,28818,28819,28820,28821,28822,28846,28852,28853,28887,28888,28889,28915,28974,29026,29097,29148,29199,29200,29275,29276,29277,29278,29279,29280,29281,29282,29303,29304,29317,29332,29333,29436,29484,29485,29486,29488,29489,29490,29491,29492,29493,29494,29495,29496,29497,29498,29499,29500,29513,29571,29574,29756,29834,29848,29875,29974,29975,29988,30023,30044,30060,30061,30064,30065,30066,30146,30147,30199,30200,30201,30202,30203,30661,30662,30663,30664,30665,30666,30667,30668,30669,30670,30671,30672,30673,30674,30675,30676,30677,30678,30679,30680,30681,30682,30683,30684,30685,30687,30749,30752,30755,30756,30757,30759,30760,30761,30762,31222,31288,31482,31483,31984,32001,32003,32256,32257,32262,32592,32612,32887,32999,33024,33085,33201,33242,33427,33433,33507,33692,33696,33745,33767,33789,33870,33888,33893,33901,33903,33904,33906,33907,33908,33909,33910,33911,33912,33913,33914,33915,33927,33929,33938,34162,34163,34181,34269,34328,34335,34337,34338,34341,34342,34345,34350,34351,34352,34354,34355,34356,34357,34359,34360,34364,34369,34370,34373,34405,34431,34499,34505,34506,34507,34509,34512,34530,34557,34562,34849,34885,34886,34966,34967,34973,35242,35280,35362,35640,35706,36159,36176,36624,36739,36816,36880,36928,36930,36960,37009,37086,37094,38674,38675,38676,38914,39312,39315,39368,39677,39692,39693,41915,41925,41968,42023,42470,42471,42552,42627,43046,43080,43358,43776,43843,43851,43859,43942,44098,44396,44778,44781,44839,45245,45246,45247,45248,45249,45250,45251,45252,45253,45254,45255,45256,45257,45258,45259,45312,45378,45379,45380,45476,45534,45557,45567,45568,45569,45570,45571,45572,45573,45600,45744,46062,46222,46223,46226,46271,46279,46311,46312,46471,46962,46963,46964,46980,47062,47093,47156,47467,47753,47799,47829,47852,47859,47930,48291,48375,48594,48861,48862,48863,48959,48960,48961,49002,49058,49059,49122,49314,49378,49481,49490,49517,49718,49754,49783,49817,49833,49834,49835,49836,49837,49838,49839,49840,49841,49842,49843,49844,49845,49846,49847,49848,49849,49868,49871,49875,49876,49877,49878,49988,50660,50787,50901,51038,51096,51112,51909,51940,51941,52015,52027,52206,52503,52588,52964,53010,53135,53226,53315,53558,53559,53637,53638,53738,53769,53770,53836,54116,54123,54346,54420,54742,54786,54802,54847,55404,55727,56546,56569,56571,57572,57573,57846,57847,57993,58291,58396,58749,58815,58877,58880,58881,58882,58883,58884,58987,58994,58995,58996,58997,58998,58999,59019,59063,59404,59628,59629,59630,59631,59632,59682,59919,60166,60917,61418,61536,61582,61630,61631,61794,62099,62386,62412,62440,62680,62681,62940,62941,63073,63088,63089,63090,63091,63092,63093,63094,63095,63096,63097,63098,63099,63100,63101,63102,63103,63104,63105,63106,63166,63167,63168,63169,63745,63826,63860,63950,64037,64557,65052,65294,65472,65927,65933,66276,66756,66757,66956,67599,67646,67774,67868,67897,68007,68428,68484,68526,68529,68698,69383,69420,70068,70069,70158,70385,70386,70387,70388,70389,70390,70475,70960,70961,71080,71138,71163,71223,71228,72035,72037,72726,72795,72820,72821,72822,72828,72829,72830,72831,72832,72833,72834,72835,72836,72930,74391,75868,76081,76587,76725,77449,77597,87013,87267,87398,87402,87940,88137,88769,89391,89565,90420,90421,90791,91640,92963,93065,93849,94581,95045,95454,95462,96117,96130,96131,96192,99095,99112,99348,101338,101565,101673,101744,102100,102692,103543,103659,103696,104804,104818,104878,105367,105662,105796,105864,106282,106708,106727,106958,107293,107294,107949,107951,107953,108172,108222,108232,108867,109030,109423,109436,109708,109720,109765,109793,109821,109845,109848,109983,110172,110331,110669,110917,111320,111324,111325,111683,111685,111947,112488,112544,112547,112669,112935,112936,112981,112982,113475,113677,113686,113742,114062,114063,114141,114147,114209,114458,114657,115204,115551,115928,116128,116193,116494,116696,116783,116890,117178,117432,117503,117765,117816,117886,118021,118048,118108,118233,118324,118573,119255,119256,119823,120241,120480,121734,121780,121837,121919,122882,123794,123811,124252,124954,124955,125360,125362,125446,125795,126056,126285,126606,127231,127336,127525,127943,128076,128143,128284,128364,128404,128468,128495,128524,128706,128940,129168,129312,131632,131675,131887,131888,131986,131988,131989,131990,132042,132044,132389,132581,132650,132775,132776,132927,132945,133182,133183,133227,133471,133595,133596,133774,134778,135079,135193,135835,135840,136291,136687,136690,137189,137253,137335,137683,137715,137746,137748,137813,137914,137915,137916,137930,138250,138438,138512,138694,139314,139682,140279,140926,141315,141493,141622,141892,142143,142163,142264,142545,143328,143329,143431,143443,143832,143839,144031,144053,144101,144249,144348,144349,144404,144413,144463,144467,144564,145155,145163,145213,145330,145384,145424,145432,145545,145546,145555,145583,145587,145945,145949,145969,146176,146251,146276,146465,146667,146738,147067,147081,147104,147168,147462,147487,147562,147644,147719,147951,147997,148227,148351,148421,148442,148602,148641,148645,148677,148718,148886,148887,149196,149229,149299,149376,149594,149745,149826,149835,150013,150066,150070,150074,150084,150138,150139,150140,150202,150276,150559,150680,150852,151246,151392,151551,151553,151566,151666,151684,151934,151942,151981,151985,152009,152072,152185,152303,152867,153096,154573,154720,154852,155250,155517,156374,157225,157481,157495,157867,157995,158040,158164,158311,158320,158431,158726,158858,158927,158928,159007,159160,159283,159288,159329,159448,159470,159737,159837,159873,159931,159932,159962,159966,159970,160289,160312,160369,160376,160418,160429,160610,161803,161819,162687,163033,163076,163579,163611,163852,163898,163899,164684,164840,164933,164936,165058,165171,165199,165202,165427,165542,165733,166007,166643,166878,167411,168378,168794,169387,169391,169812,170286,170315,170324,170349,170393,170789,170889,170969,171033,171092,172099,172311,172354,172476,172530,172862,172912,173014,173274,173554,173582,173588,173825,173828,173829,173835,173838,173839,173843,174334,174886,175054,175076,175100,175102,175411,175948,176005,176267,176839,177382,177388,177515,177632,177684,177781,177813,177909,177976,178043,178315,179316,179960,180316,181334,181336,181426,182180,182210,182366,183277,183519,183542,183547,183639,183856,183866,184527,185184,185228,185560,186160,186306,186330,186509,187562,187828,188391,189284,189661,190825,191696,193308,193412,196571,197305,199090) GROUP BY sold_month ORDER BY scs.date_actual_sold |
79 | Creole | executeQuery(): [38.24 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 (27718,27719,27748,27783,27784,27785,27787,27788,27789,27809,27810,27811,27836,27837,27838,27997,28110,28111,28112,28113,28114,28115,28116,28117,28138,28158,28159,28210,28212,28213,28235,28299,28302,28389,28515,28516,28517,28600,28601,28602,28603,28644,28645,28659,28660,28661,28663,28815,28816,28817,28818,28819,28820,28821,28822,28846,28852,28853,28887,28888,28889,28915,28974,29026,29097,29148,29199,29200,29275,29276,29277,29278,29279,29280,29281,29282,29303,29304,29317,29332,29333,29436,29484,29485,29486,29488,29489,29490,29491,29492,29493,29494,29495,29496,29497,29498,29499,29500,29513,29571,29574,29756,29834,29848,29875,29974,29975,29988,30023,30044,30060,30061,30064,30065,30066,30146,30147,30199,30200,30201,30202,30203,30661,30662,30663,30664,30665,30666,30667,30668,30669,30670,30671,30672,30673,30674,30675,30676,30677,30678,30679,30680,30681,30682,30683,30684,30685,30687,30749,30752,30755,30756,30757,30759,30760,30761,30762,31222,31288,31482,31483,31984,32001,32003,32256,32257,32262,32592,32612,32887,32999,33024,33085,33201,33242,33427,33433,33507,33692,33696,33745,33767,33789,33870,33888,33893,33901,33903,33904,33906,33907,33908,33909,33910,33911,33912,33913,33914,33915,33927,33929,33938,34162,34163,34181,34269,34328,34335,34337,34338,34341,34342,34345,34350,34351,34352,34354,34355,34356,34357,34359,34360,34364,34369,34370,34373,34405,34431,34499,34505,34506,34507,34509,34512,34530,34557,34562,34849,34885,34886,34966,34967,34973,35242,35280,35362,35640,35706,36159,36176,36624,36739,36816,36880,36928,36930,36960,37009,37086,37094,38674,38675,38676,38914,39312,39315,39368,39677,39692,39693,41915,41925,41968,42023,42470,42471,42552,42627,43046,43080,43358,43776,43843,43851,43859,43942,44098,44396,44778,44781,44839,45245,45246,45247,45248,45249,45250,45251,45252,45253,45254,45255,45256,45257,45258,45259,45312,45378,45379,45380,45476,45534,45557,45567,45568,45569,45570,45571,45572,45573,45600,45744,46062,46222,46223,46226,46271,46279,46311,46312,46471,46962,46963,46964,46980,47062,47093,47156,47467,47753,47799,47829,47852,47859,47930,48291,48375,48594,48861,48862,48863,48959,48960,48961,49002,49058,49059,49122,49314,49378,49481,49490,49517,49718,49754,49783,49817,49833,49834,49835,49836,49837,49838,49839,49840,49841,49842,49843,49844,49845,49846,49847,49848,49849,49868,49871,49875,49876,49877,49878,49988,50660,50787,50901,51038,51096,51112,51909,51940,51941,52015,52027,52206,52503,52588,52964,53010,53135,53226,53315,53558,53559,53637,53638,53738,53769,53770,53836,54116,54123,54346,54420,54742,54786,54802,54847,55404,55727,56546,56569,56571,57572,57573,57846,57847,57993,58291,58396,58749,58815,58877,58880,58881,58882,58883,58884,58987,58994,58995,58996,58997,58998,58999,59019,59063,59404,59628,59629,59630,59631,59632,59682,59919,60166,60917,61418,61536,61582,61630,61631,61794,62099,62386,62412,62440,62680,62681,62940,62941,63073,63088,63089,63090,63091,63092,63093,63094,63095,63096,63097,63098,63099,63100,63101,63102,63103,63104,63105,63106,63166,63167,63168,63169,63745,63826,63860,63950,64037,64557,65052,65294,65472,65927,65933,66276,66756,66757,66956,67599,67646,67774,67868,67897,68007,68428,68484,68526,68529,68698,69383,69420,70068,70069,70158,70385,70386,70387,70388,70389,70390,70475,70960,70961,71080,71138,71163,71223,71228,72035,72037,72726,72795,72820,72821,72822,72828,72829,72830,72831,72832,72833,72834,72835,72836,72930,74391,75868,76081,76587,76725,77449,77597,87013,87267,87398,87402,87940,88137,88769,89391,89565,90420,90421,90791,91640,92963,93065,93849,94581,95045,95454,95462,96117,96130,96131,96192,99095,99112,99348,101338,101565,101673,101744,102100,102692,103543,103659,103696,104804,104818,104878,105367,105662,105796,105864,106282,106708,106727,106958,107293,107294,107949,107951,107953,108172,108222,108232,108867,109030,109423,109436,109708,109720,109765,109793,109821,109845,109848,109983,110172,110331,110669,110917,111320,111324,111325,111683,111685,111947,112488,112544,112547,112669,112935,112936,112981,112982,113475,113677,113686,113742,114062,114063,114141,114147,114209,114458,114657,115204,115551,115928,116128,116193,116494,116696,116783,116890,117178,117432,117503,117765,117816,117886,118021,118048,118108,118233,118324,118573,119255,119256,119823,120241,120480,121734,121780,121837,121919,122882,123794,123811,124252,124954,124955,125360,125362,125446,125795,126056,126285,126606,127231,127336,127525,127943,128076,128143,128284,128364,128404,128468,128495,128524,128706,128940,129168,129312,131632,131675,131887,131888,131986,131988,131989,131990,132042,132044,132389,132581,132650,132775,132776,132927,132945,133182,133183,133227,133471,133595,133596,133774,134778,135079,135193,135835,135840,136291,136687,136690,137189,137253,137335,137683,137715,137746,137748,137813,137914,137915,137916,137930,138250,138438,138512,138694,139314,139682,140279,140926,141315,141493,141622,141892,142143,142163,142264,142545,143328,143329,143431,143443,143832,143839,144031,144053,144101,144249,144348,144349,144404,144413,144463,144467,144564,145155,145163,145213,145330,145384,145424,145432,145545,145546,145555,145583,145587,145945,145949,145969,146176,146251,146276,146465,146667,146738,147067,147081,147104,147168,147462,147487,147562,147644,147719,147951,147997,148227,148351,148421,148442,148602,148641,148645,148677,148718,148886,148887,149196,149229,149299,149376,149594,149745,149826,149835,150013,150066,150070,150074,150084,150138,150139,150140,150202,150276,150559,150680,150852,151246,151392,151551,151553,151566,151666,151684,151934,151942,151981,151985,152009,152072,152185,152303,152867,153096,154573,154720,154852,155250,155517,156374,157225,157481,157495,157867,157995,158040,158164,158311,158320,158431,158726,158858,158927,158928,159007,159160,159283,159288,159329,159448,159470,159737,159837,159873,159931,159932,159962,159966,159970,160289,160312,160369,160376,160418,160429,160610,161803,161819,162687,163033,163076,163579,163611,163852,163898,163899,164684,164840,164933,164936,165058,165171,165199,165202,165427,165542,165733,166007,166643,166878,167411,168378,168794,169387,169391,169812,170286,170315,170324,170349,170393,170789,170889,170969,171033,171092,172099,172311,172354,172476,172530,172862,172912,173014,173274,173554,173582,173588,173825,173828,173829,173835,173838,173839,173843,174334,174886,175054,175076,175100,175102,175411,175948,176005,176267,176839,177382,177388,177515,177632,177684,177781,177813,177909,177976,178043,178315,179316,179960,180316,181334,181336,181426,182180,182210,182366,183277,183519,183542,183547,183639,183856,183866,184527,185184,185228,185560,186160,186306,186330,186509,187562,187828,188391,189284,189661,190825,191696,193308,193412,196571,197305,199090) 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(): [1844.68 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.71 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199879 |
108 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
109 | Creole | executeQuery(): [0.68 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199183 |
110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
111 | Creole | executeQuery(): [0.56 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199010 |
112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
113 | Creole | executeQuery(): [0.54 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198896 |
114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
115 | Creole | executeQuery(): [0.73 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197950 |
116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
117 | Creole | executeQuery(): [0.76 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=142338 |
118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
119 | Creole | executeQuery(): [0.67 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=141261 |
120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
121 | Creole | executeQuery(): [0.69 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=139233 |
122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
123 | Creole | executeQuery(): [0.67 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=131379 |
124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
125 | Creole | executeQuery(): [0.67 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=131377 |
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: 131378 action: view id: 131378 make: other model: other 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: 1735246839.1208 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: care_did: 28433529-98a1-48bf-b7b4-e92eea3fa83b fikker-InIR-Qh5V: mbyZOTi0cx3R3LgZidkBShUMQdqPNMmO env: files: get: post: server: CONTENT_LENGTH: CONTENT_TYPE: DOCUMENT_ROOT: /web/classicdigest.com/web DOCUMENT_URI: /cars/index_dev.php/other/other/131378 FCGI_ROLE: RESPONDER GATEWAY_INTERFACE: CGI/1.1 HOME: /var/lib/nginx HTTPS: on HTTP_ACCEPT: */* HTTP_ACCEPT_ENCODING: gzip, br, zstd, deflate HTTP_COOKIE: care_did=28433529-98a1-48bf-b7b4-e92eea3fa83b; fikker-InIR-Qh5V=mbyZOTi0cx3R3LgZidkBShUMQdqPNMmO HTTP_HOST: www.classicdigest.com HTTP_REFERER: https://classicdigest.com/cars/index_dev.php/other/other/131378 HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) PATH_INFO: /other/other/131378 PATH_TRANSLATED: /web/classicdigest.com/web/other/other/131378 PHP_SELF: /cars/index_dev.php/other/other/131378 QUERY_STRING: REDIRECT_STATUS: 200 REMOTE_ADDR: 18.117.184.125 REMOTE_PORT: 1136 REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1735246839 REQUEST_TIME_FLOAT: 1735246839.1195 REQUEST_URI: /cars/index_dev.php/other/other/131378 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.63 |
Action "home/view" | 1 | 2235.59 |
Database | 34 | 2180.29 |
View "Success" for "home/view" | 1 | 58.06 |
Partial "home/_vif_images" | 1 | 0.62 |
Partial "common_page/_social_buttons" | 1 | 0.09 |
Partial "home/_vif_info" | 1 | 0.17 |
Partial "home/_hoover_user_info" | 1 | 0.09 |
Partial "common_page/_price_development_graph" | 1 | 0.07 |
Partial "common_page/_sell_time_price_graph" | 1 | 0.06 |
Partial "common_page/_price_gauge_graph" | 1 | 0.06 |
Partial "common_page/_include_vif_js" | 1 | 0.09 |
Partial "common_page/_fancybox_javascript" | 2 | 0.21 |
Partial "common_page/_responsive_javascript" | 1 | 0.06 |
Partial "common_page/_google_analytics" | 1 | 0.06 |
Partial "common_page/_header_links" | 1 | 0.82 |
Partial "common_page/_cookie_policy" | 1 | 0.10 |
Partial "common_page/_responsive_top_menu" | 1 | 0.16 |
Partial "common_page/_top_menu" | 1 | 0.16 |
Partial "common_page/_footer_javascript" | 1 | 0.13 |
Partial "common_page/_footer" | 1 | 0.12 |