Generic placeholder image

Current Computer-Aided Drug Design

Editor-in-Chief

ISSN (Print): 1573-4099
ISSN (Online): 1875-6697

Research Article

Screening of Inhibitors against Idiopathic Pulmonary Fibrosis: Few-shot Machine Learning and Molecule Docking based Drug Repurposing

Author(s): Jun Chang*, Shaoqing Zou, Subo Xu, Yiwen Xiao and Du Zhu*

Volume 20, Issue 2, 2024

Published on: 03 May, 2023

Page: [134 - 144] Pages: 11

DOI: 10.2174/1573409919666230417080832

Price: $65

Abstract

Introduction: Idiopathic pulmonary fibrosis is a chronic progressive disorder and is diagnosed as post-COVID fibrosis. Idiopathic pulmonary fibrosis has no effective treatment because of the low therapeutic effects and side effects of currently available drugs.

Aim: The aim is to screen new inhibitors against idiopathic pulmonary fibrosis from traditional Chinese medicines.

Methods: Few-shot-based machine learning and molecule docking were used to predict the potential activities of candidates and calculate the ligand-receptor interactions. In vitro A549 cell model was taken to verify the effects of the selected leads on idiopathic pulmonary fibrosis.

Results: A logistic regression classifier model with an accuracy of 0.82 was built and, combined with molecule docking, used to predict the activities of candidates. 6 leads were finally screened out and 5 of them were in vitro experimentally verified as effective inhibitors against idiopathic pulmonary fibrosis.

Conclusion: Herbacetin, morusin, swertiamarin, vicenin-2, and vitexin were active inhibitors against idiopathic pulmonary fibrosis. Swertiamarin exhibited the highest anti-idiopathic pulmonary fibrosis effect and should be further in vivo investigated for its activity.

Graphical Abstract

