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

In-licensing

Up-to-date access to technology licensing opportunities worldwide.

In-licensing
Browse

Licensing opportunities

Displaying 1..7 of 7 - per page
Order by

Dermatology: products/technologies for Acne

New Products/Technologies for Acne in early to late phases or already marketed required for acquisition or in-licensing for Mexico More

Dermatology: Skin Cancer, Anti-fungals, Dermoceuticals & more

New Dermatology products in early to late phases or already marketed required for acquisition or in-licensing for Mexico More

UK Marketing Partner

Are you a small to medium company seeking a UK presence? More

Dermatology: products/Technologies for Atopic Dermatitis

New Products/technologies for Atopic Dermatitis in early to late phases or already marketed required for acquisition or in-licensing for Mexico More

Oral, Topical or Transdermal products in any therapeutical area

APR is interested to in-license new early stage, innovative and patent protected products/technologies (preferably off patent or close to expiry) for oral, topical or transdermal administration More

Products for Otorinilaryngology, Pediatrics, Dermatology, Gynecology and Ophthalmology

Products for Otorinilaryngology, Pediatrics, Dermatology, Gynecology and Ophthalmology More

Drug free pain relief devices with additional benefits

A global healthcare company is currently seeking devices that can be used to relieve pain, particularly electrotherapy devices. More

Displaying 1..7 of 7 - per page
Order by

Related Reports

Market Research Reports provided by reports.innovaro.com

Medical Device Company Performance Tables

Mar 2010 - 414 pages - $690

Smiths Medical Medical Device Company Intelligence Report

Jan 2011 - 38 pages - $515

Sorin Medical Medical Device Company Intelligence Report

Apr 2010 - 42 pages - $515

American Medical Systems Medical Device Company Intelligence Report

Mar 2010 - 30 pages - $515

Toshiba Medical Systems Medical Device Company Intelligence Report

May 2009 - 32 pages - $515

Advanced Medical Optics Medical Device Company Intelligence Report

Jul 2005 - 52 pages - $515

The True State of the Medical Device Industry

Feb 2009 - 242 pages - $690

Healthcare Reform: Impact on Medical Device Industry

Apr 2010 - 5 pages - $500

Brazil Medical Device Industry – Key Company Profiles

Apr 2011 - 25 pages - $500

Cordis Medical Device Company Intelligence Report

Mar 2011 - 38 pages - $340

Your selection

Industry sector: Medical device del

Browse By

Industry sector: Therapeutic device; Therapeutic medical equipment; Vision Care
Therapeutic target: Accident and Trauma; Allergy; Blood and forming organs; Cardiovascular; Central Nervous System; Dermatological; Endocrinology; Gastrointestinal; Genetic disorders; Genito-urinary; Hospital and Surgery; Immune related disorders; Infectious diseases; Metabolism; Musculoskeletal; Oncology; Oral Health; Other therapeutic; Respiratory; Sensory organ
Development phase: Early Stage; Preclinical; Phase I; Phase I/II; Phase II; Phase III; Phase III/IV; Preregistration; Registered

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

Products:

Partnering Search

Company Profiling

Pharmalicensing Intelligence

Intellectual Property

