SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450514 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450514 [ RunTime:0.002331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8573,179346,179203,708964,513731,1037824,922544,522643,986277,68699,952312,1014550,506821,425180,258438,59036,893760,980542,514763,694308,1027356,936696,909809,628083,894011,56266,560433,921596,571178,974873,452677,373949,784846,782073,23286,944935,989871,183674,222759,622936,194964,927659,147298,29492,754979,697789,592978,332128,578670,237241,433509,20721,230924,912902,225388,967145,291857,292586,742891,82503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]