SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414618 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414618 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270562,183937,746656,388062,786949,94691,563164,340686,413401,175378,1047812,379392,440391,394704,778500,437715,304022,839892,301524,609229,1044957,606668,926010,491377,233266,443926,263503,336462,739762,1034553,96460,986901,158789,193281,769256,173695,172102,929881,228317,839179,761499,770289,44126,598501,966498,48771,949990,120273,10987,365900,797864,937764,124671,45628,944829,1014124,262522,757133,113156,727683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]