SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412563 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412563 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520436,196681,610324,687378,288721,518458,518048,935116,827756,611769,619677,150051,745457,439026,757264,863462,949509,955034,268536,764290,138021,552627,965304,94483,744231,962129,833286,910027,145419,699155,164966,595782,637846,591690,362122,200648,426727,786070,725784,512542,202450,765495,527103,464034,157883,595830,415261,676319,673557,703835,823986,1030023,236634,732335,784175,719176,78141,704357,720598,263343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]