eTickets.ca takes pride in offering you a seamless way to witness the electrifying performance of your favorite team or player, The Hook Our platform is designed to make your ticket purchasing experience hassle-free and enjoyable, with a wide range of options to suit all your theatre needs.
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 The Hook live. Keep an eye on the.The Hooktheatre event dates, and grab the opportunity to book your tickets online at the most competitive prices.
For those spontaneous theatre-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 theatre event, even at the eleventh hour.
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.
At eTickets.ca, we understand the exhilaration of attending live theatre. 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 The Hook's theatre. This is your chance to make your social profiles buzz with the excitement of a live theatre event.
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.
1 x Application (68.06%) | 201.78ms |
1 x Booting (31.88%) | 94.54ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
select `nq_menu`.`id`, `intParentMenuId`, `intItemOrder`, `intParentItemOrder`, `chrInMobile`, `chrInWeb`, `intAliasId`, `intPageId`, `varTitle`, `txtPageUrl`, `intPosition`, `chrActive`, `chrDisplayFront`, `chrMegaMenu`, `chrDelete`, `chrPublish`, `created_at`, `updated_at`, `chrNewTab`, `intfkMegaMenuId`, `nq_mega_menu_details`.`title` as `mega_menu_inner_title`, `nq_mega_menu_details`.`description`, `nq_mega_menu_details`.`image_id`, `nq_mega_menu_details`.`link`, `nq_mega_menu_details`.`image_caption` from `nq_menu` left join `nq_mega_menu_details` on `nq_mega_menu_details`.`id` = `nq_menu`.`intfkMegaMenuId` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`chrActive` = 'Y') and `chrInWeb` = 'Y' order by `intPosition` asc, `intParentItemOrder` asc, `intItemOrder` asc
6.37ms/packages/Powerpanel/Menu/src/Models/Menu.php:233etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `varTitle` from `nq_menu_type` where `nq_menu_type`.`id` in (1, 3, 4, 5, 6, 7) and `chrPublish` = 'Y' and (`chrDelete` = 'N')
1.01ms/packages/Powerpanel/Menu/src/Models/Menu.php:233etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'the-hook-tickets' limit 1
1.09ms/app/Alias.php:35etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 47574 and `chrIsPreview` = 'N' limit 1
950μs/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `fkIntPageId`, `fkModuleId`, `varTitle`, `varPopUpOn`, `varDsplyOn`, `varLink`, `txtDescription`, `fkIntImgId`, `dtStartDateTime`, `dtEndDateTime`, `chrPublish` from `nq_pop_up_content` where (`chrPublish` = 'Y') and `fkIntPageId` = 47574 and (`chrDelete` = 'N') limit 1
1.04ms/app/Http/Controllers/FrontController.php:799etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `fkIntPageId`, `fkModuleId`, `varTitle`, `varPopUpOn`, `varDsplyOn`, `varLink`, `txtDescription`, `fkIntImgId`, `dtStartDateTime`, `dtEndDateTime`, `chrPublish` from `nq_pop_up_content` where (`chrPublish` = 'Y') and (`chrDelete` = 'N')
1.02ms/packages/Powerpanel/PopupContent/src/Models/PopUpContent.php:89etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'performers' and `intFkModuleCode` = 3 limit 1
980μs/app/Alias.php:50etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `fkIntImgId`, `fkIntInnerImgId`, `varLink`, `varShortDescription`, `chrDisplayLink`, `chrDisplayVideo`, `varVideoLink`, `varTitle`, `txtDescription`, `chrDraft`, `chrArchive`, `chrTrash`, `chrPublish`, `FavoriteID`, `created_at`, `updated_at` from `nq_banner` where (`chrDefaultBanner` = 'Y') and (`chrDelete` = 'N') and ((dtEndDateTime >= NOW() AND NOW() >= dtDateTime) OR (NOW() >= dtDateTime and dtEndDateTime is null)) and `chrMain` = 'Y' and `chrTrash` != 'Y' and (`chrPublish` = 'Y') order by `intDisplayOrder` asc
1.16ms/packages/Powerpanel/Banner/src/Models/Banner.php:108etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `varTitle`, `fkIntImgId`, `varTitle`, `chrPublish`, `chrDelete`, `dtDateTime` from `nq_offer` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and ((dtEndDateTime >= NOW() AND NOW() >= dtDateTime) OR (NOW() >= dtDateTime and dtEndDateTime is null)) order by `dtDateTime` desc limit 1
990μs/packages/Powerpanel/Offer/src/Models/Offer.php:66etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'the-hook-tickets' limit 1
940μs/app/Alias.php:35etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intCategoryId` from `nq_peformers` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `intAliasId` = 47574 limit 1
1.01ms/packages/Powerpanel/Performers/src/Models/Performers.php:594etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intCategoryId`, `intParentCatId`, `intChildCatId`, `id`, `varTitle`, `txtDescription` from `nq_peformers` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `intAliasId` = 47574 limit 1
1.11ms/packages/Powerpanel/Performers/src/Models/Performers.php:154etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `nq_peformers` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `intAliasId` = 47574 limit 1
2.05ms/packages/Powerpanel/Performers/src/Models/Performers.php:1288etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `varTitle`, `fkIntImgId`, `fkIntInnerImgId`, `varLink`, `fkIntPageId`, `varShortDescription`, `fkModuleId`, `varVideoLink`, `chrPublish`, `chrDisplayLink`, `chrDisplayVideo`, `txtDescription`, `chrDraft`, `chrArchive`, `chrTrash`, `FavoriteID`, `created_at`, `updated_at` 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` = 46566 and `fkModuleId` = 158
1.21ms/packages/Powerpanel/Banner/src/Models/Banner.php:157etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
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` = 3 and `nq_events`.`intChildCatId` = 74 and `nq_event_performers`.`performerid` = 213046 and `nq_events`.`chrDelete` = 'N'
7.38ms/app/EventPerformer.php:37etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from (select `varCity`, `varStateProvince`, count(fkeventGlcode) as event_count from `nq_events` where `fkeventGlcode` in (6245236, 6245237, 6245238, 6245239, 6245240, 6245241, 6245242, 6245243, 6245244, 6245245, 6245246, 6245247, 6245248, 6245249, 6245250, 6245251, 6245252, 6245253, 6245254, 6245255, 6245256, 6245257, 6245258, 6245259, 6245260, 6245261, 6245262, 6267310, 6267311, 6267312, 6267313, 6267314, 6267315, 6267316, 6267317, 6267318, 6267319, 6267320, 6267321, 6267322, 6267323, 6267324, 6267325, 6267326, 6267327, 6267328, 6267329, 6267330, 6267331, 6267332, 6267333, 6267334, 6267335, 6267336, 6267337, 6267338, 6267339, 6267340, 6267341, 6267342, 6267343, 6267344, 6267345, 6267346, 6267347, 6267348, 6267349, 6267350, 6267351, 6267352, 6267353, 6267354, 6267355, 6267356, 6267357, 6267358, 6267359, 6267360, 6267361, 6267362, 6267363, 6267364, 6267365, 6267366, 6267367, 6267368, 6267369, 6267370, 6267371, 6267372, 6267373, 6267374, 6267375, 6267376, 6267377, 6267378, 6267379, 6267380, 6267381, 6267382, 6267383, 6267384, 6399607, 6399608, 6399609, 6560570, 6560573, 6560574, 6560576, 6560579, 6560580, 6560581, 6560582, 6560583, 6560584, 6560585, 6560586, 6560587, 6560588, 6560589, 6560590, 6560591, 6560592, 6560593, 6560594, 6560595, 6560596, 6560597, 6560598, 6560599, 6560600, 6560601, 6560602, 6560603, 6560604, 6560605, 6560606, 6560607, 6560608, 6560609, 6560610, 6560611, 6560612, 6560613, 6560614, 6560615, 6560616, 6560617, 6560618, 6560619, 6560620, 6560621, 6560622, 6560623, 6560624, 6560625, 6560626, 6560627, 6560628, 6560629, 6560630, 6560631, 6560632, 6560633, 6560634, 6560635, 6560636, 6560637, 6560638, 6560639, 6560640, 6560641, 6560642, 6560643, 6560644, 6560645, 6560646, 6560647, 6560648, 6560649, 6560650, 6560651, 6560652, 6560653, 6560654, 6560655, 6560656, 6560657, 6560658, 6560659, 6560660, 6560661, 6560662, 6560663, 6560664, 6560665, 6560666, 6560667, 6560668, 6560669, 6560670, 6560671, 6560672, 6560673, 6560674, 6560675, 6560676, 6560677, 6560678, 6560679, 6560680, 6560681, 6560682, 6560683, 6560684, 6560685, 6560686, 6560687, 6560688, 6560689, 6560690, 6560691, 6560692, 6560693, 6560694, 6560695, 6560696, 6560697, 6560698, 6560699, 6560700, 6560701, 6560702, 6560703, 6560704, 6560705, 6560706, 6560707, 6560708, 6560709, 6560710, 6560711, 6560712, 6560713, 6560714, 6560716, 6560717, 6560718, 6560719, 6560720, 6560721, 6560722, 6560723, 6560724, 6560725, 6560726, 6560727, 6560728, 6560729, 6560730, 6560731, 6560732, 6560733, 6560734, 6560735, 6560736, 6560737, 6560738, 6560739, 6560740, 6560741, 6560742, 6560743, 6560744, 6560745, 6560746, 6560747, 6560748, 6560749, 6560750, 6560751, 6560752, 6560753, 6560754, 6560755, 6560756, 6560757, 6560758, 6560759, 6560760, 6560761, 6560762, 6560763, 6560764, 6560765, 6560766, 6560767, 6560769, 6560770, 6560771, 6560571, 6560572, 6560575, 6560577, 6560715, 6560768, 6560578, 6600000, 6618009, 6618010, 6618011, 6618012, 6618037, 6618038, 6618040, 6618107, 6618108, 6618109, 6618131, 6618132, 6618133, 6618134, 6618135, 6618145, 6618146, 6618147, 6618148, 6618149, 6618150, 6618157, 6618158, 6618159, 6618160, 6618161, 6618162, 6618163, 6618165, 6618166, 6618219, 6618220, 6618233, 6618234, 6618235, 6618237, 6618238, 6618239, 6618240, 6618241, 6618242, 6618243, 6618244, 6618245, 6618247, 6618248, 6618249, 6618250, 6618251, 6618252, 6618253, 6618254, 6618255, 6618256, 6618257, 6618258, 6618259, 6618260, 6618261, 6618262, 6618263, 6618264, 6618265, 6618273, 6618279, 6618280, 6618281, 6618282, 6618290, 6618291, 6618292, 6618293, 6618294, 6618360, 6618361, 6618362, 6618666, 6618751, 6619065, 6619090, 6619370, 6619402, 6619403, 6619614, 6619632, 6619987, 6620060, 6620111, 6620177, 6620190, 6621461, 6831806, 6831807, 6831827, 6831837, 6831838, 6831842, 6831843, 6831844, 6831854, 6831861, 6832204, 6832257, 6832689, 6832690, 6832691, 6832692, 6832695, 6832698, 6832699, 6832700, 6832701, 6832702, 6832703, 6832704, 6832706, 6832707, 6832708, 6832709, 6832710, 6832712, 6832713, 6832714, 6832715, 6832716, 6832717, 6832718, 6835753, 6835754, 6835755, 6835756, 6835757, 6835758, 6835759, 6835760, 6835771, 6835772, 6835905, 6835906, 6835907, 6835908, 6835925, 6835926, 6835927, 6835928, 6835929, 6835930, 6835931, 6835932, 6835933, 6835934, 6835935, 6835936, 6835937, 6835938, 6835939, 6835940, 6835941, 6835942, 6835943, 6835951, 6835952, 6835953, 6835993, 6835994, 6835995, 6835996, 6835997, 6835998, 6836341, 6836393, 6837935, 6837936, 6837937, 6998056, 6998059, 6998066, 6998067, 6998068, 6998089, 6998090, 6998091, 6998155, 6998156, 6998277, 6998294, 6998334, 6998335, 6998336, 6999290, 7031440, 7031441, 7031464, 7031465, 7031466, 7031467, 7031468, 7031469, 7031470, 7031483, 7031484, 7031485, 7031486, 7031487, 7031488, 7031489, 7031490, 7031510, 7031511, 7031512, 7031513, 7031514, 7031515, 7031516, 7031517, 7031523, 7031524, 7031525, 7031552, 7031553, 7031554, 7031778, 7031779, 7031780, 7031781, 7031782, 7031783, 7031784, 7031785, 7031786, 7031787, 7031788, 7031789, 7031790, 7031791, 7031792, 7031793, 7031802, 7031803, 7031804, 7031805, 7031806, 7031807, 7031808, 7031809, 7031810, 7031811, 7031812, 7031813, 7031821, 7031822, 7031823, 7031824, 7078282, 7078283, 7078284, 7078285, 7078311, 7078312, 7078313, 7078314, 7078315, 7078316, 7078317, 7078318, 7078319, 7078320, 7078321, 7078322, 7078323, 7078324, 7078325, 7078326, 7078327, 7078328, 7078329, 7078330, 7078331, 7078332, 7078333, 7078334, 7078335, 7078336, 7078337, 7078349, 7078350, 7078351, 7078352, 7078353, 7078363, 7078364, 7078365, 7078366, 7078367, 7078368, 7078369, 7078370, 7078371, 7078372, 7078373, 7078374, 7078375, 7078376, 7078401, 7078402, 7078403, 7078404, 7078405, 7078406, 7078407, 7078408, 7078409, 7078410, 7078430, 7078431, 7078432, 7078433, 7078434, 7078435, 7078436, 7078437, 7078438, 7078439, 7078440, 7078441, 7078442, 7078443, 7078444, 7078445, 7078446, 7078447, 7078448, 7078466, 7078467, 7078468, 7078469, 7078470, 7078471, 7078472, 7078473, 7078474, 7078475, 7078476, 7078477, 7078507, 7078508, 7078509, 7078510, 7078511, 7078512, 7078536, 7078537, 7078538, 7078539, 7078540, 7078541, 7078542, 7078543, 7078544, 7078545, 7078546, 7078547, 7078548, 7078549, 7078563, 7078570, 7078606, 7078607, 7078608, 7078609, 7078610, 7078635, 7078659, 7078708) group by `varCity`) as `aggregate_table`
8.68ms/packages/Powerpanel/Performers/src/Controllers/PerformerController.php:218etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `varCity`, `varStateProvince`, count(fkeventGlcode) as event_count from `nq_events` where `fkeventGlcode` in (6245236, 6245237, 6245238, 6245239, 6245240, 6245241, 6245242, 6245243, 6245244, 6245245, 6245246, 6245247, 6245248, 6245249, 6245250, 6245251, 6245252, 6245253, 6245254, 6245255, 6245256, 6245257, 6245258, 6245259, 6245260, 6245261, 6245262, 6267310, 6267311, 6267312, 6267313, 6267314, 6267315, 6267316, 6267317, 6267318, 6267319, 6267320, 6267321, 6267322, 6267323, 6267324, 6267325, 6267326, 6267327, 6267328, 6267329, 6267330, 6267331, 6267332, 6267333, 6267334, 6267335, 6267336, 6267337, 6267338, 6267339, 6267340, 6267341, 6267342, 6267343, 6267344, 6267345, 6267346, 6267347, 6267348, 6267349, 6267350, 6267351, 6267352, 6267353, 6267354, 6267355, 6267356, 6267357, 6267358, 6267359, 6267360, 6267361, 6267362, 6267363, 6267364, 6267365, 6267366, 6267367, 6267368, 6267369, 6267370, 6267371, 6267372, 6267373, 6267374, 6267375, 6267376, 6267377, 6267378, 6267379, 6267380, 6267381, 6267382, 6267383, 6267384, 6399607, 6399608, 6399609, 6560570, 6560573, 6560574, 6560576, 6560579, 6560580, 6560581, 6560582, 6560583, 6560584, 6560585, 6560586, 6560587, 6560588, 6560589, 6560590, 6560591, 6560592, 6560593, 6560594, 6560595, 6560596, 6560597, 6560598, 6560599, 6560600, 6560601, 6560602, 6560603, 6560604, 6560605, 6560606, 6560607, 6560608, 6560609, 6560610, 6560611, 6560612, 6560613, 6560614, 6560615, 6560616, 6560617, 6560618, 6560619, 6560620, 6560621, 6560622, 6560623, 6560624, 6560625, 6560626, 6560627, 6560628, 6560629, 6560630, 6560631, 6560632, 6560633, 6560634, 6560635, 6560636, 6560637, 6560638, 6560639, 6560640, 6560641, 6560642, 6560643, 6560644, 6560645, 6560646, 6560647, 6560648, 6560649, 6560650, 6560651, 6560652, 6560653, 6560654, 6560655, 6560656, 6560657, 6560658, 6560659, 6560660, 6560661, 6560662, 6560663, 6560664, 6560665, 6560666, 6560667, 6560668, 6560669, 6560670, 6560671, 6560672, 6560673, 6560674, 6560675, 6560676, 6560677, 6560678, 6560679, 6560680, 6560681, 6560682, 6560683, 6560684, 6560685, 6560686, 6560687, 6560688, 6560689, 6560690, 6560691, 6560692, 6560693, 6560694, 6560695, 6560696, 6560697, 6560698, 6560699, 6560700, 6560701, 6560702, 6560703, 6560704, 6560705, 6560706, 6560707, 6560708, 6560709, 6560710, 6560711, 6560712, 6560713, 6560714, 6560716, 6560717, 6560718, 6560719, 6560720, 6560721, 6560722, 6560723, 6560724, 6560725, 6560726, 6560727, 6560728, 6560729, 6560730, 6560731, 6560732, 6560733, 6560734, 6560735, 6560736, 6560737, 6560738, 6560739, 6560740, 6560741, 6560742, 6560743, 6560744, 6560745, 6560746, 6560747, 6560748, 6560749, 6560750, 6560751, 6560752, 6560753, 6560754, 6560755, 6560756, 6560757, 6560758, 6560759, 6560760, 6560761, 6560762, 6560763, 6560764, 6560765, 6560766, 6560767, 6560769, 6560770, 6560771, 6560571, 6560572, 6560575, 6560577, 6560715, 6560768, 6560578, 6600000, 6618009, 6618010, 6618011, 6618012, 6618037, 6618038, 6618040, 6618107, 6618108, 6618109, 6618131, 6618132, 6618133, 6618134, 6618135, 6618145, 6618146, 6618147, 6618148, 6618149, 6618150, 6618157, 6618158, 6618159, 6618160, 6618161, 6618162, 6618163, 6618165, 6618166, 6618219, 6618220, 6618233, 6618234, 6618235, 6618237, 6618238, 6618239, 6618240, 6618241, 6618242, 6618243, 6618244, 6618245, 6618247, 6618248, 6618249, 6618250, 6618251, 6618252, 6618253, 6618254, 6618255, 6618256, 6618257, 6618258, 6618259, 6618260, 6618261, 6618262, 6618263, 6618264, 6618265, 6618273, 6618279, 6618280, 6618281, 6618282, 6618290, 6618291, 6618292, 6618293, 6618294, 6618360, 6618361, 6618362, 6618666, 6618751, 6619065, 6619090, 6619370, 6619402, 6619403, 6619614, 6619632, 6619987, 6620060, 6620111, 6620177, 6620190, 6621461, 6831806, 6831807, 6831827, 6831837, 6831838, 6831842, 6831843, 6831844, 6831854, 6831861, 6832204, 6832257, 6832689, 6832690, 6832691, 6832692, 6832695, 6832698, 6832699, 6832700, 6832701, 6832702, 6832703, 6832704, 6832706, 6832707, 6832708, 6832709, 6832710, 6832712, 6832713, 6832714, 6832715, 6832716, 6832717, 6832718, 6835753, 6835754, 6835755, 6835756, 6835757, 6835758, 6835759, 6835760, 6835771, 6835772, 6835905, 6835906, 6835907, 6835908, 6835925, 6835926, 6835927, 6835928, 6835929, 6835930, 6835931, 6835932, 6835933, 6835934, 6835935, 6835936, 6835937, 6835938, 6835939, 6835940, 6835941, 6835942, 6835943, 6835951, 6835952, 6835953, 6835993, 6835994, 6835995, 6835996, 6835997, 6835998, 6836341, 6836393, 6837935, 6837936, 6837937, 6998056, 6998059, 6998066, 6998067, 6998068, 6998089, 6998090, 6998091, 6998155, 6998156, 6998277, 6998294, 6998334, 6998335, 6998336, 6999290, 7031440, 7031441, 7031464, 7031465, 7031466, 7031467, 7031468, 7031469, 7031470, 7031483, 7031484, 7031485, 7031486, 7031487, 7031488, 7031489, 7031490, 7031510, 7031511, 7031512, 7031513, 7031514, 7031515, 7031516, 7031517, 7031523, 7031524, 7031525, 7031552, 7031553, 7031554, 7031778, 7031779, 7031780, 7031781, 7031782, 7031783, 7031784, 7031785, 7031786, 7031787, 7031788, 7031789, 7031790, 7031791, 7031792, 7031793, 7031802, 7031803, 7031804, 7031805, 7031806, 7031807, 7031808, 7031809, 7031810, 7031811, 7031812, 7031813, 7031821, 7031822, 7031823, 7031824, 7078282, 7078283, 7078284, 7078285, 7078311, 7078312, 7078313, 7078314, 7078315, 7078316, 7078317, 7078318, 7078319, 7078320, 7078321, 7078322, 7078323, 7078324, 7078325, 7078326, 7078327, 7078328, 7078329, 7078330, 7078331, 7078332, 7078333, 7078334, 7078335, 7078336, 7078337, 7078349, 7078350, 7078351, 7078352, 7078353, 7078363, 7078364, 7078365, 7078366, 7078367, 7078368, 7078369, 7078370, 7078371, 7078372, 7078373, 7078374, 7078375, 7078376, 7078401, 7078402, 7078403, 7078404, 7078405, 7078406, 7078407, 7078408, 7078409, 7078410, 7078430, 7078431, 7078432, 7078433, 7078434, 7078435, 7078436, 7078437, 7078438, 7078439, 7078440, 7078441, 7078442, 7078443, 7078444, 7078445, 7078446, 7078447, 7078448, 7078466, 7078467, 7078468, 7078469, 7078470, 7078471, 7078472, 7078473, 7078474, 7078475, 7078476, 7078477, 7078507, 7078508, 7078509, 7078510, 7078511, 7078512, 7078536, 7078537, 7078538, 7078539, 7078540, 7078541, 7078542, 7078543, 7078544, 7078545, 7078546, 7078547, 7078548, 7078549, 7078563, 7078570, 7078606, 7078607, 7078608, 7078609, 7078610, 7078635, 7078659, 7078708) group by `varCity` order by `event_count` desc limit 12 offset 0
8.04ms/packages/Powerpanel/Performers/src/Controllers/PerformerController.php:218etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
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 (6245236, 6245237, 6245238, 6245239, 6245240, 6245241, 6245242, 6245243, 6245244, 6245245, 6245246, 6245247, 6245248, 6245249, 6245250, 6245251, 6245252, 6245253, 6245254, 6245255, 6245256, 6245257, 6245258, 6245259, 6245260, 6245261, 6245262, 6267310, 6267311, 6267312, 6267313, 6267314, 6267315, 6267316, 6267317, 6267318, 6267319, 6267320, 6267321, 6267322, 6267323, 6267324, 6267325, 6267326, 6267327, 6267328, 6267329, 6267330, 6267331, 6267332, 6267333, 6267334, 6267335, 6267336, 6267337, 6267338, 6267339, 6267340, 6267341, 6267342, 6267343, 6267344, 6267345, 6267346, 6267347, 6267348, 6267349, 6267350, 6267351, 6267352, 6267353, 6267354, 6267355, 6267356, 6267357, 6267358, 6267359, 6267360, 6267361, 6267362, 6267363, 6267364, 6267365, 6267366, 6267367, 6267368, 6267369, 6267370, 6267371, 6267372, 6267373, 6267374, 6267375, 6267376, 6267377, 6267378, 6267379, 6267380, 6267381, 6267382, 6267383, 6267384, 6399607, 6399608, 6399609, 6560570, 6560573, 6560574, 6560576, 6560579, 6560580, 6560581, 6560582, 6560583, 6560584, 6560585, 6560586, 6560587, 6560588, 6560589, 6560590, 6560591, 6560592, 6560593, 6560594, 6560595, 6560596, 6560597, 6560598, 6560599, 6560600, 6560601, 6560602, 6560603, 6560604, 6560605, 6560606, 6560607, 6560608, 6560609, 6560610, 6560611, 6560612, 6560613, 6560614, 6560615, 6560616, 6560617, 6560618, 6560619, 6560620, 6560621, 6560622, 6560623, 6560624, 6560625, 6560626, 6560627, 6560628, 6560629, 6560630, 6560631, 6560632, 6560633, 6560634, 6560635, 6560636, 6560637, 6560638, 6560639, 6560640, 6560641, 6560642, 6560643, 6560644, 6560645, 6560646, 6560647, 6560648, 6560649, 6560650, 6560651, 6560652, 6560653, 6560654, 6560655, 6560656, 6560657, 6560658, 6560659, 6560660, 6560661, 6560662, 6560663, 6560664, 6560665, 6560666, 6560667, 6560668, 6560669, 6560670, 6560671, 6560672, 6560673, 6560674, 6560675, 6560676, 6560677, 6560678, 6560679, 6560680, 6560681, 6560682, 6560683, 6560684, 6560685, 6560686, 6560687, 6560688, 6560689, 6560690, 6560691, 6560692, 6560693, 6560694, 6560695, 6560696, 6560697, 6560698, 6560699, 6560700, 6560701, 6560702, 6560703, 6560704, 6560705, 6560706, 6560707, 6560708, 6560709, 6560710, 6560711, 6560712, 6560713, 6560714, 6560716, 6560717, 6560718, 6560719, 6560720, 6560721, 6560722, 6560723, 6560724, 6560725, 6560726, 6560727, 6560728, 6560729, 6560730, 6560731, 6560732, 6560733, 6560734, 6560735, 6560736, 6560737, 6560738, 6560739, 6560740, 6560741, 6560742, 6560743, 6560744, 6560745, 6560746, 6560747, 6560748, 6560749, 6560750, 6560751, 6560752, 6560753, 6560754, 6560755, 6560756, 6560757, 6560758, 6560759, 6560760, 6560761, 6560762, 6560763, 6560764, 6560765, 6560766, 6560767, 6560769, 6560770, 6560771, 6560571, 6560572, 6560575, 6560577, 6560715, 6560768, 6560578, 6600000, 6618009, 6618010, 6618011, 6618012, 6618037, 6618038, 6618040, 6618107, 6618108, 6618109, 6618131, 6618132, 6618133, 6618134, 6618135, 6618145, 6618146, 6618147, 6618148, 6618149, 6618150, 6618157, 6618158, 6618159, 6618160, 6618161, 6618162, 6618163, 6618165, 6618166, 6618219, 6618220, 6618233, 6618234, 6618235, 6618237, 6618238, 6618239, 6618240, 6618241, 6618242, 6618243, 6618244, 6618245, 6618247, 6618248, 6618249, 6618250, 6618251, 6618252, 6618253, 6618254, 6618255, 6618256, 6618257, 6618258, 6618259, 6618260, 6618261, 6618262, 6618263, 6618264, 6618265, 6618273, 6618279, 6618280, 6618281, 6618282, 6618290, 6618291, 6618292, 6618293, 6618294, 6618360, 6618361, 6618362, 6618666, 6618751, 6619065, 6619090, 6619370, 6619402, 6619403, 6619614, 6619632, 6619987, 6620060, 6620111, 6620177, 6620190, 6621461, 6831806, 6831807, 6831827, 6831837, 6831838, 6831842, 6831843, 6831844, 6831854, 6831861, 6832204, 6832257, 6832689, 6832690, 6832691, 6832692, 6832695, 6832698, 6832699, 6832700, 6832701, 6832702, 6832703, 6832704, 6832706, 6832707, 6832708, 6832709, 6832710, 6832712, 6832713, 6832714, 6832715, 6832716, 6832717, 6832718, 6835753, 6835754, 6835755, 6835756, 6835757, 6835758, 6835759, 6835760, 6835771, 6835772, 6835905, 6835906, 6835907, 6835908, 6835925, 6835926, 6835927, 6835928, 6835929, 6835930, 6835931, 6835932, 6835933, 6835934, 6835935, 6835936, 6835937, 6835938, 6835939, 6835940, 6835941, 6835942, 6835943, 6835951, 6835952, 6835953, 6835993, 6835994, 6835995, 6835996, 6835997, 6835998, 6836341, 6836393, 6837935, 6837936, 6837937, 6998056, 6998059, 6998066, 6998067, 6998068, 6998089, 6998090, 6998091, 6998155, 6998156, 6998277, 6998294, 6998334, 6998335, 6998336, 6999290, 7031440, 7031441, 7031464, 7031465, 7031466, 7031467, 7031468, 7031469, 7031470, 7031483, 7031484, 7031485, 7031486, 7031487, 7031488, 7031489, 7031490, 7031510, 7031511, 7031512, 7031513, 7031514, 7031515, 7031516, 7031517, 7031523, 7031524, 7031525, 7031552, 7031553, 7031554, 7031778, 7031779, 7031780, 7031781, 7031782, 7031783, 7031784, 7031785, 7031786, 7031787, 7031788, 7031789, 7031790, 7031791, 7031792, 7031793, 7031802, 7031803, 7031804, 7031805, 7031806, 7031807, 7031808, 7031809, 7031810, 7031811, 7031812, 7031813, 7031821, 7031822, 7031823, 7031824, 7078282, 7078283, 7078284, 7078285, 7078311, 7078312, 7078313, 7078314, 7078315, 7078316, 7078317, 7078318, 7078319, 7078320, 7078321, 7078322, 7078323, 7078324, 7078325, 7078326, 7078327, 7078328, 7078329, 7078330, 7078331, 7078332, 7078333, 7078334, 7078335, 7078336, 7078337, 7078349, 7078350, 7078351, 7078352, 7078353, 7078363, 7078364, 7078365, 7078366, 7078367, 7078368, 7078369, 7078370, 7078371, 7078372, 7078373, 7078374, 7078375, 7078376, 7078401, 7078402, 7078403, 7078404, 7078405, 7078406, 7078407, 7078408, 7078409, 7078410, 7078430, 7078431, 7078432, 7078433, 7078434, 7078435, 7078436, 7078437, 7078438, 7078439, 7078440, 7078441, 7078442, 7078443, 7078444, 7078445, 7078446, 7078447, 7078448, 7078466, 7078467, 7078468, 7078469, 7078470, 7078471, 7078472, 7078473, 7078474, 7078475, 7078476, 7078477, 7078507, 7078508, 7078509, 7078510, 7078511, 7078512, 7078536, 7078537, 7078538, 7078539, 7078540, 7078541, 7078542, 7078543, 7078544, 7078545, 7078546, 7078547, 7078548, 7078549, 7078563, 7078570, 7078606, 7078607, 7078608, 7078609, 7078610, 7078635, 7078659, 7078708) and date(`dtEventDate`) >= '2025-05-05' order by `dtEventDate` asc limit 12
8.3ms/app/Events.php:380etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `nq_events` where `dtEventDate` between '2025-05-05 16:44:39' and '2025-12-31 23:59:59' and (`chrDelete` = 'N') and `fkeventGlcode` in (6245236, 6245237, 6245238, 6245239, 6245240, 6245241, 6245242, 6245243, 6245244, 6245245, 6245246, 6245247, 6245248, 6245249, 6245250, 6245251, 6245252, 6245253, 6245254, 6245255, 6245256, 6245257, 6245258, 6245259, 6245260, 6245261, 6245262, 6267310, 6267311, 6267312, 6267313, 6267314, 6267315, 6267316, 6267317, 6267318, 6267319, 6267320, 6267321, 6267322, 6267323, 6267324, 6267325, 6267326, 6267327, 6267328, 6267329, 6267330, 6267331, 6267332, 6267333, 6267334, 6267335, 6267336, 6267337, 6267338, 6267339, 6267340, 6267341, 6267342, 6267343, 6267344, 6267345, 6267346, 6267347, 6267348, 6267349, 6267350, 6267351, 6267352, 6267353, 6267354, 6267355, 6267356, 6267357, 6267358, 6267359, 6267360, 6267361, 6267362, 6267363, 6267364, 6267365, 6267366, 6267367, 6267368, 6267369, 6267370, 6267371, 6267372, 6267373, 6267374, 6267375, 6267376, 6267377, 6267378, 6267379, 6267380, 6267381, 6267382, 6267383, 6267384, 6399607, 6399608, 6399609, 6560570, 6560573, 6560574, 6560576, 6560579, 6560580, 6560581, 6560582, 6560583, 6560584, 6560585, 6560586, 6560587, 6560588, 6560589, 6560590, 6560591, 6560592, 6560593, 6560594, 6560595, 6560596, 6560597, 6560598, 6560599, 6560600, 6560601, 6560602, 6560603, 6560604, 6560605, 6560606, 6560607, 6560608, 6560609, 6560610, 6560611, 6560612, 6560613, 6560614, 6560615, 6560616, 6560617, 6560618, 6560619, 6560620, 6560621, 6560622, 6560623, 6560624, 6560625, 6560626, 6560627, 6560628, 6560629, 6560630, 6560631, 6560632, 6560633, 6560634, 6560635, 6560636, 6560637, 6560638, 6560639, 6560640, 6560641, 6560642, 6560643, 6560644, 6560645, 6560646, 6560647, 6560648, 6560649, 6560650, 6560651, 6560652, 6560653, 6560654, 6560655, 6560656, 6560657, 6560658, 6560659, 6560660, 6560661, 6560662, 6560663, 6560664, 6560665, 6560666, 6560667, 6560668, 6560669, 6560670, 6560671, 6560672, 6560673, 6560674, 6560675, 6560676, 6560677, 6560678, 6560679, 6560680, 6560681, 6560682, 6560683, 6560684, 6560685, 6560686, 6560687, 6560688, 6560689, 6560690, 6560691, 6560692, 6560693, 6560694, 6560695, 6560696, 6560697, 6560698, 6560699, 6560700, 6560701, 6560702, 6560703, 6560704, 6560705, 6560706, 6560707, 6560708, 6560709, 6560710, 6560711, 6560712, 6560713, 6560714, 6560716, 6560717, 6560718, 6560719, 6560720, 6560721, 6560722, 6560723, 6560724, 6560725, 6560726, 6560727, 6560728, 6560729, 6560730, 6560731, 6560732, 6560733, 6560734, 6560735, 6560736, 6560737, 6560738, 6560739, 6560740, 6560741, 6560742, 6560743, 6560744, 6560745, 6560746, 6560747, 6560748, 6560749, 6560750, 6560751, 6560752, 6560753, 6560754, 6560755, 6560756, 6560757, 6560758, 6560759, 6560760, 6560761, 6560762, 6560763, 6560764, 6560765, 6560766, 6560767, 6560769, 6560770, 6560771, 6560571, 6560572, 6560575, 6560577, 6560715, 6560768, 6560578, 6600000, 6618009, 6618010, 6618011, 6618012, 6618037, 6618038, 6618040, 6618107, 6618108, 6618109, 6618131, 6618132, 6618133, 6618134, 6618135, 6618145, 6618146, 6618147, 6618148, 6618149, 6618150, 6618157, 6618158, 6618159, 6618160, 6618161, 6618162, 6618163, 6618165, 6618166, 6618219, 6618220, 6618233, 6618234, 6618235, 6618237, 6618238, 6618239, 6618240, 6618241, 6618242, 6618243, 6618244, 6618245, 6618247, 6618248, 6618249, 6618250, 6618251, 6618252, 6618253, 6618254, 6618255, 6618256, 6618257, 6618258, 6618259, 6618260, 6618261, 6618262, 6618263, 6618264, 6618265, 6618273, 6618279, 6618280, 6618281, 6618282, 6618290, 6618291, 6618292, 6618293, 6618294, 6618360, 6618361, 6618362, 6618666, 6618751, 6619065, 6619090, 6619370, 6619402, 6619403, 6619614, 6619632, 6619987, 6620060, 6620111, 6620177, 6620190, 6621461, 6831806, 6831807, 6831827, 6831837, 6831838, 6831842, 6831843, 6831844, 6831854, 6831861, 6832204, 6832257, 6832689, 6832690, 6832691, 6832692, 6832695, 6832698, 6832699, 6832700, 6832701, 6832702, 6832703, 6832704, 6832706, 6832707, 6832708, 6832709, 6832710, 6832712, 6832713, 6832714, 6832715, 6832716, 6832717, 6832718, 6835753, 6835754, 6835755, 6835756, 6835757, 6835758, 6835759, 6835760, 6835771, 6835772, 6835905, 6835906, 6835907, 6835908, 6835925, 6835926, 6835927, 6835928, 6835929, 6835930, 6835931, 6835932, 6835933, 6835934, 6835935, 6835936, 6835937, 6835938, 6835939, 6835940, 6835941, 6835942, 6835943, 6835951, 6835952, 6835953, 6835993, 6835994, 6835995, 6835996, 6835997, 6835998, 6836341, 6836393, 6837935, 6837936, 6837937, 6998056, 6998059, 6998066, 6998067, 6998068, 6998089, 6998090, 6998091, 6998155, 6998156, 6998277, 6998294, 6998334, 6998335, 6998336, 6999290, 7031440, 7031441, 7031464, 7031465, 7031466, 7031467, 7031468, 7031469, 7031470, 7031483, 7031484, 7031485, 7031486, 7031487, 7031488, 7031489, 7031490, 7031510, 7031511, 7031512, 7031513, 7031514, 7031515, 7031516, 7031517, 7031523, 7031524, 7031525, 7031552, 7031553, 7031554, 7031778, 7031779, 7031780, 7031781, 7031782, 7031783, 7031784, 7031785, 7031786, 7031787, 7031788, 7031789, 7031790, 7031791, 7031792, 7031793, 7031802, 7031803, 7031804, 7031805, 7031806, 7031807, 7031808, 7031809, 7031810, 7031811, 7031812, 7031813, 7031821, 7031822, 7031823, 7031824, 7078282, 7078283, 7078284, 7078285, 7078311, 7078312, 7078313, 7078314, 7078315, 7078316, 7078317, 7078318, 7078319, 7078320, 7078321, 7078322, 7078323, 7078324, 7078325, 7078326, 7078327, 7078328, 7078329, 7078330, 7078331, 7078332, 7078333, 7078334, 7078335, 7078336, 7078337, 7078349, 7078350, 7078351, 7078352, 7078353, 7078363, 7078364, 7078365, 7078366, 7078367, 7078368, 7078369, 7078370, 7078371, 7078372, 7078373, 7078374, 7078375, 7078376, 7078401, 7078402, 7078403, 7078404, 7078405, 7078406, 7078407, 7078408, 7078409, 7078410, 7078430, 7078431, 7078432, 7078433, 7078434, 7078435, 7078436, 7078437, 7078438, 7078439, 7078440, 7078441, 7078442, 7078443, 7078444, 7078445, 7078446, 7078447, 7078448, 7078466, 7078467, 7078468, 7078469, 7078470, 7078471, 7078472, 7078473, 7078474, 7078475, 7078476, 7078477, 7078507, 7078508, 7078509, 7078510, 7078511, 7078512, 7078536, 7078537, 7078538, 7078539, 7078540, 7078541, 7078542, 7078543, 7078544, 7078545, 7078546, 7078547, 7078548, 7078549, 7078563, 7078570, 7078606, 7078607, 7078608, 7078609, 7078610, 7078635, 7078659, 7078708) and date(`dtEventDate`) >= '2025-05-05'
7.48ms/app/Events.php:338etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from (select `nq_peformers`.`intCategoryId`, `nq_peformers`.`varTitle`, `nq_peformers`.`intAliasId` from `nq_peformers` where `nq_peformers`.`chrPublish` = 'Y' and `nq_peformers`.`chrDelete` = 'N' and `nq_peformers`.`intParentCatId` = 'NJ' and `nq_peformers`.`intChildCatId` = 47574 and `nq_peformers`.`total_count` != 0 group by `nq_peformers`.`id`) as `aggregate_table`
1.19ms/packages/Powerpanel/Performers/src/Models/Performers.php:202etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intAliasId`, `varTitle`, `txtDescription`, `fkIntImgId`, `intCategoryId`, `intParentCatId`, `intChildCatId` from `nq_peformers` where `chrPublish` = 'Y' and `chrDelete` = 'N' and `intAliasId` = 47574 limit 1
1.21ms/packages/Powerpanel/Performers/src/Models/Performers.php:1299etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `varTitle`, `intCategoryId` from `nq_categories` where `intCategoryId` = 3 limit 1
980μs/packages/Powerpanel/Categories/src/Models/Categories.php:962etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `varTitle`, `intCategoryId` from `nq_categories` where `intCategoryId` = 74 and `intParentCategoryId` = 3 limit 1
980μs/packages/Powerpanel/Categories/src/Models/Categories.php:975etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Atlantic City') and (`varStateProvince` = 'NJ') limit 1
1.73ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101858 and `chrIsPreview` = 'N' limit 1
900μs/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
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 `chrIsPrimary` = 'Y' and (`chrDelete` = 'N') and (`chrPublish` = 'Y')
1ms/packages/Powerpanel/ContactInfo/src/Models/ContactInfo.php:111etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
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 `chrIsPrimary` = 'Y' and (`chrDelete` = 'N') and (`chrPublish` = 'Y')
1.13ms/packages/Powerpanel/ContactInfo/src/Models/ContactInfo.php:111etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
200
[]
[]
0 of 0array: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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "close" ] "x-forwarded-for" => array:1 [▶ 0 => "18.217.131.249" ] "x-real-ip" => array:1 [▶ 0 => "18.217.131.249" ] "x-forwarded-host" => array:1 [▶ 0 => "cron.etickets.ca" ] "host" => array:1 [▶ 0 => "cron.etickets.ca" ] "content-length" => array:1 [▶ 0 => "" ] "content-type" => array:1 [▶ 0 => "" ] ]
0 of 0array:58 [▼ "USER" => "etickets-cron" "HOME" => "/home/etickets-cron" "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_CONNECTION" => "close" "HTTP_X_FORWARDED_FOR" => "18.217.131.249" "HTTP_X_REAL_IP" => "18.217.131.249" "HTTP_X_FORWARDED_HOST" => "cron.etickets.ca" "HTTP_HOST" => "cron.etickets.ca" "PHP_VALUE" => """ \n error_log=/home/etickets-cron/logs/php/error.log;\n memory_limit=512M;\n max_execution_time=60;\n max_input_time=60;\n max_input_vars=10000;\n post_max_size=64M;\n upload_max_filesize=64M;\n date.timezone=UTC;\n display_errors=off; """ "HTTPS" => true "MGT" => "1" "GEOIP_LONGITUDE" => "-71.1028" "GEOIP_LATITUDE" => "42.3646" "GEOIP_CITY_CONTINENT_CODE" => "NA" "GEOIP_POSTAL_CODE" => "02139" "GEOIP_CITY" => "Cambridge" "GEOIP_REGION" => "MA" "GEOIP_CITY_COUNTRY_NAME" => "United States" "GEOIP_CITY_COUNTRY_CODE3" => "USA" "GEOIP_CITY_COUNTRY_CODE" => "US" "GEOIP_COUNTRY_NAME" => "United States" "GEOIP_COUNTRY_CODE3" => "USA" "GEOIP_COUNTRY_CODE" => "US" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "cron.etickets.ca" "SERVER_PORT" => "443" "SERVER_ADDR" => "127.0.0.1" "REMOTE_PORT" => "" "REMOTE_ADDR" => "18.217.131.249" "SERVER_SOFTWARE" => "nginx/1.21.4" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.0" "DOCUMENT_ROOT" => "/home/etickets-cron/htdocs/cron.etickets.ca/public_html" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/performers/the-hook-tickets" "SCRIPT_NAME" => "/index.php" "SCRIPT_FILENAME" => "/home/etickets-cron/htdocs/cron.etickets.ca/public_html/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746481479.504 "REQUEST_TIME" => 1746481479 ]
[]
0 of 0array:7 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "private, must-revalidate" ] "date" => array:1 [▶ 0 => "Mon, 05 May 2025 21:44:39 GMT" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => "-1" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlNScmlVZzRoV1B0aHFVZXFtZDBpVFE9PSIsInZhbHVlIjoiT1hMbGNDczlhT1pGWEZjTVJpVkFBNFZwZkNpRFROSTZ6dkFMM1FUYzhRWTl4RUExNjUwTlV1OG9vdzJXYjFpSHhDeEFQSXhzRWh2ODNETWc0K0NVMURuQmpyMFRNSnFQN3R3VTJ5cmdBMXJLa3pQeThrWURYTnNUZXVON3Q5c3MiLCJtYWMiOiJhNTlhYjQ3OGFhNGRmMTk4NTRmOGVhOTU5MzNjYzE0NmIzMjgwMWQzM2I3YTg4NjQzZTMyN2I0YTM4N2MyYzFhIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 23:44:39 GMT; Max-Age=7200; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlNScmlVZzRoV1B0aHFVZXFtZDBpVFE9PSIsInZhbHVlIjoiT1hMbGNDczlhT1pGWEZjTVJpVkFBNFZwZkNpRFROSTZ6dkFMM1FUYzhRWTl4RUExNjUwTlV1OG9vdzJXYjFpSHhDeEFQS ▶" 1 => "recently_viewed=Fhk5lzLOh3fgKchJ1yKt; expires=Tue, 06 May 2025 21:44:39 GMT; Max-Age=86400; path=/; secure; httponly" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlNScmlVZzRoV1B0aHFVZXFtZDBpVFE9PSIsInZhbHVlIjoiT1hMbGNDczlhT1pGWEZjTVJpVkFBNFZwZkNpRFROSTZ6dkFMM1FUYzhRWTl4RUExNjUwTlV1OG9vdzJXYjFpSHhDeEFQSXhzRWh2ODNETWc0K0NVMURuQmpyMFRNSnFQN3R3VTJ5cmdBMXJLa3pQeThrWURYTnNUZXVON3Q5c3MiLCJtYWMiOiJhNTlhYjQ3OGFhNGRmMTk4NTRmOGVhOTU5MzNjYzE0NmIzMjgwMWQzM2I3YTg4NjQzZTMyN2I0YTM4N2MyYzFhIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 23:44:39 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlNScmlVZzRoV1B0aHFVZXFtZDBpVFE9PSIsInZhbHVlIjoiT1hMbGNDczlhT1pGWEZjTVJpVkFBNFZwZkNpRFROSTZ6dkFMM1FUYzhRWTl4RUExNjUwTlV1OG9vdzJXYjFpSHhDeEFQS ▶" 1 => "recently_viewed=Fhk5lzLOh3fgKchJ1yKt; expires=Tue, 06-May-2025 21:44:39 GMT; path=/; secure; httponly" ] ]
0 of 0array:2 [▼ "_token" => "tJbxV4zklEm62ZGuFCXbbmxgIeLVL8cKk2Ral9cE" "PHPDEBUGBAR_STACK_DATA" => [] ]