Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.60 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.61 ms (62.03%)	1	SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.active AS active_8, t0.locale AS locale_9, t0.newsletter AS newsletter_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deactivate_date AS deactivate_date_13, t0.group_id AS group_id_14, t0.company_id AS company_id_15, t0.client_id AS client_id_16, t0.division_id AS division_id_17, t0.client_localization_id AS client_localization_id_18, t19.id AS id_20, t19.notifications AS notifications_21, t19.user_id AS user_id_22, t23.id AS id_24, t23.after_login_route AS after_login_route_25, t23.user_id AS user_id_26, t23.printer_id AS printer_id_27, t23.mqtt_broker_id AS mqtt_broker_id_28, t0.worker_id AS worker_id_29, t0.created_by AS created_by_30, t0.updated_by AS updated_by_31 FROM user t0 LEFT JOIN user_notification t19 ON t19.user_id = t0.id LEFT JOIN user_setting t23 ON t23.user_id = t0.id WHERE t0.id = ? Parameters: [`262`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.active AS active_8, t0.locale AS locale_9, t0.newsletter AS newsletter_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deactivate_date AS deactivate_date_13, t0.group_id AS group_id_14, t0.company_id AS company_id_15, t0.client_id AS client_id_16, t0.division_id AS division_id_17, t0.client_localization_id AS client_localization_id_18, t19.id AS id_20, t19.notifications AS notifications_21, t19.user_id AS user_id_22, t23.id AS id_24, t23.after_login_route AS after_login_route_25, t23.user_id AS user_id_26, t23.printer_id AS printer_id_27, t23.mqtt_broker_id AS mqtt_broker_id_28, t0.worker_id AS worker_id_29, t0.created_by AS created_by_30, t0.updated_by AS updated_by_31 FROM user t0 LEFT JOIN user_notification t19 ON t19.user_id = t0.id LEFT JOIN user_setting t23 ON t23.user_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.active AS active_8, t0.locale AS locale_9, t0.newsletter AS newsletter_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deactivate_date AS deactivate_date_13, t0.group_id AS group_id_14, t0.company_id AS company_id_15, t0.client_id AS client_id_16, t0.division_id AS division_id_17, t0.client_localization_id AS client_localization_id_18, t19.id AS id_20, t19.notifications AS notifications_21, t19.user_id AS user_id_22, t23.id AS id_24, t23.after_login_route AS after_login_route_25, t23.user_id AS user_id_26, t23.printer_id AS printer_id_27, t23.mqtt_broker_id AS mqtt_broker_id_28, t0.worker_id AS worker_id_29, t0.created_by AS created_by_30, t0.updated_by AS updated_by_31 FROM user t0 LEFT JOIN user_notification t19 ON t19.user_id = t0.id LEFT JOIN user_setting t23 ON t23.user_id = t0.id WHERE t0.id = 262;
0.99 ms (37.97%)	1	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;

Time▼

Count

Info

1.61 ms
(62.03%)

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.active AS active_8, t0.locale AS locale_9, t0.newsletter AS newsletter_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deactivate_date AS deactivate_date_13, t0.group_id AS group_id_14, t0.company_id AS company_id_15, t0.client_id AS client_id_16, t0.division_id AS division_id_17, t0.client_localization_id AS client_localization_id_18, t19.id AS id_20, t19.notifications AS notifications_21, t19.user_id AS user_id_22, t23.id AS id_24, t23.after_login_route AS after_login_route_25, t23.user_id AS user_id_26, t23.printer_id AS printer_id_27, t23.mqtt_broker_id AS mqtt_broker_id_28, t0.worker_id AS worker_id_29, t0.created_by AS created_by_30, t0.updated_by AS updated_by_31 FROM user t0 LEFT JOIN user_notification t19 ON t19.user_id = t0.id LEFT JOIN user_setting t23 ON t23.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  262
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.lastname AS lastname_6,
  t0.email AS email_7,
  t0.active AS active_8,
  t0.locale AS locale_9,
  t0.newsletter AS newsletter_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deactivate_date AS deactivate_date_13,
  t0.group_id AS group_id_14,
  t0.company_id AS company_id_15,
  t0.client_id AS client_id_16,
  t0.division_id AS division_id_17,
  t0.client_localization_id AS client_localization_id_18,
  t19.id AS id_20,
  t19.notifications AS notifications_21,
  t19.user_id AS user_id_22,
  t23.id AS id_24,
  t23.after_login_route AS after_login_route_25,
  t23.user_id AS user_id_26,
  t23.printer_id AS printer_id_27,
  t23.mqtt_broker_id AS mqtt_broker_id_28,
  t0.worker_id AS worker_id_29,
  t0.created_by AS created_by_30,
  t0.updated_by AS updated_by_31
FROM
  user t0
  LEFT JOIN user_notification t19 ON t19.user_id = t0.id
  LEFT JOIN user_setting t23 ON t23.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.active AS active_8, t0.locale AS locale_9, t0.newsletter AS newsletter_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deactivate_date AS deactivate_date_13, t0.group_id AS group_id_14, t0.company_id AS company_id_15, t0.client_id AS client_id_16, t0.division_id AS division_id_17, t0.client_localization_id AS client_localization_id_18, t19.id AS id_20, t19.notifications AS notifications_21, t19.user_id AS user_id_22, t23.id AS id_24, t23.after_login_route AS after_login_route_25, t23.user_id AS user_id_26, t23.printer_id AS printer_id_27, t23.mqtt_broker_id AS mqtt_broker_id_28, t0.worker_id AS worker_id_29, t0.created_by AS created_by_30, t0.updated_by AS updated_by_31 FROM user t0 LEFT JOIN user_notification t19 ON t19.user_id = t0.id LEFT JOIN user_setting t23 ON t23.user_id = t0.id WHERE t0.id = 262;

0.99 ms
(37.97%)

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;

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

Entities Mapping

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

Symfony Profiler

GET https://vps-63a4a332.vps.ovh.net/

Configuration Settings

Theme

Page Width