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
Company details

Orpha Swiss GmbH

OrPha Swiss is looking of in - and out-licensing opportunities in the field of anaesthesia, intensive care, neurology, pulmonary hypertension and addiction medicine

Profile

OrPha Swiss GmbH is a Swiss pharmaceutical company. We are a distributor and marketer of orphan drugs as well as value added and niche generics in the Swiss, Austrian and certain Eastern European markets. We are focussed mainly in niche areas such as anaesthesia, intensive care, neurology, pulmonary hypertension and addiction medicine. Together with partner companies we have our own product development to expand our product portfolio. In export markets we are working with distributors worldwide (except of USA).

Partnering strategy/interests

We are interested to find distributors outside our core territory for our products.

We are also looking for foreign developers and manufacturers of niche products or orphan drugs (originator products as well as generics) that are themselves looking for a distributor of their products in Switzerland and Austria.

Out-licensing

Droperidol 1.25mg/1ml ampoule

Injectable for treatment of PONV and nausea and vomiting during post-operative PCA More

Esmolol 100mg/10ml vial

Ultrashort acting beta blocker Esmolol for use in anesthesia, intensive care, cardiology and internal medicine. More

Esmolol 2500 mg/10ml ampoule

Ultrashort acting beta blocker Esmolol for use in anesthesia, intensive care, cardiology and internal medicine. More

Nalbuphine 20mg/2ml ampoule

Kappa opioid receptor agonist/ mü antagonist providing analgesia, while preventing respiratory depression More

Naloxone 0,4 mg/ml ampoule

Opioid receptor antagonist reducing opioid induced respiratory depression More

Naltrexone 50 mg film tablet:

Opioid receptor blocker which reduces desire for opioids and alcohol, use in psychiatry, neurology and addition medicine. More

Tetrabenazine 25 mg tablets

Treatment of movement disorders associated with organic central nervous system conditions, e.g. Huntington's chorea, hemiballismus and senile chorea. More

In-licensing

Injectables and oral medicines for hospital use

In-licensing injectables andoral medicines for the hospital market, originals for orphan/nichemarkets More

Related Reports

Market Research Reports provided by reports.innovaro.com

Swiss Reinsurance Company Ltd: SWOT Analysis & Company Profile

Mar 2010 - 30 pages - $99

Swiss Life Holding: SWOT Analysis & Company Profile

Oct 2010 - 22 pages - $99

Swiss Post - Company Capsule

Aug 2011 - 8 pages - $75

Foodservice in Switzerland to 2011

Sep 2008 - 55 pages - $495

Automotive Aftermarket Overview and Products in Switzerland to 2012

Apr 2008 - 43 pages - $2,295

Top 10 Companies in the Swiss Life Sciences Industry: IT Spending Predictor 2010

Dec 2010 - 98 pages - $495

Automotive Aftermarket Overview and Channels in Switzerland to 2012

Apr 2008 - 44 pages - $2,295

Foodservice in Switzerland to 2012

Jul 2010 - 46 pages - $495

Swiss Re Group - SWOT Analysis

Jul 2010 - 31 pages - $125

Swiss Post - Company Capsule

Nov 2011 - 9 pages - $75

Contact details

Dr. Juerg Fehlmann
Business Development Manager

Contact directly

Head office

Orpha Swiss GmbH
Untere Hesilbachstr. 41a
Kuesnacht
8700
Switzerland

Visit website

Contact head office

Related categories

