<commit_before>SELECT
t.NAVIGATION_ID
, t.NAVIGATION_CODE
, t.NAME
, t.PARENT_ID
, t.PARENT_CODE
, (select count(*) from c1_NAVIGATION s where s.PARENT_ID = t.NAVIGATION_ID) as children_count
, t.URL
FROM c1_NAVIGATION t
WHERE t.state_code = '1' and t.data_state_code = '1'
<#if cardone.StringUtils.isBlank(notId)>
    <#if cardone.StringUtils.isNotBlank(id)>
    AND t.PARENT_ID = :id
    <#else>
    AND t.PARENT_ID = ''
    </#if>
</#if>
<@cardone.permissionSql permissionColumnName="t.NAVIGATION_CODE" permissions=permissions />
ORDER BY t.ORDER_BY_, t.NAVIGATION_CODE<commit_msg>查询权限控制<commit_after>SELECT
t.NAVIGATION_ID
, t.NAVIGATION_CODE
, t.NAME
, t.PARENT_ID
, t.PARENT_CODE
, (select count(*) from c1_NAVIGATION s where s.PARENT_ID = t.NAVIGATION_ID) as children_count
, t.URL
FROM c1_NAVIGATION t
WHERE t.state_code = '1' and t.data_state_code = '1'
<#if cardone.StringUtils.isBlank(notId)>
    <#if cardone.StringUtils.isNotBlank(id)>
    AND t.PARENT_ID = :id
    <#else>
    AND t.PARENT_ID = ''
    </#if>
</#if>
<@cardone.permissionSql prefixName=false permissions=permissions permissionColumnName="t.NAVIGATION_CODE"/>
ORDER BY t.ORDER_BY_, t.NAVIGATION_CODE
{'fraction_non_alphanumeric': 0.12999150382327954, 'fraction_numerical': 0.006796941376380629, 'mean_word_length': 4.8606965174129355, 'pattern_counts': {'":': 0, '<': 15, '<?xml version=': 0, '>': 15, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '145506', 'n_tokens_mistral': 505, 'n_tokens_neox': 495, 'n_words': 90}