eTickets.ca takes pride in offering you a seamless way to witness the electrifying performance of your favorite team or player, Harry Potter and The Cursed Child 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 Harry Potter and The Cursed Child live. Keep an eye on the.Harry Potter and The Cursed Childtheatre 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 Harry Potter and The Cursed Child'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 (63.24%) | 266.86ms |
1 x Booting (36.74%) | 155.06ms |
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
8.24ms/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.15ms/packages/Powerpanel/Menu/src/Models/Menu.php:233etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'harry-potter-and-the-cursed-child-tickets' limit 1
1.11ms/app/Alias.php:35etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 17174 and `chrIsPreview` = 'N' limit 1
1.03ms/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` = 17174 and (`chrDelete` = 'N') limit 1
1.03ms/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')
970μs/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
5.59ms/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.25ms/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
1.07ms/packages/Powerpanel/Offer/src/Models/Offer.php:66etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'harry-potter-and-the-cursed-child-tickets' limit 1
980μs/app/Alias.php:35etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intCategoryId` from `nq_peformers` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `intAliasId` = 17174 limit 1
1.11ms/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` = 17174 limit 1
1.07ms/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` = 17174 limit 1
1.07ms/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` = 16164 and `fkModuleId` = 158
1.29ms/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` = 38 and `nq_event_performers`.`performerid` = 74268 and `nq_events`.`chrDelete` = 'N'
16.27ms/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 (6207446, 6207447, 6207448, 6207459, 6207460, 6207461, 6207462, 6208659, 6208660, 6208661, 6208662, 6208663, 6208664, 6208665, 6208666, 6208667, 6208668, 6208669, 6208670, 6208671, 6208672, 6208673, 6208674, 6208675, 6208676, 6208677, 6208678, 6208679, 6208680, 6208681, 6208682, 6208683, 6208684, 6208685, 6208686, 6208687, 6208688, 6208689, 6208690, 6208691, 6208692, 6208693, 6208694, 6208695, 6208696, 6208697, 6208698, 6208699, 6208700, 6208701, 6208702, 6208703, 6208704, 6208705, 6208706, 6208707, 6208708, 6208709, 6208710, 6208711, 6208712, 6208713, 6208714, 6208715, 6208716, 6208717, 6208718, 6208719, 6208720, 6208721, 6234836, 6234837, 6234838, 6234839, 6234840, 6234841, 6234842, 6234843, 6234844, 6234845, 6234846, 6234847, 6255596, 6255597, 6255598, 6255599, 6255600, 6255601, 6255602, 6255603, 6255604, 6255605, 6255606, 6255607, 6255608, 6255609, 6255610, 6255611, 6255612, 6255613, 6255614, 6255615, 6255616, 6255617, 6255618, 6255619, 6255620, 6255621, 6255622, 6255623, 6255624, 6255625, 6255626, 6255627, 6255628, 6255629, 6255630, 6255631, 6255632, 6255633, 6255634, 6255635, 6255636, 6255637, 6255638, 6255639, 6255640, 6255641, 6255642, 6255643, 6255644, 6255645, 6255646, 6274437, 6274438, 6274439, 6274440, 6274441, 6274442, 6281765, 6281766, 6281767, 6281768, 6281769, 6281770, 6284810, 6284811, 6284812, 6284813, 6284814, 6284815, 6284816, 6284817, 6284818, 6284819, 6284820, 6284821, 6284822, 6284823, 6284824, 6284825, 6284826, 6284827, 6284828, 6284829, 6284830, 6284831, 6284832, 6284833, 6284834, 6284835, 6284836, 6284837, 6284838, 6284839, 6284840, 6284841, 6284842, 6284843, 6284844, 6284845, 6284846, 6284847, 6284848, 6284849, 6284850, 6284851, 6284852, 6284853, 6284854, 6284855, 6284856, 6284857, 6284858, 6284859, 6284860, 6284861, 6284862, 6284863, 6284864, 6284865, 6284866, 6284867, 6284868, 6284869, 6284870, 6284871, 6284872, 6284873, 6284874, 6284876, 6284877, 6284878, 6284879, 6284880, 6284881, 6284882, 6284883, 6284884, 6284885, 6284889, 6284890, 6284891, 6284892, 6284894, 6284895, 6284897, 6284898, 6284899, 6284900, 6284901, 6284902, 6284903, 6284904, 6284906, 6284907, 6284910, 6284911, 6284912, 6284913, 6284914, 6284915, 6284916, 6284917, 6284918, 6284919, 6284920, 6284921, 6284922, 6284923, 6284924, 6284925, 6284926, 6284927, 6284928, 6284929, 6284930, 6284931, 6284932, 6284933, 6284934, 6284935, 6284936, 6284937, 6284938, 6284939, 6284940, 6284941, 6284942, 6284943, 6284944, 6284945, 6284946, 6284947, 6284948, 6284949, 6284950, 6284952, 6284953, 6284954, 6284955, 6284956, 6284957, 6284958, 6284959, 6284960, 6284962, 6284964, 6284965, 6284967, 6284968, 6284970, 6284971, 6284973, 6284974, 6295794, 6295795, 6295796, 6295801, 6295819, 6295820, 6295852, 6295854, 6344521, 6344522, 6344523, 6344524, 6425092, 6425093, 6425094, 6425095, 6425096, 6425097, 6425098, 6425099, 6425100, 6425101, 6425102, 6425103, 6425104, 6425105, 6425106, 6625233, 6625244, 6625245, 6625302, 6192410, 6187551, 6187553, 6669558, 6669559, 6669560, 6669563, 6669564, 6669565, 6669566, 6669567, 6187554, 6187559, 6187550, 6187552, 6187555, 6187556, 6187557, 6187558, 6187560, 6691949, 6754223, 6754224, 6754225, 6781854, 6782110, 6782948, 6882878, 6947433, 6947434, 6947435, 6947436, 6947437, 6947438, 6947440, 6947441, 6947442, 6947443, 6947444, 6947446, 6947447, 6947448, 6947449, 6947450, 6947452, 6947455, 6947456, 6947458, 6947460, 6947461, 6947463, 6947469, 6947472, 6947473, 6962535, 6962536, 6977361, 6977363, 6977364, 6977366, 6977367, 6977368, 6977369, 6977370, 6977371, 6977372, 6977373, 6977374, 6977375, 6977376, 6977377, 6977378, 6977379, 6977380, 6977381, 6977382, 6977383, 6977384, 6977385, 6977386, 6977387, 6977388, 6977389, 6977390, 6977391, 6977392, 6977393, 6977394, 6977395, 6993445, 6994060, 7009207, 7009208, 7009209, 7009210, 7009211, 7009212, 7009213, 7009214, 7009215, 7009216, 7009217, 7009218, 7009219, 7009220, 7009221, 7009222, 7009223, 7009224, 7009225, 7009226, 7009227, 7009228, 7009229, 7009230, 7009231, 7009232, 7009233, 7009234, 7009235, 7009236, 7009237, 7009238, 7009239, 7009240, 7009241, 7009242, 7009243, 7009244, 7009245, 7009246, 7009247, 7009248, 7009249, 7009250, 7009251, 7009252, 7009253, 7009254, 7009255, 7018997, 7018998, 7018999, 7019000, 7019001, 7019002, 7019003, 7019004, 7019005, 7019006, 7019007, 7019008, 7019009, 7019010, 7019011, 7020439, 7020440, 7020441, 7020442, 7020552, 7020553, 7020563, 7020565, 7020566, 7021021, 7021026, 7021028, 7021029, 7021030, 7021031, 7021032, 7021036, 7021038, 7021042, 7021043, 7021044, 7021051, 7021053, 7021055, 7021057, 7021058, 7021060, 7021061, 7021064, 7021067, 7021068, 7021071, 7021073, 7021075, 7021076, 7021077, 7021080, 7021083, 7021084, 7021085, 7021088, 7021089, 7021090, 7021091, 7021092, 7021094, 7021104, 7021105, 7021106, 7021107, 7021108, 7021109, 7021110, 7021111, 7021113, 7021115, 7021120, 7021121, 7021122, 7021123, 7021125, 7021128, 7021129, 7021130, 7021131, 7021132, 7021133, 7021134, 7021135, 7041266, 7041267, 7041268, 7041269, 7041270, 7041271, 7041272, 7041273, 7041274, 7041275, 7041276, 7041277, 7041278, 7041279, 7041280, 7041281, 7041282, 7041283, 7041284, 7041285, 7041286, 7041287, 7041288, 7041289, 7041290, 7041291, 7047349, 7047350, 7047351, 7047352, 7047353, 7047354, 7047355, 7047356, 7047357, 7047358, 7047359, 7047360, 7047361, 7047362, 7047363, 7047364, 7047365, 7047366, 7047367, 7047368, 7047369, 7047370, 7047371, 7047372, 7047373, 7063855, 7063856, 7063857, 7063858, 7063859, 7063860, 7063861, 7063862, 7063863, 7063864, 7063865, 7063866, 7063867, 7063868, 7063869, 7063870, 7063871, 7063872, 7063873, 7080638, 7081848, 7081935, 7081936, 7081937, 7081938, 7081939, 7081940, 7081941, 7081942, 7081943, 7081944, 7081945, 7081946, 7081947, 7081948, 7081949, 7081950, 7081951, 7081952, 7081953, 7081954, 7081955, 7081956, 7081957, 7081958, 7081959, 7081960, 7081961, 7081962, 7081963, 7081964, 7081965, 7081966, 7081967, 7082450, 7082451, 7082452, 7082453, 7082454, 7082455, 7082456, 7082457, 7082458, 7082459, 7082462, 7082463, 7082464, 7082465, 7082466, 7082467, 7082468, 7082469, 7082470, 7082471, 7082472, 7082473, 7082474, 7082475, 7082476, 7085387) group by `varCity`) as `aggregate_table`
8.81ms/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 (6207446, 6207447, 6207448, 6207459, 6207460, 6207461, 6207462, 6208659, 6208660, 6208661, 6208662, 6208663, 6208664, 6208665, 6208666, 6208667, 6208668, 6208669, 6208670, 6208671, 6208672, 6208673, 6208674, 6208675, 6208676, 6208677, 6208678, 6208679, 6208680, 6208681, 6208682, 6208683, 6208684, 6208685, 6208686, 6208687, 6208688, 6208689, 6208690, 6208691, 6208692, 6208693, 6208694, 6208695, 6208696, 6208697, 6208698, 6208699, 6208700, 6208701, 6208702, 6208703, 6208704, 6208705, 6208706, 6208707, 6208708, 6208709, 6208710, 6208711, 6208712, 6208713, 6208714, 6208715, 6208716, 6208717, 6208718, 6208719, 6208720, 6208721, 6234836, 6234837, 6234838, 6234839, 6234840, 6234841, 6234842, 6234843, 6234844, 6234845, 6234846, 6234847, 6255596, 6255597, 6255598, 6255599, 6255600, 6255601, 6255602, 6255603, 6255604, 6255605, 6255606, 6255607, 6255608, 6255609, 6255610, 6255611, 6255612, 6255613, 6255614, 6255615, 6255616, 6255617, 6255618, 6255619, 6255620, 6255621, 6255622, 6255623, 6255624, 6255625, 6255626, 6255627, 6255628, 6255629, 6255630, 6255631, 6255632, 6255633, 6255634, 6255635, 6255636, 6255637, 6255638, 6255639, 6255640, 6255641, 6255642, 6255643, 6255644, 6255645, 6255646, 6274437, 6274438, 6274439, 6274440, 6274441, 6274442, 6281765, 6281766, 6281767, 6281768, 6281769, 6281770, 6284810, 6284811, 6284812, 6284813, 6284814, 6284815, 6284816, 6284817, 6284818, 6284819, 6284820, 6284821, 6284822, 6284823, 6284824, 6284825, 6284826, 6284827, 6284828, 6284829, 6284830, 6284831, 6284832, 6284833, 6284834, 6284835, 6284836, 6284837, 6284838, 6284839, 6284840, 6284841, 6284842, 6284843, 6284844, 6284845, 6284846, 6284847, 6284848, 6284849, 6284850, 6284851, 6284852, 6284853, 6284854, 6284855, 6284856, 6284857, 6284858, 6284859, 6284860, 6284861, 6284862, 6284863, 6284864, 6284865, 6284866, 6284867, 6284868, 6284869, 6284870, 6284871, 6284872, 6284873, 6284874, 6284876, 6284877, 6284878, 6284879, 6284880, 6284881, 6284882, 6284883, 6284884, 6284885, 6284889, 6284890, 6284891, 6284892, 6284894, 6284895, 6284897, 6284898, 6284899, 6284900, 6284901, 6284902, 6284903, 6284904, 6284906, 6284907, 6284910, 6284911, 6284912, 6284913, 6284914, 6284915, 6284916, 6284917, 6284918, 6284919, 6284920, 6284921, 6284922, 6284923, 6284924, 6284925, 6284926, 6284927, 6284928, 6284929, 6284930, 6284931, 6284932, 6284933, 6284934, 6284935, 6284936, 6284937, 6284938, 6284939, 6284940, 6284941, 6284942, 6284943, 6284944, 6284945, 6284946, 6284947, 6284948, 6284949, 6284950, 6284952, 6284953, 6284954, 6284955, 6284956, 6284957, 6284958, 6284959, 6284960, 6284962, 6284964, 6284965, 6284967, 6284968, 6284970, 6284971, 6284973, 6284974, 6295794, 6295795, 6295796, 6295801, 6295819, 6295820, 6295852, 6295854, 6344521, 6344522, 6344523, 6344524, 6425092, 6425093, 6425094, 6425095, 6425096, 6425097, 6425098, 6425099, 6425100, 6425101, 6425102, 6425103, 6425104, 6425105, 6425106, 6625233, 6625244, 6625245, 6625302, 6192410, 6187551, 6187553, 6669558, 6669559, 6669560, 6669563, 6669564, 6669565, 6669566, 6669567, 6187554, 6187559, 6187550, 6187552, 6187555, 6187556, 6187557, 6187558, 6187560, 6691949, 6754223, 6754224, 6754225, 6781854, 6782110, 6782948, 6882878, 6947433, 6947434, 6947435, 6947436, 6947437, 6947438, 6947440, 6947441, 6947442, 6947443, 6947444, 6947446, 6947447, 6947448, 6947449, 6947450, 6947452, 6947455, 6947456, 6947458, 6947460, 6947461, 6947463, 6947469, 6947472, 6947473, 6962535, 6962536, 6977361, 6977363, 6977364, 6977366, 6977367, 6977368, 6977369, 6977370, 6977371, 6977372, 6977373, 6977374, 6977375, 6977376, 6977377, 6977378, 6977379, 6977380, 6977381, 6977382, 6977383, 6977384, 6977385, 6977386, 6977387, 6977388, 6977389, 6977390, 6977391, 6977392, 6977393, 6977394, 6977395, 6993445, 6994060, 7009207, 7009208, 7009209, 7009210, 7009211, 7009212, 7009213, 7009214, 7009215, 7009216, 7009217, 7009218, 7009219, 7009220, 7009221, 7009222, 7009223, 7009224, 7009225, 7009226, 7009227, 7009228, 7009229, 7009230, 7009231, 7009232, 7009233, 7009234, 7009235, 7009236, 7009237, 7009238, 7009239, 7009240, 7009241, 7009242, 7009243, 7009244, 7009245, 7009246, 7009247, 7009248, 7009249, 7009250, 7009251, 7009252, 7009253, 7009254, 7009255, 7018997, 7018998, 7018999, 7019000, 7019001, 7019002, 7019003, 7019004, 7019005, 7019006, 7019007, 7019008, 7019009, 7019010, 7019011, 7020439, 7020440, 7020441, 7020442, 7020552, 7020553, 7020563, 7020565, 7020566, 7021021, 7021026, 7021028, 7021029, 7021030, 7021031, 7021032, 7021036, 7021038, 7021042, 7021043, 7021044, 7021051, 7021053, 7021055, 7021057, 7021058, 7021060, 7021061, 7021064, 7021067, 7021068, 7021071, 7021073, 7021075, 7021076, 7021077, 7021080, 7021083, 7021084, 7021085, 7021088, 7021089, 7021090, 7021091, 7021092, 7021094, 7021104, 7021105, 7021106, 7021107, 7021108, 7021109, 7021110, 7021111, 7021113, 7021115, 7021120, 7021121, 7021122, 7021123, 7021125, 7021128, 7021129, 7021130, 7021131, 7021132, 7021133, 7021134, 7021135, 7041266, 7041267, 7041268, 7041269, 7041270, 7041271, 7041272, 7041273, 7041274, 7041275, 7041276, 7041277, 7041278, 7041279, 7041280, 7041281, 7041282, 7041283, 7041284, 7041285, 7041286, 7041287, 7041288, 7041289, 7041290, 7041291, 7047349, 7047350, 7047351, 7047352, 7047353, 7047354, 7047355, 7047356, 7047357, 7047358, 7047359, 7047360, 7047361, 7047362, 7047363, 7047364, 7047365, 7047366, 7047367, 7047368, 7047369, 7047370, 7047371, 7047372, 7047373, 7063855, 7063856, 7063857, 7063858, 7063859, 7063860, 7063861, 7063862, 7063863, 7063864, 7063865, 7063866, 7063867, 7063868, 7063869, 7063870, 7063871, 7063872, 7063873, 7080638, 7081848, 7081935, 7081936, 7081937, 7081938, 7081939, 7081940, 7081941, 7081942, 7081943, 7081944, 7081945, 7081946, 7081947, 7081948, 7081949, 7081950, 7081951, 7081952, 7081953, 7081954, 7081955, 7081956, 7081957, 7081958, 7081959, 7081960, 7081961, 7081962, 7081963, 7081964, 7081965, 7081966, 7081967, 7082450, 7082451, 7082452, 7082453, 7082454, 7082455, 7082456, 7082457, 7082458, 7082459, 7082462, 7082463, 7082464, 7082465, 7082466, 7082467, 7082468, 7082469, 7082470, 7082471, 7082472, 7082473, 7082474, 7082475, 7082476, 7085387) group by `varCity` order by `event_count` desc limit 12 offset 0
6.91ms/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 (6207446, 6207447, 6207448, 6207459, 6207460, 6207461, 6207462, 6208659, 6208660, 6208661, 6208662, 6208663, 6208664, 6208665, 6208666, 6208667, 6208668, 6208669, 6208670, 6208671, 6208672, 6208673, 6208674, 6208675, 6208676, 6208677, 6208678, 6208679, 6208680, 6208681, 6208682, 6208683, 6208684, 6208685, 6208686, 6208687, 6208688, 6208689, 6208690, 6208691, 6208692, 6208693, 6208694, 6208695, 6208696, 6208697, 6208698, 6208699, 6208700, 6208701, 6208702, 6208703, 6208704, 6208705, 6208706, 6208707, 6208708, 6208709, 6208710, 6208711, 6208712, 6208713, 6208714, 6208715, 6208716, 6208717, 6208718, 6208719, 6208720, 6208721, 6234836, 6234837, 6234838, 6234839, 6234840, 6234841, 6234842, 6234843, 6234844, 6234845, 6234846, 6234847, 6255596, 6255597, 6255598, 6255599, 6255600, 6255601, 6255602, 6255603, 6255604, 6255605, 6255606, 6255607, 6255608, 6255609, 6255610, 6255611, 6255612, 6255613, 6255614, 6255615, 6255616, 6255617, 6255618, 6255619, 6255620, 6255621, 6255622, 6255623, 6255624, 6255625, 6255626, 6255627, 6255628, 6255629, 6255630, 6255631, 6255632, 6255633, 6255634, 6255635, 6255636, 6255637, 6255638, 6255639, 6255640, 6255641, 6255642, 6255643, 6255644, 6255645, 6255646, 6274437, 6274438, 6274439, 6274440, 6274441, 6274442, 6281765, 6281766, 6281767, 6281768, 6281769, 6281770, 6284810, 6284811, 6284812, 6284813, 6284814, 6284815, 6284816, 6284817, 6284818, 6284819, 6284820, 6284821, 6284822, 6284823, 6284824, 6284825, 6284826, 6284827, 6284828, 6284829, 6284830, 6284831, 6284832, 6284833, 6284834, 6284835, 6284836, 6284837, 6284838, 6284839, 6284840, 6284841, 6284842, 6284843, 6284844, 6284845, 6284846, 6284847, 6284848, 6284849, 6284850, 6284851, 6284852, 6284853, 6284854, 6284855, 6284856, 6284857, 6284858, 6284859, 6284860, 6284861, 6284862, 6284863, 6284864, 6284865, 6284866, 6284867, 6284868, 6284869, 6284870, 6284871, 6284872, 6284873, 6284874, 6284876, 6284877, 6284878, 6284879, 6284880, 6284881, 6284882, 6284883, 6284884, 6284885, 6284889, 6284890, 6284891, 6284892, 6284894, 6284895, 6284897, 6284898, 6284899, 6284900, 6284901, 6284902, 6284903, 6284904, 6284906, 6284907, 6284910, 6284911, 6284912, 6284913, 6284914, 6284915, 6284916, 6284917, 6284918, 6284919, 6284920, 6284921, 6284922, 6284923, 6284924, 6284925, 6284926, 6284927, 6284928, 6284929, 6284930, 6284931, 6284932, 6284933, 6284934, 6284935, 6284936, 6284937, 6284938, 6284939, 6284940, 6284941, 6284942, 6284943, 6284944, 6284945, 6284946, 6284947, 6284948, 6284949, 6284950, 6284952, 6284953, 6284954, 6284955, 6284956, 6284957, 6284958, 6284959, 6284960, 6284962, 6284964, 6284965, 6284967, 6284968, 6284970, 6284971, 6284973, 6284974, 6295794, 6295795, 6295796, 6295801, 6295819, 6295820, 6295852, 6295854, 6344521, 6344522, 6344523, 6344524, 6425092, 6425093, 6425094, 6425095, 6425096, 6425097, 6425098, 6425099, 6425100, 6425101, 6425102, 6425103, 6425104, 6425105, 6425106, 6625233, 6625244, 6625245, 6625302, 6192410, 6187551, 6187553, 6669558, 6669559, 6669560, 6669563, 6669564, 6669565, 6669566, 6669567, 6187554, 6187559, 6187550, 6187552, 6187555, 6187556, 6187557, 6187558, 6187560, 6691949, 6754223, 6754224, 6754225, 6781854, 6782110, 6782948, 6882878, 6947433, 6947434, 6947435, 6947436, 6947437, 6947438, 6947440, 6947441, 6947442, 6947443, 6947444, 6947446, 6947447, 6947448, 6947449, 6947450, 6947452, 6947455, 6947456, 6947458, 6947460, 6947461, 6947463, 6947469, 6947472, 6947473, 6962535, 6962536, 6977361, 6977363, 6977364, 6977366, 6977367, 6977368, 6977369, 6977370, 6977371, 6977372, 6977373, 6977374, 6977375, 6977376, 6977377, 6977378, 6977379, 6977380, 6977381, 6977382, 6977383, 6977384, 6977385, 6977386, 6977387, 6977388, 6977389, 6977390, 6977391, 6977392, 6977393, 6977394, 6977395, 6993445, 6994060, 7009207, 7009208, 7009209, 7009210, 7009211, 7009212, 7009213, 7009214, 7009215, 7009216, 7009217, 7009218, 7009219, 7009220, 7009221, 7009222, 7009223, 7009224, 7009225, 7009226, 7009227, 7009228, 7009229, 7009230, 7009231, 7009232, 7009233, 7009234, 7009235, 7009236, 7009237, 7009238, 7009239, 7009240, 7009241, 7009242, 7009243, 7009244, 7009245, 7009246, 7009247, 7009248, 7009249, 7009250, 7009251, 7009252, 7009253, 7009254, 7009255, 7018997, 7018998, 7018999, 7019000, 7019001, 7019002, 7019003, 7019004, 7019005, 7019006, 7019007, 7019008, 7019009, 7019010, 7019011, 7020439, 7020440, 7020441, 7020442, 7020552, 7020553, 7020563, 7020565, 7020566, 7021021, 7021026, 7021028, 7021029, 7021030, 7021031, 7021032, 7021036, 7021038, 7021042, 7021043, 7021044, 7021051, 7021053, 7021055, 7021057, 7021058, 7021060, 7021061, 7021064, 7021067, 7021068, 7021071, 7021073, 7021075, 7021076, 7021077, 7021080, 7021083, 7021084, 7021085, 7021088, 7021089, 7021090, 7021091, 7021092, 7021094, 7021104, 7021105, 7021106, 7021107, 7021108, 7021109, 7021110, 7021111, 7021113, 7021115, 7021120, 7021121, 7021122, 7021123, 7021125, 7021128, 7021129, 7021130, 7021131, 7021132, 7021133, 7021134, 7021135, 7041266, 7041267, 7041268, 7041269, 7041270, 7041271, 7041272, 7041273, 7041274, 7041275, 7041276, 7041277, 7041278, 7041279, 7041280, 7041281, 7041282, 7041283, 7041284, 7041285, 7041286, 7041287, 7041288, 7041289, 7041290, 7041291, 7047349, 7047350, 7047351, 7047352, 7047353, 7047354, 7047355, 7047356, 7047357, 7047358, 7047359, 7047360, 7047361, 7047362, 7047363, 7047364, 7047365, 7047366, 7047367, 7047368, 7047369, 7047370, 7047371, 7047372, 7047373, 7063855, 7063856, 7063857, 7063858, 7063859, 7063860, 7063861, 7063862, 7063863, 7063864, 7063865, 7063866, 7063867, 7063868, 7063869, 7063870, 7063871, 7063872, 7063873, 7080638, 7081848, 7081935, 7081936, 7081937, 7081938, 7081939, 7081940, 7081941, 7081942, 7081943, 7081944, 7081945, 7081946, 7081947, 7081948, 7081949, 7081950, 7081951, 7081952, 7081953, 7081954, 7081955, 7081956, 7081957, 7081958, 7081959, 7081960, 7081961, 7081962, 7081963, 7081964, 7081965, 7081966, 7081967, 7082450, 7082451, 7082452, 7082453, 7082454, 7082455, 7082456, 7082457, 7082458, 7082459, 7082462, 7082463, 7082464, 7082465, 7082466, 7082467, 7082468, 7082469, 7082470, 7082471, 7082472, 7082473, 7082474, 7082475, 7082476, 7085387) and date(`dtEventDate`) >= '2025-04-24' order by `dtEventDate` asc limit 12
7.07ms/app/Events.php:380etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `nq_events` where `dtEventDate` between '2025-04-24 19:01:44' and '2025-12-31 23:59:59' and (`chrDelete` = 'N') and `fkeventGlcode` in (6207446, 6207447, 6207448, 6207459, 6207460, 6207461, 6207462, 6208659, 6208660, 6208661, 6208662, 6208663, 6208664, 6208665, 6208666, 6208667, 6208668, 6208669, 6208670, 6208671, 6208672, 6208673, 6208674, 6208675, 6208676, 6208677, 6208678, 6208679, 6208680, 6208681, 6208682, 6208683, 6208684, 6208685, 6208686, 6208687, 6208688, 6208689, 6208690, 6208691, 6208692, 6208693, 6208694, 6208695, 6208696, 6208697, 6208698, 6208699, 6208700, 6208701, 6208702, 6208703, 6208704, 6208705, 6208706, 6208707, 6208708, 6208709, 6208710, 6208711, 6208712, 6208713, 6208714, 6208715, 6208716, 6208717, 6208718, 6208719, 6208720, 6208721, 6234836, 6234837, 6234838, 6234839, 6234840, 6234841, 6234842, 6234843, 6234844, 6234845, 6234846, 6234847, 6255596, 6255597, 6255598, 6255599, 6255600, 6255601, 6255602, 6255603, 6255604, 6255605, 6255606, 6255607, 6255608, 6255609, 6255610, 6255611, 6255612, 6255613, 6255614, 6255615, 6255616, 6255617, 6255618, 6255619, 6255620, 6255621, 6255622, 6255623, 6255624, 6255625, 6255626, 6255627, 6255628, 6255629, 6255630, 6255631, 6255632, 6255633, 6255634, 6255635, 6255636, 6255637, 6255638, 6255639, 6255640, 6255641, 6255642, 6255643, 6255644, 6255645, 6255646, 6274437, 6274438, 6274439, 6274440, 6274441, 6274442, 6281765, 6281766, 6281767, 6281768, 6281769, 6281770, 6284810, 6284811, 6284812, 6284813, 6284814, 6284815, 6284816, 6284817, 6284818, 6284819, 6284820, 6284821, 6284822, 6284823, 6284824, 6284825, 6284826, 6284827, 6284828, 6284829, 6284830, 6284831, 6284832, 6284833, 6284834, 6284835, 6284836, 6284837, 6284838, 6284839, 6284840, 6284841, 6284842, 6284843, 6284844, 6284845, 6284846, 6284847, 6284848, 6284849, 6284850, 6284851, 6284852, 6284853, 6284854, 6284855, 6284856, 6284857, 6284858, 6284859, 6284860, 6284861, 6284862, 6284863, 6284864, 6284865, 6284866, 6284867, 6284868, 6284869, 6284870, 6284871, 6284872, 6284873, 6284874, 6284876, 6284877, 6284878, 6284879, 6284880, 6284881, 6284882, 6284883, 6284884, 6284885, 6284889, 6284890, 6284891, 6284892, 6284894, 6284895, 6284897, 6284898, 6284899, 6284900, 6284901, 6284902, 6284903, 6284904, 6284906, 6284907, 6284910, 6284911, 6284912, 6284913, 6284914, 6284915, 6284916, 6284917, 6284918, 6284919, 6284920, 6284921, 6284922, 6284923, 6284924, 6284925, 6284926, 6284927, 6284928, 6284929, 6284930, 6284931, 6284932, 6284933, 6284934, 6284935, 6284936, 6284937, 6284938, 6284939, 6284940, 6284941, 6284942, 6284943, 6284944, 6284945, 6284946, 6284947, 6284948, 6284949, 6284950, 6284952, 6284953, 6284954, 6284955, 6284956, 6284957, 6284958, 6284959, 6284960, 6284962, 6284964, 6284965, 6284967, 6284968, 6284970, 6284971, 6284973, 6284974, 6295794, 6295795, 6295796, 6295801, 6295819, 6295820, 6295852, 6295854, 6344521, 6344522, 6344523, 6344524, 6425092, 6425093, 6425094, 6425095, 6425096, 6425097, 6425098, 6425099, 6425100, 6425101, 6425102, 6425103, 6425104, 6425105, 6425106, 6625233, 6625244, 6625245, 6625302, 6192410, 6187551, 6187553, 6669558, 6669559, 6669560, 6669563, 6669564, 6669565, 6669566, 6669567, 6187554, 6187559, 6187550, 6187552, 6187555, 6187556, 6187557, 6187558, 6187560, 6691949, 6754223, 6754224, 6754225, 6781854, 6782110, 6782948, 6882878, 6947433, 6947434, 6947435, 6947436, 6947437, 6947438, 6947440, 6947441, 6947442, 6947443, 6947444, 6947446, 6947447, 6947448, 6947449, 6947450, 6947452, 6947455, 6947456, 6947458, 6947460, 6947461, 6947463, 6947469, 6947472, 6947473, 6962535, 6962536, 6977361, 6977363, 6977364, 6977366, 6977367, 6977368, 6977369, 6977370, 6977371, 6977372, 6977373, 6977374, 6977375, 6977376, 6977377, 6977378, 6977379, 6977380, 6977381, 6977382, 6977383, 6977384, 6977385, 6977386, 6977387, 6977388, 6977389, 6977390, 6977391, 6977392, 6977393, 6977394, 6977395, 6993445, 6994060, 7009207, 7009208, 7009209, 7009210, 7009211, 7009212, 7009213, 7009214, 7009215, 7009216, 7009217, 7009218, 7009219, 7009220, 7009221, 7009222, 7009223, 7009224, 7009225, 7009226, 7009227, 7009228, 7009229, 7009230, 7009231, 7009232, 7009233, 7009234, 7009235, 7009236, 7009237, 7009238, 7009239, 7009240, 7009241, 7009242, 7009243, 7009244, 7009245, 7009246, 7009247, 7009248, 7009249, 7009250, 7009251, 7009252, 7009253, 7009254, 7009255, 7018997, 7018998, 7018999, 7019000, 7019001, 7019002, 7019003, 7019004, 7019005, 7019006, 7019007, 7019008, 7019009, 7019010, 7019011, 7020439, 7020440, 7020441, 7020442, 7020552, 7020553, 7020563, 7020565, 7020566, 7021021, 7021026, 7021028, 7021029, 7021030, 7021031, 7021032, 7021036, 7021038, 7021042, 7021043, 7021044, 7021051, 7021053, 7021055, 7021057, 7021058, 7021060, 7021061, 7021064, 7021067, 7021068, 7021071, 7021073, 7021075, 7021076, 7021077, 7021080, 7021083, 7021084, 7021085, 7021088, 7021089, 7021090, 7021091, 7021092, 7021094, 7021104, 7021105, 7021106, 7021107, 7021108, 7021109, 7021110, 7021111, 7021113, 7021115, 7021120, 7021121, 7021122, 7021123, 7021125, 7021128, 7021129, 7021130, 7021131, 7021132, 7021133, 7021134, 7021135, 7041266, 7041267, 7041268, 7041269, 7041270, 7041271, 7041272, 7041273, 7041274, 7041275, 7041276, 7041277, 7041278, 7041279, 7041280, 7041281, 7041282, 7041283, 7041284, 7041285, 7041286, 7041287, 7041288, 7041289, 7041290, 7041291, 7047349, 7047350, 7047351, 7047352, 7047353, 7047354, 7047355, 7047356, 7047357, 7047358, 7047359, 7047360, 7047361, 7047362, 7047363, 7047364, 7047365, 7047366, 7047367, 7047368, 7047369, 7047370, 7047371, 7047372, 7047373, 7063855, 7063856, 7063857, 7063858, 7063859, 7063860, 7063861, 7063862, 7063863, 7063864, 7063865, 7063866, 7063867, 7063868, 7063869, 7063870, 7063871, 7063872, 7063873, 7080638, 7081848, 7081935, 7081936, 7081937, 7081938, 7081939, 7081940, 7081941, 7081942, 7081943, 7081944, 7081945, 7081946, 7081947, 7081948, 7081949, 7081950, 7081951, 7081952, 7081953, 7081954, 7081955, 7081956, 7081957, 7081958, 7081959, 7081960, 7081961, 7081962, 7081963, 7081964, 7081965, 7081966, 7081967, 7082450, 7082451, 7082452, 7082453, 7082454, 7082455, 7082456, 7082457, 7082458, 7082459, 7082462, 7082463, 7082464, 7082465, 7082466, 7082467, 7082468, 7082469, 7082470, 7082471, 7082472, 7082473, 7082474, 7082475, 7082476, 7085387) and date(`dtEventDate`) >= '2025-04-24'
5.83ms/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` = 'CA' and `nq_peformers`.`intChildCatId` = 17174 and `nq_peformers`.`total_count` != 0 group by `nq_peformers`.`id`) as `aggregate_table`
1.51ms/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` = 17174 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` = 38 and `intParentCategoryId` = 3 limit 1
1.09ms/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` = 'Chicago') and (`varStateProvince` = 'IL') limit 1
2.02ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101237 and `chrIsPreview` = 'N' limit 1
1.27ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Los Angeles') and (`varStateProvince` = 'CA') limit 1
1.32ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 100806 and `chrIsPreview` = 'N' limit 1
1.11ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Washington') and (`varStateProvince` = 'DC') limit 1
1.95ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 100996 and `chrIsPreview` = 'N' limit 1
1.08ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Boston') and (`varStateProvince` = 'MA') limit 1
2ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101437 and `chrIsPreview` = 'N' limit 1
1.1ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Orlando') and (`varStateProvince` = 'FL') limit 1
1.74ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101060 and `chrIsPreview` = 'N' limit 1
1.07ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Minneapolis') and (`varStateProvince` = 'MN') limit 1
2.2ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101624 and `chrIsPreview` = 'N' limit 1
1.36ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Atlanta') and (`varStateProvince` = 'GA') limit 1
1.75ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101096 and `chrIsPreview` = 'N' limit 1
1.29ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'St. Louis') and (`varStateProvince` = 'MO') limit 1
2.25ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101673 and `chrIsPreview` = 'N' limit 1
2.1ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Columbus') and (`varStateProvince` = 'OH') limit 1
2.45ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 102068 and `chrIsPreview` = 'N' limit 1
1.25ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Costa Mesa') and (`varStateProvince` = 'CA') limit 1
1.62ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 100763 and `chrIsPreview` = 'N' limit 1
1.17ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Durham') and (`varStateProvince` = 'NC') limit 1
2.24ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101748 and `chrIsPreview` = 'N' limit 1
1.26ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Providence') and (`varStateProvince` = 'RI') limit 1
2.68ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 102277 and `chrIsPreview` = 'N' limit 1
1.22ms/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')
1.59ms/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.3ms/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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "close" ] "x-forwarded-for" => array:1 [▶ 0 => "3.15.223.232" ] "x-real-ip" => array:1 [▶ 0 => "3.15.223.232" ] "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" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "close" "HTTP_X_FORWARDED_FOR" => "3.15.223.232" "HTTP_X_REAL_IP" => "3.15.223.232" "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" => "-73.2637" "GEOIP_LATITUDE" => "41.1412" "GEOIP_CITY_CONTINENT_CODE" => "NA" "GEOIP_POSTAL_CODE" => "06828" "GEOIP_CITY" => "Fairfield" "GEOIP_REGION" => "CT" "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" => "3.15.223.232" "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/harry-potter-and-the-cursed-child-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" => 1745539303.9894 "REQUEST_TIME" => 1745539303 ]
[]
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 => "Fri, 25 Apr 2025 00:01:44 GMT" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => "-1" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InB1ajRlai9TK2dRSHVnbC9mVTNVQlE9PSIsInZhbHVlIjoiRDBtU0JDVlBZMFRrSGxsVXV3S1A0dGNCUFVrSjhGMmYzK21rcXBVZXNES1pCYTU4eWJRQW9GRG9xY3laTEF0eFhaVDVGaFkvRHpyblU3bTd4MVNScWtMOE1KaWNRcVo2eWc5OSt0S29XQkd5UnpiQSt3OXdzNm5RWmlKQmkrc1oiLCJtYWMiOiIxMWFmMDJhN2RiYmFjOTdiMTg1MzA2N2NkYTVjZWQ1OGMzMTQxYzc2OGU0YWE0YjNlYWY4N2QyNWJiN2M2YTlhIiwidGFnIjoiIn0%3D; expires=Fri, 25 Apr 2025 02:01:44 GMT; Max-Age=7200; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InB1ajRlai9TK2dRSHVnbC9mVTNVQlE9PSIsInZhbHVlIjoiRDBtU0JDVlBZMFRrSGxsVXV3S1A0dGNCUFVrSjhGMmYzK21rcXBVZXNES1pCYTU4eWJRQW9GRG9xY3laTEF0eFhaVDVGa ▶" 1 => "recently_viewed=WTMqrpwYc07MFU6FNhD3; expires=Sat, 26 Apr 2025 00:01:44 GMT; Max-Age=86400; path=/; secure; httponly" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InB1ajRlai9TK2dRSHVnbC9mVTNVQlE9PSIsInZhbHVlIjoiRDBtU0JDVlBZMFRrSGxsVXV3S1A0dGNCUFVrSjhGMmYzK21rcXBVZXNES1pCYTU4eWJRQW9GRG9xY3laTEF0eFhaVDVGaFkvRHpyblU3bTd4MVNScWtMOE1KaWNRcVo2eWc5OSt0S29XQkd5UnpiQSt3OXdzNm5RWmlKQmkrc1oiLCJtYWMiOiIxMWFmMDJhN2RiYmFjOTdiMTg1MzA2N2NkYTVjZWQ1OGMzMTQxYzc2OGU0YWE0YjNlYWY4N2QyNWJiN2M2YTlhIiwidGFnIjoiIn0%3D; expires=Fri, 25-Apr-2025 02:01:44 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InB1ajRlai9TK2dRSHVnbC9mVTNVQlE9PSIsInZhbHVlIjoiRDBtU0JDVlBZMFRrSGxsVXV3S1A0dGNCUFVrSjhGMmYzK21rcXBVZXNES1pCYTU4eWJRQW9GRG9xY3laTEF0eFhaVDVGa ▶" 1 => "recently_viewed=WTMqrpwYc07MFU6FNhD3; expires=Sat, 26-Apr-2025 00:01:44 GMT; path=/; secure; httponly" ] ]
0 of 0array:2 [▼ "_token" => "UfAhp5KEYZOjpqsAj1ZOYUPdl9BazEJfHwcX9LlF" "PHPDEBUGBAR_STACK_DATA" => [] ]