SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682723 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682723 [ RunTime:0.002235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035659,275642,922806,389118,634430,424828,772075,780060,742515,396833,49192,423259,13950,550445,1000432,620770,471519,554347,502384,475999,1037640,528988,602845,73251,866086,912976,966875,442485,503137,676427,584683,65039,160157,1016790,436036,537093,453563,80355,730992,295037,502378,399358,424895,784725,947495,538821,639772,475821,763033,845864,542679,535827,8180,884096,512196,455249,770225,502149,327818,154452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000860s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]