Symfony Profiler

call stats_accesos ('escenas', 1, null)

call stats_accesos ('escenas', 1, null);

SELECT
  u.cuenta_invitaciones
FROM
  stats_invitaciones u
WHERE
  u.uid = 'WtmT9tqkI7gDOGVxVNEyIBJKjuW2'

SELECT u.cuenta_invitaciones FROM stats_invitaciones u WHERE u.uid = 'WtmT9tqkI7gDOGVxVNEyIBJKjuW2';

SELECT
  u.cuenta_usuarios
FROM
  stats_invitaciones u
WHERE
  u.uid = 'WtmT9tqkI7gDOGVxVNEyIBJKjuW2'

SELECT u.cuenta_usuarios FROM stats_invitaciones u WHERE u.uid = 'WtmT9tqkI7gDOGVxVNEyIBJKjuW2';

SELECT
  t0.id AS id_1,
  t0.codigo AS codigo_2,
  t0.referencia AS referencia_3,
  t0.fecha_desde AS fecha_desde_4,
  t0.hora_desde AS hora_desde_5,
  t0.fecha_hasta AS fecha_hasta_6,
  t0.hora_hasta AS hora_hasta_7,
  t0.escena_id AS escena_id_8,
  t0.nombre AS nombre_9,
  t0.dias AS dias_10,
  t0.usuario_id AS usuario_id_11,
  t0.duracion AS duracion_12,
  t0.observaciones AS observaciones_13,
  t0.id AS id_14,
  t0.plataforma_id AS plataforma_id_15
FROM
  api_entradasproximas t0
WHERE
  t0.usuario_id = ?
ORDER BY
  t0.dias ASC,
  t0.nombre ASC

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.referencia AS referencia_3, t0.fecha_desde AS fecha_desde_4, t0.hora_desde AS hora_desde_5, t0.fecha_hasta AS fecha_hasta_6, t0.hora_hasta AS hora_hasta_7, t0.escena_id AS escena_id_8, t0.nombre AS nombre_9, t0.dias AS dias_10, t0.usuario_id AS usuario_id_11, t0.duracion AS duracion_12, t0.observaciones AS observaciones_13, t0.id AS id_14, t0.plataforma_id AS plataforma_id_15 FROM api_entradasproximas t0 WHERE t0.usuario_id = 1 ORDER BY t0.dias ASC, t0.nombre ASC;

call proc_invitacioneshuespedes_wizars (1)

call proc_invitacioneshuespedes_wizars (1);

SELECT
  DISTINCT mo.codigo
FROM
  escenaspropietarios ep
  JOIN escenas e ON e.id = ep.escena_id
  JOIN usuariosmodulos um ON um.usuario_id = e.usuario_id
  JOIN modulos mo ON mo.id = um.modulo_id
WHERE
  ep.copropietario_id = ?
  AND ep.estado = 1
  AND um.estado = 2

SELECT DISTINCT mo.codigo
				FROM escenaspropietarios ep
				JOIN escenas e ON e.id = ep.escena_id
				JOIN usuariosmodulos um ON um.usuario_id = e.usuario_id
				JOIN modulos mo ON mo.id = um.modulo_id
				WHERE ep.copropietario_id = 1
				AND ep.estado = 1
				AND um.estado = 2
			;

SELECT
  t0.id AS id_1,
  t0.codigo AS codigo_2,
  t0.referencia AS referencia_3,
  t0.fecha_hasta AS fecha_hasta_4,
  t0.hora_hasta AS hora_hasta_5,
  t0.escena_id AS escena_id_6,
  t0.nombre AS nombre_7,
  t0.dias AS dias_8,
  t0.usuario_id AS usuario_id_9,
  t0.observaciones AS observaciones_10,
  t0.plataforma_id AS plataforma_id_11
FROM
  api_salidasproximas t0
WHERE
  t0.usuario_id = ?
ORDER BY
  t0.dias ASC,
  t0.nombre ASC

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.referencia AS referencia_3, t0.fecha_hasta AS fecha_hasta_4, t0.hora_hasta AS hora_hasta_5, t0.escena_id AS escena_id_6, t0.nombre AS nombre_7, t0.dias AS dias_8, t0.usuario_id AS usuario_id_9, t0.observaciones AS observaciones_10, t0.plataforma_id AS plataforma_id_11 FROM api_salidasproximas t0 WHERE t0.usuario_id = 1 ORDER BY t0.dias ASC, t0.nombre ASC;

