SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426203 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426203 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482661,437301,1036074,318072,769964,557584,715864,36657,782983,686948,657645,1013239,678049,179646,219646,481739,297342,522284,118873,807164,674014,907739,201497,690251,160068,120281,611726,55052,576275,40944,649367,85634,373225,818527,138664,392164,513727,1020908,969187,508510,435330,593248,967677,399607,436831,291176,624668,631620,485083,112204,295302,1042662,690469,319558,891415,642311,854311,416533,329847,696041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]