Generic placeholder image

Current Pharmaceutical Biotechnology

Editor-in-Chief

ISSN (Print): 1389-2010
ISSN (Online): 1873-4316

Research Article

Separation, Characterization and Discriminant Analysis of Subvisible Particles in Biologics Formulations

Author(s): Zahir S. Akhunzada*, Mario Hubert, Erinc Sahin and James Pratt

Volume 20, Issue 3, 2019

Page: [232 - 244] Pages: 13

DOI: 10.2174/1389201020666190214100840

Price: $65

Abstract

Background: The presence of subvisible particles (SVPs) in parenteral formulations of biologics is a major challenge in the development of therapeutic protein formulations. Distinction between proteinaceous and non-proteinaceous SVPs is vital in monitoring formulation stability.

Methods: The current compendial method based on light obscuration (LO) has limitations in the analysis of translucent/low refractive index particles. A number of attempts have been made to develop an unambiguous method to characterize SVPs, albeit with limited success.

Results: Herein, we describe a robust method that characterizes and distinguishes both potentially proteinaceous and non-proteinaceous SVPs in protein formulations using Microflow imaging (MFI) in conjunction with the MVAS software (MFI View Analysis Suite), developed by ProteinSimple. The method utilizes two Intensity parameters and a morphological filter that successfully distinguishes proteinaceous SVPs from non-proteinaceous SVPs and mixed aggregates.

Conclusion: The MFI generated raw data of a protein sample is processed through Lumetics LINK software that applies an in-house developed filter to separate proteinaceous from the rest of the particulates.

Keywords: Protein aggregation, proteinaceous particles, non-proteinaceous particles, subvisible particles, MFI, MVAS, lumetics link, discriminant analysis.

Graphical Abstract

