SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414643 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414643 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485626,193529,229365,511107,133463,824586,815732,286922,632844,686248,960095,568425,134633,352218,799571,447043,413449,602316,940605,446957,424792,107240,62626,603582,705029,21003,287156,166710,827373,38669,582858,916702,577986,678183,1031957,121933,23763,747827,419297,982775,22014,631008,859729,838778,500606,677288,771870,85227,837481,190692,881597,509085,682274,212809,635518,978893,207871,828344,606458,254691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]