GET https://quin.riskplaza.nl/maintenance/status

Query Metrics

7 Database Queries
6 Different statements
6.87 ms Query time
0 Invalid entities
10 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.52 ms
(22.17%)
1
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
]
1.39 ms
(20.28%)
2
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:
[]
1.38 ms
(20.12%)
1
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
]
0.98 ms
(14.21%)
1
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
]
0.91 ms
(13.21%)
1
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
]
0.69 ms
(10.00%)
1
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
]

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.