SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001341s ]
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` = 973 AND `switch` = 1 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 973 [ RunTime:0.003166s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.001093s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('chú','zhù') [ RunTime:0.000529s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.002865s ]
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 ('45','70','579','757','42','43','585','589') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.140695s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001273s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (260219,255894,255052,249779,249778,249777,249776,249775,249774,249773,249772,249771,249770,249769,249768,249767,249766,249765,249764,249763,249762,249761,249760,249759,249758,249757,249756,249755,249754,249753,249752,249751,249750,249749,249748,249747,249746,249745,249744,249743,249742,249741,249740,249739,249738,249737,249736,249735) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.001757s ]