SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001747s ]
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` = 17587 AND `switch` = 1 LIMIT 1 [ RunTime:0.005387s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 17587 [ RunTime:0.001716s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.001149s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('qù','cù') [ RunTime:0.013303s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.001521s ]
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 ('260','379','1120','71','254','701','850') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.259170s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001159s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (260251,258789,257930,253838,253769,253768,253029,252630,252310,249758,247295,242102,241667,237856,234738,233485,231210,230935,227304,220643,219439,218956,215876,215123,212891,212866,212239,211328,211008,209791,209401,208194,203583,202235,202033,194919,194875,194874,193544,192255,185130,182352,181118,179269,178956,178359,172949,165892) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.001376s ]