Query Metrics
1
Database Queries
1
Different statements
1.72 ms
Query time
2
Invalid entities
3
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.72 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_admin AS is_admin_3, t0.is_super_admin AS is_super_admin_4, t0.is_verified AS is_verified_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.email AS email_8, t0.stripe_customer_id AS stripe_customer_id_9, t0.phone AS phone_10, t0.encoded_password AS encoded_password_11, t0.salt AS salt_12, t0.requested_organization AS requested_organization_13, t0.job_title AS job_title_14, t0.department AS department_15, t0.is_department AS is_department_16, t0.register_as_individual AS register_as_individual_17, t0.address_first AS address_first_18, t0.address_second AS address_second_19, t0.city AS city_20, t0.zip_code AS zip_code_21, t0.state_name AS state_name_22, t0.notes AS notes_23, t0.forget_password_code AS forget_password_code_24, t0.forget_password_valid_until AS forget_password_valid_until_25, t0.last_login_date AS last_login_date_26, t0.last_login_ip AS last_login_ip_27, t0.enabled AS enabled_28, t0.view_only AS view_only_29, t0.password_valid_until AS password_valid_until_30, t0.is_blocked AS is_blocked_31, t0.last_unblock_time AS last_unblock_time_32, t0.send_auto_generated_reports AS send_auto_generated_reports_33, t0.is_caruser AS is_caruser_34, t0.created_by AS created_by_35, t0.updated_by AS updated_by_36, t0.deleted_date AS deleted_date_37, t0.created_date AS created_date_38, t0.updated_date AS updated_date_39, t0.organization_id AS organization_id_40, t0.municipality_id AS municipality_id_41, t42.id AS id_43, t42.type AS type_44, t42.name AS name_45, t42.ordinances_url AS ordinances_url_46, t42.contact_name AS contact_name_47, t42.contact_email AS contact_email_48, t42.contact_phone AS contact_phone_49, t42.notes AS notes_50, t42.domains AS domains_51, t42.zipcodes AS zipcodes_52, t42.active AS active_53, t42.can_upload_document AS can_upload_document_54, t42.enable_multiple_registration_forms AS enable_multiple_registration_forms_55, t42.enable_staging_tracking AS enable_staging_tracking_56, t42.sbl_enabled AS sbl_enabled_57, t42.created_by AS created_by_58, t42.updated_by AS updated_by_59, t42.deleted_date AS deleted_date_60, t42.created_date AS created_date_61, t42.updated_date AS updated_date_62, t42.state_id AS state_id_63, t42.registrant_id AS registrant_id_64, t0.state_id AS state_id_65, t0.country_id AS country_id_66 FROM user t0 LEFT JOIN municipality t42 ON t0.municipality_id = t42.id AND ((t42.deleted_date IS NULL)) WHERE t0.id = ? AND ((t0.deleted_date IS NULL))
Parameters:
[
37
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User | 1 |
| App\Entity\State | 1 |
| App\Entity\Country | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Invoice | No errors. |
| App\Entity\LatePaymentChargeLogs | No errors. |
| App\Entity\SupportTicket | No errors. |
| App\Entity\InvoiceSupportTicket | No errors. |
| App\Entity\ClientFee | No errors. |
| App\Entity\MunicipalityFee | No errors. |
| App\Entity\Zone | No errors. |
| App\Entity\Form | No errors. |
| App\Entity\RenewalForm | No errors. |
| App\Entity\MunicipalityLateFees | No errors. |
| App\Entity\EmployeeMunicipalityAssignment | No errors. |
| App\Entity\Property |
|
| App\Entity\PropertyWorkRequest | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Organization | No errors. |
| App\Entity\Municipality |
|
| App\Entity\State | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\ChangeLog | No errors. |
| App\Entity\UserChangeLog | No errors. |
| App\Entity\UserNotification | No errors. |
| App\Entity\UserReview | No errors. |