Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.ciudad AS ciudad_2,
  t0.calle AS calle_3,
  t0.latitud AS latitud_4,
  t0.longitud AS longitud_5,
  t6.id AS id_7,
  t6.tipo_servicio AS tipo_servicio_8,
  t6.capacidad AS capacidad_9,
  t6.num_pasajeros AS num_pasajeros_10,
  t6.fecha_inicio AS fecha_inicio_11,
  t6.fecha_fin AS fecha_fin_12,
  t6.comentario AS comentario_13,
  t6.entidad_id AS entidad_id_14,
  t6.origen_id AS origen_id_15,
  t6.destino_id AS destino_id_16,
  t17.id AS id_18,
  t17.tipo_servicio AS tipo_servicio_19,
  t17.capacidad AS capacidad_20,
  t17.num_pasajeros AS num_pasajeros_21,
  t17.fecha_inicio AS fecha_inicio_22,
  t17.fecha_fin AS fecha_fin_23,
  t17.comentario AS comentario_24,
  t17.entidad_id AS entidad_id_25,
  t17.origen_id AS origen_id_26,
  t17.destino_id AS destino_id_27
FROM
  gv_direcciones t0
  LEFT JOIN gv_servicios t6 ON t6.origen_id = t0.id
  LEFT JOIN gv_servicios t17 ON t17.destino_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ciudad AS ciudad_2, t0.calle AS calle_3, t0.latitud AS latitud_4, t0.longitud AS longitud_5, t6.id AS id_7, t6.tipo_servicio AS tipo_servicio_8, t6.capacidad AS capacidad_9, t6.num_pasajeros AS num_pasajeros_10, t6.fecha_inicio AS fecha_inicio_11, t6.fecha_fin AS fecha_fin_12, t6.comentario AS comentario_13, t6.entidad_id AS entidad_id_14, t6.origen_id AS origen_id_15, t6.destino_id AS destino_id_16, t17.id AS id_18, t17.tipo_servicio AS tipo_servicio_19, t17.capacidad AS capacidad_20, t17.num_pasajeros AS num_pasajeros_21, t17.fecha_inicio AS fecha_inicio_22, t17.fecha_fin AS fecha_fin_23, t17.comentario AS comentario_24, t17.entidad_id AS entidad_id_25, t17.origen_id AS origen_id_26, t17.destino_id AS destino_id_27 FROM gv_direcciones t0 LEFT JOIN gv_servicios t6 ON t6.origen_id = t0.id LEFT JOIN gv_servicios t17 ON t17.destino_id = t0.id WHERE t0.id = 36;

SELECT
  e0_.id AS id_0,
  e0_.nombre AS nombre_1,
  e0_.dominio AS dominio_2,
  e0_.email AS email_3,
  e0_.created_at AS created_at_4,
  e0_.updated_at AS updated_at_5,
  e0_.n_bases AS n_bases_6,
  e0_.n_vehiculos AS n_vehiculos_7,
  e0_.validado AS validado_8
FROM
  entidades e0_
WHERE
  e0_.dominio = ?
  AND e0_.validado = ?

SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.dominio AS dominio_2, e0_.email AS email_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.n_bases AS n_bases_6, e0_.n_vehiculos AS n_vehiculos_7, e0_.validado AS validado_8 FROM entidades e0_ WHERE e0_.dominio = 'pedrobus.movilium.com' AND e0_.validado = 1;

SELECT
  count(g0_.id) AS sclr_0
FROM
  gv_anuncio_matches g0_
WHERE
  g0_.vacio_id = ?
  AND g0_.confirmado_anuncio = ?

SELECT count(g0_.id) AS sclr_0 FROM gv_anuncio_matches g0_ WHERE g0_.vacio_id = 20 AND g0_.confirmado_anuncio = 1;

SELECT
  t0.id AS id_1,
  t0.servicio_vacio_id AS servicio_vacio_id_2,
  t0.servicio_pasaje_id AS servicio_pasaje_id_3
FROM
  gv_enlaces t0
WHERE
  t0.servicio_pasaje_id = ?

