SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001339s ]
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` = 5832 AND `switch` = 1 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 5832 [ RunTime:0.002799s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.001073s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('yìn','yǐn') [ RunTime:0.004147s ]
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 ('27','420','590','806') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.191293s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001199s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (257037,256861,252259,252258,251828,251101,250640,247972,244885,244549,242569,241094,235607,235318,231842,230871,230812,230634,229993,225963,225340,225110,219070,216376,214785,206220,206033,205510,202619,202617,199869,195581,195580,195579,195578,195577,195576,195575,195574,195573,195572,195571,195570,195569,195568,195567,195566,195565) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.001266s ]