Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Group`.`id`, `Group`.`code`, `Group`.`name`, `Group`.`order`, `Group`.`status`, `Group`.`created`, `Group`.`modified` FROM `itenderdb`.`groups` AS `Group` WHERE `Group`.`code` = 'public' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `itenderdb`.`aros` AS `Aro` INNER JOIN `itenderdb`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'Group' AND `Aro0`.`foreign_key` = 2 ORDER BY `Aro`.`lft` DESC | 1 | 1 | 1 | |
SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias` FROM `itenderdb`.`acos` AS `Aco` INNER JOIN `itenderdb`.`acos` AS `Aco0` ON (`Aco0`.`alias` = 'controllers') INNER JOIN `itenderdb`.`acos` AS `Aco1` ON (`Aco1`.`alias` = 'TenderDocs') INNER JOIN `itenderdb`.`acos` AS `Aco2` ON (`Aco2`.`alias` = 'index') WHERE ((`Aco`.`lft` <= `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) AND `Aco0`.`id` = `Aco1`.`parent_id` AND `Aco1`.`rght` < `Aco0`.`rght` AND `Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`id` = `Aco2`.`parent_id` AND `Aco2`.`rght` < `Aco1`.`rght` AND `Aco2`.`lft` > `Aco1`.`lft` ORDER BY `Aco`.`lft` DESC | 3 | 3 | 1 | maybe slow |
SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `itenderdb`.`aros_acos` AS `Permission` LEFT JOIN `itenderdb`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `itenderdb`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = 2 AND `Permission`.`aco_id` IN (161, 160, 1) ORDER BY `Aco`.`lft` desc | 1 | 1 | 1 | |
SELECT `TenderDoc`.`id`, `TenderDoc`.`type_id`, `TenderDoc`.`title`, `TenderDoc`.`tender_no`, `TenderDoc`.`tender_pa`, `TenderDoc`.`tender_pr`, `TenderDoc`.`tender_po`, `TenderDoc`.`price`, `TenderDoc`.`tender_info`, `TenderDoc`.`tender_requirements_info`, `TenderDoc`.`tender_briefing`, `TenderDoc`.`reg_start_date`, `TenderDoc`.`reg_end_date`, `TenderDoc`.`inform_date`, `TenderDoc`.`sitevisit_start_date`, `TenderDoc`.`sitevisit_end_date`, `TenderDoc`.`sales_period_start`, `TenderDoc`.`sales_period_end`, `TenderDoc`.`closing_date_time`, `TenderDoc`.`category`, `TenderDoc`.`contact_officers`, `TenderDoc`.`mntstaffemail_id`, `TenderDoc`.`status_id`, `TenderDoc`.`reason`, `TenderDoc`.`webtender_no`, `TenderDoc`.`webtitle`, `TenderDoc`.`webstatus`, `TenderDoc`.`flag_correction`, `TenderDoc`.`publish_only`, `TenderDoc`.`approved`, `TenderDoc`.`approved_by`, `TenderDoc`.`created`, `TenderDoc`.`created_by`, `TenderDoc`.`modified`, `TenderDoc`.`modified_by`, (CONCAT(`TenderDoc`.`tender_no`, " - ", `TenderDoc`.`title`)) AS `TenderDoc__select_viewdocsbynotitle`, `Status`.`id`, `Status`.`name`, `Status`.`information`, `Status`.`status_id`, `Status`.`type`, `Status`.`created`, `Status`.`created_by`, `Status`.`modified`, `Status`.`modified_by`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`status`, `User`.`usertype_id`, `User`.`source`, `User`.`expired`, `User`.`ldap`, `User`.`created`, `User`.`modified`, `user_approved`.`id`, `user_approved`.`username`, `user_approved`.`password`, `user_approved`.`name`, `user_approved`.`email`, `user_approved`.`status`, `user_approved`.`usertype_id`, `user_approved`.`source`, `user_approved`.`expired`, `user_approved`.`ldap`, `user_approved`.`created`, `user_approved`.`modified`, `Type`.`id`, `Type`.`name`, `Type`.`information`, `Type`.`category`, `Type`.`status_id`, `MntStaffEmail`.`id`, `MntStaffEmail`.`name`, `MntStaffEmail`.`email`, `MntStaffEmail`.`department`, `MntStaffEmail`.`office_phone`, `MntStaffEmail`.`mobile_phone`, `MntStaffEmail`.`extra_info`, `MntStaffEmail`.`status_id`, `MntStaffEmail`.`created`, `MntStaffEmail`.`created_by`, `MntStaffEmail`.`modified`, `MntStaffEmail`.`modified_by`, (CONCAT(`MntStaffEmail`.`name`, " - ", `MntStaffEmail`.`email`)) AS `MntStaffEmail__staffbynameemail` FROM `itenderdb`.`tender_docs` AS `TenderDoc` LEFT JOIN `itenderdb`.`statuses` AS `Status` ON (`TenderDoc`.`status_id` = `Status`.`id`) LEFT JOIN `itenderdb`.`users` AS `User` ON (`TenderDoc`.`created_by` = `User`.`id`) LEFT JOIN `itenderdb`.`users` AS `user_approved` ON (`TenderDoc`.`approved_by` = `user_approved`.`id`) LEFT JOIN `itenderdb`.`types` AS `Type` ON (`TenderDoc`.`Type_id` = `Type`.`id`) LEFT JOIN `itenderdb`.`mnt_staff_email` AS `MntStaffEmail` ON (`TenderDoc`.`mntstaffemail_id` = `MntStaffEmail`.`id`) WHERE `TenderDoc`.`reg_end_date` >= '2025-09-07 12:40:18' AND `TenderDoc`.`status_id` = 1 ORDER BY `TenderDoc`.`flag_correction` desc LIMIT 5 | 0 | 0 | 1 | maybe slow |
SELECT `Menu`.`id`, `Menu`.`name`, `Menu`.`sidebar`, `Menu`.`alias`, `Menu`.`layout`, `Menu`.`link_count`, `Menu`.`status`, `Menu`.`created`, `Menu`.`modified` FROM `itenderdb`.`menus` AS `Menu` WHERE FIND_IN_SET('default',`Menu`.`layout`) | 1 | 1 | 0 | |
SELECT `Link`.`id`, `Link`.`name`, `Link`.`type`, `Link`.`url`, `Link`.`icon`, `Link`.`aco_id`, `Link`.`parent_id`, `Link`.`menu_id`, `Link`.`lft`, `Link`.`rght`, `Link`.`params`, `Link`.`status`, `Link`.`created`, `Link`.`modified`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `itenderdb`.`links` AS `Link` LEFT JOIN `itenderdb`.`acos` AS `Aco` ON (`Link`.`aco_id` = `Aco`.`id`) WHERE `Link`.`menu_id` = 2 ORDER BY `Link`.`lft` ASC, `Link`.`rght` ASC | 8 | 8 | 1 | maybe slow |
SELECT `Aro`.`id` FROM `itenderdb`.`aros` AS `Aro` WHERE `Aro`.`model` = 'Group' AND `Aro`.`foreign_key` = (2) | 1 | 1 | 1 | |
SELECT `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete`, `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght`, `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `itenderdb`.`aros_acos` AS `Permission` LEFT JOIN `itenderdb`.`aros` AS `Aro` ON (`Permission`.`aro_id` = `Aro`.`id`) LEFT JOIN `itenderdb`.`acos` AS `Aco` ON (`Permission`.`aco_id` = `Aco`.`id`) WHERE `Permission`.`aro_id` = (2) ORDER BY `Aco`.`lft` ASC, `Aco`.`rght` ASC | 11 | 11 | 1 | maybe slow |
SELECT COUNT(*) AS `count` FROM `itenderdb`.`alerts` AS `Alert` LEFT JOIN `itenderdb`.`users` AS `User` ON (`Alert`.`user_id` = `User`.`id`) WHERE `Alert`.`user_id` IS NULL AND `Alert`.`read` = 0 | 1 | 1 | 1 | |
SELECT `Alert`.`id`, `Alert`.`title`, `Alert`.`url`, `Alert`.`icon`, `Alert`.`color`, `Alert`.`user_id`, `Alert`.`read`, `Alert`.`created`, `Alert`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`status`, `User`.`usertype_id`, `User`.`source`, `User`.`expired`, `User`.`ldap`, `User`.`created`, `User`.`modified` FROM `itenderdb`.`alerts` AS `Alert` LEFT JOIN `itenderdb`.`users` AS `User` ON (`Alert`.`user_id` = `User`.`id`) WHERE `Alert`.`user_id` IS NULL AND `Alert`.`read` = 0 | 6 | 6 | 1 | maybe slow |