Di Noia Edoardo
Statistiche
14
Partite Arbitrate
Partite Arbitrate
Total Queries: 11
Total Time: 0.032638788223267
Array
(
[0] => Array
(
[query] => select * from setting where property = 'datetime_timezone'
[start] => 1781155182.5097
[end] => 1781155182.51
[time] => 0.0002439022064209
)
[1] => Array
(
[query] => select * from referee where referee_id = '40'
[start] => 1781155182.5117
[end] => 1781155182.512
[time] => 0.00029897689819336
)
[2] => Array
(
[query] => select * from matches where (first_referee_id = '40' OR second_referee_id = '40' OR third_referee_id = '40') 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) ORDER BY
case when description in('', '') then 'ZZZZZZZZZZZZZZZZZZZZZZZZZZZ' else description end,
round_id+0,
date+0,
match_id
ASC
[start] => 1781155182.5124
[end] => 1781155182.5211
[time] => 0.0086250305175781
)
[3] => Array
(
[query] => select * from match_time where match_id in (3914,3865,3879,3867,3878,3979,3721,3799,3475,3472,3821,3585,3590,3589) order by id ASC
[start] => 1781155182.5212
[end] => 1781155182.5244
[time] => 0.0032470226287842
)
[4] => Array
(
[query] => select * from matches where (first_referee_id = '40' OR second_referee_id = '40' OR third_referee_id = '40') AND date >= '1756677600' AND date <= '1788213599' ORDER BY
case when date in('', '0') then 9999999999999999999999 else date end DESC,
round_id+0
DESC
[start] => 1781155182.5248
[end] => 1781155182.5277
[time] => 0.0028769969940186
)
[5] => Array
(
[query] => select * from match_time where match_id in (3979) order by id ASC
[start] => 1781155182.5277
[end] => 1781155182.5307
[time] => 0.0030100345611572
)
[6] => Array
(
[query] => SELECT * FROM match_data where match_id IN (3979)
[start] => 1781155182.533
[end] => 1781155182.5459
[time] => 0.012933969497681
)
[7] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781155182.5466
[end] => 1781155182.5471
[time] => 0.00047492980957031
)
[8] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781155182.5475
[end] => 1781155182.5478
[time] => 0.00027990341186523
)
[9] => Array
(
[query] => select * from championship ORDER BY YEAR(FROM_UNIXTIME(date)) DESC, name ASC
[start] => 1781155182.5502
[end] => 1781155182.5506
[time] => 0.00038003921508789
)
[10] => Array
(
[query] => select * from match_group where deleted = '0' ORDER BY from_unixtime(date, '%Y') DESC,name,match_group_id ASC
[start] => 1781155182.5514
[end] => 1781155182.5517
[time] => 0.00026798248291016
)
)