SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50204 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50204 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (860663,936275,250288,851798,821408,516223,935428,963994,922789,96013,652603,485143,123924,947450,413316,205467,744943,963077,967382,481638,698979,918965,34091,248759,739457,739303,443053,315045,1025816,601430,518803,778476,242496,265613,861464,258203,728082,972996,404901,692007,469503,191122,571755,555559,520754,240761,904968,580201,515226,732220,1028711,838377,741049,790525,472600,928059,716202,872509,966101,174128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000878s ]