Generic placeholder image

Recent Patents on Engineering

Editor-in-Chief

ISSN (Print): 1872-2121
ISSN (Online): 2212-4047

Review Article

Development of Precision Medical Technology and its Current Clinical Applications

Author(s): Ziwen Wang, Yuanying Chi, Kaiye Gao* and Rui Peng

Volume 16, Issue 3, 2022

Published on: 25 June, 2021

Article ID: e250621194290 Pages: 10

DOI: 10.2174/1872212115666210625150220

Price: $65

Abstract

Precision medicine has emerged with the development of science and technology and the rise of big data. This study first defines and presents the advantages of precision medicine and then introduces the development of three technologies: gene sequencing, cellular immunotherapy, and gene editing. The clinical applications of precision medicine in lung cancer, cervical cancer, breast cancer, and prostate cancer are thus analyzed. Lastly, the existing problems and future development directions of precision medicine are identified. The introduction of gene sequencing, bioanalytical techniques, and big data analysis tools has propelled medicine into the era of precision medicine. Key technologies in precision medicine form the foundation of its development. Therefore, this study elaborates on the development of key technologies in precision medicine, the current status of its clinical application, and the main problems that currently exist. This study also suggests solutions to the problems.

To systematically explain the development and principle of three core technologies in precision medicine and to predict the main research trends of precision medicine.

Research in gene sequencing, cell immunotherapy, and gene editing technology has shown significant progress, and accurate medical treatment has achieved remarkable results, effectively prolonging the survival time and improving the quality of life of patients.

Precision medicine has made significant achievements, but problems remain. Ensuring safety and efficiency in precision medicine should be the focus of future research.

Keywords: Precision medicine, big data, gene sequencing, cellular immunotherapy, gene editing, clinical application.

Graphical Abstract

