SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002475s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481884 LIMIT 1 [ RunTime:0.001529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481884 [ RunTime:0.005521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888242,845669,614937,1014190,388622,976032,187182,1014801,789661,1035128,971795,601179,669539,811101,339028,472527,468536,428669,852468,684758,421416,540068,69533,197040,422432,539415,821948,697241,432002,644197,662753,442721,847553,885669,518266,333951,1018667,346180,899066,29550,757909,491699,527328,672986,247023,406624,376035,619958,1033935,268020,448996,752322,995738,399268,829683,989303,1003235,319713,685060,993441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]