SELECT t0.id AS id_1, t0.servicio_vacio_id AS servicio_vacio_id_2, t0.servicio_pasaje_id AS servicio_pasaje_id_3 FROM gv_enlaces t0 WHERE t0.servicio_pasaje_id = 20;

SELECT
  t0.id AS id_1,
  t0.servicio_vacio_id AS servicio_vacio_id_2,
  t0.servicio_pasaje_id AS servicio_pasaje_id_3
FROM
  gv_enlaces t0
WHERE
  t0.servicio_vacio_id = ?

SELECT t0.id AS id_1, t0.servicio_vacio_id AS servicio_vacio_id_2, t0.servicio_pasaje_id AS servicio_pasaje_id_3 FROM gv_enlaces t0 WHERE t0.servicio_vacio_id = 20;

SELECT
  c0_.id AS id_0,
  c0_.color_principal AS color_principal_1,
  c0_.color_secundario AS color_secundario_2,
  c0_.logo_filename AS logo_filename_3,
  c0_.entidad_id AS entidad_id_4
FROM
  configuration c0_
WHERE
  c0_.entidad_id = ?
  AND c0_.entidad_id = ?

SELECT c0_.id AS id_0, c0_.color_principal AS color_principal_1, c0_.color_secundario AS color_secundario_2, c0_.logo_filename AS logo_filename_3, c0_.entidad_id AS entidad_id_4 FROM configuration c0_ WHERE c0_.entidad_id = 3 AND c0_.entidad_id = 3;

SELECT
  count(g0_.id) AS sclr_0
FROM
  gv_anuncio_match_interes g0_
WHERE
  g0_.vacio_id = ?
  AND g0_.interes_anuncio = ?

SELECT count(g0_.id) AS sclr_0 FROM gv_anuncio_match_interes g0_ WHERE g0_.vacio_id = 20 AND g0_.interes_anuncio = 1;

SELECT
  count(g0_.id) AS sclr_0
FROM
  gv_anuncio_matches g0_
  LEFT JOIN gv_anuncio_match_interes g1_ ON (
    g1_.anuncio_id = g0_.anuncio_id
    AND g1_.vacio_id = g0_.vacio_id
  )
WHERE
  g0_.vacio_id = ?
  AND g1_.interes_anuncio = ?

SELECT count(g0_.id) AS sclr_0 FROM gv_anuncio_matches g0_ LEFT JOIN gv_anuncio_match_interes g1_ ON (g1_.anuncio_id = g0_.anuncio_id AND g1_.vacio_id = g0_.vacio_id) WHERE g0_.vacio_id = 20 AND g1_.interes_anuncio = 1;

SELECT
  g0_.id AS id_0,
  g0_.interes_vacio AS interes_vacio_1,
  g0_.interes_pasaje AS interes_pasaje_2,
  g0_.vacio_id AS vacio_id_3,
  g0_.pasaje_id AS pasaje_id_4
FROM
  gv_matchs_interes g0_
WHERE
  g0_.vacio_id = ?
  AND g0_.interes_pasaje = 1
  AND g0_.interes_vacio = 0

SELECT g0_.id AS id_0, g0_.interes_vacio AS interes_vacio_1, g0_.interes_pasaje AS interes_pasaje_2, g0_.vacio_id AS vacio_id_3, g0_.pasaje_id AS pasaje_id_4 FROM gv_matchs_interes g0_ WHERE g0_.vacio_id = 20 AND g0_.interes_pasaje = 1 AND g0_.interes_vacio = 0;

SELECT
  count(g0_.id) AS sclr_0
FROM
  gv_anuncio_matches g0_
WHERE
  g0_.vacio_id = ?

SELECT count(g0_.id) AS sclr_0 FROM gv_anuncio_matches g0_ WHERE g0_.vacio_id = 20;

SELECT
  count(ma_int.id) as TOTAL
FROM
  gv_matchs_interes ma_int
WHERE
  1 = 1
  AND ma_int.pasaje_id = 35
  AND ma_int.interes_pasaje = 1

