Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ui_label AS ui_label_3,
  t0.value AS value_4,
  t0.readonly AS readonly_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.ui_label AS ui_label_3, t0.value AS value_4, t0.readonly AS readonly_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM setting t0 WHERE t0.name = 'default_from_email' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ui_label AS ui_label_3,
  t0.value AS value_4,
  t0.readonly AS readonly_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.ui_label AS ui_label_3, t0.value AS value_4, t0.readonly AS readonly_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM setting t0 WHERE t0.name = 'default_from_sms' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.purchase_date AS purchase_date_2,
  t0.amount AS amount_3,
  t0.status AS status_4,
  t0.hash AS hash_5,
  t0.payment_strategy AS payment_strategy_6,
  t0.resource_id_string AS resource_id_string_7,
  t0.state AS state_8,
  t0.installment_period AS installment_period_9,
  t0.shipped_at AS shipped_at_10,
  t0.paid_to_shop AS paid_to_shop_11,
  t0.confirmed_by_customer_at AS confirmed_by_customer_at_12,
  t0.paid_at AS paid_at_13,
  t0.expire_at AS expire_at_14,
  t0.cancelled_at AS cancelled_at_15,
  t0.ok_url AS ok_url_16,
  t0.cancel_url AS cancel_url_17,
  t0.version AS version_18,
  t0.instalment4_initial_payment_percent AS instalment4_initial_payment_percent_19,
  t0.interest_rate_percent AS interest_rate_percent_20,
  t0.old_payment_strategy AS old_payment_strategy_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.deleted_at AS deleted_at_24,
  t0.customer_id AS customer_id_25,
  t0.shop_id AS shop_id_26,
  t27.id AS id_28,
  t27.first_name AS first_name_29,
  t27.middle_name AS middle_name_30,
  t27.last_name AS last_name_31,
  t27.email AS email_32,
  t27.phone AS phone_33,
  t27.purchase_id AS purchase_id_34,
  t0.shop_payment_id AS shop_payment_id_35,
  t0.contract_id AS contract_id_36
FROM
  purchase t0
  LEFT JOIN purchase_user_data t27 ON t27.purchase_id = t0.id
WHERE
  t0.hash IS NULL
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.purchase_date AS purchase_date_2, t0.amount AS amount_3, t0.status AS status_4, t0.hash AS hash_5, t0.payment_strategy AS payment_strategy_6, t0.resource_id_string AS resource_id_string_7, t0.state AS state_8, t0.installment_period AS installment_period_9, t0.shipped_at AS shipped_at_10, t0.paid_to_shop AS paid_to_shop_11, t0.confirmed_by_customer_at AS confirmed_by_customer_at_12, t0.paid_at AS paid_at_13, t0.expire_at AS expire_at_14, t0.cancelled_at AS cancelled_at_15, t0.ok_url AS ok_url_16, t0.cancel_url AS cancel_url_17, t0.version AS version_18, t0.instalment4_initial_payment_percent AS instalment4_initial_payment_percent_19, t0.interest_rate_percent AS interest_rate_percent_20, t0.old_payment_strategy AS old_payment_strategy_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.deleted_at AS deleted_at_24, t0.customer_id AS customer_id_25, t0.shop_id AS shop_id_26, t27.id AS id_28, t27.first_name AS first_name_29, t27.middle_name AS middle_name_30, t27.last_name AS last_name_31, t27.email AS email_32, t27.phone AS phone_33, t27.purchase_id AS purchase_id_34, t0.shop_payment_id AS shop_payment_id_35, t0.contract_id AS contract_id_36 FROM purchase t0 LEFT JOIN purchase_user_data t27 ON t27.purchase_id = t0.id WHERE t0.hash IS NULL AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.active AS active_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.preferred_language AS preferred_language_8,
  t0.id_card_status AS id_card_status_9,
  t0.aml_status AS aml_status_10,
  t0.credit_score_status AS credit_score_status_11,
  t0.allowed_products AS allowed_products_12,
  t0.ondato_id AS ondato_id_13,
  t0.ondato_scan_ref AS ondato_scan_ref_14,
  t0.ondato_status AS ondato_status_15,
  t0.reason_to_block_account AS reason_to_block_account_16,
  t0.black_list_status AS black_list_status_17,
  t0.final_ondato_status AS final_ondato_status_18,
  t0.verification_status AS verification_status_19,
  t0.block_request AS block_request_20,
  t0.registration_country_allowed AS registration_country_allowed_21,
  t0.status AS status_22,
  t0.ondato_kyc_id AS ondato_kyc_id_23,
  t25.id AS id_24,
  t25.first_name AS first_name_26,
  t25.last_name AS last_name_27,
  t25.egn AS egn_28,
  t25.address AS address_29,
  t25.city AS city_30,
  t25.middle_name AS middle_name_31,
  t25.phone1 AS phone1_32,
  t25.phone2 AS phone2_33,
  t25.phone3 AS phone3_34,
  t25.notes AS notes_35,
  t25.ondato_pdf AS ondato_pdf_36,
  t25.regix_signature AS regix_signature_37,
  t25.regix_picture AS regix_picture_38,
  t25.regix_data AS regix_data_39,
  t25.extended_check_notes AS extended_check_notes_40,
  t25.has_been_redirected_from_ondato AS has_been_redirected_from_ondato_41,
  t25.unsuccessful_identification_reason AS unsuccessful_identification_reason_42,
  t25.newsletter_subscribed AS newsletter_subscribed_43,
  t25.registered_with_egn AS registered_with_egn_44,
  t25.created_at AS created_at_45,
  t25.updated_at AS updated_at_46,
  t25.customer_id AS customer_id_47,
  t25.ondato_document_id AS ondato_document_id_48,
  t50.id AS id_49,
  t50.valid_until AS valid_until_51,
  t50.number AS number_52,
  t50.type AS type_53,
  t50.cvc AS cvc_54,
  t50.name_on_card AS name_on_card_55,
  t50.created_at AS created_at_56,
  t50.updated_at AS updated_at_57,
  t50.customer_id AS customer_id_58,
  t0.id_card_id AS id_card_id_59,
  t61.id AS id_60,
  t61.`key` AS key_62,
  t61.code AS code_63,
  t61.expires_at AS expires_at_64,
  t61.customer_id AS customer_id_65,
  t0.credit_profile_id AS credit_profile_id_66,
  t68.id AS id_67,
  t68.agreed_dpgfor_pay_now_at AS agreed_dpgfor_pay_now_at_69,
  t68.agreed_dpgfor_pay_later_at AS agreed_dpgfor_pay_later_at_70,
  t68.agreed_dpgfor_instalments_at AS agreed_dpgfor_instalments_at_71,
  t68.customer_id AS customer_id_72,
  t68.pay_later_general_terms_id AS pay_later_general_terms_id_73,
  t68.pay_later_contract_id AS pay_later_contract_id_74,
  t68.instalment_general_terms_id AS instalment_general_terms_id_75,
  t68.instalment_contract_id AS instalment_contract_id_76,
  t68.pay_later_sef_id AS pay_later_sef_id_77,
  t68.instalment_sef_id AS instalment_sef_id_78,
  t68.instalment4_general_terms_id AS instalment4_general_terms_id_79,
  t68.instalment4_contract_id AS instalment4_contract_id_80,
  t68.instalment4_sef_id AS instalment4_sef_id_81,
  t68.instalment6_general_terms_id AS instalment6_general_terms_id_82,
  t68.instalment6_contract_id AS instalment6_contract_id_83,
  t68.instalment6_sef_id AS instalment6_sef_id_84,
  t68.pay_later_contract_terminate_annex_id AS pay_later_contract_terminate_annex_id_85,
  t68.instalment_contract_terminate_annex_id AS instalment_contract_terminate_annex_id_86,
  t68.instalment6_contract_terminate_annex_id AS instalment6_contract_terminate_annex_id_87,
  t0.customer_api_token_id AS customer_api_token_id_88,
  t0.dtype,
  t0.shop_id AS shop_id_89
FROM
  users t0
  LEFT JOIN customer_profile t25 ON t25.customer_id = t0.id
  LEFT JOIN credit_card t50 ON t50.customer_id = t0.id
  LEFT JOIN login_key t61 ON t61.customer_id = t0.id
  LEFT JOIN documents t68 ON t68.customer_id = t0.id
