SHOW FULL COLUMNS FROM `tool_hanzi` [ RunTime:0.001409s ]
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` = 99 AND `switch` = 1 LIMIT 1 [ RunTime:0.005012s ]
UPDATE `tool_hanzi` SET `views` = `views` + 1 WHERE `id` = 99 [ RunTime:0.014981s ]
SHOW FULL COLUMNS FROM `tool_pinyin_sort` [ RunTime:0.047329s ]
SELECT `id`,`pinyin` FROM `tool_pinyin_sort` WHERE `pinyin` IN ('lí','lì') [ RunTime:0.016285s ]
SHOW FULL COLUMNS FROM `tool_pinyin_zc` [ RunTime:0.006513s ]
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 ('50','100','354','795') ) a WHERE ( rowindex <= 48 ) [ RunTime:0.314868s ]
SHOW FULL COLUMNS FROM `tool_zc` [ RunTime:0.001097s ]
SELECT `id`,`zc` FROM `tool_zc` WHERE `id` IN (258569,256516,255970,248884,246781,244130,242420,239121,238857,238775,237424,237423,237422,235972,234517,233706,231627,228216,221921,220956,220392,219504,219397,218527,216889,216570,212381,211381,210730,209722,208798,207117,204133,203563,202356,202007,201607,201564,201481,200828,199947,197800,195929,194213,192900,192217,190751,190375) AND `switch` = 1 ORDER BY `id` DESC [ RunTime:0.003161s ]