SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807593 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807593 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507373,618543,470696,450225,159931,783360,964487,164362,544806,244410,933086,146453,74578,865881,261702,398027,469745,54395,513501,626110,388909,790866,947212,10902,724344,998260,802231,945917,146051,99090,670418,470484,788250,699008,819526,952096,435160,912315,549491,202317,447873,711765,333792,226584,736971,887733,414939,589179,354800,604529,1032784,723360,127281,142747,1016383,637858,300740,228266,410603,574953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]