Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.tipo AS tipo_2,
  t0.seccion AS seccion_3,
  t0.estado AS estado_4,
  t0.fecha_creacion AS fecha_creacion_5,
  t0.fecha_actualizacion AS fecha_actualizacion_6
FROM
  banner t0
WHERE
  t0.seccion = ?
  AND t0.estado = ?

SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.seccion AS seccion_3, t0.estado AS estado_4, t0.fecha_creacion AS fecha_creacion_5, t0.fecha_actualizacion AS fecha_actualizacion_6 FROM banner t0 WHERE t0.seccion = 'PRINCIPAL' AND t0.estado = 'A';

SELECT
  t0.id AS id_1,
  t0.imagen_desktop AS imagen_desktop_2,
  t0.imagen_tablet AS imagen_tablet_3,
  t0.imagen_movil AS imagen_movil_4,
  t0.nombre_original_desktop AS nombre_original_desktop_5,
  t0.nombre_original_tablet AS nombre_original_tablet_6,
  t0.nombre_original_movil AS nombre_original_movil_7,
  t0.nombre_alterno AS nombre_alterno_8,
  t0.posicion AS posicion_9,
  t0.url_redirect AS url_redirect_10,
  t0.estado AS estado_11,
  t0.banner_id AS banner_id_12
FROM
  imagen t0
WHERE
  t0.banner_id = ?
ORDER BY
  t0.posicion ASC

SELECT t0.id AS id_1, t0.imagen_desktop AS imagen_desktop_2, t0.imagen_tablet AS imagen_tablet_3, t0.imagen_movil AS imagen_movil_4, t0.nombre_original_desktop AS nombre_original_desktop_5, t0.nombre_original_tablet AS nombre_original_tablet_6, t0.nombre_original_movil AS nombre_original_movil_7, t0.nombre_alterno AS nombre_alterno_8, t0.posicion AS posicion_9, t0.url_redirect AS url_redirect_10, t0.estado AS estado_11, t0.banner_id AS banner_id_12 FROM imagen t0 WHERE t0.banner_id = 15 ORDER BY t0.posicion ASC;

SELECT
  t0.id AS id_1,
  t0.tipo AS tipo_2,
  t0.seccion AS seccion_3,
  t0.estado AS estado_4,
  t0.fecha_creacion AS fecha_creacion_5,
  t0.fecha_actualizacion AS fecha_actualizacion_6
FROM
  banner t0
WHERE
  t0.seccion = ?
  AND t0.estado = ?

SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.seccion AS seccion_3, t0.estado AS estado_4, t0.fecha_creacion AS fecha_creacion_5, t0.fecha_actualizacion AS fecha_actualizacion_6 FROM banner t0 WHERE t0.seccion = 'SECCION1' AND t0.estado = 'A';

SELECT
  t0.id AS id_1,
  t0.tipo AS tipo_2,
  t0.seccion AS seccion_3,
  t0.estado AS estado_4,
  t0.fecha_creacion AS fecha_creacion_5,
  t0.fecha_actualizacion AS fecha_actualizacion_6
FROM
  banner t0
WHERE
  t0.seccion = ?
  AND t0.estado = ?

SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.seccion AS seccion_3, t0.estado AS estado_4, t0.fecha_creacion AS fecha_creacion_5, t0.fecha_actualizacion AS fecha_actualizacion_6 FROM banner t0 WHERE t0.seccion = 'SECCION2' AND t0.estado = 'A';

SELECT
  t0.id AS id_1,
  t0.imagen_desktop AS imagen_desktop_2,
  t0.imagen_tablet AS imagen_tablet_3,
  t0.imagen_movil AS imagen_movil_4,
  t0.nombre_original_desktop AS nombre_original_desktop_5,
  t0.nombre_original_tablet AS nombre_original_tablet_6,
  t0.nombre_original_movil AS nombre_original_movil_7,
  t0.nombre_alterno AS nombre_alterno_8,
  t0.posicion AS posicion_9,
  t0.url_redirect AS url_redirect_10,
  t0.estado AS estado_11,
  t0.banner_id AS banner_id_12
FROM
  imagen t0
WHERE
  t0.banner_id = ?
ORDER BY
  t0.posicion ASC

