https://admin.paynetics.dev/applications

Query Metrics

6 Database Queries
6 Different statements
344.69 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 3.82 ms
SELECT t0.id AS id_1, t0.token AS token_2, t0.username AS username_3, t0.password AS password_4 FROM t_admin_user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 2.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.users_id AS users_id_3 FROM t_role t0 WHERE t0.users_id = ?
Parameters:
[
  1
]
3 1.97 ms
SELECT t0.id AS id_1, t0.token AS token_2, t0.username AS username_3, t0.password AS password_4 FROM t_admin_user t0
Parameters:
[]

clickhouse connection

# Time Info
1 213.21 ms
SELECT COUNT(DISTINCT app.app_id) FROM `t_application` app WHERE app.app_is_deleted = ?
Parameters:
[
  0
]
2 109.92 ms
SELECT DISTINCT app.* FROM `t_application` app WHERE app.app_is_deleted = ? ORDER BY app.app_created_at DESC LIMIT 0, 20
Parameters:
[
  0
]
3 13.60 ms
SELECT * FROM `t_application_product_status` WHERE (`t_application_product_status`.application_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (is_deleted = 0)
Parameters:
[
  761
  760
  759
  758
  757
  756
  755
  754
  753
  752
  751
  750
  749
  748
  747
  746
  745
  744
  743
  742
]

Database Connections

Name Service
default doctrine.dbal.default_connection
clickhouse doctrine.dbal.clickhouse_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\Role No errors.