SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405412 LIMIT 1 [ RunTime:0.000708s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405412 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931335,209299,409117,789276,465173,750369,328255,462499,617119,284840,378686,600621,634427,1033086,370527,266548,517644,141569,696285,779063,936575,859464,331670,64727,1034308,463871,976510,338662,971596,781036,682635,808401,588878,497449,331979,735787,978146,706016,693432,524287,426643,311065,1021923,864069,1001545,776635,256488,145562,731949,281160,589520,529287,336312,300278,826905,786655,791594,619403,527191,664054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]