Author(s): Lalthazuala Rokhum and Ghanashyam Bez
Page: [641 - 642] Pages: 2
* (Excluding Mailing and Handling)
1 x Application (57.24%) | 129ms |
1 x Booting (42.75%) | 96.08ms |
Backtrace |
|
INSERT INTO visitor_ip_address (ip_address,visitor_agent,visitor_count, created_on,updated_on) VALUES ('309728264','',1,1735391429,1735391429)
ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1735391429
Backtrace |
|
INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('309728264','/article/99188',1,1735391429,1735391429)
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 >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) 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 >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) 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 >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) 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 >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) 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 >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) 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 >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 309728264 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309728264) limit 1
Bindings |
|
Backtrace |
|
SELECT at.type_name, p.copyright, p.publisher_location,m.month,y.year,
a.publish_on, a.nid article_nid,a.article_id, a.pmid, a.issue_id, a.title, a.abstract,a.podcast,a.altmetric_score,a.altmetric_url,a.kudos_url, a.page_count, a.first_page, a.elocator,
a.last_page, i.publication_date, a.file_name,
a.file_path, a.doi, a.is_epub,a.epub_type, a.volume_id, a.is_uploaded, a.editor_choice, a.is_epub, j.image_file_name,
a.article_no, a.art_type AS article_type, a.supplementary_filename,a.html_filename,a.prc_filename,a.epub_filename, a.graph_abs_lg_filename, a.graph_abs_sm_filename, a.oa_image_lg_filename, a.oa_image_sm_filename, j.journal_banner,a.animated_abstract,a.erratum_in,a.erratum_for,
(CASE WHEN a.issue_id =0 THEN j.epub_price ELSE j.price END) AS sell_price, j.epub_price, j.nid AS jour_nid, j.title AS journal_title, j.issn, j.eissn,j.journal_id, j.subtitle AS jour_subtitle,
v.volume_id,v.volume_name AS volume, v.year_id, i.title AS issue, i.month_id ,i.type issue_type, j.subtitle,j.formerly_title, ac.subtitle AS epub_title,a.crossmark_enabled,a.text_mining_urls,a.license_urls,a.created, a.receivedate, a.revisedate, a.acceptdate,js.js_title
FROM article a
LEFT JOIN article_section ac ON a.is_epub = ac.art_sec_id
LEFT JOIN journal_section js ON a.js_id = js.js_id
LEFT JOIN article_type at ON a.art_type = at.art_type_id
LEFT JOIN issue i ON a.issue_id = i.issue_id
LEFT JOIN month m ON m.id = i.month_id
LEFT JOIN volume v ON v.volume_id = a.volume_id
INNER JOIN year y ON y.id = v.year_id
INNER JOIN journal j ON j.journal_id = a.journal_id
INNER JOIN publisher p ON p.publisher_id = j.publisher_id
WHERE a.article_id=99188
Backtrace |
|
select * from `journal` where `journal_id` = 19 limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from (select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword,
j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=19) and sj.journal_id!=19 group by `j`.`nid`) as `aggregate_table`
Backtrace |
|
select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword,
j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=19) and sj.journal_id!=19 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
Backtrace |
|
select count(*) as aggregate from (select 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` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id
FROM subject_journal
WHERE journal_id=19) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
Backtrace |
|
select 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` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id
FROM subject_journal
WHERE journal_id=19) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
Backtrace |
|
select * from `keywords` where `article_id` = '99188'
Bindings |
|
Backtrace |
|
select * from `article_citation` where `article_id` = '99188'
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`.`article_id` = '99188' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
Bindings |
|
Backtrace |
|
select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
Bindings |
|
Backtrace |
|
select `subtitle` from `journal` where `continues_publication_journal` = 1
Bindings |
|
Backtrace |
|
Select j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j
join volume v on j.journal_id = v.journal_id
join issue i on v.volume_id = i.volume_id
join article a on a.issue_id = i.issue_id
join year y on v.year_id = y.id
where j.journal_id = 19 and i.is_uploaded = 1
order by v.volume_name+0 desc, i.title+0 desc limit 1
Backtrace |
|
select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id,
a.issue_id,a.title,first_page, last_page,
page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name,
a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 1 and a.journal_id = 19 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`last_modified` desc
Backtrace |
|
select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id,
a.issue_id,a.title,first_page, last_page,
page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name,
a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 19 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`last_modified` desc
Backtrace |
|
select pdf, html, epub, prc from `article_metrics` where `article_id` = 99188 limit 1
Bindings |
|
Backtrace |
|
select * from content_by_diseases
where content_id = 99188 and content_type = 'article' order by status desc limit 1
Backtrace |
|
select * from `node_meta` where `nid` = 172965 limit 1
Bindings |
|
Backtrace |
|
select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
Bindings |
|
Backtrace |
|
select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'COC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
Bindings |
|
Backtrace |
|
select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '99188' and content_type = 'a'
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 * from `article` where `first_page` < '641' and is_uploaded = 1 and issue_id = 9168 order by cast(first_page as SIGNED) desc limit 1
Bindings |
|
Backtrace |
|
select * from `article` where `last_page` > '642' and is_uploaded = 1 and issue_id = 9168 order by cast(first_page as SIGNED) asc limit 1
Bindings |
|
Backtrace |
|
select `language_id` from `multilanguage` where `short_code` = 'en'
Bindings |
|
Backtrace |
|
select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
Bindings |
|
Backtrace |
|
select `id` from `multilanguage_article` where `article_id` = 99188 limit 1
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` inner join `journal` as `j` on `j`.`journal_id` = `bd`.`content_id` where `b`.`banner_journal` = 1 and `bd`.`content_type` = 'J' and `bd`.`content_id` = 19 and `b`.`banner_from_date` <= 1735391429 and `b`.`banner_to_date` >= 1735391429 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `uc_cart_products` where cart_id='db7be08b4f690fee6f175a4bab80da66'
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 => "Sat, 28 Dec 2024 13:10:29 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im1wQU53VG9JOGl1WE1HZEt3OW5pN0E9PSIsInZhbHVlIjoieDFhbk0xaEhXN3E4b2RMeHZHajdQTGFMMzE5M3laNEt0VHVmWUFYN2JpQk9mTDI2cXNRMkhLTDRJVUwzWDVnTW53cThNSFlHVDBqZXA5VHB4YnZDMjEra1BpWTNKak5hSUgvenJtQ29ESnYremFXbnlPaHlzRWxVOC9ZcUhxWmkiLCJtYWMiOiI2MGRiMzIyZmZlZDAwYzcxYjE5NjcwODdkMDFmYzQwYWVlMTgxNzE4MWUyODYyMGZhMjdlYWExNGE5ZTNjOWU3IiwidGFnIjoiIn0%3D; expires=Tue, 31 Dec 2024 01:10:29 GMT; Max-Age=216000; path=/; secure; samesite=strict ◀XSRF-TOKEN=eyJpdiI6Im1wQU53VG9JOGl1WE1HZEt3OW5pN0E9PSIsInZhbHVlIjoieDFhbk0xaEhXN3E4b2RMeHZHajdQTGFMMzE5M3laNEt0VHVmWUFYN2JpQk9mTDI2cXNRMkhLTDRJVUwzWDVnTW53cThNS ▶" 1 => "eurekaselectnew_session=eyJpdiI6IjArRHZQRm53Tkt5dDR3NkhUTG5HQmc9PSIsInZhbHVlIjoiL1UzeWVVMFJqd2JzSHZVbnBUVkxXUVYvbEVFZ1pvS0FZYVVWY1pJazU5UlF4ZDhYNXRXejU0WCtMVE00WGdWVGlVMlNiZHRQb0ZhdWF2aDNxeFBhQk00L3FBSHRUNHE4cjQ0eW5OOFZ2RnBtTXRlaVFJc0VWdnYwdkxST2NMRGsiLCJtYWMiOiJjZjgxYjYzNGExNTk2Y2Y3NTBmOGExMjlkNzI2NWZlNWY3NWFiNTc0NWE5MWQzMDE0YWVhZWM1Y2E3ZTVkNzJkIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=strict ◀eurekaselectnew_session=eyJpdiI6IjArRHZQRm53Tkt5dDR3NkhUTG5HQmc9PSIsInZhbHVlIjoiL1UzeWVVMFJqd2JzSHZVbnBUVkxXUVYvbEVFZ1pvS0FZYVVWY1pJazU5UlF4ZDhYNXRXejU0WCtMVE00 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im1wQU53VG9JOGl1WE1HZEt3OW5pN0E9PSIsInZhbHVlIjoieDFhbk0xaEhXN3E4b2RMeHZHajdQTGFMMzE5M3laNEt0VHVmWUFYN2JpQk9mTDI2cXNRMkhLTDRJVUwzWDVnTW53cThNSFlHVDBqZXA5VHB4YnZDMjEra1BpWTNKak5hSUgvenJtQ29ESnYremFXbnlPaHlzRWxVOC9ZcUhxWmkiLCJtYWMiOiI2MGRiMzIyZmZlZDAwYzcxYjE5NjcwODdkMDFmYzQwYWVlMTgxNzE4MWUyODYyMGZhMjdlYWExNGE5ZTNjOWU3IiwidGFnIjoiIn0%3D; expires=Tue, 31-Dec-2024 01:10:29 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Im1wQU53VG9JOGl1WE1HZEt3OW5pN0E9PSIsInZhbHVlIjoieDFhbk0xaEhXN3E4b2RMeHZHajdQTGFMMzE5M3laNEt0VHVmWUFYN2JpQk9mTDI2cXNRMkhLTDRJVUwzWDVnTW53cThNS ▶" 1 => "eurekaselectnew_session=eyJpdiI6IjArRHZQRm53Tkt5dDR3NkhUTG5HQmc9PSIsInZhbHVlIjoiL1UzeWVVMFJqd2JzSHZVbnBUVkxXUVYvbEVFZ1pvS0FZYVVWY1pJazU5UlF4ZDhYNXRXejU0WCtMVE00WGdWVGlVMlNiZHRQb0ZhdWF2aDNxeFBhQk00L3FBSHRUNHE4cjQ0eW5OOFZ2RnBtTXRlaVFJc0VWdnYwdkxST2NMRGsiLCJtYWMiOiJjZjgxYjYzNGExNTk2Y2Y3NTBmOGExMjlkNzI2NWZlNWY3NWFiNTc0NWE5MWQzMDE0YWVhZWM1Y2E3ZTVkNzJkIiwidGFnIjoiIn0%3D; path=/; secure; httponly ◀eurekaselectnew_session=eyJpdiI6IjArRHZQRm53Tkt5dDR3NkhUTG5HQmc9PSIsInZhbHVlIjoiL1UzeWVVMFJqd2JzSHZVbnBUVkxXUVYvbEVFZ1pvS0FZYVVWY1pJazU5UlF4ZDhYNXRXejU0WCtMVE00 ▶" ] ]
0 of 0array:5 [▼ "_token" => "BemJMZpxb5TlDLrlyRpIek1yzwkaVox4Dgx6WFh6" "uc_cart_id" => "db7be08b4f690fee6f175a4bab80da66" "_previous" => array:1 [▶ "url" => "https://beta.benthamscience.com/article/99188" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]