Generic placeholder image

Current Psychopharmacology

Editor-in-Chief

ISSN (Print): 2211-5560
ISSN (Online): 2211-5579

Review Article

In Search of Reward Deficiency Syndrome (RDS)-Free Controls: The “Holy Grail” in Genetic Addiction Risk Testing

Author(s): Kenneth Blum*, David Baron, Lisa Lott, Jessica V. Ponce, David Siwicki, Brent Boyett, Bruce Steinberg, Edward J. Modestino, Lyle Fried, Mary Hauser, Thomas Simpatico, Bill W. Downs, Thomas McLaughlin, Raju Hajela and Rajendra D. Badgaiyan

Volume 9, Issue 1, 2020

Page: [7 - 21] Pages: 15

DOI: 10.2174/2211556008666191111103152

Abstract

Background: The search for an accurate, gene-based test to identify heritable risk factors for Reward Deficiency Syndrome (RDS) was conducted based on hundreds of published studies about the role of dopamine in addictive behaviors, including risk for drug dependence and compulsive/impulsive behavior disorders. The term RDS was first coined by Blum’s group in 1995 to identify a group of behaviors with a common neurobiological mechanism associated with a polymorphic allelic propensity for hypodopaminergia.

Objectives: To outline the process used to select risk alleles of reward genes for the Genetic Addiction Risk Score (GARS) test. Consequently, to address the limitations caused by inconsistent results that occur in many case-control behavioral association studies. These limitations are perhaps due to the failure of investigators to adequately screen controls for drug and alcohol use disorder, and any of the many RDS behaviors, including nicotine dependence, obesity, pathological gambling, and internet gaming addiction.

Methods: Review of the literature related to the function of risk alleles of reward genes associated with hypodopaminergia relevant case-control association studies for the selection of alleles to be measured by the Genetic Addiction Risk Score (GARS) test.

Results: The prevalence of the DRD2 A1 allele in unscreened controls (33.3%), compared to “Super-Controls” [highly screened RDS controls (3.3%) in proband and family] is used to exemplify a possible solution.

Conclusion: Unlike One Gene-One Disease (OGOD), RDS is polygenetic, and very complex. In addition, any RDS-related behaviors must be eliminated from the control group in order to obtain the best possible statistical analysis instead of comparing the phenotype with diseaseridden controls.

Keywords: Behavioral genetic research, case controlled studies, genetic addiction association studies, genetic prevalence, hypodopaminergia, Reward Deficiency Syndrome (RDS), Single Nucleotide Polymorphisms (SNPs), study controls, super controls.

Graphical Abstract

