https://dreamvacationpr.com/proveedor/el-platanal-restaurant-bayamon

Query Metrics

13 Database Queries
7 Different statements
2.92 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.59 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.is_activo AS is_activo_3, t0.slug AS slug_4, t0.description AS description_5, t0.location AS location_6, t0.subcontent AS subcontent_7, t0.provider_type_id AS provider_type_id_8 FROM provider t0 WHERE t0.slug = ? AND t0.is_activo = ? LIMIT 1
Parameters:
[
  "el-platanal-restaurant-bayamon"
  1
]
2 0.38 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.post_content AS post_content_3, t0.is_activo AS is_activo_4, t0.discount_name_id AS discount_name_id_5, t0.discount_type_id AS discount_type_id_6, t0.provider_id AS provider_id_7 FROM discount t0 WHERE t0.provider_id = ?
Parameters:
[
  93
]
3 0.24 ms
SELECT t0.id AS id_1, t0.content AS content_2 FROM discount_name t0 WHERE t0.id = ?
Parameters:
[
  9
]
4 0.29 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 INNER JOIN discount_restriction ON t0.id = discount_restriction.restriction_id WHERE discount_restriction.discount_id = ?
Parameters:
[
  112
]
5 0.20 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  12
]
6 0.18 ms
SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  5
]
7 0.18 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  17
]
8 0.14 ms
SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  4
]
9 0.14 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  24
]
10 0.13 ms
SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  3
]
11 0.14 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.is_feature AS is_feature_3, t0.color_id AS color_id_4 FROM restriction t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  25
]
12 0.13 ms
SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  5
]
13 0.19 ms
SELECT t0.id AS id_1, t0.content AS content_2 FROM discount_type t0 WHERE t0.id = ?
Parameters:
[
  4
]

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\Provider No errors.
App\Entity\ProviderType No errors.
App\Entity\Programa No errors.
App\Entity\Discount No errors.
App\Entity\Solicitud No errors.
App\Entity\SolicitudPublica
  • The association App\Entity\SolicitudPublica#socio refers to the inverse side field App\Entity\User#solicitudPublicas which does not exist.
App\Entity\DiscountName No errors.
App\Entity\DiscountType No errors.
App\Entity\Restriction No errors.
App\Entity\Color No errors.