Generic placeholder image

Current Analytical Chemistry

Editor-in-Chief

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

Research Article

Isolation and Purification of Kudinosides from Kuding Tea by Semi-Preparative HPLC Combined with MCI-GEL Resin

Author(s): Ji Tian, Xuanyuan Wang, Qingxin Shi, Xingliang Xiang, Chao Su, Yun Xie, Shuna Jin, Rongzeng Huang* and Chengwu Song*

Volume 16, Issue 7, 2020

Page: [914 - 923] Pages: 10

DOI: 10.2174/1573411015666191031153352

Price: $65

Abstract

Background: Kuding tea, a Traditional Chinese drink, has a history of thousands of years in China. Triterpenoid saponins in Kuding tea are regarded as one of the major functional ingredients.

Objective: The aim of this paper was to establish separation progress for the isolation and purification of five triterpenoid saponins (kudinoside A, C, D, F, G) from Kuding tea.

Methods: Nine types of resins, including seven macroporous resins and two MCI-GEL resins, were firstly used for purifying triterpenoid saponins by the adsorption and desorption tests. Further dynamic adsorption/desorption experiments were carried out to obtain the optimal parameters for the five targeted saponins. Then the purification of five triterpenoid saponins (kudinoside A, C, D, F, G) was completed by semi-preparative high-performance liquid chromatography (semi-pHPLC).

Results: As of optimized results, the HP20SS MCI-GEL was selected as the optimal one. The data also showed that 65.24 mg of refined extract including 7.04 mg kudinoside A, 3.52 mg kudinoside C, 4.04 mg kudinoside D, 4.13 mg kudinoside F, and 34.45 mg kudinoside G, could be isolated and purified from 645.90 mg of crude extract in which the content of five saponins was 81.51% and the average recovery reached 69.76%. The final contents of five saponins increased 6.91-fold as compared to the crude extract.

Conclusion: The established separation progress was highly efficient, making it a potential approach for the large-scale production in the laboratory and providing several markers of triterpenoid saponins for quality control of Kuding tea or its processing products.

Keywords: Enrichment, kuding tea, kudinoside, resin, semi-preparative HPLC, triterpenoid saponins.

Graphical Abstract

