SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001391s ]
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` = 12857 AND `switch` = 1 LIMIT 1 [ RunTime:0.001184s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 12857 [ RunTime:0.001892s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.001113s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('yào','yuè') [ RunTime:0.002094s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.001353s ]
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 ('23','406','696','1062','317','422','874') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.077737s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001178s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (254466,254084,241933,236709,229857,227413,224296,224196,219910,216139,214007,212440,211967,207953,205520,197933,189752,185397,182496,182495,182494,182493,182492,181836,174452,169212,165471,156560,154637,153543,148112,137333,126129,121462,115614,110906,110795,110573,109732,109704,103771,97947,88168,88035,80424,74482,74220,66287) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.010134s ]