AI in the Social and Business World: A Comprehensive Approach

Unlocking Business Insights: Leveraging the Synergy of Business Intelligence and Artifical Intelligence for Effective Data Analytics

Author(s): Manjushree Nayak* and Ashutosh Pattnaik

Pp: 152-168 (17)

DOI: 10.2174/9789815256864124010009

* (Excluding Mailing and Handling)

Abstract

Nowadays, the market is full of a variety of products for a single item, which makes it very difficult for customers to choose which product is best for them according to their price range. At the same time, it also creates a huge problem for manufacturers and business people to sell their products in this market, with a variety of customers who have different needs and expectations from the products they purchase. One of the most important factors in selling a product is its price and standard, which determine its sales and demand in the market. So, it is most important to sell the product as per the customer's needs and also at a price so that they can afford it. As there is a rapid evolution of technology, it is being used by other sectors to make a profit and also to understand market needs and their performance in the market. So, it is also very necessary to implement the technology in this sector, as it deals with a huge number of customers and is very important for the businessperson to make a huge amount of profit. A business intelligence tool is used, and its purpose is to analyze the market. It collects complete information about a product in a huge quantity, which helps it predict future results more accurately. By applying this tool in business, it predicts the future sale of the product in the market, and if they decide to come up with a new product in the market, what should be the selling price they need to fix for its sale, and how can they increase the demand for that product in the market? One of the biggest advantages of using this tool is that it also predicts the performance of the manufacturer in the market and the different areas they should focus on to improve their productivity. This concludes that using business intelligence in business solves many problems for the manufacturer, starting from analyzing the market to understanding the needs and expectations of the customers. Not only does it help businesses, but it also helps customers so that they can purchase the product that meets their expectations.

