| 1 | DESCRIBE `service` | | 15 | 15 | 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 | 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 | 11 |
| 20 | DESCRIBE `dms_clinical_areas_dms_releases` | | 2 | 2 | 1 |
| 21 | DESCRIBE `dms_releases_sites` | | 5 | 5 | 13 |
| 22 | DESCRIBE `licopp` | | 23 | 23 | 1 |
| 23 | DESCRIBE `development_statuses` | | 5 | 5 | 2 |
| 24 | DESCRIBE `category` | | 14 | 14 | 1 |
| 25 | DESCRIBE `categories_sites` | | 5 | 5 | 4 |
| 26 | DESCRIBE `categorisation` | | 8 | 8 | 2 |
| 27 | DESCRIBE `licopps_sites` | | 3 | 3 | 1 |
| 28 | DESCRIBE `press_release` | | 13 | 13 | 1 |
| 29 | DESCRIBE `press_releases_sites` | | 5 | 5 | 13 |
| 30 | DESCRIBE `story` | | 12 | 12 | 1 |
| 31 | DESCRIBE `sites_stories` | | 5 | 5 | 3 |
| 32 | DESCRIBE `story_assoc` | | 4 | 4 | 14 |
| 33 | DESCRIBE `companies_sites` | | 3 | 3 | 1 |
| 34 | DESCRIBE `categories_users` | | 2 | 2 | 1 |
| 35 | DESCRIBE `authority` | | 3 | 3 | 0 |
| 36 | DESCRIBE `sites_users` | | 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 `Service`.`legacy_id`, `Service`.`company_id`, `Service`.`created`, `Service`.`modified`, `Service`.`headline`, `Service`.`contact_id`, `Service`.`detail`, `Service`.`body`, `Service`.`url`, `Service`.`is_live`, `Service`.`id`, `Service`.`viewed_counter`, `Service`.`last_modified_by_user_id`, `Service`.`revision`, `Service`.`slug`, `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`, `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 `service` AS `Service` INNER JOIN company AS `ParentCompany` ON (`ParentCompany`.`uid`=`Service`.`company_id` AND `ParentCompany`.`is_live`="Y") LEFT JOIN `person` AS `Person` ON (`Service`.`contact_id` = `Person`.`uid`) LEFT JOIN `company` AS `Company` ON (`Service`.`company_id` = `Company`.`uid`) WHERE `Service`.`id` = 179 AND `Service`.`is_live` > 0 LIMIT 1 | | 1 | 1 | 8 |
| 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` = 29317 | | 1 | 1 | 0 |
| 41 | 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` = 10405 | | 1 | 1 | 1 |
| 42 | 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` = 37604 | | 1 | 1 | 0 |
| 43 | 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` = 29317 | | 1 | 1 | 0 |
| 44 | 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` = 179 AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="V" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC | | 1 | 1 | 0 |
| 45 | SELECT Category.uid, Category.parent, Category.name, Category.level, Category.lft,
SUM(IF (Category.uid = Categorisation.category_id ,1,0)) AS is_categorised, 0 AS is_to_add, 0 AS is_to_remove,CASE Category.root WHEN '712' THEN 0 ELSE CASE Category.uid WHEN '712' THEN 0 ELSE NULL END END AS root_order FROM category AS RootCategory JOIN categories_sites AS CategoriesSites ON RootCategory.uid=CategoriesSites.category_id AND CategoriesSites.site_id=1 LEFT JOIN categorisation AS
Categorisation ON Categorisation.category_id=RootCategory.uid AND
Categorisation.company_id='179' AND Categorisation.cat_type='V' 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 (712) GROUP BY Category.uid
ORDER BY root_order,lft | | 3 | 3 | 0 |
| 46 | 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 |
| 47 | UPDATE `service` AS `Service` LEFT JOIN `person` AS `Person` ON (`Service`.`contact_id` = `Person`.`uid`) LEFT JOIN `user` AS `UpdateUser` ON (`Service`.`last_modified_by_user_id` = `UpdateUser`.`uid`) LEFT JOIN `company` AS `Company` ON (`Service`.`company_id` = `Company`.`uid`) SET `Service`.`viewed_counter` = Service.viewed_counter + 1 WHERE `Service`.`id` = 179 | | 1 | | 2 |
| 48 | SELECT `Service`.`company_id` FROM `service` AS `Service` WHERE `Service`.`id` = 179 LIMIT 1 | | 1 | 1 | 0 |
| 49 | DESCRIBE `statistics` | | 7 | 7 | 1 |
| 50 | SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'service' LIMIT 1 | | 1 | 1 | 0 |
| 51 | 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` = '179' AND `company_id` = 10405 AND `module_type_id` = '12' AND `hit_date` = '2012-05-24' LIMIT 1 | | 0 | 0 | 9 |
| 52 | INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 10405, '179', '12', '2012-05-24') | | 1 | | 1 |
| 53 | SELECT LAST_INSERT_ID() AS insertID | | 1 | 1 | 0 |
All rights reserved. Terms and Conditions | Contact us