Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.nombre AS nombre_1,
  m0_.slug AS slug_2,
  m0_.descripcion AS descripcion_3,
  m0_.precio AS precio_4,
  m0_.precio_desde AS precio_desde_5,
  m0_.precio_hasta AS precio_hasta_6,
  m0_.year AS year_7,
  m0_.img_thumbnail AS img_thumbnail_8,
  m0_.img_fotos AS img_fotos_9,
  m0_.url_modelo AS url_modelo_10,
  m0_.url_catalogo AS url_catalogo_11,
  m0_.fuente_precio AS fuente_precio_12,
  m0_.scrape_date AS scrape_date_13,
  m0_.orden AS orden_14,
  m0_.visible AS visible_15,
  m0_.destacado_home AS destacado_home_16,
  m0_.es_nuevo AS es_nuevo_17,
  m0_.vistas AS vistas_18,
  m0_.calificacion AS calificacion_19,
  m0_.created_at AS created_at_20,
  m0_.img AS img_21,
  m1_.id AS id_22,
  m1_.orden AS orden_23,
  m1_.principal AS principal_24,
  m1_.created_at AS created_at_25,
  i2_.id AS id_26,
  i2_.filename AS filename_27,
  i2_.filename_mobile AS filename_mobile_28,
  i2_.path AS path_29,
  i2_.link AS link_30,
  i2_.size AS size_31,
  i2_.mime_type AS mime_type_32,
  i2_.size_mobile AS size_mobile_33,
  i2_.mime_type_mobile AS mime_type_mobile_34,
  i2_.alt AS alt_35,
  i2_.titulo AS titulo_36,
  i2_.descripcion AS descripcion_37,
  i2_.llave AS llave_38,
  i2_.seccion AS seccion_39,
  i2_.orden AS orden_40,
  i2_.visible AS visible_41,
  i2_.created_at AS created_at_42,
  i2_.updated_at AS updated_at_43,
  m0_.marca_id AS marca_id_44,
  m0_.tipo_vehiculo_id AS tipo_vehiculo_id_45,
  m1_.modelo_id AS modelo_id_46,
  m1_.imagen_id AS imagen_id_47,
  i2_.galeria_id AS galeria_id_48
FROM
  modelos m0_
  LEFT JOIN modelo_imagenes m1_ ON m0_.id = m1_.modelo_id
  LEFT JOIN imagenes i2_ ON m1_.imagen_id = i2_.id
WHERE
  m0_.id = ?
ORDER BY
  m1_.principal DESC,
  m1_.orden ASC

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.slug AS slug_2, m0_.descripcion AS descripcion_3, m0_.precio AS precio_4, m0_.precio_desde AS precio_desde_5, m0_.precio_hasta AS precio_hasta_6, m0_.year AS year_7, m0_.img_thumbnail AS img_thumbnail_8, m0_.img_fotos AS img_fotos_9, m0_.url_modelo AS url_modelo_10, m0_.url_catalogo AS url_catalogo_11, m0_.fuente_precio AS fuente_precio_12, m0_.scrape_date AS scrape_date_13, m0_.orden AS orden_14, m0_.visible AS visible_15, m0_.destacado_home AS destacado_home_16, m0_.es_nuevo AS es_nuevo_17, m0_.vistas AS vistas_18, m0_.calificacion AS calificacion_19, m0_.created_at AS created_at_20, m0_.img AS img_21, m1_.id AS id_22, m1_.orden AS orden_23, m1_.principal AS principal_24, m1_.created_at AS created_at_25, i2_.id AS id_26, i2_.filename AS filename_27, i2_.filename_mobile AS filename_mobile_28, i2_.path AS path_29, i2_.link AS link_30, i2_.size AS size_31, i2_.mime_type AS mime_type_32, i2_.size_mobile AS size_mobile_33, i2_.mime_type_mobile AS mime_type_mobile_34, i2_.alt AS alt_35, i2_.titulo AS titulo_36, i2_.descripcion AS descripcion_37, i2_.llave AS llave_38, i2_.seccion AS seccion_39, i2_.orden AS orden_40, i2_.visible AS visible_41, i2_.created_at AS created_at_42, i2_.updated_at AS updated_at_43, m0_.marca_id AS marca_id_44, m0_.tipo_vehiculo_id AS tipo_vehiculo_id_45, m1_.modelo_id AS modelo_id_46, m1_.imagen_id AS imagen_id_47, i2_.galeria_id AS galeria_id_48 FROM modelos m0_ LEFT JOIN modelo_imagenes m1_ ON m0_.id = m1_.modelo_id LEFT JOIN imagenes i2_ ON m1_.imagen_id = i2_.id WHERE m0_.id = 691 ORDER BY m1_.principal DESC, m1_.orden ASC;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  modelos
SET
  vistas = ?
