SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405201 LIMIT 1 [ RunTime:0.000754s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405201 [ RunTime:0.003013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939237,306337,586140,719309,773813,600407,512663,357307,224204,937154,952602,17550,208143,322599,887898,554786,425472,438958,6718,847016,927847,334694,566652,223308,539067,614850,72301,839122,1046803,761962,1007176,244676,675394,1022156,125844,240325,134979,530587,20594,375244,297167,1015617,57355,933834,975057,487718,921947,487493,971916,621348,52516,993412,365912,802703,504855,689143,361726,719501,551147,377180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]