# |
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' => 'other', 'id' => '199327', '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.39 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=199327 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.98 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 (1873) |
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(): [0.84 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=199327 |
38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
39 | Creole | executeQuery(): [0.73 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=199327 |
40 | Creole | prepareStatement(): SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=? AND fa_payment_order.PAYMENT_STATUS=? AND fa_payment_order.UPSELLS_TAKEN=? |
41 | Creole | executeQuery(): [0.63 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=199327 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2' |
42 | Creole | prepareStatement(): SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID=? |
43 | Creole | executeQuery(): [0.53 ms] SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID='1' |
44 | Creole | prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199327) ORDER BY carimg.ORD ASC |
45 | Creole | executeQuery(): [0.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 (199327) ORDER BY carimg.ORD ASC |
46 | Creole | prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?) |
47 | Creole | executeQuery(): [0.57 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 (1873) |
48 | 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 |
49 | Creole | executeQuery(): [0.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=63 AND model.ID=764 AND make.ID=model.ID_MAKE |
50 | 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 != 199327 AND car.ID_MODEL = '764' ) 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 != 199327 AND car.ID_MODEL = '764' ) ORDER BY ID DESC |
51 | 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 != 199327 AND car.ID_MODEL = '764' ) 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 != 199327 AND car.ID_MODEL = '764' ) ) AS count |
52 | Creole | executeQuery(): [3.59 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 != 199327 AND car.ID_MODEL = '764' ) 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 != 199327 AND car.ID_MODEL = '764' ) ) AS count |
53 | 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 != 199327 AND car.ID_MODEL = '764' ) 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 != 199327 AND car.ID_MODEL = '764' ) ORDER BY ID DESC, offset: 0, limit: 5 |
54 | Creole | executeQuery(): [4.48 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 != 199327 AND car.ID_MODEL = '764' ) 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 != 199327 AND car.ID_MODEL = '764' ) ORDER BY ID DESC LIMIT 5 |
55 | 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 (199535,198754,198671,197235,195580) ORDER BY carimg.ORD ASC |
56 | Creole | executeQuery(): [0.98 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 (199535,198754,198671,197235,195580) ORDER BY carimg.ORD ASC |
57 | 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 != '199327' AND car.ID_NETTI_USER = '1873' ) 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 != '199327' AND car.ID_NETTI_USER = '1873' ) ORDER BY ID DESC |
58 | 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 != '199327' AND car.ID_NETTI_USER = '1873' ) 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 != '199327' AND car.ID_NETTI_USER = '1873' ) ) AS count |
59 | Creole | executeQuery(): [1.05 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 != '199327' AND car.ID_NETTI_USER = '1873' ) 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 != '199327' AND car.ID_NETTI_USER = '1873' ) ) AS count |
60 | Creole | prepareStatement(): SELECT car.ID FROM car WHERE car.ID_MAKE=? AND car.ID_MODEL=? AND car.STATUS=? |
61 | Creole | executeQuery(): [2.06 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=63 AND car.ID_MODEL=764 AND car.STATUS='F' |
62 | Creole | prepareStatement(): SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=? AND sold_car.ID_MODEL=? AND sold_car.STATUS=? |
63 | Creole | executeQuery(): [54.71 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=63 AND sold_car.ID_MODEL=764 AND sold_car.STATUS='S' |
64 | 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 (23073,27825,28247,28248,66498,72934,72935,124641,142214,142431,145115,149296,154302,162166,175412,176635,178450,181401,184717,184747,191954,193750,195491,195580,197235,198671,198754,199327,199535) GROUP BY cmonth ORDER BY date_create |
65 | Creole | executeQuery(): [1.15 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 (23073,27825,28247,28248,66498,72934,72935,124641,142214,142431,145115,149296,154302,162166,175412,176635,178450,181401,184717,184747,191954,193750,195491,195580,197235,198671,198754,199327,199535) GROUP BY cmonth ORDER BY date_create |
66 | 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 (20440,20443,21703,22495,22496,22498,22499,22501,22503,22512,22513,22514,22515,22516,22517,22524,22554,22559,22661,22673,22677,22690,22691,22712,22739,22741,22742,22762,22798,22809,22813,22814,22856,22860,22869,22880,22894,22915,22917,22920,22941,22942,22943,22945,22947,22948,22949,22950,22952,22954,22958,22960,22996,23023,23024,23025,23037,23043,23047,23048,23055,23064,23074,23077,23088,23093,23104,23117,23129,23137,23138,23152,23158,23159,23175,23186,23196,23198,23199,23204,23206,23216,23217,23543,23674,23828,23844,23846,23864,24044,24093,24134,24155,24294,24296,24298,24300,24303,24304,24305,24308,24554,24555,24556,24680,25126,25139,25651,25676,26043,26044,26048,26155,27347,27739,27740,27794,27850,27948,27949,27950,27951,27952,27955,27957,27958,27959,27960,27965,27966,28080,28219,28220,28221,28222,28246,28649,28753,28862,28863,28864,28921,29154,29156,29207,29208,29210,29247,29248,29249,29592,29594,29595,29596,29626,29627,29628,29629,29639,29844,29881,29882,29977,30037,30196,30208,30290,30291,30383,30886,30940,31242,31243,31966,32396,32484,32485,32486,33013,33036,33045,33086,33207,33236,33275,33748,34037,34501,34830,35018,35023,35048,36956,38994,39382,39700,41932,42687,42688,43898,43956,44441,45387,45388,45627,46232,46233,46283,46487,46779,47032,47746,48453,48835,48888,49507,49697,50264,50537,50538,51601,52644,53750,53986,54005,55473,56005,56026,56030,56033,56034,56035,56036,56038,56041,56045,56049,56052,56053,56241,56443,56472,56607,56700,56717,56746,56785,56814,56819,56823,56825,56829,56836,56839,56843,56848,56915,56946,56962,56963,56966,56967,56968,56970,57432,58133,58134,58138,58141,58143,58146,58149,58150,58154,58155,58167,58196,58283,58303,58305,58317,58318,58321,58322,58325,58328,58338,58339,58372,58377,58415,58416,58417,58419,58423,58429,58430,58431,58437,58438,58439,58441,58444,58451,58452,58453,58454,58455,58462,58466,58468,58469,58516,58748,58821,58822,58823,60678,60685,60688,60847,61361,61645,61715,61716,61717,61822,61873,62101,63231,63735,63742,64051,64053,64409,64429,64558,64613,65430,65663,65687,65690,65740,65793,66900,68569,68623,69295,69486,69565,71068,71207,71225,71273,71283,71762,71771,71801,72051,72087,72552,72843,72932,74974,87159,88807,89592,91828,95382,98704,99302,105270,105762,107960,109435,109855,112969,114757,116294,116371,120540,121593,121681,124315,124628,124630,124631,124632,124633,124634,124635,124636,124637,124638,124639,124640,124642,124643,124644,124645,124646,124647,124648,124649,124650,124652,124653,126456,126911,127222,128855,128963,133398,134044,134045,135065,136117,137720,138943,139347,140868,143247,143675,144453,144823,145112,145120,145435,146214,147828,148361,149295,149680,149957,150035,150422,150511,151676,152042,155031,155373,156277,156816,158254,158255,159074,159360,159361,159660,159661,159943,160539,161972,161973,161974,162178,163242,163369,164129,164627,164628,165011,165274,165306,165373,165559,166651,168352,168685,168989,169160,170095,170830,173511,173976,174846,177810,178822,179667,180270,181043,182215,182273,183060,184121,184746,185034,185035,185329,186112,187497,187891,188034,188334,188703,188704,188953,188954,189041,190014,191302,191487,192622,192877,193853,195660) GROUP BY sold_week ORDER BY scs.date_actual_sold |
67 | Creole | executeQuery(): [5.58 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 (20440,20443,21703,22495,22496,22498,22499,22501,22503,22512,22513,22514,22515,22516,22517,22524,22554,22559,22661,22673,22677,22690,22691,22712,22739,22741,22742,22762,22798,22809,22813,22814,22856,22860,22869,22880,22894,22915,22917,22920,22941,22942,22943,22945,22947,22948,22949,22950,22952,22954,22958,22960,22996,23023,23024,23025,23037,23043,23047,23048,23055,23064,23074,23077,23088,23093,23104,23117,23129,23137,23138,23152,23158,23159,23175,23186,23196,23198,23199,23204,23206,23216,23217,23543,23674,23828,23844,23846,23864,24044,24093,24134,24155,24294,24296,24298,24300,24303,24304,24305,24308,24554,24555,24556,24680,25126,25139,25651,25676,26043,26044,26048,26155,27347,27739,27740,27794,27850,27948,27949,27950,27951,27952,27955,27957,27958,27959,27960,27965,27966,28080,28219,28220,28221,28222,28246,28649,28753,28862,28863,28864,28921,29154,29156,29207,29208,29210,29247,29248,29249,29592,29594,29595,29596,29626,29627,29628,29629,29639,29844,29881,29882,29977,30037,30196,30208,30290,30291,30383,30886,30940,31242,31243,31966,32396,32484,32485,32486,33013,33036,33045,33086,33207,33236,33275,33748,34037,34501,34830,35018,35023,35048,36956,38994,39382,39700,41932,42687,42688,43898,43956,44441,45387,45388,45627,46232,46233,46283,46487,46779,47032,47746,48453,48835,48888,49507,49697,50264,50537,50538,51601,52644,53750,53986,54005,55473,56005,56026,56030,56033,56034,56035,56036,56038,56041,56045,56049,56052,56053,56241,56443,56472,56607,56700,56717,56746,56785,56814,56819,56823,56825,56829,56836,56839,56843,56848,56915,56946,56962,56963,56966,56967,56968,56970,57432,58133,58134,58138,58141,58143,58146,58149,58150,58154,58155,58167,58196,58283,58303,58305,58317,58318,58321,58322,58325,58328,58338,58339,58372,58377,58415,58416,58417,58419,58423,58429,58430,58431,58437,58438,58439,58441,58444,58451,58452,58453,58454,58455,58462,58466,58468,58469,58516,58748,58821,58822,58823,60678,60685,60688,60847,61361,61645,61715,61716,61717,61822,61873,62101,63231,63735,63742,64051,64053,64409,64429,64558,64613,65430,65663,65687,65690,65740,65793,66900,68569,68623,69295,69486,69565,71068,71207,71225,71273,71283,71762,71771,71801,72051,72087,72552,72843,72932,74974,87159,88807,89592,91828,95382,98704,99302,105270,105762,107960,109435,109855,112969,114757,116294,116371,120540,121593,121681,124315,124628,124630,124631,124632,124633,124634,124635,124636,124637,124638,124639,124640,124642,124643,124644,124645,124646,124647,124648,124649,124650,124652,124653,126456,126911,127222,128855,128963,133398,134044,134045,135065,136117,137720,138943,139347,140868,143247,143675,144453,144823,145112,145120,145435,146214,147828,148361,149295,149680,149957,150035,150422,150511,151676,152042,155031,155373,156277,156816,158254,158255,159074,159360,159361,159660,159661,159943,160539,161972,161973,161974,162178,163242,163369,164129,164627,164628,165011,165274,165306,165373,165559,166651,168352,168685,168989,169160,170095,170830,173511,173976,174846,177810,178822,179667,180270,181043,182215,182273,183060,184121,184746,185034,185035,185329,186112,187497,187891,188034,188334,188703,188704,188953,188954,189041,190014,191302,191487,192622,192877,193853,195660) GROUP BY sold_week ORDER BY scs.date_actual_sold |
68 | 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 (20440,20443,21703,22495,22496,22498,22499,22501,22503,22512,22513,22514,22515,22516,22517,22524,22554,22559,22661,22673,22677,22690,22691,22712,22739,22741,22742,22762,22798,22809,22813,22814,22856,22860,22869,22880,22894,22915,22917,22920,22941,22942,22943,22945,22947,22948,22949,22950,22952,22954,22958,22960,22996,23023,23024,23025,23037,23043,23047,23048,23055,23064,23074,23077,23088,23093,23104,23117,23129,23137,23138,23152,23158,23159,23175,23186,23196,23198,23199,23204,23206,23216,23217,23543,23674,23828,23844,23846,23864,24044,24093,24134,24155,24294,24296,24298,24300,24303,24304,24305,24308,24554,24555,24556,24680,25126,25139,25651,25676,26043,26044,26048,26155,27347,27739,27740,27794,27850,27948,27949,27950,27951,27952,27955,27957,27958,27959,27960,27965,27966,28080,28219,28220,28221,28222,28246,28649,28753,28862,28863,28864,28921,29154,29156,29207,29208,29210,29247,29248,29249,29592,29594,29595,29596,29626,29627,29628,29629,29639,29844,29881,29882,29977,30037,30196,30208,30290,30291,30383,30886,30940,31242,31243,31966,32396,32484,32485,32486,33013,33036,33045,33086,33207,33236,33275,33748,34037,34501,34830,35018,35023,35048,36956,38994,39382,39700,41932,42687,42688,43898,43956,44441,45387,45388,45627,46232,46233,46283,46487,46779,47032,47746,48453,48835,48888,49507,49697,50264,50537,50538,51601,52644,53750,53986,54005,55473,56005,56026,56030,56033,56034,56035,56036,56038,56041,56045,56049,56052,56053,56241,56443,56472,56607,56700,56717,56746,56785,56814,56819,56823,56825,56829,56836,56839,56843,56848,56915,56946,56962,56963,56966,56967,56968,56970,57432,58133,58134,58138,58141,58143,58146,58149,58150,58154,58155,58167,58196,58283,58303,58305,58317,58318,58321,58322,58325,58328,58338,58339,58372,58377,58415,58416,58417,58419,58423,58429,58430,58431,58437,58438,58439,58441,58444,58451,58452,58453,58454,58455,58462,58466,58468,58469,58516,58748,58821,58822,58823,60678,60685,60688,60847,61361,61645,61715,61716,61717,61822,61873,62101,63231,63735,63742,64051,64053,64409,64429,64558,64613,65430,65663,65687,65690,65740,65793,66900,68569,68623,69295,69486,69565,71068,71207,71225,71273,71283,71762,71771,71801,72051,72087,72552,72843,72932,74974,87159,88807,89592,91828,95382,98704,99302,105270,105762,107960,109435,109855,112969,114757,116294,116371,120540,121593,121681,124315,124628,124630,124631,124632,124633,124634,124635,124636,124637,124638,124639,124640,124642,124643,124644,124645,124646,124647,124648,124649,124650,124652,124653,126456,126911,127222,128855,128963,133398,134044,134045,135065,136117,137720,138943,139347,140868,143247,143675,144453,144823,145112,145120,145435,146214,147828,148361,149295,149680,149957,150035,150422,150511,151676,152042,155031,155373,156277,156816,158254,158255,159074,159360,159361,159660,159661,159943,160539,161972,161973,161974,162178,163242,163369,164129,164627,164628,165011,165274,165306,165373,165559,166651,168352,168685,168989,169160,170095,170830,173511,173976,174846,177810,178822,179667,180270,181043,182215,182273,183060,184121,184746,185034,185035,185329,186112,187497,187891,188034,188334,188703,188704,188953,188954,189041,190014,191302,191487,192622,192877,193853,195660) GROUP BY sold_month ORDER BY scs.date_actual_sold |
69 | Creole | executeQuery(): [7.83 ms] SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sc.id IN (20440,20443,21703,22495,22496,22498,22499,22501,22503,22512,22513,22514,22515,22516,22517,22524,22554,22559,22661,22673,22677,22690,22691,22712,22739,22741,22742,22762,22798,22809,22813,22814,22856,22860,22869,22880,22894,22915,22917,22920,22941,22942,22943,22945,22947,22948,22949,22950,22952,22954,22958,22960,22996,23023,23024,23025,23037,23043,23047,23048,23055,23064,23074,23077,23088,23093,23104,23117,23129,23137,23138,23152,23158,23159,23175,23186,23196,23198,23199,23204,23206,23216,23217,23543,23674,23828,23844,23846,23864,24044,24093,24134,24155,24294,24296,24298,24300,24303,24304,24305,24308,24554,24555,24556,24680,25126,25139,25651,25676,26043,26044,26048,26155,27347,27739,27740,27794,27850,27948,27949,27950,27951,27952,27955,27957,27958,27959,27960,27965,27966,28080,28219,28220,28221,28222,28246,28649,28753,28862,28863,28864,28921,29154,29156,29207,29208,29210,29247,29248,29249,29592,29594,29595,29596,29626,29627,29628,29629,29639,29844,29881,29882,29977,30037,30196,30208,30290,30291,30383,30886,30940,31242,31243,31966,32396,32484,32485,32486,33013,33036,33045,33086,33207,33236,33275,33748,34037,34501,34830,35018,35023,35048,36956,38994,39382,39700,41932,42687,42688,43898,43956,44441,45387,45388,45627,46232,46233,46283,46487,46779,47032,47746,48453,48835,48888,49507,49697,50264,50537,50538,51601,52644,53750,53986,54005,55473,56005,56026,56030,56033,56034,56035,56036,56038,56041,56045,56049,56052,56053,56241,56443,56472,56607,56700,56717,56746,56785,56814,56819,56823,56825,56829,56836,56839,56843,56848,56915,56946,56962,56963,56966,56967,56968,56970,57432,58133,58134,58138,58141,58143,58146,58149,58150,58154,58155,58167,58196,58283,58303,58305,58317,58318,58321,58322,58325,58328,58338,58339,58372,58377,58415,58416,58417,58419,58423,58429,58430,58431,58437,58438,58439,58441,58444,58451,58452,58453,58454,58455,58462,58466,58468,58469,58516,58748,58821,58822,58823,60678,60685,60688,60847,61361,61645,61715,61716,61717,61822,61873,62101,63231,63735,63742,64051,64053,64409,64429,64558,64613,65430,65663,65687,65690,65740,65793,66900,68569,68623,69295,69486,69565,71068,71207,71225,71273,71283,71762,71771,71801,72051,72087,72552,72843,72932,74974,87159,88807,89592,91828,95382,98704,99302,105270,105762,107960,109435,109855,112969,114757,116294,116371,120540,121593,121681,124315,124628,124630,124631,124632,124633,124634,124635,124636,124637,124638,124639,124640,124642,124643,124644,124645,124646,124647,124648,124649,124650,124652,124653,126456,126911,127222,128855,128963,133398,134044,134045,135065,136117,137720,138943,139347,140868,143247,143675,144453,144823,145112,145120,145435,146214,147828,148361,149295,149680,149957,150035,150422,150511,151676,152042,155031,155373,156277,156816,158254,158255,159074,159360,159361,159660,159661,159943,160539,161972,161973,161974,162178,163242,163369,164129,164627,164628,165011,165274,165306,165373,165559,166651,168352,168685,168989,169160,170095,170830,173511,173976,174846,177810,178822,179667,180270,181043,182215,182273,183060,184121,184746,185034,185035,185329,186112,187497,187891,188034,188334,188703,188704,188953,188954,189041,190014,191302,191487,192622,192877,193853,195660) GROUP BY sold_month ORDER BY scs.date_actual_sold |
70 | 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 |
71 | Creole | executeQuery(): [2742.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 |
72 | Action | change layout to "view_layout" |
73 | View | initialize view for "home/view" |
74 | View | render "sf_app_dir/modules/home/templates/viewSuccess.php" |
75 | View | initialize view for "home/_vif_images" |
76 | View | render "sf_app_dir/modules/home/templates/_vif_images.php" |
77 | PartialHelper | Generate cache key |
78 | View | initialize view for "common_page/_social_buttons" |
79 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php" |
80 | PartialHelper | Generate cache key |
81 | View | initialize view for "home/_vif_info" |
82 | View | render "sf_app_dir/modules/home/templates/_vif_info.php" |
83 | PartialHelper | Generate cache key |
84 | View | initialize view for "home/_owner_info" |
85 | View | render "sf_app_dir/modules/home/templates/_owner_info.php" |
86 | PartialHelper | Generate cache key |
87 | View | initialize view for "common_page/_price_development_graph" |
88 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php" |
89 | PartialHelper | Generate cache key |
90 | View | initialize view for "common_page/_sell_time_price_graph" |
91 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php" |
92 | PartialHelper | Generate cache key |
93 | View | initialize view for "common_page/_price_gauge_graph" |
94 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php" |
95 | PartialHelper | Generate cache key |
96 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
97 | Creole | executeQuery(): [4.87 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199535 |
98 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
99 | Creole | executeQuery(): [6.80 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198754 |
100 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
101 | Creole | executeQuery(): [6.17 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198671 |
102 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
103 | Creole | executeQuery(): [0.55 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197235 |
104 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
105 | Creole | executeQuery(): [4.21 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=195580 |
106 | View | initialize view for "common_page/_include_vif_js" |
107 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_include_vif_js.php" |
108 | PartialHelper | Generate cache key |
109 | View | initialize view for "common_page/_fancybox_javascript" |
110 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php" |
111 | PartialHelper | Generate cache key |
112 | View | decorate content with "sf_app_dir/templates/view_layout.php" |
113 | View | render "sf_app_dir/templates/view_layout.php" |
114 | View | initialize view for "common_page/_responsive_javascript" |
115 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_javascript.php" |
116 | PartialHelper | Generate cache key |
117 | View | initialize view for "common_page/_google_analytics" |
118 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_google_analytics.php" |
119 | PartialHelper | Generate cache key |
120 | View | initialize view for "common_page/_header_links" |
121 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_header_links.php" |
122 | View | initialize view for "common_page/_fancybox_javascript" |
123 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php" |
124 | PartialHelper | Generate cache key |
125 | View | initialize view for "common_page/_cookie_policy" |
126 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_cookie_policy.php" |
127 | PartialHelper | Generate cache key |
128 | PartialHelper | Generate cache key |
129 | View | initialize view for "common_page/_responsive_top_menu" |
130 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_top_menu.php" |
131 | PartialHelper | Generate cache key |
132 | View | initialize view for "common_page/_top_menu" |
133 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_top_menu.php" |
134 | PartialHelper | Generate cache key |
135 | View | initialize view for "common_page/_footer_javascript" |
136 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer_javascript.php" |
137 | PartialHelper | Generate cache key |
138 | View | initialize view for "common_page/_footer" |
139 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer.php" |
140 | PartialHelper | Generate cache key |