Advance Search | Bentham Science

Messages7 Timeline Exceptions Views7 Route Queries86 Models10 Mails Gate Session Request

Request history8.2.28639ms54MBGET search/{searchvalue?}

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

Booting (113ms)time
Application (525ms)time
1 x Application (82.24%)
525ms
1 x Booting (17.76%)
113ms

7 templates were rendered

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

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

86 statements were executed179ms

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

1.2msbetabenthamscien_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 ('316381173','/search?searchvalue=+paddy',1,1744019914,1744019914)

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

14.21msbetabenthamscien_newUserAccess.php#784

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

420μsbetabenthamscien_newArticle.php#2037

Bindings	0: 0 1: 9 2: 10 3: 11 4: 21
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 ('35', '118', '160', '6', '7', '15', '18', '19', '25', '34', '50', '57', '65', '73', '76', '78', '128', '210') order by FIELD(journal_id, 35,118,160,6,7,15,18,19,25,34,50,57,65,73,76,78,128,210)

11.98msbetabenthamscien_newJournal.php#1395

Bindings	0: 35 1: 118 2: 160 3: 6 4: 7 5: 15 6: 18 7: 19 8: 25 9: 34 10: 50 11: 57 12: 65 13: 73 14: 76 15: 78 16: 128 17: 210
Backtrace	13. app/Models/Journal.php:1395 14. app/Http/Controllers/SearchController.php:493 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `subject` where `subject_id` in ('2', '113', '31', '110', '153', '1', '12', '86', '135', '36', '112', '149', '7', '46', '106', '118', '136', '168', '13', '14', '94', '103', '154', '5', '11') order by FIELD(subject_id, 2,113,31,110,153,1,12,86,135,36,112,149,7,46,106,118,136,168,13,14,94,103,154,5,11)

590μsbetabenthamscien_newSubject.php#433