WHERE
  t0.email IS NULL
  AND t0.dtype IN ('customer', 'testcustomer')
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.preferred_language AS preferred_language_8, t0.id_card_status AS id_card_status_9, t0.aml_status AS aml_status_10, t0.credit_score_status AS credit_score_status_11, t0.allowed_products AS allowed_products_12, t0.ondato_id AS ondato_id_13, t0.ondato_scan_ref AS ondato_scan_ref_14, t0.ondato_status AS ondato_status_15, t0.reason_to_block_account AS reason_to_block_account_16, t0.black_list_status AS black_list_status_17, t0.final_ondato_status AS final_ondato_status_18, t0.verification_status AS verification_status_19, t0.block_request AS block_request_20, t0.registration_country_allowed AS registration_country_allowed_21, t0.status AS status_22, t0.ondato_kyc_id AS ondato_kyc_id_23, t25.id AS id_24, t25.first_name AS first_name_26, t25.last_name AS last_name_27, t25.egn AS egn_28, t25.address AS address_29, t25.city AS city_30, t25.middle_name AS middle_name_31, t25.phone1 AS phone1_32, t25.phone2 AS phone2_33, t25.phone3 AS phone3_34, t25.notes AS notes_35, t25.ondato_pdf AS ondato_pdf_36, t25.regix_signature AS regix_signature_37, t25.regix_picture AS regix_picture_38, t25.regix_data AS regix_data_39, t25.extended_check_notes AS extended_check_notes_40, t25.has_been_redirected_from_ondato AS has_been_redirected_from_ondato_41, t25.unsuccessful_identification_reason AS unsuccessful_identification_reason_42, t25.newsletter_subscribed AS newsletter_subscribed_43, t25.registered_with_egn AS registered_with_egn_44, t25.created_at AS created_at_45, t25.updated_at AS updated_at_46, t25.customer_id AS customer_id_47, t25.ondato_document_id AS ondato_document_id_48, t50.id AS id_49, t50.valid_until AS valid_until_51, t50.number AS number_52, t50.type AS type_53, t50.cvc AS cvc_54, t50.name_on_card AS name_on_card_55, t50.created_at AS created_at_56, t50.updated_at AS updated_at_57, t50.customer_id AS customer_id_58, t0.id_card_id AS id_card_id_59, t61.id AS id_60, t61.`key` AS key_62, t61.code AS code_63, t61.expires_at AS expires_at_64, t61.customer_id AS customer_id_65, t0.credit_profile_id AS credit_profile_id_66, t68.id AS id_67, t68.agreed_dpgfor_pay_now_at AS agreed_dpgfor_pay_now_at_69, t68.agreed_dpgfor_pay_later_at AS agreed_dpgfor_pay_later_at_70, t68.agreed_dpgfor_instalments_at AS agreed_dpgfor_instalments_at_71, t68.customer_id AS customer_id_72, t68.pay_later_general_terms_id AS pay_later_general_terms_id_73, t68.pay_later_contract_id AS pay_later_contract_id_74, t68.instalment_general_terms_id AS instalment_general_terms_id_75, t68.instalment_contract_id AS instalment_contract_id_76, t68.pay_later_sef_id AS pay_later_sef_id_77, t68.instalment_sef_id AS instalment_sef_id_78, t68.instalment4_general_terms_id AS instalment4_general_terms_id_79, t68.instalment4_contract_id AS instalment4_contract_id_80, t68.instalment4_sef_id AS instalment4_sef_id_81, t68.instalment6_general_terms_id AS instalment6_general_terms_id_82, t68.instalment6_contract_id AS instalment6_contract_id_83, t68.instalment6_sef_id AS instalment6_sef_id_84, t68.pay_later_contract_terminate_annex_id AS pay_later_contract_terminate_annex_id_85, t68.instalment_contract_terminate_annex_id AS instalment_contract_terminate_annex_id_86, t68.instalment6_contract_terminate_annex_id AS instalment6_contract_terminate_annex_id_87, t0.customer_api_token_id AS customer_api_token_id_88, t0.dtype, t0.shop_id AS shop_id_89 FROM users t0 LEFT JOIN customer_profile t25 ON t25.customer_id = t0.id LEFT JOIN credit_card t50 ON t50.customer_id = t0.id LEFT JOIN login_key t61 ON t61.customer_id = t0.id LEFT JOIN documents t68 ON t68.customer_id = t0.id WHERE t0.email IS NULL AND t0.dtype IN ('customer', 'testcustomer') LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.ui_label AS ui_label_2,
  s0_.value AS value_3,
  s0_.readonly AS readonly_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6
FROM
  setting s0_
WHERE
  s0_.name = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = 'facebook_link' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.ui_label AS ui_label_2,
  s0_.value AS value_3,
  s0_.readonly AS readonly_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6
FROM
  setting s0_
WHERE
  s0_.name = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = 'instagram_link' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.ui_label AS ui_label_2,
  s0_.value AS value_3,
  s0_.readonly AS readonly_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6
FROM
  setting s0_
WHERE
  s0_.name = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.ui_label AS ui_label_2, s0_.value AS value_3, s0_.readonly AS readonly_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM setting s0_ WHERE s0_.name = 'linkedin_link' LIMIT 1;