SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.006424s ]
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` = 3920 AND `switch` = 1 LIMIT 1 [ RunTime:0.001199s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 3920 [ RunTime:0.003698s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.009718s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('chà','zhà') [ RunTime:0.003587s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.002144s ]
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 ('51','203','968','1031','36','235','912','1137') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.128713s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001263s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (257160,256698,256697,256696,256695,256694,256693,256692,256691,256690,248268,236338,236336,236325,227403,227402,227401,227400,223629,221158,221157,190619,188743,177136,153717,133406,133056,133055,127549,115967,115965,110910,88820,87030,81944,69234,60986,47595,40843,38357) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.002941s ]