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
Morris Water Maze

Morris Water Maze

Morris Water Maze: - The water maze can be used to assess spatial learning and memory. The subjects are placed in a pool of water in a random start location. There is an escape platform hidden under the surface of the water. The subjects will swim in the maze until they have located the platform. During the trials the path length to find the escape platform is recorded. After a number of learning trials the platform is removed, and the percentage of time spent in the quadrant that normally contains the platform is compared to the time spent in other quadrants.

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

Philip Morris International Inc.: SWOT Analysis & Company Profile

Jul 2010 - 26 pages - $99

T.J. Morris Limited - Company Capsule

Aug 2011 - 7 pages - $75

Eastern Morris Cranes Co. Ltd. - Company Capsule

Nov 2011 - 6 pages - $75

Duane Morris LLP. - Company Capsule

Nov 2011 - 6 pages - $75

Philip Morris International Inc. - Strategy, SWOT and Corporate Finance Report

Mar 2011 - 37 pages - $125

Philip Morris International Inc. - Strategy and SWOT Report

Jun 2011 - 47 pages - $125

T.J. Morris Limited - Strategic SWOT Analysis Review

May 2011 - 15 pages - $125

Sanders Morris Harris Group - Financial and Strategic SWOT Analysis Review

May 2011 - 25 pages - $250

Morris Energy Group - Power - Deals and Alliances Profile

Mar 2011 - 16 pages - $250

Just Water International Limited: SWOT Analysis & Company Profile

Feb 2011 - 22 pages - $99

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

Related categories

Services

Contract Services

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 205 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `service`	15	15	37
2	DESCRIBE `company`	27	27	1
3	DESCRIBE `condet`	17	17	3
4	DESCRIBE `countrycode`	4	4	2
5	DESCRIBE `person`	15	15	2
6	DESCRIBE `account`	29	29	2
7	DESCRIBE `product_legacy`	6	6	2
8	DESCRIBE `sales_people`	6	6	1
9	DESCRIBE `profile`	14	14	1
10	DESCRIBE `currencies`	7	7	2
11	DESCRIBE `update_rec`	7	7	1
12	DESCRIBE `user`	24	24	2
13	DESCRIBE `enquiry`	14	14	3
14	DESCRIBE `module_types`	6	6	1
15	DESCRIBE `dms_companies`	26	26	3
16	DESCRIBE `dms_releases`	10	10	2
17	DESCRIBE `dms_categories`	4	4	1
18	DESCRIBE `dms_clinical_areas`	4	4	1
19	DESCRIBE `dms_categories_dms_releases`	2	2	1
20	DESCRIBE `dms_clinical_areas_dms_releases`	2	2	2
21	DESCRIBE `dms_releases_sites`	5	5	2
22	DESCRIBE `licopp`	23	23	2
23	DESCRIBE `development_statuses`	5	5	1
24	DESCRIBE `category`	14	14	3
25	DESCRIBE `categories_sites`	5	5	2
26	DESCRIBE `categorisation`	8	8	2
27	DESCRIBE `licopps_sites`	3	3	3
28	DESCRIBE `press_release`	13	13	2
29	DESCRIBE `press_releases_sites`	5	5	1
30	DESCRIBE `story`	12	12	6
31	DESCRIBE `sites_stories`	5	5	1
32	DESCRIBE `story_assoc`	4	4	1
33	DESCRIBE `companies_sites`	3	3	1
34	DESCRIBE `categories_users`	2	2	8
35	DESCRIBE `authority`	3	3	1
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	1
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` = 234 AND `Service`.`is_live` > 0 LIMIT 1	1	1	2
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	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` = 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` = 234 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	2
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='234' 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	2	2	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	13
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` = 234	1		9
48	SELECT `Service`.`company_id` FROM `service` AS `Service` WHERE `Service`.`id` = 234 LIMIT 1	1	1	19
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` = '234' AND `company_id` = 21108 AND `module_type_id` = '12' AND `hit_date` = '2012-05-24' LIMIT 1	0	0	41
52	INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 21108, '234', '12', '2012-05-24')	1		5
53	SELECT LAST_INSERT_ID() AS insertID	1	1	2

(website) 53 queries took 205 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` = 234 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` = 234 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='234' 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` = 234

SELECT `Service`.`company_id` FROM `service` AS `Service` WHERE `Service`.`id` = 234 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` = '234' 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, '234', '12', '2012-05-24')

SELECT LAST_INSERT_ID() AS insertID

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

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

161