Total Queries: 29
Total Time: 0.46637463569641
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1770959598.8034
[end] => 1770959598.8037
[time] => 0.0003201961517334
)
[1] => Array
(
[query] => select * from location where location_id = '10'
[start] => 1770959598.8054
[end] => 1770959598.8057
[time] => 0.00033903121948242
)
[2] => Array
(
[query] => select * from matches where date >= '1770937200' AND location_id = '10' 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] => 1770959598.806
[end] => 1770959598.8088
[time] => 0.0028071403503418
)
[3] => Array
(
[query] => select * from match_time where match_id in (4193,4284,4289,4297,4220) order by id ASC
[start] => 1770959598.8088
[end] => 1770959598.8115
[time] => 0.0026659965515137
)
[4] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4193,4284,4289,4297,4220)
[start] => 1770959598.8116
[end] => 1770959598.8236
[time] => 0.012028932571411
)
[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 = '10' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC LIMIT 0,5
[start] => 1770959598.8249
[end] => 1770959598.8325
[time] => 0.0076160430908203
)
[6] => Array
(
[query] => select * from match_time where match_id in (4278,4272,4181,4171,4167) order by id ASC
[start] => 1770959598.8325
[end] => 1770959598.8352
[time] => 0.0026390552520752
)
[7] => Array
(
[query] => select time from match_time where match_id = '4278'
[start] => 1770959598.836
[end] => 1770959598.8379
[time] => 0.0018877983093262
)
[8] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN team_id = '47' THEN point
WHEN (team_id = '12' AND point = 'A') THEN 1
END)
,0) as home_team_score,
COALESCE(
SUM(
CASE
WHEN team_id = '12' THEN point
WHEN (team_id = '47' AND point = 'A') THEN 1
END )
,0) as visitor_team_score,
time
FROM point where match_id = '4278' group by time
[start] => 1770959598.8379
[end] => 1770959598.8838
[time] => 0.045876026153564
)
[9] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN (team_id = '47' AND point = 'I') THEN 1
END)
,0) as home_team_invasions,
COALESCE(
SUM(
CASE
WHEN (team_id = '12' AND point = 'I') THEN 1
END )
,0) as visitor_team_invasions
FROM point where match_id = '4278'
[start] => 1770959598.8839
[end] => 1770959598.9209
[time] => 0.037023782730103
)
[10] => Array
(
[query] => select time from match_time where match_id = '4272'
[start] => 1770959598.9229
[end] => 1770959598.9248
[time] => 0.0019221305847168
)
[11] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN team_id = '47' THEN point
WHEN (team_id = '56' AND point = 'A') THEN 1
END)
,0) as home_team_score,
COALESCE(
SUM(
CASE
WHEN team_id = '56' THEN point
WHEN (team_id = '47' AND point = 'A') THEN 1
END )
,0) as visitor_team_score,
time
FROM point where match_id = '4272' group by time
[start] => 1770959598.9248
[end] => 1770959598.971
[time] => 0.046140909194946
)
[12] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN (team_id = '47' AND point = 'I') THEN 1
END)
,0) as home_team_invasions,
COALESCE(
SUM(
CASE
WHEN (team_id = '56' AND point = 'I') THEN 1
END )
,0) as visitor_team_invasions
FROM point where match_id = '4272'
[start] => 1770959598.971
[end] => 1770959599.0079
[time] => 0.03688907623291
)
[13] => Array
(
[query] => select time from match_time where match_id = '4181'
[start] => 1770959599.0096
[end] => 1770959599.0116
[time] => 0.0019848346710205
)
[14] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN team_id = '14' THEN point
WHEN (team_id = '37' AND point = 'A') THEN 1
END)
,0) as home_team_score,
COALESCE(
SUM(
CASE
WHEN team_id = '37' THEN point
WHEN (team_id = '14' AND point = 'A') THEN 1
END )
,0) as visitor_team_score,
time
FROM point where match_id = '4181' group by time
[start] => 1770959599.0116
[end] => 1770959599.0573
[time] => 0.045680999755859
)
[15] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN (team_id = '14' AND point = 'I') THEN 1
END)
,0) as home_team_invasions,
COALESCE(
SUM(
CASE
WHEN (team_id = '37' AND point = 'I') THEN 1
END )
,0) as visitor_team_invasions
FROM point where match_id = '4181'
[start] => 1770959599.0573
[end] => 1770959599.0943
[time] => 0.036938905715942
)
[16] => Array
(
[query] => select time from match_time where match_id = '4171'
[start] => 1770959599.096
[end] => 1770959599.098
[time] => 0.0019230842590332
)
[17] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN team_id = '14' THEN point
WHEN (team_id = '39' AND point = 'A') THEN 1
END)
,0) as home_team_score,
COALESCE(
SUM(
CASE
WHEN team_id = '39' THEN point
WHEN (team_id = '14' AND point = 'A') THEN 1
END )
,0) as visitor_team_score,
time
FROM point where match_id = '4171' group by time
[start] => 1770959599.098
[end] => 1770959599.144
[time] => 0.04601001739502
)
[18] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN (team_id = '14' AND point = 'I') THEN 1
END)
,0) as home_team_invasions,
COALESCE(
SUM(
CASE
WHEN (team_id = '39' AND point = 'I') THEN 1
END )
,0) as visitor_team_invasions
FROM point where match_id = '4171'
[start] => 1770959599.144
[end] => 1770959599.1811
[time] => 0.037010192871094
)
[19] => Array
(
[query] => select time from match_time where match_id = '4167'
[start] => 1770959599.1829
[end] => 1770959599.1848
[time] => 0.00193190574646
)
[20] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN team_id = '14' THEN point
WHEN (team_id = '6' AND point = 'A') THEN 1
END)
,0) as home_team_score,
COALESCE(
SUM(
CASE
WHEN team_id = '6' THEN point
WHEN (team_id = '14' AND point = 'A') THEN 1
END )
,0) as visitor_team_score,
time
FROM point where match_id = '4167' group by time
[start] => 1770959599.1848
[end] => 1770959599.2306
[time] => 0.045821905136108
)
[21] => Array
(
[query] => SELECT
COALESCE(
SUM(
CASE
WHEN (team_id = '14' AND point = 'I') THEN 1
END)
,0) as home_team_invasions,
COALESCE(
SUM(
CASE
WHEN (team_id = '6' AND point = 'I') THEN 1
END )
,0) as visitor_team_invasions
FROM point where match_id = '4167'
[start] => 1770959599.2307
[end] => 1770959599.2676
[time] => 0.036931991577148
)
[22] => Array
(
[query] => SELECT * FROM match_data where match_id IN (4278,4272,4181,4171,4167)
[start] => 1770959599.2686
[end] => 1770959599.2807
[time] => 0.012102842330933
)
[23] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770959599.2822
[end] => 1770959599.2826
[time] => 0.00042104721069336
)
[24] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770959599.283
[end] => 1770959599.2833
[time] => 0.00022196769714355
)
[25] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770959599.2843
[end] => 1770959599.2847
[time] => 0.00040602684020996
)
[26] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770959599.2851
[end] => 1770959599.2853
[time] => 0.00026679039001465
)
[27] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1770959599.2878
[end] => 1770959599.2882
[time] => 0.00037002563476562
)
[28] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1770959599.2889
[end] => 1770959599.2891
[time] => 0.00019598007202148
)
)