[1]
Wilson, M.S.; Wynn, T.A. Pulmonary fibrosis: Pathogenesis, etiology and regulation. Mucosal Immunol., 2009, 2(2), 103-121.
[http://dx.doi.org/10.1038/mi.2008.85] [PMID: 19129758]
[2]
Bazdyrev, E.; Rusina, P.; Panova, M.; Novikov, F.; Grishagin, I.; Nebolsin, V. Lung fibrosis after COVID-19: Treatment prospects. Pharmaceuticals, 2021, 14(8), 807-821.
[http://dx.doi.org/10.3390/ph14080807] [PMID: 34451904]
[3]
Murray, L.A.; Rubinowitz, A.; Herzog, E.L. Interstitial lung disease. Curr. Opin. Rheumatol., 2012, 24(6), 656-662.
[http://dx.doi.org/10.1097/BOR.0b013e3283588de4] [PMID: 22955020]
[4]
Glass, D.S.; Grossfeld, D.; Renna, H.A.; Agarwala, P.; Spiegler, P.; DeLeon, J.; Reiss, A.B. Idiopathic pulmonary fibrosis: Current and future treatment. Clin. Respir. J., 2022, 16(2), 84-96.
[http://dx.doi.org/10.1111/crj.13466] [PMID: 35001525]
[5]
Jin, H. Imrecoxib inhibits paraquat-induced pulmonary fibrosis through the NF-κB/snail signaling pathway. Comput. Math. Methods Med., 2020, 2020, 1-9.
[http://dx.doi.org/10.1155/2020/6374014] [PMID: 33123215]
[6]
Ekins, S.; Gerlach, J.; Zorn, K.M.; Antonio, B.M.; Lin, Z.; Gerlach, A. Repurposing approved drugs as inhibitors of Kv7.1 and Nav1.8 to Treat Pitt Hopkins syndrome. Pharm. Pharm. Res., 2019, 36(9), 137.
[http://dx.doi.org/10.1007/s11095-019-2671-y] [PMID: 31332533]
[7]
Dudley, J.T.; Deshpande, T.; Butte, A.J. Exploiting drug-disease relationships for computational drug repositioning. Brief. Bioinform., 2011, 12(4), 303-311.
[http://dx.doi.org/10.1093/bib/bbr013] [PMID: 21690101]
[8]
Baker, N.C.; Ekins, S.; Williams, A.J.; Tropsha, A. A bibliometric review of drug repurposing. Drug Discov. Today, 2018, 23(3), 661-672.
[http://dx.doi.org/10.1016/j.drudis.2018.01.018] [PMID: 29330123]
[9]
Ru, J.; Li, P.; Wang, J.; Zhou, W.; Li, B.; Huang, C.; Li, P.; Guo, Z.; Tao, W.; Yang, Y.; Xu, X.; Li, Y.; Wang, Y.; Yang, L. TCMSP: A database of systems pharmacology for drug discovery from herbal medicines. J. Cheminform., 2014, 6(1), 13.
[http://dx.doi.org/10.1186/1758-2946-6-13] [PMID: 24735618]
[10]
Trott, O.; Olson, A.J. AutoDock Vina: Improving the speed and accuracy of docking with a new scoring function, efficient optimization, and multithreading. J. Comput. Chem., 2010, 31(2), 455-461.
[PMID: 19499576]
[11]
O’Boyle, N.M.; Banck, M.; James, C.A.; Morley, C.; Vandermeersch, T.; Hutchison, G.R. Open babel: An open chemical toolbox. J. Cheminform., 2011, 3(1), 33.
[http://dx.doi.org/10.1186/1758-2946-3-33] [PMID: 21982300]
[12]
Kim, D.J.; Lee, M.H.; Liu, K.; Lim, D.Y.; Roh, E.; Chen, H.; Kim, S.H.; Shim, J.H.; Kim, M.O.; Li, W.; Ma, F.; Fredimoses, M.; Bode, A.M.; Dong, Z. Herbacetin suppresses cutaneous squamous cell carcinoma and melanoma cell growth by targeting AKT and ODC. Carcinogenesis, 2017, 38(11), 1136-1146.
[http://dx.doi.org/10.1093/carcin/bgx082] [PMID: 29029040]
[13]
Li, L.; Sapkota, M.; Kim, S.; Soh, Y. Herbacetin inhibits inducible nitric oxide synthase via JNK and nuclear factor-κB in LPS-stimulated RAW264.7 cells. Eur. J. Pharmacol., 2015, 765, 115-123.
[http://dx.doi.org/10.1016/j.ejphar.2015.08.032] [PMID: 26297979]
[14]
Jin, S.; Ha, H.; Shin, H.K.; Seo, C.S. Anti-allergic and anti-inflammatory effects of kuwanon G and morusin on MC/9 mast cells and Ha-CaT keratinocytes. Molecules, 2019, 24(2), 265.
[http://dx.doi.org/10.3390/molecules24020265] [PMID: 30642008]
[15]
Chen, C.; Wang, J.; Chen, J.; Zhou, L.; Wang, H.; Chen, J.; Xu, Z.; Zhu, S.; Liu, W.; Yu, R.; Lu, J.; Luo, H.; Chen, M.; Chen, W. Morusin alleviates mycoplasma pneumonia via the inhibition of Wnt/β-catenin and NF-κB signaling. Biosci. Rep., 2019, 39(6), BSR20190190.
[http://dx.doi.org/10.1042/BSR20190190] [PMID: 31171712]
[16]
Martins, B.A.; Sande, D.; Solares, M.D.; Takahashi, J.A. Antioxidant role of morusin and mulberrofuran B in ethanol extract of Morus alba roots. Nat. Prod. Res., 2021, 35(24), 5993-5996.
[http://dx.doi.org/10.1080/14786419.2020.1810036] [PMID: 32840147]
[17]
Jaishree, V.; Badami, S. Antioxidant and hepatoprotective effect of swertiamarin from Enicostemma axillare against d-galactosamine induced acute liver damage in rats. J. Ethnopharmacol., 2010, 130(1), 103-106.
[http://dx.doi.org/10.1016/j.jep.2010.04.019] [PMID: 20420896]
[18]
Vaijanathappa, J.; Badami, S. Antiedematogenic and free radical scavenging activity of swertiamarin isolated from Enicostemma axillare. Planta Med., 2009, 75(1), 12-17.
[http://dx.doi.org/10.1055/s-0028-1088333] [PMID: 19006050]
[19]
Wu, X.; Gu, Y.; Li, L. The anti-hyperplasia, anti-oxidative and anti-inflammatory properties of Qing Ye Dan and swertiamarin in testosterone-induced benign prostatic hyperplasia in rats. Toxicol. Lett., 2017, 265, 9-16.
[http://dx.doi.org/10.1016/j.toxlet.2016.11.011] [PMID: 27866977]
[20]
Seo, K.H.; Park, M.J.; Ra, J.E.; Han, S.I.; Nam, M.H.; Kim, J.H.; Lee, J.H.; Seo, W.D. Saponarin from barley sprouts inhibits NF-κB and MAPK on LPS-induced RAW 264.7 cells. Food Funct., 2014, 5(11), 3005-3013.
[http://dx.doi.org/10.1039/C4FO00612G] [PMID: 25238253]
[21]
Min, S.Y.; Park, C.H.; Yu, H.W.; Park, Y.J. Anti-inflammatory and anti-allergic fffects of saponarin and its impact on signaling pathways of RAW 264.7, RBL-2H3, and HaCaT cells. Int. J. Mol. Sci., 2021, 22(16), 8431.
[http://dx.doi.org/10.3390/ijms22168431] [PMID: 34445132]
[22]
Kamiyama, M.; Shibamoto, T. Flavonoids with potent antioxidant activity found in young green barley leaves. J. Agric. Food Chem., 2012, 60(25), 6260-6267.
[http://dx.doi.org/10.1021/jf301700j] [PMID: 22681491]
[23]
Vitcheva, V.; Simeonova, R.; Krasteva, I.; Yotova, M.; Nikolov, S.; Mitcheva, M. Hepatoprotective effects of saponarin, isolated from Gypsophila trichotoma Wend. on cocaine-induced oxidative stress in rats. Redox Rep., 2011, 16(2), 56-61.
[http://dx.doi.org/10.1179/174329211X12989133691530] [PMID: 21722413]
[24]
Duan, X.; Wu, T.; Liu, T.; Yang, H.; Ding, X.; Chen, Y.; Mu, Y. Vicenin-2 ameliorates oxidative damage and photoaging via modulation of MAPKs and MMPs signaling in UVB radiation exposed human skin cells. J. Photochem. Photobiol. B, 2019, 190, 76-85.
[http://dx.doi.org/10.1016/j.jphotobiol.2018.11.018] [PMID: 30502588]
[25]
Yang, D.; Zhang, X.; Zhang, W.; Thamaraiselvan, R. Vicenin-2 inhibits Wnt/β-catenin signaling and induces apoptosis in HT-29 human colon cancer cell line. Drug Des. Devel. Ther., 2018, 12, 1303-1310.
[http://dx.doi.org/10.2147/DDDT.S149307] [PMID: 29849451]
[26]
Yin, Y.; Ye, L.; Niu, Z.; Fang, W. Anti-inflammatory effects of Vicenin-2 on dextran sulfate sodium-induced colitis in mice. Drug Dev. Res., 2019, 80(5), 546-555.
[http://dx.doi.org/10.1002/ddr.21529] [PMID: 30972795]
[27]
Rosa, S.I.G.; Rios-Santos, F.; Balogun, S.O.; Martins, D.T.O. Vitexin reduces neutrophil migration to inflammatory focus by down-regulating pro-inflammatory mediators via inhibition of p38, ERK1/2 and JNK pathway. Phytomedicine, 2016, 23(1), 9-17.
[http://dx.doi.org/10.1016/j.phymed.2015.11.003] [PMID: 26902402]
[28]
Chen, Y.; Yang, J.; Huang, Z.; Yin, B.; Umar, T.; Yang, C.; Zhang, X.; Jing, H.; Guo, S.; Guo, M.; Deng, G.; Qiu, C. Vitexin Mitigates Staphylococcus aureus-induced mastitis via regulation of ROS/ER stress/NF-kappa B/MAPK pathway. Oxid. Med. Cell. Longev., 2022, 2022, 1-20.
[http://dx.doi.org/10.1155/2022/7977433] [PMID: 35795861]
[29]
Li, S.; Lv, H.; Chen, Y.; Song, H.; Zhang, Y.; Wang, S.; Luo, L.; Guan, X. N-trimethyl chitosan coated targeting nanoparticles improve the oral bioavailability and antioxidant activity of vitexin. Carbohydr. Polym., 2022, 286, 119273.
[http://dx.doi.org/10.1016/j.carbpol.2022.119273] [PMID: 35337500]
[30]
Vamathevan, J.; Clark, D.; Czodrowski, P.; Dunham, I.; Ferran, E.; Lee, G.; Li, B.; Madabhushi, A.; Shah, P.; Spitzer, M.; Zhao, S. Applications of machine learning in drug discovery and development. Nat. Rev. Drug Discov., 2019, 18(6), 463-477.
[http://dx.doi.org/10.1038/s41573-019-0024-5] [PMID: 30976107]
[31]
Yaseen, B.T.; Kurnaz, S. Drug-target interaction prediction using artificial intelligence. Appl. Nanosci., 2021, 195, 2.
[32]
Xue, L.; Godden, J.W.; Bajorath, J. Mini-fingerprints for virtual screening: Design principles and generation of novel prototypes based on information theory. SAR QSAR Environ. Res., 2003, 14(1), 27-40.
[http://dx.doi.org/10.1080/1062936021000058764] [PMID: 12688414]
[33]
Matsuyama, Y.; Ishida, T. Stacking multiple molecular fingerprints for improving ligand-based virtual screening. Cham; Springer International Publishing: Berlin, 2018.
[34]
Kim, H.; Nam, H. hERG-Att: Self-attention-based deep neural network for predicting hERG blockers. Comput. Biol. Chem., 2020, 87, 107286.
[http://dx.doi.org/10.1016/j.compbiolchem.2020.107286] [PMID: 32531518]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version303msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[23:43:05] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[23:43:06] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[23:43:06] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[23:43:06] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (89.96ms)time
  • Application (213ms)time
  • 1 x Application (70.33%)
    213ms
    1 x Booting (29.66%)
    89.96ms
    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 duplicated141ms
    • 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 ('316513831','',1,1740526985,1740526985) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740526985
      990μ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 ('316513831','/article/130951',1,1740526985,1740526985)
      140μ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 >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) 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 >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) 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 >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) 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 >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) 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 >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) 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 >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316513831 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316513831) limit 1
      11.26msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316513831
      • 1: 316513831
      • 2: 316513831
      • 3: 316513831
      • 4: 316513831
      • 5: 316513831
      • 6: 316513831
      • 7: 316513831
      • 8: 316513831
      • 9: 316513831
      • 10: 316513831
      • 11: 316513831
      • 12: 316513831
      • 13: 316513831
      • 14: 316513831
      • 15: 316513831
      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=130951
      670μ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` = 5 limit 1
      18.19msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 5
      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=5) and sj.journal_id!=5 group by `j`.`nid`) as `aggregate_table`
      850μsalphaeurekaselec_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=5) and sj.journal_id!=5 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      610μ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=5) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.82msalphaeurekaselec_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=5) 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.49msalphaeurekaselec_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` = '130951'
      190μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 130951
      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` = '130951'
      2.97msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 130951
      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` = '130951' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.33msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 130951
      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
      440μ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 = 5 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      36.42msalphaeurekaselec_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 = 5 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      11.11msalphaeurekaselec_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 = 5 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      4.34msalphaeurekaselec_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` = 130951 limit 1
      160μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 130951
      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 = 130951 and content_type = 'article' order by status desc limit 1
      260μ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` = 215838 limit 1
      180μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 215838
      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
      210μ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` = 'CCADD' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      230μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CCADD
      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 = '130951' 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) )
      320μ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 = '12701' 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) )
      260μ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 = '3441' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      240μ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 <= 316513831 and j.to_ip >=316513831 )) and ((j.from_date <= 1740526986 and j.to_date >= 1740526986 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3441) 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 <= 316513831 and j.to_ip >=316513831 )) and ((j.from_date <= 1740526986 and j.to_date >= 1740526986 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3441) 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 <= 316513831 and j.to_ip >=316513831 )) and ((j.from_date <= 1740526986 and j.to_date >= 1740526986 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3441)
      37.57msalphaeurekaselec_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 <= 316513831 and j.to_ip >=316513831 )) and ((j.from_date <= 1740526986 and j.to_date >= 1740526986 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12701) 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 <= 316513831 and j.to_ip >=316513831 )) and ((j.from_date <= 1740526986 and j.to_date >= 1740526986 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12701) 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 <= 316513831 and j.to_ip >=316513831 )) and ((j.from_date <= 1740526986 and j.to_date >= 1740526986 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 12701)
      740μ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 <= 316513831 and j.to_ip >=316513831 )) and ((j.from_date <= 1740526986 and j.to_date >= 1740526986 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 130951) 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 <= 316513831 and j.to_ip >=316513831 )) and ((j.from_date <= 1740526986 and j.to_date >= 1740526986 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 130951) 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 <= 316513831 and j.to_ip >=316513831 )) and ((j.from_date <= 1740526986 and j.to_date >= 1740526986 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 130951)
      570μ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` < '134' and is_uploaded = 1 and issue_id = 12701 order by cast(first_page as SIGNED) desc limit 1
      450μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 134
      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` > '144' and is_uploaded = 1 and issue_id = 12701 order by cast(first_page as SIGNED) asc limit 1
      370μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 144
      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'
      150μ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
      170μ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` = 130951 limit 1
      2.31msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 130951
      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` = 5 and `b`.`banner_from_date` <= 1740526986 and `b`.`banner_to_date` >= 1740526986 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: 5
      • 3: 1740526986
      • 4: 1740526986
      • 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` = 5 and `b`.`banner_from_date` <= 1740526986 and `b`.`banner_to_date` >= 1740526986 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.04msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 5
      • 3: 1740526986
      • 4: 1740526986
      • 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='0987814086eab4d34fde4a3c7e0d249a'
      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
        jKLERarj1zzm0sUF7kbP8cWIhGDkk4UyhPAYpdfh
        uc_cart_id
        0987814086eab4d34fde4a3c7e0d249a
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/130951" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/130951
        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=eyJpdiI6IjJsMkxYUTZnVFptdWFKbS9JRTZpTnc9PSIsInZhbHVlIjoickdrcDE1czcvSVdGa3NWNFdIUkh6TGgzZHNuWU4rVk03bE9yYXN1MW5qVT0iLCJtYWMiOiJhYzZjZmQyZjdlNGQ5YzViODUwOGVmY2QxNDYxMDYyZmFhYjc1Zjk0MTExODRmOGVhNTk5MGU2YzE4M2Q4ZmZhIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IjJsMkxYUTZnVFptdWFKbS9JRTZpTnc9PSIsInZhbHVlIjoickdrcDE1czcvSVdGa3NWNFdIUkh6TGgzZHNuWU4rVk03bE9yYXN1MW5qVT0iLCJtYWMiOiJhYzZjZmQyZjdlNGQ5" ] "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 23:43:06 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ild1a0JWOVpiSU1MSkFJdDNMb050Nnc9PSIsInZhbHVlIjoiRTFHV2VYQVppMHBISE1NZXE1VFV4b3JMcFczSWI3MzFSU3FsT3c5NVJHdmtJK0M5TWJzait2ZndNSnpwT3diUUsvSzk3MkVQUUo1MitRUXZtVURvVXJkbW9ENnVlNjQvbHdzVW56SnhNTVluZ0xYSDJSQWI1UUNzUllEcnBvR2wiLCJtYWMiOiJiZTAyNmM1ZjJjODhhMmRjNjBlMzdlZTdiYTNmYWU5MzE3ODExODYwYThjYmE2MThlOTA4NzFiNzUwMThlMjNhIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 11:43:06 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ild1a0JWOVpiSU1MSkFJdDNMb050Nnc9PSIsInZhbHVlIjoiRTFHV2VYQVppMHBISE1NZXE1VFV4b3JMcFczSWI3MzFSU3FsT3c5NVJHdmtJK0M5TWJzait2ZndNSnpwT3diUUsvSzk3M" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkZVVUVPM3hDd1d3LzJyTlNUVHZrUVE9PSIsInZhbHVlIjoib2lsVnMwU21NL2xiRGsyNGZ3YTRkaW5ld1RqYVlNdXg1THppbmVPVUptRjF4UGRUc1pLK0lreFBFakxlelNKaVZEOWVCbzRnUkhEdFZFSDVod0dwMEZ4d3ZhSXoyWktaUS9zdG4zRVBobTdVbWtibXdQa1poenBXNldvbVM4eXMiLCJtYWMiOiI3ODgxNDk3OWUyMmY4ODAyZGUxNjk2YWM3YTVmMzU0NmNhYTg1OWZiMGE2MDNmYTFjMDk3NzRmOGZjYzEwOWQwIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkZVVUVPM3hDd1d3LzJyTlNUVHZrUVE9PSIsInZhbHVlIjoib2lsVnMwU21NL2xiRGsyNGZ3YTRkaW5ld1RqYVlNdXg1THppbmVPVUptRjF4UGRUc1pLK0lreFB" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ild1a0JWOVpiSU1MSkFJdDNMb050Nnc9PSIsInZhbHVlIjoiRTFHV2VYQVppMHBISE1NZXE1VFV4b3JMcFczSWI3MzFSU3FsT3c5NVJHdmtJK0M5TWJzait2ZndNSnpwT3diUUsvSzk3MkVQUUo1MitRUXZtVURvVXJkbW9ENnVlNjQvbHdzVW56SnhNTVluZ0xYSDJSQWI1UUNzUllEcnBvR2wiLCJtYWMiOiJiZTAyNmM1ZjJjODhhMmRjNjBlMzdlZTdiYTNmYWU5MzE3ODExODYwYThjYmE2MThlOTA4NzFiNzUwMThlMjNhIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 11:43:06 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ild1a0JWOVpiSU1MSkFJdDNMb050Nnc9PSIsInZhbHVlIjoiRTFHV2VYQVppMHBISE1NZXE1VFV4b3JMcFczSWI3MzFSU3FsT3c5NVJHdmtJK0M5TWJzait2ZndNSnpwT3diUUsvSzk3M" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkZVVUVPM3hDd1d3LzJyTlNUVHZrUVE9PSIsInZhbHVlIjoib2lsVnMwU21NL2xiRGsyNGZ3YTRkaW5ld1RqYVlNdXg1THppbmVPVUptRjF4UGRUc1pLK0lreFBFakxlelNKaVZEOWVCbzRnUkhEdFZFSDVod0dwMEZ4d3ZhSXoyWktaUS9zdG4zRVBobTdVbWtibXdQa1poenBXNldvbVM4eXMiLCJtYWMiOiI3ODgxNDk3OWUyMmY4ODAyZGUxNjk2YWM3YTVmMzU0NmNhYTg1OWZiMGE2MDNmYTFjMDk3NzRmOGZjYzEwOWQwIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkZVVUVPM3hDd1d3LzJyTlNUVHZrUVE9PSIsInZhbHVlIjoib2lsVnMwU21NL2xiRGsyNGZ3YTRkaW5ld1RqYVlNdXg1THppbmVPVUptRjF4UGRUc1pLK0lreFB" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "jKLERarj1zzm0sUF7kbP8cWIhGDkk4UyhPAYpdfh" "uc_cart_id" => "0987814086eab4d34fde4a3c7e0d249a" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/130951" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 23:43:06GET/article/130951414361