https://manebi-manager.tembo.xyz/admin/products/?filter=1&filter-type=without-hscode

Query Metrics

1 Database Queries
1 Different statements
8736.47 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8736.47 ms
(100.00%)
1
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.