Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
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.
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.
Specialty pharmaceutical and drug delivery company engaged in the research and manufacture of collagen-based technologies for local drug delivery, surgical implants, advanced wound care and oncology.
View profile| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `licopp` | 23 | 23 | 12 | |
| 2 | DESCRIBE `company` | 27 | 27 | 12 | |
| 3 | DESCRIBE `condet` | 17 | 17 | 3 | |
| 4 | DESCRIBE `countrycode` | 4 | 4 | 7 | |
| 5 | DESCRIBE `person` | 15 | 15 | 5 | |
| 6 | DESCRIBE `account` | 29 | 29 | 14 | |
| 7 | DESCRIBE `product_legacy` | 6 | 6 | 8 | |
| 8 | DESCRIBE `sales_people` | 6 | 6 | 5 | |
| 9 | DESCRIBE `profile` | 14 | 14 | 4 | |
| 10 | DESCRIBE `currencies` | 7 | 7 | 7 | |
| 11 | DESCRIBE `update_rec` | 7 | 7 | 1 | |
| 12 | DESCRIBE `user` | 24 | 24 | 5 | |
| 13 | DESCRIBE `enquiry` | 14 | 14 | 14 | |
| 14 | DESCRIBE `module_types` | 6 | 6 | 5 | |
| 15 | DESCRIBE `dms_companies` | 26 | 26 | 16 | |
| 16 | DESCRIBE `dms_releases` | 10 | 10 | 17 | |
| 17 | DESCRIBE `dms_categories` | 4 | 4 | 10 | |
| 18 | DESCRIBE `dms_clinical_areas` | 4 | 4 | 5 | |
| 19 | DESCRIBE `dms_categories_dms_releases` | 2 | 2 | 4 | |
| 20 | DESCRIBE `dms_clinical_areas_dms_releases` | 2 | 2 | 1 | |
| 21 | DESCRIBE `dms_releases_sites` | 5 | 5 | 1 | |
| 22 | DESCRIBE `development_statuses` | 5 | 5 | 14 | |
| 23 | DESCRIBE `category` | 14 | 14 | 6 | |
| 24 | DESCRIBE `categories_sites` | 5 | 5 | 10 | |
| 25 | DESCRIBE `categorisation` | 8 | 8 | 11 | |
| 26 | DESCRIBE `licopps_sites` | 3 | 3 | 6 | |
| 27 | DESCRIBE `service` | 15 | 15 | 1 | |
| 28 | DESCRIBE `press_release` | 13 | 13 | 35 | |
| 29 | DESCRIBE `press_releases_sites` | 5 | 5 | 2 | |
| 30 | DESCRIBE `story` | 12 | 12 | 18 | |
| 31 | DESCRIBE `sites_stories` | 5 | 5 | 12 | |
| 32 | DESCRIBE `story_assoc` | 4 | 4 | 7 | |
| 33 | DESCRIBE `companies_sites` | 3 | 3 | 37 | |
| 34 | DESCRIBE `categories_users` | 2 | 2 | 4 | |
| 35 | DESCRIBE `authority` | 3 | 3 | 1 | |
| 36 | DESCRIBE `sites_users` | 5 | 5 | 7 | |
| 37 | DESCRIBE `sites` | 5 | 5 | 5 | |
| 38 | SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 39 | SELECT `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 1 | 1 | 1 | 7 | |
| 40 | SELECT `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 | 1 | 1 | 2 | |
| 41 | SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name`, `DevelopmentStatus`.`display_order`, `DevelopmentStatus`.`created`, `DevelopmentStatus`.`modified` FROM `development_statuses` AS `DevelopmentStatus` WHERE `DevelopmentStatus`.`id` = 8 | 1 | 1 | 1 | |
| 42 | SELECT `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 | 1 | 1 | 1 | |
| 43 | 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` FROM `company` AS `Company` WHERE `Company`.`uid` = 4754 | 1 | 1 | 2 | |
| 44 | 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` = 26507 | 1 | 1 | 4 | |
| 45 | 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`.`company_primary_contact` = 1 AND `PrimaryContact`.`uid` = 28540 | 1 | 1 | 1 | |
| 46 | SELECT `OutlicensingSite`.`id`, `OutlicensingSite`.`licopp_id`, `OutlicensingSite`.`site_id` FROM `licopps_sites` AS `OutlicensingSite` WHERE `OutlicensingSite`.`licopp_id` = 4156 | 2 | 2 | 1 | |
| 47 | SELECT `Category`.`uid`, `Category`.`name`, `Category`.`parent`, `Category`.`has_children`, `Category`.`show_children`, `Category`.`show_grandchildren`, `Category`.`members`, `Category`.`num_children`, `Category`.`root`, `Category`.`restricted`, `Category`.`clan`, `Category`.`lft`, `Category`.`rgt`, `Category`.`level`, `Categorisation`.`id`, `Categorisation`.`company_id`, `Categorisation`.`buysell`, `Categorisation`.`category_id`, `Categorisation`.`browse_category_id`, `Categorisation`.`cat_type`, `Categorisation`.`story_id`, `Categorisation`.`network_id` FROM `category` AS `Category` JOIN `categorisation` AS `Categorisation` ON (`Categorisation`.`company_id` = 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 | 10 | 10 | 1 | |
| 48 | SELECT `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 | 10 | 10 | 11 | |
| 49 | SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` IN (505, 1812, 1965, 1713, 1968, 453, 1973, 1818, 615, 1976) ORDER BY `name` ASC | 11 | 11 | 1 | |
| 50 | 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` = 505 ORDER BY `par`.`lft` ASC | 1 | 1 | 1 | |
| 51 | 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` = (505) ORDER BY `name` ASC | 8 | 8 | 3 | |
| 52 | 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` = 1812 ORDER BY `par`.`lft` ASC | 2 | 2 | 0 | |
| 53 | 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` = (1812) ORDER BY `name` ASC | 0 | 0 | 0 | |
| 54 | 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` = 1965 ORDER BY `par`.`lft` ASC | 2 | 2 | 2 | |
| 55 | 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` = (1965) ORDER BY `name` ASC | 0 | 0 | 1 | |
| 56 | 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` = 1713 ORDER BY `par`.`lft` ASC | 2 | 2 | 1 | |
| 57 | 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` = (1713) ORDER BY `name` ASC | 0 | 0 | 2 | |
| 58 | 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` = 1968 ORDER BY `par`.`lft` ASC | 2 | 2 | 1 | |
| 59 | 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` = (1968) ORDER BY `name` ASC | 0 | 0 | 1 | |
| 60 | 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` = 453 ORDER BY `par`.`lft` ASC | 1 | 1 | 1 | |
| 61 | SELECT `Child`.`uid`, `Child`.`name`, `Child`.`parent`, `Child`.`has_children`, `Child`.`show_children`, `Child`.`show_grandchildren`, `Child`.`members`, `Child`.`num_children`, `Child`.`root`, `Child`.`restricted`, `Child`.`clan`, `Child`.`lft`, `Child`.`rgt`, `Child`.`level` FROM `category` AS `Child` WHERE `Child`.`parent` = (453) ORDER BY `name` ASC | 3 | 3 | 1 | |
| 62 | 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` = 1973 ORDER BY `par`.`lft` ASC | 2 | 2 | 1 | |
| 63 | 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` = (1973) ORDER BY `name` ASC | 0 | 0 | 1 | |
| 64 | 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` = 1818 ORDER BY `par`.`lft` ASC | 2 | 2 | 1 | |
| 65 | 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` = (1818) ORDER BY `name` ASC | 0 | 0 | 0 | |
| 66 | 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` = 615 ORDER BY `par`.`lft` ASC | 2 | 2 | 1 | |
| 67 | 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` = (615) ORDER BY `name` ASC | 0 | 0 | 1 | |
| 68 | 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` = 1976 ORDER BY `par`.`lft` ASC | 2 | 2 | 3 | |
| 69 | 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` = (1976) ORDER BY `name` ASC | 0 | 0 | 0 | |
| 70 | SELECT 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 | 5 | 5 | 105 | |
| 71 | SELECT Authority.user_id FROM authority AS Authority WHERE company_id = 4754 ORDER BY primary_user DESC | 3 | 3 | 38 | |
| 72 | SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 73 | UPDATE licopp SET viewed_counter = viewed_counter + 1 WHERE uid = 4156 | 1 | 37 | ||
| 74 | SELECT `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 1 | 1 | 1 | 1 | |
| 75 | DESCRIBE `statistics` | 7 | 7 | 1 | |
| 76 | SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'outlicensing' LIMIT 1 | 1 | 1 | 0 | |
| 77 | 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` = '4156' AND `company_id` = 4754 AND `module_type_id` = '4' AND `hit_date` = '2012-05-24' LIMIT 1 | 0 | 0 | 36 | |
| 78 | INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 4754, '4156', '4', '2012-05-24') | 1 | 0 | ||
| 79 | SELECT LAST_INSERT_ID() AS insertID | 1 | 1 | 0 |
| Nr | Query | Error | Affected | Num. rows | Took (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 ("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 10 | 10 | 10 | 2 |