Generic placeholder image

Current Medical Imaging

Editor-in-Chief

ISSN (Print): 1573-4056
ISSN (Online): 1875-6603

Research Article

Breast Cancer Diagnosis in Digital Mammography Images Using Automatic Detection for the Region of Interest

Author(s): Saleem Z. Ramadan* and Mahmoud El-Banna

Volume 16, Issue 7, 2020

Page: [902 - 912] Pages: 11

DOI: 10.2174/1573405615666190717112820

Price: $65

Abstract

Background: One of the early screening methods of breast cancer that is still used today is mammogram due to its low cost. Unfortunately, this low cost accompanied with low performance rate also.

Methods: The low performance rate in mammograms is associated with low capability in determining the best region from which the features are extracted. Therefore, we offer an automatic method to detect the Region of Interest in the mammograms based on maximizing the area under receiver operating characteristic curve utilizing Genetic Algorithms.

The proposed method had been applied to the MIAS mammographic database, which is widely used in literature. Its performance had been evaluated using four different classifiers; Support Vector Machine, Naïve Bayes, K-Nearest Neighbor and Logistic Regression classifiers.

Results & Conclusion: The results showed good classification performances for all the classifiers used due to the rich information contained in the features extracted from the automatically selected Region of Interest.

Keywords: Breast cancer, mammography, genetic algorithms, automatic region of interest, classification, tumor.

Graphical Abstract

