Query Metrics
970
Database Queries
7
Different statements
1187.68 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
607.25 ms (51.13%) |
482 |
SELECT t0.historical_info AS historical_info_1, t0.description_ar AS description_ar_2, t0.description_en AS description_en_3, t0.body_type AS body_type_4, t0.vehicle_status AS vehicle_status_5, t0.vehicle_condition AS vehicle_condition_6, t0.transmission AS transmission_7, t0.fuel AS fuel_8, t0.condition_report_path AS condition_report_path_9, t0.estimate_value AS estimate_value_10, t0.is_repairable AS is_repairable_11, t0.repair_required_time AS repair_required_time_12, t0.repair_cost AS repair_cost_13, t0.value_after_repair AS value_after_repair_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.old_panel_numbers AS old_panel_numbers_17, t0.manufacturer_country_id AS manufacturer_country_id_18, t0.odometer_range_id AS odometer_range_id_19, t0.vehicle_id AS vehicle_id_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22, t0.old_panel_letter1 AS old_panel_letter1_23, t0.old_panel_letter2 AS old_panel_letter2_24, t0.old_panel_letter3 AS old_panel_letter3_25 FROM vehicle_technical_specs t0 WHERE t0.vehicle_id = ?
Parameters:
[
12643
]
|
544.68 ms (45.86%) |
482 |
SELECT t0.beneficiary_vehicle_number AS beneficiary_vehicle_number_1, t0.compensation_amount AS compensation_amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.vehicle_id AS vehicle_id_5, t0.beneficiary_id AS beneficiary_id_6, t0.owner_payment_doc_id AS owner_payment_doc_id_7, t0.purchase_supplier_invoice_id AS purchase_supplier_invoice_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.vehicle_id AS vehicle_id_11 FROM vehicle_beneficiary_details t0 WHERE t0.vehicle_id = ?
Parameters:
[
12643
]
|
16.03 ms (1.35%) |
1 |
SELECT a0_.line_number AS line_number_0, v1_.vehicle_id AS vehicle_id_1, v1_.state AS state_2, v1_.vehicle_number AS vehicle_number_3, v1_.created_at AS created_at_4, v1_.updated_at AS updated_at_5, v1_.situation AS situation_6, v1_.offerability_for_sale AS offerability_for_sale_7, v1_.status AS status_8, v1_.is_deleted AS is_deleted_9, v1_.is_approved AS is_approved_10, v1_.inspection_expiration_date AS inspection_expiration_date_11, v1_.insurance_start_date AS insurance_start_date_12, v1_.insurance_expiry_date AS insurance_expiry_date_13, v1_.exit_date AS exit_date_14, v1_.receiving_at AS receiving_at_15, v2_.vin_number AS vin_number_16, v2_.panel_numbers AS panel_numbers_17, v2_.weight AS weight_18, v2_.vehicle_load AS vehicle_load_19, v2_.manufacturing_year AS manufacturing_year_20, v2_.serial_number AS serial_number_21, v2_.license_expiry_date AS license_expiry_date_22, v2_.license_expiry_date_hijri AS license_expiry_date_hijri_23, v2_.vehicle_id AS vehicle_id_24, v1_.approved_by AS approved_by_25, v1_.created_by AS created_by_26, v1_.parent_vehicle_id AS parent_vehicle_id_27, v1_.updated_by AS updated_by_28, v2_.color_id AS color_id_29, v2_.registration_doc_id AS registration_doc_id_30, v2_.panel_letter1 AS panel_letter1_31, v2_.panel_letter2 AS panel_letter2_32, v2_.panel_letter3 AS panel_letter3_33, v2_.model_id AS model_id_34, v2_.registration_type_id AS registration_type_id_35, v2_.vehicle_id AS vehicle_id_36, v2_.vehicle_owner_id AS vehicle_owner_id_37, v2_.vehicle_user_id AS vehicle_user_id_38 FROM vehicles v1_ INNER JOIN auction_vehicles a0_ ON (v1_.vehicle_id = a0_.vehicle_id AND a0_.auction_id = 21001) LEFT JOIN vehicle_registrations v2_ ON v1_.vehicle_id = v2_.vehicle_id ORDER BY a0_.line_number ASC
Parameters:
[] |
8.00 ms (0.67%) |
2 |
SELECT t0.id AS id_1, t0.title_ar AS title_ar_2, t0.title_en AS title_en_3, t0.content_ar AS content_ar_4, t0.content_en AS content_en_5, t0.keyword AS keyword_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM content_pages t0 WHERE t0.keyword = ? LIMIT 1
Parameters:
[
"video"
]
|
5.14 ms (0.43%) |
1 |
SELECT a0_.auction_id AS auction_id_0, a0_.start_date AS start_date_1, a0_.start_date_hijri AS start_date_hijri_2, a0_.end_date AS end_date_3, a0_.end_date_hijri AS end_date_hijri_4, a0_.title AS title_5, a0_.status AS status_6, a0_.auction_sec_amount_method AS auction_sec_amount_method_7, a0_.confiscation_rate AS confiscation_rate_8, a0_.minimum_confiscation AS minimum_confiscation_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.auction_list_file AS auction_list_file_12, a0_.auction_video AS auction_video_13, a0_.auction_preview_start AS auction_preview_start_14, a0_.auction_preview_end AS auction_preview_end_15, a0_.created_by AS created_by_16 FROM auctions a0_ ORDER BY a0_.auction_id DESC LIMIT 1
Parameters:
[] |
4.23 ms (0.36%) |
1 |
SELECT v0_.model_id AS model_id_0, v0_.name_ar AS name_ar_1, v0_.name_en AS name_en_2, v0_.oracle_model_id AS oracle_model_id_3, v0_.maker_id AS maker_id_4 FROM vehicle_models v0_
Parameters:
[] |
2.35 ms (0.20%) |
1 |
SELECT v0_.maker_id AS maker_id_0, v0_.name_ar AS name_ar_1, v0_.name_en AS name_en_2 FROM vehicle_makers v0_
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\ContentPages | No errors. |
App\Entity\Users | No errors. |
App\Entity\VehicleMakers | No errors. |
App\Entity\VehicleModels | No errors. |
App\Entity\Auctions | No errors. |
App\Entity\AuctionVehicles | No errors. |
App\Entity\Vehicles |
|
App\Entity\VehicleRegistrations | No errors. |
App\Entity\VehicleColors | No errors. |
App\Entity\VehicleDocs | No errors. |
App\Entity\PanelLetters | No errors. |
App\Entity\VehicleRegistrationTypes | No errors. |
App\Entity\VehicleClients | No errors. |
App\Entity\VehicleInventoryMissingParts | No errors. |
App\Entity\VehicleOtherMissingParts | No errors. |
App\Entity\VehicleInventoryImages | No errors. |
App\Entity\VehicleTechnicalSpecs | No errors. |
App\Entity\Countries | No errors. |
App\Entity\OdometerRanges | No errors. |
App\Entity\VehicleBeneficiaryDetails | No errors. |
App\Entity\SupplierInvoices | No errors. |
App\Entity\VehicleRevokeRequests | No errors. |
App\Entity\VehicleRtsActivitiesEstimateVal | No errors. |
App\Entity\VehicleSales | No errors. |