#1kernel::init5ms102.03kb
#2plugins::init128ms2.04mb
#3kernel::run55ms923.91kb
#4Controller::html-render30ms457.77kb
#1Memory usage3.53mb
#2Memory peak3.97mb
#1StatusConnected
#2Typemysql
#3Version10.11.18-MariaDB-cll-lve
#1debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'barcodegenerator' LIMIT 1 OFFSET 0;0.4ms
#2debugBegin Transaction
#3debugUPDATE `settings` SET `name` = 'barcodegenerator', `properties` = '{\"prefix\":\"RE\",\"separator\":\"-\",\"max_length\":\"20\",\"digits\":\"6\",\"mode\":\"referenceid\",\"uppercase\":\"1\",\"auto_on_save\":\"1\"}' WHERE `name` = 'barcodegenerator'
#4debugCommit Transaction
#5debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'default' LIMIT 1 OFFSET 0;0.3ms
#6debugUPDATE `settings` SET `name` = 'default', `properties` = '{\"codpais\":\"ESP\",\"decimals\":\"2\",\"decimal_separator\":\",\",\"thousands_separator\":\" \",\"currency_position\":\"right\",\"item_limit\":50,\"coddivisa\":\"EUR\",\"homepage\":\"ListAlbaranCliente\",\"updatesupplierprices\":true,\"ventasinstock\":true,\"codalmacen\":\"ALG\",\"idempresa\":\"1\",\"tipoidfiscal\":\"NIF\",\"codimpuesto\":\"IVA21\",\"codpago\":\"CONT\",\"codserie\":\"A\",\"codserierec\":\"R\",\"validate_iban\":true,\"costpricepolicy\":null,\"codrole\":\"employee\",\"finofertadays\":0,\"codretencion\":null,\"columnetosubtotal\":\"subtotal\",\"tablesize\":\"big\",\"bootema\":\"solar\",\"idloginimage\":0,\"enable_api\":false,\"enableupdatesbeta\":false,\"telemetryinstall\":6099,\"telemetrylastu\":1783574814,\"telemetrykey\":\"9UJOtLSqHFcWMPzweRds\",\"autogenbarcodes\":0}' WHERE `name` = 'default'
#7debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'email' LIMIT 1 OFFSET 0;0.2ms
#8debugUPDATE `settings` SET `name` = 'email', `properties` = '{\"enc\":\"ssl\",\"host\":\"email-smtp.eu-west-2.amazonaws.com\",\"mailer\":\"smtp\",\"port\":465,\"email\":\"ventas@reelec.es\",\"emailbcc\":\"admin@1-sat.com\",\"signature\":\"<p style="font-size:20px"><strong>REELEC, Repuestos y Servicio Técnico de electrodomésticos</strong></p>\\r\\n<p style="font-size:16px"><strong>Te invito a conocer más sobre REELEC entrando en nuestra web <a href="https://www.reelec.es">www.reelec.es</a></strong></p>\\r\\n<p style="font-size:16px">¿Ya conoces nuestras tiendas/taller?<br>\\r\\n<ul style="font-size:16px">\\r\\n<li>Murcia - Av. de Sta. Catalina, 31, local, 30012<br>\\r\\nTeléfono: <strong>868 61 02 30</strong></li>\\r\\n<li>Málaga - C/ Juan Martínez Montañés, 5, local 7.1, 29004<br>\\r\\nTeléfono: <strong>685 87 43 42</strong></li>\\r\\n</ul>\\r\\n</p>\\r\\n<p><a href="https://www.reelec.es"><img src="https://reelec.es/img/my-shop-logo-1589990555.jpg" width="400px"></a></p>\\r\\n\\r\\n\\r\\n<p>"AVISO: La información contenida en este mensaje de correo electrónico y, en su caso, en cualquier fichero anexo al mismo, tiene caracter reservado y confidencial para uso exclusivo de su destinatario o destinatarios, por lo que su divulgacón, copia o distribución a terceros están expresamente prohibidas. En el caso de haber recibido este mensaje por error se ruega comunicarlo inmediatamente mediante reenvio a la dirección electrónica del remitente, eliminándolo a continuación."<br>\\r\\n<p>"NOTICE: All information contained in this message and, in the event, any file attached hereto, is confidential and intended for the sole use of the addressee(s). Disseminating, copying or distributing this message to third parties is expressly</p>\",\"password\":\"BJzk+MtB1H02iCfhAxZGudYH2Wau2lhW9bIB7E6jeQiu\",\"user\":\"AKIAWJPSA3N62HLO6ZMQ\",\"authtype\":null,\"lowsecure\":false,\"replytouseremail\":\"1\",\"emailcc\":\"ventas@reelec.es\"}' WHERE `name` = 'email'0.2ms
#9debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'packlinkshippingfs2023' LIMIT 1 OFFSET 0;0.2ms
#10debugUPDATE `settings` SET `name` = 'packlinkshippingfs2023', `properties` = '{\"packlink_token\":\"84aea8280ea6ed1f3e858d6544c4836ad40f5306ef328a557ab1222e6e86dae7\",\"packlink_company_name\":\"REELEC\",\"packlink_company_phone\":\"644955070\",\"packlink_company_email\":\"clientes@reelec.es\",\"packlink_company_contact_name\":\"Joaquín\",\"packlink_company_contact_surname\":\"REELEC\",\"packlink_company_address\":\"Avenida de Santa Catalina 31\",\"packlink_company_postcode\":\"30012\",\"packlink_company_city\":\"Murcia\",\"packlink_company_country\":\"\",\"packlink_email_template\":\"Hola {cliente},\\r\\n\\r\\nTu envío/recogida ha sido gestionado mediante {carrier}.\\r\\n\\r\\nNúmero de seguimiento:\\r\\n{tracking}\\r\\n\\r\\nPuedes consultar el estado del envío aquí:\\r\\n{tracking_url}\\r\\n\\r\\nFecha de recogida:\\r\\n{collection_date}\\r\\n\\r\\nFranja horaria de recogida:\\r\\n{collection_time}\\r\\n\\r\\nDescarga de etiqueta:\\r\\n{label_url}\\r\\n\\r\\nImportante – Preparación del paquete\\r\\n\\r\\nSi se trata de la recogida de un aparato electrónico, te recomendamos preparar el envío de la siguiente forma:\\r\\n\\r\\n• Protege bien el aparato con material acolchado (burbuja o espuma).\\r\\n• Utiliza una caja resistente y del tamaño adecuado.\\r\\n• Evita que el aparato se mueva dentro del paquete.\\r\\n• Si es posible, envuelve el aparato en una bolsa protectora antes del embalaje.\\r\\n• Cierra la caja firmemente con cinta de embalaje.\\r\\n\\r\\nEsto ayudará a evitar daños durante el transporte.\\r\\n\\r\\nGracias por confiar en nosotros.\\r\\n\\r\\nUn saludo.\"}' WHERE `name` = 'packlinkshippingfs2023'
#11debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'paysign' LIMIT 1 OFFSET 0;0.2ms
#12debugUPDATE `settings` SET `name` = 'paysign', `properties` = '{\"api_base_url\":\"https://www.paysign.io\",\"api_key\":\"GvZHN52xIljFn0DQCogUKT94EDZmjXvQi5oyrEiy\",\"api_secret\":\"CNofsPCg59YFfH3HDWCyBAR9bqnoE2J7CPDWBrxJqAz2sMETA9DG5lYjp8vsrfuL\",\"timeout\":\"20\",\"default_source_system\":\"facturascripts\",\"default_currency\":\"EUR\",\"default_language\":\"es\",\"default_country_code\":\"ESP\",\"default_flow_type\":\"payment_only\",\"default_require_payment\":\"1\",\"default_require_signature\":\"1\",\"default_send_email\":\"1\",\"default_signature_mode\":\"drawn\",\"default_return_url\":\"\",\"default_cancel_url\":\"\",\"default_success_url\":\"\",\"default_webhook_url\":\"\",\"default_logo_url\":\"\",\"external_reference_template\":\"{model}-{document_code}\",\"title_template\":\"{model_label} {document_code}\",\"description_template\":\"Pago del documento {model_label} {document_code}\",\"document_type_template\":\"{source_type}\",\"document_external_reference_template\":\"{model}-{document_code}\",\"document_number_template\":\"{document_code}\",\"document_title_template\":\"{model_label} {document_code}\",\"document_html_template\":\"<section><h1>{document_title}</h1><p><strong>Documento:</strong> {document_code}</p><p><strong>Cliente:</strong> {customer_name}</p><p><strong>Importe:</strong> {amount_total} {currency}</p></section>\",\"webhook_signing_secret\":\"YV0AJ5jiKsZnBeniiq2Jy8lkRf96xUrlFMPoAH3Q3s6GaUystNibAywB7Xt0RrjB\"}' WHERE `name` = 'paysign'
#13debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'plantillaspdf' LIMIT 1 OFFSET 0;
#14debugUPDATE `settings` SET `name` = 'plantillaspdf', `properties` = '{\"bottommargin\":20,\"color1\":\"#2770ca\",\"color2\":\"#ffffff\",\"color3\":\"#f1f1f1\",\"endalign\":\"justify\",\"endfontsize\":10,\"endtext\":\"\",\"font\":\"DejaVuSans\",\"fontcolor\":\"#000000\",\"fontsize\":10,\"footeralign\":\"center\",\"footerfontsize\":10,\"footertext\":\"ONESAT SL, Inscrita en el Registro Mercantil de Málaga: Tomo 5517, Folio 25, Inscripción 1, Hoja MA-134139\\r\\n{PAGENO} / {nbpg}\",\"linecols\":\"referencia,descripcion,cantidad,pvpunitario,dtopor,pvptotal,iva,recargo,irpf\",\"linecolalignments\":\"left,left,right,right,right,right,right,right,right\",\"linecoltypes\":\"text,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\":true,\"size\":\"A4\",\"thankstext\":\"\",\"thankstitle\":\"\",\"template\":\"Template1\",\"titlefontsize\":18,\"topmargin\":50,\"idlogo\":\"1\",\"showcustomercode\":true,\"showcustomerphones\":true,\"showcustomeremail\":true,\"shownumero2\":true,\"showpaymentdate\":false,\"showagent\":false,\"showinvoicesketch\":false,\"hideshipping\":false,\"hidenumberinvoice\":false,\"hideserieinvoice\":false,\"hideobservations\":false,\"hidepaymentmethods\":false,\"hidereceipts\":false,\"hideexpirationpayment\":false,\"idimagetext\":null,\"imagetextsize\":0,\"idimagefooter\":null,\"imagefootersize\":0,\"qrfield\":\"\",\"qrpositionx\":0,\"qrpositiony\":0}' WHERE `name` = 'plantillaspdf'
#15debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'richitheme' LIMIT 1 OFFSET 0;
#16debugUPDATE `settings` SET `name` = 'richitheme', `properties` = '{\"lbgcolor\":\"#EDEDED\",\"fbgcolor\":\"#FFFFFF\",\"lbtncolor\":\"#2770CA\",\"lfoodis\":0,\"lrpdis\":0,\"sbgcolor\":\"#F7F7F7\",\"subbgcolor\":\"#F8FDFF\",\"itembgcolor\":\"#ABD9FF\",\"accentcolor\":\"#000000\",\"lsfile\":\"3749\",\"tbgcolor\":\"#FFFFFFB3\",\"tcndis\":0,\"stxtcolor\":\"#000000\",\"ttxtcolor\":\"#1A1F36\",\"itxtcolor\":\"#6C757D\",\"uigradient\":\"#2770CA\",\"sidebar_menu_order\":\"admin,sales,purchases,warehouse,accounting,crm,reports,new,rrhh\",\"sidebar_menu_hidden\":\"new\",\"sidebar_menu_labels\":\"{\\\"admin/AdminRichiTheme\\\":\\\"Ajustes del Tema\\\",\\\"admin/PacklinkConfig\\\":\\\"Conexión Packlink\\\",\\\"admin/StripeSettings\\\":\\\"Conexión Stripe\\\",\\\"sales/ListPaysignCheckouts\\\":\\\"Lista Checkouts\\\",\\\"sales/ListStripePaymentLinks\\\":\\\"Lista Pagos Links\\\",\\\"sales/ListStripePayments\\\":\\\"Pagos Formulario\\\",\\\"sales/PaysignCheckout\\\":\\\"Nuevo Checkout\\\"}\",\"sidebar_menu_subhidden\":\"[\\\"admin/About\\\",\\\"admin/Updater\\\"]\",\"sidebar_menu_suborder\":\"{\\\"accounting\\\":[\\\"accounting/ListAsiento\\\",\\\"accounting/ListCuenta\\\",\\\"accounting/ListEjercicio\\\",\\\"accounting/ListFormaPago\\\",\\\"accounting/ListImpuesto\\\",\\\"accounting/ListSerie\\\"],\\\"admin\\\":[\\\"admin/About\\\",\\\"admin/Updater\\\",\\\"admin/ListUser\\\",\\\"admin/ListAgente\\\",\\\"admin/ListAttachedFile\\\",\\\"admin/EditSettings\\\",\\\"admin/PaysignSettings\\\",\\\"admin/PacklinkConfig\\\",\\\"admin/StripeSettings\\\",\\\"admin/AdminCRM\\\",\\\"admin/ConfigEmail\\\",\\\"admin/ListEmpresa\\\",\\\"admin/BarcodeGeneratorConfig\\\",\\\"admin/ListLogMessage\\\",\\\"admin/AdminRichiTheme\\\",\\\"admin/ListPacklinkPaquete\\\",\\\"admin/ListPais\\\",\\\"admin/AdminPlantillasPDF\\\",\\\"admin/AdminPlugins\\\",\\\"admin/AdminServicios\\\"],\\\"crm\\\":[\\\"crm/ListContacto\\\",\\\"crm/ListCrmNota\\\",\\\"crm/ListCrmOportunidad\\\"],\\\"new\\\":[\\\"new/PacklinkCancel\\\",\\\"new/PacklinkCompare\\\",\\\"new/PaysignWebhook\\\",\\\"new/StripeImportPayments\\\",\\\"new/StripePaymentAction\\\",\\\"new/StripePaymentLinkController\\\",\\\"new/StripeWebhook\\\"],\\\"purchases\\\":[\\\"purchases/ListAlbaranProveedor\\\",\\\"purchases/ListFacturaProveedor\\\",\\\"purchases/ListPedidoProveedor\\\",\\\"purchases/ListPresupuestoProveedor\\\",\\\"purchases/ListProveedor\\\"],\\\"reports\\\":[\\\"reports/ReportTaxes\\\",\\\"reports/ReportProducto\\\",\\\"reports/Dashboard\\\"],\\\"rrhh\\\":[\\\"rrhh/EmployeePanel\\\",\\\"rrhh/ListAttendance\\\",\\\"rrhh/ListCourseTraining\\\",\\\"rrhh/ListBasicData\\\",\\\"rrhh/ListEmployee\\\",\\\"rrhh/ReportAttendance\\\",\\\"rrhh/AttendancePanel\\\"],\\\"sales\\\":[\\\"sales/ListCliente\\\",\\\"sales/ListFacturaCliente\\\",\\\"sales/ListAlbaranCliente\\\",\\\"sales/ListPresupuestoCliente\\\",\\\"sales/ListPedidoCliente\\\",\\\"sales/ListServicioAT\\\",\\\"sales/PaysignCheckout\\\",\\\"sales/ListPaysignCheckouts\\\",\\\"sales/ListStripePayments\\\",\\\"sales/ListStripePaymentLinks\\\",\\\"sales/ListPacklinkEnvio\\\",\\\"sales/ListTarifa\\\"],\\\"warehouse\\\":[\\\"warehouse/ListProducto\\\",\\\"warehouse/ListAlmacen\\\",\\\"warehouse/ListAtributo\\\",\\\"warehouse/Etiquetas\\\",\\\"warehouse/ListFabricante\\\",\\\"warehouse/ListFamilia\\\",\\\"warehouse/ListAgenciaTransporte\\\"]}\",\"htotals\":\"1\"}' WHERE `name` = 'richitheme'0.3ms
#17debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'rrhh' LIMIT 1 OFFSET 0;
#18debugUPDATE `settings` SET `name` = 'rrhh', `properties` = '{\"journal\":\"1\",\"extra-hours\":\"5\",\"biodevice\":\"0\"}' WHERE `name` = 'rrhh'
#19debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'servicios' LIMIT 1 OFFSET 0;
#20debugUPDATE `settings` SET `name` = 'servicios', `properties` = '{\"footertext\":\"Condiciones del depósito:\\r\\nLos presupuestos realizados tienen validez de 15 días.\\r\\nUna vez avisado al cliente para que recoja el producto, dispondrá de un plazo máximo de 10 días para recogerlo, de no ser así y no haber aviso por parte del cliente se empezará a cobrar 2 € al día por gastos de almacenaje.\\r\\nLos accesorios y productos externos al equipo no especificados en este documento no podrán ser reclamados en caso de disconformidad con el técnico.\\r\\nSe informará al cliente del presupuesto siempre que sea superior a 35€ en PAE, superior a 60€ en aparatos electrónicos, placas y televisores de hasta 40\\\", superior a 80€ en televisores a partir de 40\\\", en caso de ser de un importe igual o inferior el técnico reparará independientemente del valor de presupuesto quedando este aceptado en este documento.\",\"patron\":\"SER{ANYO}-{NUM}\",\"workstatus\":\"3\",\"printworks\":true,\"printmachineinfo\":true,\"printobservations\":true,\"disablestockmanagement\":false,\"longnumero\":6,\"print_ticket_footer_text\":\"\",\"print_pdf_footer_text\":\"\",\"print_pdf_description\":1,\"print_pdf_material\":1,\"print_pdf_solution\":1,\"print_ticket_description\":1,\"print_ticket_material\":1,\"print_ticket_solution\":1}' WHERE `name` = 'servicios'
#21debugSELECT COUNT(*) as _count FROM `settings` WHERE `name` = 'stripefs' LIMIT 1 OFFSET 0;0.2ms
#22debugUPDATE `settings` SET `name` = 'stripefs', `properties` = '{\"stripe_secret_key\":\"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\",\"stripe_public_key\":\"pk_live_51TJqXYL5wODaXGibCwyTGk84aJ7G9NKuaarieZmIqg4IMY2Q5FnFBN9AfHaeGXhRvIOqbOvKkeC6yqUDI1WT8p5J00EfNkLzsj\",\"stripe_currency\":\"EUR\",\"stripe_webhook_secret\":\"whsec_EZb1OrSLKw7OaBpheQAjOXKLNOC8dvvx\",\"stripe_webhook_id\":\"we_1TJyW8L5wODaXGibVQ86KT21\"}' WHERE `name` = 'stripefs'
#23debugSELECT * FROM `settings`0.6ms
#24debugSELECT * FROM `empresas` ORDER BY `nombre` ASC0.7ms
#25debugSHOW COLUMNS FROM `empresas`;1.0ms