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' => 'mg', 'model' => 'mga', 'id' => '199738', '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.50 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=199738 AND car.STATUS='F'
34	Creole	prepareStatement(): SELECT sold_car.ID, sold_car.ID_NETTI_USER, sold_car.ID_MAKE, sold_car.ID_MODEL, sold_car.ID_VEHICLE_TYPE, sold_car.MFG_YEAR, sold_car.MILEAGE, sold_car.ENGINE_SIZE, sold_car.ENGINE_MODEL, sold_car.ID_ACC, sold_car.DEALER_IDENTIFIER, sold_car.PRICE_ASK, sold_car.CURRENCY, sold_car.PRICE_STATUS, sold_car.FIRST_REG, sold_car.STATUS, sold_car.POSTED_BY, sold_car.STAY_UNKNOWN, sold_car.DRIVE_SIDE, sold_car.DATE_CREATE, sold_car.DATE_MODIFY, sold_car.LOCATION, sold_car_info.ID, sold_car_info.ID_CAR, sold_car_info.HOOVER_ID, sold_car_info.REG_NO, sold_car_info.SHOW_REG, sold_car_info.ID_CAR_TYPE, sold_car_info.ID_COLOR, sold_car_info.ID_COLOR_TYPE, sold_car_info.AD_CONDITION, sold_car_info.DOCUMENTED_HISTORY, sold_car_info.COMPETITION_HISTORY, sold_car_info.REGISTERED_VEHICLE, sold_car_info.MANUFACTURE_COUNTRY, sold_car_info.DELIVERY_COUNTRY, sold_car_info.GENERAL_DESCRIPTION, sold_car_info.DOCUMENT_DESCRIPTION, sold_car_info.COMPETITION_DESCRIPTION, sold_car_info.TAGS, sold_car_info.YOUTUBE_VID1, sold_car_info.YOUTUBE_VID2, sold_car_info.NOTE, sold_car_info.REMARK, sold_car_info.SHOW_DATE, sold_car.ID AS ID_AD, DATE_FORMAT(sold_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 FROM sold_car LEFT JOIN sold_car_info ON (sold_car.ID=sold_car_info.ID_CAR) LEFT JOIN make ON (sold_car.ID_MAKE=make.ID) LEFT JOIN model ON (sold_car.ID_MODEL=model.ID) LEFT JOIN vehicle_type ON (sold_car.ID_VEHICLE_TYPE=vehicle_type.ID) LEFT JOIN car_type ON (sold_car_info.ID_CAR_TYPE=car_type.ID) LEFT JOIN color ON (sold_car_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (sold_car_info.ID_COLOR_TYPE=color_type.ID) WHERE sold_car.ID=?
35	Creole	executeQuery(): [2.01 ms] SELECT sold_car.ID, sold_car.ID_NETTI_USER, sold_car.ID_MAKE, sold_car.ID_MODEL, sold_car.ID_VEHICLE_TYPE, sold_car.MFG_YEAR, sold_car.MILEAGE, sold_car.ENGINE_SIZE, sold_car.ENGINE_MODEL, sold_car.ID_ACC, sold_car.DEALER_IDENTIFIER, sold_car.PRICE_ASK, sold_car.CURRENCY, sold_car.PRICE_STATUS, sold_car.FIRST_REG, sold_car.STATUS, sold_car.POSTED_BY, sold_car.STAY_UNKNOWN, sold_car.DRIVE_SIDE, sold_car.DATE_CREATE, sold_car.DATE_MODIFY, sold_car.LOCATION, sold_car_info.ID, sold_car_info.ID_CAR, sold_car_info.HOOVER_ID, sold_car_info.REG_NO, sold_car_info.SHOW_REG, sold_car_info.ID_CAR_TYPE, sold_car_info.ID_COLOR, sold_car_info.ID_COLOR_TYPE, sold_car_info.AD_CONDITION, sold_car_info.DOCUMENTED_HISTORY, sold_car_info.COMPETITION_HISTORY, sold_car_info.REGISTERED_VEHICLE, sold_car_info.MANUFACTURE_COUNTRY, sold_car_info.DELIVERY_COUNTRY, sold_car_info.GENERAL_DESCRIPTION, sold_car_info.DOCUMENT_DESCRIPTION, sold_car_info.COMPETITION_DESCRIPTION, sold_car_info.TAGS, sold_car_info.YOUTUBE_VID1, sold_car_info.YOUTUBE_VID2, sold_car_info.NOTE, sold_car_info.REMARK, sold_car_info.SHOW_DATE, sold_car.ID AS ID_AD, DATE_FORMAT(sold_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 FROM sold_car LEFT JOIN sold_car_info ON (sold_car.ID=sold_car_info.ID_CAR) LEFT JOIN make ON (sold_car.ID_MAKE=make.ID) LEFT JOIN model ON (sold_car.ID_MODEL=model.ID) LEFT JOIN vehicle_type ON (sold_car.ID_VEHICLE_TYPE=vehicle_type.ID) LEFT JOIN car_type ON (sold_car_info.ID_CAR_TYPE=car_type.ID) LEFT JOIN color ON (sold_car_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (sold_car_info.ID_COLOR_TYPE=color_type.ID) WHERE sold_car.ID=199738
36	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 (?)
37	Creole	executeQuery(): [1.81 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 (594)
38	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=?
39	Creole	executeQuery(): [1.31 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=199738
40	Creole	prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=?
41	Creole	executeQuery(): [0.87 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=199738
42	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=?
43	Creole	executeQuery(): [0.77 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=199738 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2'
44	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=?
45	Creole	executeQuery(): [0.96 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'
46	Creole	prepareStatement(): SELECT sold_carimg.ID, sold_carimg.ID_AD, sold_carimg.PATH, sold_carimg.IMG_HASH, sold_carimg.ORIGINAL, sold_carimg.ORD, sold_carimg.WIDTH, sold_carimg.HEIGHT FROM sold_carimg WHERE sold_carimg.ID_AD IN (199738) ORDER BY sold_carimg.ORD ASC
47	Creole	executeQuery(): [0.61 ms] SELECT sold_carimg.ID, sold_carimg.ID_AD, sold_carimg.PATH, sold_carimg.IMG_HASH, sold_carimg.ORIGINAL, sold_carimg.ORD, sold_carimg.WIDTH, sold_carimg.HEIGHT FROM sold_carimg WHERE sold_carimg.ID_AD IN (199738) ORDER BY sold_carimg.ORD ASC
48	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 (?)
49	Creole	executeQuery(): [0.77 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 (594)
50	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 (?)
51	Creole	executeQuery(): [0.59 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 (594)
52	Creole	prepareStatement(): SELECT dealer.ID_MAKE, dealer.HIT_COUNTER FROM dealer WHERE dealer.ID_DEALER=?
53	Creole	executeQuery(): [0.38 ms] SELECT dealer.ID_MAKE, dealer.HIT_COUNTER FROM dealer WHERE dealer.ID_DEALER=594
54	Creole	prepareStatement(): SELECT netti_dealer.HAS_SITE, netti_dealer.SIMPLE_URL, netti_dealer.SLOGAN FROM netti_dealer WHERE netti_dealer.ID_DEALER=?
55	Creole	executeQuery(): [0.33 ms] SELECT netti_dealer.HAS_SITE, netti_dealer.SIMPLE_URL, netti_dealer.SLOGAN FROM netti_dealer WHERE netti_dealer.ID_DEALER=594
56	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=?
57	Creole	executeQuery(): [0.33 ms] SELECT dealer_permission.ID, dealer_permission.ID_DEALER, dealer_permission.WHICH, dealer_permission.DATE_CREATE FROM dealer_permission WHERE dealer_permission.ID_DEALER=594
58	Creole	prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=?
59	Creole	executeQuery(): [0.97 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=594 AND dealer_permission.WHICH='Q'
60	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
61	Creole	executeQuery(): [0.82 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=115 AND model.ID=1284 AND make.ID=model.ID_MAKE
62	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 != 199738 AND car.ID_MODEL = '1284' ) 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 != 199738 AND car.ID_MODEL = '1284' ) ORDER BY ID DESC
63	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 != 199738 AND car.ID_MODEL = '1284' ) 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 != 199738 AND car.ID_MODEL = '1284' ) ) AS count
64	Creole	executeQuery(): [2.93 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 != 199738 AND car.ID_MODEL = '1284' ) 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 != 199738 AND car.ID_MODEL = '1284' ) ) AS count
65	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 != 199738 AND car.ID_MODEL = '1284' ) 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 != 199738 AND car.ID_MODEL = '1284' ) ORDER BY ID DESC, offset: 0, limit: 5
66	Creole	executeQuery(): [5.58 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 != 199738 AND car.ID_MODEL = '1284' ) 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 != 199738 AND car.ID_MODEL = '1284' ) ORDER BY ID DESC LIMIT 5
67	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 (199538,196253,196229,195873,195423) ORDER BY carimg.ORD ASC
68	Creole	executeQuery(): [0.70 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199538,196253,196229,195873,195423) ORDER BY carimg.ORD ASC
69	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 != '199738' AND car.ID_NETTI_USER = '594' ) 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 != '199738' AND car.ID_NETTI_USER = '594' ) ORDER BY ID DESC
70	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 != '199738' AND car.ID_NETTI_USER = '594' ) 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 != '199738' AND car.ID_NETTI_USER = '594' ) ) AS count
71	Creole	executeQuery(): [2.27 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 != '199738' AND car.ID_NETTI_USER = '594' ) 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 != '199738' AND car.ID_NETTI_USER = '594' ) ) AS count
72	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 != '199738' AND car.ID_NETTI_USER = '594' ) 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 != '199738' AND car.ID_NETTI_USER = '594' ) ORDER BY ID DESC, offset: 0, limit: 5
73	Creole	executeQuery(): [3.91 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 != '199738' AND car.ID_NETTI_USER = '594' ) 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 != '199738' AND car.ID_NETTI_USER = '594' ) ORDER BY ID DESC LIMIT 5
74	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 (199737,199688,199320,199215,199079) ORDER BY carimg.ORD ASC
75	Creole	executeQuery(): [1.05 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 (199737,199688,199320,199215,199079) ORDER BY carimg.ORD ASC
76	Creole	prepareStatement(): SELECT car.ID FROM car WHERE car.ID_MAKE=? AND car.ID_MODEL=? AND car.STATUS=?
77	Creole	executeQuery(): [0.44 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=115 AND car.ID_MODEL=1284 AND car.STATUS='F'
78	Creole	prepareStatement(): SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=? AND sold_car.ID_MODEL=? AND sold_car.STATUS=?
79	Creole	executeQuery(): [2.42 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=115 AND sold_car.ID_MODEL=1284 AND sold_car.STATUS='S'
80	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 (31424,31425,33946,119066,122293,123252,123285,130128,131407,131822,132900,135597,136757,141426,141769,142344,146882,148697,155829,161810,164208,168014,168768,169031,169309,169948,170030,175284,175833,176078,177267,177495,177529,178982,179464,180627,180930,181142,182552,182555,184871,185492,186840,187491,188943,188963,189538,189973,191755,191847,193360,194288,194717,195135,195423,195873,196229,196253,199538) GROUP BY cmonth ORDER BY date_create
81	Creole	executeQuery(): [1.24 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 (31424,31425,33946,119066,122293,123252,123285,130128,131407,131822,132900,135597,136757,141426,141769,142344,146882,148697,155829,161810,164208,168014,168768,169031,169309,169948,170030,175284,175833,176078,177267,177495,177529,178982,179464,180627,180930,181142,182552,182555,184871,185492,186840,187491,188943,188963,189538,189973,191755,191847,193360,194288,194717,195135,195423,195873,196229,196253,199538) GROUP BY cmonth ORDER BY date_create
82	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 (20347,20373,20778,20958,21031,21069,21114,21173,21174,21245,21246,21370,21424,21430,21642,21643,21826,22124,22175,22413,22650,23288,23515,23538,23840,23987,23988,24070,24072,24905,24937,24948,24950,24996,25008,25039,25107,25108,25238,25484,25801,26103,26137,26196,26206,26300,26359,26421,26457,26689,26690,26861,27289,27575,27670,28777,28986,28987,29144,29253,29254,29454,29455,29546,29911,30547,31554,31712,33200,33331,33332,33897,33976,34400,35016,35239,35240,35257,36922,42017,42547,45564,45583,48444,50922,50933,50958,51901,52417,52523,52537,53069,53271,53284,53524,53722,54051,54334,54775,55361,55929,57569,57626,58515,59563,59914,60333,60334,61554,62070,62269,62270,62907,62908,64622,67633,68574,68582,69353,69354,69502,70169,70192,70465,71028,71161,71276,71793,71857,71950,71951,72791,73639,73664,74230,74292,75180,76074,76079,78557,78558,78559,78670,78779,81218,81219,81220,81950,82485,83045,83227,83624,84337,84500,84958,85067,85068,85128,85551,85790,86372,86628,86927,86993,87059,87412,92896,93757,95567,95781,99025,99107,99304,101264,101265,101266,101267,101268,101269,101270,101271,101272,101273,101274,101275,103029,103814,103896,104528,105229,105780,106055,106106,106329,106511,106818,106908,107059,108322,108737,109095,109353,109377,109443,109651,110582,110937,111054,112842,112851,112890,112991,113068,113155,113156,113283,113464,113527,113564,113878,113945,114158,114632,114633,114783,114912,115087,115644,115645,115739,116258,116311,116544,116725,116726,116792,117201,117587,117672,118077,118080,118179,118393,118451,118538,118543,118663,119753,121185,121825,122170,122229,122230,122641,122986,123064,123273,123846,123921,123953,124166,124167,124270,124399,125785,125816,125817,125961,126223,126785,126853,126898,126901,127623,127950,127995,128732,128784,128843,129095,129375,130127,130546,130583,130941,131106,131107,131582,131920,133290,133293,133539,133975,134019,135015,135227,135424,135591,135631,136005,136185,136186,136187,136496,136505,136506,136563,136714,137513,138545,138712,139392,139393,139677,139746,140955,140979,141192,141559,141944,142243,142691,143032,143033,143034,143576,143992,144140,144172,144840,146167,146206,146252,146732,146736,146848,148647,148987,149274,149379,149423,149471,149663,149787,149823,149937,149942,150200,150317,150577,150893,150986,151331,151389,151429,151559,152564,152565,152800,153371,153373,153524,154699,154700,155022,155131,155439,155989,155991,156213,156316,156317,156318,156319,156706,156711,157173,157534,157576,157693,157903,157990,158115,158501,158626,158859,158962,159054,159097,159238,159380,159483,159620,159721,159748,160128,162546,162645,162691,163212,163323,163339,163781,163800,163969,163986,164395,164423,164490,164539,164607,164786,164948,165138,165499,165509,165510,165514,165568,165775,165791,165826,165903,166096,166115,166196,166406,166423,166427,166429,166436,167253,167631,167634,167660,167914,167926,168101,168145,168273,168306,168318,168398,168452,168587,168689,168854,168864,169078,169255,169261,169265,169469,169475,169549,169686,169832,169875,169878,170080,170549,170933,171199,171318,171349,171577,172128,172518,173023,173326,173541,173716,173953,173968,174195,174463,174660,174820,175203,175567,175817,176557,176619,177111,177518,177630,177631,177752,177794,177980,178419,178690,179161,179164,179178,179513,179656,179848,179858,180073,180149,180216,180220,180241,180446,180992,181566,182797,183028,183029,183035,183321,183343,183379,183949,183950,184102,184264,184266,184313,184791,184792,185008,186564,186719,186755,187112,187425,187482,187656,187883,187971,187972,188276,188398,188886,189114,189741,189846,189950,190710,191525,191528,191751,191848,192610,192896,193248,193441,196931,197100,197147,198539,199738) GROUP BY sold_week ORDER BY scs.date_actual_sold
83	Creole	executeQuery(): [4.98 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 (20347,20373,20778,20958,21031,21069,21114,21173,21174,21245,21246,21370,21424,21430,21642,21643,21826,22124,22175,22413,22650,23288,23515,23538,23840,23987,23988,24070,24072,24905,24937,24948,24950,24996,25008,25039,25107,25108,25238,25484,25801,26103,26137,26196,26206,26300,26359,26421,26457,26689,26690,26861,27289,27575,27670,28777,28986,28987,29144,29253,29254,29454,29455,29546,29911,30547,31554,31712,33200,33331,33332,33897,33976,34400,35016,35239,35240,35257,36922,42017,42547,45564,45583,48444,50922,50933,50958,51901,52417,52523,52537,53069,53271,53284,53524,53722,54051,54334,54775,55361,55929,57569,57626,58515,59563,59914,60333,60334,61554,62070,62269,62270,62907,62908,64622,67633,68574,68582,69353,69354,69502,70169,70192,70465,71028,71161,71276,71793,71857,71950,71951,72791,73639,73664,74230,74292,75180,76074,76079,78557,78558,78559,78670,78779,81218,81219,81220,81950,82485,83045,83227,83624,84337,84500,84958,85067,85068,85128,85551,85790,86372,86628,86927,86993,87059,87412,92896,93757,95567,95781,99025,99107,99304,101264,101265,101266,101267,101268,101269,101270,101271,101272,101273,101274,101275,103029,103814,103896,104528,105229,105780,106055,106106,106329,106511,106818,106908,107059,108322,108737,109095,109353,109377,109443,109651,110582,110937,111054,112842,112851,112890,112991,113068,113155,113156,113283,113464,113527,113564,113878,113945,114158,114632,114633,114783,114912,115087,115644,115645,115739,116258,116311,116544,116725,116726,116792,117201,117587,117672,118077,118080,118179,118393,118451,118538,118543,118663,119753,121185,121825,122170,122229,122230,122641,122986,123064,123273,123846,123921,123953,124166,124167,124270,124399,125785,125816,125817,125961,126223,126785,126853,126898,126901,127623,127950,127995,128732,128784,128843,129095,129375,130127,130546,130583,130941,131106,131107,131582,131920,133290,133293,133539,133975,134019,135015,135227,135424,135591,135631,136005,136185,136186,136187,136496,136505,136506,136563,136714,137513,138545,138712,139392,139393,139677,139746,140955,140979,141192,141559,141944,142243,142691,143032,143033,143034,143576,143992,144140,144172,144840,146167,146206,146252,146732,146736,146848,148647,148987,149274,149379,149423,149471,149663,149787,149823,149937,149942,150200,150317,150577,150893,150986,151331,151389,151429,151559,152564,152565,152800,153371,153373,153524,154699,154700,155022,155131,155439,155989,155991,156213,156316,156317,156318,156319,156706,156711,157173,157534,157576,157693,157903,157990,158115,158501,158626,158859,158962,159054,159097,159238,159380,159483,159620,159721,159748,160128,162546,162645,162691,163212,163323,163339,163781,163800,163969,163986,164395,164423,164490,164539,164607,164786,164948,165138,165499,165509,165510,165514,165568,165775,165791,165826,165903,166096,166115,166196,166406,166423,166427,166429,166436,167253,167631,167634,167660,167914,167926,168101,168145,168273,168306,168318,168398,168452,168587,168689,168854,168864,169078,169255,169261,169265,169469,169475,169549,169686,169832,169875,169878,170080,170549,170933,171199,171318,171349,171577,172128,172518,173023,173326,173541,173716,173953,173968,174195,174463,174660,174820,175203,175567,175817,176557,176619,177111,177518,177630,177631,177752,177794,177980,178419,178690,179161,179164,179178,179513,179656,179848,179858,180073,180149,180216,180220,180241,180446,180992,181566,182797,183028,183029,183035,183321,183343,183379,183949,183950,184102,184264,184266,184313,184791,184792,185008,186564,186719,186755,187112,187425,187482,187656,187883,187971,187972,188276,188398,188886,189114,189741,189846,189950,190710,191525,191528,191751,191848,192610,192896,193248,193441,196931,197100,197147,198539,199738) GROUP BY sold_week ORDER BY scs.date_actual_sold
84	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 (20347,20373,20778,20958,21031,21069,21114,21173,21174,21245,21246,21370,21424,21430,21642,21643,21826,22124,22175,22413,22650,23288,23515,23538,23840,23987,23988,24070,24072,24905,24937,24948,24950,24996,25008,25039,25107,25108,25238,25484,25801,26103,26137,26196,26206,26300,26359,26421,26457,26689,26690,26861,27289,27575,27670,28777,28986,28987,29144,29253,29254,29454,29455,29546,29911,30547,31554,31712,33200,33331,33332,33897,33976,34400,35016,35239,35240,35257,36922,42017,42547,45564,45583,48444,50922,50933,50958,51901,52417,52523,52537,53069,53271,53284,53524,53722,54051,54334,54775,55361,55929,57569,57626,58515,59563,59914,60333,60334,61554,62070,62269,62270,62907,62908,64622,67633,68574,68582,69353,69354,69502,70169,70192,70465,71028,71161,71276,71793,71857,71950,71951,72791,73639,73664,74230,74292,75180,76074,76079,78557,78558,78559,78670,78779,81218,81219,81220,81950,82485,83045,83227,83624,84337,84500,84958,85067,85068,85128,85551,85790,86372,86628,86927,86993,87059,87412,92896,93757,95567,95781,99025,99107,99304,101264,101265,101266,101267,101268,101269,101270,101271,101272,101273,101274,101275,103029,103814,103896,104528,105229,105780,106055,106106,106329,106511,106818,106908,107059,108322,108737,109095,109353,109377,109443,109651,110582,110937,111054,112842,112851,112890,112991,113068,113155,113156,113283,113464,113527,113564,113878,113945,114158,114632,114633,114783,114912,115087,115644,115645,115739,116258,116311,116544,116725,116726,116792,117201,117587,117672,118077,118080,118179,118393,118451,118538,118543,118663,119753,121185,121825,122170,122229,122230,122641,122986,123064,123273,123846,123921,123953,124166,124167,124270,124399,125785,125816,125817,125961,126223,126785,126853,126898,126901,127623,127950,127995,128732,128784,128843,129095,129375,130127,130546,130583,130941,131106,131107,131582,131920,133290,133293,133539,133975,134019,135015,135227,135424,135591,135631,136005,136185,136186,136187,136496,136505,136506,136563,136714,137513,138545,138712,139392,139393,139677,139746,140955,140979,141192,141559,141944,142243,142691,143032,143033,143034,143576,143992,144140,144172,144840,146167,146206,146252,146732,146736,146848,148647,148987,149274,149379,149423,149471,149663,149787,149823,149937,149942,150200,150317,150577,150893,150986,151331,151389,151429,151559,152564,152565,152800,153371,153373,153524,154699,154700,155022,155131,155439,155989,155991,156213,156316,156317,156318,156319,156706,156711,157173,157534,157576,157693,157903,157990,158115,158501,158626,158859,158962,159054,159097,159238,159380,159483,159620,159721,159748,160128,162546,162645,162691,163212,163323,163339,163781,163800,163969,163986,164395,164423,164490,164539,164607,164786,164948,165138,165499,165509,165510,165514,165568,165775,165791,165826,165903,166096,166115,166196,166406,166423,166427,166429,166436,167253,167631,167634,167660,167914,167926,168101,168145,168273,168306,168318,168398,168452,168587,168689,168854,168864,169078,169255,169261,169265,169469,169475,169549,169686,169832,169875,169878,170080,170549,170933,171199,171318,171349,171577,172128,172518,173023,173326,173541,173716,173953,173968,174195,174463,174660,174820,175203,175567,175817,176557,176619,177111,177518,177630,177631,177752,177794,177980,178419,178690,179161,179164,179178,179513,179656,179848,179858,180073,180149,180216,180220,180241,180446,180992,181566,182797,183028,183029,183035,183321,183343,183379,183949,183950,184102,184264,184266,184313,184791,184792,185008,186564,186719,186755,187112,187425,187482,187656,187883,187971,187972,188276,188398,188886,189114,189741,189846,189950,190710,191525,191528,191751,191848,192610,192896,193248,193441,196931,197100,197147,198539,199738) GROUP BY sold_month ORDER BY scs.date_actual_sold
85	Creole	executeQuery(): [5.40 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 (20347,20373,20778,20958,21031,21069,21114,21173,21174,21245,21246,21370,21424,21430,21642,21643,21826,22124,22175,22413,22650,23288,23515,23538,23840,23987,23988,24070,24072,24905,24937,24948,24950,24996,25008,25039,25107,25108,25238,25484,25801,26103,26137,26196,26206,26300,26359,26421,26457,26689,26690,26861,27289,27575,27670,28777,28986,28987,29144,29253,29254,29454,29455,29546,29911,30547,31554,31712,33200,33331,33332,33897,33976,34400,35016,35239,35240,35257,36922,42017,42547,45564,45583,48444,50922,50933,50958,51901,52417,52523,52537,53069,53271,53284,53524,53722,54051,54334,54775,55361,55929,57569,57626,58515,59563,59914,60333,60334,61554,62070,62269,62270,62907,62908,64622,67633,68574,68582,69353,69354,69502,70169,70192,70465,71028,71161,71276,71793,71857,71950,71951,72791,73639,73664,74230,74292,75180,76074,76079,78557,78558,78559,78670,78779,81218,81219,81220,81950,82485,83045,83227,83624,84337,84500,84958,85067,85068,85128,85551,85790,86372,86628,86927,86993,87059,87412,92896,93757,95567,95781,99025,99107,99304,101264,101265,101266,101267,101268,101269,101270,101271,101272,101273,101274,101275,103029,103814,103896,104528,105229,105780,106055,106106,106329,106511,106818,106908,107059,108322,108737,109095,109353,109377,109443,109651,110582,110937,111054,112842,112851,112890,112991,113068,113155,113156,113283,113464,113527,113564,113878,113945,114158,114632,114633,114783,114912,115087,115644,115645,115739,116258,116311,116544,116725,116726,116792,117201,117587,117672,118077,118080,118179,118393,118451,118538,118543,118663,119753,121185,121825,122170,122229,122230,122641,122986,123064,123273,123846,123921,123953,124166,124167,124270,124399,125785,125816,125817,125961,126223,126785,126853,126898,126901,127623,127950,127995,128732,128784,128843,129095,129375,130127,130546,130583,130941,131106,131107,131582,131920,133290,133293,133539,133975,134019,135015,135227,135424,135591,135631,136005,136185,136186,136187,136496,136505,136506,136563,136714,137513,138545,138712,139392,139393,139677,139746,140955,140979,141192,141559,141944,142243,142691,143032,143033,143034,143576,143992,144140,144172,144840,146167,146206,146252,146732,146736,146848,148647,148987,149274,149379,149423,149471,149663,149787,149823,149937,149942,150200,150317,150577,150893,150986,151331,151389,151429,151559,152564,152565,152800,153371,153373,153524,154699,154700,155022,155131,155439,155989,155991,156213,156316,156317,156318,156319,156706,156711,157173,157534,157576,157693,157903,157990,158115,158501,158626,158859,158962,159054,159097,159238,159380,159483,159620,159721,159748,160128,162546,162645,162691,163212,163323,163339,163781,163800,163969,163986,164395,164423,164490,164539,164607,164786,164948,165138,165499,165509,165510,165514,165568,165775,165791,165826,165903,166096,166115,166196,166406,166423,166427,166429,166436,167253,167631,167634,167660,167914,167926,168101,168145,168273,168306,168318,168398,168452,168587,168689,168854,168864,169078,169255,169261,169265,169469,169475,169549,169686,169832,169875,169878,170080,170549,170933,171199,171318,171349,171577,172128,172518,173023,173326,173541,173716,173953,173968,174195,174463,174660,174820,175203,175567,175817,176557,176619,177111,177518,177630,177631,177752,177794,177980,178419,178690,179161,179164,179178,179513,179656,179848,179858,180073,180149,180216,180220,180241,180446,180992,181566,182797,183028,183029,183035,183321,183343,183379,183949,183950,184102,184264,184266,184313,184791,184792,185008,186564,186719,186755,187112,187425,187482,187656,187883,187971,187972,188276,188398,188886,189114,189741,189846,189950,190710,191525,191528,191751,191848,192610,192896,193248,193441,196931,197100,197147,198539,199738) GROUP BY sold_month ORDER BY scs.date_actual_sold
86	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
87	Creole	executeQuery(): [1037.83 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
88	Action	change layout to "view_layout"
89	View	initialize view for "home/view"
90	View	render "sf_app_dir/modules/home/templates/viewSuccess.php"
91	View	initialize view for "home/_vif_images"
92	View	render "sf_app_dir/modules/home/templates/_vif_images.php"
93	PartialHelper	Generate cache key
94	View	initialize view for "common_page/_social_buttons"
95	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php"
96	PartialHelper	Generate cache key
97	View	initialize view for "home/_vif_info"
98	View	render "sf_app_dir/modules/home/templates/_vif_info.php"
99	PartialHelper	Generate cache key
100	View	initialize view for "common_page/_price_development_graph"
101	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php"
102	PartialHelper	Generate cache key
103	View	initialize view for "common_page/_sell_time_price_graph"
104	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php"
105	PartialHelper	Generate cache key
106	View	initialize view for "common_page/_price_gauge_graph"
107	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php"
108	PartialHelper	Generate cache key
109	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
110	Creole	executeQuery(): [3.44 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199538
111	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
112	Creole	executeQuery(): [0.95 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=196253
113	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
114	Creole	executeQuery(): [0.41 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=196229
115	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
116	Creole	executeQuery(): [1.03 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=195873
117	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
118	Creole	executeQuery(): [0.42 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=195423
119	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
120	Creole	executeQuery(): [1.18 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199737
121	Creole	prepareStatement(): SELECT sold_car.ID_MAKE, sold_car.ID_MODEL FROM sold_car WHERE sold_car.ID=?
122	Creole	executeQuery(): [0.39 ms] SELECT sold_car.ID_MAKE, sold_car.ID_MODEL FROM sold_car WHERE sold_car.ID=199688
123	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
124	Creole	executeQuery(): [0.60 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199320
125	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
126	Creole	executeQuery(): [1.37 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199215
127	Creole	prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=?
128	Creole	executeQuery(): [0.44 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199079
129	View	initialize view for "common_page/_include_vif_js"
130	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_include_vif_js.php"
131	PartialHelper	Generate cache key
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	decorate content with "sf_app_dir/templates/view_layout.php"
136	View	render "sf_app_dir/templates/view_layout.php"
137	View	initialize view for "common_page/_responsive_javascript"
138	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_javascript.php"
139	PartialHelper	Generate cache key
140	View	initialize view for "common_page/_google_analytics"
141	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_google_analytics.php"
142	PartialHelper	Generate cache key
143	View	initialize view for "common_page/_header_links"
144	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_header_links.php"
145	View	initialize view for "common_page/_fancybox_javascript"
146	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
147	PartialHelper	Generate cache key
148	View	initialize view for "common_page/_cookie_policy"
149	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_cookie_policy.php"
150	PartialHelper	Generate cache key
151	PartialHelper	Generate cache key
152	View	initialize view for "common_page/_responsive_top_menu"
153	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_top_menu.php"
154	PartialHelper	Generate cache key
155	View	initialize view for "common_page/_top_menu"
156	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_top_menu.php"
157	PartialHelper	Generate cache key
158	View	initialize view for "common_page/_footer_javascript"
159	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer_javascript.php"
160	PartialHelper	Generate cache key
161	View	initialize view for "common_page/_footer"
162	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer.php"
163	PartialHelper	Generate cache key

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    ID_AD: 199738
    action: view
    id: 199738
    make: mg
    model: mga
    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: 1732339369.5709
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/mg/mga/199738
  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/mg/mga/199738
  HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
  PATH_INFO: /mg/mga/199738
  PATH_TRANSLATED: /web/classicdigest.com/web/mg/mga/199738
  PHP_SELF: /cars/index_dev.php/mg/mga/199738
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REMOTE_ADDR: 3.144.20.66
  REMOTE_PORT: 41421
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1732339369
  REQUEST_TIME_FLOAT: 1732339369.5697
  REQUEST_URI: /cars/index_dev.php/mg/mga/199738
  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.50 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=199738 AND car.STATUS='F'
[2.01 ms] SELECT sold_car.ID, sold_car.ID_NETTI_USER, sold_car.ID_MAKE, sold_car.ID_MODEL, sold_car.ID_VEHICLE_TYPE, sold_car.MFG_YEAR, sold_car.MILEAGE, sold_car.ENGINE_SIZE, sold_car.ENGINE_MODEL, sold_car.ID_ACC, sold_car.DEALER_IDENTIFIER, sold_car.PRICE_ASK, sold_car.CURRENCY, sold_car.PRICE_STATUS, sold_car.FIRST_REG, sold_car.STATUS, sold_car.POSTED_BY, sold_car.STAY_UNKNOWN, sold_car.DRIVE_SIDE, sold_car.DATE_CREATE, sold_car.DATE_MODIFY, sold_car.LOCATION, sold_car_info.ID, sold_car_info.ID_CAR, sold_car_info.HOOVER_ID, sold_car_info.REG_NO, sold_car_info.SHOW_REG, sold_car_info.ID_CAR_TYPE, sold_car_info.ID_COLOR, sold_car_info.ID_COLOR_TYPE, sold_car_info.AD_CONDITION, sold_car_info.DOCUMENTED_HISTORY, sold_car_info.COMPETITION_HISTORY, sold_car_info.REGISTERED_VEHICLE, sold_car_info.MANUFACTURE_COUNTRY, sold_car_info.DELIVERY_COUNTRY, sold_car_info.GENERAL_DESCRIPTION, sold_car_info.DOCUMENT_DESCRIPTION, sold_car_info.COMPETITION_DESCRIPTION, sold_car_info.TAGS, sold_car_info.YOUTUBE_VID1, sold_car_info.YOUTUBE_VID2, sold_car_info.NOTE, sold_car_info.REMARK, sold_car_info.SHOW_DATE, sold_car.ID AS ID_AD, DATE_FORMAT(sold_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 FROM sold_car LEFT JOIN sold_car_info ON (sold_car.ID=sold_car_info.ID_CAR) LEFT JOIN make ON (sold_car.ID_MAKE=make.ID) LEFT JOIN model ON (sold_car.ID_MODEL=model.ID) LEFT JOIN vehicle_type ON (sold_car.ID_VEHICLE_TYPE=vehicle_type.ID) LEFT JOIN car_type ON (sold_car_info.ID_CAR_TYPE=car_type.ID) LEFT JOIN color ON (sold_car_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (sold_car_info.ID_COLOR_TYPE=color_type.ID) WHERE sold_car.ID=199738
[1.81 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 (594)
[1.31 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=199738
[0.87 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=199738
[0.77 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=199738 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2'
[0.96 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.61 ms] SELECT sold_carimg.ID, sold_carimg.ID_AD, sold_carimg.PATH, sold_carimg.IMG_HASH, sold_carimg.ORIGINAL, sold_carimg.ORD, sold_carimg.WIDTH, sold_carimg.HEIGHT FROM sold_carimg WHERE sold_carimg.ID_AD IN (199738) ORDER BY sold_carimg.ORD ASC
[0.77 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 (594)
[0.59 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 (594)
[0.38 ms] SELECT dealer.ID_MAKE, dealer.HIT_COUNTER FROM dealer WHERE dealer.ID_DEALER=594
[0.33 ms] SELECT netti_dealer.HAS_SITE, netti_dealer.SIMPLE_URL, netti_dealer.SLOGAN FROM netti_dealer WHERE netti_dealer.ID_DEALER=594
[0.33 ms] SELECT dealer_permission.ID, dealer_permission.ID_DEALER, dealer_permission.WHICH, dealer_permission.DATE_CREATE FROM dealer_permission WHERE dealer_permission.ID_DEALER=594
[0.97 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=594 AND dealer_permission.WHICH='Q'
[0.82 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=115 AND model.ID=1284 AND make.ID=model.ID_MAKE
[2.93 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 != 199738 AND car.ID_MODEL = '1284' ) 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 != 199738 AND car.ID_MODEL = '1284' ) ) AS count
[5.58 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 != 199738 AND car.ID_MODEL = '1284' ) 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 != 199738 AND car.ID_MODEL = '1284' ) ORDER BY ID DESC LIMIT 5
[0.70 ms] SELECT carimg.ID, carimg.ID_AD, carimg.PATH, carimg.IMG_HASH, carimg.ORIGINAL, carimg.ORD, carimg.WIDTH, carimg.HEIGHT FROM carimg WHERE carimg.ID_AD IN (199538,196253,196229,195873,195423) ORDER BY carimg.ORD ASC
[2.27 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 != '199738' AND car.ID_NETTI_USER = '594' ) 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 != '199738' AND car.ID_NETTI_USER = '594' ) ) AS count
[3.91 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 != '199738' AND car.ID_NETTI_USER = '594' ) 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 != '199738' AND car.ID_NETTI_USER = '594' ) ORDER BY ID DESC LIMIT 5
[1.05 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 (199737,199688,199320,199215,199079) ORDER BY carimg.ORD ASC
[0.44 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=115 AND car.ID_MODEL=1284 AND car.STATUS='F'
[2.42 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=115 AND sold_car.ID_MODEL=1284 AND sold_car.STATUS='S'
[1.24 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 (31424,31425,33946,119066,122293,123252,123285,130128,131407,131822,132900,135597,136757,141426,141769,142344,146882,148697,155829,161810,164208,168014,168768,169031,169309,169948,170030,175284,175833,176078,177267,177495,177529,178982,179464,180627,180930,181142,182552,182555,184871,185492,186840,187491,188943,188963,189538,189973,191755,191847,193360,194288,194717,195135,195423,195873,196229,196253,199538) GROUP BY cmonth ORDER BY date_create
[4.98 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 (20347,20373,20778,20958,21031,21069,21114,21173,21174,21245,21246,21370,21424,21430,21642,21643,21826,22124,22175,22413,22650,23288,23515,23538,23840,23987,23988,24070,24072,24905,24937,24948,24950,24996,25008,25039,25107,25108,25238,25484,25801,26103,26137,26196,26206,26300,26359,26421,26457,26689,26690,26861,27289,27575,27670,28777,28986,28987,29144,29253,29254,29454,29455,29546,29911,30547,31554,31712,33200,33331,33332,33897,33976,34400,35016,35239,35240,35257,36922,42017,42547,45564,45583,48444,50922,50933,50958,51901,52417,52523,52537,53069,53271,53284,53524,53722,54051,54334,54775,55361,55929,57569,57626,58515,59563,59914,60333,60334,61554,62070,62269,62270,62907,62908,64622,67633,68574,68582,69353,69354,69502,70169,70192,70465,71028,71161,71276,71793,71857,71950,71951,72791,73639,73664,74230,74292,75180,76074,76079,78557,78558,78559,78670,78779,81218,81219,81220,81950,82485,83045,83227,83624,84337,84500,84958,85067,85068,85128,85551,85790,86372,86628,86927,86993,87059,87412,92896,93757,95567,95781,99025,99107,99304,101264,101265,101266,101267,101268,101269,101270,101271,101272,101273,101274,101275,103029,103814,103896,104528,105229,105780,106055,106106,106329,106511,106818,106908,107059,108322,108737,109095,109353,109377,109443,109651,110582,110937,111054,112842,112851,112890,112991,113068,113155,113156,113283,113464,113527,113564,113878,113945,114158,114632,114633,114783,114912,115087,115644,115645,115739,116258,116311,116544,116725,116726,116792,117201,117587,117672,118077,118080,118179,118393,118451,118538,118543,118663,119753,121185,121825,122170,122229,122230,122641,122986,123064,123273,123846,123921,123953,124166,124167,124270,124399,125785,125816,125817,125961,126223,126785,126853,126898,126901,127623,127950,127995,128732,128784,128843,129095,129375,130127,130546,130583,130941,131106,131107,131582,131920,133290,133293,133539,133975,134019,135015,135227,135424,135591,135631,136005,136185,136186,136187,136496,136505,136506,136563,136714,137513,138545,138712,139392,139393,139677,139746,140955,140979,141192,141559,141944,142243,142691,143032,143033,143034,143576,143992,144140,144172,144840,146167,146206,146252,146732,146736,146848,148647,148987,149274,149379,149423,149471,149663,149787,149823,149937,149942,150200,150317,150577,150893,150986,151331,151389,151429,151559,152564,152565,152800,153371,153373,153524,154699,154700,155022,155131,155439,155989,155991,156213,156316,156317,156318,156319,156706,156711,157173,157534,157576,157693,157903,157990,158115,158501,158626,158859,158962,159054,159097,159238,159380,159483,159620,159721,159748,160128,162546,162645,162691,163212,163323,163339,163781,163800,163969,163986,164395,164423,164490,164539,164607,164786,164948,165138,165499,165509,165510,165514,165568,165775,165791,165826,165903,166096,166115,166196,166406,166423,166427,166429,166436,167253,167631,167634,167660,167914,167926,168101,168145,168273,168306,168318,168398,168452,168587,168689,168854,168864,169078,169255,169261,169265,169469,169475,169549,169686,169832,169875,169878,170080,170549,170933,171199,171318,171349,171577,172128,172518,173023,173326,173541,173716,173953,173968,174195,174463,174660,174820,175203,175567,175817,176557,176619,177111,177518,177630,177631,177752,177794,177980,178419,178690,179161,179164,179178,179513,179656,179848,179858,180073,180149,180216,180220,180241,180446,180992,181566,182797,183028,183029,183035,183321,183343,183379,183949,183950,184102,184264,184266,184313,184791,184792,185008,186564,186719,186755,187112,187425,187482,187656,187883,187971,187972,188276,188398,188886,189114,189741,189846,189950,190710,191525,191528,191751,191848,192610,192896,193248,193441,196931,197100,197147,198539,199738) GROUP BY sold_week ORDER BY scs.date_actual_sold
[5.40 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 (20347,20373,20778,20958,21031,21069,21114,21173,21174,21245,21246,21370,21424,21430,21642,21643,21826,22124,22175,22413,22650,23288,23515,23538,23840,23987,23988,24070,24072,24905,24937,24948,24950,24996,25008,25039,25107,25108,25238,25484,25801,26103,26137,26196,26206,26300,26359,26421,26457,26689,26690,26861,27289,27575,27670,28777,28986,28987,29144,29253,29254,29454,29455,29546,29911,30547,31554,31712,33200,33331,33332,33897,33976,34400,35016,35239,35240,35257,36922,42017,42547,45564,45583,48444,50922,50933,50958,51901,52417,52523,52537,53069,53271,53284,53524,53722,54051,54334,54775,55361,55929,57569,57626,58515,59563,59914,60333,60334,61554,62070,62269,62270,62907,62908,64622,67633,68574,68582,69353,69354,69502,70169,70192,70465,71028,71161,71276,71793,71857,71950,71951,72791,73639,73664,74230,74292,75180,76074,76079,78557,78558,78559,78670,78779,81218,81219,81220,81950,82485,83045,83227,83624,84337,84500,84958,85067,85068,85128,85551,85790,86372,86628,86927,86993,87059,87412,92896,93757,95567,95781,99025,99107,99304,101264,101265,101266,101267,101268,101269,101270,101271,101272,101273,101274,101275,103029,103814,103896,104528,105229,105780,106055,106106,106329,106511,106818,106908,107059,108322,108737,109095,109353,109377,109443,109651,110582,110937,111054,112842,112851,112890,112991,113068,113155,113156,113283,113464,113527,113564,113878,113945,114158,114632,114633,114783,114912,115087,115644,115645,115739,116258,116311,116544,116725,116726,116792,117201,117587,117672,118077,118080,118179,118393,118451,118538,118543,118663,119753,121185,121825,122170,122229,122230,122641,122986,123064,123273,123846,123921,123953,124166,124167,124270,124399,125785,125816,125817,125961,126223,126785,126853,126898,126901,127623,127950,127995,128732,128784,128843,129095,129375,130127,130546,130583,130941,131106,131107,131582,131920,133290,133293,133539,133975,134019,135015,135227,135424,135591,135631,136005,136185,136186,136187,136496,136505,136506,136563,136714,137513,138545,138712,139392,139393,139677,139746,140955,140979,141192,141559,141944,142243,142691,143032,143033,143034,143576,143992,144140,144172,144840,146167,146206,146252,146732,146736,146848,148647,148987,149274,149379,149423,149471,149663,149787,149823,149937,149942,150200,150317,150577,150893,150986,151331,151389,151429,151559,152564,152565,152800,153371,153373,153524,154699,154700,155022,155131,155439,155989,155991,156213,156316,156317,156318,156319,156706,156711,157173,157534,157576,157693,157903,157990,158115,158501,158626,158859,158962,159054,159097,159238,159380,159483,159620,159721,159748,160128,162546,162645,162691,163212,163323,163339,163781,163800,163969,163986,164395,164423,164490,164539,164607,164786,164948,165138,165499,165509,165510,165514,165568,165775,165791,165826,165903,166096,166115,166196,166406,166423,166427,166429,166436,167253,167631,167634,167660,167914,167926,168101,168145,168273,168306,168318,168398,168452,168587,168689,168854,168864,169078,169255,169261,169265,169469,169475,169549,169686,169832,169875,169878,170080,170549,170933,171199,171318,171349,171577,172128,172518,173023,173326,173541,173716,173953,173968,174195,174463,174660,174820,175203,175567,175817,176557,176619,177111,177518,177630,177631,177752,177794,177980,178419,178690,179161,179164,179178,179513,179656,179848,179858,180073,180149,180216,180220,180241,180446,180992,181566,182797,183028,183029,183035,183321,183343,183379,183949,183950,184102,184264,184266,184313,184791,184792,185008,186564,186719,186755,187112,187425,187482,187656,187883,187971,187972,188276,188398,188886,189114,189741,189846,189950,190710,191525,191528,191751,191848,192610,192896,193248,193441,196931,197100,197147,198539,199738) GROUP BY sold_month ORDER BY scs.date_actual_sold
[1037.83 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
[3.44 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199538
[0.95 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=196253
[0.41 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=196229
[1.03 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=195873
[0.42 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=195423
[1.18 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199737
[0.39 ms] SELECT sold_car.ID_MAKE, sold_car.ID_MODEL FROM sold_car WHERE sold_car.ID=199688
[0.60 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199320
[1.37 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199215
[0.44 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199079

type	calls	time (ms)
Configuration	13	1.49
Action "home/view"	1	1141.23
Database	37	1093.01
View "Success" for "home/view"	1	51.57
Partial "home/_vif_images"	1	0.49
Partial "common_page/_social_buttons"	1	0.07
Partial "home/_vif_info"	1	0.14
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.64
Partial "common_page/_cookie_policy"	1	0.07
Partial "common_page/_responsive_top_menu"	1	0.10
Partial "common_page/_top_menu"	1	0.12
Partial "common_page/_footer_javascript"	1	0.10
Partial "common_page/_footer"	1	0.10

MG MGA 1958

Car Facts

Seller Information

ClassicDigest Market Radar on MG MGA

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers