Tablero de Demo

Crear

Producto Cliente Contacto Factura de Cliente Albarán de Cliente Pedido de Cliente Presupuesto de Cliente

Historial

Impagado

Recibos

AAAA • -11,52 € • Vencimiento: 19-11-2025
AAAAAAA • 11,25 € • Vencimiento: 19-11-2025
AAAA • 11,52 € • Vencimiento: 06-11-2025
pepito perez con recargo equivalencia • 111,40 € • Vencimiento: 03-07-2025
Iván Varela • 4,79 € • Vencimiento: 19-06-2025
Srta. Juana Mota Segundo • 4,73 € • Vencimiento: 02-05-2025




#1kernel::init0ms26.81kb
#2plugins::init6ms685.1kb
#3kernel::run620ms4.47mb
#4Controller::html-render54ms1.61mb
#1Memory usage5.54mb
#2Memory peak5.97mb
#1StatusConnected
#2Typemysql
#3Version10.5.29-MariaDB
#1fsNickdemo
#2fsLogkeyp9D9jtkEaM6fIEGEcaomfdODDq6HhKHge13dl5wkz3gkWImTs4KDYiTeba8g0zbn3EauDrMiitHbsBluYJCSvVDtyDwhpCkSE6c
#3fsLanges_ES
#1debugSELECT * FROM `empresas` ORDER BY `nombre` ASC0.5ms
#2debugSHOW COLUMNS FROM `empresas`;0.4ms
#3debugSELECT * FROM `users` WHERE `nick` = 'demo' LIMIT 1 OFFSET 0;
#4debugSHOW COLUMNS FROM `facturascli`;0.5ms
#5debugSELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'facturascli';1.0ms
#6debugSHOW INDEXES FROM facturascli;0.2ms
#7debugSHOW COLUMNS FROM `facturascli`;0.5ms
#8debugSHOW COLUMNS FROM `estados_documentos`;0.5ms
#9debugSELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'estados_documentos';
#10debugSHOW INDEXES FROM estados_documentos;0.2ms
#11debugSHOW COLUMNS FROM `estados_documentos`;0.3ms
#12debugSELECT * FROM `estados_documentos` ORDER BY `idestado` ASC
#13debugSHOW COLUMNS FROM `divisas`;0.5ms
#14debugSELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'divisas';
#15debugSHOW INDEXES FROM divisas;
#16debugSHOW COLUMNS FROM `divisas`;0.3ms
#17debugSELECT * FROM `divisas` ORDER BY `coddivisa` ASC
#18debugSELECT * FROM `facturascli` WHERE `fecha` >= '2026-03-21' AND `nick` = 'demo' ORDER BY `idfactura` DESC LIMIT 3 OFFSET 0;
#19debugSHOW COLUMNS FROM `albaranescli`;0.4ms
#20debugSELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'albaranescli';
#21debugSHOW INDEXES FROM albaranescli;
#22debugSHOW COLUMNS FROM `albaranescli`;0.4ms
#23debugSELECT * FROM `albaranescli` WHERE `fecha` >= '2026-03-21' AND `nick` = 'demo' ORDER BY `idalbaran` DESC LIMIT 3 OFFSET 0;0.2ms
#24debugSHOW COLUMNS FROM `pedidoscli`;0.4ms
#25debugSELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'pedidoscli';
#26debugSHOW INDEXES FROM pedidoscli;
#27debugSHOW COLUMNS FROM `pedidoscli`;0.4ms
#28debugSELECT * FROM `pedidoscli` WHERE `fecha` >= '2026-03-21' AND `nick` = 'demo' ORDER BY `idpedido` DESC LIMIT 3 OFFSET 0;
#29debugSHOW COLUMNS FROM `presupuestoscli`;0.4ms
#30debugSELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'presupuestoscli';
#31debugSHOW INDEXES FROM presupuestoscli;
#32debugSHOW COLUMNS FROM `presupuestoscli`;0.4ms
#33debugSELECT * FROM `presupuestoscli` WHERE `fecha` >= '2026-03-21' AND `nick` = 'demo' ORDER BY `idpresupuesto` DESC LIMIT 3 OFFSET 0;0.2ms
#34debugSHOW COLUMNS FROM `clientes`;0.8ms
#35debugSELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'clientes';1.2ms
#36debugSHOW INDEXES FROM clientes;
#37debugSHOW COLUMNS FROM `clientes`;0.4ms
#38debugSELECT * FROM `clientes` WHERE `fechaalta` >= '2026-03-21' ORDER BY `fechaalta` DESC LIMIT 3 OFFSET 0;0.2ms
#39debugSHOW COLUMNS FROM `contactos`;0.4ms
#40debugSELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'contactos';
#41debugSHOW INDEXES FROM contactos;
#42debugSHOW COLUMNS FROM `contactos`;0.4ms
#43debugSELECT * FROM `contactos` WHERE `fechaalta` >= '2026-03-21' ORDER BY `fechaalta` DESC LIMIT 3 OFFSET 0;0.3ms
#44debugSHOW COLUMNS FROM `productos`;0.9ms
#45debugSELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'productos';0.6ms
#46debugSHOW INDEXES FROM productos;0.2ms
#47debugSHOW COLUMNS FROM `productos`;0.4ms
#48debugSELECT * FROM `productos` WHERE `actualizado` >= '2026-03-21 22:54:29' ORDER BY `actualizado` DESC LIMIT 3 OFFSET 0;0.2ms
#49debugSELECT SUM(`neto`) as sum FROM `facturasprov` WHERE `fecha` >= '2026-03-01' AND `fecha` < '2026-04-01'
#50debugSELECT SUM(`neto`) as sum FROM `facturasprov` WHERE `fecha` >= '2026-02-01' AND `fecha` < '2026-03-01'
#51debugSELECT SUM(`neto`) as sum FROM `facturasprov` WHERE `fecha` >= '2026-01-01' AND `fecha` < '2026-02-01'
#52debugSELECT SUM(`neto`) as sum FROM `facturascli` WHERE `fecha` >= '2026-03-01' AND `fecha` < '2026-04-01'
#53debugSELECT SUM(`neto`) as sum FROM `facturascli` WHERE `fecha` >= '2026-02-01' AND `fecha` < '2026-03-01'
#54debugSELECT SUM(`neto`) as sum FROM `facturascli` WHERE `fecha` >= '2026-01-01' AND `fecha` < '2026-02-01'
#55debugSELECT SUM(`totaliva`) as sum FROM `facturascli` WHERE `fecha` >= '2026-03-01' AND `fecha` < '2026-04-01'
#56debugSELECT SUM(`totalrecargo`) as sum FROM `facturascli` WHERE `fecha` >= '2026-03-01' AND `fecha` < '2026-04-01'
#57debugSELECT SUM(`totaliva`) as sum FROM `facturasprov` WHERE `fecha` >= '2026-03-01' AND `fecha` < '2026-04-01'
#58debugSELECT SUM(`totalrecargo`) as sum FROM `facturasprov` WHERE `fecha` >= '2026-03-01' AND `fecha` < '2026-04-01'
#59debugSELECT SUM(`totaliva`) as sum FROM `facturascli` WHERE `fecha` >= '2026-02-01' AND `fecha` < '2026-03-01'
#60debugSELECT SUM(`totalrecargo`) as sum FROM `facturascli` WHERE `fecha` >= '2026-02-01' AND `fecha` < '2026-03-01'
#61debugSELECT SUM(`totaliva`) as sum FROM `facturasprov` WHERE `fecha` >= '2026-02-01' AND `fecha` < '2026-03-01'
#62debugSELECT SUM(`totalrecargo`) as sum FROM `facturasprov` WHERE `fecha` >= '2026-02-01' AND `fecha` < '2026-03-01'
#63debugSELECT SUM(`totaliva`) as sum FROM `facturascli` WHERE `fecha` >= '2026-01-01' AND `fecha` < '2026-02-01'
#64debugSELECT SUM(`totalrecargo`) as sum FROM `facturascli` WHERE `fecha` >= '2026-01-01' AND `fecha` < '2026-02-01'
#65debugSELECT SUM(`totaliva`) as sum FROM `facturasprov` WHERE `fecha` >= '2026-01-01' AND `fecha` < '2026-02-01'
#66debugSELECT SUM(`totalrecargo`) as sum FROM `facturasprov` WHERE `fecha` >= '2026-01-01' AND `fecha` < '2026-02-01'
#67debugSELECT COUNT(*) as _count FROM `clientes` WHERE `fechaalta` >= '2026-03-01' AND `fechaalta` < '2026-04-01' LIMIT 1 OFFSET 0;
#68debugSELECT COUNT(*) as _count FROM `clientes` WHERE `fechaalta` >= '2026-02-01' AND `fechaalta` < '2026-03-01' LIMIT 1 OFFSET 0;
#69debugSELECT COUNT(*) as _count FROM `clientes` WHERE `fechaalta` >= '2026-01-01' AND `fechaalta` < '2026-02-01' LIMIT 1 OFFSET 0;
#70debugSELECT * FROM stocks WHERE stockmin > 0 AND disponible < stockmin;0.8ms
#71debugSHOW COLUMNS FROM `recibospagoscli`;0.3ms
#72debugSELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'recibospagoscli';
#73debugSHOW INDEXES FROM recibospagoscli;
#74debugSHOW COLUMNS FROM `recibospagoscli`;0.3ms
#75debugSELECT * FROM `recibospagoscli` WHERE `pagado` = FALSE AND `vencimiento` < '2026-03-23' AND `vencimiento` > '2025-03-23' ORDER BY `vencimiento` DESC
#76debugSELECT * FROM `pages` WHERE `showonmenu` = TRUE ORDER BY lower(menu) ASC, lower(submenu) ASC, `ordernum` ASC, lower(title) ASC0.7ms
#77debugSHOW COLUMNS FROM `pages`;0.3ms
#78debugSELECT * FROM `clientes` WHERE `codcliente` = '76' LIMIT 1 OFFSET 0;0.2ms
#79debugSELECT * FROM `clientes` WHERE `codcliente` = '77' LIMIT 1 OFFSET 0;
#80debugSELECT * FROM `clientes` WHERE `codcliente` = '76' LIMIT 1 OFFSET 0;
#81debugSELECT * FROM `clientes` WHERE `codcliente` = '71' LIMIT 1 OFFSET 0;
#82debugSELECT * FROM `clientes` WHERE `codcliente` = '25' LIMIT 1 OFFSET 0;
#83debugSELECT * FROM `clientes` WHERE `codcliente` = '1' LIMIT 1 OFFSET 0;
#1debugTabla facturascli comprobada.
#2debugTabla estados_documentos comprobada.
#3debugTabla divisas comprobada.
#4debugTabla albaranescli comprobada.
#5debugTabla pedidoscli comprobada.
#6debugTabla presupuestoscli comprobada.
#7debugTabla clientes comprobada.
#8debugTabla contactos comprobada.
#9debugTabla productos comprobada.
#10debugTabla recibospagoscli comprobada.
Partes
Clientes
Productos