Advance Search | Bentham Science

Messages8 Timeline Exceptions Views7 Route Queries71 Models7 Mails Gate Session Request

Request history8.2.28505ms53MBGET search/{searchvalue?}

warninglog[10:48:03] LOG.warning: urlencode(): Passing null to parameter #1 ($string) of type string is deprec...
warninglog[10:48:03] LOG.warning: Creation of dynamic property Illuminate\Http\Request::$btnjournalsearch is d...
warninglog[10:48:03] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
warninglog[10:48:03] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
warninglog[10:48:03] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
warninglog[10:48:03] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
warninglog[10:48:03] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
warninglog[10:48:03] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...

Booting (113ms)time
Application (392ms)time
1 x Application (77.63%)
392ms
1 x Booting (22.37%)
113ms

7 templates were rendered

searchsearch.blade.php#?blade
search_datasearch_data.blade.php#?blade
paginationpagination.blade.php#?blade
layouts.appapp.blade.php#?blade
layouts._login_access_login_access.blade.php#?blade
layouts._main_menu_main_menu.blade.php#?blade
layouts._footer_menu_footer_menu.blade.php#?blade

uri: GET search/{searchvalue?}
middleware: web, check_user_access
controller: App\Http\Controllers\SearchController@getSearch
namespace: App\Http\Controllers
where
as: advancesearch
file: app/Http/Controllers/SearchController.php:369-590

71 statements were executed142ms

Connection Establishedbetabenthamscien_newUserAccessCheck.php#24

Backtrace

9. middleware::check_user_access:24
10. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
11. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
13. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88

INSERT INTO visitor_ip_address (ip_address,visitor_agent,visitor_count, created_on,updated_on) VALUES ('58766425','',1,1744022883,1744022883)
ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1744022883

1.33msbetabenthamscien_newUserAccessCheck.php#24

Backtrace

11. middleware::check_user_access:24
12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88

INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('58766425','/search?searchvalue=+HGFIN',1,1744022883,1744022883)

150μsbetabenthamscien_newUserAccessCheck.php#27

Backtrace

11. middleware::check_user_access:27
12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88

(select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_trail WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) 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 >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) 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 >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) 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 >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) 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 >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) 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 >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 58766425 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58766425) limit 1

13.12msbetabenthamscien_newUserAccess.php#784

Bindings	0: 58766425 1: 58766425 2: 58766425 3: 58766425 4: 58766425 5: 58766425 6: 58766425 7: 58766425 8: 58766425 9: 58766425 10: 58766425 11: 58766425 12: 58766425 13: 58766425 14: 58766425 15: 58766425
Backtrace	14. app/Models/UserAccess/UserAccess.php:784 15. middleware::check_user_access:63 16. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 17. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183

select * from `article_type` where `art_type_id` in ('0', '11') order by FIELD(art_type_id, 0,11)

340μsbetabenthamscien_newArticle.php#2037

Bindings	0: 0 1: 11
Backtrace	13. app/Models/Article.php:2037 14. app/Http/Controllers/SearchController.php:461 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `journal` where `journal_id` in ('28') order by FIELD(journal_id, 28)

1.15msbetabenthamscien_newJournal.php#1395

Bindings	0: 28
Backtrace	13. app/Models/Journal.php:1395 14. app/Http/Controllers/SearchController.php:493 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `subject` where `subject_id` in ('2', '7', '99', '103', '120', '167') order by FIELD(subject_id, 2,7,99,103,120,167)

320μsbetabenthamscien_newSubject.php#433

Bindings	0: 2 1: 7 2: 99 3: 103 4: 120 5: 167
Backtrace	13. app/Models/Subject.php:433 14. app/Http/Controllers/SearchController.php:521 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `subject`

770μsbetabenthamscien_newSubject.php#81

Backtrace

13. app/Models/Subject.php:81
14. app/Http/Controllers/SearchController.php:538
15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select count(*) as aggregate from `journal` as `j` left join `users` as `u` on `u`.`id` = `j`.`created_by`

770μsbetabenthamscien_newJournal.php#120

Backtrace

16. app/Models/Journal.php:120
17. app/Http/Controllers/SearchController.php:539
18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `journal` as `j` left join `users` as `u` on `u`.`id` = `j`.`created_by` order by `j`.`title` asc limit 1000 offset 0

89.86msbetabenthamscien_newJournal.php#120

Backtrace

14. app/Models/Journal.php:120
15. app/Http/Controllers/SearchController.php:539
16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `ebook` where `published` = 1 order by `title` asc

6.82msbetabenthamscien_newEbook.php#66