[1]
Bray F, Siegel RL, Ferlay J, Lortet-Tieulent J, Jemal A. Global cancer statistics. CA Cancer J Clin 2015; 65(2): 87-108.
[PMID: 25651787]
[3]
Wittenberg Th, Wagner F, Gryanik A. Towards a computer assisted diagnosis system for digital breast tomosynthesis. Biomedizinische Technik 2012; 57(Suppl. 1): 223-6.
[http://dx.doi.org/10.1515/bmt-2012-4455]
[4]
American Cancer Society Breast Cancer Facts & Figures 2017-2018, Atlanta 2017. Available from: https://www.cancer.org/research/cancer-facts-statistics/breast-cancer-facts-figures.html
[5]
Wishart GC, Campisi M, Boswell M, et al. The accuracy of digital infrared imaging for breast cancer detection in women undergoing breast biopsy. Eur J Surg Oncol 2010; 36(6): 535-40.
[http://dx.doi.org/10.1016/j.ejso.2010.04.003] [PMID: 20452740]
[6]
Milosevic M, Jankovic D, Peulic A. Comparative analysis of breast cancer detection in mammograms and thermograms. Biomed Tech (Berl) 2015; 60(1): 49-56.
[http://dx.doi.org/10.1515/bmt-2014-0047] [PMID: 25720034]
[7]
Giri P, Saravanakumar K. Breast cancer detection using image processing Techniques. Orient J Comp Sci 2017; 10(2): 391-9.
[8]
Antonie M, Zaiane O, Coman A. Application of data mining techniques for medical image classification. Proceedings of the Second International Conference on Multimedia Data Mining. San Francisco, USA. New Jersey: IEEE 2001; pp. 94-101.
[9]
Varsha J. Detection of breast cancer in mammogram using support vector machine. Int J Sci Engineer Res 2015; 3(2): 26-30.
[10]
Khuzi A. Mohd, Besar R, Wan Zaki WMD, Ahmad NN. Identification of masses in digital mammogram using gray level cooccurrence matrices Biomed Imaging Interv J 2009; 5(3): 1-13.
[11]
Kinoshita SK, Marques PMA, Slaets AFF, Marana HRC, Ferrari RJ, Villela RL. Detection and characterization of mammographic masses by artificial neural network. In:Karssemeijer N, Thijssen M, Hendriks J, van Erning L. Eds. Digital mammography computational imaging and vision. Berlin: Springer 1998.
[http://dx.doi.org/10.1007/978-94-011-5318-8_85]
[12]
Mudigonda NR, Rangayyan RM, Desautels JEL. Gradient and texture analysis for the classification of mammographic masses. IEEE Trans Med Imaging 2000; 19(10): 1032-43.
[http://dx.doi.org/10.1109/42.887618] [PMID: 11131493]
[13]
Sheshadri HS, Kandaswamy A. Detection of breast cancer by mammogram image segmentation. J Cancer Res Ther 2005; 1(4): 232-4.
[http://dx.doi.org/10.4103/0973-1482.19599]]
[14]
Petrosian A, Chan HP, Helvie MA, Goodsitt MM, Adler DD. Computer-aided diagnosis in mammography: classification of mass and normal tissue by texture analysis. Phys Med Biol 1994; 39(12): 2273-88.
[http://dx.doi.org/10.1088/0031-9155/39/12/010] [PMID: 15551553]
[15]
Hadjiiski L, Sahiner B, Chan HP, Petrick N, Helvie M. Classification of malignant and benign masses based on hybrid ART2LDA approach. IEEE Trans Med Imaging 1999; 18(12): 1178-87.
[http://dx.doi.org/10.1109/42.819327] [PMID: 10695530]
[16]
Kim JK, Park HW. Statistical textural features for detection of microcalcifications in digitized mammograms. IEEE Trans Med Imaging 1999; 18(3): 231-8.
[http://dx.doi.org/10.1109/42.764896] [PMID: 10363701]
[17]
Suckling J, Parker J, Dance D, et al. Mammographic Image Analysis Society (MIAS) database v121, 2015. Available from: https://www.repository.cam.ac.uk/handle/1810/250394
[18]
Cahoon TC, Sutton MA, Bezdek JC. Breast cancer detection using image processing techniques. IEEE Trans Instrum Meas 2017.
[19]
Mencattini A, Salmeri M, Lojacono R. Mammographic images enhancement and denoising for breast cancer detection using dyadic wavelet processing. IEEE Trans Instrum Meas 2008; 57(7): 1422-30.
[20]
Ramadan S. Reducing premature convergence problem in genetic algorithm: application on travel salesman problem. Comput Inform Sci 2013; 6(1): 47-57.
[21]
Rangayyan M. Analysis of bilateral asymmetry in mammograms using directional, morphological, and density features. J Electron Imaging 2007; 16(1): 013003.
[22]
Chaudhuri D, Samal A. A simple method for fitting of bounding rectangle to closed regions. Pattern Recognit 2007; 40(7): 1981-9.
[http://dx.doi.org/10.1016/j.patcog.2006.08.003]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version648msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[08:41:20] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[08:41:20] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[08:41:20] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (288ms)time
  • Application (360ms)time
  • 1 x Application (55.54%)
    360ms
    1 x Booting (44.46%)
    288ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    37 statements were executed, 4 of which were duplicates, 33 unique. Show only duplicated253ms
    • 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 ('316548017','',1,1740472880,1740472880) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740472880
      2.24msalphaeurekaselec_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 ('316548017','/article/99719',1,1740472880,1740472880)
      230μ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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) 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 >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316548017 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316548017) limit 1
      19.26msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316548017
      • 1: 316548017
      • 2: 316548017
      • 3: 316548017
      • 4: 316548017
      • 5: 316548017
      • 6: 316548017
      • 7: 316548017
      • 8: 316548017
      • 9: 316548017
      • 10: 316548017
      • 11: 316548017
      • 12: 316548017
      • 13: 316548017
      • 14: 316548017
      • 15: 316548017
      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=99719
      1.29msalphaeurekaselec_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` = 33 limit 1
      1.24msalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 33
      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=33) and sj.journal_id!=33 group by `j`.`nid`) as `aggregate_table`
      740μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 16. app/Models/Subject.php:200
      • 17. app/Http/Controllers/ArticleController.php:2517
      • 18. app/Http/Controllers/ArticleController.php:2035
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select j.nid as journal_nid,j.flyer_link,j.title ,j.issn,j.eissn,j.keyword, j.journal_id as journal_id, j.subtitle, j.image_file_name,j.description,j.journal_insight_url,j.doi from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where j.journal_status=1 and subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=33) and sj.journal_id!=33 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      630μsalphaeurekaselec_live_10_06_2022Subject.php#200
      Backtrace
      • 14. app/Models/Subject.php:200
      • 15. app/Http/Controllers/ArticleController.php:2517
      • 16. app/Http/Controllers/ArticleController.php:2035
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select v.nid as volume_id,e.nid,e.title,v.issn,v.eissn,v.isbn,v.eisbn,e.ebook_id, v.image_file_name,v.file_path,v.flyer_link,v.ebook_volume_id, v.volume_name,v.doi,v.year_id,v.introduction from `subject_ebook` as `se` inner join `ebook` as `e` on `e`.`ebook_id` = `se`.`ebook_id` inner join `ebook_volume` as `v` on `v`.`ebook_id` = `se`.`ebook_id` inner join `year` as `y` on `y`.`id` = `v`.`year_id` where subject_id IN (SELECT subject_id FROM subject_journal WHERE journal_id=33) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      900μsalphaeurekaselec_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=33) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      820μsalphaeurekaselec_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` = '99719'
      1.33msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 99719
      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` = '99719'
      2.92msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 99719
      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` = '99719' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.87msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 99719
      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
      380μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      730μsalphaeurekaselec_live_10_06_2022Article.php#1960
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/Article.php:1960
      • 14. app/Http/Controllers/ArticleController.php:2062
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • Select j.subtitle, v.volume_id as volume_id,v.year_id,y.year as year,v.volume_name, v.total_no_of_issues, i.issue_id as issue_id,i.title as issue, i.publication_date as issue_pub_date from journal j join volume v on j.journal_id = v.journal_id join issue i on v.volume_id = i.volume_id join article a on a.issue_id = i.issue_id join year y on v.year_id = y.id where j.journal_id = 33 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      44.43msalphaeurekaselec_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 = 33 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      16.86msalphaeurekaselec_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 = 33 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      12.88msalphaeurekaselec_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` = 99719 limit 1
      340μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 99719
      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 = 99719 and content_type = 'article' order by status desc limit 1
      990μ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 = 16 and cd.sub_disease_id = 436 and content_id!=99719 and cd.content_type = 'article' order by rand() limit 20
      96.47msalphaeurekaselec_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` = 173590 limit 1
      260μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 173590
      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
      260μ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` = 'CMIM' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      340μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: CMIM
      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 = '99719' 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) )
      430μ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 = '10077' 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) )
      350μ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 = '2796' 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) )
      310μ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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740472880 and j.to_date >= 1740472880 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2796) 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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740472880 and j.to_date >= 1740472880 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2796) 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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740472880 and j.to_date >= 1740472880 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2796)
      33.31msalphaeurekaselec_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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740472880 and j.to_date >= 1740472880 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10077) 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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740472880 and j.to_date >= 1740472880 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10077) 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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740472880 and j.to_date >= 1740472880 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10077)
      930μ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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740472880 and j.to_date >= 1740472880 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99719) 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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740472880 and j.to_date >= 1740472880 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99719) 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 <= 316548017 and j.to_ip >=316548017 )) and ((j.from_date <= 1740472880 and j.to_date >= 1740472880 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99719)
      890μ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` < '902' and is_uploaded = 1 and issue_id = 10077 order by cast(first_page as SIGNED) desc limit 1
      770μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 902
      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` > '912' and is_uploaded = 1 and issue_id = 10077 order by cast(first_page as SIGNED) asc limit 1
      510μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 912
      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'
      280μ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
      340μ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` = 99719 limit 1
      3.36msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 99719
      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` = 33 and `b`.`banner_from_date` <= 1740472880 and `b`.`banner_to_date` >= 1740472880 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.71msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 33
      • 3: 1740472880
      • 4: 1740472880
      • 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` = 33 and `b`.`banner_from_date` <= 1740472880 and `b`.`banner_to_date` >= 1740472880 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.65msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 33
      • 3: 1740472880
      • 4: 1740472880
      • 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='31f1b15fcd8172b02d7f8a776a055ff4'
      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
        ypbmGF2UiXNi93ofauMzGQCDnI00gQfpS22yRpje
        uc_cart_id
        31f1b15fcd8172b02d7f8a776a055ff4
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/99719" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/99719
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:8 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Tue, 25 Feb 2025 08:41:20 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlEwVm9YajJtMlRmaWVUMEhwTkxvTnc9PSIsInZhbHVlIjoiZVFGM0FzbXI3REw3QWdLMFBPbnl1bzgxd1gwSHhtU09hb1FrY2tSU2Z0R1JBekhYRmNmeGxxTkNOOWFlU2hLaEplT3QweVBjcnhoTSt2eHF6bGVTekN0STVzV2JTSmtFZ1JMOWg0dWF3VFJDZ3FqNWZ6MXR1Nlk5a3Z2c2h4VzciLCJtYWMiOiIzNmZhNzdkMzg2NWE3Yjg4YTkzYmFmOTkyN2Q5MWZmNDNkYzI0ZGVlMzgyNmNiZjE0MmNiYWExZDQwYjU4MjU4IiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 20:41:20 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlEwVm9YajJtMlRmaWVUMEhwTkxvTnc9PSIsInZhbHVlIjoiZVFGM0FzbXI3REw3QWdLMFBPbnl1bzgxd1gwSHhtU09hb1FrY2tSU2Z0R1JBekhYRmNmeGxxTkNOOWFlU2hLaEplT3Qwe" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlBOTmhZbkJVaXRDVzVPTkFQUE5aRmc9PSIsInZhbHVlIjoiNW5ZM2FTQUthZTlPR2svZHpFUjB6QWYvOEY1Z1pMcUQxcEppMFVnbnBxRmQ1YkVLSUR6SGNuZzNpTmFrY2hqNkd6R2szMFREcThOV0JXL2JmSnpoMWY5NmxhWFpFaHpzbGNLejlFUzRHc2Y1RmhqOEFDWlJaUHJGbWJBbUg5UEoiLCJtYWMiOiI2OWYzMGIxYWM0MWRhYWMzZjg5YzJiOWMzOWRmNjM4ZmJkMzdiNTdmYmNhMjYwY2Q0N2I4NzdjOGFmM2QwM2EwIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlBOTmhZbkJVaXRDVzVPTkFQUE5aRmc9PSIsInZhbHVlIjoiNW5ZM2FTQUthZTlPR2svZHpFUjB6QWYvOEY1Z1pMcUQxcEppMFVnbnBxRmQ1YkVLSUR6SGNuZzN" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlEwVm9YajJtMlRmaWVUMEhwTkxvTnc9PSIsInZhbHVlIjoiZVFGM0FzbXI3REw3QWdLMFBPbnl1bzgxd1gwSHhtU09hb1FrY2tSU2Z0R1JBekhYRmNmeGxxTkNOOWFlU2hLaEplT3QweVBjcnhoTSt2eHF6bGVTekN0STVzV2JTSmtFZ1JMOWg0dWF3VFJDZ3FqNWZ6MXR1Nlk5a3Z2c2h4VzciLCJtYWMiOiIzNmZhNzdkMzg2NWE3Yjg4YTkzYmFmOTkyN2Q5MWZmNDNkYzI0ZGVlMzgyNmNiZjE0MmNiYWExZDQwYjU4MjU4IiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 20:41:20 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlEwVm9YajJtMlRmaWVUMEhwTkxvTnc9PSIsInZhbHVlIjoiZVFGM0FzbXI3REw3QWdLMFBPbnl1bzgxd1gwSHhtU09hb1FrY2tSU2Z0R1JBekhYRmNmeGxxTkNOOWFlU2hLaEplT3Qwe" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlBOTmhZbkJVaXRDVzVPTkFQUE5aRmc9PSIsInZhbHVlIjoiNW5ZM2FTQUthZTlPR2svZHpFUjB6QWYvOEY1Z1pMcUQxcEppMFVnbnBxRmQ1YkVLSUR6SGNuZzNpTmFrY2hqNkd6R2szMFREcThOV0JXL2JmSnpoMWY5NmxhWFpFaHpzbGNLejlFUzRHc2Y1RmhqOEFDWlJaUHJGbWJBbUg5UEoiLCJtYWMiOiI2OWYzMGIxYWM0MWRhYWMzZjg5YzJiOWMzOWRmNjM4ZmJkMzdiNTdmYmNhMjYwY2Q0N2I4NzdjOGFmM2QwM2EwIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlBOTmhZbkJVaXRDVzVPTkFQUE5aRmc9PSIsInZhbHVlIjoiNW5ZM2FTQUthZTlPR2svZHpFUjB6QWYvOEY1Z1pMcUQxcEppMFVnbnBxRmQ1YkVLSUR6SGNuZzN" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "ypbmGF2UiXNi93ofauMzGQCDnI00gQfpS22yRpje" "uc_cart_id" => "31f1b15fcd8172b02d7f8a776a055ff4" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/99719" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 08:41:20GET/article/99719314371