# |
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' => '198539', '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.37 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=198539 AND car.STATUS='F' |
34 | Creole | prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?) |
35 | Creole | executeQuery(): [0.71 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 (914) |
36 | Creole | prepareStatement(): SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, DATE_ADD(car.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) WHERE car.ID=? |
37 | Creole | executeQuery(): [1.11 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=198539 |
38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
39 | Creole | executeQuery(): [1.57 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=198539 |
40 | Creole | prepareStatement(): SELECT car_contact.ID, car_contact.ID_AD, car_contact.ID_SOURCE_AD, car_contact.SCODE, car_contact.COMPANY, car_contact.NAME, car_contact.CITY, car_contact.ADDRESS, car_contact.ZIP, car_contact.EMAIL, car_contact.CONT_TIME, car_contact.PHONE, car_contact.MOBILE, car_contact.FAX, car_contact.WEB_URL, car_contact.DATE_CREATE, car_contact.DATE_MODIFY FROM car_contact WHERE car_contact.ID_AD=? |
41 | Creole | executeQuery(): [7.17 ms] SELECT car_contact.ID, car_contact.ID_AD, car_contact.ID_SOURCE_AD, car_contact.SCODE, car_contact.COMPANY, car_contact.NAME, car_contact.CITY, car_contact.ADDRESS, car_contact.ZIP, car_contact.EMAIL, car_contact.CONT_TIME, car_contact.PHONE, car_contact.MOBILE, car_contact.FAX, car_contact.WEB_URL, car_contact.DATE_CREATE, car_contact.DATE_MODIFY FROM car_contact WHERE car_contact.ID_AD=198539 |
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(): [0.87 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 (914) |
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(): [0.71 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=198539 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(): [0.99 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 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 (198539) ORDER BY carimg.ORD ASC |
49 | Creole | executeQuery(): [1.00 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 (198539) ORDER BY carimg.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(): [0.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 (914) |
52 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
53 | Creole | executeQuery(): [1.13 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=914 AND dealer_permission.WHICH='Q' |
54 | 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 |
55 | Creole | executeQuery(): [0.45 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 |
56 | 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 != 198539 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 != 198539 AND car.ID_MODEL = '1284' ) ORDER BY ID DESC |
57 | 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 != 198539 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 != 198539 AND car.ID_MODEL = '1284' ) ) AS count |
58 | Creole | executeQuery(): [2.72 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 != 198539 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 != 198539 AND car.ID_MODEL = '1284' ) ) AS count |
59 | 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 != 198539 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 != 198539 AND car.ID_MODEL = '1284' ) ORDER BY ID DESC, offset: 0, limit: 5 |
60 | Creole | executeQuery(): [3.86 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 != 198539 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 != 198539 AND car.ID_MODEL = '1284' ) ORDER BY ID DESC LIMIT 5 |
61 | 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 (197147,196931,196253,196229,195873) ORDER BY carimg.ORD ASC |
62 | Creole | executeQuery(): [0.61 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 (197147,196931,196253,196229,195873) ORDER BY carimg.ORD ASC |
63 | 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 != '198539' AND car.ID_NETTI_USER = '914' ) 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 != '198539' AND car.ID_NETTI_USER = '914' ) ORDER BY ID DESC |
64 | 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 != '198539' AND car.ID_NETTI_USER = '914' ) 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 != '198539' AND car.ID_NETTI_USER = '914' ) ) AS count |
65 | Creole | executeQuery(): [3.90 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 != '198539' AND car.ID_NETTI_USER = '914' ) 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 != '198539' AND car.ID_NETTI_USER = '914' ) ) AS count |
66 | 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 != '198539' AND car.ID_NETTI_USER = '914' ) 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 != '198539' AND car.ID_NETTI_USER = '914' ) ORDER BY ID DESC, offset: 0, limit: 5 |
67 | Creole | executeQuery(): [9.84 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 != '198539' AND car.ID_NETTI_USER = '914' ) 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 != '198539' AND car.ID_NETTI_USER = '914' ) ORDER BY ID DESC LIMIT 5 |
68 | 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 (198904,198805,198803,198802,198717) ORDER BY carimg.ORD ASC |
69 | Creole | executeQuery(): [0.79 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 (198904,198805,198803,198802,198717) ORDER BY carimg.ORD ASC |
70 | Creole | prepareStatement(): SELECT car.ID FROM car WHERE car.ID_MAKE=? AND car.ID_MODEL=? AND car.STATUS=? |
71 | Creole | executeQuery(): [0.67 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=115 AND car.ID_MODEL=1284 AND car.STATUS='F' |
72 | Creole | prepareStatement(): SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=? AND sold_car.ID_MODEL=? AND sold_car.STATUS=? |
73 | Creole | executeQuery(): [3.14 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' |
74 | Creole | prepareStatement(): SELECT id, id_ad, ROUND(AVG(price)) AS avg_price, DATE_FORMAT(date_create, "%m-%Y") AS cmonth, date_create FROM price_history WHERE date_create >= DATE_SUB(SYSDATE(), INTERVAL 1 YEAR) AND id_ad IN (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,197147,198539) GROUP BY cmonth ORDER BY date_create |
75 | Creole | executeQuery(): [1.33 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,197147,198539) GROUP BY cmonth ORDER BY date_create |
76 | Creole | prepareStatement(): SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%V" ) AS sold_week, DATE_FORMAT(scs.date_actual_sold, "%V-%Y") AS wmonth FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND sc.price_ask > 0 AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 5 YEAR) AND scs.id_ad IN (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) GROUP BY sold_week ORDER BY scs.date_actual_sold |
77 | Creole | executeQuery(): [3.87 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) GROUP BY sold_week ORDER BY scs.date_actual_sold |
78 | Creole | prepareStatement(): SELECT ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) WHERE sc.status = "S" AND scs.date_actual_sold > DATE_SUB(NOW(), INTERVAL 2 YEAR) AND sc.id IN (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) GROUP BY sold_month ORDER BY scs.date_actual_sold |
79 | Creole | executeQuery(): [4.69 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) GROUP BY sold_month ORDER BY scs.date_actual_sold |
80 | Creole | prepareStatement(): SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC |
81 | Creole | executeQuery(): [815.44 ms] SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC |
82 | Action | change layout to "view_layout" |
83 | View | initialize view for "home/view" |
84 | View | render "sf_app_dir/modules/home/templates/viewSuccess.php" |
85 | View | initialize view for "home/_vif_images" |
86 | View | render "sf_app_dir/modules/home/templates/_vif_images.php" |
87 | PartialHelper | Generate cache key |
88 | View | initialize view for "common_page/_social_buttons" |
89 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php" |
90 | PartialHelper | Generate cache key |
91 | View | initialize view for "home/_vif_info" |
92 | View | render "sf_app_dir/modules/home/templates/_vif_info.php" |
93 | PartialHelper | Generate cache key |
94 | View | initialize view for "home/_hoover_user_info" |
95 | View | render "sf_app_dir/modules/home/templates/_hoover_user_info.php" |
96 | PartialHelper | Generate cache key |
97 | View | initialize view for "common_page/_price_development_graph" |
98 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php" |
99 | PartialHelper | Generate cache key |
100 | View | initialize view for "common_page/_sell_time_price_graph" |
101 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php" |
102 | PartialHelper | Generate cache key |
103 | View | initialize view for "common_page/_price_gauge_graph" |
104 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php" |
105 | PartialHelper | Generate cache key |
106 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
107 | Creole | executeQuery(): [1.10 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197147 |
108 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
109 | Creole | executeQuery(): [1.67 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=196931 |
110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
111 | Creole | executeQuery(): [1.21 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=196253 |
112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
113 | Creole | executeQuery(): [1.26 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=196229 |
114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
115 | Creole | executeQuery(): [0.98 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=195873 |
116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
117 | Creole | executeQuery(): [0.85 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198904 |
118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
119 | Creole | executeQuery(): [0.56 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198805 |
120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
121 | Creole | executeQuery(): [0.58 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198803 |
122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
123 | Creole | executeQuery(): [1.25 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198802 |
124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
125 | Creole | executeQuery(): [1.71 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198717 |
126 | View | initialize view for "common_page/_include_vif_js" |
127 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_include_vif_js.php" |
128 | PartialHelper | Generate cache key |
129 | View | initialize view for "common_page/_fancybox_javascript" |
130 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php" |
131 | PartialHelper | Generate cache key |
132 | View | decorate content with "sf_app_dir/templates/view_layout.php" |
133 | View | render "sf_app_dir/templates/view_layout.php" |
134 | View | initialize view for "common_page/_responsive_javascript" |
135 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_javascript.php" |
136 | PartialHelper | Generate cache key |
137 | View | initialize view for "common_page/_google_analytics" |
138 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_google_analytics.php" |
139 | PartialHelper | Generate cache key |
140 | View | initialize view for "common_page/_header_links" |
141 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_header_links.php" |
142 | View | initialize view for "common_page/_fancybox_javascript" |
143 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php" |
144 | PartialHelper | Generate cache key |
145 | View | initialize view for "common_page/_cookie_policy" |
146 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_cookie_policy.php" |
147 | PartialHelper | Generate cache key |
148 | PartialHelper | Generate cache key |
149 | View | initialize view for "common_page/_responsive_top_menu" |
150 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_top_menu.php" |
151 | PartialHelper | Generate cache key |
152 | View | initialize view for "common_page/_top_menu" |
153 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_top_menu.php" |
154 | PartialHelper | Generate cache key |
155 | View | initialize view for "common_page/_footer_javascript" |
156 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer_javascript.php" |
157 | PartialHelper | Generate cache key |
158 | View | initialize view for "common_page/_footer" |
159 | View | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer.php" |
160 | PartialHelper | Generate cache key |