** Dashboard

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

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

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

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

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

sql: SHOW TABLE STATUS WHERE Engine = 'MyISAM' AND Name = 'admin', executionMS: 0.0016229152679443

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

sql: SELECT `url` FROM `portal_setup` where `portal_setup`.`url` like '%office.woolindia.in%' limit 1, executionMS: 0.00047588348388672

sql: SELECT `id` FROM `portal_setup` where `portal_setup`.`admin_url` like '%office.woolindia.in%' || `portal_setup`.`url` like '%office.woolindia.in%' limit 1, executionMS: 0.00013494491577148

sql: SELECT `name` FROM `portal_info` where `id` = '200000' limit 1, executionMS: 0.00049710273742676

sql: SELECT ifnull((SELECT `footer_line_be` FROM `portal_setup` where `admin_url` like '%office.woolindia.in%' || '%office.woolindia.in%' like `url` limit 1),'©2024 Integer Systems. All rights reserved. Helpline +91 9829221171'), executionMS: 0.0001518726348877

sql: SELECT `pd_byepass` FROM `portal_setup` Limit 1, executionMS: 0.00011277198791504

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

sql: SELECT `default_page` from `portal_setup` where `id` = 200000, executionMS: 0.00016689300537109

sql: SELECT `dashboard` from `portal_setup` where `id` = 200000, executionMS: 0.00010490417480469

sql: SELECT `html` FROM `home` limit 1, executionMS: 0.00072813034057617

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` = 4 || `group_by` = 0) and `id` != 4 and `id` > 0 ORDER BY order_by ASC, executionMS: 0.0010781288146973

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(4, `group_by`) and (`item_group` = 2) and `id` != 4 ORDER BY order_by ASC, executionMS: 0.00036287307739258

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(4, `group_by`) and (`item_group` = 3) and `id` != 4 ORDER BY order_by ASC, executionMS: 0.00029110908508301

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.0006251335144043

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(4, `group_by`) and ifnull(`sub_group_by`,0) = 0 ORDER BY order_by ASC, executionMS: 0.00033092498779297

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(4, `group_by`) and (`item_group` = 5) and `group_by` = 5 and `id` != 4 ORDER BY order_by ASC, executionMS: 0.00034284591674805