Industry sector: Pharmaceutical; Pharmaceutical / Prescription; Pharmaceutical / Generics
Therapeutic target: Cardiovascular / Vascular / Hypotension; Central Nervous System / Psychiatric / Addiction; Hospital and Surgery / Anesthesia

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) 76 queries took 118 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `company`	27	27	4
2	DESCRIBE `condet`	17	17	1
3	DESCRIBE `countrycode`	4	4	1
4	DESCRIBE `person`	15	15	1
5	DESCRIBE `account`	29	29	1
6	DESCRIBE `product_legacy`	6	6	1
7	DESCRIBE `sales_people`	6	6	1
8	DESCRIBE `profile`	14	14	1
9	DESCRIBE `currencies`	7	7	1
10	DESCRIBE `update_rec`	7	7	1
11	DESCRIBE `user`	24	24	1
12	DESCRIBE `enquiry`	14	14	1
13	DESCRIBE `module_types`	6	6	5
14	DESCRIBE `dms_companies`	26	26	2
15	DESCRIBE `dms_releases`	10	10	1
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	2
22	DESCRIBE `development_statuses`	5	5	1
23	DESCRIBE `category`	14	14	1
24	DESCRIBE `categories_sites`	5	5	1
25	DESCRIBE `categorisation`	8	8	1
26	DESCRIBE `licopps_sites`	3	3	1
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	0
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	0
40	SELECT `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` = 12659 LIMIT 1	1	1	8
41	SELECT `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` = 41044	1	1	3
42	SELECT `Country`.`uid`, `Country`.`country`, `Country`.`eu_member`, `Country`.`isocode` FROM `countrycode` AS `Country` WHERE `Country`.`uid` = 41	1	1	0
43	SELECT `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` = 29078	1	1	0
44	SELECT `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` = 12659	1	1	4
45	SELECT `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` = 12659	1	1	0
46	SELECT `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` = 12659	0	0	0
47	SELECT `CompanySite`.`id`, `CompanySite`.`company_id`, `CompanySite`.`site_id` FROM `companies_sites` AS `CompanySite` WHERE `CompanySite`.`company_id` = 12659	1	1	1
48	SELECT `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` = (12659) ORDER BY `Service`.`headline` ASC	0	0	9
49	SELECT `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` = (12659) ORDER BY `RegionalOffice`.`office` ASC	0	0	0
50	SELECT `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` = (12659) ORDER BY `SecondaryContact`.`surname` ASC	0	0	0
51	SELECT `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	77	77	0
52	SELECT `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` = 12659 ORDER BY `Inlicensing`.`title` ASC	1	1	1
53	SELECT `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` = 12659 ORDER BY `Outlicensing`.`title` ASC	7	7	1
54	SELECT `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`="12659" 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	0	0	4
55	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`.`company_id` = 12659 AND `Press`.`is_live` = 1 ORDER BY `Press`.`issued` DESC	0	0	30
56	SELECT 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 = 12659 AND c.restricted IS NULL ORDER BY cc.name, c.level	6	6	0
57	SELECT `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` = 1862 ORDER BY `par`.`lft` ASC	3	3	0
58	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` = (1862) ORDER BY `name` ASC	0	0	0
59	SELECT `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` = 1885 ORDER BY `par`.`lft` ASC	3	3	0
60	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` = (1885) ORDER BY `name` ASC	0	0	0
61	SELECT `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` = 1615 ORDER BY `par`.`lft` ASC	2	2	0
62	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` = (1615) ORDER BY `name` ASC	0	0	0
63	SELECT `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` = 298 ORDER BY `par`.`lft` ASC	1	1	0
64	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` = (298) ORDER BY `name` ASC	6	6	0
65	SELECT `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	2	2	0
66	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` = (299) ORDER BY `name` ASC	0	0	0
67	SELECT `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	2	2	0
68	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` = (301) ORDER BY `name` ASC	0	0	0
69	SELECT Authority.user_id FROM authority AS Authority WHERE company_id = 12659 ORDER BY primary_user DESC	3	3	0
70	SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1	1	1	0
71	UPDATE company SET viewed_counter = viewed_counter + 1 WHERE uid = 12659	1		2
72	DESCRIBE `statistics`	7	7	1
73	SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'company' LIMIT 1	1	1	0
74	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` = '12659' AND `company_id` = 12659 AND `module_type_id` = '2' AND `hit_date` = '2012-05-17' LIMIT 1	0	0	8
75	INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 12659, '12659', '2', '2012-05-17')	1		0
76	SELECT LAST_INSERT_ID() AS insertID	1	1	0

(website) 76 queries took 118 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 `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` = 12659 LIMIT 1

SELECT `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` = 41044

SELECT `Country`.`uid`, `Country`.`country`, `Country`.`eu_member`, `Country`.`isocode` FROM `countrycode` AS `Country` WHERE `Country`.`uid` = 41

SELECT `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` = 29078

SELECT `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` = 12659

SELECT `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` = 12659

SELECT `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` = 12659

SELECT `CompanySite`.`id`, `CompanySite`.`company_id`, `CompanySite`.`site_id` FROM `companies_sites` AS `CompanySite` WHERE `CompanySite`.`company_id` = 12659

SELECT `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` = (12659) ORDER BY `Service`.`headline` ASC

SELECT `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` = (12659) ORDER BY `RegionalOffice`.`office` ASC

SELECT `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` = (12659) ORDER BY `SecondaryContact`.`surname` ASC

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

SELECT `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` = 12659 ORDER BY `Inlicensing`.`title` ASC

SELECT `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` = 12659 ORDER BY `Outlicensing`.`title` ASC

SELECT `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`="12659" 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

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`.`company_id` = 12659 AND `Press`.`is_live` = 1 ORDER BY `Press`.`issued` DESC

SELECT 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 = 12659 AND c.restricted IS NULL ORDER BY cc.name, c.level

SELECT `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` = 1862 ORDER BY `par`.`lft` 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` = (1862) ORDER BY `name` ASC

SELECT Authority.user_id FROM authority AS Authority WHERE company_id = 12659 ORDER BY primary_user DESC

SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1

UPDATE company SET viewed_counter = viewed_counter + 1 WHERE uid = 12659

DESCRIBE `statistics`

SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'company' 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` = '12659' AND `company_id` = 12659 AND `module_type_id` = '2' AND `hit_date` = '2012-05-17' LIMIT 1

INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 12659, '12659', '2', '2012-05-17')

SELECT LAST_INSERT_ID() AS insertID

(report) 2 queries took 2 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 ("Orpha Swiss GmbH") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Orpha Swiss GmbH") DESC , MarketResearchReport.published DESC LIMIT 10		10	10	1

(report) 2 queries took 2 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 ("Orpha Swiss GmbH") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Orpha Swiss GmbH") DESC , MarketResearchReport.published DESC LIMIT 10