SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487098 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487098 [ RunTime:0.002669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786935,662848,105243,384211,379407,184136,528893,434468,708878,65536,310546,750421,1027658,267302,451121,514295,583080,885446,500381,799476,262831,80653,103772,114513,498351,766387,775405,250962,629944,622400,435312,916654,377094,543071,443555,789595,1037303,761413,38084,832713,146241,272811,145161,499545,827840,963645,350347,574672,228377,455959,780667,1020795,574551,661731,41083,509199,92211,665215,679527,930752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]