SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467817 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467817 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449415,288689,120130,766737,382673,409890,45033,318882,294826,629576,945887,1012784,721053,606399,615313,975959,154855,750371,222113,690883,452245,686616,745798,448755,808340,334800,836097,874625,314324,181094,479227,460466,124109,480074,161551,731697,534225,175439,584482,732995,780099,1021788,134760,251194,227943,977873,683115,834246,719126,671257,304619,202852,830077,7388,949005,823441,154375,908395,81400,648220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]