Array
(
)

Array
(
    [order] => lname,fname|ASC
)

Array
(
    [before] => Closure Object
        (
        )

    [segment] => Array
        (
            [0] => profiles
        )

    [route] => /profiles
    [template] => front/themes/master/profiles.tpl.php
)

1. select | total: 1 . SELECT * FROM `settings` WHERE id = 1 ;

2. count | total: 181 . SELECT COUNT(*) AS NUMROWS FROM `users`;

3. SELECT | total: 12 . SELECT *,u.id as id,  u.active as active, CONCAT(fname,' ',lname) as fullname, u.lname, u.fname, m.title_en as mtitle, m.thumb
                  FROM   `users` as u
                  LEFT JOIN memberships as m on m.id = u.membership_id
                  WHERE (type in ( 'member','family'))
                  
                  ORDER BY lname  ASC,fname  ASC LIMIT 0,12

4. select | total: 16 . SELECT * FROM `menus` WHERE active = 1 ORDER BY parent_id, position;

5. SELECT | total: 12 . SELECT *,u.id as id,  u.active as active, CONCAT(fname,' ',lname) as fullname, u.lname, u.fname, m.title_en as mtitle, m.thumb
                  FROM   `users` as u
                  LEFT JOIN memberships as m on m.id = u.membership_id
                  WHERE (type in ( 'member','family'))
                  
                  ORDER BY lname  ASC,fname  ASC LIMIT 0,12