SELECT
  i0_.id AS id_0,
  i0_.codigo AS codigo_1,
  i0_.referencia AS referencia_2,
  i0_.observaciones AS observaciones_3,
  i0_.fecha_desde AS fecha_desde_4,
  i0_.hora_desde AS hora_desde_5,
  i0_.fecha_hasta AS fecha_hasta_6,
  i0_.hora_hasta AS hora_hasta_7,
  i0_.previsualizar AS previsualizar_8,
  i0_.compartir AS compartir_9,
  i0_.limitar_por_posicion AS limitar_por_posicion_10,
  i0_.usos AS usos_11,
  i0_.activo AS activo_12,
  i0_.ocultar_calendario AS ocultar_calendario_13,
  i0_.sesion_id AS sesion_id_14,
  i0_.tecladoweb AS tecladoweb_15,
  i0_.archivada AS archivada_16,
  i0_.numero_checkins AS numero_checkins_17,
  i0_.url_acceso_directo AS url_acceso_directo_18,
  i0_.escena_id AS escena_id_19,
  i0_.horario_id AS horario_id_20,
  i0_.tipocheckin AS tipocheckin_21,
  i0_.estado_checkin AS estado_checkin_22,
  i0_.plataforma_id AS plataforma_id_23
FROM
  invitaciones i0_
  INNER JOIN escenas e1_ ON i0_.escena_id = e1_.id
  LEFT JOIN escenaspropietarios e2_ ON e1_.id = e2_.escena_id
WHERE
  (
    e1_.usuario_id = ?
    OR (
      e2_.copropietario_id = ?
      AND i0_.fecha_desde >= SUBSTRING(
        e2_.fecha_estado
        FROM
          1 FOR 10
      )
      AND e2_.activo = 1
    )
  )
  AND i0_.archivada = 0

SELECT i0_.id AS id_0, i0_.codigo AS codigo_1, i0_.referencia AS referencia_2, i0_.observaciones AS observaciones_3, i0_.fecha_desde AS fecha_desde_4, i0_.hora_desde AS hora_desde_5, i0_.fecha_hasta AS fecha_hasta_6, i0_.hora_hasta AS hora_hasta_7, i0_.previsualizar AS previsualizar_8, i0_.compartir AS compartir_9, i0_.limitar_por_posicion AS limitar_por_posicion_10, i0_.usos AS usos_11, i0_.activo AS activo_12, i0_.ocultar_calendario AS ocultar_calendario_13, i0_.sesion_id AS sesion_id_14, i0_.tecladoweb AS tecladoweb_15, i0_.archivada AS archivada_16, i0_.numero_checkins AS numero_checkins_17, i0_.url_acceso_directo AS url_acceso_directo_18, i0_.escena_id AS escena_id_19, i0_.horario_id AS horario_id_20, i0_.tipocheckin AS tipocheckin_21, i0_.estado_checkin AS estado_checkin_22, i0_.plataforma_id AS plataforma_id_23 FROM invitaciones i0_ INNER JOIN escenas e1_ ON i0_.escena_id = e1_.id LEFT JOIN escenaspropietarios e2_ ON e1_.id = e2_.escena_id WHERE (e1_.usuario_id = 1 OR (e2_.copropietario_id = 1 AND i0_.fecha_desde >= SUBSTRING(e2_.fecha_estado FROM 1 FOR 10) AND e2_.activo = 1)) AND i0_.archivada = 0;

SELECT
  t0.id AS id_1,
  t0.codigo AS codigo_2,
  t0.nombre AS nombre_3,
  t0.coste AS coste_4,
  t0.unidad AS unidad_5,
  t0.activo AS activo_6
FROM
  modulos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.coste AS coste_4, t0.unidad AS unidad_5, t0.activo AS activo_6 FROM modulos t0 WHERE t0.id = 1;

