Generic placeholder image

Current HIV Research

Editor-in-Chief

ISSN (Print): 1570-162X
ISSN (Online): 1873-4251

Research Article

Design, Synthesis, Docking Studies and Biological Activities Novel 2,3- Diaryl-4-Quinazolinone Derivatives as Anti-HIV-1 Agents

Author(s): Zahra Hajimahdi, Rezvan Zabihollahi, Mohamad Reza Aghasadeghi and Afshin Zarghi*

Volume 17, Issue 3, 2019

Page: [214 - 222] Pages: 9

DOI: 10.2174/1570162X17666190911125359

Price: $65

Abstract

Background: Although major efforts have been devoted to the effective treatment of HIV-1 infection, it has remained one of the leading causes of deaths around the world. So, development of anti-HIV-1 agents featuring novel structure is essential.

Objective: To synthesize novel quinazolinone derivatives and evaluate their anti-HIV-1 activity.

Method: In this study, we designed and synthesized a series of novel 2,3-diaryl-4-quinazolinone derivatives using a one-pot multicomponent reaction. Then, the resulting derivatives were evaluated for anti-HIV-1 activity using Hela cell-based single-cycle replication assay.

Results: Most of the compounds showed efficacy against HIV-1 replication and the compound 9c exhibited the highest activity with EC50 value of 37 μM. Docking studies indicated that synthesized compounds can interact with the key residues of the HIV-1 integrase active site. Binding of the most active compound was consistent with the HIV-1 integrase inhibitors.

Conclusion: Based on our results, these derivatives represent novel lead compounds for the development of new promising anti-HIV-1 agents.

Keywords: Synthesis, molecular docking, design, anti-HIV-1 activity, integrase, 4-quinazolinone.

« Previous
Graphical Abstract

