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.
| 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 | 1 | |
| 6 | DESCRIBE `company` | 27 | 27 | 1 | |
| 7 | DESCRIBE `person` | 15 | 15 | 1 | |
| 8 | DESCRIBE `account` | 29 | 29 | 6 | |
| 9 | DESCRIBE `product_legacy` | 6 | 6 | 1 | |
| 10 | DESCRIBE `sales_people` | 6 | 6 | 1 | |
| 11 | DESCRIBE `profile` | 14 | 14 | 1 | |
| 12 | DESCRIBE `currencies` | 7 | 7 | 1 | |
| 13 | DESCRIBE `update_rec` | 7 | 7 | 1 | |
| 14 | DESCRIBE `dms_companies` | 26 | 26 | 1 | |
| 15 | DESCRIBE `dms_releases` | 10 | 10 | 1 | |
| 16 | DESCRIBE `dms_categories` | 4 | 4 | 1 | |
| 17 | DESCRIBE `dms_clinical_areas` | 4 | 4 | 1 | |
| 18 | DESCRIBE `dms_categories_dms_releases` | 2 | 2 | 1 | |
| 19 | DESCRIBE `dms_clinical_areas_dms_releases` | 2 | 2 | 1 | |
| 20 | DESCRIBE `dms_releases_sites` | 5 | 5 | 0 | |
| 21 | DESCRIBE `licopp` | 23 | 23 | 2 | |
| 22 | DESCRIBE `development_statuses` | 5 | 5 | 1 | |
| 23 | DESCRIBE `category` | 14 | 14 | 1 | |
| 24 | DESCRIBE `categories_sites` | 5 | 5 | 1 | |
| 25 | DESCRIBE `categorisation` | 8 | 8 | 1 | |
| 26 | DESCRIBE `licopps_sites` | 3 | 3 | 1 | |
| 27 | DESCRIBE `service` | 15 | 15 | 1 | |
| 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 | 1 | |
| 32 | DESCRIBE `story` | 12 | 12 | 1 | |
| 33 | DESCRIBE `sites_stories` | 5 | 5 | 1 | |
| 34 | DESCRIBE `story_assoc` | 4 | 4 | 1 | |
| 35 | DESCRIBE `companies_sites` | 3 | 3 | 0 | |
| 36 | DESCRIBE `categories_users` | 2 | 2 | 1 | |
| 37 | DESCRIBE `authority` | 3 | 3 | 2 | |
| 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 | 12 | |
| 41 | SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name | 11 | 11 | 0 | |
| 42 | SELECT c.uid, c.name FROM category c WHERE c.parent = 560 ORDER BY c.name | 20 | 20 | 0 | |
| 43 | SELECT feature_article.uid, feature_article.headline, feature_article.summary, feature_article.slug FROM feature_article WHERE feature_article.is_live > 0 AND feature_article.issued >= "2011-01-01 00:00:00" AND feature_article.issued <= "2011-12-31 23:59:59" GROUP BY feature_article.uid ORDER BY feature_article.viewed_counter DESC, feature_article.headline LIMIT 0, 10 | 1 | 1 | 5 | |
| 44 | SELECT count(DISTINCT feature_article.uid) AS total FROM feature_article WHERE feature_article.is_live > 0 AND feature_article.issued >= "2011-01-01 00:00:00" AND feature_article.issued <= "2011-12-31 23:59:59" | 1 | 1 | 6 |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `reports` | 17 | 17 | 1 |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `MarketResearchReport`.`id`, `MarketResearchReport`.`slug`, `MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`, `MarketResearchReport`.`pages`, `MarketResearchReport`.`published`, `MarketResearchReport`.`net_price_usd`, `MarketResearchReport`.`active`, `MarketResearchReport`.`publisher_id`, `MarketResearchReport`.`views`, `MarketResearchReport`.`tags`, `MarketResearchReport`.`created`, `MarketResearchReport`.`modified` FROM `reports` AS `MarketResearchReport` WHERE `MarketResearchReport`.`active` = 1 AND MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("2011") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("2011") DESC , MarketResearchReport.published DESC LIMIT 10 | 10 | 10 | 2 |