SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522962 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522962 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180622,175090,792588,765646,74532,750986,481449,589972,358001,258199,37204,1738,942407,1048729,418190,973260,44890,16057,325680,198269,142785,263821,785081,955331,815227,214287,114229,867666,76852,99147,773072,519254,304760,940281,456034,583678,1048365,1023406,520151,189215,936892,822289,835243,360531,500880,131205,905423,667464,276488,811617,9925,122737,730711,293975,930478,580900,464949,772862,730123,707334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522962 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522962 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]