GET https://demo2.zipvisual.com/es/ibis-tijuana/galeria/

Query Metrics

16 Database Queries
5 Different statements
10.53 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 2.59 ms
SELECT g0_.id AS id_0, g0_.section AS section_1, g0_.is_visible AS is_visible_2, g0_.content AS content_3, g0_.name AS name_4 FROM gallery g0_ WHERE g0_.section = ? AND g0_.is_visible = 1
Parameters:
[
  "ibis-tijuana"
]
2 0.42 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:
[
  "ibis-tijuana"
  "galleries"
  "hotel-text"
]
3 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:
[
  "ibis-tijuana"
  "video"
  "hotel-section"
]
4 0.78 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"
]
5 0.52 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"
]
6 0.49 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"
]
7 0.51 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"
]
8 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:
[
  "vista-manzanillo"
]
9 0.43 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"
]
10 0.49 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"
]
11 0.51 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"
]
12 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-express-guadalajara-expo"
]
13 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:
[
  "the-palm"
]
14 0.51 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"
]
15 0.90 ms
SELECT t0.id AS id_1, t0.section AS section_2, t0.is_visible AS is_visible_3, t0.content AS content_4, t0.name AS name_5 FROM gallery t0 WHERE t0.id = ? AND t0.is_visible = ? LIMIT 1
Parameters:
[
  0
  1
]
16 0.50 ms
SELECT t0.id AS id_1, t0.section AS section_2, t0.is_visible AS is_visible_3, t0.content AS content_4, t0.name AS name_5 FROM gallery t0 WHERE t0.is_visible = ? AND t0.section = ? LIMIT 1
Parameters:
[
  1
  "ibis-tijuana"
]

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\Gallery No errors.
App\Entity\Content No errors.
App\Entity\Promotion No errors.