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

Press releases

Stay current with the latest press releases from within the industry.

Press releases
GfK Bridgehead
Bridgehead International...

Bridgehead International announces publication by The Personalized Medicine Coalition (PMC) of a white paper entitled “Advancing Access to Personalized Medicine: A Comparative Assessment

Release issued 20th October 2011

London 17 October 2011 ......Bridgehead International is pleased to announce publication by The Personalized Medicine Coalition (PMC) of a white paper entitled "Advancing Access to Personalized Medicine: A Comparative Assessment of European Reimbursement Systems" that evaluates and rates the payment, coding and evidence systems for personalized medicine products in Europe today. The author of the report was Susan Garfield, Vice President of Bridgehead International (www.bridgehead.com), an expert in market access consulting.

Issue Brief Rates European Countries on Reimbursement Policies for New Personalized Medicine Technologies
European Health Agencies Must Reassess Evaluation and Payment Mechanisms to Keep Pace With Innovation and Improve Patient Care

Washington, DC (October 13, 2011) - The Personalized Medicine Coalition (PMC) today released a white paper titled "Advancing Access to Personalized Medicine: A Comparative Assessment of European Reimbursement Systems" that evaluates and rates the payment, coding and evidence systems for personalized medicine products in Europe. Of the ten European countries included in the landscape analysis, Germany, the United Kingdom and France rated highest and Norway, Finland and the Netherlands rated lowest. The paper also proposes reforms that would improve access to personalized medicine by modernizing coding systems, developing new reimbursement processes, and clarifying evidence requirements needed to bring products to market.

"Companies developing innovative personalized medicine products in Europe face similar challenges to innovators in the United States; regulatory systems on both continents are not well-positioned to evaluate personalized medicine products nor are reimbursement systems configured to provide companies with a predictable, value-based return on their investments," said Edward Abrahams, PMC President.

The white paper identifies country-level reimbursement factors that can support or inhibit investment in and access to personalized medicine technologies. It recommends best practices that could improve reimbursement systems and ultimately bring more personalized medicine products to the market in Europe.

"For personalized medicine to reach its full potential, policies across Europe need to be better aligned. Health systems must define clear evidence requirements and create reimbursement pathways for combination products. The fragmented system whereby regulatory decisions are made by the entire European Union, but reimbursement, coding and pricing are determined by individual countries compounds the problem," said the report's author, Susan Garfield, Vice President of Bridgehead International.

Countries were rated based upon eight criteria, including value-based pricing opportunities for diagnostics, coding specificity requirements, health technology assessment processes and national funding for personalized medicine research, among others.

The white paper was released at the Cambridge Healthtech Institute's Molecular Diagnostics Summit Europe in Hannover, Germany and is available for download on the Personalized Medicine Coalition's website: www.PersonalizedMedicineCoalition.org.

About the Personalized Medicine Coalition
The Personalized Medicine Coalition (PMC), representing scientists, patients, providers and payers, promotes the understanding and adoption of personalized medicine concepts, services and products to benefit patients and the health system.

CONTACT
Gwen Gordon, Communications Director
Phone: (202) 589-1770
ggordon@PersonalizedMedicineCoalition.org

Wendy Daunt, Marketing Executive
Phone: 0044 1664503700
Wendy.daunt@bridgehead.com

Company details

If you want to find out more about the company visit GfK Bridgehead profile.

Latest GfK Bridgehead press releases

(20th October 2011) Bridgehead International Appoints Expert in Global Pricing and Market Access for Oncology Products

(13th September 2011) Bridgehead International Appoints Marcus Deans as Principal Consultant

(1st August 2011) Bridgehead International Announces US West Coast Expansion

(14th June 2011) Bridgehead International appoints Nigel Seear as Vice President, Europe

(21st April 2011) Bridgehead International wins The Queen’s Award for Enterprise 2011

Related reports

Market Research Reports provided by reports.innovaro.com

Personalized Medicine

Aug 2007 - 87 pages - $1,999

Personalized Medicine Market - Advances in Human Genomics and Proteomics to Challenge Traditional Therapeutics

Dec 2010 - 124 pages - $3,500

Personalized Medicine Partnering Terms and Agreements

Apr 2011 - 951 pages - $4,995

Personalized Nutrition and the Future of Functional Foods

Oct 2011 - 31 pages - $1,495

