SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 298049 LIMIT 1 [ RunTime:0.000918s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 298049 [ RunTime:0.003101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381182,484081,906599,152067,535176,784381,1006170,47847,783181,626929,185259,581862,740016,22986,1025543,334773,837394,1031513,433678,620147,87452,183179,631842,513610,978287,203267,491254,827576,656203,725887,483572,268392,280049,738013,702356,558772,244041,71434,985887,139963,938049,882498,654836,71300,562505,866177,263097,336552,351457,301130,326789,141475,263727,123863,574047,284155,553703,816934,293249,618557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 298049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 298049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]