Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Notice (8): Undefined index: summary [/home/pharma/website/releases/20120317114903/cakephp/app/common/controllers/deals_common_controller.php, line 61]
In order to access this content you must be logged in and have a subscription to Pharmalicensing Intelligence.
Pharmalicensing Intelligence is a one-stop environment for time-conscious executives. Keeping you abreast of the latest developments in the life sciences industry, saving you time and money when you need it most.
Recommeded Offer by Sanofi Pasteur for Acambis plc
Acambis signs JE partnership agreement with sanofi pasteur
Sanofi Pasteur and Institut Pasteur team up against malaria
Bio-Rad to acquire Pasteur Sanofi Diagnostics
BD Micro-Delivery system licensed by Sanofi Pasteur
3M Licenses Vaccine Adjuvants to Sanofi Pasteur
Sanofi Pasteur to acquire all shares of Joint Venture with Daiichi-Sankyo in Japan
Bio-Rad acquires Pasteur Sanofi Diagnostics
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `story` | 12 | 12 | 5 | |
| 2 | DESCRIBE `category` | 14 | 14 | 4 | |
| 3 | DESCRIBE `categories_sites` | 5 | 5 | 3 | |
| 4 | DESCRIBE `categorisation` | 8 | 8 | 2 | |
| 5 | DESCRIBE `sites_stories` | 5 | 5 | 2 | |
| 6 | DESCRIBE `sites` | 5 | 5 | 4 | |
| 7 | DESCRIBE `user` | 24 | 24 | 3 | |
| 8 | DESCRIBE `condet` | 17 | 17 | 3 | |
| 9 | DESCRIBE `countrycode` | 4 | 4 | 2 | |
| 10 | DESCRIBE `company` | 27 | 27 | 2 | |
| 11 | DESCRIBE `person` | 15 | 15 | 4 | |
| 12 | DESCRIBE `account` | 29 | 29 | 2 | |
| 13 | DESCRIBE `product_legacy` | 6 | 6 | 2 | |
| 14 | DESCRIBE `sales_people` | 6 | 6 | 3 | |
| 15 | DESCRIBE `profile` | 14 | 14 | 1 | |
| 16 | DESCRIBE `currencies` | 7 | 7 | 3 | |
| 17 | DESCRIBE `update_rec` | 7 | 7 | 2 | |
| 18 | DESCRIBE `dms_companies` | 26 | 26 | 3 | |
| 19 | DESCRIBE `dms_releases` | 10 | 10 | 3 | |
| 20 | DESCRIBE `dms_categories` | 4 | 4 | 2 | |
| 21 | DESCRIBE `dms_clinical_areas` | 4 | 4 | 3 | |
| 22 | DESCRIBE `dms_categories_dms_releases` | 2 | 2 | 4 | |
| 23 | DESCRIBE `dms_clinical_areas_dms_releases` | 2 | 2 | 2 | |
| 24 | DESCRIBE `dms_releases_sites` | 5 | 5 | 4 | |
| 25 | DESCRIBE `licopp` | 23 | 23 | 7 | |
| 26 | DESCRIBE `development_statuses` | 5 | 5 | 4 | |
| 27 | DESCRIBE `licopps_sites` | 3 | 3 | 1 | |
| 28 | DESCRIBE `service` | 15 | 15 | 2 | |
| 29 | DESCRIBE `enquiry` | 14 | 14 | 2 | |
| 30 | DESCRIBE `module_types` | 6 | 6 | 2 | |
| 31 | DESCRIBE `press_release` | 13 | 13 | 2 | |
| 32 | DESCRIBE `press_releases_sites` | 5 | 5 | 1 | |
| 33 | DESCRIBE `story_assoc` | 4 | 4 | 1 | |
| 34 | DESCRIBE `companies_sites` | 3 | 3 | 3 | |
| 35 | DESCRIBE `categories_users` | 2 | 2 | 3 | |
| 36 | DESCRIBE `authority` | 3 | 3 | 1 | |
| 37 | DESCRIBE `sites_users` | 5 | 5 | 5 | |
| 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 | 1 | |
| 39 | SELECT `Deal`.`uid`, `Deal`.`headline`, `Deal`.`slug` FROM `story` AS `Deal` LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND `Deal`.`uid` = '435237' LIMIT 1 | 1 | 1 | 1 | |
| 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` = '435237' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE `Categorisation`.`cat_type` = "S" | 1 | 1 | 1 | |
| 41 | SELECT Deal.uid, Deal.headline, Deal.created, Deal.summary, Deal.slug, MATCH(Deal.headline, Deal.summary) AGAINST ("Recommended acquisition of Acambis plc (\"Acambis\") by Sanofi Pasteur Holding (\"Sanofi Pasteur\") by way of scheme of arrangement Posting of Scheme Document") AS score FROM story AS Deal WHERE MATCH(Deal.headline, Deal.summary) AGAINST ("Recommended acquisition of Acambis plc (\"Acambis\") by Sanofi Pasteur Holding (\"Sanofi Pasteur\") by way of scheme of arrangement Posting of Scheme Document") AND Deal.is_live = 1 AND Deal.uid != "435237" LIMIT 10 | 10 | 10 | 8 | |
| 42 | 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='435237' AND Categorisation.cat_type='S' 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 | 2 | 2 | 2 | |
| 43 | SELECT Deal.uid, Deal.slug, Deal.issued, Deal.headline, Deal.summary FROM story AS Deal WHERE Deal.is_live = 1 AND DATE(Deal.issued) <= DATE(now()) ORDER BY Deal.issued DESC LIMIT 5 | 5 | 5 | 5 | |
| 44 | SELECT `Deal`.`uid`, `Deal`.`issued`, `Deal`.`headline`, `Deal`.`slug` FROM `story` AS `Deal` LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND `is_live` = 1 ORDER BY `Deal`.`viewed_counter` DESC, `Deal`.`issued` DESC LIMIT 5 | 5 | 5 | 74 | |
| 45 | UPDATE story SET viewed_counter = viewed_counter + 1 WHERE uid = "435237" | 1 | 11 |