SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315880 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315880 [ RunTime:0.002478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953182,262116,916140,650343,969378,474559,1010016,995715,34142,296903,366995,258537,176029,702059,358312,584641,482850,879878,623730,830847,431099,188938,779248,271866,807067,998154,741080,590326,472853,922289,338201,330287,725913,450261,901221,696493,54573,1004765,200060,777887,842784,422150,862302,388584,218298,678636,524102,16591,465024,327911,935127,479802,938302,127082,811066,1039543,225797,597585,783362,783517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]