Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.nombre AS nombre_1,
  m0_.orden AS orden_2,
  m0_.visible AS visible_3,
  m0_.created_at AS created_at_4,
  m0_.imagen_id AS imagen_id_5
FROM
  marca m0_
WHERE
  m0_.visible = ?
ORDER BY
  m0_.orden ASC,
  m0_.nombre ASC

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.orden AS orden_2, m0_.visible AS visible_3, m0_.created_at AS created_at_4, m0_.imagen_id AS imagen_id_5 FROM marca m0_ WHERE m0_.visible = 1 ORDER BY m0_.orden ASC, m0_.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 = ?
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
  DISTINCT v0_.combustible AS combustible_0
FROM
  versiones v0_
WHERE
  v0_.visible = ?
  AND v0_.combustible IS NOT NULL
  AND v0_.combustible <> ?
ORDER BY
  v0_.combustible ASC

SELECT DISTINCT v0_.combustible AS combustible_0 FROM versiones v0_ WHERE v0_.visible = 1 AND v0_.combustible IS NOT NULL AND v0_.combustible <> '' ORDER BY v0_.combustible ASC;

SELECT
  DISTINCT m0_.id AS id_0
FROM
  modelos m0_
  LEFT JOIN marca m1_ ON m0_.marca_id = m1_.id
  LEFT JOIN tipos_vehiculo t2_ ON m0_.tipo_vehiculo_id = t2_.id
  LEFT JOIN versiones v3_ ON m0_.id = v3_.modelo_id
WHERE
  m0_.visible = 1
  AND m0_.es_nuevo = ?
ORDER BY
  m0_.nombre ASC
LIMIT
  12
OFFSET
  12

SELECT DISTINCT m0_.id AS id_0 FROM modelos m0_ LEFT JOIN marca m1_ ON m0_.marca_id = m1_.id LEFT JOIN tipos_vehiculo t2_ ON m0_.tipo_vehiculo_id = t2_.id LEFT JOIN versiones v3_ ON m0_.id = v3_.modelo_id WHERE m0_.visible = 1 AND m0_.es_nuevo = 0 ORDER BY m0_.nombre ASC LIMIT 12 OFFSET 12;

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_.nombre AS nombre_23,
  m1_.orden AS orden_24,
  m1_.visible AS visible_25,
  m1_.created_at AS created_at_26,
  m2_.id AS id_27,
  m2_.orden AS orden_28,
  m2_.principal AS principal_29,
  m2_.created_at AS created_at_30,
  i3_.id AS id_31,
  i3_.filename AS filename_32,
  i3_.filename_mobile AS filename_mobile_33,
  i3_.path AS path_34,
  i3_.link AS link_35,
  i3_.size AS size_36,
  i3_.mime_type AS mime_type_37,
  i3_.size_mobile AS size_mobile_38,
  i3_.mime_type_mobile AS mime_type_mobile_39,
  i3_.alt AS alt_40,
  i3_.titulo AS titulo_41,
  i3_.descripcion AS descripcion_42,
  i3_.llave AS llave_43,
  i3_.seccion AS seccion_44,
  i3_.orden AS orden_45,
  i3_.visible AS visible_46,
  i3_.created_at AS created_at_47,
  i3_.updated_at AS updated_at_48,
  v4_.id AS id_49,
  v4_.nombre_version AS nombre_version_50,
  v4_.precio AS precio_51,
  v4_.orden AS orden_52,
  v4_.visible AS visible_53,
  v4_.destacado_home AS destacado_home_54,
  v4_.created_at AS created_at_55,
  v4_.img AS img_56,
  v4_.especificaciones AS especificaciones_57,
  v4_.motor AS motor_58,
  v4_.tipo_motor AS tipo_motor_59,
  v4_.transmision AS transmision_60,
  v4_.combustible AS combustible_61,
  v4_.cilindrada_cc AS cilindrada_cc_62,
  v4_.potencia_hp AS potencia_hp_63,
  v4_.potencia_kw AS potencia_kw_64,
  v4_.torque_nm AS torque_nm_65,
  v4_.consumo AS consumo_66,
  v4_.traccion AS traccion_67,
  v4_.autonomia_km AS autonomia_km_68,
  v4_.url_pdf AS url_pdf_69,
  t5_.id AS id_70,
  t5_.nombre AS nombre_71,
  t5_.descripcion AS descripcion_72,
  t5_.orden AS orden_73,
  t5_.visible AS visible_74,
  t5_.created_at AS created_at_75,
  m0_.marca_id AS marca_id_76,
  m0_.tipo_vehiculo_id AS tipo_vehiculo_id_77,
  m1_.imagen_id AS imagen_id_78,
  m2_.modelo_id AS modelo_id_79,
  m2_.imagen_id AS imagen_id_80,
  i3_.galeria_id AS galeria_id_81,
  v4_.tipo_vehiculo_id AS tipo_vehiculo_id_82,
  v4_.modelo_id AS modelo_id_83
