Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.titulo_app AS titulo_app_1,
  c0_.descripcion_app AS descripcion_app_2,
  c0_.seo_title AS seo_title_3,
  c0_.seo_description AS seo_description_4,
  c0_.seo_keywords AS seo_keywords_5,
  c0_.colores AS colores_6,
  c0_.codigo_google_analytics_front AS codigo_google_analytics_front_7,
  c0_.rrss_facebook AS rrss_facebook_8,
  c0_.rrss_twitter AS rrss_twitter_9,
  c0_.rrss_instagram AS rrss_instagram_10,
  c0_.rrss_linkedin AS rrss_linkedin_11
FROM
  configuracion_general c0_
LIMIT
  1

SELECT c0_.id AS id_0, c0_.titulo_app AS titulo_app_1, c0_.descripcion_app AS descripcion_app_2, c0_.seo_title AS seo_title_3, c0_.seo_description AS seo_description_4, c0_.seo_keywords AS seo_keywords_5, c0_.colores AS colores_6, c0_.codigo_google_analytics_front AS codigo_google_analytics_front_7, c0_.rrss_facebook AS rrss_facebook_8, c0_.rrss_twitter AS rrss_twitter_9, c0_.rrss_instagram AS rrss_instagram_10, c0_.rrss_linkedin AS rrss_linkedin_11 FROM configuracion_general c0_ LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.direccion AS direccion_1,
  c0_.contrasena AS contrasena_2,
  c0_.smtp AS smtp_3,
  c0_.puerto AS puerto_4,
  c0_.seguridad AS seguridad_5,
  c0_.email_front AS email_front_6,
  c0_.pie_legal AS pie_legal_7,
  c0_.nombre_emisor AS nombre_emisor_8
FROM
  configuracion_correo c0_
LIMIT
  1

SELECT c0_.id AS id_0, c0_.direccion AS direccion_1, c0_.contrasena AS contrasena_2, c0_.smtp AS smtp_3, c0_.puerto AS puerto_4, c0_.seguridad AS seguridad_5, c0_.email_front AS email_front_6, c0_.pie_legal AS pie_legal_7, c0_.nombre_emisor AS nombre_emisor_8 FROM configuracion_correo c0_ LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.visible AS visible_3,
  t0.borrado AS borrado_4,
  t0.tiene_menos5000_habitantes AS tiene_menos5000_habitantes_5,
  t0.slug AS slug_6,
  t0.seo_title AS seo_title_7,
  t0.seo_description AS seo_description_8,
  t0.seo_keywords AS seo_keywords_9,
  t0.comarca_id AS comarca_id_10
FROM
  localidad t0
WHERE
  t0.slug IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.visible AS visible_3, t0.borrado AS borrado_4, t0.tiene_menos5000_habitantes AS tiene_menos5000_habitantes_5, t0.slug AS slug_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.comarca_id AS comarca_id_10 FROM localidad t0 WHERE t0.slug IS NULL LIMIT 1;

SELECT
  count(DISTINCT j0_.id) AS sclr_0
FROM
  jornada_curso j0_
  LEFT JOIN localidad l1_ ON (l1_.id = j0_.localidad_id)
WHERE
  j0_.visible = 1
  AND j0_.borrado = 0
  AND j0_.nombre LIKE ?

SELECT count(DISTINCT j0_.id) AS sclr_0 FROM jornada_curso j0_ LEFT JOIN localidad l1_ ON (l1_.id = j0_.localidad_id) WHERE j0_.visible = 1 AND j0_.borrado = 0 AND j0_.nombre LIKE '%%';

SELECT
  DISTINCT j0_.id AS id_0,
  j0_.fecha_hora_creacion AS fecha_hora_creacion_1
FROM
  jornada_curso j0_
  LEFT JOIN localidad l1_ ON (l1_.id = j0_.localidad_id)
WHERE
  j0_.visible = 1
  AND j0_.borrado = 0
  AND j0_.nombre LIKE ?
ORDER BY
  j0_.fecha_hora_creacion DESC
LIMIT
  30

SELECT DISTINCT j0_.id AS id_0, j0_.fecha_hora_creacion AS fecha_hora_creacion_1 FROM jornada_curso j0_ LEFT JOIN localidad l1_ ON (l1_.id = j0_.localidad_id) WHERE j0_.visible = 1 AND j0_.borrado = 0 AND j0_.nombre LIKE '%%' ORDER BY j0_.fecha_hora_creacion DESC LIMIT 30;

