SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.014296s ]
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` = 9668 AND `switch` = 1 LIMIT 1 [ RunTime:0.003743s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 9668 [ RunTime:0.004671s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.008578s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('jin','jīn') [ RunTime:0.003773s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.002097s ]
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 ('121','332','557') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.131937s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.000934s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (257229,250792,250791,250790,224787,224779,224778,224768,224767,224766,221573,221348,185386,185385,181028,166563,163230,157465,155040,152591,152511,152506,150678,144561,144560,144559,144558,144557,140691,139715,133314,108748,99582,80171,78666,65952,65951,65950,61858,61841,55748,55547,52946,51540,50047,49470,41885,41884) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.001336s ]