SELECT
  a0_.uid AS uid_0,
  a0_.usuario_id AS usuario_id_1,
  a0_.instalador_id AS instalador_id_2,
  a0_.email AS email_3,
  a0_.modo_id AS modo_id_4,
  a0_.nombre AS nombre_5,
  a0_.estado AS estado_6,
  a0_.fecha_estado AS fecha_estado_7,
  a0_.respuesta AS respuesta_8,
  a0_.fecha_respuesta AS fecha_respuesta_9,
  a0_.escenacerradura_id AS escenacerradura_id_10,
  a0_.escena AS escena_11,
  a0_.cerradura_id AS cerradura_id_12,
  a0_.nivel_bateria AS nivel_bateria_13,
  a0_.id AS id_14
FROM
  apiestadoscerraduras a0_
WHERE
  a0_.usuario_id = ?
  OR a0_.instalador_id = ?
ORDER BY
  a0_.estado DESC,
  a0_.respuesta DESC,
  a0_.nombre ASC

SELECT a0_.uid AS uid_0, a0_.usuario_id AS usuario_id_1, a0_.instalador_id AS instalador_id_2, a0_.email AS email_3, a0_.modo_id AS modo_id_4, a0_.nombre AS nombre_5, a0_.estado AS estado_6, a0_.fecha_estado AS fecha_estado_7, a0_.respuesta AS respuesta_8, a0_.fecha_respuesta AS fecha_respuesta_9, a0_.escenacerradura_id AS escenacerradura_id_10, a0_.escena AS escena_11, a0_.cerradura_id AS cerradura_id_12, a0_.nivel_bateria AS nivel_bateria_13, a0_.id AS id_14 FROM apiestadoscerraduras a0_ WHERE a0_.usuario_id = 1 OR a0_.instalador_id = 1 ORDER BY a0_.estado DESC, a0_.respuesta DESC, a0_.nombre ASC;

SELECT
  t0.id AS id_1,
  t0.tipo AS tipo_2,
  t0.hash_notificacion AS hash_notificacion_3,
  t0.titulo AS titulo_4,
  t0.contenido AS contenido_5,
  t0.datos_reemplazo AS datos_reemplazo_6,
  t0.boton_texto AS boton_texto_7,
  t0.boton_url AS boton_url_8,
  t0.icono AS icono_9,
  t0.icono_class AS icono_class_10,
  t0.fecha_alta AS fecha_alta_11,
  t0.omitido AS omitido_12,
  t0.activo AS activo_13,
  t0.fecha_omitido AS fecha_omitido_14,
  t0.usuario_id AS usuario_id_15
FROM
  notificaciones t0
WHERE
  t0.usuario_id = ?
  AND t0.omitido = ?
  AND t0.activo = ?

SELECT t0.id AS id_1, t0.tipo AS tipo_2, t0.hash_notificacion AS hash_notificacion_3, t0.titulo AS titulo_4, t0.contenido AS contenido_5, t0.datos_reemplazo AS datos_reemplazo_6, t0.boton_texto AS boton_texto_7, t0.boton_url AS boton_url_8, t0.icono AS icono_9, t0.icono_class AS icono_class_10, t0.fecha_alta AS fecha_alta_11, t0.omitido AS omitido_12, t0.activo AS activo_13, t0.fecha_omitido AS fecha_omitido_14, t0.usuario_id AS usuario_id_15 FROM notificaciones t0 WHERE t0.usuario_id = 1 AND t0.omitido = 0 AND t0.activo = 1;

SELECT
  t0.id AS id_1,
  t0.fecha_caducidad AS fecha_caducidad_2,
  t0.sesion_id AS sesion_id_3,
  t0.estado AS estado_4,
  t0.multiplicador AS multiplicador_5,
  t0.bruto AS bruto_6,
  t0.descuento AS descuento_7,
  t0.usuario_id AS usuario_id_8,
  t0.modulo_id AS modulo_id_9
FROM
  usuariosmodulos t0
WHERE
  t0.usuario_id = ?

