http://e-vizedubai.com/api/visa-application/list Return to referer URL

Query Metrics

57 Database Queries
17 Different statements
38.31 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.84 ms
SELECT t0.data AS data_1, t0.expires_at AS expires_at_2, t0.deleted_at AS deleted_at_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.user_id AS user_id_7 FROM token t0 WHERE t0.user_id = ?
Parameters:
[
  1
]
2 0.44 ms
"START TRANSACTION"
Parameters:
[]
3 0.58 ms
UPDATE token SET expires_at = ? WHERE user_id = ?
Parameters:
[
  "2024-05-16 05:56:17"
  "1"
]
4 0.26 ms
"COMMIT"
Parameters:
[]
5 1.38 ms
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.email AS email_3, c0_.phone AS phone_4, c0_.pasaport_number AS pasaport_number_5, c0_.expire_date AS expire_date_6, c0_.issue_date AS issue_date_7, c0_.start_date AS start_date_8, c0_.remarks AS remarks_9, c0_.price AS price_10, c0_.payment AS payment_11, c0_.gender AS gender_12, c0_.travel_date AS travel_date_13, c0_.missing_documents AS missing_documents_14, c0_.deleted_at AS deleted_at_15, c0_.is_active AS is_active_16, c0_.created_at AS created_at_17, c0_.updated_at AS updated_at_18, c0_.company_id AS company_id_19, c0_.user_id AS user_id_20, c0_.visa_type AS visa_type_21, c0_.visa_status AS visa_status_22, c0_.currency_code AS currency_code_23, c0_.country_code AS country_code_24, c0_.insurance_id AS insurance_id_25 FROM company_visa_application c0_ WHERE (c0_.deleted_at IS NULL) ORDER BY c0_.id DESC LIMIT 25
Parameters:
[]
6 1.01 ms
SELECT count(c0_.id) AS sclr_0 FROM company_visa_application c0_ WHERE (c0_.deleted_at IS NULL)
Parameters:
[]
7 0.86 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.email AS email_5, t0.phone AS phone_6, t0.tax_id AS tax_id_7, t0.tax_office AS tax_office_8, t0.payment_type AS payment_type_9, t0.company_status AS company_status_10, t0.credit AS credit_11, t0.remarks AS remarks_12, t0.deleted_at AS deleted_at_13, t0.is_active AS is_active_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.company_type AS company_type_17, t0.currency_code AS currency_code_18 FROM company t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  29
]
8 0.77 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.deleted_at AS deleted_at_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sta_company_type t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "AGENT"
]
9 0.86 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.company_id AS company_id_8, t0.file_type AS file_type_9 FROM company_document t0 WHERE t0.company_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  29
]
10 1.38 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.gender AS gender_6, t0.birth_date AS birth_date_7, t0.cell_phone AS cell_phone_8, t0.job_title AS job_title_9, t0.business_phone AS business_phone_10, t0.business_phone_extension AS business_phone_extension_11, t0.is_admin AS is_admin_12, t0.device_unique_id AS device_unique_id_13, t0.deleted_at AS deleted_at_14, t0.is_active AS is_active_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.company_id AS company_id_18, t0.user_type AS user_type_19 FROM company_user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  22
]
11 1.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_order AS sort_order_3, t0.price AS price_4, t0.cancellation_penalty AS cancellation_penalty_5, t0.description AS description_6, t0.show_page AS show_page_7, t0.deleted_at AS deleted_at_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.visa_type AS visa_type_12, t0.currency_code AS currency_code_13 FROM visa_type t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  4
]
12 0.84 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.deleted_at AS deleted_at_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sta_visa_type t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "STS"
]
13 0.75 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.sort_order AS sort_order_4, t0.deleted_at AS deleted_at_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM sta_visa_status t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "PE"
]
14 1.05 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  488
]
15 0.98 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.sort_order AS sort_order_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM sta_file_type t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "PASS"
]
16 0.66 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.sort_order AS sort_order_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM sta_file_type t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "PHOT"
]
17 0.68 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.email AS email_5, t0.phone AS phone_6, t0.tax_id AS tax_id_7, t0.tax_office AS tax_office_8, t0.payment_type AS payment_type_9, t0.company_status AS company_status_10, t0.credit AS credit_11, t0.remarks AS remarks_12, t0.deleted_at AS deleted_at_13, t0.is_active AS is_active_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.company_type AS company_type_17, t0.currency_code AS currency_code_18 FROM company t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  28
]
18 0.61 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.company_id AS company_id_8, t0.file_type AS file_type_9 FROM company_document t0 WHERE t0.company_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  28
]
19 0.57 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.gender AS gender_6, t0.birth_date AS birth_date_7, t0.cell_phone AS cell_phone_8, t0.job_title AS job_title_9, t0.business_phone AS business_phone_10, t0.business_phone_extension AS business_phone_extension_11, t0.is_admin AS is_admin_12, t0.device_unique_id AS device_unique_id_13, t0.deleted_at AS deleted_at_14, t0.is_active AS is_active_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.company_id AS company_id_18, t0.user_type AS user_type_19 FROM company_user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
20 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_order AS sort_order_3, t0.price AS price_4, t0.cancellation_penalty AS cancellation_penalty_5, t0.description AS description_6, t0.show_page AS show_page_7, t0.deleted_at AS deleted_at_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.visa_type AS visa_type_12, t0.currency_code AS currency_code_13 FROM visa_type t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  5
]
21 0.43 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.deleted_at AS deleted_at_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sta_visa_type t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "CH"
]
22 0.43 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.sort_order AS sort_order_4, t0.deleted_at AS deleted_at_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM sta_visa_status t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "CF"
]
23 0.43 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.phone_code AS phone_code_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.currency_code AS currency_code_8 FROM location_country t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "TR"
]
24 0.57 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  487
]
25 0.55 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.sort_order AS sort_order_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM sta_file_type t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "VIS"
]
26 0.65 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  486
]
27 0.56 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  485
]
28 0.49 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  484
]
29 0.63 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  483
]
30 0.63 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  482
]
31 0.60 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  481
]
32 0.52 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  480
]
33 0.53 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  479
]
34 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_order AS sort_order_3, t0.price AS price_4, t0.cancellation_penalty AS cancellation_penalty_5, t0.description AS description_6, t0.show_page AS show_page_7, t0.deleted_at AS deleted_at_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.visa_type AS visa_type_12, t0.currency_code AS currency_code_13 FROM visa_type t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  6
]
35 0.37 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.deleted_at AS deleted_at_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sta_visa_type t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "EV"
]
36 0.71 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  477
]
37 0.76 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  476
]
38 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.email AS email_5, t0.phone AS phone_6, t0.tax_id AS tax_id_7, t0.tax_office AS tax_office_8, t0.payment_type AS payment_type_9, t0.company_status AS company_status_10, t0.credit AS credit_11, t0.remarks AS remarks_12, t0.deleted_at AS deleted_at_13, t0.is_active AS is_active_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.company_type AS company_type_17, t0.currency_code AS currency_code_18 FROM company t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  50
]
39 0.39 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.company_id AS company_id_8, t0.file_type AS file_type_9 FROM company_document t0 WHERE t0.company_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  50
]
40 0.78 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  475
]
41 0.67 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  474
]
42 0.64 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  473
]
43 0.71 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  472
]
44 0.78 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.gender AS gender_6, t0.birth_date AS birth_date_7, t0.cell_phone AS cell_phone_8, t0.job_title AS job_title_9, t0.business_phone AS business_phone_10, t0.business_phone_extension AS business_phone_extension_11, t0.is_admin AS is_admin_12, t0.device_unique_id AS device_unique_id_13, t0.deleted_at AS deleted_at_14, t0.is_active AS is_active_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.company_id AS company_id_18, t0.user_type AS user_type_19 FROM company_user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  42
]
45 0.70 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  471
]
46 0.58 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.sort_order AS sort_order_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM sta_file_type t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "ADD"
]
47 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.currency_code AS currency_code_8 FROM insurance t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
48 1.01 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  470
]
49 0.77 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  469
]
50 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_order AS sort_order_3, t0.price AS price_4, t0.cancellation_penalty AS cancellation_penalty_5, t0.description AS description_6, t0.show_page AS show_page_7, t0.deleted_at AS deleted_at_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.visa_type AS visa_type_12, t0.currency_code AS currency_code_13 FROM visa_type t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
51 0.48 ms
SELECT t0.code AS code_1, t0.name AS name_2, t0.deleted_at AS deleted_at_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sta_visa_type t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "LT"
]
52 0.58 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  468
]
53 0.44 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  467
]
54 0.52 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  466
]
55 0.44 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  465
]
56 0.52 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  464
]
57 0.48 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.extension AS extension_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visa_application_id AS visa_application_id_8, t0.file_type AS file_type_9 FROM company_visa_application_document t0 WHERE t0.visa_application_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  463
]

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\Token No errors.
App\Entity\CompanyUser No errors.
App\Entity\CompanyVisaApplication
  • The field App\Entity\CompanyVisaApplication#visaApplicationDocuments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CompanyVisaApplicationDocument#visaApplication does not contain the required 'inversedBy="visaApplicationDocuments"' attribute.
App\Entity\Company
  • The field App\Entity\Company#companyDocuments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CompanyDocument#company does not contain the required 'inversedBy="companyDocuments"' attribute.
App\Entity\VisaType No errors.
App\Entity\StaVisaStatus No errors.
App\Entity\StaCurrency No errors.
App\Entity\LocationCountry No errors.
App\Entity\Insurance No errors.
App\Entity\CompanyVisaApplicationDocument No errors.
App\Entity\StaCompanyType No errors.
App\Entity\CompanyDocument No errors.
App\Entity\StaCompanyFileType No errors.
App\Entity\StaUserType No errors.
App\Entity\StaVisaType No errors.
App\Entity\StaFileType No errors.