Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]
Innovaro Pharmalicensing brings you advice, commentary and analysis from industry experts.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `event` | 26 | 26 | 1 | |
| 2 | DESCRIBE `company` | 27 | 27 | 1 | |
| 3 | DESCRIBE `condet` | 17 | 17 | 2 | |
| 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 | 0 | |
| 9 | DESCRIBE `profile` | 14 | 14 | 1 | |
| 10 | DESCRIBE `currencies` | 7 | 7 | 0 | |
| 11 | DESCRIBE `update_rec` | 7 | 7 | 1 | |
| 12 | DESCRIBE `user` | 24 | 24 | 1 | |
| 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 | 0 | |
| 17 | DESCRIBE `dms_categories` | 4 | 4 | 0 | |
| 18 | DESCRIBE `dms_clinical_areas` | 4 | 4 | 1 | |
| 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 | 0 | |
| 22 | DESCRIBE `licopp` | 23 | 23 | 1 | |
| 23 | DESCRIBE `development_statuses` | 5 | 5 | 0 | |
| 24 | DESCRIBE `category` | 14 | 14 | 1 | |
| 25 | DESCRIBE `categories_sites` | 5 | 5 | 1 | |
| 26 | DESCRIBE `categorisation` | 8 | 8 | 1 | |
| 27 | DESCRIBE `licopps_sites` | 3 | 3 | 0 | |
| 28 | DESCRIBE `service` | 15 | 15 | 1 | |
| 29 | DESCRIBE `press_release` | 13 | 13 | 1 | |
| 30 | DESCRIBE `press_releases_sites` | 5 | 5 | 0 | |
| 31 | DESCRIBE `story` | 12 | 12 | 1 | |
| 32 | DESCRIBE `sites_stories` | 5 | 5 | 0 | |
| 33 | DESCRIBE `story_assoc` | 4 | 4 | 0 | |
| 34 | DESCRIBE `companies_sites` | 3 | 3 | 0 | |
| 35 | DESCRIBE `categories_users` | 2 | 2 | 0 | |
| 36 | DESCRIBE `authority` | 3 | 3 | 1 | |
| 37 | DESCRIBE `sites_users` | 5 | 5 | 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 `Event`.`id`, `Event`.`slug`, `Event`.`legacy_id`, `Event`.`company_id`, `Event`.`issued`, `Event`.`ends`, `Event`.`headline`, `Event`.`detail`, `Event`.`body`, `Event`.`content`, `Event`.`email`, `Event`.`contact`, `Event`.`regform`, `Event`.`url`, `Event`.`telephone`, `Event`.`location`, `Event`.`venue`, `Event`.`course`, `Event`.`prices`, `Event`.`featured`, `Event`.`created`, `Event`.`modified`, `Event`.`is_live`, `Event`.`flags`, `Event`.`organizer`, `Event`.`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` FROM `event` AS `Event` LEFT JOIN `company` AS `Company` ON (`Event`.`company_id` = `Company`.`uid` AND `Company`.`is_live` = 'Y') WHERE `Event`.`is_live` > 0 AND ((DATE(`Event`.`issued`) >= DATE(now())) OR (DATE(`Event`.`ends`) >= DATE(now()))) GROUP BY `Company`.`uid` ORDER BY `Company`.`name` ASC | 32 | 32 | 19 | |
| 41 | SELECT `Event`.`id`, `Event`.`slug`, `Event`.`legacy_id`, `Event`.`company_id`, `Event`.`issued`, `Event`.`ends`, `Event`.`headline`, `Event`.`detail`, `Event`.`body`, `Event`.`content`, `Event`.`email`, `Event`.`contact`, `Event`.`regform`, `Event`.`url`, `Event`.`telephone`, `Event`.`location`, `Event`.`venue`, `Event`.`course`, `Event`.`prices`, `Event`.`featured`, `Event`.`created`, `Event`.`modified`, `Event`.`is_live`, `Event`.`flags`, `Event`.`organizer`, `Event`.`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` FROM `event` AS `Event` INNER JOIN company AS `CompanyLive` ON (`Event`.`company_id`=`CompanyLive`.`uid` AND `CompanyLive`.`is_live`="Y") LEFT JOIN `company` AS `Company` ON (`Event`.`company_id` = `Company`.`uid` AND `Company`.`is_live` = 'Y') WHERE `Event`.`is_live` > 0 AND ((DATE(`Event`.`issued`) >= DATE(now())) OR (DATE(`Event`.`ends`) >= DATE(now()))) AND `Event`.`issued` >= "2012-07-01 00:00:00" AND `Event`.`issued` <= "2012-07-31 23:59:59" ORDER BY `Event`.`issued` ASC LIMIT 0, 10 | 6 | 6 | 10 | |
| 42 | SELECT COUNT(*) AS `count` FROM `event` AS `Event` INNER JOIN company AS `CompanyLive` ON (`Event`.`company_id`=`CompanyLive`.`uid` AND `CompanyLive`.`is_live`="Y") LEFT JOIN `company` AS `Company` ON (`Event`.`company_id` = `Company`.`uid` AND `Company`.`is_live` = 'Y') WHERE `Event`.`is_live` > 0 AND ((DATE(`Event`.`issued`) >= DATE(now())) OR (DATE(`Event`.`ends`) >= DATE(now()))) AND `Event`.`issued` >= "2012-07-01 00:00:00" AND `Event`.`issued` <= "2012-07-31 23:59:59" | 1 | 1 | 9 |