Symfony Profiler

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)
  )

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 = 488 AND ((t0.deleted_at IS NULL));

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)
  )

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 = 4 AND ((t0.deleted_at IS NULL));

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)
  )

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 = 'PASS' AND ((t0.deleted_at IS NULL));

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)
  )

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 = 22 AND ((t0.deleted_at IS NULL));

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)
  )

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 = 29 AND ((t0.deleted_at IS NULL));

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)
  )

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 = 'STS' AND ((t0.deleted_at IS NULL));

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)
  )

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 = 29 AND ((t0.deleted_at IS NULL));

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

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;

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)
  )

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 = 'PE' AND ((t0.deleted_at IS NULL));

SELECT
  count(c0_.id) AS sclr_0
FROM
  company_visa_application c0_
WHERE
  (c0_.deleted_at IS NULL)

SELECT count(c0_.id) AS sclr_0 FROM company_visa_application c0_ WHERE (c0_.deleted_at IS NULL);

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 = ?

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 = 1;

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)
  )

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 = 'AGENT' AND ((t0.deleted_at IS NULL));

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)
  )

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 = 1 AND ((t0.deleted_at IS NULL));

UPDATE
  token
SET
  expires_at = ?
WHERE
  user_id = ?

UPDATE token SET expires_at = '2024-05-16 05:56:17' WHERE user_id = '1';

"START TRANSACTION"

"START TRANSACTION";

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)
  )

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 = 'TR' AND ((t0.deleted_at IS NULL));

"COMMIT"

"COMMIT";