# |
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' => 'malaguti-grand-sport', 'id' => '183391', '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(): [1.08 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=183391 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(): [2.02 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(): [10.05 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=183391 |
38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_BIKE=? |
39 | Creole | executeQuery(): [10.13 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_BIKE=183391 |
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(): [13.59 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=183391 |
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(): [6.22 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.49 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=183391 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(): [16.16 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 (183391) ORDER BY bikeimg.ORD ASC |
49 | Creole | executeQuery(): [4.89 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 (183391) 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(): [5.80 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(): [16.10 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(): [10.44 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=25 |
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.73 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!=183391 AND (bike.ID_MAKE = '25' OR bike.MFG_YEAR = '1969') ) 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!=183391 AND (bike.ID_MAKE = '25' OR bike.MFG_YEAR = '1969') ) 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!=183391 AND (bike.ID_MAKE = '25' OR bike.MFG_YEAR = '1969') ) 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!=183391 AND (bike.ID_MAKE = '25' OR bike.MFG_YEAR = '1969') ) ) AS count |
60 | Creole | executeQuery(): [28.63 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!=183391 AND (bike.ID_MAKE = '25' OR bike.MFG_YEAR = '1969') ) 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!=183391 AND (bike.ID_MAKE = '25' OR bike.MFG_YEAR = '1969') ) ) 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!=183391 AND (bike.ID_MAKE = '25' OR bike.MFG_YEAR = '1969') ) 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!=183391 AND (bike.ID_MAKE = '25' OR bike.MFG_YEAR = '1969') ) ORDER BY ID DESC, offset: 0, limit: 5 |
62 | Creole | executeQuery(): [31.35 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!=183391 AND (bike.ID_MAKE = '25' OR bike.MFG_YEAR = '1969') ) 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!=183391 AND (bike.ID_MAKE = '25' OR bike.MFG_YEAR = '1969') ) 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 (186972,181637,168222,163372,144201) ORDER BY bikeimg.ORD ASC |
64 | Creole | executeQuery(): [29.09 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 (186972,181637,168222,163372,144201) 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(): [9.85 ms] SELECT bike.ID FROM bike WHERE bike.ID_MAKE=25 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(): [10.83 ms] SELECT sold_bike.ID FROM sold_bike WHERE sold_bike.ID_MAKE=25 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 (125044,144201,163372,181637,183391) GROUP BY cmonth ORDER BY date_create |
70 | Creole | executeQuery(): [37.20 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 (125044,144201,163372,181637,183391) 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 (125042,125043,125045) GROUP BY sold_week ORDER BY sbs.date_actual_sold |
72 | Creole | executeQuery(): [11.04 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 (125042,125043,125045) 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 (125042,125043,125045) GROUP BY sold_month ORDER BY sbs.date_actual_sold |
74 | Creole | executeQuery(): [5.58 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 (125042,125043,125045) 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(): [27.49 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(): [48.14 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=186972 |
106 | Creole | prepareStatement(): SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=? |
107 | Creole | executeQuery(): [1.41 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=181637 |
108 | Creole | prepareStatement(): SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=? |
109 | Creole | executeQuery(): [1.45 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=168222 |
110 | Creole | prepareStatement(): SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=? |
111 | Creole | executeQuery(): [18.21 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=163372 |
112 | Creole | prepareStatement(): SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=? |
113 | Creole | executeQuery(): [8.90 ms] SELECT bike.ID_MAKE, bike.MODEL, bike.ID_BIKE_TYPE FROM bike WHERE bike.ID=144201 |
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 |