| #1 | debug | SELECT * FROM "caja_terminales" | 0.7ms |
| #2 | debug | SELECT * FROM "cajas" WHERE "fechacierre" IS NULL AND "idterminal" = '1' | 0.5ms |
| #3 | debug | SELECT column_name as name, data_type as type,character_maximum_length, column_default as default,is_nullable FROM information_schema.columns WHERE table_catalog = 'fsviveiro' AND table_name = 'variantes' ORDER BY 1 ASC; | 10.2ms |
| #4 | debug | SELECT column_name as name, data_type as type,character_maximum_length, column_default as default,is_nullable FROM information_schema.columns WHERE table_catalog = 'fsviveiro' AND table_name = 'empresas' ORDER BY 1 ASC; | 6.9ms |
| #5 | debug | SELECT tc.constraint_type as type, tc.constraint_name as name FROM information_schema.table_constraints AS tc WHERE tc.table_name = 'empresas' AND tc.constraint_type IN ('PRIMARY KEY','FOREIGN KEY','UNIQUE') ORDER BY 1 DESC, 2 ASC; | 1.7ms |
| #6 | debug | SELECT
i.relname AS key_name,
a.attname AS column_name
FROM
pg_class t
JOIN
pg_index ix ON t.oid = ix.indrelid
JOIN
pg_class i ON i.oid = ix.indexrelid
JOIN
pg_attribute a ON a.attrelid = t.oid AND a.attnum = ANY(ix.indkey)
WHERE
t.relkind = 'r'
AND t.relname = 'empresas'
ORDER BY
i.relname,
a.attname; | 0.9ms |
| #7 | debug | SELECT column_name as name, data_type as type,character_maximum_length, column_default as default,is_nullable FROM information_schema.columns WHERE table_catalog = 'fsviveiro' AND table_name = 'empresas' ORDER BY 1 ASC; | 6.2ms |
| #8 | debug | SELECT * FROM "empresas" ORDER BY "nombre" ASC | 0.5ms |
| #9 | debug | SELECT column_name as name, data_type as type,character_maximum_length, column_default as default,is_nullable FROM information_schema.columns WHERE table_catalog = 'fsviveiro' AND table_name = 'attached_files' ORDER BY 1 ASC; | 4.3ms |
| #10 | debug | SELECT tc.constraint_type as type, tc.constraint_name as name FROM information_schema.table_constraints AS tc WHERE tc.table_name = 'attached_files' AND tc.constraint_type IN ('PRIMARY KEY','FOREIGN KEY','UNIQUE') ORDER BY 1 DESC, 2 ASC; | 0.7ms |
| #11 | debug | SELECT
i.relname AS key_name,
a.attname AS column_name
FROM
pg_class t
JOIN
pg_index ix ON t.oid = ix.indrelid
JOIN
pg_class i ON i.oid = ix.indexrelid
JOIN
pg_attribute a ON a.attrelid = t.oid AND a.attnum = ANY(ix.indkey)
WHERE
t.relkind = 'r'
AND t.relname = 'attached_files'
ORDER BY
i.relname,
a.attname; | 0.7ms |
| #12 | debug | SELECT column_name as name, data_type as type,character_maximum_length, column_default as default,is_nullable FROM information_schema.columns WHERE table_catalog = 'fsviveiro' AND table_name = 'attached_files' ORDER BY 1 ASC; | 3.7ms |
| #13 | debug | SELECT * FROM "attached_files" WHERE "idfile" = '5' LIMIT 1 OFFSET 0; | 0.3ms |