SELECT count(ma_int.id) as TOTAL FROM gv_matchs_interes ma_int WHERE 1=1 AND ma_int.pasaje_id = 35 AND ma_int.interes_pasaje = 1 ;

SELECT
  count(ma.id) as TOTAL
FROM
  gv_matchs ma
WHERE
  1 = 1
  AND ma.vacio_id = 28
  AND ma.confirmado_vacio = 1

SELECT count(ma.id) as TOTAL FROM gv_matchs ma WHERE 1=1 AND ma.vacio_id = 28 AND ma.confirmado_vacio = 1 ;

SELECT
  count(ma.id) as TOTAL
FROM
  gv_matchs ma
WHERE
  1 = 1
  AND ma.vacio_id = 20

SELECT count(ma.id) as TOTAL FROM gv_matchs ma WHERE 1=1 AND ma.vacio_id = 20 ;

SELECT
  g0_.id AS id_0,
  g0_.interes_vacio AS interes_vacio_1,
  g0_.interes_pasaje AS interes_pasaje_2,
  g0_.vacio_id AS vacio_id_3,
  g0_.pasaje_id AS pasaje_id_4
FROM
  gv_matchs_interes g0_
WHERE
  g0_.pasaje_id = ?
  AND g0_.interes_vacio = 1
  AND g0_.interes_pasaje = 0

SELECT g0_.id AS id_0, g0_.interes_vacio AS interes_vacio_1, g0_.interes_pasaje AS interes_pasaje_2, g0_.vacio_id AS vacio_id_3, g0_.pasaje_id AS pasaje_id_4 FROM gv_matchs_interes g0_ WHERE g0_.pasaje_id = 35 AND g0_.interes_vacio = 1 AND g0_.interes_pasaje = 0;

SELECT
  g0_.id AS id_0,
  g0_.tipo_servicio AS tipo_servicio_1,
  g0_.capacidad AS capacidad_2,
  g0_.num_pasajeros AS num_pasajeros_3,
  g0_.fecha_inicio AS fecha_inicio_4,
  g0_.fecha_fin AS fecha_fin_5,
  g0_.comentario AS comentario_6,
  g0_.entidad_id AS entidad_id_7,
  g0_.origen_id AS origen_id_8,
  g0_.destino_id AS destino_id_9
FROM
  gv_servicios g0_
WHERE
  g0_.entidad_id = ?

SELECT g0_.id AS id_0, g0_.tipo_servicio AS tipo_servicio_1, g0_.capacidad AS capacidad_2, g0_.num_pasajeros AS num_pasajeros_3, g0_.fecha_inicio AS fecha_inicio_4, g0_.fecha_fin AS fecha_fin_5, g0_.comentario AS comentario_6, g0_.entidad_id AS entidad_id_7, g0_.origen_id AS origen_id_8, g0_.destino_id AS destino_id_9 FROM gv_servicios g0_ WHERE g0_.entidad_id = 3;

SELECT
  g0_.id AS id_0,
  g0_.distancia_origen AS distancia_origen_1,
  g0_.distancia_destino AS distancia_destino_2,
  g0_.distancia_trayecto AS distancia_trayecto_3,
  g0_.distancia_total AS distancia_total_4,
  g0_.idoneidad AS idoneidad_5,
  g0_.created_at AS created_at_6,
  g0_.confirmado_vacio AS confirmado_vacio_7,
  g0_.confirmado_pasaje AS confirmado_pasaje_8,
  g0_.updated_at_vacio AS updated_at_vacio_9,
  g0_.updated_at_pasaje AS updated_at_pasaje_10,
  g0_.vacio_id AS vacio_id_11,
  g0_.pasaje_id AS pasaje_id_12,
  g0_.usuario_vacio_id AS usuario_vacio_id_13,
  g0_.usuario_pasaje_id AS usuario_pasaje_id_14
FROM
  gv_matchs g0_
WHERE
  g0_.pasaje_id = ?
  AND g0_.confirmado_vacio = 1
  AND g0_.confirmado_pasaje = 0