WHERE
  id = ?

UPDATE modelos SET vistas = 3 WHERE id = 691;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.nombre_version AS nombre_version_2,
  t0.precio AS precio_3,
  t0.orden AS orden_4,
  t0.visible AS visible_5,
  t0.destacado_home AS destacado_home_6,
  t0.created_at AS created_at_7,
  t0.img AS img_8,
  t0.especificaciones AS especificaciones_9,
  t0.motor AS motor_10,
  t0.tipo_motor AS tipo_motor_11,
  t0.transmision AS transmision_12,
  t0.combustible AS combustible_13,
  t0.cilindrada_cc AS cilindrada_cc_14,
  t0.potencia_hp AS potencia_hp_15,
  t0.potencia_kw AS potencia_kw_16,
  t0.torque_nm AS torque_nm_17,
  t0.consumo AS consumo_18,
  t0.traccion AS traccion_19,
  t0.autonomia_km AS autonomia_km_20,
  t0.url_pdf AS url_pdf_21,
  t0.tipo_vehiculo_id AS tipo_vehiculo_id_22,
  t0.modelo_id AS modelo_id_23
FROM
  versiones t0
WHERE
  t0.modelo_id = ?

SELECT t0.id AS id_1, t0.nombre_version AS nombre_version_2, t0.precio AS precio_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.destacado_home AS destacado_home_6, t0.created_at AS created_at_7, t0.img AS img_8, t0.especificaciones AS especificaciones_9, t0.motor AS motor_10, t0.tipo_motor AS tipo_motor_11, t0.transmision AS transmision_12, t0.combustible AS combustible_13, t0.cilindrada_cc AS cilindrada_cc_14, t0.potencia_hp AS potencia_hp_15, t0.potencia_kw AS potencia_kw_16, t0.torque_nm AS torque_nm_17, t0.consumo AS consumo_18, t0.traccion AS traccion_19, t0.autonomia_km AS autonomia_km_20, t0.url_pdf AS url_pdf_21, t0.tipo_vehiculo_id AS tipo_vehiculo_id_22, t0.modelo_id AS modelo_id_23 FROM versiones t0 WHERE t0.modelo_id = 691;

SELECT
  m0_.id AS id_0
FROM
  modelos m0_
WHERE
  m0_.marca_id = ?
  AND m0_.tipo_vehiculo_id = ?
  AND m0_.id <> ?
  AND m0_.visible = 1
  AND m0_.es_nuevo = 1
  AND (
    m0_.precio_desde BETWEEN ?
    AND ?
  )
ORDER BY
  m0_.created_at DESC
LIMIT
  3

SELECT m0_.id AS id_0 FROM modelos m0_ WHERE m0_.marca_id = 259 AND m0_.tipo_vehiculo_id = 2 AND m0_.id <> 691 AND m0_.visible = 1 AND m0_.es_nuevo = 1 AND (m0_.precio_desde BETWEEN 111341500 AND 150638500) ORDER BY m0_.created_at DESC LIMIT 3;

SELECT
  m0_.id AS id_0
FROM
  modelos m0_
WHERE
  m0_.tipo_vehiculo_id = ?
  AND m0_.id <> ?
  AND m0_.visible = 1
  AND m0_.es_nuevo = 1
  AND m0_.id NOT IN (?, ?)
  AND (
    m0_.precio_desde BETWEEN ?
    AND ?
  )
ORDER BY
  m0_.created_at DESC
LIMIT
  1

