SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001815s ]
SELECT `id`,`image`,`smallimage`,`zi`,`fantizi`,`py`,`pinyin`,`zy`,`wuxing`,`wubi`,`bushou`,`jg`,`bihua`,`fantibihua`,`unicode`,`zm`,`cj`,`bishun`,`bishunm`,`xiefa`,`ziyi`,`xiangjie`,`views`,`pv`,`switch`,`updatetime`,`createtime`,`duoyinzi` FROM `tool_hanzi` WHERE `id` = 4723 AND `switch` = 1 LIMIT 1 [ RunTime:0.010528s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 4723 [ RunTime:0.007414s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.002406s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('hào','hǎo') [ RunTime:0.008538s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.001218s ]
SELECT * FROM ( SELECT u.pinyin, u.cid,row_number() over(partition by u.pinyin order by u.id desc) as rowindex FROM `tool_pinyin_zc` `u` WHERE `u`.`title` = '好' AND `u`.`pinyin` IN ('343','538','544','1155') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.299267s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001528s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (260983,260982,260294,259107,258031,257903,256285,255557,253715,252895,252625,250896,248747,248553,247626,246728,246198,243696,239703,239296,238513,237087,236560,234919,234617,234616,232805,230252,230073,229135,228853,228200,225848,221080,220405,220388,219791,217145,216604,213484,211324,211205,210963,208395,207479,205263,204937,204024,225849) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.001161s ]