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 1st February 2012
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
(15th November 2011) Innocoll Enters Partnership with Merus Labs in Canada for the Distribution of CollaGUARD
(19th October 2011) Innocoll Enters Partnership with Pioneer Pharma in China 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 | 1 | |
| 2 | DESCRIBE `company` | 27 | 27 | 1 | |
| 3 | DESCRIBE `condet` | 17 | 17 | 1 | |
| 4 | DESCRIBE `countrycode` | 4 | 4 | 0 | |
| 5 | DESCRIBE `person` | 15 | 15 | 1 | |
| 6 | DESCRIBE `account` | 29 | 29 | 1 | |
| 7 | DESCRIBE `product_legacy` | 6 | 6 | 1 | |
| 8 | DESCRIBE `sales_people` | 6 | 6 | 0 | |
| 9 | DESCRIBE `profile` | 14 | 14 | 1 | |
| 10 | DESCRIBE `currencies` | 7 | 7 | 1 | |
| 11 | DESCRIBE `update_rec` | 7 | 7 | 0 | |
| 12 | DESCRIBE `user` | 24 | 24 | 1 | |
| 13 | DESCRIBE `enquiry` | 14 | 14 | 1 | |
| 14 | DESCRIBE `module_types` | 6 | 6 | 0 | |
| 15 | DESCRIBE `dms_companies` | 26 | 26 | 1 | |
| 16 | DESCRIBE `dms_releases` | 10 | 10 | 1 | |
| 17 | DESCRIBE `dms_categories` | 4 | 4 | 0 | |
| 18 | DESCRIBE `dms_clinical_areas` | 4 | 4 | 0 | |
| 19 | DESCRIBE `dms_categories_dms_releases` | 2 | 2 | 0 | |
| 20 | DESCRIBE `dms_clinical_areas_dms_releases` | 2 | 2 | 0 | |
| 21 | DESCRIBE `dms_releases_sites` | 5 | 5 | 0 | |
| 22 | DESCRIBE `licopp` | 23 | 23 | 1 | |
| 23 | DESCRIBE `development_statuses` | 5 | 5 | 0 | |
| 24 | DESCRIBE `category` | 14 | 14 | 1 | |
| 25 | DESCRIBE `categories_sites` | 5 | 5 | 0 | |
| 26 | DESCRIBE `categorisation` | 8 | 8 | 1 | |
| 27 | DESCRIBE `licopps_sites` | 3 | 3 | 0 | |
| 28 | DESCRIBE `service` | 15 | 15 | 1 | |
| 29 | DESCRIBE `story` | 12 | 12 | 1 | |
| 30 | DESCRIBE `sites_stories` | 5 | 5 | 0 | |
| 31 | DESCRIBE `story_assoc` | 4 | 4 | 0 | |
| 32 | DESCRIBE `companies_sites` | 3 | 3 | 0 | |
| 33 | DESCRIBE `categories_users` | 2 | 2 | 0 | |
| 34 | DESCRIBE `authority` | 3 | 3 | 0 | |
| 35 | DESCRIBE `sites_users` | 5 | 5 | 0 | |
| 36 | DESCRIBE `press_releases_sites` | 5 | 5 | 1 | |
| 37 | DESCRIBE `sites` | 5 | 5 | 0 | |
| 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 | 0 | |
| 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` = '1328089169_4f290851cf01d' LIMIT 1 | 1 | 1 | 11 | |
| 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` = '1328089169_4f290851cf01d' 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` != "1328089169_4f290851cf01d" ORDER BY `issued` DESC LIMIT 5 | 5 | 5 | 37 | |
| 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', '1321358440_4ec25468ba113', '1319018074_4e9e9e5a8039f', '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 | 64 | |
| 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='1328089169_4f290851cf01d' 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 | 0 | |
| 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`="1328089169_4f290851cf01d" 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` = '1328089169_4f290851cf01d' 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 | |
| 48 | SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1328089169_4f290851cf01d' | 1 | 1 | 0 | |
| 49 | SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1328089169_4f290851cf01d' | 1 | 1 | 0 | |
| 50 | UPDATE `press_release` SET `viewed_counter` = 710 WHERE `press_release`.`uid` = '1328089169_4f290851cf01d' | 1 | 4 | ||
| 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` = '1328089169_4f290851cf01d' 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` = '1328089169_4f290851cf01d' 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 | |
| 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` = '1328089169_4f290851cf01d' | 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 | 0 | |
| 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` = '1328089169_4f290851cf01d' AND `company_id` = 4754 AND `module_type_id` = '9' AND `hit_date` = '2012-05-24' LIMIT 1 | 0 | 0 | 2 | |
| 57 | INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 4754, '1328089169_4f290851cf01d', '9', '2012-05-24') | 1 | 9 | ||
| 58 | SELECT LAST_INSERT_ID() AS insertID | 1 | 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 CollaGUARD® Distribution Partnership with Flynn Pharma Ltd in the UK and Inresa Arzneimittel GmbH in Germany") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Innocoll Enters CollaGUARD® Distribution Partnership with Flynn Pharma Ltd in the UK and Inresa Arzneimittel GmbH in Germany") DESC , MarketResearchReport.published DESC LIMIT 10 | 10 | 10 | 1 |