Generic placeholder image

Current Analytical Chemistry

Editor-in-Chief

ISSN (Print): 1573-4110
ISSN (Online): 1875-6727

General Review Article

Extraction Procedures and Analytical Methods for the Determination of Methylene Blue, Rhodamine B and Crystal Violet - An Overview

Author(s): Afnan A.H. Hakami, Saikh M. Wabaidur, Moonis A. Khan, Zeid A. AlOthman and Masoom R. Siddiqui*

Volume 17, Issue 5, 2021

Published on: 25 November, 2020

Page: [708 - 728] Pages: 21

DOI: 10.2174/1573411017999201125203536

Price: $65

Abstract

Background: Dyes have been a blessing to mankind owing to their numerous applications in several industries ranging from textile, food, pharmaceuticals, and paper to leather, and many more. At the same time, these dyes pose a potential threat to mankind, when they are present beyond their permissible limits. This review covers the extraction and determination methods of dyes in different matrices.

Introduction: Methylene blue (MB), rhodamine B (RB), and crystal violet (CV) are the three cationic dyes discussed in this review. These dyes can pose a potential threat to biota beyond their permissible limits.

Methods: This review article mentions different analytical methods and extraction techniques involved in the determination of dyes.

Result: Almost all the analytical methods reported in this article involve proper extraction of the analyte, which finds a place in this review article. Spectrophotometric and electrochemical methods are cost-effective, although the former is less sensitive than the latter. Liquid chromatography (LC) and liquid chromatography coupled with mass spectrometry (LC/MS) are capable of simultaneously determining a number of dyes.

Conclusion: This review also offers a compilation of different mobile phase combinations that have been used for the quantitative analysis of these three dyes. The article also contains a list of different solvents for liquid-liquid extraction and different types of sorbent materials used during the solid-phase extraction of the reviewed dyes.

Keywords: Methylene blue, rhodamine B, crystal violet, extraction procedure, determination, analytical methods.

« Previous
Graphical Abstract

