Total Queries: 82
Total Time: 1.1536836624146
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1791343296.9781
[end] => 1791343296.9784
[time] => 0.0003669261932373
)
[1] => Array
(
[query] => select * from championship where championship_id = '12'
[start] => 1791343296.9812
[end] => 1791343296.9816
[time] => 0.00036096572875977
)
[2] => Array
(
[query] => select * from team_to_championship where championship_id = '12'
[start] => 1791343296.9817
[end] => 1791343296.9821
[time] => 0.00033187866210938
)
[3] => Array
(
[query] => select * from matches where championship_id = '12' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end ASC,
round_id+0,
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end
ASC
[start] => 1791343296.9822
[end] => 1791343296.9873
[time] => 0.005051851272583
)
[4] => Array
(
[query] => select * from match_time where match_id in (2620,2618,2621,2625,2623,2622,2624,2627,2626,2628,2629,2630,2633,2631,2632,2635,2636,2637,2634,2638,2639,2641,2640,2642,2643,2644,2648,2646,2647,2649,2651,2653,2650,2652,2654,2657,2656,2655,2659,2661,2660,2658,2619,2664,2665,2662,2663,2669,2667,2666,2668,2671,2672,2670,2673,2645) order by id ASC
[start] => 1791343296.9877
[end] => 1791343296.9915
[time] => 0.0038111209869385
)
[5] => Array
(
[query] => SELECT * FROM match_data where match_id IN (2620,2618,2621,2625,2623,2622,2624,2627,2626,2628,2629,2630,2633,2631,2632,2635,2636,2637,2634,2638,2639,2641,2640,2642,2643,2644,2648,2646,2647,2649,2651,2653,2650,2652,2654,2657,2656,2655,2659,2661,2660,2658,2619,2664,2665,2662,2663,2669,2667,2666,2668,2671,2672,2670,2673,2645)
[start] => 1791343297.1303
[end] => 1791343297.1477
[time] => 0.017358064651489
)
[6] => Array
(
[query] => select team.*,team_to_club.club_id,team_to_club.start,team_to_club.end from team
left join team_to_club on (team.team_id = team_to_club.team_id) where deleted = '0' AND (start = 0 OR start <= 1791343297 OR start >= 1791343297) AND (end >= 1791343297 OR end = 0) AND (start < 1791343297) ORDER BY name ASC
[start] => 1791343297.1694
[end] => 1791343297.1707
[time] => 0.0013201236724854
)
[7] => Array
(
[query] => select * from championship where championship_id = '12'
[start] => 1791343297.1709
[end] => 1791343297.1711
[time] => 0.00028491020202637
)
[8] => Array
(
[query] => select * from team_to_championship where championship_id = '12'
[start] => 1791343297.1713
[end] => 1791343297.1716
[time] => 0.00034499168395996
)
[9] => Array
(
[query] => select * from matches where championship_id = '12' ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343297.1718
[end] => 1791343297.1755
[time] => 0.0036611557006836
)
[10] => Array
(
[query] => select * from match_time where match_id in (2620,2618,2621,2619,2625,2623,2622,2624,2627,2626,2628,2629,2630,2633,2631,2632,2635,2636,2637,2634,2638,2639,2641,2640,2642,2643,2644,2645,2648,2646,2647,2649,2651,2653,2650,2652,2654,2657,2656,2655,2659,2661,2660,2658,2664,2665,2662,2663,2669,2667,2666,2668,2671,2672,2670,2673) order by id ASC
[start] => 1791343297.176
[end] => 1791343297.1798
[time] => 0.0038378238677979
)
[11] => Array
(
[query] => select * from team_to_championship where championship_id = '12'
[start] => 1791343297.3838
[end] => 1791343297.3842
[time] => 0.00046706199645996
)
[12] => Array
(
[query] => select * from championship where championship_id = '12'
[start] => 1791343297.3852
[end] => 1791343297.3855
[time] => 0.00033307075500488
)
[13] => Array
(
[query] => select * from team_to_championship where championship_id = '12'
[start] => 1791343297.3856
[end] => 1791343297.3859
[time] => 0.00031089782714844
)
[14] => Array
(
[query] => select * from team_to_championship where championship_id = '12'
[start] => 1791343297.386
[end] => 1791343297.3862
[time] => 0.0002448558807373
)
[15] => Array
(
[query] => select player.*,player_to_team.team_id,player_to_team.number,player_to_team.start,player_to_team.end from player
left join player_to_team on (player.player_id = player_to_team.player_id) where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1791343297.3863
[end] => 1791343297.3957
[time] => 0.0094189643859863
)
[16] => Array
(
[query] => select player.*,player_to_team.team_id,player_to_team.number,player_to_team.start,player_to_team.end from player
left join player_to_team on (player.player_id = player_to_team.player_id) where player.gender = 'male' AND deleted = '0' AND (start = 0 OR start <= 1663340180 OR start >= 1663340180) AND (end >= 1693519200 OR end = 0) AND (start < 1693519200) AND team_id in (23,43,25,9,40,24,26,27) ORDER BY lastname,firstname ASC
[start] => 1791343297.401
[end] => 1791343297.4029
[time] => 0.0019419193267822
)
[17] => Array
(
[query] => SELECT player_id, COUNT(player_id) as attendance FROM match_roster where match_id IN (select match_id from matches where championship_id = '12') AND match_id NOT IN (select match_id from matches where championship_id IN (select championship_id from championship where show_player_ranking = '0')) GROUP BY player_id
[start] => 1791343297.4034
[end] => 1791343297.4202
[time] => 0.016803979873657
)
[18] => Array
(
[query] => SELECT
player_id,
SUM(
CASE
WHEN point != 'A' THEN point
END
) as total,
SUM(
CASE
WHEN point = 'A' THEN 1
WHEN point != 'A' THEN 0
END
) as autohit,
SUM(
CASE
WHEN point = '3' THEN 1
WHEN point != '3' THEN 0
END
) as defense,
SUM(
CASE
WHEN point = '2' THEN 1
WHEN point != '2' THEN 0
END
) as attack,
SUM(
CASE
WHEN point = 'P' THEN 1
WHEN point != 'P' THEN 0
END
) as admonitions,
SUM(
CASE
WHEN point = 'E' THEN 1
WHEN point != 'E' THEN 0
END
) as expulsions
FROM point WHERE match_id IN (select match_id from matches where championship_id = '12') and player_id in (select player_id from player where gender = 'male') group by player_id order by total DESC
[start] => 1791343297.4205
[end] => 1791343297.7154
[time] => 0.29488682746887
)
[19] => Array
(
[query] => select * from championship where championship_id = '12'
[start] => 1791343297.7169
[end] => 1791343297.7173
[time] => 0.00037407875061035
)
[20] => Array
(
[query] => select * from team_to_championship where championship_id = '12'
[start] => 1791343297.7174
[end] => 1791343297.7178
[time] => 0.00035500526428223
)
[21] => Array
(
[query] => select * from team_to_championship where championship_id = '12'
[start] => 1791343297.7178
[end] => 1791343297.7181
[time] => 0.00032186508178711
)
[22] => Array
(
[query] => select player.*,player_to_team.team_id,player_to_team.number,player_to_team.start,player_to_team.end from player
left join player_to_team on (player.player_id = player_to_team.player_id) where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1791343297.7182
[end] => 1791343297.7274
[time] => 0.0091879367828369
)
[23] => Array
(
[query] => select player.*,player_to_team.team_id,player_to_team.number,player_to_team.start,player_to_team.end from player
left join player_to_team on (player.player_id = player_to_team.player_id) where player.gender = 'female' AND deleted = '0' AND (start = 0 OR start <= 1663340180 OR start >= 1663340180) AND (end >= 1693519200 OR end = 0) AND (start < 1693519200) AND team_id in (23,43,25,9,40,24,26,27) ORDER BY lastname,firstname ASC
[start] => 1791343297.7328
[end] => 1791343297.7342
[time] => 0.001413106918335
)
[24] => Array
(
[query] => SELECT player_id, COUNT(player_id) as attendance FROM match_roster where match_id IN (select match_id from matches where championship_id = '12') AND match_id NOT IN (select match_id from matches where championship_id IN (select championship_id from championship where show_player_ranking = '0')) GROUP BY player_id
[start] => 1791343297.7345
[end] => 1791343297.7512
[time] => 0.016757965087891
)
[25] => Array
(
[query] => SELECT
player_id,
SUM(
CASE
WHEN point != 'A' THEN point
END
) as total,
SUM(
CASE
WHEN point = 'A' THEN 1
WHEN point != 'A' THEN 0
END
) as autohit,
SUM(
CASE
WHEN point = '3' THEN 1
WHEN point != '3' THEN 0
END
) as defense,
SUM(
CASE
WHEN point = '2' THEN 1
WHEN point != '2' THEN 0
END
) as attack,
SUM(
CASE
WHEN point = 'P' THEN 1
WHEN point != 'P' THEN 0
END
) as admonitions,
SUM(
CASE
WHEN point = 'E' THEN 1
WHEN point != 'E' THEN 0
END
) as expulsions
FROM point WHERE match_id IN (select match_id from matches where championship_id = '12') and player_id in (select player_id from player where gender = 'female') group by player_id order by total DESC
[start] => 1791343297.7513
[end] => 1791343298.0356
[time] => 0.28425812721252
)
[26] => Array
(
[query] => select player.*,player_to_team.team_id,player_to_team.number,player_to_team.start,player_to_team.end from player
left join player_to_team on (player.player_id = player_to_team.player_id) where (start = 0 OR start <= 1663340180 OR start >= 1663340180) AND (end >= 1693519200 OR end = 0) AND (start < 1693519200) ORDER BY lastname,firstname ASC
[start] => 1791343298.0367
[end] => 1791343298.0411
[time] => 0.0044040679931641
)
[27] => Array
(
[query] => select * from referee where deleted = '0' ORDER BY lastname,firstname ASC
[start] => 1791343298.0431
[end] => 1791343298.044
[time] => 0.00089097023010254
)
[28] => Array
(
[query] => select * from location where deleted = '0' ORDER BY name ASC
[start] => 1791343298.0445
[end] => 1791343298.0449
[time] => 0.00035691261291504
)
[29] => Array
(
[query] => select team.*,team_to_club.club_id,team_to_club.start,team_to_club.end from team
left join team_to_club on (team.team_id = team_to_club.team_id) where (start = 0 OR start <= 1791343298 OR start >= 1791343298) AND (end >= 1791343298 OR end = 0) AND (start < 1791343298) ORDER BY name ASC
[start] => 1791343298.045
[end] => 1791343298.0461
[time] => 0.001133918762207
)
[30] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1791343298.0485
[end] => 1791343298.0489
[time] => 0.00047898292541504
)
[31] => Array
(
[query] => select * from matches where championship_id = '52' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.0491
[end] => 1791343298.0561
[time] => 0.0069789886474609
)
[32] => Array
(
[query] => select * from match_time where match_id in (4813,4814,4815,4816,4817,4818,4819,4820,4821,4822,4823,4824,4825,4826,4827,4828,4829,4830,4831,4832,4833,4834,4835,4836,4837,4838,4839,4840,4841,4842,4843,4844,4845,4846,4847,4848,4849,4850,4851,4852,4853,4854,4855,4856,4857,4858,4859,4860,4861,4862,4863,4864,4865,4866,4867,4868,4869,4870,4871,4872,4873,4874,4875,4876,4877,4878,4879,4880,4881,4882,4883,4884,4885,4886,4887,4888,4889,4890,4891,4892,4893,4894,4895,4896,4897,4898,4899,4900,4901,4902) order by id ASC
[start] => 1791343298.0564
[end] => 1791343298.0599
[time] => 0.0034627914428711
)
[33] => Array
(
[query] => select * from matches where championship_id = '53' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.0602
[end] => 1791343298.067
[time] => 0.0068290233612061
)
[34] => Array
(
[query] => select * from match_time where match_id in (4903,4904,4905,4906,4907,4908,4909,4910,4911,4912,4913,4914,4915,4916,4917,4918,4919,4920,4921,4922,4923,4924,4925,4926,4927,4928,4929,4930,4931,4932,4933,4934,4935,4936,4937,4938,4939,4940,4941,4942,4943,4944,4945,4946,4947,4948,4949,4950,4951,4952,4953,4954,4955,4956,4957,4958,4959,4960,4961,4962,4963,4964,4965,4966,4967,4968,4969,4970,4971,4972,4973,4974,4975,4976,4977,4978,4979,4980,4981,4982,4983,4984,4985,4986,4987,4988,4989,4990,4991,4992) order by id ASC
[start] => 1791343298.0673
[end] => 1791343298.0707
[time] => 0.0034270286560059
)
[35] => Array
(
[query] => select * from matches where championship_id = '54' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.071
[end] => 1791343298.0778
[time] => 0.0067939758300781
)
[36] => Array
(
[query] => select * from match_time where match_id in (4993,4994,4995,4996,4997,4998,4999,5000,5001,5002,5003,5004,5005,5006,5007,5008,5009,5010,5011,5012,5013,5014,5015,5016,5017,5018,5019,5020,5021,5022,5023,5024,5025,5026,5027,5028,5029,5030,5031,5032,5033,5034,5035,5036,5037,5038,5039,5040,5041,5042,5043,5044,5045,5046,5047,5048,5049,5050,5051,5052,5053,5054,5055,5056,5057,5058,5059,5060,5061,5062,5063,5064,5065,5066,5067,5068,5069,5070,5071,5072,5073,5074,5075,5076,5077,5078,5079,5080,5081,5082) order by id ASC
[start] => 1791343298.0782
[end] => 1791343298.0815
[time] => 0.0033040046691895
)
[37] => Array
(
[query] => select * from matches where championship_id = '55' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.0818
[end] => 1791343298.0886
[time] => 0.0067641735076904
)
[38] => Array
(
[query] => select * from match_time where match_id in (5083,5084,5085,5086,5087,5088,5089,5090,5091,5092,5093,5094,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5105,5106,5107,5108,5109,5110,5111,5112,5113,5114,5115,5116,5117,5118,5119,5120,5121,5122,5123,5124,5125,5126,5127,5128,5129,5130,5131,5132,5133,5134,5135,5136,5137,5138,5139,5140,5141,5142,5143,5144,5145,5146,5147,5148,5149,5150,5151,5152,5153,5154,5155,5156,5157,5158,5159,5160,5161,5162,5163,5164,5165,5166,5167,5168,5169,5170,5171,5172) order by id ASC
[start] => 1791343298.0889
[end] => 1791343298.0923
[time] => 0.0033421516418457
)
[39] => Array
(
[query] => select * from matches where championship_id = '51' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.0925
[end] => 1791343298.0989
[time] => 0.0064070224761963
)
[40] => Array
(
[query] => select * from matches where championship_id = '49' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.0992
[end] => 1791343298.1054
[time] => 0.0062351226806641
)
[41] => Array
(
[query] => select * from matches where championship_id = '50' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.1057
[end] => 1791343298.112
[time] => 0.0063209533691406
)
[42] => Array
(
[query] => select * from matches where championship_id = '48' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.1122
[end] => 1791343298.1186
[time] => 0.0063560009002686
)
[43] => Array
(
[query] => select * from matches where championship_id = '39' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.1188
[end] => 1791343298.1251
[time] => 0.0062940120697021
)
[44] => Array
(
[query] => select * from matches where championship_id = '41' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.1253
[end] => 1791343298.1317
[time] => 0.006350040435791
)
[45] => Array
(
[query] => select * from matches where championship_id = '42' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.1319
[end] => 1791343298.1382
[time] => 0.0063660144805908
)
[46] => Array
(
[query] => select * from matches where championship_id = '43' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.1385
[end] => 1791343298.1449
[time] => 0.0063929557800293
)
[47] => Array
(
[query] => select * from matches where championship_id = '47' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.1451
[end] => 1791343298.1514
[time] => 0.0063040256500244
)
[48] => Array
(
[query] => select * from matches where championship_id = '46' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.1516
[end] => 1791343298.1591
[time] => 0.0074748992919922
)
[49] => Array
(
[query] => select * from matches where championship_id = '38' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.1593
[end] => 1791343298.175
[time] => 0.015718936920166
)
[50] => Array
(
[query] => select * from matches where championship_id = '33' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.1753
[end] => 1791343298.1836
[time] => 0.0083048343658447
)
[51] => Array
(
[query] => select * from matches where championship_id = '34' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.1838
[end] => 1791343298.1933
[time] => 0.0094079971313477
)
[52] => Array
(
[query] => select * from matches where championship_id = '35' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.1935
[end] => 1791343298.2091
[time] => 0.015614032745361
)
[53] => Array
(
[query] => select * from matches where championship_id = '30' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.2093
[end] => 1791343298.2179
[time] => 0.0085940361022949
)
[54] => Array
(
[query] => select * from matches where championship_id = '31' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.2182
[end] => 1791343298.2249
[time] => 0.0066587924957275
)
[55] => Array
(
[query] => select * from matches where championship_id = '32' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.2251
[end] => 1791343298.2345
[time] => 0.0094840526580811
)
[56] => Array
(
[query] => select * from matches where championship_id = '36' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.2348
[end] => 1791343298.2412
[time] => 0.006417989730835
)
[57] => Array
(
[query] => select * from matches where championship_id = '37' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.2415
[end] => 1791343298.2544
[time] => 0.012912034988403
)
[58] => Array
(
[query] => select * from matches where championship_id = '25' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.2546
[end] => 1791343298.2668
[time] => 0.012206077575684
)
[59] => Array
(
[query] => select * from matches where championship_id = '26' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.2671
[end] => 1791343298.2787
[time] => 0.011630058288574
)
[60] => Array
(
[query] => select * from matches where championship_id = '29' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.2789
[end] => 1791343298.2948
[time] => 0.015820980072021
)
[61] => Array
(
[query] => select * from matches where championship_id = '28' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.295
[end] => 1791343298.308
[time] => 0.013032913208008
)
[62] => Array
(
[query] => select * from matches where championship_id = '22' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.3083
[end] => 1791343298.3188
[time] => 0.010501861572266
)
[63] => Array
(
[query] => select * from matches where championship_id = '23' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.319
[end] => 1791343298.333
[time] => 0.014055013656616
)
[64] => Array
(
[query] => select * from matches where championship_id = '18' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.3333
[end] => 1791343298.3475
[time] => 0.014279127120972
)
[65] => Array
(
[query] => select * from matches where championship_id = '19' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.3478
[end] => 1791343298.3588
[time] => 0.011027097702026
)
[66] => Array
(
[query] => select * from matches where championship_id = '20' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.3591
[end] => 1791343298.3735
[time] => 0.014368057250977
)
[67] => Array
(
[query] => select * from matches where championship_id = '21' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.3738
[end] => 1791343298.3861
[time] => 0.012331962585449
)
[68] => Array
(
[query] => select * from matches where championship_id = '13' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.3863
[end] => 1791343298.3982
[time] => 0.011842966079712
)
[69] => Array
(
[query] => select * from matches where championship_id = '15' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.3989
[end] => 1791343298.4121
[time] => 0.013146877288818
)
[70] => Array
(
[query] => select * from matches where championship_id = '16' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.4123
[end] => 1791343298.4268
[time] => 0.014467000961304
)
[71] => Array
(
[query] => select * from matches where championship_id = '17' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.427
[end] => 1791343298.4418
[time] => 0.014794111251831
)
[72] => Array
(
[query] => select * from matches where championship_id = '14' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.442
[end] => 1791343298.4536
[time] => 0.011584043502808
)
[73] => Array
(
[query] => select * from matches where championship_id = '8' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.4538
[end] => 1791343298.4743
[time] => 0.020493030548096
)
[74] => Array
(
[query] => select * from matches where championship_id = '10' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.4746
[end] => 1791343298.4918
[time] => 0.017243146896362
)
[75] => Array
(
[query] => select * from matches where championship_id = '11' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.4921
[end] => 1791343298.5
[time] => 0.0079460144042969
)
[76] => Array
(
[query] => select * from matches where championship_id = '12' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.5002
[end] => 1791343298.5066
[time] => 0.0064001083374023
)
[77] => Array
(
[query] => select * from matches where championship_id = '6' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.5068
[end] => 1791343298.5133
[time] => 0.0064620971679688
)
[78] => Array
(
[query] => select * from matches where championship_id = '5' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.5135
[end] => 1791343298.52
[time] => 0.0064330101013184
)
[79] => Array
(
[query] => select * from matches where championship_id = '2' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.5202
[end] => 1791343298.5271
[time] => 0.0068891048431396
)
[80] => Array
(
[query] => select * from matches where championship_id = '3' AND match_id NOT IN (select match_id from match_time group by match_id) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1791343298.5273
[end] => 1791343298.534
[time] => 0.0067448616027832
)
[81] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1791343298.5347
[end] => 1791343298.5351
[time] => 0.00039792060852051
)
)
Black Knights
Iron Lion Tyson
Trefferspan
Meatballs
Krakens Chivasso
Explichit
Padawan
Legio X