Generic placeholder image

The Natural Products Journal

Editor-in-Chief

ISSN (Print): 2210-3155
ISSN (Online): 2210-3163

Review Article

Visnagin: A New Perspective of Medicinal Importance, Physiological Functions, Phytochemistry, Pharmacology and Analytical Aspects of Active Phytoconstituents of Ammi visnaga

Author(s): Kanika Patel, Mahfoozur Rahman, Vikas Kumar, Amita Verma and Dinesh Kumar Patel*

Volume 9, Issue 3, 2019

Page: [197 - 206] Pages: 10

DOI: 10.2174/2210315508666180327154245

Price: $65

Abstract

Background: Ammi visnaga commonly known as ‘honey plant, tooth pick fruit, bisnaga and khella’ is an important plant of Apiaceae family. It is an annual herb found in Europe, Asia, North Africa, Latin America and in India. Carrot, parsnip, celery, coriander, anise, caraway, cumin, parsley and dill are some other plants of the same family i.e., ‘Apiaceae’. Fruits of Ammi visnaga (A. visnaga) are medicinally used as a strong photosensitizer, diaphoretic, carminative and antispasmodic agents.

Objective: A. visnaga has been used for the treatment of bronchial asthma, coronary insufficiency, angina pectoris, psoriasis, renal colic and ureteric stones. Visnagin (C13H10O4) is a ‘furanochromone derivative’ which is the main active constituent’s of A. visnaga. Visnagin is used for the treatment of low blood-pressure, angina pectoris and kidney stone. It also has neuroprotective and antiinflammatory activity. Moreover, visnagin also treat whooping cough, ureter and bile duct, gall bladder and renal colic, tumors and epileptic seizures.

Methods: This review summarizes data’s regarding the biological importance, pharmacological uses and medicinal importance of A. visnaga and their important active constituent’s “visnagin”. Moreover, the detailed pharmacological aspects of visnagin were presented in this review. Further various analytical techniques used for the extraction and isolation of visnagin were also discussed. Studies related to the pharmacological profile of the plants and their active phytoconstituents are one of the leading areas of research.

Conclusion: This review will be beneficial to the scientific society to understand the importance of A. visnaga plant and their active constituents ‘visnagin’for the development of alternative tools to treat disorders in the future.

Keywords: Ammi visnaga, analytical techniques, furanochromone, medicinal importance, pharmacological uses, visnagin.

Graphical Abstract

