Log and debug messages

#	type	message
1	Routing	connect "/captcha"
2	Context	initialization
3	Controller	initialization
4	Routing	match route [na_vif] "/:make/:model/:id"
5	Request	request parameters array ( 'make' => 'ford', 'model' => 'bronco', 'id' => '200086', '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(): [5.04 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=200086 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(): [8.16 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 (1891)
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(): [5.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, 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=200086
38	Creole	prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=?
39	Creole	executeQuery(): [16.01 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=200086
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(): [9.74 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=200086 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(): [9.58 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 (200086) ORDER BY carimg.ORD ASC
45	Creole	executeQuery(): [16.46 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 (200086) 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(): [7.61 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 (1891)
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(): [10.01 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 (1891)
50	Creole	prepareStatement(): SELECT dealer.ID_MAKE, dealer.HIT_COUNTER FROM dealer WHERE dealer.ID_DEALER=?
51	Creole	executeQuery(): [8.47 ms] SELECT dealer.ID_MAKE, dealer.HIT_COUNTER FROM dealer WHERE dealer.ID_DEALER=1891
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(): [1.35 ms] SELECT netti_dealer.HAS_SITE, netti_dealer.SIMPLE_URL, netti_dealer.SLOGAN FROM netti_dealer WHERE netti_dealer.ID_DEALER=1891
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(): [8.19 ms] SELECT dealer_permission.ID, dealer_permission.ID_DEALER, dealer_permission.WHICH, dealer_permission.DATE_CREATE FROM dealer_permission WHERE dealer_permission.ID_DEALER=1891
56	Creole	prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=?
57	Creole	executeQuery(): [14.06 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=1891 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(): [3.70 ms] SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=63 AND model.ID=707 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 != 200086 AND car.ID_MODEL = '707' ) 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 != 200086 AND car.ID_MODEL = '707' ) 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 != 200086 AND car.ID_MODEL = '707' ) 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 != 200086 AND car.ID_MODEL = '707' ) ) AS count
62	Creole	executeQuery(): [9.77 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 != 200086 AND car.ID_MODEL = '707' ) 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 != 200086 AND car.ID_MODEL = '707' ) ) 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 != 200086 AND car.ID_MODEL = '707' ) 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 != 200086 AND car.ID_MODEL = '707' ) ORDER BY ID DESC, offset: 0, limit: 5
64	Creole	executeQuery(): [4.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.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 != 200086 AND car.ID_MODEL = '707' ) 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 != 200086 AND car.ID_MODEL = '707' ) 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 (199944,199700,199697,199458,199338) ORDER BY carimg.ORD ASC
66	Creole	executeQuery(): [4.43 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 (199944,199700,199697,199458,199338) 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 != '200086' AND car.ID_NETTI_USER = '1891' ) 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 != '200086' AND car.ID_NETTI_USER = '1891' ) 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 != '200086' AND car.ID_NETTI_USER = '1891' ) 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 != '200086' AND car.ID_NETTI_USER = '1891' ) ) AS count
69	Creole	executeQuery(): [1.42 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 != '200086' AND car.ID_NETTI_USER = '1891' ) 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 != '200086' AND car.ID_NETTI_USER = '1891' ) ) AS count
70	Creole	prepareStatement(): SELECT car.ID FROM car WHERE car.ID_MAKE=? AND car.ID_MODEL=? AND car.STATUS=?
71	Creole	executeQuery(): [1.48 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=63 AND car.ID_MODEL=707 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(): [103.89 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=63 AND sold_car.ID_MODEL=707 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 (66497,90831,153233,153723,172391,175068,190437,191780,192086,192887,193153,194094,195861,196442,196692,196894,197489,198180,198470,198557,198724,198912,199338,199458,199697,199700,199944,200086) GROUP BY cmonth ORDER BY date_create
75	Creole	executeQuery(): [1.86 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 (66497,90831,153233,153723,172391,175068,190437,191780,192086,192887,193153,194094,195861,196442,196692,196894,197489,198180,198470,198557,198724,198912,199338,199458,199697,199700,199944,200086) 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 (24142,30931,31056,31930,31965,32273,34829,41914,43897,46234,50263,56234,56240,57029,57030,57782,58593,58674,64553,65159,69330,69391,69392,74275,76676,76998,77628,78654,83076,84484,85152,85343,86453,86591,88458,88695,88918,89008,90145,92877,95564,95686,95731,98707,98708,102638,103109,103136,106292,106318,108051,109632,110892,110926,111774,112896,113006,113515,114314,114579,115029,115184,115428,116084,116233,116645,116786,117148,117655,118380,118800,119195,119285,120604,121071,121104,121474,121854,122420,123388,124264,124338,125396,126344,126414,126491,126890,127015,127353,128745,130374,132418,132736,132815,133071,133249,135942,136973,136996,137002,137821,138072,138209,138338,138362,138762,138779,138931,141434,141742,142851,143783,144013,144068,144533,144632,145408,145661,145709,145713,146455,146602,146694,147546,148462,148491,148939,150745,151171,151634,153883,153890,154169,154232,154345,154395,154399,154483,154616,154675,154862,154897,155274,155645,155814,155907,156154,156335,156697,157322,157607,159578,160061,160156,160479,162025,162078,162080,163836,164443,165005,165729,165875,166440,166584,166609,166941,167046,167146,167424,167853,168062,168171,168257,168440,169720,170109,170216,170703,171089,171182,171227,172431,172844,172897,173749,173903,174107,174446,174497,174514,174985,175086,175116,175743,176316,177050,177350,177424,179432,179691,179760,180163,180262,180362,181084,181647,181874,181877,182277,182302,182795,183676,183683,184727,185055,185123,185157,185349,185417,185504,185902,185963,186138,186202,186295,186482,186909,187233,187730,187756,188294,188411,188776,188821,189204,189626,190200,190254,190536,190581,191179,191203,191264,191337,191438,191961,192079,193038,193151,193203,193348,193603,194001,194359,194640,194863,196180,196353,196381,196469,196497,198501,198684) GROUP BY sold_week ORDER BY scs.date_actual_sold
77	Creole	executeQuery(): [12.27 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 (24142,30931,31056,31930,31965,32273,34829,41914,43897,46234,50263,56234,56240,57029,57030,57782,58593,58674,64553,65159,69330,69391,69392,74275,76676,76998,77628,78654,83076,84484,85152,85343,86453,86591,88458,88695,88918,89008,90145,92877,95564,95686,95731,98707,98708,102638,103109,103136,106292,106318,108051,109632,110892,110926,111774,112896,113006,113515,114314,114579,115029,115184,115428,116084,116233,116645,116786,117148,117655,118380,118800,119195,119285,120604,121071,121104,121474,121854,122420,123388,124264,124338,125396,126344,126414,126491,126890,127015,127353,128745,130374,132418,132736,132815,133071,133249,135942,136973,136996,137002,137821,138072,138209,138338,138362,138762,138779,138931,141434,141742,142851,143783,144013,144068,144533,144632,145408,145661,145709,145713,146455,146602,146694,147546,148462,148491,148939,150745,151171,151634,153883,153890,154169,154232,154345,154395,154399,154483,154616,154675,154862,154897,155274,155645,155814,155907,156154,156335,156697,157322,157607,159578,160061,160156,160479,162025,162078,162080,163836,164443,165005,165729,165875,166440,166584,166609,166941,167046,167146,167424,167853,168062,168171,168257,168440,169720,170109,170216,170703,171089,171182,171227,172431,172844,172897,173749,173903,174107,174446,174497,174514,174985,175086,175116,175743,176316,177050,177350,177424,179432,179691,179760,180163,180262,180362,181084,181647,181874,181877,182277,182302,182795,183676,183683,184727,185055,185123,185157,185349,185417,185504,185902,185963,186138,186202,186295,186482,186909,187233,187730,187756,188294,188411,188776,188821,189204,189626,190200,190254,190536,190581,191179,191203,191264,191337,191438,191961,192079,193038,193151,193203,193348,193603,194001,194359,194640,194863,196180,196353,196381,196469,196497,198501,198684) 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 (24142,30931,31056,31930,31965,32273,34829,41914,43897,46234,50263,56234,56240,57029,57030,57782,58593,58674,64553,65159,69330,69391,69392,74275,76676,76998,77628,78654,83076,84484,85152,85343,86453,86591,88458,88695,88918,89008,90145,92877,95564,95686,95731,98707,98708,102638,103109,103136,106292,106318,108051,109632,110892,110926,111774,112896,113006,113515,114314,114579,115029,115184,115428,116084,116233,116645,116786,117148,117655,118380,118800,119195,119285,120604,121071,121104,121474,121854,122420,123388,124264,124338,125396,126344,126414,126491,126890,127015,127353,128745,130374,132418,132736,132815,133071,133249,135942,136973,136996,137002,137821,138072,138209,138338,138362,138762,138779,138931,141434,141742,142851,143783,144013,144068,144533,144632,145408,145661,145709,145713,146455,146602,146694,147546,148462,148491,148939,150745,151171,151634,153883,153890,154169,154232,154345,154395,154399,154483,154616,154675,154862,154897,155274,155645,155814,155907,156154,156335,156697,157322,157607,159578,160061,160156,160479,162025,162078,162080,163836,164443,165005,165729,165875,166440,166584,166609,166941,167046,167146,167424,167853,168062,168171,168257,168440,169720,170109,170216,170703,171089,171182,171227,172431,172844,172897,173749,173903,174107,174446,174497,174514,174985,175086,175116,175743,176316,177050,177350,177424,179432,179691,179760,180163,180262,180362,181084,181647,181874,181877,182277,182302,182795,183676,183683,184727,185055,185123,185157,185349,185417,185504,185902,185963,186138,186202,186295,186482,186909,187233,187730,187756,188294,188411,188776,188821,189204,189626,190200,190254,190536,190581,191179,191203,191264,191337,191438,191961,192079,193038,193151,193203,193348,193603,194001,194359,194640,194863,196180,196353,196381,196469,196497,198501,198684) GROUP BY sold_month ORDER BY scs.date_actual_sold
79	Creole	executeQuery(): [10.00 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 (24142,30931,31056,31930,31965,32273,34829,41914,43897,46234,50263,56234,56240,57029,57030,57782,58593,58674,64553,65159,69330,69391,69392,74275,76676,76998,77628,78654,83076,84484,85152,85343,86453,86591,88458,88695,88918,89008,90145,92877,95564,95686,95731,98707,98708,102638,103109,103136,106292,106318,108051,109632,110892,110926,111774,112896,113006,113515,114314,114579,115029,115184,115428,116084,116233,116645,116786,117148,117655,118380,118800,119195,119285,120604,121071,121104,121474,121854,122420,123388,124264,124338,125396,126344,126414,126491,126890,127015,127353,128745,130374,132418,132736,132815,133071,133249,135942,136973,136996,137002,137821,138072,138209,138338,138362,138762,138779,138931,141434,141742,142851,143783,144013,144068,144533,144632,145408,145661,145709,145713,146455,146602,146694,147546,148462,148491,148939,150745,151171,151634,153883,153890,154169,154232,154345,154395,154399,154483,154616,154675,154862,154897,155274,155645,155814,155907,156154,156335,156697,157322,157607,159578,160061,160156,160479,162025,162078,162080,163836,164443,165005,165729,165875,166440,166584,166609,166941,167046,167146,167424,167853,168062,168171,168257,168440,169720,170109,170216,170703,171089,171182,171227,172431,172844,172897,173749,173903,174107,174446,174497,174514,174985,175086,175116,175743,176316,177050,177350,177424,179432,179691,179760,180163,180262,180362,181084,181647,181874,181877,182277,182302,182795,183676,183683,184727,185055,185123,185157,185349,185417,185504,185902,185963,186138,186202,186295,186482,186909,187233,187730,187756,188294,188411,188776,188821,189204,189626,190200,190254,190536,190581,191179,191203,191264,191337,191438,191961,192079,193038,193151,193203,193348,193603,194001,194359,194640,194863,196180,196353,196381,196469,196497,198501,198684) 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(): [3949.19 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/_owner_info"
95	View	render "sf_app_dir/modules/home/templates/_owner_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(): [18.51 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199944
108	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
109	Creole	executeQuery(): [6.60 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199700
110	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
111	Creole	executeQuery(): [0.60 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199697
112	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
113	Creole	executeQuery(): [12.73 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199458
114	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
115	Creole	executeQuery(): [11.24 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199338
116	View	initialize view for "common_page/_include_vif_js"
117	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_include_vif_js.php"
118	PartialHelper	Generate cache key
119	View	initialize view for "common_page/_fancybox_javascript"
120	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
121	PartialHelper	Generate cache key
122	View	decorate content with "sf_app_dir/templates/view_layout.php"
123	View	render "sf_app_dir/templates/view_layout.php"
124	View	initialize view for "common_page/_responsive_javascript"
125	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_javascript.php"
126	PartialHelper	Generate cache key
127	View	initialize view for "common_page/_google_analytics"
128	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_google_analytics.php"
129	PartialHelper	Generate cache key
130	View	initialize view for "common_page/_header_links"
131	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_header_links.php"
132	View	initialize view for "common_page/_fancybox_javascript"
133	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
134	PartialHelper	Generate cache key
135	View	initialize view for "common_page/_cookie_policy"
136	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_cookie_policy.php"
137	PartialHelper	Generate cache key
138	PartialHelper	Generate cache key
139	View	initialize view for "common_page/_responsive_top_menu"
140	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_top_menu.php"
141	PartialHelper	Generate cache key
142	View	initialize view for "common_page/_top_menu"
143	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_top_menu.php"
144	PartialHelper	Generate cache key
145	View	initialize view for "common_page/_footer_javascript"
146	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer_javascript.php"
147	PartialHelper	Generate cache key
148	View	initialize view for "common_page/_footer"
149	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer.php"
150	PartialHelper	Generate cache key

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    ID_AD: 200086
    action: view
    id: 200086
    make: ford
    model: bronco
    module: home
attributeHolder: 
  symfony/default: 
    HOME_LINK: <a title="cap_na_default_title_3" href="https://www.classicdigest.com/cars/index_dev.php">Classic Cars</a>
    base_domain: .classicdigest.com
    display_que_ans_setction: Y
    show_cookie_policy: 1

Response

---
cookies: 
httpHeaders: 
  Content-Type: text/html; charset=utf-8
parameterHolder: 
  helper/asset/auto/httpmeta: 
    Content-Type: text/html; charset=utf-8
  helper/asset/auto/javascript: 
    /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main
  helper/asset/auto/meta: 
    author: Fiare
    description: Netiauto - Osta tai Myy vaihtoautot- Kauppa käy
    keywords: auto, autot, vaihtoautot, vaihtoauto, vaihtoautoliike, bensa, polttoaine, käytetyt, netiauto, osta, myy, käytetty, etsi, haku, ilmastointi, stereot, amatööri, moottori, katsastus, kesäauto, automaatti, kova, halpa, halvalla, kone, hyvä, nopea, ilmainen, ilmaiseksi, second hand, used, car, cars, hot, fast, good, cheap
    language: et,Estonian,ru,russia,fi,soumeksi,en,English
    other: Mach1 Oy:n kehittämä vaihtoautosivusto. netiauto.ee on sivusto yksityisille ilmoittajille sekä autoliikkeille. netiauto.ee:issa on erittäin monipuoliset hakutoiminnot, jotka helpottavat vaihtoautoa etsivää.
    revisit-after: 15 days
    robots: follow,index
    title: Netiauto - Osta tai Myy vaihtoautot- Kauppa käy
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
  symfony/action/view: 
    home_view_layout: view_layout
  symfony/response/http/headers: 
    Content-Type: text/html; charset=utf-8
  symfony/view/asset: 
    javascripts_included: 
    stylesheets_included:

Settings

---
app_params_adbox_slot: 6
app_params_image_limit: 25
app_params_pdf_limit: 1
app_params_site: Classic Cars
app_params_tot_limit_na: 50
app_params_tot_per_month_limit: 50
app_params_web_master: administrator@classicdigest.com
app_params_www: www.classicdigest.com/cars
app_url_na: https://www.classicdigest.com/cars/index_dev.php
app_url_nm: https://www.classicdigest.com/motorcycles/index_dev.php
app_url_site_url: https://www.classicdigest.com/cars/index_dev.php
css_jquery_ui_custom: jquery-ui-1.8.23.custom.min.css
css_jsquares: jsquares.min.css
css_responsive: responsive.min.css
css_style: style.min.css
homepage_sms_slots: 12
html_direction: ltr
html_left: left
html_right: right
jquery_url: https://ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js
js_banner: banner.min.js
js_common: common.min.js
js_effects: effects.js
js_html5_printshiv: html5shiv-printshiv.min.js
js_html5shiv: html5shiv.min.js
js_jsquares: mosiac/jquery.jsquares.min.js
js_lazy: lazyload/jquery.lazy.min.js
js_netiauto: netiauto
js_prototype: prototype.js
js_slider: slider.min.js
mod_home_enabled: 1
mod_home_is_internal: 
mod_home_view_class: sfPHP
quick_search_max_price: 10000000
quick_search_min_price: 0
sf_admin_web_dir: /sf/sf_admin
sf_app: cars
sf_app_config_dir: /web/classicdigest.com/apps/cars/config
sf_app_config_dir_name: config
sf_app_dir: /web/classicdigest.com/apps/cars
sf_app_i18n_dir: /web/classicdigest.com/lib/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: /web/classicdigest.com/apps/cars/lib
sf_app_lib_dir_name: lib
sf_app_module_action_dir_name: actions
sf_app_module_config_dir_name: config
sf_app_module_dir: /web/classicdigest.com/apps/cars/modules
sf_app_module_dir_name: modules
sf_app_module_i18n_dir_name: i18n
sf_app_module_lib_dir_name: lib
sf_app_module_template_dir_name: templates
sf_app_module_validate_dir_name: validate
sf_app_module_view_dir_name: views
sf_app_template_dir: /web/classicdigest.com/apps/cars/templates
sf_app_template_dir_name: templates
sf_apps_dir_name: apps
sf_autoloading_functions: 
sf_available: 1
sf_base_cache_dir: /web/classicdigest.com/cache/cars
sf_bin_dir: /web/classicdigest.com/batch
sf_bin_dir_name: batch
sf_cache: 1
sf_cache_dir: /web/classicdigest.com/cache/cars/dev
sf_cache_dir_name: cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock: 
sf_check_symfony_version: 
sf_compressed: 
sf_config_cache_dir: /web/classicdigest.com/cache/cars/dev/config
sf_config_dir: /web/classicdigest.com/config
sf_config_dir_name: config
sf_data_dir: /web/classicdigest.com/data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_module: default
sf_doc_dir: /web/classicdigest.com/data/doc
sf_doc_dir_name: doc
sf_enabled_modules: 
  - default
  - user
  - faSms
  - user_mail
  - faDealer
  - dealer_person
  - statistics
  - vote
  - faErrors
  - feedback
  - sfTCPDF
  - static
  - article
  - news
  - que_ans
  - favorite
  - category
  - sfCaptchaGD
  - service_index
  - club
  - sfLightboxPlugin
  - sfPropelNorthIdPlugin
  - facebook
  - tag_cloud
  - adbox
  - apijson
  - findAgent
  - fb_connect
  - fbGeneral
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: faErrors
sf_error_reporting: 2037
sf_escaping_method: ESC_ENTITIES
sf_escaping_strategy: bc
sf_etag: 
sf_i18n: 1
sf_i18n_cache: 1
sf_i18n_cache_dir: /web/classicdigest.com/cache/cars/dev/i18n
sf_i18n_debug: 
sf_i18n_default_culture: en
sf_i18n_source: gettext
sf_i18n_untranslated_prefix: [T]
sf_i18n_untranslated_suffix: [/T]
sf_lazy_cache_key: 
sf_lib_dir: /web/classicdigest.com/lib
sf_lib_dir_name: lib
sf_lightbox_css_dir: https://www.classicdigest.com/entity/css/sfLightboxPlugin/
sf_lightbox_images_dir: https://www.classicdigest.com/entity/images/sfLightboxPlugin/
sf_lightbox_js_dir: https://www.classicdigest.com/entity/js/sfLightboxPlugin/
sf_log_dir: /web/classicdigest.com/log
sf_log_dir_name: log
sf_logging_enabled: 1
sf_logging_history: 10
sf_logging_level: debug
sf_logging_period: 7
sf_logging_purge: 1
sf_logging_rotate: 
sf_login_action: loginRequired
sf_login_module: faErrors
sf_max_forwards: 5
sf_model_dir_name: model
sf_model_lib_dir: /web/classicdigest.com/lib/model
sf_module_cache_dir: /web/classicdigest.com/cache/cars/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: 
sf_orm: propel
sf_path_info_array: SERVER
sf_path_info_key: PATH_INFO
sf_plugins_dir: /web/classicdigest.com/plugins
sf_plugins_dir_name: plugins
sf_prototype_web_dir: /sf/prototype
sf_rich_text_js_dir: js/tiny_mce
sf_root_cache_dir: /web/classicdigest.com/cache
sf_root_dir: /web/classicdigest.com
sf_routing_defaults: 
  sf_culture: en
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers: 
  - Partial
  - Cache
  - Form
  - Date
  - faNettiX
  - faClient
  - Javascript
  - Validation
  - Object
  - Lightbox
sf_strip_comments: 1
sf_suffix: .
sf_symfony_data_dir: /web/clssymfony/data
sf_symfony_lib_dir: /web/clssymfony/lib
sf_template_cache_dir: /web/classicdigest.com/cache/cars/dev/template
sf_test: 
sf_test_cache_dir: /web/classicdigest.com/cache/cars/dev/test
sf_test_dir: /web/classicdigest.com/test
sf_test_dir_name: test
sf_timeout: 1800
sf_timer_start: 1740388606.7275
sf_unavailable_action: maintenance
sf_unavailable_module: util
sf_upload_dir: /web/classicdigest.com/web/uploads
sf_upload_dir_name: uploads
sf_url_format: PATH
sf_use_database: 1
sf_use_flash: 1
sf_use_process_cache: 1
sf_use_security: 1
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix:  
sf_validation_error_suffix:  
sf_web_debug: 1
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /web/classicdigest.com/web
sf_web_dir_name: web

Globals

---
cookie: 
env: 
files: 
get: 
post: 
server: 
  CONTENT_LENGTH: 
  CONTENT_TYPE: 
  DOCUMENT_ROOT: /web/classicdigest.com/web
  DOCUMENT_URI: /cars/index_dev.php/ford/bronco/200086
  FCGI_ROLE: RESPONDER
  GATEWAY_INTERFACE: CGI/1.1
  HOME: /var/lib/nginx
  HTTPS: on
  HTTP_ACCEPT: */*
  HTTP_ACCEPT_ENCODING: gzip, br, zstd, deflate
  HTTP_HOST: www.classicdigest.com
  HTTP_REFERER: https://classicdigest.com/cars/index_dev.php/ford/bronco/200086
  HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
  PATH_INFO: /ford/bronco/200086
  PATH_TRANSLATED: /web/classicdigest.com/web/ford/bronco/200086
  PHP_SELF: /cars/index_dev.php/ford/bronco/200086
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REMOTE_ADDR: 3.145.10.108
  REMOTE_PORT: 48428
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1740388606
  REQUEST_TIME_FLOAT: 1740388606.7262
  REQUEST_URI: /cars/index_dev.php/ford/bronco/200086
  SCRIPT_FILENAME: /web/classicdigest.com/web/cars/index_dev.php
  SCRIPT_NAME: /cars/index_dev.php
  SERVER_ADDR: 10.8.1.209
  SERVER_NAME: www.classicdigest.com
  SERVER_PORT: 443
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SOFTWARE: nginx/1.18.0
  USER: nginx
session: 
  visit_page: 
    - home/view

Php

---
php: 7.2.34
os: Linux classicdigestprod1 4.14.336-179.559.amzn1.x86_64 #1 SMP Tue Feb 13 10:34:24 UTC 2024 x86_64
extensions: 
  - Core
  - date
  - libxml
  - openssl
  - pcre
  - zlib
  - filter
  - hash
  - Reflection
  - SPL
  - session
  - standard
  - cgi-fcgi
  - bz2
  - calendar
  - ctype
  - curl
  - dom
  - mbstring
  - fileinfo
  - ftp
  - gd
  - gettext
  - iconv
  - json
  - exif
  - mysqlnd
  - PDO
  - Phar
  - posix
  - shmop
  - SimpleXML
  - sockets
  - sqlite3
  - sysvmsg
  - sysvsem
  - sysvshm
  - tokenizer
  - xml
  - xmlwriter
  - xsl
  - zip
  - mcrypt
  - mysqli
  - pdo_mysql
  - pdo_sqlite
  - wddx
  - xmlreader
  - memcache

SQL queries

SET time_zone = '+01:00'
SET time_zone = '+01:00'
SET time_zone = '+01:00'
SET time_zone = '+01:00'
SET time_zone = '+01:00'
[5.04 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=200086 AND car.STATUS='F'
[8.16 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 (1891)
[5.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, 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=200086
[16.01 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=200086
[9.74 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=200086 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2'
[9.58 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'
[16.46 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 (200086) ORDER BY carimg.ORD ASC
[7.61 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 (1891)
[10.01 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 (1891)
[8.47 ms] SELECT dealer.ID_MAKE, dealer.HIT_COUNTER FROM dealer WHERE dealer.ID_DEALER=1891
[1.35 ms] SELECT netti_dealer.HAS_SITE, netti_dealer.SIMPLE_URL, netti_dealer.SLOGAN FROM netti_dealer WHERE netti_dealer.ID_DEALER=1891
[8.19 ms] SELECT dealer_permission.ID, dealer_permission.ID_DEALER, dealer_permission.WHICH, dealer_permission.DATE_CREATE FROM dealer_permission WHERE dealer_permission.ID_DEALER=1891
[14.06 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=1891 AND dealer_permission.WHICH='Q'
[3.70 ms] SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=63 AND model.ID=707 AND make.ID=model.ID_MAKE
[9.77 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 != 200086 AND car.ID_MODEL = '707' ) 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 != 200086 AND car.ID_MODEL = '707' ) ) AS count
[4.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.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 != 200086 AND car.ID_MODEL = '707' ) 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 != 200086 AND car.ID_MODEL = '707' ) ORDER BY ID DESC LIMIT 5
[4.43 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 (199944,199700,199697,199458,199338) ORDER BY carimg.ORD ASC
[1.42 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 != '200086' AND car.ID_NETTI_USER = '1891' ) 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 != '200086' AND car.ID_NETTI_USER = '1891' ) ) AS count
[1.48 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=63 AND car.ID_MODEL=707 AND car.STATUS='F'
[103.89 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=63 AND sold_car.ID_MODEL=707 AND sold_car.STATUS='S'
[1.86 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 (66497,90831,153233,153723,172391,175068,190437,191780,192086,192887,193153,194094,195861,196442,196692,196894,197489,198180,198470,198557,198724,198912,199338,199458,199697,199700,199944,200086) GROUP BY cmonth ORDER BY date_create
[12.27 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 (24142,30931,31056,31930,31965,32273,34829,41914,43897,46234,50263,56234,56240,57029,57030,57782,58593,58674,64553,65159,69330,69391,69392,74275,76676,76998,77628,78654,83076,84484,85152,85343,86453,86591,88458,88695,88918,89008,90145,92877,95564,95686,95731,98707,98708,102638,103109,103136,106292,106318,108051,109632,110892,110926,111774,112896,113006,113515,114314,114579,115029,115184,115428,116084,116233,116645,116786,117148,117655,118380,118800,119195,119285,120604,121071,121104,121474,121854,122420,123388,124264,124338,125396,126344,126414,126491,126890,127015,127353,128745,130374,132418,132736,132815,133071,133249,135942,136973,136996,137002,137821,138072,138209,138338,138362,138762,138779,138931,141434,141742,142851,143783,144013,144068,144533,144632,145408,145661,145709,145713,146455,146602,146694,147546,148462,148491,148939,150745,151171,151634,153883,153890,154169,154232,154345,154395,154399,154483,154616,154675,154862,154897,155274,155645,155814,155907,156154,156335,156697,157322,157607,159578,160061,160156,160479,162025,162078,162080,163836,164443,165005,165729,165875,166440,166584,166609,166941,167046,167146,167424,167853,168062,168171,168257,168440,169720,170109,170216,170703,171089,171182,171227,172431,172844,172897,173749,173903,174107,174446,174497,174514,174985,175086,175116,175743,176316,177050,177350,177424,179432,179691,179760,180163,180262,180362,181084,181647,181874,181877,182277,182302,182795,183676,183683,184727,185055,185123,185157,185349,185417,185504,185902,185963,186138,186202,186295,186482,186909,187233,187730,187756,188294,188411,188776,188821,189204,189626,190200,190254,190536,190581,191179,191203,191264,191337,191438,191961,192079,193038,193151,193203,193348,193603,194001,194359,194640,194863,196180,196353,196381,196469,196497,198501,198684) GROUP BY sold_week ORDER BY scs.date_actual_sold
[10.00 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 (24142,30931,31056,31930,31965,32273,34829,41914,43897,46234,50263,56234,56240,57029,57030,57782,58593,58674,64553,65159,69330,69391,69392,74275,76676,76998,77628,78654,83076,84484,85152,85343,86453,86591,88458,88695,88918,89008,90145,92877,95564,95686,95731,98707,98708,102638,103109,103136,106292,106318,108051,109632,110892,110926,111774,112896,113006,113515,114314,114579,115029,115184,115428,116084,116233,116645,116786,117148,117655,118380,118800,119195,119285,120604,121071,121104,121474,121854,122420,123388,124264,124338,125396,126344,126414,126491,126890,127015,127353,128745,130374,132418,132736,132815,133071,133249,135942,136973,136996,137002,137821,138072,138209,138338,138362,138762,138779,138931,141434,141742,142851,143783,144013,144068,144533,144632,145408,145661,145709,145713,146455,146602,146694,147546,148462,148491,148939,150745,151171,151634,153883,153890,154169,154232,154345,154395,154399,154483,154616,154675,154862,154897,155274,155645,155814,155907,156154,156335,156697,157322,157607,159578,160061,160156,160479,162025,162078,162080,163836,164443,165005,165729,165875,166440,166584,166609,166941,167046,167146,167424,167853,168062,168171,168257,168440,169720,170109,170216,170703,171089,171182,171227,172431,172844,172897,173749,173903,174107,174446,174497,174514,174985,175086,175116,175743,176316,177050,177350,177424,179432,179691,179760,180163,180262,180362,181084,181647,181874,181877,182277,182302,182795,183676,183683,184727,185055,185123,185157,185349,185417,185504,185902,185963,186138,186202,186295,186482,186909,187233,187730,187756,188294,188411,188776,188821,189204,189626,190200,190254,190536,190581,191179,191203,191264,191337,191438,191961,192079,193038,193151,193203,193348,193603,194001,194359,194640,194863,196180,196353,196381,196469,196497,198501,198684) GROUP BY sold_month ORDER BY scs.date_actual_sold
[3949.19 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
[18.51 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199944
[6.60 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199700
[0.60 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199697
[12.73 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199458
[11.24 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199338

type	calls	time (ms)
Configuration	13	1.50
Action "home/view"	1	4302.08
Database	29	4272.65
View "Success" for "home/view"	1	75.71
Partial "home/_vif_images"	1	0.32
Partial "common_page/_social_buttons"	1	0.07
Partial "home/_vif_info"	1	0.15
Partial "home/_owner_info"	1	0.12
Partial "common_page/_price_development_graph"	1	0.05
Partial "common_page/_sell_time_price_graph"	1	0.04
Partial "common_page/_price_gauge_graph"	1	0.04
Partial "common_page/_include_vif_js"	1	0.07
Partial "common_page/_fancybox_javascript"	2	0.17
Partial "common_page/_responsive_javascript"	1	0.05
Partial "common_page/_google_analytics"	1	0.04
Partial "common_page/_header_links"	1	0.67
Partial "common_page/_cookie_policy"	1	0.07
Partial "common_page/_responsive_top_menu"	1	0.11
Partial "common_page/_top_menu"	1	0.12
Partial "common_page/_footer_javascript"	1	0.10
Partial "common_page/_footer"	1	0.10

Ford Bronco 2005

Car Facts

Seller Information

ClassicDigest Market Radar on Ford Bronco

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers