SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802051 LIMIT 1 [ RunTime:0.000564s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802051 [ RunTime:0.002730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273705,32301,583083,393428,1040677,105524,831302,32115,542475,988248,249618,934884,985055,525782,687813,93795,465477,1000969,75910,560892,275592,436879,415172,78254,614462,326638,215624,231088,419471,955360,674449,686518,21354,531158,910541,129142,225420,494330,976972,20340,551319,765944,766473,81176,942968,816815,866301,764018,826745,599164,786099,907293,747939,214916,935129,59042,242124,704388,350272,368410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000796s ]