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

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 = '50';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  sitios
SET
  visitas = ?
WHERE
  id = ?

UPDATE sitios SET visitas = 105 WHERE id = 50;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.imagen AS imagen_2,
  t0.estado AS estado_3,
  t0.posicion AS posicion_4,
  t0.id_sitio_id AS id_sitio_id_5
FROM
  sitios_galeria t0
WHERE
  t0.id_sitio_id = ?

SELECT t0.id AS id_1, t0.imagen AS imagen_2, t0.estado AS estado_3, t0.posicion AS posicion_4, t0.id_sitio_id AS id_sitio_id_5 FROM sitios_galeria t0 WHERE t0.id_sitio_id = '50';

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.estado AS estado_3,
  t0.id_sitio_id AS id_sitio_id_4,
  t0.id_icono_id AS id_icono_id_5
FROM
  sitios_comodidades t0
WHERE
  t0.id_sitio_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.estado AS estado_3, t0.id_sitio_id AS id_sitio_id_4, t0.id_icono_id AS id_icono_id_5 FROM sitios_comodidades t0 WHERE t0.id_sitio_id = '50';

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.color AS color_3,
  t0.enlace AS enlace_4,
  t0.estado AS estado_5,
  t0.id_sitio_id AS id_sitio_id_6,
  t0.id_icono_id AS id_icono_id_7
FROM
  sitios_redes_sociales t0
WHERE
  t0.id_sitio_id = ?
  AND t0.estado = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.color AS color_3, t0.enlace AS enlace_4, t0.estado AS estado_5, t0.id_sitio_id AS id_sitio_id_6, t0.id_icono_id AS id_icono_id_7 FROM sitios_redes_sociales t0 WHERE t0.id_sitio_id = '50' AND t0.estado = 'Activo';

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 = 6 AND t0.estado = 'Activo';

SELECT
  t0.id AS id_1,
  t0.icono AS icono_2
FROM
  iconos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.icono AS icono_2
FROM
  iconos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.icono AS icono_2
FROM
  iconos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.icono AS icono_2
FROM
  iconos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.icono AS icono_2 FROM iconos t0 WHERE t0.id = 14;

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

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