Related Books
© 2025 Bentham Science Publishers | Privacy Policy
Request history8.2.27PHP Version200msRequest Duration26MBMemory UsageGET chapter/{id}/{param?}Route
  • warninglog[16:51:51] LOG.warning: Optional parameter $id declared before required parameter $request is implic...
  • Booting (116ms)time
  • Application (84.33ms)time
  • 1 x Booting (57.84%)
    116ms
    1 x Application (42.16%)
    84.33ms
    12 templates were rendered
    • ebook.chapter_detailschapter_details.blade.php#?blade
    • layouts.chapter_header_sectionchapter_header_section.blade.php#?blade
    • ebook.chapter_top_bannerchapter_top_banner.blade.php#?blade
    • ebook.chapter_bottom_bannerchapter_bottom_banner.blade.php#?blade
    • ebook.ebook_right_bannerebook_right_banner.blade.php#?blade
    • includes.inc_related_journalsinc_related_journals.blade.php#?blade
    • includes.inc_related_ebooksinc_related_ebooks.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 chapter/{id}/{param?}
    middleware
    web, check_user_access
    controller
    App\Http\Controllers\ChapterController@GetChapterDetails
    namespace
    App\Http\Controllers
    where
    as
    chapter
    file
    app/Http/Controllers/ChapterController.php:1350-1704
    18 statements were executed26.54ms
    • 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 ('59699349','',1,1740675111,1740675111) ON DUPLICATE KEY UPDATE visitor_count=visitor_count + 1, updated_on=1740675111
      900μsalphaeurekaselec_live_10_06_2022UserAccessCheck.php#24
      Backtrace
      • 11. middleware::check_user_access:24
      • 12. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 13. vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50
      • 14. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • 15. vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:88
    • INSERT INTO visitor_ip_address_detail (ip_address,visitor_url,visitor_count, created_on,updated_on) VALUES ('59699349','/chapter/23447',1,1740675111,1740675111)
      190μ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 >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) 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 >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) 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 >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) 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 >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) 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 >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) 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 >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_trail WHERE to_ip >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_corporate WHERE to_ip >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_issue_token WHERE to_ip >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_trail WHERE to_ip >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_corporate WHERE to_ip >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_article_token WHERE to_ip >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_trail WHERE to_ip >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_corporate WHERE to_ip >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_chapter_token WHERE to_ip >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) union (select `user_id`, `to_ip`, `from_ip` from (select user_id, to_ip, from_ip FROM user_access_disease_corporate WHERE to_ip >= 59699349 ORDER BY to_ip ASC LIMIT 1) as `tjv` where `from_ip` <= 59699349) limit 1
      14.4msalphaeurekaselec_live_10_06_2022UserAccess.php#784
      Bindings
      • 0: 59699349
      • 1: 59699349
      • 2: 59699349
      • 3: 59699349
      • 4: 59699349
      • 5: 59699349
      • 6: 59699349
      • 7: 59699349
      • 8: 59699349
      • 9: 59699349
      • 10: 59699349
      • 11: 59699349
      • 12: 59699349
      • 13: 59699349
      • 14: 59699349
      • 15: 59699349
      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 * from `chapter` where `chapter_id` = '23447' limit 1
      1.04msalphaeurekaselec_live_10_06_2022ChapterController.php#1406
      Bindings
      • 0: 23447
      Backtrace
      • 16. app/Http/Controllers/ChapterController.php:1406
      • 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 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`.`chapter_id` = '23447' group by `au`.`author_id` order by `au`.`article_id` asc, `au`.`sequence` asc
      2.11msalphaeurekaselec_live_10_06_2022Author.php#86
      Bindings
      • 0: 23447
      Backtrace
      • 13. app/Models/Author.php:86
      • 14. app/Http/Controllers/ChapterController.php:1411
      • 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 `keywords` where `chapter_id` = '23447'
      190μsalphaeurekaselec_live_10_06_2022ChapterController.php#1415
      Bindings
      • 0: 23447
      Backtrace
      • 15. app/Http/Controllers/ChapterController.php:1415
      • 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
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select * from `ebook` where `ebook_id` = 1417 limit 1
      200μsalphaeurekaselec_live_10_06_2022ChapterController.php#1430
      Bindings
      • 0: 1417
      Backtrace
      • 16. app/Http/Controllers/ChapterController.php:1430
      • 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 count(*) as aggregate 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` = `e`.`ebook_id` where subject_id IN (select subject_id FROM subject_ebook WHERE ebook_id=1417) and se.ebook_id!=1417 and v.ebook_status='1'
      660μsalphaeurekaselec_live_10_06_2022Subject.php#238
      Backtrace
      • 16. app/Models/Subject.php:238
      • 17. app/Http/Controllers/ChapterController.php:1434
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select distinct 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` = `e`.`ebook_id` where subject_id IN (select subject_id FROM subject_ebook WHERE ebook_id=1417) and se.ebook_id!=1417 and v.ebook_status='1' limit 10 offset 0
      700μsalphaeurekaselec_live_10_06_2022Subject.php#238
      Backtrace
      • 14. app/Models/Subject.php:238
      • 15. app/Http/Controllers/ChapterController.php:1434
      • 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 count(*) as aggregate from `subject_journal` as `sj` inner join `journal` as `j` on `j`.`journal_id` = `sj`.`journal_id` where subject_id IN (select subject_id FROM subject_ebook WHERE ebook_id=1417)
      390μsalphaeurekaselec_live_10_06_2022Subject.php#255
      Backtrace
      • 16. app/Models/Subject.php:255
      • 17. app/Http/Controllers/ChapterController.php:1435
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `e`.*, `a`.*, `y`.`year`, `e`.`ebook_volume_id` as `ebook_volume_id`, `a`.`ebook_volume_id` as `ebk_vol_id`, `e`.`ebook_id` as `ebk_ebook_id` from `ebook_volume` as `e` left join `author` as `a` on `e`.`ebook_volume_id` = `a`.`ebook_volume_id` left join `year` as `y` on `y`.`id` = `e`.`year_id` where `e`.`ebook_volume_id` = 3782 and `e`.`is_uploaded` = 1
      2.28msalphaeurekaselec_live_10_06_2022EbookVolume.php#271
      Bindings
      • 0: 3782
      • 1: 1
      Backtrace
      • 13. app/Models/EbookVolume.php:271
      • 14. app/Http/Controllers/ChapterController.php:1438
      • 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(*) rcd from `ebook_volume` where `ebook_id` = 1417 and ebook_volume_id <> 3782 limit 1
      270μsalphaeurekaselec_live_10_06_2022EbookVolume.php#999
      Bindings
      • 0: 1417
      Backtrace
      • 14. app/Models/EbookVolume.php:999
      • 15. app/Http/Controllers/ChapterController.php:1462
      • 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 count(*) as total_count, content_type_access_id as access_type from ebook_access where content_type_id = '23447' and content_type = 'c' and ( (from_date <= CURDATE() and to_date >= CURDATE() and perpetual= 0) or (from_date is null and to_date is null and perpetual= 1) )
      330μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ChapterController.php:1465
      • 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 ebook_access where content_type_id = '3782' 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) )
      300μsalphaeurekaselec_live_10_06_2022ContentAccess.php#647
      Backtrace
      • 11. app/Models/ContentAccess.php:647
      • 12. app/Http/Controllers/ChapterController.php:1478
      • 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,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59699349 and j.to_ip >=59699349 )) and ((j.from_date <= 1740675111 and j.to_date >= 1740675111 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3782) 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,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59699349 and j.to_ip >=59699349 )) and ((j.from_date <= 1740675111 and j.to_date >= 1740675111 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3782) 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,"ebook_volume" as access_level,"" as chapter_id from `user_access_ebook_volume_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59699349 and j.to_ip >=59699349 )) and ((j.from_date <= 1740675111 and j.to_date >= 1740675111 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.volume_id = 3782)
      640μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ChapterController.php:1518
      • 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,"chapter" as access_level, j.chapter_id from `user_access_chapter_trail` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59699349 and j.to_ip >=59699349 )) and ((j.from_date <= 1740675111 and j.to_date >= 1740675111 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 23447) 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,"chapter" as access_level, j.chapter_id from `user_access_chapter_corporate` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59699349 and j.to_ip >=59699349 )) and ((j.from_date <= 1740675111 and j.to_date >= 1740675111 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 23447) 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,"chapter" as access_level, j.chapter_id from `user_access_chapter_token` as `j` inner join `user_access_info` as `info` on `j`.`user_access_id` = `info`.`user_access_id` where ((j.from_ip <= 59699349 and j.to_ip >=59699349 )) and ((j.from_date <= 1740675111 and j.to_date >= 1740675111 and j.perpetual= 0) or (j.from_date is null and j.to_date is null and j.perpetual= 1)) and j.chapter_id = 23447)
      600μsalphaeurekaselec_live_10_06_2022UserAccess.php#1266
      Backtrace
      • 13. app/Models/UserAccess/UserAccess.php:1266
      • 14. app/Http/Controllers/ChapterController.php:1549
      • 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 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` where `b`.`banner_ebook` = 1 and `bd`.`content_type` = 'B' and `bd`.`content_id` = 3782 and `b`.`banner_from_date` <= 1740675111 and `b`.`banner_to_date` >= 1740675111 and `b`.`banner_status` = 'A' order by `b`.`banner_id` desc
      1.09msalphaeurekaselec_live_10_06_2022Banner.php#95
      Bindings
      • 0: 1
      • 1: B
      • 2: 3782
      • 3: 1740675111
      • 4: 1740675111
      • 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='8a719b38fa60e8ac78aa1c7fa4b3c6fd'
      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\Chapter
    1Chapter.php#?
    App\Models\Ebook
    1Ebook.php#?
        _token
        wNlvID1X5FXEi4xzIoeqSA76Zzlp0F87myEfbKqr
        uc_cart_id
        8a719b38fa60e8ac78aa1c7fa4b3c6fd
        _previous
        array:1 [ "url" => "https://alpha.eurekaselect.com/chapter/23447" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /chapter/23447
        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=eyJpdiI6ImZFbHpxSG9NTVFjTldnem5pczVuamc9PSIsInZhbHVlIjoiV0VKMEZNak0rU2FSempvQUpkTUEzVXIxKytabGlZQU03OHErampPd2dDUT0iLCJtYWMiOiJlZTk5YTYwZWFjMWRiZDFhODU5NGEyMjIyNGE4NTIyZWVlNWVjZmExNDQ0N2RhM2EwMTg5YmE4YWEwYzQ3YTA1IiwidGFnIjoiIn0%3Dwayfindertarget=eyJpdiI6ImZFbHpxSG9NTVFjTldnem5pczVuamc9PSIsInZhbHVlIjoiV0VKMEZNak0rU2FSempvQUpkTUEzVXIxKytabGlZQU03OHErampPd2dDUT0iLCJtYWMiOiJlZTk5YTYwZWFjMWRi" ] "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:1 [ "wayfindertarget" => null ]
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Thu, 27 Feb 2025 16:51:51 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ilc3U1pGUVE2US9RbnJJTjJ1OVArTWc9PSIsInZhbHVlIjoia083VEE1TWtyT3ZVaVhzSm1Xbk5JQ3l1K3NIMFFwWmt3S2wrSit1cUtXWUlyS2JwY0FVTnBSdVVPV05ueSsybFBBV0J0eURDRWo5SEoyRjJBcXBtSUY5VWxwS25pQk1jRFRkakFrVlRsMlE4ZGlJSWVhMTQzOUxNeDg0M1hLcXgiLCJtYWMiOiJiY2JiNzQ5MjVjZTA5MDVlOGE2NTNhOGFmZTVkNDNiZjU3MzQ4NzhmM2RjMTQ2OWFkYjhlNjFlYmM4MjMzY2NmIiwidGFnIjoiIn0%3D; expires=Sun, 02 Mar 2025 04:51:51 GMT; Max-Age=216000; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ilc3U1pGUVE2US9RbnJJTjJ1OVArTWc9PSIsInZhbHVlIjoia083VEE1TWtyT3ZVaVhzSm1Xbk5JQ3l1K3NIMFFwWmt3S2wrSit1cUtXWUlyS2JwY0FVTnBSdVVPV05ueSsybFBBV0J0e" 1 => "alphaeurekaselectnet_session=eyJpdiI6InlzeEx5a0JrUHZ1anN2bUliTFhNc0E9PSIsInZhbHVlIjoiZWdBbnNkZ3pPWFhmS2hpSmZCSTZvZkRUSmhOZ0o1enpRdzRTYUZ5Qmh5NG4rOCtseHNvYXNaRERiVFA2MDBjRHFYTE15UjFIbGhWSTJuWVNVQVhTbDhXQzFaOE9LWnV0WGFuQmQwQzFWc1ZCYXphNUhSaklRNHlmTllHM0hGTnIiLCJtYWMiOiI1NjNmZWFhNzliMDQ3MjBiOGUyYjYwNjY0MWMwMzI5NDk0ZGUwMjcyN2M5NWM0YmIxMDIzNGNlYjZhZGY0Y2JiIiwidGFnIjoiIn0%3D; path=/; secure; httponly; samesite=laxalphaeurekaselectnet_session=eyJpdiI6InlzeEx5a0JrUHZ1anN2bUliTFhNc0E9PSIsInZhbHVlIjoiZWdBbnNkZ3pPWFhmS2hpSmZCSTZvZkRUSmhOZ0o1enpRdzRTYUZ5Qmh5NG4rOCtseHNvYXNaRER" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ilc3U1pGUVE2US9RbnJJTjJ1OVArTWc9PSIsInZhbHVlIjoia083VEE1TWtyT3ZVaVhzSm1Xbk5JQ3l1K3NIMFFwWmt3S2wrSit1cUtXWUlyS2JwY0FVTnBSdVVPV05ueSsybFBBV0J0eURDRWo5SEoyRjJBcXBtSUY5VWxwS25pQk1jRFRkakFrVlRsMlE4ZGlJSWVhMTQzOUxNeDg0M1hLcXgiLCJtYWMiOiJiY2JiNzQ5MjVjZTA5MDVlOGE2NTNhOGFmZTVkNDNiZjU3MzQ4NzhmM2RjMTQ2OWFkYjhlNjFlYmM4MjMzY2NmIiwidGFnIjoiIn0%3D; expires=Sun, 02-Mar-2025 04:51:51 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ilc3U1pGUVE2US9RbnJJTjJ1OVArTWc9PSIsInZhbHVlIjoia083VEE1TWtyT3ZVaVhzSm1Xbk5JQ3l1K3NIMFFwWmt3S2wrSit1cUtXWUlyS2JwY0FVTnBSdVVPV05ueSsybFBBV0J0e" 1 => "alphaeurekaselectnet_session=eyJpdiI6InlzeEx5a0JrUHZ1anN2bUliTFhNc0E9PSIsInZhbHVlIjoiZWdBbnNkZ3pPWFhmS2hpSmZCSTZvZkRUSmhOZ0o1enpRdzRTYUZ5Qmh5NG4rOCtseHNvYXNaRERiVFA2MDBjRHFYTE15UjFIbGhWSTJuWVNVQVhTbDhXQzFaOE9LWnV0WGFuQmQwQzFWc1ZCYXphNUhSaklRNHlmTllHM0hGTnIiLCJtYWMiOiI1NjNmZWFhNzliMDQ3MjBiOGUyYjYwNjY0MWMwMzI5NDk0ZGUwMjcyN2M5NWM0YmIxMDIzNGNlYjZhZGY0Y2JiIiwidGFnIjoiIn0%3D; path=/; secure; httponlyalphaeurekaselectnet_session=eyJpdiI6InlzeEx5a0JrUHZ1anN2bUliTFhNc0E9PSIsInZhbHVlIjoiZWdBbnNkZ3pPWFhmS2hpSmZCSTZvZkRUSmhOZ0o1enpRdzRTYUZ5Qmh5NG4rOCtseHNvYXNaRER" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "wNlvID1X5FXEi4xzIoeqSA76Zzlp0F87myEfbKqr" "uc_cart_id" => "8a719b38fa60e8ac78aa1c7fa4b3c6fd" "_previous" => array:1 [ "url" => "https://alpha.eurekaselect.com/chapter/23447" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-02-27 16:51:51GET/chapter/23447112182