Generic placeholder image

Medicinal Chemistry

Editor-in-Chief

ISSN (Print): 1573-4064
ISSN (Online): 1875-6638

Research Article

Exploring the Molecular Mechanisms of 17β-HSD5-induced Carcinogenicity of Catha edulis via Molecular Modeling Approach

Author(s): Maria Saeed, Sajda Ashraf, Rashad Alsanosi, Hassan A. Alhazmi, Mohammed AlBratty, Asim Najmi, Asaad Khalid* and Zaheer Ul-Haq*

Volume 17, Issue 4, 2021

Published on: 05 October, 2020

Page: [418 - 428] Pages: 11

DOI: 10.2174/1573406416666201005142522

Price: $65

Abstract

Background: The tradition of khat chewing has been deep-rooted in the African and Arabian Peninsula for centuries. Due to its amphetamine-like psycho-stimulant or euphoric effect, khat has been used by millions in Somalia, Ethiopia, Saudi Arabia and Yemen. The long-term use of khat can induce many major health outcomes, which may be serious and irreversible.

Objective: Prolonged use of khat constituents has been associated with different types of cancers such as prostatic, breast and ovarian cancer. However, it has been very difficult to identify the molecular targets involved in khat carcinogenesis that interact with the Khat constituents by in vitro/in vivo experimental tools.

Methods: In silico tools were used to predict potential targets involved in the carcinogenesis of khat. Pass on-line prediction server was used for the prediction of a potential molecular target for khat constituents. Molecular Dynamics simulation and MM-GBSA calculation of the predicted target were carried out.

Results: Molecular Dynamics simulation and MM-GBSA calculation revealed that among khat constituents, β-sitosterol showed a high binding affinity towards 17β-HSD5. On the other hand, this study highlights for the first time some new interactions, which were observed in the case of cathine, cathinone and nerol during the simulation.

Conclusion: In silico molecular dynamic simulation tools were used for the first time to investigate the molecular mechanism of widely used leaves of psychoactive khat (Catha edulis) constituent. The present study provides deep insight to understand the effect of khat constituents involved in the impairment of the reproductive system and its binding to 17β-HSD5. ADMET profiling also suggested that few khat constituents do not fulfill the requirements of the Lipinski rule of five i.e. poor absorption and blood-brain barrier impermeability.

Keywords: Khat constituents, psychoactive substance, euphoria, 17β-HSD5, MD simulation, MM GB/PBSA, polycystic ovary syndrome.

« Previous
Graphical Abstract

