Advance Search | Bentham Science

Messages11 Timeline Exceptions Views7 Route Queries88 Models10 Mails Gate Session Request

Request history8.2.28636ms53MBGET search/{searchvalue?}

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

Booting (91.96ms)time
Application (544ms)time
1 x Application (85.54%)
544ms
1 x Booting (14.46%)
91.96ms

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

88 statements were executed134ms

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 ('51362930','',1,1744016512,1744016512)
ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1744016512

990μsbetabenthamscien_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 ('51362930','/search?searchvalue=+FONA',1,1744016512,1744016512)

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

9.14msbetabenthamscien_newUserAccess.php#784

Bindings	0: 51362930 1: 51362930 2: 51362930 3: 51362930 4: 51362930 5: 51362930 6: 51362930 7: 51362930 8: 51362930 9: 51362930 10: 51362930 11: 51362930 12: 51362930 13: 51362930 14: 51362930 15: 51362930
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 ('10', '0', '9', '24', '11', '28') order by FIELD(art_type_id, 10,0,9,24,11,28)

430μsbetabenthamscien_newArticle.php#2037

Bindings	0: 10 1: 0 2: 9 3: 24 4: 11 5: 28
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 ('29', '103', '15', '23', '25', '50', '181', '205') order by FIELD(journal_id, 29,103,15,23,25,50,181,205)

5.11msbetabenthamscien_newJournal.php#1395

Bindings	0: 29 1: 103 2: 15 3: 23 4: 25 5: 50 6: 181 7: 205
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 ('86', '11', '69', '2', '71', '166', '168', '197', '3', '31', '102', '122', '5', '20', '37', '46', '57', '58', '87', '103', '112', '114', '118', '133', '176') order by FIELD(subject_id, 86,11,69,2,71,166,168,197,3,31,102,122,5,20,37,46,57,58,87,103,112,114,118,133,176)

560μsbetabenthamscien_newSubject.php#433

Bindings	0: 86 1: 11 2: 69 3: 2 4: 71 5: 166 6: 168 7: 197 8: 3 9: 31 10: 102 11: 122 12: 5 13: 20 14: 37 15: 46 16: 57 17: 58 18: 87 19: 103 20: 112 21: 114 22: 118 23: 133 24: 176
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`

850μ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`

610μ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

77.68msbetabenthamscien_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.15msbetabenthamscien_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/9789811432385120030020' limit 1

480μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/9789811432385120030020
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` = '13435' limit 1

370μsbetabenthamscien_newSearchController.php#856

Bindings	0: 13435
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 = '13435' 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)
)

390μ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 = '2808' 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)
)

280μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2808) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2808) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2808)

670μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 13435) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 13435) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 13435)

590μ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/2665978601999200702163914' limit 1

400μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/2665978601999200702163914
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` = 107866) limit 1

350μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 107866
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=107866

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 = '107866' 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)
)

380μ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 * from `article` where `doi` = '10.2174/1874609816666230816090934' limit 1

380μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/1874609816666230816090934
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` = 133646) limit 1

350μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 133646
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=133646

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 = '133646' 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 = '13156' 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 = '3500' 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)
)

270μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3500) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3500) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3500)

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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13156) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13156) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13156)

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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 133646) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 133646) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 133646)

550μ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/1381612826666200406083035' limit 1

380μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/1381612826666200406083035
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` = 105658) limit 1

340μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 105658
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=105658

580μ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 = '105658' 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)
)

350μ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 * from `article` where `doi` = '10.2174/157340481101150914202014' limit 1

360μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/157340481101150914202014
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` = 70364) limit 1

340μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 70364
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=70364

550μ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 = '70364' 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)
)

300μ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 = '6613' 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)
)

290μ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 = '1606' 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)
)

280μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1606) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1606) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1606)

640μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6613) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6613) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6613)

530μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 70364) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 70364) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 70364)

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/1573406414666171204102633' limit 1

370μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/1573406414666171204102633
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` = 87227) limit 1

330μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 87227
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=87227

560μ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 = '87227' 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)
)

300μ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 = '8334' 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 = '2325' 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)
)

250μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2325) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2325) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2325)

600μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 8334) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 8334) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 8334)

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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 87227) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 87227) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 87227)

480μ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/1874609816666230119125104' limit 1

320μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/1874609816666230119125104
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` = 128942) limit 1

280μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 128942
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=128942

490μ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 = '128942' 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)
)

260μ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 = '12437' 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 = '3385' 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3385) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3385) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3385)

610μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12437) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12437) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12437)

470μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 128942) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 128942) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 128942)

500μ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/1381612825666190115144241' limit 1

340μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/1381612825666190115144241
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` = 95802) limit 1

280μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 95802
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=95802

490μ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 = '95802' 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 = '8944' 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)
)

240μ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 = '2285' 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)
)

590μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2285) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2285) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2285)

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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 8944) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 8944) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 8944)

520μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 95802) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 95802) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 95802)

510μ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/1381612826666200218100420' limit 1

340μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/1381612826666200218100420
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` = 104588) limit 1

290μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 104588
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=104588

490μ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 = '104588' 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 = '9810' 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 = '2790' 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: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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2790) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2790) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2790)

610μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9810) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9810) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9810)

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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 104588) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 104588) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 104588)

480μ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/1381612822666151211094521' limit 1

320μsbetabenthamscien_newArticle.php#128

Bindings	0: 10.2174/1381612822666151211094521
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` = 72456) limit 1

280μsbetabenthamscien_newsearch_data.blade.php#326

Bindings	0: 72456
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=72456

490μ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 = '72456' 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)
)

270μ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 = '6987' 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)
)

260μ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 = '1771' 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: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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1771) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1771) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1771)

620μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6987) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6987) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6987)

490μ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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 72456) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 72456) 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 <= 51362930 and j.to_ip >=51362930 )) and ((j.from_date <= 1744016512 and j.to_date >= 1744016512 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 72456)

490μ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='85a4a724893870b332b8f017b2076ca3'

180μ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: 9Article.php#?
App\Models\Chapter: 1Chapter.php#?

_token: snQhiOCyEkH6yLqjKX0MdZx5mlHlU0UL8mmhk06D
uc_cart_id: 85a4a724893870b332b8f017b2076ca3
_previous: array:1 [ "url" => "https://beta.benthamscience.com/search?searchvalue=%20FONA" ]
_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" => "FONA"
]

request_request

[]

request_headers

  0 of 0   