SELECT t0.id AS id_1, t0.imagen_desktop AS imagen_desktop_2, t0.imagen_tablet AS imagen_tablet_3, t0.imagen_movil AS imagen_movil_4, t0.nombre_original_desktop AS nombre_original_desktop_5, t0.nombre_original_tablet AS nombre_original_tablet_6, t0.nombre_original_movil AS nombre_original_movil_7, t0.nombre_alterno AS nombre_alterno_8, t0.posicion AS posicion_9, t0.url_redirect AS url_redirect_10, t0.estado AS estado_11, t0.banner_id AS banner_id_12 FROM imagen t0 WHERE t0.banner_id = 16 ORDER BY t0.posicion ASC;

SELECT
  p0_.id AS id_0
FROM
  producto p0_
WHERE
  p0_.status_infor = 1
  AND p0_.status_eCommerce = 1
  AND p0_.marca IS NOT NULL
  AND p0_.id = 2073

SELECT p0_.id AS id_0 FROM producto p0_ WHERE p0_.status_infor = 1 AND p0_.status_eCommerce = 1 AND p0_.marca IS NOT NULL AND p0_.id = 2073;

SELECT
  p0_.id AS id_0
FROM
  producto p0_
WHERE
  p0_.sesion = true
  AND p0_.id = 2073

SELECT p0_.id AS id_0 FROM producto p0_ WHERE p0_.sesion = true AND p0_.id = 2073;

SELECT
  t0.id AS id_1,
  t0.Idinfor AS idinfor_2,
  t0.Descripcion AS descripcion_3,
  t0.Inventario AS inventario_4,
  t0.Pvp AS pvp_5,
  t0.Ultima_actualizacion AS ultima_actualizacion_6,
  t0.status_infor AS status_infor_7,
  t0.status_eCommerce AS status_ecommerce_8,
  t0.Idfamilia AS idfamilia_9,
  t0.Value_linea_de_producto AS value_linea_de_producto_10,
  t0.Value_grupo_estadistico AS value_grupo_estadistico_11,
  t0.Id_estructura_ecommerce AS id_estructura_ecommerce_12,
  t0.Descripcion_comercial AS descripcion_comercial_13,
  t0.Descripcion_corta AS descripcion_corta_14,
  t0.Descripcion_larga AS descripcion_larga_15,
  t0.Aplicaciones_relacionadas AS aplicaciones_relacionadas_16,
  t0.url_foto AS url_foto_17,
  t0.sesion AS sesion_18,
  t0.tiene_despiece AS tiene_despiece_19,
  t0.estado_btc AS estado_btc_20,
  t0.descuento_bateria AS descuento_bateria_21,
  t0.valor_descuento_bateria AS valor_descuento_bateria_22,
  t0.otros_productos AS otros_productos_23,
  t0.promocion_vigente AS promocion_vigente_24,
  t0.slogan AS slogan_25,
  t0.tipo_uso AS tipo_uso_26,
  t0.marca AS marca_27
FROM
  producto t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.Idinfor AS idinfor_2, t0.Descripcion AS descripcion_3, t0.Inventario AS inventario_4, t0.Pvp AS pvp_5, t0.Ultima_actualizacion AS ultima_actualizacion_6, t0.status_infor AS status_infor_7, t0.status_eCommerce AS status_ecommerce_8, t0.Idfamilia AS idfamilia_9, t0.Value_linea_de_producto AS value_linea_de_producto_10, t0.Value_grupo_estadistico AS value_grupo_estadistico_11, t0.Id_estructura_ecommerce AS id_estructura_ecommerce_12, t0.Descripcion_comercial AS descripcion_comercial_13, t0.Descripcion_corta AS descripcion_corta_14, t0.Descripcion_larga AS descripcion_larga_15, t0.Aplicaciones_relacionadas AS aplicaciones_relacionadas_16, t0.url_foto AS url_foto_17, t0.sesion AS sesion_18, t0.tiene_despiece AS tiene_despiece_19, t0.estado_btc AS estado_btc_20, t0.descuento_bateria AS descuento_bateria_21, t0.valor_descuento_bateria AS valor_descuento_bateria_22, t0.otros_productos AS otros_productos_23, t0.promocion_vigente AS promocion_vigente_24, t0.slogan AS slogan_25, t0.tipo_uso AS tipo_uso_26, t0.marca AS marca_27 FROM producto t0 WHERE t0.id = '2073';

SELECT
  p0_.id AS id_0,
  p0_.Idinfor AS idinfor_1,
  p0_.Pvp AS pvp_2,
  p0_.Descripcion AS descripcion_3,
  p0_.Descripcion_corta AS descripcion_corta_4,
  p0_.Descripcion_larga AS descripcion_larga_5,
  p0_.url_foto AS url_foto_6,
  m1_.nombre AS nombre_7,
  p0_.Idfamilia AS idfamilia_8,
  f2_.Nombre AS nombre_9,
  p0_.estado_btc AS estado_btc_10,
  p0_.valor_descuento_bateria AS valor_descuento_bateria_11,
  p0_.descuento_bateria AS descuento_bateria_12
