SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.002592s ]
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` = 6135 AND `switch` = 1 LIMIT 1 [ RunTime:0.000629s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 6135 [ RunTime:0.001501s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.001071s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` = 'zhèn' [ RunTime:0.000524s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.000913s ]
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 ('363','457','731') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.080137s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001304s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (256879,244482,242788,231573,229632,228507,228506,228505,228504,228503,228502,228501,228500,228499,228498,228497,228496,228495,228494,228493,228492,228491,228490,228489,228488,228487,228486,228485,228484,228483,228482,228481,228480,228479,228478,228477,228476,228475,228474,228473,228472,228471,228470,228469,228468) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.001444s ]