SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550441 LIMIT 1 [ RunTime:0.001150s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550441 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698596,172819,727109,503560,222448,19483,189618,1027578,297270,128590,689602,218823,96948,157966,1009243,902484,348834,605574,823603,6162,1035182,649196,175513,946147,874406,831380,642114,707729,382148,674046,3735,586190,356485,699877,72523,791732,430108,145066,242720,24136,771411,588381,738556,194968,267612,642148,893559,127343,703078,769199,159167,756864,1010375,268847,800947,129373,407827,937882,617112,283266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]