SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001332s ]
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` = 6660 AND `switch` = 1 LIMIT 1 [ RunTime:0.002711s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 6660 [ RunTime:0.003968s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.001334s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('shā','shà') [ RunTime:0.001187s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.001077s ]
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 ('300','534','646') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.103599s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001185s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (257218,256695,250573,250285,248373,248164,246106,242536,242280,240688,240147,238452,234234,230657,230652,229506,228620,226835,224557,221892,221605,219745,212821,209908,208905,205597,202838,198539,198538,198537,198116,197612,196889,193728,193716,190852,190529,186394,186393,177119,174060,172995,171889,169670,168223,168007,163813) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.004395s ]