Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Companies: Laboratorios Dermatologicos Darier, S.A. de C.V
RSS Feeds
Search

Companies

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

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.

The company in detail

Profile

Darier Laboratories is a vertically integrated specialty pharmaceutical company that develops, manufactures and commercializes dermatrology products and solutions. Darier has unique strengths in go to market abilities, product-enhancement and development, clinical development, manufacturing, and regulatory affairs, which make the company a proven partner of choice for early to late stage compounds and novel branded prescription pharmaceutical products and technologies. Darier Laboratories is the market leader in Dermatology in Mexico, with marketing and go-to-market resources in Latin America added to a development and production unit (GMP accreditation) in Mexico. Darier's product offer includes a wide range of dermatological products, from prescription to Dermoceuticals. The line includes Acne, Atopical Dermatitis, Sunscreens and Skin Cancer. Thanks to an exclusive niche strategy from its creation, Darier has been consistently performing above the average and occupies today the lead with more than 10% market share (IMS) in México. The strength of Darier lies on the best combination of high product quality and innovation as well as privileged relationships with Dermatologists and Pediatricians built up over 24 years. Darier operates its own factory that runs under GMP excellence standards. Besides a versatile plant, it recently inaugurated (2005) a modern steroids plant. It also performs toll and contract manufacturing for third parties at highly competitive cost/quality standards. More than 35 Free Trade unilateral and multilateral Agreements (NAFTA, EU, etc.) confer to Mexico a unique position in the International Trade.

Partnering strategy/interests

Darier is actively seeking collaborations, strategic alliances and business development opportunities including: 1) New product developments in dermatology, from finished products/line extensions to New Chemical Entities (early to late stages), including but not limited to Acne, Atopic Dermatitis and Skin Cancer protection. This can happen through In-Licensing, co-development, acquisitions. Patents preferred. 2) New Delivery Systems and innovatie topical and oral technologies. 3) Out-Licensing and Exports: existing product lines of Darier (pharma and dermo/cosmeceuticals) as well as patented New Chemicals Entities in Dermatology available outside of México 4) Toll and Contract Manufacturing (including but not limited to semi-solids, solids and steroids).

Out-licensing

Novel patent pending in dermatology: combination of a well known topical antibiotic with a topical steroid indicated for skin infections with inflammatory process More

In-licensing

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

Services

Full manufacturing outsourcing in a complete GMPs/ISO9002 facility

more

Contact details

Dir. Juan-Carlos Lozano
Business Development Director
Business Development

Contact directly

Full contact list

Head office

Laboratorios Dermatologicos Darier, S.A. de C.V
Insurgentes Sur No 3579
Torre 3 Piso 8
Locales 801-804
Col.Tlalpan
Mexico

Company figures

Formed: 1982
Annual Turnover: 40,000,000 (2005)
Number of employees: 315

Related categories

© Copyright 1998-2012 Innovaro Europe Ltd Innovaro Corporation All rights reserved. Terms and Conditions | Contact us

