Process analytics in drug quality control
We successfully applied our Bayesian system-analytics tool as a process analytic technology for anomaly detection in drug quality control.

Database (default) | 0.046126 s | |||
---|---|---|---|---|
29.3438 kB | ||||
Benchmark | Min | Max | Average | Total |
SHOW FULL COLUMNS FROM `languages` (1) |
0.002009 s
|
0.002009 s
|
0.002009 s
|
0.002009 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `language`.* FROM `languages` AS `language` WHERE `url` = '' LIMIT 1 (1) |
0.001078 s
|
0.001078 s
|
0.001078 s
|
0.001078 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `language`.* FROM `languages` AS `language` WHERE `id` = 1 LIMIT 1 (1) |
0.000871 s
|
0.000871 s
|
0.000871 s
|
0.000871 s
|
0.7891 kB
|
0.7891 kB
|
0.7891 kB
|
0.7891 kB
|
|
SHOW FULL COLUMNS FROM `urls` (1) |
0.001716 s
|
0.001716 s
|
0.001716 s
|
0.001716 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `url`.* FROM `urls` AS `url` (1) |
0.001042 s
|
0.001042 s
|
0.001042 s
|
0.001042 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT * FROM `languages` (1) |
0.000840 s
|
0.000840 s
|
0.000840 s
|
0.000840 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT * FROM `language_values` (1) |
0.004669 s
|
0.004669 s
|
0.004669 s
|
0.004669 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SHOW FULL COLUMNS FROM `menu` (1) |
0.001704 s
|
0.001704 s
|
0.001704 s
|
0.001704 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `menu`.* FROM `menu` AS `menu` JOIN `urls` ON (`urls`.`menu_id` = `menu`.`id`) JOIN `language_values` ON (`language_values`.`word_id` = `urls`.`route`) WHERE `language_values`.`value` = 'about_us/news' AND `language_values`.`language_id` = '1' LIMIT 1 (8) |
0.000404 s
|
0.001770 s
|
0.000670 s
|
0.005361 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
5.3125 kB
|
|
SELECT `url`.* FROM `urls` AS `url` WHERE `route_name` = 'route_95' LIMIT 1 (1) |
0.001060 s
|
0.001060 s
|
0.001060 s
|
0.001060 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SHOW FULL COLUMNS FROM `skeletons` (1) |
0.001575 s
|
0.001575 s
|
0.001575 s
|
0.001575 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `skeleton`.* FROM `skeletons` AS `skeleton` WHERE `skeleton`.`id` = '2' LIMIT 1 (1) |
0.000915 s
|
0.000915 s
|
0.000915 s
|
0.000915 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `portlets`.`name`, `url_portlets`.`id`, `url_portlets`.`container_id` FROM `url_portlets` JOIN `portlets` ON (`url_portlets`.`portlet_id` = `portlets`.`id`) WHERE `url_portlets`.`url_id` = '95' AND `url_portlets`.`container_id` IN ('1', '2', '3', '4', '5', '6') ORDER BY `url_portlets`.`ord` ASC (1) |
0.001668 s
|
0.001668 s
|
0.001668 s
|
0.001668 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SHOW FULL COLUMNS FROM `url_portlets` (1) |
0.001397 s
|
0.001397 s
|
0.001397 s
|
0.001397 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `urlportlet`.* FROM `url_portlets` AS `urlportlet` WHERE `urlportlet`.`id` = '604' LIMIT 1 (1) |
0.000873 s
|
0.000873 s
|
0.000873 s
|
0.000873 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `menu`.* FROM `menu` AS `menu` JOIN `language_values` AS `ormlv0` ON (`ormlv0`.`word_id` = `menu`.`hidden`) WHERE `ormlv0`.`language_id` = '1' AND `ormlv0`.`value` = 0 AND `parent_id` = 0 ORDER BY `ord` ASC (1) |
0.001190 s
|
0.001190 s
|
0.001190 s
|
0.001190 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `menu`.* FROM `menu` AS `menu` JOIN `language_values` AS `ormlv0` ON (`ormlv0`.`word_id` = `menu`.`hidden`) WHERE `ormlv0`.`language_id` = '1' AND `ormlv0`.`value` = '0' AND `parent_id` = '48' (1) |
0.001033 s
|
0.001033 s
|
0.001033 s
|
0.001033 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `menu`.* FROM `menu` AS `menu` JOIN `language_values` AS `ormlv0` ON (`ormlv0`.`word_id` = `menu`.`hidden`) WHERE `ormlv0`.`language_id` = '1' AND `ormlv0`.`value` = '0' AND `parent_id` = '74' (1) |
0.001016 s
|
0.001016 s
|
0.001016 s
|
0.001016 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `menu`.* FROM `menu` AS `menu` WHERE `menu`.`id` = '74' LIMIT 1 (5) |
0.000420 s
|
0.000730 s
|
0.000538 s
|
0.002689 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
3.3203 kB
|
|
SELECT `menu`.* FROM `menu` AS `menu` JOIN `language_values` AS `ormlv0` ON (`ormlv0`.`word_id` = `menu`.`hidden`) WHERE `ormlv0`.`language_id` = '1' AND `ormlv0`.`value` = '0' AND `parent_id` = '90' (1) |
0.001230 s
|
0.001230 s
|
0.001230 s
|
0.001230 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `menu`.* FROM `menu` AS `menu` JOIN `language_values` AS `ormlv0` ON (`ormlv0`.`word_id` = `menu`.`hidden`) WHERE `ormlv0`.`language_id` = '1' AND `ormlv0`.`value` = '0' AND `parent_id` = '91' (1) |
0.000946 s
|
0.000946 s
|
0.000946 s
|
0.000946 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `menu`.* FROM `menu` AS `menu` JOIN `language_values` AS `ormlv0` ON (`ormlv0`.`word_id` = `menu`.`hidden`) WHERE `ormlv0`.`language_id` = '1' AND `ormlv0`.`value` = '0' AND `parent_id` = '92' (1) |
0.000976 s
|
0.000976 s
|
0.000976 s
|
0.000976 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `urlportlet`.* FROM `url_portlets` AS `urlportlet` WHERE `urlportlet`.`id` = '609' LIMIT 1 (1) |
0.000849 s
|
0.000849 s
|
0.000849 s
|
0.000849 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SHOW FULL COLUMNS FROM `news` (1) |
0.001660 s
|
0.001660 s
|
0.001660 s
|
0.001660 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `news`.* FROM `news` AS `news` JOIN `language_values` AS `ormlv0` ON (`ormlv0`.`word_id` = `news`.`url`) WHERE `ormlv0`.`language_id` = '1' AND `ormlv0`.`value` = 'process_analytics_in_drug_quality_control' LIMIT 1 (1) |
0.001131 s
|
0.001131 s
|
0.001131 s
|
0.001131 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `urlportlet`.* FROM `url_portlets` AS `urlportlet` WHERE `urlportlet`.`id` = '608' LIMIT 1 (1) |
0.000859 s
|
0.000859 s
|
0.000859 s
|
0.000859 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `urlportlet`.* FROM `url_portlets` AS `urlportlet` WHERE `urlportlet`.`id` = '603' LIMIT 1 (1) |
0.000865 s
|
0.000865 s
|
0.000865 s
|
0.000865 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `urlportlet`.* FROM `url_portlets` AS `urlportlet` WHERE `urlportlet`.`id` = '605' LIMIT 1 (1) |
0.000907 s
|
0.000907 s
|
0.000907 s
|
0.000907 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `menu`.* FROM `menu` AS `menu` JOIN `language_values` AS `ormlv0` ON (`ormlv0`.`word_id` = `menu`.`hidden`) WHERE `ormlv0`.`language_id` = '1' AND `ormlv0`.`value` = '0' AND `parent_id` = 0 ORDER BY `ord` ASC (1) |
0.001060 s
|
0.001060 s
|
0.001060 s
|
0.001060 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `menu`.* FROM `menu` AS `menu` WHERE `menu`.`parent_id` = '74' (1) |
0.000776 s
|
0.000776 s
|
0.000776 s
|
0.000776 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `urlportlet`.* FROM `url_portlets` AS `urlportlet` WHERE `urlportlet`.`id` = '607' LIMIT 1 (1) |
0.000741 s
|
0.000741 s
|
0.000741 s
|
0.000741 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `url_id` FROM `url_portlets` WHERE `id` = '607' (1) |
0.000861 s
|
0.000861 s
|
0.000861 s
|
0.000861 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `menu_id` FROM `urls` WHERE `id` = '95' (1) |
0.000559 s
|
0.000559 s
|
0.000559 s
|
0.000559 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
Kohana | 0.004234 s | |||
---|---|---|---|---|
56.9844 kB | ||||
Benchmark | Min | Max | Average | Total |
find_file (80) |
0.000017 s
|
0.000122 s
|
0.000053 s
|
0.004234 s
|
0.5078 kB
|
2.1406 kB
|
0.7123 kB
|
56.9844 kB
|
Requests | 0.153960 s | |||
---|---|---|---|---|
2,299.8672 kB | ||||
Benchmark | Min | Max | Average | Total |
"about_us/news/process_analytics_in_drug_quality_control" (1) |
0.113221 s
|
0.113221 s
|
0.113221 s
|
0.113221 s
|
1,646.8984 kB
|
1,646.8984 kB
|
1,646.8984 kB
|
1,646.8984 kB
|
|
"en/portlet/menu" « "about_us/news/process_analytics_in_drug_quality_control" (1) |
0.016525 s
|
0.016525 s
|
0.016525 s
|
0.016525 s
|
267.4219 kB
|
267.4219 kB
|
267.4219 kB
|
267.4219 kB
|
|
"en/portlet/news" « "about_us/news/process_analytics_in_drug_quality_control" (1) |
0.006116 s
|
0.006116 s
|
0.006116 s
|
0.006116 s
|
214.9531 kB
|
214.9531 kB
|
214.9531 kB
|
214.9531 kB
|
|
"en/portlet/footer" « "about_us/news/process_analytics_in_drug_quality_control" (1) |
0.001618 s
|
0.001618 s
|
0.001618 s
|
0.001618 s
|
20.5547 kB
|
20.5547 kB
|
20.5547 kB
|
20.5547 kB
|
|
"en/portlet/contentheader" « "about_us/news/process_analytics_in_drug_quality_control" (1) |
0.003522 s
|
0.003522 s
|
0.003522 s
|
0.003522 s
|
45.9844 kB
|
45.9844 kB
|
45.9844 kB
|
45.9844 kB
|
|
"en/portlet/contentmenu" « "about_us/news/process_analytics_in_drug_quality_control" (1) |
0.009672 s
|
0.009672 s
|
0.009672 s
|
0.009672 s
|
56.0313 kB
|
56.0313 kB
|
56.0313 kB
|
56.0313 kB
|
|
"en/portlet/contentimage" « "about_us/news/process_analytics_in_drug_quality_control" (1) |
0.004762 s
|
0.004762 s
|
0.004762 s
|
0.004762 s
|
54.6563 kB
|
54.6563 kB
|
54.6563 kB
|
54.6563 kB
|
Application Execution (93) | 0.068082 s | 12.112719 s | 0.347441 s | 0.167812 s |
---|---|---|---|---|
4,653.4219 kB | 5,249.0391 kB | 4,736.1098 kB | 4,900.8594 kB |