Symfony Profiler

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

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 = 'punta-borinquen-resort-aguadilla-puerto-rico' AND t0.is_activo = 1 LIMIT 1;

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 = ?

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 = 43;

SELECT
  t0.id AS id_1,
  t0.content AS content_2
FROM
  discount_name t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.content AS content_2 FROM discount_name t0 WHERE t0.id = 1;

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 = ?

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 = 40;

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

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 = 4 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2
FROM
  color t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = 3 LIMIT 1;

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

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 = 5 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2
FROM
  color t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = 3 LIMIT 1;

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

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 = 13 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2
FROM
  color t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = 4 LIMIT 1;

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

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 = 14 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2
FROM
  color t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = 2 LIMIT 1;

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

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 = 21 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2
FROM
  color t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = 4 LIMIT 1;

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

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 = 23 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2
FROM
  color t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content AS content_2 FROM color t0 WHERE t0.id = 5 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2
FROM
  discount_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.content AS content_2 FROM discount_type t0 WHERE t0.id = 1;