SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431830 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431830 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618553,196075,1043232,507204,969303,463942,1048861,870072,430404,670655,107974,858948,309664,528920,547601,66472,174007,243839,197806,40789,745173,48408,19829,304339,588670,437915,256532,470784,146360,836860,402174,472151,75232,341036,966118,1020569,657782,564628,320019,952391,536184,181224,754408,58664,571942,371658,503852,434001,671617,105931,383942,378122,965078,219537,925494,72959,849029,778690,856656,640437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001016s ]