| #1 | debug | SELECT * FROM `roles_users` WHERE `codrole` IS NULL | |
| #2 | debug | SELECT * FROM `roles_users` WHERE `codrole` IS NULL | 0.2ms |
| #3 | debug | SELECT * FROM `roles_users` WHERE `codrole` IS NULL | |
| #4 | debug | SELECT * FROM `roles_users` WHERE `codrole` IS NULL | 2.8ms |
| #5 | debug | SELECT * FROM `roles_users` WHERE `codrole` IS NULL | |
| #6 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'AiScan' LIMIT 1 OFFSET 0; | |
| #7 | debug | Begin Transaction | |
| #8 | debug | UPDATE `settings` SET `name` = 'AiScan', `properties` = '{\"enabled\":\"1\",\"default_provider\":\"gemini\",\"max_upload_size_mb\":\"10\",\"allowed_extensions\":\"pdf,jpg,jpeg,png,webp\",\"auto_scan\":\"0\",\"debug_mode\":\"\",\"max_parallel_requests\":\"5\",\"request_timeout\":\"120\",\"openai_model\":\"gpt-5-nano\",\"openai_base_url\":\"https://api.openai.com/v1\",\"gemini_model\":\"gemini-2.5-flash-lite\",\"mistral_model\":\"mistral-small-latest\",\"openai_api_key\":\"\",\"gemini_api_key\":\"AIzaSyD23-9gvfoWJRXV8zJqzpeMvTCPtcP0_R8\",\"mistral_api_key\":\"\",\"custom_api_key\":\"\",\"custom_model\":\"\",\"custom_base_url\":\"\",\"additional_prompt\":\"\"}' WHERE `name` = 'AiScan' | |
| #9 | debug | Commit Transaction | |
| #10 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'backup' LIMIT 1 OFFSET 0; | |
| #11 | debug | UPDATE `settings` SET `name` = 'backup', `properties` = '{\"frequency\":\"1 week\",\"weekly_day\":1,\"monthly_day\":1,\"hour\":3}' WHERE `name` = 'backup' | |
| #12 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'default' LIMIT 1 OFFSET 0; | |
| #13 | debug | UPDATE `settings` SET `name` = 'default', `properties` = '{\"codpais\":\"ESP\",\"currency_position\":\"right\",\"item_limit\":\"50\",\"decimals\":\"2\",\"decimal_separator\":\",\",\"thousands_separator\":\" \",\"tipoidfiscal\":\"NIF\",\"codalmacen\":\"ALG\",\"idempresa\":\"1\",\"coddivisa\":\"EUR\",\"codimpuesto\":\"IVA21\",\"codpago\":\"CONT\",\"codserie\":\"A\",\"codserierec\":\"R\",\"updatesupplierprices\":\"1\",\"validate_iban\":\"1\",\"homepage\":\"Dashboard\",\"costpricepolicy\":\"last-price\",\"ventasinstock\":\"\",\"site_url\":\"https://test25.viviendasanaservicios.es\",\"codretencion\":null,\"finofertadays\":\"0\",\"codrole\":\"employee\",\"telemetryinstall\":23463,\"telemetrylastu\":1782279936,\"telemetrykey\":\"fmfu62aVYtduZG18TrxU\",\"enableupdatesbeta\":\"\",\"comissionposition\":\"modal\",\"columnetosubtotal\":\"subtotal\",\"levelcostsales\":\"0\",\"levelbenefitsales\":\"0\",\"idloginimage\":0,\"tablesize\":\"big\",\"days_log_retention\":\"1\",\"enable_api\":\"\"}' WHERE `name` = 'default' | |
| #14 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'email' LIMIT 1 OFFSET 0; | |
| #15 | debug | UPDATE `settings` SET `name` = 'email', `properties` = '{\"enc\":\"ssl\",\"host\":\"smtp.gmail.com\",\"mailer\":\"smtp\",\"port\":\"465\",\"email\":null}' WHERE `name` = 'email' | |
| #16 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'gestoranticipos' LIMIT 1 OFFSET 0; | |
| #17 | debug | UPDATE `settings` SET `name` = 'gestoranticipos', `properties` = '{\"productoanticipo\":\"ANTICIPO\",\"observacionesanticipo\":\"Factura de anticipo correspondiente al [PORCENTAJE] del total del contrato.\",\"serieanticipo\":\"A\",\"recuperar_estado_defecto\":true,\"estadoanticipoven\":\"\",\"estadoanticipocom\":\"\",\"avisoanticipo100\":\"<strong>¡Atención! Anticipo del 100%:</strong> Se generará una factura detallada con todas las líneas de producto. El documento actual no marcará sus líneas como servidas para mantener el ciclo logístico abierto (Albaranes), pero su total quedará contablemente a cero mediante una línea de compensación.\",\"avisoanticipoerror\":\"<strong>¡Error!</strong> El importe del anticipo no puede superar el total pendiente del documento. Por favor, reduzca el importe para continuar.\",\"desc_doc_origen\":\"Compensación de anticipo recibido s/ Factura [CODIGO_FACTURA] pagado mediante [FORMA_PAGO]\",\"desc_factura_anticipo\":\"Anticipo s/ [TIPO_DOC] [CODIGO_ORIGEN] pagado mediante [FORMA_PAGO]\"}' WHERE `name` = 'gestoranticipos' | |
| #18 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'loginscreen' LIMIT 1 OFFSET 0; | |
| #19 | debug | UPDATE `settings` SET `name` = 'loginscreen', `properties` = '{\"login_primary_color\":\"#0424AA\",\"login_background_id\":0,\"login_image_id\":0,\"login_footer_content\":null,\"login_secondary_color\":\"#111C2A\"}' WHERE `name` = 'loginscreen' | |
| #20 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'notificaciones' LIMIT 1 OFFSET 0; | |
| #21 | debug | UPDATE `settings` SET `name` = 'notificaciones', `properties` = '{\"load_notifications_minutes\":3,\"load_chat_seconds\":60,\"sound_notifications\":false,\"update_notices\":true,\"group_sales_estimation\":null,\"group_sales_order\":null,\"group_sales_receipt\":null,\"group_remesas_sepa\":null,\"group_stock\":null,\"group_customer\":null}' WHERE `name` = 'notificaciones' | |
| #22 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'plantillaspdf' LIMIT 1 OFFSET 0; | 0.7ms |
| #23 | debug | UPDATE `settings` SET `name` = 'plantillaspdf', `properties` = '{\"bottommargin\":\"20\",\"color1\":\"#2770CA\",\"color2\":\"#FFFFFF\",\"color3\":\"#F1F1F1\",\"endalign\":\"justify\",\"endfontsize\":\"10\",\"endtext\":\"Prueba de como quedaria el texto si se añade una linea para por ejemplo meter el RGPD\",\"font\":\"DejaVuSans\",\"fontcolor\":\"#000000\",\"fontsize\":\"12\",\"footeralign\":\"center\",\"footerfontsize\":\"10\",\"footertext\":\"{PAGENO} / {nbpg}\",\"linecols\":\"descripcion,cantidad,pvpunitario,dtopor,pvptotal,iva,recargo,irpf\",\"linecolalignments\":\"left,right,right,right,right,right,right,right\",\"linecoltypes\":\"text,number2,number,percentage,number,percentage1,percentage1,percentage1\",\"linesheight\":\"400\",\"logoalign\":\"right\",\"logosize\":\"100\",\"orientation\":\"portrait\",\"password\":\"\",\"productimageheight\":\"50\",\"productimagewidth\":\"50\",\"qrbgcolor\":\"#FFFFFF\",\"qrcolor\":\"#000000\",\"qrsize\":80,\"qrtransparent\":1,\"size\":\"A4\",\"thankstext\":\"\",\"thankstitle\":\"\",\"template\":\"TemplateRetencionGarantia\",\"titlefontsize\":\"18\",\"topmargin\":\"50\",\"idlogo\":null,\"showcustomercode\":\"\",\"showcustomerphones\":\"\",\"showcustomeremail\":\"\",\"shownumero2\":\"\",\"shownumproveedor\":\"\",\"showpaymentdate\":\"\",\"showagent\":\"\",\"showinvoicesketch\":\"\",\"show_parent_documents\":\"\",\"hideshipping\":\"\",\"hidenumberinvoice\":\"\",\"hideserieinvoice\":\"\",\"hideobservations\":\"\",\"hidepaymentmethods\":\"\",\"hidereceipts\":\"\",\"hideexpirationpayment\":\"\",\"print_attachment_document\":\"\",\"idimagetext\":null,\"imagetextsize\":\"0\",\"idimagefooter\":null,\"imagefootersize\":\"0\"}' WHERE `name` = 'plantillaspdf' | |
| #24 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'proyectos' LIMIT 1 OFFSET 0; | |
| #25 | debug | UPDATE `settings` SET `name` = 'proyectos', `properties` = '{\"patron\":\"{ANYO}-{MES}{0NUM}\",\"longnumero\":\"3\",\"stock\":\"\",\"burnstock\":\"\",\"reiniciar_patron_anualmente\":\"\",\"reiniciar_patron_mensualmente\":\"1\",\"usar_serie_numerada\":\"1\",\"inicio_numero\":\"11\"}' WHERE `name` = 'proyectos' | |
| #26 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'richitheme' LIMIT 1 OFFSET 0; | |
| #27 | debug | UPDATE `settings` SET `name` = 'richitheme', `properties` = '{\"lbgcolor\":\"#f7f7f7\",\"fbgcolor\":\"#ffffff\",\"lbtncolor\":\"#2770ca\",\"lfoodis\":0,\"lrpdis\":0,\"sbgcolor\":\"#f7f7f7\",\"subbgcolor\":\"#ffffff\",\"itembgcolor\":\"#edf5fc\",\"accentcolor\":\"#000000\",\"lsfile\":\"0\",\"tbgcolor\":\"#ffffffb3\",\"tcndis\":0,\"stxtcolor\":\"#444b52\",\"ttxtcolor\":\"#1a1f36\",\"itxtcolor\":\"#6c757d\",\"uigradient\":\"#2770ca\"}' WHERE `name` = 'richitheme' | |
| #28 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'rrhh' LIMIT 1 OFFSET 0; | |
| #29 | debug | UPDATE `settings` SET `name` = 'rrhh', `properties` = '{\"journal\":\"1\",\"extra-hours\":\"5\",\"biodevice\":\"0\",\"filtercheckdate\":null,\"allowmanual\":\"1\",\"overtime\":null,\"notificationemail\":\"\",\"credentialmaxlen\":\"0\",\"inputdelay\":\"0\",\"maxdelay\":\"0\",\"perioddelay\":\"0\",\"allowcomputable\":\"0\",\"minforextra\":\"0\",\"locationgps\":\"1\"}' WHERE `name` = 'rrhh' | |
| #30 | debug | SELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'servicios' LIMIT 1 OFFSET 0; | |
| #31 | debug | UPDATE `settings` SET `name` = 'servicios', `properties` = '{\"workstatus\":\"0\",\"print_ticket_footer_text\":\"\",\"print_pdf_footer_text\":\"\",\"longnumero\":\"6\",\"patron\":\"SER{ANYO}-{NUM}\",\"new_service_without_machine\":\"1\",\"disablestockmanagement\":\"\",\"print_pdf_machine_info\":\"\",\"print_pdf_observations\":\"\",\"print_pdf_agent\":\"\",\"print_pdf_assigned\":\"\",\"print_pdf_works\":\"\",\"print_pdf_work_reference\":\"\",\"print_pdf_work_description\":\"\",\"print_pdf_work_quantity\":\"\",\"print_pdf_work_price\":\"\",\"print_ticket_machine_info\":\"\",\"print_ticket_observations\":\"\",\"print_ticket_agent\":\"\",\"print_ticket_assigned\":\"\",\"print_ticket_works\":\"\",\"print_ticket_work_reference\":\"\",\"print_ticket_work_description\":\"\",\"print_ticket_work_quantity\":\"\",\"print_ticket_work_price\":\"\",\"document_description\":\"\",\"document_material\":\"\",\"document_solution\":\"\",\"document_observations\":\"\",\"document_start_date\":\"\",\"document_end_date\":\"\",\"document_machine\":\"\"}' WHERE `name` = 'servicios' | |
| #32 | debug | SELECT * FROM `settings` | |