SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432366 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432366 [ RunTime:0.002638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517888,574388,434660,809516,672514,46968,745178,726813,22219,429550,469813,575526,893154,785536,867975,573316,20550,842524,183284,61756,7231,44157,66464,658476,596882,794386,3102,197880,1048177,836578,300417,1016518,368586,105934,899114,420232,388005,14924,485768,962801,499887,270950,684509,117007,707232,605472,304772,389179,533279,114386,932678,99509,707661,190255,678498,932237,239570,944554,187142,427942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]