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
Medvance Resourcing is a medical devi...

Medvance Resourcing is a medical device specialist resourcing agency.

We can uniquely combine both our experience of staffing and our intricate knowledge of regulatory and clinical device trials. This offers our clients an unprecedented quality of candidates. Our European talent pool is the most comprehensive on the market and contains candidates who may not be accessed via traditional job boards and web advertising.

Full description

Medvance Resourcing is a recruitment division of Medvance Ltd, a leading Medical Device CRO. We focus on clinical research jobs for medical device clients on a pan European basis.
Medvance Resourcing specialise in recruitment for medical device Jobs, combining recruitment expertise with knowledge of the industry to offer a market leading service.

Feedback from clients has indicated that our process is superior to that of our competitors. It is underpinned by a meticulous candidate attraction and tracking mechanism.
We can uniquely combine both our experience of staffing and our intricate knowledge of regulatory and clinical device trials. This offers our clients an unprecedented quality of candidates. Our European talent pool is the most comprehensive on the market and contains candidates who may not be accessed via traditional job boards and web advertising.

As an organisation, we are committed to providing the best opportunities for our candidates and a market leading service to our clients. We are also committed to working on collaborative projects with key institutions such as The Institute of Clinical Research; this enables us to contribute to the overall success of the market for both clients and candidates alike.

Related reports

Market Research Reports provided by reports.innovaro.com

Enterprise 2.0 – what is the business case?

Apr 2009 - 17 pages - $1,050

Medical Device Company Performance Tables

Mar 2010 - 414 pages - $690

Smiths Medical Medical Device Company Intelligence Report

Jan 2011 - 38 pages - $515

Sorin Medical Medical Device Company Intelligence Report

Apr 2010 - 42 pages - $515

American Medical Systems Medical Device Company Intelligence Report

Mar 2010 - 30 pages - $515

Toshiba Medical Systems Medical Device Company Intelligence Report

May 2009 - 32 pages - $515

Advanced Medical Optics Medical Device Company Intelligence Report

Jul 2005 - 52 pages - $515

The True State of the Medical Device Industry

Feb 2009 - 242 pages - $690

Healthcare Reform: Impact on Medical Device Industry

Apr 2010 - 5 pages - $500

Brazil Medical Device Industry – Key Company Profiles

Apr 2011 - 25 pages - $500

Service contact

Mr Mark O'Reilly
Head of Resourcing.
Resourcing

Contact directly

Company details

Medvance Ltd

Medvance is a leading global clinical research and regulatory services provider supporting the medical device and healthcare industries worldwide.

View profile

Visit website

Related categories

Services

Clinical and scientific

Consultancy

Human resources

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 39 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	4
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	0
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	0
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	0
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` = 231 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` = 48259	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` = 21143	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` = 59227	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` = 48258	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` = 231 AND `Categorisation`.`category_id` = `Category`.`uid`) WHERE cat_type="V" ORDER BY `Category`.`root` ASC, `Category`.`clan` ASC, `Category`.`parent` ASC, `Category`.`name` ASC	3	3	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='231' 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	4	4	4
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` = 231	1		1
48	SELECT `Service`.`company_id` FROM `service` AS `Service` WHERE `Service`.`id` = 231 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` = '231' AND `company_id` = 21143 AND `module_type_id` = '12' AND `hit_date` = '2012-05-21' LIMIT 1	0	0	1
52	INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 21143, '231', '12', '2012-05-21')	1		0
53	SELECT LAST_INSERT_ID() AS insertID	1	1	0

(website) 53 queries took 39 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` = 231 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` = 48259

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

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

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

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` = 231 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='231' 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` = 231

SELECT `Service`.`company_id` FROM `service` AS `Service` WHERE `Service`.`id` = 231 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` = '231' AND `company_id` = 21143 AND `module_type_id` = '12' AND `hit_date` = '2012-05-21' LIMIT 1

INSERT INTO `statistics` (`is_aggregated`, `count`, `company_id`, `business_object_id`, `module_type_id`, `hit_date`) VALUES (0, 1, 21143, '231', '12', '2012-05-21')

SELECT LAST_INSERT_ID() AS insertID

(report) 2 queries took 81 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 ("Medvance Resourcing is a medical device specialist resourcing agency.") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Medvance Resourcing is a medical device specialist resourcing agency.") DESC , MarketResearchReport.published DESC LIMIT 10		10	10	80

(report) 2 queries took 81 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 ("Medvance Resourcing is a medical device specialist resourcing agency.") ORDER BY MATCH (`MarketResearchReport`.`name`, `MarketResearchReport`.`description`, `MarketResearchReport`.`summary`, `MarketResearchReport`.`content`, `MarketResearchReport`.`isbn`, `MarketResearchReport`.`code`) AGAINST ("Medvance Resourcing is a medical device specialist resourcing agency.") DESC , MarketResearchReport.published DESC LIMIT 10