SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292083 LIMIT 1 [ RunTime:0.000275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292083 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448638,1024958,955226,571085,377389,379428,972742,689018,743725,950129,4692,424949,562012,674813,640163,124256,122850,893234,45069,458102,1023718,837587,369316,864412,215087,313217,810541,439073,900041,261140,279449,546298,479533,305744,297105,735800,58568,436989,721732,32427,111654,256535,83745,1039859,268997,846912,330261,598015,468680,1023427,101358,379124,114736,397144,46839,969648,601227,492214,882143,849870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]