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

Companies

Companies
Browse

Companies

Displaying 1..10 of 16 - per page Next page
Order by

Laboratorios Dermatologicos Darier, S.A. de C.V

Darier Laboratories is a vertically integrated specialty pharmaceutical company that develops, manufactures, markets, and sells therapies and technologies exclusively in dermatology. More

Center for Genetic Engineering and Biotechnology (CIGB)

Laboratorios Senosiain

Laboratorios Senosiain S.A. de C.V. is Mexican company dedicated to the development, production and comercialisation of quality pharmaceutical products. More

CIMAB SA

Especificos Stendhal, SA de CV

Rimaco Inc

MEH Consulting--Mexico

BurnsAdler Pharmaceutical Laboratories, Ltd (see Tanner Pharmaceuticals Ltd)

Consultofarma S.A.

VPR Group

Displaying 1..10 of 16 - per page Next page
Order by

Related Reports

Market Research Reports provided by reports.innovaro.com

IP VPN Market Forecast in South and Central America to 2016

Apr 2011 - 44 pages - $795

Regional Broadband Overview: South and Central America

Feb 2011 - 49 pages - $2,500

Enterprise Applications Market Forecast in Central and Latin America to 2014

Apr 2011 - 31 pages - $795

Internet Services Market in South and Central America to 2012

May 2009 - 46 pages - $695

Mobile Application Download Volume and Revenue Forecast in South & Central America to 2015

Dec 2010 - 30 pages - $695

Wealth Management Technology Spending in South and Central America to 2015

Apr 2011 - 61 pages - $995

Wholesale Voice Market in South and Central America - Traffic and Revenue Forecasts to 2015

Apr 2011 - 47 pages - $795

ATM and Frame Relay Market Forecast in South and Central America to 2015

Apr 2011 - 31 pages - $795

Mobile Communications Market in South and Central America to 2013

May 2009 - 55 pages - $695

Product Insights: Global Product Innovation Update, September 2010

Sep 2010 - 71 pages - $400

Your selection

Geographic location: Central America del

Browse By

Industry sector: Academic/Research; Animal health; Biotechnology; Diagnostic; Drug delivery; Drug discovery; Medical device; Non-profit org./Government; Pharmaceutical; Research tools; Service
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
Geographic location: Anguilla; Antigua and Barbuda; Bahamas; Barbados; Belize; Cayman Islands; Costa Rica; Cuba; Curacao; Dominica; Dominican Republic; El Salvador; Grand Turk Island; Grenada; Guadeloupe; Guatemala; Haiti; Honduras; Jamaica; Martinique; Mexico; Montserrat; Nicaragua; Panama; Puerto Rico; St Kitts-Nevis; St Lucia; St Vincent; Trinidad and Tobago; Turks and Caicos Islands; Virgin Islands

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) 48 queries took 80 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `company`	27	27	7
2	DESCRIBE `condet`	17	17	1
3	DESCRIBE `countrycode`	4	4	1
4	DESCRIBE `person`	15	15	1
5	DESCRIBE `account`	29	29	2
6	DESCRIBE `product_legacy`	6	6	1
7	DESCRIBE `sales_people`	6	6	3
8	DESCRIBE `profile`	14	14	2
9	DESCRIBE `currencies`	7	7	1
10	DESCRIBE `update_rec`	7	7	3
11	DESCRIBE `user`	24	24	3
12	DESCRIBE `enquiry`	14	14	2
13	DESCRIBE `module_types`	6	6	1
14	DESCRIBE `dms_companies`	26	26	2
15	DESCRIBE `dms_releases`	10	10	0
16	DESCRIBE `dms_categories`	4	4	1
17	DESCRIBE `dms_clinical_areas`	4	4	1
18	DESCRIBE `dms_categories_dms_releases`	2	2	1
19	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	1
20	DESCRIBE `dms_releases_sites`	5	5	1
21	DESCRIBE `licopp`	23	23	1
22	DESCRIBE `development_statuses`	5	5	1
23	DESCRIBE `category`	14	14	2
24	DESCRIBE `categories_sites`	5	5	1
25	DESCRIBE `categorisation`	8	8	1
26	DESCRIBE `licopps_sites`	3	3	0
27	DESCRIBE `service`	15	15	1
28	DESCRIBE `press_release`	13	13	1
29	DESCRIBE `press_releases_sites`	5	5	1
30	DESCRIBE `story`	12	12	1
31	DESCRIBE `sites_stories`	5	5	1
32	DESCRIBE `story_assoc`	4	4	1
33	DESCRIBE `companies_sites`	3	3	1
34	DESCRIBE `categories_users`	2	2	1
35	DESCRIBE `authority`	3	3	1
36	DESCRIBE `sites_users`	5	5	1
37	DESCRIBE `products`	8	8	1
38	DESCRIBE `sites`	5	5	1
39	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	9
40	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` = 297 ORDER BY `Category`.`name` ASC	11	11	0
41	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 (527, 505, 303, 432, 319, 798, 453, 514, 298, 805, 534) ORDER BY `name` ASC	111	111	0
42	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 ORDER BY `Category`.`name` ASC	20	20	1
43	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	1
44	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` = 212 ORDER BY `Category`.`name` ASC	31	31	3
45	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 (213, 214, 227, 215, 236, 216, 237, 223, 217, 218, 231, 238, 220, 221, 222, 239, 228, 240, 224, 225, 243, 226, 241, 242, 230, 232, 233, 234, 229, 219, 235) ORDER BY `name` ASC	0	0	1
46	SELECT c.lft, c.rgt FROM category c WHERE c.uid = 212	1	1	0
47	SELECT c.uid, c.name, c.level FROM category c WHERE c.lft <= "2185" AND c.rgt >= "2248" AND c.level > 1 ORDER BY c.level	1	1	0
48	SELECT `Category`.`lft`, `Category`.`rgt`, `Category`.`uid` 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`.`uid` = 212 LIMIT 1	1	1	12

(website) 48 queries took 80 ms

Query

Error

Affected

Num. rows

Took (ms)

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

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` = 297 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 (527, 505, 303, 432, 319, 798, 453, 514, 298, 805, 534) ORDER BY `name` ASC

