** Dashboard

sql: SET time_zone = '+05:30', executionMS: 0.0001060962677002

sql: SELECT COUNT(*) FROM userlevels WHERE userlevelid = -2, executionMS: 0.00079703330993652

sql: SELECT userlevelid, userlevelname FROM userlevels, executionMS: 0.00017118453979492

sql: SELECT COUNT(*) FROM userlevelpermissions WHERE userlevelid = -2, executionMS: 0.010271072387695

sql: SELECT tablename, userlevelid, permission FROM userlevelpermissions WHERE userlevelid IN (-2), executionMS: 0.010390043258667

sql: SHOW TABLE STATUS WHERE Engine = 'MyISAM' AND Name = 'admin_office', executionMS: 0.0015020370483398

sql: SELECT `code` FROM `apc_pfv` WHERE `id`=1 LIMIT 1, executionMS: 0.00061893463134766

sql: SET @@group_concat_max_len = 1000000;, executionMS: 0.00034594535827637

sql: SELECT `icon`, `image`, `title` as Title, `sub_title` as `Sub_Title`, replace(replace(`url_link`, '_', ''),'.php','') as url, `code`, `user_level`,`group_by`, `target_window` FROM `dashboard` WHERE `status`=1 and (`item_group` = 0) and (`group_by` = 5 || `group_by` = 0) and `id` != 5 and `id` > 0 ORDER BY order_by ASC, executionMS: 0.00080394744873047

sql: SELECT concat((SELECT concat('Today: ', count(`id`), ' / ') FROM `calendar` WHERE `start` > CURRENT_DATE and `start` < Date_add(CURRENT_DATE, Interval 1 Day)), (SELECT concat('Old: ', count(`id`), ' Tasks') FROM `calendar` WHERE `start` < CURRENT_DATE)) as `OTask`, executionMS: 0.0027031898498535

sql: SELECT `icon`, `image`, `title` as Title, `sub_title` as `Sub_Title`, replace(replace(`url_link`, '_', ''),'.php','') as url, `code`, `user_level`,`group_by`, `target_window` FROM `dashboard` WHERE FIND_IN_SET(-2, `user_level`) and status=1 and FIND_IN_SET(5, `group_by`) and (`item_group` = 2) and `id` != 5 ORDER BY order_by ASC, executionMS: 0.00045919418334961

sql: SELECT `icon`, `image`, `title` as Title, `sub_title` as `Sub_Title`, replace(replace(`url_link`, '_', ''),'.php','') as url, `code`, `user_level`,`group_by`, `target_window` FROM `dashboard` WHERE FIND_IN_SET(-2, `user_level`) and status=1 and FIND_IN_SET(5, `group_by`) and (`item_group` = 3) and `id` != 5 ORDER BY order_by ASC, executionMS: 0.00042486190795898

sql: SELECT distinct ifnull(`sub_group_by`,0) as `sgrp`, if(`sub_group_by` = 0, '', concat(' (',(select `d`.`title` from `dashboard` `d` where `d`.`id` = `dashboard`.`sub_group_by`), ')')) as `rtitle` FROM `dashboard` WHERE FIND_IN_SET(-2, `user_level`) and status=1 group by `sub_group_by` ORDER BY ifnull(`sub_group_by`,0), order_by ASC, executionMS: 0.00062012672424316

sql: SELECT `icon`, `image`, `title` as Title, `sub_title` as `Sub_Title`, replace(replace(`url_link`, '_', ''),'.php','') as url, `code`, `user_level`, `group_by`, `target_window` FROM `dashboard` WHERE FIND_IN_SET(-2, `user_level`) and status=1 and `item_group` = 4 and find_in_set(5, `group_by`) and ifnull(`sub_group_by`,0) = 0 ORDER BY order_by ASC, executionMS: 0.00041794776916504

sql: SELECT `icon`, `image`, `title` as Title, `sub_title` as `Sub_Title`, replace(replace(`url_link`, '_', ''),'.php','') as url, `code`, `user_level`,`group_by`, `target_window` FROM `dashboard` WHERE FIND_IN_SET(-2, `user_level`) and status=1 and FIND_IN_SET(5, `group_by`) and (`item_group` = 5) and `group_by` = 5 and `id` != 5 ORDER BY order_by ASC, executionMS: 0.00033998489379883

sql: SELECT gallery.id, gallery.grp, DATE_FORMAT(date, '%d-%m-%Y') as dated, description, detailed_description, image, video_link, gallery.category FROM gallery WHERE 1=1 GROUP BY grp ORDER BY date DESC LIMIT 3 OFFSET 0, executionMS: 0.00023794174194336

sql: SELECT id, item FROM gallery_misc WHERE `grp` = 11 ORDER BY item ASC, executionMS: 0.0001978874206543

sql: SELECT COUNT(DISTINCT grp) FROM gallery WHERE 1=1 , executionMS: 8.6784362792969E-5