SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.003049s ]
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` = 7729 AND `switch` = 1 LIMIT 1 [ RunTime:0.002224s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 7729 [ RunTime:0.008358s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.002695s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('jī','qī') [ RunTime:0.007637s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.001699s ]
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 ('161','210','355','906','157','176','396','829') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.345207s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001463s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (260626,257569,257568,255114,254301,251580,250483,250458,244203,242402,230708,229249,221334,203549,180664,175971,173477,172678,170133,170132,168134,153361,139238,138042,132988,127366,118263,101740,90162,65921,65230,50270,49143,3394,2230,457) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.009888s ]