SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401714 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401714 [ RunTime:0.004138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334878,795617,580147,303680,364181,447877,160261,248193,19654,215209,394782,207955,878625,623045,299864,1041349,147702,1028633,16735,227897,990747,804686,568468,370438,239203,729014,395224,935411,245060,716985,749152,581019,256165,709611,225123,234998,284618,496275,476755,568397,988810,621131,629022,137012,466159,536019,255804,398571,864383,190541,996615,336578,613193,536003,843491,258128,557565,459913,557589,808367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]