https://mmwec-api.dev.knectar.com/api/upload_datas/daterange/file

Query Metrics

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

Queries

Group similar statements

custom connection

# Time Info
1 0.51 ms
SELECT t0.id AS id_1, t0.token AS token_2, t0.user_id AS user_id_3 FROM api_token t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "917ee1c4e21a9a1455e6ebb4bee14cb67cb41dbb7e0518c57f1b2bbc99ad8f4a"
]
2 0.22 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]

default connection

# Time Info
1 21.73 ms
SELECT CONCAT(MIN(tt.file_date), ':', MAX(tt.file_date)) as years_renage
  FROM (
    SELECT DATE_FORMAT(d.file_date, "%Y") as file_date
    FROM upload_data d
      WHERE d.page_id = 263
    GROUP BY d.file_date
  ) tt
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
custom doctrine.dbal.custom_connection

Entity Managers

Name Service
auto_generate_proxy_classes doctrine.orm.auto_generate_proxy_classes_entity_manager
auto_mapping doctrine.orm.auto_mapping_entity_manager
default doctrine.orm.default_entity_manager
custom doctrine.orm.custom_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

auto_generate_proxy_classes entity manager

No loaded entities.

auto_mapping entity manager

No loaded entities.

default entity manager

No loaded entities.

custom entity manager

Class Mapping errors
App\Entity\Custom\ApiToken No errors.
App\Entity\Custom\User No errors.