Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Catheter-associated urinary tract infection (CAUTI) is the most common nosocomial infection in hospitals and nursing homes. It has been associated with increased morbidity, mortality, increased length of stay in hospitals and increased costs. Although CAUTI can occur in patients with short to medium term catheters (less than 30 days), it is a major issue in patients with long term urinary catheters due to blockage of urinary catheters. Some patients are more prone to blockage than others and can block their catheter several times a year. These "frequent blockers" represent between 15% and 20% of the overall population of long term catheterized patients.
There is no proven effective prevention technique for both CAUTI and catheter blockage other than using sterile techniques when inserting and taking care of the catheter and frequent replacement of blocked catheters. Some silver coated or antiseptic impregnated catheters may delay the onset of blockage with some patients but sooner or later the catheters will get blocked.
NovaBay has developed a catheter irrigation solution containing NVC-422, a non-antibiotic, broad spectrum anti-microbial agent with activity on viruses, gram + and - bacteria and fungi with the potential to reduce the buildup of urologic pathogens in the bladder and the lumen of catheters. In addition, NVC-422 catheter irrigation solution has been shown to prevent the formation of biofilms, thereby potentially reducing the incidence of blockage as well as limiting the colonization of those biofilms by pathogens.
NVC-422 catheter irrigation solution was shown to be safe at concentrations up to 0.1% in a human phase 1 study. In vitro studies have shown no development of resistance. One dose three times a week, flushed through the catheter into the bladder and left for 15 minutes before being drained, NVC-422 has the potential for being a simple, effective alternative for reducing the incidence of UTI and blockage in patients with long term indwelling Foley catheters.
Patients that would benefit most from an effective prevention method for CAUTI and catheter blockage include stroke, ALS, Alzheimer, spinal cord injury, multiple sclerosis and Parkinson's patients, comprising most of the long term urinary catheter population.
While there is no effective prevention method, saline and renacidin are sometimes used for prevention of blockage despite any clinical evidence of efficacy. Renacidin irrigation solution needs to be administered two to three times every day to be effective. There is also no drug that we are aware of that is in development for this indication.
The composition of matter patent for NVC-422 has issued in the US and pending in other countries. Additional utility and formulation patent applications have been filedĀ in multiple countries.
Phase 2b study results expected in Q2 2012
NovaBay is planning to commercialize this product in the US. We are seeking a collaboration partner to participate in the phase 3 program and to commercialize this product in the rest of the world.
NovaBay is a clinical stage biotechnology company developing a first-in-class, anti-infective platform of compounds called the AganocideĀ® compounds.
View profile| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `licopp` | 23 | 23 | 1 | |
| 2 | DESCRIBE `company` | 27 | 27 | 1 | |
| 3 | DESCRIBE `condet` | 17 | 17 | 1 | |
| 4 | DESCRIBE `countrycode` | 4 | 4 | 0 | |
| 5 | DESCRIBE `person` | 15 | 15 | 1 | |
| 6 | DESCRIBE `account` | 29 | 29 | 1 | |
| 7 | DESCRIBE `product_legacy` | 6 | 6 | 1 | |
| 8 | DESCRIBE `sales_people` | 6 | 6 | 1 | |
| 9 | DESCRIBE `profile` | 14 | 14 | 1 | |
| 10 | DESCRIBE `currencies` | 7 | 7 | 1 | |
| 11 | DESCRIBE `update_rec` | 7 | 7 | 1 | |
| 12 | DESCRIBE `user` | 24 | 24 | 2 | |
| 13 | DESCRIBE `enquiry` | 14 | 14 | 1 | |
| 14 | DESCRIBE `module_types` | 6 | 6 | 0 | |
| 15 | DESCRIBE `dms_companies` | 26 | 26 | 1 | |
| 16 | DESCRIBE `dms_releases` | 10 | 10 | 1 | |
| 17 | DESCRIBE `dms_categories` | 4 | 4 | 0 | |
| 18 | DESCRIBE `dms_clinical_areas` | 4 | 4 | 0 | |
| 19 | DESCRIBE `dms_categories_dms_releases` | 2 | 2 | 0 | |
| 20 | DESCRIBE `dms_clinical_areas_dms_releases` | 2 | 2 | 0 | |
| 21 | DESCRIBE `dms_releases_sites` | 5 | 5 | 1 | |
| 22 | DESCRIBE `development_statuses` | 5 | 5 | 0 | |
| 23 | DESCRIBE `category` | 14 | 14 | 1 | |
| 24 | DESCRIBE `categories_sites` | 5 | 5 | 0 | |
| 25 | DESCRIBE `categorisation` | 8 | 8 | 1 | |
| 26 | DESCRIBE `licopps_sites` | 3 | 3 | 0 | |
| 27 | DESCRIBE `service` | 15 | 15 | 1 | |
| 28 | DESCRIBE `press_release` | 13 | 13 | 1 | |
| 29 | DESCRIBE `press_releases_sites` | 5 | 5 | 0 | |
| 30 | DESCRIBE `story` | 12 | 12 | 1 | |
| 31 | DESCRIBE `sites_stories` | 5 | 5 | 1 | |
| 32 | DESCRIBE `story_assoc` | 4 | 4 | 0 | |
| 33 | DESCRIBE `companies_sites` | 3 | 3 | 0 | |
| 34 | DESCRIBE `categories_users` | 2 | 2 | 0 | |
| 35 | DESCRIBE `authority` | 3 | 3 | 0 | |
| 36 | DESCRIBE `sites_users` | 5 | 5 | 0 | |
| 37 | DESCRIBE `sites` | 5 | 5 | 1 | |
| 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 | 0 | |
| 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` = 19388 AND `Outlicensing`.`is_out` = 'Y' LIMIT 1 | 1 | 1 | 1 | |
| 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` = 49120 | 1 | 1 | 0 | |
| 41 | SELECT `DevelopmentStatus`.`id`, `DevelopmentStatus`.`name`, `DevelopmentStatus`.`display_order`, `DevelopmentStatus`.`created`, `DevelopmentStatus`.`modified` FROM `development_statuses` AS `DevelopmentStatus` WHERE `DevelopmentStatus`.`id` = 4 | 1 | 1 | 0 | |
| 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` = 8800 | 1 | 1 | 0 | |
| 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` = 21172 | 1 | 1 | 1 | |
| 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` = 60108 | 1 | 1 | 0 | |
| 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` = 49120 | 1 | 1 | 0 | |
| 46 | SELECT `OutlicensingSite`.`id`, `OutlicensingSite`.`licopp_id`, `OutlicensingSite`.`site_id` FROM `licopps_sites` AS `OutlicensingSite` WHERE `OutlicensingSite`.`licopp_id` = 19388 | 2 | 2 | 0 | |
| 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` = 19388 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 | 0 | |
| 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` = '19388' ORDER BY `Category`.`name` ASC, `Category`.`level` ASC | 10 | 10 | 0 | |
| 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 (2137, 456, 631, 641, 1619, 562, 453, 496, 2125, 469) ORDER BY `name` ASC | 66 | 66 | 0 | |
| 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` = 2137 ORDER BY `par`.`lft` ASC | 2 | 2 | 0 | |
| 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` = (2137) ORDER BY `name` ASC | 16 | 16 | 0 | |
| 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` = 456 ORDER BY `par`.`lft` ASC | 3 | 3 | 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` = (456) 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` = 631 ORDER BY `par`.`lft` ASC | 1 | 1 | 0 | |
| 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` = (631) ORDER BY `name` ASC | 6 | 6 | 0 | |
| 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` = 641 ORDER BY `par`.`lft` ASC | 1 | 1 | 0 | |
| 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` = (641) ORDER BY `name` ASC | 20 | 20 | 0 | |
| 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` = 1619 ORDER BY `par`.`lft` ASC | 2 | 2 | 0 | |
| 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` = (1619) ORDER BY `name` ASC | 0 | 0 | 0 | |
| 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` = 562 ORDER BY `par`.`lft` ASC | 1 | 1 | 0 | |
| 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` = (562) ORDER BY `name` ASC | 7 | 7 | 0 | |
| 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` = 453 ORDER BY `par`.`lft` ASC | 1 | 1 | 0 | |
| 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` = (453) ORDER BY `name` ASC | 3 | 3 | 0 | |
| 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` = 496 ORDER BY `par`.`lft` ASC | 3 | 3 | 0 | |
| 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` = (496) 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` = 2125 ORDER BY `par`.`lft` ASC | 2 | 2 | 0 | |
| 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` = (2125) ORDER BY `name` ASC | 14 | 14 | 0 | |
| 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` = 469 ORDER BY `par`.`lft` ASC | 3 | 3 | 0 | |
| 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` = (469) 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 = "19388" AND ctg2.cat_type = "L" INNER JOIN category c ON ctg.category_id = c.uid WHERE l.uid <> 19388 AND c.root = 560 GROUP BY l.uid, l.title, l.shortdesc ORDER BY score DESC, l.viewed_counter DESC LIMIT 5 | 5 | 5 | 353 | |
| 71 | SELECT Authority.user_id FROM authority AS Authority WHERE company_id = 21172 ORDER BY primary_user DESC | 1 | 1 | 0 | |
| 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 | 0 | |
| 73 | UPDATE licopp SET viewed_counter = viewed_counter + 1 WHERE uid = 19388 | 1 | 6 | ||
| 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` = 19388 LIMIT 1 | 1 | 1 | 0 | |
| 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` = '19388' AND `company_id` = 21172 AND `module_type_id` = '4' AND `hit_date` = '2012-05-21' LIMIT 1 | 1 | 1 | 1 | |
| 78 | SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10690553 | 1 | 1 | 0 | |
| 79 | SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10690553 | 1 | 1 | 0 | |
| 80 | SELECT COUNT(*) AS `count` FROM `statistics` AS `Statistic` WHERE `Statistic`.`id` = 10690553 | 1 | 1 | 0 | |
| 81 | UPDATE `statistics` SET `id` = 10690553, `module_type_id` = '4', `company_id` = 21172, `business_object_id` = '19388', `count` = 2, `hit_date` = '2012-05-21', `is_aggregated` = 0 WHERE `statistics`.`id` = 10690553 | 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 ("NVC-422 for Urinary catheter blockage and encrustation (UCBE)") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("NVC-422 for Urinary catheter blockage and encrustation (UCBE)") DESC , MarketResearchReport.published DESC LIMIT 10 | 10 | 10 | 1 |