Generic placeholder image

Nanoscience & Nanotechnology-Asia

Editor-in-Chief

ISSN (Print): 2210-6812
ISSN (Online): 2210-6820

Research Article

Investigations on Optical, Material and Electrical Properties of aSi:H and aSiGe:H in Making Proposed n+aSi:H/i-aSi:H/p+aSiGe:H Graded Bandgap Single-junction Solar Cell

Author(s): Fatima Rasheed J.* and V. Suresh Babu

Volume 10, Issue 5, 2020

Page: [709 - 718] Pages: 10

DOI: 10.2174/2210681209666190627152852

Price: $65

Abstract

Objective: This work identifies materials that satisfy refractive index, optical band gap, composition profile, conductivity, hall mobility, carrier type and carrier concentration to utilize them in making thin film photovoltaic cells.

Methods: We fabricated phosphorous doped amorphous silicon (n+ aSi:H), boron doped amorphous silicon germanium(p+ aSiGe:H) and intrinsic amorphous silicon (i-aSi:H). A detailed and systematic characterization of the fabricated layers was done. The phosphorous doped amorphous silicon (n+ aSi:H) showed an optical band gap of 1.842 eV and an electron mobility of 295.45 cm2V-1s-1. The boron doped amorphous silicon germanium (p+ aSiGe:H) exhibited an optical band gap of 1.74 eV and a hole mobility of 158.353 cm2V-1s-1. The intrinsic amorphous silicon (i-aSi:H) has an optical band gap of 1.801 eV. The films of n+ aSi:H, i-aSi:H and p+ aSiGe:H can be utilized for fabricating graded band gap single junction thin film solar cells, as they are semiconducting materials with varying band gaps in the range of 1.74 eV to 1.84 eV. The tailoring of band gap achieved by the proposed material combination has been presented using its energy band diagram.

Results: In this work, we are proposing a single junction graded band gap solar cell with aSi:H and aSi- Ge:H alloys of varying doping to achieve grading of band gap, which improves the efficiency while keeping the cell compact and light.

Conclusion: As a first step in the validation, we have simulated a thin film solar cell using SCAPS1D simulation software with the measured parameters for each of the layers and found that it successfully performs as solar cell with an efficiency of 14.5%.

Keywords: Amorphous silicon alloys, PECVD, graded band gap, SCAPS1D, photovoltaic cells, cadmium.

Graphical Abstract

