People who viewed this Volkswagen Beetle Typ1 also viewed similar Volkswagen listed at ClassicDigest
Other cars listed for sale by this dealer
# | 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' => 'volkswagen', 'model' => 'beetle-typ1', 'id' => '199775', '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.25 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=199775 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.64 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 (906) |
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(): [0.87 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=199775 |
38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
39 | Creole | executeQuery(): [0.68 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=199775 |
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(): [15.42 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=199775 |
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.72 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 (906) |
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.63 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=199775 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.80 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 (199775) ORDER BY carimg.ORD ASC |
49 | Creole | executeQuery(): [0.69 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 (199775) 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.49 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 (906) |
52 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
53 | Creole | executeQuery(): [0.56 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=906 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.77 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=1993 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 != 199775 AND car.ID_MODEL = '1993' ) 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 != 199775 AND car.ID_MODEL = '1993' ) 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 != 199775 AND car.ID_MODEL = '1993' ) 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 != 199775 AND car.ID_MODEL = '1993' ) ) AS count |
58 | Creole | executeQuery(): [8.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 != 199775 AND car.ID_MODEL = '1993' ) 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 != 199775 AND car.ID_MODEL = '1993' ) ) 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 != 199775 AND car.ID_MODEL = '1993' ) 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 != 199775 AND car.ID_MODEL = '1993' ) ORDER BY ID DESC, offset: 0, limit: 5 |
60 | Creole | executeQuery(): [13.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 != 199775 AND car.ID_MODEL = '1993' ) 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 != 199775 AND car.ID_MODEL = '1993' ) 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 (199964,199915,199861,199832,199533) ORDER BY carimg.ORD ASC |
62 | 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 (199964,199915,199861,199832,199533) 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 != '199775' AND car.ID_NETTI_USER = '906' ) 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 != '199775' AND car.ID_NETTI_USER = '906' ) 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 != '199775' AND car.ID_NETTI_USER = '906' ) 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 != '199775' AND car.ID_NETTI_USER = '906' ) ) AS count |
65 | Creole | executeQuery(): [10.08 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 != '199775' AND car.ID_NETTI_USER = '906' ) 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 != '199775' AND car.ID_NETTI_USER = '906' ) ) 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 != '199775' AND car.ID_NETTI_USER = '906' ) 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 != '199775' AND car.ID_NETTI_USER = '906' ) ORDER BY ID DESC, offset: 0, limit: 5 |
67 | Creole | executeQuery(): [17.44 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 != '199775' AND car.ID_NETTI_USER = '906' ) 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 != '199775' AND car.ID_NETTI_USER = '906' ) 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 (200010,199995,199976,199974,199973) ORDER BY carimg.ORD ASC |
69 | Creole | executeQuery(): [0.97 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 (200010,199995,199976,199974,199973) 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(): [1.81 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=175 AND car.ID_MODEL=1993 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(): [52.53 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=175 AND sold_car.ID_MODEL=1993 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 (27806,28276,28594,30627,30994,31331,31445,33429,33430,44810,48345,50189,53843,59570,67861,72940,97998,106985,114656,117324,118847,123418,127908,131358,131444,131719,131779,132558,132559,132583,133589,133762,134868,135254,135464,135545,135599,135883,136181,136231,136494,136498,136538,136732,137529,138389,138405,139611,140318,140888,140889,141257,141719,142092,142094,142209,142609,142810,142811,143118,147150,147539,150945,151226,153212,153718,154304,155721,155875,155877,156465,157064,157079,158715,159989,160640,162686,166312,168446,171575,172264,172544,173072,173073,173192,173726,175395,176608,176904,176982,176983,177203,177268,177535,177541,177674,178210,179180,180229,180455,180548,181136,181902,183355,183377,184106,184595,185664,186520,186958,186959,187438,188326,188697,189809,190091,190717,191531,192264,192814,193678,193848,193901,194209,194347,194491,194492,194502,194770,194989,196188,196326,196572,196657,196824,196927,197034,197035,197312,197389,197398,197469,197534,197578,197698,198457,198612,198726,199104,199138,199270,199331,199504,199533,199775,199832,199861,199915,199964) GROUP BY cmonth ORDER BY date_create |
75 | Creole | executeQuery(): [2.86 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 (27806,28276,28594,30627,30994,31331,31445,33429,33430,44810,48345,50189,53843,59570,67861,72940,97998,106985,114656,117324,118847,123418,127908,131358,131444,131719,131779,132558,132559,132583,133589,133762,134868,135254,135464,135545,135599,135883,136181,136231,136494,136498,136538,136732,137529,138389,138405,139611,140318,140888,140889,141257,141719,142092,142094,142209,142609,142810,142811,143118,147150,147539,150945,151226,153212,153718,154304,155721,155875,155877,156465,157064,157079,158715,159989,160640,162686,166312,168446,171575,172264,172544,173072,173073,173192,173726,175395,176608,176904,176982,176983,177203,177268,177535,177541,177674,178210,179180,180229,180455,180548,181136,181902,183355,183377,184106,184595,185664,186520,186958,186959,187438,188326,188697,189809,190091,190717,191531,192264,192814,193678,193848,193901,194209,194347,194491,194492,194502,194770,194989,196188,196326,196572,196657,196824,196927,197034,197035,197312,197389,197398,197469,197534,197578,197698,198457,198612,198726,199104,199138,199270,199331,199504,199533,199775,199832,199861,199915,199964) 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 (21076,21181,21253,21368,21652,21756,21986,21987,22186,22693,22794,23839,23847,23848,23903,24135,24470,24783,24785,24832,24926,24927,24958,24970,25067,25109,25206,25429,25493,25503,25566,25711,25712,25727,25741,25872,25939,25944,26019,26031,26187,26205,26207,26294,26297,26353,26361,26362,26706,26707,26955,27165,27500,27600,27779,27891,27892,27909,27910,27936,27972,27982,27995,28102,28191,28192,28209,28353,28470,28627,28629,28684,28714,28884,28911,28925,28998,28999,29024,29061,29082,29083,29084,29085,29086,29087,29088,29089,29090,29091,29092,29113,29114,29147,29175,29176,29243,29300,29330,29331,29424,29464,29481,29482,29483,29555,29649,29650,29651,29652,29695,29763,29801,29815,29816,29817,29818,29819,29820,29821,29822,29845,29899,29901,29903,29985,29997,29998,30062,30158,30159,30160,30161,30162,30247,30307,30308,30333,30490,30521,30522,30548,30549,30562,30578,30625,30763,30791,30792,30876,30897,30995,31030,31031,31127,31129,31269,31334,31335,31338,31468,31469,31471,31575,31576,31577,31735,31765,31906,31953,31954,31955,31956,31981,31994,31995,32103,32104,32105,32159,32250,32251,32252,32253,32254,32255,32347,32349,32350,32423,32530,32531,32641,32642,32970,32973,32986,33011,33039,33047,33048,33049,33071,33096,33097,33098,33100,33101,33102,33113,33194,33195,33235,33318,33341,33348,33349,33410,33413,33414,33498,33505,33506,33513,33519,33594,33635,33636,33646,33654,33679,33754,33755,34052,34060,34235,34312,34412,34845,34858,34859,34915,34916,34928,34985,35037,35229,35232,35236,35321,35335,35361,35376,35505,35522,35545,35638,35639,35673,35771,35797,36156,36202,36238,36318,36488,36575,36677,36678,36713,36807,36812,36916,36918,36935,36937,36976,37061,37080,37099,37104,38710,38717,38731,38773,38777,38778,38786,38787,38803,38828,38879,38880,38881,38882,38884,38885,38886,38887,38888,38920,39311,39337,39410,39450,39531,39532,39533,39534,39569,39570,39571,39575,39576,39599,39602,39642,39664,39671,41896,41906,41907,41960,42489,42511,42536,42679,43114,43129,43130,43169,43247,43249,43250,43261,43278,43297,43299,43339,43343,43373,43387,43390,43913,43998,44075,44076,44113,44408,44495,44529,44618,44622,44630,45140,45141,45292,45401,45402,45512,45513,45587,45752,46155,46179,46187,46188,46192,46205,46210,46278,46349,46363,46371,46388,46460,46465,46737,46758,46973,46974,46977,47033,47044,47073,47086,47104,47105,47134,47137,47138,47139,47140,47141,47142,47162,47535,47546,47801,47827,47838,47901,47902,47945,47979,48447,48451,48477,48478,48496,48497,48509,48510,48565,48599,48608,48794,48797,48874,48977,48996,49046,49056,49134,49359,49445,49488,49489,49558,49564,49614,49716,49726,49784,49797,49800,49803,49811,49824,49825,49860,49913,49992,50163,50164,50253,50307,50308,50347,50399,50467,50493,50494,50502,50533,50713,50722,50733,50842,50843,50852,50861,50870,50879,50992,50997,51027,51072,51082,51087,51092,51579,51580,51599,51883,51913,51922,51930,51980,51999,52001,52021,52140,52172,52195,52205,52216,52220,52466,52471,52566,52604,52973,53058,53059,53172,53191,53192,53195,53209,53233,53251,53252,53253,53263,53264,53291,53298,53299,53328,53529,53820,53824,54111,54112,54283,54332,54333,54621,54736,54845,54854,55260,55301,55327,55350,55391,55392,55408,55414,55415,55749,55758,55931,56013,56186,56206,56221,56228,56229,56250,56765,56778,56783,56798,56895,56914,56916,57111,57112,57151,57197,57226,57292,57303,57308,57500,57633,57663,57672,57752,57768,57789,58207,58257,58265,58266,58267,58375,58583,58599,58650,58660,58695,58696,58914,58915,58916,58929,58943,58971,58985,59058,59560,59565,59595,59597,59598,59939,60101,60102,60152,60153,60159,60164,60173,60227,60285,60713,60722,60858,60977,61021,61024,61039,61043,61076,61089,61102,61367,61416,61507,61518,61537,61556,61560,61584,61795,61797,61818,61819,62075,62083,62085,62152,62232,62265,62278,62280,62282,62356,62804,62818,62826,62975,62976,63032,63039,63055,63063,63067,63079,63163,63178,63188,63215,63680,63925,63939,63940,63947,63965,63966,63977,64531,64532,64550,64576,64584,64585,64602,64618,64632,64638,64703,64713,64725,64727,65058,65141,65228,65279,65385,65431,65445,65454,65577,65675,66354,66582,66652,66654,66677,66684,66737,66776,66959,66960,67651,67800,67848,67883,67908,67925,67926,67927,67982,68398,68472,68500,68558,68559,68599,68603,68604,68605,68609,68708,68741,69239,69378,69385,69415,69419,69517,69580,69644,70080,70122,70247,70248,70249,70263,70264,70283,70302,70324,70327,70352,70353,70354,70356,70361,70372,70379,70381,70406,70494,70511,70513,70912,70918,70976,70994,71059,71069,71111,71127,71149,71170,71221,71240,71263,71266,71292,71293,71766,71772,71879,71905,71922,71952,71959,72002,72014,72028,72048,72553,72760,72797,72898,73398,73406,73438,74344,74345,74366,74432,74525,75008,75043,75177,75181,76752,76847,76872,77005,77359,77440,77441,77442,77694,78194,78408,78591,78639,81260,81261,81476,83369,83370,83371,83373,83376,83378,83380,83381,83382,83383,83590,83608,84043,84516,84661,84806,84921,85007,85061,85062,85157,85475,85556,85649,85682,85728,85842,85912,85958,86281,86518,86532,86849,86872,87216,87242,88085,88795,88802,88805,88878,89069,89126,89127,89476,90738,90806,91001,91037,91081,91192,91478,91496,91497,91498,91599,91600,91943,92102,92135,92922,93527,93785,94418,94420,94421,94422,94423,94424,94427,95083,95331,95332,95333,95347,95680,95822,95833,96068,96152,98059,98131,98132,98329,98358,98782,98831,98927,99059,99072,99080,99092,99106,99141,99212,99254,100468,100832,100852,101171,101507,101569,101690,101767,101768,101770,101771,102024,102032,102359,102385,102626,102686,102687,102731,103085,103205,103228,103287,103296,103356,103357,103668,103669,103670,103697,104389,105127,105273,105726,105883,105884,106054,106082,106092,106135,106136,106182,106183,106210,106384,106421,106529,106531,106532,106585,106600,106629,106877,106884,106892,106974,106979,106984,107274,107385,107552,108427,108445,108450,108451,108452,108453,108535,108565,108750,108777,108868,108928,108952,109121,109174,109240,109249,109282,109283,109309,109345,109387,109540,109683,109692,109764,109801,110160,110162,110163,110369,110370,110696,110702,110777,110894,111080,111081,111085,111087,111129,111181,111193,111215,111268,111955,112353,112354,112355,112391,112688,112691,112749,113057,113063,113110,113131,113141,113206,113257,113312,113325,113446,113654,113739,113879,113911,114036,114037,114039,114227,114279,114710,114773,115003,115004,115045,115092,115106,115249,115274,115290,115308,115785,116292,116327,116423,116438,116488,116660,116662,116692,116924,117170,117354,117355,117392,117413,117534,117698,117782,117787,117858,118057,118112,118113,118114,118115,118470,118491,118505,118546,118579,118724,119007,119054,119137,119147,119148,119168,119271,119612,119749,120130,120541,120667,120687,120882,120898,121061,121139,121316,121407,121486,121522,121523,121583,121701,121702,121720,121724,121732,121773,121790,121800,121817,121843,121846,121858,122164,122460,122602,122611,122624,122712,122716,122772,122816,122817,123093,123107,123123,123126,123133,123157,123158,123159,123167,123206,123338,123421,123422,123448,123781,123826,123827,123968,124069,124236,124407,125589,125735,126042,126049,126183,126199,126271,126562,126603,126708,126716,126924,126967,127197,127417,127457,127494,127506,127588,127692,127698,127741,127798,127844,127904,128093,128266,128588,128678,128863,129236,129345,130382,130593,130612,130640,130696,131061,131062,131156,131409,131485,131591,131648,131649,131650,131651,131652,131653,131709,132136,132163,132198,132216,132270,132284,132348,132368,132415,132432,132452,132517,132518,132610,132678,132732,132774,132810,132904,132919,132988,133240,133430,133466,133723,133754,133988,134022,134083,134869,135086,135145,135146,135147,135177,135298,135325,135345,135371,135463,135465,135646,136025,136144,136172,136173,136174,136257,136455,136490,136568,136584,136760,136951,137093,137259,137265,137268,137350,137400,137464,137658,137672,137674,137792,137796,138013,138069,138077,138160,138302,138315,138328,138574,138617,138655,138773,139340,139350,139695,139769,140129,140134,140254,140807,140830,140831,141032,141096,141247,141284,141303,141363,141365,141643,141686,141764,142132,142174,142179,142351,142964,143104,143308,143756,143930,144064,144144,144357,144368,144369,144415,144471,144477,144530,144537,144541,144570,144572,144576,144609,144614,144652,144790,144885,144920,145095,145156,145374,145611,145614,145866,145988,146197,146418,146701,146767,147140,147141,147142,147143,147144,147145,147146,147148,147191,147323,147362,147593,147744,147901,147955,148303,148322,148347,148423,148424,148435,148589,148728,148787,148831,148837,148896,148961,148967,148984,149004,149042,149051,149263,149277,149424,149430,149515,149519,149665,149789,149838,149886,149936,150069,150204,150313,150411,150501,150579,150660,150760,150761,150765,150766,150955,150979,150982,151115,151181,151254,151264,151318,151427,151437,151542,151670,151694,151717,151759,151767,151816,151817,151821,151882,151958,151962,151992,152037,152125,152129,152132,152202,152241,152447,152658,152791,153140,153606,153937,153976,153996,154051,154136,154370,154396,154465,154482,154521,154546,154620,155005,155024,155349,155356,155722,155762,155922,155925,155926,155934,155936,155937,155948,155952,156570,156677,156678,156794,156857,156860,157006,157007,157033,157153,157182,157473,157650,157651,157819,157927,157997,158026,158271,158272,158273,158368,158713,158714,158794,158847,158889,159126,159351,159456,159457,159695,159875,160003,160004,160081,160241,160269,160386,161035,162267,162274,162275,162369,162370,162411,162418,162423,162466,162732,162739,162838,162839,163134,163391,163394,163742,163750,163796,163797,163802,163810,163855,163994,164077,164268,164269,164357,164452,164975,164977,164999,165075,165133,165240,165491,165492,165561,165679,165744,165893,165912,165957,166010,166126,166219,166382,166393,166677,166693,166820,166838,166908,166925,167110,167822,167881,167883,167885,167960,168183,168646,168725,168760,168904,169062,169120,169235,169496,169497,169590,169591,169635,169638,169640,169641,169642,169646,169650,169898,170079,170084,170089,170254,170255,170345,170355,170613,171096,171189,171303,171348,171395,171406,171444,171573,172052,172070,172085,172170,172326,172374,172377,172379,172380,172867,173086,173150,173317,173505,173657,173945,173964,174183,174287,174426,174436,174437,174472,174473,174716,174738,174743,174940,174956,175202,175432,175580,175806,175863,175866,175869,175870,175964,176050,176109,176163,176189,176242,176287,176601,176923,176942,177020,177202,177236,177423,177464,177532,177586,177727,177771,177792,177801,177991,178330,178425,178429,178431,178483,178545,178630,178631,179175,179441,179710,179711,179738,179976,179998,180080,180084,180166,180191,180197,180672,180799,180815,180909,180910,180945,181035,181138,181141,181143,181147,181169,181276,181282,181352,181359,181362,181397,181512,181514,181515,181667,181676,181784,181883,181911,182061,182209,182212,182990,183085,183260,183289,183335,183363,183381,183640,183837,183854,183889,183911,183985,183987,184108,184734,185192,185321,185496,185584,185655,185661,185685,185697,185817,185896,185948,185977,186005,186043,186256,186281,186410,186816,186831,186846,186967,186999,187095,187238,187377,188053,188209,188410,188452,188550,188797,188848,188980,189079,189270,189380,189394,189439,189670,189688,189952,190144,190299,190353,190415,190665,190708,191048,191310,191418,191547,191923,192002,192336,192342,192437,192468,192835,193188,193385,193389,193856,193869,194060,194307,195242,195327,195587,195721,196829,197553,197880,198290) GROUP BY sold_week ORDER BY scs.date_actual_sold |
77 | Creole | executeQuery(): [16.13 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 (21076,21181,21253,21368,21652,21756,21986,21987,22186,22693,22794,23839,23847,23848,23903,24135,24470,24783,24785,24832,24926,24927,24958,24970,25067,25109,25206,25429,25493,25503,25566,25711,25712,25727,25741,25872,25939,25944,26019,26031,26187,26205,26207,26294,26297,26353,26361,26362,26706,26707,26955,27165,27500,27600,27779,27891,27892,27909,27910,27936,27972,27982,27995,28102,28191,28192,28209,28353,28470,28627,28629,28684,28714,28884,28911,28925,28998,28999,29024,29061,29082,29083,29084,29085,29086,29087,29088,29089,29090,29091,29092,29113,29114,29147,29175,29176,29243,29300,29330,29331,29424,29464,29481,29482,29483,29555,29649,29650,29651,29652,29695,29763,29801,29815,29816,29817,29818,29819,29820,29821,29822,29845,29899,29901,29903,29985,29997,29998,30062,30158,30159,30160,30161,30162,30247,30307,30308,30333,30490,30521,30522,30548,30549,30562,30578,30625,30763,30791,30792,30876,30897,30995,31030,31031,31127,31129,31269,31334,31335,31338,31468,31469,31471,31575,31576,31577,31735,31765,31906,31953,31954,31955,31956,31981,31994,31995,32103,32104,32105,32159,32250,32251,32252,32253,32254,32255,32347,32349,32350,32423,32530,32531,32641,32642,32970,32973,32986,33011,33039,33047,33048,33049,33071,33096,33097,33098,33100,33101,33102,33113,33194,33195,33235,33318,33341,33348,33349,33410,33413,33414,33498,33505,33506,33513,33519,33594,33635,33636,33646,33654,33679,33754,33755,34052,34060,34235,34312,34412,34845,34858,34859,34915,34916,34928,34985,35037,35229,35232,35236,35321,35335,35361,35376,35505,35522,35545,35638,35639,35673,35771,35797,36156,36202,36238,36318,36488,36575,36677,36678,36713,36807,36812,36916,36918,36935,36937,36976,37061,37080,37099,37104,38710,38717,38731,38773,38777,38778,38786,38787,38803,38828,38879,38880,38881,38882,38884,38885,38886,38887,38888,38920,39311,39337,39410,39450,39531,39532,39533,39534,39569,39570,39571,39575,39576,39599,39602,39642,39664,39671,41896,41906,41907,41960,42489,42511,42536,42679,43114,43129,43130,43169,43247,43249,43250,43261,43278,43297,43299,43339,43343,43373,43387,43390,43913,43998,44075,44076,44113,44408,44495,44529,44618,44622,44630,45140,45141,45292,45401,45402,45512,45513,45587,45752,46155,46179,46187,46188,46192,46205,46210,46278,46349,46363,46371,46388,46460,46465,46737,46758,46973,46974,46977,47033,47044,47073,47086,47104,47105,47134,47137,47138,47139,47140,47141,47142,47162,47535,47546,47801,47827,47838,47901,47902,47945,47979,48447,48451,48477,48478,48496,48497,48509,48510,48565,48599,48608,48794,48797,48874,48977,48996,49046,49056,49134,49359,49445,49488,49489,49558,49564,49614,49716,49726,49784,49797,49800,49803,49811,49824,49825,49860,49913,49992,50163,50164,50253,50307,50308,50347,50399,50467,50493,50494,50502,50533,50713,50722,50733,50842,50843,50852,50861,50870,50879,50992,50997,51027,51072,51082,51087,51092,51579,51580,51599,51883,51913,51922,51930,51980,51999,52001,52021,52140,52172,52195,52205,52216,52220,52466,52471,52566,52604,52973,53058,53059,53172,53191,53192,53195,53209,53233,53251,53252,53253,53263,53264,53291,53298,53299,53328,53529,53820,53824,54111,54112,54283,54332,54333,54621,54736,54845,54854,55260,55301,55327,55350,55391,55392,55408,55414,55415,55749,55758,55931,56013,56186,56206,56221,56228,56229,56250,56765,56778,56783,56798,56895,56914,56916,57111,57112,57151,57197,57226,57292,57303,57308,57500,57633,57663,57672,57752,57768,57789,58207,58257,58265,58266,58267,58375,58583,58599,58650,58660,58695,58696,58914,58915,58916,58929,58943,58971,58985,59058,59560,59565,59595,59597,59598,59939,60101,60102,60152,60153,60159,60164,60173,60227,60285,60713,60722,60858,60977,61021,61024,61039,61043,61076,61089,61102,61367,61416,61507,61518,61537,61556,61560,61584,61795,61797,61818,61819,62075,62083,62085,62152,62232,62265,62278,62280,62282,62356,62804,62818,62826,62975,62976,63032,63039,63055,63063,63067,63079,63163,63178,63188,63215,63680,63925,63939,63940,63947,63965,63966,63977,64531,64532,64550,64576,64584,64585,64602,64618,64632,64638,64703,64713,64725,64727,65058,65141,65228,65279,65385,65431,65445,65454,65577,65675,66354,66582,66652,66654,66677,66684,66737,66776,66959,66960,67651,67800,67848,67883,67908,67925,67926,67927,67982,68398,68472,68500,68558,68559,68599,68603,68604,68605,68609,68708,68741,69239,69378,69385,69415,69419,69517,69580,69644,70080,70122,70247,70248,70249,70263,70264,70283,70302,70324,70327,70352,70353,70354,70356,70361,70372,70379,70381,70406,70494,70511,70513,70912,70918,70976,70994,71059,71069,71111,71127,71149,71170,71221,71240,71263,71266,71292,71293,71766,71772,71879,71905,71922,71952,71959,72002,72014,72028,72048,72553,72760,72797,72898,73398,73406,73438,74344,74345,74366,74432,74525,75008,75043,75177,75181,76752,76847,76872,77005,77359,77440,77441,77442,77694,78194,78408,78591,78639,81260,81261,81476,83369,83370,83371,83373,83376,83378,83380,83381,83382,83383,83590,83608,84043,84516,84661,84806,84921,85007,85061,85062,85157,85475,85556,85649,85682,85728,85842,85912,85958,86281,86518,86532,86849,86872,87216,87242,88085,88795,88802,88805,88878,89069,89126,89127,89476,90738,90806,91001,91037,91081,91192,91478,91496,91497,91498,91599,91600,91943,92102,92135,92922,93527,93785,94418,94420,94421,94422,94423,94424,94427,95083,95331,95332,95333,95347,95680,95822,95833,96068,96152,98059,98131,98132,98329,98358,98782,98831,98927,99059,99072,99080,99092,99106,99141,99212,99254,100468,100832,100852,101171,101507,101569,101690,101767,101768,101770,101771,102024,102032,102359,102385,102626,102686,102687,102731,103085,103205,103228,103287,103296,103356,103357,103668,103669,103670,103697,104389,105127,105273,105726,105883,105884,106054,106082,106092,106135,106136,106182,106183,106210,106384,106421,106529,106531,106532,106585,106600,106629,106877,106884,106892,106974,106979,106984,107274,107385,107552,108427,108445,108450,108451,108452,108453,108535,108565,108750,108777,108868,108928,108952,109121,109174,109240,109249,109282,109283,109309,109345,109387,109540,109683,109692,109764,109801,110160,110162,110163,110369,110370,110696,110702,110777,110894,111080,111081,111085,111087,111129,111181,111193,111215,111268,111955,112353,112354,112355,112391,112688,112691,112749,113057,113063,113110,113131,113141,113206,113257,113312,113325,113446,113654,113739,113879,113911,114036,114037,114039,114227,114279,114710,114773,115003,115004,115045,115092,115106,115249,115274,115290,115308,115785,116292,116327,116423,116438,116488,116660,116662,116692,116924,117170,117354,117355,117392,117413,117534,117698,117782,117787,117858,118057,118112,118113,118114,118115,118470,118491,118505,118546,118579,118724,119007,119054,119137,119147,119148,119168,119271,119612,119749,120130,120541,120667,120687,120882,120898,121061,121139,121316,121407,121486,121522,121523,121583,121701,121702,121720,121724,121732,121773,121790,121800,121817,121843,121846,121858,122164,122460,122602,122611,122624,122712,122716,122772,122816,122817,123093,123107,123123,123126,123133,123157,123158,123159,123167,123206,123338,123421,123422,123448,123781,123826,123827,123968,124069,124236,124407,125589,125735,126042,126049,126183,126199,126271,126562,126603,126708,126716,126924,126967,127197,127417,127457,127494,127506,127588,127692,127698,127741,127798,127844,127904,128093,128266,128588,128678,128863,129236,129345,130382,130593,130612,130640,130696,131061,131062,131156,131409,131485,131591,131648,131649,131650,131651,131652,131653,131709,132136,132163,132198,132216,132270,132284,132348,132368,132415,132432,132452,132517,132518,132610,132678,132732,132774,132810,132904,132919,132988,133240,133430,133466,133723,133754,133988,134022,134083,134869,135086,135145,135146,135147,135177,135298,135325,135345,135371,135463,135465,135646,136025,136144,136172,136173,136174,136257,136455,136490,136568,136584,136760,136951,137093,137259,137265,137268,137350,137400,137464,137658,137672,137674,137792,137796,138013,138069,138077,138160,138302,138315,138328,138574,138617,138655,138773,139340,139350,139695,139769,140129,140134,140254,140807,140830,140831,141032,141096,141247,141284,141303,141363,141365,141643,141686,141764,142132,142174,142179,142351,142964,143104,143308,143756,143930,144064,144144,144357,144368,144369,144415,144471,144477,144530,144537,144541,144570,144572,144576,144609,144614,144652,144790,144885,144920,145095,145156,145374,145611,145614,145866,145988,146197,146418,146701,146767,147140,147141,147142,147143,147144,147145,147146,147148,147191,147323,147362,147593,147744,147901,147955,148303,148322,148347,148423,148424,148435,148589,148728,148787,148831,148837,148896,148961,148967,148984,149004,149042,149051,149263,149277,149424,149430,149515,149519,149665,149789,149838,149886,149936,150069,150204,150313,150411,150501,150579,150660,150760,150761,150765,150766,150955,150979,150982,151115,151181,151254,151264,151318,151427,151437,151542,151670,151694,151717,151759,151767,151816,151817,151821,151882,151958,151962,151992,152037,152125,152129,152132,152202,152241,152447,152658,152791,153140,153606,153937,153976,153996,154051,154136,154370,154396,154465,154482,154521,154546,154620,155005,155024,155349,155356,155722,155762,155922,155925,155926,155934,155936,155937,155948,155952,156570,156677,156678,156794,156857,156860,157006,157007,157033,157153,157182,157473,157650,157651,157819,157927,157997,158026,158271,158272,158273,158368,158713,158714,158794,158847,158889,159126,159351,159456,159457,159695,159875,160003,160004,160081,160241,160269,160386,161035,162267,162274,162275,162369,162370,162411,162418,162423,162466,162732,162739,162838,162839,163134,163391,163394,163742,163750,163796,163797,163802,163810,163855,163994,164077,164268,164269,164357,164452,164975,164977,164999,165075,165133,165240,165491,165492,165561,165679,165744,165893,165912,165957,166010,166126,166219,166382,166393,166677,166693,166820,166838,166908,166925,167110,167822,167881,167883,167885,167960,168183,168646,168725,168760,168904,169062,169120,169235,169496,169497,169590,169591,169635,169638,169640,169641,169642,169646,169650,169898,170079,170084,170089,170254,170255,170345,170355,170613,171096,171189,171303,171348,171395,171406,171444,171573,172052,172070,172085,172170,172326,172374,172377,172379,172380,172867,173086,173150,173317,173505,173657,173945,173964,174183,174287,174426,174436,174437,174472,174473,174716,174738,174743,174940,174956,175202,175432,175580,175806,175863,175866,175869,175870,175964,176050,176109,176163,176189,176242,176287,176601,176923,176942,177020,177202,177236,177423,177464,177532,177586,177727,177771,177792,177801,177991,178330,178425,178429,178431,178483,178545,178630,178631,179175,179441,179710,179711,179738,179976,179998,180080,180084,180166,180191,180197,180672,180799,180815,180909,180910,180945,181035,181138,181141,181143,181147,181169,181276,181282,181352,181359,181362,181397,181512,181514,181515,181667,181676,181784,181883,181911,182061,182209,182212,182990,183085,183260,183289,183335,183363,183381,183640,183837,183854,183889,183911,183985,183987,184108,184734,185192,185321,185496,185584,185655,185661,185685,185697,185817,185896,185948,185977,186005,186043,186256,186281,186410,186816,186831,186846,186967,186999,187095,187238,187377,188053,188209,188410,188452,188550,188797,188848,188980,189079,189270,189380,189394,189439,189670,189688,189952,190144,190299,190353,190415,190665,190708,191048,191310,191418,191547,191923,192002,192336,192342,192437,192468,192835,193188,193385,193389,193856,193869,194060,194307,195242,195327,195587,195721,196829,197553,197880,198290) 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 (21076,21181,21253,21368,21652,21756,21986,21987,22186,22693,22794,23839,23847,23848,23903,24135,24470,24783,24785,24832,24926,24927,24958,24970,25067,25109,25206,25429,25493,25503,25566,25711,25712,25727,25741,25872,25939,25944,26019,26031,26187,26205,26207,26294,26297,26353,26361,26362,26706,26707,26955,27165,27500,27600,27779,27891,27892,27909,27910,27936,27972,27982,27995,28102,28191,28192,28209,28353,28470,28627,28629,28684,28714,28884,28911,28925,28998,28999,29024,29061,29082,29083,29084,29085,29086,29087,29088,29089,29090,29091,29092,29113,29114,29147,29175,29176,29243,29300,29330,29331,29424,29464,29481,29482,29483,29555,29649,29650,29651,29652,29695,29763,29801,29815,29816,29817,29818,29819,29820,29821,29822,29845,29899,29901,29903,29985,29997,29998,30062,30158,30159,30160,30161,30162,30247,30307,30308,30333,30490,30521,30522,30548,30549,30562,30578,30625,30763,30791,30792,30876,30897,30995,31030,31031,31127,31129,31269,31334,31335,31338,31468,31469,31471,31575,31576,31577,31735,31765,31906,31953,31954,31955,31956,31981,31994,31995,32103,32104,32105,32159,32250,32251,32252,32253,32254,32255,32347,32349,32350,32423,32530,32531,32641,32642,32970,32973,32986,33011,33039,33047,33048,33049,33071,33096,33097,33098,33100,33101,33102,33113,33194,33195,33235,33318,33341,33348,33349,33410,33413,33414,33498,33505,33506,33513,33519,33594,33635,33636,33646,33654,33679,33754,33755,34052,34060,34235,34312,34412,34845,34858,34859,34915,34916,34928,34985,35037,35229,35232,35236,35321,35335,35361,35376,35505,35522,35545,35638,35639,35673,35771,35797,36156,36202,36238,36318,36488,36575,36677,36678,36713,36807,36812,36916,36918,36935,36937,36976,37061,37080,37099,37104,38710,38717,38731,38773,38777,38778,38786,38787,38803,38828,38879,38880,38881,38882,38884,38885,38886,38887,38888,38920,39311,39337,39410,39450,39531,39532,39533,39534,39569,39570,39571,39575,39576,39599,39602,39642,39664,39671,41896,41906,41907,41960,42489,42511,42536,42679,43114,43129,43130,43169,43247,43249,43250,43261,43278,43297,43299,43339,43343,43373,43387,43390,43913,43998,44075,44076,44113,44408,44495,44529,44618,44622,44630,45140,45141,45292,45401,45402,45512,45513,45587,45752,46155,46179,46187,46188,46192,46205,46210,46278,46349,46363,46371,46388,46460,46465,46737,46758,46973,46974,46977,47033,47044,47073,47086,47104,47105,47134,47137,47138,47139,47140,47141,47142,47162,47535,47546,47801,47827,47838,47901,47902,47945,47979,48447,48451,48477,48478,48496,48497,48509,48510,48565,48599,48608,48794,48797,48874,48977,48996,49046,49056,49134,49359,49445,49488,49489,49558,49564,49614,49716,49726,49784,49797,49800,49803,49811,49824,49825,49860,49913,49992,50163,50164,50253,50307,50308,50347,50399,50467,50493,50494,50502,50533,50713,50722,50733,50842,50843,50852,50861,50870,50879,50992,50997,51027,51072,51082,51087,51092,51579,51580,51599,51883,51913,51922,51930,51980,51999,52001,52021,52140,52172,52195,52205,52216,52220,52466,52471,52566,52604,52973,53058,53059,53172,53191,53192,53195,53209,53233,53251,53252,53253,53263,53264,53291,53298,53299,53328,53529,53820,53824,54111,54112,54283,54332,54333,54621,54736,54845,54854,55260,55301,55327,55350,55391,55392,55408,55414,55415,55749,55758,55931,56013,56186,56206,56221,56228,56229,56250,56765,56778,56783,56798,56895,56914,56916,57111,57112,57151,57197,57226,57292,57303,57308,57500,57633,57663,57672,57752,57768,57789,58207,58257,58265,58266,58267,58375,58583,58599,58650,58660,58695,58696,58914,58915,58916,58929,58943,58971,58985,59058,59560,59565,59595,59597,59598,59939,60101,60102,60152,60153,60159,60164,60173,60227,60285,60713,60722,60858,60977,61021,61024,61039,61043,61076,61089,61102,61367,61416,61507,61518,61537,61556,61560,61584,61795,61797,61818,61819,62075,62083,62085,62152,62232,62265,62278,62280,62282,62356,62804,62818,62826,62975,62976,63032,63039,63055,63063,63067,63079,63163,63178,63188,63215,63680,63925,63939,63940,63947,63965,63966,63977,64531,64532,64550,64576,64584,64585,64602,64618,64632,64638,64703,64713,64725,64727,65058,65141,65228,65279,65385,65431,65445,65454,65577,65675,66354,66582,66652,66654,66677,66684,66737,66776,66959,66960,67651,67800,67848,67883,67908,67925,67926,67927,67982,68398,68472,68500,68558,68559,68599,68603,68604,68605,68609,68708,68741,69239,69378,69385,69415,69419,69517,69580,69644,70080,70122,70247,70248,70249,70263,70264,70283,70302,70324,70327,70352,70353,70354,70356,70361,70372,70379,70381,70406,70494,70511,70513,70912,70918,70976,70994,71059,71069,71111,71127,71149,71170,71221,71240,71263,71266,71292,71293,71766,71772,71879,71905,71922,71952,71959,72002,72014,72028,72048,72553,72760,72797,72898,73398,73406,73438,74344,74345,74366,74432,74525,75008,75043,75177,75181,76752,76847,76872,77005,77359,77440,77441,77442,77694,78194,78408,78591,78639,81260,81261,81476,83369,83370,83371,83373,83376,83378,83380,83381,83382,83383,83590,83608,84043,84516,84661,84806,84921,85007,85061,85062,85157,85475,85556,85649,85682,85728,85842,85912,85958,86281,86518,86532,86849,86872,87216,87242,88085,88795,88802,88805,88878,89069,89126,89127,89476,90738,90806,91001,91037,91081,91192,91478,91496,91497,91498,91599,91600,91943,92102,92135,92922,93527,93785,94418,94420,94421,94422,94423,94424,94427,95083,95331,95332,95333,95347,95680,95822,95833,96068,96152,98059,98131,98132,98329,98358,98782,98831,98927,99059,99072,99080,99092,99106,99141,99212,99254,100468,100832,100852,101171,101507,101569,101690,101767,101768,101770,101771,102024,102032,102359,102385,102626,102686,102687,102731,103085,103205,103228,103287,103296,103356,103357,103668,103669,103670,103697,104389,105127,105273,105726,105883,105884,106054,106082,106092,106135,106136,106182,106183,106210,106384,106421,106529,106531,106532,106585,106600,106629,106877,106884,106892,106974,106979,106984,107274,107385,107552,108427,108445,108450,108451,108452,108453,108535,108565,108750,108777,108868,108928,108952,109121,109174,109240,109249,109282,109283,109309,109345,109387,109540,109683,109692,109764,109801,110160,110162,110163,110369,110370,110696,110702,110777,110894,111080,111081,111085,111087,111129,111181,111193,111215,111268,111955,112353,112354,112355,112391,112688,112691,112749,113057,113063,113110,113131,113141,113206,113257,113312,113325,113446,113654,113739,113879,113911,114036,114037,114039,114227,114279,114710,114773,115003,115004,115045,115092,115106,115249,115274,115290,115308,115785,116292,116327,116423,116438,116488,116660,116662,116692,116924,117170,117354,117355,117392,117413,117534,117698,117782,117787,117858,118057,118112,118113,118114,118115,118470,118491,118505,118546,118579,118724,119007,119054,119137,119147,119148,119168,119271,119612,119749,120130,120541,120667,120687,120882,120898,121061,121139,121316,121407,121486,121522,121523,121583,121701,121702,121720,121724,121732,121773,121790,121800,121817,121843,121846,121858,122164,122460,122602,122611,122624,122712,122716,122772,122816,122817,123093,123107,123123,123126,123133,123157,123158,123159,123167,123206,123338,123421,123422,123448,123781,123826,123827,123968,124069,124236,124407,125589,125735,126042,126049,126183,126199,126271,126562,126603,126708,126716,126924,126967,127197,127417,127457,127494,127506,127588,127692,127698,127741,127798,127844,127904,128093,128266,128588,128678,128863,129236,129345,130382,130593,130612,130640,130696,131061,131062,131156,131409,131485,131591,131648,131649,131650,131651,131652,131653,131709,132136,132163,132198,132216,132270,132284,132348,132368,132415,132432,132452,132517,132518,132610,132678,132732,132774,132810,132904,132919,132988,133240,133430,133466,133723,133754,133988,134022,134083,134869,135086,135145,135146,135147,135177,135298,135325,135345,135371,135463,135465,135646,136025,136144,136172,136173,136174,136257,136455,136490,136568,136584,136760,136951,137093,137259,137265,137268,137350,137400,137464,137658,137672,137674,137792,137796,138013,138069,138077,138160,138302,138315,138328,138574,138617,138655,138773,139340,139350,139695,139769,140129,140134,140254,140807,140830,140831,141032,141096,141247,141284,141303,141363,141365,141643,141686,141764,142132,142174,142179,142351,142964,143104,143308,143756,143930,144064,144144,144357,144368,144369,144415,144471,144477,144530,144537,144541,144570,144572,144576,144609,144614,144652,144790,144885,144920,145095,145156,145374,145611,145614,145866,145988,146197,146418,146701,146767,147140,147141,147142,147143,147144,147145,147146,147148,147191,147323,147362,147593,147744,147901,147955,148303,148322,148347,148423,148424,148435,148589,148728,148787,148831,148837,148896,148961,148967,148984,149004,149042,149051,149263,149277,149424,149430,149515,149519,149665,149789,149838,149886,149936,150069,150204,150313,150411,150501,150579,150660,150760,150761,150765,150766,150955,150979,150982,151115,151181,151254,151264,151318,151427,151437,151542,151670,151694,151717,151759,151767,151816,151817,151821,151882,151958,151962,151992,152037,152125,152129,152132,152202,152241,152447,152658,152791,153140,153606,153937,153976,153996,154051,154136,154370,154396,154465,154482,154521,154546,154620,155005,155024,155349,155356,155722,155762,155922,155925,155926,155934,155936,155937,155948,155952,156570,156677,156678,156794,156857,156860,157006,157007,157033,157153,157182,157473,157650,157651,157819,157927,157997,158026,158271,158272,158273,158368,158713,158714,158794,158847,158889,159126,159351,159456,159457,159695,159875,160003,160004,160081,160241,160269,160386,161035,162267,162274,162275,162369,162370,162411,162418,162423,162466,162732,162739,162838,162839,163134,163391,163394,163742,163750,163796,163797,163802,163810,163855,163994,164077,164268,164269,164357,164452,164975,164977,164999,165075,165133,165240,165491,165492,165561,165679,165744,165893,165912,165957,166010,166126,166219,166382,166393,166677,166693,166820,166838,166908,166925,167110,167822,167881,167883,167885,167960,168183,168646,168725,168760,168904,169062,169120,169235,169496,169497,169590,169591,169635,169638,169640,169641,169642,169646,169650,169898,170079,170084,170089,170254,170255,170345,170355,170613,171096,171189,171303,171348,171395,171406,171444,171573,172052,172070,172085,172170,172326,172374,172377,172379,172380,172867,173086,173150,173317,173505,173657,173945,173964,174183,174287,174426,174436,174437,174472,174473,174716,174738,174743,174940,174956,175202,175432,175580,175806,175863,175866,175869,175870,175964,176050,176109,176163,176189,176242,176287,176601,176923,176942,177020,177202,177236,177423,177464,177532,177586,177727,177771,177792,177801,177991,178330,178425,178429,178431,178483,178545,178630,178631,179175,179441,179710,179711,179738,179976,179998,180080,180084,180166,180191,180197,180672,180799,180815,180909,180910,180945,181035,181138,181141,181143,181147,181169,181276,181282,181352,181359,181362,181397,181512,181514,181515,181667,181676,181784,181883,181911,182061,182209,182212,182990,183085,183260,183289,183335,183363,183381,183640,183837,183854,183889,183911,183985,183987,184108,184734,185192,185321,185496,185584,185655,185661,185685,185697,185817,185896,185948,185977,186005,186043,186256,186281,186410,186816,186831,186846,186967,186999,187095,187238,187377,188053,188209,188410,188452,188550,188797,188848,188980,189079,189270,189380,189394,189439,189670,189688,189952,190144,190299,190353,190415,190665,190708,191048,191310,191418,191547,191923,192002,192336,192342,192437,192468,192835,193188,193385,193389,193856,193869,194060,194307,195242,195327,195587,195721,196829,197553,197880,198290) GROUP BY sold_month ORDER BY scs.date_actual_sold |
79 | Creole | executeQuery(): [22.51 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 (21076,21181,21253,21368,21652,21756,21986,21987,22186,22693,22794,23839,23847,23848,23903,24135,24470,24783,24785,24832,24926,24927,24958,24970,25067,25109,25206,25429,25493,25503,25566,25711,25712,25727,25741,25872,25939,25944,26019,26031,26187,26205,26207,26294,26297,26353,26361,26362,26706,26707,26955,27165,27500,27600,27779,27891,27892,27909,27910,27936,27972,27982,27995,28102,28191,28192,28209,28353,28470,28627,28629,28684,28714,28884,28911,28925,28998,28999,29024,29061,29082,29083,29084,29085,29086,29087,29088,29089,29090,29091,29092,29113,29114,29147,29175,29176,29243,29300,29330,29331,29424,29464,29481,29482,29483,29555,29649,29650,29651,29652,29695,29763,29801,29815,29816,29817,29818,29819,29820,29821,29822,29845,29899,29901,29903,29985,29997,29998,30062,30158,30159,30160,30161,30162,30247,30307,30308,30333,30490,30521,30522,30548,30549,30562,30578,30625,30763,30791,30792,30876,30897,30995,31030,31031,31127,31129,31269,31334,31335,31338,31468,31469,31471,31575,31576,31577,31735,31765,31906,31953,31954,31955,31956,31981,31994,31995,32103,32104,32105,32159,32250,32251,32252,32253,32254,32255,32347,32349,32350,32423,32530,32531,32641,32642,32970,32973,32986,33011,33039,33047,33048,33049,33071,33096,33097,33098,33100,33101,33102,33113,33194,33195,33235,33318,33341,33348,33349,33410,33413,33414,33498,33505,33506,33513,33519,33594,33635,33636,33646,33654,33679,33754,33755,34052,34060,34235,34312,34412,34845,34858,34859,34915,34916,34928,34985,35037,35229,35232,35236,35321,35335,35361,35376,35505,35522,35545,35638,35639,35673,35771,35797,36156,36202,36238,36318,36488,36575,36677,36678,36713,36807,36812,36916,36918,36935,36937,36976,37061,37080,37099,37104,38710,38717,38731,38773,38777,38778,38786,38787,38803,38828,38879,38880,38881,38882,38884,38885,38886,38887,38888,38920,39311,39337,39410,39450,39531,39532,39533,39534,39569,39570,39571,39575,39576,39599,39602,39642,39664,39671,41896,41906,41907,41960,42489,42511,42536,42679,43114,43129,43130,43169,43247,43249,43250,43261,43278,43297,43299,43339,43343,43373,43387,43390,43913,43998,44075,44076,44113,44408,44495,44529,44618,44622,44630,45140,45141,45292,45401,45402,45512,45513,45587,45752,46155,46179,46187,46188,46192,46205,46210,46278,46349,46363,46371,46388,46460,46465,46737,46758,46973,46974,46977,47033,47044,47073,47086,47104,47105,47134,47137,47138,47139,47140,47141,47142,47162,47535,47546,47801,47827,47838,47901,47902,47945,47979,48447,48451,48477,48478,48496,48497,48509,48510,48565,48599,48608,48794,48797,48874,48977,48996,49046,49056,49134,49359,49445,49488,49489,49558,49564,49614,49716,49726,49784,49797,49800,49803,49811,49824,49825,49860,49913,49992,50163,50164,50253,50307,50308,50347,50399,50467,50493,50494,50502,50533,50713,50722,50733,50842,50843,50852,50861,50870,50879,50992,50997,51027,51072,51082,51087,51092,51579,51580,51599,51883,51913,51922,51930,51980,51999,52001,52021,52140,52172,52195,52205,52216,52220,52466,52471,52566,52604,52973,53058,53059,53172,53191,53192,53195,53209,53233,53251,53252,53253,53263,53264,53291,53298,53299,53328,53529,53820,53824,54111,54112,54283,54332,54333,54621,54736,54845,54854,55260,55301,55327,55350,55391,55392,55408,55414,55415,55749,55758,55931,56013,56186,56206,56221,56228,56229,56250,56765,56778,56783,56798,56895,56914,56916,57111,57112,57151,57197,57226,57292,57303,57308,57500,57633,57663,57672,57752,57768,57789,58207,58257,58265,58266,58267,58375,58583,58599,58650,58660,58695,58696,58914,58915,58916,58929,58943,58971,58985,59058,59560,59565,59595,59597,59598,59939,60101,60102,60152,60153,60159,60164,60173,60227,60285,60713,60722,60858,60977,61021,61024,61039,61043,61076,61089,61102,61367,61416,61507,61518,61537,61556,61560,61584,61795,61797,61818,61819,62075,62083,62085,62152,62232,62265,62278,62280,62282,62356,62804,62818,62826,62975,62976,63032,63039,63055,63063,63067,63079,63163,63178,63188,63215,63680,63925,63939,63940,63947,63965,63966,63977,64531,64532,64550,64576,64584,64585,64602,64618,64632,64638,64703,64713,64725,64727,65058,65141,65228,65279,65385,65431,65445,65454,65577,65675,66354,66582,66652,66654,66677,66684,66737,66776,66959,66960,67651,67800,67848,67883,67908,67925,67926,67927,67982,68398,68472,68500,68558,68559,68599,68603,68604,68605,68609,68708,68741,69239,69378,69385,69415,69419,69517,69580,69644,70080,70122,70247,70248,70249,70263,70264,70283,70302,70324,70327,70352,70353,70354,70356,70361,70372,70379,70381,70406,70494,70511,70513,70912,70918,70976,70994,71059,71069,71111,71127,71149,71170,71221,71240,71263,71266,71292,71293,71766,71772,71879,71905,71922,71952,71959,72002,72014,72028,72048,72553,72760,72797,72898,73398,73406,73438,74344,74345,74366,74432,74525,75008,75043,75177,75181,76752,76847,76872,77005,77359,77440,77441,77442,77694,78194,78408,78591,78639,81260,81261,81476,83369,83370,83371,83373,83376,83378,83380,83381,83382,83383,83590,83608,84043,84516,84661,84806,84921,85007,85061,85062,85157,85475,85556,85649,85682,85728,85842,85912,85958,86281,86518,86532,86849,86872,87216,87242,88085,88795,88802,88805,88878,89069,89126,89127,89476,90738,90806,91001,91037,91081,91192,91478,91496,91497,91498,91599,91600,91943,92102,92135,92922,93527,93785,94418,94420,94421,94422,94423,94424,94427,95083,95331,95332,95333,95347,95680,95822,95833,96068,96152,98059,98131,98132,98329,98358,98782,98831,98927,99059,99072,99080,99092,99106,99141,99212,99254,100468,100832,100852,101171,101507,101569,101690,101767,101768,101770,101771,102024,102032,102359,102385,102626,102686,102687,102731,103085,103205,103228,103287,103296,103356,103357,103668,103669,103670,103697,104389,105127,105273,105726,105883,105884,106054,106082,106092,106135,106136,106182,106183,106210,106384,106421,106529,106531,106532,106585,106600,106629,106877,106884,106892,106974,106979,106984,107274,107385,107552,108427,108445,108450,108451,108452,108453,108535,108565,108750,108777,108868,108928,108952,109121,109174,109240,109249,109282,109283,109309,109345,109387,109540,109683,109692,109764,109801,110160,110162,110163,110369,110370,110696,110702,110777,110894,111080,111081,111085,111087,111129,111181,111193,111215,111268,111955,112353,112354,112355,112391,112688,112691,112749,113057,113063,113110,113131,113141,113206,113257,113312,113325,113446,113654,113739,113879,113911,114036,114037,114039,114227,114279,114710,114773,115003,115004,115045,115092,115106,115249,115274,115290,115308,115785,116292,116327,116423,116438,116488,116660,116662,116692,116924,117170,117354,117355,117392,117413,117534,117698,117782,117787,117858,118057,118112,118113,118114,118115,118470,118491,118505,118546,118579,118724,119007,119054,119137,119147,119148,119168,119271,119612,119749,120130,120541,120667,120687,120882,120898,121061,121139,121316,121407,121486,121522,121523,121583,121701,121702,121720,121724,121732,121773,121790,121800,121817,121843,121846,121858,122164,122460,122602,122611,122624,122712,122716,122772,122816,122817,123093,123107,123123,123126,123133,123157,123158,123159,123167,123206,123338,123421,123422,123448,123781,123826,123827,123968,124069,124236,124407,125589,125735,126042,126049,126183,126199,126271,126562,126603,126708,126716,126924,126967,127197,127417,127457,127494,127506,127588,127692,127698,127741,127798,127844,127904,128093,128266,128588,128678,128863,129236,129345,130382,130593,130612,130640,130696,131061,131062,131156,131409,131485,131591,131648,131649,131650,131651,131652,131653,131709,132136,132163,132198,132216,132270,132284,132348,132368,132415,132432,132452,132517,132518,132610,132678,132732,132774,132810,132904,132919,132988,133240,133430,133466,133723,133754,133988,134022,134083,134869,135086,135145,135146,135147,135177,135298,135325,135345,135371,135463,135465,135646,136025,136144,136172,136173,136174,136257,136455,136490,136568,136584,136760,136951,137093,137259,137265,137268,137350,137400,137464,137658,137672,137674,137792,137796,138013,138069,138077,138160,138302,138315,138328,138574,138617,138655,138773,139340,139350,139695,139769,140129,140134,140254,140807,140830,140831,141032,141096,141247,141284,141303,141363,141365,141643,141686,141764,142132,142174,142179,142351,142964,143104,143308,143756,143930,144064,144144,144357,144368,144369,144415,144471,144477,144530,144537,144541,144570,144572,144576,144609,144614,144652,144790,144885,144920,145095,145156,145374,145611,145614,145866,145988,146197,146418,146701,146767,147140,147141,147142,147143,147144,147145,147146,147148,147191,147323,147362,147593,147744,147901,147955,148303,148322,148347,148423,148424,148435,148589,148728,148787,148831,148837,148896,148961,148967,148984,149004,149042,149051,149263,149277,149424,149430,149515,149519,149665,149789,149838,149886,149936,150069,150204,150313,150411,150501,150579,150660,150760,150761,150765,150766,150955,150979,150982,151115,151181,151254,151264,151318,151427,151437,151542,151670,151694,151717,151759,151767,151816,151817,151821,151882,151958,151962,151992,152037,152125,152129,152132,152202,152241,152447,152658,152791,153140,153606,153937,153976,153996,154051,154136,154370,154396,154465,154482,154521,154546,154620,155005,155024,155349,155356,155722,155762,155922,155925,155926,155934,155936,155937,155948,155952,156570,156677,156678,156794,156857,156860,157006,157007,157033,157153,157182,157473,157650,157651,157819,157927,157997,158026,158271,158272,158273,158368,158713,158714,158794,158847,158889,159126,159351,159456,159457,159695,159875,160003,160004,160081,160241,160269,160386,161035,162267,162274,162275,162369,162370,162411,162418,162423,162466,162732,162739,162838,162839,163134,163391,163394,163742,163750,163796,163797,163802,163810,163855,163994,164077,164268,164269,164357,164452,164975,164977,164999,165075,165133,165240,165491,165492,165561,165679,165744,165893,165912,165957,166010,166126,166219,166382,166393,166677,166693,166820,166838,166908,166925,167110,167822,167881,167883,167885,167960,168183,168646,168725,168760,168904,169062,169120,169235,169496,169497,169590,169591,169635,169638,169640,169641,169642,169646,169650,169898,170079,170084,170089,170254,170255,170345,170355,170613,171096,171189,171303,171348,171395,171406,171444,171573,172052,172070,172085,172170,172326,172374,172377,172379,172380,172867,173086,173150,173317,173505,173657,173945,173964,174183,174287,174426,174436,174437,174472,174473,174716,174738,174743,174940,174956,175202,175432,175580,175806,175863,175866,175869,175870,175964,176050,176109,176163,176189,176242,176287,176601,176923,176942,177020,177202,177236,177423,177464,177532,177586,177727,177771,177792,177801,177991,178330,178425,178429,178431,178483,178545,178630,178631,179175,179441,179710,179711,179738,179976,179998,180080,180084,180166,180191,180197,180672,180799,180815,180909,180910,180945,181035,181138,181141,181143,181147,181169,181276,181282,181352,181359,181362,181397,181512,181514,181515,181667,181676,181784,181883,181911,182061,182209,182212,182990,183085,183260,183289,183335,183363,183381,183640,183837,183854,183889,183911,183985,183987,184108,184734,185192,185321,185496,185584,185655,185661,185685,185697,185817,185896,185948,185977,186005,186043,186256,186281,186410,186816,186831,186846,186967,186999,187095,187238,187377,188053,188209,188410,188452,188550,188797,188848,188980,189079,189270,189380,189394,189439,189670,189688,189952,190144,190299,190353,190415,190665,190708,191048,191310,191418,191547,191923,192002,192336,192342,192437,192468,192835,193188,193385,193389,193856,193869,194060,194307,195242,195327,195587,195721,196829,197553,197880,198290) 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(): [1976.78 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(): [0.60 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199964 |
108 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
109 | Creole | executeQuery(): [0.50 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199915 |
110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
111 | Creole | executeQuery(): [0.68 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199861 |
112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
113 | Creole | executeQuery(): [0.73 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199832 |
114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
115 | Creole | executeQuery(): [0.50 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199533 |
116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
117 | Creole | executeQuery(): [0.51 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=200010 |
118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
119 | Creole | executeQuery(): [0.57 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199995 |
120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
121 | Creole | executeQuery(): [0.76 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199976 |
122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
123 | Creole | executeQuery(): [0.63 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199974 |
124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
125 | Creole | executeQuery(): [0.68 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199973 |
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 |
--- parameterHolder: symfony/default: ID_AD: 199775 action: view id: 199775 make: volkswagen model: beetle-typ1 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: 1734971212.1049 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: care_did: ce22da7f-ca52-428f-8ad6-e86664bc1713 env: files: get: post: server: CONTENT_LENGTH: CONTENT_TYPE: DOCUMENT_ROOT: /web/classicdigest.com/web DOCUMENT_URI: /cars/index_dev.php/volkswagen/beetle-typ1/199775 FCGI_ROLE: RESPONDER GATEWAY_INTERFACE: CGI/1.1 HOME: /var/lib/nginx HTTPS: on HTTP_ACCEPT: */* HTTP_ACCEPT_ENCODING: gzip, br, zstd, deflate HTTP_COOKIE: care_did=ce22da7f-ca52-428f-8ad6-e86664bc1713 HTTP_HOST: www.classicdigest.com HTTP_REFERER: https://classicdigest.com/cars/index_dev.php/volkswagen/beetle-typ1/199775 HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) PATH_INFO: /volkswagen/beetle-typ1/199775 PATH_TRANSLATED: /web/classicdigest.com/web/volkswagen/beetle-typ1/199775 PHP_SELF: /cars/index_dev.php/volkswagen/beetle-typ1/199775 QUERY_STRING: REDIRECT_STATUS: 200 REMOTE_ADDR: 18.221.221.171 REMOTE_PORT: 22110 REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1734971212 REQUEST_TIME_FLOAT: 1734971212.1036 REQUEST_URI: /cars/index_dev.php/volkswagen/beetle-typ1/199775 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.52 |
Action "home/view" | 1 | 2212.63 |
Database | 34 | 2153.61 |
View "Success" for "home/view" | 1 | 48.09 |
Partial "home/_vif_images" | 1 | 0.51 |
Partial "common_page/_social_buttons" | 1 | 0.07 |
Partial "home/_vif_info" | 1 | 0.17 |
Partial "home/_hoover_user_info" | 1 | 0.06 |
Partial "common_page/_price_development_graph" | 1 | 0.05 |
Partial "common_page/_sell_time_price_graph" | 1 | 0.04 |
Partial "common_page/_price_gauge_graph" | 1 | 0.04 |
Partial "common_page/_include_vif_js" | 1 | 0.09 |
Partial "common_page/_fancybox_javascript" | 2 | 0.17 |
Partial "common_page/_responsive_javascript" | 1 | 0.05 |
Partial "common_page/_google_analytics" | 1 | 0.04 |
Partial "common_page/_header_links" | 1 | 0.66 |
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.10 |
Partial "common_page/_footer" | 1 | 0.10 |