SET SESSION group_concat_max_len=1024000; [ RunTime:0.000331s ]
SHOW FULL COLUMNS FROM `buy` [ RunTime:0.000967s ]
SELECT group_concat(a.gpid) gpids, a.type, a.day, a.diff, a.date FROM `buy` `a` LEFT JOIN `gpdata` `l` ON `l`.`gpid`=a.gpid and a.date=l.date WHERE `a`.`date` = '2026-11-06' AND `l`.`open` > '0' GROUP BY `a`.`type` [ RunTime:0.071168s ]
SHOW FULL COLUMNS FROM `gpdata` [ RunTime:0.000965s ]
SELECT `date` FROM `gpdata` GROUP BY `date` ORDER BY `date` DESC LIMIT 0,10 [ RunTime:0.324143s ]