SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001404s ]
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` = 4642 AND `switch` = 1 LIMIT 1 [ RunTime:0.002509s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 4642 [ RunTime:0.002895s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.009310s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('gū','jiā','jie') [ RunTime:0.002382s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.002166s ]
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 ('86','329','334','924','120','530','620','893','347','366','507','521') ) a WHERE ( rowindex <= 48 ) [ RunTime:1.486310s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001777s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (261002,261001,261000,260830,260314,260313,259767,259704,259473,258964,258769,258476,258473,258068,257980,257979,256211,256106,256105,256104,256103,255546,255364,255337,254828,254027,252055,252054,252053,252052,251294,250440,250270,250248,249829,249701,249551,249311,249181,249180,249164,248362,247644,245929,245888,245334) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.013178s ]