SELECT m0_.id AS id_0 FROM modelos m0_ WHERE m0_.tipo_vehiculo_id = 2 AND m0_.id <> 691 AND m0_.visible = 1 AND m0_.es_nuevo = 1 AND m0_.id NOT IN (696, 695) AND (m0_.precio_desde BETWEEN 111341500 AND 150638500) ORDER BY m0_.created_at DESC LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.nombre AS nombre_1,
  m0_.slug AS slug_2,
  m0_.descripcion AS descripcion_3,
  m0_.precio AS precio_4,
  m0_.precio_desde AS precio_desde_5,
  m0_.precio_hasta AS precio_hasta_6,
  m0_.year AS year_7,
  m0_.img_thumbnail AS img_thumbnail_8,
  m0_.img_fotos AS img_fotos_9,
  m0_.url_modelo AS url_modelo_10,
  m0_.url_catalogo AS url_catalogo_11,
  m0_.fuente_precio AS fuente_precio_12,
  m0_.scrape_date AS scrape_date_13,
  m0_.orden AS orden_14,
  m0_.visible AS visible_15,
  m0_.destacado_home AS destacado_home_16,
  m0_.es_nuevo AS es_nuevo_17,
  m0_.vistas AS vistas_18,
  m0_.calificacion AS calificacion_19,
  m0_.created_at AS created_at_20,
  m0_.img AS img_21,
  m1_.id AS id_22,
  m1_.orden AS orden_23,
  m1_.principal AS principal_24,
  m1_.created_at AS created_at_25,
  i2_.id AS id_26,
  i2_.filename AS filename_27,
  i2_.filename_mobile AS filename_mobile_28,
  i2_.path AS path_29,
  i2_.link AS link_30,
  i2_.size AS size_31,
  i2_.mime_type AS mime_type_32,
  i2_.size_mobile AS size_mobile_33,
  i2_.mime_type_mobile AS mime_type_mobile_34,
  i2_.alt AS alt_35,
  i2_.titulo AS titulo_36,
  i2_.descripcion AS descripcion_37,
  i2_.llave AS llave_38,
  i2_.seccion AS seccion_39,
  i2_.orden AS orden_40,
  i2_.visible AS visible_41,
  i2_.created_at AS created_at_42,
  i2_.updated_at AS updated_at_43,
  m0_.marca_id AS marca_id_44,
  m0_.tipo_vehiculo_id AS tipo_vehiculo_id_45,
  m1_.modelo_id AS modelo_id_46,
  m1_.imagen_id AS imagen_id_47,
  i2_.galeria_id AS galeria_id_48
FROM
  modelos m0_
  LEFT JOIN modelo_imagenes m1_ ON m0_.id = m1_.modelo_id
  LEFT JOIN imagenes i2_ ON m1_.imagen_id = i2_.id
WHERE
  m0_.id IN (?, ?, ?)
ORDER BY
  CASE WHEN m0_.marca_id = ? THEN
    0
  ELSE
    1
  END ASC,
  m1_.principal DESC,
  m1_.orden ASC

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.slug AS slug_2, m0_.descripcion AS descripcion_3, m0_.precio AS precio_4, m0_.precio_desde AS precio_desde_5, m0_.precio_hasta AS precio_hasta_6, m0_.year AS year_7, m0_.img_thumbnail AS img_thumbnail_8, m0_.img_fotos AS img_fotos_9, m0_.url_modelo AS url_modelo_10, m0_.url_catalogo AS url_catalogo_11, m0_.fuente_precio AS fuente_precio_12, m0_.scrape_date AS scrape_date_13, m0_.orden AS orden_14, m0_.visible AS visible_15, m0_.destacado_home AS destacado_home_16, m0_.es_nuevo AS es_nuevo_17, m0_.vistas AS vistas_18, m0_.calificacion AS calificacion_19, m0_.created_at AS created_at_20, m0_.img AS img_21, m1_.id AS id_22, m1_.orden AS orden_23, m1_.principal AS principal_24, m1_.created_at AS created_at_25, i2_.id AS id_26, i2_.filename AS filename_27, i2_.filename_mobile AS filename_mobile_28, i2_.path AS path_29, i2_.link AS link_30, i2_.size AS size_31, i2_.mime_type AS mime_type_32, i2_.size_mobile AS size_mobile_33, i2_.mime_type_mobile AS mime_type_mobile_34, i2_.alt AS alt_35, i2_.titulo AS titulo_36, i2_.descripcion AS descripcion_37, i2_.llave AS llave_38, i2_.seccion AS seccion_39, i2_.orden AS orden_40, i2_.visible AS visible_41, i2_.created_at AS created_at_42, i2_.updated_at AS updated_at_43, m0_.marca_id AS marca_id_44, m0_.tipo_vehiculo_id AS tipo_vehiculo_id_45, m1_.modelo_id AS modelo_id_46, m1_.imagen_id AS imagen_id_47, i2_.galeria_id AS galeria_id_48 FROM modelos m0_ LEFT JOIN modelo_imagenes m1_ ON m0_.id = m1_.modelo_id LEFT JOIN imagenes i2_ ON m1_.imagen_id = i2_.id WHERE m0_.id IN (696, 695, 728) ORDER BY CASE WHEN m0_.marca_id = 259 THEN 0 ELSE 1 END ASC, m1_.principal DESC, m1_.orden ASC;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.orden AS orden_3,
  t0.visible AS visible_4,
  t0.created_at AS created_at_5,
  t0.imagen_id AS imagen_id_6
