SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001495s ]
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` = 2767 AND `switch` = 1 LIMIT 1 [ RunTime:0.001122s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 2767 [ RunTime:0.004946s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.008474s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('báo','bó','bò') [ RunTime:0.002004s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.002256s ]
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 ('142','262','474','1156','148','502','1052','1053','1090') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.338805s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001230s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (254684,253225,252131,249466,245728,243511,241996,240007,239280,238377,237565,235130,234779,232652,225466,225085,223830,221631,221193,220404,220384,220383,219244,218658,218482,218044,217579,217126,216123,214172,210376,209072,208850,208588,205159,203654,201647,201282,198071,196348,196088,192544,191388,191178,189196,188063,186569,186568) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.006790s ]