(website) 49 queries took 165 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `licopp`	23	23	3
2	DESCRIBE `company`	27	27	2
3	DESCRIBE `condet`	17	17	3
4	DESCRIBE `countrycode`	4	4	2
5	DESCRIBE `person`	15	15	1
6	DESCRIBE `account`	29	29	2
7	DESCRIBE `product_legacy`	6	6	3
8	DESCRIBE `sales_people`	6	6	1
9	DESCRIBE `profile`	14	14	1
10	DESCRIBE `currencies`	7	7	2
11	DESCRIBE `update_rec`	7	7	1
12	DESCRIBE `user`	24	24	1
13	DESCRIBE `enquiry`	14	14	2
14	DESCRIBE `module_types`	6	6	1
15	DESCRIBE `dms_companies`	26	26	2
16	DESCRIBE `dms_releases`	10	10	8
17	DESCRIBE `dms_categories`	4	4	2
18	DESCRIBE `dms_clinical_areas`	4	4	3
19	DESCRIBE `dms_categories_dms_releases`	2	2	4
20	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	2
21	DESCRIBE `dms_releases_sites`	5	5	8
22	DESCRIBE `development_statuses`	5	5	4
23	DESCRIBE `category`	14	14	3
24	DESCRIBE `categories_sites`	5	5	4
25	DESCRIBE `categorisation`	8	8	2
26	DESCRIBE `licopps_sites`	3	3	2
27	DESCRIBE `service`	15	15	6
28	DESCRIBE `press_release`	13	13	18
29	DESCRIBE `press_releases_sites`	5	5	2
30	DESCRIBE `story`	12	12	15
31	DESCRIBE `sites_stories`	5	5	1
32	DESCRIBE `story_assoc`	4	4	2
33	DESCRIBE `companies_sites`	3	3	1
34	DESCRIBE `categories_users`	2	2	16
35	DESCRIBE `authority`	3	3	1
36	DESCRIBE `sites_users`	5	5	1
37	DESCRIBE `sites`	5	5	2
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 `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 453 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC	3	3	11
40	SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (454, 472, 501) ORDER BY `name` ASC	43	43	1
41	SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 560 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC	20	20	4
42	SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (1476, 561, 575, 582, 595, 603, 635, 616, 1477, 631, 641, 651, 562, 654, 662, 572, 1479, 670, 679, 689) ORDER BY `name` ASC	316	316	2
43	SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name` FROM `development_statuses` AS `DevelopmentStatus` WHERE 1 = 1 GROUP BY `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name` ORDER BY `DevelopmentStatus`.`display_order` ASC	9	9	4
44	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 453	1	1	1
45	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "1769" AND c.rgt >= "1874" AND c.level > 1 ORDER BY c.level	1	1	0
46	SELECT `IndustrySector`.`lft`, `IndustrySector`.`rgt`, `IndustrySector`.`uid` FROM `category` AS `IndustrySector` LEFT JOIN `category` AS `Parent` ON (`IndustrySector`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `IndustrySector`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `IndustrySector`.`uid` = 453 LIMIT 1	1	1	1
47	SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` = (453) ORDER BY `name` ASC	3	3	1
48	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`.`company_id` IN (4338, 4340, 2111, 4339, 5002, 19247, 19298) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	108	108	3
49	SELECT `IndustrySector`.`uid`, `IndustrySector`.`name`, `IndustrySector`.`parent`, `IndustrySector`.`has_children`, `IndustrySector`.`show_children`, `IndustrySector`.`show_grandchildren`, `IndustrySector`.`members`, `IndustrySector`.`num_children`, `IndustrySector`.`root`, `IndustrySector`.`restricted`, `IndustrySector`.`clan`, `IndustrySector`.`lft`, `IndustrySector`.`rgt`, `IndustrySector`.`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 `IndustrySector` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` IN (4338, 4340, 2111, 4339, 5002, 19247, 19298) AND `Categorisation`.`category_id` = `IndustrySector`.`uid`) WHERE `cat_type` = 'P' ORDER BY `IndustrySector`.`root` ASC, `IndustrySector`.`clan` ASC, `IndustrySector`.`parent` ASC, `IndustrySector`.`name` ASC	108	108	2

(website) 49 queries took 165 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `licopp`

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

DESCRIBE `category`

DESCRIBE `categories_sites`

DESCRIBE `categorisation`

DESCRIBE `licopps_sites`

DESCRIBE `service`

DESCRIBE `press_release`

DESCRIBE `press_releases_sites`

DESCRIBE `story`

DESCRIBE `sites_stories`

DESCRIBE `story_assoc`

DESCRIBE `companies_sites`

DESCRIBE `categories_users`

DESCRIBE `authority`

DESCRIBE `sites_users`

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 `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 453 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC

SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (454, 472, 501) ORDER BY `name` ASC

SELECT `Category`.`uid`, `Category`.`name` FROM `category` AS `Category` LEFT JOIN `category` AS `Parent` ON (`Category`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `Category`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `Category`.`parent` = 560 AND `Category`.`restricted` IS NULL ORDER BY `Category`.`name` ASC

316

SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name` FROM `development_statuses` AS `DevelopmentStatus` WHERE 1 = 1 GROUP BY `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name` ORDER BY `DevelopmentStatus`.`display_order` ASC

SELECT c.lft, c.rgt FROM category c WHERE c.uid = 453

SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "1769" AND c.rgt >= "1874" AND c.level > 1 ORDER BY c.level

