| 0.0004 |
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('de552db06eba63e81d9d0c657929b2f7', '18.191.5.239', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])', 1713518533, '')
|
| 0.0013 |
SHOW TABLES FROM `u909333597_sooretama`
|
| 0.0007 |
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.0696 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
|
| 0.0010 |
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.0004 |
SELECT *
FROM `vw_portal_cpe_filial`
GROUP BY `NRO_FILIAL_CNPJ`
ORDER BY `NOM_EMPRESA` ASC
|
| 0.0242 |
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.0242 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '2'
|
| 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) = '2'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0242 |
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.0242 |
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.0241 |
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.0241 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '6'
|
| 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) = '6'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0242 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '7'
|
| 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) = '7'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0242 |
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.0243 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '9'
|
| 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) = '9'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0243 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '10'
|
| 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) = '10'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0242 |
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.0241 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '12'
|
| 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) = '12'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0207 |
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.0009 |
SELECT *
FROM `menus`
WHERE `localizacao` = 8
AND `ativo` = 1
ORDER BY `ordem`, `id` ASC
|
| 0.0009 |
SELECT *
FROM `menus`
WHERE `localizacao` = 8
AND `ativo` = 1
ORDER BY `ordem`, `id` ASC
|
