Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

1 Different statements

1.63 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.63 ms (100.00%)	2	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▼

Count

Info

1.63 ms
(100.00%)

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