Query Metrics
7
Database Queries
6
Different statements
7.19 ms
Query time
0
Invalid entities
10
Managed entities
Queries
default connection
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.28 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.active AS active_7, t0.last_login AS last_login_8, t0.first_name AS first_name_9, t0.middle_name AS middle_name_10, t0.last_name AS last_name_11, t0.phone_number AS phone_number_12, t0.newsletter AS newsletter_13, t0.token AS token_14, t0.token_created AS token_created_15, t0.verification_cookie AS verification_cookie_16, t0.expiration_date AS expiration_date_17, t0.start_date AS start_date_18, t0.system_expert AS system_expert_19, t0.sparkpost_mail_confidence AS sparkpost_mail_confidence_20, t0.password_reset_required AS password_reset_required_21, t0.soft_delete AS soft_delete_22 FROM user t0 WHERE t0.id = ?
Parameters:
[
3124
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.88 ms |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.account_id AS account_id_3 FROM account_user t0 WHERE t0.user_id = ? AND t0.account_id = ? LIMIT 1
Parameters:
[ 3124 302 ] |
||||||||||||||||||||||||||||||||
| 3 | 1.73 ms |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t3.id AS id_4, t3.created_at AS created_at_5, t3.updated_at AS updated_at_6, t3.email AS email_7, t3.roles AS roles_8, t3.password AS password_9, t3.active AS active_10, t3.last_login AS last_login_11, t3.first_name AS first_name_12, t3.middle_name AS middle_name_13, t3.last_name AS last_name_14, t3.phone_number AS phone_number_15, t3.newsletter AS newsletter_16, t3.token AS token_17, t3.token_created AS token_created_18, t3.verification_cookie AS verification_cookie_19, t3.expiration_date AS expiration_date_20, t3.start_date AS start_date_21, t3.system_expert AS system_expert_22, t3.sparkpost_mail_confidence AS sparkpost_mail_confidence_23, t3.password_reset_required AS password_reset_required_24, t3.soft_delete AS soft_delete_25, t0.account_id AS account_id_26, t27.id AS id_28, t27.created_at AS created_at_29, t27.updated_at AS updated_at_30, t27.active AS active_31, t27.name AS name_32, t27.location AS location_33, t27.owner_id AS owner_id_34, t27.street AS street_35, t27.house_number AS house_number_36, t27.postal_code AS postal_code_37, t27.city AS city_38, t27.country_id AS country_id_39, t27.email AS email_40, t27.phone AS phone_41, t27.website AS website_42, t27.logo AS logo_43, t27.certificate_file AS certificate_file_44, t27.certificate_supplement AS certificate_supplement_45, t27.btw_nr AS btw_nr_46, t27.sector_id AS sector_id_47, t27.max_users AS max_users_48, t27.audit_plus AS audit_plus_49, t27.cleanup_reference_date AS cleanup_reference_date_50, t27.is_certifying_body AS is_certifying_body_51, t27.expiration_date AS expiration_date_52, t27.start_date AS start_date_53, t27.certifying_body_id AS certifying_body_id_54, t27.chamber_of_commerce_nr AS chamber_of_commerce_nr_55, t27.debtor_number AS debtor_number_56, t27.has_demo AS has_demo_57, t27.is_verified AS is_verified_58, t27.use_legacy_ingredient_groups AS use_legacy_ingredient_groups_59, t27.audit_plus_expire_warned AS audit_plus_expire_warned_60, t27.soft_delete AS soft_delete_61, t0.action_id AS action_id_62, t63.id AS id_64, t63.name AS name_65, t63.action_key AS action_key_66, t63.reset_roles AS reset_roles_67, t63.bo_action AS bo_action_68, t63.admin_controlled AS admin_controlled_69, t63.limit_modules AS limit_modules_70, t0.module_id AS module_id_71, t72.id AS id_73, t72.created_at AS created_at_74, t72.updated_at AS updated_at_75, t72.has_demo AS has_demo_76, t72.name AS name_77, t72.sort_id AS sort_id_78, t72.icon AS icon_79, t72.bo_only AS bo_only_80, t72.for_sale AS for_sale_81, t72.soft_delete AS soft_delete_82 FROM permission t0 LEFT JOIN user t3 ON t0.user_id = t3.id LEFT JOIN account t27 ON t0.account_id = t27.id LEFT JOIN action t63 ON t0.action_id = t63.id LEFT JOIN module t72 ON t0.module_id = t72.id WHERE t0.account_id = ? AND t0.user_id = ? AND t0.module_id = ? AND t0.action_id = ? LIMIT 1
Parameters:
[ 302 3124 4 4 ] |
||||||||||||||||||||||||||||||||
| 4 | 1.03 ms |
SELECT t0.id AS id_1, t0.account_id AS account_id_2, t0.module_id AS module_id_3, t0.is_demo AS is_demo_4, t0.module_expiration_date AS module_expiration_date_5, t0.start_date AS start_date_6, t0.is_active AS is_active_7, t0.ordered AS ordered_8 FROM account_module t0 WHERE t0.account_id = ? AND t0.is_active = ?
Parameters:
[ 302 1 ]
|
||||||||||||||||||||||||||||||||
| 5 | 0.83 ms |
SELECT t0.id AS id_1, t0.module_id AS module_id_2, t0.release_date AS release_date_3, t0.status AS status_4, t0.version AS version_5 FROM published_release t0 WHERE t0.status = ? ORDER BY t0.release_date DESC LIMIT 1
Parameters:
[
100
]
|
||||||||||||||||||||||||||||||||
| 6 | 0.72 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4 FROM maintenance_mode t0
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 7 | 0.72 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4 FROM maintenance_mode t0
Parameters:
[]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| legacy | doctrine.dbal.legacy_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| legacy | doctrine.orm.legacy_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Main\AccountModule | 7 |
| App\Entity\Main\User | 1 |
| App\Entity\Main\AccountUser | 1 |
| App\Entity\Main\PublishedRelease | 1 |
legacy entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Main\AbstractBaseEntity | No errors. |
| App\Entity\Main\User | No errors. |
| App\Entity\Main\Permission | No errors. |
| App\Entity\Main\AccountUser | No errors. |
| App\Entity\Main\Account | No errors. |
| App\Entity\Main\Action | No errors. |
| App\Entity\Main\Module | No errors. |
| App\Entity\Main\AccountModule | No errors. |
| App\Entity\Main\PublishedRelease | No errors. |
| App\Entity\Main\MaintenanceMode | No errors. |
legacy entity manager
No loaded entities.