Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.63 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲	Time	Info
1	1.22 ms	SELECT * FROM uv_ticket_subtype WHERE id = :id Parameters: [`"id" => "36"`] View formatted query View runnable query Explain query SELECT * FROM uv_ticket_subtype WHERE id = : id SELECT * FROM uv_ticket_subtype WHERE id = '36';
2	1.41 ms	SELECT d.id, d.data, d.tipo, ds.required FROM uv_ticket_data d JOIN uv_ticket_data_subtype ds ON ds.id_ticket_data = d.id WHERE ds.id_ticket_subtype = :id_ticket_subtype Parameters: [`"id_ticket_subtype" => "36"`] View formatted query View runnable query Explain query SELECT d.id, d.data, d.tipo, ds.required FROM uv_ticket_data d JOIN uv_ticket_data_subtype ds ON ds.id_ticket_data = d.id WHERE ds.id_ticket_subtype = : id_ticket_subtype SELECT d.id, d.data, d.tipo, ds.required FROM uv_ticket_data d JOIN uv_ticket_data_subtype ds ON ds.id_ticket_data = d.id WHERE ds.id_ticket_subtype = '36' ;

#▲

Time

Info

1.22 ms

SELECT * FROM uv_ticket_subtype WHERE id = :id

Parameters:

[
  "id" => "36"
]

View formatted query View runnable query Explain query

SELECT 
  * 
FROM 
  uv_ticket_subtype 
WHERE 
  id = : id

SELECT * FROM uv_ticket_subtype WHERE id = '36';

1.41 ms

SELECT d.id, d.data, d.tipo, ds.required
        FROM uv_ticket_data d
        JOIN uv_ticket_data_subtype ds ON ds.id_ticket_data = d.id
        WHERE ds.id_ticket_subtype = :id_ticket_subtype

Parameters:

[
  "id_ticket_subtype" => "36"
]

View formatted query View runnable query Explain query

SELECT 
  d.id, 
  d.data, 
  d.tipo, 
  ds.required 
FROM 
  uv_ticket_data d 
  JOIN uv_ticket_data_subtype ds ON ds.id_ticket_data = d.id 
WHERE 
  ds.id_ticket_subtype = : id_ticket_subtype

SELECT d.id, d.data, d.tipo, ds.required
        FROM uv_ticket_data d
        JOIN uv_ticket_data_subtype ds ON ds.id_ticket_data = d.id
        WHERE ds.id_ticket_subtype = '36'
    ;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Entities Mapping

No loaded entities.

Symfony Profiler

https://ticketsdemo.softguard.com/public/en/ticket/data?supportTicketSubtypesId=36

Configuration Settings

Theme