SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412930 LIMIT 1 [ RunTime:0.000692s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412930 [ RunTime:0.004552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24462,994645,306013,348527,329299,944443,616721,668781,5664,518463,393219,493569,851409,511194,244247,850608,190140,282262,19181,837428,302129,945870,317915,729880,17179,226283,1032228,856653,813578,544350,794938,170449,1022301,988989,588057,226664,847567,155455,180461,756408,674318,606897,852349,340166,318294,807440,216314,115632,1371,923594,754287,898910,348360,94000,27581,672884,610576,936406,477334,218916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]