SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509189 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509189 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532638,84658,296350,117972,71299,350561,857665,185911,107267,198554,584681,190280,19620,933180,216688,1008743,810185,189321,48592,764845,714571,609844,836576,1001365,354228,470041,843676,153810,937543,505401,592500,654507,795569,191838,466304,442409,844677,709085,24322,848940,282129,581015,749241,346366,274305,218208,502295,884610,202766,1019643,530937,795870,360814,667275,297458,698140,359882,115833,232194,567879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]