SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53835 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53835 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033926,655027,835272,223360,448063,824284,471437,240511,944754,680281,427369,21809,759276,378825,731853,483761,243912,883560,482855,117766,219897,607486,230291,505409,157175,876727,743810,570420,941306,2739,496399,529775,173565,21190,210505,955335,810491,554690,63619,408296,596906,539442,336258,661488,36269,122461,160364,640987,96012,859683,349444,742268,57599,607059,266018,570359,858923,370855,974746,399534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53835 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53835 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]