(website) 98 queries took 162 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `company`272710
2DESCRIBE `condet`17172
3DESCRIBE `countrycode`441
4DESCRIBE `person`15154
5DESCRIBE `account`29291
6DESCRIBE `product_legacy`661
7DESCRIBE `sales_people`663
8DESCRIBE `profile`14141
9DESCRIBE `currencies`771
10DESCRIBE `update_rec`771
11DESCRIBE `user`24241
12DESCRIBE `enquiry`14141
13DESCRIBE `module_types`661
14DESCRIBE `dms_companies`26261
15DESCRIBE `dms_releases`10101
16DESCRIBE `dms_categories`441
17DESCRIBE `dms_clinical_areas`441
18DESCRIBE `dms_categories_dms_releases`221
19DESCRIBE `dms_clinical_areas_dms_releases`220
20DESCRIBE `dms_releases_sites`551
21DESCRIBE `licopp`23231
22DESCRIBE `development_statuses`551
23DESCRIBE `category`14141
24DESCRIBE `categories_sites`551
25DESCRIBE `categorisation`881
26DESCRIBE `licopps_sites`330
27DESCRIBE `service`15153
28DESCRIBE `press_release`13136
29DESCRIBE `press_releases_sites`551
30DESCRIBE `story`12128
31DESCRIBE `sites_stories`551
32DESCRIBE `story_assoc`442
33DESCRIBE `companies_sites`331
34DESCRIBE `categories_users`221
35DESCRIBE `authority`334
36DESCRIBE `sites_users`551
37DESCRIBE `products`881
38DESCRIBE `sites`554
39SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1110
40SELECT `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`, `Contact`.`uid`, `Contact`.`address`, `Contact`.`street1`, `Contact`.`street2`, `Contact`.`city`, `Contact`.`district`, `Contact`.`postcode`, `Contact`.`telswitch`, `Contact`.`teldirect`, `Contact`.`cellphone`, `Contact`.`fax`, `Contact`.`faxdirect`, `Contact`.`email`, `Contact`.`url`, `Contact`.`country`, `Contact`.`office`, `Contact`.`company_id`, `PrimaryContact`.`uid`, `PrimaryContact`.`salutation`, `PrimaryContact`.`forename`, `PrimaryContact`.`surname`, `PrimaryContact`.`nickname`, `PrimaryContact`.`postfix`, `PrimaryContact`.`jobtitle`, `PrimaryContact`.`company_id`, `PrimaryContact`.`company_primary_contact`, `PrimaryContact`.`department`, `PrimaryContact`.`condet_id`, `PrimaryContact`.`assistant_id`, `PrimaryContact`.`notes_id`, `PrimaryContact`.`user_id`, `PrimaryContact`.`public`, `Account`.`uid`, `Account`.`company_id`, `Account`.`product`, `Account`.`maxlic`, `Account`.`maxpress`, `Account`.`maxjob`, `Account`.`uselic`, `Account`.`usepress`, `Account`.`usejob`, `Account`.`subscribed`, `Account`.`renewal`, `Account`.`priceover`, `Account`.`maxevent`, `Account`.`useevent`, `Account`.`profile`, `Account`.`maxserv`, `Account`.`useserv`, `Account`.`promotion`, `Account`.`maxilic`, `Account`.`useilic`, `Account`.`site_id`, `Account`.`budget`, `Account`.`vat_number`, `Account`.`sales_person_id`, `Account`.`cc_number`, `Account`.`cc_expiry_date`, `Account`.`ipay_client_id`, `Account`.`ipay_account_id`, `Account`.`terms_accepted`, `Profile`.`uid`, `Profile`.`company_id`, `Profile`.`update_id`, `Profile`.`body`, `Profile`.`formed`, `Profile`.`stock_symbol`, `Profile`.`stock_exchange`, `Profile`.`ownership`, `Profile`.`employees`, `Profile`.`annualrep`, `Profile`.`turnover`, `Profile`.`turnyear`, `Profile`.`currency_id`, `Profile`.`needs`, `DmsCompany`.`id`, `DmsCompany`.`company_id`, `DmsCompany`.`name`, `DmsCompany`.`url`, `DmsCompany`.`email`, `DmsCompany`.`founded`, `DmsCompany`.`address`, `DmsCompany`.`zip`, `DmsCompany`.`city`, `DmsCompany`.`state`, `DmsCompany`.`country`, `DmsCompany`.`region`, `DmsCompany`.`primary_phone`, `DmsCompany`.`secondary_phone`, `DmsCompany`.`abstract`, `DmsCompany`.`summary`, `DmsCompany`.`management`, `DmsCompany`.`primary_parent_company`, `DmsCompany`.`secondary_parent_company`, `DmsCompany`.`subsidiary_names`, `DmsCompany`.`exchanges`, `DmsCompany`.`is_public`, `DmsCompany`.`is_dead`, `DmsCompany`.`last_changed`, `DmsCompany`.`created`, `DmsCompany`.`modified`, `CompanySite`.`id`, `CompanySite`.`company_id`, `CompanySite`.`site_id` FROM `company` AS `Company` LEFT JOIN `condet` AS `Contact` ON (`Company`.`condet_id` = `Contact`.`uid`) LEFT JOIN `person` AS `PrimaryContact` ON (`PrimaryContact`.`public`="Y" AND `PrimaryContact`.`company_primary_contact` = 1 AND `Company`.`person_id` = `PrimaryContact`.`uid`) LEFT JOIN `account` AS `Account` ON (`Account`.`company_id` = `Company`.`uid`) LEFT JOIN `profile` AS `Profile` ON (`Profile`.`company_id` = `Company`.`uid`) LEFT JOIN `dms_companies` AS `DmsCompany` ON (`DmsCompany`.`company_id` = `Company`.`uid`) LEFT JOIN `companies_sites` AS `CompanySite` ON (`CompanySite`.`company_id` = `Company`.`uid`) WHERE `CompanySite`.`site_id` = 1 AND `Company`.`uid` = 10405 LIMIT 1113
41SELECT `Contact`.`uid`, `Contact`.`address`, `Contact`.`street1`, `Contact`.`street2`, `Contact`.`city`, `Contact`.`district`, `Contact`.`postcode`, `Contact`.`telswitch`, `Contact`.`teldirect`, `Contact`.`cellphone`, `Contact`.`fax`, `Contact`.`faxdirect`, `Contact`.`email`, `Contact`.`url`, `Contact`.`country`, `Contact`.`office`, `Contact`.`company_id` FROM `condet` AS `Contact` WHERE `Contact`.`uid` = 37604 111
42SELECT `Country`.`uid`, `Country`.`country`, `Country`.`eu_member`, `Country`.`isocode` FROM `countrycode` AS `Country` WHERE `Country`.`uid` = 243 110
43SELECT `PrimaryContact`.`uid`, `PrimaryContact`.`salutation`, `PrimaryContact`.`forename`, `PrimaryContact`.`surname`, `PrimaryContact`.`nickname`, `PrimaryContact`.`postfix`, `PrimaryContact`.`jobtitle`, `PrimaryContact`.`company_id`, `PrimaryContact`.`company_primary_contact`, `PrimaryContact`.`department`, `PrimaryContact`.`condet_id`, `PrimaryContact`.`assistant_id`, `PrimaryContact`.`notes_id`, `PrimaryContact`.`user_id`, `PrimaryContact`.`public` FROM `person` AS `PrimaryContact` WHERE `PrimaryContact`.`public`="Y" AND `PrimaryContact`.`company_primary_contact` = 1 AND `PrimaryContact`.`uid` = 29317 111
44SELECT `Account`.`uid`, `Account`.`company_id`, `Account`.`product`, `Account`.`maxlic`, `Account`.`maxpress`, `Account`.`maxjob`, `Account`.`uselic`, `Account`.`usepress`, `Account`.`usejob`, `Account`.`subscribed`, `Account`.`renewal`, `Account`.`priceover`, `Account`.`maxevent`, `Account`.`useevent`, `Account`.`profile`, `Account`.`maxserv`, `Account`.`useserv`, `Account`.`promotion`, `Account`.`maxilic`, `Account`.`useilic`, `Account`.`site_id`, `Account`.`budget`, `Account`.`vat_number`, `Account`.`sales_person_id`, `Account`.`cc_number`, `Account`.`cc_expiry_date`, `Account`.`ipay_client_id`, `Account`.`ipay_account_id`, `Account`.`terms_accepted` FROM `account` AS `Account` WHERE `Account`.`company_id` = 10405 114
45SELECT `Profile`.`uid`, `Profile`.`company_id`, `Profile`.`update_id`, `Profile`.`body`, `Profile`.`formed`, `Profile`.`stock_symbol`, `Profile`.`stock_exchange`, `Profile`.`ownership`, `Profile`.`employees`, `Profile`.`annualrep`, `Profile`.`turnover`, `Profile`.`turnyear`, `Profile`.`currency_id`, `Profile`.`needs` FROM `profile` AS `Profile` WHERE `Profile`.`company_id` = 10405 112
46SELECT `DmsCompany`.`id`, `DmsCompany`.`company_id`, `DmsCompany`.`name`, `DmsCompany`.`url`, `DmsCompany`.`email`, `DmsCompany`.`founded`, `DmsCompany`.`address`, `DmsCompany`.`zip`, `DmsCompany`.`city`, `DmsCompany`.`state`, `DmsCompany`.`country`, `DmsCompany`.`region`, `DmsCompany`.`primary_phone`, `DmsCompany`.`secondary_phone`, `DmsCompany`.`abstract`, `DmsCompany`.`summary`, `DmsCompany`.`management`, `DmsCompany`.`primary_parent_company`, `DmsCompany`.`secondary_parent_company`, `DmsCompany`.`subsidiary_names`, `DmsCompany`.`exchanges`, `DmsCompany`.`is_public`, `DmsCompany`.`is_dead`, `DmsCompany`.`last_changed`, `DmsCompany`.`created`, `DmsCompany`.`modified` FROM `dms_companies` AS `DmsCompany` WHERE `DmsCompany`.`company_id` = 10405 000
47SELECT `CompanySite`.`id`, `CompanySite`.`company_id`, `CompanySite`.`site_id` FROM `companies_sites` AS `CompanySite` WHERE `CompanySite`.`company_id` = 10405 220
48SELECT `Service`.`id`, `Service`.`slug`, `Service`.`headline`, `Service`.`detail`, `Service`.`contact_id`, `Service`.`company_id` FROM `service` AS `Service` WHERE `Service`.`is_live` = 1 AND `Service`.`company_id` = (10405) ORDER BY `Service`.`headline` ASC 111
49SELECT `RegionalOffice`.`uid`, `RegionalOffice`.`address`, `RegionalOffice`.`street1`, `RegionalOffice`.`street2`, `RegionalOffice`.`city`, `RegionalOffice`.`district`, `RegionalOffice`.`postcode`, `RegionalOffice`.`telswitch`, `RegionalOffice`.`teldirect`, `RegionalOffice`.`cellphone`, `RegionalOffice`.`fax`, `RegionalOffice`.`faxdirect`, `RegionalOffice`.`email`, `RegionalOffice`.`url`, `RegionalOffice`.`country`, `RegionalOffice`.`office`, `RegionalOffice`.`company_id` FROM `condet` AS `RegionalOffice` WHERE `RegionalOffice`.`company_id` = (10405) ORDER BY `RegionalOffice`.`office` ASC 000
50SELECT `SecondaryContact`.`uid`, `SecondaryContact`.`salutation`, `SecondaryContact`.`forename`, `SecondaryContact`.`surname`, `SecondaryContact`.`nickname`, `SecondaryContact`.`postfix`, `SecondaryContact`.`jobtitle`, `SecondaryContact`.`company_id`, `SecondaryContact`.`company_primary_contact`, `SecondaryContact`.`department`, `SecondaryContact`.`condet_id`, `SecondaryContact`.`assistant_id`, `SecondaryContact`.`notes_id`, `SecondaryContact`.`user_id`, `SecondaryContact`.`public` FROM `person` AS `SecondaryContact` WHERE `SecondaryContact`.`company_primary_contact` = 0 AND `SecondaryContact`.`public`="y" AND `SecondaryContact`.`company_id` = (10405) ORDER BY `SecondaryContact`.`surname` ASC 110
51SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent` 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`=146 OR `Category`.`parent`=198 ORDER BY `Category`.`parent` ASC, `Category`.`name` ASC 77770
52SELECT `Inlicensing`.`uid`, `Inlicensing`.`slug`, `Inlicensing`.`title`, `Inlicensing`.`shortdesc`, `Inlicensing`.`is_anon`, `Inlicensing`.`contact_id` FROM `licopp` AS `Inlicensing` LEFT JOIN `person` AS `Person` ON (`Inlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Inlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Inlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Inlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `InlicensingSite` ON (`InlicensingSite`.`licopp_id` = `Inlicensing`.`uid`) WHERE `InlicensingSite`.`site_id` = 1 AND `Inlicensing`.`is_out` <> "Y" AND `Inlicensing`.`is_anon` = 'n' AND `Inlicensing`.`company_id` = 10405 ORDER BY `Inlicensing`.`title` ASC 331
53SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`title`, `Outlicensing`.`shortdesc`, `Outlicensing`.`is_anon`, `Outlicensing`.`contact_id` FROM `licopp` AS `Outlicensing` LEFT JOIN `person` AS `Person` ON (`Outlicensing`.`contact_id` = `Person`.`uid`) LEFT JOIN `development_statuses` AS `DevelopmentStatus` ON (`Outlicensing`.`devstatus` = `DevelopmentStatus`.`id`) LEFT JOIN `update_rec` AS `UpdateRecord` ON (`Outlicensing`.`update_id` = `UpdateRecord`.`uid`) LEFT JOIN `company` AS `Company` ON (`Outlicensing`.`company_id` = `Company`.`uid`) LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND `Outlicensing`.`is_out` = 'Y' AND `Outlicensing`.`is_anon` = 'n' AND `Outlicensing`.`company_id` = 10405 ORDER BY `Outlicensing`.`title` ASC 1112
54SELECT `Deal`.`uid`, `Deal`.`slug`, `Deal`.`created`, `Deal`.`lastmod`, `Deal`.`issued`, `Deal`.`author`, `Deal`.`author_email`, `Deal`.`headline`, `Deal`.`summary`, `Deal`.`body`, `Deal`.`is_live`, `Deal`.`viewed_counter`, `DealSite`.`id`, `DealSite`.`story_id`, `DealSite`.`created`, `DealSite`.`modified`, `DealSite`.`site_id` FROM `story` AS `Deal` inner JOIN story_assoc AS `DealAssoc` ON (`DealAssoc`.`story_id`=`Deal`.`uid` AND `DealAssoc`.`assoc_id`="10405" AND `DealAssoc`.`type`="company") LEFT JOIN `sites_stories` AS `DealSite` ON (`DealSite`.`story_id` = `Deal`.`uid`) WHERE `DealSite`.`site_id` = 1 AND `Deal`.`is_live` = 1 006
55SELECT `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`.`company_id` = 10405 AND `Press`.`is_live` = 1 ORDER BY `Press`.`issued` DESC 0037
56SELECT c.uid, c.name, c.root FROM category c INNER JOIN category cc ON cc.uid = c.clan INNER JOIN categorisation ctg ON ctg.category_id = c.uid AND ctg.cat_type = "C" WHERE ctg.company_id = 10405 AND c.restricted IS NULL ORDER BY cc.name, c.level 16160
57SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 741 ORDER BY `par`.`lft` ASC 220
58SELECT `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` = (741) ORDER BY `name` ASC 000
59SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2029 ORDER BY `par`.`lft` ASC 220
60SELECT `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` = (2029) ORDER BY `name` ASC 000
61SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2032 ORDER BY `par`.`lft` ASC 220
62SELECT `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` = (2032) ORDER BY `name` ASC 000
63SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 603 ORDER BY `par`.`lft` ASC 110
64SELECT `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` = (603) ORDER BY `name` ASC 33330
65SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 604 ORDER BY `par`.`lft` ASC 228
66SELECT `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` = (604) ORDER BY `name` ASC 000
67SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 607 ORDER BY `par`.`lft` ASC 220
68SELECT `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` = (607) ORDER BY `name` ASC 000
69SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 609 ORDER BY `par`.`lft` ASC 220
70SELECT `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` = (609) ORDER BY `name` ASC 000
71SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 614 ORDER BY `par`.`lft` ASC 220
72SELECT `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` = (614) ORDER BY `name` ASC 000
73SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 1816 ORDER BY `par`.`lft` ASC 220
74SELECT `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` = (1816) ORDER BY `name` ASC 000
75SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 2052 ORDER BY `par`.`lft` ASC 220
76SELECT `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` = (2052) ORDER BY `name` ASC 000
77SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 1548 ORDER BY `par`.`lft` ASC 220
78SELECT `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` = (1548) ORDER BY `name` ASC 330
79SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 1548 ORDER BY `par`.`lft` ASC 220
80SELECT `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` = (1548) ORDER BY `name` ASC 330
81SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 299 ORDER BY `par`.`lft` ASC 221
82SELECT `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` = (299) ORDER BY `name` ASC 000
83SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 300 ORDER BY `par`.`lft` ASC 220
84SELECT `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` = (300) ORDER BY `name` ASC 000
85SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 301 ORDER BY `par`.`lft` ASC 220
86SELECT `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` = (301) ORDER BY `name` ASC 000
87SELECT `par`.`uid`, `par`.`name`, `Category`.`uid` FROM `category` AS `Category` JOIN category AS `par` ON (`Category`.`lft` BETWEEN `par`.`lft` AND `par`.`rgt` AND `par`.`level` >= 2) 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` = 302 ORDER BY `par`.`lft` ASC 220
88SELECT `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` = (302) ORDER BY `name` ASC 000
89SELECT Authority.user_id FROM authority AS Authority WHERE company_id = 10405 ORDER BY primary_user DESC220
90SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1110
91UPDATE company SET viewed_counter = viewed_counter + 1 WHERE uid = 10405 19
92DESCRIBE `statistics`771
93SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'company' LIMIT 1110
94SELECT `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` = '10405' AND `company_id` = 10405 AND `module_type_id` = '2' AND `hit_date` = '2012-05-22' LIMIT 1113
95SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10693024 110
96SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10693024 110
97SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10693024 110
98UPDATE `statistics` SET `id` = 10693024, `module_type_id` = '2', `company_id` = 10405, `business_object_id` = '10405', `count` = 9, `hit_date` = '2012-05-22', `is_aggregated` = 0 WHERE `statistics`.`id` = 1069302410
(default) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)
(report) 2 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `reports`17171
2SELECT `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 ("Laboratorios Dermatologicos Darier, S.A. de C.V") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Laboratorios Dermatologicos Darier, `S`.`A`. de `C`.`V`") DESC , MarketResearchReport.published DESC LIMIT 1010102