GET https://pregestion.expedicionmedievo.es/registro/agencia

Query Metrics

8 Database Queries
6 Different statements
45.90 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

#▲ Time Info
1 12.49 ms
SELECT t0.id AS id_1, t0.venta_entradas_gratuitas AS venta_entradas_gratuitas_2, t0.dominio_web_gratuita AS dominio_web_gratuita_3, t0.venta_rutas AS venta_rutas_4, t0.venta_souvenirs AS venta_souvenirs_5, t0.contenido_condiciones AS contenido_condiciones_6, t0.contenido_politica AS contenido_politica_7, t0.portal_agencias AS portal_agencias_8, t0.registro_publico_agencias AS registro_publico_agencias_9, t0.combinados_multiples_misma_venta AS combinados_multiples_misma_venta_10, t0.recaptcha_site_key AS recaptcha_site_key_11, t0.recaptcha_secret_key_cifrado AS recaptcha_secret_key_cifrado_12, t0.mostrar_botones_sincronizacion AS mostrar_botones_sincronizacion_13, t0.nombre_plataforma AS nombre_plataforma_14, t0.color_principal AS color_principal_15, t0.ticket_titulo AS ticket_titulo_16, t0.ticket_imprimir_combinado AS ticket_imprimir_combinado_17, t0.ticket_texto_pie1 AS ticket_texto_pie1_18, t0.ticket_texto_pie2 AS ticket_texto_pie2_19, t0.mostrar_boton_granada_card AS mostrar_boton_granada_card_20, t0.enlace_condiciones_generales AS enlace_condiciones_generales_21, t0.enlace_politica_privacidad AS enlace_politica_privacidad_22, t0.iframe_metodo_pago_redsys AS iframe_metodo_pago_redsys_23, t0.iframe_metodo_pago_transferencia AS iframe_metodo_pago_transferencia_24, t0.iframe_metodo_pago_aplazado AS iframe_metodo_pago_aplazado_25, t0.cajas_con_clave AS cajas_con_clave_26, t0.iva AS iva_27, t0.porcentaje_comision_vsc AS porcentaje_comision_vsc_28, t0.iva_comision_vsc AS iva_comision_vsc_29, t0.gastos_gestion_por_entrada AS gastos_gestion_por_entrada_30, t0.master_api_url AS master_api_url_31, t0.sincronizacion_productos_activa AS sincronizacion_productos_activa_32, t0.master_merchant_id_cifrado AS master_merchant_id_cifrado_33, t0.master_api_key_cifrado AS master_api_key_cifrado_34, t0.master_establecimiento_online_id_cifrado AS master_establecimiento_online_id_cifrado_35, t0.prefijo_codigo_master AS prefijo_codigo_master_36, t0.wordpress_merchant_id_cifrado AS wordpress_merchant_id_cifrado_37, t0.wordpress_api_key_cifrado AS wordpress_api_key_cifrado_38, t0.ticketbai_licencia AS ticketbai_licencia_39, t0.ticketbai_desarrollador_nif AS ticketbai_desarrollador_nif_40, t0.ticketbai_software_nombre AS ticketbai_software_nombre_41, t0.ticketbai_software_version AS ticketbai_software_version_42, t0.ticketbai_instancia AS ticketbai_instancia_43, t0.ticketbai_cert_tipo AS ticketbai_cert_tipo_44, t0.ticketbai_cert_fichero AS ticketbai_cert_fichero_45, t0.ticketbai_key_fichero AS ticketbai_key_fichero_46, t0.ticketbai_cert_password_cifrada AS ticketbai_cert_password_cifrada_47, t0.ticketbai_cert_titular AS ticketbai_cert_titular_48, t0.ticketbai_cert_caduca AS ticketbai_cert_caduca_49, t0.establecimiento_gestion_id AS establecimiento_gestion_id_50 FROM configuracion t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
2 1.23 ms
SELECT t0.id AS id_1, t0.venta_entradas_gratuitas AS venta_entradas_gratuitas_2, t0.dominio_web_gratuita AS dominio_web_gratuita_3, t0.venta_rutas AS venta_rutas_4, t0.venta_souvenirs AS venta_souvenirs_5, t0.contenido_condiciones AS contenido_condiciones_6, t0.contenido_politica AS contenido_politica_7, t0.portal_agencias AS portal_agencias_8, t0.registro_publico_agencias AS registro_publico_agencias_9, t0.combinados_multiples_misma_venta AS combinados_multiples_misma_venta_10, t0.recaptcha_site_key AS recaptcha_site_key_11, t0.recaptcha_secret_key_cifrado AS recaptcha_secret_key_cifrado_12, t0.mostrar_botones_sincronizacion AS mostrar_botones_sincronizacion_13, t0.nombre_plataforma AS nombre_plataforma_14, t0.color_principal AS color_principal_15, t0.ticket_titulo AS ticket_titulo_16, t0.ticket_imprimir_combinado AS ticket_imprimir_combinado_17, t0.ticket_texto_pie1 AS ticket_texto_pie1_18, t0.ticket_texto_pie2 AS ticket_texto_pie2_19, t0.mostrar_boton_granada_card AS mostrar_boton_granada_card_20, t0.enlace_condiciones_generales AS enlace_condiciones_generales_21, t0.enlace_politica_privacidad AS enlace_politica_privacidad_22, t0.iframe_metodo_pago_redsys AS iframe_metodo_pago_redsys_23, t0.iframe_metodo_pago_transferencia AS iframe_metodo_pago_transferencia_24, t0.iframe_metodo_pago_aplazado AS iframe_metodo_pago_aplazado_25, t0.cajas_con_clave AS cajas_con_clave_26, t0.iva AS iva_27, t0.porcentaje_comision_vsc AS porcentaje_comision_vsc_28, t0.iva_comision_vsc AS iva_comision_vsc_29, t0.gastos_gestion_por_entrada AS gastos_gestion_por_entrada_30, t0.master_api_url AS master_api_url_31, t0.sincronizacion_productos_activa AS sincronizacion_productos_activa_32, t0.master_merchant_id_cifrado AS master_merchant_id_cifrado_33, t0.master_api_key_cifrado AS master_api_key_cifrado_34, t0.master_establecimiento_online_id_cifrado AS master_establecimiento_online_id_cifrado_35, t0.prefijo_codigo_master AS prefijo_codigo_master_36, t0.wordpress_merchant_id_cifrado AS wordpress_merchant_id_cifrado_37, t0.wordpress_api_key_cifrado AS wordpress_api_key_cifrado_38, t0.ticketbai_licencia AS ticketbai_licencia_39, t0.ticketbai_desarrollador_nif AS ticketbai_desarrollador_nif_40, t0.ticketbai_software_nombre AS ticketbai_software_nombre_41, t0.ticketbai_software_version AS ticketbai_software_version_42, t0.ticketbai_instancia AS ticketbai_instancia_43, t0.ticketbai_cert_tipo AS ticketbai_cert_tipo_44, t0.ticketbai_cert_fichero AS ticketbai_cert_fichero_45, t0.ticketbai_key_fichero AS ticketbai_key_fichero_46, t0.ticketbai_cert_password_cifrada AS ticketbai_cert_password_cifrada_47, t0.ticketbai_cert_titular AS ticketbai_cert_titular_48, t0.ticketbai_cert_caduca AS ticketbai_cert_caduca_49, t0.establecimiento_gestion_id AS establecimiento_gestion_id_50 FROM configuracion t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
3 1.05 ms
SELECT t0.id AS id_1, t0.venta_entradas_gratuitas AS venta_entradas_gratuitas_2, t0.dominio_web_gratuita AS dominio_web_gratuita_3, t0.venta_rutas AS venta_rutas_4, t0.venta_souvenirs AS venta_souvenirs_5, t0.contenido_condiciones AS contenido_condiciones_6, t0.contenido_politica AS contenido_politica_7, t0.portal_agencias AS portal_agencias_8, t0.registro_publico_agencias AS registro_publico_agencias_9, t0.combinados_multiples_misma_venta AS combinados_multiples_misma_venta_10, t0.recaptcha_site_key AS recaptcha_site_key_11, t0.recaptcha_secret_key_cifrado AS recaptcha_secret_key_cifrado_12, t0.mostrar_botones_sincronizacion AS mostrar_botones_sincronizacion_13, t0.nombre_plataforma AS nombre_plataforma_14, t0.color_principal AS color_principal_15, t0.ticket_titulo AS ticket_titulo_16, t0.ticket_imprimir_combinado AS ticket_imprimir_combinado_17, t0.ticket_texto_pie1 AS ticket_texto_pie1_18, t0.ticket_texto_pie2 AS ticket_texto_pie2_19, t0.mostrar_boton_granada_card AS mostrar_boton_granada_card_20, t0.enlace_condiciones_generales AS enlace_condiciones_generales_21, t0.enlace_politica_privacidad AS enlace_politica_privacidad_22, t0.iframe_metodo_pago_redsys AS iframe_metodo_pago_redsys_23, t0.iframe_metodo_pago_transferencia AS iframe_metodo_pago_transferencia_24, t0.iframe_metodo_pago_aplazado AS iframe_metodo_pago_aplazado_25, t0.cajas_con_clave AS cajas_con_clave_26, t0.iva AS iva_27, t0.porcentaje_comision_vsc AS porcentaje_comision_vsc_28, t0.iva_comision_vsc AS iva_comision_vsc_29, t0.gastos_gestion_por_entrada AS gastos_gestion_por_entrada_30, t0.master_api_url AS master_api_url_31, t0.sincronizacion_productos_activa AS sincronizacion_productos_activa_32, t0.master_merchant_id_cifrado AS master_merchant_id_cifrado_33, t0.master_api_key_cifrado AS master_api_key_cifrado_34, t0.master_establecimiento_online_id_cifrado AS master_establecimiento_online_id_cifrado_35, t0.prefijo_codigo_master AS prefijo_codigo_master_36, t0.wordpress_merchant_id_cifrado AS wordpress_merchant_id_cifrado_37, t0.wordpress_api_key_cifrado AS wordpress_api_key_cifrado_38, t0.ticketbai_licencia AS ticketbai_licencia_39, t0.ticketbai_desarrollador_nif AS ticketbai_desarrollador_nif_40, t0.ticketbai_software_nombre AS ticketbai_software_nombre_41, t0.ticketbai_software_version AS ticketbai_software_version_42, t0.ticketbai_instancia AS ticketbai_instancia_43, t0.ticketbai_cert_tipo AS ticketbai_cert_tipo_44, t0.ticketbai_cert_fichero AS ticketbai_cert_fichero_45, t0.ticketbai_key_fichero AS ticketbai_key_fichero_46, t0.ticketbai_cert_password_cifrada AS ticketbai_cert_password_cifrada_47, t0.ticketbai_cert_titular AS ticketbai_cert_titular_48, t0.ticketbai_cert_caduca AS ticketbai_cert_caduca_49, t0.establecimiento_gestion_id AS establecimiento_gestion_id_50 FROM configuracion t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
4 5.87 ms
SELECT COUNT(v0_.id) AS sclr_0 FROM venta v0_ WHERE v0_.estadopedido = 4
Parameters:
[]
5 15.44 ms
SELECT v0_.id AS id_0, v0_.tipo AS tipo_1, v0_.fecha_inicio AS fecha_inicio_2, v0_.fecha_fin AS fecha_fin_3, v0_.estado AS estado_4, v0_.fecha_aprobacion AS fecha_aprobacion_5, v0_.motivo_aprobado_rechazado AS motivo_aprobado_rechazado_6, v0_.motivo AS motivo_7, v0_.fecha_solicitud AS fecha_solicitud_8, v0_.created_at AS created_at_9, v0_.updated_at AS updated_at_10, v0_.deleted_at AS deleted_at_11, v0_.empleado_id AS empleado_id_12, v0_.aprobado_por_id AS aprobado_por_id_13 FROM vacaciones v0_ INNER JOIN "user" u1_ ON v0_.empleado_id = u1_.id AND u1_.dtype IN ('user', 'agencia', 'trabajador', 'superadmin', 'cliente') WHERE v0_.estado = ? AND u1_.deleted_at IS NULL AND u1_.dtype IN ('trabajador') AND v0_.deleted_at IS NULL ORDER BY v0_.fecha_solicitud ASC
Parameters:
[
  0
]
6 5.10 ms
SELECT t0.id AS id_1, t0.nameuser AS nameuser_2, t0.username AS username_3, t0.password AS password_4, t0.salt AS salt_5, t0.deleted_at AS deleted_at_6, t0.jsonpassword AS jsonpassword_7, t0.create_at AS create_at_8, t0.update_at AS update_at_9, t0.idventa AS idventa_10, t0.fecha_inicio AS fecha_inicio_11, t0.jsonip AS jsonip_12, t0.monitorizar AS monitorizar_13, t0.email AS email_14, t0.establecimiento_id AS establecimiento_id_15, t0.entidad_id AS entidad_id_16, t0.caja_id AS caja_id_17, t0.dtype, t0.razon_social AS razon_social_18, t0.cif AS cif_19, t0.direccion AS direccion_20, t0.localidad AS localidad_21, t0.agencia_provincia AS agencia_provincia_22, t0.agencia_cp AS agencia_cp_23, t0.agencia_email AS agencia_email_24, t0.telefono AS telefono_25, t0.puede_exportar AS puede_exportar_26, t0.numero_maximo_entradas AS numero_maximo_entradas_27, t0.solo_combinado_total AS solo_combinado_total_28, t0.puede_comprar_tarifas_gratuitas_solas AS puede_comprar_tarifas_gratuitas_solas_29, t0.puede_comprar_sesiones_privadas AS puede_comprar_sesiones_privadas_30, t0.aplazado_auto_validado AS aplazado_auto_validado_31, t0.emite_factura AS emite_factura_32, t0.solo_tarifas_agencia AS solo_tarifas_agencia_33, t0.token_confirmacion AS token_confirmacion_34, t0.validada AS validada_35, t0.datos_facturacion_confirmados AS datos_facturacion_confirmados_36, t0.formas_pago_permitidas AS formas_pago_permitidas_37, t0.segundos_anuales AS segundos_anuales_38, t0.dias_vacaciones AS dias_vacaciones_39, t0.control_horario AS control_horario_40, t0.puede_aprobar_tiempo AS puede_aprobar_tiempo_41, t0.horas AS horas_42, t0.color AS color_43, t0.tipo_contrato_id AS tipo_contrato_id_44, t0.apellido1 AS apellido1_45, t0.apellido2 AS apellido2_46, t0.dni AS dni_47, t0.telefono AS telefono_48, t0.direccion AS direccion_49, t0.cp AS cp_50, t0.localidad_cliente AS localidad_cliente_51, t0.provincia_cliente AS provincia_cliente_52, t0.aceptapubli AS aceptapubli_53, t0.md5 AS md5_54, t0.pais_id AS pais_id_55 FROM "user" t0 WHERE t0.id = ? AND t0.dtype IN ('user', 'agencia', 'trabajador', 'superadmin', 'cliente')
Parameters:
[
  6
]
7 1.29 ms
SELECT u0_.id AS id_0, u0_.nameuser AS nameuser_1, u0_.username AS username_2, u0_.password AS password_3, u0_.salt AS salt_4, u0_.deleted_at AS deleted_at_5, u0_.jsonpassword AS jsonpassword_6, u0_.create_at AS create_at_7, u0_.update_at AS update_at_8, u0_.idventa AS idventa_9, u0_.fecha_inicio AS fecha_inicio_10, u0_.jsonip AS jsonip_11, u0_.monitorizar AS monitorizar_12, u0_.email AS email_13, u0_.razon_social AS razon_social_14, u0_.cif AS cif_15, u0_.direccion AS direccion_16, u0_.localidad AS localidad_17, u0_.agencia_provincia AS agencia_provincia_18, u0_.agencia_cp AS agencia_cp_19, u0_.agencia_email AS agencia_email_20, u0_.telefono AS telefono_21, u0_.puede_exportar AS puede_exportar_22, u0_.numero_maximo_entradas AS numero_maximo_entradas_23, u0_.solo_combinado_total AS solo_combinado_total_24, u0_.puede_comprar_tarifas_gratuitas_solas AS puede_comprar_tarifas_gratuitas_solas_25, u0_.puede_comprar_sesiones_privadas AS puede_comprar_sesiones_privadas_26, u0_.aplazado_auto_validado AS aplazado_auto_validado_27, u0_.emite_factura AS emite_factura_28, u0_.solo_tarifas_agencia AS solo_tarifas_agencia_29, u0_.token_confirmacion AS token_confirmacion_30, u0_.validada AS validada_31, u0_.datos_facturacion_confirmados AS datos_facturacion_confirmados_32, u0_.formas_pago_permitidas AS formas_pago_permitidas_33, u0_.dtype AS dtype_34, u0_.establecimiento_id AS establecimiento_id_35, u0_.entidad_id AS entidad_id_36, u0_.caja_id AS caja_id_37 FROM "user" u0_ WHERE (u0_.validada = false AND u0_.deleted_at IS NULL) AND u0_.dtype IN ('agencia') ORDER BY u0_.create_at DESC
Parameters:
[]
8 3.43 ms
SELECT COUNT(v0_.id) AS sclr_0 FROM venta v0_ WHERE (v0_.estadopedido = 2 OR v0_.estadopedido IS NULL) AND (v0_.eliminado = false OR v0_.eliminado IS NULL) AND (v0_.anulada = false OR v0_.anulada IS NULL) AND (v0_.totalprecio >= 0 OR v0_.totalprecio IS NULL) AND v0_.error_sincronizacion_master IS NOT NULL
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Establecimiento 2
App\Entity\Configuracion 1
App\Entity\Vacaciones 1
App\Entity\User 1
App\Entity\Entidad 1

Entities Mapping