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.012249 s | |||
---|---|---|---|---|
29.3438 kB | ||||
Benchmark | Min | Max | Average | Total |
SHOW FULL COLUMNS FROM `languages` (1) |
0.000758 s
|
0.000758 s
|
0.000758 s
|
0.000758 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.000188 s
|
0.000188 s
|
0.000188 s
|
0.000188 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.000162 s
|
0.000162 s
|
0.000162 s
|
0.000162 s
|
0.7891 kB
|
0.7891 kB
|
0.7891 kB
|
0.7891 kB
|
|
SHOW FULL COLUMNS FROM `urls` (1) |
0.000526 s
|
0.000526 s
|
0.000526 s
|
0.000526 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `url`.* FROM `urls` AS `url` (1) |
0.000220 s
|
0.000220 s
|
0.000220 s
|
0.000220 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT * FROM `languages` (1) |
0.000171 s
|
0.000171 s
|
0.000171 s
|
0.000171 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT * FROM `language_values` (1) |
0.001791 s
|
0.001791 s
|
0.001791 s
|
0.001791 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SHOW FULL COLUMNS FROM `menu` (1) |
0.000674 s
|
0.000674 s
|
0.000674 s
|
0.000674 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.000166 s
|
0.000179 s
|
0.000172 s
|
0.001374 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.000175 s
|
0.000175 s
|
0.000175 s
|
0.000175 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SHOW FULL COLUMNS FROM `skeletons` (1) |
0.000473 s
|
0.000473 s
|
0.000473 s
|
0.000473 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.000190 s
|
0.000190 s
|
0.000190 s
|
0.000190 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.000187 s
|
0.000187 s
|
0.000187 s
|
0.000187 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SHOW FULL COLUMNS FROM `url_portlets` (1) |
0.000508 s
|
0.000508 s
|
0.000508 s
|
0.000508 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.000171 s
|
0.000171 s
|
0.000171 s
|
0.000171 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.000177 s
|
0.000177 s
|
0.000177 s
|
0.000177 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.000171 s
|
0.000171 s
|
0.000171 s
|
0.000171 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.000178 s
|
0.000178 s
|
0.000178 s
|
0.000178 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.000165 s
|
0.000171 s
|
0.000168 s
|
0.000841 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.000183 s
|
0.000183 s
|
0.000183 s
|
0.000183 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.000169 s
|
0.000169 s
|
0.000169 s
|
0.000169 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.000170 s
|
0.000170 s
|
0.000170 s
|
0.000170 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.000169 s
|
0.000169 s
|
0.000169 s
|
0.000169 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SHOW FULL COLUMNS FROM `news` (1) |
0.000543 s
|
0.000543 s
|
0.000543 s
|
0.000543 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.000722 s
|
0.000722 s
|
0.000722 s
|
0.000722 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.000175 s
|
0.000175 s
|
0.000175 s
|
0.000175 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.000167 s
|
0.000167 s
|
0.000167 s
|
0.000167 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.000168 s
|
0.000168 s
|
0.000168 s
|
0.000168 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.000184 s
|
0.000184 s
|
0.000184 s
|
0.000184 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.000168 s
|
0.000168 s
|
0.000168 s
|
0.000168 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.000168 s
|
0.000168 s
|
0.000168 s
|
0.000168 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `url_id` FROM `url_portlets` WHERE `id` = '607' (1) |
0.000171 s
|
0.000171 s
|
0.000171 s
|
0.000171 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
|
SELECT `menu_id` FROM `urls` WHERE `id` = '95' (1) |
0.000156 s
|
0.000156 s
|
0.000156 s
|
0.000156 s
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
0.6641 kB
|
Kohana | 0.002006 s | |||
---|---|---|---|---|
56.9844 kB | ||||
Benchmark | Min | Max | Average | Total |
find_file (80) |
0.000009 s
|
0.000054 s
|
0.000025 s
|
0.002006 s
|
0.5078 kB
|
2.1406 kB
|
0.7123 kB
|
56.9844 kB
|
Requests | 0.048179 s | |||
---|---|---|---|---|
2,299.8672 kB | ||||
Benchmark | Min | Max | Average | Total |
"about_us/news/process_analytics_in_drug_quality_control" (1) |
0.032795 s
|
0.032795 s
|
0.032795 s
|
0.032795 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.005988 s
|
0.005988 s
|
0.005988 s
|
0.005988 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.002902 s
|
0.002902 s
|
0.002902 s
|
0.002902 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.000591 s
|
0.000591 s
|
0.000591 s
|
0.000591 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.001327 s
|
0.001327 s
|
0.001327 s
|
0.001327 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.003927 s
|
0.003927 s
|
0.003927 s
|
0.003927 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.001790 s
|
0.001790 s
|
0.001790 s
|
0.001790 s
|
54.6563 kB
|
54.6563 kB
|
54.6563 kB
|
54.6563 kB
|
Application Execution (934) | 0.059006 s | 8.887409 s | 0.198560 s | 0.064750 s |
---|---|---|---|---|
4,653.4766 kB | 5,250.4453 kB | 4,753.6814 kB | 4,900.8594 kB |