基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-04-13 10:40:21 HTTP/2.0 GET : https://goal365.com.hk/home/live/detail.html?id=5642
- 运行时间 : 0.300147s [ 吞吐率：3.33req/s ] 内存消耗：5,389.13kb 文件加载：199
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=f7dd906f193cdd349a5def38bdacc870
- CONNECT:[ UseTime:0.000064s ] mysql:host=127.0.0.1;port=3306;dbname=goal365;charset=utf8mb4
- SHOW FULL COLUMNS FROM `dlm_user` [ RunTime:0.000503s ]
- SELECT `a`.*,b.name as grade_name,b.thumb_url as grade_thumb,`b`.`grade_key` FROM `dlm_user` `a` LEFT JOIN `dlm_user_grade` `b` ON `b`.`gid`=`a`.`grade` WHERE `a`.`status` = '1' AND `a`.`token` = 'kND6zmrCY8AsKDTMokzLm2' LIMIT 1 [ RunTime:0.000446s ]
- SHOW FULL COLUMNS FROM `dlm_site` [ RunTime:0.000421s ]
- SELECT * FROM `dlm_site` WHERE `site_url` LIKE '%https://goal365.com.hk%' ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000210s ]
- SELECT * FROM `dlm_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000169s ]
- SHOW FULL COLUMNS FROM `dlm_nav` [ RunTime:0.000351s ]
- SELECT `id`,name as name,sub as sub,`thumb_url`,parent_id as parentid,`linkurl`,title as title,keywords as keywords,description as description,name as cn FROM `dlm_nav` WHERE `status` = 1 AND `linkurl` LIKE '%live/%' ORDER BY `status` DESC LIMIT 1 [ RunTime:0.000171s ]
- SELECT `id`,name as name,sub as sub,`thumb_url`,parent_id as parentid,`linkurl`,title as title,keywords as keywords,description as description,name as cn FROM `dlm_nav` WHERE `status` = 1 AND `linkurl` LIKE '%Live/detail.html%' ORDER BY `status` DESC LIMIT 1 [ RunTime:0.000138s ]
- SELECT `id`,name as name,sub as sub,`thumb_url`,parent_id as parentid,`linkurl`,title as title,keywords as keywords,description as description,name as cn FROM `dlm_nav` WHERE `linkurl` LIKE '%Live/detail%' ORDER BY `status` DESC LIMIT 1 [ RunTime:0.000132s ]
- SELECT * FROM `dlm_nav` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000208s ]
- SHOW FULL COLUMNS FROM `dlm_matchs` [ RunTime:0.000444s ]
- SELECT `a`.*,b.name as home_team_name,b.thumb_url as home_team_flag,c.name as visiting_team_name,c.thumb_url as visiting_team_flag,d.thumb as cat_logo,d.catname as catname FROM `dlm_matchs` `a` INNER JOIN `dlm_matchs_teams` `b` ON `b`.`tid`=`a`.`home_team` INNER JOIN `dlm_matchs_teams` `c` ON `c`.`tid`=`a`.`visiting_team` LEFT JOIN `dlm_cat` `d` ON `d`.`catid`=`a`.`catid` WHERE ( `a`.`mid` = '5642' AND `a`.`delete_time` = '0' ) AND `a`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000379s ]
- SHOW FULL COLUMNS FROM `dlm_cat` [ RunTime:0.000544s ]
- SELECT * FROM `dlm_cat` WHERE ( `delete_time` = 0 ) AND `dlm_cat`.`delete_time` = '0' ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.008315s ]
- SHOW FULL COLUMNS FROM `dlm_matchs_views` [ RunTime:0.000472s ]
- SELECT * FROM `dlm_matchs_views` WHERE `ip` = '216.73.216.122' AND `user_id` = 0 AND `match_id` = 5642 AND `create_time` > 1776047421 LIMIT 1 [ RunTime:0.000283s ]
- INSERT INTO `dlm_matchs_views` SET `ip` = '216.73.216.122' , `user_id` = 0 , `match_id` = 5642 , `create_time` = 1776048021 , `update_time` = 1776048021 [ RunTime:0.000193s ]
- SELECT COUNT(*) AS think_count FROM `dlm_matchs_views` WHERE `match_id` = 5642 AND `create_time` > 1776047421 [ RunTime:0.000279s ]
- UPDATE `dlm_matchs` SET `watchs_views` = 1 WHERE ( `mid` = 5642 ) AND `dlm_matchs`.`delete_time` = '0' [ RunTime:0.004855s ]
- SHOW FULL COLUMNS FROM `dlm_matchs_tasks` [ RunTime:0.000498s ]
- SELECT COUNT(*) AS think_count FROM `dlm_matchs_tasks` WHERE `match_id` = 5642 AND `match_k` = 'x7lm7phjoyk8m2w' [ RunTime:0.000257s ]
- SELECT * FROM `dlm_matchs` WHERE ( `mid` = 5642 ) AND `dlm_matchs`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000455s ]
- SHOW FULL COLUMNS FROM `dlm_matchs_lineup` [ RunTime:0.000460s ]
- SHOW FULL COLUMNS FROM `dlm_matchs_player` [ RunTime:0.000478s ]
- SHOW FULL COLUMNS FROM `dlm_matchs_teams` [ RunTime:0.000500s ]
- SELECT * FROM `dlm_matchs_lineup` WHERE `match_id` = 5642 LIMIT 1 [ RunTime:0.015057s ]
- SELECT * FROM `dlm_matchs_lineup` WHERE `match_id` = 5642 LIMIT 1 [ RunTime:0.010534s ]
- INSERT INTO `dlm_matchs_lineup` SET `match_id` = 5642 , `match_k` = 'x7lm7phjoyk8m2w' , `confirmed` = 1 , `home_formation` = '4-2-3-1' , `away_formation` = '3-4-2-1' , `home_coach_k` = '4zp5rzgh76xq82w' , `away_coach_k` = 'gx7lm7phoxkm2wd' , `injury` = '{\"home\":[{\"id\":\"318q66hk2d0qo9j\",\"name\":\"Ben Wilmot\",\"position\":\"D\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/02b9101776a0b991beaf1c5c053978cf.png\",\"type\":1,\"injury_id\":\"kjw2r09hlvrz84o\",\"reason\":\"Calf Injury\",\"start_time\":1772899200,\"end_time\":0,\"missed_matches\":6},{\"id\":\"l5ergphpzynr8k0\",\"name\":\"Viktor Johansson\",\"position\":\"G\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/505cba4c3740a55c500e9af65373e4ba.png\",\"type\":1,\"injury_id\":\"9d23xmvkhxqg8ny\",\"reason\":\"Shoulder injury\",\"start_time\":1767024000,\"end_time\":0,\"missed_matches\":21},{\"id\":\"pxwrxlh97ey5ryk\",\"name\":\"Róbert Boženík\",\"position\":\"F\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/4269267a34b289848c35f0d59f57339d.png\",\"type\":1,\"injury_id\":\"9d23xmvkhxqg8ny\",\"reason\":\"Shoulder injury\",\"start_time\":1767283200,\"end_time\":0,\"missed_matches\":19},{\"id\":\"318q66hvgo44qo9\",\"name\":\"Maksym Taloverov\",\"position\":\"D\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/71c922d62e624075493ce428ed38c3f0.png\",\"type\":1,\"injury_id\":\"4zp5rzghj2q82w1\",\"reason\":\"Ankle injury\",\"start_time\":1773504000,\"end_time\":0,\"missed_matches\":4},{\"id\":\"l5ergphvlkllr8k\",\"name\":\"Tomas Rigo\",\"position\":\"M\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/0deb16ca878c45a5f5fe9dfca2880e20.png\",\"type\":1,\"injury_id\":\"xe4wyrn4h5q86pv\",\"reason\":\"Wound\",\"start_time\":1775491200,\"end_time\":0,\"missed_matches\":1},{\"id\":\"vjxm8gh8gx58r6o\",\"name\":\"Junior Tchamadeu\",\"position\":\"D\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/11060bdf78f2d5df5ac29c42001cadef.png\",\"type\":1,\"injury_id\":\"xkn54qllhjqvy9d\",\"reason\":\"Hamstring Injury\",\"start_time\":1774022400,\"end_time\":0,\"missed_matches\":4},{\"id\":\"4jwq2ghxjp25m0v\",\"name\":\"Ato Ampah\",\"position\":\"F\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/928aba748f15a96554f5af1f9dcaf374.png\",\"type\":1,\"injury_id\":\"xkn54qllhjqvy9d\",\"reason\":\"Hamstring Injury\",\"start_time\":1770652800,\"end_time\":0,\"missed_matches\":12},{\"id\":\"l5ergphnl1zzr8k\",\"name\":\"ato ampah\",\"position\":\"M\",\"logo\":\"\",\"type\":1,\"injury_id\":\"xe4wyrn4h5q86pv\",\"reason\":\"Wound\",\"start_time\":1770652800,\"end_time\":0,\"missed_matches\":4}],\"away\":[{\"id\":\"x7lm7ph0kx7m2wd\",\"name\":\"Sondre Tronstad\",\"position\":\"M\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/7a9d1d772a918bac35c6dbe7d5580099.png\",\"type\":1,\"injury_id\":\"9dn1m1ghp4moepl\",\"reason\":\"Knee injury\",\"start_time\":1771948800,\"end_time\":0,\"missed_matches\":9},{\"id\":\"vjxm8gh8jwpr6od\",\"name\":\"Ryan Hedges\",\"position\":\"F\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/2f25fc1ae3753d4ce8382efae1b4b370.png\",\"type\":1,\"injury_id\":\"4zp5rzghj2q82w1\",\"reason\":\"Ankle injury\",\"start_time\":1767283200,\"end_time\":0,\"missed_matches\":19},{\"id\":\"y0or5jheg6g5qwz\",\"name\":\"Andri Guðjohnsen\",\"position\":\"F\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/f7bc8418d319990f89b96dbd26641d9c.png\",\"type\":1,\"injury_id\":\"4zp5rzghj2q82w1\",\"reason\":\"Ankle injury\",\"start_time\":1772899200,\"end_time\":0,\"missed_matches\":6},{\"id\":\"23xmvkhdxnk0qg8\",\"name\":\"Augustus Kargbo\",\"position\":\"F\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/6caf8acb12013c6e0376c59faf06842c.png\",\"type\":1,\"injury_id\":\"xkn54qllhjqvy9d\",\"reason\":\"Hamstring Injury\",\"start_time\":1771948800,\"end_time\":0,\"missed_matches\":9},{\"id\":\"pxwrxlh97vderyk\",\"name\":\"Lewis Miller\",\"position\":\"D\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/da0802cb6bc520ea6df515d2f700b1e4.png\",\"type\":1,\"injury_id\":\"28y39mp1hzmojxg\",\"reason\":\"Achilles tendon problems\",\"start_time\":1771084800,\"end_time\":0,\"missed_matches\":10},{\"id\":\"y0or5jhez612qwz\",\"name\":\"Hayden Carter\",\"position\":\"D\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/6fcf8f28fe7058bf490c9d04000fae7b.png\",\"type\":1,\"injury_id\":\"xe4wyrn4h5q86pv\",\"reason\":\"Wound\",\"start_time\":1773504000,\"end_time\":0,\"missed_matches\":4},{\"id\":\"ednm9whzo20yryo\",\"name\":\"Jake Garrett\",\"position\":\"M\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/279fc16212f7b61a6bad364caaa5c555.png\",\"type\":1,\"injury_id\":\"kn54qllh40qvy9d\",\"reason\":\"Fitness\",\"start_time\":1772812800,\"end_time\":0,\"missed_matches\":7},{\"id\":\"318q66h4jkg0qo9\",\"name\":\"Axel Henriksson\",\"position\":\"M\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/4f9b8924e5d40f7b95df1a2a52366a92.png\",\"type\":2,\"injury_id\":\"9dn1m1gh4xmoepl\",\"reason\":\"Rest\",\"start_time\":0,\"end_time\":0,\"missed_matches\":0},{\"id\":\"3glrw7hzyozyqdy\",\"name\":\"Matthew Litherland\",\"position\":\"M\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/b1082f2fbda0574689f909aac5a7a2fc.png\",\"type\":2,\"injury_id\":\"9dn1m1gh4xmoepl\",\"reason\":\"Rest\",\"start_time\":0,\"end_time\":0,\"missed_matches\":0}]}' , `lineup` = '{\"home\":[{\"id\":\"318q66hvk582qo9\",\"first\":1,\"captain\":0,\"name\":\"Gavin Bazunu\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/dfba91af83be14b38577819ffe0e901d.png\",\"shirt_number\":31,\"position\":\"G\",\"x\":50,\"y\":12,\"rating\":\"6.94\"},{\"id\":\"ednm9whzwynlryo\",\"first\":1,\"captain\":0,\"name\":\"Bosun Lawal\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/d9033e31649970ccc889558d76640362.png\",\"shirt_number\":18,\"position\":\"D\",\"x\":13,\"y\":32,\"rating\":\"6.35\"},{\"id\":\"4jwq2ghx6l3vm0v\",\"first\":1,\"captain\":0,\"name\":\"Ashley Phillips\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/5e524bb6a135f99d1ae898688a7a597f.png\",\"shirt_number\":26,\"position\":\"D\",\"x\":36,\"y\":32,\"rating\":\"6.09\",\"incidents\":[{\"type\":3,\"time\":\"47\",\"minute\":47,\"addtime\":0,\"belong\":1,\"home_score\":0,\"away_score\":1,\"player\":{\"id\":\"4jwq2ghx6l3vm0v\",\"name\":\"Ashley Phillips\"}},{\"type\":15,\"time\":\"87\",\"minute\":87,\"addtime\":0,\"belong\":1,\"home_score\":1,\"away_score\":1,\"player\":{\"id\":\"4jwq2ghx6l3vm0v\",\"name\":\"Ashley Phillips\"}}]},{\"id\":\"l7oqdeh6lnzr510\",\"first\":1,\"captain\":1,\"name\":\"Ben Gibson\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/33630164001279b7fa7851fef0f5f50b.png\",\"shirt_number\":23,\"position\":\"D\",\"x\":64,\"y\":32,\"rating\":\"6.77\",\"incidents\":[{\"type\":9,\"time\":\"24\",\"minute\":24,\"addtime\":0,\"belong\":1,\"home_score\":0,\"away_score\":1,\"in_player\":{\"id\":\"k82rekhv64grepz\",\"name\":\"Aaron Cresswell\"},\"out_player\":{\"id\":\"l7oqdeh6lnzr510\",\"name\":\"Ben Gibson\"}}]},{\"id\":\"2y8m4zhg52xjql0\",\"first\":1,\"captain\":0,\"name\":\"Eric Junior Bocat\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/0b77db1a27eb6c2edb43831fec223221.png\",\"shirt_number\":17,\"position\":\"D\",\"x\":87,\"y\":32,\"rating\":\"6.24\"},{\"id\":\"y0or5jh4v0nqwzv\",\"first\":1,\"captain\":0,\"name\":\"Ben Pearson\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/20557859b254b0fb0734efad961827c6.png\",\"shirt_number\":4,\"position\":\"M\",\"x\":36,\"y\":50,\"rating\":\"6.42\",\"incidents\":[{\"type\":3,\"time\":\"88\",\"minute\":88,\"addtime\":0,\"belong\":1,\"home_score\":1,\"away_score\":1,\"player\":{\"id\":\"y0or5jh4v0nqwzv\",\"name\":\"Ben Pearson\"}}]},{\"id\":\"pxwrxlh162yryk0\",\"first\":1,\"captain\":0,\"name\":\"Lewis Baker\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/1475ec75b5bf22c9f0602d30c8230570.png\",\"shirt_number\":8,\"position\":\"M\",\"x\":64,\"y\":50,\"rating\":\"6.4\",\"incidents\":[{\"type\":3,\"time\":\"88\",\"minute\":88,\"addtime\":0,\"belong\":1,\"home_score\":1,\"away_score\":1,\"player\":{\"id\":\"pxwrxlh162yryk0\",\"name\":\"Lewis Baker\"}}]},{\"id\":\"6ypq3nhw0xg3md7\",\"first\":1,\"captain\":0,\"name\":\"Jesurun Rak-Sakyi\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/502a55010a7be96229533caee83697c0.png\",\"shirt_number\":21,\"position\":\"M\",\"x\":22,\"y\":70,\"rating\":\"7.5\",\"incidents\":[{\"type\":1,\"time\":\"56\",\"minute\":56,\"addtime\":0,\"belong\":1,\"home_score\":1,\"away_score\":1,\"player\":{\"id\":\"6ypq3nhw0xg3md7\",\"name\":\"Jesurun Rak-Sakyi\"},\"assist1\":{\"id\":\"8yomo4h25pkxq0j\",\"name\":\"Million·Manhoef\"}},{\"type\":3,\"time\":\"62\",\"minute\":62,\"addtime\":0,\"belong\":1,\"home_score\":1,\"away_score\":1,\"player\":{\"id\":\"6ypq3nhw0xg3md7\",\"name\":\"Jesurun Rak-Sakyi\"}},{\"type\":9,\"time\":\"86\",\"minute\":86,\"addtime\":0,\"belong\":1,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"pxwrxlhj01zvryk\",\"name\":\"Bae Jun-ho\"},\"out_player\":{\"id\":\"6ypq3nhw0xg3md7\",\"name\":\"Jesurun Rak-Sakyi\"}}]},{\"id\":\"8yomo4h25pkxq0j\",\"first\":1,\"captain\":0,\"name\":\"Million·Manhoef\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/cc5c6fb6afc24218cc1268e7b586085f.png\",\"shirt_number\":42,\"position\":\"M\",\"x\":50,\"y\":70,\"rating\":\"7.19\",\"incidents\":[{\"type\":1,\"time\":\"56\",\"minute\":56,\"addtime\":0,\"belong\":1,\"home_score\":1,\"away_score\":1,\"player\":{\"id\":\"6ypq3nhw0xg3md7\",\"name\":\"Jesurun Rak-Sakyi\"},\"assist1\":{\"id\":\"8yomo4h25pkxq0j\",\"name\":\"Million·Manhoef\"}}]},{\"id\":\"jw2r09hxwnzdrz8\",\"first\":1,\"captain\":0,\"name\":\"Sorba Thomas\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/ef280490fb6422dee0c0c37ec913688f.png\",\"shirt_number\":7,\"position\":\"M\",\"x\":78,\"y\":70,\"rating\":\"6.07\"},{\"id\":\"l5ergphvx7lr8k0\",\"first\":1,\"captain\":0,\"name\":\"Sam Gallagher\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/722e6700b74f4cf69cebb827115c001c.png\",\"shirt_number\":20,\"position\":\"F\",\"x\":50,\"y\":85,\"rating\":\"6.81\",\"incidents\":[{\"type\":9,\"time\":\"72\",\"minute\":72,\"addtime\":0,\"belong\":1,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"8yomo4hvz0e5q0j\",\"name\":\"Lamine Cissé\"},\"out_player\":{\"id\":\"l5ergphvx7lr8k0\",\"name\":\"Sam Gallagher\"}}]},{\"id\":\"pxwrxlhj01zvryk\",\"first\":0,\"captain\":0,\"name\":\"Bae Jun-ho\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/7a32d5b27af15dabf418abb28840e66e.png\",\"shirt_number\":10,\"position\":\"M\",\"x\":0,\"y\":0,\"rating\":\"6.23\",\"incidents\":[{\"type\":9,\"time\":\"86\",\"minute\":86,\"addtime\":0,\"belong\":1,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"pxwrxlhj01zvryk\",\"name\":\"Bae Jun-ho\"},\"out_player\":{\"id\":\"6ypq3nhw0xg3md7\",\"name\":\"Jesurun Rak-Sakyi\"}}]},{\"id\":\"8yomo4hvz0e5q0j\",\"first\":0,\"captain\":0,\"name\":\"Lamine Cissé\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/fb82138341406bcccafd198190d8ac97.png\",\"shirt_number\":29,\"position\":\"F\",\"x\":0,\"y\":0,\"rating\":\"6.48\",\"incidents\":[{\"type\":9,\"time\":\"72\",\"minute\":72,\"addtime\":0,\"belong\":1,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"8yomo4hvz0e5q0j\",\"name\":\"Lamine Cissé\"},\"out_player\":{\"id\":\"l5ergphvx7lr8k0\",\"name\":\"Sam Gallagher\"}}]},{\"id\":\"k82rekhv64grepz\",\"first\":0,\"captain\":0,\"name\":\"Aaron Cresswell\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/ab0c9df3c647d1e7a8acd3a598a1603b.png\",\"shirt_number\":3,\"position\":\"D\",\"x\":0,\"y\":0,\"rating\":\"6.64\",\"incidents\":[{\"type\":9,\"time\":\"24\",\"minute\":24,\"addtime\":0,\"belong\":1,\"home_score\":0,\"away_score\":1,\"in_player\":{\"id\":\"k82rekhv64grepz\",\"name\":\"Aaron Cresswell\"},\"out_player\":{\"id\":\"l7oqdeh6lnzr510\",\"name\":\"Ben Gibson\"}}]},{\"id\":\"dj2ryohkl8oq1zp\",\"first\":0,\"captain\":0,\"name\":\"Steven N\'Zonzi\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/ea8c0f986cf3f9578d48e300d5168300.png\",\"shirt_number\":15,\"position\":\"M\",\"x\":0,\"y\":0,\"rating\":\"0.0\"},{\"id\":\"4jwq2ghvw66om0v\",\"first\":0,\"captain\":0,\"name\":\"Tatsuki Seko\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/6ef7cf757d49a927a16fbf13ba8123ad.png\",\"shirt_number\":12,\"position\":\"M\",\"x\":0,\"y\":0,\"rating\":\"0.0\"},{\"id\":\"3glrw7hyzvzwqdy\",\"first\":0,\"captain\":0,\"name\":\"Tommy Simkim\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/2f2f87b14272e6b54bccb65f5feaf985.png\",\"shirt_number\":25,\"position\":\"G\",\"x\":0,\"y\":0,\"rating\":\"0.0\"},{\"id\":\"8yomo4hvyyzgq0j\",\"first\":0,\"captain\":0,\"name\":\"Milan Smit\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/ffa84e190998bcf5ff0a432563bbabbb.png\",\"shirt_number\":49,\"position\":\"F\",\"x\":0,\"y\":0,\"rating\":\"0.0\"},{\"id\":\"vjxm8gh8zvw6r6o\",\"first\":0,\"captain\":0,\"name\":\"Sydney Agina\",\"logo\":\"\",\"shirt_number\":50,\"position\":\"M\",\"x\":0,\"y\":0,\"rating\":\"0.0\"},{\"id\":\"pxwrxlhz8gd4ryk\",\"first\":0,\"captain\":0,\"name\":\"G. Gartside-Kelly\",\"logo\":\"\",\"shirt_number\":59,\"position\":\"M\",\"x\":0,\"y\":0,\"rating\":\"0.0\"}],\"away\":[{\"id\":\"4jwq2gh1vzgm0ve\",\"first\":1,\"captain\":0,\"name\":\"Balazs Toth\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/e6080f0a1ce924b3ac54105ebd659d68.png\",\"shirt_number\":22,\"position\":\"G\",\"x\":50,\"y\":12,\"rating\":\"5.96\"},{\"id\":\"4jwq2gh7klyzm0v\",\"first\":1,\"captain\":0,\"name\":\"Tom Atcheson\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/8b35a824bddc3766323544e3fd45b6a1.png\",\"shirt_number\":38,\"position\":\"D\",\"x\":24,\"y\":32,\"rating\":\"6.41\"},{\"id\":\"x7lm7phoek93m2w\",\"first\":1,\"captain\":0,\"name\":\"Sean McLoughlin\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/668c2b656e49cf12c3c159755ac86b04.png\",\"shirt_number\":15,\"position\":\"D\",\"x\":50,\"y\":32,\"rating\":\"6.77\"},{\"id\":\"965mkyhenppdr1g\",\"first\":1,\"captain\":0,\"name\":\"Eiran Joe Cashin\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/d551014ae437501a772197ef97eae661.png\",\"shirt_number\":20,\"position\":\"D\",\"x\":76,\"y\":32,\"rating\":\"6.49\"},{\"id\":\"vjxm8ghj05w5r6o\",\"first\":1,\"captain\":0,\"name\":\"Ryan Alebiosu\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/efce443f0eb52119802c6b6dfe3b685d.png\",\"shirt_number\":2,\"position\":\"M\",\"x\":13,\"y\":62,\"rating\":\"6.26\",\"incidents\":[{\"type\":1,\"time\":\"21\",\"minute\":21,\"addtime\":0,\"belong\":2,\"home_score\":0,\"away_score\":1,\"player\":{\"id\":\"965mkyh442zr1ge\",\"name\":\"Adam Forshaw\"},\"assist1\":{\"id\":\"vjxm8ghj05w5r6o\",\"name\":\"Ryan Alebiosu\"}},{\"type\":3,\"time\":\"45\",\"minute\":45,\"addtime\":0,\"belong\":2,\"home_score\":0,\"away_score\":1,\"player\":{\"id\":\"vjxm8ghj05w5r6o\",\"name\":\"Ryan Alebiosu\"}}]},{\"id\":\"965mkyh442zr1ge\",\"first\":1,\"captain\":0,\"name\":\"Adam Forshaw\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/e4fb14ca74421a41b1c36cd457896650.png\",\"shirt_number\":28,\"position\":\"M\",\"x\":36,\"y\":62,\"rating\":\"7.88\",\"incidents\":[{\"type\":1,\"time\":\"21\",\"minute\":21,\"addtime\":0,\"belong\":2,\"home_score\":0,\"away_score\":1,\"player\":{\"id\":\"965mkyh442zr1ge\",\"name\":\"Adam Forshaw\"},\"assist1\":{\"id\":\"vjxm8ghj05w5r6o\",\"name\":\"Ryan Alebiosu\"}},{\"type\":9,\"time\":\"77\",\"minute\":77,\"addtime\":0,\"belong\":2,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"pxwrxlhjg8njryk\",\"name\":\"Kristi Montgomery\"},\"out_player\":{\"id\":\"965mkyh442zr1ge\",\"name\":\"Adam Forshaw\"}}]},{\"id\":\"4jwq2ghx9yeom0v\",\"first\":1,\"captain\":0,\"name\":\"Moussa·Baradji\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/8199788c137f0d537b32e1b5ed77733c.png\",\"shirt_number\":24,\"position\":\"M\",\"x\":64,\"y\":62,\"rating\":\"6.38\",\"incidents\":[{\"type\":3,\"time\":\"31\",\"minute\":31,\"addtime\":0,\"belong\":2,\"home_score\":0,\"away_score\":1,\"player\":{\"id\":\"4jwq2ghx9yeom0v\",\"name\":\"Moussa·Baradji\"}},{\"type\":9,\"time\":\"63\",\"minute\":63,\"addtime\":0,\"belong\":2,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"23xmvkhkxwe4qg8\",\"name\":\"Taylor·Gardner Hickman\"},\"out_player\":{\"id\":\"4jwq2ghx9yeom0v\",\"name\":\"Moussa·Baradji\"}}]},{\"id\":\"x7lm7ph0ev6m2wd\",\"first\":1,\"captain\":0,\"name\":\"Yuri Ribeiro\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/5cd2e2730b9db5ba685c923e693d7126.png\",\"shirt_number\":4,\"position\":\"M\",\"x\":87,\"y\":62,\"rating\":\"6.22\",\"incidents\":[{\"type\":9,\"time\":\"90\",\"minute\":90,\"addtime\":0,\"belong\":2,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"23xmvkho43kqg8n\",\"name\":\"Nathan Redmond\"},\"out_player\":{\"id\":\"x7lm7ph0ev6m2wd\",\"name\":\"Yuri Ribeiro\"}}]},{\"id\":\"965mkyh3w114r1g\",\"first\":1,\"captain\":0,\"name\":\"Ryoya Morishita\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/66961869f5b85d6eabcef122e17a5216.png\",\"shirt_number\":25,\"position\":\"M\",\"x\":25,\"y\":80,\"rating\":\"6.25\",\"incidents\":[{\"type\":9,\"time\":\"89\",\"minute\":89,\"addtime\":0,\"belong\":2,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"dj2ryohjn9weq1z\",\"name\":\"Dion De Neve\"},\"out_player\":{\"id\":\"965mkyh3w114r1g\",\"name\":\"Ryoya Morishita\"}}]},{\"id\":\"zp5rzgh2vx3q82w\",\"first\":1,\"captain\":1,\"name\":\"Todd Cantwell\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/235503b236736af726bfb2b9823cbe81.png\",\"shirt_number\":10,\"position\":\"M\",\"x\":75,\"y\":80,\"rating\":\"6.77\",\"incidents\":[{\"type\":9,\"time\":\"77\",\"minute\":77,\"addtime\":0,\"belong\":2,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"k82rekh9d7jdrep\",\"name\":\"Mathias Jørgensen\"},\"out_player\":{\"id\":\"zp5rzgh2vx3q82w\",\"name\":\"Todd Cantwell\"}}]},{\"id\":\"zp5rzghz0d75q82\",\"first\":1,\"captain\":0,\"name\":\"Yuki Ohashi\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/427708aa22baca3a208ead39b840a445.png\",\"shirt_number\":23,\"position\":\"F\",\"x\":50,\"y\":90,\"rating\":\"6.65\",\"incidents\":[{\"type\":3,\"time\":\"33\",\"minute\":33,\"addtime\":0,\"belong\":2,\"home_score\":0,\"away_score\":1,\"player\":{\"id\":\"zp5rzghz0d75q82\",\"name\":\"Yuki Ohashi\"}}]},{\"id\":\"23xmvkho43kqg8n\",\"first\":0,\"captain\":0,\"name\":\"Nathan Redmond\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/71cd82ff8bfe73dc535483fa8cd4e1bc.png\",\"shirt_number\":27,\"position\":\"M\",\"x\":0,\"y\":0,\"rating\":\"5.94\",\"incidents\":[{\"type\":9,\"time\":\"90\",\"minute\":90,\"addtime\":0,\"belong\":2,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"23xmvkho43kqg8n\",\"name\":\"Nathan Redmond\"},\"out_player\":{\"id\":\"x7lm7ph0ev6m2wd\",\"name\":\"Yuri Ribeiro\"}}]},{\"id\":\"pxwrxlhz6weryk0\",\"first\":0,\"captain\":0,\"name\":\"Harry Pickering\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/3cd874818e52d87d1a3da6b6de4d8d96.png\",\"shirt_number\":3,\"position\":\"D\",\"x\":0,\"y\":0,\"rating\":\"0.0\"},{\"id\":\"23xmvkhgjg8qg8n\",\"first\":0,\"captain\":0,\"name\":\"Aynsley Pears\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/cdf543bf9debb15aacdd836f1b93c8f0.png\",\"shirt_number\":1,\"position\":\"G\",\"x\":0,\"y\":0,\"rating\":\"0.0\"},{\"id\":\"4wyrn4h4xe52q86\",\"first\":0,\"captain\":0,\"name\":\"Connor O\'Riordan\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/127621bd1ad3c143729dac9963910e4e.png\",\"shirt_number\":26,\"position\":\"D\",\"x\":0,\"y\":0,\"rating\":\"0.0\"},{\"id\":\"pxwrxlhjg8njryk\",\"first\":0,\"captain\":0,\"name\":\"Kristi Montgomery\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/63012f7050e9974ce7952a0d736c75f0.png\",\"shirt_number\":31,\"position\":\"M\",\"x\":0,\"y\":0,\"rating\":\"6.34\",\"incidents\":[{\"type\":9,\"time\":\"77\",\"minute\":77,\"addtime\":0,\"belong\":2,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"pxwrxlhjg8njryk\",\"name\":\"Kristi Montgomery\"},\"out_player\":{\"id\":\"965mkyh442zr1ge\",\"name\":\"Adam Forshaw\"}}]},{\"id\":\"k82rekh9d7jdrep\",\"first\":0,\"captain\":0,\"name\":\"Mathias Jørgensen\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/d7caf119dc13f2dd940f327a76c7ab46.png\",\"shirt_number\":29,\"position\":\"F\",\"x\":0,\"y\":0,\"rating\":\"6.57\",\"incidents\":[{\"type\":9,\"time\":\"77\",\"minute\":77,\"addtime\":0,\"belong\":2,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"k82rekh9d7jdrep\",\"name\":\"Mathias Jørgensen\"},\"out_player\":{\"id\":\"zp5rzgh2vx3q82w\",\"name\":\"Todd Cantwell\"}}]},{\"id\":\"23xmvkhkxwe4qg8\",\"first\":0,\"captain\":0,\"name\":\"Taylor·Gardner Hickman\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/28ef250b5f652e449ce1f0fdb8fc3660.png\",\"shirt_number\":5,\"position\":\"M\",\"x\":0,\"y\":0,\"rating\":\"6.07\",\"incidents\":[{\"type\":9,\"time\":\"63\",\"minute\":63,\"addtime\":0,\"belong\":2,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"23xmvkhkxwe4qg8\",\"name\":\"Taylor·Gardner Hickman\"},\"out_player\":{\"id\":\"4jwq2ghx9yeom0v\",\"name\":\"Moussa·Baradji\"}}]},{\"id\":\"dj2ryohjn9weq1z\",\"first\":0,\"captain\":0,\"name\":\"Dion De Neve\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/8b779b224754e1d41410efea669cfbdb.png\",\"shirt_number\":14,\"position\":\"D\",\"x\":0,\"y\":0,\"rating\":\"6.5\",\"incidents\":[{\"type\":9,\"time\":\"89\",\"minute\":89,\"addtime\":0,\"belong\":2,\"home_score\":1,\"away_score\":1,\"in_player\":{\"id\":\"dj2ryohjn9weq1z\",\"name\":\"Dion De Neve\"},\"out_player\":{\"id\":\"965mkyh3w114r1g\",\"name\":\"Ryoya Morishita\"}}]},{\"id\":\"ednm9whzxewjryo\",\"first\":0,\"captain\":0,\"name\":\"Oladapo Afolayan\",\"logo\":\"https:\\/\\/img.thesports.com\\/football\\/player\\/b9bec5935d4902dd919841656c4f356f.png\",\"shirt_number\":21,\"position\":\"F\",\"x\":0,\"y\":0,\"rating\":\"0.0\"}]}' , `create_time` = 1776048021 , `update_time` = 1776048021 [ RunTime:0.000470s ]
- SELECT * FROM `dlm_matchs_lineup` WHERE `match_id` = 5642 LIMIT 1 [ RunTime:0.008358s ]
- SELECT `name` FROM `dlm_matchs_teams` WHERE ( `tid` = 247 ) AND `dlm_matchs_teams`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000216s ]
- SELECT `name` FROM `dlm_matchs_teams` WHERE ( `tid` = 7 ) AND `dlm_matchs_teams`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000130s ]
- SELECT `name` FROM `dlm_matchs_player` WHERE `k` = 'pxwrxlhj01zvryk' LIMIT 1 [ RunTime:0.000237s ]
- SELECT k as id,`name`,short_name as name_en,`logo` FROM `dlm_matchs_player` WHERE `k` = '6ypq3nhw0xg3md7' LIMIT 1 [ RunTime:0.000204s ]
- SELECT `name` FROM `dlm_matchs_player` WHERE `k` = '8yomo4hvz0e5q0j' LIMIT 1 [ RunTime:0.000171s ]
- SELECT k as id,`name`,short_name as name_en,`logo` FROM `dlm_matchs_player` WHERE `k` = 'l5ergphvx7lr8k0' LIMIT 1 [ RunTime:0.000205s ]
- SELECT `name` FROM `dlm_matchs_player` WHERE `k` = 'k82rekhv64grepz' LIMIT 1 [ RunTime:0.000178s ]
- SELECT k as id,`name`,short_name as name_en,`logo` FROM `dlm_matchs_player` WHERE `k` = 'l7oqdeh6lnzr510' LIMIT 1 [ RunTime:0.000203s ]
- SELECT k as id,`name`,short_name as name_en,`logo` FROM `dlm_matchs_player` WHERE `k` = 'x7lm7ph0ev6m2wd' LIMIT 1 [ RunTime:0.000197s ]
- SELECT k as id,`name`,short_name as name_en,`logo` FROM `dlm_matchs_player` WHERE `k` = '965mkyh442zr1ge' LIMIT 1 [ RunTime:0.000195s ]
- SELECT k as id,`name`,short_name as name_en,`logo` FROM `dlm_matchs_player` WHERE `k` = 'zp5rzgh2vx3q82w' LIMIT 1 [ RunTime:0.000174s ]
- SELECT k as id,`name`,short_name as name_en,`logo` FROM `dlm_matchs_player` WHERE `k` = '4jwq2ghx9yeom0v' LIMIT 1 [ RunTime:0.000144s ]
- SELECT k as id,`name`,short_name as name_en,`logo` FROM `dlm_matchs_player` WHERE `k` = '965mkyh3w114r1g' LIMIT 1 [ RunTime:0.000141s ]
- SHOW FULL COLUMNS FROM `dlm_matchs_coach` [ RunTime:0.000375s ]
- SELECT * FROM `dlm_matchs_coach` WHERE `k` = '4zp5rzgh76xq82w' LIMIT 1 [ RunTime:0.000264s ]
- SELECT * FROM `dlm_matchs_coach` WHERE `k` = 'gx7lm7phoxkm2wd' LIMIT 1 [ RunTime:0.000217s ]
0.305166s
(4-3)
