Author(s): Simmi Kharb * .
Pp: 27-28 (2)
* (Excluding Mailing and Handling)
Author(s): Simmi Kharb * .
Pp: 27-28 (2)
DOI: 10.2174/9789814998758121010005
* (Excluding Mailing and Handling)
Learning objectives:
1. Discuss steps for a complete analysis or unit operation.
2. Illustrate systems available for automation.
Cite this chapter as:
Simmi Kharb ;Automation in Clinical Laboratory, Mind Maps in Clinical Chemistry (Part II) (2021) 1: 27. https://doi.org/10.2174/9789814998758121010005
DOI https://doi.org/10.2174/9789814998758121010005 |
Publisher Name Bentham Science Publisher |
1 x Booting (54.85%) | 92.17ms |
1 x Application (45.14%) | 75.86ms |
Backtrace |
|
INSERT INTO visitor_ip_address (ip_address,visitor_agent,visitor_count, created_on,updated_on) VALUES ('316852268','',1,1737107599,1737107599)
ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1737107599
Backtrace |
|
INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('316852268','/chapter/15513',1,1737107599,1737107599)
Backtrace |
|
(select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_corporate WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_token WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_trail WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_corporate WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_token WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316852268 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316852268) limit 1
Bindings |
|
Backtrace |
|
select * from `chapter` where `chapter_id` = '15513' limit 1
Bindings |
|
Backtrace |
|
select CONCAT_WS(' ',au.first_name, ' ', ifnull(au.initials,''), ' ', au.last_name) as authors,
CONCAT(au.last_name, IFNULL(CONCAT(' ', au.initials), ''), ' ', au.first_name) AS authorsRIS, CONCAT_WS(' ',au.last_name, ' ', ifnull(au.initials,''), ' ', au.first_name) as authorsCiteAs , `au`.*, (GROUP_CONCAT(TRIM(BOTH ', ' FROM
CONCAT(ifnull(concat(af.institution,','),''), ifnull(concat(af.department,','),''), ifnull(concat(af.address,','),''), ifnull(concat(af.city,','),''), ifnull(concat(af.country,','),''), ifnull(concat(af.postal_code,','),''), ifnull(concat(af.phone,','),''), ifnull(concat(af.fax,','),'')))
SEPARATOR '|')) as `author_affiliation`, (GROUP_CONCAT(TRIM(BOTH ', ' FROM
CONCAT(ifnull(concat(af.web_view,','),'')))
SEPARATOR '|')) as `web_view` from `author` as `au` left join `author_affiliation` as `af` on `au`.`author_id` = `af`.`author_id` where `au`.`chapter_id` = '15513' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
Bindings |
|
Backtrace |
|
select * from `keywords` where `chapter_id` = '15513'
Bindings |
|
Backtrace |
|
select * from `ebook` where `ebook_id` = 903 limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `e`.`ebook_id` where subject_id IN (select subject_id FROM subject_ebook WHERE ebook_id=903)
and se.ebook_id!=903 and v.ebook_status='1'
Backtrace |
|
select distinct v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id,
v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `e`.`ebook_id` where subject_id IN (select subject_id FROM subject_ebook WHERE ebook_id=903)
and se.ebook_id!=903 and v.ebook_status='1' limit 10 offset 0
Backtrace |
|
select count(*) as aggregate from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where subject_id IN (select subject_id FROM subject_ebook WHERE ebook_id=903)
Backtrace |
|
select distinct j.nid as
journal_nid,j.title,j.subtitle,j.issn,j.eissn,j.keyword,sj.journal_id,j.image_file_name,j.flyer_link from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where subject_id IN (select subject_id FROM subject_ebook WHERE ebook_id=903) limit 10 offset 0
Backtrace |
|
select `e`.*, `a`.*, `y`.`year`, `e`.`ebook_volume_id` as `ebook_volume_id`, `a`.`ebook_volume_id` as `ebk_vol_id`, `e`.`ebook_id` as `ebk_ebook_id` from `ebook_volume` as `e` left join `author` as `a` on `e`.`ebook_volume_id` = `a`.`ebook_volume_id` left join `year` as `y` on `y`.`id` = `e`.`year_id` where `e`.`ebook_volume_id` = 3122 and `e`.`is_uploaded` = 1
Bindings |
|
Backtrace |
|
select count(*) rcd from `ebook_volume` where `ebook_id` = 903 and ebook_volume_id <> 3122 limit 1
Bindings |
|
Backtrace |
|
select count(*) as total_count, content_type_access_id as access_type from ebook_access
where content_type_id = '15513' and content_type = 'c'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)
Backtrace |
|
select count(*) as total_count, content_type_access_id as access_type from ebook_access
where content_type_id = '3122' and content_type = 'v'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)
Backtrace |
|
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN 111 THEN true ELSE false END as terms_popup,
"S" as content_download_type,
null as restricted_user_access_key,
null as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316852268 and j.to_ip >=316852268 )) and ((j.from_date <= 1737107599 and j.to_date >= 1737107599 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3122) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
false as terms_popup,
"S" as content_download_type,
null as restricted_user_access_key,
null as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316852268 and j.to_ip >=316852268 )) and ((j.from_date <= 1737107599 and j.to_date >= 1737107599 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3122) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
false as terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316852268 and j.to_ip >=316852268 )) and ((j.from_date <= 1737107599 and j.to_date >= 1737107599 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3122)
Backtrace |
|
(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN 111 THEN true ELSE false END as terms_popup,
"S" as content_download_type,
null as restricted_user_access_key,
null as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316852268 and j.to_ip >=316852268 )) and ((j.from_date <= 1737107599 and j.to_date >= 1737107599 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 15513) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text,
false as terms_popup,
"S" as content_download_type,
null as restricted_user_access_key,
null as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316852268 and j.to_ip >=316852268 )) and ((j.from_date <= 1737107599 and j.to_date >= 1737107599 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 15513) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text,
false as terms_popup,
"R" as content_download_type,
j.uc_id as restricted_user_access_key,
"v" as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 316852268 and j.to_ip >=316852268 )) and ((j.from_date <= 1737107599 and j.to_date >= 1737107599 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 15513)
Backtrace |
|
select b.banner_link, b.banner_name, b.banner_script, b.banner_remarks, b.banner_file_name, b.banner_placement, bd.content_type, bd.content_id from `tbl_banner` as `b` inner join `tbl_banner_detail` as `bd` on `bd`.`banner_id` = `b`.`banner_id` inner join `users` as `u` on `u`.`id` = `b`.`updated_by` where `b`.`banner_ebook` = 1 and `bd`.`content_type` = 'B' and `bd`.`content_id` = 3122 and `b`.`banner_from_date` <= 1737107599 and `b`.`banner_to_date` >= 1737107599 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `uc_cart_products` where cart_id='aac5208ca484ee5f93fe11ddb0770221'
Backtrace |
|
200
[]
[]
0 of 0array:16 [▼ "x-https" => array:1 [▶ 0 => "1" ] "host" => array:1 [▶ 0 => "beta.benthamscience.com" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Fri, 17 Jan 2025 09:53:19 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ii9GY2g5YTloeFFrMXI0WWJkT2RkdFE9PSIsInZhbHVlIjoiR0ViM1R6OWM5L09BdURNMWlNL3JRYlRSNVhyd0cycWZYbFFVRlNGK1I1TnpIdmRtMFlCaEtNbWdDTGUyNnNyUXFWWHdIQlgvVlYzbXdTakYyK0xrZ3Z0ZmxaYW9rSklEa3RhZ2IycGpPdFZDZ1cxRlhHc2pzWXYrbW5uQk9OblMiLCJtYWMiOiJkNmNhNGNkYzEzNzFiMWVjYmNhODA3NDkzMDZkZWM5NTdmNmYxM2Y2Zjg2MWZkNmVkMjQ4NTU3YWM5Yjc2M2FiIiwidGFnIjoiIn0%3D; expires=Sun, 19 Jan 2025 21:53:19 GMT; Max-Age=216000; path=/; secure; samesite=strict ◀XSRF-TOKEN=eyJpdiI6Ii9GY2g5YTloeFFrMXI0WWJkT2RkdFE9PSIsInZhbHVlIjoiR0ViM1R6OWM5L09BdURNMWlNL3JRYlRSNVhyd0cycWZYbFFVRlNGK1I1TnpIdmRtMFlCaEtNbWdDTGUyNnNyUXFWWHdIQ ▶" 1 => "eurekaselectnew_session=eyJpdiI6IkIwd1FvNWNBaEpKUlF5Zk1UMVB5cGc9PSIsInZhbHVlIjoicUYrNXkvemFPTmJncDMwYVJzTUR1TitxV2tBMGNYNzE5Vi8zMWwrRXJvL25JZ2RuWFFXb1oxMUsvTmRDZzZLcm1GdkdnUm0xdEw3MzllV2JBSHZLckVOaXdwS05iYUdZenVrZlNYWVcvTG5OcWt6K1dyK2tsVW5Wdko4MU10b0EiLCJtYWMiOiJmOGIzZWUzMDdlM2M4YWFjNGJjODk5NDVkMjJiODMzZDRjMzI4NTljMGJjMjcwYTg3M2U5M2Q1NmEwY2Q5NDNmIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=strict ◀eurekaselectnew_session=eyJpdiI6IkIwd1FvNWNBaEpKUlF5Zk1UMVB5cGc9PSIsInZhbHVlIjoicUYrNXkvemFPTmJncDMwYVJzTUR1TitxV2tBMGNYNzE5Vi8zMWwrRXJvL25JZ2RuWFFXb1oxMUsvTmRD ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ii9GY2g5YTloeFFrMXI0WWJkT2RkdFE9PSIsInZhbHVlIjoiR0ViM1R6OWM5L09BdURNMWlNL3JRYlRSNVhyd0cycWZYbFFVRlNGK1I1TnpIdmRtMFlCaEtNbWdDTGUyNnNyUXFWWHdIQlgvVlYzbXdTakYyK0xrZ3Z0ZmxaYW9rSklEa3RhZ2IycGpPdFZDZ1cxRlhHc2pzWXYrbW5uQk9OblMiLCJtYWMiOiJkNmNhNGNkYzEzNzFiMWVjYmNhODA3NDkzMDZkZWM5NTdmNmYxM2Y2Zjg2MWZkNmVkMjQ4NTU3YWM5Yjc2M2FiIiwidGFnIjoiIn0%3D; expires=Sun, 19-Jan-2025 21:53:19 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Ii9GY2g5YTloeFFrMXI0WWJkT2RkdFE9PSIsInZhbHVlIjoiR0ViM1R6OWM5L09BdURNMWlNL3JRYlRSNVhyd0cycWZYbFFVRlNGK1I1TnpIdmRtMFlCaEtNbWdDTGUyNnNyUXFWWHdIQ ▶" 1 => "eurekaselectnew_session=eyJpdiI6IkIwd1FvNWNBaEpKUlF5Zk1UMVB5cGc9PSIsInZhbHVlIjoicUYrNXkvemFPTmJncDMwYVJzTUR1TitxV2tBMGNYNzE5Vi8zMWwrRXJvL25JZ2RuWFFXb1oxMUsvTmRDZzZLcm1GdkdnUm0xdEw3MzllV2JBSHZLckVOaXdwS05iYUdZenVrZlNYWVcvTG5OcWt6K1dyK2tsVW5Wdko4MU10b0EiLCJtYWMiOiJmOGIzZWUzMDdlM2M4YWFjNGJjODk5NDVkMjJiODMzZDRjMzI4NTljMGJjMjcwYTg3M2U5M2Q1NmEwY2Q5NDNmIiwidGFnIjoiIn0%3D; path=/; secure; httponly ◀eurekaselectnew_session=eyJpdiI6IkIwd1FvNWNBaEpKUlF5Zk1UMVB5cGc9PSIsInZhbHVlIjoicUYrNXkvemFPTmJncDMwYVJzTUR1TitxV2tBMGNYNzE5Vi8zMWwrRXJvL25JZ2RuWFFXb1oxMUsvTmRD ▶" ] ]
0 of 0array:5 [▼ "_token" => "vpkuWeVOGgxjTbR4mjmpT2enXwFE63r7NA1NOCCA" "uc_cart_id" => "aac5208ca484ee5f93fe11ddb0770221" "_previous" => array:1 [▶ "url" => "https://beta.benthamscience.com/chapter/15513" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]