[1]
Abdelwahab, S.I.; Alsanosy, R.M.; Rahim, B-E.; Mohan, S.; Taha, S.; Mohamed Elhassan, M.; El-Setouhy, M. Khat (Catha edulis Forsk.) dependence potential and pattern of use in Saudi Arabia. BioMed Res. Int., 2015, 2015604526
[http://dx.doi.org/10.1155/2015/604526] [PMID: 26380288]
[2]
Gebissa, E. Khat in the Horn of Africa: historical perspectives and current trends. J. Ethnopharmacol., 2010, 132(3), 607-614.
[http://dx.doi.org/10.1016/j.jep.2010.01.063] [PMID: 20227478]
[3]
Hansen, P. The ambiguity of khat in Somaliland. J. Ethnopharmacol., 2010, 132(3), 590-599.
[http://dx.doi.org/10.1016/j.jep.2010.02.028] [PMID: 20211235]
[4]
Lamina, S. Khat (Catha edulis): the herb with officio-legal, socio-cultural and economic uncertainty. S. Afr. J. Sci., 2010, 106(3-4), 1-4.
[http://dx.doi.org/10.4102/sajs.v106i3/4.155]
[5]
Colzato, L.S.; Ruiz, M.J.; van den Wildenberg, W.P.; Hommel, B. Khat use is associated with impaired working memory and cognitive flexibility. PLoS One, 2011, 6(6)e20602
[http://dx.doi.org/10.1371/journal.pone.0020602] [PMID: 21698275]
[6]
Engidawork, E. Pharmacological and toxicological effects of Catha edulis F.(Khat). Phytother. Res., 2017, 31(7), 1019-1028.
[http://dx.doi.org/10.1002/ptr.5832] [PMID: 28557133]
[7]
Nichols, T.; Khondkar, P.; Gibbons, S. The psychostimulant drug khat (Catha edulis): A mini-review. Phytochem. Lett., 2015, 13, 127-133.
[http://dx.doi.org/10.1016/j.phytol.2015.05.016]
[8]
Wabe, N.T.; Mohammed, M.A. What science says about khat (Catha edulis Forsk)? Overview of chemistry, toxicology and pharmacology. J. Exp. Integr. Med., 2012, 2(1), 29-37.
[http://dx.doi.org/10.5455/jeim.221211.rw.005]
[9]
Wabe, N.T. Chemistry, pharmacology, and toxicology of khat (catha edulis forsk): a review. Addict. Health, 2011, 3(3-4), 137-149.
[PMID: 24494129]
[10]
Toennes, S.W.; Harder, S.; Schramm, M.; Niess, C.; Kauert, G.F. Pharmacokinetics of cathinone, cathine and norephedrine after the chewing of khat leaves. Br. J. Clin. Pharmacol., 2003, 56(1), 125-130.
[http://dx.doi.org/10.1046/j.1365-2125.2003.01834.x PMID: 12848785]
[11]
Warfa, N.; Klein, A.; Bhui, K.; Leavey, G.; Craig, T.; Alfred Stansfeld, S. Khat use and mental illness: a critical review. Soc. Sci. Med., 2007, 65(2), 309-318.
[http://dx.doi.org/10.1016/j.socscimed.2007.04.038 PMID: 17544193]
[12]
Al-Motarreb, A.; Baker, K.; Broadley, K.J. Khat: pharmacological and medical aspects and its social use in Yemen. Phytother. Res., 2002, 16(5), 403-413.
[http://dx.doi.org/10.1002/ptr.1106] [PMID: 12203257]
[13]
Berihu, B.A.; Asfeha, G.G.; Welderufael, A.L.; Debeb, Y.G.; Zelelow, Y.B.; Beyene, H.A. Toxic effect of khat (Catha edulis) on memory: Systematic review and meta-analysis. J. Neurosci. Rural Pract., 2017, 8(01), 030-037.
[14]
Getasetegn, M. Chemical composition of Catha edulis (khat): a review. Phytochem. Rev., 2016, 15(5), 907-920.
[http://dx.doi.org/10.1007/s11101-015-9435-z]
[15]
Astatkie, A.; Demissie, M.; Berhane, Y.; Worku, A. Prevalence of and factors associated with regular khat chewing among university students in Ethiopia. Subst. Abuse Rehabil., 2015, 6, 41-50.
[http://dx.doi.org/10.2147/SAR.S78773] [PMID: 25750551]
[16]
Ayano, G.; Yohannis, K.; Abraha, M. Epidemiology of khat (Catha edulis) consumption among university students: a meta-analysis. BMC Public Health, 2019, 19(1), 150.
[http://dx.doi.org/10.1186/s12889-019-6495-9] [PMID: 30717743]
[17]
Chauhan, N.S.; Sharma, V.; Dixit, V.K.; Thakur, M. A review on plants used for improvement of sexual performance and virility. BioMed Res. Int., 2014, 2014868062
[http://dx.doi.org/10.1155/2014/868062] [PMID: 25215296]
[18]
Reda, A.A.; Moges, A.; Biadgilign, S.; Wondmagegn, B.Y. Prevalence and determinants of khat (Catha edulis) chewing among high school students in eastern Ethiopia: a cross-sectional study. PLoS One, 2012, 7(3)e33946
[http://dx.doi.org/10.1371/journal.pone.0033946] [PMID: 22479484]
[19]
Alele, P.E.; Ajayi, A.M.; Imanirampa, L. Chronic khat (Catha edulis) and alcohol marginally alter complete blood counts, clinical chemistry, and testosterone in male rats. J. Exp. Pharmacol., 2013, 2013(5), 33.
[http://dx.doi.org/10.2147/JEP.S46635] [PMID: 24348075]
[20]
Al-Shahrani, Z.; Al-Rawaji, A.; Al-Madouj, A.; Hayder, M.; Al-Zahrani, A.; Al-Mutlaq, H.; Bazarbashi, S. Cancer incidence report Saudi Arabia 2014; Saudi Cancer Registry, 2017, pp. 1-81.
[21]
Beckerleg, S. East African discourses on khat and sex. J. Ethnopharmacol., 2010, 132(3), 600-606.
[http://dx.doi.org/10.1016/j.jep.2010.08.057] [PMID: 20832464]
[22]
Byrns, M.C.; Penning, T.M. Type 5 17β-hydroxysteroid dehydrogenase/prostaglandin F synthase (AKR1C3): role in breast cancer and inhibition by non-steroidal anti-inflammatory drug analogs. Chem. Biol. Interact., 2009, 178(1-3), 221-227.
[http://dx.doi.org/10.1016/j.cbi.2008.10.024] [PMID: 19010312]
[23]
Carvalho, F. The toxicological potential of khat. J. Ethnopharmacol., 2003, 87(1), 1-2.
[http://dx.doi.org/10.1016/S0378-8741(03)00100-4] [PMID: 12787946]
[24]
Dimba, E.A.; Gjertsen, B.T.; Bredholt, T.; Fossan, K.O.; Costea, D.E.; Francis, G.W.; Johannessen, A.C.; Vintermyr, O.K. Khat (Catha edulis)-induced apoptosis is inhibited by antagonists of caspase-1 and -8 in human leukaemia cells. Br. J. Cancer, 2004, 91(9), 1726-1734.
[http://dx.doi.org/10.1038/sj.bjc.6602197] [PMID: 15477863]
[25]
Kebede, D.; Alem, A.; Mitike, G.; Enquselassie, F.; Berhane, F.; Abebe, Y.; Ayele, R.; Lemma, W.; Assefa, T.; Gebremichael, T. Khat and alcohol use and risky sex behaviour among in-school and out-of-school youth in Ethiopia. BMC Public Health, 2005, 5(1), 109.
[http://dx.doi.org/10.1186/1471-2458-5-109] [PMID: 16225665]
[26]
Xu, D.; Aka, J.A.; Wang, R.; Lin, S-X. 17beta-hydroxysteroid dehydrogenase type 5 is negatively correlated to apoptosis inhibitor GRP78 and tumor-secreted protein PGK1, and modulates breast cancer cell viability and proliferation. J. Steroid Biochem. Mol. Biol., 2017, 171, 270-280.
[http://dx.doi.org/10.1016/j.jsbmb.2017.04.009] [PMID: 28457968]
[27]
Hassan, N.A.; Gunaid, A.A.; Murray-Lyon, I.M. Khat (Catha edulis): health aspects of khat chewing. East. Mediterr. Health J., 2007, 13(3), 706-718.
[PMID: 17687845]
[28]
Odenwald, M.; Klein, A.; Warfa, N. Introduction to the special issue: the changing use and misuse of khat (Catha edulis)--tradition, trade and tragedy. J. Ethnopharmacol., 2010, 132(3), 537-539.
[http://dx.doi.org/10.1016/j.jep.2010.11.012] [PMID: 21115151]
[29]
Filimonov, D.; Lagunin, A.; Gloriozova, T.; Rudik, A.; Druzhilovskii, D.; Pogodin, P.; Poroikov, V. Prediction of the biological activity spectra of organic compounds using the PASS online web resource. Chem. Heterocycl. Compd., 2014, 50(3), 444-457.
[http://dx.doi.org/10.1007/s10593-014-1496-1]
[30]
Mohler, M.L.; Narayanan, R.; He, Y.; Miller, D.D.; Dalton, J.T. Hydroxysteroid dehydrogenase (17β-HSD3, 17β-HSD5, and 3α-HSD3) inhibitors: Extragonadal regulation of intracellular sex steroid hormone levels. Recent Pat. Endocr. Metab. Immune Drug Discov., 2007, 1(2), 103-118.
[http://dx.doi.org/10.2174/187221407780831957]
[31]
Nakamura, Y.; Hornsby, P.J.; Casson, P.; Morimoto, R.; Satoh, F.; Xing, Y.; Kennedy, M.R.; Sasano, H.; Rainey, W.E. Type 5 17β-hydroxysteroid dehydrogenase (AKR1C3) contributes to testosterone production in the adrenal reticularis. J. Clin. Endocrinol. Metab., 2009, 94(6), 2192-2198.
[http://dx.doi.org/10.1210/jc.2008-2374] [PMID: 19336506]
[32]
Marchais-Oberwinkler, S.; Henn, C.; Möller, G.; Klein, T.; Negri, M.; Oster, A.; Spadaro, A.; Werth, R.; Wetzel, M.; Xu, K.; Frotscher, M.; Hartmann, R.W.; Adamski, J. 17β-Hydroxysteroid dehydrogenases (17β-HSDs) as therapeutic targets: protein structures, functions, and recent progress in inhibitor development. J. Steroid Biochem. Mol. Biol., 2011, 125(1-2), 66-82.
[http://dx.doi.org/10.1016/j.jsbmb.2010.12.013] [PMID: 21193039]
[33]
Poirier, D. 17β-Hydroxysteroid dehydrogenase inhibitors: a patent review. Expert Opin. Ther. Pat., 2010, 20(9), 1123-1145.
[http://dx.doi.org/10.1517/13543776.2010.505604] [PMID: 20645882]
[34]
Qin, K.; Ehrmann, D.A.; Cox, N.; Refetoff, S.; Rosenfield, R.L. Identification of a functional polymorphism of the human type 5 17β-hydroxysteroid dehydrogenase gene associated with polycystic ovary syndrome. J. Clin. Endocrinol. Metab., 2006, 91(1), 270-276.
[http://dx.doi.org/10.1210/jc.2005-2012] [PMID: 16263811]
[35]
Gashawa, A.; Getachew, T. The chemistry of khat and adverse effect of khat chewing. Am. Sci. Res. J. Eng. Technol. Soc., 2014, 9(1), 35-46.
[36]
Szendrei, K. The chemistry of khat. Bull. Narc., 1980, 32(3), 5-35.
[PMID: 6911031]
[37]
Molecular Operating Environment (MOE). Chemical Computing Group Inc; 1010 Sherbooke St. West, Suite #910, Montreal, QC, Canada, H3A 2R7. 2019.
[38]
Amano, Y.; Yamaguchi, T.; Niimi, T.; Sakashita, H. Structures of complexes of type 5 17β-hydroxysteroid dehydrogenase with structurally diverse inhibitors: insights into the conformational changes upon inhibitor binding. Acta Crystallogr. D Biol. Crystallogr., 2015, 71(Pt 4), 918-927.
[http://dx.doi.org/10.1107/S1399004715002175] [PMID: 25849402]
[39]
Case, D.A. Ben-Shalom, Brozell, I.Y.; Cerutti, S.R.D.S.; Cheatham, T.E.; Cruzeiro, V.W.D.; Darden, T.A.; Duke, R.E.; Giambasu, G.; Gilson, M.K.; Gohlke, H.; Goetz, A.W.; Harris, R.; Izadi, S.; Izmailov, S.A.; Kasavajhala, K.; Kovalenko, A.; Krasny, R.; Kurtzman, T.; Lee, T.S.; LeGrand, S.; Li, P.; Lin, C.; Liu, J.; Luchko, T.; Luo, R.; Man, V.; Merz, K.M.; Miao, Y.; Mikhailovskii, O.; Monard, G.; Nguyen, H.; Onufriev, A.; Pan, F.; Pantano, S.; Qi, R.; Roe, D.R.; Roitberg, A.; Sagui, C.; Schott-Verdugo, S.; Shen, J.; Simmerling, C.L.; Skrynnikov, N.R.; Smith, J.; Swails, J.; Walker, R.C.; Wang, J.; Wilson, L.; Wolf, R.M.; Wu, X.; Xiong, Y.; Xue, Y.; York, D.M.; Kollman, P.A. AMBER 16; University of California: San Francisco, 2016.
[40]
Miyamoto, S.; Kollman, P.A. Settle: An analytical version of the SHAKE and RATTLE algorithm for rigid water models. J. Comput. Chem., 1992, 13(8), 952-962.
[http://dx.doi.org/10.1002/jcc.540130805]
[41]
Roe, D.R.; Cheatham, T.E. III PTRAJ and CPPTRAJ: software for processing and analysis of molecular dynamics trajectory data. J. Chem. Theory Comput., 2013, 9(7), 3084-3095.
[http://dx.doi.org/10.1021/ct400341p] [PMID: 26583988]
[42]
Humphrey, W.; Dalke, A.; Schulten, K. VMD: visual molecular dynamics. J. Mol. Graph., 1996, 14(1), 33-38. 27-28
[http://dx.doi.org/10.1016/0263-7855(96)00018-5] [PMID: 8744570]
[43]
Genheden, S.; Ryde, U. The MM/PBSA and MM/GBSA methods to estimate ligand-binding affinities. Expert Opin. Drug Discov., 2015, 10(5), 449-461.
[http://dx.doi.org/10.1517/17460441.2015.1032936] [PMID: 25835573]
[44]
Daina, A.; Michielin, O.; Zoete, V. SwissADME: a free web tool to evaluate pharmacokinetics, drug-likeness and medicinal chemistry friendliness of small molecules. Sci. Rep., 2017, 7, 42717.
[http://dx.doi.org/10.1038/srep42717] [PMID: 28256516]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version485msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[08:32:32] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[08:32:32] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[08:32:32] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[08:32:32] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[08:32:32] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[08:32:32] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (146ms)time
  • Application (340ms)time
  • 1 x Application (70%)
    340ms
    1 x Booting (30%)
    146ms
    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 duplicated235ms
    • 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 ('314383442','',1,1740472352,1740472352) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740472352
      1.81msalphaeurekaselec_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 ('314383442','/article/110444',1,1740472352,1740472352)
      260μ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 >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) 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 >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) 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 >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) 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 >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) 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 >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) 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 >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314383442 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314383442) limit 1
      18.56msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314383442
      • 1: 314383442
      • 2: 314383442
      • 3: 314383442
      • 4: 314383442
      • 5: 314383442
      • 6: 314383442
      • 7: 314383442
      • 8: 314383442
      • 9: 314383442
      • 10: 314383442
      • 11: 314383442
      • 12: 314383442
      • 13: 314383442
      • 14: 314383442
      • 15: 314383442
      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=110444
      1.21msalphaeurekaselec_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` = 50 limit 1
      1.04msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 50
      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=50) and sj.journal_id!=50 group by `j`.`nid`) as `aggregate_table`
      1.55msalphaeurekaselec_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=50) and sj.journal_id!=50 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.38msalphaeurekaselec_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=50) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.12msalphaeurekaselec_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=50) 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.93msalphaeurekaselec_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` = '110444'
      4.12msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 110444
      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` = '110444'
      3.03msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 110444
      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` = '110444' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      4.27msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 110444
      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
      560μ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
      690μ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 = 50 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      51.85msalphaeurekaselec_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 = 50 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      14.71msalphaeurekaselec_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 = 50 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      7.31msalphaeurekaselec_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` = 110444 limit 1
      270μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 110444
      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 = 110444 and content_type = 'article' order by status desc limit 1
      300μ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 = 478 and content_id!=110444 and cd.content_type = 'article' order by rand() limit 20
      67.84msalphaeurekaselec_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` = 186607 limit 1
      900μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 186607
      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
      550μ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` = 'MC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      400μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: MC
      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 = '110444' 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) )
      400μ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 = '10456' 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) )
      420μ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 = '2927' 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) )
      420μ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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740472352 and j.to_date >= 1740472352 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2927) 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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740472352 and j.to_date >= 1740472352 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2927) 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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740472352 and j.to_date >= 1740472352 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2927)
      35.96msalphaeurekaselec_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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740472352 and j.to_date >= 1740472352 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10456) 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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740472352 and j.to_date >= 1740472352 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10456) 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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740472352 and j.to_date >= 1740472352 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10456)
      930μ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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740472352 and j.to_date >= 1740472352 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 110444) 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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740472352 and j.to_date >= 1740472352 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 110444) 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 <= 314383442 and j.to_ip >=314383442 )) and ((j.from_date <= 1740472352 and j.to_date >= 1740472352 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 110444)
      880μ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` < '418' and is_uploaded = 1 and issue_id = 10456 order by cast(first_page as SIGNED) desc limit 1
      780μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 418
      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` > '428' and is_uploaded = 1 and issue_id = 10456 order by cast(first_page as SIGNED) asc limit 1
      570μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 428
      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'
      220μ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
      290μ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` = 110444 limit 1
      3.61msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 110444
      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` = 50 and `b`.`banner_from_date` <= 1740472352 and `b`.`banner_to_date` >= 1740472352 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.65msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 50
      • 3: 1740472352
      • 4: 1740472352
      • 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` = 50 and `b`.`banner_from_date` <= 1740472352 and `b`.`banner_to_date` >= 1740472352 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.53msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 50
      • 3: 1740472352
      • 4: 1740472352
      • 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='8473c314221ec1e6bf8807f596ec14c4'
      290μ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
        O81sOnkWiCopZ0sCAg0OIdOaRgPdCajelrCa5938
        uc_cart_id
        8473c314221ec1e6bf8807f596ec14c4
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/110444" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/110444
        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, 25 Feb 2025 08:32:32 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlVOWTllSk5YRmdEZjM1QnZNVTNNdVE9PSIsInZhbHVlIjoiZkxGM3ZjT3ZGUWxYTm1oc1VXT0g3VXVTRkpET1NTbnJ2Qnc2ZEJhbjlMbWpMOWNrMCsyRnZ1UCtraUhYSGpxVFRCVjkxQVhQVER1VlZscUp2RllFSEcvUW14Ujk3ODBEZkNHQ04rOU5LOHhvUGVXS3U2bmExQVVCQUp5OGo2R0QiLCJtYWMiOiJkODNjYmRlZjkyZmNjOWRjMmZkNmNlODg4ODA5MWViZGY5NDRjNGE5YjU4ZmYyYzA1YmYxMzgzMjU4YzU4Y2NiIiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 20:32:32 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlVOWTllSk5YRmdEZjM1QnZNVTNNdVE9PSIsInZhbHVlIjoiZkxGM3ZjT3ZGUWxYTm1oc1VXT0g3VXVTRkpET1NTbnJ2Qnc2ZEJhbjlMbWpMOWNrMCsyRnZ1UCtraUhYSGpxVFRCVjkxQ" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImI1L0VWNzdPWnhxNnM5eVdBVjVPUmc9PSIsInZhbHVlIjoiMExuQnFHYldnbjAwTlRvbVFMZThRd0hBNEc0a0Z2S2s2V2RVVTRrTUtNaTI1cnRTbjVTMTRzVWt1WnpHYS9xL2ZkalAwNTVKVTYzK1ZHY2tDczZSaTJOR3VZSHlHM3ZYSlViV1pKMnlDRXN6Sjhmd21SUVp6cFBtd1Q3UXNVU1QiLCJtYWMiOiIzNjdjZmNjMjU1NjM2MzgyZTVlMzY5MWVmYzYwMmNjNzgxZmU1MzU0NjA5ZTVmNjlkMGVmNjc2NmU2MWVjYjIwIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6ImI1L0VWNzdPWnhxNnM5eVdBVjVPUmc9PSIsInZhbHVlIjoiMExuQnFHYldnbjAwTlRvbVFMZThRd0hBNEc0a0Z2S2s2V2RVVTRrTUtNaTI1cnRTbjVTMTRzVWt" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlVOWTllSk5YRmdEZjM1QnZNVTNNdVE9PSIsInZhbHVlIjoiZkxGM3ZjT3ZGUWxYTm1oc1VXT0g3VXVTRkpET1NTbnJ2Qnc2ZEJhbjlMbWpMOWNrMCsyRnZ1UCtraUhYSGpxVFRCVjkxQVhQVER1VlZscUp2RllFSEcvUW14Ujk3ODBEZkNHQ04rOU5LOHhvUGVXS3U2bmExQVVCQUp5OGo2R0QiLCJtYWMiOiJkODNjYmRlZjkyZmNjOWRjMmZkNmNlODg4ODA5MWViZGY5NDRjNGE5YjU4ZmYyYzA1YmYxMzgzMjU4YzU4Y2NiIiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 20:32:32 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlVOWTllSk5YRmdEZjM1QnZNVTNNdVE9PSIsInZhbHVlIjoiZkxGM3ZjT3ZGUWxYTm1oc1VXT0g3VXVTRkpET1NTbnJ2Qnc2ZEJhbjlMbWpMOWNrMCsyRnZ1UCtraUhYSGpxVFRCVjkxQ" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImI1L0VWNzdPWnhxNnM5eVdBVjVPUmc9PSIsInZhbHVlIjoiMExuQnFHYldnbjAwTlRvbVFMZThRd0hBNEc0a0Z2S2s2V2RVVTRrTUtNaTI1cnRTbjVTMTRzVWt1WnpHYS9xL2ZkalAwNTVKVTYzK1ZHY2tDczZSaTJOR3VZSHlHM3ZYSlViV1pKMnlDRXN6Sjhmd21SUVp6cFBtd1Q3UXNVU1QiLCJtYWMiOiIzNjdjZmNjMjU1NjM2MzgyZTVlMzY5MWVmYzYwMmNjNzgxZmU1MzU0NjA5ZTVmNjlkMGVmNjc2NmU2MWVjYjIwIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6ImI1L0VWNzdPWnhxNnM5eVdBVjVPUmc9PSIsInZhbHVlIjoiMExuQnFHYldnbjAwTlRvbVFMZThRd0hBNEc0a0Z2S2s2V2RVVTRrTUtNaTI1cnRTbjVTMTRzVWt" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "O81sOnkWiCopZ0sCAg0OIdOaRgPdCajelrCa5938" "uc_cart_id" => "8473c314221ec1e6bf8807f596ec14c4" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/110444" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 08:32:32GET/article/110444614371