POST http://pawelvivobook.tail089c3d.ts.net/login

Query Metrics

5 Database Queries
5 Different statements
11.27 ms Query time
0 Invalid entities
11 Managed entities

Queries

Group similar statements

# Time Info
1 0.68 ms
SELECT u0_.id AS id_0, u0_.login AS login_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.lastname AS lastname_5, u0_.email AS email_6, u0_.active AS active_7, u0_.locale AS locale_8, u0_.newsletter AS newsletter_9, u0_.created_at AS created_at_10, u0_.updated_at AS updated_at_11, u0_.deactivate_date AS deactivate_date_12, u0_.group_id AS group_id_13, u0_.company_id AS company_id_14, u0_.client_id AS client_id_15, u0_.division_id AS division_id_16, u0_.client_localization_id AS client_localization_id_17, u0_.worker_id AS worker_id_18, u0_.created_by AS created_by_19, u0_.updated_by AS updated_by_20 FROM user u0_ WHERE u0_.login = ? OR u0_.email = ?
Parameters:
[
  "serwis@aska.com.pl"
  "serwis@aska.com.pl"
]
2 1.82 ms
SELECT t0.id AS id_1, t0.notifications AS notifications_2, t0.user_id AS user_id_3 FROM user_notification t0 WHERE t0.user_id = ?
Parameters:
[
  184
]
3 1.35 ms
SELECT t0.id AS id_1, t0.after_login_route AS after_login_route_2, t0.user_id AS user_id_3, t0.printer_id AS printer_id_4, t0.mqtt_broker_id AS mqtt_broker_id_5 FROM user_setting t0 WHERE t0.user_id = ?
Parameters:
[
  184
]
4 4.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t6.id AS id_7, t6.permissions AS permissions_8, t6.role_id AS role_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM user_role t0 LEFT JOIN role_permission t6 ON t6.role_id = t0.id INNER JOIN user_role_user ON t0.id = user_role_user.user_role_id WHERE user_role_user.user_id = ?
Parameters:
[
  184
]
5 2.94 ms
SELECT t0.id AS id_1, t0.company AS company_2, t0.nip AS nip_3, t0.regon AS regon_4, t0.post_code AS post_code_5, t0.city AS city_6, t0.address AS address_7, t0.image_name AS image_name_8, t0.permissions AS permissions_9, t0.footer_www AS footer_www_10, t0.footer_phone AS footer_phone_11, t0.footer_email AS footer_email_12, t0.report_settings AS report_settings_13, t0.active AS active_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deactivate_date AS deactivate_date_17, t18.id AS id_19, t18.locker_settings AS locker_settings_20, t18.alert_settings AS alert_settings_21, t18.base_settings AS base_settings_22, t18.report_columns AS report_columns_23, t18.client_reports AS client_reports_24, t18.worker_name_format AS worker_name_format_25, t18.product_amortization_activation AS product_amortization_activation_26, t18.product_batch_creation_mode AS product_batch_creation_mode_27, t18.alert_product_batch_creation AS alert_product_batch_creation_28, t18.fakturownia_host AS fakturownia_host_29, t18.fakturownia_api_token AS fakturownia_api_token_30, t18.fakturownia_department_id AS fakturownia_department_id_31, t18.company_id AS company_id_32, t18.printer_default_id AS printer_default_id_33, t0.created_by AS created_by_34, t0.updated_by AS updated_by_35 FROM company t0 LEFT JOIN company_setting t18 ON t18.company_id = t0.id WHERE t0.id = ?
Parameters:
[
  6
]

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 3
App\Entity\UserRole 3
App\Entity\RolePermission 2
App\Entity\Company 1
App\Entity\UserSetting 1
App\Entity\CompanySetting 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Faq No errors.
App\Entity\ProductOrder No errors.
App\Entity\Numeration No errors.
App\Entity\ClothesServiceEvent No errors.
App\Entity\QrCode No errors.
App\Entity\Company No errors.
App\Entity\ProductAttributeGroupRelationCompany No errors.
App\Entity\Newsletter No errors.
App\Entity\AmortizationCirculationItem No errors.
App\Entity\ProductAttributeGroup No errors.
App\Entity\TextileTemplate No errors.
App\Entity\PriceBatch No errors.
App\Entity\ProductBatchHistory No errors.
App\Entity\StickyNote No errors.
App\Entity\Alert No errors.
App\Entity\AmortizationCirculation No errors.
App\Entity\ReportSettings No errors.
App\Entity\ProductKit No errors.
App\Entity\EquipmentRental No errors.
App\Entity\ProductBatch No errors.
App\Entity\Settings No errors.
App\Entity\Product No errors.
App\Entity\Worker No errors.
App\Entity\ClientPermission No errors.
App\Entity\AmortizationPriceItem No errors.
App\Entity\StateStatus No errors.
App\Entity\Task No errors.
App\Entity\CassationObjects No errors.
App\Entity\ClientLocalization No errors.
App\Entity\Printer No errors.
App\Entity\ClothesServiceReason No errors.
App\Entity\Module No errors.
App\Entity\StorageHistory No errors.
App\Entity\Attribute No errors.
App\Entity\ClothesGroup No errors.
App\Entity\PhysicalInventory No errors.
App\Entity\CassationType No errors.
App\Entity\UserSetting No errors.
App\Entity\Clothe No errors.
App\Entity\AmortizationSuspension No errors.
App\Entity\AmortizationContract No errors.
App\Entity\StateHistoryArchive No errors.
App\Entity\PermissionGroup No errors.
App\Entity\Notification No errors.
App\Entity\Inventory No errors.
App\Entity\UserNotification No errors.
App\Entity\RolePermission No errors.
App\Entity\BatchJob No errors.
App\Entity\Storage No errors.
App\Entity\ClotheSetting No errors.
App\Entity\ProductOrderItem No errors.
App\Entity\Equipment No errors.
App\Entity\CirculationItem No errors.
App\Entity\ClothesService No errors.
App\Entity\StorageDocument No errors.
App\Entity\Group No errors.
App\Entity\PriceMaintenance No errors.
App\Entity\CompanySetting No errors.
App\Entity\StateRoadMap No errors.
App\Entity\FaqTag No errors.
App\Entity\Log No errors.
App\Entity\EquipmentType No errors.
App\Entity\Document No errors.
App\Entity\Circulation No errors.
App\Entity\MqttBroker No errors.
App\Entity\Settlement No errors.
App\Entity\Box No errors.
App\Entity\Tag No errors.
App\Entity\Client No errors.
App\Entity\ProductReturned No errors.
App\Entity\LumpSumAgreement No errors.
App\Entity\PriceItem No errors.
App\Entity\ProductBatchArchive No errors.
App\Entity\ProductAttribute No errors.
App\Entity\ClientGroup No errors.
App\Entity\AmortizationPrice No errors.
App\Entity\Division No errors.
App\Entity\ClientLaundry No errors.
App\Entity\InvoiceItem No errors.
App\Entity\ProductWithdrawal No errors.
App\Entity\EquipmentClient No errors.
App\Entity\Size No errors.
App\Entity\Invoice No errors.
App\Entity\Cassation No errors.
App\Entity\Amortization No errors.
App\Entity\ProductAttributeGroupRelationClient No errors.
App\Entity\Locker No errors.
App\Entity\AlertGroup No errors.
App\Entity\Device No errors.
App\Entity\Price No errors.
App\Entity\PrintTemplate No errors.
App\Entity\DeviceError No errors.
App\Entity\FaqFile No errors.
App\Entity\PriceStorage No errors.
App\Entity\SettlementAdditionalReturnItem No errors.
App\Entity\ProductState No errors.
App\Entity\DeviceRead No errors.
App\Entity\ProductLock No errors.
App\Entity\ProductLog No errors.
App\Entity\Permission No errors.
App\Entity\ProductReturnedItem No errors.
App\Entity\InventoryGroup No errors.
App\Entity\UserRole No errors.
App\Entity\ProductWithdrawalItem No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\SettlementItem No errors.
App\Entity\StateHistory No errors.
Vich\UploaderBundle\Entity\File No errors.