FROM
  producto p0_
  LEFT JOIN marca m1_ ON p0_.marca = m1_.id
  LEFT JOIN familia f2_ ON (f2_.Id_infor = p0_.Idfamilia)
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.Idinfor AS idinfor_1, p0_.Pvp AS pvp_2, p0_.Descripcion AS descripcion_3, p0_.Descripcion_corta AS descripcion_corta_4, p0_.Descripcion_larga AS descripcion_larga_5, p0_.url_foto AS url_foto_6, m1_.nombre AS nombre_7, p0_.Idfamilia AS idfamilia_8, f2_.Nombre AS nombre_9, p0_.estado_btc AS estado_btc_10, p0_.valor_descuento_bateria AS valor_descuento_bateria_11, p0_.descuento_bateria AS descuento_bateria_12 FROM producto p0_ LEFT JOIN marca m1_ ON p0_.marca = m1_.id LEFT JOIN familia f2_ ON (f2_.Id_infor = p0_.Idfamilia) WHERE p0_.id = '2073';

SELECT
  a0_.id AS id_0,
  t1_.id AS id_1,
  a0_.Url AS url_2,
  a0_.Alt_text AS alt_text_3,
  a0_.nombre AS nombre_4,
  a0_.target_blank AS target_blank_5
FROM
  producto p2_
  INNER JOIN adjuntos a0_ ON p2_.id = a0_.id_producto
  INNER JOIN tipo_documento t1_ ON a0_.id_tipo = t1_.id
WHERE
  a0_.id_producto = ?

SELECT a0_.id AS id_0, t1_.id AS id_1, a0_.Url AS url_2, a0_.Alt_text AS alt_text_3, a0_.nombre AS nombre_4, a0_.target_blank AS target_blank_5 FROM producto p2_ INNER JOIN adjuntos a0_ ON p2_.id = a0_.id_producto INNER JOIN tipo_documento t1_ ON a0_.id_tipo = t1_.id WHERE a0_.id_producto = '2073';

SELECT
  p0_.id AS id_0,
  p0_.Idinfor AS idinfor_1,
  p0_.Pvp AS pvp_2,
  p0_.Descripcion AS descripcion_3,
  p0_.Descripcion_corta AS descripcion_corta_4,
  p0_.Descripcion_larga AS descripcion_larga_5,
  p0_.url_foto AS url_foto_6,
  m1_.nombre AS nombre_7,
  p0_.Idfamilia AS idfamilia_8,
  f2_.Nombre AS nombre_9
FROM
  producto p0_
  LEFT JOIN marca m1_ ON p0_.marca = m1_.id
  LEFT JOIN familia f2_ ON (f2_.Id_infor = p0_.Idfamilia)
WHERE
  p0_.status_eCommerce = 1
  AND p0_.id IN (
    SELECT
      DISTINCT d3_.id_producto_relacionado
    FROM
      detalle_producto_tipo_relacion d3_
    WHERE
      d3_.id_producto = 2073
    ORDER BY
      d3_.id_producto_relacionado ASC
  )

SELECT p0_.id AS id_0, p0_.Idinfor AS idinfor_1, p0_.Pvp AS pvp_2, p0_.Descripcion AS descripcion_3, p0_.Descripcion_corta AS descripcion_corta_4, p0_.Descripcion_larga AS descripcion_larga_5, p0_.url_foto AS url_foto_6, m1_.nombre AS nombre_7, p0_.Idfamilia AS idfamilia_8, f2_.Nombre AS nombre_9 FROM producto p0_ LEFT JOIN marca m1_ ON p0_.marca = m1_.id LEFT JOIN familia f2_ ON (f2_.Id_infor = p0_.Idfamilia) WHERE p0_.status_eCommerce = 1 AND p0_.id IN (SELECT DISTINCT d3_.id_producto_relacionado FROM detalle_producto_tipo_relacion d3_ WHERE d3_.id_producto = 2073 ORDER BY d3_.id_producto_relacionado ASC);

SELECT
  c0_.id AS id_0,
  c0_.Nombre AS nombre_1,
  c1_.id AS id_2,
  c1_.valor AS valor_3
