Query Metrics
10
Database Queries
1
Different statements
4.52 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |