0.94 ms
(100.00%)
|
1 |
SELECT e0_.id AS id_0, e0_.cif_nif AS cif_nif_1, e0_.nombre AS nombre_2, e0_.persona_contacto AS persona_contacto_3, e0_.telefono AS telefono_4, e0_.email AS email_5, e0_.localidad AS localidad_6, e0_.direccion AS direccion_7, e0_.codigo_postal AS codigo_postal_8, e0_.pais AS pais_9, e0_.nombre_fiscal AS nombre_fiscal_10, e0_.direccion_fiscal AS direccion_fiscal_11, e0_.localidad_fiscal AS localidad_fiscal_12, e0_.codigo_postal_fiscal AS codigo_postal_fiscal_13, e0_.provincia_fiscal AS provincia_fiscal_14, e0_.pais_fiscal AS pais_fiscal_15, e0_.smtp_host AS smtp_host_16, e0_.smtp_port AS smtp_port_17, e0_.smtp_seguridad AS smtp_seguridad_18, e0_.smtp_email AS smtp_email_19, e0_.smtp_contrasena AS smtp_contrasena_20, e0_.path_logo AS path_logo_21, e0_.path_facturas AS path_facturas_22, e0_.color_principal AS color_principal_23, e0_.color_secundario AS color_secundario_24, e0_.deleted_at AS deleted_at_25, e0_.observaciones AS observaciones_26, e0_.estado_redsys AS estado_redsys_27, e0_.clave_produccion_redsys AS clave_produccion_redsys_28, e0_.clave_desarrollo_redsys AS clave_desarrollo_redsys_29, e0_.terminal_redsys AS terminal_redsys_30, e0_.lenguaje_redsys AS lenguaje_redsys_31, e0_.moneda_redsys AS moneda_redsys_32, e0_.fuc_redsys AS fuc_redsys_33, e0_.version_redsys AS version_redsys_34, e0_.dominio AS dominio_35, e0_.subdominio AS subdominio_36, e0_.favicon AS favicon_37, e0_.estado_bizum_redsys AS estado_bizum_redsys_38, e0_.estado_transferencia_bancaria AS estado_transferencia_bancaria_39, e0_.descripcion_transferencia AS descripcion_transferencia_40, e0_.descripcion_transferencia_gracias AS descripcion_transferencia_gracias_41, e0_.desistir_matricula_gracias AS desistir_matricula_gracias_42, e0_.iban_transferencia AS iban_transferencia_43, e0_.color_tres AS color_tres_44, e0_.color_cuatro AS color_cuatro_45, e0_.color_cinco AS color_cinco_46, e0_.campo_donde_te_has_preparado AS campo_donde_te_has_preparado_47, e0_.panel_info_matriculacion_simple AS panel_info_matriculacion_simple_48, e0_.dias_margen_matriculacion AS dias_margen_matriculacion_49, e0_.matriculacion_activa AS matriculacion_activa_50, e0_.mostrar_poblacion_iframe_pasos AS mostrar_poblacion_iframe_pasos_51, e0_.fecha_speaking AS fecha_speaking_52, e0_.fondo_login AS fondo_login_53, e0_.ver_pasos_iframe AS ver_pasos_iframe_54, e0_.preguntas_matriculacion AS preguntas_matriculacion_55, e0_.plazas_convocatoria_centros AS plazas_convocatoria_centros_56, e0_.importacion_convocatorias_cambridge AS importacion_convocatorias_cambridge_57, e0_.idioma AS idioma_58, e0_.importe_envio AS importe_envio_59, e0_.pie_email AS pie_email_60, e0_.configuracion_alias AS configuracion_alias_61, e0_.texto_factura2 AS texto_factura2_62, e0_.registro_mercantil AS registro_mercantil_63, e0_.plantilla_factura_pdf AS plantilla_factura_pdf_64, e0_.texto_envio_certificados AS texto_envio_certificados_65, e0_.clonar_convocatorias_plazas_agotadas AS clonar_convocatorias_plazas_agotadas_66, e0_.activar_rol_profesor_convocatoria AS activar_rol_profesor_convocatoria_67, e0_.numero_emails_por_envio AS numero_emails_por_envio_68, e0_.fechas_visibles_matriculacion_por_pasos AS fechas_visibles_matriculacion_por_pasos_69, e0_.color_seis AS color_seis_70, e0_.color_siete AS color_siete_71, e0_.color_ocho AS color_ocho_72, e0_.color_nueve AS color_nueve_73, e0_.color_diez AS color_diez_74, e0_.email_recordatorio_pago AS email_recordatorio_pago_75, e0_.email_recordatorio_examen AS email_recordatorio_examen_76, e0_.pedir_profesor_centro_matriculacion AS pedir_profesor_centro_matriculacion_77, e0_.activar_descuento_xcertificado AS activar_descuento_xcertificado_78, e0_.mostrar_importe_envio_pregunta AS mostrar_importe_envio_pregunta_79, e0_.descripcion_factura_linea_personalizada AS descripcion_factura_linea_personalizada_80, e0_.mostrar_enlaces_matriculacion_centros AS mostrar_enlaces_matriculacion_centros_81, e0_.titulo_certificacion_matriculacion_por_pasos AS titulo_certificacion_matriculacion_por_pasos_82, e0_.color_fondo_logo_menu AS color_fondo_logo_menu_83, e0_.info_matriculados_esta_semana_home AS info_matriculados_esta_semana_home_84, e0_.pago_redireccion_matriculacion_por_pasos AS pago_redireccion_matriculacion_por_pasos_85, e0_.porcentaje_devolucion_candidato AS porcentaje_devolucion_candidato_86, e0_.texto_login AS texto_login_87, e0_.tipo_editor AS tipo_editor_88, e0_.clave_tiny AS clave_tiny_89, e0_.tamano_letra AS tamano_letra_90, e0_.mostrar_logo_matriculacion AS mostrar_logo_matriculacion_91, e0_.scroll_matriculacion AS scroll_matriculacion_92, e0_.dias_para_marcar_en_rojo_convocatoria AS dias_para_marcar_en_rojo_convocatoria_93, e0_.tipo_representacion_publica_late_entry AS tipo_representacion_publica_late_entry_94, e0_.country_code AS country_code_95, e0_.activar_api AS activar_api_96, e0_.dias_filtro_convocatorias AS dias_filtro_convocatorias_97, e0_.aplicar_descuento_late_entry AS aplicar_descuento_late_entry_98, e0_.estado_facturacion AS estado_facturacion_99, e0_.texto_necesidades AS texto_necesidades_100, e0_.numero_dias_mandar_historial AS numero_dias_mandar_historial_101, e0_.genero_activo AS genero_activo_102, e0_.nacionalidad_activa AS nacionalidad_activa_103 FROM empresa e0_ WHERE (e0_.dominio LIKE '%examenes-englishinaction.winecta.com%' OR e0_.subdominio LIKE '%examenes-englishinaction.winecta.com%') AND e0_.deleted_at IS NULL LIMIT 1
SELECT
e0_.id AS id_0,
e0_.cif_nif AS cif_nif_1,
e0_.nombre AS nombre_2,
e0_.persona_contacto AS persona_contacto_3,
e0_.telefono AS telefono_4,
e0_.email AS email_5,
e0_.localidad AS localidad_6,
e0_.direccion AS direccion_7,
e0_.codigo_postal AS codigo_postal_8,
e0_.pais AS pais_9,
e0_.nombre_fiscal AS nombre_fiscal_10,
e0_.direccion_fiscal AS direccion_fiscal_11,
e0_.localidad_fiscal AS localidad_fiscal_12,
e0_.codigo_postal_fiscal AS codigo_postal_fiscal_13,
e0_.provincia_fiscal AS provincia_fiscal_14,
e0_.pais_fiscal AS pais_fiscal_15,
e0_.smtp_host AS smtp_host_16,
e0_.smtp_port AS smtp_port_17,
e0_.smtp_seguridad AS smtp_seguridad_18,
e0_.smtp_email AS smtp_email_19,
e0_.smtp_contrasena AS smtp_contrasena_20,
e0_.path_logo AS path_logo_21,
e0_.path_facturas AS path_facturas_22,
e0_.color_principal AS color_principal_23,
e0_.color_secundario AS color_secundario_24,
e0_.deleted_at AS deleted_at_25,
e0_.observaciones AS observaciones_26,
e0_.estado_redsys AS estado_redsys_27,
e0_.clave_produccion_redsys AS clave_produccion_redsys_28,
e0_.clave_desarrollo_redsys AS clave_desarrollo_redsys_29,
e0_.terminal_redsys AS terminal_redsys_30,
e0_.lenguaje_redsys AS lenguaje_redsys_31,
e0_.moneda_redsys AS moneda_redsys_32,
e0_.fuc_redsys AS fuc_redsys_33,
e0_.version_redsys AS version_redsys_34,
e0_.dominio AS dominio_35,
e0_.subdominio AS subdominio_36,
e0_.favicon AS favicon_37,
e0_.estado_bizum_redsys AS estado_bizum_redsys_38,
e0_.estado_transferencia_bancaria AS estado_transferencia_bancaria_39,
e0_.descripcion_transferencia AS descripcion_transferencia_40,
e0_.descripcion_transferencia_gracias AS descripcion_transferencia_gracias_41,
e0_.desistir_matricula_gracias AS desistir_matricula_gracias_42,
e0_.iban_transferencia AS iban_transferencia_43,
e0_.color_tres AS color_tres_44,
e0_.color_cuatro AS color_cuatro_45,
e0_.color_cinco AS color_cinco_46,
e0_.campo_donde_te_has_preparado AS campo_donde_te_has_preparado_47,
e0_.panel_info_matriculacion_simple AS panel_info_matriculacion_simple_48,
e0_.dias_margen_matriculacion AS dias_margen_matriculacion_49,
e0_.matriculacion_activa AS matriculacion_activa_50,
e0_.mostrar_poblacion_iframe_pasos AS mostrar_poblacion_iframe_pasos_51,
e0_.fecha_speaking AS fecha_speaking_52,
e0_.fondo_login AS fondo_login_53,
e0_.ver_pasos_iframe AS ver_pasos_iframe_54,
e0_.preguntas_matriculacion AS preguntas_matriculacion_55,
e0_.plazas_convocatoria_centros AS plazas_convocatoria_centros_56,
e0_.importacion_convocatorias_cambridge AS importacion_convocatorias_cambridge_57,
e0_.idioma AS idioma_58,
e0_.importe_envio AS importe_envio_59,
e0_.pie_email AS pie_email_60,
e0_.configuracion_alias AS configuracion_alias_61,
e0_.texto_factura2 AS texto_factura2_62,
e0_.registro_mercantil AS registro_mercantil_63,
e0_.plantilla_factura_pdf AS plantilla_factura_pdf_64,
e0_.texto_envio_certificados AS texto_envio_certificados_65,
e0_.clonar_convocatorias_plazas_agotadas AS clonar_convocatorias_plazas_agotadas_66,
e0_.activar_rol_profesor_convocatoria AS activar_rol_profesor_convocatoria_67,
e0_.numero_emails_por_envio AS numero_emails_por_envio_68,
e0_.fechas_visibles_matriculacion_por_pasos AS fechas_visibles_matriculacion_por_pasos_69,
e0_.color_seis AS color_seis_70,
e0_.color_siete AS color_siete_71,
e0_.color_ocho AS color_ocho_72,
e0_.color_nueve AS color_nueve_73,
e0_.color_diez AS color_diez_74,
e0_.email_recordatorio_pago AS email_recordatorio_pago_75,
e0_.email_recordatorio_examen AS email_recordatorio_examen_76,
e0_.pedir_profesor_centro_matriculacion AS pedir_profesor_centro_matriculacion_77,
e0_.activar_descuento_xcertificado AS activar_descuento_xcertificado_78,
e0_.mostrar_importe_envio_pregunta AS mostrar_importe_envio_pregunta_79,
e0_.descripcion_factura_linea_personalizada AS descripcion_factura_linea_personalizada_80,
e0_.mostrar_enlaces_matriculacion_centros AS mostrar_enlaces_matriculacion_centros_81,
e0_.titulo_certificacion_matriculacion_por_pasos AS titulo_certificacion_matriculacion_por_pasos_82,
e0_.color_fondo_logo_menu AS color_fondo_logo_menu_83,
e0_.info_matriculados_esta_semana_home AS info_matriculados_esta_semana_home_84,
e0_.pago_redireccion_matriculacion_por_pasos AS pago_redireccion_matriculacion_por_pasos_85,
e0_.porcentaje_devolucion_candidato AS porcentaje_devolucion_candidato_86,
e0_.texto_login AS texto_login_87,
e0_.tipo_editor AS tipo_editor_88,
e0_.clave_tiny AS clave_tiny_89,
e0_.tamano_letra AS tamano_letra_90,
e0_.mostrar_logo_matriculacion AS mostrar_logo_matriculacion_91,
e0_.scroll_matriculacion AS scroll_matriculacion_92,
e0_.dias_para_marcar_en_rojo_convocatoria AS dias_para_marcar_en_rojo_convocatoria_93,
e0_.tipo_representacion_publica_late_entry AS tipo_representacion_publica_late_entry_94,
e0_.country_code AS country_code_95,
e0_.activar_api AS activar_api_96,
e0_.dias_filtro_convocatorias AS dias_filtro_convocatorias_97,
e0_.aplicar_descuento_late_entry AS aplicar_descuento_late_entry_98,
e0_.estado_facturacion AS estado_facturacion_99,
e0_.texto_necesidades AS texto_necesidades_100,
e0_.numero_dias_mandar_historial AS numero_dias_mandar_historial_101,
e0_.genero_activo AS genero_activo_102,
e0_.nacionalidad_activa AS nacionalidad_activa_103
FROM
empresa e0_
WHERE
(
e0_.dominio LIKE '%examenes-englishinaction.winecta.com%'
OR e0_.subdominio LIKE '%examenes-englishinaction.winecta.com%'
)
AND e0_.deleted_at IS NULL
LIMIT
1
SELECT e0_.id AS id_0, e0_.cif_nif AS cif_nif_1, e0_.nombre AS nombre_2, e0_.persona_contacto AS persona_contacto_3, e0_.telefono AS telefono_4, e0_.email AS email_5, e0_.localidad AS localidad_6, e0_.direccion AS direccion_7, e0_.codigo_postal AS codigo_postal_8, e0_.pais AS pais_9, e0_.nombre_fiscal AS nombre_fiscal_10, e0_.direccion_fiscal AS direccion_fiscal_11, e0_.localidad_fiscal AS localidad_fiscal_12, e0_.codigo_postal_fiscal AS codigo_postal_fiscal_13, e0_.provincia_fiscal AS provincia_fiscal_14, e0_.pais_fiscal AS pais_fiscal_15, e0_.smtp_host AS smtp_host_16, e0_.smtp_port AS smtp_port_17, e0_.smtp_seguridad AS smtp_seguridad_18, e0_.smtp_email AS smtp_email_19, e0_.smtp_contrasena AS smtp_contrasena_20, e0_.path_logo AS path_logo_21, e0_.path_facturas AS path_facturas_22, e0_.color_principal AS color_principal_23, e0_.color_secundario AS color_secundario_24, e0_.deleted_at AS deleted_at_25, e0_.observaciones AS observaciones_26, e0_.estado_redsys AS estado_redsys_27, e0_.clave_produccion_redsys AS clave_produccion_redsys_28, e0_.clave_desarrollo_redsys AS clave_desarrollo_redsys_29, e0_.terminal_redsys AS terminal_redsys_30, e0_.lenguaje_redsys AS lenguaje_redsys_31, e0_.moneda_redsys AS moneda_redsys_32, e0_.fuc_redsys AS fuc_redsys_33, e0_.version_redsys AS version_redsys_34, e0_.dominio AS dominio_35, e0_.subdominio AS subdominio_36, e0_.favicon AS favicon_37, e0_.estado_bizum_redsys AS estado_bizum_redsys_38, e0_.estado_transferencia_bancaria AS estado_transferencia_bancaria_39, e0_.descripcion_transferencia AS descripcion_transferencia_40, e0_.descripcion_transferencia_gracias AS descripcion_transferencia_gracias_41, e0_.desistir_matricula_gracias AS desistir_matricula_gracias_42, e0_.iban_transferencia AS iban_transferencia_43, e0_.color_tres AS color_tres_44, e0_.color_cuatro AS color_cuatro_45, e0_.color_cinco AS color_cinco_46, e0_.campo_donde_te_has_preparado AS campo_donde_te_has_preparado_47, e0_.panel_info_matriculacion_simple AS panel_info_matriculacion_simple_48, e0_.dias_margen_matriculacion AS dias_margen_matriculacion_49, e0_.matriculacion_activa AS matriculacion_activa_50, e0_.mostrar_poblacion_iframe_pasos AS mostrar_poblacion_iframe_pasos_51, e0_.fecha_speaking AS fecha_speaking_52, e0_.fondo_login AS fondo_login_53, e0_.ver_pasos_iframe AS ver_pasos_iframe_54, e0_.preguntas_matriculacion AS preguntas_matriculacion_55, e0_.plazas_convocatoria_centros AS plazas_convocatoria_centros_56, e0_.importacion_convocatorias_cambridge AS importacion_convocatorias_cambridge_57, e0_.idioma AS idioma_58, e0_.importe_envio AS importe_envio_59, e0_.pie_email AS pie_email_60, e0_.configuracion_alias AS configuracion_alias_61, e0_.texto_factura2 AS texto_factura2_62, e0_.registro_mercantil AS registro_mercantil_63, e0_.plantilla_factura_pdf AS plantilla_factura_pdf_64, e0_.texto_envio_certificados AS texto_envio_certificados_65, e0_.clonar_convocatorias_plazas_agotadas AS clonar_convocatorias_plazas_agotadas_66, e0_.activar_rol_profesor_convocatoria AS activar_rol_profesor_convocatoria_67, e0_.numero_emails_por_envio AS numero_emails_por_envio_68, e0_.fechas_visibles_matriculacion_por_pasos AS fechas_visibles_matriculacion_por_pasos_69, e0_.color_seis AS color_seis_70, e0_.color_siete AS color_siete_71, e0_.color_ocho AS color_ocho_72, e0_.color_nueve AS color_nueve_73, e0_.color_diez AS color_diez_74, e0_.email_recordatorio_pago AS email_recordatorio_pago_75, e0_.email_recordatorio_examen AS email_recordatorio_examen_76, e0_.pedir_profesor_centro_matriculacion AS pedir_profesor_centro_matriculacion_77, e0_.activar_descuento_xcertificado AS activar_descuento_xcertificado_78, e0_.mostrar_importe_envio_pregunta AS mostrar_importe_envio_pregunta_79, e0_.descripcion_factura_linea_personalizada AS descripcion_factura_linea_personalizada_80, e0_.mostrar_enlaces_matriculacion_centros AS mostrar_enlaces_matriculacion_centros_81, e0_.titulo_certificacion_matriculacion_por_pasos AS titulo_certificacion_matriculacion_por_pasos_82, e0_.color_fondo_logo_menu AS color_fondo_logo_menu_83, e0_.info_matriculados_esta_semana_home AS info_matriculados_esta_semana_home_84, e0_.pago_redireccion_matriculacion_por_pasos AS pago_redireccion_matriculacion_por_pasos_85, e0_.porcentaje_devolucion_candidato AS porcentaje_devolucion_candidato_86, e0_.texto_login AS texto_login_87, e0_.tipo_editor AS tipo_editor_88, e0_.clave_tiny AS clave_tiny_89, e0_.tamano_letra AS tamano_letra_90, e0_.mostrar_logo_matriculacion AS mostrar_logo_matriculacion_91, e0_.scroll_matriculacion AS scroll_matriculacion_92, e0_.dias_para_marcar_en_rojo_convocatoria AS dias_para_marcar_en_rojo_convocatoria_93, e0_.tipo_representacion_publica_late_entry AS tipo_representacion_publica_late_entry_94, e0_.country_code AS country_code_95, e0_.activar_api AS activar_api_96, e0_.dias_filtro_convocatorias AS dias_filtro_convocatorias_97, e0_.aplicar_descuento_late_entry AS aplicar_descuento_late_entry_98, e0_.estado_facturacion AS estado_facturacion_99, e0_.texto_necesidades AS texto_necesidades_100, e0_.numero_dias_mandar_historial AS numero_dias_mandar_historial_101, e0_.genero_activo AS genero_activo_102, e0_.nacionalidad_activa AS nacionalidad_activa_103 FROM empresa e0_ WHERE (e0_.dominio LIKE '%examenes-englishinaction.winecta.com%' OR e0_.subdominio LIKE '%examenes-englishinaction.winecta.com%') AND e0_.deleted_at IS NULL LIMIT 1;
|
