Query Metrics
1
Database Queries
1
Different statements
8736.47 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 8736.47 ms |
SELECT SUBSTR(op.`SKU`,1,5) AS SKU, op.name, GROUP_CONCAT(DISTINCT(op.Order)) as "Orders" FROM `ordini_prodotti` op LEFT JOIN `codici_doganali` cd ON (SUBSTR(op.`SKU`,1,5) = cd.`Codice`) WHERE Shop = 1 AND (cd.Codice IS NULL OR cd.Codice = "") GROUP BY SUBSTR(op.`SKU`,1,5)
Parameters:
[] |
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.