SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341408 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341408 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554248,463811,925179,619872,356052,743557,177917,503483,757263,247551,697086,380607,1010150,16642,909662,319639,494762,597091,18715,654454,81347,214776,280394,200415,995894,762317,516422,677595,352698,785262,427912,432337,511519,726236,522183,735178,289970,240012,927219,317214,628443,596260,451015,815144,1003769,791562,574675,791123,573794,364110,883993,194293,83022,851116,281106,378953,877096,245541,317692,872807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]