SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.007906s ]
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` = 8980 AND `switch` = 1 LIMIT 1 [ RunTime:0.009160s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 8980 [ RunTime:0.003704s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.015214s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('shóu','shú') [ RunTime:0.006521s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.005110s ]
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 ('130','563','919','11','226','702','877') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.483985s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.004938s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (258778,257828,256658,256575,251042,249323,242598,222571,221668,219048,216924,215931,214924,214731,212156,210774,207522,207476,205457,203885,203589,203478,202942,202888,199982,199520,197912,195550,195386,190756,189730,185188,183176,174204,174098,173037,173036,171772,171003,170138,166228,162781,162547,162310,162309,161229,158837,147528) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.016958s ]