Warning (512): /home/pharma/website/current/cakephp/app/pharmalicensing/tmp/cache/ is not writable [CORE/cake/libs/cache/file.php, line 267]

        if ($this->_init && !is_writable($this->settings['path'])) {
            $this->_init = false;
            trigger_error(sprintf(__('%s is not writable', true), $this->settings['path']), E_USER_WARNING);

FileEngine::__active() - CORE/cake/libs/cache/file.php, line 267
FileEngine::init() - CORE/cake/libs/cache/file.php, line 94
Cache::_buildEngine() - CORE/cake/libs/cache.php, line 151
Cache::config() - CORE/cake/libs/cache.php, line 126
include - /home/pharma/website/releases/20120317114903/cakephp/app/pharmalicensing/config/core.php, line 345
Configure::__loadBootstrap() - CORE/cake/libs/configure.php, line 391
Configure::getInstance() - CORE/cake/libs/configure.php, line 52
include - CORE/cake/bootstrap.php, line 38
[main] - /home/pharma/website/releases/20120317114903/cakephp/webroot/pharmalicensing/index.php, line 100

Services

Services
Rotarod

Rotarod

Rotarod: - This task is used to assess motor coordination, and can be used test the effects of drugs on coordination. The apparatus consists of a rotating cylinder that can be set to rotate either at a constant speed or to accelerate. The latency (under constant speed rotation) or the speed (at accelerating rotation) at which the test subject falls from the cylinder is measured.

Full description

Key benefits of use of services:

Project on time
Project right first time
Customer is our partner
People and facility are ready
Project costs cheaper in Asia

Related reports

Market Research Reports provided by reports.innovaro.com

Service contact

Mr Anthony Bishop
CEO

Contact directly

Company details

Cerca Insights Sdn Bhd

Discover MORE! Cerca Insights is a Malaysian based CRO focused on behavioural pharmacology

View profile

Visit website

Products:	Partnering Search	Company Profiling	Pharmalicensing Intelligence	Reports	Comparision
In-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Out-licensing:	Latest records	Industry Sector	Therapeutic Target	Search	Profile your company	Pharma partnering
Companies:	Profiled companies	Industry Sector	Therapeutic Target	Geographic Location	Search	Add your company
Reports:	Biotechnology	Business Development	Management	Market & Sales	Medical Devices	Pharmaceuticals
News:	Deals & Alliances	Development	Financial Results	Financings	Intellectual Property	Regulatory
Events:	Pharma events	Calendar	Organizers	Featured events	Search
Articles:	Industrial Sector	Therapeutic Target	Articles date
Deals:	Industry Sector	Therapeutic Target	Deals Date	Search	Reports	Press releases
About us:	Our Audience	Case Studies	Newsletter	FAQ	Contact us	Site map

(website) 53 queries took 54 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `service`	15	15	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	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	0
20	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	1
21	DESCRIBE `dms_releases_sites`	5	5	1
22	DESCRIBE `licopp`	23	23	1
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 `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	0
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 `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` = 245 AND `Service`.`is_live` > 0 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` = 47158	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` = 21108	1	1	0
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` = 58110	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` = 47158	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` = 245 AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="V" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	0	0	1
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='245' 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	0	0	1
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	0
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` = 245	1		11
48	SELECT `Service`.`company_id` FROM `service` AS `Service` WHERE `Service`.`id` = 245 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	2
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` = '245' AND `company_id` = 21108 AND `module_type_id` = '12' AND `hit_date` = '2012-05-24' LIMIT 1	0	0	7
52	INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 21108, '245', '12', '2012-05-24')	1		1
53	SELECT LAST_INSERT_ID() AS insertID	1	1	0

(website) 53 queries took 54 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `service`

DESCRIBE `company`

DESCRIBE `condet`

DESCRIBE `countrycode`

DESCRIBE `person`

DESCRIBE `account`

DESCRIBE `product_legacy`

DESCRIBE `sales_people`

DESCRIBE `profile`

DESCRIBE `currencies`

DESCRIBE `update_rec`

DESCRIBE `user`

DESCRIBE `enquiry`

DESCRIBE `module_types`

DESCRIBE `dms_companies`

DESCRIBE `dms_releases`

DESCRIBE `dms_categories`

DESCRIBE `dms_clinical_areas`

DESCRIBE `dms_categories_dms_releases`

DESCRIBE `dms_clinical_areas_dms_releases`

DESCRIBE `dms_releases_sites`

DESCRIBE `licopp`

DESCRIBE `development_statuses`

DESCRIBE `category`

DESCRIBE `categories_sites`

DESCRIBE `categorisation`

DESCRIBE `licopps_sites`

DESCRIBE `press_release`

DESCRIBE `press_releases_sites`

DESCRIBE `story`

DESCRIBE `sites_stories`

DESCRIBE `story_assoc`

DESCRIBE `companies_sites`

DESCRIBE `categories_users`

DESCRIBE `authority`

DESCRIBE `sites_users`

DESCRIBE `sites`

SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1

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` = 245 AND `Service`.`is_live` > 0 LIMIT 1

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` = 47158

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` = 21108

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` = 58110

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` = 47158

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` = 245 AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="V" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC

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='245' 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

SELECT `Site`.`id`, `Site`.`name`, `Site`.`email_domain`, `Site`.`short_name`, `Site`.`brand` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1

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` = 245

SELECT `Service`.`company_id` FROM `service` AS `Service` WHERE `Service`.`id` = 245 LIMIT 1

DESCRIBE `statistics`

SELECT `ModuleType`.`id`, `ModuleType`.`handle`, `ModuleType`.`name`, `ModuleType`.`description`, `ModuleType`.`created`, `ModuleType`.`modified` FROM `module_types` AS `ModuleType` WHERE `ModuleType`.`handle` = 'service' LIMIT 1

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` = '245' AND `company_id` = 21108 AND `module_type_id` = '12' AND `hit_date` = '2012-05-24' LIMIT 1

INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 21108, '245', '12', '2012-05-24')

SELECT LAST_INSERT_ID() AS insertID

(report) 2 queries took 2 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 ("Rotarod") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Rotarod") DESC , MarketResearchReport.published DESC LIMIT 10		0	0	1

(report) 2 queries took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `reports`

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 ("Rotarod") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Rotarod") DESC , MarketResearchReport.published DESC LIMIT 10