SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516522 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516522 [ RunTime:0.001442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136148,541230,1000670,229224,447209,174250,591928,599287,554788,602103,767229,131113,568404,846977,361616,552691,155038,3135,12175,69319,330047,148374,838513,540952,406596,1003627,389094,410705,277704,68558,560574,492644,420606,693255,966526,508882,821018,629712,93070,59337,480352,883392,596130,438819,709622,893238,691068,230780,549933,120784,6344,835413,477117,897050,257397,747633,635161,821261,799860,671804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]