SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.002246s ]
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` = 6398 AND `switch` = 1 LIMIT 1 [ RunTime:0.000737s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 6398 [ RunTime:0.002926s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.001257s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('piě','piē') [ RunTime:0.000564s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.000977s ]
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 ('455','1228','1229') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.117616s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001191s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (255761,193731,175247,147802,143593,143592,143591,143590,143589,128451,113875,113554,105046,98896,88871,83854,83853,83852,83851,83850,83849,83848,83847,83846,83845,83844,83843,83842,83841,83840,83839,83838,83837,83836,83835,83834,83833,83832,83831,83830,83829,83828,83827,82282,69150,65548,55965,55964) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.001093s ]