SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499151 LIMIT 1 [ RunTime:0.001101s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499151 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805136,324843,957428,977136,512706,688074,446011,406411,641831,747892,711877,71258,247366,463906,237513,311426,742640,451049,111429,497213,765792,74837,159711,8107,1022612,40369,624351,800116,266988,501119,969826,372855,369180,608964,354785,1033138,930715,928919,175631,97569,578882,353086,629295,140518,33110,127302,581407,902136,585597,134493,755509,576769,778806,330096,844024,64802,866520,947247,739141,195970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]