[1]
Song, C.; Yu, Q.; Li, X.; Jin, S.; Li, S.; Zhang, Y.; Jia, S.; Chen, C.; Xiang, Y.; Jiang, H. The hypolipidemic effect of total saponins from kuding tea in high-fat diet-induced hyperlipidemic mice and its composition characterized by UPLC-QTOF-MS/MS. J. Food Sci., 2016, 81(5), 1313-1319.
[http://dx.doi.org/10.1111/1750-3841.13299] [PMID: 27074384]
[2]
Thuong, P.T.; Su, N.D.; Ngoc, T.M.; Hung, T.M.; Dang, N.H.; Thuan, N.D.; Bae, K.; Oh, W.K. Antioxidant activity and principles of Vietnam bitter tea Ilex kudingcha. Food Chem., 2009, 113(1), 139-145.
[http://dx.doi.org/10.1016/j.foodchem.2008.07.041]
[3]
Liu, A.; Luo, Y.; Lin, Y. A review of the study on kudingcha. J. Chin. Med. Mater., 2002, 25(2), 148-150.
[PMID: 14740664]
[4]
Yang, M.; Zou, F.; Shi, Q.; Ji, S.; Wang, X.; Xiang, X.; Li, W.; Jin, S.; Huang, R.; Song, C. An efficient approach for enrichment of three isochlorogenic acids from Kuding tea using MCI-GEL resin. J. Liq. Chromatogr. Relat. Technol., 2018, 41(4), 188-195.
[http://dx.doi.org/10.1080/10826076.2018.1431276]
[5]
Fan, S.; Zhang, Y.; Hu, N.; Sun, Q.; Ding, X.; Li, G.; Zheng, B.; Gu, M.; Huang, F.; Sun, Y.Q.; Zhou, Z.; Lu, X.; Huang, C.; Ji, G. Extract of Kuding tea prevents high fat diet induced metabolic disorders in C57BL/6 mice via liver X receptor (LXR) β antagonism. PLoS One, 2012, 7(12) e51007
[http://dx.doi.org/10.1371/journal.pone.0051007] [PMID: 23226556]
[6]
Li, L.; Xu, L.J.; Ma, G.Z.; Dong, Y.M.; Peng, Y.; Xiao, P.G. The large-leaved Kudingcha (Ilex latifolia Thunb and Ilex kudingcha C.J. Tseng): a traditional Chinese tea with plentiful secondary metabolites and potential biological activities. J. Nat. Med., 2013, 67(3), 425-437.
[http://dx.doi.org/10.1007/s11418-013-0758-z] [PMID: 23529541]
[7]
Song, J.L.; Qian, Y.; Li, G.J.; Zhao, X. Anti-inflammatory effects of kudingcha methanol extract (Ilex kudingcha C.J. Tseng) in dextran sulfate sodium-induced ulcerative colitis. Mol. Med. Rep., 2013, 8(4), 1256-1262.
[http://dx.doi.org/10.3892/mmr.2013.1635] [PMID: 23969782]
[8]
Song, C.; Xie, C.; Zhou, Z.; Yu, S.; Fang, N. Antidiabetic effect of an active components group from ilex kudingcha and its chemical composition. Evid. Based Complement. Alternat. Med., 2012, 2012 423690
[http://dx.doi.org/10.1155/2012/423690] [PMID: 22474502]
[9]
Zhao, X.; Wang, Q.; Qian, Y.; Song, J.L. Ilex kudingcha C.J. Tseng (Kudingcha) has in vitro anticancer activities in MCF-7 human breast adenocarcinoma cells and exerts anti-metastatic effects in vivo. Oncol. Lett., 2013, 5(5), 1744-1748.
[http://dx.doi.org/10.3892/ol.2013.1253] [PMID: 23760150]
[10]
Zhu, K.; Li, G.; Sun, P.; Wang, R.; Qian, Y.; Zhao, X. In vitro and in vivo anti-cancer activities of Kuding tea (Ilex kudingcha C.J. Tseng) against oral cancer. Exp. Ther. Med., 2014, 7(3), 709-715.
[http://dx.doi.org/10.3892/etm.2013.1450] [PMID: 24520272]
[11]
Montoya, G.; Arango, G.J.; Unger, M.; Holzgrabe, U. O-glycoside sequence of pentacyclic triterpene saponins from Phytolacca bogotensis using HPLC-ESI/multi-stage tandem mass spectrometry. Phytochem. Anal., 2009, 20(6), 465-474.
[http://dx.doi.org/10.1002/pca.1148] [PMID: 19629957]
[12]
Liu, W.Y.; Feng, F.; Yu, C.X.; Xie, N. Qualitative and quantitative analysis of the main constituents of Radix Ilicis Pubescentis by LC-coupled with DAD and ESI-MS detection. Nat. Prod. Commun., 2010, 5(1), 23-26.
[http://dx.doi.org/10.1177/1934578X1000500106] [PMID: 20184013]
[13]
Qian, Z.M.; Lu, J.; Gao, Q.P.; Li, S.P. Rapid method for simultaneous determination of flavonoid, saponins and polyacetylenes in folium ginseng and radix ginseng by pressurized liquid extraction and high performance liquid chromatography coupled with diode array detection and mass spectrometry. J. Chromatogr. A, 2009, 1216(18), 3825-3830.
[http://dx.doi.org/10.1016/j.chroma.2009.02.065] [PMID: 19272605]
[14]
Capriotti, A.L.; Cavaliere, C.; Crescenzi, C.; Foglia, P.; Nescatelli, R.; Samperi, R.; Laganà, A. Comparison of extraction methods for the identification and quantification of polyphenols in virgin olive oil by ultra-HPLC-QToF mass spectrometry. Food Chem., 2014, 158(1), 392-400.
[http://dx.doi.org/10.1016/j.foodchem.2014.02.130] [PMID: 24731360]
[15]
Brusotti, G.; Cesari, I.; Dentamaro, A.; Caccialanza, G.; Massolini, G. Isolation and characterization of bioactive compounds from plant resources: the role of analysis in the ethnopharmacological approach. J. Pharm. Biomed. Anal., 2014, 87(1634), 218-228.
[http://dx.doi.org/10.1016/j.jpba.2013.03.007] [PMID: 23591140]
[16]
Zhou, Y.; Gao, X.; Fu, Q.; Guo, P.; Xu, X.; Zhang, T.; Ge, Y.; Zhang, B.; Wang, M.; Zeng, A.; Luo, Z.; Chang, C. Enrichment of total steroidal saponins from the extracts of Trillium tschonoskii Maxim by macroporous resin and the simultaneous determination of eight steroidal saponins in the final product by HPLC. J. Sep. Sci., 2017, 40(5), 1115-1124.
[http://dx.doi.org/10.1002/jssc.201600884] [PMID: 28044421]
[17]
Qi, X.L.; Peng, X.; Huang, Y.Y.; Li, L.; Wei, Z.F.; Zu, Y.G.; Fu, Y.J. Green and efficient extraction of bioactive flavonoids from Equisetum palustre L. by deep eutectic solvents-based negative pressure cavitation method combined with macroporous resin enrichment. Ind. Crops Prod., 2015, 70, 142-148.
[http://dx.doi.org/10.1016/j.indcrop.2015.03.026]
[18]
Sun, Y.; Yuan, H.; Hao, L.; Min, C.; Cai, J.; Liu, J.; Cai, P.; Yang, S. Enrichment and antioxidant properties of flavone C-glycosides from trollflowers using macroporous resin. Food Chem., 2013, 141(1), 533-541.
[http://dx.doi.org/10.1016/j.foodchem.2013.03.030] [PMID: 23768390]
[19]
Yang, W.Z.; Bo, T.; Ji, S.; Qiao, X.; Guo, D.A.; Ye, M. Rapid chemical profiling of saponins in the flower buds of Panax notoginseng by integrating MCI gel column chromatography and liquid chromatography/mass spectrometry analysis. Food Chem., 2013, 139(1-4), 762-769.
[http://dx.doi.org/10.1016/j.foodchem.2013.01.051] [PMID: 23561171]
[20]
Chen, F.; Luo, J.; Kong, L. Fast isolation of ginsenosides Re and Rg1 from the roots of by HSCCC-ELSD combined with MCI GEL CC guided by HPLC-MS. J. Liq. Chromatogr. Relat. Technol., 2012, 35(7), 912-923.
[http://dx.doi.org/10.1080/10826076.2011.613144]
[21]
Nie, W.; Luo, J.G.; Wang, X.B.; Wan, X.; Kong, L.Y. An insight into enrichment and separation of oleanane-type triterpenoid saponins by various chromatographic materials. Separ. Purif. Tech., 2009, 65(3), 243-247.
[http://dx.doi.org/10.1016/j.seppur.2008.10.042]
[22]
Li, C.; Zheng, Y.; Wang, X.; Feng, S.; Di, D. Simultaneous separation and purification of flavonoids and oleuropein from Olea europaea L. (olive) leaves using macroporous resin. J. Sci. Food Agric., 2011, 91(15), 2826-2834.
[http://dx.doi.org/10.1002/jsfa.4528] [PMID: 21744357]
[23]
Silva, E.M.; Pompeu, D.R.; Larondelle, Y.; Rogez, H. Optimisation of the adsorption of polyphenols from Inga edulis leaves on macroporous resins using an experimental design methodology. Separ. Purif. Tech., 2007, 53(3), 274-280.
[http://dx.doi.org/10.1016/j.seppur.2006.07.012]
[24]
Li, J.; Chase, H.A. Development of adsorptive (non-ionic) macroporous resins and their uses in the purification of pharmacologically-active natural products from plant sources. Nat. Prod. Rep., 2010, 27(10), 1493-1510.
[http://dx.doi.org/10.1039/c0np00015a] [PMID: 20820638]
[25]
Feng, J.; He, X.; Zhou, S.; Peng, F.; Liu, J.; Hao, L.; Li, H.; Ao, G.; Yang, S. Preparative separation of crocins and geniposide simultaneously from gardenia fruits using macroporous resin and reversed phase chromatography. J. Sep. Sci., 2014, 37(3), 314-322.
[http://dx.doi.org/10.1002/jssc.201300601] [PMID: 24259446]
[26]
Wang, R.; Peng, X.; Wang, L.; Tan, B.; Liu, J.; Feng, Y.; Yang, S. Preparative purification of peoniflorin and albiflorin from peony rhizome using macroporous resin and medium-pressure liquid chromatography. J. Sep. Sci., 2012, 35(15), 1985-1992.
[http://dx.doi.org/10.1002/jssc.201200120] [PMID: 22674837]
[27]
Chen, T.; Li, H.M.; Zou, D.L.; Du, Y.Z.; Shen, Y.H.; Li, Y. Preparation of two flavonoid glycosides with unique structures from barley seedlings by membrane separation technology and preparative high performance liquid chromatography. J. Sep. Sci., 2014, 37(24), 3760-3766.
[http://dx.doi.org/10.1002/jssc.201400798] [PMID: 25283274]
[28]
Zou, D.; Chen, T.; Chen, C.; Li, H.; Liu, Y.; Li, Y. An efficient protocol for preparation of gallic acid from terminalia bellirica (gaertn.) roxb by combination of macroporous resin and preparative high performance liquid chromatography. J. Chromatogr. Sci., 2016, 54(7), 1220-1224.
[http://dx.doi.org/10.1093/chromsci/bmw054] [PMID: 27076561]
[29]
Chen, T.; Liu, Y.; Zou, D.; Chen, C.; You, J.; Zhou, G.; Sun, J.; Li, Y. Application of an efficient strategy based on liquid-liquid extraction, high-speed counter-current chromatography, and preparative HPLC for the rapid enrichment, separation, and purification of four anthraquinones from Rheum tanguticum. J. Sep. Sci., 2014, 37(1-2), 165-170.
[http://dx.doi.org/10.1002/jssc.201300648] [PMID: 24166848]
[30]
Jin, H.; Liu, Y.; Feng, J.; Guo, Z.; Wang, C.; Zhong, Z.; Peng, X.; Dang, J.; Tao, Y.; Liang, X. Efficient purification of high-purity compounds from the stem of Lonicera japonica Thunb using two-dimensional preparative chromatography. J. Sep. Sci., 2013, 36(15), 2414-2420.
[http://dx.doi.org/10.1002/jssc.201300319] [PMID: 23720435]
[31]
Mangas, I.; Vilanova, E.; Benabent, M.; Estévez, J. Separating esterase targets of organophosphorus compounds in the brain by preparative chromatography. Toxicol. Lett., 2014, 225(1), 167-176.
[http://dx.doi.org/10.1016/j.toxlet.2013.12.003] [PMID: 24355587]
[32]
Yang, P.; Zhou, M.; Zhou, C.; Wang, Q.; Zhang, F.; Chen, J. Separation and purification of both tea seed polysaccharide and saponin from camellia cake extract using macroporous resin. J. Sep. Sci., 2015, 38(4), 656-662.
[http://dx.doi.org/10.1002/jssc.201401123] [PMID: 25491912]
[33]
Zhu, L.; Li, B.; Liu, X.; Meng, X. Purification of two triterpenoids from Schisandra chinensis by macroporous resin combined with high-speed counter-current chromatography. J. Chromatogr. Sci., 2014, 52(9), 1082-1088.
[http://dx.doi.org/10.1093/chromsci/bmt168] [PMID: 24220992]
[34]
Zhu, M.Z.; Wu, W.; Jiao, L.L.; Yang, P.F.; Guo, M.Q. Analysis of flavonoids in lotus (nelumbo nucifera) leaves and their antioxidant activity using macroporous resin chromatography coupled with LC-MS/MS and antioxidant biochemical assays. Molecules, 2015, 20(6), 10553-10565.
[http://dx.doi.org/10.3390/molecules200610553] [PMID: 26060918]
[35]
Shaheen, N.; Yin, L.; Gu, Y.; Rwigimba, E.; Xie, Q.; Wei, Y. Separation of isorhamnetin 3-sulphate and astragalin from Flaveria bidentis (L.) Kuntze using macroporous resin and followed by high-speed countercurrent chromatography. J. Sep. Sci., 2015, 38(11), 1933-1941.
[http://dx.doi.org/10.1002/jssc.201500119] [PMID: 25763770]
[36]
Su, J.W.; Jia, Z.M.; Xie, Y. [Study on ultrasonic extraction and macroporous resin purification techniques of total flavones from Sedum lineare] Zhong Yao Cai, 2013, 36(2), 298-301.
[PMID: 23901658]
[37]
Lu, C.; Luo, X.; Lu, L.; Li, H.; Chen, X.; Ji, Y. Preliminary extraction of tannins by 1-butyl-3-methylimidazole bromide and its subsequent removal from Galla chinensis extract using macroporous resins. J. Sep. Sci., 2013, 36(5), 959-964.
[http://dx.doi.org/10.1002/jssc.201200679] [PMID: 23362230]
[38]
Ouyang, M.A.; Wang, H.Q.; Chen, Z.L.; Yang, C.R. Triterpenoid glycosides from Ilex kudincha. Phytochemistry, 1996, 43(2), 443-445.
[http://dx.doi.org/10.1016/0031-9422(96)00015-5] [PMID: 8862036]
[39]
Ouyang, M.A.; Yang, C.R.; Wu, Z.J. Triterpenoid saponins from the leaves of Ilex kudincha. J. Asian Nat. Prod. Res., 2001, 3(1), 31-42.
[http://dx.doi.org/10.1080/10286020108042836] [PMID: 11355768]
[40]
Ding, Y.; Yang, X.M.; Pan, G.B.; Ma, H.L.; Liu, W.M. Adsorption and enrichment of alkalids from areca nut by means of macroporous resins. Adsorpt. Sci. Technol., 2012, 30(3), 193-204.
[http://dx.doi.org/10.1260/0263-6174.30.3.193]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version323msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[04:22:56] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[04:22:56] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[04:22:56] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (114ms)time
  • Application (209ms)time
  • 1 x Application (64.75%)
    209ms
    1 x Booting (35.25%)
    114ms
    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 duplicated120ms
    • 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 ('59228343','',1,1740457376,1740457376) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740457376
      1.11msalphaeurekaselec_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 ('59228343','/article/102023',1,1740457376,1740457376)
      160μ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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) 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 >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59228343 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59228343) limit 1
      11.92msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59228343
      • 1: 59228343
      • 2: 59228343
      • 3: 59228343
      • 4: 59228343
      • 5: 59228343
      • 6: 59228343
      • 7: 59228343
      • 8: 59228343
      • 9: 59228343
      • 10: 59228343
      • 11: 59228343
      • 12: 59228343
      • 13: 59228343
      • 14: 59228343
      • 15: 59228343
      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=102023
      600μ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
      710μ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`
      550μ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
      500μ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`
      2.51msalphaeurekaselec_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
      3.39msalphaeurekaselec_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` = '102023'
      810μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 102023
      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` = '102023'
      3.59msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 102023
      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` = '102023' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.73msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 102023
      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
      270μ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
      640μ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
      42.46msalphaeurekaselec_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
      9.45msalphaeurekaselec_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
      5.18msalphaeurekaselec_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` = 102023 limit 1
      760μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 102023
      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 = 102023 and content_type = 'article' order by status desc limit 1
      280μ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 = 258 and cd.sub_disease_id = 403 and content_id!=102023 and cd.content_type = 'article' order by rand() limit 20
      19.65msalphaeurekaselec_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` = 176319 limit 1
      210μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 176319
      Backtrace
      • 14. app/Models/Meta.php:30
      • 15. app/Http/Controllers/ArticleController.php:2101
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      210μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2108
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `tbl_ht_submission` as `h` where `h`.`subtitle` = 'CAC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      260μ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 = '102023' 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) )
      320μ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 = '10090' and content_type = 'i' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      260μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2207
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as total_count, content_type_access_id as access_type from journal_access where content_type_id = '2728' and content_type = 'v' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      240μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ArticleController.php:2231
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • (select j.user_access_id,j.volume_id,j.user_id,j.from_ip,j.to_ip,j.type,j.track,"Trial Access" as access_base_text, CASE j.type WHEN 111 THEN true ELSE false END as terms_popup, "S" as content_download_type, null as restricted_user_access_key, null as restricted_user_access_type, CASE j.track WHEN 0 THEN false ELSE true END as tracksAccessByVolume,"volume" as access_level,"" as issue_id,"" as article_id from `user_access_journal_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740457376 and j.to_date >= 1740457376 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2728) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740457376 and j.to_date >= 1740457376 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2728) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740457376 and j.to_date >= 1740457376 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2728)
      3.1msalphaeurekaselec_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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740457376 and j.to_date >= 1740457376 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10090) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740457376 and j.to_date >= 1740457376 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10090) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740457376 and j.to_date >= 1740457376 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10090)
      750μ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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740457376 and j.to_date >= 1740457376 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 102023) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740457376 and j.to_date >= 1740457376 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 102023) 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 <= 59228343 and j.to_ip >=59228343 )) and ((j.from_date <= 1740457376 and j.to_date >= 1740457376 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 102023)
      750μ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` < '914' and is_uploaded = 1 and issue_id = 10090 order by cast(first_page as SIGNED) desc limit 1
      650μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 914
      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` > '923' and is_uploaded = 1 and issue_id = 10090 order by cast(first_page as SIGNED) asc limit 1
      550μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 923
      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
      240μ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` = 102023 limit 1
      3.78msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 102023
      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` <= 1740457376 and `b`.`banner_to_date` >= 1740457376 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.22msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 4
      • 3: 1740457376
      • 4: 1740457376
      • 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` <= 1740457376 and `b`.`banner_to_date` >= 1740457376 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.07msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 4
      • 3: 1740457376
      • 4: 1740457376
      • 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='d41dd11cf4881fe0fbf6b17677831031'
      190μ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
        gfvjZz8Fh5P4DOIO8w3OPCoJIv0mMH4BFMHHRuIB
        uc_cart_id
        d41dd11cf4881fe0fbf6b17677831031
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/102023" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/102023
        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:9 [ "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6Ijh3Q0g2ZHlnU2RIWWVCYlFDR0dNRmc9PSIsInZhbHVlIjoicUdkUTlVVDM2L1l6QXoydFVqc3pIb0wrSDNNQ1EwZWQ1K2JyNnR2cS9OYz0iLCJtYWMiOiIwZDI4NTM5MzBkNjg1ZGMyMjA2NGJlMGE2ZWUwOWJjOWFkNzk2ODQ0MTdlNGI5NDMwYTY5MTA0NTdiY2U2N2FjIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6Ijh3Q0g2ZHlnU2RIWWVCYlFDR0dNRmc9PSIsInZhbHVlIjoicUdkUTlVVDM2L1l6QXoydFVqc3pIb0wrSDNNQ1EwZWQ1K2JyNnR2cS9OYz0iLCJtYWMiOiIwZDI4NTM5MzBkNjg1" ] "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
        0 of 0
        array:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 04:22:56 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJyM0o2WTYyQVFJS1BNYVFSanR3M3c9PSIsInZhbHVlIjoiMzhyRmphbTQ3TkNPSDBwZHk3MG9aUVNVQUtPWmVUck9qRy9zMzlFdzFMWGVTVXhRZHFYQzZJamUza1hiL09TWkVReE14aTRBQ0NSbmFoNG1kN1lkR3NBTytYWHlnNE5ianhhUHUxSGQ1WTJaYWphcEwzLysrQ3FGcGIwbHNkMnUiLCJtYWMiOiI3ZmVhZTcwNWYzYzJmNDAyNTBjYmY0MDJlYzZmMTIwYzA1NGIyYmZmNWRiZDVjMGE1ZGRiOWI4NzA1Mjc5ZWY0IiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 16:22:56 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlJyM0o2WTYyQVFJS1BNYVFSanR3M3c9PSIsInZhbHVlIjoiMzhyRmphbTQ3TkNPSDBwZHk3MG9aUVNVQUtPWmVUck9qRy9zMzlFdzFMWGVTVXhRZHFYQzZJamUza1hiL09TWkVReE14a" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlRHN0YrRVZBTStsbkMxRElrWE05VVE9PSIsInZhbHVlIjoiTVh5bDZjUnV4MC9PY1E1YlRITWphb2xBQjFmYkFhQ255Y1M4ays2c1NYa2t0SEVnejQ3bGJ0bzY3Zk1oOVlBQ3IxaFZrWDNzWEVnRzVUZk8ydnIwcHBJZjJMekZzWjhDQ3ErcXVtQ2h1R0dJbzg5Mm0ydTZUTE43bm1xczB0aWgiLCJtYWMiOiI3MTYwMTA1Y2NiNzkxYmY2YTZlM2NmMjdiYjVmMmU1MzdjYmIyN2Y1ODg2MDQ1MTU5MjczNWNmNGIwNDBhZTNjIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlRHN0YrRVZBTStsbkMxRElrWE05VVE9PSIsInZhbHVlIjoiTVh5bDZjUnV4MC9PY1E1YlRITWphb2xBQjFmYkFhQ255Y1M4ays2c1NYa2t0SEVnejQ3bGJ0bzY" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJyM0o2WTYyQVFJS1BNYVFSanR3M3c9PSIsInZhbHVlIjoiMzhyRmphbTQ3TkNPSDBwZHk3MG9aUVNVQUtPWmVUck9qRy9zMzlFdzFMWGVTVXhRZHFYQzZJamUza1hiL09TWkVReE14aTRBQ0NSbmFoNG1kN1lkR3NBTytYWHlnNE5ianhhUHUxSGQ1WTJaYWphcEwzLysrQ3FGcGIwbHNkMnUiLCJtYWMiOiI3ZmVhZTcwNWYzYzJmNDAyNTBjYmY0MDJlYzZmMTIwYzA1NGIyYmZmNWRiZDVjMGE1ZGRiOWI4NzA1Mjc5ZWY0IiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 16:22:56 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlJyM0o2WTYyQVFJS1BNYVFSanR3M3c9PSIsInZhbHVlIjoiMzhyRmphbTQ3TkNPSDBwZHk3MG9aUVNVQUtPWmVUck9qRy9zMzlFdzFMWGVTVXhRZHFYQzZJamUza1hiL09TWkVReE14a" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlRHN0YrRVZBTStsbkMxRElrWE05VVE9PSIsInZhbHVlIjoiTVh5bDZjUnV4MC9PY1E1YlRITWphb2xBQjFmYkFhQ255Y1M4ays2c1NYa2t0SEVnejQ3bGJ0bzY3Zk1oOVlBQ3IxaFZrWDNzWEVnRzVUZk8ydnIwcHBJZjJMekZzWjhDQ3ErcXVtQ2h1R0dJbzg5Mm0ydTZUTE43bm1xczB0aWgiLCJtYWMiOiI3MTYwMTA1Y2NiNzkxYmY2YTZlM2NmMjdiYjVmMmU1MzdjYmIyN2Y1ODg2MDQ1MTU5MjczNWNmNGIwNDBhZTNjIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlRHN0YrRVZBTStsbkMxRElrWE05VVE9PSIsInZhbHVlIjoiTVh5bDZjUnV4MC9PY1E1YlRITWphb2xBQjFmYkFhQ255Y1M4ays2c1NYa2t0SEVnejQ3bGJ0bzY" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "gfvjZz8Fh5P4DOIO8w3OPCoJIv0mMH4BFMHHRuIB" "uc_cart_id" => "d41dd11cf4881fe0fbf6b17677831031" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/102023" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 04:22:56GET/article/102023314371