FROM
  modelos m0_
  INNER JOIN marca m1_ ON m0_.marca_id = m1_.id
  LEFT JOIN modelo_imagenes m2_ ON m0_.id = m2_.modelo_id
  LEFT JOIN imagenes i3_ ON m2_.imagen_id = i3_.id
  LEFT JOIN versiones v4_ ON m0_.id = v4_.modelo_id
  LEFT JOIN tipos_vehiculo t5_ ON m0_.tipo_vehiculo_id = t5_.id
WHERE
  m0_.id IN (?, ?)
ORDER BY
  m2_.principal DESC,
  m2_.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_.nombre AS nombre_23, m1_.orden AS orden_24, m1_.visible AS visible_25, m1_.created_at AS created_at_26, m2_.id AS id_27, m2_.orden AS orden_28, m2_.principal AS principal_29, m2_.created_at AS created_at_30, i3_.id AS id_31, i3_.filename AS filename_32, i3_.filename_mobile AS filename_mobile_33, i3_.path AS path_34, i3_.link AS link_35, i3_.size AS size_36, i3_.mime_type AS mime_type_37, i3_.size_mobile AS size_mobile_38, i3_.mime_type_mobile AS mime_type_mobile_39, i3_.alt AS alt_40, i3_.titulo AS titulo_41, i3_.descripcion AS descripcion_42, i3_.llave AS llave_43, i3_.seccion AS seccion_44, i3_.orden AS orden_45, i3_.visible AS visible_46, i3_.created_at AS created_at_47, i3_.updated_at AS updated_at_48, v4_.id AS id_49, v4_.nombre_version AS nombre_version_50, v4_.precio AS precio_51, v4_.orden AS orden_52, v4_.visible AS visible_53, v4_.destacado_home AS destacado_home_54, v4_.created_at AS created_at_55, v4_.img AS img_56, v4_.especificaciones AS especificaciones_57, v4_.motor AS motor_58, v4_.tipo_motor AS tipo_motor_59, v4_.transmision AS transmision_60, v4_.combustible AS combustible_61, v4_.cilindrada_cc AS cilindrada_cc_62, v4_.potencia_hp AS potencia_hp_63, v4_.potencia_kw AS potencia_kw_64, v4_.torque_nm AS torque_nm_65, v4_.consumo AS consumo_66, v4_.traccion AS traccion_67, v4_.autonomia_km AS autonomia_km_68, v4_.url_pdf AS url_pdf_69, t5_.id AS id_70, t5_.nombre AS nombre_71, t5_.descripcion AS descripcion_72, t5_.orden AS orden_73, t5_.visible AS visible_74, t5_.created_at AS created_at_75, m0_.marca_id AS marca_id_76, m0_.tipo_vehiculo_id AS tipo_vehiculo_id_77, m1_.imagen_id AS imagen_id_78, m2_.modelo_id AS modelo_id_79, m2_.imagen_id AS imagen_id_80, i3_.galeria_id AS galeria_id_81, v4_.tipo_vehiculo_id AS tipo_vehiculo_id_82, v4_.modelo_id AS modelo_id_83 FROM modelos m0_ INNER JOIN marca m1_ ON m0_.marca_id = m1_.id LEFT JOIN modelo_imagenes m2_ ON m0_.id = m2_.modelo_id LEFT JOIN imagenes i3_ ON m2_.imagen_id = i3_.id LEFT JOIN versiones v4_ ON m0_.id = v4_.modelo_id LEFT JOIN tipos_vehiculo t5_ ON m0_.tipo_vehiculo_id = t5_.id WHERE m0_.id IN (768, 770) ORDER BY m2_.principal DESC, m2_.orden ASC;

SELECT
  COUNT(m0_.id) AS sclr_0
FROM
  modelos m0_
WHERE
  m0_.id IN (
    SELECT
      DISTINCT m1_.id
    FROM
      modelos m1_
      LEFT JOIN marca m2_ ON m1_.marca_id = m2_.id
      LEFT JOIN tipos_vehiculo t3_ ON m1_.tipo_vehiculo_id = t3_.id
      LEFT JOIN versiones v4_ ON m1_.id = v4_.modelo_id
    WHERE
      m1_.visible = 1
      AND m1_.es_nuevo = ?
    ORDER BY
      m1_.nombre ASC
  )

SELECT COUNT(m0_.id) AS sclr_0 FROM modelos m0_ WHERE m0_.id IN (SELECT DISTINCT m1_.id FROM modelos m1_ LEFT JOIN marca m2_ ON m1_.marca_id = m2_.id LEFT JOIN tipos_vehiculo t3_ ON m1_.tipo_vehiculo_id = t3_.id LEFT JOIN versiones v4_ ON m1_.id = v4_.modelo_id WHERE m1_.visible = 1 AND m1_.es_nuevo = 0 ORDER BY m1_.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 = 'vehicles.page_title' AND t0_.activo = 1;

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;

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;