SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200323 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200323 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649574,278355,313081,1113,602889,713127,274659,537324,376952,367908,515069,924832,799707,947614,410306,10094,44854,235163,890459,821647,163692,772333,879839,368571,327731,23482,380254,432201,578442,586628,1022745,1037041,973555,617323,83227,578910,611226,209998,167433,249931,737600,862551,368445,237360,613494,69858,787365,358040,648523,19157,971734,174988,488293,281261,165160,550422,742690,76992,160803,821537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]