GET https://www.demo2.zipvisual.com/es/playa-de-oro-manzanillo/entretenimiento/

Query Metrics

15 Database Queries
4 Different statements
6.96 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.