SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401792 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401792 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249326,651533,387619,537351,911656,309072,429462,744752,503324,148010,319634,328220,412792,607664,688798,442809,469260,635567,596920,959584,714114,844469,484887,538996,500721,139069,850357,142319,716459,882595,108805,139810,194284,421923,1048269,298853,855518,33314,352745,99589,1019344,963789,444647,476758,419391,380654,259300,30443,667803,207598,879434,462633,955091,776173,460550,1029293,113021,541104,91800,112471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401792 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401792 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004567s ]