Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Anken`.`id`, `Anken`.`name`, `Anken`.`title`, `Anken`.`contents`, `Anken`.`age`, `Anken`.`people`, `Anken`.`skill`, `Anken`.`note`, `Anken`.`company_id`, `Anken`.`employee_id`, `Anken`.`location_id`, `Anken`.`release_id`, `Anken`.`created`, `Anken`.`modified`, `Company`.`id`, `Company`.`name`, `Company`.`created`, `Company`.`modified`, `Employee`.`id`, `Employee`.`name`, `Employee`.`created`, `Employee`.`modified`, `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Release`.`id`, `Release`.`name`, `Release`.`created`, `Release`.`modified` FROM `imagine628_imaengineer`.`ankens` AS `Anken` LEFT JOIN `imagine628_imaengineer`.`companies` AS `Company` ON (`Anken`.`company_id` = `Company`.`id`) LEFT JOIN `imagine628_imaengineer`.`employees` AS `Employee` ON (`Anken`.`employee_id` = `Employee`.`id`) LEFT JOIN `imagine628_imaengineer`.`locations` AS `Location` ON (`Anken`.`location_id` = `Location`.`id`) LEFT JOIN `imagine628_imaengineer`.`releases` AS `Release` ON (`Anken`.`release_id` = `Release`.`id`) WHERE `Anken`.`id` = 21 LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `Feature`.`id`, `Feature`.`name`, `Feature`.`release_id`, `Feature`.`created`, `Feature`.`modified`, `AnkensFeature`.`id`, `AnkensFeature`.`anken_id`, `AnkensFeature`.`feature_id` FROM `imagine628_imaengineer`.`features` AS `Feature` JOIN `imagine628_imaengineer`.`ankens_features` AS `AnkensFeature` ON (`AnkensFeature`.`anken_id` = 21 AND `AnkensFeature`.`feature_id` = `Feature`.`id`) | 3 | 3 | 1 | maybe slow |
SELECT `Step`.`id`, `Step`.`name`, `Step`.`created`, `Step`.`modified`, `AnkensStep`.`id`, `AnkensStep`.`anken_id`, `AnkensStep`.`step_id` FROM `imagine628_imaengineer`.`steps` AS `Step` JOIN `imagine628_imaengineer`.`ankens_steps` AS `AnkensStep` ON (`AnkensStep`.`anken_id` = 21 AND `AnkensStep`.`step_id` = `Step`.`id`) | 2 | 2 | 1 | maybe slow |
SELECT `Period`.`id`, `Period`.`name`, `Period`.`created`, `Period`.`modified`, `AnkensPeriod`.`id`, `AnkensPeriod`.`anken_id`, `AnkensPeriod`.`period_id` FROM `imagine628_imaengineer`.`periods` AS `Period` JOIN `imagine628_imaengineer`.`ankens_periods` AS `AnkensPeriod` ON (`AnkensPeriod`.`anken_id` = 21 AND `AnkensPeriod`.`period_id` = `Period`.`id`) | 1 | 1 | 1 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`created`, `Category`.`modified`, `AnkensCategory`.`id`, `AnkensCategory`.`anken_id`, `AnkensCategory`.`category_id` FROM `imagine628_imaengineer`.`categories` AS `Category` JOIN `imagine628_imaengineer`.`ankens_categories` AS `AnkensCategory` ON (`AnkensCategory`.`anken_id` = 21 AND `AnkensCategory`.`category_id` = `Category`.`id`) | 2 | 2 | 1 | maybe slow |
SELECT `Type`.`id`, `Type`.`name`, `Type`.`created`, `Type`.`modified`, `AnkensType`.`id`, `AnkensType`.`anken_id`, `AnkensType`.`type_id` FROM `imagine628_imaengineer`.`types` AS `Type` JOIN `imagine628_imaengineer`.`ankens_types` AS `AnkensType` ON (`AnkensType`.`anken_id` = 21 AND `AnkensType`.`type_id` = `Type`.`id`) | 0 | 0 | 0 | |
SELECT `Start`.`id`, `Start`.`name`, `Start`.`created`, `Start`.`modified`, `AnkensStart`.`id`, `AnkensStart`.`anken_id`, `AnkensStart`.`start_id` FROM `imagine628_imaengineer`.`starts` AS `Start` JOIN `imagine628_imaengineer`.`ankens_starts` AS `AnkensStart` ON (`AnkensStart`.`anken_id` = 21 AND `AnkensStart`.`start_id` = `Start`.`id`) | 2 | 2 | 1 | maybe slow |
SELECT `Feature`.`id`, `Feature`.`name` FROM `imagine628_imaengineer`.`features` AS `Feature` WHERE 1 = 1 | 7 | 7 | 0 | |
SELECT `Step`.`id`, `Step`.`name` FROM `imagine628_imaengineer`.`steps` AS `Step` WHERE 1 = 1 | 8 | 8 | 0 | |
SELECT `Period`.`id`, `Period`.`name` FROM `imagine628_imaengineer`.`periods` AS `Period` WHERE 1 = 1 | 4 | 4 | 0 | |
SELECT `Category`.`id`, `Category`.`name` FROM `imagine628_imaengineer`.`categories` AS `Category` WHERE 1 = 1 | 19 | 19 | 0 | |
SELECT `Type`.`id`, `Type`.`name` FROM `imagine628_imaengineer`.`types` AS `Type` WHERE 1 = 1 | 10 | 10 | 0 | |
SELECT `Start`.`id`, `Start`.`name` FROM `imagine628_imaengineer`.`starts` AS `Start` WHERE 1 = 1 | 2 | 2 | 0 | |
SELECT `Company`.`id`, `Company`.`name` FROM `imagine628_imaengineer`.`companies` AS `Company` WHERE 1 = 1 | 24 | 24 | 0 | |
SELECT `Employee`.`id`, `Employee`.`name` FROM `imagine628_imaengineer`.`employees` AS `Employee` WHERE 1 = 1 | 3 | 3 | 0 | |
SELECT `Location`.`id`, `Location`.`name` FROM `imagine628_imaengineer`.`locations` AS `Location` WHERE 1 = 1 | 7 | 7 | 0 | |
SELECT `Release`.`id`, `Release`.`name` FROM `imagine628_imaengineer`.`releases` AS `Release` WHERE 1 = 1 | 2 | 2 | 0 | |