etickets.ca
Please enter search value

PNC Park

Explore Events

eTickets 100% Ticket Guarantee

Our commitment to our valued customers is unwavering, and we've designed our ticketing service with you in mind. We offer a 100% Ticket Guarantee to ensure your ticket-buying experience is seamless and stress-free.

100% verified tickets
100% verified tickets
Your seats will be together
Your seats will be together
Tickets will arrive on time
Tickets will arrive on time
100% authentic tickets
100% authentic tickets
Safe & Secured transaction
Safe & Secured transaction
Safe & Secured transaction
You will get the seats you choose or better
Load More
Messages42TimelineExceptionsViews9RouteQueries14Models4642AuthGateSessionRequest
8.1.27PHP Version1.72sRequest Duration48MBMemory UsageGET {slug}RouteAuth status
  • warninglog[15:23:31] LOG.warning: Calling static trait method App\Http\Traits\slug::resolve_alias_for_routes i...
  • warninglog[15:23:32] LOG.warning: Calling static trait method App\Http\Traits\slug::resolve_alias_for_routes i...
  • warninglog[15:23:32] LOG.warning: Calling static trait method App\Http\Traits\slug::resolve_alias is deprecate...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[15:23:32] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[15:23:32] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[15:23:32] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[15:23:32] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[15:23:32] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[15:23:32] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[15:23:32] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[15:23:32] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[15:23:32] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[15:23:32] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[15:23:32] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[15:23:32] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[15:23:32] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[15:23:32] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[15:23:32] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $catid is i...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $pcatid is ...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $pcatid is ...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $pcatid is ...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $catid is i...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $catid is i...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $catid is i...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $venueId is...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $data is im...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $venueId is...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $data is im...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $catid is i...
  • warninglog[15:23:32] LOG.warning: Optional parameter $filterArr declared before required parameter $catid is i...
  • warninglog[15:23:32] LOG.warning: Optional parameter $date declared before required parameter $search is impli...
  • warninglog[15:23:33] LOG.warning: str_contains(): Passing null to parameter #1 ($haystack) of type string is d...
  • warninglog[15:23:33] LOG.warning: str_contains(): Passing null to parameter #1 ($haystack) of type string is d...
  • warninglog[15:23:33] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[15:23:33] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
