SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578972 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578972 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503388,875647,559911,108444,842375,201104,52309,966682,629392,606014,542616,43241,493205,103360,851798,459597,134594,849067,892823,916100,36960,555134,1013587,559434,176476,199728,783605,685065,14797,675311,318667,791033,17016,176225,366096,161347,831571,81128,164419,388906,279479,871827,532362,621876,94732,644653,681094,639029,740944,427298,676527,583255,518273,405670,250595,541285,767517,673270,223470,694293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]