SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548861 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548861 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929888,594358,355959,721376,695470,1033945,755174,871104,80902,167794,169547,193853,395797,230584,185651,342960,811122,1033481,57781,847806,912840,275831,474436,493607,674767,906478,895377,290022,604705,904237,370870,416055,472886,1047870,180421,928948,475742,692815,16783,1026659,603741,386698,45198,363060,559415,523884,168135,591034,209847,304948,567701,584082,252081,377654,95559,890249,760391,677007,442458,9718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548861 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548861 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]