SELECT t0.id AS id_1, t0.fecha_caducidad AS fecha_caducidad_2, t0.sesion_id AS sesion_id_3, t0.estado AS estado_4, t0.multiplicador AS multiplicador_5, t0.bruto AS bruto_6, t0.descuento AS descuento_7, t0.usuario_id AS usuario_id_8, t0.modulo_id AS modulo_id_9 FROM usuariosmodulos t0 WHERE t0.usuario_id = 1;

SELECT
  t0.id AS id_1,
  t0.contacto AS contacto_2,
  t0.envio AS envio_3,
  t0.limitado_al_contacto AS limitado_al_contacto_4,
  t0.idioma AS idioma_5,
  t0.fecha_envio AS fecha_envio_6,
  t0.fecha_activacion AS fecha_activacion_7,
  t0.programacion_envio AS programacion_envio_8,
  t0.envio_checkin AS envio_checkin_9,
  t0.requisito_checkin AS requisito_checkin_10,
  t0.fecha_envio_checkin AS fecha_envio_checkin_11,
  t0.codigoSeguridad AS codigoSeguridad_12,
  t0.invitacion_id AS invitacion_id_13,
  t0.usuario_id AS usuario_id_14,
  t0.escenausuario_id AS escenausuario_id_15,
  t0.sesion_id AS sesion_id_16
FROM
  invitacionesusuarios t0
WHERE
  t0.invitacion_id = ?

SELECT t0.id AS id_1, t0.contacto AS contacto_2, t0.envio AS envio_3, t0.limitado_al_contacto AS limitado_al_contacto_4, t0.idioma AS idioma_5, t0.fecha_envio AS fecha_envio_6, t0.fecha_activacion AS fecha_activacion_7, t0.programacion_envio AS programacion_envio_8, t0.envio_checkin AS envio_checkin_9, t0.requisito_checkin AS requisito_checkin_10, t0.fecha_envio_checkin AS fecha_envio_checkin_11, t0.codigoSeguridad AS codigoSeguridad_12, t0.invitacion_id AS invitacion_id_13, t0.usuario_id AS usuario_id_14, t0.escenausuario_id AS escenausuario_id_15, t0.sesion_id AS sesion_id_16 FROM invitacionesusuarios t0 WHERE t0.invitacion_id = 123565;

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.email AS email_3,
  t0.nombre AS nombre_4,
  t0.apellidos AS apellidos_5,
  t0.password AS password_6,
  t0.razon AS razon_7,
  t0.doi AS doi_8,
  t0.movil AS movil_9,
  t0.fecha_nacimiento AS fecha_nacimiento_10,
  t0.activo AS activo_11,
  t0.reset_password AS reset_password_12,
  t0.reset_validez AS reset_validez_13,
  t0.locale AS locale_14,
  t0.sesion_id AS sesion_id_15,
  t0.intentos_login AS intentos_login_16,
  t0.ultimo_login AS ultimo_login_17,
  t0.instalador_id AS instalador_id_18,
  t0.rol AS rol_19,
  t0.notificar AS notificar_20,
  t0.paquete_id AS paquete_id_21
FROM
  usuarios t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.email AS email_3, t0.nombre AS nombre_4, t0.apellidos AS apellidos_5, t0.password AS password_6, t0.razon AS razon_7, t0.doi AS doi_8, t0.movil AS movil_9, t0.fecha_nacimiento AS fecha_nacimiento_10, t0.activo AS activo_11, t0.reset_password AS reset_password_12, t0.reset_validez AS reset_validez_13, t0.locale AS locale_14, t0.sesion_id AS sesion_id_15, t0.intentos_login AS intentos_login_16, t0.ultimo_login AS ultimo_login_17, t0.instalador_id AS instalador_id_18, t0.rol AS rol_19, t0.notificar AS notificar_20, t0.paquete_id AS paquete_id_21 FROM usuarios t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.paquete AS paquete_2,
  t0.visible AS visible_3,
  t0.activo AS activo_4,
  t0.precio AS precio_5,
  t0.duracion AS duracion_6
FROM
  paquetes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.paquete AS paquete_2, t0.visible AS visible_3, t0.activo AS activo_4, t0.precio AS precio_5, t0.duracion AS duracion_6 FROM paquetes t0 WHERE t0.id = 5;