[1]
Y.F. Li, H.T. Liu, K. Zeng, and S.J. Zhang, "Hotspot analysis in the field of international precision medicine", Chin. J. Med. Lib. Info. Sci., vol. 25, pp. 24-29, 2016.
[2]
H.W. Zhang, Innovative development and suggestions of 'internet., China Population News, 2019.
[3]
X. Su, and Y.P. Liu, "Director of oncology department of the first hospital of china medical university- the overall situation and future trend of the latest gene detection", Chin. Med. Pharm., vol. 5, pp. 1-6, 2015.
[4]
L. Xie, and W. Li, "Development of key technologies and platforms for the research of precision medicine for renal disease", Zhonghua Yi Xue Za Zhi, vol. 98, pp. 1051-1052, 2018.
[PMID: 29690718]
[5]
E.H. Du, J.W. Huang, Y.J. Yang, C. Qiao, X. Zhang, W.Q. Qiu, and A.Y. Mao, "A review of clinical application of precision medical technology", Zhongguo Weisheng Ziyuan, vol. 23, pp. 265-270, 2020.
[6]
F. Sanger, S. Nicklen, and A.R. Coulson, "DNA sequencing with chain-terminating inhibitors. 1977", Biotechnology, vol. 24, pp. 104-108, 1992.
[PMID: 1422003]
[7]
H. Wang, "Understanding and analysis of new terms of high-throughput sequencing", Chin. Terminol., vol. 19, pp. 51-54, 2017.
[8]
A.M. Maxam, and W. Gilbert, "A new method for sequencing DNA", Proc. Natl. Acad. Sci. USA, vol. 74, no. 2, pp. 560-564, 1977.
[http://dx.doi.org/10.1073/pnas.74.2.560] [PMID: 265521]
[9]
J.M. Heather, and B. Chain, "The sequence of sequencers: The history of sequencing DNA", Genomics, vol. 107, no. 1, pp. 1-8, 2016.
[http://dx.doi.org/10.1016/j.ygeno.2015.11.003] [PMID: 26554401]
[10]
P. Nyrén, and A. Lundin, "Enzymatic method for continuous monitoring of inorganic pyrophosphate synthesis", Anal. Biochem., vol. 151, no. 2, pp. 504-509, 1985.
[http://dx.doi.org/10.1016/0003-2697(85)90211-8] [PMID: 3006540]
[11]
J. Berka, Y.J. Chen, J.H. Leamon, S. Lefkowitz, K.L. Lohman, V.B. Makhijani, J.M. Rothberg, G.J. Sarkis, M. Srinivasan, and M.P. Weiner, "Bead emulsion nucleic acid amplification", U. S. Patent 20,050,079,510
[12]
S.M. Xu, "The application and research progress of the new generation dna sequencing", J. Xuzhou Inst.Technol., vol. 33, pp. 60-64, 2018.
[13]
Y.W. Mao, and J.H. Chen, "DNA the development of sequencing technology", Yaredai Zhiwu Kexue, vol. 47, pp. 94-100, 2018.
[14]
S. Roeh, P. Weber, M. Rex-Haffner, J.M. Deussing, E.B. Binder, and M. Jakovcevski, "Sequencing on the SOLiD 5500xl System - in-depth characterization of the GC bias", Nucleus, vol. 8, no. 4, pp. 370-380, 2017.
[http://dx.doi.org/10.1080/19491034.2017.1320461] [PMID: 28448740]
[15]
J. F. Thompson, and K. E. Steinmann, "Single molecule sequencing with a HeliScope genetic analysis system", Curr. Protocol Molec. bio., vol. 92, no.1, pp.7-10, 2010.
[http://dx.doi.org/10.1002/0471142727.mb0710s92]
[16]
S.J. Heerema, and C. Dekker, "Graphene nanodevices for DNA sequencing", Nat. Nanotechnol., vol. 11, no. 2, pp. 127-136, 2016.
[http://dx.doi.org/10.1038/nnano.2015.307] [PMID: 26839258]
[17]
J. Korlach, A. Bibillo, J. Wegener, P. Peluso, T.T. Pham, I. Park, S. Clark, G.A. Otto, and S.W. Turner, "Long, processive enzymatic DNA synthesis using 100% dye-labeled terminal phosphate-linked nucleotides", Nucleosides Nucleotides Nucleic Acids, vol. 27, no. 9, pp. 1072-1083, 2008.
[http://dx.doi.org/10.1080/15257770802260741] [PMID: 18711669]
[18]
J. Eid, A. Fehr, J. Gray, K. Luong, J. Lyle, G. Otto, P. Peluso, D. Rank, P. Baybayan, B. Bettman, A. Bibillo, K. Bjornson, B. Chaudhuri, F. Christians, R. Cicero, S. Clark, R. Dalal, A. Dewinter, J. Dixon, M. Foquet, A. Gaertner, P. Hardenbol, C. Heiner, K. Hester, D. Holden, G. Kearns, X. Kong, R. Kuse, Y. Lacroix, S. Lin, P. Lundquist, C. Ma, P. Marks, M. Maxham, D. Murphy, I. Park, T. Pham, M. Phillips, J. Roy, R. Sebra, G. Shen, J. Sorenson, A. Tomaney, K. Travers, M. Trulson, J. Vieceli, J. Wegener, D. Wu, A. Yang, D. Zaccarin, P. Zhao, F. Zhong, J. Korlach, and S. Turner, "Real-time DNA sequencing from single polymerase molecules", Science, vol. 323, no. 5910, pp. 133-138, 2009.
[http://dx.doi.org/10.1126/science.1162986] [PMID: 19023044]
[19]
W.J. Ansorge, "Next-generation DNA sequencing techniques", N. Biotechnol., vol. 25, no. 4, pp. 195-203, 2009.
[http://dx.doi.org/10.1016/j.nbt.2008.12.009] [PMID: 19429539]
[20]
E.A. Jares-Erijman, and T.M. Jovin, "FRET imaging", Nat. Biotechnol., vol. 21, no. 11, pp. 1387-1395, 2003.
[http://dx.doi.org/10.1038/nbt896] [PMID: 14595367]
[21]
T.Y. Dong, "DNA sequencing technology", Mod. Chem. Res., pp. 71-73, 2018.
[22]
Y. Liu, Y.Q. Xu, T.T. Zhou, M.Z. Liu, and Y.Y. Li, "Analysis of gene detection technology", Doctor., vol. 3, pp. 73-74, 2018.
[23]
Q.J. Qian, and M.C. Wu, "Accurate cellular immunotherapy for tumor: A dream into reality", Zhongguo Zhongliu Shengwu Zhiliao Zazhi, vol. 22, pp. 151-158, 2015.
[24]
T.G. Yu, J. Zhao, X.L. Li, Y.L. Liu, and G.Z. Liu, "CIK effect on immune function of patients with ovarian and cervical cancer", J. Med. Forum., vol. 41, pp. 8-11, 2020.
[25]
Q. Ren, R.H. Xiong, Y.C. He, J.K. Zhuge, D.L. Lu, and X.Y. Jiang, "The effect of autologous CIK cells on tumor markers and immune function of nasopharyngeal carcinoma", Prac. J. Cancer., vol. 35, pp. 1829-1832, 2020.
[26]
J. Wang, and W.Y. Cao, "Progress in the study of cell killing mechanism and effect CIK peripheral blood and cord blood", Curr. Immun., vol. 37, pp. 165-169, 2017.
[27]
L. Okjae, J.M. Young, H.Y. Kyeong, and S. Eui-Cheol, "Present and future of allogeneic natural killer cell therapy", Front. Immun, vol. Vol. 6, 2015.
[28]
M. Cheng, Y. Chen, W. Xiao, R. Sun, and Z. Tian, "NK cell-based immunotherapy for malignant diseases", Cell. Mol. Immunol., vol. 10, no. 3, pp. 230-252, 2013.
[http://dx.doi.org/10.1038/cmi.2013.10] [PMID: 23604045]
[29]
X.W. Lin, Y.Q. Xie, L.J. Huang, X.F. Chen, and Q.H. Zheng, "Function study of tumor invasive lymphocyte subgroup and its receptor cloning", Prac. J. Cancer., vol. 35, pp. 1749-1752, 2020.
[30]
L.P. Yang, F. Zhang, J. Zhang, Y.Y. Fei, and X. Li, "“Clinical study of DC-CIK cell maintenance in the treatment of advanced gastric cancer”, Chin. J. Meta", Cancer, vol. 3, pp. 25-29, 2020.
[31]
J.S. Kim, "Genome editing comes of age", Nat. Protoc., vol. 11, no. 9, pp. 1573-1578, 2016.
[http://dx.doi.org/10.1038/nprot.2016.104] [PMID: 27490630]
[32]
I. Hatada, and T. Horii, "Genome editing: A breakthrough in life science and medicine", Endocr. J., vol. 63, no. 2, pp. 105-110, 2016.
[http://dx.doi.org/10.1507/endocrj.EJ15-0716] [PMID: 26698412]
[33]
J.M. Wilson, "The Past, present, and future of gene therapy from Nobel Laureate David Baltimore", Hum. Gene Ther. Clin. Dev., vol. 28, no. 2, pp. 65-67, 2017.
[http://dx.doi.org/10.1089/humc.2017.29024.int] [PMID: 28530842]
[34]
A.C. Komor, Y.B. Kim, M.S. Packer, J.A. Zuris, and D.R. Liu, "Programmable editing of a target base in genomic DNA without double-stranded DNA cleavage", Nature, vol. 533, no. 7603, pp. 420-424, 2016.
[http://dx.doi.org/10.1038/nature17946] [PMID: 27096365]
[35]
Y.X. Ren, R.D. Xiao, and X.M. Lou, "Gene editing technology and its application in gene therapy", Hereditas, vol. 41, pp. 18-28, 2019.
[PMID: 30686782]
[36]
L.P. Wang, "Current situation and prospect of immunotherapy for lung cancer", Journal of Chin. Prac. Diag. Ther., vol. 31, pp. 105-110, 2017.
[37]
Z. Yang, A. Hackshaw, Q. Feng, X. Fu, Y. Zhang, C. Mao, and J. Tang, "Comparison of gefitinib, erlotinib and afatinib in non-small cell lung cancer: A meta-analysis", Int. J. Cancer, vol. 140, no. 12, pp. 2805-2819, 2017.
[http://dx.doi.org/10.1002/ijc.30691] [PMID: 28295308]
[38]
J.J. Liu, S. Zhang, C.J. Wu, L.X. Ma, Y. Liu, H. Li, H.X. Cui, and Y. Cheng, "Comparison of clinical outcomes of patients with non-small cell lung cancer harboring different types of epidermal growth factor receptor sensitive mutations after first-line EGFR-TKI treatment", Zhonghua Zhong Liu Za Zhi, vol. 38, no. 3, pp. 211-217, 2016.
[39]
D.S.W. Tan, S.S. Yom, M.S. Tsao, H.I. Pass, K. Kelly, N. Peled, R.C. Yung, I.I. Wistuba, Y. Yatabe, M. Unger, P.C. Mack, M.W. Wynes, T. Mitsudomi, W. Weder, D. Yankelevitz, R.S. Herbst, D.R. Gandara, D.P. Carbone, P.A. Bunn Jr, T.S. Mok, and F.R. Hirsch, "The international association for the study of lung cancer consensus statement on optimizing management of EGFR mutation-positive non-small cell lung cancer: Status in 2016", J. Thorac. Oncol., vol. 11, no. 7, pp. 946-963, 2016.
[http://dx.doi.org/10.1016/j.jtho.2016.05.008] [PMID: 27229180]
[40]
J.C. Soria, Y. Ohe, J. Vansteenkiste, T. Reungwetwattana, B. Chewaskulyong, K.H. Lee, A. Dechaphunkul, F. Imamura, N. Nogami, T. Kurata, I. Okamoto, C. Zhou, B.C. Cho, Y. Cheng, E.K. Cho, P.J. Voon, D. Planchard, W.C. Su, J.E. Gray, S.M. Lee, R. Hodge, M. Marotti, Y. Rukazenkov, and S.S. Ramalingam, "Osimertinib in untreated egfr-mutated advanced non-small-cell lung cancer", N. Engl. J. Med., vol. 378, no. 2, pp. 113-125, 2018.
[http://dx.doi.org/10.1056/NEJMoa1713137] [PMID: 29151359]
[41]
Q. Lai, H. Wang, A. Li, Y. Xu, L. Tang, Q. Chen, C. Zhang, Y. Gao, J. Song, and Z. Du, "Decitibine improve the efficiency of anti-PD-1 therapy via activating the response to IFN/PD-L1 signal of lung cancer cells", Oncogene, vol. 37, no. 17, pp. 2302-2312, 2018.
[http://dx.doi.org/10.1038/s41388-018-0125-3] [PMID: 29422611]
[42]
S.Y. Mahati, D.N. Ainiwaer, L. Xiao, Y.X. Bao, and Y.L.Y.E. Xiaheding, "Current situation and trend of accurate medical target screening for lung cancer", Oncol. Prog., vol. 18, pp. 331-334, 2020.
[43]
C. Wang, Z.Z. Li, X.T. Lin, N. Yu, Q.Q. Gao, and X.H. Qiu, "Advances in early screening and prevention of cervical cancer in the context of precision medicine", J. Chin. Phys., vol. 22, pp. 941-944, 2020.
[44]
R. Song, "Advances in precision medicine in the treatment of breast cancer", Smart Health., vol. 6, pp. 26-28, 2020.
[45]
G.W. Ji, "Breast cancer therapy in the age of precision medicine", J. Prac. Med., vol. 33, pp. 1369-1372, 2017.
[46]
X. Gao, and J. Li, "Prostate cancer and precision medicine", Acad. J. Sec. Milit. Med. Uni., vol. 39, pp. 581-590, 2018.
[47]
N. Zhang, China’s legal protection of genetic rights of human genetic information providers., Shandong University, 2019.
[48]
K. Chen, "Medical ethics under the reform of precision medicine", Med. Phil., vol. 37, pp. 23-25, 2016.
[49]
H.N. Ma, "Precision Medicine brings a new dawn to cancer patients", Cap. Med., vol. 23, pp. 48-49, 2016.
[50]
M. Yang, X.L. Yang, X.W. Feng, Y.F. Xiao, and Y. He, "Dilemma and outlet in the development of precision medicine in china", Chin. Health Ser. Manag., vol. 34, pp. 249-251, 2017.
[51]
Y.C. Qin, A. Wu, X. Zhang, and J. He, "Comparison of domestic and foreign legislation on privacy protection of patients and analysis on the principles of foreign basic legislation protection", Chin. Health Ser. Manag., vol. 33, pp. 48-50, 2016.
[52]
S.C. Huang, and H.J. Zhang, "A study on the ethics of precision medicine", J. Liaoning Med. Uni., vol. 17, pp. 12-16, 2019. [Natural Sciences Edition].
[53]
M.E. Bayrakdar, "Priority based health data monitoring with IEEE 802.11af technology in wireless medical sensor networks", Med. Biol. Eng. Comput., vol. 57, no. 12, pp. 2757-2769, 2019.
[http://dx.doi.org/10.1007/s11517-019-02060-4] [PMID: 31741289]
[54]
M.E. Bayrakdar, "Fuzzy logic based coordinator node selection approach in wireless medical sensor networks", IEEE 4th International Conference on Computer Science and Engineering (UBMK 2019), 2019 Quito, Ecuador.
[http://dx.doi.org/10.1109/UBMK.2019.8907097]
[55]
A. Çalhan, K. Gündoğdu, M. Cicioğlu, and M.E. Bayrakdar, "Energy harvesting unit design for body area networks", Sakarya Uni. J. Comput. Info. Sci., vol. 2, pp. 41-52, 2019.
[http://dx.doi.org/10.35377/saucis.02.01.512210]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version290msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[03:14:34] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[03:14:34] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[03:14:34] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[03:14:34] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (103ms)time
  • Application (187ms)time
  • 1 x Application (64.56%)
    187ms
    1 x Booting (35.44%)
    103ms
    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
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated112ms
    • Connection Establishedalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 9. middleware::check_user_access:24
      • 10. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 11. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address (ip_address,visitor_agent,visitor_count, created_on,updated_on) VALUES ('51271683','',1,1739848474,1739848474) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1739848474
      920μ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 ('51271683','/article/116344',1,1739848474,1739848474)
      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 >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_corporate WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_journal_volume_token WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_trail WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_corporate WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_ebook_volume_token WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51271683 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51271683) limit 1
      12.07msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51271683
      • 1: 51271683
      • 2: 51271683
      • 3: 51271683
      • 4: 51271683
      • 5: 51271683
      • 6: 51271683
      • 7: 51271683
      • 8: 51271683
      • 9: 51271683
      • 10: 51271683
      • 11: 51271683
      • 12: 51271683
      • 13: 51271683
      • 14: 51271683
      • 15: 51271683
      Backtrace
      • 14. app/Models/UserAccess/UserAccess.php:784
      • 15. middleware::check_user_access:114
      • 16. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • SELECT 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=116344
      590μ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` = 78 limit 1
      750μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 78
      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=78) and sj.journal_id!=78 group by `j`.`nid`) as `aggregate_table`
      570μ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=78) and sj.journal_id!=78 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      450μ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=78) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      1.99msalphaeurekaselec_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=78) 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.71msalphaeurekaselec_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` = '116344'
      810μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 116344
      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` = '116344'
      2.13msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 116344
      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` = '116344' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.04msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 116344
      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
      240μ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
      420μ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 = 78 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      24.84msalphaeurekaselec_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 = 78 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      8.8msalphaeurekaselec_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 = 78 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      4.49msalphaeurekaselec_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` = 116344 limit 1
      190μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 116344
      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 = 116344 and content_type = 'article' order by status desc limit 1
      240μ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 a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 16 and cd.sub_disease_id = 439 and content_id!=116344 and cd.content_type = 'article' order by rand() limit 20
      31.69msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 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` = 194290 limit 1
      200μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 194290
      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
      190μ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` = 'ENG' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      310μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: ENG
      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 = '116344' 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 = '11411' 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) )
      250μ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 = '3194' 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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1739848474 and j.to_date >= 1739848474 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3194) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1739848474 and j.to_date >= 1739848474 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3194) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1739848474 and j.to_date >= 1739848474 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3194)
      7.42msalphaeurekaselec_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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1739848474 and j.to_date >= 1739848474 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11411) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1739848474 and j.to_date >= 1739848474 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11411) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"issue" as access_level,j.issue_id,"" as article_id from `user_access_issue_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1739848474 and j.to_date >= 1739848474 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11411)
      530μ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 <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1739848474 and j.to_date >= 1739848474 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 116344) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Subscribed" as access_base_text, false as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1739848474 and j.to_date >= 1739848474 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 116344) union (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Token Based Access" as access_base_text, false as terms_popup, "R" as content_download_type, j.uc_id as restricted_user_access_key, "v" as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 51271683 and j.to_ip >=51271683 )) and ((j.from_date <= 1739848474 and j.to_date >= 1739848474 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 116344)
      540μ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` < '54' and is_uploaded = 1 and issue_id = 11411 order by cast(first_page as SIGNED) desc limit 1
      430μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 54
      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` > '63' and is_uploaded = 1 and issue_id = 11411 order by cast(first_page as SIGNED) asc limit 1
      380μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 63
      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
      160μ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` = 116344 limit 1
      2.69msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 116344
      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` = 78 and `b`.`banner_from_date` <= 1739848474 and `b`.`banner_to_date` >= 1739848474 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.29msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 78
      • 3: 1739848474
      • 4: 1739848474
      • 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` = 78 and `b`.`banner_from_date` <= 1739848474 and `b`.`banner_to_date` >= 1739848474 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.06msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 78
      • 3: 1739848474
      • 4: 1739848474
      • 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='e25101ce59186685453d4bbf2164ad4e'
      210μ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
        EwwAIzkTFPvjF30IgVqk9i5TwVxyoMbglRTpXGoM
        uc_cart_id
        e25101ce59186685453d4bbf2164ad4e
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/116344" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/116344
        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:8 [ "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
        []
        
        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, 18 Feb 2025 03:14:34 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjEweXRCeUlQNzg3eDQ0eXJvL3lOS1E9PSIsInZhbHVlIjoiTVU1cW0rN0FZb0E2bVJwMDBOQmVyQ3RwekVwcUlmVTVZdHh5cjNtTnNYN0wzd3Joei81NjhOdVdIc01QUVJEYW1WblBjNUhSNTdpOTRaYTAyMUdSc0JEaDNtZHJIRThueU03OEw1SGU3T2F5dzZCT3NTaDZGd0xDZkFGN1FyY3oiLCJtYWMiOiI1NTJiZGJlMzJhMzBjNzRkNjhkZjJhZjBmOTFhMDc4ZWVhZWQwODI2MTE4OWM5NGJhMjAxYzY5NzY5ZjM3YjkwIiwidGFnIjoiIn0%3D; expires=Thu, 20 Feb 2025 15:14:34 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjEweXRCeUlQNzg3eDQ0eXJvL3lOS1E9PSIsInZhbHVlIjoiTVU1cW0rN0FZb0E2bVJwMDBOQmVyQ3RwekVwcUlmVTVZdHh5cjNtTnNYN0wzd3Joei81NjhOdVdIc01QUVJEYW1WblBjN" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkRPOWpXQXA5Y01UM2RvK0p1WHZRUVE9PSIsInZhbHVlIjoiUVpnOUtYSFFGdmZiNW5kQnV1cFhyZEpaQjJvSkFVTWpDSXZIRUlEZ2owcXJtMVcwQUhsYkN5eEtIYndGcXJNdndRR3FyT24rbFE2djlnSXdTZEtia3VtMStvUHFzZE9NaEI1WmZMZlR3OURFRlpwVzV5dU1tWnJSaTdHR1ZibDEiLCJtYWMiOiIxZWY4MTcxOTBkNWYyNGIxN2MyNDc1Y2U0YjUxNDRmOTM3M2NlMWE2ZWEwYTVlNWM0NTA1MzMyOTU2MTBhMjA3IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkRPOWpXQXA5Y01UM2RvK0p1WHZRUVE9PSIsInZhbHVlIjoiUVpnOUtYSFFGdmZiNW5kQnV1cFhyZEpaQjJvSkFVTWpDSXZIRUlEZ2owcXJtMVcwQUhsYkN5eEt" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjEweXRCeUlQNzg3eDQ0eXJvL3lOS1E9PSIsInZhbHVlIjoiTVU1cW0rN0FZb0E2bVJwMDBOQmVyQ3RwekVwcUlmVTVZdHh5cjNtTnNYN0wzd3Joei81NjhOdVdIc01QUVJEYW1WblBjNUhSNTdpOTRaYTAyMUdSc0JEaDNtZHJIRThueU03OEw1SGU3T2F5dzZCT3NTaDZGd0xDZkFGN1FyY3oiLCJtYWMiOiI1NTJiZGJlMzJhMzBjNzRkNjhkZjJhZjBmOTFhMDc4ZWVhZWQwODI2MTE4OWM5NGJhMjAxYzY5NzY5ZjM3YjkwIiwidGFnIjoiIn0%3D; expires=Thu, 20-Feb-2025 15:14:34 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjEweXRCeUlQNzg3eDQ0eXJvL3lOS1E9PSIsInZhbHVlIjoiTVU1cW0rN0FZb0E2bVJwMDBOQmVyQ3RwekVwcUlmVTVZdHh5cjNtTnNYN0wzd3Joei81NjhOdVdIc01QUVJEYW1WblBjN" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkRPOWpXQXA5Y01UM2RvK0p1WHZRUVE9PSIsInZhbHVlIjoiUVpnOUtYSFFGdmZiNW5kQnV1cFhyZEpaQjJvSkFVTWpDSXZIRUlEZ2owcXJtMVcwQUhsYkN5eEtIYndGcXJNdndRR3FyT24rbFE2djlnSXdTZEtia3VtMStvUHFzZE9NaEI1WmZMZlR3OURFRlpwVzV5dU1tWnJSaTdHR1ZibDEiLCJtYWMiOiIxZWY4MTcxOTBkNWYyNGIxN2MyNDc1Y2U0YjUxNDRmOTM3M2NlMWE2ZWEwYTVlNWM0NTA1MzMyOTU2MTBhMjA3IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkRPOWpXQXA5Y01UM2RvK0p1WHZRUVE9PSIsInZhbHVlIjoiUVpnOUtYSFFGdmZiNW5kQnV1cFhyZEpaQjJvSkFVTWpDSXZIRUlEZ2owcXJtMVcwQUhsYkN5eEt" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "EwwAIzkTFPvjF30IgVqk9i5TwVxyoMbglRTpXGoM" "uc_cart_id" => "e25101ce59186685453d4bbf2164ad4e" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/116344" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-18 03:14:34GET/article/116344414371