Bindings	0: 1
Backtrace	13. app/Models/Ebook.php:66 14. app/Http/Controllers/SearchController.php:540 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `article` where `doi` = '10.2174/157488907779561781' limit 1

540μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/157488907779561781
Backtrace	14. app/Models/Article.php:128 15. view::search_data:264 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

select * from `article` where (`article_id` = 22638) limit 1

430μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 22638
Backtrace	16. view::search_data:326 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73 21. vendor/laravel/framework/src/Illuminate/View/View.php:208

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=22638

710μsbetabenthamscien_newArticle.php#408

Backtrace

11. app/Models/Article.php:408
12. app/Http/Controllers/SearchController.php:621
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '22638' 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)
)

430μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:647
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '668' and content_type = 'i'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)

440μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:668
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '534' 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)
)

330μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:690
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 534) 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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 534) 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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 534)

730μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:727
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 668) 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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 668) 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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 668)

540μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:752
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 22638) 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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 22638) 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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 22638)

540μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:784
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `article` where `doi` = '10.2174/157488912800673146' limit 1

310μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/157488912800673146
Backtrace	14. app/Models/Article.php:128 15. view::search_data:264 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

select * from `article` where (`article_id` = 42981) limit 1

280μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 42981
Backtrace	16. view::search_data:326 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73 21. vendor/laravel/framework/src/Illuminate/View/View.php:208

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=42981

530μsbetabenthamscien_newArticle.php#408

Backtrace

11. app/Models/Article.php:408
12. app/Http/Controllers/SearchController.php:621
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '42981' 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)
)

280μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:647
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '4534' and content_type = 'i'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)

250μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:668
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '539' 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)
)

230μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:690
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 539) 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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 539) 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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 539)

630μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:727
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 4534) 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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 4534) 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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 4534)

480μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:752
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 42981) 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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 42981) 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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 42981)

580μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:784
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `article` where `doi` = '10.2174/978160805159511001010378' limit 1

300μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/978160805159511001010378
Backtrace	14. app/Models/Article.php:128 15. view::search_data:264 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

select * from `chapter` where `chapter_id` = '1882' limit 1

250μsbetabenthamscien_newSearchController.php#856

Bindings	0: 1882
Backtrace	16. app/Http/Controllers/SearchController.php:856 17. view::search_data:736 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

select count(*) as total_count, content_type_access_id as access_type from ebook_access
where content_type_id = '1882' 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)
)

270μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:880
13. view::search_data:736
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from ebook_access
where content_type_id = '923' 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)
)

240μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:893
13. view::search_data:736
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 923) 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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 923) 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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 923)

580μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:933
15. view::search_data:736
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 1882) 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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 1882) 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 <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 1882)

570μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:964
15. view::search_data:736
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `article` where `doi` = '10.2174/1567269043390771' limit 1

350μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/1567269043390771
Backtrace	14. app/Models/Article.php:128 15. view::search_data:264 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

select * from `article` where (`article_id` = 36282) limit 1

370μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 36282
Backtrace	16. view::search_data:326 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73 21. vendor/laravel/framework/src/Illuminate/View/View.php:208

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=36282

610μsbetabenthamscien_newArticle.php#408

Backtrace

11. app/Models/Article.php:408
12. app/Http/Controllers/SearchController.php:621
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '36282' 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)
)

340μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:647
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '1429' and content_type = 'i'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)

310μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:668
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '670' 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)
)

300μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:690
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 670) 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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 670) 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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 670)

700μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:727
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 1429) 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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 1429) 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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 1429)

570μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:752
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 36282) 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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 36282) 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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 36282)

600μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:784
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `article` where `doi` = '10.2174/187221409787002967' limit 1

360μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/187221409787002967
Backtrace	14. app/Models/Article.php:128 15. view::search_data:264 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

select * from `article` where (`article_id` = 37997) limit 1

370μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 37997
Backtrace	16. view::search_data:326 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73 21. vendor/laravel/framework/src/Illuminate/View/View.php:208

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=37997

650μsbetabenthamscien_newArticle.php#408

Backtrace

11. app/Models/Article.php:408
12. app/Http/Controllers/SearchController.php:621
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '37997' 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)
)

330μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:647
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '2722' and content_type = 'i'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)

310μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:668
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '637' 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)
)

330μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:690
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 637) 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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 637) 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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 637)

690μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:727
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 2722) 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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 2722) 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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 2722)

580μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:752
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 37997) 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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 37997) 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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 37997)

610μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:784
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `article` where `doi` = '10.2174/157016308783769450' limit 1

390μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/157016308783769450
Backtrace	14. app/Models/Article.php:128 15. view::search_data:264 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

select * from `article` where (`article_id` = 37530) limit 1

370μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 37530
Backtrace	16. view::search_data:326 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73 21. vendor/laravel/framework/src/Illuminate/View/View.php:208

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=37530

570μsbetabenthamscien_newArticle.php#408

Backtrace

11. app/Models/Article.php:408
12. app/Http/Controllers/SearchController.php:621
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '37530' 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)
)

330μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:647
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '2563' and content_type = 'i'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)

330μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:668
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '582' 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)
)

310μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:690
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 582) 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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 582) 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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 582)

670μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:727
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 2563) 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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 2563) 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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 2563)

550μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:752
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 37530) 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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 37530) 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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 37530)

580μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:784
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select * from `article` where `doi` = '10.2174/0115665232291010240221104445' limit 1

380μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/0115665232291010240221104445
Backtrace	14. app/Models/Article.php:128 15. view::search_data:264 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

select * from `article` where (`article_id` = 138754) limit 1

360μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 138754
Backtrace	16. view::search_data:326 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73 21. vendor/laravel/framework/src/Illuminate/View/View.php:208

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=138754

590μsbetabenthamscien_newArticle.php#408

Backtrace

11. app/Models/Article.php:408
12. app/Http/Controllers/SearchController.php:621
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '138754' 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)
)

340μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:647
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '13204' and content_type = 'i'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)

310μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:668
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '3472' 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)
)

320μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php:690
13. view::search_data:336
15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3472) 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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3472) 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,"volume" as access_level,"" as issue_id,"" as article_id  from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3472)

680μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:727
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13204) 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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13204) 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,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13204)

570μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:752
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

