Query Metrics

10 Database Queries
1 Different statements
4.52 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.85 ms
SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = ? AND p0_.is_visible = 1 ORDER BY p0_.priority ASC
Parameters:
[
  "golden-shores"
]
2 0.47 ms
SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = ? AND p0_.is_visible = 1 ORDER BY p0_.priority ASC
Parameters:
[
  "crown-club-cancun"
]
3 0.42 ms
SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = ? AND p0_.is_visible = 1 ORDER BY p0_.priority ASC
Parameters:
[
  "crown-club-vallarta"
]
4 0.42 ms
SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = ? AND p0_.is_visible = 1 ORDER BY p0_.priority ASC
Parameters:
[
  "crown-golden-vallarta"
]
5 0.36 ms
SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = ? AND p0_.is_visible = 1 ORDER BY p0_.priority ASC
Parameters:
[
  "vista-manzanillo"
]
6 0.37 ms
SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = ? AND p0_.is_visible = 1 ORDER BY p0_.priority ASC
Parameters:
[
  "vista-express-morelia"
]
7 0.45 ms
SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = ? AND p0_.is_visible = 1 ORDER BY p0_.priority ASC
Parameters:
[
  "westin-cozumel"
]
8 0.41 ms
SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = ? AND p0_.is_visible = 1 ORDER BY p0_.priority ASC
Parameters:
[
  "ibis-tijuana"
]
9 0.40 ms
SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = ? AND p0_.is_visible = 1 ORDER BY p0_.priority ASC
Parameters:
[
  "vista-express-guadalajara-expo"
]
10 0.38 ms
SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = ? AND p0_.is_visible = 1 ORDER BY p0_.priority ASC
Parameters:
[
  "sensira-rivera-maya"
]

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