Symfony Profiler

Query Metrics

23 Database Queries

21 Different statements

280.56 ms Query time

3 Invalid entities

Queries


SELECT t0.user_id AS user_id_1, t0.username AS username_2, t0.password AS password_3, t0.telephone AS telephone_4, t0.roles AS roles_5, t0.mobile_number AS mobile_number_6, t0.mobile_number2 AS mobile_number2_7, t0.is_mobile_number2_verified AS is_mobile_number2_verified_8, t0.email AS email_9, t0.email_verified AS email_verified_10, t0.verify_token AS verify_token_11, t0.balance AS balance_12, t0.locked_ot_security AS locked_ot_security_13, t0.is_verified AS is_verified_14, t0.is_deleted AS is_deleted_15, t0.is_receive_sms AS is_receive_sms_16, t0.last_login AS last_login_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.profile_origin AS profile_origin_20, t0.signature_path AS signature_path_21, t0.balance_amount AS balance_amount_22, t0.pledge_amount AS pledge_amount_23, t0.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_24, t0.balance_due AS balance_due_25, t0.client_id AS client_id_26, t0.category_id AS category_id_27, t0.company_id AS company_id_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t31.firstname_ar AS firstname_ar_32, t31.secondname_ar AS secondname_ar_33, t31.thirdname_ar AS thirdname_ar_34, t31.fourthname_ar AS fourthname_ar_35, t31.firstname_en AS firstname_en_36, t31.secondname_en AS secondname_en_37, t31.thirdname_en AS thirdname_en_38, t31.fourthname_en AS fourthname_en_39, t31.identification_number AS identification_number_40, t31.gender AS gender_41, t31.expiration_date AS expiration_date_42, t31.expiration_date_hijri AS expiration_date_hijri_43, t31.version_number AS version_number_44, t31.issuer AS issuer_45, t31.date_of_birth AS date_of_birth_46, t31.date_of_birth_hijri AS date_of_birth_hijri_47, t31.occupation AS occupation_48, t31.religion AS religion_49, t31.registry_number AS registry_number_50, t31.registry_authority AS registry_authority_51, t31.registry_hijri_date AS registry_hijri_date_52, t31.employer AS employer_53, t31.image_path AS image_path_54, t31.employer_letter_path AS employer_letter_path_55, t31.country_id AS country_id_56, t31.user_id AS user_id_57, t58.prefix AS prefix_59, t58.suffix AS suffix_60, t58.home_phone AS home_phone_61, t58.business_phone AS business_phone_62, t58.business_fax AS business_fax_63, t58.business_phone2 AS business_phone2_64, t58.company_main_phone AS company_main_phone_65, t58.email2 AS email2_66, t58.web_page AS web_page_67, t58.department AS department_68, t58.job_title AS job_title_69, t58.manager_name AS manager_name_70, t58.business_city AS business_city_71, t58.po_box AS po_box_72, t58.postal_code AS postal_code_73, t58.trn AS trn_74, t58.building_no AS building_no_75, t58.business_street AS business_street_76, t58.district_name AS district_name_77, t58.zip_code AS zip_code_78, t58.additional_no AS additional_no_79, t58.unit_no AS unit_no_80, t58.issue_date_hijri AS issue_date_hijri_81, t58.issue_date AS issue_date_82, t58.birth_city AS birth_city_83, t58.passport_no AS passport_no_84, t58.passport_expiry_date AS passport_expiry_date_85, t58.passport_issue_date AS passport_issue_date_86, t58.soc_insrnc_no AS soc_insrnc_no_87, t58.join_date AS join_date_88, t58.basic_salary AS basic_salary_89, t58.housing_allowance AS housing_allowance_90, t58.soc_insrnc_amount AS soc_insrnc_amount_91, t58.other_allowances AS other_allowances_92, t58.labor_no AS labor_no_93, t58.labor_start_date AS labor_start_date_94, t58.ksa_entry_date AS ksa_entry_date_95, t58.border_no AS border_no_96, t58.work_permit_start_date AS work_permit_start_date_97, t58.work_permit_end_date AS work_permit_end_date_98, t58.med_insrnc_mem_no AS med_insrnc_mem_no_99, t58.national_address_path AS national_address_path_100, t58.passport_path AS passport_path_101, t58.med_insrnc_path AS med_insrnc_path_102, t58.med_insrnc_expiry_date AS med_insrnc_expiry_date_103, t58.classification_id AS classification_id_104, t58.city_id AS city_id_105, t58.user_id AS user_id_106, t107.client_id AS client_id_108, t107.is_active AS is_active_109, t107.company_id AS company_id_110, t107.user_id AS user_id_111 FROM users t0 LEFT JOIN user_identity_info t31 ON t31.user_id = t0.user_id LEFT JOIN user_additional_details t58 ON t58.user_id = t0.user_id LEFT JOIN vehicle_clients t107 ON t107.user_id = t0.user_id WHERE t0.user_id = ?
SELECT t0.vehicle_id AS vehicle_id_1, t0.state AS state_2, t0.vehicle_number AS vehicle_number_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.situation AS situation_6, t0.offerability_for_sale AS offerability_for_sale_7, t0.status AS status_8, t0.is_deleted AS is_deleted_9, t0.is_approved AS is_approved_10, t0.inspection_expiration_date AS inspection_expiration_date_11, t0.insurance_start_date AS insurance_start_date_12, t0.insurance_expiry_date AS insurance_expiry_date_13, t0.exit_date AS exit_date_14, t0.receiving_at AS receiving_at_15, t0.approved_by AS approved_by_16, t0.created_by AS created_by_17, t0.parent_vehicle_id AS parent_vehicle_id_18, t0.updated_by AS updated_by_19, t20.vin_number AS vin_number_21, t20.panel_numbers AS panel_numbers_22, t20.weight AS weight_23, t20.vehicle_load AS vehicle_load_24, t20.manufacturing_year AS manufacturing_year_25, t20.serial_number AS serial_number_26, t20.license_expiry_date AS license_expiry_date_27, t20.license_expiry_date_hijri AS license_expiry_date_hijri_28, t20.vehicle_id AS vehicle_id_29, t20.color_id AS color_id_30, t20.registration_doc_id AS registration_doc_id_31, t20.panel_letter1 AS panel_letter1_32, t20.panel_letter2 AS panel_letter2_33, t20.panel_letter3 AS panel_letter3_34, t20.model_id AS model_id_35, t20.registration_type_id AS registration_type_id_36, t20.vehicle_id AS vehicle_id_37, t20.vehicle_owner_id AS vehicle_owner_id_38, t20.vehicle_user_id AS vehicle_user_id_39, t40.historical_info AS historical_info_41, t40.description_ar AS description_ar_42, t40.description_en AS description_en_43, t40.body_type AS body_type_44, t40.vehicle_status AS vehicle_status_45, t40.vehicle_condition AS vehicle_condition_46, t40.transmission AS transmission_47, t40.fuel AS fuel_48, t40.condition_report_path AS condition_report_path_49, t40.estimate_value AS estimate_value_50, t40.is_repairable AS is_repairable_51, t40.repair_required_time AS repair_required_time_52, t40.repair_cost AS repair_cost_53, t40.value_after_repair AS value_after_repair_54, t40.created_at AS created_at_55, t40.updated_at AS updated_at_56, t40.old_panel_numbers AS old_panel_numbers_57, t40.manufacturer_country_id AS manufacturer_country_id_58, t40.odometer_range_id AS odometer_range_id_59, t40.vehicle_id AS vehicle_id_60, t40.created_by AS created_by_61, t40.updated_by AS updated_by_62, t40.old_panel_letter1 AS old_panel_letter1_63, t40.old_panel_letter2 AS old_panel_letter2_64, t40.old_panel_letter3 AS old_panel_letter3_65, t66.beneficiary_vehicle_number AS beneficiary_vehicle_number_67, t66.compensation_amount AS compensation_amount_68, t66.created_at AS created_at_69, t66.updated_at AS updated_at_70, t66.vehicle_id AS vehicle_id_71, t66.beneficiary_id AS beneficiary_id_72, t66.owner_payment_doc_id AS owner_payment_doc_id_73, t66.purchase_supplier_invoice_id AS purchase_supplier_invoice_id_74, t66.created_by AS created_by_75, t66.updated_by AS updated_by_76, t66.vehicle_id AS vehicle_id_77 FROM vehicles t0 LEFT JOIN vehicle_registrations t20 ON t20.vehicle_id = t0.vehicle_id LEFT JOIN vehicle_technical_specs t40 ON t40.vehicle_id = t0.vehicle_id LEFT JOIN vehicle_beneficiary_details t66 ON t66.vehicle_id = t0.vehicle_id WHERE t0.vehicle_id = ?
SELECT v0_.request_id AS request_id_0, v0_.request_type AS request_type_1, v0_.is_estimate_val_requested AS is_estimate_val_requested_2, v0_.request_date AS request_date_3, v0_.revoke_cancellation_notes AS revoke_cancellation_notes_4, v0_.is_rejected AS is_rejected_5, v0_.rejection_reason AS rejection_reason_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_9, v0_.auth_image_path AS auth_image_path_10, v0_.estimate_image_path AS estimate_image_path_11, v0_.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_12, v0_.created_by AS created_by_13, v0_.updated_by AS updated_by_14, v0_.vehicle_id AS vehicle_id_15 FROM vehicle_revoke_requests v0_ WHERE v0_.vehicle_id = ? ORDER BY v0_.created_at DESC
SELECT t0.address AS address_1, t0.responsible_person_name AS responsible_person_name_2, t0.responsible_person_mob_num AS responsible_person_mob_num_3, t0.responsible_person_mob_num2 AS responsible_person_mob_num2_4, t0.responsible_person_mob_num3 AS responsible_person_mob_num3_5, t0.request_id AS request_id_6, t0.city_id AS city_id_7, t0.request_id AS request_id_8 FROM vehicle_revoke_request_source t0 WHERE t0.request_id = ?
SELECT t0.address AS address_1, t0.responsible_person_name AS responsible_person_name_2, t0.responsible_person_mob_num AS responsible_person_mob_num_3, t0.request_id AS request_id_4, t0.city_id AS city_id_5, t0.request_id AS request_id_6 FROM vehicle_revoke_request_destination t0 WHERE t0.request_id = ?
SELECT v0_.activity_id AS activity_id_0, v0_.activity_type AS activity_type_1, v0_.is_include_revoke AS is_include_revoke_2, v0_.notes AS notes_3, v0_.activity_date AS activity_date_4, v0_.created_at AS created_at_5, v0_.updated_at AS updated_at_6, v0_.is_deleted AS is_deleted_7, v0_.created_by AS created_by_8, v0_.updated_by AS updated_by_9, v0_.revoke_request_id AS revoke_request_id_10, v0_.vehicle_id AS vehicle_id_11 FROM vehicle_rts_activities v0_ WHERE v0_.vehicle_id = ? ORDER BY v0_.created_at DESC
SELECT c0_.delegation_id AS delegation_id_0, c0_.relationship AS relationship_1, c0_.image_path AS image_path_2, c0_.approval_status AS approval_status_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, v1_.client_id AS client_id_6, v1_.is_active AS is_active_7, c2_.company_id AS company_id_8, c2_.shortname_ar AS shortname_ar_9, c2_.shortname_en AS shortname_en_10, c2_.building_no AS building_no_11, c2_.unit_no AS unit_no_12, c2_.street_name_ar AS street_name_ar_13, c2_.street_name_en AS street_name_en_14, c2_.district_name_ar AS district_name_ar_15, c2_.district_name_en AS district_name_en_16, c2_.zip_code AS zip_code_17, c2_.additional_no AS additional_no_18, c2_.universal_no AS universal_no_19, c2_.sms AS sms_20, c2_.email AS email_21, c2_.email2 AS email2_22, c2_.website AS website_23, c2_.trade_chamber_no AS trade_chamber_no_24, c2_.client_id AS client_id_25, c2_.vat_no AS vat_no_26, c2_.social_insurance_no AS social_insurance_no_27, c2_.labour_institution_no AS labour_institution_no_28, c2_.balance AS balance_29, c2_.locked_ot_security AS locked_ot_security_30, c2_.zakat_id_no AS zakat_id_no_31, c2_.municipality_license_no AS municipality_license_no_32, c2_.seal_path AS seal_path_33, c2_.logo_path AS logo_path_34, c2_.signature_path AS signature_path_35, c2_.is_beneficiary AS is_beneficiary_36, c2_.is_tjr_co AS is_tjr_co_37, c2_.is_bank AS is_bank_38, c2_.created_at AS created_at_39, c2_.updated_at AS updated_at_40, c2_.bank_code AS bank_code_41, c2_.balance_amount AS balance_amount_42, c2_.pledge_amount AS pledge_amount_43, c2_.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_44, c2_.balance_due AS balance_due_45, u3_.user_id AS user_id_46, u3_.username AS username_47, u3_.password AS password_48, u3_.telephone AS telephone_49, u3_.roles AS roles_50, u3_.mobile_number AS mobile_number_51, u3_.mobile_number2 AS mobile_number2_52, u3_.is_mobile_number2_verified AS is_mobile_number2_verified_53, u3_.email AS email_54, u3_.email_verified AS email_verified_55, u3_.verify_token AS verify_token_56, u3_.balance AS balance_57, u3_.locked_ot_security AS locked_ot_security_58, u3_.is_verified AS is_verified_59, u3_.is_deleted AS is_deleted_60, u3_.is_receive_sms AS is_receive_sms_61, u3_.last_login AS last_login_62, u3_.created_at AS created_at_63, u3_.updated_at AS updated_at_64, u3_.profile_origin AS profile_origin_65, u3_.signature_path AS signature_path_66, u3_.balance_amount AS balance_amount_67, u3_.pledge_amount AS pledge_amount_68, u3_.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_69, u3_.balance_due AS balance_due_70, u3_.client_id AS client_id_71, c0_.delegator_id AS delegator_id_72, c0_.delegated_id AS delegated_id_73, c0_.created_by AS created_by_74, c0_.updated_by AS updated_by_75, v1_.company_id AS company_id_76, v1_.user_id AS user_id_77, c2_.classification_id AS classification_id_78, c2_.city_id AS city_id_79, c2_.created_by AS created_by_80, c2_.updated_by AS updated_by_81, c2_.category_id AS category_id_82, u3_.category_id AS category_id_83, u3_.company_id AS company_id_84, u3_.created_by AS created_by_85, u3_.updated_by AS updated_by_86 FROM clients_delegation c0_ LEFT JOIN vehicle_clients v1_ ON c0_.delegator_id = v1_.client_id LEFT JOIN companies c2_ ON v1_.company_id = c2_.company_id LEFT JOIN users u3_ ON v1_.user_id = u3_.user_id WHERE c0_.delegated_id = ? AND c0_.approval_status = ?
SELECT t0.letter_code AS letter_code_1, t0.letter_ar AS letter_ar_2, t0.letter_en AS letter_en_3 FROM panel_letters t0 WHERE t0.letter_code = ?
SELECT t0.letter_code AS letter_code_1, t0.letter_ar AS letter_ar_2, t0.letter_en AS letter_en_3 FROM panel_letters t0 WHERE t0.letter_code = ?
SELECT t0.letter_code AS letter_code_1, t0.letter_ar AS letter_ar_2, t0.letter_en AS letter_en_3 FROM panel_letters t0 WHERE t0.letter_code = ?
SELECT v0_.sale_id AS sale_id_0, v0_.renunciation_letter_no AS renunciation_letter_no_1, v0_.seller_price AS seller_price_2, v0_.is_cancelled AS is_cancelled_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5, v0_.is_deleted AS is_deleted_6, v0_.sold_by AS sold_by_7, v0_.value_for_tax AS value_for_tax_8, v0_.vat_amount_for_tax AS vat_amount_for_tax_9, v0_.total_for_tax AS total_for_tax_10, v0_.payed_at AS payed_at_11, v0_.buyer_id AS buyer_id_12, v0_.invoice_id AS invoice_id_13, v0_.created_by AS created_by_14, v0_.ot_sec_transaction_id AS ot_sec_transaction_id_15, v0_.updated_by AS updated_by_16, v0_.vehicle_id AS vehicle_id_17, v0_.vat_for_tax_rate_id AS vat_for_tax_rate_id_18 FROM vehicle_sales v0_ INNER JOIN invoices i1_ ON v0_.invoice_id = i1_.invoice_id INNER JOIN account_transactions a2_ ON i1_.transaction_id = a2_.transaction_id WHERE v0_.vehicle_id = ? AND a2_.status_id = ? AND v0_.is_cancelled <> 1
SELECT t0.ot_id AS ot_id_1, t0.ot_date AS ot_date_2, t0.approval_status AS approval_status_3, t0.created_at AS created_at_4, t0.approved_at AS approved_at_5, t0.is_drop AS is_drop_6, t0.approved_by AS approved_by_7, t0.created_by AS created_by_8, t0.ot_doc_id AS ot_doc_id_9, t0.sale_id AS sale_id_10, t0.vehicle_id AS vehicle_id_11 FROM vehicle_ownership_transfer t0 WHERE t0.vehicle_id = ? AND t0.approval_status = ? LIMIT 1
SELECT t0.activity_id AS activity_id_1, t0.activity_type AS activity_type_2, t0.is_include_revoke AS is_include_revoke_3, t0.notes AS notes_4, t0.activity_date AS activity_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_deleted AS is_deleted_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.revoke_request_id AS revoke_request_id_11, t0.vehicle_id AS vehicle_id_12, t13.is_returned AS is_returned_14, t13.is_repair AS is_repair_15, t13.address AS address_16, t13.responsible_person_name AS responsible_person_name_17, t13.responsible_person_mob_num AS responsible_person_mob_num_18, t13.destination_activity_id AS destination_activity_id_19, t13.inventory_delivery_path AS inventory_delivery_path_20, t13.destination_activity_id AS destination_activity_id_21, t13.city_id AS city_id_22, t23.estimate_val_before AS estimate_val_before_24, t23.estimate_val_after AS estimate_val_after_25, t23.parts_estimation AS parts_estimation_26, t23.image_path AS image_path_27, t23.estimation_id AS estimation_id_28, t23.activity_id AS activity_id_29, t23.rts_invoice_id AS rts_invoice_id_30, t23.vehicle_id AS vehicle_id_31, t32.storage_activity_id AS storage_activity_id_33, t32.storage_activity_id AS storage_activity_id_34, t32.warehouse_id AS warehouse_id_35, t36.transport_date AS transport_date_37, t36.transport_activity_id AS transport_activity_id_38, t36.driver_id AS driver_id_39, t36.rts_invoice_id AS rts_invoice_id_40, t36.transporter_id AS transporter_id_41, t36.transport_activity_id AS transport_activity_id_42, t43.inventory_notes AS inventory_notes_44, t43.inventory_activity_id AS inventory_activity_id_45, t43.inventory_activity_id AS inventory_activity_id_46 FROM vehicle_rts_activities t0 LEFT JOIN vehicle_rts_activities_destinations t13 ON t13.destination_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_estimate_val t23 ON t23.activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_storage t32 ON t32.storage_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_transports t36 ON t36.transport_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_inventories t43 ON t43.inventory_activity_id = t0.activity_id WHERE t0.vehicle_id = ? LIMIT 1
SELECT v0_.request_id AS request_id_0, v0_.request_type AS request_type_1, v0_.is_estimate_val_requested AS is_estimate_val_requested_2, v0_.request_date AS request_date_3, v0_.revoke_cancellation_notes AS revoke_cancellation_notes_4, v0_.is_rejected AS is_rejected_5, v0_.rejection_reason AS rejection_reason_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_9, v0_.auth_image_path AS auth_image_path_10, v0_.estimate_image_path AS estimate_image_path_11, v0_.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_12, v0_.created_by AS created_by_13, v0_.updated_by AS updated_by_14, v0_.vehicle_id AS vehicle_id_15 FROM vehicle_revoke_requests v0_ INNER JOIN vehicle_rts_activities v1_ ON v0_.request_id = v1_.revoke_request_id WHERE v0_.vehicle_id = ?
SELECT t0.log_id AS log_id_1, t0.situation AS situation_2, t0.created_at AS created_at_3, t0.transition AS transition_4, t0.created_by AS created_by_5, t0.vehicle_id AS vehicle_id_6 FROM vehicle_situation_log t0 WHERE t0.vehicle_id = ? ORDER BY t0.log_id DESC LIMIT 1
SELECT t0.log_id AS log_id_1, t0.situation AS situation_2, t0.created_at AS created_at_3, t0.transition AS transition_4, t0.created_by AS created_by_5, t0.vehicle_id AS vehicle_id_6 FROM vehicle_situation_log t0 WHERE t0.vehicle_id = ? ORDER BY t0.log_id DESC LIMIT 1 OFFSET 1
SELECT v0_.request_id AS request_id_0, v0_.request_type AS request_type_1, v0_.is_estimate_val_requested AS is_estimate_val_requested_2, v0_.request_date AS request_date_3, v0_.revoke_cancellation_notes AS revoke_cancellation_notes_4, v0_.is_rejected AS is_rejected_5, v0_.rejection_reason AS rejection_reason_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_9, v0_.auth_image_path AS auth_image_path_10, v0_.estimate_image_path AS estimate_image_path_11, v0_.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_12, v0_.created_by AS created_by_13, v0_.updated_by AS updated_by_14, v0_.vehicle_id AS vehicle_id_15 FROM vehicle_revoke_requests v0_ LEFT JOIN vehicle_rts_activities v1_ ON v0_.request_id = v1_.revoke_request_id WHERE v0_.vehicle_id = ? ORDER BY v0_.request_id DESC
SELECT v0_.activity_id AS activity_id_0, v1_.request_id AS request_id_1, v0_.activity_type AS activity_type_2 FROM vehicle_rts_activities v0_ INNER JOIN vehicle_revoke_requests v1_ ON v0_.revoke_request_id = v1_.request_id WHERE v1_.vehicle_id = ? ORDER BY v0_.activity_id DESC LIMIT 1
SELECT t0.is_returned AS is_returned_1, t0.is_repair AS is_repair_2, t0.address AS address_3, t0.responsible_person_name AS responsible_person_name_4, t0.responsible_person_mob_num AS responsible_person_mob_num_5, t0.destination_activity_id AS destination_activity_id_6, t0.inventory_delivery_path AS inventory_delivery_path_7, t0.destination_activity_id AS destination_activity_id_8, t0.city_id AS city_id_9 FROM vehicle_rts_activities_destinations t0 WHERE t0.destination_activity_id = ? LIMIT 1
SELECT t0.activity_id AS activity_id_1, t0.activity_type AS activity_type_2, t0.is_include_revoke AS is_include_revoke_3, t0.notes AS notes_4, t0.activity_date AS activity_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_deleted AS is_deleted_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.revoke_request_id AS revoke_request_id_11, t0.vehicle_id AS vehicle_id_12, t13.is_returned AS is_returned_14, t13.is_repair AS is_repair_15, t13.address AS address_16, t13.responsible_person_name AS responsible_person_name_17, t13.responsible_person_mob_num AS responsible_person_mob_num_18, t13.destination_activity_id AS destination_activity_id_19, t13.inventory_delivery_path AS inventory_delivery_path_20, t13.destination_activity_id AS destination_activity_id_21, t13.city_id AS city_id_22, t23.estimate_val_before AS estimate_val_before_24, t23.estimate_val_after AS estimate_val_after_25, t23.parts_estimation AS parts_estimation_26, t23.image_path AS image_path_27, t23.estimation_id AS estimation_id_28, t23.activity_id AS activity_id_29, t23.rts_invoice_id AS rts_invoice_id_30, t23.vehicle_id AS vehicle_id_31, t32.storage_activity_id AS storage_activity_id_33, t32.storage_activity_id AS storage_activity_id_34, t32.warehouse_id AS warehouse_id_35, t36.transport_date AS transport_date_37, t36.transport_activity_id AS transport_activity_id_38, t36.driver_id AS driver_id_39, t36.rts_invoice_id AS rts_invoice_id_40, t36.transporter_id AS transporter_id_41, t36.transport_activity_id AS transport_activity_id_42, t43.inventory_notes AS inventory_notes_44, t43.inventory_activity_id AS inventory_activity_id_45, t43.inventory_activity_id AS inventory_activity_id_46 FROM vehicle_rts_activities t0 LEFT JOIN vehicle_rts_activities_destinations t13 ON t13.destination_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_estimate_val t23 ON t23.activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_storage t32 ON t32.storage_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_transports t36 ON t36.transport_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_inventories t43 ON t43.inventory_activity_id = t0.activity_id WHERE t0.revoke_request_id = ? ORDER BY t0.created_at DESC
SELECT t0.city_id AS city_id_1, t0.name_ar AS name_ar_2, t0.name_en AS name_en_3, t0.oracle_city_id AS oracle_city_id_4, t0.region_id AS region_id_5 FROM cities t0 WHERE t0.city_id = ?
SELECT t0.transporter_id AS transporter_id_1, t0.name_ar AS name_ar_2, t0.name_en AS name_en_3, t0.agreement_type AS agreement_type_4, t0.is_active AS is_active_5, t0.company_id AS company_id_6 FROM transporters t0 WHERE t0.transporter_id = ?
SELECT t0.warehouse_id AS warehouse_id_1, t0.name AS name_2, t0.address AS address_3, t0.telephone AS telephone_4, t0.is_active AS is_active_5, t0.city_id AS city_id_6, t0.company_id AS company_id_7 FROM warehouses t0 WHERE t0.warehouse_id = ?