SELECT g0_.id AS id_0, g0_.distancia_origen AS distancia_origen_1, g0_.distancia_destino AS distancia_destino_2, g0_.distancia_trayecto AS distancia_trayecto_3, g0_.distancia_total AS distancia_total_4, g0_.idoneidad AS idoneidad_5, g0_.created_at AS created_at_6, g0_.confirmado_vacio AS confirmado_vacio_7, g0_.confirmado_pasaje AS confirmado_pasaje_8, g0_.updated_at_vacio AS updated_at_vacio_9, g0_.updated_at_pasaje AS updated_at_pasaje_10, g0_.vacio_id AS vacio_id_11, g0_.pasaje_id AS pasaje_id_12, g0_.usuario_vacio_id AS usuario_vacio_id_13, g0_.usuario_pasaje_id AS usuario_pasaje_id_14 FROM gv_matchs g0_ WHERE g0_.pasaje_id = 35 AND g0_.confirmado_vacio = 1 AND g0_.confirmado_pasaje = 0;

SELECT
  g0_.id AS id_0,
  g0_.distancia_origen AS distancia_origen_1,
  g0_.distancia_destino AS distancia_destino_2,
  g0_.distancia_trayecto AS distancia_trayecto_3,
  g0_.distancia_total AS distancia_total_4,
  g0_.idoneidad AS idoneidad_5,
  g0_.created_at AS created_at_6,
  g0_.confirmado_vacio AS confirmado_vacio_7,
  g0_.confirmado_pasaje AS confirmado_pasaje_8,
  g0_.updated_at_vacio AS updated_at_vacio_9,
  g0_.updated_at_pasaje AS updated_at_pasaje_10,
  g0_.vacio_id AS vacio_id_11,
  g0_.pasaje_id AS pasaje_id_12,
  g0_.usuario_vacio_id AS usuario_vacio_id_13,
  g0_.usuario_pasaje_id AS usuario_pasaje_id_14
FROM
  gv_matchs g0_
WHERE
  g0_.vacio_id = ?
  AND g0_.confirmado_vacio = 0
  AND g0_.confirmado_pasaje = 1

SELECT g0_.id AS id_0, g0_.distancia_origen AS distancia_origen_1, g0_.distancia_destino AS distancia_destino_2, g0_.distancia_trayecto AS distancia_trayecto_3, g0_.distancia_total AS distancia_total_4, g0_.idoneidad AS idoneidad_5, g0_.created_at AS created_at_6, g0_.confirmado_vacio AS confirmado_vacio_7, g0_.confirmado_pasaje AS confirmado_pasaje_8, g0_.updated_at_vacio AS updated_at_vacio_9, g0_.updated_at_pasaje AS updated_at_pasaje_10, g0_.vacio_id AS vacio_id_11, g0_.pasaje_id AS pasaje_id_12, g0_.usuario_vacio_id AS usuario_vacio_id_13, g0_.usuario_pasaje_id AS usuario_pasaje_id_14 FROM gv_matchs g0_ WHERE g0_.vacio_id = 20 AND g0_.confirmado_vacio = 0 AND g0_.confirmado_pasaje = 1;

SELECT
  count(ma.id) as TOTAL
FROM
  gv_matchs ma
WHERE
  1 = 1
  AND ma.pasaje_id = 35
  AND ma.confirmado_vacio = 1
  AND ma.confirmado_pasaje = 1

SELECT count(ma.id) as TOTAL FROM gv_matchs ma WHERE 1=1 AND ma.pasaje_id = 35 AND ma.confirmado_vacio = 1 AND ma.confirmado_pasaje = 1 ;

SELECT
  count(ma.id) as TOTAL
FROM
  gv_matchs ma
WHERE
  1 = 1
  AND ma.pasaje_id = 35
  AND ma.confirmado_pasaje = 1

SELECT count(ma.id) as TOTAL FROM gv_matchs ma WHERE 1=1 AND ma.pasaje_id = 35 AND ma.confirmado_pasaje = 1 ;

SELECT
  count(ma.id) as TOTAL
