SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013071 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013071 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171010,10499,330911,923143,636727,767382,137452,980556,969616,537954,222527,235065,901102,305093,631105,1037327,427430,728783,924339,162214,575690,392213,673224,124108,883048,880704,34855,197921,481977,605125,1030684,993596,1017402,317415,541021,747213,1002550,963174,935694,688151,455035,931635,731171,574172,940356,589088,303368,875152,737009,493800,45332,584831,619851,46034,743223,164661,536118,561981,173346,620142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]