Advance Search | Bentham Science

Messages12 Timeline Exceptions Views7 Route Queries101 Models10 Mails Gate Session Request

Request history8.2.283.63s55MBGET search/{searchvalue?}

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

Booting (90.82ms)time
Application (3.54s)time
1 x Application (97.5%)
3.54s
1 x Booting (2.5%)
90.82ms

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

101 statements were executed, 8 of which were duplicates, 93 unique. Show only duplicated195ms

# Query soft limit for Debugbar is reached after 100 queries, additional 1 queries only show the query. Limit can be raised in the config. Limits can be raised in the config (debugbar.options.db.soft_limit)

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

1.36msbetabenthamscien_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 ('316575447','/search?searchvalue=+GDM',1,1744011746,1744011746)

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

15msbetabenthamscien_newUserAccess.php#784

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

select * from `article_type` where `art_type_id` in ('10', '9', '0', '11', '24', '3', '6', '29', '8', '69') order by FIELD(art_type_id, 10,9,0,11,24,3,6,29,8,69)

590μsbetabenthamscien_newArticle.php#2037

Bindings	0: 10 1: 9 2: 0 3: 11 4: 24 5: 3 6: 6 7: 29 8: 8 9: 69
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 ('10', '40', '59', '29', '25', '58', '18', '12', '14', '17', '23', '35', '70', '156', '1', '11', '13', '15', '19', '30', '33', '47', '56', '78') order by FIELD(journal_id, 10,40,59,29,25,58,18,12,14,17,23,35,70,156,1,11,13,15,19,30,33,47,56,78)

18.31msbetabenthamscien_newJournal.php#1395

Bindings	0: 10 1: 40 2: 59 3: 29 4: 25 5: 58 6: 18 7: 12 8: 14 9: 17 10: 23 11: 35 12: 70 13: 156 14: 1 15: 11 16: 13 17: 15 18: 19 19: 30 20: 33 21: 47 22: 56 23: 78
Backtrace	13. app/Models/Journal.php:1395 14. app/Http/Controllers/SearchController.php:493 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

select * from `subject` where `subject_id` in ('86', '11', '168', '62', '187', '69', '59', '170', '103', '2', '31', '46', '65', '58', '112', '120', '181', '3', '102', '5', '36', '110', '188', '6', '7') order by FIELD(subject_id, 86,11,168,62,187,69,59,170,103,2,31,46,65,58,112,120,181,3,102,5,36,110,188,6,7)

740μsbetabenthamscien_newSubject.php#433

