SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468801 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468801 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180978,94119,589096,146343,162876,485882,866745,567061,792575,606524,590913,310895,923992,708393,855564,989040,750103,180662,186282,960804,582110,452333,854779,433351,629474,978974,518866,227887,46194,128145,356913,1024538,216626,204761,958573,533303,439668,40031,675537,808865,827312,810472,623676,206851,190063,589963,138023,428683,659931,1043237,433425,327465,501278,789513,845903,558833,450350,173375,373034,206521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]