| 0.0003 |
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('c026e24d8fd4af6b14d97db89f811fbe', '18.221.53.209', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])', 1714136028, '')
|
| 0.0012 |
SHOW TABLES FROM `u909333597_sooretama`
|
| 0.0006 |
SELECT *
FROM `parametros_sistema`
ORDER BY `chave` ASC
|
| 0.0060 |
SELECT SUM(`VLR_ORCAMENTO`) AS `VLR_ORCAMENTO`
FROM `vw_portal_cpe_orcamento_receita`
WHERE `ANO_ORCAMENTO` = '2024'
|
| 0.0012 |
SELECT SUM(`VLR_ORCAMENTO`) AS `VLR_ORCAMENTO`
FROM `vw_portal_cpe_orcamento_despesa`
WHERE `ANO_ORCAMENTO` = '2024'
|
| 0.0298 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
|
| 0.0011 |
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.0271 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '1'
|
| 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) = '1'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0233 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '2'
|
| 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) = '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.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) = '3'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0233 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '4'
|
| 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) = '4'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0268 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '5'
|
| 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) = '5'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0293 |
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.0295 |
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.0255 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '8'
|
| 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) = '8'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0241 |
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.0238 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '10'
|
| 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) = '10'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0300 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '11'
|
| 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) = '11'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0296 |
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.0208 |
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
|
