Query Metrics
15
Database Queries
4
Different statements
6.96 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.75 ms |
SELECT b0_.id AS id_0, b0_.section AS section_1, b0_.sub_section AS sub_section_2, b0_.content AS content_3 FROM banner b0_ WHERE b0_.section = ? AND b0_.sub_section = ?
Parameters:
[ "vista-manzanillo" "entertainment" ] |
| 2 | 0.44 ms |
SELECT c0_.id AS id_0, c0_.section AS section_1, c0_.sub_section AS sub_section_2, c0_.content AS content_3, c0_.type AS type_4 FROM content c0_ WHERE c0_.section = ? AND c0_.sub_section = ? AND c0_.type = ?
Parameters:
[ "vista-manzanillo" "entertainment" "hotel-text" ] |
| 3 | 0.46 ms |
SELECT m0_.id AS id_0, m0_.section AS section_1, m0_.type AS type_2, m0_.content AS content_3, m0_.priority AS priority_4, m0_.is_visible AS is_visible_5 FROM module m0_ WHERE m0_.section = ? AND m0_.type = ? AND m0_.is_visible = 1
Parameters:
[ "vista-manzanillo" "activities" ] |
| 4 | 0.39 ms |
SELECT c0_.id AS id_0, c0_.section AS section_1, c0_.sub_section AS sub_section_2, c0_.content AS content_3, c0_.type AS type_4 FROM content c0_ WHERE c0_.section = ? AND c0_.sub_section = ? AND c0_.type = ?
Parameters:
[ "vista-manzanillo" "shows" "hotel-section" ] |
| 5 | 0.38 ms |
SELECT c0_.id AS id_0, c0_.section AS section_1, c0_.sub_section AS sub_section_2, c0_.content AS content_3, c0_.type AS type_4 FROM content c0_ WHERE c0_.section = ? AND c0_.sub_section = ? AND c0_.type = ?
Parameters:
[ "vista-manzanillo" "video" "hotel-section" ] |
| 6 | 0.81 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"
]
|
| 7 | 0.54 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"
]
|
| 8 | 0.39 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"
]
|
| 9 | 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:
[
"crown-golden-vallarta"
]
|
| 10 | 0.48 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"
]
|
| 11 | 0.39 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"
]
|
| 12 | 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:
[
"westin-cozumel"
]
|
| 13 | 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:
[
"ibis-tijuana"
]
|
| 14 | 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-guadalajara-expo"
]
|
| 15 | 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:
[
"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\Banner | No errors. |
| App\Entity\Content | No errors. |
| App\Entity\Module | No errors. |
| App\Entity\Promotion | No errors. |