Generic placeholder image

Recent Advances in Computer Science and Communications

Editor-in-Chief

ISSN (Print): 2666-2558
ISSN (Online): 2666-2566

General Research Article

Research on Java Programming Course Based on CDIO and Iterative Engineering Teaching Pattern

Author(s): Cai Yang*

Volume 13, Issue 3, 2020

Page: [519 - 530] Pages: 12

DOI: 10.2174/2213275912666190819103333

Price: $65

Abstract

Background: In universities, the course of Java programming is widely offered.It contains many contents and is practical. Therefore, learning Java programming is considered to be a difficult and challenging task for beginners. That is to say, students must learn a lot of programming skills in order to effectively master the course. However, it is often reported that the result of teaching Java programming is poor, mainly reflected in the stereotyped teaching methods, lack of project development experience and so on. In order to investigate and solve these problems, many educational experts have conducted in-depth research about it. CDIO (Conceiving-Designing-Implementing-Operating) engineering education model is the latest achievement of engineering education reform in recent years. It is a life cycle from product development to product operation as the carrier, which enables students to learn engineering in an active, practical and comprehensive way. For the problems in Java programming course, the concept of CDIO engineering is introduced to solve them.

Methods: Firstly, the research status of Java programming course and the application of CDIO model were analysed. Secondly, the current situation of learning was analysed by means of questionnaire survey. At the same time, the main problems existing in the current teaching project were listed. Following this, the questionnaire method was used to analyse the current learning situation of Java programming course. The ideas of CDIO engineering education and iteration mode were applied to Java programming course. From various perspectives, this paper makes a detailed analysis of the development methods and strategies of the new teaching mode. Finally, the teaching model was applied to the existing teaching process. The teaching effect of the model was verified by data statistics.

Results: The experimental results show that the new teaching mode encouraged students to master programming knowledge as well as problem-solving strategies. Students' interest in learning has been increased and their comprehensive ability has also been improved. Compared with traditional teaching methods, teachers tend to adopt CDIO teaching methods. The data statistics of teaching effect include six aspects: learning initiative, learning interest, knowledge-related ability, communication ability and practical ability, practical skills and final examination scores. The final exam results also showed that students with the new method performed better than those being taught with the older teaching method.

Conclusion: A new teaching model based on graded iteration and CDIO Engineering education mode is proposed for the problems existing in the teaching process of Java programming course. This paper creatively combines CDIO engineering ideas with Java programming course, and introduces the idea of hierarchical iteration. According to this idea, the knowledge structure of the course is put forward, and the teaching method of CDIO is adopted to attract students to study Java programming. The basic characteristics of the teaching mode are that the project is taken as the main line, the teacher as the leading role, and the students as the main body, so as to cultivate the students' comprehensive engineering ability. By strengthening the classroom teaching and practice teaching, the new model improves the Java teaching process, and enhances the teaching effect. The teaching practice proves that the new teaching model can mobilize the enthusiasm of students and improve the students' practical ability. It is worthy of popularizing.

Keywords: CDIO, iterative engineering teaching, collaborative learning platform, instructional effectiveness, outcomes of education, teaching reform.

Graphical Abstract

