Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.63 ms Query time

0 Invalid entities

Time▼	Count	Info
1.31 ms (80.64%)	1	SELECT master_state_id, state_name FROM master_state WHERE STATUS='1' ORDER BY state_name Parameters: [] View formatted query View runnable query Explain query SELECT master_state_id, state_name FROM master_state WHERE STATUS = '1' ORDER BY state_name SELECT master_state_id, state_name FROM master_state WHERE STATUS='1' ORDER BY state_name;
0.31 ms (19.36%)	1	SELECT master_country_id, country_name FROM master_country WHERE statu_s='active' ORDER BY country_name Parameters: [] View formatted query View runnable query Explain query SELECT master_country_id, country_name FROM master_country WHERE statu_s = 'active' ORDER BY country_name SELECT master_country_id, country_name FROM master_country WHERE statu_s='active' ORDER BY country_name;

Time▼

Count

Info

1.31 ms
(80.64%)

SELECT master_state_id, state_name
        FROM master_state WHERE STATUS='1'
        ORDER BY state_name

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  master_state_id,
  state_name
FROM
  master_state
WHERE
  STATUS = '1'
ORDER BY
  state_name

SELECT master_state_id, state_name
        FROM master_state WHERE STATUS='1'
        ORDER BY state_name;

0.31 ms
(19.36%)

SELECT master_country_id, country_name
        FROM master_country WHERE statu_s='active'
        ORDER BY country_name

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  master_country_id,
  country_name
FROM
  master_country
WHERE
  statu_s = 'active'
ORDER BY
  country_name

SELECT master_country_id, country_name
        FROM master_country WHERE statu_s='active'
        ORDER BY country_name;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

No loaded entities.