SELECT `IndustrySector`.`lft`, `IndustrySector`.`rgt`, `IndustrySector`.`uid` FROM `category` AS `IndustrySector` LEFT JOIN `category` AS `Parent` ON (`IndustrySector`.`parent` = `Parent`.`uid`) LEFT JOIN `categories_sites` AS `CategorySite` ON (`CategorySite`.`category_id` = `IndustrySector`.`uid`) WHERE `CategorySite`.`site_id` = 1 AND `IndustrySector`.`uid` = 453 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`.`company_id` IN (4338, 4340, 2111, 4339, 5002, 19247, 19298) AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="P" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

108

SELECT `IndustrySector`.`uid`, `IndustrySector`.`name`, `IndustrySector`.`parent`, `IndustrySector`.`has_children`, `IndustrySector`.`show_children`, `IndustrySector`.`show_grandchildren`, `IndustrySector`.`members`, `IndustrySector`.`num_children`, `IndustrySector`.`root`, `IndustrySector`.`restricted`, `IndustrySector`.`clan`, `IndustrySector`.`lft`, `IndustrySector`.`rgt`, `IndustrySector`.`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 `IndustrySector` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` IN (4338, 4340, 2111, 4339, 5002, 19247, 19298) AND `Categorisation`.`category_id` = `IndustrySector`.`uid`) WHERE `cat_type` = 'P' ORDER BY `IndustrySector`.`root` ASC, `IndustrySector`.`clan` ASC, `IndustrySector`.`parent` ASC, `IndustrySector`.`name` ASC

108

(website_slave) 2 queries took 14 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `Inlicensing`.`uid`, `Inlicensing`.`slug`, `Inlicensing`.`title`, `Inlicensing`.`shortdesc` FROM `licopp` AS `Inlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Inlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") INNER JOIN categorisation AS `CategorisationIndustrySector` ON (`CategorisationIndustrySector`.`company_id` = `Inlicensing`.`uid` AND `CategorisationIndustrySector`.`cat_type` = 'P') INNER JOIN category AS `IndustrySector` ON (`IndustrySector`.`uid` = `CategorisationIndustrySector`.`category_id` AND `IndustrySector`.`lft` >= '1769' AND `IndustrySector`.`rgt` <= '1874') LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND `Inlicensing`.`is_out` = 'N' GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`viewed_counter` DESC, `Inlicensing`.`title` ASC LIMIT 10		7	7	9
2	SELECT COUNT(DISTINCT Inlicensing.uid) AS `count` FROM `licopp` AS `Inlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Inlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") INNER JOIN categorisation AS `CategorisationIndustrySector` ON (`CategorisationIndustrySector`.`company_id` = `Inlicensing`.`uid` AND `CategorisationIndustrySector`.`cat_type` = 'P') INNER JOIN category AS `IndustrySector` ON (`IndustrySector`.`uid` = `CategorisationIndustrySector`.`category_id` AND `IndustrySector`.`lft` >= '1769' AND `IndustrySector`.`rgt` <= '1874') LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND `Inlicensing`.`is_out` = 'N'		1	1	5

(website_slave) 2 queries took 14 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Inlicensing`.`uid`, `Inlicensing`.`slug`, `Inlicensing`.`title`, `Inlicensing`.`shortdesc` FROM `licopp` AS `Inlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Inlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") INNER JOIN categorisation AS `CategorisationIndustrySector` ON (`CategorisationIndustrySector`.`company_id` = `Inlicensing`.`uid` AND `CategorisationIndustrySector`.`cat_type` = 'P') INNER JOIN category AS `IndustrySector` ON (`IndustrySector`.`uid` = `CategorisationIndustrySector`.`category_id` AND `IndustrySector`.`lft` >= '1769' AND `IndustrySector`.`rgt` <= '1874') LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND `Inlicensing`.`is_out` = 'N' GROUP BY `Inlicensing`.`uid` ORDER BY `Inlicensing`.`viewed_counter` DESC, `Inlicensing`.`title` ASC LIMIT 10

SELECT COUNT(DISTINCT Inlicensing.uid) AS `count` FROM `licopp` AS `Inlicensing` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Inlicensing`.`company_id` AND `ParentCompany`.`is_live`="Y") INNER JOIN categorisation AS `CategorisationIndustrySector` ON (`CategorisationIndustrySector`.`company_id` = `Inlicensing`.`uid` AND `CategorisationIndustrySector`.`cat_type` = 'P') INNER JOIN category AS `IndustrySector` ON (`IndustrySector`.`uid` = `CategorisationIndustrySector`.`category_id` AND `IndustrySector`.`lft` >= '1769' AND `IndustrySector`.`rgt` <= '1874') LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND `Inlicensing`.`is_out` = 'N'

(report) 1 query took 1 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `reports`		17	17	1

(report) 1 query took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `reports`

(report_slave) 1 query took 4 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	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 ("Medical device") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Medical device") DESC , MarketResearchReport.published DESC LIMIT 10		10	10	4

(report_slave) 1 query took 4 ms

Query

Error

Affected

Num. rows

Took (ms)

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 ("Medical device") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Medical device") DESC , MarketResearchReport.published DESC LIMIT 10