Query Metrics
57
Database Queries
17
Different statements
38.31 ms
Query time
2
Invalid entities
Queries
#▲ | 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 |
|
App\Entity\Company |
|
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. |