1 x Booting (51.1%) | 91.91ms |
1 x Application (48.89%) | 87.94ms |
Backtrace |
|
INSERT INTO visitor_ip_address (ip_address,visitor_agent,visitor_count, created_on,updated_on) VALUES ('873443466','',1,1739835028,1739835028)
ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739835028
Backtrace |
|
INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('873443466','/journal/223/become_an_executive_guest_editor',1,1739835028,1739835028)
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 >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) 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 >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) 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 >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) 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 >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) 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 >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) 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 >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 873443466 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 873443466) limit 1
Bindings |
|
Backtrace |
|
select CONCAT(`subtitle`, ' - ', `title`) as title, `journal_id` from `journal` order by `subtitle` asc
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 = 223 and i.is_uploaded = 1
order by v.volume_name+0 desc, i.title+0 desc limit 1
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 from journal j
join volume v on j.journal_id = v.journal_id
join year y on v.year_id = y.id
where j.journal_id = 223 and y.year = 2025
order by v.volume_name+0 desc limit 1
Backtrace |
|
select * from `country`
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=223) and sj.journal_id!=223 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=223) and sj.journal_id!=223 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=223) 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=223) 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 s.*,concat(s.type," - ","Volume ",s.volume_name,", ",s.frequency," Issue (",s.year,")") as subs_category from `tbl_subscription` as `s` inner join `journal` as `j` on `j`.`journal_id` = `s`.`journal_id` where s.journal_id= 223 order by subs_id desc
Backtrace |
|
select j.subtitle, j.title,js.* from `journal_section` as `js` inner join `journal` as `j` on `js`.`journal_id` = `j`.`journal_id` where `js`.`journal_id` = '223' and `js`.`js_status` = '1' order by `js`.`category_name` asc, `js`.`js_title` asc
Bindings |
|
Backtrace |
|
select * from `journal` where `journal_id` = '223' limit 1
Bindings |
|
Backtrace |
|
select substring_index(GROUP_CONCAT(i.nicename ORDER BY i.priority SEPARATOR ', '), ',', 3) as indexing_title, COUNT(i.nicename) as indexing_occurrences from `indexing_journal` as `ij` inner join `indexing_agencies` as `i` on `ij`.`index_id` = `i`.`index_id` where `ij`.`journal_id` = '223' and `i`.`status` = 1 and `i`.`index_flag` = 1 group by `ij`.`journal_id` limit 1
Bindings |
|
Backtrace |
|
select `sj`.*, `s`.*, `sp`.`title` as `parent_title`, `sp`.`subject_id` as `parent_subject_id` from `subject_journal` as `sj` inner join `subject` as `s` on `s`.`subject_id` = `sj`.`subject_id` left join `subject` as `sp` on `sp`.`subject_id` = `s`.`parent_id` where `journal_id` = '223'
Bindings |
|
Backtrace |
|
select `dj`.`disease_id`, `d`.`disease_name` from `disease_journal` as `dj` inner join `journal` as `j` on `dj`.`journal_id` = `j`.`journal_id` inner join `disease` as `d` on `dj`.`disease_id` = `d`.`disease_id` where `dj`.`journal_id` = '223'
Bindings |
|
Backtrace |
|
select * from `node_meta` where `nid` = 219451 limit 1
Bindings |
|
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 = 223 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` 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 = 223 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
Backtrace |
|
select `subtitle` from `journal` where `continues_publication_journal` = 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` = 223 and `b`.`banner_from_date` <= 1739835028 and `b`.`banner_to_date` >= 1739835028 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `uc_cart_products` where cart_id='52d1fc73d8b73e9adc329ade1557beef'
Backtrace |
|
200
[]
[]
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=eyJpdiI6IlBGVS9pMVBXY3BsM3FjUHhwaDlMU1E9PSIsInZhbHVlIjoiditFZXY1Y2ZRRmIxV0E5aWlyRXBkSWxpQWFSMVEvVW0wUWFkOFNtM0tFYz0iLCJtYWMiOiI0ZGU0ZjNiYjI1ZTcwYTNiZDliNzI3YmUzOTJlNDU4M2E2OTU5YzJjZDU3NmYzY2FlNGE0MzJlNGRkZTIxMjRjIiwidGFnIjoiIn0%3D; XSRF-TOKEN=eyJpdiI6IkJ6dVQ2aFRiY08zVXJkR1VCSjYwbUE9PSIsInZhbHVlIjoiZENxQlViWE1qMTB4SUplNU8xOFdPWjRhZnJGekdJbExzakdDdzg1ZzZXK0luTWVINFZLMUdNamtKME94aXU2L21IdE5yMmF3Y0FpQkdtMGJsYy9hT1BzL3VHQmljNDVBRnhwcW1BVUVZU1ZFcEQraWZLeVNncndoa2Q0dS9sNE0iLCJtYWMiOiI4NDA5MGNhZWQ4YzI2ODQwYTc0NGU4YzhjNGFlY2Q3Nzg1MjVkOWJlNjQ1ZWUwN2Y1MzY0NTU4MjQ5OTBkYWQzIiwidGFnIjoiIn0%3D; alphaeurekaselectnet_session=eyJpdiI6Ikk1NXA5VnhSb3NJMEU5SXNnNW5YS3c9PSIsInZhbHVlIjoiYTdQN0NTOHQrekVwRzJ0ZER0clVmSlBjMmROWHArTG1BUkZSblNBVzN2VDdaaFdBV1IwZENCWTk2MmFNR0ZnL2x0RDhZbHVUK0RNaCtSRURuUWRrUXYyaGxVOWNyQ3JTVGhEd3g3ekxPL2E5QmpZOXJablhGU0JEUkdTMko1V3oiLCJtYWMiOiJkYmEyZmM3NWFmZGZkNDU1ODgzNmZiYmQ4YTllOTU0MzVlZDhjMDc4Y2ZmMjg2NjZiZmFkYmE2OGYyOGQyNTA0IiwidGFnIjoiIn0%3D ◀wayfindertarget=eyJpdiI6IlBGVS9pMVBXY3BsM3FjUHhwaDlMU1E9PSIsInZhbHVlIjoiditFZXY1Y2ZRRmIxV0E5aWlyRXBkSWxpQWFSMVEvVW0wUWFkOFNtM0tFYz0iLCJtYWMiOiI0ZGU0ZjNiYjI1ZTcw ▶" ] "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" => "tFP8Fvx8Vnwum5EHKQuKCntkEWTXck3zxgCvWOCL" "alphaeurekaselectnet_session" => "evNJsAv7ZUSqaRp1eAKGFAdsnKsCWjZyD77Zvglp" ]
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 => "Mon, 17 Feb 2025 23:30:28 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlRmZnFhcjA5YWpuaVNTOW5QeEhKOEE9PSIsInZhbHVlIjoiNGhwTFBRL1FpWnFseWorbVc4RWZvQzROQ1RqSmNlaGQ4UytpVDQ3eEhtU2FnZHFLQzJ5K1pYRHNuMzBhR1N2OUZOSmVRUEZWZ0pZeFRpbTNUdmhVUnZsWmJnUm5MUTNRby9pSnJodjVTR094Q0tXa0lIeW1LZGNIYjVZcDNVNE4iLCJtYWMiOiIwYjhjNmRhYmRiNjExYTRlMzE1MmVjMDQwOTk1ZDUxNTQzYWI5ZjI1ZDczODJiMjM4NWVjMWI4ZGZiOWI5YmY1IiwidGFnIjoiIn0%3D; expires=Thu, 20 Feb 2025 11:30:28 GMT; Max-Age=216000; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlRmZnFhcjA5YWpuaVNTOW5QeEhKOEE9PSIsInZhbHVlIjoiNGhwTFBRL1FpWnFseWorbVc4RWZvQzROQ1RqSmNlaGQ4UytpVDQ3eEhtU2FnZHFLQzJ5K1pYRHNuMzBhR1N2OUZOSmVRU ▶" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImtFRDBvVVp0QWhJVHRsa1grNUpmYkE9PSIsInZhbHVlIjoiM0d5cmtEMVBWVTJ4Ty9QWW1KbHFPWFVoNndkK01hUnB6Ty9KVTIrRHlLVU13RG9oei9MMFdXNXp2ckxoenVrMzVtUlJ4dm5hRHFzRFdPcWFlTUNzT2JPeTR5NXAyT0FYbHBUTkVnSnZiWVF6aVAwaTFGQ3l3aFpuL0tFemhFYmwiLCJtYWMiOiJjZmIxZTUzNTNlNWVhMDg1YjAxN2Q5NzcxMjg2NWFkOGRhYTk3MGY1NTQ0ZjdjMjNhNTVlN2EyYzIyM2IwYmM3IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=lax ◀alphaeurekaselectnet_session=eyJpdiI6ImtFRDBvVVp0QWhJVHRsa1grNUpmYkE9PSIsInZhbHVlIjoiM0d5cmtEMVBWVTJ4Ty9QWW1KbHFPWFVoNndkK01hUnB6Ty9KVTIrRHlLVU13RG9oei9MMFdXNXp ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlRmZnFhcjA5YWpuaVNTOW5QeEhKOEE9PSIsInZhbHVlIjoiNGhwTFBRL1FpWnFseWorbVc4RWZvQzROQ1RqSmNlaGQ4UytpVDQ3eEhtU2FnZHFLQzJ5K1pYRHNuMzBhR1N2OUZOSmVRUEZWZ0pZeFRpbTNUdmhVUnZsWmJnUm5MUTNRby9pSnJodjVTR094Q0tXa0lIeW1LZGNIYjVZcDNVNE4iLCJtYWMiOiIwYjhjNmRhYmRiNjExYTRlMzE1MmVjMDQwOTk1ZDUxNTQzYWI5ZjI1ZDczODJiMjM4NWVjMWI4ZGZiOWI5YmY1IiwidGFnIjoiIn0%3D; expires=Thu, 20-Feb-2025 11:30:28 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlRmZnFhcjA5YWpuaVNTOW5QeEhKOEE9PSIsInZhbHVlIjoiNGhwTFBRL1FpWnFseWorbVc4RWZvQzROQ1RqSmNlaGQ4UytpVDQ3eEhtU2FnZHFLQzJ5K1pYRHNuMzBhR1N2OUZOSmVRU ▶" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImtFRDBvVVp0QWhJVHRsa1grNUpmYkE9PSIsInZhbHVlIjoiM0d5cmtEMVBWVTJ4Ty9QWW1KbHFPWFVoNndkK01hUnB6Ty9KVTIrRHlLVU13RG9oei9MMFdXNXp2ckxoenVrMzVtUlJ4dm5hRHFzRFdPcWFlTUNzT2JPeTR5NXAyT0FYbHBUTkVnSnZiWVF6aVAwaTFGQ3l3aFpuL0tFemhFYmwiLCJtYWMiOiJjZmIxZTUzNTNlNWVhMDg1YjAxN2Q5NzcxMjg2NWFkOGRhYTk3MGY1NTQ0ZjdjMjNhNTVlN2EyYzIyM2IwYmM3IiwidGFnIjoiIn0%3D; path=/; secure; httponly ◀alphaeurekaselectnet_session=eyJpdiI6ImtFRDBvVVp0QWhJVHRsa1grNUpmYkE9PSIsInZhbHVlIjoiM0d5cmtEMVBWVTJ4Ty9QWW1KbHFPWFVoNndkK01hUnB6Ty9KVTIrRHlLVU13RG9oei9MMFdXNXp ▶" ] ]
0 of 0array:5 [▼ "_token" => "tFP8Fvx8Vnwum5EHKQuKCntkEWTXck3zxgCvWOCL" "uc_cart_id" => "52d1fc73d8b73e9adc329ade1557beef" "_previous" => array:1 [▶ "url" => "https://alpha.eurekaselect.com/journal/223/become_an_executive_guest_editor" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]