SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043220 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043220 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314326,1014768,966268,321784,90130,768384,959004,105409,535541,591567,240180,851814,416752,243524,430831,457488,167009,752814,294531,349656,626509,550469,844232,156926,442688,613134,94748,899128,153236,424535,306308,60697,54852,130096,906748,961790,742057,303811,580499,466474,668988,894369,430983,258150,276344,471756,395164,474309,903512,605615,558732,966375,94516,927589,411532,439241,946116,559048,511012,710969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]