| 0.0003 |
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('43b6961eb239342d43cf5a293f5b4a10', '13.59.61.119', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])', 1714083098, '')
|
| 0.0014 |
SHOW TABLES FROM `u909333597_sooretama`
|
| 0.0007 |
SELECT *
FROM `parametros_sistema`
ORDER BY `chave` ASC
|
| 0.0007 |
SELECT SUM(`VLR_ORCAMENTO`) AS `VLR_ORCAMENTO`
FROM `vw_portal_cpe_orcamento_receita`
WHERE `ANO_ORCAMENTO` = '2024'
|
| 0.0010 |
SELECT SUM(`VLR_ORCAMENTO`) AS `VLR_ORCAMENTO`
FROM `vw_portal_cpe_orcamento_despesa`
WHERE `ANO_ORCAMENTO` = '2024'
|
| 0.0255 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
|
| 0.0012 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0002 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` < '2024'
AND `ANO_DOCUMENTO` = '2024'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0003 |
SELECT *
FROM `vw_portal_cpe_filial`
GROUP BY `NRO_FILIAL_CNPJ`
ORDER BY `NOM_EMPRESA` ASC
|
| 0.0238 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '1'
|
| 0.0004 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '1'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0245 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '2'
|
| 0.0005 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '2'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0237 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '3'
|
| 0.0003 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '3'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0238 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '4'
|
| 0.0005 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '4'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0238 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '5'
|
| 0.0005 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '5'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0236 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '6'
|
| 0.0004 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '6'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0236 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '7'
|
| 0.0004 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '7'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0234 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '8'
|
| 0.0003 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '8'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0235 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '9'
|
| 0.0004 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '9'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0261 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '10'
|
| 0.0005 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '10'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0240 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '11'
|
| 0.0003 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '11'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0235 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '12'
|
| 0.0004 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `SBL_FASE` = '20'
AND `ANO_EMPENHO` = '2024'
AND `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '12'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0226 |
SELECT MIN(`ANO_DOCUMENTO`) AS `ANO_DOCUMENTO`
FROM `vw_portal_cpe_receita`
|
| 0.0002 |
SELECT MIN(`ANO_DOCUMENTO`) AS `ANO_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `ANO_DOCUMENTO` >0
|
| 0.0007 |
SELECT *
FROM `menus`
WHERE `localizacao` = 8
AND `ativo` = 1
ORDER BY `ordem`, `id` ASC
|
| 0.0006 |
SELECT *
FROM `menus`
WHERE `localizacao` = 8
AND `ativo` = 1
ORDER BY `ordem`, `id` ASC
|