FROM
  gv_matchs ma
WHERE
  1 = 1
  AND ma.vacio_id = 20
  AND ma.confirmado_vacio = 1
  AND ma.confirmado_pasaje = 1

SELECT count(ma.id) as TOTAL FROM gv_matchs ma WHERE 1=1 AND ma.vacio_id = 20 AND ma.confirmado_vacio = 1 AND ma.confirmado_pasaje = 1 ;

SELECT
  count(g0_.id) AS sclr_0
FROM
  gv_anuncio_matches g0_
WHERE
  g0_.vacio_id = ?
  AND g0_.confirmado_anuncio = ?
  AND g0_.confirmado_vacio = ?

SELECT count(g0_.id) AS sclr_0 FROM gv_anuncio_matches g0_ WHERE g0_.vacio_id = 20 AND g0_.confirmado_anuncio = 1 AND g0_.confirmado_vacio = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.locale AS locale_5,
  t0.descuento_traslados AS descuento_traslados_6,
  t0.descuento_disposiciones AS descuento_disposiciones_7,
  t0.descuento_cenas AS descuento_cenas_8,
  t0.descuento_excursiones AS descuento_excursiones_9,
  t0.descuento_circuitos AS descuento_circuitos_10,
  t0.entidad_id AS entidad_id_11
FROM
  `users` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.locale AS locale_5, t0.descuento_traslados AS descuento_traslados_6, t0.descuento_disposiciones AS descuento_disposiciones_7, t0.descuento_cenas AS descuento_cenas_8, t0.descuento_excursiones AS descuento_excursiones_9, t0.descuento_circuitos AS descuento_circuitos_10, t0.entidad_id AS entidad_id_11 FROM `users` t0 WHERE t0.id = 31;

SELECT
  count(ma_int.id) as TOTAL
FROM
  gv_matchs_interes ma_int
WHERE
  1 = 1
  AND ma_int.vacio_id = 20
  AND ma_int.interes_vacio = 1

SELECT count(ma_int.id) as TOTAL FROM gv_matchs_interes ma_int WHERE 1=1 AND ma_int.vacio_id = 20 AND ma_int.interes_vacio = 1 ;

SELECT
  count(ma.id) as TOTAL
FROM
  gv_matchs ma
WHERE
  1 = 1
  AND ma.vacio_id = 28
  AND ma.confirmado_vacio = 1
  AND ma.confirmado_pasaje = 1

SELECT count(ma.id) as TOTAL FROM gv_matchs ma WHERE 1=1 AND ma.vacio_id = 28 AND ma.confirmado_vacio = 1 AND ma.confirmado_pasaje = 1 ;

SELECT
  count(ma.id) as TOTAL
FROM
  gv_matchs ma
WHERE
  1 = 1
  AND ma.pasaje_id = 35

SELECT count(ma.id) as TOTAL FROM gv_matchs ma WHERE 1=1 AND ma.pasaje_id = 35 ;

SELECT
  count(ma.id) as TOTAL
FROM
  gv_matchs ma
WHERE
  1 = 1
  AND ma.vacio_id = 28

SELECT count(ma.id) as TOTAL FROM gv_matchs ma WHERE 1=1 AND ma.vacio_id = 28 ;

SELECT
  count(ma.id) as TOTAL
FROM
  gv_matchs ma
WHERE
  1 = 1
  AND ma.vacio_id = 20
  AND ma.confirmado_vacio = 1

SELECT count(ma.id) as TOTAL FROM gv_matchs ma WHERE 1=1 AND ma.vacio_id = 20 AND ma.confirmado_vacio = 1 ;

SELECT
  count(ma_int.id) as TOTAL
FROM
  gv_matchs_interes ma_int
WHERE
  1 = 1
  AND ma_int.vacio_id = 28
  AND ma_int.interes_vacio = 1

SELECT count(ma_int.id) as TOTAL FROM gv_matchs_interes ma_int WHERE 1=1 AND ma_int.vacio_id = 28 AND ma_int.interes_vacio = 1 ;