[1]
Blum K, Chen ALC, Thanos PK, et al. Genetic addiction risk score (GARS) ™, a predictor of vulnerability to opioid dependence. Front Biosci (Elite Ed) 2018; 10: 175-96.
[http://dx.doi.org/10.2741/e816] [PMID: 28930612]
[2]
Blum K, Sheridan PJ, Wood RC, et al. The D2 dopamine receptor gene as a determinant of reward deficiency syndrome. J R Soc Med 1996; 89(7): 396-400.
[http://dx.doi.org/10.1177/014107689608900711] [PMID: 8774539]
[3]
Blum K, Kozlowski G. Ethanol and neuromodulator interactions: a cascade model of reward. Alcohol Behav 1990; pp. 131-50.
[4]
Erickson C. The Science of Addiction. New York: W.W. Norton 2007.
[5]
Blum K, Thanos PK, Badgaiyan RD, et al. Neurogenetics and gene therapy for reward deficiency syndrome: are we going to the Promised Land? Expert Opin Biol Ther 2015; 15(7): 973-85.
[http://dx.doi.org/10.1517/14712598.2015.1045871] [PMID: 25974314]
[6]
Li CY, Zhou WZ, Zhang PW, Johnson C, Wei L, Uhl GR. Meta-analysis and genome-wide interpretation of genetic susceptibility to drug addiction. BMC Genomics 2011; 12: 508.
[http://dx.doi.org/10.1186/1471-2164-12-508] [PMID: 21999673]
[7]
Koob GF, Volkow ND. Neurobiology of addiction: a neurocircuitry analysis. Lancet Psychiatry 2016; 3(8): 760-73.
[http://dx.doi.org/10.1016/S2215-0366(16)00104-8] [PMID: 27475769]
[8]
Noble EP, Blum K, Ritchie T, Montgomery A, Sheridan PJ. Allelic association of the D2 dopamine receptor gene with receptor-binding characteristics in alcoholism. Arch Gen Psychiatry 1991; 48(7): 648-54.
[http://dx.doi.org/10.1001/archpsyc.1991.01810310066012] [PMID: 2069496]
[9]
Kranzler HR, Smith RV, Schnoll R, Moustafa A, Greenstreet-Akman E. Precision medicine and pharmacogenetics: what does oncology have that addiction medicine does not? Addiction 2017; 112(12): 2086-94.
[http://dx.doi.org/10.1111/add.13818] [PMID: 28431457]
[10]
Gerra G, Somaini L, Leonardi C, et al. Association between gene variants and response to buprenorphine maintenance treatment. Psychiatry Res 2014; 215(1): 202-7.
[http://dx.doi.org/10.1016/j.psychres.2013.11.001] [PMID: 24274990]
[11]
Madrid GA, MacMurray J, Lee JW, Anderson BA, Comings DE. Stress as a mediating factor in the association between the DRD2 TaqI polymorphism and alcoholism. Alcohol 2001; 23(2): 117-22.
[http://dx.doi.org/10.1016/S0741-8329(00)00138-5] [PMID: 11331109]
[12]
Thompson MD, Kenna GA. Variation in the serotonin transporter gene and alcoholism: risk and response to pharmacotherapy. Alcohol Alcohol 2016; 51(2): 164-71.
[http://dx.doi.org/10.1093/alcalc/agv090] [PMID: 26311211]
[13]
Gold MS, Badgaiyan RD, Blum K. A Shared molecular and genetic basis for food and drug addiction: overcoming hypodopaminergic trait/state by incorporating dopamine agonistic therapy in psychiatry. Psychiatr Clin North Am 2015; 38(3): 419-62.
[http://dx.doi.org/10.1016/j.psc.2015.05.011] [PMID: 26300032]
[14]
Gold MS, Blum K, Oscar-Berman M, Braverman ER. Low dopamine function in attention deficit/hyperactivity disorder: should genotyping signify early diagnosis in children? Postgrad Med 2014; 126(1): 153-77.
[http://dx.doi.org/10.3810/pgm.2014.01.2735] [PMID: 24393762]
[15]
Batel P, Houchi H, Daoust M, Ramoz N, Naassila M, Gorwood P. A haplotype of the DRD1 gene is associated with alcohol dependence. Alcohol Clin Exp Res 2008; 32(4): 567-72.
[http://dx.doi.org/10.1111/j.1530-0277.2008.00618.x] [PMID: 18341651]
[16]
Kuo SC, Yeh YW, Chen CY, et al. DRD3 variation associates with early-onset heroin dependence, but not specific personality traits. Prog Neuropsychopharmacol Biol Psychiatry 2014; 51: 1-8.
[http://dx.doi.org/10.1016/j.pnpbp.2013.12.018] [PMID: 24398431]
[17]
Van Tol HH. Structural and functional characteristics of the dopamine D4 receptor. Adv Pharmacol 1998; 42: 486-90.
[http://dx.doi.org/10.1016/S1054-3589(08)60794-2] [PMID: 9327945]
[18]
Baransel Isir AB, Oguzkan S, Nacak M, Gorucu S, Dulger HE, Arslan A. The catechol-O-methyl transferase Val158Met polymorphism and susceptibility to cannabis dependence. Am J Forensic Med Pathol 2008; 29(4): 320-2.
[http://dx.doi.org/10.1097/PAF.0b013e3181847e56] [PMID: 19259017]
[19]
Wichers M, Aguilera M, Kenis G, et al. The catechol-O-methyl transferase Val158Met polymorphism and experience of reward in the flow of daily life. Neuropsychopharmacology 2008; 33(13): 3030-6.
[http://dx.doi.org/10.1038/sj.npp.1301520]
[20]
Ray R, Ruparel K, Newberg A, et al. Human Mu Opioid Receptor (OPRM1 A118G) polymorphism is associated with brain mu-opioid receptor binding potential in smokers. Proc Natl Acad Sci USA 2011; 108(22): 9268-73.
[http://dx.doi.org/10.1073/pnas.1018699108] [PMID: 21576462]
[21]
Byerley W, Hoff M, Holik J, Caron MG, Giros B. VNTR polymorphism for the human dopamine transporter gene (DAT1). Hum Mol Genet 1993; 2(3): 335.
[http://dx.doi.org/10.1093/hmg/2.3.335] [PMID: 8098980]
[22]
Contini V, Marques FZ, Garcia CE, Hutz MH, Bau CH. MAOA-uVNTR polymorphism in a Brazilian sample: further support for the association with impulsive behaviors and alcohol dependence. Am J Med Genet B Neuropsychiatr Genet 2006; 141B(3): 305-8.
[23]
Merenäkk L, Mäestu J, Nordquist N, et al. Effects of the serotonin transporter (5-HTTLPR) and α2A-adrenoceptor (C-1291G) genotypes on substance use in children and adolescents: a longitudinal study. Psychopharmacology (Berl) 2011; 215(1): 13-22.
[http://dx.doi.org/10.1007/s00213-010-2109-z] [PMID: 21140256]
[24]
van der Zwaluw CS, Engels RC, Vermulst AA, et al. A serotonin transporter polymorphism (5-HTTLPR) predicts the development of adolescent alcohol use. Drug Alcohol Depend 2010; 112(1-2): 134-9.
[http://dx.doi.org/10.1016/j.drugalcdep.2010.06.001] [PMID: 20598814]
[25]
Namkoong K, Cheon KA, Kim JW, Jun JY, Lee JY. Association study of dopamine D2, D4 receptor gene, GABAA receptor beta subunit gene, serotonin transporter gene polymorphism with children of alcoholics in Korea: a preliminary study. Alcohol 2008; 42(2): 77-81.
[http://dx.doi.org/10.1016/j.alcohol.2008.01.004] [PMID: 18358985]
[26]
Pearson-Fuhrhop KM, Dunn EC, Mortero S, et al. Dopamine genetic risk score predicts depressive symptoms in healthy adults and adults with depression. PLoS One 2014; 9(5)e93772
[http://dx.doi.org/10.1371/journal.pone.0093772] [PMID: 24834916]
[27]
Kawada Y, Hattori M, Fukuda R, Arai H, Inoue R, Nanko S. No evidence of linkage or association between tyrosine hydroxylase gene and affective disorder. J Affect Disord 1995; 34(2): 89-94.
[http://dx.doi.org/10.1016/0165-0327(95)00004-7] [PMID: 7665810]
[28]
Gold MS, Blum K, Febo M, et al. Molecular role of dopamine in anhedonia linked to reward deficiency syndrome (RDS) and anti- reward systems. Front Biosci (Schol Ed) 2018; 10: 309-25.
[http://dx.doi.org/10.2741/s518] [PMID: 29293435]
[29]
Chen TJ, Blum K, Mathews D, et al. Are dopaminergic genes involved in a predisposition to pathological aggression? Hypothesizing the importance of “super normal controls” in psychiatricgenetic research of complex behavioral disorders. Med Hypotheses 2005; 65(4): 703-7.
[http://dx.doi.org/10.1016/j.mehy.2005.04.037] [PMID: 15964153]
[30]
Chen AL, Blum K, Chen TJ, et al. Correlation of the Taq1 dopamine D2 receptor gene and percent body fat in obese and screened control subjects: a preliminary report. Food Funct 2012; 3(1): 40-8.
[http://dx.doi.org/10.1039/C1FO10089K] [PMID: 22051885]
[31]
Blum K. Reward Deficiency Syndrome. In: Wenzel A, Ed. The Sage Encyclopedia of Abnormal Clinical Psychology. Thousand Oaks, California: SAGE publishers 2017; pp. 4200.
[32]
Bolos AM, Dean M, Lucas-Derse S, Ramsburg M, Brown GL, Goldman D. Population and pedigree studies reveal a lack of association between the dopamine D2 receptor gene and alcoholism. JAMA 1990; 264(24): 3156-60.
[http://dx.doi.org/10.1001/jama.1990.03450240058040] [PMID: 1979357]
[33]
Kranzler HR, Zhou H, Kember RL, et al. Genome-wide association study of alcohol consumption and use disorder in 274,424 individuals from multiple populations. Nat Commun 2019; 10(1): 1499.
[http://dx.doi.org/10.1038/s41467-019-09480-8] [PMID: 30940813]
[34]
Blum K, Noble EP, Sheridan PJ, et al. Allelic association of human dopamine D2 receptor gene in alcoholism. JAMA 1990; 263(15): 2055-60.
[http://dx.doi.org/10.1001/jama.1990.03440150063027] [PMID: 1969501]
[35]
Prasad P, Ambekar A, Vaswani M. Case-control association analysis of dopamine receptor polymorphisms in alcohol dependence: a pilot study in Indian males. BMC Res Notes 2013; 6: 418.
[http://dx.doi.org/10.1186/1756-0500-6-418] [PMID: 24135011]
[36]
Verde Z, Santiago C, Rodríguez González-Moro JM, et al. ‘Smoking genes’: a genetic association study. PLoS One 2011; 6(10)e26668
[37]
Pinto JAF, Freitas PHB, Nunes FDD, Granjeiro PA, Santos LLD, Machado RM. Prevalence of polymorphisms in the ANKK1, DRD2, DRD3 genes and metabolic syndrome in refractory schizophrenia. Rev Lat Am Enfermagem 2018; 26e2983
[38]
Ding YC, Chi HC, Grady DL, et al. Evidence of positive selection acting at the human dopamine receptor D4 gene locus. Proc Natl Acad Sci USA 2002; 99(1): 309-14.
[http://dx.doi.org/10.1073/pnas.012464099] [PMID: 11756666]
[39]
van Dyck CH, Malison RT, Jacobsen LK, et al. Increased dopamine transporter availability associated with the 9-repeat allele of the SLC6A3 gene. J Nucl Med 2005; 46(5): 745-51.
[http://dx.doi.org/10.1073/pnas.012464099] [PMID: 15872345]
[40]
Saravani R, Galavi HR, Lotfian Sargazi M. Catechol-O-Methyltransferase (COMT) Gene (Val158Met) and Brain-Derived Neurotropic Factor (BDNF) (Val66Met) Genes Polymorphism in Schizophrenia: A Case-Control Study. Iran J Psychiatry 2017; 12(4): 265-70.
[41]
Hwang IW, Lim MH, Kwon HJ, Jin HJ. Association of Monoamine Oxidase A (MAOA) gene uVNTR and rs6323 polymorphisms with attention deficit and hyperactivity disorder in Korean children. Medicina (Kaunas) 2018; 54(3)E32
[http://dx.doi.org/10.3390/medicina54030032] [PMID: 30344263]
[42]
Haberstick BC, Smolen A, Williams RB, et al. Population frequencies of the triallelic 5HTTLPR in six ethnicially diverse samples from North America, Southeast Asia, and Africa. Behav Genet 2015; 45(2): 255-61.
[43]
Malhotra S, Basu D, Khullar M, Ghosh A, Chugh N. Candidate genes for alcohol dependence: A genetic association study from India. Indian J Med Res 2016; 144(5): 689-96.
[http://dx.doi.org/10.4103/ijmr.IJMR_1018_14] [PMID: 28361821]
[44]
Nobile B, Ramoz N, Jaussent I, et al. Polymorphism A118G of opioid receptor mu 1 (OPRM1) is associated with emergence of suicidal ideation at antidepressant onset in a large naturalistic cohort of depressed outpatients. Sci Rep 2019; 9(1): 2569.
[http://dx.doi.org/10.1038/s41598-019-39622-3] [PMID: 30796320]
[45]
Gade R, Blake H, MacMurray J, et al. Relationship of the GABRB3 gene to adult ADHD and personality traits in Caucasian and African-American samples. Psychiatr Genet 1996; 6: 164-5.
[46]
Gerra MC, Manfredini M, Cortese E, et al. Genetic and environmental risk factors for Cannabis use: preliminary results for the role of parental care perception. Subst Use Misuse 2019; 54(4): 670-80.
[http://dx.doi.org/10.1097/00041444-199623000-00081]
[47]
Shields PG, Lerman C, Audrain J, et al. Dopamine D4 receptors and the risk of cigarette smoking in African-Americans and Caucasians. Cancer Epidemiol Biomarkers Prev 1998; 7(6): 453-8.
[PMID: 9641486]
[48]
Li CY, Mao X, Wei L. Genes and (common) pathways underlying drug addiction. PLOS Comput Biol 2008; 4(1)e2
[http://dx.doi.org/10.1371/journal.pcbi.0040002] [PMID: 18179280]

© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version405msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[04:25:46] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[04:25:46] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[04:25:46] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (113ms)time
  • Application (292ms)time
  • 1 x Application (72.15%)
    292ms
    1 x Booting (27.84%)
    113ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    32 statements were executed, 4 of which were duplicates, 28 unique. Show only duplicated215ms
    • 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 ('309725698','',1,1740457546,1740457546) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740457546
      950μ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 ('309725698','/article/102202',1,1740457546,1740457546)
      220μ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 >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) 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 >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) 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 >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) 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 >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) 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 >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) 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 >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 309725698 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 309725698) limit 1
      20.03msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 309725698
      • 1: 309725698
      • 2: 309725698
      • 3: 309725698
      • 4: 309725698
      • 5: 309725698
      • 6: 309725698
      • 7: 309725698
      • 8: 309725698
      • 9: 309725698
      • 10: 309725698
      • 11: 309725698
      • 12: 309725698
      • 13: 309725698
      • 14: 309725698
      • 15: 309725698
      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=102202
      930μ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` = 121 limit 1
      1.03msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 121
      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=121) and sj.journal_id!=121 group by `j`.`nid`) as `aggregate_table`
      1.61msalphaeurekaselec_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=121) and sj.journal_id!=121 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      1.31msalphaeurekaselec_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=121) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      7.28msalphaeurekaselec_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=121) 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.41msalphaeurekaselec_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` = '102202'
      910μsalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 102202
      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` = '102202'
      2.25msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 102202
      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` = '102202' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.95msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 102202
      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
      250μ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
      500μ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 = 121 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      24.75msalphaeurekaselec_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 = 121 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      1.96msalphaeurekaselec_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 = 121 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      1.74msalphaeurekaselec_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` = 102202 limit 1
      230μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 102202
      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 = 102202 and content_type = 'article' order by status desc limit 1
      290μ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 = 281 and cd.sub_disease_id = 297 and content_id!=102202 and cd.content_type = 'article' order by rand() limit 20
      133msalphaeurekaselec_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` = 176526 limit 1
      250μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 176526
      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
      220μ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` = 'CPSP' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      290μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CPSP
      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 = '102202' 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) )
      390μ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 * from `article` where `first_page` < '7' and is_uploaded = 1 and issue_id = 9730 order by cast(first_page as SIGNED) desc limit 1
      420μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 7
      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` > '21' and is_uploaded = 1 and issue_id = 9730 order by cast(first_page as SIGNED) asc limit 1
      360μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 21
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      190μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      170μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 102202 limit 1
      2.33msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 102202
      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` = 121 and `b`.`banner_from_date` <= 1740457546 and `b`.`banner_to_date` >= 1740457546 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.31msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 121
      • 3: 1740457546
      • 4: 1740457546
      • 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` = 121 and `b`.`banner_from_date` <= 1740457546 and `b`.`banner_to_date` >= 1740457546 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.14msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 121
      • 3: 1740457546
      • 4: 1740457546
      • 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='f478c889e2eacaf2ba42ea65ab186ac9'
      230μ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
        5PhNXwLjvFZKKHiv3snJkCIpM9j6fTeet4PzHkIb
        uc_cart_id
        f478c889e2eacaf2ba42ea65ab186ac9
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/102202" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/102202
        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=eyJpdiI6InEyRWFXUy9lWUtpalBMazZEZkx0WlE9PSIsInZhbHVlIjoiWUIzS3NQTWxIbmQ0NkdqZlVLZU8xeHE0a1dpV3V0ZlBPWnJsWVlCS013cz0iLCJtYWMiOiI3ZTEwNWYxMGE5YTI2YzgyOTYzMWE5MjRjZmY1MDQxZGY2NzUyMTZmMTg2NjliNTNhNGRmMDlhODM3ODk0NjQ3IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6InEyRWFXUy9lWUtpalBMazZEZkx0WlE9PSIsInZhbHVlIjoiWUIzS3NQTWxIbmQ0NkdqZlVLZU8xeHE0a1dpV3V0ZlBPWnJsWVlCS013cz0iLCJtYWMiOiI3ZTEwNWYxMGE5YTI2" ] "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:25:46 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjYxV1kzQ2w5VkpQL2F0bkFRQXhCSnc9PSIsInZhbHVlIjoicHp6dWp0cmgyUjZCT1RBRUpZSjZ5OXVLaHZBWisvWUM0bzg4dkE3WXQ2a0xuSTRpNUt3MmI2SnlyMXo1cGNzMGQzM2llTTYxTmUyUFZBU0hiQ3V0blhpcUkyZmRqelBWNnVWQ0xtdDR6SlU4NTROL3NBazZqZTBRMkxFYW9aVU0iLCJtYWMiOiI0NDUxZDBiZDJlZjY0NGJiNjgzNjc4Zjg2YWQ5NWZhMGM5ZDkxYjMzYmE3MTIyMzlmYjk0MDUxNWQ0Nzg3ODI1IiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 16:25:46 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjYxV1kzQ2w5VkpQL2F0bkFRQXhCSnc9PSIsInZhbHVlIjoicHp6dWp0cmgyUjZCT1RBRUpZSjZ5OXVLaHZBWisvWUM0bzg4dkE3WXQ2a0xuSTRpNUt3MmI2SnlyMXo1cGNzMGQzM2llT" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkYvRkwxM1JWc294UDVaamQ0VlJTanc9PSIsInZhbHVlIjoiTnhHK0d1VEhvR1ZHWW1kYkIySytSQm1vTGh0VDZIN2FaUVlwM21GaDNzZEszL1hYVFdSdWErQ05FellvR1g5YTB6QlVVdHZWWG1pVk5hMCtxVkgzMTd0N25ER29FeVlBdC9SU3h6WWE5d2Y0cmN6KzNqSnJUTkVITEpsUDczOWciLCJtYWMiOiIzMDkyYmY2NWVkNGNjYTM4NTkzMTU0ODc5OWM5MzAwODY4ZjQ2MmE1ZjliNTY1YmI5N2RiYzkyYjcwOTYxNzAyIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkYvRkwxM1JWc294UDVaamQ0VlJTanc9PSIsInZhbHVlIjoiTnhHK0d1VEhvR1ZHWW1kYkIySytSQm1vTGh0VDZIN2FaUVlwM21GaDNzZEszL1hYVFdSdWErQ05" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjYxV1kzQ2w5VkpQL2F0bkFRQXhCSnc9PSIsInZhbHVlIjoicHp6dWp0cmgyUjZCT1RBRUpZSjZ5OXVLaHZBWisvWUM0bzg4dkE3WXQ2a0xuSTRpNUt3MmI2SnlyMXo1cGNzMGQzM2llTTYxTmUyUFZBU0hiQ3V0blhpcUkyZmRqelBWNnVWQ0xtdDR6SlU4NTROL3NBazZqZTBRMkxFYW9aVU0iLCJtYWMiOiI0NDUxZDBiZDJlZjY0NGJiNjgzNjc4Zjg2YWQ5NWZhMGM5ZDkxYjMzYmE3MTIyMzlmYjk0MDUxNWQ0Nzg3ODI1IiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 16:25:46 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjYxV1kzQ2w5VkpQL2F0bkFRQXhCSnc9PSIsInZhbHVlIjoicHp6dWp0cmgyUjZCT1RBRUpZSjZ5OXVLaHZBWisvWUM0bzg4dkE3WXQ2a0xuSTRpNUt3MmI2SnlyMXo1cGNzMGQzM2llT" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkYvRkwxM1JWc294UDVaamQ0VlJTanc9PSIsInZhbHVlIjoiTnhHK0d1VEhvR1ZHWW1kYkIySytSQm1vTGh0VDZIN2FaUVlwM21GaDNzZEszL1hYVFdSdWErQ05FellvR1g5YTB6QlVVdHZWWG1pVk5hMCtxVkgzMTd0N25ER29FeVlBdC9SU3h6WWE5d2Y0cmN6KzNqSnJUTkVITEpsUDczOWciLCJtYWMiOiIzMDkyYmY2NWVkNGNjYTM4NTkzMTU0ODc5OWM5MzAwODY4ZjQ2MmE1ZjliNTY1YmI5N2RiYzkyYjcwOTYxNzAyIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkYvRkwxM1JWc294UDVaamQ0VlJTanc9PSIsInZhbHVlIjoiTnhHK0d1VEhvR1ZHWW1kYkIySytSQm1vTGh0VDZIN2FaUVlwM21GaDNzZEszL1hYVFdSdWErQ05" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "5PhNXwLjvFZKKHiv3snJkCIpM9j6fTeet4PzHkIb" "uc_cart_id" => "f478c889e2eacaf2ba42ea65ab186ac9" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/102202" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 04:25:46GET/article/102202314321