Expanding Applications of Personalized Medicine: Use of biomarkers in prognostic, predictive and pharmacogenetic tests in a targeted approach

Aug 2009 - 141 pages - $3,835

Company Financials: Cypress Bioscience, Inc.

Jan 2010 - $75

PMC-Sierra, Inc.: SWOT Analysis & Company Profile

Jul 2010 - 24 pages - $99

Case Study: Personalized Cancer Therapy - The era of biomarker identification and companion diagnostic co-development

Mar 2011 - 50 pages - $1,900

Translational Medicine - Drug Development Transformed? (Market Focus)

Feb 2007 - 14 pages - $1,895

Hot Topics: Impact of Biomarkers in Alzheimer's Disease - Dx-Rx collaboration paves the way for personalized medicine

Dec 2011 - 50 pages - $3,800

More Press Releases

Latest

Frost & Sullivan Award Highlights CIS Pharma’s Technology Innovation in Polymer Industry -- Award Recipient Recognised for its Innovative and Unique Cellophil

Innocoll Provides Update of Regulatory and Partnering Activities for CollaGUARD® Adhesion Barrier and Launches New Product Website

Development of Butyrylcholinesterase-targeted Radiopharmaceuticals for the Treatment of Cancer

19 March 2012 Cerca Insights Opens New Behavioural Pharmacology Laboratory in Penang, Malaysia

Alcon gains exclusive ex-US rights for ocriplasmin, potential first pharmacological treatment for symptomatic vitreomacular adhesion

Most viewed

euroPLX Introduces Tool to Overcome Reject vs. Accept Dilemma in Partnering

Discovery and validation of 13 diabetes biomarkers to be commercialized

Genesis Conference on target to exceed all previous years

Two papers on Neo-Penotran® Forte and Neo-Penotran® Forte-L have been accepted for presentation at the 4'th World Conference on Vaginitis, Costa Rica, 10-13 Jan 2004

TDS® TESTOSTERONE EXCEEDS ANDROGEL® OUTCOMES

Related categories

Therapeutic target

Industry sector

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

(website) 58 queries took 1033 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `press_release`	13	13	2
2	DESCRIBE `company`	27	27	10
3	DESCRIBE `condet`	17	17	1
4	DESCRIBE `countrycode`	4	4	1
5	DESCRIBE `person`	15	15	1
6	DESCRIBE `account`	29	29	20
7	DESCRIBE `product_legacy`	6	6	37
8	DESCRIBE `sales_people`	6	6	1
9	DESCRIBE `profile`	14	14	2
10	DESCRIBE `currencies`	7	7	1
11	DESCRIBE `update_rec`	7	7	3
12	DESCRIBE `user`	24	24	1
13	DESCRIBE `enquiry`	14	14	1
14	DESCRIBE `module_types`	6	6	1
15	DESCRIBE `dms_companies`	26	26	1
16	DESCRIBE `dms_releases`	10	10	2
17	DESCRIBE `dms_categories`	4	4	1
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	3
22	DESCRIBE `licopp`	23	23	7
23	DESCRIBE `development_statuses`	5	5	11
24	DESCRIBE `category`	14	14	1
25	DESCRIBE `categories_sites`	5	5	14
26	DESCRIBE `categorisation`	8	8	1
27	DESCRIBE `licopps_sites`	3	3	1
28	DESCRIBE `service`	15	15	1
29	DESCRIBE `story`	12	12	54
30	DESCRIBE `sites_stories`	5	5	2
31	DESCRIBE `story_assoc`	4	4	12
32	DESCRIBE `companies_sites`	3	3	5
33	DESCRIBE `categories_users`	2	2	5
34	DESCRIBE `authority`	3	3	4
35	DESCRIBE `sites_users`	5	5	5
36	DESCRIBE `press_releases_sites`	5	5	13
37	DESCRIBE `sites`	5	5	1
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 `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` = '1319100933_4e9fe205aecc4' LIMIT 1	1	1	75
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` = '1319100933_4e9fe205aecc4' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	8	8	29
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`='4555' AND `Press`.`is_live`=1 AND DATE(`Press`.`issued`) <= DATE(now()) AND `Press`.`uid` != "1319100933_4e9fe205aecc4" ORDER BY `issued` DESC LIMIT 5	5	5	297
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 ('1319100585_4e9fe0a90f9db', '1315909545_4e6f2fa949b02', '1312190342_4e366f8698fb4', '1308065056_4df77d200a16b', '1303377151_4daff4ff8c962') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	46	46	59
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	223
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='1319100933_4e9fe205aecc4' 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	8	8	60
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`="1319100933_4e9fe205aecc4" AND `Press`.`is_live`>0 LIMIT 1	1	1	21
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` = '1319100933_4e9fe205aecc4' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	8	8	9
48	SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1319100933_4e9fe205aecc4'	1	1	1
49	SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1319100933_4e9fe205aecc4'	1	1	0
50	UPDATE `press_release` SET `viewed_counter` = 581 WHERE `press_release`.`uid` = '1319100933_4e9fe205aecc4'	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` = '1319100933_4e9fe205aecc4' LIMIT 1	1	1	4
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` = '1319100933_4e9fe205aecc4' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	8	8	13
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` = '1319100933_4e9fe205aecc4'	1	1	1
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` = '1319100933_4e9fe205aecc4' AND `company_id` = 4555 AND `module_type_id` = '9' AND `hit_date` = '2012-05-21' 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, 4555, '1319100933_4e9fe205aecc4', '9', '2012-05-21')	1		1
58	SELECT LAST_INSERT_ID() AS insertID	1	1	1

