SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48474 LIMIT 1 [ RunTime:0.001273s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48474 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345536,524145,1016254,390425,806809,515044,953510,806816,17866,307490,490860,267973,1020824,742820,1043981,819289,625659,457630,711996,303752,993759,765270,718866,247798,94560,264450,72442,242555,615474,279203,485848,846651,126101,303850,487241,1012749,875666,618136,881315,868540,117187,112759,607538,470597,380382,476829,216889,533419,364018,399354,808178,933524,581258,419049,134369,765041,194463,605351,995016,775441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]