Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.valor AS valor_2,
  t0.estado AS estado_3,
  t0.locacion AS locacion_4,
  t0.direccion AS direccion_5,
  t0.calificacion AS calificacion_6,
  t0.imagen_principal AS imagen_principal_7,
  t0.longitud AS longitud_8,
  t0.latitud AS latitud_9,
  t0.nombre AS nombre_10,
  t0.descripcion AS descripcion_11,
  t0.visitas AS visitas_12,
  t0.palabras_clave AS palabras_clave_13,
  t0.horario_atencion AS horario_atencion_14,
  t0.id_categoria_id AS id_categoria_id_15,
  t0.id_ciudad_id AS id_ciudad_id_16
FROM
  sitios t0
WHERE
  t0.id_categoria_id = ?
  AND t0.estado = ?

SELECT t0.id AS id_1, t0.valor AS valor_2, t0.estado AS estado_3, t0.locacion AS locacion_4, t0.direccion AS direccion_5, t0.calificacion AS calificacion_6, t0.imagen_principal AS imagen_principal_7, t0.longitud AS longitud_8, t0.latitud AS latitud_9, t0.nombre AS nombre_10, t0.descripcion AS descripcion_11, t0.visitas AS visitas_12, t0.palabras_clave AS palabras_clave_13, t0.horario_atencion AS horario_atencion_14, t0.id_categoria_id AS id_categoria_id_15, t0.id_ciudad_id AS id_ciudad_id_16 FROM sitios t0 WHERE t0.id_categoria_id = '23' AND t0.estado = 'Activo';

SELECT
  s0_.id AS id_0,
  s0_.valor AS valor_1,
  s0_.estado AS estado_2,
  s0_.locacion AS locacion_3,
  s0_.direccion AS direccion_4,
  s0_.calificacion AS calificacion_5,
  s0_.imagen_principal AS imagen_principal_6,
  s0_.longitud AS longitud_7,
  s0_.latitud AS latitud_8,
  s0_.nombre AS nombre_9,
  s0_.descripcion AS descripcion_10,
  s0_.visitas AS visitas_11,
  s0_.palabras_clave AS palabras_clave_12,
  s0_.horario_atencion AS horario_atencion_13,
  s0_.id_categoria_id AS id_categoria_id_14,
  s0_.id_ciudad_id AS id_ciudad_id_15
FROM
  sitios s0_
WHERE
  (s0_.id_categoria_id = ?)
ORDER BY
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.valor AS valor_1, s0_.estado AS estado_2, s0_.locacion AS locacion_3, s0_.direccion AS direccion_4, s0_.calificacion AS calificacion_5, s0_.imagen_principal AS imagen_principal_6, s0_.longitud AS longitud_7, s0_.latitud AS latitud_8, s0_.nombre AS nombre_9, s0_.descripcion AS descripcion_10, s0_.visitas AS visitas_11, s0_.palabras_clave AS palabras_clave_12, s0_.horario_atencion AS horario_atencion_13, s0_.id_categoria_id AS id_categoria_id_14, s0_.id_ciudad_id AS id_ciudad_id_15 FROM sitios s0_ WHERE (s0_.id_categoria_id = '23') ORDER BY s0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.id_departamento_id AS id_departamento_id_3
FROM
  ciudades t0
WHERE
  t0.id_departamento_id = ?
ORDER BY
  t0.nombre ASC

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.id_departamento_id AS id_departamento_id_3 FROM ciudades t0 WHERE t0.id_departamento_id = 26 ORDER BY t0.nombre ASC;