# |
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' => 'porsche', 'model' => '912', 'id' => '192976', '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(): [0.99 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=192976 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.37 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 (1581) |
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.33 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=192976 |
38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
39 | Creole | executeQuery(): [1.83 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=192976 |
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(): [3.84 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=192976 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.87 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 (192976) ORDER BY carimg.ORD ASC |
45 | Creole | executeQuery(): [1.86 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 (192976) 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.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 (1581) |
48 | Creole | prepareStatement(): SELECT netti_dealer.ID_DEALER, netti_dealer.ID, netti_dealer.PATH, netti_dealer.COMPANY, netti_dealer.SLOGAN, netti_dealer.URL, netti_dealer.SIMPLE_URL, netti_dealer.HAS_SITE FROM netti_dealer WHERE netti_dealer.ID_DEALER IN (?) |
49 | Creole | executeQuery(): [0.43 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 (1581) |
50 | Creole | prepareStatement(): SELECT dealer.ID_MAKE, dealer.HIT_COUNTER FROM dealer WHERE dealer.ID_DEALER=? |
51 | Creole | executeQuery(): [0.48 ms] SELECT dealer.ID_MAKE, dealer.HIT_COUNTER FROM dealer WHERE dealer.ID_DEALER=1581 |
52 | Creole | prepareStatement(): SELECT netti_dealer.HAS_SITE, netti_dealer.SIMPLE_URL, netti_dealer.SLOGAN FROM netti_dealer WHERE netti_dealer.ID_DEALER=? |
53 | Creole | executeQuery(): [0.31 ms] SELECT netti_dealer.HAS_SITE, netti_dealer.SIMPLE_URL, netti_dealer.SLOGAN FROM netti_dealer WHERE netti_dealer.ID_DEALER=1581 |
54 | Creole | prepareStatement(): SELECT dealer_permission.ID, dealer_permission.ID_DEALER, dealer_permission.WHICH, dealer_permission.DATE_CREATE FROM dealer_permission WHERE dealer_permission.ID_DEALER=? |
55 | Creole | executeQuery(): [0.54 ms] SELECT dealer_permission.ID, dealer_permission.ID_DEALER, dealer_permission.WHICH, dealer_permission.DATE_CREATE FROM dealer_permission WHERE dealer_permission.ID_DEALER=1581 |
56 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
57 | Creole | executeQuery(): [1.01 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=1581 AND dealer_permission.WHICH='Q' |
58 | Creole | prepareStatement(): SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=? AND model.ID=? AND make.ID=model.ID_MAKE |
59 | Creole | executeQuery(): [1.34 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=139 AND model.ID=1593 AND make.ID=model.ID_MAKE |
60 | Creole | prepareStatement(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 192976 AND car.ID_MODEL = '1593' ) 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 != 192976 AND car.ID_MODEL = '1593' ) ORDER BY ID DESC |
61 | Creole | prepareStatement(): SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 192976 AND car.ID_MODEL = '1593' ) 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 != 192976 AND car.ID_MODEL = '1593' ) ) AS count |
62 | Creole | executeQuery(): [2.23 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 != 192976 AND car.ID_MODEL = '1593' ) 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 != 192976 AND car.ID_MODEL = '1593' ) ) AS count |
63 | Creole | applyLimit(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 192976 AND car.ID_MODEL = '1593' ) 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 != 192976 AND car.ID_MODEL = '1593' ) ORDER BY ID DESC, offset: 0, limit: 5 |
64 | Creole | executeQuery(): [3.64 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 != 192976 AND car.ID_MODEL = '1593' ) 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 != 192976 AND car.ID_MODEL = '1593' ) ORDER BY ID DESC LIMIT 5 |
65 | Creole | prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (196726,194134,193121,192543,191308) ORDER BY carimg.ORD ASC |
66 | Creole | executeQuery(): [0.99 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 (196726,194134,193121,192543,191308) ORDER BY carimg.ORD ASC |
67 | Creole | prepareStatement(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '192976' AND car.ID_NETTI_USER = '1581' ) 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 != '192976' AND car.ID_NETTI_USER = '1581' ) ORDER BY ID DESC |
68 | Creole | prepareStatement(): SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '192976' AND car.ID_NETTI_USER = '1581' ) 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 != '192976' AND car.ID_NETTI_USER = '1581' ) ) AS count |
69 | Creole | executeQuery(): [1.55 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 != '192976' AND car.ID_NETTI_USER = '1581' ) 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 != '192976' AND car.ID_NETTI_USER = '1581' ) ) AS count |
70 | Creole | applyLimit(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '192976' AND car.ID_NETTI_USER = '1581' ) 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 != '192976' AND car.ID_NETTI_USER = '1581' ) ORDER BY ID DESC, offset: 0, limit: 5 |
71 | Creole | executeQuery(): [1.19 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 != '192976' AND car.ID_NETTI_USER = '1581' ) 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 != '192976' AND car.ID_NETTI_USER = '1581' ) ORDER BY ID DESC LIMIT 5 |
72 | Creole | prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (192975,191913,191911) ORDER BY carimg.ORD ASC |
73 | Creole | executeQuery(): [0.58 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 (192975,191913,191911) ORDER BY carimg.ORD ASC |
74 | Creole | prepareStatement(): SELECT car.ID FROM car WHERE car.ID_MAKE=? AND car.ID_MODEL=? AND car.STATUS=? |
75 | Creole | executeQuery(): [1.48 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=139 AND car.ID_MODEL=1593 AND car.STATUS='F' |
76 | Creole | prepareStatement(): SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=? AND sold_car.ID_MODEL=? AND sold_car.STATUS=? |
77 | Creole | executeQuery(): [37.80 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=139 AND sold_car.ID_MODEL=1593 AND sold_car.STATUS='S' |
78 | Creole | prepareStatement(): SELECT id, id_ad, ROUND(AVG(price)) AS avg_price, DATE_FORMAT(date_create, "%m-%Y") AS cmonth, date_create FROM price_history WHERE date_create >= DATE_SUB(SYSDATE(), INTERVAL 1 YEAR) AND id_ad IN (61855,84658,129653,130430,133303,134805,134806,134807,137550,148648,150386,150478,158328,165472,170138,172497,173562,175720,176988,177964,179844,180404,187764,188169,188170,191308,192543,192976,193121,194134,196726) GROUP BY cmonth ORDER BY date_create |
79 | Creole | executeQuery(): [0.95 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 (61855,84658,129653,130430,133303,134805,134806,134807,137550,148648,150386,150478,158328,165472,170138,172497,173562,175720,176988,177964,179844,180404,187764,188169,188170,191308,192543,192976,193121,194134,196726) GROUP BY cmonth ORDER BY date_create |
80 | Creole | prepareStatement(): SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%V" ) AS sold_week, DATE_FORMAT(scs.date_actual_sold, "%V-%Y") AS wmonth FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND sc.price_ask > 0 AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 5 YEAR) AND scs.id_ad IN (20698,20699,20700,20701,20712,20713,20774,20775,20818,20867,20868,21070,21071,21115,21177,21425,21646,21701,22276,22333,22334,22335,22478,22651,23289,23366,23430,23584,23585,24410,24768,24956,24962,25021,25028,25074,25196,25292,25293,25329,25406,25578,25581,25646,25707,25860,25933,26038,26104,26425,26514,26699,26765,26873,27009,27672,28075,28939,29615,29693,30488,30646,31103,31723,31839,32875,32910,32985,33110,33204,33337,33338,33475,33494,33512,33573,33589,34004,34103,34809,35294,35295,35584,35585,36144,36469,36972,37011,38723,38776,38844,38845,39303,39304,39305,43311,43798,43918,44148,44391,46015,46772,46904,46905,46906,46907,46918,47195,47606,47906,48273,48366,48847,48848,48849,48852,49991,50760,50761,50854,50885,50902,50949,50963,52565,53121,53122,53609,53610,53763,54110,56319,58796,58834,58974,59054,59453,60954,61471,61472,61504,61514,61763,61764,63805,64484,64485,64486,64491,64535,65197,65580,66471,66565,66730,67741,67743,67814,68461,68462,68508,68573,69356,69475,69505,69642,70196,70199,70240,71031,71860,71877,71899,72018,72699,72704,72975,73521,73522,73524,73525,74183,74294,74495,75087,76706,76747,77511,81222,82487,83228,84342,84344,84657,85376,85793,86632,87063,89097,90201,90377,90380,90381,90524,90856,91291,92423,93761,95308,95327,96019,97749,98316,98317,98318,98319,98320,98906,99472,101040,101285,101286,101287,101288,101291,101310,101756,102562,103650,103732,105105,105106,105107,105108,105534,105535,105536,106330,106379,106538,107353,107354,108278,108430,109195,109232,109414,109511,110110,110665,111134,111143,111827,111830,112596,112712,112723,113056,113140,113477,115261,115331,115396,115650,115651,115652,115653,115654,115693,115992,116829,117349,118013,118015,118490,118685,118686,118687,118688,118689,120189,121188,121686,122074,122075,122526,123610,123923,123924,125695,125773,126961,127325,127955,127998,128062,128126,128448,128623,128624,128848,129206,129611,131111,131231,131638,131639,131640,131918,132162,132187,132516,133010,133059,133062,133351,133354,133624,133625,133626,135019,135284,135727,135728,135729,135795,136007,136067,136068,136190,136399,136565,136582,136781,137779,139420,140252,140941,141195,141437,141562,142695,142807,143037,143998,144002,144003,144113,144397,144745,144987,145113,146060,146110,146273,146274,146293,146990,147006,147120,147121,147469,148280,149242,149689,150064,150088,150330,151695,152015,152294,152295,152790,153473,154447,154950,155294,155338,155602,155796,155951,156181,156548,156630,157116,157176,157675,157679,158234,158495,158629,158777,159445,159446,159769,159822,159907,160339,161574,161591,161592,162719,163043,163307,163337,163542,163548,163965,163968,164249,164597,164695,164697,164984,165124,165179,165215,165334,165348,165513,165624,165628,165633,165754,165765,165841,165881,165892,165895,166013,166409,167543,167908,168115,168117,168252,168496,168601,169278,169365,169447,169472,169566,169696,169698,170038,170207,170226,170753,170754,170930,171020,171889,171890,171902,172152,172177,172375,172482,172692,172729,172733,172741,172745,173658,173921,173944,174150,174406,174902,176081,176097,176108,176560,176992,177001,177002,177196,177348,177497,177948,177952,178670,178675,179128,179842,180055,180522,182174,183579,187028,187567,188100,188501,188623,191989,192466,193570,194040) GROUP BY sold_week ORDER BY scs.date_actual_sold |
81 | Creole | executeQuery(): [4.65 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 (20698,20699,20700,20701,20712,20713,20774,20775,20818,20867,20868,21070,21071,21115,21177,21425,21646,21701,22276,22333,22334,22335,22478,22651,23289,23366,23430,23584,23585,24410,24768,24956,24962,25021,25028,25074,25196,25292,25293,25329,25406,25578,25581,25646,25707,25860,25933,26038,26104,26425,26514,26699,26765,26873,27009,27672,28075,28939,29615,29693,30488,30646,31103,31723,31839,32875,32910,32985,33110,33204,33337,33338,33475,33494,33512,33573,33589,34004,34103,34809,35294,35295,35584,35585,36144,36469,36972,37011,38723,38776,38844,38845,39303,39304,39305,43311,43798,43918,44148,44391,46015,46772,46904,46905,46906,46907,46918,47195,47606,47906,48273,48366,48847,48848,48849,48852,49991,50760,50761,50854,50885,50902,50949,50963,52565,53121,53122,53609,53610,53763,54110,56319,58796,58834,58974,59054,59453,60954,61471,61472,61504,61514,61763,61764,63805,64484,64485,64486,64491,64535,65197,65580,66471,66565,66730,67741,67743,67814,68461,68462,68508,68573,69356,69475,69505,69642,70196,70199,70240,71031,71860,71877,71899,72018,72699,72704,72975,73521,73522,73524,73525,74183,74294,74495,75087,76706,76747,77511,81222,82487,83228,84342,84344,84657,85376,85793,86632,87063,89097,90201,90377,90380,90381,90524,90856,91291,92423,93761,95308,95327,96019,97749,98316,98317,98318,98319,98320,98906,99472,101040,101285,101286,101287,101288,101291,101310,101756,102562,103650,103732,105105,105106,105107,105108,105534,105535,105536,106330,106379,106538,107353,107354,108278,108430,109195,109232,109414,109511,110110,110665,111134,111143,111827,111830,112596,112712,112723,113056,113140,113477,115261,115331,115396,115650,115651,115652,115653,115654,115693,115992,116829,117349,118013,118015,118490,118685,118686,118687,118688,118689,120189,121188,121686,122074,122075,122526,123610,123923,123924,125695,125773,126961,127325,127955,127998,128062,128126,128448,128623,128624,128848,129206,129611,131111,131231,131638,131639,131640,131918,132162,132187,132516,133010,133059,133062,133351,133354,133624,133625,133626,135019,135284,135727,135728,135729,135795,136007,136067,136068,136190,136399,136565,136582,136781,137779,139420,140252,140941,141195,141437,141562,142695,142807,143037,143998,144002,144003,144113,144397,144745,144987,145113,146060,146110,146273,146274,146293,146990,147006,147120,147121,147469,148280,149242,149689,150064,150088,150330,151695,152015,152294,152295,152790,153473,154447,154950,155294,155338,155602,155796,155951,156181,156548,156630,157116,157176,157675,157679,158234,158495,158629,158777,159445,159446,159769,159822,159907,160339,161574,161591,161592,162719,163043,163307,163337,163542,163548,163965,163968,164249,164597,164695,164697,164984,165124,165179,165215,165334,165348,165513,165624,165628,165633,165754,165765,165841,165881,165892,165895,166013,166409,167543,167908,168115,168117,168252,168496,168601,169278,169365,169447,169472,169566,169696,169698,170038,170207,170226,170753,170754,170930,171020,171889,171890,171902,172152,172177,172375,172482,172692,172729,172733,172741,172745,173658,173921,173944,174150,174406,174902,176081,176097,176108,176560,176992,177001,177002,177196,177348,177497,177948,177952,178670,178675,179128,179842,180055,180522,182174,183579,187028,187567,188100,188501,188623,191989,192466,193570,194040) GROUP BY sold_week ORDER BY scs.date_actual_sold |
82 | Creole | prepareStatement(): SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sc.id IN (20698,20699,20700,20701,20712,20713,20774,20775,20818,20867,20868,21070,21071,21115,21177,21425,21646,21701,22276,22333,22334,22335,22478,22651,23289,23366,23430,23584,23585,24410,24768,24956,24962,25021,25028,25074,25196,25292,25293,25329,25406,25578,25581,25646,25707,25860,25933,26038,26104,26425,26514,26699,26765,26873,27009,27672,28075,28939,29615,29693,30488,30646,31103,31723,31839,32875,32910,32985,33110,33204,33337,33338,33475,33494,33512,33573,33589,34004,34103,34809,35294,35295,35584,35585,36144,36469,36972,37011,38723,38776,38844,38845,39303,39304,39305,43311,43798,43918,44148,44391,46015,46772,46904,46905,46906,46907,46918,47195,47606,47906,48273,48366,48847,48848,48849,48852,49991,50760,50761,50854,50885,50902,50949,50963,52565,53121,53122,53609,53610,53763,54110,56319,58796,58834,58974,59054,59453,60954,61471,61472,61504,61514,61763,61764,63805,64484,64485,64486,64491,64535,65197,65580,66471,66565,66730,67741,67743,67814,68461,68462,68508,68573,69356,69475,69505,69642,70196,70199,70240,71031,71860,71877,71899,72018,72699,72704,72975,73521,73522,73524,73525,74183,74294,74495,75087,76706,76747,77511,81222,82487,83228,84342,84344,84657,85376,85793,86632,87063,89097,90201,90377,90380,90381,90524,90856,91291,92423,93761,95308,95327,96019,97749,98316,98317,98318,98319,98320,98906,99472,101040,101285,101286,101287,101288,101291,101310,101756,102562,103650,103732,105105,105106,105107,105108,105534,105535,105536,106330,106379,106538,107353,107354,108278,108430,109195,109232,109414,109511,110110,110665,111134,111143,111827,111830,112596,112712,112723,113056,113140,113477,115261,115331,115396,115650,115651,115652,115653,115654,115693,115992,116829,117349,118013,118015,118490,118685,118686,118687,118688,118689,120189,121188,121686,122074,122075,122526,123610,123923,123924,125695,125773,126961,127325,127955,127998,128062,128126,128448,128623,128624,128848,129206,129611,131111,131231,131638,131639,131640,131918,132162,132187,132516,133010,133059,133062,133351,133354,133624,133625,133626,135019,135284,135727,135728,135729,135795,136007,136067,136068,136190,136399,136565,136582,136781,137779,139420,140252,140941,141195,141437,141562,142695,142807,143037,143998,144002,144003,144113,144397,144745,144987,145113,146060,146110,146273,146274,146293,146990,147006,147120,147121,147469,148280,149242,149689,150064,150088,150330,151695,152015,152294,152295,152790,153473,154447,154950,155294,155338,155602,155796,155951,156181,156548,156630,157116,157176,157675,157679,158234,158495,158629,158777,159445,159446,159769,159822,159907,160339,161574,161591,161592,162719,163043,163307,163337,163542,163548,163965,163968,164249,164597,164695,164697,164984,165124,165179,165215,165334,165348,165513,165624,165628,165633,165754,165765,165841,165881,165892,165895,166013,166409,167543,167908,168115,168117,168252,168496,168601,169278,169365,169447,169472,169566,169696,169698,170038,170207,170226,170753,170754,170930,171020,171889,171890,171902,172152,172177,172375,172482,172692,172729,172733,172741,172745,173658,173921,173944,174150,174406,174902,176081,176097,176108,176560,176992,177001,177002,177196,177348,177497,177948,177952,178670,178675,179128,179842,180055,180522,182174,183579,187028,187567,188100,188501,188623,191989,192466,193570,194040) GROUP BY sold_month ORDER BY scs.date_actual_sold |
83 | Creole | executeQuery(): [4.32 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 (20698,20699,20700,20701,20712,20713,20774,20775,20818,20867,20868,21070,21071,21115,21177,21425,21646,21701,22276,22333,22334,22335,22478,22651,23289,23366,23430,23584,23585,24410,24768,24956,24962,25021,25028,25074,25196,25292,25293,25329,25406,25578,25581,25646,25707,25860,25933,26038,26104,26425,26514,26699,26765,26873,27009,27672,28075,28939,29615,29693,30488,30646,31103,31723,31839,32875,32910,32985,33110,33204,33337,33338,33475,33494,33512,33573,33589,34004,34103,34809,35294,35295,35584,35585,36144,36469,36972,37011,38723,38776,38844,38845,39303,39304,39305,43311,43798,43918,44148,44391,46015,46772,46904,46905,46906,46907,46918,47195,47606,47906,48273,48366,48847,48848,48849,48852,49991,50760,50761,50854,50885,50902,50949,50963,52565,53121,53122,53609,53610,53763,54110,56319,58796,58834,58974,59054,59453,60954,61471,61472,61504,61514,61763,61764,63805,64484,64485,64486,64491,64535,65197,65580,66471,66565,66730,67741,67743,67814,68461,68462,68508,68573,69356,69475,69505,69642,70196,70199,70240,71031,71860,71877,71899,72018,72699,72704,72975,73521,73522,73524,73525,74183,74294,74495,75087,76706,76747,77511,81222,82487,83228,84342,84344,84657,85376,85793,86632,87063,89097,90201,90377,90380,90381,90524,90856,91291,92423,93761,95308,95327,96019,97749,98316,98317,98318,98319,98320,98906,99472,101040,101285,101286,101287,101288,101291,101310,101756,102562,103650,103732,105105,105106,105107,105108,105534,105535,105536,106330,106379,106538,107353,107354,108278,108430,109195,109232,109414,109511,110110,110665,111134,111143,111827,111830,112596,112712,112723,113056,113140,113477,115261,115331,115396,115650,115651,115652,115653,115654,115693,115992,116829,117349,118013,118015,118490,118685,118686,118687,118688,118689,120189,121188,121686,122074,122075,122526,123610,123923,123924,125695,125773,126961,127325,127955,127998,128062,128126,128448,128623,128624,128848,129206,129611,131111,131231,131638,131639,131640,131918,132162,132187,132516,133010,133059,133062,133351,133354,133624,133625,133626,135019,135284,135727,135728,135729,135795,136007,136067,136068,136190,136399,136565,136582,136781,137779,139420,140252,140941,141195,141437,141562,142695,142807,143037,143998,144002,144003,144113,144397,144745,144987,145113,146060,146110,146273,146274,146293,146990,147006,147120,147121,147469,148280,149242,149689,150064,150088,150330,151695,152015,152294,152295,152790,153473,154447,154950,155294,155338,155602,155796,155951,156181,156548,156630,157116,157176,157675,157679,158234,158495,158629,158777,159445,159446,159769,159822,159907,160339,161574,161591,161592,162719,163043,163307,163337,163542,163548,163965,163968,164249,164597,164695,164697,164984,165124,165179,165215,165334,165348,165513,165624,165628,165633,165754,165765,165841,165881,165892,165895,166013,166409,167543,167908,168115,168117,168252,168496,168601,169278,169365,169447,169472,169566,169696,169698,170038,170207,170226,170753,170754,170930,171020,171889,171890,171902,172152,172177,172375,172482,172692,172729,172733,172741,172745,173658,173921,173944,174150,174406,174902,176081,176097,176108,176560,176992,177001,177002,177196,177348,177497,177948,177952,178670,178675,179128,179842,180055,180522,182174,183579,187028,187567,188100,188501,188623,191989,192466,193570,194040) GROUP BY sold_month ORDER BY scs.date_actual_sold |
84 | Creole | prepareStatement(): SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC |
85 | Creole | executeQuery(): [1028.09 ms] SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC |
86 | Action | change layout to "view_layout" |
87 | View | initialize view for "home/view" |
88 | View | render "sf_app_dir/modules/home/templates/viewSuccess.php" |
89 | View | initialize view for "home/_vif_images" |
90 | View | render "sf_app_dir/modules/home/templates/_vif_images.php" |
91 | PartialHelper | Generate cache key |
92 | View | initialize view for "common_page/_social_buttons" |
93 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php" |
94 | PartialHelper | Generate cache key |
95 | View | initialize view for "home/_vif_info" |
96 | View | render "sf_app_dir/modules/home/templates/_vif_info.php" |
97 | PartialHelper | Generate cache key |
98 | View | initialize view for "home/_owner_info" |
99 | View | render "sf_app_dir/modules/home/templates/_owner_info.php" |
100 | PartialHelper | Generate cache key |
101 | View | initialize view for "common_page/_price_development_graph" |
102 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php" |
103 | PartialHelper | Generate cache key |
104 | View | initialize view for "common_page/_sell_time_price_graph" |
105 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php" |
106 | PartialHelper | Generate cache key |
107 | View | initialize view for "common_page/_price_gauge_graph" |
108 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php" |
109 | PartialHelper | Generate cache key |
110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
111 | Creole | executeQuery(): [2.98 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=196726 |
112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
113 | Creole | executeQuery(): [1.35 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=194134 |
114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
115 | Creole | executeQuery(): [0.94 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=193121 |
116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
117 | Creole | executeQuery(): [0.45 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=192543 |
118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
119 | Creole | executeQuery(): [0.51 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=191308 |
120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
121 | Creole | executeQuery(): [1.20 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=192975 |
122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
123 | Creole | executeQuery(): [0.98 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=191913 |
124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
125 | Creole | executeQuery(): [1.15 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=191911 |
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 |