People who viewed this MG MGB also viewed similar MG 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' => 'mg', 'model' => 'mgb', 'id' => '148441', '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(): [8.32 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=148441 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(): [4.41 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 (1205) |
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(): [4.11 ms] SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car_info.ID, car_info.ID_CAR, car_info.HOOVER_ID, car_info.REG_NO, car_info.SHOW_REG, car_info.ID_CAR_TYPE, car_info.ID_COLOR, car_info.ID_COLOR_TYPE, car_info.AD_CONDITION, car_info.DOCUMENTED_HISTORY, car_info.COMPETITION_HISTORY, car_info.REGISTERED_VEHICLE, car_info.MANUFACTURE_COUNTRY, car_info.DELIVERY_COUNTRY, car_info.GENERAL_DESCRIPTION, car_info.DOCUMENT_DESCRIPTION, car_info.COMPETITION_DESCRIPTION, car_info.TAGS, car_info.YOUTUBE_VID1, car_info.YOUTUBE_VID2, car_info.NOTE, car_info.REMARK, car_info.SHOW_DATE, DATE_ADD(car.DATE_MODIFY,INTERVAL 3 DAY) AS DM FROM car LEFT JOIN car_info ON (car.ID=car_info.ID_CAR) WHERE car.ID=148441 |
38 | Creole | prepareStatement(): SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=? |
39 | Creole | executeQuery(): [5.70 ms] SELECT COUNT(hoover_check.ID) FROM hoover_check WHERE hoover_check.ID_CAR=148441 |
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(): [18.20 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=148441 |
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(): [5.51 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 (1205) |
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(): [1.04 ms] SELECT COUNT(fa_payment_order.ID) FROM fa_payment_order WHERE fa_payment_order.ID_PRODUCT=148441 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(): [2.62 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 (148441) ORDER BY carimg.ORD ASC |
49 | Creole | executeQuery(): [5.46 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 (148441) 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(): [6.48 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 (1205) |
52 | Creole | prepareStatement(): SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=? AND dealer_permission.WHICH=? |
53 | Creole | executeQuery(): [4.15 ms] SELECT COUNT(dealer_permission.ID) FROM dealer_permission WHERE dealer_permission.ID_DEALER=1205 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(): [5.43 ms] SELECT model.ID, model.ID_MAKE, model.MODEL_EN, model.MODEL_DE, model.MODEL_SV, model.DESCRIPTION_EN, model.DESCRIPTION_DE, model.DESCRIPTION_SV, model.COUNTER, model.ORD, model.DATE_CREATE, model.DATE_MODIFY, model.ID_VEHICLE_TYPE, model.ID_DRIVE_TYPE, model.DATE_RANDOM, make.DESCRIPTION_EN AS MAKE_DESC, model.DESCRIPTION_EN AS MODEL_DESC FROM model, make WHERE make.ID=115 AND model.ID=1285 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 != 148441 AND car.ID_MODEL = '1285' ) 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 != 148441 AND car.ID_MODEL = '1285' ) 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 != 148441 AND car.ID_MODEL = '1285' ) 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 != 148441 AND car.ID_MODEL = '1285' ) ) AS count |
58 | Creole | executeQuery(): [10.15 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 != 148441 AND car.ID_MODEL = '1285' ) 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 != 148441 AND car.ID_MODEL = '1285' ) ) 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 != 148441 AND car.ID_MODEL = '1285' ) 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 != 148441 AND car.ID_MODEL = '1285' ) ORDER BY ID DESC, offset: 0, limit: 5 |
60 | Creole | executeQuery(): [16.78 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 != 148441 AND car.ID_MODEL = '1285' ) 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 != 148441 AND car.ID_MODEL = '1285' ) 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 (199610,199268,199087,199021,198664) ORDER BY carimg.ORD ASC |
62 | Creole | executeQuery(): [4.02 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 (199610,199268,199087,199021,198664) 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 != '148441' AND car.ID_NETTI_USER = '1205' ) 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 != '148441' AND car.ID_NETTI_USER = '1205' ) 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 != '148441' AND car.ID_NETTI_USER = '1205' ) 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 != '148441' AND car.ID_NETTI_USER = '1205' ) ) AS count |
65 | Creole | executeQuery(): [2.31 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 != '148441' AND car.ID_NETTI_USER = '1205' ) 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 != '148441' AND car.ID_NETTI_USER = '1205' ) ) 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 != '148441' AND car.ID_NETTI_USER = '1205' ) 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 != '148441' AND car.ID_NETTI_USER = '1205' ) ORDER BY ID DESC, offset: 0, limit: 5 |
67 | Creole | executeQuery(): [9.64 ms] ( SELECT car.ID, car.ID_NETTI_USER, car.ID_MAKE, car.ID_MODEL, car.ID_VEHICLE_TYPE, car.MFG_YEAR, car.MILEAGE, car.ENGINE_SIZE, car.ENGINE_MODEL, car.ID_ACC, car.DEALER_IDENTIFIER, car.CURRENCY, car.PRICE_ASK, car.PRICE_STATUS, car.DRIVE_SIDE, car.FIRST_REG, car.STATUS, car.POSTED_BY, car.STAY_UNKNOWN, car.DATE_CREATE, car.DATE_MODIFY, car.LOCATION, car.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 != '148441' AND car.ID_NETTI_USER = '1205' ) 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 != '148441' AND car.ID_NETTI_USER = '1205' ) 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 (148440,148216,147982,147981,147980) ORDER BY carimg.ORD ASC |
69 | Creole | executeQuery(): [4.62 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 (148440,148216,147982,147981,147980) 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(): [2.55 ms] SELECT car.ID FROM car WHERE car.ID_MAKE=115 AND car.ID_MODEL=1285 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(): [10.00 ms] SELECT sold_car.ID FROM sold_car WHERE sold_car.ID_MAKE=115 AND sold_car.ID_MODEL=1285 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 (20448,20552,21032,21033,24676,25149,25352,31426,31427,31428,36100,89167,98900,100446,116470,123221,123227,123238,123239,123247,123281,123289,123292,124280,126737,126738,127235,129448,130618,131823,134716,134718,134719,134720,134721,134722,134723,134724,134725,134726,134727,134728,134729,134730,134733,134734,134737,135490,135503,135853,135934,136310,139072,139097,139619,140524,142057,142058,142369,142867,142885,142981,144243,148441,148698,148918,151345,151615,152219,152220,152282,154276,155561,156898,162195,165451,165452,165453,165454,165455,165456,166307,168073,168703,172938,173004,174461,174673,174890,174922,176542,177654,178164,178199,179006,179103,179104,179105,179106,179107,179878,180133,180223,180389,180917,181562,181924,182103,182104,182105,182106,182554,182576,183213,184110,184392,184567,184585,184715,185493,185813,185818,188213,188451,188558,188562,188784,188802,188827,188843,189351,189469,190203,190264,190321,190322,190820,190936,191492,192115,192135,193004,193564,193639,193954,194543,194645,195652,195725,196328,197033,197101,197367,197586,197599,197861,198540,198589,198605,198664,199021,199087,199268,199610) GROUP BY cmonth ORDER BY date_create |
75 | Creole | executeQuery(): [3.26 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 (20448,20552,21032,21033,24676,25149,25352,31426,31427,31428,36100,89167,98900,100446,116470,123221,123227,123238,123239,123247,123281,123289,123292,124280,126737,126738,127235,129448,130618,131823,134716,134718,134719,134720,134721,134722,134723,134724,134725,134726,134727,134728,134729,134730,134733,134734,134737,135490,135503,135853,135934,136310,139072,139097,139619,140524,142057,142058,142369,142867,142885,142981,144243,148441,148698,148918,151345,151615,152219,152220,152282,154276,155561,156898,162195,165451,165452,165453,165454,165455,165456,166307,168073,168703,172938,173004,174461,174673,174890,174922,176542,177654,178164,178199,179006,179103,179104,179105,179106,179107,179878,180133,180223,180389,180917,181562,181924,182103,182104,182105,182106,182554,182576,183213,184110,184392,184567,184585,184715,185493,185813,185818,188213,188451,188558,188562,188784,188802,188827,188843,189351,189469,190203,190264,190321,190322,190820,190936,191492,192115,192135,193004,193564,193639,193954,194543,194645,195652,195725,196328,197033,197101,197367,197586,197599,197861,198540,198589,198605,198664,199021,199087,199268,199610) 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 (20320,20333,20334,20338,20340,20349,20357,20374,20378,20446,20556,20747,21512,21580,21762,21824,21874,21881,21933,21988,22415,22416,22423,22425,22432,22436,22438,22439,23303,23382,23384,23465,23670,24061,24071,24075,24081,24082,24084,24085,24086,24994,24998,25009,25010,25044,25052,25068,25076,25080,25097,25099,25104,25105,25112,25242,25679,25787,25888,25889,26032,26034,26131,26132,26363,26364,26365,26451,26577,26769,26770,27362,27363,27374,27461,27496,27508,27583,27862,28070,28988,29166,29761,30302,30484,30576,31024,31075,31713,31714,32331,32512,32830,33050,33129,33130,33131,33132,33333,33531,34619,35247,36154,36260,36261,36262,36573,38822,38823,39526,39614,39687,39715,39743,40356,41984,41994,42575,43025,43026,43337,43887,43917,43996,44418,44526,44826,46171,46184,46185,46783,47051,47108,47858,48163,48379,49072,49128,49920,50149,50532,50829,50841,50913,50927,50937,50960,50972,51957,52470,52967,53161,53726,53788,53795,56002,56101,56139,56260,56516,56800,57130,57385,57506,57608,57797,58261,58685,59011,59067,59552,60188,60261,60335,60336,60337,60581,61019,61160,61192,61648,61852,61885,62264,62323,62335,62458,63907,63908,63934,63960,64057,64416,64555,64674,65235,65576,65671,66445,66616,66771,68583,69306,70041,70120,70376,70401,71279,71949,72092,72609,72759,72846,73598,73772,74231,74354,74395,74526,75338,76037,76190,76717,78626,82550,83046,83559,84040,84647,84982,85196,85245,85925,86139,86471,86644,86805,86859,86883,87413,87414,87415,88770,89168,89361,89507,89570,90757,91071,91102,91993,92786,92897,94383,94384,94520,94983,95611,95612,95722,95810,98210,98443,98444,98454,99027,99050,99098,99102,99109,99413,99466,100585,100733,100748,100893,102437,102441,103030,103260,103442,103457,103632,103633,103634,103635,103636,103849,104360,105327,105697,105707,106022,106196,106424,106589,106631,106783,107025,107136,107150,107270,107374,107428,107468,107494,107553,108323,108328,108477,108478,108846,108872,108962,109096,109325,109327,109329,109893,109936,110355,110438,110559,110560,110623,111190,111340,111341,111342,112157,112762,112796,112819,113159,113210,113528,113580,113745,114012,114083,114138,114238,114269,114315,114486,114576,115007,115088,115546,115730,115742,115896,115897,116360,116380,116545,116661,116793,116934,117000,117733,117820,117867,118079,118153,118540,118545,118757,119093,119143,119325,119895,120346,120698,121218,121420,121584,122168,122248,122643,122648,122650,122781,122838,123048,123215,123228,123257,123259,123268,123272,123274,123276,123712,123776,123837,123952,123954,124271,124402,124405,124406,125318,125733,125772,125779,125802,125885,125962,125993,126073,126480,126550,126675,126676,126943,127173,127174,127219,127360,127539,127606,127630,127659,127754,127843,127940,128032,128046,128065,128102,128276,128278,128305,128558,128677,128679,128694,128936,128937,129164,129220,129252,129582,130062,130063,130064,130106,130942,131145,131326,131495,131825,132349,132367,132739,132965,133056,133181,133234,133276,133540,133976,134199,134717,134731,134732,134735,134736,134738,134739,134740,135713,136006,136206,136207,136564,136685,136834,137266,137289,137383,137563,137855,138076,138081,138634,138644,138785,139014,139120,140212,140646,140870,141357,141683,141959,142121,142348,142408,142487,142509,142514,142517,142530,143607,143737,143921,143993,144141,144527,144638,144785,144929,145061,145153,145295,145375,145379,146041,146148,146155,146156,146175,146182,146253,146254,146255,146256,146257,146258,146426,146545,146676,146720,146725,146729,146849,146850,147050,147361,147467,147598,147650,147673,147793,147864,148039,148046,148068,148111,148150,148203,148224,148419,148426,148436,148563,148568,148622,149283,149410,149472,149631,149662,149757,149885,150027,150087,150185,150311,150663,150897,150938,151030,151221,151222,151245,151261,151332,151432,151657,151766,151810,151813,151878,151885,152075,152221,152566,152579,152597,152750,153093,153278,154015,154050,154159,154164,154446,154542,154561,154584,154701,155020,155132,155261,155369,155377,155440,155912,156212,156321,156596,156597,156598,156802,157137,157379,157575,157699,157705,157733,157848,158037,158263,158264,158295,158319,158388,158411,158412,158468,158645,158681,158760,158860,158892,159064,159239,159240,159722,159795,159801,159815,159881,160001,160002,160113,160651,160882,161813,162046,162120,162294,162410,162445,162565,162570,162590,163038,163039,163040,163165,163205,163373,163374,163436,163439,163672,163673,163955,164005,164115,164131,164134,164298,164329,164489,164608,164727,164767,164805,164859,164900,164901,164902,164994,165008,165111,165540,165578,165648,165649,165931,166424,166426,166505,166579,166588,166692,166837,166875,166988,167201,167255,167837,167944,168345,168420,168550,168882,169293,169295,169311,169312,169348,169349,169362,169724,169739,169938,169939,170040,170202,170308,170449,170461,170679,170945,170976,171080,171228,171275,171391,171471,171514,171710,172013,172279,172605,173092,173121,173194,173276,173450,173628,173958,174055,174592,174601,174750,174888,175099,175194,175199,175205,175290,175384,175396,175399,175416,175568,175569,175859,175862,175922,175961,176034,176135,176152,176365,176462,176613,176616,176727,176756,176832,176861,176892,177022,177072,177073,177074,177299,177429,177433,177533,177558,177648,177676,177986,177994,178115,178430,178542,178543,178765,178769,178983,179420,179536,179644,179655,179684,179826,179910,179973,180511,180512,180663,180704,180767,180789,180840,181280,181309,181393,181663,181710,183040,183314,183332,183342,183344,183353,183736,183737,183738,183739,183740,183741,183951,183952,183953,184406,184416,184793,184826,184946,185009,185021,185028,185174,185219,185346,185347,185483,185566,185567,185718,185760,185869,185969,186193,186524,186536,186773,186867,186929,187024,187025,187110,187407,187529,187659,187694,187773,187792,188010,188182,188367,188599,188619,188734,188950,189115,189376,189746,190250,190277,190402,190440,191389,191471,191544,191545,191561,191708,191768,191849,191986,192095,192325,192339,192391,192429,192595,192612,192833,193230,193695,193697,194579,195405,195454,195499,195567,196703,198171,199161) GROUP BY sold_week ORDER BY scs.date_actual_sold |
77 | Creole | executeQuery(): [15.45 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 (20320,20333,20334,20338,20340,20349,20357,20374,20378,20446,20556,20747,21512,21580,21762,21824,21874,21881,21933,21988,22415,22416,22423,22425,22432,22436,22438,22439,23303,23382,23384,23465,23670,24061,24071,24075,24081,24082,24084,24085,24086,24994,24998,25009,25010,25044,25052,25068,25076,25080,25097,25099,25104,25105,25112,25242,25679,25787,25888,25889,26032,26034,26131,26132,26363,26364,26365,26451,26577,26769,26770,27362,27363,27374,27461,27496,27508,27583,27862,28070,28988,29166,29761,30302,30484,30576,31024,31075,31713,31714,32331,32512,32830,33050,33129,33130,33131,33132,33333,33531,34619,35247,36154,36260,36261,36262,36573,38822,38823,39526,39614,39687,39715,39743,40356,41984,41994,42575,43025,43026,43337,43887,43917,43996,44418,44526,44826,46171,46184,46185,46783,47051,47108,47858,48163,48379,49072,49128,49920,50149,50532,50829,50841,50913,50927,50937,50960,50972,51957,52470,52967,53161,53726,53788,53795,56002,56101,56139,56260,56516,56800,57130,57385,57506,57608,57797,58261,58685,59011,59067,59552,60188,60261,60335,60336,60337,60581,61019,61160,61192,61648,61852,61885,62264,62323,62335,62458,63907,63908,63934,63960,64057,64416,64555,64674,65235,65576,65671,66445,66616,66771,68583,69306,70041,70120,70376,70401,71279,71949,72092,72609,72759,72846,73598,73772,74231,74354,74395,74526,75338,76037,76190,76717,78626,82550,83046,83559,84040,84647,84982,85196,85245,85925,86139,86471,86644,86805,86859,86883,87413,87414,87415,88770,89168,89361,89507,89570,90757,91071,91102,91993,92786,92897,94383,94384,94520,94983,95611,95612,95722,95810,98210,98443,98444,98454,99027,99050,99098,99102,99109,99413,99466,100585,100733,100748,100893,102437,102441,103030,103260,103442,103457,103632,103633,103634,103635,103636,103849,104360,105327,105697,105707,106022,106196,106424,106589,106631,106783,107025,107136,107150,107270,107374,107428,107468,107494,107553,108323,108328,108477,108478,108846,108872,108962,109096,109325,109327,109329,109893,109936,110355,110438,110559,110560,110623,111190,111340,111341,111342,112157,112762,112796,112819,113159,113210,113528,113580,113745,114012,114083,114138,114238,114269,114315,114486,114576,115007,115088,115546,115730,115742,115896,115897,116360,116380,116545,116661,116793,116934,117000,117733,117820,117867,118079,118153,118540,118545,118757,119093,119143,119325,119895,120346,120698,121218,121420,121584,122168,122248,122643,122648,122650,122781,122838,123048,123215,123228,123257,123259,123268,123272,123274,123276,123712,123776,123837,123952,123954,124271,124402,124405,124406,125318,125733,125772,125779,125802,125885,125962,125993,126073,126480,126550,126675,126676,126943,127173,127174,127219,127360,127539,127606,127630,127659,127754,127843,127940,128032,128046,128065,128102,128276,128278,128305,128558,128677,128679,128694,128936,128937,129164,129220,129252,129582,130062,130063,130064,130106,130942,131145,131326,131495,131825,132349,132367,132739,132965,133056,133181,133234,133276,133540,133976,134199,134717,134731,134732,134735,134736,134738,134739,134740,135713,136006,136206,136207,136564,136685,136834,137266,137289,137383,137563,137855,138076,138081,138634,138644,138785,139014,139120,140212,140646,140870,141357,141683,141959,142121,142348,142408,142487,142509,142514,142517,142530,143607,143737,143921,143993,144141,144527,144638,144785,144929,145061,145153,145295,145375,145379,146041,146148,146155,146156,146175,146182,146253,146254,146255,146256,146257,146258,146426,146545,146676,146720,146725,146729,146849,146850,147050,147361,147467,147598,147650,147673,147793,147864,148039,148046,148068,148111,148150,148203,148224,148419,148426,148436,148563,148568,148622,149283,149410,149472,149631,149662,149757,149885,150027,150087,150185,150311,150663,150897,150938,151030,151221,151222,151245,151261,151332,151432,151657,151766,151810,151813,151878,151885,152075,152221,152566,152579,152597,152750,153093,153278,154015,154050,154159,154164,154446,154542,154561,154584,154701,155020,155132,155261,155369,155377,155440,155912,156212,156321,156596,156597,156598,156802,157137,157379,157575,157699,157705,157733,157848,158037,158263,158264,158295,158319,158388,158411,158412,158468,158645,158681,158760,158860,158892,159064,159239,159240,159722,159795,159801,159815,159881,160001,160002,160113,160651,160882,161813,162046,162120,162294,162410,162445,162565,162570,162590,163038,163039,163040,163165,163205,163373,163374,163436,163439,163672,163673,163955,164005,164115,164131,164134,164298,164329,164489,164608,164727,164767,164805,164859,164900,164901,164902,164994,165008,165111,165540,165578,165648,165649,165931,166424,166426,166505,166579,166588,166692,166837,166875,166988,167201,167255,167837,167944,168345,168420,168550,168882,169293,169295,169311,169312,169348,169349,169362,169724,169739,169938,169939,170040,170202,170308,170449,170461,170679,170945,170976,171080,171228,171275,171391,171471,171514,171710,172013,172279,172605,173092,173121,173194,173276,173450,173628,173958,174055,174592,174601,174750,174888,175099,175194,175199,175205,175290,175384,175396,175399,175416,175568,175569,175859,175862,175922,175961,176034,176135,176152,176365,176462,176613,176616,176727,176756,176832,176861,176892,177022,177072,177073,177074,177299,177429,177433,177533,177558,177648,177676,177986,177994,178115,178430,178542,178543,178765,178769,178983,179420,179536,179644,179655,179684,179826,179910,179973,180511,180512,180663,180704,180767,180789,180840,181280,181309,181393,181663,181710,183040,183314,183332,183342,183344,183353,183736,183737,183738,183739,183740,183741,183951,183952,183953,184406,184416,184793,184826,184946,185009,185021,185028,185174,185219,185346,185347,185483,185566,185567,185718,185760,185869,185969,186193,186524,186536,186773,186867,186929,187024,187025,187110,187407,187529,187659,187694,187773,187792,188010,188182,188367,188599,188619,188734,188950,189115,189376,189746,190250,190277,190402,190440,191389,191471,191544,191545,191561,191708,191768,191849,191986,192095,192325,192339,192391,192429,192595,192612,192833,193230,193695,193697,194579,195405,195454,195499,195567,196703,198171,199161) 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 (20320,20333,20334,20338,20340,20349,20357,20374,20378,20446,20556,20747,21512,21580,21762,21824,21874,21881,21933,21988,22415,22416,22423,22425,22432,22436,22438,22439,23303,23382,23384,23465,23670,24061,24071,24075,24081,24082,24084,24085,24086,24994,24998,25009,25010,25044,25052,25068,25076,25080,25097,25099,25104,25105,25112,25242,25679,25787,25888,25889,26032,26034,26131,26132,26363,26364,26365,26451,26577,26769,26770,27362,27363,27374,27461,27496,27508,27583,27862,28070,28988,29166,29761,30302,30484,30576,31024,31075,31713,31714,32331,32512,32830,33050,33129,33130,33131,33132,33333,33531,34619,35247,36154,36260,36261,36262,36573,38822,38823,39526,39614,39687,39715,39743,40356,41984,41994,42575,43025,43026,43337,43887,43917,43996,44418,44526,44826,46171,46184,46185,46783,47051,47108,47858,48163,48379,49072,49128,49920,50149,50532,50829,50841,50913,50927,50937,50960,50972,51957,52470,52967,53161,53726,53788,53795,56002,56101,56139,56260,56516,56800,57130,57385,57506,57608,57797,58261,58685,59011,59067,59552,60188,60261,60335,60336,60337,60581,61019,61160,61192,61648,61852,61885,62264,62323,62335,62458,63907,63908,63934,63960,64057,64416,64555,64674,65235,65576,65671,66445,66616,66771,68583,69306,70041,70120,70376,70401,71279,71949,72092,72609,72759,72846,73598,73772,74231,74354,74395,74526,75338,76037,76190,76717,78626,82550,83046,83559,84040,84647,84982,85196,85245,85925,86139,86471,86644,86805,86859,86883,87413,87414,87415,88770,89168,89361,89507,89570,90757,91071,91102,91993,92786,92897,94383,94384,94520,94983,95611,95612,95722,95810,98210,98443,98444,98454,99027,99050,99098,99102,99109,99413,99466,100585,100733,100748,100893,102437,102441,103030,103260,103442,103457,103632,103633,103634,103635,103636,103849,104360,105327,105697,105707,106022,106196,106424,106589,106631,106783,107025,107136,107150,107270,107374,107428,107468,107494,107553,108323,108328,108477,108478,108846,108872,108962,109096,109325,109327,109329,109893,109936,110355,110438,110559,110560,110623,111190,111340,111341,111342,112157,112762,112796,112819,113159,113210,113528,113580,113745,114012,114083,114138,114238,114269,114315,114486,114576,115007,115088,115546,115730,115742,115896,115897,116360,116380,116545,116661,116793,116934,117000,117733,117820,117867,118079,118153,118540,118545,118757,119093,119143,119325,119895,120346,120698,121218,121420,121584,122168,122248,122643,122648,122650,122781,122838,123048,123215,123228,123257,123259,123268,123272,123274,123276,123712,123776,123837,123952,123954,124271,124402,124405,124406,125318,125733,125772,125779,125802,125885,125962,125993,126073,126480,126550,126675,126676,126943,127173,127174,127219,127360,127539,127606,127630,127659,127754,127843,127940,128032,128046,128065,128102,128276,128278,128305,128558,128677,128679,128694,128936,128937,129164,129220,129252,129582,130062,130063,130064,130106,130942,131145,131326,131495,131825,132349,132367,132739,132965,133056,133181,133234,133276,133540,133976,134199,134717,134731,134732,134735,134736,134738,134739,134740,135713,136006,136206,136207,136564,136685,136834,137266,137289,137383,137563,137855,138076,138081,138634,138644,138785,139014,139120,140212,140646,140870,141357,141683,141959,142121,142348,142408,142487,142509,142514,142517,142530,143607,143737,143921,143993,144141,144527,144638,144785,144929,145061,145153,145295,145375,145379,146041,146148,146155,146156,146175,146182,146253,146254,146255,146256,146257,146258,146426,146545,146676,146720,146725,146729,146849,146850,147050,147361,147467,147598,147650,147673,147793,147864,148039,148046,148068,148111,148150,148203,148224,148419,148426,148436,148563,148568,148622,149283,149410,149472,149631,149662,149757,149885,150027,150087,150185,150311,150663,150897,150938,151030,151221,151222,151245,151261,151332,151432,151657,151766,151810,151813,151878,151885,152075,152221,152566,152579,152597,152750,153093,153278,154015,154050,154159,154164,154446,154542,154561,154584,154701,155020,155132,155261,155369,155377,155440,155912,156212,156321,156596,156597,156598,156802,157137,157379,157575,157699,157705,157733,157848,158037,158263,158264,158295,158319,158388,158411,158412,158468,158645,158681,158760,158860,158892,159064,159239,159240,159722,159795,159801,159815,159881,160001,160002,160113,160651,160882,161813,162046,162120,162294,162410,162445,162565,162570,162590,163038,163039,163040,163165,163205,163373,163374,163436,163439,163672,163673,163955,164005,164115,164131,164134,164298,164329,164489,164608,164727,164767,164805,164859,164900,164901,164902,164994,165008,165111,165540,165578,165648,165649,165931,166424,166426,166505,166579,166588,166692,166837,166875,166988,167201,167255,167837,167944,168345,168420,168550,168882,169293,169295,169311,169312,169348,169349,169362,169724,169739,169938,169939,170040,170202,170308,170449,170461,170679,170945,170976,171080,171228,171275,171391,171471,171514,171710,172013,172279,172605,173092,173121,173194,173276,173450,173628,173958,174055,174592,174601,174750,174888,175099,175194,175199,175205,175290,175384,175396,175399,175416,175568,175569,175859,175862,175922,175961,176034,176135,176152,176365,176462,176613,176616,176727,176756,176832,176861,176892,177022,177072,177073,177074,177299,177429,177433,177533,177558,177648,177676,177986,177994,178115,178430,178542,178543,178765,178769,178983,179420,179536,179644,179655,179684,179826,179910,179973,180511,180512,180663,180704,180767,180789,180840,181280,181309,181393,181663,181710,183040,183314,183332,183342,183344,183353,183736,183737,183738,183739,183740,183741,183951,183952,183953,184406,184416,184793,184826,184946,185009,185021,185028,185174,185219,185346,185347,185483,185566,185567,185718,185760,185869,185969,186193,186524,186536,186773,186867,186929,187024,187025,187110,187407,187529,187659,187694,187773,187792,188010,188182,188367,188599,188619,188734,188950,189115,189376,189746,190250,190277,190402,190440,191389,191471,191544,191545,191561,191708,191768,191849,191986,192095,192325,192339,192391,192429,192595,192612,192833,193230,193695,193697,194579,195405,195454,195499,195567,196703,198171,199161) GROUP BY sold_month ORDER BY scs.date_actual_sold |
79 | Creole | executeQuery(): [17.25 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 (20320,20333,20334,20338,20340,20349,20357,20374,20378,20446,20556,20747,21512,21580,21762,21824,21874,21881,21933,21988,22415,22416,22423,22425,22432,22436,22438,22439,23303,23382,23384,23465,23670,24061,24071,24075,24081,24082,24084,24085,24086,24994,24998,25009,25010,25044,25052,25068,25076,25080,25097,25099,25104,25105,25112,25242,25679,25787,25888,25889,26032,26034,26131,26132,26363,26364,26365,26451,26577,26769,26770,27362,27363,27374,27461,27496,27508,27583,27862,28070,28988,29166,29761,30302,30484,30576,31024,31075,31713,31714,32331,32512,32830,33050,33129,33130,33131,33132,33333,33531,34619,35247,36154,36260,36261,36262,36573,38822,38823,39526,39614,39687,39715,39743,40356,41984,41994,42575,43025,43026,43337,43887,43917,43996,44418,44526,44826,46171,46184,46185,46783,47051,47108,47858,48163,48379,49072,49128,49920,50149,50532,50829,50841,50913,50927,50937,50960,50972,51957,52470,52967,53161,53726,53788,53795,56002,56101,56139,56260,56516,56800,57130,57385,57506,57608,57797,58261,58685,59011,59067,59552,60188,60261,60335,60336,60337,60581,61019,61160,61192,61648,61852,61885,62264,62323,62335,62458,63907,63908,63934,63960,64057,64416,64555,64674,65235,65576,65671,66445,66616,66771,68583,69306,70041,70120,70376,70401,71279,71949,72092,72609,72759,72846,73598,73772,74231,74354,74395,74526,75338,76037,76190,76717,78626,82550,83046,83559,84040,84647,84982,85196,85245,85925,86139,86471,86644,86805,86859,86883,87413,87414,87415,88770,89168,89361,89507,89570,90757,91071,91102,91993,92786,92897,94383,94384,94520,94983,95611,95612,95722,95810,98210,98443,98444,98454,99027,99050,99098,99102,99109,99413,99466,100585,100733,100748,100893,102437,102441,103030,103260,103442,103457,103632,103633,103634,103635,103636,103849,104360,105327,105697,105707,106022,106196,106424,106589,106631,106783,107025,107136,107150,107270,107374,107428,107468,107494,107553,108323,108328,108477,108478,108846,108872,108962,109096,109325,109327,109329,109893,109936,110355,110438,110559,110560,110623,111190,111340,111341,111342,112157,112762,112796,112819,113159,113210,113528,113580,113745,114012,114083,114138,114238,114269,114315,114486,114576,115007,115088,115546,115730,115742,115896,115897,116360,116380,116545,116661,116793,116934,117000,117733,117820,117867,118079,118153,118540,118545,118757,119093,119143,119325,119895,120346,120698,121218,121420,121584,122168,122248,122643,122648,122650,122781,122838,123048,123215,123228,123257,123259,123268,123272,123274,123276,123712,123776,123837,123952,123954,124271,124402,124405,124406,125318,125733,125772,125779,125802,125885,125962,125993,126073,126480,126550,126675,126676,126943,127173,127174,127219,127360,127539,127606,127630,127659,127754,127843,127940,128032,128046,128065,128102,128276,128278,128305,128558,128677,128679,128694,128936,128937,129164,129220,129252,129582,130062,130063,130064,130106,130942,131145,131326,131495,131825,132349,132367,132739,132965,133056,133181,133234,133276,133540,133976,134199,134717,134731,134732,134735,134736,134738,134739,134740,135713,136006,136206,136207,136564,136685,136834,137266,137289,137383,137563,137855,138076,138081,138634,138644,138785,139014,139120,140212,140646,140870,141357,141683,141959,142121,142348,142408,142487,142509,142514,142517,142530,143607,143737,143921,143993,144141,144527,144638,144785,144929,145061,145153,145295,145375,145379,146041,146148,146155,146156,146175,146182,146253,146254,146255,146256,146257,146258,146426,146545,146676,146720,146725,146729,146849,146850,147050,147361,147467,147598,147650,147673,147793,147864,148039,148046,148068,148111,148150,148203,148224,148419,148426,148436,148563,148568,148622,149283,149410,149472,149631,149662,149757,149885,150027,150087,150185,150311,150663,150897,150938,151030,151221,151222,151245,151261,151332,151432,151657,151766,151810,151813,151878,151885,152075,152221,152566,152579,152597,152750,153093,153278,154015,154050,154159,154164,154446,154542,154561,154584,154701,155020,155132,155261,155369,155377,155440,155912,156212,156321,156596,156597,156598,156802,157137,157379,157575,157699,157705,157733,157848,158037,158263,158264,158295,158319,158388,158411,158412,158468,158645,158681,158760,158860,158892,159064,159239,159240,159722,159795,159801,159815,159881,160001,160002,160113,160651,160882,161813,162046,162120,162294,162410,162445,162565,162570,162590,163038,163039,163040,163165,163205,163373,163374,163436,163439,163672,163673,163955,164005,164115,164131,164134,164298,164329,164489,164608,164727,164767,164805,164859,164900,164901,164902,164994,165008,165111,165540,165578,165648,165649,165931,166424,166426,166505,166579,166588,166692,166837,166875,166988,167201,167255,167837,167944,168345,168420,168550,168882,169293,169295,169311,169312,169348,169349,169362,169724,169739,169938,169939,170040,170202,170308,170449,170461,170679,170945,170976,171080,171228,171275,171391,171471,171514,171710,172013,172279,172605,173092,173121,173194,173276,173450,173628,173958,174055,174592,174601,174750,174888,175099,175194,175199,175205,175290,175384,175396,175399,175416,175568,175569,175859,175862,175922,175961,176034,176135,176152,176365,176462,176613,176616,176727,176756,176832,176861,176892,177022,177072,177073,177074,177299,177429,177433,177533,177558,177648,177676,177986,177994,178115,178430,178542,178543,178765,178769,178983,179420,179536,179644,179655,179684,179826,179910,179973,180511,180512,180663,180704,180767,180789,180840,181280,181309,181393,181663,181710,183040,183314,183332,183342,183344,183353,183736,183737,183738,183739,183740,183741,183951,183952,183953,184406,184416,184793,184826,184946,185009,185021,185028,185174,185219,185346,185347,185483,185566,185567,185718,185760,185869,185969,186193,186524,186536,186773,186867,186929,187024,187025,187110,187407,187529,187659,187694,187773,187792,188010,188182,188367,188599,188619,188734,188950,189115,189376,189746,190250,190277,190402,190440,191389,191471,191544,191545,191561,191708,191768,191849,191986,192095,192325,192339,192391,192429,192595,192612,192833,193230,193695,193697,194579,195405,195454,195499,195567,196703,198171,199161) 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(): [2313.07 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(): [7.40 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199610 |
108 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
109 | Creole | executeQuery(): [4.05 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199268 |
110 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
111 | Creole | executeQuery(): [7.34 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199087 |
112 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
113 | Creole | executeQuery(): [10.36 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=199021 |
114 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
115 | Creole | executeQuery(): [4.32 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=198664 |
116 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
117 | Creole | executeQuery(): [8.52 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=148440 |
118 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
119 | Creole | executeQuery(): [4.76 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=148216 |
120 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
121 | Creole | executeQuery(): [3.24 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=147982 |
122 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
123 | Creole | executeQuery(): [2.24 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=147981 |
124 | Creole | prepareStatement(): SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=? |
125 | Creole | executeQuery(): [4.26 ms] SELECT car.ID_MAKE, car.ID_MODEL FROM car WHERE car.ID=147980 |
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: 148441 action: view id: 148441 make: mg model: mgb 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: 1731602437.2378 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: HandLtestDomainNameServer: HandLtestDomainValueServer country: US countryName: United States handl_ip: 3.147.74.197 handl_landing_page: https://sprutcam.com/ja/?p=208303 handl_url: https://sprutcam.com/ja/?p=208303 handl_url_base: https://sprutcam.com/ja/ user_agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) env: files: get: post: server: CONTENT_LENGTH: CONTENT_TYPE: DOCUMENT_ROOT: /web/classicdigest.com/web DOCUMENT_URI: /cars/index_dev.php/mg/mgb/148441 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: HandLtestDomainNameServer=HandLtestDomainValueServer; handl_url_base=https%3A%2F%2Fsprutcam.com%2Fja%2F; countryName=United%20States; user_agent=Mozilla%2F5.0%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%3B%20compatible%3B%20ClaudeBot%2F1.0%3B%20%2Bclaudebot%40anthropic.com%29; country=US; handl_url=https%3A%2F%2Fsprutcam.com%2Fja%2F%3Fp%3D208303; handl_ip=3.147.74.197; handl_landing_page=https%3A%2F%2Fsprutcam.com%2Fja%2F%3Fp%3D208303 HTTP_HOST: www.classicdigest.com HTTP_REFERER: https://classicdigest.com/cars/index_dev.php/mg/mgb/148441 HTTP_USER_AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) PATH_INFO: /mg/mgb/148441 PATH_TRANSLATED: /web/classicdigest.com/web/mg/mgb/148441 PHP_SELF: /cars/index_dev.php/mg/mgb/148441 QUERY_STRING: REDIRECT_STATUS: 200 REMOTE_ADDR: 3.147.74.197 REMOTE_PORT: 5514 REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1731602437 REQUEST_TIME_FLOAT: 1731602437.2365 REQUEST_URI: /cars/index_dev.php/mg/mgb/148441 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.98 |
Action "home/view" | 1 | 2546.32 |
Database | 34 | 2537.00 |
View "Success" for "home/view" | 1 | 106.33 |
Partial "home/_vif_images" | 1 | 0.74 |
Partial "common_page/_social_buttons" | 1 | 0.11 |
Partial "home/_vif_info" | 1 | 0.23 |
Partial "home/_hoover_user_info" | 1 | 0.09 |
Partial "common_page/_price_development_graph" | 1 | 0.07 |
Partial "common_page/_sell_time_price_graph" | 1 | 0.06 |
Partial "common_page/_price_gauge_graph" | 1 | 0.05 |
Partial "common_page/_include_vif_js" | 1 | 0.09 |
Partial "common_page/_fancybox_javascript" | 2 | 0.23 |
Partial "common_page/_responsive_javascript" | 1 | 0.07 |
Partial "common_page/_google_analytics" | 1 | 0.06 |
Partial "common_page/_header_links" | 1 | 0.98 |
Partial "common_page/_cookie_policy" | 1 | 0.10 |
Partial "common_page/_responsive_top_menu" | 1 | 0.16 |
Partial "common_page/_top_menu" | 1 | 0.19 |
Partial "common_page/_footer_javascript" | 1 | 0.14 |
Partial "common_page/_footer" | 1 | 0.16 |