SELECT
  j0_.id AS id_0,
  j0_.codigo_ministerio AS codigo_ministerio_1,
  j0_.nombre AS nombre_2,
  j0_.fecha_hora AS fecha_hora_3,
  j0_.fecha_inicio_inscripciones AS fecha_inicio_inscripciones_4,
  j0_.fecha_fin_inscripciones AS fecha_fin_inscripciones_5,
  j0_.lugar AS lugar_6,
  j0_.num_plazas AS num_plazas_7,
  j0_.descripcion AS descripcion_8,
  j0_.importe AS importe_9,
  j0_.estado AS estado_10,
  j0_.visible AS visible_11,
  j0_.borrado AS borrado_12,
  j0_.imagen AS imagen_13,
  j0_.seo_title AS seo_title_14,
  j0_.seo_description AS seo_description_15,
  j0_.seo_keywords AS seo_keywords_16,
  j0_.slug AS slug_17,
  j0_.fecha_hora_creacion AS fecha_hora_creacion_18,
  j0_.localidad_id AS localidad_id_19
FROM
  jornada_curso j0_
  LEFT JOIN localidad l1_ ON (l1_.id = j0_.localidad_id)
WHERE
  j0_.visible = 1
  AND j0_.borrado = 0
  AND j0_.nombre LIKE ?
  AND j0_.id IN (?)
ORDER BY
  j0_.fecha_hora_creacion DESC

SELECT j0_.id AS id_0, j0_.codigo_ministerio AS codigo_ministerio_1, j0_.nombre AS nombre_2, j0_.fecha_hora AS fecha_hora_3, j0_.fecha_inicio_inscripciones AS fecha_inicio_inscripciones_4, j0_.fecha_fin_inscripciones AS fecha_fin_inscripciones_5, j0_.lugar AS lugar_6, j0_.num_plazas AS num_plazas_7, j0_.descripcion AS descripcion_8, j0_.importe AS importe_9, j0_.estado AS estado_10, j0_.visible AS visible_11, j0_.borrado AS borrado_12, j0_.imagen AS imagen_13, j0_.seo_title AS seo_title_14, j0_.seo_description AS seo_description_15, j0_.seo_keywords AS seo_keywords_16, j0_.slug AS slug_17, j0_.fecha_hora_creacion AS fecha_hora_creacion_18, j0_.localidad_id AS localidad_id_19 FROM jornada_curso j0_ LEFT JOIN localidad l1_ ON (l1_.id = j0_.localidad_id) WHERE j0_.visible = 1 AND j0_.borrado = 0 AND j0_.nombre LIKE '%%' AND j0_.id IN (1) ORDER BY j0_.fecha_hora_creacion DESC;

SELECT
  l0_.id AS id_0,
  l0_.nombre AS nombre_1,
  l0_.visible AS visible_2,
  l0_.borrado AS borrado_3,
  l0_.tiene_menos5000_habitantes AS tiene_menos5000_habitantes_4,
  l0_.slug AS slug_5,
  l0_.seo_title AS seo_title_6,
  l0_.seo_description AS seo_description_7,
  l0_.seo_keywords AS seo_keywords_8,
  l0_.comarca_id AS comarca_id_9
FROM
  localidad l0_
WHERE
  l0_.visible = 1
  AND l0_.borrado = 0
ORDER BY
  l0_.nombre ASC

SELECT l0_.id AS id_0, l0_.nombre AS nombre_1, l0_.visible AS visible_2, l0_.borrado AS borrado_3, l0_.tiene_menos5000_habitantes AS tiene_menos5000_habitantes_4, l0_.slug AS slug_5, l0_.seo_title AS seo_title_6, l0_.seo_description AS seo_description_7, l0_.seo_keywords AS seo_keywords_8, l0_.comarca_id AS comarca_id_9 FROM localidad l0_ WHERE l0_.visible = 1 AND l0_.borrado = 0 ORDER BY l0_.nombre ASC;

SELECT
  c0_.id AS id_0,
  c0_.titulo_app AS titulo_app_1,
  c0_.descripcion_app AS descripcion_app_2,
  c0_.seo_title AS seo_title_3,
  c0_.seo_description AS seo_description_4,
  c0_.seo_keywords AS seo_keywords_5,
  c0_.colores AS colores_6,
  c0_.codigo_google_analytics_front AS codigo_google_analytics_front_7,
  c0_.rrss_facebook AS rrss_facebook_8,
  c0_.rrss_twitter AS rrss_twitter_9,
  c0_.rrss_instagram AS rrss_instagram_10,
  c0_.rrss_linkedin AS rrss_linkedin_11
FROM
  configuracion_general c0_
LIMIT
  1

