SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002062s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536631 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536631 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446887,723595,601748,830023,297141,424706,597934,711304,429970,560608,33299,643633,104160,279865,440375,251523,38165,441326,582691,947644,477126,718807,452859,846483,342873,142862,595942,227082,946049,89708,544342,529057,556439,509957,978653,844904,739795,96600,607913,785518,915919,167359,757186,868348,633311,522364,147975,607594,62799,186217,767138,1040613,692919,905166,960396,486659,106130,228340,802576,123060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]