FROM
  producto p2_,
  familia f3_,
  caracteristica c0_,
  caracteristica_valor c1_,
  detalle_familia_caracteristica d4_
WHERE
  p2_.Idfamilia = f3_.Id_infor
  AND c0_.id = c1_.id_caracteristica
  AND c0_.id = d4_.id_caracteristica
  AND d4_.id_familia = f3_.id
  AND p2_.id = c1_.id_producto
  AND p2_.id = 2073
ORDER BY
  d4_.posicion ASC

SELECT c0_.id AS id_0, c0_.Nombre AS nombre_1, c1_.id AS id_2, c1_.valor AS valor_3 FROM producto p2_, familia f3_, caracteristica c0_, caracteristica_valor c1_, detalle_familia_caracteristica d4_ WHERE p2_.Idfamilia = f3_.Id_infor AND c0_.id = c1_.id_caracteristica AND c0_.id = d4_.id_caracteristica AND d4_.id_familia = f3_.id AND p2_.id = c1_.id_producto AND p2_.id = 2073 ORDER BY d4_.posicion ASC;

SELECT
  p0_.id AS id_0,
  p0_.Descripcion AS descripcion_1,
  p0_.Pvp AS pvp_2,
  p0_.Descripcion_larga AS descripcion_larga_3,
  p0_.url_foto AS url_foto_4
FROM
  producto p0_
WHERE
  p0_.id = 2073

SELECT p0_.id AS id_0, p0_.Descripcion AS descripcion_1, p0_.Pvp AS pvp_2, p0_.Descripcion_larga AS descripcion_larga_3, p0_.url_foto AS url_foto_4 FROM producto p0_ WHERE p0_.id = 2073;

SELECT
  a0_.marca AS marca_0,
  a0_.modelo AS modelo_1,
  a0_.tipo AS sclr_2,
  e1_.nombre AS nombre_3
FROM
  detalle_producto_aplicacion d2_,
  aplicacion a0_,
  estructura_aplicacion e1_
WHERE
  2073 = d2_.id_producto
  AND d2_.id_aplicacion = a0_.id
  AND e1_.id = a0_.tipo
  AND a0_.status = 1
GROUP BY
  a0_.marca,
  a0_.modelo,
  a0_.tipo,
  e1_.nombre
ORDER BY
  a0_.marca ASC

SELECT a0_.marca AS marca_0, a0_.modelo AS modelo_1, a0_.tipo AS sclr_2, e1_.nombre AS nombre_3 FROM detalle_producto_aplicacion d2_, aplicacion a0_, estructura_aplicacion e1_ WHERE 2073 = d2_.id_producto AND d2_.id_aplicacion = a0_.id AND e1_.id = a0_.tipo AND a0_.status = 1 GROUP BY a0_.marca, a0_.modelo, a0_.tipo, e1_.nombre ORDER BY a0_.marca ASC;

SELECT
  d0_.id_aplicacion AS sclr_0,
  d0_.id_producto AS sclr_1,
  a1_.marca AS marca_2,
  a1_.modelo AS modelo_3,
  e2_.nombre AS nombre_4,
  a1_.anio_fabricacion AS anio_fabricacion_5,
  a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6,
  a1_.cilindraje AS cilindraje_7,
  a1_.numero_de_cilindros AS numero_de_cilindros_8,
  a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9,
  a1_.combustible AS combustible_10,
  a1_.origen AS origen_11,
  a1_.version AS version_12,
  d0_.comentario AS comentario_13
FROM
  detalle_producto_aplicacion d0_,
  aplicacion a1_,
  estructura_aplicacion e2_
WHERE
  2073 = d0_.id_producto
  AND d0_.id_aplicacion = a1_.id
  AND e2_.id = a1_.tipo
  AND a1_.marca = 'ACURA'
  AND a1_.tipo = 2
  AND a1_.status = 1

SELECT d0_.id_aplicacion AS sclr_0, d0_.id_producto AS sclr_1, a1_.marca AS marca_2, a1_.modelo AS modelo_3, e2_.nombre AS nombre_4, a1_.anio_fabricacion AS anio_fabricacion_5, a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6, a1_.cilindraje AS cilindraje_7, a1_.numero_de_cilindros AS numero_de_cilindros_8, a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9, a1_.combustible AS combustible_10, a1_.origen AS origen_11, a1_.version AS version_12, d0_.comentario AS comentario_13 FROM detalle_producto_aplicacion d0_, aplicacion a1_, estructura_aplicacion e2_ WHERE 2073 = d0_.id_producto AND d0_.id_aplicacion = a1_.id AND e2_.id = a1_.tipo AND a1_.marca = 'ACURA' AND a1_.tipo = 2 AND a1_.status = 1;

SELECT
  d0_.id_aplicacion AS sclr_0,
  d0_.id_producto AS sclr_1,
  a1_.marca AS marca_2,
  a1_.modelo AS modelo_3,
  e2_.nombre AS nombre_4,
  a1_.anio_fabricacion AS anio_fabricacion_5,
  a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6,
  a1_.cilindraje AS cilindraje_7,
  a1_.numero_de_cilindros AS numero_de_cilindros_8,
  a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9,
  a1_.combustible AS combustible_10,
  a1_.origen AS origen_11,
  a1_.version AS version_12,
  d0_.comentario AS comentario_13
FROM
  detalle_producto_aplicacion d0_,
  aplicacion a1_,
  estructura_aplicacion e2_
WHERE
  2073 = d0_.id_producto
  AND d0_.id_aplicacion = a1_.id
  AND e2_.id = a1_.tipo
  AND a1_.marca = 'AGRALE - DEUTZ'
  AND a1_.tipo = 2
  AND a1_.status = 1

SELECT d0_.id_aplicacion AS sclr_0, d0_.id_producto AS sclr_1, a1_.marca AS marca_2, a1_.modelo AS modelo_3, e2_.nombre AS nombre_4, a1_.anio_fabricacion AS anio_fabricacion_5, a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6, a1_.cilindraje AS cilindraje_7, a1_.numero_de_cilindros AS numero_de_cilindros_8, a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9, a1_.combustible AS combustible_10, a1_.origen AS origen_11, a1_.version AS version_12, d0_.comentario AS comentario_13 FROM detalle_producto_aplicacion d0_, aplicacion a1_, estructura_aplicacion e2_ WHERE 2073 = d0_.id_producto AND d0_.id_aplicacion = a1_.id AND e2_.id = a1_.tipo AND a1_.marca = 'AGRALE - DEUTZ' AND a1_.tipo = 2 AND a1_.status = 1;

SELECT
  d0_.id_aplicacion AS sclr_0,
  d0_.id_producto AS sclr_1,
  a1_.marca AS marca_2,
  a1_.modelo AS modelo_3,
  e2_.nombre AS nombre_4,
  a1_.anio_fabricacion AS anio_fabricacion_5,
  a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6,
  a1_.cilindraje AS cilindraje_7,
  a1_.numero_de_cilindros AS numero_de_cilindros_8,
  a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9,
  a1_.combustible AS combustible_10,
  a1_.origen AS origen_11,
  a1_.version AS version_12,
  d0_.comentario AS comentario_13
FROM
  detalle_producto_aplicacion d0_,
  aplicacion a1_,
  estructura_aplicacion e2_
WHERE
  2073 = d0_.id_producto
  AND d0_.id_aplicacion = a1_.id
  AND e2_.id = a1_.tipo
  AND a1_.marca = 'BAW'
  AND a1_.tipo = 2
  AND a1_.status = 1

SELECT d0_.id_aplicacion AS sclr_0, d0_.id_producto AS sclr_1, a1_.marca AS marca_2, a1_.modelo AS modelo_3, e2_.nombre AS nombre_4, a1_.anio_fabricacion AS anio_fabricacion_5, a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6, a1_.cilindraje AS cilindraje_7, a1_.numero_de_cilindros AS numero_de_cilindros_8, a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9, a1_.combustible AS combustible_10, a1_.origen AS origen_11, a1_.version AS version_12, d0_.comentario AS comentario_13 FROM detalle_producto_aplicacion d0_, aplicacion a1_, estructura_aplicacion e2_ WHERE 2073 = d0_.id_producto AND d0_.id_aplicacion = a1_.id AND e2_.id = a1_.tipo AND a1_.marca = 'BAW' AND a1_.tipo = 2 AND a1_.status = 1;

SELECT
  d0_.id_aplicacion AS sclr_0,
  d0_.id_producto AS sclr_1,
  a1_.marca AS marca_2,
  a1_.modelo AS modelo_3,
  e2_.nombre AS nombre_4,
  a1_.anio_fabricacion AS anio_fabricacion_5,
  a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6,
  a1_.cilindraje AS cilindraje_7,
  a1_.numero_de_cilindros AS numero_de_cilindros_8,
  a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9,
  a1_.combustible AS combustible_10,
  a1_.origen AS origen_11,
  a1_.version AS version_12,
  d0_.comentario AS comentario_13
