SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001301s ]
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` = 10003 AND `switch` = 1 LIMIT 1 [ RunTime:0.000640s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 10003 [ RunTime:0.001968s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.001161s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('jiào','xiào') [ RunTime:0.000437s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.001163s ]
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 ('164','249','556','914','231','232','327','1200') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.270967s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001273s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (260697,255134,254371,252656,252583,249184,249099,248970,248440,242698,242688,240449,239672,239532,234106,234027,232005,228175,227243,221258,217517,216945,216279,214001,208791,208724,207955,207809,206601,206600,206599,206598,206597,206596,206595,206594,206593,206592,206591,206590,206589,206588,206587,206586,206585,206584,206583,206582,74837) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.003537s ]