| 1 | DESCRIBE `projects` | | 22 | 22 | 1 |
| 2 | DESCRIBE `project_categories` | | 3 | 3 | 0 |
| 3 | DESCRIBE `project_select_categories` | | 4 | 4 | 0 |
| 4 | DESCRIBE `project_urls` | | 4 | 4 | 0 |
| 5 | SELECT `Project`.`id`, `Project`.`display_order`, `Project`.`client_id`, `Project`.`name`, `Project`.`description`, `Project`.`mindgenies_display_status`, `Project`.`status`, `Project`.`notes`, `Project`.`created_date`, `Project`.`type`, `Project`.`attachment`, `Project`.`created`, `Project`.`modified`, `Project`.`keyword`, `Project`.`tags`, `Project`.`liveurl`, `Project`.`session_id`, `Project`.`team_member`, `Project`.`tot_bug`, `Project`.`seo_title`, `Project`.`meta_description`, `Project`.`meta_keyword` FROM `projects` AS `Project` WHERE `Project`.`id` = "349" | | 1 | 1 | 0 |
| 6 | DESCRIBE `project_images` | | 7 | 7 | 1 |
| 7 | SELECT `ProjectImage`.`id`, `ProjectImage`.`project_id`, `ProjectImage`.`large_image`, `ProjectImage`.`thumb_image`, `ProjectImage`.`created`, `ProjectImage`.`modified`, `ProjectImage`.`status` FROM `project_images` AS `ProjectImage` WHERE `ProjectImage`.`project_id` = 349 | | 2 | 2 | 0 |
| 8 | DESCRIBE `project_select_keywords` | | 4 | 4 | 0 |
| 9 | SELECT `Keywords`.`keyword` FROM `project_select_keywords` AS `ProjectSelectKeyword` inner JOIN keywords AS `Keywords` ON (`ProjectSelectKeyword`.`keyword_id` = `Keywords`.`id`) WHERE project_id = 349 | | 2 | 2 | 0 |
| 10 | SELECT `PC`.`name` FROM `project_select_categories` AS `ProjectSelectCategory` inner JOIN project_categories AS `PC` ON (`ProjectSelectCategory`.`category_id` = `PC`.`id`) WHERE project_id = 349 | | 3 | 3 | 1 |
| 11 | DESCRIBE `project_users` | | 7 | 7 | 1 |
| 12 | SELECT `ProjectUser`.`id`, `ProjectUser`.`user_name`, `ProjectUser`.`password`, `ProjectUser`.`url`, `ProjectUser`.`user_type`, `ProjectUser`.`project_id`, `ProjectUser`.`user_type_flag` FROM `project_users` AS `ProjectUser` WHERE project_id = 349 and user_type_flag = 2 | | 1 | 1 | 0 |
| 13 | SELECT `ProjectUrl`.`id`, `ProjectUrl`.`page_name`, `ProjectUrl`.`page_url`, `ProjectUrl`.`project_id` FROM `project_urls` AS `ProjectUrl` WHERE project_id = 349 | | 0 | 0 | 2 |
| 14 | DESCRIBE `keywords` | | 3 | 3 | 1 |
| 15 | SELECT `Tag`.*, count(`PST`.`project_id`) as totalProjects FROM `keywords` AS `Tag` inner JOIN project_select_keywords AS `PST` ON (`Tag`.`id` = `PST`.`keyword_id`) WHERE 1 = 1 GROUP BY `Tag`.`id` ORDER BY `Tag`.`id` ASC | | 26 | 26 | 0 |