SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.002419s ]
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` = 9128 AND `switch` = 1 LIMIT 1 [ RunTime:0.008887s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 9128 [ RunTime:0.003510s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.002222s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('máo','mào') [ RunTime:0.000865s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.001116s ]
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.170930s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001189s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (243270,240039,233982,232351,202381,190511,180282,179857,167965,136246,128376,126719,126718,126717,126716,126715,126714,126713,126712,126711,126710,126709,126708,126707,126706,126705,126704,126703,126702,126701,126700,126699,126698,126697,126696,126695,126694,126693,124944,112130,87085,72958,57318,51289,48091,34533,18594,11484) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.005482s ]