SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255308 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255308 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349659,787440,364953,741890,267672,744380,609469,750194,860027,636030,678539,141743,762575,56286,849809,285500,748259,1019381,411155,1029367,865378,102176,555138,1045496,513627,325187,276806,229330,154152,496889,805618,657878,489575,362648,891346,894286,370975,620965,698482,874537,801562,931443,957349,152784,917025,610285,467674,308521,951850,874836,998026,24435,483222,468574,66136,414079,34258,473751,608511,1015855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]