Coupling of Thiols and Aryl Halides Mediated by Dicyclohexano-18- crown-6 and Potassium Carbonate | Bentham Science
Coupling of Thiols and Aryl Halides Mediated by Dicyclohexano-18- crown-6 and Potassium Carbonate

Page: [824 - 837] Pages: 14

  • * (Excluding Mailing and Handling)

Abstract

Aims: A simple, transition-metal-free C-S coupling protocol for the synthesis of aryl thioethers is reported.

Background: Sulfur-containing moieties are ubiquitous in pharmaceutical drugs and materials and therefore methods for their construction are of great importance. One approach entails the catalytic coupling of an aryl halohydrocarbon with a thiol, but the transition metal catalysts usually used are prone to poisoning by participating sulfur species and efficient catalysis is usually only achieved after complex ligand optimization.

Objective: New transition-metal-free approaches to the synthesis of C-S bonds are urgently need.

Methods: We screened the reaction conditions such as alkali, crown ether, solvent, temperature, etc., tested the compatibility of the reaction substrate, and analyzed the mechanism process.

Results: The optimized reaction conditions were determined to be 1.0 equiv of aryl halides and 1.2 equiv of thiols at 110 ℃ in toluene with K2CO3 (1.5 equiv) as a base, promoted by 10 mol% dicyclohexano-18-crown-6. Up to 33 examples of thioethers were synthesized under transitionmetal- free conditions in good to excellent yields.

Conclusion: We have developed a simple and efficient method for the C-S cross-coupling of a wide variety of (hetero)aryl halides and thiols mediated by dicyclohexano-18-crown-6 and without the need for transition-metal catalyst. In addition, the preparation and gram-scale experiments of a variety of drug molecules further verify the practicability of our developed method.

Keywords: Carbon-sulfur coupling, SNAr, aryl halides, thiols, dicyclohexano-18-crown-6, potassium carbonate.

Graphical Abstract

