https://bio-moosod.com/ Return to referer URL

Query Metrics

3 Database Queries
3 Different statements
6.60 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.66 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.lastname AS lastname_5, t0.flag_status AS flag_status_6, t0.id_card_no AS id_card_no_7, t0.pic AS pic_8, t0.address AS address_9, t0.province AS province_10, t0.name AS name_11, t0.ref_id AS ref_id_12, t0.passkey AS passkey_13, t0.branch_id AS branch_id_14, t0.app_role_id AS app_role_id_15 FROM user t0 WHERE t0.id = ?
Parameters:
[
  26
]
2 0.13 ms
SELECT t0.id AS id_1, t0.ref_id AS ref_id_2, t0.branch_ref_key AS branch_ref_key_3, t0.branch_id AS branch_id_4, t0.branch_code AS branch_code_5, t0.branch_name AS branch_name_6, t0.address AS address_7, t0.postel AS postel_8, t0.update_by AS update_by_9, t0.update_date AS update_date_10, t0.flag_status AS flag_status_11, t0.flag_show_product_cost AS flag_show_product_cost_12, t0.flag_show_product_balance AS flag_show_product_balance_13, t0.province_key AS province_key_14 FROM branch t0
Parameters:
[]
3 5.81 ms
SELECT s0_.id AS id_0, s0_.report_date AS report_date_1, s0_.total_cost AS total_cost_2, s0_.total_sale AS total_sale_3, s0_.ref_id AS ref_id_4, s0_.flag_status AS flag_status_5, s0_.branch_id AS branch_id_6 FROM sale_report s0_ WHERE (s0_.report_date >= ? AND s0_.report_date < ?) AND s0_.flag_status = ?
Parameters:
[
  "2024-11-14 00:00:00"
  "2024-11-14  23:59:59"
  1
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Branch No errors.
App\Entity\AppRole No errors.
App\Entity\SaleReport No errors.
App\Entity\Province No errors.
App\Entity\SaleReportDetail No errors.