array:17 [▼
  "x-https" => array:1 [▶
    0 => "1"
  ]
  "host" => array:1 [▶
    0 => "beta.benthamscience.com"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkVrRzBJVkZFMW5Tbis5VGdZR0pQRFE9PSIsInZhbHVlIjoiMmdTV001Zk5YbXJzdXNoY2VuRG0wRzM0OEUrd0xTOU4wSnJOdk5Ic2RnQjAvbURrWmhnOGRUem1nRkFzWGYvM1FnSnZ5azVJUldla3FCcTZQWHJUc1M4S0xxNTdvbmtVbWtHcjZ0TURpYTlpeFc5MlA3ellGdGFSNmltRXBuQ2wiLCJtYWMiOiI3Y2YwZTJhMjMwNzU1NDQ3N2YwMDljMWE2NjcyNmVlNDA0NGIwMzViN2QyYzA2YzM1ZGM1YjIwNTA3NDU4NTYzIiwidGFnIjoiIn0%3D; eurekaselectnew_session=eyJpdiI6InNZNzEvakcwdkJ4NmZvWjNibU0va2c9PSIsInZhbHVlIjoiSkJnU0NYTEU1U2lyNnVWUnNLai9kaUZBMFA3allrZmNLQmFPVHdXOVBjMlhZU1VreU9DKzdKdndOd1B0SGdFdGxIREZuSmd5T3Y5OXR4OE4wUVR4M3BVckZ5TmVsRFhFanoxMUN0VVJxYUtJeCthY3Zxb21ZL0cxU2RKQm03YlIiLCJtYWMiOiI3MjdiMmVkYmNmY2FlYjAyMWJlMDdiYzYwNWM5ZTFlZGMwMWIwNDk1ZDc5NGQ3MTY0ZDk4YzQ4MTg3MTM4ODMxIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IkVrRzBJVkZFMW5Tbis5VGdZR0pQRFE9PSIsInZhbHVlIjoiMmdTV001Zk5YbXJzdXNoY2VuRG0wRzM0OEUrd0xTOU4wSnJOdk5Ic2RnQjAvbURrWmhnOGRUem1nRkFzWGYvM1FnSnZ5a ▶"
  ]
  "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

  0 of 0   
array:2 [▼
  "XSRF-TOKEN" => "snQhiOCyEkH6yLqjKX0MdZx5mlHlU0UL8mmhk06D"
  "eurekaselectnew_session" => "iM9j6hHtmeSwOLiRPAQUW8PCq6kk97Q4p4xb5YRV"
]

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 09:01:52 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IllQbUtlQXl0emdZZTR4UnVPWFVncmc9PSIsInZhbHVlIjoiT1VuYmphVXJtVkRENDlRRTAvVncrRWI0Tkl0dzVaazZCNzBKUTRQdDlrSWorYVh0emVQYXpuenFDbFQzY2dVTHVoNTZwaE8xQXo5ajlGaFk4U2duS0NKd0hlZys2amN1T2tyeTBmNC9XSnI1bFpiQWhVRVAvaElFc0oxM2FlMEgiLCJtYWMiOiI3ODM1M2RmMmEyNjY1MjczNDJmZjZmNTJiYTljZWNiYjcxYzk0YjIwODM3ZTU2YzJiMmYwYmExNGRhNjdmZTA3IiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 21:01:52 GMT; Max-Age=216000; path=/; secure; samesite=strict ◀XSRF-TOKEN=eyJpdiI6IllQbUtlQXl0emdZZTR4UnVPWFVncmc9PSIsInZhbHVlIjoiT1VuYmphVXJtVkRENDlRRTAvVncrRWI0Tkl0dzVaazZCNzBKUTRQdDlrSWorYVh0emVQYXpuenFDbFQzY2dVTHVoNTZwa ▶"
    1 => "eurekaselectnew_session=eyJpdiI6Inh6aGhyTXRRVTZsNFlvVHpkS3lRWkE9PSIsInZhbHVlIjoiMWREUmhqOUJ2S1dHbDNkUDVTckl4am9sU2hGUW1wOVRZajV2Y2pWQTJZdHhnRFBzN3FaVWI4NU9jOHJ1U1RjRGZyQjZWeHhnaU9jelZQWUZTN1lCQXE0ZTkwLzg2RGU5dmh2aTVkUU9BWitxN3cxdFZBUmFRUEk2emgrNzdBcWwiLCJtYWMiOiIwNmNmMTAzYjMwNmU0MDdjZjEzZGY5NjI4YzlkZGQ0ZTQwYjAyMzU0MTNmYTJmYThhY2E3YzU0ZWRkN2IyZWU0IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=strict ◀eurekaselectnew_session=eyJpdiI6Inh6aGhyTXRRVTZsNFlvVHpkS3lRWkE9PSIsInZhbHVlIjoiMWREUmhqOUJ2S1dHbDNkUDVTckl4am9sU2hGUW1wOVRZajV2Y2pWQTJZdHhnRFBzN3FaVWI4NU9jOHJ1 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IllQbUtlQXl0emdZZTR4UnVPWFVncmc9PSIsInZhbHVlIjoiT1VuYmphVXJtVkRENDlRRTAvVncrRWI0Tkl0dzVaazZCNzBKUTRQdDlrSWorYVh0emVQYXpuenFDbFQzY2dVTHVoNTZwaE8xQXo5ajlGaFk4U2duS0NKd0hlZys2amN1T2tyeTBmNC9XSnI1bFpiQWhVRVAvaElFc0oxM2FlMEgiLCJtYWMiOiI3ODM1M2RmMmEyNjY1MjczNDJmZjZmNTJiYTljZWNiYjcxYzk0YjIwODM3ZTU2YzJiMmYwYmExNGRhNjdmZTA3IiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 21:01:52 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IllQbUtlQXl0emdZZTR4UnVPWFVncmc9PSIsInZhbHVlIjoiT1VuYmphVXJtVkRENDlRRTAvVncrRWI0Tkl0dzVaazZCNzBKUTRQdDlrSWorYVh0emVQYXpuenFDbFQzY2dVTHVoNTZwa ▶"
    1 => "eurekaselectnew_session=eyJpdiI6Inh6aGhyTXRRVTZsNFlvVHpkS3lRWkE9PSIsInZhbHVlIjoiMWREUmhqOUJ2S1dHbDNkUDVTckl4am9sU2hGUW1wOVRZajV2Y2pWQTJZdHhnRFBzN3FaVWI4NU9jOHJ1U1RjRGZyQjZWeHhnaU9jelZQWUZTN1lCQXE0ZTkwLzg2RGU5dmh2aTVkUU9BWitxN3cxdFZBUmFRUEk2emgrNzdBcWwiLCJtYWMiOiIwNmNmMTAzYjMwNmU0MDdjZjEzZGY5NjI4YzlkZGQ0ZTQwYjAyMzU0MTNmYTJmYThhY2E3YzU0ZWRkN2IyZWU0IiwidGFnIjoiIn0%3D; path=/; secure; httponly ◀eurekaselectnew_session=eyJpdiI6Inh6aGhyTXRRVTZsNFlvVHpkS3lRWkE9PSIsInZhbHVlIjoiMWREUmhqOUJ2S1dHbDNkUDVTckl4am9sU2hGUW1wOVRZajV2Y2pWQTJZdHhnRFBzN3FaVWI4NU9jOHJ1 ▶"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-07 09:01:52	GET	/search?searchvalue=+FONA	11 7 88 10

Search Result "FONA"

An Update on Airway Management in the Emergency Department

Adverse Effects of Natural Products: A Brief Pre-Systematic Review

Neuropsychiatric Symptoms are Related to Blood-biomarkers in MajorNeurocognitive Disorders

Artemia species: An Important Tool to Screen General Toxicity Samples

Can Group Exercise Programs Improve Health Outcomes in Pregnant Women? A Systematic Review

Activity of Rifabutin and Hemi-synthetic Derivatives Against Mycobacterium abscessus

Behavioral, Sociodemographic, and Sleep Correlates of Symptoms ofDepression amongst Older Brazilian Females According to Age: A Cross-Sectional Network Analysis

Naturally Occurring Plectranthus-derived Diterpenes with Antitumoral Activities

Dietary Amino Acids and Immunonutrition Supplementation in Cancer-Induced Skeletal Muscle Mass Depletion: A Mini-Review

Reactivity of Diterpenoid Quinones: Royleanones.

Apply Filters

Content Type

1 x Application (85.54%)	544ms
1 x Booting (14.46%)	91.96ms