SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001963s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428823 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428823 [ RunTime:0.002590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003081,963704,228321,224420,720282,233926,884739,883122,451493,279463,230700,907986,175501,656470,1019687,139327,20628,696194,119794,633808,252519,155180,466436,714630,382294,672682,482115,742785,342926,315360,757339,247832,545893,1036822,280106,200726,936095,517979,943489,385374,397533,96989,197130,511864,435517,232984,838399,274288,181773,543652,774010,5663,851338,938034,758243,184090,814697,810066,331436,457399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]