SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.003741s ]
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` = 6068 AND `switch` = 1 LIMIT 1 [ RunTime:0.003493s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 6068 [ RunTime:0.005999s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.006964s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('shè','shí') [ RunTime:0.007034s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.002238s ]
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 ('368','789','854','1268','73','129','199','399') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.263770s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.002988s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (257734,251639,248738,243792,242450,224450,222352,208098,207382,193174,193168,180124,170408,162404,161184,153830,152643,148021,143005,143004,139588,134666,134665,134664,134663,134662,134661,134660,134659,134658,134657,134656,134655,134654,134653,134652,134651,134650,134649,134648,134647,134646,134645,134644,134643,134642,134641,134640) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.010303s ]