[1]
Winn, M.; Reilly, E.B.; Liu, G.; Huth, J.R.; Jae, H-S.; Freeman, J.; Pei, Z.; Xin, Z.; Lynch, J.; Kester, J.; von Geldern, T.W.; Leitza, S.; DeVries, P.; Dickinson, R.; Mussatto, D.; Okasinski, G.F. Discovery of novel p-arylthio cinnamides as antagonists of leukocyte function-associated antigen-1/intercellular adhesion molecule-1 interaction. 4. Structure-activity relationship of substituents on the benzene ring of the cinnamide. J. Med. Chem., 2001, 44(25), 4393-4403.
[http://dx.doi.org/10.1021/jm0103108] [PMID: 11728185]
[2]
Cai, Z.; Zhou, W.; Sun, L. Synthesis and HMG CoA reductase inhibition of 4-thiophenyl quinolines as potential hypocholesterolemic agents. Bioorg. Med. Chem., 2007, 15(24), 7809-7829.
[http://dx.doi.org/10.1016/j.bmc.2007.08.044] [PMID: 17851082]
[3]
Delfín, D.A.; Morgan, R.E.; Zhu, X.; Werbovetz, K.A. Redox-active dinitrodiphenylthioethers against Leishmania: Synthesis, structure-activity relationships and mechanism of action studies. Bioorg. Med. Chem., 2009, 17(2), 820-829.
[http://dx.doi.org/10.1016/j.bmc.2008.11.031] [PMID: 19058972]
[4]
Bagley, M.C.; Davis, T.; Dix, M.C.; Fusillo, V.; Pigeaux, M.; Rokicki, M.J.; Kipling, D. Microwave-assisted Ullmann C-S bond formation: Synthesis of the P38α MAPK clinical candidate VX-745. J. Org. Chem., 2009, 74(21), 8336-8342.
[http://dx.doi.org/10.1021/jo9017155] [PMID: 19778055]
[5]
Eichman, C.C.; Stambuli, J.P. Transition metal catalyzed synthesis of aryl sulfides. Molecules, 2011, 16(1), 590-608.
[http://dx.doi.org/10.3390/molecules16010590] [PMID: 21242940]
[6]
Beletskaya, I.P.; Ananikov, V.P. Transition-metal-catalyzed C-S, C-Se, and C-Te bond formation via cross-coupling and atom-economic addition reactions. Chem. Rev., 2011, 111(3), 1596-1636.
[http://dx.doi.org/10.1021/cr100347k] [PMID: 21391564]
[7]
Ilardi, E.A.; Vitaku, E.; Njardarson, J.T. Data-mining for sulfur and fluorine: An evaluation of pharmaceuticals to reveal opportunities for drug design and discovery. J. Med. Chem., 2014, 57(7), 2832-2842.
[http://dx.doi.org/10.1021/jm401375q] [PMID: 24102067]
[8]
Boyd, D.A. Sulfur and its role in modern materials science. Angew. Chem. Int. Ed. Engl., 2016, 55(50), 15486-15502.
[http://dx.doi.org/10.1002/anie.201604615] [PMID: 27860133]
[9]
Murata, M.; Buchwald, S.L. A general and efficient method for the palladium-catalyzed cross-coupling of thiols and secondary phosphines. Tetrahedron, 2004, 60(34), 7397-7403.
[http://dx.doi.org/10.1016/j.tet.2004.05.044]
[10]
Alvaro, E.; Hartwig, J.F. Resting state and elementary steps of the coupling of aryl halides with thiols catalyzed by alkylbisphosphine com-plexes of palladium. J. Am. Chem. Soc., 2009, 131(22), 7858-7868.
[http://dx.doi.org/10.1021/ja901793w] [PMID: 19453106]
[11]
Uyeda, C.; Tan, Y.; Fu, G.C.; Peters, J.C. A new family of nucleophiles for photoinduced, copper-catalyzed cross-couplings via single-electron transfer: Reactions of thiols with aryl halides under mild conditions (O °C). J. Am. Chem. Soc., 2013, 135(25), 9548-9552.
[http://dx.doi.org/10.1021/ja404050f] [PMID: 23697882]
[12]
Qiao, Z.; Wei, J.; Jiang, X. Direct cross-coupling access to diverse aromatic sulfide: Palladium-catalyzed double C-S bond construction using Na2S2O3 as a sulfurating reagent. Org. Lett., 2014, 16(4), 1212-1215.
[http://dx.doi.org/10.1021/ol500112y] [PMID: 24555790]
[13]
Gogoi, P.; Hazarika, S.; Sarma, M.J.; Sarma, K.; Barman, P. Nickel-Schiff base complex catalyzed C-S cross-coupling of thiols with organic chlorides. Tetrahedron, 2014, 70(41), 7484-7489.
[http://dx.doi.org/10.1016/j.tet.2014.08.020]
[14]
Johnson, M.W.; Hannoun, K.I.; Tan, Y.; Fu, G.C.; Peters, J.C. A mechanistic investigation of the photoinduced, copper-mediated cross-coupling of an aryl thiol with an aryl halide. Chem. Sci. (Camb.), 2016, 7(7), 4091-4100.
[http://dx.doi.org/10.1039/C5SC04709A] [PMID: 28044096]
[15]
Zhu, Y-Y.; Lan, G.; Fan, Y.; Veroneau, S.S.; Song, Y.; Micheroni, D.; Lin, W. Merging photoredox and organometallic catalysts in a metal-organic framework significantly boosts photocatalytic activities. Angew. Chem. Int. Ed. Engl., 2018, 57(43), 14090-14094.
[http://dx.doi.org/10.1002/anie.201809493] [PMID: 30129281]
[16]
Liu, D.; Ma, H-X.; Fang, P.; Mei, T-S. Nickel-catalyzed thiolation of aryl halides and heteroaryl halides through electrochemistry. Angew. Chem. Int. Ed. Engl., 2019, 58(15), 5033-5037.
[http://dx.doi.org/10.1002/anie.201900956] [PMID: 30735304]
[17]
Sikari, R.; Sinha, S.; Das, S.; Saha, A.; Chakraborty, G.; Mondal, R.; Paul, N.D. Achieving nickel catalyzed C-S cross-coupling under mild conditions using metal-ligand cooperativity. J. Org. Chem., 2019, 84(7), 4072-4085.
[http://dx.doi.org/10.1021/acs.joc.9b00075] [PMID: 30855958]
[18]
Zhao, J-N.; Kayumov, M.; Wang, D-Y.; Zhang, A. Transition-metal-free aryl-heteroatom bond formation via C-S bond cleavage. Org. Lett., 2019, 21(18), 7303-7306.
[http://dx.doi.org/10.1021/acs.orglett.9b02584] [PMID: 31465236]
[19]
Varala, R.; Ramu, E.; Alam, M.M.; Adapa, R.S. CsOH·H2O-Promoted synthesis of aryl sulfides via direct coupling of aryl halides and thi-ols. Chem. Lett., 2004, 33, 1614-1615.
[http://dx.doi.org/10.1246/cl.2004.1614]
[20]
Sreedhar, B.; Reddy, P.S.; Reddy, M.A. Catalyst-free and base-free water-promoted SNAr reaction of heteroaryl halides with thiols. Synthesis, 2009, 2009(10), 1732-1738.
[http://dx.doi.org/10.1055/s-0029-1216644]
[21]
Yuan, Y.; Thomé, I.; Kim, S.H.; Chen, D.T.; Beyer, A.; Bonnamour, J.; Zuidema, E.; Chang, S.; Bolm, C. Dimethyl sulfoxide/potassium hydroxide: A superbase for the transition metal-free preparation of cross-coupling products. Adv. Synth. Catal., 2010, 352(17), 2892-2898.
[http://dx.doi.org/10.1002/adsc.201000575]
[22]
Duan, Z.; Ranjit, S.; Liu, X. One-pot synthesis of amine-substituted aryl sulfides and benzo[b]thiophene derivatives. Org. Lett., 2010, 12(10), 2430-2433.
[http://dx.doi.org/10.1021/ol100816g] [PMID: 20420378]
[23]
Cano, R.; Ramón, D.J.; Yus, M. Transition-metal-free O-, S-, and N-arylation of alcohols, thiols, amides, amines, and related heterocycles. J. Org. Chem., 2011, 76(2), 654-660.
[http://dx.doi.org/10.1021/jo1022052] [PMID: 21175155]
[24]
Ma, X.T.; Liu, Q.; Jia, X.J.; Su, C.L.; Xu, Q. Efficient synthesis of unsymmetrical heteroaryl thioethers and chalcogenides by alkali hydrox-ide-mediated SNAr reactions of heteroaryl halides and dichalcogenides. RSC Advances, 2016, 6(62), 56930-56935.
[http://dx.doi.org/10.1039/C6RA10517C]
[25]
Kwan, E.E.; Zeng, Y.; Besser, H.A.; Jacobsen, E.N. Concerted nucleophilic aromatic substitutions. Nat. Chem., 2018, 10(9), 917-923.
[http://dx.doi.org/10.1038/s41557-018-0079-7] [PMID: 30013193]
[26]
Anderson, R.G.; Jett, B.M.; McNally, A. A unified approach to couple aromatic heteronucleophiles to azines and pharmaceuticals. Angew. Chem. Int. Ed. Engl., 2018, 57(38), 12514-12518.
[http://dx.doi.org/10.1002/anie.201807322] [PMID: 30084203]
[27]
Chen, L.; Liang, J.; Chen, Z-Y.; Chen, J.; Yan, M.; Zhang, X-J. A convenient synthesis of sulfones via light promoted coupling of sodium sulfinates and aryl halides. Adv. Synth. Catal., 2019, 361, 956-960.
[28]
Liu, C.Z.; Zang, X.F.; Yu, B.H.; Yu, X.C.; Xu, Q. Microwave-promoted TBAF-catalyzed SNAr reaction of aryl fluorides and ArSTMS: An efficient synthesis of unsymmetrical diaryl thioethers. Synlett, 2011, 1143-1148.
[29]
Reeves, J.T.; Camara, K.; Han, Z.S.; Xu, Y.; Lee, H.; Busacca, C.A.; Senanayake, C.H. The reaction of Grignard reagents with Bunte salts: A thiol-free synthesis of sulfides. Org. Lett., 2014, 16(4), 1196-1199.
[http://dx.doi.org/10.1021/ol500067f] [PMID: 24512478]
[30]
Jia, X-J.; Yu, L.; Liu, J-P.; Xu, Q.; Sickert, M.; Chen, L-H.; Lautens, M. Sulfur-silicon bond activation catalysed by Cl/Br ions: Waste-free synthesis of unsymmetrical thioethers by replacing fluoride catalysis and fluorinated substrates in SNAr reactions. Green Chem., 2014, 16(7), 3444-3449.
[http://dx.doi.org/10.1039/c4gc00535j]
[31]
Jouffroy, M.; Kelly, C.B.; Molander, G.A. Thioetherification via photoredox/nickel dual catalysis. Org. Lett., 2016, 18(4), 876-879.
[http://dx.doi.org/10.1021/acs.orglett.6b00208] [PMID: 26852821]
[32]
Moser, D.; Duan, Y.; Wang, F.; Ma, Y.; O’Neill, M.J.; Cornella, J. Selective functionalization of aminoheterocycles by a pyrylium salt. Angew. Chem. Int. Ed. Engl., 2018, 57(34), 11035-11039.
[http://dx.doi.org/10.1002/anie.201806271] [PMID: 29969531]
[33]
Liu, B.; Lim, C-H.; Miyake, G.M. Visible-light-promoted C-S cross-coupling via intermolecular charge transfer. J. Am. Chem. Soc., 2017, 139(39), 13616-13619.
[http://dx.doi.org/10.1021/jacs.7b07390] [PMID: 28910097]
[34]
Liotta, C.L.; Harris, H.P.; McDermott, M.; Gonzalez, T.; Smith, K. Chemistry of “naked” anions II. reactions of the 18-crown-6 complex of potassium acetate with organic substrates in aprotic organic solvents. Tetrahedron Lett., 1974, 15(28), 2417-2420.
[http://dx.doi.org/10.1016/S0040-4039(01)92273-7]
[35]
Schmittling, E.A.; Sawyer, J.S. Synthesis of diaryl ethers, diaryl thioethers, and diarylamines mediated by potassium fluoride-alumina and 18-crown-6. J. Org. Chem., 1993, 58(12), 3229-3230.
[http://dx.doi.org/10.1021/jo00064a004]
[36]
Wadamoto, M.; Ozasa, N.; Yanagisawa, A.; Yamamoto, H. BINAP/AgOTf/KF/18-crown-6 as new bifunctional catalysts for asymmetric Sa-kurai-Hosomi allylation and Mukaiyama aldol reaction. J. Org. Chem., 2003, 68(14), 5593-5601.
[http://dx.doi.org/10.1021/jo020691c] [PMID: 12839451]
[37]
Jadhav, V.H.; Choi, W.; Lee, S-S.; Lee, S.; Kim, D.W. Bis-tert-alcohol-functionalized crown-6-calix[4]arene: An organic promoter for nucle-ophilic fluorination. Chemistry, 2016, 22(13), 4515-4520.
[http://dx.doi.org/10.1002/chem.201504602] [PMID: 26880350]
[38]
Carvalho, N.F.; Pliego, J.R., Jr Theoretical design and calculation of a crown ether phase-transfer-catalyst scaffold for nucleophilic fluorina-tion merging two catalytic concepts. J. Org. Chem., 2016, 81(18), 8455-8463.
[http://dx.doi.org/10.1021/acs.joc.6b01624] [PMID: 27525472]
[39]
Kang, S.M.; Kim, C.H.; Lee, K.C.; Kim, D.W. Bis-triethylene glycolic crown-5-calix[4]arene: A promoter of nucleophilic fluorination using potassium fluoride. Org. Lett., 2019, 21(9), 3062-3066.
[http://dx.doi.org/10.1021/acs.orglett.9b00649] [PMID: 30990693]
[40]
Lee, W.C.; Kang, S.M.; Lee, B.C.; Kim, S.E.; Kim, D.W. Multifunctional crown-5-calix[4]arene-based phase-transfer catalysts for aromatic 18f-fluorination. Org. Lett., 2020, 22(24), 9551-9555.
[http://dx.doi.org/10.1021/acs.orglett.0c03604] [PMID: 33270463]
[41]
Dalessandro, E.V.; Pliego, J.R. Theoretical design of new macrocycles for nucleophilic fluorination with KF: Thiourea-crown-ether is pre-dicted to overcome [2.2.2]-cryptand. Mol. Syst. Des. Eng., 2020, 5(9), 1513-1523.
[http://dx.doi.org/10.1039/D0ME00112K]
[42]
Zhou, Y.; Wang, Y.; Lou, Y.; Song, Q. Facile synthesis of 1,2-thiobenzonitriles via Cu-catalyzed denitrogenative radical coupling reaction. Chem. Commun. (Camb.), 2019, 55(69), 10265-10268.
[http://dx.doi.org/10.1039/C9CC05099J] [PMID: 31393484]
[43]
Singh, N.; Singh, R.; Raghuvanshi, D.S.; Singh, K.N. Convenient MW-assisted synthesis of unsymmetrical sulfides using sulfonyl hydra-zides as aryl thiol surrogate. Org. Lett., 2013, 15(22), 5874-5877.
[http://dx.doi.org/10.1021/ol402948k] [PMID: 24171443]
[44]
Ku, X.; Huang, H.; Jiang, H.; Liu, H. Efficient iron/copper cocatalyzed S-arylations of thiols with aryl halides. J. Comb. Chem., 2009, 11(3), 338-340.
[http://dx.doi.org/10.1021/cc800182q] [PMID: 19260652]
[45]
Park, N.; Park, K.; Jang, M.; Lee, S. One-pot synthesis of symmetrical and unsymmetrical aryl sulfides by Pd-catalyzed couplings of aryl halides and thioacetates. J. Org. Chem., 2011, 76(11), 4371-4378.
[http://dx.doi.org/10.1021/jo2007253] [PMID: 21545186]
[46]
Garnier, T.; Danel, M.; Magné, V.; Pujol, A.; Bénéteau, V.; Pale, P.; Chassaing, S. Copper(I)-USY as a ligand-free and recyclable catalyst for ullmann-type O-, N-, S-, and C-arylation reactions: Scope and application to total synthesis. J. Org. Chem., 2018, 83(12), 6408-6422.
[http://dx.doi.org/10.1021/acs.joc.8b00620] [PMID: 29790337]
[47]
Khakyzadeh, V.; Rostami, A.; Veisi, H.; Shirmardi Shaghasemi, B.; Reimhult, E.; Luque, R.; Xia, Y.; Darvishi, S. Direct C-S bond formation via C-O bond activation of phenols in a crossover Pd/Cu dual-metal catalysis system. Org. Biomol. Chem., 2019, 17(18), 4491-4497.
[http://dx.doi.org/10.1039/C9OB00313D] [PMID: 30990509]
[48]
Thankachan, A.P.; Sindhu, K.S.; Krishnan, K.K.; Anilkumar, G. A novel and efficient zinc-catalyzed thioetherification of aryl halides. RSC Advances, 2015, 5(41), 32675-32678.
[http://dx.doi.org/10.1039/C5RA03869C]
[49]
Mukherjee, N.; Chatterjee, T.; Ranu, B.C. Reaction under ball-milling: Solvent-, ligand-, and metal-free synthesis of unsymmetrical diaryl chalcogenides. J. Org. Chem., 2013, 78(21), 11110-11114.
[http://dx.doi.org/10.1021/jo402071b] [PMID: 24116379]
[50]
Sam, D.J.; Simmons, H.E. Crown ether chemistry. Substitution reactions of potassium halide and potassium hydroxide complexes of dicy-clohexyl-18-crown-6. J. Am. Chem. Soc., 1974, 96(7), 2252-2253.
[http://dx.doi.org/10.1021/ja00814a045]
[51]
Raevsky, O.A.; Solov’ev, V.P.; Solotnov, A.F.; Schneider, H-J.; Rüdiger, V. Conformation of 18-crown-5 and its influence on complexation with alkali and ammonium cations: Why 18-crown-5 binds more than 1000 times weaker than 18C6. J. Org. Chem., 1996, 61(23), 8113-8116.
[http://dx.doi.org/10.1021/jo961083y] [PMID: 11667798]
[52]
Xu, Z.; Yang, Z.; Liu, Y.; Lu, Y.; Chen, K.; Zhu, W. Halogen bond: Its role beyond drug-target binding affinity for drug discovery and de-velopment. J. Chem. Inf. Model., 2014, 54(1), 69-78.
[http://dx.doi.org/10.1021/ci400539q] [PMID: 24372485]
[53]
Silva, S.L.; Valle, M.S.; Pliego, J.R. Jr Nucleophilic fluorination with KF Catalyzed by 18-crown-6 and bulky diols: A theoretical and exper-imental study. J. Org. Chem., 2020, 85(23), 15457-15465.
[http://dx.doi.org/10.1021/acs.joc.0c02229] [PMID: 33227195]
[54]
Silva, S.L.; Valle, M.S.; Pliego, J.R., Jr Micro-solvation and counter ion effects on ionic reactions: Activation of potassium fluoride with 18-crown-6 and tert-butanol in aprotic solvents. J. Mol. Liq., 2020, 319, 114211.
[http://dx.doi.org/10.1016/j.molliq.2020.114211]
[55]
Pliego, J.R. The role of intermolecular forces in ionic reactions: The solvent effect, ion-pairing, aggregates and structured environment. Org. Biomol. Chem., 2021, 19(9), 1900-1914.
[http://dx.doi.org/10.1039/D0OB02413A] [PMID: 33554992]
Request history8.2.26PHP Version240msRequest Duration27MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[21:05:58] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[21:05:58] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[21:05:58] LOG.warning: Function strftime() is deprecated in /home/betabenthamscien/public_html/stor...
  • warninglog[21:05:58] LOG.warning: Function strftime() is deprecated in /home/betabenthamscien/public_html/stor...
  • Booting (88.7ms)time
  • Application (151ms)time
  • 1 x Application (62.99%)
    151ms
    1 x Booting (37.01%)
    88.70ms
    8 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.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
    35 statements were executed, 2 of which were duplicates, 33 unique. Show only duplicated83.45ms
    • 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 ('58792404','',1,1734987958,1734987958) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1734987958
      1.46msalphaeurekaselec_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 ('58792404','/article/122480',1,1734987958,1734987958)
      600μ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 >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) 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 >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) 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 >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) 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 >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) 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 >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) 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 >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 58792404 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58792404) limit 1
      23.98msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 58792404
      • 1: 58792404
      • 2: 58792404
      • 3: 58792404
      • 4: 58792404
      • 5: 58792404
      • 6: 58792404
      • 7: 58792404
      • 8: 58792404
      • 9: 58792404
      • 10: 58792404
      • 11: 58792404
      • 12: 58792404
      • 13: 58792404
      • 14: 58792404
      • 15: 58792404
      Backtrace
      • 14. app/Models/UserAccess/UserAccess.php:784
      • 15. middleware::check_user_access:63
      • 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=122480
      770μ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` = 34 limit 1
      800μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 34
      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=34) and sj.journal_id!=34 group by `j`.`nid`) as `aggregate_table`
      640μsalphaeurekaselec_live_10_06_2022Subject.php#198
      Backtrace
      • 16. app/Models/Subject.php:198
      • 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=34) and sj.journal_id!=34 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      510μsalphaeurekaselec_live_10_06_2022Subject.php#198
      Backtrace
      • 14. app/Models/Subject.php:198
      • 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=34) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      710μsalphaeurekaselec_live_10_06_2022Subject.php#218
      Backtrace
      • 16. app/Models/Subject.php:218
      • 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=34) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      650μsalphaeurekaselec_live_10_06_2022Subject.php#218
      Backtrace
      • 14. app/Models/Subject.php:218
      • 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` = '122480'
      260μsalphaeurekaselec_live_10_06_2022Keywords.php#85
      Bindings
      • 0: 122480
      Backtrace
      • 13. app/Models/Keywords.php:85
      • 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` = '122480'
      2.27msalphaeurekaselec_live_10_06_2022Article.php#1569
      Bindings
      • 0: 122480
      Backtrace
      • 13. app/Models/Article.php:1569
      • 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 , `au`.*, (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` = '122480' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      780μsalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 122480
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      220μsalphaeurekaselec_live_10_06_2022BundleOffer.php#113
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:113
      • 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
      450μsalphaeurekaselec_live_10_06_2022Article.php#1959
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1959
      • 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 = 34 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      19.35msalphaeurekaselec_live_10_06_2022Issue.php#295
      Backtrace
      • 11. app/Models/Issue.php:295
      • 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 = 34 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`last_modified` desc
      11.79msalphaeurekaselec_live_10_06_2022Article.php#527
      Backtrace
      • 13. app/Models/Article.php:527
      • 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 = 34 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`last_modified` desc
      6.14msalphaeurekaselec_live_10_06_2022Article.php#527
      Backtrace
      • 13. app/Models/Article.php:527
      • 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` = 122480 limit 1
      2.32msalphaeurekaselec_live_10_06_2022Article.php#743
      Bindings
      • 0: 122480
      Backtrace
      • 14. app/Models/Article.php:743
      • 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 = 122480 and content_type = 'article' order by status desc limit 1
      310μsalphaeurekaselec_live_10_06_2022Article.php#750
      Backtrace
      • 11. app/Models/Article.php:750
      • 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` = 203419 limit 1
      240μsalphaeurekaselec_live_10_06_2022Meta.php#59
      Bindings
      • 0: 203419
      Backtrace
      • 14. app/Models/Meta.php:59
      • 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
      250μsalphaeurekaselec_live_10_06_2022BundleOffer.php#113
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:113
      • 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` = 'COS' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      290μsalphaeurekaselec_live_10_06_2022Article.php#2024
      Bindings
      • 0: COS
      Backtrace
      • 13. app/Models/Article.php:2024
      • 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 = '122480' 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) )
      360μ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 = '11756' and content_type = 'i' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      260μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '3224' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      240μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 58792404 and j.to_ip >=58792404 )) and ((j.from_date <= 1734987958 and j.to_date >= 1734987958 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3224) 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 <= 58792404 and j.to_ip >=58792404 )) and ((j.from_date <= 1734987958 and j.to_date >= 1734987958 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3224) 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 <= 58792404 and j.to_ip >=58792404 )) and ((j.from_date <= 1734987958 and j.to_date >= 1734987958 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3224)
      1.72msalphaeurekaselec_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 <= 58792404 and j.to_ip >=58792404 )) and ((j.from_date <= 1734987958 and j.to_date >= 1734987958 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11756) 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 <= 58792404 and j.to_ip >=58792404 )) and ((j.from_date <= 1734987958 and j.to_date >= 1734987958 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11756) 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 <= 58792404 and j.to_ip >=58792404 )) and ((j.from_date <= 1734987958 and j.to_date >= 1734987958 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 11756)
      530μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ArticleController.php:2297
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"article" as access_level, j.issue_id, j.article_id from `user_access_article_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 58792404 and j.to_ip >=58792404 )) and ((j.from_date <= 1734987958 and j.to_date >= 1734987958 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 122480) 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 <= 58792404 and j.to_ip >=58792404 )) and ((j.from_date <= 1734987958 and j.to_date >= 1734987958 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 122480) 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 <= 58792404 and j.to_ip >=58792404 )) and ((j.from_date <= 1734987958 and j.to_date >= 1734987958 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 122480)
      510μ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` < '824' and is_uploaded = 1 and issue_id = 11756 order by cast(first_page as SIGNED) desc limit 1
      460μsalphaeurekaselec_live_10_06_2022Article.php#1818
      Bindings
      • 0: 824
      Backtrace
      • 14. app/Models/Article.php:1818
      • 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` > '837' and is_uploaded = 1 and issue_id = 11756 order by cast(first_page as SIGNED) asc limit 1
      360μsalphaeurekaselec_live_10_06_2022Article.php#1830
      Bindings
      • 0: 837
      Backtrace
      • 14. app/Models/Article.php:1830
      • 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
      180μ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` = 122480 limit 1
      2.4msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 122480
      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` = 34 and `b`.`banner_from_date` <= 1734987958 and `b`.`banner_to_date` >= 1734987958 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.19msalphaeurekaselec_live_10_06_2022Banner.php#189
      Bindings
      • 0: 1
      • 1: J
      • 2: 34
      • 3: 1734987958
      • 4: 1734987958
      • 5: A
      Backtrace
      • 13. app/Models/Banner.php:189
      • 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='1ba8af266b05ca81f81ffa981933597d'
      270μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._main_menu:13
      • 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
        RAxy9S5Dgs56TR5QMgMDw3uro7ZRfsrYz7Jm4YyW
        uc_cart_id
        1ba8af266b05ca81f81ffa981933597d
        _previous
        array:1 [ "url" => "https://beta.benthamscience.com/article/122480" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/122480
        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:16 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "beta.benthamscience.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "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" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        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 => "Mon, 23 Dec 2024 21:05:58 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlZmL21ZQkxjb04zVm81WExQd1Q5dVE9PSIsInZhbHVlIjoiYTAwVkFYTHZJYVVkK1R2dU92SHFnRXZkZllOVk5hT0tPdEhlZjRxT3B5a0JxbDdKWHQ1Uy84Q05MVlVGRUdsUlFlai9mTDd4NHkzV215bVlOK2d0aFJIaC9iU202WnYrM0tsMG9ENVhVSXFvRUx0ZndILzNsTXFRejhVUmJ2blYiLCJtYWMiOiJlMTI2YzM5NDc0MTFhYWRmMjFkOTMyNDc2OTJkMTI0NjhjOWI1MWIzY2Q5YWZjOGIyMGFhMTA1OWM3Yjg3NzRkIiwidGFnIjoiIn0%3D; expires=Thu, 26 Dec 2024 09:05:58 GMT; Max-Age=216000; path=/; secure; samesite=strictXSRF-TOKEN=eyJpdiI6IlZmL21ZQkxjb04zVm81WExQd1Q5dVE9PSIsInZhbHVlIjoiYTAwVkFYTHZJYVVkK1R2dU92SHFnRXZkZllOVk5hT0tPdEhlZjRxT3B5a0JxbDdKWHQ1Uy84Q05MVlVGRUdsUlFlai9mT" 1 => "eurekaselectnew_session=eyJpdiI6ImxQWjdJcTdQTEZvdU9FNEpxc1EwQkE9PSIsInZhbHVlIjoiSVQrRmtXMXpHa2IyaDFSRGFQTWZ5ZnVISG5RWTFiVmhZYWtjdFZJUDE1MzBsOTd5QkFZTUczUjQxWkxMLzBJZlVRakpyNVRQQnJSeGl5WEs5SFhIN1NwN3FSZ1p2bURVT2RkQUtnaktvWXNoNFpPZndTWXFraVU1ZllpUU1xU04iLCJtYWMiOiI5MTE3ZjliOTUyYTQ2NmFhNGNhODM5YmJkYzUwMGVkYmFmNTM3MDFhNDhhZDM4MGVhM2MxNzQxZGNmZTlkNmUwIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=stricteurekaselectnew_session=eyJpdiI6ImxQWjdJcTdQTEZvdU9FNEpxc1EwQkE9PSIsInZhbHVlIjoiSVQrRmtXMXpHa2IyaDFSRGFQTWZ5ZnVISG5RWTFiVmhZYWtjdFZJUDE1MzBsOTd5QkFZTUczUjQxWkxM" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlZmL21ZQkxjb04zVm81WExQd1Q5dVE9PSIsInZhbHVlIjoiYTAwVkFYTHZJYVVkK1R2dU92SHFnRXZkZllOVk5hT0tPdEhlZjRxT3B5a0JxbDdKWHQ1Uy84Q05MVlVGRUdsUlFlai9mTDd4NHkzV215bVlOK2d0aFJIaC9iU202WnYrM0tsMG9ENVhVSXFvRUx0ZndILzNsTXFRejhVUmJ2blYiLCJtYWMiOiJlMTI2YzM5NDc0MTFhYWRmMjFkOTMyNDc2OTJkMTI0NjhjOWI1MWIzY2Q5YWZjOGIyMGFhMTA1OWM3Yjg3NzRkIiwidGFnIjoiIn0%3D; expires=Thu, 26-Dec-2024 09:05:58 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlZmL21ZQkxjb04zVm81WExQd1Q5dVE9PSIsInZhbHVlIjoiYTAwVkFYTHZJYVVkK1R2dU92SHFnRXZkZllOVk5hT0tPdEhlZjRxT3B5a0JxbDdKWHQ1Uy84Q05MVlVGRUdsUlFlai9mT" 1 => "eurekaselectnew_session=eyJpdiI6ImxQWjdJcTdQTEZvdU9FNEpxc1EwQkE9PSIsInZhbHVlIjoiSVQrRmtXMXpHa2IyaDFSRGFQTWZ5ZnVISG5RWTFiVmhZYWtjdFZJUDE1MzBsOTd5QkFZTUczUjQxWkxMLzBJZlVRakpyNVRQQnJSeGl5WEs5SFhIN1NwN3FSZ1p2bURVT2RkQUtnaktvWXNoNFpPZndTWXFraVU1ZllpUU1xU04iLCJtYWMiOiI5MTE3ZjliOTUyYTQ2NmFhNGNhODM5YmJkYzUwMGVkYmFmNTM3MDFhNDhhZDM4MGVhM2MxNzQxZGNmZTlkNmUwIiwidGFnIjoiIn0%3D; path=/; secure; httponlyeurekaselectnew_session=eyJpdiI6ImxQWjdJcTdQTEZvdU9FNEpxc1EwQkE9PSIsInZhbHVlIjoiSVQrRmtXMXpHa2IyaDFSRGFQTWZ5ZnVISG5RWTFiVmhZYWtjdFZJUDE1MzBsOTd5QkFZTUczUjQxWkxM" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "RAxy9S5Dgs56TR5QMgMDw3uro7ZRfsrYz7Jm4YyW" "uc_cart_id" => "1ba8af266b05ca81f81ffa981933597d" "_previous" => array:1 [ "url" => "https://beta.benthamscience.com/article/122480" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12024-12-23 21:05:58GET/article/12248048351