https://apitest.parkovisko.eu/api/for-customers/vehicle/get-by-vin

Query Metrics

5 Database Queries
5 Different statements
10.71 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
8.67 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.endpoint AS endpoint_2, t0.client_token AS client_token_3, t0.calls AS calls_4 FROM api_call_counter t0 WHERE t0.endpoint = ? AND t0.client_token = ? LIMIT 1
Parameters:
[
  "get-by-vin"
  "dgj73GksFa84flsdGSBJ93hSaSdjf"
]
1.12 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.last_update_at AS last_update_at_2, t0.has_brakes_abs AS has_brakes_abs_3, t0.brakes_ehk AS brakes_ehk_4, t0.has_brakes_emergency AS has_brakes_emergency_5, t0.has_brakes_relief AS has_brakes_relief_6, t0.has_brakes_parking AS has_brakes_parking_7, t0.has_brakes_operating AS has_brakes_operating_8, t0.engine_number AS engine_number_9, t0.tp_number AS tp_number_10, t0.first_registration_on AS first_registration_on_11, t0.first_registration_in_sr_on AS first_registration_in_sr_on_12, t0.type_case AS type_case_13, t0.type_wheel AS type_wheel_14, t0.type_fuel AS type_fuel_15, t0.type_vehicle AS type_vehicle_16, t0.emission_co AS emission_co_17, t0.emission_co2 AS emission_co2_18, t0.emission_particles AS emission_particles_19, t0.emission_smoke AS emission_smoke_20, t0.emission_ehk AS emission_ehk_21, t0.emission_hc AS emission_hc_22, t0.emission_hc_nox AS emission_hc_nox_23, t0.emission_absorbtion_coeff AS emission_absorbtion_coeff_24, t0.emission_co_unit_of_meas AS emission_co_unit_of_meas_25, t0.emission_co_identifier AS emission_co_identifier_26, t0.emission_particles_unit_of_meas AS emission_particles_unit_of_meas_27, t0.emission_particles_identifier AS emission_particles_identifier_28, t0.emission_hc_unit_of_meas AS emission_hc_unit_of_meas_29, t0.emission_hc_identifier AS emission_hc_identifier_30, t0.emission_nox_unit_of_meas AS emission_nox_unit_of_meas_31, t0.emission_nox_identifier AS emission_nox_identifier_32, t0.emission_nox AS emission_nox_33, t0.emission_combined_fuel_consumption AS emission_combined_fuel_consumption_34, t0.emission_city_fuel_consumption AS emission_city_fuel_consumption_35, t0.emission_city_outside_fuel_consumption AS emission_city_outside_fuel_consumption_36, t0.emission_sound_ehk AS emission_sound_ehk_37, t0.emission_sound_at_speed AS emission_sound_at_speed_38, t0.ecv AS ecv_39, t0.type_color AS type_color_40, t0.sound_level_standing AS sound_level_standing_41, t0.sound_level_driving AS sound_level_driving_42, t0.type_catalize AS type_catalize_43, t0.type_category AS type_category_44, t0.max_engine_perfomance AS max_engine_perfomance_45, t0.max_speed AS max_speed_46, t0.max_permissable_total_weight AS max_permissable_total_weight_47, t0.max_permissable_vehicle_weight AS max_permissable_vehicle_weight_48, t0.max_permissable_weight_per_axle1 AS max_permissable_weight_per_axle1_49, t0.max_permissable_weight_per_axle2 AS max_permissable_weight_per_axle2_50, t0.max_permissable_weight_per_axle3 AS max_permissable_weight_per_axle3_51, t0.max_permissable_weight_per_axle4 AS max_permissable_weight_per_axle4_52, t0.max_weight_for_trailers_with_brakes AS max_weight_for_trailers_with_brakes_53, t0.max_weight_for_trailers_without_brakes AS max_weight_for_trailers_without_brakes_54, t0.max_permissable_weight_at_connection_upper_hinge AS max_permissable_weight_at_connection_upper_hinge_55, t0.max_permissable_weight_at_connection_lower_hinge AS max_permissable_weight_at_connection_lower_hinge_56, t0.max_permissable_weight_at_connection_turntable AS max_permissable_weight_at_connection_turntable_57, t0.code_model AS code_model_58, t0.fuel_volume AS fuel_volume_59, t0.cisterne_volume AS cisterne_volume_60, t0.laying_count AS laying_count_61, t0.sitting_count AS sitting_count_62, t0.staying_count AS staying_count_63, t0.axle_count AS axle_count_64, t0.sitting_emergency_count AS sitting_emergency_count_65, t0.transmission_count AS transmission_count_66, t0.is_driving_axle1 AS is_driving_axle1_67, t0.is_driving_axle2 AS is_driving_axle2_68, t0.is_driving_axle3 AS is_driving_axle3_69, t0.is_driving_axle4 AS is_driving_axle4_70, t0.operating_weight AS operating_weight_71, t0.type_transmission AS type_transmission_72, t0.wheel_base AS wheel_base_73, t0.wheel_base2 AS wheel_base2_74, t0.wheel_base3 AS wheel_base3_75, t0.wheel_base4 AS wheel_base4_76, t0.dimension_and_type_of_tyre_axle1 AS dimension_and_type_of_tyre_axle1_77, t0.dimension_and_type_of_tyre_axle2 AS dimension_and_type_of_tyre_axle2_78, t0.dimension_and_type_of_tyre_axle3 AS dimension_and_type_of_tyre_axle3_79, t0.dimension_and_type_of_tyre_axle4 AS dimension_and_type_of_tyre_axle4_80, t0.rim_dimensions_axle1 AS rim_dimensions_axle1_81, t0.rim_dimensions_axle2 AS rim_dimensions_axle2_82, t0.rim_dimensions_axle3 AS rim_dimensions_axle3_83, t0.rim_dimensions_axle4 AS rim_dimensions_axle4_84, t0.length_vehicle AS length_vehicle_85, t0.width AS width_86, t0.height AS height_87, t0.length_loading_area AS length_loading_area_88, t0.width_loading_area AS width_loading_area_89, t0.coupling_device_approval_mark AS coupling_device_approval_mark_90, t0.coupling_device_class AS coupling_device_class_91, t0.coupling_device_identifier AS coupling_device_identifier_92, t0.coupling_device_type AS coupling_device_type_93, t0.coupling_device_brand AS coupling_device_brand_94, t0.type_name AS type_name_95, t0.type_engine AS type_engine_96, t0.type_variant_version AS type_variant_version_97, t0.approval_procedure_number AS approval_procedure_number_98, t0.approval_certificate_number AS approval_certificate_number_99, t0.date_of_approval_procedure_on AS date_of_approval_procedure_on_100, t0.date_of_approval_issue_on AS date_of_approval_issue_on_101, t0.approval_place_of_issue AS approval_place_of_issue_102, t0.vin AS vin_103, t0.engine_weight AS engine_weight_104, t0.body_manufacturer AS body_manufacturer_105, t0.engine_manufacturer AS engine_manufacturer_106, t0.vehicle_manufacturer AS vehicle_manufacturer_107, t0.body_serial_number AS body_serial_number_108, t0.max_roof_load AS max_roof_load_109, t0.cylinder_displacement AS cylinder_displacement_110, t0.code_brand AS code_brand_111, t0.police_code_brand AS police_code_brand_112, t0.brand_original_name AS brand_original_name_113, t0.model_original_name AS model_original_name_114 FROM police_data t0 WHERE t0.vin = ?
Parameters:
[
  "WAUZZZFNXTN062790"
]
0.39 ms
(0.00%)
1
UPDATE api_call_counter SET calls = ? WHERE id = ?
Parameters:
[
  11989
  3
]
0.28 ms
(0.00%)
1
"COMMIT"
Parameters:
[]
0.25 ms
(0.00%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\policeData\PoliceData No errors.
App\Entity\ApiConsumer\ApiCallCounter No errors.