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` = 401151 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401151 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724371,150319,848827,212093,907531,96568,130683,754863,267716,274024,95867,974957,669054,544450,180712,568142,342721,710701,127228,774383,570867,773419,167762,272058,803612,344882,456479,761816,365048,969077,691949,952471,591983,706585,653402,28827,569910,214045,918315,230721,215097,598769,181444,277606,1037458,1003054,917783,725393,769950,956765,183370,246499,484813,920897,538253,457010,725961,376405,56025,95507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]