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.
Clinsys Partners with Medidata Solutions Through ASPire to Win Partner Program
Leading Japanese CRO Partners with Medidata Solutions Through ASPire to Win Program
Quintiles Strengthens Relationship with Medidata Solutions through ASPire to Win Accreditation
Taiho Pharmaceutical Selects Medidata Rave for Global Trials
Lundbeck Selects Medidata Rave® to Manage Global Electronic Clinical Trials
Medidata Solutions Expands Clinical Trial Technology Offering with Acquisition of Fast Track Systems
PharmaNet Development Group Agrees to be Acquired by JLL Partners
TurboWorx Joins Avnet Hall-Mark's ESP Program To Deliver Custom IBM Solutions - On Demand
Genaissance to provide pharmacogenetic support to INC Research, its first CRO partner
PHT and Medidata Provide Sucampo with Integrated eClinical Solution for Pediatric GI Clinical Trial
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `story` | 12 | 12 | 1 | |
| 2 | DESCRIBE `category` | 14 | 14 | 1 | |
| 3 | DESCRIBE `categories_sites` | 5 | 5 | 1 | |
| 4 | DESCRIBE `categorisation` | 8 | 8 | 1 | |
| 5 | DESCRIBE `sites_stories` | 5 | 5 | 0 | |
| 6 | DESCRIBE `sites` | 5 | 5 | 0 | |
| 7 | DESCRIBE `user` | 24 | 24 | 1 | |
| 8 | DESCRIBE `condet` | 17 | 17 | 1 | |
| 9 | DESCRIBE `countrycode` | 4 | 4 | 0 | |
| 10 | DESCRIBE `company` | 27 | 27 | 1 | |
| 11 | DESCRIBE `person` | 15 | 15 | 1 | |
| 12 | DESCRIBE `account` | 29 | 29 | 1 | |
| 13 | DESCRIBE `product_legacy` | 6 | 6 | 0 | |
| 14 | DESCRIBE `sales_people` | 6 | 6 | 0 | |
| 15 | DESCRIBE `profile` | 14 | 14 | 1 | |
| 16 | DESCRIBE `currencies` | 7 | 7 | 1 | |
| 17 | DESCRIBE `update_rec` | 7 | 7 | 1 | |
| 18 | DESCRIBE `dms_companies` | 26 | 26 | 1 | |
| 19 | DESCRIBE `dms_releases` | 10 | 10 | 8 | |
| 20 | DESCRIBE `dms_categories` | 4 | 4 | 1 | |
| 21 | DESCRIBE `dms_clinical_areas` | 4 | 4 | 0 | |
| 22 | DESCRIBE `dms_categories_dms_releases` | 2 | 2 | 0 | |
| 23 | DESCRIBE `dms_clinical_areas_dms_releases` | 2 | 2 | 0 | |
| 24 | DESCRIBE `dms_releases_sites` | 5 | 5 | 1 | |
| 25 | DESCRIBE `licopp` | 23 | 23 | 1 | |
| 26 | DESCRIBE `development_statuses` | 5 | 5 | 1 | |
| 27 | DESCRIBE `licopps_sites` | 3 | 3 | 0 | |
| 28 | DESCRIBE `service` | 15 | 15 | 1 | |
| 29 | DESCRIBE `enquiry` | 14 | 14 | 1 | |
| 30 | DESCRIBE `module_types` | 6 | 6 | 1 | |
| 31 | DESCRIBE `press_release` | 13 | 13 | 1 | |
| 32 | DESCRIBE `press_releases_sites` | 5 | 5 | 1 | |
| 33 | DESCRIBE `story_assoc` | 4 | 4 | 1 | |
| 34 | DESCRIBE `companies_sites` | 3 | 3 | 0 | |
| 35 | DESCRIBE `categories_users` | 2 | 2 | 0 | |
| 36 | DESCRIBE `authority` | 3 | 3 | 0 | |
| 37 | DESCRIBE `sites_users` | 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 `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` = '530743' 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` = '530743' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE `Categorisation`.`cat_type` = "S" | 0 | 0 | 1 | |
| 41 | SELECT Deal.uid, Deal.headline, Deal.created, Deal.summary, Deal.slug, MATCH(Deal.headline, Deal.summary) AGAINST ("PharmaNet Joins Medidata Solutions’ CRO Partner Program") AS score FROM story AS Deal WHERE MATCH(Deal.headline, Deal.summary) AGAINST ("PharmaNet Joins Medidata Solutions’ CRO Partner Program") AND Deal.is_live = 1 AND Deal.uid != "530743" LIMIT 10 | 10 | 10 | 7 | |
| 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='530743' 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 | 0 | 0 | 1 | |
| 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 | 0 | |
| 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 | 57 | |
| 45 | UPDATE story SET viewed_counter = viewed_counter + 1 WHERE uid = "530743" | 1 | 5 |