Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

1 Different statements

1.63 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.85 ms	SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.url AS url_3, b0_.expiration_date AS expiration_date_4, b0_.is_active AS is_active_5 FROM banner b0_ WHERE b0_.is_active = 1 OR b0_.is_active IS NULL ORDER BY b0_.id DESC Parameters: [] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.url AS url_3, b0_.expiration_date AS expiration_date_4, b0_.is_active AS is_active_5 FROM banner b0_ WHERE b0_.is_active = 1 OR b0_.is_active IS NULL ORDER BY b0_.id DESC SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.url AS url_3, b0_.expiration_date AS expiration_date_4, b0_.is_active AS is_active_5 FROM banner b0_ WHERE b0_.is_active = 1 OR b0_.is_active IS NULL ORDER BY b0_.id DESC;
2	0.78 ms	SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.url AS url_3, b0_.expiration_date AS expiration_date_4, b0_.is_active AS is_active_5 FROM banner b0_ WHERE b0_.is_active = 1 OR b0_.is_active IS NULL ORDER BY b0_.id DESC Parameters: [] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.url AS url_3, b0_.expiration_date AS expiration_date_4, b0_.is_active AS is_active_5 FROM banner b0_ WHERE b0_.is_active = 1 OR b0_.is_active IS NULL ORDER BY b0_.id DESC SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.url AS url_3, b0_.expiration_date AS expiration_date_4, b0_.is_active AS is_active_5 FROM banner b0_ WHERE b0_.is_active = 1 OR b0_.is_active IS NULL ORDER BY b0_.id DESC;

#▲

Time

Info

0.85 ms

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.url AS url_3, b0_.expiration_date AS expiration_date_4, b0_.is_active AS is_active_5 FROM banner b0_ WHERE b0_.is_active = 1 OR b0_.is_active IS NULL ORDER BY b0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.image AS image_2,
  b0_.url AS url_3,
  b0_.expiration_date AS expiration_date_4,
  b0_.is_active AS is_active_5
FROM
  banner b0_
WHERE
  b0_.is_active = 1
  OR b0_.is_active IS NULL
ORDER BY
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.url AS url_3, b0_.expiration_date AS expiration_date_4, b0_.is_active AS is_active_5 FROM banner b0_ WHERE b0_.is_active = 1 OR b0_.is_active IS NULL ORDER BY b0_.id DESC;

0.78 ms

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.url AS url_3, b0_.expiration_date AS expiration_date_4, b0_.is_active AS is_active_5 FROM banner b0_ WHERE b0_.is_active = 1 OR b0_.is_active IS NULL ORDER BY b0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.image AS image_2,
  b0_.url AS url_3,
  b0_.expiration_date AS expiration_date_4,
  b0_.is_active AS is_active_5
FROM
  banner b0_
WHERE
  b0_.is_active = 1
  OR b0_.is_active IS NULL
ORDER BY
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.image AS image_2, b0_.url AS url_3, b0_.expiration_date AS expiration_date_4, b0_.is_active AS is_active_5 FROM banner b0_ WHERE b0_.is_active = 1 OR b0_.is_active IS NULL ORDER BY b0_.id DESC;

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\Banner	No errors.

Symfony Profiler

https://hmsdcportal2.ctssys.com/login

Configuration Settings

Theme