Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Stay current with the latest press releases from within the industry.
Release issued 19th October 2011
If you want to find out more about the company visit Innocoll, Inc. profile.
(3rd April 2012) Innocoll Provides Update of Regulatory and Partnering Activities for CollaGUARD® Adhesion Barrier and Launches New Product Website
(17th February 2012) Innocoll Announces Successful End-of-Phase 2 Meeting with FDA for XaraColl® and Agreement of the Phase 3 Program
(1st February 2012) Innocoll Enters CollaGUARD® Distribution Partnership with Flynn Pharma Ltd in the UK and Inresa Arzneimittel GmbH in Germany
(15th November 2011) Innocoll Enters Partnership with Merus Labs in Canada for the Distribution of CollaGUARD
(11th October 2011) Innocoll Announces European Approval for CollaGUARD®, Surgical Adhesion Barrier.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `press_release` | 13 | 13 | 2 | |
| 2 | DESCRIBE `company` | 27 | 27 | 3 | |
| 3 | DESCRIBE `condet` | 17 | 17 | 2 | |
| 4 | DESCRIBE `countrycode` | 4 | 4 | 1 | |
| 5 | DESCRIBE `person` | 15 | 15 | 3 | |
| 6 | DESCRIBE `account` | 29 | 29 | 2 | |
| 7 | DESCRIBE `product_legacy` | 6 | 6 | 2 | |
| 8 | DESCRIBE `sales_people` | 6 | 6 | 3 | |
| 9 | DESCRIBE `profile` | 14 | 14 | 1 | |
| 10 | DESCRIBE `currencies` | 7 | 7 | 2 | |
| 11 | DESCRIBE `update_rec` | 7 | 7 | 2 | |
| 12 | DESCRIBE `user` | 24 | 24 | 3 | |
| 13 | DESCRIBE `enquiry` | 14 | 14 | 2 | |
| 14 | DESCRIBE `module_types` | 6 | 6 | 1 | |
| 15 | DESCRIBE `dms_companies` | 26 | 26 | 1 | |
| 16 | DESCRIBE `dms_releases` | 10 | 10 | 5 | |
| 17 | DESCRIBE `dms_categories` | 4 | 4 | 3 | |
| 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 | 1 | |
| 21 | DESCRIBE `dms_releases_sites` | 5 | 5 | 4 | |
| 22 | DESCRIBE `licopp` | 23 | 23 | 1 | |
| 23 | DESCRIBE `development_statuses` | 5 | 5 | 1 | |
| 24 | DESCRIBE `category` | 14 | 14 | 1 | |
| 25 | DESCRIBE `categories_sites` | 5 | 5 | 1 | |
| 26 | DESCRIBE `categorisation` | 8 | 8 | 2 | |
| 27 | DESCRIBE `licopps_sites` | 3 | 3 | 1 | |
| 28 | DESCRIBE `service` | 15 | 15 | 3 | |
| 29 | DESCRIBE `story` | 12 | 12 | 1 | |
| 30 | DESCRIBE `sites_stories` | 5 | 5 | 6 | |
| 31 | DESCRIBE `story_assoc` | 4 | 4 | 1 | |
| 32 | DESCRIBE `companies_sites` | 3 | 3 | 1 | |
| 33 | DESCRIBE `categories_users` | 2 | 2 | 1 | |
| 34 | DESCRIBE `authority` | 3 | 3 | 1 | |
| 35 | DESCRIBE `sites_users` | 5 | 5 | 1 | |
| 36 | DESCRIBE `press_releases_sites` | 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 | 6 | |
| 39 | SELECT `Press`.`uid`, `Press`.`slug`, `Press`.`company_id`, `Press`.`created`, `Press`.`lastmod`, `Press`.`issued`, `Press`.`headline`, `Press`.`summary`, `Press`.`body`, `Press`.`is_live`, `Press`.`is_attachment`, `Press`.`user_id`, `Press`.`viewed_counter`, `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`condet_id`, `Company`.`person_id`, `Company`.`billing_id`, `Company`.`parent`, `Company`.`has_children`, `Company`.`notes_id`, `Company`.`contact_status`, `Company`.`last_contacted`, `Company`.`profile_id`, `Company`.`account_id`, `Company`.`summary`, `Company`.`is_customer`, `Company`.`change_time`, `Company`.`flags`, `Company`.`is_anon`, `Company`.`is_resource`, `Company`.`satellite`, `Company`.`no_dms`, `Company`.`is_live`, `Company`.`viewed_counter`, `Company`.`created`, `Company`.`last_disabled`, `Company`.`no_trial`, `Company`.`trial_notification_sent`, `User`.`uid`, `User`.`email`, `User`.`name`, `User`.`password`, `User`.`lastlogin`, `User`.`currency`, `User`.`person`, `User`.`customer`, `User`.`operator`, `User`.`company`, `User`.`wantsmail`, `User`.`passwordclue`, `User`.`alias`, `User`.`username`, `User`.`person_id`, `User`.`condet_id`, `User`.`company_id`, `User`.`signup_date`, `User`.`alert_inlic`, `User`.`alert_outlic`, `User`.`alert_company`, `User`.`alert_events`, `User`.`alert_lasttime`, `User`.`stats_access`, `PressSite`.`id`, `PressSite`.`created`, `PressSite`.`modified`, `PressSite`.`press_release_id`, `PressSite`.`site_id` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`uid` = '1319018074_4e9e9e5a8039f' LIMIT 1 | 1 | 1 | 16 | |
| 40 | 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` = '1319018074_4e9e9e5a8039f' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | 0 | 0 | 1 | |
| 41 | SELECT `Press`.`uid`, `Press`.`slug`, `Press`.`headline`, `Press`.`body`, `Press`.`issued` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`company_id`='4754' AND `Press`.`is_live`=1 AND DATE(`Press`.`issued`) <= DATE(now()) AND `Press`.`uid` != "1319018074_4e9e9e5a8039f" ORDER BY `issued` DESC LIMIT 5 | 5 | 5 | 67 | |
| 42 | 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 ('1333447334_4f7acaa66741b', '1329480732_4f3e441cc2e60', '1328089169_4f290851cf01d', '1321358440_4ec25468ba113', '1318322688_4e940200e8576') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | 0 | 0 | 0 | |
| 43 | SELECT Press.uid, Press.slug, Press.issued, Press.headline, Press.summary FROM press_release AS Press WHERE Press.is_live = 1 AND Press.issued <= now() GROUP BY Press.uid ORDER BY Press.issued DESC LIMIT 5 | 5 | 5 | 1 | |
| 44 | SELECT `Press`.`uid`, `Press`.`issued`, `Press`.`headline`, `Press`.`slug` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`is_live` = 1 AND DATE(`Press`.`issued`) <= DATE(now()) ORDER BY `Press`.`viewed_counter` DESC, `Press`.`issued` DESC LIMIT 5 | 5 | 5 | 106 | |
| 45 | SELECT Category.uid, Category.parent, Category.root, Category.name, Category.level, Category.lft, CASE Category.root WHEN '560' THEN 0 WHEN '297' THEN 1 ELSE CASE Category.uid WHEN '560' THEN 0 WHEN '297' THEN 1 ELSE NULL END END AS root_order FROM category AS RootCategory LEFT JOIN categorisation AS Categorisation ON Categorisation.category_id=RootCategory.uid AND Categorisation.story_id='1319018074_4e9e9e5a8039f' AND Categorisation.cat_type='R' LEFT JOIN category AS Category ON (Category.lft <= RootCategory.lft AND Category.rgt >= RootCategory.rgt AND Category.level > 0) WHERE Categorisation.id IS NOT NULL AND RootCategory.root IN (560, 297) GROUP BY Category.uid ORDER BY root_order,lft | 0 | 0 | 1 | |
| 46 | SELECT `Press`.`uid`, `Press`.`company_id`, `Press`.`viewed_counter` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`uid`="1319018074_4e9e9e5a8039f" AND `Press`.`is_live`>0 LIMIT 1 | 1 | 1 | 3 | |
| 47 | 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` = '1319018074_4e9e9e5a8039f' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | 0 | 0 | 8 | |
| 48 | SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1319018074_4e9e9e5a8039f' | 1 | 1 | 0 | |
| 49 | SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1319018074_4e9e9e5a8039f' | 1 | 1 | 0 | |
| 50 | UPDATE `press_release` SET `viewed_counter` = 466 WHERE `press_release`.`uid` = '1319018074_4e9e9e5a8039f' | 1 | 3 | ||
| 51 | SELECT `Press`.`uid` FROM `press_release` AS `Press` LEFT JOIN `company` AS `Company` ON (`Press`.`company_id` = `Company`.`uid`) LEFT JOIN `user` AS `User` ON (`Press`.`user_id` = `User`.`uid`) LEFT JOIN `press_releases_sites` AS `PressSite` ON (`PressSite`.`press_release_id` = `Press`.`uid`) WHERE `PressSite`.`site_id` = 1 AND `Press`.`uid` = '1319018074_4e9e9e5a8039f' LIMIT 1 | 1 | 1 | 3 | |
| 52 | 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` = '1319018074_4e9e9e5a8039f' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | 0 | 0 | 10 | |
| 53 | SELECT `PressSite`.`id`, `PressSite`.`created`, `PressSite`.`modified`, `PressSite`.`press_release_id`, `PressSite`.`site_id` FROM `press_releases_sites` AS `PressSite` WHERE `site_id` = 1 AND `press_release_id` = '1319018074_4e9e9e5a8039f' | 1 | 1 | 0 | |
| 54 | DESCRIBE `statistics` | 7 | 7 | 1 | |
| 55 | SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'press' LIMIT 1 | 1 | 1 | 1 | |
| 56 | SELECT `Statistic`.`id`, `Statistic`.`module_type_id`, `Statistic`.`company_id`, `Statistic`.`business_object_id`, `Statistic`.`count`, `Statistic`.`hit_date`, `Statistic`.`is_aggregated`, `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `statistics` AS `Statistic` LEFT JOIN `module_types` AS `ModuleType` ON (`Statistic`.`module_type_id` = `ModuleType`.`id`) WHERE `business_object_id` = '1319018074_4e9e9e5a8039f' AND `company_id` = 4754 AND `module_type_id` = '9' AND `hit_date` = '2012-05-21' LIMIT 1 | 1 | 1 | 1 | |
| 57 | SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10690038 | 1 | 1 | 0 | |
| 58 | SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10690038 | 1 | 1 | 0 | |
| 59 | SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10690038 | 1 | 1 | 0 | |
| 60 | UPDATE `statistics` SET `id` = 10690038, `module_type_id` = '9', `company_id` = 4754, `business_object_id` = '1319018074_4e9e9e5a8039f', `count` = 2, `hit_date` = '2012-05-21', `is_aggregated` = 0 WHERE `statistics`.`id` = 10690038 | 1 | 0 |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `reports` | 17 | 17 | 1 | |
| 2 | 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 ("Innocoll Enters Partnership with Pioneer Pharma in China for the Distribution of CollaGUARD") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Innocoll Enters Partnership with Pioneer Pharma in China for the Distribution of CollaGUARD") DESC , MarketResearchReport.published DESC LIMIT 10 | 10 | 10 | 1 |