SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559087 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559087 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034333,170356,703389,573088,227619,765689,778364,94763,35327,55423,443536,369098,141316,233059,120742,244270,745160,645778,1016818,500305,727462,533606,336565,393065,807559,964207,933855,82717,324156,410207,878052,556180,947847,498223,584421,270908,1002985,1048242,438069,913851,215587,455739,850666,827705,584777,923675,375718,270230,233961,209850,510258,20241,649261,476364,121673,384148,710784,684157,820908,968856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]