Bindings	0: 86 1: 11 2: 168 3: 62 4: 187 5: 69 6: 59 7: 170 8: 103 9: 2 10: 31 11: 46 12: 65 13: 58 14: 112 15: 120 16: 181 17: 3 18: 102 19: 5 20: 36 21: 110 22: 188 23: 6 24: 7
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`

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

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

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

8.35msbetabenthamscien_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/1573399815666190712193828' limit 1

660μsbetabenthamscien_newArticle.php#128

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

440μsbetabenthamscien_newsearch_data.blade.php#326

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

960μ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 = '99591' 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)
)

520μ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 = '9860' 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)
)

400μ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 = '2714' 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)
)

340μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2714) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2714) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2714)

990μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9860) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9860) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9860)

620μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99591) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99591) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99591)

1.03msbetabenthamscien_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/157339911794940738' limit 1

500μsbetabenthamscien_newArticle.php#128

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

440μsbetabenthamscien_newsearch_data.blade.php#326

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

870μ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 = '18304' 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)
)

670μ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 = '3905' 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)
)

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

460μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 76) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 76) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 76)

1.47msbetabenthamscien_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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 3905) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 3905) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 3905)

790μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 18304) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 18304) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 18304)

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

560μsbetabenthamscien_newArticle.php#128

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

470μsbetabenthamscien_newsearch_data.blade.php#326

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

730μ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 = '131247' 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)
)

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

400μ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 = '3337' 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3337) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3337) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3337)

920μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12822) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12822) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12822)

2.83msbetabenthamscien_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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 131247) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 131247) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 131247)

910μ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/1573399817666210219124628' limit 1

610μsbetabenthamscien_newArticle.php#128

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

420μsbetabenthamscien_newsearch_data.blade.php#326

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

700μ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 = '114393' 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)
)

440μ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 = '11334' 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)
)

350μ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 = '3130' 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)
)

350μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3130) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3130) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3130)

990μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11334) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11334) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11334)

630μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 114393) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 114393) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 114393)

780μ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/1573399812666160919100253' limit 1

490μsbetabenthamscien_newArticle.php#128

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

480μsbetabenthamscien_newsearch_data.blade.php#326

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

610μsbetabenthamscien_newArticle.php#408

Backtrace

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

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

350μ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 = '2027' 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)
)

430μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2027) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2027) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2027)

1.03msbetabenthamscien_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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 7943) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 7943) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 7943)

780μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 78391) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 78391) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 78391)

780μ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/157340111795713898' limit 1

1.05msbetabenthamscien_newArticle.php#128

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

440μsbetabenthamscien_newsearch_data.blade.php#326

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

750μ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 = '33060' 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)
)

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

360μ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 = '317' 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)
)

360μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 317) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 317) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 317)

940μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 4115) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 4115) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 4115)

780μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 33060) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 33060) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 33060)

780μ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/1573404815666190128155057' limit 1

510μsbetabenthamscien_newArticle.php#128

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

460μsbetabenthamscien_newsearch_data.blade.php#326

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

800μ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 = '96182' 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)
)

470μ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 = '9434' 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)
)

400μ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 = '2526' 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2526) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2526) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2526)

1.03msbetabenthamscien_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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9434) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9434) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9434)

660μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96182) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96182) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96182)

760μ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/157340111795713861' limit 1

500μsbetabenthamscien_newArticle.php#128

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

480μsbetabenthamscien_newsearch_data.blade.php#326

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

840μ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 = '33058' 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)
)

460μ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 = '4115' 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)
)

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

400μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 317) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 317) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 317)

950μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 4115) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 4115) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 4115)

740μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 33058) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 33058) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 33058)

710μ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/1570164617666190822125837' limit 1

690μsbetabenthamscien_newArticle.php#128

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

440μsbetabenthamscien_newsearch_data.blade.php#326

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

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

430μsbetabenthamscien_newContentAccess.php#647

Backtrace

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

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

320μ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 = '2666' 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)
)

1.17msbetabenthamscien_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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2666) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2666) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2666)

1.02msbetabenthamscien_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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9669) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9669) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9669)

780μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100403) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100403) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100403)

760μ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/1573399819666220613154802' limit 1

470μsbetabenthamscien_newArticle.php#128

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

400μsbetabenthamscien_newsearch_data.blade.php#326

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

770μ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 = '124414' 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)
)

410μ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 = '11630' 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)
)

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

470μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3304) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3304) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3304)

1.06msbetabenthamscien_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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11630) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11630) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11630)

830μ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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 124414) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 124414) 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 <= 316575447 and j.to_ip >=316575447 )) and ((j.from_date <= 1744011746 and j.to_date >= 1744011746 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 124414)

810μ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='6fea7ca884c3b4c99d889ac3d78fdea9'
270μsbetabenthamscien_new

App\Models\Article: 10Article.php#?

_token: okSEdTkehLX2VW1u8IlhSZCykY8NyeKBSDAioS3C
uc_cart_id: 6fea7ca884c3b4c99d889ac3d78fdea9
_previous: array:1 [ "url" => "https://beta.benthamscience.com/search?searchvalue=%20GDM" ]
_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" => "GDM"
]

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=eyJpdiI6IjUzUVdCaEhDZE1LLzlhRmtTdFVIeUE9PSIsInZhbHVlIjoiVkZRR2xwUVpZdVFmdjVlRkxwb2RGMVJsSk1RMG1Ycmt1NGhoQytwb1E4ZWI5Q0NObW9ZM0dEM210MWN4d1AybWZCNVlqQ3RWeFB3RFNIZHdvczE1Nms5K3U2cDgvMmRXUWZoQXpOMjRKZmxZQi9naGJyc2Z4WTFCRCtNU0xEWnQiLCJtYWMiOiJmNDlkMjcwYzExZmMxMmZmOTVmMjcxMDkzZmMzNzFlODQwMTBhNGM4MmRjMGViNzhhZmQwMWNlNDA1MzM2NzFlIiwidGFnIjoiIn0%3D; eurekaselectnew_session=eyJpdiI6ImNDV1oralkxaGY4RjhDR2xvVnB2bVE9PSIsInZhbHVlIjoiUDE0V1drdkpaeDkzS3lFdmtVOXQ5UDhDSEVhZVdzZ3JvR09Dc2tXbXkrM2dOR2FJRGtvM1JGOWUrbUlnc1IxZE1Mc0tzb1hycGRWSVU0bENXdEtTZnpUVnVOb2dLZ3l6MGVraEg3b2dwdk9TREZVMGFFSDR0N0VMQzJnR09QTnYiLCJtYWMiOiIzZWE3ZjY1NmZhYTQxYzExN2Q3Mjk1MzlkODdjYWVjNTBkNTc1ZWE1OGI0NmI1MjRjOTA0ZGM4NzAwNjQyMmJhIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6IjUzUVdCaEhDZE1LLzlhRmtTdFVIeUE9PSIsInZhbHVlIjoiVkZRR2xwUVpZdVFmdjVlRkxwb2RGMVJsSk1RMG1Ycmt1NGhoQytwb1E4ZWI5Q0NObW9ZM0dEM210MWN4d1AybWZCNVlqQ ▶"
  ]
  "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" => "okSEdTkehLX2VW1u8IlhSZCykY8NyeKBSDAioS3C"
  "eurekaselectnew_session" => "iuYNdFEmb44ZFsbLSwTTqcQZZWeyl4eHuBqcVExo"
]

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 07:42:26 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkVtalJYbDdJdUloT1czVnhDVHlGS3c9PSIsInZhbHVlIjoiZzk0T0dEbjA5RDZwWUgrZGFpSmdYeEdNR09TK0FDSDRvaDNrS1o2MlVXWWZpY3kvb2ZFOUtkS2V5Z2Nuc1o2eDJmaFpZRHZ1S3pvMDBIV2NKSGxYVmNHN0c2SDNtTlhQZXJzNGJTYXB5ZU9KRkNXVFY2Nkp4d1R6WE5GVzhsTWoiLCJtYWMiOiJkNWRhODgxYTYyMTA2Y2EwMDY3YWQ5MmFkMTYyNzU4MjM1Yzk0N2U0N2NhMGE5ZmNiZGY5MGVlYTMzODUzYTljIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 19:42:26 GMT; Max-Age=216000; path=/; secure; samesite=strict ◀XSRF-TOKEN=eyJpdiI6IkVtalJYbDdJdUloT1czVnhDVHlGS3c9PSIsInZhbHVlIjoiZzk0T0dEbjA5RDZwWUgrZGFpSmdYeEdNR09TK0FDSDRvaDNrS1o2MlVXWWZpY3kvb2ZFOUtkS2V5Z2Nuc1o2eDJmaFpZR ▶"
    1 => "eurekaselectnew_session=eyJpdiI6ImdiS3hEclR1T3REanEweUVkdThFZUE9PSIsInZhbHVlIjoiN0NqN2t0OUF3UFYvaW9iNVJDRVpwckIyNXZDczBPZlJjd2NPOCtjYkx2dW5EK0x1Y3liOHZ5VmFwOVRnTjRVdmZwbHd1V3RHZEI4K1habngxQzZaQ2swOVUwaXF3NTYzSGo0cjUvK3JjYUJsdGVUREpUQnFxdyswalYyMGNxWmoiLCJtYWMiOiIzNjM1Y2UyMTEyYWFkNWJmNmE0MDcyOTYxMWJhMDNlM2Q1ZGQwYmZkZWE3OTM3NGRmMjVjYjkyMTE4YjYyNDQ0IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=strict ◀eurekaselectnew_session=eyJpdiI6ImdiS3hEclR1T3REanEweUVkdThFZUE9PSIsInZhbHVlIjoiN0NqN2t0OUF3UFYvaW9iNVJDRVpwckIyNXZDczBPZlJjd2NPOCtjYkx2dW5EK0x1Y3liOHZ5VmFwOVRn ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkVtalJYbDdJdUloT1czVnhDVHlGS3c9PSIsInZhbHVlIjoiZzk0T0dEbjA5RDZwWUgrZGFpSmdYeEdNR09TK0FDSDRvaDNrS1o2MlVXWWZpY3kvb2ZFOUtkS2V5Z2Nuc1o2eDJmaFpZRHZ1S3pvMDBIV2NKSGxYVmNHN0c2SDNtTlhQZXJzNGJTYXB5ZU9KRkNXVFY2Nkp4d1R6WE5GVzhsTWoiLCJtYWMiOiJkNWRhODgxYTYyMTA2Y2EwMDY3YWQ5MmFkMTYyNzU4MjM1Yzk0N2U0N2NhMGE5ZmNiZGY5MGVlYTMzODUzYTljIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 19:42:26 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkVtalJYbDdJdUloT1czVnhDVHlGS3c9PSIsInZhbHVlIjoiZzk0T0dEbjA5RDZwWUgrZGFpSmdYeEdNR09TK0FDSDRvaDNrS1o2MlVXWWZpY3kvb2ZFOUtkS2V5Z2Nuc1o2eDJmaFpZR ▶"
    1 => "eurekaselectnew_session=eyJpdiI6ImdiS3hEclR1T3REanEweUVkdThFZUE9PSIsInZhbHVlIjoiN0NqN2t0OUF3UFYvaW9iNVJDRVpwckIyNXZDczBPZlJjd2NPOCtjYkx2dW5EK0x1Y3liOHZ5VmFwOVRnTjRVdmZwbHd1V3RHZEI4K1habngxQzZaQ2swOVUwaXF3NTYzSGo0cjUvK3JjYUJsdGVUREpUQnFxdyswalYyMGNxWmoiLCJtYWMiOiIzNjM1Y2UyMTEyYWFkNWJmNmE0MDcyOTYxMWJhMDNlM2Q1ZGQwYmZkZWE3OTM3NGRmMjVjYjkyMTE4YjYyNDQ0IiwidGFnIjoiIn0%3D; path=/; secure; httponly ◀eurekaselectnew_session=eyJpdiI6ImdiS3hEclR1T3REanEweUVkdThFZUE9PSIsInZhbHVlIjoiN0NqN2t0OUF3UFYvaW9iNVJDRVpwckIyNXZDczBPZlJjd2NPOCtjYkx2dW5EK0x1Y3liOHZ5VmFwOVRn ▶"
  ]
]

session_attributes

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

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-07 07:42:26	GET	/search?searchvalue=+GDM	12 7 101 10

Search Result "GDM"

Prevention of Gestational Diabetes Mellitus (GDM) and Probiotics: Mechanism of Action: A Review

Strategies for Diabetes Prevention Before and After Pregnancy in Women with GDM

Periostin Acts as a Bridge between Gestational Diabetes Mellitus (GDM)and Chronic Inflammation to Modulate Insulin Resistance by ModulatingPPARα/NF-κB/TNF-α Signaling Pathway

GST T1, M1, and IRS-1 G972R Genetic Variants Association to Gestational Diabetes Mellitus (GDM) in Egyptian Women: Linkage to Maternal Hyperglycemia

Soluble (Pro) Renin Receptor is a Predictor of Gestational Diabetes Mellitus

Dietary Management of Gestational Diabetes Mellitus

Improved Insulin Resistance through Cajanus cajan extract in Gestational Diabetes Mellitus of Wistar Rat

History of Development of the Diagnostic Criteria for Gestational Diabetes Mellitus in Japan and the HAPO Study

Upregulated Retinol Binding Protein and Transthyretin as Predictive Biomarkers of Gestational Diabetes Mellitus

Current Practice and Controversies in Screening for Gestational Diabetes

Apply Filters

Content Type

1 x Application (97.5%)	3.54s
1 x Booting (2.5%)	90.82ms