SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103576 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103576 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (244240,515791,995742,698761,502442,988837,796862,370953,877776,107626,313080,1032760,167426,846434,42081,746793,767934,937383,241927,931917,813757,244166,695776,916933,839914,463875,188704,262864,454895,437001,905267,3831,385123,1017683,786522,813139,719497,1025587,984396,380229,541745,966228,396339,222002,678379,241036,938192,87289,163832,724639,402618,885585,641045,620317,499109,275866,785852,238964,91182,874810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]