SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142511 LIMIT 1 [ RunTime:0.000694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142511 [ RunTime:0.005010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488510,513213,186818,191273,449828,723081,1043061,112731,858049,62389,264807,703807,900375,592651,1025013,339181,812031,636538,912485,130482,553864,266538,1011880,488158,624692,509554,309221,106375,350007,589118,781000,576531,659229,520858,957454,462745,723350,413891,875183,452789,560856,113550,382898,704159,828185,1013014,788264,694733,634720,393550,521948,871138,333239,41461,53510,615944,291248,171846,665919,210630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]