SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804688 LIMIT 1 [ RunTime:0.001983s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804688 [ RunTime:0.003223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184185,483538,435936,99559,887,121172,103070,584836,472561,365962,822728,921714,795575,181839,692205,974883,739083,1020202,370030,229039,141023,547013,950270,1039081,326196,522909,13320,432405,815677,2525,612081,670795,479961,437941,150659,535520,22483,132219,75518,949716,709985,91171,23937,214708,122350,470331,218330,750564,530312,151840,766095,798853,555051,670076,769999,82871,703825,489456,555346,809691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]