SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001644s ]
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` = 2268 AND `switch` = 1 LIMIT 1 [ RunTime:0.001306s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 2268 [ RunTime:0.004276s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.032698s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('suō','shā') [ RunTime:0.003785s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.004243s ]
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 ('300','534','646','255','256') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.499418s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001196s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (242359,202041,187654,168390,168389,162871,148183,148182,148181,148180,148179,148178,148177,148176,139252,133160,132561,132557,118587,107173,100184,94581,93859,63464,29040,6404) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.003915s ]