SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.002538s ]
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` = 1801 AND `switch` = 1 LIMIT 1 [ RunTime:0.008576s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 1801 [ RunTime:0.007855s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.001620s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('qīn','qìng') [ RunTime:0.006029s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.003124s ]
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 ('69','748','1106','1199','397','626','700','821') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.469929s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001575s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (260849,257808,257807,256836,253433,252438,252437,251625,250261,250260,249845,248722,247291,246172,246171,246170,246169,244823,244602,243866,243562,242957,242272,242151,238699,238208,238178,237049,235645,234915,234479,230253,230252,230164,229480,220987,220354,215412,215026,214605,214390,214094,213846,213304,212884,212094,210755,210576) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.002786s ]