SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 822218 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 822218 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277299,946425,545043,55204,327572,173800,199190,612205,177601,931099,1017754,255398,1009456,746318,921428,648726,172914,649013,178505,170431,684596,564027,593320,177428,573447,537583,17110,914475,104149,744561,806936,22939,512485,464539,159517,9494,475524,607301,791349,952198,920428,505602,613073,669064,751789,18407,888219,851574,730982,583818,787813,955474,192043,671817,201043,73971,879829,575773,482949,629224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 822218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 822218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]