Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght` FROM `redminegit`.`acos` AS `Aco` WHERE 1 = 1 | 311 | 311 | 1 | |
SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `redminegit`.`aros` AS `Aro` WHERE `model` = 'Group' | 3 | 3 | 0 | |
SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `redminegit`.`acos` AS `Aco` JOIN `redminegit`.`aros_acos` AS `Permission` ON (`Permission`.`aro_id` IN (2, 4, 5) AND `Permission`.`aco_id` = `Aco`.`id`) | 449 | 449 | 2 | |
SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `redminegit`.`aros` AS `Aro` WHERE `model` = 'User' | 20 | 20 | 0 | |
SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `redminegit`.`acos` AS `Aco` JOIN `redminegit`.`aros_acos` AS `Permission` ON (`Permission`.`aro_id` IN (1, 3, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 22, 24, 25, 26) AND `Permission`.`aco_id` = `Aco`.`id`) | 0 | 0 | 0 | |
SELECT `Slider`.`id`, `Slider`.`image`, `Slider`.`heading`, `Slider`.`text`, `Slider`.`alternate_text`, `Slider`.`active`, `Slider`.`order` FROM `redminegit`.`slider_images` AS `Slider` WHERE `active` = '1' ORDER BY `order` ASC | 0 | 0 | 0 | |
SELECT `Content`.`lft`, `Content`.`rght` FROM `redminegit`.`content` AS `Content` WHERE `Content`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Content`.`id`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`keywords`, `Content`.`description`, `Content`.`title`, `Content`.`long_title`, `Content`.`header_bar`, `Content`.`body`, `Content`.`redirect`, `Content`.`icon`, `Content`.`created`, `Content`.`modified` FROM `redminegit`.`content` AS `Content` WHERE 1 = 1 AND `Content`.`lft` <= 3 AND `Content`.`rght` >= 4 ORDER BY `Content`.`lft` asc | 3 | 3 | 0 | |
SELECT `Content`.`id`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`lft`, `Content`.`rght`, `Content`.`keywords`, `Content`.`description`, `Content`.`title`, `Content`.`long_title`, `Content`.`header_bar`, `Content`.`body`, `Content`.`redirect`, `Content`.`icon`, `Content`.`created`, `Content`.`modified` FROM `redminegit`.`content` AS `Content` WHERE `title` = 'en' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Content`.`lft`, `Content`.`rght` FROM `redminegit`.`content` AS `Content` WHERE 1 = 1 AND `Content`.`id` = 100 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Content`.`id`, `Content`.`title`, `Content`.`long_title`, `Content`.`parent_id`, `Content`.`slug`, `Content`.`header_bar`, `Content`.`lft`, `Content`.`rght` FROM `redminegit`.`content` AS `Content` WHERE 1 = 1 AND `Content`.`rght` < 90 AND `Content`.`lft` > 2 ORDER BY `Content`.`lft` asc | 7 | 7 | 0 | |
SELECT `PricingPlan`.`id`, `PricingPlan`.`name`, `PricingPlan`.`active`, `PricingPlan`.`type`, `PricingPlan`.`data`, `PricingPlan`.`period`, `PricingPlan`.`created`, `PricingPlan`.`modified` FROM `redminegit`.`pricing_plan` AS `PricingPlan` WHERE `PricingPlan`.`active` = '1' AND `PricingPlan`.`type` = 1 LIMIT 6 | 4 | 4 | 0 | |
SELECT `PricingPlanService`.`id`, `PricingPlanService`.`pricing_plan_id`, `PricingPlanService`.`service_id`, `PricingPlanService`.`cost`, `PricingPlanService`.`quantity`, `PricingPlanService`.`name`, `PricingPlanService`.`type`, `PricingPlanService`.`active`, `PricingPlanService`.`period`, `PricingPlanService`.`data`, `PricingPlanService`.`created`, `PricingPlanService`.`modified` FROM `redminegit`.`pricing_plan_service` AS `PricingPlanService` WHERE `PricingPlanService`.`pricing_plan_id` IN (1, 2, 3, 5) | 4 | 4 | 0 | |