Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

25.66 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
25.66 ms (100.00%)	1	SELECT c0_.code_postal AS code_postal_0, c0_.nom_commune AS nom_commune_1 FROM code_postal c0_ WHERE (c0_.nom_commune LIKE ?) AND (c0_.code_postal LIKE ?) ORDER BY c0_.code_postal ASC LIMIT 10 Parameters: [`"%" "30%"`] View formatted query View runnable query Explain query SELECT c0_.code_postal AS code_postal_0, c0_.nom_commune AS nom_commune_1 FROM code_postal c0_ WHERE (c0_.nom_commune LIKE ?) AND (c0_.code_postal LIKE ?) ORDER BY c0_.code_postal ASC LIMIT 10 SELECT c0_.code_postal AS code_postal_0, c0_.nom_commune AS nom_commune_1 FROM code_postal c0_ WHERE (c0_.nom_commune LIKE '%') AND (c0_.code_postal LIKE '30%') ORDER BY c0_.code_postal ASC LIMIT 10;

Time▼

Count

Info

25.66 ms
(100.00%)

SELECT c0_.code_postal AS code_postal_0, c0_.nom_commune AS nom_commune_1 FROM code_postal c0_ WHERE (c0_.nom_commune LIKE ?) AND (c0_.code_postal LIKE ?) ORDER BY c0_.code_postal ASC LIMIT 10

Parameters:

[
  "%"
  "30%"
]

View formatted query View runnable query Explain query

SELECT 
  c0_.code_postal AS code_postal_0, 
  c0_.nom_commune AS nom_commune_1 
FROM 
  code_postal c0_ 
WHERE 
  (c0_.nom_commune LIKE ?) 
  AND (c0_.code_postal LIKE ?) 
ORDER BY 
  c0_.code_postal ASC 
LIMIT 
  10

SELECT c0_.code_postal AS code_postal_0, c0_.nom_commune AS nom_commune_1 FROM code_postal c0_ WHERE (c0_.nom_commune LIKE '%') AND (c0_.code_postal LIKE '30%') ORDER BY c0_.code_postal ASC LIMIT 10;

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

Class	Mapping errors
App\Entity\Code_postal	No errors.

Symfony Profiler

https://www.oneclickdj.com/ajax/30

Configuration Settings

Theme