SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001969s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809591 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809591 [ RunTime:0.002537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231804,260650,60478,902929,315387,215877,496898,40374,331512,139154,170249,1030888,904476,144805,116757,846928,274083,423233,915110,520050,852794,760668,114019,1018987,79204,282852,643059,644018,990185,546946,98759,125597,493474,374223,487798,1027629,734899,145661,913967,728127,750253,936388,687000,92805,77393,36890,828121,26414,617748,178585,540618,936344,1022624,159528,448172,884865,463845,1538,496882,824199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]