Advance Search | Bentham Science

Messages6 Timeline Exceptions Views7 Route Queries53 Models5 Mails Gate Session Request

Request history8.2.28437ms53MBGET search/{searchvalue?}

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

Booting (91.04ms)time
Application (346ms)time
1 x Application (79.18%)
346ms
1 x Booting (20.82%)
91.04ms

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

53 statements were executed108ms

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

1.1msbetabenthamscien_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 ('51408323','/search?searchvalue=FliT',1,1744013002,1744013002)

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

9.34msbetabenthamscien_newUserAccess.php#784

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

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

420μsbetabenthamscien_newArticle.php#2037

Bindings	0: 0 1: 9 2: 10
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 ('70', '115') order by FIELD(journal_id, 70,115)

1.35msbetabenthamscien_newJournal.php#1395

Bindings	0: 70 1: 115
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 ('5', '12', '16', '118', '158', '163', '168', '183', '185', '186') order by FIELD(subject_id, 5,12,16,118,158,163,168,183,185,186)

290μsbetabenthamscien_newSubject.php#433

Bindings	0: 5 1: 12 2: 16 3: 118 4: 158 5: 163 6: 168 7: 183 8: 185 9: 186
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`

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

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

71.23msbetabenthamscien_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

5.89msbetabenthamscien_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/2210327909666190409114926' limit 1

360μsbetabenthamscien_newArticle.php#128

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

300μsbetabenthamscien_newsearch_data.blade.php#326

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

600μ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 = '97946' 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 count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '10427' 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)
)

280μ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 = '3014' 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013002 and j.to_date >= 1744013002 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3014) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013002 and j.to_date >= 1744013002 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3014) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013002 and j.to_date >= 1744013002 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3014)

730μsbetabenthamscien_newUserAccess.php#1266

Backtrace

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

(select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text,
CASE j.type WHEN 111 THEN true ELSE false END as terms_popup,
"S" as content_download_type,
null as restricted_user_access_key,
null as restricted_user_access_type,
CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id  from `user_access_issue_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where  ((j.from_ip <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013002 and j.to_date >= 1744013002 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10427) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013002 and j.to_date >= 1744013002 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10427) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013002 and j.to_date >= 1744013002 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10427)

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

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

310μsbetabenthamscien_newArticle.php#128

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

300μsbetabenthamscien_newsearch_data.blade.php#326

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

520μ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 = '32348' 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 = '3722' 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 = '1063' 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013002 and j.to_date >= 1744013002 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1063) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013002 and j.to_date >= 1744013002 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1063) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013002 and j.to_date >= 1744013002 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1063)

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

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

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

310μsbetabenthamscien_newArticle.php#128

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

290μsbetabenthamscien_newsearch_data.blade.php#326

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

500μ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 = '92518' 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 = '8694' 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 = '2492' 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013002 and j.to_date >= 1744013002 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2492) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013002 and j.to_date >= 1744013002 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2492) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013002 and j.to_date >= 1744013002 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2492)

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

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

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

280μsbetabenthamscien_newArticle.php#128

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

220μsbetabenthamscien_newSearchController.php#856

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

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

550μ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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013003 and j.to_date >= 1744013003 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 15874) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013003 and j.to_date >= 1744013003 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 15874) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013003 and j.to_date >= 1744013003 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 15874)

530μ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/138920111798281009' limit 1

300μsbetabenthamscien_newArticle.php#128

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

270μsbetabenthamscien_newsearch_data.blade.php#326

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

510μ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 = '19891' 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 = '3796' 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 = '275' 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013003 and j.to_date >= 1744013003 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 275) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013003 and j.to_date >= 1744013003 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 275) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013003 and j.to_date >= 1744013003 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 275)