[1]
Meier, J.; Spitznagel, J.; Kroll, U.; Bucher, C.; Fay, S.; Moriarty, T.; Shah, A. Potential of amorphous and microcystalline silicon solar cells. Thin Solid Films, 2004, 451, 518-524.
[http://dx.doi.org/10.1016/j.tsf.2003.11.014]
[2]
Arai, Y.; Ishii, M.; Shinohara, H.; Yamazaki, S. A single pin junction amorphous-silicon solar cell with conversion efficiency of 12.65%. IEEE Electron Device Lett., 1991, 12(8), 460-461.
[http://dx.doi.org/10.1109/55.119165]
[3]
Dharmadasa, I.; Chaure, N.; Tolan, G.; Samantilleke, A. Development of p+, p, i, n, and n+type cuingase2 layers for applications in graded bandgap multilayer thin- film solar cells. J. Electrochem. Soc., 2007, 154(6), H466-H471.
[http://dx.doi.org/10.1149/1.2718401]
[4]
Jenny, D.A.; Bube, R.H. Semiconducting cadmium telluride. Phys. Rev., 1954, 96(5), 1190.
[http://dx.doi.org/10.1103/PhysRev.96.1190]
[5]
Bube, R. Photoconductivity of the sulfide, selenide, and telluride of zinc or cadmium. Proc. IRE, 1955, pp. 1836-1850.
[6]
Cusano, D. Cdte solar cells and photovoltaic heterojunctions in ii-vi compounds. Solid-State Electron., 1963, 6(3), 217-232.
[http://dx.doi.org/10.1016/0038-1101(63)90078-9]
[7]
Goldstein, B. Properties of photovoltaic films of cdte. Phys. Rev., 1958, 109(2), 601.
[http://dx.doi.org/10.1103/PhysRev.109.601.2]
[8]
Vodakov, Y.A.; Lomakina, G.; Naumov, G.; Maslakovets, Y.P. A pn junction photocell made of cadmium telluride. Soviet Phys. Solid State, 1960, 2(1), 1-4.
[9]
Dhere, N.G. Toward gw/year of cigs production within the next decade. Sol. Energy Mater. Sol. Cells, 2007, 91(15-16), 1376-1382.
[http://dx.doi.org/10.1016/j.solmat.2007.04.003]
[10]
Yunus, N.A.M.; Aman, N.H.N.; Khoshsirat, N. Comparison between thin- film solar cells and copper- indium-gallium-diselenide in Southeast Asia. IET Renew. Power Gener., 2015, 9(8), 1079-1086.
[http://dx.doi.org/10.1049/iet-rpg.2015.0114]
[11]
Carlson, D.E.; Wronski, C.R. Amorphous silicon solar cell. Appl. Phys. Lett., 1976, 28(11), 671-673.
[http://dx.doi.org/10.1063/1.88617]
[12]
Shah, A.; Schade, H.; Vanecek, M.; Meier, J.E. VallatSauvain, N. Wyrsch, U. Kroll, C. Droz, J. Bailat, Thin- film silicon solar cell technology. Prog. Photovolt. Res. Appl., 2004, 12(2-3), 113-142.
[http://dx.doi.org/10.1002/pip.533]
[13]
Gupta, N.; Alapatt, G.; Podila, R.; Singh, R.; Poole, K. Prospects of nanostructure-based so-lar cells for manufacturing future generations of photovoltaic modules. Int. J. Photoenergy, 2009, 2009154059
[http://dx.doi.org/10.1155/2009/154059]
[14]
Werner, J.H.; Zapf-Gottwick, R.; Koch, M.; Fischer, K. Toxic substances in photovoltaic modules. Proceedings of the 21st International Photovoltaic Science and Engineering Conference, Fukuoka, JapanNovember 28th to December 2nd, 2011
[15]
Candelise, C.; Winskel, M.; Gross, R. Implications for cdte and cigs technologies production costs of indium and tellurium scarcity. Prog. Photovolt. Res. Appl., 2012, 20(6), 816-831.
[http://dx.doi.org/10.1002/pip.2216]
[16]
Chopra, K.; Paulson, P.; Dutta, V. Thin- film solar cells: An overview. Prog. Photovolt. Res. Appl., 2004, 12(2-3), 69-92.
[http://dx.doi.org/10.1002/pip.541]
[17]
Mller, J.; Rech, B.; Springer, J.; Vanecek, M. Tco and light trapping in silicon thin film solar cells. Sol. Energy, 2004, 77(6), 917-930.
[http://dx.doi.org/10.1016/j.solener.2004.03.015]
[18]
Deng, X.; Liao, X.; Han, S.; Povolny, H.; Agarwal, P. Amorphous silicon and silicon ger-manium materials for high-efficiency triple-junction solar cells. Sol. Energy Mater. Sol. Cells, 2000, 62(1-2), 89-95.
[http://dx.doi.org/10.1016/S0927-0248(99)00139-7]
[19]
Multone, X.; Fesquet, L.; Borrello, D.; Romang, D.; Choong, G.; Vallat-Sauvain, E.; Charrire, M.; Billet, A.; Boucher, J-F.; Steinhauser, J. Triplejunction amor-phous/microcrystalline silicon solar cells: Towards industrially viable thin film solar technology. Sol. Energy Mater. Sol. Cells, 2015, 140, 388-395.
[20]
Matsui, T.; Bidiville, A.; Maejima, K.; Sai, H.; Koida, T.; Suezaki, T.; Matsumoto, M.; Saito, K.; Yoshida, I.; Kondo, M. High-efficiency amorphous silicon solar cells: impact of deposition rate on metastability. Appl. Phys. Lett., 2015, 106(5)053901
[http://dx.doi.org/10.1063/1.4907001]
[21]
Echendu, O.K.; Dharmadasa, I.M. Graded-bandgap solar cells using all-electrodeposited zns, cds and cdte thin- films. Energies, 2015, 8(5), 4416-4435.
[http://dx.doi.org/10.3390/en8054416]
[22]
Schttauf, J-W.; Niesen, B.; Lfgren, L. Amorphous silicon-germanium for triple and quadruple junction thin- film silicon based solar cells. Sol. Energy Mater. Sol. Cells, 2015, 133, 163-169.
[http://dx.doi.org/10.1016/j.solmat.2014.11.006]
[23]
Yang, J.; Banerjee, A.; Guha, S. Triple-junction amorphous silicon alloy solar cell with 14.6% initial and 13.0% stable conversion efficiencies. Appl. Phys. Lett., 1997, 70(22), 2975-2977.
[http://dx.doi.org/10.1063/1.118761]
[24]
Fan, Q.H.; Chen, C.; Liao, X.; Xiang, X.; Zhang, S.; Ingler, W.; Adiga, N.; Hu, Z.; Cao, X.; Du, W. High efficiency silicon-germanium thin film solar cells using graded absorber layer. Sol. Energy Mater. Sol. Cells, 2010, 94(7), 1300-1302.
[http://dx.doi.org/10.1016/j.solmat.2010.03.006]
[25]
Sai, H.; Matsui, T.; Koida, T.; Matsubara, K.; Kondo, M.; Sugiyama, S.; Katayama, H.; Takeuchi, Y.; Yoshida, I. Triple-junction thin- film silicon solar cell fabricated on periodically tex-tured substrate with a stabilized efficiency of 13.6%. Appl. Phys. Lett., 2015, 106(21)213902
[http://dx.doi.org/10.1063/1.4921794]
[26]
Bush, K.A.; Palmstrom, A.F.; Zhengshan, J.Y.; Boccard, M.; Cheacharoen, R.; Mailoa, J.P.; McMeekin, D.P.; Hoye, R.L.; Bailie, C.D.; Leijtens, T. 23.6%-efficient monolithic perovskite/silicon tandem solar cells with improved stability. Nat. Energy, 2017, 2(4), 17009.
[http://dx.doi.org/10.1038/nenergy.2017.9]
[27]
Meillaud, F.; Shah, A.; Droz, C.; Vallat-Sauvain, E.; Miazza, C. E ciency limits for single-junction and tandem solar cells. Sol. Energy Mater. Sol. Cells, 2006, 90(18-19), 2952-2959.
[http://dx.doi.org/10.1016/j.solmat.2006.06.002]
[28]
Nawaz, M. Computer analysis of thin- film amorphous silicon heterojunction solar cells. J. Phys. D Appl. Phys., 2011, 44(14)145105
[http://dx.doi.org/10.1088/0022-3727/44/14/145105]
[29]
Si, F.T.; Isabella, O.; Zeman, M. Thin- film amorphous silicon germanium solar cells with p-and n-type hydrogenated silicon oxide layers. Sol. Energy Mater. Sol. Cells, 2017, 163, 9-14.
[http://dx.doi.org/10.1016/j.solmat.2017.01.001]
[30]
Wang, G.; Shi, C.; Zhao, L.; Diao, H.; Wang, W. Fabrication of amorphous silicon-germanium thin film solar cell toward broadening long wavelength response. J. Alloys Compd., 2016, 658, 543-547.
[http://dx.doi.org/10.1016/j.jallcom.2015.10.235]
[31]
Krajangsang, T.; Inthisang, S.; Dousse, A.; Moollakorn, A.; Hongsingthong, A.; Kittison-tirak, S.; Chinnavornrungsee, P.; Limmanee, A.; Sritharathikhun, J.; Sriprapha, K. Band gap pro les of intrinsic amorphous silicon germanium lms and their application to amorphous silicon germanium heterojunction solar cells. Opt. Mater., 2016, 51, 245-249.
[http://dx.doi.org/10.1016/j.optmat.2015.11.012]
[32]
Son, W.H.; Lee, S.K.; Moon, Y.S.; Lee, T.Y.; Choi, S.Y. Characteristics of amorphous silicon thin- film solar cells of a-si: H/a-sige: H superlattices in different thickness for barrier and well layers. Mol. Cryst. Liq. Cryst. (Phila. Pa.), 2013, 586(1), 61-68.
[http://dx.doi.org/10.1080/15421406.2013.851502]
[33]
Lattyak, C.; Ravekes, R-E.; Steenho, V.; Vehse, M.; Agert, C. Ultrathin resonant-cavity-enhanced amorphous germanium solar cells on zno honeycomb electrodes. IEEE J. Photovoltaics, 2018, 8(1), 3-7.
[http://dx.doi.org/10.1109/JPHOTOV.2017.2762527]
[34]
Chen, Y-H.; Fang, H-Y.; Yeh, C-M. Raman scattering and electrical characterizations studies of hydrogenated amorphous silicon-germanium alloys prepared by 40 mhz plasma-enhanced cvd. J. Non-Cryst. Solids, 2011, 357(1), 1-3.
[http://dx.doi.org/10.1016/j.jnoncrysol.2010.09.060]
[35]
Burgelman, M.; Verschraegen, J.; Degrave, S.; Nollet, P. Modeling thin- film pv devices. Prog. Photovolt. Res. Appl., 2004, 12(2-3), 143-153.
[http://dx.doi.org/10.1002/pip.524]
[36]
Burgelman, M.; Marlein, J. Analysis of graded band gap solar cells with scaps. Proceedings of the 23rd European Photovoltaic Solar Energy Conference, Valencia, Spain2008.
[37]
Ambrosio, R.; Moreno, M.; Torres, A.; Carrillo, A.; Vivaldo, I.; Cosme, I.; Heredia, A. De-position and characterization of amorphous silicon with embedded nanocrystals and micro-crystalline silicon for thin film solar cells. J. Alloys Compd., 2015, 643, S27-S32.
[http://dx.doi.org/10.1016/j.jallcom.2014.11.105]
[38]
Plasma enhanced chemical vapor deposition of amorphous, polymor-phous and microcrystalline silicon films. J. Non-Cryst. Solids, 2000, 266, 31-37.
[39]
Hishikawa, Y.; Nakamura, N.; Tsuda, S.; Nakano, S.; Kishi, Y.; Kuwano, Y. Interference-free determination of the optical absorption coefficient and the optical gap of amorphous silicon thin films. Jpn. J. Appl. Phys., 1991, 30(5R), 1008.
[40]
Robertson, J. Deposition mechanism of hydrogenated amorphous silicon. J. Appl. Phys., 2000, 87(5), 2608-2617.
[http://dx.doi.org/10.1063/1.372226]
[41]
Crose, M.; Kwon, J.S-I.; Tran, A.P.D. Christo des, Multiscale modeling and run-to-run control of pecvd of thin film solar cells. Renew. Energy, 2017, 100, 129-140.
[http://dx.doi.org/10.1016/j.renene.2016.06.065]
[42]
Ayoub, G.; Bashara, N. Characterization of a very thin uniaxial film on a nonabsorbing substrate by multiple wavelength ellipsometry: Palmitic acid on water. JOSA, 1978, 68(7), 978-983.
[http://dx.doi.org/10.1364/JOSA.68.000978]
[43]
Azzam, R.; Bashara, N. Ellipsometry and polarized light north; J.A. Woollam Co.: USA, 1977.
[44]
Tauc, J. Optical properties and electronic structure of amorphous Ge and Si. Mater. Res. Bull., 1968, 3(1), 137-146.
[http://dx.doi.org/10.1016/0025-5408(68)90023-8]
[45]
Tauc, J.; Grigorovici, R.; Vancu, A. Optical properties and electronic structure of amorphous germanium. Phys. Status Solidi, 1966, 15(2), 627-637.
[46]
Gans, P. Vibrating molecules: An introduction to the interpretation of infrared and Raman spectra; CRC Press: Cleveland, USA, 1971.
[47]
Coates, J.P. The interpretation of infrared spectra: Published reference sources. Appl. Spectrosc. Rev., 1996, 31(1-2), 179-192.
[http://dx.doi.org/10.1080/05704929608000568]
[48]
Hollas, J.M. Modern spectroscopy; John Wiley & Sons: New Jersy, USA, 2004.
[49]
Russ, J.C. Fundamentals of energy dispersive X-ray analysis: Butterworths monographs in materials; Butterworth-Heinemann: Oxford, UK, 2013.
[50]
Brodsky, M.; Cardona, M.; Cuomo, J. Infrared and raman spectra of the silicon-hydrogen bonds in amorphous silicon prepared by glow discharge and sputtering. Phys. Rev. B, 1977, 16(8), 3556.
[http://dx.doi.org/10.1103/PhysRevB.16.3556]
[51]
Bragg, W. The investigation of the properties of thin films by means of X-rays. Nature, 1925, 115, 266-269.
[52]
Smith, K.; Oatley, C. The scanning electron microscope and its fields of application. Br. J. Appl. Phys., 1955, 6(11), 391.
[http://dx.doi.org/10.1088/0508-3443/6/11/304]
[53]
van der PAUWA L.J. method of measuring the resistivity and hall coefficient on lamellae of arbitrary shape. Semicond. Devices, 1991, 1, 174-182.
[54]
Mostefaoui, M.; Mazari, H.; Kheli, S.; Bouraiou, A.; Dabou, R. Simulation of high efficiency CIGS solar cells with SCAPS-1D software. Energy Procedia, 2015, 74, 736-744.
[http://dx.doi.org/10.1016/j.egypro.2015.07.809]
[55]
Olopade, M.A.; Oyebola, O.O.; Adeleke, B.S. Investigation of some materials as buffer layer in copper zinc tin sulphide (Cu2ZnSnS4) solar cells by SCAPS-1D. Adv. Appl. Sci. Res., 2012, 3(6), 3396-3400.
[56]
Kabir, M.I.; Shahahmadi, S.A.; Lim, V.; Zaidi, S.; Sopian, K.; Amin, N. Amorphous silicon singlejunction thin- film solar cell exceeding 10% efficiency by design optimization. Int. J. Photoenergy, 2012, 2012460919
[http://dx.doi.org/10.1155/2012/460919]
[57]
Qarony, W.; Hossain, M.I.; Hossain, M.K.; Uddin, M.J.; Haque, A.; Saad, A.; Tsang, Y.H. Efficient amorphous silicon solar cells: characterization, optimization, and optical loss analysis. Results Phys., 2017, 7, 4287-4293.

Rights & Permissions Print Cite
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version364msRequest Duration28MBMemory UsageGET article/{article_id}/{param?}Route
  • warninglog[17:24:22] LOG.warning: Optional parameter $article_id declared before required parameter $request i...
  • warninglog[17:24:22] LOG.warning: trim(): Passing null to parameter #1 ($string) of type string is deprecated ...
  • warninglog[17:24:22] LOG.warning: Function strftime() is deprecated in /home/alphaeurekaselec/public_html/stor...
  • Booting (139ms)time
  • Application (225ms)time
  • 1 x Application (61.85%)
    225ms
    1 x Booting (38.15%)
    139ms
    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 duplicated130ms
    • 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 ('316202228','',1,1740677062,1740677062) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740677062
      1.09msalphaeurekaselec_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 ('316202228','/article/99269',1,1740677062,1740677062)
      150μ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 >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) 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 >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) 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 >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) 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 >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) 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 >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) 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 >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 316202228 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 316202228) limit 1
      13.07msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 316202228
      • 1: 316202228
      • 2: 316202228
      • 3: 316202228
      • 4: 316202228
      • 5: 316202228
      • 6: 316202228
      • 7: 316202228
      • 8: 316202228
      • 9: 316202228
      • 10: 316202228
      • 11: 316202228
      • 12: 316202228
      • 13: 316202228
      • 14: 316202228
      • 15: 316202228
      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=99269
      690μsalphaeurekaselec_live_10_06_2022Article.php#408
      Backtrace
      • 11. app/Models/Article.php:408
      • 12. app/Http/Controllers/ArticleController.php:2515
      • 13. app/Http/Controllers/ArticleController.php:2035
      • 14. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 15. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `journal` where `journal_id` = 117 limit 1
      770μsalphaeurekaselec_live_10_06_2022Journal.php#64
      Bindings
      • 0: 117
      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=117) and sj.journal_id!=117 group by `j`.`nid`) as `aggregate_table`
      570μ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=117) and sj.journal_id!=117 group by `j`.`nid` order by `j`.`journal_id` asc limit 10 offset 0
      480μ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=117) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid`) as `aggregate_table`
      940μ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=117) and v.ebook_status='1' and y.year > 2020 group by `v`.`nid` order by `v`.`ebook_volume_id` desc limit 10 offset 0
      970μ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` = '99269'
      1.25msalphaeurekaselec_live_10_06_2022Keywords.php#43
      Bindings
      • 0: 99269
      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` = '99269'
      2.09msalphaeurekaselec_live_10_06_2022Article.php#1570
      Bindings
      • 0: 99269
      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` = '99269' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      1.7msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 99269
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ArticleController.php:2533
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `bo`.* from `bundle_offer` as `bo` where `bo`.`bundle_status` = 'A' order by `bo`.`bundle_id` desc
      250μsalphaeurekaselec_live_10_06_2022BundleOffer.php#57
      Bindings
      • 0: A
      Backtrace
      • 13. app/Models/BundleOffer.php:57
      • 14. app/Http/Controllers/ArticleController.php:2535
      • 15. app/Http/Controllers/ArticleController.php:2035
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `subtitle` from `journal` where `continues_publication_journal` = 1
      590μ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 = 117 and i.is_uploaded = 1 order by v.volume_name+0 desc, i.title+0 desc limit 1
      29.45msalphaeurekaselec_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 = 117 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      11.8msalphaeurekaselec_live_10_06_2022Article.php#528
      Backtrace
      • 13. app/Models/Article.php:528
      • 14. app/Http/Controllers/ArticleController.php:2070
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select a.nid,a.publish_on, a.pmid,a.article_id,a.doi,j.journal_id,j.subtitle,v.volume_name,a.volume_id as volume_id, a.issue_id,a.title,first_page, last_page, page_count,abstract,ifnull(is_abstract,"y"),asec.title as article_section,at.type_name as article_type_name, a.article_id as ArticleID ,is_epub,epub_price,epub_type,a.created, y.year from `article` as `a` left join `article_section` as `asec` on `asec`.`art_sec_id` = `a`.`is_epub` left join `article_type` as `at` on `at`.`art_type_id` = `a`.`art_type` left join `journal` as `j` on `j`.`journal_id` = `a`.`journal_id` inner join `volume` as `v` on `a`.`volume_id` = `v`.`volume_id` inner join `year` as `y` on `v`.`year_id` = `y`.`id` where a.article_status != "W" and a.is_epub = 4 and a.journal_id = 117 and a.is_uploaded = 1 group by `a`.`article_id` order by `a`.`publish_on` desc
      3.12msalphaeurekaselec_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` = 99269 limit 1
      1.93msalphaeurekaselec_live_10_06_2022Article.php#744
      Bindings
      • 0: 99269
      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 = 99269 and content_type = 'article' order by status desc limit 1
      330μ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` = 173056 limit 1
      200μsalphaeurekaselec_live_10_06_2022Meta.php#30
      Bindings
      • 0: 173056
      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
      230μ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` = 'NNA' and (h.proposal_closing_date = 0 OR TO_DAYS(FROM_UNIXTIME(h.proposal_closing_date)) >= TO_DAYS(NOW())) order by `h`.`manuscript` asc
      650μsalphaeurekaselec_live_10_06_2022Article.php#2025
      Bindings
      • 0: NNA
      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 = '99269' 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) )
      340μ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 = '10208' 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) )
      320μ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 = '2770' 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) )
      250μ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 <= 316202228 and j.to_ip >=316202228 )) and ((j.from_date <= 1740677062 and j.to_date >= 1740677062 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2770) 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 <= 316202228 and j.to_ip >=316202228 )) and ((j.from_date <= 1740677062 and j.to_date >= 1740677062 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2770) 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 <= 316202228 and j.to_ip >=316202228 )) and ((j.from_date <= 1740677062 and j.to_date >= 1740677062 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 2770)
      48.39msalphaeurekaselec_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 <= 316202228 and j.to_ip >=316202228 )) and ((j.from_date <= 1740677062 and j.to_date >= 1740677062 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10208) 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 <= 316202228 and j.to_ip >=316202228 )) and ((j.from_date <= 1740677062 and j.to_date >= 1740677062 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10208) 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 <= 316202228 and j.to_ip >=316202228 )) and ((j.from_date <= 1740677062 and j.to_date >= 1740677062 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.issue_id = 10208)
      840μ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 <= 316202228 and j.to_ip >=316202228 )) and ((j.from_date <= 1740677062 and j.to_date >= 1740677062 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99269) 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 <= 316202228 and j.to_ip >=316202228 )) and ((j.from_date <= 1740677062 and j.to_date >= 1740677062 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99269) 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 <= 316202228 and j.to_ip >=316202228 )) and ((j.from_date <= 1740677062 and j.to_date >= 1740677062 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.article_id = 99269)
      640μ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` < '709' and is_uploaded = 1 and issue_id = 10208 order by cast(first_page as SIGNED) desc limit 1
      820μsalphaeurekaselec_live_10_06_2022Article.php#1819
      Bindings
      • 0: 709
      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` > '718' and is_uploaded = 1 and issue_id = 10208 order by cast(first_page as SIGNED) asc limit 1
      500μsalphaeurekaselec_live_10_06_2022Article.php#1831
      Bindings
      • 0: 718
      Backtrace
      • 14. app/Models/Article.php:1831
      • 15. app/Http/Controllers/ArticleController.php:2472
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `language_id` from `multilanguage` where `short_code` = 'en'
      200μsalphaeurekaselec_live_10_06_2022ArticleController.php#2497
      Bindings
      • 0: en
      Backtrace
      • 14. app/Http/Controllers/ArticleController.php:2497
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select `source_lang_label`, `target_lang_label` from `multilanguage_labels` where `target_lang_id` = 1
      190μsalphaeurekaselec_live_10_06_2022MultiLanguage.php#23
      Bindings
      • 0: 1
      Backtrace
      • 13. app/Models/MultiLanguage.php:23
      • 14. app/Http/Controllers/ArticleController.php:2498
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id` from `multilanguage_article` where `article_id` = 99269 limit 1
      2.4msalphaeurekaselec_live_10_06_2022ArticleController.php#2506
      Bindings
      • 0: 99269
      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` = 117 and `b`.`banner_from_date` <= 1740677062 and `b`.`banner_to_date` >= 1740677062 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.1msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 117
      • 3: 1740677062
      • 4: 1740677062
      • 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` = 117 and `b`.`banner_from_date` <= 1740677062 and `b`.`banner_to_date` >= 1740677062 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.05msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: J
      • 2: 117
      • 3: 1740677062
      • 4: 1740677062
      • 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='a1a3b434bcd469f65370c3824eb769ed'
      200μ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
        ZauGYtzmY5DVuQk7ePGFGHVNphLS9mGcmE0tUxUA
        uc_cart_id
        a1a3b434bcd469f65370c3824eb769ed
        _previous
        array:1 [ "url" => "http://alpha.eurekaselect.com/article/99269" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /article/99269
        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 => "Thu, 27 Feb 2025 17:24:22 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IklIbDUzS2tmWU1wc2tXZmN4bzVlc0E9PSIsInZhbHVlIjoiZ2RlOGpYOGw0K0krMWNQR2V1YTVwTHYvOVhsMTNJdnJLc3pNTndtOHBmL1JQQnJ5YmRST0ttSENQbFV3czQvVG9wcUpWUWVsdWowb255cVZRS1BURDEzRG0vdzU5eHdWTUtkOUVOZHYvellnTlgxVTB5bWZUV1FEeVIzMWtyc3QiLCJtYWMiOiJhZmJlZmYwM2M2OTQ1ZTkxMmYxNjYwMWY4MDEzYTdiNjYwNWU1OGVlMDNiNmNlZDkzNmIwNzhhYzE5ZjdlYTFmIiwidGFnIjoiIn0%3D; expires=Sun, 02 Mar 2025 05:24:22 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IklIbDUzS2tmWU1wc2tXZmN4bzVlc0E9PSIsInZhbHVlIjoiZ2RlOGpYOGw0K0krMWNQR2V1YTVwTHYvOVhsMTNJdnJLc3pNTndtOHBmL1JQQnJ5YmRST0ttSENQbFV3czQvVG9wcUpWU" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlNRTjl1N2J4SnNHRjYwQnlMVGRZY0E9PSIsInZhbHVlIjoiY0hOR0hVT25xUFNYL0l6bElEcXVoQ1IrRWl4cmowb2JXTEVBV1IxbWFQV3JHS0lXbGJkcWw0WTNZNE5ySVJMcDdhcjBpb3UvdTFZQ01tbFlJRjNZaHBNcC85eUxmZzZtU2xWeHV2cC94VlNIWDNDWnU2Nkd4L0JKMFkxaytoamMiLCJtYWMiOiIwMWU1MmU5ZDUwNWRlYjQzZmEyMDAwOTc0NjI5ZTdiZWY0MDg1ODhlZGIxZTBkM2RiYWZmYjJiN2VjYmE5MjcyIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6IlNRTjl1N2J4SnNHRjYwQnlMVGRZY0E9PSIsInZhbHVlIjoiY0hOR0hVT25xUFNYL0l6bElEcXVoQ1IrRWl4cmowb2JXTEVBV1IxbWFQV3JHS0lXbGJkcWw0WTN" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IklIbDUzS2tmWU1wc2tXZmN4bzVlc0E9PSIsInZhbHVlIjoiZ2RlOGpYOGw0K0krMWNQR2V1YTVwTHYvOVhsMTNJdnJLc3pNTndtOHBmL1JQQnJ5YmRST0ttSENQbFV3czQvVG9wcUpWUWVsdWowb255cVZRS1BURDEzRG0vdzU5eHdWTUtkOUVOZHYvellnTlgxVTB5bWZUV1FEeVIzMWtyc3QiLCJtYWMiOiJhZmJlZmYwM2M2OTQ1ZTkxMmYxNjYwMWY4MDEzYTdiNjYwNWU1OGVlMDNiNmNlZDkzNmIwNzhhYzE5ZjdlYTFmIiwidGFnIjoiIn0%3D; expires=Sun, 02-Mar-2025 05:24:22 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IklIbDUzS2tmWU1wc2tXZmN4bzVlc0E9PSIsInZhbHVlIjoiZ2RlOGpYOGw0K0krMWNQR2V1YTVwTHYvOVhsMTNJdnJLc3pNTndtOHBmL1JQQnJ5YmRST0ttSENQbFV3czQvVG9wcUpWU" 1 => "alphaeurekaselectnet_session=eyJpdiI6IlNRTjl1N2J4SnNHRjYwQnlMVGRZY0E9PSIsInZhbHVlIjoiY0hOR0hVT25xUFNYL0l6bElEcXVoQ1IrRWl4cmowb2JXTEVBV1IxbWFQV3JHS0lXbGJkcWw0WTNZNE5ySVJMcDdhcjBpb3UvdTFZQ01tbFlJRjNZaHBNcC85eUxmZzZtU2xWeHV2cC94VlNIWDNDWnU2Nkd4L0JKMFkxaytoamMiLCJtYWMiOiIwMWU1MmU5ZDUwNWRlYjQzZmEyMDAwOTc0NjI5ZTdiZWY0MDg1ODhlZGIxZTBkM2RiYWZmYjJiN2VjYmE5MjcyIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6IlNRTjl1N2J4SnNHRjYwQnlMVGRZY0E9PSIsInZhbHVlIjoiY0hOR0hVT25xUFNYL0l6bElEcXVoQ1IrRWl4cmowb2JXTEVBV1IxbWFQV3JHS0lXbGJkcWw0WTN" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "ZauGYtzmY5DVuQk7ePGFGHVNphLS9mGcmE0tUxUA" "uc_cart_id" => "a1a3b434bcd469f65370c3824eb769ed" "_previous" => array:1 [ "url" => "http://alpha.eurekaselect.com/article/99269" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-27 17:24:22GET/article/99269314361