Generic placeholder image

Current Organic Synthesis

Editor-in-Chief

ISSN (Print): 1570-1794
ISSN (Online): 1875-6271

Research Article

Polymer-Bound Triphenylphosphine and 4,4′-Dinitroazobenzene as a Coupling Reagents for Chromatography-Free Esterification Reaction

Author(s): Diparjun Das, Kalyani Rajkumari and Lalthazuala Rokhum*

Volume 16, Issue 7, 2019

Page: [1024 - 1031] Pages: 8

DOI: 10.2174/1570179416666190919152424

Price: $65

Abstract

Aim and Objective: Sustainable production of fine chemicals both in industries and pharmaceuticals heavily depends on the application of solid-phase synthesis route coupled with microwave technologies due to their environmentally benign nature. In this report, a microwave-assisted esterification reaction using polymer-bound triphenylphosphine and 4,4′-dinitroazobenzene reagent system was investigated.

Materials and Methods: The solvents were obtained from Merck India. Polymer-bound triphenylphosphine (~3 mmol triphenylphosphine moiety/g) was acquired from Sigma-Aldrich. The progress of the reaction was observed by thin-layer chromatography. All the reactions were performed in Milestones StartSYNTH microwave. The NMR spectra were recorded on Bruker Avance III 300, 400, and 500 MHz FT NMR Spectrometers. Using azo compound and polymer-bound triphenyl phosphine as a coupling reagent, esterification of different carboxylic acids with alcohols was performed under microwave irradiation.

Results: Esterification of benzoic acid with 1-propanol under microwave irradiation gave a high yield of 92% propyl benzoate in 60 minutes only. Isolation of the ester products was relatively simple as both the byproducts polymer-bound triphenylphosphine oxide and hydrazine could be removed by simple filtration. The rates of reactions were found to be directly proportional to the pKa of the benzoic acids.

Conclusion: 4,4′-Dinitroazobenzene was introduced as a novel coupling reagent, in conjugation with polymer-bound triphenylphosphine, for esterification reactions under microwave irradiation. The low moisture sensitivity of the reaction system, easy separation of the byproducts, and column chromatographyfree isolation of esters help our methods with application significance, particularly from the ‘Sustainable Chemistry’ perspective.

Keywords: Esterification reaction, chemoselective, retention, chromatography-free, microwave irradiation, simple filtration.

Graphical Abstract

[1]
Hughes, D.L. Progress in the Mitsunobu reaction. A review. Org. Prep. Proced. Int., 1996, 28, 127-164. [http://dx.doi.org/10.1080/00304949609356516].
[2]
Twibanire, J.D.A.K.; Grindley, T.B. Efficient and controllably selective preparation of esters using uronium-based coupling agents. Org. Lett., 2011, 13(12), 2988-2991. [http://dx.doi.org/10.1021/ol201005s]. [PMID: 21591807].
[3]
Han, S.Y.; Kim, Y.A. Recent development of peptide coupling reagents in organic synthesis. Tetrahedron, 2004, 60(11), 2447-2467. [http://dx.doi.org/10.1016/j.tet.2004.01.020].
[4]
Montalbetti, C.A.G.N.; Falque, V. Amide bond formation and peptide coupling. Tetrahedron, 2005, 61(46), 10827-10852. [http://dx.doi.org/10.1016/j.tet.2005.08.031].
[5]
Miyamura, H.; Yasukawa, T.; Kobayashi, S. Aerobic oxidative esterification of alcohols catalyzed by polymer-incarcerated gold nanoclusters under ambient conditions. Green Chem., 2010, 12(5), 776-778. [http://dx.doi.org/10.1039/b926877d].
[6]
Pathak, G.; Rokhum, L. Selective monoesterification of symmetrical diols using resin-bound triphenylphosphine. ACS Comb. Sci., 2015, 17(9), 483-487. [http://dx.doi.org/10.1021/acscombsci.5b00086]. [PMID: 26226065].
[7]
Matković, M.; Veljković, J.; Mlinarić-Majerski, K.; Molčanov, K.; Kojić-Prodić, B. Design of a depside with a lipophilic adamantane moiety: Synthesis, crystal structure and molecular conformation. J. Mol. Struct., 2007, 832(1–3), 191-198. [http://dx.doi.org/10.1016/j.molstruc.2006.08.022].
[8]
Weininger, S.J.; Stermitz, F.R. Organic Chemistry; , 1984, p. 1121.
[9]
Dhimitruka, I.; Santalucia, J., Jr Investigation of the Yamaguchi esterification mechanism. Synthesis of a lux-s enzyme inhibitor using an improved esterification method. Org. Lett., 2006, 8(1), 47-50. [http://dx.doi.org/10.1021/ol0524048]. [PMID: 16381564].
[10]
Kuisle, O.; Quiñoá, E.; Riguera, R. A general methodology for automated solid-phase synthesis of depsides and depsipeptides. Preparation of a valinomycin analogue. J. Org. Chem., 1999, 64(22), 8063-8075. [http://dx.doi.org/10.1021/jo981580+]. [PMID: 11674717].
[11]
Rodrigues, R.D.C.; Barros, I.M.A.; Lima, E.L.S. Mild one-pot conversion of carboxylic acids to amides or esters with Ph3P/trichloroisocyanuric acid. Tetrahedron Lett., 2005, 46(35), 5945-5947. [http://dx.doi.org/10.1016/j.tetlet.2005.06.127].
[12]
Dong, H.; Pei, Z.; Byström, S.; Ramström, O. Reagent-dependent regioselective control in multiple carbohydrate esterifications. J. Org. Chem., 2007, 72(4), 1499-1502. [http://dx.doi.org/10.1021/jo0620821]. [PMID: 17288394].
[13]
Dai, C.; Zhang, A.; Li, J.; Hou, K.; Liu, M.; Song, C.; Guo, X. Synthesis of yolk-shell HPW@Hollow silicalite-1 for esterification reaction. Chem. Commun. (Camb.), 2014, 50(37), 4846-4848. [http://dx.doi.org/10.1039/c4cc00693c]. [PMID: 24686392].
[14]
Mamidi, N.; Manna, D. Zn(OTf)2-promoted chemoselective esterification of hydroxyl group bearing carboxylic acids. J. Org. Chem., 2013, 78(6), 2386-2396. [http://dx.doi.org/10.1021/jo302502r]. [PMID: 23350970].
[15]
Salomé, C.; Kohn, H. Triphenylphosphine dibromide: A simple one-pot esterification reagent. Tetrahedron, 2009, 65(2), 456-460. [http://dx.doi.org/10.1016/j.tet.2008.10.062]. [PMID: 20066025].
[16]
Mitsunobu, O.; Yamada, M. Preparation of esters of carboxylic and phosphoric acid via quaternary phosphonium salts. Bull. Chem. Soc. Jpn., 1967, 40(10), 2380-2382. [http://dx.doi.org/10.1246/bcsj.40.2380].
[17]
Swamy, K.C.K.; Kumar, N.N.B.; Balaraman, E.; Kumar, K.V.P.P. Mitsunobu and related reactions: advances and applications. Chem. Rev., 2009, 109(6), 2551-2651. [http://dx.doi.org/10.1021/cr800278z]. [PMID: 19382806].
[18]
Nowrouzi, N.; Mehranpour, A.M.; Rad, J.A. A simple and convenient method for preparation of carboxylic acid alkyl esters, phenolic and thioesters using chlorodiphenylphosphine/I2 and imidazole reagent system. Tetrahedron, 2010, 66(50), 9596-9601. [http://dx.doi.org/10.1016/j.tet.2010.10.022].
[19]
Hirose, D.; Gazvoda, M.; Košmrlj, J.; Taniguchi, T. Advances and mechanistic insight on the catalytic Mitsunobu reaction using recyclable azo reagents. Chem. Sci. (Camb.), 2016, 7(8), 5148-5159. [http://dx.doi.org/10.1039/C6SC00308G]. [PMID: 30155165].
[20]
Hashimoto, T.; Hirose, D.; Taniguchi, T. Catalytic aerobic oxidation of arylhydrazides with iron phthalocyanine. Adv. Synth. Catal., 2015, 357(14–15), 3346-3352. [http://dx.doi.org/10.1002/adsc.201500459].
[21]
Lipshutz, B.H.; Chung, D.W.; Rich, B.; Corral, R. Simplification of the Mitsunobu reaction. Di-p-chlorobenzyl azodicarboxylate: A new azodicarboxylate. Org. Lett., 2006, 8(22), 5069-5072. [http://dx.doi.org/10.1021/ol0618757]. [PMID: 17048845].
[22]
Kato, T.; Matsuoka, S.; Suzuki, M. N-Heterocyclic carbene-mediated redox condensation of alcohols. Chem. Commun. (Camb.), 2016, 52(55), 8569-8572. [http://dx.doi.org/10.1039/C6CC04154J]. [PMID: 27319401].
[23]
But, T.Y.S.; Toy, P.H. Organocatalytic Mitsunobu reactions. J. Am. Chem. Soc., 2006, 128(30), 9636-9637. [http://dx.doi.org/10.1021/ja063141v]. [PMID: 16866510].
[24]
Tunoori, A.R.; Dutta, D.; Georg, G.I. Polymer-bound triphenylphosphine as traceless reagent for Mitsunobu reactions in combinatorial chemistry: Synthesis of aryl ethers from phenols and alcohols. Tetrahedron Lett., 1998, 39(48), 8751-8754. [http://dx.doi.org/10.1016/S0040-4039(98)01988-1].
[25]
Barrett, A.G.; Roberts, R.S.; Schröder, J. Impurity annihilation: chromatography-free parallel Mitsunobu reactions. Org. Lett., 2000, 2(19), 2999-3001. [http://dx.doi.org/10.1021/ol006313g]. [PMID: 10986092].
[26]
Lanning, M.E.; Fletcher, S. Azodicarbonyl dimorpholide (ADDM): An effective, versatile, and water-soluble Mitsunobu reagent. Tetrahedron Lett., 2013, 54(35), 4624-4628. [http://dx.doi.org/10.1016/j.tetlet.2013.06.049].
[27]
Dandapani, S.; Curran, D.P. Separation-friendly Mitsunobu reactions: a microcosm of recent developments in separation strategies. Chemistry, 2004, 10(13), 3130-3138. [http://dx.doi.org/10.1002/chem.200400363]. [PMID: 15224321].
[28]
Kappe, C.O. Kontrolliertes Erhitzen mit Mikrowellen in der modernen organischen Synthese. Angew. Chem., 2004, 116(46), 6408-6443. [http://dx.doi.org/10.1002/ange.200400655].
[29]
de la Hoz, A.; Díaz-Ortiz, A.; Moreno, A. Microwaves in organic synthesis. Thermal and non-thermal microwave effects. Chem. Soc. Rev., 2005, 34(2), 164-178. [http://dx.doi.org/10.1039/B411438H]. [PMID: 15672180].
[30]
Pathak, G.; Das, D.; Rokhum, L. A microwave-assisted highly practical chemoselective esterification and amidation of carboxylic acids. RSC Advances, 2016, 6(96), 93729-93740. [http://dx.doi.org/10.1039/C6RA22558F].
[31]
Kappe, C.O.; Dallinger, D.; Murphree, S.S. Practical Microwave Synthesis For Organic Chemists: Strategies, Instruments, and Protocols Wiley VCH Verlag GmbH & Co. KGaA: Weinheim,; , 2009.
[32]
Gedye, R.; Smith, F.; Westaway, K.; Ali, H.; Baldisera, L.; Laberge, L.; Rousell, J. The use of microwave ovens for rapid organic synthesis. Tetrahedron Lett., 1986, 27(3), 279-282. [http://dx.doi.org/10.1016/S0040-4039(00)83996-9].
[33]
Lai, G.; Guo, F.; Zheng, Y.; Fang, Y.; Song, H.; Xu, K.; Wang, S.; Zha, Z.; Wang, Z. Highly enantioselective Henry reactions in water catalyzed by a copper tertiary amine complex and applied in the synthesis of (S)-N-trans-feruloyl octopamine. Chemistry, 2011, 17(4), 1114-1117. [http://dx.doi.org/10.1002/chem.201002915]. [PMID: 21243676].
[34]
Boas, U.; Brask, J.; Jensen, K.J. Backbone amide linker in solid-phase synthesis. Chem. Rev., 2009, 109(5), 2092-2118. [http://dx.doi.org/10.1021/cr068206r]. [PMID: 19290595].
[35]
Das, D.; Pathak, G.; Rokhum, L. Polymer supported DMAP: an easily recyclable organocatalyst for highly atom-economical Henry reaction under solvent-free conditions. RSC Advances, 2016, 6(106), 104154-104163. [http://dx.doi.org/10.1039/C6RA23696K].
[36]
Balkenhohl, F.; Von dem Bussche-Hünnefeld, C.; Lansky, A.; Zechel, C. Combinatorial synthesis of small organic molecules. Angew. Chem. Int. Ed. Engl., 1996, 35(20), 2288-2337. [http://dx.doi.org/10.1002/anie.199622881].
[37]
Das, D.; Anal, J.M.H.; Rokhum, L. A mild and highly chemoselective iodination of alcohol using polymer supported DMAP. J. Chem. Sci., 2016, 128(11), 1695-1701. [http://dx.doi.org/10.1007/s12039-016-1158-1].
[38]
Harned, A.M.; Mukherjee, S.; Flynn, D.L.; Hanson, P.R. Ring-opening metathesis phase-trafficking (ROMpt) synthesis: Multistep synthesis on soluble ROM supports. Org. Lett., 2003, 5(1), 15-18. [http://dx.doi.org/10.1021/ol0270327]. [PMID: 12509879].
[39]
Mothana, S.; Chahal, N.; Vanneste, S.; Hall, D.G. Phase-switch synthesis with boronic acids as productive tags. J. Comb. Chem., 2007, 9(2), 193-196. [http://dx.doi.org/10.1021/cc060149s]. [PMID: 17348725].
[40]
Huestls, L. Sodium perborate oxidation of an aromatic amine. J. Chem. Educ., 1977, I(5), 98447.
[41]
Zhang, C.; Jiao, N. Copper-catalyzed aerobic oxidative dehydrogenative coupling of anilines leading to aromatic azo compounds using dioxygen as an oxidant. Angew. Chem. Int. Ed. Engl., 2010, 49(35), 6174-6177. [http://dx.doi.org/10.1002/anie.201001651]. [PMID: 20652918].
[42]
Regen, S.L.; Lee, D.P. Solid phase phosphorus reagents. Conversion of alcohols to alkyl chlorides. J. Org. Chem., 1975, 40(11), 11-12. [http://dx.doi.org/10.1021/jo00899a042].
[43]
Chatterjee, S. Dhanurdhar; Rokhum, L. Extraction of a cardanol based liquid bio-fuel from waste natural resource and decarboxylation using a silverbased catalyst. Renew. Sustain. Energy Rev., 2017, 72, 560-564. [http://dx.doi.org/10.1016/j.rser.2017.01.035].
[44]
Rokhum, L.; Bez, G. One-pot solid phase synthesis of (E) -nitroalkenes. Tetrahedron Lett., 2013, 54(40), 5500-5504. [http://dx.doi.org/10.1016/j.tetlet.2013.07.146].
[45]
Das, D.; Chanda, T.; Rokhum, L. Application of “Click” chemistry in solid phase synthesis of alkyl halides. Acta Chim. Slov., 2015, 62(4), 775-783. [PMID: 26680704].
[46]
Taniguchi, T.; Hirose, D.; Ishibashi, H. Esterification via iron-catalyzed activation of triphenylphosphine with air. ACS Catal., 2011, 1(11), 1469-1474. [http://dx.doi.org/10.1021/cs2003824].
[47]
McNulty, J.; Capretta, A.; Laritchev, V.; Dyck, J.; Robertson, A.J. Dimethylmalonyltrialkylphosphoranes: New general reagents for esterification reactions allowing controlled inversion or retention of configuration on chiral alcohols. J. Org. Chem., 2003, 68(4), 1597-1600. [http://dx.doi.org/10.1021/jo026639y]. [PMID: 12585914].
[48]
Gómez-Vidal, J.A.; Forrester, M.T.; Silverman, R.B. Mild and selective sodium azide mediated cleavage of p-nitrobenzoic esters. Org. Lett., 2001, 3(16), 2477-2479. [http://dx.doi.org/10.1021/ol016104b]. [PMID: 11483039].
[49]
Iranpoor, N.; Firouzabadi, H.; Khalili, D.; Motevalli, S. Easily prepared azopyridines as potent and recyclable reagents for facile esterification reactions. An efficient modified mitsunobu reaction. J. Org. Chem., 2008, 73(13), 4882-4887. [http://dx.doi.org/10.1021/jo8000782]. [PMID: 18512992].
[50]
Dodge, J.A.; Trujillo, J.I.; Presnell, M. Effect of the acidic component on the Mitsunobu inversion of a sterically hindered alcohol. J. Org. Chem., 1994, 59(1), 234-236. [http://dx.doi.org/10.1021/jo00080a039].
[51]
McNulty, J.; Capretta, A.; Laritchev, V.; Dyck, J.; Robertson, A.J. The role of acyloxyphosphonium ions and the stereochemical influence of base in the phosphorane-mediated esterification of alcohols. Angew. Chem. Int. Ed. Engl., 2003, 42(34), 4051-4054. [http://dx.doi.org/10.1002/anie.200351209]. [PMID: 12973767].
[52]
Smith, A.B., III; Safonov, I.G.; Corbett, R.M.; Pennsyl, V. Total syntheses of (+)-zampanolide and (+)-dactylolide exploiting a unified strategy. J. Am. Chem. Soc., 2002, 124(37), 11102-11113. [http://dx.doi.org/10.1021/ja020635t]. [PMID: 12224958].

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version242msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[15:15:33] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[15:15:33] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[15:15:33] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (90.68ms)time
  • Application (152ms)time
  • 1 x Application (62.6%)
    152ms
    1 x Booting (37.4%)
    90.68ms
    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 duplicated80.33ms
    • 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 ('58953283','',1,1740496533,1740496533) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740496533
      900μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 11. middleware::check_user_access:24
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('58953283','/article/100916',1,1740496533,1740496533)
      120μ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 >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) 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 >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) 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 >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) 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 >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) 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 >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) 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 >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 58953283 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 58953283) limit 1
      16.39msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 58953283
      • 1: 58953283
      • 2: 58953283
      • 3: 58953283
      • 4: 58953283
      • 5: 58953283
      • 6: 58953283
      • 7: 58953283
      • 8: 58953283
      • 9: 58953283
      • 10: 58953283
      • 11: 58953283
      • 12: 58953283
      • 13: 58953283
      • 14: 58953283
      • 15: 58953283
      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=100916
      670μ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`
      560μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=34) and sj.journal_id!=34 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      470μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=34) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      750μsalphaeurekaselec_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=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
      770μsalphaeurekaselec_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` = '100916'
      1.78msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 100916
      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` = '100916'
      2.25msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 100916
      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` = '100916' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.04msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 100916
      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#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
      430μ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 = 34 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      24.65msalphaeurekaselec_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 = 34 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.19msalphaeurekaselec_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 = 34 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      4.31msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2071
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select pdf, html, epub, prc from `article_metrics` where `article_id` = 100916 limit 1
      180μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 100916
      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 = 100916 and content_type = 'article' order by status desc limit 1
      210μ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` = 175005 limit 1
      160μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 175005
      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
      210μ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` = 'COS' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      280μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: COS
      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 = '100916' 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) )
      300μ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 = '9548' 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 = '2584' 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 <= 58953283 and j.to_ip >=58953283 )) and ((j.from_date <= 1740496533 and j.to_date >= 1740496533 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2584) 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 <= 58953283 and j.to_ip >=58953283 )) and ((j.from_date <= 1740496533 and j.to_date >= 1740496533 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2584) 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 <= 58953283 and j.to_ip >=58953283 )) and ((j.from_date <= 1740496533 and j.to_date >= 1740496533 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2584)
      9.21msalphaeurekaselec_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 <= 58953283 and j.to_ip >=58953283 )) and ((j.from_date <= 1740496533 and j.to_date >= 1740496533 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9548) 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 <= 58953283 and j.to_ip >=58953283 )) and ((j.from_date <= 1740496533 and j.to_date >= 1740496533 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9548) 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 <= 58953283 and j.to_ip >=58953283 )) and ((j.from_date <= 1740496533 and j.to_date >= 1740496533 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9548)
      550μ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 <= 58953283 and j.to_ip >=58953283 )) and ((j.from_date <= 1740496533 and j.to_date >= 1740496533 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100916) 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 <= 58953283 and j.to_ip >=58953283 )) and ((j.from_date <= 1740496533 and j.to_date >= 1740496533 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100916) 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 <= 58953283 and j.to_ip >=58953283 )) and ((j.from_date <= 1740496533 and j.to_date >= 1740496533 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100916)
      610μ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` < '1024' and is_uploaded = 1 and issue_id = 9548 order by cast(first_page as SIGNED) desc limit 1
      460μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 1024
      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` > '1031' and is_uploaded = 1 and issue_id = 9548 order by cast(first_page as SIGNED) asc limit 1
      400μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 1031
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      180μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      170μ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` = 100916 limit 1
      2.29msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 100916
      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` <= 1740496533 and `b`.`banner_to_date` >= 1740496533 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.08msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 34
      • 3: 1740496533
      • 4: 1740496533
      • 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` = 34 and `b`.`banner_from_date` <= 1740496533 and `b`.`banner_to_date` >= 1740496533 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.04msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 34
      • 3: 1740496533
      • 4: 1740496533
      • 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='43a3d74b4790d0a052654ba70a9203c1'
      200μsalphaeurekaselec_live_10_06_2022Cart.php#271
      Backtrace
      • 15. app/Models/Cart.php:271
      • 16. view::layouts._header:260
      • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
      • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    App\Models\MultiLanguage
    1MultiLanguage.php#?
        _token
        cuhvgjKRYXoN7I8XjosVHCrHm47dNwM5RtXQZOWe
        uc_cart_id
        43a3d74b4790d0a052654ba70a9203c1
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/article/100916" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/100916
        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:17 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6ImNPT3QzcXQxc3Z2L0lTMEZrRngxVnc9PSIsInZhbHVlIjoicXpiQXhyam5DdHMreGpCQlVIKzJHdDcrakNDMzdKaUcyYnlCTzRmS0d0UT0iLCJtYWMiOiJkYmI1YmY3ZGY5YjRjMjQ3NzVlYTQ0MTJmMzExZTE0MDNlMzc0Y2E0OWI5OGQzMzg2Njk5ZTU0ZGY1YzUxYmRkIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6ImNPT3QzcXQxc3Z2L0lTMEZrRngxVnc9PSIsInZhbHVlIjoicXpiQXhyam5DdHMreGpCQlVIKzJHdDcrakNDMzdKaUcyYnlCTzRmS0d0UT0iLCJtYWMiOiJkYmI1YmY3ZGY5YjRj" ] "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
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 15:15:33 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlVWY050V2pjS1JKZ3d4UFZUeEtyK0E9PSIsInZhbHVlIjoiTWZpZHByMGwxNWx6eXoyNXhnaUFBZ0hOSVZzTnh2c3NpOTl6bWxITUtOZm1IUEFTQ1FkaEJNeVREaWI2WU91ajJKQlJTUWRtZ2JpTEhZZndscnN2blIzYzY0eGdnSzFmK2JSVGRtZEQrcXFGR0ltdWxkM3hHUEpyNnEyQjVNZFMiLCJtYWMiOiJiYjJmMjVkZTQ3Yzg1NTU2Yzg1MmZmZThjMjkxYTViZWY2MDNjNTYzM2UwODc0OWVkZjM1NTA3NjRhOGNlMTQzIiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 03:15:33 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlVWY050V2pjS1JKZ3d4UFZUeEtyK0E9PSIsInZhbHVlIjoiTWZpZHByMGwxNWx6eXoyNXhnaUFBZ0hOSVZzTnh2c3NpOTl6bWxITUtOZm1IUEFTQ1FkaEJNeVREaWI2WU91ajJKQlJTU" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjlCV25WRXl4TlE3emJPK2prZjNGWFE9PSIsInZhbHVlIjoiMFBkS2YzV1JDTklsQU41M0FRdWhkaDFLV0ZvUHdUT01iSzFGTDQxMXQzUU5iL1Ntd1hpNkE2akZQNXAzRnJTdGp5WHVpS2lCR1FFZm41UllvYnJMNW83RTJ5YVVPVTllNFd0QzV3L2U1RXBpbTQyV3VFMW0rSTJibmkzNGM3cjEiLCJtYWMiOiIzMmQxNTBhYTk4MDE5ZjU5NWIwOWU5MGU1ODc3NzQ1NmI5ZmNlZWZmMTJkMDE0ODU2MzcxMzE2MTQ1MTdlODU5IiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IjlCV25WRXl4TlE3emJPK2prZjNGWFE9PSIsInZhbHVlIjoiMFBkS2YzV1JDTklsQU41M0FRdWhkaDFLV0ZvUHdUT01iSzFGTDQxMXQzUU5iL1Ntd1hpNkE2akZ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlVWY050V2pjS1JKZ3d4UFZUeEtyK0E9PSIsInZhbHVlIjoiTWZpZHByMGwxNWx6eXoyNXhnaUFBZ0hOSVZzTnh2c3NpOTl6bWxITUtOZm1IUEFTQ1FkaEJNeVREaWI2WU91ajJKQlJTUWRtZ2JpTEhZZndscnN2blIzYzY0eGdnSzFmK2JSVGRtZEQrcXFGR0ltdWxkM3hHUEpyNnEyQjVNZFMiLCJtYWMiOiJiYjJmMjVkZTQ3Yzg1NTU2Yzg1MmZmZThjMjkxYTViZWY2MDNjNTYzM2UwODc0OWVkZjM1NTA3NjRhOGNlMTQzIiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 03:15:33 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlVWY050V2pjS1JKZ3d4UFZUeEtyK0E9PSIsInZhbHVlIjoiTWZpZHByMGwxNWx6eXoyNXhnaUFBZ0hOSVZzTnh2c3NpOTl6bWxITUtOZm1IUEFTQ1FkaEJNeVREaWI2WU91ajJKQlJTU" 1 => "alphaeurekaselectnet_session=eyJpdiI6IjlCV25WRXl4TlE3emJPK2prZjNGWFE9PSIsInZhbHVlIjoiMFBkS2YzV1JDTklsQU41M0FRdWhkaDFLV0ZvUHdUT01iSzFGTDQxMXQzUU5iL1Ntd1hpNkE2akZQNXAzRnJTdGp5WHVpS2lCR1FFZm41UllvYnJMNW83RTJ5YVVPVTllNFd0QzV3L2U1RXBpbTQyV3VFMW0rSTJibmkzNGM3cjEiLCJtYWMiOiIzMmQxNTBhYTk4MDE5ZjU5NWIwOWU5MGU1ODc3NzQ1NmI5ZmNlZWZmMTJkMDE0ODU2MzcxMzE2MTQ1MTdlODU5IiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IjlCV25WRXl4TlE3emJPK2prZjNGWFE9PSIsInZhbHVlIjoiMFBkS2YzV1JDTklsQU41M0FRdWhkaDFLV0ZvUHdUT01iSzFGTDQxMXQzUU5iL1Ntd1hpNkE2akZ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "cuhvgjKRYXoN7I8XjosVHCrHm47dNwM5RtXQZOWe" "uc_cart_id" => "43a3d74b4790d0a052654ba70a9203c1" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/article/100916" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 15:15:33GET/article/100916314361