People who viewed this Volkswagen Golf also viewed similar Volkswagen listed at ClassicDigest
Other cars listed for sale by this dealer
# | type | message |
---|---|---|
1 | ![]() | connect "/captcha" |
2 | ![]() | initialization |
3 | ![]() | initialization |
4 | ![]() | match route [na_vif] "/:make/:model/:id" |
5 | ![]() | request parameters array ( 'make' => 'volkswagen', 'model' => 'golf', 'id' => '169517', 'module' => 'home', 'action' => 'view',) |
6 | ![]() | connect "/sf_cache_partial/:module/:action/:sf_cache_key" |
7 | ![]() | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
8 | ![]() | prepareStatement(): SET time_zone = '+01:00' |
9 | ![]() | executeUpdate(): SET time_zone = '+01:00' |
10 | ![]() | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
11 | ![]() | prepareStatement(): SET time_zone = '+01:00' |
12 | ![]() | executeUpdate(): SET time_zone = '+01:00' |
13 | ![]() | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
14 | ![]() | prepareStatement(): SET time_zone = '+01:00' |
15 | ![]() | executeUpdate(): SET time_zone = '+01:00' |
16 | ![]() | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
17 | ![]() | prepareStatement(): SET time_zone = '+01:00' |
18 | ![]() | executeUpdate(): SET time_zone = '+01:00' |
19 | ![]() | connect(): DSN: array ( 'compat_assoc_lower' => '****', 'compat_rtrim_string' => '****', 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'socket' => '****', 'username' => '****', ), FLAGS: 0 |
20 | ![]() | prepareStatement(): SET time_zone = '+01:00' |
21 | ![]() | executeUpdate(): SET time_zone = '+01:00' |
22 | ![]() | dispatch request |
23 | ![]() | executing filter "sfRenderingFilter" |
24 | ![]() | executing filter "sfWebDebugFilter" |
25 | ![]() | executing filter "sfCarViewFilter" |
26 | ![]() | executing filter "naBreadcrumbFilter" |
27 | ![]() | executing filter "sfCacheFilter" |
28 | ![]() | executing filter "sfCommonFilter" |
29 | ![]() | executing filter "sfFlashFilter" |
30 | ![]() | executing filter "sfExecutionFilter" |
31 | ![]() | call "homeActions->executeView()" |
32 | ![]() | 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 | ![]() | executeQuery(): [1.64 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=169517 AND car.STATUS='F' |
34 | ![]() | prepareStatement(): SELECT sold_car.ID, sold_car.ID_NETTI_USER, sold_car.ID_MAKE, sold_car.ID_MODEL, sold_car.ID_VEHICLE_TYPE, sold_car.MFG_YEAR, sold_car.MILEAGE, sold_car.ENGINE_SIZE, sold_car.ENGINE_MODEL, sold_car.ID_ACC, sold_car.DEALER_IDENTIFIER, sold_car.PRICE_ASK, sold_car.CURRENCY, sold_car.PRICE_STATUS, sold_car.FIRST_REG, sold_car.STATUS, sold_car.POSTED_BY, sold_car.STAY_UNKNOWN, sold_car.DRIVE_SIDE, sold_car.DATE_CREATE, sold_car.DATE_MODIFY, sold_car.LOCATION, sold_car_info.ID, sold_car_info.ID_CAR, sold_car_info.HOOVER_ID, sold_car_info.REG_NO, sold_car_info.SHOW_REG, sold_car_info.ID_CAR_TYPE, sold_car_info.ID_COLOR, sold_car_info.ID_COLOR_TYPE, sold_car_info.AD_CONDITION, sold_car_info.DOCUMENTED_HISTORY, sold_car_info.COMPETITION_HISTORY, sold_car_info.REGISTERED_VEHICLE, sold_car_info.MANUFACTURE_COUNTRY, sold_car_info.DELIVERY_COUNTRY, sold_car_info.GENERAL_DESCRIPTION, sold_car_info.DOCUMENT_DESCRIPTION, sold_car_info.COMPETITION_DESCRIPTION, sold_car_info.TAGS, sold_car_info.YOUTUBE_VID1, sold_car_info.YOUTUBE_VID2, sold_car_info.NOTE, sold_car_info.REMARK, sold_car_info.SHOW_DATE, sold_car.ID AS ID_AD, DATE_FORMAT(sold_car.DATE_MODIFY,'%d.%m.%Y') AS DM, make.MAKE_EN AS MAKE, model.MODEL_EN AS MODEL, make.MAKE_EN AS MAKE_en, model.MODEL_EN AS MODEL_en, vehicle_type.VEHICLE_TYPE_EN AS VEHICLE_TYPE, car_type.CAR_TYPE_EN AS CAR_TYPE, color.COLOR_EN AS COLOR, color_type.COLOR_TYPE_EN AS COLOR_TYPE FROM sold_car LEFT JOIN sold_car_info ON (sold_car.ID=sold_car_info.ID_CAR) LEFT JOIN make ON (sold_car.ID_MAKE=make.ID) LEFT JOIN model ON (sold_car.ID_MODEL=model.ID) LEFT JOIN vehicle_type ON (sold_car.ID_VEHICLE_TYPE=vehicle_type.ID) LEFT JOIN car_type ON (sold_car_info.ID_CAR_TYPE=car_type.ID) LEFT JOIN color ON (sold_car_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (sold_car_info.ID_COLOR_TYPE=color_type.ID) WHERE sold_car.ID=? |
35 | ![]() | executeQuery(): [1.21 ms] SELECT sold_car.ID, sold_car.ID_NETTI_USER, sold_car.ID_MAKE, sold_car.ID_MODEL, sold_car.ID_VEHICLE_TYPE, sold_car.MFG_YEAR, sold_car.MILEAGE, sold_car.ENGINE_SIZE, sold_car.ENGINE_MODEL, sold_car.ID_ACC, sold_car.DEALER_IDENTIFIER, sold_car.PRICE_ASK, sold_car.CURRENCY, sold_car.PRICE_STATUS, sold_car.FIRST_REG, sold_car.STATUS, sold_car.POSTED_BY, sold_car.STAY_UNKNOWN, sold_car.DRIVE_SIDE, sold_car.DATE_CREATE, sold_car.DATE_MODIFY, sold_car.LOCATION, sold_car_info.ID, sold_car_info.ID_CAR, sold_car_info.HOOVER_ID, sold_car_info.REG_NO, sold_car_info.SHOW_REG, sold_car_info.ID_CAR_TYPE, sold_car_info.ID_COLOR, sold_car_info.ID_COLOR_TYPE, sold_car_info.AD_CONDITION, sold_car_info.DOCUMENTED_HISTORY, sold_car_info.COMPETITION_HISTORY, sold_car_info.REGISTERED_VEHICLE, sold_car_info.MANUFACTURE_COUNTRY, sold_car_info.DELIVERY_COUNTRY, sold_car_info.GENERAL_DESCRIPTION, sold_car_info.DOCUMENT_DESCRIPTION, sold_car_info.COMPETITION_DESCRIPTION, sold_car_info.TAGS, sold_car_info.YOUTUBE_VID1, sold_car_info.YOUTUBE_VID2, sold_car_info.NOTE, sold_car_info.REMARK, sold_car_info.SHOW_DATE, sold_car.ID AS ID_AD, DATE_FORMAT(sold_car.DATE_MODIFY,'%d.%m.%Y') AS DM, make.MAKE_EN AS MAKE, model.MODEL_EN AS MODEL, make.MAKE_EN AS MAKE_en, model.MODEL_EN AS MODEL_en, vehicle_type.VEHICLE_TYPE_EN AS VEHICLE_TYPE, car_type.CAR_TYPE_EN AS CAR_TYPE, color.COLOR_EN AS COLOR, color_type.COLOR_TYPE_EN AS COLOR_TYPE FROM sold_car LEFT JOIN sold_car_info ON (sold_car.ID=sold_car_info.ID_CAR) LEFT JOIN make ON (sold_car.ID_MAKE=make.ID) LEFT JOIN model ON (sold_car.ID_MODEL=model.ID) LEFT JOIN vehicle_type ON (sold_car.ID_VEHICLE_TYPE=vehicle_type.ID) LEFT JOIN car_type ON (sold_car_info.ID_CAR_TYPE=car_type.ID) LEFT JOIN color ON (sold_car_info.ID_COLOR=color.ID) LEFT JOIN color_type ON (sold_car_info.ID_COLOR_TYPE=color_type.ID) WHERE sold_car.ID=169517 |
36 | ![]() | prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?) |
37 | ![]() | executeQuery(): [0.68 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 (430) |
38 | ![]() | prepareStatement(): SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, DATE_ADD(car.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) WHERE car.ID=? |
39 | ![]() | executeQuery(): [0.90 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=169517 |
40 | ![]() | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
41 | ![]() | executeQuery(): [0.89 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=169517 |
42 | ![]() | prepareStatement(): SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=? AND fa_payment_order.PAYMENT_STATUS=? AND fa_payment_order.UPSELLS_TAKEN=? |
43 | ![]() | executeQuery(): [0.89 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=169517 AND fa_payment_order.PAYMENT_STATUS='S' AND fa_payment_order.UPSELLS_TAKEN='2' |
44 | ![]() | prepareStatement(): SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID=? |
45 | ![]() | executeQuery(): [0.78 ms] SELECT package_type.ID, package_type.TITLE_EN, package_type.DESCRIPTION_EN, package_type.TITLE_DE, package_type.DESCRIPTION_DE, package_type.TITLE_SV, package_type.DESCRIPTION_SV, package_type.PRICE FROM package_type WHERE package_type.ID='1' |
46 | ![]() | prepareStatement(): SELECT sold_carimg.ID, sold_carimg.ID_AD, sold_carimg.PATH, sold_carimg.IMG_HASH, sold_carimg.ORIGINAL, sold_carimg.ORD, sold_carimg.WIDTH, sold_carimg.HEIGHT FROM sold_carimg WHERE sold_carimg.ID_AD IN (169517) ORDER BY sold_carimg.ORD ASC |
47 | ![]() | executeQuery(): [0.90 ms] SELECT sold_carimg.ID, sold_carimg.ID_AD, sold_carimg.PATH, sold_carimg.IMG_HASH, sold_carimg.ORIGINAL, sold_carimg.ORD, sold_carimg.WIDTH, sold_carimg.HEIGHT FROM sold_carimg WHERE sold_carimg.ID_AD IN (169517) ORDER BY sold_carimg.ORD ASC |
48 | ![]() | prepareStatement(): SELECT netti_user.ID, netti_user.FNAME, netti_user.LNAME, netti_user.ADDRESS, netti_user.CITY, netti_user.EMAIL, netti_user.PHONE, netti_user.FAX, netti_user.MOBILE, netti_user.EMAIL, netti_user.ZIP, netti_user.CONT_TIME, netti_user.DOMICILE, netti_user.ID_COUNTRY, netti_user.CATEGORY, netti_user.LOGINID FROM netti_user WHERE netti_user.ID IN (?) |
49 | ![]() | executeQuery(): [0.60 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 (430) |
50 | ![]() | prepareStatement(): SELECT netti_dealer.ID_DEALER, netti_dealer.ID, netti_dealer.PATH, netti_dealer.COMPANY, netti_dealer.SLOGAN, netti_dealer.URL, netti_dealer.SIMPLE_URL, netti_dealer.HAS_SITE FROM netti_dealer WHERE netti_dealer.ID_DEALER IN (?) |
51 | ![]() | executeQuery(): [0.74 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 (430) |
52 | ![]() | prepareStatement(): SELECT dealer.ID_MAKE, dealer.HIT_COUNTER FROM dealer WHERE dealer.ID_DEALER=? |
53 | ![]() | executeQuery(): [0.68 ms] SELECT dealer.ID_MAKE, dealer.HIT_COUNTER FROM dealer WHERE dealer.ID_DEALER=430 |
54 | ![]() | prepareStatement(): SELECT netti_dealer.HAS_SITE, netti_dealer.SIMPLE_URL, netti_dealer.SLOGAN FROM netti_dealer WHERE netti_dealer.ID_DEALER=? |
55 | ![]() | executeQuery(): [0.65 ms] SELECT netti_dealer.HAS_SITE, netti_dealer.SIMPLE_URL, netti_dealer.SLOGAN FROM netti_dealer WHERE netti_dealer.ID_DEALER=430 |
56 | ![]() | prepareStatement(): SELECT dealer_permission.ID, dealer_permission.ID_DEALER, dealer_permission.WHICH, dealer_permission.DATE_CREATE FROM dealer_permission WHERE dealer_permission.ID_DEALER=? |
57 | ![]() | executeQuery(): [0.84 ms] SELECT dealer_permission.ID, dealer_permission.ID_DEALER, dealer_permission.WHICH, dealer_permission.DATE_CREATE FROM dealer_permission WHERE dealer_permission.ID_DEALER=430 |
58 | ![]() | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
59 | ![]() | executeQuery(): [0.73 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=430 AND dealer_permission.WHICH='Q' |
60 | ![]() | prepareStatement(): SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=? AND model.ID=? AND make.ID=model.ID_MAKE |
61 | ![]() | executeQuery(): [0.94 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=175 AND model.ID=2005 AND make.ID=model.ID_MAKE |
62 | ![]() | 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 != 169517 AND car.ID_MODEL = '2005' ) 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 != 169517 AND car.ID_MODEL = '2005' ) ORDER BY ID DESC |
63 | ![]() | 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 != 169517 AND car.ID_MODEL = '2005' ) 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 != 169517 AND car.ID_MODEL = '2005' ) ) AS count |
64 | ![]() | executeQuery(): [3.39 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 != 169517 AND car.ID_MODEL = '2005' ) 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 != 169517 AND car.ID_MODEL = '2005' ) ) AS count |
65 | ![]() | 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 != 169517 AND car.ID_MODEL = '2005' ) 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 != 169517 AND car.ID_MODEL = '2005' ) ORDER BY ID DESC, offset: 0, limit: 5 |
66 | ![]() | executeQuery(): [5.01 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 != 169517 AND car.ID_MODEL = '2005' ) 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 != 169517 AND car.ID_MODEL = '2005' ) ORDER BY ID DESC LIMIT 5 |
67 | ![]() | 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 (197297,192202,191513,172133,170927) ORDER BY carimg.ORD ASC |
68 | ![]() | executeQuery(): [1.21 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 (197297,192202,191513,172133,170927) ORDER BY carimg.ORD ASC |
69 | ![]() | 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 != '169517' AND car.ID_NETTI_USER = '430' ) 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 != '169517' AND car.ID_NETTI_USER = '430' ) ORDER BY ID DESC |
70 | ![]() | 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 != '169517' AND car.ID_NETTI_USER = '430' ) 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 != '169517' AND car.ID_NETTI_USER = '430' ) ) AS count |
71 | ![]() | executeQuery(): [2.86 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 != '169517' AND car.ID_NETTI_USER = '430' ) 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 != '169517' AND car.ID_NETTI_USER = '430' ) ) AS count |
72 | ![]() | 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 != '169517' AND car.ID_NETTI_USER = '430' ) 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 != '169517' AND car.ID_NETTI_USER = '430' ) ORDER BY ID DESC, offset: 0, limit: 5 |
73 | ![]() | executeQuery(): [4.01 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 != '169517' AND car.ID_NETTI_USER = '430' ) 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 != '169517' AND car.ID_NETTI_USER = '430' ) ORDER BY ID DESC LIMIT 5 |
74 | ![]() | 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 (199082,198753,198670,198591,198590) ORDER BY carimg.ORD ASC |
75 | ![]() | 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 (199082,198753,198670,198591,198590) ORDER BY carimg.ORD ASC |
76 | ![]() | prepareStatement(): SELECT car.ID FROM car WHERE car.ID_MAKE=? AND car.ID_MODEL=? AND car.STATUS=? |
77 | ![]() | executeQuery(): [0.78 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=175 AND car.ID_MODEL=2005 AND car.STATUS='F' |
78 | ![]() | prepareStatement(): SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=? AND sold_car.ID_MODEL=? AND sold_car.STATUS=? |
79 | ![]() | executeQuery(): [3.64 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=175 AND sold_car.ID_MODEL=2005 AND sold_car.STATUS='S' |
80 | ![]() | 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 (28593,30077,49462,51025,62799,63949,66792,83703,84752,84870,85307,86953,91720,101449,103708,108385,113552,113712,119153,120280,120281,129707,131486,131628,131629,131940,132562,133112,133468,134857,134859,134861,134959,134960,134961,134963,136709,141701,141864,141990,142031,142041,142042,142361,142822,142999,148302,150733,151621,151622,157000,157780,162871,165610,167252,170926,170927,172133,191513,192202,197297) GROUP BY cmonth ORDER BY date_create |
81 | ![]() | executeQuery(): [1.46 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 (28593,30077,49462,51025,62799,63949,66792,83703,84752,84870,85307,86953,91720,101449,103708,108385,113552,113712,119153,120280,120281,129707,131486,131628,131629,131940,132562,133112,133468,134857,134859,134861,134959,134960,134961,134963,136709,141701,141864,141990,142031,142041,142042,142361,142822,142999,148302,150733,151621,151622,157000,157780,162871,165610,167252,170926,170927,172133,191513,192202,197297) GROUP BY cmonth ORDER BY date_create |
82 | ![]() | 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 (29112,29900,31333,31574,32348,36310,36533,36534,43211,43212,43213,43277,44641,45290,46764,46795,47500,48450,48974,49970,53989,55110,60060,60625,61658,62074,62084,62100,62163,62366,62855,62856,63062,63071,63704,64547,65059,66271,68610,69240,69464,69465,69526,70331,70364,70920,71738,71806,72554,72751,73399,74997,76004,76803,76804,78632,83704,83705,83706,83707,83708,83709,83710,83711,83712,83713,84148,84184,84185,84186,84234,84350,84372,84577,84710,84711,84826,84830,84916,84994,85306,85418,85461,85462,85876,85877,85900,86413,86672,86704,86739,86740,86923,86924,87094,87139,87140,88149,89034,89151,89204,89205,89381,89382,89443,90069,90642,90643,90805,90991,91138,92003,92171,93601,94054,94093,94094,95032,95235,95236,95329,95713,95869,95870,95908,95957,97760,97761,98021,98970,98971,99925,99982,100502,100503,101044,101448,101595,102042,103048,103049,103234,103331,103373,103709,104029,104324,105137,105672,106049,106203,106204,106220,106372,106860,107011,107073,107290,107291,107380,107390,107477,108379,108574,108575,108673,108674,108857,108882,108971,109120,109168,109173,110052,110060,110609,111128,111354,111355,111659,111660,112225,112801,112862,112998,113191,113493,113746,113806,114049,114050,114321,114655,115125,115404,115749,115765,115780,115781,116109,116838,116839,116840,117171,117535,117536,117717,118576,118721,118846,118916,119333,119665,119908,120005,120380,122014,122015,122016,122017,122018,122019,122194,122388,123090,123117,123120,123405,126789,126790,129585,129629,129996,130461,130897,130924,131118,131183,131184,131340,131357,131405,131443,131630,131643,131644,131645,131717,131718,131750,131827,132003,132035,132457,132731,132827,132870,133198,133199,133384,133428,133707,133788,134081,134108,134133,134134,134858,134860,134962,135331,135734,135735,135736,135759,135826,136139,136202,136786,137126,139217,139218,139305,141302,142030,142808,146571,146706,146712,146714,147058,147449,149488,150400,150627,151661,152166,152575,152834,155062,155917,155919,155930,156129,157009,158094,158166,158799,158914,159559,159652,160276,161599,162339,163054,163741,163854,163959,163962,164030,164229,164574,164797,164974,165148,166519,167882,169517,169944,170189,170964,171359,171365,172488,172696,174034,174492,174958,176378,177025,177642,178553,179183,179603,179604,180447,181149,181740,182313,183274,184887,185011,185314,185574,186533,186970,187258,187457,187768,189645,191299,191714,191914,192480,192813,192991,193849,194970,196736) GROUP BY sold_week ORDER BY scs.date_actual_sold |
83 | ![]() | executeQuery(): [3.55 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 (29112,29900,31333,31574,32348,36310,36533,36534,43211,43212,43213,43277,44641,45290,46764,46795,47500,48450,48974,49970,53989,55110,60060,60625,61658,62074,62084,62100,62163,62366,62855,62856,63062,63071,63704,64547,65059,66271,68610,69240,69464,69465,69526,70331,70364,70920,71738,71806,72554,72751,73399,74997,76004,76803,76804,78632,83704,83705,83706,83707,83708,83709,83710,83711,83712,83713,84148,84184,84185,84186,84234,84350,84372,84577,84710,84711,84826,84830,84916,84994,85306,85418,85461,85462,85876,85877,85900,86413,86672,86704,86739,86740,86923,86924,87094,87139,87140,88149,89034,89151,89204,89205,89381,89382,89443,90069,90642,90643,90805,90991,91138,92003,92171,93601,94054,94093,94094,95032,95235,95236,95329,95713,95869,95870,95908,95957,97760,97761,98021,98970,98971,99925,99982,100502,100503,101044,101448,101595,102042,103048,103049,103234,103331,103373,103709,104029,104324,105137,105672,106049,106203,106204,106220,106372,106860,107011,107073,107290,107291,107380,107390,107477,108379,108574,108575,108673,108674,108857,108882,108971,109120,109168,109173,110052,110060,110609,111128,111354,111355,111659,111660,112225,112801,112862,112998,113191,113493,113746,113806,114049,114050,114321,114655,115125,115404,115749,115765,115780,115781,116109,116838,116839,116840,117171,117535,117536,117717,118576,118721,118846,118916,119333,119665,119908,120005,120380,122014,122015,122016,122017,122018,122019,122194,122388,123090,123117,123120,123405,126789,126790,129585,129629,129996,130461,130897,130924,131118,131183,131184,131340,131357,131405,131443,131630,131643,131644,131645,131717,131718,131750,131827,132003,132035,132457,132731,132827,132870,133198,133199,133384,133428,133707,133788,134081,134108,134133,134134,134858,134860,134962,135331,135734,135735,135736,135759,135826,136139,136202,136786,137126,139217,139218,139305,141302,142030,142808,146571,146706,146712,146714,147058,147449,149488,150400,150627,151661,152166,152575,152834,155062,155917,155919,155930,156129,157009,158094,158166,158799,158914,159559,159652,160276,161599,162339,163054,163741,163854,163959,163962,164030,164229,164574,164797,164974,165148,166519,167882,169517,169944,170189,170964,171359,171365,172488,172696,174034,174492,174958,176378,177025,177642,178553,179183,179603,179604,180447,181149,181740,182313,183274,184887,185011,185314,185574,186533,186970,187258,187457,187768,189645,191299,191714,191914,192480,192813,192991,193849,194970,196736) GROUP BY sold_week ORDER BY scs.date_actual_sold |
84 | ![]() | 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 (29112,29900,31333,31574,32348,36310,36533,36534,43211,43212,43213,43277,44641,45290,46764,46795,47500,48450,48974,49970,53989,55110,60060,60625,61658,62074,62084,62100,62163,62366,62855,62856,63062,63071,63704,64547,65059,66271,68610,69240,69464,69465,69526,70331,70364,70920,71738,71806,72554,72751,73399,74997,76004,76803,76804,78632,83704,83705,83706,83707,83708,83709,83710,83711,83712,83713,84148,84184,84185,84186,84234,84350,84372,84577,84710,84711,84826,84830,84916,84994,85306,85418,85461,85462,85876,85877,85900,86413,86672,86704,86739,86740,86923,86924,87094,87139,87140,88149,89034,89151,89204,89205,89381,89382,89443,90069,90642,90643,90805,90991,91138,92003,92171,93601,94054,94093,94094,95032,95235,95236,95329,95713,95869,95870,95908,95957,97760,97761,98021,98970,98971,99925,99982,100502,100503,101044,101448,101595,102042,103048,103049,103234,103331,103373,103709,104029,104324,105137,105672,106049,106203,106204,106220,106372,106860,107011,107073,107290,107291,107380,107390,107477,108379,108574,108575,108673,108674,108857,108882,108971,109120,109168,109173,110052,110060,110609,111128,111354,111355,111659,111660,112225,112801,112862,112998,113191,113493,113746,113806,114049,114050,114321,114655,115125,115404,115749,115765,115780,115781,116109,116838,116839,116840,117171,117535,117536,117717,118576,118721,118846,118916,119333,119665,119908,120005,120380,122014,122015,122016,122017,122018,122019,122194,122388,123090,123117,123120,123405,126789,126790,129585,129629,129996,130461,130897,130924,131118,131183,131184,131340,131357,131405,131443,131630,131643,131644,131645,131717,131718,131750,131827,132003,132035,132457,132731,132827,132870,133198,133199,133384,133428,133707,133788,134081,134108,134133,134134,134858,134860,134962,135331,135734,135735,135736,135759,135826,136139,136202,136786,137126,139217,139218,139305,141302,142030,142808,146571,146706,146712,146714,147058,147449,149488,150400,150627,151661,152166,152575,152834,155062,155917,155919,155930,156129,157009,158094,158166,158799,158914,159559,159652,160276,161599,162339,163054,163741,163854,163959,163962,164030,164229,164574,164797,164974,165148,166519,167882,169517,169944,170189,170964,171359,171365,172488,172696,174034,174492,174958,176378,177025,177642,178553,179183,179603,179604,180447,181149,181740,182313,183274,184887,185011,185314,185574,186533,186970,187258,187457,187768,189645,191299,191714,191914,192480,192813,192991,193849,194970,196736) GROUP BY sold_month ORDER BY scs.date_actual_sold |
85 | ![]() | executeQuery(): [4.21 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 (29112,29900,31333,31574,32348,36310,36533,36534,43211,43212,43213,43277,44641,45290,46764,46795,47500,48450,48974,49970,53989,55110,60060,60625,61658,62074,62084,62100,62163,62366,62855,62856,63062,63071,63704,64547,65059,66271,68610,69240,69464,69465,69526,70331,70364,70920,71738,71806,72554,72751,73399,74997,76004,76803,76804,78632,83704,83705,83706,83707,83708,83709,83710,83711,83712,83713,84148,84184,84185,84186,84234,84350,84372,84577,84710,84711,84826,84830,84916,84994,85306,85418,85461,85462,85876,85877,85900,86413,86672,86704,86739,86740,86923,86924,87094,87139,87140,88149,89034,89151,89204,89205,89381,89382,89443,90069,90642,90643,90805,90991,91138,92003,92171,93601,94054,94093,94094,95032,95235,95236,95329,95713,95869,95870,95908,95957,97760,97761,98021,98970,98971,99925,99982,100502,100503,101044,101448,101595,102042,103048,103049,103234,103331,103373,103709,104029,104324,105137,105672,106049,106203,106204,106220,106372,106860,107011,107073,107290,107291,107380,107390,107477,108379,108574,108575,108673,108674,108857,108882,108971,109120,109168,109173,110052,110060,110609,111128,111354,111355,111659,111660,112225,112801,112862,112998,113191,113493,113746,113806,114049,114050,114321,114655,115125,115404,115749,115765,115780,115781,116109,116838,116839,116840,117171,117535,117536,117717,118576,118721,118846,118916,119333,119665,119908,120005,120380,122014,122015,122016,122017,122018,122019,122194,122388,123090,123117,123120,123405,126789,126790,129585,129629,129996,130461,130897,130924,131118,131183,131184,131340,131357,131405,131443,131630,131643,131644,131645,131717,131718,131750,131827,132003,132035,132457,132731,132827,132870,133198,133199,133384,133428,133707,133788,134081,134108,134133,134134,134858,134860,134962,135331,135734,135735,135736,135759,135826,136139,136202,136786,137126,139217,139218,139305,141302,142030,142808,146571,146706,146712,146714,147058,147449,149488,150400,150627,151661,152166,152575,152834,155062,155917,155919,155930,156129,157009,158094,158166,158799,158914,159559,159652,160276,161599,162339,163054,163741,163854,163959,163962,164030,164229,164574,164797,164974,165148,166519,167882,169517,169944,170189,170964,171359,171365,172488,172696,174034,174492,174958,176378,177025,177642,178553,179183,179603,179604,180447,181149,181740,182313,183274,184887,185011,185314,185574,186533,186970,187258,187457,187768,189645,191299,191714,191914,192480,192813,192991,193849,194970,196736) GROUP BY sold_month ORDER BY scs.date_actual_sold |
86 | ![]() | prepareStatement(): SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC |
87 | ![]() | executeQuery(): [1288.03 ms] SELECT mk.make_en, md.model_en, ROUND(AVG(sc.price_ask)) AS avg_price, DATE_FORMAT( scs.date_actual_sold, "%m-%Y" ) AS sold_month, AVG(DATEDIFF(scs.date_actual_sold, sc.date_create)) AS days, ROUND(ROUND(AVG(sc.price_ask)) / AVG(DATEDIFF(scs.date_actual_sold, sc.date_create))) AS avg_index FROM sold_car sc LEFT JOIN sold_car_stat scs ON (scs.ID_AD = sc.ID) LEFT JOIN make mk ON (sc.id_make = mk.ID) LEFT JOIN model md ON (sc.id_model = md.ID) WHERE sc.status = "S" GROUP BY sold_month ORDER BY avg_index DESC |
88 | ![]() | change layout to "view_layout" |
89 | ![]() | initialize view for "home/view" |
90 | ![]() | render "sf_app_dir/modules/home/templates/viewSuccess.php" |
91 | ![]() | initialize view for "home/_vif_images" |
92 | ![]() | render "sf_app_dir/modules/home/templates/_vif_images.php" |
93 | ![]() | Generate cache key |
94 | ![]() | initialize view for "common_page/_social_buttons" |
95 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_social_buttons.php" |
96 | ![]() | Generate cache key |
97 | ![]() | initialize view for "home/_vif_info" |
98 | ![]() | render "sf_app_dir/modules/home/templates/_vif_info.php" |
99 | ![]() | Generate cache key |
100 | ![]() | initialize view for "common_page/_price_development_graph" |
101 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_development_graph.php" |
102 | ![]() | Generate cache key |
103 | ![]() | initialize view for "common_page/_sell_time_price_graph" |
104 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_sell_time_price_graph.php" |
105 | ![]() | Generate cache key |
106 | ![]() | initialize view for "common_page/_price_gauge_graph" |
107 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_price_gauge_graph.php" |
108 | ![]() | Generate cache key |
109 | ![]() | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
110 | ![]() | executeQuery(): [0.75 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=197297 |
111 | ![]() | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
112 | ![]() | executeQuery(): [0.62 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=192202 |
113 | ![]() | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
114 | ![]() | executeQuery(): [0.63 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=191513 |
115 | ![]() | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
116 | ![]() | executeQuery(): [0.63 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=172133 |
117 | ![]() | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
118 | ![]() | executeQuery(): [0.57 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=170927 |
119 | ![]() | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
120 | ![]() | executeQuery(): [0.57 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199082 |
121 | ![]() | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
122 | ![]() | executeQuery(): [0.60 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198753 |
123 | ![]() | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
124 | ![]() | executeQuery(): [0.62 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198670 |
125 | ![]() | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
126 | ![]() | executeQuery(): [0.57 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198591 |
127 | ![]() | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
128 | ![]() | executeQuery(): [0.58 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198590 |
129 | ![]() | initialize view for "common_page/_include_vif_js" |
130 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_include_vif_js.php" |
131 | ![]() | Generate cache key |
132 | ![]() | initialize view for "common_page/_fancybox_javascript" |
133 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php" |
134 | ![]() | Generate cache key |
135 | ![]() | decorate content with "sf_app_dir/templates/view_layout.php" |
136 | ![]() | render "sf_app_dir/templates/view_layout.php" |
137 | ![]() | initialize view for "common_page/_responsive_javascript" |
138 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_javascript.php" |
139 | ![]() | Generate cache key |
140 | ![]() | initialize view for "common_page/_google_analytics" |
141 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_google_analytics.php" |
142 | ![]() | Generate cache key |
143 | ![]() | initialize view for "common_page/_header_links" |
144 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_header_links.php" |
145 | ![]() | initialize view for "common_page/_fancybox_javascript" |
146 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_fancybox_javascript.php" |
147 | ![]() | Generate cache key |
148 | ![]() | initialize view for "common_page/_cookie_policy" |
149 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_cookie_policy.php" |
150 | ![]() | Generate cache key |
151 | ![]() | Generate cache key |
152 | ![]() | initialize view for "common_page/_responsive_top_menu" |
153 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_responsive_top_menu.php" |
154 | ![]() | Generate cache key |
155 | ![]() | initialize view for "common_page/_top_menu" |
156 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_top_menu.php" |
157 | ![]() | Generate cache key |
158 | ![]() | initialize view for "common_page/_footer_javascript" |
159 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer_javascript.php" |
160 | ![]() | Generate cache key |
161 | ![]() | initialize view for "common_page/_footer" |
162 | ![]() | render "sf_root_dir/plugins/faFiareAdsPlugin/modules/common_page/templates/_footer.php" |
163 | ![]() | Generate cache key |
--- parameterHolder: symfony/default: ID_AD: 169517 action: view id: 169517 make: volkswagen model: golf module: home attributeHolder: symfony/default: HOME_LINK: <a title="cap_na_default_title_3" href="https://www.classicdigest.com/cars/index_dev.php">Classic Cars</a> base_domain: .classicdigest.com display_que_ans_setction: Y show_cookie_policy: 1
--- cookies: httpHeaders: Content-Type: text/html; charset=utf-8 parameterHolder: helper/asset/auto/httpmeta: Content-Type: text/html; charset=utf-8 helper/asset/auto/javascript: /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main helper/asset/auto/meta: author: Fiare description: Netiauto - Osta tai Myy vaihtoautot- Kauppa käy keywords: auto, autot, vaihtoautot, vaihtoauto, vaihtoautoliike, bensa, polttoaine, käytetyt, netiauto, osta, myy, käytetty, etsi, haku, ilmastointi, stereot, amatööri, moottori, katsastus, kesäauto, automaatti, kova, halpa, halvalla, kone, hyvä, nopea, ilmainen, ilmaiseksi, second hand, used, car, cars, hot, fast, good, cheap language: et,Estonian,ru,russia,fi,soumeksi,en,English other: Mach1 Oy:n kehittämä vaihtoautosivusto. netiauto.ee on sivusto yksityisille ilmoittajille sekä autoliikkeille. netiauto.ee:issa on erittäin monipuoliset hakutoiminnot, jotka helpottavat vaihtoautoa etsivää. revisit-after: 15 days robots: follow,index title: Netiauto - Osta tai Myy vaihtoautot- Kauppa käy helper/asset/auto/stylesheet: /sf/sf_web_debug/css/main: symfony/action/view: home_view_layout: view_layout symfony/response/http/headers: Content-Type: text/html; charset=utf-8 symfony/view/asset: javascripts_included: stylesheets_included:
--- app_params_adbox_slot: 6 app_params_image_limit: 25 app_params_pdf_limit: 1 app_params_site: Classic Cars app_params_tot_limit_na: 50 app_params_tot_per_month_limit: 50 app_params_web_master: administrator@classicdigest.com app_params_www: www.classicdigest.com/cars app_url_na: https://www.classicdigest.com/cars/index_dev.php app_url_nm: https://www.classicdigest.com/motorcycles/index_dev.php app_url_site_url: https://www.classicdigest.com/cars/index_dev.php css_jquery_ui_custom: jquery-ui-1.8.23.custom.min.css css_jsquares: jsquares.min.css css_responsive: responsive.min.css css_style: style.min.css homepage_sms_slots: 12 html_direction: ltr html_left: left html_right: right jquery_url: https://ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js js_banner: banner.min.js js_common: common.min.js js_effects: effects.js js_html5_printshiv: html5shiv-printshiv.min.js js_html5shiv: html5shiv.min.js js_jsquares: mosiac/jquery.jsquares.min.js js_lazy: lazyload/jquery.lazy.min.js js_netiauto: netiauto js_prototype: prototype.js js_slider: slider.min.js mod_home_enabled: 1 mod_home_is_internal: mod_home_view_class: sfPHP quick_search_max_price: 10000000 quick_search_min_price: 0 sf_admin_web_dir: /sf/sf_admin sf_app: cars sf_app_config_dir: /web/classicdigest.com/apps/cars/config sf_app_config_dir_name: config sf_app_dir: /web/classicdigest.com/apps/cars sf_app_i18n_dir: /web/classicdigest.com/lib/i18n sf_app_i18n_dir_name: i18n sf_app_lib_dir: /web/classicdigest.com/apps/cars/lib sf_app_lib_dir_name: lib sf_app_module_action_dir_name: actions sf_app_module_config_dir_name: config sf_app_module_dir: /web/classicdigest.com/apps/cars/modules sf_app_module_dir_name: modules sf_app_module_i18n_dir_name: i18n sf_app_module_lib_dir_name: lib sf_app_module_template_dir_name: templates sf_app_module_validate_dir_name: validate sf_app_module_view_dir_name: views sf_app_template_dir: /web/classicdigest.com/apps/cars/templates sf_app_template_dir_name: templates sf_apps_dir_name: apps sf_autoloading_functions: sf_available: 1 sf_base_cache_dir: /web/classicdigest.com/cache/cars sf_bin_dir: /web/classicdigest.com/batch sf_bin_dir_name: batch sf_cache: 1 sf_cache_dir: /web/classicdigest.com/cache/cars/dev sf_cache_dir_name: cache sf_calendar_web_dir: /sf/calendar sf_charset: utf-8 sf_check_lock: sf_check_symfony_version: sf_compressed: sf_config_cache_dir: /web/classicdigest.com/cache/cars/dev/config sf_config_dir: /web/classicdigest.com/config sf_config_dir_name: config sf_data_dir: /web/classicdigest.com/data sf_data_dir_name: data sf_debug: 1 sf_default_action: index sf_default_module: default sf_doc_dir: /web/classicdigest.com/data/doc sf_doc_dir_name: doc sf_enabled_modules: - default - user - faSms - user_mail - faDealer - dealer_person - statistics - vote - faErrors - feedback - sfTCPDF - static - article - news - que_ans - favorite - category - sfCaptchaGD - service_index - club - sfLightboxPlugin - sfPropelNorthIdPlugin - facebook - tag_cloud - adbox - apijson - findAgent - fb_connect - fbGeneral sf_environment: dev sf_error_404_action: error404 sf_error_404_module: faErrors sf_error_reporting: 2037 sf_escaping_method: ESC_ENTITIES sf_escaping_strategy: bc sf_etag: sf_i18n: 1 sf_i18n_cache: 1 sf_i18n_cache_dir: /web/classicdigest.com/cache/cars/dev/i18n sf_i18n_debug: sf_i18n_default_culture: en sf_i18n_source: gettext sf_i18n_untranslated_prefix: [T] sf_i18n_untranslated_suffix: [/T] sf_lazy_cache_key: sf_lib_dir: /web/classicdigest.com/lib sf_lib_dir_name: lib sf_lightbox_css_dir: https://www.classicdigest.com/entity/css/sfLightboxPlugin/ sf_lightbox_images_dir: https://www.classicdigest.com/entity/images/sfLightboxPlugin/ sf_lightbox_js_dir: https://www.classicdigest.com/entity/js/sfLightboxPlugin/ sf_log_dir: /web/classicdigest.com/log sf_log_dir_name: log sf_logging_enabled: 1 sf_logging_history: 10 sf_logging_level: debug sf_logging_period: 7 sf_logging_purge: 1 sf_logging_rotate: sf_login_action: loginRequired sf_login_module: faErrors sf_max_forwards: 5 sf_model_dir_name: model sf_model_lib_dir: /web/classicdigest.com/lib/model sf_module_cache_dir: /web/classicdigest.com/cache/cars/dev/modules sf_module_disabled_action: disabled sf_module_disabled_module: default sf_no_script_name: sf_orm: propel sf_path_info_array: SERVER sf_path_info_key: PATH_INFO sf_plugins_dir: /web/classicdigest.com/plugins sf_plugins_dir_name: plugins sf_prototype_web_dir: /sf/prototype sf_rich_text_js_dir: js/tiny_mce sf_root_cache_dir: /web/classicdigest.com/cache sf_root_dir: /web/classicdigest.com sf_routing_defaults: sf_culture: en sf_secure_action: secure sf_secure_module: default sf_standard_helpers: - Partial - Cache - Form - Date - faNettiX - faClient - Javascript - Validation - Object - Lightbox sf_strip_comments: 1 sf_suffix: . sf_symfony_data_dir: /web/clssymfony/data sf_symfony_lib_dir: /web/clssymfony/lib sf_template_cache_dir: /web/classicdigest.com/cache/cars/dev/template sf_test: sf_test_cache_dir: /web/classicdigest.com/cache/cars/dev/test sf_test_dir: /web/classicdigest.com/test sf_test_dir_name: test sf_timeout: 1800 sf_timer_start: 1725446733.7836 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
--- cookie: env: files: get: post: server: CONTENT_LENGTH: CONTENT_TYPE: DOCUMENT_ROOT: /web/classicdigest.com/web DOCUMENT_URI: /cars/index_dev.php/volkswagen/golf/169517 FCGI_ROLE: RESPONDER GATEWAY_INTERFACE: CGI/1.1 HOME: /var/lib/nginx HTTPS: on HTTP_ACCEPT: */* HTTP_ACCEPT_ENCODING: gzip, br, zstd, deflate HTTP_HOST: www.classicdigest.com HTTP_REFERER: https://classicdigest.com/cars/index_dev.php/volkswagen/golf/169517 HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) PATH_INFO: /volkswagen/golf/169517 PATH_TRANSLATED: /web/classicdigest.com/web/volkswagen/golf/169517 PHP_SELF: /cars/index_dev.php/volkswagen/golf/169517 QUERY_STRING: REDIRECT_STATUS: 200 REMOTE_ADDR: 3.137.178.206 REMOTE_PORT: 42875 REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1725446733 REQUEST_TIME_FLOAT: 1725446733.7822 REQUEST_URI: /cars/index_dev.php/volkswagen/golf/169517 SCRIPT_FILENAME: /web/classicdigest.com/web/cars/index_dev.php SCRIPT_NAME: /cars/index_dev.php SERVER_ADDR: 10.8.1.209 SERVER_NAME: www.classicdigest.com SERVER_PORT: 443 SERVER_PROTOCOL: HTTP/1.1 SERVER_SOFTWARE: nginx/1.18.0 USER: nginx session: visit_page: - home/view
--- php: 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
type | calls | time (ms) |
---|---|---|
Configuration | 13 | 1.55 |
Action "home/view" | 1 | 1391.64 |
Database | 37 | 1338.33 |
View "Success" for "home/view" | 1 | 46.25 |
Partial "home/_vif_images" | 1 | 0.27 |
Partial "common_page/_social_buttons" | 1 | 0.07 |
Partial "home/_vif_info" | 1 | 0.15 |
Partial "common_page/_price_development_graph" | 1 | 0.05 |
Partial "common_page/_sell_time_price_graph" | 1 | 0.05 |
Partial "common_page/_price_gauge_graph" | 1 | 0.04 |
Partial "common_page/_include_vif_js" | 1 | 0.08 |
Partial "common_page/_fancybox_javascript" | 2 | 0.17 |
Partial "common_page/_responsive_javascript" | 1 | 0.07 |
Partial "common_page/_google_analytics" | 1 | 0.04 |
Partial "common_page/_header_links" | 1 | 0.67 |
Partial "common_page/_cookie_policy" | 1 | 0.07 |
Partial "common_page/_responsive_top_menu" | 1 | 0.11 |
Partial "common_page/_top_menu" | 1 | 0.12 |
Partial "common_page/_footer_javascript" | 1 | 0.11 |
Partial "common_page/_footer" | 1 | 0.10 |