| 0.0004 |
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('c5fca760a9e92e7ab659bd2e76d1d2ef', '3.133.109.30', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])', 1714080628, '')
|
| 0.0012 |
SHOW TABLES FROM `u909333597_sooretama`
|
| 0.0007 |
SELECT *
FROM `parametros_sistema`
ORDER BY `chave` ASC
|
| 0.0084 |
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.0834 |
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.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 `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.0328 |
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.0233 |
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.0234 |
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.0263 |
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.0246 |
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.0234 |
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.0234 |
SELECT SUM(`VLR_DOCUMENTO`) AS `VLR_DOCUMENTO`
FROM `vw_portal_cpe_receita`
WHERE `ANO_DOCUMENTO` = '2024'
AND MONTH(DAT_DOCUMENTO) = '7'
|
| 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) = '7'
AND `NOM_LIQUIDACAO_TIPO` NOT LIKE '%Restos a Pagar%' ESCAPE '!'
|
| 0.0282 |
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.0234 |
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.0232 |
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.0232 |
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.0280 |
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.0197 |
SELECT MIN(`ANO_DOCUMENTO`) AS `ANO_DOCUMENTO`
FROM `vw_portal_cpe_receita`
|
| 0.0003 |
SELECT MIN(`ANO_DOCUMENTO`) AS `ANO_DOCUMENTO`
FROM `vw_portal_cpe_despesa`
WHERE `ANO_DOCUMENTO` >0
|
| 0.0004 |
SELECT *
FROM `menu`
WHERE `status` = 1
AND `posicao` = 2
ORDER BY `parent` ASC, `ordem` ASC, `texto` ASC
|
| 0.0003 |
SELECT *
FROM `menu`
WHERE `parent` = 100
AND `status` = 1
AND `posicao` = 1
ORDER BY `parent` ASC, `ordem` ASC, `texto` ASC
|
| 0.0003 |
SELECT *
FROM `menu`
WHERE `parent` = 1
AND `status` = 1
AND `posicao` = 1
ORDER BY `parent` ASC, `ordem` ASC, `texto` ASC
|
| 0.0004 |
SELECT *
FROM `menu`
WHERE `parent` = 2
AND `status` = 1
AND `posicao` = 1
ORDER BY `parent` ASC, `ordem` ASC, `texto` ASC
|
| 0.0003 |
SELECT *
FROM `menu`
WHERE `parent` = 2
AND `status` = 1
AND `posicao` = 1
ORDER BY `parent` ASC, `ordem` ASC, `texto` ASC
|
| 0.0002 |
SELECT *
FROM `orgaos`
ORDER BY `ordem` ASC
|
| 0.0003 |
SELECT *
FROM `menu`
WHERE `parent` = 1
AND `status` = 1
AND `posicao` = 1
ORDER BY `parent` ASC, `ordem` ASC, `texto` ASC
|
| 0.0004 |
SELECT *
FROM `menu`
WHERE `parent` = 2
AND `status` = 1
AND `posicao` = 1
ORDER BY `parent` ASC, `ordem` ASC, `texto` ASC
|
| 0.0003 |
SELECT *
FROM `menu`
WHERE `parent` = 3
AND `status` = 1
AND `posicao` = 1
ORDER BY `parent` ASC, `ordem` ASC, `texto` ASC
|
| 0.0003 |
SELECT *
FROM `menu`
WHERE `parent` = 4
AND `status` = 1
AND `posicao` = 1
ORDER BY `parent` ASC, `ordem` ASC, `texto` ASC
|
| 0.0004 |
SELECT *
FROM `menu`
WHERE `parent` = 6
AND `status` = 1
AND `posicao` = 1
ORDER BY `parent` ASC, `ordem` ASC, `texto` ASC
|
| 0.0004 |
SELECT *
FROM `menu`
WHERE `parent` = 5
AND `status` = 1
AND `posicao` = 1
ORDER BY `parent` ASC, `ordem` ASC, `texto` ASC
|
