SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001325s ]
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` = 18846 AND `switch` = 1 LIMIT 1 [ RunTime:0.000717s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 18846 [ RunTime:0.002346s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.001005s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('xiǎn','xiān') [ RunTime:0.000466s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.000799s ]
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 ('173','184','187','676') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.222143s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.002810s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (259557,252356,242468,236285,228261,217505,204992,204991,204990,204989,204988,204987,204986,204985,204984,204983,204982,204981,204980,204979,204978,204977,204976,204975,204974,204973,204972,204971,204970,204969,204968,204967,204966,204965,204964,204963,204962,204961,204960,204706,203933,203932,203931,203833,203643,202275,190956,190432) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.003313s ]