SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.002177s ]
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` = 5282 AND `switch` = 1 LIMIT 1 [ RunTime:0.001622s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 5282 [ RunTime:0.002572s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.003586s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('máo','māo') [ RunTime:0.002092s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.001685s ]
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 ('197','448','685','1073') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.210943s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.002862s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (260584,256388,254537,252001,246520,237032,235481,221489,217543,199326,193408,172288,165074,158716,147891,130056,118260,116929,103113,103112,96096,96095,96094,96093,96092,96091,96090,96089,96088,96087,96086,96085,96084,96083,96082,96081,96080,96079,96078,96077,96076,96075,96074,96073,96072,96071,96070,96069) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.009236s ]