Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Out-licensing: Advanced Wound Care Products
RSS Feeds
Search

Out-licensing

Advanced Wound Care Products

Innocoll, Inc.
Collagen-based dressings for wound management

Full description

Collagen is the body's structural building block, comprising about 95% of bone, 75% of skin, and is the main component of other connective tissues (cartilage, tendon and ligament). 27 different types of collagen are known and these have been classified according to molecular composition and tissue distribution. Bone, dermis, tendon, and ligament are predominantly type-I collagen.

Collagen also has important pharmacological properties. It promotes epithelization and tissue granulation through the stimulation of growth factors and increased production of host collagen by fibroblasts, especially when these cells are able to migrate and bind to an extracellular matrix such as provided by a collagen dressing or implant.

Collagen dressings are fully biodegradable. Collagenase enzymes slowly degrade the dressing into constituent amino acids and peptides, such that it is gradually remodelled and replaced by host type-I collagen. This sequence of cellular response, absorption and remodelling of a collagen dressing or implant resembles the normal wound healing mechanism.

Innocoll is developing a series of collagen-based dressings for advanced wound care:

CollaGUARD(TM) and CollaGUARD(TM) Ag

Type-I collagen membrane (or film-type) dressing indicated for the management of superficial and deep wounds, including coverage of skin ulcers and temporary dematoplasty in the case of lesions and burns. CollaGUARD (branded COLLIEVA(TM) in the US) is already approved in Europe as a CE-marked, class III medical device and a US 510k application has also been approved. CollaGUARD Ag includes silver for added antimicrobial action in the management of infected wounds. (EU and US regulatory submission are planned for 2008).

DermaSIL(TM)

A proprietary composite dressing (US patent granted) comprising a collagen layer adhered to silicon foam in order to maintain an optimal wound healing environment. The product is specifically designed for the treatment of deep wounds, or wounds that penetrate the middle and deepest layers of skin, or dermis. These deep wounds occur in second- or third-degree burns and in a variety of acute and/or chronic skin disorders, such as leg and pressure ulcers. EU and US medical device applications are planned for 2008.

Anesthetic and other Medicated Dressings

Innocoll is also seeking partnerships with wound care companies interested in utilizing the CollaRx technology to develop medicated dressings for advanced wound care. The primary application identified is the introduction of a local anesthetic agent to provide pain relief.

Innocoll has already established the feasibility of incorporating such agents (e.g. bupivacaine) into the CollaRx platforms and has filed and IND for CollaRX Bupivacaine Topical intended for the treatment of painful chronic wounds. Other areas of interest include the development of collagen dressings containing antimicrobials to combine the benefits of infection control with wound healing.

Development status

Registered

Type of business relationship sought

Marketing and distribution partnerships for CollaGUARD, CollaGUARD Ag, and DermaSIL in all regions except the US.

Co-development and marketing partners for CollaRx Bupivacaine Topical.

Related reports

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