[1]
T. Amira, M. Lamia, and M. Hafidi, "Implementation and evaluation of flipped algorithmic class", Int. J. Inf. Commun. Technol. Educ., vol. 15, no. 1, pp. 1-12, 2019.
[http://dx.doi.org/10.4018/IJICTE.2019010101]
[2]
B. Tomić, J. Jovanović, N. Milikić, V. Devedžić, S. Dimitrijević, D. Đurić, and Z. Ševarac, "Grading students’ programming and soft skills with open badges: A case study", Br. J. Educ. Technol., vol. 50, no. 2, pp. 518-530, 2019.
[3]
S.I. Malik, and J. Coldwell-Neilson, "Impact of a new teaching and learning approach in an introductory programming course", J. Educ. Comput. Res., vol. 55, no. 6, pp. 789-819, 2017.
[http://dx.doi.org/10.1177/0735633116685852]
[4]
A. Nordby, and S. Karlsen, "Teaching ‘hardcorescience’ to arts and design students: Reflections on the development of a basic programming course. Information", Nordic J. Art Res., vol. 3, no. 2, pp. 43-46, 2014.
[5]
H. Chen, and S. Brennan, "Sadler, The effects of first programming language on college students’ computing attitude and achievement: A comparison of graphical and textual languages", Comput. Sci. Educ., vol. 29, no. 1, pp. 23-48, 2019.
[http://dx.doi.org/10.1080/08993408.2018.1547564]
[6]
S. Sentance, J. Waite, and M. Kallia, "Teachers’ experiences of using PRIMM to teach programming in School", Proceedings of the 50th ACM Technical Symposium on Computer Science Education, 2019, pp. 476-482.
[http://dx.doi.org/10.1145/3287324.3287477]
[7]
M.M. Müller, "A preliminary study on the impact of a pair design phase on pair programming and solo programming", Inf. Softw. Technol., vol. 48, no. 5, pp. 335-344, 2019.
[http://dx.doi.org/10.1016/j.infsof.2005.09.008]
[8]
J. Lagus, K. Longi, A. Klami, A. Hellas, R. Callingham, and K. Beswick, "Transfer-learning methods in programming course outcome prediction", ACM Trans. Comput. Educ., vol. 18, no. 4, pp. 1-18, 2018.
[http://dx.doi.org/10.1145/3152714]
[9]
S.I. Malik, "Gender differences in an introductory programming course: New teaching approach, students’ learning outcomes, and perceptions", Educ. Inf. Technol., vol. 23, no. 6, pp. 2453-2475, 2018.
[http://dx.doi.org/10.1007/s10639-018-9725-3]
[10]
E. Casey, "Davenport, evolution in student perceptions of a flipped classroom in a computer programming course", J. Coll. Sci. Teach., vol. 47, no. 4, pp. 30-35, 2018.
[11]
T. Li, M.A. Petrini, and T.E. Stone, "Baccalaureate nursing students’ perspectives of peer tutoring in simulation laboratory, a Q methodology study", Nurse Educ. Today, vol. 61, pp. 235-241, 2018.
[http://dx.doi.org/10.1016/j.nedt.2017.12.001] [PMID: 29268198]
[12]
M. López-Nores, Y. Blanco-Fernández, J.F. Bravo-Torres, and J.J. Pazos-Arias, "Alberto Gil-SollaManue, Ramos-Cabrer, Experiences from placing Stack Overflow at the core of an intermediate programming course", Comput. Appl. Eng. Educ., vol. 27, no. 3, pp. 698-707, 2019.
[http://dx.doi.org/10.1002/cae.22109]
[13]
T.Q. Le, T.N.H. Diep, and T.A.D. Thu, "Learning outcomes for training program by cdio approach applied to mechanical industry 4.0", J. Mech. Eng. Res. Dev., vol. 42, no. 1, pp. 50-55, 2019.
[http://dx.doi.org/10.26480/jmerd.01.2019.50.55]
[14]
D.X. Khoa, and N.H. Bang, "A Low-Cost Experimental Kit for Teaching Wave Optics Based on the CDIO Approach", Phys. Teach., vol. 57, no. 3, pp. 169-172, 2019.
[http://dx.doi.org/10.1119/1.5092477]
[15]
A. Chuchalin, J. Malmqvist, and M. Tayurskaya, "“Professional development of Russian HEIs” management and faculty in CDIO standards application", Eur. J. Eng. Educ., vol. 41, no. 4, pp. 426-437, 2016.
[http://dx.doi.org/10.1080/03043797.2015.1085837]
[16]
Tseng Cheng-Tang, Lee Ching-Yi, and Tai Kuo-Cheng, "Development and assessment of a mold design curriculum corresponding to industry 4.0 based on the CDIO principles", Int. J. of Eng. Educ., vol. 35, no. 5, pp. 1526-1539, 2019.
[17]
S. Schedin, and O.A.B. Hassan, "Work integrated learning model in relation to CDIO standards", J. Appl. Res. High. Educ., vol. 8, no. 3, pp. 278-286, 2016.
[http://dx.doi.org/10.1108/JARHE-11-2014-0104]
[18]
S. Gunnarsson, "Automatic Control Education in a CDIO Perspective", IFAC Papers OnLine, vol. 50, no. 1, pp. 12161-12166, 2017.
[http://dx.doi.org/10.1016/j.ifacol.2017.08.2145]
[19]
Y. Wang, "Reform and Exploration on Electric Circuit Course Teaching Based on CDIO", Creat. Educ., vol. 7, no. 3, pp. 478-481, 2016.
[http://dx.doi.org/10.4236/ce.2016.73048]
[20]
T.Q. Le, "Active teaching techniques for engineering students to ensure the learning outcomes of training programs by CDIO approach", Int. J. Adv. Sci. Eng. Inf. Technol., vol. 9, no. 1, pp. 266-273, 2019.
[21]
J.C-Y. Sun, and K.Y-C. Hsu, "A smart eye-tracking feedback scaffolding approach to improving students’ learning self-efficacy and performance in a C programming course", Comput. Human Behav., vol. 95, pp. 66-72, 2019.
[http://dx.doi.org/10.1016/j.chb.2019.01.036]
[22]
W. Sheng, "Design and implementation of mixed flip classroom teaching plan-taking the object-oriented programming (JAVA) course as an example", Int. J. Educ. Manag., vol. 3, no. 4, pp. 6-9, 2018.
[23]
D. Jovanovic, and S. Jovanovic, "An adaptive e‐learning system for Java programming course, based on Dokeos LE", Comput. Appl. Eng. Educ., vol. 23, no. 3, pp. 337-343, 2015.
[http://dx.doi.org/10.1002/cae.21603]
[24]
K. Huang, Y. Liu, Y. Huang, L. Li, L. Cooper, J. Ruan, and Z. Zhao, "The incremental teaching project design for project-based learning and its application in java programming course", Intelligent biology and medicine in 2015: Advancing interdisciplinary education, collaboration, and data science, BMC Genom., vol. 17, no. 6, suppl. Suppl. 7, p. 524, 2016.
[http://dx.doi.org/10.1186/s12864-016-2893-x] [PMID: 27556295]
[25]
M. Hugerat, "How teaching science using project-based learning strategies affects the classroom learning environment", Learn. Environ. Res., vol. 19, no. 3, pp. 383-395, 2016.
[http://dx.doi.org/10.1007/s10984-016-9212-y]
[26]
K. Al-Tahat, "The impact of a 3D visual programming tool on students’ performance and attitude in computer programming: A case study in Jordan", J. Cases Inf. Technol., vol. 29, no. 1, pp. 52-64, 2019.
[http://dx.doi.org/10.4018/JCIT.2019010104]
[27]
P. Chul-sung, and C. Joo-sun, Memory chip, memory system, and method of accessing the memory chip,” U. S. Patent.
[28]
V.V. Enrique, and K.S. Katarzyna, System and method for a switching transistor..
[29]
C.D.I.O. Org, http://www.cdio.org
[30]
H. Huang, L. Gao, X. Qi, and N. Jian, "Systems and methods for loop suspension in java programming", U.S. Patent 9,250,935, February 2016.,
[31]
V. Clara, D. Scott, S. Patrick, B. Patrick, and M. Alberto, Detecting and classifying workspace regions for safety monitoring.U.S. Patent 10,099,372, 2018.,
[32]
S.D. Woolf, G. Mythreyee, P. O’Kelley, and M. Neema, "Scaffolding support for learning application programs in a computerized learning environment", U.S. Patent 8,137,112, Vol. 8, Issued March, , pp. 261-191, 2008.
[33]
R. Fifield, "Receiver having an adaptive filter and method of optimizing the filter", U.S. Patent 8,634,507, , vol. 120, pp. 150-934, 2012.
[34]
W.E. Weihl, and S. Gene, "Forward request queuing in a distributed edge processing environment", U.S. Patent 8,423,662, , vol. 160, pp. 381-088, April 2013.
[35]
P. Jiri, and V. Martin, "Assisted garbage collection in a virtual machine", U.S. Patent 10,114,745, , vol. 160, pp. 098-346, 2018.
[36]
B. Issa, H. Ghaith, O. Rashad, and A-H. Rawad, "Computing device providing electronic book data with rolling images and related methods", U.S. Patent 10,269,259, , vol. 160, pp. 026-351, 2016.
[37]
Z. Feng, and L.H-Q. Duc, "Method, apparatus, and system for object tracking and navigation", U.S. Patent 10,270,642, , vol. 180, pp. 183-650, 2018.
[38]
A. Austin, S. Wayne, and C. Jasmin, "Instrument and system for rapid microorganism identification and antimicrobial agent susceptibility testing", U.S. Patent 20,190,203,252, , vol. 180, pp. 135-093, 2018.
[39]
L.N. James, P.N. Robert, and F.B. Peter, "System and method for marksmanship training", U.S. Patent 20150276349A1, , vol. 170, pp. 307-333, 2017.
[40]
S. Shinichi, "Risk analysis of codebase using static analysis and performance data", U.S. Patent 10275333B2, , vol. 150, pp. 363-292, 2015.
[41]
A. Chuchalin, J. Malmqvist, and M. Tayurskaya, "Professional development of Russian HEIs’ management and faculty in CDIO standards application", Eur. J. Eng. Educ., vol. 41, no. 4, pp. 426-437, 2016.
[http://dx.doi.org/10.1080/03043797.2015.1085837]
[42]
K. Edström, "Academic and professional values in engineering education: Engaging with history to explore a persistent tension", Eng. Stud., vol. 10, no. 1, pp. 38-65, 2018.
[http://dx.doi.org/10.1080/19378629.2018.1424860]
[43]
D. Song, "Comparison of CDIO and chinese engineering education accreditation for animation specialty of TUST", Procedia Comput. Sci., vol. 131, pp. 765-770, 2018.
[http://dx.doi.org/10.1016/j.procs.2018.04.322]
[44]
T. Haavi, N. Tvenge, and K. Martinsen, "CDIO design education collaboration using 3D-desktop printers", Procedia CIRP, vol. 70, pp. 325-330, 2018.
[http://dx.doi.org/10.1016/j.procir.2018.03.277]
[45]
H.M. Omar, "Enhancing automatic control learning through Arduino-based projects", Eur. J. Eng. Educ., vol. 43, no. 5, pp. 652-663, 2018.
[http://dx.doi.org/10.1080/03043797.2017.1390548]
[46]
O.M. Zamyatina, M.G. Minin, D.S. Denchuk, and V.O. Sadchenko, "Analysis of engineering invention competencies in standards and programmes of engineering universities", Procedia Soc. Behav. Sci., vol. 171, pp. 1088-1096, 2015.
[http://dx.doi.org/10.1016/j.sbspro.2015.01.270]
[47]
Y. Fan, X. Zhang, and X. Xie, "Design and development of a course in professionalism and ethics for CDIO curriculum in China", Sci. Eng. Ethics, vol. 21, no. 5, pp. 1381-1389, 2015.
[http://dx.doi.org/10.1007/s11948-014-9592-2] [PMID: 25230906]
[48]
M.C. Ramírez, J.P. Sanabria, D.M. Duarte, and L.C. Caicedo, "Methodology to support participative decision-making with vulnerable communities. Case study: Engineers without borders Colombia/Ingenieros Sin Fronteras Colombia—ISFCOL", Syst. Pract. Action Res., vol. 28, no. 2, pp. 125-161, 2015.
[http://dx.doi.org/10.1007/s11213-014-9325-0]

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version349msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[04:36:56] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[04:36:56] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[04:36:56] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (145ms)time
  • Application (204ms)time
  • 1 x Application (58.38%)
    204ms
    1 x Booting (41.61%)
    145ms
    14 templates were rendered
    • articlearticle.blade.php#?blade
    • includes.article_top_bannerarticle_top_banner.blade.php#?blade
    • includes.article_referencearticle_reference.blade.php#?blade
    • export_citation_formexport_citation_form.blade.php#?blade
    • includes.article_bottom_bannerarticle_bottom_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.blade.php#?blade
    • includes.journal_rightmenujournal_rightmenu.blade.php#?blade
    • includes.journal_right_bannerjournal_right_banner.blade.php#?blade
    • layouts.appapp.blade.php#?blade
    • layouts._login_access_login_access.blade.php#?blade
    • layouts._header_header.blade.php#?blade
    • layouts._main_menu_main_menu.blade.php#?blade
    • layouts._footer_menu_footer_menu.blade.php#?blade
    uri
    GET article/{article_id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ArticleController@GetArticleDetails
    namespace
    App\Http\Controllers
    where
    as
    article
    file
    app/Http/Controllers/ArticleController.php:1974-2510
    36 statements were executed, 4 of which were duplicates, 32 unique. Show only duplicated98.07ms
    • 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 ('316245611','',1,1740458216,1740458216) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740458216
      1.86msalphaeurekaselec_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 ('316245611','/article/100296',1,1740458216,1740458216)
      240μ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 >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) 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 >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) 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 >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) 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 >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) 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 >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) 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 >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316245611 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316245611) limit 1
      18.09msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316245611
      • 1: 316245611
      • 2: 316245611
      • 3: 316245611
      • 4: 316245611
      • 5: 316245611
      • 6: 316245611
      • 7: 316245611
      • 8: 316245611
      • 9: 316245611
      • 10: 316245611
      • 11: 316245611
      • 12: 316245611
      • 13: 316245611
      • 14: 316245611
      • 15: 316245611
      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=100296
      1.66msalphaeurekaselec_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` = 179 limit 1
      530μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 179
      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=179) and sj.journal_id!=179 group by `j`.`nid`) as `aggregate_table`
      860μ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=179) and sj.journal_id!=179 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      730μ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=179) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      2.52msalphaeurekaselec_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=179) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      2.14msalphaeurekaselec_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` = '100296'
      1.61msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 100296
      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` = '100296'
      2.64msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 100296
      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` = '100296' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      3.1msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 100296
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      350μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      490μ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 = 179 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      24.73msalphaeurekaselec_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 = 179 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      5.16msalphaeurekaselec_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 = 179 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      4.45msalphaeurekaselec_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` = 100296 limit 1
      780μsalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 100296
      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 = 100296 and content_type = 'article' order by status desc limit 1
      390μsalphaeurekaselec_live_10_06_2022Article.php#751
      Backtrace
      • 11. app/Models/Article.php:751
      • 12. app/Http/Controllers/ArticleController.php:2094
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 14. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `node_meta` where `nid` = 174281 limit 1
      280μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 174281
      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
      330μ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` = 'RACSC' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      4.2msalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: RACSC
      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 = '100296' 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) )
      780μ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 = '9799' 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) )
      480μ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 = '2669' 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) )
      420μ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 <= 316245611 and j.to_ip >=316245611 )) and ((j.from_date <= 1740458216 and j.to_date >= 1740458216 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2669) 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 <= 316245611 and j.to_ip >=316245611 )) and ((j.from_date <= 1740458216 and j.to_date >= 1740458216 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2669) 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 <= 316245611 and j.to_ip >=316245611 )) and ((j.from_date <= 1740458216 and j.to_date >= 1740458216 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2669)
      11.09msalphaeurekaselec_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 <= 316245611 and j.to_ip >=316245611 )) and ((j.from_date <= 1740458216 and j.to_date >= 1740458216 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9799) 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 <= 316245611 and j.to_ip >=316245611 )) and ((j.from_date <= 1740458216 and j.to_date >= 1740458216 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9799) 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 <= 316245611 and j.to_ip >=316245611 )) and ((j.from_date <= 1740458216 and j.to_date >= 1740458216 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 9799)
      700μ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 <= 316245611 and j.to_ip >=316245611 )) and ((j.from_date <= 1740458216 and j.to_date >= 1740458216 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100296) 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 <= 316245611 and j.to_ip >=316245611 )) and ((j.from_date <= 1740458216 and j.to_date >= 1740458216 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100296) 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 <= 316245611 and j.to_ip >=316245611 )) and ((j.from_date <= 1740458216 and j.to_date >= 1740458216 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 100296)
      650μ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` < '519' and is_uploaded = 1 and issue_id = 9799 order by cast(first_page as SIGNED) desc limit 1
      670μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 519
      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` > '530' and is_uploaded = 1 and issue_id = 9799 order by cast(first_page as SIGNED) asc limit 1
      570μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 530
      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'
      220μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      240μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 100296 limit 1
      2.46msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 100296
      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` = 179 and `b`.`banner_from_date` <= 1740458216 and `b`.`banner_to_date` >= 1740458216 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.21msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 179
      • 3: 1740458216
      • 4: 1740458216
      • 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` = 179 and `b`.`banner_from_date` <= 1740458216 and `b`.`banner_to_date` >= 1740458216 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.19msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 179
      • 3: 1740458216
      • 4: 1740458216
      • 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='86db1b3323487c2a357eec06ea5d9ac6'
      250μ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
        y8MmwRm3WkpPzYJT0w7dkB8lINNFngbDngESmuDI
        uc_cart_id
        86db1b3323487c2a357eec06ea5d9ac6
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/article/100296" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/100296
        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:17 [ "x-https" => array:1 [ 0 => "1" ] "host" => array:1 [ 0 => "alpha.eurekaselect.com" ] "priority" => array:1 [ 0 => "u=0, i" ] "cookie" => array:1 [ 0 => "wayfindertarget=eyJpdiI6IlA2Z1dXazhYQUtOaVlSM09NVno4Mnc9PSIsInZhbHVlIjoiOHFoS0syczRWT2RmTUVadW9BT3BtcitNeXhWQWtZa3VtaW1RMGdrUmRQcz0iLCJtYWMiOiJjMDA4NDU1YjAwYWQyODFjMmNiYjFjODI1MDZlOWRkMTI4YTRkNGQ2OTI4MGMxNTI4MzY4NDUyZjlkOWEwZGFmIiwidGFnIjoiIn0%3D; XSRF-TOKEN=eyJpdiI6ImZudldzMTVQbE9oYXJYM3l6bmFVUlE9PSIsInZhbHVlIjoiaUc5cWNXbTZDNFRMbnJaZ1dna1FXRlBaK1djeHlKaXNQQldZMmExYzlQMGVkY2NwMUZOSnFRS3E0Q003K0FGY2x4ajNtTnhUeFR2cytJNkJUVkg2K3F2TXFtMUdBa01GWkNpZnpFR093Z0NHSXRSWHpGR3dMc2gyQW0va2dLaXIiLCJtYWMiOiI5NDJhYjEyZGQxZDQ0ZGJkNDExYmVlODFhYmNhN2M1YmZlM2QwYzhlOTMyZDQ0NzhhMjhiZGM5NThhZTMwZDY0IiwidGFnIjoiIn0%3D; alphaeurekaselectnet_session=eyJpdiI6InY3RDBCcmxwd0JHUi82TDdHemxXUWc9PSIsInZhbHVlIjoiYzlZaHdxaUxLTzh0WnFtMk53citXZHZ2SlEwbUdGTm1ORHRoYVBDMlI1c1dDQllLamM3bWVmRWg5ZUdRVDA2cmRZNkhoSVlwbHp1cnBPTHliSm5LR1dyQ3NKdjlxbk44Q3lzRjNHRHVQQW1rNmxoMlUwUndobFJ2YmE1bXNKeEciLCJtYWMiOiI4MWYxZDhkZDgxMmVjOWZlYmIwYjBlYmM2NmNjODBmNWY5M2ViZmJkMzZhMmQxOTVkNjYzMGI1NTk0N2RmM2QwIiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6IlA2Z1dXazhYQUtOaVlSM09NVno4Mnc9PSIsInZhbHVlIjoiOHFoS0syczRWT2RmTUVadW9BT3BtcitNeXhWQWtZa3VtaW1RMGdrUmRQcz0iLCJtYWMiOiJjMDA4NDU1YjAwYWQy" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_cookies
        0 of 0
        array:3 [ "wayfindertarget" => null "XSRF-TOKEN" => "y8MmwRm3WkpPzYJT0w7dkB8lINNFngbDngESmuDI" "alphaeurekaselectnet_session" => "IKT4xnF3Qh65T0yye3yocy1suK2ieZI2bfkSvrhs" ]
        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:36:56 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IldTZDdaaUt3NFRYY2dpalJ2QVQ2Vnc9PSIsInZhbHVlIjoiYzJVeTl5ajJMY2pGR3FuY0xRMmg4dXRYei9lZzdGcXhyVFpseFZNUi9LZ3M5ci9ZdlB3OEg3THp1VGtJS24yaW4zQUpCVFZBS2MwOHYyc2E5emFqVTlMWXBFRm54b01JRUQweDdDZmF0WGp4eC9pTy9KZmVsMXBmOHh0SVdqMmQiLCJtYWMiOiI0MjgwZDA1MmUyYjVlMTE1ZDI3MmY4NzE0OGIwZTI3Y2Q2ZGUwNzE5MGI0MGEzNGQxMWM1NTQ4OTA3YTMyYTc1IiwidGFnIjoiIn0%3D; expires=Thu, 27 Feb 2025 16:36:56 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IldTZDdaaUt3NFRYY2dpalJ2QVQ2Vnc9PSIsInZhbHVlIjoiYzJVeTl5ajJMY2pGR3FuY0xRMmg4dXRYei9lZzdGcXhyVFpseFZNUi9LZ3M5ci9ZdlB3OEg3THp1VGtJS24yaW4zQUpCV" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkxqS1o2WHl5YWpGUlMvaVBUUVNTdlE9PSIsInZhbHVlIjoiUkRrTFFpejhJWHNjNHNvbjBNZjlRbmYvSGNSdnJyT0NQTVpSc0tNYjFCcVAyeEd0MUp6cTNDcDh3dHhtUGlTd01wQ0h6Yit4cVlKUlVXdG9sMWM0MGtBbEp0MC9QZy9kT0VoY1RNb0h0bUREeGc4WWpnbHh5OElWZnhuOEVISE4iLCJtYWMiOiJkMjk4MmIxNjAxMWJiNTZmNjUxMjk0ZmQ5NjdjMWEzMmNiYTgxNjFlMWM4NjY2ZTIxZjE5MTIzYmY1NDQ2MTZhIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IkxqS1o2WHl5YWpGUlMvaVBUUVNTdlE9PSIsInZhbHVlIjoiUkRrTFFpejhJWHNjNHNvbjBNZjlRbmYvSGNSdnJyT0NQTVpSc0tNYjFCcVAyeEd0MUp6cTNDcDh" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IldTZDdaaUt3NFRYY2dpalJ2QVQ2Vnc9PSIsInZhbHVlIjoiYzJVeTl5ajJMY2pGR3FuY0xRMmg4dXRYei9lZzdGcXhyVFpseFZNUi9LZ3M5ci9ZdlB3OEg3THp1VGtJS24yaW4zQUpCVFZBS2MwOHYyc2E5emFqVTlMWXBFRm54b01JRUQweDdDZmF0WGp4eC9pTy9KZmVsMXBmOHh0SVdqMmQiLCJtYWMiOiI0MjgwZDA1MmUyYjVlMTE1ZDI3MmY4NzE0OGIwZTI3Y2Q2ZGUwNzE5MGI0MGEzNGQxMWM1NTQ4OTA3YTMyYTc1IiwidGFnIjoiIn0%3D; expires=Thu, 27-Feb-2025 16:36:56 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IldTZDdaaUt3NFRYY2dpalJ2QVQ2Vnc9PSIsInZhbHVlIjoiYzJVeTl5ajJMY2pGR3FuY0xRMmg4dXRYei9lZzdGcXhyVFpseFZNUi9LZ3M5ci9ZdlB3OEg3THp1VGtJS24yaW4zQUpCV" 1 => "alphaeurekaselectnet_session=eyJpdiI6IkxqS1o2WHl5YWpGUlMvaVBUUVNTdlE9PSIsInZhbHVlIjoiUkRrTFFpejhJWHNjNHNvbjBNZjlRbmYvSGNSdnJyT0NQTVpSc0tNYjFCcVAyeEd0MUp6cTNDcDh3dHhtUGlTd01wQ0h6Yit4cVlKUlVXdG9sMWM0MGtBbEp0MC9QZy9kT0VoY1RNb0h0bUREeGc4WWpnbHh5OElWZnhuOEVISE4iLCJtYWMiOiJkMjk4MmIxNjAxMWJiNTZmNjUxMjk0ZmQ5NjdjMWEzMmNiYTgxNjFlMWM4NjY2ZTIxZjE5MTIzYmY1NDQ2MTZhIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IkxqS1o2WHl5YWpGUlMvaVBUUVNTdlE9PSIsInZhbHVlIjoiUkRrTFFpejhJWHNjNHNvbjBNZjlRbmYvSGNSdnJyT0NQTVpSc0tNYjFCcVAyeEd0MUp6cTNDcDh" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "y8MmwRm3WkpPzYJT0w7dkB8lINNFngbDngESmuDI" "uc_cart_id" => "86db1b3323487c2a357eec06ea5d9ac6" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/article/100296" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-25 04:36:56GET/article/100296314361