(website) 58 queries took 1033 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `press_release`

DESCRIBE `company`

DESCRIBE `condet`

DESCRIBE `countrycode`

DESCRIBE `person`

DESCRIBE `account`

DESCRIBE `product_legacy`

DESCRIBE `sales_people`

DESCRIBE `profile`

DESCRIBE `currencies`

DESCRIBE `update_rec`

DESCRIBE `user`

DESCRIBE `enquiry`

DESCRIBE `module_types`

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 `story`

DESCRIBE `sites_stories`

DESCRIBE `story_assoc`

DESCRIBE `companies_sites`

DESCRIBE `categories_users`

DESCRIBE `authority`

DESCRIBE `sites_users`

DESCRIBE `press_releases_sites`

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 `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` = '1319100933_4e9fe205aecc4' LIMIT 1

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` = '1319100933_4e9fe205aecc4' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

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`='4555' AND `Press`.`is_live`=1 AND DATE(`Press`.`issued`) <= DATE(now()) AND `Press`.`uid` != "1319100933_4e9fe205aecc4" ORDER BY `issued` DESC LIMIT 5

297

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 ('1319100585_4e9fe0a90f9db', '1315909545_4e6f2fa949b02', '1312190342_4e366f8698fb4', '1308065056_4df77d200a16b', '1303377151_4daff4ff8c962') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

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

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

223

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='1319100933_4e9fe205aecc4' 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

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`="1319100933_4e9fe205aecc4" AND `Press`.`is_live`>0 LIMIT 1

SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1319100933_4e9fe205aecc4'

UPDATE `press_release` SET `viewed_counter` = 581 WHERE `press_release`.`uid` = '1319100933_4e9fe205aecc4'

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` = '1319100933_4e9fe205aecc4' LIMIT 1

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` = '1319100933_4e9fe205aecc4'

DESCRIBE `statistics`

SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'press' LIMIT 1

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` = '1319100933_4e9fe205aecc4' AND `company_id` = 4555 AND `module_type_id` = '9' AND `hit_date` = '2012-05-21' LIMIT 1

INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 4555, '1319100933_4e9fe205aecc4', '9', '2012-05-21')

SELECT LAST_INSERT_ID() AS insertID

(report) 2 queries took 981 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 ("Bridgehead International announces publication by The Personalized Medicine Coalition (PMC) of a white paper entitled “Advancing Access to Personalized Medicine: A Comparative Assessment") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Bridgehead International announces publication by The Personalized Medicine Coalition (PMC) of a white paper entitled “Advancing Access to Personalized Medicine: A Comparative Assessment") DESC , MarketResearchReport.published DESC LIMIT 10		10	10	980

(report) 2 queries took 981 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `reports`

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 ("Bridgehead International announces publication by The Personalized Medicine Coalition (PMC) of a white paper entitled “Advancing Access to Personalized Medicine: A Comparative Assessment") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Bridgehead International announces publication by The Personalized Medicine Coalition (PMC) of a white paper entitled “Advancing Access to Personalized Medicine: A Comparative Assessment") DESC , MarketResearchReport.published DESC LIMIT 10

980