Generic placeholder image

Mini-Reviews in Medicinal Chemistry

Editor-in-Chief

ISSN (Print): 1389-5575
ISSN (Online): 1875-5607

Research Article

Synthesis, Docking Studies into CDK-2 and Anticancer Activity of New Derivatives Based Pyrimidine Scaffold and Their Derived Glycosides

Author(s): Adel A.H. Abdel Rahman, Ibrahim F. Nassar*, Amira K.F. Shaban, Dina S. EL-Kady, Hanem M. Awad and Wael A. El Sayed*

Volume 19, Issue 13, 2019

Page: [1093 - 1110] Pages: 18

DOI: 10.2174/1389557519666190312165717

Price: $65

Abstract

Background & Objective: New diaryl-substituted pyrimidinedione compounds, their thioxo derivatives as well as their bicyclic thiazole compounds were synthesized and characterized.

Methods: The glycosylamino derivatives of the synthesized disubstituted derivatives of the pyrimidine scaffold were also prepared via reaction of the N3-amino derivatives with a number of monosaccharides followed by acetylation.

Results: The anticancer activity of the synthesized compounds was studied against human liver cancer (HepG2) and RPE-1cell lines. Compounds 2a, 2b, 3a and 12 showed potent activities with IC50 results comparable to that of doxorubicin.

Conclusion: Docking investigations into Cyclin-dependent kinase 2 (CDK-2) enzyme, a potential target for cancer medication, were also reported showing the possible binding interaction into the enzyme active site to support their activity behavior.

Keywords: Pyrimidine, thiopyrimidine, thiazolopyrimidine, glycosides, anticancer, HepG2, Docking, CDK2.

« Previous
Graphical Abstract

