Total Queries: 26
Total Time: 0.3819797039032
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770959599.4228
[end] => 1770959599.4231
[time] => 0.00027704238891602
)
[1] => Array
(
[query] => select * from location where location_id = '9'
[start] => 1770959599.4247
[end] => 1770959599.425
[time] => 0.00032806396484375
)
[2] => Array
(
[query] => select * from matches where date >= '1770937200' AND location_id = '9' 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 LIMIT 0,5
[start] => 1770959599.4253
[end] => 1770959599.428
[time] => 0.0027370452880859
)
[3] => Array
(
[query] => select * from match_time where match_id in (4359,3993,4290,4349,4363) order by id ASC
[start] => 1770959599.4281
[end] => 1770959599.4307
[time] => 0.0026390552520752
)
[4] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4359,3993,4290,4349,4363)
[start] => 1770959599.4309
[end] => 1770959599.4428
[time] => 0.011944055557251
)
[5] => Array
(
[query] => select * from matches where date <= '1770937200' AND match_id IN (select match_id from match_time where closed != '0' group by match_id) AND match_id NOT IN (select match_id from match_time where closed = '0' group by match_id) AND location_id = '9' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC LIMIT 0,5
[start] => 1770959599.4441
[end] => 1770959599.4521
[time] => 0.0080020427703857
)
[6] => Array
(
[query] => select * from match_time where match_id in (4330,3984,4243,4354,4151) order by id ASC
[start] => 1770959599.4521
[end] => 1770959599.4548
[time] => 0.0027010440826416
)
[7] => Array
(
[query] => select time from match_time where match_id = '4330'
[start] => 1770959599.4557
[end] => 1770959599.4576
[time] => 0.0018851757049561
)
[8] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN team_id = '43' THEN point
WHEN (team_id = '46' AND point = 'A') THEN 1
END)
,0) as home_team_score,
COALESCE(
SUM(
CASE
WHEN team_id = '46' THEN point
WHEN (team_id = '43' AND point = 'A') THEN 1
END )
,0) as visitor_team_score,
time
FROM point where match_id = '4330' group by time
[start] => 1770959599.4576
[end] => 1770959599.5037
[time] => 0.046072006225586
)
[9] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN (team_id = '43' AND point = 'I') THEN 1
END)
,0) as home_team_invasions,
COALESCE(
SUM(
CASE
WHEN (team_id = '46' AND point = 'I') THEN 1
END )
,0) as visitor_team_invasions
FROM point where match_id = '4330'
[start] => 1770959599.5037
[end] => 1770959599.5407
[time] => 0.037005186080933
)
[10] => Array
(
[query] => select time from match_time where match_id = '4243'
[start] => 1770959599.5442
[end] => 1770959599.5462
[time] => 0.0019950866699219
)
[11] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN team_id = '4' THEN point
WHEN (team_id = '25' AND point = 'A') THEN 1
END)
,0) as home_team_score,
COALESCE(
SUM(
CASE
WHEN team_id = '25' THEN point
WHEN (team_id = '4' AND point = 'A') THEN 1
END )
,0) as visitor_team_score,
time
FROM point where match_id = '4243' group by time
[start] => 1770959599.5462
[end] => 1770959599.5922
[time] => 0.045960187911987
)
[12] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN (team_id = '4' AND point = 'I') THEN 1
END)
,0) as home_team_invasions,
COALESCE(
SUM(
CASE
WHEN (team_id = '25' AND point = 'I') THEN 1
END )
,0) as visitor_team_invasions
FROM point where match_id = '4243'
[start] => 1770959599.5922
[end] => 1770959599.629
[time] => 0.036760091781616
)
[13] => Array
(
[query] => select time from match_time where match_id = '4354'
[start] => 1770959599.6308
[end] => 1770959599.6327
[time] => 0.0019569396972656
)
[14] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN team_id = '43' THEN point
WHEN (team_id = '13' AND point = 'A') THEN 1
END)
,0) as home_team_score,
COALESCE(
SUM(
CASE
WHEN team_id = '13' THEN point
WHEN (team_id = '43' AND point = 'A') THEN 1
END )
,0) as visitor_team_score,
time
FROM point where match_id = '4354' group by time
[start] => 1770959599.6327
[end] => 1770959599.6788
[time] => 0.04604697227478
)
[15] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN (team_id = '43' AND point = 'I') THEN 1
END)
,0) as home_team_invasions,
COALESCE(
SUM(
CASE
WHEN (team_id = '13' AND point = 'I') THEN 1
END )
,0) as visitor_team_invasions
FROM point where match_id = '4354'
[start] => 1770959599.6788
[end] => 1770959599.7158
[time] => 0.036916971206665
)
[16] => Array
(
[query] => select time from match_time where match_id = '4151'
[start] => 1770959599.7176
[end] => 1770959599.7195
[time] => 0.0019538402557373
)
[17] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN team_id = '6' THEN point
WHEN (team_id = '23' AND point = 'A') THEN 1
END)
,0) as home_team_score,
COALESCE(
SUM(
CASE
WHEN team_id = '23' THEN point
WHEN (team_id = '6' AND point = 'A') THEN 1
END )
,0) as visitor_team_score,
time
FROM point where match_id = '4151' group by time
[start] => 1770959599.7195
[end] => 1770959599.7654
[time] => 0.045815944671631
)
[18] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN (team_id = '6' AND point = 'I') THEN 1
END)
,0) as home_team_invasions,
COALESCE(
SUM(
CASE
WHEN (team_id = '23' AND point = 'I') THEN 1
END )
,0) as visitor_team_invasions
FROM point where match_id = '4151'
[start] => 1770959599.7654
[end] => 1770959599.8023
[time] => 0.036887884140015
)
[19] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4330,3984,4243,4354,4151)
[start] => 1770959599.8033
[end] => 1770959599.8154
[time] => 0.012083053588867
)
[20] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770959599.8169
[end] => 1770959599.8173
[time] => 0.00045895576477051
)
[21] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770959599.8178
[end] => 1770959599.8181
[time] => 0.0003209114074707
)
[22] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770959599.8191
[end] => 1770959599.8194
[time] => 0.00035595893859863
)
[23] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770959599.8198
[end] => 1770959599.82
[time] => 0.0002140998840332
)
[24] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770959599.8225
[end] => 1770959599.8228
[time] => 0.00035715103149414
)
[25] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770959599.8236
[end] => 1770959599.8239
[time] => 0.0003049373626709
)
)