FROM
  detalle_producto_aplicacion d0_,
  aplicacion a1_,
  estructura_aplicacion e2_
WHERE
  2073 = d0_.id_producto
  AND d0_.id_aplicacion = a1_.id
  AND e2_.id = a1_.tipo
  AND a1_.marca = 'BAW'
  AND a1_.tipo = 2
  AND a1_.status = 1

SELECT d0_.id_aplicacion AS sclr_0, d0_.id_producto AS sclr_1, a1_.marca AS marca_2, a1_.modelo AS modelo_3, e2_.nombre AS nombre_4, a1_.anio_fabricacion AS anio_fabricacion_5, a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6, a1_.cilindraje AS cilindraje_7, a1_.numero_de_cilindros AS numero_de_cilindros_8, a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9, a1_.combustible AS combustible_10, a1_.origen AS origen_11, a1_.version AS version_12, d0_.comentario AS comentario_13 FROM detalle_producto_aplicacion d0_, aplicacion a1_, estructura_aplicacion e2_ WHERE 2073 = d0_.id_producto AND d0_.id_aplicacion = a1_.id AND e2_.id = a1_.tipo AND a1_.marca = 'BAW' AND a1_.tipo = 2 AND a1_.status = 1;

SELECT
  d0_.id_aplicacion AS sclr_0,
  d0_.id_producto AS sclr_1,
  a1_.marca AS marca_2,
  a1_.modelo AS modelo_3,
  e2_.nombre AS nombre_4,
  a1_.anio_fabricacion AS anio_fabricacion_5,
  a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6,
  a1_.cilindraje AS cilindraje_7,
  a1_.numero_de_cilindros AS numero_de_cilindros_8,
  a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9,
  a1_.combustible AS combustible_10,
  a1_.origen AS origen_11,
  a1_.version AS version_12,
  d0_.comentario AS comentario_13
FROM
  detalle_producto_aplicacion d0_,
  aplicacion a1_,
  estructura_aplicacion e2_
WHERE
  2073 = d0_.id_producto
  AND d0_.id_aplicacion = a1_.id
  AND e2_.id = a1_.tipo
  AND a1_.marca = 'BAW'
  AND a1_.tipo = 2
  AND a1_.status = 1

SELECT d0_.id_aplicacion AS sclr_0, d0_.id_producto AS sclr_1, a1_.marca AS marca_2, a1_.modelo AS modelo_3, e2_.nombre AS nombre_4, a1_.anio_fabricacion AS anio_fabricacion_5, a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6, a1_.cilindraje AS cilindraje_7, a1_.numero_de_cilindros AS numero_de_cilindros_8, a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9, a1_.combustible AS combustible_10, a1_.origen AS origen_11, a1_.version AS version_12, d0_.comentario AS comentario_13 FROM detalle_producto_aplicacion d0_, aplicacion a1_, estructura_aplicacion e2_ WHERE 2073 = d0_.id_producto AND d0_.id_aplicacion = a1_.id AND e2_.id = a1_.tipo AND a1_.marca = 'BAW' AND a1_.tipo = 2 AND a1_.status = 1;

SELECT
  d0_.id_aplicacion AS sclr_0,
  d0_.id_producto AS sclr_1,
  a1_.marca AS marca_2,
  a1_.modelo AS modelo_3,
  e2_.nombre AS nombre_4,
  a1_.anio_fabricacion AS anio_fabricacion_5,
  a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6,
  a1_.cilindraje AS cilindraje_7,
  a1_.numero_de_cilindros AS numero_de_cilindros_8,
  a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9,
  a1_.combustible AS combustible_10,
  a1_.origen AS origen_11,
  a1_.version AS version_12,
  d0_.comentario AS comentario_13
FROM
  detalle_producto_aplicacion d0_,
  aplicacion a1_,
  estructura_aplicacion e2_
WHERE
  2073 = d0_.id_producto
  AND d0_.id_aplicacion = a1_.id
  AND e2_.id = a1_.tipo
  AND a1_.marca = 'BAW'
  AND a1_.tipo = 2
  AND a1_.status = 1

