Log and debug messages

#	type	message
1	Routing	connect "/captcha"
2	Context	initialization
3	Controller	initialization
4	Routing	match route [nm_vif] "/:bike_type/:make/:id"
5	Request	request parameters array ( 'bike_type' => 'road-bike', 'make' => 'other-sprint-sport', 'id' => '143704', '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 "sfBikeViewFilter"
26	Filter	executing filter "nmBreadcrumbFilter"
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 bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike_info.ID, bike_info.ID_BIKE, bike_info.HOOVER_ID, bike_info.REG_NO, bike_info.SHOW_REG, bike_info.ID_COLOR, bike_info.ID_COLOR_TYPE, bike_info.AD_CONDITION, bike_info.DOCUMENTED_HISTORY, bike_info.COMPETITION_HISTORY, bike_info.REGISTERED_VEHICLE, bike_info.MANUFACTURE_COUNTRY, bike_info.DELIVERY_COUNTRY, bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike_info.TAGS, bike_info.YOUTUBE_VID1, bike_info.YOUTUBE_VID2, bike_info.NOTE, bike_info.REMARK, bike_info.SHOW_DATE, bike.ID AS ID_AD, UNIX_TIMESTAMP(bike.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(bike.DATE_MODIFY) AS MODIFY_DATE, DATE_FORMAT(bike.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, bike.MODEL AS BIKE_MODEL, bike_type.BIKE_TYPE_EN AS BIKE_TYPE, color.COLOR_EN AS COLOR, color_type.COLOR_TYPE_EN AS COLOR_TYPE, bike_stat.HIT_AD_INFO AS AD_HIT FROM bike LEFT JOIN bike_info ON (bike.ID=bike_info.ID_BIKE) LEFT JOIN make ON (bike.ID_MAKE=make.ID) LEFT JOIN model ON (bike.ID_MODEL=model.ID) LEFT JOIN bike_type ON (bike.ID_BIKE_TYPE=bike_type.ID) LEFT JOIN color ON (bike_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (bike_info.ID_COLOR_TYPE=color_type.ID) LEFT JOIN bike_stat ON (bike.ID=bike_stat.ID_AD) WHERE bike.ID=? AND (bike.STATUS=? OR bike.STATUS=?)
33	Creole	executeQuery(): [5.23 ms] SELECT bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike_info.ID, bike_info.ID_BIKE, bike_info.HOOVER_ID, bike_info.REG_NO, bike_info.SHOW_REG, bike_info.ID_COLOR, bike_info.ID_COLOR_TYPE, bike_info.AD_CONDITION, bike_info.DOCUMENTED_HISTORY, bike_info.COMPETITION_HISTORY, bike_info.REGISTERED_VEHICLE, bike_info.MANUFACTURE_COUNTRY, bike_info.DELIVERY_COUNTRY, bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike_info.TAGS, bike_info.YOUTUBE_VID1, bike_info.YOUTUBE_VID2, bike_info.NOTE, bike_info.REMARK, bike_info.SHOW_DATE, bike.ID AS ID_AD, UNIX_TIMESTAMP(bike.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(bike.DATE_MODIFY) AS MODIFY_DATE, DATE_FORMAT(bike.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, bike.MODEL AS BIKE_MODEL, bike_type.BIKE_TYPE_EN AS BIKE_TYPE, color.COLOR_EN AS COLOR, color_type.COLOR_TYPE_EN AS COLOR_TYPE, bike_stat.HIT_AD_INFO AS AD_HIT FROM bike LEFT JOIN bike_info ON (bike.ID=bike_info.ID_BIKE) LEFT JOIN make ON (bike.ID_MAKE=make.ID) LEFT JOIN model ON (bike.ID_MODEL=model.ID) LEFT JOIN bike_type ON (bike.ID_BIKE_TYPE=bike_type.ID) LEFT JOIN color ON (bike_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (bike_info.ID_COLOR_TYPE=color_type.ID) LEFT JOIN bike_stat ON (bike.ID=bike_stat.ID_AD) WHERE bike.ID=143704 AND (bike.STATUS='F' OR bike.STATUS='P')
34	Creole	prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?)
35	Creole	executeQuery(): [7.56 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 (1258)
36	Creole	prepareStatement(): SELECT bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike_info.ID, bike_info.ID_BIKE, bike_info.HOOVER_ID, bike_info.REG_NO, bike_info.SHOW_REG, bike_info.ID_COLOR, bike_info.ID_COLOR_TYPE, bike_info.AD_CONDITION, bike_info.DOCUMENTED_HISTORY, bike_info.COMPETITION_HISTORY, bike_info.REGISTERED_VEHICLE, bike_info.MANUFACTURE_COUNTRY, bike_info.DELIVERY_COUNTRY, bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike_info.TAGS, bike_info.YOUTUBE_VID1, bike_info.YOUTUBE_VID2, bike_info.NOTE, bike_info.REMARK, bike_info.SHOW_DATE, DATE_ADD(bike.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM bike LEFT JOIN bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.ID=?
37	Creole	executeQuery(): [7.68 ms] SELECT bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike_info.ID, bike_info.ID_BIKE, bike_info.HOOVER_ID, bike_info.REG_NO, bike_info.SHOW_REG, bike_info.ID_COLOR, bike_info.ID_COLOR_TYPE, bike_info.AD_CONDITION, bike_info.DOCUMENTED_HISTORY, bike_info.COMPETITION_HISTORY, bike_info.REGISTERED_VEHICLE, bike_info.MANUFACTURE_COUNTRY, bike_info.DELIVERY_COUNTRY, bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike_info.TAGS, bike_info.YOUTUBE_VID1, bike_info.YOUTUBE_VID2, bike_info.NOTE, bike_info.REMARK, bike_info.SHOW_DATE, DATE_ADD(bike.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM bike LEFT JOIN bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.ID=143704
38	Creole	prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_BIKE=?
39	Creole	executeQuery(): [9.94 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_BIKE=143704
40	Creole	prepareStatement(): SELECT bike_contact.ID, bike_contact.ID_AD, bike_contact.ID_SOURCE_AD, bike_contact.SCODE, bike_contact.COMPANY, bike_contact.NAME, bike_contact.CITY, bike_contact.ADDRESS, bike_contact.ZIP, bike_contact.EMAIL, bike_contact.CONT_TIME, bike_contact.PHONE, bike_contact.MOBILE, bike_contact.FAX, bike_contact.WEB_URL, bike_contact.DATE_CREATE, bike_contact.DATE_MODIFY FROM bike_contact WHERE bike_contact.ID_AD=?
41	Creole	executeQuery(): [6.57 ms] SELECT bike_contact.ID, bike_contact.ID_AD, bike_contact.ID_SOURCE_AD, bike_contact.SCODE, bike_contact.COMPANY, bike_contact.NAME, bike_contact.CITY, bike_contact.ADDRESS, bike_contact.ZIP, bike_contact.EMAIL, bike_contact.CONT_TIME, bike_contact.PHONE, bike_contact.MOBILE, bike_contact.FAX, bike_contact.WEB_URL, bike_contact.DATE_CREATE, bike_contact.DATE_MODIFY FROM bike_contact WHERE bike_contact.ID_AD=143704
42	Creole	prepareStatement(): SELECT netti_dealer.ID_DEALER, netti_dealer.ID, netti_dealer.PATH, netti_dealer.COMPANY, netti_dealer.SLOGAN, netti_dealer.URL, netti_dealer.SIMPLE_URL, netti_dealer.HAS_SITE FROM netti_dealer WHERE netti_dealer.ID_DEALER IN (?)
43	Creole	executeQuery(): [4.42 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 (1258)
44	Creole	prepareStatement(): SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=? AND fa_payment_order.PAYMENT_STATUS=? AND fa_payment_order.UPSELLS_TAKEN=?
45	Creole	executeQuery(): [9.47 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=143704 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2'
46	Creole	prepareStatement(): SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID=?
47	Creole	executeQuery(): [4.45 ms] SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID='1'
48	Creole	prepareStatement(): SELECT bikeimg.ID, bikeimg.ID_AD, bikeimg.PATH, bikeimg.IMG_HASH, bikeimg.ORIGINAL, bikeimg.ORD, bikeimg.WIDTH, bikeimg.HEIGHT FROM bikeimg WHERE bikeimg.ID_AD IN (143704) ORDER BY bikeimg.ORD ASC
49	Creole	executeQuery(): [8.44 ms] SELECT bikeimg.ID, bikeimg.ID_AD, bikeimg.PATH, bikeimg.IMG_HASH, bikeimg.ORIGINAL, bikeimg.ORD, bikeimg.WIDTH, bikeimg.HEIGHT FROM bikeimg WHERE bikeimg.ID_AD IN (143704) ORDER BY bikeimg.ORD ASC
50	Creole	prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?)
51	Creole	executeQuery(): [9.57 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 (1258)
52	Creole	prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=?
53	Creole	executeQuery(): [8.18 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=1258 AND dealer_permission.WHICH='Q'
54	Creole	prepareStatement(): SELECT make.ID, make.MAKE_EN, make.MAKE_DE, make.MAKE_SV, make.DESCRIPTION_EN, make.DESCRIPTION_DE, make.DESCRIPTION_SV, make.URL, make.IMG_ORIGINAL, make.IMG_THUMB, make.ORD, make.COUNTER, make.DATE_CREATE, make.DATE_MODIFY, make.ID_BIKE_TYPE, make.DESCRIPTION_EN AS MAKE_DESC FROM make WHERE make.ID=?
55	Creole	executeQuery(): [8.51 ms] SELECT make.ID, make.MAKE_EN, make.MAKE_DE, make.MAKE_SV, make.DESCRIPTION_EN, make.DESCRIPTION_DE, make.DESCRIPTION_SV, make.URL, make.IMG_ORIGINAL, make.IMG_THUMB, make.ORD, make.COUNTER, make.DATE_CREATE, make.DATE_MODIFY, make.ID_BIKE_TYPE, make.DESCRIPTION_EN AS MAKE_DESC FROM make WHERE make.ID=1622
56	Creole	prepareStatement(): SELECT bike_type.ID, bike_type.BIKE_TYPE_EN, bike_type.BIKE_TYPE_DE, bike_type.BIKE_TYPE_SV, bike_type.DESCRIPTION_EN, bike_type.DESCRIPTION_DE, bike_type.DESCRIPTION_SV, bike_type.ORD, bike_type.TOT_SO, bike_type.TOT_FS, bike_type.DATE_CREATE, bike_type.DATE_MODIFY, bike_type.DESCRIPTION_EN AS BIKETYPE_DESC FROM bike_type WHERE bike_type.ID=?
57	Creole	executeQuery(): [9.81 ms] SELECT bike_type.ID, bike_type.BIKE_TYPE_EN, bike_type.BIKE_TYPE_DE, bike_type.BIKE_TYPE_SV, bike_type.DESCRIPTION_EN, bike_type.DESCRIPTION_DE, bike_type.DESCRIPTION_SV, bike_type.ORD, bike_type.TOT_SO, bike_type.TOT_FS, bike_type.DATE_CREATE, bike_type.DATE_MODIFY, bike_type.DESCRIPTION_EN AS BIKETYPE_DESC FROM bike_type WHERE bike_type.ID=1
58	Creole	prepareStatement(): ( SELECT bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike.ID AS ID_AD, UNIX_TIMESTAMP(bike.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(bike.DATE_MODIFY) AS MODIFY_DATE, bike_info.NOTE FROM cd_bikes.bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'F' AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) UNION ( SELECT bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike.ID AS ID_AD, UNIX_TIMESTAMP(bike.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(bike.DATE_MODIFY) AS MODIFY_DATE, bike_info.NOTE FROM cd_bikes.sold_bike as bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.sold_bike_info as bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'S' and bike.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) ORDER BY ID DESC
59	Creole	prepareStatement(): SELECT COUNT( * ) AS count FROM ( ( SELECT bike.id FROM cd_bikes.bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'F' AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) UNION ( SELECT bike.id FROM cd_bikes.sold_bike as bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.sold_bike_info as bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'S' and bike.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) ) AS count
60	Creole	executeQuery(): [12.04 ms] SELECT COUNT( * ) AS count FROM ( ( SELECT bike.id FROM cd_bikes.bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'F' AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) UNION ( SELECT bike.id FROM cd_bikes.sold_bike as bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.sold_bike_info as bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'S' and bike.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) ) AS count
61	Creole	applyLimit(): ( SELECT bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike.ID AS ID_AD, UNIX_TIMESTAMP(bike.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(bike.DATE_MODIFY) AS MODIFY_DATE, bike_info.NOTE FROM cd_bikes.bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'F' AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) UNION ( SELECT bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike.ID AS ID_AD, UNIX_TIMESTAMP(bike.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(bike.DATE_MODIFY) AS MODIFY_DATE, bike_info.NOTE FROM cd_bikes.sold_bike as bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.sold_bike_info as bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'S' and bike.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) ORDER BY ID DESC, offset: 0, limit: 5
62	Creole	executeQuery(): [12.59 ms] ( SELECT bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike.ID AS ID_AD, UNIX_TIMESTAMP(bike.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(bike.DATE_MODIFY) AS MODIFY_DATE, bike_info.NOTE FROM cd_bikes.bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'F' AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) UNION ( SELECT bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike.ID AS ID_AD, UNIX_TIMESTAMP(bike.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(bike.DATE_MODIFY) AS MODIFY_DATE, bike_info.NOTE FROM cd_bikes.sold_bike as bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.sold_bike_info as bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'S' and bike.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) ORDER BY ID DESC LIMIT 5
63	Creole	prepareStatement(): SELECT bikeimg.ID, bikeimg.ID_AD, bikeimg.PATH, bikeimg.IMG_HASH, bikeimg.ORIGINAL, bikeimg.ORD, bikeimg.WIDTH, bikeimg.HEIGHT FROM bikeimg WHERE bikeimg.ID_AD IN (195144,195143,195142,195141,195140) ORDER BY bikeimg.ORD ASC
64	Creole	executeQuery(): [4.38 ms] SELECT bikeimg.ID, bikeimg.ID_AD, bikeimg.PATH, bikeimg.IMG_HASH, bikeimg.ORIGINAL, bikeimg.ORD, bikeimg.WIDTH, bikeimg.HEIGHT FROM bikeimg WHERE bikeimg.ID_AD IN (195144,195143,195142,195141,195140) ORDER BY bikeimg.ORD ASC
65	Creole	prepareStatement(): SELECT bike.ID FROM bike WHERE bike.ID_MAKE=? AND bike.ID_MODEL=? AND bike.STATUS=?
66	Creole	executeQuery(): [4.80 ms] SELECT bike.ID FROM bike WHERE bike.ID_MAKE=1622 AND bike.ID_MODEL=0 AND bike.STATUS='F'
67	Creole	prepareStatement(): SELECT sold_bike.ID FROM sold_bike WHERE sold_bike.ID_MAKE=? AND sold_bike.ID_MODEL=? AND sold_bike.STATUS=?
68	Creole	executeQuery(): [14.84 ms] SELECT sold_bike.ID FROM sold_bike WHERE sold_bike.ID_MAKE=1622 AND sold_bike.ID_MODEL=0 AND sold_bike.STATUS='S'
69	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 (23507,66448,143702,143704,143705,143706,150926,161994,163078,165736,166928,168218,168219,168221,168222,177644,184991,184993,186600,195140,195141,195142,195143,195144) GROUP BY cmonth ORDER BY date_create
70	Creole	executeQuery(): [4.11 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 (23507,66448,143702,143704,143705,143706,150926,161994,163078,165736,166928,168218,168219,168221,168222,177644,184991,184993,186600,195140,195141,195142,195143,195144) GROUP BY cmonth ORDER BY date_create
71	Creole	prepareStatement(): SELECT ROUND(AVG(sb.price_ask)) AS avg_price, DATE_FORMAT( sbs.date_actual_sold, "%V" ) AS sold_week, DATE_FORMAT(sbs.date_actual_sold, "%V-%Y") AS wmonth FROM sold_bike sb LEFT JOIN sold_bike_stat sbs ON (sbs.ID_AD = sb.ID) WHERE sb.status = "S" AND sb.price_ask > 0 AND sbs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 5 YEAR) AND sbs.id_ad IN (143701,143703,143707,150924,150927,163817) GROUP BY sold_week ORDER BY sbs.date_actual_sold
72	Creole	executeQuery(): [5.09 ms] SELECT ROUND(AVG(sb.price_ask)) AS avg_price, DATE_FORMAT( sbs.date_actual_sold, "%V" ) AS sold_week, DATE_FORMAT(sbs.date_actual_sold, "%V-%Y") AS wmonth FROM sold_bike sb LEFT JOIN sold_bike_stat sbs ON (sbs.ID_AD = sb.ID) WHERE sb.status = "S" AND sb.price_ask > 0 AND sbs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 5 YEAR) AND sbs.id_ad IN (143701,143703,143707,150924,150927,163817) GROUP BY sold_week ORDER BY sbs.date_actual_sold
73	Creole	prepareStatement(): SELECT ROUND(AVG(sb.price_ask)) AS avg_price, DATE_FORMAT( sbs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(sbs.date_actual_sold, sb.date_create)) AS days FROM sold_bike sb LEFT JOIN sold_bike_stat sbs ON (sbs.ID_AD = sb.ID) WHERE sb.status = "S" AND sbs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sb.id IN (143701,143703,143707,150924,150927,163817) GROUP BY sold_month ORDER BY sbs.date_actual_sold
74	Creole	executeQuery(): [2.61 ms] SELECT ROUND(AVG(sb.price_ask)) AS avg_price, DATE_FORMAT( sbs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(sbs.date_actual_sold, sb.date_create)) AS days FROM sold_bike sb LEFT JOIN sold_bike_stat sbs ON (sbs.ID_AD = sb.ID) WHERE sb.status = "S" AND sbs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sb.id IN (143701,143703,143707,150924,150927,163817) GROUP BY sold_month ORDER BY sbs.date_actual_sold
75	Creole	prepareStatement(): SELECT mk.make_en, ROUND(AVG(sb.price_ask)) AS avg_price, DATE_FORMAT( sbs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(sbs.date_actual_sold, sb.date_create)) AS days, ROUND(ROUND(AVG(sb.price_ask)) / AVG(DATEDIFF(sbs.date_actual_sold, sb.date_create))) AS avg_index FROM sold_bike sb LEFT JOIN sold_bike_stat sbs ON (sbs.ID_AD = sb.ID) LEFT JOIN make mk ON (sb.id_make = mk.ID) WHERE sb.status = "S" GROUP BY sold_month ORDER BY avg_index DESC
76	Creole	executeQuery(): [31.28 ms] SELECT mk.make_en, ROUND(AVG(sb.price_ask)) AS avg_price, DATE_FORMAT( sbs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(sbs.date_actual_sold, sb.date_create)) AS days, ROUND(ROUND(AVG(sb.price_ask)) / AVG(DATEDIFF(sbs.date_actual_sold, sb.date_create))) AS avg_index FROM sold_bike sb LEFT JOIN sold_bike_stat sbs ON (sbs.ID_AD = sb.ID) LEFT JOIN make mk ON (sb.id_make = mk.ID) WHERE sb.status = "S" GROUP BY sold_month ORDER BY avg_index DESC
77	Action	change layout to "listing_layout"
78	View	initialize view for "home/view"
79	View	render "sf_app_dir/modules/home/templates/viewSuccess.php"
80	View	initialize view for "common_page/_fancybox_javascript"
81	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
82	PartialHelper	Generate cache key
83	View	initialize view for "home/_vif_images"
84	View	render "sf_app_dir/modules/home/templates/_vif_images.php"
85	PartialHelper	Generate cache key
86	View	initialize view for "common_page/_social_buttons"
87	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php"
88	PartialHelper	Generate cache key
89	View	initialize view for "home/_vif_info"
90	View	render "sf_app_dir/modules/home/templates/_vif_info.php"
91	PartialHelper	Generate cache key
92	View	initialize view for "home/_hoover_user_info"
93	View	render "sf_app_dir/modules/home/templates/_hoover_user_info.php"
94	PartialHelper	Generate cache key
95	View	initialize view for "common_page/_price_development_graph"
96	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php"
97	PartialHelper	Generate cache key
98	View	initialize view for "common_page/_sell_time_price_graph"
99	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php"
100	PartialHelper	Generate cache key
101	View	initialize view for "common_page/_price_gauge_graph"
102	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php"
103	PartialHelper	Generate cache key
104	Creole	prepareStatement(): SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=?
105	Creole	executeQuery(): [4.58 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=195144
106	Creole	prepareStatement(): SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=?
107	Creole	executeQuery(): [0.68 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=195143
108	Creole	prepareStatement(): SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=?
109	Creole	executeQuery(): [2.47 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=195142
110	Creole	prepareStatement(): SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=?
111	Creole	executeQuery(): [4.34 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=195141
112	Creole	prepareStatement(): SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=?
113	Creole	executeQuery(): [9.50 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=195140
114	View	initialize view for "common_page/_include_vif_js"
115	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_include_vif_js.php"
116	PartialHelper	Generate cache key
117	View	decorate content with "sf_app_dir/templates/listing_layout.php"
118	View	render "sf_app_dir/templates/listing_layout.php"
119	View	initialize view for "common_page/_responsive_javascript"
120	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_javascript.php"
121	PartialHelper	Generate cache key
122	View	initialize view for "common_page/_google_analytics"
123	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_google_analytics.php"
124	PartialHelper	Generate cache key
125	View	initialize view for "common_page/_header_links"
126	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_header_links.php"
127	View	initialize view for "common_page/_fancybox_javascript"
128	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php"
129	PartialHelper	Generate cache key
130	View	initialize view for "common_page/_cookie_policy"
131	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_cookie_policy.php"
132	PartialHelper	Generate cache key
133	PartialHelper	Generate cache key
134	View	initialize view for "common_page/_responsive_top_menu"
135	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_top_menu.php"
136	PartialHelper	Generate cache key
137	View	initialize view for "common_page/_top_menu"
138	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_top_menu.php"
139	PartialHelper	Generate cache key
140	View	initialize view for "common_page/_footer_javascript"
141	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer_javascript.php"
142	PartialHelper	Generate cache key
143	View	initialize view for "common_page/_footer"
144	View	render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer.php"
145	PartialHelper	Generate cache key

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    ID_AD: 143704
    action: view
    bike_type: road-bike
    id: 143704
    make: other-sprint-sport
    module: home
attributeHolder: 
  symfony/default: 
    HOME_LINK: <a href="/motorcycles/index_dev.php/index_dev.php">Classic Motorcycles</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: Netimoto - Moottoripyörät Skootterit Mopot Mönkijät Moottorikelkat
    keywords: moottoripyörä, moottoripyörät, käytetty, käytetyt, mopo, mopedi, mopot, mönkijä, mönkijät, moottorikelkka, moottorikelkat, skootteri, skootterit
    language: et,Estonian,ru,russia,fi,soumeksi,en,English
    other: NettiX Oy:n kehittämä vaihtomotosivusto. Nettimoto.com on sivusto yksityisille ilmoittajille sekä motoliikkeille. Nettimoto.com:issa on erittäin monipuoliset hakutoiminnot, jotka helpottavat vaihtomotoa etsivää.
    revisit-after: 15 days
    robots: index, follow
    title: Netimoto - Moottoripyörät Skootterit Mopot Mönkijät Moottorikelkat
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
  symfony/action/view: 
    home_view_layout: listing_layout
  symfony/response/http/headers: 
    Content-Type: text/html; charset=utf-8
  symfony/view/asset: 
    javascripts_included: 
    stylesheets_included:

Settings

---
app_params_image_limit: 25
app_params_pdf_limit: 1
app_params_site: Classic Motorcycles
app_params_tot_limit_nm: 50
app_params_tot_per_month_limit: 50
app_params_web_master: administrator@classicdigest.com
app_params_www: www.classicdigest.com/bikes
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: /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
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_builder: builder.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_lightbox: lightbox.js
js_modalbox: modalbox.js
js_netimoto: netimoto.js
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_bprice: 10000000
quick_search_min_bprice: 0
sf_admin_web_dir: /sf/sf_admin
sf_app: motorcycles
sf_app_config_dir: /web/classicdigest.com/apps/motorcycles/config
sf_app_config_dir_name: config
sf_app_dir: /web/classicdigest.com/apps/motorcycles
sf_app_i18n_dir: /web/classicdigest.com/lib/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: /web/classicdigest.com/apps/motorcycles/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/motorcycles/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/motorcycles/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/motorcycles
sf_bin_dir: /web/classicdigest.com/batch
sf_bin_dir_name: batch
sf_cache: 1
sf_cache_dir: /web/classicdigest.com/cache/motorcycles/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/motorcycles/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
  - missing_detail
  - facebook
  - sfLightboxPlugin
  - tag_cloud
  - 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/motorcycles/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: login
sf_login_module: default
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/motorcycles/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/motorcycles/dev/template
sf_test: 
sf_test_cache_dir: /web/classicdigest.com/cache/motorcycles/dev/test
sf_test_dir: /web/classicdigest.com/test
sf_test_dir_name: test
sf_timeout: 18000
sf_timer_start: 1765786229.1112
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: 
  fiareAds: ri5rgcuhahkh3agqm3ov5qs8lf
env: 
files: 
get: 
post: 
server: 
  CONTENT_LENGTH: 
  CONTENT_TYPE: 
  DOCUMENT_ROOT: /web/classicdigest.com/web
  DOCUMENT_URI: /motorcycles/index_dev.php/road-bike/other-sprint-sport/143704
  FCGI_ROLE: RESPONDER
  GATEWAY_INTERFACE: CGI/1.1
  HOME: /var/lib/nginx
  HTTPS: on
  HTTP_ACCEPT: */*
  HTTP_ACCEPT_ENCODING: gzip, br, zstd, deflate
  HTTP_COOKIE: fiareAds=ri5rgcuhahkh3agqm3ov5qs8lf
  HTTP_HOST: www.classicdigest.com
  HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
  PATH_INFO: /road-bike/other-sprint-sport/143704
  PATH_TRANSLATED: /web/classicdigest.com/web/road-bike/other-sprint-sport/143704
  PHP_SELF: /motorcycles/index_dev.php/road-bike/other-sprint-sport/143704
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REMOTE_ADDR: 216.73.216.62
  REMOTE_PORT: 57384
  REQUEST_METHOD: GET
  REQUEST_SCHEME: https
  REQUEST_TIME: 1765786229
  REQUEST_TIME_FLOAT: 1765786229.1095
  REQUEST_URI: /motorcycles/index_dev.php/road-bike/other-sprint-sport/143704
  SCRIPT_FILENAME: /web/classicdigest.com/web/motorcycles/index_dev.php
  SCRIPT_NAME: /motorcycles/index_dev.php
  SERVER_ADDR: 10.8.1.209
  SERVER_NAME: www.classicdigest.com
  SERVER_PORT: 443
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SOFTWARE: nginx/1.18.0
  USER: nginx
session: 
  visit_page: 
    - home/view

Php

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

SQL queries

SET time_zone = '+01:00'
SET time_zone = '+01:00'
SET time_zone = '+01:00'
SET time_zone = '+01:00'
SET time_zone = '+01:00'
[5.23 ms] SELECT bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike_info.ID, bike_info.ID_BIKE, bike_info.HOOVER_ID, bike_info.REG_NO, bike_info.SHOW_REG, bike_info.ID_COLOR, bike_info.ID_COLOR_TYPE, bike_info.AD_CONDITION, bike_info.DOCUMENTED_HISTORY, bike_info.COMPETITION_HISTORY, bike_info.REGISTERED_VEHICLE, bike_info.MANUFACTURE_COUNTRY, bike_info.DELIVERY_COUNTRY, bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike_info.TAGS, bike_info.YOUTUBE_VID1, bike_info.YOUTUBE_VID2, bike_info.NOTE, bike_info.REMARK, bike_info.SHOW_DATE, bike.ID AS ID_AD, UNIX_TIMESTAMP(bike.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(bike.DATE_MODIFY) AS MODIFY_DATE, DATE_FORMAT(bike.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, bike.MODEL AS BIKE_MODEL, bike_type.BIKE_TYPE_EN AS BIKE_TYPE, color.COLOR_EN AS COLOR, color_type.COLOR_TYPE_EN AS COLOR_TYPE, bike_stat.HIT_AD_INFO AS AD_HIT FROM bike LEFT JOIN bike_info ON (bike.ID=bike_info.ID_BIKE) LEFT JOIN make ON (bike.ID_MAKE=make.ID) LEFT JOIN model ON (bike.ID_MODEL=model.ID) LEFT JOIN bike_type ON (bike.ID_BIKE_TYPE=bike_type.ID) LEFT JOIN color ON (bike_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (bike_info.ID_COLOR_TYPE=color_type.ID) LEFT JOIN bike_stat ON (bike.ID=bike_stat.ID_AD) WHERE bike.ID=143704 AND (bike.STATUS='F' OR bike.STATUS='P')
[7.56 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 (1258)
[7.68 ms] SELECT bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike_info.ID, bike_info.ID_BIKE, bike_info.HOOVER_ID, bike_info.REG_NO, bike_info.SHOW_REG, bike_info.ID_COLOR, bike_info.ID_COLOR_TYPE, bike_info.AD_CONDITION, bike_info.DOCUMENTED_HISTORY, bike_info.COMPETITION_HISTORY, bike_info.REGISTERED_VEHICLE, bike_info.MANUFACTURE_COUNTRY, bike_info.DELIVERY_COUNTRY, bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike_info.TAGS, bike_info.YOUTUBE_VID1, bike_info.YOUTUBE_VID2, bike_info.NOTE, bike_info.REMARK, bike_info.SHOW_DATE, DATE_ADD(bike.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM bike LEFT JOIN bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.ID=143704
[9.94 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_BIKE=143704
[6.57 ms] SELECT bike_contact.ID, bike_contact.ID_AD, bike_contact.ID_SOURCE_AD, bike_contact.SCODE, bike_contact.COMPANY, bike_contact.NAME, bike_contact.CITY, bike_contact.ADDRESS, bike_contact.ZIP, bike_contact.EMAIL, bike_contact.CONT_TIME, bike_contact.PHONE, bike_contact.MOBILE, bike_contact.FAX, bike_contact.WEB_URL, bike_contact.DATE_CREATE, bike_contact.DATE_MODIFY FROM bike_contact WHERE bike_contact.ID_AD=143704
[4.42 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 (1258)
[9.47 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=143704 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2'
[4.45 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'
[8.44 ms] SELECT bikeimg.ID, bikeimg.ID_AD, bikeimg.PATH, bikeimg.IMG_HASH, bikeimg.ORIGINAL, bikeimg.ORD, bikeimg.WIDTH, bikeimg.HEIGHT FROM bikeimg WHERE bikeimg.ID_AD IN (143704) ORDER BY bikeimg.ORD ASC
[9.57 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 (1258)
[8.18 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=1258 AND dealer_permission.WHICH='Q'
[8.51 ms] SELECT make.ID, make.MAKE_EN, make.MAKE_DE, make.MAKE_SV, make.DESCRIPTION_EN, make.DESCRIPTION_DE, make.DESCRIPTION_SV, make.URL, make.IMG_ORIGINAL, make.IMG_THUMB, make.ORD, make.COUNTER, make.DATE_CREATE, make.DATE_MODIFY, make.ID_BIKE_TYPE, make.DESCRIPTION_EN AS MAKE_DESC FROM make WHERE make.ID=1622
[9.81 ms] SELECT bike_type.ID, bike_type.BIKE_TYPE_EN, bike_type.BIKE_TYPE_DE, bike_type.BIKE_TYPE_SV, bike_type.DESCRIPTION_EN, bike_type.DESCRIPTION_DE, bike_type.DESCRIPTION_SV, bike_type.ORD, bike_type.TOT_SO, bike_type.TOT_FS, bike_type.DATE_CREATE, bike_type.DATE_MODIFY, bike_type.DESCRIPTION_EN AS BIKETYPE_DESC FROM bike_type WHERE bike_type.ID=1
[12.04 ms] SELECT COUNT( * ) AS count FROM ( ( SELECT bike.id FROM cd_bikes.bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'F' AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) UNION ( SELECT bike.id FROM cd_bikes.sold_bike as bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.sold_bike_info as bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'S' and bike.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) ) AS count
[12.59 ms] ( SELECT bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike.ID AS ID_AD, UNIX_TIMESTAMP(bike.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(bike.DATE_MODIFY) AS MODIFY_DATE, bike_info.NOTE FROM cd_bikes.bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'F' AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) UNION ( SELECT bike_info.GENERAL_DESCRIPTION, bike_info.DOCUMENT_DESCRIPTION, bike_info.COMPETITION_DESCRIPTION, bike.ID, bike.ID_NETTI_USER, bike.ID_MAKE, bike.ID_MODEL, bike.ID_BIKE_TYPE, bike.MFG_YEAR, bike.MODEL, bike.MILEAGE, bike.ENGINE_SIZE, bike.ENGINE_MODEL, bike.DEALER_IDENTIFIER, bike.CURRENCY, bike.PRICE_ASK, bike.PRICE_STATUS, bike.STATUS, bike.POSTED_BY, bike.STAY_UNKNOWN, bike.DATE_CREATE, bike.DATE_MODIFY, bike.LOCATION, bike.ID AS ID_AD, UNIX_TIMESTAMP(bike.DATE_CREATE) AS ENROLL_DATE, UNIX_TIMESTAMP(bike.DATE_MODIFY) AS MODIFY_DATE, bike_info.NOTE FROM cd_bikes.sold_bike as bike LEFT JOIN cd_bikes.make ON (bike.ID_MAKE=make.ID) LEFT JOIN cd_bikes.model ON (bike.ID_MODEL=model.ID) LEFT JOIN cd_bikes.sold_bike_info as bike_info ON (bike.ID=bike_info.ID_BIKE) WHERE bike.status = 'S' and bike.date_modify > DATE_SUB(NOW(), INTERVAL 1 WEEK) AND bike.ID!=143704 AND (bike.ID_MAKE = '1622' OR bike.MFG_YEAR = '1967') ) ORDER BY ID DESC LIMIT 5
[4.38 ms] SELECT bikeimg.ID, bikeimg.ID_AD, bikeimg.PATH, bikeimg.IMG_HASH, bikeimg.ORIGINAL, bikeimg.ORD, bikeimg.WIDTH, bikeimg.HEIGHT FROM bikeimg WHERE bikeimg.ID_AD IN (195144,195143,195142,195141,195140) ORDER BY bikeimg.ORD ASC
[4.80 ms] SELECT bike.ID FROM bike WHERE bike.ID_MAKE=1622 AND bike.ID_MODEL=0 AND bike.STATUS='F'
[14.84 ms] SELECT sold_bike.ID FROM sold_bike WHERE sold_bike.ID_MAKE=1622 AND sold_bike.ID_MODEL=0 AND sold_bike.STATUS='S'
[4.11 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 (23507,66448,143702,143704,143705,143706,150926,161994,163078,165736,166928,168218,168219,168221,168222,177644,184991,184993,186600,195140,195141,195142,195143,195144) GROUP BY cmonth ORDER BY date_create
[5.09 ms] SELECT ROUND(AVG(sb.price_ask)) AS avg_price, DATE_FORMAT( sbs.date_actual_sold, "%V" ) AS sold_week, DATE_FORMAT(sbs.date_actual_sold, "%V-%Y") AS wmonth FROM sold_bike sb LEFT JOIN sold_bike_stat sbs ON (sbs.ID_AD = sb.ID) WHERE sb.status = "S" AND sb.price_ask > 0 AND sbs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 5 YEAR) AND sbs.id_ad IN (143701,143703,143707,150924,150927,163817) GROUP BY sold_week ORDER BY sbs.date_actual_sold
[2.61 ms] SELECT ROUND(AVG(sb.price_ask)) AS avg_price, DATE_FORMAT( sbs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(sbs.date_actual_sold, sb.date_create)) AS days FROM sold_bike sb LEFT JOIN sold_bike_stat sbs ON (sbs.ID_AD = sb.ID) WHERE sb.status = "S" AND sbs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sb.id IN (143701,143703,143707,150924,150927,163817) GROUP BY sold_month ORDER BY sbs.date_actual_sold
[31.28 ms] SELECT mk.make_en, ROUND(AVG(sb.price_ask)) AS avg_price, DATE_FORMAT( sbs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(sbs.date_actual_sold, sb.date_create)) AS days, ROUND(ROUND(AVG(sb.price_ask)) / AVG(DATEDIFF(sbs.date_actual_sold, sb.date_create))) AS avg_index FROM sold_bike sb LEFT JOIN sold_bike_stat sbs ON (sbs.ID_AD = sb.ID) LEFT JOIN make mk ON (sb.id_make = mk.ID) WHERE sb.status = "S" GROUP BY sold_month ORDER BY avg_index DESC
[4.58 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=195144
[0.68 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=195143
[2.47 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=195142
[4.34 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=195141
[9.50 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=195140

type	calls	time (ms)
Configuration	13	2.66
Action "home/view"	1	250.52
Database	27	213.12
View "Success" for "home/view"	1	40.88
Partial "common_page/_fancybox_javascript"	2	0.18
Partial "home/_vif_images"	1	0.36
Partial "common_page/_social_buttons"	1	0.08
Partial "home/_vif_info"	1	0.15
Partial "home/_hoover_user_info"	1	0.06
Partial "common_page/_price_development_graph"	1	0.06
Partial "common_page/_sell_time_price_graph"	1	0.05
Partial "common_page/_price_gauge_graph"	1	0.05
Partial "common_page/_include_vif_js"	1	0.07
Partial "common_page/_responsive_javascript"	1	0.05
Partial "common_page/_google_analytics"	1	0.05
Partial "common_page/_header_links"	1	0.83
Partial "common_page/_cookie_policy"	1	0.09
Partial "common_page/_responsive_top_menu"	1	0.12
Partial "common_page/_top_menu"	1	0.13
Partial "common_page/_footer_javascript"	1	0.11
Partial "common_page/_footer"	1	0.12

Other Sprint Sport 0.0

Bike Facts

Seller Information

ClassicDigest Market Radar on Other Sprint Sport

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers