# |
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' => 'pontiac', 'model' => 'gto', 'id' => '196982', '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.44 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=196982 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.33 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 (1191) |
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.83 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=196982 |
38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
39 | Creole | executeQuery(): [1.24 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=196982 |
40 | Creole | prepareStatement(): SELECT car_contact.ID, car_contact.ID_AD, car_contact.ID_SOURCE_AD, car_contact.SCODE, car_contact.COMPANY, car_contact.NAME, car_contact.CITY, car_contact.ADDRESS, car_contact.ZIP, car_contact.EMAIL, car_contact.CONT_TIME, car_contact.PHONE, car_contact.MOBILE, car_contact.FAX, car_contact.WEB_URL, car_contact.DATE_CREATE, car_contact.DATE_MODIFY FROM car_contact WHERE car_contact.ID_AD=? |
41 | Creole | executeQuery(): [7.37 ms] SELECT car_contact.ID, car_contact.ID_AD, car_contact.ID_SOURCE_AD, car_contact.SCODE, car_contact.COMPANY, car_contact.NAME, car_contact.CITY, car_contact.ADDRESS, car_contact.ZIP, car_contact.EMAIL, car_contact.CONT_TIME, car_contact.PHONE, car_contact.MOBILE, car_contact.FAX, car_contact.WEB_URL, car_contact.DATE_CREATE, car_contact.DATE_MODIFY FROM car_contact WHERE car_contact.ID_AD=196982 |
42 | Creole | prepareStatement(): SELECT netti_dealer.ID_DEALER, netti_dealer.ID, netti_dealer.PATH, netti_dealer.COMPANY, netti_dealer.SLOGAN, netti_dealer.URL, netti_dealer.SIMPLE_URL, netti_dealer.HAS_SITE FROM netti_dealer WHERE netti_dealer.ID_DEALER IN (?) |
43 | Creole | executeQuery(): [1.57 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 (1191) |
44 | Creole | prepareStatement(): SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=? AND fa_payment_order.PAYMENT_STATUS=? AND fa_payment_order.UPSELLS_TAKEN=? |
45 | Creole | executeQuery(): [1.47 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=196982 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2' |
46 | Creole | prepareStatement(): SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID=? |
47 | Creole | executeQuery(): [0.52 ms] SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID='1' |
48 | Creole | prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (196982) ORDER BY carimg.ORD ASC |
49 | Creole | executeQuery(): [1.01 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 (196982) ORDER BY carimg.ORD ASC |
50 | Creole | prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?) |
51 | Creole | executeQuery(): [0.45 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 (1191) |
52 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
53 | Creole | executeQuery(): [1.37 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=1191 AND dealer_permission.WHICH='Q' |
54 | Creole | prepareStatement(): SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=? AND model.ID=? AND make.ID=model.ID_MAKE |
55 | Creole | executeQuery(): [1.40 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=138 AND model.ID=1562 AND make.ID=model.ID_MAKE |
56 | Creole | prepareStatement(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 196982 AND car.ID_MODEL = '1562' ) 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 != 196982 AND car.ID_MODEL = '1562' ) ORDER BY ID DESC |
57 | Creole | prepareStatement(): SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 196982 AND car.ID_MODEL = '1562' ) 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 != 196982 AND car.ID_MODEL = '1562' ) ) AS count |
58 | Creole | executeQuery(): [3.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 != 196982 AND car.ID_MODEL = '1562' ) 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 != 196982 AND car.ID_MODEL = '1562' ) ) AS count |
59 | Creole | applyLimit(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 196982 AND car.ID_MODEL = '1562' ) 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 != 196982 AND car.ID_MODEL = '1562' ) ORDER BY ID DESC, offset: 0, limit: 5 |
60 | Creole | executeQuery(): [5.53 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 != 196982 AND car.ID_MODEL = '1562' ) 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 != 196982 AND car.ID_MODEL = '1562' ) ORDER BY ID DESC LIMIT 5 |
61 | Creole | prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199191,197607,197419,197220,196128) ORDER BY carimg.ORD ASC |
62 | Creole | executeQuery(): [0.70 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 (199191,197607,197419,197220,196128) ORDER BY carimg.ORD ASC |
63 | Creole | prepareStatement(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '196982' AND car.ID_NETTI_USER = '1191' ) 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 != '196982' AND car.ID_NETTI_USER = '1191' ) ORDER BY ID DESC |
64 | Creole | prepareStatement(): SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '196982' AND car.ID_NETTI_USER = '1191' ) 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 != '196982' AND car.ID_NETTI_USER = '1191' ) ) AS count |
65 | Creole | executeQuery(): [4.94 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 != '196982' AND car.ID_NETTI_USER = '1191' ) 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 != '196982' AND car.ID_NETTI_USER = '1191' ) ) AS count |
66 | Creole | applyLimit(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '196982' AND car.ID_NETTI_USER = '1191' ) 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 != '196982' AND car.ID_NETTI_USER = '1191' ) ORDER BY ID DESC, offset: 0, limit: 5 |
67 | Creole | executeQuery(): [9.03 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 != '196982' AND car.ID_NETTI_USER = '1191' ) 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 != '196982' AND car.ID_NETTI_USER = '1191' ) ORDER BY ID DESC LIMIT 5 |
68 | Creole | prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (197344,197219,197218,197217,197216) ORDER BY carimg.ORD ASC |
69 | Creole | executeQuery(): [0.81 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 (197344,197219,197218,197217,197216) ORDER BY carimg.ORD ASC |
70 | Creole | prepareStatement(): SELECT car.ID FROM car WHERE car.ID_MAKE=? AND car.ID_MODEL=? AND car.STATUS=? |
71 | Creole | executeQuery(): [3.27 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=138 AND car.ID_MODEL=1562 AND car.STATUS='F' |
72 | Creole | prepareStatement(): SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=? AND sold_car.ID_MODEL=? AND sold_car.STATUS=? |
73 | Creole | executeQuery(): [3.97 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=138 AND sold_car.ID_MODEL=1562 AND sold_car.STATUS='S' |
74 | Creole | prepareStatement(): SELECT id, id_ad, ROUND(AVG(price)) AS avg_price, DATE_FORMAT(date_create, "%m-%Y") AS cmonth, date_create FROM price_history WHERE date_create >= DATE_SUB(SYSDATE(), INTERVAL 1 YEAR) AND id_ad IN (31633,65767,65784,65823,65846,102407,106066,106436,129474,131397,131398,132835,132976,136212,142788,153191,154809,155229,155492,155871,155878,157060,166752,168538,170251,172996,176360,178745,179782,181115,181392,187011,187984,188639,189111,190255,191196,191383,191549,191620,191953,192087,192518,192578,193010,193223,193397,193482,193876,194107,194248,194751,195030,195448,195632,195667,195823,195932,195949,196128,196982,197220,197419,197607,199191) GROUP BY cmonth ORDER BY date_create |
75 | Creole | executeQuery(): [2.46 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 (31633,65767,65784,65823,65846,102407,106066,106436,129474,131397,131398,132835,132976,136212,142788,153191,154809,155229,155492,155871,155878,157060,166752,168538,170251,172996,176360,178745,179782,181115,181392,187011,187984,188639,189111,190255,191196,191383,191549,191620,191953,192087,192518,192578,193010,193223,193397,193482,193876,194107,194248,194751,195030,195448,195632,195667,195823,195932,195949,196128,196982,197220,197419,197607,199191) GROUP BY cmonth ORDER BY date_create |
76 | Creole | prepareStatement(): SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%V" ) AS sold_week, DATE_FORMAT(scs.date_actual_sold, "%V-%Y") AS wmonth FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND sc.price_ask > 0 AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 5 YEAR) AND scs.id_ad IN (22540,22541,22543,22544,22545,22553,22568,22586,22597,22660,22686,22699,22817,22824,22827,22859,23026,23225,23905,24932,25522,25705,27084,27681,27971,30659,32151,32416,32805,32807,34908,35047,35100,35112,35132,35134,35137,36999,39489,39661,42596,43933,44060,44716,46305,46443,48554,50433,50434,50808,53862,55444,55825,55830,55851,55956,56112,56140,56153,56154,56203,56626,56747,56892,56893,57012,57266,57298,57377,57378,57389,57390,57643,57644,57739,57751,57764,58223,58224,58242,58581,58618,58637,58672,58940,59025,59543,60729,60730,60737,60773,60774,60804,61075,61441,61557,62259,62423,64391,64404,64729,65746,67824,69448,69567,71303,73413,73553,73726,73727,74386,75204,75827,75849,75968,77012,78276,78284,78403,78597,78609,78640,78676,78683,78697,80927,81253,81254,81480,81854,81856,81899,81959,82410,82426,82430,83097,83243,85186,85480,85727,85969,86195,86298,86578,86891,88043,88437,90853,90854,91812,92450,92873,92901,93483,93554,95020,95082,95569,95694,95700,95736,95745,98447,98980,99001,99275,100876,101352,101494,101735,102406,102410,102413,102419,103410,103439,103515,104023,105301,105690,106024,106401,106437,106613,106668,107132,107401,107405,108035,108036,108054,108055,108075,108428,108640,109147,109480,109575,109591,109918,109930,109987,109989,110218,110227,110231,110244,110247,110249,110264,110363,110364,110568,110887,111105,111265,111611,112686,112687,112883,113045,113148,113669,113856,114121,114166,114177,114219,114229,114235,114306,114470,114801,114807,114932,114933,114940,115033,115157,115346,115350,115359,115493,115500,115795,115800,115970,116070,116150,116162,116231,116456,116501,116502,116921,116922,117369,117440,117743,117982,118069,118139,118227,118302,118511,119225,119359,119930,120595,120596,120597,120609,120610,120611,120648,120666,121026,121027,121028,121059,121060,121078,121222,121345,121346,121355,121396,121406,121416,121419,121480,121481,121684,121685,121833,122203,122254,122340,122436,122437,122595,122623,122775,122911,123139,123394,123706,123759,123791,123824,124004,124006,124081,124190,124193,124211,125553,125782,125900,126317,126340,126407,126420,126429,126640,126732,126740,126746,126883,127154,127366,127682,127702,127842,127893,127910,127948,128031,128091,128260,128330,128640,128922,129068,129129,129319,129348,129385,129409,130996,132115,132170,132177,132235,132244,132290,132602,132659,132834,133447,136446,136627,136925,136965,137054,137222,137225,137231,137355,137631,137646,137664,137759,137762,138174,138308,138440,138564,138585,138592,138736,138756,138775,139691,139700,139721,140182,140183,141479,141883,142192,142463,142504,142592,142841,143293,143491,143664,143668,143779,143872,143959,144042,144050,144444,144691,144727,144768,144781,144782,145222,145272,145274,145347,145354,145613,145728,145729,145730,145731,145782,146132,146143,146386,146454,146749,146759,146806,146940,147047,147048,147074,147218,147506,147549,147670,147780,147798,147927,147928,147989,148208,148242,148450,148580,148903,148956,148980,149022,149050,149271,149374,149588,149706,149707,150141,150255,150367,150845,150848,151444,151548,151655,151954,152036,152040,152041,152126,152127,153377,153378,153415,153416,153420,153431,153512,153514,153575,153771,153889,154088,154119,154158,154371,154539,154540,154761,155402,155570,155745,156698,156718,156882,156910,157193,157271,157272,157274,157286,157298,157624,157639,157695,157740,157885,157890,158033,158531,158532,158600,158601,158657,158791,159864,159925,159926,160023,160034,160541,160613,160655,161032,161392,162114,162198,162575,162681,163240,163625,164350,164894,165142,165319,165581,165592,165722,165859,165862,165974,166029,166030,166095,166218,166502,166544,166552,166565,166566,166665,166681,166760,167137,167293,167294,167446,168032,168079,168369,169438,169614,169989,170151,170399,170499,170504,170697,170698,170902,171183,171443,171749,171777,172051,172053,172535,172667,172878,172881,172883,172932,173097,173314,173330,173439,173801,173803,173804,173855,173889,174033,174345,174458,174515,174520,174598,174630,174652,174654,174880,175006,175015,175348,175684,175744,175923,175925,176129,176362,176798,177315,177526,177551,177659,177891,177934,178157,178412,178413,178488,178566,179208,179326,179481,179553,179701,179821,180006,180246,180250,180286,180332,180383,180707,180770,180797,180899,180900,180940,180998,181135,181157,181180,181244,181504,181767,182255,182257,182594,182597,182920,183306,183672,183787,183923,183940,184338,184500,184523,184703,184823,184824,184950,185156,185433,185607,185649,185689,185755,185764,185767,185804,185806,185851,186019,186039,186049,186179,186629,186739,186802,187068,187199,187278,187319,187373,187514,187719,187877,188214,188219,188253,188272,188345,188530,188548,188689,188991,189343,189562,189577,189615,189839,189970,190157,190198,190433,190574,190991,191126,191242,191262,191320,191505,191564,191793,191864,191999,192025,192365,192432,192510,192911,193323,193699,193840,193910,194299,194410,195955,196265,197308) GROUP BY sold_week ORDER BY scs.date_actual_sold |
77 | Creole | executeQuery(): [5.42 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 (22540,22541,22543,22544,22545,22553,22568,22586,22597,22660,22686,22699,22817,22824,22827,22859,23026,23225,23905,24932,25522,25705,27084,27681,27971,30659,32151,32416,32805,32807,34908,35047,35100,35112,35132,35134,35137,36999,39489,39661,42596,43933,44060,44716,46305,46443,48554,50433,50434,50808,53862,55444,55825,55830,55851,55956,56112,56140,56153,56154,56203,56626,56747,56892,56893,57012,57266,57298,57377,57378,57389,57390,57643,57644,57739,57751,57764,58223,58224,58242,58581,58618,58637,58672,58940,59025,59543,60729,60730,60737,60773,60774,60804,61075,61441,61557,62259,62423,64391,64404,64729,65746,67824,69448,69567,71303,73413,73553,73726,73727,74386,75204,75827,75849,75968,77012,78276,78284,78403,78597,78609,78640,78676,78683,78697,80927,81253,81254,81480,81854,81856,81899,81959,82410,82426,82430,83097,83243,85186,85480,85727,85969,86195,86298,86578,86891,88043,88437,90853,90854,91812,92450,92873,92901,93483,93554,95020,95082,95569,95694,95700,95736,95745,98447,98980,99001,99275,100876,101352,101494,101735,102406,102410,102413,102419,103410,103439,103515,104023,105301,105690,106024,106401,106437,106613,106668,107132,107401,107405,108035,108036,108054,108055,108075,108428,108640,109147,109480,109575,109591,109918,109930,109987,109989,110218,110227,110231,110244,110247,110249,110264,110363,110364,110568,110887,111105,111265,111611,112686,112687,112883,113045,113148,113669,113856,114121,114166,114177,114219,114229,114235,114306,114470,114801,114807,114932,114933,114940,115033,115157,115346,115350,115359,115493,115500,115795,115800,115970,116070,116150,116162,116231,116456,116501,116502,116921,116922,117369,117440,117743,117982,118069,118139,118227,118302,118511,119225,119359,119930,120595,120596,120597,120609,120610,120611,120648,120666,121026,121027,121028,121059,121060,121078,121222,121345,121346,121355,121396,121406,121416,121419,121480,121481,121684,121685,121833,122203,122254,122340,122436,122437,122595,122623,122775,122911,123139,123394,123706,123759,123791,123824,124004,124006,124081,124190,124193,124211,125553,125782,125900,126317,126340,126407,126420,126429,126640,126732,126740,126746,126883,127154,127366,127682,127702,127842,127893,127910,127948,128031,128091,128260,128330,128640,128922,129068,129129,129319,129348,129385,129409,130996,132115,132170,132177,132235,132244,132290,132602,132659,132834,133447,136446,136627,136925,136965,137054,137222,137225,137231,137355,137631,137646,137664,137759,137762,138174,138308,138440,138564,138585,138592,138736,138756,138775,139691,139700,139721,140182,140183,141479,141883,142192,142463,142504,142592,142841,143293,143491,143664,143668,143779,143872,143959,144042,144050,144444,144691,144727,144768,144781,144782,145222,145272,145274,145347,145354,145613,145728,145729,145730,145731,145782,146132,146143,146386,146454,146749,146759,146806,146940,147047,147048,147074,147218,147506,147549,147670,147780,147798,147927,147928,147989,148208,148242,148450,148580,148903,148956,148980,149022,149050,149271,149374,149588,149706,149707,150141,150255,150367,150845,150848,151444,151548,151655,151954,152036,152040,152041,152126,152127,153377,153378,153415,153416,153420,153431,153512,153514,153575,153771,153889,154088,154119,154158,154371,154539,154540,154761,155402,155570,155745,156698,156718,156882,156910,157193,157271,157272,157274,157286,157298,157624,157639,157695,157740,157885,157890,158033,158531,158532,158600,158601,158657,158791,159864,159925,159926,160023,160034,160541,160613,160655,161032,161392,162114,162198,162575,162681,163240,163625,164350,164894,165142,165319,165581,165592,165722,165859,165862,165974,166029,166030,166095,166218,166502,166544,166552,166565,166566,166665,166681,166760,167137,167293,167294,167446,168032,168079,168369,169438,169614,169989,170151,170399,170499,170504,170697,170698,170902,171183,171443,171749,171777,172051,172053,172535,172667,172878,172881,172883,172932,173097,173314,173330,173439,173801,173803,173804,173855,173889,174033,174345,174458,174515,174520,174598,174630,174652,174654,174880,175006,175015,175348,175684,175744,175923,175925,176129,176362,176798,177315,177526,177551,177659,177891,177934,178157,178412,178413,178488,178566,179208,179326,179481,179553,179701,179821,180006,180246,180250,180286,180332,180383,180707,180770,180797,180899,180900,180940,180998,181135,181157,181180,181244,181504,181767,182255,182257,182594,182597,182920,183306,183672,183787,183923,183940,184338,184500,184523,184703,184823,184824,184950,185156,185433,185607,185649,185689,185755,185764,185767,185804,185806,185851,186019,186039,186049,186179,186629,186739,186802,187068,187199,187278,187319,187373,187514,187719,187877,188214,188219,188253,188272,188345,188530,188548,188689,188991,189343,189562,189577,189615,189839,189970,190157,190198,190433,190574,190991,191126,191242,191262,191320,191505,191564,191793,191864,191999,192025,192365,192432,192510,192911,193323,193699,193840,193910,194299,194410,195955,196265,197308) GROUP BY sold_week ORDER BY scs.date_actual_sold |
78 | Creole | prepareStatement(): SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sc.id IN (22540,22541,22543,22544,22545,22553,22568,22586,22597,22660,22686,22699,22817,22824,22827,22859,23026,23225,23905,24932,25522,25705,27084,27681,27971,30659,32151,32416,32805,32807,34908,35047,35100,35112,35132,35134,35137,36999,39489,39661,42596,43933,44060,44716,46305,46443,48554,50433,50434,50808,53862,55444,55825,55830,55851,55956,56112,56140,56153,56154,56203,56626,56747,56892,56893,57012,57266,57298,57377,57378,57389,57390,57643,57644,57739,57751,57764,58223,58224,58242,58581,58618,58637,58672,58940,59025,59543,60729,60730,60737,60773,60774,60804,61075,61441,61557,62259,62423,64391,64404,64729,65746,67824,69448,69567,71303,73413,73553,73726,73727,74386,75204,75827,75849,75968,77012,78276,78284,78403,78597,78609,78640,78676,78683,78697,80927,81253,81254,81480,81854,81856,81899,81959,82410,82426,82430,83097,83243,85186,85480,85727,85969,86195,86298,86578,86891,88043,88437,90853,90854,91812,92450,92873,92901,93483,93554,95020,95082,95569,95694,95700,95736,95745,98447,98980,99001,99275,100876,101352,101494,101735,102406,102410,102413,102419,103410,103439,103515,104023,105301,105690,106024,106401,106437,106613,106668,107132,107401,107405,108035,108036,108054,108055,108075,108428,108640,109147,109480,109575,109591,109918,109930,109987,109989,110218,110227,110231,110244,110247,110249,110264,110363,110364,110568,110887,111105,111265,111611,112686,112687,112883,113045,113148,113669,113856,114121,114166,114177,114219,114229,114235,114306,114470,114801,114807,114932,114933,114940,115033,115157,115346,115350,115359,115493,115500,115795,115800,115970,116070,116150,116162,116231,116456,116501,116502,116921,116922,117369,117440,117743,117982,118069,118139,118227,118302,118511,119225,119359,119930,120595,120596,120597,120609,120610,120611,120648,120666,121026,121027,121028,121059,121060,121078,121222,121345,121346,121355,121396,121406,121416,121419,121480,121481,121684,121685,121833,122203,122254,122340,122436,122437,122595,122623,122775,122911,123139,123394,123706,123759,123791,123824,124004,124006,124081,124190,124193,124211,125553,125782,125900,126317,126340,126407,126420,126429,126640,126732,126740,126746,126883,127154,127366,127682,127702,127842,127893,127910,127948,128031,128091,128260,128330,128640,128922,129068,129129,129319,129348,129385,129409,130996,132115,132170,132177,132235,132244,132290,132602,132659,132834,133447,136446,136627,136925,136965,137054,137222,137225,137231,137355,137631,137646,137664,137759,137762,138174,138308,138440,138564,138585,138592,138736,138756,138775,139691,139700,139721,140182,140183,141479,141883,142192,142463,142504,142592,142841,143293,143491,143664,143668,143779,143872,143959,144042,144050,144444,144691,144727,144768,144781,144782,145222,145272,145274,145347,145354,145613,145728,145729,145730,145731,145782,146132,146143,146386,146454,146749,146759,146806,146940,147047,147048,147074,147218,147506,147549,147670,147780,147798,147927,147928,147989,148208,148242,148450,148580,148903,148956,148980,149022,149050,149271,149374,149588,149706,149707,150141,150255,150367,150845,150848,151444,151548,151655,151954,152036,152040,152041,152126,152127,153377,153378,153415,153416,153420,153431,153512,153514,153575,153771,153889,154088,154119,154158,154371,154539,154540,154761,155402,155570,155745,156698,156718,156882,156910,157193,157271,157272,157274,157286,157298,157624,157639,157695,157740,157885,157890,158033,158531,158532,158600,158601,158657,158791,159864,159925,159926,160023,160034,160541,160613,160655,161032,161392,162114,162198,162575,162681,163240,163625,164350,164894,165142,165319,165581,165592,165722,165859,165862,165974,166029,166030,166095,166218,166502,166544,166552,166565,166566,166665,166681,166760,167137,167293,167294,167446,168032,168079,168369,169438,169614,169989,170151,170399,170499,170504,170697,170698,170902,171183,171443,171749,171777,172051,172053,172535,172667,172878,172881,172883,172932,173097,173314,173330,173439,173801,173803,173804,173855,173889,174033,174345,174458,174515,174520,174598,174630,174652,174654,174880,175006,175015,175348,175684,175744,175923,175925,176129,176362,176798,177315,177526,177551,177659,177891,177934,178157,178412,178413,178488,178566,179208,179326,179481,179553,179701,179821,180006,180246,180250,180286,180332,180383,180707,180770,180797,180899,180900,180940,180998,181135,181157,181180,181244,181504,181767,182255,182257,182594,182597,182920,183306,183672,183787,183923,183940,184338,184500,184523,184703,184823,184824,184950,185156,185433,185607,185649,185689,185755,185764,185767,185804,185806,185851,186019,186039,186049,186179,186629,186739,186802,187068,187199,187278,187319,187373,187514,187719,187877,188214,188219,188253,188272,188345,188530,188548,188689,188991,189343,189562,189577,189615,189839,189970,190157,190198,190433,190574,190991,191126,191242,191262,191320,191505,191564,191793,191864,191999,192025,192365,192432,192510,192911,193323,193699,193840,193910,194299,194410,195955,196265,197308) GROUP BY sold_month ORDER BY scs.date_actual_sold |
79 | Creole | executeQuery(): [6.15 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 (22540,22541,22543,22544,22545,22553,22568,22586,22597,22660,22686,22699,22817,22824,22827,22859,23026,23225,23905,24932,25522,25705,27084,27681,27971,30659,32151,32416,32805,32807,34908,35047,35100,35112,35132,35134,35137,36999,39489,39661,42596,43933,44060,44716,46305,46443,48554,50433,50434,50808,53862,55444,55825,55830,55851,55956,56112,56140,56153,56154,56203,56626,56747,56892,56893,57012,57266,57298,57377,57378,57389,57390,57643,57644,57739,57751,57764,58223,58224,58242,58581,58618,58637,58672,58940,59025,59543,60729,60730,60737,60773,60774,60804,61075,61441,61557,62259,62423,64391,64404,64729,65746,67824,69448,69567,71303,73413,73553,73726,73727,74386,75204,75827,75849,75968,77012,78276,78284,78403,78597,78609,78640,78676,78683,78697,80927,81253,81254,81480,81854,81856,81899,81959,82410,82426,82430,83097,83243,85186,85480,85727,85969,86195,86298,86578,86891,88043,88437,90853,90854,91812,92450,92873,92901,93483,93554,95020,95082,95569,95694,95700,95736,95745,98447,98980,99001,99275,100876,101352,101494,101735,102406,102410,102413,102419,103410,103439,103515,104023,105301,105690,106024,106401,106437,106613,106668,107132,107401,107405,108035,108036,108054,108055,108075,108428,108640,109147,109480,109575,109591,109918,109930,109987,109989,110218,110227,110231,110244,110247,110249,110264,110363,110364,110568,110887,111105,111265,111611,112686,112687,112883,113045,113148,113669,113856,114121,114166,114177,114219,114229,114235,114306,114470,114801,114807,114932,114933,114940,115033,115157,115346,115350,115359,115493,115500,115795,115800,115970,116070,116150,116162,116231,116456,116501,116502,116921,116922,117369,117440,117743,117982,118069,118139,118227,118302,118511,119225,119359,119930,120595,120596,120597,120609,120610,120611,120648,120666,121026,121027,121028,121059,121060,121078,121222,121345,121346,121355,121396,121406,121416,121419,121480,121481,121684,121685,121833,122203,122254,122340,122436,122437,122595,122623,122775,122911,123139,123394,123706,123759,123791,123824,124004,124006,124081,124190,124193,124211,125553,125782,125900,126317,126340,126407,126420,126429,126640,126732,126740,126746,126883,127154,127366,127682,127702,127842,127893,127910,127948,128031,128091,128260,128330,128640,128922,129068,129129,129319,129348,129385,129409,130996,132115,132170,132177,132235,132244,132290,132602,132659,132834,133447,136446,136627,136925,136965,137054,137222,137225,137231,137355,137631,137646,137664,137759,137762,138174,138308,138440,138564,138585,138592,138736,138756,138775,139691,139700,139721,140182,140183,141479,141883,142192,142463,142504,142592,142841,143293,143491,143664,143668,143779,143872,143959,144042,144050,144444,144691,144727,144768,144781,144782,145222,145272,145274,145347,145354,145613,145728,145729,145730,145731,145782,146132,146143,146386,146454,146749,146759,146806,146940,147047,147048,147074,147218,147506,147549,147670,147780,147798,147927,147928,147989,148208,148242,148450,148580,148903,148956,148980,149022,149050,149271,149374,149588,149706,149707,150141,150255,150367,150845,150848,151444,151548,151655,151954,152036,152040,152041,152126,152127,153377,153378,153415,153416,153420,153431,153512,153514,153575,153771,153889,154088,154119,154158,154371,154539,154540,154761,155402,155570,155745,156698,156718,156882,156910,157193,157271,157272,157274,157286,157298,157624,157639,157695,157740,157885,157890,158033,158531,158532,158600,158601,158657,158791,159864,159925,159926,160023,160034,160541,160613,160655,161032,161392,162114,162198,162575,162681,163240,163625,164350,164894,165142,165319,165581,165592,165722,165859,165862,165974,166029,166030,166095,166218,166502,166544,166552,166565,166566,166665,166681,166760,167137,167293,167294,167446,168032,168079,168369,169438,169614,169989,170151,170399,170499,170504,170697,170698,170902,171183,171443,171749,171777,172051,172053,172535,172667,172878,172881,172883,172932,173097,173314,173330,173439,173801,173803,173804,173855,173889,174033,174345,174458,174515,174520,174598,174630,174652,174654,174880,175006,175015,175348,175684,175744,175923,175925,176129,176362,176798,177315,177526,177551,177659,177891,177934,178157,178412,178413,178488,178566,179208,179326,179481,179553,179701,179821,180006,180246,180250,180286,180332,180383,180707,180770,180797,180899,180900,180940,180998,181135,181157,181180,181244,181504,181767,182255,182257,182594,182597,182920,183306,183672,183787,183923,183940,184338,184500,184523,184703,184823,184824,184950,185156,185433,185607,185649,185689,185755,185764,185767,185804,185806,185851,186019,186039,186049,186179,186629,186739,186802,187068,187199,187278,187319,187373,187514,187719,187877,188214,188219,188253,188272,188345,188530,188548,188689,188991,189343,189562,189577,189615,189839,189970,190157,190198,190433,190574,190991,191126,191242,191262,191320,191505,191564,191793,191864,191999,192025,192365,192432,192510,192911,193323,193699,193840,193910,194299,194410,195955,196265,197308) GROUP BY sold_month ORDER BY scs.date_actual_sold |
80 | Creole | prepareStatement(): SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC |
81 | Creole | executeQuery(): [793.67 ms] SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC |
82 | Action | change layout to "view_layout" |
83 | View | initialize view for "home/view" |
84 | View | render "sf_app_dir/modules/home/templates/viewSuccess.php" |
85 | View | initialize view for "home/_vif_images" |
86 | View | render "sf_app_dir/modules/home/templates/_vif_images.php" |
87 | PartialHelper | Generate cache key |
88 | View | initialize view for "common_page/_social_buttons" |
89 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php" |
90 | PartialHelper | Generate cache key |
91 | View | initialize view for "home/_vif_info" |
92 | View | render "sf_app_dir/modules/home/templates/_vif_info.php" |
93 | PartialHelper | Generate cache key |
94 | View | initialize view for "home/_hoover_user_info" |
95 | View | render "sf_app_dir/modules/home/templates/_hoover_user_info.php" |
96 | PartialHelper | Generate cache key |
97 | View | initialize view for "common_page/_price_development_graph" |
98 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php" |
99 | PartialHelper | Generate cache key |
100 | View | initialize view for "common_page/_sell_time_price_graph" |
101 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php" |
102 | PartialHelper | Generate cache key |
103 | View | initialize view for "common_page/_price_gauge_graph" |
104 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php" |
105 | PartialHelper | Generate cache key |
106 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
107 | Creole | executeQuery(): [0.70 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199191 |
108 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
109 | Creole | executeQuery(): [4.06 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197607 |
110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
111 | Creole | executeQuery(): [0.59 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197419 |
112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
113 | Creole | executeQuery(): [0.56 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197220 |
114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
115 | Creole | executeQuery(): [1.61 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=196128 |
116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
117 | Creole | executeQuery(): [1.03 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197344 |
118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
119 | Creole | executeQuery(): [1.11 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197219 |
120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
121 | Creole | executeQuery(): [1.12 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197218 |
122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
123 | Creole | executeQuery(): [1.27 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197217 |
124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
125 | Creole | executeQuery(): [1.40 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197216 |
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 |