[1]
Zhan P, Pannecouque C, De Clercq E, Liu X. Anti-HIV drug discovery and development: Current innovations and future trends: miniperspective. J Med Chem 2016; 59(7): 2849-78.
[http://dx.doi.org/10.1021/acs.jmedchem.5b00497] [PMID: 26509831]
[2]
Cohen MS, Chen YQ, McCauley M, et al. HPTN 052 Study Team. Prevention of HIV-1 infection with early antiretroviral therapy. N Engl J Med 2011; 365(6): 493-505.
[http://dx.doi.org/10.1056/NEJMoa1105243] [PMID: 21767103]
[3]
Yeni P. Update on HAART in HIV. J Hepatol 2006; 44(1)(Suppl.): S100-3.
[http://dx.doi.org/10.1016/j.jhep.2005.11.021] [PMID: 16359748]
[4]
Trono D, Van Lint C, Rouzioux C, et al. HIV persistence and the prospect of long-term drug-free remissions for HIV-infected individuals. Science 2010; 329(5988): 174-80.
[http://dx.doi.org/10.1126/science.1191047] [PMID: 20616270]
[5]
Bon I, Calza L, Musumeci G, et al. Impact of Different Antiretroviral Strategies on Total HIV-DNA Level in Virologically Suppressed HIV-1 Infected Patients. Curr HIV Res 2017; 15(6): 448-55.
[PMID: 29210661]
[6]
Montaner JS, Lima VD, Barrios R, et al. Association of highly active antiretroviral therapy coverage, population viral load, and yearly new HIV diagnoses in British Columbia, Canada: A population-based study. Lancet 2010; 376(9740): 532-9.
[http://dx.doi.org/10.1016/S0140-6736(10)60936-1] [PMID: 20638713]
[7]
Craigie R. The molecular biology of HIV integrase. Future Virol 2012; 7(7): 679-86.
[http://dx.doi.org/10.2217/fvl.12.56] [PMID: 23024700]
[8]
Brown PO. Integration of retroviral DNA. Curr Top Microbiol Immunol 1990; 157: 19-48.
[http://dx.doi.org/10.1007/978-3-642-75218-6_2] [PMID: 2203610]
[9]
Zeinalipour-Loizidou E, Nicolaou C, Nicolaides A, Kostrikis LG. HIV-1 integrase: From biology to chemotherapeutics. Curr HIV Res 2007; 5(4): 365-88.
[http://dx.doi.org/10.2174/157016207781023965] [PMID: 17627500]
[10]
Pommier Y, Johnson AA, Marchand C. Integrase inhibitors to treat HIV/AIDS. Nat Rev Drug Discov 2005; 4(3): 236-48.
[http://dx.doi.org/10.1038/nrd1660] [PMID: 15729361]
[11]
Hazuda DJ. HIV integrase as a target for antiretroviral therapy. Curr Opin HIV AIDS 2012; 7(5): 383-9.
[http://dx.doi.org/10.1097/COH.0b013e3283567309] [PMID: 22871634]
[12]
Maertens GN, Hare S, Cherepanov P. The mechanism of retroviral integration from X-ray structures of its key intermediates. Nature 2010; 468(7321): 326-9.
[http://dx.doi.org/10.1038/nature09517] [PMID: 21068843]
[13]
Anthony NJ. HIV-1 integrase: A target for new AIDS chemotherapeutics. Curr Top Med Chem 2004; 4(9): 979-90.
[http://dx.doi.org/10.2174/1568026043388448] [PMID: 15134552]
[14]
Summa V, Petrocchi A, Bonelli F, et al. Discovery of raltegravir, a potent, selective orally bioavailable HIV-integrase inhibitor for the treatment of HIV-AIDS infection. J Med Chem 2008; 51(18): 5843-55.
[http://dx.doi.org/10.1021/jm800245z] [PMID: 18763751]
[15]
Evering TH, Markowitz M. Raltegravir (MK-0518): An integrase inhibitor for the treatment of HIV-1. Drugs Today (Barc) 2007; 43(12): 865-77.
[http://dx.doi.org/10.1358/dot.2007.43.12.1146063] [PMID: 18174972]
[16]
Sato M, Motomura T, Aramaki H, et al. Novel HIV-1 integrase inhibitors derived from quinolone antibiotics. J Med Chem 2006; 49(5): 1506-8.
[http://dx.doi.org/10.1021/jm0600139] [PMID: 16509568]
[17]
Shimura K, Kodama E, Sakagami Y, et al. Broad antiretroviral activity and resistance profile of the novel human immunodeficiency virus integrase inhibitor elvitegravir (JTK-303/GS-9137). J Virol 2008; 82(2): 764-74.
[http://dx.doi.org/10.1128/JVI.01534-07] [PMID: 17977962]
[18]
Johns BA, Kawasuji T, Weatherhead JG, et al. Carbamoyl pyridone HIV-1 integrase inhibitors 3. A diastereomeric approach to chiral nonracemic tricyclic ring systems and the discovery of dolutegravir (S/GSK1349572) and (S/GSK1265744). J Med Chem 2013; 56(14): 5901-16.
[http://dx.doi.org/10.1021/jm400645w] [PMID: 23845180]
[19]
Kawasuji T, Johns BA, Yoshida H, et al. Carbamoyl pyridone HIV-1 integrase inhibitors. 2. Bi- and tricyclic derivatives result in superior antiviral and pharmacokinetic profiles. J Med Chem 2013; 56(3): 1124-35.
[http://dx.doi.org/10.1021/jm301550c] [PMID: 23316884]
[20]
Katlama C, Murphy R. Dolutegravir for the treatment of HIV. Expert Opin Investig Drugs 2012; 21(4): 523-30.
[http://dx.doi.org/10.1517/13543784.2012.661713] [PMID: 22380682]
[21]
Narang BK, Grewal GK, Roy S, Bariwal J, Gupta MK, Rawal RK. A novel integrase targeting agent to explore the future prospective of HIV eradication: Dolutegravir. Curr HIV Res 2014; 12(5): 325-38.
[http://dx.doi.org/10.2174/1570162X12666140807150753] [PMID: 25106411]
[22]
Hajimahdi Z, Zarghi A. Progress in HIV-1 integrase inhibitors: A review of their chemical structure diversity. Iran J Pharm Res 2016; 15(4): 595-628.
[PMID: 28243261]
[23]
Zhao XZ, Maddali K, Metifiot M, et al. Bicyclic hydroxy-1H-pyrrolopyridine-trione containing HIV-1 integrase inhibitors. Chem Biol Drug Des 2012; 79(2): 157-65.
[http://dx.doi.org/10.1111/j.1747-0285.2011.01270.x] [PMID: 22107736]
[24]
Telvekar VN, Patel KN. Pharmacophore development and docking studies of the hiv-1 integrase inhibitors derived from N-methylpyrimidones, Dihydroxypyrimidines, and bicyclic pyrimidinones. Chem Biol Drug Des 2011; 78(1): 150-60.
[http://dx.doi.org/10.1111/j.1747-0285.2011.01130.x] [PMID: 21518263]
[25]
Debnath U, Kumar P, Agarwal A, Kesharwani A, Gupta SK, Katti SB. N-hydroxy-substituted 2-aryl acetamide analogs: A novel class of HIV-1 integrase inhibitors. Chem Biol Drug Des 2017; 90(4): 527-34.
[http://dx.doi.org/10.1111/cbdd.12974] [PMID: 28294572]
[26]
Schreier JD, Embrey MW, Raheem IT, et al. Discovery and optimization of 2-pyridinone aminal integrase strand transfer inhibitors for the treatment of HIV. Bioorg Med Chem Lett 2017; 27(9): 2038-46.
[http://dx.doi.org/10.1016/j.bmcl.2017.02.039] [PMID: 28285916]
[27]
Patel SB, Patel BD, Pannecouque C, Bhatt HG. Design, synthesis and anti-HIV activity of novel quinoxaline derivatives. Eur J Med Chem 2016; 117: 230-40.
[http://dx.doi.org/10.1016/j.ejmech.2016.04.019] [PMID: 27105027]
[28]
Rogolino D, Carcelli M, Compari C, et al. Diketoacid chelating ligands as dual inhibitors of HIV-1 integration process. Eur J Med Chem 2014; 78: 425-30.
[http://dx.doi.org/10.1016/j.ejmech.2014.03.070] [PMID: 24704615]
[29]
Billamboz M, Suchaud V, Bailly F, et al. 2-hydroxyisoquinoline-1,3(2H,4H)-diones (HIDs) as human immunodeficiency virus type 1 integrase inhibitors: Influence of the alkylcarboxamide substitution of position 4. Eur J Med Chem 2016; 117: 256-68.
[http://dx.doi.org/10.1016/j.ejmech.2016.03.083] [PMID: 27105029]
[30]
Vandurm P, Guiguen A, Cauvin C, et al. Synthesis, biological evaluation and molecular modeling studies of quinolonyl diketo acid derivatives: New structural insight into the HIV-1 integrase inhibition. Eur J Med Chem 2011; 46(5): 1749-56.
[http://dx.doi.org/10.1016/j.ejmech.2011.02.028] [PMID: 21385662]
[31]
Wang Y, Rong J, Zhang B, Hu L, Wang X, Zeng C. Design and synthesis of N-methylpyrimidone derivatives as HIV-1 integrase inhibitors. Bioorg Med Chem 2015; 23(4): 735-41.
[http://dx.doi.org/10.1016/j.bmc.2014.12.059] [PMID: 25618597]
[32]
El-Sharief A, Ammar Y, Zahran M, Ali A, El-Gaby M. Aminoacids in the synthesis of heterocyclic systems: The synthesis of triazinoquinazolinones, triazepinoquinazolinones and triazocinoquinazolinones of potential biological interest. Molecules 2001; 6: 267-78.
[http://dx.doi.org/10.3390/60300267]
[33]
Barker AJ. inventor; Zeneca Ltd., assignee. Quinazoline derivatives and their use as anti-cancer agents. International Patent Classification 6: C07D239/94, A61K31/505, C07D.. 1995 Feb.
[34]
Jatav V, Mishra P, Kashaw S, Stables JP. CNS depressant and anticonvulsant activities of some novel 3-[5-substituted 1,3,4-thiadiazole-2-yl]-2-styryl quinazoline-4(3H)-ones. Eur J Med Chem 2008; 43(9): 1945-54.
[http://dx.doi.org/10.1016/j.ejmech.2007.12.003] [PMID: 18222569]
[35]
Theivendren PS, Palanirajan VK. Quinazoline marketed drugs – A review. Res Pharm 2011; 1: 1-21.
[36]
Wang Z, Wang M, Yao X, et al. Design, synthesis and antiviral activity of novel quinazolinones. Eur J Med Chem 2012; 53: 275-82.
[http://dx.doi.org/10.1016/j.ejmech.2012.04.010] [PMID: 22546200]
[37]
Hajimahdi Z, Zarghi A, Zabihollahi R, Aghasadeghi MR. Synthesis, biological evaluation, and molecular modeling studies of new 1,3,4-oxadiazole- and 1,3,4-thiadiazole-substituted 4-oxo-4H-pyrido [1,2-a]pyrimidines as anti-HIV-1 agents. Med Chem Res 2013; 22: 2467-75.
[http://dx.doi.org/10.1007/s00044-012-0241-5]
[38]
Hajimahdi Z, Ranjbar A, Abolfazl Suratgar A, Zarghi A. QSAR Study on anti-HIV-1 activity of 4-oxo-1,4-dihydroquinoline and 4-oxo-4H-pyrido [1,2-a]pyrimidine derivatives using SW-MLR, artificial neural network and filtering methods. Iran J Pharm Res 2015; 14(Suppl.): 69-75.
[PMID: 26185507]
[39]
Hajimahdi Z, Zabihollahi R, Aghasadeghi MR, Ashtiani SH, Zarghi A. Novel quinolone-3-carboxylic acid derivatives as anti-HIV-1 agents: design, synthesis, and biological activities. Med Chem Res 2016; 25: 1861-76.
[http://dx.doi.org/10.1007/s00044-016-1631-x]
[40]
Faghihi K, Safakish M, Zebardast T, Hajimahdi Z, Zarghi A. Molecular Docking and QSAR Study of 2-Benzoxazolinone, Quinazoline and Diazocoumarin Derivatives as Anti-HIV-1 Agents. Iran J Pharm Res 2019; 18: 1253-63.
[41]
Livani ZA, Safakish M, Hajimahdi Z, Soleymani S, Zabihollahi R, Aghasadeghi MR, et al. Design, synthesis, molecular modeling, in silico ADME studies and anti-HIV-1 assay of new diazocoumarin derivatives Iran J Pharm Res 2018; 17(Special Issue 2): 65-77.
[42]
Safakish M, Hajimahdi Z, Zabihollahi R, Aghasadeghi MR, Vahabpour R, Zarghi A. Design, synthesis, and docking studies of new 2-benzoxazolinone derivatives as anti-HIV-1 agent. Med Chem Res 2017; 26: 2718-26.
[http://dx.doi.org/10.1007/s00044-017-1969-8]
[43]
Parizadeh N, Alipour E, Soleymani S, et al. Synthesis of novel 3-(5-(alkyl/arylthio)-1,3,4-oxadiazol-2-yl)-8-phenylquinolin-4(1H)-one derivatives as anti-HIV agents. Phosphorus Sulfur Silicon Relat Elem 2018; 193: 225-31.
[http://dx.doi.org/10.1080/10426507.2017.1394302]
[44]
Scudiero DA, Shoemaker RH, Paull KD, et al. Evaluation of a soluble tetrazolium/formazan assay for cell growth and drug sensitivity in culture using human and other tumor cell lines. Cancer Res 1988; 48(17): 4827-33.
[PMID: 3409223]
[45]
Lin C-C, Cheng H-Y, Yang C-M, Lin T-C. Antioxidant and antiviral activities of Euphorbia thymifolia L. J Biomed Sci 2002; 9(6 Pt 2): 656-64.
[http://dx.doi.org/10.1159/000067281] [PMID: 12432232]
[46]
HyperChem(TM) Professional 8.0, Hypercube, Inc 1115 NW 4th Street, Gainesville, Florida 32601, USA..
[47]
Morris GM, Goodsell DS, Halliday RS, Huey R, Hart WE, Belew RK, et al. Automated Docking Using a Lamarckian Genetic Algorithm and and Empirical Binding Free Energy Function. J Comput Chem 1998; 19: 1639-62.
[http://dx.doi.org/10.1002/(SICI)1096-987X(19981115)19:14<1639:AID-JCC10>3.0.CO;2-B]
[48]
Narasimhulu M, Lee YR. Ethylenediamine diacetate-catalyzed three-component reaction for the synthesis of 2,3-dihydroquinazolin-4(1H)-ones and their spirooxindole derivatives. Tetrahedron 2011; 67: 9627-34.
[http://dx.doi.org/10.1016/j.tet.2011.08.018]
[49]
Zarghi A, Zebardast T, Hajighasemali F, Alipoor E, Daraie B, Hedayati M. Design and synthesis of new 1,3-benzdiazinan-4-one derivatives as selective cyclooxygenase (COX-2) inhibitors. Arch Pharm (Weinheim) 2012; 345(4): 257-64.
[http://dx.doi.org/10.1002/ardp.201100138] [PMID: 22076641]
[50]
Zabihollahi R, Sadat SM, Vahabpour R, et al. Development of single-cycle replicable human immunodeficiency virus 1 mutants. Acta Virol 2011; 55(1): 15-22.
[http://dx.doi.org/10.4149/av_2011_01_15] [PMID: 21434701]
[51]
Hajimahdi Z, Zabihollahi R, Aghasadeghi MR, Zarghi A. Design, synthesis and docking studies of new 4-hydroxyquinoline-3-carbohydrazide derivatives as anti-HIV-1 agents. Drug Res (Stuttg) 2013; 63(4): 192-7.
[http://dx.doi.org/10.1055/s-0033-1334964] [PMID: 23487403]
[52]
Zabihollahi R, Vahabpour R, Hartoonian C, et al. Evaluation of the in vitro antiretroviral potential of some Biginelli-type pyrimidines. Acta Virol 2012; 56(1): 11-8.
[http://dx.doi.org/10.4149/av_2012_01_11] [PMID: 22404604]
[53]
Hare S, Maertens GN, Cherepanov P. 3′-processing and strand transfer catalysed by retroviral integrase in crystallo. EMBO J 2012; 31(13): 3020-8.
[http://dx.doi.org/10.1038/emboj.2012.118] [PMID: 22580823]
[54]
Hare S, Gupta SS, Valkov E, Engelman A, Cherepanov P. Retroviral intasome assembly and inhibition of DNA strand transfer. Nature 2010; 464(7286): 232-6.
[http://dx.doi.org/10.1038/nature08784] [PMID: 20118915]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version818msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[20:52:12] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[20:52:13] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[20:52:13] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (196ms)time
  • Application (622ms)time
  • 1 x Application (76.05%)
    622ms
    1 x Booting (23.95%)
    196ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    36 statements were executed, 4 of which were duplicates, 32 unique. Show only duplicated476ms
    • 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 ('314340157','',1,1740775932,1740775932) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740775932
      2.55msalphaeurekaselec_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 ('314340157','/article/100735',1,1740775932,1740775932)
      240μ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 >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) 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 >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) 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 >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) 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 >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) 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 >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) 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 >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) limit 1
      19.46msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314340157
      • 1: 314340157
      • 2: 314340157
      • 3: 314340157
      • 4: 314340157
      • 5: 314340157
      • 6: 314340157
      • 7: 314340157
      • 8: 314340157
      • 9: 314340157
      • 10: 314340157
      • 11: 314340157
      • 12: 314340157
      • 13: 314340157
      • 14: 314340157
      • 15: 314340157
      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=100735
      1.14msalphaeurekaselec_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` = 67 limit 1
      1.29msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 67
      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=67) and sj.journal_id!=67 group by `j`.`nid`) as `aggregate_table`
      1.14msalphaeurekaselec_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=67) and sj.journal_id!=67 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1msalphaeurekaselec_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=67) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      7.45msalphaeurekaselec_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=67) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      6.61msalphaeurekaselec_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` = '100735'
      10.86msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 100735
      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` = '100735'
      38.75msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 100735
      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` = '100735' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      22.28msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 100735
      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
      11.03msalphaeurekaselec_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
      770μ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 = 67 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      69.44msalphaeurekaselec_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 = 67 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      72.46msalphaeurekaselec_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 = 67 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      22.72msalphaeurekaselec_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` = 100735 limit 1
      350μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 100735
      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 = 100735 and content_type = 'article' order by status desc limit 1
      370μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 174799 limit 1
      300μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 174799
      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
      330μ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` = 'CHIVR' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      410μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CHIVR
      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 = '100735' 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) )
      470μ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 = '9408' 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) )
      430μ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 = '2568' 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740775933 and j.to_date >= 1740775933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2568) 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740775933 and j.to_date >= 1740775933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2568) 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740775933 and j.to_date >= 1740775933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2568)
      172msalphaeurekaselec_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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740775933 and j.to_date >= 1740775933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9408) 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740775933 and j.to_date >= 1740775933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9408) 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740775933 and j.to_date >= 1740775933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9408)
      1.05msalphaeurekaselec_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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740775933 and j.to_date >= 1740775933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100735) 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740775933 and j.to_date >= 1740775933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100735) 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740775933 and j.to_date >= 1740775933 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100735)
      940μ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` < '214' and is_uploaded = 1 and issue_id = 9408 order by cast(first_page as SIGNED) desc limit 1
      750μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 214
      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` > '222' and is_uploaded = 1 and issue_id = 9408 order by cast(first_page as SIGNED) asc limit 1
      590μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 222
      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'
      260μ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
      330μ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` = 100735 limit 1
      4.06msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 100735
      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` = 67 and `b`.`banner_from_date` <= 1740775933 and `b`.`banner_to_date` >= 1740775933 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.67msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 67
      • 3: 1740775933
      • 4: 1740775933
      • 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` = 67 and `b`.`banner_from_date` <= 1740775933 and `b`.`banner_to_date` >= 1740775933 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.61msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 67
      • 3: 1740775933
      • 4: 1740775933
      • 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='1bcb57c705d1697634c8b31bc8f9fc1a'
      460μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:291
      • 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
        HUZPoHokAam4yy69nX6UCNXdL8FrYESUjr6ujlf9
        uc_cart_id
        1bcb57c705d1697634c8b31bc8f9fc1a
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/100735" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/100735
        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 => "Fri, 28 Feb 2025 20:52:13 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlpLdlJrRkd2SnFiaU9DN3NGTndQWlE9PSIsInZhbHVlIjoick5IaGtDYmFnK2dlQ0VoNW55MXYybTNvb2o0ZFpWSnAxWkZkRUZWKzNVRE1NNmpESjluUDlvRENzWE8vSkQ5NUxnOTIzaW9IdDQxMVY2WEQ1Q3NZVmVRWkhGRFFjSk5WZ0xJdGRTY2lTR1NXUGVucWZKaVdPRS9lZ3IvNjNKVTMiLCJtYWMiOiI3ZmU1NmI1M2ZkMWFjZDgzMDdiMmM1MjQyYWZhMmIxMTE0OTYyYjM4YTQ3MWUyOGVkYmQ3NTAwOGE4MjUzOWQ3IiwidGFnIjoiIn0%3D; expires=Mon, 03 Mar 2025 08:52:13 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlpLdlJrRkd2SnFiaU9DN3NGTndQWlE9PSIsInZhbHVlIjoick5IaGtDYmFnK2dlQ0VoNW55MXYybTNvb2o0ZFpWSnAxWkZkRUZWKzNVRE1NNmpESjluUDlvRENzWE8vSkQ5NUxnOTIza" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ik4wRlc5UjVBWk1BaEsvQjkvcjFEcUE9PSIsInZhbHVlIjoiVGFaTThaTUh5MjlqRi9CTjNqRlorNzEvL3UyQVBKRk8vUmJKdWJyM09QNTV3RlVlVlN0K1ptZGwzMWFVNnZwbmN6NS9hUkZ0SWRqb0d4aEd1Q1c4eEtBT0UyQi80eTU5VnZzL3V6djgrdHhqUUlNWEJjeHlXbEpQN0VDYlJQLzIiLCJtYWMiOiI1NTEyYTI3M2Q2NjRjMTA3MjE5MGU0ZGI0YmM3NTk1NTNkYjcxYzBlY2I4NWU0OTdiMzc4YWJhNzFhZTdlN2Q2IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Ik4wRlc5UjVBWk1BaEsvQjkvcjFEcUE9PSIsInZhbHVlIjoiVGFaTThaTUh5MjlqRi9CTjNqRlorNzEvL3UyQVBKRk8vUmJKdWJyM09QNTV3RlVlVlN0K1ptZGw" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlpLdlJrRkd2SnFiaU9DN3NGTndQWlE9PSIsInZhbHVlIjoick5IaGtDYmFnK2dlQ0VoNW55MXYybTNvb2o0ZFpWSnAxWkZkRUZWKzNVRE1NNmpESjluUDlvRENzWE8vSkQ5NUxnOTIzaW9IdDQxMVY2WEQ1Q3NZVmVRWkhGRFFjSk5WZ0xJdGRTY2lTR1NXUGVucWZKaVdPRS9lZ3IvNjNKVTMiLCJtYWMiOiI3ZmU1NmI1M2ZkMWFjZDgzMDdiMmM1MjQyYWZhMmIxMTE0OTYyYjM4YTQ3MWUyOGVkYmQ3NTAwOGE4MjUzOWQ3IiwidGFnIjoiIn0%3D; expires=Mon, 03-Mar-2025 08:52:13 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlpLdlJrRkd2SnFiaU9DN3NGTndQWlE9PSIsInZhbHVlIjoick5IaGtDYmFnK2dlQ0VoNW55MXYybTNvb2o0ZFpWSnAxWkZkRUZWKzNVRE1NNmpESjluUDlvRENzWE8vSkQ5NUxnOTIza" 1 => "alphaeurekaselectnet_session=eyJpdiI6Ik4wRlc5UjVBWk1BaEsvQjkvcjFEcUE9PSIsInZhbHVlIjoiVGFaTThaTUh5MjlqRi9CTjNqRlorNzEvL3UyQVBKRk8vUmJKdWJyM09QNTV3RlVlVlN0K1ptZGwzMWFVNnZwbmN6NS9hUkZ0SWRqb0d4aEd1Q1c4eEtBT0UyQi80eTU5VnZzL3V6djgrdHhqUUlNWEJjeHlXbEpQN0VDYlJQLzIiLCJtYWMiOiI1NTEyYTI3M2Q2NjRjMTA3MjE5MGU0ZGI0YmM3NTk1NTNkYjcxYzBlY2I4NWU0OTdiMzc4YWJhNzFhZTdlN2Q2IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Ik4wRlc5UjVBWk1BaEsvQjkvcjFEcUE9PSIsInZhbHVlIjoiVGFaTThaTUh5MjlqRi9CTjNqRlorNzEvL3UyQVBKRk8vUmJKdWJyM09QNTV3RlVlVlN0K1ptZGw" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "HUZPoHokAam4yy69nX6UCNXdL8FrYESUjr6ujlf9" "uc_cart_id" => "1bcb57c705d1697634c8b31bc8f9fc1a" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/100735" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-28 20:52:13GET/article/100735314361