Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

3.45 ms Query time

0 Invalid entities

12 Managed entities

Queries


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_.cartrack_driver_id AS cartrack_driver_id_10, u0_.created_at AS created_at_11, u0_.updated_at AS updated_at_12, u0_.deactivate_date AS deactivate_date_13, u0_.group_id AS group_id_14, u0_.company_id AS company_id_15, u0_.client_id AS client_id_16, u0_.division_id AS division_id_17, u0_.client_localization_id AS client_localization_id_18, u0_.worker_id AS worker_id_19, u0_.created_by AS created_by_20, u0_.updated_by AS updated_by_21 FROM user u0_ WHERE u0_.login = ? OR u0_.email = ?
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 = ?
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 = ?
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 = ?
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.cartrack_base_url AS cartrack_base_url_32, t18.cartrack_basic_auth_username AS cartrack_basic_auth_username_33, t18.cartrack_basic_auth_password AS cartrack_basic_auth_password_34, t18.company_id AS company_id_35, t18.printer_default_id AS printer_default_id_36, t0.created_by AS created_by_37, t0.updated_by AS updated_by_38 FROM company t0 LEFT JOIN company_setting t18 ON t18.company_id = t0.id WHERE t0.id = ?

#▲	Time	Info
1	1.48 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_.cartrack_driver_id AS cartrack_driver_id_10, u0_.created_at AS created_at_11, u0_.updated_at AS updated_at_12, u0_.deactivate_date AS deactivate_date_13, u0_.group_id AS group_id_14, u0_.company_id AS company_id_15, u0_.client_id AS client_id_16, u0_.division_id AS division_id_17, u0_.client_localization_id AS client_localization_id_18, u0_.worker_id AS worker_id_19, u0_.created_by AS created_by_20, u0_.updated_by AS updated_by_21 FROM user u0_ WHERE u0_.login = ? OR u0_.email = ? Parameters: [`"damians2@aska.com.pl" "damians2@aska.com.pl"`] View formatted query View runnable query Explain query 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_.cartrack_driver_id AS cartrack_driver_id_10, u0_.created_at AS created_at_11, u0_.updated_at AS updated_at_12, u0_.deactivate_date AS deactivate_date_13, u0_.group_id AS group_id_14, u0_.company_id AS company_id_15, u0_.client_id AS client_id_16, u0_.division_id AS division_id_17, u0_.client_localization_id AS client_localization_id_18, u0_.worker_id AS worker_id_19, u0_.created_by AS created_by_20, u0_.updated_by AS updated_by_21 FROM user u0_ WHERE u0_.login = ? OR u0_.email = ? 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_.cartrack_driver_id AS cartrack_driver_id_10, u0_.created_at AS created_at_11, u0_.updated_at AS updated_at_12, u0_.deactivate_date AS deactivate_date_13, u0_.group_id AS group_id_14, u0_.company_id AS company_id_15, u0_.client_id AS client_id_16, u0_.division_id AS division_id_17, u0_.client_localization_id AS client_localization_id_18, u0_.worker_id AS worker_id_19, u0_.created_by AS created_by_20, u0_.updated_by AS updated_by_21 FROM user u0_ WHERE u0_.login = 'damians2@aska.com.pl' OR u0_.email = 'damians2@aska.com.pl';
2	0.47 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: [`262`] View formatted query View runnable query Explain query 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 = ? 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 = 262;
3	0.43 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: [`262`] View formatted query View runnable query Explain query 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 = ? 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 = 262;
4	0.58 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: [`262`] View formatted query View runnable query Explain query 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 = ? 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 = 262;
5	0.49 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.cartrack_base_url AS cartrack_base_url_32, t18.cartrack_basic_auth_username AS cartrack_basic_auth_username_33, t18.cartrack_basic_auth_password AS cartrack_basic_auth_password_34, t18.company_id AS company_id_35, t18.printer_default_id AS printer_default_id_36, t0.created_by AS created_by_37, t0.updated_by AS updated_by_38 FROM company t0 LEFT JOIN company_setting t18 ON t18.company_id = t0.id WHERE t0.id = ? Parameters: [`18`] View formatted query View runnable query Explain query 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.cartrack_base_url AS cartrack_base_url_32, t18.cartrack_basic_auth_username AS cartrack_basic_auth_username_33, t18.cartrack_basic_auth_password AS cartrack_basic_auth_password_34, t18.company_id AS company_id_35, t18.printer_default_id AS printer_default_id_36, t0.created_by AS created_by_37, t0.updated_by AS updated_by_38 FROM company t0 LEFT JOIN company_setting t18 ON t18.company_id = t0.id WHERE t0.id = ? 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.cartrack_base_url AS cartrack_base_url_32, t18.cartrack_basic_auth_username AS cartrack_basic_auth_username_33, t18.cartrack_basic_auth_password AS cartrack_basic_auth_password_34, t18.company_id AS company_id_35, t18.printer_default_id AS printer_default_id_36, t0.created_by AS created_by_37, t0.updated_by AS updated_by_38 FROM company t0 LEFT JOIN company_setting t18 ON t18.company_id = t0.id WHERE t0.id = 18;

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

Entities Mapping

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

Symfony Profiler

POST https://vps-63a4a332.vps.ovh.net/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping