SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031003 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031003 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340614,702241,554632,343780,167266,369902,863537,797007,635052,152290,166745,2045,108983,1018859,401568,426094,475036,42009,110329,863963,61842,827541,989530,597324,683276,261973,591201,250025,939502,827524,764950,673552,128594,502303,602289,445476,451240,692238,630149,877417,807431,577298,789295,760877,448504,504290,225663,703780,159297,318852,1029321,434643,713836,618431,922346,752804,152869,317738,103959,295067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001871s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]