SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510814 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510814 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555483,718854,679065,433868,170747,181425,127347,489599,393436,775793,22948,962143,339869,55729,207210,697738,305029,917862,56427,203007,936360,680617,899438,119109,542271,972032,287801,19105,432533,600609,118659,831574,372186,860775,505579,954926,14729,402795,732784,932009,383854,441414,36815,625647,46129,620700,211010,934961,697213,62512,81954,864081,368244,248722,464606,6271,524470,584818,117122,983052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]