FROM
  marca t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.orden AS orden_3, t0.visible AS visible_4, t0.created_at AS created_at_5, t0.imagen_id AS imagen_id_6 FROM marca t0 WHERE t0.id = 259;

SELECT
  i0_.id AS id_0,
  i0_.filename AS filename_1,
  i0_.filename_mobile AS filename_mobile_2,
  i0_.path AS path_3,
  i0_.link AS link_4,
  i0_.size AS size_5,
  i0_.mime_type AS mime_type_6,
  i0_.size_mobile AS size_mobile_7,
  i0_.mime_type_mobile AS mime_type_mobile_8,
  i0_.alt AS alt_9,
  i0_.titulo AS titulo_10,
  i0_.descripcion AS descripcion_11,
  i0_.llave AS llave_12,
  i0_.seccion AS seccion_13,
  i0_.orden AS orden_14,
  i0_.visible AS visible_15,
  i0_.created_at AS created_at_16,
  i0_.updated_at AS updated_at_17,
  i0_.galeria_id AS galeria_id_18
FROM
  imagenes i0_
WHERE
  i0_.llave = ?
  AND i0_.visible = ?

SELECT i0_.id AS id_0, i0_.filename AS filename_1, i0_.filename_mobile AS filename_mobile_2, i0_.path AS path_3, i0_.link AS link_4, i0_.size AS size_5, i0_.mime_type AS mime_type_6, i0_.size_mobile AS size_mobile_7, i0_.mime_type_mobile AS mime_type_mobile_8, i0_.alt AS alt_9, i0_.titulo AS titulo_10, i0_.descripcion AS descripcion_11, i0_.llave AS llave_12, i0_.seccion AS seccion_13, i0_.orden AS orden_14, i0_.visible AS visible_15, i0_.created_at AS created_at_16, i0_.updated_at AS updated_at_17, i0_.galeria_id AS galeria_id_18 FROM imagenes i0_ WHERE i0_.llave = 'img-favicon' AND i0_.visible = 1;

SELECT
  t0_.id AS id_0,
  t0_.llave AS llave_1,
  t0_.valor AS valor_2,
  t0_.descripcion AS descripcion_3,
  t0_.categoria AS categoria_4,
  t0_.orden AS orden_5,
  t0_.activo AS activo_6,
  t0_.created_at AS created_at_7,
  t0_.updated_at AS updated_at_8
FROM
  textos t0_
WHERE
  t0_.llave = ?
  AND t0_.activo = ?

SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor AS valor_2, t0_.descripcion AS descripcion_3, t0_.categoria AS categoria_4, t0_.orden AS orden_5, t0_.activo AS activo_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM textos t0_ WHERE t0_.llave = 'header.nav.new_vehicles' AND t0_.activo = 1;

SELECT
  t0_.id AS id_0,
  t0_.nombre AS nombre_1,
  t0_.descripcion AS descripcion_2,
  t0_.orden AS orden_3,
  t0_.visible AS visible_4,
  t0_.created_at AS created_at_5
FROM
  tipos_vehiculo t0_
WHERE
  t0_.visible = ?
ORDER BY
  t0_.orden ASC,
  t0_.nombre ASC

SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2, t0_.orden AS orden_3, t0_.visible AS visible_4, t0_.created_at AS created_at_5 FROM tipos_vehiculo t0_ WHERE t0_.visible = 1 ORDER BY t0_.orden ASC, t0_.nombre ASC;

