Generic placeholder image

Endocrine, Metabolic & Immune Disorders - Drug Targets

Editor-in-Chief

ISSN (Print): 1871-5303
ISSN (Online): 2212-3873

Meta-Analysis

Effects of Teriparatide versus Salmon Calcitonin Therapy for the Treatment of Osteoporosis in Asia: A Meta-analysis of Randomized Controlled Trials

Author(s): Changjun Chen, Mohammed Alqwbani, Jie Zhao, Ruitong Yang, Songgang Wang* and Xin Pan*

Volume 21, Issue 5, 2021

Published on: 17 August, 2020

Page: [932 - 942] Pages: 11

DOI: 10.2174/1871530320999200817114817

Price: $65

Abstract

Objective: The objective of this meta-analysis was to compare the efficacy and safety of teriparatide versus salmon calcitonin for the treatment of osteoporosis in Asian patients and to investigate whether the results of global studies could be applicable to Asian patients.

Methods: PubMed, OVID, Cochrane Central Register of Controlled Trials (CENTRAL) and EMBASE up to December 2018 were searched. Eligible randomized controlled trials (RCTs) that compared teriparatide versus salmon calcitonin in Asian osteoporosis population were included. Preferred Reporting Items for Systematic Reviews and Meta-Analyses (PRISMA) guidelines were used for data synthesis, and Cochrane Collaboration software Review Manager 5.3 was used to analyze the pooled data.

Results: Three RCTs involving 529 patients were included (mean age 68.7 yr; 93.4% females; mean follow-up 6 months); outcome measures included bone mineral density (BMD) of the femoral neck, total hip and lumbar spine; bone markers and adverse events. We found that the period of 6-months of teriparatide treatment was helpful for the improvement of the BMD of lumbar vertebra, however, the improvement of BMD was not significant in the femoral neck and total hip joint. There was a positive correlation between bone-specific alkaline phosphatase (BSAP) and osteocalcin (OCN) and the response of Asian patients to subcutaneous injection of 20 micrograms per day of teriparatide. The proportion of the occurrence of adverse effects was more obvious in the teriparatide group compared with salmon calcitonin, but there was no significant difference.

Conclusion: Results suggested that the use of teriparatide could improve the lumbar BMD by shortterm (six months) application in Asian osteoporosis patients, which is beneficial to the patients who cannot tolerate adverse events of long-term treatment. The BSAP and OCN bone markers could be useful to monitor the responses of Asian osteoporosis patients to teriparatide treatment. Finally, both of teriparatide and salmon calcitonin were well tolerated by Asian patients.

Keywords: Teriparatide, salmon calcitonin, meta-analysis, osteoporosis, Asia, fractures.

Graphical Abstract