SELECT
  s0_.id AS id_0,
  s0_.fecha_inicio AS fecha_inicio_1,
  s0_.fecha_fin AS fecha_fin_2,
  s0_.version AS version_3,
  s0_.sid AS sid_4,
  s0_.uuid AS uuid_5,
  s0_.manufacturer AS manufacturer_6,
  s0_.model AS model_7,
  s0_.platform AS platform_8,
  s0_.serial AS serial_9,
  s0_.useragent AS useragent_10,
  s0_.ip AS ip_11,
  s0_.usuario_id AS usuario_id_12
FROM
  sesiones s0_
  INNER JOIN usuarios u1_ ON s0_.usuario_id = u1_.id
WHERE
  u1_.id = ?
ORDER BY
  s0_.id DESC
LIMIT
  10

SELECT s0_.id AS id_0, s0_.fecha_inicio AS fecha_inicio_1, s0_.fecha_fin AS fecha_fin_2, s0_.version AS version_3, s0_.sid AS sid_4, s0_.uuid AS uuid_5, s0_.manufacturer AS manufacturer_6, s0_.model AS model_7, s0_.platform AS platform_8, s0_.serial AS serial_9, s0_.useragent AS useragent_10, s0_.ip AS ip_11, s0_.usuario_id AS usuario_id_12 FROM sesiones s0_ INNER JOIN usuarios u1_ ON s0_.usuario_id = u1_.id WHERE u1_.id = 1 ORDER BY s0_.id DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.codigo AS codigo_2,
  t0.nombre AS nombre_3,
  t0.icono AS icono_4,
  t0.orden AS orden_5
FROM
  plataformas t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.icono AS icono_4, t0.orden AS orden_5 FROM plataformas t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.dias_archivar_invitaciones AS dias_archivar_invitaciones_2,
  t0.enviar_copia_email_invitaciones AS enviar_copia_email_invitaciones_3,
  t0.enviar_email_cerraduras_offline AS enviar_email_cerraduras_offline_4,
  t0.periodicidad_enviar_email_cerraduras_offline AS periodicidad_enviar_email_cerraduras_offline_5,
  t0.fechaenvio_enviar_email_cerraduras_offline AS fechaenvio_enviar_email_cerraduras_offline_6,
  t0.enviar_email_checkins_sin_cubrir AS enviar_email_checkins_sin_cubrir_7,
  t0.enviar_email_checkins_sin_enviar AS enviar_email_checkins_sin_enviar_8,
  t0.enviar_email_resumen_accesos AS enviar_email_resumen_accesos_9,
  t0.periodicidad_email_resumen_accesos AS periodicidad_email_resumen_accesos_10,
  t0.remitente_emails AS remitente_emails_11,
  t0.interno_numero_invitaciones AS interno_numero_invitaciones_12,
  t0.interno_codigo_checkin AS interno_codigo_checkin_13,
  t0.usuario_id AS usuario_id_14
FROM
  usuariosconfiguraciones t0
WHERE
  t0.usuario_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.dias_archivar_invitaciones AS dias_archivar_invitaciones_2, t0.enviar_copia_email_invitaciones AS enviar_copia_email_invitaciones_3, t0.enviar_email_cerraduras_offline AS enviar_email_cerraduras_offline_4, t0.periodicidad_enviar_email_cerraduras_offline AS periodicidad_enviar_email_cerraduras_offline_5, t0.fechaenvio_enviar_email_cerraduras_offline AS fechaenvio_enviar_email_cerraduras_offline_6, t0.enviar_email_checkins_sin_cubrir AS enviar_email_checkins_sin_cubrir_7, t0.enviar_email_checkins_sin_enviar AS enviar_email_checkins_sin_enviar_8, t0.enviar_email_resumen_accesos AS enviar_email_resumen_accesos_9, t0.periodicidad_email_resumen_accesos AS periodicidad_email_resumen_accesos_10, t0.remitente_emails AS remitente_emails_11, t0.interno_numero_invitaciones AS interno_numero_invitaciones_12, t0.interno_codigo_checkin AS interno_codigo_checkin_13, t0.usuario_id AS usuario_id_14 FROM usuariosconfiguraciones t0 WHERE t0.usuario_id = 1 LIMIT 1;