Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]

        if ($this->_init && !is_writable($this->settings['path'])) {
            $this->_init = false;
            trigger_error(sprintf(__('%s is not writable', true), $this->settings['path']), E_USER_WARNING);

FileEngine::__active() - CORE/cake/libs/cache/file.php, line 267
FileEngine::init() - CORE/cake/libs/cache/file.php, line 94
Cache::_buildEngine() - CORE/cake/libs/cache.php, line 151
Cache::config() - CORE/cake/libs/cache.php, line 126
include - /home/pharma/website/releases/20120317114903/cakephp/app/pharmalicensing/config/core.php, line 345
Configure::__loadBootstrap() - CORE/cake/libs/configure.php, line 391
Configure::getInstance() - CORE/cake/libs/configure.php, line 52
include - CORE/cake/bootstrap.php, line 38
[main] - /home/pharma/website/releases/20120317114903/cakephp/webroot/pharmalicensing/index.php, line 100

Articles

Innovaro Pharmalicensing brings you advice, commentary and analysis from industry experts.

Articles
Browse

Articles

Displaying 1..3 of 3 - per page
Order by

A Tour around Periodontal Disease

Which do you think is the most common disease in the world - heart disease, cancer, osteoarthritis? Well, the dubious honour goes to periodontal disease. More

A tour around ENT disease

Many Ear, Nose and Throat (ENT) problems are treated surgically. However, pharmaceutical executives can't afford to ignore ENT More

A Tour around Conditions of the Retina

The retina plays a vital role in the sensation of vision, converting light into electrical impulses which are carried by the optic nerve to the brain, where they are interpreted to create a mental image of the field of view. More

Displaying 1..3 of 3 - per page
Order by

Related Reports

Market Research Reports provided by reports.innovaro.com

Wrigley's 5 Gum Case Study: remaining competitive in the gum market through a multi-sensory offering

Aug 2009 - 10 pages - $295

Deals and alliances in sensory and dental diseases

Jun 2006 - 422 pages - $2,495

Clinical Stage Partnering Terms and Agreements in Pharma, Biotech and Diagnostics

Apr 2010 - 510 pages - $2,695

Peripheral Neuropathy (Sensory Neuropathy) - Pipeline Review, H2 2011

Oct 2011 - 64 pages - $500

Personalized Medicine Partnering Terms and Agreements

Apr 2011 - 951 pages - $4,995

Manufacturing and Supply Partnering Terms and Agreements in Pharma, Biotech and Diagnostics

Oct 2010 - 598 pages - $2,695

Immunosuppressants, Organ Transplants, and the Potential of Regenerative Medicine

Sep 2010 - 118 pages - $3,835

Premium Company Profile: Givaudan SA

Feb 2008 - 44 pages - $495

TransMedics, Inc. - Product Pipeline Analysis

Mar 2011 - 21 pages - $750

South Beach case study: positioning healthier food as a lifestyle choice

Jun 2008 - 9 pages - $295

Your selection

Therapeutic target: Sensory organ del

Browse By

Industry sector: Academic/Research; Animal health; Biotechnology; Diagnostic; Drug delivery; Drug discovery; Medical device; Non-profit org./Government; Pharmaceutical; Research tools; Service
Therapeutic target: Auditory; Opthalmic
Year: 2011; 2010; 2009; 2008; 2007; 2006; 2005; 2004; 2003; 2002; 2001; 2000; 1999

Products:	Partnering Search	Company Profiling	Pharmalicensing Intelligence	Reports	Comparision
In-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Out-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Companies:	Profiled companies	Industry Sector	Therapeutic Target	Geographic Location	Search	Add your company
Reports:	Biotechnology	Business Development	Management	Market & Sales	Medical Devices	Pharmaceuticals
News:	Deals & Alliances	Development	Financial Results	Financings	Intellectual Property	Regulatory
Events:	Pharma events	Calendar	Organizers	Featured events	Search
Articles:	Industrial Sector	Therapeutic Target	Articles date
Deals:	Industry Sector	Therapeutic Target	Deals Date	Search	Reports	Press releases
About us:	Our Audience	Case Studies	Newsletter	FAQ	Contact us	Site map

Products:

Partnering Search

Company Profiling

Pharmalicensing Intelligence

Intellectual Property

(website) 47 queries took 172 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `feature_article`	13	13	2
2	DESCRIBE `feature_author`	13	13	1
3	DESCRIBE `user`	24	24	2
4	DESCRIBE `condet`	17	17	2
5	DESCRIBE `countrycode`	4	4	1
6	DESCRIBE `company`	27	27	1
7	DESCRIBE `person`	15	15	40
8	DESCRIBE `account`	29	29	2
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	2
15	DESCRIBE `dms_releases`	10	10	1
16	DESCRIBE `dms_categories`	4	4	2
17	DESCRIBE `dms_clinical_areas`	4	4	2
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	1
21	DESCRIBE `licopp`	23	23	2
22	DESCRIBE `development_statuses`	5	5	2
23	DESCRIBE `category`	14	14	2
24	DESCRIBE `categories_sites`	5	5	2
25	DESCRIBE `categorisation`	8	8	1
26	DESCRIBE `licopps_sites`	3	3	2
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	3
31	DESCRIBE `press_releases_sites`	5	5	1
32	DESCRIBE `story`	12	12	2
33	DESCRIBE `sites_stories`	5	5	1
34	DESCRIBE `story_assoc`	4	4	1
35	DESCRIBE `companies_sites`	3	3	1
36	DESCRIBE `categories_users`	2	2	1
37	DESCRIBE `authority`	3	3	1
38	DESCRIBE `sites_users`	5	5	1
39	DESCRIBE `sites`	5	5	2
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 c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name	11	11	1
42	SELECT c.uid, c.name FROM category c WHERE c.parent = 689 ORDER BY c.name	2	2	0
43	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
44	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 689	1	1	1
45	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "4157" AND c.rgt >= "4196" AND c.level > 1 ORDER BY c.level	1	1	1
46	SELECT feature_article.uid, feature_article.headline, feature_article.summary, feature_article.slug FROM feature_article INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = feature_article.uid AND tt_ctg.cat_type = "F" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 4157 AND rgt <= 4196) ) WHERE feature_article.is_live > 0 GROUP BY feature_article.uid ORDER BY feature_article.viewed_counter DESC, feature_article.headline LIMIT 0, 10	3	3	48
47	SELECT count(DISTINCT feature_article.uid) AS total FROM feature_article INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = feature_article.uid AND tt_ctg.cat_type = "F" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 4157 AND rgt <= 4196) ) WHERE feature_article.is_live > 0	1	1	26