(website) 79 queries took 606 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `licopp`232312
2DESCRIBE `company`272712
3DESCRIBE `condet`17173
4DESCRIBE `countrycode`447
5DESCRIBE `person`15155
6DESCRIBE `account`292914
7DESCRIBE `product_legacy`668
8DESCRIBE `sales_people`665
9DESCRIBE `profile`14144
10DESCRIBE `currencies`777
11DESCRIBE `update_rec`771
12DESCRIBE `user`24245
13DESCRIBE `enquiry`141414
14DESCRIBE `module_types`665
15DESCRIBE `dms_companies`262616
16DESCRIBE `dms_releases`101017
17DESCRIBE `dms_categories`4410
18DESCRIBE `dms_clinical_areas`445
19DESCRIBE `dms_categories_dms_releases`224
20DESCRIBE `dms_clinical_areas_dms_releases`221
21DESCRIBE `dms_releases_sites`551
22DESCRIBE `development_statuses`5514
23DESCRIBE `category`14146
24DESCRIBE `categories_sites`5510
25DESCRIBE `categorisation`8811
26DESCRIBE `licopps_sites`336
27DESCRIBE `service`15151
28DESCRIBE `press_release`131335
29DESCRIBE `press_releases_sites`552
30DESCRIBE `story`121218
31DESCRIBE `sites_stories`5512
32DESCRIBE `story_assoc`447
33DESCRIBE `companies_sites`3337
34DESCRIBE `categories_users`224
35DESCRIBE `authority`331
36DESCRIBE `sites_users`557
37DESCRIBE `sites`555
38SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1111
39SELECT `Outlicensing`.`uid`, `Outlicensing`.`slug`, `Outlicensing`.`company_id`, `Outlicensing`.`update_id`, `Outlicensing`.`title`, `Outlicensing`.`shortdesc`, `Outlicensing`.`mechanism`, `Outlicensing`.`body`, `Outlicensing`.`contact_id`, `Outlicensing`.`otherinfo`, `Outlicensing`.`patent`, `Outlicensing`.`change_time`, `Outlicensing`.`devstatus`, `Outlicensing`.`url`, `Outlicensing`.`flags`, `Outlicensing`.`is_anon`, `Outlicensing`.`is_out`, `Outlicensing`.`active`, `Outlicensing`.`viewed_counter`, `Outlicensing`.`created`, `Outlicensing`.`external_id`, `Outlicensing`.`md5`, `Outlicensing`.`patent_number`, `Person`.`uid`, `Person`.`salutation`, `Person`.`forename`, `Person`.`surname`, `Person`.`nickname`, `Person`.`postfix`, `Person`.`jobtitle`, `Person`.`company_id`, `Person`.`company_primary_contact`, `Person`.`department`, `Person`.`condet_id`, `Person`.`assistant_id`, `Person`.`notes_id`, `Person`.`user_id`, `Person`.`public`, `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name`, `DevelopmentStatus`.`display_order`, `DevelopmentStatus`.`created`, `DevelopmentStatus`.`modified`, `UpdateRecord`.`uid`, `UpdateRecord`.`created`, `UpdateRecord`.`last_change`, `UpdateRecord`.`last_changed_by`, `UpdateRecord`.`revision`, `UpdateRecord`.`change_credit`, `UpdateRecord`.`expiry`, `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`, `OutlicensingSite`.`id`, `OutlicensingSite`.`licopp_id`, `OutlicensingSite`.`site_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`.`uid` = 4156 AND `Outlicensing`.`is_out` = 'Y' LIMIT 1117
40SELECT `Person`.`uid`, `Person`.`salutation`, `Person`.`forename`, `Person`.`surname`, `Person`.`nickname`, `Person`.`postfix`, `Person`.`jobtitle`, `Person`.`company_id`, `Person`.`company_primary_contact`, `Person`.`department`, `Person`.`condet_id`, `Person`.`assistant_id`, `Person`.`notes_id`, `Person`.`user_id`, `Person`.`public` FROM `person` AS `Person` WHERE `Person`.`uid` = 28540 112
41SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name`, `DevelopmentStatus`.`display_order`, `DevelopmentStatus`.`created`, `DevelopmentStatus`.`modified` FROM `development_statuses` AS `DevelopmentStatus` WHERE `DevelopmentStatus`.`id` = 8 111
42SELECT `UpdateRecord`.`uid`, `UpdateRecord`.`created`, `UpdateRecord`.`last_change`, `UpdateRecord`.`last_changed_by`, `UpdateRecord`.`revision`, `UpdateRecord`.`change_credit`, `UpdateRecord`.`expiry` FROM `update_rec` AS `UpdateRecord` WHERE `UpdateRecord`.`uid` = 4904 111
43SELECT `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` FROM `company` AS `Company` WHERE `Company`.`uid` = 4754 112
44SELECT `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` = 26507 114
45SELECT `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`.`company_primary_contact` = 1 AND `PrimaryContact`.`uid` = 28540 111
46SELECT `OutlicensingSite`.`id`, `OutlicensingSite`.`licopp_id`, `OutlicensingSite`.`site_id` FROM `licopps_sites` AS `OutlicensingSite` WHERE `OutlicensingSite`.`licopp_id` = 4156 221
47SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` = 4156 AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="L" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC 10101
48SELECT `Category`.`uid`, `Category`.`name`, `Category`.`root` FROM `category` AS `Category` INNER JOIN categorisation AS `Categorisation` ON (`Categorisation`.`category_id` = `Category`.`uid`) 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 `cat_type` = 'L' AND `company_id` = '4156' ORDER BY `Category`.`name` ASC, `Category`.`level` ASC 101011
49SELECT `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 (505, 1812, 1965, 1713, 1968, 453, 1973, 1818, 615, 1976) ORDER BY `name` ASC 11111
50SELECT `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` = 505 ORDER BY `par`.`lft` ASC 111
51SELECT `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` = (505) ORDER BY `name` ASC 883
52SELECT `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` = 1812 ORDER BY `par`.`lft` ASC 220
53SELECT `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` = (1812) ORDER BY `name` ASC 000
54SELECT `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` = 1965 ORDER BY `par`.`lft` ASC 222
55SELECT `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` = (1965) ORDER BY `name` ASC 001
56SELECT `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` = 1713 ORDER BY `par`.`lft` ASC 221
57SELECT `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` = (1713) ORDER BY `name` ASC 002
58SELECT `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` = 1968 ORDER BY `par`.`lft` ASC 221
59SELECT `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` = (1968) ORDER BY `name` ASC 001
60SELECT `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` = 453 ORDER BY `par`.`lft` ASC 111
61SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` = (453) ORDER BY `name` ASC 331
62SELECT `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` = 1973 ORDER BY `par`.`lft` ASC 221
63SELECT `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` = (1973) ORDER BY `name` ASC 001
64SELECT `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` = 1818 ORDER BY `par`.`lft` ASC 221
65SELECT `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` = (1818) ORDER BY `name` ASC 000
66SELECT `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` = 615 ORDER BY `par`.`lft` ASC 221
67SELECT `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` = (615) ORDER BY `name` ASC 001
68SELECT `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` = 1976 ORDER BY `par`.`lft` ASC 223
69SELECT `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` = (1976) ORDER BY `name` ASC 000
70SELECT l.uid, l.slug, l.title, l.shortdesc, sum(c.level) AS score FROM licopp l INNER JOIN categorisation ctg ON ctg.company_id = l.uid AND ctg.cat_type = "L" INNER JOIN categorisation ctg2 ON ctg.category_id = ctg2.category_id AND ctg2.company_id = "4156" AND ctg2.cat_type = "L" INNER JOIN category c ON ctg.category_id = c.uid WHERE l.uid <> 4156 AND c.root = 560 GROUP BY l.uid, l.title, l.shortdesc ORDER BY score DESC, l.viewed_counter DESC LIMIT 5 55105
71SELECT Authority.user_id FROM authority AS Authority WHERE company_id = 4754 ORDER BY primary_user DESC3338
72SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1111
73UPDATE licopp SET viewed_counter = viewed_counter + 1 WHERE uid = 4156 137
74SELECT `Outlicensing`.`company_id` FROM `licopp` AS `Outlicensing` LEFT JOIN `licopps_sites` AS `OutlicensingSite` ON (`OutlicensingSite`.`licopp_id` = `Outlicensing`.`uid`) WHERE `OutlicensingSite`.`site_id` = 1 AND `Outlicensing`.`uid` = 4156 LIMIT 1111
75DESCRIBE `statistics`771
76SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'outlicensing' LIMIT 1110
77SELECT `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` = '4156' AND `company_id` = 4754 AND `module_type_id` = '4' AND `hit_date` = '2012-05-24' LIMIT 10036
78INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 4754, '4156', '4', '2012-05-24')10
79SELECT LAST_INSERT_ID() AS insertID110
(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 ("Advanced Wound Care Products") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Advanced Wound Care Products") DESC , MarketResearchReport.published DESC LIMIT 1010102