SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490090 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490090 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682827,710423,621660,1022384,351639,91233,166879,597595,486180,593024,486112,511283,336991,608513,229959,238200,554986,152973,561628,23575,792242,360221,750640,383723,83354,153836,735163,1012803,197405,630525,867170,445988,605364,621958,67119,319915,602653,574371,839639,816977,212163,197227,78323,744721,896008,946981,678896,586117,80082,674158,1040053,510786,931694,955135,64630,177249,39723,685920,460393,581389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]