https://admin.paynetics.dev/applications

Query Metrics

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

Grouped Statements

Show all queries

default connection

Time Count Info
3.82 ms
(1.11%)
1
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.16 ms
(0.63%)
1
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
]
1.97 ms
(0.57%)
1
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 Count Info
213.21 ms
(61.86%)
1
SELECT COUNT(DISTINCT app.app_id) FROM `t_application` app WHERE app.app_is_deleted = ?
Parameters:
[
  0
]
109.92 ms
(31.89%)
1
SELECT DISTINCT app.* FROM `t_application` app WHERE app.app_is_deleted = ? ORDER BY app.app_created_at DESC LIMIT 0, 20
Parameters:
[
  0
]
13.60 ms
(3.95%)
1
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.