(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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 138754) 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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 138754) 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,"article" as access_level, j.issue_id, j.article_id  from `user_access_article_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 58766425 and j.to_ip >=58766425 )) and ((j.from_date <= 1744022883 and j.to_date >= 1744022883 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 138754)

580μsbetabenthamscien_newUserAccess.php#1266

Backtrace

13. app/Models/UserAccess/UserAccess.php:1266
14. app/Http/Controllers/SearchController.php:784
15. view::search_data:336
17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as aggregate from `uc_cart_products` where cart_id='60b5ebbd1121b8a267022a7773304b88'

230μsbetabenthamscien_newCart.php#271

Backtrace

15. app/Models/Cart.php:271
16. view::layouts._main_menu:13
18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

App\Models\Article: 6Article.php#?
App\Models\Chapter: 1Chapter.php#?

_token: pt23LBIvhlMjFzOSx3AGupjqRIrYgrk6I3tXIGL1
uc_cart_id: 60b5ebbd1121b8a267022a7773304b88
_previous: array:1 [ "url" => "https://beta.benthamscience.com/search?searchvalue=%20HGFIN" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/search

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "searchvalue" => "HGFIN"
]

request_request

[]

request_headers

  0 of 0   
array: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"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 07 Apr 2025 10:48:03 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlFFVUNTUXUyZ3dBVVBnM2lsM1UwNVE9PSIsInZhbHVlIjoieFM0TDVQV2FJN20vdXhmYS9Cd3hFMC9xcUFsWnRIV2dHdjJNYzdOSTBTRG11Yzg0SjZKZWVBVWs3SWtKMTYyaVUweXU5c1V3cGorUHpkQzd4VjA1NE1KRENENjJyRTJSQzgzZWVRcG5uRTc2ci9aRDRDTDJyNVQ2U0JTeDhkbUkiLCJtYWMiOiJiZTliMGU3ZjI0NTFjYzJkMzkzNTc5MmM0MzViOWU0NzQ4NmU2YWFmNDdkNjAzYjZhZTRlNmVmOGM5MzZlNGZlIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 22:48:03 GMT; Max-Age=216000; path=/; secure; samesite=strict ◀XSRF-TOKEN=eyJpdiI6IlFFVUNTUXUyZ3dBVVBnM2lsM1UwNVE9PSIsInZhbHVlIjoieFM0TDVQV2FJN20vdXhmYS9Cd3hFMC9xcUFsWnRIV2dHdjJNYzdOSTBTRG11Yzg0SjZKZWVBVWs3SWtKMTYyaVUweXU5c ▶"
    1 => "eurekaselectnew_session=eyJpdiI6IjVrS1hScnNNT0I1aFBDWEFGdTh0K3c9PSIsInZhbHVlIjoiUXNFT25MajkxenY5aHUybzEyVjIwTXpMOUg2SjF3Y0M1K3ZNQXd6cy9tQnN1SnJDMkdMZU82S3AwYjNiSnludEVjTGdxbUx5aUFJNmFRK3p1ZGpReDI2d2N6STEzVVpsd1MvNitSbjhlUTVyY2ZBbTl0a3R6eWEyYXNzM244a20iLCJtYWMiOiJhYTE1YWQ5NWYyMzIwNGU5NmU5NGMyNDkyZGU4ZGMyMWE0MGIxOTU5OTVlZmJhNDUzMDQ2M2VjMDg3MGI1YjEzIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=strict ◀eurekaselectnew_session=eyJpdiI6IjVrS1hScnNNT0I1aFBDWEFGdTh0K3c9PSIsInZhbHVlIjoiUXNFT25MajkxenY5aHUybzEyVjIwTXpMOUg2SjF3Y0M1K3ZNQXd6cy9tQnN1SnJDMkdMZU82S3AwYjNi ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlFFVUNTUXUyZ3dBVVBnM2lsM1UwNVE9PSIsInZhbHVlIjoieFM0TDVQV2FJN20vdXhmYS9Cd3hFMC9xcUFsWnRIV2dHdjJNYzdOSTBTRG11Yzg0SjZKZWVBVWs3SWtKMTYyaVUweXU5c1V3cGorUHpkQzd4VjA1NE1KRENENjJyRTJSQzgzZWVRcG5uRTc2ci9aRDRDTDJyNVQ2U0JTeDhkbUkiLCJtYWMiOiJiZTliMGU3ZjI0NTFjYzJkMzkzNTc5MmM0MzViOWU0NzQ4NmU2YWFmNDdkNjAzYjZhZTRlNmVmOGM5MzZlNGZlIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:48:03 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlFFVUNTUXUyZ3dBVVBnM2lsM1UwNVE9PSIsInZhbHVlIjoieFM0TDVQV2FJN20vdXhmYS9Cd3hFMC9xcUFsWnRIV2dHdjJNYzdOSTBTRG11Yzg0SjZKZWVBVWs3SWtKMTYyaVUweXU5c ▶"
    1 => "eurekaselectnew_session=eyJpdiI6IjVrS1hScnNNT0I1aFBDWEFGdTh0K3c9PSIsInZhbHVlIjoiUXNFT25MajkxenY5aHUybzEyVjIwTXpMOUg2SjF3Y0M1K3ZNQXd6cy9tQnN1SnJDMkdMZU82S3AwYjNiSnludEVjTGdxbUx5aUFJNmFRK3p1ZGpReDI2d2N6STEzVVpsd1MvNitSbjhlUTVyY2ZBbTl0a3R6eWEyYXNzM244a20iLCJtYWMiOiJhYTE1YWQ5NWYyMzIwNGU5NmU5NGMyNDkyZGU4ZGMyMWE0MGIxOTU5OTVlZmJhNDUzMDQ2M2VjMDg3MGI1YjEzIiwidGFnIjoiIn0%3D; path=/; secure; httponly ◀eurekaselectnew_session=eyJpdiI6IjVrS1hScnNNT0I1aFBDWEFGdTh0K3c9PSIsInZhbHVlIjoiUXNFT25MajkxenY5aHUybzEyVjIwTXpMOUg2SjF3Y0M1K3ZNQXd6cy9tQnN1SnJDMkdMZU82S3AwYjNi ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "pt23LBIvhlMjFzOSx3AGupjqRIrYgrk6I3tXIGL1"
  "uc_cart_id" => "60b5ebbd1121b8a267022a7773304b88"
  "_previous" => array:1 [▶
    "url" => "https://beta.benthamscience.com/search?searchvalue=%20HGFIN"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-07 10:48:03	GET	/search?searchvalue=+HGFIN	8 7 71 7

Search Result "HGFIN"

Implication of Possible Therapies Targeted for the Tachykinergic System with the Biology of Neurokinin Receptors and Emerging Related Proteins

The Tachykinergic System as Avenues for Drug Intervention

Tachykinergic System and Binding Molecules in Disease: Implication for Targeted Therapies

Neurokinin Receptors and Subtypes as Potential Targets in Breast Cancer: Relevance to Bone Marrow Metastasis

Physiology of Immune System: Regulation of Stem Cell Survival

Neurokinin Receptors as Potential Targets in Breast Cancer Treatment

The Functions and Application Prospects of Hepatocyte Growth Factor inReproduction

Apply Filters

Content Type

1 x Application (77.63%)	392ms
1 x Booting (22.37%)	113ms