Search Result "Data Extraction"

General Research Article

A Hybrid Data Reduction and Knowledge Extraction Algorithm for Quality Prediction

Journal: Recent Patents on Engineering
Volume: 14 Issue: 2 Year: 2020 Page: 273-280
Author(s): Meng Wang,Shiyuan Zhou,Zhankui Dong,Xiupeng Li

Research Article

A Discriminative Feature Extraction Approach for Tumor Classification Using Gene Expression Data

Journal: Current Bioinformatics
Volume: 11 Issue: 5 Year: 2016 Page: 561-570
Author(s): Qinglin Mei,Huaxiang Zhang,Cheng Liang

Data Mining and Big Data in Medical Imaging

Ebook: Recent Advances in Imaging
Volume: 1 Year: 2018
Author(s): Fuk-hay Tang
Doi: 10.2174/9781681087177118010004

Journey from Data Warehouse to Data Lake

Ebook: Cyber Physical Systems - Advances and Applications
Volume: 1 Year: 2024
Author(s):
Doi: 10.2174/9789815223286124010009

From Data Processing to Multivariate Validation - Essential Steps in Extracting Interpretable Information from Metabolomics Data

Journal: Current Pharmaceutical Biotechnology
Volume: 12 Issue: 7 Year: 2011 Page: 996-1004
Author(s): Mattias Eliasson, Stefan Rannar, Johan Trygg

The Internet, Data Analytics and Big Data

Ebook: Internet Economics: Models, Mechanisms and Management
Volume: 1 Year: 2017
Author(s): Hans W. Gottinger
Doi: 10.2174/9781681085463117010010

Exploring Patterns of Epigenetic Information with Data Mining Techniques

Journal: Current Pharmaceutical Design
Volume: 19 Issue: 4 Year: 2013 Page: 779-789
Author(s): Vanessa Aguiar-Pulido, Jose A. Seoane, Marcos Gestal, Julian Dorado

Extraction of Structure-Activity Relationship Information from High-Throughput Screening Data

Journal: Current Medicinal Chemistry
Volume: 16 Issue: 3 Year: 2009 Page: 4049-4057
Author(s): M. Wawer, J. Bajorath

Data Science and Healthcare

Ebook: Advanced Mathematical Applications in Data Science
Volume: 1 Year: 2023
Author(s):
Doi: 10.2174/9789815124842123010016

Systematic Review Article

Schema Extraction in NoSQL Databases: A Systematic Literature Review

Journal: Recent Advances in Computer Science and Communications
Volume: 17 Issue: 8 Year: 2024 Page: 92-104
Author(s):

Previous   Next

Go To   Results 1 - 1 of 10000

Apply Filters

Volume Years
Article Type
Publication Title
Subject Title

Content Type


© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version1.78sRequest Duration55MBMemory UsageGET search/{searchvalue?}Route
  • warninglog[20:33:17] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
  • warninglog[20:33:17] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
  • warninglog[20:33:17] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
  • warninglog[20:33:17] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
  • warninglog[20:33:17] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
  • warninglog[20:33:17] LOG.warning: str_replace(): Passing null to parameter #3 ($subject) of type array|string ...
  • Booting (452ms)time
  • Application (1.32s)time
  • 1 x Application (74.53%)
    1.32s
    1 x Booting (25.47%)
    452ms
    8 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._header_header.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:346-592
    89 statements were executed849ms
    • Connection Establishedalphaeurekaselec_live_10_06_2022UserAccessCheck.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 ('51271683','',1,1740774796,1740774796) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740774796
      1.33msalphaeurekaselec_live_10_06_2022UserAccessCheck.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 ('51271683','/search?searchvalue=Data+Extraction',1,1740774796,1740774796)
      230μsalphaeurekaselec_live_10_06_2022UserAccessCheck.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 >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) 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 >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) 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 >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) 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 >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) 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 >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) 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 >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) limit 1
      18.71msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51271683
      • 1: 51271683
      • 2: 51271683
      • 3: 51271683
      • 4: 51271683
      • 5: 51271683
      • 6: 51271683
      • 7: 51271683
      • 8: 51271683
      • 9: 51271683
      • 10: 51271683
      • 11: 51271683
      • 12: 51271683
      • 13: 51271683
      • 14: 51271683
      • 15: 51271683
      Backtrace
      • 14. app/Models/UserAccess/UserAccess.php:784
      • 15. middleware::check_user_access:114
      • 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 ('9', '0', '10', '24', '11', '28', '45', '29', '6', '7', '3', '36', '22', '33', '64', '14', '43', '27', '62', '2', '4', '8', '21', '38', '51') order by FIELD(art_type_id, 9,0,10,24,11,28,45,29,6,7,3,36,22,33,64,14,43,27,62,2,4,8,21,38,51)
      570μsalphaeurekaselec_live_10_06_2022Article.php#2038
      Bindings
      • 0: 9
      • 1: 0
      • 2: 10
      • 3: 24
      • 4: 11
      • 5: 28
      • 6: 45
      • 7: 29
      • 8: 6
      • 9: 7
      • 10: 3
      • 11: 36
      • 12: 22
      • 13: 33
      • 14: 64
      • 15: 14
      • 16: 43
      • 17: 27
      • 18: 62
      • 19: 2
      • 20: 4
      • 21: 8
      • 22: 21
      • 23: 38
      • 24: 51
      Backtrace
      • 13. app/Models/Article.php:2038
      • 14. app/Http/Controllers/SearchController.php:454
      • 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 ('25', '29', '38', '33', '32', '66', '1', '18', '57', '65', '48', '118', '8', '6', '15', '35', '19', '30', '7', '56', '59', '179', '13', '23') order by FIELD(journal_id, 25,29,38,33,32,66,1,18,57,65,48,118,8,6,15,35,19,30,7,56,59,179,13,23)
      19.91msalphaeurekaselec_live_10_06_2022Journal.php#1395
      Bindings
      • 0: 25
      • 1: 29
      • 2: 38
      • 3: 33
      • 4: 32
      • 5: 66
      • 6: 1
      • 7: 18
      • 8: 57
      • 9: 65
      • 10: 48
      • 11: 118
      • 12: 8
      • 13: 6
      • 14: 15
      • 15: 35
      • 16: 19
      • 17: 30
      • 18: 7
      • 19: 56
      • 20: 59
      • 21: 179
      • 22: 13
      • 23: 23
      Backtrace
      • 13. app/Models/Journal.php:1395
      • 14. app/Http/Controllers/SearchController.php:486
      • 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', '168', '69', '31', '103', '11', '46', '58', '2', '37', '36', '120', '12', '71', '72', '163', '102', '161', '68', '165', '5', '110', '112', '188', '62') order by FIELD(subject_id, 86,168,69,31,103,11,46,58,2,37,36,120,12,71,72,163,102,161,68,165,5,110,112,188,62)
      10.86msalphaeurekaselec_live_10_06_2022Subject.php#435
      Bindings
      • 0: 86
      • 1: 168
      • 2: 69
      • 3: 31
      • 4: 103
      • 5: 11
      • 6: 46
      • 7: 58
      • 8: 2
      • 9: 37
      • 10: 36
      • 11: 120
      • 12: 12
      • 13: 71
      • 14: 72
      • 15: 163
      • 16: 102
      • 17: 161
      • 18: 68
      • 19: 165
      • 20: 5
      • 21: 110
      • 22: 112
      • 23: 188
      • 24: 62
      Backtrace
      • 13. app/Models/Subject.php:435
      • 14. app/Http/Controllers/SearchController.php:514
      • 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`
      1.08msalphaeurekaselec_live_10_06_2022Subject.php#81
      Backtrace
      • 13. app/Models/Subject.php:81
      • 14. app/Http/Controllers/SearchController.php:531
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as aggregate from `journal` as `j` left join `users` as `u` on `u`.`id` = `j`.`created_by`
      850μsalphaeurekaselec_live_10_06_2022Journal.php#120
      Backtrace
      • 16. app/Models/Journal.php:120
      • 17. app/Http/Controllers/SearchController.php:532
      • 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
      390msalphaeurekaselec_live_10_06_2022Journal.php#120
      Backtrace
      • 14. app/Models/Journal.php:120
      • 15. app/Http/Controllers/SearchController.php:532
      • 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
      35.48msalphaeurekaselec_live_10_06_2022Ebook.php#66
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Ebook.php:66
      • 14. app/Http/Controllers/SearchController.php:533
      • 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/1872212113666190722144214' limit 1
      14.21msalphaeurekaselec_live_10_06_2022Article.php#128
      Bindings
      • 0: 10.2174/1872212113666190722144214
      Backtrace
      • 14. app/Models/Article.php:128
      • 15. view::search_data:133
      • 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` = 99825) limit 1
      840μsalphaeurekaselec_live_10_06_2022search_data.blade.php#164
      Bindings
      • 0: 99825
      Backtrace
      • 16. view::search_data:164
      • 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=99825
      2.26msalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/SearchController.php:623
      • 13. view::search_data:169
      • 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 = '99825' 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) )
      900μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:649
      • 13. view::search_data:169
      • 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 = '10129' 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) )
      460μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:670
      • 13. view::search_data:169
      • 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 = '2752' 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) )
      560μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:692
      • 13. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2752) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2752) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2752)
      3.39msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:729
      • 15. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10129) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10129) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10129)
      3.45msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:754
      • 15. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99825) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99825) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99825)
      1.33msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:786
      • 15. view::search_data:169
      • 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/1574893611666160728114747' limit 1
      3.17msalphaeurekaselec_live_10_06_2022Article.php#128
      Bindings
      • 0: 10.2174/1574893611666160728114747
      Backtrace
      • 14. app/Models/Article.php:128
      • 15. view::search_data:133
      • 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` = 77410) limit 1
      980μsalphaeurekaselec_live_10_06_2022search_data.blade.php#164
      Bindings
      • 0: 77410
      Backtrace
      • 16. view::search_data:164
      • 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=77410
      6.58msalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/SearchController.php:623
      • 13. view::search_data:169
      • 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 = '77410' 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) )
      9.36msalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:649
      • 13. view::search_data:169
      • 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 = '7345' 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) )
      480μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:670
      • 13. view::search_data:169
      • 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 = '1780' 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) )
      440μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:692
      • 13. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1780) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1780) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1780)
      30.25msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:729
      • 15. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 7345) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 7345) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 7345)
      1.44msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:754
      • 15. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 77410) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 77410) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 77410)
      1.49msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:786
      • 15. view::search_data:169
      • 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/9781681087177118010004' limit 1
      10.39msalphaeurekaselec_live_10_06_2022Article.php#128
      Bindings
      • 0: 10.2174/9781681087177118010004
      Backtrace
      • 14. app/Models/Article.php:128
      • 15. view::search_data:133
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • select * from `chapter` where `chapter_id` = '12516' limit 1
      6.88msalphaeurekaselec_live_10_06_2022SearchController.php#858
      Bindings
      • 0: 12516
      Backtrace
      • 16. app/Http/Controllers/SearchController.php:858
      • 17. view::search_data:368
      • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • select count(*) as total_count, content_type_access_id as access_type from ebook_access where content_type_id = '12516' and content_type = 'c' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      550μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:882
      • 13. view::search_data:368
      • 15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(*) as total_count, content_type_access_id as access_type from ebook_access where content_type_id = '2480' 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μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:895
      • 13. view::search_data:368
      • 15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2480) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2480) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2480)
      980μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:935
      • 15. view::search_data:368
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 12516) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 12516) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 12516)
      1.22msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:966
      • 15. view::search_data:368
      • 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/9789815223286124010009' limit 1
      490μsalphaeurekaselec_live_10_06_2022Article.php#128
      Bindings
      • 0: 10.2174/9789815223286124010009
      Backtrace
      • 14. app/Models/Article.php:128
      • 15. view::search_data:133
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • select * from `chapter` where `chapter_id` = '22257' limit 1
      12.69msalphaeurekaselec_live_10_06_2022SearchController.php#858
      Bindings
      • 0: 22257
      Backtrace
      • 16. app/Http/Controllers/SearchController.php:858
      • 17. view::search_data:368
      • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • select count(*) as total_count, content_type_access_id as access_type from ebook_access where content_type_id = '22257' and content_type = 'c' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      10.77msalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:882
      • 13. view::search_data:368
      • 15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(*) as total_count, content_type_access_id as access_type from ebook_access where content_type_id = '3703' 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) )
      450μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:895
      • 13. view::search_data:368
      • 15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3703) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3703) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3703)
      11.29msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:935
      • 15. view::search_data:368
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 22257) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 22257) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 22257)
      1.25msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:966
      • 15. view::search_data:368
      • 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/138920111795909041' limit 1
      500μsalphaeurekaselec_live_10_06_2022Article.php#128
      Bindings
      • 0: 10.2174/138920111795909041
      Backtrace
      • 14. app/Models/Article.php:128
      • 15. view::search_data:133
      • 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` = 18396) limit 1
      460μsalphaeurekaselec_live_10_06_2022search_data.blade.php#164
      Bindings
      • 0: 18396
      Backtrace
      • 16. view::search_data:164
      • 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=18396
      870μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/SearchController.php:623
      • 13. view::search_data:169
      • 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 = '18396' 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μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:649
      • 13. view::search_data:169
      • 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 = '3803' and content_type = 'i' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      440μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:670
      • 13. view::search_data:169
      • 15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '275' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      390μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:692
      • 13. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 275) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 275) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 275)
      31.65msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:729
      • 15. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 3803) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 3803) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 3803)
      900μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:754
      • 15. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 18396) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 18396) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 18396)
      860μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:786
      • 15. view::search_data:169
      • 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/9781681085463117010010' limit 1
      500μsalphaeurekaselec_live_10_06_2022Article.php#128
      Bindings
      • 0: 10.2174/9781681085463117010010
      Backtrace
      • 14. app/Models/Article.php:128
      • 15. view::search_data:133
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • select * from `chapter` where `chapter_id` = '10886' limit 1
      6.71msalphaeurekaselec_live_10_06_2022SearchController.php#858
      Bindings
      • 0: 10886
      Backtrace
      • 16. app/Http/Controllers/SearchController.php:858
      • 17. view::search_data:368
      • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • select count(*) as total_count, content_type_access_id as access_type from ebook_access where content_type_id = '10886' and content_type = 'c' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      440μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:882
      • 13. view::search_data:368
      • 15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(*) as total_count, content_type_access_id as access_type from ebook_access where content_type_id = '2257' 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) )
      440μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:895
      • 13. view::search_data:368
      • 15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2257) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2257) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2257)
      930μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:935
      • 15. view::search_data:368
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 10886) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 10886) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 10886)
      900μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:966
      • 15. view::search_data:368
      • 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/1381612811306040779' limit 1
      11.46msalphaeurekaselec_live_10_06_2022Article.php#128
      Bindings
      • 0: 10.2174/1381612811306040779
      Backtrace
      • 14. app/Models/Article.php:128
      • 15. view::search_data:133
      • 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` = 47927) limit 1
      520μsalphaeurekaselec_live_10_06_2022search_data.blade.php#164
      Bindings
      • 0: 47927
      Backtrace
      • 16. view::search_data:164
      • 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=47927
      930μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/SearchController.php:623
      • 13. view::search_data:169
      • 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 = '47927' 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μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:649
      • 13. view::search_data:169
      • 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 = '4870' 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) )
      480μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:670
      • 13. view::search_data:169
      • 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 = '1131' 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μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:692
      • 13. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1131) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1131) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 1131)
      13.48msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:729
      • 15. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 4870) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 4870) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 4870)
      860μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:754
      • 15. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 47927) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 47927) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 47927)
      890μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:786
      • 15. view::search_data:169
      • 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/092986709789378189' limit 1
      690μsalphaeurekaselec_live_10_06_2022Article.php#128
      Bindings
      • 0: 10.2174/092986709789378189
      Backtrace
      • 14. app/Models/Article.php:128
      • 15. view::search_data:133
      • 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` = 15149) limit 1
      510μsalphaeurekaselec_live_10_06_2022search_data.blade.php#164
      Bindings
      • 0: 15149
      Backtrace
      • 16. view::search_data:164
      • 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=15149
      910μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/SearchController.php:623
      • 13. view::search_data:169
      • 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 = '15149' 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) )
      500μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:649
      • 13. view::search_data:169
      • 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 = '2623' 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) )
      490μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:670
      • 13. view::search_data:169
      • 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 = '218' 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) )
      410μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:692
      • 13. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 218) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 218) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 218)
      2.06msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:729
      • 15. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 2623) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 2623) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 2623)
      840μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:754
      • 15. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 15149) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 15149) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 15149)
      870μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:786
      • 15. view::search_data:169
      • 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/9789815124842123010016' limit 1
      500μsalphaeurekaselec_live_10_06_2022Article.php#128
      Bindings
      • 0: 10.2174/9789815124842123010016
      Backtrace
      • 14. app/Models/Article.php:128
      • 15. view::search_data:133
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • select * from `chapter` where `chapter_id` = '20068' limit 1
      1.36msalphaeurekaselec_live_10_06_2022SearchController.php#858
      Bindings
      • 0: 20068
      Backtrace
      • 16. app/Http/Controllers/SearchController.php:858
      • 17. view::search_data:368
      • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • select count(*) as total_count, content_type_access_id as access_type from ebook_access where content_type_id = '20068' and content_type = 'c' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      430μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:882
      • 13. view::search_data:368
      • 15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • select count(*) as total_count, content_type_access_id as access_type from ebook_access where content_type_id = '3560' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      390μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:895
      • 13. view::search_data:368
      • 15. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 16. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3560) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3560) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3560)
      920μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:935
      • 15. view::search_data:368
      • 17. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 18. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 20068) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 20068) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"chapter" as access_level, j.chapter_id from `user_access_chapter_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 20068)
      850μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:966
      • 15. view::search_data:368
      • 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/0126662558273437231204061106' limit 1
      1.49msalphaeurekaselec_live_10_06_2022Article.php#128
      Bindings
      • 0: 10.2174/0126662558273437231204061106
      Backtrace
      • 14. app/Models/Article.php:128
      • 15. view::search_data:133
      • 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` = 136703) limit 1
      2.59msalphaeurekaselec_live_10_06_2022search_data.blade.php#164
      Bindings
      • 0: 136703
      Backtrace
      • 16. view::search_data:164
      • 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=136703
      4.68msalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/SearchController.php:623
      • 13. view::search_data:169
      • 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 = '136703' 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) )
      760μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:649
      • 13. view::search_data:169
      • 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 = '13507' 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) )
      670μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:670
      • 13. view::search_data:169
      • 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 = '3476' 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.94msalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/SearchController.php:692
      • 13. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3476) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3476) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3476)
      129msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:729
      • 15. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13507) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13507) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 13507)
      880μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:754
      • 15. view::search_data:169
      • 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 136703) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 136703) 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1740774797 and j.to_date >= 1740774797 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 136703)
      1.05msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/SearchController.php:786
      • 15. view::search_data:169
      • 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='03864ea9af79acba2ff0f0c21ba111b9'
      290μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:291
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\Article
    6Article.php#?
    App\Models\Chapter
    4Chapter.php#?
        _token
        eqzCoDy8yMUDwXinNUxACv7hTGzfyhMk9wSvBf9e
        uc_cart_id
        03864ea9af79acba2ff0f0c21ba111b9
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/search?searchvalue=Data%20Extraction" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /search
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        0 of 0
        array:4 [ "searchvalue" => "Data Extraction" "subject" => [] "journal" => [] "ebook" => [] ]
        request_request
        []
        
        request_headers
        0 of 0
        array:17 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6ImpUVyt4Zmd5SkliWG1mdm1TUnJyK0E9PSIsInZhbHVlIjoiRThoYnFmcnRXSDZtOGdqMjVuOWNVNElGQ2pyUFl5R3Fucnl5aCsxTVFRZz0iLCJtYWMiOiIyNGZiNmQxYmQwZWU0Mzk3N2VmNWIxMTAwMGIzY2JlMGIxZGIxMjMwNzhkNGYxNDc1NmM2NTA4ZGJiZjNkYjA3IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6ImpUVyt4Zmd5SkliWG1mdm1TUnJyK0E9PSIsInZhbHVlIjoiRThoYnFmcnRXSDZtOGdqMjVuOWNVNElGQ2pyUFl5R3Fucnl5aCsxTVFRZz0iLCJtYWMiOiIyNGZiNmQxYmQwZWU0" ] "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:1 [ "wayfindertarget" => null ]
        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 => "Fri, 28 Feb 2025 20:33:17 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IisvWlZhNDVncHV5RDlFU1pGSGFNK3c9PSIsInZhbHVlIjoidGMwZnAvaHlpYlpVVjE4WDE0UFEzajczOGFHbFBiQVlvUWFjZW9lVXpaaEYyOTRkSmFJLzJCb0N5K1MwSnNhb1hNOFFLZHM4RXd2K2xEbW1QTlowWnBWc2h3ZnpVVHlVQ2huWjc2NitMQjZtdzBNNzlSUjArVTU4bzQ0WGNJdTgiLCJtYWMiOiIyMmQ0ZmE1NmY2MzVlYTMzZWQzNmQxOWM4MmI1MzhiNDEyY2IwMmMzYjdiYTU2ZmM1ZjMzN2U4ZTIxZWEwNzI5IiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:33:17 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IisvWlZhNDVncHV5RDlFU1pGSGFNK3c9PSIsInZhbHVlIjoidGMwZnAvaHlpYlpVVjE4WDE0UFEzajczOGFHbFBiQVlvUWFjZW9lVXpaaEYyOTRkSmFJLzJCb0N5K1MwSnNhb1hNOFFLZ" 1 => "alphaeurekaselectnet_session=eyJpdiI6InB4SklFcmE2V3BPcUJCc3pXUU1nd2c9PSIsInZhbHVlIjoiSkRTU0VsWW5Ca0lHVXN3YzN4MElIY0ZocHBheWphSDhRUnVocEE0S3NLYnRaUlhUemJtNU1ETnJwNnZ5aSt2elFvYm1udTRwR3dUTU9HS0pIVGU2aGpkUXBjTUFaVHI0U25YOFpoakgwSnFCdU5zNEg2eFdPUkdUd1ZRWnQ0VzYiLCJtYWMiOiJlZDdkYTUzNjVjZWZjODllMGM4NTUyOGI2NzM2ODczZGU4YjczM2RhZjg0MWZkNGM5ZmRmZTUwYzUyYzRkZmE2IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InB4SklFcmE2V3BPcUJCc3pXUU1nd2c9PSIsInZhbHVlIjoiSkRTU0VsWW5Ca0lHVXN3YzN4MElIY0ZocHBheWphSDhRUnVocEE0S3NLYnRaUlhUemJtNU1ETnJ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IisvWlZhNDVncHV5RDlFU1pGSGFNK3c9PSIsInZhbHVlIjoidGMwZnAvaHlpYlpVVjE4WDE0UFEzajczOGFHbFBiQVlvUWFjZW9lVXpaaEYyOTRkSmFJLzJCb0N5K1MwSnNhb1hNOFFLZHM4RXd2K2xEbW1QTlowWnBWc2h3ZnpVVHlVQ2huWjc2NitMQjZtdzBNNzlSUjArVTU4bzQ0WGNJdTgiLCJtYWMiOiIyMmQ0ZmE1NmY2MzVlYTMzZWQzNmQxOWM4MmI1MzhiNDEyY2IwMmMzYjdiYTU2ZmM1ZjMzN2U4ZTIxZWEwNzI5IiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:33:17 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IisvWlZhNDVncHV5RDlFU1pGSGFNK3c9PSIsInZhbHVlIjoidGMwZnAvaHlpYlpVVjE4WDE0UFEzajczOGFHbFBiQVlvUWFjZW9lVXpaaEYyOTRkSmFJLzJCb0N5K1MwSnNhb1hNOFFLZ" 1 => "alphaeurekaselectnet_session=eyJpdiI6InB4SklFcmE2V3BPcUJCc3pXUU1nd2c9PSIsInZhbHVlIjoiSkRTU0VsWW5Ca0lHVXN3YzN4MElIY0ZocHBheWphSDhRUnVocEE0S3NLYnRaUlhUemJtNU1ETnJwNnZ5aSt2elFvYm1udTRwR3dUTU9HS0pIVGU2aGpkUXBjTUFaVHI0U25YOFpoakgwSnFCdU5zNEg2eFdPUkdUd1ZRWnQ0VzYiLCJtYWMiOiJlZDdkYTUzNjVjZWZjODllMGM4NTUyOGI2NzM2ODczZGU4YjczM2RhZjg0MWZkNGM5ZmRmZTUwYzUyYzRkZmE2IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InB4SklFcmE2V3BPcUJCc3pXUU1nd2c9PSIsInZhbHVlIjoiSkRTU0VsWW5Ca0lHVXN3YzN4MElIY0ZocHBheWphSDhRUnVocEE0S3NLYnRaUlhUemJtNU1ETnJ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "eqzCoDy8yMUDwXinNUxACv7hTGzfyhMk9wSvBf9e" "uc_cart_id" => "03864ea9af79acba2ff0f0c21ba111b9" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/search?searchvalue=Data%20Extraction" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:33:17GET/search?searchvalue=Data+Extraction688910