SELECT c0_.id AS id_0, c0_.titulo_app AS titulo_app_1, c0_.descripcion_app AS descripcion_app_2, c0_.seo_title AS seo_title_3, c0_.seo_description AS seo_description_4, c0_.seo_keywords AS seo_keywords_5, c0_.colores AS colores_6, c0_.codigo_google_analytics_front AS codigo_google_analytics_front_7, c0_.rrss_facebook AS rrss_facebook_8, c0_.rrss_twitter AS rrss_twitter_9, c0_.rrss_instagram AS rrss_instagram_10, c0_.rrss_linkedin AS rrss_linkedin_11 FROM configuracion_general c0_ LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.titulo_app AS titulo_app_1,
  c0_.descripcion_app AS descripcion_app_2,
  c0_.seo_title AS seo_title_3,
  c0_.seo_description AS seo_description_4,
  c0_.seo_keywords AS seo_keywords_5,
  c0_.colores AS colores_6,
  c0_.codigo_google_analytics_front AS codigo_google_analytics_front_7,
  c0_.rrss_facebook AS rrss_facebook_8,
  c0_.rrss_twitter AS rrss_twitter_9,
  c0_.rrss_instagram AS rrss_instagram_10,
  c0_.rrss_linkedin AS rrss_linkedin_11
FROM
  configuracion_general c0_
LIMIT
  1

SELECT c0_.id AS id_0, c0_.titulo_app AS titulo_app_1, c0_.descripcion_app AS descripcion_app_2, c0_.seo_title AS seo_title_3, c0_.seo_description AS seo_description_4, c0_.seo_keywords AS seo_keywords_5, c0_.colores AS colores_6, c0_.codigo_google_analytics_front AS codigo_google_analytics_front_7, c0_.rrss_facebook AS rrss_facebook_8, c0_.rrss_twitter AS rrss_twitter_9, c0_.rrss_instagram AS rrss_instagram_10, c0_.rrss_linkedin AS rrss_linkedin_11 FROM configuracion_general c0_ LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.titulo_app AS titulo_app_1,
  c0_.descripcion_app AS descripcion_app_2,
  c0_.seo_title AS seo_title_3,
  c0_.seo_description AS seo_description_4,
  c0_.seo_keywords AS seo_keywords_5,
  c0_.colores AS colores_6,
  c0_.codigo_google_analytics_front AS codigo_google_analytics_front_7,
  c0_.rrss_facebook AS rrss_facebook_8,
  c0_.rrss_twitter AS rrss_twitter_9,
  c0_.rrss_instagram AS rrss_instagram_10,
  c0_.rrss_linkedin AS rrss_linkedin_11
FROM
  configuracion_general c0_
LIMIT
  1

SELECT c0_.id AS id_0, c0_.titulo_app AS titulo_app_1, c0_.descripcion_app AS descripcion_app_2, c0_.seo_title AS seo_title_3, c0_.seo_description AS seo_description_4, c0_.seo_keywords AS seo_keywords_5, c0_.colores AS colores_6, c0_.codigo_google_analytics_front AS codigo_google_analytics_front_7, c0_.rrss_facebook AS rrss_facebook_8, c0_.rrss_twitter AS rrss_twitter_9, c0_.rrss_instagram AS rrss_instagram_10, c0_.rrss_linkedin AS rrss_linkedin_11 FROM configuracion_general c0_ LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.titulo_app AS titulo_app_1,
  c0_.descripcion_app AS descripcion_app_2,
  c0_.seo_title AS seo_title_3,
  c0_.seo_description AS seo_description_4,
  c0_.seo_keywords AS seo_keywords_5,
  c0_.colores AS colores_6,
  c0_.codigo_google_analytics_front AS codigo_google_analytics_front_7,
  c0_.rrss_facebook AS rrss_facebook_8,
  c0_.rrss_twitter AS rrss_twitter_9,
  c0_.rrss_instagram AS rrss_instagram_10,
  c0_.rrss_linkedin AS rrss_linkedin_11
FROM
  configuracion_general c0_
LIMIT
  1

SELECT c0_.id AS id_0, c0_.titulo_app AS titulo_app_1, c0_.descripcion_app AS descripcion_app_2, c0_.seo_title AS seo_title_3, c0_.seo_description AS seo_description_4, c0_.seo_keywords AS seo_keywords_5, c0_.colores AS colores_6, c0_.codigo_google_analytics_front AS codigo_google_analytics_front_7, c0_.rrss_facebook AS rrss_facebook_8, c0_.rrss_twitter AS rrss_twitter_9, c0_.rrss_instagram AS rrss_instagram_10, c0_.rrss_linkedin AS rrss_linkedin_11 FROM configuracion_general c0_ LIMIT 1;