590μ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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013003 and j.to_date >= 1744013003 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 3796) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013003 and j.to_date >= 1744013003 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 3796) 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 <= 51408323 and j.to_ip >=51408323 )) and ((j.from_date <= 1744013003 and j.to_date >= 1744013003 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 3796)

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

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 count(*) as aggregate from `uc_cart_products` where cart_id='673d6fb6f83a63b72f777a9ffb308375'

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

_token: 8knkAiJA8OJnrD6NnFVlqWk9ZwqXruCVIXeIlDrd
uc_cart_id: 673d6fb6f83a63b72f777a9ffb308375
_previous: array:1 [ "url" => "https://beta.benthamscience.com/search?searchvalue=FliT" ]
_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" => "FliT"
]

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=eyJpdiI6ImY2SG1ZY0lCKzc3Mld2WnIzUnVMUHc9PSIsInZhbHVlIjoidTFiOEhsT2hLTDA1VlhxODBYcFp4SklteE5PMlRPWHZKTlNUUm1IUkVXaU40TzRJQVc3OTg0OFMyUGQrcGJtTklYM2hWZ1ZxbFc5ZXdvVzZPYldvQjdkUWhDUXZyWEErc2dDRWJGWE92eFVDWFFRUlFjVDRCdDZxdUxYL0FSUmkiLCJtYWMiOiIyMTE0MjdjYzdmN2RhYjdlM2NjMmQyMGFmNWI4NWYxZDlkOTU0ZDE3YzA0ZmQyZTdjZDdlMDRiNWY0MWM0MDEwIiwidGFnIjoiIn0%3D; eurekaselectnew_session=eyJpdiI6IkdKN01GWHo3NGFIWU00bG9CcEZDckE9PSIsInZhbHVlIjoiejVia3RzVXl5d3JFUWZ1anppaTlQdEFMcWJadXRPUWtwNllYZnBPSDB6aDhCazl1Mm90OXYvL2w4NlFTK2d2bUNZNjE1Um5LRzRCOFVBU29JSUpsRUFaV0NGRTR6ZllLSmdUeVJCa2hRNHVNWjZaalh2ZjY5TExDczkvTHZaOWsiLCJtYWMiOiI0OTZjZmEwN2U0ZjNjMTEzYmNjYmEzNjNkYzVjNmI4YzE4NGJhMzQ4ZjAwNDhjMWFlZjAxOTJkZDVhNGRmY2ZhIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6ImY2SG1ZY0lCKzc3Mld2WnIzUnVMUHc9PSIsInZhbHVlIjoidTFiOEhsT2hLTDA1VlhxODBYcFp4SklteE5PMlRPWHZKTlNUUm1IUkVXaU40TzRJQVc3OTg0OFMyUGQrcGJtTklYM2hWZ ▶"
  ]
  "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" => "8knkAiJA8OJnrD6NnFVlqWk9ZwqXruCVIXeIlDrd"
  "eurekaselectnew_session" => "YcV2wsUau1HHKU0jcjKRMYosYs1IqYoxXxyDQq0T"
]

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 08:03:22 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9tQTBRNlVWTFNwWmNpTWVjNU5JN2c9PSIsInZhbHVlIjoiZlZXbUtadkFqTlV1T2hNS0RVaU1UT1lZMWZTWVFJcmNJMEc0aEdJUG5oMGdSdW10VTdmQU1wMGtxWkk3VHkzOU13d096UVBWYWRqNmxRdXNzczF6aDlKbzdxZkZHZEZFNllhc2ZSWlZLd01MTkE4RVY0STFIOW92QjU3Slp3U2EiLCJtYWMiOiJhYzNlNWFiNmRkNTM2OGRmNWUxMGRmZTI2MDQ5NGUzZDkyNWUwYjdmM2Y0MjhkYzI0YTJiNWQ2NTU2YjI1ZThiIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 20:03:23 GMT; Max-Age=216000; path=/; secure; samesite=strict ◀XSRF-TOKEN=eyJpdiI6Im9tQTBRNlVWTFNwWmNpTWVjNU5JN2c9PSIsInZhbHVlIjoiZlZXbUtadkFqTlV1T2hNS0RVaU1UT1lZMWZTWVFJcmNJMEc0aEdJUG5oMGdSdW10VTdmQU1wMGtxWkk3VHkzOU13d096U ▶"
    1 => "eurekaselectnew_session=eyJpdiI6IkFCbUl5VVdnZUJMM3NPTW5FczBQOWc9PSIsInZhbHVlIjoiWmo3Vk5IVU9WTUh4UU01clJDdVJwLzBzb1ZGSWJzazJNUmJCcm9iVXZwOHBjUXJjYlNMOG01ZWtJK1lkVG44OWQwRnZKbmlSMXhyTEs1dERQeXhzczMzQy82WGpCU09aZGNZR3p1UU16eUlDT1JPSEN5aWRLdEFTd2dqVGdlZ1giLCJtYWMiOiJmYWVhNTVhZmRkMDMwMTlhZmU0NWI4YTU1N2NkMTkwZGQ1YWUzNjA5M2I4MTRmZGUzYjQyZGVmM2M5ZmQ1NGFmIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=strict ◀eurekaselectnew_session=eyJpdiI6IkFCbUl5VVdnZUJMM3NPTW5FczBQOWc9PSIsInZhbHVlIjoiWmo3Vk5IVU9WTUh4UU01clJDdVJwLzBzb1ZGSWJzazJNUmJCcm9iVXZwOHBjUXJjYlNMOG01ZWtJK1lk ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9tQTBRNlVWTFNwWmNpTWVjNU5JN2c9PSIsInZhbHVlIjoiZlZXbUtadkFqTlV1T2hNS0RVaU1UT1lZMWZTWVFJcmNJMEc0aEdJUG5oMGdSdW10VTdmQU1wMGtxWkk3VHkzOU13d096UVBWYWRqNmxRdXNzczF6aDlKbzdxZkZHZEZFNllhc2ZSWlZLd01MTkE4RVY0STFIOW92QjU3Slp3U2EiLCJtYWMiOiJhYzNlNWFiNmRkNTM2OGRmNWUxMGRmZTI2MDQ5NGUzZDkyNWUwYjdmM2Y0MjhkYzI0YTJiNWQ2NTU2YjI1ZThiIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 20:03:23 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Im9tQTBRNlVWTFNwWmNpTWVjNU5JN2c9PSIsInZhbHVlIjoiZlZXbUtadkFqTlV1T2hNS0RVaU1UT1lZMWZTWVFJcmNJMEc0aEdJUG5oMGdSdW10VTdmQU1wMGtxWkk3VHkzOU13d096U ▶"
    1 => "eurekaselectnew_session=eyJpdiI6IkFCbUl5VVdnZUJMM3NPTW5FczBQOWc9PSIsInZhbHVlIjoiWmo3Vk5IVU9WTUh4UU01clJDdVJwLzBzb1ZGSWJzazJNUmJCcm9iVXZwOHBjUXJjYlNMOG01ZWtJK1lkVG44OWQwRnZKbmlSMXhyTEs1dERQeXhzczMzQy82WGpCU09aZGNZR3p1UU16eUlDT1JPSEN5aWRLdEFTd2dqVGdlZ1giLCJtYWMiOiJmYWVhNTVhZmRkMDMwMTlhZmU0NWI4YTU1N2NkMTkwZGQ1YWUzNjA5M2I4MTRmZGUzYjQyZGVmM2M5ZmQ1NGFmIiwidGFnIjoiIn0%3D; path=/; secure; httponly ◀eurekaselectnew_session=eyJpdiI6IkFCbUl5VVdnZUJMM3NPTW5FczBQOWc9PSIsInZhbHVlIjoiWmo3Vk5IVU9WTUh4UU01clJDdVJwLzBzb1ZGSWJzazJNUmJCcm9iVXZwOHBjUXJjYlNMOG01ZWtJK1lk ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "8knkAiJA8OJnrD6NnFVlqWk9ZwqXruCVIXeIlDrd"
  "uc_cart_id" => "673d6fb6f83a63b72f777a9ffb308375"
  "_previous" => array:1 [▶
    "url" => "https://beta.benthamscience.com/search?searchvalue=FliT"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-07 08:03:23	GET	/search?searchvalue=FliT	6 7 53 5

Search Result "FliT"

An Adaptive Fault-Tolerant and Congestion Controlled Selection Strategy for Networks on Chip

Bacterial Secretion Chaperones

Chaperone-Assisted Secretion in Bacteria: Protein and DNA Transport via Cell Membranes

Advances in Nanotherapeutic Agents

On the Involvement of H2S in Nitroso Signaling and Other Mechanisms of H2S Action

Apply Filters

Content Type

1 x Application (79.18%)	346ms
1 x Booting (20.82%)	91.04ms