Buy

The terms query is:

Array
(
    [hide_empty] => 1
    [taxonomy] => pa_brand
    [count] => 1
    [number] => 100
    [orderby] => name
    [order] => ASC
)

terms found: 8

The Query Request Is:

SELECT  t.term_id
			 FROM wp_terms AS t  INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
			 WHERE tt.taxonomy IN ('pa_brand') AND tt.count > 0
			 ORDER BY t.name ASC
			 LIMIT 100

The finals query vars:

Array
(
    [taxonomy] => Array
        (
            [0] => pa_brand
        )

    [orderby] => name
    [order] => ASC
    [hide_empty] => 1
    [number] => 100
    [fields] => all
    [count] => 1
    [cache_domain] => core
    [cache_results] => 1
    [update_term_meta_cache] => 1
)

Query modify callbacks ( get_terms_args ):

Array
(
)

Query modify callbacks ( get_terms_orderby ):

Array
(
    [1] => Array
        (
            [0000000000000ca70000000000000000get_terms_orderby] => Array
                (
                    [function] => Array
                        (
                            [0] => TTO Object
                                (
                                    [functions] => 
                                )

                            [1] => get_terms_orderby
                        )

                    [accepted_args] => 2
                )

        )

)