SELECT
  t0_.id AS id_0,
  t0_.llave AS llave_1,
  t0_.valor AS valor_2,
  t0_.descripcion AS descripcion_3,
  t0_.categoria AS categoria_4,
  t0_.orden AS orden_5,
  t0_.activo AS activo_6,
  t0_.created_at AS created_at_7,
  t0_.updated_at AS updated_at_8
FROM
  textos t0_
WHERE
  t0_.llave = ?
  AND t0_.activo = ?

SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor AS valor_2, t0_.descripcion AS descripcion_3, t0_.categoria AS categoria_4, t0_.orden AS orden_5, t0_.activo AS activo_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM textos t0_ WHERE t0_.llave = 'header.nav.used_vehicles' AND t0_.activo = 1;

SELECT
  t0_.id AS id_0,
  t0_.nombre AS nombre_1,
  t0_.descripcion AS descripcion_2,
  t0_.orden AS orden_3,
  t0_.visible AS visible_4,
  t0_.created_at AS created_at_5
FROM
  tipos_vehiculo t0_
WHERE
  t0_.visible = ?
ORDER BY
  t0_.orden ASC,
  t0_.nombre ASC

SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2, t0_.orden AS orden_3, t0_.visible AS visible_4, t0_.created_at AS created_at_5 FROM tipos_vehiculo t0_ WHERE t0_.visible = 1 ORDER BY t0_.orden ASC, t0_.nombre ASC;

SELECT
  t0_.id AS id_0,
  t0_.llave AS llave_1,
  t0_.valor AS valor_2,
  t0_.descripcion AS descripcion_3,
  t0_.categoria AS categoria_4,
  t0_.orden AS orden_5,
  t0_.activo AS activo_6,
  t0_.created_at AS created_at_7,
  t0_.updated_at AS updated_at_8
FROM
  textos t0_
WHERE
  t0_.llave = ?
  AND t0_.activo = ?

SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor AS valor_2, t0_.descripcion AS descripcion_3, t0_.categoria AS categoria_4, t0_.orden AS orden_5, t0_.activo AS activo_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM textos t0_ WHERE t0_.llave = 'header.nav.about_us' AND t0_.activo = 1;

SELECT
  t0_.id AS id_0,
  t0_.llave AS llave_1,
  t0_.valor AS valor_2,
  t0_.descripcion AS descripcion_3,
  t0_.categoria AS categoria_4,
  t0_.orden AS orden_5,
  t0_.activo AS activo_6,
  t0_.created_at AS created_at_7,
  t0_.updated_at AS updated_at_8
FROM
  textos t0_
WHERE
  t0_.llave = ?
  AND t0_.activo = ?

SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor AS valor_2, t0_.descripcion AS descripcion_3, t0_.categoria AS categoria_4, t0_.orden AS orden_5, t0_.activo AS activo_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM textos t0_ WHERE t0_.llave = 'header.nav.compare' AND t0_.activo = 1;

SELECT
  t0_.id AS id_0,
  t0_.llave AS llave_1,
  t0_.valor AS valor_2,
  t0_.descripcion AS descripcion_3,
  t0_.categoria AS categoria_4,
  t0_.orden AS orden_5,
  t0_.activo AS activo_6,
  t0_.created_at AS created_at_7,
  t0_.updated_at AS updated_at_8
FROM
  textos t0_
WHERE
  t0_.llave = ?
  AND t0_.activo = ?

SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor AS valor_2, t0_.descripcion AS descripcion_3, t0_.categoria AS categoria_4, t0_.orden AS orden_5, t0_.activo AS activo_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM textos t0_ WHERE t0_.llave = 'header.nav.contact' AND t0_.activo = 1;

SELECT
  t0_.id AS id_0,
  t0_.llave AS llave_1,
  t0_.valor AS valor_2,
  t0_.descripcion AS descripcion_3,
  t0_.categoria AS categoria_4,
  t0_.orden AS orden_5,
  t0_.activo AS activo_6,
  t0_.created_at AS created_at_7,
  t0_.updated_at AS updated_at_8
FROM
  textos t0_
WHERE
  t0_.llave = ?
  AND t0_.activo = ?

SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor AS valor_2, t0_.descripcion AS descripcion_3, t0_.categoria AS categoria_4, t0_.orden AS orden_5, t0_.activo AS activo_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM textos t0_ WHERE t0_.llave = 'header.cta.quote_now' AND t0_.activo = 1;