SELECT d0_.id_aplicacion AS sclr_0, d0_.id_producto AS sclr_1, a1_.marca AS marca_2, a1_.modelo AS modelo_3, e2_.nombre AS nombre_4, a1_.anio_fabricacion AS anio_fabricacion_5, a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6, a1_.cilindraje AS cilindraje_7, a1_.numero_de_cilindros AS numero_de_cilindros_8, a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9, a1_.combustible AS combustible_10, a1_.origen AS origen_11, a1_.version AS version_12, d0_.comentario AS comentario_13 FROM detalle_producto_aplicacion d0_, aplicacion a1_, estructura_aplicacion e2_ WHERE 2073 = d0_.id_producto AND d0_.id_aplicacion = a1_.id AND e2_.id = a1_.tipo AND a1_.marca = 'BAW' AND a1_.tipo = 2 AND a1_.status = 1;

SELECT
  d0_.id_aplicacion AS sclr_0,
  d0_.id_producto AS sclr_1,
  a1_.marca AS marca_2,
  a1_.modelo AS modelo_3,
  e2_.nombre AS nombre_4,
  a1_.anio_fabricacion AS anio_fabricacion_5,
  a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6,
  a1_.cilindraje AS cilindraje_7,
  a1_.numero_de_cilindros AS numero_de_cilindros_8,
  a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9,
  a1_.combustible AS combustible_10,
  a1_.origen AS origen_11,
  a1_.version AS version_12,
  d0_.comentario AS comentario_13
FROM
  detalle_producto_aplicacion d0_,
  aplicacion a1_,
  estructura_aplicacion e2_
WHERE
  2073 = d0_.id_producto
  AND d0_.id_aplicacion = a1_.id
  AND e2_.id = a1_.tipo
  AND a1_.marca = 'BAW'
  AND a1_.tipo = 2
  AND a1_.status = 1

SELECT d0_.id_aplicacion AS sclr_0, d0_.id_producto AS sclr_1, a1_.marca AS marca_2, a1_.modelo AS modelo_3, e2_.nombre AS nombre_4, a1_.anio_fabricacion AS anio_fabricacion_5, a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6, a1_.cilindraje AS cilindraje_7, a1_.numero_de_cilindros AS numero_de_cilindros_8, a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9, a1_.combustible AS combustible_10, a1_.origen AS origen_11, a1_.version AS version_12, d0_.comentario AS comentario_13 FROM detalle_producto_aplicacion d0_, aplicacion a1_, estructura_aplicacion e2_ WHERE 2073 = d0_.id_producto AND d0_.id_aplicacion = a1_.id AND e2_.id = a1_.tipo AND a1_.marca = 'BAW' AND a1_.tipo = 2 AND a1_.status = 1;

SELECT
  d0_.id_aplicacion AS sclr_0,
  d0_.id_producto AS sclr_1,
  a1_.marca AS marca_2,
  a1_.modelo AS modelo_3,
  e2_.nombre AS nombre_4,
  a1_.anio_fabricacion AS anio_fabricacion_5,
  a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6,
  a1_.cilindraje AS cilindraje_7,
  a1_.numero_de_cilindros AS numero_de_cilindros_8,
  a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9,
  a1_.combustible AS combustible_10,
  a1_.origen AS origen_11,
  a1_.version AS version_12,
  d0_.comentario AS comentario_13
FROM
  detalle_producto_aplicacion d0_,
  aplicacion a1_,
  estructura_aplicacion e2_
WHERE
  2073 = d0_.id_producto
  AND d0_.id_aplicacion = a1_.id
  AND e2_.id = a1_.tipo
  AND a1_.marca = 'BYD'
  AND a1_.tipo = 2
  AND a1_.status = 1

SELECT d0_.id_aplicacion AS sclr_0, d0_.id_producto AS sclr_1, a1_.marca AS marca_2, a1_.modelo AS modelo_3, e2_.nombre AS nombre_4, a1_.anio_fabricacion AS anio_fabricacion_5, a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6, a1_.cilindraje AS cilindraje_7, a1_.numero_de_cilindros AS numero_de_cilindros_8, a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9, a1_.combustible AS combustible_10, a1_.origen AS origen_11, a1_.version AS version_12, d0_.comentario AS comentario_13 FROM detalle_producto_aplicacion d0_, aplicacion a1_, estructura_aplicacion e2_ WHERE 2073 = d0_.id_producto AND d0_.id_aplicacion = a1_.id AND e2_.id = a1_.tipo AND a1_.marca = 'BYD' AND a1_.tipo = 2 AND a1_.status = 1;

SELECT
  d0_.id_aplicacion AS sclr_0,
  d0_.id_producto AS sclr_1,
  a1_.marca AS marca_2,
  a1_.modelo AS modelo_3,
  e2_.nombre AS nombre_4,
  a1_.anio_fabricacion AS anio_fabricacion_5,
  a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6,
  a1_.cilindraje AS cilindraje_7,
  a1_.numero_de_cilindros AS numero_de_cilindros_8,
  a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9,
  a1_.combustible AS combustible_10,
  a1_.origen AS origen_11,
  a1_.version AS version_12,
  d0_.comentario AS comentario_13
