SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001404s ]
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` = 1102 AND `switch` = 1 LIMIT 1 [ RunTime:0.001251s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 1102 [ RunTime:0.002271s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.000976s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('líng','lìng','lǐng') [ RunTime:0.000461s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.000817s ]
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 ('168','485','800','1225') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.327918s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001237s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (260684,258744,258103,258078,252278,251306,250861,249998,249848,249837,248954,247673,245318,245009,243716,242941,242207,242206,242205,239895,239854,239565,236821,236613,236183,235815,235451,235027,232917,231374,230915,230140,230016,229357,229274,228015,226684,225659,225505,223703,221346,220965,219507,218691,214681,211237,210190,208008) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.004035s ]