Please enter search value

Scrooge The Musical Tickets

Explore Scrooge The Musical Events

Enable location services to discover Scrooge the musical events near you.

Upcoming Scrooge The Musical Tickets & Tour Schedule

It looks like there are no Scrooge The Musical events available. You might be interested in other activities on our site, or consider widening your search range.

Discover Similar Events

May 23
10:30 AM
Today
Buffalo Philharmonic Orchestra: Bradley Thachuk - Patriotic Pops
Buffalo
Kleinhans Music Hall
See Tickets
May 23
11:00 AM
Today
Jacksonville Symphony: Kevin Fitzgerald - At The Ballet
Jacksonville
Jacoby Symphony Hall At Jacksonville Center for the Performing Arts
See Tickets
May 23
1:00 PM
Today
Bank of America Chamber Music: Happy Days Are Here Again
Charleston
Dock Street Theatre
See Tickets
May 23
2:00 PM
Today
Glenn Miller Orchestra
Wabash
Eagles Theatre At Honeywell Center
See Tickets
May 23
2:00 PM
Today
Ode To Joy: Beethoven's Ninth Symphony
Philadelphia
Marian Anderson Hall at The Kimmel Center
See Tickets
May 23
2:00 PM
Today
New York Philharmonic: Gustavo Dudamel - Stravinsky, Glass & Soper
New York
David Geffen Hall at Lincoln Center
See Tickets
May 23
7:00 PM
Today
Kansas City Symphony: Jaws in Concert
Kansas City
Helzberg Hall - Kauffman Center for the Performing Arts
See Tickets
May 23
7:00 PM
Today
Quartet For The End Of Time
Colorado Springs
Ent Center For The Arts
See Tickets
May 23
7:00 PM
Today
Colorado Symphony: The Lord of the Rings: The Fellowship of the Ring – In Concert
Denver
Boettcher Concert Hall
See Tickets
May 23
7:00 PM
Today
Vancouver Symphony Orchestra
Vancouver
Orpheum Theatre - Vancouver
See Tickets
May 23
7:30 PM
Today
Milwaukee Symphony Orchestra: Byron Stripling - Let's Groove Tonight
Milwaukee
Bradley Symphony Center
See Tickets
May 23
7:30 PM
Today
Concert Artists International Winners Concert
New York
Carnegie Hall - Joan & Sanford I. Weill Recital Hall
See Tickets

Similar Performers

Scrooge The Musical Tickets

Experience the Thrill of Live Concerts with etickets.ca

Your Gateway to Unforgettable Concerts Event

etickets.ca takes pride in offering you a seamless way to witness the electrifying performance of your favorite team or player, Vanishing Twin Our platform is designed to make your ticket purchasing experience hassle-free and enjoyable, with a wide range of options to suit all your Concerts needs.

A Variety of Tickets for Every Fan

We offer an extensive selection of tickets, from budget-friendly standard options to exclusive VIP experiences. This variety ensures that every fan finds the perfect ticket to experience their favorite team or player Vanishing Twin live. Keep an eye on the.Vanishing Twin Concerts event dates, and grab the opportunity to book your tickets online at the most competitive prices.

Last-Minute Plans? No Problem!

For those spontaneous Concerts-goers, our last-minute section is a lifesaver, offering the best available tickets for your impromptu plans. This feature ensures that you never miss out on experiencing a memorable live Concerts event, even at the eleventh hour.

Book Early for the Best Experience

Remember, the early bird gets the worm! Securing your tickets early is crucial to avoid disappointment and get the best possible seats. However, if you do find yourself in need of last-minute tickets, don't worry – we've got you covered.

Don’t Miss Out – Act Fast!

