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' => 'mercedes-benz', 'model' => '190sl', 'id' => '195543', '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.16 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=195543 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.26 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 (1829)
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.16 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=195543
38	Creole	prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=?
39	Creole	executeQuery(): [2.16 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=195543
40	Creole	prepareStatement(): SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=? AND fa_payment_order.PAYMENT_STATUS=? AND fa_payment_order.UPSELLS_TAKEN=?
41	Creole	executeQuery(): [0.67 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=195543 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(): [1.39 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 (195543) ORDER BY carimg.ORD ASC
45	Creole	executeQuery(): [0.38 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 (195543) ORDER BY carimg.ORD ASC
46	Creole	prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?)
47	Creole	executeQuery(): [0.43 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 (1829)
48	Creole	prepareStatement(): SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=? AND model.ID=? AND make.ID=model.ID_MAKE
49	Creole	executeQuery(): [1.84 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=112 AND model.ID=1180 AND make.ID=model.ID_MAKE
50	Creole	prepareStatement(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 195543 AND car.ID_MODEL = '1180' ) 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 != 195543 AND car.ID_MODEL = '1180' ) ORDER BY ID DESC
51	Creole	prepareStatement(): SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 195543 AND car.ID_MODEL = '1180' ) 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 != 195543 AND car.ID_MODEL = '1180' ) ) AS count
52	Creole	executeQuery(): [3.87 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 != 195543 AND car.ID_MODEL = '1180' ) 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 != 195543 AND car.ID_MODEL = '1180' ) ) AS count
53	Creole	applyLimit(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != 195543 AND car.ID_MODEL = '1180' ) 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 != 195543 AND car.ID_MODEL = '1180' ) ORDER BY ID DESC, offset: 0, limit: 5
54	Creole	executeQuery(): [5.25 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 != 195543 AND car.ID_MODEL = '1180' ) 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 != 195543 AND car.ID_MODEL = '1180' ) ORDER BY ID DESC LIMIT 5
55	Creole	prepareStatement(): SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199561,198452,197549,197500,195133) ORDER BY carimg.ORD ASC
56	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 (199561,198452,197549,197500,195133) ORDER BY carimg.ORD ASC
57	Creole	prepareStatement(): ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.ID AS ID_AD, UNIX_TIMESTAMP(car.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(car.DATE_MODIFY) AS MODIFY_DATE, car_info.ID_CAR_TYPE AS ID_CAR_TYPE, car_info.GENERAL_DESCRIPTION AS GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION AS DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION AS COMPETITION_DESCRIPTION, car_info.NOTE FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '195543' AND car.ID_NETTI_USER = '1829' ) 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 != '195543' AND car.ID_NETTI_USER = '1829' ) ORDER BY ID DESC
58	Creole	prepareStatement(): SELECT COUNT( * ) AS count FROM ( ( SELECT car.id FROM cd_cars.car LEFT JOIN cd_cars.make ON (car.ID_MAKE=make.ID) LEFT JOIN cd_cars.model ON (car.ID_MODEL=model.ID) LEFT JOIN cd_cars.car_info ON (car.ID=car_info.ID_CAR) WHERE car.status = 'F' AND car.ID != '195543' AND car.ID_NETTI_USER = '1829' ) 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 != '195543' AND car.ID_NETTI_USER = '1829' ) ) AS count
59	Creole	executeQuery(): [0.97 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 != '195543' AND car.ID_NETTI_USER = '1829' ) 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 != '195543' AND car.ID_NETTI_USER = '1829' ) ) AS count
60	Creole	prepareStatement(): SELECT car.ID FROM car WHERE car.ID_MAKE=? AND car.ID_MODEL=? AND car.STATUS=?
61	Creole	executeQuery(): [0.89 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=112 AND car.ID_MODEL=1180 AND car.STATUS='F'
62	Creole	prepareStatement(): SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=? AND sold_car.ID_MODEL=? AND sold_car.STATUS=?
63	Creole	executeQuery(): [31.55 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=112 AND sold_car.ID_MODEL=1180 AND sold_car.STATUS='S'
64	Creole	prepareStatement(): SELECT id, id_ad, ROUND(AVG(price)) AS avg_price, DATE_FORMAT(date_create, "%m-%Y") AS cmonth, date_create FROM price_history WHERE date_create >= DATE_SUB(SYSDATE(), INTERVAL 1 YEAR) AND id_ad IN (26541,26542,28257,31419,31420,35556,35557,43978,44021,60923,86066,86693,98680,106139,110780,117618,117803,129692,129986,130181,130196,130232,130352,130554,131012,131820,132229,133926,135245,136223,136488,141970,141976,142055,143054,148102,150540,151251,156059,157113,159052,159075,159090,159111,159723,160310,165209,171825,178643,180395,180498,181746,184018,184470,186643,190706,191296,192593,195133,195543,197500,197549,198452,199561) GROUP BY cmonth ORDER BY date_create
65	Creole	executeQuery(): [2.98 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 (26541,26542,28257,31419,31420,35556,35557,43978,44021,60923,86066,86693,98680,106139,110780,117618,117803,129692,129986,130181,130196,130232,130352,130554,131012,131820,132229,133926,135245,136223,136488,141970,141976,142055,143054,148102,150540,151251,156059,157113,159052,159075,159090,159111,159723,160310,165209,171825,178643,180395,180498,181746,184018,184470,186643,190706,191296,192593,195133,195543,197500,197549,198452,199561) GROUP BY cmonth ORDER BY date_create
66	Creole	prepareStatement(): SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%V" ) AS sold_week, DATE_FORMAT(scs.date_actual_sold, "%V-%Y") AS wmonth FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND sc.price_ask > 0 AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 5 YEAR) AND scs.id_ad IN (20660,20663,20858,21356,21421,21458,21568,21569,21639,21975,22167,22169,22227,22323,22324,22325,22369,22406,22644,23282,23419,23421,23654,23984,24182,24357,24360,24362,24759,24822,24974,25015,25066,25191,25405,25482,25776,25852,25961,25984,26181,26315,26417,26474,26684,26965,26966,26979,27095,27290,27390,27399,27436,27495,27668,27705,27706,27707,28125,28416,28685,28686,29314,29379,29579,29580,29612,29726,29727,29807,29869,30125,30228,30425,31681,31682,31822,31824,31991,32321,32398,32930,33238,33457,33580,33641,33650,33941,33974,34376,34804,34805,34855,35540,35541,35576,36171,36200,36230,36757,36781,36847,38871,38906,39509,39691,39719,41954,42378,43279,43847,44068,44096,44097,45509,45743,45764,46170,46342,46393,46434,46435,46497,46512,46874,46970,47173,47519,47544,47601,47602,47880,48574,48841,49831,49925,50238,50283,50301,50717,50858,50865,50909,51048,51090,52464,53154,53155,53157,53158,53270,53668,53669,54239,54632,56617,56618,57627,57836,58850,60024,60025,60162,60330,61051,61392,61875,62266,62438,62900,62901,62902,63856,64473,65409,65598,65902,66783,67468,67889,68458,68577,69349,69639,70411,70500,71233,71288,72024,72044,72693,73512,74286,74522,75077,76051,76150,76590,76883,76896,76952,76971,77000,78630,81945,81946,83066,83355,83425,84084,84085,84086,84495,84798,85039,85040,85127,85211,85285,85286,85397,85789,85915,86034,86168,86418,86501,86619,86818,87052,88766,88889,89442,89611,90231,91242,91535,91550,91592,91593,91631,91676,91714,91936,91972,92015,92175,92289,92290,92291,92321,92467,92468,92518,92981,93755,94321,94487,95135,95357,95492,95641,95914,97777,97823,97907,97908,98139,98283,98284,99100,99372,100118,100365,100728,100862,101058,101805,102113,102165,102283,102648,102679,102683,102722,102954,103023,103024,103141,103326,103455,103485,103614,103615,103744,103906,104359,104515,105143,105144,105201,105384,105385,105531,105617,105737,105747,105748,105749,106458,107095,107348,107491,107517,107531,108192,108240,108394,108423,108788,108949,109224,109401,109537,109649,109650,110948,111114,111818,111820,111991,112331,112336,112458,112478,113032,113033,113065,113281,113422,113461,113558,113590,113591,113623,113936,114059,114088,114213,114688,115315,115632,116253,116296,116698,116789,117581,117582,117808,117809,118070,118183,118255,118412,118445,118484,118653,118654,118655,118729,118819,118936,119351,120398,121181,121572,121804,121805,121915,121916,122067,122306,122499,122500,122588,122721,123603,124160,124301,125478,126121,126123,126252,126584,126718,126722,126739,126846,127245,127666,127785,128178,128179,128231,128232,128233,128693,129729,129753,129770,129863,129914,130314,130330,130331,130356,130365,130453,130521,130522,131685,131686,131819,131967,132700,132760,132795,133551,133634,133635,133970,133971,135276,135489,135628,135900,135901,135911,135928,135996,135997,136233,136390,136749,136776,137511,138813,138814,139606,139675,140876,141117,141291,141794,142357,142758,143029,143384,143556,143557,144072,144139,144742,144985,145369,145447,145865,146052,146053,146208,146246,146502,146822,146823,146824,146825,147312,147421,147595,147654,147920,148062,148063,148112,148344,148416,149420,149604,149784,149827,150201,150417,150554,150704,151291,151328,151339,151690,151993,152423,152552,152636,152639,152640,152764,154440,155791,156009,156111,156381,156540,156958,156959,157521,157901,157934,158122,158408,158464,158703,158958,159096,159221,159411,159479,159524,159726,159903,159935,159972,160536,160594,161382,162244,162933,163204,163678,163764,164113,164611,164949,165136,165702,165836,165883,168013,168120,168300,168497,168515,168732,168973,169086,169209,169262,169473,169593,169670,169865,169867,169953,170076,170127,170481,170543,170947,170948,170949,171039,171252,171358,171399,171758,171824,172029,172750,172786,173407,173409,173780,173785,173913,174142,174433,174562,174590,174617,174829,175153,175594,175841,175971,176051,176223,176434,176551,176810,177477,177782,177939,177956,178044,178045,178344,178930,179624,179957,180059,180300,180989,181745,182176,182845,182846,183084,183549,183550,184944,185876,186006,187022,188579,188628,189054,189605,189830,190304,190569,191485,191707,191984,192157,192262,192428,192547,192997,194591,194833,194834,195007) GROUP BY sold_week ORDER BY scs.date_actual_sold
67	Creole	executeQuery(): [4.73 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 (20660,20663,20858,21356,21421,21458,21568,21569,21639,21975,22167,22169,22227,22323,22324,22325,22369,22406,22644,23282,23419,23421,23654,23984,24182,24357,24360,24362,24759,24822,24974,25015,25066,25191,25405,25482,25776,25852,25961,25984,26181,26315,26417,26474,26684,26965,26966,26979,27095,27290,27390,27399,27436,27495,27668,27705,27706,27707,28125,28416,28685,28686,29314,29379,29579,29580,29612,29726,29727,29807,29869,30125,30228,30425,31681,31682,31822,31824,31991,32321,32398,32930,33238,33457,33580,33641,33650,33941,33974,34376,34804,34805,34855,35540,35541,35576,36171,36200,36230,36757,36781,36847,38871,38906,39509,39691,39719,41954,42378,43279,43847,44068,44096,44097,45509,45743,45764,46170,46342,46393,46434,46435,46497,46512,46874,46970,47173,47519,47544,47601,47602,47880,48574,48841,49831,49925,50238,50283,50301,50717,50858,50865,50909,51048,51090,52464,53154,53155,53157,53158,53270,53668,53669,54239,54632,56617,56618,57627,57836,58850,60024,60025,60162,60330,61051,61392,61875,62266,62438,62900,62901,62902,63856,64473,65409,65598,65902,66783,67468,67889,68458,68577,69349,69639,70411,70500,71233,71288,72024,72044,72693,73512,74286,74522,75077,76051,76150,76590,76883,76896,76952,76971,77000,78630,81945,81946,83066,83355,83425,84084,84085,84086,84495,84798,85039,85040,85127,85211,85285,85286,85397,85789,85915,86034,86168,86418,86501,86619,86818,87052,88766,88889,89442,89611,90231,91242,91535,91550,91592,91593,91631,91676,91714,91936,91972,92015,92175,92289,92290,92291,92321,92467,92468,92518,92981,93755,94321,94487,95135,95357,95492,95641,95914,97777,97823,97907,97908,98139,98283,98284,99100,99372,100118,100365,100728,100862,101058,101805,102113,102165,102283,102648,102679,102683,102722,102954,103023,103024,103141,103326,103455,103485,103614,103615,103744,103906,104359,104515,105143,105144,105201,105384,105385,105531,105617,105737,105747,105748,105749,106458,107095,107348,107491,107517,107531,108192,108240,108394,108423,108788,108949,109224,109401,109537,109649,109650,110948,111114,111818,111820,111991,112331,112336,112458,112478,113032,113033,113065,113281,113422,113461,113558,113590,113591,113623,113936,114059,114088,114213,114688,115315,115632,116253,116296,116698,116789,117581,117582,117808,117809,118070,118183,118255,118412,118445,118484,118653,118654,118655,118729,118819,118936,119351,120398,121181,121572,121804,121805,121915,121916,122067,122306,122499,122500,122588,122721,123603,124160,124301,125478,126121,126123,126252,126584,126718,126722,126739,126846,127245,127666,127785,128178,128179,128231,128232,128233,128693,129729,129753,129770,129863,129914,130314,130330,130331,130356,130365,130453,130521,130522,131685,131686,131819,131967,132700,132760,132795,133551,133634,133635,133970,133971,135276,135489,135628,135900,135901,135911,135928,135996,135997,136233,136390,136749,136776,137511,138813,138814,139606,139675,140876,141117,141291,141794,142357,142758,143029,143384,143556,143557,144072,144139,144742,144985,145369,145447,145865,146052,146053,146208,146246,146502,146822,146823,146824,146825,147312,147421,147595,147654,147920,148062,148063,148112,148344,148416,149420,149604,149784,149827,150201,150417,150554,150704,151291,151328,151339,151690,151993,152423,152552,152636,152639,152640,152764,154440,155791,156009,156111,156381,156540,156958,156959,157521,157901,157934,158122,158408,158464,158703,158958,159096,159221,159411,159479,159524,159726,159903,159935,159972,160536,160594,161382,162244,162933,163204,163678,163764,164113,164611,164949,165136,165702,165836,165883,168013,168120,168300,168497,168515,168732,168973,169086,169209,169262,169473,169593,169670,169865,169867,169953,170076,170127,170481,170543,170947,170948,170949,171039,171252,171358,171399,171758,171824,172029,172750,172786,173407,173409,173780,173785,173913,174142,174433,174562,174590,174617,174829,175153,175594,175841,175971,176051,176223,176434,176551,176810,177477,177782,177939,177956,178044,178045,178344,178930,179624,179957,180059,180300,180989,181745,182176,182845,182846,183084,183549,183550,184944,185876,186006,187022,188579,188628,189054,189605,189830,190304,190569,191485,191707,191984,192157,192262,192428,192547,192997,194591,194833,194834,195007) GROUP BY sold_week ORDER BY scs.date_actual_sold
68	Creole	prepareStatement(): SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sc.id IN (20660,20663,20858,21356,21421,21458,21568,21569,21639,21975,22167,22169,22227,22323,22324,22325,22369,22406,22644,23282,23419,23421,23654,23984,24182,24357,24360,24362,24759,24822,24974,25015,25066,25191,25405,25482,25776,25852,25961,25984,26181,26315,26417,26474,26684,26965,26966,26979,27095,27290,27390,27399,27436,27495,27668,27705,27706,27707,28125,28416,28685,28686,29314,29379,29579,29580,29612,29726,29727,29807,29869,30125,30228,30425,31681,31682,31822,31824,31991,32321,32398,32930,33238,33457,33580,33641,33650,33941,33974,34376,34804,34805,34855,35540,35541,35576,36171,36200,36230,36757,36781,36847,38871,38906,39509,39691,39719,41954,42378,43279,43847,44068,44096,44097,45509,45743,45764,46170,46342,46393,46434,46435,46497,46512,46874,46970,47173,47519,47544,47601,47602,47880,48574,48841,49831,49925,50238,50283,50301,50717,50858,50865,50909,51048,51090,52464,53154,53155,53157,53158,53270,53668,53669,54239,54632,56617,56618,57627,57836,58850,60024,60025,60162,60330,61051,61392,61875,62266,62438,62900,62901,62902,63856,64473,65409,65598,65902,66783,67468,67889,68458,68577,69349,69639,70411,70500,71233,71288,72024,72044,72693,73512,74286,74522,75077,76051,76150,76590,76883,76896,76952,76971,77000,78630,81945,81946,83066,83355,83425,84084,84085,84086,84495,84798,85039,85040,85127,85211,85285,85286,85397,85789,85915,86034,86168,86418,86501,86619,86818,87052,88766,88889,89442,89611,90231,91242,91535,91550,91592,91593,91631,91676,91714,91936,91972,92015,92175,92289,92290,92291,92321,92467,92468,92518,92981,93755,94321,94487,95135,95357,95492,95641,95914,97777,97823,97907,97908,98139,98283,98284,99100,99372,100118,100365,100728,100862,101058,101805,102113,102165,102283,102648,102679,102683,102722,102954,103023,103024,103141,103326,103455,103485,103614,103615,103744,103906,104359,104515,105143,105144,105201,105384,105385,105531,105617,105737,105747,105748,105749,106458,107095,107348,107491,107517,107531,108192,108240,108394,108423,108788,108949,109224,109401,109537,109649,109650,110948,111114,111818,111820,111991,112331,112336,112458,112478,113032,113033,113065,113281,113422,113461,113558,113590,113591,113623,113936,114059,114088,114213,114688,115315,115632,116253,116296,116698,116789,117581,117582,117808,117809,118070,118183,118255,118412,118445,118484,118653,118654,118655,118729,118819,118936,119351,120398,121181,121572,121804,121805,121915,121916,122067,122306,122499,122500,122588,122721,123603,124160,124301,125478,126121,126123,126252,126584,126718,126722,126739,126846,127245,127666,127785,128178,128179,128231,128232,128233,128693,129729,129753,129770,129863,129914,130314,130330,130331,130356,130365,130453,130521,130522,131685,131686,131819,131967,132700,132760,132795,133551,133634,133635,133970,133971,135276,135489,135628,135900,135901,135911,135928,135996,135997,136233,136390,136749,136776,137511,138813,138814,139606,139675,140876,141117,141291,141794,142357,142758,143029,143384,143556,143557,144072,144139,144742,144985,145369,145447,145865,146052,146053,146208,146246,146502,146822,146823,146824,146825,147312,147421,147595,147654,147920,148062,148063,148112,148344,148416,149420,149604,149784,149827,150201,150417,150554,150704,151291,151328,151339,151690,151993,152423,152552,152636,152639,152640,152764,154440,155791,156009,156111,156381,156540,156958,156959,157521,157901,157934,158122,158408,158464,158703,158958,159096,159221,159411,159479,159524,159726,159903,159935,159972,160536,160594,161382,162244,162933,163204,163678,163764,164113,164611,164949,165136,165702,165836,165883,168013,168120,168300,168497,168515,168732,168973,169086,169209,169262,169473,169593,169670,169865,169867,169953,170076,170127,170481,170543,170947,170948,170949,171039,171252,171358,171399,171758,171824,172029,172750,172786,173407,173409,173780,173785,173913,174142,174433,174562,174590,174617,174829,175153,175594,175841,175971,176051,176223,176434,176551,176810,177477,177782,177939,177956,178044,178045,178344,178930,179624,179957,180059,180300,180989,181745,182176,182845,182846,183084,183549,183550,184944,185876,186006,187022,188579,188628,189054,189605,189830,190304,190569,191485,191707,191984,192157,192262,192428,192547,192997,194591,194833,194834,195007) GROUP BY sold_month ORDER BY scs.date_actual_sold
69	Creole	executeQuery(): [7.98 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 (20660,20663,20858,21356,21421,21458,21568,21569,21639,21975,22167,22169,22227,22323,22324,22325,22369,22406,22644,23282,23419,23421,23654,23984,24182,24357,24360,24362,24759,24822,24974,25015,25066,25191,25405,25482,25776,25852,25961,25984,26181,26315,26417,26474,26684,26965,26966,26979,27095,27290,27390,27399,27436,27495,27668,27705,27706,27707,28125,28416,28685,28686,29314,29379,29579,29580,29612,29726,29727,29807,29869,30125,30228,30425,31681,31682,31822,31824,31991,32321,32398,32930,33238,33457,33580,33641,33650,33941,33974,34376,34804,34805,34855,35540,35541,35576,36171,36200,36230,36757,36781,36847,38871,38906,39509,39691,39719,41954,42378,43279,43847,44068,44096,44097,45509,45743,45764,46170,46342,46393,46434,46435,46497,46512,46874,46970,47173,47519,47544,47601,47602,47880,48574,48841,49831,49925,50238,50283,50301,50717,50858,50865,50909,51048,51090,52464,53154,53155,53157,53158,53270,53668,53669,54239,54632,56617,56618,57627,57836,58850,60024,60025,60162,60330,61051,61392,61875,62266,62438,62900,62901,62902,63856,64473,65409,65598,65902,66783,67468,67889,68458,68577,69349,69639,70411,70500,71233,71288,72024,72044,72693,73512,74286,74522,75077,76051,76150,76590,76883,76896,76952,76971,77000,78630,81945,81946,83066,83355,83425,84084,84085,84086,84495,84798,85039,85040,85127,85211,85285,85286,85397,85789,85915,86034,86168,86418,86501,86619,86818,87052,88766,88889,89442,89611,90231,91242,91535,91550,91592,91593,91631,91676,91714,91936,91972,92015,92175,92289,92290,92291,92321,92467,92468,92518,92981,93755,94321,94487,95135,95357,95492,95641,95914,97777,97823,97907,97908,98139,98283,98284,99100,99372,100118,100365,100728,100862,101058,101805,102113,102165,102283,102648,102679,102683,102722,102954,103023,103024,103141,103326,103455,103485,103614,103615,103744,103906,104359,104515,105143,105144,105201,105384,105385,105531,105617,105737,105747,105748,105749,106458,107095,107348,107491,107517,107531,108192,108240,108394,108423,108788,108949,109224,109401,109537,109649,109650,110948,111114,111818,111820,111991,112331,112336,112458,112478,113032,113033,113065,113281,113422,113461,113558,113590,113591,113623,113936,114059,114088,114213,114688,115315,115632,116253,116296,116698,116789,117581,117582,117808,117809,118070,118183,118255,118412,118445,118484,118653,118654,118655,118729,118819,118936,119351,120398,121181,121572,121804,121805,121915,121916,122067,122306,122499,122500,122588,122721,123603,124160,124301,125478,126121,126123,126252,126584,126718,126722,126739,126846,127245,127666,127785,128178,128179,128231,128232,128233,128693,129729,129753,129770,129863,129914,130314,130330,130331,130356,130365,130453,130521,130522,131685,131686,131819,131967,132700,132760,132795,133551,133634,133635,133970,133971,135276,135489,135628,135900,135901,135911,135928,135996,135997,136233,136390,136749,136776,137511,138813,138814,139606,139675,140876,141117,141291,141794,142357,142758,143029,143384,143556,143557,144072,144139,144742,144985,145369,145447,145865,146052,146053,146208,146246,146502,146822,146823,146824,146825,147312,147421,147595,147654,147920,148062,148063,148112,148344,148416,149420,149604,149784,149827,150201,150417,150554,150704,151291,151328,151339,151690,151993,152423,152552,152636,152639,152640,152764,154440,155791,156009,156111,156381,156540,156958,156959,157521,157901,157934,158122,158408,158464,158703,158958,159096,159221,159411,159479,159524,159726,159903,159935,159972,160536,160594,161382,162244,162933,163204,163678,163764,164113,164611,164949,165136,165702,165836,165883,168013,168120,168300,168497,168515,168732,168973,169086,169209,169262,169473,169593,169670,169865,169867,169953,170076,170127,170481,170543,170947,170948,170949,171039,171252,171358,171399,171758,171824,172029,172750,172786,173407,173409,173780,173785,173913,174142,174433,174562,174590,174617,174829,175153,175594,175841,175971,176051,176223,176434,176551,176810,177477,177782,177939,177956,178044,178045,178344,178930,179624,179957,180059,180300,180989,181745,182176,182845,182846,183084,183549,183550,184944,185876,186006,187022,188579,188628,189054,189605,189830,190304,190569,191485,191707,191984,192157,192262,192428,192547,192997,194591,194833,194834,195007) GROUP BY sold_month ORDER BY scs.date_actual_sold
70	Creole	prepareStatement(): SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC
71	Creole	executeQuery(): [1035.22 ms] SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC
72	Action	change layout to "view_layout"
73	View	initialize view for "home/view"
74	View	render "sf_app_dir/modules/home/templates/viewSuccess.php"
75	View	initialize view for "home/_vif_images"
76	View	render "sf_app_dir/modules/home/templates/_vif_images.php"
77	PartialHelper	Generate cache key
78	View	initialize view for "common_page/_social_buttons"
79	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php"
80	PartialHelper	Generate cache key
81	View	initialize view for "home/_vif_info"
82	View	render "sf_app_dir/modules/home/templates/_vif_info.php"
83	PartialHelper	Generate cache key
84	View	initialize view for "home/_owner_info"
85	View	render "sf_app_dir/modules/home/templates/_owner_info.php"
86	PartialHelper	Generate cache key
87	View	initialize view for "common_page/_price_development_graph"
88	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php"
89	PartialHelper	Generate cache key
90	View	initialize view for "common_page/_sell_time_price_graph"
91	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php"
92	PartialHelper	Generate cache key
93	View	initialize view for "common_page/_price_gauge_graph"
94	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php"
95	PartialHelper	Generate cache key
96	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
97	Creole	executeQuery(): [0.57 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199561
98	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
99	Creole	executeQuery(): [0.63 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198452
100	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
101	Creole	executeQuery(): [0.45 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197549
102	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
103	Creole	executeQuery(): [0.38 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197500
104	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
105	Creole	executeQuery(): [1.29 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=195133
106	View	initialize view for "common_page/_include_vif_js"
107	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_include_vif_js.php"
108	PartialHelper	Generate cache key
109	View	initialize view for "common_page/_fancybox_javascript"
110	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
111	PartialHelper	Generate cache key
112	View	decorate content with "sf_app_dir/templates/view_layout.php"
113	View	render "sf_app_dir/templates/view_layout.php"
114	View	initialize view for "common_page/_responsive_javascript"
115	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_javascript.php"
116	PartialHelper	Generate cache key
117	View	initialize view for "common_page/_google_analytics"
118	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_google_analytics.php"
119	PartialHelper	Generate cache key
120	View	initialize view for "common_page/_header_links"
121	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_header_links.php"
122	View	initialize view for "common_page/_fancybox_javascript"
123	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
124	PartialHelper	Generate cache key
125	View	initialize view for "common_page/_cookie_policy"
126	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_cookie_policy.php"
127	PartialHelper	Generate cache key
128	PartialHelper	Generate cache key
129	View	initialize view for "common_page/_responsive_top_menu"
130	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_top_menu.php"
131	PartialHelper	Generate cache key
132	View	initialize view for "common_page/_top_menu"
133	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_top_menu.php"
134	PartialHelper	Generate cache key
135	View	initialize view for "common_page/_footer_javascript"
136	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer_javascript.php"
137	PartialHelper	Generate cache key
138	View	initialize view for "common_page/_footer"
139	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer.php"
140	PartialHelper	Generate cache key

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    ID_AD: 195543
    action: view
    id: 195543
    make: mercedes-benz
    model: 190sl
    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
    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: 1732341090.6053
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: 
  RWSESSID: f5955a495e75d98627407741dd7ec9da
env: 
files: 
get: 
post: 
server: 
  CONTENT_LENGTH: 
  CONTENT_TYPE: 
  DOCUMENT_ROOT: /web/classicdigest.com/web
  DOCUMENT_URI: /cars/index_dev.php/mercedes-benz/190sl/195543
  FCGI_ROLE: RESPONDER
  GATEWAY_INTERFACE: CGI/1.1
  HOME: /var/lib/nginx
  HTTPS: on
  HTTP_ACCEPT: */*
  HTTP_ACCEPT_ENCODING: gzip, br, zstd, deflate
  HTTP_COOKIE: RWSESSID=f5955a495e75d98627407741dd7ec9da
  HTTP_HOST: www.classicdigest.com
  HTTP_REFERER: https://classicdigest.com/cars/index_dev.php/mercedes-benz/190sl/195543
  HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
  PATH_INFO: /mercedes-benz/190sl/195543
  PATH_TRANSLATED: /web/classicdigest.com/web/mercedes-benz/190sl/195543
  PHP_SELF: /cars/index_dev.php/mercedes-benz/190sl/195543
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REMOTE_ADDR: 3.133.124.23
  REMOTE_PORT: 1260
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1732341090
  REQUEST_TIME_FLOAT: 1732341090.604
  REQUEST_URI: /cars/index_dev.php/mercedes-benz/190sl/195543
  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'
[1.16 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=195543 AND car.STATUS='F'
[1.26 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 (1829)
[1.16 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=195543
[2.16 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=195543
[0.67 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=195543 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2'
[1.39 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'
[0.38 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 (195543) ORDER BY carimg.ORD ASC
[0.43 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 (1829)
[1.84 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=112 AND model.ID=1180 AND make.ID=model.ID_MAKE
[3.87 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 != 195543 AND car.ID_MODEL = '1180' ) 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 != 195543 AND car.ID_MODEL = '1180' ) ) AS count
[5.25 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 != 195543 AND car.ID_MODEL = '1180' ) 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 != 195543 AND car.ID_MODEL = '1180' ) ORDER BY ID DESC LIMIT 5
[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 (199561,198452,197549,197500,195133) ORDER BY carimg.ORD ASC
[0.97 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 != '195543' AND car.ID_NETTI_USER = '1829' ) 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 != '195543' AND car.ID_NETTI_USER = '1829' ) ) AS count
[0.89 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=112 AND car.ID_MODEL=1180 AND car.STATUS='F'
[31.55 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=112 AND sold_car.ID_MODEL=1180 AND sold_car.STATUS='S'
[2.98 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 (26541,26542,28257,31419,31420,35556,35557,43978,44021,60923,86066,86693,98680,106139,110780,117618,117803,129692,129986,130181,130196,130232,130352,130554,131012,131820,132229,133926,135245,136223,136488,141970,141976,142055,143054,148102,150540,151251,156059,157113,159052,159075,159090,159111,159723,160310,165209,171825,178643,180395,180498,181746,184018,184470,186643,190706,191296,192593,195133,195543,197500,197549,198452,199561) GROUP BY cmonth ORDER BY date_create
[4.73 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 (20660,20663,20858,21356,21421,21458,21568,21569,21639,21975,22167,22169,22227,22323,22324,22325,22369,22406,22644,23282,23419,23421,23654,23984,24182,24357,24360,24362,24759,24822,24974,25015,25066,25191,25405,25482,25776,25852,25961,25984,26181,26315,26417,26474,26684,26965,26966,26979,27095,27290,27390,27399,27436,27495,27668,27705,27706,27707,28125,28416,28685,28686,29314,29379,29579,29580,29612,29726,29727,29807,29869,30125,30228,30425,31681,31682,31822,31824,31991,32321,32398,32930,33238,33457,33580,33641,33650,33941,33974,34376,34804,34805,34855,35540,35541,35576,36171,36200,36230,36757,36781,36847,38871,38906,39509,39691,39719,41954,42378,43279,43847,44068,44096,44097,45509,45743,45764,46170,46342,46393,46434,46435,46497,46512,46874,46970,47173,47519,47544,47601,47602,47880,48574,48841,49831,49925,50238,50283,50301,50717,50858,50865,50909,51048,51090,52464,53154,53155,53157,53158,53270,53668,53669,54239,54632,56617,56618,57627,57836,58850,60024,60025,60162,60330,61051,61392,61875,62266,62438,62900,62901,62902,63856,64473,65409,65598,65902,66783,67468,67889,68458,68577,69349,69639,70411,70500,71233,71288,72024,72044,72693,73512,74286,74522,75077,76051,76150,76590,76883,76896,76952,76971,77000,78630,81945,81946,83066,83355,83425,84084,84085,84086,84495,84798,85039,85040,85127,85211,85285,85286,85397,85789,85915,86034,86168,86418,86501,86619,86818,87052,88766,88889,89442,89611,90231,91242,91535,91550,91592,91593,91631,91676,91714,91936,91972,92015,92175,92289,92290,92291,92321,92467,92468,92518,92981,93755,94321,94487,95135,95357,95492,95641,95914,97777,97823,97907,97908,98139,98283,98284,99100,99372,100118,100365,100728,100862,101058,101805,102113,102165,102283,102648,102679,102683,102722,102954,103023,103024,103141,103326,103455,103485,103614,103615,103744,103906,104359,104515,105143,105144,105201,105384,105385,105531,105617,105737,105747,105748,105749,106458,107095,107348,107491,107517,107531,108192,108240,108394,108423,108788,108949,109224,109401,109537,109649,109650,110948,111114,111818,111820,111991,112331,112336,112458,112478,113032,113033,113065,113281,113422,113461,113558,113590,113591,113623,113936,114059,114088,114213,114688,115315,115632,116253,116296,116698,116789,117581,117582,117808,117809,118070,118183,118255,118412,118445,118484,118653,118654,118655,118729,118819,118936,119351,120398,121181,121572,121804,121805,121915,121916,122067,122306,122499,122500,122588,122721,123603,124160,124301,125478,126121,126123,126252,126584,126718,126722,126739,126846,127245,127666,127785,128178,128179,128231,128232,128233,128693,129729,129753,129770,129863,129914,130314,130330,130331,130356,130365,130453,130521,130522,131685,131686,131819,131967,132700,132760,132795,133551,133634,133635,133970,133971,135276,135489,135628,135900,135901,135911,135928,135996,135997,136233,136390,136749,136776,137511,138813,138814,139606,139675,140876,141117,141291,141794,142357,142758,143029,143384,143556,143557,144072,144139,144742,144985,145369,145447,145865,146052,146053,146208,146246,146502,146822,146823,146824,146825,147312,147421,147595,147654,147920,148062,148063,148112,148344,148416,149420,149604,149784,149827,150201,150417,150554,150704,151291,151328,151339,151690,151993,152423,152552,152636,152639,152640,152764,154440,155791,156009,156111,156381,156540,156958,156959,157521,157901,157934,158122,158408,158464,158703,158958,159096,159221,159411,159479,159524,159726,159903,159935,159972,160536,160594,161382,162244,162933,163204,163678,163764,164113,164611,164949,165136,165702,165836,165883,168013,168120,168300,168497,168515,168732,168973,169086,169209,169262,169473,169593,169670,169865,169867,169953,170076,170127,170481,170543,170947,170948,170949,171039,171252,171358,171399,171758,171824,172029,172750,172786,173407,173409,173780,173785,173913,174142,174433,174562,174590,174617,174829,175153,175594,175841,175971,176051,176223,176434,176551,176810,177477,177782,177939,177956,178044,178045,178344,178930,179624,179957,180059,180300,180989,181745,182176,182845,182846,183084,183549,183550,184944,185876,186006,187022,188579,188628,189054,189605,189830,190304,190569,191485,191707,191984,192157,192262,192428,192547,192997,194591,194833,194834,195007) GROUP BY sold_week ORDER BY scs.date_actual_sold
[7.98 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 (20660,20663,20858,21356,21421,21458,21568,21569,21639,21975,22167,22169,22227,22323,22324,22325,22369,22406,22644,23282,23419,23421,23654,23984,24182,24357,24360,24362,24759,24822,24974,25015,25066,25191,25405,25482,25776,25852,25961,25984,26181,26315,26417,26474,26684,26965,26966,26979,27095,27290,27390,27399,27436,27495,27668,27705,27706,27707,28125,28416,28685,28686,29314,29379,29579,29580,29612,29726,29727,29807,29869,30125,30228,30425,31681,31682,31822,31824,31991,32321,32398,32930,33238,33457,33580,33641,33650,33941,33974,34376,34804,34805,34855,35540,35541,35576,36171,36200,36230,36757,36781,36847,38871,38906,39509,39691,39719,41954,42378,43279,43847,44068,44096,44097,45509,45743,45764,46170,46342,46393,46434,46435,46497,46512,46874,46970,47173,47519,47544,47601,47602,47880,48574,48841,49831,49925,50238,50283,50301,50717,50858,50865,50909,51048,51090,52464,53154,53155,53157,53158,53270,53668,53669,54239,54632,56617,56618,57627,57836,58850,60024,60025,60162,60330,61051,61392,61875,62266,62438,62900,62901,62902,63856,64473,65409,65598,65902,66783,67468,67889,68458,68577,69349,69639,70411,70500,71233,71288,72024,72044,72693,73512,74286,74522,75077,76051,76150,76590,76883,76896,76952,76971,77000,78630,81945,81946,83066,83355,83425,84084,84085,84086,84495,84798,85039,85040,85127,85211,85285,85286,85397,85789,85915,86034,86168,86418,86501,86619,86818,87052,88766,88889,89442,89611,90231,91242,91535,91550,91592,91593,91631,91676,91714,91936,91972,92015,92175,92289,92290,92291,92321,92467,92468,92518,92981,93755,94321,94487,95135,95357,95492,95641,95914,97777,97823,97907,97908,98139,98283,98284,99100,99372,100118,100365,100728,100862,101058,101805,102113,102165,102283,102648,102679,102683,102722,102954,103023,103024,103141,103326,103455,103485,103614,103615,103744,103906,104359,104515,105143,105144,105201,105384,105385,105531,105617,105737,105747,105748,105749,106458,107095,107348,107491,107517,107531,108192,108240,108394,108423,108788,108949,109224,109401,109537,109649,109650,110948,111114,111818,111820,111991,112331,112336,112458,112478,113032,113033,113065,113281,113422,113461,113558,113590,113591,113623,113936,114059,114088,114213,114688,115315,115632,116253,116296,116698,116789,117581,117582,117808,117809,118070,118183,118255,118412,118445,118484,118653,118654,118655,118729,118819,118936,119351,120398,121181,121572,121804,121805,121915,121916,122067,122306,122499,122500,122588,122721,123603,124160,124301,125478,126121,126123,126252,126584,126718,126722,126739,126846,127245,127666,127785,128178,128179,128231,128232,128233,128693,129729,129753,129770,129863,129914,130314,130330,130331,130356,130365,130453,130521,130522,131685,131686,131819,131967,132700,132760,132795,133551,133634,133635,133970,133971,135276,135489,135628,135900,135901,135911,135928,135996,135997,136233,136390,136749,136776,137511,138813,138814,139606,139675,140876,141117,141291,141794,142357,142758,143029,143384,143556,143557,144072,144139,144742,144985,145369,145447,145865,146052,146053,146208,146246,146502,146822,146823,146824,146825,147312,147421,147595,147654,147920,148062,148063,148112,148344,148416,149420,149604,149784,149827,150201,150417,150554,150704,151291,151328,151339,151690,151993,152423,152552,152636,152639,152640,152764,154440,155791,156009,156111,156381,156540,156958,156959,157521,157901,157934,158122,158408,158464,158703,158958,159096,159221,159411,159479,159524,159726,159903,159935,159972,160536,160594,161382,162244,162933,163204,163678,163764,164113,164611,164949,165136,165702,165836,165883,168013,168120,168300,168497,168515,168732,168973,169086,169209,169262,169473,169593,169670,169865,169867,169953,170076,170127,170481,170543,170947,170948,170949,171039,171252,171358,171399,171758,171824,172029,172750,172786,173407,173409,173780,173785,173913,174142,174433,174562,174590,174617,174829,175153,175594,175841,175971,176051,176223,176434,176551,176810,177477,177782,177939,177956,178044,178045,178344,178930,179624,179957,180059,180300,180989,181745,182176,182845,182846,183084,183549,183550,184944,185876,186006,187022,188579,188628,189054,189605,189830,190304,190569,191485,191707,191984,192157,192262,192428,192547,192997,194591,194833,194834,195007) GROUP BY sold_month ORDER BY scs.date_actual_sold
[1035.22 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
[0.57 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199561
[0.63 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198452
[0.45 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197549
[0.38 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197500
[1.29 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=195133

type	calls	time (ms)
Configuration	13	1.52
Action "home/view"	1	1156.58
Database	24	1108.21
View "Success" for "home/view"	1	27.67
Partial "home/_vif_images"	1	0.29
Partial "common_page/_social_buttons"	1	0.08
Partial "home/_vif_info"	1	0.16
Partial "home/_owner_info"	1	0.11
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.05
Partial "common_page/_fancybox_javascript"	2	0.16
Partial "common_page/_responsive_javascript"	1	0.05
Partial "common_page/_google_analytics"	1	0.04
Partial "common_page/_header_links"	1	0.65
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

Mercedes-Benz 190SL 1963

Car Facts

Seller Information

ClassicDigest Market Radar on Mercedes-Benz 190SL

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers