SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002622s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104283 LIMIT 1 [ RunTime:0.001377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104283 [ RunTime:0.002785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935915,101482,257528,1012503,942573,27556,782681,716401,834930,223093,48694,471542,1048852,1022258,106359,279581,66248,1000463,144061,479518,398347,446463,492127,822996,549416,756661,137890,614486,218212,531833,710624,213599,534737,33810,112819,909230,119382,491609,278787,1043422,384602,1000741,24118,6711,676087,805991,743174,554454,585538,936939,878224,534312,162859,897940,682810,492632,915439,98033,860162,546946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]