[1]
Morgan, D.O. The cell cycle: Principles of control, 1st ed; , 2007. New Science Press: London.
[2]
Lee, M.G.; Nurse, P. Complementation used to clone a human homologue of the fission yeast cell cycle control gene cdc2. Nature, 1987, 327, 31-35.
[3]
Peyressatre, M.; Prével, C.; Pellerano, M.; Morris, M.C. Targeting cyclin-dependent kinases in human cancers: From small molecules to peptide inhibitors. Cancers, 2015, 7, 179-237.
[4]
Rossi, A.G.; Sawatzky, D.A.; Walker, A.; Ward, C.; Sheldrake, T.A.; Riley, N.A.; Caldicott, A.; Martinez-Losa, M.; Walker, T.R.; Duffin, R.; Gray, M.; Crescenzi, E.; Martin, M.C.; Brady, H.J.; Savill, J.S.; Dransfield, I.; Haslett, C. Cyclin-dependent kinase inhibitors enhance the resolution of inflammation by promoting inflammatory cell apoptosis. Nat. Med., 2006, 12, 1056-1064.
[5]
Senderowicz, A.M. Flavopiridol the first cyclin-dependent kinase inhibitor in human clinical trials. Invest. New Drugs, 1999, 17, 313-320.
[6]
Abdel Mohsen, H.T.; Ragab, F.A.F.; Ramla, M.M.; El Diwani, H.I. Novel benzimidazole-pyrimidine conjugates as potent antitumor agents. Eur. J. Med. Chem., 2010, 45, 2336-2344.
[7]
Yoon, J.S.; Jarhad, D.B.; Kim, G.L.; Zhao, X.; Yu, J.; Kim, H-R.; Lee, J.Y.; Mulamoottil, V.A.; Chandra, G.; Byun, W.S.; Lee, S.K.; Kim, Y-C.; Jeong, L.S. Design, synthesis and anticancer activity of fluorocyclopentenyl-purines and - pyrimidines. Eur. J. Med. Chem., 2018, 155, 406-417.
[8]
Ramiz, M.M.M.; El-Sayed, W.A.; Hagag, E.; Abdel-Rahman, A.A-H. Synthesis and antiviral activity of new substituted pyrimidine Glycosides. J. Heterocycl. Chem., 2011, 48, 1028-1038.
[9]
Pertusati, F.; Serafini, S.; Albadry, N.; Snoeck, R.; Andrei, G. Phosphonoamidate pro drugs of C5-substituted pyrimidine acyclic nucleosides for antiviral therapy. Antiviral Res., 2017, 143, 262-268.
[10]
Bai, S.; Liu, S.; Zhu, Y.; Wu, Q. Asymmetric synthesis and antiviral activity of novel chiral amino-pyrimidine derivatives. Tetrahedron Lett., 2018, 59, 3179-3183.
[11]
Summa, V.; Petrocchi, A.; Bonelli, F.; Crescenzi, B.; Donghi, M.; Ferrara, M.; Fiore, F.; Gardelli, C.; Paz, O.G.; Hazuda, D.J.; Jones, P.; Kinzel, O.; Laufer, R.; Monteagudo, E.; Muraglia, E.; Nizi, E. Orvieto, F.; Pace, P.; Pescatore, G.; Scarpelli, R.; Stillmock, K.; Witmer, M.V.; Rowley, M. Discovery of raltegravir, a potent, selective orally bioavailable HIV-integrase inhibitor for the treatment of HIV-AIDS infection. Med. Chem., 2008, 51, 5843-5855.
[12]
Deshmukh, M.B.; Salunkhe, S. M.; Patil, D. R.; Anbhule. P.V. A. novel an efficient one step synthesis of 2-amino-5-cyano-6-hydroxy-4-aryl pyrimidines and their anti-bacterial activity. Eur. J. Med. Chem., 2009, 44, 2651-2654.
[13]
Mai, A.; Rotili, D.; Massa, S.; Brosch, G.; Simonetti, G.; Passariello, C.; Palamara, A.T. Discovery of uracil-based histone deacetylase inhibitors able to reduce acquired antifungal resistance and trailing growth in Candida albicans. Bioorg. Med. Chem. Lett., 2007, 17, 1221-1225.
[14]
Gholap, A.R.; Toti, K.S.; Shirazi, F.; Deshpande, M.V.; Srinivasan, K.V. Efficient synthesis of antifungal pyrimidines via palladium catalyzed Suzuki/Sonogashira cross-coupling reaction from Biginelli 3,4-dihydropyrimidin-2(1H)-ones. Tetrahedron, 2008, 64, 10214-10223.
[15]
McCarthy, O.; Musso-Buendia, A.; Kaiser, M.; Brun, R.; Ruiz-Perez, L.M.; Johansson, N.G.; Pacanowska, D.G.; Gilbert, I.H. Design, synthesis and evaluation of novel uracil acetamide derivatives as potential inhibitors of Plasmodium falciparum dUTPnucleotide hydrolase. Eur. J. Med. Chem., 2009, 44, 678-688.
[16]
Singh, B.K.; Mishra, M.; Saxena, N.; Yadav, G.P.; Maulik, P.R.; Sahoo, M.K.; Gaur, R.L.; Murthy, P.K.; Tripathi, R.P. Synthesis of 2-sulfanyl-6-methyl-1,4-dihydropyrimidines as a new class of antifilarial agents. Eur. J. Med. Chem., 2008, 43, 2717-2723.
[17]
van der Westhuyzen, A.E. Frolova, L.V.; Kornienko, A.; van Otterlo W.A.L. The Rigidins: Isolation, bioactivity, and total synthesis-novel pyrrolo[2,3-d]pyrimidine analogues using multicomponent reactions. In the alkaloids: Chemistry and Biology. Chapter Four, 2018, 79, 191-220.
[18]
Gillespie, R.J.; Bamford, S.J.; Clay, A.; Gaur, S.; Haymes, T.; Jackson, P.S.; Jordan, A.M.; Klenke, B.; Leonardi, S.; Liu, J.; Mansell, H.L.; Ng, S.; Saadi, M.; Simmonite, H.; Stratton, G.C.; Todd, R.S.; Williamson, D.S.; Yule, I.A. Antagonists of the human A2A receptor. Part 6: Further optimization of pyrimidine-4-carboxamides. Bioorg. Med. Chem., 2009, 17, 6590-05.
[19]
Siddiqui, A.A.; Rajesh, R.; Islam, M.U.; Alagarsamy, V.; De Clercq, E. Synthesis, antiviral, antituberculostic, and antibacterial activities of some novel, 4-(4-substituted phenyl)-6-(4-nitrophenyl)-2-(substituted imino)pyrimidines). Arch. Pharm., 2007, 340, 95-102.
[20]
Haiba, M.E.; Fathalla, O.A.; Zeid, I.F.; Soliman, A.M.; Abd El-Moez, S.I.; El-serwy, W.S. Synthesis and evaluation of some novel tetrahydropyrimidine derivatives as antimicrobial and cytotoxic agents. Res. Chem. Intermed., 2013, 39, 3763-3774.
[21]
Singh, P. Paul. K. Anti-cancer activities of 5-acyl-6-[2-hydroxy/ benzyloxy-3-(amino)-propylamino]-1,3-dialkyl-1H-pyrimidin-2,4-diones. Bioorg. Med. Chem., 2006, 14, 8622-8625.
[22]
Geist, J.G.; Lauw, S.; Illarionova, V.; Illarionov, B.; Fischer, M.; Gräwert, T.; Rohdich, F.; Eisenreich, W.; Kaiser, J.; Groll, M.; Scheurer, C. Thiazolopyrimidine inhibitors of 2-methylerythritol 2,4-cyclodiphosphate synthase (IspF) from Mycobacterium tuberculosis and Plasmodium falciparum. ChemMedChem, 2010, 5, 1092-1101.
[23]
Amr, A.E-G.; Maigali, S.S.; Abdulla, M.M. Synthesis, and analgesic and antiparkinsonian activities of thiopyrimidine, pyrane, pyrazoline, and thiazolopyrimidine derivatives from 2-chloro-6-ethoxy-4-acetylpyridine. Monatsh. Chem., 2008, 139, 1409-1415.
[24]
Yousif1, M.N.M.; El-Sayed, W.A.; Abbas, H.S.; Awad, H.M.; Yousif, N.M. Cytotoxic activity of new substituted pyrimidines, their thioglycosides and thiazolopyrimidine derivatives. J. Appl. Pharm. Sci., 2017, 7, 21-32.
[25]
Flefel, E.M.; El-Sayed, W.A.; El-Sofany, W.; Mohamed, A.M.; Awad, H.M. Synthesis and anticancer activity of new 1-thia-4-azaspiro[4.5]decane, their derived thiazolopyrimidine and 1,3,4-thiadiazole thioglycosides. Molecules, 2017, 22, 170-183.
[26]
Rashad, A.E.; Shamroukh, A.H.; Abdel-Megeid, R.E.; El-Sayed, W.A. Synthesis, reactions and antimicrobial evaluation of some polycondensedthieno-pyrimidine derivatives. Synth. Commun., 2010, 40, 1149-1160.
[27]
Kolb, S.; Mondésert, O.; Goddard, M.L.; Jullien, D.; Villoutreix, B.O.; Ducommun, B.; Garbay, C.; Braud, E. Development of novel thiazolopyrimidines as CDC25B phosphatase inhibitors. ChemMedChem, 2009, 4, 633-648.
[28]
Zhi, H.; Chen, L.; Zhang, L.; Liu, S.; Wan, D.C.C.; Lin, H.; Hu, C. Design, synthesis, and biological evaluation of 5H-thiazolo[3,2- a]pyrimidine derivatives as a new type of acetylcholinesterase inhibitors. ARKIVOC, 2008, xiii, 266-277.
[29]
El-Sayed, W.A.; El-Sofany, W.I.; Hussein, H.A.R.; Fathy, N.M. Synthesis and anticancer activity of new [(Indolyl)pyrazolyl]-1,3,4-oxadiazole thioglycosides and acyclic nucleoside analogs. Nucleosides Nucleotides Nucleic Acids, 2017, 36, 474-495.
[30]
El Ashry, E.S.H.; Rashed, N.; Awad, L.F.; Ramadan, E.; Abdel-Mageed, S.M.; Rezki, N. Novel regioselective hydroxyl-alkylation of 4,5-diphenylimidazole-2-thione and A competitive intramolecular ring closure of the SHydroxyalkyl-Imidazoles to Imidazo[2,1-b]thiazines and thiazoles. Role of catalyst, microwave irradiation, and solid support. Nucleosides Nucleotides Nucleic Acids, 2007, 26, 423-435.
[31]
El-Sayed, W.A.; Abbas, H-A.S.; Abdel Mageid, R.E.; Magdziarz, T. Synthesis, antimicrobial activity and docking studies of new N-ethyl-3-indolyl heterocycles. Med. Chem. Res., 2016, 25, 339-355.
[32]
Kumar, G.; Aggarwal, H. Gupta. R. Cobalt Complexes Appended with para- and meta-Arylcarboxylic Acids: Influence of cation, solvent, and symmetry on hydrogen-bonded assemblies. Cryst. Growth Des., 2013, 13, 74-90.
[33]
Ali, A.; Hundal, G.; Gupta, R. Co3+ -based Building blocks with appended phenol and catechol groups: examples of placing hydrogen-bond donors and acceptors in a single molecule. Cryst. Growth Des., 2012, 12, 1308-1312.
[34]
Chou, Y.M. M.C. Lai, T.M. Hwang, C.W Ong. Bioorg. Med. Chem. Lett., 1999, 9, 2643-2646.
[35]
Alagarsamy, V.; U.S., Pathak; R., Revathi Anticancer, antibacterial and antifungal activities of some 2-substituted (1,3,4) thiadiazolothieno (3,2-e) - pyrimidin-5(4H)-onesInd, J. Heterocycl. Chem.,2003, 12, 335-338. (b) Abdullah, E.S.A. Synthesis and anticancer activity of some novel tetralin-6-yl-pyrazoline, 2-thioxopyrimidine, 2-oxopyridine, 2-thioxo-pyridine and 2-iminopyridine derivatives. Molecule, 2011, 16, 3410-3419.
[36]
Abdel-Mohsen, H.T.; Ragab, F.A.F.; Ramla, M.M.; Diwani, H.I.E. Novel benzimidazole-pyrimidine conjugates as potent antitumor agents. Eur. J. Med. Chem., 2010, 45, 2336-2344.
[37]
Jordheim, L.P.; Durantel, D.; Zoulim, F.; Dumontet, C. Advances of nuleosides and nucleotides analogs for cancer and viral diseases. Nat. Rev. Drug Discov., 2013, 12, 447-464.
[38]
Fahmy, H.T.Y.; Rostom, S.A.F.; Saudi, M.N.; Zjawiony, J.K.; Robins, D.J. Synthesis and antitumor evaluation of new polysubstituted thiazole and derived thiazolo[4,5-d]pyrimidine systems. Arch. Pharm. Pharm. Med. Chem., 2003, 3, 1-10.
[39]
El-Sayed, W.A.; Nassar, I.F.; Abdel Rahman, A.A-H. Synthesis and antitumor activity of new 1,2,4-triazine and [1,2,4]triazolo[4,3-b][1,2,4]triazine derivatives and their thioglycoside and acyclic C-Nucleoside analogous. J. Heterocycl. Chem., 2011, 48, 135-143.
[40]
El-Sayed, W.A.; Ali, O.M. l; Faheem, M.S.l Zied, I.F. Abdel-Rahman A.A.-H. Synthesis and antimicrobial activity of new 1,2,3-triazolopyrimidine derivatives and their glycoside and acyclic nucleoside analogs. J. Heterocycl. Chem., 2012, 49, 607-612.
[41]
El-Sayed, W.A.; Khalaf, H.S.; Mohamed, S.F.; Hssien, H.A.; Kutkat, O.M.; Amr, A.E.E. Synthesis and antiviral activity of 1,2,3-triazole glycosides based substituted pyridine via click cycloaddition. Russ. J. Gen. Chem., 2017, 87, 2444-2453.
[42]
Nassar, I.F. Synthesis and antitumor activity of new substituted mercapto‐1,2,4‐triazine derivatives, their thioglycosides, and Acyclic thioglycoside analogs. J. Heterocycl. Chem., 2013, 50, 129-134.
[43]
Nassar, I.F.; Atta-Allah, S.R.; Elgazwy, A.S.H. A convenient synthesis and molecular modeling study of Novel Pyrazolo[3,4-d]pyrimidine and Pyrazole derivatives as antitumor agents. J. Enzyme Inhib. Med. Chem., 2015, 30, 396-405.
[44]
Nassar, I.F.; El-Sayed, W.A.; Ragab, T.I.M.; Shalaby, A.S.G.; Mehany, A.B.M. Design, synthesis of novel pyridine and pyrimidine sugar compounds as antagonists targeting the ERα via structurebased virtual screening mini reviews in medicinal chemistry (DOI: 10.2174/1389557518666180820125210).
[45]
Mahato, S.; Chatterjee, R.; Santra, S.; Zyryanov, G.V.; Hajra, A.; Majee, A.A. Domino Approach for the Synthesis of a-Iodo-b-dicarbonyl Compounds from a-Epoxycarbonyls. ChemistrySelect, 2017, 2, 6254-6259.
[46]
Hamdy, N.A.; Anwar, M.M.; Abu-Zied, K.M.; Awad, H.M. Synthesis, tumor inhibitory and antioxidant activity of new polyfunctionally 2-substituted 5,6,7,8-tetrahydronaphthalene derivatives containing pyridine, thioxopyridine and pyrazolopyridine moieties. Acta Poloniae Pharmaceutica -. Drug Res., 2013, 70, 987-1001.
[47]
Almajhdi, F.N.; Fouad, H.; Khalil, K.A.; Awad, H.M.; Mohamed, S.H.S.; Elsarnagawy, T.; Albarrag, A.M.; Al-Jassir, F.F.; Abdo, H.S. In-vitro anticancer and antimicrobial activities of PLGA/silver nanofibers composites prepared by electrospinning. J. Mater. Sci. Mater. Med., 2014, 25, 1-9.
[48]
Staker, B.L.; Feese, M.D.; Cushman, M.; Pommier, Y.; Zembower, D.; Stewart, L. Structure of three classes of anticancer agents bound to the human topoisomerase I-DNA covalent complex. J. Med. Chem., 2005, 48, 2336-2345.
[49]
Kaminski, G.; Jorgensen, W. L Performance of the AMBER94, MMFF94 and OPLS-AA force fields for modeling organic liquids. J. Phys. Chem., 1996, 100, 18010-13013.
[50]
Lensink, M.F.; Méndez, R.; Wodak, S.J. Docking and scoring protein complexes: CAPRI 3rd Edition. Proteins 2007, 69, 704- 718.
[51]
Flefel, E.E.; Salama, M.A.; El-Shahat, M.; El-Hashash, M.A.; El-Farargy, A.F. A Novel synthesis of some new pyrimidine and thiazolopyrimidine derivatives for anticancer evaluation. Phosphorus, Sulfur, and Silicon, 2007, 182, 1739-1756.
[52]
Abdel-Megeed, M.F.; Saleh, M.A.; Abdo, M.A.; El-Hiti, G.A. Reaction of 6-substituted 3-amino-2-phenyl-4(3H)-quinazolinones with D-ribose and L-arabinose. Collect. Czech. Chem. Commun., 1995, 60, 1016-1025.
[53]
El-Sayed, W.A.; Abdel-Rahman, A.A-H.; Ramiz, M.M.M. Anti-Hepatitis B virus activity of new N4-β-D-glycoside pyrazolo[3,4-d]pyrimidine derivatives. Zeitschriftfür Naturforschung, 2009, 64c, 323-328.
[54]
Gorin, P.; Mazurek, M. Further studies on the assignment of signals in 13C magnetic resonance spectra of aldoses and derived methyl glycosides. Can. J. Chem., 1975, 53, 1212-1223.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version329msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[04:19:53] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[04:19:53] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[04:19:53] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (91.97ms)time
  • Application (237ms)time
  • 1 x Application (72.08%)
    237ms
    1 x Booting (27.92%)
    91.97ms
    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 duplicated160ms
    • 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 ('314545352','',1,1740457193,1740457193) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740457193
      1.16msalphaeurekaselec_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 ('314545352','/article/97274',1,1740457193,1740457193)
      180μ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 >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) 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 >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) 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 >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) 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 >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) 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 >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) 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 >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314545352 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314545352) limit 1
      15.63msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314545352
      • 1: 314545352
      • 2: 314545352
      • 3: 314545352
      • 4: 314545352
      • 5: 314545352
      • 6: 314545352
      • 7: 314545352
      • 8: 314545352
      • 9: 314545352
      • 10: 314545352
      • 11: 314545352
      • 12: 314545352
      • 13: 314545352
      • 14: 314545352
      • 15: 314545352
      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=97274
      940μ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` = 56 limit 1
      1.07msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 56
      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=56) and sj.journal_id!=56 group by `j`.`nid`) as `aggregate_table`
      1.56msalphaeurekaselec_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=56) and sj.journal_id!=56 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.3msalphaeurekaselec_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=56) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.83msalphaeurekaselec_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=56) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      2.37msalphaeurekaselec_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` = '97274'
      1.56msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 97274
      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` = '97274'
      2.2msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 97274
      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` = '97274' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.75msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 97274
      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
      230μ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
      460μ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 = 56 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      34.14msalphaeurekaselec_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 = 56 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      14.81msalphaeurekaselec_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 = 56 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      13.91msalphaeurekaselec_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` = 97274 limit 1
      1.17msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 97274
      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 = 97274 and content_type = 'article' order by status desc limit 1
      1.73msalphaeurekaselec_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 = 465 and content_id!=97274 and cd.content_type = 'article' order by rand() limit 20
      40.2msalphaeurekaselec_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` = 170670 limit 1
      280μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 170670
      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
      270μ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` = 'MRMC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      360μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: MRMC
      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 = '97274' and content_type = 'a' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      430μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2186
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '9174' 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) )
      360μ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 = '2608' 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) )
      320μ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 <= 314545352 and j.to_ip >=314545352 )) and ((j.from_date <= 1740457193 and j.to_date >= 1740457193 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2608) 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 <= 314545352 and j.to_ip >=314545352 )) and ((j.from_date <= 1740457193 and j.to_date >= 1740457193 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2608) 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 <= 314545352 and j.to_ip >=314545352 )) and ((j.from_date <= 1740457193 and j.to_date >= 1740457193 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2608)
      10.37msalphaeurekaselec_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 <= 314545352 and j.to_ip >=314545352 )) and ((j.from_date <= 1740457193 and j.to_date >= 1740457193 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9174) 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 <= 314545352 and j.to_ip >=314545352 )) and ((j.from_date <= 1740457193 and j.to_date >= 1740457193 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9174) 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 <= 314545352 and j.to_ip >=314545352 )) and ((j.from_date <= 1740457193 and j.to_date >= 1740457193 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9174)
      610μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2297
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 314545352 and j.to_ip >=314545352 )) and ((j.from_date <= 1740457193 and j.to_date >= 1740457193 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 97274) 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 <= 314545352 and j.to_ip >=314545352 )) and ((j.from_date <= 1740457193 and j.to_date >= 1740457193 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 97274) 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 <= 314545352 and j.to_ip >=314545352 )) and ((j.from_date <= 1740457193 and j.to_date >= 1740457193 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 97274)
      580μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2329
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `article` where `first_page` < '1093' and is_uploaded = 1 and issue_id = 9174 order by cast(first_page as SIGNED) desc limit 1
      560μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 1093
      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` > '1110' and is_uploaded = 1 and issue_id = 9174 order by cast(first_page as SIGNED) asc limit 1
      480μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 1110
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      180μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      250μ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` = 97274 limit 1
      2.43msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 97274
      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` = 56 and `b`.`banner_from_date` <= 1740457193 and `b`.`banner_to_date` >= 1740457193 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.14msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 56
      • 3: 1740457193
      • 4: 1740457193
      • 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` = 56 and `b`.`banner_from_date` <= 1740457193 and `b`.`banner_to_date` >= 1740457193 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.08msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 56
      • 3: 1740457193
      • 4: 1740457193
      • 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='5ab831df59bfbe8cedc3af83f5a51b1b'
      240μ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
        Ir6dy1RrRHMhGXDLT5soe8C7eHrWDIWALDOp4nlV
        uc_cart_id
        5ab831df59bfbe8cedc3af83f5a51b1b
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/97274" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/97274
        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 04:19:53 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjdrRWlXTnJMRXY2c0VUSUJEZENaOWc9PSIsInZhbHVlIjoiUTAxWk1KbDhwYUVFUGJoTjNsVzR4NE1Sd3lzNjVDQ2xRODYyYkhpWEplZVpqNmR3djJSQ2JUNXBwNGZwK1JqUXBwdVJGL012NlNYWGpUTCtwSzFCV3BLK2dTc0lBbGxsL2VpVk4zcVpYelZzeHRrcWhSLzRTU1ZHUjVOd05ySWwiLCJtYWMiOiI2OGMxN2UyNDBjODBiNTZiM2RhMWRjZTI2MWI1MzkxYjUwMjliZDVlMzU0NGEwMDAyMTlmYzQwNTRiMjJmYWVjIiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 16:19:53 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjdrRWlXTnJMRXY2c0VUSUJEZENaOWc9PSIsInZhbHVlIjoiUTAxWk1KbDhwYUVFUGJoTjNsVzR4NE1Sd3lzNjVDQ2xRODYyYkhpWEplZVpqNmR3djJSQ2JUNXBwNGZwK1JqUXBwdVJGL" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkhLc3VXTU84M1VreWo1YkNYelloVXc9PSIsInZhbHVlIjoiNnYvR1F0R3hrOExDOFd0RXBNNlpoeEdYQkJNQk1PdXdiLzY1TEhqYlovK2Z3L05KMjBSRXFGUnFqQ29kSGZmN3BPU1NTbFp1K0NuQjF4M2tldUJwcU03VVNOajdsS2hkTStiMG1uTVk1QjNoS3V4ODNEM1NkK3hzZm1SZWxkNm8iLCJtYWMiOiJmYTg3OWNkZTA4YjEwNTg0OWI5Mzk1MzY3ZDI3MmEzMWMzZjdjMzQ5NWE0ZDc1ZmFiNWEyYjg0ZTAxYzQ2MjViIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkhLc3VXTU84M1VreWo1YkNYelloVXc9PSIsInZhbHVlIjoiNnYvR1F0R3hrOExDOFd0RXBNNlpoeEdYQkJNQk1PdXdiLzY1TEhqYlovK2Z3L05KMjBSRXFGUnF" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjdrRWlXTnJMRXY2c0VUSUJEZENaOWc9PSIsInZhbHVlIjoiUTAxWk1KbDhwYUVFUGJoTjNsVzR4NE1Sd3lzNjVDQ2xRODYyYkhpWEplZVpqNmR3djJSQ2JUNXBwNGZwK1JqUXBwdVJGL012NlNYWGpUTCtwSzFCV3BLK2dTc0lBbGxsL2VpVk4zcVpYelZzeHRrcWhSLzRTU1ZHUjVOd05ySWwiLCJtYWMiOiI2OGMxN2UyNDBjODBiNTZiM2RhMWRjZTI2MWI1MzkxYjUwMjliZDVlMzU0NGEwMDAyMTlmYzQwNTRiMjJmYWVjIiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 16:19:53 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjdrRWlXTnJMRXY2c0VUSUJEZENaOWc9PSIsInZhbHVlIjoiUTAxWk1KbDhwYUVFUGJoTjNsVzR4NE1Sd3lzNjVDQ2xRODYyYkhpWEplZVpqNmR3djJSQ2JUNXBwNGZwK1JqUXBwdVJGL" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkhLc3VXTU84M1VreWo1YkNYelloVXc9PSIsInZhbHVlIjoiNnYvR1F0R3hrOExDOFd0RXBNNlpoeEdYQkJNQk1PdXdiLzY1TEhqYlovK2Z3L05KMjBSRXFGUnFqQ29kSGZmN3BPU1NTbFp1K0NuQjF4M2tldUJwcU03VVNOajdsS2hkTStiMG1uTVk1QjNoS3V4ODNEM1NkK3hzZm1SZWxkNm8iLCJtYWMiOiJmYTg3OWNkZTA4YjEwNTg0OWI5Mzk1MzY3ZDI3MmEzMWMzZjdjMzQ5NWE0ZDc1ZmFiNWEyYjg0ZTAxYzQ2MjViIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkhLc3VXTU84M1VreWo1YkNYelloVXc9PSIsInZhbHVlIjoiNnYvR1F0R3hrOExDOFd0RXBNNlpoeEdYQkJNQk1PdXdiLzY1TEhqYlovK2Z3L05KMjBSRXFGUnF" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "Ir6dy1RrRHMhGXDLT5soe8C7eHrWDIWALDOp4nlV" "uc_cart_id" => "5ab831df59bfbe8cedc3af83f5a51b1b" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/97274" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 04:19:53GET/article/97274314371