#▲	Time	Info
1	165.42 ms	SELECT t0.user_id AS user_id_1, t0.username AS username_2, t0.password AS password_3, t0.telephone AS telephone_4, t0.roles AS roles_5, t0.mobile_number AS mobile_number_6, t0.mobile_number2 AS mobile_number2_7, t0.is_mobile_number2_verified AS is_mobile_number2_verified_8, t0.email AS email_9, t0.email_verified AS email_verified_10, t0.verify_token AS verify_token_11, t0.balance AS balance_12, t0.locked_ot_security AS locked_ot_security_13, t0.is_verified AS is_verified_14, t0.is_deleted AS is_deleted_15, t0.is_receive_sms AS is_receive_sms_16, t0.last_login AS last_login_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.profile_origin AS profile_origin_20, t0.signature_path AS signature_path_21, t0.balance_amount AS balance_amount_22, t0.pledge_amount AS pledge_amount_23, t0.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_24, t0.balance_due AS balance_due_25, t0.client_id AS client_id_26, t0.category_id AS category_id_27, t0.company_id AS company_id_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t31.firstname_ar AS firstname_ar_32, t31.secondname_ar AS secondname_ar_33, t31.thirdname_ar AS thirdname_ar_34, t31.fourthname_ar AS fourthname_ar_35, t31.firstname_en AS firstname_en_36, t31.secondname_en AS secondname_en_37, t31.thirdname_en AS thirdname_en_38, t31.fourthname_en AS fourthname_en_39, t31.identification_number AS identification_number_40, t31.gender AS gender_41, t31.expiration_date AS expiration_date_42, t31.expiration_date_hijri AS expiration_date_hijri_43, t31.version_number AS version_number_44, t31.issuer AS issuer_45, t31.date_of_birth AS date_of_birth_46, t31.date_of_birth_hijri AS date_of_birth_hijri_47, t31.occupation AS occupation_48, t31.religion AS religion_49, t31.registry_number AS registry_number_50, t31.registry_authority AS registry_authority_51, t31.registry_hijri_date AS registry_hijri_date_52, t31.employer AS employer_53, t31.image_path AS image_path_54, t31.employer_letter_path AS employer_letter_path_55, t31.country_id AS country_id_56, t31.user_id AS user_id_57, t58.prefix AS prefix_59, t58.suffix AS suffix_60, t58.home_phone AS home_phone_61, t58.business_phone AS business_phone_62, t58.business_fax AS business_fax_63, t58.business_phone2 AS business_phone2_64, t58.company_main_phone AS company_main_phone_65, t58.email2 AS email2_66, t58.web_page AS web_page_67, t58.department AS department_68, t58.job_title AS job_title_69, t58.manager_name AS manager_name_70, t58.business_city AS business_city_71, t58.po_box AS po_box_72, t58.postal_code AS postal_code_73, t58.trn AS trn_74, t58.building_no AS building_no_75, t58.business_street AS business_street_76, t58.district_name AS district_name_77, t58.zip_code AS zip_code_78, t58.additional_no AS additional_no_79, t58.unit_no AS unit_no_80, t58.issue_date_hijri AS issue_date_hijri_81, t58.issue_date AS issue_date_82, t58.birth_city AS birth_city_83, t58.passport_no AS passport_no_84, t58.passport_expiry_date AS passport_expiry_date_85, t58.passport_issue_date AS passport_issue_date_86, t58.soc_insrnc_no AS soc_insrnc_no_87, t58.join_date AS join_date_88, t58.basic_salary AS basic_salary_89, t58.housing_allowance AS housing_allowance_90, t58.soc_insrnc_amount AS soc_insrnc_amount_91, t58.other_allowances AS other_allowances_92, t58.labor_no AS labor_no_93, t58.labor_start_date AS labor_start_date_94, t58.ksa_entry_date AS ksa_entry_date_95, t58.border_no AS border_no_96, t58.work_permit_start_date AS work_permit_start_date_97, t58.work_permit_end_date AS work_permit_end_date_98, t58.med_insrnc_mem_no AS med_insrnc_mem_no_99, t58.national_address_path AS national_address_path_100, t58.passport_path AS passport_path_101, t58.med_insrnc_path AS med_insrnc_path_102, t58.med_insrnc_expiry_date AS med_insrnc_expiry_date_103, t58.classification_id AS classification_id_104, t58.city_id AS city_id_105, t58.user_id AS user_id_106, t107.client_id AS client_id_108, t107.is_active AS is_active_109, t107.company_id AS company_id_110, t107.user_id AS user_id_111 FROM users t0 LEFT JOIN user_identity_info t31 ON t31.user_id = t0.user_id LEFT JOIN user_additional_details t58 ON t58.user_id = t0.user_id LEFT JOIN vehicle_clients t107 ON t107.user_id = t0.user_id WHERE t0.user_id = ? Parameters: [`"0b0913e6-2202-11ed-aa65-0a343ee84526"`] View formatted query View runnable query Explain query SELECT t0.user_id AS user_id_1, t0.username AS username_2, t0.password AS password_3, t0.telephone AS telephone_4, t0.roles AS roles_5, t0.mobile_number AS mobile_number_6, t0.mobile_number2 AS mobile_number2_7, t0.is_mobile_number2_verified AS is_mobile_number2_verified_8, t0.email AS email_9, t0.email_verified AS email_verified_10, t0.verify_token AS verify_token_11, t0.balance AS balance_12, t0.locked_ot_security AS locked_ot_security_13, t0.is_verified AS is_verified_14, t0.is_deleted AS is_deleted_15, t0.is_receive_sms AS is_receive_sms_16, t0.last_login AS last_login_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.profile_origin AS profile_origin_20, t0.signature_path AS signature_path_21, t0.balance_amount AS balance_amount_22, t0.pledge_amount AS pledge_amount_23, t0.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_24, t0.balance_due AS balance_due_25, t0.client_id AS client_id_26, t0.category_id AS category_id_27, t0.company_id AS company_id_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t31.firstname_ar AS firstname_ar_32, t31.secondname_ar AS secondname_ar_33, t31.thirdname_ar AS thirdname_ar_34, t31.fourthname_ar AS fourthname_ar_35, t31.firstname_en AS firstname_en_36, t31.secondname_en AS secondname_en_37, t31.thirdname_en AS thirdname_en_38, t31.fourthname_en AS fourthname_en_39, t31.identification_number AS identification_number_40, t31.gender AS gender_41, t31.expiration_date AS expiration_date_42, t31.expiration_date_hijri AS expiration_date_hijri_43, t31.version_number AS version_number_44, t31.issuer AS issuer_45, t31.date_of_birth AS date_of_birth_46, t31.date_of_birth_hijri AS date_of_birth_hijri_47, t31.occupation AS occupation_48, t31.religion AS religion_49, t31.registry_number AS registry_number_50, t31.registry_authority AS registry_authority_51, t31.registry_hijri_date AS registry_hijri_date_52, t31.employer AS employer_53, t31.image_path AS image_path_54, t31.employer_letter_path AS employer_letter_path_55, t31.country_id AS country_id_56, t31.user_id AS user_id_57, t58.prefix AS prefix_59, t58.suffix AS suffix_60, t58.home_phone AS home_phone_61, t58.business_phone AS business_phone_62, t58.business_fax AS business_fax_63, t58.business_phone2 AS business_phone2_64, t58.company_main_phone AS company_main_phone_65, t58.email2 AS email2_66, t58.web_page AS web_page_67, t58.department AS department_68, t58.job_title AS job_title_69, t58.manager_name AS manager_name_70, t58.business_city AS business_city_71, t58.po_box AS po_box_72, t58.postal_code AS postal_code_73, t58.trn AS trn_74, t58.building_no AS building_no_75, t58.business_street AS business_street_76, t58.district_name AS district_name_77, t58.zip_code AS zip_code_78, t58.additional_no AS additional_no_79, t58.unit_no AS unit_no_80, t58.issue_date_hijri AS issue_date_hijri_81, t58.issue_date AS issue_date_82, t58.birth_city AS birth_city_83, t58.passport_no AS passport_no_84, t58.passport_expiry_date AS passport_expiry_date_85, t58.passport_issue_date AS passport_issue_date_86, t58.soc_insrnc_no AS soc_insrnc_no_87, t58.join_date AS join_date_88, t58.basic_salary AS basic_salary_89, t58.housing_allowance AS housing_allowance_90, t58.soc_insrnc_amount AS soc_insrnc_amount_91, t58.other_allowances AS other_allowances_92, t58.labor_no AS labor_no_93, t58.labor_start_date AS labor_start_date_94, t58.ksa_entry_date AS ksa_entry_date_95, t58.border_no AS border_no_96, t58.work_permit_start_date AS work_permit_start_date_97, t58.work_permit_end_date AS work_permit_end_date_98, t58.med_insrnc_mem_no AS med_insrnc_mem_no_99, t58.national_address_path AS national_address_path_100, t58.passport_path AS passport_path_101, t58.med_insrnc_path AS med_insrnc_path_102, t58.med_insrnc_expiry_date AS med_insrnc_expiry_date_103, t58.classification_id AS classification_id_104, t58.city_id AS city_id_105, t58.user_id AS user_id_106, t107.client_id AS client_id_108, t107.is_active AS is_active_109, t107.company_id AS company_id_110, t107.user_id AS user_id_111 FROM users t0 LEFT JOIN user_identity_info t31 ON t31.user_id = t0.user_id LEFT JOIN user_additional_details t58 ON t58.user_id = t0.user_id LEFT JOIN vehicle_clients t107 ON t107.user_id = t0.user_id WHERE t0.user_id = ? SELECT t0.user_id AS user_id_1, t0.username AS username_2, t0.password AS password_3, t0.telephone AS telephone_4, t0.roles AS roles_5, t0.mobile_number AS mobile_number_6, t0.mobile_number2 AS mobile_number2_7, t0.is_mobile_number2_verified AS is_mobile_number2_verified_8, t0.email AS email_9, t0.email_verified AS email_verified_10, t0.verify_token AS verify_token_11, t0.balance AS balance_12, t0.locked_ot_security AS locked_ot_security_13, t0.is_verified AS is_verified_14, t0.is_deleted AS is_deleted_15, t0.is_receive_sms AS is_receive_sms_16, t0.last_login AS last_login_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.profile_origin AS profile_origin_20, t0.signature_path AS signature_path_21, t0.balance_amount AS balance_amount_22, t0.pledge_amount AS pledge_amount_23, t0.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_24, t0.balance_due AS balance_due_25, t0.client_id AS client_id_26, t0.category_id AS category_id_27, t0.company_id AS company_id_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30, t31.firstname_ar AS firstname_ar_32, t31.secondname_ar AS secondname_ar_33, t31.thirdname_ar AS thirdname_ar_34, t31.fourthname_ar AS fourthname_ar_35, t31.firstname_en AS firstname_en_36, t31.secondname_en AS secondname_en_37, t31.thirdname_en AS thirdname_en_38, t31.fourthname_en AS fourthname_en_39, t31.identification_number AS identification_number_40, t31.gender AS gender_41, t31.expiration_date AS expiration_date_42, t31.expiration_date_hijri AS expiration_date_hijri_43, t31.version_number AS version_number_44, t31.issuer AS issuer_45, t31.date_of_birth AS date_of_birth_46, t31.date_of_birth_hijri AS date_of_birth_hijri_47, t31.occupation AS occupation_48, t31.religion AS religion_49, t31.registry_number AS registry_number_50, t31.registry_authority AS registry_authority_51, t31.registry_hijri_date AS registry_hijri_date_52, t31.employer AS employer_53, t31.image_path AS image_path_54, t31.employer_letter_path AS employer_letter_path_55, t31.country_id AS country_id_56, t31.user_id AS user_id_57, t58.prefix AS prefix_59, t58.suffix AS suffix_60, t58.home_phone AS home_phone_61, t58.business_phone AS business_phone_62, t58.business_fax AS business_fax_63, t58.business_phone2 AS business_phone2_64, t58.company_main_phone AS company_main_phone_65, t58.email2 AS email2_66, t58.web_page AS web_page_67, t58.department AS department_68, t58.job_title AS job_title_69, t58.manager_name AS manager_name_70, t58.business_city AS business_city_71, t58.po_box AS po_box_72, t58.postal_code AS postal_code_73, t58.trn AS trn_74, t58.building_no AS building_no_75, t58.business_street AS business_street_76, t58.district_name AS district_name_77, t58.zip_code AS zip_code_78, t58.additional_no AS additional_no_79, t58.unit_no AS unit_no_80, t58.issue_date_hijri AS issue_date_hijri_81, t58.issue_date AS issue_date_82, t58.birth_city AS birth_city_83, t58.passport_no AS passport_no_84, t58.passport_expiry_date AS passport_expiry_date_85, t58.passport_issue_date AS passport_issue_date_86, t58.soc_insrnc_no AS soc_insrnc_no_87, t58.join_date AS join_date_88, t58.basic_salary AS basic_salary_89, t58.housing_allowance AS housing_allowance_90, t58.soc_insrnc_amount AS soc_insrnc_amount_91, t58.other_allowances AS other_allowances_92, t58.labor_no AS labor_no_93, t58.labor_start_date AS labor_start_date_94, t58.ksa_entry_date AS ksa_entry_date_95, t58.border_no AS border_no_96, t58.work_permit_start_date AS work_permit_start_date_97, t58.work_permit_end_date AS work_permit_end_date_98, t58.med_insrnc_mem_no AS med_insrnc_mem_no_99, t58.national_address_path AS national_address_path_100, t58.passport_path AS passport_path_101, t58.med_insrnc_path AS med_insrnc_path_102, t58.med_insrnc_expiry_date AS med_insrnc_expiry_date_103, t58.classification_id AS classification_id_104, t58.city_id AS city_id_105, t58.user_id AS user_id_106, t107.client_id AS client_id_108, t107.is_active AS is_active_109, t107.company_id AS company_id_110, t107.user_id AS user_id_111 FROM users t0 LEFT JOIN user_identity_info t31 ON t31.user_id = t0.user_id LEFT JOIN user_additional_details t58 ON t58.user_id = t0.user_id LEFT JOIN vehicle_clients t107 ON t107.user_id = t0.user_id WHERE t0.user_id = '0b0913e6-2202-11ed-aa65-0a343ee84526';
2	19.96 ms	SELECT t0.vehicle_id AS vehicle_id_1, t0.state AS state_2, t0.vehicle_number AS vehicle_number_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.situation AS situation_6, t0.offerability_for_sale AS offerability_for_sale_7, t0.status AS status_8, t0.is_deleted AS is_deleted_9, t0.is_approved AS is_approved_10, t0.inspection_expiration_date AS inspection_expiration_date_11, t0.insurance_start_date AS insurance_start_date_12, t0.insurance_expiry_date AS insurance_expiry_date_13, t0.exit_date AS exit_date_14, t0.receiving_at AS receiving_at_15, t0.approved_by AS approved_by_16, t0.created_by AS created_by_17, t0.parent_vehicle_id AS parent_vehicle_id_18, t0.updated_by AS updated_by_19, t20.vin_number AS vin_number_21, t20.panel_numbers AS panel_numbers_22, t20.weight AS weight_23, t20.vehicle_load AS vehicle_load_24, t20.manufacturing_year AS manufacturing_year_25, t20.serial_number AS serial_number_26, t20.license_expiry_date AS license_expiry_date_27, t20.license_expiry_date_hijri AS license_expiry_date_hijri_28, t20.vehicle_id AS vehicle_id_29, t20.color_id AS color_id_30, t20.registration_doc_id AS registration_doc_id_31, t20.panel_letter1 AS panel_letter1_32, t20.panel_letter2 AS panel_letter2_33, t20.panel_letter3 AS panel_letter3_34, t20.model_id AS model_id_35, t20.registration_type_id AS registration_type_id_36, t20.vehicle_id AS vehicle_id_37, t20.vehicle_owner_id AS vehicle_owner_id_38, t20.vehicle_user_id AS vehicle_user_id_39, t40.historical_info AS historical_info_41, t40.description_ar AS description_ar_42, t40.description_en AS description_en_43, t40.body_type AS body_type_44, t40.vehicle_status AS vehicle_status_45, t40.vehicle_condition AS vehicle_condition_46, t40.transmission AS transmission_47, t40.fuel AS fuel_48, t40.condition_report_path AS condition_report_path_49, t40.estimate_value AS estimate_value_50, t40.is_repairable AS is_repairable_51, t40.repair_required_time AS repair_required_time_52, t40.repair_cost AS repair_cost_53, t40.value_after_repair AS value_after_repair_54, t40.created_at AS created_at_55, t40.updated_at AS updated_at_56, t40.old_panel_numbers AS old_panel_numbers_57, t40.manufacturer_country_id AS manufacturer_country_id_58, t40.odometer_range_id AS odometer_range_id_59, t40.vehicle_id AS vehicle_id_60, t40.created_by AS created_by_61, t40.updated_by AS updated_by_62, t40.old_panel_letter1 AS old_panel_letter1_63, t40.old_panel_letter2 AS old_panel_letter2_64, t40.old_panel_letter3 AS old_panel_letter3_65, t66.beneficiary_vehicle_number AS beneficiary_vehicle_number_67, t66.compensation_amount AS compensation_amount_68, t66.created_at AS created_at_69, t66.updated_at AS updated_at_70, t66.vehicle_id AS vehicle_id_71, t66.beneficiary_id AS beneficiary_id_72, t66.owner_payment_doc_id AS owner_payment_doc_id_73, t66.purchase_supplier_invoice_id AS purchase_supplier_invoice_id_74, t66.created_by AS created_by_75, t66.updated_by AS updated_by_76, t66.vehicle_id AS vehicle_id_77 FROM vehicles t0 LEFT JOIN vehicle_registrations t20 ON t20.vehicle_id = t0.vehicle_id LEFT JOIN vehicle_technical_specs t40 ON t40.vehicle_id = t0.vehicle_id LEFT JOIN vehicle_beneficiary_details t66 ON t66.vehicle_id = t0.vehicle_id WHERE t0.vehicle_id = ? Parameters: [`"19642"`] View formatted query View runnable query Explain query SELECT t0.vehicle_id AS vehicle_id_1, t0.state AS state_2, t0.vehicle_number AS vehicle_number_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.situation AS situation_6, t0.offerability_for_sale AS offerability_for_sale_7, t0.status AS status_8, t0.is_deleted AS is_deleted_9, t0.is_approved AS is_approved_10, t0.inspection_expiration_date AS inspection_expiration_date_11, t0.insurance_start_date AS insurance_start_date_12, t0.insurance_expiry_date AS insurance_expiry_date_13, t0.exit_date AS exit_date_14, t0.receiving_at AS receiving_at_15, t0.approved_by AS approved_by_16, t0.created_by AS created_by_17, t0.parent_vehicle_id AS parent_vehicle_id_18, t0.updated_by AS updated_by_19, t20.vin_number AS vin_number_21, t20.panel_numbers AS panel_numbers_22, t20.weight AS weight_23, t20.vehicle_load AS vehicle_load_24, t20.manufacturing_year AS manufacturing_year_25, t20.serial_number AS serial_number_26, t20.license_expiry_date AS license_expiry_date_27, t20.license_expiry_date_hijri AS license_expiry_date_hijri_28, t20.vehicle_id AS vehicle_id_29, t20.color_id AS color_id_30, t20.registration_doc_id AS registration_doc_id_31, t20.panel_letter1 AS panel_letter1_32, t20.panel_letter2 AS panel_letter2_33, t20.panel_letter3 AS panel_letter3_34, t20.model_id AS model_id_35, t20.registration_type_id AS registration_type_id_36, t20.vehicle_id AS vehicle_id_37, t20.vehicle_owner_id AS vehicle_owner_id_38, t20.vehicle_user_id AS vehicle_user_id_39, t40.historical_info AS historical_info_41, t40.description_ar AS description_ar_42, t40.description_en AS description_en_43, t40.body_type AS body_type_44, t40.vehicle_status AS vehicle_status_45, t40.vehicle_condition AS vehicle_condition_46, t40.transmission AS transmission_47, t40.fuel AS fuel_48, t40.condition_report_path AS condition_report_path_49, t40.estimate_value AS estimate_value_50, t40.is_repairable AS is_repairable_51, t40.repair_required_time AS repair_required_time_52, t40.repair_cost AS repair_cost_53, t40.value_after_repair AS value_after_repair_54, t40.created_at AS created_at_55, t40.updated_at AS updated_at_56, t40.old_panel_numbers AS old_panel_numbers_57, t40.manufacturer_country_id AS manufacturer_country_id_58, t40.odometer_range_id AS odometer_range_id_59, t40.vehicle_id AS vehicle_id_60, t40.created_by AS created_by_61, t40.updated_by AS updated_by_62, t40.old_panel_letter1 AS old_panel_letter1_63, t40.old_panel_letter2 AS old_panel_letter2_64, t40.old_panel_letter3 AS old_panel_letter3_65, t66.beneficiary_vehicle_number AS beneficiary_vehicle_number_67, t66.compensation_amount AS compensation_amount_68, t66.created_at AS created_at_69, t66.updated_at AS updated_at_70, t66.vehicle_id AS vehicle_id_71, t66.beneficiary_id AS beneficiary_id_72, t66.owner_payment_doc_id AS owner_payment_doc_id_73, t66.purchase_supplier_invoice_id AS purchase_supplier_invoice_id_74, t66.created_by AS created_by_75, t66.updated_by AS updated_by_76, t66.vehicle_id AS vehicle_id_77 FROM vehicles t0 LEFT JOIN vehicle_registrations t20 ON t20.vehicle_id = t0.vehicle_id LEFT JOIN vehicle_technical_specs t40 ON t40.vehicle_id = t0.vehicle_id LEFT JOIN vehicle_beneficiary_details t66 ON t66.vehicle_id = t0.vehicle_id WHERE t0.vehicle_id = ? SELECT t0.vehicle_id AS vehicle_id_1, t0.state AS state_2, t0.vehicle_number AS vehicle_number_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.situation AS situation_6, t0.offerability_for_sale AS offerability_for_sale_7, t0.status AS status_8, t0.is_deleted AS is_deleted_9, t0.is_approved AS is_approved_10, t0.inspection_expiration_date AS inspection_expiration_date_11, t0.insurance_start_date AS insurance_start_date_12, t0.insurance_expiry_date AS insurance_expiry_date_13, t0.exit_date AS exit_date_14, t0.receiving_at AS receiving_at_15, t0.approved_by AS approved_by_16, t0.created_by AS created_by_17, t0.parent_vehicle_id AS parent_vehicle_id_18, t0.updated_by AS updated_by_19, t20.vin_number AS vin_number_21, t20.panel_numbers AS panel_numbers_22, t20.weight AS weight_23, t20.vehicle_load AS vehicle_load_24, t20.manufacturing_year AS manufacturing_year_25, t20.serial_number AS serial_number_26, t20.license_expiry_date AS license_expiry_date_27, t20.license_expiry_date_hijri AS license_expiry_date_hijri_28, t20.vehicle_id AS vehicle_id_29, t20.color_id AS color_id_30, t20.registration_doc_id AS registration_doc_id_31, t20.panel_letter1 AS panel_letter1_32, t20.panel_letter2 AS panel_letter2_33, t20.panel_letter3 AS panel_letter3_34, t20.model_id AS model_id_35, t20.registration_type_id AS registration_type_id_36, t20.vehicle_id AS vehicle_id_37, t20.vehicle_owner_id AS vehicle_owner_id_38, t20.vehicle_user_id AS vehicle_user_id_39, t40.historical_info AS historical_info_41, t40.description_ar AS description_ar_42, t40.description_en AS description_en_43, t40.body_type AS body_type_44, t40.vehicle_status AS vehicle_status_45, t40.vehicle_condition AS vehicle_condition_46, t40.transmission AS transmission_47, t40.fuel AS fuel_48, t40.condition_report_path AS condition_report_path_49, t40.estimate_value AS estimate_value_50, t40.is_repairable AS is_repairable_51, t40.repair_required_time AS repair_required_time_52, t40.repair_cost AS repair_cost_53, t40.value_after_repair AS value_after_repair_54, t40.created_at AS created_at_55, t40.updated_at AS updated_at_56, t40.old_panel_numbers AS old_panel_numbers_57, t40.manufacturer_country_id AS manufacturer_country_id_58, t40.odometer_range_id AS odometer_range_id_59, t40.vehicle_id AS vehicle_id_60, t40.created_by AS created_by_61, t40.updated_by AS updated_by_62, t40.old_panel_letter1 AS old_panel_letter1_63, t40.old_panel_letter2 AS old_panel_letter2_64, t40.old_panel_letter3 AS old_panel_letter3_65, t66.beneficiary_vehicle_number AS beneficiary_vehicle_number_67, t66.compensation_amount AS compensation_amount_68, t66.created_at AS created_at_69, t66.updated_at AS updated_at_70, t66.vehicle_id AS vehicle_id_71, t66.beneficiary_id AS beneficiary_id_72, t66.owner_payment_doc_id AS owner_payment_doc_id_73, t66.purchase_supplier_invoice_id AS purchase_supplier_invoice_id_74, t66.created_by AS created_by_75, t66.updated_by AS updated_by_76, t66.vehicle_id AS vehicle_id_77 FROM vehicles t0 LEFT JOIN vehicle_registrations t20 ON t20.vehicle_id = t0.vehicle_id LEFT JOIN vehicle_technical_specs t40 ON t40.vehicle_id = t0.vehicle_id LEFT JOIN vehicle_beneficiary_details t66 ON t66.vehicle_id = t0.vehicle_id WHERE t0.vehicle_id = '19642';
3	5.75 ms	SELECT v0_.request_id AS request_id_0, v0_.request_type AS request_type_1, v0_.is_estimate_val_requested AS is_estimate_val_requested_2, v0_.request_date AS request_date_3, v0_.revoke_cancellation_notes AS revoke_cancellation_notes_4, v0_.is_rejected AS is_rejected_5, v0_.rejection_reason AS rejection_reason_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_9, v0_.auth_image_path AS auth_image_path_10, v0_.estimate_image_path AS estimate_image_path_11, v0_.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_12, v0_.created_by AS created_by_13, v0_.updated_by AS updated_by_14, v0_.vehicle_id AS vehicle_id_15 FROM vehicle_revoke_requests v0_ WHERE v0_.vehicle_id = ? ORDER BY v0_.created_at DESC Parameters: [`"19642"`] View formatted query View runnable query Explain query SELECT v0_.request_id AS request_id_0, v0_.request_type AS request_type_1, v0_.is_estimate_val_requested AS is_estimate_val_requested_2, v0_.request_date AS request_date_3, v0_.revoke_cancellation_notes AS revoke_cancellation_notes_4, v0_.is_rejected AS is_rejected_5, v0_.rejection_reason AS rejection_reason_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_9, v0_.auth_image_path AS auth_image_path_10, v0_.estimate_image_path AS estimate_image_path_11, v0_.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_12, v0_.created_by AS created_by_13, v0_.updated_by AS updated_by_14, v0_.vehicle_id AS vehicle_id_15 FROM vehicle_revoke_requests v0_ WHERE v0_.vehicle_id = ? ORDER BY v0_.created_at DESC SELECT v0_.request_id AS request_id_0, v0_.request_type AS request_type_1, v0_.is_estimate_val_requested AS is_estimate_val_requested_2, v0_.request_date AS request_date_3, v0_.revoke_cancellation_notes AS revoke_cancellation_notes_4, v0_.is_rejected AS is_rejected_5, v0_.rejection_reason AS rejection_reason_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_9, v0_.auth_image_path AS auth_image_path_10, v0_.estimate_image_path AS estimate_image_path_11, v0_.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_12, v0_.created_by AS created_by_13, v0_.updated_by AS updated_by_14, v0_.vehicle_id AS vehicle_id_15 FROM vehicle_revoke_requests v0_ WHERE v0_.vehicle_id = '19642' ORDER BY v0_.created_at DESC;
4	17.23 ms	SELECT t0.address AS address_1, t0.responsible_person_name AS responsible_person_name_2, t0.responsible_person_mob_num AS responsible_person_mob_num_3, t0.responsible_person_mob_num2 AS responsible_person_mob_num2_4, t0.responsible_person_mob_num3 AS responsible_person_mob_num3_5, t0.request_id AS request_id_6, t0.city_id AS city_id_7, t0.request_id AS request_id_8 FROM vehicle_revoke_request_source t0 WHERE t0.request_id = ? Parameters: [`11014`] View formatted query View runnable query Explain query SELECT t0.address AS address_1, t0.responsible_person_name AS responsible_person_name_2, t0.responsible_person_mob_num AS responsible_person_mob_num_3, t0.responsible_person_mob_num2 AS responsible_person_mob_num2_4, t0.responsible_person_mob_num3 AS responsible_person_mob_num3_5, t0.request_id AS request_id_6, t0.city_id AS city_id_7, t0.request_id AS request_id_8 FROM vehicle_revoke_request_source t0 WHERE t0.request_id = ? SELECT t0.address AS address_1, t0.responsible_person_name AS responsible_person_name_2, t0.responsible_person_mob_num AS responsible_person_mob_num_3, t0.responsible_person_mob_num2 AS responsible_person_mob_num2_4, t0.responsible_person_mob_num3 AS responsible_person_mob_num3_5, t0.request_id AS request_id_6, t0.city_id AS city_id_7, t0.request_id AS request_id_8 FROM vehicle_revoke_request_source t0 WHERE t0.request_id = 11014;
5	2.15 ms	SELECT t0.address AS address_1, t0.responsible_person_name AS responsible_person_name_2, t0.responsible_person_mob_num AS responsible_person_mob_num_3, t0.request_id AS request_id_4, t0.city_id AS city_id_5, t0.request_id AS request_id_6 FROM vehicle_revoke_request_destination t0 WHERE t0.request_id = ? Parameters: [`11014`] View formatted query View runnable query Explain query SELECT t0.address AS address_1, t0.responsible_person_name AS responsible_person_name_2, t0.responsible_person_mob_num AS responsible_person_mob_num_3, t0.request_id AS request_id_4, t0.city_id AS city_id_5, t0.request_id AS request_id_6 FROM vehicle_revoke_request_destination t0 WHERE t0.request_id = ? SELECT t0.address AS address_1, t0.responsible_person_name AS responsible_person_name_2, t0.responsible_person_mob_num AS responsible_person_mob_num_3, t0.request_id AS request_id_4, t0.city_id AS city_id_5, t0.request_id AS request_id_6 FROM vehicle_revoke_request_destination t0 WHERE t0.request_id = 11014;
6	6.66 ms	SELECT v0_.activity_id AS activity_id_0, v0_.activity_type AS activity_type_1, v0_.is_include_revoke AS is_include_revoke_2, v0_.notes AS notes_3, v0_.activity_date AS activity_date_4, v0_.created_at AS created_at_5, v0_.updated_at AS updated_at_6, v0_.is_deleted AS is_deleted_7, v0_.created_by AS created_by_8, v0_.updated_by AS updated_by_9, v0_.revoke_request_id AS revoke_request_id_10, v0_.vehicle_id AS vehicle_id_11 FROM vehicle_rts_activities v0_ WHERE v0_.vehicle_id = ? ORDER BY v0_.created_at DESC Parameters: [`"19642"`] View formatted query View runnable query Explain query SELECT v0_.activity_id AS activity_id_0, v0_.activity_type AS activity_type_1, v0_.is_include_revoke AS is_include_revoke_2, v0_.notes AS notes_3, v0_.activity_date AS activity_date_4, v0_.created_at AS created_at_5, v0_.updated_at AS updated_at_6, v0_.is_deleted AS is_deleted_7, v0_.created_by AS created_by_8, v0_.updated_by AS updated_by_9, v0_.revoke_request_id AS revoke_request_id_10, v0_.vehicle_id AS vehicle_id_11 FROM vehicle_rts_activities v0_ WHERE v0_.vehicle_id = ? ORDER BY v0_.created_at DESC SELECT v0_.activity_id AS activity_id_0, v0_.activity_type AS activity_type_1, v0_.is_include_revoke AS is_include_revoke_2, v0_.notes AS notes_3, v0_.activity_date AS activity_date_4, v0_.created_at AS created_at_5, v0_.updated_at AS updated_at_6, v0_.is_deleted AS is_deleted_7, v0_.created_by AS created_by_8, v0_.updated_by AS updated_by_9, v0_.revoke_request_id AS revoke_request_id_10, v0_.vehicle_id AS vehicle_id_11 FROM vehicle_rts_activities v0_ WHERE v0_.vehicle_id = '19642' ORDER BY v0_.created_at DESC;
7	5.57 ms	SELECT c0_.delegation_id AS delegation_id_0, c0_.relationship AS relationship_1, c0_.image_path AS image_path_2, c0_.approval_status AS approval_status_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, v1_.client_id AS client_id_6, v1_.is_active AS is_active_7, c2_.company_id AS company_id_8, c2_.shortname_ar AS shortname_ar_9, c2_.shortname_en AS shortname_en_10, c2_.building_no AS building_no_11, c2_.unit_no AS unit_no_12, c2_.street_name_ar AS street_name_ar_13, c2_.street_name_en AS street_name_en_14, c2_.district_name_ar AS district_name_ar_15, c2_.district_name_en AS district_name_en_16, c2_.zip_code AS zip_code_17, c2_.additional_no AS additional_no_18, c2_.universal_no AS universal_no_19, c2_.sms AS sms_20, c2_.email AS email_21, c2_.email2 AS email2_22, c2_.website AS website_23, c2_.trade_chamber_no AS trade_chamber_no_24, c2_.client_id AS client_id_25, c2_.vat_no AS vat_no_26, c2_.social_insurance_no AS social_insurance_no_27, c2_.labour_institution_no AS labour_institution_no_28, c2_.balance AS balance_29, c2_.locked_ot_security AS locked_ot_security_30, c2_.zakat_id_no AS zakat_id_no_31, c2_.municipality_license_no AS municipality_license_no_32, c2_.seal_path AS seal_path_33, c2_.logo_path AS logo_path_34, c2_.signature_path AS signature_path_35, c2_.is_beneficiary AS is_beneficiary_36, c2_.is_tjr_co AS is_tjr_co_37, c2_.is_bank AS is_bank_38, c2_.created_at AS created_at_39, c2_.updated_at AS updated_at_40, c2_.bank_code AS bank_code_41, c2_.balance_amount AS balance_amount_42, c2_.pledge_amount AS pledge_amount_43, c2_.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_44, c2_.balance_due AS balance_due_45, u3_.user_id AS user_id_46, u3_.username AS username_47, u3_.password AS password_48, u3_.telephone AS telephone_49, u3_.roles AS roles_50, u3_.mobile_number AS mobile_number_51, u3_.mobile_number2 AS mobile_number2_52, u3_.is_mobile_number2_verified AS is_mobile_number2_verified_53, u3_.email AS email_54, u3_.email_verified AS email_verified_55, u3_.verify_token AS verify_token_56, u3_.balance AS balance_57, u3_.locked_ot_security AS locked_ot_security_58, u3_.is_verified AS is_verified_59, u3_.is_deleted AS is_deleted_60, u3_.is_receive_sms AS is_receive_sms_61, u3_.last_login AS last_login_62, u3_.created_at AS created_at_63, u3_.updated_at AS updated_at_64, u3_.profile_origin AS profile_origin_65, u3_.signature_path AS signature_path_66, u3_.balance_amount AS balance_amount_67, u3_.pledge_amount AS pledge_amount_68, u3_.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_69, u3_.balance_due AS balance_due_70, u3_.client_id AS client_id_71, c0_.delegator_id AS delegator_id_72, c0_.delegated_id AS delegated_id_73, c0_.created_by AS created_by_74, c0_.updated_by AS updated_by_75, v1_.company_id AS company_id_76, v1_.user_id AS user_id_77, c2_.classification_id AS classification_id_78, c2_.city_id AS city_id_79, c2_.created_by AS created_by_80, c2_.updated_by AS updated_by_81, c2_.category_id AS category_id_82, u3_.category_id AS category_id_83, u3_.company_id AS company_id_84, u3_.created_by AS created_by_85, u3_.updated_by AS updated_by_86 FROM clients_delegation c0_ LEFT JOIN vehicle_clients v1_ ON c0_.delegator_id = v1_.client_id LEFT JOIN companies c2_ ON v1_.company_id = c2_.company_id LEFT JOIN users u3_ ON v1_.user_id = u3_.user_id WHERE c0_.delegated_id = ? AND c0_.approval_status = ? Parameters: [`"0b0913e6-2202-11ed-aa65-0a343ee84526" "approved"`] View formatted query View runnable query Explain query SELECT c0_.delegation_id AS delegation_id_0, c0_.relationship AS relationship_1, c0_.image_path AS image_path_2, c0_.approval_status AS approval_status_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, v1_.client_id AS client_id_6, v1_.is_active AS is_active_7, c2_.company_id AS company_id_8, c2_.shortname_ar AS shortname_ar_9, c2_.shortname_en AS shortname_en_10, c2_.building_no AS building_no_11, c2_.unit_no AS unit_no_12, c2_.street_name_ar AS street_name_ar_13, c2_.street_name_en AS street_name_en_14, c2_.district_name_ar AS district_name_ar_15, c2_.district_name_en AS district_name_en_16, c2_.zip_code AS zip_code_17, c2_.additional_no AS additional_no_18, c2_.universal_no AS universal_no_19, c2_.sms AS sms_20, c2_.email AS email_21, c2_.email2 AS email2_22, c2_.website AS website_23, c2_.trade_chamber_no AS trade_chamber_no_24, c2_.client_id AS client_id_25, c2_.vat_no AS vat_no_26, c2_.social_insurance_no AS social_insurance_no_27, c2_.labour_institution_no AS labour_institution_no_28, c2_.balance AS balance_29, c2_.locked_ot_security AS locked_ot_security_30, c2_.zakat_id_no AS zakat_id_no_31, c2_.municipality_license_no AS municipality_license_no_32, c2_.seal_path AS seal_path_33, c2_.logo_path AS logo_path_34, c2_.signature_path AS signature_path_35, c2_.is_beneficiary AS is_beneficiary_36, c2_.is_tjr_co AS is_tjr_co_37, c2_.is_bank AS is_bank_38, c2_.created_at AS created_at_39, c2_.updated_at AS updated_at_40, c2_.bank_code AS bank_code_41, c2_.balance_amount AS balance_amount_42, c2_.pledge_amount AS pledge_amount_43, c2_.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_44, c2_.balance_due AS balance_due_45, u3_.user_id AS user_id_46, u3_.username AS username_47, u3_.password AS password_48, u3_.telephone AS telephone_49, u3_.roles AS roles_50, u3_.mobile_number AS mobile_number_51, u3_.mobile_number2 AS mobile_number2_52, u3_.is_mobile_number2_verified AS is_mobile_number2_verified_53, u3_.email AS email_54, u3_.email_verified AS email_verified_55, u3_.verify_token AS verify_token_56, u3_.balance AS balance_57, u3_.locked_ot_security AS locked_ot_security_58, u3_.is_verified AS is_verified_59, u3_.is_deleted AS is_deleted_60, u3_.is_receive_sms AS is_receive_sms_61, u3_.last_login AS last_login_62, u3_.created_at AS created_at_63, u3_.updated_at AS updated_at_64, u3_.profile_origin AS profile_origin_65, u3_.signature_path AS signature_path_66, u3_.balance_amount AS balance_amount_67, u3_.pledge_amount AS pledge_amount_68, u3_.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_69, u3_.balance_due AS balance_due_70, u3_.client_id AS client_id_71, c0_.delegator_id AS delegator_id_72, c0_.delegated_id AS delegated_id_73, c0_.created_by AS created_by_74, c0_.updated_by AS updated_by_75, v1_.company_id AS company_id_76, v1_.user_id AS user_id_77, c2_.classification_id AS classification_id_78, c2_.city_id AS city_id_79, c2_.created_by AS created_by_80, c2_.updated_by AS updated_by_81, c2_.category_id AS category_id_82, u3_.category_id AS category_id_83, u3_.company_id AS company_id_84, u3_.created_by AS created_by_85, u3_.updated_by AS updated_by_86 FROM clients_delegation c0_ LEFT JOIN vehicle_clients v1_ ON c0_.delegator_id = v1_.client_id LEFT JOIN companies c2_ ON v1_.company_id = c2_.company_id LEFT JOIN users u3_ ON v1_.user_id = u3_.user_id WHERE c0_.delegated_id = ? AND c0_.approval_status = ? SELECT c0_.delegation_id AS delegation_id_0, c0_.relationship AS relationship_1, c0_.image_path AS image_path_2, c0_.approval_status AS approval_status_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, v1_.client_id AS client_id_6, v1_.is_active AS is_active_7, c2_.company_id AS company_id_8, c2_.shortname_ar AS shortname_ar_9, c2_.shortname_en AS shortname_en_10, c2_.building_no AS building_no_11, c2_.unit_no AS unit_no_12, c2_.street_name_ar AS street_name_ar_13, c2_.street_name_en AS street_name_en_14, c2_.district_name_ar AS district_name_ar_15, c2_.district_name_en AS district_name_en_16, c2_.zip_code AS zip_code_17, c2_.additional_no AS additional_no_18, c2_.universal_no AS universal_no_19, c2_.sms AS sms_20, c2_.email AS email_21, c2_.email2 AS email2_22, c2_.website AS website_23, c2_.trade_chamber_no AS trade_chamber_no_24, c2_.client_id AS client_id_25, c2_.vat_no AS vat_no_26, c2_.social_insurance_no AS social_insurance_no_27, c2_.labour_institution_no AS labour_institution_no_28, c2_.balance AS balance_29, c2_.locked_ot_security AS locked_ot_security_30, c2_.zakat_id_no AS zakat_id_no_31, c2_.municipality_license_no AS municipality_license_no_32, c2_.seal_path AS seal_path_33, c2_.logo_path AS logo_path_34, c2_.signature_path AS signature_path_35, c2_.is_beneficiary AS is_beneficiary_36, c2_.is_tjr_co AS is_tjr_co_37, c2_.is_bank AS is_bank_38, c2_.created_at AS created_at_39, c2_.updated_at AS updated_at_40, c2_.bank_code AS bank_code_41, c2_.balance_amount AS balance_amount_42, c2_.pledge_amount AS pledge_amount_43, c2_.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_44, c2_.balance_due AS balance_due_45, u3_.user_id AS user_id_46, u3_.username AS username_47, u3_.password AS password_48, u3_.telephone AS telephone_49, u3_.roles AS roles_50, u3_.mobile_number AS mobile_number_51, u3_.mobile_number2 AS mobile_number2_52, u3_.is_mobile_number2_verified AS is_mobile_number2_verified_53, u3_.email AS email_54, u3_.email_verified AS email_verified_55, u3_.verify_token AS verify_token_56, u3_.balance AS balance_57, u3_.locked_ot_security AS locked_ot_security_58, u3_.is_verified AS is_verified_59, u3_.is_deleted AS is_deleted_60, u3_.is_receive_sms AS is_receive_sms_61, u3_.last_login AS last_login_62, u3_.created_at AS created_at_63, u3_.updated_at AS updated_at_64, u3_.profile_origin AS profile_origin_65, u3_.signature_path AS signature_path_66, u3_.balance_amount AS balance_amount_67, u3_.pledge_amount AS pledge_amount_68, u3_.reserved_for_ownership_transfer AS reserved_for_ownership_transfer_69, u3_.balance_due AS balance_due_70, u3_.client_id AS client_id_71, c0_.delegator_id AS delegator_id_72, c0_.delegated_id AS delegated_id_73, c0_.created_by AS created_by_74, c0_.updated_by AS updated_by_75, v1_.company_id AS company_id_76, v1_.user_id AS user_id_77, c2_.classification_id AS classification_id_78, c2_.city_id AS city_id_79, c2_.created_by AS created_by_80, c2_.updated_by AS updated_by_81, c2_.category_id AS category_id_82, u3_.category_id AS category_id_83, u3_.company_id AS company_id_84, u3_.created_by AS created_by_85, u3_.updated_by AS updated_by_86 FROM clients_delegation c0_ LEFT JOIN vehicle_clients v1_ ON c0_.delegator_id = v1_.client_id LEFT JOIN companies c2_ ON v1_.company_id = c2_.company_id LEFT JOIN users u3_ ON v1_.user_id = u3_.user_id WHERE c0_.delegated_id = '0b0913e6-2202-11ed-aa65-0a343ee84526' AND c0_.approval_status = 'approved';
8	1.98 ms	SELECT t0.letter_code AS letter_code_1, t0.letter_ar AS letter_ar_2, t0.letter_en AS letter_en_3 FROM panel_letters t0 WHERE t0.letter_code = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.letter_code AS letter_code_1, t0.letter_ar AS letter_ar_2, t0.letter_en AS letter_en_3 FROM panel_letters t0 WHERE t0.letter_code = ? SELECT t0.letter_code AS letter_code_1, t0.letter_ar AS letter_ar_2, t0.letter_en AS letter_en_3 FROM panel_letters t0 WHERE t0.letter_code = 4;
9	1.40 ms	SELECT t0.letter_code AS letter_code_1, t0.letter_ar AS letter_ar_2, t0.letter_en AS letter_en_3 FROM panel_letters t0 WHERE t0.letter_code = ? Parameters: [`14`] View formatted query View runnable query Explain query SELECT t0.letter_code AS letter_code_1, t0.letter_ar AS letter_ar_2, t0.letter_en AS letter_en_3 FROM panel_letters t0 WHERE t0.letter_code = ? SELECT t0.letter_code AS letter_code_1, t0.letter_ar AS letter_ar_2, t0.letter_en AS letter_en_3 FROM panel_letters t0 WHERE t0.letter_code = 14;
10	1.83 ms	SELECT t0.letter_code AS letter_code_1, t0.letter_ar AS letter_ar_2, t0.letter_en AS letter_en_3 FROM panel_letters t0 WHERE t0.letter_code = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.letter_code AS letter_code_1, t0.letter_ar AS letter_ar_2, t0.letter_en AS letter_en_3 FROM panel_letters t0 WHERE t0.letter_code = ? SELECT t0.letter_code AS letter_code_1, t0.letter_ar AS letter_ar_2, t0.letter_en AS letter_en_3 FROM panel_letters t0 WHERE t0.letter_code = 3;
11	2.36 ms	SELECT v0_.sale_id AS sale_id_0, v0_.renunciation_letter_no AS renunciation_letter_no_1, v0_.seller_price AS seller_price_2, v0_.is_cancelled AS is_cancelled_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5, v0_.is_deleted AS is_deleted_6, v0_.sold_by AS sold_by_7, v0_.value_for_tax AS value_for_tax_8, v0_.vat_amount_for_tax AS vat_amount_for_tax_9, v0_.total_for_tax AS total_for_tax_10, v0_.payed_at AS payed_at_11, v0_.buyer_id AS buyer_id_12, v0_.invoice_id AS invoice_id_13, v0_.created_by AS created_by_14, v0_.ot_sec_transaction_id AS ot_sec_transaction_id_15, v0_.updated_by AS updated_by_16, v0_.vehicle_id AS vehicle_id_17, v0_.vat_for_tax_rate_id AS vat_for_tax_rate_id_18 FROM vehicle_sales v0_ INNER JOIN invoices i1_ ON v0_.invoice_id = i1_.invoice_id INNER JOIN account_transactions a2_ ON i1_.transaction_id = a2_.transaction_id WHERE v0_.vehicle_id = ? AND a2_.status_id = ? AND v0_.is_cancelled <> 1 Parameters: [`19642 9`] View formatted query View runnable query Explain query SELECT v0_.sale_id AS sale_id_0, v0_.renunciation_letter_no AS renunciation_letter_no_1, v0_.seller_price AS seller_price_2, v0_.is_cancelled AS is_cancelled_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5, v0_.is_deleted AS is_deleted_6, v0_.sold_by AS sold_by_7, v0_.value_for_tax AS value_for_tax_8, v0_.vat_amount_for_tax AS vat_amount_for_tax_9, v0_.total_for_tax AS total_for_tax_10, v0_.payed_at AS payed_at_11, v0_.buyer_id AS buyer_id_12, v0_.invoice_id AS invoice_id_13, v0_.created_by AS created_by_14, v0_.ot_sec_transaction_id AS ot_sec_transaction_id_15, v0_.updated_by AS updated_by_16, v0_.vehicle_id AS vehicle_id_17, v0_.vat_for_tax_rate_id AS vat_for_tax_rate_id_18 FROM vehicle_sales v0_ INNER JOIN invoices i1_ ON v0_.invoice_id = i1_.invoice_id INNER JOIN account_transactions a2_ ON i1_.transaction_id = a2_.transaction_id WHERE v0_.vehicle_id = ? AND a2_.status_id = ? AND v0_.is_cancelled <> 1 SELECT v0_.sale_id AS sale_id_0, v0_.renunciation_letter_no AS renunciation_letter_no_1, v0_.seller_price AS seller_price_2, v0_.is_cancelled AS is_cancelled_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5, v0_.is_deleted AS is_deleted_6, v0_.sold_by AS sold_by_7, v0_.value_for_tax AS value_for_tax_8, v0_.vat_amount_for_tax AS vat_amount_for_tax_9, v0_.total_for_tax AS total_for_tax_10, v0_.payed_at AS payed_at_11, v0_.buyer_id AS buyer_id_12, v0_.invoice_id AS invoice_id_13, v0_.created_by AS created_by_14, v0_.ot_sec_transaction_id AS ot_sec_transaction_id_15, v0_.updated_by AS updated_by_16, v0_.vehicle_id AS vehicle_id_17, v0_.vat_for_tax_rate_id AS vat_for_tax_rate_id_18 FROM vehicle_sales v0_ INNER JOIN invoices i1_ ON v0_.invoice_id = i1_.invoice_id INNER JOIN account_transactions a2_ ON i1_.transaction_id = a2_.transaction_id WHERE v0_.vehicle_id = 19642 AND a2_.status_id = 9 AND v0_.is_cancelled <> 1;
12	1.91 ms	SELECT t0.ot_id AS ot_id_1, t0.ot_date AS ot_date_2, t0.approval_status AS approval_status_3, t0.created_at AS created_at_4, t0.approved_at AS approved_at_5, t0.is_drop AS is_drop_6, t0.approved_by AS approved_by_7, t0.created_by AS created_by_8, t0.ot_doc_id AS ot_doc_id_9, t0.sale_id AS sale_id_10, t0.vehicle_id AS vehicle_id_11 FROM vehicle_ownership_transfer t0 WHERE t0.vehicle_id = ? AND t0.approval_status = ? LIMIT 1 Parameters: [`19642 "approved"`] View formatted query View runnable query Explain query SELECT t0.ot_id AS ot_id_1, t0.ot_date AS ot_date_2, t0.approval_status AS approval_status_3, t0.created_at AS created_at_4, t0.approved_at AS approved_at_5, t0.is_drop AS is_drop_6, t0.approved_by AS approved_by_7, t0.created_by AS created_by_8, t0.ot_doc_id AS ot_doc_id_9, t0.sale_id AS sale_id_10, t0.vehicle_id AS vehicle_id_11 FROM vehicle_ownership_transfer t0 WHERE t0.vehicle_id = ? AND t0.approval_status = ? LIMIT 1 SELECT t0.ot_id AS ot_id_1, t0.ot_date AS ot_date_2, t0.approval_status AS approval_status_3, t0.created_at AS created_at_4, t0.approved_at AS approved_at_5, t0.is_drop AS is_drop_6, t0.approved_by AS approved_by_7, t0.created_by AS created_by_8, t0.ot_doc_id AS ot_doc_id_9, t0.sale_id AS sale_id_10, t0.vehicle_id AS vehicle_id_11 FROM vehicle_ownership_transfer t0 WHERE t0.vehicle_id = 19642 AND t0.approval_status = 'approved' LIMIT 1;
13	2.25 ms	SELECT t0.activity_id AS activity_id_1, t0.activity_type AS activity_type_2, t0.is_include_revoke AS is_include_revoke_3, t0.notes AS notes_4, t0.activity_date AS activity_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_deleted AS is_deleted_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.revoke_request_id AS revoke_request_id_11, t0.vehicle_id AS vehicle_id_12, t13.is_returned AS is_returned_14, t13.is_repair AS is_repair_15, t13.address AS address_16, t13.responsible_person_name AS responsible_person_name_17, t13.responsible_person_mob_num AS responsible_person_mob_num_18, t13.destination_activity_id AS destination_activity_id_19, t13.inventory_delivery_path AS inventory_delivery_path_20, t13.destination_activity_id AS destination_activity_id_21, t13.city_id AS city_id_22, t23.estimate_val_before AS estimate_val_before_24, t23.estimate_val_after AS estimate_val_after_25, t23.parts_estimation AS parts_estimation_26, t23.image_path AS image_path_27, t23.estimation_id AS estimation_id_28, t23.activity_id AS activity_id_29, t23.rts_invoice_id AS rts_invoice_id_30, t23.vehicle_id AS vehicle_id_31, t32.storage_activity_id AS storage_activity_id_33, t32.storage_activity_id AS storage_activity_id_34, t32.warehouse_id AS warehouse_id_35, t36.transport_date AS transport_date_37, t36.transport_activity_id AS transport_activity_id_38, t36.driver_id AS driver_id_39, t36.rts_invoice_id AS rts_invoice_id_40, t36.transporter_id AS transporter_id_41, t36.transport_activity_id AS transport_activity_id_42, t43.inventory_notes AS inventory_notes_44, t43.inventory_activity_id AS inventory_activity_id_45, t43.inventory_activity_id AS inventory_activity_id_46 FROM vehicle_rts_activities t0 LEFT JOIN vehicle_rts_activities_destinations t13 ON t13.destination_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_estimate_val t23 ON t23.activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_storage t32 ON t32.storage_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_transports t36 ON t36.transport_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_inventories t43 ON t43.inventory_activity_id = t0.activity_id WHERE t0.vehicle_id = ? LIMIT 1 Parameters: [`19642`] View formatted query View runnable query Explain query SELECT t0.activity_id AS activity_id_1, t0.activity_type AS activity_type_2, t0.is_include_revoke AS is_include_revoke_3, t0.notes AS notes_4, t0.activity_date AS activity_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_deleted AS is_deleted_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.revoke_request_id AS revoke_request_id_11, t0.vehicle_id AS vehicle_id_12, t13.is_returned AS is_returned_14, t13.is_repair AS is_repair_15, t13.address AS address_16, t13.responsible_person_name AS responsible_person_name_17, t13.responsible_person_mob_num AS responsible_person_mob_num_18, t13.destination_activity_id AS destination_activity_id_19, t13.inventory_delivery_path AS inventory_delivery_path_20, t13.destination_activity_id AS destination_activity_id_21, t13.city_id AS city_id_22, t23.estimate_val_before AS estimate_val_before_24, t23.estimate_val_after AS estimate_val_after_25, t23.parts_estimation AS parts_estimation_26, t23.image_path AS image_path_27, t23.estimation_id AS estimation_id_28, t23.activity_id AS activity_id_29, t23.rts_invoice_id AS rts_invoice_id_30, t23.vehicle_id AS vehicle_id_31, t32.storage_activity_id AS storage_activity_id_33, t32.storage_activity_id AS storage_activity_id_34, t32.warehouse_id AS warehouse_id_35, t36.transport_date AS transport_date_37, t36.transport_activity_id AS transport_activity_id_38, t36.driver_id AS driver_id_39, t36.rts_invoice_id AS rts_invoice_id_40, t36.transporter_id AS transporter_id_41, t36.transport_activity_id AS transport_activity_id_42, t43.inventory_notes AS inventory_notes_44, t43.inventory_activity_id AS inventory_activity_id_45, t43.inventory_activity_id AS inventory_activity_id_46 FROM vehicle_rts_activities t0 LEFT JOIN vehicle_rts_activities_destinations t13 ON t13.destination_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_estimate_val t23 ON t23.activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_storage t32 ON t32.storage_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_transports t36 ON t36.transport_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_inventories t43 ON t43.inventory_activity_id = t0.activity_id WHERE t0.vehicle_id = ? LIMIT 1 SELECT t0.activity_id AS activity_id_1, t0.activity_type AS activity_type_2, t0.is_include_revoke AS is_include_revoke_3, t0.notes AS notes_4, t0.activity_date AS activity_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_deleted AS is_deleted_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.revoke_request_id AS revoke_request_id_11, t0.vehicle_id AS vehicle_id_12, t13.is_returned AS is_returned_14, t13.is_repair AS is_repair_15, t13.address AS address_16, t13.responsible_person_name AS responsible_person_name_17, t13.responsible_person_mob_num AS responsible_person_mob_num_18, t13.destination_activity_id AS destination_activity_id_19, t13.inventory_delivery_path AS inventory_delivery_path_20, t13.destination_activity_id AS destination_activity_id_21, t13.city_id AS city_id_22, t23.estimate_val_before AS estimate_val_before_24, t23.estimate_val_after AS estimate_val_after_25, t23.parts_estimation AS parts_estimation_26, t23.image_path AS image_path_27, t23.estimation_id AS estimation_id_28, t23.activity_id AS activity_id_29, t23.rts_invoice_id AS rts_invoice_id_30, t23.vehicle_id AS vehicle_id_31, t32.storage_activity_id AS storage_activity_id_33, t32.storage_activity_id AS storage_activity_id_34, t32.warehouse_id AS warehouse_id_35, t36.transport_date AS transport_date_37, t36.transport_activity_id AS transport_activity_id_38, t36.driver_id AS driver_id_39, t36.rts_invoice_id AS rts_invoice_id_40, t36.transporter_id AS transporter_id_41, t36.transport_activity_id AS transport_activity_id_42, t43.inventory_notes AS inventory_notes_44, t43.inventory_activity_id AS inventory_activity_id_45, t43.inventory_activity_id AS inventory_activity_id_46 FROM vehicle_rts_activities t0 LEFT JOIN vehicle_rts_activities_destinations t13 ON t13.destination_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_estimate_val t23 ON t23.activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_storage t32 ON t32.storage_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_transports t36 ON t36.transport_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_inventories t43 ON t43.inventory_activity_id = t0.activity_id WHERE t0.vehicle_id = 19642 LIMIT 1;
14	2.23 ms	SELECT v0_.request_id AS request_id_0, v0_.request_type AS request_type_1, v0_.is_estimate_val_requested AS is_estimate_val_requested_2, v0_.request_date AS request_date_3, v0_.revoke_cancellation_notes AS revoke_cancellation_notes_4, v0_.is_rejected AS is_rejected_5, v0_.rejection_reason AS rejection_reason_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_9, v0_.auth_image_path AS auth_image_path_10, v0_.estimate_image_path AS estimate_image_path_11, v0_.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_12, v0_.created_by AS created_by_13, v0_.updated_by AS updated_by_14, v0_.vehicle_id AS vehicle_id_15 FROM vehicle_revoke_requests v0_ INNER JOIN vehicle_rts_activities v1_ ON v0_.request_id = v1_.revoke_request_id WHERE v0_.vehicle_id = ? Parameters: [`19642`] View formatted query View runnable query Explain query SELECT v0_.request_id AS request_id_0, v0_.request_type AS request_type_1, v0_.is_estimate_val_requested AS is_estimate_val_requested_2, v0_.request_date AS request_date_3, v0_.revoke_cancellation_notes AS revoke_cancellation_notes_4, v0_.is_rejected AS is_rejected_5, v0_.rejection_reason AS rejection_reason_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_9, v0_.auth_image_path AS auth_image_path_10, v0_.estimate_image_path AS estimate_image_path_11, v0_.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_12, v0_.created_by AS created_by_13, v0_.updated_by AS updated_by_14, v0_.vehicle_id AS vehicle_id_15 FROM vehicle_revoke_requests v0_ INNER JOIN vehicle_rts_activities v1_ ON v0_.request_id = v1_.revoke_request_id WHERE v0_.vehicle_id = ? SELECT v0_.request_id AS request_id_0, v0_.request_type AS request_type_1, v0_.is_estimate_val_requested AS is_estimate_val_requested_2, v0_.request_date AS request_date_3, v0_.revoke_cancellation_notes AS revoke_cancellation_notes_4, v0_.is_rejected AS is_rejected_5, v0_.rejection_reason AS rejection_reason_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_9, v0_.auth_image_path AS auth_image_path_10, v0_.estimate_image_path AS estimate_image_path_11, v0_.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_12, v0_.created_by AS created_by_13, v0_.updated_by AS updated_by_14, v0_.vehicle_id AS vehicle_id_15 FROM vehicle_revoke_requests v0_ INNER JOIN vehicle_rts_activities v1_ ON v0_.request_id = v1_.revoke_request_id WHERE v0_.vehicle_id = 19642;
15	5.99 ms	SELECT t0.log_id AS log_id_1, t0.situation AS situation_2, t0.created_at AS created_at_3, t0.transition AS transition_4, t0.created_by AS created_by_5, t0.vehicle_id AS vehicle_id_6 FROM vehicle_situation_log t0 WHERE t0.vehicle_id = ? ORDER BY t0.log_id DESC LIMIT 1 Parameters: [`19642`] View formatted query View runnable query Explain query SELECT t0.log_id AS log_id_1, t0.situation AS situation_2, t0.created_at AS created_at_3, t0.transition AS transition_4, t0.created_by AS created_by_5, t0.vehicle_id AS vehicle_id_6 FROM vehicle_situation_log t0 WHERE t0.vehicle_id = ? ORDER BY t0.log_id DESC LIMIT 1 SELECT t0.log_id AS log_id_1, t0.situation AS situation_2, t0.created_at AS created_at_3, t0.transition AS transition_4, t0.created_by AS created_by_5, t0.vehicle_id AS vehicle_id_6 FROM vehicle_situation_log t0 WHERE t0.vehicle_id = 19642 ORDER BY t0.log_id DESC LIMIT 1;
16	2.41 ms	SELECT t0.log_id AS log_id_1, t0.situation AS situation_2, t0.created_at AS created_at_3, t0.transition AS transition_4, t0.created_by AS created_by_5, t0.vehicle_id AS vehicle_id_6 FROM vehicle_situation_log t0 WHERE t0.vehicle_id = ? ORDER BY t0.log_id DESC LIMIT 1 OFFSET 1 Parameters: [`19642`] View formatted query View runnable query Explain query SELECT t0.log_id AS log_id_1, t0.situation AS situation_2, t0.created_at AS created_at_3, t0.transition AS transition_4, t0.created_by AS created_by_5, t0.vehicle_id AS vehicle_id_6 FROM vehicle_situation_log t0 WHERE t0.vehicle_id = ? ORDER BY t0.log_id DESC LIMIT 1 OFFSET 1 SELECT t0.log_id AS log_id_1, t0.situation AS situation_2, t0.created_at AS created_at_3, t0.transition AS transition_4, t0.created_by AS created_by_5, t0.vehicle_id AS vehicle_id_6 FROM vehicle_situation_log t0 WHERE t0.vehicle_id = 19642 ORDER BY t0.log_id DESC LIMIT 1 OFFSET 1;
17	3.42 ms	SELECT v0_.request_id AS request_id_0, v0_.request_type AS request_type_1, v0_.is_estimate_val_requested AS is_estimate_val_requested_2, v0_.request_date AS request_date_3, v0_.revoke_cancellation_notes AS revoke_cancellation_notes_4, v0_.is_rejected AS is_rejected_5, v0_.rejection_reason AS rejection_reason_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_9, v0_.auth_image_path AS auth_image_path_10, v0_.estimate_image_path AS estimate_image_path_11, v0_.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_12, v0_.created_by AS created_by_13, v0_.updated_by AS updated_by_14, v0_.vehicle_id AS vehicle_id_15 FROM vehicle_revoke_requests v0_ LEFT JOIN vehicle_rts_activities v1_ ON v0_.request_id = v1_.revoke_request_id WHERE v0_.vehicle_id = ? ORDER BY v0_.request_id DESC Parameters: [`19642`] View formatted query View runnable query Explain query SELECT v0_.request_id AS request_id_0, v0_.request_type AS request_type_1, v0_.is_estimate_val_requested AS is_estimate_val_requested_2, v0_.request_date AS request_date_3, v0_.revoke_cancellation_notes AS revoke_cancellation_notes_4, v0_.is_rejected AS is_rejected_5, v0_.rejection_reason AS rejection_reason_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_9, v0_.auth_image_path AS auth_image_path_10, v0_.estimate_image_path AS estimate_image_path_11, v0_.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_12, v0_.created_by AS created_by_13, v0_.updated_by AS updated_by_14, v0_.vehicle_id AS vehicle_id_15 FROM vehicle_revoke_requests v0_ LEFT JOIN vehicle_rts_activities v1_ ON v0_.request_id = v1_.revoke_request_id WHERE v0_.vehicle_id = ? ORDER BY v0_.request_id DESC SELECT v0_.request_id AS request_id_0, v0_.request_type AS request_type_1, v0_.is_estimate_val_requested AS is_estimate_val_requested_2, v0_.request_date AS request_date_3, v0_.revoke_cancellation_notes AS revoke_cancellation_notes_4, v0_.is_rejected AS is_rejected_5, v0_.rejection_reason AS rejection_reason_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8, v0_.is_beneficiary_informed_with_revoke AS is_beneficiary_informed_with_revoke_9, v0_.auth_image_path AS auth_image_path_10, v0_.estimate_image_path AS estimate_image_path_11, v0_.revoke_cancellation_reason_id AS revoke_cancellation_reason_id_12, v0_.created_by AS created_by_13, v0_.updated_by AS updated_by_14, v0_.vehicle_id AS vehicle_id_15 FROM vehicle_revoke_requests v0_ LEFT JOIN vehicle_rts_activities v1_ ON v0_.request_id = v1_.revoke_request_id WHERE v0_.vehicle_id = 19642 ORDER BY v0_.request_id DESC;
18	2.76 ms	SELECT v0_.activity_id AS activity_id_0, v1_.request_id AS request_id_1, v0_.activity_type AS activity_type_2 FROM vehicle_rts_activities v0_ INNER JOIN vehicle_revoke_requests v1_ ON v0_.revoke_request_id = v1_.request_id WHERE v1_.vehicle_id = ? ORDER BY v0_.activity_id DESC LIMIT 1 Parameters: [`19642`] View formatted query View runnable query Explain query SELECT v0_.activity_id AS activity_id_0, v1_.request_id AS request_id_1, v0_.activity_type AS activity_type_2 FROM vehicle_rts_activities v0_ INNER JOIN vehicle_revoke_requests v1_ ON v0_.revoke_request_id = v1_.request_id WHERE v1_.vehicle_id = ? ORDER BY v0_.activity_id DESC LIMIT 1 SELECT v0_.activity_id AS activity_id_0, v1_.request_id AS request_id_1, v0_.activity_type AS activity_type_2 FROM vehicle_rts_activities v0_ INNER JOIN vehicle_revoke_requests v1_ ON v0_.revoke_request_id = v1_.request_id WHERE v1_.vehicle_id = 19642 ORDER BY v0_.activity_id DESC LIMIT 1;
19	1.25 ms	SELECT t0.is_returned AS is_returned_1, t0.is_repair AS is_repair_2, t0.address AS address_3, t0.responsible_person_name AS responsible_person_name_4, t0.responsible_person_mob_num AS responsible_person_mob_num_5, t0.destination_activity_id AS destination_activity_id_6, t0.inventory_delivery_path AS inventory_delivery_path_7, t0.destination_activity_id AS destination_activity_id_8, t0.city_id AS city_id_9 FROM vehicle_rts_activities_destinations t0 WHERE t0.destination_activity_id = ? LIMIT 1 Parameters: [`19246`] View formatted query View runnable query Explain query SELECT t0.is_returned AS is_returned_1, t0.is_repair AS is_repair_2, t0.address AS address_3, t0.responsible_person_name AS responsible_person_name_4, t0.responsible_person_mob_num AS responsible_person_mob_num_5, t0.destination_activity_id AS destination_activity_id_6, t0.inventory_delivery_path AS inventory_delivery_path_7, t0.destination_activity_id AS destination_activity_id_8, t0.city_id AS city_id_9 FROM vehicle_rts_activities_destinations t0 WHERE t0.destination_activity_id = ? LIMIT 1 SELECT t0.is_returned AS is_returned_1, t0.is_repair AS is_repair_2, t0.address AS address_3, t0.responsible_person_name AS responsible_person_name_4, t0.responsible_person_mob_num AS responsible_person_mob_num_5, t0.destination_activity_id AS destination_activity_id_6, t0.inventory_delivery_path AS inventory_delivery_path_7, t0.destination_activity_id AS destination_activity_id_8, t0.city_id AS city_id_9 FROM vehicle_rts_activities_destinations t0 WHERE t0.destination_activity_id = 19246 LIMIT 1;
20	6.66 ms	SELECT t0.activity_id AS activity_id_1, t0.activity_type AS activity_type_2, t0.is_include_revoke AS is_include_revoke_3, t0.notes AS notes_4, t0.activity_date AS activity_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_deleted AS is_deleted_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.revoke_request_id AS revoke_request_id_11, t0.vehicle_id AS vehicle_id_12, t13.is_returned AS is_returned_14, t13.is_repair AS is_repair_15, t13.address AS address_16, t13.responsible_person_name AS responsible_person_name_17, t13.responsible_person_mob_num AS responsible_person_mob_num_18, t13.destination_activity_id AS destination_activity_id_19, t13.inventory_delivery_path AS inventory_delivery_path_20, t13.destination_activity_id AS destination_activity_id_21, t13.city_id AS city_id_22, t23.estimate_val_before AS estimate_val_before_24, t23.estimate_val_after AS estimate_val_after_25, t23.parts_estimation AS parts_estimation_26, t23.image_path AS image_path_27, t23.estimation_id AS estimation_id_28, t23.activity_id AS activity_id_29, t23.rts_invoice_id AS rts_invoice_id_30, t23.vehicle_id AS vehicle_id_31, t32.storage_activity_id AS storage_activity_id_33, t32.storage_activity_id AS storage_activity_id_34, t32.warehouse_id AS warehouse_id_35, t36.transport_date AS transport_date_37, t36.transport_activity_id AS transport_activity_id_38, t36.driver_id AS driver_id_39, t36.rts_invoice_id AS rts_invoice_id_40, t36.transporter_id AS transporter_id_41, t36.transport_activity_id AS transport_activity_id_42, t43.inventory_notes AS inventory_notes_44, t43.inventory_activity_id AS inventory_activity_id_45, t43.inventory_activity_id AS inventory_activity_id_46 FROM vehicle_rts_activities t0 LEFT JOIN vehicle_rts_activities_destinations t13 ON t13.destination_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_estimate_val t23 ON t23.activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_storage t32 ON t32.storage_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_transports t36 ON t36.transport_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_inventories t43 ON t43.inventory_activity_id = t0.activity_id WHERE t0.revoke_request_id = ? ORDER BY t0.created_at DESC Parameters: [`11014`] View formatted query View runnable query Explain query SELECT t0.activity_id AS activity_id_1, t0.activity_type AS activity_type_2, t0.is_include_revoke AS is_include_revoke_3, t0.notes AS notes_4, t0.activity_date AS activity_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_deleted AS is_deleted_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.revoke_request_id AS revoke_request_id_11, t0.vehicle_id AS vehicle_id_12, t13.is_returned AS is_returned_14, t13.is_repair AS is_repair_15, t13.address AS address_16, t13.responsible_person_name AS responsible_person_name_17, t13.responsible_person_mob_num AS responsible_person_mob_num_18, t13.destination_activity_id AS destination_activity_id_19, t13.inventory_delivery_path AS inventory_delivery_path_20, t13.destination_activity_id AS destination_activity_id_21, t13.city_id AS city_id_22, t23.estimate_val_before AS estimate_val_before_24, t23.estimate_val_after AS estimate_val_after_25, t23.parts_estimation AS parts_estimation_26, t23.image_path AS image_path_27, t23.estimation_id AS estimation_id_28, t23.activity_id AS activity_id_29, t23.rts_invoice_id AS rts_invoice_id_30, t23.vehicle_id AS vehicle_id_31, t32.storage_activity_id AS storage_activity_id_33, t32.storage_activity_id AS storage_activity_id_34, t32.warehouse_id AS warehouse_id_35, t36.transport_date AS transport_date_37, t36.transport_activity_id AS transport_activity_id_38, t36.driver_id AS driver_id_39, t36.rts_invoice_id AS rts_invoice_id_40, t36.transporter_id AS transporter_id_41, t36.transport_activity_id AS transport_activity_id_42, t43.inventory_notes AS inventory_notes_44, t43.inventory_activity_id AS inventory_activity_id_45, t43.inventory_activity_id AS inventory_activity_id_46 FROM vehicle_rts_activities t0 LEFT JOIN vehicle_rts_activities_destinations t13 ON t13.destination_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_estimate_val t23 ON t23.activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_storage t32 ON t32.storage_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_transports t36 ON t36.transport_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_inventories t43 ON t43.inventory_activity_id = t0.activity_id WHERE t0.revoke_request_id = ? ORDER BY t0.created_at DESC SELECT t0.activity_id AS activity_id_1, t0.activity_type AS activity_type_2, t0.is_include_revoke AS is_include_revoke_3, t0.notes AS notes_4, t0.activity_date AS activity_date_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_deleted AS is_deleted_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.revoke_request_id AS revoke_request_id_11, t0.vehicle_id AS vehicle_id_12, t13.is_returned AS is_returned_14, t13.is_repair AS is_repair_15, t13.address AS address_16, t13.responsible_person_name AS responsible_person_name_17, t13.responsible_person_mob_num AS responsible_person_mob_num_18, t13.destination_activity_id AS destination_activity_id_19, t13.inventory_delivery_path AS inventory_delivery_path_20, t13.destination_activity_id AS destination_activity_id_21, t13.city_id AS city_id_22, t23.estimate_val_before AS estimate_val_before_24, t23.estimate_val_after AS estimate_val_after_25, t23.parts_estimation AS parts_estimation_26, t23.image_path AS image_path_27, t23.estimation_id AS estimation_id_28, t23.activity_id AS activity_id_29, t23.rts_invoice_id AS rts_invoice_id_30, t23.vehicle_id AS vehicle_id_31, t32.storage_activity_id AS storage_activity_id_33, t32.storage_activity_id AS storage_activity_id_34, t32.warehouse_id AS warehouse_id_35, t36.transport_date AS transport_date_37, t36.transport_activity_id AS transport_activity_id_38, t36.driver_id AS driver_id_39, t36.rts_invoice_id AS rts_invoice_id_40, t36.transporter_id AS transporter_id_41, t36.transport_activity_id AS transport_activity_id_42, t43.inventory_notes AS inventory_notes_44, t43.inventory_activity_id AS inventory_activity_id_45, t43.inventory_activity_id AS inventory_activity_id_46 FROM vehicle_rts_activities t0 LEFT JOIN vehicle_rts_activities_destinations t13 ON t13.destination_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_estimate_val t23 ON t23.activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_storage t32 ON t32.storage_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activity_transports t36 ON t36.transport_activity_id = t0.activity_id LEFT JOIN vehicle_rts_activities_inventories t43 ON t43.inventory_activity_id = t0.activity_id WHERE t0.revoke_request_id = 11014 ORDER BY t0.created_at DESC;
21	5.79 ms	SELECT t0.city_id AS city_id_1, t0.name_ar AS name_ar_2, t0.name_en AS name_en_3, t0.oracle_city_id AS oracle_city_id_4, t0.region_id AS region_id_5 FROM cities t0 WHERE t0.city_id = ? Parameters: [`15`] View formatted query View runnable query Explain query SELECT t0.city_id AS city_id_1, t0.name_ar AS name_ar_2, t0.name_en AS name_en_3, t0.oracle_city_id AS oracle_city_id_4, t0.region_id AS region_id_5 FROM cities t0 WHERE t0.city_id = ? SELECT t0.city_id AS city_id_1, t0.name_ar AS name_ar_2, t0.name_en AS name_en_3, t0.oracle_city_id AS oracle_city_id_4, t0.region_id AS region_id_5 FROM cities t0 WHERE t0.city_id = 15;
22	13.43 ms	SELECT t0.transporter_id AS transporter_id_1, t0.name_ar AS name_ar_2, t0.name_en AS name_en_3, t0.agreement_type AS agreement_type_4, t0.is_active AS is_active_5, t0.company_id AS company_id_6 FROM transporters t0 WHERE t0.transporter_id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.transporter_id AS transporter_id_1, t0.name_ar AS name_ar_2, t0.name_en AS name_en_3, t0.agreement_type AS agreement_type_4, t0.is_active AS is_active_5, t0.company_id AS company_id_6 FROM transporters t0 WHERE t0.transporter_id = ? SELECT t0.transporter_id AS transporter_id_1, t0.name_ar AS name_ar_2, t0.name_en AS name_en_3, t0.agreement_type AS agreement_type_4, t0.is_active AS is_active_5, t0.company_id AS company_id_6 FROM transporters t0 WHERE t0.transporter_id = 2;
23	2.14 ms	SELECT t0.warehouse_id AS warehouse_id_1, t0.name AS name_2, t0.address AS address_3, t0.telephone AS telephone_4, t0.is_active AS is_active_5, t0.city_id AS city_id_6, t0.company_id AS company_id_7 FROM warehouses t0 WHERE t0.warehouse_id = ? Parameters: [`14`] View formatted query View runnable query Explain query SELECT t0.warehouse_id AS warehouse_id_1, t0.name AS name_2, t0.address AS address_3, t0.telephone AS telephone_4, t0.is_active AS is_active_5, t0.city_id AS city_id_6, t0.company_id AS company_id_7 FROM warehouses t0 WHERE t0.warehouse_id = ? SELECT t0.warehouse_id AS warehouse_id_1, t0.name AS name_2, t0.address AS address_3, t0.telephone AS telephone_4, t0.is_active AS is_active_5, t0.city_id AS city_id_6, t0.company_id AS company_id_7 FROM warehouses t0 WHERE t0.warehouse_id = 14;

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\Users	No errors.
App\Entity\UsersCategories	No errors.
App\Entity\Companies	No errors.
App\Entity\UserIdentityInfo	No errors.
App\Entity\Countries	No errors.
App\Entity\UserAdditionalDetails	No errors.
App\Entity\ProfileClassification	No errors.
App\Entity\Cities	No errors.
App\Entity\VehicleClients	No errors.
App\Entity\UserBankDetails	No errors.
App\Entity\Vehicles	The field App\Entity\Vehicles#vehicleSales is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VehicleSales#vehicle does not contain the required 'inversedBy="vehicleSales"' attribute.
App\Entity\VehicleRegistrations	No errors.
App\Entity\VehicleColors	No errors.
App\Entity\VehicleDocs	No errors.
App\Entity\PanelLetters	No errors.
App\Entity\VehicleModels	No errors.
App\Entity\VehicleRegistrationTypes	No errors.
App\Entity\VehicleTechnicalSpecs	No errors.
App\Entity\OdometerRanges	No errors.
App\Entity\VehicleBeneficiaryDetails	No errors.
App\Entity\SupplierInvoices	No errors.
App\Entity\VehicleInventoryMissingParts	No errors.
App\Entity\VehicleOtherMissingParts	No errors.
App\Entity\VehicleInventoryImages	No errors.
App\Entity\VehicleRevokeRequests	No errors.
App\Entity\VehicleRtsActivitiesEstimateVal	No errors.
App\Entity\VehicleSales	No errors.
App\Entity\RevokeCancellationReasons	No errors.
App\Entity\VehicleRevokeRequestSource	No errors.
App\Entity\VehicleRevokeRequestDestination	No errors.
App\Entity\Activity	No errors.
App\Entity\ClientsDelegation	No errors.
App\Entity\Invoices	The field App\Entity\Invoices#vehicleAbandon is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VehicleSaleAbandons#abandonInvoice does not contain the required 'inversedBy="vehicleAbandon"' attribute.
App\Entity\AccountTransactions	No errors.
App\Entity\VatRate	No errors.
App\Entity\VehicleOwnershipTransfer	No errors.
App\Entity\ActivityDestination	No errors.
App\Entity\VehicleRtsActivitiesInvoices	The association App\Entity\VehicleRtsActivitiesInvoices#estimateVal refers to the inverse side field App\Entity\VehicleRtsActivitiesEstimateVal#estimateInvoice which does not exist.
App\Entity\VehicleRtsActivityStorage	No errors.
App\Entity\Warehouses	No errors.
App\Entity\VehicleRtsActivityTransports	No errors.
App\Entity\TransporterDrivers	No errors.
App\Entity\Transporters	No errors.
App\Entity\VehicleRtsActivitiesInventories	No errors.
App\Entity\VehicleSituationLog	No errors.
App\Entity\InventoryParts	No errors.
App\Entity\VehicleRtsActivitiesInventoriesImages	No errors.
App\Entity\Regions	No errors.

Symfony Profiler

GET https://auction.sa/ar/revokeRequests/19642/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping