SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198498 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198498 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513754,720977,193043,119371,508845,451873,411150,638907,753083,282175,116826,381072,435647,347400,849140,372527,949297,847490,922678,703007,73364,863922,601369,233616,81593,146273,256007,462196,821416,374113,197204,915687,932211,761317,466922,187542,758287,378611,183361,581436,66445,911247,179904,571541,390034,68987,534833,483418,60432,918946,52021,945471,747623,393040,664872,937837,308435,572992,662178,453909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]