| 1 | DESCRIBE `press_release` | | 13 | 13 | 1 |
| 2 | DESCRIBE `company` | | 27 | 27 | 1 |
| 3 | DESCRIBE `condet` | | 17 | 17 | 1 |
| 4 | DESCRIBE `countrycode` | | 4 | 4 | 1 |
| 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 | 26 |
| 12 | DESCRIBE `user` | | 24 | 24 | 1 |
| 13 | DESCRIBE `enquiry` | | 14 | 14 | 1 |
| 14 | DESCRIBE `module_types` | | 6 | 6 | 1 |
| 15 | DESCRIBE `dms_companies` | | 26 | 26 | 1 |
| 16 | DESCRIBE `dms_releases` | | 10 | 10 | 1 |
| 17 | DESCRIBE `dms_categories` | | 4 | 4 | 1 |
| 18 | DESCRIBE `dms_clinical_areas` | | 4 | 4 | 1 |
| 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 | 6 |
| 22 | DESCRIBE `licopp` | | 23 | 23 | 5 |
| 23 | DESCRIBE `development_statuses` | | 5 | 5 | 1 |
| 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 | 1 |
| 28 | DESCRIBE `service` | | 15 | 15 | 1 |
| 29 | DESCRIBE `story` | | 12 | 12 | 1 |
| 30 | DESCRIBE `sites_stories` | | 5 | 5 | 1 |
| 31 | DESCRIBE `story_assoc` | | 4 | 4 | 0 |
| 32 | DESCRIBE `companies_sites` | | 3 | 3 | 1 |
| 33 | DESCRIBE `categories_users` | | 2 | 2 | 0 |
| 34 | DESCRIBE `authority` | | 3 | 3 | 1 |
| 35 | DESCRIBE `sites_users` | | 5 | 5 | 1 |
| 36 | DESCRIBE `press_releases_sites` | | 5 | 5 | 1 |
| 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 `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`.`uid` = '1325773429_4f05b2751fc19' LIMIT 1 | | 1 | 1 | 8 |
| 40 | 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`.`story_id` = '1325773429_4f05b2751fc19' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | | 0 | 0 | 1 |
| 41 | SELECT `Press`.`uid`, `Press`.`slug`, `Press`.`headline`, `Press`.`body`, `Press`.`issued` 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`='1139' AND `Press`.`is_live`=1 AND DATE(`Press`.`issued`) <= DATE(now()) AND `Press`.`uid` != "1325773429_4f05b2751fc19" ORDER BY `issued` DESC LIMIT 5 | | 5 | 5 | 42 |
| 42 | 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`.`story_id` IN ('1264690189_4b61a40da59c2', '1263461647_4b4ee50fec797', '1199698191_4781f10f97b10', '1185378481_46a770b17c59f', '1185193701_46a49ee52be37') AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | | 36 | 36 | 0 |
| 43 |
SELECT Press.uid, Press.slug, Press.issued, Press.headline, Press.summary FROM press_release AS Press WHERE Press.is_live = 1 AND Press.issued <= now()
GROUP BY Press.uid
ORDER BY Press.issued DESC
LIMIT 5 | | 5 | 5 | 1 |
| 44 | SELECT `Press`.`uid`, `Press`.`issued`, `Press`.`headline`, `Press`.`slug` 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`.`is_live` = 1 AND DATE(`Press`.`issued`) <= DATE(now()) ORDER BY `Press`.`viewed_counter` DESC, `Press`.`issued` DESC LIMIT 5 | | 5 | 5 | 73 |
| 45 |
SELECT Category.uid, Category.parent, Category.root, Category.name, Category.level, Category.lft,
CASE Category.root
WHEN '560' THEN 0
WHEN '297' THEN 1
ELSE CASE Category.uid
WHEN '560' THEN 0
WHEN '297' THEN 1
ELSE NULL END END AS root_order
FROM category AS RootCategory
LEFT JOIN categorisation AS Categorisation
ON Categorisation.category_id=RootCategory.uid AND Categorisation.story_id='1325773429_4f05b2751fc19' AND Categorisation.cat_type='R'
LEFT JOIN category AS Category
ON (Category.lft <= RootCategory.lft AND Category.rgt >= RootCategory.rgt AND Category.level > 0)
WHERE Categorisation.id IS NOT NULL AND
RootCategory.root IN (560, 297)
GROUP BY Category.uid
ORDER BY root_order,lft | | 0 | 0 | 0 |
| 46 | SELECT `Press`.`uid`, `Press`.`company_id`, `Press`.`viewed_counter` 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`.`uid`="1325773429_4f05b2751fc19" AND `Press`.`is_live`>0 LIMIT 1 | | 1 | 1 | 3 |
| 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`.`story_id` = '1325773429_4f05b2751fc19' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | | 0 | 0 | 0 |
| 48 | SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1325773429_4f05b2751fc19' | | 1 | 1 | 0 |
| 49 | SELECT COUNT(*) AS `count` FROM `press_release` AS `Press` WHERE `Press`.`uid` = '1325773429_4f05b2751fc19' | | 1 | 1 | 0 |
| 50 | UPDATE `press_release` SET `viewed_counter` = 696 WHERE `press_release`.`uid` = '1325773429_4f05b2751fc19' | | 1 | | 6 |
| 51 | SELECT `Press`.`uid` 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`.`uid` = '1325773429_4f05b2751fc19' LIMIT 1 | | 1 | 1 | 3 |
| 52 | 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`.`story_id` = '1325773429_4f05b2751fc19' AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="R" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | | 0 | 0 | 0 |
| 53 | SELECT `PressSite`.`id`, `PressSite`.`created`, `PressSite`.`modified`, `PressSite`.`press_release_id`, `PressSite`.`site_id` FROM `press_releases_sites` AS `PressSite` WHERE `site_id` = 1 AND `press_release_id` = '1325773429_4f05b2751fc19' | | 1 | 1 | 0 |
| 54 | DESCRIBE `statistics` | | 7 | 7 | 1 |
| 55 | SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'press' LIMIT 1 | | 1 | 1 | 0 |
| 56 | 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` = '1325773429_4f05b2751fc19' AND `company_id` = 1139 AND `module_type_id` = '9' AND `hit_date` = '2012-05-24' LIMIT 1 | | 0 | 0 | 1 |
| 57 | INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 1139, '1325773429_4f05b2751fc19', '9', '2012-05-24') | | 1 | | 0 |
| 58 | SELECT LAST_INSERT_ID() AS insertID | | 1 | 1 | 0 |
All rights reserved. Terms and Conditions | Contact us