DOI: 10.2174/97816080520041060201
eISBN: 978-1-60805-200-4,
2006
ISBN: 978-1-60805-670-5
ISSN: 1574-0889 (Print)
ISSN: 2212-1064 (Online)
Cite this Book as:
For Books
Gary W. Caldwell, M. Iqbal Choudhary, Michael R. D’Andrea, Atta Ur-Rahman , " Frontiers in Drug Design and Discovery ", Bentham Science Publishers (2006). https://doi.org/10.2174/97816080520041060201
DOI https://doi.org/10.2174/97816080520041060201 Publisher Name Bentham Science Publisher |
Print ISBN Online ISBN |
1 x Application (93.78%) | 1.99s |
1 x Booting (6.22%) | 132ms |
Backtrace |
|
INSERT INTO visitor_ip_address (ip_address,visitor_agent,visitor_count, created_on,updated_on) VALUES ('221988192','',1,1739971533,1739971533)
ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739971533
Backtrace |
|
INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('221988192','/ebook_volume/939/related-ebooks?page=12',1,1739971533,1739971533)
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 >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) 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 >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) 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 >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) 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 >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) 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 >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) 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 >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 221988192 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 221988192) limit 1
Bindings |
|
Backtrace |
|
select `year`, `id` from `year` order by `year` asc
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` = '939' and `e`.`is_uploaded` = 1
Bindings |
|
Backtrace |
|
select `ie`.`index_id`, `ie`.`ebook_volume_id`, `i`.`title` from `indexing_ebook` as `ie` left join `indexing_agencies` as `i` on `ie`.`index_id` = `i`.`index_id` where `ie`.`ebook_volume_id` = '939' and `i`.`status` = 1 order by `i`.`title` asc
Bindings |
|
Backtrace |
|
select count(*) as aggregate from (select `chapter`.*, group_concat(a.first_name,' ',a.last_name) as author_name from `chapter` left join `author` as `a` on `a`.`chapter_id` = `chapter`.`chapter_id` where `chapter`.`ebook_volume_id` = '939' and `chapter`.`is_uploaded` = 1 group by `chapter`.`chapter_id`) as `aggregate_table`
Bindings |
|
Backtrace |
|
select `chapter`.*, group_concat(a.first_name,' ',a.last_name) as author_name from `chapter` left join `author` as `a` on `a`.`chapter_id` = `chapter`.`chapter_id` where `chapter`.`ebook_volume_id` = '939' and `chapter`.`is_uploaded` = 1 group by `chapter`.`chapter_id` order by `chapter`.`chapter_no` asc limit 100 offset 1100
Bindings |
|
Backtrace |
|
select * from `ebook` where `ebook_id` = 151 limit 1
Bindings |
|
Backtrace |
|
select count(*) rcd from `ebook_volume` where `ebook_id` = 151 and ebook_volume_id <> 939 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=151)
and se.ebook_id!=151 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=151)
and se.ebook_id!=151 and v.ebook_status='1' limit 10 offset 110
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=151)
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=151) limit 10 offset 110
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, CONCAT_WS(' ',au.first_name, IFNULL(CONCAT(' ', au.initials), ''), IFNULL(CONCAT(' ', au.last_name), '')) as authorsmodal , `au`.*, `af`.`ror_id`, `af`.`institution`, `af`.`department`, `af`.`country`, `af`.`city`, `af`.`address`, (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`.`ebook_volume_id` = '939' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
Bindings |
|
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` = 939 and `b`.`banner_from_date` <= 1739971533 and `b`.`banner_to_date` >= 1739971533 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
Bindings |
|
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` = 939 and `b`.`banner_from_date` <= 1739971533 and `b`.`banner_to_date` >= 1739971533 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `uc_cart_products` where cart_id='3d25a1663b5f24bdba979972c7a6aa9d'
Backtrace |
|
200
0 of 0array:1 [▼ "page" => "12" ]
[]
0 of 0array:17 [▼ "x-https" => array:1 [▶ 0 => "1" ] "host" => array:1 [▶ 0 => "alpha.eurekaselect.com" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "cookie" => array:1 [▶ 0 => "wayfindertarget=eyJpdiI6Ik5BRG5aZXpqTmZZVi9ha2JlV2xuSWc9PSIsInZhbHVlIjoiaDhCd0pnSThBdzA0TU41NFY3Z1piRTVKWFg2STlnblNoSVA2R29tazBsd0wzQlZXdEZhek9KTW1xMGRYd0g2TEVDSHBXdndRRDlrUk1jOXhML25tZFE9PSIsIm1hYyI6IjY3NDNmYTMzMWJkYTVkNDEzMGE1MDEwZmMxY2Q2MDc3ODE4ZjNmMGY5YmRiYjFkNjdiMDVmNzZkOTMwMzk2M2EiLCJ0YWciOiIifQ%3D%3D; XSRF-TOKEN=eyJpdiI6InZHYnlSWXNvRXNPVVNpd01MRFhRWlE9PSIsInZhbHVlIjoibGZYSWgvNGl1NUtwbGpSdEVxeFhvQTI3ZHlUVGJKUUJXVi9XWE5Fd2Q3czlZMGNIcVFVMVdYZGplUXphVHhkRVcwZWFJMjY2RkcyN3RPclNHU0RTaTUzT0VFL1IrM0d1UElNSjZQRDFMSFFnYXFpbFpsMTA1T3pMOVd0YmNaZSsiLCJtYWMiOiJjZjc3MTA5MGNjYzQwMDcwYzEyMzgyYWM4YTQ4NjBmMTUxNTFlZmViZjIyNTlmMGFhODcyMmMwNjk5NzgxMzFhIiwidGFnIjoiIn0%3D; alphaeurekaselectnet_session=eyJpdiI6IlVMUXJyN01LWW9wT0lCc21JYldXamc9PSIsInZhbHVlIjoiTFlsTnNkbjlUVVZObkN4Zk5LRFVpdVdwOHhPSjhRMUMvRzZFN0c0K3Y4RUtkdit1REtkRDNQdWx1VHZ6OTczS3ZCL1FyWnBqS2hQY3U3UFR2UmRqNG5EaFZzTElUMGttUnFYS2hkU3Q3WW42UDd3Z3RTcGpkaGZ2K1R1ZE1qeE8iLCJtYWMiOiJjOTY5YjJkYzAzYThkY2I0YjgzN2Y2NmFkNWJlYWJhZWJjMTE1NzlmN2UxMWEzMzExYWY1YTYwZmNlNWU2MzQzIiwidGFnIjoiIn0%3D ◀wayfindertarget=eyJpdiI6Ik5BRG5aZXpqTmZZVi9ha2JlV2xuSWc9PSIsInZhbHVlIjoiaDhCd0pnSThBdzA0TU41NFY3Z1piRTVKWFg2STlnblNoSVA2R29tazBsd0wzQlZXdEZhek9KTW1xMGRYd0g2TEVD ▶" ] "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:3 [▼ "wayfindertarget" => null "XSRF-TOKEN" => "uRmeQHYLFa5jSZp8HZoEw45O2XseLpxy9I4iFFA5" "alphaeurekaselectnet_session" => "psk9eown93RFsHfC4I5bLCsRAJDtlwDdwXE8vc6g" ]
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 => "Wed, 19 Feb 2025 13:25:33 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IklUYmlRQUVyM3N4dm9UWXAxVi9wRVE9PSIsInZhbHVlIjoiUEY0cWlqQVMwbCtORlBwNHpPMDk3STVSbVpRMHBYMEh0VC9FVnFMR280YURmdHg1SW4xU2prOWMvNFlSa3RTYVVIb2o3UEkxeHMvQ0ZxUEZCSXNESHVWREJNeHhEVVlvcDJRa1E0NWFRRUpyeDd2MzFPalJ6ZlpOZHM3dGpaVUsiLCJtYWMiOiIwYTEyYmQ4Y2M4M2MyZDI0NGNjMTg3ODg1YjQyZDUxNTliODg1OGViMTkzNzcyN2YyNWQzNzVjMmZlMDVhOWZmIiwidGFnIjoiIn0%3D; expires=Sat, 22 Feb 2025 01:25:33 GMT; Max-Age=216000; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IklUYmlRQUVyM3N4dm9UWXAxVi9wRVE9PSIsInZhbHVlIjoiUEY0cWlqQVMwbCtORlBwNHpPMDk3STVSbVpRMHBYMEh0VC9FVnFMR280YURmdHg1SW4xU2prOWMvNFlSa3RTYVVIb2o3U ▶" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ijd6WjQ3NEZrVmhocllTQ085YXovYkE9PSIsInZhbHVlIjoiQXhZWkFIUDJ1akJmbmMvQVZRR0RmOEtFUVlaaVBNaFRlNjF5QkM5VGFNQU14TFc3MldGM1AyNnhnUmx6WE9GU2loUFBpQ2s5Z1RsZ3RvZHZjNlRvRk1DTEp0WUVBS2RWa0dFWlQ0dnFyL053VTRNeDU5T2cwakZrdVo0b3dMc3YiLCJtYWMiOiJkYzMyN2E0MDBmMmI4N2ZiM2YxNmQxNzJhYzRjYWRlOGFhZjBjMWRjNjE4NzRkMTg0Yzc2ZDVmMzEwMTAwNjJkIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=lax ◀alphaeurekaselectnet_session=eyJpdiI6Ijd6WjQ3NEZrVmhocllTQ085YXovYkE9PSIsInZhbHVlIjoiQXhZWkFIUDJ1akJmbmMvQVZRR0RmOEtFUVlaaVBNaFRlNjF5QkM5VGFNQU14TFc3MldGM1AyNnh ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IklUYmlRQUVyM3N4dm9UWXAxVi9wRVE9PSIsInZhbHVlIjoiUEY0cWlqQVMwbCtORlBwNHpPMDk3STVSbVpRMHBYMEh0VC9FVnFMR280YURmdHg1SW4xU2prOWMvNFlSa3RTYVVIb2o3UEkxeHMvQ0ZxUEZCSXNESHVWREJNeHhEVVlvcDJRa1E0NWFRRUpyeDd2MzFPalJ6ZlpOZHM3dGpaVUsiLCJtYWMiOiIwYTEyYmQ4Y2M4M2MyZDI0NGNjMTg3ODg1YjQyZDUxNTliODg1OGViMTkzNzcyN2YyNWQzNzVjMmZlMDVhOWZmIiwidGFnIjoiIn0%3D; expires=Sat, 22-Feb-2025 01:25:33 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IklUYmlRQUVyM3N4dm9UWXAxVi9wRVE9PSIsInZhbHVlIjoiUEY0cWlqQVMwbCtORlBwNHpPMDk3STVSbVpRMHBYMEh0VC9FVnFMR280YURmdHg1SW4xU2prOWMvNFlSa3RTYVVIb2o3U ▶" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ijd6WjQ3NEZrVmhocllTQ085YXovYkE9PSIsInZhbHVlIjoiQXhZWkFIUDJ1akJmbmMvQVZRR0RmOEtFUVlaaVBNaFRlNjF5QkM5VGFNQU14TFc3MldGM1AyNnhnUmx6WE9GU2loUFBpQ2s5Z1RsZ3RvZHZjNlRvRk1DTEp0WUVBS2RWa0dFWlQ0dnFyL053VTRNeDU5T2cwakZrdVo0b3dMc3YiLCJtYWMiOiJkYzMyN2E0MDBmMmI4N2ZiM2YxNmQxNzJhYzRjYWRlOGFhZjBjMWRjNjE4NzRkMTg0Yzc2ZDVmMzEwMTAwNjJkIiwidGFnIjoiIn0%3D; path=/; secure; httponly ◀alphaeurekaselectnet_session=eyJpdiI6Ijd6WjQ3NEZrVmhocllTQ085YXovYkE9PSIsInZhbHVlIjoiQXhZWkFIUDJ1akJmbmMvQVZRR0RmOEtFUVlaaVBNaFRlNjF5QkM5VGFNQU14TFc3MldGM1AyNnh ▶" ] ]
0 of 0array:5 [▼ "_token" => "uRmeQHYLFa5jSZp8HZoEw45O2XseLpxy9I4iFFA5" "uc_cart_id" => "3d25a1663b5f24bdba979972c7a6aa9d" "_previous" => array:1 [▶ "url" => "https://alpha.eurekaselect.com/ebook_volume/939/related-ebooks?page=12" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]