eTickets.ca takes pride in offering you a seamless way to witness the electrifying performance of your favorite team or player, Cirque du Soleil - Mad Apple 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 Cirque du Soleil - Mad Apple live. Keep an eye on the.Cirque du Soleil - Mad Appletheatre 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 Cirque du Soleil - Mad Apple'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 (61%) | 425.31ms |
1 x Booting (38.99%) | 271.84ms |
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
23.16ms/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')
4.15ms/packages/Powerpanel/Menu/src/Models/Menu.php:233etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'cirque-du-soleil-mad-apple-tickets' limit 1
6.73ms/app/Alias.php:35etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 42815 and `chrIsPreview` = 'N' limit 1
3.5ms/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` = 42815 and (`chrDelete` = 'N') limit 1
7.26ms/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')
6.97ms/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
7.74ms/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
3.35ms/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
5.64ms/packages/Powerpanel/Offer/src/Models/Offer.php:66etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'cirque-du-soleil-mad-apple-tickets' limit 1
8.76ms/app/Alias.php:35etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intCategoryId` from `nq_peformers` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `intAliasId` = 42815 limit 1
8.92ms/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` = 42815 limit 1
8.88ms/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` = 42815 limit 1
9.84ms/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` = 41807 and `fkModuleId` = 158
3.61ms/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` = 35 and `nq_event_performers`.`performerid` = 193757 and `nq_events`.`chrDelete` = 'N'
11.44ms/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 (5750149, 5750150, 5750151, 5750152, 5750153, 5750154, 5750155, 5750156, 5750157, 5750158, 5750159, 5750160, 5750161, 5750162, 5750163, 5750164, 5750165, 5750166, 5750167, 5750168, 5750169, 5750170, 5750171, 5750207, 5750208, 5750209, 5750210, 5750211, 5750212, 5750213, 5750214, 5750215, 5750216, 5750217, 5750218, 5750219, 5750220, 5750221, 5750222, 5750223, 5750224, 5750225, 5750226, 5750227, 5750228, 5750229, 6101855, 6101857, 6101858, 6101859, 6101860, 6101861, 6101862, 6101863, 6101864, 6101865, 6101869, 6101870, 6101871, 6101872, 6101873, 6101876, 6101877, 6101878, 6101879, 6101880, 6101881, 6101882, 6101883, 6101884, 6101885, 6101886, 6101887, 6101888, 6101889, 6101890, 6101891, 6101892, 6101893, 6101894, 6101895, 6101896, 6101897, 6101899, 6101901, 6101902, 6101903, 6101904, 6101905, 6101909, 6101910, 6101911, 6101912, 6101917, 6101918, 6101919, 6101920, 6101921, 6101922, 6101923, 6101924, 6101925, 6101926, 6101927, 6101928, 6101929, 6101930, 6101931, 6101932, 6101933, 6101934, 6101935, 6101936, 6101937, 6101938, 6101939, 6101940, 6101941, 6101942, 6101944, 6101945, 6101946, 6101947, 6101948, 6101949, 6101950, 6101951, 6101952, 6101953, 6101954, 6101955, 6101956, 6101957, 6101958, 6101960, 6101961, 6101962, 6101963, 6101964, 6101965, 6101966, 6101967, 6101968, 6101969, 6101970, 6101971, 6101972, 6101973, 6101974, 6101975, 6101976, 6101977, 6101978, 6101979, 6101980, 6101981, 6101982, 6101983, 6101985, 6101986, 6101987, 6101988, 6101989, 6101990, 6101991, 6101992, 6101993, 6101994, 6101995, 6101996, 6101997, 6101998, 6101999, 6102000, 6102001, 6102002, 6102003, 6102004, 6102006, 6102007, 6102008, 6102009, 6102010, 6102011, 6102012, 6102013, 6102014, 6102015, 6102017, 6102018, 6102019, 6102020, 6102021, 6102022, 6102023, 6102024, 6102025, 6102026, 6102027, 6102029, 6102030, 6102031, 6102032, 6102033, 6102034, 6102035, 6102036, 6102037, 6102038, 6102039, 6102040, 6102041, 6102042, 6102043, 6102044, 6102045, 6102046, 6102047, 6102049, 6102050, 6102051, 6102052, 6102053, 6102054, 6102055, 6102056, 6102057, 6102058, 6102059, 6102060, 6102061, 6102062, 6102063, 6102064, 6102065, 6102066, 6102067, 6102068, 6102069, 6102070, 6102071, 6102072, 6102073, 6102074, 6102075, 6102076, 6102077, 6102078, 6102079, 6102080, 6102081, 6102082, 6102083, 6102084, 6102085, 6102086, 6102087, 6102089, 6102090, 6102091, 6102092, 6102093, 6102094, 6102095, 6102096, 6102097, 6102098, 6102099, 6102100, 6102101, 6102102, 6102103, 6102104, 6102105, 6102106, 6102107, 6102108, 6102109, 6102110, 6102111, 6102112, 6102113, 6102114, 6102115, 6102116, 6102117, 6102118, 6102119, 6102120, 6102121, 6102122, 6102123, 6102124, 6102125, 6102126, 6102127, 6102128, 6102129, 6102130, 6102131, 6102132, 6102133, 6102134, 6102135, 6102136, 6102138, 6102139, 6102140, 6102141, 6102142, 6102143, 6102144, 6102145, 6102147, 6102148, 6102149, 6102150, 6102151, 6102152, 6102153, 6102154, 6102155, 6102156, 6102157, 6102158, 6102159, 6102160, 6102161, 6102162, 6102163, 6102164, 6102165, 6102166, 6102167, 6102168, 6102170, 6102172, 6102173, 6102174, 6102175, 6102176, 6102177, 6102178, 6102179, 6102180, 6102184, 6102185, 6102186, 6102187, 6102188, 6102189, 6102190, 6102191, 6102192, 6102193, 6102196, 6102197, 6102198, 6102199, 6102200, 6102201, 6102202, 6102203, 6102204, 6102205, 6102206, 6102207, 6102208, 6102209, 6102218, 6102221, 6102222, 6102223, 6102258, 6102259, 6102260, 6102261, 6102262, 6102263, 6102264, 6102265, 6102266, 6102268, 6102269, 6102270, 6102271, 6102272, 6102273, 6102274, 6102275, 6102276, 6102277, 6102278, 6102279, 6102280, 6102281, 6102282, 6102283, 6510739, 6510740, 6510854, 6510855, 6510999, 6647926, 6647927, 6647928, 6647931, 6647932, 6647933, 6647934, 6647935, 6647936, 6647937, 6647938, 6647939, 6647940, 6647941, 6647942, 6647943, 6647944, 6647945, 6647946, 6647949, 6647951, 6647952, 6647953, 6647954, 6647956, 6647957, 6647958, 6647959, 6647960, 6647961, 6647962, 6647963, 6647964, 6647965, 6647966, 6647967, 6647968, 6647969, 6647970, 6647971, 6647972, 6647973, 6647974, 6647975, 6647976, 6647977, 6647978, 6647979, 6647980, 6647981, 6647982, 6647983, 6647984, 6647985, 6647986, 6647987, 6647988, 6647989, 6647990, 6647991, 6647992, 6647993, 6647994, 6647995, 6647996, 6647997, 6647998, 6647999, 6648000, 6648001, 6648002, 6648003, 6648004, 6648005, 6648006, 6648007, 6648008, 6648009, 6648010, 6648011, 6648012, 6648013, 6648014, 6648015, 6648016, 6648017, 6648018, 6648019, 6648020, 6648021, 6648022, 6648023, 6648024, 6648025, 6648026, 6648027, 6648028, 6648029, 6648030, 6648031, 6648032, 6648033, 6648034, 6648035, 6648036, 6648037, 6648038, 6648039, 6648040, 6648041, 6648042, 6648043, 6648044, 6648045, 6648046, 6648047, 6648048, 6648049, 6648050, 6648051, 6648052, 6648053, 6648054, 6648055, 6648056, 6648057, 6648058, 6648059, 6648060, 6648061, 6648062, 6648063, 6648064, 6648065, 6648066, 6648067, 6648068, 6648069, 6648070, 6648071, 6648072, 6648073, 6648074, 6648075, 6648076, 6648077, 6648078, 6648079, 6648080, 6648081, 6648082, 6648083, 6648084, 6648085, 6648086, 6648087, 6648088, 6648089, 6648090, 6648091, 6648092, 6648093, 6648094, 6648095, 6648096, 6648097, 6648098, 6648099, 6648100, 6648101, 6648102, 6648103, 6648105, 6648106, 6648107, 6648108, 6648109, 6648110, 6648112, 6648113, 6648114, 6648115, 6648116, 6648117, 6648118, 6648119, 6648120, 6648122, 6648123, 6648124, 6648125, 6648126, 6648127, 6648128, 6648130, 6648131, 6648132, 6648135, 6648136, 6648137, 6648138, 6648139, 6648140, 6648141, 6648142, 6648143, 6648145, 6648147, 6648150, 6648151, 6648152, 6648153, 6648154, 6648155, 6648159, 6648161, 6648163, 6648164, 6648165, 6648166, 6648167, 6648168, 6648169, 6648170, 6648171, 6648172, 6648173, 6648175, 6648176, 6648177, 6648178, 6648179, 6648180, 6648181, 6648182, 6648183, 6648185, 6648186, 6648187, 6648188, 6648189, 6648190, 6648192, 6648193, 6648194, 6648195, 6648197, 6648198, 6648199, 6648200, 6648201, 6648202, 6648203, 6648204, 6648205, 6648206, 6648207, 6648208, 6648209, 6648210, 6648211, 6648213, 6648214, 6648215, 6648216, 6648217, 6648218, 6648219, 6648220, 6648222, 6648223, 6648224, 6648225, 6648233, 6648235, 6648236, 6648243, 6648244, 6648245, 6648246, 6648247, 6648248, 6648254, 6648256, 6648259, 6648260, 6648261, 6648263, 6648264, 6648265, 6648266, 6648267, 6648268, 6648269, 6648271, 6648272, 6648273, 6648275, 6648276, 6648277, 6648278, 6648280, 6648286, 6648287, 6648288, 6648289, 6648290, 6648291, 6648292, 6648293, 6648294, 6648295, 6648296, 6648297, 6648299, 6648303, 6648304, 6648305, 6648306, 6648307, 6648308, 6648309, 6648310, 6648311, 6648312, 6648313, 6648314, 6648315, 6648316, 6648317, 6648318, 6648319, 6648320, 6648321, 6648322, 6648324, 6648325, 6648326, 6648327, 6648328, 6648329, 6648331, 6648332, 6648333, 6648334, 6648335, 6648336, 6648337, 6648339, 6648340, 6648341, 6648342, 6648343, 6648344, 6648346, 6648347, 6648348, 6648349, 6648350, 6648351, 6648352, 6648354, 6648355, 6648356, 6648357, 6648358, 6648378, 6648380, 6648381, 6648382, 6648383, 6648384, 6648385, 6648386, 6648387, 6648388, 6648389, 6648390, 6648392, 6648393, 6648395, 6648396, 6648397, 6648398, 6648400, 6648421, 6648423, 6648424, 6648425, 6648426, 6648427, 6648428, 6648429, 6648430, 6648431, 6648432, 6648433, 6648434, 6648435, 6648436, 6648438, 6648439, 6648440, 6648441, 6648443, 6648444, 6648445, 6648446, 6648447, 6648448, 6648450, 6648451, 6648453, 6648454, 6648455, 6648457, 6648458, 6648459, 6648460, 6648461, 6648462, 6648463, 6648464, 6648465, 6648467, 6648468, 6648470, 6648494, 6648495, 6648496, 6648497, 6648498, 6648500, 6648501, 6648502, 6648505, 6648509, 6648510, 6648511, 6648512, 6648513, 6648514, 6648516, 6648517, 6648518, 6648520, 6648522, 6648524, 6648525, 6648527, 6648528, 6648530, 6648531, 6648532, 6648533, 6648534, 6648535, 6648536, 6654350, 6654379, 6654397, 6654398, 6654437, 6654451, 6648507) group by `varCity`) as `aggregate_table`
14.54ms/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 (5750149, 5750150, 5750151, 5750152, 5750153, 5750154, 5750155, 5750156, 5750157, 5750158, 5750159, 5750160, 5750161, 5750162, 5750163, 5750164, 5750165, 5750166, 5750167, 5750168, 5750169, 5750170, 5750171, 5750207, 5750208, 5750209, 5750210, 5750211, 5750212, 5750213, 5750214, 5750215, 5750216, 5750217, 5750218, 5750219, 5750220, 5750221, 5750222, 5750223, 5750224, 5750225, 5750226, 5750227, 5750228, 5750229, 6101855, 6101857, 6101858, 6101859, 6101860, 6101861, 6101862, 6101863, 6101864, 6101865, 6101869, 6101870, 6101871, 6101872, 6101873, 6101876, 6101877, 6101878, 6101879, 6101880, 6101881, 6101882, 6101883, 6101884, 6101885, 6101886, 6101887, 6101888, 6101889, 6101890, 6101891, 6101892, 6101893, 6101894, 6101895, 6101896, 6101897, 6101899, 6101901, 6101902, 6101903, 6101904, 6101905, 6101909, 6101910, 6101911, 6101912, 6101917, 6101918, 6101919, 6101920, 6101921, 6101922, 6101923, 6101924, 6101925, 6101926, 6101927, 6101928, 6101929, 6101930, 6101931, 6101932, 6101933, 6101934, 6101935, 6101936, 6101937, 6101938, 6101939, 6101940, 6101941, 6101942, 6101944, 6101945, 6101946, 6101947, 6101948, 6101949, 6101950, 6101951, 6101952, 6101953, 6101954, 6101955, 6101956, 6101957, 6101958, 6101960, 6101961, 6101962, 6101963, 6101964, 6101965, 6101966, 6101967, 6101968, 6101969, 6101970, 6101971, 6101972, 6101973, 6101974, 6101975, 6101976, 6101977, 6101978, 6101979, 6101980, 6101981, 6101982, 6101983, 6101985, 6101986, 6101987, 6101988, 6101989, 6101990, 6101991, 6101992, 6101993, 6101994, 6101995, 6101996, 6101997, 6101998, 6101999, 6102000, 6102001, 6102002, 6102003, 6102004, 6102006, 6102007, 6102008, 6102009, 6102010, 6102011, 6102012, 6102013, 6102014, 6102015, 6102017, 6102018, 6102019, 6102020, 6102021, 6102022, 6102023, 6102024, 6102025, 6102026, 6102027, 6102029, 6102030, 6102031, 6102032, 6102033, 6102034, 6102035, 6102036, 6102037, 6102038, 6102039, 6102040, 6102041, 6102042, 6102043, 6102044, 6102045, 6102046, 6102047, 6102049, 6102050, 6102051, 6102052, 6102053, 6102054, 6102055, 6102056, 6102057, 6102058, 6102059, 6102060, 6102061, 6102062, 6102063, 6102064, 6102065, 6102066, 6102067, 6102068, 6102069, 6102070, 6102071, 6102072, 6102073, 6102074, 6102075, 6102076, 6102077, 6102078, 6102079, 6102080, 6102081, 6102082, 6102083, 6102084, 6102085, 6102086, 6102087, 6102089, 6102090, 6102091, 6102092, 6102093, 6102094, 6102095, 6102096, 6102097, 6102098, 6102099, 6102100, 6102101, 6102102, 6102103, 6102104, 6102105, 6102106, 6102107, 6102108, 6102109, 6102110, 6102111, 6102112, 6102113, 6102114, 6102115, 6102116, 6102117, 6102118, 6102119, 6102120, 6102121, 6102122, 6102123, 6102124, 6102125, 6102126, 6102127, 6102128, 6102129, 6102130, 6102131, 6102132, 6102133, 6102134, 6102135, 6102136, 6102138, 6102139, 6102140, 6102141, 6102142, 6102143, 6102144, 6102145, 6102147, 6102148, 6102149, 6102150, 6102151, 6102152, 6102153, 6102154, 6102155, 6102156, 6102157, 6102158, 6102159, 6102160, 6102161, 6102162, 6102163, 6102164, 6102165, 6102166, 6102167, 6102168, 6102170, 6102172, 6102173, 6102174, 6102175, 6102176, 6102177, 6102178, 6102179, 6102180, 6102184, 6102185, 6102186, 6102187, 6102188, 6102189, 6102190, 6102191, 6102192, 6102193, 6102196, 6102197, 6102198, 6102199, 6102200, 6102201, 6102202, 6102203, 6102204, 6102205, 6102206, 6102207, 6102208, 6102209, 6102218, 6102221, 6102222, 6102223, 6102258, 6102259, 6102260, 6102261, 6102262, 6102263, 6102264, 6102265, 6102266, 6102268, 6102269, 6102270, 6102271, 6102272, 6102273, 6102274, 6102275, 6102276, 6102277, 6102278, 6102279, 6102280, 6102281, 6102282, 6102283, 6510739, 6510740, 6510854, 6510855, 6510999, 6647926, 6647927, 6647928, 6647931, 6647932, 6647933, 6647934, 6647935, 6647936, 6647937, 6647938, 6647939, 6647940, 6647941, 6647942, 6647943, 6647944, 6647945, 6647946, 6647949, 6647951, 6647952, 6647953, 6647954, 6647956, 6647957, 6647958, 6647959, 6647960, 6647961, 6647962, 6647963, 6647964, 6647965, 6647966, 6647967, 6647968, 6647969, 6647970, 6647971, 6647972, 6647973, 6647974, 6647975, 6647976, 6647977, 6647978, 6647979, 6647980, 6647981, 6647982, 6647983, 6647984, 6647985, 6647986, 6647987, 6647988, 6647989, 6647990, 6647991, 6647992, 6647993, 6647994, 6647995, 6647996, 6647997, 6647998, 6647999, 6648000, 6648001, 6648002, 6648003, 6648004, 6648005, 6648006, 6648007, 6648008, 6648009, 6648010, 6648011, 6648012, 6648013, 6648014, 6648015, 6648016, 6648017, 6648018, 6648019, 6648020, 6648021, 6648022, 6648023, 6648024, 6648025, 6648026, 6648027, 6648028, 6648029, 6648030, 6648031, 6648032, 6648033, 6648034, 6648035, 6648036, 6648037, 6648038, 6648039, 6648040, 6648041, 6648042, 6648043, 6648044, 6648045, 6648046, 6648047, 6648048, 6648049, 6648050, 6648051, 6648052, 6648053, 6648054, 6648055, 6648056, 6648057, 6648058, 6648059, 6648060, 6648061, 6648062, 6648063, 6648064, 6648065, 6648066, 6648067, 6648068, 6648069, 6648070, 6648071, 6648072, 6648073, 6648074, 6648075, 6648076, 6648077, 6648078, 6648079, 6648080, 6648081, 6648082, 6648083, 6648084, 6648085, 6648086, 6648087, 6648088, 6648089, 6648090, 6648091, 6648092, 6648093, 6648094, 6648095, 6648096, 6648097, 6648098, 6648099, 6648100, 6648101, 6648102, 6648103, 6648105, 6648106, 6648107, 6648108, 6648109, 6648110, 6648112, 6648113, 6648114, 6648115, 6648116, 6648117, 6648118, 6648119, 6648120, 6648122, 6648123, 6648124, 6648125, 6648126, 6648127, 6648128, 6648130, 6648131, 6648132, 6648135, 6648136, 6648137, 6648138, 6648139, 6648140, 6648141, 6648142, 6648143, 6648145, 6648147, 6648150, 6648151, 6648152, 6648153, 6648154, 6648155, 6648159, 6648161, 6648163, 6648164, 6648165, 6648166, 6648167, 6648168, 6648169, 6648170, 6648171, 6648172, 6648173, 6648175, 6648176, 6648177, 6648178, 6648179, 6648180, 6648181, 6648182, 6648183, 6648185, 6648186, 6648187, 6648188, 6648189, 6648190, 6648192, 6648193, 6648194, 6648195, 6648197, 6648198, 6648199, 6648200, 6648201, 6648202, 6648203, 6648204, 6648205, 6648206, 6648207, 6648208, 6648209, 6648210, 6648211, 6648213, 6648214, 6648215, 6648216, 6648217, 6648218, 6648219, 6648220, 6648222, 6648223, 6648224, 6648225, 6648233, 6648235, 6648236, 6648243, 6648244, 6648245, 6648246, 6648247, 6648248, 6648254, 6648256, 6648259, 6648260, 6648261, 6648263, 6648264, 6648265, 6648266, 6648267, 6648268, 6648269, 6648271, 6648272, 6648273, 6648275, 6648276, 6648277, 6648278, 6648280, 6648286, 6648287, 6648288, 6648289, 6648290, 6648291, 6648292, 6648293, 6648294, 6648295, 6648296, 6648297, 6648299, 6648303, 6648304, 6648305, 6648306, 6648307, 6648308, 6648309, 6648310, 6648311, 6648312, 6648313, 6648314, 6648315, 6648316, 6648317, 6648318, 6648319, 6648320, 6648321, 6648322, 6648324, 6648325, 6648326, 6648327, 6648328, 6648329, 6648331, 6648332, 6648333, 6648334, 6648335, 6648336, 6648337, 6648339, 6648340, 6648341, 6648342, 6648343, 6648344, 6648346, 6648347, 6648348, 6648349, 6648350, 6648351, 6648352, 6648354, 6648355, 6648356, 6648357, 6648358, 6648378, 6648380, 6648381, 6648382, 6648383, 6648384, 6648385, 6648386, 6648387, 6648388, 6648389, 6648390, 6648392, 6648393, 6648395, 6648396, 6648397, 6648398, 6648400, 6648421, 6648423, 6648424, 6648425, 6648426, 6648427, 6648428, 6648429, 6648430, 6648431, 6648432, 6648433, 6648434, 6648435, 6648436, 6648438, 6648439, 6648440, 6648441, 6648443, 6648444, 6648445, 6648446, 6648447, 6648448, 6648450, 6648451, 6648453, 6648454, 6648455, 6648457, 6648458, 6648459, 6648460, 6648461, 6648462, 6648463, 6648464, 6648465, 6648467, 6648468, 6648470, 6648494, 6648495, 6648496, 6648497, 6648498, 6648500, 6648501, 6648502, 6648505, 6648509, 6648510, 6648511, 6648512, 6648513, 6648514, 6648516, 6648517, 6648518, 6648520, 6648522, 6648524, 6648525, 6648527, 6648528, 6648530, 6648531, 6648532, 6648533, 6648534, 6648535, 6648536, 6654350, 6654379, 6654397, 6654398, 6654437, 6654451, 6648507) group by `varCity` order by `event_count` desc limit 12 offset 0
17.71ms/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 (5750149, 5750150, 5750151, 5750152, 5750153, 5750154, 5750155, 5750156, 5750157, 5750158, 5750159, 5750160, 5750161, 5750162, 5750163, 5750164, 5750165, 5750166, 5750167, 5750168, 5750169, 5750170, 5750171, 5750207, 5750208, 5750209, 5750210, 5750211, 5750212, 5750213, 5750214, 5750215, 5750216, 5750217, 5750218, 5750219, 5750220, 5750221, 5750222, 5750223, 5750224, 5750225, 5750226, 5750227, 5750228, 5750229, 6101855, 6101857, 6101858, 6101859, 6101860, 6101861, 6101862, 6101863, 6101864, 6101865, 6101869, 6101870, 6101871, 6101872, 6101873, 6101876, 6101877, 6101878, 6101879, 6101880, 6101881, 6101882, 6101883, 6101884, 6101885, 6101886, 6101887, 6101888, 6101889, 6101890, 6101891, 6101892, 6101893, 6101894, 6101895, 6101896, 6101897, 6101899, 6101901, 6101902, 6101903, 6101904, 6101905, 6101909, 6101910, 6101911, 6101912, 6101917, 6101918, 6101919, 6101920, 6101921, 6101922, 6101923, 6101924, 6101925, 6101926, 6101927, 6101928, 6101929, 6101930, 6101931, 6101932, 6101933, 6101934, 6101935, 6101936, 6101937, 6101938, 6101939, 6101940, 6101941, 6101942, 6101944, 6101945, 6101946, 6101947, 6101948, 6101949, 6101950, 6101951, 6101952, 6101953, 6101954, 6101955, 6101956, 6101957, 6101958, 6101960, 6101961, 6101962, 6101963, 6101964, 6101965, 6101966, 6101967, 6101968, 6101969, 6101970, 6101971, 6101972, 6101973, 6101974, 6101975, 6101976, 6101977, 6101978, 6101979, 6101980, 6101981, 6101982, 6101983, 6101985, 6101986, 6101987, 6101988, 6101989, 6101990, 6101991, 6101992, 6101993, 6101994, 6101995, 6101996, 6101997, 6101998, 6101999, 6102000, 6102001, 6102002, 6102003, 6102004, 6102006, 6102007, 6102008, 6102009, 6102010, 6102011, 6102012, 6102013, 6102014, 6102015, 6102017, 6102018, 6102019, 6102020, 6102021, 6102022, 6102023, 6102024, 6102025, 6102026, 6102027, 6102029, 6102030, 6102031, 6102032, 6102033, 6102034, 6102035, 6102036, 6102037, 6102038, 6102039, 6102040, 6102041, 6102042, 6102043, 6102044, 6102045, 6102046, 6102047, 6102049, 6102050, 6102051, 6102052, 6102053, 6102054, 6102055, 6102056, 6102057, 6102058, 6102059, 6102060, 6102061, 6102062, 6102063, 6102064, 6102065, 6102066, 6102067, 6102068, 6102069, 6102070, 6102071, 6102072, 6102073, 6102074, 6102075, 6102076, 6102077, 6102078, 6102079, 6102080, 6102081, 6102082, 6102083, 6102084, 6102085, 6102086, 6102087, 6102089, 6102090, 6102091, 6102092, 6102093, 6102094, 6102095, 6102096, 6102097, 6102098, 6102099, 6102100, 6102101, 6102102, 6102103, 6102104, 6102105, 6102106, 6102107, 6102108, 6102109, 6102110, 6102111, 6102112, 6102113, 6102114, 6102115, 6102116, 6102117, 6102118, 6102119, 6102120, 6102121, 6102122, 6102123, 6102124, 6102125, 6102126, 6102127, 6102128, 6102129, 6102130, 6102131, 6102132, 6102133, 6102134, 6102135, 6102136, 6102138, 6102139, 6102140, 6102141, 6102142, 6102143, 6102144, 6102145, 6102147, 6102148, 6102149, 6102150, 6102151, 6102152, 6102153, 6102154, 6102155, 6102156, 6102157, 6102158, 6102159, 6102160, 6102161, 6102162, 6102163, 6102164, 6102165, 6102166, 6102167, 6102168, 6102170, 6102172, 6102173, 6102174, 6102175, 6102176, 6102177, 6102178, 6102179, 6102180, 6102184, 6102185, 6102186, 6102187, 6102188, 6102189, 6102190, 6102191, 6102192, 6102193, 6102196, 6102197, 6102198, 6102199, 6102200, 6102201, 6102202, 6102203, 6102204, 6102205, 6102206, 6102207, 6102208, 6102209, 6102218, 6102221, 6102222, 6102223, 6102258, 6102259, 6102260, 6102261, 6102262, 6102263, 6102264, 6102265, 6102266, 6102268, 6102269, 6102270, 6102271, 6102272, 6102273, 6102274, 6102275, 6102276, 6102277, 6102278, 6102279, 6102280, 6102281, 6102282, 6102283, 6510739, 6510740, 6510854, 6510855, 6510999, 6647926, 6647927, 6647928, 6647931, 6647932, 6647933, 6647934, 6647935, 6647936, 6647937, 6647938, 6647939, 6647940, 6647941, 6647942, 6647943, 6647944, 6647945, 6647946, 6647949, 6647951, 6647952, 6647953, 6647954, 6647956, 6647957, 6647958, 6647959, 6647960, 6647961, 6647962, 6647963, 6647964, 6647965, 6647966, 6647967, 6647968, 6647969, 6647970, 6647971, 6647972, 6647973, 6647974, 6647975, 6647976, 6647977, 6647978, 6647979, 6647980, 6647981, 6647982, 6647983, 6647984, 6647985, 6647986, 6647987, 6647988, 6647989, 6647990, 6647991, 6647992, 6647993, 6647994, 6647995, 6647996, 6647997, 6647998, 6647999, 6648000, 6648001, 6648002, 6648003, 6648004, 6648005, 6648006, 6648007, 6648008, 6648009, 6648010, 6648011, 6648012, 6648013, 6648014, 6648015, 6648016, 6648017, 6648018, 6648019, 6648020, 6648021, 6648022, 6648023, 6648024, 6648025, 6648026, 6648027, 6648028, 6648029, 6648030, 6648031, 6648032, 6648033, 6648034, 6648035, 6648036, 6648037, 6648038, 6648039, 6648040, 6648041, 6648042, 6648043, 6648044, 6648045, 6648046, 6648047, 6648048, 6648049, 6648050, 6648051, 6648052, 6648053, 6648054, 6648055, 6648056, 6648057, 6648058, 6648059, 6648060, 6648061, 6648062, 6648063, 6648064, 6648065, 6648066, 6648067, 6648068, 6648069, 6648070, 6648071, 6648072, 6648073, 6648074, 6648075, 6648076, 6648077, 6648078, 6648079, 6648080, 6648081, 6648082, 6648083, 6648084, 6648085, 6648086, 6648087, 6648088, 6648089, 6648090, 6648091, 6648092, 6648093, 6648094, 6648095, 6648096, 6648097, 6648098, 6648099, 6648100, 6648101, 6648102, 6648103, 6648105, 6648106, 6648107, 6648108, 6648109, 6648110, 6648112, 6648113, 6648114, 6648115, 6648116, 6648117, 6648118, 6648119, 6648120, 6648122, 6648123, 6648124, 6648125, 6648126, 6648127, 6648128, 6648130, 6648131, 6648132, 6648135, 6648136, 6648137, 6648138, 6648139, 6648140, 6648141, 6648142, 6648143, 6648145, 6648147, 6648150, 6648151, 6648152, 6648153, 6648154, 6648155, 6648159, 6648161, 6648163, 6648164, 6648165, 6648166, 6648167, 6648168, 6648169, 6648170, 6648171, 6648172, 6648173, 6648175, 6648176, 6648177, 6648178, 6648179, 6648180, 6648181, 6648182, 6648183, 6648185, 6648186, 6648187, 6648188, 6648189, 6648190, 6648192, 6648193, 6648194, 6648195, 6648197, 6648198, 6648199, 6648200, 6648201, 6648202, 6648203, 6648204, 6648205, 6648206, 6648207, 6648208, 6648209, 6648210, 6648211, 6648213, 6648214, 6648215, 6648216, 6648217, 6648218, 6648219, 6648220, 6648222, 6648223, 6648224, 6648225, 6648233, 6648235, 6648236, 6648243, 6648244, 6648245, 6648246, 6648247, 6648248, 6648254, 6648256, 6648259, 6648260, 6648261, 6648263, 6648264, 6648265, 6648266, 6648267, 6648268, 6648269, 6648271, 6648272, 6648273, 6648275, 6648276, 6648277, 6648278, 6648280, 6648286, 6648287, 6648288, 6648289, 6648290, 6648291, 6648292, 6648293, 6648294, 6648295, 6648296, 6648297, 6648299, 6648303, 6648304, 6648305, 6648306, 6648307, 6648308, 6648309, 6648310, 6648311, 6648312, 6648313, 6648314, 6648315, 6648316, 6648317, 6648318, 6648319, 6648320, 6648321, 6648322, 6648324, 6648325, 6648326, 6648327, 6648328, 6648329, 6648331, 6648332, 6648333, 6648334, 6648335, 6648336, 6648337, 6648339, 6648340, 6648341, 6648342, 6648343, 6648344, 6648346, 6648347, 6648348, 6648349, 6648350, 6648351, 6648352, 6648354, 6648355, 6648356, 6648357, 6648358, 6648378, 6648380, 6648381, 6648382, 6648383, 6648384, 6648385, 6648386, 6648387, 6648388, 6648389, 6648390, 6648392, 6648393, 6648395, 6648396, 6648397, 6648398, 6648400, 6648421, 6648423, 6648424, 6648425, 6648426, 6648427, 6648428, 6648429, 6648430, 6648431, 6648432, 6648433, 6648434, 6648435, 6648436, 6648438, 6648439, 6648440, 6648441, 6648443, 6648444, 6648445, 6648446, 6648447, 6648448, 6648450, 6648451, 6648453, 6648454, 6648455, 6648457, 6648458, 6648459, 6648460, 6648461, 6648462, 6648463, 6648464, 6648465, 6648467, 6648468, 6648470, 6648494, 6648495, 6648496, 6648497, 6648498, 6648500, 6648501, 6648502, 6648505, 6648509, 6648510, 6648511, 6648512, 6648513, 6648514, 6648516, 6648517, 6648518, 6648520, 6648522, 6648524, 6648525, 6648527, 6648528, 6648530, 6648531, 6648532, 6648533, 6648534, 6648535, 6648536, 6654350, 6654379, 6654397, 6654398, 6654437, 6654451, 6648507) and date(`dtEventDate`) >= '2025-04-28' order by `dtEventDate` asc limit 12
25.01ms/app/Events.php:380etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `nq_events` where `dtEventDate` between '2025-04-28 10:25:06' and '2025-12-31 23:59:59' and (`chrDelete` = 'N') and `fkeventGlcode` in (5750149, 5750150, 5750151, 5750152, 5750153, 5750154, 5750155, 5750156, 5750157, 5750158, 5750159, 5750160, 5750161, 5750162, 5750163, 5750164, 5750165, 5750166, 5750167, 5750168, 5750169, 5750170, 5750171, 5750207, 5750208, 5750209, 5750210, 5750211, 5750212, 5750213, 5750214, 5750215, 5750216, 5750217, 5750218, 5750219, 5750220, 5750221, 5750222, 5750223, 5750224, 5750225, 5750226, 5750227, 5750228, 5750229, 6101855, 6101857, 6101858, 6101859, 6101860, 6101861, 6101862, 6101863, 6101864, 6101865, 6101869, 6101870, 6101871, 6101872, 6101873, 6101876, 6101877, 6101878, 6101879, 6101880, 6101881, 6101882, 6101883, 6101884, 6101885, 6101886, 6101887, 6101888, 6101889, 6101890, 6101891, 6101892, 6101893, 6101894, 6101895, 6101896, 6101897, 6101899, 6101901, 6101902, 6101903, 6101904, 6101905, 6101909, 6101910, 6101911, 6101912, 6101917, 6101918, 6101919, 6101920, 6101921, 6101922, 6101923, 6101924, 6101925, 6101926, 6101927, 6101928, 6101929, 6101930, 6101931, 6101932, 6101933, 6101934, 6101935, 6101936, 6101937, 6101938, 6101939, 6101940, 6101941, 6101942, 6101944, 6101945, 6101946, 6101947, 6101948, 6101949, 6101950, 6101951, 6101952, 6101953, 6101954, 6101955, 6101956, 6101957, 6101958, 6101960, 6101961, 6101962, 6101963, 6101964, 6101965, 6101966, 6101967, 6101968, 6101969, 6101970, 6101971, 6101972, 6101973, 6101974, 6101975, 6101976, 6101977, 6101978, 6101979, 6101980, 6101981, 6101982, 6101983, 6101985, 6101986, 6101987, 6101988, 6101989, 6101990, 6101991, 6101992, 6101993, 6101994, 6101995, 6101996, 6101997, 6101998, 6101999, 6102000, 6102001, 6102002, 6102003, 6102004, 6102006, 6102007, 6102008, 6102009, 6102010, 6102011, 6102012, 6102013, 6102014, 6102015, 6102017, 6102018, 6102019, 6102020, 6102021, 6102022, 6102023, 6102024, 6102025, 6102026, 6102027, 6102029, 6102030, 6102031, 6102032, 6102033, 6102034, 6102035, 6102036, 6102037, 6102038, 6102039, 6102040, 6102041, 6102042, 6102043, 6102044, 6102045, 6102046, 6102047, 6102049, 6102050, 6102051, 6102052, 6102053, 6102054, 6102055, 6102056, 6102057, 6102058, 6102059, 6102060, 6102061, 6102062, 6102063, 6102064, 6102065, 6102066, 6102067, 6102068, 6102069, 6102070, 6102071, 6102072, 6102073, 6102074, 6102075, 6102076, 6102077, 6102078, 6102079, 6102080, 6102081, 6102082, 6102083, 6102084, 6102085, 6102086, 6102087, 6102089, 6102090, 6102091, 6102092, 6102093, 6102094, 6102095, 6102096, 6102097, 6102098, 6102099, 6102100, 6102101, 6102102, 6102103, 6102104, 6102105, 6102106, 6102107, 6102108, 6102109, 6102110, 6102111, 6102112, 6102113, 6102114, 6102115, 6102116, 6102117, 6102118, 6102119, 6102120, 6102121, 6102122, 6102123, 6102124, 6102125, 6102126, 6102127, 6102128, 6102129, 6102130, 6102131, 6102132, 6102133, 6102134, 6102135, 6102136, 6102138, 6102139, 6102140, 6102141, 6102142, 6102143, 6102144, 6102145, 6102147, 6102148, 6102149, 6102150, 6102151, 6102152, 6102153, 6102154, 6102155, 6102156, 6102157, 6102158, 6102159, 6102160, 6102161, 6102162, 6102163, 6102164, 6102165, 6102166, 6102167, 6102168, 6102170, 6102172, 6102173, 6102174, 6102175, 6102176, 6102177, 6102178, 6102179, 6102180, 6102184, 6102185, 6102186, 6102187, 6102188, 6102189, 6102190, 6102191, 6102192, 6102193, 6102196, 6102197, 6102198, 6102199, 6102200, 6102201, 6102202, 6102203, 6102204, 6102205, 6102206, 6102207, 6102208, 6102209, 6102218, 6102221, 6102222, 6102223, 6102258, 6102259, 6102260, 6102261, 6102262, 6102263, 6102264, 6102265, 6102266, 6102268, 6102269, 6102270, 6102271, 6102272, 6102273, 6102274, 6102275, 6102276, 6102277, 6102278, 6102279, 6102280, 6102281, 6102282, 6102283, 6510739, 6510740, 6510854, 6510855, 6510999, 6647926, 6647927, 6647928, 6647931, 6647932, 6647933, 6647934, 6647935, 6647936, 6647937, 6647938, 6647939, 6647940, 6647941, 6647942, 6647943, 6647944, 6647945, 6647946, 6647949, 6647951, 6647952, 6647953, 6647954, 6647956, 6647957, 6647958, 6647959, 6647960, 6647961, 6647962, 6647963, 6647964, 6647965, 6647966, 6647967, 6647968, 6647969, 6647970, 6647971, 6647972, 6647973, 6647974, 6647975, 6647976, 6647977, 6647978, 6647979, 6647980, 6647981, 6647982, 6647983, 6647984, 6647985, 6647986, 6647987, 6647988, 6647989, 6647990, 6647991, 6647992, 6647993, 6647994, 6647995, 6647996, 6647997, 6647998, 6647999, 6648000, 6648001, 6648002, 6648003, 6648004, 6648005, 6648006, 6648007, 6648008, 6648009, 6648010, 6648011, 6648012, 6648013, 6648014, 6648015, 6648016, 6648017, 6648018, 6648019, 6648020, 6648021, 6648022, 6648023, 6648024, 6648025, 6648026, 6648027, 6648028, 6648029, 6648030, 6648031, 6648032, 6648033, 6648034, 6648035, 6648036, 6648037, 6648038, 6648039, 6648040, 6648041, 6648042, 6648043, 6648044, 6648045, 6648046, 6648047, 6648048, 6648049, 6648050, 6648051, 6648052, 6648053, 6648054, 6648055, 6648056, 6648057, 6648058, 6648059, 6648060, 6648061, 6648062, 6648063, 6648064, 6648065, 6648066, 6648067, 6648068, 6648069, 6648070, 6648071, 6648072, 6648073, 6648074, 6648075, 6648076, 6648077, 6648078, 6648079, 6648080, 6648081, 6648082, 6648083, 6648084, 6648085, 6648086, 6648087, 6648088, 6648089, 6648090, 6648091, 6648092, 6648093, 6648094, 6648095, 6648096, 6648097, 6648098, 6648099, 6648100, 6648101, 6648102, 6648103, 6648105, 6648106, 6648107, 6648108, 6648109, 6648110, 6648112, 6648113, 6648114, 6648115, 6648116, 6648117, 6648118, 6648119, 6648120, 6648122, 6648123, 6648124, 6648125, 6648126, 6648127, 6648128, 6648130, 6648131, 6648132, 6648135, 6648136, 6648137, 6648138, 6648139, 6648140, 6648141, 6648142, 6648143, 6648145, 6648147, 6648150, 6648151, 6648152, 6648153, 6648154, 6648155, 6648159, 6648161, 6648163, 6648164, 6648165, 6648166, 6648167, 6648168, 6648169, 6648170, 6648171, 6648172, 6648173, 6648175, 6648176, 6648177, 6648178, 6648179, 6648180, 6648181, 6648182, 6648183, 6648185, 6648186, 6648187, 6648188, 6648189, 6648190, 6648192, 6648193, 6648194, 6648195, 6648197, 6648198, 6648199, 6648200, 6648201, 6648202, 6648203, 6648204, 6648205, 6648206, 6648207, 6648208, 6648209, 6648210, 6648211, 6648213, 6648214, 6648215, 6648216, 6648217, 6648218, 6648219, 6648220, 6648222, 6648223, 6648224, 6648225, 6648233, 6648235, 6648236, 6648243, 6648244, 6648245, 6648246, 6648247, 6648248, 6648254, 6648256, 6648259, 6648260, 6648261, 6648263, 6648264, 6648265, 6648266, 6648267, 6648268, 6648269, 6648271, 6648272, 6648273, 6648275, 6648276, 6648277, 6648278, 6648280, 6648286, 6648287, 6648288, 6648289, 6648290, 6648291, 6648292, 6648293, 6648294, 6648295, 6648296, 6648297, 6648299, 6648303, 6648304, 6648305, 6648306, 6648307, 6648308, 6648309, 6648310, 6648311, 6648312, 6648313, 6648314, 6648315, 6648316, 6648317, 6648318, 6648319, 6648320, 6648321, 6648322, 6648324, 6648325, 6648326, 6648327, 6648328, 6648329, 6648331, 6648332, 6648333, 6648334, 6648335, 6648336, 6648337, 6648339, 6648340, 6648341, 6648342, 6648343, 6648344, 6648346, 6648347, 6648348, 6648349, 6648350, 6648351, 6648352, 6648354, 6648355, 6648356, 6648357, 6648358, 6648378, 6648380, 6648381, 6648382, 6648383, 6648384, 6648385, 6648386, 6648387, 6648388, 6648389, 6648390, 6648392, 6648393, 6648395, 6648396, 6648397, 6648398, 6648400, 6648421, 6648423, 6648424, 6648425, 6648426, 6648427, 6648428, 6648429, 6648430, 6648431, 6648432, 6648433, 6648434, 6648435, 6648436, 6648438, 6648439, 6648440, 6648441, 6648443, 6648444, 6648445, 6648446, 6648447, 6648448, 6648450, 6648451, 6648453, 6648454, 6648455, 6648457, 6648458, 6648459, 6648460, 6648461, 6648462, 6648463, 6648464, 6648465, 6648467, 6648468, 6648470, 6648494, 6648495, 6648496, 6648497, 6648498, 6648500, 6648501, 6648502, 6648505, 6648509, 6648510, 6648511, 6648512, 6648513, 6648514, 6648516, 6648517, 6648518, 6648520, 6648522, 6648524, 6648525, 6648527, 6648528, 6648530, 6648531, 6648532, 6648533, 6648534, 6648535, 6648536, 6654350, 6654379, 6654397, 6654398, 6654437, 6654451, 6648507) and date(`dtEventDate`) >= '2025-04-28'
23ms/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` = 'NV' and `nq_peformers`.`intChildCatId` = 42815 and `nq_peformers`.`total_count` != 0 group by `nq_peformers`.`id`) as `aggregate_table`
6.41ms/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` = 42815 limit 1
7.15ms/packages/Powerpanel/Performers/src/Models/Performers.php:1299etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `varTitle`, `intCategoryId` from `nq_categories` where `intCategoryId` = 3 limit 1
7.21ms/packages/Powerpanel/Categories/src/Models/Categories.php:962etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `varTitle`, `intCategoryId` from `nq_categories` where `intCategoryId` = 35 and `intParentCategoryId` = 3 limit 1
7.5ms/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` = 'Las Vegas') and (`varStateProvince` = 'NV') limit 1
9.63ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101930 and `chrIsPreview` = 'N' limit 1
6.08ms/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')
3.07ms/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')
5.99ms/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.12.154.26" ] "x-real-ip" => array:1 [▶ 0 => "3.12.154.26" ] "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.12.154.26" "HTTP_X_REAL_IP" => "3.12.154.26" "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.12.154.26" "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/cirque-du-soleil-mad-apple-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" => 1745853905.8967 "REQUEST_TIME" => 1745853905 ]
[]
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, 28 Apr 2025 15:25:06 GMT" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => "-1" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ijlyb0FLdWVJYXZHblNoR1RSVGxUN1E9PSIsInZhbHVlIjoicUpPVzh0OVErQ3NUTFVxWUVhY0o0aWVtdEdBT1Bma1BNZXZoOTlSRFRCVjdOeHFKckNIRTE3cENyUTVXbHB1U2E3NWFRaUFpM3M4V21aTFJ0U0tqcjNDc0laamd1M011SWdXQzF0RGIyVWpqZGViQWFlSUorUm82aXFkYXROcUoiLCJtYWMiOiIzZDNkZmIwYWJjOWM2ZTdlYTk4NDVmNWI0NTcyOWU0ZGY0NDE1YmRiMDFjZDAyOTNhYWY3ZDM1MWNhM2QyNzdlIiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 17:25:06 GMT; Max-Age=7200; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Ijlyb0FLdWVJYXZHblNoR1RSVGxUN1E9PSIsInZhbHVlIjoicUpPVzh0OVErQ3NUTFVxWUVhY0o0aWVtdEdBT1Bma1BNZXZoOTlSRFRCVjdOeHFKckNIRTE3cENyUTVXbHB1U2E3NWFRa ▶" 1 => "recently_viewed=QzcTWMBQI6KmNMAncAPe; expires=Tue, 29 Apr 2025 15:25:06 GMT; Max-Age=86400; path=/; secure; httponly" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ijlyb0FLdWVJYXZHblNoR1RSVGxUN1E9PSIsInZhbHVlIjoicUpPVzh0OVErQ3NUTFVxWUVhY0o0aWVtdEdBT1Bma1BNZXZoOTlSRFRCVjdOeHFKckNIRTE3cENyUTVXbHB1U2E3NWFRaUFpM3M4V21aTFJ0U0tqcjNDc0laamd1M011SWdXQzF0RGIyVWpqZGViQWFlSUorUm82aXFkYXROcUoiLCJtYWMiOiIzZDNkZmIwYWJjOWM2ZTdlYTk4NDVmNWI0NTcyOWU0ZGY0NDE1YmRiMDFjZDAyOTNhYWY3ZDM1MWNhM2QyNzdlIiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 17:25:06 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Ijlyb0FLdWVJYXZHblNoR1RSVGxUN1E9PSIsInZhbHVlIjoicUpPVzh0OVErQ3NUTFVxWUVhY0o0aWVtdEdBT1Bma1BNZXZoOTlSRFRCVjdOeHFKckNIRTE3cENyUTVXbHB1U2E3NWFRa ▶" 1 => "recently_viewed=QzcTWMBQI6KmNMAncAPe; expires=Tue, 29-Apr-2025 15:25:06 GMT; path=/; secure; httponly" ] ]
0 of 0array:2 [▼ "_token" => "eq7wTLIAKLMtCjXhjQuLGAQ6uaA9GLKrUnqCcXFB" "PHPDEBUGBAR_STACK_DATA" => [] ]