111

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

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 (213, 214, 227, 215, 236, 216, 237, 223, 217, 218, 231, 238, 220, 221, 222, 239, 228, 240, 224, 225, 243, 226, 241, 242, 230, 232, 233, 234, 229, 219, 235) ORDER BY `name` ASC

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

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

SELECT `Category`.`lft`, `Category`.`rgt`, `Category`.`uid` 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`.`uid` = 212 LIMIT 1

(website_slave) 2 queries took 272 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`summary`, `Company`.`is_customer` FROM `company` AS `Company` INNER JOIN condet AS `ContactGeographicLocation` ON (`Company`.`condet_id` = `ContactGeographicLocation`.`uid`) INNER JOIN category AS `GeographicLocation` ON (`GeographicLocation`.`uid` = `ContactGeographicLocation`.`country` AND `GeographicLocation`.`lft` >= '2185' AND `GeographicLocation`.`rgt` <= '2248') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2185') AND (`GeographicLocation`.`rgt` <= '2248')) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 10		10	10	152
2	SELECT COUNT(DISTINCT Company.uid) AS `count` FROM `company` AS `Company` INNER JOIN condet AS `ContactGeographicLocation` ON (`Company`.`condet_id` = `ContactGeographicLocation`.`uid`) INNER JOIN category AS `GeographicLocation` ON (`GeographicLocation`.`uid` = `ContactGeographicLocation`.`country` AND `GeographicLocation`.`lft` >= '2185' AND `GeographicLocation`.`rgt` <= '2248') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2185') AND (`GeographicLocation`.`rgt` <= '2248')) AND `Company`.`is_live` = 'Y'		1	1	120

(website_slave) 2 queries took 272 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Company`.`uid`, `Company`.`slug`, `Company`.`name`, `Company`.`summary`, `Company`.`is_customer` FROM `company` AS `Company` INNER JOIN condet AS `ContactGeographicLocation` ON (`Company`.`condet_id` = `ContactGeographicLocation`.`uid`) INNER JOIN category AS `GeographicLocation` ON (`GeographicLocation`.`uid` = `ContactGeographicLocation`.`country` AND `GeographicLocation`.`lft` >= '2185' AND `GeographicLocation`.`rgt` <= '2248') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2185') AND (`GeographicLocation`.`rgt` <= '2248')) AND `Company`.`is_live` = 'Y' GROUP BY `Company`.`uid` ORDER BY `Company`.`is_customer` DESC, `Company`.`viewed_counter` DESC, `Company`.`name` ASC LIMIT 10

152

SELECT COUNT(DISTINCT Company.uid) AS `count` FROM `company` AS `Company` INNER JOIN condet AS `ContactGeographicLocation` ON (`Company`.`condet_id` = `ContactGeographicLocation`.`uid`) INNER JOIN category AS `GeographicLocation` ON (`GeographicLocation`.`uid` = `ContactGeographicLocation`.`country` AND `GeographicLocation`.`lft` >= '2185' AND `GeographicLocation`.`rgt` <= '2248') LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND ((`GeographicLocation`.`lft` >= '2185') AND (`GeographicLocation`.`rgt` <= '2248')) AND `Company`.`is_live` = 'Y'

120

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

(report_slave) 1 query took 136 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 ("Central America") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Central America") DESC , MarketResearchReport.published DESC LIMIT 10

136