Bindings	0: 2 1: 113 2: 31 3: 110 4: 153 5: 1 6: 12 7: 86 8: 135 9: 36 10: 112 11: 149 12: 7 13: 46 14: 106 15: 118 16: 136 17: 168 18: 13 19: 14 20: 94 21: 103 22: 154 23: 5 24: 11
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`

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

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

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

7.23msbetabenthamscien_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/9789815136531123010018' limit 1

430μsbetabenthamscien_newArticle.php#128

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

260μsbetabenthamscien_newSearchController.php#856

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

360μ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 = '3488' 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: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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3488) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3488) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3488)

5.9msbetabenthamscien_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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 19046) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 19046) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 19046)

1.12msbetabenthamscien_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/9789811801631121010004' limit 1

470μsbetabenthamscien_newArticle.php#128

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

320μsbetabenthamscien_newSearchController.php#856

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

380μ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 = '3053' 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)
)

370μ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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3053) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3053) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3053)

6.59msbetabenthamscien_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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 14676) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 14676) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 14676)

1.06msbetabenthamscien_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/1573407215666181213162132' limit 1

520μsbetabenthamscien_newArticle.php#128

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

460μsbetabenthamscien_newsearch_data.blade.php#326

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

850μ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 = '95233' 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)
)

450μ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 = '9823' 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)
)

420μ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 = '2725' 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)
)

390μ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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2725) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2725) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2725)

1.07msbetabenthamscien_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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9823) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9823) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9823)

820μ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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 95233) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 95233) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 95233)

770μ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/9789815305098124010007' limit 1

350μsbetabenthamscien_newArticle.php#128

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

260μsbetabenthamscien_newSearchController.php#856

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

300μ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 = '3787' 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3787) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3787) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3787)

3.9msbetabenthamscien_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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 23520) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 23520) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 23520)

720μ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/9789815040340122020013' limit 1

470μsbetabenthamscien_newArticle.php#128

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

250μsbetabenthamscien_newSearchController.php#856

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

300μ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 = '3371' and content_type = 'v'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)

300μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php: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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3371) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3371) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3371)

3.99msbetabenthamscien_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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 17293) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 17293) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 17293)

720μ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/1567201812666150422163531' limit 1

370μsbetabenthamscien_newArticle.php#128

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

400μsbetabenthamscien_newsearch_data.blade.php#326

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

620μ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 = '66731' 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 count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '6516' and content_type = 'i'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)

330μsbetabenthamscien_newContentAccess.php#647

Backtrace

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

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

390μ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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1589) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1589) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1589)

750μ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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6516) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6516) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 6516)

590μ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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 66731) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 66731) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 66731)

600μsbetabenthamscien_newUserAccess.php#1266

Backtrace

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

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

340μsbetabenthamscien_newArticle.php#128

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

250μsbetabenthamscien_newSearchController.php#856

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

310μ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 = '3666' and content_type = 'v'
and
(
(from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or
(from_date is null and to_date is null and perpetual= 1)
)

310μsbetabenthamscien_newContentAccess.php#647

Backtrace

11. app/Models/ContentAccess.php:647
12. app/Http/Controllers/SearchController.php: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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3666) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3666) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3666)

5.66msbetabenthamscien_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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 21585) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 21585) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 21585)

930μ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/2211352512666140714175749' limit 1

400μsbetabenthamscien_newArticle.php#128

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

330μsbetabenthamscien_newsearch_data.blade.php#326

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

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 = '61392' 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 = '5879' 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 = '1360' 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)
)

370μ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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1360) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1360) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1360)

750μ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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 5879) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 5879) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 5879)

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

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

400μsbetabenthamscien_newArticle.php#128

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

380μsbetabenthamscien_newsearch_data.blade.php#326

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

620μ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 = '129253' 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 count(*) as total_count, content_type_access_id as access_type from journal_access
where content_type_id = '12611' 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 = '3395' 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3395) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3395) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3395)

710μ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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12611) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12611) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12611)

560μ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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 129253) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 129253) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 129253)

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

390μsbetabenthamscien_newArticle.php#128

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

330μsbetabenthamscien_newsearch_data.blade.php#326

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

540μ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 = '130043' 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)
)

310μ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 = '12883' 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 = '3469' 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3469) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3469) 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 <= 316381173 and j.to_ip >=316381173 )) and ((j.from_date <= 1744019915 and j.to_date >= 1744019915 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3469)

690μsbetabenthamscien_newUserAccess.php#1266

Backtrace

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

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

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

580μsbetabenthamscien_newUserAccess.php#1266

Backtrace

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

select count(*) as aggregate from `uc_cart_products` where cart_id='5f4e8f055c946cd0f4d642e9bcadba3a'

210μ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\Chapter: 5Chapter.php#?
App\Models\Article: 5Article.php#?

_token: mThVzg78jSQEqguhzYjGlU2ItisFv1s08z2g3to1
uc_cart_id: 5f4e8f055c946cd0f4d642e9bcadba3a
_previous: array:1 [ "url" => "https://beta.benthamscience.com/search?searchvalue=%20paddy" ]
_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" => "paddy"
]

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=eyJpdiI6IjFsTXVMWVM2WlJoZmxpU3M0ZnBZemc9PSIsInZhbHVlIjoiS1lMTzBxcTNBWG1oYzhmSGN5a3JrZVI1ZC9mSVpidlAxdkpUaHRwWVRISnVTazFWM01FMkJhVi81Z0hJa2JXUEpmNkVRUnptdTJHRXBreDVvMzE4eHF5RGJkUWYydDcyc1BKZ3dyRTFKcjBBRGk1V3F1UzduOXEzdGVQaUdqMzMiLCJtYWMiOiI5YmEzNWVmYjc2YjE5YTgyNGJhODY0OWMwMzRkOGIyNGViYWU1NWNhYWYzMTFjMDk2NDAzMDVkNTgzYmYxMTA0IiwidGFnIjoiIn0%3D; eurekaselectnew_session=eyJpdiI6IjBLblhFUmdPazZwd0xoNkhwb0twZnc9PSIsInZhbHVlIjoiOVVRTTN5eXlFdGc1QXlZTldUUGhLeGJHUDZkei9seTMwZHdyb3FLNEMyY1RZVnZyMEhjSkc2K3FQbU51N1NIdWhlT293UWdrcmlMQ0V5OEQwYlZFL2JBY25wZWxPRTBDVmFlUE9qdmduRXdLUjBETERESG5QK2dSdE16bTVKTHgiLCJtYWMiOiIzN2UzMDY0ZDEyNzAxNWZjNDQ1Zjc3OTkxY2U3MDQ3NzkyYzU0MzkyN2E2NWFjNWVhMmUyNDJlOTRkNmIwYjAzIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IjFsTXVMWVM2WlJoZmxpU3M0ZnBZemc9PSIsInZhbHVlIjoiS1lMTzBxcTNBWG1oYzhmSGN5a3JrZVI1ZC9mSVpidlAxdkpUaHRwWVRISnVTazFWM01FMkJhVi81Z0hJa2JXUEpmNkVRU ▶"
  ]
  "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" => "mThVzg78jSQEqguhzYjGlU2ItisFv1s08z2g3to1"
  "eurekaselectnew_session" => "G0xZx6f6Yxyvaa4P0Mif5s97CkTm3k6rxe5v4hhH"
]

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:58:35 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikw0NTNSYnlnbGV1TUhmWGNNak9KU3c9PSIsInZhbHVlIjoiajJWQWVRL0ZWVUF6N2luQUJYcWsrc0R2RVpMVGVnYlpSdUlNNFl2c2lxdHB1WUxaQklTWFBWK2lLZWwrWnhnSHVza292SGxYYU56NkdOeko1SEVUT2ROckE1Vmp4ZmdxRS9qVC9NNld2QXRMSDdDTGo4cFVweUxJTkg2dGpiZDIiLCJtYWMiOiJmZWIzOTUzODU0NzM3YmMzY2VhZjZkMzFjZWQ1MDJkMWI5MWVjOTkzMWZiOTJlZmY2NzhhMTdmNjc1OTcyZjZhIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 21:58:35 GMT; Max-Age=216000; path=/; secure; samesite=strict ◀XSRF-TOKEN=eyJpdiI6Ikw0NTNSYnlnbGV1TUhmWGNNak9KU3c9PSIsInZhbHVlIjoiajJWQWVRL0ZWVUF6N2luQUJYcWsrc0R2RVpMVGVnYlpSdUlNNFl2c2lxdHB1WUxaQklTWFBWK2lLZWwrWnhnSHVza292S ▶"
    1 => "eurekaselectnew_session=eyJpdiI6IkNuUmlZaU9rMllEbThNZ3c3RG1LOVE9PSIsInZhbHVlIjoieVBGZ0VSUFRyRURRVldlb1BnanpHV014YTRFMUNLQWRzbTExZ3FVVVY1VUtoWUtHZnlHVXBhd3JCSS9sdHNHam1PKzdLM0lMcEpEZS9PdzFlYVBKbW9nbndmSERzL2E5WkV1QlJvQXBoL1lGRTk3eE9LTWUxQU42UnlKN0tFU0YiLCJtYWMiOiI1YWIzZWI4ZWJjMmRjZjkyZTc1YmNkN2RlNDY3YzE4YWJiNzgwM2MzYzVlMGQ5YzBjZmNjNjkzNTNjNjgzMmIzIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=strict ◀eurekaselectnew_session=eyJpdiI6IkNuUmlZaU9rMllEbThNZ3c3RG1LOVE9PSIsInZhbHVlIjoieVBGZ0VSUFRyRURRVldlb1BnanpHV014YTRFMUNLQWRzbTExZ3FVVVY1VUtoWUtHZnlHVXBhd3JCSS9s ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikw0NTNSYnlnbGV1TUhmWGNNak9KU3c9PSIsInZhbHVlIjoiajJWQWVRL0ZWVUF6N2luQUJYcWsrc0R2RVpMVGVnYlpSdUlNNFl2c2lxdHB1WUxaQklTWFBWK2lLZWwrWnhnSHVza292SGxYYU56NkdOeko1SEVUT2ROckE1Vmp4ZmdxRS9qVC9NNld2QXRMSDdDTGo4cFVweUxJTkg2dGpiZDIiLCJtYWMiOiJmZWIzOTUzODU0NzM3YmMzY2VhZjZkMzFjZWQ1MDJkMWI5MWVjOTkzMWZiOTJlZmY2NzhhMTdmNjc1OTcyZjZhIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 21:58:35 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Ikw0NTNSYnlnbGV1TUhmWGNNak9KU3c9PSIsInZhbHVlIjoiajJWQWVRL0ZWVUF6N2luQUJYcWsrc0R2RVpMVGVnYlpSdUlNNFl2c2lxdHB1WUxaQklTWFBWK2lLZWwrWnhnSHVza292S ▶"
    1 => "eurekaselectnew_session=eyJpdiI6IkNuUmlZaU9rMllEbThNZ3c3RG1LOVE9PSIsInZhbHVlIjoieVBGZ0VSUFRyRURRVldlb1BnanpHV014YTRFMUNLQWRzbTExZ3FVVVY1VUtoWUtHZnlHVXBhd3JCSS9sdHNHam1PKzdLM0lMcEpEZS9PdzFlYVBKbW9nbndmSERzL2E5WkV1QlJvQXBoL1lGRTk3eE9LTWUxQU42UnlKN0tFU0YiLCJtYWMiOiI1YWIzZWI4ZWJjMmRjZjkyZTc1YmNkN2RlNDY3YzE4YWJiNzgwM2MzYzVlMGQ5YzBjZmNjNjkzNTNjNjgzMmIzIiwidGFnIjoiIn0%3D; path=/; secure; httponly ◀eurekaselectnew_session=eyJpdiI6IkNuUmlZaU9rMllEbThNZ3c3RG1LOVE9PSIsInZhbHVlIjoieVBGZ0VSUFRyRURRVldlb1BnanpHV014YTRFMUNLQWRzbTExZ3FVVVY1VUtoWUtHZnlHVXBhd3JCSS9s ▶"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-07 09:58:35	GET	/search?searchvalue=+paddy	7 7 86 10

Search Result "paddy"

Discernment of Paddy Crop Disease by Employing CNN and Transfer Learning Methods of Deep Learning

Use of Banana Plant Pseudo-stem Juice as the Substitute for Muriate of Potash in Agriculture: Application in the Cultivation of Rice

Synthesis and Biological Activity of Triclopyr Derivatives Containing the Pyridine Group

An Integrated Approach to the Control of Weeds in Rice Fields

Mushroom Cultivation Using Agricultural Wastes

Production of Î² -cyclodextrin from pH and Thermo Stable Cyclodextrin Glycosyl Transferase, Obtained from Arthrobacter mysorens and Its Evaluation as a Drug Carrier for Irbesartan

Inoculation of Plant Growth-Promoting Bacteria Aiming to Improve Rice Tolerance to Abiotic Stressful Conditions

Antibacterial and Antioxidant Property of Streptomyces cinnamonensis VITNS1 Isolated from Serkadu Region, Vellore, Tamil Nadu, India

Urinary MicroRNA Analysis Indicates an Epigenetic Regulation of ChronicKidney Disease of Unknown Etiology in Sri Lanka

Trace Element Levels in Rice Varieties Consumed in Saudi Arabia

Apply Filters

Content Type

1 x Application (82.24%)	525ms
1 x Booting (17.76%)	113ms