At etickets.ca, we understand the exhilaration of attending live Concerts. We are committed to providing you with the best seats for an unforgettable experience. Delaying your decision could mean missing out on the best seats, so be prompt in securing your spot at Vanishing Twin's Concerts. This is your chance to make your social profiles buzz with the excitement of a live Concerts event.

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
8.1.27PHP Version1.11sRequest Duration45MBMemory UsageGET {slug}RouteAuth status
  • warninglog[12:20:31] LOG.warning: Calling static trait method App\Http\Traits\slug::resolve_alias_for_routes i...
  • warninglog[12:20:31] LOG.warning: Calling static trait method App\Http\Traits\slug::resolve_alias_for_routes i...
  • warninglog[12:20:31] LOG.warning: Calling static trait method App\Http\Traits\slug::resolve_alias is deprecate...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $catid is i...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $pcatid is ...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $pcatid is ...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $pcatid is ...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $catid is i...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $catid is i...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $catid is i...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $venueId is...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $data is im...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $venueId is...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $data is im...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $catid is i...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $catid is i...
  • warninglog[12:20:31] LOG.warning: Optional parameter $date declared before required parameter $search is impli...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreId declared before required parameter $userRoleSec...
  • warninglog[12:20:31] LOG.warning: Optional parameter $ignoreDeleteScope declared before required parameter $ve...
  • warninglog[12:20:31] LOG.warning: Optional parameter $paginate declared before required parameter $page is imp...
  • warninglog[12:20:31] LOG.warning: Optional parameter $filterArr declared before required parameter $userRoleSe...
  • warninglog[12:20:31] LOG.warning: Optional parameter $returnCounter declared before required parameter $userRo...
  • warninglog[12:20:31] LOG.warning: Optional parameter $isAdmin declared before required parameter $userRoleSect...
  • warninglog[12:20:31] LOG.warning: str_contains(): Passing null to parameter #1 ($haystack) of type string is d...
  • warninglog[12:20:31] LOG.warning: str_contains(): Passing null to parameter #1 ($haystack) of type string is d...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • warninglog[12:20:31] LOG.warning: strpos(): Passing null to parameter #1 ($haystack) of type string is depreca...
  • Booting (314ms)
  • Application (798ms)
  • 1 x Application (71.73%)
    797.79ms
    1 x Booting (28.25%)
    314.15ms
    10 templates were rendered
    • performers::frontview.performer-tickets (packages/Powerpanel/Performers/src/Resources/views/frontview/performer-tickets.blade.php)16bladefile
      Params
      0
      getAllEvents
      1
      getEventCount
      2
      parentTitle
      3
      childTitle
      4
      performerid
      5
      intChildCatId
      6
      intParentCatId
      7
      getAllPerformers
      8
      isCategoryTitle
      9
      breadcrumb
      10
      metaInfo
      11
      bannerData
      12
      detailPageTitle
      13
      isCategoryDescription
      14
      promoUrl
      15
      state
    • layouts.inner_banner (resources/views/layouts/inner_banner.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
      getAllEvents
      25
      getEventCount
      26
      parentTitle
      27
      childTitle
      28
      performerid
      29
      intChildCatId
      30
      intParentCatId
      31
      getAllPerformers
      32
      isCategoryTitle
      33
      breadcrumb
      34
      metaInfo
      35
      bannerData
      36
      detailPageTitle
      37
      isCategoryDescription
      38
      promoUrl
      39
      state
    • similar-performer-event-list (resources/views/similar-performer-event-list.blade.php)43bladefile
      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
      getAllEvents
      25
      getEventCount
      26
      parentTitle
      27
      childTitle
      28
      performerid
      29
      intChildCatId
      30
      intParentCatId
      31
      getAllPerformers
      32
      isCategoryTitle
      33
      breadcrumb
      34
      metaInfo
      35
      bannerData
      36
      detailPageTitle
      37
      isCategoryDescription
      38
      promoUrl
      39
      state
      40
      filterArr
      41
      getEventsArray
      42
      getEventsData
    • right_side_adv (resources/views/right_side_adv.blade.php)42bladefile
      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
      getAllEvents
      25
      getEventCount
      26
      parentTitle
      27
      childTitle
      28
      performerid
      29
      intChildCatId
      30
      intParentCatId
      31
      getAllPerformers
      32
      isCategoryTitle
      33
      breadcrumb
      34
      metaInfo
      35
      bannerData
      36
      detailPageTitle
      37
      isCategoryDescription
      38
      promoUrl
      39
      state
      40
      filterArr
      41
      getEventsArray
    • performers-list (resources/views/performers-list.blade.php)42bladefile
      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
      getAllEvents
      25
      getEventCount
      26
      parentTitle
      27
      childTitle
      28
      performerid
      29
      intChildCatId
      30
      intParentCatId
      31
      getAllPerformers
      32
      isCategoryTitle
      33
      breadcrumb
      34
      metaInfo
      35
      bannerData
      36
      detailPageTitle
      37
      isCategoryDescription
      38
      promoUrl
      39
      state
      40
      filterArr
      41
      getEventsArray
    • layouts.app (resources/views/layouts/app.blade.php)47bladefile
      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
      getAllEvents
      25
      getEventCount
      26
      parentTitle
      27
      childTitle
      28
      performerid
      29
      intChildCatId
      30
      intParentCatId
      31
      getAllPerformers
      32
      isCategoryTitle
      33
      breadcrumb
      34
      metaInfo
      35
      bannerData
      36
      detailPageTitle
      37
      isCategoryDescription
      38
      promoUrl
      39
      state
      40
      filterArr
      41
      getEventsArray
      42
      seg1
      43
      seg3
      44
      seg2
      45
      substring
      46
      title
    • layouts.header (resources/views/layouts/header.blade.php)52bladefile
      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
      getAllEvents
      25
      getEventCount
      26
      parentTitle
      27
      childTitle
      28
      performerid
      29
      intChildCatId
      30
      intParentCatId
      31
      getAllPerformers
      32
      isCategoryTitle
      33
      breadcrumb
      34
      metaInfo
      35
      bannerData
      36
      detailPageTitle
      37
      isCategoryDescription
      38
      promoUrl
      39
      state
      40
      filterArr
      41
      getEventsArray
      42
      seg1
      43
      seg3
      44
      seg2
      45
      substring
      46
      title
      47
      requestedFullUrl
      48
      homePageUrl
      49
      seg
      50
      encodedSeg
      51
      d_class
    • layouts.header_main (resources/views/layouts/header_main.blade.php)52bladefile
      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
      getAllEvents
      25
      getEventCount
      26
      parentTitle
      27
      childTitle
      28
      performerid
      29
      intChildCatId
      30
      intParentCatId
      31
      getAllPerformers
      32
      isCategoryTitle
      33
      breadcrumb
      34
      metaInfo
      35
      bannerData
      36
      detailPageTitle
      37
      isCategoryDescription
      38
      promoUrl
      39
      state
      40
      filterArr
      41
      getEventsArray
      42
      seg1
      43
      seg3
      44
      seg2
      45
      substring
      46
      title
      47
      requestedFullUrl
      48
      homePageUrl
      49
      seg
      50
      encodedSeg
      51
      d_class
    • layouts.footer_main (resources/views/layouts/footer_main.blade.php)52bladefile
      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
      getAllEvents
      25
      getEventCount
      26
      parentTitle
      27
      childTitle
      28
      performerid
      29
      intChildCatId
      30
      intParentCatId
      31
      getAllPerformers
      32
      isCategoryTitle
      33
      breadcrumb
      34
      metaInfo
      35
      bannerData
      36
      detailPageTitle
      37
      isCategoryDescription
      38
      promoUrl
      39
      state
      40
      filterArr
      41
      getEventsArray
      42
      seg1
      43
      seg3
      44
      seg2
      45
      substring
      46
      title
      47
      requestedFullUrl
      48
      homePageUrl
      49
      seg
      50
      encodedSeg
      51
      d_class
    • layouts.footer (resources/views/layouts/footer.blade.php)52bladefile
      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
      getAllEvents
      25
      getEventCount
      26
      parentTitle
      27
      childTitle
      28
      performerid
      29
      intChildCatId
      30
      intParentCatId
      31
      getAllPerformers
      32
      isCategoryTitle
      33
      breadcrumb
      34
      metaInfo
      35
      bannerData
      36
      detailPageTitle
      37
      isCategoryDescription
      38
      promoUrl
      39
      state
      40
      filterArr
      41
      getEventsArray
      42
      seg1
      43
      seg3
      44
      seg2
      45
      substring
      46
      title
      47
      requestedFullUrl
      48
      homePageUrl
      49
      seg
      50
      encodedSeg
      51
      d_class
    uri
    GET {slug}
    middleware
    web
    controller
    App\Http\Controllers\HomeController@redirectrule
    namespace
    prefix
    where
    file
    app/Http/Controllers/HomeController.php:34-115
    32 statements were executed, 8 of which were duplicated, 24 unique. Show only duplicated691ms
    • 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.53ms/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')520μs/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` = 'scrooge-the-musical-tickets' and `intFkModuleCode` = 3 and `intFkSiteid` = 1 limit 1620μs/app/Alias.php:60etickets_live
      Metadata
      Bindings
      • 0. scrooge-the-musical-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')700μ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` = 'scrooge-the-musical-tickets' limit 1530μs/app/Alias.php:44etickets_live
      Metadata
      Bindings
      • 0. scrooge-the-musical-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` asc4.45ms/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. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:31
      • 18. /app/Http/Controllers/HomeController.php:98
    • select `id`, `varTitle` from `nq_menu_type` where `nq_menu_type`.`id` in (1, 3, 4, 5, 6) and `chrPublish` = 'Y' and (`chrDelete` = 'N')540μs/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. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:31
      • 23. /app/Http/Controllers/HomeController.php:98
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'scrooge-the-musical-tickets' and `intFkModuleCode` = 3 and `intFkSiteid` = 1 limit 1580μs/app/Alias.php:60etickets_live
      Metadata
      Bindings
      • 0. scrooge-the-musical-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. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:31
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'scrooge-the-musical-tickets' limit 1460μs/app/Alias.php:44etickets_live
      Metadata
      Bindings
      • 0. scrooge-the-musical-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. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:85
      • 18. /app/Http/Controllers/HomeController.php:99
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select `intCategoryId`, `intParentCatId`, `intChildCatId`, `id`, `varTitle`, `txtDescription` from `nq_peformers` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `intAliasId` = 107755 limit 1660μs/packages/Powerpanel/Performers/src/Models/Performers.php:154etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. Y
      • 2. 107755
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /packages/Powerpanel/Performers/src/Models/Performers.php:154
      • 16. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:86
      • 17. /app/Http/Controllers/HomeController.php:99
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `fkIntImgId`, `fkIntInnerImgId` from `nq_banner` where (`chrDelete` = 'N') and ((dtEndDateTime >= NOW() AND NOW() >= dtDateTime) OR (NOW() >= dtDateTime and dtEndDateTime is null)) and (`chrPublish` = 'Y') and (`varBannerType` = 'inner_banner') and `fkIntPageId` = 63997 and `fkModuleId` = 158640μs/packages/Powerpanel/Banner/src/Models/Banner.php:157etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. Y
      • 2. inner_banner
      • 3. 63997
      • 4. 158
      Backtrace
      • 14. /packages/Powerpanel/Banner/src/Models/Banner.php:157
      • 15. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:88
      • 16. /app/Http/Controllers/HomeController.php:99
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `nq_event_performers`.`eventid`, `nq_events`.`varCity` from `nq_event_performers` inner join `nq_events` on `nq_event_performers`.`eventid` = `nq_events`.`fkeventGlcode` where `nq_events`.`chrPublish` = 'Y' and `nq_events`.`intParentCatId` = 2 and `nq_events`.`intChildCatId` = 49 and `nq_event_performers`.`performerid` = 110453 and `nq_events`.`chrDelete` = 'N'1.16ms/app/EventPerformer.php:37etickets_live
      Metadata
      Bindings
      • 0. Y
      • 1. 2
      • 2. 49
      • 3. 110453
      • 4. N
      Backtrace
      • 12. /app/EventPerformer.php:37
      • 13. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:95
      • 14. /app/Http/Controllers/HomeController.php:99
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select count(*) as aggregate from (select `varCity`, `fkeventGlcode`, `varStateProvince`, count(fkeventGlcode) as event_count from `nq_events` where date(`dtEventDate`) >= '2025-05-23' and `fkeventGlcode` in (6388908, 6388909, 6388910, 6388911, 6388916, 6388917, 6388918, 6388919, 6388920, 6388924, 6388925, 6388926, 6388927, 6388928, 6388929, 6388933, 6388934, 6388935, 6388936, 6388937, 6388938, 6388942, 6388943, 6388944, 6388945, 6388946, 6388947) group by `varCity`) as `aggregate_table`1.25ms/packages/Powerpanel/Performers/src/Controllers/PerformerController.php:106etickets_live
      Metadata
      Bindings
      • 0. 2025-05-23
      • 1. 6388908
      • 2. 6388909
      • 3. 6388910
      • 4. 6388911
      • 5. 6388916
      • 6. 6388917
      • 7. 6388918
      • 8. 6388919
      • 9. 6388920
      • 10. 6388924
      • 11. 6388925
      • 12. 6388926
      • 13. 6388927
      • 14. 6388928
      • 15. 6388929
      • 16. 6388933
      • 17. 6388934
      • 18. 6388935
      • 19. 6388936
      • 20. 6388937
      • 21. 6388938
      • 22. 6388942
      • 23. 6388943
      • 24. 6388944
      • 25. 6388945
      • 26. 6388946
      • 27. 6388947
      Backtrace
      • 15. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:106
      • 16. /app/Http/Controllers/HomeController.php:99
      • 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 `id`, `fkeventGlcode`, `VarDisplayDate`, `varTitle`, `intParentCatId`, `intChildCatId`, `intGrandChildCatId`, `varStateProvince`, `varticketsAvailable`, `varPrice`, `intStateProvinceID`, `varCity`, `varVenue`, `intVenueConfigurationID`, `intVenueID`, `dtEventDate`, `intCountryID` from `nq_events` where (`chrDelete` = 'N') and `fkeventGlcode` in (6388908, 6388909, 6388910, 6388911, 6388916, 6388917, 6388918, 6388919, 6388920, 6388924, 6388925, 6388926, 6388927, 6388928, 6388929, 6388933, 6388934, 6388935, 6388936, 6388937, 6388938, 6388942, 6388943, 6388944, 6388945, 6388946, 6388947) and date(`dtEventDate`) >= '2025-05-23' order by `dtEventDate` asc limit 12 offset 01.21ms/app/Events.php:355etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. 6388908
      • 2. 6388909
      • 3. 6388910
      • 4. 6388911
      • 5. 6388916
      • 6. 6388917
      • 7. 6388918
      • 8. 6388919
      • 9. 6388920
      • 10. 6388924
      • 11. 6388925
      • 12. 6388926
      • 13. 6388927
      • 14. 6388928
      • 15. 6388929
      • 16. 6388933
      • 17. 6388934
      • 18. 6388935
      • 19. 6388936
      • 20. 6388937
      • 21. 6388938
      • 22. 6388942
      • 23. 6388943
      • 24. 6388944
      • 25. 6388945
      • 26. 6388946
      • 27. 6388947
      • 28. 2025-05-23
      Backtrace
      • 14. /app/Events.php:355
      • 15. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:110
      • 16. /app/Http/Controllers/HomeController.php:99
      • 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 `nq_peformers`.`intCategoryId`, `nq_peformers`.`varTitle`, `nq_peformers`.`intAliasId` from `nq_peformers` where `nq_peformers`.`intParentCatId` = 2 and `nq_peformers`.`intChildCatId` = 49 and `nq_peformers`.`total_count` != 0 group by `nq_peformers`.`id`) as `aggregate_table`99ms/packages/Powerpanel/Performers/src/Models/Performers.php:191etickets_live
      Metadata
      Bindings
      • 0. 2
      • 1. 49
      • 2. 0
      Hints
      • The != operator is not standard. Use the <> operator to test for inequality instead.
      Backtrace
      • 15. /packages/Powerpanel/Performers/src/Models/Performers.php:191
      • 16. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:128
      • 17. /app/Http/Controllers/HomeController.php:99
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `nq_peformers`.`intCategoryId`, `nq_peformers`.`varTitle`, `nq_peformers`.`intAliasId` from `nq_peformers` where `nq_peformers`.`intParentCatId` = 2 and `nq_peformers`.`intChildCatId` = 49 and `nq_peformers`.`total_count` != 0 group by `nq_peformers`.`id` order by `total_count` desc limit 12 offset 04.05ms/packages/Powerpanel/Performers/src/Models/Performers.php:191etickets_live
      Metadata
      Bindings
      • 0. 2
      • 1. 49
      • 2. 0
      Hints
      • The != operator is not standard. Use the <> operator to test for inequality instead.
      Backtrace
      • 13. /packages/Powerpanel/Performers/src/Models/Performers.php:191
      • 14. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:128
      • 15. /app/Http/Controllers/HomeController.php:99
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `id`, `varTitle`, `intCategoryId` from `nq_categories` where `intCategoryId` = 2 limit 1680μs/packages/Powerpanel/Categories/src/Models/Categories.php:849etickets_live
      Metadata
      Bindings
      • 0. 2
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /packages/Powerpanel/Categories/src/Models/Categories.php:849
      • 16. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:129
      • 17. /app/Http/Controllers/HomeController.php:99
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `id`, `varTitle`, `intCategoryId` from `nq_categories` where `intCategoryId` = 49 and `intParentCategoryId` = 2 limit 1660μs/packages/Powerpanel/Categories/src/Models/Categories.php:862etickets_live
      Metadata
      Bindings
      • 0. 49
      • 1. 2
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /packages/Powerpanel/Categories/src/Models/Categories.php:862
      • 16. /packages/Powerpanel/Performers/src/Controllers/PerformerController.php:130
      • 17. /app/Http/Controllers/HomeController.php:99
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `id`, `fkeventGlcode`, `intAliasId`, `varTitle`, `intParentCatId`, `intChildCatId`, `intGrandChildCatId`, `VarDisplayDate`, `intClicks`, `intWomensEvent`, `varMapurl`, `varticketsAvailable`, `varPrice`, `varStateProvince`, `intStateProvinceID`, `varCity`, `varVenue`, `intVenueConfigurationID`, `intVenueID`, `dtEventDate`, `intCountryID` from `nq_events` where `intParentCatId` = 2 and `intChildCatId` = 49 and date(`dtEventDate`) >= '2025-05-23' order by `dtEventDate` asc limit 12268ms/app/Events.php:461etickets_live
      Metadata
      Bindings
      • 0. 2
      • 1. 49
      • 2. 2025-05-23
      Backtrace
      • 14. /app/Events.php:461
      • 15. view::performers::frontview.performer-tickets:62
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select count(*) as aggregate from `nq_events` where `intParentCatId` = 2 and `intChildCatId` = 49 and date(`dtEventDate`) >= '2025-05-23'277ms/app/Events.php:771etickets_live
      Metadata
      Bindings
      • 0. 2
      • 1. 49
      • 2. 2025-05-23
      Backtrace
      • 15. /app/Events.php:771
      • 16. view::performers::frontview.performer-tickets:65
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 180568 and `chrIsPreview` = 'N' limit 1750μs/app/Alias.php:72etickets_live
      Metadata
      Bindings
      • 0. 180568
      • 1. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:72
      • 16. view::performers-list:16
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 220789 and `chrIsPreview` = 'N' limit 14.36ms/app/Alias.php:72etickets_live
      Metadata
      Bindings
      • 0. 220789
      • 1. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:72
      • 16. view::performers-list:16
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 218266 and `chrIsPreview` = 'N' limit 15.51ms/app/Alias.php:72etickets_live
      Metadata
      Bindings
      • 0. 218266
      • 1. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:72
      • 16. view::performers-list:16
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 219265 and `chrIsPreview` = 'N' limit 19.28ms/app/Alias.php:72etickets_live
      Metadata
      Bindings
      • 0. 219265
      • 1. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:72
      • 16. view::performers-list:16
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 218419 and `chrIsPreview` = 'N' limit 1480μs/app/Alias.php:72etickets_live
      Metadata
      Bindings
      • 0. 218419
      • 1. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:72
      • 16. view::performers-list:16
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 107755 and `chrIsPreview` = 'N' limit 1450μs/app/Alias.php:72etickets_live
      Metadata
      Bindings
      • 0. 107755
      • 1. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:72
      • 16. view::performers-list:16
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 104066 and `chrIsPreview` = 'N' limit 1490μs/app/Alias.php:72etickets_live
      Metadata
      Bindings
      • 0. 104066
      • 1. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:72
      • 16. view::performers-list:16
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 29983 and `chrIsPreview` = 'N' limit 1460μs/app/Alias.php:72etickets_live
      Metadata
      Bindings
      • 0. 29983
      • 1. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:72
      • 16. view::performers-list:16
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 162724 and `chrIsPreview` = 'N' limit 1450μs/app/Alias.php:72etickets_live
      Metadata
      Bindings
      • 0. 162724
      • 1. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:72
      • 16. view::performers-list:16
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 104896 and `chrIsPreview` = 'N' limit 1420μs/app/Alias.php:72etickets_live
      Metadata
      Bindings
      • 0. 104896
      • 1. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:72
      • 16. view::performers-list:16
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 92230 and `chrIsPreview` = 'N' limit 1470μs/app/Alias.php:72etickets_live
      Metadata
      Bindings
      • 0. 92230
      • 1. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:72
      • 16. view::performers-list:16
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 3930 and `chrIsPreview` = 'N' limit 1480μs/app/Alias.php:72etickets_live
      Metadata
      Bindings
      • 0. 3930
      • 1. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:72
      • 16. view::performers-list:16
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    App\Events
    12
    Powerpanel\Categories\Models\Categories
    2
    Powerpanel\Performers\Models\Performers
    1
    App\Alias
    14
    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
      Y6c6JjUfATmmM66rZpOzxBVA7ydNJxSwhGF9ax3U
      PHPDEBUGBAR_STACK_DATA
      []
      _previous
      array:1 [ "url" => "https://www.etickets.ca/_debugbar/assets/javascript?v=1748019654" ]
      _flash
      array:2 [ "old" => [] "new" => [] ]
      path_info
      /scrooge-the-musical-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:22 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IkNEem92bjkvdmFDNWk4NHZPVDNsK3c9PSIsInZhbHVlIjoiUHM4dys0OElBcWJyemRQUUlITUowTnBpSnFyYVRVUnpZVWg0bjkxekpxY2J0MW9GMHZMOFVSWFZjNVlqSStFNmtra2ZOMEU3K3l4MXh1NmlnN0g2SjdRQW9meFhXMGJLWk1LelhpTEVoQzZGd0wvTFVMOEZVS2t1Y20rRVJwV3YiLCJtYWMiOiJiYjJhNmRhMjhiODU3ZGI1ZmNmZThkYTU0YjAzOWJjM2FjYWRkMjU3NGQzOTZlNGY3ZTllMzkwZDE0MjFkZDdlIiwidGFnIjoiIn0%3D; recently_viewed=I0PwzcOFUsFD1xbOPuI8; AWSALB=3W7JLExkmm0sCNEDFgohND1Kxp78BQKPMtTDGtPomdYYjJjJwTsjRM6YOdFLVxcG2wYD1k6gHR2mUmUyepg1QuqN8NCVHt3EAhzx82ag8BLIKWY/rEE5SQ+E2TRs; AWSALBCORS=3W7JLExkmm0sCNEDFgohND1Kxp78BQKPMtTDGtPomdYYjJjJwTsjRM6YOdFLVxcG2wYD1k6gHR2mUmUyepg1QuqN8NCVHt3EAhzx82ag8BLIKWY/rEE5SQ+E2TRs; eticket_2023_session=1WbpjGMJQiNo4edBjzC23pUAvpeXCqjdOZwRx2bzXSRF-TOKEN=eyJpdiI6IkNEem92bjkvdmFDNWk4NHZPVDNsK3c9PSIsInZhbHVlIjoiUHM4dys0OElBcWJyemRQUUlITUowTnBpSnFyYVRVUnpZVWg0bjkxekpxY2J0MW9GMHZMOFVSWFZjNVlqSStFNmtra2ZOM" ] "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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "x-amzn-trace-id" => array:1 [ 0 => "Root=1-6830ae5e-6899111474a94879021f4863" ] "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.216.17.239" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
      request_server
      0 of 0
      array:46 [ "USER" => "nobody" "HOME" => "/" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6IkNEem92bjkvdmFDNWk4NHZPVDNsK3c9PSIsInZhbHVlIjoiUHM4dys0OElBcWJyemRQUUlITUowTnBpSnFyYVRVUnpZVWg0bjkxekpxY2J0MW9GMHZMOFVSWFZjNVlqSStFNmtra2ZOMEU3K3l4MXh1NmlnN0g2SjdRQW9meFhXMGJLWk1LelhpTEVoQzZGd0wvTFVMOEZVS2t1Y20rRVJwV3YiLCJtYWMiOiJiYjJhNmRhMjhiODU3ZGI1ZmNmZThkYTU0YjAzOWJjM2FjYWRkMjU3NGQzOTZlNGY3ZTllMzkwZDE0MjFkZDdlIiwidGFnIjoiIn0%3D; recently_viewed=I0PwzcOFUsFD1xbOPuI8; AWSALB=3W7JLExkmm0sCNEDFgohND1Kxp78BQKPMtTDGtPomdYYjJjJwTsjRM6YOdFLVxcG2wYD1k6gHR2mUmUyepg1QuqN8NCVHt3EAhzx82ag8BLIKWY/rEE5SQ+E2TRs; AWSALBCORS=3W7JLExkmm0sCNEDFgohND1Kxp78BQKPMtTDGtPomdYYjJjJwTsjRM6YOdFLVxcG2wYD1k6gHR2mUmUyepg1QuqN8NCVHt3EAhzx82ag8BLIKWY/rEE5SQ+E2TRs; eticket_2023_session=1WbpjGMJQiNo4edBjzC23pUAvpeXCqjdOZwRx2bzXSRF-TOKEN=eyJpdiI6IkNEem92bjkvdmFDNWk4NHZPVDNsK3c9PSIsInZhbHVlIjoiUHM4dys0OElBcWJyemRQUUlITUowTnBpSnFyYVRVUnpZVWg0bjkxekpxY2J0MW9GMHZMOFVSWFZjNVlqSStFNmtra2ZOM" "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" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_X_AMZN_TRACE_ID" => "Root=1-6830ae5e-6899111474a94879021f4863" "HTTP_HOST" => "www.etickets.ca" "HTTP_X_FORWARDED_PORT" => "443" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_FOR" => "18.216.17.239" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "etickets.ca" "SERVER_PORT" => "80" "SERVER_ADDR" => "172.17.0.13" "REMOTE_PORT" => "52630" "REMOTE_ADDR" => "172.16.0.8" "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" => "/scrooge-the-musical-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" => 1748020830.7555 "REQUEST_TIME" => 1748020830 "HTTPS" => true ]
      request_cookies
      0 of 0
      array:5 [ "XSRF-TOKEN" => "uuVuPrbKIkl37VzK4uHPWe2axDzragn58MO8VIbe" "recently_viewed" => "I0PwzcOFUsFD1xbOPuI8" "AWSALB" => null "AWSALBCORS" => null "eticket_2023_session" => 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 => "Fri, 23 May 2025 17:20:31 GMT" ] "set-cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InY4cUpSa3pPbU5qUHRhaFRoRHA3emc9PSIsInZhbHVlIjoiby9xRE1OVHFiN1U5R08wUUlXMlN5Y014emM0TDRuZWVHUDNxYy9kNGZZaWU4bjhEL0lsbFVPS2hoTDc0Wnd0U1RXcFd6cnowN09yZzlEYW5XNmI0dHE2LytLN2lmb2FMUGZLRGZaZVl0eGZmeFgzZnI5VXNqc3Yrb3h6cnlIVFQiLCJtYWMiOiJhMDc0YjIwZjc1ODkxZDBmYzQxNDZhN2JlZGJhMWJjZTcxNDlmNzVmYTgyZTU0ZWE0Y2E2NjQ2MzZkMDdmZGUwIiwidGFnIjoiIn0%3D; expires=Fri, 23 May 2025 19:20:31 GMT; Max-Age=7200; path=/; secureXSRF-TOKEN=eyJpdiI6InY4cUpSa3pPbU5qUHRhaFRoRHA3emc9PSIsInZhbHVlIjoiby9xRE1OVHFiN1U5R08wUUlXMlN5Y014emM0TDRuZWVHUDNxYy9kNGZZaWU4bjhEL0lsbFVPS2hoTDc0Wnd0U1RXcFd6c" ] "Set-Cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InY4cUpSa3pPbU5qUHRhaFRoRHA3emc9PSIsInZhbHVlIjoiby9xRE1OVHFiN1U5R08wUUlXMlN5Y014emM0TDRuZWVHUDNxYy9kNGZZaWU4bjhEL0lsbFVPS2hoTDc0Wnd0U1RXcFd6cnowN09yZzlEYW5XNmI0dHE2LytLN2lmb2FMUGZLRGZaZVl0eGZmeFgzZnI5VXNqc3Yrb3h6cnlIVFQiLCJtYWMiOiJhMDc0YjIwZjc1ODkxZDBmYzQxNDZhN2JlZGJhMWJjZTcxNDlmNzVmYTgyZTU0ZWE0Y2E2NjQ2MzZkMDdmZGUwIiwidGFnIjoiIn0%3D; expires=Fri, 23-May-2025 19:20:31 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6InY4cUpSa3pPbU5qUHRhaFRoRHA3emc9PSIsInZhbHVlIjoiby9xRE1OVHFiN1U5R08wUUlXMlN5Y014emM0TDRuZWVHUDNxYy9kNGZZaWU4bjhEL0lsbFVPS2hoTDc0Wnd0U1RXcFd6c" ] ]
      session_attributes
      0 of 0
      array:4 [ "_token" => "Y6c6JjUfATmmM66rZpOzxBVA7ydNJxSwhGF9ax3U" "PHPDEBUGBAR_STACK_DATA" => [] "_previous" => array:1 [ "url" => "https://www.etickets.ca/_debugbar/assets/javascript?v=1748019654" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]