###########################################################################################################################################
# Generated        : 2024-06-04 17:31
# Cmdline          : fbtrace_parser.php --sort=perf_natural trace.log
# Queries          : 145
# Excluded queries : 0
###########################################################################################################################################

Databases: AUTEX.FDB
Time range: 2024-06-04 14:25:21 - 2024-06-04 14:25:43
Queries: 4288
 +----------- +----------- +----------- +
 |            |   Avarage  |     Total  |
 +----------- +----------- +----------- +
 |  time (ms) |          0 |          1 |
 |      reads |          0 |          0 |
 |    fetches |         87 |     373058 |
 |     writes |          0 |          0 |
 |      reads |          0 |          0 |
 |    records |          1 |       4288 |
 +----------- +----------- +----------- +
Sample SQL:
SELECT FIRST 1 bar.ACCOUNT_ABBR FROM BOOKKEEPING_ACCOUNT_RULES bar
            LEFT JOIN BOOKKEEPING_RULE_GOOD_TREE brgt ON(brgt.BOOKKEEPING_ACCOUNT_RULE_ID = bar.BOOKKEEPING_ACCOUNT_RULE_ID)
            JOIN BOOKKEEPING_ACCOUNT_TYPES bat on (bat.TYPE_NAME = bar.ACCOUNT_ABBR)
            WHERE bat.IS_ACTIVE = 'T' AND bar.DOC_KIND = 'S'  AND (bar.IS_PAKALPOJUMS = 'F' OR COALESCE(bar.IS_PAKALPOJUMS, '') = '') AND (bar.COUNTRY_GROUP_ID = 2 OR bar.COUNTRY_GROUP_ID IS NULL) AND (bat.LOCATION_ID = 2 OR bat.LOCATION_ID IS NULL) AND (COALESCE(bar.DOC_TYPE, '') = '' OR bar.DOC_TYPE = 'Y') AND (COALESCE(bar.DOC_PAY_TYPE, '') = '' OR bar.DOC_PAY_TYPE = 'N') AND (COALESCE(bar.PVN_RATE, '') = '' OR bar.PVN_RATE = '0') AND ((brgt.SUBGROUP_ID IS NULL AND brgt.GROUP_ID IS NULL AND brgt.CATEGORY_ID IS NULL) OR (brgt.SUBGROUP_ID = 26 OR (brgt.GROUP_ID = 3 AND brgt.SUBGROUP_ID IS NULL) OR (brgt.CATEGORY_ID = 3 AND brgt.SUBGROUP_ID IS NULL AND brgt.GROUP_ID IS NULL)))
            ORDER BY IIF(bar.DOC_TYPE IS NULL, 0, 1) + IIF(bar.DOC_PAY_TYPE IS NULL, 0, 1) + IIF(bar.COUNTRY_GROUP_ID IS NULL OR (SELECT COALESCE(COUNTRIES.COUNTRY_GROUP_ID, CLIENTS.COUNTRY_GROUP_ID) FROM CLIENTS JOIN COUNTRIES ON(COUNTRIES.COUNTRY_ID = CLIENTS.COUNTRY_ID) WHERE CLIENT_ID = 3851) IS NULL, 0, 1) + IIF(bar.IS_PAKALPOJUMS IS NULL, 0, 1) + IIF(bat.LOCATION_ID IS NULL, 0, 1) + IIF(brgt.CATEGORY_ID IS NULL, 0, 1) + IIF(brgt.GROUP_ID IS NULL, 0, 1) + IIF(brgt.SUBGROUP_ID IS NULL, 0, 1) + IIF(COALESCE(bar.PVN_RATE, '') = '', 0, 1) DESC

Table                             Natural     Index    Update    Insert    Delete   Backout     Purge   Expunge
***************************************************************************************************************
BOOKKEEPING_ACCOUNT_RULES          188672
BOOKKEEPING_ACCOUNT_TYPES           85760
BOOKKEEPING_RULE_GOOD_TREE          12864
############################################################################################################################################

Databases: AUTEX.FDB
Time range: 2024-06-04 14:25:21 - 2024-06-04 14:25:43
Queries: 8576
 +----------- +----------- +----------- +
 |            |   Avarage  |     Total  |
 +----------- +----------- +----------- +
 |  time (ms) |          0 |          0 |
 |      reads |          0 |          0 |
 |    fetches |         24 |     205824 |
 |     writes |          0 |          0 |
 |      reads |          0 |          0 |
 |    records |         20 |     171520 |
 +----------- +----------- +----------- +
Sample SQL:
SELECT DISTINCT TYPE_NAME ACCOUNT_ABBR FROM BOOKKEEPING_ACCOUNT_TYPES WHERE IS_ACTIVE = 'T'  AND (LOCATION_ID = 2 OR LOCATION_ID IS NULL)

Table                             Natural     Index    Update    Insert    Delete   Backout     Purge   Expunge
***************************************************************************************************************
BOOKKEEPING_ACCOUNT_TYPES          171520
############################################################################################################################################

Databases: AUTEX.FDB
Time range: 2024-06-04 14:25:21 - 2024-06-04 14:25:43
Queries: 4288
 +----------- +----------- +----------- +
 |            |   Avarage  |     Total  |
 +----------- +----------- +----------- +
 |  time (ms) |          0 |          1 |
 |      reads |          0 |          0 |
 |    fetches |        156 |     668928 |
 |     writes |          0 |          0 |
 |      reads |          0 |          0 |
 |    records |          2 |       8576 |
 +----------- +----------- +----------- +
Sample SQL:
SELECT ba.BA_ID, ba.ACCOUNT_CODE1, ba.ACCOUNT_CODE2, ba.ACCOUNT_TYPE, bat.TYPE_NAME ACCOUNT_ABBR
    FROM BOOKKEEPING_ACCOUNTS ba
    JOIN BOOKKEEPING_ACCOUNT_TYPES bat ON(bat.TYPE_ID = ba.TYPE_ID)
    WHERE bat.IS_ACTIVE = 'T' AND bat.TYPE_NAME = 'PPES'  AND (bat.LOCATION_ID = 2 OR bat.LOCATION_ID IS NULL)

Table                             Natural     Index    Update    Insert    Delete   Backout     Purge   Expunge
***************************************************************************************************************
BOOKKEEPING_ACCOUNTS               162944
BOOKKEEPING_ACCOUNT_TYPES                    162944
############################################################################################################################################