[1]
Heywood, V. Systematic survey of Old World Umbelliferae. In: The Biology and Chemistry of the Umbelliferae; , 1971; pp. 31-41.
[2]
Marwat, K.B.; Hashim, S.; Ali, H. Weed management. A case study from north-west Pakistan. Pak. J. Bot., 2010, 42, 341-353.
[3]
Hegnauer, R. Chemical Patterns and Relationships of Umbelliferae.In: Heywood, V.H. 1999. [ed.], The Biology and Chemistry of the Umbelliferae., Academic Press: London. 1971.
[4]
Sitting, M. Pharmaceutical Manufacturing Encyclopedia; Noyes Publications: USA, 1988.
[5]
Hashim, S.; Jan, A.; Marwat, K.B.; Khan, M.A. Phytochemistry and medicinal properties of Ammi visnaga (Apiacae). Pak. J. Bot., 2014, 46, 861-867.
[6]
Talaat, I.M.; Khattab, H.I.; Ahmed, A.M. Changes in growth, hormones levels and essential oil content of Ammi visnaga L. plants treated with some bioregulators. Saudi J. Biol. Sci., 2014, 21, 355-365.
[7]
Chevallier, A. Encyclopedia of medicinal plants. Encycl. Med. Plants, 2001, 18-27, 211-222.
[8]
Rao, P.P.; Reddy, P.R.; Gupta, H.C. Standardisation of Ammi visnaga L. Fruit. A homoeopathic drug. Indian J. Res. Homoeopath., 2011, 5, 15-18.
[9]
Bencheraiet, R.; Kherrab, H.; Kabouche, A.; Kabouche, Z.; Jay, M. Flavonols and antioxidant activity of Ammi visnaga L. (Apiaceae) Rec. Rec. Nat. Prod., 2011, 5, 55.
[10]
Ghoneim, K.; Al-Daly, A.; Amer, M.; Mohammad, A.; Khadrawy, F.; Mahmoud, M.A. Effects of Ammi visnaga L. (Apiaceae) extracts on the main metabolites in haemolymph and fat bodies of Schistocerca gregaria (Forskal) (Orthoptera: Acrididae). J. Adv. Zool, 2014, 1, 11-23.
[11]
Ghoneim, K.; Amer, M.; Al-Daly, A.; Mohammad, A.H.; Khadrawy, F.; Mahmoud, M. Disrupted survival, growth and development of desert locust Schistocerca gregaria (Forskal) (Orthoptera: Acrididae) by extracts from toothpick weed Ammi visnaga Lamarck (Apiaceae). Int. J. Biosci., 2014, 5, 397-414.
[12]
Chevallier, A. The Encyclopedia of Medicinal Plants; Dorling Kindersley: London, 1996.
[13]
Meepagala, K.M.; Estep, A.S.; Becnel, J.J. Mosquitocidal activity of extracts from Ammi visnaga (Apiaceae) seeds. J. Agric. Chem. Environ., 2016, 5, 170-178.
[14]
Sabry, A.; El-Said, A.H.M.; El-Zayat, S.A.; Abdel-Motaal, F.F.; Magraby, T.A. Fungal contamination of Ammi visnaga seeds, antimicrobial activity of theplant seeds secondary metabolites and detection of alkaloids and non-alkalo ids compounds. Int. J. Curr. Microbiol. Appl. Sci., 2014, 3, 901-914.
[15]
Beltagy, M.A.; Beltagy, M.D. Chemical composition of Ammi visnaga L. and new cytotoxic activity of its constituents khellin and visnagin. J. Pharm. Sci. Res., 2015, 7, 285-291.
[16]
Kamal, A.; Khan, W.; Ahmad, S.; Ahmad, F.J.; Saleem, K. Development and validation of high-performance liquid chromatography and high-performance thin-layer chromatography methods for the quantification of khellin in Ammi visnaga seed. J. Pharm. Bioallied Sci., 2015, 7, 308-313.
[17]
Duarte, J.; Lugnier, C.; Torres, A.I.; Pérez-Vizcaino, F.; Zarzuelo, A.; Tamargo, J. Effects of visnagin on cyclic nucleotide phosphodiesterases and their role in its inhibitory effects on vascular smooth muscle contraction. Gen. Pharmacol., 1999, 32, 71-74.
[18]
Vrzal, R.; Frauenstein, K.; Proksch, P.; Abel, J.; Dvorak, Z.; Haarmann-Stemmann, T. Khellin and visnagin differentially modulate AHR signaling and downstream CYP1A activity in human liver cells. PLoS One, 2013, 8, e74917.
[19]
Kwon, M.S.; Lee, J.K.; Park, S.H.; Sim, Y.B.; Jung, J.S.; Won, M.H.; Kim, S.M.; Suh, H.W. Neuroprotective effect of visnagin on kainic acid-induced neuronal cell death in the mice hippocampus. Korean J. Physiol. Pharmacol., 2010, 14, 257-263.
[20]
Jan, M. Effects of Ammi visnaga (Bisnaga) extract on the volume and acidity of stimulated gastric secretion in fasting rabbits. J. Coll. Physicians Surg. Pak., 2014, 24, 39-42.
[21]
El-Nakkady, S.S.; Roaiah, H.F.; El-Serwy, W.S.; Soliman, A.M.; Abd El-Moez, S.I.; Abdel-Rahman, A.A.H. Antitumor and antimicrobial activities of some hetero aromatic benzofurans derived from naturally occurring visnagin. Acta Pol. Pharm. Drug Res., 2012, 69, 645-655.
[22]
Haug, K.G.; Weber, B.; Hochhaus, G.; Butterweck, V. Nonlinear pharmacokinetics of visnagin in rats after intravenous bolus administration. Eur. J. Pharm. Sci., 2012, 45, 79-89.
[23]
Schimmer, O. Studies on the photobiological activity of two naturally occurring furochromones, visnagin and khellin, in Chlamydomonas reinhardtii. Mutagenesis, 1997, 12, 141-145.
[24]
Kuriakose, R.K.; Kukreja, R.C.; Xi, L. Potential therapeutic strategies for hypertension-exacerbated cardiotoxicity of anticancer drugs. Oxid. Med. Cell Longev, 2016, 2016
[25]
Duarte, J.; Torres, A.I.; Zarzuelo, A. Cardiovascular effects of visnagin on rats. Planta Med., 2000, 66, 35-39.
[26]
Xi, L. Visnagin-a new protectant against doxorubicin cardiotoxicity? Inhibition of mitochondrial malate dehydrogenase 2 (MDH2) and beyond. Ann. Transl. Med., 2016, 4, 65.
[27]
Liu, Y.; Asnani, A.; Zou, L.; Bentley, V.L.; Yu, M.; Wang, Y.; Dellaire, G.; Sarkar, K.S.; Dai, M.; Chen, H.H.; Sosnovik, D.E. Visnagin protects against doxorubicin-induced cardiomyopathy through modulation of mitochondrial malate dehydrogenase. Sci. Transl. Med., 2014, 6(266), 266ra170.
[28]
Duarte, J.; Pérez-Vizcaíno, F.; Torres, A.I.; Zarzuelo, A.; Jiménez, J.; Tamargo, J. Vasodilator effects of visnagin in isolated rat vascular smooth muscle. Eur. J. Pharmacol., 1995, 286(2), 115-122.
[29]
Rauwald, H.W.; Brehm, O.; Odenthal, K.P. The involvement of a Ca2+ channel blocking mode of action in the pharmacology of Ammi visnaga Fruits. Planta Med., 1994, 60, 101-115.
[30]
Lee, J.K.; Jung, J.S.; Park, S.H.; Park, S.H.; Sim, Y.B.; Kim, S.M.; Ha, T.S.; Suh, H.W. Anti-inflammatory effect of visnagin in lipopolysaccharide-stimulated BV-2 microglial cells. Arch. Pharm. Res., 2010, 33, 1843-1850.
[31]
Abu-Hashem, A.A.; Youssef, M.M. Synthesis of new visnagen and khellin furochromone pyrimidine derivatives and their anti-inflammatory and analgesic activity. Molecules, 2011, 16, 1956-1972.
[32]
Karton, Y.; Jiang, J.L.; Ji, X.D.; Melman, N.; Olah, M.E.; Stiles, G.L.; Jacobson, K.A. Synthesis and biological activities of flavonoid derivatives as A3 adenosine receptor antagonists. J. Med. Chem., 1996, 39, 2293-2301.
[33]
Vanachayangkul, P.; Chow, N.; Khan, S.R.; Butterweck, V. Prevention of renal crystal deposition by an extract of Ammi visnaga L. and its constituents khellin and visnagin in hyperoxaluric rats. Urol. Res., 2011, 39, 189-195.
[34]
Vanachayangkul, P.; Byer, K.; Khan, S.; Butterweck, V. An aqueous extract of Ammi visnaga fruits and its constituents khellin and visnagin prevent cell damage caused by oxalate in renal epithelial cells. Phytomedicine, 2010, 17, 653-658.
[35]
Hassaneen, H.M.; Atta, S.M.S.; Fawzy, N.M.; Ahmed, F.A.; Hegazi, A.G.; Abdalla, F.A.; Abd El Rahman, A.H. A new synthesis of oxadiazole, thiazolidinone, N-phthalimidoamino carbonyl and arylidene derivatives with potential antimicrobial activity. Arch. Pharm. (Weinheim), 2002, 335, 251-261.
[36]
Mabrouk, S.S.; El-Shayeb, N.M.A. Inhibition of aflatoxin production in Aspergillus flavus by natural coumarins and chromones. World J. Microbiol. Biotechnol., 1992, 8, 60-62.
[37]
Pavela, R.; Vrchotová, N.; Tříska, J. Larvicidal activity of extracts from Ammi visnaga Linn. (Apiaceae) seeds against Culex quinquefasciatus Say. (Diptera: Culicidae). Exp. Parasitol., 2016, 165, 51-57.
[38]
Abdelhafez, O.M.; Abedelatif, N.A.; Badria, F.A. DNA binding, antiviral activities and cytotoxicity of new furochromone and benzofuran derivatives. Arch. Pharm. Res., 2011, 34, 1623-1632.
[39]
Ragab, F.A.; Hassan, G.S.; Yossef, H.A.; Hashem, H.A. Synthesis of 6- and 9-alkylaminomethyl furoflavones as gastroprotective agents. Eur. J. Med. Chem., 2007, 42, 1117-1127.
[40]
Schimmer, O.; Rauch, P. Inhibition of metabolic activation of the promutagens, benzo[a]pyrene, 2-aminofluorene and 2-amino-anthracene by furanochromones in Salmonella typhimurium. Mutagenesis, 1998, 13, 385-389.
[41]
Edenharder, R.; Tang, X. Inhibition of the mutagenicity of 2-nitrofluorene, 3-nitrofluoranthene and 1-nitropyrene by flavonoids, coumarins, quinones and other phenolic compounds. Food Chem. Toxicol., 1997, 35, 357-372.
[42]
Niccolai, N.; Bovalini, L.; Martelli, P. The mechanisms of interaction between furanochromones and DNA. A heteronuclear overhauser effect study on the khellin-thymidine model system. Biophys. Chem., 1986, 24, 217-220.
[43]
Chen, X.; Kagan, J. Photosensitized cleavage and cross-linking of pBR322 DNA with khellin and visnagin. J. Photochem. Photobiol. B, 1993, 20, 183-189.
[44]
Borges, M.L.; Latterini, L.; Elisei, F.; Silva, P.F.; Borges, R.; Becker, R.S.; Maçanita, A.L. Photophysical properties and photobiological activity of the furanochromones visnagin and khellin. Photochem. Photobiol., 1998, 67, 184-191.
[45]
Haug, K.; Weber, B.; Hochhaus, G.; Butterweck, V. Pharmacokinetic evaluation of visnagin and ammi visnaga aqueous extract after oral administration in rats. Planta Med., 2012, 78, 1831-1836.
[46]
Kaul, B.; Staba, E.J. Visnagin: Biosynthesis and isolation from Ammi visnagi suspension cultures. Science, 1965, 150, 1731-1732.
[47]
Aneja, R.; Mukerjee, S.K.; Seshadri, T.R. Synthesis of benzofuran derivatives-II : A new synthesis of visnagin. Tetrahedron, 1958, 3, 230-235.
[48]
Hessein, S.A.; El-Sharief, M.A.; Abbas, S.Y.; Thabet, H.K.; Ammar, Y.A. Synthesis and antimicrobial activity of furochromone, benzofuran and furocoumarin derivatives bearing sulfonyl moiety. Croat. Chem. Acta, 2016, 89, 91-100.
[49]
Badawi, M.M.; Fayez, M.B.E. Natural chromones-VII. A new total synthesis of visnagin. Tetrahedron Lett., 1967, 8, 1029-1032.
[50]
Winderl, B.; Schwaiger, S.; Ganzera, M. Fast and improved separation of major coumarins in Ammi visnaga (L.) Lam. by supercritical fluid chromatography. J. Sep. Sci., 2016, 39, 4042-4048.
[51]
Badr, J.M.; Hadad, G.M.; Nahriry, K.; Hassanean, H.A. Validated HPLC method for simultaneous estimation of khellol glucoside, khellin and visnagin in Ammi visnaga L. fruits and pharmaceutical preparations. Nat. Prod. Res., 2015, 29, 593-601.
[52]
Vanachayangkul, P.; Butterweck, V.; Frye, R.F. Determination of visnagin in rat plasma by liquid chromatography with tandem mass spectrometry and its application to in vivo pharmacokinetic studies. J. Chromatogr. B Analyt. Technol. Biomed. Life Sci., 2009, 877(7), 653-656.
[53]
El-Gogary, S.; Grabner, G. Ultraviolet photoionization of the photosensitizers khellin and visnagin in aqueous solution and in micelles: One-photon ionization is a minor process. Photochem. Photobiol. Sci., 2006, 5, 311-316.
[54]
Günaydin, K.; Beyazit, N. The chemical investigations on the ripe fruits of Ammi visnaga (Lam.) Lamarck growing in Turkey. Nat. Prod. Res., 2004, 18, 169-175.
[55]
Mawatari, K.; Mashiko, S.; Watanabe, M.; Nakagomi, K. Fluorometric determination of khellin in human urine and serum by high-performance liquid chromatography using postcolumn photoirradiation. Anal. Sci., 2003, 19, 1071-1073.
[56]
Günaydin, K.; Erim, F.B. Determination of khellin and visnagin in Ammi visnaga fruits by capillary electrophoresis. J. Chromatogr. A, 2002, 954, 291-294.
[57]
Pan, J.X.; Han, Z.H.; Miao, J.L.; Yao, S.D.; Lin, N.Y.; Zhu, Y.D. Furanochromone radical cations: generation, characterization and interaction with DNA. Biophys. Chem., 2001, 91, 105-113.
[58]
Zgórka, G.; Dragan, T.; Głowniak, K.; Basiura, E. Determination of furanochromones and pyranocoumarins in drugs and Ammi visnaga fruits by combined solid-phase extraction-high-perfor-mance liquid chromatography and thin-layer chromatography-high-performance liquid chromatography. J. Chromatogr. A, 1998, 797, 305-309.
[59]
Sayed, H.M.; Mohamed, M.H.; Farag, S.F.; Mohamed, G.A.; Proksch, P. A new steroid glycoside and furochromones from Cyperus rotundus L. Nat. Prod. Res., 2007, 21, 343-350.
[60]
El‐Domiaty, M.M. Improved high‐performance liquid chromato-graphic determination of khellin and visnagin in Ammi visnaga fruits and pharmaceutical formulations. J. Pharm. Sci., 1992, 81, 475-478.
[61]
Abounassif, M.A.; Gad-Kariem, E.A.; Wahbi, A.M. High performance liquid chromatographic determinations of Khellin, phenobarbitone and dipyrone combination in tablets. Farmaco, 1990, 45, 465-472.
[62]
Franchi, G.G.; Bovalini, L.; Martelli, P.; Ferri, S.; Sbardellati, E. High performance liquid chromatography analysis of the furanochromones khellin and visnagin in various organs of Ammi visnaga (L.) Lam. at different developmental stages. J. Ethnopharmacol., 1985, 14, 203-212.
[63]
Fersi, H.; Platz, M.S. Nanosecond time-resolved infrared studies of visnagin and khellin triplets and radical ions. J. Phys. Chem. A, 2005, 109, 9206-9212.
[64]
Abu-Hashem, A.A.; El-Shazly, M. Synthesis, reactions and biological activities of furochromones: A review. Eur. J. Med. Chem., 2015, 90, 633-665.
[65]
Satrani, B.; Farah, A.; Fechtal, M.M.T.; Boumari, M.L. Chemical composition and antimicrobial and antifungal activities of the essential oil of Ammi visnaga (L.) Lam. Acta Bot. Bras., 2004, 151, 65-71.
[66]
Abdelfattah, A.; Aboulenein, M.N.; Wassel, G.M.; Elmenshawi, B. Preliminary report on the therapeutic effect of Khellin in Psoriasis. Dermatologica, 1983, 167, 109-110.
[67]
Valkova, S.; Trashlieva, M.; Christova, P. Treatment of vitiligo with local khellin and UVA: Comparison with systemic PUVA. Clin. Exp. Dermatol., 2004, 29, 180-184.
[68]
Hudson, J.; Towers, G.H.N. Phytomedicines as antivirals. Drugs Future, 1999, 24, 295-320.
[69]
Harvengt, C.; Desager, J.P.; Lecart, C. Effects on plasma apoproteins AI and B induced by two estroprogestin preparations: Monophasic versus triphasic. Curr. Ther. Res. Clin. Exp., 1983, 33, 385-393.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version559msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[18:46:28] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[18:46:28] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[18:46:28] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (146ms)time
  • Application (413ms)time
  • 1 x Application (73.91%)
    413ms
    1 x Booting (26.09%)
    146ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated319ms
    • 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 ('316642695','',1,1740422788,1740422788) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740422788
      1.23msalphaeurekaselec_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 ('316642695','/article/89340',1,1740422788,1740422788)
      210μ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 >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) 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 >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) 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 >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) 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 >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) 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 >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) 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 >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316642695 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316642695) limit 1
      26.18msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316642695
      • 1: 316642695
      • 2: 316642695
      • 3: 316642695
      • 4: 316642695
      • 5: 316642695
      • 6: 316642695
      • 7: 316642695
      • 8: 316642695
      • 9: 316642695
      • 10: 316642695
      • 11: 316642695
      • 12: 316642695
      • 13: 316642695
      • 14: 316642695
      • 15: 316642695
      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=89340
      8.99msalphaeurekaselec_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` = 118 limit 1
      1.07msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 118
      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=118) and sj.journal_id!=118 group by `j`.`nid`) as `aggregate_table`
      1.04msalphaeurekaselec_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=118) and sj.journal_id!=118 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.06msalphaeurekaselec_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=118) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      157msalphaeurekaselec_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=118) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      8.61msalphaeurekaselec_live_10_06_2022Subject.php#220
      Backtrace
      • 14. app/Models/Subject.php:220
      • 15. app/Http/Controllers/ArticleController.php:2518
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `keywords` where `article_id` = '89340'
      1.41msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 89340
      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` = '89340'
      2.05msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 89340
      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` = '89340' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.7msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 89340
      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
      210μ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
      420μ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 = 118 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      28.91msalphaeurekaselec_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 = 118 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      6.03msalphaeurekaselec_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 = 118 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      3.76msalphaeurekaselec_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` = 89340 limit 1
      200μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 89340
      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 = 89340 and content_type = 'article' order by status desc limit 1
      270μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid article_nid,a.title article_title,j.title journal_title from content_by_diseases cd inner join article a on a.article_id=cd.content_id inner join journal j on j.journal_id=a.journal_id where cd.pid = 295 and cd.sub_disease_id = 605 and content_id!=89340 and cd.content_type = 'article' order by rand() limit 20
      30.85msalphaeurekaselec_live_10_06_2022Article.php#769
      Backtrace
      • 11. app/Models/Article.php:769
      • 12. app/Http/Controllers/ArticleController.php:2098
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 160784 limit 1
      300μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 160784
      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
      280μ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` = 'NPJ' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      360μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: NPJ
      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 = '89340' 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) )
      480μ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 = '9120' 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) )
      400μ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 = '2613' 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) )
      370μ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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740422788 and j.to_date >= 1740422788 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2613) 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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740422788 and j.to_date >= 1740422788 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2613) 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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740422788 and j.to_date >= 1740422788 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2613)
      26.32msalphaeurekaselec_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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740422788 and j.to_date >= 1740422788 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9120) 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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740422788 and j.to_date >= 1740422788 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9120) 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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740422788 and j.to_date >= 1740422788 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9120)
      800μ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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740422788 and j.to_date >= 1740422788 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 89340) 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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740422788 and j.to_date >= 1740422788 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 89340) 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 <= 316642695 and j.to_ip >=316642695 )) and ((j.from_date <= 1740422788 and j.to_date >= 1740422788 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 89340)
      760μ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` < '197' and is_uploaded = 1 and issue_id = 9120 order by cast(first_page as SIGNED) desc limit 1
      570μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 197
      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` > '206' and is_uploaded = 1 and issue_id = 9120 order by cast(first_page as SIGNED) asc limit 1
      520μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 206
      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'
      190μ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
      220μ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` = 89340 limit 1
      3.66msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 89340
      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` = 118 and `b`.`banner_from_date` <= 1740422788 and `b`.`banner_to_date` >= 1740422788 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.5msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 118
      • 3: 1740422788
      • 4: 1740422788
      • 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` = 118 and `b`.`banner_from_date` <= 1740422788 and `b`.`banner_to_date` >= 1740422788 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.34msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 118
      • 3: 1740422788
      • 4: 1740422788
      • 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='de021e703adb3bd5e00d2e49452b5876'
      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
        idZ4kX51WqbUe8QcjYWgaa7OAJjPiTU350hqJ4UB
        uc_cart_id
        de021e703adb3bd5e00d2e49452b5876
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/89340" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/89340
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Mon, 24 Feb 2025 18:46:28 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlorVUU5SzFDUlpVZ3V0aG4xRXR1aEE9PSIsInZhbHVlIjoidm5pTGZGN0V1N3lKTWw3bzdvbUJQbk5aNng1cFk2QlNZN3hDNnhaZS9aOUF3VFUrK1NUazVBVXhuNlBGbit0aXlMVXlRV3RBNkp0U2lKcStGZEpUT1JWUnowYXZkSkpHWWhXNkxQOTFraDZ3UTVMeExKYkVZRlpGOTJSaEtYczUiLCJtYWMiOiIyMWUzMWY2OWVjOTM4OTU0YWY0ZDZhYWJkMDZiYjY1Yjg2OTg3ZmIwN2NiMDA5ZDQzYmVhNjcxYmZiNmM0MDg3IiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 06:46:28 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlorVUU5SzFDUlpVZ3V0aG4xRXR1aEE9PSIsInZhbHVlIjoidm5pTGZGN0V1N3lKTWw3bzdvbUJQbk5aNng1cFk2QlNZN3hDNnhaZS9aOUF3VFUrK1NUazVBVXhuNlBGbit0aXlMVXlRV" 1 => "alphaeurekaselectnet_session=eyJpdiI6IklTaGp1VkIyMjBTWTBSamROUXZPOFE9PSIsInZhbHVlIjoiWXA3Q3RiOGZmNVNtMDNFWC93MFVZTmhkZ0pZNkMxbTNCSzdEN2RBZ3RaNFZXU2cvang0NFU4c1pFVWhORWZyVlFOTldTZTl4R3R5NmFxWit5cUFiWEhmQkFTR1hYOEFyaGhvOHFuQWRsVmIrZnpULy9JdW13eFEreVdwcm43SFIiLCJtYWMiOiI3Yzk4OGQzNDRkNDFlZjhkYTRiMjZjMjBiMDliYzc5Mjk4ZmZkYWY0Yzg2NmYwZjZiMTA3YmE1ZWZkZjIwZGUyIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IklTaGp1VkIyMjBTWTBSamROUXZPOFE9PSIsInZhbHVlIjoiWXA3Q3RiOGZmNVNtMDNFWC93MFVZTmhkZ0pZNkMxbTNCSzdEN2RBZ3RaNFZXU2cvang0NFU4c1p" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlorVUU5SzFDUlpVZ3V0aG4xRXR1aEE9PSIsInZhbHVlIjoidm5pTGZGN0V1N3lKTWw3bzdvbUJQbk5aNng1cFk2QlNZN3hDNnhaZS9aOUF3VFUrK1NUazVBVXhuNlBGbit0aXlMVXlRV3RBNkp0U2lKcStGZEpUT1JWUnowYXZkSkpHWWhXNkxQOTFraDZ3UTVMeExKYkVZRlpGOTJSaEtYczUiLCJtYWMiOiIyMWUzMWY2OWVjOTM4OTU0YWY0ZDZhYWJkMDZiYjY1Yjg2OTg3ZmIwN2NiMDA5ZDQzYmVhNjcxYmZiNmM0MDg3IiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 06:46:28 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlorVUU5SzFDUlpVZ3V0aG4xRXR1aEE9PSIsInZhbHVlIjoidm5pTGZGN0V1N3lKTWw3bzdvbUJQbk5aNng1cFk2QlNZN3hDNnhaZS9aOUF3VFUrK1NUazVBVXhuNlBGbit0aXlMVXlRV" 1 => "alphaeurekaselectnet_session=eyJpdiI6IklTaGp1VkIyMjBTWTBSamROUXZPOFE9PSIsInZhbHVlIjoiWXA3Q3RiOGZmNVNtMDNFWC93MFVZTmhkZ0pZNkMxbTNCSzdEN2RBZ3RaNFZXU2cvang0NFU4c1pFVWhORWZyVlFOTldTZTl4R3R5NmFxWit5cUFiWEhmQkFTR1hYOEFyaGhvOHFuQWRsVmIrZnpULy9JdW13eFEreVdwcm43SFIiLCJtYWMiOiI3Yzk4OGQzNDRkNDFlZjhkYTRiMjZjMjBiMDliYzc5Mjk4ZmZkYWY0Yzg2NmYwZjZiMTA3YmE1ZWZkZjIwZGUyIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IklTaGp1VkIyMjBTWTBSamROUXZPOFE9PSIsInZhbHVlIjoiWXA3Q3RiOGZmNVNtMDNFWC93MFVZTmhkZ0pZNkMxbTNCSzdEN2RBZ3RaNFZXU2cvang0NFU4c1p" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "idZ4kX51WqbUe8QcjYWgaa7OAJjPiTU350hqJ4UB" "uc_cart_id" => "de021e703adb3bd5e00d2e49452b5876" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/89340" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-24 18:46:28GET/article/89340314371