Query Metrics
2
Database Queries
2
Different statements
3.36 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.79 ms (53.35%) |
1 |
SELECT t0.email AS email_1, t0.name AS name_2, t0.surname AS surname_3, t0.full_name AS full_name_4, t0.is_active AS is_active_5, t0.roles AS roles_6, t0.is_back_office_user AS is_back_office_user_7, t0.password AS password_8, t0.auth_code AS auth_code_9, t0.temp_password AS temp_password_10, t0.google_auth_id AS google_auth_id_11, t0.uid AS uid_12, t0.forgot_password_created_time AS forgot_password_created_time_13, t0.forgot_password_updated_time AS forgot_password_updated_time_14, t0.id AS id_15, t0.created_at AS created_at_16, t17.avatar AS avatar_18, t17.greeting AS greeting_19, t17.title AS title_20, t17.gender AS gender_21, t17.name AS name_22, t17.middle_name AS middle_name_23, t17.surname AS surname_24, t17.name_org AS name_org_25, t17.middle_name_org AS middle_name_org_26, t17.surname_org AS surname_org_27, t17.identity_number AS identity_number_28, t17.birthday AS birthday_29, t17.nationality AS nationality_30, t17.phone AS phone_31, t17.email AS email_32, t17.company_uid AS company_uid_33, t17.employee_number AS employee_number_34, t17.division AS division_35, t17.location_id AS location_id_36, t17.department_customer_id AS department_customer_id_37, t17.cmg_number AS cmg_number_38, t17.project_number AS project_number_39, t17.sap_code AS sap_code_40, t17.id AS id_41, t17.created_at AS created_at_42, t17.deleted_at AS deleted_at_43, t17.is_deleted AS is_deleted_44, t17.company_id AS company_id_45, t17.related_user_id AS related_user_id_46, t17.department_id AS department_id_47, t17.job_title_id AS job_title_id_48, t17.cost_center_id AS cost_center_id_49, t17.rule_id AS rule_id_50, t17.created_by_id AS created_by_id_51, t17.deleted_by_id AS deleted_by_id_52, t0.company_id AS company_id_53, t0.created_by_id AS created_by_id_54 FROM users t0 LEFT JOIN company_persons t17 ON t17.related_user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
"mustafa.turan@atgturkey.com"
]
|
1.57 ms (46.65%) |
1 |
SELECT t0.name AS name_1, t0.currency AS currency_2, t0.is_active AS is_active_3, t0.parent AS parent_4, t0.children AS children_5, t0.users AS users_6, t0.uid AS uid_7, t0.location_type AS location_type_8, t0.notification_email AS notification_email_9, t0.credit AS credit_10, t0.credit_balance AS credit_balance_11, t0.corporate_card_id AS corporate_card_id_12, t0.vat_number AS vat_number_13, t0.vat_office AS vat_office_14, t0.registration_number AS registration_number_15, t0.is_credit_active AS is_credit_active_16, t0.contact_name AS contact_name_17, t0.contact_phone AS contact_phone_18, t0.contact_email AS contact_email_19, t0.finance_contact_name AS finance_contact_name_20, t0.finance_contact_phone AS finance_contact_phone_21, t0.finance_contact_email AS finance_contact_email_22, t0.id AS id_23 FROM companies t0 WHERE t0.id = ?
Parameters:
[
"2"
]
|
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\User |
|
App\Entity\Company\Person | No errors. |
App\Entity\Company |
|
App\Entity\Term | No errors. |
App\Entity\Company\Person\Rule |
|