Symfony Profiler

https://dev.swc-empire.com/p/library

Method: GET
HTTP Status: 500
IP: 23.249.160.156
Profiled on: Fri, 04 Jul 2025 15:36:14 +0000
Token: b522bd

Last 10 Latest Search

Settings

Query Metrics

14 Database Queries

5 Different statements

16.65 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
9.12 ms (54.75%)	3	SELECT * FROM CLEARANCE WHERE CLEA_ORDER = 2 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM CLEARANCE WHERE CLEA_ORDER = 2 SELECT * FROM CLEARANCE WHERE CLEA_ORDER = 2;
4.54 ms (27.24%)	6	SELECT * FROM BRANCH WHERE BRAN_ID IN (?) Parameters: [`[ "9" ]`] View formatted query View runnable query Explain query SELECT * FROM BRANCH WHERE BRAN_ID IN (?) SELECT * FROM BRANCH WHERE BRAN_ID IN ('9');
2.12 ms (12.73%)	1	SELECT * FROM DOCUMENT_LIBRARY WHERE DOLI_STATUS = 1 ORDER BY BRAN_ID DESC, DOLI_RELEASE DESC Parameters: [] View formatted query View runnable query Explain query SELECT * FROM DOCUMENT_LIBRARY WHERE DOLI_STATUS = 1 ORDER BY BRAN_ID DESC, DOLI_RELEASE DESC SELECT * FROM DOCUMENT_LIBRARY WHERE DOLI_STATUS = 1 ORDER BY BRAN_ID DESC, DOLI_RELEASE DESC;
0.68 ms (4.07%)	3	SELECT * FROM CLEARANCE WHERE CLEA_ORDER = 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM CLEARANCE WHERE CLEA_ORDER = 1 SELECT * FROM CLEARANCE WHERE CLEA_ORDER = 1;
0.20 ms (1.21%)	1	SELECT * FROM CLEARANCE WHERE CLEA_ORDER = 0 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM CLEARANCE WHERE CLEA_ORDER = 0 SELECT * FROM CLEARANCE WHERE CLEA_ORDER = 0;

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

No loaded entities.