FROM
  detalle_producto_aplicacion d0_,
  aplicacion a1_,
  estructura_aplicacion e2_
WHERE
  2073 = d0_.id_producto
  AND d0_.id_aplicacion = a1_.id
  AND e2_.id = a1_.tipo
  AND a1_.marca = 'BYD'
  AND a1_.tipo = 2
  AND a1_.status = 1

SELECT d0_.id_aplicacion AS sclr_0, d0_.id_producto AS sclr_1, a1_.marca AS marca_2, a1_.modelo AS modelo_3, e2_.nombre AS nombre_4, a1_.anio_fabricacion AS anio_fabricacion_5, a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6, a1_.cilindraje AS cilindraje_7, a1_.numero_de_cilindros AS numero_de_cilindros_8, a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9, a1_.combustible AS combustible_10, a1_.origen AS origen_11, a1_.version AS version_12, d0_.comentario AS comentario_13 FROM detalle_producto_aplicacion d0_, aplicacion a1_, estructura_aplicacion e2_ WHERE 2073 = d0_.id_producto AND d0_.id_aplicacion = a1_.id AND e2_.id = a1_.tipo AND a1_.marca = 'BYD' AND a1_.tipo = 2 AND a1_.status = 1;

SELECT
  d0_.id_aplicacion AS sclr_0,
  d0_.id_producto AS sclr_1,
  a1_.marca AS marca_2,
  a1_.modelo AS modelo_3,
  e2_.nombre AS nombre_4,
  a1_.anio_fabricacion AS anio_fabricacion_5,
  a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6,
  a1_.cilindraje AS cilindraje_7,
  a1_.numero_de_cilindros AS numero_de_cilindros_8,
  a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9,
  a1_.combustible AS combustible_10,
  a1_.origen AS origen_11,
  a1_.version AS version_12,
  d0_.comentario AS comentario_13
FROM
  detalle_producto_aplicacion d0_,
  aplicacion a1_,
  estructura_aplicacion e2_
WHERE
  2073 = d0_.id_producto
  AND d0_.id_aplicacion = a1_.id
  AND e2_.id = a1_.tipo
  AND a1_.marca = 'BYD'
  AND a1_.tipo = 2
  AND a1_.status = 1

SELECT d0_.id_aplicacion AS sclr_0, d0_.id_producto AS sclr_1, a1_.marca AS marca_2, a1_.modelo AS modelo_3, e2_.nombre AS nombre_4, a1_.anio_fabricacion AS anio_fabricacion_5, a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6, a1_.cilindraje AS cilindraje_7, a1_.numero_de_cilindros AS numero_de_cilindros_8, a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9, a1_.combustible AS combustible_10, a1_.origen AS origen_11, a1_.version AS version_12, d0_.comentario AS comentario_13 FROM detalle_producto_aplicacion d0_, aplicacion a1_, estructura_aplicacion e2_ WHERE 2073 = d0_.id_producto AND d0_.id_aplicacion = a1_.id AND e2_.id = a1_.tipo AND a1_.marca = 'BYD' AND a1_.tipo = 2 AND a1_.status = 1;

SELECT
  d0_.id_aplicacion AS sclr_0,
  d0_.id_producto AS sclr_1,
  a1_.marca AS marca_2,
  a1_.modelo AS modelo_3,
  e2_.nombre AS nombre_4,
  a1_.anio_fabricacion AS anio_fabricacion_5,
  a1_.anio_fin_fabricacion AS anio_fin_fabricacion_6,
  a1_.cilindraje AS cilindraje_7,
  a1_.numero_de_cilindros AS numero_de_cilindros_8,
  a1_.tipo_comando_valvulas AS tipo_comando_valvulas_9,
  a1_.combustible AS combustible_10,
  a1_.origen AS origen_11,
  a1_.version AS version_12,
  d0_.comentario AS comentario_13
FROM
  detalle_producto_aplicacion d0_,
  aplicacion a1_,
  estructura_aplicacion e2_
WHERE
  2073 = d0_.id_producto
  AND d0_.id_aplicacion = a1_.id
  AND e2_.id = a1_.tipo
  AND a1_.marca = 'CHEVROLET'
  AND a1_.tipo = 1
  AND a1_.status = 1