[2]
Ginimuge, P.R.; Jyothi, S.D. Methylene blue: revisited. J. Anaesthesiol. Clin. Pharmacol., 2010, 26(4), 517-520.
[PMID: 21547182]
[3]
Gillman, P.K. CNS toxicity involving methylene blue: the exemplar for understanding and predicting drug interactions that precipitate serotonin toxicity. J. Psychopharmacol., 2011, 25(3), 429-436.
[http://dx.doi.org/10.1177/0269881109359098] [PMID: 20142303]
[4]
Garza, F.; Kearney, T.E. Chapter 205. Methylene Blue in Poisoning drug overdose; The McGraw-Hill Companies, 2012.
[5]
Vutskits, L.; Briner, A.; Klauser, P.; Gascon, E.; Dayer, A.G.; Kiss, J.Z.; Muller, D.; Licker, M.J.; Morel, D.R. Adverse effects of methylene blue on the central nervous system. Anesthesiology, 2008, 108(4), 684-692.
[http://dx.doi.org/10.1097/ALN.0b013e3181684be4] [PMID: 18362601]
[6]
Muthuraman, G.; Teng, T.T.; Leh, C.P.; Norli, I. Extraction and recovery of methylene blue from industrial wastewater using benzoic acid as an extractant. J. Hazard. Mater., 2009, 163(1), 363-369.
[http://dx.doi.org/10.1016/j.jhazmat.2008.06.122] [PMID: 18782652]
[7]
El-Ashtoukhy, E-S.Z.; Fouad, Y.O. Liquid–liquid extraction of methylene blue dye from aqueous solutions using sodium dodecylbenzenesulfonate as an extractant. Alexandria Eng. J., 2015, 54(1), 77-81.
[http://dx.doi.org/10.1016/j.aej.2014.11.007]
[8]
Soniya, M.; Muthuraman, G. Recovery of methylene blue from aqueous solution by liquid–liquid extraction Desal. water Treat., 2015, 53, 2501-2509..
[http://dx.doi.org/10.1080/19443994.2013.866055]
[9]
Swathi, P.; Muthuraman, G. Extraction and Stripping of Methylene Blue from Industrial Wastewater by Liquid-Liquid Extraction. SSRG Int. J. App. Chem., 2019, 6(2), 14-22.
[http://dx.doi.org/10.14445/23939133/IJAC-V6I2P103]
[10]
Soniya, M.; Muthuraman, G. Comparative study between liquid–liquid extraction and bulk liquid membrane for the removal and recovery of methylene blue from wastewater. J. Ind. Eng. Chem., 2015, 30, 266-273.
[http://dx.doi.org/10.1016/j.jiec.2015.05.032]
[11]
Talbi, Z.; Haddou, B.; Ghouas, H.; Kameche, M.; Derriche, Z. Gourdon. C. Cationic Dye Removal from Aqueous Solutions Using Ionic Liquid and Nonionic Surfactant-Ionic Liquid Systems: A Comparative Study Based upon Experimental Design. Chem. Eng. Commun., 2014, 201(1), 41-52.
[http://dx.doi.org/10.1080/00986445.2012.759563]
[12]
Pandit, P.; Basu, S. Removal of organic dyes from water by liquid-liquid extraction using reverse micelles. J. Colloid Interface Sci., 2002, 245(1), 208-214.
[http://dx.doi.org/10.1006/jcis.2001.7939] [PMID: 16290352]
[13]
Razmara, R.S.; Daneshfar, A.; Sahrai, R. Determination of methylene blue and sunset yellow in wastewater and food samples using salting-out assisted liquid–liquid extraction. J. Ind. Eng. Chem., 2011, 17, 533-536.
[http://dx.doi.org/10.1016/j.jiec.2010.10.028]
[14]
Regel-Rosocka, M.; Szymanowski, J. Direct Yellow and Methylene Blue liquid-liquid extraction with alkylene carbonates. Chemosphere, 2005, 60(8), 1151-1156.
[http://dx.doi.org/10.1016/j.chemosphere.2005.01.019] [PMID: 15993164]
[15]
Marshall, P.N.; Lewis, S.M. The purification of methylene blue and azure B by solvent extraction and crystallization. Stain Technol., 1975, 50(6), 375-381.
[http://dx.doi.org/10.3109/10520297509117095] [PMID: 1226556]
[16]
Kinugasa, T.; Hashimoto, T.; Nishii, Y. Reversed Micellar Extraction of Methylene blue by using Di(2-ethylhexyl) phosphoric Acid. Solvent Extr. Res. Dev. Jpn., 2015, 22(2), 169-176.
[http://dx.doi.org/10.15261/serdj.22.169]
[17]
Chen, X.; Li, F.; Asumana, C.; Yu, G. Extraction of soluble dyes from aqueous solutions with quaternary ammonium-based ionic liquids. Separ. Purif. Tech., 2013, 106, 105-109.
[http://dx.doi.org/10.1016/j.seppur.2013.01.002]
[18]
Xu, J-Z.; Dai, L.; Wu, B.; Ding, T.; Zhu, J-J.; Lin, H.; Chen, H-L.; Shen, C-Y.; Jiang, Y. Determination of methylene blue residues in aquatic products by liquid chromatography-tandem mass spectrometry. J. Sep. Sci., 2009, 32(23-24), 4193-4199.
[http://dx.doi.org/10.1002/jssc.200900364] [PMID: 20066681]
[19]
Belaz-David, N.; Decosterd, L.A.; Appenzeller, M.; Ruetsch, Y.A.; Chioloro, R.; Buclin, T.; Biollaz, J. Spectrophotometric determination of methylene blue in biological fluids after ion-pair extraction and evidence of its adsorption on plastic polymers. Eur. J. Pharm. Sci., 1997, 5, 335-345.
[http://dx.doi.org/10.1016/S0928-0987(97)00061-4]
[20]
Ahmadi, R.; Kazemi, G.; Ramezani, A.M.; Safavi, A. Shaker-assisted liquid-liquid microextraction of methylene blue using deep eutectic solvent followed by back-extraction and spectrophotometric determination. Microchem. J., 2019, 145, 501-507.
[http://dx.doi.org/10.1016/j.microc.2018.11.005]
[21]
Żwir-Ferenc, A.; Biziuk, M. Solid Phase Extraction Technique – Trends, Opportunities and Applications. Polish. J. Environ. Stud. (Northborough), 2006, 15(5), 677-690.
[22]
Andrade-Eiroa, A.; Canle, M.; Leroy-Cancellieri, V.; Cerdà, V. Solid-phase extraction of organic compounds: A critical review. part ii. TrAC., 2016, 80, 655-667.
[http://dx.doi.org/10.1016/j.trac.2015.08.014]
[23]
Liska, I.; Bilikova, K. Stability of polar pesticides on disposable solid-phase extraction precolumns. J. Chromatogr. A, 1998, 795, 61-69.
[http://dx.doi.org/10.1016/S0021-9673(97)01038-8]
[25]
Khan, M.R.; Khan, M.A.; Alothman, Z.A.; Alsohaimi, I.H.; Naushad, M.; Al-Shaalan, N.H. Quantitative determination of methylene blue in environmental samples by solid-phase extraction and ultra-performance liquid chromatographytandem mass spectrometry: a green approach. RSC Advances, 2014, 4, 34037-34044.
[http://dx.doi.org/10.1039/C4RA03504F]
[26]
Youssef, A.M.; Al-Awadhi, M.M.; Akl, M.A. Solid Phase Extraction and Spectrophotometric Determination of Methylene Blue in Environmental Samples using Bentonite and Acid Activated Bentonite from Egypt. Anal. Bioanal. Tech., 2014, 5, 179.
[27]
Tang, D.; Santschi, P.H. Sensitive determination of dissolved sulfide in estuarine water by solid-phase extraction and high-performance liquid chromatography of methylene blue. J. Chromatogr. A, 2000, 883(1-2), 305-309.
[http://dx.doi.org/10.1016/S0021-9673(00)00381-2] [PMID: 10910224]
[28]
Khaled, E.; Elries, M.A.; Zidane, F.I.; Shaban, S.; Abdel-Monem, M.S. Potentiometric determination of methylene blue in pharmaceutical preparation using simple PVC electrode. Anal. Chem. An Indian J., 2010, 9(3), 334-341.
[29]
Wen, M.L.; Zhao, Y.B.; Chen, X.; Wang, C.Y. Potentiometric sensor for methylene blue based on methylene blue-silicotungstate ion association and its pharmaceutical applications. J. Pharm. Biomed. Anal., 1999, 18(6), 957-961.
[http://dx.doi.org/10.1016/S0731-7085(98)00104-6] [PMID: 9925330]
[30]
Piccardi, G.; Pergola, F.; Foresti, M.L. Guidelli. R. A detailed analysis of the polarographic behaviour of methylene blue in phosphate buffer on mercury. J. Electroanal. Chem. Interfacial Electrochem., 1977, 84(2), 235-253.
[http://dx.doi.org/10.1016/S0022-0728(77)80375-6]
[31]
Nekouei, F.; Kargarzadeh, H.; Nekouei, S.; Keshtpour, F.; Makhlouf, A.S.H. Efficient method for determination of methylene blue dye in water samples based on a combined dispersive solid phase and cloud point extraction using Cu(OH)2 nanoflakes: central composite design optimization. Anal. Bioanal. Chem., 2017, 409(4), 1079-1092.
[http://dx.doi.org/10.1007/s00216-016-0026-7] [PMID: 27815609]
[32]
Kirsten, W.J.; Patel, V.J. On the Spectrophotometric Measurement of Methylene Blue. Microchem. J., 1972, 17, 277-284.
[http://dx.doi.org/10.1016/0026-265X(72)90065-3]
[33]
Onur, F.; Acar, N. Simultaneous determination of methylene blue, hexamethylene tetramine and resorcinol in pharmaceutical formulations by first-derivative UV spectrophotometry. Int. J. Pharm., 1992, 78, 89-91.
[http://dx.doi.org/10.1016/0378-5173(92)90359-A]
[34]
Badiee, H.; Zanjanchi, M.A.; Zamani, A.; Fashi, A. Hollow fiber liquid-phase microextraction based on the use of a rotating extraction cell: A green approach for trace determination of rhodamine 6G and methylene blue dyes. Environ. Pollut., 2019, 255(Pt 2), 113287.
[PMID: 31600705]
[35]
Borwitzky, H.; Haefeli, W.E.; Burhenne, J. Analysis of methylene blue in human urine by capillary electrophoresis. J. Chromatogr. B Analyt. Technol. Biomed. Life Sci., 2005, 826(1-2), 244-251.
[http://dx.doi.org/10.1016/j.jchromb.2005.09.013] [PMID: 16182616]
[36]
Li, N.; Shi, X-J.; Guo, F-H.; Wang, Z-M.; Cui, X-Y. Zhong. M.-K. Determination of methylene blue in pig plasma using RP-HPLC with solid phase extraction. J. Chin. Pharm. Sci., 2011, 46(3), 231-234.
[37]
Li, L.I.; Lei, T.; Jia-yu, H.; Min, Z.; Yi, Z. HPLC determination of related substances of methylene blue. Yaowu Fenxi Zazhi, 2008, 28, 1698-1701.
[38]
Roybal, J.E.; Munns, R.K.; Holland, D.C.; Hurlbut, J.A.; Long, A.R. Application of Electrochemical and UV/Visible Detection to the LC Separation and Determination of Methylene Blue and Its Demethylated Metabolites from Milk.Analysis of Antibiotic/Drug Residues in Food Products of Animal Origin; Agarwal, V.K., Ed.; Springer: Boston, MA, 1992.
[http://dx.doi.org/10.1007/978-1-4615-3356-6_16]
[39]
Michał, J.M.; Krzesimir, C.; Magdalena, B.F.; Julia, J.; Marta, K. Fast Method for Quantitative Determination of Methylene Blue by Micellar Electrokinetic Chromatography Biomed. J. Sci. Tech. Res., 2018, 3(3)
[40]
Chen, R-C.; Wei, K-J.; Wang, T-M.; Yu, Y-M.; Li, J-Y.; Lee, S-H.; Wang, W-H.; Ren, T-J. Tsai. C.-W. Simultaneous quantification of antibiotic dyes inaquatic products and feeds by liquid chromatography- tandem mass spectrometry. Yao Wu Shi Pin Fen Xi, 2013, 21, 339-346.
[41]
Kim, S-J.; Ha, D-J.; Koo, T-S. Simultaneous quantification of methylene blue and its major metabolite, azure B, in plasma by LC-MS/MS and its application for a pharmacokinetic study. Biomed. Chromatogr., 2014, 28(4), 518-524.
[http://dx.doi.org/10.1002/bmc.3063] [PMID: 24122875]
[42]
Yang, F.; Xia, S.; Liu, Z.; Chen, J.; Lin, Y.; Qiu, B.; Chen, G. Analysis of methylene blue and its metabolites in blood by capillary electrophoresis/electrospray ionization mass spectrometry. Electrophoresis, 2011, 32(6-7), 659-664.
[http://dx.doi.org/10.1002/elps.201000514] [PMID: 21328395]
[43]
Nagaraja, R.; Kottam, N.; Girija, C.R.; Nagabhushana, B.M. Photocatalytic degradation of Rhodamine B dye under UV/solar light using ZnO nanopowder synthesized by solution combustion route. Powder Technol., 2012, 91-97.
[44]
Richardson, S.D.; Willson, C.S.; Rusch, K.A. Use of Rhodamine water tracer in the marshland upwelling system. Ground Water, 2004, 42(5), 678-688.
[http://dx.doi.org/10.1111/j.1745-6584.2004.tb02722.x] [PMID: 15457791]
[45]
Kim, H.N.; Lee, M.H.; Kim, H.J.; Kim, J.S.; Yoon, J. A new trend in rhodamine-based chemosensors: application of spirolactam ring-opening to sensing ions. Chem. Soc. Rev., 2008, 37(8), 1465-1472.
[http://dx.doi.org/10.1039/b802497a] [PMID: 18648672]
[46]
Yang, Q.; Zou, J.; Chirumarry, S.; Huo, C.; Tang, L.; Zhang, F.; Xiang, Y.; Zuo, H.; Shin, D-S.; Peng, X. A New Rhodamine B based Fluorescent Probe for pH Detection and Bioimaging under Strong Acidic Conditions. Bull. Korean Chem. Soc., 2016, 37(9), 1453-1457.
[http://dx.doi.org/10.1002/bkcs.10888]
[47]
Shelley, W.B. Fluorescent staining of elastic tissue with Rhodamine B and related xanthene dyes. Histochemie, 1969, 20(3), 244-249.
[http://dx.doi.org/10.1007/BF00306012] [PMID: 4190306]
[48]
Kolmakov, K.; Belov, V.N.; Bierwagen, J.; Ringemann, C.; Müller, V.; Eggeling, C.; Hell, S.W. Red-emitting rhodamine dyes for fluorescence microscopy and nanoscopy. Chemistry, 2010, 16(1), 158-166.
[http://dx.doi.org/10.1002/chem.200902309] [PMID: 19950338]
[49]
Khaled, E.; El-Ries, M.A.; Zidane, F.I.; Ibrahim, S.A. A Simple Potentiometric Sensor for Rhodamine B. Sensing in electrolysis, 2010, 5, 127-140..
[50]
Roda, G.; Faggiani, F.; Bolchi, C.; Pallavicini, M.; Dei Cas, M. Review’. Anal. Sci., 2019, 35(5), 479-491.
[http://dx.doi.org/10.2116/analsci.18R004] [PMID: 30686797]
[51]
Jain, R.; Mathur, M.; Sikarwar, S.; Mittal, A. Removal of the hazardous dye rhodamine B through photocatalytic and adsorption treatments. J. Environ. Manage., 2007, 85(4), 956-964.
[http://dx.doi.org/10.1016/j.jenvman.2006.11.002] [PMID: 17239520]
[52]
Zhang, J.; Zhang, L.; Wang, W. Sensitive Electrochemical Determination of Rhodamine B Based on a Silica-Pillared Zirconium Phosphate/Nafion Composite Modified Glassy Carbon Electrode. J. AOAC Int., 2016, 99, 760-765.
[http://dx.doi.org/10.5740/jaoacint.15-0262] [PMID: 27076279]
[53]
Qi, P.; Lin, Z.; Li, J.; Wang, C.; Meng, W.; Hong, H.; Zhang, X. Development of a rapid, simple and sensitive HPLC-FLD method for determination of rhodamine B in chili-containing products. Food Chem., 2014, 164, 98-103.
[http://dx.doi.org/10.1016/j.foodchem.2014.05.036] [PMID: 24996311]
[54]
Tatebe, C.; Zhong, X.; Ohtsuki, T.; Kubota, H.; Sato, K.; Akiyama, H. A simple and rapid chromatographic method to determine unauthorized basic colorants (rhodamine B, auramine O, and pararosaniline) in processed foods. Food Sci. Nutr., 2014, 2(5), 547-556.
[http://dx.doi.org/10.1002/fsn3.127] [PMID: 25473512]
[55]
Bişgin, A.T.; Sürme, Y.; Uçan, M. Narin, Separation, Preconcentration and Spectrophotometric Determination of Rhodamine B in Industrial, Cosmetic and Water Samples by Cloud Point and Solid Phase Extraction. J. Anal. Chem., 2018, 73(5), 452-458.
[http://dx.doi.org/10.1134/S1061934818050040]
[56]
Chiang, T-L.; Wang, Y-C.; Ding, W-H. Trace Determination of Rhodamine B and Rhodamine 6G Dyes in Aqueous Samples by Solid-phase Extraction and High-performance Liquid Chromatography Coupled with Fluorescence Detection. J. Chin. Chem. Soc. (Taipei), 2012, 59, 515-519.
[http://dx.doi.org/10.1002/jccs.201100318]
[57]
Soylak, M.; Unsal, Y.E.; Yilmaz, E.; Tuzen, M. Determination of rhodamine B in soft drink, waste water and lipstick samples after solid phase extraction. Food Chem. Toxicol., 2011, 49(8), 1796-1799.
[http://dx.doi.org/10.1016/j.fct.2011.04.030] [PMID: 21570440]
[58]
Ozkantar, N.; Soylak, M.; Tuzen, M. Spectrophotometric detection of rhodamine B in tap water, lipstick, rouge, and nail polish samples after supramolecular solvent microextraction. Turk. J. Chem., 2017, 41, 987-994.
[http://dx.doi.org/10.3906/kim-1702-72]
[59]
Unsal, Y.E.; Soylak, M.; Tuzen, M. Dispersive liquid–liquid microextraction–spectrophotometry combination for determination of rhodamine B in food, water, and environmental samples. Desal. Water Treat., 2018, 55(8), 1459-1462.
[60]
Yilmaz, E.; Soylak, M. A novel and simple deep eutectic solvent based liquid phase microextraction method for rhodamine B in cosmetic products and water samples prior to its spectrophotometric determination. Spectrochim. Acta A Mol. Biomol. Spectrosc., 2018, 202, 81-86.
[http://dx.doi.org/10.1016/j.saa.2018.04.073] [PMID: 29778709]
[61]
Gagliardi, L.; Orsi, D.D.; Cavazzutti, G.; Multari, G.; Tonelli, D. HPLC Determination of Rhodamine B (C.I. 45170) in Cosmetic Products. Chromatographia, 1996, 43, 76-78.
[http://dx.doi.org/10.1007/BF02272825]
[62]
Unsal, Y.E.; Soylak, M.; Tuzen, M. Spectrophotometric Detection of Rhodamine B after Separation-Enrichment by Using Multi-walled Carbon Nanotubes. J. AOAC Int., 2014, 97(5), 1459-1462.
[http://dx.doi.org/10.5740/jaoacint.12-458] [PMID: 25903000]
[63]
Shi, J.; Chen, L. Determination of rhodamine B in lipsticks by high performance liquid chromatography after extraction with AOT reversed micelles. Anal. Methods, 2014, 6, 8627-8632.
[http://dx.doi.org/10.1039/C4AY01740D]
[64]
Pourreza, N.; Rastegarzadeh, S.; Larki, A. Micelle-mediated cloud point extraction and spectrophotometric determination of rhodamine B using Triton X-100. Talanta, 2008, 77, 733-736.
[http://dx.doi.org/10.1016/j.talanta.2008.07.031]
[65]
Hasanin, T.H.A.; Tsukahara, S.; Fujiwara, T. Acid-base behavior of rhodamine B in a reversed micellar medium of cetyltrimethylammonium chloride in 1-hexanol-cyclohexane/water. Anal. Sci., 2010, 26(12), 1247-1254.
[http://dx.doi.org/10.2116/analsci.26.1247] [PMID: 21157092]
[66]
Arabi, M.; Ostovan, A.; Bagheri, A.R.; Guo, X.; Li, J.; Ma, J.; Chen, L. Hydrophilic molecularly imprinted nanospheres for the extraction of rhodamine B followed by HPLC analysis: A green approach and hazardous waste elimination. Talanta, 2020, 215120933
[http://dx.doi.org/10.1016/j.talanta.2020.120933] [PMID: 32312469]
[67]
Wang, Z.; Zhang, L.; Li, N.; Lei, L.; Shao, M.; Yang, X.; Song, Y.; Yu, A.; Zhang, H.; Qiu, F. Ionic liquid-based matrix solid-phase dispersion coupled with homogeneous liquid-liquid microextraction of synthetic dyes in condiments. J. Chromatogr. A, 2014, 1348, 52-62.
[http://dx.doi.org/10.1016/j.chroma.2014.04.086] [PMID: 24857032]
[68]
Hassan, S.S.; El-Shahawi, M.S.; Othman, A.M.; Mosaad, M.A. A potentiometric rhodamine-B based membrane sensor for the selective determination of chromium ions in wastewater. Anal. Sci., 2005, 21(6), 673-678.
[http://dx.doi.org/10.2116/analsci.21.673] [PMID: 15984204]
[69]
Yu, L.; Mao, Y.; Qu, L. Simple Voltammetric Determination of Rhodamine B by Using the Glassy Carbon Electrode in Fruit Juice and Preserved Fruit. Food Anal. Methods, 2013, 6, 1665-1670.
[http://dx.doi.org/10.1007/s12161-013-9580-1]
[70]
He, Q.; Liu, J.; Xia, Y.; Tuo, D.; Deng, P.; Tian, Y.; Wu, Y.; Li, G.; Chen, D. Rapid and Sensitive Voltammetric Detection of Rhodamine B in Chili-Containing Foodstuffs Using MnO2 Nanorods/Electro-Reduced Graphene Oxide Composite. J. Electrochem. Soc., 2019, 166(10), B805-B813.
[http://dx.doi.org/10.1149/2.1271910jes]
[71]
Yi, Y.; Sun, H.; Zhu, G.; Zhang, Z.; Wu, X. Sensitive Electrochemical Determination of Rhodamine B Based on Cyclodextrin-Functionalized Nanogold/Hollow Carbon Nanospheres. Anal. Methods, 2015, 7(12), 4965-4970.
[http://dx.doi.org/10.1039/C5AY00654F]
[72]
Razi-Asrami, M.; Ghasemi, J.B.; Amiri, N.; Sadeghi, S.J. Simultaneous spectrophotometric determination of crystal violet and malachite green in water samples using partial least squares regression and central composite design after preconcentration by dispersive solid-phase extraction. Environ. Monit. Assess., 2017, 189(4), 196.
[http://dx.doi.org/10.1007/s10661-017-5898-2] [PMID: 28361487]
[73]
Azarkohan, A.; Shemirani, F.; Alvand, M. .Fast Analysis of Water Samples for Trace Amount of Crystal Violet Dye Based on Solid Phase Extraction Using Nanoporous SBA-3 prior to Determination by Fiber Optic-Linear Array Detection Spectrophotometry. J. Chem., 2013, 530843.
[http://dx.doi.org/10.1155/2013/530843]
[74]
Lian, Z.; Wang, J. Determination of crystal violet in seawater and seafood samples through off-line molecularly imprinted SPE followed by HPLC with diode-array detection. J. Sep. Sci., 2013, 36(5), 980-985.
[http://dx.doi.org/10.1002/jssc.201200939] [PMID: 23390113]
[75]
Yantih, N.; Lestari, D.A. . Validation of visible spectrophotometry for determination of rhodamine b in lipstick Published at The 24th FAPA Congress in Bali Nusa Dua Convention Center, Bali, IndonesiaSeptember, 13-16th. 2012.
[76]
Cai, S-S.; Stark, J.D. A method for the determination of rhodamine b and brilliant sulfaflavine on cotton string collectors and in a spray tank solution mixture. J. Environ. Sci. Health B, 1997, 32(6), 985-1004.
[http://dx.doi.org/10.1080/03601239709373124]
[77]
Bhooma, V.; Nagasathiya, K.; Vairamani, M.; Parani, M. Identification of synthetic dyes magenta III (new fuchsin) and rhodamine B as common adulterants in commercial saffron. Food Chem., 2020, 309125793
[http://dx.doi.org/10.1016/j.foodchem.2019.125793] [PMID: 31699557]
[78]
Tonica, W.W.; Hardianti, M.F.; Prasetya, S.A.; Rachmaniaha, O. Determination of Rhodamine-B and Amaranth in Snacks at Primary School Sukolilo District of Surabaya-Indonesia by Thin Layer Chromatography. AIP Conf. Proc., 2018, 2049020043
[http://dx.doi.org/10.1063/1.5082448]]
[80]
Nevitasar, R.; Rohman, A.; Martono, S. Validation and quantitative analysis of carmine and rhodamine b in lipstick formulation Int. J. App. Pharmaceut., 2019, 11, 176-180.
[http://dx.doi.org/10.22159/ijap.2019v11i3.32492]
[81]
Yantih, N.; Aziza, Z.; Prasetya, A.D. Optimization and Validation of HPLC for the Analysis of Rhodamine-B in Sponge Cake Proceedings of The 9 th Joint Conference on Chemistry., FSM, Diponegoro University. 2015.
[82]
Cheng, Y-Y.; Tsai, T-H. A validated LC-MS/MS determination method for the illegal food additive rhodamine B: Applications of a pharmacokinetic study in rats. J. Pharm. Biomed. Anal., 2016, 125, 394-399.
[http://dx.doi.org/10.1016/j.jpba.2016.04.018] [PMID: 27131149]
[83]
AlTamimi, A.; AlRabeh, M.; AlTamimi, A.; AlAjlan, A.; Alowaifeer, A. Fast and simple method for the detection and quantification of 15 synthetic dyes in sauce, cotton candy, and pickle by liquid chromatography/tandem mass spectrometry. Arab. J. Chem., 2020, 13, 3882-3888.
[http://dx.doi.org/10.1016/j.arabjc.2019.09.008]
[84]
Mittal, A.; Mittal, J.; Malviya, A.; Kaur, D.; Gupta, V.K. Adsorption of hazardous dye crystal violet from wastewater by waste materials. J. Colloid Interface Sci., 2010, 343(2), 463-473.
[http://dx.doi.org/10.1016/j.jcis.2009.11.060] [PMID: 20045526]
[85]
Maley, A.M.; Arbiser, J.L. Gentian violet: a 19th century drug re-emerges in the 21st century. Exp. Dermatol., 2013, 22(12), 775-780.
[http://dx.doi.org/10.1111/exd.12257] [PMID: 24118276]
[86]
Choudhary, K.N.; Soni, P.P.; Sao, D.K.; Murthy, R.; Deshkar, A.M.; Nanda, B.R. Role of gentian violet paint in burn wound management: a prospective randomised control trial. J. Indian Med. Assoc., 2013, 111(4), 248-250.
[PMID: 24475556]
[87]
Krause, R.G.E.; Goldring, J.P.D. Crystal violet stains proteins in SDS-PAGE gels and zymograms. Anal. Biochem., 2019, 566, 107-115.
[http://dx.doi.org/10.1016/j.ab.2018.11.015] [PMID: 30458124]
[88]
Kadoo, P.; Dandekar, R.; Kulkarni, M.; Mahajan, A.; Kumawat, R.; Parate, N. Correlation of mitosis obtained by using 1% crystal violet stain with Ki67LI in histological grades of oral squamous cell carcinoma. J. Oral Biol. Craniofac. Res., 2018, 8(3), 234-240.
[http://dx.doi.org/10.1016/j.jobcr.2017.09.010] [PMID: 30191116]
[89]
Suzuki, T.; Hara, T.; Kitagawa, Y.; Yamaguchi, T. Magnified endoscopic observation of early colorectal cancer by linked color imaging with crystal violet staining (with video). Gastrointest. Endosc., 2016, 84(4), 726-729.
[http://dx.doi.org/10.1016/j.gie.2016.05.023] [PMID: 27215791]
[90]
Senthilkumaar, S.; Kalaamani, P.; Subburaam, C.V. Liquid phase adsorption of Crystal violet onto activated carbons derived from male flowers of coconut tree. J. Hazard. Mater., 2006, 136(3), 800-808.
[http://dx.doi.org/10.1016/j.jhazmat.2006.01.045] [PMID: 16675107]
[91]
Li, S. Removal of crystal violet from aqueous solution by sorption into semi-interpenetrated networks hydrogels constituted of poly(acrylic acid-acrylamide-methacrylate) and amylose. Bioresour. Technol., 2010, 101(7), 2197-2202.
[http://dx.doi.org/10.1016/j.biortech.2009.11.044] [PMID: 19969451]
[92]
Patil, S.R.; Sutar, S.S.; Jadhav, J.P. Sorption of crystal violet from aqueous solution using live roots of Eichhornia crassipes: Kinetic, isotherm, phyto and cyto-genotoxicity studies. Environ. Technol. Innovat., 2020, 100648
[http://dx.doi.org/10.1016/j.eti.2020.100648]]
[93]
Mani, S.; Bharagava, R.N. Exposure to Crystal Violet, Its Toxic, Genotoxic and Carcinogenic Effects on Environment and Its Degradation and Detoxification for Environmental Safety. Rev. Environ. Contam. Toxicol., 2016, 237, 71-104.
[http://dx.doi.org/10.1007/978-3-319-23573-8_4] [PMID: 26613989]
[94]
An, L.; Deng, J.; Zhou, L.; Li, H.; Chen, F.; Wang, H.; Liu, Y. Simultaneous spectrophotometric determination of trace amount of malachite green and crystal violet in water after cloud point extraction using partial least squares regression. J. Hazard. Mater., 2010, 175(1-3), 883-888.
[http://dx.doi.org/10.1016/j.jhazmat.2009.10.092] [PMID: 19939555]
[95]
Ghasemi, E.; Kaykhaii, M. Application of Micro-cloud point extraction for spectrophotometric determination of Malachite green, Crystal violet and Rhodamine B in aqueous samples. Spectrochim. Acta A Mol. Biomol. Spectrosc., 2016, 164, 93-97.
[http://dx.doi.org/10.1016/j.saa.2016.04.001] [PMID: 27085294]
[96]
Manzo, V.; Navarro, O.; Honda, L.; Sánchez, K.; Inés Toral, M.; Richter, P. Determination of crystal violet in water by direct solid phase spectrophotometry after rotating disk sorptive extraction. Talanta, 2013, 106, 305-308.
[http://dx.doi.org/10.1016/j.talanta.2012.11.004] [PMID: 23598132]
[97]
Sadeghi, S.; Nasehi, Z. Simultaneous determination of Brilliant Green and Crystal Violet dyes in fish and water samples with dispersive liquid-liquid micro-extraction using ionic liquid followed by zero crossing first derivative spectrophotometric analysis method. Spectrochim. Acta A Mol. Biomol. Spectrosc., 2018, 201, 134-142.
[http://dx.doi.org/10.1016/j.saa.2018.04.061] [PMID: 29747083]
[98]
Xie, J.; Peng, T.; Chen, D-D.; Zhang, Q-J.; Wang, G-M.; Wang, X.; Guo, Q.; Jiang, F.; Chen, D.; Deng, J. Determination of malachite green, crystal violet and their leuco-metabolites in fish by HPLC-VIS detection after immunoaffinity column clean-up. J. Chromatogr. B Analyt. Technol. Biomed. Life Sci., 2013, 913-914, 123-128.
[http://dx.doi.org/10.1016/j.jchromb.2012.12.002] [PMID: 23286983]
[99]
Lee, J.B.; Kim, H.Y.; Jang, Y.M.; Song, J.Y.; Woo, S.M.; Park, M.S.; Lee, H.S.; Lee, S.K.; Kim, M. Determination of malachite green and crystal violet in processed fish products Food Add. Contam., 2010, 27(7), 953-961.
[http://dx.doi.org/10.1080/19440041003705839]
[100]
ElHamd, M.A.; Ali, R.; Abdellatif, A.A.H. Non-Aqueous Titrimetric Assay for Determination of Loratadine in Pharmaceutical Preparations. J. Anal. Bioanal. Tech., 2016, 7(1), 294.
[101]
Masadome, T. Determination of Cationic Surfactants by a Photometric Titration Method with Crystal Violet as a Color Indicator. Anal. Lett., 2003, 37, 499-506.
[http://dx.doi.org/10.1081/AL-120028622]
[102]
Lan, Q.; Li, Q.; Zhang, X.; Chen, Z. A novel electrochemiluminescence system of CuS film and K2S2O8 for determination of crystal violet. J. Electroanal. Chem. (Lausanne Switz.), 2018, 810, 216-221.
[http://dx.doi.org/10.1016/j.jelechem.2018.01.008]
[103]
Pradel, J.S.; Tong, W.G. Determination of Malachite Green, Crystal Violet, Brilliant Green and Methylene Blue with Micro-Cloud-Point Extraction and Nonlinear Laser Wave-Mixing Detection Interfaced to Micellar Capillary Electrophoresis. Anal. Methods, 2017, 9(45), 6411-6419.
[http://dx.doi.org/10.1039/C7AY01706E]
[104]
Vishnu, D.; Dhandapani, B.; Authilingam, S.; Sivakumar, S.V. A Comprehensive Review of Effective Adsorbents Used for the Removal of Dyes from Wastewater. Curr. Anal. Chem.,
[http://dx.doi.org/10.2174/1573411016999200831111155]]
[105]
Al Shamari, Y.M.G.; Wabaidur, S.M.; Alwarthan, A.A.; Khan, M.A.; Siddiqui, M.R. Corncob Waste Based Adsorbent for Solid Phase Extraction of Tartrazine in Carbonated Drinks and Analytical Method using Ultra Performance Liquid Chromatography-Mass Spectrometry. Curr. Anal. Chem., 2020, 16, 924-932.
[http://dx.doi.org/10.2174/1573411015666191028113257]
[106]
Al Shamari, Y.M.G.; Alwarthan, A.A.; Wabaidur, S.M.; Khan, M.A.; Alqadami, A.A.; Siddiqui, M.R. New Ultra Performance liquid chromatography-mass spectrometric method for the determination of allura red in soft drinks using corncob as solid phase extraction sorbent: Analysis and food waste management approach. Journal of King Saud University-Science., 2019, 32, 1135-1141.
[http://dx.doi.org/10.1016/j.jksus.2019.10.011]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version368msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[06:25:34] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[06:25:34] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[06:25:34] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[06:25:34] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[06:25:34] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • warninglog[06:25:34] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (113ms)time
  • Application (255ms)time
  • 1 x Application (69.35%)
    255ms
    1 x Booting (30.65%)
    113ms
    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 duplicated175ms
    • 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 ('51872515','',1,1740551134,1740551134) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740551134
      1.04msalphaeurekaselec_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 ('51872515','/article/111846',1,1740551134,1740551134)
      200μ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 >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) 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 >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) 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 >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) 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 >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) 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 >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) 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 >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 51872515 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 51872515) limit 1
      30.79msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 51872515
      • 1: 51872515
      • 2: 51872515
      • 3: 51872515
      • 4: 51872515
      • 5: 51872515
      • 6: 51872515
      • 7: 51872515
      • 8: 51872515
      • 9: 51872515
      • 10: 51872515
      • 11: 51872515
      • 12: 51872515
      • 13: 51872515
      • 14: 51872515
      • 15: 51872515
      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=111846
      920μ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` = 4 limit 1
      850μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 4
      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=4) and sj.journal_id!=4 group by `j`.`nid`) as `aggregate_table`
      830μ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=4) and sj.journal_id!=4 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      700μ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=4) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      3.04msalphaeurekaselec_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=4) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      2.6msalphaeurekaselec_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` = '111846'
      1.57msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 111846
      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` = '111846'
      4.82msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 111846
      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` = '111846' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.79msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 111846
      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
      350μ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
      730μ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 = 4 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      79.57msalphaeurekaselec_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 = 4 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      12.94msalphaeurekaselec_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 = 4 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      9.61msalphaeurekaselec_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` = 111846 limit 1
      480μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 111846
      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 = 111846 and content_type = 'article' order by status desc limit 1
      400μ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` = 188394 limit 1
      1.72msalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 188394
      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
      340μ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` = 'CAC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      420μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CAC
      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 = '111846' 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) )
      520μ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 = '10676' 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) )
      450μ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 = '2918' 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) )
      440μ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 <= 51872515 and j.to_ip >=51872515 )) and ((j.from_date <= 1740551134 and j.to_date >= 1740551134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2918) 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 <= 51872515 and j.to_ip >=51872515 )) and ((j.from_date <= 1740551134 and j.to_date >= 1740551134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2918) 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 <= 51872515 and j.to_ip >=51872515 )) and ((j.from_date <= 1740551134 and j.to_date >= 1740551134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2918)
      7.65msalphaeurekaselec_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 <= 51872515 and j.to_ip >=51872515 )) and ((j.from_date <= 1740551134 and j.to_date >= 1740551134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10676) 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 <= 51872515 and j.to_ip >=51872515 )) and ((j.from_date <= 1740551134 and j.to_date >= 1740551134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10676) 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 <= 51872515 and j.to_ip >=51872515 )) and ((j.from_date <= 1740551134 and j.to_date >= 1740551134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10676)
      770μ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 <= 51872515 and j.to_ip >=51872515 )) and ((j.from_date <= 1740551134 and j.to_date >= 1740551134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 111846) 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 <= 51872515 and j.to_ip >=51872515 )) and ((j.from_date <= 1740551134 and j.to_date >= 1740551134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 111846) 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 <= 51872515 and j.to_ip >=51872515 )) and ((j.from_date <= 1740551134 and j.to_date >= 1740551134 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 111846)
      710μ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` < '708' and is_uploaded = 1 and issue_id = 10676 order by cast(first_page as SIGNED) desc limit 1
      730μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 708
      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` > '728' and is_uploaded = 1 and issue_id = 10676 order by cast(first_page as SIGNED) asc limit 1
      590μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 728
      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'
      200μ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
      230μ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` = 111846 limit 1
      2.44msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 111846
      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` = 4 and `b`.`banner_from_date` <= 1740551134 and `b`.`banner_to_date` >= 1740551134 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.3msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 4
      • 3: 1740551134
      • 4: 1740551134
      • 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` = 4 and `b`.`banner_from_date` <= 1740551134 and `b`.`banner_to_date` >= 1740551134 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.18msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 4
      • 3: 1740551134
      • 4: 1740551134
      • 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='1a5ab1c4f6568249f5828e4a0dd6e765'
      330μ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
        a9UcZhigcl8yIYrSIJidNdKsxPMjqUfcE9PBDOmL
        uc_cart_id
        1a5ab1c4f6568249f5828e4a0dd6e765
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/article/111846" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/111846
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:16 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 26 Feb 2025 06:25:34 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InFOZzZsNjRnckN6Y1RGd05EdzJxRUE9PSIsInZhbHVlIjoiN1BFbkdvMGhDTFIrNk1ja1R0eWxtWUVOMzRHWXRUZGZZbERiVDN4ZkRrcXhadHNRM2ZiZnUvbDUxZnFMVk5vTGxTcndZL012eUVaTFFVUzFXYTRTT1JuYloxSkE0Y25WOTVvV29vODc1QUxJUkU5OTgzM2dxb1M5MjFvTW5jVkwiLCJtYWMiOiIwOThhOWU0NWZlZDQ3ZGVjYzI1MTkyZGVhMTNmYWExZWQ1MDY2YjgzMjA3ZDEyZGEwMzVhYTk1NWFlMGU3NDI2IiwidGFnIjoiIn0%3D; expires=Fri, 28 Feb 2025 18:25:34 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6InFOZzZsNjRnckN6Y1RGd05EdzJxRUE9PSIsInZhbHVlIjoiN1BFbkdvMGhDTFIrNk1ja1R0eWxtWUVOMzRHWXRUZGZZbERiVDN4ZkRrcXhadHNRM2ZiZnUvbDUxZnFMVk5vTGxTcndZL" 1 => "alphaeurekaselectnet_session=eyJpdiI6Imhad1Z5UEVvYk0xUkVDbGRGK3RodEE9PSIsInZhbHVlIjoiQytwcnFKcys2Q2xWWWNMcjRIUHVqdTNDR0xJZmtEUjZDekhVQ05wc1h6Wk5ZK1FOOWtkMnpSWGJtT2pKVFFBb1lFRGhaWmRsck5CcndINjNlMU1HT3F6a2hlQ2ZMelNzVHhOV2x0K01FYjVCeWhPSjhvL1dUUGdlb1lucUdEQzciLCJtYWMiOiJjOWVmNGRiZmZhYTllMzcyN2ExZDRmYzM3MmVlOTk1MDQ0ODBiMGYzZDZlMjNiY2YwMTNkYjM2NDQ5OThmYjYzIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6Imhad1Z5UEVvYk0xUkVDbGRGK3RodEE9PSIsInZhbHVlIjoiQytwcnFKcys2Q2xWWWNMcjRIUHVqdTNDR0xJZmtEUjZDekhVQ05wc1h6Wk5ZK1FOOWtkMnpSWGJ" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InFOZzZsNjRnckN6Y1RGd05EdzJxRUE9PSIsInZhbHVlIjoiN1BFbkdvMGhDTFIrNk1ja1R0eWxtWUVOMzRHWXRUZGZZbERiVDN4ZkRrcXhadHNRM2ZiZnUvbDUxZnFMVk5vTGxTcndZL012eUVaTFFVUzFXYTRTT1JuYloxSkE0Y25WOTVvV29vODc1QUxJUkU5OTgzM2dxb1M5MjFvTW5jVkwiLCJtYWMiOiIwOThhOWU0NWZlZDQ3ZGVjYzI1MTkyZGVhMTNmYWExZWQ1MDY2YjgzMjA3ZDEyZGEwMzVhYTk1NWFlMGU3NDI2IiwidGFnIjoiIn0%3D; expires=Fri, 28-Feb-2025 18:25:34 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InFOZzZsNjRnckN6Y1RGd05EdzJxRUE9PSIsInZhbHVlIjoiN1BFbkdvMGhDTFIrNk1ja1R0eWxtWUVOMzRHWXRUZGZZbERiVDN4ZkRrcXhadHNRM2ZiZnUvbDUxZnFMVk5vTGxTcndZL" 1 => "alphaeurekaselectnet_session=eyJpdiI6Imhad1Z5UEVvYk0xUkVDbGRGK3RodEE9PSIsInZhbHVlIjoiQytwcnFKcys2Q2xWWWNMcjRIUHVqdTNDR0xJZmtEUjZDekhVQ05wc1h6Wk5ZK1FOOWtkMnpSWGJtT2pKVFFBb1lFRGhaWmRsck5CcndINjNlMU1HT3F6a2hlQ2ZMelNzVHhOV2x0K01FYjVCeWhPSjhvL1dUUGdlb1lucUdEQzciLCJtYWMiOiJjOWVmNGRiZmZhYTllMzcyN2ExZDRmYzM3MmVlOTk1MDQ0ODBiMGYzZDZlMjNiY2YwMTNkYjM2NDQ5OThmYjYzIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6Imhad1Z5UEVvYk0xUkVDbGRGK3RodEE9PSIsInZhbHVlIjoiQytwcnFKcys2Q2xWWWNMcjRIUHVqdTNDR0xJZmtEUjZDekhVQ05wc1h6Wk5ZK1FOOWtkMnpSWGJ" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "a9UcZhigcl8yIYrSIJidNdKsxPMjqUfcE9PBDOmL" "uc_cart_id" => "1a5ab1c4f6568249f5828e4a0dd6e765" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/article/111846" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-26 06:25:34GET/article/111846614361