Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.67 ms Query time

0 Invalid entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼	Count	Info
2.05 ms (76.73%)	1	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' ;
0.62 ms (23.27%)	1	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';

Time▼

Count

Info

2.05 ms
(76.73%)

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'
    ;

0.62 ms
(23.27%)

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';

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