| 1 | DESCRIBE `licopp` | | 23 | 23 | 1 |
| 2 | DESCRIBE `company` | | 27 | 27 | 2 |
| 3 | DESCRIBE `condet` | | 17 | 17 | 3 |
| 4 | DESCRIBE `countrycode` | | 4 | 4 | 3 |
| 5 | DESCRIBE `person` | | 15 | 15 | 2 |
| 6 | DESCRIBE `account` | | 29 | 29 | 2 |
| 7 | DESCRIBE `product_legacy` | | 6 | 6 | 2 |
| 8 | DESCRIBE `sales_people` | | 6 | 6 | 2 |
| 9 | DESCRIBE `profile` | | 14 | 14 | 2 |
| 10 | DESCRIBE `currencies` | | 7 | 7 | 1 |
| 11 | DESCRIBE `update_rec` | | 7 | 7 | 1 |
| 12 | DESCRIBE `user` | | 24 | 24 | 4 |
| 13 | DESCRIBE `enquiry` | | 14 | 14 | 2 |
| 14 | DESCRIBE `module_types` | | 6 | 6 | 4 |
| 15 | DESCRIBE `dms_companies` | | 26 | 26 | 4 |
| 16 | DESCRIBE `dms_releases` | | 10 | 10 | 1 |
| 17 | DESCRIBE `dms_categories` | | 4 | 4 | 1 |
| 18 | DESCRIBE `dms_clinical_areas` | | 4 | 4 | 1 |
| 19 | DESCRIBE `dms_categories_dms_releases` | | 2 | 2 | 1 |
| 20 | DESCRIBE `dms_clinical_areas_dms_releases` | | 2 | 2 | 2 |
| 21 | DESCRIBE `dms_releases_sites` | | 5 | 5 | 4 |
| 22 | DESCRIBE `development_statuses` | | 5 | 5 | 2 |
| 23 | DESCRIBE `category` | | 14 | 14 | 3 |
| 24 | DESCRIBE `categories_sites` | | 5 | 5 | 2 |
| 25 | DESCRIBE `categorisation` | | 8 | 8 | 1 |
| 26 | DESCRIBE `licopps_sites` | | 3 | 3 | 3 |
| 27 | DESCRIBE `service` | | 15 | 15 | 4 |
| 28 | DESCRIBE `press_release` | | 13 | 13 | 2 |
| 29 | DESCRIBE `press_releases_sites` | | 5 | 5 | 3 |
| 30 | DESCRIBE `story` | | 12 | 12 | 5 |
| 31 | DESCRIBE `sites_stories` | | 5 | 5 | 2 |
| 32 | DESCRIBE `story_assoc` | | 4 | 4 | 2 |
| 33 | DESCRIBE `companies_sites` | | 3 | 3 | 2 |
| 34 | DESCRIBE `categories_users` | | 2 | 2 | 1 |
| 35 | DESCRIBE `authority` | | 3 | 3 | 1 |
| 36 | DESCRIBE `sites_users` | | 5 | 5 | 2 |
| 37 | DESCRIBE `sites` | | 5 | 5 | 3 |
| 38 | SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1 | | 1 | 1 | 1 |
| 39 | SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 297 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC | | 8 | 8 | 1 |
| 40 | SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (505, 303, 432, 319, 798, 453, 298, 805) ORDER BY `name` ASC | | 67 | 67 | 1 |
| 41 | SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 560 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC | | 20 | 20 | 1 |
| 42 | SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (1476, 561, 575, 582, 595, 603, 635, 616, 1477, 631, 641, 651, 562, 654, 662, 572, 1479, 670, 679, 689) ORDER BY `name` ASC | | 316 | 316 | 1 |
| 43 | SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name` FROM `development_statuses` AS `DevelopmentStatus` WHERE `id` = 6 | | 1 | 1 | 1 |
| 44 | SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`display_order` FROM `development_statuses` AS `DevelopmentStatus` WHERE `DevelopmentStatus`.`id` = 6 LIMIT 1 | | 1 | 1 | 0 |
| 45 | SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` IN (4156, 104, 4915, 4438, 1364, 223, 3221, 4342, 4242, 5073) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | | 133 | 133 | 10 |