warning
  • Booting (416ms)
  • Application (1.3s)
  • 1 x Application (75.72%)
    1.30s
    1 x Booting (24.27%)
    416.50ms
    9 templates were rendered
    • venue-events-view (resources/views/venue-events-view.blade.php)6bladefile
      Params
      0
      venueData
      1
      venueEventData
      2
      getVenueEventCount
      3
      isCategoryId
      4
      detailPageTitle
      5
      metaInfo
    • layouts.inner_banner (resources/views/layouts/inner_banner.blade.php)30bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      CitiesMenu
      8
      footerMenu
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      PAGE_ID
      13
      META_TITLE
      14
      META_KEYWORD
      15
      META_DESCRIPTION
      16
      PAGE_CONTENT
      17
      PAGE_CONTENT_BOTTOM
      18
      APP_URL
      19
      SHARE_IMG
      20
      VIEWING_PREVIEW
      21
      ADVERTISE_BANNER_IMG
      22
      errors
      23
      selectmenu
      24
      venueData
      25
      venueEventData
      26
      getVenueEventCount
      27
      isCategoryId
      28
      detailPageTitle
      29
      metaInfo
    • venue-event-list (resources/views/venue-event-list.blade.php)30bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      CitiesMenu
      8
      footerMenu
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      PAGE_ID
      13
      META_TITLE
      14
      META_KEYWORD
      15
      META_DESCRIPTION
      16
      PAGE_CONTENT
      17
      PAGE_CONTENT_BOTTOM
      18
      APP_URL
      19
      SHARE_IMG
      20
      VIEWING_PREVIEW
      21
      ADVERTISE_BANNER_IMG
      22
      errors
      23
      selectmenu
      24
      venueData
      25
      venueEventData
      26
      getVenueEventCount
      27
      isCategoryId
      28
      detailPageTitle
      29
      metaInfo
    • right_side_adv (resources/views/right_side_adv.blade.php)30bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      CitiesMenu
      8
      footerMenu
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      PAGE_ID
      13
      META_TITLE
      14
      META_KEYWORD
      15
      META_DESCRIPTION
      16
      PAGE_CONTENT
      17
      PAGE_CONTENT_BOTTOM
      18
      APP_URL
      19
      SHARE_IMG
      20
      VIEWING_PREVIEW
      21
      ADVERTISE_BANNER_IMG
      22
      errors
      23
      selectmenu
      24
      venueData
      25
      venueEventData
      26
      getVenueEventCount
      27
      isCategoryId
      28
      detailPageTitle
      29
      metaInfo
    • layouts.app (resources/views/layouts/app.blade.php)35bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      CitiesMenu
      8
      footerMenu
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      PAGE_ID
      13
      META_TITLE
      14
      META_KEYWORD
      15
      META_DESCRIPTION
      16
      PAGE_CONTENT
      17
      PAGE_CONTENT_BOTTOM
      18
      APP_URL
      19
      SHARE_IMG
      20
      VIEWING_PREVIEW
      21
      ADVERTISE_BANNER_IMG
      22
      errors
      23
      selectmenu
      24
      venueData
      25
      venueEventData
      26
      getVenueEventCount
      27
      isCategoryId
      28
      detailPageTitle
      29
      metaInfo
      30
      seg1
      31
      seg3
      32
      seg2
      33
      substring
      34
      title
    • layouts.header (resources/views/layouts/header.blade.php)40bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      CitiesMenu
      8
      footerMenu
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      PAGE_ID
      13
      META_TITLE
      14
      META_KEYWORD
      15
      META_DESCRIPTION
      16
      PAGE_CONTENT
      17
      PAGE_CONTENT_BOTTOM
      18
      APP_URL
      19
      SHARE_IMG
      20
      VIEWING_PREVIEW
      21
      ADVERTISE_BANNER_IMG
      22
      errors
      23
      selectmenu
      24
      venueData
      25
      venueEventData
      26
      getVenueEventCount
      27
      isCategoryId
      28
      detailPageTitle
      29
      metaInfo
      30
      seg1
      31
      seg3
      32
      seg2
      33
      substring
      34
      title
      35
      requestedFullUrl
      36
      homePageUrl
      37
      seg
      38
      encodedSeg
      39
      d_class
    • layouts.header_main (resources/views/layouts/header_main.blade.php)40bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      CitiesMenu
      8
      footerMenu
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      PAGE_ID
      13
      META_TITLE
      14
      META_KEYWORD
      15
      META_DESCRIPTION
      16
      PAGE_CONTENT
      17
      PAGE_CONTENT_BOTTOM
      18
      APP_URL
      19
      SHARE_IMG
      20
      VIEWING_PREVIEW
      21
      ADVERTISE_BANNER_IMG
      22
      errors
      23
      selectmenu
      24
      venueData
      25
      venueEventData
      26
      getVenueEventCount
      27
      isCategoryId
      28
      detailPageTitle
      29
      metaInfo
      30
      seg1
      31
      seg3
      32
      seg2
      33
      substring
      34
      title
      35
      requestedFullUrl
      36
      homePageUrl
      37
      seg
      38
      encodedSeg
      39
      d_class
    • layouts.footer_main (resources/views/layouts/footer_main.blade.php)40bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      CitiesMenu
      8
      footerMenu
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      PAGE_ID
      13
      META_TITLE
      14
      META_KEYWORD
      15
      META_DESCRIPTION
      16
      PAGE_CONTENT
      17
      PAGE_CONTENT_BOTTOM
      18
      APP_URL
      19
      SHARE_IMG
      20
      VIEWING_PREVIEW
      21
      ADVERTISE_BANNER_IMG
      22
      errors
      23
      selectmenu
      24
      venueData
      25
      venueEventData
      26
      getVenueEventCount
      27
      isCategoryId
      28
      detailPageTitle
      29
      metaInfo
      30
      seg1
      31
      seg3
      32
      seg2
      33
      substring
      34
      title
      35
      requestedFullUrl
      36
      homePageUrl
      37
      seg
      38
      encodedSeg
      39
      d_class
    • layouts.footer (resources/views/layouts/footer.blade.php)40bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      CitiesMenu
      8
      footerMenu
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      PAGE_ID
      13
      META_TITLE
      14
      META_KEYWORD
      15
      META_DESCRIPTION
      16
      PAGE_CONTENT
      17
      PAGE_CONTENT_BOTTOM
      18
      APP_URL
      19
      SHARE_IMG
      20
      VIEWING_PREVIEW
      21
      ADVERTISE_BANNER_IMG
      22
      errors
      23
      selectmenu
      24
      venueData
      25
      venueEventData
      26
      getVenueEventCount
      27
      isCategoryId
      28
      detailPageTitle
      29
      metaInfo
      30
      seg1
      31
      seg3
      32
      seg2
      33
      substring
      34
      title
      35
      requestedFullUrl
      36
      homePageUrl
      37
      seg
      38
      encodedSeg
      39
      d_class
    uri
    GET {slug}
    middleware
    web
    controller
    App\Http\Controllers\HomeController@redirectrule
    namespace
    prefix
    where
    file
    app/Http/Controllers/HomeController.php:34-115
    14 statements were executed, 8 of which were duplicated, 6 unique. Show only duplicated1.16s
    etickets_live
    • select `nq_menu`.`id`, `intParentMenuId`, `intItemOrder`, `intParentItemOrder`, `chrInMobile`, `chrInWeb`, `intAliasId`, `intPageId`, `varTitle`, `txtPageUrl`, `intPosition`, `chrActive`, `chrDisplayFront`, `chrMegaMenu`, `chrDelete`, `chrPublish`, `chrNewTab`, `intfkMegaMenuId` from `nq_menu` where `intFkSiteid` = 1 and (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`chrActive` = 'Y') and `chrInWeb` = 'Y' order by `intPosition` asc, `intParentItemOrder` asc, `intItemOrder` asc4.29ms/packages/Powerpanel/Menu/src/Models/Menu.php:228etickets_live
      Metadata
      Bindings
      • 0. 1
      • 1. N
      • 2. Y
      • 3. Y
      • 4. Y
      Backtrace
      • 14. /packages/Powerpanel/Menu/src/Models/Menu.php:228
      • 15. /app/Http/Controllers/FrontController.php:69
      • 16. /app/Http/Controllers/FrontController.php:59
      • 17. /app/Http/Controllers/HomeController.php:31
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:952
    • select `id`, `varTitle` from `nq_menu_type` where `nq_menu_type`.`id` in (1, 3, 4, 5, 6) and `chrPublish` = 'Y' and (`chrDelete` = 'N')1.07ms/packages/Powerpanel/Menu/src/Models/Menu.php:228etickets_live
      Metadata
      Bindings
      • 0. Y
      • 1. N
      Backtrace
      • 19. /packages/Powerpanel/Menu/src/Models/Menu.php:228
      • 20. /app/Http/Controllers/FrontController.php:69
      • 21. /app/Http/Controllers/FrontController.php:59
      • 22. /app/Http/Controllers/HomeController.php:31
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:952
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'pnc-park-tickets' and `intFkModuleCode` = 3 and `intFkSiteid` = 1 limit 113.46ms/app/Alias.php:60etickets_live
      Metadata
      Bindings
      • 0. pnc-park-tickets
      • 1. 3
      • 2. 1
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:60
      • 16. /app/Http/Traits/slug.php:36
      • 17. /app/Http/Controllers/FrontController.php:545
      • 18. /app/Http/Controllers/FrontController.php:61
      • 19. /app/Http/Controllers/HomeController.php:31
    • select `id`, `varTitle`, `varEmail`, `varPhoneNo`, `varEmergencyPhoneNo`, `varCustomerServicePhoneNo`, `varFax`, `txtDescription`, `intDisplayOrder`, `fkIntImgId`, `txtAddress`, `mailingaddress`, `varOpeningHours`, `chrLatitude`, `chrLongitude`, `chrIsPrimary`, `chrPublish`, `chrDelete`, `created_at`, `updated_at` from `nq_contact_info` where `intFkSiteid` = 1 and (`chrDelete` = 'N') and (`chrPublish` = 'Y')670μs/packages/Powerpanel/ContactInfo/src/Models/ContactInfo.php:82etickets_live
      Metadata
      Bindings
      • 0. 1
      • 1. N
      • 2. Y
      Backtrace
      • 14. /packages/Powerpanel/ContactInfo/src/Models/ContactInfo.php:82
      • 15. /app/Http/Controllers/FrontController.php:586
      • 16. /app/Http/Controllers/FrontController.php:61
      • 17. /app/Http/Controllers/HomeController.php:31
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:952
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'pnc-park-tickets' limit 12.23ms/app/Alias.php:44etickets_live
      Metadata
      Bindings
      • 0. pnc-park-tickets
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:44
      • 16. /app/Http/Controllers/HomeController.php:51
      • 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
    • select `nq_menu`.`id`, `intParentMenuId`, `intItemOrder`, `intParentItemOrder`, `chrInMobile`, `chrInWeb`, `intAliasId`, `intPageId`, `varTitle`, `txtPageUrl`, `intPosition`, `chrActive`, `chrDisplayFront`, `chrMegaMenu`, `chrDelete`, `chrPublish`, `chrNewTab`, `intfkMegaMenuId` from `nq_menu` where `intFkSiteid` = 1 and (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`chrActive` = 'Y') and `chrInWeb` = 'Y' order by `intPosition` asc, `intParentItemOrder` asc, `intItemOrder` asc8.54ms/packages/Powerpanel/Menu/src/Models/Menu.php:228etickets_live
      Metadata
      Bindings
      • 0. 1
      • 1. N
      • 2. Y
      • 3. Y
      • 4. Y
      Backtrace
      • 14. /packages/Powerpanel/Menu/src/Models/Menu.php:228
      • 15. /app/Http/Controllers/FrontController.php:69
      • 16. /app/Http/Controllers/FrontController.php:59
      • 17. /app/Http/Controllers/ListingController.php:26
      • 18. /app/Http/Controllers/HomeController.php:101
    • select `id`, `varTitle` from `nq_menu_type` where `nq_menu_type`.`id` in (1, 3, 4, 5, 6) and `chrPublish` = 'Y' and (`chrDelete` = 'N')4.22ms/packages/Powerpanel/Menu/src/Models/Menu.php:228etickets_live
      Metadata
      Bindings
      • 0. Y
      • 1. N
      Backtrace
      • 19. /packages/Powerpanel/Menu/src/Models/Menu.php:228
      • 20. /app/Http/Controllers/FrontController.php:69
      • 21. /app/Http/Controllers/FrontController.php:59
      • 22. /app/Http/Controllers/ListingController.php:26
      • 23. /app/Http/Controllers/HomeController.php:101
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'pnc-park-tickets' and `intFkModuleCode` = 3 and `intFkSiteid` = 1 limit 12.58ms/app/Alias.php:60etickets_live
      Metadata
      Bindings
      • 0. pnc-park-tickets
      • 1. 3
      • 2. 1
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:60
      • 16. /app/Http/Traits/slug.php:36
      • 17. /app/Http/Controllers/FrontController.php:545
      • 18. /app/Http/Controllers/FrontController.php:61
      • 19. /app/Http/Controllers/ListingController.php:26
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'pnc-park-tickets' limit 18.89ms/app/Alias.php:44etickets_live
      Metadata
      Bindings
      • 0. pnc-park-tickets
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:44
      • 16. /app/Http/Traits/slug.php:24
      • 17. /app/Http/Controllers/ListingController.php:152
      • 18. /app/Http/Controllers/HomeController.php:102
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `venueId`, `varTitle` from `nq_venue` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `intAliasId` = 51348 limit 11.54ms/packages/Powerpanel/Venue/src/Models/Venue.php:740etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. Y
      • 2. 51348
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /packages/Powerpanel/Venue/src/Models/Venue.php:740
      • 16. /app/Http/Controllers/ListingController.php:153
      • 17. /app/Http/Controllers/HomeController.php:102
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `id`, `fkeventGlcode`, `VarDisplayDate`, `varTitle`, `intParentCatId`, `intChildCatId`, `intGrandChildCatId`, `varStateProvince`, `varPrice`, `intStateProvinceID`, `varCity`, `varVenue`, `intVenueConfigurationID`, `intVenueID`, `dtEventDate`, `intCountryID` from `nq_events` where `dtEventDate` between '2025-04-17 15:23:32' and '2025-12-31 23:59:59' and `intVenueID` = 73 order by `dtEventDate` asc limit 12296ms/app/Events.php:598etickets_live
      Metadata
      Bindings
      • 0. 2025-04-17 15:23:32
      • 1. 2025-12-31 23:59:59
      • 2. 73
      Backtrace
      • 14. /app/Events.php:598
      • 15. /app/Http/Controllers/ListingController.php:155
      • 16. /app/Http/Controllers/HomeController.php:102
      • 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 `nq_events` where `dtEventDate` between '2025-04-17 15:23:32' and '2025-12-31 23:59:59' and `intVenueID` = 73773ms/app/Events.php:679etickets_live
      Metadata
      Bindings
      • 0. 2025-04-17 15:23:32
      • 1. 2025-12-31 23:59:59
      • 2. 73
      Backtrace
      • 15. /app/Events.php:679
      • 16. /app/Http/Controllers/ListingController.php:156
      • 17. /app/Http/Controllers/HomeController.php:102
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `varCity` from `nq_events` group by `varCity`34.68ms/app/Http/Controllers/ListingController.php:157etickets_live
      Metadata
      Hints
      • The SELECT statement has no WHERE clause and could examine many more rows than intended
      Backtrace
      • 14. /app/Http/Controllers/ListingController.php:157
      • 15. /app/Http/Controllers/HomeController.php:102
      • 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 `id`, `intAliasId`, `venueId`, `varTitle`, `varCity`, `varState`, `varCountry`, `varCapacity`, `varAddress`, `varZipcode`, `varURL`, `varBoxOfficePhone`, `chrPublish`, `chrDelete`, `created_at`, `updated_at` from `nq_venue` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `intAliasId` = 51348 limit 17.23ms/packages/Powerpanel/Venue/src/Models/Venue.php:763etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. Y
      • 2. 51348
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /packages/Powerpanel/Venue/src/Models/Venue.php:763
      • 16. /app/Http/Controllers/ListingController.php:166
      • 17. /app/Http/Controllers/HomeController.php:102
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    App\Events
    4033
    Powerpanel\Venue\Models\Venue
    2
    App\Alias
    2
    Powerpanel\ContactInfo\Models\ContactInfo
    1
    Powerpanel\Menu\Models\MenuType
    10
    Powerpanel\Menu\Models\Menu
    594
    web
    null
    front-user
    null
    api
    null
    sanctum
    null
      _token
      j1piP4j8eknaIGqum4u3jIGYGDGhrN4ZJe7bKtjd
      PHPDEBUGBAR_STACK_DATA
      []
      path_info
      /pnc-park-tickets
      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:21 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "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"
  ]
  "x-amzn-trace-id" => array:1 [▶
    0 => "Root=1-68016343-7947f73369546a7e6df1a9ff"
  ]
  "host" => array:1 [▶
    0 => "www.etickets.ca"
  ]
  "x-forwarded-port" => array:1 [▶
    0 => "443"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.219.215.35"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]
      request_server
        0 of 0   
      array:45 [▼
  "USER" => "nobody"
  "HOME" => "/"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "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"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_X_AMZN_TRACE_ID" => "Root=1-68016343-7947f73369546a7e6df1a9ff"
  "HTTP_HOST" => "www.etickets.ca"
  "HTTP_X_FORWARDED_PORT" => "443"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "18.219.215.35"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "etickets.ca"
  "SERVER_PORT" => "80"
  "SERVER_ADDR" => "172.17.0.10"
  "REMOTE_PORT" => "11716"
  "REMOTE_ADDR" => "172.16.0.198"
  "SERVER_SOFTWARE" => "nginx/1.24.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REQUEST_SCHEME" => "http"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "DOCUMENT_ROOT" => "/var/www/html/public_html"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/pnc-park-tickets"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "SCRIPT_NAME" => "/index.php"
  "SCRIPT_FILENAME" => "/var/www/html/public_html/index.php"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744921411.5011
  "REQUEST_TIME" => 1744921411
  "HTTPS" => true
]
      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, 17 Apr 2025 20:23:33 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjI4UkdjdVRQZGJTQmpnaGprbDUzeEE9PSIsInZhbHVlIjoiMVZRTjZIZnBacU0xd3Y3dGJRUXg3YTVSNFJXV2VPTTFDSW8zbHlheHRLOXFGUktSTEFZMVF3UThnZlRiQUxQeHNEdy9DZWpnWGhUanE5NHBxdU9zUERBZncrZTFIU2VOZTAxSDhIbU01VVRFUE1pUHUvRWNOSDc4QzdQZXluOGciLCJtYWMiOiIyYWIwYWNlZmQzMWRiNTRhMzM3NDQ1NjRmYmM0YjhjYjk4MTYzZjk3N2JmZTU0NDM0ZGUxMjYzZTNlMDBmZDViIiwidGFnIjoiIn0%3D; expires=Thu, 17 Apr 2025 22:23:33 GMT; Max-Age=7200; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjI4UkdjdVRQZGJTQmpnaGprbDUzeEE9PSIsInZhbHVlIjoiMVZRTjZIZnBacU0xd3Y3dGJRUXg3YTVSNFJXV2VPTTFDSW8zbHlheHRLOXFGUktSTEFZMVF3UThnZlRiQUxQeHNEdy9DZ ▶"
    1 => "recently_viewed=cWXxRq6mivOFYPHn5IUh; expires=Fri, 18 Apr 2025 20:23:31 GMT; Max-Age=86398; path=/; secure; httponly"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjI4UkdjdVRQZGJTQmpnaGprbDUzeEE9PSIsInZhbHVlIjoiMVZRTjZIZnBacU0xd3Y3dGJRUXg3YTVSNFJXV2VPTTFDSW8zbHlheHRLOXFGUktSTEFZMVF3UThnZlRiQUxQeHNEdy9DZWpnWGhUanE5NHBxdU9zUERBZncrZTFIU2VOZTAxSDhIbU01VVRFUE1pUHUvRWNOSDc4QzdQZXluOGciLCJtYWMiOiIyYWIwYWNlZmQzMWRiNTRhMzM3NDQ1NjRmYmM0YjhjYjk4MTYzZjk3N2JmZTU0NDM0ZGUxMjYzZTNlMDBmZDViIiwidGFnIjoiIn0%3D; expires=Thu, 17-Apr-2025 22:23:33 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjI4UkdjdVRQZGJTQmpnaGprbDUzeEE9PSIsInZhbHVlIjoiMVZRTjZIZnBacU0xd3Y3dGJRUXg3YTVSNFJXV2VPTTFDSW8zbHlheHRLOXFGUktSTEFZMVF3UThnZlRiQUxQeHNEdy9DZ ▶"
    1 => "recently_viewed=cWXxRq6mivOFYPHn5IUh; expires=Fri, 18-Apr-2025 20:23:31 GMT; path=/; secure; httponly"
  ]
]
      session_attributes
        0 of 0   
      array:2 [▼
  "_token" => "j1piP4j8eknaIGqum4u3jIGYGDGhrN4ZJe7bKtjd"
  "PHPDEBUGBAR_STACK_DATA" => []
]