(website) 47 queries took 172 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `feature_article`

DESCRIBE `feature_author`

DESCRIBE `user`

DESCRIBE `condet`

DESCRIBE `countrycode`

DESCRIBE `company`

DESCRIBE `person`

DESCRIBE `account`

DESCRIBE `product_legacy`

DESCRIBE `sales_people`

DESCRIBE `profile`

DESCRIBE `currencies`

DESCRIBE `update_rec`

DESCRIBE `dms_companies`

DESCRIBE `dms_releases`

DESCRIBE `dms_categories`

DESCRIBE `dms_clinical_areas`

DESCRIBE `dms_categories_dms_releases`

DESCRIBE `dms_clinical_areas_dms_releases`

DESCRIBE `dms_releases_sites`

DESCRIBE `licopp`

DESCRIBE `development_statuses`

DESCRIBE `category`

DESCRIBE `categories_sites`

DESCRIBE `categorisation`

DESCRIBE `licopps_sites`

DESCRIBE `service`

DESCRIBE `enquiry`

DESCRIBE `module_types`

DESCRIBE `press_release`

DESCRIBE `press_releases_sites`

DESCRIBE `story`

DESCRIBE `sites_stories`

DESCRIBE `story_assoc`

DESCRIBE `companies_sites`

DESCRIBE `categories_users`

DESCRIBE `authority`

DESCRIBE `sites_users`

DESCRIBE `sites`

SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1

SELECT c.uid, c.name FROM category c WHERE c.parent = 297 ORDER BY c.name

SELECT c.uid, c.name FROM category c WHERE c.parent = 689 ORDER BY c.name

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

SELECT c.lft, c.rgt FROM category c WHERE c.uid = 689

SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "4157" AND c.rgt >= "4196" AND c.level > 1 ORDER BY c.level

SELECT feature_article.uid, feature_article.headline, feature_article.summary, feature_article.slug FROM feature_article INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = feature_article.uid AND tt_ctg.cat_type = "F" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 4157 AND rgt <= 4196) ) WHERE feature_article.is_live > 0 GROUP BY feature_article.uid ORDER BY feature_article.viewed_counter DESC, feature_article.headline LIMIT 0, 10

SELECT count(DISTINCT feature_article.uid) AS total FROM feature_article INNER JOIN categorisation tt_ctg ON tt_ctg.story_id = feature_article.uid AND tt_ctg.cat_type = "F" AND tt_ctg.category_id IN (SELECT uid FROM category WHERE (lft >= 4157 AND rgt <= 4196) ) WHERE feature_article.is_live > 0

(report) 1 query took 2 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `reports`		17	17	2

(report) 1 query took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `reports`

(report_slave) 1 query took 3 ms
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 ("Sensory organ") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Sensory organ") DESC , MarketResearchReport.published DESC LIMIT 10		10	10	3

(report_slave) 1 query took 3 ms

Query

Error

Affected

Num. rows

Took (ms)

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 ("Sensory organ") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Sensory organ") DESC , MarketResearchReport.published DESC LIMIT 10