vorpal-buildbot
commented
1 year ago Exceeded slow_query limit (0.6 > 0.5) in mysql: ```
SELECT
p.id,
LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS name,
p.mtgo_username,
p.tappedout_username,
p.mtggoldfish_username,
p.discord_id,
p.elo,
p.locale,
p.banned,
SUM(1) AS num_decks,
SUM(dc.wins) AS wins,
SUM(dc.losses) AS losses,
SUM(dc.draws) AS draws,
SUM(dc.wins - dc.losses) AS record,
SUM(CASE WHEN dc.wins >= 5 AND dc.losses = 0 AND d.source_id IN (SELECT id FROM source WHERE name = 'League') THEN 1 ELSE 0 END) AS perfect_runs,
SUM(CASE WHEN d.finish = 1 THEN 1 ELSE 0 END) AS tournament_wins,
SUM(CASE WHEN d.finish <= 8 THEN 1 ELSE 0 END) AS tournament_top8s,
IFNULL(ROUND((SUM(dc.wins) / NULLIF(SUM(dc.wins + dc.losses), 0)) * 100, 1), '') AS win_percent,
SUM(DISTINCT CASE WHEN d.competition_id IS NOT NULL THEN 1 ELSE 0 END) AS num_competitions
FROM
person AS p
LEFT JOIN
deck AS d ON d.person_id = p.id
LEFT JOIN
deck_cache AS dc ON d.id = dc.deck_id
WHERE
(p.mtgo_username IS NOT NULL) AND (TRUE)
GROUP BY
p.id
ORDER BY
num_decks DESC, p.name
```[] (slow_query, 0.6, mysql)
Reported on decksite by mysql-perf
Location Hash: 653b481df12c16c3744044a2b91a97ff30e5135c
Request Data
``` Request Method: HEAD Path: /matchups/?season_id=29&hero_archetype_id=&hero_person_id=8254&hero_card=Barren+Moor&enemy_archetype_id=383&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([]) Endpoint: matchups View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 51.15.164.30 Cf-Ray: 7cb5960afb2d2a34-CDG X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.67 Safari/537.36 Cf-Connecting-Ip: 51.15.164.30 Cf-Ipcountry: FR Cdn-Loop: cloudflare ```Labels: decksite
[](slow_query, 0.6, mysql)Reported on decksite by mysql-perf
Location Hash: 653b481df12c16c3744044a2b91a97ff30e5135c
Request Data
``` Request Method: GET Path: /matchups/?season_id=29&hero_archetype_id=&hero_person_id=8254&hero_card=Barren+Moor&enemy_archetype_id=383&enemy_person_id=&enemy_card= Cookies: ImmutableMultiDict([('hide_intro', 'True'), ('session', '.eJx1UNFuwjAM_Jc8M9Q2EFreBhpMQxqDwYqYpiq0Lk1J0ipNtxXEv89FAp725juf7fOdSFSCUVyDtmRoTQ0dwhMlNBmmXFaIElBCFckdiyouTBIJpEif9oO-6w0CShn1sHLIXSGLmEtAFeiH9Ts2_h8ROtrXQiZXCwWvbeZFleW2XbCc7Bbpz1ueDHbh5uW4-fBXWVZ-P68B9MgnN70tDoDOT4THMVTVFZNwLGfbucpfp64t3UaFmXp8mo4Wx9JZzVY4D7-lMFBFHENwmU-9oHXZZYwNqNO799tcmNPzHadDDKRIZbcjW2DpUqxzZQ4zf6-C3rJZiDndMRuPJwEewVRK_OYTc8C0Rdogd_m66uYFbr4i8tUhl6WRbdoBMgJuwJAz0tzsAT3qWsrzH2zdjtU.ZEv9KA.R8PD9Qh-0APgLWQ-QKGbDjraElo'), ('session', '.eJx1UctuwkAM_Jc9pygkISTcSlWoilQKhYKoqmhJnGRhH9HuBgqIf6-DBByq3jz22GOPTySpQAsqQVrSs7oGh9BMMEl6OeUGUQaCCZXdMTOp0lnCMEU6fifutL1u7Puh72HkkjuDq5RyQBbIh_kHFv5vYTIpasaz6wpcFQVkzWpGyYtU5HUChwhbqKQ2oCUVzeRM7aVVO8prsBjiJEVrW3qJsdQ2hOlgPcn375usu14sX4_Lz2hWltXuZQ4g-9Gdb9UW8OYToWkKxlwxWTzx0WosNm_Dtq3aB7EoxePzsD85Vu5sNMN--KmYBpNQtK8dRr4XN_e1wjDs-m5wrzeOhm4Qua5DNOSYKm8iKwjzKZtvhN6OokLEwfQwYWN_Hdr0aRCjCPpZ4TVf6CD-ieUHzF38Mq2NYvKGyLdDLkMTe2gaSB-oBk3ODvljpaW6AFxa1pyffwE1mKkK.ZGtz2w.DcOVAo_8Pkh2k26ngeVu8APUgrY'), ('page_size', '20'), ('deck_id', '215849'), ('views', '550')]) Endpoint: matchups View Args: {} Person: 535951279336325120 Referrer: https://pennydreadfulmagic.com/matchups/ Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 2600:4041:54ba:5000:e499:f7c0:55d9:91a1 Cf-Ray: 7cb58d59abd70fa1-EWR X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Sec-Ch-Ua: "Chromium";v="112", "Google Chrome";v="112", "Not:A-Brand";v="99" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "Windows" Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7 Sec-Fetch-Site: same-origin Sec-Fetch-Mode: navigate Sec-Fetch-User: ?1 Sec-Fetch-Dest: document Referer: https://pennydreadfulmagic.com/matchups/ Accept-Language: en-US,en;q=0.9 Cookie: hide_intro=True; session=.eJx1UNFuwjAM_Jc8M9Q2EFreBhpMQxqDwYqYpiq0Lk1J0ipNtxXEv89FAp725juf7fOdSFSCUVyDtmRoTQ0dwhMlNBmmXFaIElBCFckdiyouTBIJpEif9oO-6w0CShn1sHLIXSGLmEtAFeiH9Ts2_h8ROtrXQiZXCwWvbeZFleW2XbCc7Bbpz1ueDHbh5uW4-fBXWVZ-P68B9MgnN70tDoDOT4THMVTVFZNwLGfbucpfp64t3UaFmXp8mo4Wx9JZzVY4D7-lMFBFHENwmU-9oHXZZYwNqNO799tcmNPzHadDDKRIZbcjW2DpUqxzZQ4zf6-C3rJZiDndMRuPJwEewVRK_OYTc8C0Rdogd_m66uYFbr4i8tUhl6WRbdoBMgJuwJAz0tzsAT3qWsrzH2zdjtU.ZEv9KA.R8PD9Qh-0APgLWQ-QKGbDjraElo; page_size=20; deck_id=215849; views=550; session=.eJx1UctuwkAM_Jc9pygkISTcSlWoilQKhYKoqmhJnGRhH9HuBgqIf6-DBByq3jz22GOPTySpQAsqQVrSs7oGh9BMMEl6OeUGUQaCCZXdMTOp0lnCMEU6fifutL1u7Puh72HkkjuDq5RyQBbIh_kHFv5vYTIpasaz6wpcFQVkzWpGyYtU5HUChwhbqKQ2oCUVzeRM7aVVO8prsBjiJEVrW3qJsdQ2hOlgPcn375usu14sX4_Lz2hWltXuZQ4g-9Gdb9UW8OYToWkKxlwxWTzx0WosNm_Dtq3aB7EoxePzsD85Vu5sNMN--KmYBpNQtK8dRr4XN_e1wjDs-m5wrzeOhm4Qua5DNOSYKm8iKwjzKZtvhN6OokLEwfQwYWN_Hdr0aRCjCPpZ4TVf6CD-ieUHzF38Mq2NYvKGyLdDLkMTe2gaSB-oBk3ODvljpaW6AFxa1pyffwE1mKkK.ZGtz2w.DcOVAo_8Pkh2k26ngeVu8APUgrY Priority: u=0, i Cf-Connecting-Ip: 2600:4041:54ba:5000:e499:f7c0:55d9:91a1 Cf-Ipcountry: US Cdn-Loop: cloudflare ```