SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001344s ]
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` = 6709 AND `switch` = 1 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 6709 [ RunTime:0.001906s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.008700s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('qiǎn','jiān') [ RunTime:0.002807s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.001644s ]
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 ('104','211','555','126','252','612','790') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.452020s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001766s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (254504,244898,238417,231578,230934,224502,221646,221636,221595,220396,219028,217780,206393,204161,202225,195374,192159,191229,190398,188693,177671,173892,173258,169871,166677,160755,159206,159205,159204,159203,159202,159201,159200,159199,159198,159197,159196,159195,159194,159193,159192,159191,159190,159189,159188,159187,159186,159185) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.003318s ]