Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Innovaro Pharmalicensing brings you advice, commentary and analysis from industry experts.
Would you like to see your article or company featured in the Innovaro Pharmalicensing articles pages? Submit your proposals, or email us with requests for articles on specific topics.
You must be a Pharmalicensing Intelligence subscriber to submit articles.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `feature_article` | 13 | 13 | 1 | |
| 2 | DESCRIBE `feature_author` | 13 | 13 | 1 | |
| 3 | DESCRIBE `user` | 24 | 24 | 1 | |
| 4 | DESCRIBE `condet` | 17 | 17 | 1 | |
| 5 | DESCRIBE `countrycode` | 4 | 4 | 3 | |
| 6 | DESCRIBE `company` | 27 | 27 | 3 | |
| 7 | DESCRIBE `person` | 15 | 15 | 1 | |
| 8 | DESCRIBE `account` | 29 | 29 | 2 | |
| 9 | DESCRIBE `product_legacy` | 6 | 6 | 1 | |
| 10 | DESCRIBE `sales_people` | 6 | 6 | 2 | |
| 11 | DESCRIBE `profile` | 14 | 14 | 4 | |
| 12 | DESCRIBE `currencies` | 7 | 7 | 2 | |
| 13 | DESCRIBE `update_rec` | 7 | 7 | 2 | |
| 14 | DESCRIBE `dms_companies` | 26 | 26 | 3 | |
| 15 | DESCRIBE `dms_releases` | 10 | 10 | 2 | |
| 16 | DESCRIBE `dms_categories` | 4 | 4 | 1 | |
| 17 | DESCRIBE `dms_clinical_areas` | 4 | 4 | 2 | |
| 18 | DESCRIBE `dms_categories_dms_releases` | 2 | 2 | 5 | |
| 19 | DESCRIBE `dms_clinical_areas_dms_releases` | 2 | 2 | 0 | |
| 20 | DESCRIBE `dms_releases_sites` | 5 | 5 | 1 | |
| 21 | DESCRIBE `licopp` | 23 | 23 | 6 | |
| 22 | DESCRIBE `development_statuses` | 5 | 5 | 1 | |
| 23 | DESCRIBE `category` | 14 | 14 | 1 | |
| 24 | DESCRIBE `categories_sites` | 5 | 5 | 3 | |
| 25 | DESCRIBE `categorisation` | 8 | 8 | 1 | |
| 26 | DESCRIBE `licopps_sites` | 3 | 3 | 1 | |
| 27 | DESCRIBE `service` | 15 | 15 | 3 | |
| 28 | DESCRIBE `enquiry` | 14 | 14 | 1 | |
| 29 | DESCRIBE `module_types` | 6 | 6 | 1 | |
| 30 | DESCRIBE `press_release` | 13 | 13 | 1 | |
| 31 | DESCRIBE `press_releases_sites` | 5 | 5 | 0 | |
| 32 | DESCRIBE `story` | 12 | 12 | 4 | |
| 33 | DESCRIBE `sites_stories` | 5 | 5 | 1 | |
| 34 | DESCRIBE `story_assoc` | 4 | 4 | 1 | |
| 35 | DESCRIBE `companies_sites` | 3 | 3 | 2 | |
| 36 | DESCRIBE `categories_users` | 2 | 2 | 3 | |
| 37 | DESCRIBE `authority` | 3 | 3 | 24 | |
| 38 | DESCRIBE `sites_users` | 5 | 5 | 1 | |
| 39 | DESCRIBE `sites` | 5 | 5 | 1 | |
| 40 | 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 | |
| 41 | SELECT uid, name FROM category WHERE parent = 297 AND (restricted = "C" OR restricted IS NULL) ORDER BY name | 11 | 11 | 22 | |
| 42 | SELECT uid, name FROM category WHERE parent = 560 AND (restricted = "C" OR restricted IS NULL) ORDER BY name | 20 | 20 | 1 | |
| 43 | SELECT fa.uid, fa.headline FROM feature_author fa ORDER BY fa.headline | 73 | 73 | 1 | |
| 44 | SELECT Article.uid,Article.slug,Article.headline,Article.summary,Article.viewed_counter FROM feature_article AS Article WHERE Article.is_live>0 GROUP BY Article.uid ORDER BY viewed_counter DESC, Article.headline LIMIT 5 | 5 | 5 | 6 | |
| 45 | SELECT `Article`.`uid`, `Article`.`slug`, `Article`.`issued`, `Article`.`headline`, `Article`.`summary`, `Category`.`uid` FROM `feature_article` AS `Article` LEFT JOIN categorisation AS `Categorisation` ON (`Categorisation`.`story_id` = `Article`.`uid`) LEFT JOIN category AS `Category` ON (`Category`.`uid` = `Categorisation`.`category_id`) LEFT JOIN `feature_author` AS `Author` ON (`Article`.`author` = `Author`.`uid`) LEFT JOIN `user` AS `User` ON (`Article`.`user_id` = `User`.`uid`) WHERE `Article`.`is_live` = 1 AND `Article`.`issued` <= '2012-05-17T03:00:14' GROUP BY `Article`.`uid` ORDER BY `Article`.`issued` DESC LIMIT 5 | 5 | 5 | 133 | |
| 46 | 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`.`story_id` IN ('1320403760_4eb3c330c8165', '1288873128_4cd2a4a89f3e9', '1281112259_4c5c38c30dfa9', '1256664303_4ae72cef092f9', '1263552474_4b5047da07a48') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="F" ORDER BY `Category`.`lft` ASC | 12 | 12 | 1 | |
| 47 | SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name | 11 | 11 | 0 | |
| 48 | SELECT c.uid, c.name FROM category c WHERE c.parent = 560 ORDER BY c.name | 20 | 20 | 1 | |
| 49 | SELECT DISTINCT SUBSTRING(issued, 1, 4) AS publication_year FROM feature_article AS Article WHERE is_live = 1 AND issued IS NOT NULL ORDER BY publication_year DESC | 13 | 13 | 0 |