[1]
Garven, J.M. Gunner, B.W. The harmful effects of particles in intravenous fluids. Med. J. Aust., 1964, 2(1), 1-6.
[2]
Carpenter, J.F.; Randolph, T.W.; Jiskoot, W.; Crommlin, D.J.A.; Middaugh, C.R.; Winter, G.; Fan, Y.X.; Kirshner, S.; Verthelyi, D.; Koslowski, S.; Clouse, K.A.; Swann, P.G.; Rosenberg, A.; Cherney, B. Overlooking subvisible particles, in therapeutic protein products: Gaps that may compromise product quality. J. Pharm. Sci., 2009, 98(4), 1201-1205.
[3]
Das, T.K. Protein particulate detection issues in bio-therapeutics development - current status. AAPS PharmSciTech, 2012, 13(2), 732-746.
[4]
Lehr, H.A.; Brunner, J.; Rangoonwala, R.; Kirkpatrick, C.J. Particulate matter contamination of intravenous antibiotics aggravates loss of functional capillary density in post-ischemic striated muscle. Am. J. Respir. Care Med, 2002, 165, 514-520.
[5]
Groves, M.J. Particulate contamination in parenterals: Current issues. Boll. Chim. Farmaceutico Anno, 1991, 130, 347-354.
[6]
Narhi, L.O.; Corvari, V.; Ripple, D.C.; Nataliya, A.; Cecchini, I.; Defelippis, M.R.; Garidel, P.; Herre, A.; Koulov, A.; Lubiniecki, T.; Mahler, H.C.; Mangiagalli, P.; Nesta, D.; Perez-Ramerez, B.; Polozava, A.; Rossi, M.; Schmidt, R.; Simler, R.; Singh, S.; Spitznagel, T.; Weiskopf, A.; Wuchner, K. Subvisible (2-100 mm) particle analysis during biotherapeutic drug product development: Part 1, Considerations and strategy. J. Pharm. Sci., 2015, 104(6), 1899-1908.
[7]
James, D.E.; Jenkins, A.B.; Kraegen, E.W.; Chisholm, D.J. Insulin precipitation in artificial infusion devices. Diabetologia, 1981, 21, 554-557.
[8]
Insigler, K.; Kirtz, H. Longterm continuous intravenous insulin therapy with a portable insulin dosage -regulating apparatus. Diabetes, 1979, 28, 196-203.
[9]
Warne, N.W. Development of high concentration protein biopharmaceuticals: The use of the plateform approaches in formulation development. Eur. J. Biopharm, 2011, 78, 202-212.
[10]
Schellekens, H. Immunogenicity of therapeutic proteins. Nephro. Dial., 2003, 18, 1257-1259.
[11]
Schellekens, H. Factors influencing the immunogenicity of therapeutic proteins. Nephro. Dial, 2005, 20, vi3-vi9.
[12]
Carpenter, J.; Cherney, B.; Lubinecki, A.; Ma, S.; Marszal, E.; Mire-Sluis, A.; Nikolai, T.; Novak, J.; Ragheb, J.; Simak, J. Meeting report on protein particles and immunogenicity of therapeutic proteins: Filling in the gaps in risk evaluation and mitigation. Biologicals, 2010, 38, 602-611.
[13]
van Beers, M.M.C.; Sauerborn, M.; Gilli, F.; Brinks, V.; Shellekens, H.; Jiskoot, W. Aggregated recombinant human interferon Beta induces antibodies but no memory in immune-tolerant transgenic mice. Pharm. Res., 2010, 27, 1812-1824.
[14]
van Beers, M.M.C.; Gilli, F.V.; Shellekens, H.; Randolph, T.W.; Jiskoot, W. Immunogenicity of recombinant human interferon beta interacting with particles of glass, metal, and polystyrene. J. Pharm. Sci., 2012, 101(1), 187-199.
[15]
Jiang, Y.; Nashed-Samuel, Y.; Li, C.; Liu, W.; Pollastrinin, J.; Mallard, D.; Zai-Qing, W.; Fujimori, K.; Pallitto, M.; Donahue, L.; Chu, G.; Torraca, G.; Vance, A.; Mitre-Sluis, T.; Freund, E.; Davis, J.; Narhi, L. Tungsten-induced aggregation: Solution behavior. J. Pharm. Sci., 2009, 98(12), 4695-4710.
[16]
Kumar, S.; Singh, S.K.; Wang, X.; Rup, B.; Gill, D. Coupling of aggregation and immunogenicity in biotherapeutics: T- and B-Cell immune epitopes may contain aggregation - prone regions. Pharm. Res., 2011, 28, 949-961.
[17]
Fradkin, A.H.; Carpenter, J.F.; Randolph, T.W. Glass particles as an adjuvant: A model for adverse immunogenicity of therapeutic proteins. J. Pharm. Sci., 2011, 100(11), 4953-4964.
[18]
Rosenberg, A.S. Effect of protein aggregates: An immunologic perspective. AAPS J., 2006, 8, E501-E507.
[19]
Rosenberg, A.S.; Verthelyi, D.; Cherney, B.W. Managing uncertainity: A perspective on risk pertaining to product quality attributes as they bear on immunogenicity of therapeutic proteins. J. Pharm. Sci., 2012, 101(10), 35603567.
[20]
Narhi, L.O.; Schmit, J.; Bechtold-Peters, K.; Sharma, D. Classification of protein aggregates. J. Pharm. Sci., 2012, 101(2), 493-498.
[21]
Current USP General Chapter <788>. Particulate Matter in Injections.
[22]
Current USP General Chapter <787>. Subvisible Particulate Matter in Protein Therapeutic Injections.
[23]
Current USP General Chapter <789>. Particulate Matter in Opthalmic Solutions.
[24]
Zolls, S.; Tantipolphan, R.; Wiggenhorn, M.; Winter, G.; Jiskoot, W.; Friess, W.; Hawe, A. Particles in therapeutic protein formulations, part 1: Overview of analytical methods. J. Pharm. Sci., 2012, 101(3), 914-935.
[25]
Felsovalyi, F.; Janvier, S.; Jouffray, S.; Soukiassian, H.; Mangiagalli, P. Silicone-oil-based subvisible particles: Their detection, interactions, and regulation in prefilled container closure systems for biopharmaceuticals. J. Pharm. Sci., 2012, 101(12), 4569-4583.
[26]
Demeule, B.; Messick, S.; Shire, S.J.; Liu, J. Characterization of particles in protein solutions: Reaching the limits of current technologies. AAPS J., 2010, 12(4), 708-714.
[27]
Jones, L.S.; Kaufmann, A.; Middaugh, C.R. Silicone oil aggregation of proteins. J. Pharm. Sci., 2005, 94(4), 918-927.
[28]
Zolls, S.; Gregoritza, M.; Tantipolphan, R.; Wiggenhorn, M.; Winter, G.; Friess, W.; Hawe, A. How subvisible particles become invisible - relevance of the refractive index for protein analysis. J. Pharm. Sci., 2013, 102(5), 1434-1446.
[29]
Weinbuch, D.; Zolls, S.; Wiggenhorn, M.; Friess, W.; Winter, G.; Jiskoot, W.; Hawe, A. Micro-flow imaging and resonant mass measurement (Archimedes) - complementary methods to quantitatively differentiate protein particles and silicone oil droplets. J. Pharm. Sci., 2013, 102(5), 1434-1446.
[30]
Wuchner, K.; Buchler, J.; Spycher, R.; Dalmonte, P.; Volken, D.B. Development of a microflow digital imaging assay to characterize protein particulates during storage of a high concentration Ig G1 monoclonal antibody formulation. J. Pharm. Sci., 2010, 99(8), 3343-3361.
[31]
Telikepalli, S.N.; Kumru, O.S.; Kalonia, C.; Esfandiary, R.; Joshi, S.B.; Middaugh, C.R.; Volkin, D.B. Structural characterization of IgG1 mAb aggregates and particles generated under various stress conditions. J. Pharm. Sci., 2014, 103, 796-809.
[32]
Simler, B.R.; Guodong, H.; Jennifer, E.D.; Perez-Ramirez, B. Mechanistic complexity of subvisible particle formation: Links to protein aggregation are highly specific. J. Pharm. Sci., 2012, 101(11), 4140-4154.
[33]
Sharma, D.K.; King, D.; Oma, P.; Merchant, C. Micro flow imaging: Flow microscopy applied to subvisible particulate analysis in protein formulations. AAPS J., 2010, 12(3), 455-464.
[34]
Sharma, D.K.; King, D.; Oma, P.; Pollo, M.J.; Sukumar, M. Quantitation and characterization of subvisible proteinaceous particles in opalescent mAb formulations using micro flow imaging, Micro flow imaging. J. Pharm. Sci., 2009, 99(6), 2628-2642.
[35]
Huang, C-T.; Sharma, D.; Oma, P.; Krishnamurty, R. Quantitation of protein particles in parenteral solutions using micro flow imaging. J. Pharm. Sci., 2008, 98(9), 3058-3070.
[36]
Ripple, D.C.; Dimitrova, M.N. Protein particles: What we know and what we do not know. J. Pharm. Sci., 2012, 101(10), 3568-3579.
[37]
James, G.; Bernard, S.S.; Theodore, W.; Randolph, J.; Carpenter, F. Subvisible particle counting provides a sensitive method of detecting and quantifying aggregation of monoclonal antibody caused by freeze-thawing: Insights into the roles of particles in the protein aggregation pathway. J. Pharm. Sci., 2011, 100(2), 492-503.
[38]
Singh, S.K.; Afonina, N.; Awwad, M.; Bechtold-Peters, K.; Blue, J.T.; Chou, D.; Cromwell, M.; Krause, H.J.; Mahler, H.C.; Meyer, B.K.; Narhi, L.; Nesta, P.D.; Spitznagel, T. An Industry perspective on the monitoring of subvisible particles as a quality attribute for protein therapeutics. J. Pharm. Sci., 2010, 99(8), 3302-3321.
[39]
Traban, M.B.; Truong, H.C.; Feng, Y.; Jouravleva, E.V.; Anisimov, M.A.; Yu, Y.B. Water proton NMR for in situ detection of insulin aggregates. J. Pharm. Sci., 2015, 104, 4132-4141.
[40]
Mach, H.; Middaugh, C.R. Ultraviolet spectroscopy as a tool in therapeutic protein development. J. Pharm. Sci., 2010, 100(4), 1214-1227.
[41]
Strehl, R.; Rombach-Riegraf, V.; Diez, M.; Egodage, K.; Bluemel, M.; Jeschke, M.; Koulov, A.V. Discrimination between silicone oil droplets and protein aggregates in biopharmaceuticals: A novel multiparametric image filter for sub-visible particles in microflow imaging analysis. Pharm. Res., 2012, 29, 594-604.
[42]
Philo, J.S. Is any measurement method optimal for all aggregate sizes and types. AAPS J., 2006, 8(3), E564-E571.
[43]
Joubert, M.K.; Luo, Q.; Nashed-Samuel, Y.; Wypych, J.; Narhi, L.O. Classification and characterization of therapeutic antibody aggregates. J. Biochem., 2011, 286(28), 25118-25133.
[44]
Bai, K.; Barnett, G.V.; Kar, S.R.; Das, T.K. Interference from proteins and surfactants on particle size distributions measured by nanoparticle tracking analysis. Pharm. Res., 2017, 34, 800-808.
[45]
Filipe, V.; Hawe, A.; Jiskoot, W. Critical evaluation of nanoparticle tracking analysis (nta) by nanosight for the measurement of nanoparticles and protein aggregates. Pharm. Res., 2010, 27(5), 796-810.
[46]
Patel, A.R.; Lau, D.; Liu, J. Quantification and characterization of micrometer and submicrometer sibvisible particles in protein therapeutics by use of a suspended microchannel resonator. Anal. Chem., 2012, 84, 6833-6840.
[47]
Khodabandehloo, A.; Chen, D.D.Y. Particles sizing method for the detection of protein aggregates in biopharmaceuticals. Bioanalysis, 2017, 9(3), 313-326.
[48]
Lorber, B.; Fischer, F.; Bailly, M.; Roy, H.; Kern, D. Protein analysis by dynamic light scattering: Methods and techniques for students. Biochem. Mol. Biol. Educ., 2012, 40(6), 372-382.
[49]
Sharma, D.; Oma, P.; Krishnan, S. Silicone-micro-droplets in protein formulations-detection and enumeration. Pharm. Technol., 2009, 33(4), 74-79.
[50]
Sharma, D.; King, D.; Oma, P.; Merchant, C. Micro-flow imaging: Flow microscopy applied to sub-visible particulate analysis in protein formulations. AAPS J., 2010, 12(3), 455-464.
[51]
MFI View Analysis Suite, (MVAS), version 4.1. Software manufactured by ProteinSimple; Bio-techne, 2015.
[52]
Eriksson, L.; Byrne, T.; Johansson, E.; Trygg, J.; Vikstrom, C. Multi- and megavariate data analysis, Basic principles and applications; Umetric Academy Malmo: Sweden, 2013.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version327msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[08:49:51] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[08:49:51] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[08:49:51] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (133ms)time
  • Application (194ms)time
  • 1 x Application (59.31%)
    194ms
    1 x Booting (40.69%)
    133ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.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 article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    36 statements were executed, 4 of which were duplicates, 32 unique. Show only duplicated101ms
    • 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 ('309791667','',1,1740473391,1740473391) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740473391
      950μsalphaeurekaselec_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 ('309791667','/article/96641',1,1740473391,1740473391)
      190μ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 >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) 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 >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) 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 >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) 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 >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) 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 >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) 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 >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 309791667 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309791667) limit 1
      12.59msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 309791667
      • 1: 309791667
      • 2: 309791667
      • 3: 309791667
      • 4: 309791667
      • 5: 309791667
      • 6: 309791667
      • 7: 309791667
      • 8: 309791667
      • 9: 309791667
      • 10: 309791667
      • 11: 309791667
      • 12: 309791667
      • 13: 309791667
      • 14: 309791667
      • 15: 309791667
      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 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=96641
      660μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 30 limit 1
      870μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 30
      Backtrace
      • 14. app/Models/Journal.php:64
      • 15. app/Http/Controllers/ArticleController.php:2516
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=30) and sj.journal_id!=30 group by `j`.`nid`) as `aggregate_table`
      1.04msalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=30) and sj.journal_id!=30 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      880μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=30) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.97msalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 16. app/Models/Subject.php:220
      • 17. app/Http/Controllers/ArticleController.php:2518
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=30) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      1.34msalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 14. app/Models/Subject.php:220
      • 15. app/Http/Controllers/ArticleController.php:2518
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `keywords` where `article_id` = '96641'
      870μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 96641
      Backtrace
      • 13. app/Models/Keywords.php:43
      • 14. app/Http/Controllers/ArticleController.php:2519
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `article_citation` where `article_id` = '96641'
      3.54msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 96641
      Backtrace
      • 13. app/Models/Article.php:1570
      • 14. app/Http/Controllers/ArticleController.php:2520
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select CONCAT_WS(' ',au.first_name, ' ', ifnull(au.initials,''), ' ', au.last_name) as authors, CONCAT(au.last_name, IFNULL(CONCAT(' ', au.initials), ''), ' ', au.first_name) AS authorsRIS, CONCAT_WS(' ',au.last_name, ' ', ifnull(au.initials,''), ' ', au.first_name) as authorsCiteAs, CONCAT_WS(' ',au.first_name, IFNULL(CONCAT(' ', au.initials), ''), IFNULL(CONCAT(' ', au.last_name), '')) as authorsmodal , `au`.*, `af`.`ror_id`, `af`.`institution`, `af`.`department`, `af`.`country`, `af`.`city`, `af`.`address`, (GROUP_CONCAT(TRIM(BOTH ', ' FROM CONCAT(ifnull(concat(af.institution,','),''), ifnull(concat(af.department,','),''), ifnull(concat(af.address,','),''), ifnull(concat(af.city,','),''), ifnull(concat(af.country,','),''), ifnull(concat(af.postal_code,','),''), ifnull(concat(af.phone,','),''), ifnull(concat(af.fax,','),''))) SEPARATOR '|')) as `author_affiliation`, (GROUP_CONCAT(TRIM(BOTH ', ' FROM CONCAT(ifnull(concat(af.web_view,','),''))) SEPARATOR '|')) as `web_view` from `author` as `au` left join `author_affiliation` as `af` on `au`.`author_id` = `af`.`author_id` where `au`.`article_id` = '96641' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.33msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 96641
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      220μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      470μsalphaeurekaselec_live_10_06_2022Article.php#1960
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1960
      • 14. app/Http/Controllers/ArticleController.php:2062
      • 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 j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j join volume v on j.journal_id = v.journal_id join issue i on v.volume_id = i.volume_id join article a on a.issue_id = i.issue_id join year y on v.year_id = y.id where j.journal_id = 30 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      26.5msalphaeurekaselec_live_10_06_2022Issue.php#298
      Backtrace
      • 11. app/Models/Issue.php:298
      • 12. app/Http/Controllers/ArticleController.php:2068
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 1 and a.journal_id = 30 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      12.48msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2070
      • 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 a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 30 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      11.99msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2071
      • 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 pdf, html, epub, prc from `article_metrics` where `article_id` = 96641 limit 1
      280μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 96641
      Backtrace
      • 14. app/Models/Article.php:744
      • 15. app/Http/Controllers/ArticleController.php:2091
      • 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 content_by_diseases where content_id = 96641 and content_type = 'article' order by status desc limit 1
      330μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 169973 limit 1
      240μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 169973
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 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 `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      280μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 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 `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CPB' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      380μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CPB
      Backtrace
      • 13. app/Models/Article.php:2025
      • 14. app/Http/Controllers/ArticleController.php:2112
      • 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 total_count, content_type_access_id as access_type from journal_access where content_type_id = '96641' and content_type = 'a' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      430μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2186
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '9061' and content_type = 'i' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      400μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '2587' 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/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740473391 and j.to_date >= 1740473391 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2587) 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740473391 and j.to_date >= 1740473391 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2587) 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740473391 and j.to_date >= 1740473391 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2587)
      12.69msalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2272
      • 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 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740473391 and j.to_date >= 1740473391 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9061) 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740473391 and j.to_date >= 1740473391 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9061) 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740473391 and j.to_date >= 1740473391 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9061)
      610μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2297
      • 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 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740473391 and j.to_date >= 1740473391 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96641) 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740473391 and j.to_date >= 1740473391 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96641) 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 <= 309791667 and j.to_ip >=309791667 )) and ((j.from_date <= 1740473391 and j.to_date >= 1740473391 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 96641)
      580μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2329
      • 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 `first_page` < '232' and is_uploaded = 1 and issue_id = 9061 order by cast(first_page as SIGNED) desc limit 1
      520μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 232
      Backtrace
      • 14. app/Models/Article.php:1819
      • 15. app/Http/Controllers/ArticleController.php:2470
      • 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 `article` where `last_page` > '244' and is_uploaded = 1 and issue_id = 9061 order by cast(first_page as SIGNED) asc limit 1
      440μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 244
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 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 `language_id` from `multilanguage` where `short_code` = 'en'
      180μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 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
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      200μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 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 `id` from `multilanguage_article` where `article_id` = 96641 limit 1
      2.37msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 96641
      Backtrace
      • 16. app/Http/Controllers/ArticleController.php:2506
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select b.banner_link, b.banner_name, b.banner_script, b.banner_remarks, b.banner_file_name, b.banner_placement, bd.content_type, bd.content_id from `tbl_banner` as `b` inner join `tbl_banner_detail` as `bd` on `bd`.`banner_id` = `b`.`banner_id` inner join `users` as `u` on `u`.`id` = `b`.`updated_by` inner join `journal` as `j` on `j`.`journal_id` = `bd`.`content_id` where `b`.`banner_journal` = 1 and `bd`.`content_type` = 'J' and `bd`.`content_id` = 30 and `b`.`banner_from_date` <= 1740473391 and `b`.`banner_to_date` >= 1740473391 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.16msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 30
      • 3: 1740473391
      • 4: 1740473391
      • 5: A
      Backtrace
      • 13. app/Models/Banner.php:95
      • 14. app/Http/helpers.php:404
      • 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 b.banner_link, b.banner_name, b.banner_script, b.banner_remarks, b.banner_file_name, b.banner_placement, bd.content_type, bd.content_id from `tbl_banner` as `b` inner join `tbl_banner_detail` as `bd` on `bd`.`banner_id` = `b`.`banner_id` inner join `users` as `u` on `u`.`id` = `b`.`updated_by` inner join `journal` as `j` on `j`.`journal_id` = `bd`.`content_id` where `b`.`banner_journal` = 1 and `bd`.`content_type` = 'J' and `bd`.`content_id` = 30 and `b`.`banner_from_date` <= 1740473391 and `b`.`banner_to_date` >= 1740473391 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.11msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 30
      • 3: 1740473391
      • 4: 1740473391
      • 5: A
      Backtrace
      • 13. app/Models/Banner.php:95
      • 14. app/Http/helpers.php:404
      • 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 count(*) as aggregate from `uc_cart_products` where cart_id='599131d5e7b2427d70999b2a1e438bcd'
      200μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 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\MultiLanguage
    1MultiLanguage.php#?
        _token
        Q1bcbZSQXxtXPpIxrnSEGBtJdtX7zkcgyPgll7Rv
        uc_cart_id
        599131d5e7b2427d70999b2a1e438bcd
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/96641" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/96641
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6ImxIZUd6R2s1MGxNaERsZER3ZW51bkE9PSIsInZhbHVlIjoiemwyQXdERStwMG5sblhqVzdYMGh4MUxaZ28xUk9Fak44bk1Cdkx1bFpPUT0iLCJtYWMiOiIzYmM3NDBkZTIwNGZiNmE2Njc0OWFkZDZmYWQ0MjM3OGIyNWQ5MGFiZTcyOWRmZDI4MWRjYmYxNjY1MzRiN2Q4IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6ImxIZUd6R2s1MGxNaERsZER3ZW51bkE9PSIsInZhbHVlIjoiemwyQXdERStwMG5sblhqVzdYMGh4MUxaZ28xUk9Fak44bk1Cdkx1bFpPUT0iLCJtYWMiOiIzYmM3NDBkZTIwNGZi" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "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" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        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 => "Tue, 25 Feb 2025 08:49:51 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Iit4UmkzNkJ5Um95dFB1Tk1ma0d0amc9PSIsInZhbHVlIjoiTS8rNG9qMHVzZWIxcElkY3ZOQzc5ZmFjV2RZc3QzaHhEV2Nud1Frd3AzcDVJYisxc3JtSUcwUFIzelVGRmR2VG5GOXhZQjFGTDJxV3p3ejRYc2VYWWtDWkJuRER5Rlk4V3hGTVlSMzFwMXhHZHQzSjJLdStnOGRKaWZkTDhVdCsiLCJtYWMiOiI3NTRmZWU3NTc1YjZjYzI4NjdiZDQ0N2FhNmRmNzQ4MDM1YWNkY2Q0NjMzN2E5Y2JmYTM0NzNkMmE5MmMzMjYzIiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 20:49:51 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Iit4UmkzNkJ5Um95dFB1Tk1ma0d0amc9PSIsInZhbHVlIjoiTS8rNG9qMHVzZWIxcElkY3ZOQzc5ZmFjV2RZc3QzaHhEV2Nud1Frd3AzcDVJYisxc3JtSUcwUFIzelVGRmR2VG5GOXhZQ" 1 => "alphaeurekaselectnet_session=eyJpdiI6Imx6eHFmcmUyNkJUNzZuTk5ycXMwckE9PSIsInZhbHVlIjoiNk5GOVdsRVpnZDhYWW5ISFhkWnpZeFFwRzVBUkMyOVlNcUg5NnVSZFlZcGwwUlQ3S3NPNTMydEVOK1JGM0ZGQUllM3ZWMlMwQVFQcGJZUWdyb1pCQ0tXS1pTMlFnVGkvZGdLYVV0RjFWZWZnU296bHlZbE9Ed1FrNzY3b3N2bU4iLCJtYWMiOiIxNzMwNTgxZjg1ODdlZmZmNmU5Yzc3ODZkMDExMTBiZjFhMzVjYzlmZTczOTYxNTE4MDQ3MzEzOTM4Mzg3ZDM0IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Imx6eHFmcmUyNkJUNzZuTk5ycXMwckE9PSIsInZhbHVlIjoiNk5GOVdsRVpnZDhYWW5ISFhkWnpZeFFwRzVBUkMyOVlNcUg5NnVSZFlZcGwwUlQ3S3NPNTMydEV" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Iit4UmkzNkJ5Um95dFB1Tk1ma0d0amc9PSIsInZhbHVlIjoiTS8rNG9qMHVzZWIxcElkY3ZOQzc5ZmFjV2RZc3QzaHhEV2Nud1Frd3AzcDVJYisxc3JtSUcwUFIzelVGRmR2VG5GOXhZQjFGTDJxV3p3ejRYc2VYWWtDWkJuRER5Rlk4V3hGTVlSMzFwMXhHZHQzSjJLdStnOGRKaWZkTDhVdCsiLCJtYWMiOiI3NTRmZWU3NTc1YjZjYzI4NjdiZDQ0N2FhNmRmNzQ4MDM1YWNkY2Q0NjMzN2E5Y2JmYTM0NzNkMmE5MmMzMjYzIiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 20:49:51 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Iit4UmkzNkJ5Um95dFB1Tk1ma0d0amc9PSIsInZhbHVlIjoiTS8rNG9qMHVzZWIxcElkY3ZOQzc5ZmFjV2RZc3QzaHhEV2Nud1Frd3AzcDVJYisxc3JtSUcwUFIzelVGRmR2VG5GOXhZQ" 1 => "alphaeurekaselectnet_session=eyJpdiI6Imx6eHFmcmUyNkJUNzZuTk5ycXMwckE9PSIsInZhbHVlIjoiNk5GOVdsRVpnZDhYWW5ISFhkWnpZeFFwRzVBUkMyOVlNcUg5NnVSZFlZcGwwUlQ3S3NPNTMydEVOK1JGM0ZGQUllM3ZWMlMwQVFQcGJZUWdyb1pCQ0tXS1pTMlFnVGkvZGdLYVV0RjFWZWZnU296bHlZbE9Ed1FrNzY3b3N2bU4iLCJtYWMiOiIxNzMwNTgxZjg1ODdlZmZmNmU5Yzc3ODZkMDExMTBiZjFhMzVjYzlmZTczOTYxNTE4MDQ3MzEzOTM4Mzg3ZDM0IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Imx6eHFmcmUyNkJUNzZuTk5ycXMwckE9PSIsInZhbHVlIjoiNk5GOVdsRVpnZDhYWW5ISFhkWnpZeFFwRzVBUkMyOVlNcUg5NnVSZFlZcGwwUlQ3S3NPNTMydEV" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "Q1bcbZSQXxtXPpIxrnSEGBtJdtX7zkcgyPgll7Rv" "uc_cart_id" => "599131d5e7b2427d70999b2a1e438bcd" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/96641" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 08:49:51GET/article/96641314361