[1]
Sleeman, A.; Clements, J.N. Abaloparatide: a new pharmacological option for osteoporosis. Am. J. Health Syst. Pharm., 2019, 76(3), 130-135.
[http://dx.doi.org/10.1093/ajhp/zxy022] [PMID: 30689744]
[2]
Chen, P.; Li, Z.; Hu, Y. Prevalence of osteoporosis in China: a meta-analysis and systematic review. BMC Public Health, 2016, 16(1), 1039.
[http://dx.doi.org/10.1186/s12889-016-3712-7] [PMID: 27716144]
[3]
Lin, X.; Xiong, D.; Peng, Y.Q.; Sheng, Z.F.; Wu, X.Y.; Wu, X.P.; Wu, F.; Yuan, L.Q.; Liao, E.Y. Epidemiology and management of osteoporosis in the People’s Republic of China: current perspectives. Clin. Interv. Aging, 2015, 10, 1017-1033.
[http://dx.doi.org/10.2147/CIA.S54613] [PMID: 26150706]
[4]
Mithal, A.; Kaur, P. Osteoporosis in Asia: a call to action. Curr. Osteoporos. Rep., 2012, 10(4), 245-247.
[http://dx.doi.org/10.1007/s11914-012-0114-3] [PMID: 22898971]
[5]
Dobnig, H. A review of teriparatide and its clinical efficacy in the treatment of osteoporosis. Expert Opin. Pharmacother., 2004, 5(5), 1153-1162.
[http://dx.doi.org/10.1517/14656566.5.5.1153] [PMID: 15155114]
[6]
Sugimoto, T.; Shiraki, M.; Fukunaga, M.; Hagino, H.; Sone, T.; Nakano, T.; Kishimoto, H.; Ito, M.; Yoshikawa, H.; Kishida, M.; Irie, C.; Nakamura, T. 24-Month open-label teriparatide once-weekly efficacy research trial examining bone mineral density in subjects with primary osteoporosis and high fracture risk. Adv. Ther., 2017, 34(7), 1727-1740.
[http://dx.doi.org/10.1007/s12325-017-0568-x] [PMID: 28631217]
[7]
Muñoz-Torres, M.; Alonso, G.; Raya, M.P. Calcitonin therapy in osteoporosis. Treat. Endocrinol., 2004, 3(2), 117-132 [J]..
[http://dx.doi.org/10.2165/00024677-200403020-00006] [PMID: 15743107]
[8]
Binkley, N.; Bolognese, M.; Sidorowicz-Bialynicka, A.; Vally, T.; Trout, R.; Miller, C.; Buben, C.E.; Gilligan, J.P.; Krause, D.S. Oral calcitonin in postmenopausal osteoporosis (ORACAL) investigators. A phase 3 trial of the efficacy and safety of oral recombinant calcitonin: the oral calcitonin in postmenopausal osteoporosis (ORACAL) trial. J. Bone Miner. Res., 2012, 27(8), 1821-1829.
[http://dx.doi.org/10.1002/jbmr.1602] [PMID: 22437792]
[9]
Henriksen, K.; Bay-Jensen, A.C.; Christiansen, C.; Karsdal, M.A. Oral salmon calcitonin--pharmacology in osteoporosis. Expert Opin. Biol. Ther., 2010, 10(11), 1617-1629.
[http://dx.doi.org/10.1517/14712598.2010.526104] [PMID: 20932224]
[10]
Papadokostakis, G.; Damilakis, J.; Mantzouranis, E.; Katonis, P.; Hadjipavlou, A. The effectiveness of calcitonin on chronic back pain and daily activities in postmenopausal women with osteoporosis. Eur. Spine J., 2006, 15(3), 356-362.
[http://dx.doi.org/10.1007/s00586-005-0916-4] [PMID: 16193299]
[11]
Johnell, O.; Kanis, J.A.; Oden, A.; Johansson, H.; De Laet, C.; Delmas, P.; Eisman, J.A.; Fujiwara, S.; Kroger, H.; Mellstrom, D.; Meunier, P.J.; Melton, L.J., III; O’Neill, T.; Pols, H.; Reeve, J.; Silman, A.; Tenenhouse, A. Predictive value of BMD for hip and other fractures. J. Bone Miner. Res., 2005, 20(7), 1185-1194.
[http://dx.doi.org/10.1359/JBMR.050304] [PMID: 15940371]
[12]
Garnero, P. Biomarkers for osteoporosis management: utility in diagnosis, fracture risk prediction and therapy monitoring. Mol. Diagn. Ther., 2008, 12(3), 157-170.
[http://dx.doi.org/10.1007/BF03256280] [PMID: 18510379]
[13]
Scudeller, L A; Srinivasan, S; Rossi, A.M. Orientation and conformation of osteocalcin adsorbed onto calcium phosphate and silica surfaces., Biointerphases, 2017, 12(2), 02D411..
[http://dx.doi.org/10.1116/1.4983407] [PMID: 28521505]
[14]
Tanabe, R.; Kawamura, Y.; Tsugawa, N.; Haraikawa, M.; Sogabe, N.; Okano, T.; Hosoi, T.; Goseki-Sone, M. Effects of Fok-I polymorphism in vitamin D receptor gene on serum 25-hydroxyvitamin D, bone-specific alkaline phosphatase and calcaneal quantitative ultrasound parameters in young adults. Asia Pac. J. Clin. Nutr., 2015, 24(2), 329-335.
[http://dx.doi.org/10.6133/apjcn.2015.24.2.01] [PMID: 26078251]
[15]
Tripathi, T.; Gupta, P.; Sharma, J.; Rai, P.; Gupta, V.K.; Singh, N. Bone-specific alkaline phosphatase - a potential biomarker for skeletal growth assessment. J. Orthod., 2018, 45(1), 4-10.
[http://dx.doi.org/10.1080/14653125.2017.1416571] [PMID: 29281939]
[16]
Eastell, R.; Szulc, P. Use of bone turnover markers in postmenopausal osteoporosis. Lancet Diabetes Endocrinol., 2017, 5(11), 908-923.
[http://dx.doi.org/10.1016/S2213-8587(17)30184-5] [PMID: 28689768]
[17]
Liberati, A.; Altman, D.G.; Tetzlaff, J.; Mulrow, C.; Gøtzsche, P.C.; Ioannidis, J.P.; Clarke, M.; Devereaux, P.J.; Kleijnen, J.; Moher, D. The PRISMA statement for reporting systematic reviews and meta-analyses of studies that evaluate health care interventions: explanation and elaboration. PLoS Med., 2009, 6(7)e1000100
[http://dx.doi.org/10.1371/journal.pmed.1000100] [PMID: 19621070]
[18]
Hozo, S.P.; Djulbegovic, B.; Hozo, I. Estimating the mean and variance from the median, range, and the size of a sample. BMC Med. Res. Methodol., 2005, 5, 13.
[http://dx.doi.org/10.1186/1471-2288-5-13] [PMID: 15840177]
[19]
Cumpston, M.; Li, T.; Page, M.J.; Chandler, J.; Welch, V.A.; Higgins, J.P.; Thomas, J. Updated guidance for trusted systematic reviews: a new edition of the Cochrane handbook for systematic reviews of interventions. Cochrane Database Syst. Rev., 2019, 10ED000142
[http://dx.doi.org/10.1002/14651858.ED000142] [PMID: 31643080]
[20]
Kung, A.W.; Pasion, E.G.; Sofiyan, M.; Lau, E.M.; Tay, B.K.; Lam, K.S.; Wilawan, K.; Ongphiphadhanakul, B.; Thiebaud, D. A comparison of teriparatide and calcitonin therapy in postmenopausal Asian women with osteoporosis: a 6-month study. Curr. Med. Res. Opin., 2006, 22(5), 929-937.
[http://dx.doi.org/10.1185/030079906X104768] [PMID: 16709314]
[21]
Hwang, J.S.; Tu, S.T.; Yang, T.S.; Chen, J.F.; Wang, C.J.; Tsai, K.S. Teriparatide vs. calcitonin in the treatment of Asian postmenopausal women with established osteoporosis. Osteoporos. Int., 2006, 17(3), 373-378.
[http://dx.doi.org/10.1007/s00198-005-2002-5] [PMID: 16421647]
[22]
Lu, C.; Chen, Y.; Zhang, B.; Chen, Y.; Bai, F.; Chen, D. Response to teriparatide in Chinese patients with established osteoporosis: osteocalcin and lumbar spine bone-mineral density changes from teriparatide Phase III study. Clin. Interv. Aging, 2017, 12, 1717-1723.
[http://dx.doi.org/10.2147/CIA.S140900] [PMID: 29066877]
[23]
Kim, S.Y.; Zhang, M.; Bockman, R. Bone mineral density response from teriparatide in patients with osteoporosis. HSS J., 2017, 13(2), 171-177.
[http://dx.doi.org/10.1007/s11420-016-9537-1] [PMID: 28690468]
[24]
Fahrleitner-Pammer, A.; Langdahl, B.L.; Marin, F.; Jakob, F.; Karras, D.; Barrett, A.; Ljunggren, Ö.; Walsh, J.B.; Rajzbaum, G.; Barker, C.; Lems, W.F. Fracture rate and back pain during and after discontinuation of teriparatide: 36-month data from the European Forsteo Observational Study (EFOS). Osteoporos. Int., 2011, 22(10), 2709-2719.
[http://dx.doi.org/10.1007/s00198-010-1498-5] [PMID: 21113576]
[25]
Eastell, R.; Nickelsen, T.; Marin, F.; Barker, C.; Hadji, P.; Farrerons, J.; Audran, M.; Boonen, S.; Brixen, K.; Gomes, J.M.; Obermayer-Pietsch, B.; Avramidis, A.; Sigurdsson, G.; Glüer, C.C. Sequential treatment of severe postmenopausal osteoporosis after teriparatide: final results of the randomized, controlled European Study of Forsteo (EUROFORS). J. Bone Miner. Res., 2009, 24(4), 726-736.
[http://dx.doi.org/10.1359/jbmr.081215] [PMID: 19049337]
[26]
An, J.; Yang, H.; Zhang, Q.; Liu, C.; Zhao, J.; Zhang, L.; Chen, B. Natural products for treatment of osteoporosis: The effects and mechanisms on promoting osteoblast-mediated bone formation. Life Sci., 2016, 147, 46-58.
[http://dx.doi.org/10.1016/j.lfs.2016.01.024] [PMID: 26796578]
[27]
Karpf, D.B.; Pihl, S.; Mourya, S.; Mortensen, E.; Kovoor, E.; Markova, D.; Leff, J.A. A Randomized double-blind placebo-controlled first-in-human phase 1 trial of TransCon PTH in healthy adults. J. Bone Miner. Res., 2020, 35(8), 1430-1440.
[http://dx.doi.org/10.1002/jbmr.4016] [PMID: 32212275]
[28]
Raterman, H.G.; Bultink, I.E.M.; Lems, W.F. Current treatments and new developments in the management of glucocorticoid-induced osteoporosis. Drugs, 2019, 79(10), 1065-1087.
[http://dx.doi.org/10.1007/s40265-019-01145-6] [PMID: 31201710]
[29]
Galluccio, F.; Matucci-Cerinic, M. Efficacy of short-term teriparatide for hip osteonecrosis. J. Rheumatol., 2016, 43(11), 2084-2085.
[http://dx.doi.org/10.3899/jrheum.160190] [PMID: 27803352]
[30]
Obermayer-Pietsch, B.M.; Marin, F.; McCloskey, E.V.; Hadji, P.; Farrerons, J.; Boonen, S.; Audran, M.; Barker, C.; Anastasilakis, A.D.; Fraser, W.D.; Nickelsen, T. EUROFORS investigators. Effects of two years of daily teriparatide treatment on BMD in postmenopausal women with severe osteoporosis with and without prior antiresorptive treatment. J. Bone Miner. Res., 2008, 23(10), 1591-1600.
[http://dx.doi.org/10.1359/jbmr.080506] [PMID: 18505369]
[31]
Chesnut, C.H., III; Azria, M.; Silverman, S.; Engelhardt, M.; Olson, M.; Mindeholm, L. Salmon calcitonin: a review of current and future therapeutic indications. Osteoporos. Int., 2008, 19(4), 479-491.
[http://dx.doi.org/10.1007/s00198-007-0490-1] [PMID: 18071651]
[32]
Blick, S.K.; Dhillon, S.; Keam, S.J. Teriparatide: a review of its use in osteoporosis. Drugs, 2008, 68(18), 2709-2737.
[http://dx.doi.org/10.2165/0003495-200868180-00012] [PMID: 19093708]
[33]
Bandeira, L.; Lewiecki, E.M.; Bilezikian, J.P. Pharmacodynamics and pharmacokinetics of oral salmon calcitonin in the treatment of osteoporosis. Expert Opin. Drug Metab. Toxicol., 2016, 12(6), 681-689.
[http://dx.doi.org/10.1080/17425255.2016.1175436] [PMID: 27070719]
[34]
Tanaka, S.; Kuroda, T.; Sugimoto, T.; Nakamura, T.; Shiraki, M. Changes in bone mineral density, bone turnover markers, and vertebral fracture risk reduction with once weekly teriparatide. Curr. Med. Res. Opin., 2014, 30(5), 931-936.
[http://dx.doi.org/10.1185/03007995.2013.879440] [PMID: 24392946]
[35]
Lindsay, R.; Krege, J.H.; Marin, F.; Jin, L.; Stepan, J.J. Teriparatide for osteoporosis: importance of the full course. Osteoporos. Int., 2016, 27(8), 2395-2410.
[http://dx.doi.org/10.1007/s00198-016-3534-6] [PMID: 26902094]
[36]
Chesnut, C.H., III; Majumdar, S.; Newitt, D.C.; Shields, A.; Van Pelt, J.; Laschansky, E.; Azria, M.; Kriegman, A.; Olson, M.; Eriksen, E.F.; Mindeholm, L. Effects of salmon calcitonin on trabecular microarchitecture as determined by magnetic resonance imaging: results from the QUEST study. J. Bone Miner. Res., 2005, 20(9), 1548-1561.
[http://dx.doi.org/10.1359/JBMR.050411] [PMID: 16059627]
[37]
Kleerekoper, M.; Greenspan, S.L.; Lewiecki, E.M.; Miller, P.D.; Kendler, D.L.; Maricic, M.; Keaveny, T.M.; Kopperdahl, D.L.; Ruff, V.A.; Wan, X.; Janos, B.; Krohn, K. Assessing the effects of teriparatide treatment on bone mineral density, bone microarchitecture, and bone strength. J. Bone Joint Surg. Am., 2014, 96(11)e90
[http://dx.doi.org/10.2106/JBJS.L.01757] [PMID: 24897747]
[38]
Yamamoto, T.; Taketsuna, M.; Guo, X.; Sato, M.; Sowa, H. The safety and effectiveness profile of daily teriparatide in a prospective observational study in Japanese patients with osteoporosis at high risk for fracture: interim report. J. Bone Miner. Metab., 2014, 32(6), 699-708.
[http://dx.doi.org/10.1007/s00774-013-0546-6] [PMID: 24368586]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version333msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[21:10:31] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[21:10:31] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • warninglog[21:10:31] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[21:10:31] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (108ms)time
  • Application (224ms)time
  • 1 x Application (67.4%)
    224ms
    1 x Booting (32.6%)
    108ms
    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 duplicated152ms
    • 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 ('314340157','',1,1740345031,1740345031) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740345031
      970μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 11. middleware::check_user_access:24
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('314340157','/article/109152',1,1740345031,1740345031)
      140μ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 >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) 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 >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) 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 >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) 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 >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) 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 >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) 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 >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 314340157 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 314340157) limit 1
      10.53msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 314340157
      • 1: 314340157
      • 2: 314340157
      • 3: 314340157
      • 4: 314340157
      • 5: 314340157
      • 6: 314340157
      • 7: 314340157
      • 8: 314340157
      • 9: 314340157
      • 10: 314340157
      • 11: 314340157
      • 12: 314340157
      • 13: 314340157
      • 14: 314340157
      • 15: 314340157
      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=109152
      640μ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` = 59 limit 1
      740μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 59
      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=59) and sj.journal_id!=59 group by `j`.`nid`) as `aggregate_table`
      1.6msalphaeurekaselec_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=59) and sj.journal_id!=59 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.53msalphaeurekaselec_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=59) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      7.25msalphaeurekaselec_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=59) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      6.44msalphaeurekaselec_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` = '109152'
      1.33msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 109152
      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` = '109152'
      2.45msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 109152
      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` = '109152' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.16msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 109152
      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
      300μ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 = 59 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      38.68msalphaeurekaselec_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 = 59 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      15.8msalphaeurekaselec_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 = 59 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      10.15msalphaeurekaselec_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` = 109152 limit 1
      770μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 109152
      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 = 109152 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 * from `node_meta` where `nid` = 184896 limit 1
      170μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 184896
      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
      190μ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` = 'EMIDDT' 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: EMIDDT
      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 = '109152' 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) )
      280μ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 = '10584' 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 = '2931' 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740345031 and j.to_date >= 1740345031 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2931) 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740345031 and j.to_date >= 1740345031 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2931) 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740345031 and j.to_date >= 1740345031 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2931)
      40.45msalphaeurekaselec_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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740345031 and j.to_date >= 1740345031 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10584) 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740345031 and j.to_date >= 1740345031 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10584) 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740345031 and j.to_date >= 1740345031 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10584)
      630μ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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740345031 and j.to_date >= 1740345031 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 109152) 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740345031 and j.to_date >= 1740345031 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 109152) 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 <= 314340157 and j.to_ip >=314340157 )) and ((j.from_date <= 1740345031 and j.to_date >= 1740345031 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 109152)
      570μ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` < '932' and is_uploaded = 1 and issue_id = 10584 order by cast(first_page as SIGNED) desc limit 1
      570μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 932
      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` > '942' and is_uploaded = 1 and issue_id = 10584 order by cast(first_page as SIGNED) asc limit 1
      430μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 942
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      180μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      190μ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` = 109152 limit 1
      2.32msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 109152
      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` = 59 and `b`.`banner_from_date` <= 1740345031 and `b`.`banner_to_date` >= 1740345031 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.15msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 59
      • 3: 1740345031
      • 4: 1740345031
      • 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` = 59 and `b`.`banner_from_date` <= 1740345031 and `b`.`banner_to_date` >= 1740345031 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.12msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 59
      • 3: 1740345031
      • 4: 1740345031
      • 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='ee3bac78d57c895001750dfa88aa4c77'
      220μ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
        AS39pFk4aMhpamLjVzV8pafxI0HiMQXXobyZwCKr
        uc_cart_id
        ee3bac78d57c895001750dfa88aa4c77
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/109152" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/109152
        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=eyJpdiI6IlNPekhnS1FlYmx2UHZWMHFrdDlSSXc9PSIsInZhbHVlIjoicjYwNHR4U0wydGt4VTJtT0lqK2NGZ0dWOUtwVFpHUU56eTNvZGVmdFQ3Zz0iLCJtYWMiOiJmM2M5MjAwNmIwOWNjNWI3YTdlYjEzMzhkZTI3MTM5YmVmOWJjMGE4OTA4MjI0OTdhMmIyZWQxMWEwOGJmZWNlIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IlNPekhnS1FlYmx2UHZWMHFrdDlSSXc9PSIsInZhbHVlIjoicjYwNHR4U0wydGt4VTJtT0lqK2NGZ0dWOUtwVFpHUU56eTNvZGVmdFQ3Zz0iLCJtYWMiOiJmM2M5MjAwNmIwOWNj" ] "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 => "Sun, 23 Feb 2025 21:10:31 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImVDN1R2WWdWc2REMTE0N05qOG00dHc9PSIsInZhbHVlIjoiVGRzYkVvOE5kZ3o0MU12OWJJN0E1cUI5ZGwzTjlUNjFEOVh1VzBjUndtM0o0SFA1U1ZRRmFLQkZlQ1BxVEgrR3pQOUhDVzV5eWtTTEp4c2Z2RURYZ1diTjdKbzByZHNmREptKzl3S3JKWWFNODlqbEV1UHV4Y2E2UGJKRk9xY2MiLCJtYWMiOiIzN2RlMDlkMjJhMDUxMjJjZjA1ODQ2MWYyZjQ1MjYwMDc3OWY2YjY3MWNhYTYyY2U1NjQ2MjQ2N2Y2ZTZkNDVkIiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 09:10:31 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImVDN1R2WWdWc2REMTE0N05qOG00dHc9PSIsInZhbHVlIjoiVGRzYkVvOE5kZ3o0MU12OWJJN0E1cUI5ZGwzTjlUNjFEOVh1VzBjUndtM0o0SFA1U1ZRRmFLQkZlQ1BxVEgrR3pQOUhDV" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImR2WTE4UERHcTJxTTdRL090M0FUcHc9PSIsInZhbHVlIjoiQ3Q2Tks5S3ZHSEZCdmdFQzE0TXBZUDRaT0U5cmZLR2o1S1Q3eW45K094RGk0V1hMVjVuWmprMFV4RldOb3RRb1VSbExWUEFqQVQ0ZklsWGZCUVBtd3FBRUNkVEFzNnhEdFNQUThHcVZHNEdGWTR1MFpxWEt1bW1pa0NjQ0FzVjciLCJtYWMiOiI2OWQ3ZjU0OTM1MmFjNTZiMjRiNjhmNWQzYzJhMTAyODQwMjRmMGQ2YjNjMmYyZjMwZmYwMjBiMzg2MjFkMTFmIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6ImR2WTE4UERHcTJxTTdRL090M0FUcHc9PSIsInZhbHVlIjoiQ3Q2Tks5S3ZHSEZCdmdFQzE0TXBZUDRaT0U5cmZLR2o1S1Q3eW45K094RGk0V1hMVjVuWmprMFV" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImVDN1R2WWdWc2REMTE0N05qOG00dHc9PSIsInZhbHVlIjoiVGRzYkVvOE5kZ3o0MU12OWJJN0E1cUI5ZGwzTjlUNjFEOVh1VzBjUndtM0o0SFA1U1ZRRmFLQkZlQ1BxVEgrR3pQOUhDVzV5eWtTTEp4c2Z2RURYZ1diTjdKbzByZHNmREptKzl3S3JKWWFNODlqbEV1UHV4Y2E2UGJKRk9xY2MiLCJtYWMiOiIzN2RlMDlkMjJhMDUxMjJjZjA1ODQ2MWYyZjQ1MjYwMDc3OWY2YjY3MWNhYTYyY2U1NjQ2MjQ2N2Y2ZTZkNDVkIiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 09:10:31 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImVDN1R2WWdWc2REMTE0N05qOG00dHc9PSIsInZhbHVlIjoiVGRzYkVvOE5kZ3o0MU12OWJJN0E1cUI5ZGwzTjlUNjFEOVh1VzBjUndtM0o0SFA1U1ZRRmFLQkZlQ1BxVEgrR3pQOUhDV" 1 => "alphaeurekaselectnet_session=eyJpdiI6ImR2WTE4UERHcTJxTTdRL090M0FUcHc9PSIsInZhbHVlIjoiQ3Q2Tks5S3ZHSEZCdmdFQzE0TXBZUDRaT0U5cmZLR2o1S1Q3eW45K094RGk0V1hMVjVuWmprMFV4RldOb3RRb1VSbExWUEFqQVQ0ZklsWGZCUVBtd3FBRUNkVEFzNnhEdFNQUThHcVZHNEdGWTR1MFpxWEt1bW1pa0NjQ0FzVjciLCJtYWMiOiI2OWQ3ZjU0OTM1MmFjNTZiMjRiNjhmNWQzYzJhMTAyODQwMjRmMGQ2YjNjMmYyZjMwZmYwMjBiMzg2MjFkMTFmIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6ImR2WTE4UERHcTJxTTdRL090M0FUcHc9PSIsInZhbHVlIjoiQ3Q2Tks5S3ZHSEZCdmdFQzE0TXBZUDRaT0U5cmZLR2o1S1Q3eW45K094RGk0V1hMVjVuWmprMFV" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "AS39pFk4aMhpamLjVzV8pafxI0HiMQXXobyZwCKr" "uc_cart_id" => "ee3bac78d57c895001750dfa88aa4c77" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/109152" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-23 21:10:31GET/article/109152414361