SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 918054 LIMIT 1 [ RunTime:0.001192s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 918054 [ RunTime:0.004340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426475,482228,538382,1016441,308717,328983,1004908,66648,842868,7035,584914,601514,920078,512087,718251,916284,59596,276096,993463,943511,33973,174914,552787,39703,292782,1031184,306148,955805,513826,458968,403143,512256,433706,790541,102511,792315,987701,27914,939453,987947,138665,551304,404418,925623,700163,144324,752433,221262,831818,666677,67008,236338,1005542,769258,173280,580697,810441,933165,39220,438054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 918054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 918054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]